270: v_match_not_found BOOLEAN DEFAULT FALSE;
271: CURSOR c_cat_ci_cir_cs1 IS
272: SELECT cir.sub_cal_type,
273: cir.sub_ci_sequence_number
274: FROM IGS_CA_TYPE cat,
275: IGS_CA_INST ci,
276: IGS_CA_INST_REL cir,
277: IGS_CA_STAT cs
278: WHERE cir.sup_cal_type = p_prg_cal_type AND
314: cp_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
315: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
316: SELECT cir.sup_cal_type,
317: cir.sup_ci_sequence_number
318: FROM IGS_CA_TYPE cat,
319: IGS_CA_INST ci1,
320: IGS_CA_INST_REL cir,
321: IGS_CA_STAT cs
322: WHERE cir.sub_cal_type = cp_sua_cal_type AND
441: v_period_found BOOLEAN DEFAULT FALSE;
442: CURSOR c_cat_ci_cir_cs IS
443: SELECT cir.sub_cal_type,
444: cir.sub_ci_sequence_number
445: FROM IGS_CA_TYPE cat,
446: IGS_CA_INST ci,
447: IGS_CA_INST_REL cir,
448: IGS_CA_STAT cs
449: WHERE cir.sup_cal_type = p_prg_cal_type AND