APPS.BEN_EPA_UPD dependencies on HR_API

Line 156: When hr_api.check_integrity_violated Then

152: End If;
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 15);
155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
159: ben_epa_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
159: ben_epa_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
164: ben_epa_shd.constraint_error

Line 161: When hr_api.unique_integrity_violated Then

157: -- A check constraint has been violated
158: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
159: ben_epa_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
164: ben_epa_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
164: ben_epa_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
168: Raise;
169: End dt_update_dml;

Line 547: when hr_api.cannot_find_prog_unit then

543: );
544: --
545: exception
546: --
547: when hr_api.cannot_find_prog_unit then
548: --
549: hr_api.cannot_find_prog_unit_error
550: (p_module_name => 'ben_prtn_elig_f'
551: ,p_hook_type => 'AU');

Line 549: hr_api.cannot_find_prog_unit_error

545: exception
546: --
547: when hr_api.cannot_find_prog_unit then
548: --
549: hr_api.cannot_find_prog_unit_error
550: (p_module_name => 'ben_prtn_elig_f'
551: ,p_hook_type => 'AU');
552: --
553: end;

Line 616: If (p_rec.business_group_id = hr_api.g_number) then

612: -- p_rec plsql record structure
613: -- to see if a system default is being used. If a system default
614: -- is being used then we must set to the 'current' argument value.
615: --
616: If (p_rec.business_group_id = hr_api.g_number) then
617: p_rec.business_group_id :=
618: ben_epa_shd.g_old_rec.business_group_id;
619: End If;
620: If (p_rec.pgm_id = hr_api.g_number) then

Line 620: If (p_rec.pgm_id = hr_api.g_number) then

616: If (p_rec.business_group_id = hr_api.g_number) then
617: p_rec.business_group_id :=
618: ben_epa_shd.g_old_rec.business_group_id;
619: End If;
620: If (p_rec.pgm_id = hr_api.g_number) then
621: p_rec.pgm_id :=
622: ben_epa_shd.g_old_rec.pgm_id;
623: End If;
624: If (p_rec.pl_id = hr_api.g_number) then

Line 624: If (p_rec.pl_id = hr_api.g_number) then

620: If (p_rec.pgm_id = hr_api.g_number) then
621: p_rec.pgm_id :=
622: ben_epa_shd.g_old_rec.pgm_id;
623: End If;
624: If (p_rec.pl_id = hr_api.g_number) then
625: p_rec.pl_id :=
626: ben_epa_shd.g_old_rec.pl_id;
627: End If;
628: If (p_rec.oipl_id = hr_api.g_number) then

Line 628: If (p_rec.oipl_id = hr_api.g_number) then

624: If (p_rec.pl_id = hr_api.g_number) then
625: p_rec.pl_id :=
626: ben_epa_shd.g_old_rec.pl_id;
627: End If;
628: If (p_rec.oipl_id = hr_api.g_number) then
629: p_rec.oipl_id :=
630: ben_epa_shd.g_old_rec.oipl_id;
631: End If;
632: If (p_rec.ptip_id = hr_api.g_number) then

Line 632: If (p_rec.ptip_id = hr_api.g_number) then

628: If (p_rec.oipl_id = hr_api.g_number) then
629: p_rec.oipl_id :=
630: ben_epa_shd.g_old_rec.oipl_id;
631: End If;
632: If (p_rec.ptip_id = hr_api.g_number) then
633: p_rec.ptip_id :=
634: ben_epa_shd.g_old_rec.ptip_id;
635: End If;
636: If (p_rec.plip_id = hr_api.g_number) then

Line 636: If (p_rec.plip_id = hr_api.g_number) then

632: If (p_rec.ptip_id = hr_api.g_number) then
633: p_rec.ptip_id :=
634: ben_epa_shd.g_old_rec.ptip_id;
635: End If;
636: If (p_rec.plip_id = hr_api.g_number) then
637: p_rec.plip_id :=
638: ben_epa_shd.g_old_rec.plip_id;
639: End If;
640: If (p_rec.prtn_eff_strt_dt_cd = hr_api.g_varchar2) then

Line 640: If (p_rec.prtn_eff_strt_dt_cd = hr_api.g_varchar2) then

636: If (p_rec.plip_id = hr_api.g_number) then
637: p_rec.plip_id :=
638: ben_epa_shd.g_old_rec.plip_id;
639: End If;
640: If (p_rec.prtn_eff_strt_dt_cd = hr_api.g_varchar2) then
641: p_rec.prtn_eff_strt_dt_cd :=
642: ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd;
643: End If;
644: If (p_rec.trk_scr_for_inelg_flag = hr_api.g_varchar2) then

Line 644: If (p_rec.trk_scr_for_inelg_flag = hr_api.g_varchar2) then

640: If (p_rec.prtn_eff_strt_dt_cd = hr_api.g_varchar2) then
641: p_rec.prtn_eff_strt_dt_cd :=
642: ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd;
643: End If;
644: If (p_rec.trk_scr_for_inelg_flag = hr_api.g_varchar2) then
645: p_rec.trk_scr_for_inelg_flag :=
646: ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag;
647: End If;
648: If (p_rec.prtn_eff_end_dt_cd = hr_api.g_varchar2) then

Line 648: If (p_rec.prtn_eff_end_dt_cd = hr_api.g_varchar2) then

644: If (p_rec.trk_scr_for_inelg_flag = hr_api.g_varchar2) then
645: p_rec.trk_scr_for_inelg_flag :=
646: ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag;
647: End If;
648: If (p_rec.prtn_eff_end_dt_cd = hr_api.g_varchar2) then
649: p_rec.prtn_eff_end_dt_cd :=
650: ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd;
651: End If;
652: If (p_rec.prtn_eff_strt_dt_rl = hr_api.g_number) then

Line 652: If (p_rec.prtn_eff_strt_dt_rl = hr_api.g_number) then

648: If (p_rec.prtn_eff_end_dt_cd = hr_api.g_varchar2) then
649: p_rec.prtn_eff_end_dt_cd :=
650: ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd;
651: End If;
652: If (p_rec.prtn_eff_strt_dt_rl = hr_api.g_number) then
653: p_rec.prtn_eff_strt_dt_rl :=
654: ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl;
655: End If;
656: If (p_rec.prtn_eff_end_dt_rl = hr_api.g_number) then

Line 656: If (p_rec.prtn_eff_end_dt_rl = hr_api.g_number) then

652: If (p_rec.prtn_eff_strt_dt_rl = hr_api.g_number) then
653: p_rec.prtn_eff_strt_dt_rl :=
654: ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl;
655: End If;
656: If (p_rec.prtn_eff_end_dt_rl = hr_api.g_number) then
657: p_rec.prtn_eff_end_dt_rl :=
658: ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl;
659: End If;
660: If (p_rec.wait_perd_dt_to_use_cd = hr_api.g_varchar2) then

Line 660: If (p_rec.wait_perd_dt_to_use_cd = hr_api.g_varchar2) then

656: If (p_rec.prtn_eff_end_dt_rl = hr_api.g_number) then
657: p_rec.prtn_eff_end_dt_rl :=
658: ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl;
659: End If;
660: If (p_rec.wait_perd_dt_to_use_cd = hr_api.g_varchar2) then
661: p_rec.wait_perd_dt_to_use_cd :=
662: ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd;
663: End If;
664: If (p_rec.wait_perd_dt_to_use_rl = hr_api.g_number) then

Line 664: If (p_rec.wait_perd_dt_to_use_rl = hr_api.g_number) then

660: If (p_rec.wait_perd_dt_to_use_cd = hr_api.g_varchar2) then
661: p_rec.wait_perd_dt_to_use_cd :=
662: ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd;
663: End If;
664: If (p_rec.wait_perd_dt_to_use_rl = hr_api.g_number) then
665: p_rec.wait_perd_dt_to_use_rl :=
666: ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl;
667: End If;
668: If (p_rec.wait_perd_val = hr_api.g_number) then

