1 PACKAGE IGS_PR_GEN_006 AUTHID CURRENT_USER AS
2 /* $Header: IGSPR27S.pls 115.8 2002/12/13 07:58:34 smanglm ship $ */
3
4 FUNCTION IGS_PR_GET_SCSC_COMP(
5
6 p_person_id IN NUMBER ,
7
8 p_course_cd IN VARCHAR2 ,
9
10 p_version_number IN NUMBER ,
11
12 p_cst_sequence_number IN NUMBER )
13
14 RETURN VARCHAR2 ;
15
16
17 FUNCTION IGS_PR_get_spo_aply_dt(
18
19 p_decision_status IN VARCHAR2 ,
20
21 p_old_applied_dt IN DATE ,
22
23 p_new_applied_dt IN DATE ,
24
25 p_old_encmb_course_group_cd IN VARCHAR2 ,
26
27 p_new_encmb_course_group_cd IN VARCHAR2 ,
28
29 p_old_restricted_enrolment_cp IN NUMBER ,
30
31 p_new_restricted_enrolment_cp IN NUMBER ,
32
33 p_old_restricted_attend_type IN VARCHAR2 ,
34
35 p_new_restricted_attend_type IN VARCHAR2 ,
36
37 p_old_expiry_dt IN DATE ,
38
39 p_new_expiry_dt IN DATE ,
40
41
42 p_old_duration IN NUMBER ,
43
44 p_new_duration IN NUMBER ,
45
46 p_old_duration_type IN VARCHAR2 ,
47
48 p_new_duration_type IN VARCHAR2 ,
49
50 p_out_applied_dt OUT NOCOPY DATE )
51
52 RETURN BOOLEAN ;
53
54
55 FUNCTION IGS_PR_GET_SPO_CMT(
56
57 p_person_id IN NUMBER ,
58
59 p_course_cd IN VARCHAR2 ,
60
61 p_version_number IN NUMBER ,
62
63 p_org_unit_cd IN VARCHAR2 ,
64
65 p_ou_start_dt IN DATE ,
66
67 p_course_type IN VARCHAR2 ,
68
69 p_location_cd IN VARCHAR2 ,
70
71 p_attendance_mode IN VARCHAR2 )
72
73 RETURN VARCHAR2 ;
74
75
76 FUNCTION IGS_PR_get_spo_expiry(
77
78 p_person_id IN NUMBER ,
79
80 p_course_cd IN VARCHAR2 ,
81
82 p_sequence_number IN NUMBER ,
83
84 p_spo_expiry_dt IN DATE ,
85
86 p_expiry_dt OUT NOCOPY DATE )
87
88 RETURN VARCHAR2;
89
90 FUNCTION IGS_PR_get_sprc_dsp(
91
92 p_person_id IN NUMBER ,
93
94 p_course_cd IN VARCHAR2 ,
95
96 p_prg_cal_type IN VARCHAR2 ,
97
98 p_prg_ci_sequence_number IN NUMBER ,
99
100 p_rule_check_dt IN DATE ,
101
102 p_progression_rule_cat IN VARCHAR2 ,
103
104 p_pra_sequence_number IN NUMBER )
105
106 RETURN VARCHAR2;
107 FUNCTION IGS_PR_GET_STD_GPA(
108
109 p_person_id IN NUMBER ,
110
111 p_course_cd IN VARCHAR2 ,
112
113 p_prg_cal_type IN VARCHAR2 ,
114
115 p_prg_sequence_number IN NUMBER )
116
117 RETURN NUMBER;
118
119
120
121 FUNCTION IGS_PR_GET_STD_WAM(
122
123 p_person_id IN NUMBER ,
124
125 p_course_cd IN VARCHAR2 ,
126
127 p_course_version IN NUMBER ,
128
129 p_prg_cal_type IN VARCHAR2 ,
130
131 p_prg_sequence_number IN NUMBER )
132
133 RETURN NUMBER ;
134
135
136
137 FUNCTION IGS_PR_get_within_appl(
138
139 p_prg_cal_type IN VARCHAR2 ,
140
141 p_prg_sequence_number IN NUMBER ,
142
143 p_course_cd IN VARCHAR2 ,
144
145 p_version_number IN NUMBER ,
146
147 p_application_type IN VARCHAR2 ,
148
149 p_start_dt OUT NOCOPY DATE ,
150
151 p_cutoff_dt OUT NOCOPY DATE )
152
153 RETURN VARCHAR2;
154
155
156
157 FUNCTION IGS_PR_INS_COPY_PRA(
158
159 p_progression_rule_cat IN VARCHAR2 ,
160
161 p_sequence_number IN NUMBER ,
162
163 p_new_course_cd IN VARCHAR2 ,
164
165 p_new_version_number IN NUMBER ,
166
167 p_new_org_unit_cd IN VARCHAR2 ,
168
169 p_new_ou_start_dt IN DATE ,
170
171 p_new_spo_person_id IN NUMBER ,
172
173 p_new_spo_course_cd IN VARCHAR2 ,
174
175 p_new_spo_sequence_number IN NUMBER ,
176
177 p_new_sca_person_id IN NUMBER ,
178
179 p_new_sca_course_cd IN VARCHAR2 ,
180
181
182 p_message_name OUT NOCOPY VARCHAR2 )
183
184 RETURN NUMBER;
185
186
187
188 FUNCTION IGS_PR_INS_SSP_CMP_DTL(
189
190 p_rule_text IN VARCHAR2 ,
191
192 p_message_text IN VARCHAR2 ,
193
194 p_log_dt IN DATE ,
195
196 p_key IN VARCHAR2 ,
197
198 p_message_name OUT NOCOPY VARCHAR2 )
199
200 RETURN BOOLEAN ;
201
202 FUNCTION IGS_PR_upd_pen_clash(
203
204 p_person_id IN NUMBER ,
205
206 p_course_cd IN VARCHAR2 ,
207
208 p_spo_sequence_number IN NUMBER ,
209
210 p_application_type IN VARCHAR2 ,
211
212 p_message_text OUT NOCOPY VARCHAR2 ,
213
214 p_message_level OUT NOCOPY VARCHAR2 )
215
216 RETURN boolean ;
217
218
219
220 FUNCTION IGS_PR_UPD_SCA_STATUS(
221
222 p_person_id IN NUMBER ,
223
224 p_course_cd IN VARCHAR2 ,
225
226 p_current_progression_status IN VARCHAR2 ,
227
228 p_course_version IN NUMBER ,
229
230 p_message_name OUT NOCOPY VARCHAR2 )
231
232 RETURN boolean;
233
234
235
236 FUNCTION IGS_PR_upd_spo_pen(
237
238 p_person_id IN NUMBER ,
239
240 p_course_cd IN VARCHAR2 ,
241
242 p_spo_sequence_number IN NUMBER ,
243
244 p_authorising_person_id IN NUMBER ,
245
246 p_application_type IN VARCHAR2 ,
247
248 p_message_text OUT NOCOPY VARCHAR2 ,
249
250 p_message_level OUT NOCOPY VARCHAR2 )
251
252 RETURN boolean ;
253
254 FUNCTION IGS_PR_GET_SPO_EXPIRY(
255
256 p_person_id IN NUMBER ,
257
258 p_course_cd IN VARCHAR2 ,
259
260 p_sequence_number IN NUMBER ,
261
262 p_spo_expiry_dt IN DATE )
263
264 RETURN VARCHAR2;
265
266 FUNCTION get_antcp_compl_dt(
267
268 p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
269
270 p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE)
271
272 RETURN DATE;
273
274 END IGS_PR_GEN_006;