[Home] [Help]
136: RETURN VARCHAR2 AS
137:
138: gv_acad_rec_found BOOLEAN := FALSE;
139: gv_alternate_code IGS_CA_INST.alternate_code%TYPE;
140: gv_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
141:
142: BEGIN -- enrp_get_acad_alt_cd
143: -- Get the alternate_code for the superior ACADEMIC IGS_CA_INST of the
144: -- IGS_CA_INST passed
146: -- This function recursively track down the first superior academic
147: -- IGS_CA_INST (deep first recursive). Returning TRUE if it can find one,
148: -- FALSE otherwise
149:
150: CURSOR c_check_s_cal_cat (cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
151: SELECT cat.s_cal_cat
152: FROM IGS_CA_TYPE cat
153: WHERE cat.cal_type = cp_cal_type;
154:
148: -- FALSE otherwise
149:
150: CURSOR c_check_s_cal_cat (cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
151: SELECT cat.s_cal_cat
152: FROM IGS_CA_TYPE cat
153: WHERE cat.cal_type = cp_cal_type;
154:
155: CURSOR c_get_super_ci_for_load (cp_cal_type IGS_CA_INST.cal_type%TYPE,
156: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
160: ci.end_dt,
161: ci.alternate_code
162: FROM IGS_CA_INST_REL cir,
163: IGS_CA_INST ci,
164: IGS_CA_TYPE cat
165: WHERE cir.sub_cal_type = cp_cal_type AND
166: cir.sub_ci_sequence_number = cp_ci_sequence_number AND
167: ci.cal_type = cir.sup_cal_type AND
168: ci.sequence_number = cir.sup_ci_sequence_number AND
188: ci.alternate_code,
189: cat.s_cal_cat
190: FROM IGS_CA_INST_REL cir,
191: IGS_CA_INST ci,
192: IGS_CA_TYPE cat
193: WHERE cir.sub_cal_type = cp_cal_type AND
194: cir.sub_ci_sequence_number = cp_ci_sequence_number AND
195: ci.cal_type = cir.sup_cal_type AND
196: ci.sequence_number = cir.sup_ci_sequence_number AND
363: cir.sup_ci_sequence_number
364: FROM IGS_AS_SC_ATMPT_ENR scae,
365: IGS_CA_INST_REL cir,
366: IGS_CA_INST ci,
367: IGS_CA_TYPE cat
368: WHERE scae.person_id = p_person_id AND
369: scae.course_cd = p_course_cd AND
370: scae.cal_type = cir.sub_cal_type AND
371: scae.ci_sequence_number = cir.sub_ci_sequence_number AND