Line 668: If (p_rec.wait_perd_val = hr_api.g_number) then

664: If (p_rec.wait_perd_dt_to_use_rl = hr_api.g_number) then
665: p_rec.wait_perd_dt_to_use_rl :=
666: ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl;
667: End If;
668: If (p_rec.wait_perd_val = hr_api.g_number) then
669: p_rec.wait_perd_val :=
670: ben_epa_shd.g_old_rec.wait_perd_val;
671: End If;
672: If (p_rec.wait_perd_uom = hr_api.g_varchar2) then

Line 672: If (p_rec.wait_perd_uom = hr_api.g_varchar2) then

668: If (p_rec.wait_perd_val = hr_api.g_number) then
669: p_rec.wait_perd_val :=
670: ben_epa_shd.g_old_rec.wait_perd_val;
671: End If;
672: If (p_rec.wait_perd_uom = hr_api.g_varchar2) then
673: p_rec.wait_perd_uom :=
674: ben_epa_shd.g_old_rec.wait_perd_uom;
675: End If;
676: If (p_rec.wait_perd_rl = hr_api.g_number) then

Line 676: If (p_rec.wait_perd_rl = hr_api.g_number) then

672: If (p_rec.wait_perd_uom = hr_api.g_varchar2) then
673: p_rec.wait_perd_uom :=
674: ben_epa_shd.g_old_rec.wait_perd_uom;
675: End If;
676: If (p_rec.wait_perd_rl = hr_api.g_number) then
677: p_rec.wait_perd_rl :=
678: ben_epa_shd.g_old_rec.wait_perd_rl;
679: End If;
680: If (p_rec.mx_poe_det_dt_cd = hr_api.g_varchar2) then

Line 680: If (p_rec.mx_poe_det_dt_cd = hr_api.g_varchar2) then

676: If (p_rec.wait_perd_rl = hr_api.g_number) then
677: p_rec.wait_perd_rl :=
678: ben_epa_shd.g_old_rec.wait_perd_rl;
679: End If;
680: If (p_rec.mx_poe_det_dt_cd = hr_api.g_varchar2) then
681: p_rec.mx_poe_det_dt_cd :=
682: ben_epa_shd.g_old_rec.mx_poe_det_dt_cd;
683: End If;
684: If (p_rec.mx_poe_det_dt_rl = hr_api.g_number) then

Line 684: If (p_rec.mx_poe_det_dt_rl = hr_api.g_number) then

680: If (p_rec.mx_poe_det_dt_cd = hr_api.g_varchar2) then
681: p_rec.mx_poe_det_dt_cd :=
682: ben_epa_shd.g_old_rec.mx_poe_det_dt_cd;
683: End If;
684: If (p_rec.mx_poe_det_dt_rl = hr_api.g_number) then
685: p_rec.mx_poe_det_dt_rl :=
686: ben_epa_shd.g_old_rec.mx_poe_det_dt_rl;
687: End If;
688: If (p_rec.mx_poe_val = hr_api.g_number) then

Line 688: If (p_rec.mx_poe_val = hr_api.g_number) then

684: If (p_rec.mx_poe_det_dt_rl = hr_api.g_number) then
685: p_rec.mx_poe_det_dt_rl :=
686: ben_epa_shd.g_old_rec.mx_poe_det_dt_rl;
687: End If;
688: If (p_rec.mx_poe_val = hr_api.g_number) then
689: p_rec.mx_poe_val :=
690: ben_epa_shd.g_old_rec.mx_poe_val;
691: End If;
692: If (p_rec.mx_poe_uom = hr_api.g_varchar2) then

Line 692: If (p_rec.mx_poe_uom = hr_api.g_varchar2) then

688: If (p_rec.mx_poe_val = hr_api.g_number) then
689: p_rec.mx_poe_val :=
690: ben_epa_shd.g_old_rec.mx_poe_val;
691: End If;
692: If (p_rec.mx_poe_uom = hr_api.g_varchar2) then
693: p_rec.mx_poe_uom :=
694: ben_epa_shd.g_old_rec.mx_poe_uom;
695: End If;
696: If (p_rec.mx_poe_rl = hr_api.g_number) then

Line 696: If (p_rec.mx_poe_rl = hr_api.g_number) then

692: If (p_rec.mx_poe_uom = hr_api.g_varchar2) then
693: p_rec.mx_poe_uom :=
694: ben_epa_shd.g_old_rec.mx_poe_uom;
695: End If;
696: If (p_rec.mx_poe_rl = hr_api.g_number) then
697: p_rec.mx_poe_rl :=
698: ben_epa_shd.g_old_rec.mx_poe_rl;
699: End If;
700: If (p_rec.mx_poe_apls_cd = hr_api.g_varchar2) then

Line 700: If (p_rec.mx_poe_apls_cd = hr_api.g_varchar2) then

696: If (p_rec.mx_poe_rl = hr_api.g_number) then
697: p_rec.mx_poe_rl :=
698: ben_epa_shd.g_old_rec.mx_poe_rl;
699: End If;
700: If (p_rec.mx_poe_apls_cd = hr_api.g_varchar2) then
701: p_rec.mx_poe_apls_cd :=
702: ben_epa_shd.g_old_rec.mx_poe_apls_cd;
703: End If;
704: If (p_rec.epa_attribute_category = hr_api.g_varchar2) then

Line 704: If (p_rec.epa_attribute_category = hr_api.g_varchar2) then

700: If (p_rec.mx_poe_apls_cd = hr_api.g_varchar2) then
701: p_rec.mx_poe_apls_cd :=
702: ben_epa_shd.g_old_rec.mx_poe_apls_cd;
703: End If;
704: If (p_rec.epa_attribute_category = hr_api.g_varchar2) then
705: p_rec.epa_attribute_category :=
706: ben_epa_shd.g_old_rec.epa_attribute_category;
707: End If;
708: If (p_rec.epa_attribute1 = hr_api.g_varchar2) then

Line 708: If (p_rec.epa_attribute1 = hr_api.g_varchar2) then

704: If (p_rec.epa_attribute_category = hr_api.g_varchar2) then
705: p_rec.epa_attribute_category :=
706: ben_epa_shd.g_old_rec.epa_attribute_category;
707: End If;
708: If (p_rec.epa_attribute1 = hr_api.g_varchar2) then
709: p_rec.epa_attribute1 :=
710: ben_epa_shd.g_old_rec.epa_attribute1;
711: End If;
712: If (p_rec.epa_attribute2 = hr_api.g_varchar2) then

Line 712: If (p_rec.epa_attribute2 = hr_api.g_varchar2) then

708: If (p_rec.epa_attribute1 = hr_api.g_varchar2) then
709: p_rec.epa_attribute1 :=
710: ben_epa_shd.g_old_rec.epa_attribute1;
711: End If;
712: If (p_rec.epa_attribute2 = hr_api.g_varchar2) then
713: p_rec.epa_attribute2 :=
714: ben_epa_shd.g_old_rec.epa_attribute2;
715: End If;
716: If (p_rec.epa_attribute3 = hr_api.g_varchar2) then

Line 716: If (p_rec.epa_attribute3 = hr_api.g_varchar2) then

712: If (p_rec.epa_attribute2 = hr_api.g_varchar2) then
713: p_rec.epa_attribute2 :=
714: ben_epa_shd.g_old_rec.epa_attribute2;
715: End If;
716: If (p_rec.epa_attribute3 = hr_api.g_varchar2) then
717: p_rec.epa_attribute3 :=
718: ben_epa_shd.g_old_rec.epa_attribute3;
719: End If;
720: If (p_rec.epa_attribute4 = hr_api.g_varchar2) then

Line 720: If (p_rec.epa_attribute4 = hr_api.g_varchar2) then

