[Home] [Help]
1: Package Body pqh_txh_del as
2: /* $Header: pqtxhrhi.pkb 120.2 2005/12/21 11:29:59 hpandya noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_txh_del.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------------< delete_dml >------------------------------|
12: -- ----------------------------------------------------------------------------
202: hr_multi_message.end_validation_set;
203: --
204: -- Call the supporting pre-delete operation
205: --
206: pqh_txh_del.pre_delete(p_rec);
207: --
208: -- Delete the row.
209: --
210: pqh_txh_del.delete_dml(p_rec);
206: pqh_txh_del.pre_delete(p_rec);
207: --
208: -- Delete the row.
209: --
210: pqh_txh_del.delete_dml(p_rec);
211: --
212: -- Call the supporting post-delete operation
213: --
214: pqh_txh_del.post_delete(p_rec);
210: pqh_txh_del.delete_dml(p_rec);
211: --
212: -- Call the supporting post-delete operation
213: --
214: pqh_txh_del.post_delete(p_rec);
215: --
216: -- Call to raise any errors on multi-message list
217: hr_multi_message.end_validation_set;
218: --
242: -- Having converted the arguments into the pqh_txh_rec
243: -- plsql record structure we must call the corresponding entity
244: -- business process
245: --
246: pqh_txh_del.del(l_rec);
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 10);
249: End del;
250: --
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 10);
249: End del;
250: --
251: end pqh_txh_del;