eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_VAL_SCI dependencies on IGS_EN_STDNT_PS_ATT

Line 103: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

99: p_message_name OUT NOCOPY VARCHAR2)
100: RETURN boolean AS
101: BEGIN
102: DECLARE
103: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
104: CURSOR c_sca IS
105: SELECT course_attempt_status
106: FROM IGS_EN_STDNT_PS_ATT
107: WHERE person_id = p_person_id AND

Line 106: FROM IGS_EN_STDNT_PS_ATT

102: DECLARE
103: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
104: CURSOR c_sca IS
105: SELECT course_attempt_status
106: FROM IGS_EN_STDNT_PS_ATT
107: WHERE person_id = p_person_id AND
108: course_cd = p_course_cd;
109: BEGIN
110: -- This module validates that intermission is allowed

Line 158: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

154: p_message_name OUT NOCOPY VARCHAR2)
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

Line 163: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%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
165: SELECT version_number
166: FROM IGS_EN_STDNT_PS_ATT
167: WHERE person_id = cp_person_id AND

Line 164: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

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
165: SELECT version_number
166: FROM IGS_EN_STDNT_PS_ATT
167: WHERE person_id = cp_person_id AND
168: course_cd = cp_course_cd;

Line 166: FROM IGS_EN_STDNT_PS_ATT

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
165: SELECT version_number
166: FROM IGS_EN_STDNT_PS_ATT
167: WHERE person_id = cp_person_id AND
168: course_cd = cp_course_cd;
169: CURSOR c_cv_details
170: (cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

Line 170: (cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

166: FROM IGS_EN_STDNT_PS_ATT
167: WHERE person_id = cp_person_id AND
168: course_cd = cp_course_cd;
169: CURSOR c_cv_details
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

Line 171: cp_version_num IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

167: WHERE person_id = cp_person_id AND
168: course_cd = cp_course_cd;
169: CURSOR c_cv_details
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

Line 178: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

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,
179: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
180: SELECT count(*)
181: FROM IGS_EN_SU_ATTEMPT
182: WHERE person_id = cp_person_id AND

Line 179: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

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,
179: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
180: SELECT count(*)
181: FROM IGS_EN_SU_ATTEMPT
182: WHERE person_id = cp_person_id AND
183: course_cd = cp_course_cd AND

Line 334: -- IGS_EN_STDNT_PS_ATT

330: BEGIN
331: -- This module validates that the student_course_intermssion
332: -- record being created or updated does not overlap with an
333: -- existing intermission record for the nominated
334: -- IGS_EN_STDNT_PS_ATT
335: p_message_name := null;
336: FOR c_sci_rec IN c_sci(p_person_id,
337: p_course_cd,
338: p_start_dt) LOOP