APPS.IGS_AD_VAL_SCFT dependencies on IGS_EN_UNIT_SET

Line 197: -- This module validates the IGS_EN_UNIT_SET component of IGS_AD_SBM_PS_FNTRGT

193: p_attendance_type IN VARCHAR2 ,
194: p_message_name OUT NOCOPY VARCHAR2 )
195: RETURN BOOLEAN AS
196: BEGIN -- admp_val_scft_cous
197: -- This module validates the IGS_EN_UNIT_SET component of IGS_AD_SBM_PS_FNTRGT
198: -- does not have a system status of 'INACTIVE' and maps to at least one
199: -- course_offering_unot_set or IGS_PS_OF_OPT_UNT_ST.
200: DECLARE
201: v_coousv VARCHAR2(1);

Line 202: cst_inactive CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'INACTIVE';

198: -- does not have a system status of 'INACTIVE' and maps to at least one
199: -- course_offering_unot_set or IGS_PS_OF_OPT_UNT_ST.
200: DECLARE
201: v_coousv VARCHAR2(1);
202: cst_inactive CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'INACTIVE';
203: CURSOR c_coousv IS
204: SELECT 'x'
205: FROM IGS_PS_OFR_OPT_UNIT_SET_V coousv,
206: IGS_EN_UNIT_SET us,

Line 206: IGS_EN_UNIT_SET us,

202: cst_inactive CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'INACTIVE';
203: CURSOR c_coousv IS
204: SELECT 'x'
205: FROM IGS_PS_OFR_OPT_UNIT_SET_V coousv,
206: IGS_EN_UNIT_SET us,
207: IGS_EN_UNIT_SET_STAT uss
208: WHERE coousv.unit_set_cd = p_unit_set_cd AND
209: coousv.us_version_number = p_us_version_number AND
210: coousv.course_cd = p_course_cd AND

Line 207: IGS_EN_UNIT_SET_STAT uss

203: CURSOR c_coousv IS
204: SELECT 'x'
205: FROM IGS_PS_OFR_OPT_UNIT_SET_V coousv,
206: IGS_EN_UNIT_SET us,
207: IGS_EN_UNIT_SET_STAT uss
208: WHERE coousv.unit_set_cd = p_unit_set_cd AND
209: coousv.us_version_number = p_us_version_number AND
210: coousv.course_cd = p_course_cd AND
211: coousv.crv_version_number = p_crv_version_number AND