This page (revision-3) 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
3 26-Nov-2021 10:22 1 KB rforbes to previous
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 10 changed one line
|AS OF | The ID of the record that you are seeking the data for
|AS OF | ''Optional''. Provides a date frame to retrieve the data. If it is not provided, the current system date will be used.
At line 13 changed one line
Varchar2 (regardless of the type of data being requested)
Varchar2 (even though the return value is a numeric ID)
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 Alias}} |When there is no table found in [IMTD] with the alias provided
|{{** No UK constraint found with ...}} |When the table alias provided does not have a date sensitive child table
|{{** Select failed on child table ...}} |When a date sensitive child record could not be located as of the date specified
At line 23 changed one line
{{P2K_PU.GC('EID','FIRST_NAME',~)}} - Using Identity ID as the third parameter (~)
{{p2k_pu.get_child_id('DWR',dwr_id)}}
At line 25 changed one line
;:Will return the First Name the employee from P2K_HR_IDENTITIES, identified by the ID in the third parameter
;:will return the ID of the effective record from P2K_CM_WORK_RULE_DETAILS (the child of DWR - P2K_CM_WORK_RULES) as of today
At line 27 changed one line
{{P2K_PU.GC('P2K_PR_PAY_RUNS','DISBURSED',~)}} - Using Pay Run ID as the third parameter (~)
Where this could be used is if you know the information of a header record, but now want to get something from the date-sensitive detail. You can use the combination of the [P2K_PU.GC] function and this function to get the column information from the child record.
At line 29 changed one line
;:Will return the DISBURSED flag, for the payrun identified by the ID in the third parameter
For example, If I know the Work Rule (DWR) and I want to get the Standard Hours per day from the date sensitive detail, the reference would be:
At line 31 changed one line
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.
{{{ p2k_pu.gc('DWRD','STD_HOURS_PER_DAY',p2k_pu.get_child_id('DWR',dwr_id)) }}}