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

Line 107: -- Cannot be set if the parent IGS_EN_STDNT_PS_ATT.course_attempt_status

103: -- with their thesis_result_cd set
104: -- Cannot set if previous thesis_exam record exists which
105: -- has been submitted but for which no result has been recorded
106: -- Cannot set if parent IGS_RE_THESIS.final_title_ind = 'N'
107: -- Cannot be set if the parent IGS_EN_STDNT_PS_ATT.course_attempt_status
108: -- is not one of ENROLLED, INTERMIT or INACTIVE
109: -- Cannot be deceased person
110: -- Cannot be future dated
111: -- Cannot be less than the IGS_EN_STDNT_PS_ATT.commencement_dt

Line 111: -- Cannot be less than the IGS_EN_STDNT_PS_ATT.commencement_dt

107: -- Cannot be set if the parent IGS_EN_STDNT_PS_ATT.course_attempt_status
108: -- is not one of ENROLLED, INTERMIT or INACTIVE
109: -- Cannot be deceased person
110: -- Cannot be future dated
111: -- Cannot be less than the IGS_EN_STDNT_PS_ATT.commencement_dt
112: -- Cannot be prior to the submission date of a previous thesis_examination
113: -- record
114: -- Must have a principal supervisor
115: -- Must have fields of study = 100%

Line 120: -- Cannot be set if the parent IGS_EN_STDNT_PS_ATT.course_attempt_status is

116: -- Must have socio-economic classifications = 100%
117: -- Must have type of activity code set
118: -- Cannot be prior to the minimum submission date
119: -- Warn if greater than maximum submission date
120: -- Cannot be set if the parent IGS_EN_STDNT_PS_ATT.course_attempt_status is
121: -- COMPLETED and all its associated awards completed.
122:
123: DECLARE
124: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';

Line 144: IGS_EN_STDNT_PS_ATT sca

140: ca.govt_type_of_activity_cd,
141: sca.person_id,
142: sca.course_cd
143: FROM IGS_RE_CANDIDATURE ca,
144: IGS_EN_STDNT_PS_ATT sca
145: WHERE ca.person_id = p_person_id AND
146: ca.sequence_number = p_ca_sequence_number AND
147: sca.person_id = ca.person_id AND
148: sca.course_cd = ca.sca_course_cd;

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

204: tpm.creation_dt = p_creation_dt AND
205: tpm.confirmed_dt IS NOT NULL AND
206: thr.thesis_result_cd = tpm.thesis_result_cd AND
207: thr.s_thesis_result_cd <> cst_no_result;
208: CURSOR c_awd_exists(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
209: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
210: SELECT 'x'
211: FROM igs_en_spa_awd_aim
212: WHERE person_id = cp_person_id

Line 209: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

205: tpm.confirmed_dt IS NOT NULL AND
206: thr.thesis_result_cd = tpm.thesis_result_cd AND
207: thr.s_thesis_result_cd <> cst_no_result;
208: CURSOR c_awd_exists(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
209: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
210: SELECT 'x'
211: FROM igs_en_spa_awd_aim
212: WHERE person_id = cp_person_id
213: AND course_cd = cp_course_cd

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

213: AND course_cd = cp_course_cd
214: AND ( end_dt IS NULL OR
215: (end_dt IS NOT NULL AND complete_ind = 'Y')
216: );
217: CURSOR c_incomp_awd(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
218: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
219: SELECT 'x'
220: FROM igs_en_spa_awd_aim
221: WHERE person_id = cp_person_id

Line 218: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

214: AND ( end_dt IS NULL OR
215: (end_dt IS NOT NULL AND complete_ind = 'Y')
216: );
217: CURSOR c_incomp_awd(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
218: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
219: SELECT 'x'
220: FROM igs_en_spa_awd_aim
221: WHERE person_id = cp_person_id
222: AND course_cd = cp_course_cd

Line 499: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';

495: cst_insert CONSTANT VARCHAR2(10) := 'INSERT';
496: cst_update CONSTANT VARCHAR2(10) := 'UPDATE';
497: cst_delete CONSTANT VARCHAR2(10) := 'DELETE';
498: cst_enrolled CONSTANT
499: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
500: cst_inactive CONSTANT
501: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
502: cst_intermit CONSTANT
503: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';

Line 501: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';

497: cst_delete CONSTANT VARCHAR2(10) := 'DELETE';
498: cst_enrolled CONSTANT
499: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
500: cst_inactive CONSTANT
501: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
502: cst_intermit CONSTANT
503: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
504: cst_completed CONSTANT
505: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';

Line 503: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';

499: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
500: cst_inactive CONSTANT
501: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
502: cst_intermit CONSTANT
503: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
504: cst_completed CONSTANT
505: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';
506: cst_examined CONSTANT IGS_RE_THESIS_V.thesis_status%TYPE := 'EXAMINED';
507: cst_deleted CONSTANT IGS_RE_THESIS_V.thesis_status%TYPE := 'DELETED';

Line 505: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';

501: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
502: cst_intermit CONSTANT
503: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
504: cst_completed CONSTANT
505: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';
506: cst_examined CONSTANT IGS_RE_THESIS_V.thesis_status%TYPE := 'EXAMINED';
507: cst_deleted CONSTANT IGS_RE_THESIS_V.thesis_status%TYPE := 'DELETED';
508: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
509: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

Line 509: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

505: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';
506: cst_examined CONSTANT IGS_RE_THESIS_V.thesis_status%TYPE := 'EXAMINED';
507: cst_deleted CONSTANT IGS_RE_THESIS_V.thesis_status%TYPE := 'DELETED';
508: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
509: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
510: v_thesis_status IGS_RE_THESIS_V.thesis_status%TYPE;
511: v_message_name VARCHAR2(30);
512: CURSOR c_ca IS
513: SELECT ca.sca_course_cd

Line 520: FROM IGS_EN_STDNT_PS_ATT sca

516: ca.sequence_number = p_ca_sequence_number;
517: CURSOR c_sca (
518: cp_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE) IS
519: SELECT sca.course_attempt_status
520: FROM IGS_EN_STDNT_PS_ATT sca
521: WHERE sca.person_id = p_person_id AND
522: sca.course_cd = cp_sca_course_cd;
523: CURSOR c_thev IS
524: SELECT thev.thesis_status

Line 556: -- Select details from IGS_EN_STDNT_PS_ATT

552: IF (v_sca_course_cd IS NULL) THEN
553: p_message_name := 'IGS_RE_CANT_IU_THESIS_EXM_DET';
554: RETURN FALSE;
555: END IF;
556: -- Select details from IGS_EN_STDNT_PS_ATT
557: OPEN c_sca(v_sca_course_cd);
558: FETCH c_sca INTO v_course_attempt_status;
559: CLOSE c_sca;
560: -- 2. Not if the course_attempt_status is not ENROLLED, INTERMIT, COMPLETED or INACTIVE