APPS.IGS_AD_VAL_APCOO dependencies on IGS_EN_ATD_TYPE

Line 124: v_closed_ind IGS_EN_ATD_TYPE.closed_ind%TYPE;

120: RETURN BOOLEAN IS
121: BEGIN
122: DECLARE
123: v_other_detail VARCHAR2(255);
124: v_closed_ind IGS_EN_ATD_TYPE.closed_ind%TYPE;
125: CURSOR c_ci IS
126: SELECT closed_ind
127: FROM IGS_EN_ATD_TYPE
128: WHERE attendance_type = p_attendance_type;

Line 127: FROM IGS_EN_ATD_TYPE

123: v_other_detail VARCHAR2(255);
124: v_closed_ind IGS_EN_ATD_TYPE.closed_ind%TYPE;
125: CURSOR c_ci IS
126: SELECT closed_ind
127: FROM IGS_EN_ATD_TYPE
128: WHERE attendance_type = p_attendance_type;
129: BEGIN
130: -- Validates attendance type closed indicator.
131: p_message_name := Null;

Line 177: -- IGS_EN_ATD_TYPE tables when inserting or updating an admission period

173: RETURN BOOLEAN IS
174: gv_other_detail VARCHAR2(255);
175: BEGIN -- admp_val_apcoo_links
176: -- Validates that the links to the location, attendance_mode and
177: -- IGS_EN_ATD_TYPE tables when inserting or updating an admission period
178: -- IGS_PS_COURSE offering option record to avoid
179: -- conflicting or duplicate course offering option components.
180: DECLARE
181: v_message_name VARCHAR2(30);