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_AS_VAL_EIS dependencies on IGS_GR_VENUE

Line 244: v_supervisor_limit IGS_GR_VENUE.supervisor_limit%TYPE;

240: v_start_time IGS_AS_EXAM_SESSION.start_time%TYPE;
241: v_end_time IGS_AS_EXAM_SESSION.end_time%TYPE;
242: v_supervisor_count NUMBER(5);
243: v_venue_count NUMBER(5);
244: v_supervisor_limit IGS_GR_VENUE.supervisor_limit%TYPE;
245: CURSOR c_sprvsr_cnt (
246: cp_start_time IGS_AS_EXAM_SESSION.start_time%TYPE,
247: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE) IS
248: SELECT COUNT(DISTINCT person_id)

Line 271: FROM IGS_GR_VENUE

267: IGS_GE_GEN_003.GENP_SET_TIME(end_time) = cp_end_time AND
268: venue_cd = p_venue_cd;
269: CURSOR c_venue IS
270: SELECT supervisor_limit
271: FROM IGS_GR_VENUE
272: WHERE venue_cd = p_venue_cd;
273: BEGIN
274: P_MESSAGE_NAME := NULL;
275: -- Check if the allocation of a supervisor to a session and venue will cause