1: Package Body pqp_aat_del as
2: /* $Header: pqaatrhi.pkb 120.2.12010000.2 2008/08/05 13:56:35 ubhat ship $ */
3: --
4: -- ---------------------------------------------------------------------------+
5: -- | Private Global Definitions |
4: -- ---------------------------------------------------------------------------+
5: -- | Private Global Definitions |
6: -- ---------------------------------------------------------------------------+
7: --
8: g_package varchar2(33) := ' pqp_aat_del.'; -- Global package name
9: --
10: -- ---------------------------------------------------------------------------+
11: -- |----------------------------< dt_delete_dml >-----------------------------|
12: -- ---------------------------------------------------------------------------+
110: --
111: Begin
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: pqp_aat_del.dt_delete_dml
115: (p_rec => p_rec
116: ,p_effective_date => p_effective_date
117: ,p_datetrack_mode => p_datetrack_mode
118: ,p_validation_start_date => p_validation_start_date
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: --
248: --
249: pqp_aat_del.dt_pre_delete
250: (p_rec => p_rec
251: ,p_effective_date => p_effective_date
252: ,p_datetrack_mode => p_datetrack_mode
253: ,p_validation_start_date => p_validation_start_date
537: );
538: --
539: -- Call the supporting pre-delete operation
540: --
541: pqp_aat_del.pre_delete
542: (p_rec => p_rec
543: ,p_effective_date => p_effective_date
544: ,p_datetrack_mode => p_datetrack_mode
545: ,p_validation_start_date => l_validation_start_date
547: );
548: --
549: -- Delete the row.
550: --
551: pqp_aat_del.delete_dml
552: (p_rec => p_rec
553: ,p_effective_date => p_effective_date
554: ,p_datetrack_mode => p_datetrack_mode
555: ,p_validation_start_date => l_validation_start_date
556: ,p_validation_end_date => l_validation_end_date
557: );
558: -- Call the supporting post-delete operation
559: --
560: pqp_aat_del.post_delete
561: (p_rec => p_rec
562: ,p_effective_date => p_effective_date
563: ,p_datetrack_mode => p_datetrack_mode
564: ,p_validation_start_date => l_validation_start_date
597: -- Having converted the arguments into the pqp_aat_rec
598: -- plsql record structure we must call the corresponding entity
599: -- business process
600: --
601: pqp_aat_del.del
602: (p_effective_date
603: ,p_datetrack_mode
604: ,l_rec
605: );
612: --
613: hr_utility.set_location(' Leaving:'||l_proc, 10);
614: End del;
615: --
616: end pqp_aat_del;