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.
PACKAGE BODY: APPS.GHR_PAR_RKI

Source


1 package body GHR_PAR_RKI as
2 /* $Header: ghparrhi.pkb 120.5.12010000.3 2008/10/22 07:10:55 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:20:39 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_INSERT
6 (P_PA_REQUEST_ID in NUMBER
7 ,P_PA_NOTIFICATION_ID in NUMBER
8 ,P_NOA_FAMILY_CODE in VARCHAR2
9 ,P_ROUTING_GROUP_ID in NUMBER
10 ,P_PROPOSED_EFFECTIVE_ASAP_FLAG in VARCHAR2
11 ,P_ACADEMIC_DISCIPLINE in VARCHAR2
12 ,P_ADDITIONAL_INFO_PERSON_ID in NUMBER
13 ,P_ADDITIONAL_INFO_TEL_NUMBER in VARCHAR2
14 ,P_AGENCY_CODE in VARCHAR2
15 ,P_ALTERED_PA_REQUEST_ID in NUMBER
16 ,P_ANNUITANT_INDICATOR in VARCHAR2
17 ,P_ANNUITANT_INDICATOR_DESC in VARCHAR2
18 ,P_APPROPRIATION_CODE1 in VARCHAR2
19 ,P_APPROPRIATION_CODE2 in VARCHAR2
20 ,P_APPROVAL_DATE in DATE
21 ,P_APPROVING_OFFICIAL_FULL_NAME in VARCHAR2
22 ,P_APPROVING_OFFICIAL_WORK_TITL in VARCHAR2
23 ,P_SF50_APPROVAL_DATE in DATE
24 ,P_SF50_APPROVING_OFCL_FULL_NAM in VARCHAR2
25 ,P_SF50_APPROVING_OFCL_WORK_TIT in VARCHAR2
26 ,P_AUTHORIZED_BY_PERSON_ID in NUMBER
27 ,P_AUTHORIZED_BY_TITLE in VARCHAR2
28 ,P_AWARD_AMOUNT in NUMBER
29 ,P_AWARD_UOM in VARCHAR2
30 ,P_BARGAINING_UNIT_STATUS in VARCHAR2
31 ,P_CITIZENSHIP in VARCHAR2
32 ,P_CONCURRENCE_DATE in DATE
33 ,P_CUSTOM_PAY_CALC_FLAG in VARCHAR2
34 ,P_DUTY_STATION_CODE in VARCHAR2
35 ,P_DUTY_STATION_DESC in VARCHAR2
36 ,P_DUTY_STATION_ID in NUMBER
37 ,P_DUTY_STATION_LOCATION_ID in NUMBER
38 ,P_EDUCATION_LEVEL in VARCHAR2
39 ,P_EFFECTIVE_DATE in DATE
40 ,P_EMPLOYEE_ASSIGNMENT_ID in NUMBER
41 ,P_EMPLOYEE_DATE_OF_BIRTH in DATE
42 ,P_EMPLOYEE_DEPT_OR_AGENCY in VARCHAR2
43 ,P_EMPLOYEE_FIRST_NAME in VARCHAR2
44 ,P_EMPLOYEE_LAST_NAME in VARCHAR2
45 ,P_EMPLOYEE_MIDDLE_NAMES in VARCHAR2
46 ,P_EMPLOYEE_NATIONAL_IDENTIFIER in VARCHAR2
47 ,P_FEGLI in VARCHAR2
48 ,P_FEGLI_DESC in VARCHAR2
49 ,P_FIRST_ACTION_LA_CODE1 in VARCHAR2
50 ,P_FIRST_ACTION_LA_CODE2 in VARCHAR2
51 ,P_FIRST_ACTION_LA_DESC1 in VARCHAR2
52 ,P_FIRST_ACTION_LA_DESC2 in VARCHAR2
53 ,P_FIRST_NOA_CANCEL_OR_CORRECT in VARCHAR2
54 ,P_FIRST_NOA_CODE in VARCHAR2
55 ,P_FIRST_NOA_DESC in VARCHAR2
56 ,P_FIRST_NOA_ID in NUMBER
57 ,P_FIRST_NOA_PA_REQUEST_ID in NUMBER
58 ,P_FLSA_CATEGORY in VARCHAR2
59 ,P_FORWARDING_ADDRESS_LINE1 in VARCHAR2
60 ,P_FORWARDING_ADDRESS_LINE2 in VARCHAR2
61 ,P_FORWARDING_ADDRESS_LINE3 in VARCHAR2
62 ,P_FORWARDING_COUNTRY in VARCHAR2
63 ,P_FORWARDING_COUNTRY_SHORT_NAM in VARCHAR2
64 ,P_FORWARDING_POSTAL_CODE in VARCHAR2
65 ,P_FORWARDING_REGION_2 in VARCHAR2
66 ,P_FORWARDING_TOWN_OR_CITY in VARCHAR2
67 ,P_FROM_ADJ_BASIC_PAY in NUMBER
68 ,P_FROM_AGENCY_CODE in VARCHAR2
69 ,P_FROM_AGENCY_DESC in VARCHAR2
70 ,P_FROM_BASIC_PAY in NUMBER
71 ,P_FROM_GRADE_OR_LEVEL in VARCHAR2
72 ,P_FROM_LOCALITY_ADJ in NUMBER
73 ,P_FROM_OCC_CODE in VARCHAR2
74 ,P_FROM_OFFICE_SYMBOL in VARCHAR2
75 ,P_FROM_OTHER_PAY_AMOUNT in NUMBER
76 ,P_FROM_PAY_BASIS in VARCHAR2
77 ,P_FROM_PAY_PLAN in VARCHAR2
78 ,P_FROM_POSITION_ID in NUMBER
79 ,P_FROM_POSITION_ORG_LINE1 in VARCHAR2
80 ,P_FROM_POSITION_ORG_LINE2 in VARCHAR2
81 ,P_FROM_POSITION_ORG_LINE3 in VARCHAR2
82 ,P_FROM_POSITION_ORG_LINE4 in VARCHAR2
83 ,P_FROM_POSITION_ORG_LINE5 in VARCHAR2
84 ,P_FROM_POSITION_ORG_LINE6 in VARCHAR2
85 ,P_FROM_POSITION_NUMBER in VARCHAR2
86 ,P_FROM_POSITION_SEQ_NO in NUMBER
87 ,P_FROM_POSITION_TITLE in VARCHAR2
88 ,P_FROM_STEP_OR_RATE in VARCHAR2
89 ,P_FROM_TOTAL_SALARY in NUMBER
90 ,P_FUNCTIONAL_CLASS in VARCHAR2
91 ,P_NOTEPAD in VARCHAR2
92 ,P_PART_TIME_HOURS in NUMBER
93 ,P_PAY_RATE_DETERMINANT in VARCHAR2
94 ,P_PERSONNEL_OFFICE_ID in VARCHAR2
95 ,P_PERSON_ID in NUMBER
96 ,P_POSITION_OCCUPIED in VARCHAR2
97 ,P_PROPOSED_EFFECTIVE_DATE in DATE
98 ,P_REQUESTED_BY_PERSON_ID in NUMBER
99 ,P_REQUESTED_BY_TITLE in VARCHAR2
100 ,P_REQUESTED_DATE in DATE
101 ,P_REQUESTING_OFFICE_REMARKS_DE in VARCHAR2
102 ,P_REQUESTING_OFFICE_REMARKS_FL in VARCHAR2
103 ,P_REQUEST_NUMBER in VARCHAR2
104 ,P_RESIGN_AND_RETIRE_REASON_DES in VARCHAR2
105 ,P_RETIREMENT_PLAN in VARCHAR2
106 ,P_RETIREMENT_PLAN_DESC in VARCHAR2
107 ,P_SECOND_ACTION_LA_CODE1 in VARCHAR2
108 ,P_SECOND_ACTION_LA_CODE2 in VARCHAR2
109 ,P_SECOND_ACTION_LA_DESC1 in VARCHAR2
110 ,P_SECOND_ACTION_LA_DESC2 in VARCHAR2
111 ,P_SECOND_NOA_CANCEL_OR_CORRECT in VARCHAR2
112 ,P_SECOND_NOA_CODE in VARCHAR2
113 ,P_SECOND_NOA_DESC in VARCHAR2
114 ,P_SECOND_NOA_ID in NUMBER
115 ,P_SECOND_NOA_PA_REQUEST_ID in NUMBER
116 ,P_SERVICE_COMP_DATE in DATE
117 ,P_STATUS in VARCHAR2
118 ,P_SUPERVISORY_STATUS in VARCHAR2
119 ,P_TENURE in VARCHAR2
120 ,P_TO_ADJ_BASIC_PAY in NUMBER
121 ,P_TO_BASIC_PAY in NUMBER
122 ,P_TO_GRADE_ID in NUMBER
123 ,P_TO_GRADE_OR_LEVEL in VARCHAR2
124 ,P_TO_JOB_ID in NUMBER
125 ,P_TO_LOCALITY_ADJ in NUMBER
126 ,P_TO_OCC_CODE in VARCHAR2
127 ,P_TO_OFFICE_SYMBOL in VARCHAR2
128 ,P_TO_ORGANIZATION_ID in NUMBER
129 ,P_TO_OTHER_PAY_AMOUNT in NUMBER
130 ,P_TO_AU_OVERTIME in NUMBER
131 ,P_TO_AUO_PREMIUM_PAY_INDICATOR in VARCHAR2
132 ,P_TO_AVAILABILITY_PAY in NUMBER
133 ,P_TO_AP_PREMIUM_PAY_INDICATOR in VARCHAR2
134 ,P_TO_RETENTION_ALLOWANCE in NUMBER
135 ,P_TO_SUPERVISORY_DIFFERENTIAL in NUMBER
136 ,P_TO_STAFFING_DIFFERENTIAL in NUMBER
137 ,P_TO_PAY_BASIS in VARCHAR2
138 ,P_TO_PAY_PLAN in VARCHAR2
139 ,P_TO_POSITION_ID in NUMBER
140 ,P_TO_POSITION_ORG_LINE1 in VARCHAR2
141 ,P_TO_POSITION_ORG_LINE2 in VARCHAR2
142 ,P_TO_POSITION_ORG_LINE3 in VARCHAR2
143 ,P_TO_POSITION_ORG_LINE4 in VARCHAR2
144 ,P_TO_POSITION_ORG_LINE5 in VARCHAR2
145 ,P_TO_POSITION_ORG_LINE6 in VARCHAR2
146 ,P_TO_POSITION_NUMBER in VARCHAR2
147 ,P_TO_POSITION_SEQ_NO in NUMBER
148 ,P_TO_POSITION_TITLE in VARCHAR2
149 ,P_TO_STEP_OR_RATE in VARCHAR2
150 ,P_TO_TOTAL_SALARY in NUMBER
151 ,P_VETERANS_PREFERENCE in VARCHAR2
152 ,P_VETERANS_PREF_FOR_RIF in VARCHAR2
153 ,P_VETERANS_STATUS in VARCHAR2
154 ,P_WORK_SCHEDULE in VARCHAR2
155 ,P_WORK_SCHEDULE_DESC in VARCHAR2
156 ,P_YEAR_DEGREE_ATTAINED in NUMBER
157 ,P_FIRST_NOA_INFORMATION1 in VARCHAR2
158 ,P_FIRST_NOA_INFORMATION2 in VARCHAR2
159 ,P_FIRST_NOA_INFORMATION3 in VARCHAR2
160 ,P_FIRST_NOA_INFORMATION4 in VARCHAR2
161 ,P_FIRST_NOA_INFORMATION5 in VARCHAR2
162 ,P_SECOND_LAC1_INFORMATION1 in VARCHAR2
163 ,P_SECOND_LAC1_INFORMATION2 in VARCHAR2
164 ,P_SECOND_LAC1_INFORMATION3 in VARCHAR2
165 ,P_SECOND_LAC1_INFORMATION4 in VARCHAR2
166 ,P_SECOND_LAC1_INFORMATION5 in VARCHAR2
167 ,P_SECOND_LAC2_INFORMATION1 in VARCHAR2
168 ,P_SECOND_LAC2_INFORMATION2 in VARCHAR2
169 ,P_SECOND_LAC2_INFORMATION3 in VARCHAR2
170 ,P_SECOND_LAC2_INFORMATION4 in VARCHAR2
171 ,P_SECOND_LAC2_INFORMATION5 in VARCHAR2
172 ,P_SECOND_NOA_INFORMATION1 in VARCHAR2
173 ,P_SECOND_NOA_INFORMATION2 in VARCHAR2
174 ,P_SECOND_NOA_INFORMATION3 in VARCHAR2
175 ,P_SECOND_NOA_INFORMATION4 in VARCHAR2
176 ,P_SECOND_NOA_INFORMATION5 in VARCHAR2
177 ,P_FIRST_LAC1_INFORMATION1 in VARCHAR2
178 ,P_FIRST_LAC1_INFORMATION2 in VARCHAR2
179 ,P_FIRST_LAC1_INFORMATION3 in VARCHAR2
180 ,P_FIRST_LAC1_INFORMATION4 in VARCHAR2
181 ,P_FIRST_LAC1_INFORMATION5 in VARCHAR2
182 ,P_FIRST_LAC2_INFORMATION1 in VARCHAR2
183 ,P_FIRST_LAC2_INFORMATION2 in VARCHAR2
184 ,P_FIRST_LAC2_INFORMATION3 in VARCHAR2
185 ,P_FIRST_LAC2_INFORMATION4 in VARCHAR2
186 ,P_FIRST_LAC2_INFORMATION5 in VARCHAR2
187 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
188 ,P_ATTRIBUTE1 in VARCHAR2
189 ,P_ATTRIBUTE2 in VARCHAR2
190 ,P_ATTRIBUTE3 in VARCHAR2
191 ,P_ATTRIBUTE4 in VARCHAR2
192 ,P_ATTRIBUTE5 in VARCHAR2
193 ,P_ATTRIBUTE6 in VARCHAR2
194 ,P_ATTRIBUTE7 in VARCHAR2
195 ,P_ATTRIBUTE8 in VARCHAR2
196 ,P_ATTRIBUTE9 in VARCHAR2
197 ,P_ATTRIBUTE10 in VARCHAR2
198 ,P_ATTRIBUTE11 in VARCHAR2
199 ,P_ATTRIBUTE12 in VARCHAR2
200 ,P_ATTRIBUTE13 in VARCHAR2
201 ,P_ATTRIBUTE14 in VARCHAR2
202 ,P_ATTRIBUTE15 in VARCHAR2
203 ,P_ATTRIBUTE16 in VARCHAR2
204 ,P_ATTRIBUTE17 in VARCHAR2
205 ,P_ATTRIBUTE18 in VARCHAR2
206 ,P_ATTRIBUTE19 in VARCHAR2
207 ,P_ATTRIBUTE20 in VARCHAR2
208 ,P_FIRST_NOA_CANC_PA_REQUEST_ID in NUMBER
209 ,P_SECOND_NOA_CANC_PA_REQUEST_I in NUMBER
210 ,P_TO_RETENTION_ALLOW_PERCENTAG in NUMBER
211 ,P_TO_SUPERVISORY_DIFF_PERCENTA in NUMBER
212 ,P_TO_STAFFING_DIFF_PERCENTAGE in NUMBER
213 ,P_AWARD_PERCENTAGE in NUMBER
214 ,P_RPA_TYPE in VARCHAR2
215 ,P_MASS_ACTION_ID in NUMBER
216 ,P_MASS_ACTION_ELIGIBLE_FLAG in VARCHAR2
217 ,P_MASS_ACTION_SELECT_FLAG in VARCHAR2
218 ,P_MASS_ACTION_COMMENTS in VARCHAR2
219 )is
220 begin
221 hr_utility.set_location('Entering: GHR_PAR_RKI.AFTER_INSERT', 10);
222 hr_utility.set_location(' Leaving: GHR_PAR_RKI.AFTER_INSERT', 20);
223 end AFTER_INSERT;
224 end GHR_PAR_RKI;