[Home] [Help]
1: Package Body hxc_vtl_ins as
2: /* $Header: hxcvtlrhi.pkb 120.2 2005/09/23 06:39:43 rchennur noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_vtl_ins.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< insert_dml >------------------------------|
271: );
272: --
273: -- Call the supporting pre-insert operation
274: --
275: hxc_vtl_ins.pre_insert
276: (p_rec => p_rec
277: ,p_alias_value_id => p_alias_value_id
278: );
279: --
278: );
279: --
280: -- Insert the row
281: --
282: hxc_vtl_ins.insert_dml(p_rec);
283: --
284: -- Call the supporting post-insert operation
285: --
286: hxc_vtl_ins.post_insert
282: hxc_vtl_ins.insert_dml(p_rec);
283: --
284: -- Call the supporting post-insert operation
285: --
286: hxc_vtl_ins.post_insert
287: (p_rec
288: );
289: --
290: if g_debug then
325: --
326: -- Having converted the arguments into the hxc_vtl_rec
327: -- plsql record structure we call the corresponding record business process.
328: --
329: hxc_vtl_ins.ins
330: (p_rec => l_rec
331: ,p_alias_value_id => p_alias_value_id
332: );
333: --
372: --
373: -- Insert a row for the base language and every installed language.
374: --
375: for l_lang in csr_ins_langs loop
376: hxc_vtl_ins.ins
377: (p_alias_value_id => p_alias_value_id
378: ,p_language => l_lang.language_code
379: ,p_source_lang => p_language_code
380: ,p_alias_value_name => p_alias_value_name
385: hr_utility.set_location('Leaving:'||l_proc,20);
386: end if;
387: End ins_tl;
388: --
389: end hxc_vtl_ins;