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.

[Home] [Help]

APPS.IGS_AS_VAL_ESU dependencies on IGS_AS_EXM_SPRVSRTYP

Line 19: v_closed_ind IGS_AS_EXM_SPRVSRTYP.closed_ind%TYPE;

15:
16: BEGIN -- assp_val_est_closed
17: -- Validates the exam supervisor type closed indicator
18: DECLARE
19: v_closed_ind IGS_AS_EXM_SPRVSRTYP.closed_ind%TYPE;
20: CURSOR c_est (
21: cp_exam_supervisor_type IGS_AS_EXM_SPRVSRTYP.exam_supervisor_type%TYPE) IS
22: SELECT est.closed_ind
23: FROM IGS_AS_EXM_SPRVSRTYP est

Line 21: cp_exam_supervisor_type IGS_AS_EXM_SPRVSRTYP.exam_supervisor_type%TYPE) IS

17: -- Validates the exam supervisor type closed indicator
18: DECLARE
19: v_closed_ind IGS_AS_EXM_SPRVSRTYP.closed_ind%TYPE;
20: CURSOR c_est (
21: cp_exam_supervisor_type IGS_AS_EXM_SPRVSRTYP.exam_supervisor_type%TYPE) IS
22: SELECT est.closed_ind
23: FROM IGS_AS_EXM_SPRVSRTYP est
24: WHERE est.exam_supervisor_type = cp_exam_supervisor_type;
25: BEGIN

Line 23: FROM IGS_AS_EXM_SPRVSRTYP est

19: v_closed_ind IGS_AS_EXM_SPRVSRTYP.closed_ind%TYPE;
20: CURSOR c_est (
21: cp_exam_supervisor_type IGS_AS_EXM_SPRVSRTYP.exam_supervisor_type%TYPE) IS
22: SELECT est.closed_ind
23: FROM IGS_AS_EXM_SPRVSRTYP est
24: WHERE est.exam_supervisor_type = cp_exam_supervisor_type;
25: BEGIN
26: P_MESSAGE_NAME := NULL;
27: OPEN c_est(