1 PACKAGE BODY igs_ad_uhk_pre_create_appl_pkg AS
2 /* $Header: IGSADD3B.pls 120.2 2006/05/24 10:54:10 arvsrini noship $ */
3
4 --
5 -- User Hook - which can be customisable by the customer.
6 --
7
8 PROCEDURE derive_app_type (
9 p_person_id in number,
10 p_login_resp in varchar2,
11 p_acad_cal_type in varchar2,
12 p_acad_cal_seq_number in number,
13 p_adm_cal_type in varchar2,
14 p_adm_ci_sequence_number in number,
15 p_application_type in out nocopy varchar2,
16 p_location_code in out nocopy varchar2,
17 p_program_type in out nocopy varchar2,
18 p_sch_apl_to_id in out nocopy number,
19 p_attendance_type in out nocopy varchar2,
20 p_attendance_mode in out nocopy varchar2,
21 p_oo_attribute_1 in out nocopy varchar2,
22 p_oo_attribute_2 in out nocopy varchar2,
23 p_oo_attribute_3 in out nocopy varchar2,
24 p_oo_attribute_4 in out nocopy varchar2,
25 p_oo_attribute_5 in out nocopy varchar2,
26 p_oo_attribute_6 in out nocopy varchar2,
27 p_oo_attribute_7 in out nocopy varchar2,
28 p_oo_attribute_8 in out nocopy varchar2,
29 p_oo_attribute_9 in out nocopy varchar2,
30 p_oo_attribute_10 in out nocopy varchar2,
31 p_citizenship_residency_ind in out nocopy varchar2,
32 p_cit_res_attribute_1 in out nocopy varchar2,
33 p_cit_res_attribute_2 in out nocopy varchar2,
34 p_cit_res_attribute_3 in out nocopy varchar2,
35 p_cit_res_attribute_4 in out nocopy varchar2,
36 p_cit_res_attribute_5 in out nocopy varchar2,
37 p_cit_res_attribute_6 in out nocopy varchar2,
38 p_cit_res_attribute_7 in out nocopy varchar2,
39 p_cit_res_attribute_8 in out nocopy varchar2,
40 p_cit_res_attribute_9 in out nocopy varchar2,
41 p_cit_res_attribute_10 in out nocopy varchar2,
42 p_state_of_res_type_code in out nocopy varchar2,
43 p_dom_attribute_1 in out nocopy varchar2,
44 p_dom_attribute_2 in out nocopy varchar2,
45 p_dom_attribute_3 in out nocopy varchar2,
46 p_dom_attribute_4 in out nocopy varchar2,
47 p_dom_attribute_5 in out nocopy varchar2,
48 p_dom_attribute_6 in out nocopy varchar2,
49 p_dom_attribute_7 in out nocopy varchar2,
50 p_dom_attribute_8 in out nocopy varchar2,
51 p_dom_attribute_9 in out nocopy varchar2,
52 p_dom_attribute_10 in out nocopy varchar2,
53 p_gen_attribute_1 in out nocopy varchar2,
54 p_gen_attribute_2 in out nocopy varchar2,
55 p_gen_attribute_3 in out nocopy varchar2,
56 p_gen_attribute_4 in out nocopy varchar2,
57 p_gen_attribute_5 in out nocopy varchar2,
58 p_gen_attribute_6 in out nocopy varchar2,
59 p_gen_attribute_7 in out nocopy varchar2,
60 p_gen_attribute_8 in out nocopy varchar2,
61 p_gen_attribute_9 in out nocopy varchar2,
62 p_gen_attribute_10 in out nocopy varchar2,
63 p_gen_attribute_11 in out nocopy varchar2,
64 p_gen_attribute_12 in out nocopy varchar2,
65 p_gen_attribute_13 in out nocopy varchar2,
66 p_gen_attribute_14 in out nocopy varchar2,
67 p_gen_attribute_15 in out nocopy varchar2,
68 p_gen_attribute_16 in out nocopy varchar2,
69 p_gen_attribute_17 in out nocopy varchar2,
70 p_gen_attribute_18 in out nocopy varchar2,
71 p_gen_attribute_19 in out nocopy varchar2,
72 p_gen_attribute_20 in out nocopy varchar2,
73 p_entry_status in out nocopy varchar2,
74 p_entry_level in out nocopy varchar2,
75 p_spcl_gr1 in out nocopy varchar2,
76 p_spcl_gr2 in out nocopy varchar2,
77 p_apply_for_finaid in out nocopy varchar2,
78 p_finaid_apply_date in out nocopy date,
79 p_appl_date in out nocopy date,
80 p_attribute_category in out nocopy varchar2,
81 p_attribute1 in out nocopy varchar2,
82 p_attribute2 in out nocopy varchar2,
83 p_attribute3 in out nocopy varchar2,
84 p_attribute4 in out nocopy varchar2,
85 p_attribute5 in out nocopy varchar2,
86 p_attribute6 in out nocopy varchar2,
87 p_attribute7 in out nocopy varchar2,
88 p_attribute8 in out nocopy varchar2,
89 p_attribute9 in out nocopy varchar2,
90 p_attribute10 in out nocopy varchar2,
91 p_attribute11 in out nocopy varchar2,
92 p_attribute12 in out nocopy varchar2,
93 p_attribute13 in out nocopy varchar2,
94 p_attribute14 in out nocopy varchar2,
95 p_attribute15 in out nocopy varchar2,
96 p_attribute16 in out nocopy varchar2,
97 p_attribute17 in out nocopy varchar2,
98 p_attribute18 in out nocopy varchar2,
99 p_attribute19 in out nocopy varchar2,
100 p_attribute20 in out nocopy varchar2,
101 p_attribute21 in out nocopy varchar2,
102 p_attribute22 in out nocopy varchar2,
103 p_attribute23 in out nocopy varchar2,
104 p_attribute24 in out nocopy varchar2,
105 p_attribute25 in out nocopy varchar2,
106 p_attribute26 in out nocopy varchar2,
107 p_attribute27 in out nocopy varchar2,
108 p_attribute28 in out nocopy varchar2,
109 p_attribute29 in out nocopy varchar2,
110 p_attribute30 in out nocopy varchar2,
111 p_attribute31 in out nocopy varchar2,
112 p_attribute32 in out nocopy varchar2,
113 p_attribute33 in out nocopy varchar2,
114 p_attribute34 in out nocopy varchar2,
115 p_attribute35 in out nocopy varchar2,
116 p_attribute36 in out nocopy varchar2,
117 p_attribute37 in out nocopy varchar2,
118 p_attribute38 in out nocopy varchar2,
119 p_attribute39 in out nocopy varchar2,
120 p_attribute40 in out nocopy varchar2
121 )
122
123 -- This procedure would be called from the workflow executed when an Applicant
124 -- clicks on continue button in Create Application Page to create an Application.
125 -- This procedure would be primally customised for deriving Application Type to create
126 -- Unsubmitted Application form the information passed through parameters of this
127 -- procedure. There are other parameters which are of in out nocopy type which could be
128 -- updated according to the customer needs ( for eg customer might provide values
129 -- for Application Instance DFF). The updated value will be used while creating
130 -- the Unsubmitted Application.
131
132 -- Who When What
133 -- Akadam 7/7/2005 Created the procedure
134
135 --
136 -- Parameters Description:
137 --
138
139 -- p_person_id Applicant Person Identifier
140 -- p_login_resp Responsibility identifier :- Could be 'ADMIN' for Administrator responsibilities, 'APPLICANT' and 'STUDENT' for respective Self Service Responsibilities.
141 -- p_acad_cal_type Calendar type relating to the academic period
142 -- p_acad_cal_seq_number Sequence number which uniquely identifies the academic period calendar instance
143 -- p_adm_cal_type Calendar type relating to the admission period
144 -- p_adm_ci_sequence_number Sequence number which uniquely identifies the admission period calendar instance
145 -- p_application_type Application Type
146 -- p_location_code Offering Option Location Code
147 -- p_program_type Institution-defined program type. Program type indicates the type of higher education program
148 -- p_sch_apl_to_id School Applying To identifier
149 -- p_attendance_type Offering Option Attendance Type
150 -- p_attendance_mode Offering Option Attendance Mode
151 -- p_oo_attribute_1 Offering Option custom attribute
152 -- p_oo_attribute_2 Offering Option custom attribute
153 -- p_oo_attribute_3 Offering Option custom attribute
154 -- p_oo_attribute_4 Offering Option custom attribute
155 -- p_oo_attribute_5 Offering Option custom attribute
156 -- p_oo_attribute_6 Offering Option custom attribute
157 -- p_oo_attribute_7 Offering Option custom attribute
158 -- p_oo_attribute_8 Offering Option custom attribute
159 -- p_oo_attribute_9 Offering Option custom attribute
160 -- p_oo_attribute_10 Offering Option custom attribute
161 -- p_citizenship_residency_ind Citizenship/Residency Indicator
162 -- p_cit_res_attribute_1 Citizenship/Residency custom attribute
163 -- p_cit_res_attribute_2 Citizenship/Residency custom attribute
164 -- p_cit_res_attribute_3 Citizenship/Residency custom attribute
165 -- p_cit_res_attribute_4 Citizenship/Residency custom attribute
166 -- p_cit_res_attribute_5 Citizenship/Residency custom attribute
167 -- p_cit_res_attribute_6 Citizenship/Residency custom attribute
168 -- p_cit_res_attribute_7 Citizenship/Residency custom attribute
169 -- p_cit_res_attribute_8 Citizenship/Residency custom attribute
170 -- p_cit_res_attribute_9 Citizenship/Residency custom attribute
171 -- p_cit_res_attribute_10 Citizenship/Residency custom attribute
172 -- p_state_of_res_type_code Indicates code for state
173 -- p_dom_attribute_1 Domicile custom attribute
174 -- p_dom_attribute_2 Domicile custom attribute
175 -- p_dom_attribute_3 Domicile custom attribute
176 -- p_dom_attribute_4 Domicile custom attribute
177 -- p_dom_attribute_5 Domicile custom attribute
178 -- p_dom_attribute_6 Domicile custom attribute
179 -- p_dom_attribute_7 Domicile custom attribute
180 -- p_dom_attribute_8 Domicile custom attribute
181 -- p_dom_attribute_9 Domicile custom attribute
182 -- p_dom_attribute_10 Domicile custom attribute
183 -- p_gen_attribute_1 Generic custom attribute
184 -- p_gen_attribute_2 Generic custom attribute
185 -- p_gen_attribute_3 Generic custom attribute
186 -- p_gen_attribute_4 Generic custom attribute
187 -- p_gen_attribute_5 Generic custom attribute
188 -- p_gen_attribute_6 Generic custom attribute
189 -- p_gen_attribute_7 Generic custom attribute
190 -- p_gen_attribute_8 Generic custom attribute
191 -- p_gen_attribute_9 Generic custom attribute
192 -- p_gen_attribute_10 Generic custom attribute
193 -- p_gen_attribute_11 Generic custom attribute
194 -- p_gen_attribute_12 Generic custom attribute
195 -- p_gen_attribute_13 Generic custom attribute
196 -- p_gen_attribute_14 Generic custom attribute
197 -- p_gen_attribute_15 Generic custom attribute
198 -- p_gen_attribute_16 Generic custom attribute
199 -- p_gen_attribute_17 Generic custom attribute
200 -- p_gen_attribute_18 Generic custom attribute
201 -- p_gen_attribute_19 Generic custom attribute
202 -- p_gen_attribute_20 Generic custom attribute
203 -- p_entry_status Entry Status
204 -- p_entry_level Entry Level
205 -- p_spcl_gr1 Special Group 1
206 -- p_spcl_gr2 Special Group 2
207 -- p_apply_for_finaid Apply For Financial Aid Indicator
208 -- p_finaid_apply_date Financial Aid Apply Date
209 -- p_appl_date Application Date
210 -- p_attribute_category Descriptive flex field qualifier.
211 -- p_attribute1 Standard Attribute Column. Meant for descriptive flex field.
212 -- p_attribute2 Standard Attribute Column. Meant for descriptive flex field.
213 -- p_attribute3 Standard Attribute Column. Meant for descriptive flex field.
214 -- p_attribute4 Standard Attribute Column. Meant for descriptive flex field.
215 -- p_attribute5 Standard Attribute Column. Meant for descriptive flex field.
216 -- p_attribute6 Standard Attribute Column. Meant for descriptive flex field.
217 -- p_attribute7 Standard Attribute Column. Meant for descriptive flex field.
218 -- p_attribute8 Standard Attribute Column. Meant for descriptive flex field.
219 -- p_attribute9 Standard Attribute Column. Meant for descriptive flex field.
220 -- p_attribute10 Standard Attribute Column. Meant for descriptive flex field.
221 -- p_attribute11 Standard Attribute Column. Meant for descriptive flex field.
222 -- p_attribute12 Standard Attribute Column. Meant for descriptive flex field.
223 -- p_attribute13 Standard Attribute Column. Meant for descriptive flex field.
224 -- p_attribute14 Standard Attribute Column. Meant for descriptive flex field.
225 -- p_attribute15 Standard Attribute Column. Meant for descriptive flex field.
229 -- p_attribute19 Standard Attribute Column. Meant for descriptive flex field.
226 -- p_attribute16 Standard Attribute Column. Meant for descriptive flex field.
227 -- p_attribute17 Standard Attribute Column. Meant for descriptive flex field.
228 -- p_attribute18 Standard Attribute Column. Meant for descriptive flex field.
230 -- p_attribute20 Standard Attribute Column. Meant for descriptive flex field.
231 -- p_attribute21 Standard Attribute Column. Meant for descriptive flex field.
232 -- p_attribute22 Standard Attribute Column. Meant for descriptive flex field.
233 -- p_attribute23 Standard Attribute Column. Meant for descriptive flex field.
234 -- p_attribute24 Standard Attribute Column. Meant for descriptive flex field.
235 -- p_attribute25 Standard Attribute Column. Meant for descriptive flex field.
236 -- p_attribute26 Standard Attribute Column. Meant for descriptive flex field.
237 -- p_attribute27 Standard Attribute Column. Meant for descriptive flex field.
238 -- p_attribute28 Standard Attribute Column. Meant for descriptive flex field.
239 -- p_attribute29 Standard Attribute Column. Meant for descriptive flex field.
240 -- p_attribute30 Standard Attribute Column. Meant for descriptive flex field.
241 -- p_attribute31 Standard Attribute Column. Meant for descriptive flex field.
242 -- p_attribute32 Standard Attribute Column. Meant for descriptive flex field.
243 -- p_attribute33 Standard Attribute Column. Meant for descriptive flex field.
244 -- p_attribute34 Standard Attribute Column. Meant for descriptive flex field.
245 -- p_attribute35 Standard Attribute Column. Meant for descriptive flex field.
246 -- p_attribute36 Standard Attribute Column. Meant for descriptive flex field.
247 -- p_attribute37 Standard Attribute Column. Meant for descriptive flex field.
248 -- p_attribute38 Standard Attribute Column. Meant for descriptive flex field.
249 -- p_attribute39 Standard Attribute Column. Meant for descriptive flex field.
250 -- p_attribute40 Standard Attribute Column. Meant for descriptive flex field.
251
252 IS
253 BEGIN
254
255 -- PUT YOUR CODE HERE
256 RETURN ;
257
258 EXCEPTION
259 WHEN OTHERS THEN
260
261 FND_MESSAGE.SET_NAME ('IGS','IGS_AD_UH_UNHAND_EXCEPTION');
262 FND_MESSAGE.SET_TOKEN ('OBJECTNAME','IGS_AD_UHK_PRE_CREATE_APPL_PKG.DERIVE_APP_TYPE');
263 IGS_GE_MSG_STACK.ADD;
264
265 APP_EXCEPTION.RAISE_EXCEPTION;
266
267 END derive_app_type ;
268
269 PROCEDURE derive_app_fee (
270 p_person_id in number,
271 p_login_resp in varchar2,
272 p_acad_cal_type in varchar2,
273 p_acad_cal_seq_number in number,
274 p_adm_cal_type in varchar2,
275 p_adm_ci_sequence_number in number,
276 p_application_type in out nocopy varchar2,
277 p_application_fee_amount in out nocopy number,
278 p_location_code in out nocopy varchar2,
279 p_program_type in out nocopy varchar2,
280 p_sch_apl_to_id in out nocopy number,
281 p_attendance_type in out nocopy varchar2,
282 p_attendance_mode in out nocopy varchar2,
283 p_oo_attribute_1 in out nocopy varchar2,
284 p_oo_attribute_2 in out nocopy varchar2,
285 p_oo_attribute_3 in out nocopy varchar2,
286 p_oo_attribute_4 in out nocopy varchar2,
287 p_oo_attribute_5 in out nocopy varchar2,
288 p_oo_attribute_6 in out nocopy varchar2,
289 p_oo_attribute_7 in out nocopy varchar2,
290 p_oo_attribute_8 in out nocopy varchar2,
291 p_oo_attribute_9 in out nocopy varchar2,
292 p_oo_attribute_10 in out nocopy varchar2,
293 p_citizenship_residency_ind in out nocopy varchar2,
294 p_cit_res_attribute_1 in out nocopy varchar2,
295 p_cit_res_attribute_2 in out nocopy varchar2,
296 p_cit_res_attribute_3 in out nocopy varchar2,
297 p_cit_res_attribute_4 in out nocopy varchar2,
298 p_cit_res_attribute_5 in out nocopy varchar2,
299 p_cit_res_attribute_6 in out nocopy varchar2,
300 p_cit_res_attribute_7 in out nocopy varchar2,
301 p_cit_res_attribute_8 in out nocopy varchar2,
302 p_cit_res_attribute_9 in out nocopy varchar2,
303 p_cit_res_attribute_10 in out nocopy varchar2,
304 p_state_of_res_type_code in out nocopy varchar2,
305 p_dom_attribute_1 in out nocopy varchar2,
306 p_dom_attribute_2 in out nocopy varchar2,
307 p_dom_attribute_3 in out nocopy varchar2,
308 p_dom_attribute_4 in out nocopy varchar2,
309 p_dom_attribute_5 in out nocopy varchar2,
310 p_dom_attribute_6 in out nocopy varchar2,
311 p_dom_attribute_7 in out nocopy varchar2,
312 p_dom_attribute_8 in out nocopy varchar2,
313 p_dom_attribute_9 in out nocopy varchar2,
314 p_dom_attribute_10 in out nocopy varchar2,
315 p_gen_attribute_1 in out nocopy varchar2,
316 p_gen_attribute_2 in out nocopy varchar2,
317 p_gen_attribute_3 in out nocopy varchar2,
318 p_gen_attribute_4 in out nocopy varchar2,
319 p_gen_attribute_5 in out nocopy varchar2,
320 p_gen_attribute_6 in out nocopy varchar2,
321 p_gen_attribute_7 in out nocopy varchar2,
322 p_gen_attribute_8 in out nocopy varchar2,
323 p_gen_attribute_9 in out nocopy varchar2,
324 p_gen_attribute_10 in out nocopy varchar2,
325 p_gen_attribute_11 in out nocopy varchar2,
326 p_gen_attribute_12 in out nocopy varchar2,
327 p_gen_attribute_13 in out nocopy varchar2,
328 p_gen_attribute_14 in out nocopy varchar2,
329 p_gen_attribute_15 in out nocopy varchar2,
330 p_gen_attribute_16 in out nocopy varchar2,
331 p_gen_attribute_17 in out nocopy varchar2,
332 p_gen_attribute_18 in out nocopy varchar2,
336 p_entry_level in out nocopy varchar2,
333 p_gen_attribute_19 in out nocopy varchar2,
334 p_gen_attribute_20 in out nocopy varchar2,
335 p_entry_status in out nocopy varchar2,
337 p_spcl_gr1 in out nocopy varchar2,
338 p_spcl_gr2 in out nocopy varchar2,
339 p_apply_for_finaid in out nocopy varchar2,
340 p_finaid_apply_date in out nocopy date,
341 p_appl_date in out nocopy date,
342 p_attribute_category in out nocopy varchar2,
343 p_attribute1 in out nocopy varchar2,
344 p_attribute2 in out nocopy varchar2,
345 p_attribute3 in out nocopy varchar2,
346 p_attribute4 in out nocopy varchar2,
347 p_attribute5 in out nocopy varchar2,
348 p_attribute6 in out nocopy varchar2,
349 p_attribute7 in out nocopy varchar2,
350 p_attribute8 in out nocopy varchar2,
351 p_attribute9 in out nocopy varchar2,
352 p_attribute10 in out nocopy varchar2,
353 p_attribute11 in out nocopy varchar2,
354 p_attribute12 in out nocopy varchar2,
355 p_attribute13 in out nocopy varchar2,
356 p_attribute14 in out nocopy varchar2,
357 p_attribute15 in out nocopy varchar2,
358 p_attribute16 in out nocopy varchar2,
359 p_attribute17 in out nocopy varchar2,
360 p_attribute18 in out nocopy varchar2,
361 p_attribute19 in out nocopy varchar2,
362 p_attribute20 in out nocopy varchar2,
363 p_attribute21 in out nocopy varchar2,
364 p_attribute22 in out nocopy varchar2,
365 p_attribute23 in out nocopy varchar2,
366 p_attribute24 in out nocopy varchar2,
367 p_attribute25 in out nocopy varchar2,
368 p_attribute26 in out nocopy varchar2,
369 p_attribute27 in out nocopy varchar2,
370 p_attribute28 in out nocopy varchar2,
371 p_attribute29 in out nocopy varchar2,
372 p_attribute30 in out nocopy varchar2,
373 p_attribute31 in out nocopy varchar2,
374 p_attribute32 in out nocopy varchar2,
375 p_attribute33 in out nocopy varchar2,
376 p_attribute34 in out nocopy varchar2,
377 p_attribute35 in out nocopy varchar2,
378 p_attribute36 in out nocopy varchar2,
379 p_attribute37 in out nocopy varchar2,
380 p_attribute38 in out nocopy varchar2,
381 p_attribute39 in out nocopy varchar2,
382 p_attribute40 in out nocopy varchar2
383 )
384
385 -- This procedure would be called from the workflow executed when an Applicant
386 -- clicks on continue button in Create Application Page to create an Application.
387 -- And this procedure would be called after the 'derive_app_type' User Hook is called.
388 -- This procedure would be primally customised for deriving Application Fee Amount
389 -- for the Unsubmitted Application to be created after Application Type is derived.
390 -- There are other parameters which are of in out nocopy type which could be
391 -- updated according to the customer needs ( for eg customer might provide values
392 -- for Application Instance DFF). The updated value will be used while creating
393 -- the Unsubmitted Application.
394
395 -- Who When What
396 -- Akadam 7/7/2005 Created the procedure
397
398 --
399 -- Parameters Description:
400 --
401
402 -- p_person_id Applicant Person Identifier
403 -- p_login_resp Responsibility identifier :- Could be 'ADMIN' for Administrator responsibilities, 'APPLICANT' and 'STUDENT' for respective Self Service Responsibilities.
404 -- p_acad_cal_type Calendar type relating to the academic period
405 -- p_acad_cal_seq_number Sequence number which uniquely identifies the academic period calendar instance
406 -- p_adm_cal_type Calendar type relating to the admission period
407 -- p_adm_ci_sequence_number Sequence number which uniquely identifies the admission period calendar instance
408 -- p_application_type Application Type
409 -- p_application_fee_amount Application Fee Amount
410 -- p_location_code Offering Option Location Code
411 -- p_program_type Institution-defined program type. Program type indicates the type of higher education program
412 -- p_sch_apl_to_id School Applying To identifier
413 -- p_attendance_type Offering Option Attendance Type
414 -- p_attendance_mode Offering Option Attendance Mode
415 -- p_oo_attribute_1 Offering Option custom attribute
416 -- p_oo_attribute_2 Offering Option custom attribute
417 -- p_oo_attribute_3 Offering Option custom attribute
418 -- p_oo_attribute_4 Offering Option custom attribute
419 -- p_oo_attribute_5 Offering Option custom attribute
420 -- p_oo_attribute_6 Offering Option custom attribute
421 -- p_oo_attribute_7 Offering Option custom attribute
422 -- p_oo_attribute_8 Offering Option custom attribute
423 -- p_oo_attribute_9 Offering Option custom attribute
424 -- p_oo_attribute_10 Offering Option custom attribute
425 -- p_citizenship_residency_ind Citizenship/Residency Indicator
426 -- p_cit_res_attribute_1 Citizenship/Residency custom attribute
427 -- p_cit_res_attribute_2 Citizenship/Residency custom attribute
428 -- p_cit_res_attribute_3 Citizenship/Residency custom attribute
429 -- p_cit_res_attribute_4 Citizenship/Residency custom attribute
430 -- p_cit_res_attribute_5 Citizenship/Residency custom attribute
431 -- p_cit_res_attribute_6 Citizenship/Residency custom attribute
432 -- p_cit_res_attribute_7 Citizenship/Residency custom attribute
433 -- p_cit_res_attribute_8 Citizenship/Residency custom attribute
434 -- p_cit_res_attribute_9 Citizenship/Residency custom attribute
435 -- p_cit_res_attribute_10 Citizenship/Residency custom attribute
439 -- p_dom_attribute_3 Domicile custom attribute
436 -- p_state_of_res_type_code Indicates code for state
437 -- p_dom_attribute_1 Domicile custom attribute
438 -- p_dom_attribute_2 Domicile custom attribute
440 -- p_dom_attribute_4 Domicile custom attribute
441 -- p_dom_attribute_5 Domicile custom attribute
442 -- p_dom_attribute_6 Domicile custom attribute
443 -- p_dom_attribute_7 Domicile custom attribute
444 -- p_dom_attribute_8 Domicile custom attribute
445 -- p_dom_attribute_9 Domicile custom attribute
446 -- p_dom_attribute_10 Domicile custom attribute
447 -- p_gen_attribute_1 Generic custom attribute
448 -- p_gen_attribute_2 Generic custom attribute
449 -- p_gen_attribute_3 Generic custom attribute
450 -- p_gen_attribute_4 Generic custom attribute
451 -- p_gen_attribute_5 Generic custom attribute
452 -- p_gen_attribute_6 Generic custom attribute
453 -- p_gen_attribute_7 Generic custom attribute
454 -- p_gen_attribute_8 Generic custom attribute
455 -- p_gen_attribute_9 Generic custom attribute
456 -- p_gen_attribute_10 Generic custom attribute
457 -- p_gen_attribute_11 Generic custom attribute
458 -- p_gen_attribute_12 Generic custom attribute
459 -- p_gen_attribute_13 Generic custom attribute
460 -- p_gen_attribute_14 Generic custom attribute
461 -- p_gen_attribute_15 Generic custom attribute
462 -- p_gen_attribute_16 Generic custom attribute
463 -- p_gen_attribute_17 Generic custom attribute
464 -- p_gen_attribute_18 Generic custom attribute
465 -- p_gen_attribute_19 Generic custom attribute
466 -- p_gen_attribute_20 Generic custom attribute
467 -- p_entry_status Entry Status
468 -- p_entry_level Entry Level
469 -- p_spcl_gr1 Special Group 1
470 -- p_spcl_gr2 Special Group 2
471 -- p_apply_for_finaid Apply For Financial Aid Indicator
472 -- p_finaid_apply_date Financial Aid Apply Date
473 -- p_appl_date Application Date
474 -- p_attribute_category Descriptive flex field qualifier.
475 -- p_attribute1 Standard Attribute Column. Meant for descriptive flex field.
476 -- p_attribute2 Standard Attribute Column. Meant for descriptive flex field.
477 -- p_attribute3 Standard Attribute Column. Meant for descriptive flex field.
478 -- p_attribute4 Standard Attribute Column. Meant for descriptive flex field.
479 -- p_attribute5 Standard Attribute Column. Meant for descriptive flex field.
480 -- p_attribute6 Standard Attribute Column. Meant for descriptive flex field.
481 -- p_attribute7 Standard Attribute Column. Meant for descriptive flex field.
482 -- p_attribute8 Standard Attribute Column. Meant for descriptive flex field.
483 -- p_attribute9 Standard Attribute Column. Meant for descriptive flex field.
484 -- p_attribute10 Standard Attribute Column. Meant for descriptive flex field.
485 -- p_attribute11 Standard Attribute Column. Meant for descriptive flex field.
486 -- p_attribute12 Standard Attribute Column. Meant for descriptive flex field.
487 -- p_attribute13 Standard Attribute Column. Meant for descriptive flex field.
488 -- p_attribute14 Standard Attribute Column. Meant for descriptive flex field.
489 -- p_attribute15 Standard Attribute Column. Meant for descriptive flex field.
490 -- p_attribute16 Standard Attribute Column. Meant for descriptive flex field.
491 -- p_attribute17 Standard Attribute Column. Meant for descriptive flex field.
492 -- p_attribute18 Standard Attribute Column. Meant for descriptive flex field.
493 -- p_attribute19 Standard Attribute Column. Meant for descriptive flex field.
494 -- p_attribute20 Standard Attribute Column. Meant for descriptive flex field.
495 -- p_attribute21 Standard Attribute Column. Meant for descriptive flex field.
496 -- p_attribute22 Standard Attribute Column. Meant for descriptive flex field.
497 -- p_attribute23 Standard Attribute Column. Meant for descriptive flex field.
498 -- p_attribute24 Standard Attribute Column. Meant for descriptive flex field.
499 -- p_attribute25 Standard Attribute Column. Meant for descriptive flex field.
500 -- p_attribute26 Standard Attribute Column. Meant for descriptive flex field.
501 -- p_attribute27 Standard Attribute Column. Meant for descriptive flex field.
502 -- p_attribute28 Standard Attribute Column. Meant for descriptive flex field.
503 -- p_attribute29 Standard Attribute Column. Meant for descriptive flex field.
504 -- p_attribute30 Standard Attribute Column. Meant for descriptive flex field.
505 -- p_attribute31 Standard Attribute Column. Meant for descriptive flex field.
506 -- p_attribute32 Standard Attribute Column. Meant for descriptive flex field.
507 -- p_attribute33 Standard Attribute Column. Meant for descriptive flex field.
508 -- p_attribute34 Standard Attribute Column. Meant for descriptive flex field.
509 -- p_attribute35 Standard Attribute Column. Meant for descriptive flex field.
510 -- p_attribute36 Standard Attribute Column. Meant for descriptive flex field.
511 -- p_attribute37 Standard Attribute Column. Meant for descriptive flex field.
512 -- p_attribute38 Standard Attribute Column. Meant for descriptive flex field.
516 IS
513 -- p_attribute39 Standard Attribute Column. Meant for descriptive flex field.
514 -- p_attribute40 Standard Attribute Column. Meant for descriptive flex field.
515
517
518 BEGIN
519
520 -- PUT YOUR CODE HERE
521 RETURN ;
522
523 EXCEPTION
524 WHEN OTHERS THEN
525
526 FND_MESSAGE.SET_NAME ('IGS','IGS_AD_UH_UNHAND_EXCEPTION');
527 FND_MESSAGE.SET_TOKEN ('OBJECTNAME','IGS_AD_UHK_PRE_CREATE_APPL_PKG.DERIVE_APP_FEE');
528 IGS_GE_MSG_STACK.ADD;
529
530 APP_EXCEPTION.RAISE_EXCEPTION;
531
532 END derive_app_fee;
533
534 PROCEDURE pre_submit_application (
535 p_person_id in number,
536 p_ss_adm_appl_id in number,
537 p_return_status in out nocopy varchar2,
538 p_msg_data out nocopy varchar2
539 )
540
541 -- This procedure would be called from function subcription attached to the
542 -- Business Event (B.E) 'oracle.apps.igs.ad.pre_submit_application'. This B.E
543 -- is raised when Submit Application button is clicked in Checklist Page. The B.E
544 -- would be raised before Unsubmitted Application is transfered from staging tables
545 -- to Core Tables. So This procedure could be used to validate the Application Data or
546 -- insert any additional information like Fee Records through Public API's before
547 -- Unsubmitted Application is transfered from staging tables to Core Tables.
548 -- User has to set p_msg_data with appropriate error message text for any custom
549 -- validation failures.
550
551 -- Who When What
552 -- Akadam 02/5/2005 Created the procedure
553
554 --
555 -- Parameters Description:
556 --
557
558 -- p_person_id Applicant Person Identifier
559 -- p_ss_adm_appl_id Admission Application Identifier
560 -- p_return_status Return Status this should set to following values depending upon
561 -- the execution of the User Hook.
562 -- Error --> p_return_status := 'E';
563 -- Unexpected Error --> p_return_status := 'U';
564 -- Success --> p_return_status := 'S';
565 -- p_msg_data Appropriate error message text for any Custom Validation Failures.
566
567 IS
568
569 BEGIN
570
571 -- PUT YOUR CODE HERE
572 RETURN ;
573
574 EXCEPTION
575 WHEN OTHERS THEN
576
577 FND_MESSAGE.SET_NAME ('IGS','IGS_AD_UH_UNHAND_EXCEPTION');
578 FND_MESSAGE.SET_TOKEN ('OBJECTNAME','IGS_AD_UHK_PRE_CREATE_APPL_PKG.PRE_SUBMIT_APPLICATION');
579 IGS_GE_MSG_STACK.ADD;
580
581 APP_EXCEPTION.RAISE_EXCEPTION;
582
583 END pre_submit_application;
584
585
586 END igs_ad_uhk_pre_create_appl_pkg;