eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_ACAD_DETAILS dependencies on IGS_EN_SU_ATTEMPT

Line 9: person_id igs_en_su_attempt.person_id%TYPE,

5: -- kdande; 23-Apr-2003; Bug# 2829262
6: -- Added uoo_id field to the r_sua_record RECORD
7: --
8: TYPE r_sua_record IS RECORD (
9: person_id igs_en_su_attempt.person_id%TYPE,
10: course_cd igs_en_su_attempt.course_cd%TYPE,
11: unit_cd igs_en_su_attempt.unit_cd%TYPE,
12: version_number igs_en_su_attempt.version_number%TYPE,
13: teach_cal_type igs_en_su_attempt.cal_type%TYPE,

Line 10: course_cd igs_en_su_attempt.course_cd%TYPE,

6: -- Added uoo_id field to the r_sua_record RECORD
7: --
8: TYPE r_sua_record IS RECORD (
9: person_id igs_en_su_attempt.person_id%TYPE,
10: course_cd igs_en_su_attempt.course_cd%TYPE,
11: unit_cd igs_en_su_attempt.unit_cd%TYPE,
12: version_number igs_en_su_attempt.version_number%TYPE,
13: teach_cal_type igs_en_su_attempt.cal_type%TYPE,
14: teach_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

Line 11: unit_cd igs_en_su_attempt.unit_cd%TYPE,

7: --
8: TYPE r_sua_record IS RECORD (
9: person_id igs_en_su_attempt.person_id%TYPE,
10: course_cd igs_en_su_attempt.course_cd%TYPE,
11: unit_cd igs_en_su_attempt.unit_cd%TYPE,
12: version_number igs_en_su_attempt.version_number%TYPE,
13: teach_cal_type igs_en_su_attempt.cal_type%TYPE,
14: teach_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
15: grade igs_as_su_stmptout.grade%TYPE,

Line 12: version_number igs_en_su_attempt.version_number%TYPE,

8: TYPE r_sua_record IS RECORD (
9: person_id igs_en_su_attempt.person_id%TYPE,
10: course_cd igs_en_su_attempt.course_cd%TYPE,
11: unit_cd igs_en_su_attempt.unit_cd%TYPE,
12: version_number igs_en_su_attempt.version_number%TYPE,
13: teach_cal_type igs_en_su_attempt.cal_type%TYPE,
14: teach_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
15: grade igs_as_su_stmptout.grade%TYPE,
16: mark igs_as_su_stmptout.mark%TYPE,

Line 13: teach_cal_type igs_en_su_attempt.cal_type%TYPE,

9: person_id igs_en_su_attempt.person_id%TYPE,
10: course_cd igs_en_su_attempt.course_cd%TYPE,
11: unit_cd igs_en_su_attempt.unit_cd%TYPE,
12: version_number igs_en_su_attempt.version_number%TYPE,
13: teach_cal_type igs_en_su_attempt.cal_type%TYPE,
14: teach_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
15: grade igs_as_su_stmptout.grade%TYPE,
16: mark igs_as_su_stmptout.mark%TYPE,
17: gpa igs_as_grd_sch_grade.gpa_val%TYPE,

Line 14: teach_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

10: course_cd igs_en_su_attempt.course_cd%TYPE,
11: unit_cd igs_en_su_attempt.unit_cd%TYPE,
12: version_number igs_en_su_attempt.version_number%TYPE,
13: teach_cal_type igs_en_su_attempt.cal_type%TYPE,
14: teach_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
15: grade igs_as_su_stmptout.grade%TYPE,
16: mark igs_as_su_stmptout.mark%TYPE,
17: gpa igs_as_grd_sch_grade.gpa_val%TYPE,
18: gpa_cp igs_ps_unit_ver.achievable_credit_points%TYPE,

Line 22: uoo_id igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

18: gpa_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
19: gpa_qp igs_ps_unit_ver.achievable_credit_points%TYPE,
20: earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
21: attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
22: uoo_id igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
23: );
24:
25: TYPE t_sua_table IS TABLE OF r_sua_record INDEX BY BINARY_INTEGER;
26:

Line 30: person_id igs_en_su_attempt.person_id%TYPE,

26:
27: sua_table t_sua_table;
28:
29: TYPE r_load_record IS RECORD (
30: person_id igs_en_su_attempt.person_id%TYPE,
31: course_cd igs_en_su_attempt.course_cd%TYPE,
32: load_cal_type igs_en_su_attempt.cal_type%TYPE,
33: load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
34: load_gpa igs_as_grd_sch_grade.gpa_val%TYPE,

Line 31: course_cd igs_en_su_attempt.course_cd%TYPE,

27: sua_table t_sua_table;
28:
29: TYPE r_load_record IS RECORD (
30: person_id igs_en_su_attempt.person_id%TYPE,
31: course_cd igs_en_su_attempt.course_cd%TYPE,
32: load_cal_type igs_en_su_attempt.cal_type%TYPE,
33: load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
34: load_gpa igs_as_grd_sch_grade.gpa_val%TYPE,
35: load_gpa_cp igs_ps_unit_ver.achievable_credit_points%TYPE,

Line 32: load_cal_type igs_en_su_attempt.cal_type%TYPE,

28:
29: TYPE r_load_record IS RECORD (
30: person_id igs_en_su_attempt.person_id%TYPE,
31: course_cd igs_en_su_attempt.course_cd%TYPE,
32: load_cal_type igs_en_su_attempt.cal_type%TYPE,
33: load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
34: load_gpa igs_as_grd_sch_grade.gpa_val%TYPE,
35: load_gpa_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
36: load_gpa_qp igs_ps_unit_ver.achievable_credit_points%TYPE,

Line 33: load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

29: TYPE r_load_record IS RECORD (
30: person_id igs_en_su_attempt.person_id%TYPE,
31: course_cd igs_en_su_attempt.course_cd%TYPE,
32: load_cal_type igs_en_su_attempt.cal_type%TYPE,
33: load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
34: load_gpa igs_as_grd_sch_grade.gpa_val%TYPE,
35: load_gpa_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
36: load_gpa_qp igs_ps_unit_ver.achievable_credit_points%TYPE,
37: load_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE,

Line 55: p_person_id IN igs_en_su_attempt.person_id%TYPE,

51: -- Added p_uoo_id parameter to the PROCEDURE populate_sua_table
52: --
53: PROCEDURE populate_sua_table
54: (
55: p_person_id IN igs_en_su_attempt.person_id%TYPE,
56: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
57: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
58: p_version_number IN igs_en_su_attempt.version_number%TYPE,
59: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 56: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

52: --
53: PROCEDURE populate_sua_table
54: (
55: p_person_id IN igs_en_su_attempt.person_id%TYPE,
56: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
57: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
58: p_version_number IN igs_en_su_attempt.version_number%TYPE,
59: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
60: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 57: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

53: PROCEDURE populate_sua_table
54: (
55: p_person_id IN igs_en_su_attempt.person_id%TYPE,
56: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
57: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
58: p_version_number IN igs_en_su_attempt.version_number%TYPE,
59: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
60: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
61: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 58: p_version_number IN igs_en_su_attempt.version_number%TYPE,

54: (
55: p_person_id IN igs_en_su_attempt.person_id%TYPE,
56: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
57: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
58: p_version_number IN igs_en_su_attempt.version_number%TYPE,
59: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
60: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
61: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
62: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

Line 59: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

55: p_person_id IN igs_en_su_attempt.person_id%TYPE,
56: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
57: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
58: p_version_number IN igs_en_su_attempt.version_number%TYPE,
59: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
60: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
61: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
62: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
63: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

Line 60: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

56: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
57: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
58: p_version_number IN igs_en_su_attempt.version_number%TYPE,
59: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
60: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
61: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
62: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
63: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
64: );

Line 61: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

57: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
58: p_version_number IN igs_en_su_attempt.version_number%TYPE,
59: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
60: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
61: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
62: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
63: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
64: );
65:

Line 63: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

59: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
60: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
61: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
62: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
63: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
64: );
65:
66: PROCEDURE populate_load_table
67: (

Line 68: p_person_id IN igs_en_su_attempt.person_id%TYPE,

64: );
65:
66: PROCEDURE populate_load_table
67: (
68: p_person_id IN igs_en_su_attempt.person_id%TYPE,
69: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
70: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
71: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
72: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 69: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

65:
66: PROCEDURE populate_load_table
67: (
68: p_person_id IN igs_en_su_attempt.person_id%TYPE,
69: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
70: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
71: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
72: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
73: );

Line 70: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

66: PROCEDURE populate_load_table
67: (
68: p_person_id IN igs_en_su_attempt.person_id%TYPE,
69: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
70: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
71: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
72: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
73: );
74: --

Line 71: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

67: (
68: p_person_id IN igs_en_su_attempt.person_id%TYPE,
69: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
70: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
71: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
72: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
73: );
74: --
75: -- kdande; 23-Apr-2003; Bug# 2829262

Line 80: p_person_id IN igs_en_su_attempt.person_id%TYPE,

76: -- Added p_uoo_id parameter to the FUNCTION get_sua_gpa
77: --
78: FUNCTION get_sua_gpa
79: (
80: p_person_id IN igs_en_su_attempt.person_id%TYPE,
81: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
82: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
83: p_version_number IN igs_en_su_attempt.version_number%TYPE,
84: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 81: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

77: --
78: FUNCTION get_sua_gpa
79: (
80: p_person_id IN igs_en_su_attempt.person_id%TYPE,
81: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
82: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
83: p_version_number IN igs_en_su_attempt.version_number%TYPE,
84: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
85: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 82: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

78: FUNCTION get_sua_gpa
79: (
80: p_person_id IN igs_en_su_attempt.person_id%TYPE,
81: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
82: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
83: p_version_number IN igs_en_su_attempt.version_number%TYPE,
84: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
85: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
86: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 83: p_version_number IN igs_en_su_attempt.version_number%TYPE,

79: (
80: p_person_id IN igs_en_su_attempt.person_id%TYPE,
81: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
82: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
83: p_version_number IN igs_en_su_attempt.version_number%TYPE,
84: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
85: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
86: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
87: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

Line 84: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

80: p_person_id IN igs_en_su_attempt.person_id%TYPE,
81: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
82: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
83: p_version_number IN igs_en_su_attempt.version_number%TYPE,
84: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
85: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
86: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
87: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
88: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

Line 85: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

81: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
82: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
83: p_version_number IN igs_en_su_attempt.version_number%TYPE,
84: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
85: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
86: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
87: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
88: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
89: ) RETURN NUMBER;

Line 86: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

82: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
83: p_version_number IN igs_en_su_attempt.version_number%TYPE,
84: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
85: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
86: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
87: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
88: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
89: ) RETURN NUMBER;
90: --

Line 88: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

84: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
85: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
86: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
87: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
88: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
89: ) RETURN NUMBER;
90: --
91: -- kdande; 23-Apr-2003; Bug# 2829262
92: -- Added p_uoo_id parameter to the FUNCTION get_sua_gpa_cp

Line 96: p_person_id IN igs_en_su_attempt.person_id%TYPE,

92: -- Added p_uoo_id parameter to the FUNCTION get_sua_gpa_cp
93: --
94: FUNCTION get_sua_gpa_cp
95: (
96: p_person_id IN igs_en_su_attempt.person_id%TYPE,
97: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
98: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
99: p_version_number IN igs_en_su_attempt.version_number%TYPE,
100: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 97: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

93: --
94: FUNCTION get_sua_gpa_cp
95: (
96: p_person_id IN igs_en_su_attempt.person_id%TYPE,
97: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
98: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
99: p_version_number IN igs_en_su_attempt.version_number%TYPE,
100: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
101: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 98: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

94: FUNCTION get_sua_gpa_cp
95: (
96: p_person_id IN igs_en_su_attempt.person_id%TYPE,
97: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
98: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
99: p_version_number IN igs_en_su_attempt.version_number%TYPE,
100: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
101: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
102: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 99: p_version_number IN igs_en_su_attempt.version_number%TYPE,

95: (
96: p_person_id IN igs_en_su_attempt.person_id%TYPE,
97: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
98: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
99: p_version_number IN igs_en_su_attempt.version_number%TYPE,
100: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
101: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
102: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
103: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

Line 100: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

96: p_person_id IN igs_en_su_attempt.person_id%TYPE,
97: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
98: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
99: p_version_number IN igs_en_su_attempt.version_number%TYPE,
100: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
101: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
102: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
103: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
104: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

Line 101: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

97: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
98: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
99: p_version_number IN igs_en_su_attempt.version_number%TYPE,
100: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
101: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
102: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
103: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
104: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
105: ) RETURN NUMBER;

Line 102: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

98: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
99: p_version_number IN igs_en_su_attempt.version_number%TYPE,
100: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
101: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
102: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
103: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
104: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
105: ) RETURN NUMBER;
106: --

Line 104: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

100: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
101: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
102: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
103: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
104: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
105: ) RETURN NUMBER;
106: --
107: -- kdande; 23-Apr-2003; Bug# 2829262
108: -- Added p_uoo_id parameter to the FUNCTION get_sua_gpa_qp

Line 112: p_person_id IN igs_en_su_attempt.person_id%TYPE,

108: -- Added p_uoo_id parameter to the FUNCTION get_sua_gpa_qp
109: --
110: FUNCTION get_sua_gpa_qp
111: (
112: p_person_id IN igs_en_su_attempt.person_id%TYPE,
113: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
114: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
115: p_version_number IN igs_en_su_attempt.version_number%TYPE,
116: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 113: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

109: --
110: FUNCTION get_sua_gpa_qp
111: (
112: p_person_id IN igs_en_su_attempt.person_id%TYPE,
113: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
114: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
115: p_version_number IN igs_en_su_attempt.version_number%TYPE,
116: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
117: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 114: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

110: FUNCTION get_sua_gpa_qp
111: (
112: p_person_id IN igs_en_su_attempt.person_id%TYPE,
113: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
114: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
115: p_version_number IN igs_en_su_attempt.version_number%TYPE,
116: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
117: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
118: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 115: p_version_number IN igs_en_su_attempt.version_number%TYPE,

111: (
112: p_person_id IN igs_en_su_attempt.person_id%TYPE,
113: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
114: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
115: p_version_number IN igs_en_su_attempt.version_number%TYPE,
116: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
117: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
118: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
119: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

Line 116: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

112: p_person_id IN igs_en_su_attempt.person_id%TYPE,
113: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
114: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
115: p_version_number IN igs_en_su_attempt.version_number%TYPE,
116: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
117: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
118: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
119: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
120: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

Line 117: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

113: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
114: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
115: p_version_number IN igs_en_su_attempt.version_number%TYPE,
116: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
117: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
118: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
119: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
120: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
121: ) RETURN NUMBER;

Line 118: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

114: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
115: p_version_number IN igs_en_su_attempt.version_number%TYPE,
116: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
117: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
118: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
119: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
120: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
121: ) RETURN NUMBER;
122: --

Line 120: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

116: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
117: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
118: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
119: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
120: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
121: ) RETURN NUMBER;
122: --
123: -- kdande; 23-Apr-2003; Bug# 2829262
124: -- Added p_uoo_id parameter to the FUNCTION get_sua_earned_cp

Line 128: p_person_id IN igs_en_su_attempt.person_id%TYPE,

124: -- Added p_uoo_id parameter to the FUNCTION get_sua_earned_cp
125: --
126: FUNCTION get_sua_earned_cp
127: (
128: p_person_id IN igs_en_su_attempt.person_id%TYPE,
129: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
130: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
131: p_version_number IN igs_en_su_attempt.version_number%TYPE,
132: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 129: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

125: --
126: FUNCTION get_sua_earned_cp
127: (
128: p_person_id IN igs_en_su_attempt.person_id%TYPE,
129: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
130: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
131: p_version_number IN igs_en_su_attempt.version_number%TYPE,
132: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
133: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 130: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

126: FUNCTION get_sua_earned_cp
127: (
128: p_person_id IN igs_en_su_attempt.person_id%TYPE,
129: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
130: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
131: p_version_number IN igs_en_su_attempt.version_number%TYPE,
132: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
133: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
134: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 131: p_version_number IN igs_en_su_attempt.version_number%TYPE,

127: (
128: p_person_id IN igs_en_su_attempt.person_id%TYPE,
129: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
130: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
131: p_version_number IN igs_en_su_attempt.version_number%TYPE,
132: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
133: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
134: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
135: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

Line 132: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

128: p_person_id IN igs_en_su_attempt.person_id%TYPE,
129: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
130: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
131: p_version_number IN igs_en_su_attempt.version_number%TYPE,
132: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
133: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
134: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
135: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
136: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

Line 133: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

129: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
130: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
131: p_version_number IN igs_en_su_attempt.version_number%TYPE,
132: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
133: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
134: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
135: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
136: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
137: ) RETURN NUMBER;

Line 134: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

130: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
131: p_version_number IN igs_en_su_attempt.version_number%TYPE,
132: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
133: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
134: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
135: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
136: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
137: ) RETURN NUMBER;
138: --

Line 136: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

132: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
133: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
134: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
135: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
136: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
137: ) RETURN NUMBER;
138: --
139: -- kdande; 23-Apr-2003; Bug# 2829262
140: -- Added p_uoo_id parameter to the FUNCTION get_sua_attempted_cp

Line 144: p_person_id IN igs_en_su_attempt.person_id%TYPE,

140: -- Added p_uoo_id parameter to the FUNCTION get_sua_attempted_cp
141: --
142: FUNCTION get_sua_attempted_cp
143: (
144: p_person_id IN igs_en_su_attempt.person_id%TYPE,
145: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
146: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
147: p_version_number IN igs_en_su_attempt.version_number%TYPE,
148: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 145: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

141: --
142: FUNCTION get_sua_attempted_cp
143: (
144: p_person_id IN igs_en_su_attempt.person_id%TYPE,
145: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
146: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
147: p_version_number IN igs_en_su_attempt.version_number%TYPE,
148: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
149: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 146: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

142: FUNCTION get_sua_attempted_cp
143: (
144: p_person_id IN igs_en_su_attempt.person_id%TYPE,
145: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
146: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
147: p_version_number IN igs_en_su_attempt.version_number%TYPE,
148: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
149: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
150: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 147: p_version_number IN igs_en_su_attempt.version_number%TYPE,

143: (
144: p_person_id IN igs_en_su_attempt.person_id%TYPE,
145: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
146: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
147: p_version_number IN igs_en_su_attempt.version_number%TYPE,
148: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
149: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
150: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
151: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

Line 148: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

144: p_person_id IN igs_en_su_attempt.person_id%TYPE,
145: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
146: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
147: p_version_number IN igs_en_su_attempt.version_number%TYPE,
148: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
149: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
150: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
151: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
152: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

Line 149: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

145: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
146: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
147: p_version_number IN igs_en_su_attempt.version_number%TYPE,
148: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
149: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
150: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
151: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
152: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
153: ) RETURN NUMBER;

Line 150: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

146: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
147: p_version_number IN igs_en_su_attempt.version_number%TYPE,
148: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
149: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
150: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
151: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
152: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
153: ) RETURN NUMBER;
154: --

Line 152: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

148: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
149: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
150: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
151: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
152: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
153: ) RETURN NUMBER;
154: --
155: -- kdande; 23-Apr-2003; Bug# 2829262
156: -- Added p_uoo_id parameter to the FUNCTION get_sua_grade

Line 160: p_person_id IN igs_en_su_attempt.person_id%TYPE,

156: -- Added p_uoo_id parameter to the FUNCTION get_sua_grade
157: --
158: FUNCTION get_sua_grade
159: (
160: p_person_id IN igs_en_su_attempt.person_id%TYPE,
161: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
162: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
163: p_version_number IN igs_en_su_attempt.version_number%TYPE,
164: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 161: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

157: --
158: FUNCTION get_sua_grade
159: (
160: p_person_id IN igs_en_su_attempt.person_id%TYPE,
161: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
162: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
163: p_version_number IN igs_en_su_attempt.version_number%TYPE,
164: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
165: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 162: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

158: FUNCTION get_sua_grade
159: (
160: p_person_id IN igs_en_su_attempt.person_id%TYPE,
161: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
162: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
163: p_version_number IN igs_en_su_attempt.version_number%TYPE,
164: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
165: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
166: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 163: p_version_number IN igs_en_su_attempt.version_number%TYPE,

159: (
160: p_person_id IN igs_en_su_attempt.person_id%TYPE,
161: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
162: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
163: p_version_number IN igs_en_su_attempt.version_number%TYPE,
164: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
165: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
166: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
167: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

Line 164: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

160: p_person_id IN igs_en_su_attempt.person_id%TYPE,
161: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
162: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
163: p_version_number IN igs_en_su_attempt.version_number%TYPE,
164: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
165: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
166: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
167: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
168: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

Line 165: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

161: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
162: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
163: p_version_number IN igs_en_su_attempt.version_number%TYPE,
164: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
165: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
166: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
167: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
168: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
169: ) RETURN VARCHAR2;

Line 166: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

162: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
163: p_version_number IN igs_en_su_attempt.version_number%TYPE,
164: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
165: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
166: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
167: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
168: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
169: ) RETURN VARCHAR2;
170: --

Line 168: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

164: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
165: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
166: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
167: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
168: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
169: ) RETURN VARCHAR2;
170: --
171: -- kdande; 23-Apr-2003; Bug# 2829262
172: -- Added p_uoo_id parameter to the FUNCTION get_sua_mark

Line 176: p_person_id IN igs_en_su_attempt.person_id%TYPE,

172: -- Added p_uoo_id parameter to the FUNCTION get_sua_mark
173: --
174: FUNCTION get_sua_mark
175: (
176: p_person_id IN igs_en_su_attempt.person_id%TYPE,
177: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
178: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
179: p_version_number IN igs_en_su_attempt.version_number%TYPE,
180: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 177: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

173: --
174: FUNCTION get_sua_mark
175: (
176: p_person_id IN igs_en_su_attempt.person_id%TYPE,
177: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
178: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
179: p_version_number IN igs_en_su_attempt.version_number%TYPE,
180: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
181: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 178: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

174: FUNCTION get_sua_mark
175: (
176: p_person_id IN igs_en_su_attempt.person_id%TYPE,
177: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
178: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
179: p_version_number IN igs_en_su_attempt.version_number%TYPE,
180: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
181: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
182: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 179: p_version_number IN igs_en_su_attempt.version_number%TYPE,

175: (
176: p_person_id IN igs_en_su_attempt.person_id%TYPE,
177: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
178: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
179: p_version_number IN igs_en_su_attempt.version_number%TYPE,
180: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
181: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
182: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
183: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

Line 180: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

176: p_person_id IN igs_en_su_attempt.person_id%TYPE,
177: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
178: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
179: p_version_number IN igs_en_su_attempt.version_number%TYPE,
180: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
181: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
182: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
183: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
184: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

Line 181: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

177: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
178: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
179: p_version_number IN igs_en_su_attempt.version_number%TYPE,
180: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
181: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
182: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
183: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
184: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
185: ) RETURN NUMBER;

Line 182: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

178: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
179: p_version_number IN igs_en_su_attempt.version_number%TYPE,
180: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
181: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
182: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
183: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
184: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
185: ) RETURN NUMBER;
186:

Line 184: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL

180: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
181: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
182: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
183: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
184: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
185: ) RETURN NUMBER;
186:
187: FUNCTION get_sua_yop
188: (

Line 189: p_person_id IN igs_en_su_attempt.person_id%TYPE,

185: ) RETURN NUMBER;
186:
187: FUNCTION get_sua_yop
188: (
189: p_person_id IN igs_en_su_attempt.person_id%TYPE,
190: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
191: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
192: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
193: ) RETURN VARCHAR2;

Line 190: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

186:
187: FUNCTION get_sua_yop
188: (
189: p_person_id IN igs_en_su_attempt.person_id%TYPE,
190: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
191: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
192: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
193: ) RETURN VARCHAR2;
194:

Line 191: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

187: FUNCTION get_sua_yop
188: (
189: p_person_id IN igs_en_su_attempt.person_id%TYPE,
190: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
191: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
192: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
193: ) RETURN VARCHAR2;
194:
195: FUNCTION get_load_gpa

Line 192: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE

188: (
189: p_person_id IN igs_en_su_attempt.person_id%TYPE,
190: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
191: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
192: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
193: ) RETURN VARCHAR2;
194:
195: FUNCTION get_load_gpa
196: (

Line 197: p_person_id IN igs_en_su_attempt.person_id%TYPE,

193: ) RETURN VARCHAR2;
194:
195: FUNCTION get_load_gpa
196: (
197: p_person_id IN igs_en_su_attempt.person_id%TYPE,
198: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
199: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
200: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
201: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 198: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

194:
195: FUNCTION get_load_gpa
196: (
197: p_person_id IN igs_en_su_attempt.person_id%TYPE,
198: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
199: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
200: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
201: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
202: ) RETURN NUMBER;

Line 199: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

195: FUNCTION get_load_gpa
196: (
197: p_person_id IN igs_en_su_attempt.person_id%TYPE,
198: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
199: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
200: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
201: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
202: ) RETURN NUMBER;
203:

Line 200: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

196: (
197: p_person_id IN igs_en_su_attempt.person_id%TYPE,
198: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
199: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
200: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
201: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
202: ) RETURN NUMBER;
203:
204: FUNCTION get_load_gpa_cp

Line 206: p_person_id IN igs_en_su_attempt.person_id%TYPE,

202: ) RETURN NUMBER;
203:
204: FUNCTION get_load_gpa_cp
205: (
206: p_person_id IN igs_en_su_attempt.person_id%TYPE,
207: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
208: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
209: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
210: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 207: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

203:
204: FUNCTION get_load_gpa_cp
205: (
206: p_person_id IN igs_en_su_attempt.person_id%TYPE,
207: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
208: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
209: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
210: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
211: ) RETURN NUMBER;

Line 208: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

204: FUNCTION get_load_gpa_cp
205: (
206: p_person_id IN igs_en_su_attempt.person_id%TYPE,
207: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
208: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
209: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
210: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
211: ) RETURN NUMBER;
212:

Line 209: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

205: (
206: p_person_id IN igs_en_su_attempt.person_id%TYPE,
207: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
208: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
209: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
210: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
211: ) RETURN NUMBER;
212:
213: FUNCTION get_load_gpa_qp

Line 215: p_person_id IN igs_en_su_attempt.person_id%TYPE,

211: ) RETURN NUMBER;
212:
213: FUNCTION get_load_gpa_qp
214: (
215: p_person_id IN igs_en_su_attempt.person_id%TYPE,
216: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
217: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
218: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
219: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 216: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

212:
213: FUNCTION get_load_gpa_qp
214: (
215: p_person_id IN igs_en_su_attempt.person_id%TYPE,
216: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
217: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
218: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
219: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
220: ) RETURN NUMBER;

Line 217: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

213: FUNCTION get_load_gpa_qp
214: (
215: p_person_id IN igs_en_su_attempt.person_id%TYPE,
216: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
217: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
218: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
219: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
220: ) RETURN NUMBER;
221:

Line 218: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

214: (
215: p_person_id IN igs_en_su_attempt.person_id%TYPE,
216: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
217: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
218: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
219: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
220: ) RETURN NUMBER;
221:
222: FUNCTION get_load_earned_cp

Line 224: p_person_id IN igs_en_su_attempt.person_id%TYPE,

220: ) RETURN NUMBER;
221:
222: FUNCTION get_load_earned_cp
223: (
224: p_person_id IN igs_en_su_attempt.person_id%TYPE,
225: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
226: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
227: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
228: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 225: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

221:
222: FUNCTION get_load_earned_cp
223: (
224: p_person_id IN igs_en_su_attempt.person_id%TYPE,
225: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
226: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
227: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
228: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
229: ) RETURN NUMBER;

Line 226: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

222: FUNCTION get_load_earned_cp
223: (
224: p_person_id IN igs_en_su_attempt.person_id%TYPE,
225: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
226: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
227: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
228: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
229: ) RETURN NUMBER;
230:

Line 227: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

223: (
224: p_person_id IN igs_en_su_attempt.person_id%TYPE,
225: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
226: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
227: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
228: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
229: ) RETURN NUMBER;
230:
231: FUNCTION get_load_attempted_cp

Line 233: p_person_id IN igs_en_su_attempt.person_id%TYPE,

229: ) RETURN NUMBER;
230:
231: FUNCTION get_load_attempted_cp
232: (
233: p_person_id IN igs_en_su_attempt.person_id%TYPE,
234: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
235: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
236: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
237: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 234: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

230:
231: FUNCTION get_load_attempted_cp
232: (
233: p_person_id IN igs_en_su_attempt.person_id%TYPE,
234: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
235: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
236: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
237: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
238: ) RETURN NUMBER;

Line 235: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

231: FUNCTION get_load_attempted_cp
232: (
233: p_person_id IN igs_en_su_attempt.person_id%TYPE,
234: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
235: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
236: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
237: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
238: ) RETURN NUMBER;
239:

Line 236: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

232: (
233: p_person_id IN igs_en_su_attempt.person_id%TYPE,
234: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
235: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
236: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
237: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
238: ) RETURN NUMBER;
239:
240: FUNCTION get_cum_gpa

Line 242: p_person_id IN igs_en_su_attempt.person_id%TYPE,

238: ) RETURN NUMBER;
239:
240: FUNCTION get_cum_gpa
241: (
242: p_person_id IN igs_en_su_attempt.person_id%TYPE,
243: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
244: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
245: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
246: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 243: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

239:
240: FUNCTION get_cum_gpa
241: (
242: p_person_id IN igs_en_su_attempt.person_id%TYPE,
243: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
244: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
245: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
246: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
247: ) RETURN NUMBER;

Line 244: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

240: FUNCTION get_cum_gpa
241: (
242: p_person_id IN igs_en_su_attempt.person_id%TYPE,
243: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
244: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
245: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
246: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
247: ) RETURN NUMBER;
248:

Line 245: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

241: (
242: p_person_id IN igs_en_su_attempt.person_id%TYPE,
243: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
244: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
245: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
246: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
247: ) RETURN NUMBER;
248:
249: FUNCTION get_cum_gpa_cp

Line 251: p_person_id IN igs_en_su_attempt.person_id%TYPE,

247: ) RETURN NUMBER;
248:
249: FUNCTION get_cum_gpa_cp
250: (
251: p_person_id IN igs_en_su_attempt.person_id%TYPE,
252: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
253: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
254: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
255: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 252: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

248:
249: FUNCTION get_cum_gpa_cp
250: (
251: p_person_id IN igs_en_su_attempt.person_id%TYPE,
252: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
253: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
254: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
255: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
256: ) RETURN NUMBER;

Line 253: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

249: FUNCTION get_cum_gpa_cp
250: (
251: p_person_id IN igs_en_su_attempt.person_id%TYPE,
252: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
253: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
254: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
255: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
256: ) RETURN NUMBER;
257:

Line 254: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

250: (
251: p_person_id IN igs_en_su_attempt.person_id%TYPE,
252: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
253: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
254: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
255: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
256: ) RETURN NUMBER;
257:
258: FUNCTION get_cum_gpa_qp

Line 260: p_person_id IN igs_en_su_attempt.person_id%TYPE,

256: ) RETURN NUMBER;
257:
258: FUNCTION get_cum_gpa_qp
259: (
260: p_person_id IN igs_en_su_attempt.person_id%TYPE,
261: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
262: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
263: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
264: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 261: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

257:
258: FUNCTION get_cum_gpa_qp
259: (
260: p_person_id IN igs_en_su_attempt.person_id%TYPE,
261: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
262: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
263: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
264: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
265: ) RETURN NUMBER;

Line 262: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

258: FUNCTION get_cum_gpa_qp
259: (
260: p_person_id IN igs_en_su_attempt.person_id%TYPE,
261: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
262: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
263: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
264: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
265: ) RETURN NUMBER;
266:

Line 263: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

259: (
260: p_person_id IN igs_en_su_attempt.person_id%TYPE,
261: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
262: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
263: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
264: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
265: ) RETURN NUMBER;
266:
267: FUNCTION get_cum_earned_cp

Line 269: p_person_id IN igs_en_su_attempt.person_id%TYPE,

265: ) RETURN NUMBER;
266:
267: FUNCTION get_cum_earned_cp
268: (
269: p_person_id IN igs_en_su_attempt.person_id%TYPE,
270: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
271: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
272: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
273: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 270: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

266:
267: FUNCTION get_cum_earned_cp
268: (
269: p_person_id IN igs_en_su_attempt.person_id%TYPE,
270: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
271: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
272: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
273: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
274: ) RETURN NUMBER;

Line 271: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

267: FUNCTION get_cum_earned_cp
268: (
269: p_person_id IN igs_en_su_attempt.person_id%TYPE,
270: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
271: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
272: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
273: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
274: ) RETURN NUMBER;
275:

Line 272: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

268: (
269: p_person_id IN igs_en_su_attempt.person_id%TYPE,
270: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
271: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
272: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
273: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
274: ) RETURN NUMBER;
275:
276: FUNCTION get_cum_attempted_cp

Line 278: p_person_id IN igs_en_su_attempt.person_id%TYPE,

274: ) RETURN NUMBER;
275:
276: FUNCTION get_cum_attempted_cp
277: (
278: p_person_id IN igs_en_su_attempt.person_id%TYPE,
279: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
280: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
281: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
282: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 279: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

275:
276: FUNCTION get_cum_attempted_cp
277: (
278: p_person_id IN igs_en_su_attempt.person_id%TYPE,
279: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
280: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
281: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
282: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
283: ) RETURN NUMBER;

Line 280: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

276: FUNCTION get_cum_attempted_cp
277: (
278: p_person_id IN igs_en_su_attempt.person_id%TYPE,
279: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
280: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
281: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
282: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
283: ) RETURN NUMBER;
284:

Line 281: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

277: (
278: p_person_id IN igs_en_su_attempt.person_id%TYPE,
279: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
280: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
281: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
282: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
283: ) RETURN NUMBER;
284:
285: END IGS_PR_ACAD_DETAILS;