APPS.IGS_RE_VAL_TPM dependencies on IGS_RE_THESIS_EXAM

Line 370: v_tex_rec IGS_RE_THESIS_EXAM.submission_dt%TYPE;

366: -- * Cannot be a closed IGS_RE_THESIS result code
367: -- * Cannot set if parent thesis_examination has not been submitted
368: -- * Cannot set if panel member has not confirmed
369: DECLARE
370: v_tex_rec IGS_RE_THESIS_EXAM.submission_dt%TYPE;
371: v_thr_rec IGS_RE_THESIS_RESULT.closed_ind%TYPE;
372: CURSOR c_tex IS
373: SELECT tex.submission_dt
374: FROM IGS_RE_THESIS_EXAM tex

Line 374: FROM IGS_RE_THESIS_EXAM tex

370: v_tex_rec IGS_RE_THESIS_EXAM.submission_dt%TYPE;
371: v_thr_rec IGS_RE_THESIS_RESULT.closed_ind%TYPE;
372: CURSOR c_tex IS
373: SELECT tex.submission_dt
374: FROM IGS_RE_THESIS_EXAM tex
375: WHERE tex.person_id = p_ca_person_id AND
376: tex.ca_sequence_number = p_ca_sequence_number AND
377: tex.the_sequence_number = p_the_sequence_number AND
378: tex.creation_dt = p_creation_dt;

Line 502: v_thesis_result_cd IGS_RE_THESIS_EXAM.thesis_result_cd%TYPE;

498: DECLARE
499: cst_insert CONSTANT VARCHAR2(10) := 'INSERT';
500: cst_delete CONSTANT VARCHAR2(10) := 'DELETE';
501: cst_update CONSTANT VARCHAR2(10) := 'UPDATE';
502: v_thesis_result_cd IGS_RE_THESIS_EXAM.thesis_result_cd%TYPE;
503: CURSOR c_tex IS
504: SELECT tex.thesis_result_cd
505: FROM IGS_RE_THESIS_EXAM tex
506: WHERE tex.person_id = p_ca_person_id AND

Line 505: FROM IGS_RE_THESIS_EXAM tex

501: cst_update CONSTANT VARCHAR2(10) := 'UPDATE';
502: v_thesis_result_cd IGS_RE_THESIS_EXAM.thesis_result_cd%TYPE;
503: CURSOR c_tex IS
504: SELECT tex.thesis_result_cd
505: FROM IGS_RE_THESIS_EXAM tex
506: WHERE tex.person_id = p_ca_person_id AND
507: tex.ca_sequence_number = p_ca_sequence_number AND
508: tex.the_sequence_number = p_the_sequence_number AND
509: tex.creation_dt = p_creation_dt;