APPS.IGS_AS_VAL_ESVS dependencies on IGS_CA_GEN_001

Line 148: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(

144: SELECT 'x'
145: FROM IGS_AS_EXM_INS_SPVSR eis,
146: IGS_GR_VENUE ve
147: WHERE eis.person_id = p_person_id AND
148: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
149: eis.dt_alias,
150: eis.dai_sequence_number,
151: eis.exam_cal_type,
152: eis.exam_ci_sequence_number) = cp_dt_alias_val AND

Line 162: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(

158: SELECT 'x'
159: FROM IGS_AS_EXM_SES_VN_SP esvs,
160: IGS_GR_VENUE ve
161: WHERE esvs.person_id = p_person_id AND
162: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
163: esvs.dt_alias,
164: esvs.dai_sequence_number,
165: esvs.exam_cal_type,
166: esvs.exam_ci_sequence_number) = cp_dt_alias_val AND

Line 172: v_dt_alias_val := IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(

168: ve.exam_location_cd <> cp_exam_location_cd;
169: BEGIN
170: P_MESSAGE_NAME := NULL;
171: -- Get the date for the date alias instance value.
172: v_dt_alias_val := IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
173: p_dt_alias,
174: p_dai_sequence_number,
175: p_exam_cal_type,
176: p_exam_ci_sequence_number);

Line 248: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(

244: CURSOR c_eis IS
245: SELECT 'X'
246: FROM IGS_AS_EXM_INS_SPVSR eis
247: WHERE person_id = p_person_id AND
248: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
249: dt_alias,
250: dai_sequence_number,
251: exam_cal_type,
252: exam_ci_sequence_number) = v_dt_alias_val AND

Line 264: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(

260: CURSOR c_esvs IS
261: SELECT 'X'
262: FROM IGS_AS_EXM_SES_VN_SP esvs
263: WHERE person_id = p_person_id AND
264: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
265: dt_alias,
266: dai_sequence_number,
267: exam_cal_type,
268: exam_ci_sequence_number) = v_dt_alias_val AND

Line 280: v_dt_alias_val := IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(

276: BEGIN
277: --Set the default message number
278: P_MESSAGE_NAME := NULL;
279: --Get the date for the date alias instance value
280: v_dt_alias_val := IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
281: p_dt_alias,
282: p_dai_sequence_number,
283: p_exam_cal_type,
284: p_exam_ci_sequence_number);