DBA Data[Home] [Help]

APPS.IGS_PR_CP_GPA dependencies on IGS_EN_SU_ATTEMPT

Line 26: p_person_id IN igs_en_su_attempt.person_id%TYPE,

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,

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

Line 28: p_unit_cd IN igs_en_su_attempt.unit_cd%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,

Line 29: p_unit_version_number IN igs_en_su_attempt.version_number%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,

Line 30: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

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,

Line 31: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%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,
35: p_attempted_cp OUT NOCOPY NUMBER,