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