APPS.IGS_AD_VAL_ACAIU dependencies on IGS_CA_INST_REL

Line 109: IGS_CA_INST_REL cir

105: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS
106: SELECT DISTINCT uoo.cal_type,
107: uoo.ci_sequence_number
108: FROM IGS_PS_UNIT_OFR_OPT uoo,
109: IGS_CA_INST_REL cir
110: WHERE uoo.unit_cd = cp_unit_cd AND
111: uoo.version_number = cp_uv_version_number AND
112: uoo.offered_ind = cst_yes AND
113: cir.sub_cal_type = uoo.cal_type AND

Line 123: FROM IGS_CA_INST_REL cir

119: cp_adm_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,
120: cp_sup_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
121: cp_sup_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS
122: SELECT 'x'
123: FROM IGS_CA_INST_REL cir
124: WHERE cir.sub_cal_type = cp_adm_cal_type AND
125: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number AND
126: cir.sup_cal_type = cp_sup_cal_type AND
127: cir.sup_ci_sequence_number = cp_sup_ci_sequence_number;

Line 206: FROM IGS_CA_INST_REL cir,

202: -- Select valid teaching periods for the admission course application
203: CURSOR c_cir IS
204: SELECT cir.sub_cal_type,
205: cir.sub_ci_sequence_number
206: FROM IGS_CA_INST_REL cir,
207: IGS_CA_TYPE cat1,
208: IGS_CA_TYPE cat2
209: WHERE cir.sup_cal_type = p_acad_cal_type AND
210: cir.sup_ci_sequence_number = p_acad_ci_sequence_number AND

Line 344: EXIT; -- (IGS_CA_INST_REL)

340: v_ci_sequence_number,
341: v_val_ind_type_offer) = TRUE THEN
342: v_val_ind_type := v_val_ind_type_offer;
343: v_val_off_optn_found := TRUE;
344: EXIT; -- (IGS_CA_INST_REL)
345: ELSE
346: v_val_ind_type := v_val_ind_type_offer;
347: v_val_off_optn_found := FALSE;
348: END IF;

Line 350: END LOOP; -- (IGS_CA_INST_REL)

346: v_val_ind_type := v_val_ind_type_offer;
347: v_val_off_optn_found := FALSE;
348: END IF;
349: END IF;
350: END LOOP; -- (IGS_CA_INST_REL)
351: -- set flag to 1 so that the error msg number could be returned
352: IF v_cir_found = FALSE OR v_admp_pk_ind = FALSE THEN
353: v_val_ind_type := 1;
354: END IF;

Line 516: FROM IGS_CA_INST_REL cir,

512: ci.sequence_number = p_teach_ci_sequence_number;
513: v_teach_perd_rec c_teach_perd%ROWTYPE;
514: CURSOR c_chk_within_acad IS
515: SELECT 'x'
516: FROM IGS_CA_INST_REL cir,
517: IGS_CA_TYPE cat
518: WHERE cir.sup_cal_type = cat.cal_type AND
519: cir.sup_cal_type = p_acad_cal_type AND
520: cir.sup_ci_sequence_number = p_acad_ci_sequence_number AND

Line 526: FROM IGS_CA_INST_REL cir,

522: cir.sub_ci_sequence_number = p_teach_ci_sequence_number AND
523: cat.s_cal_cat = cst_academic;
524: CURSOR c_chk_include_adm IS
525: SELECT 'x'
526: FROM IGS_CA_INST_REL cir,
527: IGS_CA_TYPE cat
528: WHERE cir.sub_cal_type = cat.cal_type AND
529: cir.sup_cal_type = p_teach_cal_type AND
530: cir.sup_ci_sequence_number = p_teach_ci_sequence_number AND

Line 786: FROM IGS_CA_INST_REL cir,

782: CURSOR c_cir IS
783: SELECT ci.cal_type,
784: ci.sequence_number,
785: cs.s_cal_status
786: FROM IGS_CA_INST_REL cir,
787: IGS_CA_INST ci,
788: IGS_CA_TYPE cat,
789: IGS_CA_STAT cs
790: WHERE cir.sup_cal_type = p_acad_cal_type AND

Line 803: FROM IGS_CA_INST_REL cir,

799: CURSOR c_cir_cat(
800: cp_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
801: cp_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
802: SELECT 'x'
803: FROM IGS_CA_INST_REL cir,
804: IGS_CA_TYPE cat
805: WHERE cir.sub_cal_type = p_adm_cal_type AND
806: cir.sub_ci_sequence_number = p_adm_ci_sequence_number AND
807: cir.sup_cal_type = cp_cal_type AND