[Home] [Help]
123: is
124: --
125: l_proc varchar2(72) := g_package||'create_Eligible_Person';
126: --
127: l_rec ben_pep_shd.g_rec_type;
128: l_pepinsplip g_pepapi_rectyp;
129: l_pepinsplip_score_tab ben_evaluate_elig_profiles.scoreTab;
130: --
131: -- Declare cursors and local variables
548: -- Set the object version number for the insert
549: --
550: l_object_version_number := 1;
551: --
552: ben_pep_shd.g_api_dml := true; -- Set the api dml status
553: --
554: -- Insert the row into: ben_elig_per_f
555: --
556: hr_utility.set_location('Insert: '||l_proc, 5);
784:
785: --Bug 12732878 changes end
786: ------------------------------------------------------------------------------
787:
788: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
789: --
790: -- When in validation only mode raise the Validate_Enabled exception
791: --
792: if p_validate then
834: --
835: end create_perf_Eligible_Person;
836: --
837: Procedure convert_defs
838: (p_rec in out nocopy ben_pep_shd.g_rec_type
839: )
840: is
841: --
842: l_proc varchar2(72) := g_package||'convert_defs';
851: -- is being used then we must set to the 'current' argument value.
852: --
853: If (p_rec.business_group_id = hr_api.g_number) then
854: p_rec.business_group_id :=
855: ben_pep_shd.g_old_rec.business_group_id;
856: End If;
857: If (p_rec.pl_id = hr_api.g_number) then
858: p_rec.pl_id :=
859: ben_pep_shd.g_old_rec.pl_id;
855: ben_pep_shd.g_old_rec.business_group_id;
856: End If;
857: If (p_rec.pl_id = hr_api.g_number) then
858: p_rec.pl_id :=
859: ben_pep_shd.g_old_rec.pl_id;
860: End If;
861: If (p_rec.pgm_id = hr_api.g_number) then
862: p_rec.pgm_id :=
863: ben_pep_shd.g_old_rec.pgm_id;
859: ben_pep_shd.g_old_rec.pl_id;
860: End If;
861: If (p_rec.pgm_id = hr_api.g_number) then
862: p_rec.pgm_id :=
863: ben_pep_shd.g_old_rec.pgm_id;
864: End If;
865: If (p_rec.plip_id = hr_api.g_number) then
866: p_rec.plip_id :=
867: ben_pep_shd.g_old_rec.plip_id;
863: ben_pep_shd.g_old_rec.pgm_id;
864: End If;
865: If (p_rec.plip_id = hr_api.g_number) then
866: p_rec.plip_id :=
867: ben_pep_shd.g_old_rec.plip_id;
868: End If;
869: If (p_rec.ptip_id = hr_api.g_number) then
870: p_rec.ptip_id :=
871: ben_pep_shd.g_old_rec.ptip_id;
867: ben_pep_shd.g_old_rec.plip_id;
868: End If;
869: If (p_rec.ptip_id = hr_api.g_number) then
870: p_rec.ptip_id :=
871: ben_pep_shd.g_old_rec.ptip_id;
872: End If;
873: If (p_rec.ler_id = hr_api.g_number) then
874: p_rec.ler_id :=
875: ben_pep_shd.g_old_rec.ler_id;
871: ben_pep_shd.g_old_rec.ptip_id;
872: End If;
873: If (p_rec.ler_id = hr_api.g_number) then
874: p_rec.ler_id :=
875: ben_pep_shd.g_old_rec.ler_id;
876: End If;
877: If (p_rec.person_id = hr_api.g_number) then
878: p_rec.person_id :=
879: ben_pep_shd.g_old_rec.person_id;
875: ben_pep_shd.g_old_rec.ler_id;
876: End If;
877: If (p_rec.person_id = hr_api.g_number) then
878: p_rec.person_id :=
879: ben_pep_shd.g_old_rec.person_id;
880: End If;
881: If (p_rec.per_in_ler_id = hr_api.g_number) then
882: p_rec.per_in_ler_id :=
883: ben_pep_shd.g_old_rec.per_in_ler_id;
879: ben_pep_shd.g_old_rec.person_id;
880: End If;
881: If (p_rec.per_in_ler_id = hr_api.g_number) then
882: p_rec.per_in_ler_id :=
883: ben_pep_shd.g_old_rec.per_in_ler_id;
884: End If;
885: If (p_rec.dpnt_othr_pl_cvrd_rl_flag = hr_api.g_varchar2) then
886: p_rec.dpnt_othr_pl_cvrd_rl_flag :=
887: ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag;
883: ben_pep_shd.g_old_rec.per_in_ler_id;
884: End If;
885: If (p_rec.dpnt_othr_pl_cvrd_rl_flag = hr_api.g_varchar2) then
886: p_rec.dpnt_othr_pl_cvrd_rl_flag :=
887: ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag;
888: End If;
889: If (p_rec.prtn_ovridn_thru_dt = hr_api.g_date) then
890: p_rec.prtn_ovridn_thru_dt :=
891: ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt;
887: ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag;
888: End If;
889: If (p_rec.prtn_ovridn_thru_dt = hr_api.g_date) then
890: p_rec.prtn_ovridn_thru_dt :=
891: ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt;
892: End If;
893: If (p_rec.pl_key_ee_flag = hr_api.g_varchar2) then
894: p_rec.pl_key_ee_flag :=
895: ben_pep_shd.g_old_rec.pl_key_ee_flag;
891: ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt;
892: End If;
893: If (p_rec.pl_key_ee_flag = hr_api.g_varchar2) then
894: p_rec.pl_key_ee_flag :=
895: ben_pep_shd.g_old_rec.pl_key_ee_flag;
896: End If;
897: If (p_rec.pl_hghly_compd_flag = hr_api.g_varchar2) then
898: p_rec.pl_hghly_compd_flag :=
899: ben_pep_shd.g_old_rec.pl_hghly_compd_flag;
895: ben_pep_shd.g_old_rec.pl_key_ee_flag;
896: End If;
897: If (p_rec.pl_hghly_compd_flag = hr_api.g_varchar2) then
898: p_rec.pl_hghly_compd_flag :=
899: ben_pep_shd.g_old_rec.pl_hghly_compd_flag;
900: End If;
901: If (p_rec.elig_flag = hr_api.g_varchar2) then
902: p_rec.elig_flag :=
903: ben_pep_shd.g_old_rec.elig_flag;
899: ben_pep_shd.g_old_rec.pl_hghly_compd_flag;
900: End If;
901: If (p_rec.elig_flag = hr_api.g_varchar2) then
902: p_rec.elig_flag :=
903: ben_pep_shd.g_old_rec.elig_flag;
904: End If;
905: If (p_rec.comp_ref_amt = hr_api.g_number) then
906: p_rec.comp_ref_amt :=
907: ben_pep_shd.g_old_rec.comp_ref_amt;
903: ben_pep_shd.g_old_rec.elig_flag;
904: End If;
905: If (p_rec.comp_ref_amt = hr_api.g_number) then
906: p_rec.comp_ref_amt :=
907: ben_pep_shd.g_old_rec.comp_ref_amt;
908: End If;
909: If (p_rec.cmbn_age_n_los_val = hr_api.g_number) then
910: p_rec.cmbn_age_n_los_val :=
911: ben_pep_shd.g_old_rec.cmbn_age_n_los_val;
907: ben_pep_shd.g_old_rec.comp_ref_amt;
908: End If;
909: If (p_rec.cmbn_age_n_los_val = hr_api.g_number) then
910: p_rec.cmbn_age_n_los_val :=
911: ben_pep_shd.g_old_rec.cmbn_age_n_los_val;
912: End If;
913: If (p_rec.comp_ref_uom = hr_api.g_varchar2) then
914: p_rec.comp_ref_uom :=
915: ben_pep_shd.g_old_rec.comp_ref_uom;
911: ben_pep_shd.g_old_rec.cmbn_age_n_los_val;
912: End If;
913: If (p_rec.comp_ref_uom = hr_api.g_varchar2) then
914: p_rec.comp_ref_uom :=
915: ben_pep_shd.g_old_rec.comp_ref_uom;
916: End If;
917: If (p_rec.age_val = hr_api.g_number) then
918: p_rec.age_val :=
919: ben_pep_shd.g_old_rec.age_val;
915: ben_pep_shd.g_old_rec.comp_ref_uom;
916: End If;
917: If (p_rec.age_val = hr_api.g_number) then
918: p_rec.age_val :=
919: ben_pep_shd.g_old_rec.age_val;
920: End If;
921: If (p_rec.los_val = hr_api.g_number) then
922: p_rec.los_val :=
923: ben_pep_shd.g_old_rec.los_val;
919: ben_pep_shd.g_old_rec.age_val;
920: End If;
921: If (p_rec.los_val = hr_api.g_number) then
922: p_rec.los_val :=
923: ben_pep_shd.g_old_rec.los_val;
924: End If;
925: If (p_rec.prtn_end_dt = hr_api.g_date) then
926: p_rec.prtn_end_dt :=
927: ben_pep_shd.g_old_rec.prtn_end_dt;
923: ben_pep_shd.g_old_rec.los_val;
924: End If;
925: If (p_rec.prtn_end_dt = hr_api.g_date) then
926: p_rec.prtn_end_dt :=
927: ben_pep_shd.g_old_rec.prtn_end_dt;
928: End If;
929: If (p_rec.prtn_strt_dt = hr_api.g_date) then
930: p_rec.prtn_strt_dt :=
931: ben_pep_shd.g_old_rec.prtn_strt_dt;
927: ben_pep_shd.g_old_rec.prtn_end_dt;
928: End If;
929: If (p_rec.prtn_strt_dt = hr_api.g_date) then
930: p_rec.prtn_strt_dt :=
931: ben_pep_shd.g_old_rec.prtn_strt_dt;
932: End If;
933: If (p_rec.wait_perd_cmpltn_dt = hr_api.g_date) then
934: p_rec.wait_perd_cmpltn_dt :=
935: ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt;
931: ben_pep_shd.g_old_rec.prtn_strt_dt;
932: End If;
933: If (p_rec.wait_perd_cmpltn_dt = hr_api.g_date) then
934: p_rec.wait_perd_cmpltn_dt :=
935: ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt;
936: End If;
937:
938: If (p_rec.wait_perd_strt_dt = hr_api.g_date) then
939: p_rec.wait_perd_strt_dt :=
936: End If;
937:
938: If (p_rec.wait_perd_strt_dt = hr_api.g_date) then
939: p_rec.wait_perd_strt_dt :=
940: ben_pep_shd.g_old_rec.wait_perd_strt_dt;
941: End If;
942: If (p_rec.wv_ctfn_typ_cd = hr_api.g_varchar2) then
943: p_rec.wv_ctfn_typ_cd :=
944: ben_pep_shd.g_old_rec.wv_ctfn_typ_cd;
940: ben_pep_shd.g_old_rec.wait_perd_strt_dt;
941: End If;
942: If (p_rec.wv_ctfn_typ_cd = hr_api.g_varchar2) then
943: p_rec.wv_ctfn_typ_cd :=
944: ben_pep_shd.g_old_rec.wv_ctfn_typ_cd;
945: End If;
946: If (p_rec.hrs_wkd_val = hr_api.g_number) then
947: p_rec.hrs_wkd_val :=
948: ben_pep_shd.g_old_rec.hrs_wkd_val;
944: ben_pep_shd.g_old_rec.wv_ctfn_typ_cd;
945: End If;
946: If (p_rec.hrs_wkd_val = hr_api.g_number) then
947: p_rec.hrs_wkd_val :=
948: ben_pep_shd.g_old_rec.hrs_wkd_val;
949: End If;
950: If (p_rec.hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
951: p_rec.hrs_wkd_bndry_perd_cd :=
952: ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
948: ben_pep_shd.g_old_rec.hrs_wkd_val;
949: End If;
950: If (p_rec.hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
951: p_rec.hrs_wkd_bndry_perd_cd :=
952: ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
953: End If;
954: If (p_rec.prtn_ovridn_flag = hr_api.g_varchar2) then
955: p_rec.prtn_ovridn_flag :=
956: ben_pep_shd.g_old_rec.prtn_ovridn_flag;
952: ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
953: End If;
954: If (p_rec.prtn_ovridn_flag = hr_api.g_varchar2) then
955: p_rec.prtn_ovridn_flag :=
956: ben_pep_shd.g_old_rec.prtn_ovridn_flag;
957: End If;
958: If (p_rec.no_mx_prtn_ovrid_thru_flag = hr_api.g_varchar2) then
959: p_rec.no_mx_prtn_ovrid_thru_flag :=
960: ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
956: ben_pep_shd.g_old_rec.prtn_ovridn_flag;
957: End If;
958: If (p_rec.no_mx_prtn_ovrid_thru_flag = hr_api.g_varchar2) then
959: p_rec.no_mx_prtn_ovrid_thru_flag :=
960: ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
961: End If;
962: If (p_rec.prtn_ovridn_rsn_cd = hr_api.g_varchar2) then
963: p_rec.prtn_ovridn_rsn_cd :=
964: ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd;
960: ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
961: End If;
962: If (p_rec.prtn_ovridn_rsn_cd = hr_api.g_varchar2) then
963: p_rec.prtn_ovridn_rsn_cd :=
964: ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd;
965: End If;
966: If (p_rec.age_uom = hr_api.g_varchar2) then
967: p_rec.age_uom :=
968: ben_pep_shd.g_old_rec.age_uom;
964: ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd;
965: End If;
966: If (p_rec.age_uom = hr_api.g_varchar2) then
967: p_rec.age_uom :=
968: ben_pep_shd.g_old_rec.age_uom;
969: End If;
970: If (p_rec.los_uom = hr_api.g_varchar2) then
971: p_rec.los_uom :=
972: ben_pep_shd.g_old_rec.los_uom;
968: ben_pep_shd.g_old_rec.age_uom;
969: End If;
970: If (p_rec.los_uom = hr_api.g_varchar2) then
971: p_rec.los_uom :=
972: ben_pep_shd.g_old_rec.los_uom;
973: End If;
974: If (p_rec.ovrid_svc_dt = hr_api.g_date) then
975: p_rec.ovrid_svc_dt :=
976: ben_pep_shd.g_old_rec.ovrid_svc_dt;
972: ben_pep_shd.g_old_rec.los_uom;
973: End If;
974: If (p_rec.ovrid_svc_dt = hr_api.g_date) then
975: p_rec.ovrid_svc_dt :=
976: ben_pep_shd.g_old_rec.ovrid_svc_dt;
977: End If;
978: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
979: p_rec.inelg_rsn_cd :=
980: ben_pep_shd.g_old_rec.inelg_rsn_cd;
976: ben_pep_shd.g_old_rec.ovrid_svc_dt;
977: End If;
978: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
979: p_rec.inelg_rsn_cd :=
980: ben_pep_shd.g_old_rec.inelg_rsn_cd;
981: End If;
982: If (p_rec.frz_los_flag = hr_api.g_varchar2) then
983: p_rec.frz_los_flag :=
984: ben_pep_shd.g_old_rec.frz_los_flag;
980: ben_pep_shd.g_old_rec.inelg_rsn_cd;
981: End If;
982: If (p_rec.frz_los_flag = hr_api.g_varchar2) then
983: p_rec.frz_los_flag :=
984: ben_pep_shd.g_old_rec.frz_los_flag;
985: End If;
986: If (p_rec.frz_age_flag = hr_api.g_varchar2) then
987: p_rec.frz_age_flag :=
988: ben_pep_shd.g_old_rec.frz_age_flag;
984: ben_pep_shd.g_old_rec.frz_los_flag;
985: End If;
986: If (p_rec.frz_age_flag = hr_api.g_varchar2) then
987: p_rec.frz_age_flag :=
988: ben_pep_shd.g_old_rec.frz_age_flag;
989: End If;
990: If (p_rec.frz_cmp_lvl_flag = hr_api.g_varchar2) then
991: p_rec.frz_cmp_lvl_flag :=
992: ben_pep_shd.g_old_rec.frz_cmp_lvl_flag;
988: ben_pep_shd.g_old_rec.frz_age_flag;
989: End If;
990: If (p_rec.frz_cmp_lvl_flag = hr_api.g_varchar2) then
991: p_rec.frz_cmp_lvl_flag :=
992: ben_pep_shd.g_old_rec.frz_cmp_lvl_flag;
993: End If;
994: If (p_rec.frz_pct_fl_tm_flag = hr_api.g_varchar2) then
995: p_rec.frz_pct_fl_tm_flag :=
996: ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag;
992: ben_pep_shd.g_old_rec.frz_cmp_lvl_flag;
993: End If;
994: If (p_rec.frz_pct_fl_tm_flag = hr_api.g_varchar2) then
995: p_rec.frz_pct_fl_tm_flag :=
996: ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag;
997: End If;
998: If (p_rec.frz_hrs_wkd_flag = hr_api.g_varchar2) then
999: p_rec.frz_hrs_wkd_flag :=
1000: ben_pep_shd.g_old_rec.frz_hrs_wkd_flag;
996: ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag;
997: End If;
998: If (p_rec.frz_hrs_wkd_flag = hr_api.g_varchar2) then
999: p_rec.frz_hrs_wkd_flag :=
1000: ben_pep_shd.g_old_rec.frz_hrs_wkd_flag;
1001: End If;
1002: If (p_rec.frz_comb_age_and_los_flag = hr_api.g_varchar2) then
1003: p_rec.frz_comb_age_and_los_flag :=
1004: ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag;
1000: ben_pep_shd.g_old_rec.frz_hrs_wkd_flag;
1001: End If;
1002: If (p_rec.frz_comb_age_and_los_flag = hr_api.g_varchar2) then
1003: p_rec.frz_comb_age_and_los_flag :=
1004: ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag;
1005: End If;
1006: If (p_rec.dstr_rstcn_flag = hr_api.g_varchar2) then
1007: p_rec.dstr_rstcn_flag :=
1008: ben_pep_shd.g_old_rec.dstr_rstcn_flag;
1004: ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag;
1005: End If;
1006: If (p_rec.dstr_rstcn_flag = hr_api.g_varchar2) then
1007: p_rec.dstr_rstcn_flag :=
1008: ben_pep_shd.g_old_rec.dstr_rstcn_flag;
1009: End If;
1010: If (p_rec.pct_fl_tm_val = hr_api.g_number) then
1011: p_rec.pct_fl_tm_val :=
1012: ben_pep_shd.g_old_rec.pct_fl_tm_val;
1008: ben_pep_shd.g_old_rec.dstr_rstcn_flag;
1009: End If;
1010: If (p_rec.pct_fl_tm_val = hr_api.g_number) then
1011: p_rec.pct_fl_tm_val :=
1012: ben_pep_shd.g_old_rec.pct_fl_tm_val;
1013: End If;
1014: If (p_rec.wv_prtn_rsn_cd = hr_api.g_varchar2) then
1015: p_rec.wv_prtn_rsn_cd :=
1016: ben_pep_shd.g_old_rec.wv_prtn_rsn_cd;
1012: ben_pep_shd.g_old_rec.pct_fl_tm_val;
1013: End If;
1014: If (p_rec.wv_prtn_rsn_cd = hr_api.g_varchar2) then
1015: p_rec.wv_prtn_rsn_cd :=
1016: ben_pep_shd.g_old_rec.wv_prtn_rsn_cd;
1017: End If;
1018: If (p_rec.pl_wvd_flag = hr_api.g_varchar2) then
1019: p_rec.pl_wvd_flag :=
1020: ben_pep_shd.g_old_rec.pl_wvd_flag;
1016: ben_pep_shd.g_old_rec.wv_prtn_rsn_cd;
1017: End If;
1018: If (p_rec.pl_wvd_flag = hr_api.g_varchar2) then
1019: p_rec.pl_wvd_flag :=
1020: ben_pep_shd.g_old_rec.pl_wvd_flag;
1021: End If;
1022: If (p_rec.rt_comp_ref_amt = hr_api.g_number) then
1023: p_rec.rt_comp_ref_amt :=
1024: ben_pep_shd.g_old_rec.rt_comp_ref_amt;
1020: ben_pep_shd.g_old_rec.pl_wvd_flag;
1021: End If;
1022: If (p_rec.rt_comp_ref_amt = hr_api.g_number) then
1023: p_rec.rt_comp_ref_amt :=
1024: ben_pep_shd.g_old_rec.rt_comp_ref_amt;
1025: End If;
1026: If (p_rec.rt_cmbn_age_n_los_val = hr_api.g_number) then
1027: p_rec.rt_cmbn_age_n_los_val :=
1028: ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val;
1024: ben_pep_shd.g_old_rec.rt_comp_ref_amt;
1025: End If;
1026: If (p_rec.rt_cmbn_age_n_los_val = hr_api.g_number) then
1027: p_rec.rt_cmbn_age_n_los_val :=
1028: ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val;
1029: End If;
1030: If (p_rec.rt_comp_ref_uom = hr_api.g_varchar2) then
1031: p_rec.rt_comp_ref_uom :=
1032: ben_pep_shd.g_old_rec.rt_comp_ref_uom;
1028: ben_pep_shd.g_old_rec.rt_cmbn_age_n_los_val;
1029: End If;
1030: If (p_rec.rt_comp_ref_uom = hr_api.g_varchar2) then
1031: p_rec.rt_comp_ref_uom :=
1032: ben_pep_shd.g_old_rec.rt_comp_ref_uom;
1033: End If;
1034: If (p_rec.rt_age_val = hr_api.g_number) then
1035: p_rec.rt_age_val :=
1036: ben_pep_shd.g_old_rec.rt_age_val;
1032: ben_pep_shd.g_old_rec.rt_comp_ref_uom;
1033: End If;
1034: If (p_rec.rt_age_val = hr_api.g_number) then
1035: p_rec.rt_age_val :=
1036: ben_pep_shd.g_old_rec.rt_age_val;
1037: End If;
1038: If (p_rec.rt_los_val = hr_api.g_number) then
1039: p_rec.rt_los_val :=
1040: ben_pep_shd.g_old_rec.rt_los_val;
1036: ben_pep_shd.g_old_rec.rt_age_val;
1037: End If;
1038: If (p_rec.rt_los_val = hr_api.g_number) then
1039: p_rec.rt_los_val :=
1040: ben_pep_shd.g_old_rec.rt_los_val;
1041: End If;
1042: If (p_rec.rt_hrs_wkd_val = hr_api.g_number) then
1043: p_rec.rt_hrs_wkd_val :=
1044: ben_pep_shd.g_old_rec.rt_hrs_wkd_val;
1040: ben_pep_shd.g_old_rec.rt_los_val;
1041: End If;
1042: If (p_rec.rt_hrs_wkd_val = hr_api.g_number) then
1043: p_rec.rt_hrs_wkd_val :=
1044: ben_pep_shd.g_old_rec.rt_hrs_wkd_val;
1045: End If;
1046: If (p_rec.rt_hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
1047: p_rec.rt_hrs_wkd_bndry_perd_cd :=
1048: ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
1044: ben_pep_shd.g_old_rec.rt_hrs_wkd_val;
1045: End If;
1046: If (p_rec.rt_hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
1047: p_rec.rt_hrs_wkd_bndry_perd_cd :=
1048: ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
1049: End If;
1050: If (p_rec.rt_age_uom = hr_api.g_varchar2) then
1051: p_rec.rt_age_uom :=
1052: ben_pep_shd.g_old_rec.rt_age_uom;
1048: ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
1049: End If;
1050: If (p_rec.rt_age_uom = hr_api.g_varchar2) then
1051: p_rec.rt_age_uom :=
1052: ben_pep_shd.g_old_rec.rt_age_uom;
1053: End If;
1054: If (p_rec.rt_los_uom = hr_api.g_varchar2) then
1055: p_rec.rt_los_uom :=
1056: ben_pep_shd.g_old_rec.rt_los_uom;
1052: ben_pep_shd.g_old_rec.rt_age_uom;
1053: End If;
1054: If (p_rec.rt_los_uom = hr_api.g_varchar2) then
1055: p_rec.rt_los_uom :=
1056: ben_pep_shd.g_old_rec.rt_los_uom;
1057: End If;
1058: If (p_rec.rt_pct_fl_tm_val = hr_api.g_number) then
1059: p_rec.rt_pct_fl_tm_val :=
1060: ben_pep_shd.g_old_rec.rt_pct_fl_tm_val;
1056: ben_pep_shd.g_old_rec.rt_los_uom;
1057: End If;
1058: If (p_rec.rt_pct_fl_tm_val = hr_api.g_number) then
1059: p_rec.rt_pct_fl_tm_val :=
1060: ben_pep_shd.g_old_rec.rt_pct_fl_tm_val;
1061: End If;
1062: If (p_rec.rt_frz_los_flag = hr_api.g_varchar2) then
1063: p_rec.rt_frz_los_flag :=
1064: ben_pep_shd.g_old_rec.rt_frz_los_flag;
1060: ben_pep_shd.g_old_rec.rt_pct_fl_tm_val;
1061: End If;
1062: If (p_rec.rt_frz_los_flag = hr_api.g_varchar2) then
1063: p_rec.rt_frz_los_flag :=
1064: ben_pep_shd.g_old_rec.rt_frz_los_flag;
1065: End If;
1066: If (p_rec.rt_frz_age_flag = hr_api.g_varchar2) then
1067: p_rec.rt_frz_age_flag :=
1068: ben_pep_shd.g_old_rec.rt_frz_age_flag;
1064: ben_pep_shd.g_old_rec.rt_frz_los_flag;
1065: End If;
1066: If (p_rec.rt_frz_age_flag = hr_api.g_varchar2) then
1067: p_rec.rt_frz_age_flag :=
1068: ben_pep_shd.g_old_rec.rt_frz_age_flag;
1069: End If;
1070: If (p_rec.rt_frz_cmp_lvl_flag = hr_api.g_varchar2) then
1071: p_rec.rt_frz_cmp_lvl_flag :=
1072: ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag;
1068: ben_pep_shd.g_old_rec.rt_frz_age_flag;
1069: End If;
1070: If (p_rec.rt_frz_cmp_lvl_flag = hr_api.g_varchar2) then
1071: p_rec.rt_frz_cmp_lvl_flag :=
1072: ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag;
1073: End If;
1074: If (p_rec.rt_frz_pct_fl_tm_flag = hr_api.g_varchar2) then
1075: p_rec.rt_frz_pct_fl_tm_flag :=
1076: ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
1072: ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag;
1073: End If;
1074: If (p_rec.rt_frz_pct_fl_tm_flag = hr_api.g_varchar2) then
1075: p_rec.rt_frz_pct_fl_tm_flag :=
1076: ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
1077: End If;
1078: If (p_rec.rt_frz_hrs_wkd_flag = hr_api.g_varchar2) then
1079: p_rec.rt_frz_hrs_wkd_flag :=
1080: ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag;
1076: ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
1077: End If;
1078: If (p_rec.rt_frz_hrs_wkd_flag = hr_api.g_varchar2) then
1079: p_rec.rt_frz_hrs_wkd_flag :=
1080: ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag;
1081: End If;
1082: If (p_rec.rt_frz_comb_age_and_los_flag = hr_api.g_varchar2) then
1083: p_rec.rt_frz_comb_age_and_los_flag :=
1084: ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
1080: ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag;
1081: End If;
1082: If (p_rec.rt_frz_comb_age_and_los_flag = hr_api.g_varchar2) then
1083: p_rec.rt_frz_comb_age_and_los_flag :=
1084: ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
1085: End If;
1086: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then
1087: p_rec.once_r_cntug_cd :=
1088: ben_pep_shd.g_old_rec.once_r_cntug_cd;
1084: ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
1085: End If;
1086: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then
1087: p_rec.once_r_cntug_cd :=
1088: ben_pep_shd.g_old_rec.once_r_cntug_cd;
1089: End If;
1090: If (p_rec.pl_ordr_num = hr_api.g_number) then
1091: p_rec.pl_ordr_num :=
1092: ben_pep_shd.g_old_rec.pl_ordr_num;
1088: ben_pep_shd.g_old_rec.once_r_cntug_cd;
1089: End If;
1090: If (p_rec.pl_ordr_num = hr_api.g_number) then
1091: p_rec.pl_ordr_num :=
1092: ben_pep_shd.g_old_rec.pl_ordr_num;
1093: End If;
1094: If (p_rec.plip_ordr_num = hr_api.g_number) then
1095: p_rec.plip_ordr_num :=
1096: ben_pep_shd.g_old_rec.plip_ordr_num;
1092: ben_pep_shd.g_old_rec.pl_ordr_num;
1093: End If;
1094: If (p_rec.plip_ordr_num = hr_api.g_number) then
1095: p_rec.plip_ordr_num :=
1096: ben_pep_shd.g_old_rec.plip_ordr_num;
1097: End If;
1098: If (p_rec.ptip_ordr_num = hr_api.g_number) then
1099: p_rec.ptip_ordr_num :=
1100: ben_pep_shd.g_old_rec.ptip_ordr_num;
1096: ben_pep_shd.g_old_rec.plip_ordr_num;
1097: End If;
1098: If (p_rec.ptip_ordr_num = hr_api.g_number) then
1099: p_rec.ptip_ordr_num :=
1100: ben_pep_shd.g_old_rec.ptip_ordr_num;
1101: End If;
1102: If (p_rec.pep_attribute_category = hr_api.g_varchar2) then
1103: p_rec.pep_attribute_category :=
1104: ben_pep_shd.g_old_rec.pep_attribute_category;
1100: ben_pep_shd.g_old_rec.ptip_ordr_num;
1101: End If;
1102: If (p_rec.pep_attribute_category = hr_api.g_varchar2) then
1103: p_rec.pep_attribute_category :=
1104: ben_pep_shd.g_old_rec.pep_attribute_category;
1105: End If;
1106: If (p_rec.pep_attribute1 = hr_api.g_varchar2) then
1107: p_rec.pep_attribute1 :=
1108: ben_pep_shd.g_old_rec.pep_attribute1;
1104: ben_pep_shd.g_old_rec.pep_attribute_category;
1105: End If;
1106: If (p_rec.pep_attribute1 = hr_api.g_varchar2) then
1107: p_rec.pep_attribute1 :=
1108: ben_pep_shd.g_old_rec.pep_attribute1;
1109: End If;
1110: If (p_rec.pep_attribute2 = hr_api.g_varchar2) then
1111: p_rec.pep_attribute2 :=
1112: ben_pep_shd.g_old_rec.pep_attribute2;
1108: ben_pep_shd.g_old_rec.pep_attribute1;
1109: End If;
1110: If (p_rec.pep_attribute2 = hr_api.g_varchar2) then
1111: p_rec.pep_attribute2 :=
1112: ben_pep_shd.g_old_rec.pep_attribute2;
1113: End If;
1114: If (p_rec.pep_attribute3 = hr_api.g_varchar2) then
1115: p_rec.pep_attribute3 :=
1116: ben_pep_shd.g_old_rec.pep_attribute3;
1112: ben_pep_shd.g_old_rec.pep_attribute2;
1113: End If;
1114: If (p_rec.pep_attribute3 = hr_api.g_varchar2) then
1115: p_rec.pep_attribute3 :=
1116: ben_pep_shd.g_old_rec.pep_attribute3;
1117: End If;
1118: If (p_rec.pep_attribute4 = hr_api.g_varchar2) then
1119: p_rec.pep_attribute4 :=
1120: ben_pep_shd.g_old_rec.pep_attribute4;
1116: ben_pep_shd.g_old_rec.pep_attribute3;
1117: End If;
1118: If (p_rec.pep_attribute4 = hr_api.g_varchar2) then
1119: p_rec.pep_attribute4 :=
1120: ben_pep_shd.g_old_rec.pep_attribute4;
1121: End If;
1122: If (p_rec.pep_attribute5 = hr_api.g_varchar2) then
1123: p_rec.pep_attribute5 :=
1124: ben_pep_shd.g_old_rec.pep_attribute5;
1120: ben_pep_shd.g_old_rec.pep_attribute4;
1121: End If;
1122: If (p_rec.pep_attribute5 = hr_api.g_varchar2) then
1123: p_rec.pep_attribute5 :=
1124: ben_pep_shd.g_old_rec.pep_attribute5;
1125: End If;
1126: If (p_rec.pep_attribute6 = hr_api.g_varchar2) then
1127: p_rec.pep_attribute6 :=
1128: ben_pep_shd.g_old_rec.pep_attribute6;
1124: ben_pep_shd.g_old_rec.pep_attribute5;
1125: End If;
1126: If (p_rec.pep_attribute6 = hr_api.g_varchar2) then
1127: p_rec.pep_attribute6 :=
1128: ben_pep_shd.g_old_rec.pep_attribute6;
1129: End If;
1130: If (p_rec.pep_attribute7 = hr_api.g_varchar2) then
1131: p_rec.pep_attribute7 :=
1132: ben_pep_shd.g_old_rec.pep_attribute7;
1128: ben_pep_shd.g_old_rec.pep_attribute6;
1129: End If;
1130: If (p_rec.pep_attribute7 = hr_api.g_varchar2) then
1131: p_rec.pep_attribute7 :=
1132: ben_pep_shd.g_old_rec.pep_attribute7;
1133: End If;
1134: If (p_rec.pep_attribute8 = hr_api.g_varchar2) then
1135: p_rec.pep_attribute8 :=
1136: ben_pep_shd.g_old_rec.pep_attribute8;
1132: ben_pep_shd.g_old_rec.pep_attribute7;
1133: End If;
1134: If (p_rec.pep_attribute8 = hr_api.g_varchar2) then
1135: p_rec.pep_attribute8 :=
1136: ben_pep_shd.g_old_rec.pep_attribute8;
1137: End If;
1138: If (p_rec.pep_attribute9 = hr_api.g_varchar2) then
1139: p_rec.pep_attribute9 :=
1140: ben_pep_shd.g_old_rec.pep_attribute9;
1136: ben_pep_shd.g_old_rec.pep_attribute8;
1137: End If;
1138: If (p_rec.pep_attribute9 = hr_api.g_varchar2) then
1139: p_rec.pep_attribute9 :=
1140: ben_pep_shd.g_old_rec.pep_attribute9;
1141: End If;
1142: If (p_rec.pep_attribute10 = hr_api.g_varchar2) then
1143: p_rec.pep_attribute10 :=
1144: ben_pep_shd.g_old_rec.pep_attribute10;
1140: ben_pep_shd.g_old_rec.pep_attribute9;
1141: End If;
1142: If (p_rec.pep_attribute10 = hr_api.g_varchar2) then
1143: p_rec.pep_attribute10 :=
1144: ben_pep_shd.g_old_rec.pep_attribute10;
1145: End If;
1146: If (p_rec.pep_attribute11 = hr_api.g_varchar2) then
1147: p_rec.pep_attribute11 :=
1148: ben_pep_shd.g_old_rec.pep_attribute11;
1144: ben_pep_shd.g_old_rec.pep_attribute10;
1145: End If;
1146: If (p_rec.pep_attribute11 = hr_api.g_varchar2) then
1147: p_rec.pep_attribute11 :=
1148: ben_pep_shd.g_old_rec.pep_attribute11;
1149: End If;
1150: If (p_rec.pep_attribute12 = hr_api.g_varchar2) then
1151: p_rec.pep_attribute12 :=
1152: ben_pep_shd.g_old_rec.pep_attribute12;
1148: ben_pep_shd.g_old_rec.pep_attribute11;
1149: End If;
1150: If (p_rec.pep_attribute12 = hr_api.g_varchar2) then
1151: p_rec.pep_attribute12 :=
1152: ben_pep_shd.g_old_rec.pep_attribute12;
1153: End If;
1154: If (p_rec.pep_attribute13 = hr_api.g_varchar2) then
1155: p_rec.pep_attribute13 :=
1156: ben_pep_shd.g_old_rec.pep_attribute13;
1152: ben_pep_shd.g_old_rec.pep_attribute12;
1153: End If;
1154: If (p_rec.pep_attribute13 = hr_api.g_varchar2) then
1155: p_rec.pep_attribute13 :=
1156: ben_pep_shd.g_old_rec.pep_attribute13;
1157: End If;
1158: If (p_rec.pep_attribute14 = hr_api.g_varchar2) then
1159: p_rec.pep_attribute14 :=
1160: ben_pep_shd.g_old_rec.pep_attribute14;
1156: ben_pep_shd.g_old_rec.pep_attribute13;
1157: End If;
1158: If (p_rec.pep_attribute14 = hr_api.g_varchar2) then
1159: p_rec.pep_attribute14 :=
1160: ben_pep_shd.g_old_rec.pep_attribute14;
1161: End If;
1162: If (p_rec.pep_attribute15 = hr_api.g_varchar2) then
1163: p_rec.pep_attribute15 :=
1164: ben_pep_shd.g_old_rec.pep_attribute15;
1160: ben_pep_shd.g_old_rec.pep_attribute14;
1161: End If;
1162: If (p_rec.pep_attribute15 = hr_api.g_varchar2) then
1163: p_rec.pep_attribute15 :=
1164: ben_pep_shd.g_old_rec.pep_attribute15;
1165: End If;
1166: If (p_rec.pep_attribute16 = hr_api.g_varchar2) then
1167: p_rec.pep_attribute16 :=
1168: ben_pep_shd.g_old_rec.pep_attribute16;
1164: ben_pep_shd.g_old_rec.pep_attribute15;
1165: End If;
1166: If (p_rec.pep_attribute16 = hr_api.g_varchar2) then
1167: p_rec.pep_attribute16 :=
1168: ben_pep_shd.g_old_rec.pep_attribute16;
1169: End If;
1170: If (p_rec.pep_attribute17 = hr_api.g_varchar2) then
1171: p_rec.pep_attribute17 :=
1172: ben_pep_shd.g_old_rec.pep_attribute17;
1168: ben_pep_shd.g_old_rec.pep_attribute16;
1169: End If;
1170: If (p_rec.pep_attribute17 = hr_api.g_varchar2) then
1171: p_rec.pep_attribute17 :=
1172: ben_pep_shd.g_old_rec.pep_attribute17;
1173: End If;
1174: If (p_rec.pep_attribute18 = hr_api.g_varchar2) then
1175: p_rec.pep_attribute18 :=
1176: ben_pep_shd.g_old_rec.pep_attribute18;
1172: ben_pep_shd.g_old_rec.pep_attribute17;
1173: End If;
1174: If (p_rec.pep_attribute18 = hr_api.g_varchar2) then
1175: p_rec.pep_attribute18 :=
1176: ben_pep_shd.g_old_rec.pep_attribute18;
1177: End If;
1178: If (p_rec.pep_attribute19 = hr_api.g_varchar2) then
1179: p_rec.pep_attribute19 :=
1180: ben_pep_shd.g_old_rec.pep_attribute19;
1176: ben_pep_shd.g_old_rec.pep_attribute18;
1177: End If;
1178: If (p_rec.pep_attribute19 = hr_api.g_varchar2) then
1179: p_rec.pep_attribute19 :=
1180: ben_pep_shd.g_old_rec.pep_attribute19;
1181: End If;
1182: If (p_rec.pep_attribute20 = hr_api.g_varchar2) then
1183: p_rec.pep_attribute20 :=
1184: ben_pep_shd.g_old_rec.pep_attribute20;
1180: ben_pep_shd.g_old_rec.pep_attribute19;
1181: End If;
1182: If (p_rec.pep_attribute20 = hr_api.g_varchar2) then
1183: p_rec.pep_attribute20 :=
1184: ben_pep_shd.g_old_rec.pep_attribute20;
1185: End If;
1186: If (p_rec.pep_attribute21 = hr_api.g_varchar2) then
1187: p_rec.pep_attribute21 :=
1188: ben_pep_shd.g_old_rec.pep_attribute21;
1184: ben_pep_shd.g_old_rec.pep_attribute20;
1185: End If;
1186: If (p_rec.pep_attribute21 = hr_api.g_varchar2) then
1187: p_rec.pep_attribute21 :=
1188: ben_pep_shd.g_old_rec.pep_attribute21;
1189: End If;
1190: If (p_rec.pep_attribute22 = hr_api.g_varchar2) then
1191: p_rec.pep_attribute22 :=
1192: ben_pep_shd.g_old_rec.pep_attribute22;
1188: ben_pep_shd.g_old_rec.pep_attribute21;
1189: End If;
1190: If (p_rec.pep_attribute22 = hr_api.g_varchar2) then
1191: p_rec.pep_attribute22 :=
1192: ben_pep_shd.g_old_rec.pep_attribute22;
1193: End If;
1194: If (p_rec.pep_attribute23 = hr_api.g_varchar2) then
1195: p_rec.pep_attribute23 :=
1196: ben_pep_shd.g_old_rec.pep_attribute23;
1192: ben_pep_shd.g_old_rec.pep_attribute22;
1193: End If;
1194: If (p_rec.pep_attribute23 = hr_api.g_varchar2) then
1195: p_rec.pep_attribute23 :=
1196: ben_pep_shd.g_old_rec.pep_attribute23;
1197: End If;
1198: If (p_rec.pep_attribute24 = hr_api.g_varchar2) then
1199: p_rec.pep_attribute24 :=
1200: ben_pep_shd.g_old_rec.pep_attribute24;
1196: ben_pep_shd.g_old_rec.pep_attribute23;
1197: End If;
1198: If (p_rec.pep_attribute24 = hr_api.g_varchar2) then
1199: p_rec.pep_attribute24 :=
1200: ben_pep_shd.g_old_rec.pep_attribute24;
1201: End If;
1202: If (p_rec.pep_attribute25 = hr_api.g_varchar2) then
1203: p_rec.pep_attribute25 :=
1204: ben_pep_shd.g_old_rec.pep_attribute25;
1200: ben_pep_shd.g_old_rec.pep_attribute24;
1201: End If;
1202: If (p_rec.pep_attribute25 = hr_api.g_varchar2) then
1203: p_rec.pep_attribute25 :=
1204: ben_pep_shd.g_old_rec.pep_attribute25;
1205: End If;
1206: If (p_rec.pep_attribute26 = hr_api.g_varchar2) then
1207: p_rec.pep_attribute26 :=
1208: ben_pep_shd.g_old_rec.pep_attribute26;
1204: ben_pep_shd.g_old_rec.pep_attribute25;
1205: End If;
1206: If (p_rec.pep_attribute26 = hr_api.g_varchar2) then
1207: p_rec.pep_attribute26 :=
1208: ben_pep_shd.g_old_rec.pep_attribute26;
1209: End If;
1210: If (p_rec.pep_attribute27 = hr_api.g_varchar2) then
1211: p_rec.pep_attribute27 :=
1212: ben_pep_shd.g_old_rec.pep_attribute27;
1208: ben_pep_shd.g_old_rec.pep_attribute26;
1209: End If;
1210: If (p_rec.pep_attribute27 = hr_api.g_varchar2) then
1211: p_rec.pep_attribute27 :=
1212: ben_pep_shd.g_old_rec.pep_attribute27;
1213: End If;
1214: If (p_rec.pep_attribute28 = hr_api.g_varchar2) then
1215: p_rec.pep_attribute28 :=
1216: ben_pep_shd.g_old_rec.pep_attribute28;
1212: ben_pep_shd.g_old_rec.pep_attribute27;
1213: End If;
1214: If (p_rec.pep_attribute28 = hr_api.g_varchar2) then
1215: p_rec.pep_attribute28 :=
1216: ben_pep_shd.g_old_rec.pep_attribute28;
1217: End If;
1218: If (p_rec.pep_attribute29 = hr_api.g_varchar2) then
1219: p_rec.pep_attribute29 :=
1220: ben_pep_shd.g_old_rec.pep_attribute29;
1216: ben_pep_shd.g_old_rec.pep_attribute28;
1217: End If;
1218: If (p_rec.pep_attribute29 = hr_api.g_varchar2) then
1219: p_rec.pep_attribute29 :=
1220: ben_pep_shd.g_old_rec.pep_attribute29;
1221: End If;
1222: If (p_rec.pep_attribute30 = hr_api.g_varchar2) then
1223: p_rec.pep_attribute30 :=
1224: ben_pep_shd.g_old_rec.pep_attribute30;
1220: ben_pep_shd.g_old_rec.pep_attribute29;
1221: End If;
1222: If (p_rec.pep_attribute30 = hr_api.g_varchar2) then
1223: p_rec.pep_attribute30 :=
1224: ben_pep_shd.g_old_rec.pep_attribute30;
1225: End If;
1226: If (p_rec.request_id = hr_api.g_number) then
1227: p_rec.request_id :=
1228: ben_pep_shd.g_old_rec.request_id;
1224: ben_pep_shd.g_old_rec.pep_attribute30;
1225: End If;
1226: If (p_rec.request_id = hr_api.g_number) then
1227: p_rec.request_id :=
1228: ben_pep_shd.g_old_rec.request_id;
1229: End If;
1230: If (p_rec.program_application_id = hr_api.g_number) then
1231: p_rec.program_application_id :=
1232: ben_pep_shd.g_old_rec.program_application_id;
1228: ben_pep_shd.g_old_rec.request_id;
1229: End If;
1230: If (p_rec.program_application_id = hr_api.g_number) then
1231: p_rec.program_application_id :=
1232: ben_pep_shd.g_old_rec.program_application_id;
1233: End If;
1234: If (p_rec.program_id = hr_api.g_number) then
1235: p_rec.program_id :=
1236: ben_pep_shd.g_old_rec.program_id;
1232: ben_pep_shd.g_old_rec.program_application_id;
1233: End If;
1234: If (p_rec.program_id = hr_api.g_number) then
1235: p_rec.program_id :=
1236: ben_pep_shd.g_old_rec.program_id;
1237: End If;
1238: If (p_rec.program_update_date = hr_api.g_date) then
1239: p_rec.program_update_date :=
1240: ben_pep_shd.g_old_rec.program_update_date;
1236: ben_pep_shd.g_old_rec.program_id;
1237: End If;
1238: If (p_rec.program_update_date = hr_api.g_date) then
1239: p_rec.program_update_date :=
1240: ben_pep_shd.g_old_rec.program_update_date;
1241: End If;
1242: --
1243: hr_utility.set_location(' Leaving:'||l_proc, 10);
1244: --
1384: --
1385: -- We must select and lock the current row.
1386: --
1387: Open C_Sel1;
1388: Fetch C_Sel1 Into ben_pep_shd.g_old_rec;
1389: If C_Sel1%notfound then
1390: Close C_Sel1;
1391: --
1392: -- The primary key is invalid therefore we must error
1394: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1395: fnd_message.raise_error;
1396: End If;
1397: Close C_Sel1;
1398: If (p_object_version_number <> ben_pep_shd.g_old_rec.object_version_number)
1399: then
1400: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
1401: fnd_message.raise_error;
1402: End If;
1569: -- Declare cursors and local variables
1570: --
1571: l_proc varchar2(72) := g_package||'update_perf_Eligible_Person';
1572: --
1573: l_rec ben_pep_shd.g_rec_type;
1574: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
1575: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
1576: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1577: --
1708: t.creation_date
1709: from ben_elig_per_f t
1710: where t.elig_per_id = p_elig_per_id
1711: and t.effective_start_date =
1712: ben_pep_shd.g_old_rec.effective_start_date
1713: and t.effective_end_date = (l_validation_start_date - 1);
1714: --
1715: cursor c_effdates
1716: (c_eff_date date
2014: -- Process Logic
2015: --
2016: l_object_version_number := p_object_version_number;
2017: l_rec :=
2018: ben_pep_shd.convert_args
2019: (
2020: p_elig_per_id,
2021: null,
2022: null,
2128: --
2129: -- We must select and lock the current row.
2130: --
2131: Open c_old_rec;
2132: Fetch c_old_rec Into ben_pep_shd.g_old_rec;
2133: If c_old_rec%notfound then
2134: Close c_old_rec;
2135: --
2136: -- The primary key is invalid therefore we must error
2138: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
2139: fnd_message.raise_error;
2140: End If;
2141: Close c_old_rec;
2142: If (p_object_version_number <> ben_pep_shd.g_old_rec.object_version_number) Then
2143: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
2144: fnd_message.raise_error;
2145: End If;
2146: hr_utility.set_location(l_proc, 15);
2177: --compare values to decide whether to update or not
2178: --Bug 12964414 assigning the old and new ler_id's to l_old_ler_id and l_new_ler_id
2179: if l_old_ler_id is null and l_new_ler_id is null and
2180: ben_manage_life_events.g_modified_mode in ('S','U') then
2181: l_old_ler_id := nvl(ben_pep_shd.g_old_rec.ler_id,-1);
2182: l_new_ler_id := nvl(l_rec.ler_id,-1);
2183: end if;
2184: --Bug 12964414
2185: --
2185: --
2186:
2187: if
2188: --
2189: nvl(ben_pep_shd.g_old_rec.pl_id,-1) <> nvl(l_rec.pl_id,-1) or
2190: nvl(ben_pep_shd.g_old_rec.pgm_id,-1) <> nvl(l_rec.pgm_id,-1) or
2191: nvl(ben_pep_shd.g_old_rec.plip_id,-1) <> nvl(l_rec.plip_id,-1) or
2192: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2193: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2186:
2187: if
2188: --
2189: nvl(ben_pep_shd.g_old_rec.pl_id,-1) <> nvl(l_rec.pl_id,-1) or
2190: nvl(ben_pep_shd.g_old_rec.pgm_id,-1) <> nvl(l_rec.pgm_id,-1) or
2191: nvl(ben_pep_shd.g_old_rec.plip_id,-1) <> nvl(l_rec.plip_id,-1) or
2192: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2193: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2194: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2187: if
2188: --
2189: nvl(ben_pep_shd.g_old_rec.pl_id,-1) <> nvl(l_rec.pl_id,-1) or
2190: nvl(ben_pep_shd.g_old_rec.pgm_id,-1) <> nvl(l_rec.pgm_id,-1) or
2191: nvl(ben_pep_shd.g_old_rec.plip_id,-1) <> nvl(l_rec.plip_id,-1) or
2192: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2193: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2194: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2195: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2188: --
2189: nvl(ben_pep_shd.g_old_rec.pl_id,-1) <> nvl(l_rec.pl_id,-1) or
2190: nvl(ben_pep_shd.g_old_rec.pgm_id,-1) <> nvl(l_rec.pgm_id,-1) or
2191: nvl(ben_pep_shd.g_old_rec.plip_id,-1) <> nvl(l_rec.plip_id,-1) or
2192: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2193: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2194: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2195: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2196: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2189: nvl(ben_pep_shd.g_old_rec.pl_id,-1) <> nvl(l_rec.pl_id,-1) or
2190: nvl(ben_pep_shd.g_old_rec.pgm_id,-1) <> nvl(l_rec.pgm_id,-1) or
2191: nvl(ben_pep_shd.g_old_rec.plip_id,-1) <> nvl(l_rec.plip_id,-1) or
2192: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2193: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2194: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2195: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2196: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2197: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2190: nvl(ben_pep_shd.g_old_rec.pgm_id,-1) <> nvl(l_rec.pgm_id,-1) or
2191: nvl(ben_pep_shd.g_old_rec.plip_id,-1) <> nvl(l_rec.plip_id,-1) or
2192: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2193: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2194: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2195: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2196: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2197: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2198: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2192: nvl(ben_pep_shd.g_old_rec.ptip_id,-1) <> nvl(l_rec.ptip_id,-1) or
2193: nvl(ben_pep_shd.g_old_rec.ler_id,-1) <> nvl(l_rec.ler_id,-1) or
2194: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2195: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2196: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2197: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2198: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2194: nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,'N') <>
2195: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2196: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2197: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2198: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2202: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2195: nvl(l_rec.dpnt_othr_pl_cvrd_rl_flag,'N') or
2196: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2197: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2198: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2202: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2203: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2196: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
2197: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2198: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2202: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2203: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2204: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2197: nvl(l_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2198: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2202: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2203: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2204: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2205: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2198: nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag,'N')<> nvl(l_rec.pl_key_ee_flag,'N') or
2199: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2202: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2203: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2204: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2205: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2206: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2199: nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,'N') <> nvl(l_rec.pl_hghly_compd_flag,'N') or
2200: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2202: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2203: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2204: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2205: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2206: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2207: nvl(l_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2200: nvl(ben_pep_shd.g_old_rec.elig_flag,'N') <> nvl(l_rec.elig_flag,'N') or
2201: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2202: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2203: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2204: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2205: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2206: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2207: nvl(l_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2208: nvl(ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2201: nvl(ben_pep_shd.g_old_rec.comp_ref_amt,-1) <> nvl(l_rec.comp_ref_amt,-1) or
2202: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2203: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2204: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2205: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2206: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2207: nvl(l_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2208: nvl(ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2209: nvl(l_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2202: nvl(ben_pep_shd.g_old_rec.cmbn_age_n_los_val, -1) <> nvl(l_rec.cmbn_age_n_los_val, -1) or
2203: nvl(ben_pep_shd.g_old_rec.comp_ref_uom,'X') <> nvl(l_rec.comp_ref_uom,'X') or
2204: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2205: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2206: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2207: nvl(l_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2208: nvl(ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2209: nvl(l_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2210: nvl(ben_pep_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2204: nvl(ben_pep_shd.g_old_rec.age_val, -1) <> nvl(l_rec.age_val, -1) or
2205: nvl(ben_pep_shd.g_old_rec.los_val, -1) <> nvl(l_rec.los_val, -1) or
2206: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2207: nvl(l_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2208: nvl(ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2209: nvl(l_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2210: nvl(ben_pep_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2211: nvl(l_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2212: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2206: nvl(ben_pep_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2207: nvl(l_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2208: nvl(ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2209: nvl(l_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2210: nvl(ben_pep_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2211: nvl(l_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2212: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2213: nvl(ben_pep_shd.g_old_rec.hrs_wkd_val,-1) <> nvl(l_rec.hrs_wkd_val,-1) or
2214: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2208: nvl(ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2209: nvl(l_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2210: nvl(ben_pep_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2211: nvl(l_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2212: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2213: nvl(ben_pep_shd.g_old_rec.hrs_wkd_val,-1) <> nvl(l_rec.hrs_wkd_val,-1) or
2214: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2215: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_flag,'N') <> nvl(l_rec.prtn_ovridn_flag,'N') or
2216: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2209: nvl(l_rec.wait_perd_cmpltn_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2210: nvl(ben_pep_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2211: nvl(l_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2212: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2213: nvl(ben_pep_shd.g_old_rec.hrs_wkd_val,-1) <> nvl(l_rec.hrs_wkd_val,-1) or
2214: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2215: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_flag,'N') <> nvl(l_rec.prtn_ovridn_flag,'N') or
2216: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2217: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2210: nvl(ben_pep_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2211: nvl(l_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2212: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2213: nvl(ben_pep_shd.g_old_rec.hrs_wkd_val,-1) <> nvl(l_rec.hrs_wkd_val,-1) or
2214: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2215: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_flag,'N') <> nvl(l_rec.prtn_ovridn_flag,'N') or
2216: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2217: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2211: nvl(l_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2212: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2213: nvl(ben_pep_shd.g_old_rec.hrs_wkd_val,-1) <> nvl(l_rec.hrs_wkd_val,-1) or
2214: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2215: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_flag,'N') <> nvl(l_rec.prtn_ovridn_flag,'N') or
2216: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2217: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2219: nvl(l_rec.prtn_ovridn_rsn_cd, 'X') or
2212: nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,'X') <> nvl(l_rec.wv_ctfn_typ_cd,'X') or
2213: nvl(ben_pep_shd.g_old_rec.hrs_wkd_val,-1) <> nvl(l_rec.hrs_wkd_val,-1) or
2214: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2215: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_flag,'N') <> nvl(l_rec.prtn_ovridn_flag,'N') or
2216: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2217: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2219: nvl(l_rec.prtn_ovridn_rsn_cd, 'X') or
2220: nvl(ben_pep_shd.g_old_rec.age_uom,'X') <> nvl(l_rec.age_uom,'X') or
2214: nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(l_rec.hrs_wkd_bndry_perd_cd,'X') or
2215: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_flag,'N') <> nvl(l_rec.prtn_ovridn_flag,'N') or
2216: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2217: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2219: nvl(l_rec.prtn_ovridn_rsn_cd, 'X') or
2220: nvl(ben_pep_shd.g_old_rec.age_uom,'X') <> nvl(l_rec.age_uom,'X') or
2221: nvl(ben_pep_shd.g_old_rec.los_uom,'X') <> nvl(l_rec.los_uom,'X') or
2222: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2216: nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
2217: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2219: nvl(l_rec.prtn_ovridn_rsn_cd, 'X') or
2220: nvl(ben_pep_shd.g_old_rec.age_uom,'X') <> nvl(l_rec.age_uom,'X') or
2221: nvl(ben_pep_shd.g_old_rec.los_uom,'X') <> nvl(l_rec.los_uom,'X') or
2222: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2223: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2224: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2217: nvl(l_rec.no_mx_prtn_ovrid_thru_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2219: nvl(l_rec.prtn_ovridn_rsn_cd, 'X') or
2220: nvl(ben_pep_shd.g_old_rec.age_uom,'X') <> nvl(l_rec.age_uom,'X') or
2221: nvl(ben_pep_shd.g_old_rec.los_uom,'X') <> nvl(l_rec.los_uom,'X') or
2222: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2223: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2224: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2225: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2218: nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') <>
2219: nvl(l_rec.prtn_ovridn_rsn_cd, 'X') or
2220: nvl(ben_pep_shd.g_old_rec.age_uom,'X') <> nvl(l_rec.age_uom,'X') or
2221: nvl(ben_pep_shd.g_old_rec.los_uom,'X') <> nvl(l_rec.los_uom,'X') or
2222: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2223: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2224: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2225: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2226: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2220: nvl(ben_pep_shd.g_old_rec.age_uom,'X') <> nvl(l_rec.age_uom,'X') or
2221: nvl(ben_pep_shd.g_old_rec.los_uom,'X') <> nvl(l_rec.los_uom,'X') or
2222: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2223: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2224: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2225: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2226: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2227: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2228: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2221: nvl(ben_pep_shd.g_old_rec.los_uom,'X') <> nvl(l_rec.los_uom,'X') or
2222: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2223: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2224: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2225: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2226: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2227: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2228: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2229: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2222: nvl(ben_pep_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
2223: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2224: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2225: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2226: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2227: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2228: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2229: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2230: 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
2223: nvl(l_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
2224: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2225: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2226: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2227: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2228: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2229: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2230: 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
2231: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2224: nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,'X') <> nvl(l_rec.inelg_rsn_cd,'X') or
2225: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2226: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2227: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2228: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2229: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2230: 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
2231: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2232: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2225: nvl(ben_pep_shd.g_old_rec.frz_los_flag,'N') <> nvl(l_rec.frz_los_flag,'N') or
2226: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2227: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2228: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2229: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2230: 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
2231: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2232: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2233: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2226: nvl(ben_pep_shd.g_old_rec.frz_age_flag,'N') <> nvl(l_rec.frz_age_flag,'N') or
2227: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2228: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2229: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2230: 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
2231: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2232: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2233: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2234: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2227: nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,'N') <> nvl(l_rec.frz_cmp_lvl_flag,'N') or
2228: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2229: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2230: 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
2231: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2232: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2233: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2234: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2235: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2228: nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,'N') <> nvl(l_rec.frz_pct_fl_tm_flag,'N') or
2229: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2230: 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
2231: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2232: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2233: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2234: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2235: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2236: 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
2229: nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,'N') <> nvl(l_rec.frz_hrs_wkd_flag,'N') or
2230: 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
2231: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2232: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2233: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2234: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2235: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2236: 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
2237: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2230: 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
2231: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2232: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2233: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2234: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2235: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2236: 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
2237: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2238: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2231: nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,'N') <> nvl(l_rec.dstr_rstcn_flag,'N') or
2232: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2233: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2234: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2235: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2236: 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
2237: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2238: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2239: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2232: nvl(ben_pep_shd.g_old_rec.pct_fl_tm_val,-1) <> nvl(l_rec.pct_fl_tm_val,-1) or
2233: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2234: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2235: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2236: 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
2237: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2238: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2239: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2240: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2233: nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,'X') <> nvl(l_rec.wv_prtn_rsn_cd,'X') or
2234: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2235: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2236: 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
2237: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2238: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2239: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2240: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2241: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2234: nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,'N') <> nvl(l_rec.pl_wvd_flag,'N') or
2235: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2236: 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
2237: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2238: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2239: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2240: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2241: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2242: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2235: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_amt,-1) <> nvl(l_rec.rt_comp_ref_amt,-1) or
2236: 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
2237: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2238: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2239: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2240: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2241: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2242: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2243: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2236: 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
2237: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2238: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2239: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2240: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2241: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2242: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2243: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2244: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2237: nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,'X') <> nvl(l_rec.rt_comp_ref_uom,'X') or
2238: nvl(ben_pep_shd.g_old_rec.rt_age_val,-1) <> nvl(l_rec.rt_age_val,-1) or
2239: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2240: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2241: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2242: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2243: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2244: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2245: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2239: nvl(ben_pep_shd.g_old_rec.rt_los_val,-1) <> nvl(l_rec.rt_los_val,-1) or
2240: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2241: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2242: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2243: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2244: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2245: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2246: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2247: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2240: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_val,-1) <> nvl(l_rec.rt_hrs_wkd_val,-1) or
2241: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2242: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2243: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2244: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2245: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2246: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2247: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2248: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2241: nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
2242: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2243: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2244: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2245: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2246: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2247: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2248: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2249: 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
2242: nvl(l_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
2243: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2244: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2245: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2246: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2247: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2248: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2249: 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
2250: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2243: nvl(ben_pep_shd.g_old_rec.rt_age_uom,'X') <> nvl(l_rec.rt_age_uom,'X') or
2244: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2245: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2246: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2247: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2248: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2249: 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
2250: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2251: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2244: nvl(ben_pep_shd.g_old_rec.rt_los_uom,'X') <> nvl(l_rec.rt_los_uom,'X') or
2245: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2246: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2247: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2248: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2249: 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
2250: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2251: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2252: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2245: nvl(ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,-1) <> nvl(l_rec.rt_pct_fl_tm_val,-1) or
2246: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2247: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2248: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2249: 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
2250: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2251: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2252: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2253: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2246: nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,'N') <> nvl(l_rec.rt_frz_los_flag,'N') or
2247: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2248: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2249: 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
2250: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2251: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2252: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2253: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2254: nvl(ben_pep_shd.g_old_rec.pl_ordr_num,-1) <> nvl(l_rec.pl_ordr_num,-1) or
2247: nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,'N') <> nvl(l_rec.rt_frz_age_flag,'N') or
2248: nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(l_rec.rt_frz_cmp_lvl_flag,'N') or
2249: 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
2250: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2251: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2252: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2253: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2254: nvl(ben_pep_shd.g_old_rec.pl_ordr_num,-1) <> nvl(l_rec.pl_ordr_num,-1) or
2255: nvl(ben_pep_shd.g_old_rec.plip_ordr_num,-1) <> nvl(l_rec.plip_ordr_num,-1) or
2249: 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
2250: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2251: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2252: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2253: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2254: nvl(ben_pep_shd.g_old_rec.pl_ordr_num,-1) <> nvl(l_rec.pl_ordr_num,-1) or
2255: nvl(ben_pep_shd.g_old_rec.plip_ordr_num,-1) <> nvl(l_rec.plip_ordr_num,-1) or
2256: nvl(ben_pep_shd.g_old_rec.ptip_ordr_num,-1) <> nvl(l_rec.ptip_ordr_num,-1)
2257: then
2250: nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(l_rec.rt_frz_hrs_wkd_flag,'N') or
2251: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2252: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2253: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2254: nvl(ben_pep_shd.g_old_rec.pl_ordr_num,-1) <> nvl(l_rec.pl_ordr_num,-1) or
2255: nvl(ben_pep_shd.g_old_rec.plip_ordr_num,-1) <> nvl(l_rec.plip_ordr_num,-1) or
2256: nvl(ben_pep_shd.g_old_rec.ptip_ordr_num,-1) <> nvl(l_rec.ptip_ordr_num,-1)
2257: then
2258: -- do nothing
2251: nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') <>
2252: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2253: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2254: nvl(ben_pep_shd.g_old_rec.pl_ordr_num,-1) <> nvl(l_rec.pl_ordr_num,-1) or
2255: nvl(ben_pep_shd.g_old_rec.plip_ordr_num,-1) <> nvl(l_rec.plip_ordr_num,-1) or
2256: nvl(ben_pep_shd.g_old_rec.ptip_ordr_num,-1) <> nvl(l_rec.ptip_ordr_num,-1)
2257: then
2258: -- do nothing
2259: null;
2252: nvl(l_rec.rt_frz_comb_age_and_los_flag,'N') or
2253: nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,'X') <> nvl(l_rec.once_r_cntug_cd,'X') or
2254: nvl(ben_pep_shd.g_old_rec.pl_ordr_num,-1) <> nvl(l_rec.pl_ordr_num,-1) or
2255: nvl(ben_pep_shd.g_old_rec.plip_ordr_num,-1) <> nvl(l_rec.plip_ordr_num,-1) or
2256: nvl(ben_pep_shd.g_old_rec.ptip_ordr_num,-1) <> nvl(l_rec.ptip_ordr_num,-1)
2257: then
2258: -- do nothing
2259: null;
2260: --
2275: );
2276: fetch c_getovn into l_object_version_number;
2277: close c_getovn;
2278: --
2279: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2280: --
2281: -- Update the specified datetrack row setting the effective
2282: -- end date to the specified new effective end date.
2283: --
2287: where t.elig_per_id = p_elig_per_id
2288: and p_effective_date
2289: between t.effective_start_date and t.effective_end_date;
2290: --
2291: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2292: --
2293: If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
2294: hr_utility.set_location(l_proc, 15);
2295: --
2297: -- delete any future rows
2298: --
2299: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
2300: hr_utility.set_location(l_proc, 10);
2301: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2302: --
2303: -- Delete the where the effective start date is equal
2304: -- to the validation end date.
2305: --
2306: delete from ben_elig_per_f
2307: where elig_per_id = p_elig_per_id
2308: and effective_start_date = l_validation_start_date;
2309: --
2310: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2311: Else
2312: hr_utility.set_location(l_proc, 15);
2313: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2314: --
2309: --
2310: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2311: Else
2312: hr_utility.set_location(l_proc, 15);
2313: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2314: --
2315: -- Delete the row(s) where the effective start date is greater than
2316: -- or equal to the validation start date.
2317: --
2318: delete from ben_elig_per_f
2319: where elig_per_id = p_elig_per_id
2320: and effective_start_date >= l_validation_start_date;
2321: --
2322: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2323: End If;
2324: --
2325: End If;
2326: hr_utility.set_location(l_proc, 20);
2372: l_last_updated_by := fnd_global.user_id;
2373: l_last_update_login := fnd_global.login_id;
2374: End If;
2375: --
2376: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2377: --
2378: -- Insert the row into: ben_elig_per_f
2379: --
2380: hr_utility.set_location('Ins PEP:'||l_proc, 5);
2596: l_last_updated_by,
2597: l_last_update_login
2598: );
2599: --
2600: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2601: End If;
2602: --
2603: -- update_dml
2604: --
2613: );
2614: fetch c_getovn into l_rec.object_version_number;
2615: close c_getovn;
2616: --
2617: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2618: --
2619: -- Update the ben_elig_per_f Row
2620: --
2621: update ben_elig_per_f
2722: where elig_per_id = l_rec.elig_per_id
2723: and effective_start_date = l_validation_start_date
2724: and effective_end_date = l_validation_end_date;
2725: --
2726: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2727: --
2728: -- Set the effective start and end dates
2729: --
2730: l_rec.effective_start_date := l_validation_start_date;