APPS.PER_PAR_INS dependencies on PER_PAR_INS

Line 1: Package Body per_par_ins as

1: Package Body per_par_ins as
2: /* $Header: peparrhi.pkb 120.1.12020000.2 2012/11/16 07:55:56 kgowripe ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 24: per_par_ins.g_participant_id_i := p_participant_id;

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

Line 220: per_par_ins.g_participant_id_i;

216: Cursor C_Sel2 is
217: Select null
218: from per_participants
219: where participant_id =
220: per_par_ins.g_participant_id_i;
221: --
222:
223: Begin
224: hr_utility.set_location('Entering:'||l_proc, 5);

Line 229: IF (per_par_ins.g_participant_id_i is not null)

225: --
226: --
227: -- Select the next sequence number
228: --
229: IF (per_par_ins.g_participant_id_i is not null)
230: then
231: --
232: -- Verify registered primary key values not already in use
233: --

Line 249: p_rec.participant_id := per_par_ins.g_participant_id_i;

245: Close C_Sel2;
246: --
247: -- Use registered key values and clear globals
248: --
249: p_rec.participant_id := per_par_ins.g_participant_id_i;
250: per_par_ins.g_participant_id_i := null;
251: Else
252:
253: Open C_Sel1;

Line 250: per_par_ins.g_participant_id_i := null;

246: --
247: -- Use registered key values and clear globals
248: --
249: p_rec.participant_id := per_par_ins.g_participant_id_i;
250: per_par_ins.g_participant_id_i := null;
251: Else
252:
253: Open C_Sel1;
254: Fetch C_Sel1 Into p_rec.participant_id;

Line 525: end per_par_ins;

521: --
522: hr_utility.set_location(' Leaving:'||l_proc, 10);
523: End ins;
524: --
525: end per_par_ins;