[Home] [Help]
1230: END admpl_match_standard;
1231: ---------------
1232: ---------------
1233: PROCEDURE admpl_write_course_header (
1234: p_course_cd IN IGS_PS_VER.course_cd%TYPE,
1235: p_course_title IN IGS_PS_VER.title%TYPE,
1236: p_govt_field_of_study IN IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE,
1237: p_govt_course_type IN IGS_PS_TYPE.govt_course_type%TYPE,
1238: p_honours_flag IN IGS_GR_HONOURS_LEVEL.govt_honours_level%TYPE,
1231: ---------------
1232: ---------------
1233: PROCEDURE admpl_write_course_header (
1234: p_course_cd IN IGS_PS_VER.course_cd%TYPE,
1235: p_course_title IN IGS_PS_VER.title%TYPE,
1236: p_govt_field_of_study IN IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE,
1237: p_govt_course_type IN IGS_PS_TYPE.govt_course_type%TYPE,
1238: p_honours_flag IN IGS_GR_HONOURS_LEVEL.govt_honours_level%TYPE,
1239: p_exclusion_flag IN VARCHAR2,
1321: v_course_sem_last_enr NUMBER(1);
1322: v_sca_total_eftsu NUMBER;
1323: v_output_student VARCHAR2(71);
1324: v_output_subject VARCHAR2(69);
1325: v_last_course_cd IGS_PS_VER.course_cd%TYPE;
1326: v_course_title IGS_PS_VER.title%TYPE;
1327: v_govt_field_of_study IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE;
1328: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
1329: v_honours_flag IGS_GR_HONOURS_LEVEL.govt_honours_level%TYPE;
1322: v_sca_total_eftsu NUMBER;
1323: v_output_student VARCHAR2(71);
1324: v_output_subject VARCHAR2(69);
1325: v_last_course_cd IGS_PS_VER.course_cd%TYPE;
1326: v_course_title IGS_PS_VER.title%TYPE;
1327: v_govt_field_of_study IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE;
1328: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
1329: v_honours_flag IGS_GR_HONOURS_LEVEL.govt_honours_level%TYPE;
1330: v_exclusion_flag VARCHAR2(1);
1379: sua.unit_attempt_status,
1380: sua.no_assessment_ind
1381: FROM IGS_EN_SU_ATTEMPT sua,
1382: IGS_EN_STDNT_PS_ATT sca,
1383: IGS_PS_VER crv,
1384: IGS_PS_UNIT_VER uv
1385: WHERE sua.person_id = p_matched_id AND
1386: sua.unit_attempt_status IN (
1387: cst_enrolled,
1395: crv.version_number = sca.version_number
1396: ORDER BY sua.course_cd,
1397: sua.ci_start_dt;
1398: CURSOR c_fos_cfos (
1399: cp_course_cd IGS_PS_VER.course_cd%TYPE,
1400: cp_version_number IGS_PS_VER.version_number%TYPE) IS
1401: SELECT fos.govt_field_of_study
1402: FROM IGS_PS_FLD_OF_STUDY fos,
1403: IGS_PS_FIELD_STUDY cfos
1396: ORDER BY sua.course_cd,
1397: sua.ci_start_dt;
1398: CURSOR c_fos_cfos (
1399: cp_course_cd IGS_PS_VER.course_cd%TYPE,
1400: cp_version_number IGS_PS_VER.version_number%TYPE) IS
1401: SELECT fos.govt_field_of_study
1402: FROM IGS_PS_FLD_OF_STUDY fos,
1403: IGS_PS_FIELD_STUDY cfos
1404: WHERE cfos.course_cd = cp_course_cd AND
1405: cfos.version_number = cp_version_number AND
1406: cfos.major_field_ind = 'Y' AND
1407: fos.field_of_study = cfos.field_of_study;
1408: CURSOR c_cty (
1409: cp_course_type IGS_PS_VER.course_type%TYPE) IS
1410: SELECT cty.govt_course_type
1411: FROM IGS_PS_TYPE cty
1412: WHERE cty.course_type = cp_course_type;
1413: CURSOR c_pee (
1419: cst_sus_srvc,
1420: cst_rvk_srvc);
1421: CURSOR c_pce (
1422: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1423: cp_course_cd IGS_PS_VER.course_cd%TYPE) IS
1424: SELECT pce.s_encmb_effect_type
1425: FROM IGS_PE_COURSE_EXCL pce
1426: WHERE pce.person_id = cp_person_id AND
1427: pce.s_encmb_effect_type IN (
1429: cst_sus_course) AND
1430: pce.course_cd = cp_course_cd;
1431: CURSOR c_pcge_cgr_cgm (
1432: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1433: cp_course_cd IGS_PS_VER.course_cd%TYPE) IS
1434: SELECT pcge.s_encmb_effect_type
1435: FROM IGS_PE_CRS_GRP_EXCL pcge,
1436: IGS_PS_GRP cgr,
1437: IGS_PS_GRP_MBR cgm