DBA Data[Home] [Help]

APPS.PER_OBJ_INS dependencies on PER_OBJ_INS

Line 1: Package Body per_obj_ins as

1: Package Body per_obj_ins as
2: /* $Header: peobjrhi.pkb 120.20 2011/12/19 10:22:22 kgowripe ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 24: per_obj_ins.g_objective_id_i := p_objective_id;

20: --
21: Begin
22: hr_utility.set_location('Entering:'||l_proc, 10);
23: --
24: per_obj_ins.g_objective_id_i := p_objective_id;
25: --
26: hr_utility.set_location(' Leaving:'||l_proc, 20);
27: End set_base_key_value;
28: --

Line 288: per_obj_ins.g_objective_id_i;

284: Cursor C_Sel2 is
285: Select null
286: from per_objectives
287: where objective_id =
288: per_obj_ins.g_objective_id_i;
289: --
290:
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);

Line 297: IF (per_obj_ins.g_objective_id_i is not null)

293: --
294: --
295: -- Select the next sequence number
296: --
297: IF (per_obj_ins.g_objective_id_i is not null)
298: then
299: --
300: -- Verify registered primary key values not already in use
301: --

Line 317: p_rec.objective_id := per_obj_ins.g_objective_id_i;

313: Close C_Sel2;
314: --
315: -- Use registered key values and clear globals
316: --
317: p_rec.objective_id := per_obj_ins.g_objective_id_i;
318: per_obj_ins.g_objective_id_i := null;
319: Else
320:
321: Open C_Sel1;

Line 318: per_obj_ins.g_objective_id_i := null;

314: --
315: -- Use registered key values and clear globals
316: --
317: p_rec.objective_id := per_obj_ins.g_objective_id_i;
318: per_obj_ins.g_objective_id_i := null;
319: Else
320:
321: Open C_Sel1;
322: Fetch C_Sel1 Into p_rec.objective_id;

Line 736: end per_obj_ins;

732: --
733: hr_utility.set_location(' Leaving:'||l_proc, 10);
734: End ins;
735: --
736: end per_obj_ins;