APPS.BEN_EOU_INS dependencies on BEN_EOU_INS

Line 1: Package Body ben_eou_ins as

1: Package Body ben_eou_ins as
2: /* $Header: beeourhi.pkb 120.2 2006/02/27 00:41:49 rtagarra noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ben_eou_ins.'; -- Global package name
9: --
10: --
11: g_elig_org_unit_prte_id_i number default null;
12:

Line 21: ben_eou_ins.g_elig_org_unit_prte_id_i := p_elig_org_unit_prte_id;

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 10);
20: --
21: ben_eou_ins.g_elig_org_unit_prte_id_i := p_elig_org_unit_prte_id;
22: --
23: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: End set_base_key_value;
25: -- ----------------------------------------------------------------------------

Line 344: where elig_org_unit_prte_id = ben_eou_ins.g_elig_org_unit_prte_id_i;

340: --
341: Cursor C_Sel2 is
342: Select null
343: from ben_elig_org_unit_prte_f
344: where elig_org_unit_prte_id = ben_eou_ins.g_elig_org_unit_prte_id_i;
345: --
346: l_proc varchar2(72) := g_package||'pre_insert';
347: l_exists varchar2(1);
348: --

Line 352: If (ben_eou_ins.g_elig_org_unit_prte_id_i is not null) Then

348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: If (ben_eou_ins.g_elig_org_unit_prte_id_i is not null) Then
353: --
354: -- Verify registered primary key values not already in use
355: --
356: Open C_Sel2;

Line 371: p_rec.elig_org_unit_prte_id:= ben_eou_ins.g_elig_org_unit_prte_id_i;

367: Close C_Sel2;
368: --
369: -- Use registered key values and clear globals
370: --
371: p_rec.elig_org_unit_prte_id:= ben_eou_ins.g_elig_org_unit_prte_id_i;
372: ben_eou_ins.g_elig_org_unit_prte_id_i := null;
373: Else
374: --
375: open c1;

Line 372: ben_eou_ins.g_elig_org_unit_prte_id_i := null;

368: --
369: -- Use registered key values and clear globals
370: --
371: p_rec.elig_org_unit_prte_id:= ben_eou_ins.g_elig_org_unit_prte_id_i;
372: ben_eou_ins.g_elig_org_unit_prte_id_i := null;
373: Else
374: --
375: open c1;
376: fetch c1 into p_rec.elig_org_unit_prte_id;

Line 760: end ben_eou_ins;

756: --
757: hr_utility.set_location(' Leaving:'||l_proc, 10);
758: End ins;
759: --
760: end ben_eou_ins;