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_THE dependencies on IGS_RE_THESIS_RESULT

Line 346: -- To validate the IGS_RE_THESIS result code

342: IGS_GE_MSG_STACK.ADD;
343: App_Exception.Raise_Exception;
344: END resp_val_the_lbry;
345: --
346: -- To validate the IGS_RE_THESIS result code
347: FUNCTION RESP_VAL_THE_THR(
348: p_person_id IN NUMBER ,
349: p_ca_sequence_number IN NUMBER ,
350: p_sequence_number IN NUMBER ,

Line 375: v_closed_ind IGS_RE_THESIS_RESULT.closed_ind%TYPE;

371: DECLARE
372: cst_pending CONSTANT VARCHAR2(10) := 'PENDING';
373: v_dummy VARCHAR2(1);
374: v_thesis_status IGS_RE_THESIS_V.thesis_status%TYPE;
375: v_closed_ind IGS_RE_THESIS_RESULT.closed_ind%TYPE;
376: v_final_result_ind IGS_LOOKUPS_VIEW.final_result_ind%TYPE;
377: v_thesis_result_cd IGS_RE_THESIS_EXAM.thesis_result_cd%TYPE;
378: CURSOR c_thev IS
379: SELECT thev.thesis_status

Line 397: FROM IGS_RE_THESIS_RESULT thr,

393: -- Bug # 2146848 .
394: CURSOR c_thr_sthr IS
395: SELECT thr.closed_ind,
396: sthr.final_result_ind
397: FROM IGS_RE_THESIS_RESULT thr,
398: IGS_LOOKUPS_VIEW sthr
399: WHERE thr.thesis_result_cd = p_thesis_result_cd AND
400: sthr.LOOKUP_CODE = thr.s_thesis_result_cd
401: AND sthr.lookup_type = 'THESIS_RESULT';