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:
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: --
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: --
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: --
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
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: --
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
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
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);
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: