APPS.IGS_AD_IMP_025 dependencies on IGS_CA_INST

Line 248: c_cal_type igs_ca_inst.cal_type%TYPE,

244: FUNCTION validate_record(p_housing_rec IN housing_cur%ROWTYPE,P_ACTION VARCHAR2)
245: RETURN BOOLEAN IS
246:
247: CURSOR validate_cal(c_person_id igs_pe_person.person_id%TYPE,
248: c_cal_type igs_ca_inst.cal_type%TYPE,
249: c_seq_number igs_ca_inst.sequence_number%TYPE) IS
250: SELECT 'X'
251: FROM igs_en_su_attempt_all sa
252: WHERE sa.person_id = c_person_id AND

Line 249: c_seq_number igs_ca_inst.sequence_number%TYPE) IS

245: RETURN BOOLEAN IS
246:
247: CURSOR validate_cal(c_person_id igs_pe_person.person_id%TYPE,
248: c_cal_type igs_ca_inst.cal_type%TYPE,
249: c_seq_number igs_ca_inst.sequence_number%TYPE) IS
250: SELECT 'X'
251: FROM igs_en_su_attempt_all sa
252: WHERE sa.person_id = c_person_id AND
253: sa.unit_attempt_status IN ('ENROLLED','UNCONFIRM') AND

Line 257: CURSOR validate_load_cal(c_cal_type igs_ca_inst.cal_type%TYPE,

253: sa.unit_attempt_status IN ('ENROLLED','UNCONFIRM') AND
254: sa.cal_type = c_cal_type AND
255: sa.ci_sequence_number = c_seq_number;
256:
257: CURSOR validate_load_cal(c_cal_type igs_ca_inst.cal_type%TYPE,
258: c_seq_number igs_ca_inst.sequence_number%TYPE) IS
259: SELECT 'X'
260: FROM IGS_CA_INST_ALL CA,
261: IGS_CA_TYPE TYP,

Line 258: c_seq_number igs_ca_inst.sequence_number%TYPE) IS

254: sa.cal_type = c_cal_type AND
255: sa.ci_sequence_number = c_seq_number;
256:
257: CURSOR validate_load_cal(c_cal_type igs_ca_inst.cal_type%TYPE,
258: c_seq_number igs_ca_inst.sequence_number%TYPE) IS
259: SELECT 'X'
260: FROM IGS_CA_INST_ALL CA,
261: IGS_CA_TYPE TYP,
262: IGS_CA_STAT STAT

Line 260: FROM IGS_CA_INST_ALL CA,

256:
257: CURSOR validate_load_cal(c_cal_type igs_ca_inst.cal_type%TYPE,
258: c_seq_number igs_ca_inst.sequence_number%TYPE) IS
259: SELECT 'X'
260: FROM IGS_CA_INST_ALL CA,
261: IGS_CA_TYPE TYP,
262: IGS_CA_STAT STAT
263: WHERE
264: TYP.CAL_TYPE = CA.CAL_TYPE AND