This page (revision-4) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by rforbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 1 KB rforbes to previous
3 26-Nov-2021 10:22 1 KB rforbes to previous | to last
2 26-Nov-2021 10:22 1 KB rforbes to previous | to last
1 26-Nov-2021 10:22 1 KB rforbes to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 16 changed 4 lines
|{{*err: bad table name*}} |When there is no table found in [IMTD] with the name, or alias provided
|{{*err: bad column name*}} |When there is no column name found in [IMCD] with that name, for the table provided.
|{{*err: invalid column length*}}|When the column is a BLOB, or has a maximum length in excess of 4,000 characters
|{{*err: ORA-xxx}} |is issued when any other error occurs.
* {{*bad table name*}} When there is no table found in [IMTD] with the name, or alias provided
* {{*bad column name*}} When there is no column name found in [IMCD] with that name, for the table provided.
* {{*error: invalid column length*}} When the column is a BLOB, or has a maximum length in excess of 4,000 characters
* {{*error: ORA-xxx}} is issued when any other error occurs.
At line 27 removed 6 lines
{{P2K_PU.GC('P2K_PR_PAY_RUNS','DISBURSED',~)}} - Using Pay Run ID as the third parameter (~)
;:Will return the DISBURSED flag, for the payrun identified by the ID in the third parameter
Note that DATE field types will return the date as a character in DD-MON-YYYY format, so if you want to reformat using a date format mask, then you will need to convert to a date type using the TO_DATE function.