157: End If;
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 15);
160: Exception
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: ben_peo_shd.g_api_dml := false; -- Unset the api dml status
164: ben_peo_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: ben_peo_shd.g_api_dml := false; -- Unset the api dml status
164: ben_peo_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_peo_shd.g_api_dml := false; -- Unset the api dml status
169: ben_peo_shd.constraint_error
162: -- A check constraint has been violated
163: ben_peo_shd.g_api_dml := false; -- Unset the api dml status
164: ben_peo_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_peo_shd.g_api_dml := false; -- Unset the api dml status
169: ben_peo_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_peo_shd.g_api_dml := false; -- Unset the api dml status
169: ben_peo_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: ben_peo_shd.g_api_dml := false; -- Unset the api dml status
173: Raise;
174: End dt_update_dml;
557: );
558: --
559: exception
560: --
561: when hr_api.cannot_find_prog_unit then
562: --
563: hr_api.cannot_find_prog_unit_error
564: (p_module_name => 'ben_elig_to_prte_rsn_f'
565: ,p_hook_type => 'AU');
559: exception
560: --
561: when hr_api.cannot_find_prog_unit then
562: --
563: hr_api.cannot_find_prog_unit_error
564: (p_module_name => 'ben_elig_to_prte_rsn_f'
565: ,p_hook_type => 'AU');
566: --
567: end;
626: -- p_rec plsql record structure
627: -- to see if a system default is being used. If a system default
628: -- is being used then we must set to the 'current' argument value.
629: --
630: If (p_rec.business_group_id = hr_api.g_number) then
631: p_rec.business_group_id :=
632: ben_peo_shd.g_old_rec.business_group_id;
633: End If;
634: If (p_rec.ler_id = hr_api.g_number) then
630: If (p_rec.business_group_id = hr_api.g_number) then
631: p_rec.business_group_id :=
632: ben_peo_shd.g_old_rec.business_group_id;
633: End If;
634: If (p_rec.ler_id = hr_api.g_number) then
635: p_rec.ler_id :=
636: ben_peo_shd.g_old_rec.ler_id;
637: End If;
638: If (p_rec.oipl_id = hr_api.g_number) then
634: If (p_rec.ler_id = hr_api.g_number) then
635: p_rec.ler_id :=
636: ben_peo_shd.g_old_rec.ler_id;
637: End If;
638: If (p_rec.oipl_id = hr_api.g_number) then
639: p_rec.oipl_id :=
640: ben_peo_shd.g_old_rec.oipl_id;
641: End If;
642: If (p_rec.pgm_id = hr_api.g_number) then
638: If (p_rec.oipl_id = hr_api.g_number) then
639: p_rec.oipl_id :=
640: ben_peo_shd.g_old_rec.oipl_id;
641: End If;
642: If (p_rec.pgm_id = hr_api.g_number) then
643: p_rec.pgm_id :=
644: ben_peo_shd.g_old_rec.pgm_id;
645: End If;
646: If (p_rec.pl_id = hr_api.g_number) then
642: If (p_rec.pgm_id = hr_api.g_number) then
643: p_rec.pgm_id :=
644: ben_peo_shd.g_old_rec.pgm_id;
645: End If;
646: If (p_rec.pl_id = hr_api.g_number) then
647: p_rec.pl_id :=
648: ben_peo_shd.g_old_rec.pl_id;
649: End If;
650: If (p_rec.ptip_id = hr_api.g_number) then
646: If (p_rec.pl_id = hr_api.g_number) then
647: p_rec.pl_id :=
648: ben_peo_shd.g_old_rec.pl_id;
649: End If;
650: If (p_rec.ptip_id = hr_api.g_number) then
651: p_rec.ptip_id :=
652: ben_peo_shd.g_old_rec.ptip_id;
653: End If;
654: If (p_rec.plip_id = hr_api.g_number) then
650: If (p_rec.ptip_id = hr_api.g_number) then
651: p_rec.ptip_id :=
652: ben_peo_shd.g_old_rec.ptip_id;
653: End If;
654: If (p_rec.plip_id = hr_api.g_number) then
655: p_rec.plip_id :=
656: ben_peo_shd.g_old_rec.plip_id;
657: End If;
658: If (p_rec.ignr_prtn_ovrid_flag = hr_api.g_varchar2) then
654: If (p_rec.plip_id = hr_api.g_number) then
655: p_rec.plip_id :=
656: ben_peo_shd.g_old_rec.plip_id;
657: End If;
658: If (p_rec.ignr_prtn_ovrid_flag = hr_api.g_varchar2) then
659: p_rec.ignr_prtn_ovrid_flag :=
660: ben_peo_shd.g_old_rec.ignr_prtn_ovrid_flag;
661: End If;
662: If (p_rec.elig_inelig_cd = hr_api.g_varchar2) then
658: If (p_rec.ignr_prtn_ovrid_flag = hr_api.g_varchar2) then
659: p_rec.ignr_prtn_ovrid_flag :=
660: ben_peo_shd.g_old_rec.ignr_prtn_ovrid_flag;
661: End If;
662: If (p_rec.elig_inelig_cd = hr_api.g_varchar2) then
663: p_rec.elig_inelig_cd :=
664: ben_peo_shd.g_old_rec.elig_inelig_cd;
665: End If;
666: If (p_rec.prtn_eff_strt_dt_cd = hr_api.g_varchar2) then
662: If (p_rec.elig_inelig_cd = hr_api.g_varchar2) then
663: p_rec.elig_inelig_cd :=
664: ben_peo_shd.g_old_rec.elig_inelig_cd;
665: End If;
666: If (p_rec.prtn_eff_strt_dt_cd = hr_api.g_varchar2) then
667: p_rec.prtn_eff_strt_dt_cd :=
668: ben_peo_shd.g_old_rec.prtn_eff_strt_dt_cd;
669: End If;
670: If (p_rec.prtn_eff_strt_dt_rl = hr_api.g_number) then
666: If (p_rec.prtn_eff_strt_dt_cd = hr_api.g_varchar2) then
667: p_rec.prtn_eff_strt_dt_cd :=
668: ben_peo_shd.g_old_rec.prtn_eff_strt_dt_cd;
669: End If;
670: If (p_rec.prtn_eff_strt_dt_rl = hr_api.g_number) then
671: p_rec.prtn_eff_strt_dt_rl :=
672: ben_peo_shd.g_old_rec.prtn_eff_strt_dt_rl;
673: End If;
674: If (p_rec.prtn_eff_end_dt_cd = hr_api.g_varchar2) then
670: If (p_rec.prtn_eff_strt_dt_rl = hr_api.g_number) then
671: p_rec.prtn_eff_strt_dt_rl :=
672: ben_peo_shd.g_old_rec.prtn_eff_strt_dt_rl;
673: End If;
674: If (p_rec.prtn_eff_end_dt_cd = hr_api.g_varchar2) then
675: p_rec.prtn_eff_end_dt_cd :=
676: ben_peo_shd.g_old_rec.prtn_eff_end_dt_cd;
677: End If;
678: If (p_rec.prtn_eff_end_dt_rl = hr_api.g_number) then
674: If (p_rec.prtn_eff_end_dt_cd = hr_api.g_varchar2) then
675: p_rec.prtn_eff_end_dt_cd :=
676: ben_peo_shd.g_old_rec.prtn_eff_end_dt_cd;
677: End If;
678: If (p_rec.prtn_eff_end_dt_rl = hr_api.g_number) then
679: p_rec.prtn_eff_end_dt_rl :=
680: ben_peo_shd.g_old_rec.prtn_eff_end_dt_rl;
681: End If;
682: If (p_rec.wait_perd_dt_to_use_cd = hr_api.g_varchar2) then
678: If (p_rec.prtn_eff_end_dt_rl = hr_api.g_number) then
679: p_rec.prtn_eff_end_dt_rl :=
680: ben_peo_shd.g_old_rec.prtn_eff_end_dt_rl;
681: End If;
682: If (p_rec.wait_perd_dt_to_use_cd = hr_api.g_varchar2) then
683: p_rec.wait_perd_dt_to_use_cd :=
684: ben_peo_shd.g_old_rec.wait_perd_dt_to_use_cd;
685: End If;
686: If (p_rec.wait_perd_dt_to_use_rl = hr_api.g_number) then
682: If (p_rec.wait_perd_dt_to_use_cd = hr_api.g_varchar2) then
683: p_rec.wait_perd_dt_to_use_cd :=
684: ben_peo_shd.g_old_rec.wait_perd_dt_to_use_cd;
685: End If;
686: If (p_rec.wait_perd_dt_to_use_rl = hr_api.g_number) then
687: p_rec.wait_perd_dt_to_use_rl :=
688: ben_peo_shd.g_old_rec.wait_perd_dt_to_use_rl;
689: End If;
690: If (p_rec.wait_perd_val = hr_api.g_number) then
686: If (p_rec.wait_perd_dt_to_use_rl = hr_api.g_number) then
687: p_rec.wait_perd_dt_to_use_rl :=
688: ben_peo_shd.g_old_rec.wait_perd_dt_to_use_rl;
689: End If;
690: If (p_rec.wait_perd_val = hr_api.g_number) then
691: p_rec.wait_perd_val :=
692: ben_peo_shd.g_old_rec.wait_perd_val;
693: End If;
694: If (p_rec.wait_perd_uom = hr_api.g_varchar2) then
690: If (p_rec.wait_perd_val = hr_api.g_number) then
691: p_rec.wait_perd_val :=
692: ben_peo_shd.g_old_rec.wait_perd_val;
693: End If;
694: If (p_rec.wait_perd_uom = hr_api.g_varchar2) then
695: p_rec.wait_perd_uom :=
696: ben_peo_shd.g_old_rec.wait_perd_uom;
697: End If;
698: If (p_rec.wait_perd_rl = hr_api.g_number) then
694: If (p_rec.wait_perd_uom = hr_api.g_varchar2) then
695: p_rec.wait_perd_uom :=
696: ben_peo_shd.g_old_rec.wait_perd_uom;
697: End If;
698: If (p_rec.wait_perd_rl = hr_api.g_number) then
699: p_rec.wait_perd_rl :=
700: ben_peo_shd.g_old_rec.wait_perd_rl;
701: End If;
702: If (p_rec.mx_poe_det_dt_cd = hr_api.g_varchar2) then
698: If (p_rec.wait_perd_rl = hr_api.g_number) then
699: p_rec.wait_perd_rl :=
700: ben_peo_shd.g_old_rec.wait_perd_rl;
701: End If;
702: If (p_rec.mx_poe_det_dt_cd = hr_api.g_varchar2) then
703: p_rec.mx_poe_det_dt_cd :=
704: ben_peo_shd.g_old_rec.mx_poe_det_dt_cd;
705: End If;
706: If (p_rec.mx_poe_det_dt_rl = hr_api.g_number) then
702: If (p_rec.mx_poe_det_dt_cd = hr_api.g_varchar2) then
703: p_rec.mx_poe_det_dt_cd :=
704: ben_peo_shd.g_old_rec.mx_poe_det_dt_cd;
705: End If;
706: If (p_rec.mx_poe_det_dt_rl = hr_api.g_number) then
707: p_rec.mx_poe_det_dt_rl :=
708: ben_peo_shd.g_old_rec.mx_poe_det_dt_rl;
709: End If;
710: If (p_rec.mx_poe_val = hr_api.g_number) then
706: If (p_rec.mx_poe_det_dt_rl = hr_api.g_number) then
707: p_rec.mx_poe_det_dt_rl :=
708: ben_peo_shd.g_old_rec.mx_poe_det_dt_rl;
709: End If;
710: If (p_rec.mx_poe_val = hr_api.g_number) then
711: p_rec.mx_poe_val :=
712: ben_peo_shd.g_old_rec.mx_poe_val;
713: End If;
714: If (p_rec.mx_poe_uom = hr_api.g_varchar2) then
710: If (p_rec.mx_poe_val = hr_api.g_number) then
711: p_rec.mx_poe_val :=
712: ben_peo_shd.g_old_rec.mx_poe_val;
713: End If;
714: If (p_rec.mx_poe_uom = hr_api.g_varchar2) then
715: p_rec.mx_poe_uom :=
716: ben_peo_shd.g_old_rec.mx_poe_uom;
717: End If;
718: If (p_rec.mx_poe_rl = hr_api.g_number) then
714: If (p_rec.mx_poe_uom = hr_api.g_varchar2) then
715: p_rec.mx_poe_uom :=
716: ben_peo_shd.g_old_rec.mx_poe_uom;
717: End If;
718: If (p_rec.mx_poe_rl = hr_api.g_number) then
719: p_rec.mx_poe_rl :=
720: ben_peo_shd.g_old_rec.mx_poe_rl;
721: End If;
722: If (p_rec.mx_poe_apls_cd = hr_api.g_varchar2) then
718: If (p_rec.mx_poe_rl = hr_api.g_number) then
719: p_rec.mx_poe_rl :=
720: ben_peo_shd.g_old_rec.mx_poe_rl;
721: End If;
722: If (p_rec.mx_poe_apls_cd = hr_api.g_varchar2) then
723: p_rec.mx_poe_apls_cd :=
724: ben_peo_shd.g_old_rec.mx_poe_apls_cd;
725: End If;
726: If (p_rec.prtn_ovridbl_flag = hr_api.g_varchar2) then
722: If (p_rec.mx_poe_apls_cd = hr_api.g_varchar2) then
723: p_rec.mx_poe_apls_cd :=
724: ben_peo_shd.g_old_rec.mx_poe_apls_cd;
725: End If;
726: If (p_rec.prtn_ovridbl_flag = hr_api.g_varchar2) then
727: p_rec.prtn_ovridbl_flag :=
728: ben_peo_shd.g_old_rec.prtn_ovridbl_flag;
729: End If;
730: If (p_rec.vrfy_fmly_mmbr_cd = hr_api.g_varchar2) then
726: If (p_rec.prtn_ovridbl_flag = hr_api.g_varchar2) then
727: p_rec.prtn_ovridbl_flag :=
728: ben_peo_shd.g_old_rec.prtn_ovridbl_flag;
729: End If;
730: If (p_rec.vrfy_fmly_mmbr_cd = hr_api.g_varchar2) then
731: p_rec.vrfy_fmly_mmbr_cd :=
732: ben_peo_shd.g_old_rec.vrfy_fmly_mmbr_cd;
733: End If;
734: If (p_rec.vrfy_fmly_mmbr_rl = hr_api.g_number) then
730: If (p_rec.vrfy_fmly_mmbr_cd = hr_api.g_varchar2) then
731: p_rec.vrfy_fmly_mmbr_cd :=
732: ben_peo_shd.g_old_rec.vrfy_fmly_mmbr_cd;
733: End If;
734: If (p_rec.vrfy_fmly_mmbr_rl = hr_api.g_number) then
735: p_rec.vrfy_fmly_mmbr_rl :=
736: ben_peo_shd.g_old_rec.vrfy_fmly_mmbr_rl;
737: End If;
738: If (p_rec.peo_attribute_category = hr_api.g_varchar2) then
734: If (p_rec.vrfy_fmly_mmbr_rl = hr_api.g_number) then
735: p_rec.vrfy_fmly_mmbr_rl :=
736: ben_peo_shd.g_old_rec.vrfy_fmly_mmbr_rl;
737: End If;
738: If (p_rec.peo_attribute_category = hr_api.g_varchar2) then
739: p_rec.peo_attribute_category :=
740: ben_peo_shd.g_old_rec.peo_attribute_category;
741: End If;
742: If (p_rec.peo_attribute1 = hr_api.g_varchar2) then
738: If (p_rec.peo_attribute_category = hr_api.g_varchar2) then
739: p_rec.peo_attribute_category :=
740: ben_peo_shd.g_old_rec.peo_attribute_category;
741: End If;
742: If (p_rec.peo_attribute1 = hr_api.g_varchar2) then
743: p_rec.peo_attribute1 :=
744: ben_peo_shd.g_old_rec.peo_attribute1;
745: End If;
746: If (p_rec.peo_attribute2 = hr_api.g_varchar2) then
742: If (p_rec.peo_attribute1 = hr_api.g_varchar2) then
743: p_rec.peo_attribute1 :=
744: ben_peo_shd.g_old_rec.peo_attribute1;
745: End If;
746: If (p_rec.peo_attribute2 = hr_api.g_varchar2) then
747: p_rec.peo_attribute2 :=
748: ben_peo_shd.g_old_rec.peo_attribute2;
749: End If;
750: If (p_rec.peo_attribute3 = hr_api.g_varchar2) then
746: If (p_rec.peo_attribute2 = hr_api.g_varchar2) then
747: p_rec.peo_attribute2 :=
748: ben_peo_shd.g_old_rec.peo_attribute2;
749: End If;
750: If (p_rec.peo_attribute3 = hr_api.g_varchar2) then
751: p_rec.peo_attribute3 :=
752: ben_peo_shd.g_old_rec.peo_attribute3;
753: End If;
754: If (p_rec.peo_attribute4 = hr_api.g_varchar2) then
750: If (p_rec.peo_attribute3 = hr_api.g_varchar2) then
751: p_rec.peo_attribute3 :=
752: ben_peo_shd.g_old_rec.peo_attribute3;
753: End If;
754: If (p_rec.peo_attribute4 = hr_api.g_varchar2) then
755: p_rec.peo_attribute4 :=
756: ben_peo_shd.g_old_rec.peo_attribute4;
757: End If;
758: If (p_rec.peo_attribute5 = hr_api.g_varchar2) then
754: If (p_rec.peo_attribute4 = hr_api.g_varchar2) then
755: p_rec.peo_attribute4 :=
756: ben_peo_shd.g_old_rec.peo_attribute4;
757: End If;
758: If (p_rec.peo_attribute5 = hr_api.g_varchar2) then
759: p_rec.peo_attribute5 :=
760: ben_peo_shd.g_old_rec.peo_attribute5;
761: End If;
762: If (p_rec.peo_attribute6 = hr_api.g_varchar2) then
758: If (p_rec.peo_attribute5 = hr_api.g_varchar2) then
759: p_rec.peo_attribute5 :=
760: ben_peo_shd.g_old_rec.peo_attribute5;
761: End If;
762: If (p_rec.peo_attribute6 = hr_api.g_varchar2) then
763: p_rec.peo_attribute6 :=
764: ben_peo_shd.g_old_rec.peo_attribute6;
765: End If;
766: If (p_rec.peo_attribute7 = hr_api.g_varchar2) then
762: If (p_rec.peo_attribute6 = hr_api.g_varchar2) then
763: p_rec.peo_attribute6 :=
764: ben_peo_shd.g_old_rec.peo_attribute6;
765: End If;
766: If (p_rec.peo_attribute7 = hr_api.g_varchar2) then
767: p_rec.peo_attribute7 :=
768: ben_peo_shd.g_old_rec.peo_attribute7;
769: End If;
770: If (p_rec.peo_attribute8 = hr_api.g_varchar2) then
766: If (p_rec.peo_attribute7 = hr_api.g_varchar2) then
767: p_rec.peo_attribute7 :=
768: ben_peo_shd.g_old_rec.peo_attribute7;
769: End If;
770: If (p_rec.peo_attribute8 = hr_api.g_varchar2) then
771: p_rec.peo_attribute8 :=
772: ben_peo_shd.g_old_rec.peo_attribute8;
773: End If;
774: If (p_rec.peo_attribute9 = hr_api.g_varchar2) then
770: If (p_rec.peo_attribute8 = hr_api.g_varchar2) then
771: p_rec.peo_attribute8 :=
772: ben_peo_shd.g_old_rec.peo_attribute8;
773: End If;
774: If (p_rec.peo_attribute9 = hr_api.g_varchar2) then
775: p_rec.peo_attribute9 :=
776: ben_peo_shd.g_old_rec.peo_attribute9;
777: End If;
778: If (p_rec.peo_attribute10 = hr_api.g_varchar2) then
774: If (p_rec.peo_attribute9 = hr_api.g_varchar2) then
775: p_rec.peo_attribute9 :=
776: ben_peo_shd.g_old_rec.peo_attribute9;
777: End If;
778: If (p_rec.peo_attribute10 = hr_api.g_varchar2) then
779: p_rec.peo_attribute10 :=
780: ben_peo_shd.g_old_rec.peo_attribute10;
781: End If;
782: If (p_rec.peo_attribute11 = hr_api.g_varchar2) then
778: If (p_rec.peo_attribute10 = hr_api.g_varchar2) then
779: p_rec.peo_attribute10 :=
780: ben_peo_shd.g_old_rec.peo_attribute10;
781: End If;
782: If (p_rec.peo_attribute11 = hr_api.g_varchar2) then
783: p_rec.peo_attribute11 :=
784: ben_peo_shd.g_old_rec.peo_attribute11;
785: End If;
786: If (p_rec.peo_attribute12 = hr_api.g_varchar2) then
782: If (p_rec.peo_attribute11 = hr_api.g_varchar2) then
783: p_rec.peo_attribute11 :=
784: ben_peo_shd.g_old_rec.peo_attribute11;
785: End If;
786: If (p_rec.peo_attribute12 = hr_api.g_varchar2) then
787: p_rec.peo_attribute12 :=
788: ben_peo_shd.g_old_rec.peo_attribute12;
789: End If;
790: If (p_rec.peo_attribute13 = hr_api.g_varchar2) then
786: If (p_rec.peo_attribute12 = hr_api.g_varchar2) then
787: p_rec.peo_attribute12 :=
788: ben_peo_shd.g_old_rec.peo_attribute12;
789: End If;
790: If (p_rec.peo_attribute13 = hr_api.g_varchar2) then
791: p_rec.peo_attribute13 :=
792: ben_peo_shd.g_old_rec.peo_attribute13;
793: End If;
794: If (p_rec.peo_attribute14 = hr_api.g_varchar2) then
790: If (p_rec.peo_attribute13 = hr_api.g_varchar2) then
791: p_rec.peo_attribute13 :=
792: ben_peo_shd.g_old_rec.peo_attribute13;
793: End If;
794: If (p_rec.peo_attribute14 = hr_api.g_varchar2) then
795: p_rec.peo_attribute14 :=
796: ben_peo_shd.g_old_rec.peo_attribute14;
797: End If;
798: If (p_rec.peo_attribute15 = hr_api.g_varchar2) then
794: If (p_rec.peo_attribute14 = hr_api.g_varchar2) then
795: p_rec.peo_attribute14 :=
796: ben_peo_shd.g_old_rec.peo_attribute14;
797: End If;
798: If (p_rec.peo_attribute15 = hr_api.g_varchar2) then
799: p_rec.peo_attribute15 :=
800: ben_peo_shd.g_old_rec.peo_attribute15;
801: End If;
802: If (p_rec.peo_attribute16 = hr_api.g_varchar2) then
798: If (p_rec.peo_attribute15 = hr_api.g_varchar2) then
799: p_rec.peo_attribute15 :=
800: ben_peo_shd.g_old_rec.peo_attribute15;
801: End If;
802: If (p_rec.peo_attribute16 = hr_api.g_varchar2) then
803: p_rec.peo_attribute16 :=
804: ben_peo_shd.g_old_rec.peo_attribute16;
805: End If;
806: If (p_rec.peo_attribute17 = hr_api.g_varchar2) then
802: If (p_rec.peo_attribute16 = hr_api.g_varchar2) then
803: p_rec.peo_attribute16 :=
804: ben_peo_shd.g_old_rec.peo_attribute16;
805: End If;
806: If (p_rec.peo_attribute17 = hr_api.g_varchar2) then
807: p_rec.peo_attribute17 :=
808: ben_peo_shd.g_old_rec.peo_attribute17;
809: End If;
810: If (p_rec.peo_attribute18 = hr_api.g_varchar2) then
806: If (p_rec.peo_attribute17 = hr_api.g_varchar2) then
807: p_rec.peo_attribute17 :=
808: ben_peo_shd.g_old_rec.peo_attribute17;
809: End If;
810: If (p_rec.peo_attribute18 = hr_api.g_varchar2) then
811: p_rec.peo_attribute18 :=
812: ben_peo_shd.g_old_rec.peo_attribute18;
813: End If;
814: If (p_rec.peo_attribute19 = hr_api.g_varchar2) then
810: If (p_rec.peo_attribute18 = hr_api.g_varchar2) then
811: p_rec.peo_attribute18 :=
812: ben_peo_shd.g_old_rec.peo_attribute18;
813: End If;
814: If (p_rec.peo_attribute19 = hr_api.g_varchar2) then
815: p_rec.peo_attribute19 :=
816: ben_peo_shd.g_old_rec.peo_attribute19;
817: End If;
818: If (p_rec.peo_attribute20 = hr_api.g_varchar2) then
814: If (p_rec.peo_attribute19 = hr_api.g_varchar2) then
815: p_rec.peo_attribute19 :=
816: ben_peo_shd.g_old_rec.peo_attribute19;
817: End If;
818: If (p_rec.peo_attribute20 = hr_api.g_varchar2) then
819: p_rec.peo_attribute20 :=
820: ben_peo_shd.g_old_rec.peo_attribute20;
821: End If;
822: If (p_rec.peo_attribute21 = hr_api.g_varchar2) then
818: If (p_rec.peo_attribute20 = hr_api.g_varchar2) then
819: p_rec.peo_attribute20 :=
820: ben_peo_shd.g_old_rec.peo_attribute20;
821: End If;
822: If (p_rec.peo_attribute21 = hr_api.g_varchar2) then
823: p_rec.peo_attribute21 :=
824: ben_peo_shd.g_old_rec.peo_attribute21;
825: End If;
826: If (p_rec.peo_attribute22 = hr_api.g_varchar2) then
822: If (p_rec.peo_attribute21 = hr_api.g_varchar2) then
823: p_rec.peo_attribute21 :=
824: ben_peo_shd.g_old_rec.peo_attribute21;
825: End If;
826: If (p_rec.peo_attribute22 = hr_api.g_varchar2) then
827: p_rec.peo_attribute22 :=
828: ben_peo_shd.g_old_rec.peo_attribute22;
829: End If;
830: If (p_rec.peo_attribute23 = hr_api.g_varchar2) then
826: If (p_rec.peo_attribute22 = hr_api.g_varchar2) then
827: p_rec.peo_attribute22 :=
828: ben_peo_shd.g_old_rec.peo_attribute22;
829: End If;
830: If (p_rec.peo_attribute23 = hr_api.g_varchar2) then
831: p_rec.peo_attribute23 :=
832: ben_peo_shd.g_old_rec.peo_attribute23;
833: End If;
834: If (p_rec.peo_attribute24 = hr_api.g_varchar2) then
830: If (p_rec.peo_attribute23 = hr_api.g_varchar2) then
831: p_rec.peo_attribute23 :=
832: ben_peo_shd.g_old_rec.peo_attribute23;
833: End If;
834: If (p_rec.peo_attribute24 = hr_api.g_varchar2) then
835: p_rec.peo_attribute24 :=
836: ben_peo_shd.g_old_rec.peo_attribute24;
837: End If;
838: If (p_rec.peo_attribute25 = hr_api.g_varchar2) then
834: If (p_rec.peo_attribute24 = hr_api.g_varchar2) then
835: p_rec.peo_attribute24 :=
836: ben_peo_shd.g_old_rec.peo_attribute24;
837: End If;
838: If (p_rec.peo_attribute25 = hr_api.g_varchar2) then
839: p_rec.peo_attribute25 :=
840: ben_peo_shd.g_old_rec.peo_attribute25;
841: End If;
842: If (p_rec.peo_attribute26 = hr_api.g_varchar2) then
838: If (p_rec.peo_attribute25 = hr_api.g_varchar2) then
839: p_rec.peo_attribute25 :=
840: ben_peo_shd.g_old_rec.peo_attribute25;
841: End If;
842: If (p_rec.peo_attribute26 = hr_api.g_varchar2) then
843: p_rec.peo_attribute26 :=
844: ben_peo_shd.g_old_rec.peo_attribute26;
845: End If;
846: If (p_rec.peo_attribute27 = hr_api.g_varchar2) then
842: If (p_rec.peo_attribute26 = hr_api.g_varchar2) then
843: p_rec.peo_attribute26 :=
844: ben_peo_shd.g_old_rec.peo_attribute26;
845: End If;
846: If (p_rec.peo_attribute27 = hr_api.g_varchar2) then
847: p_rec.peo_attribute27 :=
848: ben_peo_shd.g_old_rec.peo_attribute27;
849: End If;
850: If (p_rec.peo_attribute28 = hr_api.g_varchar2) then
846: If (p_rec.peo_attribute27 = hr_api.g_varchar2) then
847: p_rec.peo_attribute27 :=
848: ben_peo_shd.g_old_rec.peo_attribute27;
849: End If;
850: If (p_rec.peo_attribute28 = hr_api.g_varchar2) then
851: p_rec.peo_attribute28 :=
852: ben_peo_shd.g_old_rec.peo_attribute28;
853: End If;
854: If (p_rec.peo_attribute29 = hr_api.g_varchar2) then
850: If (p_rec.peo_attribute28 = hr_api.g_varchar2) then
851: p_rec.peo_attribute28 :=
852: ben_peo_shd.g_old_rec.peo_attribute28;
853: End If;
854: If (p_rec.peo_attribute29 = hr_api.g_varchar2) then
855: p_rec.peo_attribute29 :=
856: ben_peo_shd.g_old_rec.peo_attribute29;
857: End If;
858: If (p_rec.peo_attribute30 = hr_api.g_varchar2) then
854: If (p_rec.peo_attribute29 = hr_api.g_varchar2) then
855: p_rec.peo_attribute29 :=
856: ben_peo_shd.g_old_rec.peo_attribute29;
857: End If;
858: If (p_rec.peo_attribute30 = hr_api.g_varchar2) then
859: p_rec.peo_attribute30 :=
860: ben_peo_shd.g_old_rec.peo_attribute30;
861: End If;
862:
945: (
946: p_elig_to_prte_rsn_id in number,
947: p_effective_start_date out nocopy date,
948: p_effective_end_date out nocopy date,
949: p_business_group_id in number default hr_api.g_number,
950: p_ler_id in number default hr_api.g_number,
951: p_oipl_id in number default hr_api.g_number,
952: p_pgm_id in number default hr_api.g_number,
953: p_pl_id in number default hr_api.g_number,
946: p_elig_to_prte_rsn_id in number,
947: p_effective_start_date out nocopy date,
948: p_effective_end_date out nocopy date,
949: p_business_group_id in number default hr_api.g_number,
950: p_ler_id in number default hr_api.g_number,
951: p_oipl_id in number default hr_api.g_number,
952: p_pgm_id in number default hr_api.g_number,
953: p_pl_id in number default hr_api.g_number,
954: p_ptip_id in number default hr_api.g_number,
947: p_effective_start_date out nocopy date,
948: p_effective_end_date out nocopy date,
949: p_business_group_id in number default hr_api.g_number,
950: p_ler_id in number default hr_api.g_number,
951: p_oipl_id in number default hr_api.g_number,
952: p_pgm_id in number default hr_api.g_number,
953: p_pl_id in number default hr_api.g_number,
954: p_ptip_id in number default hr_api.g_number,
955: p_plip_id in number default hr_api.g_number,
948: p_effective_end_date out nocopy date,
949: p_business_group_id in number default hr_api.g_number,
950: p_ler_id in number default hr_api.g_number,
951: p_oipl_id in number default hr_api.g_number,
952: p_pgm_id in number default hr_api.g_number,
953: p_pl_id in number default hr_api.g_number,
954: p_ptip_id in number default hr_api.g_number,
955: p_plip_id in number default hr_api.g_number,
956: p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2,
949: p_business_group_id in number default hr_api.g_number,
950: p_ler_id in number default hr_api.g_number,
951: p_oipl_id in number default hr_api.g_number,
952: p_pgm_id in number default hr_api.g_number,
953: p_pl_id in number default hr_api.g_number,
954: p_ptip_id in number default hr_api.g_number,
955: p_plip_id in number default hr_api.g_number,
956: p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2,
957: p_elig_inelig_cd in varchar2 default hr_api.g_varchar2,
950: p_ler_id in number default hr_api.g_number,
951: p_oipl_id in number default hr_api.g_number,
952: p_pgm_id in number default hr_api.g_number,
953: p_pl_id in number default hr_api.g_number,
954: p_ptip_id in number default hr_api.g_number,
955: p_plip_id in number default hr_api.g_number,
956: p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2,
957: p_elig_inelig_cd in varchar2 default hr_api.g_varchar2,
958: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
951: p_oipl_id in number default hr_api.g_number,
952: p_pgm_id in number default hr_api.g_number,
953: p_pl_id in number default hr_api.g_number,
954: p_ptip_id in number default hr_api.g_number,
955: p_plip_id in number default hr_api.g_number,
956: p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2,
957: p_elig_inelig_cd in varchar2 default hr_api.g_varchar2,
958: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
959: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
952: p_pgm_id in number default hr_api.g_number,
953: p_pl_id in number default hr_api.g_number,
954: p_ptip_id in number default hr_api.g_number,
955: p_plip_id in number default hr_api.g_number,
956: p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2,
957: p_elig_inelig_cd in varchar2 default hr_api.g_varchar2,
958: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
959: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
960: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
953: p_pl_id in number default hr_api.g_number,
954: p_ptip_id in number default hr_api.g_number,
955: p_plip_id in number default hr_api.g_number,
956: p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2,
957: p_elig_inelig_cd in varchar2 default hr_api.g_varchar2,
958: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
959: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
960: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
961: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
954: p_ptip_id in number default hr_api.g_number,
955: p_plip_id in number default hr_api.g_number,
956: p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2,
957: p_elig_inelig_cd in varchar2 default hr_api.g_varchar2,
958: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
959: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
960: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
961: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
962: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
955: p_plip_id in number default hr_api.g_number,
956: p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2,
957: p_elig_inelig_cd in varchar2 default hr_api.g_varchar2,
958: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
959: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
960: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
961: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
962: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
963: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
956: p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2,
957: p_elig_inelig_cd in varchar2 default hr_api.g_varchar2,
958: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
959: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
960: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
961: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
962: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
963: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
964: p_wait_perd_val in number default hr_api.g_number,
957: p_elig_inelig_cd in varchar2 default hr_api.g_varchar2,
958: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
959: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
960: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
961: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
962: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
963: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
964: p_wait_perd_val in number default hr_api.g_number,
965: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
958: p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2,
959: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
960: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
961: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
962: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
963: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
964: p_wait_perd_val in number default hr_api.g_number,
965: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
966: p_wait_perd_rl in number default hr_api.g_number,
959: p_prtn_eff_strt_dt_rl in number default hr_api.g_number,
960: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
961: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
962: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
963: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
964: p_wait_perd_val in number default hr_api.g_number,
965: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
966: p_wait_perd_rl in number default hr_api.g_number,
967: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
960: p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2,
961: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
962: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
963: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
964: p_wait_perd_val in number default hr_api.g_number,
965: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
966: p_wait_perd_rl in number default hr_api.g_number,
967: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
968: p_mx_poe_det_dt_rl in number default hr_api.g_number,
961: p_prtn_eff_end_dt_rl in number default hr_api.g_number,
962: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
963: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
964: p_wait_perd_val in number default hr_api.g_number,
965: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
966: p_wait_perd_rl in number default hr_api.g_number,
967: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
968: p_mx_poe_det_dt_rl in number default hr_api.g_number,
969: p_mx_poe_val in number default hr_api.g_number,
962: p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
963: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
964: p_wait_perd_val in number default hr_api.g_number,
965: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
966: p_wait_perd_rl in number default hr_api.g_number,
967: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
968: p_mx_poe_det_dt_rl in number default hr_api.g_number,
969: p_mx_poe_val in number default hr_api.g_number,
970: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
963: p_wait_perd_dt_to_use_rl in number default hr_api.g_number,
964: p_wait_perd_val in number default hr_api.g_number,
965: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
966: p_wait_perd_rl in number default hr_api.g_number,
967: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
968: p_mx_poe_det_dt_rl in number default hr_api.g_number,
969: p_mx_poe_val in number default hr_api.g_number,
970: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
971: p_mx_poe_rl in number default hr_api.g_number,
964: p_wait_perd_val in number default hr_api.g_number,
965: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
966: p_wait_perd_rl in number default hr_api.g_number,
967: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
968: p_mx_poe_det_dt_rl in number default hr_api.g_number,
969: p_mx_poe_val in number default hr_api.g_number,
970: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
971: p_mx_poe_rl in number default hr_api.g_number,
972: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
965: p_wait_perd_uom in varchar2 default hr_api.g_varchar2,
966: p_wait_perd_rl in number default hr_api.g_number,
967: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
968: p_mx_poe_det_dt_rl in number default hr_api.g_number,
969: p_mx_poe_val in number default hr_api.g_number,
970: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
971: p_mx_poe_rl in number default hr_api.g_number,
972: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
973: p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2,
966: p_wait_perd_rl in number default hr_api.g_number,
967: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
968: p_mx_poe_det_dt_rl in number default hr_api.g_number,
969: p_mx_poe_val in number default hr_api.g_number,
970: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
971: p_mx_poe_rl in number default hr_api.g_number,
972: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
973: p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2,
974: p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2,
967: p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2,
968: p_mx_poe_det_dt_rl in number default hr_api.g_number,
969: p_mx_poe_val in number default hr_api.g_number,
970: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
971: p_mx_poe_rl in number default hr_api.g_number,
972: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
973: p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2,
974: p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2,
975: p_vrfy_fmly_mmbr_rl in number default hr_api.g_number,
968: p_mx_poe_det_dt_rl in number default hr_api.g_number,
969: p_mx_poe_val in number default hr_api.g_number,
970: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
971: p_mx_poe_rl in number default hr_api.g_number,
972: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
973: p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2,
974: p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2,
975: p_vrfy_fmly_mmbr_rl in number default hr_api.g_number,
976: p_peo_attribute_category in varchar2 default hr_api.g_varchar2,
969: p_mx_poe_val in number default hr_api.g_number,
970: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
971: p_mx_poe_rl in number default hr_api.g_number,
972: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
973: p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2,
974: p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2,
975: p_vrfy_fmly_mmbr_rl in number default hr_api.g_number,
976: p_peo_attribute_category in varchar2 default hr_api.g_varchar2,
977: p_peo_attribute1 in varchar2 default hr_api.g_varchar2,
970: p_mx_poe_uom in varchar2 default hr_api.g_varchar2,
971: p_mx_poe_rl in number default hr_api.g_number,
972: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
973: p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2,
974: p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2,
975: p_vrfy_fmly_mmbr_rl in number default hr_api.g_number,
976: p_peo_attribute_category in varchar2 default hr_api.g_varchar2,
977: p_peo_attribute1 in varchar2 default hr_api.g_varchar2,
978: p_peo_attribute2 in varchar2 default hr_api.g_varchar2,
971: p_mx_poe_rl in number default hr_api.g_number,
972: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
973: p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2,
974: p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2,
975: p_vrfy_fmly_mmbr_rl in number default hr_api.g_number,
976: p_peo_attribute_category in varchar2 default hr_api.g_varchar2,
977: p_peo_attribute1 in varchar2 default hr_api.g_varchar2,
978: p_peo_attribute2 in varchar2 default hr_api.g_varchar2,
979: p_peo_attribute3 in varchar2 default hr_api.g_varchar2,
972: p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2,
973: p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2,
974: p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2,
975: p_vrfy_fmly_mmbr_rl in number default hr_api.g_number,
976: p_peo_attribute_category in varchar2 default hr_api.g_varchar2,
977: p_peo_attribute1 in varchar2 default hr_api.g_varchar2,
978: p_peo_attribute2 in varchar2 default hr_api.g_varchar2,
979: p_peo_attribute3 in varchar2 default hr_api.g_varchar2,
980: p_peo_attribute4 in varchar2 default hr_api.g_varchar2,
973: p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2,
974: p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2,
975: p_vrfy_fmly_mmbr_rl in number default hr_api.g_number,
976: p_peo_attribute_category in varchar2 default hr_api.g_varchar2,
977: p_peo_attribute1 in varchar2 default hr_api.g_varchar2,
978: p_peo_attribute2 in varchar2 default hr_api.g_varchar2,
979: p_peo_attribute3 in varchar2 default hr_api.g_varchar2,
980: p_peo_attribute4 in varchar2 default hr_api.g_varchar2,
981: p_peo_attribute5 in varchar2 default hr_api.g_varchar2,
974: p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2,
975: p_vrfy_fmly_mmbr_rl in number default hr_api.g_number,
976: p_peo_attribute_category in varchar2 default hr_api.g_varchar2,
977: p_peo_attribute1 in varchar2 default hr_api.g_varchar2,
978: p_peo_attribute2 in varchar2 default hr_api.g_varchar2,
979: p_peo_attribute3 in varchar2 default hr_api.g_varchar2,
980: p_peo_attribute4 in varchar2 default hr_api.g_varchar2,
981: p_peo_attribute5 in varchar2 default hr_api.g_varchar2,
982: p_peo_attribute6 in varchar2 default hr_api.g_varchar2,
975: p_vrfy_fmly_mmbr_rl in number default hr_api.g_number,
976: p_peo_attribute_category in varchar2 default hr_api.g_varchar2,
977: p_peo_attribute1 in varchar2 default hr_api.g_varchar2,
978: p_peo_attribute2 in varchar2 default hr_api.g_varchar2,
979: p_peo_attribute3 in varchar2 default hr_api.g_varchar2,
980: p_peo_attribute4 in varchar2 default hr_api.g_varchar2,
981: p_peo_attribute5 in varchar2 default hr_api.g_varchar2,
982: p_peo_attribute6 in varchar2 default hr_api.g_varchar2,
983: p_peo_attribute7 in varchar2 default hr_api.g_varchar2,
976: p_peo_attribute_category in varchar2 default hr_api.g_varchar2,
977: p_peo_attribute1 in varchar2 default hr_api.g_varchar2,
978: p_peo_attribute2 in varchar2 default hr_api.g_varchar2,
979: p_peo_attribute3 in varchar2 default hr_api.g_varchar2,
980: p_peo_attribute4 in varchar2 default hr_api.g_varchar2,
981: p_peo_attribute5 in varchar2 default hr_api.g_varchar2,
982: p_peo_attribute6 in varchar2 default hr_api.g_varchar2,
983: p_peo_attribute7 in varchar2 default hr_api.g_varchar2,
984: p_peo_attribute8 in varchar2 default hr_api.g_varchar2,
977: p_peo_attribute1 in varchar2 default hr_api.g_varchar2,
978: p_peo_attribute2 in varchar2 default hr_api.g_varchar2,
979: p_peo_attribute3 in varchar2 default hr_api.g_varchar2,
980: p_peo_attribute4 in varchar2 default hr_api.g_varchar2,
981: p_peo_attribute5 in varchar2 default hr_api.g_varchar2,
982: p_peo_attribute6 in varchar2 default hr_api.g_varchar2,
983: p_peo_attribute7 in varchar2 default hr_api.g_varchar2,
984: p_peo_attribute8 in varchar2 default hr_api.g_varchar2,
985: p_peo_attribute9 in varchar2 default hr_api.g_varchar2,
978: p_peo_attribute2 in varchar2 default hr_api.g_varchar2,
979: p_peo_attribute3 in varchar2 default hr_api.g_varchar2,
980: p_peo_attribute4 in varchar2 default hr_api.g_varchar2,
981: p_peo_attribute5 in varchar2 default hr_api.g_varchar2,
982: p_peo_attribute6 in varchar2 default hr_api.g_varchar2,
983: p_peo_attribute7 in varchar2 default hr_api.g_varchar2,
984: p_peo_attribute8 in varchar2 default hr_api.g_varchar2,
985: p_peo_attribute9 in varchar2 default hr_api.g_varchar2,
986: p_peo_attribute10 in varchar2 default hr_api.g_varchar2,
979: p_peo_attribute3 in varchar2 default hr_api.g_varchar2,
980: p_peo_attribute4 in varchar2 default hr_api.g_varchar2,
981: p_peo_attribute5 in varchar2 default hr_api.g_varchar2,
982: p_peo_attribute6 in varchar2 default hr_api.g_varchar2,
983: p_peo_attribute7 in varchar2 default hr_api.g_varchar2,
984: p_peo_attribute8 in varchar2 default hr_api.g_varchar2,
985: p_peo_attribute9 in varchar2 default hr_api.g_varchar2,
986: p_peo_attribute10 in varchar2 default hr_api.g_varchar2,
987: p_peo_attribute11 in varchar2 default hr_api.g_varchar2,
980: p_peo_attribute4 in varchar2 default hr_api.g_varchar2,
981: p_peo_attribute5 in varchar2 default hr_api.g_varchar2,
982: p_peo_attribute6 in varchar2 default hr_api.g_varchar2,
983: p_peo_attribute7 in varchar2 default hr_api.g_varchar2,
984: p_peo_attribute8 in varchar2 default hr_api.g_varchar2,
985: p_peo_attribute9 in varchar2 default hr_api.g_varchar2,
986: p_peo_attribute10 in varchar2 default hr_api.g_varchar2,
987: p_peo_attribute11 in varchar2 default hr_api.g_varchar2,
988: p_peo_attribute12 in varchar2 default hr_api.g_varchar2,
981: p_peo_attribute5 in varchar2 default hr_api.g_varchar2,
982: p_peo_attribute6 in varchar2 default hr_api.g_varchar2,
983: p_peo_attribute7 in varchar2 default hr_api.g_varchar2,
984: p_peo_attribute8 in varchar2 default hr_api.g_varchar2,
985: p_peo_attribute9 in varchar2 default hr_api.g_varchar2,
986: p_peo_attribute10 in varchar2 default hr_api.g_varchar2,
987: p_peo_attribute11 in varchar2 default hr_api.g_varchar2,
988: p_peo_attribute12 in varchar2 default hr_api.g_varchar2,
989: p_peo_attribute13 in varchar2 default hr_api.g_varchar2,
982: p_peo_attribute6 in varchar2 default hr_api.g_varchar2,
983: p_peo_attribute7 in varchar2 default hr_api.g_varchar2,
984: p_peo_attribute8 in varchar2 default hr_api.g_varchar2,
985: p_peo_attribute9 in varchar2 default hr_api.g_varchar2,
986: p_peo_attribute10 in varchar2 default hr_api.g_varchar2,
987: p_peo_attribute11 in varchar2 default hr_api.g_varchar2,
988: p_peo_attribute12 in varchar2 default hr_api.g_varchar2,
989: p_peo_attribute13 in varchar2 default hr_api.g_varchar2,
990: p_peo_attribute14 in varchar2 default hr_api.g_varchar2,
983: p_peo_attribute7 in varchar2 default hr_api.g_varchar2,
984: p_peo_attribute8 in varchar2 default hr_api.g_varchar2,
985: p_peo_attribute9 in varchar2 default hr_api.g_varchar2,
986: p_peo_attribute10 in varchar2 default hr_api.g_varchar2,
987: p_peo_attribute11 in varchar2 default hr_api.g_varchar2,
988: p_peo_attribute12 in varchar2 default hr_api.g_varchar2,
989: p_peo_attribute13 in varchar2 default hr_api.g_varchar2,
990: p_peo_attribute14 in varchar2 default hr_api.g_varchar2,
991: p_peo_attribute15 in varchar2 default hr_api.g_varchar2,
984: p_peo_attribute8 in varchar2 default hr_api.g_varchar2,
985: p_peo_attribute9 in varchar2 default hr_api.g_varchar2,
986: p_peo_attribute10 in varchar2 default hr_api.g_varchar2,
987: p_peo_attribute11 in varchar2 default hr_api.g_varchar2,
988: p_peo_attribute12 in varchar2 default hr_api.g_varchar2,
989: p_peo_attribute13 in varchar2 default hr_api.g_varchar2,
990: p_peo_attribute14 in varchar2 default hr_api.g_varchar2,
991: p_peo_attribute15 in varchar2 default hr_api.g_varchar2,
992: p_peo_attribute16 in varchar2 default hr_api.g_varchar2,
985: p_peo_attribute9 in varchar2 default hr_api.g_varchar2,
986: p_peo_attribute10 in varchar2 default hr_api.g_varchar2,
987: p_peo_attribute11 in varchar2 default hr_api.g_varchar2,
988: p_peo_attribute12 in varchar2 default hr_api.g_varchar2,
989: p_peo_attribute13 in varchar2 default hr_api.g_varchar2,
990: p_peo_attribute14 in varchar2 default hr_api.g_varchar2,
991: p_peo_attribute15 in varchar2 default hr_api.g_varchar2,
992: p_peo_attribute16 in varchar2 default hr_api.g_varchar2,
993: p_peo_attribute17 in varchar2 default hr_api.g_varchar2,
986: p_peo_attribute10 in varchar2 default hr_api.g_varchar2,
987: p_peo_attribute11 in varchar2 default hr_api.g_varchar2,
988: p_peo_attribute12 in varchar2 default hr_api.g_varchar2,
989: p_peo_attribute13 in varchar2 default hr_api.g_varchar2,
990: p_peo_attribute14 in varchar2 default hr_api.g_varchar2,
991: p_peo_attribute15 in varchar2 default hr_api.g_varchar2,
992: p_peo_attribute16 in varchar2 default hr_api.g_varchar2,
993: p_peo_attribute17 in varchar2 default hr_api.g_varchar2,
994: p_peo_attribute18 in varchar2 default hr_api.g_varchar2,
987: p_peo_attribute11 in varchar2 default hr_api.g_varchar2,
988: p_peo_attribute12 in varchar2 default hr_api.g_varchar2,
989: p_peo_attribute13 in varchar2 default hr_api.g_varchar2,
990: p_peo_attribute14 in varchar2 default hr_api.g_varchar2,
991: p_peo_attribute15 in varchar2 default hr_api.g_varchar2,
992: p_peo_attribute16 in varchar2 default hr_api.g_varchar2,
993: p_peo_attribute17 in varchar2 default hr_api.g_varchar2,
994: p_peo_attribute18 in varchar2 default hr_api.g_varchar2,
995: p_peo_attribute19 in varchar2 default hr_api.g_varchar2,
988: p_peo_attribute12 in varchar2 default hr_api.g_varchar2,
989: p_peo_attribute13 in varchar2 default hr_api.g_varchar2,
990: p_peo_attribute14 in varchar2 default hr_api.g_varchar2,
991: p_peo_attribute15 in varchar2 default hr_api.g_varchar2,
992: p_peo_attribute16 in varchar2 default hr_api.g_varchar2,
993: p_peo_attribute17 in varchar2 default hr_api.g_varchar2,
994: p_peo_attribute18 in varchar2 default hr_api.g_varchar2,
995: p_peo_attribute19 in varchar2 default hr_api.g_varchar2,
996: p_peo_attribute20 in varchar2 default hr_api.g_varchar2,
989: p_peo_attribute13 in varchar2 default hr_api.g_varchar2,
990: p_peo_attribute14 in varchar2 default hr_api.g_varchar2,
991: p_peo_attribute15 in varchar2 default hr_api.g_varchar2,
992: p_peo_attribute16 in varchar2 default hr_api.g_varchar2,
993: p_peo_attribute17 in varchar2 default hr_api.g_varchar2,
994: p_peo_attribute18 in varchar2 default hr_api.g_varchar2,
995: p_peo_attribute19 in varchar2 default hr_api.g_varchar2,
996: p_peo_attribute20 in varchar2 default hr_api.g_varchar2,
997: p_peo_attribute21 in varchar2 default hr_api.g_varchar2,
990: p_peo_attribute14 in varchar2 default hr_api.g_varchar2,
991: p_peo_attribute15 in varchar2 default hr_api.g_varchar2,
992: p_peo_attribute16 in varchar2 default hr_api.g_varchar2,
993: p_peo_attribute17 in varchar2 default hr_api.g_varchar2,
994: p_peo_attribute18 in varchar2 default hr_api.g_varchar2,
995: p_peo_attribute19 in varchar2 default hr_api.g_varchar2,
996: p_peo_attribute20 in varchar2 default hr_api.g_varchar2,
997: p_peo_attribute21 in varchar2 default hr_api.g_varchar2,
998: p_peo_attribute22 in varchar2 default hr_api.g_varchar2,
991: p_peo_attribute15 in varchar2 default hr_api.g_varchar2,
992: p_peo_attribute16 in varchar2 default hr_api.g_varchar2,
993: p_peo_attribute17 in varchar2 default hr_api.g_varchar2,
994: p_peo_attribute18 in varchar2 default hr_api.g_varchar2,
995: p_peo_attribute19 in varchar2 default hr_api.g_varchar2,
996: p_peo_attribute20 in varchar2 default hr_api.g_varchar2,
997: p_peo_attribute21 in varchar2 default hr_api.g_varchar2,
998: p_peo_attribute22 in varchar2 default hr_api.g_varchar2,
999: p_peo_attribute23 in varchar2 default hr_api.g_varchar2,
992: p_peo_attribute16 in varchar2 default hr_api.g_varchar2,
993: p_peo_attribute17 in varchar2 default hr_api.g_varchar2,
994: p_peo_attribute18 in varchar2 default hr_api.g_varchar2,
995: p_peo_attribute19 in varchar2 default hr_api.g_varchar2,
996: p_peo_attribute20 in varchar2 default hr_api.g_varchar2,
997: p_peo_attribute21 in varchar2 default hr_api.g_varchar2,
998: p_peo_attribute22 in varchar2 default hr_api.g_varchar2,
999: p_peo_attribute23 in varchar2 default hr_api.g_varchar2,
1000: p_peo_attribute24 in varchar2 default hr_api.g_varchar2,
993: p_peo_attribute17 in varchar2 default hr_api.g_varchar2,
994: p_peo_attribute18 in varchar2 default hr_api.g_varchar2,
995: p_peo_attribute19 in varchar2 default hr_api.g_varchar2,
996: p_peo_attribute20 in varchar2 default hr_api.g_varchar2,
997: p_peo_attribute21 in varchar2 default hr_api.g_varchar2,
998: p_peo_attribute22 in varchar2 default hr_api.g_varchar2,
999: p_peo_attribute23 in varchar2 default hr_api.g_varchar2,
1000: p_peo_attribute24 in varchar2 default hr_api.g_varchar2,
1001: p_peo_attribute25 in varchar2 default hr_api.g_varchar2,
994: p_peo_attribute18 in varchar2 default hr_api.g_varchar2,
995: p_peo_attribute19 in varchar2 default hr_api.g_varchar2,
996: p_peo_attribute20 in varchar2 default hr_api.g_varchar2,
997: p_peo_attribute21 in varchar2 default hr_api.g_varchar2,
998: p_peo_attribute22 in varchar2 default hr_api.g_varchar2,
999: p_peo_attribute23 in varchar2 default hr_api.g_varchar2,
1000: p_peo_attribute24 in varchar2 default hr_api.g_varchar2,
1001: p_peo_attribute25 in varchar2 default hr_api.g_varchar2,
1002: p_peo_attribute26 in varchar2 default hr_api.g_varchar2,
995: p_peo_attribute19 in varchar2 default hr_api.g_varchar2,
996: p_peo_attribute20 in varchar2 default hr_api.g_varchar2,
997: p_peo_attribute21 in varchar2 default hr_api.g_varchar2,
998: p_peo_attribute22 in varchar2 default hr_api.g_varchar2,
999: p_peo_attribute23 in varchar2 default hr_api.g_varchar2,
1000: p_peo_attribute24 in varchar2 default hr_api.g_varchar2,
1001: p_peo_attribute25 in varchar2 default hr_api.g_varchar2,
1002: p_peo_attribute26 in varchar2 default hr_api.g_varchar2,
1003: p_peo_attribute27 in varchar2 default hr_api.g_varchar2,
996: p_peo_attribute20 in varchar2 default hr_api.g_varchar2,
997: p_peo_attribute21 in varchar2 default hr_api.g_varchar2,
998: p_peo_attribute22 in varchar2 default hr_api.g_varchar2,
999: p_peo_attribute23 in varchar2 default hr_api.g_varchar2,
1000: p_peo_attribute24 in varchar2 default hr_api.g_varchar2,
1001: p_peo_attribute25 in varchar2 default hr_api.g_varchar2,
1002: p_peo_attribute26 in varchar2 default hr_api.g_varchar2,
1003: p_peo_attribute27 in varchar2 default hr_api.g_varchar2,
1004: p_peo_attribute28 in varchar2 default hr_api.g_varchar2,
997: p_peo_attribute21 in varchar2 default hr_api.g_varchar2,
998: p_peo_attribute22 in varchar2 default hr_api.g_varchar2,
999: p_peo_attribute23 in varchar2 default hr_api.g_varchar2,
1000: p_peo_attribute24 in varchar2 default hr_api.g_varchar2,
1001: p_peo_attribute25 in varchar2 default hr_api.g_varchar2,
1002: p_peo_attribute26 in varchar2 default hr_api.g_varchar2,
1003: p_peo_attribute27 in varchar2 default hr_api.g_varchar2,
1004: p_peo_attribute28 in varchar2 default hr_api.g_varchar2,
1005: p_peo_attribute29 in varchar2 default hr_api.g_varchar2,
998: p_peo_attribute22 in varchar2 default hr_api.g_varchar2,
999: p_peo_attribute23 in varchar2 default hr_api.g_varchar2,
1000: p_peo_attribute24 in varchar2 default hr_api.g_varchar2,
1001: p_peo_attribute25 in varchar2 default hr_api.g_varchar2,
1002: p_peo_attribute26 in varchar2 default hr_api.g_varchar2,
1003: p_peo_attribute27 in varchar2 default hr_api.g_varchar2,
1004: p_peo_attribute28 in varchar2 default hr_api.g_varchar2,
1005: p_peo_attribute29 in varchar2 default hr_api.g_varchar2,
1006: p_peo_attribute30 in varchar2 default hr_api.g_varchar2,
999: p_peo_attribute23 in varchar2 default hr_api.g_varchar2,
1000: p_peo_attribute24 in varchar2 default hr_api.g_varchar2,
1001: p_peo_attribute25 in varchar2 default hr_api.g_varchar2,
1002: p_peo_attribute26 in varchar2 default hr_api.g_varchar2,
1003: p_peo_attribute27 in varchar2 default hr_api.g_varchar2,
1004: p_peo_attribute28 in varchar2 default hr_api.g_varchar2,
1005: p_peo_attribute29 in varchar2 default hr_api.g_varchar2,
1006: p_peo_attribute30 in varchar2 default hr_api.g_varchar2,
1007: p_object_version_number in out nocopy number,
1000: p_peo_attribute24 in varchar2 default hr_api.g_varchar2,
1001: p_peo_attribute25 in varchar2 default hr_api.g_varchar2,
1002: p_peo_attribute26 in varchar2 default hr_api.g_varchar2,
1003: p_peo_attribute27 in varchar2 default hr_api.g_varchar2,
1004: p_peo_attribute28 in varchar2 default hr_api.g_varchar2,
1005: p_peo_attribute29 in varchar2 default hr_api.g_varchar2,
1006: p_peo_attribute30 in varchar2 default hr_api.g_varchar2,
1007: p_object_version_number in out nocopy number,
1008: p_effective_date in date,
1001: p_peo_attribute25 in varchar2 default hr_api.g_varchar2,
1002: p_peo_attribute26 in varchar2 default hr_api.g_varchar2,
1003: p_peo_attribute27 in varchar2 default hr_api.g_varchar2,
1004: p_peo_attribute28 in varchar2 default hr_api.g_varchar2,
1005: p_peo_attribute29 in varchar2 default hr_api.g_varchar2,
1006: p_peo_attribute30 in varchar2 default hr_api.g_varchar2,
1007: p_object_version_number in out nocopy number,
1008: p_effective_date in date,
1009: p_datetrack_mode in varchar2
1002: p_peo_attribute26 in varchar2 default hr_api.g_varchar2,
1003: p_peo_attribute27 in varchar2 default hr_api.g_varchar2,
1004: p_peo_attribute28 in varchar2 default hr_api.g_varchar2,
1005: p_peo_attribute29 in varchar2 default hr_api.g_varchar2,
1006: p_peo_attribute30 in varchar2 default hr_api.g_varchar2,
1007: p_object_version_number in out nocopy number,
1008: p_effective_date in date,
1009: p_datetrack_mode in varchar2
1010: ) is