5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_hrt_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: p_rec.object_version_number := 1; -- Initialise the object version
66: --
67: --
95: --
96: --
97: --
98: if g_debug then
99: hr_utility.set_location(' Leaving:'||l_proc, 10);
100: end if;
101: Exception
102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
166: --
167: Begin
168: if g_debug then
169: l_proc := g_package||'pre_insert';
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: end if;
172: --
173: --
174: -- Select the next sequence number
177: Fetch C_Sel1 Into p_rec.retrieval_process_id;
178: Close C_Sel1;
179: --
180: if g_debug then
181: hr_utility.set_location(' Leaving:'||l_proc, 10);
182: end if;
183: End pre_insert;
184: --
185: -- ----------------------------------------------------------------------------
223: --
224: Begin
225: if g_debug then
226: l_proc := g_package||'post_insert';
227: hr_utility.set_location('Entering:'||l_proc, 5);
228: end if;
229: begin
230: --
231: hxc_hrt_rki.after_insert
252: --
253: end;
254: --
255: if g_debug then
256: hr_utility.set_location(' Leaving:'||l_proc, 10);
257: end if;
258: End post_insert;
259: --
260: -- ----------------------------------------------------------------------------
267: --
268: l_proc varchar2(72);
269: --
270: Begin
271: g_debug:=hr_utility.debug_enabled;
272: if g_debug then
273: l_proc := g_package||'ins';
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: end if;
270: Begin
271: g_debug:=hr_utility.debug_enabled;
272: if g_debug then
273: l_proc := g_package||'ins';
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: end if;
276: --
277: -- Call the supporting insert validate operations
278: --
296: ,p_rec
297: );
298: --
299: if g_debug then
300: hr_utility.set_location('Leaving:'||l_proc, 20);
301: end if;
302: end ins;
303: --
304: -- ----------------------------------------------------------------------------
316: l_rec hxc_hrt_shd.g_rec_type;
317: l_proc varchar2(72);
318: --
319: Begin
320: g_debug:=hr_utility.debug_enabled;
321: if g_debug then
322: l_proc := g_package||'ins';
323: hr_utility.set_location('Entering:'||l_proc, 5);
324: end if;
319: Begin
320: g_debug:=hr_utility.debug_enabled;
321: if g_debug then
322: l_proc := g_package||'ins';
323: hr_utility.set_location('Entering:'||l_proc, 5);
324: end if;
325: --
326: -- Call conversion function to turn arguments into the
327: -- p_rec structure.
349: p_retrieval_process_id := l_rec.retrieval_process_id;
350: p_object_version_number := l_rec.object_version_number;
351: --
352: if g_debug then
353: hr_utility.set_location(' Leaving:'||l_proc, 10);
354: end if;
355: End ins;
356: --
357: end hxc_hrt_ins;