[Home] [Help]
60: --
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
85: --
86: --
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: End dt_delete_dml;
92: --
93: -- ----------------------------------------------------------------------------
140: --
141: l_proc varchar2(72) := g_package||'delete_dml';
142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc, 5);
145: --
146: pay_rom_del.dt_delete_dml
147: (p_rec => p_rec
148: ,p_effective_date => p_effective_date
150: ,p_validation_start_date => p_validation_start_date
151: ,p_validation_end_date => p_validation_end_date
152: );
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: End delete_dml;
156: --
157: -- ----------------------------------------------------------------------------
158: -- |----------------------------< dt_pre_delete >-----------------------------|
197: --
198: l_proc varchar2(72) := g_package||'dt_pre_delete';
199: --
200: Begin
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: If (p_datetrack_mode <> hr_api.g_zap) then
204: --
205: p_rec.effective_start_date
224: Else
225: p_rec.effective_start_date := null;
226: p_rec.effective_end_date := null;
227: End If;
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End dt_pre_delete;
230: --
231: -- ----------------------------------------------------------------------------
232: -- |------------------------------< pre_delete >------------------------------|
273: --
274: --
275: --
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: --
280: --
281: pay_rom_del.dt_pre_delete
285: ,p_validation_start_date => p_validation_start_date
286: ,p_validation_end_date => p_validation_end_date
287: );
288: --
289: hr_utility.set_location(' Leaving:'||l_proc, 10);
290: End pre_delete;
291: --
292: -- ----------------------------------------------------------------------------
293: -- |----------------------------< post_delete >-------------------------------|
331: --
332: l_proc varchar2(72) := g_package||'post_delete';
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: begin
337: --
338: -- Delete ownerships if applicable.
339: --
388: ,p_hook_type => 'AD');
389: --
390: end;
391: --
392: hr_utility.set_location(' Leaving:'||l_proc, 10);
393: End post_delete;
394: --
395: -- ----------------------------------------------------------------------------
396: -- |---------------------------------< del >----------------------------------|
405: l_validation_start_date date;
406: l_validation_end_date date;
407: --
408: Begin
409: hr_utility.set_location('Entering:'||l_proc, 5);
410: --
411: -- Ensure that the DateTrack delete mode is valid
412: --
413: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
461: ,p_validation_start_date => l_validation_start_date
462: ,p_validation_end_date => l_validation_end_date
463: );
464: --
465: hr_utility.set_location(' Leaving:'||l_proc, 5);
466: End del;
467: --
468: -- ----------------------------------------------------------------------------
469: -- |--------------------------------< del >-----------------------------------|
480: l_rec pay_rom_shd.g_rec_type;
481: l_proc varchar2(72) := g_package||'del';
482: --
483: Begin
484: hr_utility.set_location('Entering:'||l_proc, 5);
485: --
486: -- As the delete procedure accepts a plsql record structure we do need to
487: -- convert the arguments into the record structure.
488: -- We don't need to call the supplied conversion argument routine as we
506: p_object_version_number := l_rec.object_version_number;
507: p_effective_start_date := l_rec.effective_start_date;
508: p_effective_end_date := l_rec.effective_end_date;
509: --
510: hr_utility.set_location(' Leaving:'||l_proc, 10);
511: End del;
512: --
513: end pay_rom_del;