APPS.PER_SPH_INS dependencies on PER_SPH_INS

Line 1: Package Body per_sph_ins as

1: Package Body per_sph_ins as
2: /* $Header: pesphrhi.pkb 120.4 2011/05/06 09:30:35 vkodedal noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_sph_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_sph_ins.g_plan_id_i := p_plan_id;

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

Line 239: per_sph_ins.g_plan_id_i;

235: Cursor C_Sel2 is
236: Select null
237: from per_sp_plan
238: where plan_id =
239: per_sph_ins.g_plan_id_i;
240: --
241: l_proc varchar2(72) := g_package||'pre_insert';
242: l_exists varchar2(1);
243: --

Line 247: If (per_sph_ins.g_plan_id_i is not null) Then

243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: If (per_sph_ins.g_plan_id_i is not null) Then
248: --
249: -- Verify registered primary key values not already in use
250: --
251: Open C_Sel2;

Line 267: per_sph_ins.g_plan_id_i;

263: --
264: -- Use registered key values and clear globals
265: --
266: p_rec.plan_id :=
267: per_sph_ins.g_plan_id_i;
268: per_sph_ins.g_plan_id_i := null;
269: Else
270: --
271: -- No registerd key values, so select the next sequence number

Line 268: per_sph_ins.g_plan_id_i := null;

264: -- Use registered key values and clear globals
265: --
266: p_rec.plan_id :=
267: per_sph_ins.g_plan_id_i;
268: per_sph_ins.g_plan_id_i := null;
269: Else
270: --
271: -- No registerd key values, so select the next sequence number
272: --

Line 443: per_sph_ins.pre_insert(p_rec);

439: hr_multi_message.end_validation_set;
440: --
441: -- Call the supporting pre-insert operation
442: --
443: per_sph_ins.pre_insert(p_rec);
444: --
445: -- Insert the row
446: --
447: per_sph_ins.insert_dml(p_rec);

Line 447: per_sph_ins.insert_dml(p_rec);

443: per_sph_ins.pre_insert(p_rec);
444: --
445: -- Insert the row
446: --
447: per_sph_ins.insert_dml(p_rec);
448: --
449: -- Call the supporting post-insert operation
450: --
451: per_sph_ins.post_insert

Line 451: per_sph_ins.post_insert

447: per_sph_ins.insert_dml(p_rec);
448: --
449: -- Call the supporting post-insert operation
450: --
451: per_sph_ins.post_insert
452: (p_effective_date
453: ,p_rec
454: );
455: --

Line 559: per_sph_ins.ins

555: --
556: -- Having converted the arguments into the per_sph_rec
557: -- plsql record structure we call the corresponding record business process.
558: --
559: per_sph_ins.ins
560: (p_effective_date
561: ,l_rec
562: );
563: --

Line 573: end per_sph_ins;

569: --
570: hr_utility.set_location(' Leaving:'||l_proc, 10);
571: End ins;
572: --
573: end per_sph_ins;