[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_rtu_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_rtu_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: -- RET added call to delete ownerships
339: --
386: ,p_hook_type => 'AD');
387: --
388: end;
389: --
390: hr_utility.set_location(' Leaving:'||l_proc, 10);
391: End post_delete;
392: --
393: -- ----------------------------------------------------------------------------
394: -- |---------------------------------< del >----------------------------------|
403: l_validation_start_date date;
404: l_validation_end_date date;
405: --
406: Begin
407: hr_utility.set_location('Entering:'||l_proc, 5);
408: --
409: -- Ensure that the DateTrack delete mode is valid
410: --
411: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
459: ,p_validation_start_date => l_validation_start_date
460: ,p_validation_end_date => l_validation_end_date
461: );
462: --
463: hr_utility.set_location(' Leaving:'||l_proc, 5);
464: End del;
465: --
466: -- ----------------------------------------------------------------------------
467: -- |--------------------------------< del >-----------------------------------|
478: l_rec pay_rtu_shd.g_rec_type;
479: l_proc varchar2(72) := g_package||'del';
480: --
481: Begin
482: hr_utility.set_location('Entering:'||l_proc, 5);
483: --
484: -- As the delete procedure accepts a plsql record structure we do need to
485: -- convert the arguments into the record structure.
486: -- We don't need to call the supplied conversion argument routine as we
504: p_object_version_number := l_rec.object_version_number;
505: p_effective_start_date := l_rec.effective_start_date;
506: p_effective_end_date := l_rec.effective_end_date;
507: --
508: hr_utility.set_location(' Leaving:'||l_proc, 10);
509: End del;
510: --
511: end pay_rtu_del;