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: per_spp_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
167: --
168: Begin
169: hr_utility.set_location('Entering:'||l_proc, 5);
170: --
171: If (p_datetrack_mode <> hr_api.g_zap) then
172: --
173: p_rec.effective_start_date
174: := per_spp_shd.g_old_rec.effective_start_date;
175: --
172: --
173: p_rec.effective_start_date
174: := per_spp_shd.g_old_rec.effective_start_date;
175: --
176: If (p_datetrack_mode = hr_api.g_delete) then
177: p_rec.effective_end_date := p_validation_start_date - 1;
178: Else
179: p_rec.effective_end_date := p_validation_end_date;
180: End If;
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);
322:
323: -- Code changes start for bug 7457065
324: If (p_datetrack_mode <> hr_api.g_zap) then
325: open c_step_end_date;
326: fetch c_step_end_date into l_step_end_date;
327: close c_step_end_date;
328:
343: where placement_id = p_rec.placement_id
344: and effective_start_date = p_rec.effective_start_date;
345: end if;
346: end if;
347: end if; -- If (p_datetrack_mode <> hr_api.g_zap) then
348: -- Code changes end for bug 7457065
349:
350: begin
351: --
426: );
427: --
428: exception
429: --
430: when hr_api.cannot_find_prog_unit then
431: --
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'PER_SPINAL_POINT_PLACEMENTS_F'
434: ,p_hook_type => 'AD');
428: exception
429: --
430: when hr_api.cannot_find_prog_unit then
431: --
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'PER_SPINAL_POINT_PLACEMENTS_F'
434: ,p_hook_type => 'AD');
435: --
436: end;