[Home] [Help]
845: -- Check Student Progression Outcome doesn't already exist
846: --
847: CURSOR c_spo (
848: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
849: cp_prg_cal_type igs_ca_inst.cal_type%TYPE,
850: cp_prg_ci_sequence_number igs_ca_inst.sequence_number%TYPE
851: ) IS
852: SELECT 'X'
853: FROM igs_pr_stdnt_pr_ou spo
846: --
847: CURSOR c_spo (
848: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
849: cp_prg_cal_type igs_ca_inst.cal_type%TYPE,
850: cp_prg_ci_sequence_number igs_ca_inst.sequence_number%TYPE
851: ) IS
852: SELECT 'X'
853: FROM igs_pr_stdnt_pr_ou spo
854: WHERE spo.person_id = cp_person_id
872: ) IS
873: SELECT ci.cal_type,
874: ci.sequence_number
875: FROM igs_pr_s_crv_prg_cal scpc,
876: igs_ca_inst ci,
877: igs_ca_stat cs
878: WHERE scpc.course_cd = p_course_cd
879: AND scpc.version_number = cp_version_number
880: AND ci.cal_type = scpc.prg_cal_type
882: AND cs.s_cal_status = 'ACTIVE'
883: AND ci.start_dt < SYSDATE
884: --AND ci.end_dt = (SELECT MAX(ci.end_dt)
885: AND EXISTS ( SELECT 'X'
886: FROM igs_ca_inst_rel cir,
887: igs_en_su_attempt sua
888: WHERE cir.sup_cal_type = ci.cal_type
889: AND cir.sup_ci_sequence_number = ci.sequence_number
890: AND cir.sub_cal_type = sua.cal_type
909: ) IS
910: SELECT ci.cal_type,
911: ci.sequence_number
912: FROM igs_pr_s_ou_prg_cal sopc,
913: igs_ca_inst ci,
914: igs_ca_stat cs
915: WHERE igs_pr_gen_001.prgp_get_crv_cmt (p_course_cd, cp_version_number, sopc.org_unit_cd, sopc.ou_start_dt) = 'Y'
916: AND ci.cal_type = sopc.prg_cal_type
917: AND ci.cal_status = cs.cal_status
918: AND cs.s_cal_status = 'ACTIVE'
919: AND ci.start_dt < SYSDATE
920: --AND ci.end_dt = (SELECT MAX(ci.end_dt)
921: AND EXISTS ( SELECT 'X'
922: FROM igs_ca_inst_rel cir,
923: igs_en_su_attempt sua
924: WHERE cir.sup_cal_type = ci.cal_type
925: AND cir.sup_ci_sequence_number = ci.sequence_number
926: AND cir.sub_cal_type = sua.cal_type
935: CURSOR c_spc_ci (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS
936: SELECT ci.cal_type,
937: ci.sequence_number
938: FROM igs_pr_s_prg_cal spc,
939: igs_ca_inst ci,
940: igs_ca_stat cs
941: WHERE spc.s_control_num = 1
942: AND ci.cal_type = spc.prg_cal_type
943: AND ci.cal_status = cs.cal_status
944: AND cs.s_cal_status = 'ACTIVE'
945: AND ci.start_dt < SYSDATE
946: --AND ci.end_dt = (SELECT MAX(ci.end_dt)
947: AND EXISTS ( SELECT 'X'
948: FROM igs_ca_inst_rel cir,
949: igs_en_su_attempt sua
950: WHERE cir.sup_cal_type = ci.cal_type
951: AND cir.sup_ci_sequence_number = ci.sequence_number
952: AND cir.sub_cal_type = sua.cal_type