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
P 2 K_PU.GET_CHILD_ID
P2K_PU.GET_CHILD_ID

Version management

Difference between version and

At line 10 changed one line
|AS OF | ''Optional''. Provides a date frame to retrieve the data. If it is not provided, the current system date will be used.
|AS OF | The ID of the record that you are seeking the data for
At line 13 changed one line
Varchar2 (even though the return value is a numeric ID)
Varchar2 (regardless of the type of data being requested)
At line 16 changed 3 lines
|{{** 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
|{{*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.
At line 22 changed one line
{{p2k_pu.get_child_id('DWR',dwr_id)}}
{{P2K_PU.GC('EID','FIRST_NAME',~)}} - Using Identity ID as the third parameter (~)
At line 24 changed one line
;: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
;:Will return the First Name the employee from P2K_HR_IDENTITIES, identified by the ID in the third parameter
At line 26 changed one line
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.
{{P2K_PU.GC('P2K_PR_PAY_RUNS','DISBURSED',~)}} - Using Pay Run ID as the third parameter (~)
At line 28 changed one line
For example, If I know the Work Rule (DWR) and I want to get the Standard Hours per day from the date sensitive detail (DWRD), the reference would be:
;:Will return the DISBURSED flag, for the payrun identified by the ID in the third parameter
At line 30 changed one line
{{{ p2k_pu.gc('DWRD','STD_HOURS_PER_DAY', p2k_pu.get_child_id('DWR',dwr_id) ) }}}
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.
This page (revision-3) was last changed on 26-Nov-2021 10:22 by rforbesTop