[Home] [Help]
71: --start date.
72:
73: --
74: hr_utility.set_location('Absence Event Type = START', 10);
75: l_look_up_check := HR_GENERAL.DECODE_LOOKUP('PQP_GAP_ABSENCE_TYPES_LIST',p_new_abs_attendance_type_id);
76: --
77: if l_look_up_check is not null then
78: --
79: if p_old_date_start <> p_new_date_start and p_new_abs_attendance_type_id <> l_default then
190: --delete, an additional check is introduced to ensure that new value is not
191: --equal to the default.
192: --
193: hr_utility.set_location('Absence Event Type = END', 80);
194: l_look_up_check := HR_GENERAL.DECODE_LOOKUP('PQP_GAP_ABSENCE_TYPES_LIST',p_new_abs_attendance_type_id);
195: --
196: if l_look_up_check is not null then
197: --(
198: if p_old_date_end <> p_new_date_end and p_new_abs_attendance_type_id <> l_default then
216: --delete, an additional check is introduced to ensure that new value is not
217: --equal to the default.
218: --
219: hr_utility.set_location('Absence Event Type = DELETE', 90);
220: l_look_up_check := HR_GENERAL.DECODE_LOOKUP('PQP_GAP_ABSENCE_TYPES_LIST',p_old_abs_attendance_type_id);
221:
222: if l_look_up_check is not null then
223: --
224: if p_old_abs_attendance_type_id <> l_default and p_new_abs_attendance_type_id = l_default then
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;
425: --
426: end if;