1 PACKAGE igf_ap_css_fnar_pkg AS
2 /* $Header: IGFAI33S.pls 120.0 2005/06/01 13:31:12 appldev noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_fnar_id IN OUT NOCOPY NUMBER,
7 x_cssp_id IN NUMBER,
8 x_r_s_email_address IN VARCHAR2,
9 x_eps_code IN VARCHAR2,
10 x_comp_css_dependency_status IN VARCHAR2,
11 x_stu_age IN VARCHAR2,
12 x_assumed_stu_yr_in_coll IN VARCHAR2,
13 x_comp_stu_marital_status IN VARCHAR2,
14 x_stu_family_members IN NUMBER,
15 x_stu_fam_members_in_college IN NUMBER,
16 x_par_marital_status IN VARCHAR2,
17 x_par_family_members IN NUMBER,
18 x_par_total_in_college IN NUMBER,
19 x_par_par_in_college IN NUMBER,
20 x_par_others_in_college IN NUMBER,
21 x_par_aesa IN NUMBER,
22 x_par_cesa IN NUMBER,
23 x_stu_aesa IN NUMBER,
24 x_stu_cesa IN NUMBER,
25 x_im_p_bas_agi_taxable_income IN NUMBER,
26 x_im_p_bas_untx_inc_and_ben IN NUMBER,
27 x_im_p_bas_inc_adj IN NUMBER,
28 x_im_p_bas_total_income IN NUMBER,
29 x_im_p_bas_us_income_tax IN NUMBER,
30 x_im_p_bas_st_and_other_tax IN NUMBER,
31 x_im_p_bas_fica_tax IN NUMBER,
32 x_im_p_bas_med_dental IN NUMBER,
33 x_im_p_bas_employment_allow IN NUMBER,
34 x_im_p_bas_annual_ed_savings IN NUMBER,
35 x_im_p_bas_inc_prot_allow_m IN NUMBER,
36 x_im_p_bas_total_inc_allow IN NUMBER,
37 x_im_p_bas_cal_avail_inc IN NUMBER,
38 x_im_p_bas_avail_income IN NUMBER,
39 x_im_p_bas_total_cont_inc IN NUMBER,
40 x_im_p_bas_cash_bank_accounts IN NUMBER,
41 x_im_p_bas_home_equity IN NUMBER,
42 x_im_p_bas_ot_rl_est_inv_eq IN NUMBER,
43 x_im_p_bas_adj_bus_farm_worth IN NUMBER,
44 x_im_p_bas_ass_sibs_pre_tui IN NUMBER,
45 x_im_p_bas_net_worth IN NUMBER,
46 x_im_p_bas_emerg_res_allow IN NUMBER,
47 x_im_p_bas_cum_ed_savings IN NUMBER,
48 x_im_p_bas_low_inc_allow IN NUMBER,
49 x_im_p_bas_total_asset_allow IN NUMBER,
50 x_im_p_bas_disc_net_worth IN NUMBER,
51 x_im_p_bas_total_cont_asset IN NUMBER,
52 x_im_p_bas_total_cont IN NUMBER,
53 x_im_p_bas_num_in_coll_adj IN NUMBER,
54 x_im_p_bas_cont_for_stu IN NUMBER,
55 x_im_p_bas_cont_from_income IN NUMBER,
56 x_im_p_bas_cont_from_assets IN NUMBER,
57 x_im_p_opt_agi_taxable_income IN NUMBER,
58 x_im_p_opt_untx_inc_and_ben IN NUMBER,
59 x_im_p_opt_inc_adj IN NUMBER,
60 x_im_p_opt_total_income IN NUMBER,
61 x_im_p_opt_us_income_tax IN NUMBER,
62 x_im_p_opt_st_and_other_tax IN NUMBER,
63 x_im_p_opt_fica_tax IN NUMBER,
64 x_im_p_opt_med_dental IN NUMBER,
65 x_im_p_opt_elem_sec_tuit IN NUMBER,
66 x_im_p_opt_employment_allow IN NUMBER,
67 x_im_p_opt_annual_ed_savings IN NUMBER,
68 x_im_p_opt_inc_prot_allow_m IN NUMBER,
69 x_im_p_opt_total_inc_allow IN NUMBER,
70 x_im_p_opt_cal_avail_inc IN NUMBER,
71 x_im_p_opt_avail_income IN NUMBER,
72 x_im_p_opt_total_cont_inc IN NUMBER,
73 x_im_p_opt_cash_bank_accounts IN NUMBER,
74 x_im_p_opt_home_equity IN NUMBER,
75 x_im_p_opt_ot_rl_est_inv_eq IN NUMBER,
76 x_im_p_opt_adj_bus_farm_worth IN NUMBER,
77 x_im_p_opt_ass_sibs_pre_tui IN NUMBER,
78 x_im_p_opt_net_worth IN NUMBER,
79 x_im_p_opt_emerg_res_allow IN NUMBER,
80 x_im_p_opt_cum_ed_savings IN NUMBER,
81 x_im_p_opt_low_inc_allow IN NUMBER,
82 x_im_p_opt_total_asset_allow IN NUMBER,
83 x_im_p_opt_disc_net_worth IN NUMBER,
84 x_im_p_opt_total_cont_asset IN NUMBER,
85 x_im_p_opt_total_cont IN NUMBER,
86 x_im_p_opt_num_in_coll_adj IN NUMBER,
87 x_im_p_opt_cont_for_stu IN NUMBER,
88 x_im_p_opt_cont_from_income IN NUMBER,
89 x_im_p_opt_cont_from_assets IN NUMBER,
90 x_fm_p_analysis_type IN VARCHAR2,
91 x_fm_p_agi_taxable_income IN NUMBER,
92 x_fm_p_untx_inc_and_ben IN NUMBER,
93 x_fm_p_inc_adj IN NUMBER,
94 x_fm_p_total_income IN NUMBER,
95 x_fm_p_us_income_tax IN NUMBER,
96 x_fm_p_state_and_other_taxes IN NUMBER,
97 x_fm_p_fica_tax IN NUMBER,
98 x_fm_p_employment_allow IN NUMBER,
99 x_fm_p_income_prot_allow IN NUMBER,
100 x_fm_p_total_allow IN NUMBER,
101 x_fm_p_avail_income IN NUMBER,
102 x_fm_p_cash_bank_accounts IN NUMBER,
103 x_fm_p_ot_rl_est_inv_equity IN NUMBER,
104 x_fm_p_adj_bus_farm_net_worth IN NUMBER,
105 x_fm_p_net_worth IN NUMBER,
106 x_fm_p_asset_prot_allow IN NUMBER,
107 x_fm_p_disc_net_worth IN NUMBER,
108 x_fm_p_total_contribution IN NUMBER,
109 x_fm_p_num_in_coll IN NUMBER,
110 x_fm_p_cont_for_stu IN NUMBER,
111 x_fm_p_cont_from_income IN NUMBER,
112 x_fm_p_cont_from_assets IN NUMBER,
113 x_im_s_bas_agi_taxable_income IN NUMBER,
114 x_im_s_bas_untx_inc_and_ben IN NUMBER,
115 x_im_s_bas_inc_adj IN NUMBER,
116 x_im_s_bas_total_income IN NUMBER,
117 x_im_s_bas_us_income_tax IN NUMBER,
118 x_im_s_bas_state_and_oth_taxes IN NUMBER,
119 x_im_s_bas_fica_tax IN NUMBER,
120 x_im_s_bas_med_dental IN NUMBER,
121 x_im_s_bas_employment_allow IN NUMBER,
122 x_im_s_bas_annual_ed_savings IN NUMBER,
123 x_im_s_bas_inc_prot_allow_m IN NUMBER,
124 x_im_s_bas_total_inc_allow IN NUMBER,
125 x_im_s_bas_cal_avail_income IN NUMBER,
126 x_im_s_bas_avail_income IN NUMBER,
127 x_im_s_bas_total_cont_inc IN NUMBER,
128 x_im_s_bas_cash_bank_accounts IN NUMBER,
129 x_im_s_bas_home_equity IN NUMBER,
130 x_im_s_bas_ot_rl_est_inv_eq IN NUMBER,
131 x_im_s_bas_adj_busfarm_worth IN NUMBER,
132 x_im_s_bas_trusts IN NUMBER,
133 x_im_s_bas_net_worth IN NUMBER,
134 x_im_s_bas_emerg_res_allow IN NUMBER,
135 x_im_s_bas_cum_ed_savings IN NUMBER,
136 x_im_s_bas_total_asset_allow IN NUMBER,
137 x_im_s_bas_disc_net_worth IN NUMBER,
138 x_im_s_bas_total_cont_asset IN NUMBER,
139 x_im_s_bas_total_cont IN NUMBER,
140 x_im_s_bas_num_in_coll_adj IN NUMBER,
141 x_im_s_bas_cont_for_stu IN NUMBER,
142 x_im_s_bas_cont_from_income IN NUMBER,
143 x_im_s_bas_cont_from_assets IN NUMBER,
144 x_im_s_est_agitaxable_income IN NUMBER,
145 x_im_s_est_untx_inc_and_ben IN NUMBER,
146 x_im_s_est_inc_adj IN NUMBER,
147 x_im_s_est_total_income IN NUMBER,
148 x_im_s_est_us_income_tax IN NUMBER,
149 x_im_s_est_state_and_oth_taxes IN NUMBER,
150 x_im_s_est_fica_tax IN NUMBER,
151 x_im_s_est_med_dental IN NUMBER,
152 x_im_s_est_employment_allow IN NUMBER,
153 x_im_s_est_annual_ed_savings IN NUMBER,
154 x_im_s_est_inc_prot_allow_m IN NUMBER,
155 x_im_s_est_total_inc_allow IN NUMBER,
156 x_im_s_est_cal_avail_income IN NUMBER,
157 x_im_s_est_avail_income IN NUMBER,
158 x_im_s_est_total_cont_inc IN NUMBER,
159 x_im_s_est_cash_bank_accounts IN NUMBER,
160 x_im_s_est_home_equity IN NUMBER,
161 x_im_s_est_ot_rl_est_inv_eq IN NUMBER,
162 x_im_s_est_adj_bus_farm_worth IN NUMBER,
163 x_im_s_est_est_trusts IN NUMBER,
164 x_im_s_est_net_worth IN NUMBER,
165 x_im_s_est_emerg_res_allow IN NUMBER,
166 x_im_s_est_cum_ed_savings IN NUMBER,
167 x_im_s_est_total_asset_allow IN NUMBER,
168 x_im_s_est_disc_net_worth IN NUMBER,
169 x_im_s_est_total_cont_asset IN NUMBER,
170 x_im_s_est_total_cont IN NUMBER,
171 x_im_s_est_num_in_coll_adj IN NUMBER,
172 x_im_s_est_cont_for_stu IN NUMBER,
173 x_im_s_est_cont_from_income IN NUMBER,
174 x_im_s_est_cont_from_assets IN NUMBER,
175 x_im_s_opt_agi_taxable_income IN NUMBER,
176 x_im_s_opt_untx_inc_and_ben IN NUMBER,
177 x_im_s_opt_inc_adj IN NUMBER,
178 x_im_s_opt_total_income IN NUMBER,
179 x_im_s_opt_us_income_tax IN NUMBER,
180 x_im_s_opt_state_and_oth_taxes IN NUMBER,
181 x_im_s_opt_fica_tax IN NUMBER,
182 x_im_s_opt_med_dental IN NUMBER,
183 x_im_s_opt_employment_allow IN NUMBER,
184 x_im_s_opt_annual_ed_savings IN NUMBER,
185 x_im_s_opt_inc_prot_allow_m IN NUMBER,
186 x_im_s_opt_total_inc_allow IN NUMBER,
187 x_im_s_opt_cal_avail_income IN NUMBER,
188 x_im_s_opt_avail_income IN NUMBER,
189 x_im_s_opt_total_cont_inc IN NUMBER,
190 x_im_s_opt_cash_bank_accounts IN NUMBER,
191 x_im_s_opt_ira_keogh_accounts IN NUMBER,
192 x_im_s_opt_home_equity IN NUMBER,
193 x_im_s_opt_ot_rl_est_inv_eq IN NUMBER,
194 x_im_s_opt_adj_bus_farm_worth IN NUMBER,
195 x_im_s_opt_trusts IN NUMBER,
196 x_im_s_opt_net_worth IN NUMBER,
197 x_im_s_opt_emerg_res_allow IN NUMBER,
198 x_im_s_opt_cum_ed_savings IN NUMBER,
199 x_im_s_opt_total_asset_allow IN NUMBER,
200 x_im_s_opt_disc_net_worth IN NUMBER,
201 x_im_s_opt_total_cont_asset IN NUMBER,
202 x_im_s_opt_total_cont IN NUMBER,
203 x_im_s_opt_num_in_coll_adj IN NUMBER,
204 x_im_s_opt_cont_for_stu IN NUMBER,
205 x_im_s_opt_cont_from_income IN NUMBER,
206 x_im_s_opt_cont_from_assets IN NUMBER,
207 x_fm_s_analysis_type IN VARCHAR2,
208 x_fm_s_agi_taxable_income IN NUMBER,
209 x_fm_s_untx_inc_and_ben IN NUMBER,
210 x_fm_s_inc_adj IN NUMBER,
211 x_fm_s_total_income IN NUMBER,
212 x_fm_s_us_income_tax IN NUMBER,
213 x_fm_s_state_and_oth_taxes IN NUMBER,
214 x_fm_s_fica_tax IN NUMBER,
215 x_fm_s_employment_allow IN NUMBER,
216 x_fm_s_income_prot_allow IN NUMBER,
217 x_fm_s_total_allow IN NUMBER,
218 x_fm_s_cal_avail_income IN NUMBER,
219 x_fm_s_avail_income IN NUMBER,
220 x_fm_s_cash_bank_accounts IN NUMBER,
221 x_fm_s_ot_rl_est_inv_equity IN NUMBER,
222 x_fm_s_adj_bus_farm_worth IN NUMBER,
223 x_fm_s_trusts IN NUMBER,
224 x_fm_s_net_worth IN NUMBER,
225 x_fm_s_asset_prot_allow IN NUMBER,
226 x_fm_s_disc_net_worth IN NUMBER,
227 x_fm_s_total_cont IN NUMBER,
228 x_fm_s_num_in_coll IN NUMBER,
229 x_fm_s_cont_for_stu IN NUMBER,
230 x_fm_s_cont_from_income IN NUMBER,
231 x_fm_s_cont_from_assets IN NUMBER,
232 x_im_inst_resident_ind IN VARCHAR2,
233 x_institutional_1_budget_name IN VARCHAR2,
234 x_im_inst_1_budget_duration IN NUMBER,
235 x_im_inst_1_tuition_fees IN NUMBER,
236 x_im_inst_1_books_supplies IN NUMBER,
237 x_im_inst_1_living_expenses IN NUMBER,
238 x_im_inst_1_tot_expenses IN NUMBER,
239 x_im_inst_1_tot_stu_cont IN NUMBER,
240 x_im_inst_1_tot_par_cont IN NUMBER,
241 x_im_inst_1_tot_family_cont IN NUMBER,
242 x_im_inst_1_va_benefits IN NUMBER,
243 x_im_inst_1_ot_cont IN NUMBER,
244 x_im_inst_1_est_financial_need IN NUMBER,
245 x_institutional_2_budget_name IN VARCHAR2,
246 x_im_inst_2_budget_duration IN VARCHAR2,
247 x_im_inst_2_tuition_fees IN NUMBER,
248 x_im_inst_2_books_supplies IN NUMBER,
249 x_im_inst_2_living_expenses IN NUMBER,
250 x_im_inst_2_tot_expenses IN NUMBER,
251 x_im_inst_2_tot_stu_cont IN NUMBER,
252 x_im_inst_2_tot_par_cont IN NUMBER,
253 x_im_inst_2_tot_family_cont IN NUMBER,
254 x_im_inst_2_va_benefits IN NUMBER,
255 x_im_inst_2_est_financial_need IN NUMBER,
256 x_institutional_3_budget_name IN VARCHAR2,
257 x_im_inst_3_budget_duration IN NUMBER,
258 x_im_inst_3_tuition_fees IN NUMBER,
259 x_im_inst_3_books_supplies IN NUMBER,
260 x_im_inst_3_living_expenses IN NUMBER,
261 x_im_inst_3_tot_expenses IN NUMBER,
262 x_im_inst_3_tot_stu_cont IN NUMBER,
263 x_im_inst_3_tot_par_cont IN NUMBER,
264 x_im_inst_3_tot_family_cont IN NUMBER,
265 x_im_inst_3_va_benefits IN NUMBER,
266 x_im_inst_3_est_financial_need IN NUMBER,
267 x_fm_inst_1_federal_efc IN VARCHAR2,
268 x_fm_inst_1_va_benefits IN VARCHAR2,
269 x_fm_inst_1_fed_eligibility IN VARCHAR2,
270 x_fm_inst_1_pell IN VARCHAR2,
271 x_option_par_loss_allow_ind IN VARCHAR2,
272 x_option_par_tuition_ind IN VARCHAR2,
273 x_option_par_home_ind IN VARCHAR2,
274 x_option_par_home_value IN VARCHAR2,
275 x_option_par_home_debt IN VARCHAR2,
276 x_option_stu_ira_keogh_ind IN VARCHAR2,
277 x_option_stu_home_ind IN VARCHAR2,
278 x_option_stu_home_value IN VARCHAR2,
279 x_option_stu_home_debt IN VARCHAR2,
280 x_option_stu_sum_ay_inc_ind IN VARCHAR2,
281 x_option_par_hope_ll_credit IN VARCHAR2,
282 x_option_stu_hope_ll_credit IN VARCHAR2,
283 x_im_parent_1_8_months_bas IN VARCHAR2,
284 x_im_p_more_than_9_mth_ba IN VARCHAR2,
285 x_im_parent_1_8_months_opt IN VARCHAR2,
286 x_im_p_more_than_9_mth_op IN VARCHAR2,
287 x_fnar_message_1 IN VARCHAR2,
288 x_fnar_message_2 IN VARCHAR2,
289 x_fnar_message_3 IN VARCHAR2,
290 x_fnar_message_4 IN VARCHAR2,
291 x_fnar_message_5 IN VARCHAR2,
292 x_fnar_message_6 IN VARCHAR2,
293 x_fnar_message_7 IN VARCHAR2,
294 x_fnar_message_8 IN VARCHAR2,
295 x_fnar_message_9 IN VARCHAR2,
296 x_fnar_message_10 IN VARCHAR2,
297 x_fnar_message_11 IN VARCHAR2,
298 x_fnar_message_12 IN VARCHAR2,
302 x_fnar_message_22 IN VARCHAR2,
299 x_fnar_message_13 IN VARCHAR2,
300 x_fnar_message_20 IN VARCHAR2,
301 x_fnar_message_21 IN VARCHAR2,
303 x_fnar_message_23 IN VARCHAR2,
304 x_fnar_message_24 IN VARCHAR2,
305 x_fnar_message_25 IN VARCHAR2,
306 x_fnar_message_26 IN VARCHAR2,
307 x_fnar_message_27 IN VARCHAR2,
308 x_fnar_message_30 IN VARCHAR2,
309 x_fnar_message_31 IN VARCHAR2,
310 x_fnar_message_32 IN VARCHAR2,
311 x_fnar_message_33 IN VARCHAR2,
312 x_fnar_message_34 IN VARCHAR2,
313 x_fnar_message_35 IN VARCHAR2,
314 x_fnar_message_36 IN VARCHAR2,
315 x_fnar_message_37 IN VARCHAR2,
316 x_fnar_message_38 IN VARCHAR2,
317 x_fnar_message_39 IN VARCHAR2,
318 x_fnar_message_45 IN VARCHAR2,
319 x_fnar_message_46 IN VARCHAR2,
320 x_fnar_message_47 IN VARCHAR2,
321 x_fnar_message_48 IN VARCHAR2,
322 x_fnar_message_50 IN VARCHAR2,
323 x_fnar_message_51 IN VARCHAR2,
324 x_fnar_message_52 IN VARCHAR2,
325 x_fnar_message_53 IN VARCHAR2,
326 x_fnar_message_56 IN VARCHAR2,
327 x_fnar_message_57 IN VARCHAR2,
328 x_fnar_message_58 IN VARCHAR2,
329 x_fnar_message_59 IN VARCHAR2,
330 x_fnar_message_60 IN VARCHAR2,
331 x_fnar_message_61 IN VARCHAR2,
332 x_fnar_message_62 IN VARCHAR2,
333 x_fnar_message_63 IN VARCHAR2,
334 x_fnar_message_64 IN VARCHAR2,
335 x_fnar_message_65 IN VARCHAR2,
336 x_fnar_message_71 IN VARCHAR2,
337 x_fnar_message_72 IN VARCHAR2,
338 x_fnar_message_73 IN VARCHAR2,
339 x_fnar_message_74 IN VARCHAR2,
340 x_fnar_message_75 IN VARCHAR2,
341 x_fnar_message_76 IN VARCHAR2,
342 x_fnar_message_77 IN VARCHAR2,
343 x_fnar_message_78 IN VARCHAR2,
344 x_fnar_mesg_10_stu_fam_mem IN VARCHAR2,
345 x_fnar_mesg_11_stu_no_in_coll IN VARCHAR2,
346 x_fnar_mesg_24_stu_avail_inc IN VARCHAR2,
347 x_fnar_mesg_26_stu_taxes IN VARCHAR2,
348 x_fnar_mesg_33_stu_home_value IN VARCHAR2,
349 x_fnar_mesg_34_stu_home_value IN VARCHAR2,
350 x_fnar_mesg_34_stu_home_equity IN VARCHAR2,
351 x_fnar_mesg_35_stu_home_value IN VARCHAR2,
352 x_fnar_mesg_35_stu_home_equity IN VARCHAR2,
353 x_fnar_mesg_36_stu_home_equity IN VARCHAR2,
354 x_fnar_mesg_48_par_fam_mem IN VARCHAR2,
355 x_fnar_mesg_49_par_no_in_coll IN VARCHAR2,
356 x_fnar_mesg_56_par_agi IN VARCHAR2,
357 x_fnar_mesg_62_par_taxes IN VARCHAR2,
358 x_fnar_mesg_73_par_home_value IN VARCHAR2,
359 x_fnar_mesg_74_par_home_value IN VARCHAR2,
360 x_fnar_mesg_74_par_home_equity IN VARCHAR2,
361 x_fnar_mesg_75_par_home_value IN VARCHAR2,
362 x_fnar_mesg_75_par_home_equity IN VARCHAR2,
363 x_fnar_mesg_76_par_home_equity IN VARCHAR2,
364 x_assumption_message_1 IN VARCHAR2,
365 x_assumption_message_2 IN VARCHAR2,
366 x_assumption_message_3 IN VARCHAR2,
367 x_assumption_message_4 IN VARCHAR2,
368 x_assumption_message_5 IN VARCHAR2,
369 x_assumption_message_6 IN VARCHAR2,
370 x_record_mark IN VARCHAR2,
371 x_mode IN VARCHAR2 DEFAULT 'R',
372 x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
373 x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
374 x_opt_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
375 x_opt_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
376 x_opt_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
377 x_opt_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
378 x_opt_par_cola_adj_value IN NUMBER DEFAULT NULL,
379 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
380 x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
381 x_cust_parent_cont_adj_num IN NUMBER DEFAULT NULL,
382 x_custodial_parent_num IN NUMBER DEFAULT NULL,
383 x_cust_par_base_prcnt_inc_amt IN NUMBER DEFAULT NULL,
384 x_cust_par_base_cont_inc_amt IN NUMBER DEFAULT NULL,
385 x_cust_par_base_cont_ast_amt IN NUMBER DEFAULT NULL,
386 x_cust_par_base_tot_cont_amt IN NUMBER DEFAULT NULL,
387 x_cust_par_opt_prcnt_inc_amt IN NUMBER DEFAULT NULL,
388 x_cust_par_opt_cont_inc_amt IN NUMBER DEFAULT NULL,
389 x_cust_par_opt_cont_ast_amt IN NUMBER DEFAULT NULL,
390 x_cust_par_opt_tot_cont_amt IN NUMBER DEFAULT NULL,
394 );
391 x_parents_email_txt IN VARCHAR2 DEFAULT NULL,
392 x_parent_1_birth_date IN DATE DEFAULT NULL,
393 x_parent_2_birth_date IN DATE DEFAULT NULL
395
396 PROCEDURE lock_row (
397 x_rowid IN VARCHAR2,
398 x_fnar_id IN NUMBER,
399 x_cssp_id IN NUMBER,
400 x_r_s_email_address IN VARCHAR2,
401 x_eps_code IN VARCHAR2,
402 x_comp_css_dependency_status IN VARCHAR2,
403 x_stu_age IN VARCHAR2,
404 x_assumed_stu_yr_in_coll IN VARCHAR2,
405 x_comp_stu_marital_status IN VARCHAR2,
406 x_stu_family_members IN NUMBER,
407 x_stu_fam_members_in_college IN NUMBER,
408 x_par_marital_status IN VARCHAR2,
409 x_par_family_members IN NUMBER,
410 x_par_total_in_college IN NUMBER,
411 x_par_par_in_college IN NUMBER,
412 x_par_others_in_college IN NUMBER,
413 x_par_aesa IN NUMBER,
414 x_par_cesa IN NUMBER,
415 x_stu_aesa IN NUMBER,
416 x_stu_cesa IN NUMBER,
417 x_im_p_bas_agi_taxable_income IN NUMBER,
418 x_im_p_bas_untx_inc_and_ben IN NUMBER,
419 x_im_p_bas_inc_adj IN NUMBER,
420 x_im_p_bas_total_income IN NUMBER,
421 x_im_p_bas_us_income_tax IN NUMBER,
422 x_im_p_bas_st_and_other_tax IN NUMBER,
423 x_im_p_bas_fica_tax IN NUMBER,
424 x_im_p_bas_med_dental IN NUMBER,
425 x_im_p_bas_employment_allow IN NUMBER,
426 x_im_p_bas_annual_ed_savings IN NUMBER,
427 x_im_p_bas_inc_prot_allow_m IN NUMBER,
428 x_im_p_bas_total_inc_allow IN NUMBER,
429 x_im_p_bas_cal_avail_inc IN NUMBER,
430 x_im_p_bas_avail_income IN NUMBER,
431 x_im_p_bas_total_cont_inc IN NUMBER,
432 x_im_p_bas_cash_bank_accounts IN NUMBER,
433 x_im_p_bas_home_equity IN NUMBER,
434 x_im_p_bas_ot_rl_est_inv_eq IN NUMBER,
435 x_im_p_bas_adj_bus_farm_worth IN NUMBER,
436 x_im_p_bas_ass_sibs_pre_tui IN NUMBER,
437 x_im_p_bas_net_worth IN NUMBER,
438 x_im_p_bas_emerg_res_allow IN NUMBER,
439 x_im_p_bas_cum_ed_savings IN NUMBER,
440 x_im_p_bas_low_inc_allow IN NUMBER,
441 x_im_p_bas_total_asset_allow IN NUMBER,
442 x_im_p_bas_disc_net_worth IN NUMBER,
443 x_im_p_bas_total_cont_asset IN NUMBER,
444 x_im_p_bas_total_cont IN NUMBER,
445 x_im_p_bas_num_in_coll_adj IN NUMBER,
446 x_im_p_bas_cont_for_stu IN NUMBER,
447 x_im_p_bas_cont_from_income IN NUMBER,
448 x_im_p_bas_cont_from_assets IN NUMBER,
449 x_im_p_opt_agi_taxable_income IN NUMBER,
450 x_im_p_opt_untx_inc_and_ben IN NUMBER,
451 x_im_p_opt_inc_adj IN NUMBER,
452 x_im_p_opt_total_income IN NUMBER,
453 x_im_p_opt_us_income_tax IN NUMBER,
454 x_im_p_opt_st_and_other_tax IN NUMBER,
455 x_im_p_opt_fica_tax IN NUMBER,
456 x_im_p_opt_med_dental IN NUMBER,
457 x_im_p_opt_elem_sec_tuit IN NUMBER,
458 x_im_p_opt_employment_allow IN NUMBER,
459 x_im_p_opt_annual_ed_savings IN NUMBER,
460 x_im_p_opt_inc_prot_allow_m IN NUMBER,
461 x_im_p_opt_total_inc_allow IN NUMBER,
462 x_im_p_opt_cal_avail_inc IN NUMBER,
463 x_im_p_opt_avail_income IN NUMBER,
464 x_im_p_opt_total_cont_inc IN NUMBER,
465 x_im_p_opt_cash_bank_accounts IN NUMBER,
466 x_im_p_opt_home_equity IN NUMBER,
467 x_im_p_opt_ot_rl_est_inv_eq IN NUMBER,
468 x_im_p_opt_adj_bus_farm_worth IN NUMBER,
469 x_im_p_opt_ass_sibs_pre_tui IN NUMBER,
470 x_im_p_opt_net_worth IN NUMBER,
471 x_im_p_opt_emerg_res_allow IN NUMBER,
472 x_im_p_opt_cum_ed_savings IN NUMBER,
473 x_im_p_opt_low_inc_allow IN NUMBER,
474 x_im_p_opt_total_asset_allow IN NUMBER,
475 x_im_p_opt_disc_net_worth IN NUMBER,
476 x_im_p_opt_total_cont_asset IN NUMBER,
477 x_im_p_opt_total_cont IN NUMBER,
478 x_im_p_opt_num_in_coll_adj IN NUMBER,
479 x_im_p_opt_cont_for_stu IN NUMBER,
480 x_im_p_opt_cont_from_income IN NUMBER,
481 x_im_p_opt_cont_from_assets IN NUMBER,
482 x_fm_p_analysis_type IN VARCHAR2,
483 x_fm_p_agi_taxable_income IN NUMBER,
484 x_fm_p_untx_inc_and_ben IN NUMBER,
485 x_fm_p_inc_adj IN NUMBER,
486 x_fm_p_total_income IN NUMBER,
487 x_fm_p_us_income_tax IN NUMBER,
488 x_fm_p_state_and_other_taxes IN NUMBER,
489 x_fm_p_fica_tax IN NUMBER,
493 x_fm_p_avail_income IN NUMBER,
490 x_fm_p_employment_allow IN NUMBER,
491 x_fm_p_income_prot_allow IN NUMBER,
492 x_fm_p_total_allow IN NUMBER,
494 x_fm_p_cash_bank_accounts IN NUMBER,
495 x_fm_p_ot_rl_est_inv_equity IN NUMBER,
496 x_fm_p_adj_bus_farm_net_worth IN NUMBER,
497 x_fm_p_net_worth IN NUMBER,
498 x_fm_p_asset_prot_allow IN NUMBER,
499 x_fm_p_disc_net_worth IN NUMBER,
500 x_fm_p_total_contribution IN NUMBER,
501 x_fm_p_num_in_coll IN NUMBER,
502 x_fm_p_cont_for_stu IN NUMBER,
503 x_fm_p_cont_from_income IN NUMBER,
504 x_fm_p_cont_from_assets IN NUMBER,
505 x_im_s_bas_agi_taxable_income IN NUMBER,
506 x_im_s_bas_untx_inc_and_ben IN NUMBER,
507 x_im_s_bas_inc_adj IN NUMBER,
508 x_im_s_bas_total_income IN NUMBER,
509 x_im_s_bas_us_income_tax IN NUMBER,
510 x_im_s_bas_state_and_oth_taxes IN NUMBER,
511 x_im_s_bas_fica_tax IN NUMBER,
512 x_im_s_bas_med_dental IN NUMBER,
513 x_im_s_bas_employment_allow IN NUMBER,
514 x_im_s_bas_annual_ed_savings IN NUMBER,
515 x_im_s_bas_inc_prot_allow_m IN NUMBER,
516 x_im_s_bas_total_inc_allow IN NUMBER,
517 x_im_s_bas_cal_avail_income IN NUMBER,
518 x_im_s_bas_avail_income IN NUMBER,
519 x_im_s_bas_total_cont_inc IN NUMBER,
520 x_im_s_bas_cash_bank_accounts IN NUMBER,
521 x_im_s_bas_home_equity IN NUMBER,
522 x_im_s_bas_ot_rl_est_inv_eq IN NUMBER,
523 x_im_s_bas_adj_busfarm_worth IN NUMBER,
524 x_im_s_bas_trusts IN NUMBER,
525 x_im_s_bas_net_worth IN NUMBER,
526 x_im_s_bas_emerg_res_allow IN NUMBER,
527 x_im_s_bas_cum_ed_savings IN NUMBER,
528 x_im_s_bas_total_asset_allow IN NUMBER,
529 x_im_s_bas_disc_net_worth IN NUMBER,
530 x_im_s_bas_total_cont_asset IN NUMBER,
531 x_im_s_bas_total_cont IN NUMBER,
532 x_im_s_bas_num_in_coll_adj IN NUMBER,
533 x_im_s_bas_cont_for_stu IN NUMBER,
534 x_im_s_bas_cont_from_income IN NUMBER,
535 x_im_s_bas_cont_from_assets IN NUMBER,
536 x_im_s_est_agitaxable_income IN NUMBER,
537 x_im_s_est_untx_inc_and_ben IN NUMBER,
538 x_im_s_est_inc_adj IN NUMBER,
539 x_im_s_est_total_income IN NUMBER,
540 x_im_s_est_us_income_tax IN NUMBER,
541 x_im_s_est_state_and_oth_taxes IN NUMBER,
542 x_im_s_est_fica_tax IN NUMBER,
543 x_im_s_est_med_dental IN NUMBER,
544 x_im_s_est_employment_allow IN NUMBER,
545 x_im_s_est_annual_ed_savings IN NUMBER,
546 x_im_s_est_inc_prot_allow_m IN NUMBER,
547 x_im_s_est_total_inc_allow IN NUMBER,
548 x_im_s_est_cal_avail_income IN NUMBER,
549 x_im_s_est_avail_income IN NUMBER,
550 x_im_s_est_total_cont_inc IN NUMBER,
551 x_im_s_est_cash_bank_accounts IN NUMBER,
552 x_im_s_est_home_equity IN NUMBER,
553 x_im_s_est_ot_rl_est_inv_eq IN NUMBER,
554 x_im_s_est_adj_bus_farm_worth IN NUMBER,
555 x_im_s_est_est_trusts IN NUMBER,
556 x_im_s_est_net_worth IN NUMBER,
557 x_im_s_est_emerg_res_allow IN NUMBER,
558 x_im_s_est_cum_ed_savings IN NUMBER,
559 x_im_s_est_total_asset_allow IN NUMBER,
560 x_im_s_est_disc_net_worth IN NUMBER,
561 x_im_s_est_total_cont_asset IN NUMBER,
562 x_im_s_est_total_cont IN NUMBER,
563 x_im_s_est_num_in_coll_adj IN NUMBER,
564 x_im_s_est_cont_for_stu IN NUMBER,
565 x_im_s_est_cont_from_income IN NUMBER,
566 x_im_s_est_cont_from_assets IN NUMBER,
567 x_im_s_opt_agi_taxable_income IN NUMBER,
568 x_im_s_opt_untx_inc_and_ben IN NUMBER,
569 x_im_s_opt_inc_adj IN NUMBER,
570 x_im_s_opt_total_income IN NUMBER,
571 x_im_s_opt_us_income_tax IN NUMBER,
572 x_im_s_opt_state_and_oth_taxes IN NUMBER,
573 x_im_s_opt_fica_tax IN NUMBER,
574 x_im_s_opt_med_dental IN NUMBER,
575 x_im_s_opt_employment_allow IN NUMBER,
576 x_im_s_opt_annual_ed_savings IN NUMBER,
577 x_im_s_opt_inc_prot_allow_m IN NUMBER,
578 x_im_s_opt_total_inc_allow IN NUMBER,
579 x_im_s_opt_cal_avail_income IN NUMBER,
580 x_im_s_opt_avail_income IN NUMBER,
581 x_im_s_opt_total_cont_inc IN NUMBER,
582 x_im_s_opt_cash_bank_accounts IN NUMBER,
583 x_im_s_opt_ira_keogh_accounts IN NUMBER,
584 x_im_s_opt_home_equity IN NUMBER,
585 x_im_s_opt_ot_rl_est_inv_eq IN NUMBER,
586 x_im_s_opt_adj_bus_farm_worth IN NUMBER,
587 x_im_s_opt_trusts IN NUMBER,
591 x_im_s_opt_total_asset_allow IN NUMBER,
588 x_im_s_opt_net_worth IN NUMBER,
589 x_im_s_opt_emerg_res_allow IN NUMBER,
590 x_im_s_opt_cum_ed_savings IN NUMBER,
592 x_im_s_opt_disc_net_worth IN NUMBER,
593 x_im_s_opt_total_cont_asset IN NUMBER,
594 x_im_s_opt_total_cont IN NUMBER,
595 x_im_s_opt_num_in_coll_adj IN NUMBER,
596 x_im_s_opt_cont_for_stu IN NUMBER,
597 x_im_s_opt_cont_from_income IN NUMBER,
598 x_im_s_opt_cont_from_assets IN NUMBER,
599 x_fm_s_analysis_type IN VARCHAR2,
600 x_fm_s_agi_taxable_income IN NUMBER,
601 x_fm_s_untx_inc_and_ben IN NUMBER,
602 x_fm_s_inc_adj IN NUMBER,
603 x_fm_s_total_income IN NUMBER,
604 x_fm_s_us_income_tax IN NUMBER,
605 x_fm_s_state_and_oth_taxes IN NUMBER,
606 x_fm_s_fica_tax IN NUMBER,
607 x_fm_s_employment_allow IN NUMBER,
608 x_fm_s_income_prot_allow IN NUMBER,
609 x_fm_s_total_allow IN NUMBER,
610 x_fm_s_cal_avail_income IN NUMBER,
611 x_fm_s_avail_income IN NUMBER,
612 x_fm_s_cash_bank_accounts IN NUMBER,
613 x_fm_s_ot_rl_est_inv_equity IN NUMBER,
614 x_fm_s_adj_bus_farm_worth IN NUMBER,
615 x_fm_s_trusts IN NUMBER,
616 x_fm_s_net_worth IN NUMBER,
617 x_fm_s_asset_prot_allow IN NUMBER,
618 x_fm_s_disc_net_worth IN NUMBER,
619 x_fm_s_total_cont IN NUMBER,
620 x_fm_s_num_in_coll IN NUMBER,
621 x_fm_s_cont_for_stu IN NUMBER,
622 x_fm_s_cont_from_income IN NUMBER,
623 x_fm_s_cont_from_assets IN NUMBER,
624 x_im_inst_resident_ind IN VARCHAR2,
625 x_institutional_1_budget_name IN VARCHAR2,
626 x_im_inst_1_budget_duration IN NUMBER,
627 x_im_inst_1_tuition_fees IN NUMBER,
628 x_im_inst_1_books_supplies IN NUMBER,
629 x_im_inst_1_living_expenses IN NUMBER,
630 x_im_inst_1_tot_expenses IN NUMBER,
631 x_im_inst_1_tot_stu_cont IN NUMBER,
632 x_im_inst_1_tot_par_cont IN NUMBER,
633 x_im_inst_1_tot_family_cont IN NUMBER,
634 x_im_inst_1_va_benefits IN NUMBER,
635 x_im_inst_1_ot_cont IN NUMBER,
636 x_im_inst_1_est_financial_need IN NUMBER,
637 x_institutional_2_budget_name IN VARCHAR2,
638 x_im_inst_2_budget_duration IN VARCHAR2,
639 x_im_inst_2_tuition_fees IN NUMBER,
640 x_im_inst_2_books_supplies IN NUMBER,
641 x_im_inst_2_living_expenses IN NUMBER,
642 x_im_inst_2_tot_expenses IN NUMBER,
643 x_im_inst_2_tot_stu_cont IN NUMBER,
644 x_im_inst_2_tot_par_cont IN NUMBER,
645 x_im_inst_2_tot_family_cont IN NUMBER,
646 x_im_inst_2_va_benefits IN NUMBER,
647 x_im_inst_2_est_financial_need IN NUMBER,
648 x_institutional_3_budget_name IN VARCHAR2,
649 x_im_inst_3_budget_duration IN NUMBER,
650 x_im_inst_3_tuition_fees IN NUMBER,
651 x_im_inst_3_books_supplies IN NUMBER,
652 x_im_inst_3_living_expenses IN NUMBER,
653 x_im_inst_3_tot_expenses IN NUMBER,
654 x_im_inst_3_tot_stu_cont IN NUMBER,
655 x_im_inst_3_tot_par_cont IN NUMBER,
656 x_im_inst_3_tot_family_cont IN NUMBER,
657 x_im_inst_3_va_benefits IN NUMBER,
658 x_im_inst_3_est_financial_need IN NUMBER,
659 x_fm_inst_1_federal_efc IN VARCHAR2,
660 x_fm_inst_1_va_benefits IN VARCHAR2,
661 x_fm_inst_1_fed_eligibility IN VARCHAR2,
662 x_fm_inst_1_pell IN VARCHAR2,
663 x_option_par_loss_allow_ind IN VARCHAR2,
664 x_option_par_tuition_ind IN VARCHAR2,
665 x_option_par_home_ind IN VARCHAR2,
666 x_option_par_home_value IN VARCHAR2,
667 x_option_par_home_debt IN VARCHAR2,
668 x_option_stu_ira_keogh_ind IN VARCHAR2,
669 x_option_stu_home_ind IN VARCHAR2,
670 x_option_stu_home_value IN VARCHAR2,
671 x_option_stu_home_debt IN VARCHAR2,
672 x_option_stu_sum_ay_inc_ind IN VARCHAR2,
673 x_option_par_hope_ll_credit IN VARCHAR2,
674 x_option_stu_hope_ll_credit IN VARCHAR2,
675 x_im_parent_1_8_months_bas IN VARCHAR2,
676 x_im_p_more_than_9_mth_ba IN VARCHAR2,
677 x_im_parent_1_8_months_opt IN VARCHAR2,
678 x_im_p_more_than_9_mth_op IN VARCHAR2,
679 x_fnar_message_1 IN VARCHAR2,
680 x_fnar_message_2 IN VARCHAR2,
681 x_fnar_message_3 IN VARCHAR2,
682 x_fnar_message_4 IN VARCHAR2,
683 x_fnar_message_5 IN VARCHAR2,
684 x_fnar_message_6 IN VARCHAR2,
688 x_fnar_message_10 IN VARCHAR2,
685 x_fnar_message_7 IN VARCHAR2,
686 x_fnar_message_8 IN VARCHAR2,
687 x_fnar_message_9 IN VARCHAR2,
689 x_fnar_message_11 IN VARCHAR2,
690 x_fnar_message_12 IN VARCHAR2,
691 x_fnar_message_13 IN VARCHAR2,
692 x_fnar_message_20 IN VARCHAR2,
693 x_fnar_message_21 IN VARCHAR2,
694 x_fnar_message_22 IN VARCHAR2,
695 x_fnar_message_23 IN VARCHAR2,
696 x_fnar_message_24 IN VARCHAR2,
697 x_fnar_message_25 IN VARCHAR2,
698 x_fnar_message_26 IN VARCHAR2,
699 x_fnar_message_27 IN VARCHAR2,
700 x_fnar_message_30 IN VARCHAR2,
701 x_fnar_message_31 IN VARCHAR2,
702 x_fnar_message_32 IN VARCHAR2,
703 x_fnar_message_33 IN VARCHAR2,
704 x_fnar_message_34 IN VARCHAR2,
705 x_fnar_message_35 IN VARCHAR2,
706 x_fnar_message_36 IN VARCHAR2,
707 x_fnar_message_37 IN VARCHAR2,
708 x_fnar_message_38 IN VARCHAR2,
709 x_fnar_message_39 IN VARCHAR2,
710 x_fnar_message_45 IN VARCHAR2,
711 x_fnar_message_46 IN VARCHAR2,
712 x_fnar_message_47 IN VARCHAR2,
713 x_fnar_message_48 IN VARCHAR2,
714 x_fnar_message_50 IN VARCHAR2,
715 x_fnar_message_51 IN VARCHAR2,
716 x_fnar_message_52 IN VARCHAR2,
717 x_fnar_message_53 IN VARCHAR2,
718 x_fnar_message_56 IN VARCHAR2,
719 x_fnar_message_57 IN VARCHAR2,
720 x_fnar_message_58 IN VARCHAR2,
721 x_fnar_message_59 IN VARCHAR2,
722 x_fnar_message_60 IN VARCHAR2,
723 x_fnar_message_61 IN VARCHAR2,
724 x_fnar_message_62 IN VARCHAR2,
725 x_fnar_message_63 IN VARCHAR2,
726 x_fnar_message_64 IN VARCHAR2,
727 x_fnar_message_65 IN VARCHAR2,
728 x_fnar_message_71 IN VARCHAR2,
729 x_fnar_message_72 IN VARCHAR2,
730 x_fnar_message_73 IN VARCHAR2,
731 x_fnar_message_74 IN VARCHAR2,
732 x_fnar_message_75 IN VARCHAR2,
733 x_fnar_message_76 IN VARCHAR2,
734 x_fnar_message_77 IN VARCHAR2,
735 x_fnar_message_78 IN VARCHAR2,
736 x_fnar_mesg_10_stu_fam_mem IN VARCHAR2,
737 x_fnar_mesg_11_stu_no_in_coll IN VARCHAR2,
738 x_fnar_mesg_24_stu_avail_inc IN VARCHAR2,
739 x_fnar_mesg_26_stu_taxes IN VARCHAR2,
740 x_fnar_mesg_33_stu_home_value IN VARCHAR2,
741 x_fnar_mesg_34_stu_home_value IN VARCHAR2,
742 x_fnar_mesg_34_stu_home_equity IN VARCHAR2,
743 x_fnar_mesg_35_stu_home_value IN VARCHAR2,
744 x_fnar_mesg_35_stu_home_equity IN VARCHAR2,
745 x_fnar_mesg_36_stu_home_equity IN VARCHAR2,
746 x_fnar_mesg_48_par_fam_mem IN VARCHAR2,
747 x_fnar_mesg_49_par_no_in_coll IN VARCHAR2,
748 x_fnar_mesg_56_par_agi IN VARCHAR2,
749 x_fnar_mesg_62_par_taxes IN VARCHAR2,
750 x_fnar_mesg_73_par_home_value IN VARCHAR2,
751 x_fnar_mesg_74_par_home_value IN VARCHAR2,
752 x_fnar_mesg_74_par_home_equity IN VARCHAR2,
753 x_fnar_mesg_75_par_home_value IN VARCHAR2,
754 x_fnar_mesg_75_par_home_equity IN VARCHAR2,
755 x_fnar_mesg_76_par_home_equity IN VARCHAR2,
756 x_assumption_message_1 IN VARCHAR2,
757 x_assumption_message_2 IN VARCHAR2,
758 x_assumption_message_3 IN VARCHAR2,
759 x_assumption_message_4 IN VARCHAR2,
760 x_assumption_message_5 IN VARCHAR2,
761 x_assumption_message_6 IN VARCHAR2,
762 x_record_mark IN VARCHAR2,
763 x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
764 x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
765 x_opt_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
766 x_opt_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
767 x_opt_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
768 x_opt_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
769 x_opt_par_cola_adj_value IN NUMBER DEFAULT NULL,
770 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
771 x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
772 x_cust_parent_cont_adj_num IN NUMBER DEFAULT NULL,
773 x_custodial_parent_num IN NUMBER DEFAULT NULL,
774 x_cust_par_base_prcnt_inc_amt IN NUMBER DEFAULT NULL,
775 x_cust_par_base_cont_inc_amt IN NUMBER DEFAULT NULL,
776 x_cust_par_base_cont_ast_amt IN NUMBER DEFAULT NULL,
780 x_cust_par_opt_cont_ast_amt IN NUMBER DEFAULT NULL,
777 x_cust_par_base_tot_cont_amt IN NUMBER DEFAULT NULL,
778 x_cust_par_opt_prcnt_inc_amt IN NUMBER DEFAULT NULL,
779 x_cust_par_opt_cont_inc_amt IN NUMBER DEFAULT NULL,
781 x_cust_par_opt_tot_cont_amt IN NUMBER DEFAULT NULL,
782 x_parents_email_txt IN VARCHAR2 DEFAULT NULL,
783 x_parent_1_birth_date IN DATE DEFAULT NULL,
784 x_parent_2_birth_date IN DATE DEFAULT NULL
785 );
786
787 PROCEDURE update_row (
788 x_rowid IN VARCHAR2,
789 x_fnar_id IN NUMBER,
790 x_cssp_id IN NUMBER,
791 x_r_s_email_address IN VARCHAR2,
792 x_eps_code IN VARCHAR2,
793 x_comp_css_dependency_status IN VARCHAR2,
794 x_stu_age IN VARCHAR2,
795 x_assumed_stu_yr_in_coll IN VARCHAR2,
796 x_comp_stu_marital_status IN VARCHAR2,
797 x_stu_family_members IN NUMBER,
798 x_stu_fam_members_in_college IN NUMBER,
799 x_par_marital_status IN VARCHAR2,
800 x_par_family_members IN NUMBER,
801 x_par_total_in_college IN NUMBER,
802 x_par_par_in_college IN NUMBER,
803 x_par_others_in_college IN NUMBER,
804 x_par_aesa IN NUMBER,
805 x_par_cesa IN NUMBER,
806 x_stu_aesa IN NUMBER,
807 x_stu_cesa IN NUMBER,
808 x_im_p_bas_agi_taxable_income IN NUMBER,
809 x_im_p_bas_untx_inc_and_ben IN NUMBER,
810 x_im_p_bas_inc_adj IN NUMBER,
811 x_im_p_bas_total_income IN NUMBER,
812 x_im_p_bas_us_income_tax IN NUMBER,
813 x_im_p_bas_st_and_other_tax IN NUMBER,
814 x_im_p_bas_fica_tax IN NUMBER,
815 x_im_p_bas_med_dental IN NUMBER,
816 x_im_p_bas_employment_allow IN NUMBER,
817 x_im_p_bas_annual_ed_savings IN NUMBER,
818 x_im_p_bas_inc_prot_allow_m IN NUMBER,
819 x_im_p_bas_total_inc_allow IN NUMBER,
820 x_im_p_bas_cal_avail_inc IN NUMBER,
821 x_im_p_bas_avail_income IN NUMBER,
822 x_im_p_bas_total_cont_inc IN NUMBER,
823 x_im_p_bas_cash_bank_accounts IN NUMBER,
824 x_im_p_bas_home_equity IN NUMBER,
825 x_im_p_bas_ot_rl_est_inv_eq IN NUMBER,
826 x_im_p_bas_adj_bus_farm_worth IN NUMBER,
827 x_im_p_bas_ass_sibs_pre_tui IN NUMBER,
828 x_im_p_bas_net_worth IN NUMBER,
829 x_im_p_bas_emerg_res_allow IN NUMBER,
830 x_im_p_bas_cum_ed_savings IN NUMBER,
831 x_im_p_bas_low_inc_allow IN NUMBER,
832 x_im_p_bas_total_asset_allow IN NUMBER,
833 x_im_p_bas_disc_net_worth IN NUMBER,
834 x_im_p_bas_total_cont_asset IN NUMBER,
835 x_im_p_bas_total_cont IN NUMBER,
836 x_im_p_bas_num_in_coll_adj IN NUMBER,
837 x_im_p_bas_cont_for_stu IN NUMBER,
838 x_im_p_bas_cont_from_income IN NUMBER,
839 x_im_p_bas_cont_from_assets IN NUMBER,
840 x_im_p_opt_agi_taxable_income IN NUMBER,
841 x_im_p_opt_untx_inc_and_ben IN NUMBER,
842 x_im_p_opt_inc_adj IN NUMBER,
843 x_im_p_opt_total_income IN NUMBER,
844 x_im_p_opt_us_income_tax IN NUMBER,
845 x_im_p_opt_st_and_other_tax IN NUMBER,
846 x_im_p_opt_fica_tax IN NUMBER,
847 x_im_p_opt_med_dental IN NUMBER,
848 x_im_p_opt_elem_sec_tuit IN NUMBER,
849 x_im_p_opt_employment_allow IN NUMBER,
850 x_im_p_opt_annual_ed_savings IN NUMBER,
851 x_im_p_opt_inc_prot_allow_m IN NUMBER,
852 x_im_p_opt_total_inc_allow IN NUMBER,
853 x_im_p_opt_cal_avail_inc IN NUMBER,
854 x_im_p_opt_avail_income IN NUMBER,
855 x_im_p_opt_total_cont_inc IN NUMBER,
856 x_im_p_opt_cash_bank_accounts IN NUMBER,
857 x_im_p_opt_home_equity IN NUMBER,
858 x_im_p_opt_ot_rl_est_inv_eq IN NUMBER,
859 x_im_p_opt_adj_bus_farm_worth IN NUMBER,
860 x_im_p_opt_ass_sibs_pre_tui IN NUMBER,
861 x_im_p_opt_net_worth IN NUMBER,
862 x_im_p_opt_emerg_res_allow IN NUMBER,
863 x_im_p_opt_cum_ed_savings IN NUMBER,
864 x_im_p_opt_low_inc_allow IN NUMBER,
865 x_im_p_opt_total_asset_allow IN NUMBER,
866 x_im_p_opt_disc_net_worth IN NUMBER,
867 x_im_p_opt_total_cont_asset IN NUMBER,
868 x_im_p_opt_total_cont IN NUMBER,
869 x_im_p_opt_num_in_coll_adj IN NUMBER,
870 x_im_p_opt_cont_for_stu IN NUMBER,
871 x_im_p_opt_cont_from_income IN NUMBER,
872 x_im_p_opt_cont_from_assets IN NUMBER,
873 x_fm_p_analysis_type IN VARCHAR2,
877 x_fm_p_total_income IN NUMBER,
874 x_fm_p_agi_taxable_income IN NUMBER,
875 x_fm_p_untx_inc_and_ben IN NUMBER,
876 x_fm_p_inc_adj IN NUMBER,
878 x_fm_p_us_income_tax IN NUMBER,
879 x_fm_p_state_and_other_taxes IN NUMBER,
880 x_fm_p_fica_tax IN NUMBER,
881 x_fm_p_employment_allow IN NUMBER,
882 x_fm_p_income_prot_allow IN NUMBER,
883 x_fm_p_total_allow IN NUMBER,
884 x_fm_p_avail_income IN NUMBER,
885 x_fm_p_cash_bank_accounts IN NUMBER,
886 x_fm_p_ot_rl_est_inv_equity IN NUMBER,
887 x_fm_p_adj_bus_farm_net_worth IN NUMBER,
888 x_fm_p_net_worth IN NUMBER,
889 x_fm_p_asset_prot_allow IN NUMBER,
890 x_fm_p_disc_net_worth IN NUMBER,
891 x_fm_p_total_contribution IN NUMBER,
892 x_fm_p_num_in_coll IN NUMBER,
893 x_fm_p_cont_for_stu IN NUMBER,
894 x_fm_p_cont_from_income IN NUMBER,
895 x_fm_p_cont_from_assets IN NUMBER,
896 x_im_s_bas_agi_taxable_income IN NUMBER,
897 x_im_s_bas_untx_inc_and_ben IN NUMBER,
898 x_im_s_bas_inc_adj IN NUMBER,
899 x_im_s_bas_total_income IN NUMBER,
900 x_im_s_bas_us_income_tax IN NUMBER,
901 x_im_s_bas_state_and_oth_taxes IN NUMBER,
902 x_im_s_bas_fica_tax IN NUMBER,
903 x_im_s_bas_med_dental IN NUMBER,
904 x_im_s_bas_employment_allow IN NUMBER,
905 x_im_s_bas_annual_ed_savings IN NUMBER,
906 x_im_s_bas_inc_prot_allow_m IN NUMBER,
907 x_im_s_bas_total_inc_allow IN NUMBER,
908 x_im_s_bas_cal_avail_income IN NUMBER,
909 x_im_s_bas_avail_income IN NUMBER,
910 x_im_s_bas_total_cont_inc IN NUMBER,
911 x_im_s_bas_cash_bank_accounts IN NUMBER,
912 x_im_s_bas_home_equity IN NUMBER,
913 x_im_s_bas_ot_rl_est_inv_eq IN NUMBER,
914 x_im_s_bas_adj_busfarm_worth IN NUMBER,
915 x_im_s_bas_trusts IN NUMBER,
916 x_im_s_bas_net_worth IN NUMBER,
917 x_im_s_bas_emerg_res_allow IN NUMBER,
918 x_im_s_bas_cum_ed_savings IN NUMBER,
919 x_im_s_bas_total_asset_allow IN NUMBER,
920 x_im_s_bas_disc_net_worth IN NUMBER,
921 x_im_s_bas_total_cont_asset IN NUMBER,
922 x_im_s_bas_total_cont IN NUMBER,
923 x_im_s_bas_num_in_coll_adj IN NUMBER,
924 x_im_s_bas_cont_for_stu IN NUMBER,
925 x_im_s_bas_cont_from_income IN NUMBER,
926 x_im_s_bas_cont_from_assets IN NUMBER,
927 x_im_s_est_agitaxable_income IN NUMBER,
928 x_im_s_est_untx_inc_and_ben IN NUMBER,
929 x_im_s_est_inc_adj IN NUMBER,
930 x_im_s_est_total_income IN NUMBER,
931 x_im_s_est_us_income_tax IN NUMBER,
932 x_im_s_est_state_and_oth_taxes IN NUMBER,
933 x_im_s_est_fica_tax IN NUMBER,
934 x_im_s_est_med_dental IN NUMBER,
935 x_im_s_est_employment_allow IN NUMBER,
936 x_im_s_est_annual_ed_savings IN NUMBER,
937 x_im_s_est_inc_prot_allow_m IN NUMBER,
938 x_im_s_est_total_inc_allow IN NUMBER,
939 x_im_s_est_cal_avail_income IN NUMBER,
940 x_im_s_est_avail_income IN NUMBER,
941 x_im_s_est_total_cont_inc IN NUMBER,
942 x_im_s_est_cash_bank_accounts IN NUMBER,
943 x_im_s_est_home_equity IN NUMBER,
944 x_im_s_est_ot_rl_est_inv_eq IN NUMBER,
945 x_im_s_est_adj_bus_farm_worth IN NUMBER,
946 x_im_s_est_est_trusts IN NUMBER,
947 x_im_s_est_net_worth IN NUMBER,
948 x_im_s_est_emerg_res_allow IN NUMBER,
949 x_im_s_est_cum_ed_savings IN NUMBER,
950 x_im_s_est_total_asset_allow IN NUMBER,
951 x_im_s_est_disc_net_worth IN NUMBER,
952 x_im_s_est_total_cont_asset IN NUMBER,
953 x_im_s_est_total_cont IN NUMBER,
954 x_im_s_est_num_in_coll_adj IN NUMBER,
955 x_im_s_est_cont_for_stu IN NUMBER,
956 x_im_s_est_cont_from_income IN NUMBER,
957 x_im_s_est_cont_from_assets IN NUMBER,
958 x_im_s_opt_agi_taxable_income IN NUMBER,
959 x_im_s_opt_untx_inc_and_ben IN NUMBER,
960 x_im_s_opt_inc_adj IN NUMBER,
961 x_im_s_opt_total_income IN NUMBER,
962 x_im_s_opt_us_income_tax IN NUMBER,
963 x_im_s_opt_state_and_oth_taxes IN NUMBER,
964 x_im_s_opt_fica_tax IN NUMBER,
965 x_im_s_opt_med_dental IN NUMBER,
966 x_im_s_opt_employment_allow IN NUMBER,
967 x_im_s_opt_annual_ed_savings IN NUMBER,
968 x_im_s_opt_inc_prot_allow_m IN NUMBER,
969 x_im_s_opt_total_inc_allow IN NUMBER,
970 x_im_s_opt_cal_avail_income IN NUMBER,
974 x_im_s_opt_ira_keogh_accounts IN NUMBER,
971 x_im_s_opt_avail_income IN NUMBER,
972 x_im_s_opt_total_cont_inc IN NUMBER,
973 x_im_s_opt_cash_bank_accounts IN NUMBER,
975 x_im_s_opt_home_equity IN NUMBER,
976 x_im_s_opt_ot_rl_est_inv_eq IN NUMBER,
977 x_im_s_opt_adj_bus_farm_worth IN NUMBER,
978 x_im_s_opt_trusts IN NUMBER,
979 x_im_s_opt_net_worth IN NUMBER,
980 x_im_s_opt_emerg_res_allow IN NUMBER,
981 x_im_s_opt_cum_ed_savings IN NUMBER,
982 x_im_s_opt_total_asset_allow IN NUMBER,
983 x_im_s_opt_disc_net_worth IN NUMBER,
984 x_im_s_opt_total_cont_asset IN NUMBER,
985 x_im_s_opt_total_cont IN NUMBER,
986 x_im_s_opt_num_in_coll_adj IN NUMBER,
987 x_im_s_opt_cont_for_stu IN NUMBER,
988 x_im_s_opt_cont_from_income IN NUMBER,
989 x_im_s_opt_cont_from_assets IN NUMBER,
990 x_fm_s_analysis_type IN VARCHAR2,
991 x_fm_s_agi_taxable_income IN NUMBER,
992 x_fm_s_untx_inc_and_ben IN NUMBER,
993 x_fm_s_inc_adj IN NUMBER,
994 x_fm_s_total_income IN NUMBER,
995 x_fm_s_us_income_tax IN NUMBER,
996 x_fm_s_state_and_oth_taxes IN NUMBER,
997 x_fm_s_fica_tax IN NUMBER,
998 x_fm_s_employment_allow IN NUMBER,
999 x_fm_s_income_prot_allow IN NUMBER,
1000 x_fm_s_total_allow IN NUMBER,
1001 x_fm_s_cal_avail_income IN NUMBER,
1002 x_fm_s_avail_income IN NUMBER,
1003 x_fm_s_cash_bank_accounts IN NUMBER,
1004 x_fm_s_ot_rl_est_inv_equity IN NUMBER,
1005 x_fm_s_adj_bus_farm_worth IN NUMBER,
1006 x_fm_s_trusts IN NUMBER,
1007 x_fm_s_net_worth IN NUMBER,
1008 x_fm_s_asset_prot_allow IN NUMBER,
1009 x_fm_s_disc_net_worth IN NUMBER,
1010 x_fm_s_total_cont IN NUMBER,
1011 x_fm_s_num_in_coll IN NUMBER,
1012 x_fm_s_cont_for_stu IN NUMBER,
1013 x_fm_s_cont_from_income IN NUMBER,
1014 x_fm_s_cont_from_assets IN NUMBER,
1015 x_im_inst_resident_ind IN VARCHAR2,
1016 x_institutional_1_budget_name IN VARCHAR2,
1017 x_im_inst_1_budget_duration IN NUMBER,
1018 x_im_inst_1_tuition_fees IN NUMBER,
1019 x_im_inst_1_books_supplies IN NUMBER,
1020 x_im_inst_1_living_expenses IN NUMBER,
1021 x_im_inst_1_tot_expenses IN NUMBER,
1022 x_im_inst_1_tot_stu_cont IN NUMBER,
1023 x_im_inst_1_tot_par_cont IN NUMBER,
1024 x_im_inst_1_tot_family_cont IN NUMBER,
1025 x_im_inst_1_va_benefits IN NUMBER,
1026 x_im_inst_1_ot_cont IN NUMBER,
1027 x_im_inst_1_est_financial_need IN NUMBER,
1028 x_institutional_2_budget_name IN VARCHAR2,
1029 x_im_inst_2_budget_duration IN VARCHAR2,
1030 x_im_inst_2_tuition_fees IN NUMBER,
1031 x_im_inst_2_books_supplies IN NUMBER,
1032 x_im_inst_2_living_expenses IN NUMBER,
1033 x_im_inst_2_tot_expenses IN NUMBER,
1034 x_im_inst_2_tot_stu_cont IN NUMBER,
1035 x_im_inst_2_tot_par_cont IN NUMBER,
1036 x_im_inst_2_tot_family_cont IN NUMBER,
1037 x_im_inst_2_va_benefits IN NUMBER,
1038 x_im_inst_2_est_financial_need IN NUMBER,
1039 x_institutional_3_budget_name IN VARCHAR2,
1040 x_im_inst_3_budget_duration IN NUMBER,
1041 x_im_inst_3_tuition_fees IN NUMBER,
1042 x_im_inst_3_books_supplies IN NUMBER,
1043 x_im_inst_3_living_expenses IN NUMBER,
1044 x_im_inst_3_tot_expenses IN NUMBER,
1045 x_im_inst_3_tot_stu_cont IN NUMBER,
1046 x_im_inst_3_tot_par_cont IN NUMBER,
1047 x_im_inst_3_tot_family_cont IN NUMBER,
1048 x_im_inst_3_va_benefits IN NUMBER,
1049 x_im_inst_3_est_financial_need IN NUMBER,
1050 x_fm_inst_1_federal_efc IN VARCHAR2,
1051 x_fm_inst_1_va_benefits IN VARCHAR2,
1052 x_fm_inst_1_fed_eligibility IN VARCHAR2,
1053 x_fm_inst_1_pell IN VARCHAR2,
1054 x_option_par_loss_allow_ind IN VARCHAR2,
1055 x_option_par_tuition_ind IN VARCHAR2,
1056 x_option_par_home_ind IN VARCHAR2,
1057 x_option_par_home_value IN VARCHAR2,
1058 x_option_par_home_debt IN VARCHAR2,
1059 x_option_stu_ira_keogh_ind IN VARCHAR2,
1060 x_option_stu_home_ind IN VARCHAR2,
1061 x_option_stu_home_value IN VARCHAR2,
1062 x_option_stu_home_debt IN VARCHAR2,
1063 x_option_stu_sum_ay_inc_ind IN VARCHAR2,
1064 x_option_par_hope_ll_credit IN VARCHAR2,
1065 x_option_stu_hope_ll_credit IN VARCHAR2,
1066 x_im_parent_1_8_months_bas IN VARCHAR2,
1070 x_fnar_message_1 IN VARCHAR2,
1067 x_im_p_more_than_9_mth_ba IN VARCHAR2,
1068 x_im_parent_1_8_months_opt IN VARCHAR2,
1069 x_im_p_more_than_9_mth_op IN VARCHAR2,
1071 x_fnar_message_2 IN VARCHAR2,
1072 x_fnar_message_3 IN VARCHAR2,
1073 x_fnar_message_4 IN VARCHAR2,
1074 x_fnar_message_5 IN VARCHAR2,
1075 x_fnar_message_6 IN VARCHAR2,
1076 x_fnar_message_7 IN VARCHAR2,
1077 x_fnar_message_8 IN VARCHAR2,
1078 x_fnar_message_9 IN VARCHAR2,
1079 x_fnar_message_10 IN VARCHAR2,
1080 x_fnar_message_11 IN VARCHAR2,
1081 x_fnar_message_12 IN VARCHAR2,
1082 x_fnar_message_13 IN VARCHAR2,
1083 x_fnar_message_20 IN VARCHAR2,
1084 x_fnar_message_21 IN VARCHAR2,
1085 x_fnar_message_22 IN VARCHAR2,
1086 x_fnar_message_23 IN VARCHAR2,
1087 x_fnar_message_24 IN VARCHAR2,
1088 x_fnar_message_25 IN VARCHAR2,
1089 x_fnar_message_26 IN VARCHAR2,
1090 x_fnar_message_27 IN VARCHAR2,
1091 x_fnar_message_30 IN VARCHAR2,
1092 x_fnar_message_31 IN VARCHAR2,
1093 x_fnar_message_32 IN VARCHAR2,
1094 x_fnar_message_33 IN VARCHAR2,
1095 x_fnar_message_34 IN VARCHAR2,
1096 x_fnar_message_35 IN VARCHAR2,
1097 x_fnar_message_36 IN VARCHAR2,
1098 x_fnar_message_37 IN VARCHAR2,
1099 x_fnar_message_38 IN VARCHAR2,
1100 x_fnar_message_39 IN VARCHAR2,
1101 x_fnar_message_45 IN VARCHAR2,
1102 x_fnar_message_46 IN VARCHAR2,
1103 x_fnar_message_47 IN VARCHAR2,
1104 x_fnar_message_48 IN VARCHAR2,
1105 x_fnar_message_50 IN VARCHAR2,
1106 x_fnar_message_51 IN VARCHAR2,
1107 x_fnar_message_52 IN VARCHAR2,
1108 x_fnar_message_53 IN VARCHAR2,
1109 x_fnar_message_56 IN VARCHAR2,
1110 x_fnar_message_57 IN VARCHAR2,
1111 x_fnar_message_58 IN VARCHAR2,
1112 x_fnar_message_59 IN VARCHAR2,
1113 x_fnar_message_60 IN VARCHAR2,
1114 x_fnar_message_61 IN VARCHAR2,
1115 x_fnar_message_62 IN VARCHAR2,
1116 x_fnar_message_63 IN VARCHAR2,
1117 x_fnar_message_64 IN VARCHAR2,
1118 x_fnar_message_65 IN VARCHAR2,
1119 x_fnar_message_71 IN VARCHAR2,
1120 x_fnar_message_72 IN VARCHAR2,
1121 x_fnar_message_73 IN VARCHAR2,
1122 x_fnar_message_74 IN VARCHAR2,
1123 x_fnar_message_75 IN VARCHAR2,
1124 x_fnar_message_76 IN VARCHAR2,
1125 x_fnar_message_77 IN VARCHAR2,
1126 x_fnar_message_78 IN VARCHAR2,
1127 x_fnar_mesg_10_stu_fam_mem IN VARCHAR2,
1128 x_fnar_mesg_11_stu_no_in_coll IN VARCHAR2,
1129 x_fnar_mesg_24_stu_avail_inc IN VARCHAR2,
1130 x_fnar_mesg_26_stu_taxes IN VARCHAR2,
1131 x_fnar_mesg_33_stu_home_value IN VARCHAR2,
1132 x_fnar_mesg_34_stu_home_value IN VARCHAR2,
1133 x_fnar_mesg_34_stu_home_equity IN VARCHAR2,
1134 x_fnar_mesg_35_stu_home_value IN VARCHAR2,
1135 x_fnar_mesg_35_stu_home_equity IN VARCHAR2,
1136 x_fnar_mesg_36_stu_home_equity IN VARCHAR2,
1137 x_fnar_mesg_48_par_fam_mem IN VARCHAR2,
1138 x_fnar_mesg_49_par_no_in_coll IN VARCHAR2,
1139 x_fnar_mesg_56_par_agi IN VARCHAR2,
1140 x_fnar_mesg_62_par_taxes IN VARCHAR2,
1141 x_fnar_mesg_73_par_home_value IN VARCHAR2,
1142 x_fnar_mesg_74_par_home_value IN VARCHAR2,
1143 x_fnar_mesg_74_par_home_equity IN VARCHAR2,
1144 x_fnar_mesg_75_par_home_value IN VARCHAR2,
1145 x_fnar_mesg_75_par_home_equity IN VARCHAR2,
1146 x_fnar_mesg_76_par_home_equity IN VARCHAR2,
1147 x_assumption_message_1 IN VARCHAR2,
1148 x_assumption_message_2 IN VARCHAR2,
1149 x_assumption_message_3 IN VARCHAR2,
1150 x_assumption_message_4 IN VARCHAR2,
1151 x_assumption_message_5 IN VARCHAR2,
1152 x_assumption_message_6 IN VARCHAR2,
1153 x_record_mark IN VARCHAR2,
1154 x_mode IN VARCHAR2 DEFAULT 'R',
1155 x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
1156 x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
1157 x_opt_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
1158 x_opt_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
1159 x_opt_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
1163 x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
1160 x_opt_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
1161 x_opt_par_cola_adj_value IN NUMBER DEFAULT NULL,
1162 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
1164 x_cust_parent_cont_adj_num IN NUMBER DEFAULT NULL,
1165 x_custodial_parent_num IN NUMBER DEFAULT NULL,
1166 x_cust_par_base_prcnt_inc_amt IN NUMBER DEFAULT NULL,
1167 x_cust_par_base_cont_inc_amt IN NUMBER DEFAULT NULL,
1168 x_cust_par_base_cont_ast_amt IN NUMBER DEFAULT NULL,
1169 x_cust_par_base_tot_cont_amt IN NUMBER DEFAULT NULL,
1170 x_cust_par_opt_prcnt_inc_amt IN NUMBER DEFAULT NULL,
1171 x_cust_par_opt_cont_inc_amt IN NUMBER DEFAULT NULL,
1172 x_cust_par_opt_cont_ast_amt IN NUMBER DEFAULT NULL,
1173 x_cust_par_opt_tot_cont_amt IN NUMBER DEFAULT NULL,
1174 x_parents_email_txt IN VARCHAR2 DEFAULT NULL,
1175 x_parent_1_birth_date IN DATE DEFAULT NULL,
1176 x_parent_2_birth_date IN DATE DEFAULT NULL
1177 );
1178
1179 PROCEDURE add_row (
1180 x_rowid IN OUT NOCOPY VARCHAR2,
1181 x_fnar_id IN OUT NOCOPY NUMBER,
1182 x_cssp_id IN NUMBER,
1183 x_r_s_email_address IN VARCHAR2,
1184 x_eps_code IN VARCHAR2,
1185 x_comp_css_dependency_status IN VARCHAR2,
1186 x_stu_age IN VARCHAR2,
1187 x_assumed_stu_yr_in_coll IN VARCHAR2,
1188 x_comp_stu_marital_status IN VARCHAR2,
1189 x_stu_family_members IN NUMBER,
1190 x_stu_fam_members_in_college IN NUMBER,
1191 x_par_marital_status IN VARCHAR2,
1192 x_par_family_members IN NUMBER,
1193 x_par_total_in_college IN NUMBER,
1194 x_par_par_in_college IN NUMBER,
1195 x_par_others_in_college IN NUMBER,
1196 x_par_aesa IN NUMBER,
1197 x_par_cesa IN NUMBER,
1198 x_stu_aesa IN NUMBER,
1199 x_stu_cesa IN NUMBER,
1200 x_im_p_bas_agi_taxable_income IN NUMBER,
1201 x_im_p_bas_untx_inc_and_ben IN NUMBER,
1202 x_im_p_bas_inc_adj IN NUMBER,
1203 x_im_p_bas_total_income IN NUMBER,
1204 x_im_p_bas_us_income_tax IN NUMBER,
1205 x_im_p_bas_st_and_other_tax IN NUMBER,
1206 x_im_p_bas_fica_tax IN NUMBER,
1207 x_im_p_bas_med_dental IN NUMBER,
1208 x_im_p_bas_employment_allow IN NUMBER,
1209 x_im_p_bas_annual_ed_savings IN NUMBER,
1210 x_im_p_bas_inc_prot_allow_m IN NUMBER,
1211 x_im_p_bas_total_inc_allow IN NUMBER,
1212 x_im_p_bas_cal_avail_inc IN NUMBER,
1213 x_im_p_bas_avail_income IN NUMBER,
1214 x_im_p_bas_total_cont_inc IN NUMBER,
1215 x_im_p_bas_cash_bank_accounts IN NUMBER,
1216 x_im_p_bas_home_equity IN NUMBER,
1217 x_im_p_bas_ot_rl_est_inv_eq IN NUMBER,
1218 x_im_p_bas_adj_bus_farm_worth IN NUMBER,
1219 x_im_p_bas_ass_sibs_pre_tui IN NUMBER,
1220 x_im_p_bas_net_worth IN NUMBER,
1221 x_im_p_bas_emerg_res_allow IN NUMBER,
1222 x_im_p_bas_cum_ed_savings IN NUMBER,
1223 x_im_p_bas_low_inc_allow IN NUMBER,
1224 x_im_p_bas_total_asset_allow IN NUMBER,
1225 x_im_p_bas_disc_net_worth IN NUMBER,
1226 x_im_p_bas_total_cont_asset IN NUMBER,
1227 x_im_p_bas_total_cont IN NUMBER,
1228 x_im_p_bas_num_in_coll_adj IN NUMBER,
1229 x_im_p_bas_cont_for_stu IN NUMBER,
1230 x_im_p_bas_cont_from_income IN NUMBER,
1231 x_im_p_bas_cont_from_assets IN NUMBER,
1232 x_im_p_opt_agi_taxable_income IN NUMBER,
1233 x_im_p_opt_untx_inc_and_ben IN NUMBER,
1234 x_im_p_opt_inc_adj IN NUMBER,
1235 x_im_p_opt_total_income IN NUMBER,
1236 x_im_p_opt_us_income_tax IN NUMBER,
1237 x_im_p_opt_st_and_other_tax IN NUMBER,
1238 x_im_p_opt_fica_tax IN NUMBER,
1239 x_im_p_opt_med_dental IN NUMBER,
1240 x_im_p_opt_elem_sec_tuit IN NUMBER,
1241 x_im_p_opt_employment_allow IN NUMBER,
1242 x_im_p_opt_annual_ed_savings IN NUMBER,
1243 x_im_p_opt_inc_prot_allow_m IN NUMBER,
1244 x_im_p_opt_total_inc_allow IN NUMBER,
1245 x_im_p_opt_cal_avail_inc IN NUMBER,
1246 x_im_p_opt_avail_income IN NUMBER,
1247 x_im_p_opt_total_cont_inc IN NUMBER,
1248 x_im_p_opt_cash_bank_accounts IN NUMBER,
1249 x_im_p_opt_home_equity IN NUMBER,
1250 x_im_p_opt_ot_rl_est_inv_eq IN NUMBER,
1251 x_im_p_opt_adj_bus_farm_worth IN NUMBER,
1252 x_im_p_opt_ass_sibs_pre_tui IN NUMBER,
1253 x_im_p_opt_net_worth IN NUMBER,
1254 x_im_p_opt_emerg_res_allow IN NUMBER,
1258 x_im_p_opt_disc_net_worth IN NUMBER,
1255 x_im_p_opt_cum_ed_savings IN NUMBER,
1256 x_im_p_opt_low_inc_allow IN NUMBER,
1257 x_im_p_opt_total_asset_allow IN NUMBER,
1259 x_im_p_opt_total_cont_asset IN NUMBER,
1260 x_im_p_opt_total_cont IN NUMBER,
1261 x_im_p_opt_num_in_coll_adj IN NUMBER,
1262 x_im_p_opt_cont_for_stu IN NUMBER,
1263 x_im_p_opt_cont_from_income IN NUMBER,
1264 x_im_p_opt_cont_from_assets IN NUMBER,
1265 x_fm_p_analysis_type IN VARCHAR2,
1266 x_fm_p_agi_taxable_income IN NUMBER,
1267 x_fm_p_untx_inc_and_ben IN NUMBER,
1268 x_fm_p_inc_adj IN NUMBER,
1269 x_fm_p_total_income IN NUMBER,
1270 x_fm_p_us_income_tax IN NUMBER,
1271 x_fm_p_state_and_other_taxes IN NUMBER,
1272 x_fm_p_fica_tax IN NUMBER,
1273 x_fm_p_employment_allow IN NUMBER,
1274 x_fm_p_income_prot_allow IN NUMBER,
1275 x_fm_p_total_allow IN NUMBER,
1276 x_fm_p_avail_income IN NUMBER,
1277 x_fm_p_cash_bank_accounts IN NUMBER,
1278 x_fm_p_ot_rl_est_inv_equity IN NUMBER,
1279 x_fm_p_adj_bus_farm_net_worth IN NUMBER,
1280 x_fm_p_net_worth IN NUMBER,
1281 x_fm_p_asset_prot_allow IN NUMBER,
1282 x_fm_p_disc_net_worth IN NUMBER,
1283 x_fm_p_total_contribution IN NUMBER,
1284 x_fm_p_num_in_coll IN NUMBER,
1285 x_fm_p_cont_for_stu IN NUMBER,
1286 x_fm_p_cont_from_income IN NUMBER,
1287 x_fm_p_cont_from_assets IN NUMBER,
1288 x_im_s_bas_agi_taxable_income IN NUMBER,
1289 x_im_s_bas_untx_inc_and_ben IN NUMBER,
1290 x_im_s_bas_inc_adj IN NUMBER,
1291 x_im_s_bas_total_income IN NUMBER,
1292 x_im_s_bas_us_income_tax IN NUMBER,
1293 x_im_s_bas_state_and_oth_taxes IN NUMBER,
1294 x_im_s_bas_fica_tax IN NUMBER,
1295 x_im_s_bas_med_dental IN NUMBER,
1296 x_im_s_bas_employment_allow IN NUMBER,
1297 x_im_s_bas_annual_ed_savings IN NUMBER,
1298 x_im_s_bas_inc_prot_allow_m IN NUMBER,
1299 x_im_s_bas_total_inc_allow IN NUMBER,
1300 x_im_s_bas_cal_avail_income IN NUMBER,
1301 x_im_s_bas_avail_income IN NUMBER,
1302 x_im_s_bas_total_cont_inc IN NUMBER,
1303 x_im_s_bas_cash_bank_accounts IN NUMBER,
1304 x_im_s_bas_home_equity IN NUMBER,
1305 x_im_s_bas_ot_rl_est_inv_eq IN NUMBER,
1306 x_im_s_bas_adj_busfarm_worth IN NUMBER,
1307 x_im_s_bas_trusts IN NUMBER,
1308 x_im_s_bas_net_worth IN NUMBER,
1309 x_im_s_bas_emerg_res_allow IN NUMBER,
1310 x_im_s_bas_cum_ed_savings IN NUMBER,
1311 x_im_s_bas_total_asset_allow IN NUMBER,
1312 x_im_s_bas_disc_net_worth IN NUMBER,
1313 x_im_s_bas_total_cont_asset IN NUMBER,
1314 x_im_s_bas_total_cont IN NUMBER,
1315 x_im_s_bas_num_in_coll_adj IN NUMBER,
1316 x_im_s_bas_cont_for_stu IN NUMBER,
1317 x_im_s_bas_cont_from_income IN NUMBER,
1318 x_im_s_bas_cont_from_assets IN NUMBER,
1319 x_im_s_est_agitaxable_income IN NUMBER,
1320 x_im_s_est_untx_inc_and_ben IN NUMBER,
1321 x_im_s_est_inc_adj IN NUMBER,
1322 x_im_s_est_total_income IN NUMBER,
1323 x_im_s_est_us_income_tax IN NUMBER,
1324 x_im_s_est_state_and_oth_taxes IN NUMBER,
1325 x_im_s_est_fica_tax IN NUMBER,
1326 x_im_s_est_med_dental IN NUMBER,
1327 x_im_s_est_employment_allow IN NUMBER,
1328 x_im_s_est_annual_ed_savings IN NUMBER,
1329 x_im_s_est_inc_prot_allow_m IN NUMBER,
1330 x_im_s_est_total_inc_allow IN NUMBER,
1331 x_im_s_est_cal_avail_income IN NUMBER,
1332 x_im_s_est_avail_income IN NUMBER,
1333 x_im_s_est_total_cont_inc IN NUMBER,
1334 x_im_s_est_cash_bank_accounts IN NUMBER,
1335 x_im_s_est_home_equity IN NUMBER,
1336 x_im_s_est_ot_rl_est_inv_eq IN NUMBER,
1337 x_im_s_est_adj_bus_farm_worth IN NUMBER,
1338 x_im_s_est_est_trusts IN NUMBER,
1339 x_im_s_est_net_worth IN NUMBER,
1340 x_im_s_est_emerg_res_allow IN NUMBER,
1341 x_im_s_est_cum_ed_savings IN NUMBER,
1342 x_im_s_est_total_asset_allow IN NUMBER,
1343 x_im_s_est_disc_net_worth IN NUMBER,
1344 x_im_s_est_total_cont_asset IN NUMBER,
1345 x_im_s_est_total_cont IN NUMBER,
1346 x_im_s_est_num_in_coll_adj IN NUMBER,
1347 x_im_s_est_cont_for_stu IN NUMBER,
1348 x_im_s_est_cont_from_income IN NUMBER,
1349 x_im_s_est_cont_from_assets IN NUMBER,
1350 x_im_s_opt_agi_taxable_income IN NUMBER,
1351 x_im_s_opt_untx_inc_and_ben IN NUMBER,
1352 x_im_s_opt_inc_adj IN NUMBER,
1356 x_im_s_opt_fica_tax IN NUMBER,
1353 x_im_s_opt_total_income IN NUMBER,
1354 x_im_s_opt_us_income_tax IN NUMBER,
1355 x_im_s_opt_state_and_oth_taxes IN NUMBER,
1357 x_im_s_opt_med_dental IN NUMBER,
1358 x_im_s_opt_employment_allow IN NUMBER,
1359 x_im_s_opt_annual_ed_savings IN NUMBER,
1360 x_im_s_opt_inc_prot_allow_m IN NUMBER,
1361 x_im_s_opt_total_inc_allow IN NUMBER,
1362 x_im_s_opt_cal_avail_income IN NUMBER,
1363 x_im_s_opt_avail_income IN NUMBER,
1364 x_im_s_opt_total_cont_inc IN NUMBER,
1365 x_im_s_opt_cash_bank_accounts IN NUMBER,
1366 x_im_s_opt_ira_keogh_accounts IN NUMBER,
1367 x_im_s_opt_home_equity IN NUMBER,
1368 x_im_s_opt_ot_rl_est_inv_eq IN NUMBER,
1369 x_im_s_opt_adj_bus_farm_worth IN NUMBER,
1370 x_im_s_opt_trusts IN NUMBER,
1371 x_im_s_opt_net_worth IN NUMBER,
1372 x_im_s_opt_emerg_res_allow IN NUMBER,
1373 x_im_s_opt_cum_ed_savings IN NUMBER,
1374 x_im_s_opt_total_asset_allow IN NUMBER,
1375 x_im_s_opt_disc_net_worth IN NUMBER,
1376 x_im_s_opt_total_cont_asset IN NUMBER,
1377 x_im_s_opt_total_cont IN NUMBER,
1378 x_im_s_opt_num_in_coll_adj IN NUMBER,
1379 x_im_s_opt_cont_for_stu IN NUMBER,
1380 x_im_s_opt_cont_from_income IN NUMBER,
1381 x_im_s_opt_cont_from_assets IN NUMBER,
1382 x_fm_s_analysis_type IN VARCHAR2,
1383 x_fm_s_agi_taxable_income IN NUMBER,
1384 x_fm_s_untx_inc_and_ben IN NUMBER,
1385 x_fm_s_inc_adj IN NUMBER,
1386 x_fm_s_total_income IN NUMBER,
1387 x_fm_s_us_income_tax IN NUMBER,
1388 x_fm_s_state_and_oth_taxes IN NUMBER,
1389 x_fm_s_fica_tax IN NUMBER,
1390 x_fm_s_employment_allow IN NUMBER,
1391 x_fm_s_income_prot_allow IN NUMBER,
1392 x_fm_s_total_allow IN NUMBER,
1393 x_fm_s_cal_avail_income IN NUMBER,
1394 x_fm_s_avail_income IN NUMBER,
1395 x_fm_s_cash_bank_accounts IN NUMBER,
1396 x_fm_s_ot_rl_est_inv_equity IN NUMBER,
1397 x_fm_s_adj_bus_farm_worth IN NUMBER,
1398 x_fm_s_trusts IN NUMBER,
1399 x_fm_s_net_worth IN NUMBER,
1400 x_fm_s_asset_prot_allow IN NUMBER,
1401 x_fm_s_disc_net_worth IN NUMBER,
1402 x_fm_s_total_cont IN NUMBER,
1403 x_fm_s_num_in_coll IN NUMBER,
1404 x_fm_s_cont_for_stu IN NUMBER,
1405 x_fm_s_cont_from_income IN NUMBER,
1406 x_fm_s_cont_from_assets IN NUMBER,
1407 x_im_inst_resident_ind IN VARCHAR2,
1408 x_institutional_1_budget_name IN VARCHAR2,
1409 x_im_inst_1_budget_duration IN NUMBER,
1410 x_im_inst_1_tuition_fees IN NUMBER,
1411 x_im_inst_1_books_supplies IN NUMBER,
1412 x_im_inst_1_living_expenses IN NUMBER,
1413 x_im_inst_1_tot_expenses IN NUMBER,
1414 x_im_inst_1_tot_stu_cont IN NUMBER,
1415 x_im_inst_1_tot_par_cont IN NUMBER,
1416 x_im_inst_1_tot_family_cont IN NUMBER,
1417 x_im_inst_1_va_benefits IN NUMBER,
1418 x_im_inst_1_ot_cont IN NUMBER,
1419 x_im_inst_1_est_financial_need IN NUMBER,
1420 x_institutional_2_budget_name IN VARCHAR2,
1421 x_im_inst_2_budget_duration IN VARCHAR2,
1422 x_im_inst_2_tuition_fees IN NUMBER,
1423 x_im_inst_2_books_supplies IN NUMBER,
1424 x_im_inst_2_living_expenses IN NUMBER,
1425 x_im_inst_2_tot_expenses IN NUMBER,
1426 x_im_inst_2_tot_stu_cont IN NUMBER,
1427 x_im_inst_2_tot_par_cont IN NUMBER,
1428 x_im_inst_2_tot_family_cont IN NUMBER,
1429 x_im_inst_2_va_benefits IN NUMBER,
1430 x_im_inst_2_est_financial_need IN NUMBER,
1431 x_institutional_3_budget_name IN VARCHAR2,
1432 x_im_inst_3_budget_duration IN NUMBER,
1433 x_im_inst_3_tuition_fees IN NUMBER,
1434 x_im_inst_3_books_supplies IN NUMBER,
1435 x_im_inst_3_living_expenses IN NUMBER,
1436 x_im_inst_3_tot_expenses IN NUMBER,
1437 x_im_inst_3_tot_stu_cont IN NUMBER,
1438 x_im_inst_3_tot_par_cont IN NUMBER,
1439 x_im_inst_3_tot_family_cont IN NUMBER,
1440 x_im_inst_3_va_benefits IN NUMBER,
1441 x_im_inst_3_est_financial_need IN NUMBER,
1442 x_fm_inst_1_federal_efc IN VARCHAR2,
1443 x_fm_inst_1_va_benefits IN VARCHAR2,
1444 x_fm_inst_1_fed_eligibility IN VARCHAR2,
1445 x_fm_inst_1_pell IN VARCHAR2,
1446 x_option_par_loss_allow_ind IN VARCHAR2,
1447 x_option_par_tuition_ind IN VARCHAR2,
1448 x_option_par_home_ind IN VARCHAR2,
1449 x_option_par_home_value IN VARCHAR2,
1453 x_option_stu_home_value IN VARCHAR2,
1450 x_option_par_home_debt IN VARCHAR2,
1451 x_option_stu_ira_keogh_ind IN VARCHAR2,
1452 x_option_stu_home_ind IN VARCHAR2,
1454 x_option_stu_home_debt IN VARCHAR2,
1455 x_option_stu_sum_ay_inc_ind IN VARCHAR2,
1456 x_option_par_hope_ll_credit IN VARCHAR2,
1457 x_option_stu_hope_ll_credit IN VARCHAR2,
1458 x_im_parent_1_8_months_bas IN VARCHAR2,
1459 x_im_p_more_than_9_mth_ba IN VARCHAR2,
1460 x_im_parent_1_8_months_opt IN VARCHAR2,
1461 x_im_p_more_than_9_mth_op IN VARCHAR2,
1462 x_fnar_message_1 IN VARCHAR2,
1463 x_fnar_message_2 IN VARCHAR2,
1464 x_fnar_message_3 IN VARCHAR2,
1465 x_fnar_message_4 IN VARCHAR2,
1466 x_fnar_message_5 IN VARCHAR2,
1467 x_fnar_message_6 IN VARCHAR2,
1468 x_fnar_message_7 IN VARCHAR2,
1469 x_fnar_message_8 IN VARCHAR2,
1470 x_fnar_message_9 IN VARCHAR2,
1471 x_fnar_message_10 IN VARCHAR2,
1472 x_fnar_message_11 IN VARCHAR2,
1473 x_fnar_message_12 IN VARCHAR2,
1474 x_fnar_message_13 IN VARCHAR2,
1475 x_fnar_message_20 IN VARCHAR2,
1476 x_fnar_message_21 IN VARCHAR2,
1477 x_fnar_message_22 IN VARCHAR2,
1478 x_fnar_message_23 IN VARCHAR2,
1479 x_fnar_message_24 IN VARCHAR2,
1480 x_fnar_message_25 IN VARCHAR2,
1481 x_fnar_message_26 IN VARCHAR2,
1482 x_fnar_message_27 IN VARCHAR2,
1483 x_fnar_message_30 IN VARCHAR2,
1484 x_fnar_message_31 IN VARCHAR2,
1485 x_fnar_message_32 IN VARCHAR2,
1486 x_fnar_message_33 IN VARCHAR2,
1487 x_fnar_message_34 IN VARCHAR2,
1488 x_fnar_message_35 IN VARCHAR2,
1489 x_fnar_message_36 IN VARCHAR2,
1490 x_fnar_message_37 IN VARCHAR2,
1491 x_fnar_message_38 IN VARCHAR2,
1492 x_fnar_message_39 IN VARCHAR2,
1493 x_fnar_message_45 IN VARCHAR2,
1494 x_fnar_message_46 IN VARCHAR2,
1495 x_fnar_message_47 IN VARCHAR2,
1496 x_fnar_message_48 IN VARCHAR2,
1497 x_fnar_message_50 IN VARCHAR2,
1498 x_fnar_message_51 IN VARCHAR2,
1499 x_fnar_message_52 IN VARCHAR2,
1500 x_fnar_message_53 IN VARCHAR2,
1501 x_fnar_message_56 IN VARCHAR2,
1502 x_fnar_message_57 IN VARCHAR2,
1503 x_fnar_message_58 IN VARCHAR2,
1504 x_fnar_message_59 IN VARCHAR2,
1505 x_fnar_message_60 IN VARCHAR2,
1506 x_fnar_message_61 IN VARCHAR2,
1507 x_fnar_message_62 IN VARCHAR2,
1508 x_fnar_message_63 IN VARCHAR2,
1509 x_fnar_message_64 IN VARCHAR2,
1510 x_fnar_message_65 IN VARCHAR2,
1511 x_fnar_message_71 IN VARCHAR2,
1512 x_fnar_message_72 IN VARCHAR2,
1513 x_fnar_message_73 IN VARCHAR2,
1514 x_fnar_message_74 IN VARCHAR2,
1515 x_fnar_message_75 IN VARCHAR2,
1516 x_fnar_message_76 IN VARCHAR2,
1517 x_fnar_message_77 IN VARCHAR2,
1518 x_fnar_message_78 IN VARCHAR2,
1519 x_fnar_mesg_10_stu_fam_mem IN VARCHAR2,
1520 x_fnar_mesg_11_stu_no_in_coll IN VARCHAR2,
1521 x_fnar_mesg_24_stu_avail_inc IN VARCHAR2,
1522 x_fnar_mesg_26_stu_taxes IN VARCHAR2,
1523 x_fnar_mesg_33_stu_home_value IN VARCHAR2,
1524 x_fnar_mesg_34_stu_home_value IN VARCHAR2,
1525 x_fnar_mesg_34_stu_home_equity IN VARCHAR2,
1526 x_fnar_mesg_35_stu_home_value IN VARCHAR2,
1527 x_fnar_mesg_35_stu_home_equity IN VARCHAR2,
1528 x_fnar_mesg_36_stu_home_equity IN VARCHAR2,
1529 x_fnar_mesg_48_par_fam_mem IN VARCHAR2,
1530 x_fnar_mesg_49_par_no_in_coll IN VARCHAR2,
1531 x_fnar_mesg_56_par_agi IN VARCHAR2,
1532 x_fnar_mesg_62_par_taxes IN VARCHAR2,
1533 x_fnar_mesg_73_par_home_value IN VARCHAR2,
1534 x_fnar_mesg_74_par_home_value IN VARCHAR2,
1535 x_fnar_mesg_74_par_home_equity IN VARCHAR2,
1536 x_fnar_mesg_75_par_home_value IN VARCHAR2,
1537 x_fnar_mesg_75_par_home_equity IN VARCHAR2,
1538 x_fnar_mesg_76_par_home_equity IN VARCHAR2,
1539 x_assumption_message_1 IN VARCHAR2,
1540 x_assumption_message_2 IN VARCHAR2,
1541 x_assumption_message_3 IN VARCHAR2,
1542 x_assumption_message_4 IN VARCHAR2,
1543 x_assumption_message_5 IN VARCHAR2,
1544 x_assumption_message_6 IN VARCHAR2,
1548 x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
1545 x_record_mark IN VARCHAR2,
1546 x_mode IN VARCHAR2 DEFAULT 'R',
1547 x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
1549 x_opt_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
1550 x_opt_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
1551 x_opt_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
1552 x_opt_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
1553 x_opt_par_cola_adj_value IN NUMBER DEFAULT NULL,
1554 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
1555 x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
1556 x_cust_parent_cont_adj_num IN NUMBER DEFAULT NULL,
1557 x_custodial_parent_num IN NUMBER DEFAULT NULL,
1558 x_cust_par_base_prcnt_inc_amt IN NUMBER DEFAULT NULL,
1559 x_cust_par_base_cont_inc_amt IN NUMBER DEFAULT NULL,
1560 x_cust_par_base_cont_ast_amt IN NUMBER DEFAULT NULL,
1561 x_cust_par_base_tot_cont_amt IN NUMBER DEFAULT NULL,
1562 x_cust_par_opt_prcnt_inc_amt IN NUMBER DEFAULT NULL,
1563 x_cust_par_opt_cont_inc_amt IN NUMBER DEFAULT NULL,
1564 x_cust_par_opt_cont_ast_amt IN NUMBER DEFAULT NULL,
1565 x_cust_par_opt_tot_cont_amt IN NUMBER DEFAULT NULL,
1566 x_parents_email_txt IN VARCHAR2 DEFAULT NULL,
1567 x_parent_1_birth_date IN DATE DEFAULT NULL,
1568 x_parent_2_birth_date IN DATE DEFAULT NULL
1569 );
1570
1571 PROCEDURE delete_row (
1572 x_rowid IN VARCHAR2
1573 );
1574
1575 FUNCTION get_pk_for_validation (
1576 x_fnar_id IN NUMBER
1577 ) RETURN BOOLEAN;
1578
1579 PROCEDURE get_fk_igf_ap_css_profile_all (
1580 x_cssp_id IN NUMBER
1581 );
1582
1583 PROCEDURE before_dml (
1584 p_action IN VARCHAR2,
1585 x_rowid IN VARCHAR2 DEFAULT NULL,
1586 x_fnar_id IN NUMBER DEFAULT NULL,
1587 x_cssp_id IN NUMBER DEFAULT NULL,
1588 x_r_s_email_address IN VARCHAR2 DEFAULT NULL,
1589 x_eps_code IN VARCHAR2 DEFAULT NULL,
1590 x_comp_css_dependency_status IN VARCHAR2 DEFAULT NULL,
1591 x_stu_age IN VARCHAR2 DEFAULT NULL,
1592 x_assumed_stu_yr_in_coll IN VARCHAR2 DEFAULT NULL,
1593 x_comp_stu_marital_status IN VARCHAR2 DEFAULT NULL,
1594 x_stu_family_members IN NUMBER DEFAULT NULL,
1595 x_stu_fam_members_in_college IN NUMBER DEFAULT NULL,
1596 x_par_marital_status IN VARCHAR2 DEFAULT NULL,
1597 x_par_family_members IN NUMBER DEFAULT NULL,
1598 x_par_total_in_college IN NUMBER DEFAULT NULL,
1599 x_par_par_in_college IN NUMBER DEFAULT NULL,
1600 x_par_others_in_college IN NUMBER DEFAULT NULL,
1601 x_par_aesa IN NUMBER DEFAULT NULL,
1602 x_par_cesa IN NUMBER DEFAULT NULL,
1603 x_stu_aesa IN NUMBER DEFAULT NULL,
1604 x_stu_cesa IN NUMBER DEFAULT NULL,
1605 x_im_p_bas_agi_taxable_income IN NUMBER DEFAULT NULL,
1606 x_im_p_bas_untx_inc_and_ben IN NUMBER DEFAULT NULL,
1607 x_im_p_bas_inc_adj IN NUMBER DEFAULT NULL,
1608 x_im_p_bas_total_income IN NUMBER DEFAULT NULL,
1609 x_im_p_bas_us_income_tax IN NUMBER DEFAULT NULL,
1610 x_im_p_bas_st_and_other_tax IN NUMBER DEFAULT NULL,
1611 x_im_p_bas_fica_tax IN NUMBER DEFAULT NULL,
1612 x_im_p_bas_med_dental IN NUMBER DEFAULT NULL,
1613 x_im_p_bas_employment_allow IN NUMBER DEFAULT NULL,
1614 x_im_p_bas_annual_ed_savings IN NUMBER DEFAULT NULL,
1615 x_im_p_bas_inc_prot_allow_m IN NUMBER DEFAULT NULL,
1616 x_im_p_bas_total_inc_allow IN NUMBER DEFAULT NULL,
1617 x_im_p_bas_cal_avail_inc IN NUMBER DEFAULT NULL,
1618 x_im_p_bas_avail_income IN NUMBER DEFAULT NULL,
1619 x_im_p_bas_total_cont_inc IN NUMBER DEFAULT NULL,
1620 x_im_p_bas_cash_bank_accounts IN NUMBER DEFAULT NULL,
1621 x_im_p_bas_home_equity IN NUMBER DEFAULT NULL,
1622 x_im_p_bas_ot_rl_est_inv_eq IN NUMBER DEFAULT NULL,
1623 x_im_p_bas_adj_bus_farm_worth IN NUMBER DEFAULT NULL,
1624 x_im_p_bas_ass_sibs_pre_tui IN NUMBER DEFAULT NULL,
1625 x_im_p_bas_net_worth IN NUMBER DEFAULT NULL,
1626 x_im_p_bas_emerg_res_allow IN NUMBER DEFAULT NULL,
1627 x_im_p_bas_cum_ed_savings IN NUMBER DEFAULT NULL,
1628 x_im_p_bas_low_inc_allow IN NUMBER DEFAULT NULL,
1629 x_im_p_bas_total_asset_allow IN NUMBER DEFAULT NULL,
1630 x_im_p_bas_disc_net_worth IN NUMBER DEFAULT NULL,
1631 x_im_p_bas_total_cont_asset IN NUMBER DEFAULT NULL,
1635 x_im_p_bas_cont_from_income IN NUMBER DEFAULT NULL,
1632 x_im_p_bas_total_cont IN NUMBER DEFAULT NULL,
1633 x_im_p_bas_num_in_coll_adj IN NUMBER DEFAULT NULL,
1634 x_im_p_bas_cont_for_stu IN NUMBER DEFAULT NULL,
1636 x_im_p_bas_cont_from_assets IN NUMBER DEFAULT NULL,
1637 x_im_p_opt_agi_taxable_income IN NUMBER DEFAULT NULL,
1638 x_im_p_opt_untx_inc_and_ben IN NUMBER DEFAULT NULL,
1639 x_im_p_opt_inc_adj IN NUMBER DEFAULT NULL,
1640 x_im_p_opt_total_income IN NUMBER DEFAULT NULL,
1641 x_im_p_opt_us_income_tax IN NUMBER DEFAULT NULL,
1642 x_im_p_opt_st_and_other_tax IN NUMBER DEFAULT NULL,
1643 x_im_p_opt_fica_tax IN NUMBER DEFAULT NULL,
1644 x_im_p_opt_med_dental IN NUMBER DEFAULT NULL,
1645 x_im_p_opt_elem_sec_tuit IN NUMBER DEFAULT NULL,
1646 x_im_p_opt_employment_allow IN NUMBER DEFAULT NULL,
1647 x_im_p_opt_annual_ed_savings IN NUMBER DEFAULT NULL,
1648 x_im_p_opt_inc_prot_allow_m IN NUMBER DEFAULT NULL,
1649 x_im_p_opt_total_inc_allow IN NUMBER DEFAULT NULL,
1650 x_im_p_opt_cal_avail_inc IN NUMBER DEFAULT NULL,
1651 x_im_p_opt_avail_income IN NUMBER DEFAULT NULL,
1652 x_im_p_opt_total_cont_inc IN NUMBER DEFAULT NULL,
1653 x_im_p_opt_cash_bank_accounts IN NUMBER DEFAULT NULL,
1654 x_im_p_opt_home_equity IN NUMBER DEFAULT NULL,
1655 x_im_p_opt_ot_rl_est_inv_eq IN NUMBER DEFAULT NULL,
1656 x_im_p_opt_adj_bus_farm_worth IN NUMBER DEFAULT NULL,
1657 x_im_p_opt_ass_sibs_pre_tui IN NUMBER DEFAULT NULL,
1658 x_im_p_opt_net_worth IN NUMBER DEFAULT NULL,
1659 x_im_p_opt_emerg_res_allow IN NUMBER DEFAULT NULL,
1660 x_im_p_opt_cum_ed_savings IN NUMBER DEFAULT NULL,
1661 x_im_p_opt_low_inc_allow IN NUMBER DEFAULT NULL,
1662 x_im_p_opt_total_asset_allow IN NUMBER DEFAULT NULL,
1663 x_im_p_opt_disc_net_worth IN NUMBER DEFAULT NULL,
1664 x_im_p_opt_total_cont_asset IN NUMBER DEFAULT NULL,
1665 x_im_p_opt_total_cont IN NUMBER DEFAULT NULL,
1666 x_im_p_opt_num_in_coll_adj IN NUMBER DEFAULT NULL,
1667 x_im_p_opt_cont_for_stu IN NUMBER DEFAULT NULL,
1668 x_im_p_opt_cont_from_income IN NUMBER DEFAULT NULL,
1669 x_im_p_opt_cont_from_assets IN NUMBER DEFAULT NULL,
1670 x_fm_p_analysis_type IN VARCHAR2 DEFAULT NULL,
1671 x_fm_p_agi_taxable_income IN NUMBER DEFAULT NULL,
1672 x_fm_p_untx_inc_and_ben IN NUMBER DEFAULT NULL,
1673 x_fm_p_inc_adj IN NUMBER DEFAULT NULL,
1674 x_fm_p_total_income IN NUMBER DEFAULT NULL,
1675 x_fm_p_us_income_tax IN NUMBER DEFAULT NULL,
1676 x_fm_p_state_and_other_taxes IN NUMBER DEFAULT NULL,
1677 x_fm_p_fica_tax IN NUMBER DEFAULT NULL,
1678 x_fm_p_employment_allow IN NUMBER DEFAULT NULL,
1679 x_fm_p_income_prot_allow IN NUMBER DEFAULT NULL,
1680 x_fm_p_total_allow IN NUMBER DEFAULT NULL,
1681 x_fm_p_avail_income IN NUMBER DEFAULT NULL,
1682 x_fm_p_cash_bank_accounts IN NUMBER DEFAULT NULL,
1683 x_fm_p_ot_rl_est_inv_equity IN NUMBER DEFAULT NULL,
1684 x_fm_p_adj_bus_farm_net_worth IN NUMBER DEFAULT NULL,
1685 x_fm_p_net_worth IN NUMBER DEFAULT NULL,
1686 x_fm_p_asset_prot_allow IN NUMBER DEFAULT NULL,
1687 x_fm_p_disc_net_worth IN NUMBER DEFAULT NULL,
1688 x_fm_p_total_contribution IN NUMBER DEFAULT NULL,
1689 x_fm_p_num_in_coll IN NUMBER DEFAULT NULL,
1690 x_fm_p_cont_for_stu IN NUMBER DEFAULT NULL,
1691 x_fm_p_cont_from_income IN NUMBER DEFAULT NULL,
1692 x_fm_p_cont_from_assets IN NUMBER DEFAULT NULL,
1693 x_im_s_bas_agi_taxable_income IN NUMBER DEFAULT NULL,
1694 x_im_s_bas_untx_inc_and_ben IN NUMBER DEFAULT NULL,
1695 x_im_s_bas_inc_adj IN NUMBER DEFAULT NULL,
1696 x_im_s_bas_total_income IN NUMBER DEFAULT NULL,
1697 x_im_s_bas_us_income_tax IN NUMBER DEFAULT NULL,
1698 x_im_s_bas_state_and_oth_taxes IN NUMBER DEFAULT NULL,
1699 x_im_s_bas_fica_tax IN NUMBER DEFAULT NULL,
1700 x_im_s_bas_med_dental IN NUMBER DEFAULT NULL,
1701 x_im_s_bas_employment_allow IN NUMBER DEFAULT NULL,
1702 x_im_s_bas_annual_ed_savings IN NUMBER DEFAULT NULL,
1703 x_im_s_bas_inc_prot_allow_m IN NUMBER DEFAULT NULL,
1704 x_im_s_bas_total_inc_allow IN NUMBER DEFAULT NULL,
1705 x_im_s_bas_cal_avail_income IN NUMBER DEFAULT NULL,
1706 x_im_s_bas_avail_income IN NUMBER DEFAULT NULL,
1707 x_im_s_bas_total_cont_inc IN NUMBER DEFAULT NULL,
1708 x_im_s_bas_cash_bank_accounts IN NUMBER DEFAULT NULL,
1709 x_im_s_bas_home_equity IN NUMBER DEFAULT NULL,
1713 x_im_s_bas_net_worth IN NUMBER DEFAULT NULL,
1710 x_im_s_bas_ot_rl_est_inv_eq IN NUMBER DEFAULT NULL,
1711 x_im_s_bas_adj_busfarm_worth IN NUMBER DEFAULT NULL,
1712 x_im_s_bas_trusts IN NUMBER DEFAULT NULL,
1714 x_im_s_bas_emerg_res_allow IN NUMBER DEFAULT NULL,
1715 x_im_s_bas_cum_ed_savings IN NUMBER DEFAULT NULL,
1716 x_im_s_bas_total_asset_allow IN NUMBER DEFAULT NULL,
1717 x_im_s_bas_disc_net_worth IN NUMBER DEFAULT NULL,
1718 x_im_s_bas_total_cont_asset IN NUMBER DEFAULT NULL,
1719 x_im_s_bas_total_cont IN NUMBER DEFAULT NULL,
1720 x_im_s_bas_num_in_coll_adj IN NUMBER DEFAULT NULL,
1721 x_im_s_bas_cont_for_stu IN NUMBER DEFAULT NULL,
1722 x_im_s_bas_cont_from_income IN NUMBER DEFAULT NULL,
1723 x_im_s_bas_cont_from_assets IN NUMBER DEFAULT NULL,
1724 x_im_s_est_agitaxable_income IN NUMBER DEFAULT NULL,
1725 x_im_s_est_untx_inc_and_ben IN NUMBER DEFAULT NULL,
1726 x_im_s_est_inc_adj IN NUMBER DEFAULT NULL,
1727 x_im_s_est_total_income IN NUMBER DEFAULT NULL,
1728 x_im_s_est_us_income_tax IN NUMBER DEFAULT NULL,
1729 x_im_s_est_state_and_oth_taxes IN NUMBER DEFAULT NULL,
1730 x_im_s_est_fica_tax IN NUMBER DEFAULT NULL,
1731 x_im_s_est_med_dental IN NUMBER DEFAULT NULL,
1732 x_im_s_est_employment_allow IN NUMBER DEFAULT NULL,
1733 x_im_s_est_annual_ed_savings IN NUMBER DEFAULT NULL,
1734 x_im_s_est_inc_prot_allow_m IN NUMBER DEFAULT NULL,
1735 x_im_s_est_total_inc_allow IN NUMBER DEFAULT NULL,
1736 x_im_s_est_cal_avail_income IN NUMBER DEFAULT NULL,
1737 x_im_s_est_avail_income IN NUMBER DEFAULT NULL,
1738 x_im_s_est_total_cont_inc IN NUMBER DEFAULT NULL,
1739 x_im_s_est_cash_bank_accounts IN NUMBER DEFAULT NULL,
1740 x_im_s_est_home_equity IN NUMBER DEFAULT NULL,
1741 x_im_s_est_ot_rl_est_inv_eq IN NUMBER DEFAULT NULL,
1742 x_im_s_est_adj_bus_farm_worth IN NUMBER DEFAULT NULL,
1743 x_im_s_est_est_trusts IN NUMBER DEFAULT NULL,
1744 x_im_s_est_net_worth IN NUMBER DEFAULT NULL,
1745 x_im_s_est_emerg_res_allow IN NUMBER DEFAULT NULL,
1746 x_im_s_est_cum_ed_savings IN NUMBER DEFAULT NULL,
1747 x_im_s_est_total_asset_allow IN NUMBER DEFAULT NULL,
1748 x_im_s_est_disc_net_worth IN NUMBER DEFAULT NULL,
1749 x_im_s_est_total_cont_asset IN NUMBER DEFAULT NULL,
1750 x_im_s_est_total_cont IN NUMBER DEFAULT NULL,
1751 x_im_s_est_num_in_coll_adj IN NUMBER DEFAULT NULL,
1752 x_im_s_est_cont_for_stu IN NUMBER DEFAULT NULL,
1753 x_im_s_est_cont_from_income IN NUMBER DEFAULT NULL,
1754 x_im_s_est_cont_from_assets IN NUMBER DEFAULT NULL,
1755 x_im_s_opt_agi_taxable_income IN NUMBER DEFAULT NULL,
1756 x_im_s_opt_untx_inc_and_ben IN NUMBER DEFAULT NULL,
1757 x_im_s_opt_inc_adj IN NUMBER DEFAULT NULL,
1758 x_im_s_opt_total_income IN NUMBER DEFAULT NULL,
1759 x_im_s_opt_us_income_tax IN NUMBER DEFAULT NULL,
1760 x_im_s_opt_state_and_oth_taxes IN NUMBER DEFAULT NULL,
1761 x_im_s_opt_fica_tax IN NUMBER DEFAULT NULL,
1762 x_im_s_opt_med_dental IN NUMBER DEFAULT NULL,
1763 x_im_s_opt_employment_allow IN NUMBER DEFAULT NULL,
1764 x_im_s_opt_annual_ed_savings IN NUMBER DEFAULT NULL,
1765 x_im_s_opt_inc_prot_allow_m IN NUMBER DEFAULT NULL,
1766 x_im_s_opt_total_inc_allow IN NUMBER DEFAULT NULL,
1767 x_im_s_opt_cal_avail_income IN NUMBER DEFAULT NULL,
1768 x_im_s_opt_avail_income IN NUMBER DEFAULT NULL,
1769 x_im_s_opt_total_cont_inc IN NUMBER DEFAULT NULL,
1770 x_im_s_opt_cash_bank_accounts IN NUMBER DEFAULT NULL,
1771 x_im_s_opt_ira_keogh_accounts IN NUMBER DEFAULT NULL,
1772 x_im_s_opt_home_equity IN NUMBER DEFAULT NULL,
1773 x_im_s_opt_ot_rl_est_inv_eq IN NUMBER DEFAULT NULL,
1774 x_im_s_opt_adj_bus_farm_worth IN NUMBER DEFAULT NULL,
1775 x_im_s_opt_trusts IN NUMBER DEFAULT NULL,
1776 x_im_s_opt_net_worth IN NUMBER DEFAULT NULL,
1777 x_im_s_opt_emerg_res_allow IN NUMBER DEFAULT NULL,
1778 x_im_s_opt_cum_ed_savings IN NUMBER DEFAULT NULL,
1779 x_im_s_opt_total_asset_allow IN NUMBER DEFAULT NULL,
1780 x_im_s_opt_disc_net_worth IN NUMBER DEFAULT NULL,
1781 x_im_s_opt_total_cont_asset IN NUMBER DEFAULT NULL,
1782 x_im_s_opt_total_cont IN NUMBER DEFAULT NULL,
1783 x_im_s_opt_num_in_coll_adj IN NUMBER DEFAULT NULL,
1784 x_im_s_opt_cont_for_stu IN NUMBER DEFAULT NULL,
1785 x_im_s_opt_cont_from_income IN NUMBER DEFAULT NULL,
1786 x_im_s_opt_cont_from_assets IN NUMBER DEFAULT NULL,
1787 x_fm_s_analysis_type IN VARCHAR2 DEFAULT NULL,
1791 x_fm_s_total_income IN NUMBER DEFAULT NULL,
1788 x_fm_s_agi_taxable_income IN NUMBER DEFAULT NULL,
1789 x_fm_s_untx_inc_and_ben IN NUMBER DEFAULT NULL,
1790 x_fm_s_inc_adj IN NUMBER DEFAULT NULL,
1792 x_fm_s_us_income_tax IN NUMBER DEFAULT NULL,
1793 x_fm_s_state_and_oth_taxes IN NUMBER DEFAULT NULL,
1794 x_fm_s_fica_tax IN NUMBER DEFAULT NULL,
1795 x_fm_s_employment_allow IN NUMBER DEFAULT NULL,
1796 x_fm_s_income_prot_allow IN NUMBER DEFAULT NULL,
1797 x_fm_s_total_allow IN NUMBER DEFAULT NULL,
1798 x_fm_s_cal_avail_income IN NUMBER DEFAULT NULL,
1799 x_fm_s_avail_income IN NUMBER DEFAULT NULL,
1800 x_fm_s_cash_bank_accounts IN NUMBER DEFAULT NULL,
1801 x_fm_s_ot_rl_est_inv_equity IN NUMBER DEFAULT NULL,
1802 x_fm_s_adj_bus_farm_worth IN NUMBER DEFAULT NULL,
1803 x_fm_s_trusts IN NUMBER DEFAULT NULL,
1804 x_fm_s_net_worth IN NUMBER DEFAULT NULL,
1805 x_fm_s_asset_prot_allow IN NUMBER DEFAULT NULL,
1806 x_fm_s_disc_net_worth IN NUMBER DEFAULT NULL,
1807 x_fm_s_total_cont IN NUMBER DEFAULT NULL,
1808 x_fm_s_num_in_coll IN NUMBER DEFAULT NULL,
1809 x_fm_s_cont_for_stu IN NUMBER DEFAULT NULL,
1810 x_fm_s_cont_from_income IN NUMBER DEFAULT NULL,
1811 x_fm_s_cont_from_assets IN NUMBER DEFAULT NULL,
1812 x_im_inst_resident_ind IN VARCHAR2 DEFAULT NULL,
1813 x_institutional_1_budget_name IN VARCHAR2 DEFAULT NULL,
1814 x_im_inst_1_budget_duration IN NUMBER DEFAULT NULL,
1815 x_im_inst_1_tuition_fees IN NUMBER DEFAULT NULL,
1816 x_im_inst_1_books_supplies IN NUMBER DEFAULT NULL,
1817 x_im_inst_1_living_expenses IN NUMBER DEFAULT NULL,
1818 x_im_inst_1_tot_expenses IN NUMBER DEFAULT NULL,
1819 x_im_inst_1_tot_stu_cont IN NUMBER DEFAULT NULL,
1820 x_im_inst_1_tot_par_cont IN NUMBER DEFAULT NULL,
1821 x_im_inst_1_tot_family_cont IN NUMBER DEFAULT NULL,
1822 x_im_inst_1_va_benefits IN NUMBER DEFAULT NULL,
1823 x_im_inst_1_ot_cont IN NUMBER DEFAULT NULL,
1824 x_im_inst_1_est_financial_need IN NUMBER DEFAULT NULL,
1825 x_institutional_2_budget_name IN VARCHAR2 DEFAULT NULL,
1826 x_im_inst_2_budget_duration IN VARCHAR2 DEFAULT NULL,
1827 x_im_inst_2_tuition_fees IN NUMBER DEFAULT NULL,
1828 x_im_inst_2_books_supplies IN NUMBER DEFAULT NULL,
1832 x_im_inst_2_tot_par_cont IN NUMBER DEFAULT NULL,
1829 x_im_inst_2_living_expenses IN NUMBER DEFAULT NULL,
1830 x_im_inst_2_tot_expenses IN NUMBER DEFAULT NULL,
1831 x_im_inst_2_tot_stu_cont IN NUMBER DEFAULT NULL,
1833 x_im_inst_2_tot_family_cont IN NUMBER DEFAULT NULL,
1834 x_im_inst_2_va_benefits IN NUMBER DEFAULT NULL,
1835 x_im_inst_2_est_financial_need IN NUMBER DEFAULT NULL,
1836 x_institutional_3_budget_name IN VARCHAR2 DEFAULT NULL,
1837 x_im_inst_3_budget_duration IN NUMBER DEFAULT NULL,
1838 x_im_inst_3_tuition_fees IN NUMBER DEFAULT NULL,
1839 x_im_inst_3_books_supplies IN NUMBER DEFAULT NULL,
1840 x_im_inst_3_living_expenses IN NUMBER DEFAULT NULL,
1841 x_im_inst_3_tot_expenses IN NUMBER DEFAULT NULL,
1842 x_im_inst_3_tot_stu_cont IN NUMBER DEFAULT NULL,
1843 x_im_inst_3_tot_par_cont IN NUMBER DEFAULT NULL,
1844 x_im_inst_3_tot_family_cont IN NUMBER DEFAULT NULL,
1845 x_im_inst_3_va_benefits IN NUMBER DEFAULT NULL,
1846 x_im_inst_3_est_financial_need IN NUMBER DEFAULT NULL,
1847 x_fm_inst_1_federal_efc IN VARCHAR2 DEFAULT NULL,
1848 x_fm_inst_1_va_benefits IN VARCHAR2 DEFAULT NULL,
1849 x_fm_inst_1_fed_eligibility IN VARCHAR2 DEFAULT NULL,
1850 x_fm_inst_1_pell IN VARCHAR2 DEFAULT NULL,
1851 x_option_par_loss_allow_ind IN VARCHAR2 DEFAULT NULL,
1852 x_option_par_tuition_ind IN VARCHAR2 DEFAULT NULL,
1853 x_option_par_home_ind IN VARCHAR2 DEFAULT NULL,
1854 x_option_par_home_value IN VARCHAR2 DEFAULT NULL,
1855 x_option_par_home_debt IN VARCHAR2 DEFAULT NULL,
1856 x_option_stu_ira_keogh_ind IN VARCHAR2 DEFAULT NULL,
1857 x_option_stu_home_ind IN VARCHAR2 DEFAULT NULL,
1858 x_option_stu_home_value IN VARCHAR2 DEFAULT NULL,
1859 x_option_stu_home_debt IN VARCHAR2 DEFAULT NULL,
1860 x_option_stu_sum_ay_inc_ind IN VARCHAR2 DEFAULT NULL,
1861 x_option_par_hope_ll_credit IN VARCHAR2 DEFAULT NULL,
1862 x_option_stu_hope_ll_credit IN VARCHAR2 DEFAULT NULL,
1863 x_im_parent_1_8_months_bas IN VARCHAR2 DEFAULT NULL,
1864 x_im_p_more_than_9_mth_ba IN VARCHAR2 DEFAULT NULL,
1865 x_im_parent_1_8_months_opt IN VARCHAR2 DEFAULT NULL,
1866 x_im_p_more_than_9_mth_op IN VARCHAR2 DEFAULT NULL,
1867 x_fnar_message_1 IN VARCHAR2 DEFAULT NULL,
1868 x_fnar_message_2 IN VARCHAR2 DEFAULT NULL,
1869 x_fnar_message_3 IN VARCHAR2 DEFAULT NULL,
1870 x_fnar_message_4 IN VARCHAR2 DEFAULT NULL,
1871 x_fnar_message_5 IN VARCHAR2 DEFAULT NULL,
1872 x_fnar_message_6 IN VARCHAR2 DEFAULT NULL,
1873 x_fnar_message_7 IN VARCHAR2 DEFAULT NULL,
1874 x_fnar_message_8 IN VARCHAR2 DEFAULT NULL,
1875 x_fnar_message_9 IN VARCHAR2 DEFAULT NULL,
1876 x_fnar_message_10 IN VARCHAR2 DEFAULT NULL,
1877 x_fnar_message_11 IN VARCHAR2 DEFAULT NULL,
1878 x_fnar_message_12 IN VARCHAR2 DEFAULT NULL,
1879 x_fnar_message_13 IN VARCHAR2 DEFAULT NULL,
1880 x_fnar_message_20 IN VARCHAR2 DEFAULT NULL,
1881 x_fnar_message_21 IN VARCHAR2 DEFAULT NULL,
1882 x_fnar_message_22 IN VARCHAR2 DEFAULT NULL,
1883 x_fnar_message_23 IN VARCHAR2 DEFAULT NULL,
1884 x_fnar_message_24 IN VARCHAR2 DEFAULT NULL,
1885 x_fnar_message_25 IN VARCHAR2 DEFAULT NULL,
1886 x_fnar_message_26 IN VARCHAR2 DEFAULT NULL,
1887 x_fnar_message_27 IN VARCHAR2 DEFAULT NULL,
1888 x_fnar_message_30 IN VARCHAR2 DEFAULT NULL,
1889 x_fnar_message_31 IN VARCHAR2 DEFAULT NULL,
1890 x_fnar_message_32 IN VARCHAR2 DEFAULT NULL,
1891 x_fnar_message_33 IN VARCHAR2 DEFAULT NULL,
1892 x_fnar_message_34 IN VARCHAR2 DEFAULT NULL,
1893 x_fnar_message_35 IN VARCHAR2 DEFAULT NULL,
1894 x_fnar_message_36 IN VARCHAR2 DEFAULT NULL,
1895 x_fnar_message_37 IN VARCHAR2 DEFAULT NULL,
1896 x_fnar_message_38 IN VARCHAR2 DEFAULT NULL,
1897 x_fnar_message_39 IN VARCHAR2 DEFAULT NULL,
1898 x_fnar_message_45 IN VARCHAR2 DEFAULT NULL,
1899 x_fnar_message_46 IN VARCHAR2 DEFAULT NULL,
1900 x_fnar_message_47 IN VARCHAR2 DEFAULT NULL,
1901 x_fnar_message_48 IN VARCHAR2 DEFAULT NULL,
1902 x_fnar_message_50 IN VARCHAR2 DEFAULT NULL,
1903 x_fnar_message_51 IN VARCHAR2 DEFAULT NULL,
1904 x_fnar_message_52 IN VARCHAR2 DEFAULT NULL,
1905 x_fnar_message_53 IN VARCHAR2 DEFAULT NULL,
1906 x_fnar_message_56 IN VARCHAR2 DEFAULT NULL,
1907 x_fnar_message_57 IN VARCHAR2 DEFAULT NULL,
1908 x_fnar_message_58 IN VARCHAR2 DEFAULT NULL,
1909 x_fnar_message_59 IN VARCHAR2 DEFAULT NULL,
1910 x_fnar_message_60 IN VARCHAR2 DEFAULT NULL,
1911 x_fnar_message_61 IN VARCHAR2 DEFAULT NULL,
1912 x_fnar_message_62 IN VARCHAR2 DEFAULT NULL,
1913 x_fnar_message_63 IN VARCHAR2 DEFAULT NULL,
1914 x_fnar_message_64 IN VARCHAR2 DEFAULT NULL,
1915 x_fnar_message_65 IN VARCHAR2 DEFAULT NULL,
1916 x_fnar_message_71 IN VARCHAR2 DEFAULT NULL,
1917 x_fnar_message_72 IN VARCHAR2 DEFAULT NULL,
1918 x_fnar_message_73 IN VARCHAR2 DEFAULT NULL,
1919 x_fnar_message_74 IN VARCHAR2 DEFAULT NULL,
1920 x_fnar_message_75 IN VARCHAR2 DEFAULT NULL,
1921 x_fnar_message_76 IN VARCHAR2 DEFAULT NULL,
1922 x_fnar_message_77 IN VARCHAR2 DEFAULT NULL,
1923 x_fnar_message_78 IN VARCHAR2 DEFAULT NULL,
1924 x_fnar_mesg_10_stu_fam_mem IN VARCHAR2 DEFAULT NULL,
1925 x_fnar_mesg_11_stu_no_in_coll IN VARCHAR2 DEFAULT NULL,
1926 x_fnar_mesg_24_stu_avail_inc IN VARCHAR2 DEFAULT NULL,
1927 x_fnar_mesg_26_stu_taxes IN VARCHAR2 DEFAULT NULL,
1928 x_fnar_mesg_33_stu_home_value IN VARCHAR2 DEFAULT NULL,
1929 x_fnar_mesg_34_stu_home_value IN VARCHAR2 DEFAULT NULL,
1930 x_fnar_mesg_34_stu_home_equity IN VARCHAR2 DEFAULT NULL,
1931 x_fnar_mesg_35_stu_home_value IN VARCHAR2 DEFAULT NULL,
1932 x_fnar_mesg_35_stu_home_equity IN VARCHAR2 DEFAULT NULL,
1933 x_fnar_mesg_36_stu_home_equity IN VARCHAR2 DEFAULT NULL,
1934 x_fnar_mesg_48_par_fam_mem IN VARCHAR2 DEFAULT NULL,
1935 x_fnar_mesg_49_par_no_in_coll IN VARCHAR2 DEFAULT NULL,
1936 x_fnar_mesg_56_par_agi IN VARCHAR2 DEFAULT NULL,
1937 x_fnar_mesg_62_par_taxes IN VARCHAR2 DEFAULT NULL,
1938 x_fnar_mesg_73_par_home_value IN VARCHAR2 DEFAULT NULL,
1939 x_fnar_mesg_74_par_home_value IN VARCHAR2 DEFAULT NULL,
1940 x_fnar_mesg_74_par_home_equity IN VARCHAR2 DEFAULT NULL,
1941 x_fnar_mesg_75_par_home_value IN VARCHAR2 DEFAULT NULL,
1942 x_fnar_mesg_75_par_home_equity IN VARCHAR2 DEFAULT NULL,
1943 x_fnar_mesg_76_par_home_equity IN VARCHAR2 DEFAULT NULL,
1944 x_assumption_message_1 IN VARCHAR2 DEFAULT NULL,
1945 x_assumption_message_2 IN VARCHAR2 DEFAULT NULL,
1946 x_assumption_message_3 IN VARCHAR2 DEFAULT NULL,
1947 x_assumption_message_4 IN VARCHAR2 DEFAULT NULL,
1948 x_assumption_message_5 IN VARCHAR2 DEFAULT NULL,
1949 x_assumption_message_6 IN VARCHAR2 DEFAULT NULL,
1950 x_record_mark IN VARCHAR2 DEFAULT NULL,
1951 x_creation_date IN DATE DEFAULT NULL,
1952 x_created_by IN NUMBER DEFAULT NULL,
1953 x_last_update_date IN DATE DEFAULT NULL,
1954 x_last_updated_by IN NUMBER DEFAULT NULL,
1955 x_last_update_login IN NUMBER DEFAULT NULL,
1956 x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
1957 x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
1958 x_opt_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
1959 x_opt_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
1960 x_opt_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
1961 x_opt_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
1962 x_opt_par_cola_adj_value IN NUMBER DEFAULT NULL,
1963 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
1964 x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
1965 x_cust_parent_cont_adj_num IN NUMBER DEFAULT NULL,
1966 x_custodial_parent_num IN NUMBER DEFAULT NULL,
1967 x_cust_par_base_prcnt_inc_amt IN NUMBER DEFAULT NULL,
1968 x_cust_par_base_cont_inc_amt IN NUMBER DEFAULT NULL,
1969 x_cust_par_base_cont_ast_amt IN NUMBER DEFAULT NULL,
1970 x_cust_par_base_tot_cont_amt IN NUMBER DEFAULT NULL,
1971 x_cust_par_opt_prcnt_inc_amt IN NUMBER DEFAULT NULL,
1972 x_cust_par_opt_cont_inc_amt IN NUMBER DEFAULT NULL,
1973 x_cust_par_opt_cont_ast_amt IN NUMBER DEFAULT NULL,
1974 x_cust_par_opt_tot_cont_amt IN NUMBER DEFAULT NULL,
1975 x_parents_email_txt IN VARCHAR2 DEFAULT NULL,
1976 x_parent_1_birth_date IN DATE DEFAULT NULL,
1977 x_parent_2_birth_date IN DATE DEFAULT NULL
1978 );
1979
1980 END igf_ap_css_fnar_pkg;
[Home] [Help]