Sundry Line Information#

Functionality:#

This function retrieves information as seen on IPSN, for an employee's sundry transaction. This function does not retrieve sundry line detail information, only P2K_PR_SUNDRY_LINES.

Parameters:#

EEM_ID The actual ID for the employment record belonging to the employee you are getting data for
PC_CODE The pay component code for the sundry line
WHAT Identifies which element of the sundry line you wish to retrieve
AS_OF Optional. Provides a date to narrow down the sundry line retrieval. If not provided, then the current date will be used.

WHAT Parameter Values#

  • Any field name from P2K_PR_SUNDRY_LINES
  • PAYEE_NAME - This will return the FIRST_NAME and LAST_NAME of the Payee linked to the PSL record
  • PAYEE_CODE - This will return the PERSON_CODE of the Payee linked to the PSL record

Returns: #

Varchar2 (regardless of the type of data being requested)

If no sundry is found, then NULL is returned

Errors: #

  • *BAD EEM_ID When there is no employment record with the ID provided
  • *BAD PC CODE When there is no such pay component
  • *BAD WHAT When the WHAT parameter is not one of the values supported
  • *BAD SUNDRY When more than one sundry line meets the criteria.

Example: #

P2K_PU.PSN(~,'5030','WORK_ORDER') - Using Employment ID as the first parameter (~)

Will return the WORK_ORDER for the employee's sundry transaction for pay component 5030

Notes#

Click to create a new notes page