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_ESVS dependencies on IGS_GE_GEN_003

Line 44: v_start_time := Igs_Ge_Gen_003.GENP_SET_TIME(p_start_time);

40: BEGIN
41: P_MESSAGE_NAME := NULL;
42: v_system_date := SYSDATE;
43: v_flag := 'F' ;
44: v_start_time := Igs_Ge_Gen_003.GENP_SET_TIME(p_start_time);
45: v_end_time := Igs_Ge_Gen_003.GENP_SET_TIME(p_end_time);
46: OPEN c_ei;
47: LOOP
48: FETCH c_ei INTO v_x;

Line 45: v_end_time := Igs_Ge_Gen_003.GENP_SET_TIME(p_end_time);

41: P_MESSAGE_NAME := NULL;
42: v_system_date := SYSDATE;
43: v_flag := 'F' ;
44: v_start_time := Igs_Ge_Gen_003.GENP_SET_TIME(p_start_time);
45: v_end_time := Igs_Ge_Gen_003.GENP_SET_TIME(p_end_time);
46: OPEN c_ei;
47: LOOP
48: FETCH c_ei INTO v_x;
49: EXIT WHEN c_ei%NOTFOUND ;

Line 50: IF Igs_Ge_Gen_003.GENP_SET_TIME(v_x.start_time) = v_start_time AND

46: OPEN c_ei;
47: LOOP
48: FETCH c_ei INTO v_x;
49: EXIT WHEN c_ei%NOTFOUND ;
50: IF Igs_Ge_Gen_003.GENP_SET_TIME(v_x.start_time) = v_start_time AND
51: Igs_Ge_Gen_003.GENP_SET_TIME(v_x.end_time) = v_end_time THEN
52: v_flag := 'T' ;
53: EXIT;
54: END IF;

Line 51: Igs_Ge_Gen_003.GENP_SET_TIME(v_x.end_time) = v_end_time THEN

47: LOOP
48: FETCH c_ei INTO v_x;
49: EXIT WHEN c_ei%NOTFOUND ;
50: IF Igs_Ge_Gen_003.GENP_SET_TIME(v_x.start_time) = v_start_time AND
51: Igs_Ge_Gen_003.GENP_SET_TIME(v_x.end_time) = v_end_time THEN
52: v_flag := 'T' ;
53: EXIT;
54: END IF;
55: END LOOP;

Line 253: ((Igs_Ge_Gen_003.GENP_SET_TIME(NVL(override_start_time, start_time))

249: dt_alias,
250: dai_sequence_number,
251: exam_cal_type,
252: exam_ci_sequence_number) = v_dt_alias_val AND
253: ((Igs_Ge_Gen_003.GENP_SET_TIME(NVL(override_start_time, start_time))
254: BETWEEN v_start_time AND v_end_time OR
255: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time))
256: BETWEEN v_start_time AND v_end_time)) OR
257: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_start_time, start_time)) <= v_start_time AND

Line 255: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time))

251: exam_cal_type,
252: exam_ci_sequence_number) = v_dt_alias_val AND
253: ((Igs_Ge_Gen_003.GENP_SET_TIME(NVL(override_start_time, start_time))
254: BETWEEN v_start_time AND v_end_time OR
255: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time))
256: BETWEEN v_start_time AND v_end_time)) OR
257: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_start_time, start_time)) <= v_start_time AND
258: Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time)) >= v_end_time)) AND
259: venue_cd <> p_venue_cd;

Line 257: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_start_time, start_time)) <= v_start_time AND

253: ((Igs_Ge_Gen_003.GENP_SET_TIME(NVL(override_start_time, start_time))
254: BETWEEN v_start_time AND v_end_time OR
255: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time))
256: BETWEEN v_start_time AND v_end_time)) OR
257: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_start_time, start_time)) <= v_start_time AND
258: Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time)) >= v_end_time)) AND
259: venue_cd <> p_venue_cd;
260: CURSOR c_esvs IS
261: SELECT 'X'

