[Home] [Help]
1: Package Body psp_psc_del as
2: /* $Header: PSPSCRHB.pls 120.1 2005/11/28 23:27 dpaudel noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' psp_psc_del.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------------< delete_dml >------------------------------|
12: -- ----------------------------------------------------------------------------
220: hr_multi_message.end_validation_set;
221: --
222: -- Call the supporting pre-delete operation
223: --
224: psp_psc_del.pre_delete(p_rec);
225: --
226: -- Delete the row.
227: --
228: psp_psc_del.delete_dml(p_rec);
224: psp_psc_del.pre_delete(p_rec);
225: --
226: -- Delete the row.
227: --
228: psp_psc_del.delete_dml(p_rec);
229: --
230: -- Call the supporting post-delete operation
231: --
232: psp_psc_del.post_delete(p_rec);
228: psp_psc_del.delete_dml(p_rec);
229: --
230: -- Call the supporting post-delete operation
231: --
232: psp_psc_del.post_delete(p_rec);
233: --
234: -- Call to raise any errors on multi-message list
235: hr_multi_message.end_validation_set;
236: --
261: -- Having converted the arguments into the psp_psc_rec
262: -- plsql record structure we must call the corresponding entity
263: -- business process
264: --
265: psp_psc_del.del(l_rec);
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: End del;
269: --
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: End del;
269: --
270: end psp_psc_del;