APPS.BEN_ELP_INS dependencies on BEN_ELP_INS

Line 1: Package Body ben_elp_ins as

1: Package Body ben_elp_ins as
2: /* $Header: beelprhi.pkb 120.5 2007/01/24 05:18:55 rgajula ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 40: ben_elp_ins.g_eligy_prfl_id_i := p_eligy_prfl_id;

36: --
37: Begin
38: hr_utility.set_location('Entering:'||l_proc, 10);
39: --
40: ben_elp_ins.g_eligy_prfl_id_i := p_eligy_prfl_id;
41: --
42: hr_utility.set_location(' Leaving:'||l_proc, 20);
43: End set_base_key_value;
44:

Line 494: ben_elp_ins.g_eligy_prfl_id_i;

490: Cursor C_Sel2 is
491: Select null
492: from ben_eligy_prfl_f
493: where eligy_prfl_id =
494: ben_elp_ins.g_eligy_prfl_id_i;
495: Begin
496: hr_utility.set_location('Entering:'||l_proc, 5);
497: --
498: --

Line 500: If (ben_elp_ins.g_eligy_prfl_id_i is not null) Then

496: hr_utility.set_location('Entering:'||l_proc, 5);
497: --
498: --
499: --
500: If (ben_elp_ins.g_eligy_prfl_id_i is not null) Then
501: --
502: -- Verify registered primary key values not already in use
503: --
504: Open C_Sel2;

Line 516: p_rec.eligy_prfl_id:=ben_elp_ins.g_eligy_prfl_id_i;

512: fnd_message.set_token('TABLE_NAME','ben_eligy_prfl_f');
513: fnd_message.raise_error;
514: End if;
515: Close C_Sel2;
516: p_rec.eligy_prfl_id:=ben_elp_ins.g_eligy_prfl_id_i;
517: ben_elp_ins.g_eligy_prfl_id_i:=null;
518: ELSE
519: open c1;
520: fetch c1 into p_rec.eligy_prfl_id;

Line 517: ben_elp_ins.g_eligy_prfl_id_i:=null;

513: fnd_message.raise_error;
514: End if;
515: Close C_Sel2;
516: p_rec.eligy_prfl_id:=ben_elp_ins.g_eligy_prfl_id_i;
517: ben_elp_ins.g_eligy_prfl_id_i:=null;
518: ELSE
519: open c1;
520: fetch c1 into p_rec.eligy_prfl_id;
521: close c1;

Line 1087: end ben_elp_ins;

1083: --
1084: hr_utility.set_location(' Leaving:'||l_proc, 10);
1085: End ins;
1086: --
1087: end ben_elp_ins;