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.

[Home] [Help]

APPS.IGS_AS_VAL_ESE dependencies on IGS_AS_EXAM_SESSION

Line 25: FROM IGS_AS_EXAM_SESSION es

21: dai_sequence_number,
22: start_time,
23: end_time,
24: exam_session_number
25: FROM IGS_AS_EXAM_SESSION es
26: WHERE exam_cal_type = p_exam_cal_type AND
27: exam_ci_sequence_number = p_exam_ci_sequence_number;
28: CURSOR c_es1 (
29: cp_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE,

Line 29: cp_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE,

25: FROM IGS_AS_EXAM_SESSION es
26: WHERE exam_cal_type = p_exam_cal_type AND
27: exam_ci_sequence_number = p_exam_ci_sequence_number;
28: CURSOR c_es1 (
29: cp_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE,
30: cp_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE,
31: cp_start_time IGS_AS_EXAM_SESSION.start_time%TYPE,
32: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE,
33: cp_exam_session_number IGS_AS_EXAM_SESSION.exam_session_number%TYPE) IS

Line 30: cp_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE,

26: WHERE exam_cal_type = p_exam_cal_type AND
27: exam_ci_sequence_number = p_exam_ci_sequence_number;
28: CURSOR c_es1 (
29: cp_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE,
30: cp_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE,
31: cp_start_time IGS_AS_EXAM_SESSION.start_time%TYPE,
32: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE,
33: cp_exam_session_number IGS_AS_EXAM_SESSION.exam_session_number%TYPE) IS
34: SELECT 'x'

Line 31: cp_start_time IGS_AS_EXAM_SESSION.start_time%TYPE,

27: exam_ci_sequence_number = p_exam_ci_sequence_number;
28: CURSOR c_es1 (
29: cp_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE,
30: cp_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE,
31: cp_start_time IGS_AS_EXAM_SESSION.start_time%TYPE,
32: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE,
33: cp_exam_session_number IGS_AS_EXAM_SESSION.exam_session_number%TYPE) IS
34: SELECT 'x'
35: FROM IGS_AS_EXAM_SESSION es

Line 32: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE,

28: CURSOR c_es1 (
29: cp_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE,
30: cp_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE,
31: cp_start_time IGS_AS_EXAM_SESSION.start_time%TYPE,
32: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE,
33: cp_exam_session_number IGS_AS_EXAM_SESSION.exam_session_number%TYPE) IS
34: SELECT 'x'
35: FROM IGS_AS_EXAM_SESSION es
36: WHERE es.exam_cal_type = p_exam_cal_type AND

Line 33: cp_exam_session_number IGS_AS_EXAM_SESSION.exam_session_number%TYPE) IS

29: cp_dt_alias IGS_AS_EXAM_SESSION.dt_alias%TYPE,
30: cp_dai_sequence_number IGS_AS_EXAM_SESSION.dai_sequence_number%TYPE,
31: cp_start_time IGS_AS_EXAM_SESSION.start_time%TYPE,
32: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE,
33: cp_exam_session_number IGS_AS_EXAM_SESSION.exam_session_number%TYPE) IS
34: SELECT 'x'
35: FROM IGS_AS_EXAM_SESSION es
36: WHERE es.exam_cal_type = p_exam_cal_type AND
37: es.exam_ci_sequence_number = p_exam_ci_sequence_number AND

Line 35: FROM IGS_AS_EXAM_SESSION es

