[Home] [Help]
163: -- ptandon 15-12-03 Added validation to error out if no program is set as primary program for the given career.
164: -------------------------------------------------------------------------------------------
165:
166:
167: v_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE;
168: v_primary_prog_type_source IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE;
169: v_course_cd_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;
170: v_exst_primary_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;
171: v_exst_key_program IGS_EN_STDNT_PS_ATT_ALL.KEY_PROGRAM%TYPE ;
181: WHERE course_cd = p_course_cd
182: and version_number = p_version_number;
183:
184: /*
185: CURSOR c_auto_enabled (cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE) IS
186: SELECT crv.primary_program_rank
187: FROM igs_ps_type pst,
188: igs_ps_ver crv
189: WHERE pst.course_type = cp_course_type
183:
184: /*
185: CURSOR c_auto_enabled (cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE) IS
186: SELECT crv.primary_program_rank
187: FROM igs_ps_type pst,
188: igs_ps_ver crv
189: WHERE pst.course_type = cp_course_type
190: AND crv.course_Cd = p_course_Cd
191: AND crv.version_number = p_version_number
190: AND crv.course_Cd = p_course_Cd
191: AND crv.version_number = p_version_number
192: AND crv.course_type = pst.course_type;
193: */
194: CURSOR c_exst_primary_rank (cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE) IS
195: SELECT PRIMARY_PROGRAM_RANK , key_program
196: FROM igs_en_stdnt_ps_att sca,
197: igs_ps_ver crv
198: WHERE crv.course_type = cp_course_type
209: WHERE person_id = p_person_id
210: AND key_program = 'Y';
211: /*
212: --Cursor gets the total number of courses attempted by student for a given course type.
213: CURSOR c_prg_count(cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE) IS
214: SELECT count(1)
215: FROM IGS_EN_STDNT_PS_ATT sca,
216: IGS_PS_VER crv
217: WHERE sca.person_id = p_person_id
352: p_new_pri_prog_type IN VARCHAR2 ,
353: p_old_key_program IN VARCHAR2
354: ) AS
355:
356: v_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE;
357: v_sec_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;
358: v_test_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE;
359: v_primary_prog_type_source IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE;
360: v_course_attempt_status IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE;
380: FROM igs_ps_ver crv
381: WHERE course_cd = cp_course_cd
382: and version_number = cp_version_number;
383:
384: CURSOR c_sca_upd (cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE ,
385: cp_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
386: cp_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE) IS
387: SELECT sca.*
388: FROM igs_en_stdnt_ps_att sca,
392: and sca.version_number = crv.version_number
393: and sca.person_id = cp_person_id
394: and sca.course_cd <> cp_course_cd;
395:
396: CURSOR c_min_ranked_sec_sca (cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE ,
397: cp_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
398: cp_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ) IS
399: SELECT crv.PRIMARY_PROGRAM_RANK, sca.course_Cd
400: FROM igs_en_stdnt_ps_att sca,
409: order by crv.primary_program_rank asc ; -- ordering it to find the min ranked value first Kamal's idea
410:
411: --Following cursor get's key program for other career
412: --Added by kkillams
413: CURSOR c_ext_oth_prg_key (cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE) IS
414: SELECT 'X'
415: FROM igs_en_stdnt_ps_att sca,
416: igs_ps_ver crv
417: WHERE crv.course_type <> cp_course_type
421: AND sca.primary_program_type = cst_primary
422: AND sca.key_program = 'Y';
423:
424: --Following cursor get's any primary program for this career other than current program
425: CURSOR c_ext_oth_primprg (cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE,cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
426: SELECT 'X'
427: FROM igs_en_stdnt_ps_att sca,
428: igs_ps_ver crv
429: WHERE crv.course_type = cp_course_type