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_AS_EXAM_SESSION

Line 240: v_start_time IGS_AS_EXAM_SESSION.start_time%TYPE;

236: BEGIN -- assp_val_esu_ese_lmt
237: -- Validate that adding the person to a session at a venue will cause
238: -- the venue.supervisor_lit to be exceeded.
239: DECLARE
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;

Line 241: v_end_time IGS_AS_EXAM_SESSION.end_time%TYPE;

237: -- Validate that adding the person to a session at a venue will cause
238: -- the venue.supervisor_lit to be exceeded.
239: DECLARE
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 (

Line 246: cp_start_time IGS_AS_EXAM_SESSION.start_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)
249: FROM IGS_AS_EXM_INS_SPVSR
250: WHERE exam_cal_type = p_exam_cal_type AND

Line 247: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE) IS

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)
249: FROM IGS_AS_EXM_INS_SPVSR
250: WHERE exam_cal_type = p_exam_cal_type AND
251: exam_ci_sequence_number = p_exam_ci_sequence_number AND

Line 258: cp_start_time IGS_AS_EXAM_SESSION.start_time%TYPE,

254: IGS_GE_GEN_003.GENP_SET_TIME(start_time) = cp_start_time AND
255: IGS_GE_GEN_003.GENP_SET_TIME(end_time) = cp_end_time AND
256: venue_cd = p_venue_cd;
257: CURSOR c_venue_cnt (
258: cp_start_time IGS_AS_EXAM_SESSION.start_time%TYPE,
259: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE) IS
260: SELECT COUNT(person_id) -- v_venue_count
261: FROM IGS_AS_EXM_SES_VN_SP
262: WHERE exam_cal_type = p_exam_cal_type AND

Line 259: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE) IS

255: IGS_GE_GEN_003.GENP_SET_TIME(end_time) = cp_end_time AND
256: venue_cd = p_venue_cd;
257: CURSOR c_venue_cnt (
258: cp_start_time IGS_AS_EXAM_SESSION.start_time%TYPE,
259: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE) IS
260: SELECT COUNT(person_id) -- v_venue_count
261: FROM IGS_AS_EXM_SES_VN_SP
262: WHERE exam_cal_type = p_exam_cal_type AND
263: exam_ci_sequence_number = p_exam_ci_sequence_number AND