154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: --
157: Exception
158: When hr_api.check_integrity_violated Then
159: -- A check constraint has been violated
160: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
161: ben_pel_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.check_integrity_violated Then
159: -- A check constraint has been violated
160: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
161: ben_pel_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.parent_integrity_violated Then
164: -- Parent integrity has been violated
165: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
166: ben_pel_shd.constraint_error
159: -- A check constraint has been violated
160: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
161: ben_pel_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.parent_integrity_violated Then
164: -- Parent integrity has been violated
165: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
166: ben_pel_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.parent_integrity_violated Then
164: -- Parent integrity has been violated
165: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
166: ben_pel_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
171: ben_pel_shd.constraint_error
164: -- Parent integrity has been violated
165: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
166: ben_pel_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
171: ben_pel_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
171: ben_pel_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
175: Raise;
176: End update_dml;
427: );
428: --
429: exception
430: --
431: when hr_api.cannot_find_prog_unit then
432: --
433: hr_api.cannot_find_prog_unit_error
434: (p_module_name => 'ben_pil_elctbl_chc_popl'
435: ,p_hook_type => 'AU');
429: exception
430: --
431: when hr_api.cannot_find_prog_unit then
432: --
433: hr_api.cannot_find_prog_unit_error
434: (p_module_name => 'ben_pil_elctbl_chc_popl'
435: ,p_hook_type => 'AU');
436: --
437: end;
497: -- p_rec plsql record structure
498: -- to see if a system default is being used. If a system default
499: -- is being used then we must set to the 'current' argument value.
500: --
501: If (p_rec.dflt_enrt_dt = hr_api.g_date) then
502: p_rec.dflt_enrt_dt :=
503: ben_pel_shd.g_old_rec.dflt_enrt_dt;
504: End If;
505: If (p_rec.dflt_asnd_dt = hr_api.g_date) then
501: If (p_rec.dflt_enrt_dt = hr_api.g_date) then
502: p_rec.dflt_enrt_dt :=
503: ben_pel_shd.g_old_rec.dflt_enrt_dt;
504: End If;
505: If (p_rec.dflt_asnd_dt = hr_api.g_date) then
506: p_rec.dflt_asnd_dt :=
507: ben_pel_shd.g_old_rec.dflt_asnd_dt;
508: End If;
509: If (p_rec.elcns_made_dt = hr_api.g_date) then
505: If (p_rec.dflt_asnd_dt = hr_api.g_date) then
506: p_rec.dflt_asnd_dt :=
507: ben_pel_shd.g_old_rec.dflt_asnd_dt;
508: End If;
509: If (p_rec.elcns_made_dt = hr_api.g_date) then
510: p_rec.elcns_made_dt :=
511: ben_pel_shd.g_old_rec.elcns_made_dt;
512: End If;
513: If (p_rec.cls_enrt_dt_to_use_cd = hr_api.g_varchar2) then
509: If (p_rec.elcns_made_dt = hr_api.g_date) then
510: p_rec.elcns_made_dt :=
511: ben_pel_shd.g_old_rec.elcns_made_dt;
512: End If;
513: If (p_rec.cls_enrt_dt_to_use_cd = hr_api.g_varchar2) then
514: p_rec.cls_enrt_dt_to_use_cd :=
515: ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd;
516: End If;
517: If (p_rec.enrt_typ_cycl_cd = hr_api.g_varchar2) then
513: If (p_rec.cls_enrt_dt_to_use_cd = hr_api.g_varchar2) then
514: p_rec.cls_enrt_dt_to_use_cd :=
515: ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd;
516: End If;
517: If (p_rec.enrt_typ_cycl_cd = hr_api.g_varchar2) then
518: p_rec.enrt_typ_cycl_cd :=
519: ben_pel_shd.g_old_rec.enrt_typ_cycl_cd;
520: End If;
521: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then
517: If (p_rec.enrt_typ_cycl_cd = hr_api.g_varchar2) then
518: p_rec.enrt_typ_cycl_cd :=
519: ben_pel_shd.g_old_rec.enrt_typ_cycl_cd;
520: End If;
521: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then
522: p_rec.enrt_perd_end_dt :=
523: ben_pel_shd.g_old_rec.enrt_perd_end_dt;
524: End If;
525: If (p_rec.enrt_perd_strt_dt = hr_api.g_date) then
521: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then
522: p_rec.enrt_perd_end_dt :=
523: ben_pel_shd.g_old_rec.enrt_perd_end_dt;
524: End If;
525: If (p_rec.enrt_perd_strt_dt = hr_api.g_date) then
526: p_rec.enrt_perd_strt_dt :=
527: ben_pel_shd.g_old_rec.enrt_perd_strt_dt;
528: End If;
529: If (p_rec.procg_end_dt = hr_api.g_date) then
525: If (p_rec.enrt_perd_strt_dt = hr_api.g_date) then
526: p_rec.enrt_perd_strt_dt :=
527: ben_pel_shd.g_old_rec.enrt_perd_strt_dt;
528: End If;
529: If (p_rec.procg_end_dt = hr_api.g_date) then
530: p_rec.procg_end_dt :=
531: ben_pel_shd.g_old_rec.procg_end_dt;
532: End If;
533: If (p_rec.pil_elctbl_popl_stat_cd = hr_api.g_varchar2) then
529: If (p_rec.procg_end_dt = hr_api.g_date) then
530: p_rec.procg_end_dt :=
531: ben_pel_shd.g_old_rec.procg_end_dt;
532: End If;
533: If (p_rec.pil_elctbl_popl_stat_cd = hr_api.g_varchar2) then
534: p_rec.pil_elctbl_popl_stat_cd :=
535: ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd;
536: End If;
537: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
533: If (p_rec.pil_elctbl_popl_stat_cd = hr_api.g_varchar2) then
534: p_rec.pil_elctbl_popl_stat_cd :=
535: ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd;
536: End If;
537: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
538: p_rec.acty_ref_perd_cd :=
539: ben_pel_shd.g_old_rec.acty_ref_perd_cd;
540: End If;
541:
538: p_rec.acty_ref_perd_cd :=
539: ben_pel_shd.g_old_rec.acty_ref_perd_cd;
540: End If;
541:
542: If (p_rec.uom = hr_api.g_varchar2) then
543: p_rec.uom :=
544: ben_pel_shd.g_old_rec.uom;
545: End If;
546:
543: p_rec.uom :=
544: ben_pel_shd.g_old_rec.uom;
545: End If;
546:
547: If (p_rec.comments = hr_api.g_varchar2) then
548: p_rec.comments :=
549: ben_pel_shd.g_old_rec.comments;
550: End If;
551:
548: p_rec.comments :=
549: ben_pel_shd.g_old_rec.comments;
550: End If;
551:
552: If (p_rec.mgr_ovrid_dt = hr_api.g_date) then
553: p_rec.mgr_ovrid_dt :=
554: ben_pel_shd.g_old_rec.mgr_ovrid_dt;
555: End If;
556:
553: p_rec.mgr_ovrid_dt :=
554: ben_pel_shd.g_old_rec.mgr_ovrid_dt;
555: End If;
556:
557: If (p_rec.ws_mgr_id = hr_api.g_number) then
558: p_rec.ws_mgr_id :=
559: ben_pel_shd.g_old_rec.ws_mgr_id;
560: End If;
561:
558: p_rec.ws_mgr_id :=
559: ben_pel_shd.g_old_rec.ws_mgr_id;
560: End If;
561:
562: If (p_rec.mgr_ovrid_person_id = hr_api.g_number) then
563: p_rec.mgr_ovrid_person_id :=
564: ben_pel_shd.g_old_rec.mgr_ovrid_person_id;
565: End If;
566:
563: p_rec.mgr_ovrid_person_id :=
564: ben_pel_shd.g_old_rec.mgr_ovrid_person_id;
565: End If;
566:
567: If (p_rec.assignment_id = hr_api.g_number) then
568: p_rec.assignment_id :=
569: ben_pel_shd.g_old_rec.assignment_id;
570: End If;
571:
568: p_rec.assignment_id :=
569: ben_pel_shd.g_old_rec.assignment_id;
570: End If;
571:
572: If (p_rec.mgr_ovrid_person_id = hr_api.g_number) then
573: p_rec.mgr_ovrid_person_id :=
574: ben_pel_shd.g_old_rec.mgr_ovrid_person_id;
575: End If;
576:
575: End If;
576:
577:
578: -- cwb
579: If (p_rec.bdgt_acc_cd = hr_api.g_varchar2) then
580: p_rec.bdgt_acc_cd :=
581: ben_pel_shd.g_old_rec.bdgt_acc_cd;
582: End If;
583: If (p_rec.pop_cd = hr_api.g_varchar2) then
579: If (p_rec.bdgt_acc_cd = hr_api.g_varchar2) then
580: p_rec.bdgt_acc_cd :=
581: ben_pel_shd.g_old_rec.bdgt_acc_cd;
582: End If;
583: If (p_rec.pop_cd = hr_api.g_varchar2) then
584: p_rec.pop_cd :=
585: ben_pel_shd.g_old_rec.pop_cd;
586: End If;
587: If (p_rec.bdgt_due_dt = hr_api.g_date) then
583: If (p_rec.pop_cd = hr_api.g_varchar2) then
584: p_rec.pop_cd :=
585: ben_pel_shd.g_old_rec.pop_cd;
586: End If;
587: If (p_rec.bdgt_due_dt = hr_api.g_date) then
588: p_rec.bdgt_due_dt :=
589: ben_pel_shd.g_old_rec.bdgt_due_dt;
590: End If;
591: If (p_rec.bdgt_export_flag = hr_api.g_varchar2) then
587: If (p_rec.bdgt_due_dt = hr_api.g_date) then
588: p_rec.bdgt_due_dt :=
589: ben_pel_shd.g_old_rec.bdgt_due_dt;
590: End If;
591: If (p_rec.bdgt_export_flag = hr_api.g_varchar2) then
592: p_rec.bdgt_export_flag :=
593: ben_pel_shd.g_old_rec.bdgt_export_flag;
594: End If;
595: If (p_rec.bdgt_iss_dt = hr_api.g_date) then
591: If (p_rec.bdgt_export_flag = hr_api.g_varchar2) then
592: p_rec.bdgt_export_flag :=
593: ben_pel_shd.g_old_rec.bdgt_export_flag;
594: End If;
595: If (p_rec.bdgt_iss_dt = hr_api.g_date) then
596: p_rec.bdgt_iss_dt :=
597: ben_pel_shd.g_old_rec.bdgt_iss_dt;
598: End If;
599: If (p_rec.bdgt_stat_cd = hr_api.g_varchar2) then
595: If (p_rec.bdgt_iss_dt = hr_api.g_date) then
596: p_rec.bdgt_iss_dt :=
597: ben_pel_shd.g_old_rec.bdgt_iss_dt;
598: End If;
599: If (p_rec.bdgt_stat_cd = hr_api.g_varchar2) then
600: p_rec.bdgt_stat_cd :=
601: ben_pel_shd.g_old_rec.bdgt_stat_cd;
602: End If;
603: If (p_rec.ws_acc_cd = hr_api.g_varchar2) then
599: If (p_rec.bdgt_stat_cd = hr_api.g_varchar2) then
600: p_rec.bdgt_stat_cd :=
601: ben_pel_shd.g_old_rec.bdgt_stat_cd;
602: End If;
603: If (p_rec.ws_acc_cd = hr_api.g_varchar2) then
604: p_rec.ws_acc_cd :=
605: ben_pel_shd.g_old_rec.ws_acc_cd;
606: End If;
607: If (p_rec.ws_due_dt = hr_api.g_date) then
603: If (p_rec.ws_acc_cd = hr_api.g_varchar2) then
604: p_rec.ws_acc_cd :=
605: ben_pel_shd.g_old_rec.ws_acc_cd;
606: End If;
607: If (p_rec.ws_due_dt = hr_api.g_date) then
608: p_rec.ws_due_dt :=
609: ben_pel_shd.g_old_rec.ws_due_dt;
610: End If;
611: If (p_rec.ws_export_flag = hr_api.g_varchar2) then
607: If (p_rec.ws_due_dt = hr_api.g_date) then
608: p_rec.ws_due_dt :=
609: ben_pel_shd.g_old_rec.ws_due_dt;
610: End If;
611: If (p_rec.ws_export_flag = hr_api.g_varchar2) then
612: p_rec.ws_export_flag :=
613: ben_pel_shd.g_old_rec.ws_export_flag;
614: End If;
615: If (p_rec.ws_iss_dt = hr_api.g_date) then
611: If (p_rec.ws_export_flag = hr_api.g_varchar2) then
612: p_rec.ws_export_flag :=
613: ben_pel_shd.g_old_rec.ws_export_flag;
614: End If;
615: If (p_rec.ws_iss_dt = hr_api.g_date) then
616: p_rec.ws_iss_dt :=
617: ben_pel_shd.g_old_rec.ws_iss_dt;
618: End If;
619: If (p_rec.ws_stat_cd = hr_api.g_varchar2) then
615: If (p_rec.ws_iss_dt = hr_api.g_date) then
616: p_rec.ws_iss_dt :=
617: ben_pel_shd.g_old_rec.ws_iss_dt;
618: End If;
619: If (p_rec.ws_stat_cd = hr_api.g_varchar2) then
620: p_rec.ws_stat_cd :=
621: ben_pel_shd.g_old_rec.ws_stat_cd;
622: End If;
623: -- cwb
620: p_rec.ws_stat_cd :=
621: ben_pel_shd.g_old_rec.ws_stat_cd;
622: End If;
623: -- cwb
624: If (p_rec.reinstate_cd = hr_api.g_varchar2) then
625: p_rec.reinstate_cd :=
626: ben_pel_shd.g_old_rec.reinstate_cd;
627: End If;
628: If (p_rec.reinstate_ovrdn_cd = hr_api.g_varchar2) then
624: If (p_rec.reinstate_cd = hr_api.g_varchar2) then
625: p_rec.reinstate_cd :=
626: ben_pel_shd.g_old_rec.reinstate_cd;
627: End If;
628: If (p_rec.reinstate_ovrdn_cd = hr_api.g_varchar2) then
629: p_rec.reinstate_ovrdn_cd :=
630: ben_pel_shd.g_old_rec.reinstate_ovrdn_cd;
631: End If;
632: If (p_rec.auto_asnd_dt = hr_api.g_date) then
628: If (p_rec.reinstate_ovrdn_cd = hr_api.g_varchar2) then
629: p_rec.reinstate_ovrdn_cd :=
630: ben_pel_shd.g_old_rec.reinstate_ovrdn_cd;
631: End If;
632: If (p_rec.auto_asnd_dt = hr_api.g_date) then
633: p_rec.auto_asnd_dt :=
634: ben_pel_shd.g_old_rec.auto_asnd_dt;
635: End If;
636: If (p_rec.cbr_elig_perd_strt_dt = hr_api.g_date) then
632: If (p_rec.auto_asnd_dt = hr_api.g_date) then
633: p_rec.auto_asnd_dt :=
634: ben_pel_shd.g_old_rec.auto_asnd_dt;
635: End If;
636: If (p_rec.cbr_elig_perd_strt_dt = hr_api.g_date) then
637: p_rec.cbr_elig_perd_strt_dt :=
638: ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt;
639: End If;
640: If (p_rec.cbr_elig_perd_end_dt = hr_api.g_date) then
636: If (p_rec.cbr_elig_perd_strt_dt = hr_api.g_date) then
637: p_rec.cbr_elig_perd_strt_dt :=
638: ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt;
639: End If;
640: If (p_rec.cbr_elig_perd_end_dt = hr_api.g_date) then
641: p_rec.cbr_elig_perd_end_dt :=
642: ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt;
643: End If;
644: If (p_rec.lee_rsn_id = hr_api.g_number) then
640: If (p_rec.cbr_elig_perd_end_dt = hr_api.g_date) then
641: p_rec.cbr_elig_perd_end_dt :=
642: ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt;
643: End If;
644: If (p_rec.lee_rsn_id = hr_api.g_number) then
645: p_rec.lee_rsn_id :=
646: ben_pel_shd.g_old_rec.lee_rsn_id;
647: End If;
648: If (p_rec.enrt_perd_id = hr_api.g_number) then
644: If (p_rec.lee_rsn_id = hr_api.g_number) then
645: p_rec.lee_rsn_id :=
646: ben_pel_shd.g_old_rec.lee_rsn_id;
647: End If;
648: If (p_rec.enrt_perd_id = hr_api.g_number) then
649: p_rec.enrt_perd_id :=
650: ben_pel_shd.g_old_rec.enrt_perd_id;
651: End If;
652: If (p_rec.per_in_ler_id = hr_api.g_number) then
648: If (p_rec.enrt_perd_id = hr_api.g_number) then
649: p_rec.enrt_perd_id :=
650: ben_pel_shd.g_old_rec.enrt_perd_id;
651: End If;
652: If (p_rec.per_in_ler_id = hr_api.g_number) then
653: p_rec.per_in_ler_id :=
654: ben_pel_shd.g_old_rec.per_in_ler_id;
655: End If;
656: If (p_rec.pgm_id = hr_api.g_number) then
652: If (p_rec.per_in_ler_id = hr_api.g_number) then
653: p_rec.per_in_ler_id :=
654: ben_pel_shd.g_old_rec.per_in_ler_id;
655: End If;
656: If (p_rec.pgm_id = hr_api.g_number) then
657: p_rec.pgm_id :=
658: ben_pel_shd.g_old_rec.pgm_id;
659: End If;
660: If (p_rec.pl_id = hr_api.g_number) then
656: If (p_rec.pgm_id = hr_api.g_number) then
657: p_rec.pgm_id :=
658: ben_pel_shd.g_old_rec.pgm_id;
659: End If;
660: If (p_rec.pl_id = hr_api.g_number) then
661: p_rec.pl_id :=
662: ben_pel_shd.g_old_rec.pl_id;
663: End If;
664: If (p_rec.business_group_id = hr_api.g_number) then
660: If (p_rec.pl_id = hr_api.g_number) then
661: p_rec.pl_id :=
662: ben_pel_shd.g_old_rec.pl_id;
663: End If;
664: If (p_rec.business_group_id = hr_api.g_number) then
665: p_rec.business_group_id :=
666: ben_pel_shd.g_old_rec.business_group_id;
667: End If;
668: If (p_rec.pel_attribute_category = hr_api.g_varchar2) then
664: If (p_rec.business_group_id = hr_api.g_number) then
665: p_rec.business_group_id :=
666: ben_pel_shd.g_old_rec.business_group_id;
667: End If;
668: If (p_rec.pel_attribute_category = hr_api.g_varchar2) then
669: p_rec.pel_attribute_category :=
670: ben_pel_shd.g_old_rec.pel_attribute_category;
671: End If;
672: If (p_rec.pel_attribute1 = hr_api.g_varchar2) then
668: If (p_rec.pel_attribute_category = hr_api.g_varchar2) then
669: p_rec.pel_attribute_category :=
670: ben_pel_shd.g_old_rec.pel_attribute_category;
671: End If;
672: If (p_rec.pel_attribute1 = hr_api.g_varchar2) then
673: p_rec.pel_attribute1 :=
674: ben_pel_shd.g_old_rec.pel_attribute1;
675: End If;
676: If (p_rec.pel_attribute2 = hr_api.g_varchar2) then
672: If (p_rec.pel_attribute1 = hr_api.g_varchar2) then
673: p_rec.pel_attribute1 :=
674: ben_pel_shd.g_old_rec.pel_attribute1;
675: End If;
676: If (p_rec.pel_attribute2 = hr_api.g_varchar2) then
677: p_rec.pel_attribute2 :=
678: ben_pel_shd.g_old_rec.pel_attribute2;
679: End If;
680: If (p_rec.pel_attribute3 = hr_api.g_varchar2) then
676: If (p_rec.pel_attribute2 = hr_api.g_varchar2) then
677: p_rec.pel_attribute2 :=
678: ben_pel_shd.g_old_rec.pel_attribute2;
679: End If;
680: If (p_rec.pel_attribute3 = hr_api.g_varchar2) then
681: p_rec.pel_attribute3 :=
682: ben_pel_shd.g_old_rec.pel_attribute3;
683: End If;
684: If (p_rec.pel_attribute4 = hr_api.g_varchar2) then
680: If (p_rec.pel_attribute3 = hr_api.g_varchar2) then
681: p_rec.pel_attribute3 :=
682: ben_pel_shd.g_old_rec.pel_attribute3;
683: End If;
684: If (p_rec.pel_attribute4 = hr_api.g_varchar2) then
685: p_rec.pel_attribute4 :=
686: ben_pel_shd.g_old_rec.pel_attribute4;
687: End If;
688: If (p_rec.pel_attribute5 = hr_api.g_varchar2) then
684: If (p_rec.pel_attribute4 = hr_api.g_varchar2) then
685: p_rec.pel_attribute4 :=
686: ben_pel_shd.g_old_rec.pel_attribute4;
687: End If;
688: If (p_rec.pel_attribute5 = hr_api.g_varchar2) then
689: p_rec.pel_attribute5 :=
690: ben_pel_shd.g_old_rec.pel_attribute5;
691: End If;
692: If (p_rec.pel_attribute6 = hr_api.g_varchar2) then
688: If (p_rec.pel_attribute5 = hr_api.g_varchar2) then
689: p_rec.pel_attribute5 :=
690: ben_pel_shd.g_old_rec.pel_attribute5;
691: End If;
692: If (p_rec.pel_attribute6 = hr_api.g_varchar2) then
693: p_rec.pel_attribute6 :=
694: ben_pel_shd.g_old_rec.pel_attribute6;
695: End If;
696: If (p_rec.pel_attribute7 = hr_api.g_varchar2) then
692: If (p_rec.pel_attribute6 = hr_api.g_varchar2) then
693: p_rec.pel_attribute6 :=
694: ben_pel_shd.g_old_rec.pel_attribute6;
695: End If;
696: If (p_rec.pel_attribute7 = hr_api.g_varchar2) then
697: p_rec.pel_attribute7 :=
698: ben_pel_shd.g_old_rec.pel_attribute7;
699: End If;
700: If (p_rec.pel_attribute8 = hr_api.g_varchar2) then
696: If (p_rec.pel_attribute7 = hr_api.g_varchar2) then
697: p_rec.pel_attribute7 :=
698: ben_pel_shd.g_old_rec.pel_attribute7;
699: End If;
700: If (p_rec.pel_attribute8 = hr_api.g_varchar2) then
701: p_rec.pel_attribute8 :=
702: ben_pel_shd.g_old_rec.pel_attribute8;
703: End If;
704: If (p_rec.pel_attribute9 = hr_api.g_varchar2) then
700: If (p_rec.pel_attribute8 = hr_api.g_varchar2) then
701: p_rec.pel_attribute8 :=
702: ben_pel_shd.g_old_rec.pel_attribute8;
703: End If;
704: If (p_rec.pel_attribute9 = hr_api.g_varchar2) then
705: p_rec.pel_attribute9 :=
706: ben_pel_shd.g_old_rec.pel_attribute9;
707: End If;
708: If (p_rec.pel_attribute10 = hr_api.g_varchar2) then
704: If (p_rec.pel_attribute9 = hr_api.g_varchar2) then
705: p_rec.pel_attribute9 :=
706: ben_pel_shd.g_old_rec.pel_attribute9;
707: End If;
708: If (p_rec.pel_attribute10 = hr_api.g_varchar2) then
709: p_rec.pel_attribute10 :=
710: ben_pel_shd.g_old_rec.pel_attribute10;
711: End If;
712: If (p_rec.pel_attribute11 = hr_api.g_varchar2) then
708: If (p_rec.pel_attribute10 = hr_api.g_varchar2) then
709: p_rec.pel_attribute10 :=
710: ben_pel_shd.g_old_rec.pel_attribute10;
711: End If;
712: If (p_rec.pel_attribute11 = hr_api.g_varchar2) then
713: p_rec.pel_attribute11 :=
714: ben_pel_shd.g_old_rec.pel_attribute11;
715: End If;
716: If (p_rec.pel_attribute12 = hr_api.g_varchar2) then
712: If (p_rec.pel_attribute11 = hr_api.g_varchar2) then
713: p_rec.pel_attribute11 :=
714: ben_pel_shd.g_old_rec.pel_attribute11;
715: End If;
716: If (p_rec.pel_attribute12 = hr_api.g_varchar2) then
717: p_rec.pel_attribute12 :=
718: ben_pel_shd.g_old_rec.pel_attribute12;
719: End If;
720: If (p_rec.pel_attribute13 = hr_api.g_varchar2) then
716: If (p_rec.pel_attribute12 = hr_api.g_varchar2) then
717: p_rec.pel_attribute12 :=
718: ben_pel_shd.g_old_rec.pel_attribute12;
719: End If;
720: If (p_rec.pel_attribute13 = hr_api.g_varchar2) then
721: p_rec.pel_attribute13 :=
722: ben_pel_shd.g_old_rec.pel_attribute13;
723: End If;
724: If (p_rec.pel_attribute14 = hr_api.g_varchar2) then
720: If (p_rec.pel_attribute13 = hr_api.g_varchar2) then
721: p_rec.pel_attribute13 :=
722: ben_pel_shd.g_old_rec.pel_attribute13;
723: End If;
724: If (p_rec.pel_attribute14 = hr_api.g_varchar2) then
725: p_rec.pel_attribute14 :=
726: ben_pel_shd.g_old_rec.pel_attribute14;
727: End If;
728: If (p_rec.pel_attribute15 = hr_api.g_varchar2) then
724: If (p_rec.pel_attribute14 = hr_api.g_varchar2) then
725: p_rec.pel_attribute14 :=
726: ben_pel_shd.g_old_rec.pel_attribute14;
727: End If;
728: If (p_rec.pel_attribute15 = hr_api.g_varchar2) then
729: p_rec.pel_attribute15 :=
730: ben_pel_shd.g_old_rec.pel_attribute15;
731: End If;
732: If (p_rec.pel_attribute16 = hr_api.g_varchar2) then
728: If (p_rec.pel_attribute15 = hr_api.g_varchar2) then
729: p_rec.pel_attribute15 :=
730: ben_pel_shd.g_old_rec.pel_attribute15;
731: End If;
732: If (p_rec.pel_attribute16 = hr_api.g_varchar2) then
733: p_rec.pel_attribute16 :=
734: ben_pel_shd.g_old_rec.pel_attribute16;
735: End If;
736: If (p_rec.pel_attribute17 = hr_api.g_varchar2) then
732: If (p_rec.pel_attribute16 = hr_api.g_varchar2) then
733: p_rec.pel_attribute16 :=
734: ben_pel_shd.g_old_rec.pel_attribute16;
735: End If;
736: If (p_rec.pel_attribute17 = hr_api.g_varchar2) then
737: p_rec.pel_attribute17 :=
738: ben_pel_shd.g_old_rec.pel_attribute17;
739: End If;
740: If (p_rec.pel_attribute18 = hr_api.g_varchar2) then
736: If (p_rec.pel_attribute17 = hr_api.g_varchar2) then
737: p_rec.pel_attribute17 :=
738: ben_pel_shd.g_old_rec.pel_attribute17;
739: End If;
740: If (p_rec.pel_attribute18 = hr_api.g_varchar2) then
741: p_rec.pel_attribute18 :=
742: ben_pel_shd.g_old_rec.pel_attribute18;
743: End If;
744: If (p_rec.pel_attribute19 = hr_api.g_varchar2) then
740: If (p_rec.pel_attribute18 = hr_api.g_varchar2) then
741: p_rec.pel_attribute18 :=
742: ben_pel_shd.g_old_rec.pel_attribute18;
743: End If;
744: If (p_rec.pel_attribute19 = hr_api.g_varchar2) then
745: p_rec.pel_attribute19 :=
746: ben_pel_shd.g_old_rec.pel_attribute19;
747: End If;
748: If (p_rec.pel_attribute20 = hr_api.g_varchar2) then
744: If (p_rec.pel_attribute19 = hr_api.g_varchar2) then
745: p_rec.pel_attribute19 :=
746: ben_pel_shd.g_old_rec.pel_attribute19;
747: End If;
748: If (p_rec.pel_attribute20 = hr_api.g_varchar2) then
749: p_rec.pel_attribute20 :=
750: ben_pel_shd.g_old_rec.pel_attribute20;
751: End If;
752: If (p_rec.pel_attribute21 = hr_api.g_varchar2) then
748: If (p_rec.pel_attribute20 = hr_api.g_varchar2) then
749: p_rec.pel_attribute20 :=
750: ben_pel_shd.g_old_rec.pel_attribute20;
751: End If;
752: If (p_rec.pel_attribute21 = hr_api.g_varchar2) then
753: p_rec.pel_attribute21 :=
754: ben_pel_shd.g_old_rec.pel_attribute21;
755: End If;
756: If (p_rec.pel_attribute22 = hr_api.g_varchar2) then
752: If (p_rec.pel_attribute21 = hr_api.g_varchar2) then
753: p_rec.pel_attribute21 :=
754: ben_pel_shd.g_old_rec.pel_attribute21;
755: End If;
756: If (p_rec.pel_attribute22 = hr_api.g_varchar2) then
757: p_rec.pel_attribute22 :=
758: ben_pel_shd.g_old_rec.pel_attribute22;
759: End If;
760: If (p_rec.pel_attribute23 = hr_api.g_varchar2) then
756: If (p_rec.pel_attribute22 = hr_api.g_varchar2) then
757: p_rec.pel_attribute22 :=
758: ben_pel_shd.g_old_rec.pel_attribute22;
759: End If;
760: If (p_rec.pel_attribute23 = hr_api.g_varchar2) then
761: p_rec.pel_attribute23 :=
762: ben_pel_shd.g_old_rec.pel_attribute23;
763: End If;
764: If (p_rec.pel_attribute24 = hr_api.g_varchar2) then
760: If (p_rec.pel_attribute23 = hr_api.g_varchar2) then
761: p_rec.pel_attribute23 :=
762: ben_pel_shd.g_old_rec.pel_attribute23;
763: End If;
764: If (p_rec.pel_attribute24 = hr_api.g_varchar2) then
765: p_rec.pel_attribute24 :=
766: ben_pel_shd.g_old_rec.pel_attribute24;
767: End If;
768: If (p_rec.pel_attribute25 = hr_api.g_varchar2) then
764: If (p_rec.pel_attribute24 = hr_api.g_varchar2) then
765: p_rec.pel_attribute24 :=
766: ben_pel_shd.g_old_rec.pel_attribute24;
767: End If;
768: If (p_rec.pel_attribute25 = hr_api.g_varchar2) then
769: p_rec.pel_attribute25 :=
770: ben_pel_shd.g_old_rec.pel_attribute25;
771: End If;
772: If (p_rec.pel_attribute26 = hr_api.g_varchar2) then
768: If (p_rec.pel_attribute25 = hr_api.g_varchar2) then
769: p_rec.pel_attribute25 :=
770: ben_pel_shd.g_old_rec.pel_attribute25;
771: End If;
772: If (p_rec.pel_attribute26 = hr_api.g_varchar2) then
773: p_rec.pel_attribute26 :=
774: ben_pel_shd.g_old_rec.pel_attribute26;
775: End If;
776: If (p_rec.pel_attribute27 = hr_api.g_varchar2) then
772: If (p_rec.pel_attribute26 = hr_api.g_varchar2) then
773: p_rec.pel_attribute26 :=
774: ben_pel_shd.g_old_rec.pel_attribute26;
775: End If;
776: If (p_rec.pel_attribute27 = hr_api.g_varchar2) then
777: p_rec.pel_attribute27 :=
778: ben_pel_shd.g_old_rec.pel_attribute27;
779: End If;
780: If (p_rec.pel_attribute28 = hr_api.g_varchar2) then
776: If (p_rec.pel_attribute27 = hr_api.g_varchar2) then
777: p_rec.pel_attribute27 :=
778: ben_pel_shd.g_old_rec.pel_attribute27;
779: End If;
780: If (p_rec.pel_attribute28 = hr_api.g_varchar2) then
781: p_rec.pel_attribute28 :=
782: ben_pel_shd.g_old_rec.pel_attribute28;
783: End If;
784: If (p_rec.pel_attribute29 = hr_api.g_varchar2) then
780: If (p_rec.pel_attribute28 = hr_api.g_varchar2) then
781: p_rec.pel_attribute28 :=
782: ben_pel_shd.g_old_rec.pel_attribute28;
783: End If;
784: If (p_rec.pel_attribute29 = hr_api.g_varchar2) then
785: p_rec.pel_attribute29 :=
786: ben_pel_shd.g_old_rec.pel_attribute29;
787: End If;
788: If (p_rec.pel_attribute30 = hr_api.g_varchar2) then
784: If (p_rec.pel_attribute29 = hr_api.g_varchar2) then
785: p_rec.pel_attribute29 :=
786: ben_pel_shd.g_old_rec.pel_attribute29;
787: End If;
788: If (p_rec.pel_attribute30 = hr_api.g_varchar2) then
789: p_rec.pel_attribute30 :=
790: ben_pel_shd.g_old_rec.pel_attribute30;
791: End If;
792: If (p_rec.request_id = hr_api.g_number) then
788: If (p_rec.pel_attribute30 = hr_api.g_varchar2) then
789: p_rec.pel_attribute30 :=
790: ben_pel_shd.g_old_rec.pel_attribute30;
791: End If;
792: If (p_rec.request_id = hr_api.g_number) then
793: p_rec.request_id :=
794: ben_pel_shd.g_old_rec.request_id;
795: End If;
796: If (p_rec.program_application_id = hr_api.g_number) then
792: If (p_rec.request_id = hr_api.g_number) then
793: p_rec.request_id :=
794: ben_pel_shd.g_old_rec.request_id;
795: End If;
796: If (p_rec.program_application_id = hr_api.g_number) then
797: p_rec.program_application_id :=
798: ben_pel_shd.g_old_rec.program_application_id;
799: End If;
800: If (p_rec.program_id = hr_api.g_number) then
796: If (p_rec.program_application_id = hr_api.g_number) then
797: p_rec.program_application_id :=
798: ben_pel_shd.g_old_rec.program_application_id;
799: End If;
800: If (p_rec.program_id = hr_api.g_number) then
801: p_rec.program_id :=
802: ben_pel_shd.g_old_rec.program_id;
803: End If;
804: If (p_rec.program_update_date = hr_api.g_date) then
800: If (p_rec.program_id = hr_api.g_number) then
801: p_rec.program_id :=
802: ben_pel_shd.g_old_rec.program_id;
803: End If;
804: If (p_rec.program_update_date = hr_api.g_date) then
805: p_rec.program_update_date :=
806: ben_pel_shd.g_old_rec.program_update_date;
807: End If;
808: If (p_rec.defer_deenrol_flag = hr_api.g_varchar2) then
804: If (p_rec.program_update_date = hr_api.g_date) then
805: p_rec.program_update_date :=
806: ben_pel_shd.g_old_rec.program_update_date;
807: End If;
808: If (p_rec.defer_deenrol_flag = hr_api.g_varchar2) then
809: p_rec.defer_deenrol_flag :=
810: ben_pel_shd.g_old_rec.defer_deenrol_flag;
811: End If;
812: If (p_rec.deenrol_made_dt = hr_api.g_date) then
808: If (p_rec.defer_deenrol_flag = hr_api.g_varchar2) then
809: p_rec.defer_deenrol_flag :=
810: ben_pel_shd.g_old_rec.defer_deenrol_flag;
811: End If;
812: If (p_rec.deenrol_made_dt = hr_api.g_date) then
813: p_rec.deenrol_made_dt :=
814: ben_pel_shd.g_old_rec.deenrol_made_dt;
815: End If;
816: If (p_rec.reopen_le_on_reprocess = hr_api.g_varchar2) then
812: If (p_rec.deenrol_made_dt = hr_api.g_date) then
813: p_rec.deenrol_made_dt :=
814: ben_pel_shd.g_old_rec.deenrol_made_dt;
815: End If;
816: If (p_rec.reopen_le_on_reprocess = hr_api.g_varchar2) then
817: p_rec.reopen_le_on_reprocess :=
818: ben_pel_shd.g_old_rec.reopen_le_on_reprocess;
819: End If;
820:
887: Procedure upd
888: (
889: p_effective_date in date,
890: p_pil_elctbl_chc_popl_id in number,
891: p_dflt_enrt_dt in date default hr_api.g_date,
892: p_dflt_asnd_dt in date default hr_api.g_date,
893: p_elcns_made_dt in date default hr_api.g_date,
894: p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
895: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
888: (
889: p_effective_date in date,
890: p_pil_elctbl_chc_popl_id in number,
891: p_dflt_enrt_dt in date default hr_api.g_date,
892: p_dflt_asnd_dt in date default hr_api.g_date,
893: p_elcns_made_dt in date default hr_api.g_date,
894: p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
895: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
896: p_enrt_perd_end_dt in date default hr_api.g_date,
889: p_effective_date in date,
890: p_pil_elctbl_chc_popl_id in number,
891: p_dflt_enrt_dt in date default hr_api.g_date,
892: p_dflt_asnd_dt in date default hr_api.g_date,
893: p_elcns_made_dt in date default hr_api.g_date,
894: p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
895: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
896: p_enrt_perd_end_dt in date default hr_api.g_date,
897: p_enrt_perd_strt_dt in date default hr_api.g_date,
890: p_pil_elctbl_chc_popl_id in number,
891: p_dflt_enrt_dt in date default hr_api.g_date,
892: p_dflt_asnd_dt in date default hr_api.g_date,
893: p_elcns_made_dt in date default hr_api.g_date,
894: p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
895: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
896: p_enrt_perd_end_dt in date default hr_api.g_date,
897: p_enrt_perd_strt_dt in date default hr_api.g_date,
898: p_procg_end_dt in date default hr_api.g_date,
891: p_dflt_enrt_dt in date default hr_api.g_date,
892: p_dflt_asnd_dt in date default hr_api.g_date,
893: p_elcns_made_dt in date default hr_api.g_date,
894: p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
895: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
896: p_enrt_perd_end_dt in date default hr_api.g_date,
897: p_enrt_perd_strt_dt in date default hr_api.g_date,
898: p_procg_end_dt in date default hr_api.g_date,
899: p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2,
892: p_dflt_asnd_dt in date default hr_api.g_date,
893: p_elcns_made_dt in date default hr_api.g_date,
894: p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
895: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
896: p_enrt_perd_end_dt in date default hr_api.g_date,
897: p_enrt_perd_strt_dt in date default hr_api.g_date,
898: p_procg_end_dt in date default hr_api.g_date,
899: p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2,
900: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
893: p_elcns_made_dt in date default hr_api.g_date,
894: p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
895: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
896: p_enrt_perd_end_dt in date default hr_api.g_date,
897: p_enrt_perd_strt_dt in date default hr_api.g_date,
898: p_procg_end_dt in date default hr_api.g_date,
899: p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2,
900: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
901: p_uom in varchar2 default hr_api.g_varchar2,
894: p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
895: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
896: p_enrt_perd_end_dt in date default hr_api.g_date,
897: p_enrt_perd_strt_dt in date default hr_api.g_date,
898: p_procg_end_dt in date default hr_api.g_date,
899: p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2,
900: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
901: p_uom in varchar2 default hr_api.g_varchar2,
902: p_comments in varchar2 default hr_api.g_varchar2,
895: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
896: p_enrt_perd_end_dt in date default hr_api.g_date,
897: p_enrt_perd_strt_dt in date default hr_api.g_date,
898: p_procg_end_dt in date default hr_api.g_date,
899: p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2,
900: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
901: p_uom in varchar2 default hr_api.g_varchar2,
902: p_comments in varchar2 default hr_api.g_varchar2,
903: p_mgr_ovrid_dt in date default hr_api.g_date,
896: p_enrt_perd_end_dt in date default hr_api.g_date,
897: p_enrt_perd_strt_dt in date default hr_api.g_date,
898: p_procg_end_dt in date default hr_api.g_date,
899: p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2,
900: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
901: p_uom in varchar2 default hr_api.g_varchar2,
902: p_comments in varchar2 default hr_api.g_varchar2,
903: p_mgr_ovrid_dt in date default hr_api.g_date,
904: p_ws_mgr_id in number default hr_api.g_number,
897: p_enrt_perd_strt_dt in date default hr_api.g_date,
898: p_procg_end_dt in date default hr_api.g_date,
899: p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2,
900: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
901: p_uom in varchar2 default hr_api.g_varchar2,
902: p_comments in varchar2 default hr_api.g_varchar2,
903: p_mgr_ovrid_dt in date default hr_api.g_date,
904: p_ws_mgr_id in number default hr_api.g_number,
905: p_mgr_ovrid_person_id in number default hr_api.g_number,
898: p_procg_end_dt in date default hr_api.g_date,
899: p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2,
900: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
901: p_uom in varchar2 default hr_api.g_varchar2,
902: p_comments in varchar2 default hr_api.g_varchar2,
903: p_mgr_ovrid_dt in date default hr_api.g_date,
904: p_ws_mgr_id in number default hr_api.g_number,
905: p_mgr_ovrid_person_id in number default hr_api.g_number,
906: p_assignment_id in number default hr_api.g_number,
899: p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2,
900: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
901: p_uom in varchar2 default hr_api.g_varchar2,
902: p_comments in varchar2 default hr_api.g_varchar2,
903: p_mgr_ovrid_dt in date default hr_api.g_date,
904: p_ws_mgr_id in number default hr_api.g_number,
905: p_mgr_ovrid_person_id in number default hr_api.g_number,
906: p_assignment_id in number default hr_api.g_number,
907: --cwb
900: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
901: p_uom in varchar2 default hr_api.g_varchar2,
902: p_comments in varchar2 default hr_api.g_varchar2,
903: p_mgr_ovrid_dt in date default hr_api.g_date,
904: p_ws_mgr_id in number default hr_api.g_number,
905: p_mgr_ovrid_person_id in number default hr_api.g_number,
906: p_assignment_id in number default hr_api.g_number,
907: --cwb
908: p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2,
901: p_uom in varchar2 default hr_api.g_varchar2,
902: p_comments in varchar2 default hr_api.g_varchar2,
903: p_mgr_ovrid_dt in date default hr_api.g_date,
904: p_ws_mgr_id in number default hr_api.g_number,
905: p_mgr_ovrid_person_id in number default hr_api.g_number,
906: p_assignment_id in number default hr_api.g_number,
907: --cwb
908: p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2,
909: p_pop_cd in varchar2 default hr_api.g_varchar2,
902: p_comments in varchar2 default hr_api.g_varchar2,
903: p_mgr_ovrid_dt in date default hr_api.g_date,
904: p_ws_mgr_id in number default hr_api.g_number,
905: p_mgr_ovrid_person_id in number default hr_api.g_number,
906: p_assignment_id in number default hr_api.g_number,
907: --cwb
908: p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2,
909: p_pop_cd in varchar2 default hr_api.g_varchar2,
910: p_bdgt_due_dt in date default hr_api.g_date,
904: p_ws_mgr_id in number default hr_api.g_number,
905: p_mgr_ovrid_person_id in number default hr_api.g_number,
906: p_assignment_id in number default hr_api.g_number,
907: --cwb
908: p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2,
909: p_pop_cd in varchar2 default hr_api.g_varchar2,
910: p_bdgt_due_dt in date default hr_api.g_date,
911: p_bdgt_export_flag in varchar2 default hr_api.g_varchar2,
912: p_bdgt_iss_dt in date default hr_api.g_date,
905: p_mgr_ovrid_person_id in number default hr_api.g_number,
906: p_assignment_id in number default hr_api.g_number,
907: --cwb
908: p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2,
909: p_pop_cd in varchar2 default hr_api.g_varchar2,
910: p_bdgt_due_dt in date default hr_api.g_date,
911: p_bdgt_export_flag in varchar2 default hr_api.g_varchar2,
912: p_bdgt_iss_dt in date default hr_api.g_date,
913: p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2,
906: p_assignment_id in number default hr_api.g_number,
907: --cwb
908: p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2,
909: p_pop_cd in varchar2 default hr_api.g_varchar2,
910: p_bdgt_due_dt in date default hr_api.g_date,
911: p_bdgt_export_flag in varchar2 default hr_api.g_varchar2,
912: p_bdgt_iss_dt in date default hr_api.g_date,
913: p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2,
914: p_ws_acc_cd in varchar2 default hr_api.g_varchar2,
907: --cwb
908: p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2,
909: p_pop_cd in varchar2 default hr_api.g_varchar2,
910: p_bdgt_due_dt in date default hr_api.g_date,
911: p_bdgt_export_flag in varchar2 default hr_api.g_varchar2,
912: p_bdgt_iss_dt in date default hr_api.g_date,
913: p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2,
914: p_ws_acc_cd in varchar2 default hr_api.g_varchar2,
915: p_ws_due_dt in date default hr_api.g_date,
908: p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2,
909: p_pop_cd in varchar2 default hr_api.g_varchar2,
910: p_bdgt_due_dt in date default hr_api.g_date,
911: p_bdgt_export_flag in varchar2 default hr_api.g_varchar2,
912: p_bdgt_iss_dt in date default hr_api.g_date,
913: p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2,
914: p_ws_acc_cd in varchar2 default hr_api.g_varchar2,
915: p_ws_due_dt in date default hr_api.g_date,
916: p_ws_export_flag in varchar2 default hr_api.g_varchar2,
909: p_pop_cd in varchar2 default hr_api.g_varchar2,
910: p_bdgt_due_dt in date default hr_api.g_date,
911: p_bdgt_export_flag in varchar2 default hr_api.g_varchar2,
912: p_bdgt_iss_dt in date default hr_api.g_date,
913: p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2,
914: p_ws_acc_cd in varchar2 default hr_api.g_varchar2,
915: p_ws_due_dt in date default hr_api.g_date,
916: p_ws_export_flag in varchar2 default hr_api.g_varchar2,
917: p_ws_iss_dt in date default hr_api.g_date,
910: p_bdgt_due_dt in date default hr_api.g_date,
911: p_bdgt_export_flag in varchar2 default hr_api.g_varchar2,
912: p_bdgt_iss_dt in date default hr_api.g_date,
913: p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2,
914: p_ws_acc_cd in varchar2 default hr_api.g_varchar2,
915: p_ws_due_dt in date default hr_api.g_date,
916: p_ws_export_flag in varchar2 default hr_api.g_varchar2,
917: p_ws_iss_dt in date default hr_api.g_date,
918: p_ws_stat_cd in varchar2 default hr_api.g_varchar2,
911: p_bdgt_export_flag in varchar2 default hr_api.g_varchar2,
912: p_bdgt_iss_dt in date default hr_api.g_date,
913: p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2,
914: p_ws_acc_cd in varchar2 default hr_api.g_varchar2,
915: p_ws_due_dt in date default hr_api.g_date,
916: p_ws_export_flag in varchar2 default hr_api.g_varchar2,
917: p_ws_iss_dt in date default hr_api.g_date,
918: p_ws_stat_cd in varchar2 default hr_api.g_varchar2,
919: --cwb
912: p_bdgt_iss_dt in date default hr_api.g_date,
913: p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2,
914: p_ws_acc_cd in varchar2 default hr_api.g_varchar2,
915: p_ws_due_dt in date default hr_api.g_date,
916: p_ws_export_flag in varchar2 default hr_api.g_varchar2,
917: p_ws_iss_dt in date default hr_api.g_date,
918: p_ws_stat_cd in varchar2 default hr_api.g_varchar2,
919: --cwb
920: p_reinstate_cd in varchar2 default hr_api.g_varchar2,
913: p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2,
914: p_ws_acc_cd in varchar2 default hr_api.g_varchar2,
915: p_ws_due_dt in date default hr_api.g_date,
916: p_ws_export_flag in varchar2 default hr_api.g_varchar2,
917: p_ws_iss_dt in date default hr_api.g_date,
918: p_ws_stat_cd in varchar2 default hr_api.g_varchar2,
919: --cwb
920: p_reinstate_cd in varchar2 default hr_api.g_varchar2,
921: p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2,
914: p_ws_acc_cd in varchar2 default hr_api.g_varchar2,
915: p_ws_due_dt in date default hr_api.g_date,
916: p_ws_export_flag in varchar2 default hr_api.g_varchar2,
917: p_ws_iss_dt in date default hr_api.g_date,
918: p_ws_stat_cd in varchar2 default hr_api.g_varchar2,
919: --cwb
920: p_reinstate_cd in varchar2 default hr_api.g_varchar2,
921: p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2,
922: p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2,
916: p_ws_export_flag in varchar2 default hr_api.g_varchar2,
917: p_ws_iss_dt in date default hr_api.g_date,
918: p_ws_stat_cd in varchar2 default hr_api.g_varchar2,
919: --cwb
920: p_reinstate_cd in varchar2 default hr_api.g_varchar2,
921: p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2,
922: p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2,
923: p_auto_asnd_dt in date default hr_api.g_date,
924: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
917: p_ws_iss_dt in date default hr_api.g_date,
918: p_ws_stat_cd in varchar2 default hr_api.g_varchar2,
919: --cwb
920: p_reinstate_cd in varchar2 default hr_api.g_varchar2,
921: p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2,
922: p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2,
923: p_auto_asnd_dt in date default hr_api.g_date,
924: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
925: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
918: p_ws_stat_cd in varchar2 default hr_api.g_varchar2,
919: --cwb
920: p_reinstate_cd in varchar2 default hr_api.g_varchar2,
921: p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2,
922: p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2,
923: p_auto_asnd_dt in date default hr_api.g_date,
924: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
925: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
926: p_lee_rsn_id in number default hr_api.g_number,
919: --cwb
920: p_reinstate_cd in varchar2 default hr_api.g_varchar2,
921: p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2,
922: p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2,
923: p_auto_asnd_dt in date default hr_api.g_date,
924: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
925: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
926: p_lee_rsn_id in number default hr_api.g_number,
927: p_enrt_perd_id in number default hr_api.g_number,
920: p_reinstate_cd in varchar2 default hr_api.g_varchar2,
921: p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2,
922: p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2,
923: p_auto_asnd_dt in date default hr_api.g_date,
924: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
925: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
926: p_lee_rsn_id in number default hr_api.g_number,
927: p_enrt_perd_id in number default hr_api.g_number,
928: p_per_in_ler_id in number default hr_api.g_number,
921: p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2,
922: p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2,
923: p_auto_asnd_dt in date default hr_api.g_date,
924: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
925: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
926: p_lee_rsn_id in number default hr_api.g_number,
927: p_enrt_perd_id in number default hr_api.g_number,
928: p_per_in_ler_id in number default hr_api.g_number,
929: p_pgm_id in number default hr_api.g_number,
922: p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2,
923: p_auto_asnd_dt in date default hr_api.g_date,
924: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
925: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
926: p_lee_rsn_id in number default hr_api.g_number,
927: p_enrt_perd_id in number default hr_api.g_number,
928: p_per_in_ler_id in number default hr_api.g_number,
929: p_pgm_id in number default hr_api.g_number,
930: p_pl_id in number default hr_api.g_number,
923: p_auto_asnd_dt in date default hr_api.g_date,
924: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
925: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
926: p_lee_rsn_id in number default hr_api.g_number,
927: p_enrt_perd_id in number default hr_api.g_number,
928: p_per_in_ler_id in number default hr_api.g_number,
929: p_pgm_id in number default hr_api.g_number,
930: p_pl_id in number default hr_api.g_number,
931: p_business_group_id in number default hr_api.g_number,
924: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
925: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
926: p_lee_rsn_id in number default hr_api.g_number,
927: p_enrt_perd_id in number default hr_api.g_number,
928: p_per_in_ler_id in number default hr_api.g_number,
929: p_pgm_id in number default hr_api.g_number,
930: p_pl_id in number default hr_api.g_number,
931: p_business_group_id in number default hr_api.g_number,
932: p_pel_attribute_category in varchar2 default hr_api.g_varchar2,
925: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
926: p_lee_rsn_id in number default hr_api.g_number,
927: p_enrt_perd_id in number default hr_api.g_number,
928: p_per_in_ler_id in number default hr_api.g_number,
929: p_pgm_id in number default hr_api.g_number,
930: p_pl_id in number default hr_api.g_number,
931: p_business_group_id in number default hr_api.g_number,
932: p_pel_attribute_category in varchar2 default hr_api.g_varchar2,
933: p_pel_attribute1 in varchar2 default hr_api.g_varchar2,
926: p_lee_rsn_id in number default hr_api.g_number,
927: p_enrt_perd_id in number default hr_api.g_number,
928: p_per_in_ler_id in number default hr_api.g_number,
929: p_pgm_id in number default hr_api.g_number,
930: p_pl_id in number default hr_api.g_number,
931: p_business_group_id in number default hr_api.g_number,
932: p_pel_attribute_category in varchar2 default hr_api.g_varchar2,
933: p_pel_attribute1 in varchar2 default hr_api.g_varchar2,
934: p_pel_attribute2 in varchar2 default hr_api.g_varchar2,
927: p_enrt_perd_id in number default hr_api.g_number,
928: p_per_in_ler_id in number default hr_api.g_number,
929: p_pgm_id in number default hr_api.g_number,
930: p_pl_id in number default hr_api.g_number,
931: p_business_group_id in number default hr_api.g_number,
932: p_pel_attribute_category in varchar2 default hr_api.g_varchar2,
933: p_pel_attribute1 in varchar2 default hr_api.g_varchar2,
934: p_pel_attribute2 in varchar2 default hr_api.g_varchar2,
935: p_pel_attribute3 in varchar2 default hr_api.g_varchar2,
928: p_per_in_ler_id in number default hr_api.g_number,
929: p_pgm_id in number default hr_api.g_number,
930: p_pl_id in number default hr_api.g_number,
931: p_business_group_id in number default hr_api.g_number,
932: p_pel_attribute_category in varchar2 default hr_api.g_varchar2,
933: p_pel_attribute1 in varchar2 default hr_api.g_varchar2,
934: p_pel_attribute2 in varchar2 default hr_api.g_varchar2,
935: p_pel_attribute3 in varchar2 default hr_api.g_varchar2,
936: p_pel_attribute4 in varchar2 default hr_api.g_varchar2,
929: p_pgm_id in number default hr_api.g_number,
930: p_pl_id in number default hr_api.g_number,
931: p_business_group_id in number default hr_api.g_number,
932: p_pel_attribute_category in varchar2 default hr_api.g_varchar2,
933: p_pel_attribute1 in varchar2 default hr_api.g_varchar2,
934: p_pel_attribute2 in varchar2 default hr_api.g_varchar2,
935: p_pel_attribute3 in varchar2 default hr_api.g_varchar2,
936: p_pel_attribute4 in varchar2 default hr_api.g_varchar2,
937: p_pel_attribute5 in varchar2 default hr_api.g_varchar2,
930: p_pl_id in number default hr_api.g_number,
931: p_business_group_id in number default hr_api.g_number,
932: p_pel_attribute_category in varchar2 default hr_api.g_varchar2,
933: p_pel_attribute1 in varchar2 default hr_api.g_varchar2,
934: p_pel_attribute2 in varchar2 default hr_api.g_varchar2,
935: p_pel_attribute3 in varchar2 default hr_api.g_varchar2,
936: p_pel_attribute4 in varchar2 default hr_api.g_varchar2,
937: p_pel_attribute5 in varchar2 default hr_api.g_varchar2,
938: p_pel_attribute6 in varchar2 default hr_api.g_varchar2,
931: p_business_group_id in number default hr_api.g_number,
932: p_pel_attribute_category in varchar2 default hr_api.g_varchar2,
933: p_pel_attribute1 in varchar2 default hr_api.g_varchar2,
934: p_pel_attribute2 in varchar2 default hr_api.g_varchar2,
935: p_pel_attribute3 in varchar2 default hr_api.g_varchar2,
936: p_pel_attribute4 in varchar2 default hr_api.g_varchar2,
937: p_pel_attribute5 in varchar2 default hr_api.g_varchar2,
938: p_pel_attribute6 in varchar2 default hr_api.g_varchar2,
939: p_pel_attribute7 in varchar2 default hr_api.g_varchar2,
932: p_pel_attribute_category in varchar2 default hr_api.g_varchar2,
933: p_pel_attribute1 in varchar2 default hr_api.g_varchar2,
934: p_pel_attribute2 in varchar2 default hr_api.g_varchar2,
935: p_pel_attribute3 in varchar2 default hr_api.g_varchar2,
936: p_pel_attribute4 in varchar2 default hr_api.g_varchar2,
937: p_pel_attribute5 in varchar2 default hr_api.g_varchar2,
938: p_pel_attribute6 in varchar2 default hr_api.g_varchar2,
939: p_pel_attribute7 in varchar2 default hr_api.g_varchar2,
940: p_pel_attribute8 in varchar2 default hr_api.g_varchar2,
933: p_pel_attribute1 in varchar2 default hr_api.g_varchar2,
934: p_pel_attribute2 in varchar2 default hr_api.g_varchar2,
935: p_pel_attribute3 in varchar2 default hr_api.g_varchar2,
936: p_pel_attribute4 in varchar2 default hr_api.g_varchar2,
937: p_pel_attribute5 in varchar2 default hr_api.g_varchar2,
938: p_pel_attribute6 in varchar2 default hr_api.g_varchar2,
939: p_pel_attribute7 in varchar2 default hr_api.g_varchar2,
940: p_pel_attribute8 in varchar2 default hr_api.g_varchar2,
941: p_pel_attribute9 in varchar2 default hr_api.g_varchar2,
934: p_pel_attribute2 in varchar2 default hr_api.g_varchar2,
935: p_pel_attribute3 in varchar2 default hr_api.g_varchar2,
936: p_pel_attribute4 in varchar2 default hr_api.g_varchar2,
937: p_pel_attribute5 in varchar2 default hr_api.g_varchar2,
938: p_pel_attribute6 in varchar2 default hr_api.g_varchar2,
939: p_pel_attribute7 in varchar2 default hr_api.g_varchar2,
940: p_pel_attribute8 in varchar2 default hr_api.g_varchar2,
941: p_pel_attribute9 in varchar2 default hr_api.g_varchar2,
942: p_pel_attribute10 in varchar2 default hr_api.g_varchar2,
935: p_pel_attribute3 in varchar2 default hr_api.g_varchar2,
936: p_pel_attribute4 in varchar2 default hr_api.g_varchar2,
937: p_pel_attribute5 in varchar2 default hr_api.g_varchar2,
938: p_pel_attribute6 in varchar2 default hr_api.g_varchar2,
939: p_pel_attribute7 in varchar2 default hr_api.g_varchar2,
940: p_pel_attribute8 in varchar2 default hr_api.g_varchar2,
941: p_pel_attribute9 in varchar2 default hr_api.g_varchar2,
942: p_pel_attribute10 in varchar2 default hr_api.g_varchar2,
943: p_pel_attribute11 in varchar2 default hr_api.g_varchar2,
936: p_pel_attribute4 in varchar2 default hr_api.g_varchar2,
937: p_pel_attribute5 in varchar2 default hr_api.g_varchar2,
938: p_pel_attribute6 in varchar2 default hr_api.g_varchar2,
939: p_pel_attribute7 in varchar2 default hr_api.g_varchar2,
940: p_pel_attribute8 in varchar2 default hr_api.g_varchar2,
941: p_pel_attribute9 in varchar2 default hr_api.g_varchar2,
942: p_pel_attribute10 in varchar2 default hr_api.g_varchar2,
943: p_pel_attribute11 in varchar2 default hr_api.g_varchar2,
944: p_pel_attribute12 in varchar2 default hr_api.g_varchar2,
937: p_pel_attribute5 in varchar2 default hr_api.g_varchar2,
938: p_pel_attribute6 in varchar2 default hr_api.g_varchar2,
939: p_pel_attribute7 in varchar2 default hr_api.g_varchar2,
940: p_pel_attribute8 in varchar2 default hr_api.g_varchar2,
941: p_pel_attribute9 in varchar2 default hr_api.g_varchar2,
942: p_pel_attribute10 in varchar2 default hr_api.g_varchar2,
943: p_pel_attribute11 in varchar2 default hr_api.g_varchar2,
944: p_pel_attribute12 in varchar2 default hr_api.g_varchar2,
945: p_pel_attribute13 in varchar2 default hr_api.g_varchar2,
938: p_pel_attribute6 in varchar2 default hr_api.g_varchar2,
939: p_pel_attribute7 in varchar2 default hr_api.g_varchar2,
940: p_pel_attribute8 in varchar2 default hr_api.g_varchar2,
941: p_pel_attribute9 in varchar2 default hr_api.g_varchar2,
942: p_pel_attribute10 in varchar2 default hr_api.g_varchar2,
943: p_pel_attribute11 in varchar2 default hr_api.g_varchar2,
944: p_pel_attribute12 in varchar2 default hr_api.g_varchar2,
945: p_pel_attribute13 in varchar2 default hr_api.g_varchar2,
946: p_pel_attribute14 in varchar2 default hr_api.g_varchar2,
939: p_pel_attribute7 in varchar2 default hr_api.g_varchar2,
940: p_pel_attribute8 in varchar2 default hr_api.g_varchar2,
941: p_pel_attribute9 in varchar2 default hr_api.g_varchar2,
942: p_pel_attribute10 in varchar2 default hr_api.g_varchar2,
943: p_pel_attribute11 in varchar2 default hr_api.g_varchar2,
944: p_pel_attribute12 in varchar2 default hr_api.g_varchar2,
945: p_pel_attribute13 in varchar2 default hr_api.g_varchar2,
946: p_pel_attribute14 in varchar2 default hr_api.g_varchar2,
947: p_pel_attribute15 in varchar2 default hr_api.g_varchar2,
940: p_pel_attribute8 in varchar2 default hr_api.g_varchar2,
941: p_pel_attribute9 in varchar2 default hr_api.g_varchar2,
942: p_pel_attribute10 in varchar2 default hr_api.g_varchar2,
943: p_pel_attribute11 in varchar2 default hr_api.g_varchar2,
944: p_pel_attribute12 in varchar2 default hr_api.g_varchar2,
945: p_pel_attribute13 in varchar2 default hr_api.g_varchar2,
946: p_pel_attribute14 in varchar2 default hr_api.g_varchar2,
947: p_pel_attribute15 in varchar2 default hr_api.g_varchar2,
948: p_pel_attribute16 in varchar2 default hr_api.g_varchar2,
941: p_pel_attribute9 in varchar2 default hr_api.g_varchar2,
942: p_pel_attribute10 in varchar2 default hr_api.g_varchar2,
943: p_pel_attribute11 in varchar2 default hr_api.g_varchar2,
944: p_pel_attribute12 in varchar2 default hr_api.g_varchar2,
945: p_pel_attribute13 in varchar2 default hr_api.g_varchar2,
946: p_pel_attribute14 in varchar2 default hr_api.g_varchar2,
947: p_pel_attribute15 in varchar2 default hr_api.g_varchar2,
948: p_pel_attribute16 in varchar2 default hr_api.g_varchar2,
949: p_pel_attribute17 in varchar2 default hr_api.g_varchar2,
942: p_pel_attribute10 in varchar2 default hr_api.g_varchar2,
943: p_pel_attribute11 in varchar2 default hr_api.g_varchar2,
944: p_pel_attribute12 in varchar2 default hr_api.g_varchar2,
945: p_pel_attribute13 in varchar2 default hr_api.g_varchar2,
946: p_pel_attribute14 in varchar2 default hr_api.g_varchar2,
947: p_pel_attribute15 in varchar2 default hr_api.g_varchar2,
948: p_pel_attribute16 in varchar2 default hr_api.g_varchar2,
949: p_pel_attribute17 in varchar2 default hr_api.g_varchar2,
950: p_pel_attribute18 in varchar2 default hr_api.g_varchar2,
943: p_pel_attribute11 in varchar2 default hr_api.g_varchar2,
944: p_pel_attribute12 in varchar2 default hr_api.g_varchar2,
945: p_pel_attribute13 in varchar2 default hr_api.g_varchar2,
946: p_pel_attribute14 in varchar2 default hr_api.g_varchar2,
947: p_pel_attribute15 in varchar2 default hr_api.g_varchar2,
948: p_pel_attribute16 in varchar2 default hr_api.g_varchar2,
949: p_pel_attribute17 in varchar2 default hr_api.g_varchar2,
950: p_pel_attribute18 in varchar2 default hr_api.g_varchar2,
951: p_pel_attribute19 in varchar2 default hr_api.g_varchar2,
944: p_pel_attribute12 in varchar2 default hr_api.g_varchar2,
945: p_pel_attribute13 in varchar2 default hr_api.g_varchar2,
946: p_pel_attribute14 in varchar2 default hr_api.g_varchar2,
947: p_pel_attribute15 in varchar2 default hr_api.g_varchar2,
948: p_pel_attribute16 in varchar2 default hr_api.g_varchar2,
949: p_pel_attribute17 in varchar2 default hr_api.g_varchar2,
950: p_pel_attribute18 in varchar2 default hr_api.g_varchar2,
951: p_pel_attribute19 in varchar2 default hr_api.g_varchar2,
952: p_pel_attribute20 in varchar2 default hr_api.g_varchar2,
945: p_pel_attribute13 in varchar2 default hr_api.g_varchar2,
946: p_pel_attribute14 in varchar2 default hr_api.g_varchar2,
947: p_pel_attribute15 in varchar2 default hr_api.g_varchar2,
948: p_pel_attribute16 in varchar2 default hr_api.g_varchar2,
949: p_pel_attribute17 in varchar2 default hr_api.g_varchar2,
950: p_pel_attribute18 in varchar2 default hr_api.g_varchar2,
951: p_pel_attribute19 in varchar2 default hr_api.g_varchar2,
952: p_pel_attribute20 in varchar2 default hr_api.g_varchar2,
953: p_pel_attribute21 in varchar2 default hr_api.g_varchar2,
946: p_pel_attribute14 in varchar2 default hr_api.g_varchar2,
947: p_pel_attribute15 in varchar2 default hr_api.g_varchar2,
948: p_pel_attribute16 in varchar2 default hr_api.g_varchar2,
949: p_pel_attribute17 in varchar2 default hr_api.g_varchar2,
950: p_pel_attribute18 in varchar2 default hr_api.g_varchar2,
951: p_pel_attribute19 in varchar2 default hr_api.g_varchar2,
952: p_pel_attribute20 in varchar2 default hr_api.g_varchar2,
953: p_pel_attribute21 in varchar2 default hr_api.g_varchar2,
954: p_pel_attribute22 in varchar2 default hr_api.g_varchar2,
947: p_pel_attribute15 in varchar2 default hr_api.g_varchar2,
948: p_pel_attribute16 in varchar2 default hr_api.g_varchar2,
949: p_pel_attribute17 in varchar2 default hr_api.g_varchar2,
950: p_pel_attribute18 in varchar2 default hr_api.g_varchar2,
951: p_pel_attribute19 in varchar2 default hr_api.g_varchar2,
952: p_pel_attribute20 in varchar2 default hr_api.g_varchar2,
953: p_pel_attribute21 in varchar2 default hr_api.g_varchar2,
954: p_pel_attribute22 in varchar2 default hr_api.g_varchar2,
955: p_pel_attribute23 in varchar2 default hr_api.g_varchar2,
948: p_pel_attribute16 in varchar2 default hr_api.g_varchar2,
949: p_pel_attribute17 in varchar2 default hr_api.g_varchar2,
950: p_pel_attribute18 in varchar2 default hr_api.g_varchar2,
951: p_pel_attribute19 in varchar2 default hr_api.g_varchar2,
952: p_pel_attribute20 in varchar2 default hr_api.g_varchar2,
953: p_pel_attribute21 in varchar2 default hr_api.g_varchar2,
954: p_pel_attribute22 in varchar2 default hr_api.g_varchar2,
955: p_pel_attribute23 in varchar2 default hr_api.g_varchar2,
956: p_pel_attribute24 in varchar2 default hr_api.g_varchar2,
949: p_pel_attribute17 in varchar2 default hr_api.g_varchar2,
950: p_pel_attribute18 in varchar2 default hr_api.g_varchar2,
951: p_pel_attribute19 in varchar2 default hr_api.g_varchar2,
952: p_pel_attribute20 in varchar2 default hr_api.g_varchar2,
953: p_pel_attribute21 in varchar2 default hr_api.g_varchar2,
954: p_pel_attribute22 in varchar2 default hr_api.g_varchar2,
955: p_pel_attribute23 in varchar2 default hr_api.g_varchar2,
956: p_pel_attribute24 in varchar2 default hr_api.g_varchar2,
957: p_pel_attribute25 in varchar2 default hr_api.g_varchar2,
950: p_pel_attribute18 in varchar2 default hr_api.g_varchar2,
951: p_pel_attribute19 in varchar2 default hr_api.g_varchar2,
952: p_pel_attribute20 in varchar2 default hr_api.g_varchar2,
953: p_pel_attribute21 in varchar2 default hr_api.g_varchar2,
954: p_pel_attribute22 in varchar2 default hr_api.g_varchar2,
955: p_pel_attribute23 in varchar2 default hr_api.g_varchar2,
956: p_pel_attribute24 in varchar2 default hr_api.g_varchar2,
957: p_pel_attribute25 in varchar2 default hr_api.g_varchar2,
958: p_pel_attribute26 in varchar2 default hr_api.g_varchar2,
951: p_pel_attribute19 in varchar2 default hr_api.g_varchar2,
952: p_pel_attribute20 in varchar2 default hr_api.g_varchar2,
953: p_pel_attribute21 in varchar2 default hr_api.g_varchar2,
954: p_pel_attribute22 in varchar2 default hr_api.g_varchar2,
955: p_pel_attribute23 in varchar2 default hr_api.g_varchar2,
956: p_pel_attribute24 in varchar2 default hr_api.g_varchar2,
957: p_pel_attribute25 in varchar2 default hr_api.g_varchar2,
958: p_pel_attribute26 in varchar2 default hr_api.g_varchar2,
959: p_pel_attribute27 in varchar2 default hr_api.g_varchar2,
952: p_pel_attribute20 in varchar2 default hr_api.g_varchar2,
953: p_pel_attribute21 in varchar2 default hr_api.g_varchar2,
954: p_pel_attribute22 in varchar2 default hr_api.g_varchar2,
955: p_pel_attribute23 in varchar2 default hr_api.g_varchar2,
956: p_pel_attribute24 in varchar2 default hr_api.g_varchar2,
957: p_pel_attribute25 in varchar2 default hr_api.g_varchar2,
958: p_pel_attribute26 in varchar2 default hr_api.g_varchar2,
959: p_pel_attribute27 in varchar2 default hr_api.g_varchar2,
960: p_pel_attribute28 in varchar2 default hr_api.g_varchar2,
953: p_pel_attribute21 in varchar2 default hr_api.g_varchar2,
954: p_pel_attribute22 in varchar2 default hr_api.g_varchar2,
955: p_pel_attribute23 in varchar2 default hr_api.g_varchar2,
956: p_pel_attribute24 in varchar2 default hr_api.g_varchar2,
957: p_pel_attribute25 in varchar2 default hr_api.g_varchar2,
958: p_pel_attribute26 in varchar2 default hr_api.g_varchar2,
959: p_pel_attribute27 in varchar2 default hr_api.g_varchar2,
960: p_pel_attribute28 in varchar2 default hr_api.g_varchar2,
961: p_pel_attribute29 in varchar2 default hr_api.g_varchar2,
954: p_pel_attribute22 in varchar2 default hr_api.g_varchar2,
955: p_pel_attribute23 in varchar2 default hr_api.g_varchar2,
956: p_pel_attribute24 in varchar2 default hr_api.g_varchar2,
957: p_pel_attribute25 in varchar2 default hr_api.g_varchar2,
958: p_pel_attribute26 in varchar2 default hr_api.g_varchar2,
959: p_pel_attribute27 in varchar2 default hr_api.g_varchar2,
960: p_pel_attribute28 in varchar2 default hr_api.g_varchar2,
961: p_pel_attribute29 in varchar2 default hr_api.g_varchar2,
962: p_pel_attribute30 in varchar2 default hr_api.g_varchar2,
955: p_pel_attribute23 in varchar2 default hr_api.g_varchar2,
956: p_pel_attribute24 in varchar2 default hr_api.g_varchar2,
957: p_pel_attribute25 in varchar2 default hr_api.g_varchar2,
958: p_pel_attribute26 in varchar2 default hr_api.g_varchar2,
959: p_pel_attribute27 in varchar2 default hr_api.g_varchar2,
960: p_pel_attribute28 in varchar2 default hr_api.g_varchar2,
961: p_pel_attribute29 in varchar2 default hr_api.g_varchar2,
962: p_pel_attribute30 in varchar2 default hr_api.g_varchar2,
963: p_request_id in number default hr_api.g_number,
956: p_pel_attribute24 in varchar2 default hr_api.g_varchar2,
957: p_pel_attribute25 in varchar2 default hr_api.g_varchar2,
958: p_pel_attribute26 in varchar2 default hr_api.g_varchar2,
959: p_pel_attribute27 in varchar2 default hr_api.g_varchar2,
960: p_pel_attribute28 in varchar2 default hr_api.g_varchar2,
961: p_pel_attribute29 in varchar2 default hr_api.g_varchar2,
962: p_pel_attribute30 in varchar2 default hr_api.g_varchar2,
963: p_request_id in number default hr_api.g_number,
964: p_program_application_id in number default hr_api.g_number,
957: p_pel_attribute25 in varchar2 default hr_api.g_varchar2,
958: p_pel_attribute26 in varchar2 default hr_api.g_varchar2,
959: p_pel_attribute27 in varchar2 default hr_api.g_varchar2,
960: p_pel_attribute28 in varchar2 default hr_api.g_varchar2,
961: p_pel_attribute29 in varchar2 default hr_api.g_varchar2,
962: p_pel_attribute30 in varchar2 default hr_api.g_varchar2,
963: p_request_id in number default hr_api.g_number,
964: p_program_application_id in number default hr_api.g_number,
965: p_program_id in number default hr_api.g_number,
958: p_pel_attribute26 in varchar2 default hr_api.g_varchar2,
959: p_pel_attribute27 in varchar2 default hr_api.g_varchar2,
960: p_pel_attribute28 in varchar2 default hr_api.g_varchar2,
961: p_pel_attribute29 in varchar2 default hr_api.g_varchar2,
962: p_pel_attribute30 in varchar2 default hr_api.g_varchar2,
963: p_request_id in number default hr_api.g_number,
964: p_program_application_id in number default hr_api.g_number,
965: p_program_id in number default hr_api.g_number,
966: p_program_update_date in date default hr_api.g_date,
959: p_pel_attribute27 in varchar2 default hr_api.g_varchar2,
960: p_pel_attribute28 in varchar2 default hr_api.g_varchar2,
961: p_pel_attribute29 in varchar2 default hr_api.g_varchar2,
962: p_pel_attribute30 in varchar2 default hr_api.g_varchar2,
963: p_request_id in number default hr_api.g_number,
964: p_program_application_id in number default hr_api.g_number,
965: p_program_id in number default hr_api.g_number,
966: p_program_update_date in date default hr_api.g_date,
967: p_object_version_number in out nocopy number,
960: p_pel_attribute28 in varchar2 default hr_api.g_varchar2,
961: p_pel_attribute29 in varchar2 default hr_api.g_varchar2,
962: p_pel_attribute30 in varchar2 default hr_api.g_varchar2,
963: p_request_id in number default hr_api.g_number,
964: p_program_application_id in number default hr_api.g_number,
965: p_program_id in number default hr_api.g_number,
966: p_program_update_date in date default hr_api.g_date,
967: p_object_version_number in out nocopy number,
968: p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2,
961: p_pel_attribute29 in varchar2 default hr_api.g_varchar2,
962: p_pel_attribute30 in varchar2 default hr_api.g_varchar2,
963: p_request_id in number default hr_api.g_number,
964: p_program_application_id in number default hr_api.g_number,
965: p_program_id in number default hr_api.g_number,
966: p_program_update_date in date default hr_api.g_date,
967: p_object_version_number in out nocopy number,
968: p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2,
969: p_deenrol_made_dt in date default hr_api.g_date
962: p_pel_attribute30 in varchar2 default hr_api.g_varchar2,
963: p_request_id in number default hr_api.g_number,
964: p_program_application_id in number default hr_api.g_number,
965: p_program_id in number default hr_api.g_number,
966: p_program_update_date in date default hr_api.g_date,
967: p_object_version_number in out nocopy number,
968: p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2,
969: p_deenrol_made_dt in date default hr_api.g_date
970: ) is
964: p_program_application_id in number default hr_api.g_number,
965: p_program_id in number default hr_api.g_number,
966: p_program_update_date in date default hr_api.g_date,
967: p_object_version_number in out nocopy number,
968: p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2,
969: p_deenrol_made_dt in date default hr_api.g_date
970: ) is
971: --
972: l_rec ben_pel_shd.g_rec_type;
965: p_program_id in number default hr_api.g_number,
966: p_program_update_date in date default hr_api.g_date,
967: p_object_version_number in out nocopy number,
968: p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2,
969: p_deenrol_made_dt in date default hr_api.g_date
970: ) is
971: --
972: l_rec ben_pel_shd.g_rec_type;
973: l_proc varchar2(72) := g_package||'upd';