5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_ulp_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: --
104: --
105: --
106: --
107: if g_debug then
108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: end if;
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
176: Begin
177:
178: if g_debug then
179: l_proc := g_package||'pre_insert';
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: end if;
182: --
183: --
184: -- Select the next sequence number
187: Fetch C_Sel1 Into p_rec.layout_comp_prompt_id;
188: Close C_Sel1;
189: --
190: if g_debug then
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
192: end if;
193: End pre_insert;
194: --
195: -- ----------------------------------------------------------------------------
233: Begin
234:
235: if g_debug then
236: l_proc := g_package||'post_insert';
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: end if;
239: begin
240: --
241: hxc_ulp_rki.after_insert
269: --
270: end;
271: --
272: if g_debug then
273: hr_utility.set_location(' Leaving:'||l_proc, 10);
274: end if;
275: End post_insert;
276: --
277: -- ----------------------------------------------------------------------------
283: --
284: l_proc varchar2(72) ;
285: --
286: Begin
287: g_debug :=hr_utility.debug_enabled;
288: if g_debug then
289: l_proc := g_package||'ins';
290: hr_utility.set_location('Entering:'||l_proc, 5);
291: end if;
286: Begin
287: g_debug :=hr_utility.debug_enabled;
288: if g_debug then
289: l_proc := g_package||'ins';
290: hr_utility.set_location('Entering:'||l_proc, 5);
291: end if;
292: --
293: -- Call the supporting insert validate operations
294: --
310: (p_rec
311: );
312: --
313: if g_debug then
314: hr_utility.set_location('Leaving:'||l_proc, 20);
315: end if;
316: end ins;
317: --
318: -- ----------------------------------------------------------------------------
333: l_rec hxc_ulp_shd.g_rec_type;
334: l_proc varchar2(72) ;
335: --
336: Begin
337: g_debug :=hr_utility.debug_enabled;
338: if g_debug then
339: l_proc := g_package||'ins';
340: hr_utility.set_location('Entering:'||l_proc, 5);
341: end if;
336: Begin
337: g_debug :=hr_utility.debug_enabled;
338: if g_debug then
339: l_proc := g_package||'ins';
340: hr_utility.set_location('Entering:'||l_proc, 5);
341: end if;
342: --
343: -- Call conversion function to turn arguments into the
344: -- p_rec structure.
369: p_layout_comp_prompt_id := l_rec.layout_comp_prompt_id;
370: p_object_version_number := l_rec.object_version_number;
371: --
372: if g_debug then
373: hr_utility.set_location(' Leaving:'||l_proc, 10);
374: end if;
375: End ins;
376: --
377: end hxc_ulp_ins;