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_PRH_RKD SQL Statements

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

Line: 5


procedure AFTER_DELETE
(P_PA_ROUTING_HISTORY_ID in NUMBER
,P_PA_REQUEST_ID_O in NUMBER
,P_ATTACHMENT_MODIFIED_FLAG_O in VARCHAR2
,P_INITIATOR_FLAG_O in VARCHAR2
,P_APPROVER_FLAG_O in VARCHAR2
,P_REVIEWER_FLAG_O in VARCHAR2
,P_REQUESTER_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_NOTEPAD_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_NOA_FAMILY_CODE_O in VARCHAR2
,P_NATURE_OF_ACTION_ID_O in NUMBER
,P_SECOND_NATURE_OF_ACTION_ID_O in NUMBER
,P_APPROVAL_STATUS_O in VARCHAR2
,P_DATE_NOTIFICATION_SENT_O in DATE
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: GHR_PRH_RKD.AFTER_DELETE', 10);

Line: 35


hr_utility.set_location(' Leaving: GHR_PRH_RKD.AFTER_DELETE', 20);

Line: 36


end AFTER_DELETE;