APPS.IGS_AS_GEN_003 dependencies on IGS_AS_GEN_002

Line 175: v_sua_location := IGS_AS_GEN_002.ASSP_GET_DFLT_EXLOC(v_sua_rec.location_cd);

171: RETURN v_sua_rec.exam_location_cd;
172: END IF;
173: -- 3.1 If On-Campus IGS_PS_UNIT use the default IGS_AD_LOCATION.
174: IF (v_sua_rec.s_unit_mode = 'ON') THEN
175: v_sua_location := IGS_AS_GEN_002.ASSP_GET_DFLT_EXLOC(v_sua_rec.location_cd);
176: IF (v_sua_location IS NOT NULL) THEN
177: RETURN v_sua_location;
178: END IF;
179: END IF;

Line 188: v_sua_location := IGS_AS_GEN_002.ASSP_GET_DFLT_EXLOC(v_sua_rec.location_cd);

184: IF (v_sca_rec.exam_location_cd IS NOT NULL) THEN
185: RETURN v_sca_rec.exam_location_cd;
186: END IF;
187: -- 5. Search for the default exam IGS_AD_LOCATION for the enrolled IGS_PS_UNIT campus
188: v_sua_location := IGS_AS_GEN_002.ASSP_GET_DFLT_EXLOC(v_sua_rec.location_cd);
189: IF (v_sua_location IS NOT NULL) THEN
190: RETURN v_sua_location;
191: END IF;
192: -- 6. Search for the default exam IGS_AD_LOCATION for the enrolled IGS_PS_COURSE

Line 193: v_sca_location := IGS_AS_GEN_002.ASSP_GET_DFLT_EXLOC(v_sca_rec.location_cd);

189: IF (v_sua_location IS NOT NULL) THEN
190: RETURN v_sua_location;
191: END IF;
192: -- 6. Search for the default exam IGS_AD_LOCATION for the enrolled IGS_PS_COURSE
193: v_sca_location := IGS_AS_GEN_002.ASSP_GET_DFLT_EXLOC(v_sca_rec.location_cd);
194: IF (v_sca_location IS NOT NULL) THEN
195: RETURN v_sca_location;
196: END IF;
197: RETURN NULL;