1: Package Body psp_poa_del as
2: /* $Header: PSPOARHB.pls 120.5 2006/09/05 11:10:12 dpaudel noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' psp_poa_del.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------------< delete_dml >------------------------------|
12: -- ----------------------------------------------------------------------------
272: hr_multi_message.end_validation_set;
273: --
274: -- Call the supporting pre-delete operation
275: --
276: psp_poa_del.pre_delete(p_rec);
277: --
278: -- Delete the row.
279: --
280: psp_poa_del.delete_dml(p_rec);
276: psp_poa_del.pre_delete(p_rec);
277: --
278: -- Delete the row.
279: --
280: psp_poa_del.delete_dml(p_rec);
281: --
282: -- Call the supporting post-delete operation
283: --
284: psp_poa_del.post_delete(p_rec);
280: psp_poa_del.delete_dml(p_rec);
281: --
282: -- Call the supporting post-delete operation
283: --
284: psp_poa_del.post_delete(p_rec);
285: --
286: -- Call to raise any errors on multi-message list
287: hr_multi_message.end_validation_set;
288: --
313: -- Having converted the arguments into the psp_poa_rec
314: -- plsql record structure we must call the corresponding entity
315: -- business process
316: --
317: psp_poa_del.del(l_rec);
318: --
319: hr_utility.set_location(' Leaving:'||l_proc, 10);
320: End del;
321: --
318: --
319: hr_utility.set_location(' Leaving:'||l_proc, 10);
320: End del;
321: --
322: end psp_poa_del;