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