2256: -- cursor for getting the Unit_cd and Version Number for the Uoo_id passed
2257: CURSOR cur_ps_unit_ofr
2258: IS
2259: SELECT unit_cd, version_number
2260: FROM igs_ps_unit_ofr_opt
2261: WHERE uoo_id = p_uoo_id;
2262:
2263: -- cursor for getting the count of Grading Schema's for the Uoo_id passed at the Unit Section Level
2264: CURSOR cur_unit_grd_schm( cp_unit_code igs_ps_unit_grd_schm.unit_code%TYPE,
2492: -- cursor for getting the Unit_cd and Version Number for the Uoo_id passed
2493: CURSOR cur_ps_unit_ofr
2494: IS
2495: SELECT unit_cd, version_number
2496: FROM igs_ps_unit_ofr_opt
2497: WHERE uoo_id = p_uoo_id;
2498:
2499: -- Check if the unit is set up for variable cp
2500: CURSOR cur_chk_cp_chg_val (p_unit_cd igs_ps_unit_ver_v.unit_cd%TYPE,p_unit_ver_num igs_ps_unit_ver_v.version_number%TYPE)