eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CTK_INS dependencies on BEN_CTK_INS

Line 1: Package Body ben_ctk_ins as

1: Package Body ben_ctk_ins as
2: /* $Header: bectkrhi.pkb 120.0 2005/05/28 01:25 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ben_ctk_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
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.

Line 31: ben_ctk_ins.g_group_per_in_ler_id_i := p_group_per_in_ler_id;

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;
33: --
34: if g_debug then
35: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 32: ben_ctk_ins.g_task_id_i := p_task_id;

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;
33: --
34: if g_debug then
35: hr_utility.set_location(' Leaving:'||l_proc, 20);
36: end if;

Line 193: ben_ctk_ins.g_group_per_in_ler_id_i

189: Cursor C_Sel2 is
190: Select null
191: from ben_cwb_person_tasks
192: where group_per_in_ler_id =
193: ben_ctk_ins.g_group_per_in_ler_id_i
194: or task_id =
195: ben_ctk_ins.g_task_id_i;
196: --
197: l_proc varchar2(72) := g_package||'pre_insert';

Line 195: ben_ctk_ins.g_task_id_i;

191: from ben_cwb_person_tasks
192: where group_per_in_ler_id =
193: ben_ctk_ins.g_group_per_in_ler_id_i
194: or task_id =
195: ben_ctk_ins.g_task_id_i;
196: --
197: l_proc varchar2(72) := g_package||'pre_insert';
198: l_exists varchar2(1);
199: --

Line 205: If (ben_ctk_ins.g_group_per_in_ler_id_i is not null or

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
207: --
208: -- Verify registered primary key values not already in use
209: --

Line 206: ben_ctk_ins.g_task_id_i is not null) 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
207: --
208: -- Verify registered primary key values not already in use
209: --
210: Open C_Sel2;

Line 226: ben_ctk_ins.g_group_per_in_ler_id_i;

222: --
223: -- Use registered key values and clear globals
224: --
225: p_rec.group_per_in_ler_id :=
226: ben_ctk_ins.g_group_per_in_ler_id_i;
227: ben_ctk_ins.g_group_per_in_ler_id_i := null;
228: p_rec.task_id :=
229: ben_ctk_ins.g_task_id_i;
230: ben_ctk_ins.g_task_id_i := null;

Line 227: ben_ctk_ins.g_group_per_in_ler_id_i := null;

223: -- Use registered key values and clear globals
224: --
225: p_rec.group_per_in_ler_id :=
226: ben_ctk_ins.g_group_per_in_ler_id_i;
227: ben_ctk_ins.g_group_per_in_ler_id_i := null;
228: p_rec.task_id :=
229: ben_ctk_ins.g_task_id_i;
230: ben_ctk_ins.g_task_id_i := null;
231: Else

Line 229: ben_ctk_ins.g_task_id_i;

225: p_rec.group_per_in_ler_id :=
226: ben_ctk_ins.g_group_per_in_ler_id_i;
227: ben_ctk_ins.g_group_per_in_ler_id_i := null;
228: p_rec.task_id :=
229: ben_ctk_ins.g_task_id_i;
230: ben_ctk_ins.g_task_id_i := null;
231: Else
232: null;
233: /* --

Line 230: ben_ctk_ins.g_task_id_i := null;

226: ben_ctk_ins.g_group_per_in_ler_id_i;
227: ben_ctk_ins.g_group_per_in_ler_id_i := null;
228: p_rec.task_id :=
229: ben_ctk_ins.g_task_id_i;
230: ben_ctk_ins.g_task_id_i := null;
231: Else
232: null;
233: /* --
234: -- No registerd key values, so select the next sequence number

Line 354: ben_ctk_ins.pre_insert(p_rec);

350: hr_multi_message.end_validation_set;
351: --
352: -- Call the supporting pre-insert operation
353: --
354: ben_ctk_ins.pre_insert(p_rec);
355: --
356: -- Insert the row
357: --
358: ben_ctk_ins.insert_dml(p_rec);

Line 358: ben_ctk_ins.insert_dml(p_rec);

354: ben_ctk_ins.pre_insert(p_rec);
355: --
356: -- Insert the row
357: --
358: ben_ctk_ins.insert_dml(p_rec);
359: --
360: -- Call the supporting post-insert operation
361: --
362: ben_ctk_ins.post_insert

Line 362: ben_ctk_ins.post_insert

358: ben_ctk_ins.insert_dml(p_rec);
359: --
360: -- Call the supporting post-insert operation
361: --
362: ben_ctk_ins.post_insert
363: (p_rec
364: );
365: --
366: -- Call to raise any errors on multi-message list

Line 416: ben_ctk_ins.ins

412: --
413: -- Having converted the arguments into the ben_ctk_rec
414: -- plsql record structure we call the corresponding record business process.
415: --
416: ben_ctk_ins.ins
417: (l_rec
418: );
419: --
420: --

Line 428: end ben_ctk_ins;

424: hr_utility.set_location(' Leaving:'||l_proc, 10);
425: end if;
426: End ins;
427: --
428: end ben_ctk_ins;