[Home] [Help]
632: c_susa_upd_rec c_susa_upd%ROWTYPE ;
633:
634: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
635: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
636: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
637: igs_ca_inst ci,
638: igs_ca_type cal
639: WHERE rel.sup_cal_type = p_acad_cal_type
640: AND rel.sup_ci_sequence_number = p_acad_seq_num
1106: ci.sequence_number catalog_seq_num
1107: FROM igs_ca_inst ci,
1108: igs_ca_type ct,
1109: igs_ca_stat cs,
1110: igs_ca_inst_rel cir
1111: WHERE ci.cal_type = ct.cal_type
1112: AND ct.s_cal_cat = 'LOAD'
1113: AND cs.cal_status = ci.cal_status
1114: AND cs.s_cal_status = 'ACTIVE'
2724: WHERE am.attendance_mode = cp_attendance_mode;
2725: CURSOR c_cir (
2726: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
2727: SELECT ci.sequence_number
2728: FROM IGS_CA_INST_REL cir,
2729: IGS_CA_INST ci,
2730: IGS_CA_TYPE cat,
2731: IGS_CA_STAT cs
2732: WHERE cir.sup_cal_type = p_acad_cal_type AND
4321: v_dummy VARCHAR2(1);
4322:
4323: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
4324: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
4325: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
4326: igs_ca_inst ci,
4327: igs_ca_type cal
4328: WHERE rel.sup_cal_type = p_acad_cal_type
4329: AND rel.sup_ci_sequence_number = p_acad_seq_num
4371: WHERE am.attendance_mode = cp_attendance_mode;
4372: CURSOR c_cir (
4373: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
4374: SELECT ci.sequence_number
4375: FROM IGS_CA_INST_REL cir,
4376: IGS_CA_INST ci,
4377: IGS_CA_TYPE cat,
4378: IGS_CA_STAT cs
4379: WHERE cir.sup_cal_type = p_acad_cal_type AND
6042: cp_curr_term_start_dt igs_ca_inst.start_dt%TYPE)
6043: IS
6044: SELECT cir.sub_cal_type term_cal_type,
6045: cir.sub_ci_sequence_number term_sequence_number
6046: FROM igs_ca_inst_rel cir,
6047: igs_ca_inst ci,
6048: igs_ca_type ct,
6049: igs_ca_stat cs
6050: WHERE cir.sup_cal_type = cp_acad_cal_type