363: p_gpa OUT NOCOPY NUMBER) AS
364:
365: CURSOR c_chk_cal_cat IS
366: SELECT s_cal_cat
367: FROM igs_ca_type
368: WHERE cal_type = p_cal_type;
369: l_chk_cal_cat igs_ca_type.s_cal_cat%TYPE;
370:
371: CURSOR c_teach_to_load IS
365: CURSOR c_chk_cal_cat IS
366: SELECT s_cal_cat
367: FROM igs_ca_type
368: WHERE cal_type = p_cal_type;
369: l_chk_cal_cat igs_ca_type.s_cal_cat%TYPE;
370:
371: CURSOR c_teach_to_load IS
372: SELECT load_cal_type, load_ci_sequence_number
373: FROM igs_ca_teach_to_load_v