12: || (reverse chronological order - newest change first)
13: ****************************************************************************************************************/
14:
15: FUNCTION rulp_val_senna_res (
16: p_person_id IN igs_en_sca_v.person_id%TYPE,
17: p_course_cd IN igs_en_sca_v.course_cd%TYPE ,
18: p_course_version IN igs_en_sca_v.version_number%TYPE,
19: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
20: p_unit_version IN igs_en_su_attempt.version_number%TYPE,
13: ****************************************************************************************************************/
14:
15: FUNCTION rulp_val_senna_res (
16: p_person_id IN igs_en_sca_v.person_id%TYPE,
17: p_course_cd IN igs_en_sca_v.course_cd%TYPE ,
18: p_course_version IN igs_en_sca_v.version_number%TYPE,
19: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
20: p_unit_version IN igs_en_su_attempt.version_number%TYPE,
21: p_cal_type IN igs_en_su_attempt.cal_type%TYPE,
14:
15: FUNCTION rulp_val_senna_res (
16: p_person_id IN igs_en_sca_v.person_id%TYPE,
17: p_course_cd IN igs_en_sca_v.course_cd%TYPE ,
18: p_course_version IN igs_en_sca_v.version_number%TYPE,
19: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
20: p_unit_version IN igs_en_su_attempt.version_number%TYPE,
21: p_cal_type IN igs_en_su_attempt.cal_type%TYPE,
22: p_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
23: p_rule_number IN igs_ru_call_v.rul_sequence_number%TYPE) RETURN VARCHAR2;
24:
25:
26: FUNCTION get_cum_gpa (
27: p_person_id IN igs_en_sca_v.person_id%TYPE,
28: p_course_cd IN igs_en_sca_v.course_cd%TYPE,
29: p_cohort_name IN igs_pr_cohort.cohort_name%TYPE,
30: p_cal_type IN igs_ca_inst.cal_type%TYPE,
31: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
24:
25:
26: FUNCTION get_cum_gpa (
27: p_person_id IN igs_en_sca_v.person_id%TYPE,
28: p_course_cd IN igs_en_sca_v.course_cd%TYPE,
29: p_cohort_name IN igs_pr_cohort.cohort_name%TYPE,
30: p_cal_type IN igs_ca_inst.cal_type%TYPE,
31: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
32: p_stat_type IN VARCHAR2,