1 Package ghr_sf52_bk2 as
2 /* $Header: ghparapi.pkh 120.10.12010000.1 2008/07/28 10:34:53 appldev ship $ */
3 --
4 --
5 -- update_sf52_b
6 --
7 Procedure update_sf52_b (
8 p_pa_request_id in number ,
9 p_noa_family_code in varchar2 ,
10 p_routing_group_id in number ,
11 p_proposed_effective_asap_flag in varchar2 ,
12 p_academic_discipline in varchar2 ,
13 p_additional_info_person_id in number ,
14 p_additional_info_tel_number 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_authorized_by_person_id in number ,
21 p_authorized_by_title in varchar2 ,
22 p_award_amount in number ,
23 p_award_uom in varchar2 ,
24 p_bargaining_unit_status in varchar2 ,
25 p_citizenship in varchar2 ,
26 p_concurrence_date in date ,
27 p_custom_pay_calc_flag in varchar2 ,
28 p_duty_station_code in varchar2 ,
29 p_duty_station_desc in varchar2 ,
30 p_duty_station_id in number ,
31 p_duty_station_location_id in number ,
32 p_education_level in varchar2 ,
33 p_effective_date in date ,
34 p_employee_assignment_id in number ,
35 p_employee_date_of_birth in date ,
36 p_employee_first_name in varchar2 ,
37 p_employee_last_name in varchar2 ,
38 p_employee_middle_names in varchar2 ,
39 p_employee_national_identifier in varchar2 ,
40 p_fegli in varchar2 ,
41 p_fegli_desc in varchar2 ,
42 p_first_action_la_code1 in varchar2 ,
43 p_first_action_la_code2 in varchar2 ,
44 p_first_action_la_desc1 in varchar2 ,
45 p_first_action_la_desc2 in varchar2 ,
46 p_first_noa_cancel_or_correct in varchar2 ,
47 p_first_noa_code in varchar2 ,
48 p_first_noa_desc in varchar2 ,
49 p_first_noa_id in number ,
50 p_first_noa_pa_request_id in number ,
51 p_flsa_category in varchar2 ,
52 p_forwarding_address_line1 in varchar2 ,
53 p_forwarding_address_line2 in varchar2 ,
54 p_forwarding_address_line3 in varchar2 ,
55 p_forwarding_country in varchar2 ,
56 p_forwarding_country_short_nam in varchar2 ,
57 p_forwarding_postal_code in varchar2 ,
58 p_forwarding_region_2 in varchar2 ,
59 p_forwarding_town_or_city in varchar2 ,
60 p_from_adj_basic_pay in number ,
61 p_from_basic_pay in number ,
62 p_from_grade_or_level in varchar2 ,
63 p_from_locality_adj in number ,
64 p_from_occ_code in varchar2 ,
65 p_from_other_pay_amount in number ,
66 p_from_pay_basis in varchar2 ,
67 p_from_pay_plan in varchar2 ,
68 p_from_position_id in number ,
69 p_from_position_org_line1 in varchar2 ,
70 p_from_position_org_line2 in varchar2 ,
71 p_from_position_org_line3 in varchar2 ,
72 p_from_position_org_line4 in varchar2 ,
73 p_from_position_org_line5 in varchar2 ,
74 p_from_position_org_line6 in varchar2 ,
75 p_from_position_number in varchar2 ,
76 p_from_position_seq_no in number ,
77 p_from_position_title in varchar2 ,
78 p_from_step_or_rate in varchar2 ,
79 p_from_total_salary in number ,
80 p_functional_class in varchar2 ,
81 p_notepad in varchar2 ,
82 p_part_time_hours in number ,
83 p_pay_rate_determinant in varchar2 ,
84 p_person_id in number ,
85 p_position_occupied in varchar2 ,
86 p_proposed_effective_date in date ,
87 p_requested_by_person_id in number ,
88 p_requested_by_title in varchar2 ,
89 p_requested_date in date ,
90 p_requesting_office_remarks_de in varchar2 ,
91 p_requesting_office_remarks_fl in varchar2 ,
92 p_request_number in varchar2 ,
93 p_resign_and_retire_reason_des in varchar2 ,
94 p_retirement_plan in varchar2 ,
95 p_retirement_plan_desc in varchar2 ,
96 p_second_action_la_code1 in varchar2 ,
97 p_second_action_la_code2 in varchar2 ,
98 p_second_action_la_desc1 in varchar2 ,
99 p_second_action_la_desc2 in varchar2 ,
100 p_second_noa_cancel_or_correct in varchar2 ,
101 p_second_noa_code in varchar2 ,
102 p_second_noa_desc in varchar2 ,
103 p_second_noa_id in number ,
104 p_second_noa_pa_request_id in number ,
105 p_service_comp_date in date ,
106 p_supervisory_status in varchar2 ,
107 p_tenure in varchar2 ,
108 p_to_adj_basic_pay in number ,
109 p_to_basic_pay in number ,
110 p_to_grade_id in number ,
111 p_to_grade_or_level in varchar2 ,
112 p_to_job_id in number ,
113 p_to_locality_adj in number ,
114 p_to_occ_code in varchar2 ,
115 p_to_organization_id in number ,
116 p_to_other_pay_amount in number ,
117 p_to_au_overtime in number ,
118 p_to_auo_premium_pay_indicator in varchar2 ,
119 p_to_availability_pay in number ,
120 p_to_ap_premium_pay_indicator in varchar2 ,
121 p_to_retention_allowance in number ,
122 p_to_supervisory_differential in number ,
123 p_to_staffing_differential in number ,
124 p_to_pay_basis in varchar2 ,
125 p_to_pay_plan in varchar2 ,
126 p_to_position_id in number ,
127 p_to_position_org_line1 in varchar2 ,
128 p_to_position_org_line2 in varchar2 ,
129 p_to_position_org_line3 in varchar2 ,
130 p_to_position_org_line4 in varchar2 ,
131 p_to_position_org_line5 in varchar2 ,
132 p_to_position_org_line6 in varchar2 ,
133 p_to_position_number in varchar2 ,
134 p_to_position_seq_no in number ,
135 p_to_position_title in varchar2 ,
136 p_to_step_or_rate in varchar2 ,
137 p_to_total_salary in number ,
138 p_veterans_preference in varchar2 ,
139 p_veterans_pref_for_rif in varchar2 ,
140 p_veterans_status in varchar2 ,
141 p_work_schedule in varchar2 ,
142 p_work_schedule_desc in varchar2 ,
143 p_year_degree_attained in number ,
144 p_first_noa_information1 in varchar2 ,
145 p_first_noa_information2 in varchar2 ,
146 p_first_noa_information3 in varchar2 ,
147 p_first_noa_information4 in varchar2 ,
148 p_first_noa_information5 in varchar2 ,
149 p_second_lac1_information1 in varchar2 ,
150 p_second_lac1_information2 in varchar2 ,
151 p_second_lac1_information3 in varchar2 ,
152 p_second_lac1_information4 in varchar2 ,
153 p_second_lac1_information5 in varchar2 ,
154 p_second_lac2_information1 in varchar2 ,
155 p_second_lac2_information2 in varchar2 ,
156 p_second_lac2_information3 in varchar2 ,
157 p_second_lac2_information4 in varchar2 ,
158 p_second_lac2_information5 in varchar2 ,
159 p_second_noa_information1 in varchar2 ,
160 p_second_noa_information2 in varchar2 ,
161 p_second_noa_information3 in varchar2 ,
162 p_second_noa_information4 in varchar2 ,
163 p_second_noa_information5 in varchar2 ,
164 p_first_lac1_information1 in varchar2 ,
165 p_first_lac1_information2 in varchar2 ,
166 p_first_lac1_information3 in varchar2 ,
167 p_first_lac1_information4 in varchar2 ,
168 p_first_lac1_information5 in varchar2 ,
169 p_first_lac2_information1 in varchar2 ,
170 p_first_lac2_information2 in varchar2 ,
171 p_first_lac2_information3 in varchar2 ,
172 p_first_lac2_information4 in varchar2 ,
173 p_first_lac2_information5 in varchar2 ,
174 p_attribute_category in varchar2 ,
175 p_attribute1 in varchar2 ,
176 p_attribute2 in varchar2 ,
177 p_attribute3 in varchar2 ,
178 p_attribute4 in varchar2 ,
179 p_attribute5 in varchar2 ,
180 p_attribute6 in varchar2 ,
181 p_attribute7 in varchar2 ,
182 p_attribute8 in varchar2 ,
183 p_attribute9 in varchar2 ,
184 p_attribute10 in varchar2 ,
185 p_attribute11 in varchar2 ,
186 p_attribute12 in varchar2 ,
187 p_attribute13 in varchar2 ,
188 p_attribute14 in varchar2 ,
189 p_attribute15 in varchar2 ,
190 p_attribute16 in varchar2 ,
191 p_attribute17 in varchar2 ,
192 p_attribute18 in varchar2 ,
193 p_attribute19 in varchar2 ,
194 p_attribute20 in varchar2 ,
195 p_print_sf50_flag in varchar2 ,
196 p_printer_name in varchar2 ,
197 p_u_attachment_modified_flag in varchar2 ,
198 p_u_approved_flag in varchar2 ,
199 p_u_user_name_acted_on in varchar2 ,
200 p_u_action_taken in varchar2 ,
201 p_u_approval_status in varchar2 ,
202 p_i_user_name_routed_to in varchar2 ,
203 p_i_groupbox_id in number ,
204 p_i_routing_list_id in number ,
205 p_i_routing_seq_number in number ,
206 p_capped_other_pay in number ,
207 p_par_object_version_number in number ,
208 p_to_retention_allow_percentag in number ,
209 p_to_supervisory_diff_percenta in number ,
210 p_to_staffing_diff_percentage in number ,
211 p_award_percentage in number ,
212 p_rpa_type in varchar2 ,
213 p_mass_action_id in number ,
214 p_mass_action_eligible_flag in varchar2 ,
215 p_mass_action_select_flag in varchar2 ,
216 p_mass_action_comments in varchar2
217
218 );
219 --
220 -- update_sf52_a
221 --
222 Procedure update_sf52_a (
223 p_pa_request_id in number ,
224 p_noa_family_code in varchar2 ,
225 p_routing_group_id in number ,
226 p_proposed_effective_asap_flag in varchar2 ,
227 p_academic_discipline in varchar2 ,
228 p_additional_info_person_id in number ,
229 p_additional_info_tel_number in varchar2 ,
230 p_altered_pa_request_id in number ,
231 p_annuitant_indicator in varchar2 ,
232 p_annuitant_indicator_desc in varchar2 ,
233 p_appropriation_code1 in varchar2 ,
234 p_appropriation_code2 in varchar2 ,
235 p_authorized_by_person_id in number ,
236 p_authorized_by_title in varchar2 ,
237 p_award_amount in number ,
238 p_award_uom in varchar2 ,
239 p_bargaining_unit_status in varchar2 ,
240 p_citizenship in varchar2 ,
241 p_concurrence_date in date ,
242 p_custom_pay_calc_flag in varchar2 ,
243 p_duty_station_code in varchar2 ,
244 p_duty_station_desc in varchar2 ,
245 p_duty_station_id in number ,
246 p_duty_station_location_id in number ,
247 p_education_level in varchar2 ,
248 p_effective_date in date ,
249 p_employee_assignment_id in number ,
250 p_employee_date_of_birth in date ,
251 p_employee_first_name in varchar2 ,
252 p_employee_last_name in varchar2 ,
253 p_employee_middle_names in varchar2 ,
254 p_employee_national_identifier in varchar2 ,
255 p_fegli in varchar2 ,
256 p_fegli_desc in varchar2 ,
257 p_first_action_la_code1 in varchar2 ,
258 p_first_action_la_code2 in varchar2 ,
259 p_first_action_la_desc1 in varchar2 ,
260 p_first_action_la_desc2 in varchar2 ,
261 p_first_noa_cancel_or_correct in varchar2 ,
262 p_first_noa_code in varchar2 ,
263 p_first_noa_desc in varchar2 ,
264 p_first_noa_id in number ,
265 p_first_noa_pa_request_id in number ,
266 p_flsa_category in varchar2 ,
267 p_forwarding_address_line1 in varchar2 ,
268 p_forwarding_address_line2 in varchar2 ,
269 p_forwarding_address_line3 in varchar2 ,
270 p_forwarding_country in varchar2 ,
271 p_forwarding_country_short_nam in varchar2 ,
272 p_forwarding_postal_code in varchar2 ,
273 p_forwarding_region_2 in varchar2 ,
274 p_forwarding_town_or_city in varchar2 ,
275 p_from_adj_basic_pay in number ,
276 p_from_basic_pay in number ,
277 p_from_grade_or_level in varchar2 ,
278 p_from_locality_adj in number ,
279 p_from_occ_code in varchar2 ,
280 p_from_other_pay_amount in number ,
281 p_from_pay_basis in varchar2 ,
282 p_from_pay_plan in varchar2 ,
283 p_from_position_id in number ,
284 p_from_position_org_line1 in varchar2 ,
285 p_from_position_org_line2 in varchar2 ,
286 p_from_position_org_line3 in varchar2 ,
287 p_from_position_org_line4 in varchar2 ,
288 p_from_position_org_line5 in varchar2 ,
289 p_from_position_org_line6 in varchar2 ,
290 p_from_position_number in varchar2 ,
291 p_from_position_seq_no in number ,
292 p_from_position_title in varchar2 ,
293 p_from_step_or_rate in varchar2 ,
294 p_from_total_salary in number ,
295 p_functional_class in varchar2 ,
296 p_notepad in varchar2 ,
297 p_part_time_hours in number ,
298 p_pay_rate_determinant in varchar2 ,
299 p_person_id in number ,
300 p_position_occupied in varchar2 ,
301 p_proposed_effective_date in date ,
302 p_requested_by_person_id in number ,
303 p_requested_by_title in varchar2 ,
304 p_requested_date in date ,
305 p_requesting_office_remarks_de in varchar2 ,
306 p_requesting_office_remarks_fl in varchar2 ,
307 p_request_number in varchar2 ,
308 p_resign_and_retire_reason_des in varchar2 ,
309 p_retirement_plan in varchar2 ,
310 p_retirement_plan_desc in varchar2 ,
311 p_second_action_la_code1 in varchar2 ,
312 p_second_action_la_code2 in varchar2 ,
313 p_second_action_la_desc1 in varchar2 ,
314 p_second_action_la_desc2 in varchar2 ,
315 p_second_noa_cancel_or_correct in varchar2 ,
319 p_second_noa_pa_request_id in number ,
316 p_second_noa_code in varchar2 ,
317 p_second_noa_desc in varchar2 ,
318 p_second_noa_id in number ,
320 p_service_comp_date in date ,
321 p_supervisory_status in varchar2 ,
322 p_tenure in varchar2 ,
323 p_to_adj_basic_pay in number ,
324 p_to_basic_pay in number ,
325 p_to_grade_id in number ,
326 p_to_grade_or_level in varchar2 ,
327 p_to_job_id in number ,
328 p_to_locality_adj in number ,
329 p_to_occ_code in varchar2 ,
330 p_to_organization_id in number ,
331 p_to_other_pay_amount in number ,
332 p_to_au_overtime in number ,
333 p_to_auo_premium_pay_indicator in varchar2 ,
334 p_to_availability_pay in number ,
335 p_to_ap_premium_pay_indicator in varchar2 ,
336 p_to_retention_allowance in number ,
337 p_to_supervisory_differential in number ,
338 p_to_staffing_differential in number ,
339 p_to_pay_basis in varchar2 ,
340 p_to_pay_plan in varchar2 ,
341 p_to_position_id in number ,
342 p_to_position_org_line1 in varchar2 ,
343 p_to_position_org_line2 in varchar2 ,
344 p_to_position_org_line3 in varchar2 ,
345 p_to_position_org_line4 in varchar2 ,
346 p_to_position_org_line5 in varchar2 ,
347 p_to_position_org_line6 in varchar2 ,
348 p_to_position_number in varchar2 ,
349 p_to_position_seq_no in number ,
350 p_to_position_title in varchar2 ,
351 p_to_step_or_rate in varchar2 ,
352 p_to_total_salary in number ,
353 p_veterans_preference in varchar2 ,
354 p_veterans_pref_for_rif in varchar2 ,
355 p_veterans_status in varchar2 ,
356 p_work_schedule in varchar2 ,
357 p_work_schedule_desc in varchar2 ,
358 p_year_degree_attained in number ,
359 p_first_noa_information1 in varchar2 ,
360 p_first_noa_information2 in varchar2 ,
361 p_first_noa_information3 in varchar2 ,
362 p_first_noa_information4 in varchar2 ,
363 p_first_noa_information5 in varchar2 ,
364 p_second_lac1_information1 in varchar2 ,
365 p_second_lac1_information2 in varchar2 ,
366 p_second_lac1_information3 in varchar2 ,
367 p_second_lac1_information4 in varchar2 ,
368 p_second_lac1_information5 in varchar2 ,
369 p_second_lac2_information1 in varchar2 ,
370 p_second_lac2_information2 in varchar2 ,
371 p_second_lac2_information3 in varchar2 ,
372 p_second_lac2_information4 in varchar2 ,
373 p_second_lac2_information5 in varchar2 ,
374 p_second_noa_information1 in varchar2 ,
375 p_second_noa_information2 in varchar2 ,
376 p_second_noa_information3 in varchar2 ,
377 p_second_noa_information4 in varchar2 ,
378 p_second_noa_information5 in varchar2 ,
379 p_first_lac1_information1 in varchar2 ,
380 p_first_lac1_information2 in varchar2 ,
381 p_first_lac1_information3 in varchar2 ,
382 p_first_lac1_information4 in varchar2 ,
383 p_first_lac1_information5 in varchar2 ,
384 p_first_lac2_information1 in varchar2 ,
385 p_first_lac2_information2 in varchar2 ,
386 p_first_lac2_information3 in varchar2 ,
387 p_first_lac2_information4 in varchar2 ,
388 p_first_lac2_information5 in varchar2 ,
389 p_attribute_category in varchar2 ,
390 p_attribute1 in varchar2 ,
391 p_attribute2 in varchar2 ,
392 p_attribute3 in varchar2 ,
393 p_attribute4 in varchar2 ,
394 p_attribute5 in varchar2 ,
395 p_attribute6 in varchar2 ,
396 p_attribute7 in varchar2 ,
397 p_attribute8 in varchar2 ,
398 p_attribute9 in varchar2 ,
399 p_attribute10 in varchar2 ,
400 p_attribute11 in varchar2 ,
401 p_attribute12 in varchar2 ,
402 p_attribute13 in varchar2 ,
403 p_attribute14 in varchar2 ,
404 p_attribute15 in varchar2 ,
405 p_attribute16 in varchar2 ,
406 p_attribute17 in varchar2 ,
407 p_attribute18 in varchar2 ,
408 p_attribute19 in varchar2 ,
409 p_attribute20 in varchar2 ,
410 p_print_sf50_flag in varchar2 ,
411 p_printer_name in varchar2 ,
412 p_u_attachment_modified_flag in varchar2 ,
413 p_u_approved_flag in varchar2 ,
414 p_u_user_name_acted_on in varchar2 ,
415 p_u_action_taken in varchar2 ,
416 p_u_approval_status in varchar2 ,
417 p_i_user_name_routed_to in varchar2 ,
418 p_i_groupbox_id in number ,
419 p_i_routing_list_id in number ,
420 p_i_routing_seq_number in number ,
421 p_capped_other_pay in number ,
422 p_i_pa_routing_history_id in number ,
423 p_i_prh_object_version_number in number ,
424 p_par_object_version_number in number ,
425 p_to_retention_allow_percentag in number ,
426 p_to_supervisory_diff_percenta in number ,
427 p_to_staffing_diff_percentage in number ,
428 p_award_percentage in number ,
429 p_rpa_type in varchar2 ,
430 p_mass_action_id in number ,
431 p_mass_action_eligible_flag in varchar2 ,
432 p_mass_action_select_flag in varchar2 ,
433 p_mass_action_comments in varchar2
434 );
435 --
436 end ghr_sf52_bk2;