22: -- kdande; 23-Apr-2003; Bug# 2829262
23: -- Added p_uoo_id parameter to the PROCEDURE get_sua_all
24: --
25: PROCEDURE get_sua_all(
26: p_person_id IN igs_en_su_attempt.person_id%TYPE,
27: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
28: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
29: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
30: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
23: -- Added p_uoo_id parameter to the PROCEDURE get_sua_all
24: --
25: PROCEDURE get_sua_all(
26: p_person_id IN igs_en_su_attempt.person_id%TYPE,
27: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
28: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
29: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
30: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
31: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
24: --
25: PROCEDURE get_sua_all(
26: p_person_id IN igs_en_su_attempt.person_id%TYPE,
27: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
28: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
29: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
30: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
31: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
32: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
25: PROCEDURE get_sua_all(
26: p_person_id IN igs_en_su_attempt.person_id%TYPE,
27: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
28: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
29: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
30: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
31: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
32: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
33: p_system_stat IN VARCHAR2,
26: p_person_id IN igs_en_su_attempt.person_id%TYPE,
27: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
28: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
29: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
30: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
31: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
32: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
33: p_system_stat IN VARCHAR2,
34: p_earned_cp OUT NOCOPY NUMBER,
27: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
28: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
29: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
30: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
31: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
32: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
33: p_system_stat IN VARCHAR2,
34: p_earned_cp OUT NOCOPY NUMBER,
35: p_attempted_cp OUT NOCOPY NUMBER,