DBA Data[Home] [Help]

APPS.BEN_PEL_UPD dependencies on HR_API

Line 157: When hr_api.check_integrity_violated Then

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));

Line 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

Line 162: When hr_api.parent_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
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 167: When hr_api.unique_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
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 428: when hr_api.cannot_find_prog_unit then

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');

Line 430: hr_api.cannot_find_prog_unit_error

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;

Line 498: If (p_rec.dflt_enrt_dt = hr_api.g_date) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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:

Line 539: If (p_rec.uom = 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:
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:

Line 544: If (p_rec.comments = hr_api.g_varchar2) then

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:

Line 549: If (p_rec.mgr_ovrid_dt = hr_api.g_date) then

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:

Line 554: If (p_rec.ws_mgr_id = hr_api.g_number) then

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:

Line 559: If (p_rec.mgr_ovrid_person_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:
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:

Line 564: If (p_rec.assignment_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:
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:

Line 569: If (p_rec.mgr_ovrid_person_id = hr_api.g_number) then

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:

Line 576: If (p_rec.bdgt_acc_cd = hr_api.g_varchar2) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 621: If (p_rec.reinstate_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
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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 882: p_dflt_enrt_dt in date default hr_api.g_date,

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,

Line 883: p_dflt_asnd_dt in date default hr_api.g_date,

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,

Line 884: p_elcns_made_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,

Line 885: p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2,

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,

Line 886: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,

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,

Line 887: p_enrt_perd_end_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,
891: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,

Line 888: p_enrt_perd_strt_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,
892: p_uom in varchar2 default hr_api.g_varchar2,

Line 889: p_procg_end_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,
893: p_comments in varchar2 default hr_api.g_varchar2,

Line 890: p_pil_elctbl_popl_stat_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,
894: p_mgr_ovrid_dt in date default hr_api.g_date,

Line 891: p_acty_ref_perd_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,
895: p_ws_mgr_id in number default hr_api.g_number,

Line 892: p_uom in varchar2 default hr_api.g_varchar2,

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,

Line 893: p_comments in varchar2 default hr_api.g_varchar2,

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,

Line 894: p_mgr_ovrid_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,
898: --cwb

Line 895: p_ws_mgr_id in number default hr_api.g_number,

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,

Line 896: p_mgr_ovrid_person_id in number default hr_api.g_number,

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,

Line 897: p_assignment_id in number default hr_api.g_number,

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,

Line 899: p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2,

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,

Line 900: p_pop_cd in varchar2 default hr_api.g_varchar2,

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,

Line 901: p_bdgt_due_dt in date default hr_api.g_date,

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,

Line 902: p_bdgt_export_flag 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,

Line 903: p_bdgt_iss_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,

Line 904: p_bdgt_stat_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,
908: p_ws_iss_dt in date default hr_api.g_date,

Line 905: p_ws_acc_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,
909: p_ws_stat_cd in varchar2 default hr_api.g_varchar2,

Line 906: p_ws_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,
910: --cwb

Line 907: p_ws_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
911: p_reinstate_cd in varchar2 default hr_api.g_varchar2,

Line 908: p_ws_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,
912: p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2,

Line 909: p_ws_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,
913: p_auto_asnd_dt in date default hr_api.g_date,

Line 911: p_reinstate_cd in varchar2 default hr_api.g_varchar2,

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,

Line 912: p_reinstate_ovrdn_cd 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,
916: p_lee_rsn_id in number default hr_api.g_number,

Line 913: p_auto_asnd_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,
917: p_enrt_perd_id in number default hr_api.g_number,

Line 914: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,

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,

Line 915: p_cbr_elig_perd_end_dt in date default hr_api.g_date,

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,

Line 916: p_lee_rsn_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,

Line 917: p_enrt_perd_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,

Line 918: p_per_in_ler_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,

Line 919: p_pgm_id in number default hr_api.g_number,

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,

Line 920: p_pl_id in number default hr_api.g_number,

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,

Line 921: p_business_group_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,
925: p_pel_attribute3 in varchar2 default hr_api.g_varchar2,

Line 922: p_pel_attribute_category 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,

Line 923: p_pel_attribute1 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,

Line 924: p_pel_attribute2 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,

Line 925: p_pel_attribute3 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,

Line 926: p_pel_attribute4 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,

Line 927: p_pel_attribute5 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,

Line 928: p_pel_attribute6 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,

Line 929: p_pel_attribute7 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,

Line 930: p_pel_attribute8 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,

Line 931: p_pel_attribute9 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,

Line 932: p_pel_attribute10 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,

Line 933: p_pel_attribute11 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,

Line 934: p_pel_attribute12 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,

Line 935: p_pel_attribute13 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,

Line 936: p_pel_attribute14 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,

Line 937: p_pel_attribute15 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,

Line 938: p_pel_attribute16 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,

Line 939: p_pel_attribute17 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,

Line 940: p_pel_attribute18 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,

Line 941: p_pel_attribute19 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,

Line 942: p_pel_attribute20 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,

Line 943: p_pel_attribute21 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,

Line 944: p_pel_attribute22 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,

Line 945: p_pel_attribute23 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,

Line 946: p_pel_attribute24 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,

Line 947: p_pel_attribute25 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,

Line 948: p_pel_attribute26 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,

Line 949: p_pel_attribute27 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,

Line 950: p_pel_attribute28 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,
954: p_program_application_id in number default hr_api.g_number,

Line 951: p_pel_attribute29 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,
955: p_program_id in number default hr_api.g_number,

Line 952: p_pel_attribute30 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,
956: p_program_update_date in date default hr_api.g_date,

Line 953: p_request_id in number default hr_api.g_number,

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,

Line 954: p_program_application_id in number default hr_api.g_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,

Line 955: p_program_id in number default hr_api.g_number,

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

Line 956: p_program_update_date 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

Line 958: p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2,

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;

Line 959: p_deenrol_made_dt in date default hr_api.g_date

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';