1 Package ghr_par_rku as
2 /* $Header: ghparrhi.pkh 120.5.12010000.1 2008/07/28 10:35:39 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< after_update >------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_update (
9 p_pa_request_id in number,
10 p_pa_notification_id in number,
11 p_noa_family_code in varchar2,
12 p_routing_group_id in number,
13 p_proposed_effective_asap_flag in varchar2,
14 p_academic_discipline in varchar2,
15 p_additional_info_person_id in number,
16 p_additional_info_tel_number in varchar2,
17 p_agency_code in varchar2,
18 p_altered_pa_request_id in number,
19 p_annuitant_indicator in varchar2,
20 p_annuitant_indicator_desc in varchar2,
21 p_appropriation_code1 in varchar2,
22 p_appropriation_code2 in varchar2,
23 p_approval_date in date,
24 p_approving_official_full_name in varchar2,
25 p_approving_official_work_titl in varchar2,
26 p_sf50_approval_date in date,
27 p_sf50_approving_ofcl_full_nam in varchar2,
28 p_sf50_approving_ofcl_work_tit in varchar2,
29 p_authorized_by_person_id in number,
30 p_authorized_by_title in varchar2,
31 p_award_amount in number,
32 p_award_uom in varchar2,
33 p_bargaining_unit_status in varchar2,
34 p_citizenship in varchar2,
35 p_concurrence_date in date,
36 p_custom_pay_calc_flag in varchar2,
37 p_duty_station_code in varchar2,
38 p_duty_station_desc in varchar2,
39 p_duty_station_id in number,
40 p_duty_station_location_id in number,
41 p_education_level in varchar2,
42 p_effective_date in date,
43 p_employee_assignment_id in number,
44 p_employee_date_of_birth in date,
45 p_employee_dept_or_agency in varchar2,
46 p_employee_first_name in varchar2,
47 p_employee_last_name in varchar2,
48 p_employee_middle_names in varchar2,
49 p_employee_national_identifier in varchar2,
50 p_fegli in varchar2,
51 p_fegli_desc in varchar2,
52 p_first_action_la_code1 in varchar2,
53 p_first_action_la_code2 in varchar2,
54 p_first_action_la_desc1 in varchar2,
55 p_first_action_la_desc2 in varchar2,
56 p_first_noa_cancel_or_correct in varchar2,
57 p_first_noa_code in varchar2,
58 p_first_noa_desc in varchar2,
59 p_first_noa_id in number,
60 p_first_noa_pa_request_id in number,
61 p_flsa_category in varchar2,
62 p_forwarding_address_line1 in varchar2,
63 p_forwarding_address_line2 in varchar2,
64 p_forwarding_address_line3 in varchar2,
65 p_forwarding_country in varchar2,
66 p_forwarding_country_short_nam in varchar2,
67 p_forwarding_postal_code in varchar2,
68 p_forwarding_region_2 in varchar2,
69 p_forwarding_town_or_city in varchar2,
70 p_from_adj_basic_pay in number,
71 p_from_agency_code in varchar2,
72 p_from_agency_desc in varchar2,
73 p_from_basic_pay in number,
74 p_from_grade_or_level in varchar2,
75 p_from_locality_adj in number,
76 p_from_occ_code in varchar2,
77 p_from_office_symbol in varchar2,
78 p_from_other_pay_amount in number,
79 p_from_pay_basis in varchar2,
80 p_from_pay_plan in varchar2,
81 -- FWFA Changes Bug#4444609
82 -- p_input_pay_rate_determinant in varchar2,
83 -- p_from_pay_table_identifier in number,
84 -- FWFA Changes
85 p_from_position_id in number,
86 p_from_position_org_line1 in varchar2,
87 p_from_position_org_line2 in varchar2,
88 p_from_position_org_line3 in varchar2,
89 p_from_position_org_line4 in varchar2,
90 p_from_position_org_line5 in varchar2,
91 p_from_position_org_line6 in varchar2,
92 p_from_position_number in varchar2,
93 p_from_position_seq_no in number,
94 p_from_position_title in varchar2,
95 p_from_step_or_rate in varchar2,
96 p_from_total_salary in number,
97 p_functional_class in varchar2,
98 p_notepad in varchar2,
99 p_part_time_hours in number,
100 p_pay_rate_determinant in varchar2,
101 p_personnel_office_id in varchar2,
102 p_person_id in number,
103 p_position_occupied in varchar2,
104 p_proposed_effective_date in date,
105 p_requested_by_person_id in number,
106 p_requested_by_title in varchar2,
107 p_requested_date in date,
108 p_requesting_office_remarks_de in varchar2,
109 p_requesting_office_remarks_fl in varchar2,
110 p_request_number in varchar2,
111 p_resign_and_retire_reason_des in varchar2,
112 p_retirement_plan in varchar2,
113 p_retirement_plan_desc in varchar2,
114 p_second_action_la_code1 in varchar2,
115 p_second_action_la_code2 in varchar2,
116 p_second_action_la_desc1 in varchar2,
117 p_second_action_la_desc2 in varchar2,
118 p_second_noa_cancel_or_correct in varchar2,
119 p_second_noa_code in varchar2,
120 p_second_noa_desc in varchar2,
121 p_second_noa_id in number,
122 p_second_noa_pa_request_id in number,
123 p_service_comp_date in date,
124 p_status in varchar2,
125 p_supervisory_status in varchar2,
126 p_tenure in varchar2,
127 p_to_adj_basic_pay in number,
128 p_to_basic_pay in number,
129 p_to_grade_id in number,
130 p_to_grade_or_level in varchar2,
131 p_to_job_id in number,
132 p_to_locality_adj in number,
133 p_to_occ_code in varchar2,
134 p_to_office_symbol in varchar2,
135 p_to_organization_id in number,
136 p_to_other_pay_amount in number,
137 p_to_au_overtime in number,
138 p_to_auo_premium_pay_indicator in varchar2,
139 p_to_availability_pay in number,
140 p_to_ap_premium_pay_indicator in varchar2,
141 p_to_retention_allowance in number,
142 p_to_supervisory_differential in number,
143 p_to_staffing_differential in number,
144 p_to_pay_basis in varchar2,
145 p_to_pay_plan in varchar2,
146 -- FWFA Changes Bug#4444609
147 -- p_to_pay_table_identifier in number,
148 -- FWFA Changes
149 p_to_position_id in number,
150 p_to_position_org_line1 in varchar2,
151 p_to_position_org_line2 in varchar2,
152 p_to_position_org_line3 in varchar2,
153 p_to_position_org_line4 in varchar2,
154 p_to_position_org_line5 in varchar2,
155 p_to_position_org_line6 in varchar2,
156 p_to_position_number in varchar2,
157 p_to_position_seq_no in number,
158 p_to_position_title in varchar2,
159 p_to_step_or_rate in varchar2,
160 p_to_total_salary in number,
161 p_veterans_preference in varchar2,
162 p_veterans_pref_for_rif in varchar2,
163 p_veterans_status in varchar2,
164 p_work_schedule in varchar2,
165 p_work_schedule_desc in varchar2,
166 p_year_degree_attained in number,
167 p_first_noa_information1 in varchar2,
168 p_first_noa_information2 in varchar2,
169 p_first_noa_information3 in varchar2,
170 p_first_noa_information4 in varchar2,
171 p_first_noa_information5 in varchar2,
172 p_second_lac1_information1 in varchar2,
173 p_second_lac1_information2 in varchar2,
174 p_second_lac1_information3 in varchar2,
175 p_second_lac1_information4 in varchar2,
176 p_second_lac1_information5 in varchar2,
177 p_second_lac2_information1 in varchar2,
178 p_second_lac2_information2 in varchar2,
179 p_second_lac2_information3 in varchar2,
180 p_second_lac2_information4 in varchar2,
181 p_second_lac2_information5 in varchar2,
182 p_second_noa_information1 in varchar2,
183 p_second_noa_information2 in varchar2,
184 p_second_noa_information3 in varchar2,
185 p_second_noa_information4 in varchar2,
186 p_second_noa_information5 in varchar2,
187 p_first_lac1_information1 in varchar2,
188 p_first_lac1_information2 in varchar2,
189 p_first_lac1_information3 in varchar2,
190 p_first_lac1_information4 in varchar2,
191 p_first_lac1_information5 in varchar2,
192 p_first_lac2_information1 in varchar2,
193 p_first_lac2_information2 in varchar2,
194 p_first_lac2_information3 in varchar2,
195 p_first_lac2_information4 in varchar2,
196 p_first_lac2_information5 in varchar2,
197 p_attribute_category in varchar2,
198 p_attribute1 in varchar2,
199 p_attribute2 in varchar2,
200 p_attribute3 in varchar2,
201 p_attribute4 in varchar2,
202 p_attribute5 in varchar2,
203 p_attribute6 in varchar2,
204 p_attribute7 in varchar2,
205 p_attribute8 in varchar2,
206 p_attribute9 in varchar2,
207 p_attribute10 in varchar2,
208 p_attribute11 in varchar2,
209 p_attribute12 in varchar2,
210 p_attribute13 in varchar2,
211 p_attribute14 in varchar2,
212 p_attribute15 in varchar2,
213 p_attribute16 in varchar2,
214 p_attribute17 in varchar2,
215 p_attribute18 in varchar2,
216 p_attribute19 in varchar2,
217 p_attribute20 in varchar2,
218 p_first_noa_canc_pa_request_id in number ,
219 p_second_noa_canc_pa_request_i in number ,
220 p_to_retention_allow_percentag in number ,
221 p_to_supervisory_diff_percenta in number ,
222 p_to_staffing_diff_percentage in number ,
223 p_award_percentage in number ,
224 p_rpa_type in varchar2,
225 p_mass_action_id in number ,
226 p_mass_action_eligible_flag in varchar2,
227 p_mass_action_select_flag in varchar2,
228 p_mass_action_comments in varchar2,
229 p_pa_notification_id_o in number ,
230 p_noa_family_code_o in varchar2,
231 p_routing_group_id_o in number,
232 p_proposed_effective_asap_fl_o in varchar2,
233 p_academic_discipline_o in varchar2,
234 p_additional_info_person_id_o in number,
235 p_additional_info_tel_number_o in varchar2,
236 p_agency_code_o in varchar2,
237 p_altered_pa_request_id_o in number,
238 p_annuitant_indicator_o in varchar2,
239 p_annuitant_indicator_desc_o in varchar2,
240 p_appropriation_code1_o in varchar2,
241 p_appropriation_code2_o in varchar2,
242 p_approval_date_o in date,
243 p_approving_official_full_na_o in varchar2,
244 p_approving_official_work_ti_o in varchar2,
245 p_sf50_approval_date_o in date,
246 p_sf50_approving_ofcl_full_n_o in varchar2,
247 p_sf50_approving_ofcl_work_t_o in varchar2,
248 p_authorized_by_person_id_o in number,
249 p_authorized_by_title_o in varchar2,
250 p_award_amount_o in number,
251 p_award_uom_o in varchar2,
252 p_bargaining_unit_status_o in varchar2,
253 p_citizenship_o in varchar2,
254 p_concurrence_date_o in date,
255 p_custom_pay_calc_flag_o in varchar2,
256 p_duty_station_code_o in varchar2,
257 p_duty_station_desc_o in varchar2,
258 p_duty_station_id_o in number,
259 p_duty_station_location_id_o in number,
260 p_education_level_o in varchar2,
261 p_effective_date_o in date,
262 p_employee_assignment_id_o in number,
263 p_employee_date_of_birth_o in date,
264 p_employee_dept_or_agency_o in varchar2,
265 p_employee_first_name_o in varchar2,
266 p_employee_last_name_o in varchar2,
267 p_employee_middle_names_o in varchar2,
268 p_employee_national_identifi_o in varchar2,
269 p_fegli_o in varchar2,
270 p_fegli_desc_o in varchar2,
271 p_first_action_la_code1_o in varchar2,
272 p_first_action_la_code2_o in varchar2,
273 p_first_action_la_desc1_o in varchar2,
274 p_first_action_la_desc2_o in varchar2,
275 p_first_noa_cancel_or_correc_o in varchar2,
276 p_first_noa_code_o in varchar2,
277 p_first_noa_desc_o in varchar2,
278 p_first_noa_id_o in number,
279 p_first_noa_pa_request_id_o in number,
280 p_flsa_category_o in varchar2,
281 p_forwarding_address_line1_o in varchar2,
282 p_forwarding_address_line2_o in varchar2,
283 p_forwarding_address_line3_o in varchar2,
284 p_forwarding_country_o in varchar2,
285 p_forwarding_country_short_n_o in varchar2,
286 p_forwarding_postal_code_o in varchar2,
287 p_forwarding_region_2_o in varchar2,
288 p_forwarding_town_or_city_o in varchar2,
289 p_from_adj_basic_pay_o in number,
290 p_from_agency_code_o in varchar2,
291 p_from_agency_desc_o in varchar2,
292 p_from_basic_pay_o in number,
293 p_from_grade_or_level_o in varchar2,
294 p_from_locality_adj_o in number,
295 p_from_occ_code_o in varchar2,
296 p_from_office_symbol_o in varchar2,
297 p_from_other_pay_amount_o in number,
298 p_from_pay_basis_o in varchar2,
299 p_from_pay_plan_o in varchar2,
300 -- FWFA Changes Bug#4444609
301 -- p_input_pay_rate_determinant_o in varchar2,
302 -- p_from_pay_table_identifier_o in number,
303 -- FWFA Changes
304 p_from_position_id_o in number,
305 p_from_position_org_line1_o in varchar2,
306 p_from_position_org_line2_o in varchar2,
307 p_from_position_org_line3_o in varchar2,
308 p_from_position_org_line4_o in varchar2,
309 p_from_position_org_line5_o in varchar2,
310 p_from_position_org_line6_o in varchar2,
311 p_from_position_number_o in varchar2,
312 p_from_position_seq_no_o in number,
313 p_from_position_title_o in varchar2,
314 p_from_step_or_rate_o in varchar2,
315 p_from_total_salary_o in number,
316 p_functional_class_o in varchar2,
317 p_notepad_o in varchar2,
318 p_part_time_hours_o in number,
319 p_pay_rate_determinant_o in varchar2,
320 p_personnel_office_id_o in varchar2,
321 p_person_id_o in number,
322 p_position_occupied_o in varchar2,
323 p_proposed_effective_date_o in date,
324 p_requested_by_person_id_o in number,
328 p_requesting_office_remark_f_o in varchar2,
325 p_requested_by_title_o in varchar2,
326 p_requested_date_o in date,
327 p_requesting_office_remark_d_o in varchar2,
329 p_request_number_o in varchar2,
330 p_resign_and_retire_reason_d_o in varchar2,
331 p_retirement_plan_o in varchar2,
332 p_retirement_plan_desc_o in varchar2,
333 p_second_action_la_code1_o in varchar2,
334 p_second_action_la_code2_o in varchar2,
335 p_second_action_la_desc1_o in varchar2,
336 p_second_action_la_desc2_o in varchar2,
337 p_second_noa_cancel_or_corre_o in varchar2,
338 p_second_noa_code_o in varchar2,
339 p_second_noa_desc_o in varchar2,
340 p_second_noa_id_o in number,
341 p_second_noa_pa_request_id_o in number,
342 p_service_comp_date_o in date,
343 p_status_o in varchar2,
344 p_supervisory_status_o in varchar2,
345 p_tenure_o in varchar2,
346 p_to_adj_basic_pay_o in number,
347 p_to_basic_pay_o in number,
348 p_to_grade_id_o in number,
349 p_to_grade_or_level_o in varchar2,
350 p_to_job_id_o in number,
351 p_to_locality_adj_o in number,
352 p_to_occ_code_o in varchar2,
353 p_to_office_symbol_o in varchar2,
354 p_to_organization_id_o in number,
355 p_to_other_pay_amount_o in number,
356 p_to_au_overtime_o in number,
357 p_to_auo_premium_pay_indicat_o in varchar2,
358 p_to_availability_pay_o in number,
359 p_to_ap_premium_pay_indicato_o in varchar2,
360 p_to_retention_allowance_o in number,
361 p_to_supervisory_differentia_o in number,
362 p_to_staffing_differential_o in number,
363 p_to_pay_basis_o in varchar2,
364 p_to_pay_plan_o in varchar2,
365 -- FWFA Changes Bug#4444609
366 -- p_to_pay_table_identifier_o in number,
367 -- FWFA Changes
368 p_to_position_id_o in number,
369 p_to_position_org_line1_o in varchar2,
370 p_to_position_org_line2_o in varchar2,
371 p_to_position_org_line3_o in varchar2,
372 p_to_position_org_line4_o in varchar2,
373 p_to_position_org_line5_o in varchar2,
374 p_to_position_org_line6_o in varchar2,
375 p_to_position_number_o in varchar2,
376 p_to_position_seq_no_o in number,
377 p_to_position_title_o in varchar2,
378 p_to_step_or_rate_o in varchar2,
379 p_to_total_salary_o in number,
380 p_veterans_preference_o in varchar2,
381 p_veterans_pref_for_rif_o in varchar2,
382 p_veterans_status_o in varchar2,
383 p_work_schedule_o in varchar2,
384 p_work_schedule_desc_o in varchar2,
385 p_year_degree_attained_o in number,
386 p_first_noa_information1_o in varchar2,
387 p_first_noa_information2_o in varchar2,
388 p_first_noa_information3_o in varchar2,
389 p_first_noa_information4_o in varchar2,
390 p_first_noa_information5_o in varchar2,
391 p_second_lac1_information1_o in varchar2,
392 p_second_lac1_information2_o in varchar2,
393 p_second_lac1_information3_o in varchar2,
394 p_second_lac1_information4_o in varchar2,
395 p_second_lac1_information5_o in varchar2,
396 p_second_lac2_information1_o in varchar2,
397 p_second_lac2_information2_o in varchar2,
398 p_second_lac2_information3_o in varchar2,
399 p_second_lac2_information4_o in varchar2,
400 p_second_lac2_information5_o in varchar2,
401 p_second_noa_information1_o in varchar2,
402 p_second_noa_information2_o in varchar2,
403 p_second_noa_information3_o in varchar2,
404 p_second_noa_information4_o in varchar2,
405 p_second_noa_information5_o in varchar2,
406 p_first_lac1_information1_o in varchar2,
407 p_first_lac1_information2_o in varchar2,
408 p_first_lac1_information3_o in varchar2,
409 p_first_lac1_information4_o in varchar2,
410 p_first_lac1_information5_o in varchar2,
411 p_first_lac2_information1_o in varchar2,
412 p_first_lac2_information2_o in varchar2,
413 p_first_lac2_information3_o in varchar2,
414 p_first_lac2_information4_o in varchar2,
415 p_first_lac2_information5_o in varchar2,
416 p_attribute_category_o in varchar2,
417 p_attribute1_o in varchar2,
418 p_attribute2_o in varchar2,
419 p_attribute3_o in varchar2,
420 p_attribute4_o in varchar2,
421 p_attribute5_o in varchar2,
422 p_attribute6_o in varchar2,
423 p_attribute7_o in varchar2,
424 p_attribute8_o in varchar2,
425 p_attribute9_o in varchar2,
426 p_attribute10_o in varchar2,
427 p_attribute11_o in varchar2,
428 p_attribute12_o in varchar2,
429 p_attribute13_o in varchar2,
430 p_attribute14_o in varchar2,
431 p_attribute15_o in varchar2,
432 p_attribute16_o in varchar2,
433 p_attribute17_o in varchar2,
434 p_attribute18_o in varchar2,
435 p_attribute19_o in varchar2,
436 p_attribute20_o in varchar2,
437 p_first_noa_canc_pa_request_o in number ,
438 p_second_noa_canc_pa_request_o in number ,
439 p_to_retention_allow_percent_o in number ,
440 p_to_supervisory_diff_percen_o in number ,
441 p_to_staffing_diff_percentag_o in number ,
442 p_award_percentage_o in number ,
443 p_rpa_type_o in varchar2,
444 p_mass_action_id_o in number ,
445 p_mass_action_eligible_flag_o in varchar2,
446 p_mass_action_select_flag_o in varchar2,
447 p_mass_action_comments_o in varchar2
448 );
449
450 end ghr_par_rku;