716: If (p_rec.epa_attribute3 = hr_api.g_varchar2) then
717: p_rec.epa_attribute3 :=
718: ben_epa_shd.g_old_rec.epa_attribute3;
719: End If;
720: If (p_rec.epa_attribute4 = hr_api.g_varchar2) then
721: p_rec.epa_attribute4 :=
722: ben_epa_shd.g_old_rec.epa_attribute4;
723: End If;
724: If (p_rec.epa_attribute5 = hr_api.g_varchar2) then

Line 724: If (p_rec.epa_attribute5 = hr_api.g_varchar2) then

720: If (p_rec.epa_attribute4 = hr_api.g_varchar2) then
721: p_rec.epa_attribute4 :=
722: ben_epa_shd.g_old_rec.epa_attribute4;
723: End If;
724: If (p_rec.epa_attribute5 = hr_api.g_varchar2) then
725: p_rec.epa_attribute5 :=
726: ben_epa_shd.g_old_rec.epa_attribute5;
727: End If;
728: If (p_rec.epa_attribute6 = hr_api.g_varchar2) then

Line 728: If (p_rec.epa_attribute6 = hr_api.g_varchar2) then

724: If (p_rec.epa_attribute5 = hr_api.g_varchar2) then
725: p_rec.epa_attribute5 :=
726: ben_epa_shd.g_old_rec.epa_attribute5;
727: End If;
728: If (p_rec.epa_attribute6 = hr_api.g_varchar2) then
729: p_rec.epa_attribute6 :=
730: ben_epa_shd.g_old_rec.epa_attribute6;
731: End If;
732: If (p_rec.epa_attribute7 = hr_api.g_varchar2) then

Line 732: If (p_rec.epa_attribute7 = hr_api.g_varchar2) then

728: If (p_rec.epa_attribute6 = hr_api.g_varchar2) then
729: p_rec.epa_attribute6 :=
730: ben_epa_shd.g_old_rec.epa_attribute6;
731: End If;
732: If (p_rec.epa_attribute7 = hr_api.g_varchar2) then
733: p_rec.epa_attribute7 :=
734: ben_epa_shd.g_old_rec.epa_attribute7;
735: End If;
736: If (p_rec.epa_attribute8 = hr_api.g_varchar2) then

Line 736: If (p_rec.epa_attribute8 = hr_api.g_varchar2) then

732: If (p_rec.epa_attribute7 = hr_api.g_varchar2) then
733: p_rec.epa_attribute7 :=
734: ben_epa_shd.g_old_rec.epa_attribute7;
735: End If;
736: If (p_rec.epa_attribute8 = hr_api.g_varchar2) then
737: p_rec.epa_attribute8 :=
738: ben_epa_shd.g_old_rec.epa_attribute8;
739: End If;
740: If (p_rec.epa_attribute9 = hr_api.g_varchar2) then

Line 740: If (p_rec.epa_attribute9 = hr_api.g_varchar2) then

736: If (p_rec.epa_attribute8 = hr_api.g_varchar2) then
737: p_rec.epa_attribute8 :=
738: ben_epa_shd.g_old_rec.epa_attribute8;
739: End If;
740: If (p_rec.epa_attribute9 = hr_api.g_varchar2) then
741: p_rec.epa_attribute9 :=
742: ben_epa_shd.g_old_rec.epa_attribute9;
743: End If;
744: If (p_rec.epa_attribute10 = hr_api.g_varchar2) then

Line 744: If (p_rec.epa_attribute10 = hr_api.g_varchar2) then

740: If (p_rec.epa_attribute9 = hr_api.g_varchar2) then
741: p_rec.epa_attribute9 :=
742: ben_epa_shd.g_old_rec.epa_attribute9;
743: End If;
744: If (p_rec.epa_attribute10 = hr_api.g_varchar2) then
745: p_rec.epa_attribute10 :=
746: ben_epa_shd.g_old_rec.epa_attribute10;
747: End If;
748: If (p_rec.epa_attribute11 = hr_api.g_varchar2) then

Line 748: If (p_rec.epa_attribute11 = hr_api.g_varchar2) then

744: If (p_rec.epa_attribute10 = hr_api.g_varchar2) then
745: p_rec.epa_attribute10 :=
746: ben_epa_shd.g_old_rec.epa_attribute10;
747: End If;
748: If (p_rec.epa_attribute11 = hr_api.g_varchar2) then
749: p_rec.epa_attribute11 :=
750: ben_epa_shd.g_old_rec.epa_attribute11;
751: End If;
752: If (p_rec.epa_attribute12 = hr_api.g_varchar2) then

Line 752: If (p_rec.epa_attribute12 = hr_api.g_varchar2) then

748: If (p_rec.epa_attribute11 = hr_api.g_varchar2) then
749: p_rec.epa_attribute11 :=
750: ben_epa_shd.g_old_rec.epa_attribute11;
751: End If;
752: If (p_rec.epa_attribute12 = hr_api.g_varchar2) then
753: p_rec.epa_attribute12 :=
754: ben_epa_shd.g_old_rec.epa_attribute12;
755: End If;
756: If (p_rec.epa_attribute13 = hr_api.g_varchar2) then

Line 756: If (p_rec.epa_attribute13 = hr_api.g_varchar2) then

752: If (p_rec.epa_attribute12 = hr_api.g_varchar2) then
753: p_rec.epa_attribute12 :=
754: ben_epa_shd.g_old_rec.epa_attribute12;
755: End If;
756: If (p_rec.epa_attribute13 = hr_api.g_varchar2) then
757: p_rec.epa_attribute13 :=
758: ben_epa_shd.g_old_rec.epa_attribute13;
759: End If;
760: If (p_rec.epa_attribute14 = hr_api.g_varchar2) then

Line 760: If (p_rec.epa_attribute14 = hr_api.g_varchar2) then

756: If (p_rec.epa_attribute13 = hr_api.g_varchar2) then
757: p_rec.epa_attribute13 :=
758: ben_epa_shd.g_old_rec.epa_attribute13;
759: End If;
760: If (p_rec.epa_attribute14 = hr_api.g_varchar2) then
761: p_rec.epa_attribute14 :=
762: ben_epa_shd.g_old_rec.epa_attribute14;
763: End If;
764: If (p_rec.epa_attribute15 = hr_api.g_varchar2) then

Line 764: If (p_rec.epa_attribute15 = hr_api.g_varchar2) then

760: If (p_rec.epa_attribute14 = hr_api.g_varchar2) then
761: p_rec.epa_attribute14 :=
762: ben_epa_shd.g_old_rec.epa_attribute14;
763: End If;
764: If (p_rec.epa_attribute15 = hr_api.g_varchar2) then
765: p_rec.epa_attribute15 :=
766: ben_epa_shd.g_old_rec.epa_attribute15;
767: End If;
768: If (p_rec.epa_attribute16 = hr_api.g_varchar2) then

Line 768: If (p_rec.epa_attribute16 = hr_api.g_varchar2) then

764: If (p_rec.epa_attribute15 = hr_api.g_varchar2) then
765: p_rec.epa_attribute15 :=
766: ben_epa_shd.g_old_rec.epa_attribute15;
767: End If;
768: If (p_rec.epa_attribute16 = hr_api.g_varchar2) then
769: p_rec.epa_attribute16 :=
770: ben_epa_shd.g_old_rec.epa_attribute16;
771: End If;
772: If (p_rec.epa_attribute17 = hr_api.g_varchar2) then

Line 772: If (p_rec.epa_attribute17 = hr_api.g_varchar2) then

768: If (p_rec.epa_attribute16 = hr_api.g_varchar2) then
769: p_rec.epa_attribute16 :=
770: ben_epa_shd.g_old_rec.epa_attribute16;
771: End If;
772: If (p_rec.epa_attribute17 = hr_api.g_varchar2) then
773: p_rec.epa_attribute17 :=
774: ben_epa_shd.g_old_rec.epa_attribute17;
775: End If;
776: If (p_rec.epa_attribute18 = hr_api.g_varchar2) then

Line 776: If (p_rec.epa_attribute18 = hr_api.g_varchar2) then

