[Home] [Help]
1: Package Body hr_opt_del as
2: /* $Header: hroptrhi.pkb 120.1 2005/09/29 07:03 santosin noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hr_opt_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: hr_opt_del.pre_delete(p_rec);
225: --
226: -- Delete the row.
227: --
228: hr_opt_del.delete_dml(p_rec);
224: hr_opt_del.pre_delete(p_rec);
225: --
226: -- Delete the row.
227: --
228: hr_opt_del.delete_dml(p_rec);
229: --
230: -- Call the supporting post-delete operation
231: --
232: hr_opt_del.post_delete(p_rec);
228: hr_opt_del.delete_dml(p_rec);
229: --
230: -- Call the supporting post-delete operation
231: --
232: hr_opt_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 hr_opt_rec
262: -- plsql record structure we must call the corresponding entity
263: -- business process
264: --
265: hr_opt_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 hr_opt_del;