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.start_date
169: := ame_itc_shd.g_old_rec.start_date;
170: --
167: --
168: p_rec.start_date
169: := ame_itc_shd.g_old_rec.start_date;
170: --
171: If (p_datetrack_mode = hr_api.g_delete) then
172: p_rec.end_date := p_validation_start_date;
173: Else
174: p_rec.end_date := p_validation_end_date;
175: End If;
313: );
314: --
315: exception
316: --
317: when hr_api.cannot_find_prog_unit then
318: --
319: hr_api.cannot_find_prog_unit_error
320: (p_module_name => 'AME_ITEM_CLASSES'
321: ,p_hook_type => 'AD');
315: exception
316: --
317: when hr_api.cannot_find_prog_unit then
318: --
319: hr_api.cannot_find_prog_unit_error
320: (p_module_name => 'AME_ITEM_CLASSES'
321: ,p_hook_type => 'AD');
322: --
323: end;