[Home] [Help]
689: RAISE;
690: END;
691: END assp_get_sua_outcome;
692: FUNCTION assp_get_supp_cal(
693: p_exam_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
694: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
690: END;
691: END assp_get_sua_outcome;
692: FUNCTION assp_get_supp_cal(
693: p_exam_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
694: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
720: SELECT uai.cal_type
721: FROM IGS_AS_UNITASS_ITEM UAI,
722: IGS_AS_ASSESSMNT_ITM AI,
723: IGS_AS_ASSESSMNT_TYP ATP,
724: IGS_CA_INST CI,
725: IGS_CA_TYPE CAT,
726: IGS_CA_STAT CS
727: WHERE uai.unit_cd = p_unit_cd AND
728: uai.version_number = p_version_number AND
747: (UAI.EXAM_CI_SEQUENCE_NUMBER IS NULL OR
748: CI.SEQUENCE_NUMBER = UAI.EXAM_CI_SEQUENCE_NUMBER) AND
749: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(CI.CAL_TYPE,CI.SEQUENCE_NUMBER,
750: UAI.CAL_TYPE, UAI.CI_SEQUENCE_NUMBER, 'N') = 'Y';
751: v_unit_cd IGS_CA_INST_REL.sup_cal_type%TYPE;
752: CURSOR c_uv IS
753: SELECT supp_exam_permitted_ind
754: FROM IGS_PS_UNIT_VER
755: WHERE unit_cd = p_unit_cd AND
1488: CURSOR c_terms
1489: IS
1490: SELECT ci.cal_type, ci.sequence_number, ci.start_dt, ci.end_dt,
1491: spa.person_id, spa.course_cd
1492: FROM igs_en_stdnt_ps_att_all spa, igs_ca_inst ci,
1493: igs_ps_ver_all pv
1494: WHERE spa.course_attempt_status <> 'UNCONFIRM'
1495: AND pv.course_cd = spa.course_cd
1496: AND ci.start_dt <= SYSDATE