DBA Data[Home] [Help]

APPS.IGS_PR_CLASS_RANK dependencies on IGS_EN_SCA_V

Line 16: p_person_id IN igs_en_sca_v.person_id%TYPE,

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,

Line 17: p_course_cd IN igs_en_sca_v.course_cd%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,

Line 18: p_course_version IN igs_en_sca_v.version_number%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,

Line 27: p_person_id IN igs_en_sca_v.person_id%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,

Line 28: p_course_cd IN igs_en_sca_v.course_cd%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,