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_GE_GEN_003

Line 91: IGS_GE_GEN_003.GENP_SET_TIME(eis.start_time) = v_start_time AND

87: eis.exam_cal_type = p_exam_cal_type AND
88: eis.exam_ci_sequence_number = p_exam_ci_sequence_number AND
89: eis.dt_alias = p_dt_alias AND
90: eis.dai_sequence_number = p_dai_sequence_number AND
91: IGS_GE_GEN_003.GENP_SET_TIME(eis.start_time) = v_start_time AND
92: IGS_GE_GEN_003.GENP_SET_TIME(eis.end_time) = v_end_time AND
93: eis.venue_cd = p_venue_cd AND
94: eis.person_id = esu.person_id AND
95: esu.exam_supervisor_type = est.exam_supervisor_type AND

Line 92: IGS_GE_GEN_003.GENP_SET_TIME(eis.end_time) = v_end_time AND

88: eis.exam_ci_sequence_number = p_exam_ci_sequence_number AND
89: eis.dt_alias = p_dt_alias AND
90: eis.dai_sequence_number = p_dai_sequence_number AND
91: IGS_GE_GEN_003.GENP_SET_TIME(eis.start_time) = v_start_time AND
92: IGS_GE_GEN_003.GENP_SET_TIME(eis.end_time) = v_end_time AND
93: eis.venue_cd = p_venue_cd AND
94: eis.person_id = esu.person_id AND
95: esu.exam_supervisor_type = est.exam_supervisor_type AND
96: est.in_charge_ind = 'Y';

Line 107: IGS_GE_GEN_003.GENP_SET_TIME(esvs.start_time) = v_start_time AND

103: esvs.exam_cal_type = p_exam_cal_type AND
104: esvs.exam_ci_sequence_number = p_exam_ci_sequence_number AND
105: esvs.dt_alias = p_dt_alias AND
106: esvs.dai_sequence_number = p_dai_sequence_number AND
107: IGS_GE_GEN_003.GENP_SET_TIME(esvs.start_time) = v_start_time AND
108: IGS_GE_GEN_003.GENP_SET_TIME(esvs.end_time) = v_end_time AND
109: esvs.venue_cd = p_venue_cd AND
110: esvs.person_id = esu.person_id AND
111: esu.exam_supervisor_type = est.exam_supervisor_type AND

Line 108: IGS_GE_GEN_003.GENP_SET_TIME(esvs.end_time) = v_end_time AND

104: esvs.exam_ci_sequence_number = p_exam_ci_sequence_number AND
105: esvs.dt_alias = p_dt_alias AND
106: esvs.dai_sequence_number = p_dai_sequence_number AND
107: IGS_GE_GEN_003.GENP_SET_TIME(esvs.start_time) = v_start_time AND
108: IGS_GE_GEN_003.GENP_SET_TIME(esvs.end_time) = v_end_time AND
109: esvs.venue_cd = p_venue_cd AND
110: esvs.person_id = esu.person_id AND
111: esu.exam_supervisor_type = est.exam_supervisor_type AND
112: est.in_charge_ind = 'Y';

Line 128: v_start_time := IGS_GE_GEN_003.GENP_SET_TIME(p_start_time);

124: END IF;
125: CLOSE c_check_not_charge;
126: -- Check if more than one supervisor to a session and venue has been allocated
127: -- as being 'in-charge'.
128: v_start_time := IGS_GE_GEN_003.GENP_SET_TIME(p_start_time);
129: v_end_time := IGS_GE_GEN_003.GENP_SET_TIME(p_end_time);
130: -- Determine the distinct number of supervisors already allocated to the
131: -- session/venu within the exam instance that are 'in-charge'
132: OPEN c_exam_inst_count;

Line 129: v_end_time := IGS_GE_GEN_003.GENP_SET_TIME(p_end_time);

125: CLOSE c_check_not_charge;
126: -- Check if more than one supervisor to a session and venue has been allocated
127: -- as being 'in-charge'.
128: v_start_time := IGS_GE_GEN_003.GENP_SET_TIME(p_start_time);
129: v_end_time := IGS_GE_GEN_003.GENP_SET_TIME(p_end_time);
130: -- Determine the distinct number of supervisors already allocated to the
131: -- session/venu within the exam instance that are 'in-charge'
132: OPEN c_exam_inst_count;
133: FETCH c_exam_inst_count INTO v_exam_inst_count;

Line 254: IGS_GE_GEN_003.GENP_SET_TIME(start_time) = cp_start_time AND

250: WHERE exam_cal_type = p_exam_cal_type AND
251: exam_ci_sequence_number = p_exam_ci_sequence_number AND
252: dt_alias = p_dt_alias AND
253: dai_sequence_number = p_dai_sequence_number AND
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,

Line 255: IGS_GE_GEN_003.GENP_SET_TIME(end_time) = cp_end_time AND

251: exam_ci_sequence_number = p_exam_ci_sequence_number AND
252: dt_alias = p_dt_alias AND
253: dai_sequence_number = p_dai_sequence_number AND
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

Line 266: IGS_GE_GEN_003.GENP_SET_TIME(start_time) = cp_start_time AND

262: WHERE exam_cal_type = p_exam_cal_type AND
263: exam_ci_sequence_number = p_exam_ci_sequence_number AND
264: dt_alias = p_dt_alias AND
265: dai_sequence_number = p_dai_sequence_number AND
266: IGS_GE_GEN_003.GENP_SET_TIME(start_time) = cp_start_time AND
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

Line 267: IGS_GE_GEN_003.GENP_SET_TIME(end_time) = cp_end_time AND

263: exam_ci_sequence_number = p_exam_ci_sequence_number AND
264: dt_alias = p_dt_alias AND
265: dai_sequence_number = p_dai_sequence_number AND
266: IGS_GE_GEN_003.GENP_SET_TIME(start_time) = cp_start_time AND
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

Line 277: v_start_time := IGS_GE_GEN_003.GENP_SET_TIME(

273: BEGIN
274: P_MESSAGE_NAME := NULL;
275: -- Check if the allocation of a supervisor to a session and venue will cause
276: -- the venue.supervisor_limit to be exceeded.
277: v_start_time := IGS_GE_GEN_003.GENP_SET_TIME(
278: p_start_time);
279: v_end_time := IGS_GE_GEN_003.GENP_SET_TIME(
280: p_end_time);
281: -- Determine the distinct number of supervisors already allocated to the

Line 279: v_end_time := IGS_GE_GEN_003.GENP_SET_TIME(

275: -- Check if the allocation of a supervisor to a session and venue will cause
276: -- the venue.supervisor_limit to be exceeded.
277: v_start_time := IGS_GE_GEN_003.GENP_SET_TIME(
278: p_start_time);
279: v_end_time := IGS_GE_GEN_003.GENP_SET_TIME(
280: p_end_time);
281: -- Determine the distinct number of supervisors already allocated to the
282: -- session/venu within the exam instance
283: OPEN c_sprvsr_cnt(