APPS.PER_EVT_INS dependencies on PER_EVT_INS

Line 1: Package Body per_evt_ins as

1: Package Body per_evt_ins as
2: /* $Header: peevtrhi.pkb 120.2 2008/04/30 11:32:10 uuddavol ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_evt_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_evt_ins.g_event_id_i := p_event_id;

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

Line 253: per_evt_ins.g_event_id_i;

249: Cursor C_Sel2 is
250: Select null
251: from per_events
252: where event_id =
253: per_evt_ins.g_event_id_i;
254: --
255: l_proc varchar2(72) := g_package||'pre_insert';
256: l_exists varchar2(1);
257: --

Line 261: If (per_evt_ins.g_event_id_i is not null) Then

257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: If (per_evt_ins.g_event_id_i is not null) Then
262: --
263: -- Verify registered primary key values not already in use
264: --
265: Open C_Sel2;

Line 281: per_evt_ins.g_event_id_i;

277: --
278: -- Use registered key values and clear globals
279: --
280: p_rec.event_id :=
281: per_evt_ins.g_event_id_i;
282: per_evt_ins.g_event_id_i := null;
283: Else
284: --
285: -- No registerd key values, so select the next sequence number

Line 282: per_evt_ins.g_event_id_i := null;

278: -- Use registered key values and clear globals
279: --
280: p_rec.event_id :=
281: per_evt_ins.g_event_id_i;
282: per_evt_ins.g_event_id_i := null;
283: Else
284: --
285: -- No registerd key values, so select the next sequence number
286: --

Line 462: per_evt_ins.pre_insert(p_rec);

458: );
459: --
460: -- Call the supporting pre-insert operation
461: --
462: per_evt_ins.pre_insert(p_rec);
463: --
464: -- Insert the row
465: --
466: per_evt_ins.insert_dml(p_rec);

Line 466: per_evt_ins.insert_dml(p_rec);

462: per_evt_ins.pre_insert(p_rec);
463: --
464: -- Insert the row
465: --
466: per_evt_ins.insert_dml(p_rec);
467: --
468: -- Call the supporting post-insert operation
469: --
470: per_evt_ins.post_insert

Line 470: per_evt_ins.post_insert

466: per_evt_ins.insert_dml(p_rec);
467: --
468: -- Call the supporting post-insert operation
469: --
470: per_evt_ins.post_insert
471: (p_rec
472: );
473: --
474: hr_utility.set_location('Leaving:'||l_proc, 20);

Line 585: per_evt_ins.ins

581: --
582: -- Having converted the arguments into the per_evt_rec
583: -- plsql record structure we call the corresponding record business process.
584: --
585: per_evt_ins.ins
586: (l_rec
587: );
588: --
589: -- As the primary key argument(s)

Line 598: end per_evt_ins;

594: --
595: hr_utility.set_location(' Leaving:'||l_proc, 20);
596: End ins;
597: --
598: end per_evt_ins;