[Home] [Help]
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ben_ctk_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: --
24: l_proc varchar2(72) := g_package||'set_base_key_value';
25: --
26: Begin
27: if g_debug then
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: end if;
30: --
31: ben_ctk_ins.g_group_per_in_ler_id_i := p_group_per_in_ler_id;
32: ben_ctk_ins.g_task_id_i := p_task_id;
31: ben_ctk_ins.g_group_per_in_ler_id_i := p_group_per_in_ler_id;
32: ben_ctk_ins.g_task_id_i := p_task_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: --
87: l_proc varchar2(72) := g_package||'insert_dml';
88: --
89: Begin
90: if g_debug then
91: hr_utility.set_location('Entering:'||l_proc, 5);
92: end if;
93: p_rec.object_version_number := 1; -- Initialise the object version
94: --
95: ben_ctk_shd.g_api_dml := true; -- Set the api dml status
121: --
122: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
123: --
124: if g_debug then
125: hr_utility.set_location(' Leaving:'||l_proc, 10);
126: end if;
127: Exception
128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
198: l_exists varchar2(1);
199: --
200: Begin
201: if g_debug then
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: end if;
204: --
205: If (ben_ctk_ins.g_group_per_in_ler_id_i is not null or
206: ben_ctk_ins.g_task_id_i is not null) Then
241: Close C_Sel1; */
242: End If;
243: --
244: if g_debug then
245: hr_utility.set_location(' Leaving:'||l_proc, 10);
246: end if;
247: End pre_insert;
248: --
249: -- ----------------------------------------------------------------------------
285: l_proc varchar2(72) := g_package||'post_insert';
286: --
287: Begin
288: if g_debug then
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: end if;
291: begin
292: --
293: ben_ctk_rki.after_insert
321: --
322: end;
323: --
324: if g_debug then
325: hr_utility.set_location(' Leaving:'||l_proc, 10);
326: end if;
327: End post_insert;
328: --
329: -- ----------------------------------------------------------------------------
336: l_proc varchar2(72) := g_package||'ins';
337: --
338: Begin
339: if g_debug then
340: hr_utility.set_location('Entering:'||l_proc, 5);
341: end if;
342: --
343: -- Call the supporting insert validate operations
344: --
366: -- Call to raise any errors on multi-message list
367: hr_multi_message.end_validation_set;
368: --
369: if g_debug then
370: hr_utility.set_location('Leaving:'||l_proc, 20);
371: end if;
372: end ins;
373: --
374: -- ----------------------------------------------------------------------------
390: l_proc varchar2(72) := g_package||'ins';
391: --
392: Begin
393: if g_debug then
394: hr_utility.set_location('Entering:'||l_proc, 5);
395: end if;
396: --
397: -- Call conversion function to turn arguments into the
398: -- p_rec structure.
420: --
421: p_object_version_number := l_rec.object_version_number;
422: --
423: if g_debug then
424: hr_utility.set_location(' Leaving:'||l_proc, 10);
425: end if;
426: End ins;
427: --
428: end ben_ctk_ins;