772: If (p_rec.epa_attribute17 = hr_api.g_varchar2) then
773: p_rec.epa_attribute17 :=
774: ben_epa_shd.g_old_rec.epa_attribute17;
775: End If;
776: If (p_rec.epa_attribute18 = hr_api.g_varchar2) then
777: p_rec.epa_attribute18 :=
778: ben_epa_shd.g_old_rec.epa_attribute18;
779: End If;
780: If (p_rec.epa_attribute19 = hr_api.g_varchar2) then

Line 780: If (p_rec.epa_attribute19 = hr_api.g_varchar2) then

776: If (p_rec.epa_attribute18 = hr_api.g_varchar2) then
777: p_rec.epa_attribute18 :=
778: ben_epa_shd.g_old_rec.epa_attribute18;
779: End If;
780: If (p_rec.epa_attribute19 = hr_api.g_varchar2) then
781: p_rec.epa_attribute19 :=
782: ben_epa_shd.g_old_rec.epa_attribute19;
783: End If;
784: If (p_rec.epa_attribute20 = hr_api.g_varchar2) then

Line 784: If (p_rec.epa_attribute20 = hr_api.g_varchar2) then

780: If (p_rec.epa_attribute19 = hr_api.g_varchar2) then
781: p_rec.epa_attribute19 :=
782: ben_epa_shd.g_old_rec.epa_attribute19;
783: End If;
784: If (p_rec.epa_attribute20 = hr_api.g_varchar2) then
785: p_rec.epa_attribute20 :=
786: ben_epa_shd.g_old_rec.epa_attribute20;
787: End If;
788: If (p_rec.epa_attribute21 = hr_api.g_varchar2) then

Line 788: If (p_rec.epa_attribute21 = hr_api.g_varchar2) then

784: If (p_rec.epa_attribute20 = hr_api.g_varchar2) then
785: p_rec.epa_attribute20 :=
786: ben_epa_shd.g_old_rec.epa_attribute20;
787: End If;
788: If (p_rec.epa_attribute21 = hr_api.g_varchar2) then
789: p_rec.epa_attribute21 :=
790: ben_epa_shd.g_old_rec.epa_attribute21;
791: End If;
792: If (p_rec.epa_attribute22 = hr_api.g_varchar2) then

Line 792: If (p_rec.epa_attribute22 = hr_api.g_varchar2) then

788: If (p_rec.epa_attribute21 = hr_api.g_varchar2) then
789: p_rec.epa_attribute21 :=
790: ben_epa_shd.g_old_rec.epa_attribute21;
791: End If;
792: If (p_rec.epa_attribute22 = hr_api.g_varchar2) then
793: p_rec.epa_attribute22 :=
794: ben_epa_shd.g_old_rec.epa_attribute22;
795: End If;
796: If (p_rec.epa_attribute23 = hr_api.g_varchar2) then

Line 796: If (p_rec.epa_attribute23 = hr_api.g_varchar2) then

792: If (p_rec.epa_attribute22 = hr_api.g_varchar2) then
793: p_rec.epa_attribute22 :=
794: ben_epa_shd.g_old_rec.epa_attribute22;
795: End If;
796: If (p_rec.epa_attribute23 = hr_api.g_varchar2) then
797: p_rec.epa_attribute23 :=
798: ben_epa_shd.g_old_rec.epa_attribute23;
799: End If;
800: If (p_rec.epa_attribute24 = hr_api.g_varchar2) then

Line 800: If (p_rec.epa_attribute24 = hr_api.g_varchar2) then

796: If (p_rec.epa_attribute23 = hr_api.g_varchar2) then
797: p_rec.epa_attribute23 :=
798: ben_epa_shd.g_old_rec.epa_attribute23;
799: End If;
800: If (p_rec.epa_attribute24 = hr_api.g_varchar2) then
801: p_rec.epa_attribute24 :=
802: ben_epa_shd.g_old_rec.epa_attribute24;
803: End If;
804: If (p_rec.epa_attribute25 = hr_api.g_varchar2) then

Line 804: If (p_rec.epa_attribute25 = hr_api.g_varchar2) then

800: If (p_rec.epa_attribute24 = hr_api.g_varchar2) then
801: p_rec.epa_attribute24 :=
802: ben_epa_shd.g_old_rec.epa_attribute24;
803: End If;
804: If (p_rec.epa_attribute25 = hr_api.g_varchar2) then
805: p_rec.epa_attribute25 :=
806: ben_epa_shd.g_old_rec.epa_attribute25;
807: End If;
808: If (p_rec.epa_attribute26 = hr_api.g_varchar2) then

Line 808: If (p_rec.epa_attribute26 = hr_api.g_varchar2) then

804: If (p_rec.epa_attribute25 = hr_api.g_varchar2) then
805: p_rec.epa_attribute25 :=
806: ben_epa_shd.g_old_rec.epa_attribute25;
807: End If;
808: If (p_rec.epa_attribute26 = hr_api.g_varchar2) then
809: p_rec.epa_attribute26 :=
810: ben_epa_shd.g_old_rec.epa_attribute26;
811: End If;
812: If (p_rec.epa_attribute27 = hr_api.g_varchar2) then

Line 812: If (p_rec.epa_attribute27 = hr_api.g_varchar2) then

808: If (p_rec.epa_attribute26 = hr_api.g_varchar2) then
809: p_rec.epa_attribute26 :=
810: ben_epa_shd.g_old_rec.epa_attribute26;
811: End If;
812: If (p_rec.epa_attribute27 = hr_api.g_varchar2) then
813: p_rec.epa_attribute27 :=
814: ben_epa_shd.g_old_rec.epa_attribute27;
815: End If;
816: If (p_rec.epa_attribute28 = hr_api.g_varchar2) then

Line 816: If (p_rec.epa_attribute28 = hr_api.g_varchar2) then

812: If (p_rec.epa_attribute27 = hr_api.g_varchar2) then
813: p_rec.epa_attribute27 :=
814: ben_epa_shd.g_old_rec.epa_attribute27;
815: End If;
816: If (p_rec.epa_attribute28 = hr_api.g_varchar2) then
817: p_rec.epa_attribute28 :=
818: ben_epa_shd.g_old_rec.epa_attribute28;
819: End If;
820: If (p_rec.epa_attribute29 = hr_api.g_varchar2) then

Line 820: If (p_rec.epa_attribute29 = hr_api.g_varchar2) then

816: If (p_rec.epa_attribute28 = hr_api.g_varchar2) then
817: p_rec.epa_attribute28 :=
818: ben_epa_shd.g_old_rec.epa_attribute28;
819: End If;
820: If (p_rec.epa_attribute29 = hr_api.g_varchar2) then
821: p_rec.epa_attribute29 :=
822: ben_epa_shd.g_old_rec.epa_attribute29;
823: End If;
824: If (p_rec.epa_attribute30 = hr_api.g_varchar2) then

Line 824: If (p_rec.epa_attribute30 = hr_api.g_varchar2) then

820: If (p_rec.epa_attribute29 = hr_api.g_varchar2) then
821: p_rec.epa_attribute29 :=
822: ben_epa_shd.g_old_rec.epa_attribute29;
823: End If;
824: If (p_rec.epa_attribute30 = hr_api.g_varchar2) then
825: p_rec.epa_attribute30 :=
826: ben_epa_shd.g_old_rec.epa_attribute30;
827: End If;
828:

Line 915: p_business_group_id in number default hr_api.g_number,

