1: Package Body hxc_dtl_del as
2: /* $Header: hxcdtlrhi.pkb 120.2 2005/09/23 08:07:34 sechandr noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_dtl_del.'; -- Global package name
9: g_debug boolean :=hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< delete_dml >------------------------------|
230: hxc_dtl_bus.delete_validate(p_rec);
231: --
232: -- Call the supporting pre-delete operation
233: --
234: hxc_dtl_del.pre_delete(p_rec);
235: --
236: -- Delete the row.
237: --
238: hxc_dtl_del.delete_dml(p_rec);
234: hxc_dtl_del.pre_delete(p_rec);
235: --
236: -- Delete the row.
237: --
238: hxc_dtl_del.delete_dml(p_rec);
239: --
240: -- Call the supporting post-delete operation
241: --
242: hxc_dtl_del.post_delete(p_rec);
238: hxc_dtl_del.delete_dml(p_rec);
239: --
240: -- Call the supporting post-delete operation
241: --
242: hxc_dtl_del.post_delete(p_rec);
243: --
244: End del;
245: --
246: -- ----------------------------------------------------------------------------
273: -- Having converted the arguments into the hxc_dtl_rec
274: -- plsql record structure we must call the corresponding entity
275: -- business process
276: --
277: hxc_dtl_del.del(l_rec);
278: --
279: if g_debug then
280: hr_utility.set_location(' Leaving:'||l_proc, 10);
281: end if;
306: --
307: -- Delete all the translated rows
308: --
309: for l_lang in csr_del_langs loop
310: hxc_dtl_del.del
311: (p_alias_definition_id => p_alias_definition_id
312: ,p_language => l_lang.language
313: );
314: end loop;
317: hr_utility.set_location(' Leaving:'||l_proc,20);
318: end if;
319: End del_tl;
320: --
321: end hxc_dtl_del;