158: -- Needs to get the sequence of the ceiling point
159: open csr_get_sequence;
160: fetch csr_get_sequence into l_sequence;
161: close csr_get_sequence;
162: -- Call hr_grade_step_api.create_grade_step
163: --
164: hr_grade_step_api.create_grade_step
165: (p_effective_date => p_effective_date
166: ,p_validate => p_validate
160: fetch csr_get_sequence into l_sequence;
161: close csr_get_sequence;
162: -- Call hr_grade_step_api.create_grade_step
163: --
164: hr_grade_step_api.create_grade_step
165: (p_effective_date => p_effective_date
166: ,p_validate => p_validate
167: ,p_business_group_id => p_business_group_id
168: ,p_spinal_point_id => p_ceiling_point_id
671: --
672: hr_utility.set_location(l_datetrack_mode||' step: '||to_char(grade_step_rec.step_id), 120);
673: --
674: BEGIN
675: hr_grade_step_api.delete_grade_step(
676: p_validate => p_validate
677: ,p_step_id => grade_step_rec.step_id
678: ,p_effective_date => l_effective_date
679: ,p_datetrack_mode => l_datetrack_mode