DPS_AVAIL_EXIT (System Preference)#

Description	This preference defines a user exit to be invoked on Posting-based screens (like IRPO)
Set at	IMFN = Function
Takes effect	Immediately
Values	Name of PL/SQL function in the database to be invoked as noted below
Notes	This function, if defined is called at the LOV for the position code (DPS_ID) and is called again at the point of saving. The purpose of this function will be to provide additional editing/processing on the position code while creating or updating a posting.

Function definition:#

Parameters#

DPS_ID

(Numeric) The ID of the position selected in the list of available values, or already chosen on the posting

RPO_ID

(Numeric) The ID of the posting itself (if it has already been created) or a value <0 if this is an insert of a new posting

Return Numeric#

NULL

Your function should return a NULL value if there is no issue with the position selected.

Numeric Value

If your function returns a numeric >0 value, then this is used to choose a message from IMMS in the format DPS_xxx where xxx is the numeric return value. This will cause a message dialog to pop up with the message at both the position code selection time and at saving. In the latter event, the save will be interrupted until the return result is NULL.

Other Notes#

• Do not forget to create a public synonym for the function, so that users other than P2K will be able to access it.
• Do not forget to grant execute rights to the P2K_USER role, so that users will be able to execute it.

---

Notes #

Click to create a new notes page