[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_pbc_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_pbc_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: delete_app_ownerships
448: ,p_hook_type => 'AD');
449: --
450: end;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 10);
453: End post_delete;
454: --
455: -- ----------------------------------------------------------------------------
456: -- |---------------------------------< del >----------------------------------|
465: l_validation_start_date date;
466: l_validation_end_date date;
467: --
468: Begin
469: hr_utility.set_location('Entering:'||l_proc, 5);
470: --
471: -- Ensure that the DateTrack delete mode is valid
472: --
473: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
527: --
528: -- Call to raise any errors on multi-message list
529: hr_multi_message.end_validation_set;
530: --
531: hr_utility.set_location(' Leaving:'||l_proc, 5);
532: End del;
533: --
534: -- ----------------------------------------------------------------------------
535: -- |--------------------------------< del >-----------------------------------|
546: l_rec pay_pbc_shd.g_rec_type;
547: l_proc varchar2(72) := g_package||'del';
548: --
549: Begin
550: hr_utility.set_location('Entering:'||l_proc, 5);
551: --
552: -- As the delete procedure accepts a plsql record structure we do need to
553: -- convert the arguments into the record structure.
554: -- We don't need to call the supplied conversion argument routine as we
573: p_object_version_number := l_rec.object_version_number;
574: p_effective_start_date := l_rec.effective_start_date;
575: p_effective_end_date := l_rec.effective_end_date;
576: --
577: hr_utility.set_location(' Leaving:'||l_proc, 10);
578: End del;
579: --
580: end pay_pbc_del;