Personals Information#

Functionality:#

This function retrieves information as seen on IEPI, for an employee's personal information.

Parameters:#

EPS_ID The actual ID for the personal record belonging to the employee you are getting data for
WHAT Identifies which data you wish to retrieve

WHAT Parameter Values#

  • Any field name from P2K_HR_PERSONALS
  • PREV.xxxx - Any field name from P2K_HR_PERSONALS. The value returned will be the value from the immediately preceding effective record on that table. If there is no immediately preceding effective record, then NULL will be returned.
  • NEXT.xxxx - Any field name from P2K_HR_PERSONALS. The value returned will be the value from the immediately following effective record on that table. If there is no immediately followingeffective record, then NULL will be returned.

Returns: #

Varchar2 (regardless of the type of data being requested)

Errors: #

  • *BAD EPS_ID When there is no assignment detail record with the ID provided
  • *BAD WHAT When the WHAT parameter is not one of the values supported

Example: #


Notes#

Click to create a new notes page