[Home] [Help]
1: Package Body pqh_vlp_del as
2: /* $Header: pqvlprhi.pkb 115.6 2004/03/31 00:31:40 kgowripe noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_vlp_del.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------------< delete_dml >------------------------------|
12: -- ----------------------------------------------------------------------------
232: hr_multi_message.end_validation_set;
233: --
234: -- Call the supporting pre-delete operation
235: --
236: pqh_vlp_del.pre_delete(p_rec);
237: --
238: -- Delete the row.
239: --
240: pqh_vlp_del.delete_dml(p_rec);
236: pqh_vlp_del.pre_delete(p_rec);
237: --
238: -- Delete the row.
239: --
240: pqh_vlp_del.delete_dml(p_rec);
241: --
242: -- Call the supporting post-delete operation
243: --
244: pqh_vlp_del.post_delete(p_rec);
240: pqh_vlp_del.delete_dml(p_rec);
241: --
242: -- Call the supporting post-delete operation
243: --
244: pqh_vlp_del.post_delete(p_rec);
245: --
246: -- Call to raise any errors on multi-message list
247: hr_multi_message.end_validation_set;
248: --
273: -- Having converted the arguments into the pqh_vlp_rec
274: -- plsql record structure we must call the corresponding entity
275: -- business process
276: --
277: pqh_vlp_del.del(l_rec);
278: --
279: hr_utility.set_location(' Leaving:'||l_proc, 10);
280: End del;
281: --
278: --
279: hr_utility.set_location(' Leaving:'||l_proc, 10);
280: End del;
281: --
282: end pqh_vlp_del;