[Home] [Help]
1: Package Body pqh_rnk_del as
2: /* $Header: pqrnkrhi.pkb 120.1 2005/06/23 13:27 nsanghal noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package constant varchar2(33) := ' pqh_rnk_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_rnk_del.pre_delete(p_rec);
237: --
238: -- Delete the row.
239: --
240: pqh_rnk_del.delete_dml(p_rec);
236: pqh_rnk_del.pre_delete(p_rec);
237: --
238: -- Delete the row.
239: --
240: pqh_rnk_del.delete_dml(p_rec);
241: --
242: -- Call the supporting post-delete operation
243: --
244: pqh_rnk_del.post_delete(p_rec);
240: pqh_rnk_del.delete_dml(p_rec);
241: --
242: -- Call the supporting post-delete operation
243: --
244: pqh_rnk_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_rnk_rec
274: -- plsql record structure we must call the corresponding entity
275: -- business process
276: --
277: pqh_rnk_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_rnk_del;