911: (
912: p_prtn_elig_id in number,
913: p_effective_start_date out nocopy date,
914: p_effective_end_date out nocopy date,
915: p_business_group_id in number default hr_api.g_number,
916: p_pgm_id in number default hr_api.g_number,
917: p_pl_id in number default hr_api.g_number,
918: p_oipl_id in number default hr_api.g_number,
919: p_ptip_id in number default hr_api.g_number,

Line 916: p_pgm_id in number default hr_api.g_number,

912: p_prtn_elig_id in number,
913: p_effective_start_date out nocopy date,
914: p_effective_end_date out nocopy date,
915: p_business_group_id in number default hr_api.g_number,
916: p_pgm_id in number default hr_api.g_number,
917: p_pl_id in number default hr_api.g_number,
918: p_oipl_id in number default hr_api.g_number,
919: p_ptip_id in number default hr_api.g_number,
920: p_plip_id in number default hr_api.g_number,

Line 917: p_pl_id in number default hr_api.g_number,

913: p_effective_start_date out nocopy date,
914: p_effective_end_date out nocopy date,
915: p_business_group_id in number default hr_api.g_number,
916: p_pgm_id in number default hr_api.g_number,
917: p_pl_id in number default hr_api.g_number,
918: p_oipl_id in number default hr_api.g_number,
919: p_ptip_id in number default hr_api.g_number,
920: p_plip_id in number default hr_api.g_number,
921: p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2,

Line 918: p_oipl_id in number default hr_api.g_number,

914: p_effective_end_date out nocopy date,
915: p_business_group_id in number default hr_api.g_number,
916: p_pgm_id in number default hr_api.g_number,
917: p_pl_id in number default hr_api.g_number,
918: p_oipl_id in number default hr_api.g_number,
919: p_ptip_id in number default hr_api.g_number,
920: p_plip_id in number default hr_api.g_number,
921: p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2,
922: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,

Line 919: p_ptip_id in number default hr_api.g_number,

915: p_business_group_id in number default hr_api.g_number,
916: p_pgm_id in number default hr_api.g_number,
917: p_pl_id in number default hr_api.g_number,
918: p_oipl_id in number default hr_api.g_number,
919: p_ptip_id in number default hr_api.g_number,
920: p_plip_id in number default hr_api.g_number,
921: p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2,
922: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
923: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,

Line 920: p_plip_id in number default hr_api.g_number,

916: p_pgm_id in number default hr_api.g_number,
917: p_pl_id in number default hr_api.g_number,
918: p_oipl_id in number default hr_api.g_number,
919: p_ptip_id in number default hr_api.g_number,
920: p_plip_id in number default hr_api.g_number,
921: p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2,
922: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
923: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
924: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,

Line 921: p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2,

917: p_pl_id in number default hr_api.g_number,
918: p_oipl_id in number default hr_api.g_number,
919: p_ptip_id in number default hr_api.g_number,
920: p_plip_id in number default hr_api.g_number,
921: p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2,
922: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
923: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
924: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
925: p_prtn_eff_end_dt_rl in number default hr_api.g_number,

Line 922: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,

918: p_oipl_id in number default hr_api.g_number,
919: p_ptip_id in number default hr_api.g_number,
920: p_plip_id in number default hr_api.g_number,
921: p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2,
922: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
923: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
924: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
925: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
926: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,

Line 923: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,

919: p_ptip_id in number default hr_api.g_number,
920: p_plip_id in number default hr_api.g_number,
921: p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2,
922: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
923: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
924: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
925: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
926: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
927: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,

Line 924: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,

920: p_plip_id in number default hr_api.g_number,
921: p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2,
922: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
923: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
924: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
925: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
926: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
927: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
928: p_wait_perd_val in number default hr_api.g_number,

Line 925: p_prtn_eff_end_dt_rl in number default hr_api.g_number,

921: p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2,
922: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
923: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
924: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
925: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
926: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
927: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
928: p_wait_perd_val in number default hr_api.g_number,
929: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,

Line 926: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,

922: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
923: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
924: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
925: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
926: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
927: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
928: p_wait_perd_val in number default hr_api.g_number,
929: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
930: p_wait_perd_rl in number default hr_api.g_number,

Line 927: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,

923: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
924: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
925: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
926: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
927: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
928: p_wait_perd_val in number default hr_api.g_number,
929: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
930: p_wait_perd_rl in number default hr_api.g_number,
931: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,

Line 928: p_wait_perd_val in number default hr_api.g_number,

924: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
925: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
926: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
927: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
928: p_wait_perd_val in number default hr_api.g_number,
929: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
930: p_wait_perd_rl in number default hr_api.g_number,
931: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
932: p_mx_poe_det_dt_rl in number default hr_api.g_number,

Line 929: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,

925: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
926: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
927: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
928: p_wait_perd_val in number default hr_api.g_number,
929: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
930: p_wait_perd_rl in number default hr_api.g_number,
931: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
932: p_mx_poe_det_dt_rl in number default hr_api.g_number,
933: p_mx_poe_val in number default hr_api.g_number,

Line 930: p_wait_perd_rl in number default hr_api.g_number,

926: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
927: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
928: p_wait_perd_val in number default hr_api.g_number,
929: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
930: p_wait_perd_rl in number default hr_api.g_number,
931: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
932: p_mx_poe_det_dt_rl in number default hr_api.g_number,
933: p_mx_poe_val in number default hr_api.g_number,
934: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,

Line 931: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,

927: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
928: p_wait_perd_val in number default hr_api.g_number,
929: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
930: p_wait_perd_rl in number default hr_api.g_number,
931: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
932: p_mx_poe_det_dt_rl in number default hr_api.g_number,
933: p_mx_poe_val in number default hr_api.g_number,
934: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
935: p_mx_poe_rl in number default hr_api.g_number,

Line 932: p_mx_poe_det_dt_rl in number default hr_api.g_number,

928: p_wait_perd_val in number default hr_api.g_number,
929: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
930: p_wait_perd_rl in number default hr_api.g_number,
931: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
932: p_mx_poe_det_dt_rl in number default hr_api.g_number,
933: p_mx_poe_val in number default hr_api.g_number,
934: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
935: p_mx_poe_rl in number default hr_api.g_number,
936: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,

Line 933: p_mx_poe_val in number default hr_api.g_number,

929: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
930: p_wait_perd_rl in number default hr_api.g_number,
931: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
932: p_mx_poe_det_dt_rl in number default hr_api.g_number,
933: p_mx_poe_val in number default hr_api.g_number,
934: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
935: p_mx_poe_rl in number default hr_api.g_number,
936: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
937: p_epa_attribute_category in varchar2 default hr_api.g_varchar2,

Line 934: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,

930: p_wait_perd_rl in number default hr_api.g_number,
931: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
932: p_mx_poe_det_dt_rl in number default hr_api.g_number,
933: p_mx_poe_val in number default hr_api.g_number,
934: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
935: p_mx_poe_rl in number default hr_api.g_number,
936: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
937: p_epa_attribute_category in varchar2 default hr_api.g_varchar2,
938: p_epa_attribute1 in varchar2 default hr_api.g_varchar2,

Line 935: p_mx_poe_rl in number default hr_api.g_number,

931: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
932: p_mx_poe_det_dt_rl in number default hr_api.g_number,
933: p_mx_poe_val in number default hr_api.g_number,
934: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
935: p_mx_poe_rl in number default hr_api.g_number,
936: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
937: p_epa_attribute_category in varchar2 default hr_api.g_varchar2,
938: p_epa_attribute1 in varchar2 default hr_api.g_varchar2,
939: p_epa_attribute2 in varchar2 default hr_api.g_varchar2,

Line 936: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,

932: p_mx_poe_det_dt_rl in number default hr_api.g_number,
933: p_mx_poe_val in number default hr_api.g_number,
934: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
935: p_mx_poe_rl in number default hr_api.g_number,
936: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
937: p_epa_attribute_category in varchar2 default hr_api.g_varchar2,
938: p_epa_attribute1 in varchar2 default hr_api.g_varchar2,
939: p_epa_attribute2 in varchar2 default hr_api.g_varchar2,
940: p_epa_attribute3 in varchar2 default hr_api.g_varchar2,

Line 937: p_epa_attribute_category in varchar2 default hr_api.g_varchar2,

933: p_mx_poe_val in number default hr_api.g_number,
934: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
935: p_mx_poe_rl in number default hr_api.g_number,
936: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
937: p_epa_attribute_category in varchar2 default hr_api.g_varchar2,
938: p_epa_attribute1 in varchar2 default hr_api.g_varchar2,
939: p_epa_attribute2 in varchar2 default hr_api.g_varchar2,
940: p_epa_attribute3 in varchar2 default hr_api.g_varchar2,
941: p_epa_attribute4 in varchar2 default hr_api.g_varchar2,

Line 938: p_epa_attribute1 in varchar2 default hr_api.g_varchar2,

934: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
935: p_mx_poe_rl in number default hr_api.g_number,
936: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
937: p_epa_attribute_category in varchar2 default hr_api.g_varchar2,
938: p_epa_attribute1 in varchar2 default hr_api.g_varchar2,
939: p_epa_attribute2 in varchar2 default hr_api.g_varchar2,
940: p_epa_attribute3 in varchar2 default hr_api.g_varchar2,
941: p_epa_attribute4 in varchar2 default hr_api.g_varchar2,
942: p_epa_attribute5 in varchar2 default hr_api.g_varchar2,

Line 939: p_epa_attribute2 in varchar2 default hr_api.g_varchar2,

935: p_mx_poe_rl in number default hr_api.g_number,
936: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
937: p_epa_attribute_category in varchar2 default hr_api.g_varchar2,
938: p_epa_attribute1 in varchar2 default hr_api.g_varchar2,
939: p_epa_attribute2 in varchar2 default hr_api.g_varchar2,
940: p_epa_attribute3 in varchar2 default hr_api.g_varchar2,
941: p_epa_attribute4 in varchar2 default hr_api.g_varchar2,
942: p_epa_attribute5 in varchar2 default hr_api.g_varchar2,
943: p_epa_attribute6 in varchar2 default hr_api.g_varchar2,

Line 940: p_epa_attribute3 in varchar2 default hr_api.g_varchar2,

936: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
937: p_epa_attribute_category in varchar2 default hr_api.g_varchar2,
938: p_epa_attribute1 in varchar2 default hr_api.g_varchar2,
939: p_epa_attribute2 in varchar2 default hr_api.g_varchar2,
940: p_epa_attribute3 in varchar2 default hr_api.g_varchar2,
941: p_epa_attribute4 in varchar2 default hr_api.g_varchar2,
942: p_epa_attribute5 in varchar2 default hr_api.g_varchar2,
943: p_epa_attribute6 in varchar2 default hr_api.g_varchar2,
944: p_epa_attribute7 in varchar2 default hr_api.g_varchar2,

Line 941: p_epa_attribute4 in varchar2 default hr_api.g_varchar2,

937: p_epa_attribute_category in varchar2 default hr_api.g_varchar2,
938: p_epa_attribute1 in varchar2 default hr_api.g_varchar2,
939: p_epa_attribute2 in varchar2 default hr_api.g_varchar2,
940: p_epa_attribute3 in varchar2 default hr_api.g_varchar2,
941: p_epa_attribute4 in varchar2 default hr_api.g_varchar2,
942: p_epa_attribute5 in varchar2 default hr_api.g_varchar2,
943: p_epa_attribute6 in varchar2 default hr_api.g_varchar2,
944: p_epa_attribute7 in varchar2 default hr_api.g_varchar2,
945: p_epa_attribute8 in varchar2 default hr_api.g_varchar2,

Line 942: p_epa_attribute5 in varchar2 default hr_api.g_varchar2,

938: p_epa_attribute1 in varchar2 default hr_api.g_varchar2,
939: p_epa_attribute2 in varchar2 default hr_api.g_varchar2,
940: p_epa_attribute3 in varchar2 default hr_api.g_varchar2,
941: p_epa_attribute4 in varchar2 default hr_api.g_varchar2,
942: p_epa_attribute5 in varchar2 default hr_api.g_varchar2,
943: p_epa_attribute6 in varchar2 default hr_api.g_varchar2,
944: p_epa_attribute7 in varchar2 default hr_api.g_varchar2,
945: p_epa_attribute8 in varchar2 default hr_api.g_varchar2,
946: p_epa_attribute9 in varchar2 default hr_api.g_varchar2,

Line 943: p_epa_attribute6 in varchar2 default hr_api.g_varchar2,

939: p_epa_attribute2 in varchar2 default hr_api.g_varchar2,
940: p_epa_attribute3 in varchar2 default hr_api.g_varchar2,
941: p_epa_attribute4 in varchar2 default hr_api.g_varchar2,
942: p_epa_attribute5 in varchar2 default hr_api.g_varchar2,
943: p_epa_attribute6 in varchar2 default hr_api.g_varchar2,
944: p_epa_attribute7 in varchar2 default hr_api.g_varchar2,
945: p_epa_attribute8 in varchar2 default hr_api.g_varchar2,
946: p_epa_attribute9 in varchar2 default hr_api.g_varchar2,
947: p_epa_attribute10 in varchar2 default hr_api.g_varchar2,

Line 944: p_epa_attribute7 in varchar2 default hr_api.g_varchar2,

940: p_epa_attribute3 in varchar2 default hr_api.g_varchar2,
941: p_epa_attribute4 in varchar2 default hr_api.g_varchar2,
942: p_epa_attribute5 in varchar2 default hr_api.g_varchar2,
943: p_epa_attribute6 in varchar2 default hr_api.g_varchar2,
944: p_epa_attribute7 in varchar2 default hr_api.g_varchar2,
945: p_epa_attribute8 in varchar2 default hr_api.g_varchar2,
946: p_epa_attribute9 in varchar2 default hr_api.g_varchar2,
947: p_epa_attribute10 in varchar2 default hr_api.g_varchar2,
948: p_epa_attribute11 in varchar2 default hr_api.g_varchar2,

Line 945: p_epa_attribute8 in varchar2 default hr_api.g_varchar2,

941: p_epa_attribute4 in varchar2 default hr_api.g_varchar2,
942: p_epa_attribute5 in varchar2 default hr_api.g_varchar2,
943: p_epa_attribute6 in varchar2 default hr_api.g_varchar2,
944: p_epa_attribute7 in varchar2 default hr_api.g_varchar2,
945: p_epa_attribute8 in varchar2 default hr_api.g_varchar2,
946: p_epa_attribute9 in varchar2 default hr_api.g_varchar2,
947: p_epa_attribute10 in varchar2 default hr_api.g_varchar2,
948: p_epa_attribute11 in varchar2 default hr_api.g_varchar2,
949: p_epa_attribute12 in varchar2 default hr_api.g_varchar2,

Line 946: p_epa_attribute9 in varchar2 default hr_api.g_varchar2,

942: p_epa_attribute5 in varchar2 default hr_api.g_varchar2,
943: p_epa_attribute6 in varchar2 default hr_api.g_varchar2,
944: p_epa_attribute7 in varchar2 default hr_api.g_varchar2,
945: p_epa_attribute8 in varchar2 default hr_api.g_varchar2,
946: p_epa_attribute9 in varchar2 default hr_api.g_varchar2,
947: p_epa_attribute10 in varchar2 default hr_api.g_varchar2,
948: p_epa_attribute11 in varchar2 default hr_api.g_varchar2,
949: p_epa_attribute12 in varchar2 default hr_api.g_varchar2,
950: p_epa_attribute13 in varchar2 default hr_api.g_varchar2,

Line 947: p_epa_attribute10 in varchar2 default hr_api.g_varchar2,

943: p_epa_attribute6 in varchar2 default hr_api.g_varchar2,
944: p_epa_attribute7 in varchar2 default hr_api.g_varchar2,
945: p_epa_attribute8 in varchar2 default hr_api.g_varchar2,
946: p_epa_attribute9 in varchar2 default hr_api.g_varchar2,
947: p_epa_attribute10 in varchar2 default hr_api.g_varchar2,
948: p_epa_attribute11 in varchar2 default hr_api.g_varchar2,
949: p_epa_attribute12 in varchar2 default hr_api.g_varchar2,
950: p_epa_attribute13 in varchar2 default hr_api.g_varchar2,
951: p_epa_attribute14 in varchar2 default hr_api.g_varchar2,

Line 948: p_epa_attribute11 in varchar2 default hr_api.g_varchar2,

944: p_epa_attribute7 in varchar2 default hr_api.g_varchar2,
945: p_epa_attribute8 in varchar2 default hr_api.g_varchar2,
946: p_epa_attribute9 in varchar2 default hr_api.g_varchar2,
947: p_epa_attribute10 in varchar2 default hr_api.g_varchar2,
948: p_epa_attribute11 in varchar2 default hr_api.g_varchar2,
949: p_epa_attribute12 in varchar2 default hr_api.g_varchar2,
950: p_epa_attribute13 in varchar2 default hr_api.g_varchar2,
951: p_epa_attribute14 in varchar2 default hr_api.g_varchar2,
952: p_epa_attribute15 in varchar2 default hr_api.g_varchar2,

Line 949: p_epa_attribute12 in varchar2 default hr_api.g_varchar2,

945: p_epa_attribute8 in varchar2 default hr_api.g_varchar2,
946: p_epa_attribute9 in varchar2 default hr_api.g_varchar2,
947: p_epa_attribute10 in varchar2 default hr_api.g_varchar2,
948: p_epa_attribute11 in varchar2 default hr_api.g_varchar2,
949: p_epa_attribute12 in varchar2 default hr_api.g_varchar2,
950: p_epa_attribute13 in varchar2 default hr_api.g_varchar2,
951: p_epa_attribute14 in varchar2 default hr_api.g_varchar2,
952: p_epa_attribute15 in varchar2 default hr_api.g_varchar2,
953: p_epa_attribute16 in varchar2 default hr_api.g_varchar2,

Line 950: p_epa_attribute13 in varchar2 default hr_api.g_varchar2,

946: p_epa_attribute9 in varchar2 default hr_api.g_varchar2,
947: p_epa_attribute10 in varchar2 default hr_api.g_varchar2,
948: p_epa_attribute11 in varchar2 default hr_api.g_varchar2,
949: p_epa_attribute12 in varchar2 default hr_api.g_varchar2,
950: p_epa_attribute13 in varchar2 default hr_api.g_varchar2,
951: p_epa_attribute14 in varchar2 default hr_api.g_varchar2,
952: p_epa_attribute15 in varchar2 default hr_api.g_varchar2,
953: p_epa_attribute16 in varchar2 default hr_api.g_varchar2,
954: p_epa_attribute17 in varchar2 default hr_api.g_varchar2,

Line 951: p_epa_attribute14 in varchar2 default hr_api.g_varchar2,

947: p_epa_attribute10 in varchar2 default hr_api.g_varchar2,
948: p_epa_attribute11 in varchar2 default hr_api.g_varchar2,
949: p_epa_attribute12 in varchar2 default hr_api.g_varchar2,
950: p_epa_attribute13 in varchar2 default hr_api.g_varchar2,
951: p_epa_attribute14 in varchar2 default hr_api.g_varchar2,
952: p_epa_attribute15 in varchar2 default hr_api.g_varchar2,
953: p_epa_attribute16 in varchar2 default hr_api.g_varchar2,
954: p_epa_attribute17 in varchar2 default hr_api.g_varchar2,
955: p_epa_attribute18 in varchar2 default hr_api.g_varchar2,

Line 952: p_epa_attribute15 in varchar2 default hr_api.g_varchar2,

948: p_epa_attribute11 in varchar2 default hr_api.g_varchar2,
949: p_epa_attribute12 in varchar2 default hr_api.g_varchar2,
950: p_epa_attribute13 in varchar2 default hr_api.g_varchar2,
951: p_epa_attribute14 in varchar2 default hr_api.g_varchar2,
952: p_epa_attribute15 in varchar2 default hr_api.g_varchar2,
953: p_epa_attribute16 in varchar2 default hr_api.g_varchar2,
954: p_epa_attribute17 in varchar2 default hr_api.g_varchar2,
955: p_epa_attribute18 in varchar2 default hr_api.g_varchar2,
956: p_epa_attribute19 in varchar2 default hr_api.g_varchar2,

Line 953: p_epa_attribute16 in varchar2 default hr_api.g_varchar2,

949: p_epa_attribute12 in varchar2 default hr_api.g_varchar2,
950: p_epa_attribute13 in varchar2 default hr_api.g_varchar2,
951: p_epa_attribute14 in varchar2 default hr_api.g_varchar2,
952: p_epa_attribute15 in varchar2 default hr_api.g_varchar2,
953: p_epa_attribute16 in varchar2 default hr_api.g_varchar2,
954: p_epa_attribute17 in varchar2 default hr_api.g_varchar2,
955: p_epa_attribute18 in varchar2 default hr_api.g_varchar2,
956: p_epa_attribute19 in varchar2 default hr_api.g_varchar2,
957: p_epa_attribute20 in varchar2 default hr_api.g_varchar2,

Line 954: p_epa_attribute17 in varchar2 default hr_api.g_varchar2,

950: p_epa_attribute13 in varchar2 default hr_api.g_varchar2,
951: p_epa_attribute14 in varchar2 default hr_api.g_varchar2,
952: p_epa_attribute15 in varchar2 default hr_api.g_varchar2,
953: p_epa_attribute16 in varchar2 default hr_api.g_varchar2,
954: p_epa_attribute17 in varchar2 default hr_api.g_varchar2,
955: p_epa_attribute18 in varchar2 default hr_api.g_varchar2,
956: p_epa_attribute19 in varchar2 default hr_api.g_varchar2,
957: p_epa_attribute20 in varchar2 default hr_api.g_varchar2,
958: p_epa_attribute21 in varchar2 default hr_api.g_varchar2,

Line 955: p_epa_attribute18 in varchar2 default hr_api.g_varchar2,

951: p_epa_attribute14 in varchar2 default hr_api.g_varchar2,
952: p_epa_attribute15 in varchar2 default hr_api.g_varchar2,
953: p_epa_attribute16 in varchar2 default hr_api.g_varchar2,
954: p_epa_attribute17 in varchar2 default hr_api.g_varchar2,
955: p_epa_attribute18 in varchar2 default hr_api.g_varchar2,
956: p_epa_attribute19 in varchar2 default hr_api.g_varchar2,
957: p_epa_attribute20 in varchar2 default hr_api.g_varchar2,
958: p_epa_attribute21 in varchar2 default hr_api.g_varchar2,
959: p_epa_attribute22 in varchar2 default hr_api.g_varchar2,

Line 956: p_epa_attribute19 in varchar2 default hr_api.g_varchar2,

952: p_epa_attribute15 in varchar2 default hr_api.g_varchar2,
953: p_epa_attribute16 in varchar2 default hr_api.g_varchar2,
954: p_epa_attribute17 in varchar2 default hr_api.g_varchar2,
955: p_epa_attribute18 in varchar2 default hr_api.g_varchar2,
956: p_epa_attribute19 in varchar2 default hr_api.g_varchar2,
957: p_epa_attribute20 in varchar2 default hr_api.g_varchar2,
958: p_epa_attribute21 in varchar2 default hr_api.g_varchar2,
959: p_epa_attribute22 in varchar2 default hr_api.g_varchar2,
960: p_epa_attribute23 in varchar2 default hr_api.g_varchar2,

Line 957: p_epa_attribute20 in varchar2 default hr_api.g_varchar2,

953: p_epa_attribute16 in varchar2 default hr_api.g_varchar2,
954: p_epa_attribute17 in varchar2 default hr_api.g_varchar2,
955: p_epa_attribute18 in varchar2 default hr_api.g_varchar2,
956: p_epa_attribute19 in varchar2 default hr_api.g_varchar2,
957: p_epa_attribute20 in varchar2 default hr_api.g_varchar2,
958: p_epa_attribute21 in varchar2 default hr_api.g_varchar2,
959: p_epa_attribute22 in varchar2 default hr_api.g_varchar2,
960: p_epa_attribute23 in varchar2 default hr_api.g_varchar2,
961: p_epa_attribute24 in varchar2 default hr_api.g_varchar2,

Line 958: p_epa_attribute21 in varchar2 default hr_api.g_varchar2,

954: p_epa_attribute17 in varchar2 default hr_api.g_varchar2,
955: p_epa_attribute18 in varchar2 default hr_api.g_varchar2,
956: p_epa_attribute19 in varchar2 default hr_api.g_varchar2,
957: p_epa_attribute20 in varchar2 default hr_api.g_varchar2,
958: p_epa_attribute21 in varchar2 default hr_api.g_varchar2,
959: p_epa_attribute22 in varchar2 default hr_api.g_varchar2,
960: p_epa_attribute23 in varchar2 default hr_api.g_varchar2,
961: p_epa_attribute24 in varchar2 default hr_api.g_varchar2,
962: p_epa_attribute25 in varchar2 default hr_api.g_varchar2,

Line 959: p_epa_attribute22 in varchar2 default hr_api.g_varchar2,

955: p_epa_attribute18 in varchar2 default hr_api.g_varchar2,
956: p_epa_attribute19 in varchar2 default hr_api.g_varchar2,
957: p_epa_attribute20 in varchar2 default hr_api.g_varchar2,
958: p_epa_attribute21 in varchar2 default hr_api.g_varchar2,
959: p_epa_attribute22 in varchar2 default hr_api.g_varchar2,
960: p_epa_attribute23 in varchar2 default hr_api.g_varchar2,
961: p_epa_attribute24 in varchar2 default hr_api.g_varchar2,
962: p_epa_attribute25 in varchar2 default hr_api.g_varchar2,
963: p_epa_attribute26 in varchar2 default hr_api.g_varchar2,

Line 960: p_epa_attribute23 in varchar2 default hr_api.g_varchar2,

956: p_epa_attribute19 in varchar2 default hr_api.g_varchar2,
957: p_epa_attribute20 in varchar2 default hr_api.g_varchar2,
958: p_epa_attribute21 in varchar2 default hr_api.g_varchar2,
959: p_epa_attribute22 in varchar2 default hr_api.g_varchar2,
960: p_epa_attribute23 in varchar2 default hr_api.g_varchar2,
961: p_epa_attribute24 in varchar2 default hr_api.g_varchar2,
962: p_epa_attribute25 in varchar2 default hr_api.g_varchar2,
963: p_epa_attribute26 in varchar2 default hr_api.g_varchar2,
964: p_epa_attribute27 in varchar2 default hr_api.g_varchar2,

Line 961: p_epa_attribute24 in varchar2 default hr_api.g_varchar2,

957: p_epa_attribute20 in varchar2 default hr_api.g_varchar2,
958: p_epa_attribute21 in varchar2 default hr_api.g_varchar2,
959: p_epa_attribute22 in varchar2 default hr_api.g_varchar2,
960: p_epa_attribute23 in varchar2 default hr_api.g_varchar2,
961: p_epa_attribute24 in varchar2 default hr_api.g_varchar2,
962: p_epa_attribute25 in varchar2 default hr_api.g_varchar2,
963: p_epa_attribute26 in varchar2 default hr_api.g_varchar2,
964: p_epa_attribute27 in varchar2 default hr_api.g_varchar2,
965: p_epa_attribute28 in varchar2 default hr_api.g_varchar2,

Line 962: p_epa_attribute25 in varchar2 default hr_api.g_varchar2,

958: p_epa_attribute21 in varchar2 default hr_api.g_varchar2,
959: p_epa_attribute22 in varchar2 default hr_api.g_varchar2,
960: p_epa_attribute23 in varchar2 default hr_api.g_varchar2,
961: p_epa_attribute24 in varchar2 default hr_api.g_varchar2,
962: p_epa_attribute25 in varchar2 default hr_api.g_varchar2,
963: p_epa_attribute26 in varchar2 default hr_api.g_varchar2,
964: p_epa_attribute27 in varchar2 default hr_api.g_varchar2,
965: p_epa_attribute28 in varchar2 default hr_api.g_varchar2,
966: p_epa_attribute29 in varchar2 default hr_api.g_varchar2,

Line 963: p_epa_attribute26 in varchar2 default hr_api.g_varchar2,

959: p_epa_attribute22 in varchar2 default hr_api.g_varchar2,
960: p_epa_attribute23 in varchar2 default hr_api.g_varchar2,
961: p_epa_attribute24 in varchar2 default hr_api.g_varchar2,
962: p_epa_attribute25 in varchar2 default hr_api.g_varchar2,
963: p_epa_attribute26 in varchar2 default hr_api.g_varchar2,
964: p_epa_attribute27 in varchar2 default hr_api.g_varchar2,
965: p_epa_attribute28 in varchar2 default hr_api.g_varchar2,
966: p_epa_attribute29 in varchar2 default hr_api.g_varchar2,
967: p_epa_attribute30 in varchar2 default hr_api.g_varchar2,

Line 964: p_epa_attribute27 in varchar2 default hr_api.g_varchar2,

960: p_epa_attribute23 in varchar2 default hr_api.g_varchar2,
961: p_epa_attribute24 in varchar2 default hr_api.g_varchar2,
962: p_epa_attribute25 in varchar2 default hr_api.g_varchar2,
963: p_epa_attribute26 in varchar2 default hr_api.g_varchar2,
964: p_epa_attribute27 in varchar2 default hr_api.g_varchar2,
965: p_epa_attribute28 in varchar2 default hr_api.g_varchar2,
966: p_epa_attribute29 in varchar2 default hr_api.g_varchar2,
967: p_epa_attribute30 in varchar2 default hr_api.g_varchar2,
968: p_object_version_number in out nocopy number,

Line 965: p_epa_attribute28 in varchar2 default hr_api.g_varchar2,

961: p_epa_attribute24 in varchar2 default hr_api.g_varchar2,
962: p_epa_attribute25 in varchar2 default hr_api.g_varchar2,
963: p_epa_attribute26 in varchar2 default hr_api.g_varchar2,
964: p_epa_attribute27 in varchar2 default hr_api.g_varchar2,
965: p_epa_attribute28 in varchar2 default hr_api.g_varchar2,
966: p_epa_attribute29 in varchar2 default hr_api.g_varchar2,
967: p_epa_attribute30 in varchar2 default hr_api.g_varchar2,
968: p_object_version_number in out nocopy number,
969: p_effective_date in date,

Line 966: p_epa_attribute29 in varchar2 default hr_api.g_varchar2,

962: p_epa_attribute25 in varchar2 default hr_api.g_varchar2,
963: p_epa_attribute26 in varchar2 default hr_api.g_varchar2,
964: p_epa_attribute27 in varchar2 default hr_api.g_varchar2,
965: p_epa_attribute28 in varchar2 default hr_api.g_varchar2,
966: p_epa_attribute29 in varchar2 default hr_api.g_varchar2,
967: p_epa_attribute30 in varchar2 default hr_api.g_varchar2,
968: p_object_version_number in out nocopy number,
969: p_effective_date in date,
970: p_datetrack_mode in varchar2

Line 967: p_epa_attribute30 in varchar2 default hr_api.g_varchar2,

963: p_epa_attribute26 in varchar2 default hr_api.g_varchar2,
964: p_epa_attribute27 in varchar2 default hr_api.g_varchar2,
965: p_epa_attribute28 in varchar2 default hr_api.g_varchar2,
966: p_epa_attribute29 in varchar2 default hr_api.g_varchar2,
967: p_epa_attribute30 in varchar2 default hr_api.g_varchar2,
968: p_object_version_number in out nocopy number,
969: p_effective_date in date,
970: p_datetrack_mode in varchar2
971: ) is