1 PACKAGE IGS_PR_GEN_003 AUTHID CURRENT_USER AS
2 /* $Header: IGSPR24S.pls 115.5 2002/11/29 02:50:21 nsidana ship $ */
3
4 PROCEDURE IGS_PR_GET_CAL_PARM(
5
6 p_course_cd IN VARCHAR2 ,
7
8 p_version_number IN NUMBER ,
9
10 p_prg_cal_type IN VARCHAR2 ,
11
12 p_level OUT NOCOPY VARCHAR2 ,
13
14 p_org_unit_cd OUT NOCOPY VARCHAR2 ,
15
16 p_ou_start_dt OUT NOCOPY DATE ,
17
18
19 p_stream_number OUT NOCOPY NUMBER ,
20
21 p_show_cause_length OUT NOCOPY NUMBER ,
22
23 p_appeal_length OUT NOCOPY NUMBER ) ;
24
25 PROCEDURE IGS_PR_GET_CONFIG_LVL(
26
27 p_course_cd IN VARCHAR2 ,
28
29 p_version_number IN NUMBER ,
30
31 p_basic_level OUT NOCOPY VARCHAR2 ,
32
33 p_calendar_level OUT NOCOPY VARCHAR2 ,
34
35 p_org_unit_cd OUT NOCOPY VARCHAR2 ,
36
37 p_ou_start_dt OUT NOCOPY DATE ) ;
38
39 PROCEDURE IGS_PR_GET_CONFIG_PARM(
40
41 p_course_cd IN VARCHAR2 ,
42
43 p_version_number IN NUMBER ,
44
45 p_apply_start_dt_alias OUT NOCOPY VARCHAR2 ,
46
47 p_apply_end_dt_alias OUT NOCOPY VARCHAR2 ,
48
49 p_end_benefit_dt_alias OUT NOCOPY VARCHAR2 ,
50
51 p_end_penalty_dt_alias OUT NOCOPY VARCHAR2 ,
52
53
54 p_show_cause_cutoff_dt_alias OUT NOCOPY VARCHAR2 ,
55
56 p_appeal_cutoff_dt_alias OUT NOCOPY VARCHAR2 ,
57
58 p_show_cause_ind OUT NOCOPY VARCHAR2 ,
59
60 p_apply_before_show_ind OUT NOCOPY VARCHAR2 ,
61
62 p_appeal_ind OUT NOCOPY VARCHAR2 ,
63
64 p_apply_before_appeal_ind OUT NOCOPY VARCHAR2 ,
65
66
67 p_count_sus_in_time_ind OUT NOCOPY VARCHAR2 ,
68
69 p_count_exc_in_time_ind OUT NOCOPY VARCHAR2 ,
70
71 p_calculate_wam_ind OUT NOCOPY VARCHAR2 ,
72
73 p_calculate_gpa_ind OUT NOCOPY VARCHAR2 ,
74
75 p_outcome_check_type OUT NOCOPY VARCHAR2 ) ;
76
77 PROCEDURE IGS_PR_INS_ADV_TODO(
78
79 p_person_id IN NUMBER ,
80
81 p_course_cd IN VARCHAR2 ,
82
83 p_version_number IN NUMBER ,
84
85 p_old_adv_stnd_type IN VARCHAR2 ,
86
87 p_new_adv_stnd_type IN VARCHAR2 ,
88
89 p_old_s_adv_stnd_grant_status IN VARCHAR2 ,
90
91
92 p_new_s_adv_stnd_grant_status IN VARCHAR2 ,
93
94 p_old_credit_points IN NUMBER ,
95
96 p_new_credit_points IN NUMBER ,
97
98 p_old_credit_percentage IN NUMBER ,
99
100 p_new_credit_percentage IN NUMBER ) ;
101
102 PROCEDURE IGS_PR_INS_PRG_MSR(
103
104 p_person_id IN NUMBER ,
105
106 p_course_cd IN VARCHAR2 ,
107
108 p_version_number IN NUMBER ,
109
110 p_prg_cal_type IN VARCHAR2 ,
111
112 p_prg_sequence_number IN NUMBER ) ;
113
114 PROCEDURE IGS_PR_INS_SPO_HIST(
115
116 p_person_id IN NUMBER ,
117
118 p_course_cd IN VARCHAR2 ,
119
120 p_sequence_number IN NUMBER ,
121
122 p_new_prg_cal_type IN VARCHAR2 ,
123
124 p_old_prg_cal_type IN VARCHAR2 ,
125
126 p_new_prg_ci_sequence_number IN NUMBER ,
127
128
129 p_old_prg_ci_sequence_number IN NUMBER ,
130
131 p_new_rule_check_dt IN DATE ,
132
133 p_old_rule_check_dt IN DATE ,
134
135 p_new_progression_rule_cat IN VARCHAR2 ,
136
137 p_old_progression_rule_cat IN VARCHAR2 ,
138
139 p_new_pra_sequence_number IN NUMBER ,
140
141
142 p_old_pra_sequence_number IN NUMBER ,
143
144 p_new_pro_pra_sequence_number IN NUMBER ,
145
146 p_old_pro_pra_sequence_number IN NUMBER ,
147
148 p_new_pro_sequence_number IN NUMBER ,
149
150 p_old_pro_sequence_number IN NUMBER ,
151
152 p_new_progression_outcome_type IN VARCHAR2 ,
153
154 p_old_progression_outcome_type IN VARCHAR2 ,
155
156
157 p_new_duration IN NUMBER ,
158
159 p_old_duration IN NUMBER ,
160
161 p_new_duration_type IN VARCHAR2 ,
162
163 p_old_duration_type IN VARCHAR2 ,
164
165 p_new_decision_status IN VARCHAR2 ,
166
167 p_old_decision_status IN VARCHAR2 ,
168
169
170 p_new_decision_dt IN DATE ,
171
172 p_old_decision_dt IN DATE ,
173
174 p_new_decision_org_unit_cd IN VARCHAR2 ,
175
176 p_old_decision_org_unit_cd IN VARCHAR2 ,
177
178 p_new_decision_ou_start_dt IN DATE ,
179
180 p_old_decision_ou_start_dt IN DATE ,
181
182 p_new_applied_dt IN DATE ,
183
184
185 p_old_applied_dt IN DATE ,
186
187 p_new_expiry_dt IN DATE ,
188
189 p_old_expiry_dt IN DATE ,
190
191 p_new_show_cause_expiry_dt IN DATE ,
192
193 p_old_show_cause_expiry_dt IN DATE ,
194
195 p_new_show_cause_dt IN DATE ,
196
197
198 p_old_show_cause_dt IN DATE ,
199
200 p_new_show_cause_outcome_dt IN DATE ,
201
202 p_old_show_cause_outcome_dt IN DATE ,
203
204 p_new_show_cause_outcome_type IN VARCHAR2 ,
205
206 p_old_show_cause_outcome_type IN VARCHAR2 ,
207
208 p_new_appeal_expiry_dt IN DATE ,
209
210 p_old_appeal_expiry_dt IN DATE ,
211
212
213 p_new_appeal_dt IN DATE ,
214
215 p_old_appeal_dt IN DATE ,
216
217 p_new_appeal_outcome_dt IN DATE ,
218
219 p_old_appeal_outcome_dt IN DATE ,
220
221 p_new_appeal_outcome_type IN VARCHAR2 ,
222
223 p_old_appeal_outcome_type IN VARCHAR2 ,
224
225
226 p_new_encmb_course_group_cd IN VARCHAR2 ,
227
228 p_old_encmb_course_group_cd IN VARCHAR2 ,
229
230 p_new_restricted_enrolment_cp IN NUMBER ,
231
232 p_old_restricted_enrolment_cp IN NUMBER ,
233
234 p_new_restricted_att_type IN VARCHAR2 ,
235
236 p_old_restricted_att_type IN VARCHAR2 ,
237
238 p_new_LAST_UPDATED_BY IN VARCHAR2 ,
239
240
241 p_old_LAST_UPDATED_BY IN VARCHAR2 ,
242
243 p_new_LAST_UPDATE_DATE IN DATE ,
244
245 p_old_LAST_UPDATE_DATE IN DATE ,
246
247 p_new_comments IN VARCHAR2 ,
248
249 p_old_comments IN VARCHAR2 ,
250
254 p_old_show_cause_comments IN VARCHAR2 ,
251 p_new_show_cause_comments IN VARCHAR2 ,
252
253
255
256 p_new_appeal_comments IN VARCHAR2 ,
257
258 p_old_appeal_comments IN VARCHAR2 ) ;
259
260 PROCEDURE IGS_PR_INS_SSP(
261 p_creation_dt IN DATE ,
262 p_key IN VARCHAR2 ,
263 p_s_message_name IN VARCHAR2 ,
264 p_text IN VARCHAR2 ,
265 p_ssp_sequence_number OUT NOCOPY NUMBER );
266
267 END IGS_PR_GEN_003;