[Home] [Help]
PACKAGE: APPS.IGS_DA_XML_PKG
Source
1 PACKAGE IGS_DA_XML_PKG AS
2 /* $Header: IGSDA10S.pls 120.0 2005/07/05 11:41:31 appldev noship $ */
3
4 TYPE r_sua_record IS RECORD (
5 person_id igs_en_su_attempt.person_id%TYPE,
6 course_cd igs_en_su_attempt.course_cd%TYPE,
7 uoo_id igs_en_su_attempt.uoo_id%TYPE,
8 grade igs_as_su_stmptout.grade%TYPE,
9 mark igs_as_su_stmptout.mark%TYPE,
10 s_result_type igs_as_grd_sch_grade.s_result_type%TYPE,
11 gpa igs_as_grd_sch_grade.gpa_val%TYPE,
12 gpa_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
13 gpa_qp igs_ps_unit_ver.achievable_credit_points%TYPE,
14 earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
15 attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE
16 );
17
18 TYPE t_sua_table IS TABLE OF r_sua_record INDEX BY BINARY_INTEGER;
19
20 sua_table t_sua_table;
21
22 TYPE r_load_record IS RECORD (
23 person_id igs_en_su_attempt.person_id%TYPE,
24 course_cd igs_en_su_attempt.course_cd%TYPE,
25 load_cal_type igs_en_su_attempt.cal_type%TYPE,
26 load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
27 cum_gpa igs_as_grd_sch_grade.gpa_val%TYPE,
28 cum_gpa_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
29 cum_gpa_qp igs_ps_unit_ver.achievable_credit_points%TYPE,
30 cum_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
31 cum_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE);
32
33 TYPE t_load_table IS TABLE OF r_load_record INDEX BY BINARY_INTEGER;
34
35 load_table t_load_table;
36
37 -----------------------------------------------------------------------------
38 -- Record and Table types for
39 -- student_type_list function
40 --
41 TYPE r_student_type_rec IS RECORD (
42 person_type_code igs_pe_typ_instances_all.person_type_code%TYPE);
43
44 TYPE t_student_type_table IS TABLE OF
45 r_student_type_rec INDEX BY BINARY_INTEGER;
46
47 student_type_table t_student_type_table;
48 -----------------------------------------------------------------------------
49
50 PROCEDURE populate_sua_table
51 (
52 p_person_id IN igs_en_su_attempt.person_id%TYPE,
53 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
54 p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
55 p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
56 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
57 );
58
59 PROCEDURE populate_load_table
60 (
61 p_person_id IN igs_en_su_attempt.person_id%TYPE,
62 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
63 p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
64 p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
65 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
66 );
67
68 FUNCTION get_sua_gpa_cp
69 (
70 p_person_id IN igs_en_su_attempt.person_id%TYPE,
71 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
72 p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
73 p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
74 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
75 ) RETURN NUMBER;
76
77 FUNCTION get_sua_gpa_qp
78 (
79 p_person_id IN igs_en_su_attempt.person_id%TYPE,
80 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
81 p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
82 p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
83 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
84 ) RETURN NUMBER;
85
86 FUNCTION get_sua_earned_cp
87 (
88 p_person_id IN igs_en_su_attempt.person_id%TYPE,
89 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
90 p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
91 p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
92 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
93 ) RETURN NUMBER;
94
95 FUNCTION get_sua_attempted_cp
96 (
97 p_person_id IN igs_en_su_attempt.person_id%TYPE,
98 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
99 p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
100 p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
101 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
102 ) RETURN NUMBER;
103
104 FUNCTION get_sua_grade
105 (
106 p_person_id IN igs_en_su_attempt.person_id%TYPE,
107 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
108 p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
109 p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
110 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
111 ) RETURN VARCHAR2;
112
113 FUNCTION get_sua_mark
114 (
115 p_person_id IN igs_en_su_attempt.person_id%TYPE,
116 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
117 p_uoo_id IN igs_en_su_attempt.uoo_id%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 ) RETURN NUMBER;
121
122 FUNCTION get_sua_result_type
123 (
124 p_person_id IN igs_en_su_attempt.person_id%TYPE,
125 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
126 p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
127 p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
128 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
129 ) RETURN VARCHAR2;
130
131 FUNCTION get_cum_gpa
132 (
133 p_person_id IN igs_en_su_attempt.person_id%TYPE,
134 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
135 p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
136 p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
137 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
138 ) RETURN NUMBER;
139
140 FUNCTION get_cum_gpa_cp
141 (
142 p_person_id IN igs_en_su_attempt.person_id%TYPE,
143 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
144 p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
145 p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
146 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
147 ) RETURN NUMBER;
148
149 FUNCTION get_cum_gpa_qp
150 (
151 p_person_id IN igs_en_su_attempt.person_id%TYPE,
152 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
153 p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
154 p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
155 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
156 ) RETURN NUMBER;
157
158 FUNCTION get_cum_earned_cp
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_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
163 p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
164 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
165 ) RETURN NUMBER;
166
167 FUNCTION get_cum_attempted_cp
168 (
169 p_person_id IN igs_en_su_attempt.person_id%TYPE,
170 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
171 p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
172 p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
173 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
174 ) RETURN NUMBER;
175
176 -- ====================================================================================
177
178 FUNCTION get_course_abbr_num
179 (
180 p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
181 p_evaluation_type IN CHAR DEFAULT 'A'
182 ) RETURN VARCHAR2;
183
184 FUNCTION student_type_list
185 (
186 p_person_id IN igs_en_su_attempt.person_id%TYPE
187 ) RETURN VARCHAR2;
188
189
190 FUNCTION get_unit_repeatable
191 (
192 p_person_id IN igs_en_su_attempt.person_id%TYPE,
193 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
194 p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
195 p_version_number IN igs_en_su_attempt.version_number%TYPE,
196 p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
197 p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
198 p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
199 p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
200 ) RETURN VARCHAR2;
201
202 PROCEDURE get_person_details
203 (
204 p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
205 p_person_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
206 p_person_id OUT NOCOPY hz_parties.party_id%TYPE,
207 p_person_number OUT NOCOPY hz_parties.party_number%TYPE
208 );
209
210 PROCEDURE update_stdnts_err
211 (
212 p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
213 p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
214 p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
215 p_report_text IN igs_da_req_stdnts.report_text%TYPE,
216 p_error_code IN igs_da_req_stdnts.error_code%TYPE,
217 x_return_status OUT NOCOPY VARCHAR2
218 ) ;
219
220
221 PROCEDURE update_req_students (
222 p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
223 p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
224 p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
225 p_report_text IN igs_da_req_stdnts.report_text%TYPE,
226 p_academicsubprogram_codes IN VARCHAR2,
227 p_program_code IN igs_da_req_stdnts.program_code%TYPE,
228 p_error_code IN igs_da_req_stdnts.error_code%TYPE,
229 x_return_status OUT NOCOPY VARCHAR2
230 ) ;
231
232 PROCEDURE insert_gpa
233 (
234 p_batch_id IN igs_pr_stu_acad_stat_int.batch_id%TYPE,
235 p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
236 p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
237 p_program_code IN igs_da_req_stdnts.program_code%TYPE,
238 p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,
239 p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,
240 p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,
241 p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
242 p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
243 p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,
244 p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%TYPE,
245 p_gpa_quality_points IN igs_pr_stu_acad_stat_int.gpa_quality_points%TYPE,
246 x_return_status OUT NOCOPY VARCHAR2
247 );
248
249 PROCEDURE insert_program_completion
250 (
251 p_batch_id IN igs_pr_spa_complete_int.batch_id%TYPE,
252 p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
253 p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
254 p_program_code IN igs_da_req_stdnts.program_code%TYPE,
255 p_program_complete IN VARCHAR2,
256 p_program_complete_date IN VARCHAR2,
257 x_return_status OUT NOCOPY VARCHAR2
258 );
259
260 PROCEDURE Submit_Event (
261 p_batch_id IN IGS_DA_REQ_STDNTS.BATCH_ID%TYPE
262 );
263
264 PROCEDURE process_reply_failure
265 (p_batch_id IN igs_da_req_stdnts.batch_id%TYPE
266 );
267
268 PROCEDURE update_request_status
269 ( p_batch_id IN igs_da_req_stdnts.batch_id%TYPE
270 );
271
272
273 PROCEDURE Pre_Submit_Event (
274 p_batch_id IN IGS_DA_REQ_STDNTS.BATCH_ID%TYPE
275 );
276
277
278 END IGS_DA_XML_PKG;