APPS.IGS_AS_VAL_EIS dependencies on IGS_AS_EXM_SPRVSRTYP

Line 77: FROM IGS_AS_EXM_SPRVSRTYP

73: v_exam_inst_count NUMBER(5);
74: v_venue_count NUMBER(5);
75: CURSOR c_check_not_charge IS
76: SELECT 'x'
77: FROM IGS_AS_EXM_SPRVSRTYP
78: WHERE exam_supervisor_type = p_exam_supervisor_type AND
79: in_charge_ind = 'N';
80: v_not_charge_exist VARCHAR2(1);
81: CURSOR c_exam_inst_count IS

Line 85: IGS_AS_EXM_SPRVSRTYP est

81: CURSOR c_exam_inst_count IS
82: SELECT count(distinct eis.person_id)
83: FROM IGS_AS_EXM_INS_SPVSR eis,
84: IGS_AS_EXM_SUPRVISOR esu,
85: IGS_AS_EXM_SPRVSRTYP est
86: WHERE eis.person_id <> p_person_id 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

Line 101: IGS_AS_EXM_SPRVSRTYP est

97: CURSOR c_venue_count IS
98: SELECT count(esvs.person_id)
99: FROM IGS_AS_EXM_SES_VN_SP esvs,
100: IGS_AS_EXM_SUPRVISOR esu,
101: IGS_AS_EXM_SPRVSRTYP est
102: WHERE esvs.person_id <> p_person_id 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

Line 176: v_est_in_charge_ind IGS_AS_EXM_SPRVSRTYP.in_charge_ind%TYPE;

172: -- IGS_AS_EXM_INS_SPVSR or IGS_AS_EXM_SES_VN_SP. If the person is being
173: -- made an in-charge supervisor when they are normally are not in-charge,
174: -- then return a warning message.
175: DECLARE
176: v_est_in_charge_ind IGS_AS_EXM_SPRVSRTYP.in_charge_ind%TYPE;
177: v_in_charge_ind IGS_AS_EXM_SPRVSRTYP.in_charge_ind%TYPE;
178: CURSOR c_est IS
179: SELECT est.in_charge_ind
180: FROM IGS_AS_EXM_SUPRVISOR esu,

Line 177: v_in_charge_ind IGS_AS_EXM_SPRVSRTYP.in_charge_ind%TYPE;

173: -- made an in-charge supervisor when they are normally are not in-charge,
174: -- then return a warning message.
175: DECLARE
176: v_est_in_charge_ind IGS_AS_EXM_SPRVSRTYP.in_charge_ind%TYPE;
177: v_in_charge_ind IGS_AS_EXM_SPRVSRTYP.in_charge_ind%TYPE;
178: CURSOR c_est IS
179: SELECT est.in_charge_ind
180: FROM IGS_AS_EXM_SUPRVISOR esu,
181: IGS_AS_EXM_SPRVSRTYP est

Line 181: IGS_AS_EXM_SPRVSRTYP est

177: v_in_charge_ind IGS_AS_EXM_SPRVSRTYP.in_charge_ind%TYPE;
178: CURSOR c_est IS
179: SELECT est.in_charge_ind
180: FROM IGS_AS_EXM_SUPRVISOR esu,
181: IGS_AS_EXM_SPRVSRTYP est
182: WHERE esu.person_id = p_person_id AND
183: esu.exam_supervisor_type = est.exam_supervisor_type;
184: CURSOR c_est2 IS
185: SELECT est.in_charge_ind

Line 186: FROM IGS_AS_EXM_SPRVSRTYP est

182: WHERE esu.person_id = p_person_id AND
183: esu.exam_supervisor_type = est.exam_supervisor_type;
184: CURSOR c_est2 IS
185: SELECT est.in_charge_ind
186: FROM IGS_AS_EXM_SPRVSRTYP est
187: WHERE exam_supervisor_type = p_exam_supervisor_type;
188: BEGIN
189: --Set the default message number
190: P_MESSAGE_NAME := NULL;