APPS.PER_CEL_INS dependencies on PER_CEL_INS

Line 1: Package Body per_cel_ins as

1: Package Body per_cel_ins as
2: /* $Header: pecelrhi.pkb 120.3.12020000.3 2012/07/05 01:49:58 amnaraya ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_cel_ins.'; -- Global package name
9: --
10: --
11: -- The following global variables are only to be used by
12: -- the set_base_key_value and pre_insert procedures.

Line 27: per_cel_ins.g_competence_element_id_i := p_competence_element_id;

23: --
24: Begin
25: hr_utility.set_location('Entering:'||l_proc, 10);
26: --
27: per_cel_ins.g_competence_element_id_i := p_competence_element_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
30: End set_base_key_value;
31: --

Line 329: where competence_element_id = per_cel_ins.g_competence_element_id_i;

325: --
326: Cursor C_Sel2 is
327: select null
328: from per_competence_elements
329: where competence_element_id = per_cel_ins.g_competence_element_id_i;
330: --
331: Begin
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --

Line 334: if per_cel_ins.g_competence_element_id_i is not null then

330: --
331: Begin
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: if per_cel_ins.g_competence_element_id_i is not null then
335: --
336: -- Verify registered primary key values not already in use
337: --
338: Open C_Sel2;

Line 354: per_cel_ins.g_competence_element_id_i;

350: --
351: -- Use registered key values and clear globals
352: --
353: p_rec.competence_element_id :=
354: per_cel_ins.g_competence_element_id_i;
355: per_cel_ins.g_competence_element_id_i := null;
356: --
357: else
358: --

Line 355: per_cel_ins.g_competence_element_id_i := null;

351: -- Use registered key values and clear globals
352: --
353: p_rec.competence_element_id :=
354: per_cel_ins.g_competence_element_id_i;
355: per_cel_ins.g_competence_element_id_i := null;
356: --
357: else
358: --
359: -- Select the next sequence number

Line 780: end per_cel_ins;

776: --
777: hr_utility.set_location(' Leaving:'||l_proc, 10);
778: End ins;
779: --
780: end per_cel_ins;