5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_ulc_ins.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< insert_dml >------------------------------|
13: -- ----------------------------------------------------------------------------
60: Begin
61:
62: if g_debug then
63: l_proc := g_package||'insert_dml';
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: end if;
66: p_rec.object_version_number := 1; -- Initialise the object version
67: --
68: --
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
198: Begin
199:
200: if g_debug then
201: l_proc := g_package||'pre_insert';
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: end if;
204: --
205: --
206: -- Select the next sequence number
209: Fetch C_Sel1 Into p_rec.layout_component_id;
210: Close C_Sel1;
211: --
212: if g_debug then
213: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: end if;
215: End pre_insert;
216: --
217: -- ----------------------------------------------------------------------------
256:
257: if g_debug then
258: l_proc := g_package||'post_insert';
259:
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: end if;
262: begin
263: --
264: hxc_ulc_rki.after_insert
314: --
315: end;
316: --
317: if g_debug then
318: hr_utility.set_location(' Leaving:'||l_proc, 10);
319: end if;
320: End post_insert;
321: --
322: -- ----------------------------------------------------------------------------
328: --
329: l_proc varchar2(72) ;
330: --
331: Begin
332: g_debug :=hr_utility.debug_enabled;
333: if g_debug then
334: l_proc := g_package||'ins';
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: end if;
331: Begin
332: g_debug :=hr_utility.debug_enabled;
333: if g_debug then
334: l_proc := g_package||'ins';
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: end if;
337: --
338: -- Call the supporting insert validate operations
339: --
355: (p_rec
356: );
357: --
358: if g_debug then
359: hr_utility.set_location('Leaving:'||l_proc, 20);
360: end if;
361: end ins;
362: --
363: -- ----------------------------------------------------------------------------
389: l_rec hxc_ulc_shd.g_rec_type;
390: l_proc varchar2(72) ;
391: --
392: Begin
393: g_debug :=hr_utility.debug_enabled;
394: if g_debug then
395: l_proc := g_package||'ins';
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: end if;
392: Begin
393: g_debug :=hr_utility.debug_enabled;
394: if g_debug then
395: l_proc := g_package||'ins';
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: end if;
398: --
399: -- Call conversion function to turn arguments into the
400: -- p_rec structure.
436: p_layout_component_id := l_rec.layout_component_id;
437: p_object_version_number := l_rec.object_version_number;
438: --
439: if g_debug then
440: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: end if;
442: End ins;
443: --
444: end hxc_ulc_ins;