[Home] [Help]
PACKAGE BODY: APPS.GHR_PAR_SHD
Source
1 Package Body ghr_par_shd as
2 /* $Header: ghparrhi.pkb 120.5.12010000.3 2008/10/22 07:10:55 utokachi ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ghr_par_shd.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |---------------------------< constraint_error >---------------------------|
12 -- ----------------------------------------------------------------------------
13 Procedure constraint_error
14 (p_constraint_name in all_constraints.constraint_name%TYPE) Is
15 --
16 l_proc varchar2(72) := g_package||'constraint_error';
17 --
18 Begin
19 hr_utility.set_location('Entering:'||l_proc, 5);
20 --
21 If (p_constraint_name = 'GHR_PA_REQUESTS_FK2') Then
22 hr_utility.set_message(8301, 'GHR_38058_INV_FIRST_NOA');
23 hr_utility.raise_error;
24 ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK10') Then
25 hr_utility.set_message(8301, 'GHR_38050_INV_ROUTING_GROUP');
26 hr_utility.raise_error;
27 ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK11') Then -- First_noa_pa_request_id
28 hr_utility.set_message(8301, 'GHR_38199_INV_F_PA_REQ');
29 hr_utility.raise_error;
30 ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK12') Then -- Second Noa_pa_request_id
31 hr_utility.set_message(8301, 'GHR_38125_INV_S_PA_REQ');
32 hr_utility.raise_error;
33 hr_utility.raise_error;
34 ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK13') Then -- Altered Pa_request_id
35 hr_utility.set_message(8301, 'GHR_38126_INV_A_PA_REQ');
36 hr_utility.raise_error;
37 ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK3') Then
38 hr_utility.set_message(8301, 'GHR_38166_INV_SECOND_NOA');
39 hr_utility.raise_error;
40 ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK1') Then
41 hr_utility.set_message(8301, 'GHR_38049_INV_NOA_FAMILY');
42 hr_utility.raise_error;
43 ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK4') Then
44 hr_utility.set_message(8301, 'GHR_38266_INV_TO_PAY_PLAN');
45 hr_utility.raise_error;
46 -- ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK5') Then
47 -- hr_utility.set_message(8301, 'GHR_38057_INV_TO_POSITION');
48 -- hr_utility.raise_error;
49 ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK6') Then
50 hr_utility.set_message(8301, 'GHR_38052_INV_JOB');
51 hr_utility.raise_error;
52 ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK7') Then
53 hr_utility.set_message(8301, 'GHR_38053_INV_GRADE');
54 hr_utility.raise_error;
55 ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK8') Then
56 hr_utility.set_message(8301, 'GHR_38054_INV_ORGANIZATION');
57 hr_utility.raise_error;
58 ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK14') Then
59 hr_utility.set_message(8301, 'GHR_38265_INV_FROM_PAY_PLAN');
60 hr_utility.raise_error;
61 ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_PK') Then
62 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
63 hr_utility.set_message_token('PROCEDURE', l_proc);
64 hr_utility.set_message_token('STEP','70');
65 hr_utility.raise_error;
66 ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_UK1') Then
67 -- hr_utility.set_message(8301, 'GHR_38127_NOTIF_MUST_BE_UNIQ');
68 hr_utility.raise_error;
69 Else
70 hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
71 hr_utility.set_message_token('PROCEDURE', l_proc);
72 hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
73 hr_utility.raise_error;
74 End If;
75 --
76 hr_utility.set_location(' Leaving:'||l_proc, 10);
77 End constraint_error;
78 --
79 -- ----------------------------------------------------------------------------
80 -- |-----------------------------< api_updating >-----------------------------|
81 -- ----------------------------------------------------------------------------
82 Function api_updating
83 (
84 p_pa_request_id in number,
85 p_object_version_number in number
86 ) Return Boolean Is
87 --
88 --
89 -- Cursor selects the 'current' row from the HR Schema
90 --
91 Cursor C_Sel1 is
92 select
93 pa_request_id,
94 pa_notification_id,
95 noa_family_code,
96 routing_group_id,
97 proposed_effective_asap_flag,
98 academic_discipline,
99 additional_info_person_id,
100 additional_info_tel_number,
101 agency_code,
102 altered_pa_request_id,
103 annuitant_indicator,
104 annuitant_indicator_desc,
105 appropriation_code1,
106 appropriation_code2,
107 approval_date,
108 approving_official_full_name,
109 approving_official_work_title,
110 sf50_approval_date,
111 sf50_approving_ofcl_full_name,
112 sf50_approving_ofcl_work_title,
113 authorized_by_person_id,
114 authorized_by_title,
115 award_amount,
116 award_uom,
117 bargaining_unit_status,
118 citizenship,
119 concurrence_date,
120 custom_pay_calc_flag,
121 duty_station_code,
122 duty_station_desc,
123 duty_station_id,
124 duty_station_location_id,
125 education_level,
126 effective_date,
127 employee_assignment_id,
128 employee_date_of_birth,
129 employee_dept_or_agency,
130 employee_first_name,
131 employee_last_name,
132 employee_middle_names,
133 employee_national_identifier,
134 fegli,
135 fegli_desc,
136 first_action_la_code1,
137 first_action_la_code2,
138 first_action_la_desc1,
139 first_action_la_desc2,
140 first_noa_cancel_or_correct,
141 first_noa_code,
142 first_noa_desc,
143 first_noa_id,
144 first_noa_pa_request_id,
145 flsa_category,
146 forwarding_address_line1,
147 forwarding_address_line2,
148 forwarding_address_line3,
149 forwarding_country,
150 forwarding_country_short_name,
151 forwarding_postal_code,
152 forwarding_region_2,
153 forwarding_town_or_city,
154 from_adj_basic_pay,
155 from_agency_code,
156 from_agency_desc,
157 from_basic_pay,
158 from_grade_or_level,
159 from_locality_adj,
160 from_occ_code,
161 from_office_symbol,
162 from_other_pay_amount,
163 from_pay_basis,
164 from_pay_plan,
165 -- FWFA Changes Bug#4444609
166 input_pay_rate_determinant,
167 from_pay_table_identifier,
168 -- FWFA Changes
169 from_position_id,
170 from_position_org_line1,
171 from_position_org_line2,
172 from_position_org_line3,
173 from_position_org_line4,
174 from_position_org_line5,
175 from_position_org_line6,
176 from_position_number,
177 from_position_seq_no,
178 from_position_title,
179 from_step_or_rate,
180 from_total_salary,
181 functional_class,
182 notepad,
183 part_time_hours,
184 pay_rate_determinant,
185 personnel_office_id,
186 person_id,
187 position_occupied,
188 proposed_effective_date,
189 requested_by_person_id,
190 requested_by_title,
191 requested_date,
192 requesting_office_remarks_desc,
193 requesting_office_remarks_flag,
194 request_number,
195 resign_and_retire_reason_desc,
196 retirement_plan,
197 retirement_plan_desc,
198 second_action_la_code1,
199 second_action_la_code2,
200 second_action_la_desc1,
201 second_action_la_desc2,
202 second_noa_cancel_or_correct,
203 second_noa_code,
204 second_noa_desc,
205 second_noa_id,
206 second_noa_pa_request_id,
207 service_comp_date,
208 status,
209 supervisory_status,
210 tenure,
211 to_adj_basic_pay,
212 to_basic_pay,
213 to_grade_id,
214 to_grade_or_level,
215 to_job_id,
216 to_locality_adj,
217 to_occ_code,
218 to_office_symbol,
219 to_organization_id,
220 to_other_pay_amount,
221 to_au_overtime,
222 to_auo_premium_pay_indicator,
223 to_availability_pay,
224 to_ap_premium_pay_indicator,
225 to_retention_allowance,
226 to_supervisory_differential,
227 to_staffing_differential,
228 to_pay_basis,
229 to_pay_plan,
230 -- FWFA Changes Bug#4444609
231 to_pay_table_identifier,
232 -- FWFA Changes
233 to_position_id,
234 to_position_org_line1,
235 to_position_org_line2,
236 to_position_org_line3,
237 to_position_org_line4,
238 to_position_org_line5,
239 to_position_org_line6,
240 to_position_number,
241 to_position_seq_no,
242 to_position_title,
243 to_step_or_rate,
244 to_total_salary,
245 veterans_preference,
246 veterans_pref_for_rif,
247 veterans_status,
248 work_schedule,
249 work_schedule_desc,
250 year_degree_attained,
251 first_noa_information1,
252 first_noa_information2,
253 first_noa_information3,
254 first_noa_information4,
255 first_noa_information5,
256 second_lac1_information1,
257 second_lac1_information2,
258 second_lac1_information3,
259 second_lac1_information4,
260 second_lac1_information5,
261 second_lac2_information1,
262 second_lac2_information2,
263 second_lac2_information3,
264 second_lac2_information4,
265 second_lac2_information5,
266 second_noa_information1,
267 second_noa_information2,
268 second_noa_information3,
269 second_noa_information4,
270 second_noa_information5,
271 first_lac1_information1,
272 first_lac1_information2,
273 first_lac1_information3,
274 first_lac1_information4,
275 first_lac1_information5,
276 first_lac2_information1,
277 first_lac2_information2,
278 first_lac2_information3,
279 first_lac2_information4,
280 first_lac2_information5,
281 attribute_category,
282 attribute1,
283 attribute2,
284 attribute3,
285 attribute4,
286 attribute5,
287 attribute6,
288 attribute7,
289 attribute8,
290 attribute9,
291 attribute10,
292 attribute11,
293 attribute12,
294 attribute13,
295 attribute14,
296 attribute15,
297 attribute16,
298 attribute17,
299 attribute18,
300 attribute19,
301 attribute20,
302 first_noa_canc_pa_request_id ,
303 second_noa_canc_pa_request_id ,
304 to_retention_allow_percentage ,
305 to_supervisory_diff_percentage,
306 to_staffing_diff_percentage ,
307 award_percentage ,
308 rpa_type,
309 mass_action_id,
310 mass_action_eligible_flag,
311 mass_action_select_flag,
312 mass_action_comments,
313 -- Bug# RRR Changes
314 pa_incentive_payment_option,
315 award_salary,
316 -- Bug# RRR Changes
317 object_version_number
318 from ghr_pa_requests
319 where pa_request_id = p_pa_request_id;
320 --
321 l_proc varchar2(72) := g_package||'api_updating';
322 l_fct_ret boolean;
323 --
324 Begin
325 hr_utility.set_location('Entering:'||l_proc, 5);
326 --
327 If (
328 -- p_pa_request_id is null and
329 p_object_version_number is null
330 ) Then
331 --
332 -- One of the primary key arguments is null therefore we must
333 -- set the returning function value to false
334 --
335 l_fct_ret := false;
336 Else
337 If (
338 p_pa_request_id = g_old_rec.pa_request_id and
339 p_object_version_number = g_old_rec.object_version_number
340 ) Then
341 hr_utility.set_location(l_proc, 10);
342 --
343 -- The g_old_rec is current therefore we must
344 -- set the returning function to true
345 --
346 l_fct_ret := true;
347 Else
348 --
349 -- Select the current row into g_old_rec
350 --
351 Open C_Sel1;
352 Fetch C_Sel1 Into g_old_rec;
353 If C_Sel1%notfound Then
354 Close C_Sel1;
355 --
356 -- The primary key is invalid therefore we must error
357 --
358 hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
359 hr_utility.raise_error;
360 End If;
361 Close C_Sel1;
362 If (p_object_version_number <> g_old_rec.object_version_number) Then
363 hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
364 hr_utility.raise_error;
365 End If;
366 hr_utility.set_location(l_proc, 15);
367 l_fct_ret := true;
368 End If;
369 End If;
370 hr_utility.set_location(' Leaving:'||l_proc, 20);
371 Return (l_fct_ret);
372 --
373 End api_updating;
374 --
375 -- ----------------------------------------------------------------------------
376 -- |---------------------------------< lck >----------------------------------|
377 -- ----------------------------------------------------------------------------
378 Procedure lck
379 (
380 p_pa_request_id in number,
381 p_routing_group_id in number,
382 p_object_version_number in number
383 ) is
384 --
385 -- Cursor s the 'current' row from the HR Schema
386 --
387 Cursor C_Sel1 is
388 select
389 pa_request_id,
390 pa_notification_id,
391 noa_family_code,
392 routing_group_id,
393 proposed_effective_asap_flag,
394 academic_discipline,
395 additional_info_person_id,
396 additional_info_tel_number,
397 agency_code,
398 altered_pa_request_id,
399 annuitant_indicator,
400 annuitant_indicator_desc,
401 appropriation_code1,
402 appropriation_code2,
403 approval_date,
404 approving_official_full_name,
405 approving_official_work_title,
406 sf50_approval_date,
407 sf50_approving_ofcl_full_name,
408 sf50_approving_ofcl_work_title,
409 authorized_by_person_id,
410 authorized_by_title,
411 award_amount,
412 award_uom,
413 bargaining_unit_status,
414 citizenship,
415 concurrence_date,
416 custom_pay_calc_flag,
417 duty_station_code,
418 duty_station_desc,
419 duty_station_id,
420 duty_station_location_id,
421 education_level,
422 effective_date,
423 employee_assignment_id,
424 employee_date_of_birth,
425 employee_dept_or_agency,
426 employee_first_name,
427 employee_last_name,
428 employee_middle_names,
429 employee_national_identifier,
430 fegli,
431 fegli_desc,
432 first_action_la_code1,
433 first_action_la_code2,
434 first_action_la_desc1,
435 first_action_la_desc2,
436 first_noa_cancel_or_correct,
437 first_noa_code,
438 first_noa_desc,
439 first_noa_id,
440 first_noa_pa_request_id,
441 flsa_category,
442 forwarding_address_line1,
443 forwarding_address_line2,
444 forwarding_address_line3,
445 forwarding_country,
446 forwarding_country_short_name,
447 forwarding_postal_code,
448 forwarding_region_2,
449 forwarding_town_or_city,
450 from_adj_basic_pay,
451 from_agency_code,
452 from_agency_desc,
453 from_basic_pay,
454 from_grade_or_level,
455 from_locality_adj,
456 from_occ_code,
457 from_office_symbol,
458 from_other_pay_amount,
459 from_pay_basis,
460 from_pay_plan,
461 -- FWFA Changes Bug#4444609
462 input_pay_rate_determinant,
463 from_pay_table_identifier,
464 -- FWFA Changes
465 from_position_id,
466 from_position_org_line1,
467 from_position_org_line2,
468 from_position_org_line3,
469 from_position_org_line4,
470 from_position_org_line5,
471 from_position_org_line6,
472 from_position_number,
473 from_position_seq_no,
474 from_position_title,
475 from_step_or_rate,
476 from_total_salary,
477 functional_class,
478 notepad,
479 part_time_hours,
480 pay_rate_determinant,
481 personnel_office_id,
482 person_id,
483 position_occupied,
484 proposed_effective_date,
485 requested_by_person_id,
486 requested_by_title,
487 requested_date,
491 resign_and_retire_reason_desc,
488 requesting_office_remarks_desc,
489 requesting_office_remarks_flag,
490 request_number,
492 retirement_plan,
493 retirement_plan_desc,
494 second_action_la_code1,
495 second_action_la_code2,
496 second_action_la_desc1,
497 second_action_la_desc2,
498 second_noa_cancel_or_correct,
499 second_noa_code,
500 second_noa_desc,
501 second_noa_id,
502 second_noa_pa_request_id,
503 service_comp_date,
504 status,
505 supervisory_status,
506 tenure,
507 to_adj_basic_pay,
508 to_basic_pay,
509 to_grade_id,
510 to_grade_or_level,
511 to_job_id,
512 to_locality_adj,
513 to_occ_code,
514 to_office_symbol,
515 to_organization_id,
516 to_other_pay_amount,
517 to_au_overtime,
518 to_auo_premium_pay_indicator,
519 to_availability_pay,
520 to_ap_premium_pay_indicator,
521 to_retention_allowance,
522 to_supervisory_differential,
523 to_staffing_differential,
524 to_pay_basis,
525 to_pay_plan,
526 -- FWFA Changes Bug#4444609
527 to_pay_table_identifier,
528 -- FWFA Changes
529 to_position_id,
530 to_position_org_line1,
531 to_position_org_line2,
532 to_position_org_line3,
533 to_position_org_line4,
534 to_position_org_line5,
535 to_position_org_line6,
536 to_position_number,
537 to_position_seq_no,
538 to_position_title,
539 to_step_or_rate,
540 to_total_salary,
541 veterans_preference,
542 veterans_pref_for_rif,
543 veterans_status,
544 work_schedule,
545 work_schedule_desc,
546 year_degree_attained,
547 first_noa_information1,
548 first_noa_information2,
549 first_noa_information3,
550 first_noa_information4,
551 first_noa_information5,
552 second_lac1_information1,
553 second_lac1_information2,
554 second_lac1_information3,
555 second_lac1_information4,
556 second_lac1_information5,
557 second_lac2_information1,
558 second_lac2_information2,
559 second_lac2_information3,
560 second_lac2_information4,
561 second_lac2_information5,
562 second_noa_information1,
563 second_noa_information2,
564 second_noa_information3,
565 second_noa_information4,
566 second_noa_information5,
567 first_lac1_information1,
568 first_lac1_information2,
569 first_lac1_information3,
570 first_lac1_information4,
571 first_lac1_information5,
572 first_lac2_information1,
573 first_lac2_information2,
574 first_lac2_information3,
575 first_lac2_information4,
576 first_lac2_information5,
577 attribute_category,
578 attribute1,
579 attribute2,
580 attribute3,
581 attribute4,
582 attribute5,
583 attribute6,
584 attribute7,
585 attribute8,
586 attribute9,
587 attribute10,
588 attribute11,
589 attribute12,
590 attribute13,
591 attribute14,
592 attribute15,
593 attribute16,
594 attribute17,
595 attribute18,
596 attribute19,
597 attribute20,
598 first_noa_canc_pa_request_id ,
599 second_noa_canc_pa_request_id ,
600 to_retention_allow_percentage ,
601 to_supervisory_diff_percentage,
602 to_staffing_diff_percentage ,
603 award_percentage ,
604 rpa_type,
605 mass_action_id,
606 mass_action_eligible_flag,
607 mass_action_select_flag,
608 mass_action_comments,
609 -- Bug# RRR Changes
610 pa_incentive_payment_option,
611 award_salary,
612 -- Bug# RRR Changes
613 object_version_number
614 from ghr_pa_requests
615 where pa_request_id = p_pa_request_id
616 for update nowait;
617 --
618 l_proc varchar2(72) := g_package||'lck';
619 --
620 Begin
621 hr_utility.set_location('Entering:'||l_proc, 5);
622 --
623 -- Add any mandatory argument checking here:
624 -- Example:
625 -- hr_api.mandatory_arg_error
626 -- (p_api_name => l_proc,
627 -- p_argument => 'object_version_number',
628 -- p_argument_value => p_object_version_number);
629 --
630 /* hr_api.mandatory_arg_error
631 (p_api_name => l_proc,
632 p_argument => 'routing_group_id',
633 p_argument_value => p_routing_group_id);
634 */
635
636
637 Open C_Sel1;
638 Fetch C_Sel1 Into g_old_rec;
639 If C_Sel1%notfound then
640 Close C_Sel1;
641 --
642 -- The primary key is invalid therefore we must error
643 --
644 hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
645 hr_utility.raise_error;
646 End If;
647 Close C_Sel1;
648 If (p_object_version_number <> g_old_rec.object_version_number) Then
649 hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
650 hr_utility.raise_error;
651 End If;
652 --
653 hr_utility.set_location(' Leaving:'||l_proc, 10);
654 --
655 -- We need to trap the ORA LOCK exception
656 --
657 Exception
658 When HR_Api.Object_Locked then
659 --
660 -- The object is locked therefore we need to supply a meaningful
661 -- error message.
662 --
666 End lck;
663 hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
664 hr_utility.set_message_token('TABLE_NAME', 'ghr_pa_requests');
665 hr_utility.raise_error;
667 --
668 -- ----------------------------------------------------------------------------
669 -- |-----------------------------< convert_args >-----------------------------|
670 -- ----------------------------------------------------------------------------
671 Function convert_args
672 (
673 p_pa_request_id in number,
674 p_pa_notification_id in number,
675 p_noa_family_code in varchar2,
676 p_routing_group_id in number,
677 p_proposed_effective_asap_flag in varchar2,
678 p_academic_discipline in varchar2,
679 p_additional_info_person_id in number,
680 p_additional_info_tel_number in varchar2,
681 p_agency_code in varchar2,
682 p_altered_pa_request_id in number,
683 p_annuitant_indicator in varchar2,
684 p_annuitant_indicator_desc in varchar2,
685 p_appropriation_code1 in varchar2,
686 p_appropriation_code2 in varchar2,
687 p_approval_date in date,
688 p_approving_official_full_name in varchar2,
689 p_approving_official_work_titl in varchar2,
690 p_sf50_approval_date in date,
691 p_sf50_approving_ofcl_full_nam in varchar2,
692 p_sf50_approving_ofcl_work_tit in varchar2,
693 p_authorized_by_person_id in number,
694 p_authorized_by_title in varchar2,
695 p_award_amount in number,
696 p_award_uom in varchar2,
697 p_bargaining_unit_status in varchar2,
698 p_citizenship in varchar2,
699 p_concurrence_date in date,
700 p_custom_pay_calc_flag in varchar2,
701 p_duty_station_code in varchar2,
702 p_duty_station_desc in varchar2,
703 p_duty_station_id in number,
704 p_duty_station_location_id in number,
705 p_education_level in varchar2,
706 p_effective_date in date,
707 p_employee_assignment_id in number,
708 p_employee_date_of_birth in date,
709 p_employee_dept_or_agency in varchar2,
710 p_employee_first_name in varchar2,
711 p_employee_last_name in varchar2,
712 p_employee_middle_names in varchar2,
713 p_employee_national_identifier in varchar2,
714 p_fegli in varchar2,
715 p_fegli_desc in varchar2,
716 p_first_action_la_code1 in varchar2,
717 p_first_action_la_code2 in varchar2,
718 p_first_action_la_desc1 in varchar2,
719 p_first_action_la_desc2 in varchar2,
720 p_first_noa_cancel_or_correct in varchar2,
721 p_first_noa_code in varchar2,
722 p_first_noa_desc in varchar2,
723 p_first_noa_id in number,
724 p_first_noa_pa_request_id in number,
725 p_flsa_category in varchar2,
726 p_forwarding_address_line1 in varchar2,
727 p_forwarding_address_line2 in varchar2,
728 p_forwarding_address_line3 in varchar2,
729 p_forwarding_country in varchar2,
730 p_forwarding_country_short_nam in varchar2,
731 p_forwarding_postal_code in varchar2,
732 p_forwarding_region_2 in varchar2,
733 p_forwarding_town_or_city in varchar2,
734 p_from_adj_basic_pay in number,
735 p_from_agency_code in varchar2,
736 p_from_agency_desc in varchar2,
737 p_from_basic_pay in number,
738 p_from_grade_or_level in varchar2,
739 p_from_locality_adj in number,
740 p_from_occ_code in varchar2,
741 p_from_office_symbol in varchar2,
742 p_from_other_pay_amount in number,
743 p_from_pay_basis in varchar2,
744 p_from_pay_plan in varchar2,
745 -- FWFA Changes Bug#4444609
746 p_input_pay_rate_determinant in varchar2,
747 p_from_pay_table_identifier in number,
748 -- FWFA Changes
749 p_from_position_id in number,
750 p_from_position_org_line1 in varchar2,
751 p_from_position_org_line2 in varchar2,
752 p_from_position_org_line3 in varchar2,
753 p_from_position_org_line4 in varchar2,
754 p_from_position_org_line5 in varchar2,
755 p_from_position_org_line6 in varchar2,
756 p_from_position_number in varchar2,
757 p_from_position_seq_no in number,
758 p_from_position_title in varchar2,
759 p_from_step_or_rate in varchar2,
760 p_from_total_salary in number,
761 p_functional_class in varchar2,
762 p_notepad in varchar2,
763 p_part_time_hours in number,
764 p_pay_rate_determinant in varchar2,
765 p_personnel_office_id in varchar2,
766 p_person_id in number,
767 p_position_occupied in varchar2,
768 p_proposed_effective_date in date,
769 p_requested_by_person_id in number,
770 p_requested_by_title in varchar2,
771 p_requested_date in date,
772 p_requesting_office_remarks_de in varchar2,
773 p_requesting_office_remarks_fl in varchar2,
774 p_request_number in varchar2,
775 p_resign_and_retire_reason_des in varchar2,
779 p_second_action_la_code2 in varchar2,
776 p_retirement_plan in varchar2,
777 p_retirement_plan_desc in varchar2,
778 p_second_action_la_code1 in varchar2,
780 p_second_action_la_desc1 in varchar2,
781 p_second_action_la_desc2 in varchar2,
782 p_second_noa_cancel_or_correct in varchar2,
783 p_second_noa_code in varchar2,
784 p_second_noa_desc in varchar2,
785 p_second_noa_id in number,
786 p_second_noa_pa_request_id in number,
787 p_service_comp_date in date,
788 p_status in varchar2,
789 p_supervisory_status in varchar2,
790 p_tenure in varchar2,
791 p_to_adj_basic_pay in number,
792 p_to_basic_pay in number,
793 p_to_grade_id in number,
794 p_to_grade_or_level in varchar2,
795 p_to_job_id in number,
796 p_to_locality_adj in number,
797 p_to_occ_code in varchar2,
798 p_to_office_symbol in varchar2,
799 p_to_organization_id in number,
800 p_to_other_pay_amount in number,
801 p_to_au_overtime in number,
802 p_to_auo_premium_pay_indicator in varchar2,
803 p_to_availability_pay in number,
804 p_to_ap_premium_pay_indicator in varchar2,
805 p_to_retention_allowance in number,
806 p_to_supervisory_differential in number,
807 p_to_staffing_differential in number,
808 p_to_pay_basis in varchar2,
809 p_to_pay_plan in varchar2,
810 -- FWFA Changes Bug#4444609
811 p_to_pay_table_identifier in number,
812 -- FWFA Changes
813 p_to_position_id in number,
814 p_to_position_org_line1 in varchar2,
815 p_to_position_org_line2 in varchar2,
816 p_to_position_org_line3 in varchar2,
817 p_to_position_org_line4 in varchar2,
818 p_to_position_org_line5 in varchar2,
819 p_to_position_org_line6 in varchar2,
820 p_to_position_number in varchar2,
821 p_to_position_seq_no in number,
822 p_to_position_title in varchar2,
823 p_to_step_or_rate in varchar2,
824 p_to_total_salary in number,
825 p_veterans_preference in varchar2,
826 p_veterans_pref_for_rif in varchar2,
827 p_veterans_status in varchar2,
828 p_work_schedule in varchar2,
829 p_work_schedule_desc in varchar2,
830 p_year_degree_attained in number,
831 p_first_noa_information1 in varchar2,
832 p_first_noa_information2 in varchar2,
833 p_first_noa_information3 in varchar2,
834 p_first_noa_information4 in varchar2,
835 p_first_noa_information5 in varchar2,
836 p_second_lac1_information1 in varchar2,
837 p_second_lac1_information2 in varchar2,
838 p_second_lac1_information3 in varchar2,
839 p_second_lac1_information4 in varchar2,
840 p_second_lac1_information5 in varchar2,
841 p_second_lac2_information1 in varchar2,
842 p_second_lac2_information2 in varchar2,
843 p_second_lac2_information3 in varchar2,
844 p_second_lac2_information4 in varchar2,
845 p_second_lac2_information5 in varchar2,
846 p_second_noa_information1 in varchar2,
847 p_second_noa_information2 in varchar2,
848 p_second_noa_information3 in varchar2,
849 p_second_noa_information4 in varchar2,
850 p_second_noa_information5 in varchar2,
851 p_first_lac1_information1 in varchar2,
852 p_first_lac1_information2 in varchar2,
853 p_first_lac1_information3 in varchar2,
854 p_first_lac1_information4 in varchar2,
855 p_first_lac1_information5 in varchar2,
856 p_first_lac2_information1 in varchar2,
857 p_first_lac2_information2 in varchar2,
858 p_first_lac2_information3 in varchar2,
859 p_first_lac2_information4 in varchar2,
860 p_first_lac2_information5 in varchar2,
861 p_attribute_category in varchar2,
862 p_attribute1 in varchar2,
863 p_attribute2 in varchar2,
864 p_attribute3 in varchar2,
865 p_attribute4 in varchar2,
866 p_attribute5 in varchar2,
867 p_attribute6 in varchar2,
868 p_attribute7 in varchar2,
869 p_attribute8 in varchar2,
870 p_attribute9 in varchar2,
871 p_attribute10 in varchar2,
872 p_attribute11 in varchar2,
873 p_attribute12 in varchar2,
874 p_attribute13 in varchar2,
875 p_attribute14 in varchar2,
876 p_attribute15 in varchar2,
877 p_attribute16 in varchar2,
878 p_attribute17 in varchar2,
879 p_attribute18 in varchar2,
880 p_attribute19 in varchar2,
881 p_attribute20 in varchar2,
882 p_first_noa_canc_pa_request_id in number ,
883 p_second_noa_canc_pa_request_i in number ,
887 p_award_percentage in number ,
884 p_to_retention_allow_percentag in number ,
885 p_to_supervisory_diff_percenta in number ,
886 p_to_staffing_diff_percentage in number ,
888 p_rpa_type in varchar2,
889 p_mass_action_id in number ,
890 p_mass_action_eligible_flag in varchar2,
891 p_mass_action_select_flag in varchar2,
892 p_mass_action_comments in varchar2,
893 -- Bug#4486823 RRR Changes
894 p_payment_option in varchar2,
895 p_award_salary in number,
896 -- Bug#4486823 RRR Changes
897 p_object_version_number in number
898 )
899 Return g_rec_type is
900 --
901 l_rec g_rec_type;
902 l_proc varchar2(72) := g_package||'convert_args';
903 --
904 Begin
905 --
906 hr_utility.set_location('Entering:'||l_proc, 5);
907 --
908 -- Convert arguments into local l_rec structure.
909 --
910 l_rec.pa_request_id := p_pa_request_id;
911 l_rec.pa_notification_id := p_pa_notification_id;
912 l_rec.noa_family_code := p_noa_family_code;
913 l_rec.routing_group_id := p_routing_group_id;
914 l_rec.proposed_effective_asap_flag := p_proposed_effective_asap_flag;
915 l_rec.academic_discipline := p_academic_discipline;
916 l_rec.additional_info_person_id := p_additional_info_person_id;
917 l_rec.additional_info_tel_number := p_additional_info_tel_number;
918 l_rec.agency_code := p_agency_code;
919 l_rec.altered_pa_request_id := p_altered_pa_request_id;
920 l_rec.annuitant_indicator := p_annuitant_indicator;
921 l_rec.annuitant_indicator_desc := p_annuitant_indicator_desc;
922 l_rec.appropriation_code1 := p_appropriation_code1;
923 l_rec.appropriation_code2 := p_appropriation_code2;
924 l_rec.approval_date := p_approval_date;
925 l_rec.approving_official_full_name := p_approving_official_full_name;
926 l_rec.approving_official_work_title := p_approving_official_work_titl;
927 l_rec.sf50_approval_date := p_sf50_approval_date;
928 l_rec.sf50_approving_ofcl_full_name := p_sf50_approving_ofcl_full_nam;
929 l_rec.sf50_approving_ofcl_work_title := p_sf50_approving_ofcl_work_tit;
930 l_rec.authorized_by_person_id := p_authorized_by_person_id;
931 l_rec.authorized_by_title := p_authorized_by_title;
932 l_rec.award_amount := p_award_amount;
933 hr_utility.set_location('Before awarduom', 1);
934 hr_utility.set_location('Award UOM' || p_award_uom,1);
935 l_rec.award_uom := p_award_uom;
936 hr_utility.set_location('L Award UOM' || l_rec.award_uom,1);
937 l_rec.bargaining_unit_status := p_bargaining_unit_status;
938 l_rec.citizenship := p_citizenship;
939 l_rec.concurrence_date := p_concurrence_date;
940 l_rec.custom_pay_calc_flag := p_custom_pay_calc_flag;
941 l_rec.duty_station_code := p_duty_station_code;
942 l_rec.duty_station_desc := p_duty_station_desc;
943 l_rec.duty_station_id := p_duty_station_id;
944 l_rec.duty_station_location_id := p_duty_station_location_id;
945 l_rec.education_level := p_education_level;
946 l_rec.effective_date := p_effective_date;
947 l_rec.employee_assignment_id := p_employee_assignment_id;
948 l_rec.employee_date_of_birth := p_employee_date_of_birth;
949 l_rec.employee_dept_or_agency := p_employee_dept_or_agency;
950 l_rec.employee_first_name := p_employee_first_name;
951 l_rec.employee_last_name := p_employee_last_name;
952 l_rec.employee_middle_names := p_employee_middle_names;
953 l_rec.employee_national_identifier := p_employee_national_identifier;
954 l_rec.fegli := p_fegli;
955 l_rec.fegli_desc := p_fegli_desc;
956 l_rec.first_action_la_code1 := p_first_action_la_code1;
957 l_rec.first_action_la_code2 := p_first_action_la_code2;
958 l_rec.first_action_la_desc1 := p_first_action_la_desc1;
959 l_rec.first_action_la_desc2 := p_first_action_la_desc2;
960 l_rec.first_noa_cancel_or_correct := p_first_noa_cancel_or_correct;
961 l_rec.first_noa_code := p_first_noa_code;
962 l_rec.first_noa_desc := p_first_noa_desc;
963 l_rec.first_noa_id := p_first_noa_id;
964 l_rec.first_noa_pa_request_id := p_first_noa_pa_request_id;
965 l_rec.flsa_category := p_flsa_category;
966 l_rec.forwarding_address_line1 := p_forwarding_address_line1;
967 l_rec.forwarding_address_line2 := p_forwarding_address_line2;
968 l_rec.forwarding_address_line3 := p_forwarding_address_line3;
969 l_rec.forwarding_country := p_forwarding_country;
970 l_rec.forwarding_country_short_name := p_forwarding_country_short_nam;
971 l_rec.forwarding_postal_code := p_forwarding_postal_code;
972 l_rec.forwarding_region_2 := p_forwarding_region_2;
973 l_rec.forwarding_town_or_city := p_forwarding_town_or_city;
977 l_rec.from_basic_pay := p_from_basic_pay;
974 l_rec.from_adj_basic_pay := p_from_adj_basic_pay;
975 l_rec.from_agency_code := p_from_agency_code;
976 l_rec.from_agency_desc := p_from_agency_desc;
978 l_rec.from_grade_or_level := p_from_grade_or_level;
979 l_rec.from_locality_adj := p_from_locality_adj;
980 l_rec.from_occ_code := p_from_occ_code;
981 l_rec.from_office_symbol := p_from_office_symbol;
982 l_rec.from_other_pay_amount := p_from_other_pay_amount;
983 l_rec.from_pay_basis := p_from_pay_basis;
984 l_rec.from_pay_plan := p_from_pay_plan;
985 -- FWFA Changes Bug#4444609
986 l_rec.input_pay_rate_determinant := p_input_pay_rate_determinant;
987 l_rec.from_pay_table_identifier := p_from_pay_table_identifier;
988 -- FWFA Changes
989 l_rec.from_position_id := p_from_position_id;
990 l_rec.from_position_org_line1 := p_from_position_org_line1;
991 l_rec.from_position_org_line2 := p_from_position_org_line2;
992 l_rec.from_position_org_line3 := p_from_position_org_line3;
993 l_rec.from_position_org_line4 := p_from_position_org_line4;
994 l_rec.from_position_org_line5 := p_from_position_org_line5;
995 l_rec.from_position_org_line6 := p_from_position_org_line6;
996 l_rec.from_position_number := p_from_position_number;
997 l_rec.from_position_seq_no := p_from_position_seq_no;
998 l_rec.from_position_title := p_from_position_title;
999 l_rec.from_step_or_rate := p_from_step_or_rate;
1000 l_rec.from_total_salary := p_from_total_salary;
1001 l_rec.functional_class := p_functional_class;
1002 l_rec.notepad := p_notepad;
1003 l_rec.part_time_hours := p_part_time_hours;
1004 l_rec.pay_rate_determinant := p_pay_rate_determinant;
1005 l_rec.personnel_office_id := p_personnel_office_id;
1006 l_rec.person_id := p_person_id;
1007 l_rec.position_occupied := p_position_occupied;
1008 l_rec.proposed_effective_date := p_proposed_effective_date;
1009 l_rec.requested_by_person_id := p_requested_by_person_id;
1010 l_rec.requested_by_title := p_requested_by_title;
1011 l_rec.requested_date := p_requested_date;
1012 l_rec.requesting_office_remarks_desc := p_requesting_office_remarks_de;
1013 l_rec.requesting_office_remarks_flag := p_requesting_office_remarks_fl;
1014 l_rec.request_number := p_request_number;
1015 l_rec.resign_and_retire_reason_desc := p_resign_and_retire_reason_des;
1016 l_rec.retirement_plan := p_retirement_plan;
1017 l_rec.retirement_plan_desc := p_retirement_plan_desc;
1018 l_rec.second_action_la_code1 := p_second_action_la_code1;
1019 l_rec.second_action_la_code2 := p_second_action_la_code2;
1020 l_rec.second_action_la_desc1 := p_second_action_la_desc1;
1021 l_rec.second_action_la_desc2 := p_second_action_la_desc2;
1022 l_rec.second_noa_cancel_or_correct := p_second_noa_cancel_or_correct;
1023 l_rec.second_noa_code := p_second_noa_code;
1024 l_rec.second_noa_desc := p_second_noa_desc;
1025 l_rec.second_noa_id := p_second_noa_id;
1026 l_rec.second_noa_pa_request_id := p_second_noa_pa_request_id;
1027 l_rec.service_comp_date := p_service_comp_date;
1028 l_rec.status := p_status;
1029 l_rec.supervisory_status := p_supervisory_status;
1030 l_rec.tenure := p_tenure;
1031 l_rec.to_adj_basic_pay := p_to_adj_basic_pay;
1032 l_rec.to_basic_pay := p_to_basic_pay;
1033 l_rec.to_grade_id := p_to_grade_id;
1034 l_rec.to_grade_or_level := p_to_grade_or_level;
1035 l_rec.to_job_id := p_to_job_id;
1036 l_rec.to_locality_adj := p_to_locality_adj;
1037 l_rec.to_occ_code := p_to_occ_code;
1038 l_rec.to_office_symbol := p_to_office_symbol;
1039 l_rec.to_organization_id := p_to_organization_id;
1040 l_rec.to_other_pay_amount := p_to_other_pay_amount;
1041 l_rec.to_au_overtime := p_to_au_overtime;
1042 l_rec.to_auo_premium_pay_indicator := p_to_auo_premium_pay_indicator;
1043 l_rec.to_availability_pay := p_to_availability_pay;
1044 l_rec.to_ap_premium_pay_indicator := p_to_ap_premium_pay_indicator;
1045 l_rec.to_retention_allowance := p_to_retention_allowance;
1046 l_rec.to_supervisory_differential := p_to_supervisory_differential;
1047 l_rec.to_staffing_differential := p_to_staffing_differential;
1048 l_rec.to_pay_basis := p_to_pay_basis;
1049 l_rec.to_pay_plan := p_to_pay_plan;
1050 -- FWFA Changes Bug#4444609
1051 l_rec.to_pay_table_identifier := p_to_pay_table_identifier;
1052 -- FWFA Changes
1053 l_rec.to_position_id := p_to_position_id;
1054 l_rec.to_position_org_line1 := p_to_position_org_line1;
1055 l_rec.to_position_org_line2 := p_to_position_org_line2;
1059 l_rec.to_position_org_line6 := p_to_position_org_line6;
1056 l_rec.to_position_org_line3 := p_to_position_org_line3;
1057 l_rec.to_position_org_line4 := p_to_position_org_line4;
1058 l_rec.to_position_org_line5 := p_to_position_org_line5;
1060 l_rec.to_position_number := p_to_position_number;
1061 l_rec.to_position_seq_no := p_to_position_seq_no;
1062 l_rec.to_position_title := p_to_position_title;
1063 l_rec.to_step_or_rate := p_to_step_or_rate;
1064 l_rec.to_total_salary := p_to_total_salary;
1065 l_rec.veterans_preference := p_veterans_preference;
1066 l_rec.veterans_pref_for_rif := p_veterans_pref_for_rif;
1067 l_rec.veterans_status := p_veterans_status;
1068 l_rec.work_schedule := p_work_schedule;
1069 l_rec.work_schedule_desc := p_work_schedule_desc;
1070 l_rec.year_degree_attained := p_year_degree_attained;
1071 l_rec.first_noa_information1 := p_first_noa_information1;
1072 l_rec.first_noa_information2 := p_first_noa_information2;
1073 l_rec.first_noa_information3 := p_first_noa_information3;
1074 l_rec.first_noa_information4 := p_first_noa_information4;
1075 l_rec.first_noa_information5 := p_first_noa_information5;
1076 l_rec.second_lac1_information1 := p_second_lac1_information1;
1077 l_rec.second_lac1_information2 := p_second_lac1_information2;
1078 l_rec.second_lac1_information3 := p_second_lac1_information3;
1079 l_rec.second_lac1_information4 := p_second_lac1_information4;
1080 l_rec.second_lac1_information5 := p_second_lac1_information5;
1081 l_rec.second_lac2_information1 := p_second_lac2_information1;
1082 l_rec.second_lac2_information2 := p_second_lac2_information2;
1083 l_rec.second_lac2_information3 := p_second_lac2_information3;
1084 l_rec.second_lac2_information4 := p_second_lac2_information4;
1085 l_rec.second_lac2_information5 := p_second_lac2_information5;
1086 l_rec.second_noa_information1 := p_second_noa_information1;
1087 l_rec.second_noa_information2 := p_second_noa_information2;
1088 l_rec.second_noa_information3 := p_second_noa_information3;
1089 l_rec.second_noa_information4 := p_second_noa_information4;
1090 l_rec.second_noa_information5 := p_second_noa_information5;
1091 l_rec.first_lac1_information1 := p_first_lac1_information1;
1092 l_rec.first_lac1_information2 := p_first_lac1_information2;
1093 l_rec.first_lac1_information3 := p_first_lac1_information3;
1094 l_rec.first_lac1_information4 := p_first_lac1_information4;
1095 l_rec.first_lac1_information5 := p_first_lac1_information5;
1096 l_rec.first_lac2_information1 := p_first_lac2_information1;
1097 l_rec.first_lac2_information2 := p_first_lac2_information2;
1098 l_rec.first_lac2_information3 := p_first_lac2_information3;
1099 l_rec.first_lac2_information4 := p_first_lac2_information4;
1100 l_rec.first_lac2_information5 := p_first_lac2_information5;
1101 l_rec.attribute_category := p_attribute_category;
1102 l_rec.attribute1 := p_attribute1;
1103 l_rec.attribute2 := p_attribute2;
1104 l_rec.attribute3 := p_attribute3;
1105 l_rec.attribute4 := p_attribute4;
1106 l_rec.attribute5 := p_attribute5;
1107 l_rec.attribute6 := p_attribute6;
1108 l_rec.attribute7 := p_attribute7;
1109 l_rec.attribute8 := p_attribute8;
1110 l_rec.attribute9 := p_attribute9;
1111 l_rec.attribute10 := p_attribute10;
1112 l_rec.attribute11 := p_attribute11;
1113 l_rec.attribute12 := p_attribute12;
1114 l_rec.attribute13 := p_attribute13;
1115 l_rec.attribute14 := p_attribute14;
1116 l_rec.attribute15 := p_attribute15;
1117 l_rec.attribute16 := p_attribute16;
1118 l_rec.attribute17 := p_attribute17;
1119 l_rec.attribute18 := p_attribute18;
1120 l_rec.attribute19 := p_attribute19;
1121 l_rec.attribute20 := p_attribute20;
1122 l_rec.object_version_number := p_object_version_number;
1123 l_rec.first_noa_canc_pa_request_id := p_first_noa_canc_pa_request_id;
1124 l_rec.second_noa_canc_pa_request_id := p_second_noa_canc_pa_request_i;
1125 hr_utility.set_location('Before all per', 1);
1126 l_rec.to_retention_allow_percentage := p_to_retention_allow_percentag;
1127 l_rec.to_supervisory_diff_percentage := p_to_supervisory_diff_percenta;
1128 l_rec.to_staffing_diff_percentage := p_to_staffing_diff_percentage;
1129 hr_utility.set_location('Before awardper', 1);
1130 l_rec.award_percentage := p_award_percentage;
1131 hr_utility.set_location('Before RPA Type', 1);
1132 hr_utility.set_location('RPA Type ' || p_rpa_type,1);
1133 l_rec.rpa_type := p_rpa_type;
1134 hr_utility.set_location('after RPA Type', 1);
1135 l_rec.mass_action_id := p_mass_action_id;
1136 hr_utility.set_location('after massactg', 1);
1137 l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
1138 hr_utility.set_location('elig flag value is ' || l_rec.mass_action_eligible_flag , 1);
1139 l_rec.mass_action_select_flag := p_mass_action_select_flag;
1140 hr_utility.set_location('after seleflag', 1);
1141 l_rec.mass_action_comments := p_mass_action_comments;
1142 -- Bug#4486823 RRR Changes
1143 l_rec.payment_option := p_payment_option;
1144 l_rec.award_salary := p_award_salary ;
1145 -- Bug#4486823 RRR Changes
1146 hr_utility.set_location('after comments', 1);
1147 --
1148 -- Return the plsql record structure.
1149 --
1150 hr_utility.set_location(' Leaving:'||l_proc, 10);
1151 Return(l_rec);
1152 --
1153 End convert_args;
1154 --
1155 end ghr_par_shd;