[Home] [Help]
247: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
248: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
249: cst_waitlisted CONSTANT VARCHAR2(10) := 'WAITLISTED';
250:
251: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
252: v_sca_total_cp NUMBER;
253: v_eftsu_total NUMBER;
254: v_cp_total NUMBER;
255: v_sua_cp NUMBER;
257: v_sca_total_calculated BOOLEAN;
258:
259: CURSOR c_sca IS
260: SELECT sca.version_number
261: FROM IGS_EN_STDNT_PS_ATT sca
262: WHERE sca.person_id = p_person_id AND
263: sca.course_cd = p_course_cd;
264: CURSOR c_load_to_teach IS
265: SELECT teach_cal_type, teach_ci_sequence_number
1683: CURSOR c_key_prog IS
1684: SELECT course_cd,
1685: version_number
1686: FROM
1687: igs_en_stdnt_ps_att WHERE
1688: key_program='Y' AND
1689: person_id=p_person_id;
1690:
1691: CURSOR c_term_key_prog IS
1695: AND term_cal_type = p_term_cal_type
1696: AND term_sequence_number = p_term_sequence_number
1697: AND key_program_flag = 'Y';
1698:
1699: l_key_prog igs_en_stdnt_ps_att.course_cd%TYPE;
1700: l_key_prog_ver igs_en_stdnt_ps_att.version_number%TYPE;
1701:
1702: BEGIN
1703:
1696: AND term_sequence_number = p_term_sequence_number
1697: AND key_program_flag = 'Y';
1698:
1699: l_key_prog igs_en_stdnt_ps_att.course_cd%TYPE;
1700: l_key_prog_ver igs_en_stdnt_ps_att.version_number%TYPE;
1701:
1702: BEGIN
1703:
1704: -- This Function gets the Person and finds the key_program for that particular person and returns that Key
1812: CURSOR c_spa(cp_person_id IGS_PE_PERSON.person_id%TYPE,
1813: cp_load_cal_type IGS_EN_SPA_TERMS.term_cal_type%TYPE,
1814: cp_load_seq_number IGS_EN_SPA_TERMS.term_sequence_number%TYPE) IS
1815: Select sca.course_cd
1816: From igs_en_stdnt_ps_att_all sca,
1817: igs_ps_ver_all pv
1818: WHERE sca.person_id = cp_person_id
1819: AND sca.course_cd = pv.course_cd
1820: AND sca.version_number = pv.version_number
1974: SELECT course_cd,
1975: igs_en_spa_terms_api.get_spat_program_version(p_person_id, course_cd,
1976: p_load_cal_type, p_load_seq_number)
1977:
1978: FROM igs_en_stdnt_ps_att sca
1979: WHERE person_id = p_person_id AND
1980: --anilk, Bug# 3046897
1981: course_attempt_status IN (cst_enrolled, cst_inactive, cst_discontin, cst_completed) AND
1982: ((l_career ='Y' AND
2171: sua.discontinued_dt,
2172: sua.uoo_id,
2173: sua.no_assessment_ind
2174: FROM IGS_EN_SU_ATTEMPT sua,
2175: IGS_EN_STDNT_PS_ATT sca,
2176: IGS_PS_UNIT_VER uv
2177: WHERE
2178: sca.person_id = p_person_id AND
2179: sca.person_id = sua.person_id AND