5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_hsd_ins.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following global variables are only to be used by
12: -- the set_base_key_value and pre_insert procedures.
13: --
23: --
24: l_proc varchar2(72);
25: --
26: Begin
27: g_debug:=hr_utility.debug_enabled;
28: if g_debug then
29: l_proc := g_package||'set_base_key_value';
30: hr_utility.set_location('Entering:'||l_proc, 10);
31: end if;
26: Begin
27: g_debug:=hr_utility.debug_enabled;
28: if g_debug then
29: l_proc := g_package||'set_base_key_value';
30: hr_utility.set_location('Entering:'||l_proc, 10);
31: end if;
32: --
33: hxc_hsd_ins.g_object_id_i := p_object_id;
34: hxc_hsd_ins.g_object_type_i := p_object_type;
33: hxc_hsd_ins.g_object_id_i := p_object_id;
34: hxc_hsd_ins.g_object_type_i := p_object_type;
35: --
36: if g_debug then
37: hr_utility.set_location(' Leaving:'||l_proc, 20);
38: end if;
39: End set_base_key_value;
40: --
41: --
90: --
91: Begin
92: if g_debug then
93: l_proc := g_package||'insert_dml';
94: hr_utility.set_location('Entering:'||l_proc, 5);
95: end if;
96: --
97: --
98: --
114: --
115: --
116: --
117: if g_debug then
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: end if;
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
193: --
194: Begin
195: if g_debug then
196: l_proc := g_package||'pre_insert';
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: end if;
199: --
200: If (hxc_hsd_ins.g_object_id_i is not null or
201: hxc_hsd_ins.g_object_type_i is not null) Then
236: null;
237: End If;
238: --
239: if g_debug then
240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: end if;
242: End pre_insert;
243: --
244: -- ----------------------------------------------------------------------------
281: --
282: Begin
283: if g_debug then
284: l_proc := g_package||'post_insert';
285: hr_utility.set_location('Entering:'||l_proc, 5);
286: end if;
287: begin
288: --
289: hxc_hsd_rki.after_insert
307: --
308: end;
309: --
310: if g_debug then
311: hr_utility.set_location(' Leaving:'||l_proc, 10);
312: end if;
313: End post_insert;
314: --
315: -- ----------------------------------------------------------------------------
321: --
322: l_proc varchar2(72);
323: --
324: Begin
325: g_debug:=hr_utility.debug_enabled;
326: if g_debug then
327: l_proc := g_package||'ins';
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: end if;
324: Begin
325: g_debug:=hr_utility.debug_enabled;
326: if g_debug then
327: l_proc := g_package||'ins';
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: end if;
330: --
331: -- Call the supporting insert validate operations
332: --
354: -- Call to raise any errors on multi-message list
355: hr_multi_message.end_validation_set;
356: --
357: if g_debug then
358: hr_utility.set_location('Leaving:'||l_proc, 20);
359: end if;
360: end ins;
361: --
362: -- ----------------------------------------------------------------------------
372: l_rec hxc_hsd_shd.g_rec_type;
373: l_proc varchar2(72);
374: --
375: Begin
376: g_debug:=hr_utility.debug_enabled;
377: if g_debug then
378: l_proc := g_package||'ins';
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: end if;
375: Begin
376: g_debug:=hr_utility.debug_enabled;
377: if g_debug then
378: l_proc := g_package||'ins';
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: end if;
381: --
382: -- Call conversion function to turn arguments into the
383: -- p_rec structure.
398: );
399: --
400: --
401: if g_debug then
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
403: end if;
404: End ins;
405: --
406: end hxc_hsd_ins;