31: cp_start_time IGS_AS_EXAM_SESSION.start_time%TYPE,
32: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE,
33: cp_exam_session_number IGS_AS_EXAM_SESSION.exam_session_number%TYPE) IS
34: SELECT 'x'
35: FROM IGS_AS_EXAM_SESSION es
36: WHERE es.exam_cal_type = p_exam_cal_type AND
37: es.exam_ci_sequence_number = p_exam_ci_sequence_number AND
38: (dt_alias <> cp_dt_alias OR
39: dai_sequence_number <> cp_dai_sequence_number OR

Line 87: v_alias_val IGS_AS_EXAM_SESSION_V.alias_val%TYPE;

83: -- within the same examination calendar.
84: -- This routine only returns warning, as it is seen as possible in unusual
85: -- situations
86: DECLARE
87: v_alias_val IGS_AS_EXAM_SESSION_V.alias_val%TYPE;
88: CURSOR c_daiv(
89: cp_exam_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
90: cp_exam_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
91: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,

Line 100: cp_exam_cal_type IGS_AS_EXAM_SESSION_V.exam_cal_type%TYPE,

96: daiv.ci_sequence_number = cp_exam_ci_sequence_number AND
97: daiv.dt_alias = cp_dt_alias AND
98: daiv.sequence_number = cp_dai_sequence_number;
99: CURSOR c_esv (
100: cp_exam_cal_type IGS_AS_EXAM_SESSION_V.exam_cal_type%TYPE,
101: cp_exam_ci_sequence_number IGS_AS_EXAM_SESSION_V.exam_ci_sequence_number%TYPE,
102: cp_alias_val IGS_AS_EXAM_SESSION_V.alias_val%TYPE) IS
103: SELECT *
104: FROM IGS_AS_EXAM_SESSION_V esv

Line 101: cp_exam_ci_sequence_number IGS_AS_EXAM_SESSION_V.exam_ci_sequence_number%TYPE,

97: daiv.dt_alias = cp_dt_alias AND
98: daiv.sequence_number = cp_dai_sequence_number;
99: CURSOR c_esv (
100: cp_exam_cal_type IGS_AS_EXAM_SESSION_V.exam_cal_type%TYPE,
101: cp_exam_ci_sequence_number IGS_AS_EXAM_SESSION_V.exam_ci_sequence_number%TYPE,
102: cp_alias_val IGS_AS_EXAM_SESSION_V.alias_val%TYPE) IS
103: SELECT *
104: FROM IGS_AS_EXAM_SESSION_V esv
105: WHERE esv.exam_cal_type = cp_exam_cal_type AND

Line 102: cp_alias_val IGS_AS_EXAM_SESSION_V.alias_val%TYPE) IS

98: daiv.sequence_number = cp_dai_sequence_number;
99: CURSOR c_esv (
100: cp_exam_cal_type IGS_AS_EXAM_SESSION_V.exam_cal_type%TYPE,
101: cp_exam_ci_sequence_number IGS_AS_EXAM_SESSION_V.exam_ci_sequence_number%TYPE,
102: cp_alias_val IGS_AS_EXAM_SESSION_V.alias_val%TYPE) IS
103: SELECT *
104: FROM IGS_AS_EXAM_SESSION_V esv
105: WHERE esv.exam_cal_type = cp_exam_cal_type AND
106: esv.exam_ci_sequence_number = cp_exam_ci_sequence_number AND

Line 104: FROM IGS_AS_EXAM_SESSION_V esv

100: cp_exam_cal_type IGS_AS_EXAM_SESSION_V.exam_cal_type%TYPE,
101: cp_exam_ci_sequence_number IGS_AS_EXAM_SESSION_V.exam_ci_sequence_number%TYPE,
102: cp_alias_val IGS_AS_EXAM_SESSION_V.alias_val%TYPE) IS
103: SELECT *
104: FROM IGS_AS_EXAM_SESSION_V esv
105: WHERE esv.exam_cal_type = cp_exam_cal_type AND
106: esv.exam_ci_sequence_number = cp_exam_ci_sequence_number AND
107: esv.alias_val = cp_alias_val;
108: BEGIN

Line 132: -- Loop through IGS_AS_EXAM_SESSION_V records validating each record for

128: CLOSE c_daiv;
129: RETURN TRUE;
130: END IF;
131: CLOSE c_daiv;
132: -- Loop through IGS_AS_EXAM_SESSION_V records validating each record for
133: -- time overlaps
134: FOR v_esv_rec IN c_esv(
135: p_exam_cal_type,
136: p_exam_ci_sequence_number,

Line 166: -- Validate the IGS_AS_EXAM_SESSION calendar instance

162: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_ESE.assp_val_ese_ovrlp');
163: IGS_GE_MSG_STACK.ADD;
164: END assp_val_ese_ovrlp;
165: --
166: -- Validate the IGS_AS_EXAM_SESSION calendar instance
167: FUNCTION ASSP_VAL_ESE_CI(
168: p_cal_type IN VARCHAR2 ,
169: p_sequence_number IN NUMBER ,
170: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )

Line 174: -- Validate the calendar instance being linked to an IGS_AS_EXAM_SESSION record.

170: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
171: RETURN BOOLEAN AS
172:
173: BEGIN -- assp_val_ese_ci
174: -- Validate the calendar instance being linked to an IGS_AS_EXAM_SESSION record.
175: -- Check for :
176: -- . Calendar type must have SI_CA_S_CA_CAT of 'EXAM'
177: -- . Calendar instance must have s_cal_status of 'ACTIVE'
178: DECLARE