[Home] [Help]
PACKAGE BODY: APPS.GHR_PAR_INS
Source
1 Package Body ghr_par_ins 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_ins.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< insert_dml >------------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the actual dml insert logic. The processing of
17 -- this procedure are as follows:
18 -- 1) Initialise the object_version_number to 1 if the object_version_number
19 -- is defined as an attribute for this entity.
20 -- 2) To insert the row into the schema.
21 -- 3) To trap any constraint violations that may have occurred.
22 -- 4) To raise any other errors.
23 --
24 -- Prerequisites:
25 -- This is an internal private procedure which must be called from the ins
26 -- procedure and must have all mandatory attributes set (except the
27 -- object_version_number which is initialised within this procedure).
28 --
29 -- In Parameters:
30 -- A Pl/Sql record structre.
31 --
32 -- Post Success:
33 -- The specified row will be inserted into the schema.
34 --
35 -- Post Failure:
36 -- If a check, unique or parent integrity constraint violation is raised the
37 -- constraint_error procedure will be called.
38 --
39 -- Developer Implementation Notes:
40 -- None.
41 --
42 -- Access Status:
43 -- Internal Row Handler Use Only.
44 --
45 -- {End Of Comments}
46 -- ----------------------------------------------------------------------------
47 Procedure insert_dml(p_rec in out nocopy ghr_par_shd.g_rec_type) is
48 --
49 l_proc varchar2(72) := g_package||'insert_dml';
50 --
51 Begin
52 hr_utility.set_location('Entering:'||l_proc, 5);
53 p_rec.object_version_number := 1; -- Initialise the object version
54 --
55 --
56 -- Insert the row into: ghr_pa_requests
57 --
58 insert into ghr_pa_requests
59 ( pa_request_id,
60 pa_notification_id,
61 noa_family_code,
62 routing_group_id,
63 proposed_effective_asap_flag,
64 academic_discipline,
65 additional_info_person_id,
66 additional_info_tel_number,
67 agency_code,
68 altered_pa_request_id,
69 annuitant_indicator,
70 annuitant_indicator_desc,
71 appropriation_code1,
72 appropriation_code2,
73 approval_date,
74 approving_official_full_name,
75 approving_official_work_title,
76 sf50_approval_date,
77 sf50_approving_ofcl_full_name,
78 sf50_approving_ofcl_work_title,
79 authorized_by_person_id,
80 authorized_by_title,
81 award_amount,
82 award_uom,
83 bargaining_unit_status,
84 citizenship,
85 concurrence_date,
86 custom_pay_calc_flag,
87 duty_station_code,
88 duty_station_desc,
89 duty_station_id,
90 duty_station_location_id,
91 education_level,
92 effective_date,
93 employee_assignment_id,
94 employee_date_of_birth,
95 employee_dept_or_agency,
96 employee_first_name,
97 employee_last_name,
98 employee_middle_names,
99 employee_national_identifier,
100 fegli,
101 fegli_desc,
102 first_action_la_code1,
103 first_action_la_code2,
104 first_action_la_desc1,
105 first_action_la_desc2,
106 first_noa_cancel_or_correct,
107 first_noa_code,
108 first_noa_desc,
109 first_noa_id,
110 first_noa_pa_request_id,
111 flsa_category,
112 forwarding_address_line1,
113 forwarding_address_line2,
114 forwarding_address_line3,
115 forwarding_country,
116 forwarding_country_short_name,
117 forwarding_postal_code,
118 forwarding_region_2,
119 forwarding_town_or_city,
120 from_adj_basic_pay,
121 from_agency_code,
122 from_agency_desc,
123 from_basic_pay,
124 from_grade_or_level,
125 from_locality_adj,
126 from_occ_code,
127 from_office_symbol,
128 from_other_pay_amount,
129 from_pay_basis,
130 from_pay_plan,
131 -- FWFA Changes Bug#4444609
132 input_pay_rate_determinant,
133 from_pay_table_identifier,
134 -- FWFA Changes
135 from_position_id,
136 from_position_org_line1,
137 from_position_org_line2,
138 from_position_org_line3,
139 from_position_org_line4,
140 from_position_org_line5,
141 from_position_org_line6,
142 from_position_number,
143 from_position_seq_no,
144 from_position_title,
145 from_step_or_rate,
146 from_total_salary,
147 functional_class,
148 notepad,
149 part_time_hours,
150 pay_rate_determinant,
151 personnel_office_id,
152 person_id,
153 position_occupied,
154 proposed_effective_date,
155 requested_by_person_id,
156 requested_by_title,
157 requested_date,
158 requesting_office_remarks_desc,
159 requesting_office_remarks_flag,
160 request_number,
161 resign_and_retire_reason_desc,
162 retirement_plan,
163 retirement_plan_desc,
164 second_action_la_code1,
165 second_action_la_code2,
166 second_action_la_desc1,
167 second_action_la_desc2,
168 second_noa_cancel_or_correct,
169 second_noa_code,
170 second_noa_desc,
171 second_noa_id,
172 second_noa_pa_request_id,
173 service_comp_date,
174 status,
175 supervisory_status,
176 tenure,
177 to_adj_basic_pay,
178 to_basic_pay,
179 to_grade_id,
180 to_grade_or_level,
181 to_job_id,
182 to_locality_adj,
183 to_occ_code,
184 to_office_symbol,
185 to_organization_id,
186 to_other_pay_amount,
187 to_au_overtime,
188 to_auo_premium_pay_indicator,
189 to_availability_pay,
190 to_ap_premium_pay_indicator,
191 to_retention_allowance,
192 to_supervisory_differential,
193 to_staffing_differential,
194 to_pay_basis,
195 to_pay_plan,
196 -- FWFA Changes Bug#4444609
197 to_pay_table_identifier,
198 -- FWFA Changes
199 to_position_id,
200 to_position_org_line1,
201 to_position_org_line2,
202 to_position_org_line3,
203 to_position_org_line4,
204 to_position_org_line5,
205 to_position_org_line6,
206 to_position_number,
207 to_position_seq_no,
208 to_position_title,
209 to_step_or_rate,
210 to_total_salary,
211 veterans_preference,
212 veterans_pref_for_rif,
213 veterans_status,
214 work_schedule,
215 work_schedule_desc,
216 year_degree_attained,
217 first_noa_information1,
218 first_noa_information2,
219 first_noa_information3,
220 first_noa_information4,
221 first_noa_information5,
222 second_lac1_information1,
223 second_lac1_information2,
224 second_lac1_information3,
225 second_lac1_information4,
226 second_lac1_information5,
227 second_lac2_information1,
228 second_lac2_information2,
229 second_lac2_information3,
230 second_lac2_information4,
231 second_lac2_information5,
232 second_noa_information1,
233 second_noa_information2,
234 second_noa_information3,
235 second_noa_information4,
236 second_noa_information5,
237 first_lac1_information1,
238 first_lac1_information2,
239 first_lac1_information3,
240 first_lac1_information4,
241 first_lac1_information5,
242 first_lac2_information1,
243 first_lac2_information2,
244 first_lac2_information3,
245 first_lac2_information4,
246 first_lac2_information5,
247 attribute_category,
248 attribute1,
249 attribute2,
250 attribute3,
251 attribute4,
252 attribute5,
253 attribute6,
254 attribute7,
255 attribute8,
256 attribute9,
257 attribute10,
258 attribute11,
259 attribute12,
260 attribute13,
261 attribute14,
262 attribute15,
263 attribute16,
264 attribute17,
265 attribute18,
266 attribute19,
267 attribute20,
268 first_noa_canc_pa_request_id ,
269 second_noa_canc_pa_request_id ,
270 to_retention_allow_percentage ,
271 to_supervisory_diff_percentage,
272 to_staffing_diff_percentage ,
273 award_percentage ,
274 rpa_type ,
275 mass_action_id ,
276 mass_action_eligible_flag ,
277 mass_action_select_flag ,
278 mass_action_comments ,
279 -- Bug# RRR Changes
280 pa_incentive_payment_option,
281 award_salary,
282 -- Bug# RRR Changes
283 object_version_number
284 )
285 Values
286 ( p_rec.pa_request_id,
287 p_rec.pa_notification_id,
288 p_rec.noa_family_code,
289 p_rec.routing_group_id,
290 p_rec.proposed_effective_asap_flag,
291 p_rec.academic_discipline,
292 p_rec.additional_info_person_id,
293 p_rec.additional_info_tel_number,
294 p_rec.agency_code,
295 p_rec.altered_pa_request_id,
296 p_rec.annuitant_indicator,
297 p_rec.annuitant_indicator_desc,
298 p_rec.appropriation_code1,
299 p_rec.appropriation_code2,
300 p_rec.approval_date,
301 p_rec.approving_official_full_name,
302 p_rec.approving_official_work_title,
303 p_rec.sf50_approval_date,
304 p_rec.sf50_approving_ofcl_full_name,
305 p_rec.sf50_approving_ofcl_work_title,
306 p_rec.authorized_by_person_id,
307 p_rec.authorized_by_title,
308 p_rec.award_amount,
309 p_rec.award_uom,
310 p_rec.bargaining_unit_status,
311 p_rec.citizenship,
312 p_rec.concurrence_date,
313 p_rec.CUSTOM_PAY_CALC_FLAG,
314 p_rec.duty_station_code,
315 p_rec.duty_station_desc,
316 p_rec.duty_station_id,
317 p_rec.duty_station_location_id,
318 p_rec.education_level,
319 p_rec.effective_date,
320 p_rec.employee_assignment_id,
321 p_rec.employee_date_of_birth,
322 p_rec.employee_dept_or_agency,
323 p_rec.employee_first_name,
324 p_rec.employee_last_name,
325 p_rec.employee_middle_names,
326 p_rec.employee_national_identifier,
327 p_rec.fegli,
328 p_rec.fegli_desc,
329 p_rec.first_action_la_code1,
330 p_rec.first_action_la_code2,
331 p_rec.first_action_la_desc1,
332 p_rec.first_action_la_desc2,
333 p_rec.first_noa_cancel_or_correct,
334 p_rec.first_noa_code,
335 p_rec.first_noa_desc,
336 p_rec.first_noa_id,
337 p_rec.first_noa_pa_request_id,
338 p_rec.flsa_category,
339 p_rec.forwarding_address_line1,
340 p_rec.forwarding_address_line2,
341 p_rec.forwarding_address_line3,
342 p_rec.forwarding_country,
343 p_rec.forwarding_country_short_name,
344 p_rec.forwarding_postal_code,
345 p_rec.forwarding_region_2,
346 p_rec.forwarding_town_or_city,
347 p_rec.from_adj_basic_pay,
348 p_rec.from_agency_code,
349 p_rec.from_agency_desc,
350 p_rec.from_basic_pay,
351 p_rec.from_grade_or_level,
352 p_rec.from_locality_adj,
353 p_rec.from_occ_code,
354 p_rec.from_office_symbol,
355 p_rec.from_other_pay_amount,
356 p_rec.from_pay_basis,
357 p_rec.from_pay_plan,
358 -- FWFA Changes Bug#4444609
359 p_rec.input_pay_rate_determinant,
360 p_rec.from_pay_table_identifier,
361 -- FWFA Changes
362 p_rec.from_position_id,
363 p_rec.from_position_org_line1,
364 p_rec.from_position_org_line2,
365 p_rec.from_position_org_line3,
366 p_rec.from_position_org_line4,
367 p_rec.from_position_org_line5,
368 p_rec.from_position_org_line6,
369 p_rec.from_position_number,
370 p_rec.from_position_seq_no,
371 p_rec.from_position_title,
372 p_rec.from_step_or_rate,
373 p_rec.from_total_salary,
374 p_rec.functional_class,
375 p_rec.notepad,
376 p_rec.part_time_hours,
377 p_rec.pay_rate_determinant,
378 p_rec.personnel_office_id,
379 p_rec.person_id,
380 p_rec.position_occupied,
381 p_rec.proposed_effective_date,
382 p_rec.requested_by_person_id,
383 p_rec.requested_by_title,
384 p_rec.requested_date,
385 p_rec.requesting_office_remarks_desc,
386 p_rec.requesting_office_remarks_flag,
387 p_rec.request_number,
388 p_rec.resign_and_retire_reason_desc,
389 p_rec.retirement_plan,
390 p_rec.retirement_plan_desc,
391 p_rec.second_action_la_code1,
392 p_rec.second_action_la_code2,
393 p_rec.second_action_la_desc1,
394 p_rec.second_action_la_desc2,
395 p_rec.second_noa_cancel_or_correct,
396 p_rec.second_noa_code,
397 p_rec.second_noa_desc,
398 p_rec.second_noa_id,
399 p_rec.second_noa_pa_request_id,
400 p_rec.service_comp_date,
401 p_rec.status,
402 p_rec.supervisory_status,
403 p_rec.tenure,
404 p_rec.to_adj_basic_pay,
405 p_rec.to_basic_pay,
406 p_rec.to_grade_id,
407 p_rec.to_grade_or_level,
408 p_rec.to_job_id,
409 p_rec.to_locality_adj,
410 p_rec.to_occ_code,
411 p_rec.to_office_symbol,
412 p_rec.to_organization_id,
413 p_rec.to_other_pay_amount,
414 p_rec.to_au_overtime,
415 p_rec.to_auo_premium_pay_indicator,
416 p_rec.to_availability_pay,
417 p_rec.to_ap_premium_pay_indicator,
418 p_rec.to_retention_allowance,
419 p_rec.to_supervisory_differential,
420 p_rec.to_staffing_differential,
421 p_rec.to_pay_basis,
422 p_rec.to_pay_plan,
423 -- FWFA Changes Bug#4444609
424 p_rec.to_pay_table_identifier,
425 -- FWFA Changes
426 p_rec.to_position_id,
427 p_rec.to_position_org_line1,
428 p_rec.to_position_org_line2,
429 p_rec.to_position_org_line3,
430 p_rec.to_position_org_line4,
431 p_rec.to_position_org_line5,
432 p_rec.to_position_org_line6,
433 p_rec.to_position_number,
434 p_rec.to_position_seq_no,
435 p_rec.to_position_title,
436 p_rec.to_step_or_rate,
437 p_rec.to_total_salary,
438 p_rec.veterans_preference,
439 p_rec.veterans_pref_for_rif,
440 p_rec.veterans_status,
441 p_rec.work_schedule,
442 p_rec.work_schedule_desc,
443 p_rec.year_degree_attained,
444 p_rec.first_noa_information1,
445 p_rec.first_noa_information2,
446 p_rec.first_noa_information3,
447 p_rec.first_noa_information4,
448 p_rec.first_noa_information5,
449 p_rec.second_lac1_information1,
450 p_rec.second_lac1_information2,
451 p_rec.second_lac1_information3,
452 p_rec.second_lac1_information4,
453 p_rec.second_lac1_information5,
454 p_rec.second_lac2_information1,
455 p_rec.second_lac2_information2,
456 p_rec.second_lac2_information3,
457 p_rec.second_lac2_information4,
458 p_rec.second_lac2_information5,
459 p_rec.second_noa_information1,
460 p_rec.second_noa_information2,
461 p_rec.second_noa_information3,
462 p_rec.second_noa_information4,
463 p_rec.second_noa_information5,
464 p_rec.first_lac1_information1,
465 p_rec.first_lac1_information2,
466 p_rec.first_lac1_information3,
467 p_rec.first_lac1_information4,
468 p_rec.first_lac1_information5,
469 p_rec.first_lac2_information1,
470 p_rec.first_lac2_information2,
471 p_rec.first_lac2_information3,
472 p_rec.first_lac2_information4,
473 p_rec.first_lac2_information5,
474 p_rec.attribute_category,
475 p_rec.attribute1,
476 p_rec.attribute2,
477 p_rec.attribute3,
478 p_rec.attribute4,
479 p_rec.attribute5,
480 p_rec.attribute6,
481 p_rec.attribute7,
482 p_rec.attribute8,
483 p_rec.attribute9,
484 p_rec.attribute10,
485 p_rec.attribute11,
486 p_rec.attribute12,
487 p_rec.attribute13,
488 p_rec.attribute14,
489 p_rec.attribute15,
490 p_rec.attribute16,
491 p_rec.attribute17,
492 p_rec.attribute18,
493 p_rec.attribute19,
494 p_rec.attribute20,
495 p_rec.first_noa_canc_pa_request_id ,
496 p_rec.second_noa_canc_pa_request_id ,
497 p_rec.to_retention_allow_percentage ,
498 p_rec.to_supervisory_diff_percentage ,
499 p_rec.to_staffing_diff_percentage ,
500 p_rec.award_percentage ,
501 p_rec.rpa_type ,
502 p_rec.mass_action_id ,
503 p_rec.mass_action_eligible_flag ,
504 p_rec.mass_action_select_flag ,
505 p_rec.mass_action_comments ,
506 -- Bug# RRR Changes
507 p_rec.payment_option,
508 p_rec.award_salary,
509 -- Bug# RRR Changes
510 p_rec.object_version_number
511 );
512 --
513 --
514 hr_utility.set_location(' Leaving:'||l_proc, 10);
515 Exception
516 When hr_api.check_integrity_violated Then
517 -- A check constraint has been violated
518 ghr_par_shd.constraint_error
519 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
520 When hr_api.parent_integrity_violated Then
521 -- Parent integrity has been violated
522 ghr_par_shd.constraint_error
523 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
524 When hr_api.unique_integrity_violated Then
525 -- Unique integrity has been violated
526 ghr_par_shd.constraint_error
527 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
528 When Others Then
529 Raise;
530 End insert_dml;
531 --
532 -- ----------------------------------------------------------------------------
533 -- |------------------------------< pre_insert >------------------------------|
534 -- ----------------------------------------------------------------------------
535 -- {Start Of Comments}
536 --
537 -- Description:
538 -- This private procedure contains any processing which is required before
539 -- the insert dml. Presently, if the entity has a corresponding primary
540 -- key which is maintained by an associating sequence, the primary key for
541 -- the entity will be populated with the next sequence value in
542 -- preparation for the insert dml.
543 --
544 -- Prerequisites:
545 -- This is an internal procedure which is called from the ins procedure.
546 --
547 -- In Parameters:
548 -- A Pl/Sql record structre.
549 --
550 -- Post Success:
551 -- Processing continues.
552 --
553 -- Post Failure:
554 -- If an error has occurred, an error message and exception will be raised
555 -- but not handled.
556 --
557 -- Developer Implementation Notes:
558 -- Any pre-processing required before the insert dml is issued should be
559 -- coded within this procedure. As stated above, a good example is the
560 -- generation of a primary key number via a corresponding sequence.
561 -- It is important to note that any 3rd party maintenance should be reviewed
562 -- before placing in this procedure.
563 --
564 -- Access Status:
565 -- Internal Row Handler Use Only.
566 --
567 -- {End Of Comments}
568 -- ----------------------------------------------------------------------------
569 Procedure pre_insert(p_rec in out nocopy ghr_par_shd.g_rec_type) is
570 --
571 l_proc varchar2(72) := g_package||'pre_insert';
572 --
573 --
574 --
575 --
576 Cursor C_Sel1 is select ghr_pa_requests_s.nextval from sys.dual;
577 --
578 Begin
579 hr_utility.set_location('Entering:'||l_proc, 5);
580 if p_rec.pa_request_id is null then
581 --
582 --
583 -- Select the next sequence number
584 --
585 open C_Sel1;
586 Fetch C_Sel1 Into p_rec.pa_request_id;
587 Close C_Sel1;
588 end if;
589 hr_utility.set_location(' Leaving:'||l_proc, 10);
590 End pre_insert;
591
592 --
593 -- ----------------------------------------------------------------------------
594 -- |-----------------------------< post_insert >------------------------------|
595 -- ----------------------------------------------------------------------------
596 -- {Start Of Comments}
597 --
598 -- Description:
599 -- This private procedure contains any processing which is required after the
600 -- insert dml.
601 --
602 -- Prerequisites:
603 -- This is an internal procedure which is called from the ins procedure.
604 --
605 -- In Parameters:
606 -- A Pl/Sql record structre.
607 --
608 -- Post Success:
609 -- Processing continues.
610 --
611 -- Post Failure:
612 -- If an error has occurred, an error message and exception will be raised
613 -- but not handled.
614 --
615 -- Developer Implementation Notes:
616 -- Any post-processing required after the insert dml is issued should be
617 -- coded within this procedure. It is important to note that any 3rd party
618 -- maintenance should be reviewed before placing in this procedure.
619 --
620 -- Access Status:
621 -- Internal Row Handler Use Only.
622 --
623 -- {End Of Comments}
624 -- ----------------------------------------------------------------------------
625 Procedure post_insert(p_rec in ghr_par_shd.g_rec_type) is
626 --
627 l_proc varchar2(72) := g_package||'post_insert';
628 --
629 Begin
630 hr_utility.set_location('Entering:'||l_proc, 5);
631 --
632 -- This is a hook point and the user hook for post_insert is called here.
633 --
634 begin
635 ghr_par_rki.after_insert (
636 p_pa_request_id => p_rec.pa_request_id ,
637 p_pa_notification_id => p_rec.pa_notification_id ,
638 p_noa_family_code => p_rec.noa_family_code ,
639 p_routing_group_id => p_rec.routing_group_id ,
640 p_proposed_effective_asap_flag => p_rec.proposed_effective_asap_flag ,
641 p_academic_discipline => p_rec.academic_discipline ,
642 p_additional_info_person_id => p_rec.additional_info_person_id ,
643 p_additional_info_tel_number => p_rec.additional_info_tel_number ,
644 p_agency_code => p_rec.agency_code ,
645 p_altered_pa_request_id => p_rec.altered_pa_request_id ,
646 p_annuitant_indicator => p_rec.annuitant_indicator ,
647 p_annuitant_indicator_desc => p_rec.annuitant_indicator_desc ,
648 p_appropriation_code1 => p_rec.appropriation_code1 ,
649 p_appropriation_code2 => p_rec.appropriation_code2 ,
650 p_approval_date => p_rec.approval_date ,
651 p_approving_official_full_name => p_rec.approving_official_full_name ,
652 p_approving_official_work_titl => p_rec.approving_official_work_title ,
653 p_sf50_approval_date => p_rec.sf50_approval_date ,
654 p_sf50_approving_ofcl_full_nam => p_rec.sf50_approving_ofcl_full_name ,
655 p_sf50_approving_ofcl_work_tit => p_rec.sf50_approving_ofcl_work_title ,
656 p_authorized_by_person_id => p_rec.authorized_by_person_id ,
657 p_authorized_by_title => p_rec.authorized_by_title ,
658 p_award_amount => p_rec.award_amount ,
659 p_award_uom => p_rec.award_uom ,
660 p_bargaining_unit_status => p_rec.bargaining_unit_status ,
661 p_citizenship => p_rec.citizenship ,
662 p_concurrence_date => p_rec.concurrence_date ,
663 p_custom_pay_calc_flag => p_rec.custom_pay_calc_flag ,
664 p_duty_station_code => p_rec.duty_station_code ,
665 p_duty_station_desc => p_rec.duty_station_desc ,
666 p_duty_station_id => p_rec.duty_station_id ,
667 p_duty_station_location_id => p_rec.duty_station_location_id ,
668 p_education_level => p_rec.education_level ,
669 p_effective_date => p_rec.effective_date ,
670 p_employee_assignment_id => p_rec.employee_assignment_id ,
671 p_employee_date_of_birth => p_rec.employee_date_of_birth ,
672 p_employee_dept_or_agency => p_rec.employee_dept_or_agency ,
673 p_employee_first_name => p_rec.employee_first_name ,
674 p_employee_last_name => p_rec.employee_last_name ,
675 p_employee_middle_names => p_rec.employee_middle_names ,
676 p_employee_national_identifier => p_rec.employee_national_identifier ,
677 p_fegli => p_rec.fegli ,
678 p_fegli_desc => p_rec.fegli_desc ,
679 p_first_action_la_code1 => p_rec.first_action_la_code1 ,
680 p_first_action_la_code2 => p_rec.first_action_la_code2 ,
681 p_first_action_la_desc1 => p_rec.first_action_la_desc1 ,
682 p_first_action_la_desc2 => p_rec.first_action_la_desc2 ,
683 p_first_noa_cancel_or_correct => p_rec.first_noa_cancel_or_correct ,
684 p_first_noa_code => p_rec.first_noa_code ,
685 p_first_noa_desc => p_rec.first_noa_desc ,
686 p_first_noa_id => p_rec.first_noa_id ,
687 p_first_noa_pa_request_id => p_rec.first_noa_pa_request_id ,
688 p_flsa_category => p_rec.flsa_category ,
689 p_forwarding_address_line1 => p_rec.forwarding_address_line1 ,
690 p_forwarding_address_line2 => p_rec.forwarding_address_line2 ,
691 p_forwarding_address_line3 => p_rec.forwarding_address_line3 ,
692 p_forwarding_country => p_rec.forwarding_country ,
693 p_forwarding_country_short_nam => p_rec.forwarding_country_short_name ,
694 p_forwarding_postal_code => p_rec.forwarding_postal_code ,
695 p_forwarding_region_2 => p_rec.forwarding_region_2 ,
696 p_forwarding_town_or_city => p_rec.forwarding_town_or_city ,
697 p_from_adj_basic_pay => p_rec.from_adj_basic_pay ,
698 p_from_agency_code => p_rec.from_agency_code ,
699 p_from_agency_desc => p_rec.from_agency_desc ,
700 p_from_basic_pay => p_rec.from_basic_pay ,
701 p_from_grade_or_level => p_rec.from_grade_or_level ,
702 p_from_locality_adj => p_rec.from_locality_adj ,
703 p_from_occ_code => p_rec.from_occ_code ,
704 p_from_office_symbol => p_rec.from_office_symbol ,
705 p_from_other_pay_amount => p_rec.from_other_pay_amount ,
706 p_from_pay_basis => p_rec.from_pay_basis ,
707 p_from_pay_plan => p_rec.from_pay_plan ,
708 -- FWFA Changes Bug#4444609
709 --p_input_pay_rate_determinant => p_rec.input_pay_rate_determinant ,
710 --p_from_pay_table_identifier => p_rec.from_pay_table_identifier ,
711 -- FWFA Changes
712 p_from_position_id => p_rec.from_position_id ,
713 p_from_position_org_line1 => p_rec.from_position_org_line1 ,
714 p_from_position_org_line2 => p_rec.from_position_org_line2 ,
715 p_from_position_org_line3 => p_rec.from_position_org_line3 ,
716 p_from_position_org_line4 => p_rec.from_position_org_line4 ,
717 p_from_position_org_line5 => p_rec.from_position_org_line5 ,
718 p_from_position_org_line6 => p_rec.from_position_org_line6 ,
719 p_from_position_number => p_rec.from_position_number ,
720 p_from_position_seq_no => p_rec.from_position_seq_no ,
721 p_from_position_title => p_rec.from_position_title ,
722 p_from_step_or_rate => p_rec.from_step_or_rate ,
723 p_from_total_salary => p_rec.from_total_salary ,
724 p_functional_class => p_rec.functional_class ,
725 p_notepad => p_rec.notepad ,
726 p_part_time_hours => p_rec.part_time_hours ,
727 p_pay_rate_determinant => p_rec.pay_rate_determinant ,
728 p_personnel_office_id => p_rec.personnel_office_id ,
729 p_person_id => p_rec.person_id ,
730 p_position_occupied => p_rec.position_occupied ,
731 p_proposed_effective_date => p_rec.proposed_effective_date ,
732 p_requested_by_person_id => p_rec.requested_by_person_id ,
733 p_requested_by_title => p_rec.requested_by_title ,
734 p_requested_date => p_rec.requested_date ,
735 p_requesting_office_remarks_de => p_rec.requesting_office_remarks_desc ,
736 p_requesting_office_remarks_fl => p_rec.requesting_office_remarks_flag ,
737 p_request_number => p_rec.request_number ,
738 p_resign_and_retire_reason_des => p_rec.resign_and_retire_reason_desc ,
739 p_retirement_plan => p_rec.retirement_plan ,
740 p_retirement_plan_desc => p_rec.retirement_plan_desc ,
741 p_second_action_la_code1 => p_rec.second_action_la_code1 ,
742 p_second_action_la_code2 => p_rec.second_action_la_code2 ,
743 p_second_action_la_desc1 => p_rec.second_action_la_desc1 ,
744 p_second_action_la_desc2 => p_rec.second_action_la_desc2 ,
745 p_second_noa_cancel_or_correct => p_rec.second_noa_cancel_or_correct ,
746 p_second_noa_code => p_rec.second_noa_code ,
747 p_second_noa_desc => p_rec.second_noa_desc ,
748 p_second_noa_id => p_rec.second_noa_id ,
749 p_second_noa_pa_request_id => p_rec.second_noa_pa_request_id ,
750 p_service_comp_date => p_rec.service_comp_date ,
751 p_status => p_rec.status,
752 p_supervisory_status => p_rec.supervisory_status ,
753 p_tenure => p_rec.tenure ,
754 p_to_adj_basic_pay => p_rec.to_adj_basic_pay ,
755 p_to_basic_pay => p_rec.to_basic_pay ,
756 p_to_grade_id => p_rec.to_grade_id ,
757 p_to_grade_or_level => p_rec.to_grade_or_level ,
758 p_to_job_id => p_rec.to_job_id ,
759 p_to_locality_adj => p_rec.to_locality_adj ,
760 p_to_occ_code => p_rec.to_occ_code ,
761 p_to_office_symbol => p_rec.to_office_symbol ,
762 p_to_organization_id => p_rec.to_organization_id ,
763 p_to_other_pay_amount => p_rec.to_other_pay_amount ,
764 p_to_au_overtime => p_rec.to_au_overtime ,
765 p_to_auo_premium_pay_indicator => p_rec.to_auo_premium_pay_indicator ,
766 p_to_availability_pay => p_rec.to_availability_pay ,
767 p_to_ap_premium_pay_indicator => p_rec.to_ap_premium_pay_indicator ,
768 p_to_retention_allowance => p_rec.to_retention_allowance ,
769 p_to_supervisory_differential => p_rec.to_supervisory_differential ,
770 p_to_staffing_differential => p_rec.to_staffing_differential ,
771 p_to_pay_basis => p_rec.to_pay_basis ,
772 p_to_pay_plan => p_rec.to_pay_plan ,
773 -- FWFA Changes Bug#4444609
774 --p_to_pay_table_identifier => p_rec.to_pay_table_identifier ,
775 -- FWFA Changes
776 p_to_position_id => p_rec.to_position_id ,
777 p_to_position_org_line1 => p_rec.to_position_org_line1 ,
778 p_to_position_org_line2 => p_rec.to_position_org_line2 ,
779 p_to_position_org_line3 => p_rec.to_position_org_line3 ,
780 p_to_position_org_line4 => p_rec.to_position_org_line4 ,
781 p_to_position_org_line5 => p_rec.to_position_org_line5 ,
782 p_to_position_org_line6 => p_rec.to_position_org_line6 ,
783 p_to_position_number => p_rec.to_position_number ,
784 p_to_position_seq_no => p_rec.to_position_seq_no ,
785 p_to_position_title => p_rec.to_position_title ,
786 p_to_step_or_rate => p_rec.to_step_or_rate ,
787 p_to_total_salary => p_rec.to_total_salary ,
788 p_veterans_preference => p_rec.veterans_preference ,
789 p_veterans_pref_for_rif => p_rec.veterans_pref_for_rif ,
790 p_veterans_status => p_rec.veterans_status ,
791 p_work_schedule => p_rec.work_schedule ,
792 p_work_schedule_desc => p_rec.work_schedule_desc ,
793 p_year_degree_attained => p_rec.year_degree_attained ,
794 p_first_noa_information1 => p_rec.first_noa_information1 ,
795 p_first_noa_information2 => p_rec.first_noa_information2 ,
796 p_first_noa_information3 => p_rec.first_noa_information3 ,
797 p_first_noa_information4 => p_rec.first_noa_information4 ,
798 p_first_noa_information5 => p_rec.first_noa_information5 ,
799 p_second_lac1_information1 => p_rec.second_lac1_information1 ,
800 p_second_lac1_information2 => p_rec.second_lac1_information2 ,
801 p_second_lac1_information3 => p_rec.second_lac1_information3 ,
802 p_second_lac1_information4 => p_rec.second_lac1_information4 ,
803 p_second_lac1_information5 => p_rec.second_lac1_information5 ,
804 p_second_lac2_information1 => p_rec.second_lac2_information1 ,
805 p_second_lac2_information2 => p_rec.second_lac2_information2 ,
806 p_second_lac2_information3 => p_rec.second_lac2_information3 ,
807 p_second_lac2_information4 => p_rec.second_lac2_information4 ,
808 p_second_lac2_information5 => p_rec.second_lac2_information5 ,
809 p_second_noa_information1 => p_rec.second_noa_information1 ,
810 p_second_noa_information2 => p_rec.second_noa_information2 ,
811 p_second_noa_information3 => p_rec.second_noa_information3 ,
812 p_second_noa_information4 => p_rec.second_noa_information4 ,
813 p_second_noa_information5 => p_rec.second_noa_information5 ,
814 p_first_lac1_information1 => p_rec.first_lac1_information1 ,
815 p_first_lac1_information2 => p_rec.first_lac1_information2 ,
816 p_first_lac1_information3 => p_rec.first_lac1_information3 ,
817 p_first_lac1_information4 => p_rec.first_lac1_information4 ,
818 p_first_lac1_information5 => p_rec.first_lac1_information5 ,
819 p_first_lac2_information1 => p_rec.first_lac2_information1 ,
820 p_first_lac2_information2 => p_rec.first_lac2_information2 ,
821 p_first_lac2_information3 => p_rec.first_lac2_information3 ,
822 p_first_lac2_information4 => p_rec.first_lac2_information4 ,
823 p_first_lac2_information5 => p_rec.first_lac2_information5 ,
824 p_attribute_category => p_rec.attribute_category ,
825 p_attribute1 => p_rec.attribute1 ,
826 p_attribute2 => p_rec.attribute2 ,
827 p_attribute3 => p_rec.attribute3 ,
828 p_attribute4 => p_rec.attribute4 ,
829 p_attribute5 => p_rec.attribute5 ,
830 p_attribute6 => p_rec.attribute6 ,
831 p_attribute7 => p_rec.attribute7 ,
832 p_attribute8 => p_rec.attribute8 ,
833 p_attribute9 => p_rec.attribute9 ,
834 p_attribute10 => p_rec.attribute10 ,
835 p_attribute11 => p_rec.attribute11 ,
836 p_attribute12 => p_rec.attribute12 ,
837 p_attribute13 => p_rec.attribute13 ,
838 p_attribute14 => p_rec.attribute14 ,
839 p_attribute15 => p_rec.attribute15 ,
840 p_attribute16 => p_rec.attribute16 ,
841 p_attribute17 => p_rec.attribute17 ,
842 p_attribute18 => p_rec.attribute18 ,
843 p_attribute19 => p_rec.attribute19 ,
844 p_attribute20 => p_rec.attribute20 ,
845 p_first_noa_canc_pa_request_id => p_rec.first_noa_canc_pa_request_id ,
846 p_second_noa_canc_pa_request_i => p_rec.second_noa_canc_pa_request_id ,
847 p_to_retention_allow_percentag => p_rec.to_retention_allow_percentage ,
848 p_to_supervisory_diff_percenta => p_rec.to_supervisory_diff_percentage ,
849 p_to_staffing_diff_percentage => p_rec.to_staffing_diff_percentage ,
850 p_award_percentage => p_rec.award_percentage ,
851 p_rpa_type => p_rec.rpa_type,
852 p_mass_action_id => p_rec.mass_action_id,
853 p_mass_action_eligible_flag => p_rec.mass_action_eligible_flag,
854 p_mass_action_select_flag => p_rec.mass_action_select_flag,
855 p_mass_action_comments => p_rec.mass_action_comments
856 );
857 exception
858 when hr_api.cannot_find_prog_unit then
859 hr_api.cannot_find_prog_unit_error
860 ( p_module_name => 'GHR_PA_REQUESTS'
861 ,p_hook_type => 'AI'
862 );
863 end;
864 -- End of API User Hook for post_insert.
865
866 hr_utility.set_location(' Leaving:'||l_proc, 10);
867 End post_insert;
868 --
869 -- ----------------------------------------------------------------------------
870 -- |---------------------------------< ins >----------------------------------|
871 -- ----------------------------------------------------------------------------
872 Procedure ins
873 (
874 p_rec in out nocopy ghr_par_shd.g_rec_type
875 ) is
876 --
877 l_proc varchar2(72) := g_package||'ins';
878 --
879 Begin
880 hr_utility.set_location('Entering:'||l_proc, 5);
881 --
882 -- Call the supporting insert validate operations
883 --
884 ghr_par_bus.insert_validate(p_rec);
885 --
886 -- Call the supporting pre-insert operation
887 --
888 pre_insert(p_rec);
889 --
890 -- Insert the row
891 --
892 insert_dml(p_rec);
893 --
894 -- Call the supporting post-insert operation
895 --
896 post_insert(p_rec);
897 end ins;
898 --
899 -- ----------------------------------------------------------------------------
900 -- |---------------------------------< ins >----------------------------------|
901 -- ----------------------------------------------------------------------------
902 Procedure ins
903 (
904 p_pa_request_id in out nocopy number,
905 p_pa_notification_id in number default null,
906 p_noa_family_code in varchar2,
907 p_routing_group_id in number default null,
908 p_proposed_effective_asap_flag in varchar2,
909 p_academic_discipline in varchar2 default null,
910 p_additional_info_person_id in number default null,
911 p_additional_info_tel_number in varchar2 default null,
912 p_agency_code in varchar2 default null,
913 p_altered_pa_request_id in number default null,
914 p_annuitant_indicator in varchar2 default null,
915 p_annuitant_indicator_desc in varchar2 default null,
916 p_appropriation_code1 in varchar2 default null,
917 p_appropriation_code2 in varchar2 default null,
918 p_approval_date in date default null,
919 p_approving_official_full_name in varchar2 default null,
920 p_approving_official_work_titl in varchar2 default null,
921 p_sf50_approval_date in date default null,
922 p_sf50_approving_ofcl_full_nam in varchar2 default null,
923 p_sf50_approving_ofcl_work_tit in varchar2 default null,
924 p_authorized_by_person_id in number default null,
925 p_authorized_by_title in varchar2 default null,
926 p_award_amount in number default null,
927 p_award_uom in varchar2 default null,
928 p_bargaining_unit_status in varchar2 default null,
929 p_citizenship in varchar2 default null,
930 p_concurrence_date in date default null,
931 p_custom_pay_calc_flag in varchar2 default null,
932 p_duty_station_code in varchar2 default null,
933 p_duty_station_desc in varchar2 default null,
934 p_duty_station_id in number default null,
935 p_duty_station_location_id in number default null,
936 p_education_level in varchar2 default null,
937 p_effective_date in date default null,
938 p_employee_assignment_id in number default null,
939 p_employee_date_of_birth in date default null,
940 p_employee_dept_or_agency in varchar2 default null,
941 p_employee_first_name in varchar2 default null,
942 p_employee_last_name in varchar2 default null,
943 p_employee_middle_names in varchar2 default null,
944 p_employee_national_identifier in varchar2 default null,
945 p_fegli in varchar2 default null,
946 p_fegli_desc in varchar2 default null,
947 p_first_action_la_code1 in varchar2 default null,
948 p_first_action_la_code2 in varchar2 default null,
949 p_first_action_la_desc1 in varchar2 default null,
950 p_first_action_la_desc2 in varchar2 default null,
951 p_first_noa_cancel_or_correct in varchar2 default null,
952 p_first_noa_code in varchar2 default null,
953 p_first_noa_desc in varchar2 default null,
954 p_first_noa_id in number default null,
955 p_first_noa_pa_request_id in number default null,
956 p_flsa_category in varchar2 default null,
957 p_forwarding_address_line1 in varchar2 default null,
958 p_forwarding_address_line2 in varchar2 default null,
959 p_forwarding_address_line3 in varchar2 default null,
960 p_forwarding_country in varchar2 default null,
961 p_forwarding_country_short_nam in varchar2 default null,
962 p_forwarding_postal_code in varchar2 default null,
963 p_forwarding_region_2 in varchar2 default null,
964 p_forwarding_town_or_city in varchar2 default null,
965 p_from_adj_basic_pay in number default null,
966 p_from_agency_code in varchar2 default null,
967 p_from_agency_desc in varchar2 default null,
968 p_from_basic_pay in number default null,
969 p_from_grade_or_level in varchar2 default null,
970 p_from_locality_adj in number default null,
971 p_from_occ_code in varchar2 default null,
972 p_from_office_symbol in varchar2 default null,
973 p_from_other_pay_amount in number default null,
974 p_from_pay_basis in varchar2 default null,
975 p_from_pay_plan in varchar2 default null,
976 -- FWFA Changes Bug#4444609
977 p_input_pay_rate_determinant in varchar2 default null,
978 p_from_pay_table_identifier in number default null,
979 -- FWFA Changes
980 p_from_position_id in number default null,
981 p_from_position_org_line1 in varchar2 default null,
982 p_from_position_org_line2 in varchar2 default null,
983 p_from_position_org_line3 in varchar2 default null,
984 p_from_position_org_line4 in varchar2 default null,
985 p_from_position_org_line5 in varchar2 default null,
986 p_from_position_org_line6 in varchar2 default null,
987 p_from_position_number in varchar2 default null,
988 p_from_position_seq_no in number default null,
989 p_from_position_title in varchar2 default null,
990 p_from_step_or_rate in varchar2 default null,
991 p_from_total_salary in number default null,
992 p_functional_class in varchar2 default null,
993 p_notepad in varchar2 default null,
994 p_part_time_hours in number default null,
995 p_pay_rate_determinant in varchar2 default null,
996 p_personnel_office_id in varchar2 default null,
997 p_person_id in number default null,
998 p_position_occupied in varchar2 default null,
999 p_proposed_effective_date in date default null,
1000 p_requested_by_person_id in number default null,
1001 p_requested_by_title in varchar2 default null,
1002 p_requested_date in date default null,
1003 p_requesting_office_remarks_de in varchar2 default null,
1004 p_requesting_office_remarks_fl in varchar2 default null,
1005 p_request_number in varchar2 default null,
1006 p_resign_and_retire_reason_des in varchar2 default null,
1007 p_retirement_plan in varchar2 default null,
1008 p_retirement_plan_desc in varchar2 default null,
1009 p_second_action_la_code1 in varchar2 default null,
1010 p_second_action_la_code2 in varchar2 default null,
1011 p_second_action_la_desc1 in varchar2 default null,
1012 p_second_action_la_desc2 in varchar2 default null,
1013 p_second_noa_cancel_or_correct in varchar2 default null,
1014 p_second_noa_code in varchar2 default null,
1015 p_second_noa_desc in varchar2 default null,
1016 p_second_noa_id in number default null,
1017 p_second_noa_pa_request_id in number default null,
1018 p_service_comp_date in date default null,
1019 p_status in varchar2 default null,
1020 p_supervisory_status in varchar2 default null,
1021 p_tenure in varchar2 default null,
1022 p_to_adj_basic_pay in number default null,
1023 p_to_basic_pay in number default null,
1024 p_to_grade_id in number default null,
1025 p_to_grade_or_level in varchar2 default null,
1026 p_to_job_id in number default null,
1027 p_to_locality_adj in number default null,
1028 p_to_occ_code in varchar2 default null,
1029 p_to_office_symbol in varchar2 default null,
1030 p_to_organization_id in number default null,
1031 p_to_other_pay_amount in number default null,
1032 p_to_au_overtime in number default null,
1033 p_to_auo_premium_pay_indicator in varchar2 default null,
1034 p_to_availability_pay in number default null,
1035 p_to_ap_premium_pay_indicator in varchar2 default null,
1036 p_to_retention_allowance in number default null,
1037 p_to_supervisory_differential in number default null,
1038 p_to_staffing_differential in number default null,
1039 p_to_pay_basis in varchar2 default null,
1040 p_to_pay_plan in varchar2 default null,
1041 -- FWFA Changes Bug#4444609
1042 p_to_pay_table_identifier in number default null,
1043 -- FWFA Changes
1044 p_to_position_id in number default null,
1045 p_to_position_org_line1 in varchar2 default null,
1046 p_to_position_org_line2 in varchar2 default null,
1047 p_to_position_org_line3 in varchar2 default null,
1048 p_to_position_org_line4 in varchar2 default null,
1049 p_to_position_org_line5 in varchar2 default null,
1050 p_to_position_org_line6 in varchar2 default null,
1051 p_to_position_number in varchar2 default null,
1052 p_to_position_seq_no in number default null,
1053 p_to_position_title in varchar2 default null,
1054 p_to_step_or_rate in varchar2 default null,
1055 p_to_total_salary in number default null,
1056 p_veterans_preference in varchar2 default null,
1057 p_veterans_pref_for_rif in varchar2 default null,
1058 p_veterans_status in varchar2 default null,
1059 p_work_schedule in varchar2 default null,
1060 p_work_schedule_desc in varchar2 default null,
1061 p_year_degree_attained in number default null,
1062 p_first_noa_information1 in varchar2 default null,
1063 p_first_noa_information2 in varchar2 default null,
1064 p_first_noa_information3 in varchar2 default null,
1065 p_first_noa_information4 in varchar2 default null,
1066 p_first_noa_information5 in varchar2 default null,
1067 p_second_lac1_information1 in varchar2 default null,
1068 p_second_lac1_information2 in varchar2 default null,
1069 p_second_lac1_information3 in varchar2 default null,
1070 p_second_lac1_information4 in varchar2 default null,
1071 p_second_lac1_information5 in varchar2 default null,
1072 p_second_lac2_information1 in varchar2 default null,
1073 p_second_lac2_information2 in varchar2 default null,
1074 p_second_lac2_information3 in varchar2 default null,
1075 p_second_lac2_information4 in varchar2 default null,
1076 p_second_lac2_information5 in varchar2 default null,
1077 p_second_noa_information1 in varchar2 default null,
1078 p_second_noa_information2 in varchar2 default null,
1079 p_second_noa_information3 in varchar2 default null,
1080 p_second_noa_information4 in varchar2 default null,
1081 p_second_noa_information5 in varchar2 default null,
1082 p_first_lac1_information1 in varchar2 default null,
1083 p_first_lac1_information2 in varchar2 default null,
1084 p_first_lac1_information3 in varchar2 default null,
1085 p_first_lac1_information4 in varchar2 default null,
1086 p_first_lac1_information5 in varchar2 default null,
1087 p_first_lac2_information1 in varchar2 default null,
1088 p_first_lac2_information2 in varchar2 default null,
1089 p_first_lac2_information3 in varchar2 default null,
1090 p_first_lac2_information4 in varchar2 default null,
1091 p_first_lac2_information5 in varchar2 default null,
1092 p_attribute_category in varchar2 default null,
1093 p_attribute1 in varchar2 default null,
1094 p_attribute2 in varchar2 default null,
1095 p_attribute3 in varchar2 default null,
1096 p_attribute4 in varchar2 default null,
1097 p_attribute5 in varchar2 default null,
1098 p_attribute6 in varchar2 default null,
1099 p_attribute7 in varchar2 default null,
1100 p_attribute8 in varchar2 default null,
1101 p_attribute9 in varchar2 default null,
1102 p_attribute10 in varchar2 default null,
1103 p_attribute11 in varchar2 default null,
1104 p_attribute12 in varchar2 default null,
1105 p_attribute13 in varchar2 default null,
1106 p_attribute14 in varchar2 default null,
1107 p_attribute15 in varchar2 default null,
1108 p_attribute16 in varchar2 default null,
1109 p_attribute17 in varchar2 default null,
1110 p_attribute18 in varchar2 default null,
1111 p_attribute19 in varchar2 default null,
1112 p_attribute20 in varchar2 default null,
1113 p_first_noa_canc_pa_request_id in number default null,
1114 p_second_noa_canc_pa_request_i in number default null,
1115 p_to_retention_allow_percentag in number default null,
1116 p_to_supervisory_diff_percenta in number default null,
1117 p_to_staffing_diff_percentage in number default null,
1118 p_award_percentage in number default null,
1119 p_rpa_type in varchar2 default null,
1120 p_mass_action_id in number default null,
1121 p_mass_action_eligible_flag in varchar2 default null,
1122 p_mass_action_select_flag in varchar2 default null,
1123 p_mass_action_comments in varchar2 default null,
1124 -- Bug# RRR Changes
1125 p_payment_option in varchar2 default null,
1126 p_award_salary in number default null,
1127 -- Bug# RRR Changes
1128 p_object_version_number out nocopy number
1129 )
1130 is
1131 --
1132 l_rec ghr_par_shd.g_rec_type;
1133 l_proc varchar2(72) := g_package||'ins';
1134 --
1135 Begin
1136 hr_utility.set_location('Entering:'||l_proc, 5);
1137 --
1138 -- Call conversion function to turn arguments into the
1139 -- p_rec structure.
1140 --
1141 l_rec :=
1142 ghr_par_shd.convert_args
1143 (
1144 p_pa_request_id, -- null,
1145 p_pa_notification_id,
1146 p_noa_family_code,
1147 p_routing_group_id,
1148 p_proposed_effective_asap_flag,
1149 p_academic_discipline,
1150 p_additional_info_person_id,
1151 p_additional_info_tel_number,
1152 p_agency_code,
1153 p_altered_pa_request_id,
1154 p_annuitant_indicator,
1155 p_annuitant_indicator_desc,
1156 p_appropriation_code1,
1157 p_appropriation_code2,
1158 p_approval_date,
1159 p_approving_official_full_name,
1160 p_approving_official_work_titl,
1161 p_sf50_approval_date,
1162 p_sf50_approving_ofcl_full_nam,
1163 p_sf50_approving_ofcl_work_tit,
1164 p_authorized_by_person_id,
1165 p_authorized_by_title,
1166 p_award_amount,
1167 p_award_uom,
1168 p_bargaining_unit_status,
1169 p_citizenship,
1170 p_concurrence_date,
1171 p_custom_pay_calc_flag,
1172 p_duty_station_code,
1173 p_duty_station_desc,
1174 p_duty_station_id,
1175 p_duty_station_location_id,
1176 p_education_level,
1177 p_effective_date,
1178 p_employee_assignment_id,
1179 p_employee_date_of_birth,
1180 p_employee_dept_or_agency,
1181 p_employee_first_name,
1182 p_employee_last_name,
1183 p_employee_middle_names,
1184 p_employee_national_identifier,
1185 p_fegli,
1186 p_fegli_desc,
1187 p_first_action_la_code1,
1188 p_first_action_la_code2,
1189 p_first_action_la_desc1,
1190 p_first_action_la_desc2,
1191 p_first_noa_cancel_or_correct,
1192 p_first_noa_code,
1193 p_first_noa_desc,
1194 p_first_noa_id,
1195 p_first_noa_pa_request_id,
1196 p_flsa_category,
1197 p_forwarding_address_line1,
1198 p_forwarding_address_line2,
1199 p_forwarding_address_line3,
1200 p_forwarding_country,
1201 p_forwarding_country_short_nam,
1202 p_forwarding_postal_code,
1203 p_forwarding_region_2,
1204 p_forwarding_town_or_city,
1205 p_from_adj_basic_pay,
1206 p_from_agency_code,
1207 p_from_agency_desc,
1208 p_from_basic_pay,
1209 p_from_grade_or_level,
1210 p_from_locality_adj,
1211 p_from_occ_code,
1212 p_from_office_symbol,
1213 p_from_other_pay_amount,
1214 p_from_pay_basis,
1215 p_from_pay_plan,
1216 -- FWFA Changes Bug#4444609
1217 p_input_pay_rate_determinant,
1218 p_from_pay_table_identifier,
1219 -- FWFA Changes
1220 p_from_position_id,
1221 p_from_position_org_line1,
1222 p_from_position_org_line2,
1223 p_from_position_org_line3,
1224 p_from_position_org_line4,
1225 p_from_position_org_line5,
1226 p_from_position_org_line6,
1227 p_from_position_number,
1228 p_from_position_seq_no,
1229 p_from_position_title,
1230 p_from_step_or_rate,
1231 p_from_total_salary,
1232 p_functional_class,
1233 p_notepad,
1234 p_part_time_hours,
1235 p_pay_rate_determinant,
1236 p_personnel_office_id,
1237 p_person_id,
1238 p_position_occupied,
1239 p_proposed_effective_date,
1240 p_requested_by_person_id,
1241 p_requested_by_title,
1242 p_requested_date,
1243 p_requesting_office_remarks_de,
1244 p_requesting_office_remarks_fl,
1245 p_request_number,
1246 p_resign_and_retire_reason_des,
1247 p_retirement_plan,
1248 p_retirement_plan_desc,
1249 p_second_action_la_code1,
1250 p_second_action_la_code2,
1251 p_second_action_la_desc1,
1252 p_second_action_la_desc2,
1253 p_second_noa_cancel_or_correct,
1254 p_second_noa_code,
1255 p_second_noa_desc,
1256 p_second_noa_id,
1257 p_second_noa_pa_request_id,
1258 p_service_comp_date,
1259 p_status,
1260 p_supervisory_status,
1261 p_tenure,
1262 p_to_adj_basic_pay,
1263 p_to_basic_pay,
1264 p_to_grade_id,
1265 p_to_grade_or_level,
1266 p_to_job_id,
1267 p_to_locality_adj,
1268 p_to_occ_code,
1269 p_to_office_symbol,
1270 p_to_organization_id,
1271 p_to_other_pay_amount,
1272 p_to_au_overtime,
1273 p_to_auo_premium_pay_indicator,
1274 p_to_availability_pay,
1275 p_to_ap_premium_pay_indicator,
1276 p_to_retention_allowance,
1277 p_to_supervisory_differential,
1278 p_to_staffing_differential,
1279 p_to_pay_basis,
1280 p_to_pay_plan,
1281 -- FWFA Changes Bug#4444609
1282 p_to_pay_table_identifier,
1283 -- FWFA Changes
1284 p_to_position_id,
1285 p_to_position_org_line1,
1286 p_to_position_org_line2,
1287 p_to_position_org_line3,
1288 p_to_position_org_line4,
1289 p_to_position_org_line5,
1290 p_to_position_org_line6,
1291 p_to_position_number,
1292 p_to_position_seq_no,
1293 p_to_position_title,
1294 p_to_step_or_rate,
1295 p_to_total_salary,
1296 p_veterans_preference,
1297 p_veterans_pref_for_rif,
1298 p_veterans_status,
1299 p_work_schedule,
1300 p_work_schedule_desc,
1301 p_year_degree_attained,
1302 p_first_noa_information1,
1303 p_first_noa_information2,
1304 p_first_noa_information3,
1305 p_first_noa_information4,
1306 p_first_noa_information5,
1307 p_second_lac1_information1,
1308 p_second_lac1_information2,
1309 p_second_lac1_information3,
1310 p_second_lac1_information4,
1311 p_second_lac1_information5,
1312 p_second_lac2_information1,
1313 p_second_lac2_information2,
1314 p_second_lac2_information3,
1315 p_second_lac2_information4,
1316 p_second_lac2_information5,
1317 p_second_noa_information1,
1318 p_second_noa_information2,
1319 p_second_noa_information3,
1320 p_second_noa_information4,
1321 p_second_noa_information5,
1322 p_first_lac1_information1,
1323 p_first_lac1_information2,
1324 p_first_lac1_information3,
1325 p_first_lac1_information4,
1326 p_first_lac1_information5,
1327 p_first_lac2_information1,
1328 p_first_lac2_information2,
1329 p_first_lac2_information3,
1330 p_first_lac2_information4,
1331 p_first_lac2_information5,
1332 p_attribute_category,
1333 p_attribute1,
1334 p_attribute2,
1335 p_attribute3,
1336 p_attribute4,
1337 p_attribute5,
1338 p_attribute6,
1339 p_attribute7,
1340 p_attribute8,
1341 p_attribute9,
1342 p_attribute10,
1343 p_attribute11,
1344 p_attribute12,
1345 p_attribute13,
1346 p_attribute14,
1347 p_attribute15,
1348 p_attribute16,
1349 p_attribute17,
1350 p_attribute18,
1351 p_attribute19,
1352 p_attribute20,
1353 p_first_noa_canc_pa_request_id,
1354 p_second_noa_canc_pa_request_i,
1355 p_to_retention_allow_percentag,
1356 p_to_supervisory_diff_percenta,
1357 p_to_staffing_diff_percentage ,
1358 p_award_percentage ,
1359 p_rpa_type ,
1360 p_mass_action_id ,
1361 p_mass_action_eligible_flag ,
1362 p_mass_action_select_flag ,
1363 p_mass_action_comments ,
1364 -- Bug# RRR Changes
1365 p_payment_option ,
1366 p_award_salary ,
1367 -- Bug# RRR Changes
1368 null
1369 );
1370 --
1371 -- Having converted the arguments into the par_rec
1372 -- plsql record structure we call the corresponding record business process.
1373 --
1374 ins(l_rec);
1375 --
1376 -- As the primary key argument(s)
1377 -- are specified as an OUT's we must set these values.
1378 --
1379 p_pa_request_id := l_rec.pa_request_id;
1380 p_object_version_number := l_rec.object_version_number;
1381 --
1382 hr_utility.set_location(' Leaving:'||l_proc, 10);
1383 End ins;
1384 --
1385 end ghr_par_ins;