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.
