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