[Home] [Help]
756: and (p_rates_old.ws_val is not null))
757: or (p_rates_old.ws_val <> l_rates_new.ws_val) ) then
758:
759: -- if(nvl(p_rates_old.ws_val,-1)<>nvl(l_rates_new.ws_val,-1)) then
760: if(ben_cwb_audit_api.return_lookup_validity('CA')=true) then
761: ben_cwb_audit_api.create_audit_entry
762: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
763: ,p_group_pl_id => l_rates_new.group_pl_id
764: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
757: or (p_rates_old.ws_val <> l_rates_new.ws_val) ) then
758:
759: -- if(nvl(p_rates_old.ws_val,-1)<>nvl(l_rates_new.ws_val,-1)) then
760: if(ben_cwb_audit_api.return_lookup_validity('CA')=true) then
761: ben_cwb_audit_api.create_audit_entry
762: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
763: ,p_group_pl_id => l_rates_new.group_pl_id
764: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
765: ,p_pl_id => l_rates_new.pl_id
779: and (l_rates_new.elig_sal_val is not null))
780: or ((l_rates_new.elig_sal_val is null)
781: and (p_rates_old.elig_sal_val is not null))
782: or (p_rates_old.elig_sal_val <> l_rates_new.elig_sal_val) ) then
783: if(ben_cwb_audit_api.return_lookup_validity('ES')=true) then
784: ben_cwb_audit_api.create_audit_entry
785: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
786: ,p_group_pl_id => l_rates_new.group_pl_id
787: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
780: or ((l_rates_new.elig_sal_val is null)
781: and (p_rates_old.elig_sal_val is not null))
782: or (p_rates_old.elig_sal_val <> l_rates_new.elig_sal_val) ) then
783: if(ben_cwb_audit_api.return_lookup_validity('ES')=true) then
784: ben_cwb_audit_api.create_audit_entry
785: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
786: ,p_group_pl_id => l_rates_new.group_pl_id
787: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
788: ,p_pl_id => l_rates_new.pl_id
801: and (l_rates_new.stat_sal_val is not null))
802: or ((l_rates_new.stat_sal_val is null)
803: and (p_rates_old.stat_sal_val is not null))
804: or (p_rates_old.stat_sal_val <> l_rates_new.stat_sal_val) ) then
805: if(ben_cwb_audit_api.return_lookup_validity('SS')=true) then
806: ben_cwb_audit_api.create_audit_entry
807: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
808: ,p_group_pl_id => l_rates_new.group_pl_id
809: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
802: or ((l_rates_new.stat_sal_val is null)
803: and (p_rates_old.stat_sal_val is not null))
804: or (p_rates_old.stat_sal_val <> l_rates_new.stat_sal_val) ) then
805: if(ben_cwb_audit_api.return_lookup_validity('SS')=true) then
806: ben_cwb_audit_api.create_audit_entry
807: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
808: ,p_group_pl_id => l_rates_new.group_pl_id
809: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
810: ,p_pl_id => l_rates_new.pl_id
823: and (l_rates_new.rec_val is not null))
824: or ((l_rates_new.rec_val is null)
825: and (p_rates_old.rec_val is not null))
826: or (p_rates_old.rec_val <> l_rates_new.rec_val) ) then
827: if(ben_cwb_audit_api.return_lookup_validity('RA')=true) then
828: ben_cwb_audit_api.create_audit_entry
829: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
830: ,p_group_pl_id => l_rates_new.group_pl_id
831: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
824: or ((l_rates_new.rec_val is null)
825: and (p_rates_old.rec_val is not null))
826: or (p_rates_old.rec_val <> l_rates_new.rec_val) ) then
827: if(ben_cwb_audit_api.return_lookup_validity('RA')=true) then
828: ben_cwb_audit_api.create_audit_entry
829: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
830: ,p_group_pl_id => l_rates_new.group_pl_id
831: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
832: ,p_pl_id => l_rates_new.pl_id
845: and (l_rates_new.tot_comp_val is not null))
846: or ((l_rates_new.tot_comp_val is null)
847: and (p_rates_old.tot_comp_val is not null))
848: or (p_rates_old.tot_comp_val <> l_rates_new.tot_comp_val) ) then
849: if(ben_cwb_audit_api.return_lookup_validity('TC')=true) then
850: ben_cwb_audit_api.create_audit_entry
851: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
852: ,p_group_pl_id => l_rates_new.group_pl_id
853: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
846: or ((l_rates_new.tot_comp_val is null)
847: and (p_rates_old.tot_comp_val is not null))
848: or (p_rates_old.tot_comp_val <> l_rates_new.tot_comp_val) ) then
849: if(ben_cwb_audit_api.return_lookup_validity('TC')=true) then
850: ben_cwb_audit_api.create_audit_entry
851: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
852: ,p_group_pl_id => l_rates_new.group_pl_id
853: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
854: ,p_pl_id => l_rates_new.pl_id
867: and (l_rates_new.oth_comp_val is not null))
868: or ((l_rates_new.oth_comp_val is null)
869: and (p_rates_old.oth_comp_val is not null))
870: or (p_rates_old.oth_comp_val <> l_rates_new.oth_comp_val) ) then
871: if(ben_cwb_audit_api.return_lookup_validity('OC')=true) then
872: ben_cwb_audit_api.create_audit_entry
873: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
874: ,p_group_pl_id => l_rates_new.group_pl_id
875: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
868: or ((l_rates_new.oth_comp_val is null)
869: and (p_rates_old.oth_comp_val is not null))
870: or (p_rates_old.oth_comp_val <> l_rates_new.oth_comp_val) ) then
871: if(ben_cwb_audit_api.return_lookup_validity('OC')=true) then
872: ben_cwb_audit_api.create_audit_entry
873: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
874: ,p_group_pl_id => l_rates_new.group_pl_id
875: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
876: ,p_pl_id => l_rates_new.pl_id
889: and (l_rates_new.misc1_val is not null))
890: or ((l_rates_new.misc1_val is null)
891: and (p_rates_old.misc1_val is not null))
892: or (p_rates_old.misc1_val <> l_rates_new.misc1_val) ) then
893: if(ben_cwb_audit_api.return_lookup_validity('M1')=true) then
894: ben_cwb_audit_api.create_audit_entry
895: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
896: ,p_group_pl_id => l_rates_new.group_pl_id
897: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
890: or ((l_rates_new.misc1_val is null)
891: and (p_rates_old.misc1_val is not null))
892: or (p_rates_old.misc1_val <> l_rates_new.misc1_val) ) then
893: if(ben_cwb_audit_api.return_lookup_validity('M1')=true) then
894: ben_cwb_audit_api.create_audit_entry
895: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
896: ,p_group_pl_id => l_rates_new.group_pl_id
897: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
898: ,p_pl_id => l_rates_new.pl_id
911: and (l_rates_new.misc2_val is not null))
912: or ((l_rates_new.misc2_val is null)
913: and (p_rates_old.misc2_val is not null))
914: or (p_rates_old.misc2_val <> l_rates_new.misc2_val) ) then
915: if(ben_cwb_audit_api.return_lookup_validity('M2')=true) then
916: ben_cwb_audit_api.create_audit_entry
917: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
918: ,p_group_pl_id => l_rates_new.group_pl_id
919: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
912: or ((l_rates_new.misc2_val is null)
913: and (p_rates_old.misc2_val is not null))
914: or (p_rates_old.misc2_val <> l_rates_new.misc2_val) ) then
915: if(ben_cwb_audit_api.return_lookup_validity('M2')=true) then
916: ben_cwb_audit_api.create_audit_entry
917: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
918: ,p_group_pl_id => l_rates_new.group_pl_id
919: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
920: ,p_pl_id => l_rates_new.pl_id
933: and (l_rates_new.misc3_val is not null))
934: or ((l_rates_new.misc3_val is null)
935: and (p_rates_old.misc3_val is not null))
936: or (p_rates_old.misc3_val <> l_rates_new.misc3_val) ) then
937: if(ben_cwb_audit_api.return_lookup_validity('M3')=true) then
938: ben_cwb_audit_api.create_audit_entry
939: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
940: ,p_group_pl_id => l_rates_new.group_pl_id
941: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
934: or ((l_rates_new.misc3_val is null)
935: and (p_rates_old.misc3_val is not null))
936: or (p_rates_old.misc3_val <> l_rates_new.misc3_val) ) then
937: if(ben_cwb_audit_api.return_lookup_validity('M3')=true) then
938: ben_cwb_audit_api.create_audit_entry
939: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
940: ,p_group_pl_id => l_rates_new.group_pl_id
941: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
942: ,p_pl_id => l_rates_new.pl_id
955: and (l_rates_new.ws_mn_val is not null))
956: or ((l_rates_new.ws_mn_val is null)
957: and (p_rates_old.ws_mn_val is not null))
958: or (p_rates_old.ws_mn_val <> l_rates_new.ws_mn_val) ) then
959: if(ben_cwb_audit_api.return_lookup_validity('WN')=true) then
960: ben_cwb_audit_api.create_audit_entry
961: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
962: ,p_group_pl_id => l_rates_new.group_pl_id
963: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
956: or ((l_rates_new.ws_mn_val is null)
957: and (p_rates_old.ws_mn_val is not null))
958: or (p_rates_old.ws_mn_val <> l_rates_new.ws_mn_val) ) then
959: if(ben_cwb_audit_api.return_lookup_validity('WN')=true) then
960: ben_cwb_audit_api.create_audit_entry
961: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
962: ,p_group_pl_id => l_rates_new.group_pl_id
963: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
964: ,p_pl_id => l_rates_new.pl_id
977: and (l_rates_new.ws_mx_val is not null))
978: or ((l_rates_new.ws_mx_val is null)
979: and (p_rates_old.ws_mx_val is not null))
980: or (p_rates_old.ws_mx_val <> l_rates_new.ws_mx_val) ) then
981: if(ben_cwb_audit_api.return_lookup_validity('WX')=true) then
982: ben_cwb_audit_api.create_audit_entry
983: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
984: ,p_group_pl_id => l_rates_new.group_pl_id
985: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
978: or ((l_rates_new.ws_mx_val is null)
979: and (p_rates_old.ws_mx_val is not null))
980: or (p_rates_old.ws_mx_val <> l_rates_new.ws_mx_val) ) then
981: if(ben_cwb_audit_api.return_lookup_validity('WX')=true) then
982: ben_cwb_audit_api.create_audit_entry
983: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
984: ,p_group_pl_id => l_rates_new.group_pl_id
985: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
986: ,p_pl_id => l_rates_new.pl_id
999: and (l_rates_new.rec_mn_val is not null))
1000: or ((l_rates_new.rec_mn_val is null)
1001: and (p_rates_old.rec_mn_val is not null))
1002: or (p_rates_old.rec_mn_val <> l_rates_new.rec_mn_val) ) then
1003: if(ben_cwb_audit_api.return_lookup_validity('RN')=true) then
1004: ben_cwb_audit_api.create_audit_entry
1005: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
1006: ,p_group_pl_id => l_rates_new.group_pl_id
1007: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
1000: or ((l_rates_new.rec_mn_val is null)
1001: and (p_rates_old.rec_mn_val is not null))
1002: or (p_rates_old.rec_mn_val <> l_rates_new.rec_mn_val) ) then
1003: if(ben_cwb_audit_api.return_lookup_validity('RN')=true) then
1004: ben_cwb_audit_api.create_audit_entry
1005: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
1006: ,p_group_pl_id => l_rates_new.group_pl_id
1007: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
1008: ,p_pl_id => l_rates_new.pl_id
1021: and (l_rates_new.rec_mx_val is not null))
1022: or ((l_rates_new.rec_mx_val is null)
1023: and (p_rates_old.rec_mx_val is not null))
1024: or (p_rates_old.rec_mx_val <> l_rates_new.rec_mx_val) ) then
1025: if(ben_cwb_audit_api.return_lookup_validity('RX')=true) then
1026: ben_cwb_audit_api.create_audit_entry
1027: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
1028: ,p_group_pl_id => l_rates_new.group_pl_id
1029: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
1022: or ((l_rates_new.rec_mx_val is null)
1023: and (p_rates_old.rec_mx_val is not null))
1024: or (p_rates_old.rec_mx_val <> l_rates_new.rec_mx_val) ) then
1025: if(ben_cwb_audit_api.return_lookup_validity('RX')=true) then
1026: ben_cwb_audit_api.create_audit_entry
1027: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
1028: ,p_group_pl_id => l_rates_new.group_pl_id
1029: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
1030: ,p_pl_id => l_rates_new.pl_id
1043: and (l_rates_new.elig_flag is not null))
1044: or ((l_rates_new.elig_flag is null)
1045: and (p_rates_old.elig_flag is not null))
1046: or (p_rates_old.elig_flag <> l_rates_new.elig_flag) ) then
1047: if(ben_cwb_audit_api.return_lookup_validity('EL')=true) then
1048:
1049: begin
1050: select meaning into l_cd_meaning_old
1051: from hr_lookups
1067: -- record does not exist. return null
1068: l_cd_meaning_new:= l_rates_new.elig_flag;
1069: end;
1070:
1071: ben_cwb_audit_api.create_audit_entry
1072: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
1073: ,p_group_pl_id => l_rates_new.group_pl_id
1074: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
1075: ,p_pl_id => l_rates_new.pl_id
1088: and (l_rates_new.inelig_rsn_cd is not null))
1089: or ((l_rates_new.inelig_rsn_cd is null)
1090: and (p_rates_old.inelig_rsn_cd is not null))
1091: or (p_rates_old.inelig_rsn_cd <> l_rates_new.inelig_rsn_cd) ) then
1092: if(ben_cwb_audit_api.return_lookup_validity('ER')=true) then
1093:
1094: begin
1095: select meaning into l_cd_meaning_old
1096: from hr_lookups
1112: -- record does not exist. return null
1113: l_cd_meaning_new:= null;
1114: end;
1115:
1116: ben_cwb_audit_api.create_audit_entry
1117: (p_group_per_in_ler_id => l_rates_new.group_per_in_ler_id
1118: ,p_group_pl_id => l_rates_new.group_pl_id
1119: ,p_lf_evt_ocrd_dt => l_rates_new.lf_evt_ocrd_dt
1120: ,p_pl_id => l_rates_new.pl_id