[Home] [Help]
179: into l_grade_spine_id
180: from per_grade_spines_f
181: where rowid = chartorowid(X_Rowid);
182:
183: Delete from per_spinal_point_steps_f
184: where grade_spine_id = l_grade_spine_id;
185:
186: Exception
187: When NO_DATA_FOUND then
210: l_exists2 VARCHAR2(1);
211:
212: cursor c1 is
213: select 'x'
214: from per_spinal_point_steps_f sps,
215: per_grade_spines_f gs
216: where gs.grade_spine_id = sps.grade_spine_id
217: and gs.parent_spine_id = p_pspine_id
218: and gs.grade_id = p_grd_id
222: where sp.step_id = sps.step_id);
223: --
224: cursor c2 is
225: select 'x'
226: from per_spinal_point_steps_f sps,
227: per_grade_spines_f gs
228: where gs.grade_spine_id = sps.grade_spine_id
229: and gs.parent_spine_id = p_pspine_id
230: and gs.grade_id = p_grd_id
311: p_information_category in VARCHAR2) IS
312:
313: begin
314:
315: insert into per_spinal_point_steps_f(
316: step_id,
317: grade_spine_id,
318: spinal_point_id,
319: sequence,
344:
345: end first_step;
346:
347: --
348: -- first_step_api inserts object_verson_number into per_spinal_point_steps_f
349: -- bug2999562
350: --
351: procedure first_step_api(
352: p_step_id IN NUMBER,
392: begin
393:
394: hr_utility.set_location('Entering:' ||l_proc, 10);
395:
396: insert into per_spinal_point_steps_f(
397: step_id,
398: grade_spine_id,
399: spinal_point_id,
400: sequence,
502: where exists
503: (select null
504: from per_all_assignments_f a,
505: per_spinal_point_placements_f p,
506: per_spinal_point_steps_f s
507: where a.assignment_id = p.assignment_id
508: and a.effective_start_date <= p_val_start
509: and a.effective_end_date >= p_val_end
510: and p.effective_start_date <= p_val_start
598: begin
599: --
600: hr_utility.set_location('per_grade_spines_pkg.zap_step',1);
601: --
602: delete from per_spinal_point_steps_f
603: where step_id = p_step_id
604: and grade_spine_id = p_grade_spine_id
605: and effective_start_date = p_eff_start_date;
606: --
620: begin
621: --
622: hr_utility.set_location('per_grade_spines_pkg.update_step',1);
623: --
624: update per_spinal_point_steps_f
625: set effective_end_date = p_newdate
626: where step_id = p_step_id
627: and grade_spine_id = p_grade_spine_id
628: and effective_start_date = p_eff_start_date;
692: --
693: cursor check_ass is
694: select 1
695: from per_all_assignments_f paa,
696: per_spinal_point_steps_f psps
697: where psps.grade_spine_id = p_gspine_id
698: and paa.special_ceiling_step_id = psps.step_id
699: and p_sess < paa.effective_end_date;
700: --
704: cursor get_steps is
705: select step_id,
706: effective_start_date,
707: effective_end_date
708: from per_spinal_point_steps_f
709: where grade_spine_id = p_gspine_id;
710: --
711: cursor get_plcmnts(p_step_id in number) is
712: select placement_id,
797:
798: procedure open_gspine(p_gspine_id in number,
799: p_grade_id in number,
800: p_eff_end_date in date) is
801: l_step_id per_spinal_point_steps_f.step_id%TYPE;
802: l_stp_eff_start per_spinal_point_steps_f.effective_start_date%TYPE;
803: l_plcmnt_id per_spinal_point_placements_f.placement_id%TYPE;
804: l_plc_eff_start per_spinal_point_placements_f.effective_start_date%TYPE;
805: l_gspine_opento_date date;
798: procedure open_gspine(p_gspine_id in number,
799: p_grade_id in number,
800: p_eff_end_date in date) is
801: l_step_id per_spinal_point_steps_f.step_id%TYPE;
802: l_stp_eff_start per_spinal_point_steps_f.effective_start_date%TYPE;
803: l_plcmnt_id per_spinal_point_placements_f.placement_id%TYPE;
804: l_plc_eff_start per_spinal_point_placements_f.effective_start_date%TYPE;
805: l_gspine_opento_date date;
806: l_stp_opento_date date;
824: --
825: cursor get_steps is
826: select step_id,
827: effective_start_date
828: from per_spinal_point_steps_f
829: where grade_spine_id = p_gspine_id
830: and effective_end_date = p_eff_end_date;
831: --
832: -- cursor to locate the spinal point placements that require