[Home] [Help]
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_tkgqc_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: --
21: --
22: l_proc varchar2(72) ;
23: --
24: Begin
25: g_debug :=hr_utility.debug_enabled;
26: if g_debug then
27: l_proc := g_package||'set_base_key_value';
28:
29: hr_utility.set_location('Entering:'||l_proc, 10);
25: g_debug :=hr_utility.debug_enabled;
26: if g_debug then
27: l_proc := g_package||'set_base_key_value';
28:
29: hr_utility.set_location('Entering:'||l_proc, 10);
30: end if;
31: --
32: hxc_tkgqc_ins.g_tk_group_query_criteria_id_i := p_tk_group_query_criteria_id;
33: --
31: --
32: hxc_tkgqc_ins.g_tk_group_query_criteria_id_i := p_tk_group_query_criteria_id;
33: --
34: if g_debug then
35: hr_utility.set_location(' Leaving:'||l_proc, 20);
36: end if;
37: End set_base_key_value;
38: --
39: --
88:
89: if g_debug then
90: l_proc := g_package||'insert_dml';
91:
92: hr_utility.set_location('Entering:'||l_proc, 5);
93: end if;
94: p_rec.object_version_number := 1; -- Initialise the object version
95: --
96: hxc_tkgqc_shd.g_api_dml := true; -- Set the api dml status
124: --
125: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
126: --
127: if g_debug then
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: end if;
130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
202:
203: if g_debug then
204: l_proc := g_package||'pre_insert';
205:
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: end if;
208: --
209: If (hxc_tkgqc_ins.g_tk_group_query_criteria_id_i is not null) Then
210: --
240: Close C_Sel1;
241: End If;
242: --
243: if g_debug then
244: hr_utility.set_location(' Leaving:'||l_proc, 10);
245: end if;
246: End pre_insert;
247: --
248: -- ----------------------------------------------------------------------------
285:
286: if g_debug then
287: l_proc := g_package||'post_insert';
288:
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: end if;
291: begin
292: --
293: hxc_tkgqc_rki.after_insert
313: --
314: end;
315: --
316: if g_debug then
317: hr_utility.set_location(' Leaving:'||l_proc, 10);
318: end if;
319: End post_insert;
320: --
321: -- ----------------------------------------------------------------------------
327: --
328: l_proc varchar2(72) ;
329: --
330: Begin
331: g_debug :=hr_utility.debug_enabled;
332: if g_debug then
333: l_proc := g_package||'ins';
334:
335: hr_utility.set_location('Entering:'||l_proc, 5);
331: g_debug :=hr_utility.debug_enabled;
332: if g_debug then
333: l_proc := g_package||'ins';
334:
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: end if;
337: --
338: -- Call the supporting insert validate operations
339: --
356: (p_rec
357: );
358: --
359: if g_debug then
360: hr_utility.set_location('Leaving:'||l_proc, 20);
361: end if;
362: end ins;
363: --
364: -- ----------------------------------------------------------------------------
375: l_rec hxc_tkgqc_shd.g_rec_type;
376: l_proc varchar2(72) ;
377: --
378: Begin
379: g_debug :=hr_utility.debug_enabled;
380: if g_debug then
381: l_proc := g_package||'ins';
382:
383: hr_utility.set_location('Entering:'||l_proc, 5);
379: g_debug :=hr_utility.debug_enabled;
380: if g_debug then
381: l_proc := g_package||'ins';
382:
383: hr_utility.set_location('Entering:'||l_proc, 5);
384: end if;
385: --
386: -- Call conversion function to turn arguments into the
387: -- p_rec structure.
408: p_tk_group_query_criteria_id := l_rec.tk_group_query_criteria_id;
409: p_object_version_number := l_rec.object_version_number;
410: --
411: if g_debug then
412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: end if;
414: End ins;
415: --
416: end hxc_tkgqc_ins;