Line 258: Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time)) >= v_end_time)) AND

254: BETWEEN v_start_time AND v_end_time OR
255: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time))
256: BETWEEN v_start_time AND v_end_time)) OR
257: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_start_time, start_time)) <= v_start_time AND
258: Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time)) >= v_end_time)) AND
259: venue_cd <> p_venue_cd;
260: CURSOR c_esvs IS
261: SELECT 'X'
262: FROM IGS_AS_EXM_SES_VN_SP esvs

Line 269: ((Igs_Ge_Gen_003.GENP_SET_TIME(NVL(override_start_time, start_time))

265: dt_alias,
266: dai_sequence_number,
267: exam_cal_type,
268: exam_ci_sequence_number) = v_dt_alias_val AND
269: ((Igs_Ge_Gen_003.GENP_SET_TIME(NVL(override_start_time, start_time))
270: BETWEEN v_start_time AND v_end_time OR
271: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time))
272: BETWEEN v_start_time AND v_end_time)) OR
273: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_start_time, start_time)) <= v_start_time AND

Line 271: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time))

267: exam_cal_type,
268: exam_ci_sequence_number) = v_dt_alias_val AND
269: ((Igs_Ge_Gen_003.GENP_SET_TIME(NVL(override_start_time, start_time))
270: BETWEEN v_start_time AND v_end_time OR
271: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time))
272: BETWEEN v_start_time AND v_end_time)) OR
273: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_start_time, start_time)) <= v_start_time AND
274: Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time)) >= v_end_time)) AND
275: venue_cd <> p_venue_cd;

Line 273: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_start_time, start_time)) <= v_start_time AND

269: ((Igs_Ge_Gen_003.GENP_SET_TIME(NVL(override_start_time, start_time))
270: BETWEEN v_start_time AND v_end_time OR
271: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time))
272: BETWEEN v_start_time AND v_end_time)) OR
273: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_start_time, start_time)) <= v_start_time AND
274: Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time)) >= v_end_time)) AND
275: venue_cd <> p_venue_cd;
276: BEGIN
277: --Set the default message number

Line 274: Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time)) >= v_end_time)) AND

270: BETWEEN v_start_time AND v_end_time OR
271: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time))
272: BETWEEN v_start_time AND v_end_time)) OR
273: (Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_start_time, start_time)) <= v_start_time AND
274: Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time)) >= v_end_time)) AND
275: venue_cd <> p_venue_cd;
276: BEGIN
277: --Set the default message number
278: P_MESSAGE_NAME := NULL;

Line 289: v_start_time := Igs_Ge_Gen_003.GENP_SET_TIME(NVL(p_override_start_time, p_start_time));

285: --Calculate which time parameter to use and set the date component
286: --to be consistent when comparing times.
287: --This is due to the date component varying when entering
288: --a time format within a form
289: v_start_time := Igs_Ge_Gen_003.GENP_SET_TIME(NVL(p_override_start_time, p_start_time));
290: v_end_time := Igs_Ge_Gen_003.GENP_SET_TIME( NVL(p_override_end_time, p_end_time));
291: OPEN c_eis;
292: FETCH c_eis INTO v_eis_exists;
293: IF (c_eis%FOUND) THEN

Line 290: v_end_time := Igs_Ge_Gen_003.GENP_SET_TIME( NVL(p_override_end_time, p_end_time));

286: --to be consistent when comparing times.
287: --This is due to the date component varying when entering
288: --a time format within a form
289: v_start_time := Igs_Ge_Gen_003.GENP_SET_TIME(NVL(p_override_start_time, p_start_time));
290: v_end_time := Igs_Ge_Gen_003.GENP_SET_TIME( NVL(p_override_end_time, p_end_time));
291: OPEN c_eis;
292: FETCH c_eis INTO v_eis_exists;
293: IF (c_eis%FOUND) THEN
294: P_MESSAGE_NAME := 'IGS_AS_PRSN_ALLOC_DIFF_VENUE';