1 PACKAGE igf_ap_css_interface_pkg AS
2 /* $Header: IGFAI41S.pls 120.0 2005/06/01 14:30:44 appldev noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_css_id IN OUT NOCOPY NUMBER,
7 x_record_status IN VARCHAR2,
8 x_college_code IN VARCHAR2,
9 x_academic_year IN VARCHAR2,
10 x_stu_record_type IN VARCHAR2,
11 x_css_id_number IN VARCHAR2,
12 x_registration_receipt_date IN VARCHAR2,
13 x_registration_type IN VARCHAR2,
14 x_application_receipt_date IN VARCHAR2,
15 x_application_type IN VARCHAR2,
16 x_original_fnar_compute IN VARCHAR2,
17 x_revision_fnar_compute_date IN VARCHAR2,
18 x_electronic_extract_date IN VARCHAR2,
19 x_institutional_reporting_type IN VARCHAR2,
20 x_asr_receipt_date IN VARCHAR2,
21 x_last_name IN VARCHAR2,
22 x_first_name IN VARCHAR2,
23 x_middle_initial IN VARCHAR2,
24 x_address_number_and_street IN VARCHAR2,
25 x_city IN VARCHAR2,
26 x_state_mailing IN VARCHAR2,
27 x_zip_code IN VARCHAR2,
28 x_s_telephone_number IN VARCHAR2,
29 x_s_title IN VARCHAR2,
30 x_date_of_birth IN VARCHAR2,
31 x_social_security_number IN VARCHAR2,
32 x_state_legal_residence IN VARCHAR2,
33 x_foreign_address_indicator IN VARCHAR2,
34 x_foreign_postal_code IN VARCHAR2,
35 x_country IN VARCHAR2,
36 x_financial_aid_status IN VARCHAR2,
37 x_year_in_college IN VARCHAR2,
38 x_marital_status IN VARCHAR2,
39 x_ward_court IN VARCHAR2,
40 x_legal_dependents_other IN VARCHAR2,
41 x_household_size IN VARCHAR2,
42 x_number_in_college IN VARCHAR2,
43 x_citizenship_status IN VARCHAR2,
44 x_citizenship_country IN VARCHAR2,
45 x_visa_classification IN VARCHAR2,
46 x_tax_figures IN VARCHAR2,
47 x_number_exemptions IN VARCHAR2,
48 x_adjusted_gross_inc IN VARCHAR2,
49 x_us_tax_paid IN VARCHAR2,
50 x_itemized_deductions IN VARCHAR2,
51 x_stu_income_work IN VARCHAR2,
52 x_spouse_income_work IN VARCHAR2,
53 x_divid_int_inc IN VARCHAR2,
54 x_soc_sec_benefits IN VARCHAR2,
55 x_welfare_tanf IN VARCHAR2,
56 x_child_supp_rcvd IN VARCHAR2,
57 x_earned_income_credit IN VARCHAR2,
58 x_other_untax_income IN VARCHAR2,
59 x_tax_stu_aid IN VARCHAR2,
60 x_cash_sav_check IN VARCHAR2,
61 x_ira_keogh IN VARCHAR2,
62 x_invest_value IN VARCHAR2,
63 x_invest_debt IN VARCHAR2,
64 x_home_value IN VARCHAR2,
65 x_home_debt IN VARCHAR2,
66 x_oth_real_value IN VARCHAR2,
67 x_oth_real_debt IN VARCHAR2,
68 x_bus_farm_value IN VARCHAR2,
69 x_bus_farm_debt IN VARCHAR2,
70 x_live_on_farm IN VARCHAR2,
71 x_home_purch_price IN VARCHAR2,
72 x_hope_ll_credit IN VARCHAR2,
73 x_home_purch_year IN VARCHAR2,
74 x_trust_amount IN VARCHAR2,
75 x_trust_avail IN VARCHAR2,
76 x_trust_estab IN VARCHAR2,
77 x_child_support_paid IN VARCHAR2,
78 x_med_dent_expenses IN VARCHAR2,
79 x_vet_us IN VARCHAR2,
80 x_vet_ben_amount IN VARCHAR2,
81 x_vet_ben_months IN VARCHAR2,
82 x_stu_summer_wages IN VARCHAR2,
83 x_stu_school_yr_wages IN VARCHAR2,
84 x_spouse_summer_wages IN VARCHAR2,
85 x_spouse_school_yr_wages IN VARCHAR2,
86 x_summer_other_tax_inc IN VARCHAR2,
87 x_school_yr_other_tax_inc IN VARCHAR2,
88 x_summer_untax_inc IN VARCHAR2,
89 x_school_yr_untax_inc IN VARCHAR2,
90 x_grants_schol_etc IN VARCHAR2,
91 x_tuit_benefits IN VARCHAR2,
92 x_cont_parents IN VARCHAR2,
93 x_cont_relatives IN VARCHAR2,
94 x_p_siblings_pre_tuit IN VARCHAR2,
95 x_p_student_pre_tuit IN VARCHAR2,
96 x_p_household_size IN VARCHAR2,
97 x_p_number_in_college IN VARCHAR2,
98 x_p_parents_in_college IN VARCHAR2,
99 x_p_marital_status IN VARCHAR2,
100 x_p_state_legal_residence IN VARCHAR2,
101 x_p_natural_par_status IN VARCHAR2,
102 x_p_child_supp_paid IN VARCHAR2,
103 x_p_repay_ed_loans IN VARCHAR2,
104 x_p_med_dent_expenses IN VARCHAR2,
105 x_p_tuit_paid_amount IN VARCHAR2,
106 x_p_tuit_paid_number IN VARCHAR2,
107 x_p_exp_child_supp_paid IN VARCHAR2,
108 x_p_exp_repay_ed_loans IN VARCHAR2,
109 x_p_exp_med_dent_expenses IN VARCHAR2,
110 x_p_exp_tuit_pd_amount IN VARCHAR2,
111 x_p_exp_tuit_pd_number IN VARCHAR2,
112 x_p_cash_sav_check IN VARCHAR2,
113 x_p_month_mortgage_pay IN VARCHAR2,
114 x_p_invest_value IN VARCHAR2,
115 x_p_invest_debt IN VARCHAR2,
116 x_p_home_value IN VARCHAR2,
117 x_p_home_debt IN VARCHAR2,
118 x_p_home_purch_price IN VARCHAR2,
119 x_p_own_business_farm IN VARCHAR2,
120 x_p_business_value IN VARCHAR2,
121 x_p_business_debt IN VARCHAR2,
122 x_p_farm_value IN VARCHAR2,
123 x_p_farm_debt IN VARCHAR2,
124 x_p_live_on_farm IN VARCHAR2,
125 x_p_oth_real_estate_value IN VARCHAR2,
126 x_p_oth_real_estate_debt IN VARCHAR2,
127 x_p_oth_real_purch_price IN VARCHAR2,
128 x_p_siblings_assets IN VARCHAR2,
129 x_p_home_purch_year IN VARCHAR2,
130 x_p_oth_real_purch_year IN VARCHAR2,
131 x_p_prior_agi IN VARCHAR2,
132 x_p_prior_us_tax_paid IN VARCHAR2,
133 x_p_prior_item_deductions IN VARCHAR2,
134 x_p_prior_other_untax_inc IN VARCHAR2,
135 x_p_tax_figures IN VARCHAR2,
136 x_p_number_exemptions IN VARCHAR2,
137 x_p_adjusted_gross_inc IN VARCHAR2,
138 x_p_wages_sal_tips IN VARCHAR2,
139 x_p_interest_income IN VARCHAR2,
140 x_p_dividend_income IN VARCHAR2,
141 x_p_net_inc_bus_farm IN VARCHAR2,
142 x_p_other_taxable_income IN VARCHAR2,
143 x_p_adj_to_income IN VARCHAR2,
144 x_p_us_tax_paid IN VARCHAR2,
145 x_p_itemized_deductions IN VARCHAR2,
146 x_p_father_income_work IN VARCHAR2,
147 x_p_mother_income_work IN VARCHAR2,
148 x_p_soc_sec_ben IN VARCHAR2,
149 x_p_welfare_tanf IN VARCHAR2,
150 x_p_child_supp_rcvd IN VARCHAR2,
151 x_p_ded_ira_keogh IN VARCHAR2,
152 x_p_tax_defer_pens_savs IN VARCHAR2,
153 x_p_dep_care_med_spending IN VARCHAR2,
154 x_p_earned_income_credit IN VARCHAR2,
155 x_p_living_allow IN VARCHAR2,
156 x_p_tax_exmpt_int IN VARCHAR2,
157 x_p_foreign_inc_excl IN VARCHAR2,
158 x_p_other_untax_inc IN VARCHAR2,
159 x_p_hope_ll_credit IN VARCHAR2,
160 x_p_yr_separation IN VARCHAR2,
161 x_p_yr_divorce IN VARCHAR2,
162 x_p_exp_father_inc IN VARCHAR2,
163 x_p_exp_mother_inc IN VARCHAR2,
164 x_p_exp_other_tax_inc IN VARCHAR2,
165 x_p_exp_other_untax_inc IN VARCHAR2,
166 x_line_2_relation IN VARCHAR2,
167 x_line_2_attend_college IN VARCHAR2,
168 x_line_3_relation IN VARCHAR2,
169 x_line_3_attend_college IN VARCHAR2,
170 x_line_4_relation IN VARCHAR2,
171 x_line_4_attend_college IN VARCHAR2,
172 x_line_5_relation IN VARCHAR2,
173 x_line_5_attend_college IN VARCHAR2,
174 x_line_6_relation IN VARCHAR2,
175 x_line_6_attend_college IN VARCHAR2,
176 x_line_7_relation IN VARCHAR2,
177 x_line_7_attend_college IN VARCHAR2,
178 x_line_8_relation IN VARCHAR2,
179 x_line_8_attend_college IN VARCHAR2,
180 x_p_age_father IN VARCHAR2,
181 x_p_age_mother IN VARCHAR2,
182 x_p_div_sep_ind IN VARCHAR2,
183 x_b_cont_non_custodial_par IN VARCHAR2,
184 x_college_type_2 IN VARCHAR2,
185 x_college_type_3 IN VARCHAR2,
186 x_college_type_4 IN VARCHAR2,
187 x_college_type_5 IN VARCHAR2,
188 x_college_type_6 IN VARCHAR2,
189 x_college_type_7 IN VARCHAR2,
190 x_college_type_8 IN VARCHAR2,
191 x_school_code_1 IN VARCHAR2,
192 x_housing_code_1 IN VARCHAR2,
193 x_school_code_2 IN VARCHAR2,
194 x_housing_code_2 IN VARCHAR2,
195 x_school_code_3 IN VARCHAR2,
196 x_housing_code_3 IN VARCHAR2,
197 x_school_code_4 IN VARCHAR2,
198 x_housing_code_4 IN VARCHAR2,
199 x_school_code_5 IN VARCHAR2,
200 x_housing_code_5 IN VARCHAR2,
201 x_school_code_6 IN VARCHAR2,
202 x_housing_code_6 IN VARCHAR2,
203 x_school_code_7 IN VARCHAR2,
204 x_housing_code_7 IN VARCHAR2,
205 x_school_code_8 IN VARCHAR2,
206 x_housing_code_8 IN VARCHAR2,
207 x_school_code_9 IN VARCHAR2,
208 x_housing_code_9 IN VARCHAR2,
209 x_school_code_10 IN VARCHAR2,
210 x_housing_code_10 IN VARCHAR2,
211 x_additional_school_code_1 IN VARCHAR2,
212 x_additional_school_code_2 IN VARCHAR2,
213 x_additional_school_code_3 IN VARCHAR2,
214 x_additional_school_code_4 IN VARCHAR2,
215 x_additional_school_code_5 IN VARCHAR2,
216 x_additional_school_code_6 IN VARCHAR2,
217 x_additional_school_code_7 IN VARCHAR2,
218 x_additional_school_code_8 IN VARCHAR2,
219 x_additional_school_code_9 IN VARCHAR2,
223 x_signature_spouse IN VARCHAR2,
220 x_additional_school_code_10 IN VARCHAR2,
221 x_explanation_spec_circum IN VARCHAR2,
222 x_signature_student IN VARCHAR2,
224 x_signature_father IN VARCHAR2,
225 x_signature_mother IN VARCHAR2,
226 x_month_day_completed IN VARCHAR2,
227 x_year_completed IN VARCHAR2,
228 x_age_line_2 IN VARCHAR2,
229 x_age_line_3 IN VARCHAR2,
230 x_age_line_4 IN VARCHAR2,
231 x_age_line_5 IN VARCHAR2,
232 x_age_line_6 IN VARCHAR2,
233 x_age_line_7 IN VARCHAR2,
234 x_age_line_8 IN VARCHAR2,
235 x_a_online_signature IN VARCHAR2,
236 x_question_1_number IN VARCHAR2,
237 x_question_1_size IN VARCHAR2,
238 x_question_1_answer IN VARCHAR2,
239 x_question_2_number IN VARCHAR2,
240 x_question_2_size IN VARCHAR2,
241 x_question_2_answer IN VARCHAR2,
242 x_question_3_number IN VARCHAR2,
243 x_question_3_size IN VARCHAR2,
244 x_question_3_answer IN VARCHAR2,
245 x_question_4_number IN VARCHAR2,
246 x_question_4_size IN VARCHAR2,
247 x_question_4_answer IN VARCHAR2,
248 x_question_5_number IN VARCHAR2,
249 x_question_5_size IN VARCHAR2,
250 x_question_5_answer IN VARCHAR2,
251 x_question_6_number IN VARCHAR2,
252 x_question_6_size IN VARCHAR2,
253 x_question_6_answer IN VARCHAR2,
254 x_question_7_number IN VARCHAR2,
255 x_question_7_size IN VARCHAR2,
256 x_question_7_answer IN VARCHAR2,
257 x_question_8_number IN VARCHAR2,
258 x_question_8_size IN VARCHAR2,
259 x_question_8_answer IN VARCHAR2,
260 x_question_9_number IN VARCHAR2,
261 x_question_9_size IN VARCHAR2,
262 x_question_9_answer IN VARCHAR2,
263 x_question_10_number IN VARCHAR2,
264 x_question_10_size IN VARCHAR2,
265 x_question_10_answer IN VARCHAR2,
266 x_question_11_number IN VARCHAR2,
267 x_question_11_size IN VARCHAR2,
268 x_question_11_answer IN VARCHAR2,
269 x_question_12_number IN VARCHAR2,
270 x_question_12_size IN VARCHAR2,
271 x_question_12_answer IN VARCHAR2,
272 x_question_13_number IN VARCHAR2,
273 x_question_13_size IN VARCHAR2,
274 x_question_13_answer IN VARCHAR2,
275 x_question_14_number IN VARCHAR2,
276 x_question_14_size IN VARCHAR2,
277 x_question_14_answer IN VARCHAR2,
278 x_question_15_number IN VARCHAR2,
279 x_question_15_size IN VARCHAR2,
280 x_question_15_answer IN VARCHAR2,
281 x_question_16_number IN VARCHAR2,
282 x_question_16_size IN VARCHAR2,
283 x_question_16_answer IN VARCHAR2,
284 x_question_17_number IN VARCHAR2,
285 x_question_17_size IN VARCHAR2,
286 x_question_17_answer IN VARCHAR2,
287 x_question_18_number IN VARCHAR2,
288 x_question_18_size IN VARCHAR2,
289 x_question_18_answer IN VARCHAR2,
290 x_question_19_number IN VARCHAR2,
291 x_question_19_size IN VARCHAR2,
292 x_question_19_answer IN VARCHAR2,
293 x_question_20_number IN VARCHAR2,
294 x_question_20_size IN VARCHAR2,
295 x_question_20_answer IN VARCHAR2,
296 x_question_21_number IN VARCHAR2,
297 x_question_21_size IN VARCHAR2,
298 x_question_21_answer IN VARCHAR2,
299 x_question_22_number IN VARCHAR2,
300 x_question_22_size IN VARCHAR2,
301 x_question_22_answer IN VARCHAR2,
302 x_question_23_number IN VARCHAR2,
303 x_question_23_size IN VARCHAR2,
304 x_question_23_answer IN VARCHAR2,
305 x_question_24_number IN VARCHAR2,
306 x_question_24_size IN VARCHAR2,
307 x_question_24_answer IN VARCHAR2,
308 x_question_25_number IN VARCHAR2,
309 x_question_25_size IN VARCHAR2,
310 x_question_25_answer IN VARCHAR2,
311 x_question_26_number IN VARCHAR2,
312 x_question_26_size IN VARCHAR2,
313 x_question_26_answer IN VARCHAR2,
314 x_question_27_number IN VARCHAR2,
315 x_question_27_size IN VARCHAR2,
319 x_question_28_answer IN VARCHAR2,
316 x_question_27_answer IN VARCHAR2,
317 x_question_28_number IN VARCHAR2,
318 x_question_28_size IN VARCHAR2,
320 x_question_29_number IN VARCHAR2,
321 x_question_29_size IN VARCHAR2,
322 x_question_29_answer IN VARCHAR2,
323 x_question_30_number IN VARCHAR2,
324 x_questions_30_size IN VARCHAR2,
325 x_question_30_answer IN VARCHAR2,
326 x_r_s_email_address IN VARCHAR2,
327 x_eps_code IN VARCHAR2,
328 x_comp_css_dependency_status IN VARCHAR2,
329 x_stu_age IN VARCHAR2,
330 x_assumed_stu_yr_in_coll IN VARCHAR2,
331 x_comp_stu_marital_status IN VARCHAR2,
332 x_stu_family_members IN VARCHAR2,
333 x_stu_fam_members_in_college IN VARCHAR2,
334 x_par_marital_status IN VARCHAR2,
335 x_par_family_members IN VARCHAR2,
336 x_par_total_in_college IN VARCHAR2,
337 x_par_par_in_college IN VARCHAR2,
338 x_par_others_in_college IN VARCHAR2,
339 x_par_aesa IN VARCHAR2,
340 x_par_cesa IN VARCHAR2,
341 x_stu_aesa IN VARCHAR2,
342 x_stu_cesa IN VARCHAR2,
343 x_im_p_bas_agi_taxable_income IN VARCHAR2,
344 x_im_p_bas_untx_inc_and_ben IN VARCHAR2,
345 x_im_p_bas_inc_adj IN VARCHAR2,
346 x_im_p_bas_total_income IN VARCHAR2,
347 x_im_p_bas_us_income_tax IN VARCHAR2,
348 x_im_p_bas_st_and_other_tax IN VARCHAR2,
349 x_im_p_bas_fica_tax IN VARCHAR2,
350 x_im_p_bas_med_dental IN VARCHAR2,
351 x_im_p_bas_employment_allow IN VARCHAR2,
352 x_im_p_bas_annual_ed_savings IN VARCHAR2,
353 x_im_p_bas_inc_prot_allow_m IN VARCHAR2,
354 x_im_p_bas_total_inc_allow IN VARCHAR2,
355 x_im_p_bas_cal_avail_inc IN VARCHAR2,
356 x_im_p_bas_avail_income IN VARCHAR2,
357 x_im_p_bas_total_cont_inc IN VARCHAR2,
358 x_im_p_bas_cash_bank_accounts IN VARCHAR2,
359 x_im_p_bas_home_equity IN VARCHAR2,
360 x_im_p_bas_ot_rl_est_inv_eq IN VARCHAR2,
361 x_im_p_bas_adj_bus_farm_worth IN VARCHAR2,
362 x_im_p_bas_ass_sibs_pre_tui IN VARCHAR2,
363 x_im_p_bas_net_worth IN VARCHAR2,
364 x_im_p_bas_emerg_res_allow IN VARCHAR2,
365 x_im_p_bas_cum_ed_savings IN VARCHAR2,
366 x_im_p_bas_low_inc_allow IN VARCHAR2,
367 x_im_p_bas_total_asset_allow IN VARCHAR2,
368 x_im_p_bas_disc_net_worth IN VARCHAR2,
369 x_im_p_bas_total_cont_asset IN VARCHAR2,
370 x_im_p_bas_total_cont IN VARCHAR2,
371 x_im_p_bas_num_in_coll_adj IN VARCHAR2,
372 x_im_p_bas_cont_for_stu IN VARCHAR2,
373 x_im_p_bas_cont_from_income IN VARCHAR2,
374 x_im_p_bas_cont_from_assets IN VARCHAR2,
375 x_im_p_opt_agi_taxable_income IN VARCHAR2,
376 x_im_p_opt_untx_inc_and_ben IN VARCHAR2,
377 x_im_p_opt_inc_adj IN VARCHAR2,
378 x_im_p_opt_total_income IN VARCHAR2,
379 x_im_p_opt_us_income_tax IN VARCHAR2,
380 x_im_p_opt_st_and_other_tax IN VARCHAR2,
381 x_im_p_opt_fica_tax IN VARCHAR2,
382 x_im_p_opt_med_dental IN VARCHAR2,
383 x_im_p_opt_elem_sec_tuit IN VARCHAR2,
384 x_im_p_opt_employment_allow IN VARCHAR2,
385 x_im_p_opt_annual_ed_savings IN VARCHAR2,
386 x_im_p_opt_inc_prot_allow_m IN VARCHAR2,
387 x_im_p_opt_total_inc_allow IN VARCHAR2,
388 x_im_p_opt_cal_avail_inc IN VARCHAR2,
389 x_im_p_opt_avail_income IN VARCHAR2,
390 x_im_p_opt_total_cont_inc IN VARCHAR2,
391 x_im_p_opt_cash_bank_accounts IN VARCHAR2,
392 x_im_p_opt_home_equity IN VARCHAR2,
393 x_im_p_opt_ot_rl_est_inv_eq IN VARCHAR2,
394 x_im_p_opt_adj_bus_farm_worth IN VARCHAR2,
395 x_im_p_opt_ass_sibs_pre_t IN VARCHAR2,
396 x_im_p_opt_net_worth IN VARCHAR2,
397 x_im_p_opt_emerg_res_allow IN VARCHAR2,
398 x_im_p_opt_cum_ed_savings IN VARCHAR2,
399 x_im_p_opt_low_inc_allow IN VARCHAR2,
400 x_im_p_opt_total_asset_allow IN VARCHAR2,
401 x_im_p_opt_disc_net_worth IN VARCHAR2,
402 x_im_p_opt_total_cont_asset IN VARCHAR2,
403 x_im_p_opt_total_cont IN VARCHAR2,
404 x_im_p_opt_num_in_coll_adj IN VARCHAR2,
405 x_im_p_opt_cont_for_stu IN VARCHAR2,
406 x_im_p_opt_cont_from_income IN VARCHAR2,
407 x_im_p_opt_cont_from_assets IN VARCHAR2,
408 x_fm_p_analysis_type IN VARCHAR2,
409 x_fm_p_agi_taxable_income IN VARCHAR2,
410 x_fm_p_untx_inc_and_ben IN VARCHAR2,
411 x_fm_p_inc_adj IN VARCHAR2,
415 x_fm_p_fica_tax IN VARCHAR2,
412 x_fm_p_total_income IN VARCHAR2,
413 x_fm_p_us_income_tax IN VARCHAR2,
414 x_fm_p_state_and_other_taxes IN VARCHAR2,
416 x_fm_p_employment_allow IN VARCHAR2,
417 x_fm_p_income_prot_allow IN VARCHAR2,
418 x_fm_p_total_allow IN VARCHAR2,
419 x_fm_p_avail_income IN VARCHAR2,
420 x_fm_p_cash_bank_accounts IN VARCHAR2,
421 x_fm_p_ot_rl_est_inv_eq IN VARCHAR2,
422 x_fm_p_adj_bus_farm_net_worth IN VARCHAR2,
423 x_fm_p_net_worth IN VARCHAR2,
424 x_fm_p_asset_prot_allow IN VARCHAR2,
425 x_fm_p_disc_net_worth IN VARCHAR2,
426 x_fm_p_total_contribution IN VARCHAR2,
427 x_fm_p_num_in_coll IN VARCHAR2,
428 x_fm_p_cont_for_stu IN VARCHAR2,
429 x_fm_p_cont_from_income IN VARCHAR2,
430 x_fm_p_cont_from_assets IN VARCHAR2,
431 x_im_s_bas_agi_taxable_income IN VARCHAR2,
432 x_im_s_bas_untx_inc_and_ben IN VARCHAR2,
433 x_im_s_bas_inc_adj IN VARCHAR2,
434 x_im_s_bas_total_income IN VARCHAR2,
435 x_im_s_bas_us_income_tax IN VARCHAR2,
436 x_im_s_bas_st_and_oth_tax IN VARCHAR2,
437 x_im_s_bas_fica_tax IN VARCHAR2,
438 x_im_s_bas_med_dental IN VARCHAR2,
439 x_im_s_bas_employment_allow IN VARCHAR2,
440 x_im_s_bas_annual_ed_savings IN VARCHAR2,
441 x_im_s_bas_inc_prot_allow_m IN VARCHAR2,
442 x_im_s_bas_total_inc_allow IN VARCHAR2,
443 x_im_s_bas_cal_avail_income IN VARCHAR2,
444 x_im_s_bas_avail_income IN VARCHAR2,
445 x_im_s_bas_total_cont_inc IN VARCHAR2,
446 x_im_s_bas_cash_bank_accounts IN VARCHAR2,
447 x_im_s_bas_home_equity IN VARCHAR2,
448 x_im_s_bas_ot_rl_est_inv_eq IN VARCHAR2,
449 x_im_s_bas_adj_bus_farm_worth IN VARCHAR2,
450 x_im_s_bas_trusts IN VARCHAR2,
451 x_im_s_bas_net_worth IN VARCHAR2,
452 x_im_s_bas_emerg_res_allow IN VARCHAR2,
453 x_im_s_bas_cum_ed_savings IN VARCHAR2,
454 x_im_s_bas_total_asset_allow IN VARCHAR2,
455 x_im_s_bas_disc_net_worth IN VARCHAR2,
456 x_im_s_bas_total_cont_asset IN VARCHAR2,
457 x_im_s_bas_total_cont IN VARCHAR2,
458 x_im_s_bas_num_in_coll_adj IN VARCHAR2,
459 x_im_s_bas_cont_for_stu IN VARCHAR2,
460 x_im_s_bas_cont_from_income IN VARCHAR2,
461 x_im_s_bas_cont_from_assets IN VARCHAR2,
462 x_im_s_est_agi_taxable_income IN VARCHAR2,
463 x_im_s_est_untx_inc_and_ben IN VARCHAR2,
464 x_im_s_est_inc_adj IN VARCHAR2,
465 x_im_s_est_total_income IN VARCHAR2,
466 x_im_s_est_us_income_tax IN VARCHAR2,
467 x_im_s_est_st_and_oth_tax IN VARCHAR2,
468 x_im_s_est_fica_tax IN VARCHAR2,
469 x_im_s_est_med_dental IN VARCHAR2,
470 x_im_s_est_employment_allow IN VARCHAR2,
471 x_im_s_est_annual_ed_savings IN VARCHAR2,
472 x_im_s_est_inc_prot_allow_m IN VARCHAR2,
473 x_im_s_est_total_inc_allow IN VARCHAR2,
474 x_im_s_est_cal_avail_income IN VARCHAR2,
475 x_im_s_est_avail_income IN VARCHAR2,
476 x_im_s_est_total_cont_inc IN VARCHAR2,
477 x_im_s_est_cash_bank_accounts IN VARCHAR2,
478 x_im_s_est_home_equity IN VARCHAR2,
479 x_im_s_est_ot_rl_est_inv_equ IN VARCHAR2,
480 x_im_s_est_adj_bus_farm_worth IN VARCHAR2,
481 x_im_s_est_est_trusts IN VARCHAR2,
482 x_im_s_est_net_worth IN VARCHAR2,
483 x_im_s_est_emerg_res_allow IN VARCHAR2,
484 x_im_s_est_cum_ed_savings IN VARCHAR2,
485 x_im_s_est_total_asset_allow IN VARCHAR2,
486 x_im_s_est_disc_net_worth IN VARCHAR2,
487 x_im_s_est_total_cont_asset IN VARCHAR2,
488 x_im_s_est_total_cont IN VARCHAR2,
489 x_im_s_est_num_in_coll_adj IN VARCHAR2,
490 x_im_s_est_cont_for_stu IN VARCHAR2,
491 x_im_s_est_cont_from_income IN VARCHAR2,
492 x_im_s_est_cont_from_assets IN VARCHAR2,
493 x_im_s_opt_agi_taxable_income IN VARCHAR2,
494 x_im_s_opt_untx_inc_and_ben IN VARCHAR2,
495 x_im_s_opt_inc_adj IN VARCHAR2,
496 x_im_s_opt_total_income IN VARCHAR2,
497 x_im_s_opt_us_income_tax IN VARCHAR2,
498 x_im_s_opt_state_and_oth_taxes IN VARCHAR2,
499 x_im_s_opt_fica_tax IN VARCHAR2,
500 x_im_s_opt_med_dental IN VARCHAR2,
501 x_im_s_opt_employment_allow IN VARCHAR2,
502 x_im_s_opt_annual_ed_savings IN VARCHAR2,
503 x_im_s_opt_inc_prot_allow_m IN VARCHAR2,
504 x_im_s_opt_total_inc_allow IN VARCHAR2,
505 x_im_s_opt_cal_avail_income IN VARCHAR2,
506 x_im_s_opt_avail_income IN VARCHAR2,
507 x_im_s_opt_total_cont_inc IN VARCHAR2,
511 x_im_s_opt_ot_rl_est_inv_eq IN VARCHAR2,
508 x_im_s_opt_cash_bank_accounts IN VARCHAR2,
509 x_im_s_opt_ira_keogh_accounts IN VARCHAR2,
510 x_im_s_opt_home_equity IN VARCHAR2,
512 x_im_s_opt_adj_bus_farm_worth IN VARCHAR2,
513 x_im_s_opt_trusts IN VARCHAR2,
514 x_im_s_opt_net_worth IN VARCHAR2,
515 x_im_s_opt_emerg_res_allow IN VARCHAR2,
516 x_im_s_opt_cum_ed_savings IN VARCHAR2,
517 x_im_s_opt_total_asset_allow IN VARCHAR2,
518 x_im_s_opt_disc_net_worth IN VARCHAR2,
519 x_im_s_opt_total_cont_asset IN VARCHAR2,
520 x_im_s_opt_total_cont IN VARCHAR2,
521 x_im_s_opt_num_in_coll_adj IN VARCHAR2,
522 x_im_s_opt_cont_for_stu IN VARCHAR2,
523 x_im_s_opt_cont_from_income IN VARCHAR2,
524 x_im_s_opt_cont_from_assets IN VARCHAR2,
525 x_fm_s_analysis_type IN VARCHAR2,
526 x_fm_s_agi_taxable_income IN VARCHAR2,
527 x_fm_s_untx_inc_and_ben IN VARCHAR2,
528 x_fm_s_inc_adj IN VARCHAR2,
529 x_fm_s_total_income IN VARCHAR2,
530 x_fm_s_us_income_tax IN VARCHAR2,
531 x_fm_s_state_and_oth_taxes IN VARCHAR2,
532 x_fm_s_fica_tax IN VARCHAR2,
533 x_fm_s_employment_allow IN VARCHAR2,
534 x_fm_s_income_prot_allow IN VARCHAR2,
535 x_fm_s_total_allow IN VARCHAR2,
536 x_fm_s_cal_avail_income IN VARCHAR2,
537 x_fm_s_avail_income IN VARCHAR2,
538 x_fm_s_cash_bank_accounts IN VARCHAR2,
539 x_fm_s_ot_rl_est_inv_equity IN VARCHAR2,
540 x_fm_s_adj_bus_farm_worth IN VARCHAR2,
541 x_fm_s_trusts IN VARCHAR2,
542 x_fm_s_net_worth IN VARCHAR2,
543 x_fm_s_asset_prot_allow IN VARCHAR2,
544 x_fm_s_disc_net_worth IN VARCHAR2,
545 x_fm_s_total_cont IN VARCHAR2,
546 x_fm_s_num_in_coll IN VARCHAR2,
547 x_fm_s_cont_for_stu IN VARCHAR2,
548 x_fm_s_cont_from_income IN VARCHAR2,
549 x_fm_s_cont_from_assets IN VARCHAR2,
550 x_im_inst_resident_ind IN VARCHAR2,
551 x_institutional_1_budget_name IN VARCHAR2,
552 x_im_inst_1_budget_duration IN VARCHAR2,
553 x_im_inst_1_tuition_fees IN VARCHAR2,
554 x_im_inst_1_books_supplies IN VARCHAR2,
555 x_im_inst_1_living_expenses IN VARCHAR2,
556 x_im_inst_1_tot_expenses IN VARCHAR2,
557 x_im_inst_1_tot_stu_cont IN VARCHAR2,
558 x_im_inst_1_tot_par_cont IN VARCHAR2,
559 x_im_inst_1_tot_family_cont IN VARCHAR2,
560 x_im_inst_1_va_benefits IN VARCHAR2,
561 x_im_inst_1_ot_cont IN VARCHAR2,
562 x_im_inst_1_est_financial_need IN VARCHAR2,
563 x_institutional_2_budget_name IN VARCHAR2,
564 x_im_inst_2_budget_duration IN VARCHAR2,
565 x_im_inst_2_tuition_fees IN VARCHAR2,
566 x_im_inst_2_books_supplies IN VARCHAR2,
567 x_im_inst_2_living_expenses IN VARCHAR2,
568 x_im_inst_2_tot_expenses IN VARCHAR2,
569 x_im_inst_2_tot_stu_cont IN VARCHAR2,
570 x_im_inst_2_tot_par_cont IN VARCHAR2,
571 x_im_inst_2_tot_family_cont IN VARCHAR2,
572 x_im_inst_2_va_benefits IN VARCHAR2,
573 x_im_inst_2_est_financial_need IN VARCHAR2,
574 x_institutional_3_budget_name IN VARCHAR2,
575 x_im_inst_3_budget_duration IN VARCHAR2,
576 x_im_inst_3_tuition_fees IN VARCHAR2,
577 x_im_inst_3_books_supplies IN VARCHAR2,
578 x_im_inst_3_living_expenses IN VARCHAR2,
579 x_im_inst_3_tot_expenses IN VARCHAR2,
580 x_im_inst_3_tot_stu_cont IN VARCHAR2,
581 x_im_inst_3_tot_par_cont IN VARCHAR2,
582 x_im_inst_3_tot_family_cont IN VARCHAR2,
583 x_im_inst_3_va_benefits IN VARCHAR2,
584 x_im_inst_3_est_financial_need IN VARCHAR2,
585 x_fm_inst_1_federal_efc IN VARCHAR2,
586 x_fm_inst_1_va_benefits IN VARCHAR2,
587 x_fm_inst_1_fed_eligibility IN VARCHAR2,
588 x_fm_inst_1_pell IN VARCHAR2,
589 x_option_par_loss_allow_ind IN VARCHAR2,
590 x_option_par_tuition_ind IN VARCHAR2,
591 x_option_par_home_ind IN VARCHAR2,
592 x_option_par_home_value IN VARCHAR2,
593 x_option_par_home_debt IN VARCHAR2,
594 x_option_stu_ira_keogh_ind IN VARCHAR2,
595 x_option_stu_home_ind IN VARCHAR2,
596 x_option_stu_home_value IN VARCHAR2,
597 x_option_stu_home_debt IN VARCHAR2,
598 x_option_stu_sum_ay_inc_ind IN VARCHAR2,
599 x_option_par_hope_ll_credit IN VARCHAR2,
600 x_option_stu_hope_ll_credit IN VARCHAR2,
601 x_im_parent_1_8_months_bas IN VARCHAR2,
602 x_im_p_more_than_9_mth_ba IN VARCHAR2,
603 x_im_parent_1_8_months_opt IN VARCHAR2,
607 x_fnar_message_3 IN VARCHAR2,
604 x_im_p_more_than_9_mth_op IN VARCHAR2,
605 x_fnar_message_1 IN VARCHAR2,
606 x_fnar_message_2 IN VARCHAR2,
608 x_fnar_message_4 IN VARCHAR2,
609 x_fnar_message_5 IN VARCHAR2,
610 x_fnar_message_6 IN VARCHAR2,
611 x_fnar_message_7 IN VARCHAR2,
612 x_fnar_message_8 IN VARCHAR2,
613 x_fnar_message_9 IN VARCHAR2,
614 x_fnar_message_10 IN VARCHAR2,
615 x_fnar_message_11 IN VARCHAR2,
616 x_fnar_message_12 IN VARCHAR2,
617 x_fnar_message_13 IN VARCHAR2,
618 x_fnar_message_20 IN VARCHAR2,
619 x_fnar_message_21 IN VARCHAR2,
620 x_fnar_message_22 IN VARCHAR2,
621 x_fnar_message_23 IN VARCHAR2,
622 x_fnar_message_24 IN VARCHAR2,
623 x_fnar_message_25 IN VARCHAR2,
624 x_fnar_message_26 IN VARCHAR2,
625 x_fnar_message_27 IN VARCHAR2,
626 x_fnar_message_30 IN VARCHAR2,
627 x_fnar_message_31 IN VARCHAR2,
628 x_fnar_message_32 IN VARCHAR2,
629 x_fnar_message_33 IN VARCHAR2,
630 x_fnar_message_34 IN VARCHAR2,
631 x_fnar_message_35 IN VARCHAR2,
632 x_fnar_message_36 IN VARCHAR2,
633 x_fnar_message_37 IN VARCHAR2,
634 x_fnar_message_38 IN VARCHAR2,
635 x_fnar_message_39 IN VARCHAR2,
636 x_fnar_message_45 IN VARCHAR2,
637 x_fnar_message_46 IN VARCHAR2,
638 x_fnar_message_47 IN VARCHAR2,
639 x_fnar_message_48 IN VARCHAR2,
640 x_fnar_message_50 IN VARCHAR2,
641 x_fnar_message_51 IN VARCHAR2,
642 x_fnar_message_52 IN VARCHAR2,
643 x_fnar_message_53 IN VARCHAR2,
644 x_fnar_message_56 IN VARCHAR2,
645 x_fnar_message_57 IN VARCHAR2,
646 x_fnar_message_58 IN VARCHAR2,
647 x_fnar_message_59 IN VARCHAR2,
648 x_fnar_message_60 IN VARCHAR2,
649 x_fnar_message_61 IN VARCHAR2,
650 x_fnar_message_62 IN VARCHAR2,
651 x_fnar_message_63 IN VARCHAR2,
652 x_fnar_message_64 IN VARCHAR2,
653 x_fnar_message_65 IN VARCHAR2,
654 x_fnar_message_71 IN VARCHAR2,
655 x_fnar_message_72 IN VARCHAR2,
656 x_fnar_message_73 IN VARCHAR2,
657 x_fnar_message_74 IN VARCHAR2,
658 x_fnar_message_75 IN VARCHAR2,
659 x_fnar_message_76 IN VARCHAR2,
660 x_fnar_message_77 IN VARCHAR2,
661 x_fnar_message_78 IN VARCHAR2,
662 x_fnar_mesg_10_stu_fam_mem IN VARCHAR2,
663 x_fnar_mesg_11_stu_no_in_coll IN VARCHAR2,
664 x_fnar_mesg_24_stu_avail_inc IN VARCHAR2,
665 x_fnar_mesg_26_stu_taxes IN VARCHAR2,
666 x_fnar_mesg_33_stu_home_value IN VARCHAR2,
667 x_fnar_mesg_34_stu_home_value IN VARCHAR2,
668 x_fnar_mesg_34_stu_home_equity IN VARCHAR2,
669 x_fnar_mesg_35_stu_home_value IN VARCHAR2,
670 x_fnar_mesg_35_stu_home_equity IN VARCHAR2,
671 x_fnar_mesg_36_stu_home_equity IN VARCHAR2,
672 x_fnar_mesg_48_par_fam_mem IN VARCHAR2,
673 x_fnar_mesg_49_par_no_in_coll IN VARCHAR2,
674 x_fnar_mesg_56_par_agi IN VARCHAR2,
675 x_fnar_mesg_62_par_taxes IN VARCHAR2,
676 x_fnar_mesg_73_par_home_value IN VARCHAR2,
677 x_fnar_mesg_74_par_home_value IN VARCHAR2,
678 x_fnar_mesg_74_par_home_equity IN VARCHAR2,
679 x_fnar_mesg_75_par_home_value IN VARCHAR2,
680 x_fnar_mesg_75_par_home_equity IN VARCHAR2,
681 x_fnar_mesg_76_par_home_equity IN VARCHAR2,
682 x_assumption_message_1 IN VARCHAR2,
683 x_assumption_message_2 IN VARCHAR2,
684 x_assumption_message_3 IN VARCHAR2,
685 x_assumption_message_4 IN VARCHAR2,
686 x_assumption_message_5 IN VARCHAR2,
687 x_assumption_message_6 IN VARCHAR2,
688 x_record_mark IN VARCHAR2,
689 x_option_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
690 x_option_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
691 x_option_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
692 x_option_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
693 x_option_par_cola_adj_value IN VARCHAR2 DEFAULT NULL,
694 x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
695 x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
696 x_p_soc_sec_ben_student_amt IN NUMBER DEFAULT NULL,
697 x_p_tuit_fee_deduct_amt IN NUMBER DEFAULT NULL,
701 x_location_computer_num IN NUMBER DEFAULT NULL,
698 x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
699 x_stu_lives_with_num IN NUMBER DEFAULT NULL,
700 x_stu_most_support_from_num IN NUMBER DEFAULT NULL,
702 x_cust_parent_cont_adj_num IN NUMBER DEFAULT NULL,
703 x_custodial_parent_num IN NUMBER DEFAULT NULL,
704 x_cust_par_base_prcnt_inc_amt IN NUMBER DEFAULT NULL,
705 x_cust_par_base_cont_inc_amt IN NUMBER DEFAULT NULL,
706 x_cust_par_base_cont_ast_amt IN NUMBER DEFAULT NULL,
707 x_cust_par_base_tot_cont_amt IN NUMBER DEFAULT NULL,
708 x_cust_par_opt_prcnt_inc_amt IN NUMBER DEFAULT NULL,
709 x_cust_par_opt_cont_inc_amt IN NUMBER DEFAULT NULL,
710 x_cust_par_opt_cont_ast_amt IN NUMBER DEFAULT NULL,
711 x_cust_par_opt_tot_cont_amt IN NUMBER DEFAULT NULL,
712 x_parents_email_txt IN VARCHAR2 DEFAULT NULL,
713 x_parent_1_birth_date IN DATE DEFAULT NULL,
714 x_parent_2_birth_date IN DATE DEFAULT NULL,
715 x_match_code IN VARCHAR2 DEFAULT NULL,
716 x_mode IN VARCHAR2 DEFAULT 'R'
717 );
718
719 PROCEDURE lock_row (
720 x_rowid IN VARCHAR2,
721 x_css_id IN NUMBER,
722 x_record_status IN VARCHAR2,
723 x_college_code IN VARCHAR2,
724 x_academic_year IN VARCHAR2,
725 x_stu_record_type IN VARCHAR2,
726 x_css_id_number IN VARCHAR2,
727 x_registration_receipt_date IN VARCHAR2,
728 x_registration_type IN VARCHAR2,
729 x_application_receipt_date IN VARCHAR2,
730 x_application_type IN VARCHAR2,
731 x_original_fnar_compute IN VARCHAR2,
732 x_revision_fnar_compute_date IN VARCHAR2,
733 x_electronic_extract_date IN VARCHAR2,
734 x_institutional_reporting_type IN VARCHAR2,
735 x_asr_receipt_date IN VARCHAR2,
736 x_last_name IN VARCHAR2,
737 x_first_name IN VARCHAR2,
738 x_middle_initial IN VARCHAR2,
739 x_address_number_and_street IN VARCHAR2,
740 x_city IN VARCHAR2,
741 x_state_mailing IN VARCHAR2,
742 x_zip_code IN VARCHAR2,
743 x_s_telephone_number IN VARCHAR2,
744 x_s_title IN VARCHAR2,
745 x_date_of_birth IN VARCHAR2,
746 x_social_security_number IN VARCHAR2,
747 x_state_legal_residence IN VARCHAR2,
748 x_foreign_address_indicator IN VARCHAR2,
749 x_foreign_postal_code IN VARCHAR2,
750 x_country IN VARCHAR2,
751 x_financial_aid_status IN VARCHAR2,
752 x_year_in_college IN VARCHAR2,
753 x_marital_status IN VARCHAR2,
754 x_ward_court IN VARCHAR2,
755 x_legal_dependents_other IN VARCHAR2,
756 x_household_size IN VARCHAR2,
757 x_number_in_college IN VARCHAR2,
758 x_citizenship_status IN VARCHAR2,
759 x_citizenship_country IN VARCHAR2,
760 x_visa_classification IN VARCHAR2,
761 x_tax_figures IN VARCHAR2,
762 x_number_exemptions IN VARCHAR2,
763 x_adjusted_gross_inc IN VARCHAR2,
764 x_us_tax_paid IN VARCHAR2,
765 x_itemized_deductions IN VARCHAR2,
766 x_stu_income_work IN VARCHAR2,
767 x_spouse_income_work IN VARCHAR2,
768 x_divid_int_inc IN VARCHAR2,
769 x_soc_sec_benefits IN VARCHAR2,
770 x_welfare_tanf IN VARCHAR2,
771 x_child_supp_rcvd IN VARCHAR2,
772 x_earned_income_credit IN VARCHAR2,
773 x_other_untax_income IN VARCHAR2,
774 x_tax_stu_aid IN VARCHAR2,
775 x_cash_sav_check IN VARCHAR2,
776 x_ira_keogh IN VARCHAR2,
777 x_invest_value IN VARCHAR2,
778 x_invest_debt IN VARCHAR2,
779 x_home_value IN VARCHAR2,
780 x_home_debt IN VARCHAR2,
781 x_oth_real_value IN VARCHAR2,
782 x_oth_real_debt IN VARCHAR2,
783 x_bus_farm_value IN VARCHAR2,
784 x_bus_farm_debt IN VARCHAR2,
785 x_live_on_farm IN VARCHAR2,
786 x_home_purch_price IN VARCHAR2,
787 x_hope_ll_credit IN VARCHAR2,
788 x_home_purch_year IN VARCHAR2,
789 x_trust_amount IN VARCHAR2,
790 x_trust_avail IN VARCHAR2,
791 x_trust_estab IN VARCHAR2,
795 x_vet_ben_amount IN VARCHAR2,
792 x_child_support_paid IN VARCHAR2,
793 x_med_dent_expenses IN VARCHAR2,
794 x_vet_us IN VARCHAR2,
796 x_vet_ben_months IN VARCHAR2,
797 x_stu_summer_wages IN VARCHAR2,
798 x_stu_school_yr_wages IN VARCHAR2,
799 x_spouse_summer_wages IN VARCHAR2,
800 x_spouse_school_yr_wages IN VARCHAR2,
801 x_summer_other_tax_inc IN VARCHAR2,
802 x_school_yr_other_tax_inc IN VARCHAR2,
803 x_summer_untax_inc IN VARCHAR2,
804 x_school_yr_untax_inc IN VARCHAR2,
805 x_grants_schol_etc IN VARCHAR2,
806 x_tuit_benefits IN VARCHAR2,
807 x_cont_parents IN VARCHAR2,
808 x_cont_relatives IN VARCHAR2,
809 x_p_siblings_pre_tuit IN VARCHAR2,
810 x_p_student_pre_tuit IN VARCHAR2,
811 x_p_household_size IN VARCHAR2,
812 x_p_number_in_college IN VARCHAR2,
813 x_p_parents_in_college IN VARCHAR2,
814 x_p_marital_status IN VARCHAR2,
815 x_p_state_legal_residence IN VARCHAR2,
816 x_p_natural_par_status IN VARCHAR2,
817 x_p_child_supp_paid IN VARCHAR2,
818 x_p_repay_ed_loans IN VARCHAR2,
819 x_p_med_dent_expenses IN VARCHAR2,
820 x_p_tuit_paid_amount IN VARCHAR2,
821 x_p_tuit_paid_number IN VARCHAR2,
822 x_p_exp_child_supp_paid IN VARCHAR2,
823 x_p_exp_repay_ed_loans IN VARCHAR2,
824 x_p_exp_med_dent_expenses IN VARCHAR2,
825 x_p_exp_tuit_pd_amount IN VARCHAR2,
826 x_p_exp_tuit_pd_number IN VARCHAR2,
827 x_p_cash_sav_check IN VARCHAR2,
828 x_p_month_mortgage_pay IN VARCHAR2,
829 x_p_invest_value IN VARCHAR2,
830 x_p_invest_debt IN VARCHAR2,
831 x_p_home_value IN VARCHAR2,
832 x_p_home_debt IN VARCHAR2,
833 x_p_home_purch_price IN VARCHAR2,
834 x_p_own_business_farm IN VARCHAR2,
835 x_p_business_value IN VARCHAR2,
836 x_p_business_debt IN VARCHAR2,
837 x_p_farm_value IN VARCHAR2,
838 x_p_farm_debt IN VARCHAR2,
839 x_p_live_on_farm IN VARCHAR2,
840 x_p_oth_real_estate_value IN VARCHAR2,
841 x_p_oth_real_estate_debt IN VARCHAR2,
842 x_p_oth_real_purch_price IN VARCHAR2,
843 x_p_siblings_assets IN VARCHAR2,
844 x_p_home_purch_year IN VARCHAR2,
845 x_p_oth_real_purch_year IN VARCHAR2,
846 x_p_prior_agi IN VARCHAR2,
847 x_p_prior_us_tax_paid IN VARCHAR2,
848 x_p_prior_item_deductions IN VARCHAR2,
849 x_p_prior_other_untax_inc IN VARCHAR2,
850 x_p_tax_figures IN VARCHAR2,
851 x_p_number_exemptions IN VARCHAR2,
852 x_p_adjusted_gross_inc IN VARCHAR2,
853 x_p_wages_sal_tips IN VARCHAR2,
854 x_p_interest_income IN VARCHAR2,
855 x_p_dividend_income IN VARCHAR2,
856 x_p_net_inc_bus_farm IN VARCHAR2,
857 x_p_other_taxable_income IN VARCHAR2,
858 x_p_adj_to_income IN VARCHAR2,
859 x_p_us_tax_paid IN VARCHAR2,
860 x_p_itemized_deductions IN VARCHAR2,
861 x_p_father_income_work IN VARCHAR2,
862 x_p_mother_income_work IN VARCHAR2,
863 x_p_soc_sec_ben IN VARCHAR2,
864 x_p_welfare_tanf IN VARCHAR2,
865 x_p_child_supp_rcvd IN VARCHAR2,
866 x_p_ded_ira_keogh IN VARCHAR2,
867 x_p_tax_defer_pens_savs IN VARCHAR2,
868 x_p_dep_care_med_spending IN VARCHAR2,
869 x_p_earned_income_credit IN VARCHAR2,
870 x_p_living_allow IN VARCHAR2,
871 x_p_tax_exmpt_int IN VARCHAR2,
872 x_p_foreign_inc_excl IN VARCHAR2,
873 x_p_other_untax_inc IN VARCHAR2,
874 x_p_hope_ll_credit IN VARCHAR2,
875 x_p_yr_separation IN VARCHAR2,
876 x_p_yr_divorce IN VARCHAR2,
877 x_p_exp_father_inc IN VARCHAR2,
878 x_p_exp_mother_inc IN VARCHAR2,
879 x_p_exp_other_tax_inc IN VARCHAR2,
880 x_p_exp_other_untax_inc IN VARCHAR2,
881 x_line_2_relation IN VARCHAR2,
882 x_line_2_attend_college IN VARCHAR2,
883 x_line_3_relation IN VARCHAR2,
884 x_line_3_attend_college IN VARCHAR2,
885 x_line_4_relation IN VARCHAR2,
886 x_line_4_attend_college IN VARCHAR2,
887 x_line_5_relation IN VARCHAR2,
891 x_line_7_relation IN VARCHAR2,
888 x_line_5_attend_college IN VARCHAR2,
889 x_line_6_relation IN VARCHAR2,
890 x_line_6_attend_college IN VARCHAR2,
892 x_line_7_attend_college IN VARCHAR2,
893 x_line_8_relation IN VARCHAR2,
894 x_line_8_attend_college IN VARCHAR2,
895 x_p_age_father IN VARCHAR2,
896 x_p_age_mother IN VARCHAR2,
897 x_p_div_sep_ind IN VARCHAR2,
898 x_b_cont_non_custodial_par IN VARCHAR2,
899 x_college_type_2 IN VARCHAR2,
900 x_college_type_3 IN VARCHAR2,
901 x_college_type_4 IN VARCHAR2,
902 x_college_type_5 IN VARCHAR2,
903 x_college_type_6 IN VARCHAR2,
904 x_college_type_7 IN VARCHAR2,
905 x_college_type_8 IN VARCHAR2,
906 x_school_code_1 IN VARCHAR2,
907 x_housing_code_1 IN VARCHAR2,
908 x_school_code_2 IN VARCHAR2,
909 x_housing_code_2 IN VARCHAR2,
910 x_school_code_3 IN VARCHAR2,
911 x_housing_code_3 IN VARCHAR2,
912 x_school_code_4 IN VARCHAR2,
913 x_housing_code_4 IN VARCHAR2,
914 x_school_code_5 IN VARCHAR2,
915 x_housing_code_5 IN VARCHAR2,
916 x_school_code_6 IN VARCHAR2,
917 x_housing_code_6 IN VARCHAR2,
918 x_school_code_7 IN VARCHAR2,
919 x_housing_code_7 IN VARCHAR2,
920 x_school_code_8 IN VARCHAR2,
921 x_housing_code_8 IN VARCHAR2,
922 x_school_code_9 IN VARCHAR2,
923 x_housing_code_9 IN VARCHAR2,
924 x_school_code_10 IN VARCHAR2,
925 x_housing_code_10 IN VARCHAR2,
926 x_additional_school_code_1 IN VARCHAR2,
927 x_additional_school_code_2 IN VARCHAR2,
928 x_additional_school_code_3 IN VARCHAR2,
929 x_additional_school_code_4 IN VARCHAR2,
930 x_additional_school_code_5 IN VARCHAR2,
931 x_additional_school_code_6 IN VARCHAR2,
932 x_additional_school_code_7 IN VARCHAR2,
933 x_additional_school_code_8 IN VARCHAR2,
934 x_additional_school_code_9 IN VARCHAR2,
935 x_additional_school_code_10 IN VARCHAR2,
936 x_explanation_spec_circum IN VARCHAR2,
937 x_signature_student IN VARCHAR2,
938 x_signature_spouse IN VARCHAR2,
939 x_signature_father IN VARCHAR2,
940 x_signature_mother IN VARCHAR2,
941 x_month_day_completed IN VARCHAR2,
942 x_year_completed IN VARCHAR2,
943 x_age_line_2 IN VARCHAR2,
944 x_age_line_3 IN VARCHAR2,
945 x_age_line_4 IN VARCHAR2,
946 x_age_line_5 IN VARCHAR2,
947 x_age_line_6 IN VARCHAR2,
948 x_age_line_7 IN VARCHAR2,
949 x_age_line_8 IN VARCHAR2,
950 x_a_online_signature IN VARCHAR2,
951 x_question_1_number IN VARCHAR2,
952 x_question_1_size IN VARCHAR2,
953 x_question_1_answer IN VARCHAR2,
954 x_question_2_number IN VARCHAR2,
955 x_question_2_size IN VARCHAR2,
956 x_question_2_answer IN VARCHAR2,
957 x_question_3_number IN VARCHAR2,
958 x_question_3_size IN VARCHAR2,
959 x_question_3_answer IN VARCHAR2,
960 x_question_4_number IN VARCHAR2,
961 x_question_4_size IN VARCHAR2,
962 x_question_4_answer IN VARCHAR2,
963 x_question_5_number IN VARCHAR2,
964 x_question_5_size IN VARCHAR2,
965 x_question_5_answer IN VARCHAR2,
966 x_question_6_number IN VARCHAR2,
967 x_question_6_size IN VARCHAR2,
968 x_question_6_answer IN VARCHAR2,
969 x_question_7_number IN VARCHAR2,
970 x_question_7_size IN VARCHAR2,
971 x_question_7_answer IN VARCHAR2,
972 x_question_8_number IN VARCHAR2,
973 x_question_8_size IN VARCHAR2,
974 x_question_8_answer IN VARCHAR2,
975 x_question_9_number IN VARCHAR2,
976 x_question_9_size IN VARCHAR2,
977 x_question_9_answer IN VARCHAR2,
978 x_question_10_number IN VARCHAR2,
979 x_question_10_size IN VARCHAR2,
980 x_question_10_answer IN VARCHAR2,
981 x_question_11_number IN VARCHAR2,
982 x_question_11_size IN VARCHAR2,
986 x_question_12_answer IN VARCHAR2,
983 x_question_11_answer IN VARCHAR2,
984 x_question_12_number IN VARCHAR2,
985 x_question_12_size IN VARCHAR2,
987 x_question_13_number IN VARCHAR2,
988 x_question_13_size IN VARCHAR2,
989 x_question_13_answer IN VARCHAR2,
990 x_question_14_number IN VARCHAR2,
991 x_question_14_size IN VARCHAR2,
992 x_question_14_answer IN VARCHAR2,
993 x_question_15_number IN VARCHAR2,
994 x_question_15_size IN VARCHAR2,
995 x_question_15_answer IN VARCHAR2,
996 x_question_16_number IN VARCHAR2,
997 x_question_16_size IN VARCHAR2,
998 x_question_16_answer IN VARCHAR2,
999 x_question_17_number IN VARCHAR2,
1000 x_question_17_size IN VARCHAR2,
1001 x_question_17_answer IN VARCHAR2,
1002 x_question_18_number IN VARCHAR2,
1003 x_question_18_size IN VARCHAR2,
1004 x_question_18_answer IN VARCHAR2,
1005 x_question_19_number IN VARCHAR2,
1006 x_question_19_size IN VARCHAR2,
1007 x_question_19_answer IN VARCHAR2,
1008 x_question_20_number IN VARCHAR2,
1009 x_question_20_size IN VARCHAR2,
1010 x_question_20_answer IN VARCHAR2,
1011 x_question_21_number IN VARCHAR2,
1012 x_question_21_size IN VARCHAR2,
1013 x_question_21_answer IN VARCHAR2,
1014 x_question_22_number IN VARCHAR2,
1015 x_question_22_size IN VARCHAR2,
1016 x_question_22_answer IN VARCHAR2,
1017 x_question_23_number IN VARCHAR2,
1018 x_question_23_size IN VARCHAR2,
1019 x_question_23_answer IN VARCHAR2,
1020 x_question_24_number IN VARCHAR2,
1021 x_question_24_size IN VARCHAR2,
1022 x_question_24_answer IN VARCHAR2,
1023 x_question_25_number IN VARCHAR2,
1024 x_question_25_size IN VARCHAR2,
1025 x_question_25_answer IN VARCHAR2,
1026 x_question_26_number IN VARCHAR2,
1027 x_question_26_size IN VARCHAR2,
1028 x_question_26_answer IN VARCHAR2,
1029 x_question_27_number IN VARCHAR2,
1030 x_question_27_size IN VARCHAR2,
1031 x_question_27_answer IN VARCHAR2,
1032 x_question_28_number IN VARCHAR2,
1033 x_question_28_size IN VARCHAR2,
1034 x_question_28_answer IN VARCHAR2,
1035 x_question_29_number IN VARCHAR2,
1036 x_question_29_size IN VARCHAR2,
1037 x_question_29_answer IN VARCHAR2,
1038 x_question_30_number IN VARCHAR2,
1039 x_questions_30_size IN VARCHAR2,
1040 x_question_30_answer IN VARCHAR2,
1041 x_r_s_email_address IN VARCHAR2,
1042 x_eps_code IN VARCHAR2,
1043 x_comp_css_dependency_status IN VARCHAR2,
1044 x_stu_age IN VARCHAR2,
1045 x_assumed_stu_yr_in_coll IN VARCHAR2,
1046 x_comp_stu_marital_status IN VARCHAR2,
1047 x_stu_family_members IN VARCHAR2,
1048 x_stu_fam_members_in_college IN VARCHAR2,
1049 x_par_marital_status IN VARCHAR2,
1050 x_par_family_members IN VARCHAR2,
1051 x_par_total_in_college IN VARCHAR2,
1052 x_par_par_in_college IN VARCHAR2,
1053 x_par_others_in_college IN VARCHAR2,
1054 x_par_aesa IN VARCHAR2,
1055 x_par_cesa IN VARCHAR2,
1056 x_stu_aesa IN VARCHAR2,
1057 x_stu_cesa IN VARCHAR2,
1058 x_im_p_bas_agi_taxable_income IN VARCHAR2,
1059 x_im_p_bas_untx_inc_and_ben IN VARCHAR2,
1060 x_im_p_bas_inc_adj IN VARCHAR2,
1061 x_im_p_bas_total_income IN VARCHAR2,
1062 x_im_p_bas_us_income_tax IN VARCHAR2,
1063 x_im_p_bas_st_and_other_tax IN VARCHAR2,
1064 x_im_p_bas_fica_tax IN VARCHAR2,
1065 x_im_p_bas_med_dental IN VARCHAR2,
1066 x_im_p_bas_employment_allow IN VARCHAR2,
1067 x_im_p_bas_annual_ed_savings IN VARCHAR2,
1068 x_im_p_bas_inc_prot_allow_m IN VARCHAR2,
1069 x_im_p_bas_total_inc_allow IN VARCHAR2,
1070 x_im_p_bas_cal_avail_inc IN VARCHAR2,
1071 x_im_p_bas_avail_income IN VARCHAR2,
1072 x_im_p_bas_total_cont_inc IN VARCHAR2,
1073 x_im_p_bas_cash_bank_accounts IN VARCHAR2,
1074 x_im_p_bas_home_equity IN VARCHAR2,
1075 x_im_p_bas_ot_rl_est_inv_eq IN VARCHAR2,
1076 x_im_p_bas_adj_bus_farm_worth IN VARCHAR2,
1077 x_im_p_bas_ass_sibs_pre_tui IN VARCHAR2,
1078 x_im_p_bas_net_worth IN VARCHAR2,
1082 x_im_p_bas_total_asset_allow IN VARCHAR2,
1079 x_im_p_bas_emerg_res_allow IN VARCHAR2,
1080 x_im_p_bas_cum_ed_savings IN VARCHAR2,
1081 x_im_p_bas_low_inc_allow IN VARCHAR2,
1083 x_im_p_bas_disc_net_worth IN VARCHAR2,
1084 x_im_p_bas_total_cont_asset IN VARCHAR2,
1085 x_im_p_bas_total_cont IN VARCHAR2,
1086 x_im_p_bas_num_in_coll_adj IN VARCHAR2,
1087 x_im_p_bas_cont_for_stu IN VARCHAR2,
1088 x_im_p_bas_cont_from_income IN VARCHAR2,
1089 x_im_p_bas_cont_from_assets IN VARCHAR2,
1090 x_im_p_opt_agi_taxable_income IN VARCHAR2,
1091 x_im_p_opt_untx_inc_and_ben IN VARCHAR2,
1092 x_im_p_opt_inc_adj IN VARCHAR2,
1093 x_im_p_opt_total_income IN VARCHAR2,
1094 x_im_p_opt_us_income_tax IN VARCHAR2,
1095 x_im_p_opt_st_and_other_tax IN VARCHAR2,
1096 x_im_p_opt_fica_tax IN VARCHAR2,
1097 x_im_p_opt_med_dental IN VARCHAR2,
1098 x_im_p_opt_elem_sec_tuit IN VARCHAR2,
1099 x_im_p_opt_employment_allow IN VARCHAR2,
1100 x_im_p_opt_annual_ed_savings IN VARCHAR2,
1101 x_im_p_opt_inc_prot_allow_m IN VARCHAR2,
1102 x_im_p_opt_total_inc_allow IN VARCHAR2,
1103 x_im_p_opt_cal_avail_inc IN VARCHAR2,
1104 x_im_p_opt_avail_income IN VARCHAR2,
1105 x_im_p_opt_total_cont_inc IN VARCHAR2,
1106 x_im_p_opt_cash_bank_accounts IN VARCHAR2,
1107 x_im_p_opt_home_equity IN VARCHAR2,
1108 x_im_p_opt_ot_rl_est_inv_eq IN VARCHAR2,
1109 x_im_p_opt_adj_bus_farm_worth IN VARCHAR2,
1110 x_im_p_opt_ass_sibs_pre_t IN VARCHAR2,
1111 x_im_p_opt_net_worth IN VARCHAR2,
1112 x_im_p_opt_emerg_res_allow IN VARCHAR2,
1113 x_im_p_opt_cum_ed_savings IN VARCHAR2,
1114 x_im_p_opt_low_inc_allow IN VARCHAR2,
1115 x_im_p_opt_total_asset_allow IN VARCHAR2,
1116 x_im_p_opt_disc_net_worth IN VARCHAR2,
1117 x_im_p_opt_total_cont_asset IN VARCHAR2,
1118 x_im_p_opt_total_cont IN VARCHAR2,
1119 x_im_p_opt_num_in_coll_adj IN VARCHAR2,
1120 x_im_p_opt_cont_for_stu IN VARCHAR2,
1121 x_im_p_opt_cont_from_income IN VARCHAR2,
1122 x_im_p_opt_cont_from_assets IN VARCHAR2,
1123 x_fm_p_analysis_type IN VARCHAR2,
1124 x_fm_p_agi_taxable_income IN VARCHAR2,
1125 x_fm_p_untx_inc_and_ben IN VARCHAR2,
1126 x_fm_p_inc_adj IN VARCHAR2,
1127 x_fm_p_total_income IN VARCHAR2,
1128 x_fm_p_us_income_tax IN VARCHAR2,
1129 x_fm_p_state_and_other_taxes IN VARCHAR2,
1130 x_fm_p_fica_tax IN VARCHAR2,
1131 x_fm_p_employment_allow IN VARCHAR2,
1132 x_fm_p_income_prot_allow IN VARCHAR2,
1133 x_fm_p_total_allow IN VARCHAR2,
1134 x_fm_p_avail_income IN VARCHAR2,
1135 x_fm_p_cash_bank_accounts IN VARCHAR2,
1136 x_fm_p_ot_rl_est_inv_eq IN VARCHAR2,
1137 x_fm_p_adj_bus_farm_net_worth IN VARCHAR2,
1138 x_fm_p_net_worth IN VARCHAR2,
1139 x_fm_p_asset_prot_allow IN VARCHAR2,
1140 x_fm_p_disc_net_worth IN VARCHAR2,
1141 x_fm_p_total_contribution IN VARCHAR2,
1142 x_fm_p_num_in_coll IN VARCHAR2,
1143 x_fm_p_cont_for_stu IN VARCHAR2,
1144 x_fm_p_cont_from_income IN VARCHAR2,
1145 x_fm_p_cont_from_assets IN VARCHAR2,
1146 x_im_s_bas_agi_taxable_income IN VARCHAR2,
1147 x_im_s_bas_untx_inc_and_ben IN VARCHAR2,
1148 x_im_s_bas_inc_adj IN VARCHAR2,
1149 x_im_s_bas_total_income IN VARCHAR2,
1150 x_im_s_bas_us_income_tax IN VARCHAR2,
1151 x_im_s_bas_st_and_oth_tax IN VARCHAR2,
1152 x_im_s_bas_fica_tax IN VARCHAR2,
1153 x_im_s_bas_med_dental IN VARCHAR2,
1154 x_im_s_bas_employment_allow IN VARCHAR2,
1155 x_im_s_bas_annual_ed_savings IN VARCHAR2,
1156 x_im_s_bas_inc_prot_allow_m IN VARCHAR2,
1157 x_im_s_bas_total_inc_allow IN VARCHAR2,
1158 x_im_s_bas_cal_avail_income IN VARCHAR2,
1159 x_im_s_bas_avail_income IN VARCHAR2,
1160 x_im_s_bas_total_cont_inc IN VARCHAR2,
1161 x_im_s_bas_cash_bank_accounts IN VARCHAR2,
1162 x_im_s_bas_home_equity IN VARCHAR2,
1163 x_im_s_bas_ot_rl_est_inv_eq IN VARCHAR2,
1164 x_im_s_bas_adj_bus_farm_worth IN VARCHAR2,
1165 x_im_s_bas_trusts IN VARCHAR2,
1166 x_im_s_bas_net_worth IN VARCHAR2,
1167 x_im_s_bas_emerg_res_allow IN VARCHAR2,
1168 x_im_s_bas_cum_ed_savings IN VARCHAR2,
1169 x_im_s_bas_total_asset_allow IN VARCHAR2,
1170 x_im_s_bas_disc_net_worth IN VARCHAR2,
1171 x_im_s_bas_total_cont_asset IN VARCHAR2,
1172 x_im_s_bas_total_cont IN VARCHAR2,
1173 x_im_s_bas_num_in_coll_adj IN VARCHAR2,
1174 x_im_s_bas_cont_for_stu IN VARCHAR2,
1178 x_im_s_est_untx_inc_and_ben IN VARCHAR2,
1175 x_im_s_bas_cont_from_income IN VARCHAR2,
1176 x_im_s_bas_cont_from_assets IN VARCHAR2,
1177 x_im_s_est_agi_taxable_income IN VARCHAR2,
1179 x_im_s_est_inc_adj IN VARCHAR2,
1180 x_im_s_est_total_income IN VARCHAR2,
1181 x_im_s_est_us_income_tax IN VARCHAR2,
1182 x_im_s_est_st_and_oth_tax IN VARCHAR2,
1183 x_im_s_est_fica_tax IN VARCHAR2,
1184 x_im_s_est_med_dental IN VARCHAR2,
1185 x_im_s_est_employment_allow IN VARCHAR2,
1186 x_im_s_est_annual_ed_savings IN VARCHAR2,
1187 x_im_s_est_inc_prot_allow_m IN VARCHAR2,
1188 x_im_s_est_total_inc_allow IN VARCHAR2,
1189 x_im_s_est_cal_avail_income IN VARCHAR2,
1190 x_im_s_est_avail_income IN VARCHAR2,
1191 x_im_s_est_total_cont_inc IN VARCHAR2,
1192 x_im_s_est_cash_bank_accounts IN VARCHAR2,
1193 x_im_s_est_home_equity IN VARCHAR2,
1194 x_im_s_est_ot_rl_est_inv_equ IN VARCHAR2,
1195 x_im_s_est_adj_bus_farm_worth IN VARCHAR2,
1196 x_im_s_est_est_trusts IN VARCHAR2,
1197 x_im_s_est_net_worth IN VARCHAR2,
1198 x_im_s_est_emerg_res_allow IN VARCHAR2,
1199 x_im_s_est_cum_ed_savings IN VARCHAR2,
1200 x_im_s_est_total_asset_allow IN VARCHAR2,
1201 x_im_s_est_disc_net_worth IN VARCHAR2,
1202 x_im_s_est_total_cont_asset IN VARCHAR2,
1203 x_im_s_est_total_cont IN VARCHAR2,
1204 x_im_s_est_num_in_coll_adj IN VARCHAR2,
1205 x_im_s_est_cont_for_stu IN VARCHAR2,
1206 x_im_s_est_cont_from_income IN VARCHAR2,
1207 x_im_s_est_cont_from_assets IN VARCHAR2,
1208 x_im_s_opt_agi_taxable_income IN VARCHAR2,
1209 x_im_s_opt_untx_inc_and_ben IN VARCHAR2,
1210 x_im_s_opt_inc_adj IN VARCHAR2,
1211 x_im_s_opt_total_income IN VARCHAR2,
1212 x_im_s_opt_us_income_tax IN VARCHAR2,
1213 x_im_s_opt_state_and_oth_taxes IN VARCHAR2,
1214 x_im_s_opt_fica_tax IN VARCHAR2,
1215 x_im_s_opt_med_dental IN VARCHAR2,
1216 x_im_s_opt_employment_allow IN VARCHAR2,
1217 x_im_s_opt_annual_ed_savings IN VARCHAR2,
1218 x_im_s_opt_inc_prot_allow_m IN VARCHAR2,
1219 x_im_s_opt_total_inc_allow IN VARCHAR2,
1220 x_im_s_opt_cal_avail_income IN VARCHAR2,
1221 x_im_s_opt_avail_income IN VARCHAR2,
1222 x_im_s_opt_total_cont_inc IN VARCHAR2,
1223 x_im_s_opt_cash_bank_accounts IN VARCHAR2,
1224 x_im_s_opt_ira_keogh_accounts IN VARCHAR2,
1225 x_im_s_opt_home_equity IN VARCHAR2,
1226 x_im_s_opt_ot_rl_est_inv_eq IN VARCHAR2,
1227 x_im_s_opt_adj_bus_farm_worth IN VARCHAR2,
1228 x_im_s_opt_trusts IN VARCHAR2,
1229 x_im_s_opt_net_worth IN VARCHAR2,
1230 x_im_s_opt_emerg_res_allow IN VARCHAR2,
1231 x_im_s_opt_cum_ed_savings IN VARCHAR2,
1232 x_im_s_opt_total_asset_allow IN VARCHAR2,
1233 x_im_s_opt_disc_net_worth IN VARCHAR2,
1234 x_im_s_opt_total_cont_asset IN VARCHAR2,
1235 x_im_s_opt_total_cont IN VARCHAR2,
1236 x_im_s_opt_num_in_coll_adj IN VARCHAR2,
1237 x_im_s_opt_cont_for_stu IN VARCHAR2,
1238 x_im_s_opt_cont_from_income IN VARCHAR2,
1239 x_im_s_opt_cont_from_assets IN VARCHAR2,
1240 x_fm_s_analysis_type IN VARCHAR2,
1241 x_fm_s_agi_taxable_income IN VARCHAR2,
1242 x_fm_s_untx_inc_and_ben IN VARCHAR2,
1243 x_fm_s_inc_adj IN VARCHAR2,
1244 x_fm_s_total_income IN VARCHAR2,
1245 x_fm_s_us_income_tax IN VARCHAR2,
1246 x_fm_s_state_and_oth_taxes IN VARCHAR2,
1247 x_fm_s_fica_tax IN VARCHAR2,
1248 x_fm_s_employment_allow IN VARCHAR2,
1249 x_fm_s_income_prot_allow IN VARCHAR2,
1250 x_fm_s_total_allow IN VARCHAR2,
1251 x_fm_s_cal_avail_income IN VARCHAR2,
1252 x_fm_s_avail_income IN VARCHAR2,
1253 x_fm_s_cash_bank_accounts IN VARCHAR2,
1254 x_fm_s_ot_rl_est_inv_equity IN VARCHAR2,
1255 x_fm_s_adj_bus_farm_worth IN VARCHAR2,
1256 x_fm_s_trusts IN VARCHAR2,
1257 x_fm_s_net_worth IN VARCHAR2,
1258 x_fm_s_asset_prot_allow IN VARCHAR2,
1259 x_fm_s_disc_net_worth IN VARCHAR2,
1260 x_fm_s_total_cont IN VARCHAR2,
1261 x_fm_s_num_in_coll IN VARCHAR2,
1262 x_fm_s_cont_for_stu IN VARCHAR2,
1263 x_fm_s_cont_from_income IN VARCHAR2,
1264 x_fm_s_cont_from_assets IN VARCHAR2,
1265 x_im_inst_resident_ind IN VARCHAR2,
1266 x_institutional_1_budget_name IN VARCHAR2,
1267 x_im_inst_1_budget_duration IN VARCHAR2,
1268 x_im_inst_1_tuition_fees IN VARCHAR2,
1269 x_im_inst_1_books_supplies IN VARCHAR2,
1270 x_im_inst_1_living_expenses IN VARCHAR2,
1274 x_im_inst_1_tot_family_cont IN VARCHAR2,
1271 x_im_inst_1_tot_expenses IN VARCHAR2,
1272 x_im_inst_1_tot_stu_cont IN VARCHAR2,
1273 x_im_inst_1_tot_par_cont IN VARCHAR2,
1275 x_im_inst_1_va_benefits IN VARCHAR2,
1276 x_im_inst_1_ot_cont IN VARCHAR2,
1277 x_im_inst_1_est_financial_need IN VARCHAR2,
1278 x_institutional_2_budget_name IN VARCHAR2,
1279 x_im_inst_2_budget_duration IN VARCHAR2,
1280 x_im_inst_2_tuition_fees IN VARCHAR2,
1281 x_im_inst_2_books_supplies IN VARCHAR2,
1282 x_im_inst_2_living_expenses IN VARCHAR2,
1283 x_im_inst_2_tot_expenses IN VARCHAR2,
1284 x_im_inst_2_tot_stu_cont IN VARCHAR2,
1285 x_im_inst_2_tot_par_cont IN VARCHAR2,
1286 x_im_inst_2_tot_family_cont IN VARCHAR2,
1287 x_im_inst_2_va_benefits IN VARCHAR2,
1288 x_im_inst_2_est_financial_need IN VARCHAR2,
1289 x_institutional_3_budget_name IN VARCHAR2,
1290 x_im_inst_3_budget_duration IN VARCHAR2,
1291 x_im_inst_3_tuition_fees IN VARCHAR2,
1292 x_im_inst_3_books_supplies IN VARCHAR2,
1293 x_im_inst_3_living_expenses IN VARCHAR2,
1294 x_im_inst_3_tot_expenses IN VARCHAR2,
1295 x_im_inst_3_tot_stu_cont IN VARCHAR2,
1296 x_im_inst_3_tot_par_cont IN VARCHAR2,
1297 x_im_inst_3_tot_family_cont IN VARCHAR2,
1298 x_im_inst_3_va_benefits IN VARCHAR2,
1299 x_im_inst_3_est_financial_need IN VARCHAR2,
1300 x_fm_inst_1_federal_efc IN VARCHAR2,
1301 x_fm_inst_1_va_benefits IN VARCHAR2,
1302 x_fm_inst_1_fed_eligibility IN VARCHAR2,
1303 x_fm_inst_1_pell IN VARCHAR2,
1304 x_option_par_loss_allow_ind IN VARCHAR2,
1305 x_option_par_tuition_ind IN VARCHAR2,
1306 x_option_par_home_ind IN VARCHAR2,
1307 x_option_par_home_value IN VARCHAR2,
1308 x_option_par_home_debt IN VARCHAR2,
1309 x_option_stu_ira_keogh_ind IN VARCHAR2,
1310 x_option_stu_home_ind IN VARCHAR2,
1311 x_option_stu_home_value IN VARCHAR2,
1312 x_option_stu_home_debt IN VARCHAR2,
1313 x_option_stu_sum_ay_inc_ind IN VARCHAR2,
1314 x_option_par_hope_ll_credit IN VARCHAR2,
1315 x_option_stu_hope_ll_credit IN VARCHAR2,
1316 x_im_parent_1_8_months_bas IN VARCHAR2,
1317 x_im_p_more_than_9_mth_ba IN VARCHAR2,
1318 x_im_parent_1_8_months_opt IN VARCHAR2,
1319 x_im_p_more_than_9_mth_op IN VARCHAR2,
1320 x_fnar_message_1 IN VARCHAR2,
1321 x_fnar_message_2 IN VARCHAR2,
1322 x_fnar_message_3 IN VARCHAR2,
1323 x_fnar_message_4 IN VARCHAR2,
1324 x_fnar_message_5 IN VARCHAR2,
1325 x_fnar_message_6 IN VARCHAR2,
1326 x_fnar_message_7 IN VARCHAR2,
1327 x_fnar_message_8 IN VARCHAR2,
1328 x_fnar_message_9 IN VARCHAR2,
1329 x_fnar_message_10 IN VARCHAR2,
1330 x_fnar_message_11 IN VARCHAR2,
1331 x_fnar_message_12 IN VARCHAR2,
1332 x_fnar_message_13 IN VARCHAR2,
1333 x_fnar_message_20 IN VARCHAR2,
1334 x_fnar_message_21 IN VARCHAR2,
1335 x_fnar_message_22 IN VARCHAR2,
1336 x_fnar_message_23 IN VARCHAR2,
1337 x_fnar_message_24 IN VARCHAR2,
1338 x_fnar_message_25 IN VARCHAR2,
1339 x_fnar_message_26 IN VARCHAR2,
1340 x_fnar_message_27 IN VARCHAR2,
1341 x_fnar_message_30 IN VARCHAR2,
1342 x_fnar_message_31 IN VARCHAR2,
1343 x_fnar_message_32 IN VARCHAR2,
1344 x_fnar_message_33 IN VARCHAR2,
1345 x_fnar_message_34 IN VARCHAR2,
1346 x_fnar_message_35 IN VARCHAR2,
1347 x_fnar_message_36 IN VARCHAR2,
1348 x_fnar_message_37 IN VARCHAR2,
1349 x_fnar_message_38 IN VARCHAR2,
1350 x_fnar_message_39 IN VARCHAR2,
1351 x_fnar_message_45 IN VARCHAR2,
1352 x_fnar_message_46 IN VARCHAR2,
1353 x_fnar_message_47 IN VARCHAR2,
1354 x_fnar_message_48 IN VARCHAR2,
1355 x_fnar_message_50 IN VARCHAR2,
1356 x_fnar_message_51 IN VARCHAR2,
1357 x_fnar_message_52 IN VARCHAR2,
1358 x_fnar_message_53 IN VARCHAR2,
1359 x_fnar_message_56 IN VARCHAR2,
1360 x_fnar_message_57 IN VARCHAR2,
1361 x_fnar_message_58 IN VARCHAR2,
1362 x_fnar_message_59 IN VARCHAR2,
1363 x_fnar_message_60 IN VARCHAR2,
1364 x_fnar_message_61 IN VARCHAR2,
1365 x_fnar_message_62 IN VARCHAR2,
1366 x_fnar_message_63 IN VARCHAR2,
1370 x_fnar_message_72 IN VARCHAR2,
1367 x_fnar_message_64 IN VARCHAR2,
1368 x_fnar_message_65 IN VARCHAR2,
1369 x_fnar_message_71 IN VARCHAR2,
1371 x_fnar_message_73 IN VARCHAR2,
1372 x_fnar_message_74 IN VARCHAR2,
1373 x_fnar_message_75 IN VARCHAR2,
1374 x_fnar_message_76 IN VARCHAR2,
1375 x_fnar_message_77 IN VARCHAR2,
1376 x_fnar_message_78 IN VARCHAR2,
1377 x_fnar_mesg_10_stu_fam_mem IN VARCHAR2,
1378 x_fnar_mesg_11_stu_no_in_coll IN VARCHAR2,
1379 x_fnar_mesg_24_stu_avail_inc IN VARCHAR2,
1380 x_fnar_mesg_26_stu_taxes IN VARCHAR2,
1381 x_fnar_mesg_33_stu_home_value IN VARCHAR2,
1382 x_fnar_mesg_34_stu_home_value IN VARCHAR2,
1383 x_fnar_mesg_34_stu_home_equity IN VARCHAR2,
1384 x_fnar_mesg_35_stu_home_value IN VARCHAR2,
1385 x_fnar_mesg_35_stu_home_equity IN VARCHAR2,
1386 x_fnar_mesg_36_stu_home_equity IN VARCHAR2,
1387 x_fnar_mesg_48_par_fam_mem IN VARCHAR2,
1388 x_fnar_mesg_49_par_no_in_coll IN VARCHAR2,
1389 x_fnar_mesg_56_par_agi IN VARCHAR2,
1390 x_fnar_mesg_62_par_taxes IN VARCHAR2,
1391 x_fnar_mesg_73_par_home_value IN VARCHAR2,
1392 x_fnar_mesg_74_par_home_value IN VARCHAR2,
1393 x_fnar_mesg_74_par_home_equity IN VARCHAR2,
1394 x_fnar_mesg_75_par_home_value IN VARCHAR2,
1395 x_fnar_mesg_75_par_home_equity IN VARCHAR2,
1396 x_fnar_mesg_76_par_home_equity IN VARCHAR2,
1397 x_assumption_message_1 IN VARCHAR2,
1398 x_assumption_message_2 IN VARCHAR2,
1399 x_assumption_message_3 IN VARCHAR2,
1400 x_assumption_message_4 IN VARCHAR2,
1401 x_assumption_message_5 IN VARCHAR2,
1402 x_assumption_message_6 IN VARCHAR2,
1403 x_record_mark IN VARCHAR2,
1404 x_option_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
1405 x_option_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
1406 x_option_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
1407 x_option_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
1408 x_option_par_cola_adj_value IN VARCHAR2 DEFAULT NULL,
1409 x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
1410 x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
1411 x_p_soc_sec_ben_student_amt IN NUMBER DEFAULT NULL,
1412 x_p_tuit_fee_deduct_amt IN NUMBER DEFAULT NULL,
1413 x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
1414 x_stu_lives_with_num IN NUMBER DEFAULT NULL,
1415 x_stu_most_support_from_num IN NUMBER DEFAULT NULL,
1416 x_location_computer_num IN NUMBER DEFAULT NULL,
1417 x_cust_parent_cont_adj_num IN NUMBER DEFAULT NULL,
1418 x_custodial_parent_num IN NUMBER DEFAULT NULL,
1419 x_cust_par_base_prcnt_inc_amt IN NUMBER DEFAULT NULL,
1420 x_cust_par_base_cont_inc_amt IN NUMBER DEFAULT NULL,
1421 x_cust_par_base_cont_ast_amt IN NUMBER DEFAULT NULL,
1422 x_cust_par_base_tot_cont_amt IN NUMBER DEFAULT NULL,
1423 x_cust_par_opt_prcnt_inc_amt IN NUMBER DEFAULT NULL,
1424 x_cust_par_opt_cont_inc_amt IN NUMBER DEFAULT NULL,
1425 x_cust_par_opt_cont_ast_amt IN NUMBER DEFAULT NULL,
1426 x_cust_par_opt_tot_cont_amt IN NUMBER DEFAULT NULL,
1427 x_parents_email_txt IN VARCHAR2 DEFAULT NULL,
1428 x_parent_1_birth_date IN DATE DEFAULT NULL,
1429 x_parent_2_birth_date IN DATE DEFAULT NULL,
1430 x_match_code IN VARCHAR2 DEFAULT NULL
1431 );
1432
1433 PROCEDURE update_row (
1434 x_rowid IN VARCHAR2,
1435 x_css_id IN NUMBER,
1436 x_record_status IN VARCHAR2,
1437 x_college_code IN VARCHAR2,
1438 x_academic_year IN VARCHAR2,
1439 x_stu_record_type IN VARCHAR2,
1440 x_css_id_number IN VARCHAR2,
1441 x_registration_receipt_date IN VARCHAR2,
1442 x_registration_type IN VARCHAR2,
1443 x_application_receipt_date IN VARCHAR2,
1444 x_application_type IN VARCHAR2,
1445 x_original_fnar_compute IN VARCHAR2,
1446 x_revision_fnar_compute_date IN VARCHAR2,
1447 x_electronic_extract_date IN VARCHAR2,
1448 x_institutional_reporting_type IN VARCHAR2,
1449 x_asr_receipt_date IN VARCHAR2,
1450 x_last_name IN VARCHAR2,
1451 x_first_name IN VARCHAR2,
1452 x_middle_initial IN VARCHAR2,
1453 x_address_number_and_street IN VARCHAR2,
1454 x_city IN VARCHAR2,
1455 x_state_mailing IN VARCHAR2,
1456 x_zip_code IN VARCHAR2,
1457 x_s_telephone_number IN VARCHAR2,
1458 x_s_title IN VARCHAR2,
1462 x_foreign_address_indicator IN VARCHAR2,
1459 x_date_of_birth IN VARCHAR2,
1460 x_social_security_number IN VARCHAR2,
1461 x_state_legal_residence IN VARCHAR2,
1463 x_foreign_postal_code IN VARCHAR2,
1464 x_country IN VARCHAR2,
1465 x_financial_aid_status IN VARCHAR2,
1466 x_year_in_college IN VARCHAR2,
1467 x_marital_status IN VARCHAR2,
1468 x_ward_court IN VARCHAR2,
1469 x_legal_dependents_other IN VARCHAR2,
1470 x_household_size IN VARCHAR2,
1471 x_number_in_college IN VARCHAR2,
1472 x_citizenship_status IN VARCHAR2,
1473 x_citizenship_country IN VARCHAR2,
1474 x_visa_classification IN VARCHAR2,
1475 x_tax_figures IN VARCHAR2,
1476 x_number_exemptions IN VARCHAR2,
1477 x_adjusted_gross_inc IN VARCHAR2,
1478 x_us_tax_paid IN VARCHAR2,
1479 x_itemized_deductions IN VARCHAR2,
1480 x_stu_income_work IN VARCHAR2,
1481 x_spouse_income_work IN VARCHAR2,
1482 x_divid_int_inc IN VARCHAR2,
1483 x_soc_sec_benefits IN VARCHAR2,
1484 x_welfare_tanf IN VARCHAR2,
1485 x_child_supp_rcvd IN VARCHAR2,
1486 x_earned_income_credit IN VARCHAR2,
1487 x_other_untax_income IN VARCHAR2,
1488 x_tax_stu_aid IN VARCHAR2,
1489 x_cash_sav_check IN VARCHAR2,
1490 x_ira_keogh IN VARCHAR2,
1491 x_invest_value IN VARCHAR2,
1492 x_invest_debt IN VARCHAR2,
1493 x_home_value IN VARCHAR2,
1494 x_home_debt IN VARCHAR2,
1495 x_oth_real_value IN VARCHAR2,
1496 x_oth_real_debt IN VARCHAR2,
1497 x_bus_farm_value IN VARCHAR2,
1498 x_bus_farm_debt IN VARCHAR2,
1499 x_live_on_farm IN VARCHAR2,
1500 x_home_purch_price IN VARCHAR2,
1501 x_hope_ll_credit IN VARCHAR2,
1502 x_home_purch_year IN VARCHAR2,
1503 x_trust_amount IN VARCHAR2,
1504 x_trust_avail IN VARCHAR2,
1505 x_trust_estab IN VARCHAR2,
1506 x_child_support_paid IN VARCHAR2,
1507 x_med_dent_expenses IN VARCHAR2,
1508 x_vet_us IN VARCHAR2,
1509 x_vet_ben_amount IN VARCHAR2,
1510 x_vet_ben_months IN VARCHAR2,
1511 x_stu_summer_wages IN VARCHAR2,
1512 x_stu_school_yr_wages IN VARCHAR2,
1513 x_spouse_summer_wages IN VARCHAR2,
1514 x_spouse_school_yr_wages IN VARCHAR2,
1515 x_summer_other_tax_inc IN VARCHAR2,
1516 x_school_yr_other_tax_inc IN VARCHAR2,
1517 x_summer_untax_inc IN VARCHAR2,
1518 x_school_yr_untax_inc IN VARCHAR2,
1519 x_grants_schol_etc IN VARCHAR2,
1520 x_tuit_benefits IN VARCHAR2,
1521 x_cont_parents IN VARCHAR2,
1522 x_cont_relatives IN VARCHAR2,
1523 x_p_siblings_pre_tuit IN VARCHAR2,
1524 x_p_student_pre_tuit IN VARCHAR2,
1525 x_p_household_size IN VARCHAR2,
1526 x_p_number_in_college IN VARCHAR2,
1527 x_p_parents_in_college IN VARCHAR2,
1528 x_p_marital_status IN VARCHAR2,
1529 x_p_state_legal_residence IN VARCHAR2,
1530 x_p_natural_par_status IN VARCHAR2,
1531 x_p_child_supp_paid IN VARCHAR2,
1532 x_p_repay_ed_loans IN VARCHAR2,
1533 x_p_med_dent_expenses IN VARCHAR2,
1534 x_p_tuit_paid_amount IN VARCHAR2,
1535 x_p_tuit_paid_number IN VARCHAR2,
1536 x_p_exp_child_supp_paid IN VARCHAR2,
1537 x_p_exp_repay_ed_loans IN VARCHAR2,
1538 x_p_exp_med_dent_expenses IN VARCHAR2,
1539 x_p_exp_tuit_pd_amount IN VARCHAR2,
1540 x_p_exp_tuit_pd_number IN VARCHAR2,
1541 x_p_cash_sav_check IN VARCHAR2,
1542 x_p_month_mortgage_pay IN VARCHAR2,
1543 x_p_invest_value IN VARCHAR2,
1544 x_p_invest_debt IN VARCHAR2,
1545 x_p_home_value IN VARCHAR2,
1546 x_p_home_debt IN VARCHAR2,
1547 x_p_home_purch_price IN VARCHAR2,
1548 x_p_own_business_farm IN VARCHAR2,
1549 x_p_business_value IN VARCHAR2,
1550 x_p_business_debt IN VARCHAR2,
1551 x_p_farm_value IN VARCHAR2,
1552 x_p_farm_debt IN VARCHAR2,
1553 x_p_live_on_farm IN VARCHAR2,
1554 x_p_oth_real_estate_value IN VARCHAR2,
1558 x_p_home_purch_year IN VARCHAR2,
1555 x_p_oth_real_estate_debt IN VARCHAR2,
1556 x_p_oth_real_purch_price IN VARCHAR2,
1557 x_p_siblings_assets IN VARCHAR2,
1559 x_p_oth_real_purch_year IN VARCHAR2,
1560 x_p_prior_agi IN VARCHAR2,
1561 x_p_prior_us_tax_paid IN VARCHAR2,
1562 x_p_prior_item_deductions IN VARCHAR2,
1563 x_p_prior_other_untax_inc IN VARCHAR2,
1564 x_p_tax_figures IN VARCHAR2,
1565 x_p_number_exemptions IN VARCHAR2,
1566 x_p_adjusted_gross_inc IN VARCHAR2,
1567 x_p_wages_sal_tips IN VARCHAR2,
1568 x_p_interest_income IN VARCHAR2,
1569 x_p_dividend_income IN VARCHAR2,
1570 x_p_net_inc_bus_farm IN VARCHAR2,
1571 x_p_other_taxable_income IN VARCHAR2,
1572 x_p_adj_to_income IN VARCHAR2,
1573 x_p_us_tax_paid IN VARCHAR2,
1574 x_p_itemized_deductions IN VARCHAR2,
1575 x_p_father_income_work IN VARCHAR2,
1576 x_p_mother_income_work IN VARCHAR2,
1577 x_p_soc_sec_ben IN VARCHAR2,
1578 x_p_welfare_tanf IN VARCHAR2,
1579 x_p_child_supp_rcvd IN VARCHAR2,
1580 x_p_ded_ira_keogh IN VARCHAR2,
1581 x_p_tax_defer_pens_savs IN VARCHAR2,
1582 x_p_dep_care_med_spending IN VARCHAR2,
1583 x_p_earned_income_credit IN VARCHAR2,
1584 x_p_living_allow IN VARCHAR2,
1585 x_p_tax_exmpt_int IN VARCHAR2,
1586 x_p_foreign_inc_excl IN VARCHAR2,
1587 x_p_other_untax_inc IN VARCHAR2,
1588 x_p_hope_ll_credit IN VARCHAR2,
1589 x_p_yr_separation IN VARCHAR2,
1590 x_p_yr_divorce IN VARCHAR2,
1591 x_p_exp_father_inc IN VARCHAR2,
1592 x_p_exp_mother_inc IN VARCHAR2,
1593 x_p_exp_other_tax_inc IN VARCHAR2,
1594 x_p_exp_other_untax_inc IN VARCHAR2,
1595 x_line_2_relation IN VARCHAR2,
1596 x_line_2_attend_college IN VARCHAR2,
1597 x_line_3_relation IN VARCHAR2,
1598 x_line_3_attend_college IN VARCHAR2,
1599 x_line_4_relation IN VARCHAR2,
1600 x_line_4_attend_college IN VARCHAR2,
1601 x_line_5_relation IN VARCHAR2,
1602 x_line_5_attend_college IN VARCHAR2,
1603 x_line_6_relation IN VARCHAR2,
1604 x_line_6_attend_college IN VARCHAR2,
1605 x_line_7_relation IN VARCHAR2,
1606 x_line_7_attend_college IN VARCHAR2,
1607 x_line_8_relation IN VARCHAR2,
1608 x_line_8_attend_college IN VARCHAR2,
1609 x_p_age_father IN VARCHAR2,
1610 x_p_age_mother IN VARCHAR2,
1611 x_p_div_sep_ind IN VARCHAR2,
1612 x_b_cont_non_custodial_par IN VARCHAR2,
1613 x_college_type_2 IN VARCHAR2,
1614 x_college_type_3 IN VARCHAR2,
1615 x_college_type_4 IN VARCHAR2,
1616 x_college_type_5 IN VARCHAR2,
1617 x_college_type_6 IN VARCHAR2,
1618 x_college_type_7 IN VARCHAR2,
1619 x_college_type_8 IN VARCHAR2,
1620 x_school_code_1 IN VARCHAR2,
1621 x_housing_code_1 IN VARCHAR2,
1622 x_school_code_2 IN VARCHAR2,
1623 x_housing_code_2 IN VARCHAR2,
1624 x_school_code_3 IN VARCHAR2,
1625 x_housing_code_3 IN VARCHAR2,
1626 x_school_code_4 IN VARCHAR2,
1627 x_housing_code_4 IN VARCHAR2,
1628 x_school_code_5 IN VARCHAR2,
1629 x_housing_code_5 IN VARCHAR2,
1630 x_school_code_6 IN VARCHAR2,
1631 x_housing_code_6 IN VARCHAR2,
1632 x_school_code_7 IN VARCHAR2,
1633 x_housing_code_7 IN VARCHAR2,
1634 x_school_code_8 IN VARCHAR2,
1635 x_housing_code_8 IN VARCHAR2,
1636 x_school_code_9 IN VARCHAR2,
1637 x_housing_code_9 IN VARCHAR2,
1638 x_school_code_10 IN VARCHAR2,
1639 x_housing_code_10 IN VARCHAR2,
1640 x_additional_school_code_1 IN VARCHAR2,
1641 x_additional_school_code_2 IN VARCHAR2,
1642 x_additional_school_code_3 IN VARCHAR2,
1643 x_additional_school_code_4 IN VARCHAR2,
1644 x_additional_school_code_5 IN VARCHAR2,
1645 x_additional_school_code_6 IN VARCHAR2,
1646 x_additional_school_code_7 IN VARCHAR2,
1647 x_additional_school_code_8 IN VARCHAR2,
1648 x_additional_school_code_9 IN VARCHAR2,
1649 x_additional_school_code_10 IN VARCHAR2,
1650 x_explanation_spec_circum IN VARCHAR2,
1654 x_signature_mother IN VARCHAR2,
1651 x_signature_student IN VARCHAR2,
1652 x_signature_spouse IN VARCHAR2,
1653 x_signature_father IN VARCHAR2,
1655 x_month_day_completed IN VARCHAR2,
1656 x_year_completed IN VARCHAR2,
1657 x_age_line_2 IN VARCHAR2,
1658 x_age_line_3 IN VARCHAR2,
1659 x_age_line_4 IN VARCHAR2,
1660 x_age_line_5 IN VARCHAR2,
1661 x_age_line_6 IN VARCHAR2,
1662 x_age_line_7 IN VARCHAR2,
1663 x_age_line_8 IN VARCHAR2,
1664 x_a_online_signature IN VARCHAR2,
1665 x_question_1_number IN VARCHAR2,
1666 x_question_1_size IN VARCHAR2,
1667 x_question_1_answer IN VARCHAR2,
1668 x_question_2_number IN VARCHAR2,
1669 x_question_2_size IN VARCHAR2,
1670 x_question_2_answer IN VARCHAR2,
1671 x_question_3_number IN VARCHAR2,
1672 x_question_3_size IN VARCHAR2,
1673 x_question_3_answer IN VARCHAR2,
1674 x_question_4_number IN VARCHAR2,
1675 x_question_4_size IN VARCHAR2,
1676 x_question_4_answer IN VARCHAR2,
1677 x_question_5_number IN VARCHAR2,
1678 x_question_5_size IN VARCHAR2,
1679 x_question_5_answer IN VARCHAR2,
1680 x_question_6_number IN VARCHAR2,
1681 x_question_6_size IN VARCHAR2,
1682 x_question_6_answer IN VARCHAR2,
1683 x_question_7_number IN VARCHAR2,
1684 x_question_7_size IN VARCHAR2,
1685 x_question_7_answer IN VARCHAR2,
1686 x_question_8_number IN VARCHAR2,
1687 x_question_8_size IN VARCHAR2,
1688 x_question_8_answer IN VARCHAR2,
1689 x_question_9_number IN VARCHAR2,
1690 x_question_9_size IN VARCHAR2,
1691 x_question_9_answer IN VARCHAR2,
1692 x_question_10_number IN VARCHAR2,
1693 x_question_10_size IN VARCHAR2,
1694 x_question_10_answer IN VARCHAR2,
1695 x_question_11_number IN VARCHAR2,
1696 x_question_11_size IN VARCHAR2,
1697 x_question_11_answer IN VARCHAR2,
1698 x_question_12_number IN VARCHAR2,
1699 x_question_12_size IN VARCHAR2,
1700 x_question_12_answer IN VARCHAR2,
1701 x_question_13_number IN VARCHAR2,
1702 x_question_13_size IN VARCHAR2,
1703 x_question_13_answer IN VARCHAR2,
1704 x_question_14_number IN VARCHAR2,
1705 x_question_14_size IN VARCHAR2,
1706 x_question_14_answer IN VARCHAR2,
1707 x_question_15_number IN VARCHAR2,
1708 x_question_15_size IN VARCHAR2,
1709 x_question_15_answer IN VARCHAR2,
1710 x_question_16_number IN VARCHAR2,
1711 x_question_16_size IN VARCHAR2,
1712 x_question_16_answer IN VARCHAR2,
1713 x_question_17_number IN VARCHAR2,
1714 x_question_17_size IN VARCHAR2,
1715 x_question_17_answer IN VARCHAR2,
1716 x_question_18_number IN VARCHAR2,
1717 x_question_18_size IN VARCHAR2,
1718 x_question_18_answer IN VARCHAR2,
1719 x_question_19_number IN VARCHAR2,
1720 x_question_19_size IN VARCHAR2,
1721 x_question_19_answer IN VARCHAR2,
1722 x_question_20_number IN VARCHAR2,
1723 x_question_20_size IN VARCHAR2,
1724 x_question_20_answer IN VARCHAR2,
1725 x_question_21_number IN VARCHAR2,
1726 x_question_21_size IN VARCHAR2,
1727 x_question_21_answer IN VARCHAR2,
1728 x_question_22_number IN VARCHAR2,
1729 x_question_22_size IN VARCHAR2,
1730 x_question_22_answer IN VARCHAR2,
1731 x_question_23_number IN VARCHAR2,
1732 x_question_23_size IN VARCHAR2,
1733 x_question_23_answer IN VARCHAR2,
1734 x_question_24_number IN VARCHAR2,
1735 x_question_24_size IN VARCHAR2,
1736 x_question_24_answer IN VARCHAR2,
1737 x_question_25_number IN VARCHAR2,
1738 x_question_25_size IN VARCHAR2,
1739 x_question_25_answer IN VARCHAR2,
1740 x_question_26_number IN VARCHAR2,
1741 x_question_26_size IN VARCHAR2,
1742 x_question_26_answer IN VARCHAR2,
1743 x_question_27_number IN VARCHAR2,
1744 x_question_27_size IN VARCHAR2,
1745 x_question_27_answer IN VARCHAR2,
1746 x_question_28_number IN VARCHAR2,
1750 x_question_29_size IN VARCHAR2,
1747 x_question_28_size IN VARCHAR2,
1748 x_question_28_answer IN VARCHAR2,
1749 x_question_29_number IN VARCHAR2,
1751 x_question_29_answer IN VARCHAR2,
1752 x_question_30_number IN VARCHAR2,
1753 x_questions_30_size IN VARCHAR2,
1754 x_question_30_answer IN VARCHAR2,
1755 x_r_s_email_address IN VARCHAR2,
1756 x_eps_code IN VARCHAR2,
1757 x_comp_css_dependency_status IN VARCHAR2,
1758 x_stu_age IN VARCHAR2,
1759 x_assumed_stu_yr_in_coll IN VARCHAR2,
1760 x_comp_stu_marital_status IN VARCHAR2,
1761 x_stu_family_members IN VARCHAR2,
1762 x_stu_fam_members_in_college IN VARCHAR2,
1763 x_par_marital_status IN VARCHAR2,
1764 x_par_family_members IN VARCHAR2,
1765 x_par_total_in_college IN VARCHAR2,
1766 x_par_par_in_college IN VARCHAR2,
1767 x_par_others_in_college IN VARCHAR2,
1768 x_par_aesa IN VARCHAR2,
1769 x_par_cesa IN VARCHAR2,
1770 x_stu_aesa IN VARCHAR2,
1771 x_stu_cesa IN VARCHAR2,
1772 x_im_p_bas_agi_taxable_income IN VARCHAR2,
1773 x_im_p_bas_untx_inc_and_ben IN VARCHAR2,
1774 x_im_p_bas_inc_adj IN VARCHAR2,
1775 x_im_p_bas_total_income IN VARCHAR2,
1776 x_im_p_bas_us_income_tax IN VARCHAR2,
1777 x_im_p_bas_st_and_other_tax IN VARCHAR2,
1778 x_im_p_bas_fica_tax IN VARCHAR2,
1779 x_im_p_bas_med_dental IN VARCHAR2,
1780 x_im_p_bas_employment_allow IN VARCHAR2,
1781 x_im_p_bas_annual_ed_savings IN VARCHAR2,
1782 x_im_p_bas_inc_prot_allow_m IN VARCHAR2,
1783 x_im_p_bas_total_inc_allow IN VARCHAR2,
1784 x_im_p_bas_cal_avail_inc IN VARCHAR2,
1785 x_im_p_bas_avail_income IN VARCHAR2,
1786 x_im_p_bas_total_cont_inc IN VARCHAR2,
1787 x_im_p_bas_cash_bank_accounts IN VARCHAR2,
1788 x_im_p_bas_home_equity IN VARCHAR2,
1789 x_im_p_bas_ot_rl_est_inv_eq IN VARCHAR2,
1790 x_im_p_bas_adj_bus_farm_worth IN VARCHAR2,
1791 x_im_p_bas_ass_sibs_pre_tui IN VARCHAR2,
1792 x_im_p_bas_net_worth IN VARCHAR2,
1793 x_im_p_bas_emerg_res_allow IN VARCHAR2,
1794 x_im_p_bas_cum_ed_savings IN VARCHAR2,
1795 x_im_p_bas_low_inc_allow IN VARCHAR2,
1796 x_im_p_bas_total_asset_allow IN VARCHAR2,
1797 x_im_p_bas_disc_net_worth IN VARCHAR2,
1798 x_im_p_bas_total_cont_asset IN VARCHAR2,
1799 x_im_p_bas_total_cont IN VARCHAR2,
1800 x_im_p_bas_num_in_coll_adj IN VARCHAR2,
1801 x_im_p_bas_cont_for_stu IN VARCHAR2,
1802 x_im_p_bas_cont_from_income IN VARCHAR2,
1803 x_im_p_bas_cont_from_assets IN VARCHAR2,
1804 x_im_p_opt_agi_taxable_income IN VARCHAR2,
1805 x_im_p_opt_untx_inc_and_ben IN VARCHAR2,
1806 x_im_p_opt_inc_adj IN VARCHAR2,
1807 x_im_p_opt_total_income IN VARCHAR2,
1808 x_im_p_opt_us_income_tax IN VARCHAR2,
1809 x_im_p_opt_st_and_other_tax IN VARCHAR2,
1810 x_im_p_opt_fica_tax IN VARCHAR2,
1811 x_im_p_opt_med_dental IN VARCHAR2,
1812 x_im_p_opt_elem_sec_tuit IN VARCHAR2,
1813 x_im_p_opt_employment_allow IN VARCHAR2,
1814 x_im_p_opt_annual_ed_savings IN VARCHAR2,
1815 x_im_p_opt_inc_prot_allow_m IN VARCHAR2,
1816 x_im_p_opt_total_inc_allow IN VARCHAR2,
1817 x_im_p_opt_cal_avail_inc IN VARCHAR2,
1818 x_im_p_opt_avail_income IN VARCHAR2,
1819 x_im_p_opt_total_cont_inc IN VARCHAR2,
1820 x_im_p_opt_cash_bank_accounts IN VARCHAR2,
1821 x_im_p_opt_home_equity IN VARCHAR2,
1822 x_im_p_opt_ot_rl_est_inv_eq IN VARCHAR2,
1823 x_im_p_opt_adj_bus_farm_worth IN VARCHAR2,
1824 x_im_p_opt_ass_sibs_pre_t IN VARCHAR2,
1825 x_im_p_opt_net_worth IN VARCHAR2,
1826 x_im_p_opt_emerg_res_allow IN VARCHAR2,
1827 x_im_p_opt_cum_ed_savings IN VARCHAR2,
1828 x_im_p_opt_low_inc_allow IN VARCHAR2,
1829 x_im_p_opt_total_asset_allow IN VARCHAR2,
1830 x_im_p_opt_disc_net_worth IN VARCHAR2,
1831 x_im_p_opt_total_cont_asset IN VARCHAR2,
1832 x_im_p_opt_total_cont IN VARCHAR2,
1833 x_im_p_opt_num_in_coll_adj IN VARCHAR2,
1834 x_im_p_opt_cont_for_stu IN VARCHAR2,
1835 x_im_p_opt_cont_from_income IN VARCHAR2,
1836 x_im_p_opt_cont_from_assets IN VARCHAR2,
1837 x_fm_p_analysis_type IN VARCHAR2,
1838 x_fm_p_agi_taxable_income IN VARCHAR2,
1839 x_fm_p_untx_inc_and_ben IN VARCHAR2,
1840 x_fm_p_inc_adj IN VARCHAR2,
1841 x_fm_p_total_income IN VARCHAR2,
1842 x_fm_p_us_income_tax IN VARCHAR2,
1846 x_fm_p_income_prot_allow IN VARCHAR2,
1843 x_fm_p_state_and_other_taxes IN VARCHAR2,
1844 x_fm_p_fica_tax IN VARCHAR2,
1845 x_fm_p_employment_allow IN VARCHAR2,
1847 x_fm_p_total_allow IN VARCHAR2,
1848 x_fm_p_avail_income IN VARCHAR2,
1849 x_fm_p_cash_bank_accounts IN VARCHAR2,
1850 x_fm_p_ot_rl_est_inv_eq IN VARCHAR2,
1851 x_fm_p_adj_bus_farm_net_worth IN VARCHAR2,
1852 x_fm_p_net_worth IN VARCHAR2,
1853 x_fm_p_asset_prot_allow IN VARCHAR2,
1854 x_fm_p_disc_net_worth IN VARCHAR2,
1855 x_fm_p_total_contribution IN VARCHAR2,
1856 x_fm_p_num_in_coll IN VARCHAR2,
1857 x_fm_p_cont_for_stu IN VARCHAR2,
1858 x_fm_p_cont_from_income IN VARCHAR2,
1859 x_fm_p_cont_from_assets IN VARCHAR2,
1860 x_im_s_bas_agi_taxable_income IN VARCHAR2,
1861 x_im_s_bas_untx_inc_and_ben IN VARCHAR2,
1862 x_im_s_bas_inc_adj IN VARCHAR2,
1863 x_im_s_bas_total_income IN VARCHAR2,
1864 x_im_s_bas_us_income_tax IN VARCHAR2,
1865 x_im_s_bas_st_and_oth_tax IN VARCHAR2,
1866 x_im_s_bas_fica_tax IN VARCHAR2,
1867 x_im_s_bas_med_dental IN VARCHAR2,
1868 x_im_s_bas_employment_allow IN VARCHAR2,
1869 x_im_s_bas_annual_ed_savings IN VARCHAR2,
1870 x_im_s_bas_inc_prot_allow_m IN VARCHAR2,
1871 x_im_s_bas_total_inc_allow IN VARCHAR2,
1872 x_im_s_bas_cal_avail_income IN VARCHAR2,
1873 x_im_s_bas_avail_income IN VARCHAR2,
1874 x_im_s_bas_total_cont_inc IN VARCHAR2,
1875 x_im_s_bas_cash_bank_accounts IN VARCHAR2,
1876 x_im_s_bas_home_equity IN VARCHAR2,
1877 x_im_s_bas_ot_rl_est_inv_eq IN VARCHAR2,
1878 x_im_s_bas_adj_bus_farm_worth IN VARCHAR2,
1879 x_im_s_bas_trusts IN VARCHAR2,
1880 x_im_s_bas_net_worth IN VARCHAR2,
1881 x_im_s_bas_emerg_res_allow IN VARCHAR2,
1882 x_im_s_bas_cum_ed_savings IN VARCHAR2,
1883 x_im_s_bas_total_asset_allow IN VARCHAR2,
1884 x_im_s_bas_disc_net_worth IN VARCHAR2,
1885 x_im_s_bas_total_cont_asset IN VARCHAR2,
1886 x_im_s_bas_total_cont IN VARCHAR2,
1887 x_im_s_bas_num_in_coll_adj IN VARCHAR2,
1888 x_im_s_bas_cont_for_stu IN VARCHAR2,
1889 x_im_s_bas_cont_from_income IN VARCHAR2,
1890 x_im_s_bas_cont_from_assets IN VARCHAR2,
1891 x_im_s_est_agi_taxable_income IN VARCHAR2,
1892 x_im_s_est_untx_inc_and_ben IN VARCHAR2,
1893 x_im_s_est_inc_adj IN VARCHAR2,
1894 x_im_s_est_total_income IN VARCHAR2,
1895 x_im_s_est_us_income_tax IN VARCHAR2,
1896 x_im_s_est_st_and_oth_tax IN VARCHAR2,
1897 x_im_s_est_fica_tax IN VARCHAR2,
1898 x_im_s_est_med_dental IN VARCHAR2,
1899 x_im_s_est_employment_allow IN VARCHAR2,
1900 x_im_s_est_annual_ed_savings IN VARCHAR2,
1901 x_im_s_est_inc_prot_allow_m IN VARCHAR2,
1902 x_im_s_est_total_inc_allow IN VARCHAR2,
1903 x_im_s_est_cal_avail_income IN VARCHAR2,
1904 x_im_s_est_avail_income IN VARCHAR2,
1905 x_im_s_est_total_cont_inc IN VARCHAR2,
1906 x_im_s_est_cash_bank_accounts IN VARCHAR2,
1907 x_im_s_est_home_equity IN VARCHAR2,
1908 x_im_s_est_ot_rl_est_inv_equ IN VARCHAR2,
1909 x_im_s_est_adj_bus_farm_worth IN VARCHAR2,
1910 x_im_s_est_est_trusts IN VARCHAR2,
1911 x_im_s_est_net_worth IN VARCHAR2,
1912 x_im_s_est_emerg_res_allow IN VARCHAR2,
1913 x_im_s_est_cum_ed_savings IN VARCHAR2,
1914 x_im_s_est_total_asset_allow IN VARCHAR2,
1915 x_im_s_est_disc_net_worth IN VARCHAR2,
1916 x_im_s_est_total_cont_asset IN VARCHAR2,
1917 x_im_s_est_total_cont IN VARCHAR2,
1918 x_im_s_est_num_in_coll_adj IN VARCHAR2,
1919 x_im_s_est_cont_for_stu IN VARCHAR2,
1920 x_im_s_est_cont_from_income IN VARCHAR2,
1921 x_im_s_est_cont_from_assets IN VARCHAR2,
1922 x_im_s_opt_agi_taxable_income IN VARCHAR2,
1923 x_im_s_opt_untx_inc_and_ben IN VARCHAR2,
1924 x_im_s_opt_inc_adj IN VARCHAR2,
1925 x_im_s_opt_total_income IN VARCHAR2,
1926 x_im_s_opt_us_income_tax IN VARCHAR2,
1927 x_im_s_opt_state_and_oth_taxes IN VARCHAR2,
1928 x_im_s_opt_fica_tax IN VARCHAR2,
1929 x_im_s_opt_med_dental IN VARCHAR2,
1930 x_im_s_opt_employment_allow IN VARCHAR2,
1931 x_im_s_opt_annual_ed_savings IN VARCHAR2,
1932 x_im_s_opt_inc_prot_allow_m IN VARCHAR2,
1933 x_im_s_opt_total_inc_allow IN VARCHAR2,
1934 x_im_s_opt_cal_avail_income IN VARCHAR2,
1935 x_im_s_opt_avail_income IN VARCHAR2,
1936 x_im_s_opt_total_cont_inc IN VARCHAR2,
1937 x_im_s_opt_cash_bank_accounts IN VARCHAR2,
1941 x_im_s_opt_adj_bus_farm_worth IN VARCHAR2,
1938 x_im_s_opt_ira_keogh_accounts IN VARCHAR2,
1939 x_im_s_opt_home_equity IN VARCHAR2,
1940 x_im_s_opt_ot_rl_est_inv_eq IN VARCHAR2,
1942 x_im_s_opt_trusts IN VARCHAR2,
1943 x_im_s_opt_net_worth IN VARCHAR2,
1944 x_im_s_opt_emerg_res_allow IN VARCHAR2,
1945 x_im_s_opt_cum_ed_savings IN VARCHAR2,
1946 x_im_s_opt_total_asset_allow IN VARCHAR2,
1947 x_im_s_opt_disc_net_worth IN VARCHAR2,
1948 x_im_s_opt_total_cont_asset IN VARCHAR2,
1949 x_im_s_opt_total_cont IN VARCHAR2,
1950 x_im_s_opt_num_in_coll_adj IN VARCHAR2,
1951 x_im_s_opt_cont_for_stu IN VARCHAR2,
1952 x_im_s_opt_cont_from_income IN VARCHAR2,
1953 x_im_s_opt_cont_from_assets IN VARCHAR2,
1954 x_fm_s_analysis_type IN VARCHAR2,
1955 x_fm_s_agi_taxable_income IN VARCHAR2,
1956 x_fm_s_untx_inc_and_ben IN VARCHAR2,
1957 x_fm_s_inc_adj IN VARCHAR2,
1958 x_fm_s_total_income IN VARCHAR2,
1959 x_fm_s_us_income_tax IN VARCHAR2,
1960 x_fm_s_state_and_oth_taxes IN VARCHAR2,
1961 x_fm_s_fica_tax IN VARCHAR2,
1962 x_fm_s_employment_allow IN VARCHAR2,
1963 x_fm_s_income_prot_allow IN VARCHAR2,
1964 x_fm_s_total_allow IN VARCHAR2,
1965 x_fm_s_cal_avail_income IN VARCHAR2,
1966 x_fm_s_avail_income IN VARCHAR2,
1967 x_fm_s_cash_bank_accounts IN VARCHAR2,
1968 x_fm_s_ot_rl_est_inv_equity IN VARCHAR2,
1969 x_fm_s_adj_bus_farm_worth IN VARCHAR2,
1970 x_fm_s_trusts IN VARCHAR2,
1971 x_fm_s_net_worth IN VARCHAR2,
1972 x_fm_s_asset_prot_allow IN VARCHAR2,
1973 x_fm_s_disc_net_worth IN VARCHAR2,
1974 x_fm_s_total_cont IN VARCHAR2,
1975 x_fm_s_num_in_coll IN VARCHAR2,
1976 x_fm_s_cont_for_stu IN VARCHAR2,
1977 x_fm_s_cont_from_income IN VARCHAR2,
1978 x_fm_s_cont_from_assets IN VARCHAR2,
1979 x_im_inst_resident_ind IN VARCHAR2,
1980 x_institutional_1_budget_name IN VARCHAR2,
1981 x_im_inst_1_budget_duration IN VARCHAR2,
1982 x_im_inst_1_tuition_fees IN VARCHAR2,
1983 x_im_inst_1_books_supplies IN VARCHAR2,
1984 x_im_inst_1_living_expenses IN VARCHAR2,
1985 x_im_inst_1_tot_expenses IN VARCHAR2,
1986 x_im_inst_1_tot_stu_cont IN VARCHAR2,
1987 x_im_inst_1_tot_par_cont IN VARCHAR2,
1988 x_im_inst_1_tot_family_cont IN VARCHAR2,
1989 x_im_inst_1_va_benefits IN VARCHAR2,
1990 x_im_inst_1_ot_cont IN VARCHAR2,
1991 x_im_inst_1_est_financial_need IN VARCHAR2,
1992 x_institutional_2_budget_name IN VARCHAR2,
1993 x_im_inst_2_budget_duration IN VARCHAR2,
1994 x_im_inst_2_tuition_fees IN VARCHAR2,
1995 x_im_inst_2_books_supplies IN VARCHAR2,
1996 x_im_inst_2_living_expenses IN VARCHAR2,
1997 x_im_inst_2_tot_expenses IN VARCHAR2,
1998 x_im_inst_2_tot_stu_cont IN VARCHAR2,
1999 x_im_inst_2_tot_par_cont IN VARCHAR2,
2000 x_im_inst_2_tot_family_cont IN VARCHAR2,
2001 x_im_inst_2_va_benefits IN VARCHAR2,
2002 x_im_inst_2_est_financial_need IN VARCHAR2,
2003 x_institutional_3_budget_name IN VARCHAR2,
2004 x_im_inst_3_budget_duration IN VARCHAR2,
2005 x_im_inst_3_tuition_fees IN VARCHAR2,
2006 x_im_inst_3_books_supplies IN VARCHAR2,
2007 x_im_inst_3_living_expenses IN VARCHAR2,
2008 x_im_inst_3_tot_expenses IN VARCHAR2,
2009 x_im_inst_3_tot_stu_cont IN VARCHAR2,
2010 x_im_inst_3_tot_par_cont IN VARCHAR2,
2011 x_im_inst_3_tot_family_cont IN VARCHAR2,
2012 x_im_inst_3_va_benefits IN VARCHAR2,
2013 x_im_inst_3_est_financial_need IN VARCHAR2,
2014 x_fm_inst_1_federal_efc IN VARCHAR2,
2015 x_fm_inst_1_va_benefits IN VARCHAR2,
2016 x_fm_inst_1_fed_eligibility IN VARCHAR2,
2017 x_fm_inst_1_pell IN VARCHAR2,
2018 x_option_par_loss_allow_ind IN VARCHAR2,
2019 x_option_par_tuition_ind IN VARCHAR2,
2020 x_option_par_home_ind IN VARCHAR2,
2021 x_option_par_home_value IN VARCHAR2,
2022 x_option_par_home_debt IN VARCHAR2,
2023 x_option_stu_ira_keogh_ind IN VARCHAR2,
2024 x_option_stu_home_ind IN VARCHAR2,
2025 x_option_stu_home_value IN VARCHAR2,
2026 x_option_stu_home_debt IN VARCHAR2,
2027 x_option_stu_sum_ay_inc_ind IN VARCHAR2,
2028 x_option_par_hope_ll_credit IN VARCHAR2,
2029 x_option_stu_hope_ll_credit IN VARCHAR2,
2030 x_im_parent_1_8_months_bas IN VARCHAR2,
2031 x_im_p_more_than_9_mth_ba IN VARCHAR2,
2032 x_im_parent_1_8_months_opt IN VARCHAR2,
2036 x_fnar_message_3 IN VARCHAR2,
2033 x_im_p_more_than_9_mth_op IN VARCHAR2,
2034 x_fnar_message_1 IN VARCHAR2,
2035 x_fnar_message_2 IN VARCHAR2,
2037 x_fnar_message_4 IN VARCHAR2,
2038 x_fnar_message_5 IN VARCHAR2,
2039 x_fnar_message_6 IN VARCHAR2,
2040 x_fnar_message_7 IN VARCHAR2,
2041 x_fnar_message_8 IN VARCHAR2,
2042 x_fnar_message_9 IN VARCHAR2,
2043 x_fnar_message_10 IN VARCHAR2,
2044 x_fnar_message_11 IN VARCHAR2,
2045 x_fnar_message_12 IN VARCHAR2,
2046 x_fnar_message_13 IN VARCHAR2,
2047 x_fnar_message_20 IN VARCHAR2,
2048 x_fnar_message_21 IN VARCHAR2,
2049 x_fnar_message_22 IN VARCHAR2,
2050 x_fnar_message_23 IN VARCHAR2,
2051 x_fnar_message_24 IN VARCHAR2,
2052 x_fnar_message_25 IN VARCHAR2,
2053 x_fnar_message_26 IN VARCHAR2,
2054 x_fnar_message_27 IN VARCHAR2,
2055 x_fnar_message_30 IN VARCHAR2,
2056 x_fnar_message_31 IN VARCHAR2,
2057 x_fnar_message_32 IN VARCHAR2,
2058 x_fnar_message_33 IN VARCHAR2,
2059 x_fnar_message_34 IN VARCHAR2,
2060 x_fnar_message_35 IN VARCHAR2,
2061 x_fnar_message_36 IN VARCHAR2,
2062 x_fnar_message_37 IN VARCHAR2,
2063 x_fnar_message_38 IN VARCHAR2,
2064 x_fnar_message_39 IN VARCHAR2,
2065 x_fnar_message_45 IN VARCHAR2,
2066 x_fnar_message_46 IN VARCHAR2,
2067 x_fnar_message_47 IN VARCHAR2,
2068 x_fnar_message_48 IN VARCHAR2,
2069 x_fnar_message_50 IN VARCHAR2,
2070 x_fnar_message_51 IN VARCHAR2,
2071 x_fnar_message_52 IN VARCHAR2,
2072 x_fnar_message_53 IN VARCHAR2,
2073 x_fnar_message_56 IN VARCHAR2,
2074 x_fnar_message_57 IN VARCHAR2,
2075 x_fnar_message_58 IN VARCHAR2,
2076 x_fnar_message_59 IN VARCHAR2,
2077 x_fnar_message_60 IN VARCHAR2,
2078 x_fnar_message_61 IN VARCHAR2,
2079 x_fnar_message_62 IN VARCHAR2,
2080 x_fnar_message_63 IN VARCHAR2,
2081 x_fnar_message_64 IN VARCHAR2,
2082 x_fnar_message_65 IN VARCHAR2,
2083 x_fnar_message_71 IN VARCHAR2,
2084 x_fnar_message_72 IN VARCHAR2,
2085 x_fnar_message_73 IN VARCHAR2,
2086 x_fnar_message_74 IN VARCHAR2,
2087 x_fnar_message_75 IN VARCHAR2,
2088 x_fnar_message_76 IN VARCHAR2,
2089 x_fnar_message_77 IN VARCHAR2,
2090 x_fnar_message_78 IN VARCHAR2,
2091 x_fnar_mesg_10_stu_fam_mem IN VARCHAR2,
2092 x_fnar_mesg_11_stu_no_in_coll IN VARCHAR2,
2093 x_fnar_mesg_24_stu_avail_inc IN VARCHAR2,
2094 x_fnar_mesg_26_stu_taxes IN VARCHAR2,
2095 x_fnar_mesg_33_stu_home_value IN VARCHAR2,
2096 x_fnar_mesg_34_stu_home_value IN VARCHAR2,
2097 x_fnar_mesg_34_stu_home_equity IN VARCHAR2,
2098 x_fnar_mesg_35_stu_home_value IN VARCHAR2,
2099 x_fnar_mesg_35_stu_home_equity IN VARCHAR2,
2100 x_fnar_mesg_36_stu_home_equity IN VARCHAR2,
2101 x_fnar_mesg_48_par_fam_mem IN VARCHAR2,
2102 x_fnar_mesg_49_par_no_in_coll IN VARCHAR2,
2103 x_fnar_mesg_56_par_agi IN VARCHAR2,
2104 x_fnar_mesg_62_par_taxes IN VARCHAR2,
2105 x_fnar_mesg_73_par_home_value IN VARCHAR2,
2106 x_fnar_mesg_74_par_home_value IN VARCHAR2,
2107 x_fnar_mesg_74_par_home_equity IN VARCHAR2,
2108 x_fnar_mesg_75_par_home_value IN VARCHAR2,
2109 x_fnar_mesg_75_par_home_equity IN VARCHAR2,
2110 x_fnar_mesg_76_par_home_equity IN VARCHAR2,
2111 x_assumption_message_1 IN VARCHAR2,
2112 x_assumption_message_2 IN VARCHAR2,
2113 x_assumption_message_3 IN VARCHAR2,
2114 x_assumption_message_4 IN VARCHAR2,
2115 x_assumption_message_5 IN VARCHAR2,
2116 x_assumption_message_6 IN VARCHAR2,
2117 x_record_mark IN VARCHAR2,
2118 x_option_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
2119 x_option_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
2120 x_option_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
2121 x_option_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
2122 x_option_par_cola_adj_value IN VARCHAR2 DEFAULT NULL,
2123 x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
2124 x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
2125 x_p_soc_sec_ben_student_amt IN NUMBER DEFAULT NULL,
2129 x_stu_most_support_from_num IN NUMBER DEFAULT NULL,
2126 x_p_tuit_fee_deduct_amt IN NUMBER DEFAULT NULL,
2127 x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
2128 x_stu_lives_with_num IN NUMBER DEFAULT NULL,
2130 x_location_computer_num IN NUMBER DEFAULT NULL,
2131 x_cust_parent_cont_adj_num IN NUMBER DEFAULT NULL,
2132 x_custodial_parent_num IN NUMBER DEFAULT NULL,
2133 x_cust_par_base_prcnt_inc_amt IN NUMBER DEFAULT NULL,
2134 x_cust_par_base_cont_inc_amt IN NUMBER DEFAULT NULL,
2135 x_cust_par_base_cont_ast_amt IN NUMBER DEFAULT NULL,
2136 x_cust_par_base_tot_cont_amt IN NUMBER DEFAULT NULL,
2137 x_cust_par_opt_prcnt_inc_amt IN NUMBER DEFAULT NULL,
2138 x_cust_par_opt_cont_inc_amt IN NUMBER DEFAULT NULL,
2139 x_cust_par_opt_cont_ast_amt IN NUMBER DEFAULT NULL,
2140 x_cust_par_opt_tot_cont_amt IN NUMBER DEFAULT NULL,
2141 x_parents_email_txt IN VARCHAR2 DEFAULT NULL,
2142 x_parent_1_birth_date IN DATE DEFAULT NULL,
2143 x_parent_2_birth_date IN DATE DEFAULT NULL,
2144 x_match_code IN VARCHAR2 DEFAULT NULL,
2145 x_mode IN VARCHAR2 DEFAULT 'R'
2146 );
2147
2148 PROCEDURE add_row (
2149 x_rowid IN OUT NOCOPY VARCHAR2,
2150 x_css_id IN OUT NOCOPY NUMBER,
2151 x_record_status IN VARCHAR2,
2152 x_college_code IN VARCHAR2,
2153 x_academic_year IN VARCHAR2,
2154 x_stu_record_type IN VARCHAR2,
2155 x_css_id_number IN VARCHAR2,
2156 x_registration_receipt_date IN VARCHAR2,
2157 x_registration_type IN VARCHAR2,
2158 x_application_receipt_date IN VARCHAR2,
2159 x_application_type IN VARCHAR2,
2160 x_original_fnar_compute IN VARCHAR2,
2161 x_revision_fnar_compute_date IN VARCHAR2,
2162 x_electronic_extract_date IN VARCHAR2,
2163 x_institutional_reporting_type IN VARCHAR2,
2164 x_asr_receipt_date IN VARCHAR2,
2165 x_last_name IN VARCHAR2,
2166 x_first_name IN VARCHAR2,
2167 x_middle_initial IN VARCHAR2,
2168 x_address_number_and_street IN VARCHAR2,
2169 x_city IN VARCHAR2,
2170 x_state_mailing IN VARCHAR2,
2171 x_zip_code IN VARCHAR2,
2172 x_s_telephone_number IN VARCHAR2,
2173 x_s_title IN VARCHAR2,
2174 x_date_of_birth IN VARCHAR2,
2175 x_social_security_number IN VARCHAR2,
2176 x_state_legal_residence IN VARCHAR2,
2177 x_foreign_address_indicator IN VARCHAR2,
2178 x_foreign_postal_code IN VARCHAR2,
2179 x_country IN VARCHAR2,
2180 x_financial_aid_status IN VARCHAR2,
2181 x_year_in_college IN VARCHAR2,
2182 x_marital_status IN VARCHAR2,
2183 x_ward_court IN VARCHAR2,
2184 x_legal_dependents_other IN VARCHAR2,
2185 x_household_size IN VARCHAR2,
2186 x_number_in_college IN VARCHAR2,
2187 x_citizenship_status IN VARCHAR2,
2188 x_citizenship_country IN VARCHAR2,
2189 x_visa_classification IN VARCHAR2,
2190 x_tax_figures IN VARCHAR2,
2191 x_number_exemptions IN VARCHAR2,
2192 x_adjusted_gross_inc IN VARCHAR2,
2193 x_us_tax_paid IN VARCHAR2,
2194 x_itemized_deductions IN VARCHAR2,
2195 x_stu_income_work IN VARCHAR2,
2196 x_spouse_income_work IN VARCHAR2,
2197 x_divid_int_inc IN VARCHAR2,
2198 x_soc_sec_benefits IN VARCHAR2,
2199 x_welfare_tanf IN VARCHAR2,
2200 x_child_supp_rcvd IN VARCHAR2,
2201 x_earned_income_credit IN VARCHAR2,
2202 x_other_untax_income IN VARCHAR2,
2203 x_tax_stu_aid IN VARCHAR2,
2204 x_cash_sav_check IN VARCHAR2,
2205 x_ira_keogh IN VARCHAR2,
2206 x_invest_value IN VARCHAR2,
2207 x_invest_debt IN VARCHAR2,
2208 x_home_value IN VARCHAR2,
2209 x_home_debt IN VARCHAR2,
2210 x_oth_real_value IN VARCHAR2,
2211 x_oth_real_debt IN VARCHAR2,
2212 x_bus_farm_value IN VARCHAR2,
2213 x_bus_farm_debt IN VARCHAR2,
2214 x_live_on_farm IN VARCHAR2,
2215 x_home_purch_price IN VARCHAR2,
2216 x_hope_ll_credit IN VARCHAR2,
2217 x_home_purch_year IN VARCHAR2,
2218 x_trust_amount IN VARCHAR2,
2222 x_med_dent_expenses IN VARCHAR2,
2219 x_trust_avail IN VARCHAR2,
2220 x_trust_estab IN VARCHAR2,
2221 x_child_support_paid IN VARCHAR2,
2223 x_vet_us IN VARCHAR2,
2224 x_vet_ben_amount IN VARCHAR2,
2225 x_vet_ben_months IN VARCHAR2,
2226 x_stu_summer_wages IN VARCHAR2,
2227 x_stu_school_yr_wages IN VARCHAR2,
2228 x_spouse_summer_wages IN VARCHAR2,
2229 x_spouse_school_yr_wages IN VARCHAR2,
2230 x_summer_other_tax_inc IN VARCHAR2,
2231 x_school_yr_other_tax_inc IN VARCHAR2,
2232 x_summer_untax_inc IN VARCHAR2,
2233 x_school_yr_untax_inc IN VARCHAR2,
2234 x_grants_schol_etc IN VARCHAR2,
2235 x_tuit_benefits IN VARCHAR2,
2236 x_cont_parents IN VARCHAR2,
2237 x_cont_relatives IN VARCHAR2,
2238 x_p_siblings_pre_tuit IN VARCHAR2,
2239 x_p_student_pre_tuit IN VARCHAR2,
2240 x_p_household_size IN VARCHAR2,
2241 x_p_number_in_college IN VARCHAR2,
2242 x_p_parents_in_college IN VARCHAR2,
2243 x_p_marital_status IN VARCHAR2,
2244 x_p_state_legal_residence IN VARCHAR2,
2245 x_p_natural_par_status IN VARCHAR2,
2246 x_p_child_supp_paid IN VARCHAR2,
2247 x_p_repay_ed_loans IN VARCHAR2,
2248 x_p_med_dent_expenses IN VARCHAR2,
2249 x_p_tuit_paid_amount IN VARCHAR2,
2250 x_p_tuit_paid_number IN VARCHAR2,
2251 x_p_exp_child_supp_paid IN VARCHAR2,
2252 x_p_exp_repay_ed_loans IN VARCHAR2,
2253 x_p_exp_med_dent_expenses IN VARCHAR2,
2254 x_p_exp_tuit_pd_amount IN VARCHAR2,
2255 x_p_exp_tuit_pd_number IN VARCHAR2,
2256 x_p_cash_sav_check IN VARCHAR2,
2257 x_p_month_mortgage_pay IN VARCHAR2,
2258 x_p_invest_value IN VARCHAR2,
2259 x_p_invest_debt IN VARCHAR2,
2260 x_p_home_value IN VARCHAR2,
2261 x_p_home_debt IN VARCHAR2,
2262 x_p_home_purch_price IN VARCHAR2,
2263 x_p_own_business_farm IN VARCHAR2,
2264 x_p_business_value IN VARCHAR2,
2265 x_p_business_debt IN VARCHAR2,
2266 x_p_farm_value IN VARCHAR2,
2267 x_p_farm_debt IN VARCHAR2,
2268 x_p_live_on_farm IN VARCHAR2,
2269 x_p_oth_real_estate_value IN VARCHAR2,
2270 x_p_oth_real_estate_debt IN VARCHAR2,
2271 x_p_oth_real_purch_price IN VARCHAR2,
2272 x_p_siblings_assets IN VARCHAR2,
2273 x_p_home_purch_year IN VARCHAR2,
2274 x_p_oth_real_purch_year IN VARCHAR2,
2275 x_p_prior_agi IN VARCHAR2,
2276 x_p_prior_us_tax_paid IN VARCHAR2,
2277 x_p_prior_item_deductions IN VARCHAR2,
2278 x_p_prior_other_untax_inc IN VARCHAR2,
2279 x_p_tax_figures IN VARCHAR2,
2280 x_p_number_exemptions IN VARCHAR2,
2281 x_p_adjusted_gross_inc IN VARCHAR2,
2282 x_p_wages_sal_tips IN VARCHAR2,
2283 x_p_interest_income IN VARCHAR2,
2284 x_p_dividend_income IN VARCHAR2,
2285 x_p_net_inc_bus_farm IN VARCHAR2,
2286 x_p_other_taxable_income IN VARCHAR2,
2287 x_p_adj_to_income IN VARCHAR2,
2288 x_p_us_tax_paid IN VARCHAR2,
2289 x_p_itemized_deductions IN VARCHAR2,
2290 x_p_father_income_work IN VARCHAR2,
2291 x_p_mother_income_work IN VARCHAR2,
2292 x_p_soc_sec_ben IN VARCHAR2,
2293 x_p_welfare_tanf IN VARCHAR2,
2294 x_p_child_supp_rcvd IN VARCHAR2,
2295 x_p_ded_ira_keogh IN VARCHAR2,
2296 x_p_tax_defer_pens_savs IN VARCHAR2,
2297 x_p_dep_care_med_spending IN VARCHAR2,
2298 x_p_earned_income_credit IN VARCHAR2,
2299 x_p_living_allow IN VARCHAR2,
2300 x_p_tax_exmpt_int IN VARCHAR2,
2301 x_p_foreign_inc_excl IN VARCHAR2,
2302 x_p_other_untax_inc IN VARCHAR2,
2303 x_p_hope_ll_credit IN VARCHAR2,
2304 x_p_yr_separation IN VARCHAR2,
2305 x_p_yr_divorce IN VARCHAR2,
2306 x_p_exp_father_inc IN VARCHAR2,
2307 x_p_exp_mother_inc IN VARCHAR2,
2308 x_p_exp_other_tax_inc IN VARCHAR2,
2309 x_p_exp_other_untax_inc IN VARCHAR2,
2310 x_line_2_relation IN VARCHAR2,
2311 x_line_2_attend_college IN VARCHAR2,
2312 x_line_3_relation IN VARCHAR2,
2313 x_line_3_attend_college IN VARCHAR2,
2314 x_line_4_relation IN VARCHAR2,
2318 x_line_6_relation IN VARCHAR2,
2315 x_line_4_attend_college IN VARCHAR2,
2316 x_line_5_relation IN VARCHAR2,
2317 x_line_5_attend_college IN VARCHAR2,
2319 x_line_6_attend_college IN VARCHAR2,
2320 x_line_7_relation IN VARCHAR2,
2321 x_line_7_attend_college IN VARCHAR2,
2322 x_line_8_relation IN VARCHAR2,
2323 x_line_8_attend_college IN VARCHAR2,
2324 x_p_age_father IN VARCHAR2,
2325 x_p_age_mother IN VARCHAR2,
2326 x_p_div_sep_ind IN VARCHAR2,
2327 x_b_cont_non_custodial_par IN VARCHAR2,
2328 x_college_type_2 IN VARCHAR2,
2329 x_college_type_3 IN VARCHAR2,
2330 x_college_type_4 IN VARCHAR2,
2331 x_college_type_5 IN VARCHAR2,
2332 x_college_type_6 IN VARCHAR2,
2333 x_college_type_7 IN VARCHAR2,
2334 x_college_type_8 IN VARCHAR2,
2335 x_school_code_1 IN VARCHAR2,
2336 x_housing_code_1 IN VARCHAR2,
2337 x_school_code_2 IN VARCHAR2,
2338 x_housing_code_2 IN VARCHAR2,
2339 x_school_code_3 IN VARCHAR2,
2340 x_housing_code_3 IN VARCHAR2,
2341 x_school_code_4 IN VARCHAR2,
2342 x_housing_code_4 IN VARCHAR2,
2343 x_school_code_5 IN VARCHAR2,
2344 x_housing_code_5 IN VARCHAR2,
2345 x_school_code_6 IN VARCHAR2,
2346 x_housing_code_6 IN VARCHAR2,
2347 x_school_code_7 IN VARCHAR2,
2348 x_housing_code_7 IN VARCHAR2,
2349 x_school_code_8 IN VARCHAR2,
2350 x_housing_code_8 IN VARCHAR2,
2351 x_school_code_9 IN VARCHAR2,
2352 x_housing_code_9 IN VARCHAR2,
2353 x_school_code_10 IN VARCHAR2,
2354 x_housing_code_10 IN VARCHAR2,
2355 x_additional_school_code_1 IN VARCHAR2,
2356 x_additional_school_code_2 IN VARCHAR2,
2357 x_additional_school_code_3 IN VARCHAR2,
2358 x_additional_school_code_4 IN VARCHAR2,
2359 x_additional_school_code_5 IN VARCHAR2,
2360 x_additional_school_code_6 IN VARCHAR2,
2361 x_additional_school_code_7 IN VARCHAR2,
2362 x_additional_school_code_8 IN VARCHAR2,
2363 x_additional_school_code_9 IN VARCHAR2,
2364 x_additional_school_code_10 IN VARCHAR2,
2365 x_explanation_spec_circum IN VARCHAR2,
2366 x_signature_student IN VARCHAR2,
2367 x_signature_spouse IN VARCHAR2,
2368 x_signature_father IN VARCHAR2,
2369 x_signature_mother IN VARCHAR2,
2370 x_month_day_completed IN VARCHAR2,
2371 x_year_completed IN VARCHAR2,
2372 x_age_line_2 IN VARCHAR2,
2373 x_age_line_3 IN VARCHAR2,
2374 x_age_line_4 IN VARCHAR2,
2375 x_age_line_5 IN VARCHAR2,
2376 x_age_line_6 IN VARCHAR2,
2377 x_age_line_7 IN VARCHAR2,
2378 x_age_line_8 IN VARCHAR2,
2379 x_a_online_signature IN VARCHAR2,
2380 x_question_1_number IN VARCHAR2,
2381 x_question_1_size IN VARCHAR2,
2382 x_question_1_answer IN VARCHAR2,
2383 x_question_2_number IN VARCHAR2,
2384 x_question_2_size IN VARCHAR2,
2385 x_question_2_answer IN VARCHAR2,
2386 x_question_3_number IN VARCHAR2,
2387 x_question_3_size IN VARCHAR2,
2388 x_question_3_answer IN VARCHAR2,
2389 x_question_4_number IN VARCHAR2,
2390 x_question_4_size IN VARCHAR2,
2391 x_question_4_answer IN VARCHAR2,
2392 x_question_5_number IN VARCHAR2,
2393 x_question_5_size IN VARCHAR2,
2394 x_question_5_answer IN VARCHAR2,
2395 x_question_6_number IN VARCHAR2,
2396 x_question_6_size IN VARCHAR2,
2397 x_question_6_answer IN VARCHAR2,
2398 x_question_7_number IN VARCHAR2,
2399 x_question_7_size IN VARCHAR2,
2400 x_question_7_answer IN VARCHAR2,
2401 x_question_8_number IN VARCHAR2,
2402 x_question_8_size IN VARCHAR2,
2403 x_question_8_answer IN VARCHAR2,
2404 x_question_9_number IN VARCHAR2,
2405 x_question_9_size IN VARCHAR2,
2406 x_question_9_answer IN VARCHAR2,
2407 x_question_10_number IN VARCHAR2,
2408 x_question_10_size IN VARCHAR2,
2409 x_question_10_answer IN VARCHAR2,
2410 x_question_11_number IN VARCHAR2,
2414 x_question_12_size IN VARCHAR2,
2411 x_question_11_size IN VARCHAR2,
2412 x_question_11_answer IN VARCHAR2,
2413 x_question_12_number IN VARCHAR2,
2415 x_question_12_answer IN VARCHAR2,
2416 x_question_13_number IN VARCHAR2,
2417 x_question_13_size IN VARCHAR2,
2418 x_question_13_answer IN VARCHAR2,
2419 x_question_14_number IN VARCHAR2,
2420 x_question_14_size IN VARCHAR2,
2421 x_question_14_answer IN VARCHAR2,
2422 x_question_15_number IN VARCHAR2,
2423 x_question_15_size IN VARCHAR2,
2424 x_question_15_answer IN VARCHAR2,
2425 x_question_16_number IN VARCHAR2,
2426 x_question_16_size IN VARCHAR2,
2427 x_question_16_answer IN VARCHAR2,
2428 x_question_17_number IN VARCHAR2,
2429 x_question_17_size IN VARCHAR2,
2430 x_question_17_answer IN VARCHAR2,
2431 x_question_18_number IN VARCHAR2,
2432 x_question_18_size IN VARCHAR2,
2433 x_question_18_answer IN VARCHAR2,
2434 x_question_19_number IN VARCHAR2,
2435 x_question_19_size IN VARCHAR2,
2436 x_question_19_answer IN VARCHAR2,
2437 x_question_20_number IN VARCHAR2,
2438 x_question_20_size IN VARCHAR2,
2439 x_question_20_answer IN VARCHAR2,
2440 x_question_21_number IN VARCHAR2,
2441 x_question_21_size IN VARCHAR2,
2442 x_question_21_answer IN VARCHAR2,
2443 x_question_22_number IN VARCHAR2,
2444 x_question_22_size IN VARCHAR2,
2445 x_question_22_answer IN VARCHAR2,
2446 x_question_23_number IN VARCHAR2,
2447 x_question_23_size IN VARCHAR2,
2448 x_question_23_answer IN VARCHAR2,
2449 x_question_24_number IN VARCHAR2,
2450 x_question_24_size IN VARCHAR2,
2451 x_question_24_answer IN VARCHAR2,
2452 x_question_25_number IN VARCHAR2,
2453 x_question_25_size IN VARCHAR2,
2454 x_question_25_answer IN VARCHAR2,
2455 x_question_26_number IN VARCHAR2,
2456 x_question_26_size IN VARCHAR2,
2457 x_question_26_answer IN VARCHAR2,
2458 x_question_27_number IN VARCHAR2,
2459 x_question_27_size IN VARCHAR2,
2460 x_question_27_answer IN VARCHAR2,
2461 x_question_28_number IN VARCHAR2,
2462 x_question_28_size IN VARCHAR2,
2463 x_question_28_answer IN VARCHAR2,
2464 x_question_29_number IN VARCHAR2,
2465 x_question_29_size IN VARCHAR2,
2466 x_question_29_answer IN VARCHAR2,
2467 x_question_30_number IN VARCHAR2,
2468 x_questions_30_size IN VARCHAR2,
2469 x_question_30_answer IN VARCHAR2,
2470 x_r_s_email_address IN VARCHAR2,
2471 x_eps_code IN VARCHAR2,
2472 x_comp_css_dependency_status IN VARCHAR2,
2473 x_stu_age IN VARCHAR2,
2474 x_assumed_stu_yr_in_coll IN VARCHAR2,
2475 x_comp_stu_marital_status IN VARCHAR2,
2476 x_stu_family_members IN VARCHAR2,
2477 x_stu_fam_members_in_college IN VARCHAR2,
2478 x_par_marital_status IN VARCHAR2,
2479 x_par_family_members IN VARCHAR2,
2480 x_par_total_in_college IN VARCHAR2,
2481 x_par_par_in_college IN VARCHAR2,
2482 x_par_others_in_college IN VARCHAR2,
2483 x_par_aesa IN VARCHAR2,
2484 x_par_cesa IN VARCHAR2,
2485 x_stu_aesa IN VARCHAR2,
2486 x_stu_cesa IN VARCHAR2,
2487 x_im_p_bas_agi_taxable_income IN VARCHAR2,
2488 x_im_p_bas_untx_inc_and_ben IN VARCHAR2,
2489 x_im_p_bas_inc_adj IN VARCHAR2,
2490 x_im_p_bas_total_income IN VARCHAR2,
2491 x_im_p_bas_us_income_tax IN VARCHAR2,
2492 x_im_p_bas_st_and_other_tax IN VARCHAR2,
2493 x_im_p_bas_fica_tax IN VARCHAR2,
2494 x_im_p_bas_med_dental IN VARCHAR2,
2495 x_im_p_bas_employment_allow IN VARCHAR2,
2496 x_im_p_bas_annual_ed_savings IN VARCHAR2,
2497 x_im_p_bas_inc_prot_allow_m IN VARCHAR2,
2498 x_im_p_bas_total_inc_allow IN VARCHAR2,
2499 x_im_p_bas_cal_avail_inc IN VARCHAR2,
2500 x_im_p_bas_avail_income IN VARCHAR2,
2501 x_im_p_bas_total_cont_inc IN VARCHAR2,
2502 x_im_p_bas_cash_bank_accounts IN VARCHAR2,
2503 x_im_p_bas_home_equity IN VARCHAR2,
2504 x_im_p_bas_ot_rl_est_inv_eq IN VARCHAR2,
2505 x_im_p_bas_adj_bus_farm_worth IN VARCHAR2,
2506 x_im_p_bas_ass_sibs_pre_tui IN VARCHAR2,
2510 x_im_p_bas_low_inc_allow IN VARCHAR2,
2507 x_im_p_bas_net_worth IN VARCHAR2,
2508 x_im_p_bas_emerg_res_allow IN VARCHAR2,
2509 x_im_p_bas_cum_ed_savings IN VARCHAR2,
2511 x_im_p_bas_total_asset_allow IN VARCHAR2,
2512 x_im_p_bas_disc_net_worth IN VARCHAR2,
2513 x_im_p_bas_total_cont_asset IN VARCHAR2,
2514 x_im_p_bas_total_cont IN VARCHAR2,
2515 x_im_p_bas_num_in_coll_adj IN VARCHAR2,
2516 x_im_p_bas_cont_for_stu IN VARCHAR2,
2517 x_im_p_bas_cont_from_income IN VARCHAR2,
2518 x_im_p_bas_cont_from_assets IN VARCHAR2,
2519 x_im_p_opt_agi_taxable_income IN VARCHAR2,
2520 x_im_p_opt_untx_inc_and_ben IN VARCHAR2,
2521 x_im_p_opt_inc_adj IN VARCHAR2,
2522 x_im_p_opt_total_income IN VARCHAR2,
2523 x_im_p_opt_us_income_tax IN VARCHAR2,
2524 x_im_p_opt_st_and_other_tax IN VARCHAR2,
2525 x_im_p_opt_fica_tax IN VARCHAR2,
2526 x_im_p_opt_med_dental IN VARCHAR2,
2527 x_im_p_opt_elem_sec_tuit IN VARCHAR2,
2528 x_im_p_opt_employment_allow IN VARCHAR2,
2529 x_im_p_opt_annual_ed_savings IN VARCHAR2,
2530 x_im_p_opt_inc_prot_allow_m IN VARCHAR2,
2531 x_im_p_opt_total_inc_allow IN VARCHAR2,
2532 x_im_p_opt_cal_avail_inc IN VARCHAR2,
2533 x_im_p_opt_avail_income IN VARCHAR2,
2534 x_im_p_opt_total_cont_inc IN VARCHAR2,
2535 x_im_p_opt_cash_bank_accounts IN VARCHAR2,
2536 x_im_p_opt_home_equity IN VARCHAR2,
2537 x_im_p_opt_ot_rl_est_inv_eq IN VARCHAR2,
2538 x_im_p_opt_adj_bus_farm_worth IN VARCHAR2,
2539 x_im_p_opt_ass_sibs_pre_t IN VARCHAR2,
2540 x_im_p_opt_net_worth IN VARCHAR2,
2541 x_im_p_opt_emerg_res_allow IN VARCHAR2,
2542 x_im_p_opt_cum_ed_savings IN VARCHAR2,
2543 x_im_p_opt_low_inc_allow IN VARCHAR2,
2544 x_im_p_opt_total_asset_allow IN VARCHAR2,
2545 x_im_p_opt_disc_net_worth IN VARCHAR2,
2546 x_im_p_opt_total_cont_asset IN VARCHAR2,
2547 x_im_p_opt_total_cont IN VARCHAR2,
2548 x_im_p_opt_num_in_coll_adj IN VARCHAR2,
2549 x_im_p_opt_cont_for_stu IN VARCHAR2,
2550 x_im_p_opt_cont_from_income IN VARCHAR2,
2551 x_im_p_opt_cont_from_assets IN VARCHAR2,
2552 x_fm_p_analysis_type IN VARCHAR2,
2553 x_fm_p_agi_taxable_income IN VARCHAR2,
2554 x_fm_p_untx_inc_and_ben IN VARCHAR2,
2555 x_fm_p_inc_adj IN VARCHAR2,
2556 x_fm_p_total_income IN VARCHAR2,
2557 x_fm_p_us_income_tax IN VARCHAR2,
2558 x_fm_p_state_and_other_taxes IN VARCHAR2,
2559 x_fm_p_fica_tax IN VARCHAR2,
2560 x_fm_p_employment_allow IN VARCHAR2,
2561 x_fm_p_income_prot_allow IN VARCHAR2,
2562 x_fm_p_total_allow IN VARCHAR2,
2563 x_fm_p_avail_income IN VARCHAR2,
2564 x_fm_p_cash_bank_accounts IN VARCHAR2,
2565 x_fm_p_ot_rl_est_inv_eq IN VARCHAR2,
2566 x_fm_p_adj_bus_farm_net_worth IN VARCHAR2,
2567 x_fm_p_net_worth IN VARCHAR2,
2568 x_fm_p_asset_prot_allow IN VARCHAR2,
2569 x_fm_p_disc_net_worth IN VARCHAR2,
2570 x_fm_p_total_contribution IN VARCHAR2,
2571 x_fm_p_num_in_coll IN VARCHAR2,
2572 x_fm_p_cont_for_stu IN VARCHAR2,
2573 x_fm_p_cont_from_income IN VARCHAR2,
2574 x_fm_p_cont_from_assets IN VARCHAR2,
2575 x_im_s_bas_agi_taxable_income IN VARCHAR2,
2576 x_im_s_bas_untx_inc_and_ben IN VARCHAR2,
2577 x_im_s_bas_inc_adj IN VARCHAR2,
2578 x_im_s_bas_total_income IN VARCHAR2,
2579 x_im_s_bas_us_income_tax IN VARCHAR2,
2580 x_im_s_bas_st_and_oth_tax IN VARCHAR2,
2581 x_im_s_bas_fica_tax IN VARCHAR2,
2582 x_im_s_bas_med_dental IN VARCHAR2,
2583 x_im_s_bas_employment_allow IN VARCHAR2,
2584 x_im_s_bas_annual_ed_savings IN VARCHAR2,
2585 x_im_s_bas_inc_prot_allow_m IN VARCHAR2,
2586 x_im_s_bas_total_inc_allow IN VARCHAR2,
2587 x_im_s_bas_cal_avail_income IN VARCHAR2,
2588 x_im_s_bas_avail_income IN VARCHAR2,
2589 x_im_s_bas_total_cont_inc IN VARCHAR2,
2590 x_im_s_bas_cash_bank_accounts IN VARCHAR2,
2591 x_im_s_bas_home_equity IN VARCHAR2,
2592 x_im_s_bas_ot_rl_est_inv_eq IN VARCHAR2,
2593 x_im_s_bas_adj_bus_farm_worth IN VARCHAR2,
2594 x_im_s_bas_trusts IN VARCHAR2,
2595 x_im_s_bas_net_worth IN VARCHAR2,
2596 x_im_s_bas_emerg_res_allow IN VARCHAR2,
2597 x_im_s_bas_cum_ed_savings IN VARCHAR2,
2598 x_im_s_bas_total_asset_allow IN VARCHAR2,
2599 x_im_s_bas_disc_net_worth IN VARCHAR2,
2600 x_im_s_bas_total_cont_asset IN VARCHAR2,
2601 x_im_s_bas_total_cont IN VARCHAR2,
2602 x_im_s_bas_num_in_coll_adj IN VARCHAR2,
2606 x_im_s_est_agi_taxable_income IN VARCHAR2,
2603 x_im_s_bas_cont_for_stu IN VARCHAR2,
2604 x_im_s_bas_cont_from_income IN VARCHAR2,
2605 x_im_s_bas_cont_from_assets IN VARCHAR2,
2607 x_im_s_est_untx_inc_and_ben IN VARCHAR2,
2608 x_im_s_est_inc_adj IN VARCHAR2,
2609 x_im_s_est_total_income IN VARCHAR2,
2610 x_im_s_est_us_income_tax IN VARCHAR2,
2611 x_im_s_est_st_and_oth_tax IN VARCHAR2,
2612 x_im_s_est_fica_tax IN VARCHAR2,
2613 x_im_s_est_med_dental IN VARCHAR2,
2614 x_im_s_est_employment_allow IN VARCHAR2,
2615 x_im_s_est_annual_ed_savings IN VARCHAR2,
2616 x_im_s_est_inc_prot_allow_m IN VARCHAR2,
2617 x_im_s_est_total_inc_allow IN VARCHAR2,
2618 x_im_s_est_cal_avail_income IN VARCHAR2,
2619 x_im_s_est_avail_income IN VARCHAR2,
2620 x_im_s_est_total_cont_inc IN VARCHAR2,
2621 x_im_s_est_cash_bank_accounts IN VARCHAR2,
2622 x_im_s_est_home_equity IN VARCHAR2,
2623 x_im_s_est_ot_rl_est_inv_equ IN VARCHAR2,
2624 x_im_s_est_adj_bus_farm_worth IN VARCHAR2,
2625 x_im_s_est_est_trusts IN VARCHAR2,
2626 x_im_s_est_net_worth IN VARCHAR2,
2627 x_im_s_est_emerg_res_allow IN VARCHAR2,
2628 x_im_s_est_cum_ed_savings IN VARCHAR2,
2629 x_im_s_est_total_asset_allow IN VARCHAR2,
2630 x_im_s_est_disc_net_worth IN VARCHAR2,
2631 x_im_s_est_total_cont_asset IN VARCHAR2,
2632 x_im_s_est_total_cont IN VARCHAR2,
2633 x_im_s_est_num_in_coll_adj IN VARCHAR2,
2634 x_im_s_est_cont_for_stu IN VARCHAR2,
2635 x_im_s_est_cont_from_income IN VARCHAR2,
2636 x_im_s_est_cont_from_assets IN VARCHAR2,
2637 x_im_s_opt_agi_taxable_income IN VARCHAR2,
2638 x_im_s_opt_untx_inc_and_ben IN VARCHAR2,
2639 x_im_s_opt_inc_adj IN VARCHAR2,
2640 x_im_s_opt_total_income IN VARCHAR2,
2641 x_im_s_opt_us_income_tax IN VARCHAR2,
2642 x_im_s_opt_state_and_oth_taxes IN VARCHAR2,
2643 x_im_s_opt_fica_tax IN VARCHAR2,
2644 x_im_s_opt_med_dental IN VARCHAR2,
2645 x_im_s_opt_employment_allow IN VARCHAR2,
2646 x_im_s_opt_annual_ed_savings IN VARCHAR2,
2647 x_im_s_opt_inc_prot_allow_m IN VARCHAR2,
2648 x_im_s_opt_total_inc_allow IN VARCHAR2,
2649 x_im_s_opt_cal_avail_income IN VARCHAR2,
2650 x_im_s_opt_avail_income IN VARCHAR2,
2651 x_im_s_opt_total_cont_inc IN VARCHAR2,
2652 x_im_s_opt_cash_bank_accounts IN VARCHAR2,
2653 x_im_s_opt_ira_keogh_accounts IN VARCHAR2,
2654 x_im_s_opt_home_equity IN VARCHAR2,
2655 x_im_s_opt_ot_rl_est_inv_eq IN VARCHAR2,
2656 x_im_s_opt_adj_bus_farm_worth IN VARCHAR2,
2657 x_im_s_opt_trusts IN VARCHAR2,
2658 x_im_s_opt_net_worth IN VARCHAR2,
2659 x_im_s_opt_emerg_res_allow IN VARCHAR2,
2660 x_im_s_opt_cum_ed_savings IN VARCHAR2,
2661 x_im_s_opt_total_asset_allow IN VARCHAR2,
2662 x_im_s_opt_disc_net_worth IN VARCHAR2,
2663 x_im_s_opt_total_cont_asset IN VARCHAR2,
2664 x_im_s_opt_total_cont IN VARCHAR2,
2665 x_im_s_opt_num_in_coll_adj IN VARCHAR2,
2666 x_im_s_opt_cont_for_stu IN VARCHAR2,
2667 x_im_s_opt_cont_from_income IN VARCHAR2,
2668 x_im_s_opt_cont_from_assets IN VARCHAR2,
2669 x_fm_s_analysis_type IN VARCHAR2,
2670 x_fm_s_agi_taxable_income IN VARCHAR2,
2671 x_fm_s_untx_inc_and_ben IN VARCHAR2,
2672 x_fm_s_inc_adj IN VARCHAR2,
2673 x_fm_s_total_income IN VARCHAR2,
2674 x_fm_s_us_income_tax IN VARCHAR2,
2675 x_fm_s_state_and_oth_taxes IN VARCHAR2,
2676 x_fm_s_fica_tax IN VARCHAR2,
2677 x_fm_s_employment_allow IN VARCHAR2,
2678 x_fm_s_income_prot_allow IN VARCHAR2,
2679 x_fm_s_total_allow IN VARCHAR2,
2680 x_fm_s_cal_avail_income IN VARCHAR2,
2681 x_fm_s_avail_income IN VARCHAR2,
2682 x_fm_s_cash_bank_accounts IN VARCHAR2,
2683 x_fm_s_ot_rl_est_inv_equity IN VARCHAR2,
2684 x_fm_s_adj_bus_farm_worth IN VARCHAR2,
2685 x_fm_s_trusts IN VARCHAR2,
2686 x_fm_s_net_worth IN VARCHAR2,
2687 x_fm_s_asset_prot_allow IN VARCHAR2,
2688 x_fm_s_disc_net_worth IN VARCHAR2,
2689 x_fm_s_total_cont IN VARCHAR2,
2690 x_fm_s_num_in_coll IN VARCHAR2,
2691 x_fm_s_cont_for_stu IN VARCHAR2,
2692 x_fm_s_cont_from_income IN VARCHAR2,
2693 x_fm_s_cont_from_assets IN VARCHAR2,
2694 x_im_inst_resident_ind IN VARCHAR2,
2695 x_institutional_1_budget_name IN VARCHAR2,
2696 x_im_inst_1_budget_duration IN VARCHAR2,
2697 x_im_inst_1_tuition_fees IN VARCHAR2,
2698 x_im_inst_1_books_supplies IN VARCHAR2,
2702 x_im_inst_1_tot_par_cont IN VARCHAR2,
2699 x_im_inst_1_living_expenses IN VARCHAR2,
2700 x_im_inst_1_tot_expenses IN VARCHAR2,
2701 x_im_inst_1_tot_stu_cont IN VARCHAR2,
2703 x_im_inst_1_tot_family_cont IN VARCHAR2,
2704 x_im_inst_1_va_benefits IN VARCHAR2,
2705 x_im_inst_1_ot_cont IN VARCHAR2,
2706 x_im_inst_1_est_financial_need IN VARCHAR2,
2707 x_institutional_2_budget_name IN VARCHAR2,
2708 x_im_inst_2_budget_duration IN VARCHAR2,
2709 x_im_inst_2_tuition_fees IN VARCHAR2,
2710 x_im_inst_2_books_supplies IN VARCHAR2,
2711 x_im_inst_2_living_expenses IN VARCHAR2,
2712 x_im_inst_2_tot_expenses IN VARCHAR2,
2713 x_im_inst_2_tot_stu_cont IN VARCHAR2,
2714 x_im_inst_2_tot_par_cont IN VARCHAR2,
2715 x_im_inst_2_tot_family_cont IN VARCHAR2,
2716 x_im_inst_2_va_benefits IN VARCHAR2,
2717 x_im_inst_2_est_financial_need IN VARCHAR2,
2718 x_institutional_3_budget_name IN VARCHAR2,
2719 x_im_inst_3_budget_duration IN VARCHAR2,
2720 x_im_inst_3_tuition_fees IN VARCHAR2,
2721 x_im_inst_3_books_supplies IN VARCHAR2,
2722 x_im_inst_3_living_expenses IN VARCHAR2,
2723 x_im_inst_3_tot_expenses IN VARCHAR2,
2724 x_im_inst_3_tot_stu_cont IN VARCHAR2,
2725 x_im_inst_3_tot_par_cont IN VARCHAR2,
2726 x_im_inst_3_tot_family_cont IN VARCHAR2,
2727 x_im_inst_3_va_benefits IN VARCHAR2,
2728 x_im_inst_3_est_financial_need IN VARCHAR2,
2729 x_fm_inst_1_federal_efc IN VARCHAR2,
2730 x_fm_inst_1_va_benefits IN VARCHAR2,
2731 x_fm_inst_1_fed_eligibility IN VARCHAR2,
2732 x_fm_inst_1_pell IN VARCHAR2,
2733 x_option_par_loss_allow_ind IN VARCHAR2,
2734 x_option_par_tuition_ind IN VARCHAR2,
2735 x_option_par_home_ind IN VARCHAR2,
2736 x_option_par_home_value IN VARCHAR2,
2737 x_option_par_home_debt IN VARCHAR2,
2738 x_option_stu_ira_keogh_ind IN VARCHAR2,
2739 x_option_stu_home_ind IN VARCHAR2,
2740 x_option_stu_home_value IN VARCHAR2,
2741 x_option_stu_home_debt IN VARCHAR2,
2742 x_option_stu_sum_ay_inc_ind IN VARCHAR2,
2743 x_option_par_hope_ll_credit IN VARCHAR2,
2744 x_option_stu_hope_ll_credit IN VARCHAR2,
2745 x_im_parent_1_8_months_bas IN VARCHAR2,
2746 x_im_p_more_than_9_mth_ba IN VARCHAR2,
2747 x_im_parent_1_8_months_opt IN VARCHAR2,
2748 x_im_p_more_than_9_mth_op IN VARCHAR2,
2749 x_fnar_message_1 IN VARCHAR2,
2750 x_fnar_message_2 IN VARCHAR2,
2751 x_fnar_message_3 IN VARCHAR2,
2752 x_fnar_message_4 IN VARCHAR2,
2753 x_fnar_message_5 IN VARCHAR2,
2754 x_fnar_message_6 IN VARCHAR2,
2755 x_fnar_message_7 IN VARCHAR2,
2756 x_fnar_message_8 IN VARCHAR2,
2757 x_fnar_message_9 IN VARCHAR2,
2758 x_fnar_message_10 IN VARCHAR2,
2759 x_fnar_message_11 IN VARCHAR2,
2760 x_fnar_message_12 IN VARCHAR2,
2761 x_fnar_message_13 IN VARCHAR2,
2762 x_fnar_message_20 IN VARCHAR2,
2763 x_fnar_message_21 IN VARCHAR2,
2764 x_fnar_message_22 IN VARCHAR2,
2765 x_fnar_message_23 IN VARCHAR2,
2766 x_fnar_message_24 IN VARCHAR2,
2767 x_fnar_message_25 IN VARCHAR2,
2768 x_fnar_message_26 IN VARCHAR2,
2769 x_fnar_message_27 IN VARCHAR2,
2770 x_fnar_message_30 IN VARCHAR2,
2771 x_fnar_message_31 IN VARCHAR2,
2772 x_fnar_message_32 IN VARCHAR2,
2773 x_fnar_message_33 IN VARCHAR2,
2774 x_fnar_message_34 IN VARCHAR2,
2775 x_fnar_message_35 IN VARCHAR2,
2776 x_fnar_message_36 IN VARCHAR2,
2777 x_fnar_message_37 IN VARCHAR2,
2778 x_fnar_message_38 IN VARCHAR2,
2779 x_fnar_message_39 IN VARCHAR2,
2780 x_fnar_message_45 IN VARCHAR2,
2781 x_fnar_message_46 IN VARCHAR2,
2782 x_fnar_message_47 IN VARCHAR2,
2783 x_fnar_message_48 IN VARCHAR2,
2784 x_fnar_message_50 IN VARCHAR2,
2785 x_fnar_message_51 IN VARCHAR2,
2786 x_fnar_message_52 IN VARCHAR2,
2787 x_fnar_message_53 IN VARCHAR2,
2788 x_fnar_message_56 IN VARCHAR2,
2789 x_fnar_message_57 IN VARCHAR2,
2790 x_fnar_message_58 IN VARCHAR2,
2791 x_fnar_message_59 IN VARCHAR2,
2792 x_fnar_message_60 IN VARCHAR2,
2793 x_fnar_message_61 IN VARCHAR2,
2794 x_fnar_message_62 IN VARCHAR2,
2798 x_fnar_message_71 IN VARCHAR2,
2795 x_fnar_message_63 IN VARCHAR2,
2796 x_fnar_message_64 IN VARCHAR2,
2797 x_fnar_message_65 IN VARCHAR2,
2799 x_fnar_message_72 IN VARCHAR2,
2800 x_fnar_message_73 IN VARCHAR2,
2801 x_fnar_message_74 IN VARCHAR2,
2802 x_fnar_message_75 IN VARCHAR2,
2803 x_fnar_message_76 IN VARCHAR2,
2804 x_fnar_message_77 IN VARCHAR2,
2805 x_fnar_message_78 IN VARCHAR2,
2806 x_fnar_mesg_10_stu_fam_mem IN VARCHAR2,
2807 x_fnar_mesg_11_stu_no_in_coll IN VARCHAR2,
2808 x_fnar_mesg_24_stu_avail_inc IN VARCHAR2,
2809 x_fnar_mesg_26_stu_taxes IN VARCHAR2,
2810 x_fnar_mesg_33_stu_home_value IN VARCHAR2,
2811 x_fnar_mesg_34_stu_home_value IN VARCHAR2,
2812 x_fnar_mesg_34_stu_home_equity IN VARCHAR2,
2813 x_fnar_mesg_35_stu_home_value IN VARCHAR2,
2814 x_fnar_mesg_35_stu_home_equity IN VARCHAR2,
2815 x_fnar_mesg_36_stu_home_equity IN VARCHAR2,
2816 x_fnar_mesg_48_par_fam_mem IN VARCHAR2,
2817 x_fnar_mesg_49_par_no_in_coll IN VARCHAR2,
2818 x_fnar_mesg_56_par_agi IN VARCHAR2,
2819 x_fnar_mesg_62_par_taxes IN VARCHAR2,
2820 x_fnar_mesg_73_par_home_value IN VARCHAR2,
2821 x_fnar_mesg_74_par_home_value IN VARCHAR2,
2822 x_fnar_mesg_74_par_home_equity IN VARCHAR2,
2823 x_fnar_mesg_75_par_home_value IN VARCHAR2,
2824 x_fnar_mesg_75_par_home_equity IN VARCHAR2,
2825 x_fnar_mesg_76_par_home_equity IN VARCHAR2,
2826 x_assumption_message_1 IN VARCHAR2,
2827 x_assumption_message_2 IN VARCHAR2,
2828 x_assumption_message_3 IN VARCHAR2,
2829 x_assumption_message_4 IN VARCHAR2,
2830 x_assumption_message_5 IN VARCHAR2,
2831 x_assumption_message_6 IN VARCHAR2,
2832 x_record_mark IN VARCHAR2,
2833 x_option_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
2834 x_option_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
2835 x_option_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
2836 x_option_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
2837 x_option_par_cola_adj_value IN VARCHAR2 DEFAULT NULL,
2838 x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
2839 x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
2840 x_p_soc_sec_ben_student_amt IN NUMBER DEFAULT NULL,
2841 x_p_tuit_fee_deduct_amt IN NUMBER DEFAULT NULL,
2842 x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
2843 x_stu_lives_with_num IN NUMBER DEFAULT NULL,
2844 x_stu_most_support_from_num IN NUMBER DEFAULT NULL,
2845 x_location_computer_num IN NUMBER DEFAULT NULL,
2846 x_cust_parent_cont_adj_num IN NUMBER DEFAULT NULL,
2847 x_custodial_parent_num IN NUMBER DEFAULT NULL,
2848 x_cust_par_base_prcnt_inc_amt IN NUMBER DEFAULT NULL,
2849 x_cust_par_base_cont_inc_amt IN NUMBER DEFAULT NULL,
2850 x_cust_par_base_cont_ast_amt IN NUMBER DEFAULT NULL,
2851 x_cust_par_base_tot_cont_amt IN NUMBER DEFAULT NULL,
2852 x_cust_par_opt_prcnt_inc_amt IN NUMBER DEFAULT NULL,
2853 x_cust_par_opt_cont_inc_amt IN NUMBER DEFAULT NULL,
2854 x_cust_par_opt_cont_ast_amt IN NUMBER DEFAULT NULL,
2855 x_cust_par_opt_tot_cont_amt IN NUMBER DEFAULT NULL,
2856 x_parents_email_txt IN VARCHAR2 DEFAULT NULL,
2857 x_parent_1_birth_date IN DATE DEFAULT NULL,
2858 x_parent_2_birth_date IN DATE DEFAULT NULL,
2859 x_match_code IN VARCHAR2 DEFAULT NULL,
2860 x_mode IN VARCHAR2 DEFAULT 'R'
2861 );
2862
2863 PROCEDURE delete_row (
2864 x_rowid IN VARCHAR2
2865 );
2866
2867 FUNCTION get_pk_for_validation (
2868 x_css_id IN NUMBER
2869 ) RETURN BOOLEAN;
2870
2871 PROCEDURE before_dml (
2872 p_action IN VARCHAR2,
2873 x_rowid IN VARCHAR2 DEFAULT NULL,
2874 x_css_id IN NUMBER DEFAULT NULL,
2875 x_record_status IN VARCHAR2 DEFAULT NULL,
2876 x_college_code IN VARCHAR2 DEFAULT NULL,
2877 x_academic_year IN VARCHAR2 DEFAULT NULL,
2878 x_stu_record_type IN VARCHAR2 DEFAULT NULL,
2879 x_css_id_number IN VARCHAR2 DEFAULT NULL,
2880 x_registration_receipt_date IN VARCHAR2 DEFAULT NULL,
2881 x_registration_type IN VARCHAR2 DEFAULT NULL,
2882 x_application_receipt_date IN VARCHAR2 DEFAULT NULL,
2883 x_application_type IN VARCHAR2 DEFAULT NULL,
2884 x_original_fnar_compute IN VARCHAR2 DEFAULT NULL,
2885 x_revision_fnar_compute_date IN VARCHAR2 DEFAULT NULL,
2886 x_electronic_extract_date IN VARCHAR2 DEFAULT NULL,
2890 x_first_name IN VARCHAR2 DEFAULT NULL,
2887 x_institutional_reporting_type IN VARCHAR2 DEFAULT NULL,
2888 x_asr_receipt_date IN VARCHAR2 DEFAULT NULL,
2889 x_last_name IN VARCHAR2 DEFAULT NULL,
2891 x_middle_initial IN VARCHAR2 DEFAULT NULL,
2892 x_address_number_and_street IN VARCHAR2 DEFAULT NULL,
2893 x_city IN VARCHAR2 DEFAULT NULL,
2894 x_state_mailing IN VARCHAR2 DEFAULT NULL,
2895 x_zip_code IN VARCHAR2 DEFAULT NULL,
2896 x_s_telephone_number IN VARCHAR2 DEFAULT NULL,
2897 x_s_title IN VARCHAR2 DEFAULT NULL,
2898 x_date_of_birth IN VARCHAR2 DEFAULT NULL,
2899 x_social_security_number IN VARCHAR2 DEFAULT NULL,
2900 x_state_legal_residence IN VARCHAR2 DEFAULT NULL,
2901 x_foreign_address_indicator IN VARCHAR2 DEFAULT NULL,
2902 x_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
2903 x_country IN VARCHAR2 DEFAULT NULL,
2904 x_financial_aid_status IN VARCHAR2 DEFAULT NULL,
2905 x_year_in_college IN VARCHAR2 DEFAULT NULL,
2906 x_marital_status IN VARCHAR2 DEFAULT NULL,
2907 x_ward_court IN VARCHAR2 DEFAULT NULL,
2908 x_legal_dependents_other IN VARCHAR2 DEFAULT NULL,
2909 x_household_size IN VARCHAR2 DEFAULT NULL,
2910 x_number_in_college IN VARCHAR2 DEFAULT NULL,
2911 x_citizenship_status IN VARCHAR2 DEFAULT NULL,
2912 x_citizenship_country IN VARCHAR2 DEFAULT NULL,
2913 x_visa_classification IN VARCHAR2 DEFAULT NULL,
2914 x_tax_figures IN VARCHAR2 DEFAULT NULL,
2915 x_number_exemptions IN VARCHAR2 DEFAULT NULL,
2916 x_adjusted_gross_inc IN VARCHAR2 DEFAULT NULL,
2917 x_us_tax_paid IN VARCHAR2 DEFAULT NULL,
2918 x_itemized_deductions IN VARCHAR2 DEFAULT NULL,
2919 x_stu_income_work IN VARCHAR2 DEFAULT NULL,
2920 x_spouse_income_work IN VARCHAR2 DEFAULT NULL,
2921 x_divid_int_inc IN VARCHAR2 DEFAULT NULL,
2922 x_soc_sec_benefits IN VARCHAR2 DEFAULT NULL,
2923 x_welfare_tanf IN VARCHAR2 DEFAULT NULL,
2924 x_child_supp_rcvd IN VARCHAR2 DEFAULT NULL,
2925 x_earned_income_credit IN VARCHAR2 DEFAULT NULL,
2926 x_other_untax_income IN VARCHAR2 DEFAULT NULL,
2927 x_tax_stu_aid IN VARCHAR2 DEFAULT NULL,
2928 x_cash_sav_check IN VARCHAR2 DEFAULT NULL,
2929 x_ira_keogh IN VARCHAR2 DEFAULT NULL,
2930 x_invest_value IN VARCHAR2 DEFAULT NULL,
2931 x_invest_debt IN VARCHAR2 DEFAULT NULL,
2932 x_home_value IN VARCHAR2 DEFAULT NULL,
2933 x_home_debt IN VARCHAR2 DEFAULT NULL,
2934 x_oth_real_value IN VARCHAR2 DEFAULT NULL,
2935 x_oth_real_debt IN VARCHAR2 DEFAULT NULL,
2936 x_bus_farm_value IN VARCHAR2 DEFAULT NULL,
2937 x_bus_farm_debt IN VARCHAR2 DEFAULT NULL,
2938 x_live_on_farm IN VARCHAR2 DEFAULT NULL,
2939 x_home_purch_price IN VARCHAR2 DEFAULT NULL,
2940 x_hope_ll_credit IN VARCHAR2 DEFAULT NULL,
2941 x_home_purch_year IN VARCHAR2 DEFAULT NULL,
2942 x_trust_amount IN VARCHAR2 DEFAULT NULL,
2943 x_trust_avail IN VARCHAR2 DEFAULT NULL,
2944 x_trust_estab IN VARCHAR2 DEFAULT NULL,
2945 x_child_support_paid IN VARCHAR2 DEFAULT NULL,
2946 x_med_dent_expenses IN VARCHAR2 DEFAULT NULL,
2947 x_vet_us IN VARCHAR2 DEFAULT NULL,
2948 x_vet_ben_amount IN VARCHAR2 DEFAULT NULL,
2949 x_vet_ben_months IN VARCHAR2 DEFAULT NULL,
2950 x_stu_summer_wages IN VARCHAR2 DEFAULT NULL,
2951 x_stu_school_yr_wages IN VARCHAR2 DEFAULT NULL,
2952 x_spouse_summer_wages IN VARCHAR2 DEFAULT NULL,
2953 x_spouse_school_yr_wages IN VARCHAR2 DEFAULT NULL,
2954 x_summer_other_tax_inc IN VARCHAR2 DEFAULT NULL,
2955 x_school_yr_other_tax_inc IN VARCHAR2 DEFAULT NULL,
2956 x_summer_untax_inc IN VARCHAR2 DEFAULT NULL,
2957 x_school_yr_untax_inc IN VARCHAR2 DEFAULT NULL,
2958 x_grants_schol_etc IN VARCHAR2 DEFAULT NULL,
2959 x_tuit_benefits IN VARCHAR2 DEFAULT NULL,
2960 x_cont_parents IN VARCHAR2 DEFAULT NULL,
2961 x_cont_relatives IN VARCHAR2 DEFAULT NULL,
2962 x_p_siblings_pre_tuit IN VARCHAR2 DEFAULT NULL,
2963 x_p_student_pre_tuit IN VARCHAR2 DEFAULT NULL,
2964 x_p_household_size IN VARCHAR2 DEFAULT NULL,
2968 x_p_state_legal_residence IN VARCHAR2 DEFAULT NULL,
2965 x_p_number_in_college IN VARCHAR2 DEFAULT NULL,
2966 x_p_parents_in_college IN VARCHAR2 DEFAULT NULL,
2967 x_p_marital_status IN VARCHAR2 DEFAULT NULL,
2969 x_p_natural_par_status IN VARCHAR2 DEFAULT NULL,
2970 x_p_child_supp_paid IN VARCHAR2 DEFAULT NULL,
2971 x_p_repay_ed_loans IN VARCHAR2 DEFAULT NULL,
2972 x_p_med_dent_expenses IN VARCHAR2 DEFAULT NULL,
2973 x_p_tuit_paid_amount IN VARCHAR2 DEFAULT NULL,
2974 x_p_tuit_paid_number IN VARCHAR2 DEFAULT NULL,
2975 x_p_exp_child_supp_paid IN VARCHAR2 DEFAULT NULL,
2976 x_p_exp_repay_ed_loans IN VARCHAR2 DEFAULT NULL,
2977 x_p_exp_med_dent_expenses IN VARCHAR2 DEFAULT NULL,
2978 x_p_exp_tuit_pd_amount IN VARCHAR2 DEFAULT NULL,
2979 x_p_exp_tuit_pd_number IN VARCHAR2 DEFAULT NULL,
2980 x_p_cash_sav_check IN VARCHAR2 DEFAULT NULL,
2981 x_p_month_mortgage_pay IN VARCHAR2 DEFAULT NULL,
2982 x_p_invest_value IN VARCHAR2 DEFAULT NULL,
2983 x_p_invest_debt IN VARCHAR2 DEFAULT NULL,
2984 x_p_home_value IN VARCHAR2 DEFAULT NULL,
2985 x_p_home_debt IN VARCHAR2 DEFAULT NULL,
2986 x_p_home_purch_price IN VARCHAR2 DEFAULT NULL,
2987 x_p_own_business_farm IN VARCHAR2 DEFAULT NULL,
2988 x_p_business_value IN VARCHAR2 DEFAULT NULL,
2989 x_p_business_debt IN VARCHAR2 DEFAULT NULL,
2990 x_p_farm_value IN VARCHAR2 DEFAULT NULL,
2991 x_p_farm_debt IN VARCHAR2 DEFAULT NULL,
2992 x_p_live_on_farm IN VARCHAR2 DEFAULT NULL,
2993 x_p_oth_real_estate_value IN VARCHAR2 DEFAULT NULL,
2994 x_p_oth_real_estate_debt IN VARCHAR2 DEFAULT NULL,
2995 x_p_oth_real_purch_price IN VARCHAR2 DEFAULT NULL,
2996 x_p_siblings_assets IN VARCHAR2 DEFAULT NULL,
2997 x_p_home_purch_year IN VARCHAR2 DEFAULT NULL,
2998 x_p_oth_real_purch_year IN VARCHAR2 DEFAULT NULL,
2999 x_p_prior_agi IN VARCHAR2 DEFAULT NULL,
3000 x_p_prior_us_tax_paid IN VARCHAR2 DEFAULT NULL,
3001 x_p_prior_item_deductions IN VARCHAR2 DEFAULT NULL,
3002 x_p_prior_other_untax_inc IN VARCHAR2 DEFAULT NULL,
3003 x_p_tax_figures IN VARCHAR2 DEFAULT NULL,
3004 x_p_number_exemptions IN VARCHAR2 DEFAULT NULL,
3005 x_p_adjusted_gross_inc IN VARCHAR2 DEFAULT NULL,
3006 x_p_wages_sal_tips IN VARCHAR2 DEFAULT NULL,
3007 x_p_interest_income IN VARCHAR2 DEFAULT NULL,
3008 x_p_dividend_income IN VARCHAR2 DEFAULT NULL,
3009 x_p_net_inc_bus_farm IN VARCHAR2 DEFAULT NULL,
3010 x_p_other_taxable_income IN VARCHAR2 DEFAULT NULL,
3011 x_p_adj_to_income IN VARCHAR2 DEFAULT NULL,
3012 x_p_us_tax_paid IN VARCHAR2 DEFAULT NULL,
3013 x_p_itemized_deductions IN VARCHAR2 DEFAULT NULL,
3014 x_p_father_income_work IN VARCHAR2 DEFAULT NULL,
3015 x_p_mother_income_work IN VARCHAR2 DEFAULT NULL,
3016 x_p_soc_sec_ben IN VARCHAR2 DEFAULT NULL,
3017 x_p_welfare_tanf IN VARCHAR2 DEFAULT NULL,
3018 x_p_child_supp_rcvd IN VARCHAR2 DEFAULT NULL,
3019 x_p_ded_ira_keogh IN VARCHAR2 DEFAULT NULL,
3020 x_p_tax_defer_pens_savs IN VARCHAR2 DEFAULT NULL,
3021 x_p_dep_care_med_spending IN VARCHAR2 DEFAULT NULL,
3022 x_p_earned_income_credit IN VARCHAR2 DEFAULT NULL,
3023 x_p_living_allow IN VARCHAR2 DEFAULT NULL,
3024 x_p_tax_exmpt_int IN VARCHAR2 DEFAULT NULL,
3025 x_p_foreign_inc_excl IN VARCHAR2 DEFAULT NULL,
3026 x_p_other_untax_inc IN VARCHAR2 DEFAULT NULL,
3027 x_p_hope_ll_credit IN VARCHAR2 DEFAULT NULL,
3028 x_p_yr_separation IN VARCHAR2 DEFAULT NULL,
3029 x_p_yr_divorce IN VARCHAR2 DEFAULT NULL,
3030 x_p_exp_father_inc IN VARCHAR2 DEFAULT NULL,
3031 x_p_exp_mother_inc IN VARCHAR2 DEFAULT NULL,
3032 x_p_exp_other_tax_inc IN VARCHAR2 DEFAULT NULL,
3033 x_p_exp_other_untax_inc IN VARCHAR2 DEFAULT NULL,
3034 x_line_2_relation IN VARCHAR2 DEFAULT NULL,
3035 x_line_2_attend_college IN VARCHAR2 DEFAULT NULL,
3036 x_line_3_relation IN VARCHAR2 DEFAULT NULL,
3037 x_line_3_attend_college IN VARCHAR2 DEFAULT NULL,
3038 x_line_4_relation IN VARCHAR2 DEFAULT NULL,
3039 x_line_4_attend_college IN VARCHAR2 DEFAULT NULL,
3040 x_line_5_relation IN VARCHAR2 DEFAULT NULL,
3041 x_line_5_attend_college IN VARCHAR2 DEFAULT NULL,
3042 x_line_6_relation IN VARCHAR2 DEFAULT NULL,
3046 x_line_8_relation IN VARCHAR2 DEFAULT NULL,
3043 x_line_6_attend_college IN VARCHAR2 DEFAULT NULL,
3044 x_line_7_relation IN VARCHAR2 DEFAULT NULL,
3045 x_line_7_attend_college IN VARCHAR2 DEFAULT NULL,
3047 x_line_8_attend_college IN VARCHAR2 DEFAULT NULL,
3048 x_p_age_father IN VARCHAR2 DEFAULT NULL,
3049 x_p_age_mother IN VARCHAR2 DEFAULT NULL,
3050 x_p_div_sep_ind IN VARCHAR2 DEFAULT NULL,
3051 x_b_cont_non_custodial_par IN VARCHAR2 DEFAULT NULL,
3052 x_college_type_2 IN VARCHAR2 DEFAULT NULL,
3053 x_college_type_3 IN VARCHAR2 DEFAULT NULL,
3054 x_college_type_4 IN VARCHAR2 DEFAULT NULL,
3055 x_college_type_5 IN VARCHAR2 DEFAULT NULL,
3056 x_college_type_6 IN VARCHAR2 DEFAULT NULL,
3057 x_college_type_7 IN VARCHAR2 DEFAULT NULL,
3058 x_college_type_8 IN VARCHAR2 DEFAULT NULL,
3059 x_school_code_1 IN VARCHAR2 DEFAULT NULL,
3060 x_housing_code_1 IN VARCHAR2 DEFAULT NULL,
3061 x_school_code_2 IN VARCHAR2 DEFAULT NULL,
3062 x_housing_code_2 IN VARCHAR2 DEFAULT NULL,
3063 x_school_code_3 IN VARCHAR2 DEFAULT NULL,
3064 x_housing_code_3 IN VARCHAR2 DEFAULT NULL,
3065 x_school_code_4 IN VARCHAR2 DEFAULT NULL,
3066 x_housing_code_4 IN VARCHAR2 DEFAULT NULL,
3067 x_school_code_5 IN VARCHAR2 DEFAULT NULL,
3068 x_housing_code_5 IN VARCHAR2 DEFAULT NULL,
3069 x_school_code_6 IN VARCHAR2 DEFAULT NULL,
3070 x_housing_code_6 IN VARCHAR2 DEFAULT NULL,
3071 x_school_code_7 IN VARCHAR2 DEFAULT NULL,
3072 x_housing_code_7 IN VARCHAR2 DEFAULT NULL,
3073 x_school_code_8 IN VARCHAR2 DEFAULT NULL,
3074 x_housing_code_8 IN VARCHAR2 DEFAULT NULL,
3075 x_school_code_9 IN VARCHAR2 DEFAULT NULL,
3076 x_housing_code_9 IN VARCHAR2 DEFAULT NULL,
3077 x_school_code_10 IN VARCHAR2 DEFAULT NULL,
3078 x_housing_code_10 IN VARCHAR2 DEFAULT NULL,
3079 x_additional_school_code_1 IN VARCHAR2 DEFAULT NULL,
3080 x_additional_school_code_2 IN VARCHAR2 DEFAULT NULL,
3081 x_additional_school_code_3 IN VARCHAR2 DEFAULT NULL,
3082 x_additional_school_code_4 IN VARCHAR2 DEFAULT NULL,
3083 x_additional_school_code_5 IN VARCHAR2 DEFAULT NULL,
3084 x_additional_school_code_6 IN VARCHAR2 DEFAULT NULL,
3085 x_additional_school_code_7 IN VARCHAR2 DEFAULT NULL,
3086 x_additional_school_code_8 IN VARCHAR2 DEFAULT NULL,
3087 x_additional_school_code_9 IN VARCHAR2 DEFAULT NULL,
3088 x_additional_school_code_10 IN VARCHAR2 DEFAULT NULL,
3089 x_explanation_spec_circum IN VARCHAR2 DEFAULT NULL,
3090 x_signature_student IN VARCHAR2 DEFAULT NULL,
3091 x_signature_spouse IN VARCHAR2 DEFAULT NULL,
3092 x_signature_father IN VARCHAR2 DEFAULT NULL,
3093 x_signature_mother IN VARCHAR2 DEFAULT NULL,
3094 x_month_day_completed IN VARCHAR2 DEFAULT NULL,
3095 x_year_completed IN VARCHAR2 DEFAULT NULL,
3096 x_age_line_2 IN VARCHAR2 DEFAULT NULL,
3097 x_age_line_3 IN VARCHAR2 DEFAULT NULL,
3098 x_age_line_4 IN VARCHAR2 DEFAULT NULL,
3099 x_age_line_5 IN VARCHAR2 DEFAULT NULL,
3100 x_age_line_6 IN VARCHAR2 DEFAULT NULL,
3101 x_age_line_7 IN VARCHAR2 DEFAULT NULL,
3102 x_age_line_8 IN VARCHAR2 DEFAULT NULL,
3103 x_a_online_signature IN VARCHAR2 DEFAULT NULL,
3104 x_question_1_number IN VARCHAR2 DEFAULT NULL,
3105 x_question_1_size IN VARCHAR2 DEFAULT NULL,
3106 x_question_1_answer IN VARCHAR2 DEFAULT NULL,
3107 x_question_2_number IN VARCHAR2 DEFAULT NULL,
3108 x_question_2_size IN VARCHAR2 DEFAULT NULL,
3109 x_question_2_answer IN VARCHAR2 DEFAULT NULL,
3110 x_question_3_number IN VARCHAR2 DEFAULT NULL,
3111 x_question_3_size IN VARCHAR2 DEFAULT NULL,
3112 x_question_3_answer IN VARCHAR2 DEFAULT NULL,
3113 x_question_4_number IN VARCHAR2 DEFAULT NULL,
3114 x_question_4_size IN VARCHAR2 DEFAULT NULL,
3115 x_question_4_answer IN VARCHAR2 DEFAULT NULL,
3116 x_question_5_number IN VARCHAR2 DEFAULT NULL,
3117 x_question_5_size IN VARCHAR2 DEFAULT NULL,
3118 x_question_5_answer IN VARCHAR2 DEFAULT NULL,
3119 x_question_6_number IN VARCHAR2 DEFAULT NULL,
3120 x_question_6_size IN VARCHAR2 DEFAULT NULL,
3124 x_question_7_answer IN VARCHAR2 DEFAULT NULL,
3121 x_question_6_answer IN VARCHAR2 DEFAULT NULL,
3122 x_question_7_number IN VARCHAR2 DEFAULT NULL,
3123 x_question_7_size IN VARCHAR2 DEFAULT NULL,
3125 x_question_8_number IN VARCHAR2 DEFAULT NULL,
3126 x_question_8_size IN VARCHAR2 DEFAULT NULL,
3127 x_question_8_answer IN VARCHAR2 DEFAULT NULL,
3128 x_question_9_number IN VARCHAR2 DEFAULT NULL,
3129 x_question_9_size IN VARCHAR2 DEFAULT NULL,
3130 x_question_9_answer IN VARCHAR2 DEFAULT NULL,
3131 x_question_10_number IN VARCHAR2 DEFAULT NULL,
3132 x_question_10_size IN VARCHAR2 DEFAULT NULL,
3133 x_question_10_answer IN VARCHAR2 DEFAULT NULL,
3134 x_question_11_number IN VARCHAR2 DEFAULT NULL,
3135 x_question_11_size IN VARCHAR2 DEFAULT NULL,
3136 x_question_11_answer IN VARCHAR2 DEFAULT NULL,
3137 x_question_12_number IN VARCHAR2 DEFAULT NULL,
3138 x_question_12_size IN VARCHAR2 DEFAULT NULL,
3139 x_question_12_answer IN VARCHAR2 DEFAULT NULL,
3140 x_question_13_number IN VARCHAR2 DEFAULT NULL,
3141 x_question_13_size IN VARCHAR2 DEFAULT NULL,
3142 x_question_13_answer IN VARCHAR2 DEFAULT NULL,
3143 x_question_14_number IN VARCHAR2 DEFAULT NULL,
3144 x_question_14_size IN VARCHAR2 DEFAULT NULL,
3145 x_question_14_answer IN VARCHAR2 DEFAULT NULL,
3146 x_question_15_number IN VARCHAR2 DEFAULT NULL,
3147 x_question_15_size IN VARCHAR2 DEFAULT NULL,
3148 x_question_15_answer IN VARCHAR2 DEFAULT NULL,
3149 x_question_16_number IN VARCHAR2 DEFAULT NULL,
3150 x_question_16_size IN VARCHAR2 DEFAULT NULL,
3151 x_question_16_answer IN VARCHAR2 DEFAULT NULL,
3152 x_question_17_number IN VARCHAR2 DEFAULT NULL,
3153 x_question_17_size IN VARCHAR2 DEFAULT NULL,
3154 x_question_17_answer IN VARCHAR2 DEFAULT NULL,
3155 x_question_18_number IN VARCHAR2 DEFAULT NULL,
3156 x_question_18_size IN VARCHAR2 DEFAULT NULL,
3157 x_question_18_answer IN VARCHAR2 DEFAULT NULL,
3158 x_question_19_number IN VARCHAR2 DEFAULT NULL,
3159 x_question_19_size IN VARCHAR2 DEFAULT NULL,
3160 x_question_19_answer IN VARCHAR2 DEFAULT NULL,
3161 x_question_20_number IN VARCHAR2 DEFAULT NULL,
3162 x_question_20_size IN VARCHAR2 DEFAULT NULL,
3163 x_question_20_answer IN VARCHAR2 DEFAULT NULL,
3164 x_question_21_number IN VARCHAR2 DEFAULT NULL,
3165 x_question_21_size IN VARCHAR2 DEFAULT NULL,
3166 x_question_21_answer IN VARCHAR2 DEFAULT NULL,
3167 x_question_22_number IN VARCHAR2 DEFAULT NULL,
3168 x_question_22_size IN VARCHAR2 DEFAULT NULL,
3169 x_question_22_answer IN VARCHAR2 DEFAULT NULL,
3170 x_question_23_number IN VARCHAR2 DEFAULT NULL,
3171 x_question_23_size IN VARCHAR2 DEFAULT NULL,
3172 x_question_23_answer IN VARCHAR2 DEFAULT NULL,
3173 x_question_24_number IN VARCHAR2 DEFAULT NULL,
3174 x_question_24_size IN VARCHAR2 DEFAULT NULL,
3175 x_question_24_answer IN VARCHAR2 DEFAULT NULL,
3176 x_question_25_number IN VARCHAR2 DEFAULT NULL,
3177 x_question_25_size IN VARCHAR2 DEFAULT NULL,
3178 x_question_25_answer IN VARCHAR2 DEFAULT NULL,
3179 x_question_26_number IN VARCHAR2 DEFAULT NULL,
3180 x_question_26_size IN VARCHAR2 DEFAULT NULL,
3181 x_question_26_answer IN VARCHAR2 DEFAULT NULL,
3182 x_question_27_number IN VARCHAR2 DEFAULT NULL,
3183 x_question_27_size IN VARCHAR2 DEFAULT NULL,
3184 x_question_27_answer IN VARCHAR2 DEFAULT NULL,
3185 x_question_28_number IN VARCHAR2 DEFAULT NULL,
3186 x_question_28_size IN VARCHAR2 DEFAULT NULL,
3187 x_question_28_answer IN VARCHAR2 DEFAULT NULL,
3188 x_question_29_number IN VARCHAR2 DEFAULT NULL,
3189 x_question_29_size IN VARCHAR2 DEFAULT NULL,
3190 x_question_29_answer IN VARCHAR2 DEFAULT NULL,
3191 x_question_30_number IN VARCHAR2 DEFAULT NULL,
3192 x_questions_30_size IN VARCHAR2 DEFAULT NULL,
3193 x_question_30_answer IN VARCHAR2 DEFAULT NULL,
3194 x_r_s_email_address IN VARCHAR2 DEFAULT NULL,
3195 x_eps_code IN VARCHAR2 DEFAULT NULL,
3196 x_comp_css_dependency_status IN VARCHAR2 DEFAULT NULL,
3197 x_stu_age IN VARCHAR2 DEFAULT NULL,
3198 x_assumed_stu_yr_in_coll IN VARCHAR2 DEFAULT NULL,
3202 x_par_marital_status IN VARCHAR2 DEFAULT NULL,
3199 x_comp_stu_marital_status IN VARCHAR2 DEFAULT NULL,
3200 x_stu_family_members IN VARCHAR2 DEFAULT NULL,
3201 x_stu_fam_members_in_college IN VARCHAR2 DEFAULT NULL,
3203 x_par_family_members IN VARCHAR2 DEFAULT NULL,
3204 x_par_total_in_college IN VARCHAR2 DEFAULT NULL,
3205 x_par_par_in_college IN VARCHAR2 DEFAULT NULL,
3206 x_par_others_in_college IN VARCHAR2 DEFAULT NULL,
3207 x_par_aesa IN VARCHAR2 DEFAULT NULL,
3208 x_par_cesa IN VARCHAR2 DEFAULT NULL,
3209 x_stu_aesa IN VARCHAR2 DEFAULT NULL,
3210 x_stu_cesa IN VARCHAR2 DEFAULT NULL,
3211 x_im_p_bas_agi_taxable_income IN VARCHAR2 DEFAULT NULL,
3212 x_im_p_bas_untx_inc_and_ben IN VARCHAR2 DEFAULT NULL,
3213 x_im_p_bas_inc_adj IN VARCHAR2 DEFAULT NULL,
3214 x_im_p_bas_total_income IN VARCHAR2 DEFAULT NULL,
3215 x_im_p_bas_us_income_tax IN VARCHAR2 DEFAULT NULL,
3216 x_im_p_bas_st_and_other_tax IN VARCHAR2 DEFAULT NULL,
3217 x_im_p_bas_fica_tax IN VARCHAR2 DEFAULT NULL,
3218 x_im_p_bas_med_dental IN VARCHAR2 DEFAULT NULL,
3219 x_im_p_bas_employment_allow IN VARCHAR2 DEFAULT NULL,
3220 x_im_p_bas_annual_ed_savings IN VARCHAR2 DEFAULT NULL,
3221 x_im_p_bas_inc_prot_allow_m IN VARCHAR2 DEFAULT NULL,
3222 x_im_p_bas_total_inc_allow IN VARCHAR2 DEFAULT NULL,
3223 x_im_p_bas_cal_avail_inc IN VARCHAR2 DEFAULT NULL,
3224 x_im_p_bas_avail_income IN VARCHAR2 DEFAULT NULL,
3225 x_im_p_bas_total_cont_inc IN VARCHAR2 DEFAULT NULL,
3226 x_im_p_bas_cash_bank_accounts IN VARCHAR2 DEFAULT NULL,
3227 x_im_p_bas_home_equity IN VARCHAR2 DEFAULT NULL,
3228 x_im_p_bas_ot_rl_est_inv_eq IN VARCHAR2 DEFAULT NULL,
3229 x_im_p_bas_adj_bus_farm_worth IN VARCHAR2 DEFAULT NULL,
3230 x_im_p_bas_ass_sibs_pre_tui IN VARCHAR2 DEFAULT NULL,
3231 x_im_p_bas_net_worth IN VARCHAR2 DEFAULT NULL,
3232 x_im_p_bas_emerg_res_allow IN VARCHAR2 DEFAULT NULL,
3233 x_im_p_bas_cum_ed_savings IN VARCHAR2 DEFAULT NULL,
3234 x_im_p_bas_low_inc_allow IN VARCHAR2 DEFAULT NULL,
3235 x_im_p_bas_total_asset_allow IN VARCHAR2 DEFAULT NULL,
3236 x_im_p_bas_disc_net_worth IN VARCHAR2 DEFAULT NULL,
3237 x_im_p_bas_total_cont_asset IN VARCHAR2 DEFAULT NULL,
3238 x_im_p_bas_total_cont IN VARCHAR2 DEFAULT NULL,
3239 x_im_p_bas_num_in_coll_adj IN VARCHAR2 DEFAULT NULL,
3240 x_im_p_bas_cont_for_stu IN VARCHAR2 DEFAULT NULL,
3241 x_im_p_bas_cont_from_income IN VARCHAR2 DEFAULT NULL,
3242 x_im_p_bas_cont_from_assets IN VARCHAR2 DEFAULT NULL,
3243 x_im_p_opt_agi_taxable_income IN VARCHAR2 DEFAULT NULL,
3244 x_im_p_opt_untx_inc_and_ben IN VARCHAR2 DEFAULT NULL,
3245 x_im_p_opt_inc_adj IN VARCHAR2 DEFAULT NULL,
3246 x_im_p_opt_total_income IN VARCHAR2 DEFAULT NULL,
3247 x_im_p_opt_us_income_tax IN VARCHAR2 DEFAULT NULL,
3248 x_im_p_opt_st_and_other_tax IN VARCHAR2 DEFAULT NULL,
3249 x_im_p_opt_fica_tax IN VARCHAR2 DEFAULT NULL,
3250 x_im_p_opt_med_dental IN VARCHAR2 DEFAULT NULL,
3251 x_im_p_opt_elem_sec_tuit IN VARCHAR2 DEFAULT NULL,
3252 x_im_p_opt_employment_allow IN VARCHAR2 DEFAULT NULL,
3253 x_im_p_opt_annual_ed_savings IN VARCHAR2 DEFAULT NULL,
3254 x_im_p_opt_inc_prot_allow_m IN VARCHAR2 DEFAULT NULL,
3255 x_im_p_opt_total_inc_allow IN VARCHAR2 DEFAULT NULL,
3256 x_im_p_opt_cal_avail_inc IN VARCHAR2 DEFAULT NULL,
3257 x_im_p_opt_avail_income IN VARCHAR2 DEFAULT NULL,
3258 x_im_p_opt_total_cont_inc IN VARCHAR2 DEFAULT NULL,
3259 x_im_p_opt_cash_bank_accounts IN VARCHAR2 DEFAULT NULL,
3260 x_im_p_opt_home_equity IN VARCHAR2 DEFAULT NULL,
3261 x_im_p_opt_ot_rl_est_inv_eq IN VARCHAR2 DEFAULT NULL,
3262 x_im_p_opt_adj_bus_farm_worth IN VARCHAR2 DEFAULT NULL,
3263 x_im_p_opt_ass_sibs_pre_t IN VARCHAR2 DEFAULT NULL,
3264 x_im_p_opt_net_worth IN VARCHAR2 DEFAULT NULL,
3265 x_im_p_opt_emerg_res_allow IN VARCHAR2 DEFAULT NULL,
3266 x_im_p_opt_cum_ed_savings IN VARCHAR2 DEFAULT NULL,
3267 x_im_p_opt_low_inc_allow IN VARCHAR2 DEFAULT NULL,
3268 x_im_p_opt_total_asset_allow IN VARCHAR2 DEFAULT NULL,
3269 x_im_p_opt_disc_net_worth IN VARCHAR2 DEFAULT NULL,
3270 x_im_p_opt_total_cont_asset IN VARCHAR2 DEFAULT NULL,
3271 x_im_p_opt_total_cont IN VARCHAR2 DEFAULT NULL,
3272 x_im_p_opt_num_in_coll_adj IN VARCHAR2 DEFAULT NULL,
3273 x_im_p_opt_cont_for_stu IN VARCHAR2 DEFAULT NULL,
3274 x_im_p_opt_cont_from_income IN VARCHAR2 DEFAULT NULL,
3275 x_im_p_opt_cont_from_assets IN VARCHAR2 DEFAULT NULL,
3276 x_fm_p_analysis_type IN VARCHAR2 DEFAULT NULL,
3280 x_fm_p_total_income IN VARCHAR2 DEFAULT NULL,
3277 x_fm_p_agi_taxable_income IN VARCHAR2 DEFAULT NULL,
3278 x_fm_p_untx_inc_and_ben IN VARCHAR2 DEFAULT NULL,
3279 x_fm_p_inc_adj IN VARCHAR2 DEFAULT NULL,
3281 x_fm_p_us_income_tax IN VARCHAR2 DEFAULT NULL,
3282 x_fm_p_state_and_other_taxes IN VARCHAR2 DEFAULT NULL,
3283 x_fm_p_fica_tax IN VARCHAR2 DEFAULT NULL,
3284 x_fm_p_employment_allow IN VARCHAR2 DEFAULT NULL,
3285 x_fm_p_income_prot_allow IN VARCHAR2 DEFAULT NULL,
3286 x_fm_p_total_allow IN VARCHAR2 DEFAULT NULL,
3287 x_fm_p_avail_income IN VARCHAR2 DEFAULT NULL,
3288 x_fm_p_cash_bank_accounts IN VARCHAR2 DEFAULT NULL,
3289 x_fm_p_ot_rl_est_inv_eq IN VARCHAR2 DEFAULT NULL,
3290 x_fm_p_adj_bus_farm_net_worth IN VARCHAR2 DEFAULT NULL,
3291 x_fm_p_net_worth IN VARCHAR2 DEFAULT NULL,
3292 x_fm_p_asset_prot_allow IN VARCHAR2 DEFAULT NULL,
3293 x_fm_p_disc_net_worth IN VARCHAR2 DEFAULT NULL,
3294 x_fm_p_total_contribution IN VARCHAR2 DEFAULT NULL,
3295 x_fm_p_num_in_coll IN VARCHAR2 DEFAULT NULL,
3296 x_fm_p_cont_for_stu IN VARCHAR2 DEFAULT NULL,
3297 x_fm_p_cont_from_income IN VARCHAR2 DEFAULT NULL,
3298 x_fm_p_cont_from_assets IN VARCHAR2 DEFAULT NULL,
3299 x_im_s_bas_agi_taxable_income IN VARCHAR2 DEFAULT NULL,
3300 x_im_s_bas_untx_inc_and_ben IN VARCHAR2 DEFAULT NULL,
3301 x_im_s_bas_inc_adj IN VARCHAR2 DEFAULT NULL,
3302 x_im_s_bas_total_income IN VARCHAR2 DEFAULT NULL,
3303 x_im_s_bas_us_income_tax IN VARCHAR2 DEFAULT NULL,
3304 x_im_s_bas_st_and_oth_tax IN VARCHAR2 DEFAULT NULL,
3305 x_im_s_bas_fica_tax IN VARCHAR2 DEFAULT NULL,
3306 x_im_s_bas_med_dental IN VARCHAR2 DEFAULT NULL,
3307 x_im_s_bas_employment_allow IN VARCHAR2 DEFAULT NULL,
3308 x_im_s_bas_annual_ed_savings IN VARCHAR2 DEFAULT NULL,
3309 x_im_s_bas_inc_prot_allow_m IN VARCHAR2 DEFAULT NULL,
3310 x_im_s_bas_total_inc_allow IN VARCHAR2 DEFAULT NULL,
3311 x_im_s_bas_cal_avail_income IN VARCHAR2 DEFAULT NULL,
3312 x_im_s_bas_avail_income IN VARCHAR2 DEFAULT NULL,
3313 x_im_s_bas_total_cont_inc IN VARCHAR2 DEFAULT NULL,
3314 x_im_s_bas_cash_bank_accounts IN VARCHAR2 DEFAULT NULL,
3315 x_im_s_bas_home_equity IN VARCHAR2 DEFAULT NULL,
3316 x_im_s_bas_ot_rl_est_inv_eq IN VARCHAR2 DEFAULT NULL,
3317 x_im_s_bas_adj_bus_farm_worth IN VARCHAR2 DEFAULT NULL,
3318 x_im_s_bas_trusts IN VARCHAR2 DEFAULT NULL,
3319 x_im_s_bas_net_worth IN VARCHAR2 DEFAULT NULL,
3320 x_im_s_bas_emerg_res_allow IN VARCHAR2 DEFAULT NULL,
3321 x_im_s_bas_cum_ed_savings IN VARCHAR2 DEFAULT NULL,
3322 x_im_s_bas_total_asset_allow IN VARCHAR2 DEFAULT NULL,
3323 x_im_s_bas_disc_net_worth IN VARCHAR2 DEFAULT NULL,
3324 x_im_s_bas_total_cont_asset IN VARCHAR2 DEFAULT NULL,
3325 x_im_s_bas_total_cont IN VARCHAR2 DEFAULT NULL,
3326 x_im_s_bas_num_in_coll_adj IN VARCHAR2 DEFAULT NULL,
3327 x_im_s_bas_cont_for_stu IN VARCHAR2 DEFAULT NULL,
3328 x_im_s_bas_cont_from_income IN VARCHAR2 DEFAULT NULL,
3329 x_im_s_bas_cont_from_assets IN VARCHAR2 DEFAULT NULL,
3330 x_im_s_est_agi_taxable_income IN VARCHAR2 DEFAULT NULL,
3331 x_im_s_est_untx_inc_and_ben IN VARCHAR2 DEFAULT NULL,
3332 x_im_s_est_inc_adj IN VARCHAR2 DEFAULT NULL,
3333 x_im_s_est_total_income IN VARCHAR2 DEFAULT NULL,
3334 x_im_s_est_us_income_tax IN VARCHAR2 DEFAULT NULL,
3335 x_im_s_est_st_and_oth_tax IN VARCHAR2 DEFAULT NULL,
3336 x_im_s_est_fica_tax IN VARCHAR2 DEFAULT NULL,
3337 x_im_s_est_med_dental IN VARCHAR2 DEFAULT NULL,
3338 x_im_s_est_employment_allow IN VARCHAR2 DEFAULT NULL,
3339 x_im_s_est_annual_ed_savings IN VARCHAR2 DEFAULT NULL,
3340 x_im_s_est_inc_prot_allow_m IN VARCHAR2 DEFAULT NULL,
3341 x_im_s_est_total_inc_allow IN VARCHAR2 DEFAULT NULL,
3342 x_im_s_est_cal_avail_income IN VARCHAR2 DEFAULT NULL,
3343 x_im_s_est_avail_income IN VARCHAR2 DEFAULT NULL,
3344 x_im_s_est_total_cont_inc IN VARCHAR2 DEFAULT NULL,
3345 x_im_s_est_cash_bank_accounts IN VARCHAR2 DEFAULT NULL,
3346 x_im_s_est_home_equity IN VARCHAR2 DEFAULT NULL,
3347 x_im_s_est_ot_rl_est_inv_equ IN VARCHAR2 DEFAULT NULL,
3348 x_im_s_est_adj_bus_farm_worth IN VARCHAR2 DEFAULT NULL,
3349 x_im_s_est_est_trusts IN VARCHAR2 DEFAULT NULL,
3350 x_im_s_est_net_worth IN VARCHAR2 DEFAULT NULL,
3351 x_im_s_est_emerg_res_allow IN VARCHAR2 DEFAULT NULL,
3352 x_im_s_est_cum_ed_savings IN VARCHAR2 DEFAULT NULL,
3353 x_im_s_est_total_asset_allow IN VARCHAR2 DEFAULT NULL,
3354 x_im_s_est_disc_net_worth IN VARCHAR2 DEFAULT NULL,
3358 x_im_s_est_cont_for_stu IN VARCHAR2 DEFAULT NULL,
3355 x_im_s_est_total_cont_asset IN VARCHAR2 DEFAULT NULL,
3356 x_im_s_est_total_cont IN VARCHAR2 DEFAULT NULL,
3357 x_im_s_est_num_in_coll_adj IN VARCHAR2 DEFAULT NULL,
3359 x_im_s_est_cont_from_income IN VARCHAR2 DEFAULT NULL,
3360 x_im_s_est_cont_from_assets IN VARCHAR2 DEFAULT NULL,
3361 x_im_s_opt_agi_taxable_income IN VARCHAR2 DEFAULT NULL,
3362 x_im_s_opt_untx_inc_and_ben IN VARCHAR2 DEFAULT NULL,
3363 x_im_s_opt_inc_adj IN VARCHAR2 DEFAULT NULL,
3364 x_im_s_opt_total_income IN VARCHAR2 DEFAULT NULL,
3365 x_im_s_opt_us_income_tax IN VARCHAR2 DEFAULT NULL,
3366 x_im_s_opt_state_and_oth_taxes IN VARCHAR2 DEFAULT NULL,
3367 x_im_s_opt_fica_tax IN VARCHAR2 DEFAULT NULL,
3368 x_im_s_opt_med_dental IN VARCHAR2 DEFAULT NULL,
3369 x_im_s_opt_employment_allow IN VARCHAR2 DEFAULT NULL,
3370 x_im_s_opt_annual_ed_savings IN VARCHAR2 DEFAULT NULL,
3371 x_im_s_opt_inc_prot_allow_m IN VARCHAR2 DEFAULT NULL,
3372 x_im_s_opt_total_inc_allow IN VARCHAR2 DEFAULT NULL,
3373 x_im_s_opt_cal_avail_income IN VARCHAR2 DEFAULT NULL,
3374 x_im_s_opt_avail_income IN VARCHAR2 DEFAULT NULL,
3375 x_im_s_opt_total_cont_inc IN VARCHAR2 DEFAULT NULL,
3376 x_im_s_opt_cash_bank_accounts IN VARCHAR2 DEFAULT NULL,
3377 x_im_s_opt_ira_keogh_accounts IN VARCHAR2 DEFAULT NULL,
3378 x_im_s_opt_home_equity IN VARCHAR2 DEFAULT NULL,
3379 x_im_s_opt_ot_rl_est_inv_eq IN VARCHAR2 DEFAULT NULL,
3380 x_im_s_opt_adj_bus_farm_worth IN VARCHAR2 DEFAULT NULL,
3381 x_im_s_opt_trusts IN VARCHAR2 DEFAULT NULL,
3382 x_im_s_opt_net_worth IN VARCHAR2 DEFAULT NULL,
3383 x_im_s_opt_emerg_res_allow IN VARCHAR2 DEFAULT NULL,
3384 x_im_s_opt_cum_ed_savings IN VARCHAR2 DEFAULT NULL,
3385 x_im_s_opt_total_asset_allow IN VARCHAR2 DEFAULT NULL,
3386 x_im_s_opt_disc_net_worth IN VARCHAR2 DEFAULT NULL,
3387 x_im_s_opt_total_cont_asset IN VARCHAR2 DEFAULT NULL,
3388 x_im_s_opt_total_cont IN VARCHAR2 DEFAULT NULL,
3389 x_im_s_opt_num_in_coll_adj IN VARCHAR2 DEFAULT NULL,
3390 x_im_s_opt_cont_for_stu IN VARCHAR2 DEFAULT NULL,
3391 x_im_s_opt_cont_from_income IN VARCHAR2 DEFAULT NULL,
3392 x_im_s_opt_cont_from_assets IN VARCHAR2 DEFAULT NULL,
3393 x_fm_s_analysis_type IN VARCHAR2 DEFAULT NULL,
3394 x_fm_s_agi_taxable_income IN VARCHAR2 DEFAULT NULL,
3395 x_fm_s_untx_inc_and_ben IN VARCHAR2 DEFAULT NULL,
3396 x_fm_s_inc_adj IN VARCHAR2 DEFAULT NULL,
3397 x_fm_s_total_income IN VARCHAR2 DEFAULT NULL,
3398 x_fm_s_us_income_tax IN VARCHAR2 DEFAULT NULL,
3399 x_fm_s_state_and_oth_taxes IN VARCHAR2 DEFAULT NULL,
3400 x_fm_s_fica_tax IN VARCHAR2 DEFAULT NULL,
3401 x_fm_s_employment_allow IN VARCHAR2 DEFAULT NULL,
3402 x_fm_s_income_prot_allow IN VARCHAR2 DEFAULT NULL,
3403 x_fm_s_total_allow IN VARCHAR2 DEFAULT NULL,
3404 x_fm_s_cal_avail_income IN VARCHAR2 DEFAULT NULL,
3405 x_fm_s_avail_income IN VARCHAR2 DEFAULT NULL,
3406 x_fm_s_cash_bank_accounts IN VARCHAR2 DEFAULT NULL,
3407 x_fm_s_ot_rl_est_inv_equity IN VARCHAR2 DEFAULT NULL,
3408 x_fm_s_adj_bus_farm_worth IN VARCHAR2 DEFAULT NULL,
3409 x_fm_s_trusts IN VARCHAR2 DEFAULT NULL,
3410 x_fm_s_net_worth IN VARCHAR2 DEFAULT NULL,
3411 x_fm_s_asset_prot_allow IN VARCHAR2 DEFAULT NULL,
3412 x_fm_s_disc_net_worth IN VARCHAR2 DEFAULT NULL,
3413 x_fm_s_total_cont IN VARCHAR2 DEFAULT NULL,
3414 x_fm_s_num_in_coll IN VARCHAR2 DEFAULT NULL,
3415 x_fm_s_cont_for_stu IN VARCHAR2 DEFAULT NULL,
3416 x_fm_s_cont_from_income IN VARCHAR2 DEFAULT NULL,
3417 x_fm_s_cont_from_assets IN VARCHAR2 DEFAULT NULL,
3418 x_im_inst_resident_ind IN VARCHAR2 DEFAULT NULL,
3419 x_institutional_1_budget_name IN VARCHAR2 DEFAULT NULL,
3420 x_im_inst_1_budget_duration IN VARCHAR2 DEFAULT NULL,
3421 x_im_inst_1_tuition_fees IN VARCHAR2 DEFAULT NULL,
3422 x_im_inst_1_books_supplies IN VARCHAR2 DEFAULT NULL,
3423 x_im_inst_1_living_expenses IN VARCHAR2 DEFAULT NULL,
3424 x_im_inst_1_tot_expenses IN VARCHAR2 DEFAULT NULL,
3425 x_im_inst_1_tot_stu_cont IN VARCHAR2 DEFAULT NULL,
3426 x_im_inst_1_tot_par_cont IN VARCHAR2 DEFAULT NULL,
3427 x_im_inst_1_tot_family_cont IN VARCHAR2 DEFAULT NULL,
3428 x_im_inst_1_va_benefits IN VARCHAR2 DEFAULT NULL,
3429 x_im_inst_1_ot_cont IN VARCHAR2 DEFAULT NULL,
3430 x_im_inst_1_est_financial_need IN VARCHAR2 DEFAULT NULL,
3431 x_institutional_2_budget_name IN VARCHAR2 DEFAULT NULL,
3432 x_im_inst_2_budget_duration IN VARCHAR2 DEFAULT NULL,
3436 x_im_inst_2_tot_expenses IN VARCHAR2 DEFAULT NULL,
3433 x_im_inst_2_tuition_fees IN VARCHAR2 DEFAULT NULL,
3434 x_im_inst_2_books_supplies IN VARCHAR2 DEFAULT NULL,
3435 x_im_inst_2_living_expenses IN VARCHAR2 DEFAULT NULL,
3437 x_im_inst_2_tot_stu_cont IN VARCHAR2 DEFAULT NULL,
3438 x_im_inst_2_tot_par_cont IN VARCHAR2 DEFAULT NULL,
3439 x_im_inst_2_tot_family_cont IN VARCHAR2 DEFAULT NULL,
3440 x_im_inst_2_va_benefits IN VARCHAR2 DEFAULT NULL,
3441 x_im_inst_2_est_financial_need IN VARCHAR2 DEFAULT NULL,
3442 x_institutional_3_budget_name IN VARCHAR2 DEFAULT NULL,
3443 x_im_inst_3_budget_duration IN VARCHAR2 DEFAULT NULL,
3444 x_im_inst_3_tuition_fees IN VARCHAR2 DEFAULT NULL,
3445 x_im_inst_3_books_supplies IN VARCHAR2 DEFAULT NULL,
3446 x_im_inst_3_living_expenses IN VARCHAR2 DEFAULT NULL,
3447 x_im_inst_3_tot_expenses IN VARCHAR2 DEFAULT NULL,
3448 x_im_inst_3_tot_stu_cont IN VARCHAR2 DEFAULT NULL,
3449 x_im_inst_3_tot_par_cont IN VARCHAR2 DEFAULT NULL,
3450 x_im_inst_3_tot_family_cont IN VARCHAR2 DEFAULT NULL,
3451 x_im_inst_3_va_benefits IN VARCHAR2 DEFAULT NULL,
3452 x_im_inst_3_est_financial_need IN VARCHAR2 DEFAULT NULL,
3453 x_fm_inst_1_federal_efc IN VARCHAR2 DEFAULT NULL,
3454 x_fm_inst_1_va_benefits IN VARCHAR2 DEFAULT NULL,
3455 x_fm_inst_1_fed_eligibility IN VARCHAR2 DEFAULT NULL,
3456 x_fm_inst_1_pell IN VARCHAR2 DEFAULT NULL,
3457 x_option_par_loss_allow_ind IN VARCHAR2 DEFAULT NULL,
3458 x_option_par_tuition_ind IN VARCHAR2 DEFAULT NULL,
3459 x_option_par_home_ind IN VARCHAR2 DEFAULT NULL,
3460 x_option_par_home_value IN VARCHAR2 DEFAULT NULL,
3461 x_option_par_home_debt IN VARCHAR2 DEFAULT NULL,
3462 x_option_stu_ira_keogh_ind IN VARCHAR2 DEFAULT NULL,
3463 x_option_stu_home_ind IN VARCHAR2 DEFAULT NULL,
3464 x_option_stu_home_value IN VARCHAR2 DEFAULT NULL,
3465 x_option_stu_home_debt IN VARCHAR2 DEFAULT NULL,
3466 x_option_stu_sum_ay_inc_ind IN VARCHAR2 DEFAULT NULL,
3467 x_option_par_hope_ll_credit IN VARCHAR2 DEFAULT NULL,
3468 x_option_stu_hope_ll_credit IN VARCHAR2 DEFAULT NULL,
3469 x_im_parent_1_8_months_bas IN VARCHAR2 DEFAULT NULL,
3470 x_im_p_more_than_9_mth_ba IN VARCHAR2 DEFAULT NULL,
3471 x_im_parent_1_8_months_opt IN VARCHAR2 DEFAULT NULL,
3472 x_im_p_more_than_9_mth_op IN VARCHAR2 DEFAULT NULL,
3473 x_fnar_message_1 IN VARCHAR2 DEFAULT NULL,
3474 x_fnar_message_2 IN VARCHAR2 DEFAULT NULL,
3475 x_fnar_message_3 IN VARCHAR2 DEFAULT NULL,
3476 x_fnar_message_4 IN VARCHAR2 DEFAULT NULL,
3477 x_fnar_message_5 IN VARCHAR2 DEFAULT NULL,
3478 x_fnar_message_6 IN VARCHAR2 DEFAULT NULL,
3479 x_fnar_message_7 IN VARCHAR2 DEFAULT NULL,
3480 x_fnar_message_8 IN VARCHAR2 DEFAULT NULL,
3481 x_fnar_message_9 IN VARCHAR2 DEFAULT NULL,
3482 x_fnar_message_10 IN VARCHAR2 DEFAULT NULL,
3483 x_fnar_message_11 IN VARCHAR2 DEFAULT NULL,
3484 x_fnar_message_12 IN VARCHAR2 DEFAULT NULL,
3485 x_fnar_message_13 IN VARCHAR2 DEFAULT NULL,
3486 x_fnar_message_20 IN VARCHAR2 DEFAULT NULL,
3487 x_fnar_message_21 IN VARCHAR2 DEFAULT NULL,
3488 x_fnar_message_22 IN VARCHAR2 DEFAULT NULL,
3489 x_fnar_message_23 IN VARCHAR2 DEFAULT NULL,
3490 x_fnar_message_24 IN VARCHAR2 DEFAULT NULL,
3491 x_fnar_message_25 IN VARCHAR2 DEFAULT NULL,
3492 x_fnar_message_26 IN VARCHAR2 DEFAULT NULL,
3493 x_fnar_message_27 IN VARCHAR2 DEFAULT NULL,
3494 x_fnar_message_30 IN VARCHAR2 DEFAULT NULL,
3495 x_fnar_message_31 IN VARCHAR2 DEFAULT NULL,
3496 x_fnar_message_32 IN VARCHAR2 DEFAULT NULL,
3497 x_fnar_message_33 IN VARCHAR2 DEFAULT NULL,
3498 x_fnar_message_34 IN VARCHAR2 DEFAULT NULL,
3499 x_fnar_message_35 IN VARCHAR2 DEFAULT NULL,
3500 x_fnar_message_36 IN VARCHAR2 DEFAULT NULL,
3501 x_fnar_message_37 IN VARCHAR2 DEFAULT NULL,
3502 x_fnar_message_38 IN VARCHAR2 DEFAULT NULL,
3503 x_fnar_message_39 IN VARCHAR2 DEFAULT NULL,
3504 x_fnar_message_45 IN VARCHAR2 DEFAULT NULL,
3505 x_fnar_message_46 IN VARCHAR2 DEFAULT NULL,
3506 x_fnar_message_47 IN VARCHAR2 DEFAULT NULL,
3507 x_fnar_message_48 IN VARCHAR2 DEFAULT NULL,
3508 x_fnar_message_50 IN VARCHAR2 DEFAULT NULL,
3509 x_fnar_message_51 IN VARCHAR2 DEFAULT NULL,
3510 x_fnar_message_52 IN VARCHAR2 DEFAULT NULL,
3511 x_fnar_message_53 IN VARCHAR2 DEFAULT NULL,
3512 x_fnar_message_56 IN VARCHAR2 DEFAULT NULL,
3513 x_fnar_message_57 IN VARCHAR2 DEFAULT NULL,
3514 x_fnar_message_58 IN VARCHAR2 DEFAULT NULL,
3515 x_fnar_message_59 IN VARCHAR2 DEFAULT NULL,
3516 x_fnar_message_60 IN VARCHAR2 DEFAULT NULL,
3517 x_fnar_message_61 IN VARCHAR2 DEFAULT NULL,
3518 x_fnar_message_62 IN VARCHAR2 DEFAULT NULL,
3519 x_fnar_message_63 IN VARCHAR2 DEFAULT NULL,
3520 x_fnar_message_64 IN VARCHAR2 DEFAULT NULL,
3521 x_fnar_message_65 IN VARCHAR2 DEFAULT NULL,
3522 x_fnar_message_71 IN VARCHAR2 DEFAULT NULL,
3523 x_fnar_message_72 IN VARCHAR2 DEFAULT NULL,
3524 x_fnar_message_73 IN VARCHAR2 DEFAULT NULL,
3525 x_fnar_message_74 IN VARCHAR2 DEFAULT NULL,
3526 x_fnar_message_75 IN VARCHAR2 DEFAULT NULL,
3527 x_fnar_message_76 IN VARCHAR2 DEFAULT NULL,
3528 x_fnar_message_77 IN VARCHAR2 DEFAULT NULL,
3529 x_fnar_message_78 IN VARCHAR2 DEFAULT NULL,
3530 x_fnar_mesg_10_stu_fam_mem IN VARCHAR2 DEFAULT NULL,
3531 x_fnar_mesg_11_stu_no_in_coll IN VARCHAR2 DEFAULT NULL,
3532 x_fnar_mesg_24_stu_avail_inc IN VARCHAR2 DEFAULT NULL,
3533 x_fnar_mesg_26_stu_taxes IN VARCHAR2 DEFAULT NULL,
3534 x_fnar_mesg_33_stu_home_value IN VARCHAR2 DEFAULT NULL,
3535 x_fnar_mesg_34_stu_home_value IN VARCHAR2 DEFAULT NULL,
3536 x_fnar_mesg_34_stu_home_equity IN VARCHAR2 DEFAULT NULL,
3537 x_fnar_mesg_35_stu_home_value IN VARCHAR2 DEFAULT NULL,
3538 x_fnar_mesg_35_stu_home_equity IN VARCHAR2 DEFAULT NULL,
3539 x_fnar_mesg_36_stu_home_equity IN VARCHAR2 DEFAULT NULL,
3540 x_fnar_mesg_48_par_fam_mem IN VARCHAR2 DEFAULT NULL,
3541 x_fnar_mesg_49_par_no_in_coll IN VARCHAR2 DEFAULT NULL,
3542 x_fnar_mesg_56_par_agi IN VARCHAR2 DEFAULT NULL,
3543 x_fnar_mesg_62_par_taxes IN VARCHAR2 DEFAULT NULL,
3544 x_fnar_mesg_73_par_home_value IN VARCHAR2 DEFAULT NULL,
3545 x_fnar_mesg_74_par_home_value IN VARCHAR2 DEFAULT NULL,
3546 x_fnar_mesg_74_par_home_equity IN VARCHAR2 DEFAULT NULL,
3547 x_fnar_mesg_75_par_home_value IN VARCHAR2 DEFAULT NULL,
3548 x_fnar_mesg_75_par_home_equity IN VARCHAR2 DEFAULT NULL,
3549 x_fnar_mesg_76_par_home_equity IN VARCHAR2 DEFAULT NULL,
3550 x_assumption_message_1 IN VARCHAR2 DEFAULT NULL,
3551 x_assumption_message_2 IN VARCHAR2 DEFAULT NULL,
3552 x_assumption_message_3 IN VARCHAR2 DEFAULT NULL,
3553 x_assumption_message_4 IN VARCHAR2 DEFAULT NULL,
3554 x_assumption_message_5 IN VARCHAR2 DEFAULT NULL,
3555 x_assumption_message_6 IN VARCHAR2 DEFAULT NULL,
3556 x_record_mark IN VARCHAR2 DEFAULT NULL,
3557 x_creation_date IN DATE DEFAULT NULL,
3558 x_created_by IN NUMBER DEFAULT NULL,
3559 x_last_update_date IN DATE DEFAULT NULL,
3560 x_last_updated_by IN NUMBER DEFAULT NULL,
3561 x_last_update_login IN NUMBER DEFAULT NULL,
3562 x_option_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
3563 x_option_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
3564 x_option_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
3565 x_option_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
3566 x_option_par_cola_adj_value IN VARCHAR2 DEFAULT NULL,
3567 x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
3568 x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
3569 x_p_soc_sec_ben_student_amt IN NUMBER DEFAULT NULL,
3570 x_p_tuit_fee_deduct_amt IN NUMBER DEFAULT NULL,
3571 x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
3572 x_stu_lives_with_num IN NUMBER DEFAULT NULL,
3573 x_stu_most_support_from_num IN NUMBER DEFAULT NULL,
3574 x_location_computer_num IN NUMBER DEFAULT NULL,
3575 x_cust_parent_cont_adj_num IN NUMBER DEFAULT NULL,
3576 x_custodial_parent_num IN NUMBER DEFAULT NULL,
3577 x_cust_par_base_prcnt_inc_amt IN NUMBER DEFAULT NULL,
3578 x_cust_par_base_cont_inc_amt IN NUMBER DEFAULT NULL,
3579 x_cust_par_base_cont_ast_amt IN NUMBER DEFAULT NULL,
3580 x_cust_par_base_tot_cont_amt IN NUMBER DEFAULT NULL,
3581 x_cust_par_opt_prcnt_inc_amt IN NUMBER DEFAULT NULL,
3582 x_cust_par_opt_cont_inc_amt IN NUMBER DEFAULT NULL,
3583 x_cust_par_opt_cont_ast_amt IN NUMBER DEFAULT NULL,
3584 x_cust_par_opt_tot_cont_amt IN NUMBER DEFAULT NULL,
3585 x_parents_email_txt IN VARCHAR2 DEFAULT NULL,
3586 x_parent_1_birth_date IN DATE DEFAULT NULL,
3587 x_parent_2_birth_date IN DATE DEFAULT NULL,
3588 x_match_code IN VARCHAR2 DEFAULT NULL
3589 );
3590
3591 END igf_ap_css_interface_pkg;