APPS.IGS_EN_VAL_SCI dependencies on IGS_PS_VER

Line 159: v_int_allowed_ind IGS_PS_VER.intrmsn_allowed_ind%TYPE;

155: RETURN boolean AS
156: BEGIN
157: DECLARE
158: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
159: v_int_allowed_ind IGS_PS_VER.intrmsn_allowed_ind%TYPE;
160: v_num_units_bf_int IGS_PS_VER.num_of_units_before_intrmsn%TYPE;
161: v_count NUMBER;
162: CURSOR c_sca_details
163: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

Line 160: v_num_units_bf_int IGS_PS_VER.num_of_units_before_intrmsn%TYPE;

156: BEGIN
157: DECLARE
158: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
159: v_int_allowed_ind IGS_PS_VER.intrmsn_allowed_ind%TYPE;
160: v_num_units_bf_int IGS_PS_VER.num_of_units_before_intrmsn%TYPE;
161: v_count NUMBER;
162: CURSOR c_sca_details
163: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
164: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

Line 174: FROM IGS_PS_VER

170: (cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
171: cp_version_num IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
172: SELECT intrmsn_allowed_ind,
173: num_of_units_before_intrmsn
174: FROM IGS_PS_VER
175: WHERE course_cd = cp_course_cd AND
176: version_number = cp_version_num;
177: CURSOR c_sca_count
178: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

Line 188: -- # the IGS_PS_VER.intrmsn_allowed_ind

184: unit_attempt_status = 'COMPLETED';
185: BEGIN
186: -- This module validates that intermission is allowed
187: -- for the student's COURSE version, subject to :
188: -- # the IGS_PS_VER.intrmsn_allowed_ind
189: -- being set (this is only a warning)
190: -- # the number of complete unit attempt must
191: -- exceed the IGS_PS_VER.num_of_units_
192: -- before_intrmsn

Line 191: -- exceed the IGS_PS_VER.num_of_units_

187: -- for the student's COURSE version, subject to :
188: -- # the IGS_PS_VER.intrmsn_allowed_ind
189: -- being set (this is only a warning)
190: -- # the number of complete unit attempt must
191: -- exceed the IGS_PS_VER.num_of_units_
192: -- before_intrmsn
193: p_message_name := null;
194: OPEN c_sca_details(p_person_id,
195: p_course_cd);

Line 207: -- check if the IGS_PS_VER intermission

203: OPEN c_cv_details(p_course_cd,
204: v_version_number);
205: FETCH c_cv_details INTO v_int_allowed_ind,
206: v_num_units_bf_int;
207: -- check if the IGS_PS_VER intermission
208: -- allowed indicator
209: IF (v_int_allowed_ind = 'N') THEN
210: p_message_name := 'IGS_EN_INTERMISSION_NOTPERM';
211: RETURN FALSE;

Line 273: FROM IGS_PS_VER

269: BEGIN
270: DECLARE
271: CURSOR c_get_mid IS
272: SELECT max_intrmsn_duration
273: FROM IGS_PS_VER
274: WHERE course_cd = p_course_cd AND
275: version_number = p_version_number;
276: v_mid IGS_PS_VER.max_intrmsn_duration%TYPE;
277: BEGIN

Line 276: v_mid IGS_PS_VER.max_intrmsn_duration%TYPE;

272: SELECT max_intrmsn_duration
273: FROM IGS_PS_VER
274: WHERE course_cd = p_course_cd AND
275: version_number = p_version_number;
276: v_mid IGS_PS_VER.max_intrmsn_duration%TYPE;
277: BEGIN
278: --- Set default message number
279: p_message_name := null;
280: --- Select the maximum intermission from the students COURSE version