1 PACKAGE igf_ap_cs_upd_flags_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGFAI34S.pls 115.3 2002/11/28 13:59:11 nsidana ship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_base_id IN OUT NOCOPY NUMBER,
7 x_last_name IN VARCHAR2,
8 x_first_name IN VARCHAR2,
9 x_middle_initial IN VARCHAR2,
10 x_address_number_and_street IN VARCHAR2,
11 x_city IN VARCHAR2,
12 x_state_mailing IN VARCHAR2,
13 x_zip_code IN VARCHAR2,
14 x_s_telephone_number IN VARCHAR2,
15 x_s_title IN VARCHAR2,
16 x_date_of_birth IN VARCHAR2,
17 x_social_security_number IN VARCHAR2,
18 x_state_legal_residence IN VARCHAR2,
19 x_foreign_address_indicator IN VARCHAR2,
20 x_foreign_postal_code IN VARCHAR2,
21 x_country IN VARCHAR2,
22 x_financial_aid_status IN VARCHAR2,
23 x_year_in_college IN VARCHAR2,
24 x_marital_status IN VARCHAR2,
25 x_ward_court IN VARCHAR2,
26 x_legal_dependents_other IN VARCHAR2,
27 x_household_size IN VARCHAR2,
28 x_number_in_college IN VARCHAR2,
29 x_citizenship_status IN VARCHAR2,
30 x_citizenship_country IN VARCHAR2,
31 x_visa_classification IN VARCHAR2,
32 x_tax_figures IN VARCHAR2,
33 x_number_exemptions IN VARCHAR2,
34 x_adjusted_gross_inc IN VARCHAR2,
35 x_us_tax_paid IN VARCHAR2,
36 x_itemized_deductions IN VARCHAR2,
37 x_stu_income_work IN VARCHAR2,
38 x_spouse_income_work IN VARCHAR2,
39 x_divid_int_inc IN VARCHAR2,
40 x_soc_sec_benefits IN VARCHAR2,
41 x_welfare_tanf IN VARCHAR2,
42 x_child_supp_rcvd IN VARCHAR2,
43 x_earned_income_credit IN VARCHAR2,
44 x_other_untax_income IN VARCHAR2,
45 x_tax_stu_aid IN VARCHAR2,
46 x_cash_sav_check IN VARCHAR2,
47 x_ira_keogh IN VARCHAR2,
48 x_invest_value IN VARCHAR2,
49 x_invest_debt IN VARCHAR2,
50 x_home_value IN VARCHAR2,
51 x_home_debt IN VARCHAR2,
52 x_oth_real_value IN VARCHAR2,
53 x_oth_real_debt IN VARCHAR2,
54 x_bus_farm_value IN VARCHAR2,
55 x_bus_farm_debt IN VARCHAR2,
56 x_live_on_farm IN VARCHAR2,
57 x_home_purch_price IN VARCHAR2,
58 x_hope_ll_credit IN VARCHAR2,
59 x_home_purch_year IN VARCHAR2,
60 x_trust_amount IN VARCHAR2,
61 x_trust_avail IN VARCHAR2,
62 x_trust_estab IN VARCHAR2,
63 x_child_support_paid IN VARCHAR2,
64 x_med_dent_expenses IN VARCHAR2,
65 x_vet_us IN VARCHAR2,
66 x_vet_ben_amount IN VARCHAR2,
67 x_vet_ben_months IN VARCHAR2,
68 x_stu_summer_wages IN VARCHAR2,
69 x_stu_school_yr_wages IN VARCHAR2,
70 x_spouse_summer_wages IN VARCHAR2,
71 x_spouse_school_yr_wages IN VARCHAR2,
72 x_summer_other_tax_inc IN VARCHAR2,
73 x_school_yr_other_tax_inc IN VARCHAR2,
74 x_summer_untax_inc IN VARCHAR2,
75 x_school_yr_untax_inc IN VARCHAR2,
76 x_grants_schol_etc IN VARCHAR2,
77 x_tuit_benefits IN VARCHAR2,
78 x_cont_parents IN VARCHAR2,
79 x_cont_relatives IN VARCHAR2,
80 x_p_siblings_pre_tuit IN VARCHAR2,
81 x_p_student_pre_tuit IN VARCHAR2,
82 x_p_household_size IN VARCHAR2,
83 x_p_number_in_college IN VARCHAR2,
84 x_p_parents_in_college IN VARCHAR2,
85 x_p_marital_status IN VARCHAR2,
86 x_p_state_legal_residence IN VARCHAR2,
87 x_p_natural_par_status IN VARCHAR2,
88 x_p_child_supp_paid IN VARCHAR2,
89 x_p_repay_ed_loans IN VARCHAR2,
90 x_p_med_dent_expenses IN VARCHAR2,
91 x_p_tuit_paid_amount IN VARCHAR2,
92 x_p_tuit_paid_number IN VARCHAR2,
93 x_p_exp_child_supp_paid IN VARCHAR2,
94 x_p_exp_repay_ed_loans IN VARCHAR2,
95 x_p_exp_med_dent_expenses IN VARCHAR2,
96 x_p_exp_tuit_pd_amount IN VARCHAR2,
97 x_p_exp_tuit_pd_number IN VARCHAR2,
98 x_p_cash_sav_check IN VARCHAR2,
99 x_p_month_mortgage_pay IN VARCHAR2,
100 x_p_invest_value IN VARCHAR2,
101 x_p_invest_debt IN VARCHAR2,
102 x_p_home_value IN VARCHAR2,
103 x_p_home_debt IN VARCHAR2,
104 x_p_home_purch_price IN VARCHAR2,
105 x_p_own_business_farm IN VARCHAR2,
106 x_p_business_value IN VARCHAR2,
107 x_p_business_debt IN VARCHAR2,
108 x_p_farm_value IN VARCHAR2,
109 x_p_farm_debt IN VARCHAR2,
110 x_p_live_on_farm IN VARCHAR2,
111 x_p_oth_real_estate_value IN VARCHAR2,
112 x_p_oth_real_estate_debt IN VARCHAR2,
113 x_p_oth_real_purch_price IN VARCHAR2,
114 x_p_siblings_assets IN VARCHAR2,
115 x_p_home_purch_year IN VARCHAR2,
116 x_p_oth_real_purch_year IN VARCHAR2,
117 x_p_prior_agi IN VARCHAR2,
118 x_p_prior_us_tax_paid IN VARCHAR2,
119 x_p_prior_item_deductions IN VARCHAR2,
120 x_p_prior_other_untax_inc IN VARCHAR2,
121 x_p_tax_figures IN VARCHAR2,
122 x_p_number_exemptions IN VARCHAR2,
123 x_p_adjusted_gross_inc IN VARCHAR2,
124 x_p_wages_sal_tips IN VARCHAR2,
125 x_p_interest_income IN VARCHAR2,
126 x_p_dividend_income IN VARCHAR2,
127 x_p_net_inc_bus_farm IN VARCHAR2,
128 x_p_other_taxable_income IN VARCHAR2,
129 x_p_adj_to_income IN VARCHAR2,
130 x_p_us_tax_paid IN VARCHAR2,
131 x_p_itemized_deductions IN VARCHAR2,
132 x_p_father_income_work IN VARCHAR2,
133 x_p_mother_income_work IN VARCHAR2,
134 x_p_soc_sec_ben IN VARCHAR2,
135 x_p_welfare_tanf IN VARCHAR2,
136 x_p_child_supp_rcvd IN VARCHAR2,
137 x_p_ded_ira_keogh IN VARCHAR2,
138 x_p_tax_defer_pens_savs IN VARCHAR2,
139 x_p_dep_care_med_spending IN VARCHAR2,
140 x_p_earned_income_credit IN VARCHAR2,
141 x_p_living_allow IN VARCHAR2,
142 x_p_tax_exmpt_int IN VARCHAR2,
143 x_p_foreign_inc_excl IN VARCHAR2,
144 x_p_other_untax_inc IN VARCHAR2,
145 x_p_hope_ll_credit IN VARCHAR2,
146 x_p_yr_separation IN VARCHAR2,
147 x_p_yr_divorce IN VARCHAR2,
148 x_p_exp_father_inc IN VARCHAR2,
149 x_p_exp_mother_inc IN VARCHAR2,
150 x_p_exp_other_tax_inc IN VARCHAR2,
151 x_p_exp_other_untax_inc IN VARCHAR2,
152 x_line_2_relation IN VARCHAR2,
153 x_line_2_attend_college IN VARCHAR2,
154 x_line_3_relation IN VARCHAR2,
155 x_line_3_attend_college IN VARCHAR2,
156 x_line_4_relation IN VARCHAR2,
157 x_line_4_attend_college IN VARCHAR2,
158 x_line_5_relation IN VARCHAR2,
159 x_line_5_attend_college IN VARCHAR2,
160 x_line_6_relation IN VARCHAR2,
161 x_line_6_attend_college IN VARCHAR2,
162 x_line_7_relation IN VARCHAR2,
163 x_line_7_attend_college IN VARCHAR2,
164 x_line_8_relation IN VARCHAR2,
165 x_line_8_attend_college IN VARCHAR2,
166 x_p_age_father IN VARCHAR2,
167 x_p_age_mother IN VARCHAR2,
168 x_p_div_sep_ind IN VARCHAR2,
169 x_b_cont_non_custodial_par IN VARCHAR2,
170 x_college_type_2 IN VARCHAR2,
171 x_college_type_3 IN VARCHAR2,
172 x_college_type_4 IN VARCHAR2,
173 x_college_type_5 IN VARCHAR2,
174 x_college_type_6 IN VARCHAR2,
175 x_college_type_7 IN VARCHAR2,
176 x_college_type_8 IN VARCHAR2,
177 x_school_code_1 IN VARCHAR2,
178 x_housing_code_1 IN VARCHAR2,
179 x_school_code_2 IN VARCHAR2,
180 x_housing_code_2 IN VARCHAR2,
181 x_school_code_3 IN VARCHAR2,
182 x_housing_code_3 IN VARCHAR2,
183 x_school_code_4 IN VARCHAR2,
184 x_housing_code_4 IN VARCHAR2,
185 x_school_code_5 IN VARCHAR2,
186 x_housing_code_5 IN VARCHAR2,
187 x_school_code_6 IN VARCHAR2,
188 x_housing_code_6 IN VARCHAR2,
189 x_school_code_7 IN VARCHAR2,
190 x_housing_code_7 IN VARCHAR2,
191 x_school_code_8 IN VARCHAR2,
192 x_housing_code_8 IN VARCHAR2,
193 x_school_code_9 IN VARCHAR2,
194 x_housing_code_9 IN VARCHAR2,
195 x_school_code_10 IN VARCHAR2,
196 x_housing_code_10 IN VARCHAR2,
197 x_additional_school_code_1 IN VARCHAR2,
198 x_additional_school_code_2 IN VARCHAR2,
199 x_additional_school_code_3 IN VARCHAR2,
200 x_additional_school_code_4 IN VARCHAR2,
201 x_additional_school_code_5 IN VARCHAR2,
202 x_additional_school_code_6 IN VARCHAR2,
203 x_additional_school_code_7 IN VARCHAR2,
204 x_additional_school_code_8 IN VARCHAR2,
205 x_additional_school_code_9 IN VARCHAR2,
206 x_additional_school_code_10 IN VARCHAR2,
207 x_explanation_spec_circum IN VARCHAR2,
208 x_signature_student IN VARCHAR2,
209 x_signature_spouse IN VARCHAR2,
210 x_signature_father IN VARCHAR2,
211 x_signature_mother IN VARCHAR2,
212 x_month_day_completed IN VARCHAR2,
213 x_year_completed IN VARCHAR2,
214 x_age_line_2 IN VARCHAR2,
215 x_age_line_3 IN VARCHAR2,
216 x_age_line_4 IN VARCHAR2,
217 x_age_line_5 IN VARCHAR2,
218 x_age_line_6 IN VARCHAR2,
219 x_age_line_7 IN VARCHAR2,
220 x_age_line_8 IN VARCHAR2,
221 x_a_online_signature IN VARCHAR2,
222 x_question_1_number IN VARCHAR2,
223 x_question_1_size IN VARCHAR2,
224 x_question_1_answer IN VARCHAR2,
225 x_question_2_number IN VARCHAR2,
226 x_question_2_size IN VARCHAR2,
227 x_question_2_answer IN VARCHAR2,
228 x_question_3_number IN VARCHAR2,
229 x_question_3_size IN VARCHAR2,
230 x_question_3_answer IN VARCHAR2,
231 x_question_4_number IN VARCHAR2,
232 x_question_4_size IN VARCHAR2,
233 x_question_4_answer IN VARCHAR2,
234 x_question_5_number IN VARCHAR2,
235 x_question_5_size IN VARCHAR2,
236 x_question_5_answer IN VARCHAR2,
237 x_question_6_number IN VARCHAR2,
238 x_question_6_size IN VARCHAR2,
239 x_question_6_answer IN VARCHAR2,
240 x_question_7_number IN VARCHAR2,
241 x_question_7_size IN VARCHAR2,
242 x_question_7_answer IN VARCHAR2,
243 x_question_8_number IN VARCHAR2,
244 x_question_8_size IN VARCHAR2,
245 x_question_8_answer IN VARCHAR2,
246 x_question_9_number IN VARCHAR2,
247 x_question_9_size IN VARCHAR2,
248 x_question_9_answer IN VARCHAR2,
249 x_question_10_number IN VARCHAR2,
250 x_question_10_size IN VARCHAR2,
251 x_question_10_answer IN VARCHAR2,
252 x_question_11_number IN VARCHAR2,
253 x_question_11_size IN VARCHAR2,
254 x_question_11_answer IN VARCHAR2,
255 x_question_12_number IN VARCHAR2,
256 x_question_12_size IN VARCHAR2,
257 x_question_12_answer IN VARCHAR2,
258 x_question_13_number IN VARCHAR2,
259 x_question_13_size IN VARCHAR2,
260 x_question_13_answer IN VARCHAR2,
261 x_question_14_number IN VARCHAR2,
262 x_question_14_size IN VARCHAR2,
263 x_question_14_answer IN VARCHAR2,
264 x_question_15_number IN VARCHAR2,
265 x_question_15_size IN VARCHAR2,
266 x_question_15_answer IN VARCHAR2,
267 x_question_16_number IN VARCHAR2,
268 x_question_16_size IN VARCHAR2,
269 x_question_16_answer IN VARCHAR2,
270 x_question_17_number IN VARCHAR2,
274 x_question_18_size IN VARCHAR2,
271 x_question_17_size IN VARCHAR2,
272 x_question_17_answer IN VARCHAR2,
273 x_question_18_number IN VARCHAR2,
275 x_question_18_answer IN VARCHAR2,
276 x_question_19_number IN VARCHAR2,
277 x_question_19_size IN VARCHAR2,
278 x_question_19_answer IN VARCHAR2,
279 x_question_20_number IN VARCHAR2,
280 x_question_20_size IN VARCHAR2,
281 x_question_20_answer IN VARCHAR2,
282 x_question_21_number IN VARCHAR2,
283 x_question_21_size IN VARCHAR2,
284 x_question_21_answer IN VARCHAR2,
285 x_question_22_number IN VARCHAR2,
286 x_question_22_size IN VARCHAR2,
287 x_question_22_answer IN VARCHAR2,
288 x_question_23_number IN VARCHAR2,
289 x_question_23_size IN VARCHAR2,
290 x_question_23_answer IN VARCHAR2,
291 x_question_24_number IN VARCHAR2,
292 x_question_24_size IN VARCHAR2,
293 x_question_24_answer IN VARCHAR2,
294 x_question_25_number IN VARCHAR2,
295 x_question_25_size IN VARCHAR2,
296 x_question_25_answer IN VARCHAR2,
297 x_question_26_number IN VARCHAR2,
298 x_question_26_size IN VARCHAR2,
299 x_question_26_answer IN VARCHAR2,
300 x_question_27_number IN VARCHAR2,
301 x_question_27_size IN VARCHAR2,
302 x_question_27_answer IN VARCHAR2,
303 x_question_28_number IN VARCHAR2,
304 x_question_28_size IN VARCHAR2,
305 x_question_28_answer IN VARCHAR2,
306 x_question_29_number IN VARCHAR2,
307 x_question_29_size IN VARCHAR2,
308 x_question_29_answer IN VARCHAR2,
309 x_question_30_number IN VARCHAR2,
310 x_questions_30_size IN VARCHAR2,
311 x_question_30_answer IN VARCHAR2,
312 x_mode IN VARCHAR2 DEFAULT 'R'
313 );
314
315 PROCEDURE lock_row (
316 x_rowid IN VARCHAR2,
317 x_base_id IN NUMBER,
318 x_last_name IN VARCHAR2,
319 x_first_name IN VARCHAR2,
320 x_middle_initial IN VARCHAR2,
321 x_address_number_and_street IN VARCHAR2,
322 x_city IN VARCHAR2,
323 x_state_mailing IN VARCHAR2,
324 x_zip_code IN VARCHAR2,
325 x_s_telephone_number IN VARCHAR2,
326 x_s_title IN VARCHAR2,
327 x_date_of_birth IN VARCHAR2,
328 x_social_security_number IN VARCHAR2,
329 x_state_legal_residence IN VARCHAR2,
330 x_foreign_address_indicator IN VARCHAR2,
331 x_foreign_postal_code IN VARCHAR2,
332 x_country IN VARCHAR2,
333 x_financial_aid_status IN VARCHAR2,
334 x_year_in_college IN VARCHAR2,
335 x_marital_status IN VARCHAR2,
336 x_ward_court IN VARCHAR2,
337 x_legal_dependents_other IN VARCHAR2,
338 x_household_size IN VARCHAR2,
339 x_number_in_college IN VARCHAR2,
340 x_citizenship_status IN VARCHAR2,
341 x_citizenship_country IN VARCHAR2,
342 x_visa_classification IN VARCHAR2,
343 x_tax_figures IN VARCHAR2,
344 x_number_exemptions IN VARCHAR2,
345 x_adjusted_gross_inc IN VARCHAR2,
346 x_us_tax_paid IN VARCHAR2,
347 x_itemized_deductions IN VARCHAR2,
348 x_stu_income_work IN VARCHAR2,
349 x_spouse_income_work IN VARCHAR2,
350 x_divid_int_inc IN VARCHAR2,
351 x_soc_sec_benefits IN VARCHAR2,
352 x_welfare_tanf IN VARCHAR2,
353 x_child_supp_rcvd IN VARCHAR2,
354 x_earned_income_credit IN VARCHAR2,
355 x_other_untax_income IN VARCHAR2,
356 x_tax_stu_aid IN VARCHAR2,
357 x_cash_sav_check IN VARCHAR2,
361 x_home_value IN VARCHAR2,
358 x_ira_keogh IN VARCHAR2,
359 x_invest_value IN VARCHAR2,
360 x_invest_debt IN VARCHAR2,
362 x_home_debt IN VARCHAR2,
363 x_oth_real_value IN VARCHAR2,
364 x_oth_real_debt IN VARCHAR2,
365 x_bus_farm_value IN VARCHAR2,
366 x_bus_farm_debt IN VARCHAR2,
367 x_live_on_farm IN VARCHAR2,
368 x_home_purch_price IN VARCHAR2,
369 x_hope_ll_credit IN VARCHAR2,
370 x_home_purch_year IN VARCHAR2,
371 x_trust_amount IN VARCHAR2,
372 x_trust_avail IN VARCHAR2,
373 x_trust_estab IN VARCHAR2,
374 x_child_support_paid IN VARCHAR2,
375 x_med_dent_expenses IN VARCHAR2,
376 x_vet_us IN VARCHAR2,
377 x_vet_ben_amount IN VARCHAR2,
378 x_vet_ben_months IN VARCHAR2,
379 x_stu_summer_wages IN VARCHAR2,
380 x_stu_school_yr_wages IN VARCHAR2,
381 x_spouse_summer_wages IN VARCHAR2,
382 x_spouse_school_yr_wages IN VARCHAR2,
383 x_summer_other_tax_inc IN VARCHAR2,
384 x_school_yr_other_tax_inc IN VARCHAR2,
385 x_summer_untax_inc IN VARCHAR2,
386 x_school_yr_untax_inc IN VARCHAR2,
387 x_grants_schol_etc IN VARCHAR2,
388 x_tuit_benefits IN VARCHAR2,
389 x_cont_parents IN VARCHAR2,
390 x_cont_relatives IN VARCHAR2,
391 x_p_siblings_pre_tuit IN VARCHAR2,
392 x_p_student_pre_tuit IN VARCHAR2,
393 x_p_household_size IN VARCHAR2,
394 x_p_number_in_college IN VARCHAR2,
395 x_p_parents_in_college IN VARCHAR2,
396 x_p_marital_status IN VARCHAR2,
397 x_p_state_legal_residence IN VARCHAR2,
398 x_p_natural_par_status IN VARCHAR2,
399 x_p_child_supp_paid IN VARCHAR2,
400 x_p_repay_ed_loans IN VARCHAR2,
401 x_p_med_dent_expenses IN VARCHAR2,
402 x_p_tuit_paid_amount IN VARCHAR2,
403 x_p_tuit_paid_number IN VARCHAR2,
404 x_p_exp_child_supp_paid IN VARCHAR2,
405 x_p_exp_repay_ed_loans IN VARCHAR2,
406 x_p_exp_med_dent_expenses IN VARCHAR2,
407 x_p_exp_tuit_pd_amount IN VARCHAR2,
408 x_p_exp_tuit_pd_number IN VARCHAR2,
409 x_p_cash_sav_check IN VARCHAR2,
410 x_p_month_mortgage_pay IN VARCHAR2,
411 x_p_invest_value IN VARCHAR2,
412 x_p_invest_debt IN VARCHAR2,
413 x_p_home_value IN VARCHAR2,
414 x_p_home_debt IN VARCHAR2,
415 x_p_home_purch_price IN VARCHAR2,
416 x_p_own_business_farm IN VARCHAR2,
417 x_p_business_value IN VARCHAR2,
418 x_p_business_debt IN VARCHAR2,
419 x_p_farm_value IN VARCHAR2,
420 x_p_farm_debt IN VARCHAR2,
421 x_p_live_on_farm IN VARCHAR2,
422 x_p_oth_real_estate_value IN VARCHAR2,
423 x_p_oth_real_estate_debt IN VARCHAR2,
424 x_p_oth_real_purch_price IN VARCHAR2,
425 x_p_siblings_assets IN VARCHAR2,
426 x_p_home_purch_year IN VARCHAR2,
427 x_p_oth_real_purch_year IN VARCHAR2,
428 x_p_prior_agi IN VARCHAR2,
429 x_p_prior_us_tax_paid IN VARCHAR2,
430 x_p_prior_item_deductions IN VARCHAR2,
431 x_p_prior_other_untax_inc IN VARCHAR2,
432 x_p_tax_figures IN VARCHAR2,
433 x_p_number_exemptions IN VARCHAR2,
434 x_p_adjusted_gross_inc IN VARCHAR2,
435 x_p_wages_sal_tips IN VARCHAR2,
436 x_p_interest_income IN VARCHAR2,
437 x_p_dividend_income IN VARCHAR2,
438 x_p_net_inc_bus_farm IN VARCHAR2,
439 x_p_other_taxable_income IN VARCHAR2,
440 x_p_adj_to_income IN VARCHAR2,
441 x_p_us_tax_paid IN VARCHAR2,
442 x_p_itemized_deductions IN VARCHAR2,
443 x_p_father_income_work IN VARCHAR2,
444 x_p_mother_income_work IN VARCHAR2,
448 x_p_ded_ira_keogh IN VARCHAR2,
445 x_p_soc_sec_ben IN VARCHAR2,
446 x_p_welfare_tanf IN VARCHAR2,
447 x_p_child_supp_rcvd IN VARCHAR2,
449 x_p_tax_defer_pens_savs IN VARCHAR2,
450 x_p_dep_care_med_spending IN VARCHAR2,
451 x_p_earned_income_credit IN VARCHAR2,
452 x_p_living_allow IN VARCHAR2,
453 x_p_tax_exmpt_int IN VARCHAR2,
454 x_p_foreign_inc_excl IN VARCHAR2,
455 x_p_other_untax_inc IN VARCHAR2,
456 x_p_hope_ll_credit IN VARCHAR2,
457 x_p_yr_separation IN VARCHAR2,
458 x_p_yr_divorce IN VARCHAR2,
459 x_p_exp_father_inc IN VARCHAR2,
460 x_p_exp_mother_inc IN VARCHAR2,
461 x_p_exp_other_tax_inc IN VARCHAR2,
462 x_p_exp_other_untax_inc IN VARCHAR2,
463 x_line_2_relation IN VARCHAR2,
464 x_line_2_attend_college IN VARCHAR2,
465 x_line_3_relation IN VARCHAR2,
466 x_line_3_attend_college IN VARCHAR2,
467 x_line_4_relation IN VARCHAR2,
468 x_line_4_attend_college IN VARCHAR2,
469 x_line_5_relation IN VARCHAR2,
470 x_line_5_attend_college IN VARCHAR2,
471 x_line_6_relation IN VARCHAR2,
472 x_line_6_attend_college IN VARCHAR2,
473 x_line_7_relation IN VARCHAR2,
474 x_line_7_attend_college IN VARCHAR2,
475 x_line_8_relation IN VARCHAR2,
476 x_line_8_attend_college IN VARCHAR2,
477 x_p_age_father IN VARCHAR2,
478 x_p_age_mother IN VARCHAR2,
479 x_p_div_sep_ind IN VARCHAR2,
480 x_b_cont_non_custodial_par IN VARCHAR2,
481 x_college_type_2 IN VARCHAR2,
482 x_college_type_3 IN VARCHAR2,
483 x_college_type_4 IN VARCHAR2,
484 x_college_type_5 IN VARCHAR2,
485 x_college_type_6 IN VARCHAR2,
486 x_college_type_7 IN VARCHAR2,
487 x_college_type_8 IN VARCHAR2,
488 x_school_code_1 IN VARCHAR2,
489 x_housing_code_1 IN VARCHAR2,
490 x_school_code_2 IN VARCHAR2,
491 x_housing_code_2 IN VARCHAR2,
492 x_school_code_3 IN VARCHAR2,
493 x_housing_code_3 IN VARCHAR2,
494 x_school_code_4 IN VARCHAR2,
495 x_housing_code_4 IN VARCHAR2,
496 x_school_code_5 IN VARCHAR2,
497 x_housing_code_5 IN VARCHAR2,
498 x_school_code_6 IN VARCHAR2,
499 x_housing_code_6 IN VARCHAR2,
500 x_school_code_7 IN VARCHAR2,
501 x_housing_code_7 IN VARCHAR2,
502 x_school_code_8 IN VARCHAR2,
503 x_housing_code_8 IN VARCHAR2,
504 x_school_code_9 IN VARCHAR2,
505 x_housing_code_9 IN VARCHAR2,
506 x_school_code_10 IN VARCHAR2,
507 x_housing_code_10 IN VARCHAR2,
508 x_additional_school_code_1 IN VARCHAR2,
509 x_additional_school_code_2 IN VARCHAR2,
510 x_additional_school_code_3 IN VARCHAR2,
511 x_additional_school_code_4 IN VARCHAR2,
512 x_additional_school_code_5 IN VARCHAR2,
513 x_additional_school_code_6 IN VARCHAR2,
514 x_additional_school_code_7 IN VARCHAR2,
515 x_additional_school_code_8 IN VARCHAR2,
516 x_additional_school_code_9 IN VARCHAR2,
517 x_additional_school_code_10 IN VARCHAR2,
518 x_explanation_spec_circum IN VARCHAR2,
519 x_signature_student IN VARCHAR2,
520 x_signature_spouse IN VARCHAR2,
521 x_signature_father IN VARCHAR2,
522 x_signature_mother IN VARCHAR2,
523 x_month_day_completed IN VARCHAR2,
524 x_year_completed IN VARCHAR2,
525 x_age_line_2 IN VARCHAR2,
526 x_age_line_3 IN VARCHAR2,
527 x_age_line_4 IN VARCHAR2,
528 x_age_line_5 IN VARCHAR2,
529 x_age_line_6 IN VARCHAR2,
533 x_question_1_number IN VARCHAR2,
530 x_age_line_7 IN VARCHAR2,
531 x_age_line_8 IN VARCHAR2,
532 x_a_online_signature IN VARCHAR2,
534 x_question_1_size IN VARCHAR2,
535 x_question_1_answer IN VARCHAR2,
536 x_question_2_number IN VARCHAR2,
537 x_question_2_size IN VARCHAR2,
538 x_question_2_answer IN VARCHAR2,
539 x_question_3_number IN VARCHAR2,
540 x_question_3_size IN VARCHAR2,
541 x_question_3_answer IN VARCHAR2,
542 x_question_4_number IN VARCHAR2,
543 x_question_4_size IN VARCHAR2,
544 x_question_4_answer IN VARCHAR2,
545 x_question_5_number IN VARCHAR2,
546 x_question_5_size IN VARCHAR2,
547 x_question_5_answer IN VARCHAR2,
548 x_question_6_number IN VARCHAR2,
549 x_question_6_size IN VARCHAR2,
550 x_question_6_answer IN VARCHAR2,
551 x_question_7_number IN VARCHAR2,
552 x_question_7_size IN VARCHAR2,
553 x_question_7_answer IN VARCHAR2,
554 x_question_8_number IN VARCHAR2,
555 x_question_8_size IN VARCHAR2,
556 x_question_8_answer IN VARCHAR2,
557 x_question_9_number IN VARCHAR2,
558 x_question_9_size IN VARCHAR2,
559 x_question_9_answer IN VARCHAR2,
560 x_question_10_number IN VARCHAR2,
561 x_question_10_size IN VARCHAR2,
562 x_question_10_answer IN VARCHAR2,
563 x_question_11_number IN VARCHAR2,
564 x_question_11_size IN VARCHAR2,
565 x_question_11_answer IN VARCHAR2,
566 x_question_12_number IN VARCHAR2,
567 x_question_12_size IN VARCHAR2,
568 x_question_12_answer IN VARCHAR2,
569 x_question_13_number IN VARCHAR2,
570 x_question_13_size IN VARCHAR2,
571 x_question_13_answer IN VARCHAR2,
572 x_question_14_number IN VARCHAR2,
573 x_question_14_size IN VARCHAR2,
574 x_question_14_answer IN VARCHAR2,
575 x_question_15_number IN VARCHAR2,
576 x_question_15_size IN VARCHAR2,
577 x_question_15_answer IN VARCHAR2,
578 x_question_16_number IN VARCHAR2,
579 x_question_16_size IN VARCHAR2,
580 x_question_16_answer IN VARCHAR2,
581 x_question_17_number IN VARCHAR2,
582 x_question_17_size IN VARCHAR2,
583 x_question_17_answer IN VARCHAR2,
584 x_question_18_number IN VARCHAR2,
585 x_question_18_size IN VARCHAR2,
586 x_question_18_answer IN VARCHAR2,
587 x_question_19_number IN VARCHAR2,
588 x_question_19_size IN VARCHAR2,
589 x_question_19_answer IN VARCHAR2,
590 x_question_20_number IN VARCHAR2,
591 x_question_20_size IN VARCHAR2,
592 x_question_20_answer IN VARCHAR2,
593 x_question_21_number IN VARCHAR2,
594 x_question_21_size IN VARCHAR2,
595 x_question_21_answer IN VARCHAR2,
596 x_question_22_number IN VARCHAR2,
597 x_question_22_size IN VARCHAR2,
601 x_question_23_answer IN VARCHAR2,
598 x_question_22_answer IN VARCHAR2,
599 x_question_23_number IN VARCHAR2,
600 x_question_23_size IN VARCHAR2,
602 x_question_24_number IN VARCHAR2,
603 x_question_24_size IN VARCHAR2,
604 x_question_24_answer IN VARCHAR2,
605 x_question_25_number IN VARCHAR2,
606 x_question_25_size IN VARCHAR2,
607 x_question_25_answer IN VARCHAR2,
608 x_question_26_number IN VARCHAR2,
609 x_question_26_size IN VARCHAR2,
610 x_question_26_answer IN VARCHAR2,
611 x_question_27_number IN VARCHAR2,
612 x_question_27_size IN VARCHAR2,
613 x_question_27_answer IN VARCHAR2,
614 x_question_28_number IN VARCHAR2,
615 x_question_28_size IN VARCHAR2,
616 x_question_28_answer IN VARCHAR2,
617 x_question_29_number IN VARCHAR2,
618 x_question_29_size IN VARCHAR2,
619 x_question_29_answer IN VARCHAR2,
620 x_question_30_number IN VARCHAR2,
621 x_questions_30_size IN VARCHAR2,
622 x_question_30_answer IN VARCHAR2
623 );
624
625 PROCEDURE update_row (
626 x_rowid IN VARCHAR2,
627 x_base_id IN NUMBER,
628 x_last_name IN VARCHAR2,
629 x_first_name IN VARCHAR2,
630 x_middle_initial IN VARCHAR2,
631 x_address_number_and_street IN VARCHAR2,
632 x_city IN VARCHAR2,
633 x_state_mailing IN VARCHAR2,
634 x_zip_code IN VARCHAR2,
635 x_s_telephone_number IN VARCHAR2,
636 x_s_title IN VARCHAR2,
637 x_date_of_birth IN VARCHAR2,
638 x_social_security_number IN VARCHAR2,
639 x_state_legal_residence IN VARCHAR2,
640 x_foreign_address_indicator IN VARCHAR2,
641 x_foreign_postal_code IN VARCHAR2,
642 x_country IN VARCHAR2,
643 x_financial_aid_status IN VARCHAR2,
644 x_year_in_college IN VARCHAR2,
645 x_marital_status IN VARCHAR2,
646 x_ward_court IN VARCHAR2,
647 x_legal_dependents_other IN VARCHAR2,
648 x_household_size IN VARCHAR2,
649 x_number_in_college IN VARCHAR2,
650 x_citizenship_status IN VARCHAR2,
651 x_citizenship_country IN VARCHAR2,
652 x_visa_classification IN VARCHAR2,
653 x_tax_figures IN VARCHAR2,
654 x_number_exemptions IN VARCHAR2,
655 x_adjusted_gross_inc IN VARCHAR2,
656 x_us_tax_paid IN VARCHAR2,
657 x_itemized_deductions IN VARCHAR2,
658 x_stu_income_work IN VARCHAR2,
659 x_spouse_income_work IN VARCHAR2,
660 x_divid_int_inc IN VARCHAR2,
661 x_soc_sec_benefits IN VARCHAR2,
662 x_welfare_tanf IN VARCHAR2,
663 x_child_supp_rcvd IN VARCHAR2,
664 x_earned_income_credit IN VARCHAR2,
665 x_other_untax_income IN VARCHAR2,
666 x_tax_stu_aid IN VARCHAR2,
667 x_cash_sav_check IN VARCHAR2,
668 x_ira_keogh IN VARCHAR2,
669 x_invest_value IN VARCHAR2,
670 x_invest_debt IN VARCHAR2,
671 x_home_value IN VARCHAR2,
672 x_home_debt IN VARCHAR2,
673 x_oth_real_value IN VARCHAR2,
677 x_live_on_farm IN VARCHAR2,
674 x_oth_real_debt IN VARCHAR2,
675 x_bus_farm_value IN VARCHAR2,
676 x_bus_farm_debt IN VARCHAR2,
678 x_home_purch_price IN VARCHAR2,
679 x_hope_ll_credit IN VARCHAR2,
680 x_home_purch_year IN VARCHAR2,
681 x_trust_amount IN VARCHAR2,
682 x_trust_avail IN VARCHAR2,
683 x_trust_estab IN VARCHAR2,
684 x_child_support_paid IN VARCHAR2,
685 x_med_dent_expenses IN VARCHAR2,
686 x_vet_us IN VARCHAR2,
687 x_vet_ben_amount IN VARCHAR2,
688 x_vet_ben_months IN VARCHAR2,
689 x_stu_summer_wages IN VARCHAR2,
690 x_stu_school_yr_wages IN VARCHAR2,
691 x_spouse_summer_wages IN VARCHAR2,
692 x_spouse_school_yr_wages IN VARCHAR2,
693 x_summer_other_tax_inc IN VARCHAR2,
694 x_school_yr_other_tax_inc IN VARCHAR2,
695 x_summer_untax_inc IN VARCHAR2,
696 x_school_yr_untax_inc IN VARCHAR2,
697 x_grants_schol_etc IN VARCHAR2,
698 x_tuit_benefits IN VARCHAR2,
699 x_cont_parents IN VARCHAR2,
700 x_cont_relatives IN VARCHAR2,
701 x_p_siblings_pre_tuit IN VARCHAR2,
702 x_p_student_pre_tuit IN VARCHAR2,
703 x_p_household_size IN VARCHAR2,
704 x_p_number_in_college IN VARCHAR2,
705 x_p_parents_in_college IN VARCHAR2,
706 x_p_marital_status IN VARCHAR2,
707 x_p_state_legal_residence IN VARCHAR2,
708 x_p_natural_par_status IN VARCHAR2,
709 x_p_child_supp_paid IN VARCHAR2,
710 x_p_repay_ed_loans IN VARCHAR2,
711 x_p_med_dent_expenses IN VARCHAR2,
712 x_p_tuit_paid_amount IN VARCHAR2,
713 x_p_tuit_paid_number IN VARCHAR2,
714 x_p_exp_child_supp_paid IN VARCHAR2,
715 x_p_exp_repay_ed_loans IN VARCHAR2,
716 x_p_exp_med_dent_expenses IN VARCHAR2,
717 x_p_exp_tuit_pd_amount IN VARCHAR2,
718 x_p_exp_tuit_pd_number IN VARCHAR2,
719 x_p_cash_sav_check IN VARCHAR2,
720 x_p_month_mortgage_pay IN VARCHAR2,
721 x_p_invest_value IN VARCHAR2,
722 x_p_invest_debt IN VARCHAR2,
723 x_p_home_value IN VARCHAR2,
724 x_p_home_debt IN VARCHAR2,
725 x_p_home_purch_price IN VARCHAR2,
726 x_p_own_business_farm IN VARCHAR2,
727 x_p_business_value IN VARCHAR2,
728 x_p_business_debt IN VARCHAR2,
729 x_p_farm_value IN VARCHAR2,
730 x_p_farm_debt IN VARCHAR2,
731 x_p_live_on_farm IN VARCHAR2,
732 x_p_oth_real_estate_value IN VARCHAR2,
733 x_p_oth_real_estate_debt IN VARCHAR2,
734 x_p_oth_real_purch_price IN VARCHAR2,
735 x_p_siblings_assets IN VARCHAR2,
736 x_p_home_purch_year IN VARCHAR2,
737 x_p_oth_real_purch_year IN VARCHAR2,
741 x_p_prior_other_untax_inc IN VARCHAR2,
738 x_p_prior_agi IN VARCHAR2,
739 x_p_prior_us_tax_paid IN VARCHAR2,
740 x_p_prior_item_deductions IN VARCHAR2,
742 x_p_tax_figures IN VARCHAR2,
743 x_p_number_exemptions IN VARCHAR2,
744 x_p_adjusted_gross_inc IN VARCHAR2,
745 x_p_wages_sal_tips IN VARCHAR2,
746 x_p_interest_income IN VARCHAR2,
747 x_p_dividend_income IN VARCHAR2,
748 x_p_net_inc_bus_farm IN VARCHAR2,
749 x_p_other_taxable_income IN VARCHAR2,
750 x_p_adj_to_income IN VARCHAR2,
751 x_p_us_tax_paid IN VARCHAR2,
752 x_p_itemized_deductions IN VARCHAR2,
753 x_p_father_income_work IN VARCHAR2,
754 x_p_mother_income_work IN VARCHAR2,
755 x_p_soc_sec_ben IN VARCHAR2,
756 x_p_welfare_tanf IN VARCHAR2,
757 x_p_child_supp_rcvd IN VARCHAR2,
758 x_p_ded_ira_keogh IN VARCHAR2,
759 x_p_tax_defer_pens_savs IN VARCHAR2,
760 x_p_dep_care_med_spending IN VARCHAR2,
761 x_p_earned_income_credit IN VARCHAR2,
762 x_p_living_allow IN VARCHAR2,
763 x_p_tax_exmpt_int IN VARCHAR2,
764 x_p_foreign_inc_excl IN VARCHAR2,
765 x_p_other_untax_inc IN VARCHAR2,
766 x_p_hope_ll_credit IN VARCHAR2,
767 x_p_yr_separation IN VARCHAR2,
768 x_p_yr_divorce IN VARCHAR2,
769 x_p_exp_father_inc IN VARCHAR2,
770 x_p_exp_mother_inc IN VARCHAR2,
771 x_p_exp_other_tax_inc IN VARCHAR2,
772 x_p_exp_other_untax_inc IN VARCHAR2,
773 x_line_2_relation IN VARCHAR2,
774 x_line_2_attend_college IN VARCHAR2,
775 x_line_3_relation IN VARCHAR2,
776 x_line_3_attend_college IN VARCHAR2,
777 x_line_4_relation IN VARCHAR2,
778 x_line_4_attend_college IN VARCHAR2,
779 x_line_5_relation IN VARCHAR2,
780 x_line_5_attend_college IN VARCHAR2,
781 x_line_6_relation IN VARCHAR2,
782 x_line_6_attend_college IN VARCHAR2,
783 x_line_7_relation IN VARCHAR2,
784 x_line_7_attend_college IN VARCHAR2,
785 x_line_8_relation IN VARCHAR2,
786 x_line_8_attend_college IN VARCHAR2,
787 x_p_age_father IN VARCHAR2,
788 x_p_age_mother IN VARCHAR2,
789 x_p_div_sep_ind IN VARCHAR2,
790 x_b_cont_non_custodial_par IN VARCHAR2,
791 x_college_type_2 IN VARCHAR2,
792 x_college_type_3 IN VARCHAR2,
793 x_college_type_4 IN VARCHAR2,
794 x_college_type_5 IN VARCHAR2,
795 x_college_type_6 IN VARCHAR2,
796 x_college_type_7 IN VARCHAR2,
797 x_college_type_8 IN VARCHAR2,
798 x_school_code_1 IN VARCHAR2,
799 x_housing_code_1 IN VARCHAR2,
800 x_school_code_2 IN VARCHAR2,
801 x_housing_code_2 IN VARCHAR2,
802 x_school_code_3 IN VARCHAR2,
803 x_housing_code_3 IN VARCHAR2,
804 x_school_code_4 IN VARCHAR2,
805 x_housing_code_4 IN VARCHAR2,
809 x_housing_code_6 IN VARCHAR2,
806 x_school_code_5 IN VARCHAR2,
807 x_housing_code_5 IN VARCHAR2,
808 x_school_code_6 IN VARCHAR2,
810 x_school_code_7 IN VARCHAR2,
811 x_housing_code_7 IN VARCHAR2,
812 x_school_code_8 IN VARCHAR2,
813 x_housing_code_8 IN VARCHAR2,
814 x_school_code_9 IN VARCHAR2,
815 x_housing_code_9 IN VARCHAR2,
816 x_school_code_10 IN VARCHAR2,
817 x_housing_code_10 IN VARCHAR2,
818 x_additional_school_code_1 IN VARCHAR2,
819 x_additional_school_code_2 IN VARCHAR2,
820 x_additional_school_code_3 IN VARCHAR2,
821 x_additional_school_code_4 IN VARCHAR2,
822 x_additional_school_code_5 IN VARCHAR2,
823 x_additional_school_code_6 IN VARCHAR2,
824 x_additional_school_code_7 IN VARCHAR2,
825 x_additional_school_code_8 IN VARCHAR2,
826 x_additional_school_code_9 IN VARCHAR2,
827 x_additional_school_code_10 IN VARCHAR2,
828 x_explanation_spec_circum IN VARCHAR2,
829 x_signature_student IN VARCHAR2,
830 x_signature_spouse IN VARCHAR2,
831 x_signature_father IN VARCHAR2,
832 x_signature_mother IN VARCHAR2,
833 x_month_day_completed IN VARCHAR2,
834 x_year_completed IN VARCHAR2,
835 x_age_line_2 IN VARCHAR2,
836 x_age_line_3 IN VARCHAR2,
837 x_age_line_4 IN VARCHAR2,
838 x_age_line_5 IN VARCHAR2,
839 x_age_line_6 IN VARCHAR2,
840 x_age_line_7 IN VARCHAR2,
841 x_age_line_8 IN VARCHAR2,
842 x_a_online_signature IN VARCHAR2,
843 x_question_1_number IN VARCHAR2,
844 x_question_1_size IN VARCHAR2,
845 x_question_1_answer IN VARCHAR2,
846 x_question_2_number IN VARCHAR2,
847 x_question_2_size IN VARCHAR2,
848 x_question_2_answer IN VARCHAR2,
849 x_question_3_number IN VARCHAR2,
850 x_question_3_size IN VARCHAR2,
851 x_question_3_answer IN VARCHAR2,
852 x_question_4_number IN VARCHAR2,
853 x_question_4_size IN VARCHAR2,
854 x_question_4_answer IN VARCHAR2,
855 x_question_5_number IN VARCHAR2,
856 x_question_5_size IN VARCHAR2,
857 x_question_5_answer IN VARCHAR2,
858 x_question_6_number IN VARCHAR2,
859 x_question_6_size IN VARCHAR2,
860 x_question_6_answer IN VARCHAR2,
861 x_question_7_number IN VARCHAR2,
862 x_question_7_size IN VARCHAR2,
863 x_question_7_answer IN VARCHAR2,
864 x_question_8_number IN VARCHAR2,
865 x_question_8_size IN VARCHAR2,
866 x_question_8_answer IN VARCHAR2,
867 x_question_9_number IN VARCHAR2,
868 x_question_9_size IN VARCHAR2,
869 x_question_9_answer IN VARCHAR2,
873 x_question_11_number IN VARCHAR2,
870 x_question_10_number IN VARCHAR2,
871 x_question_10_size IN VARCHAR2,
872 x_question_10_answer IN VARCHAR2,
874 x_question_11_size IN VARCHAR2,
875 x_question_11_answer IN VARCHAR2,
876 x_question_12_number IN VARCHAR2,
877 x_question_12_size IN VARCHAR2,
878 x_question_12_answer IN VARCHAR2,
879 x_question_13_number IN VARCHAR2,
880 x_question_13_size IN VARCHAR2,
881 x_question_13_answer IN VARCHAR2,
882 x_question_14_number IN VARCHAR2,
883 x_question_14_size IN VARCHAR2,
884 x_question_14_answer IN VARCHAR2,
885 x_question_15_number IN VARCHAR2,
886 x_question_15_size IN VARCHAR2,
887 x_question_15_answer IN VARCHAR2,
888 x_question_16_number IN VARCHAR2,
889 x_question_16_size IN VARCHAR2,
890 x_question_16_answer IN VARCHAR2,
891 x_question_17_number IN VARCHAR2,
892 x_question_17_size IN VARCHAR2,
893 x_question_17_answer IN VARCHAR2,
894 x_question_18_number IN VARCHAR2,
895 x_question_18_size IN VARCHAR2,
896 x_question_18_answer IN VARCHAR2,
897 x_question_19_number IN VARCHAR2,
898 x_question_19_size IN VARCHAR2,
899 x_question_19_answer IN VARCHAR2,
900 x_question_20_number IN VARCHAR2,
901 x_question_20_size IN VARCHAR2,
902 x_question_20_answer IN VARCHAR2,
903 x_question_21_number IN VARCHAR2,
904 x_question_21_size IN VARCHAR2,
905 x_question_21_answer IN VARCHAR2,
906 x_question_22_number IN VARCHAR2,
907 x_question_22_size IN VARCHAR2,
908 x_question_22_answer IN VARCHAR2,
909 x_question_23_number IN VARCHAR2,
910 x_question_23_size IN VARCHAR2,
911 x_question_23_answer IN VARCHAR2,
912 x_question_24_number IN VARCHAR2,
913 x_question_24_size IN VARCHAR2,
914 x_question_24_answer IN VARCHAR2,
915 x_question_25_number IN VARCHAR2,
916 x_question_25_size IN VARCHAR2,
917 x_question_25_answer IN VARCHAR2,
918 x_question_26_number IN VARCHAR2,
919 x_question_26_size IN VARCHAR2,
920 x_question_26_answer IN VARCHAR2,
921 x_question_27_number IN VARCHAR2,
922 x_question_27_size IN VARCHAR2,
923 x_question_27_answer IN VARCHAR2,
924 x_question_28_number IN VARCHAR2,
925 x_question_28_size IN VARCHAR2,
926 x_question_28_answer IN VARCHAR2,
927 x_question_29_number IN VARCHAR2,
928 x_question_29_size IN VARCHAR2,
929 x_question_29_answer IN VARCHAR2,
930 x_question_30_number IN VARCHAR2,
931 x_questions_30_size IN VARCHAR2,
932 x_question_30_answer IN VARCHAR2,
933 x_mode IN VARCHAR2 DEFAULT 'R'
934 );
935
936 PROCEDURE add_row (
940 x_first_name IN VARCHAR2,
937 x_rowid IN OUT NOCOPY VARCHAR2,
938 x_base_id IN OUT NOCOPY NUMBER,
939 x_last_name IN VARCHAR2,
941 x_middle_initial IN VARCHAR2,
942 x_address_number_and_street IN VARCHAR2,
943 x_city IN VARCHAR2,
944 x_state_mailing IN VARCHAR2,
945 x_zip_code IN VARCHAR2,
946 x_s_telephone_number IN VARCHAR2,
947 x_s_title IN VARCHAR2,
948 x_date_of_birth IN VARCHAR2,
949 x_social_security_number IN VARCHAR2,
950 x_state_legal_residence IN VARCHAR2,
951 x_foreign_address_indicator IN VARCHAR2,
952 x_foreign_postal_code IN VARCHAR2,
953 x_country IN VARCHAR2,
954 x_financial_aid_status IN VARCHAR2,
955 x_year_in_college IN VARCHAR2,
956 x_marital_status IN VARCHAR2,
957 x_ward_court IN VARCHAR2,
958 x_legal_dependents_other IN VARCHAR2,
959 x_household_size IN VARCHAR2,
960 x_number_in_college IN VARCHAR2,
961 x_citizenship_status IN VARCHAR2,
962 x_citizenship_country IN VARCHAR2,
963 x_visa_classification IN VARCHAR2,
964 x_tax_figures IN VARCHAR2,
965 x_number_exemptions IN VARCHAR2,
966 x_adjusted_gross_inc IN VARCHAR2,
967 x_us_tax_paid IN VARCHAR2,
968 x_itemized_deductions IN VARCHAR2,
969 x_stu_income_work IN VARCHAR2,
970 x_spouse_income_work IN VARCHAR2,
971 x_divid_int_inc IN VARCHAR2,
972 x_soc_sec_benefits IN VARCHAR2,
973 x_welfare_tanf IN VARCHAR2,
974 x_child_supp_rcvd IN VARCHAR2,
975 x_earned_income_credit IN VARCHAR2,
976 x_other_untax_income IN VARCHAR2,
977 x_tax_stu_aid IN VARCHAR2,
978 x_cash_sav_check IN VARCHAR2,
979 x_ira_keogh IN VARCHAR2,
980 x_invest_value IN VARCHAR2,
981 x_invest_debt IN VARCHAR2,
982 x_home_value IN VARCHAR2,
983 x_home_debt IN VARCHAR2,
984 x_oth_real_value IN VARCHAR2,
985 x_oth_real_debt IN VARCHAR2,
986 x_bus_farm_value IN VARCHAR2,
987 x_bus_farm_debt IN VARCHAR2,
988 x_live_on_farm IN VARCHAR2,
989 x_home_purch_price IN VARCHAR2,
990 x_hope_ll_credit IN VARCHAR2,
991 x_home_purch_year IN VARCHAR2,
992 x_trust_amount IN VARCHAR2,
993 x_trust_avail IN VARCHAR2,
994 x_trust_estab IN VARCHAR2,
995 x_child_support_paid IN VARCHAR2,
996 x_med_dent_expenses IN VARCHAR2,
997 x_vet_us IN VARCHAR2,
998 x_vet_ben_amount IN VARCHAR2,
999 x_vet_ben_months IN VARCHAR2,
1000 x_stu_summer_wages IN VARCHAR2,
1001 x_stu_school_yr_wages IN VARCHAR2,
1002 x_spouse_summer_wages IN VARCHAR2,
1003 x_spouse_school_yr_wages IN VARCHAR2,
1004 x_summer_other_tax_inc IN VARCHAR2,
1005 x_school_yr_other_tax_inc IN VARCHAR2,
1006 x_summer_untax_inc IN VARCHAR2,
1007 x_school_yr_untax_inc IN VARCHAR2,
1008 x_grants_schol_etc IN VARCHAR2,
1009 x_tuit_benefits IN VARCHAR2,
1010 x_cont_parents IN VARCHAR2,
1011 x_cont_relatives IN VARCHAR2,
1012 x_p_siblings_pre_tuit IN VARCHAR2,
1013 x_p_student_pre_tuit IN VARCHAR2,
1014 x_p_household_size IN VARCHAR2,
1015 x_p_number_in_college IN VARCHAR2,
1016 x_p_parents_in_college IN VARCHAR2,
1017 x_p_marital_status IN VARCHAR2,
1018 x_p_state_legal_residence IN VARCHAR2,
1019 x_p_natural_par_status IN VARCHAR2,
1020 x_p_child_supp_paid IN VARCHAR2,
1021 x_p_repay_ed_loans IN VARCHAR2,
1022 x_p_med_dent_expenses IN VARCHAR2,
1023 x_p_tuit_paid_amount IN VARCHAR2,
1024 x_p_tuit_paid_number IN VARCHAR2,
1025 x_p_exp_child_supp_paid IN VARCHAR2,
1029 x_p_exp_tuit_pd_number IN VARCHAR2,
1026 x_p_exp_repay_ed_loans IN VARCHAR2,
1027 x_p_exp_med_dent_expenses IN VARCHAR2,
1028 x_p_exp_tuit_pd_amount IN VARCHAR2,
1030 x_p_cash_sav_check IN VARCHAR2,
1031 x_p_month_mortgage_pay IN VARCHAR2,
1032 x_p_invest_value IN VARCHAR2,
1033 x_p_invest_debt IN VARCHAR2,
1034 x_p_home_value IN VARCHAR2,
1035 x_p_home_debt IN VARCHAR2,
1036 x_p_home_purch_price IN VARCHAR2,
1037 x_p_own_business_farm IN VARCHAR2,
1038 x_p_business_value IN VARCHAR2,
1039 x_p_business_debt IN VARCHAR2,
1040 x_p_farm_value IN VARCHAR2,
1041 x_p_farm_debt IN VARCHAR2,
1042 x_p_live_on_farm IN VARCHAR2,
1043 x_p_oth_real_estate_value IN VARCHAR2,
1044 x_p_oth_real_estate_debt IN VARCHAR2,
1045 x_p_oth_real_purch_price IN VARCHAR2,
1046 x_p_siblings_assets IN VARCHAR2,
1047 x_p_home_purch_year IN VARCHAR2,
1048 x_p_oth_real_purch_year IN VARCHAR2,
1049 x_p_prior_agi IN VARCHAR2,
1050 x_p_prior_us_tax_paid IN VARCHAR2,
1051 x_p_prior_item_deductions IN VARCHAR2,
1052 x_p_prior_other_untax_inc IN VARCHAR2,
1053 x_p_tax_figures IN VARCHAR2,
1054 x_p_number_exemptions IN VARCHAR2,
1055 x_p_adjusted_gross_inc IN VARCHAR2,
1056 x_p_wages_sal_tips IN VARCHAR2,
1057 x_p_interest_income IN VARCHAR2,
1058 x_p_dividend_income IN VARCHAR2,
1059 x_p_net_inc_bus_farm IN VARCHAR2,
1060 x_p_other_taxable_income IN VARCHAR2,
1061 x_p_adj_to_income IN VARCHAR2,
1062 x_p_us_tax_paid IN VARCHAR2,
1063 x_p_itemized_deductions IN VARCHAR2,
1064 x_p_father_income_work IN VARCHAR2,
1065 x_p_mother_income_work IN VARCHAR2,
1066 x_p_soc_sec_ben IN VARCHAR2,
1067 x_p_welfare_tanf IN VARCHAR2,
1068 x_p_child_supp_rcvd IN VARCHAR2,
1069 x_p_ded_ira_keogh IN VARCHAR2,
1070 x_p_tax_defer_pens_savs IN VARCHAR2,
1071 x_p_dep_care_med_spending IN VARCHAR2,
1072 x_p_earned_income_credit IN VARCHAR2,
1073 x_p_living_allow IN VARCHAR2,
1074 x_p_tax_exmpt_int IN VARCHAR2,
1075 x_p_foreign_inc_excl IN VARCHAR2,
1076 x_p_other_untax_inc IN VARCHAR2,
1077 x_p_hope_ll_credit IN VARCHAR2,
1078 x_p_yr_separation IN VARCHAR2,
1079 x_p_yr_divorce IN VARCHAR2,
1080 x_p_exp_father_inc IN VARCHAR2,
1081 x_p_exp_mother_inc IN VARCHAR2,
1082 x_p_exp_other_tax_inc IN VARCHAR2,
1083 x_p_exp_other_untax_inc IN VARCHAR2,
1084 x_line_2_relation IN VARCHAR2,
1085 x_line_2_attend_college IN VARCHAR2,
1086 x_line_3_relation IN VARCHAR2,
1087 x_line_3_attend_college IN VARCHAR2,
1088 x_line_4_relation IN VARCHAR2,
1089 x_line_4_attend_college IN VARCHAR2,
1090 x_line_5_relation IN VARCHAR2,
1091 x_line_5_attend_college IN VARCHAR2,
1092 x_line_6_relation IN VARCHAR2,
1093 x_line_6_attend_college IN VARCHAR2,
1094 x_line_7_relation IN VARCHAR2,
1095 x_line_7_attend_college IN VARCHAR2,
1096 x_line_8_relation IN VARCHAR2,
1097 x_line_8_attend_college IN VARCHAR2,
1098 x_p_age_father IN VARCHAR2,
1099 x_p_age_mother IN VARCHAR2,
1100 x_p_div_sep_ind IN VARCHAR2,
1101 x_b_cont_non_custodial_par IN VARCHAR2,
1102 x_college_type_2 IN VARCHAR2,
1103 x_college_type_3 IN VARCHAR2,
1104 x_college_type_4 IN VARCHAR2,
1105 x_college_type_5 IN VARCHAR2,
1106 x_college_type_6 IN VARCHAR2,
1107 x_college_type_7 IN VARCHAR2,
1108 x_college_type_8 IN VARCHAR2,
1109 x_school_code_1 IN VARCHAR2,
1110 x_housing_code_1 IN VARCHAR2,
1111 x_school_code_2 IN VARCHAR2,
1112 x_housing_code_2 IN VARCHAR2,
1113 x_school_code_3 IN VARCHAR2,
1114 x_housing_code_3 IN VARCHAR2,
1115 x_school_code_4 IN VARCHAR2,
1116 x_housing_code_4 IN VARCHAR2,
1117 x_school_code_5 IN VARCHAR2,
1118 x_housing_code_5 IN VARCHAR2,
1119 x_school_code_6 IN VARCHAR2,
1123 x_school_code_8 IN VARCHAR2,
1120 x_housing_code_6 IN VARCHAR2,
1121 x_school_code_7 IN VARCHAR2,
1122 x_housing_code_7 IN VARCHAR2,
1124 x_housing_code_8 IN VARCHAR2,
1125 x_school_code_9 IN VARCHAR2,
1126 x_housing_code_9 IN VARCHAR2,
1127 x_school_code_10 IN VARCHAR2,
1128 x_housing_code_10 IN VARCHAR2,
1129 x_additional_school_code_1 IN VARCHAR2,
1130 x_additional_school_code_2 IN VARCHAR2,
1131 x_additional_school_code_3 IN VARCHAR2,
1132 x_additional_school_code_4 IN VARCHAR2,
1133 x_additional_school_code_5 IN VARCHAR2,
1134 x_additional_school_code_6 IN VARCHAR2,
1135 x_additional_school_code_7 IN VARCHAR2,
1136 x_additional_school_code_8 IN VARCHAR2,
1137 x_additional_school_code_9 IN VARCHAR2,
1138 x_additional_school_code_10 IN VARCHAR2,
1139 x_explanation_spec_circum IN VARCHAR2,
1140 x_signature_student IN VARCHAR2,
1141 x_signature_spouse IN VARCHAR2,
1142 x_signature_father IN VARCHAR2,
1143 x_signature_mother IN VARCHAR2,
1144 x_month_day_completed IN VARCHAR2,
1145 x_year_completed IN VARCHAR2,
1146 x_age_line_2 IN VARCHAR2,
1147 x_age_line_3 IN VARCHAR2,
1148 x_age_line_4 IN VARCHAR2,
1149 x_age_line_5 IN VARCHAR2,
1150 x_age_line_6 IN VARCHAR2,
1151 x_age_line_7 IN VARCHAR2,
1152 x_age_line_8 IN VARCHAR2,
1153 x_a_online_signature IN VARCHAR2,
1154 x_question_1_number IN VARCHAR2,
1155 x_question_1_size IN VARCHAR2,
1156 x_question_1_answer IN VARCHAR2,
1157 x_question_2_number IN VARCHAR2,
1158 x_question_2_size IN VARCHAR2,
1159 x_question_2_answer IN VARCHAR2,
1160 x_question_3_number IN VARCHAR2,
1161 x_question_3_size IN VARCHAR2,
1162 x_question_3_answer IN VARCHAR2,
1163 x_question_4_number IN VARCHAR2,
1164 x_question_4_size IN VARCHAR2,
1165 x_question_4_answer IN VARCHAR2,
1166 x_question_5_number IN VARCHAR2,
1167 x_question_5_size IN VARCHAR2,
1168 x_question_5_answer IN VARCHAR2,
1169 x_question_6_number IN VARCHAR2,
1170 x_question_6_size IN VARCHAR2,
1171 x_question_6_answer IN VARCHAR2,
1172 x_question_7_number IN VARCHAR2,
1173 x_question_7_size IN VARCHAR2,
1174 x_question_7_answer IN VARCHAR2,
1175 x_question_8_number IN VARCHAR2,
1176 x_question_8_size IN VARCHAR2,
1177 x_question_8_answer IN VARCHAR2,
1178 x_question_9_number IN VARCHAR2,
1179 x_question_9_size IN VARCHAR2,
1180 x_question_9_answer IN VARCHAR2,
1181 x_question_10_number IN VARCHAR2,
1182 x_question_10_size IN VARCHAR2,
1183 x_question_10_answer IN VARCHAR2,
1184 x_question_11_number IN VARCHAR2,
1188 x_question_12_size IN VARCHAR2,
1185 x_question_11_size IN VARCHAR2,
1186 x_question_11_answer IN VARCHAR2,
1187 x_question_12_number IN VARCHAR2,
1189 x_question_12_answer IN VARCHAR2,
1190 x_question_13_number IN VARCHAR2,
1191 x_question_13_size IN VARCHAR2,
1192 x_question_13_answer IN VARCHAR2,
1193 x_question_14_number IN VARCHAR2,
1194 x_question_14_size IN VARCHAR2,
1195 x_question_14_answer IN VARCHAR2,
1196 x_question_15_number IN VARCHAR2,
1197 x_question_15_size IN VARCHAR2,
1198 x_question_15_answer IN VARCHAR2,
1199 x_question_16_number IN VARCHAR2,
1200 x_question_16_size IN VARCHAR2,
1201 x_question_16_answer IN VARCHAR2,
1202 x_question_17_number IN VARCHAR2,
1203 x_question_17_size IN VARCHAR2,
1204 x_question_17_answer IN VARCHAR2,
1205 x_question_18_number IN VARCHAR2,
1206 x_question_18_size IN VARCHAR2,
1207 x_question_18_answer IN VARCHAR2,
1208 x_question_19_number IN VARCHAR2,
1209 x_question_19_size IN VARCHAR2,
1210 x_question_19_answer IN VARCHAR2,
1211 x_question_20_number IN VARCHAR2,
1212 x_question_20_size IN VARCHAR2,
1213 x_question_20_answer IN VARCHAR2,
1214 x_question_21_number IN VARCHAR2,
1215 x_question_21_size IN VARCHAR2,
1216 x_question_21_answer IN VARCHAR2,
1217 x_question_22_number IN VARCHAR2,
1218 x_question_22_size IN VARCHAR2,
1219 x_question_22_answer IN VARCHAR2,
1220 x_question_23_number IN VARCHAR2,
1221 x_question_23_size IN VARCHAR2,
1222 x_question_23_answer IN VARCHAR2,
1223 x_question_24_number IN VARCHAR2,
1224 x_question_24_size IN VARCHAR2,
1225 x_question_24_answer IN VARCHAR2,
1226 x_question_25_number IN VARCHAR2,
1227 x_question_25_size IN VARCHAR2,
1228 x_question_25_answer IN VARCHAR2,
1229 x_question_26_number IN VARCHAR2,
1230 x_question_26_size IN VARCHAR2,
1231 x_question_26_answer IN VARCHAR2,
1232 x_question_27_number IN VARCHAR2,
1233 x_question_27_size IN VARCHAR2,
1234 x_question_27_answer IN VARCHAR2,
1235 x_question_28_number IN VARCHAR2,
1236 x_question_28_size IN VARCHAR2,
1237 x_question_28_answer IN VARCHAR2,
1238 x_question_29_number IN VARCHAR2,
1239 x_question_29_size IN VARCHAR2,
1240 x_question_29_answer IN VARCHAR2,
1241 x_question_30_number IN VARCHAR2,
1242 x_questions_30_size IN VARCHAR2,
1243 x_question_30_answer IN VARCHAR2,
1244 x_mode IN VARCHAR2 DEFAULT 'R'
1245 );
1246
1247 PROCEDURE delete_row (
1248 x_rowid IN VARCHAR2
1249 );
1250
1251 FUNCTION get_pk_for_validation (
1252 x_base_id IN NUMBER
1253 ) RETURN BOOLEAN;
1254
1255 PROCEDURE before_dml (
1256 p_action IN VARCHAR2,
1260 x_first_name IN VARCHAR2 DEFAULT NULL,
1257 x_rowid IN VARCHAR2 DEFAULT NULL,
1258 x_base_id IN NUMBER DEFAULT NULL,
1259 x_last_name IN VARCHAR2 DEFAULT NULL,
1261 x_middle_initial IN VARCHAR2 DEFAULT NULL,
1262 x_address_number_and_street IN VARCHAR2 DEFAULT NULL,
1263 x_city IN VARCHAR2 DEFAULT NULL,
1264 x_state_mailing IN VARCHAR2 DEFAULT NULL,
1265 x_zip_code IN VARCHAR2 DEFAULT NULL,
1266 x_s_telephone_number IN VARCHAR2 DEFAULT NULL,
1267 x_s_title IN VARCHAR2 DEFAULT NULL,
1268 x_date_of_birth IN VARCHAR2 DEFAULT NULL,
1269 x_social_security_number IN VARCHAR2 DEFAULT NULL,
1270 x_state_legal_residence IN VARCHAR2 DEFAULT NULL,
1271 x_foreign_address_indicator IN VARCHAR2 DEFAULT NULL,
1272 x_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
1273 x_country IN VARCHAR2 DEFAULT NULL,
1274 x_financial_aid_status IN VARCHAR2 DEFAULT NULL,
1275 x_year_in_college IN VARCHAR2 DEFAULT NULL,
1276 x_marital_status IN VARCHAR2 DEFAULT NULL,
1277 x_ward_court IN VARCHAR2 DEFAULT NULL,
1278 x_legal_dependents_other IN VARCHAR2 DEFAULT NULL,
1279 x_household_size IN VARCHAR2 DEFAULT NULL,
1280 x_number_in_college IN VARCHAR2 DEFAULT NULL,
1281 x_citizenship_status IN VARCHAR2 DEFAULT NULL,
1282 x_citizenship_country IN VARCHAR2 DEFAULT NULL,
1283 x_visa_classification IN VARCHAR2 DEFAULT NULL,
1284 x_tax_figures IN VARCHAR2 DEFAULT NULL,
1285 x_number_exemptions IN VARCHAR2 DEFAULT NULL,
1286 x_adjusted_gross_inc IN VARCHAR2 DEFAULT NULL,
1287 x_us_tax_paid IN VARCHAR2 DEFAULT NULL,
1288 x_itemized_deductions IN VARCHAR2 DEFAULT NULL,
1289 x_stu_income_work IN VARCHAR2 DEFAULT NULL,
1290 x_spouse_income_work IN VARCHAR2 DEFAULT NULL,
1291 x_divid_int_inc IN VARCHAR2 DEFAULT NULL,
1292 x_soc_sec_benefits IN VARCHAR2 DEFAULT NULL,
1293 x_welfare_tanf IN VARCHAR2 DEFAULT NULL,
1294 x_child_supp_rcvd IN VARCHAR2 DEFAULT NULL,
1295 x_earned_income_credit IN VARCHAR2 DEFAULT NULL,
1296 x_other_untax_income IN VARCHAR2 DEFAULT NULL,
1297 x_tax_stu_aid IN VARCHAR2 DEFAULT NULL,
1298 x_cash_sav_check IN VARCHAR2 DEFAULT NULL,
1299 x_ira_keogh IN VARCHAR2 DEFAULT NULL,
1300 x_invest_value IN VARCHAR2 DEFAULT NULL,
1301 x_invest_debt IN VARCHAR2 DEFAULT NULL,
1302 x_home_value IN VARCHAR2 DEFAULT NULL,
1303 x_home_debt IN VARCHAR2 DEFAULT NULL,
1304 x_oth_real_value IN VARCHAR2 DEFAULT NULL,
1305 x_oth_real_debt IN VARCHAR2 DEFAULT NULL,
1306 x_bus_farm_value IN VARCHAR2 DEFAULT NULL,
1307 x_bus_farm_debt IN VARCHAR2 DEFAULT NULL,
1308 x_live_on_farm IN VARCHAR2 DEFAULT NULL,
1312 x_trust_amount IN VARCHAR2 DEFAULT NULL,
1309 x_home_purch_price IN VARCHAR2 DEFAULT NULL,
1310 x_hope_ll_credit IN VARCHAR2 DEFAULT NULL,
1311 x_home_purch_year IN VARCHAR2 DEFAULT NULL,
1313 x_trust_avail IN VARCHAR2 DEFAULT NULL,
1314 x_trust_estab IN VARCHAR2 DEFAULT NULL,
1315 x_child_support_paid IN VARCHAR2 DEFAULT NULL,
1316 x_med_dent_expenses IN VARCHAR2 DEFAULT NULL,
1317 x_vet_us IN VARCHAR2 DEFAULT NULL,
1318 x_vet_ben_amount IN VARCHAR2 DEFAULT NULL,
1319 x_vet_ben_months IN VARCHAR2 DEFAULT NULL,
1320 x_stu_summer_wages IN VARCHAR2 DEFAULT NULL,
1321 x_stu_school_yr_wages IN VARCHAR2 DEFAULT NULL,
1322 x_spouse_summer_wages IN VARCHAR2 DEFAULT NULL,
1323 x_spouse_school_yr_wages IN VARCHAR2 DEFAULT NULL,
1324 x_summer_other_tax_inc IN VARCHAR2 DEFAULT NULL,
1325 x_school_yr_other_tax_inc IN VARCHAR2 DEFAULT NULL,
1326 x_summer_untax_inc IN VARCHAR2 DEFAULT NULL,
1327 x_school_yr_untax_inc IN VARCHAR2 DEFAULT NULL,
1328 x_grants_schol_etc IN VARCHAR2 DEFAULT NULL,
1329 x_tuit_benefits IN VARCHAR2 DEFAULT NULL,
1330 x_cont_parents IN VARCHAR2 DEFAULT NULL,
1331 x_cont_relatives IN VARCHAR2 DEFAULT NULL,
1332 x_p_siblings_pre_tuit IN VARCHAR2 DEFAULT NULL,
1333 x_p_student_pre_tuit IN VARCHAR2 DEFAULT NULL,
1334 x_p_household_size IN VARCHAR2 DEFAULT NULL,
1335 x_p_number_in_college IN VARCHAR2 DEFAULT NULL,
1336 x_p_parents_in_college IN VARCHAR2 DEFAULT NULL,
1337 x_p_marital_status IN VARCHAR2 DEFAULT NULL,
1338 x_p_state_legal_residence IN VARCHAR2 DEFAULT NULL,
1339 x_p_natural_par_status IN VARCHAR2 DEFAULT NULL,
1340 x_p_child_supp_paid IN VARCHAR2 DEFAULT NULL,
1341 x_p_repay_ed_loans IN VARCHAR2 DEFAULT NULL,
1342 x_p_med_dent_expenses IN VARCHAR2 DEFAULT NULL,
1343 x_p_tuit_paid_amount IN VARCHAR2 DEFAULT NULL,
1344 x_p_tuit_paid_number IN VARCHAR2 DEFAULT NULL,
1345 x_p_exp_child_supp_paid IN VARCHAR2 DEFAULT NULL,
1346 x_p_exp_repay_ed_loans IN VARCHAR2 DEFAULT NULL,
1347 x_p_exp_med_dent_expenses IN VARCHAR2 DEFAULT NULL,
1348 x_p_exp_tuit_pd_amount IN VARCHAR2 DEFAULT NULL,
1349 x_p_exp_tuit_pd_number IN VARCHAR2 DEFAULT NULL,
1350 x_p_cash_sav_check IN VARCHAR2 DEFAULT NULL,
1351 x_p_month_mortgage_pay IN VARCHAR2 DEFAULT NULL,
1352 x_p_invest_value IN VARCHAR2 DEFAULT NULL,
1353 x_p_invest_debt IN VARCHAR2 DEFAULT NULL,
1354 x_p_home_value IN VARCHAR2 DEFAULT NULL,
1355 x_p_home_debt IN VARCHAR2 DEFAULT NULL,
1356 x_p_home_purch_price IN VARCHAR2 DEFAULT NULL,
1357 x_p_own_business_farm IN VARCHAR2 DEFAULT NULL,
1358 x_p_business_value IN VARCHAR2 DEFAULT NULL,
1359 x_p_business_debt IN VARCHAR2 DEFAULT NULL,
1360 x_p_farm_value IN VARCHAR2 DEFAULT NULL,
1361 x_p_farm_debt IN VARCHAR2 DEFAULT NULL,
1362 x_p_live_on_farm IN VARCHAR2 DEFAULT NULL,
1363 x_p_oth_real_estate_value IN VARCHAR2 DEFAULT NULL,
1367 x_p_home_purch_year IN VARCHAR2 DEFAULT NULL,
1364 x_p_oth_real_estate_debt IN VARCHAR2 DEFAULT NULL,
1365 x_p_oth_real_purch_price IN VARCHAR2 DEFAULT NULL,
1366 x_p_siblings_assets IN VARCHAR2 DEFAULT NULL,
1368 x_p_oth_real_purch_year IN VARCHAR2 DEFAULT NULL,
1369 x_p_prior_agi IN VARCHAR2 DEFAULT NULL,
1370 x_p_prior_us_tax_paid IN VARCHAR2 DEFAULT NULL,
1371 x_p_prior_item_deductions IN VARCHAR2 DEFAULT NULL,
1372 x_p_prior_other_untax_inc IN VARCHAR2 DEFAULT NULL,
1373 x_p_tax_figures IN VARCHAR2 DEFAULT NULL,
1374 x_p_number_exemptions IN VARCHAR2 DEFAULT NULL,
1375 x_p_adjusted_gross_inc IN VARCHAR2 DEFAULT NULL,
1376 x_p_wages_sal_tips IN VARCHAR2 DEFAULT NULL,
1377 x_p_interest_income IN VARCHAR2 DEFAULT NULL,
1378 x_p_dividend_income IN VARCHAR2 DEFAULT NULL,
1379 x_p_net_inc_bus_farm IN VARCHAR2 DEFAULT NULL,
1380 x_p_other_taxable_income IN VARCHAR2 DEFAULT NULL,
1381 x_p_adj_to_income IN VARCHAR2 DEFAULT NULL,
1382 x_p_us_tax_paid IN VARCHAR2 DEFAULT NULL,
1383 x_p_itemized_deductions IN VARCHAR2 DEFAULT NULL,
1384 x_p_father_income_work IN VARCHAR2 DEFAULT NULL,
1385 x_p_mother_income_work IN VARCHAR2 DEFAULT NULL,
1386 x_p_soc_sec_ben IN VARCHAR2 DEFAULT NULL,
1387 x_p_welfare_tanf IN VARCHAR2 DEFAULT NULL,
1388 x_p_child_supp_rcvd IN VARCHAR2 DEFAULT NULL,
1389 x_p_ded_ira_keogh IN VARCHAR2 DEFAULT NULL,
1390 x_p_tax_defer_pens_savs IN VARCHAR2 DEFAULT NULL,
1391 x_p_dep_care_med_spending IN VARCHAR2 DEFAULT NULL,
1392 x_p_earned_income_credit IN VARCHAR2 DEFAULT NULL,
1393 x_p_living_allow IN VARCHAR2 DEFAULT NULL,
1394 x_p_tax_exmpt_int IN VARCHAR2 DEFAULT NULL,
1395 x_p_foreign_inc_excl IN VARCHAR2 DEFAULT NULL,
1396 x_p_other_untax_inc IN VARCHAR2 DEFAULT NULL,
1397 x_p_hope_ll_credit IN VARCHAR2 DEFAULT NULL,
1398 x_p_yr_separation IN VARCHAR2 DEFAULT NULL,
1399 x_p_yr_divorce IN VARCHAR2 DEFAULT NULL,
1400 x_p_exp_father_inc IN VARCHAR2 DEFAULT NULL,
1401 x_p_exp_mother_inc IN VARCHAR2 DEFAULT NULL,
1402 x_p_exp_other_tax_inc IN VARCHAR2 DEFAULT NULL,
1403 x_p_exp_other_untax_inc IN VARCHAR2 DEFAULT NULL,
1404 x_line_2_relation IN VARCHAR2 DEFAULT NULL,
1405 x_line_2_attend_college IN VARCHAR2 DEFAULT NULL,
1406 x_line_3_relation IN VARCHAR2 DEFAULT NULL,
1407 x_line_3_attend_college IN VARCHAR2 DEFAULT NULL,
1408 x_line_4_relation IN VARCHAR2 DEFAULT NULL,
1409 x_line_4_attend_college IN VARCHAR2 DEFAULT NULL,
1413 x_line_6_attend_college IN VARCHAR2 DEFAULT NULL,
1410 x_line_5_relation IN VARCHAR2 DEFAULT NULL,
1411 x_line_5_attend_college IN VARCHAR2 DEFAULT NULL,
1412 x_line_6_relation IN VARCHAR2 DEFAULT NULL,
1414 x_line_7_relation IN VARCHAR2 DEFAULT NULL,
1415 x_line_7_attend_college IN VARCHAR2 DEFAULT NULL,
1416 x_line_8_relation IN VARCHAR2 DEFAULT NULL,
1417 x_line_8_attend_college IN VARCHAR2 DEFAULT NULL,
1418 x_p_age_father IN VARCHAR2 DEFAULT NULL,
1419 x_p_age_mother IN VARCHAR2 DEFAULT NULL,
1420 x_p_div_sep_ind IN VARCHAR2 DEFAULT NULL,
1421 x_b_cont_non_custodial_par IN VARCHAR2 DEFAULT NULL,
1422 x_college_type_2 IN VARCHAR2 DEFAULT NULL,
1423 x_college_type_3 IN VARCHAR2 DEFAULT NULL,
1424 x_college_type_4 IN VARCHAR2 DEFAULT NULL,
1425 x_college_type_5 IN VARCHAR2 DEFAULT NULL,
1426 x_college_type_6 IN VARCHAR2 DEFAULT NULL,
1427 x_college_type_7 IN VARCHAR2 DEFAULT NULL,
1428 x_college_type_8 IN VARCHAR2 DEFAULT NULL,
1429 x_school_code_1 IN VARCHAR2 DEFAULT NULL,
1430 x_housing_code_1 IN VARCHAR2 DEFAULT NULL,
1431 x_school_code_2 IN VARCHAR2 DEFAULT NULL,
1432 x_housing_code_2 IN VARCHAR2 DEFAULT NULL,
1433 x_school_code_3 IN VARCHAR2 DEFAULT NULL,
1434 x_housing_code_3 IN VARCHAR2 DEFAULT NULL,
1435 x_school_code_4 IN VARCHAR2 DEFAULT NULL,
1436 x_housing_code_4 IN VARCHAR2 DEFAULT NULL,
1437 x_school_code_5 IN VARCHAR2 DEFAULT NULL,
1438 x_housing_code_5 IN VARCHAR2 DEFAULT NULL,
1439 x_school_code_6 IN VARCHAR2 DEFAULT NULL,
1440 x_housing_code_6 IN VARCHAR2 DEFAULT NULL,
1441 x_school_code_7 IN VARCHAR2 DEFAULT NULL,
1442 x_housing_code_7 IN VARCHAR2 DEFAULT NULL,
1443 x_school_code_8 IN VARCHAR2 DEFAULT NULL,
1444 x_housing_code_8 IN VARCHAR2 DEFAULT NULL,
1445 x_school_code_9 IN VARCHAR2 DEFAULT NULL,
1446 x_housing_code_9 IN VARCHAR2 DEFAULT NULL,
1447 x_school_code_10 IN VARCHAR2 DEFAULT NULL,
1448 x_housing_code_10 IN VARCHAR2 DEFAULT NULL,
1449 x_additional_school_code_1 IN VARCHAR2 DEFAULT NULL,
1450 x_additional_school_code_2 IN VARCHAR2 DEFAULT NULL,
1451 x_additional_school_code_3 IN VARCHAR2 DEFAULT NULL,
1452 x_additional_school_code_4 IN VARCHAR2 DEFAULT NULL,
1453 x_additional_school_code_5 IN VARCHAR2 DEFAULT NULL,
1454 x_additional_school_code_6 IN VARCHAR2 DEFAULT NULL,
1455 x_additional_school_code_7 IN VARCHAR2 DEFAULT NULL,
1456 x_additional_school_code_8 IN VARCHAR2 DEFAULT NULL,
1457 x_additional_school_code_9 IN VARCHAR2 DEFAULT NULL,
1458 x_additional_school_code_10 IN VARCHAR2 DEFAULT NULL,
1459 x_explanation_spec_circum IN VARCHAR2 DEFAULT NULL,
1460 x_signature_student IN VARCHAR2 DEFAULT NULL,
1461 x_signature_spouse IN VARCHAR2 DEFAULT NULL,
1462 x_signature_father IN VARCHAR2 DEFAULT NULL,
1463 x_signature_mother IN VARCHAR2 DEFAULT NULL,
1464 x_month_day_completed IN VARCHAR2 DEFAULT NULL,
1465 x_year_completed IN VARCHAR2 DEFAULT NULL,
1469 x_age_line_5 IN VARCHAR2 DEFAULT NULL,
1466 x_age_line_2 IN VARCHAR2 DEFAULT NULL,
1467 x_age_line_3 IN VARCHAR2 DEFAULT NULL,
1468 x_age_line_4 IN VARCHAR2 DEFAULT NULL,
1470 x_age_line_6 IN VARCHAR2 DEFAULT NULL,
1471 x_age_line_7 IN VARCHAR2 DEFAULT NULL,
1472 x_age_line_8 IN VARCHAR2 DEFAULT NULL,
1473 x_a_online_signature IN VARCHAR2 DEFAULT NULL,
1474 x_question_1_number IN VARCHAR2 DEFAULT NULL,
1475 x_question_1_size IN VARCHAR2 DEFAULT NULL,
1476 x_question_1_answer IN VARCHAR2 DEFAULT NULL,
1477 x_question_2_number IN VARCHAR2 DEFAULT NULL,
1478 x_question_2_size IN VARCHAR2 DEFAULT NULL,
1479 x_question_2_answer IN VARCHAR2 DEFAULT NULL,
1480 x_question_3_number IN VARCHAR2 DEFAULT NULL,
1481 x_question_3_size IN VARCHAR2 DEFAULT NULL,
1482 x_question_3_answer IN VARCHAR2 DEFAULT NULL,
1483 x_question_4_number IN VARCHAR2 DEFAULT NULL,
1484 x_question_4_size IN VARCHAR2 DEFAULT NULL,
1485 x_question_4_answer IN VARCHAR2 DEFAULT NULL,
1486 x_question_5_number IN VARCHAR2 DEFAULT NULL,
1487 x_question_5_size IN VARCHAR2 DEFAULT NULL,
1488 x_question_5_answer IN VARCHAR2 DEFAULT NULL,
1489 x_question_6_number IN VARCHAR2 DEFAULT NULL,
1490 x_question_6_size IN VARCHAR2 DEFAULT NULL,
1491 x_question_6_answer IN VARCHAR2 DEFAULT NULL,
1492 x_question_7_number IN VARCHAR2 DEFAULT NULL,
1493 x_question_7_size IN VARCHAR2 DEFAULT NULL,
1494 x_question_7_answer IN VARCHAR2 DEFAULT NULL,
1495 x_question_8_number IN VARCHAR2 DEFAULT NULL,
1496 x_question_8_size IN VARCHAR2 DEFAULT NULL,
1497 x_question_8_answer IN VARCHAR2 DEFAULT NULL,
1498 x_question_9_number IN VARCHAR2 DEFAULT NULL,
1499 x_question_9_size IN VARCHAR2 DEFAULT NULL,
1500 x_question_9_answer IN VARCHAR2 DEFAULT NULL,
1501 x_question_10_number IN VARCHAR2 DEFAULT NULL,
1502 x_question_10_size IN VARCHAR2 DEFAULT NULL,
1503 x_question_10_answer IN VARCHAR2 DEFAULT NULL,
1504 x_question_11_number IN VARCHAR2 DEFAULT NULL,
1505 x_question_11_size IN VARCHAR2 DEFAULT NULL,
1506 x_question_11_answer IN VARCHAR2 DEFAULT NULL,
1507 x_question_12_number IN VARCHAR2 DEFAULT NULL,
1508 x_question_12_size IN VARCHAR2 DEFAULT NULL,
1509 x_question_12_answer IN VARCHAR2 DEFAULT NULL,
1510 x_question_13_number IN VARCHAR2 DEFAULT NULL,
1511 x_question_13_size IN VARCHAR2 DEFAULT NULL,
1512 x_question_13_answer IN VARCHAR2 DEFAULT NULL,
1513 x_question_14_number IN VARCHAR2 DEFAULT NULL,
1514 x_question_14_size IN VARCHAR2 DEFAULT NULL,
1515 x_question_14_answer IN VARCHAR2 DEFAULT NULL,
1516 x_question_15_number IN VARCHAR2 DEFAULT NULL,
1517 x_question_15_size IN VARCHAR2 DEFAULT NULL,
1518 x_question_15_answer IN VARCHAR2 DEFAULT NULL,
1519 x_question_16_number IN VARCHAR2 DEFAULT NULL,
1520 x_question_16_size IN VARCHAR2 DEFAULT NULL,
1521 x_question_16_answer IN VARCHAR2 DEFAULT NULL,
1522 x_question_17_number IN VARCHAR2 DEFAULT NULL,
1523 x_question_17_size IN VARCHAR2 DEFAULT NULL,
1524 x_question_17_answer IN VARCHAR2 DEFAULT NULL,
1525 x_question_18_number IN VARCHAR2 DEFAULT NULL,
1526 x_question_18_size IN VARCHAR2 DEFAULT NULL,
1527 x_question_18_answer IN VARCHAR2 DEFAULT NULL,
1528 x_question_19_number IN VARCHAR2 DEFAULT NULL,
1529 x_question_19_size IN VARCHAR2 DEFAULT NULL,
1530 x_question_19_answer IN VARCHAR2 DEFAULT NULL,
1531 x_question_20_number IN VARCHAR2 DEFAULT NULL,
1532 x_question_20_size IN VARCHAR2 DEFAULT NULL,
1533 x_question_20_answer IN VARCHAR2 DEFAULT NULL,
1534 x_question_21_number IN VARCHAR2 DEFAULT NULL,
1535 x_question_21_size IN VARCHAR2 DEFAULT NULL,
1536 x_question_21_answer IN VARCHAR2 DEFAULT NULL,
1537 x_question_22_number IN VARCHAR2 DEFAULT NULL,
1538 x_question_22_size IN VARCHAR2 DEFAULT NULL,
1539 x_question_22_answer IN VARCHAR2 DEFAULT NULL,
1540 x_question_23_number IN VARCHAR2 DEFAULT NULL,
1541 x_question_23_size IN VARCHAR2 DEFAULT NULL,
1542 x_question_23_answer IN VARCHAR2 DEFAULT NULL,
1543 x_question_24_number IN VARCHAR2 DEFAULT NULL,
1544 x_question_24_size IN VARCHAR2 DEFAULT NULL,
1545 x_question_24_answer IN VARCHAR2 DEFAULT NULL,
1546 x_question_25_number IN VARCHAR2 DEFAULT NULL,
1547 x_question_25_size IN VARCHAR2 DEFAULT NULL,
1548 x_question_25_answer IN VARCHAR2 DEFAULT NULL,
1549 x_question_26_number IN VARCHAR2 DEFAULT NULL,
1550 x_question_26_size IN VARCHAR2 DEFAULT NULL,
1551 x_question_26_answer IN VARCHAR2 DEFAULT NULL,
1552 x_question_27_number IN VARCHAR2 DEFAULT NULL,
1553 x_question_27_size IN VARCHAR2 DEFAULT NULL,
1554 x_question_27_answer IN VARCHAR2 DEFAULT NULL,
1555 x_question_28_number IN VARCHAR2 DEFAULT NULL,
1556 x_question_28_size IN VARCHAR2 DEFAULT NULL,
1557 x_question_28_answer IN VARCHAR2 DEFAULT NULL,
1558 x_question_29_number IN VARCHAR2 DEFAULT NULL,
1559 x_question_29_size IN VARCHAR2 DEFAULT NULL,
1560 x_question_29_answer IN VARCHAR2 DEFAULT NULL,
1561 x_question_30_number IN VARCHAR2 DEFAULT NULL,
1562 x_questions_30_size IN VARCHAR2 DEFAULT NULL,
1563 x_question_30_answer IN VARCHAR2 DEFAULT NULL,
1564 x_creation_date IN DATE DEFAULT NULL,
1565 x_created_by IN NUMBER DEFAULT NULL,
1566 x_last_update_date IN DATE DEFAULT NULL,
1567 x_last_updated_by IN NUMBER DEFAULT NULL,
1568 x_last_update_login IN NUMBER DEFAULT NULL
1569 );
1570
1571 END igf_ap_cs_upd_flags_pkg;