eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PDH_RKU SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5


procedure AFTER_UPDATE
(P_PD_ROUTING_HISTORY_ID in NUMBER
,P_POSITION_DESCRIPTION_ID in NUMBER
,P_INITIATOR_FLAG in VARCHAR2
,P_REQUESTER_FLAG in VARCHAR2
,P_APPROVER_FLAG in VARCHAR2
,P_REVIEWER_FLAG in VARCHAR2
,P_AUTHORIZER_FLAG in VARCHAR2
,P_PERSONNELIST_FLAG in VARCHAR2
,P_APPROVED_FLAG in VARCHAR2
,P_USER_NAME in VARCHAR2
,P_USER_NAME_EMPLOYEE_ID in NUMBER
,P_USER_NAME_EMP_FIRST_NAME in VARCHAR2
,P_USER_NAME_EMP_LAST_NAME in VARCHAR2
,P_USER_NAME_EMP_MIDDLE_NAMES in VARCHAR2
,P_ACTION_TAKEN in VARCHAR2
,P_GROUPBOX_ID in NUMBER
,P_ROUTING_LIST_ID in NUMBER
,P_ROUTING_SEQ_NUMBER in NUMBER
,P_DATE_NOTIFICATION_SENT in DATE
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_ITEM_KEY in VARCHAR2
,P_POSITION_DESCRIPTION_ID_O in NUMBER
,P_INITIATOR_FLAG_O in VARCHAR2
,P_REQUESTER_FLAG_O in VARCHAR2
,P_APPROVER_FLAG_O in VARCHAR2
,P_REVIEWER_FLAG_O in VARCHAR2
,P_AUTHORIZER_FLAG_O in VARCHAR2
,P_PERSONNELIST_FLAG_O in VARCHAR2
,P_APPROVED_FLAG_O in VARCHAR2
,P_USER_NAME_O in VARCHAR2
,P_USER_NAME_EMPLOYEE_ID_O in NUMBER
,P_USER_NAME_EMP_FIRST_NAME_O in VARCHAR2
,P_USER_NAME_EMP_LAST_NAME_O in VARCHAR2
,P_USER_NAME_EMP_MIDDLE_NAMES_O in VARCHAR2
,P_ACTION_TAKEN_O in VARCHAR2
,P_GROUPBOX_ID_O in NUMBER
,P_ROUTING_LIST_ID_O in NUMBER
,P_ROUTING_SEQ_NUMBER_O in NUMBER
,P_DATE_NOTIFICATION_SENT_O in DATE
,P_ITEM_KEY_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: GHR_PDH_RKU.AFTER_UPDATE', 10);

Line: 50


hr_utility.set_location(' Leaving: GHR_PDH_RKU.AFTER_UPDATE', 20);

Line: 51


end AFTER_UPDATE;