1 PACKAGE igs_ad_wf_001 AS
2 /* $Header: IGSADC0S.pls 120.5 2006/05/24 10:44:54 arvsrini ship $ */
3
4 PROCEDURE wf_adm_academic_index (
5 p_person_id IN NUMBER,
6 p_admission_appl_number IN NUMBER DEFAULT NULL,
7 p_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
8 p_sequence_number IN NUMBER DEFAULT NULL,
9 p_old_academic_index IN VARCHAR2 DEFAULT NULL,
10 p_new_academic_index IN VARCHAR2 DEFAULT NULL
11 );
12
13 PROCEDURE wf_raise_event(p_person_id IN NUMBER,
14 p_raised_for IN VARCHAR2,
15 p_admission_appl_number IN NUMBER DEFAULT NULL,
16 p_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
17 p_sequence_number IN NUMBER DEFAULT NULL,
18 p_old_outcome_status IN VARCHAR2 DEFAULT NULL,
19 p_new_outcome_status IN VARCHAR2 DEFAULT NULL
20 );
21
22 PROCEDURE transcript_entrd_event(
23 p_person_id IN NUMBER,
24 p_education_id IN NUMBER,
25 p_transcript_id IN NUMBER
26 );
27 PROCEDURE TESTSCORE_CRT_EVENT
28 (
29 P_TEST_RESULTS_ID IN NUMBER,
30 P_PERSON_ID IN NUMBER,
31 P_ACTIVE_IND IN VARCHAR2
32 );
33
34 PROCEDURE TESTSEG_CRT_EVENT
35 (
36 P_TEST_RESULTS_ID IN NUMBER,
37 P_TST_RSLT_DTLS_ID IN NUMBER,
38 P_TEST_SEGMENT_ID IN NUMBER,
39 P_PERSON_ID IN NUMBER
40 );
41 PROCEDURE TESTSCORE_UPD_EVENT
42 (
43 P_TEST_RESULTS_ID IN NUMBER,
44 P_PERSON_ID IN NUMBER,
45 P_ACTIVE_IND_NEW IN VARCHAR2,
46 P_ACTIVE_IND_OLD IN VARCHAR2,
47 P_ADMISSION_TEST_TYPE_NEW IN VARCHAR2,
48 P_ADMISSION_TEST_TYPE_OLD IN VARCHAR2,
49 P_GRADE_ID_NEW IN NUMBER,
50 P_GRADE_ID_OLD IN NUMBER,
51 P_COMP_TEST_SCORE_NEW IN NUMBER,
52 P_COMP_TEST_SCORE_OLD IN NUMBER
53 );
54 PROCEDURE TESTSEG_UPD_EVENT
55 (
56 P_TEST_RESULTS_ID IN NUMBER,
57 P_TST_RSLT_DTLS_ID IN NUMBER,
58 P_TEST_SEGMENT_ID IN NUMBER,
59 P_PERSON_ID IN NUMBER,
60 P_TEST_SCORE_NEW IN NUMBER,
61 P_TEST_SCORE_OLD IN NUMBER
62 );
63 PROCEDURE ACADHIST_CRT_EVENT
64 (
65 P_HZ_ACAD_HIST_ID IN NUMBER,
66 P_EDUCATION_ID IN NUMBER,
67 P_PERSON_ID IN NUMBER,
68 P_ACTIVE_IND IN VARCHAR2,
69 P_REQUIRED_IND IN VARCHAR2
70 );
71 PROCEDURE ACADHIST_UPD_EVENT
72 (
73 P_HZ_ACAD_HIST_ID IN NUMBER,
74 P_EDUCATION_ID IN NUMBER,
75 P_PERSON_ID IN NUMBER,
76 P_ACTIVE_IND_OLD IN VARCHAR2,
77 P_ACTIVE_IND_NEW IN VARCHAR2,
78 P_REQUIRED_IND_NEW IN VARCHAR2,
79 P_REQUIRED_IND_OLD IN VARCHAR2
80 );
81 PROCEDURE TRANSCRIPT_UPD_EVENT
82 (
83 P_TRANSCRIPT_ID IN NUMBER,
84 P_EDUCATION_ID IN NUMBER,
85 P_PERSON_ID IN NUMBER,
86 P_TRANSCRIPT_STATUS_OLD IN VARCHAR2,
87 P_TRANSCRIPT_STATUS_NEW IN VARCHAR2,
88 P_TRANSCRIPT_TYPE_OLD IN VARCHAR2,
89 P_TRANSCRIPT_TYPE_NEW IN VARCHAR2
90 );
91 PROCEDURE APPCOMP_STATUS_UPD_EVENT
92 (
93 P_PERSON_ID IN NUMBER,
94 P_ADMISSION_APPL_NUMBER IN NUMBER,
95 P_NOMINATED_COURSE_CD IN VARCHAR2,
96 P_SEQUENCE_NUMBER IN NUMBER,
97 P_ADM_DOC_STATUS_NEW IN VARCHAR2,
98 P_ADM_DOC_STATUS_OLD IN VARCHAR2
99 );
100 PROCEDURE ENTRY_QUAL_STATUS_UPD_EVENT
101 (
102 P_PERSON_ID IN NUMBER,
103 P_ADMISSION_APPL_NUMBER IN NUMBER,
104 P_NOMINATED_COURSE_CD IN VARCHAR2,
105 P_SEQUENCE_NUMBER IN NUMBER,
106 P_ADM_ENTRY_QUAL_STATUS_NEW IN VARCHAR2,
107 P_ADM_ENTRY_QUAL_STATUS_OLD IN VARCHAR2
108 );
109 PROCEDURE LATE_ADM_FEE_STATUS_UPD_EVENT
110 (
111 P_PERSON_ID IN NUMBER,
112 P_ADMISSION_APPL_NUMBER IN NUMBER,
113 P_NOMINATED_COURSE_CD IN VARCHAR2,
114 P_SEQUENCE_NUMBER IN NUMBER,
115 P_LATE_ADM_FEE_STATUS_NEW IN VARCHAR2,
116 P_LATE_ADM_FEE_STATUS_OLD IN VARCHAR2
117 );
118 PROCEDURE COND_OFFER_STATUS_UPD_EVENT
119 (
120 P_PERSON_ID IN NUMBER,
121 P_ADMISSION_APPL_NUMBER IN NUMBER,
122 P_NOMINATED_COURSE_CD IN VARCHAR2,
123 P_SEQUENCE_NUMBER IN NUMBER,
124 P_ADM_CNDTNL_OFFER_STATUS_NEW IN VARCHAR2,
125 P_ADM_CNDTNL_OFFER_STATUS_OLD IN VARCHAR2
126 );
127 PROCEDURE OFFER_DEFER_STATUS_UPD_EVENT
128 (
129 P_PERSON_ID IN NUMBER,
130 P_ADMISSION_APPL_NUMBER IN NUMBER,
131 P_NOMINATED_COURSE_CD IN VARCHAR2,
132 P_SEQUENCE_NUMBER IN NUMBER,
133 P_ADM_OFFER_DFRMNT_STATUS_NEW IN VARCHAR2,
134 P_ADM_OFFER_DFRMNT_STATUS_OLD IN VARCHAR2,
135 P_ADM_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
136 P_ADM_CI_SEQUENCE_NUMBER IN NUMBER DEFAULT NULL
137 );
138 PROCEDURE WAITLIST_STATUS_UPD_EVENT
139 (
140 P_PERSON_ID IN NUMBER,
141 P_ADMISSION_APPL_NUMBER IN NUMBER,
142 P_NOMINATED_COURSE_CD IN VARCHAR2,
143 P_SEQUENCE_NUMBER IN NUMBER,
144 P_WAITLIST_STATUS_NEW IN VARCHAR2,
145 P_WAITLIST_STATUS_OLD IN VARCHAR2
146 );
147
148
149 PROCEDURE CREATE_APPLICATION_EVENT
150 (
151 P_PERSON_ID IN NUMBER,
152 P_LOGIN_RESP IN VARCHAR2,
153 P_ACAD_CAL_TYPE IN VARCHAR2,
154 P_ACAD_CAL_SEQ_NUMBER IN NUMBER,
155 P_ADM_CAL_TYPE IN VARCHAR2,
156 P_ADM_CI_SEQUENCE_NUMBER IN NUMBER,
157 P_APPLICATION_TYPE IN OUT NOCOPY VARCHAR2,
158 P_LOCATION_CODE IN VARCHAR2,
159 P_PROGRAM_TYPE IN VARCHAR2,
160 P_SCH_APL_TO_ID IN NUMBER,
161 P_ATTENDANCE_TYPE IN VARCHAR2,
162 P_ATTENDANCE_MODE IN VARCHAR2,
163 P_OO_ATTRIBUTE_1 IN VARCHAR2,
164 P_OO_ATTRIBUTE_2 IN VARCHAR2,
165 P_OO_ATTRIBUTE_3 IN VARCHAR2,
166 P_OO_ATTRIBUTE_4 IN VARCHAR2,
167 P_OO_ATTRIBUTE_5 IN VARCHAR2,
168 P_OO_ATTRIBUTE_6 IN VARCHAR2,
169 P_OO_ATTRIBUTE_7 IN VARCHAR2,
170 P_OO_ATTRIBUTE_8 IN VARCHAR2,
171 P_OO_ATTRIBUTE_9 IN VARCHAR2,
172 P_OO_ATTRIBUTE_10 IN VARCHAR2,
173 P_CITIZENSHIP_RESIDENCY_IND IN VARCHAR2,
174 P_CIT_RES_ATTRIBUTE_1 IN VARCHAR2,
175 P_CIT_RES_ATTRIBUTE_2 IN VARCHAR2,
176 P_CIT_RES_ATTRIBUTE_3 IN VARCHAR2,
177 P_CIT_RES_ATTRIBUTE_4 IN VARCHAR2,
178 P_CIT_RES_ATTRIBUTE_5 IN VARCHAR2,
179 P_CIT_RES_ATTRIBUTE_6 IN VARCHAR2,
180 P_CIT_RES_ATTRIBUTE_7 IN VARCHAR2,
181 P_CIT_RES_ATTRIBUTE_8 IN VARCHAR2,
182 P_CIT_RES_ATTRIBUTE_9 IN VARCHAR2,
183 P_CIT_RES_ATTRIBUTE_10 IN VARCHAR2,
184 P_STATE_OF_RES_TYPE_CODE IN VARCHAR2,
185 P_DOM_ATTRIBUTE_1 IN VARCHAR2,
186 P_DOM_ATTRIBUTE_2 IN VARCHAR2,
187 P_DOM_ATTRIBUTE_3 IN VARCHAR2,
188 P_DOM_ATTRIBUTE_4 IN VARCHAR2,
189 P_DOM_ATTRIBUTE_5 IN VARCHAR2,
190 P_DOM_ATTRIBUTE_6 IN VARCHAR2,
191 P_DOM_ATTRIBUTE_7 IN VARCHAR2,
192 P_DOM_ATTRIBUTE_8 IN VARCHAR2,
193 P_DOM_ATTRIBUTE_9 IN VARCHAR2,
194 P_DOM_ATTRIBUTE_10 IN VARCHAR2,
195 P_GEN_ATTRIBUTE_1 IN VARCHAR2,
196 P_GEN_ATTRIBUTE_2 IN VARCHAR2,
197 P_GEN_ATTRIBUTE_3 IN VARCHAR2,
198 P_GEN_ATTRIBUTE_4 IN VARCHAR2,
199 P_GEN_ATTRIBUTE_5 IN VARCHAR2,
200 P_GEN_ATTRIBUTE_6 IN VARCHAR2,
201 P_GEN_ATTRIBUTE_7 IN VARCHAR2,
202 P_GEN_ATTRIBUTE_8 IN VARCHAR2,
203 P_GEN_ATTRIBUTE_9 IN VARCHAR2,
204 P_GEN_ATTRIBUTE_10 IN VARCHAR2,
205 P_GEN_ATTRIBUTE_11 IN VARCHAR2,
206 P_GEN_ATTRIBUTE_12 IN VARCHAR2,
207 P_GEN_ATTRIBUTE_13 IN VARCHAR2,
208 P_GEN_ATTRIBUTE_14 IN VARCHAR2,
209 P_GEN_ATTRIBUTE_15 IN VARCHAR2,
210 P_GEN_ATTRIBUTE_16 IN VARCHAR2,
211 P_GEN_ATTRIBUTE_17 IN VARCHAR2,
212 P_GEN_ATTRIBUTE_18 IN VARCHAR2,
213 P_GEN_ATTRIBUTE_19 IN VARCHAR2,
214 P_GEN_ATTRIBUTE_20 IN VARCHAR2,
215 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
216 X_MSG_COUNT OUT NOCOPY NUMBER,
217 X_MSG_DATA OUT NOCOPY VARCHAR2,
218 X_SS_ADM_APPL_ID OUT NOCOPY NUMBER
219 ) ;
220
221 PROCEDURE ASSIGN_REQUIRMENT_DONE_EVENT
222 (
223 P_PERSON_ID IN NUMBER,
224 P_ADMISSION_APPL_NUMBER IN NUMBER,
225 P_NOMINATED_COURSE_CD IN VARCHAR2,
226 P_SEQUENCE_NUMBER IN NUMBER
227 );
228
229 PROCEDURE FEE_PAYMENT_CRT_EVENT
230 (
231 P_PERSON_ID IN NUMBER,
232 P_ADMISSION_APPL_NUMBER IN NUMBER,
233 P_APP_REQ_ID IN NUMBER,
234 P_APPLICANT_FEE_TYPE IN NUMBER,
235 P_APPLICANT_FEE_STATUS IN NUMBER
236 );
237
238 PROCEDURE FEE_PAYMENT_UPD_EVENT
239 (
240 P_PERSON_ID IN NUMBER,
241 P_ADMISSION_APPL_NUMBER IN NUMBER,
242 P_APP_REQ_ID IN NUMBER,
243 P_APPLICANT_FEE_TYPE IN NUMBER,
244 P_APPLICANT_FEE_STATUS_NEW IN NUMBER,
245 P_APPLICANT_FEE_STATUS_OLD IN NUMBER
246 );
247
248 PROCEDURE APP_PRCOC_STATUS_UPD_EVENT
249 (
250 P_PERSON_ID IN NUMBER,
251 P_ADMISSION_APPL_NUMBER IN NUMBER,
252 P_ADM_APPL_STATUS_NEW IN VARCHAR2,
253 P_ADM_APPL_STATUS_OLD IN VARCHAR2
254 );
255
256 PROCEDURE APP_INSTANCE_STATUS_UPD_EVENT
257 (
258 P_PERSON_ID IN NUMBER,
259 P_ADMISSION_APPL_NUMBER IN NUMBER,
260 P_NOMINATED_COURSE_CD IN VARCHAR2,
261 P_SEQUENCE_NUMBER IN NUMBER,
262 P_APPL_INST_STATUS_NEW IN VARCHAR2,
263 P_APPL_INST_STATUS_OLD IN VARCHAR2
264 );
265
266 PROCEDURE APP_RECONSIDER_REQUEST_EVENT
267 (
268 P_PERSON_ID IN NUMBER,
269 P_ADMISSION_APPL_NUMBER IN NUMBER,
270 P_NOMINATED_COURSE_CD IN VARCHAR2,
271 P_SEQUENCE_NUMBER IN NUMBER,
272 P_ADM_OUTCOME_STATUS IN VARCHAR2,
273 P_ADM_OFFER_RESP_STATUS IN VARCHAR2
274 );
275
276 PROCEDURE APP_RECON_FUT_REQ_UPD_EVENT
277 (
278 P_PERSON_ID IN NUMBER,
279 P_ADMISSION_APPL_NUMBER IN NUMBER,
280 P_NOMINATED_COURSE_CD IN VARCHAR2,
281 P_SEQUENCE_NUMBER IN NUMBER,
282 P_ADM_OUTCOME_STATUS IN VARCHAR2,
283 P_ADM_OFFER_RESP_STATUS IN VARCHAR2,
284 P_FUTURE_ADM_CAL_TYPE_NEW IN VARCHAR2,
285 P_FUTURE_ADM_CAL_TYPE_OLD IN VARCHAR2,
286 P_FUTURE_ADM_CI_SEQU_NUM_NEW IN NUMBER,
287 P_FUTURE_ADM_CI_SEQU_NUM_OLD IN NUMBER,
288 P_FUTURE_ACAD_CAL_TYPE_NEW IN VARCHAR2,
289 P_FUTURE_ACAD_CAL_TYPE_OLD IN VARCHAR2,
290 P_FUTURE_ACAD_CI_SEQU_NUM_NEW IN NUMBER,
291 P_FUTURE_ACAD_CI_SEQ_NUM_OLD IN NUMBER,
292 P_REQ_FOR_RECONSIDERATION_IND IN VARCHAR2
293 );
294
295 PROCEDURE APP_INST_QUALIFYING_CODE_EVENT
296 (
297 P_PERSON_ID IN NUMBER,
298 P_ADMISSION_APPL_NUMBER IN NUMBER,
299 P_NOMINATED_COURSE_CD IN VARCHAR2,
300 P_SEQUENCE_NUMBER IN NUMBER,
301 P_QUALIFYING_TYPE_CODE IN VARCHAR2,
302 P_QUALIFYING_CODE_ID_NEW IN NUMBER,
303 P_QUALIFYING_CODE_ID_OLD IN NUMBER,
304 P_QUALIFYING_VALUE_NEW IN VARCHAR2,
305 P_QUALIFYING_VALUE_OLD IN VARCHAR2
306 );
307
308
309 PROCEDURE PRE_SUBMIT_EVENT
310 (
311 P_PERSON_ID IN NUMBER,
312 P_SS_ADM_APPL_ID IN NUMBER,
313 P_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
314 P_MSG_DATA OUT NOCOPY VARCHAR2
315 );
316
317 END igs_ad_wf_001;