1 PACKAGE igs_ad_uhk_pre_create_appl_pkg AS
2 /* $Header: IGSADD3S.pls 120.2 2006/05/25 05:53:26 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 PROCEDURE derive_app_fee (
124 p_person_id in number,
125 p_login_resp in varchar2,
126 p_acad_cal_type in varchar2,
127 p_acad_cal_seq_number in number,
128 p_adm_cal_type in varchar2,
129 p_adm_ci_sequence_number in number,
130 p_application_type in out nocopy varchar2,
131 p_application_fee_amount in out nocopy number,
132 p_location_code in out nocopy varchar2,
133 p_program_type in out nocopy varchar2,
134 p_sch_apl_to_id in out nocopy number,
135 p_attendance_type in out nocopy varchar2,
136 p_attendance_mode in out nocopy varchar2,
137 p_oo_attribute_1 in out nocopy varchar2,
138 p_oo_attribute_2 in out nocopy varchar2,
139 p_oo_attribute_3 in out nocopy varchar2,
140 p_oo_attribute_4 in out nocopy varchar2,
141 p_oo_attribute_5 in out nocopy varchar2,
142 p_oo_attribute_6 in out nocopy varchar2,
143 p_oo_attribute_7 in out nocopy varchar2,
144 p_oo_attribute_8 in out nocopy varchar2,
145 p_oo_attribute_9 in out nocopy varchar2,
146 p_oo_attribute_10 in out nocopy varchar2,
147 p_citizenship_residency_ind in out nocopy varchar2,
148 p_cit_res_attribute_1 in out nocopy varchar2,
149 p_cit_res_attribute_2 in out nocopy varchar2,
150 p_cit_res_attribute_3 in out nocopy varchar2,
151 p_cit_res_attribute_4 in out nocopy varchar2,
152 p_cit_res_attribute_5 in out nocopy varchar2,
153 p_cit_res_attribute_6 in out nocopy varchar2,
154 p_cit_res_attribute_7 in out nocopy varchar2,
155 p_cit_res_attribute_8 in out nocopy varchar2,
156 p_cit_res_attribute_9 in out nocopy varchar2,
157 p_cit_res_attribute_10 in out nocopy varchar2,
158 p_state_of_res_type_code in out nocopy varchar2,
159 p_dom_attribute_1 in out nocopy varchar2,
160 p_dom_attribute_2 in out nocopy varchar2,
161 p_dom_attribute_3 in out nocopy varchar2,
162 p_dom_attribute_4 in out nocopy varchar2,
163 p_dom_attribute_5 in out nocopy varchar2,
164 p_dom_attribute_6 in out nocopy varchar2,
165 p_dom_attribute_7 in out nocopy varchar2,
166 p_dom_attribute_8 in out nocopy varchar2,
167 p_dom_attribute_9 in out nocopy varchar2,
168 p_dom_attribute_10 in out nocopy varchar2,
169 p_gen_attribute_1 in out nocopy varchar2,
170 p_gen_attribute_2 in out nocopy varchar2,
171 p_gen_attribute_3 in out nocopy varchar2,
172 p_gen_attribute_4 in out nocopy varchar2,
173 p_gen_attribute_5 in out nocopy varchar2,
174 p_gen_attribute_6 in out nocopy varchar2,
175 p_gen_attribute_7 in out nocopy varchar2,
176 p_gen_attribute_8 in out nocopy varchar2,
177 p_gen_attribute_9 in out nocopy varchar2,
178 p_gen_attribute_10 in out nocopy varchar2,
179 p_gen_attribute_11 in out nocopy varchar2,
180 p_gen_attribute_12 in out nocopy varchar2,
181 p_gen_attribute_13 in out nocopy varchar2,
182 p_gen_attribute_14 in out nocopy varchar2,
183 p_gen_attribute_15 in out nocopy varchar2,
184 p_gen_attribute_16 in out nocopy varchar2,
185 p_gen_attribute_17 in out nocopy varchar2,
186 p_gen_attribute_18 in out nocopy varchar2,
187 p_gen_attribute_19 in out nocopy varchar2,
188 p_gen_attribute_20 in out nocopy varchar2,
189 p_entry_status in out nocopy varchar2,
190 p_entry_level in out nocopy varchar2,
191 p_spcl_gr1 in out nocopy varchar2,
192 p_spcl_gr2 in out nocopy varchar2,
193 p_apply_for_finaid in out nocopy varchar2,
194 p_finaid_apply_date in out nocopy date,
195 p_appl_date in out nocopy date,
196 p_attribute_category in out nocopy varchar2,
197 p_attribute1 in out nocopy varchar2,
198 p_attribute2 in out nocopy varchar2,
199 p_attribute3 in out nocopy varchar2,
200 p_attribute4 in out nocopy varchar2,
201 p_attribute5 in out nocopy varchar2,
202 p_attribute6 in out nocopy varchar2,
203 p_attribute7 in out nocopy varchar2,
204 p_attribute8 in out nocopy varchar2,
205 p_attribute9 in out nocopy varchar2,
206 p_attribute10 in out nocopy varchar2,
207 p_attribute11 in out nocopy varchar2,
208 p_attribute12 in out nocopy varchar2,
209 p_attribute13 in out nocopy varchar2,
210 p_attribute14 in out nocopy varchar2,
211 p_attribute15 in out nocopy varchar2,
212 p_attribute16 in out nocopy varchar2,
213 p_attribute17 in out nocopy varchar2,
214 p_attribute18 in out nocopy varchar2,
215 p_attribute19 in out nocopy varchar2,
216 p_attribute20 in out nocopy varchar2,
217 p_attribute21 in out nocopy varchar2,
218 p_attribute22 in out nocopy varchar2,
219 p_attribute23 in out nocopy varchar2,
220 p_attribute24 in out nocopy varchar2,
221 p_attribute25 in out nocopy varchar2,
222 p_attribute26 in out nocopy varchar2,
223 p_attribute27 in out nocopy varchar2,
224 p_attribute28 in out nocopy varchar2,
225 p_attribute29 in out nocopy varchar2,
226 p_attribute30 in out nocopy varchar2,
227 p_attribute31 in out nocopy varchar2,
228 p_attribute32 in out nocopy varchar2,
229 p_attribute33 in out nocopy varchar2,
230 p_attribute34 in out nocopy varchar2,
231 p_attribute35 in out nocopy varchar2,
232 p_attribute36 in out nocopy varchar2,
233 p_attribute37 in out nocopy varchar2,
234 p_attribute38 in out nocopy varchar2,
235 p_attribute39 in out nocopy varchar2,
236 p_attribute40 in out nocopy varchar2
237 );
238
239 PROCEDURE pre_submit_application (
240 p_person_id in number,
241 p_ss_adm_appl_id in number,
242 p_return_status in out nocopy varchar2,
243 p_msg_data out nocopy varchar2
244 );
245
246 END igs_ad_uhk_pre_create_appl_pkg;