61: l_proc varchar2(72) := g_package||'dt_delete_dml';
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: --
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
162: --
163: Begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.effective_start_date
169: := ben_bep_shd.g_old_rec.effective_start_date;
170: --
167: --
168: p_rec.effective_start_date
169: := ben_bep_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = hr_api.g_delete) then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else
174: p_rec.effective_end_date := p_validation_end_date;
175: End If;
372: );
373: --
374: exception
375: --
376: when hr_api.cannot_find_prog_unit then
377: --
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'BEN_ELIG_OBJ_ELIG_PROFL_F'
380: ,p_hook_type => 'AD');
374: exception
375: --
376: when hr_api.cannot_find_prog_unit then
377: --
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'BEN_ELIG_OBJ_ELIG_PROFL_F'
380: ,p_hook_type => 'AD');
381: --
382: end;