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_cty_shd.g_old_rec.effective_start_date;
170: --
167: --
168: p_rec.effective_start_date
169: := ben_cty_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;
396: );
397: --
398: exception
399: --
400: when hr_api.cannot_find_prog_unit then
401: --
402: hr_api.cannot_find_prog_unit_error
403: (p_module_name => 'BEN_comptncy_rt_F'
404: ,p_hook_type => 'AD');
398: exception
399: --
400: when hr_api.cannot_find_prog_unit then
401: --
402: hr_api.cannot_find_prog_unit_error
403: (p_module_name => 'BEN_comptncy_rt_F'
404: ,p_hook_type => 'AD');
405: --
406: end;