[Home] [Help]
308: p_cal_type VARCHAR2,
309: p_sequence_number NUMBER) IS
310: SELECT sua.unit_cd,sua.version_number,sua.override_enrolled_cp,sua.uoo_id
311: FROM igs_en_su_attempt sua,
312: igs_ca_inst_rel carel
313: WHERE sua.person_id = p_person_id and
314: sua.unit_attempt_status = 'ENROLLED' and
315: ((sua.cal_type = p_cal_type and
316: sua.ci_sequence_number = p_sequence_number)OR
1866: p_teach_cal_type IN VARCHAR2,
1867: p_teach_seq_num IN NUMBER)
1868: RETURN VARCHAR2 AS
1869: CURSOR cur_find_rel IS
1870: SELECT 'x' FROM igs_ca_inst_rel cir2
1871: WHERE cir2.sup_cal_type = p_acad_cal_type
1872: AND cir2.sub_cal_type = p_teach_cal_type
1873: AND cir2.sub_ci_sequence_number = p_teach_seq_num;
1874: l_dummy VARCHAR2(1);
1949: -- where the application exists in application instance table and admission calendar is
1950: -- subordinate to the teaching calendar.
1951: --2. Entered through Student Enrollments, having program attempt of status INACTIVE and is not
1952: -- having any unit attempts.
1953: CURSOR cur_total_admted_stdnts(cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE, cp_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1954:
1955: SELECT sca.person_id person_id ,(select person_last_name from hz_parties where party_id = sca.person_id) last_name
1956: FROM IGS_EN_STDNT_PS_ATT_ALL sca,
1957: igs_ps_ver_all pv,
1957: igs_ps_ver_all pv,
1958: igs_ps_type_all pt,
1959: IGS_AD_PS_APPL_INST_all acai,
1960: IGS_AD_APPL_all aav,
1961: IGS_CA_INST_REL cir
1962: WHERE pv.course_cd = sca.course_cd AND
1963: pv.version_number = sca.version_number AND
1964: sca.course_attempt_status IN ('INACTIVE','UNCONFIRM') AND
1965: pv.course_type = pt.course_type AND
2004:
2005:
2006: CURSOR cur_cal_st_dt(p_cal_type VARCHAR2,p_seq_num NUMBER) IS
2007: SELECT start_dt
2008: FROM igs_ca_inst
2009: WHERE cal_type = p_cal_type AND
2010: sequence_number=p_seq_num;
2011:
2012: start_date DATE;