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.
