APPS.PER_SPS_INS dependencies on PER_SPS_INS

Line 1: Package Body per_sps_ins as

1: Package Body per_sps_ins as
2: /* $Header: pespsrhi.pkb 120.5.12000000.1 2007/01/22 04:39:24 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_sps_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_sps_ins.g_step_id_i := p_step_id;

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

Line 294: per_sps_ins.dt_insert_dml

290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: per_sps_ins.dt_insert_dml
295: (p_rec => p_rec
296: ,p_effective_date => p_effective_date
297: ,p_datetrack_mode => p_datetrack_mode
298: ,p_validation_start_date => p_validation_start_date

Line 358: per_sps_ins.g_step_id_i;

354: Cursor C_Sel2 is
355: Select null
356: from per_spinal_point_steps_f
357: where step_id =
358: per_sps_ins.g_step_id_i;
359: --
360: l_proc varchar2(72) := g_package||'pre_insert';
361: l_exists varchar2(1);
362: --

Line 366: If (per_sps_ins.g_step_id_i is not null) Then

362: --
363: Begin
364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: If (per_sps_ins.g_step_id_i is not null) Then
367: --
368: -- Verify registered primary key values not already in use
369: --
370: Open C_Sel2;

Line 386: per_sps_ins.g_step_id_i;

382: --
383: -- Use registered key values and clear globals
384: --
385: p_rec.step_id :=
386: per_sps_ins.g_step_id_i;
387: per_sps_ins.g_step_id_i := null;
388: Else
389: --
390: -- No registerd key values, so select the next sequence number

Line 387: per_sps_ins.g_step_id_i := null;

383: -- Use registered key values and clear globals
384: --
385: p_rec.step_id :=
386: per_sps_ins.g_step_id_i;
387: per_sps_ins.g_step_id_i := null;
388: Else
389: --
390: -- No registerd key values, so select the next sequence number
391: --

Line 735: per_sps_ins.ins_lck

731: hr_utility.set_location('Entering:'||l_proc, 5);
732: --
733: -- Call the lock operation
734: --
735: per_sps_ins.ins_lck
736: (p_effective_date => p_effective_date
737: ,p_datetrack_mode => l_datetrack_mode
738: ,p_rec => p_rec
739: ,p_validation_start_date => l_validation_start_date

Line 758: per_sps_ins.pre_insert

754: hr_multi_message.end_validation_set;
755: --
756: -- Call the supporting pre-insert operation
757: --
758: per_sps_ins.pre_insert
759: (p_rec => p_rec
760: ,p_effective_date => p_effective_date
761: ,p_datetrack_mode => l_datetrack_mode
762: ,p_validation_start_date => l_validation_start_date

Line 768: per_sps_ins.insert_dml

764: );
765: --
766: -- Insert the row
767: --
768: per_sps_ins.insert_dml
769: (p_rec => p_rec
770: ,p_effective_date => p_effective_date
771: ,p_datetrack_mode => l_datetrack_mode
772: ,p_validation_start_date => l_validation_start_date

Line 778: per_sps_ins.post_insert

774: );
775: --
776: -- Call the supporting post-insert operation
777: --
778: per_sps_ins.post_insert
779: (p_rec => p_rec
780: ,p_effective_date => p_effective_date
781: ,p_datetrack_mode => l_datetrack_mode
782: ,p_validation_start_date => l_validation_start_date

Line 902: per_sps_ins.ins

898: -- Having converted the arguments into the per_sps_rec
899: -- plsql record structure we call the corresponding record
900: -- business process.
901: --
902: per_sps_ins.ins
903: (p_effective_date
904: ,l_rec
905: );
906: --

Line 918: end per_sps_ins;

914: --
915: hr_utility.set_location(' Leaving:'||l_proc, 10);
916: End ins;
917: --
918: end per_sps_ins;