1: Package Body hxc_hav_del as
2: /* $Header: hxchavrhi.pkb 120.2 2005/09/23 10:41:41 sechandr noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_hav_del.'; -- Global package name
9: g_debug boolean:=hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< delete_dml >------------------------------|
299: hxc_hav_bus.delete_validate(p_rec);
300: --
301: -- Call the supporting pre-delete operation
302: --
303: hxc_hav_del.pre_delete(p_rec);
304: --
305: -- Delete the row.
306: --
307: hxc_hav_del.delete_dml(p_rec);
303: hxc_hav_del.pre_delete(p_rec);
304: --
305: -- Delete the row.
306: --
307: hxc_hav_del.delete_dml(p_rec);
308: --
309: -- Call the supporting post-delete operation
310: --
311: hxc_hav_del.post_delete(p_rec);
307: hxc_hav_del.delete_dml(p_rec);
308: --
309: -- Call the supporting post-delete operation
310: --
311: hxc_hav_del.post_delete(p_rec);
312: --
313: End del;
314: --
315: -- ----------------------------------------------------------------------------
341: -- Having converted the arguments into the hxc_hav_rec
342: -- plsql record structure we must call the corresponding entity
343: -- business process
344: --
345: hxc_hav_del.del(l_rec);
346: --
347: --
348: -- Remove all matching translation rows
349: hxc_vtl_del.del_tl
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: end if;
356: End del;
357: --
358: end hxc_hav_del;