APPS.IGS_RE_VAL_TEX dependencies on IGS_RE_THESIS_V

Line 506: cst_examined CONSTANT IGS_RE_THESIS_V.thesis_status%TYPE := 'EXAMINED';

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;
510: v_thesis_status IGS_RE_THESIS_V.thesis_status%TYPE;

Line 507: cst_deleted CONSTANT IGS_RE_THESIS_V.thesis_status%TYPE := 'DELETED';

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

Line 510: v_thesis_status IGS_RE_THESIS_V.thesis_status%TYPE;

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
514: FROM IGS_RE_CANDIDATURE ca

Line 525: FROM IGS_RE_THESIS_V thev

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
525: FROM IGS_RE_THESIS_V thev
526: WHERE thev.person_id = p_person_id AND
527: thev.ca_sequence_number = p_ca_sequence_number AND
528: thev.sequence_number = p_the_sequence_number;
529: BEGIN

Line 706: FROM IGS_RE_THESIS_V thev

702: tpm.the_sequence_number = p_the_sequence_number AND
703: tpm.creation_dt = p_creation_dt;
704: CURSOR c_thev IS
705: SELECT 'x'
706: FROM IGS_RE_THESIS_V thev
707: WHERE thev.person_id = p_person_id AND
708: thev.ca_sequence_number = p_ca_sequence_number AND
709: thev.sequence_number = p_the_sequence_number AND
710: thev.thesis_status = cst_examined;