119: cp_acad_cal_type IGR_I_APPL.acad_cal_type%TYPE,
120: cp_acad_ci_sequence_number IGR_I_APPL.acad_ci_sequence_number%TYPE) IS
121: SELECT cs.s_cal_status
122: FROM IGS_CA_STAT cs,
123: IGS_CA_INST ci
124: WHERE ci.cal_type = cp_acad_cal_type AND
125: ci.sequence_number = cp_acad_ci_sequence_number AND
126: ci.cal_status = cs.cal_status;
127: v_ct_rec c_ct%ROWTYPE;
188: SELECT cat.s_cal_cat
189: FROM IGS_CA_TYPE cat
190: WHERE cat.cal_type = cp_cal_type;
191: CURSOR c_cal_instance (
192: cp_cal_type IGS_CA_INST.cal_type%TYPE,
193: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
194: SELECT cs.s_cal_status
195: FROM IGS_CA_INST ci,
196: IGS_CA_STAT cs
189: FROM IGS_CA_TYPE cat
190: WHERE cat.cal_type = cp_cal_type;
191: CURSOR c_cal_instance (
192: cp_cal_type IGS_CA_INST.cal_type%TYPE,
193: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
194: SELECT cs.s_cal_status
195: FROM IGS_CA_INST ci,
196: IGS_CA_STAT cs
197: WHERE ci.cal_status= cs.cal_status AND
191: CURSOR c_cal_instance (
192: cp_cal_type IGS_CA_INST.cal_type%TYPE,
193: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
194: SELECT cs.s_cal_status
195: FROM IGS_CA_INST ci,
196: IGS_CA_STAT cs
197: WHERE ci.cal_status= cs.cal_status AND
198: ci.cal_type = cp_cal_type AND
199: ci.sequence_number = cp_sequence_number;
197: WHERE ci.cal_status= cs.cal_status AND
198: ci.cal_type = cp_cal_type AND
199: ci.sequence_number = cp_sequence_number;
200: CURSOR c_cal_ins_rel (
201: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
202: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
203: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
204: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
205: SELECT 'x'
198: ci.cal_type = cp_cal_type AND
199: ci.sequence_number = cp_sequence_number;
200: CURSOR c_cal_ins_rel (
201: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
202: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
203: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
204: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
205: SELECT 'x'
206: FROM IGS_CA_INST_REL cir
199: ci.sequence_number = cp_sequence_number;
200: CURSOR c_cal_ins_rel (
201: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
202: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
203: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
204: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
205: SELECT 'x'
206: FROM IGS_CA_INST_REL cir
207: WHERE cir.sup_cal_type =cp_acad_cal_type AND
200: CURSOR c_cal_ins_rel (
201: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
202: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
203: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
204: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
205: SELECT 'x'
206: FROM IGS_CA_INST_REL cir
207: WHERE cir.sup_cal_type =cp_acad_cal_type AND
208: cir.sup_ci_sequence_number = cp_acad_ci_sequence_number AND
202: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
203: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
204: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
205: SELECT 'x'
206: FROM IGS_CA_INST_REL cir
207: WHERE cir.sup_cal_type =cp_acad_cal_type AND
208: cir.sup_ci_sequence_number = cp_acad_ci_sequence_number AND
209: cir.sub_cal_type = cp_adm_cal_type AND
210: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number;