APPS.PER_QUA_INS dependencies on PER_QUA_INS

Line 1: Package Body per_qua_ins as

1: Package Body per_qua_ins as
2: /* $Header: pequarhi.pkb 120.1 2008/03/14 10:01:46 viviswan noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 26: per_qua_ins.g_qualification_id_i := p_qualification_id;

22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_qua_ins.g_qualification_id_i := p_qualification_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --

Line 308: where qualification_id = per_qua_ins.g_qualification_id_i;

304: --
305: Cursor C_Sel2 is
306: select null
307: from per_qualifications
308: where qualification_id = per_qua_ins.g_qualification_id_i;
309: --
310:
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);

Line 314: if per_qua_ins.g_qualification_id_i is not null then

310:
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: if per_qua_ins.g_qualification_id_i is not null then
315: --
316: -- Verify registered primary key values not already in use
317: --
318: Open C_Sel2;

Line 334: per_qua_ins.g_qualification_id_i;

330: --
331: -- Use registered key values and clear globals
332: --
333: p_rec.qualification_id :=
334: per_qua_ins.g_qualification_id_i;
335: per_qua_ins.g_qualification_id_i := null;
336: --
337: else
338: --

Line 335: per_qua_ins.g_qualification_id_i := null;

331: -- Use registered key values and clear globals
332: --
333: p_rec.qualification_id :=
334: per_qua_ins.g_qualification_id_i;
335: per_qua_ins.g_qualification_id_i := null;
336: --
337: else
338: --
339: -- Select the next sequence number

Line 729: end per_qua_ins;

725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 10);
727: End ins;
728: --
729: end per_qua_ins;