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 >------------------------------|
13: -- ----------------------------------------------------------------------------
59: --
60: Begin
61: if g_debug then
62: l_proc := g_package||'insert_dml';
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: end if;
65: --
66: --
67: --
93: --
94: --
95: --
96: if g_debug then
97: hr_utility.set_location(' Leaving:'||l_proc, 10);
98: end if;
99: Exception
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
164: Begin
165:
166: if g_debug then
167: l_proc := g_package||'pre_insert';
168: hr_utility.set_location('Entering:'||l_proc, 5);
169: end if;
170: --
171: p_rec.alias_value_id := p_alias_value_id;
172: --
170: --
171: p_rec.alias_value_id := p_alias_value_id;
172: --
173: if g_debug then
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: end if;
176: End pre_insert;
177: --
178: -- ----------------------------------------------------------------------------
216: Begin
217:
218: if g_debug then
219: l_proc := g_package||'post_insert';
220: hr_utility.set_location('Entering:'||l_proc, 5);
221: end if;
222: begin
223: --
224: hxc_vtl_rki.after_insert
242: --
243: end;
244: --
245: if g_debug then
246: hr_utility.set_location(' Leaving:'||l_proc, 10);
247: end if;
248: End post_insert;
249: --
250: -- ----------------------------------------------------------------------------
257: --
258: l_proc varchar2(72) ;
259: --
260: Begin
261: g_debug :=hr_utility.debug_enabled;
262: if g_debug then
263: l_proc := g_package||'ins';
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: end if;
260: Begin
261: g_debug :=hr_utility.debug_enabled;
262: if g_debug then
263: l_proc := g_package||'ins';
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: end if;
266: --
267: -- Call the supporting insert validate operations
268: --
287: (p_rec
288: );
289: --
290: if g_debug then
291: hr_utility.set_location('Leaving:'||l_proc, 20);
292: end if;
293: end ins;
294: --
295: -- ----------------------------------------------------------------------------
305: l_rec hxc_vtl_shd.g_rec_type;
306: l_proc varchar2(72) ;
307: --
308: Begin
309: g_debug :=hr_utility.debug_enabled;
310: if g_debug then
311: l_proc := g_package||'ins';
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: end if;
308: Begin
309: g_debug :=hr_utility.debug_enabled;
310: if g_debug then
311: l_proc := g_package||'ins';
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: end if;
314: --
315: -- Call conversion function to turn arguments into the
316: -- p_rec structure.
336: --
337: --
338: --
339: if g_debug then
340: hr_utility.set_location(' Leaving:'||l_proc, 10);
341: end if;
342: End ins;
343: --
344: -- ----------------------------------------------------------------------------
363: --
364: l_proc varchar2(72) ;
365: --
366: Begin
367: g_debug :=hr_utility.debug_enabled;
368: if g_debug then
369: l_proc := g_package || 'ins_tl';
370: hr_utility.set_location('Entering:'||l_proc,10);
371: end if;
366: Begin
367: g_debug :=hr_utility.debug_enabled;
368: if g_debug then
369: l_proc := g_package || 'ins_tl';
370: hr_utility.set_location('Entering:'||l_proc,10);
371: end if;
372: --
373: -- Insert a row for the base language and every installed language.
374: --
381: );
382: end loop;
383: --
384: if g_debug then
385: hr_utility.set_location('Leaving:'||l_proc,20);
386: end if;
387: End ins_tl;
388: --
389: end hxc_vtl_ins;