DBA Data[Home] [Help]

APPS.HR_GRADE_STEP_API dependencies on PER_SPINAL_POINT_STEPS_F

Line 69: l_step_id per_spinal_point_steps_f.step_id%TYPE;

65:
66: --
67: -- Declare out parameters
68: --
69: l_step_id per_spinal_point_steps_f.step_id%TYPE;
70: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
71: l_effective_start_date date;
72: l_effective_end_date date;
73:

Line 70: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;

66: --
67: -- Declare out parameters
68: --
69: l_step_id per_spinal_point_steps_f.step_id%TYPE;
70: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
71: l_effective_start_date date;
72: l_effective_end_date date;
73:
74: --

Line 385: lv_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;

381: -- Declare cursors and local variables
382: --
383: l_proc varchar2(72) := g_package||'update_grade_step';
384: l_effective_date date;
385: lv_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
386:
387: --
388: -- Declare out parameters
389: --

Line 390: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;

386:
387: --
388: -- Declare out parameters
389: --
390: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
391: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;
392: l_effective_end_date per_spinal_point_steps_f.effective_end_date%TYPE;
393:
394: --

Line 391: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;

387: --
388: -- Declare out parameters
389: --
390: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
391: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;
392: l_effective_end_date per_spinal_point_steps_f.effective_end_date%TYPE;
393:
394: --
395: begin

Line 392: l_effective_end_date per_spinal_point_steps_f.effective_end_date%TYPE;

388: -- Declare out parameters
389: --
390: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
391: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;
392: l_effective_end_date per_spinal_point_steps_f.effective_end_date%TYPE;
393:
394: --
395: begin
396: --

Line 716: lv_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;

712: -- Declare cursors and local variables
713: --
714: l_proc varchar2(72) := g_package||'delete_grade_step';
715: l_effective_date date;
716: lv_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
717:
718:
719: --
720: -- Declare out variables

Line 722: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;

718:
719: --
720: -- Declare out variables
721: --
722: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
723: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;
724: l_effective_end_date per_spinal_point_steps_f.effective_end_date%TYPE;
725: --
726: begin

Line 723: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;

719: --
720: -- Declare out variables
721: --
722: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
723: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;
724: l_effective_end_date per_spinal_point_steps_f.effective_end_date%TYPE;
725: --
726: begin
727: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 724: l_effective_end_date per_spinal_point_steps_f.effective_end_date%TYPE;

720: -- Declare out variables
721: --
722: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
723: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;
724: l_effective_end_date per_spinal_point_steps_f.effective_end_date%TYPE;
725: --
726: begin
727: hr_utility.set_location('Entering:'|| l_proc, 10);
728: