[Home] [Help]
144: p_teach_cal_type igs_ca_inst.cal_type%TYPE;
145: p_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
146: p_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
147: p_unit_cd igs_ps_unit.unit_cd%TYPE;
148: p_location_cd igs_ad_location.location_cd%TYPE;
149: p_unit_mode igs_as_unit_mode.unit_mode%TYPE;
150: p_unit_class igs_as_unit_class.unit_class%TYPE;
151: p_assessable_type igs_lookups_view.lookup_code%TYPE;
152: p_no_assessment_type igs_lookups_view.lookup_code%TYPE;
263: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
264: cp_teach_sequence_number igs_ca_inst.sequence_number%TYPE,
265: cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE,
266: cp_unit_cd igs_ps_unit.unit_cd%TYPE,
267: cp_location_cd igs_ad_location.location_cd%TYPE,
268: cp_unit_mode igs_as_unit_class.unit_mode%TYPE,
269: cp_unit_class igs_as_unit_class.unit_class%TYPE,
270: cp_assessable_type igs_as_assessmnt_typ.assessment_type%TYPE,
271: cp_no_assessment_type igs_en_su_attempt.no_assessment_ind%TYPE
1006: p_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1007: p_teach_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1008: p_course_cd IGS_PS_COURSE.COURSE_CD%TYPE;
1009: p_unit_cd IGS_PS_UNIT.UNIT_CD%TYPE;
1010: p_location_cd IGS_AD_LOCATION.LOCATION_CD%TYPE;
1011: p_unit_class IGS_AS_UNIT_CLASS.UNIT_CLASS%TYPE;
1012: p_unit_mode IGS_AS_UNIT_MODE.UNIT_MODE%TYPE;
1013: p_reproduce IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE ;
1014: --------------------------------------------------------------------------------------------------------------------------
2075: esvv.venue_cd = ve.venue_cd;
2076: CURSOR c_lr(
2077: cp_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE) IS
2078: SELECT 'X'
2079: FROM IGS_AD_LOCATION_REL lr,
2080: IGS_AD_LOCATION loc,
2081: IGS_AD_LOCATION_TYPE lot
2082: WHERE lr.sub_location_cd = cp_exam_location_cd AND
2083: lr.location_cd = loc.location_cd AND
2076: CURSOR c_lr(
2077: cp_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE) IS
2078: SELECT 'X'
2079: FROM IGS_AD_LOCATION_REL lr,
2080: IGS_AD_LOCATION loc,
2081: IGS_AD_LOCATION_TYPE lot
2082: WHERE lr.sub_location_cd = cp_exam_location_cd AND
2083: lr.location_cd = loc.location_cd AND
2084: loc.LOCATION_TYPE = lot.LOCATION_TYPE AND
2077: cp_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE) IS
2078: SELECT 'X'
2079: FROM IGS_AD_LOCATION_REL lr,
2080: IGS_AD_LOCATION loc,
2081: IGS_AD_LOCATION_TYPE lot
2082: WHERE lr.sub_location_cd = cp_exam_location_cd AND
2083: lr.location_cd = loc.location_cd AND
2084: loc.LOCATION_TYPE = lot.LOCATION_TYPE AND
2085: lot.s_location_type = 'CAMPUS';
2384: v_esvv_rec.exam_location_cd);
2385: FETCH c_lr INTO v_lr_exists;
2386: IF (c_lr%NOTFOUND) THEN
2387: CLOSE c_lr;
2388: --The exam IGS_AD_LOCATION is an off campus IGS_AD_LOCATION
2389: --For each IGS_GR_VENUE, select the supervisors for which
2390: -- the exam venues are within their nominated exam locations.
2391: FOR v_els_rec IN c_els(
2392: v_esvv_rec.venue_cd) LOOP