1 package body GHR_PRH_RKU as
2 /* $Header: ghprhrhi.pkb 120.2.12000000.1 2007/03/27 09:52:58 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/10/22 06:52:34 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_UPDATE
6 (P_PA_ROUTING_HISTORY_ID in NUMBER
7 ,P_PA_REQUEST_ID in NUMBER
8 ,P_ATTACHMENT_MODIFIED_FLAG in VARCHAR2
9 ,P_INITIATOR_FLAG in VARCHAR2
10 ,P_APPROVER_FLAG in VARCHAR2
11 ,P_REVIEWER_FLAG in VARCHAR2
12 ,P_REQUESTER_FLAG in VARCHAR2
13 ,P_AUTHORIZER_FLAG in VARCHAR2
14 ,P_PERSONNELIST_FLAG in VARCHAR2
15 ,P_APPROVED_FLAG in VARCHAR2
16 ,P_USER_NAME in VARCHAR2
17 ,P_USER_NAME_EMPLOYEE_ID in NUMBER
18 ,P_USER_NAME_EMP_FIRST_NAME in VARCHAR2
19 ,P_USER_NAME_EMP_LAST_NAME in VARCHAR2
20 ,P_USER_NAME_EMP_MIDDLE_NAMES in VARCHAR2
21 ,P_NOTEPAD in VARCHAR2
22 ,P_ACTION_TAKEN in VARCHAR2
23 ,P_GROUPBOX_ID in NUMBER
24 ,P_ROUTING_LIST_ID in NUMBER
25 ,P_ROUTING_SEQ_NUMBER in NUMBER
26 ,P_NOA_FAMILY_CODE in VARCHAR2
27 ,P_NATURE_OF_ACTION_ID in NUMBER
28 ,P_SECOND_NATURE_OF_ACTION_ID in NUMBER
29 ,P_APPROVAL_STATUS in VARCHAR2
30 ,P_DATE_NOTIFICATION_SENT in DATE
31 ,P_OBJECT_VERSION_NUMBER in NUMBER
32 ,P_PA_REQUEST_ID_O in NUMBER
33 ,P_ATTACHMENT_MODIFIED_FLAG_O in VARCHAR2
34 ,P_INITIATOR_FLAG_O in VARCHAR2
35 ,P_APPROVER_FLAG_O in VARCHAR2
36 ,P_REVIEWER_FLAG_O in VARCHAR2
37 ,P_REQUESTER_FLAG_O in VARCHAR2
38 ,P_AUTHORIZER_FLAG_O in VARCHAR2
39 ,P_PERSONNELIST_FLAG_O in VARCHAR2
40 ,P_APPROVED_FLAG_O in VARCHAR2
41 ,P_USER_NAME_O in VARCHAR2
42 ,P_USER_NAME_EMPLOYEE_ID_O in NUMBER
43 ,P_USER_NAME_EMP_FIRST_NAME_O in VARCHAR2
44 ,P_USER_NAME_EMP_LAST_NAME_O in VARCHAR2
45 ,P_USER_NAME_EMP_MIDDLE_NAMES_O in VARCHAR2
46 ,P_NOTEPAD_O in VARCHAR2
47 ,P_ACTION_TAKEN_O in VARCHAR2
48 ,P_GROUPBOX_ID_O in NUMBER
49 ,P_ROUTING_LIST_ID_O in NUMBER
50 ,P_ROUTING_SEQ_NUMBER_O in NUMBER
51 ,P_NOA_FAMILY_CODE_O in VARCHAR2
52 ,P_NATURE_OF_ACTION_ID_O in NUMBER
53 ,P_SECOND_NATURE_OF_ACTION_ID_O in NUMBER
54 ,P_APPROVAL_STATUS_O in VARCHAR2
55 ,P_DATE_NOTIFICATION_SENT_O in DATE
56 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
57 )is
58 begin
59 hr_utility.set_location('Entering: GHR_PRH_RKU.AFTER_UPDATE', 10);
60 hr_utility.set_location(' Leaving: GHR_PRH_RKU.AFTER_UPDATE', 20);
61 end AFTER_UPDATE;
62 end GHR_PRH_RKU;
[Home] [Help]