[Home] [Help]
1113: -- IGS_AD_LOCATION, etc).
1114: -- * Call the ENRP_INS_SNEW_PRENRL routine to perform the pre-enrolment on each
1115: -- student.
1116: -- Returning Students:
1117: -- * Loop through IGS_EN_STDNT_PS_ATT records with a status of ENROLLED,
1118: -- INACTIVE, INTERMIT or UNCONFIRM matching the specified IGS_PS_COURSE offering
1119: -- option parameters.
1120: -- * Call the ENRP_INS_SRET_PRENRL routine to perform the pre-enrolment on
1121: -- each student.
1180:
1181: CURSOR c_sca IS
1182: SELECT sca.person_id,
1183: sca.course_cd
1184: FROM IGS_EN_STDNT_PS_ATT sca,
1185: IGS_PS_VER crv,
1186: IGS_PS_STAT cs
1187: WHERE sca.course_cd LIKE p_course_cd AND
1188: sca.cal_type = p_acad_cal_type AND
1341: -- IGS_GE_NOTE: this section of the query deals with determining if the student has
1342: -- already been pre-enrolled and whether they may require a IGS_PS_UNIT pre-enrolment
1343: (NOT EXISTS (
1344: SELECT person_id
1345: FROM IGS_EN_STDNT_PS_ATT
1346: WHERE person_id = acai.person_id AND
1347: course_cd = acai.course_cd AND
1348: adm_admission_appl_number = acai.admission_appl_number AND
1349: adm_nominated_course_cd = acai.nominated_course_cd AND
1391: cp_course_cd VARCHAR2,
1392: cp_unit_set_cd VARCHAR2)IS
1393: SELECT sca.course_cd,susa.unit_set_cd
1394: FROM IGS_AS_SU_SETATMPT susa,
1395: IGS_EN_STDNT_PS_ATT sca
1396: WHERE sca.person_id =cp_person_id
1397: AND sca.course_cd =cp_course_cd
1398: AND susa.person_id =sca.person_id
1399: AND susa.course_cd =sca.course_cd