APPS.IGS_AS_VAL_ESE dependencies on IGS_AS_EXAM_SESSION_V

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,