1 PACKAGE igs_as_su_stmptout_pkg AS
2 /* $Header: IGSDI26S.pls 120.0 2005/07/05 12:50:01 appldev noship $ */
3 PROCEDURE insert_row (
4 x_rowid IN OUT NOCOPY VARCHAR2,
5 x_org_id IN NUMBER,
6 x_person_id IN NUMBER,
7 x_course_cd IN VARCHAR2,
8 x_unit_cd IN VARCHAR2,
9 x_cal_type IN VARCHAR2,
10 x_ci_sequence_number IN NUMBER,
11 x_outcome_dt IN DATE,
12 x_ci_start_dt IN DATE,
13 x_ci_end_dt IN DATE,
14 x_grading_schema_cd IN VARCHAR2,
15 x_version_number IN NUMBER,
16 x_grade IN VARCHAR2,
17 x_s_grade_creation_method_type IN VARCHAR2,
18 x_finalised_outcome_ind IN VARCHAR2,
19 x_mark IN NUMBER,
20 x_number_times_keyed IN NUMBER,
21 x_translated_grading_schema_cd IN VARCHAR2,
22 x_translated_version_number IN NUMBER,
23 x_translated_grade IN VARCHAR2,
24 x_translated_dt IN DATE,
25 x_mode IN VARCHAR2 DEFAULT 'R',
26 x_grading_period_cd IN VARCHAR2 DEFAULT 'FINAL',
27 x_attribute_category IN VARCHAR2 DEFAULT NULL,
28 x_attribute1 IN VARCHAR2 DEFAULT NULL,
29 x_attribute2 IN VARCHAR2 DEFAULT NULL,
30 x_attribute3 IN VARCHAR2 DEFAULT NULL,
31 x_attribute4 IN VARCHAR2 DEFAULT NULL,
32 x_attribute5 IN VARCHAR2 DEFAULT NULL,
33 x_attribute6 IN VARCHAR2 DEFAULT NULL,
34 x_attribute7 IN VARCHAR2 DEFAULT NULL,
35 x_attribute8 IN VARCHAR2 DEFAULT NULL,
36 x_attribute9 IN VARCHAR2 DEFAULT NULL,
37 x_attribute10 IN VARCHAR2 DEFAULT NULL,
38 x_attribute11 IN VARCHAR2 DEFAULT NULL,
39 x_attribute12 IN VARCHAR2 DEFAULT NULL,
40 x_attribute13 IN VARCHAR2 DEFAULT NULL,
41 x_attribute14 IN VARCHAR2 DEFAULT NULL,
42 x_attribute15 IN VARCHAR2 DEFAULT NULL,
43 x_attribute16 IN VARCHAR2 DEFAULT NULL,
44 x_attribute17 IN VARCHAR2 DEFAULT NULL,
45 x_attribute18 IN VARCHAR2 DEFAULT NULL,
46 x_attribute19 IN VARCHAR2 DEFAULT NULL,
47 x_attribute20 IN VARCHAR2 DEFAULT NULL,
48 x_incomp_deadline_date IN DATE DEFAULT NULL,
49 x_incomp_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
50 x_incomp_version_number IN NUMBER DEFAULT NULL,
51 x_incomp_default_grade IN VARCHAR2 DEFAULT NULL,
52 x_incomp_default_mark IN NUMBER DEFAULT NULL,
53 x_comments IN VARCHAR2 DEFAULT NULL,
54 x_uoo_id IN NUMBER DEFAULT NULL,
55 x_mark_capped_flag IN VARCHAR2 DEFAULT 'N',
56 x_release_date IN DATE DEFAULT NULL,
57 x_manual_override_flag IN VARCHAR2 DEFAULT 'N',
58 x_show_on_academic_histry_flag IN VARCHAR2 DEFAULT 'Y'
59 );
60
61 PROCEDURE lock_row (
62 x_rowid IN VARCHAR2,
63 x_person_id IN NUMBER,
64 x_course_cd IN VARCHAR2,
65 x_unit_cd IN VARCHAR2,
66 x_cal_type IN VARCHAR2,
67 x_ci_sequence_number IN NUMBER,
68 x_outcome_dt IN DATE,
69 x_ci_start_dt IN DATE,
70 x_ci_end_dt IN DATE,
71 x_grading_schema_cd IN VARCHAR2,
72 x_version_number IN NUMBER,
73 x_grade IN VARCHAR2,
74 x_s_grade_creation_method_type IN VARCHAR2,
75 x_finalised_outcome_ind IN VARCHAR2,
76 x_mark IN NUMBER,
77 x_number_times_keyed IN NUMBER,
78 x_translated_grading_schema_cd IN VARCHAR2,
79 x_translated_version_number IN NUMBER,
80 x_translated_grade IN VARCHAR2,
81 x_translated_dt IN DATE,
82 x_grading_period_cd IN VARCHAR2 DEFAULT 'FINAL',
83 x_attribute_category IN VARCHAR2 DEFAULT NULL,
84 x_attribute1 IN VARCHAR2 DEFAULT NULL,
85 x_attribute2 IN VARCHAR2 DEFAULT NULL,
86 x_attribute3 IN VARCHAR2 DEFAULT NULL,
87 x_attribute4 IN VARCHAR2 DEFAULT NULL,
88 x_attribute5 IN VARCHAR2 DEFAULT NULL,
89 x_attribute6 IN VARCHAR2 DEFAULT NULL,
90 x_attribute7 IN VARCHAR2 DEFAULT NULL,
91 x_attribute8 IN VARCHAR2 DEFAULT NULL,
92 x_attribute9 IN VARCHAR2 DEFAULT NULL,
93 x_attribute10 IN VARCHAR2 DEFAULT NULL,
94 x_attribute11 IN VARCHAR2 DEFAULT NULL,
95 x_attribute12 IN VARCHAR2 DEFAULT NULL,
96 x_attribute13 IN VARCHAR2 DEFAULT NULL,
97 x_attribute14 IN VARCHAR2 DEFAULT NULL,
98 x_attribute15 IN VARCHAR2 DEFAULT NULL,
99 x_attribute16 IN VARCHAR2 DEFAULT NULL,
100 x_attribute17 IN VARCHAR2 DEFAULT NULL,
101 x_attribute18 IN VARCHAR2 DEFAULT NULL,
102 x_attribute19 IN VARCHAR2 DEFAULT NULL,
103 x_attribute20 IN VARCHAR2 DEFAULT NULL,
104 x_incomp_deadline_date IN DATE DEFAULT NULL,
105 x_incomp_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
106 x_incomp_version_number IN NUMBER DEFAULT NULL,
107 x_incomp_default_grade IN VARCHAR2 DEFAULT NULL,
108 x_incomp_default_mark IN NUMBER DEFAULT NULL,
109 x_comments IN VARCHAR2 DEFAULT NULL,
110 x_uoo_id IN NUMBER DEFAULT NULL,
111 x_mark_capped_flag IN VARCHAR2 DEFAULT 'N',
112 x_release_date IN DATE DEFAULT NULL,
113 x_manual_override_flag IN VARCHAR2 DEFAULT 'N',
114 x_show_on_academic_histry_flag IN VARCHAR2 DEFAULT 'Y'
115 );
116
117 PROCEDURE update_row (
118 x_rowid IN VARCHAR2,
119 x_person_id IN NUMBER,
120 x_course_cd IN VARCHAR2,
121 x_unit_cd IN VARCHAR2,
122 x_cal_type IN VARCHAR2,
123 x_ci_sequence_number IN NUMBER,
124 x_outcome_dt IN DATE,
125 x_ci_start_dt IN DATE,
126 x_ci_end_dt IN DATE,
127 x_grading_schema_cd IN VARCHAR2,
128 x_version_number IN NUMBER,
129 x_grade IN VARCHAR2,
130 x_s_grade_creation_method_type IN VARCHAR2,
131 x_finalised_outcome_ind IN VARCHAR2,
132 x_mark IN NUMBER,
133 x_number_times_keyed IN NUMBER,
134 x_translated_grading_schema_cd IN VARCHAR2,
135 x_translated_version_number IN NUMBER,
136 x_translated_grade IN VARCHAR2,
137 x_translated_dt IN DATE,
138 x_mode IN VARCHAR2 DEFAULT 'R',
139 x_grading_period_cd IN VARCHAR2 DEFAULT 'FINAL',
140 x_attribute_category IN VARCHAR2 DEFAULT NULL,
141 x_attribute1 IN VARCHAR2 DEFAULT NULL,
142 x_attribute2 IN VARCHAR2 DEFAULT NULL,
143 x_attribute3 IN VARCHAR2 DEFAULT NULL,
144 x_attribute4 IN VARCHAR2 DEFAULT NULL,
145 x_attribute5 IN VARCHAR2 DEFAULT NULL,
146 x_attribute6 IN VARCHAR2 DEFAULT NULL,
147 x_attribute7 IN VARCHAR2 DEFAULT NULL,
148 x_attribute8 IN VARCHAR2 DEFAULT NULL,
149 x_attribute9 IN VARCHAR2 DEFAULT NULL,
150 x_attribute10 IN VARCHAR2 DEFAULT NULL,
151 x_attribute11 IN VARCHAR2 DEFAULT NULL,
152 x_attribute12 IN VARCHAR2 DEFAULT NULL,
153 x_attribute13 IN VARCHAR2 DEFAULT NULL,
154 x_attribute14 IN VARCHAR2 DEFAULT NULL,
155 x_attribute15 IN VARCHAR2 DEFAULT NULL,
156 x_attribute16 IN VARCHAR2 DEFAULT NULL,
157 x_attribute17 IN VARCHAR2 DEFAULT NULL,
158 x_attribute18 IN VARCHAR2 DEFAULT NULL,
159 x_attribute19 IN VARCHAR2 DEFAULT NULL,
160 x_attribute20 IN VARCHAR2 DEFAULT NULL,
161 x_incomp_deadline_date IN DATE DEFAULT NULL,
162 x_incomp_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
163 x_incomp_version_number IN NUMBER DEFAULT NULL,
164 x_incomp_default_grade IN VARCHAR2 DEFAULT NULL,
165 x_incomp_default_mark IN NUMBER DEFAULT NULL,
166 x_comments IN VARCHAR2 DEFAULT NULL,
167 x_uoo_id IN NUMBER DEFAULT NULL,
168 x_mark_capped_flag IN VARCHAR2 DEFAULT 'N',
169 x_release_date IN DATE DEFAULT NULL,
170 x_manual_override_flag IN VARCHAR2 DEFAULT 'N',
171 x_show_on_academic_histry_flag IN VARCHAR2 DEFAULT 'Y'
172 );
173
174 PROCEDURE add_row (
175 x_rowid IN OUT NOCOPY VARCHAR2,
176 x_org_id IN NUMBER,
177 x_person_id IN NUMBER,
178 x_course_cd IN VARCHAR2,
179 x_unit_cd IN VARCHAR2,
180 x_cal_type IN VARCHAR2,
181 x_ci_sequence_number IN NUMBER,
182 x_outcome_dt IN DATE,
183 x_ci_start_dt IN DATE,
184 x_ci_end_dt IN DATE,
185 x_grading_schema_cd IN VARCHAR2,
186 x_version_number IN NUMBER,
187 x_grade IN VARCHAR2,
188 x_s_grade_creation_method_type IN VARCHAR2,
189 x_finalised_outcome_ind IN VARCHAR2,
190 x_mark IN NUMBER,
191 x_number_times_keyed IN NUMBER,
192 x_translated_grading_schema_cd IN VARCHAR2,
193 x_translated_version_number IN NUMBER,
194 x_translated_grade IN VARCHAR2,
195 x_translated_dt IN DATE,
196 x_mode IN VARCHAR2 DEFAULT 'R',
197 x_grading_period_cd IN VARCHAR2 DEFAULT 'FINAL',
198 x_attribute_category IN VARCHAR2 DEFAULT NULL,
199 x_attribute1 IN VARCHAR2 DEFAULT NULL,
200 x_attribute2 IN VARCHAR2 DEFAULT NULL,
201 x_attribute3 IN VARCHAR2 DEFAULT NULL,
202 x_attribute4 IN VARCHAR2 DEFAULT NULL,
203 x_attribute5 IN VARCHAR2 DEFAULT NULL,
204 x_attribute6 IN VARCHAR2 DEFAULT NULL,
205 x_attribute7 IN VARCHAR2 DEFAULT NULL,
206 x_attribute8 IN VARCHAR2 DEFAULT NULL,
207 x_attribute9 IN VARCHAR2 DEFAULT NULL,
208 x_attribute10 IN VARCHAR2 DEFAULT NULL,
209 x_attribute11 IN VARCHAR2 DEFAULT NULL,
210 x_attribute12 IN VARCHAR2 DEFAULT NULL,
211 x_attribute13 IN VARCHAR2 DEFAULT NULL,
212 x_attribute14 IN VARCHAR2 DEFAULT NULL,
213 x_attribute15 IN VARCHAR2 DEFAULT NULL,
214 x_attribute16 IN VARCHAR2 DEFAULT NULL,
215 x_attribute17 IN VARCHAR2 DEFAULT NULL,
216 x_attribute18 IN VARCHAR2 DEFAULT NULL,
217 x_attribute19 IN VARCHAR2 DEFAULT NULL,
218 x_attribute20 IN VARCHAR2 DEFAULT NULL,
219 x_incomp_deadline_date IN DATE DEFAULT NULL,
220 x_incomp_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
221 x_incomp_version_number IN NUMBER DEFAULT NULL,
222 x_incomp_default_grade IN VARCHAR2 DEFAULT NULL,
223 x_incomp_default_mark IN NUMBER DEFAULT NULL,
224 x_comments IN VARCHAR2 DEFAULT NULL,
225 x_uoo_id IN NUMBER DEFAULT NULL,
226 x_mark_capped_flag IN VARCHAR2 DEFAULT 'N',
227 x_release_date IN DATE DEFAULT NULL,
228 x_manual_override_flag IN VARCHAR2 DEFAULT 'N',
229 x_show_on_academic_histry_flag IN VARCHAR2 DEFAULT 'Y'
230 );
231
232 PROCEDURE delete_row (x_rowid IN VARCHAR2,
233 x_mode IN VARCHAR2 DEFAULT 'R');
234
235 FUNCTION get_pk_for_validation (
236 x_person_id IN NUMBER,
237 x_course_cd IN VARCHAR2,
238 x_outcome_dt IN DATE,
239 x_grading_period_cd IN VARCHAR2 DEFAULT 'FINAL',
240 x_uoo_id IN NUMBER
241 ) RETURN BOOLEAN;
242
243 PROCEDURE get_ufk_igs_ca_inst (
244 x_cal_type IN VARCHAR2,
245 x_sequence_number IN NUMBER,
246 x_start_dt IN DATE,
247 x_end_dt IN DATE
248 );
249
250 PROCEDURE get_fk_igs_lookups_view (x_s_grade_creation_method_type IN VARCHAR2);
251
252 PROCEDURE get_fk_igs_en_su_attempt (x_person_id IN NUMBER, x_course_cd IN VARCHAR2, x_uoo_id IN NUMBER);
253
254 PROCEDURE get_fk_igs_as_grd_sch_grade (x_grading_schema_cd IN VARCHAR2, x_version_number IN NUMBER, x_grade IN VARCHAR2);
255
256 PROCEDURE check_constraints (column_name IN VARCHAR2 DEFAULT NULL, column_value IN VARCHAR2 DEFAULT NULL);
257
258 PROCEDURE before_dml (
259 p_action IN VARCHAR2,
260 x_rowid IN VARCHAR2 DEFAULT NULL,
261 x_org_id IN NUMBER DEFAULT NULL,
262 x_cal_type IN VARCHAR2 DEFAULT NULL,
263 x_ci_sequence_number IN NUMBER DEFAULT NULL,
264 x_ci_start_dt IN DATE DEFAULT NULL,
265 x_ci_end_dt IN DATE DEFAULT NULL,
266 x_outcome_dt IN DATE DEFAULT NULL,
267 x_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
268 x_version_number IN NUMBER DEFAULT NULL,
269 x_grade IN VARCHAR2 DEFAULT NULL,
270 x_s_grade_creation_method_type IN VARCHAR2 DEFAULT NULL,
271 x_finalised_outcome_ind IN VARCHAR2 DEFAULT NULL,
272 x_mark IN NUMBER DEFAULT NULL,
273 x_translated_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
274 x_translated_version_number IN NUMBER DEFAULT NULL,
275 x_translated_grade IN VARCHAR2 DEFAULT NULL,
276 x_translated_dt IN DATE DEFAULT NULL,
277 x_number_times_keyed IN NUMBER DEFAULT NULL,
278 x_person_id IN NUMBER DEFAULT NULL,
279 x_course_cd IN VARCHAR2 DEFAULT NULL,
280 x_unit_cd IN VARCHAR2 DEFAULT NULL,
281 x_creation_date IN DATE DEFAULT NULL,
282 x_created_by IN NUMBER DEFAULT NULL,
283 x_last_update_date IN DATE DEFAULT NULL,
284 x_last_updated_by IN NUMBER DEFAULT NULL,
285 x_last_update_login IN NUMBER DEFAULT NULL,
286 x_grading_period_cd IN VARCHAR2 DEFAULT 'FINAL',
287 x_attribute_category IN VARCHAR2 DEFAULT NULL,
288 x_attribute1 IN VARCHAR2 DEFAULT NULL,
289 x_attribute2 IN VARCHAR2 DEFAULT NULL,
290 x_attribute3 IN VARCHAR2 DEFAULT NULL,
291 x_attribute4 IN VARCHAR2 DEFAULT NULL,
292 x_attribute5 IN VARCHAR2 DEFAULT NULL,
293 x_attribute6 IN VARCHAR2 DEFAULT NULL,
294 x_attribute7 IN VARCHAR2 DEFAULT NULL,
295 x_attribute8 IN VARCHAR2 DEFAULT NULL,
296 x_attribute9 IN VARCHAR2 DEFAULT NULL,
297 x_attribute10 IN VARCHAR2 DEFAULT NULL,
298 x_attribute11 IN VARCHAR2 DEFAULT NULL,
299 x_attribute12 IN VARCHAR2 DEFAULT NULL,
300 x_attribute13 IN VARCHAR2 DEFAULT NULL,
301 x_attribute14 IN VARCHAR2 DEFAULT NULL,
302 x_attribute15 IN VARCHAR2 DEFAULT NULL,
303 x_attribute16 IN VARCHAR2 DEFAULT NULL,
304 x_attribute17 IN VARCHAR2 DEFAULT NULL,
305 x_attribute18 IN VARCHAR2 DEFAULT NULL,
306 x_attribute19 IN VARCHAR2 DEFAULT NULL,
307 x_attribute20 IN VARCHAR2 DEFAULT NULL,
308 x_incomp_deadline_date IN DATE DEFAULT NULL,
309 x_incomp_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
310 x_incomp_version_number IN NUMBER DEFAULT NULL,
311 x_incomp_default_grade IN VARCHAR2 DEFAULT NULL,
312 x_incomp_default_mark IN NUMBER DEFAULT NULL,
313 x_comments IN VARCHAR2 DEFAULT NULL,
314 x_uoo_id IN NUMBER DEFAULT NULL,
315 x_mark_capped_flag IN VARCHAR2 DEFAULT 'N',
316 x_release_date IN DATE DEFAULT NULL,
317 x_manual_override_flag IN VARCHAR2 DEFAULT 'N',
318 x_show_on_academic_histry_flag IN VARCHAR2 DEFAULT 'Y'
319 );
320 END igs_as_su_stmptout_pkg;