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_RE_CANDIDATURE

Line 143: FROM IGS_RE_CANDIDATURE ca,

139: ca.max_submission_dt,
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

Line 226: v_min_submission IGS_RE_CANDIDATURE.min_submission_dt%TYPE DEFAULT NULL;

222: AND course_cd = cp_course_cd
223: AND NVL(complete_ind,'N') = 'N'
224: AND end_dt IS NULL;
225: v_tpm_exists VARCHAR2(1);
226: v_min_submission IGS_RE_CANDIDATURE.min_submission_dt%TYPE DEFAULT NULL;
227: v_max_submission IGS_RE_CANDIDATURE.max_submission_dt%TYPE DEFAULT NULL;
228: v_message_name VARCHAR2(30);
229: BEGIN
230: -- Set the default message number

Line 227: v_max_submission IGS_RE_CANDIDATURE.max_submission_dt%TYPE DEFAULT NULL;

223: AND NVL(complete_ind,'N') = 'N'
224: AND end_dt IS NULL;
225: v_tpm_exists VARCHAR2(1);
226: v_min_submission IGS_RE_CANDIDATURE.min_submission_dt%TYPE DEFAULT NULL;
227: v_max_submission IGS_RE_CANDIDATURE.max_submission_dt%TYPE DEFAULT NULL;
228: v_message_name VARCHAR2(30);
229: BEGIN
230: -- Set the default message number
231: p_message_name := NULL;

Line 508: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;

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;
510: v_thesis_status IGS_RE_THESIS_V.thesis_status%TYPE;
511: v_message_name VARCHAR2(30);
512: CURSOR c_ca IS

Line 514: FROM IGS_RE_CANDIDATURE ca

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
514: FROM IGS_RE_CANDIDATURE ca
515: WHERE ca.person_id = p_person_id AND
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

Line 518: cp_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE) IS

514: FROM IGS_RE_CANDIDATURE ca
515: WHERE ca.person_id = p_person_id AND
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;