[Home] [Help]
416: --
417: begin
418: --
419: --hr_utility.trace_on(null, 'dax');
420: benutils.set_data_migrator_mode; -- Bug 3320133
421: --
422: if hr_general.g_data_migrator_mode in ( 'Y','P') then
423: --
424: return;
846: populate_param_tab('BEN_ABA_IO_ATTRIBUTE18', p_old.attribute18);
847: populate_param_tab('BEN_ABA_IO_ATTRIBUTE19', p_old.attribute19);
848: populate_param_tab('BEN_ABA_IO_ATTRIBUTE20', p_old.attribute20);
849:
850: benutils.exec_rule
851: (p_formula_id => l_per_info_chg_cs_ler_rl,
852: p_effective_date => l_session_date,
853: p_lf_evt_ocrd_dt => null,
854: p_business_group_id => nvl(p_new.business_group_id,p_old.business_group_id),
907: --
908: if l_column = 'ABSENCE_ATTENDANCE_TYPE_ID' then
909: --
910: l_changed :=
911: (benutils.column_changed
912: (p_old.absence_attendance_type_id,
913: p_new.absence_attendance_type_id,
914: l_new_val) and
915: benutils.column_changed
911: (benutils.column_changed
912: (p_old.absence_attendance_type_id,
913: p_new.absence_attendance_type_id,
914: l_new_val) and
915: benutils.column_changed
916: (p_new.absence_attendance_type_id,
917: p_old.absence_attendance_type_id,
918: l_old_val) and
919: (l_changed));
925: -- We need to decode the absence_attendance_reasons back
926: -- to lookup values.
927: --
928: l_changed :=
929: (benutils.column_changed
930: (decode_reason(p_old.abs_attendance_reason_id),
931: decode_reason(p_new.abs_attendance_reason_id),
932: l_new_val) and
933: benutils.column_changed
929: (benutils.column_changed
930: (decode_reason(p_old.abs_attendance_reason_id),
931: decode_reason(p_new.abs_attendance_reason_id),
932: l_new_val) and
933: benutils.column_changed
934: (decode_reason(p_new.abs_attendance_reason_id),
935: decode_reason(p_old.abs_attendance_reason_id),
936: l_old_val) and (l_changed));
937: --
940: if l_column = 'DATE_START' then
941: --
942: hr_utility.set_location(' Inside Date start ben_abs_trigger', 52);
943: l_changed :=
944: (benutils.column_changed
945: (p_old.date_start,
946: p_new.date_start,
947: l_new_val) and
948: benutils.column_changed
944: (benutils.column_changed
945: (p_old.date_start,
946: p_new.date_start,
947: l_new_val) and
948: benutils.column_changed
949: (p_new.date_start,
950: p_old.date_start,
951: l_old_val) and (l_changed))or -- added here for bug 6895974
952: (benutils.column_changed
948: benutils.column_changed
949: (p_new.date_start,
950: p_old.date_start,
951: l_old_val) and (l_changed))or -- added here for bug 6895974
952: (benutils.column_changed
953: (p_old.abs_information1,
954: p_new.abs_information1,
955: l_new_val) and
956: benutils.column_changed
952: (benutils.column_changed
953: (p_old.abs_information1,
954: p_new.abs_information1,
955: l_new_val) and
956: benutils.column_changed
957: (p_new.abs_information1,
958: p_old.abs_information1,
959: l_old_val) and (l_changed))or
960: (benutils.column_changed
956: benutils.column_changed
957: (p_new.abs_information1,
958: p_old.abs_information1,
959: l_old_val) and (l_changed))or
960: (benutils.column_changed
961: (p_old.abs_information2,
962: p_new.abs_information2,
963: l_new_val) and
964: benutils.column_changed
960: (benutils.column_changed
961: (p_old.abs_information2,
962: p_new.abs_information2,
963: l_new_val) and
964: benutils.column_changed
965: (p_new.abs_information2,
966: p_old.abs_information2,
967: l_old_val) and (l_changed))or
968: (benutils.column_changed
964: benutils.column_changed
965: (p_new.abs_information2,
966: p_old.abs_information2,
967: l_old_val) and (l_changed))or
968: (benutils.column_changed
969: (p_old.abs_information4,
970: p_new.abs_information4,
971: l_new_val) and
972: benutils.column_changed
968: (benutils.column_changed
969: (p_old.abs_information4,
970: p_new.abs_information4,
971: l_new_val) and
972: benutils.column_changed
973: (p_new.abs_information4,
974: p_old.abs_information4,
975: l_old_val) and (l_changed))or
976: (benutils.column_changed
972: benutils.column_changed
973: (p_new.abs_information4,
974: p_old.abs_information4,
975: l_old_val) and (l_changed))or
976: (benutils.column_changed
977: (p_old.abs_information5,
978: p_new.abs_information5,
979: l_new_val) and
980: benutils.column_changed
976: (benutils.column_changed
977: (p_old.abs_information5,
978: p_new.abs_information5,
979: l_new_val) and
980: benutils.column_changed
981: (p_new.abs_information5,
982: p_old.abs_information5,
983: l_old_val) and (l_changed))or
984: (benutils.column_changed
980: benutils.column_changed
981: (p_new.abs_information5,
982: p_old.abs_information5,
983: l_old_val) and (l_changed))or
984: (benutils.column_changed
985: (p_old.abs_information6,
986: p_new.abs_information6,
987: l_new_val) and
988: benutils.column_changed
984: (benutils.column_changed
985: (p_old.abs_information6,
986: p_new.abs_information6,
987: l_new_val) and
988: benutils.column_changed
989: (p_new.abs_information6,
990: p_old.abs_information6,
991: l_old_val) and (l_changed)); -- added till here for bug 6895974
992: --
994: --
995: if l_column = 'DATE_END' then
996: --
997: l_changed :=
998: (benutils.column_changed
999: (p_old.date_end,
1000: p_new.date_end,
1001: l_new_val) and
1002: benutils.column_changed
998: (benutils.column_changed
999: (p_old.date_end,
1000: p_new.date_end,
1001: l_new_val) and
1002: benutils.column_changed
1003: (p_new.date_end,
1004: p_old.date_end,
1005: l_old_val) and (l_changed));
1006: --