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: := pay_psd_shd.g_old_rec.effective_start_date;
170: --
167: --
168: p_rec.effective_start_date
169: := pay_psd_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;
366: );
367: --
368: exception
369: --
370: when hr_api.cannot_find_prog_unit then
371: --
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'PAY_PL_SII_DETAILS_F'
374: ,p_hook_type => 'AD');
368: exception
369: --
370: when hr_api.cannot_find_prog_unit then
371: --
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'PAY_PL_SII_DETAILS_F'
374: ,p_hook_type => 'AD');
375: --
376: end;