[Home] [Help]
119: is
120: --
121: l_proc varchar2(72) := g_package||'create_Eligible_Person';
122: --
123: l_rec ben_pep_shd.g_rec_type;
124: l_pepinsplip g_pepapi_rectyp;
125: l_pepinsplip_score_tab ben_evaluate_elig_profiles.scoreTab;
126: --
127: -- Declare cursors and local variables
544: -- Set the object version number for the insert
545: --
546: l_object_version_number := 1;
547: --
548: ben_pep_shd.g_api_dml := true; -- Set the api dml status
549: --
550: -- Insert the row into: ben_elig_per_f
551: --
552: hr_utility.set_location('Insert: '||l_proc, 5);
763: l_last_update_login
764: ) RETURNING elig_per_id into l_elig_per_id;
765: hr_utility.set_location('Dn Insert: '||l_proc, 5);
766: --
767: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
768: --
769: -- When in validation only mode raise the Validate_Enabled exception
770: --
771: if p_validate then
813: --
814: end create_perf_Eligible_Person;
815: --
816: Procedure convert_defs
817: (p_rec in out nocopy ben_pep_shd.g_rec_type
818: )
819: is
820: --
821: l_proc varchar2(72) := g_package||'convert_defs';
830: -- is being used then we must set to the 'current' argument value.
831: --
832: If (p_rec.business_group_id = hr_api.g_number) then
833: p_rec.business_group_id :=
834: ben_pep_shd.g_old_rec.business_group_id;
835: End If;
836: If (p_rec.pl_id = hr_api.g_number) then
837: p_rec.pl_id :=
838: ben_pep_shd.g_old_rec.pl_id;
834: ben_pep_shd.g_old_rec.business_group_id;
835: End If;
836: If (p_rec.pl_id = hr_api.g_number) then
837: p_rec.pl_id :=
838: ben_pep_shd.g_old_rec.pl_id;
839: End If;
840: If (p_rec.pgm_id = hr_api.g_number) then
841: p_rec.pgm_id :=
842: ben_pep_shd.g_old_rec.pgm_id;
838: ben_pep_shd.g_old_rec.pl_id;
839: End If;
840: If (p_rec.pgm_id = hr_api.g_number) then
841: p_rec.pgm_id :=
842: ben_pep_shd.g_old_rec.pgm_id;
843: End If;
844: If (p_rec.plip_id = hr_api.g_number) then
845: p_rec.plip_id :=
846: ben_pep_shd.g_old_rec.plip_id;
842: ben_pep_shd.g_old_rec.pgm_id;
843: End If;
844: If (p_rec.plip_id = hr_api.g_number) then
845: p_rec.plip_id :=
846: ben_pep_shd.g_old_rec.plip_id;
847: End If;
848: If (p_rec.ptip_id = hr_api.g_number) then
849: p_rec.ptip_id :=
850: ben_pep_shd.g_old_rec.ptip_id;
846: ben_pep_shd.g_old_rec.plip_id;
847: End If;
848: If (p_rec.ptip_id = hr_api.g_number) then
849: p_rec.ptip_id :=
850: ben_pep_shd.g_old_rec.ptip_id;
851: End If;
852: If (p_rec.ler_id = hr_api.g_number) then
853: p_rec.ler_id :=
854: ben_pep_shd.g_old_rec.ler_id;
850: ben_pep_shd.g_old_rec.ptip_id;
851: End If;
852: If (p_rec.ler_id = hr_api.g_number) then
853: p_rec.ler_id :=
854: ben_pep_shd.g_old_rec.ler_id;
855: End If;
856: If (p_rec.person_id = hr_api.g_number) then
857: p_rec.person_id :=
858: ben_pep_shd.g_old_rec.person_id;
854: ben_pep_shd.g_old_rec.ler_id;
855: End If;
856: If (p_rec.person_id = hr_api.g_number) then
857: p_rec.person_id :=
858: ben_pep_shd.g_old_rec.person_id;
859: End If;
860: If (p_rec.per_in_ler_id = hr_api.g_number) then
861: p_rec.per_in_ler_id :=
862: ben_pep_shd.g_old_rec.per_in_ler_id;
858: ben_pep_shd.g_old_rec.person_id;
859: End If;
860: If (p_rec.per_in_ler_id = hr_api.g_number) then
861: p_rec.per_in_ler_id :=
862: ben_pep_shd.g_old_rec.per_in_ler_id;
863: End If;
864: If (p_rec.dpnt_othr_pl_cvrd_rl_flag = hr_api.g_varchar2) then
865: p_rec.dpnt_othr_pl_cvrd_rl_flag :=
866: ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag;
862: ben_pep_shd.g_old_rec.per_in_ler_id;
863: End If;
864: If (p_rec.dpnt_othr_pl_cvrd_rl_flag = hr_api.g_varchar2) then
865: p_rec.dpnt_othr_pl_cvrd_rl_flag :=
866: ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag;
867: End If;
868: If (p_rec.prtn_ovridn_thru_dt = hr_api.g_date) then
869: p_rec.prtn_ovridn_thru_dt :=
870: ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt;
866: ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag;
867: End If;
868: If (p_rec.prtn_ovridn_thru_dt = hr_api.g_date) then
869: p_rec.prtn_ovridn_thru_dt :=
870: ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt;
871: End If;
872: If (p_rec.pl_key_ee_flag = hr_api.g_varchar2) then
873: p_rec.pl_key_ee_flag :=
874: ben_pep_shd.g_old_rec.pl_key_ee_flag;
870: ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt;
871: End If;
872: If (p_rec.pl_key_ee_flag = hr_api.g_varchar2) then
873: p_rec.pl_key_ee_flag :=
874: ben_pep_shd.g_old_rec.pl_key_ee_flag;
875: End If;
876: If (p_rec.pl_hghly_compd_flag = hr_api.g_varchar2) then
877: p_rec.pl_hghly_compd_flag :=
878: ben_pep_shd.g_old_rec.pl_hghly_compd_flag;
874: ben_pep_shd.g_old_rec.pl_key_ee_flag;
875: End If;
876: If (p_rec.pl_hghly_compd_flag = hr_api.g_varchar2) then
877: p_rec.pl_hghly_compd_flag :=
878: ben_pep_shd.g_old_rec.pl_hghly_compd_flag;
879: End If;
880: If (p_rec.elig_flag = hr_api.g_varchar2) then
881: p_rec.elig_flag :=
882: ben_pep_shd.g_old_rec.elig_flag;
878: ben_pep_shd.g_old_rec.pl_hghly_compd_flag;
879: End If;
880: If (p_rec.elig_flag = hr_api.g_varchar2) then
881: p_rec.elig_flag :=
882: ben_pep_shd.g_old_rec.elig_flag;
883: End If;
884: If (p_rec.comp_ref_amt = hr_api.g_number) then
885: p_rec.comp_ref_amt :=
886: ben_pep_shd.g_old_rec.comp_ref_amt;
882: ben_pep_shd.g_old_rec.elig_flag;
883: End If;
884: If (p_rec.comp_ref_amt = hr_api.g_number) then
885: p_rec.comp_ref_amt :=
886: ben_pep_shd.g_old_rec.comp_ref_amt;
887: End If;
888: If (p_rec.cmbn_age_n_los_val = hr_api.g_number) then
889: p_rec.cmbn_age_n_los_val :=
890: ben_pep_shd.g_old_rec.cmbn_age_n_los_val;
886: ben_pep_shd.g_old_rec.comp_ref_amt;
887: End If;
888: If (p_rec.cmbn_age_n_los_val = hr_api.g_number) then
889: p_rec.cmbn_age_n_los_val :=
890: ben_pep_shd.g_old_rec.cmbn_age_n_los_val;
891: End If;
892: If (p_rec.comp_ref_uom = hr_api.g_varchar2) then
893: p_rec.comp_ref_uom :=
894: ben_pep_shd.g_old_rec.comp_ref_uom;
890: ben_pep_shd.g_old_rec.cmbn_age_n_los_val;
891: End If;
892: If (p_rec.comp_ref_uom = hr_api.g_varchar2) then
893: p_rec.comp_ref_uom :=
894: ben_pep_shd.g_old_rec.comp_ref_uom;
895: End If;
896: If (p_rec.age_val = hr_api.g_number) then
897: p_rec.age_val :=
898: ben_pep_shd.g_old_rec.age_val;
894: ben_pep_shd.g_old_rec.comp_ref_uom;
895: End If;
896: If (p_rec.age_val = hr_api.g_number) then
897: p_rec.age_val :=
898: ben_pep_shd.g_old_rec.age_val;
899: End If;
900: If (p_rec.los_val = hr_api.g_number) then
901: p_rec.los_val :=
902: ben_pep_shd.g_old_rec.los_val;
898: ben_pep_shd.g_old_rec.age_val;
899: End If;
900: If (p_rec.los_val = hr_api.g_number) then
901: p_rec.los_val :=
902: ben_pep_shd.g_old_rec.los_val;
903: End If;
904: If (p_rec.prtn_end_dt = hr_api.g_date) then
905: p_rec.prtn_end_dt :=
906: ben_pep_shd.g_old_rec.prtn_end_dt;
902: ben_pep_shd.g_old_rec.los_val;
903: End If;
904: If (p_rec.prtn_end_dt = hr_api.g_date) then
905: p_rec.prtn_end_dt :=
906: ben_pep_shd.g_old_rec.prtn_end_dt;
907: End If;
908: If (p_rec.prtn_strt_dt = hr_api.g_date) then
909: p_rec.prtn_strt_dt :=
910: ben_pep_shd.g_old_rec.prtn_strt_dt;
906: ben_pep_shd.g_old_rec.prtn_end_dt;
907: End If;
908: If (p_rec.prtn_strt_dt = hr_api.g_date) then
909: p_rec.prtn_strt_dt :=
910: ben_pep_shd.g_old_rec.prtn_strt_dt;
911: End If;
912: If (p_rec.wait_perd_cmpltn_dt = hr_api.g_date) then
913: p_rec.wait_perd_cmpltn_dt :=
914: ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt;
910: ben_pep_shd.g_old_rec.prtn_strt_dt;
911: End If;
912: If (p_rec.wait_perd_cmpltn_dt = hr_api.g_date) then
913: p_rec.wait_perd_cmpltn_dt :=
914: ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt;
915: End If;
916:
917: If (p_rec.wait_perd_strt_dt = hr_api.g_date) then
918: p_rec.wait_perd_strt_dt :=
915: End If;
916:
917: If (p_rec.wait_perd_strt_dt = hr_api.g_date) then
918: p_rec.wait_perd_strt_dt :=
919: ben_pep_shd.g_old_rec.wait_perd_strt_dt;
920: End If;
921: If (p_rec.wv_ctfn_typ_cd = hr_api.g_varchar2) then
922: p_rec.wv_ctfn_typ_cd :=
923: ben_pep_shd.g_old_rec.wv_ctfn_typ_cd;
919: ben_pep_shd.g_old_rec.wait_perd_strt_dt;
920: End If;
921: If (p_rec.wv_ctfn_typ_cd = hr_api.g_varchar2) then
922: p_rec.wv_ctfn_typ_cd :=
923: ben_pep_shd.g_old_rec.wv_ctfn_typ_cd;
924: End If;
925: If (p_rec.hrs_wkd_val = hr_api.g_number) then
926: p_rec.hrs_wkd_val :=
927: ben_pep_shd.g_old_rec.hrs_wkd_val;
923: ben_pep_shd.g_old_rec.wv_ctfn_typ_cd;
924: End If;
925: If (p_rec.hrs_wkd_val = hr_api.g_number) then
926: p_rec.hrs_wkd_val :=
927: ben_pep_shd.g_old_rec.hrs_wkd_val;
928: End If;
929: If (p_rec.hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
930: p_rec.hrs_wkd_bndry_perd_cd :=
931: ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
927: ben_pep_shd.g_old_rec.hrs_wkd_val;
928: End If;
929: If (p_rec.hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
930: p_rec.hrs_wkd_bndry_perd_cd :=
931: ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
932: End If;
933: If (p_rec.prtn_ovridn_flag = hr_api.g_varchar2) then
934: p_rec.prtn_ovridn_flag :=
935: ben_pep_shd.g_old_rec.prtn_ovridn_flag;
931: ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
932: End If;
933: If (p_rec.prtn_ovridn_flag = hr_api.g_varchar2) then
934: p_rec.prtn_ovridn_flag :=
935: ben_pep_shd.g_old_rec.prtn_ovridn_flag;
936: End If;
937: If (p_rec.no_mx_prtn_ovrid_thru_flag = hr_api.g_varchar2) then
938: p_rec.no_mx_prtn_ovrid_thru_flag :=
939: ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
935: ben_pep_shd.g_old_rec.prtn_ovridn_flag;
936: End If;
937: If (p_rec.no_mx_prtn_ovrid_thru_flag = hr_api.g_varchar2) then
938: p_rec.no_mx_prtn_ovrid_thru_flag :=
939: ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
940: End If;
941: If (p_rec.prtn_ovridn_rsn_cd = hr_api.g_varchar2) then
942: p_rec.prtn_ovridn_rsn_cd :=
943: ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd;
939: ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
940: End If;
941: If (p_rec.prtn_ovridn_rsn_cd = hr_api.g_varchar2) then
942: p_rec.prtn_ovridn_rsn_cd :=
943: ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd;
944: End If;
945: If (p_rec.age_uom = hr_api.g_varchar2) then
946: p_rec.age_uom :=
947: ben_pep_shd.g_old_rec.age_uom;
943: ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd;
944: End If;
945: If (p_rec.age_uom = hr_api.g_varchar2) then
946: p_rec.age_uom :=
947: ben_pep_shd.g_old_rec.age_uom;
948: End If;
949: If (p_rec.los_uom = hr_api.g_varchar2) then
950: p_rec.los_uom :=
951: ben_pep_shd.g_old_rec.los_uom;
947: ben_pep_shd.g_old_rec.age_uom;
948: End If;
949: If (p_rec.los_uom = hr_api.g_varchar2) then
950: p_rec.los_uom :=
951: ben_pep_shd.g_old_rec.los_uom;
952: End If;
953: If (p_rec.ovrid_svc_dt = hr_api.g_date) then
954: p_rec.ovrid_svc_dt :=
955: ben_pep_shd.g_old_rec.ovrid_svc_dt;
951: ben_pep_shd.g_old_rec.los_uom;
952: End If;
953: If (p_rec.ovrid_svc_dt = hr_api.g_date) then
954: p_rec.ovrid_svc_dt :=
955: ben_pep_shd.g_old_rec.ovrid_svc_dt;
956: End If;
957: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
958: p_rec.inelg_rsn_cd :=
959: ben_pep_shd.g_old_rec.inelg_rsn_cd;
955: ben_pep_shd.g_old_rec.ovrid_svc_dt;
956: End If;
957: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
958: p_rec.inelg_rsn_cd :=
959: ben_pep_shd.g_old_rec.inelg_rsn_cd;
960: End If;
961: If (p_rec.frz_los_flag = hr_api.g_varchar2) then
962: p_rec.frz_los_flag :=
963: ben_pep_shd.g_old_rec.frz_los_flag;
959: ben_pep_shd.g_old_rec.inelg_rsn_cd;
960: End If;
961: If (p_rec.frz_los_flag = hr_api.g_varchar2) then
962: p_rec.frz_los_flag :=
963: ben_pep_shd.g_old_rec.frz_los_flag;
964: End If;
965: If (p_rec.frz_age_flag = hr_api.g_varchar2) then
966: p_rec.frz_age_flag :=
967: ben_pep_shd.g_old_rec.frz_age_flag;
963: ben_pep_shd.g_old_rec.frz_los_flag;
964: End If;
965: If (p_rec.frz_age_flag = hr_api.g_varchar2) then
966: p_rec.frz_age_flag :=
967: ben_pep_shd.g_old_rec.frz_age_flag;
968: End If;
969: If (p_rec.frz_cmp_lvl_flag = hr_api.g_varchar2) then
970: p_rec.frz_cmp_lvl_flag :=
971: ben_pep_shd.g_old_rec.frz_cmp_lvl_flag;
967: ben_pep_shd.g_old_rec.frz_age_flag;
968: End If;
969: If (p_rec.frz_cmp_lvl_flag = hr_api.g_varchar2) then
970: p_rec.frz_cmp_lvl_flag :=
971: ben_pep_shd.g_old_rec.frz_cmp_lvl_flag;
972: End If;
973: If (p_rec.frz_pct_fl_tm_flag = hr_api.g_varchar2) then
974: p_rec.frz_pct_fl_tm_flag :=
975: ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag;
971: ben_pep_shd.g_old_rec.frz_cmp_lvl_flag;
972: End If;
973: If (p_rec.frz_pct_fl_tm_flag = hr_api.g_varchar2) then
974: p_rec.frz_pct_fl_tm_flag :=
975: ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag;
976: End If;
977: If (p_rec.frz_hrs_wkd_flag = hr_api.g_varchar2) then
978: p_rec.frz_hrs_wkd_flag :=
979: ben_pep_shd.g_old_rec.frz_hrs_wkd_flag;
975: ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag;
976: End If;
977: If (p_rec.frz_hrs_wkd_flag = hr_api.g_varchar2) then
978: p_rec.frz_hrs_wkd_flag :=
979: ben_pep_shd.g_old_rec.frz_hrs_wkd_flag;
980: End If;
981: If (p_rec.frz_comb_age_and_los_flag = hr_api.g_varchar2) then
982: p_rec.frz_comb_age_and_los_flag :=
983: ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag;
979: ben_pep_shd.g_old_rec.frz_hrs_wkd_flag;
980: End If;
981: If (p_rec.frz_comb_age_and_los_flag = hr_api.g_varchar2) then
982: p_rec.frz_comb_age_and_los_flag :=
983: ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag;
984: End If;
985: If (p_rec.dstr_rstcn_flag = hr_api.g_varchar2) then
986: p_rec.dstr_rstcn_flag :=
987: ben_pep_shd.g_old_rec.dstr_rstcn_flag;
983: ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag;
984: End If;
985: If (p_rec.dstr_rstcn_flag = hr_api.g_varchar2) then
986: p_rec.dstr_rstcn_flag :=
987: ben_pep_shd.g_old_rec.dstr_rstcn_flag;
988: End If;
989: If (p_rec.pct_fl_tm_val = hr_api.g_number) then
990: p_rec.pct_fl_tm_val :=
991: ben_pep_shd.g_old_rec.pct_fl_tm_val;
987: ben_pep_shd.g_old_rec.dstr_rstcn_flag;
988: End If;
989: If (p_rec.pct_fl_tm_val = hr_api.g_number) then
990: p_rec.pct_fl_tm_val :=
991: ben_pep_shd.g_old_rec.pct_fl_tm_val;
992: End If;
993: If (p_rec.wv_prtn_rsn_cd = hr_api.g_varchar2) then
994: p_rec.wv_prtn_rsn_cd :=
995: ben_pep_shd.g_old_rec.wv_prtn_rsn_cd;
991: ben_pep_shd.g_old_rec.pct_fl_tm_val;
992: End If;
993: If (p_rec.wv_prtn_rsn_cd = hr_api.g_varchar2) then
994: p_rec.wv_prtn_rsn_cd :=
995: ben_pep_shd.g_old_rec.wv_prtn_rsn_cd;
996: End If;
997: If (p_rec.pl_wvd_flag = hr_api.g_varchar2) then
998: p_rec.pl_wvd_flag :=
999: ben_pep_shd.g_old_rec.pl_wvd_flag;
995: ben_pep_shd.g_old_rec.wv_prtn_rsn_cd;
996: End If;
997: If (p_rec.pl_wvd_flag = hr_api.g_varchar2) then
998: p_rec.pl_wvd_flag :=
999: ben_pep_shd.g_old_rec.pl_wvd_flag;
1000: End If;
1001: If (p_rec.rt_comp_ref_amt = hr_api.g_number) then
1002: p_rec.rt_comp_ref_amt :=
1003: ben_pep_shd.g_old_rec.rt_comp_ref_amt;
999: ben_pep_shd.g_old_rec.pl_wvd_flag;
1000: End If;
1001: If (p_rec.rt_comp_ref_amt = hr_api.g_number) then
1002: p_rec.rt_comp_ref_amt :=
1003: ben_pep_shd.g_old_rec.rt_comp_ref_amt;
1004: End If;
1005: If (p_rec.rt_cmbn_age_n_los_val = hr_api.g_number) then
1006: p_rec.rt_cmbn_age_n_los_val :=
1007: ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val;
1003: ben_pep_shd.g_old_rec.rt_comp_ref_amt;
1004: End If;
1005: If (p_rec.rt_cmbn_age_n_los_val = hr_api.g_number) then
1006: p_rec.rt_cmbn_age_n_los_val :=
1007: ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val;
1008: End If;
1009: If (p_rec.rt_comp_ref_uom = hr_api.g_varchar2) then
1010: p_rec.rt_comp_ref_uom :=
1011: ben_pep_shd.g_old_rec.rt_comp_ref_uom;
1007: ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val;
1008: End If;
1009: If (p_rec.rt_comp_ref_uom = hr_api.g_varchar2) then
1010: p_rec.rt_comp_ref_uom :=
1011: ben_pep_shd.g_old_rec.rt_comp_ref_uom;
1012: End If;
1013: If (p_rec.rt_age_val = hr_api.g_number) then
1014: p_rec.rt_age_val :=
1015: ben_pep_shd.g_old_rec.rt_age_val;
1011: ben_pep_shd.g_old_rec.rt_comp_ref_uom;
1012: End If;
1013: If (p_rec.rt_age_val = hr_api.g_number) then
1014: p_rec.rt_age_val :=
1015: ben_pep_shd.g_old_rec.rt_age_val;
1016: End If;
1017: If (p_rec.rt_los_val = hr_api.g_number) then
1018: p_rec.rt_los_val :=
1019: ben_pep_shd.g_old_rec.rt_los_val;
1015: ben_pep_shd.g_old_rec.rt_age_val;
1016: End If;
1017: If (p_rec.rt_los_val = hr_api.g_number) then
1018: p_rec.rt_los_val :=
1019: ben_pep_shd.g_old_rec.rt_los_val;
1020: End If;
1021: If (p_rec.rt_hrs_wkd_val = hr_api.g_number) then
1022: p_rec.rt_hrs_wkd_val :=
1023: ben_pep_shd.g_old_rec.rt_hrs_wkd_val;
1019: ben_pep_shd.g_old_rec.rt_los_val;
1020: End If;
1021: If (p_rec.rt_hrs_wkd_val = hr_api.g_number) then
1022: p_rec.rt_hrs_wkd_val :=
1023: ben_pep_shd.g_old_rec.rt_hrs_wkd_val;
1024: End If;
1025: If (p_rec.rt_hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
1026: p_rec.rt_hrs_wkd_bndry_perd_cd :=
1027: ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
1023: ben_pep_shd.g_old_rec.rt_hrs_wkd_val;
1024: End If;
1025: If (p_rec.rt_hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
1026: p_rec.rt_hrs_wkd_bndry_perd_cd :=
1027: ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
1028: End If;
1029: If (p_rec.rt_age_uom = hr_api.g_varchar2) then
1030: p_rec.rt_age_uom :=
1031: ben_pep_shd.g_old_rec.rt_age_uom;
1027: ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
1028: End If;
1029: If (p_rec.rt_age_uom = hr_api.g_varchar2) then
1030: p_rec.rt_age_uom :=
1031: ben_pep_shd.g_old_rec.rt_age_uom;
1032: End If;
1033: If (p_rec.rt_los_uom = hr_api.g_varchar2) then
1034: p_rec.rt_los_uom :=
1035: ben_pep_shd.g_old_rec.rt_los_uom;
1031: ben_pep_shd.g_old_rec.rt_age_uom;
1032: End If;
1033: If (p_rec.rt_los_uom = hr_api.g_varchar2) then
1034: p_rec.rt_los_uom :=
1035: ben_pep_shd.g_old_rec.rt_los_uom;
1036: End If;
1037: If (p_rec.rt_pct_fl_tm_val = hr_api.g_number) then
1038: p_rec.rt_pct_fl_tm_val :=
1039: ben_pep_shd.g_old_rec.rt_pct_fl_tm_val;
1035: ben_pep_shd.g_old_rec.rt_los_uom;
1036: End If;
1037: If (p_rec.rt_pct_fl_tm_val = hr_api.g_number) then
1038: p_rec.rt_pct_fl_tm_val :=
1039: ben_pep_shd.g_old_rec.rt_pct_fl_tm_val;
1040: End If;
1041: If (p_rec.rt_frz_los_flag = hr_api.g_varchar2) then
1042: p_rec.rt_frz_los_flag :=
1043: ben_pep_shd.g_old_rec.rt_frz_los_flag;
1039: ben_pep_shd.g_old_rec.rt_pct_fl_tm_val;
1040: End If;
1041: If (p_rec.rt_frz_los_flag = hr_api.g_varchar2) then
1042: p_rec.rt_frz_los_flag :=
1043: ben_pep_shd.g_old_rec.rt_frz_los_flag;
1044: End If;
1045: If (p_rec.rt_frz_age_flag = hr_api.g_varchar2) then
1046: p_rec.rt_frz_age_flag :=
1047: ben_pep_shd.g_old_rec.rt_frz_age_flag;
1043: ben_pep_shd.g_old_rec.rt_frz_los_flag;
1044: End If;
1045: If (p_rec.rt_frz_age_flag = hr_api.g_varchar2) then
1046: p_rec.rt_frz_age_flag :=
1047: ben_pep_shd.g_old_rec.rt_frz_age_flag;
1048: End If;
1049: If (p_rec.rt_frz_cmp_lvl_flag = hr_api.g_varchar2) then
1050: p_rec.rt_frz_cmp_lvl_flag :=
1051: ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag;
1047: ben_pep_shd.g_old_rec.rt_frz_age_flag;
1048: End If;
1049: If (p_rec.rt_frz_cmp_lvl_flag = hr_api.g_varchar2) then
1050: p_rec.rt_frz_cmp_lvl_flag :=
1051: ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag;
1052: End If;
1053: If (p_rec.rt_frz_pct_fl_tm_flag = hr_api.g_varchar2) then
1054: p_rec.rt_frz_pct_fl_tm_flag :=
1055: ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
1051: ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag;
1052: End If;
1053: If (p_rec.rt_frz_pct_fl_tm_flag = hr_api.g_varchar2) then
1054: p_rec.rt_frz_pct_fl_tm_flag :=
1055: ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
1056: End If;
1057: If (p_rec.rt_frz_hrs_wkd_flag = hr_api.g_varchar2) then
1058: p_rec.rt_frz_hrs_wkd_flag :=
1059: ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag;
1055: ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
1056: End If;
1057: If (p_rec.rt_frz_hrs_wkd_flag = hr_api.g_varchar2) then
1058: p_rec.rt_frz_hrs_wkd_flag :=
1059: ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag;
1060: End If;
1061: If (p_rec.rt_frz_comb_age_and_los_flag = hr_api.g_varchar2) then
1062: p_rec.rt_frz_comb_age_and_los_flag :=
1063: ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
1059: ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag;
1060: End If;
1061: If (p_rec.rt_frz_comb_age_and_los_flag = hr_api.g_varchar2) then
1062: p_rec.rt_frz_comb_age_and_los_flag :=
1063: ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
1064: End If;
1065: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then
1066: p_rec.once_r_cntug_cd :=
1067: ben_pep_shd.g_old_rec.once_r_cntug_cd;
1063: ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
1064: End If;
1065: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then
1066: p_rec.once_r_cntug_cd :=
1067: ben_pep_shd.g_old_rec.once_r_cntug_cd;
1068: End If;
1069: If (p_rec.pl_ordr_num = hr_api.g_number) then
1070: p_rec.pl_ordr_num :=
1071: ben_pep_shd.g_old_rec.pl_ordr_num;
1067: ben_pep_shd.g_old_rec.once_r_cntug_cd;
1068: End If;
1069: If (p_rec.pl_ordr_num = hr_api.g_number) then
1070: p_rec.pl_ordr_num :=
1071: ben_pep_shd.g_old_rec.pl_ordr_num;
1072: End If;
1073: If (p_rec.plip_ordr_num = hr_api.g_number) then
1074: p_rec.plip_ordr_num :=
1075: ben_pep_shd.g_old_rec.plip_ordr_num;
1071: ben_pep_shd.g_old_rec.pl_ordr_num;
1072: End If;
1073: If (p_rec.plip_ordr_num = hr_api.g_number) then
1074: p_rec.plip_ordr_num :=
1075: ben_pep_shd.g_old_rec.plip_ordr_num;
1076: End If;
1077: If (p_rec.ptip_ordr_num = hr_api.g_number) then
1078: p_rec.ptip_ordr_num :=
1079: ben_pep_shd.g_old_rec.ptip_ordr_num;
1075: ben_pep_shd.g_old_rec.plip_ordr_num;
1076: End If;
1077: If (p_rec.ptip_ordr_num = hr_api.g_number) then
1078: p_rec.ptip_ordr_num :=
1079: ben_pep_shd.g_old_rec.ptip_ordr_num;
1080: End If;
1081: If (p_rec.pep_attribute_category = hr_api.g_varchar2) then
1082: p_rec.pep_attribute_category :=
1083: ben_pep_shd.g_old_rec.pep_attribute_category;
1079: ben_pep_shd.g_old_rec.ptip_ordr_num;
1080: End If;
1081: If (p_rec.pep_attribute_category = hr_api.g_varchar2) then
1082: p_rec.pep_attribute_category :=
1083: ben_pep_shd.g_old_rec.pep_attribute_category;
1084: End If;
1085: If (p_rec.pep_attribute1 = hr_api.g_varchar2) then
1086: p_rec.pep_attribute1 :=
1087: ben_pep_shd.g_old_rec.pep_attribute1;
1083: ben_pep_shd.g_old_rec.pep_attribute_category;
1084: End If;
1085: If (p_rec.pep_attribute1 = hr_api.g_varchar2) then
1086: p_rec.pep_attribute1 :=
1087: ben_pep_shd.g_old_rec.pep_attribute1;
1088: End If;
1089: If (p_rec.pep_attribute2 = hr_api.g_varchar2) then
1090: p_rec.pep_attribute2 :=
1091: ben_pep_shd.g_old_rec.pep_attribute2;
1087: ben_pep_shd.g_old_rec.pep_attribute1;
1088: End If;
1089: If (p_rec.pep_attribute2 = hr_api.g_varchar2) then
1090: p_rec.pep_attribute2 :=
1091: ben_pep_shd.g_old_rec.pep_attribute2;
1092: End If;
1093: If (p_rec.pep_attribute3 = hr_api.g_varchar2) then
1094: p_rec.pep_attribute3 :=
1095: ben_pep_shd.g_old_rec.pep_attribute3;
1091: ben_pep_shd.g_old_rec.pep_attribute2;
1092: End If;
1093: If (p_rec.pep_attribute3 = hr_api.g_varchar2) then
1094: p_rec.pep_attribute3 :=
1095: ben_pep_shd.g_old_rec.pep_attribute3;
1096: End If;
1097: If (p_rec.pep_attribute4 = hr_api.g_varchar2) then
1098: p_rec.pep_attribute4 :=
1099: ben_pep_shd.g_old_rec.pep_attribute4;
1095: ben_pep_shd.g_old_rec.pep_attribute3;
1096: End If;
1097: If (p_rec.pep_attribute4 = hr_api.g_varchar2) then
1098: p_rec.pep_attribute4 :=
1099: ben_pep_shd.g_old_rec.pep_attribute4;
1100: End If;
1101: If (p_rec.pep_attribute5 = hr_api.g_varchar2) then
1102: p_rec.pep_attribute5 :=
1103: ben_pep_shd.g_old_rec.pep_attribute5;
1099: ben_pep_shd.g_old_rec.pep_attribute4;
1100: End If;
1101: If (p_rec.pep_attribute5 = hr_api.g_varchar2) then
1102: p_rec.pep_attribute5 :=
1103: ben_pep_shd.g_old_rec.pep_attribute5;
1104: End If;
1105: If (p_rec.pep_attribute6 = hr_api.g_varchar2) then
1106: p_rec.pep_attribute6 :=
1107: ben_pep_shd.g_old_rec.pep_attribute6;
1103: ben_pep_shd.g_old_rec.pep_attribute5;
1104: End If;
1105: If (p_rec.pep_attribute6 = hr_api.g_varchar2) then
1106: p_rec.pep_attribute6 :=
1107: ben_pep_shd.g_old_rec.pep_attribute6;
1108: End If;
1109: If (p_rec.pep_attribute7 = hr_api.g_varchar2) then
1110: p_rec.pep_attribute7 :=
1111: ben_pep_shd.g_old_rec.pep_attribute7;
1107: ben_pep_shd.g_old_rec.pep_attribute6;
1108: End If;
1109: If (p_rec.pep_attribute7 = hr_api.g_varchar2) then
1110: p_rec.pep_attribute7 :=
1111: ben_pep_shd.g_old_rec.pep_attribute7;
1112: End If;
1113: If (p_rec.pep_attribute8 = hr_api.g_varchar2) then
1114: p_rec.pep_attribute8 :=
1115: ben_pep_shd.g_old_rec.pep_attribute8;
1111: ben_pep_shd.g_old_rec.pep_attribute7;
1112: End If;
1113: If (p_rec.pep_attribute8 = hr_api.g_varchar2) then
1114: p_rec.pep_attribute8 :=
1115: ben_pep_shd.g_old_rec.pep_attribute8;
1116: End If;
1117: If (p_rec.pep_attribute9 = hr_api.g_varchar2) then
1118: p_rec.pep_attribute9 :=
1119: ben_pep_shd.g_old_rec.pep_attribute9;
1115: ben_pep_shd.g_old_rec.pep_attribute8;
1116: End If;
1117: If (p_rec.pep_attribute9 = hr_api.g_varchar2) then
1118: p_rec.pep_attribute9 :=
1119: ben_pep_shd.g_old_rec.pep_attribute9;
1120: End If;
1121: If (p_rec.pep_attribute10 = hr_api.g_varchar2) then
1122: p_rec.pep_attribute10 :=
1123: ben_pep_shd.g_old_rec.pep_attribute10;
1119: ben_pep_shd.g_old_rec.pep_attribute9;
1120: End If;
1121: If (p_rec.pep_attribute10 = hr_api.g_varchar2) then
1122: p_rec.pep_attribute10 :=
1123: ben_pep_shd.g_old_rec.pep_attribute10;
1124: End If;
1125: If (p_rec.pep_attribute11 = hr_api.g_varchar2) then
1126: p_rec.pep_attribute11 :=
1127: ben_pep_shd.g_old_rec.pep_attribute11;
1123: ben_pep_shd.g_old_rec.pep_attribute10;
1124: End If;
1125: If (p_rec.pep_attribute11 = hr_api.g_varchar2) then
1126: p_rec.pep_attribute11 :=
1127: ben_pep_shd.g_old_rec.pep_attribute11;
1128: End If;
1129: If (p_rec.pep_attribute12 = hr_api.g_varchar2) then
1130: p_rec.pep_attribute12 :=
1131: ben_pep_shd.g_old_rec.pep_attribute12;
1127: ben_pep_shd.g_old_rec.pep_attribute11;
1128: End If;
1129: If (p_rec.pep_attribute12 = hr_api.g_varchar2) then
1130: p_rec.pep_attribute12 :=
1131: ben_pep_shd.g_old_rec.pep_attribute12;
1132: End If;
1133: If (p_rec.pep_attribute13 = hr_api.g_varchar2) then
1134: p_rec.pep_attribute13 :=
1135: ben_pep_shd.g_old_rec.pep_attribute13;
1131: ben_pep_shd.g_old_rec.pep_attribute12;
1132: End If;
1133: If (p_rec.pep_attribute13 = hr_api.g_varchar2) then
1134: p_rec.pep_attribute13 :=
1135: ben_pep_shd.g_old_rec.pep_attribute13;
1136: End If;
1137: If (p_rec.pep_attribute14 = hr_api.g_varchar2) then
1138: p_rec.pep_attribute14 :=
1139: ben_pep_shd.g_old_rec.pep_attribute14;
1135: ben_pep_shd.g_old_rec.pep_attribute13;
1136: End If;
1137: If (p_rec.pep_attribute14 = hr_api.g_varchar2) then
1138: p_rec.pep_attribute14 :=
1139: ben_pep_shd.g_old_rec.pep_attribute14;
1140: End If;
1141: If (p_rec.pep_attribute15 = hr_api.g_varchar2) then
1142: p_rec.pep_attribute15 :=
1143: ben_pep_shd.g_old_rec.pep_attribute15;
1139: ben_pep_shd.g_old_rec.pep_attribute14;
1140: End If;
1141: If (p_rec.pep_attribute15 = hr_api.g_varchar2) then
1142: p_rec.pep_attribute15 :=
1143: ben_pep_shd.g_old_rec.pep_attribute15;
1144: End If;
1145: If (p_rec.pep_attribute16 = hr_api.g_varchar2) then
1146: p_rec.pep_attribute16 :=
1147: ben_pep_shd.g_old_rec.pep_attribute16;
1143: ben_pep_shd.g_old_rec.pep_attribute15;
1144: End If;
1145: If (p_rec.pep_attribute16 = hr_api.g_varchar2) then
1146: p_rec.pep_attribute16 :=
1147: ben_pep_shd.g_old_rec.pep_attribute16;
1148: End If;
1149: If (p_rec.pep_attribute17 = hr_api.g_varchar2) then
1150: p_rec.pep_attribute17 :=
1151: ben_pep_shd.g_old_rec.pep_attribute17;
1147: ben_pep_shd.g_old_rec.pep_attribute16;
1148: End If;
1149: If (p_rec.pep_attribute17 = hr_api.g_varchar2) then
1150: p_rec.pep_attribute17 :=
1151: ben_pep_shd.g_old_rec.pep_attribute17;
1152: End If;
1153: If (p_rec.pep_attribute18 = hr_api.g_varchar2) then
1154: p_rec.pep_attribute18 :=
1155: ben_pep_shd.g_old_rec.pep_attribute18;
1151: ben_pep_shd.g_old_rec.pep_attribute17;
1152: End If;
1153: If (p_rec.pep_attribute18 = hr_api.g_varchar2) then
1154: p_rec.pep_attribute18 :=
1155: ben_pep_shd.g_old_rec.pep_attribute18;
1156: End If;
1157: If (p_rec.pep_attribute19 = hr_api.g_varchar2) then
1158: p_rec.pep_attribute19 :=
1159: ben_pep_shd.g_old_rec.pep_attribute19;
1155: ben_pep_shd.g_old_rec.pep_attribute18;
1156: End If;
1157: If (p_rec.pep_attribute19 = hr_api.g_varchar2) then
1158: p_rec.pep_attribute19 :=
1159: ben_pep_shd.g_old_rec.pep_attribute19;
1160: End If;
1161: If (p_rec.pep_attribute20 = hr_api.g_varchar2) then
1162: p_rec.pep_attribute20 :=
1163: ben_pep_shd.g_old_rec.pep_attribute20;
1159: ben_pep_shd.g_old_rec.pep_attribute19;
1160: End If;
1161: If (p_rec.pep_attribute20 = hr_api.g_varchar2) then
1162: p_rec.pep_attribute20 :=
1163: ben_pep_shd.g_old_rec.pep_attribute20;
1164: End If;
1165: If (p_rec.pep_attribute21 = hr_api.g_varchar2) then
1166: p_rec.pep_attribute21 :=
1167: ben_pep_shd.g_old_rec.pep_attribute21;
1163: ben_pep_shd.g_old_rec.pep_attribute20;
1164: End If;
1165: If (p_rec.pep_attribute21 = hr_api.g_varchar2) then
1166: p_rec.pep_attribute21 :=
1167: ben_pep_shd.g_old_rec.pep_attribute21;
1168: End If;
1169: If (p_rec.pep_attribute22 = hr_api.g_varchar2) then
1170: p_rec.pep_attribute22 :=
1171: ben_pep_shd.g_old_rec.pep_attribute22;
1167: ben_pep_shd.g_old_rec.pep_attribute21;
1168: End If;
1169: If (p_rec.pep_attribute22 = hr_api.g_varchar2) then
1170: p_rec.pep_attribute22 :=
1171: ben_pep_shd.g_old_rec.pep_attribute22;
1172: End If;
1173: If (p_rec.pep_attribute23 = hr_api.g_varchar2) then
1174: p_rec.pep_attribute23 :=
1175: ben_pep_shd.g_old_rec.pep_attribute23;
1171: ben_pep_shd.g_old_rec.pep_attribute22;
1172: End If;
1173: If (p_rec.pep_attribute23 = hr_api.g_varchar2) then
1174: p_rec.pep_attribute23 :=
1175: ben_pep_shd.g_old_rec.pep_attribute23;
1176: End If;
1177: If (p_rec.pep_attribute24 = hr_api.g_varchar2) then
1178: p_rec.pep_attribute24 :=
1179: ben_pep_shd.g_old_rec.pep_attribute24;
1175: ben_pep_shd.g_old_rec.pep_attribute23;
1176: End If;
1177: If (p_rec.pep_attribute24 = hr_api.g_varchar2) then
1178: p_rec.pep_attribute24 :=
1179: ben_pep_shd.g_old_rec.pep_attribute24;
1180: End If;
1181: If (p_rec.pep_attribute25 = hr_api.g_varchar2) then
1182: p_rec.pep_attribute25 :=
1183: ben_pep_shd.g_old_rec.pep_attribute25;
1179: ben_pep_shd.g_old_rec.pep_attribute24;
1180: End If;
1181: If (p_rec.pep_attribute25 = hr_api.g_varchar2) then
1182: p_rec.pep_attribute25 :=
1183: ben_pep_shd.g_old_rec.pep_attribute25;
1184: End If;
1185: If (p_rec.pep_attribute26 = hr_api.g_varchar2) then
1186: p_rec.pep_attribute26 :=
1187: ben_pep_shd.g_old_rec.pep_attribute26;
1183: ben_pep_shd.g_old_rec.pep_attribute25;
1184: End If;
1185: If (p_rec.pep_attribute26 = hr_api.g_varchar2) then
1186: p_rec.pep_attribute26 :=
1187: ben_pep_shd.g_old_rec.pep_attribute26;
1188: End If;
1189: If (p_rec.pep_attribute27 = hr_api.g_varchar2) then
1190: p_rec.pep_attribute27 :=
1191: ben_pep_shd.g_old_rec.pep_attribute27;
1187: ben_pep_shd.g_old_rec.pep_attribute26;
1188: End If;
1189: If (p_rec.pep_attribute27 = hr_api.g_varchar2) then
1190: p_rec.pep_attribute27 :=
1191: ben_pep_shd.g_old_rec.pep_attribute27;
1192: End If;
1193: If (p_rec.pep_attribute28 = hr_api.g_varchar2) then
1194: p_rec.pep_attribute28 :=
1195: ben_pep_shd.g_old_rec.pep_attribute28;
1191: ben_pep_shd.g_old_rec.pep_attribute27;
1192: End If;
1193: If (p_rec.pep_attribute28 = hr_api.g_varchar2) then
1194: p_rec.pep_attribute28 :=
1195: ben_pep_shd.g_old_rec.pep_attribute28;
1196: End If;
1197: If (p_rec.pep_attribute29 = hr_api.g_varchar2) then
1198: p_rec.pep_attribute29 :=
1199: ben_pep_shd.g_old_rec.pep_attribute29;
1195: ben_pep_shd.g_old_rec.pep_attribute28;
1196: End If;
1197: If (p_rec.pep_attribute29 = hr_api.g_varchar2) then
1198: p_rec.pep_attribute29 :=
1199: ben_pep_shd.g_old_rec.pep_attribute29;
1200: End If;
1201: If (p_rec.pep_attribute30 = hr_api.g_varchar2) then
1202: p_rec.pep_attribute30 :=
1203: ben_pep_shd.g_old_rec.pep_attribute30;
1199: ben_pep_shd.g_old_rec.pep_attribute29;
1200: End If;
1201: If (p_rec.pep_attribute30 = hr_api.g_varchar2) then
1202: p_rec.pep_attribute30 :=
1203: ben_pep_shd.g_old_rec.pep_attribute30;
1204: End If;
1205: If (p_rec.request_id = hr_api.g_number) then
1206: p_rec.request_id :=
1207: ben_pep_shd.g_old_rec.request_id;
1203: ben_pep_shd.g_old_rec.pep_attribute30;
1204: End If;
1205: If (p_rec.request_id = hr_api.g_number) then
1206: p_rec.request_id :=
1207: ben_pep_shd.g_old_rec.request_id;
1208: End If;
1209: If (p_rec.program_application_id = hr_api.g_number) then
1210: p_rec.program_application_id :=
1211: ben_pep_shd.g_old_rec.program_application_id;
1207: ben_pep_shd.g_old_rec.request_id;
1208: End If;
1209: If (p_rec.program_application_id = hr_api.g_number) then
1210: p_rec.program_application_id :=
1211: ben_pep_shd.g_old_rec.program_application_id;
1212: End If;
1213: If (p_rec.program_id = hr_api.g_number) then
1214: p_rec.program_id :=
1215: ben_pep_shd.g_old_rec.program_id;
1211: ben_pep_shd.g_old_rec.program_application_id;
1212: End If;
1213: If (p_rec.program_id = hr_api.g_number) then
1214: p_rec.program_id :=
1215: ben_pep_shd.g_old_rec.program_id;
1216: End If;
1217: If (p_rec.program_update_date = hr_api.g_date) then
1218: p_rec.program_update_date :=
1219: ben_pep_shd.g_old_rec.program_update_date;
1215: ben_pep_shd.g_old_rec.program_id;
1216: End If;
1217: If (p_rec.program_update_date = hr_api.g_date) then
1218: p_rec.program_update_date :=
1219: ben_pep_shd.g_old_rec.program_update_date;
1220: End If;
1221: --
1222: hr_utility.set_location(' Leaving:'||l_proc, 10);
1223: --
1363: --
1364: -- We must select and lock the current row.
1365: --
1366: Open C_Sel1;
1367: Fetch C_Sel1 Into ben_pep_shd.g_old_rec;
1368: If C_Sel1%notfound then
1369: Close C_Sel1;
1370: --
1371: -- The primary key is invalid therefore we must error
1373: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1374: fnd_message.raise_error;
1375: End If;
1376: Close C_Sel1;
1377: If (p_object_version_number <> ben_pep_shd.g_old_rec.object_version_number)
1378: then
1379: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
1380: fnd_message.raise_error;
1381: End If;
1548: -- Declare cursors and local variables
1549: --
1550: l_proc varchar2(72) := g_package||'update_perf_Eligible_Person';
1551: --
1552: l_rec ben_pep_shd.g_rec_type;
1553: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
1554: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
1555: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1556: --
1687: t.creation_date
1688: from ben_elig_per_f t
1689: where t.elig_per_id = p_elig_per_id
1690: and t.effective_start_date =
1691: ben_pep_shd.g_old_rec.effective_start_date
1692: and t.effective_end_date = (l_validation_start_date - 1);
1693: --
1694: cursor c_effdates
1695: (c_eff_date date
1993: -- Process Logic
1994: --
1995: l_object_version_number := p_object_version_number;
1996: l_rec :=
1997: ben_pep_shd.convert_args
1998: (
1999: p_elig_per_id,
2000: null,
2001: null,
2107: --
2108: -- We must select and lock the current row.
2109: --
2110: Open c_old_rec;
2111: Fetch c_old_rec Into ben_pep_shd.g_old_rec;
2112: If c_old_rec%notfound then
2113: Close c_old_rec;
2114: --
2115: -- The primary key is invalid therefore we must error
2117: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
2118: fnd_message.raise_error;
2119: End If;
2120: Close c_old_rec;
2121: If (p_object_version_number <> ben_pep_shd.g_old_rec.object_version_number) Then
2122: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
2123: fnd_message.raise_error;
2124: End If;
2125: hr_utility.set_location(l_proc, 15);
2155: if ben_manage_life_events.g_modified_mode in ('S','U','D') then --ICM
2156: --compare values to decide whether to update or not
2157: if
2158: --
2159: nvl(ben_pep_shd.g_old_rec.pl_id,-1) <> nvl(l_rec.pl_id,-1) or
2160: nvl(ben_pep_shd.g_old_rec.pgm_id,-1) <> nvl(l_rec.pgm_id,-1) or
2161: nvl(ben_pep_shd.g_old_rec.plip_id,-1) <> nvl(l_rec.plip_id,-1) or
2162: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2163: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2156: --compare values to decide whether to update or not
2157: if
2158: --
2159: nvl(ben_pep_shd.g_old_rec.pl_id,-1) <> nvl(l_rec.pl_id,-1) or
2160: nvl(ben_pep_shd.g_old_rec.pgm_id,-1) <> nvl(l_rec.pgm_id,-1) or
2161: nvl(ben_pep_shd.g_old_rec.plip_id,-1) <> nvl(l_rec.plip_id,-1) or
2162: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2163: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2164: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2157: if
2158: --
2159: nvl(ben_pep_shd.g_old_rec.pl_id,-1) <> nvl(l_rec.pl_id,-1) or
2160: nvl(ben_pep_shd.g_old_rec.pgm_id,-1) <> nvl(l_rec.pgm_id,-1) or
2161: nvl(ben_pep_shd.g_old_rec.plip_id,-1) <> nvl(l_rec.plip_id,-1) or
2162: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2163: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2164: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2165: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2158: --
2159: nvl(ben_pep_shd.g_old_rec.pl_id,-1) <> nvl(l_rec.pl_id,-1) or
2160: nvl(ben_pep_shd.g_old_rec.pgm_id,-1) <> nvl(l_rec.pgm_id,-1) or
2161: nvl(ben_pep_shd.g_old_rec.plip_id,-1) <> nvl(l_rec.plip_id,-1) or
2162: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2163: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2164: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2165: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2166: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2159: nvl(ben_pep_shd.g_old_rec.pl_id,-1) <> nvl(l_rec.pl_id,-1) or
2160: nvl(ben_pep_shd.g_old_rec.pgm_id,-1) <> nvl(l_rec.pgm_id,-1) or
2161: nvl(ben_pep_shd.g_old_rec.plip_id,-1) <> nvl(l_rec.plip_id,-1) or
2162: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2163: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2164: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2165: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2166: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2167: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2160: nvl(ben_pep_shd.g_old_rec.pgm_id,-1) <> nvl(l_rec.pgm_id,-1) or
2161: nvl(ben_pep_shd.g_old_rec.plip_id,-1) <> nvl(l_rec.plip_id,-1) or
2162: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2163: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2164: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2165: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2166: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2167: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2168: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2162: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2163: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2164: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2165: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2166: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2167: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2168: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2169: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2170: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2164: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2165: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2166: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2167: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2168: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2169: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2170: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2171: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2172: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2165: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2166: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2167: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2168: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2169: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2170: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2171: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2172: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2173: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2166: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2167: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2168: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2169: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2170: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2171: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2172: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2173: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2174: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2167: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2168: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2169: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2170: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2171: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2172: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2173: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2174: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2175: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2168: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2169: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2170: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2171: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2172: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2173: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2174: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2175: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2176: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2169: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2170: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2171: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2172: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2173: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2174: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2175: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2176: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2177: nvl(l_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2170: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2171: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2172: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2173: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2174: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2175: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2176: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2177: nvl(l_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2178: nvl(ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2171: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2172: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2173: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2174: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2175: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2176: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2177: nvl(l_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2178: nvl(ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2179: nvl(l_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2172: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2173: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2174: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2175: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2176: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2177: nvl(l_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2178: nvl(ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2179: nvl(l_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2180: nvl(ben_pep_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2174: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2175: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2176: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2177: nvl(l_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2178: nvl(ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2179: nvl(l_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2180: nvl(ben_pep_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2181: nvl(l_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2182: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2176: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2177: nvl(l_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2178: nvl(ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2179: nvl(l_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2180: nvl(ben_pep_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2181: nvl(l_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2182: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2183: nvl(ben_pep_shd.g_old_rec.hrs_wkd_val,-1) <> nvl(l_rec.hrs_wkd_val,-1) or
2184: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2178: nvl(ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2179: nvl(l_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2180: nvl(ben_pep_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2181: nvl(l_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2182: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2183: nvl(ben_pep_shd.g_old_rec.hrs_wkd_val,-1) <> nvl(l_rec.hrs_wkd_val,-1) or
2184: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2185: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_flag,'N') <> nvl(l_rec.prtn_ovridn_flag,'N') or
2186: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2179: nvl(l_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2180: nvl(ben_pep_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2181: nvl(l_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2182: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2183: nvl(ben_pep_shd.g_old_rec.hrs_wkd_val,-1) <> nvl(l_rec.hrs_wkd_val,-1) or
2184: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2185: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_flag,'N') <> nvl(l_rec.prtn_ovridn_flag,'N') or
2186: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2187: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2180: nvl(ben_pep_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2181: nvl(l_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2182: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2183: nvl(ben_pep_shd.g_old_rec.hrs_wkd_val,-1) <> nvl(l_rec.hrs_wkd_val,-1) or
2184: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2185: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_flag,'N') <> nvl(l_rec.prtn_ovridn_flag,'N') or
2186: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2187: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2188: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2181: nvl(l_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2182: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2183: nvl(ben_pep_shd.g_old_rec.hrs_wkd_val,-1) <> nvl(l_rec.hrs_wkd_val,-1) or
2184: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2185: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_flag,'N') <> nvl(l_rec.prtn_ovridn_flag,'N') or
2186: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2187: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2188: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2189: nvl(l_rec.prtn_ovridn_rsn_cd, 'X') or
2182: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2183: nvl(ben_pep_shd.g_old_rec.hrs_wkd_val,-1) <> nvl(l_rec.hrs_wkd_val,-1) or
2184: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2185: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_flag,'N') <> nvl(l_rec.prtn_ovridn_flag,'N') or
2186: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2187: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2188: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2189: nvl(l_rec.prtn_ovridn_rsn_cd, 'X') or
2190: nvl(ben_pep_shd.g_old_rec.age_uom,'X') <> nvl(l_rec.age_uom,'X') or
2184: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2185: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_flag,'N') <> nvl(l_rec.prtn_ovridn_flag,'N') or
2186: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2187: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2188: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2189: nvl(l_rec.prtn_ovridn_rsn_cd, 'X') or
2190: nvl(ben_pep_shd.g_old_rec.age_uom,'X') <> nvl(l_rec.age_uom,'X') or
2191: nvl(ben_pep_shd.g_old_rec.los_uom,'X') <> nvl(l_rec.los_uom,'X') or
2192: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2186: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2187: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2188: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2189: nvl(l_rec.prtn_ovridn_rsn_cd, 'X') or
2190: nvl(ben_pep_shd.g_old_rec.age_uom,'X') <> nvl(l_rec.age_uom,'X') or
2191: nvl(ben_pep_shd.g_old_rec.los_uom,'X') <> nvl(l_rec.los_uom,'X') or
2192: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2193: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2194: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2187: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2188: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2189: nvl(l_rec.prtn_ovridn_rsn_cd, 'X') or
2190: nvl(ben_pep_shd.g_old_rec.age_uom,'X') <> nvl(l_rec.age_uom,'X') or
2191: nvl(ben_pep_shd.g_old_rec.los_uom,'X') <> nvl(l_rec.los_uom,'X') or
2192: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2193: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2194: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2195: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2188: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2189: nvl(l_rec.prtn_ovridn_rsn_cd, 'X') or
2190: nvl(ben_pep_shd.g_old_rec.age_uom,'X') <> nvl(l_rec.age_uom,'X') or
2191: nvl(ben_pep_shd.g_old_rec.los_uom,'X') <> nvl(l_rec.los_uom,'X') or
2192: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2193: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2194: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2195: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2196: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2190: nvl(ben_pep_shd.g_old_rec.age_uom,'X') <> nvl(l_rec.age_uom,'X') or
2191: nvl(ben_pep_shd.g_old_rec.los_uom,'X') <> nvl(l_rec.los_uom,'X') or
2192: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2193: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2194: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2195: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2196: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2197: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2198: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2191: nvl(ben_pep_shd.g_old_rec.los_uom,'X') <> nvl(l_rec.los_uom,'X') or
2192: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2193: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2194: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2195: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2196: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2197: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2198: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2192: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2193: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2194: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2195: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2196: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2197: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2198: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag,'N') <> nvl(l_rec.frz_comb_age_and_los_flag,'N') or
2193: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2194: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2195: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2196: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2197: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2198: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag,'N') <> nvl(l_rec.frz_comb_age_and_los_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2194: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2195: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2196: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2197: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2198: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag,'N') <> nvl(l_rec.frz_comb_age_and_los_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2202: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2195: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2196: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2197: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2198: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag,'N') <> nvl(l_rec.frz_comb_age_and_los_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2202: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2203: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2196: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2197: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2198: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag,'N') <> nvl(l_rec.frz_comb_age_and_los_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2202: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2203: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2204: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2197: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2198: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag,'N') <> nvl(l_rec.frz_comb_age_and_los_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2202: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2203: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2204: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2205: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2198: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag,'N') <> nvl(l_rec.frz_comb_age_and_los_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2202: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2203: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2204: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2205: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2206: nvl(ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) <> nvl(l_rec.rt_cmbn_age_n_los_val,-1) or
2199: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag,'N') <> nvl(l_rec.frz_comb_age_and_los_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2202: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2203: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2204: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2205: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2206: nvl(ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) <> nvl(l_rec.rt_cmbn_age_n_los_val,-1) or
2207: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2200: nvl(ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag,'N') <> nvl(l_rec.frz_comb_age_and_los_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2202: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2203: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2204: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2205: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2206: nvl(ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) <> nvl(l_rec.rt_cmbn_age_n_los_val,-1) or
2207: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2208: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2201: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2202: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2203: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2204: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2205: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2206: nvl(ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) <> nvl(l_rec.rt_cmbn_age_n_los_val,-1) or
2207: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2208: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2209: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2202: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2203: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2204: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2205: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2206: nvl(ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) <> nvl(l_rec.rt_cmbn_age_n_los_val,-1) or
2207: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2208: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2209: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2210: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2203: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2204: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2205: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2206: nvl(ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) <> nvl(l_rec.rt_cmbn_age_n_los_val,-1) or
2207: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2208: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2209: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2210: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2211: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2204: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2205: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2206: nvl(ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) <> nvl(l_rec.rt_cmbn_age_n_los_val,-1) or
2207: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2208: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2209: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2210: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2211: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2212: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2205: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2206: nvl(ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) <> nvl(l_rec.rt_cmbn_age_n_los_val,-1) or
2207: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2208: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2209: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2210: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2211: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2212: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2213: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2206: nvl(ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) <> nvl(l_rec.rt_cmbn_age_n_los_val,-1) or
2207: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2208: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2209: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2210: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2211: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2212: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2213: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2214: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2207: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2208: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2209: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2210: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2211: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2212: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2213: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2214: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2215: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2209: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2210: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2211: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2212: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2213: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2214: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2215: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2216: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2217: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2210: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2211: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2212: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2213: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2214: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2215: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2216: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2217: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2211: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2212: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2213: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2214: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2215: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2216: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2217: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2219: nvl(ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(l_rec.rt_frz_pct_fl_tm_flag,'N') or
2212: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2213: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2214: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2215: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2216: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2217: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2219: nvl(ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(l_rec.rt_frz_pct_fl_tm_flag,'N') or
2220: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2213: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2214: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2215: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2216: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2217: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2219: nvl(ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(l_rec.rt_frz_pct_fl_tm_flag,'N') or
2220: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2221: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2214: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2215: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2216: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2217: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2219: nvl(ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(l_rec.rt_frz_pct_fl_tm_flag,'N') or
2220: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2221: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2222: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2215: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2216: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2217: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2219: nvl(ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(l_rec.rt_frz_pct_fl_tm_flag,'N') or
2220: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2221: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2222: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2223: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2216: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2217: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2219: nvl(ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(l_rec.rt_frz_pct_fl_tm_flag,'N') or
2220: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2221: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2222: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2223: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2224: nvl(ben_pep_shd.g_old_rec.pl_ordr_num,-1) <> nvl(l_rec.pl_ordr_num,-1) or
2217: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2219: nvl(ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(l_rec.rt_frz_pct_fl_tm_flag,'N') or
2220: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2221: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2222: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2223: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2224: nvl(ben_pep_shd.g_old_rec.pl_ordr_num,-1) <> nvl(l_rec.pl_ordr_num,-1) or
2225: nvl(ben_pep_shd.g_old_rec.plip_ordr_num,-1) <> nvl(l_rec.plip_ordr_num,-1) or
2219: nvl(ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(l_rec.rt_frz_pct_fl_tm_flag,'N') or
2220: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2221: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2222: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2223: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2224: nvl(ben_pep_shd.g_old_rec.pl_ordr_num,-1) <> nvl(l_rec.pl_ordr_num,-1) or
2225: nvl(ben_pep_shd.g_old_rec.plip_ordr_num,-1) <> nvl(l_rec.plip_ordr_num,-1) or
2226: nvl(ben_pep_shd.g_old_rec.ptip_ordr_num,-1) <> nvl(l_rec.ptip_ordr_num,-1)
2227: then
2220: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2221: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2222: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2223: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2224: nvl(ben_pep_shd.g_old_rec.pl_ordr_num,-1) <> nvl(l_rec.pl_ordr_num,-1) or
2225: nvl(ben_pep_shd.g_old_rec.plip_ordr_num,-1) <> nvl(l_rec.plip_ordr_num,-1) or
2226: nvl(ben_pep_shd.g_old_rec.ptip_ordr_num,-1) <> nvl(l_rec.ptip_ordr_num,-1)
2227: then
2228: -- do nothing
2221: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2222: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2223: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2224: nvl(ben_pep_shd.g_old_rec.pl_ordr_num,-1) <> nvl(l_rec.pl_ordr_num,-1) or
2225: nvl(ben_pep_shd.g_old_rec.plip_ordr_num,-1) <> nvl(l_rec.plip_ordr_num,-1) or
2226: nvl(ben_pep_shd.g_old_rec.ptip_ordr_num,-1) <> nvl(l_rec.ptip_ordr_num,-1)
2227: then
2228: -- do nothing
2229: null;
2222: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2223: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2224: nvl(ben_pep_shd.g_old_rec.pl_ordr_num,-1) <> nvl(l_rec.pl_ordr_num,-1) or
2225: nvl(ben_pep_shd.g_old_rec.plip_ordr_num,-1) <> nvl(l_rec.plip_ordr_num,-1) or
2226: nvl(ben_pep_shd.g_old_rec.ptip_ordr_num,-1) <> nvl(l_rec.ptip_ordr_num,-1)
2227: then
2228: -- do nothing
2229: null;
2230: --
2245: );
2246: fetch c_getovn into l_object_version_number;
2247: close c_getovn;
2248: --
2249: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2250: --
2251: -- Update the specified datetrack row setting the effective
2252: -- end date to the specified new effective end date.
2253: --
2257: where t.elig_per_id = p_elig_per_id
2258: and p_effective_date
2259: between t.effective_start_date and t.effective_end_date;
2260: --
2261: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2262: --
2263: If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
2264: hr_utility.set_location(l_proc, 15);
2265: --
2267: -- delete any future rows
2268: --
2269: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
2270: hr_utility.set_location(l_proc, 10);
2271: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2272: --
2273: -- Delete the where the effective start date is equal
2274: -- to the validation end date.
2275: --
2276: delete from ben_elig_per_f
2277: where elig_per_id = p_elig_per_id
2278: and effective_start_date = l_validation_start_date;
2279: --
2280: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2281: Else
2282: hr_utility.set_location(l_proc, 15);
2283: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2284: --
2279: --
2280: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2281: Else
2282: hr_utility.set_location(l_proc, 15);
2283: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2284: --
2285: -- Delete the row(s) where the effective start date is greater than
2286: -- or equal to the validation start date.
2287: --
2288: delete from ben_elig_per_f
2289: where elig_per_id = p_elig_per_id
2290: and effective_start_date >= l_validation_start_date;
2291: --
2292: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2293: End If;
2294: --
2295: End If;
2296: hr_utility.set_location(l_proc, 20);
2342: l_last_updated_by := fnd_global.user_id;
2343: l_last_update_login := fnd_global.login_id;
2344: End If;
2345: --
2346: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2347: --
2348: -- Insert the row into: ben_elig_per_f
2349: --
2350: hr_utility.set_location('Ins PEP:'||l_proc, 5);
2566: l_last_updated_by,
2567: l_last_update_login
2568: );
2569: --
2570: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2571: End If;
2572: --
2573: -- update_dml
2574: --
2583: );
2584: fetch c_getovn into l_rec.object_version_number;
2585: close c_getovn;
2586: --
2587: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2588: --
2589: -- Update the ben_elig_per_f Row
2590: --
2591: update ben_elig_per_f
2692: where elig_per_id = l_rec.elig_per_id
2693: and effective_start_date = l_validation_start_date
2694: and effective_end_date = l_validation_end_date;
2695: --
2696: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2697: --
2698: -- Set the effective start and end dates
2699: --
2700: l_rec.effective_start_date := l_validation_start_date;