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

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

Line: 5


procedure AFTER_INSERT
(P_PA_ROUTING_HISTORY_ID in NUMBER
,P_PA_REQUEST_ID in NUMBER
,P_ATTACHMENT_MODIFIED_FLAG in VARCHAR2
,P_INITIATOR_FLAG in VARCHAR2
,P_APPROVER_FLAG in VARCHAR2
,P_REVIEWER_FLAG in VARCHAR2
,P_REQUESTER_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_NOTEPAD 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_NOA_FAMILY_CODE in VARCHAR2
,P_NATURE_OF_ACTION_ID in NUMBER
,P_SECOND_NATURE_OF_ACTION_ID in NUMBER
,P_APPROVAL_STATUS in VARCHAR2
,P_DATE_NOTIFICATION_SENT in DATE
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: GHR_PRH_RKI.AFTER_INSERT', 10);

Line: 35


hr_utility.set_location(' Leaving: GHR_PRH_RKI.AFTER_INSERT', 20);

Line: 36


end AFTER_INSERT;