This is version 1 2 3 4 5 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Assignment Distribution Information#

Functionality:#

This function retrieves information as seen on IEAS, for an employee's distribution information.

Parameters:#

EASD_ID	The actual ID for the assignment detail record of the employee you are getting data for
SPLIT_SEQUENCE	Optional. Identifies which split sequence you want to access (a number from 1 to the highest sequence number). If not provided, the first sequence will be used
WHAT	Optional. Identifies which element of the distribution you want to access. If not provided, DISTRIBUTION_CODE will be used

WHAT Parameter Values#

Any field name from the P2K_CM_DISTRIBUTIONS table

Returns: #

Varchar2 (regardless of the type of data being requested)

Errors: #

• *BAD Assignment EASD_ID When there is no assignment details record with the ID provided
• *BAD WHAT When the WHAT parameter is not one of the values supported
• *BAD Distribution Sequence When no distribution sequence matching the ordinal number provided exists (i.e. you said 2 and there is not 2 records or you said 1 or nothing) and there is no distribution)

Example: #

P2K_PU.EASD_DIST(~)

Will return the DISTRIBUTION_CODE for the first (in ascending order) distribution code associated to the employee's assignment detail.

P2K_PU.EASD_DIST(~,2,'SPLIT_PERCENT')

Will return the SPLIT_PERCENT for the second (in ascending order) distribution code associated to the employee's assignment detail.

---

Notes#

Click to create a new notes page