APPS.IGS_PR_CLASS_RANK dependencies on IGS_EN_SCA_V

Line 477: cp_person_id igs_en_sca_v.person_id%TYPE,

473:
474: CURSOR cur_cohort_inst_person (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
475: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
476: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
477: cp_person_id igs_en_sca_v.person_id%TYPE,
478: cp_course_cd igs_en_sca_v.course_cd%TYPE) IS
479: SELECT cohi.*
480: FROM igs_pr_cohort_inst_rank_v cohi
481: WHERE cohi.cohort_name = cp_cohort_name

Line 478: cp_course_cd igs_en_sca_v.course_cd%TYPE) IS

474: CURSOR cur_cohort_inst_person (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
475: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
476: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
477: cp_person_id igs_en_sca_v.person_id%TYPE,
478: cp_course_cd igs_en_sca_v.course_cd%TYPE) IS
479: SELECT cohi.*
480: FROM igs_pr_cohort_inst_rank_v cohi
481: WHERE cohi.cohort_name = cp_cohort_name
482: AND cohi.load_cal_type = cp_cal_type

Line 862: FROM igs_en_sca_v sca

858: (SELECT person_id, course_cd, igs_pr_class_rank.get_cum_gpa ( sca.person_id,sca.course_cd,''' || p_cohort_name || ''',
859: ''' || p_cal_type || ''',' || p_ci_sequence_number || ',
860: ''' || stat_type_rec.stat_type ||''',
861: ''' || l_cumulative_ind || ''' ) cum_gpa
862: FROM igs_en_sca_v sca
863: WHERE
864: sca.cal_type IN ' || l_acad_cal || ' AND
865: (sca.person_id, sca.course_cd) IN
866: (

Line 868: FROM igs_en_su_attempt sua, igs_en_sca_v sca

864: sca.cal_type IN ' || l_acad_cal || ' AND
865: (sca.person_id, sca.course_cd) IN
866: (
867: SELECT sca.person_id, sca.course_cd
868: FROM igs_en_su_attempt sua, igs_en_sca_v sca
869: WHERE sua.person_id = sca.person_id
870: AND sua.course_cd = sca.course_cd
871: AND unit_attempt_status = ''COMPLETED''
872: AND ( sua.cal_type , sua.ci_sequence_number ) IN

Line 1048: FROM igs_en_sca_v sca

1044: (SELECT person_id, course_cd, igs_pr_class_rank.get_cum_gpa ( sca.person_id,sca.course_cd,''' || p_cohort_name || ''',
1045: ''' || p_cal_type || ''',' || p_ci_sequence_number || ',
1046: ''' || stat_type_rec.stat_type ||''',
1047: ''' || l_cumulative_ind || ''' ) cum_gpa
1048: FROM igs_en_sca_v sca
1049: WHERE sca.cal_type IN ' || l_acad_cal || '
1050: AND
1051: (sca.person_id, sca.course_cd) IN
1052: (

Line 1054: FROM igs_en_su_attempt sua, igs_en_sca_v sca

1050: AND
1051: (sca.person_id, sca.course_cd) IN
1052: (
1053: SELECT sca.person_id, sca.course_cd
1054: FROM igs_en_su_attempt sua, igs_en_sca_v sca
1055: WHERE sua.person_id = sca.person_id
1056: AND sua.course_cd = sca.course_cd
1057: AND unit_attempt_status = ''COMPLETED''
1058: AND ( sua.cal_type , sua.ci_sequence_number ) IN

Line 1223: ( p_person_id IN igs_en_sca_v.person_id%TYPE,

1219: END ranking_process ;
1220:
1221:
1222: FUNCTION get_cum_gpa
1223: ( p_person_id IN igs_en_sca_v.person_id%TYPE,
1224: p_course_cd IN igs_en_sca_v.course_cd%TYPE,
1225: p_cohort_name IN igs_pr_cohort.cohort_name%TYPE,
1226: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1227: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

Line 1224: p_course_cd IN igs_en_sca_v.course_cd%TYPE,

1220:
1221:
1222: FUNCTION get_cum_gpa
1223: ( p_person_id IN igs_en_sca_v.person_id%TYPE,
1224: p_course_cd IN igs_en_sca_v.course_cd%TYPE,
1225: p_cohort_name IN igs_pr_cohort.cohort_name%TYPE,
1226: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1227: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1228: p_stat_type IN VARCHAR2,

Line 1278: p_person_id IN igs_en_sca_v.person_id%TYPE,

1274:
1275: END get_cum_gpa ;
1276:
1277: FUNCTION rulp_val_senna_res (
1278: p_person_id IN igs_en_sca_v.person_id%TYPE,
1279: p_course_cd IN igs_en_sca_v.course_cd%TYPE ,
1280: p_course_version IN igs_en_sca_v.version_number%TYPE,
1281: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1282: p_unit_version IN igs_en_su_attempt.version_number%TYPE,

Line 1279: p_course_cd IN igs_en_sca_v.course_cd%TYPE ,

1275: END get_cum_gpa ;
1276:
1277: FUNCTION rulp_val_senna_res (
1278: p_person_id IN igs_en_sca_v.person_id%TYPE,
1279: p_course_cd IN igs_en_sca_v.course_cd%TYPE ,
1280: p_course_version IN igs_en_sca_v.version_number%TYPE,
1281: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1282: p_unit_version IN igs_en_su_attempt.version_number%TYPE,
1283: p_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 1280: p_course_version IN igs_en_sca_v.version_number%TYPE,

1276:
1277: FUNCTION rulp_val_senna_res (
1278: p_person_id IN igs_en_sca_v.person_id%TYPE,
1279: p_course_cd IN igs_en_sca_v.course_cd%TYPE ,
1280: p_course_version IN igs_en_sca_v.version_number%TYPE,
1281: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1282: p_unit_version IN igs_en_su_attempt.version_number%TYPE,
1283: p_cal_type IN igs_en_su_attempt.cal_type%TYPE,
1284: p_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,