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_RE_VAL_CAH dependencies on IGS_EN_STDNT_PS_ATT

Line 143: -- IGS_EN_STDNT_PS_ATT.course_attempt_status is 'COMPLETED' with all awards completed.

139: BEGIN -- resp_val_ca_childupd
140: -- This module validates the update of IGS_RE_CANDIDATURE child details.
141: -- Validations are:
142: -- IGS_RE_CANDIDATURE child details cannot be updated if
143: -- IGS_EN_STDNT_PS_ATT.course_attempt_status is 'COMPLETED' with all awards completed.
144: -- If atleast one award is incomplete or no award is associated, update is allowed.
145: DECLARE
146: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
147: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;

Line 148: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

144: -- If atleast one award is incomplete or no award is associated, update is allowed.
145: DECLARE
146: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
147: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
148: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
149: v_dummy VARCHAR2(1);
150:
151: CURSOR c_ca IS
152: SELECT ca.sca_course_cd

Line 157: cp_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

153: FROM IGS_RE_CANDIDATURE ca
154: WHERE ca.person_id = p_person_id AND
155: ca.sequence_number = p_ca_sequence_number;
156: CURSOR c_sca (
157: cp_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
158: SELECT sca.course_attempt_status
159: FROM IGS_EN_STDNT_PS_ATT sca
160: WHERE sca.person_id = p_person_id AND
161: sca.course_cd = cp_sca_course_cd;

Line 159: FROM IGS_EN_STDNT_PS_ATT sca

155: ca.sequence_number = p_ca_sequence_number;
156: CURSOR c_sca (
157: cp_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
158: SELECT sca.course_attempt_status
159: FROM IGS_EN_STDNT_PS_ATT sca
160: WHERE sca.person_id = p_person_id AND
161: sca.course_cd = cp_sca_course_cd;
162: CURSOR c_awd_exists(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
163: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

Line 162: CURSOR c_awd_exists(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

158: SELECT sca.course_attempt_status
159: FROM IGS_EN_STDNT_PS_ATT sca
160: WHERE sca.person_id = p_person_id AND
161: sca.course_cd = cp_sca_course_cd;
162: CURSOR c_awd_exists(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
163: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
164: SELECT 'x'
165: FROM igs_en_spa_awd_aim
166: WHERE person_id = cp_person_id

Line 163: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

159: FROM IGS_EN_STDNT_PS_ATT sca
160: WHERE sca.person_id = p_person_id AND
161: sca.course_cd = cp_sca_course_cd;
162: CURSOR c_awd_exists(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
163: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
164: SELECT 'x'
165: FROM igs_en_spa_awd_aim
166: WHERE person_id = cp_person_id
167: AND course_cd = cp_course_cd

Line 171: CURSOR c_incomp_awd(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

167: AND course_cd = cp_course_cd
168: AND ( end_dt IS NULL OR
169: (end_dt IS NOT NULL AND complete_ind = 'Y')
170: );
171: CURSOR c_incomp_awd(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
172: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
173: SELECT 'x'
174: FROM igs_en_spa_awd_aim
175: WHERE person_id = cp_person_id

Line 172: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

168: AND ( end_dt IS NULL OR
169: (end_dt IS NOT NULL AND complete_ind = 'Y')
170: );
171: CURSOR c_incomp_awd(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
172: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
173: SELECT 'x'
174: FROM igs_en_spa_awd_aim
175: WHERE person_id = cp_person_id
176: AND course_cd = cp_course_cd

Line 251: -- * first hist_start_dt = IGS_EN_STDNT_PS_ATT.commencement_dt

247: RETURN BOOLEAN AS
248: BEGIN -- resp_val_cah_hist_dt
249: -- This module validates for IGS_RE_CDT_ATT_HIST for the IGS_RE_CANDIDATURE. The
250: -- following is validated:
251: -- * first hist_start_dt = IGS_EN_STDNT_PS_ATT.commencement_dt
252: -- * IGS_RE_CDT_ATT_HIST do not overlap or have gaps ie. history is
253: -- continuous.
254: -------------------------------------------------------------------------------------------
255: --Change History:

Line 262: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

258: --svanukur 15-apr-2004 BUG no 3453123. Removed the check for commencement date not equal to
259: -- history start date; moved this to the IGSRE013.pld instead
260: -------------------------------------------------------------------------------------------
261: DECLARE
262: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
263: v_last_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
264: CURSOR c_cah IS
265: SELECT cah.person_id,
266: cah.ca_sequence_number,

Line 278: IGS_EN_STDNT_PS_ATT sca

274: cp_person_id IGS_RE_CDT_ATT_HIST.person_id%TYPE,
275: cp_ca_sequence_number IGS_RE_CDT_ATT_HIST.ca_sequence_number%TYPE) IS
276: SELECT sca.commencement_dt
277: FROM IGS_RE_CANDIDATURE ca,
278: IGS_EN_STDNT_PS_ATT sca
279: WHERE ca.person_id = cp_person_id AND
280: ca.sequence_number = cp_ca_sequence_number AND
281: ca.person_id = sca.person_id AND
282: ca.sca_course_cd = sca.course_cd;

Line 342: -- * research IGS_RE_CANDIDATURE IGS_EN_STDNT_PS_ATT.student_confirmed_ind is

338: BEGIN -- resp_val_cah_ca_ins
339: -- This module validates IGS_RE_CDT_ATT_HIST insert in the context of
340: -- IGS_RE_CANDIDATURE. The following is validated.
341: -- * IGS_RE_CANDIDATURE.sca_course_cd must exist.
342: -- * research IGS_RE_CANDIDATURE IGS_EN_STDNT_PS_ATT.student_confirmed_ind is
343: -- 'Y' and IGS_EN_STDNT_PS_ATT.commencement_dt exists.
344: DECLARE
345: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
346: v_sca_student_confirmed_ind

Line 343: -- 'Y' and IGS_EN_STDNT_PS_ATT.commencement_dt exists.

339: -- This module validates IGS_RE_CDT_ATT_HIST insert in the context of
340: -- IGS_RE_CANDIDATURE. The following is validated.
341: -- * IGS_RE_CANDIDATURE.sca_course_cd must exist.
342: -- * research IGS_RE_CANDIDATURE IGS_EN_STDNT_PS_ATT.student_confirmed_ind is
343: -- 'Y' and IGS_EN_STDNT_PS_ATT.commencement_dt exists.
344: DECLARE
345: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
346: v_sca_student_confirmed_ind
347: IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;

Line 347: IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;

343: -- 'Y' and IGS_EN_STDNT_PS_ATT.commencement_dt exists.
344: DECLARE
345: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
346: v_sca_student_confirmed_ind
347: IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
348: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
349: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
350: CURSOR c_ca IS
351: SELECT ca.sca_course_cd

Line 348: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

344: DECLARE
345: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
346: v_sca_student_confirmed_ind
347: IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
348: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
349: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
350: CURSOR c_ca IS
351: SELECT ca.sca_course_cd
352: FROM IGS_RE_CANDIDATURE ca

Line 349: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

345: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
346: v_sca_student_confirmed_ind
347: IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
348: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
349: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
350: CURSOR c_ca IS
351: SELECT ca.sca_course_cd
352: FROM IGS_RE_CANDIDATURE ca
353: WHERE ca.person_id = p_person_id AND

Line 360: FROM IGS_EN_STDNT_PS_ATT sca

356: IS
357: SELECT sca.student_confirmed_ind,
358: sca.commencement_dt,
359: sca.attendance_type
360: FROM IGS_EN_STDNT_PS_ATT sca
361: WHERE sca.person_id = p_person_id AND
362: sca.course_cd = cp_sca_course_cd;
363: BEGIN
364: p_message_name := NULL;

Line 436: -- hist_start_dt is the same as the research IGS_RE_CANDIDATURE IGS_EN_STDNT_PS_ATT

432: p_message_name OUT NOCOPY VARCHAR2 )
433: RETURN BOOLEAN AS
434: BEGIN -- resp_val_cah_comm
435: -- Description: This module validates that the first IGS_RE_CDT_ATT_HIST.
436: -- hist_start_dt is the same as the research IGS_RE_CANDIDATURE IGS_EN_STDNT_PS_ATT
437: -- commencement_dt.
438: -- This module currently only returns a warning.
439: DECLARE
440: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;