DBA Data[Home] [Help]

APPS.BEN_EJP_INS dependencies on BEN_EJP_INS

Line 1: Package Body ben_ejp_ins as

1: Package Body ben_ejp_ins as
2: /* $Header: beejprhi.pkb 120.2 2006/02/27 00:35:00 rtagarra noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 22: ben_ejp_ins.g_elig_job_prte_id_i := p_elig_job_prte_id;

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 10);
21: --
22: ben_ejp_ins.g_elig_job_prte_id_i := p_elig_job_prte_id;
23: --
24: hr_utility.set_location(' Leaving:'||l_proc, 20);
25: End set_base_key_value;
26:

Line 348: where elig_job_prte_id = ben_ejp_ins.g_elig_job_prte_id_i;

344: --
345: Cursor C_Sel2 is
346: Select null
347: from ben_elig_job_prte_f
348: where elig_job_prte_id = ben_ejp_ins.g_elig_job_prte_id_i;
349: --
350: l_proc varchar2(72) := g_package||'pre_insert';
351: l_exists varchar2(1);
352: --

Line 356: If (ben_ejp_ins.g_elig_job_prte_id_i is not null) Then

352: --
353: Begin
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: If (ben_ejp_ins.g_elig_job_prte_id_i is not null) Then
357: --
358: -- Verify registered primary key values not already in use
359: --
360: Open C_Sel2;

Line 375: p_rec.elig_job_prte_id:= ben_ejp_ins.g_elig_job_prte_id_i;

371: Close C_Sel2;
372: --
373: -- Use registered key values and clear globals
374: --
375: p_rec.elig_job_prte_id:= ben_ejp_ins.g_elig_job_prte_id_i;
376: ben_ejp_ins.g_elig_job_prte_id_i := null;
377: Else
378: --
379: --

Line 376: ben_ejp_ins.g_elig_job_prte_id_i := null;

372: --
373: -- Use registered key values and clear globals
374: --
375: p_rec.elig_job_prte_id:= ben_ejp_ins.g_elig_job_prte_id_i;
376: ben_ejp_ins.g_elig_job_prte_id_i := null;
377: Else
378: --
379: --
380: open c1;

Line 769: end ben_ejp_ins;

765: --
766: hr_utility.set_location(' Leaving:'||l_proc, 10);
767: End ins;
768: --
769: end ben_ejp_ins;