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_GEN_006 dependencies on IGS_AS_EXAM_SESSION

Line 40: --This module retrieves one of IGS_AS_EXAM_SESSION unique identifiers:

36: p_end_time IN OUT NOCOPY DATE ,
37: p_ese_id IN OUT NOCOPY NUMBER )
38: IS
39: BEGIN --assp_get_ese_key
40: --This module retrieves one of IGS_AS_EXAM_SESSION unique identifiers:
41: --1. exam_cal_type, exam_ci_sequence_number, dt_alias, dai_sequence_number,
42: -- start_time, end_time
43: --2. ese_id
44: DECLARE

Line 45: v_exam_cal_type IGS_AS_EXAM_SESSION.exam_cal_type%TYPE;

41: --1. exam_cal_type, exam_ci_sequence_number, dt_alias, dai_sequence_number,
42: -- start_time, end_time
43: --2. ese_id
44: DECLARE
45: v_exam_cal_type IGS_AS_EXAM_SESSION.exam_cal_type%TYPE;
46: v_exam_ci_sequence_number IGS_AS_EXAM_SESSION.exam_ci_sequence_number%TYPE;
47: v_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE;
48: v_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE;
49: v_start_time IGS_AS_EXAM_SESSION.start_time%TYPE;

Line 46: v_exam_ci_sequence_number IGS_AS_EXAM_SESSION.exam_ci_sequence_number%TYPE;

42: -- start_time, end_time
43: --2. ese_id
44: DECLARE
45: v_exam_cal_type IGS_AS_EXAM_SESSION.exam_cal_type%TYPE;
46: v_exam_ci_sequence_number IGS_AS_EXAM_SESSION.exam_ci_sequence_number%TYPE;
47: v_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE;
48: v_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE;
49: v_start_time IGS_AS_EXAM_SESSION.start_time%TYPE;
50: v_end_time IGS_AS_EXAM_SESSION.end_time%TYPE;

Line 47: v_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE;

43: --2. ese_id
44: DECLARE
45: v_exam_cal_type IGS_AS_EXAM_SESSION.exam_cal_type%TYPE;
46: v_exam_ci_sequence_number IGS_AS_EXAM_SESSION.exam_ci_sequence_number%TYPE;
47: v_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE;
48: v_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE;
49: v_start_time IGS_AS_EXAM_SESSION.start_time%TYPE;
50: v_end_time IGS_AS_EXAM_SESSION.end_time%TYPE;
51: v_ese_id IGS_AS_EXAM_SESSION.ese_id%TYPE;

Line 48: v_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE;

44: DECLARE
45: v_exam_cal_type IGS_AS_EXAM_SESSION.exam_cal_type%TYPE;
46: v_exam_ci_sequence_number IGS_AS_EXAM_SESSION.exam_ci_sequence_number%TYPE;
47: v_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE;
48: v_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE;
49: v_start_time IGS_AS_EXAM_SESSION.start_time%TYPE;
50: v_end_time IGS_AS_EXAM_SESSION.end_time%TYPE;
51: v_ese_id IGS_AS_EXAM_SESSION.ese_id%TYPE;
52: CURSOR c_ese IS

Line 49: v_start_time IGS_AS_EXAM_SESSION.start_time%TYPE;

45: v_exam_cal_type IGS_AS_EXAM_SESSION.exam_cal_type%TYPE;
46: v_exam_ci_sequence_number IGS_AS_EXAM_SESSION.exam_ci_sequence_number%TYPE;
47: v_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE;
48: v_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE;
49: v_start_time IGS_AS_EXAM_SESSION.start_time%TYPE;
50: v_end_time IGS_AS_EXAM_SESSION.end_time%TYPE;
51: v_ese_id IGS_AS_EXAM_SESSION.ese_id%TYPE;
52: CURSOR c_ese IS
53: SELECT ese.ese_id

Line 50: v_end_time IGS_AS_EXAM_SESSION.end_time%TYPE;

46: v_exam_ci_sequence_number IGS_AS_EXAM_SESSION.exam_ci_sequence_number%TYPE;
47: v_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE;
48: v_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE;
49: v_start_time IGS_AS_EXAM_SESSION.start_time%TYPE;
50: v_end_time IGS_AS_EXAM_SESSION.end_time%TYPE;
51: v_ese_id IGS_AS_EXAM_SESSION.ese_id%TYPE;
52: CURSOR c_ese IS
53: SELECT ese.ese_id
54: FROM IGS_AS_EXAM_SESSION ese

Line 51: v_ese_id IGS_AS_EXAM_SESSION.ese_id%TYPE;

47: v_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE;
48: v_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE;
49: v_start_time IGS_AS_EXAM_SESSION.start_time%TYPE;
50: v_end_time IGS_AS_EXAM_SESSION.end_time%TYPE;
51: v_ese_id IGS_AS_EXAM_SESSION.ese_id%TYPE;
52: CURSOR c_ese IS
53: SELECT ese.ese_id
54: FROM IGS_AS_EXAM_SESSION ese
55: WHERE exam_cal_type = p_exam_cal_type AND

Line 54: FROM IGS_AS_EXAM_SESSION ese

50: v_end_time IGS_AS_EXAM_SESSION.end_time%TYPE;
51: v_ese_id IGS_AS_EXAM_SESSION.ese_id%TYPE;
52: CURSOR c_ese IS
53: SELECT ese.ese_id
54: FROM IGS_AS_EXAM_SESSION ese
55: WHERE exam_cal_type = p_exam_cal_type AND
56: exam_ci_sequence_number = p_exam_ci_sequence_number AND
57: dt_alias = p_dt_alias AND
58: dai_sequence_number = p_dai_sequence_number AND

Line 68: FROM IGS_AS_EXAM_SESSION ese

64: dt_alias,
65: dai_sequence_number,
66: start_time,
67: end_time
68: FROM IGS_AS_EXAM_SESSION ese
69: WHERE ese_id = p_ese_id;
70: BEGIN
71: --Check if p_exam_cal_type has been passed
72: IF (p_exam_cal_type IS NOT NULL) THEN

Line 2003: FROM IGS_AS_EXAM_SESSION es

1999: ci_end_dt,
2000: start_time,
2001: end_time,
2002: ese_id
2003: FROM IGS_AS_EXAM_SESSION es
2004: WHERE exam_cal_type = p_exam_cal_type AND
2005: exam_ci_sequence_number = p_exam_ci_sequence_number AND
2006: NOT EXISTS (
2007: SELECT 'x'