APPS.IGS_EN_VAL_SUSA dependencies on IGS_PS_OF_UNT_SET_RL

Line 235: -- * If the unit set is a subordinate within the IGS_PS_OF_UNT_SET_RL

231: BEGIN -- enrp_val_susa_cousr
232: -- Validates that the IGS_EN_UNIT_SET being allocated to the IGS_AS_SU_SETATMPT
233: -- is:
234:
235: -- * If the unit set is a subordinate within the IGS_PS_OF_UNT_SET_RL
236: -- table, then it must be specified as a child of one of the superior
237: -- units.
238: -- * If the unit set is being specified as a child of another
239: -- IGS_AS_SU_SETATMPT, then then parent unit set version must be

Line 267: FROM IGS_PS_OF_UNT_SET_RL cousr

263: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
264: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
265: cp_susa_us_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
266: SELECT 'x'
267: FROM IGS_PS_OF_UNT_SET_RL cousr
268: WHERE cousr.course_cd = p_course_cd AND
269: cousr.crv_version_number = cp_version_number AND
270: cousr.cal_type = cp_cal_type AND
271: cousr.sub_unit_set_cd = p_unit_set_cd AND

Line 279: FROM IGS_PS_OF_UNT_SET_RL cousr

275: CURSOR c_cousr2(
276: cp_us_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
277: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE) IS
278: SELECT 'x'
279: FROM IGS_PS_OF_UNT_SET_RL cousr
280: WHERE cousr.course_cd = p_course_cd AND
281: cousr.crv_version_number = cp_us_version_number AND
282:
283: cousr.cal_type = cp_cal_type AND

Line 300: -- IGS_PS_OF_UNT_SET_RL entries

296: CLOSE c_sca;
297:
298: -- Validate that if the unit set is being specified as a child of another unit
299: -- set, then the parent unit set version must be permitted within the
300: -- IGS_PS_OF_UNT_SET_RL entries
301: IF (p_parent_unit_set_cd IS NOT NULL OR
302: p_parent_sequence_number IS NOT NULL) THEN
303: OPEN c_susa;
304:

Line 342: -- the IGS_PS_OF_UNT_SET_RL table, then the parent details must be

338:
339: ELSE
340: -- (p_parent_unit_set_cd IS NULL OR p_parent_sequence_number IS NULL)
341: -- Validate that if the IGS_EN_UNIT_SET is defined as a subordinate within
342: -- the IGS_PS_OF_UNT_SET_RL table, then the parent details must be
343:
344: -- specified.
345: OPEN c_cousr2(
346: v_ver_no,