[Home] [Help]
1: Package Body psp_pee_del as
2: /* $Header: PSPEERHB.pls 120.3 2006/02/08 05:35 dpaudel noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' psp_pee_del.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------------< delete_dml >------------------------------|
12: -- ----------------------------------------------------------------------------
268: hr_multi_message.end_validation_set;
269: --
270: -- Call the supporting pre-delete operation
271: --
272: psp_pee_del.pre_delete(p_rec);
273: --
274: -- Delete the row.
275: --
276: psp_pee_del.delete_dml(p_rec);
272: psp_pee_del.pre_delete(p_rec);
273: --
274: -- Delete the row.
275: --
276: psp_pee_del.delete_dml(p_rec);
277: --
278: -- Call the supporting post-delete operation
279: --
280: psp_pee_del.post_delete(p_rec);
276: psp_pee_del.delete_dml(p_rec);
277: --
278: -- Call the supporting post-delete operation
279: --
280: psp_pee_del.post_delete(p_rec);
281: --
282: -- Call to raise any errors on multi-message list
283: hr_multi_message.end_validation_set;
284: --
309: -- Having converted the arguments into the psp_pee_rec
310: -- plsql record structure we must call the corresponding entity
311: -- business process
312: --
313: psp_pee_del.del(l_rec);
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 10);
316: End del;
317: --
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 10);
316: End del;
317: --
318: end psp_pee_del;