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