[Home] [Help]
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_lkr_ins.'; -- Global package name
9:
10: g_debug boolean := hr_utility.debug_enabled;
11: --
12: -- The following global variables are only to be used by
13: -- the set_base_key_value and pre_insert procedures.
14: --
24: --
25: l_proc varchar2(72);
26: --
27: Begin
28: g_debug := hr_utility.debug_enabled;
29:
30: if g_debug then
31: l_proc := g_package||'set_base_key_value';
32: hr_utility.set_location('Entering:'||l_proc, 10);
28: g_debug := hr_utility.debug_enabled;
29:
30: if g_debug then
31: l_proc := g_package||'set_base_key_value';
32: hr_utility.set_location('Entering:'||l_proc, 10);
33: end if;
34: --
35: hxc_lkr_ins.g_locker_type_owner_id_i := p_locker_type_owner_id;
36: hxc_lkr_ins.g_locker_type_requestor_id_i := p_locker_type_requestor_id;
35: hxc_lkr_ins.g_locker_type_owner_id_i := p_locker_type_owner_id;
36: hxc_lkr_ins.g_locker_type_requestor_id_i := p_locker_type_requestor_id;
37: --
38: if g_debug then
39: hr_utility.set_location(' Leaving:'||l_proc, 20);
40: end if;
41: End set_base_key_value;
42: --
43: --
94:
95:
96: if g_debug then
97: l_proc := g_package||'insert_dml';
98: hr_utility.set_location('Entering:'||l_proc, 5);
99: end if;
100: --
101: --
102: --
126: --
127: --
128: --
129: if g_debug then
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: end if;
132: Exception
133: When hr_api.check_integrity_violated Then
134: -- A check constraint has been violated
209:
210: null;
211: /*
212: if g_debug then
213: hr_utility.set_location('Entering:'||l_proc, 5);
214: end if;
215: --
216: If (hxc_lkr_ins.g_locker_type_owner_id_i is not null or
217: hxc_lkr_ins.g_locker_type_requestor_id_i is not null) Then
253: */
254: --
255: if g_debug then
256: l_proc := g_package||'pre_insert';
257: hr_utility.set_location(' Leaving:'||l_proc, 10);
258: end if;
259: End pre_insert;
260: --
261: -- ----------------------------------------------------------------------------
300:
301:
302: if g_debug then
303: l_proc := g_package||'post_insert';
304: hr_utility.set_location('Entering:'||l_proc, 5);
305: end if;
306: begin
307:
308: hxc_lkr_rki.after_insert
326: --
327: end;
328: --
329: if g_debug then
330: hr_utility.set_location(' Leaving:'||l_proc, 10);
331: end if;
332: End post_insert;
333: --
334: -- ----------------------------------------------------------------------------
340: --
341: l_proc varchar2(72);
342: --
343: Begin
344: g_debug := hr_utility.debug_enabled;
345:
346: if g_debug then
347: l_proc := g_package||'ins';
348: hr_utility.set_location('Entering:'||l_proc, 5);
344: g_debug := hr_utility.debug_enabled;
345:
346: if g_debug then
347: l_proc := g_package||'ins';
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: end if;
350: --
351: -- Call the supporting insert validate operations
352: --
374: -- Call to raise any errors on multi-message list
375: hr_multi_message.end_validation_set;
376: --
377: if g_debug then
378: hr_utility.set_location('Leaving:'||l_proc, 20);
379: end if;
380: end ins;
381: --
382: -- ----------------------------------------------------------------------------
391: l_rec hxc_lkr_shd.g_rec_type;
392: l_proc varchar2(72);
393: --
394: Begin
395: g_debug := hr_utility.debug_enabled;
396:
397: if g_debug then
398: l_proc := g_package||'ins';
399: hr_utility.set_location('Entering:'||l_proc, 5);
395: g_debug := hr_utility.debug_enabled;
396:
397: if g_debug then
398: l_proc := g_package||'ins';
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: end if;
401: --
402: -- Call conversion function to turn arguments into the
403: -- p_rec structure.
423: p_locker_type_requestor_id := l_rec.locker_type_requestor_id;
424: --
425: --
426: if g_debug then
427: hr_utility.set_location(' Leaving:'||l_proc, 10);
428: end if;
429: End ins;
430: --
431: end hxc_lkr_ins;