5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_dtl_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: --
98: --
99: --
100: --
101: if g_debug then
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: end if;
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
168: --
169: Begin
170: if g_debug then
171: l_proc := g_package||'pre_insert';
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: end if;
174: --
175: p_rec.alias_definition_id := p_alias_definition_id;
176: --
174: --
175: p_rec.alias_definition_id := p_alias_definition_id;
176: --
177: if g_debug then
178: hr_utility.set_location(' Leaving:'||l_proc, 10);
179: end if;
180: End pre_insert;
181: --
182: -- ----------------------------------------------------------------------------
219: --
220: Begin
221: if g_debug then
222: l_proc := g_package||'post_insert';
223: hr_utility.set_location('Entering:'||l_proc, 5);
224: end if;
225: begin
226: --
227: hxc_dtl_rki.after_insert
249: --
250: end;
251: --
252: if g_debug then
253: hr_utility.set_location(' Leaving:'||l_proc, 10);
254: end if;
255: End post_insert;
256: --
257: -- ----------------------------------------------------------------------------
264: --
265: l_proc varchar2(72);
266: --
267: Begin
268: g_debug:=hr_utility.debug_enabled;
269: if g_debug then
270: l_proc := g_package||'ins';
271: hr_utility.set_location('Entering:'||l_proc, 5);
272: end if;
267: Begin
268: g_debug:=hr_utility.debug_enabled;
269: if g_debug then
270: l_proc := g_package||'ins';
271: hr_utility.set_location('Entering:'||l_proc, 5);
272: end if;
273: --
274: -- Call the supporting insert validate operations
275: --
294: (p_rec
295: );
296: --
297: if g_debug then
298: hr_utility.set_location('Leaving:'||l_proc, 20);
299: end if;
300: end ins;
301: --
302: -- ----------------------------------------------------------------------------
314: l_rec hxc_dtl_shd.g_rec_type;
315: l_proc varchar2(72);
316: --
317: Begin
318: g_debug:=hr_utility.debug_enabled;
319: if g_debug then
320: l_proc := g_package||'ins';
321: hr_utility.set_location('Entering:'||l_proc, 5);
322: end if;
317: Begin
318: g_debug:=hr_utility.debug_enabled;
319: if g_debug then
320: l_proc := g_package||'ins';
321: hr_utility.set_location('Entering:'||l_proc, 5);
322: end if;
323: --
324: -- Call conversion function to turn arguments into the
325: -- p_rec structure.
347: --
348: --
349: --
350: if g_debug then
351: hr_utility.set_location(' Leaving:'||l_proc, 10);
352: end if;
353: End ins;
354: --
355: -- ----------------------------------------------------------------------------
376: --
377: l_proc varchar2(72);
378: --
379: Begin
380: g_debug:=hr_utility.debug_enabled;
381: if g_debug then
382: l_proc := g_package || 'ins_tl';
383: hr_utility.set_location('Entering:'||l_proc,10);
384: end if;
379: Begin
380: g_debug:=hr_utility.debug_enabled;
381: if g_debug then
382: l_proc := g_package || 'ins_tl';
383: hr_utility.set_location('Entering:'||l_proc,10);
384: end if;
385: --
386: -- Insert a row for the base language and every installed language.
387: --
396: );
397: end loop;
398: --
399: if g_debug then
400: hr_utility.set_location('Leaving:'||l_proc,20);
401: end if;
402: End ins_tl;
403: --
404: end hxc_dtl_ins;