Wiki: P 2 K_PU.DES

Get Employment Type#

Functionality:#

This function retrieves the Status Type for the Status code provided

Parameters:#

STATUS_CODE	The STATUS_CODE for which you want the STATUS_TYPE

Returns: #

Varchar2(20)

Errors: #

If any error occurs during data retrieval, BAD STATUS CODE is returned

Example: #

P2K_PU.DES_TYPE('PROBATIONARY')

May return 'A' (for Active) if that is the way your IDES is defined.

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor