240: if l_delete_next_change_mode then
241: hr_utility.set_location('l_delete_next_change_mode true', 13);
242: end if;
243: if l_delete_next_change_mode = true or l_future_change_mode = true then
244: l_del_mode := hr_api.g_future_change;
245: else
246: l_del_mode := hr_api.g_zap;
247: end if;
248: --
242: end if;
243: if l_delete_next_change_mode = true or l_future_change_mode = true then
244: l_del_mode := hr_api.g_future_change;
245: else
246: l_del_mode := hr_api.g_zap;
247: end if;
248: --
249: return l_del_mode;
250:
490: fetch c_min_max_dt into l_min_start_date,l_max_end_date;
491: close c_min_max_dt;
492: --
493: if l_processing_type <> 'R' or p_effective_date < l_min_start_date then
494: l_dt_delete_mode := hr_api.g_zap;
495: else
496: if p_effective_date = l_min_start_date then
497: l_dt_delete_mode := hr_api.g_zap;
498: else
493: if l_processing_type <> 'R' or p_effective_date < l_min_start_date then
494: l_dt_delete_mode := hr_api.g_zap;
495: else
496: if p_effective_date = l_min_start_date then
497: l_dt_delete_mode := hr_api.g_zap;
498: else
499: l_effective_date := p_effective_date -1;
500: end if;
501: end if;