[Home] [Help]
PACKAGE: APPS.IGS_PR_ACAD_DETAILS
Source
1 PACKAGE IGS_PR_ACAD_DETAILS AS
2 /* $Header: IGSPR34S.pls 120.0 2005/07/05 12:57:55 appldev noship $ */
3
4 --
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,
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,
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
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,
36 load_gpa_qp igs_ps_unit_ver.achievable_credit_points%TYPE,
37 load_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
38 load_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
39 cum_gpa igs_as_grd_sch_grade.gpa_val%TYPE,
40 cum_gpa_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
41 cum_gpa_qp igs_ps_unit_ver.achievable_credit_points%TYPE,
42 cum_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
43 cum_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE);
44
45 TYPE t_load_table IS TABLE OF r_load_record INDEX BY BINARY_INTEGER;
46
47 load_table t_load_table;
48
49 --
50 -- kdande; 23-Apr-2003; Bug# 2829262
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,
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 (
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
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,
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
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,
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
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,
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
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,
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
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,
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
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,
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
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,
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 (
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 (
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
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
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
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
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
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
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
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
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
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;