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_RKU

Source


1 package body GHR_PAR_RKU 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:38 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_UPDATE
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 ,P_PA_NOTIFICATION_ID_O in NUMBER
220 ,P_NOA_FAMILY_CODE_O in VARCHAR2
221 ,P_ROUTING_GROUP_ID_O in NUMBER
222 ,P_PROPOSED_EFFECTIVE_ASAP_FL_O in VARCHAR2
223 ,P_ACADEMIC_DISCIPLINE_O in VARCHAR2
224 ,P_ADDITIONAL_INFO_PERSON_ID_O in NUMBER
225 ,P_ADDITIONAL_INFO_TEL_NUMBER_O in VARCHAR2
226 ,P_AGENCY_CODE_O in VARCHAR2
227 ,P_ALTERED_PA_REQUEST_ID_O in NUMBER
228 ,P_ANNUITANT_INDICATOR_O in VARCHAR2
229 ,P_ANNUITANT_INDICATOR_DESC_O in VARCHAR2
230 ,P_APPROPRIATION_CODE1_O in VARCHAR2
231 ,P_APPROPRIATION_CODE2_O in VARCHAR2
232 ,P_APPROVAL_DATE_O in DATE
233 ,P_APPROVING_OFFICIAL_FULL_NA_O in VARCHAR2
234 ,P_APPROVING_OFFICIAL_WORK_TI_O in VARCHAR2
235 ,P_SF50_APPROVAL_DATE_O in DATE
236 ,P_SF50_APPROVING_OFCL_FULL_N_O in VARCHAR2
237 ,P_SF50_APPROVING_OFCL_WORK_T_O in VARCHAR2
238 ,P_AUTHORIZED_BY_PERSON_ID_O in NUMBER
239 ,P_AUTHORIZED_BY_TITLE_O in VARCHAR2
240 ,P_AWARD_AMOUNT_O in NUMBER
241 ,P_AWARD_UOM_O in VARCHAR2
242 ,P_BARGAINING_UNIT_STATUS_O in VARCHAR2
243 ,P_CITIZENSHIP_O in VARCHAR2
244 ,P_CONCURRENCE_DATE_O in DATE
245 ,P_CUSTOM_PAY_CALC_FLAG_O in VARCHAR2
246 ,P_DUTY_STATION_CODE_O in VARCHAR2
247 ,P_DUTY_STATION_DESC_O in VARCHAR2
248 ,P_DUTY_STATION_ID_O in NUMBER
249 ,P_DUTY_STATION_LOCATION_ID_O in NUMBER
250 ,P_EDUCATION_LEVEL_O in VARCHAR2
251 ,P_EFFECTIVE_DATE_O in DATE
252 ,P_EMPLOYEE_ASSIGNMENT_ID_O in NUMBER
253 ,P_EMPLOYEE_DATE_OF_BIRTH_O in DATE
254 ,P_EMPLOYEE_DEPT_OR_AGENCY_O in VARCHAR2
255 ,P_EMPLOYEE_FIRST_NAME_O in VARCHAR2
256 ,P_EMPLOYEE_LAST_NAME_O in VARCHAR2
257 ,P_EMPLOYEE_MIDDLE_NAMES_O in VARCHAR2
258 ,P_EMPLOYEE_NATIONAL_IDENTIFI_O in VARCHAR2
259 ,P_FEGLI_O in VARCHAR2
260 ,P_FEGLI_DESC_O in VARCHAR2
261 ,P_FIRST_ACTION_LA_CODE1_O in VARCHAR2
262 ,P_FIRST_ACTION_LA_CODE2_O in VARCHAR2
263 ,P_FIRST_ACTION_LA_DESC1_O in VARCHAR2
264 ,P_FIRST_ACTION_LA_DESC2_O in VARCHAR2
265 ,P_FIRST_NOA_CANCEL_OR_CORREC_O in VARCHAR2
266 ,P_FIRST_NOA_CODE_O in VARCHAR2
267 ,P_FIRST_NOA_DESC_O in VARCHAR2
268 ,P_FIRST_NOA_ID_O in NUMBER
269 ,P_FIRST_NOA_PA_REQUEST_ID_O in NUMBER
270 ,P_FLSA_CATEGORY_O in VARCHAR2
271 ,P_FORWARDING_ADDRESS_LINE1_O in VARCHAR2
272 ,P_FORWARDING_ADDRESS_LINE2_O in VARCHAR2
273 ,P_FORWARDING_ADDRESS_LINE3_O in VARCHAR2
274 ,P_FORWARDING_COUNTRY_O in VARCHAR2
275 ,P_FORWARDING_COUNTRY_SHORT_N_O in VARCHAR2
276 ,P_FORWARDING_POSTAL_CODE_O in VARCHAR2
277 ,P_FORWARDING_REGION_2_O in VARCHAR2
278 ,P_FORWARDING_TOWN_OR_CITY_O in VARCHAR2
279 ,P_FROM_ADJ_BASIC_PAY_O in NUMBER
280 ,P_FROM_AGENCY_CODE_O in VARCHAR2
281 ,P_FROM_AGENCY_DESC_O in VARCHAR2
282 ,P_FROM_BASIC_PAY_O in NUMBER
283 ,P_FROM_GRADE_OR_LEVEL_O in VARCHAR2
284 ,P_FROM_LOCALITY_ADJ_O in NUMBER
285 ,P_FROM_OCC_CODE_O in VARCHAR2
286 ,P_FROM_OFFICE_SYMBOL_O in VARCHAR2
287 ,P_FROM_OTHER_PAY_AMOUNT_O in NUMBER
288 ,P_FROM_PAY_BASIS_O in VARCHAR2
289 ,P_FROM_PAY_PLAN_O in VARCHAR2
290 ,P_FROM_POSITION_ID_O in NUMBER
291 ,P_FROM_POSITION_ORG_LINE1_O in VARCHAR2
292 ,P_FROM_POSITION_ORG_LINE2_O in VARCHAR2
293 ,P_FROM_POSITION_ORG_LINE3_O in VARCHAR2
294 ,P_FROM_POSITION_ORG_LINE4_O in VARCHAR2
295 ,P_FROM_POSITION_ORG_LINE5_O in VARCHAR2
296 ,P_FROM_POSITION_ORG_LINE6_O in VARCHAR2
297 ,P_FROM_POSITION_NUMBER_O in VARCHAR2
298 ,P_FROM_POSITION_SEQ_NO_O in NUMBER
299 ,P_FROM_POSITION_TITLE_O in VARCHAR2
300 ,P_FROM_STEP_OR_RATE_O in VARCHAR2
301 ,P_FROM_TOTAL_SALARY_O in NUMBER
302 ,P_FUNCTIONAL_CLASS_O in VARCHAR2
303 ,P_NOTEPAD_O in VARCHAR2
304 ,P_PART_TIME_HOURS_O in NUMBER
305 ,P_PAY_RATE_DETERMINANT_O in VARCHAR2
306 ,P_PERSONNEL_OFFICE_ID_O in VARCHAR2
307 ,P_PERSON_ID_O in NUMBER
308 ,P_POSITION_OCCUPIED_O in VARCHAR2
309 ,P_PROPOSED_EFFECTIVE_DATE_O in DATE
310 ,P_REQUESTED_BY_PERSON_ID_O in NUMBER
311 ,P_REQUESTED_BY_TITLE_O in VARCHAR2
312 ,P_REQUESTED_DATE_O in DATE
313 ,P_REQUESTING_OFFICE_REMARK_D_O in VARCHAR2
314 ,P_REQUESTING_OFFICE_REMARK_F_O in VARCHAR2
315 ,P_REQUEST_NUMBER_O in VARCHAR2
316 ,P_RESIGN_AND_RETIRE_REASON_D_O in VARCHAR2
317 ,P_RETIREMENT_PLAN_O in VARCHAR2
318 ,P_RETIREMENT_PLAN_DESC_O in VARCHAR2
319 ,P_SECOND_ACTION_LA_CODE1_O in VARCHAR2
320 ,P_SECOND_ACTION_LA_CODE2_O in VARCHAR2
321 ,P_SECOND_ACTION_LA_DESC1_O in VARCHAR2
322 ,P_SECOND_ACTION_LA_DESC2_O in VARCHAR2
323 ,P_SECOND_NOA_CANCEL_OR_CORRE_O in VARCHAR2
324 ,P_SECOND_NOA_CODE_O in VARCHAR2
325 ,P_SECOND_NOA_DESC_O in VARCHAR2
326 ,P_SECOND_NOA_ID_O in NUMBER
327 ,P_SECOND_NOA_PA_REQUEST_ID_O in NUMBER
328 ,P_SERVICE_COMP_DATE_O in DATE
329 ,P_STATUS_O in VARCHAR2
330 ,P_SUPERVISORY_STATUS_O in VARCHAR2
331 ,P_TENURE_O in VARCHAR2
332 ,P_TO_ADJ_BASIC_PAY_O in NUMBER
333 ,P_TO_BASIC_PAY_O in NUMBER
334 ,P_TO_GRADE_ID_O in NUMBER
335 ,P_TO_GRADE_OR_LEVEL_O in VARCHAR2
336 ,P_TO_JOB_ID_O in NUMBER
337 ,P_TO_LOCALITY_ADJ_O in NUMBER
338 ,P_TO_OCC_CODE_O in VARCHAR2
339 ,P_TO_OFFICE_SYMBOL_O in VARCHAR2
340 ,P_TO_ORGANIZATION_ID_O in NUMBER
341 ,P_TO_OTHER_PAY_AMOUNT_O in NUMBER
342 ,P_TO_AU_OVERTIME_O in NUMBER
343 ,P_TO_AUO_PREMIUM_PAY_INDICAT_O in VARCHAR2
344 ,P_TO_AVAILABILITY_PAY_O in NUMBER
345 ,P_TO_AP_PREMIUM_PAY_INDICATO_O in VARCHAR2
346 ,P_TO_RETENTION_ALLOWANCE_O in NUMBER
347 ,P_TO_SUPERVISORY_DIFFERENTIA_O in NUMBER
348 ,P_TO_STAFFING_DIFFERENTIAL_O in NUMBER
349 ,P_TO_PAY_BASIS_O in VARCHAR2
350 ,P_TO_PAY_PLAN_O in VARCHAR2
351 ,P_TO_POSITION_ID_O in NUMBER
352 ,P_TO_POSITION_ORG_LINE1_O in VARCHAR2
353 ,P_TO_POSITION_ORG_LINE2_O in VARCHAR2
354 ,P_TO_POSITION_ORG_LINE3_O in VARCHAR2
355 ,P_TO_POSITION_ORG_LINE4_O in VARCHAR2
356 ,P_TO_POSITION_ORG_LINE5_O in VARCHAR2
357 ,P_TO_POSITION_ORG_LINE6_O in VARCHAR2
358 ,P_TO_POSITION_NUMBER_O in VARCHAR2
359 ,P_TO_POSITION_SEQ_NO_O in NUMBER
360 ,P_TO_POSITION_TITLE_O in VARCHAR2
361 ,P_TO_STEP_OR_RATE_O in VARCHAR2
362 ,P_TO_TOTAL_SALARY_O in NUMBER
363 ,P_VETERANS_PREFERENCE_O in VARCHAR2
364 ,P_VETERANS_PREF_FOR_RIF_O in VARCHAR2
365 ,P_VETERANS_STATUS_O in VARCHAR2
366 ,P_WORK_SCHEDULE_O in VARCHAR2
367 ,P_WORK_SCHEDULE_DESC_O in VARCHAR2
368 ,P_YEAR_DEGREE_ATTAINED_O in NUMBER
369 ,P_FIRST_NOA_INFORMATION1_O in VARCHAR2
370 ,P_FIRST_NOA_INFORMATION2_O in VARCHAR2
371 ,P_FIRST_NOA_INFORMATION3_O in VARCHAR2
372 ,P_FIRST_NOA_INFORMATION4_O in VARCHAR2
373 ,P_FIRST_NOA_INFORMATION5_O in VARCHAR2
374 ,P_SECOND_LAC1_INFORMATION1_O in VARCHAR2
375 ,P_SECOND_LAC1_INFORMATION2_O in VARCHAR2
376 ,P_SECOND_LAC1_INFORMATION3_O in VARCHAR2
377 ,P_SECOND_LAC1_INFORMATION4_O in VARCHAR2
378 ,P_SECOND_LAC1_INFORMATION5_O in VARCHAR2
379 ,P_SECOND_LAC2_INFORMATION1_O in VARCHAR2
380 ,P_SECOND_LAC2_INFORMATION2_O in VARCHAR2
381 ,P_SECOND_LAC2_INFORMATION3_O in VARCHAR2
382 ,P_SECOND_LAC2_INFORMATION4_O in VARCHAR2
383 ,P_SECOND_LAC2_INFORMATION5_O in VARCHAR2
384 ,P_SECOND_NOA_INFORMATION1_O in VARCHAR2
385 ,P_SECOND_NOA_INFORMATION2_O in VARCHAR2
386 ,P_SECOND_NOA_INFORMATION3_O in VARCHAR2
387 ,P_SECOND_NOA_INFORMATION4_O in VARCHAR2
388 ,P_SECOND_NOA_INFORMATION5_O in VARCHAR2
389 ,P_FIRST_LAC1_INFORMATION1_O in VARCHAR2
390 ,P_FIRST_LAC1_INFORMATION2_O in VARCHAR2
391 ,P_FIRST_LAC1_INFORMATION3_O in VARCHAR2
392 ,P_FIRST_LAC1_INFORMATION4_O in VARCHAR2
393 ,P_FIRST_LAC1_INFORMATION5_O in VARCHAR2
394 ,P_FIRST_LAC2_INFORMATION1_O in VARCHAR2
395 ,P_FIRST_LAC2_INFORMATION2_O in VARCHAR2
396 ,P_FIRST_LAC2_INFORMATION3_O in VARCHAR2
397 ,P_FIRST_LAC2_INFORMATION4_O in VARCHAR2
398 ,P_FIRST_LAC2_INFORMATION5_O in VARCHAR2
399 ,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
400 ,P_ATTRIBUTE1_O in VARCHAR2
401 ,P_ATTRIBUTE2_O in VARCHAR2
402 ,P_ATTRIBUTE3_O in VARCHAR2
403 ,P_ATTRIBUTE4_O in VARCHAR2
404 ,P_ATTRIBUTE5_O in VARCHAR2
405 ,P_ATTRIBUTE6_O in VARCHAR2
406 ,P_ATTRIBUTE7_O in VARCHAR2
407 ,P_ATTRIBUTE8_O in VARCHAR2
408 ,P_ATTRIBUTE9_O in VARCHAR2
409 ,P_ATTRIBUTE10_O in VARCHAR2
410 ,P_ATTRIBUTE11_O in VARCHAR2
411 ,P_ATTRIBUTE12_O in VARCHAR2
412 ,P_ATTRIBUTE13_O in VARCHAR2
413 ,P_ATTRIBUTE14_O in VARCHAR2
414 ,P_ATTRIBUTE15_O in VARCHAR2
415 ,P_ATTRIBUTE16_O in VARCHAR2
416 ,P_ATTRIBUTE17_O in VARCHAR2
417 ,P_ATTRIBUTE18_O in VARCHAR2
418 ,P_ATTRIBUTE19_O in VARCHAR2
419 ,P_ATTRIBUTE20_O in VARCHAR2
420 ,P_FIRST_NOA_CANC_PA_REQUEST_O in NUMBER
421 ,P_SECOND_NOA_CANC_PA_REQUEST_O in NUMBER
422 ,P_TO_RETENTION_ALLOW_PERCENT_O in NUMBER
423 ,P_TO_SUPERVISORY_DIFF_PERCEN_O in NUMBER
424 ,P_TO_STAFFING_DIFF_PERCENTAG_O in NUMBER
425 ,P_AWARD_PERCENTAGE_O in NUMBER
426 ,P_RPA_TYPE_O in VARCHAR2
427 ,P_MASS_ACTION_ID_O in NUMBER
428 ,P_MASS_ACTION_ELIGIBLE_FLAG_O in VARCHAR2
429 ,P_MASS_ACTION_SELECT_FLAG_O in VARCHAR2
430 ,P_MASS_ACTION_COMMENTS_O in VARCHAR2
431 )is
432 begin
433 hr_utility.set_location('Entering: GHR_PAR_RKU.AFTER_UPDATE', 10);
434 hr_utility.set_location(' Leaving: GHR_PAR_RKU.AFTER_UPDATE', 20);
435 end AFTER_UPDATE;
436 end GHR_PAR_RKU;