1 PACKAGE igf_ap_isir_matched_pkg AS
2 /* $Header: IGFAI09S.pls 120.0 2005/06/01 15:50:15 appldev noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_isir_id IN OUT NOCOPY NUMBER,
7 x_base_id IN NUMBER,
8 x_batch_year IN NUMBER,
9 x_transaction_num IN VARCHAR2,
10 x_current_ssn IN VARCHAR2,
11 x_ssn_name_change IN VARCHAR2,
12 x_original_ssn IN VARCHAR2,
13 x_orig_name_id IN VARCHAR2,
14 x_last_name IN VARCHAR2,
15 x_first_name IN VARCHAR2,
16 x_middle_initial IN VARCHAR2,
17 x_perm_mail_add IN VARCHAR2,
18 x_perm_city IN VARCHAR2,
19 x_perm_state IN VARCHAR2,
20 x_perm_zip_code IN VARCHAR2,
21 x_date_of_birth IN DATE,
22 x_phone_number IN VARCHAR2,
23 x_driver_license_number IN VARCHAR2,
24 x_driver_license_state IN VARCHAR2,
25 x_citizenship_status IN VARCHAR2,
26 x_alien_reg_number IN VARCHAR2,
27 x_s_marital_status IN VARCHAR2,
28 x_s_marital_status_date IN DATE,
29 x_summ_enrl_status IN VARCHAR2,
30 x_fall_enrl_status IN VARCHAR2,
31 x_winter_enrl_status IN VARCHAR2,
32 x_spring_enrl_status IN VARCHAR2,
33 x_summ2_enrl_status IN VARCHAR2,
34 x_fathers_highest_edu_level IN VARCHAR2,
35 x_mothers_highest_edu_level IN VARCHAR2,
36 x_s_state_legal_residence IN VARCHAR2,
37 x_legal_residence_before_date IN VARCHAR2,
38 x_s_legal_resd_date IN DATE,
39 x_ss_r_u_male IN VARCHAR2,
40 x_selective_service_reg IN VARCHAR2,
41 x_degree_certification IN VARCHAR2,
42 x_grade_level_in_college IN VARCHAR2,
43 x_high_school_diploma_ged IN VARCHAR2,
44 x_first_bachelor_deg_by_date IN VARCHAR2,
45 x_interest_in_loan IN VARCHAR2,
46 x_interest_in_stud_employment IN VARCHAR2,
47 x_drug_offence_conviction IN VARCHAR2,
48 x_s_tax_return_status IN VARCHAR2,
49 x_s_type_tax_return IN VARCHAR2,
50 x_s_elig_1040ez IN VARCHAR2,
51 x_s_adjusted_gross_income IN NUMBER,
52 x_s_fed_taxes_paid IN NUMBER,
53 x_s_exemptions IN NUMBER,
54 x_s_income_from_work IN NUMBER,
55 x_spouse_income_from_work IN NUMBER,
56 x_s_toa_amt_from_wsa IN NUMBER,
57 x_s_toa_amt_from_wsb IN NUMBER,
58 x_s_toa_amt_from_wsc IN NUMBER,
59 x_s_investment_networth IN NUMBER,
60 x_s_busi_farm_networth IN NUMBER,
61 x_s_cash_savings IN NUMBER,
62 x_va_months IN NUMBER,
63 x_va_amount IN NUMBER,
64 x_stud_dob_before_date IN VARCHAR2,
65 x_deg_beyond_bachelor IN VARCHAR2,
66 x_s_married IN VARCHAR2,
67 x_s_have_children IN VARCHAR2,
68 x_legal_dependents IN VARCHAR2,
69 x_orphan_ward_of_court IN VARCHAR2,
70 x_s_veteran IN VARCHAR2,
71 x_p_marital_status IN VARCHAR2,
72 x_father_ssn IN VARCHAR2,
73 x_f_last_name IN VARCHAR2,
74 x_mother_ssn IN VARCHAR2,
75 x_m_last_name IN VARCHAR2,
76 x_p_num_family_member IN NUMBER,
77 x_p_num_in_college IN NUMBER,
78 x_p_state_legal_residence IN VARCHAR2,
79 x_p_state_legal_res_before_dt IN VARCHAR2,
80 x_p_legal_res_date IN DATE,
81 x_age_older_parent IN NUMBER,
82 x_p_tax_return_status IN VARCHAR2,
83 x_p_type_tax_return IN VARCHAR2,
84 x_p_elig_1040aez IN VARCHAR2,
85 x_p_adjusted_gross_income IN NUMBER,
86 x_p_taxes_paid IN NUMBER,
87 x_p_exemptions IN NUMBER,
88 x_f_income_work IN NUMBER,
89 x_m_income_work IN NUMBER,
90 x_p_income_wsa IN NUMBER,
91 x_p_income_wsb IN NUMBER,
92 x_p_income_wsc IN NUMBER,
93 x_p_investment_networth IN NUMBER,
94 x_p_business_networth IN NUMBER,
95 x_p_cash_saving IN NUMBER,
96 x_s_num_family_members IN NUMBER,
97 x_s_num_in_college IN NUMBER,
98 x_first_college IN VARCHAR2,
99 x_first_house_plan IN VARCHAR2,
100 x_second_college IN VARCHAR2,
101 x_second_house_plan IN VARCHAR2,
102 x_third_college IN VARCHAR2,
103 x_third_house_plan IN VARCHAR2,
104 x_fourth_college IN VARCHAR2,
105 x_fourth_house_plan IN VARCHAR2,
106 x_fifth_college IN VARCHAR2,
107 x_fifth_house_plan IN VARCHAR2,
108 x_sixth_college IN VARCHAR2,
109 x_sixth_house_plan IN VARCHAR2,
110 x_date_app_completed IN DATE,
111 x_signed_by IN VARCHAR2,
112 x_preparer_ssn IN VARCHAR2,
113 x_preparer_emp_id_number IN VARCHAR2,
114 x_preparer_sign IN VARCHAR2,
115 x_transaction_receipt_date IN DATE,
116 x_dependency_override_ind IN VARCHAR2,
117 x_faa_fedral_schl_code IN VARCHAR2,
118 x_faa_adjustment IN VARCHAR2,
119 x_input_record_type IN VARCHAR2,
120 x_serial_number IN NUMBER,
121 x_batch_number IN VARCHAR2,
122 x_early_analysis_flag IN VARCHAR2,
123 x_app_entry_source_code IN VARCHAR2,
124 x_eti_destination_code IN VARCHAR2,
125 x_reject_override_b IN VARCHAR2,
126 x_reject_override_n IN VARCHAR2,
127 x_reject_override_w IN VARCHAR2,
128 x_assum_override_1 IN VARCHAR2,
129 x_assum_override_2 IN VARCHAR2,
130 x_assum_override_3 IN VARCHAR2,
131 x_assum_override_4 IN VARCHAR2,
132 x_assum_override_5 IN VARCHAR2,
133 x_assum_override_6 IN VARCHAR2,
134 x_dependency_status IN VARCHAR2,
135 x_s_email_address IN VARCHAR2,
136 x_nslds_reason_code IN VARCHAR2,
137 x_app_receipt_date IN DATE,
138 x_processed_rec_type IN VARCHAR2,
139 x_hist_correction_for_tran_id IN NUMBER,
140 x_system_generated_indicator IN VARCHAR2,
141 x_dup_request_indicator IN VARCHAR2,
142 x_source_of_correction IN VARCHAR2,
143 x_p_cal_tax_status IN VARCHAR2,
144 x_s_cal_tax_status IN VARCHAR2,
145 x_graduate_flag IN VARCHAR2,
146 x_auto_zero_efc IN VARCHAR2,
147 x_efc_change_flag IN VARCHAR2,
148 x_sarc_flag IN VARCHAR2,
149 x_simplified_need_test IN VARCHAR2,
150 x_reject_reason_codes IN VARCHAR2,
151 x_select_service_match_flag IN VARCHAR2,
152 x_select_service_reg_flag IN VARCHAR2,
153 x_ins_match_flag IN VARCHAR2,
154 x_ins_verification_number IN NUMBER DEFAULT NULL,
155 x_sec_ins_match_flag IN VARCHAR2,
156 x_sec_ins_ver_number IN NUMBER,
157 x_ssn_match_flag IN VARCHAR2,
158 x_ssa_citizenship_flag IN VARCHAR2,
159 x_ssn_date_of_death IN DATE,
160 x_nslds_match_flag IN VARCHAR2,
161 x_va_match_flag IN VARCHAR2,
162 x_prisoner_match IN VARCHAR2,
163 x_verification_flag IN VARCHAR2,
164 x_subsequent_app_flag IN VARCHAR2,
165 x_app_source_site_code IN VARCHAR2,
166 x_tran_source_site_code IN VARCHAR2,
167 x_drn IN NUMBER,
168 x_tran_process_date IN DATE,
169 x_computer_batch_number IN NUMBER,
170 x_correction_flags IN VARCHAR2,
171 x_highlight_flags IN VARCHAR2,
172 x_paid_efc IN NUMBER,
173 x_primary_efc IN NUMBER,
174 x_secondary_efc IN NUMBER,
175 x_fed_pell_grant_efc_type IN VARCHAR2,
176 x_primary_efc_type IN VARCHAR2,
177 x_sec_efc_type IN VARCHAR2,
178 x_primary_alternate_month_1 IN NUMBER,
179 x_primary_alternate_month_2 IN NUMBER,
180 x_primary_alternate_month_3 IN NUMBER,
181 x_primary_alternate_month_4 IN NUMBER,
182 x_primary_alternate_month_5 IN NUMBER,
183 x_primary_alternate_month_6 IN NUMBER,
184 x_primary_alternate_month_7 IN NUMBER,
185 x_primary_alternate_month_8 IN NUMBER,
186 x_primary_alternate_month_10 IN NUMBER,
187 x_primary_alternate_month_11 IN NUMBER,
188 x_primary_alternate_month_12 IN NUMBER,
189 x_sec_alternate_month_1 IN NUMBER,
190 x_sec_alternate_month_2 IN NUMBER,
191 x_sec_alternate_month_3 IN NUMBER,
192 x_sec_alternate_month_4 IN NUMBER,
193 x_sec_alternate_month_5 IN NUMBER,
194 x_sec_alternate_month_6 IN NUMBER,
195 x_sec_alternate_month_7 IN NUMBER,
196 x_sec_alternate_month_8 IN NUMBER,
197 x_sec_alternate_month_10 IN NUMBER,
198 x_sec_alternate_month_11 IN NUMBER,
199 x_sec_alternate_month_12 IN NUMBER,
200 x_total_income IN NUMBER,
201 x_allow_total_income IN NUMBER,
202 x_state_tax_allow IN NUMBER,
203 x_employment_allow IN NUMBER,
204 x_income_protection_allow IN NUMBER,
205 x_available_income IN NUMBER,
206 x_contribution_from_ai IN NUMBER,
207 x_discretionary_networth IN NUMBER,
208 x_efc_networth IN NUMBER,
209 x_asset_protect_allow IN NUMBER,
210 x_parents_cont_from_assets IN NUMBER,
211 x_adjusted_available_income IN NUMBER,
212 x_total_student_contribution IN NUMBER,
213 x_total_parent_contribution IN NUMBER,
214 x_parents_contribution IN NUMBER,
215 x_student_total_income IN NUMBER,
216 x_sati IN NUMBER,
217 x_sic IN NUMBER,
218 x_sdnw IN NUMBER,
219 x_sca IN NUMBER,
220 x_fti IN NUMBER,
221 x_secti IN NUMBER,
222 x_secati IN NUMBER,
223 x_secstx IN NUMBER,
224 x_secea IN NUMBER,
225 x_secipa IN NUMBER,
226 x_secai IN NUMBER,
227 x_seccai IN NUMBER,
228 x_secdnw IN NUMBER,
229 x_secnw IN NUMBER,
230 x_secapa IN NUMBER,
231 x_secpca IN NUMBER,
232 x_secaai IN NUMBER,
233 x_sectsc IN NUMBER,
234 x_sectpc IN NUMBER,
235 x_secpc IN NUMBER,
236 x_secsti IN NUMBER,
237 x_secsic IN NUMBER,
238 x_secsati IN NUMBER,
239 x_secsdnw IN NUMBER,
240 x_secsca IN NUMBER,
241 x_secfti IN NUMBER,
242 x_a_citizenship IN VARCHAR2,
243 x_a_student_marital_status IN VARCHAR2,
244 x_a_student_agi IN NUMBER,
245 x_a_s_us_tax_paid IN NUMBER,
246 x_a_s_income_work IN NUMBER,
247 x_a_spouse_income_work IN NUMBER,
248 x_a_s_total_wsc IN NUMBER,
249 x_a_date_of_birth IN VARCHAR2,
250 x_a_student_married IN VARCHAR2,
251 x_a_have_children IN VARCHAR2,
252 x_a_s_have_dependents IN VARCHAR2,
253 x_a_va_status IN VARCHAR2,
254 x_a_s_num_in_family IN NUMBER,
255 x_a_s_num_in_college IN NUMBER,
256 x_a_p_marital_status IN VARCHAR2,
257 x_a_father_ssn IN VARCHAR2,
258 x_a_mother_ssn IN VARCHAR2,
259 x_a_parents_num_family IN NUMBER,
260 x_a_parents_num_college IN NUMBER,
261 x_a_parents_agi IN NUMBER,
262 x_a_p_us_tax_paid IN NUMBER,
263 x_a_f_work_income IN NUMBER,
264 x_a_m_work_income IN NUMBER,
265 x_a_p_total_wsc IN NUMBER,
266 x_comment_codes IN VARCHAR2,
267 x_sar_ack_comm_code IN VARCHAR2,
268 x_pell_grant_elig_flag IN VARCHAR2,
269 x_reprocess_reason_code IN VARCHAR2,
270 x_duplicate_date IN DATE,
271 x_isir_transaction_type IN VARCHAR2,
272 x_fedral_schl_code_indicator IN VARCHAR2,
273 x_multi_school_code_flags IN VARCHAR2,
274 x_dup_ssn_indicator IN VARCHAR2,
275 x_payment_isir IN VARCHAR2,
276 x_receipt_status IN VARCHAR2,
277 x_isir_receipt_completed IN VARCHAR2,
278 x_mode IN VARCHAR2 DEFAULT 'R',
279 x_system_record_type IN VARCHAR2 DEFAULT NULL,
280 x_verif_track_flag IN VARCHAR2 DEFAULT NULL,
281 x_active_isir IN VARCHAR2 DEFAULT NULL,
282 x_fafsa_data_verify_flags IN VARCHAR2 DEFAULT NULL,
283 x_reject_override_a IN VARCHAR2 DEFAULT NULL,
284 x_reject_override_c IN VARCHAR2 DEFAULT NULL,
285 x_parent_marital_status_date IN DATE DEFAULT NULL,
286 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
287 x_father_first_name_initial IN VARCHAR2 DEFAULT NULL,
288 x_father_step_father_birth_dt IN DATE DEFAULT NULL,
289 x_mother_first_name_initial IN VARCHAR2 DEFAULT NULL,
290 x_mother_step_mother_birth_dt IN DATE DEFAULT NULL,
294 x_electronic_transaction_type IN VARCHAR2 DEFAULT NULL,
291 x_parents_email_address_txt IN VARCHAR2 DEFAULT NULL,
292 x_address_change_type IN VARCHAR2 DEFAULT NULL,
293 x_cps_pushed_isir_flag IN VARCHAR2 DEFAULT NULL,
295 x_sar_c_change_type IN VARCHAR2 DEFAULT NULL,
296 x_father_ssn_match_type IN VARCHAR2 DEFAULT NULL,
297 x_mother_ssn_match_type IN VARCHAR2 DEFAULT NULL,
298 x_reject_override_g_flag IN VARCHAR2 DEFAULT NULL,
299 x_dhs_verification_num_txt IN VARCHAR2 DEFAULT NULL,
300 x_data_file_name_txt IN VARCHAR2 DEFAULT NULL,
301 x_message_class_txt IN VARCHAR2 DEFAULT NULL,
302 x_reject_override_3_flag IN VARCHAR2 DEFAULT NULL,
303 x_reject_override_12_flag IN VARCHAR2 DEFAULT NULL,
304 x_reject_override_j_flag IN VARCHAR2 DEFAULT NULL,
305 x_reject_override_k_flag IN VARCHAR2 DEFAULT NULL,
306 x_rejected_status_change_flag IN VARCHAR2 DEFAULT NULL,
307 x_verification_selection_flag IN VARCHAR2 DEFAULT NULL
308 );
309
310 PROCEDURE lock_row (
311 x_rowid IN VARCHAR2,
312 x_isir_id IN NUMBER,
313 x_base_id IN NUMBER,
314 x_batch_year IN NUMBER,
315 x_transaction_num IN VARCHAR2,
316 x_current_ssn IN VARCHAR2,
317 x_ssn_name_change IN VARCHAR2,
318 x_original_ssn IN VARCHAR2,
319 x_orig_name_id IN VARCHAR2,
320 x_last_name IN VARCHAR2,
321 x_first_name IN VARCHAR2,
322 x_middle_initial IN VARCHAR2,
323 x_perm_mail_add IN VARCHAR2,
324 x_perm_city IN VARCHAR2,
325 x_perm_state IN VARCHAR2,
326 x_perm_zip_code IN VARCHAR2,
327 x_date_of_birth IN DATE,
328 x_phone_number IN VARCHAR2,
329 x_driver_license_number IN VARCHAR2,
330 x_driver_license_state IN VARCHAR2,
331 x_citizenship_status IN VARCHAR2,
332 x_alien_reg_number IN VARCHAR2,
333 x_s_marital_status IN VARCHAR2,
334 x_s_marital_status_date IN DATE,
335 x_summ_enrl_status IN VARCHAR2,
336 x_fall_enrl_status IN VARCHAR2,
337 x_winter_enrl_status IN VARCHAR2,
338 x_spring_enrl_status IN VARCHAR2,
339 x_summ2_enrl_status IN VARCHAR2,
340 x_fathers_highest_edu_level IN VARCHAR2,
341 x_mothers_highest_edu_level IN VARCHAR2,
342 x_s_state_legal_residence IN VARCHAR2,
343 x_legal_residence_before_date IN VARCHAR2,
344 x_s_legal_resd_date IN DATE,
345 x_ss_r_u_male IN VARCHAR2,
346 x_selective_service_reg IN VARCHAR2,
347 x_degree_certification IN VARCHAR2,
348 x_grade_level_in_college IN VARCHAR2,
349 x_high_school_diploma_ged IN VARCHAR2,
350 x_first_bachelor_deg_by_date IN VARCHAR2,
351 x_interest_in_loan IN VARCHAR2,
352 x_interest_in_stud_employment IN VARCHAR2,
353 x_drug_offence_conviction IN VARCHAR2,
354 x_s_tax_return_status IN VARCHAR2,
355 x_s_type_tax_return IN VARCHAR2,
356 x_s_elig_1040ez IN VARCHAR2,
357 x_s_adjusted_gross_income IN NUMBER,
358 x_s_fed_taxes_paid IN NUMBER,
359 x_s_exemptions IN NUMBER,
360 x_s_income_from_work IN NUMBER,
361 x_spouse_income_from_work IN NUMBER,
362 x_s_toa_amt_from_wsa IN NUMBER,
363 x_s_toa_amt_from_wsb IN NUMBER,
364 x_s_toa_amt_from_wsc IN NUMBER,
365 x_s_investment_networth IN NUMBER,
366 x_s_busi_farm_networth IN NUMBER,
367 x_s_cash_savings IN NUMBER,
368 x_va_months IN NUMBER,
369 x_va_amount IN NUMBER,
370 x_stud_dob_before_date IN VARCHAR2,
371 x_deg_beyond_bachelor IN VARCHAR2,
372 x_s_married IN VARCHAR2,
373 x_s_have_children IN VARCHAR2,
374 x_legal_dependents IN VARCHAR2,
375 x_orphan_ward_of_court IN VARCHAR2,
376 x_s_veteran IN VARCHAR2,
377 x_p_marital_status IN VARCHAR2,
378 x_father_ssn IN VARCHAR2,
379 x_f_last_name IN VARCHAR2,
380 x_mother_ssn IN VARCHAR2,
381 x_m_last_name IN VARCHAR2,
382 x_p_num_family_member IN NUMBER,
383 x_p_num_in_college IN NUMBER,
384 x_p_state_legal_residence IN VARCHAR2,
388 x_p_tax_return_status IN VARCHAR2,
385 x_p_state_legal_res_before_dt IN VARCHAR2,
386 x_p_legal_res_date IN DATE,
387 x_age_older_parent IN NUMBER,
389 x_p_type_tax_return IN VARCHAR2,
390 x_p_elig_1040aez IN VARCHAR2,
391 x_p_adjusted_gross_income IN NUMBER,
392 x_p_taxes_paid IN NUMBER,
393 x_p_exemptions IN NUMBER,
394 x_f_income_work IN NUMBER,
395 x_m_income_work IN NUMBER,
396 x_p_income_wsa IN NUMBER,
397 x_p_income_wsb IN NUMBER,
398 x_p_income_wsc IN NUMBER,
399 x_p_investment_networth IN NUMBER,
400 x_p_business_networth IN NUMBER,
401 x_p_cash_saving IN NUMBER,
402 x_s_num_family_members IN NUMBER,
403 x_s_num_in_college IN NUMBER,
404 x_first_college IN VARCHAR2,
405 x_first_house_plan IN VARCHAR2,
406 x_second_college IN VARCHAR2,
407 x_second_house_plan IN VARCHAR2,
408 x_third_college IN VARCHAR2,
409 x_third_house_plan IN VARCHAR2,
410 x_fourth_college IN VARCHAR2,
411 x_fourth_house_plan IN VARCHAR2,
412 x_fifth_college IN VARCHAR2,
413 x_fifth_house_plan IN VARCHAR2,
414 x_sixth_college IN VARCHAR2,
415 x_sixth_house_plan IN VARCHAR2,
416 x_date_app_completed IN DATE,
417 x_signed_by IN VARCHAR2,
418 x_preparer_ssn IN VARCHAR2,
419 x_preparer_emp_id_number IN VARCHAR2,
420 x_preparer_sign IN VARCHAR2,
421 x_transaction_receipt_date IN DATE,
422 x_dependency_override_ind IN VARCHAR2,
423 x_faa_fedral_schl_code IN VARCHAR2,
424 x_faa_adjustment IN VARCHAR2,
425 x_input_record_type IN VARCHAR2,
426 x_serial_number IN NUMBER,
427 x_batch_number IN VARCHAR2,
428 x_early_analysis_flag IN VARCHAR2,
429 x_app_entry_source_code IN VARCHAR2,
430 x_eti_destination_code IN VARCHAR2,
431 x_reject_override_b IN VARCHAR2,
432 x_reject_override_n IN VARCHAR2,
433 x_reject_override_w IN VARCHAR2,
434 x_assum_override_1 IN VARCHAR2,
435 x_assum_override_2 IN VARCHAR2,
436 x_assum_override_3 IN VARCHAR2,
437 x_assum_override_4 IN VARCHAR2,
438 x_assum_override_5 IN VARCHAR2,
439 x_assum_override_6 IN VARCHAR2,
440 x_dependency_status IN VARCHAR2,
441 x_s_email_address IN VARCHAR2,
442 x_nslds_reason_code IN VARCHAR2,
443 x_app_receipt_date IN DATE,
444 x_processed_rec_type IN VARCHAR2,
445 x_hist_correction_for_tran_id IN NUMBER,
446 x_system_generated_indicator IN VARCHAR2,
447 x_dup_request_indicator IN VARCHAR2,
448 x_source_of_correction IN VARCHAR2,
449 x_p_cal_tax_status IN VARCHAR2,
450 x_s_cal_tax_status IN VARCHAR2,
451 x_graduate_flag IN VARCHAR2,
452 x_auto_zero_efc IN VARCHAR2,
453 x_efc_change_flag IN VARCHAR2,
454 x_sarc_flag IN VARCHAR2,
455 x_simplified_need_test IN VARCHAR2,
456 x_reject_reason_codes IN VARCHAR2,
457 x_select_service_match_flag IN VARCHAR2,
458 x_select_service_reg_flag IN VARCHAR2,
459 x_ins_match_flag IN VARCHAR2,
460 x_ins_verification_number IN NUMBER DEFAULT NULL,
461 x_sec_ins_match_flag IN VARCHAR2,
462 x_sec_ins_ver_number IN NUMBER,
463 x_ssn_match_flag IN VARCHAR2,
464 x_ssa_citizenship_flag IN VARCHAR2,
465 x_ssn_date_of_death IN DATE,
466 x_nslds_match_flag IN VARCHAR2,
467 x_va_match_flag IN VARCHAR2,
468 x_prisoner_match IN VARCHAR2,
469 x_verification_flag IN VARCHAR2,
470 x_subsequent_app_flag IN VARCHAR2,
471 x_app_source_site_code IN VARCHAR2,
472 x_tran_source_site_code IN VARCHAR2,
473 x_drn IN NUMBER,
474 x_tran_process_date IN DATE,
475 x_computer_batch_number IN NUMBER,
476 x_correction_flags IN VARCHAR2,
477 x_highlight_flags IN VARCHAR2,
478 x_paid_efc IN NUMBER,
479 x_primary_efc IN NUMBER,
483 x_sec_efc_type IN VARCHAR2,
480 x_secondary_efc IN NUMBER,
481 x_fed_pell_grant_efc_type IN VARCHAR2,
482 x_primary_efc_type IN VARCHAR2,
484 x_primary_alternate_month_1 IN NUMBER,
485 x_primary_alternate_month_2 IN NUMBER,
486 x_primary_alternate_month_3 IN NUMBER,
487 x_primary_alternate_month_4 IN NUMBER,
488 x_primary_alternate_month_5 IN NUMBER,
489 x_primary_alternate_month_6 IN NUMBER,
490 x_primary_alternate_month_7 IN NUMBER,
491 x_primary_alternate_month_8 IN NUMBER,
492 x_primary_alternate_month_10 IN NUMBER,
493 x_primary_alternate_month_11 IN NUMBER,
494 x_primary_alternate_month_12 IN NUMBER,
495 x_sec_alternate_month_1 IN NUMBER,
496 x_sec_alternate_month_2 IN NUMBER,
497 x_sec_alternate_month_3 IN NUMBER,
498 x_sec_alternate_month_4 IN NUMBER,
499 x_sec_alternate_month_5 IN NUMBER,
500 x_sec_alternate_month_6 IN NUMBER,
501 x_sec_alternate_month_7 IN NUMBER,
502 x_sec_alternate_month_8 IN NUMBER,
503 x_sec_alternate_month_10 IN NUMBER,
504 x_sec_alternate_month_11 IN NUMBER,
505 x_sec_alternate_month_12 IN NUMBER,
506 x_total_income IN NUMBER,
507 x_allow_total_income IN NUMBER,
508 x_state_tax_allow IN NUMBER,
509 x_employment_allow IN NUMBER,
510 x_income_protection_allow IN NUMBER,
511 x_available_income IN NUMBER,
512 x_contribution_from_ai IN NUMBER,
513 x_discretionary_networth IN NUMBER,
514 x_efc_networth IN NUMBER,
515 x_asset_protect_allow IN NUMBER,
516 x_parents_cont_from_assets IN NUMBER,
517 x_adjusted_available_income IN NUMBER,
518 x_total_student_contribution IN NUMBER,
519 x_total_parent_contribution IN NUMBER,
520 x_parents_contribution IN NUMBER,
521 x_student_total_income IN NUMBER,
522 x_sati IN NUMBER,
523 x_sic IN NUMBER,
524 x_sdnw IN NUMBER,
525 x_sca IN NUMBER,
526 x_fti IN NUMBER,
527 x_secti IN NUMBER,
528 x_secati IN NUMBER,
529 x_secstx IN NUMBER,
530 x_secea IN NUMBER,
531 x_secipa IN NUMBER,
532 x_secai IN NUMBER,
533 x_seccai IN NUMBER,
534 x_secdnw IN NUMBER,
535 x_secnw IN NUMBER,
536 x_secapa IN NUMBER,
537 x_secpca IN NUMBER,
538 x_secaai IN NUMBER,
539 x_sectsc IN NUMBER,
540 x_sectpc IN NUMBER,
541 x_secpc IN NUMBER,
542 x_secsti IN NUMBER,
543 x_secsic IN NUMBER,
544 x_secsati IN NUMBER,
545 x_secsdnw IN NUMBER,
546 x_secsca IN NUMBER,
547 x_secfti IN NUMBER,
548 x_a_citizenship IN VARCHAR2,
549 x_a_student_marital_status IN VARCHAR2,
550 x_a_student_agi IN NUMBER,
551 x_a_s_us_tax_paid IN NUMBER,
552 x_a_s_income_work IN NUMBER,
553 x_a_spouse_income_work IN NUMBER,
554 x_a_s_total_wsc IN NUMBER,
555 x_a_date_of_birth IN VARCHAR2,
556 x_a_student_married IN VARCHAR2,
557 x_a_have_children IN VARCHAR2,
558 x_a_s_have_dependents IN VARCHAR2,
559 x_a_va_status IN VARCHAR2,
560 x_a_s_num_in_family IN NUMBER,
561 x_a_s_num_in_college IN NUMBER,
562 x_a_p_marital_status IN VARCHAR2,
563 x_a_father_ssn IN VARCHAR2,
564 x_a_mother_ssn IN VARCHAR2,
565 x_a_parents_num_family IN NUMBER,
566 x_a_parents_num_college IN NUMBER,
567 x_a_parents_agi IN NUMBER,
568 x_a_p_us_tax_paid IN NUMBER,
569 x_a_f_work_income IN NUMBER,
570 x_a_m_work_income IN NUMBER,
571 x_a_p_total_wsc IN NUMBER,
572 x_comment_codes IN VARCHAR2,
573 x_sar_ack_comm_code IN VARCHAR2,
574 x_pell_grant_elig_flag IN VARCHAR2,
575 x_reprocess_reason_code IN VARCHAR2,
576 x_duplicate_date IN DATE,
580 x_dup_ssn_indicator IN VARCHAR2,
577 x_isir_transaction_type IN VARCHAR2,
578 x_fedral_schl_code_indicator IN VARCHAR2,
579 x_multi_school_code_flags IN VARCHAR2,
581 x_payment_isir IN VARCHAR2,
582 x_receipt_status IN VARCHAR2,
583 x_isir_receipt_completed IN VARCHAR2,
584 x_system_record_type IN VARCHAR2,
585 x_verif_track_flag IN VARCHAR2 DEFAULT NULL,
586 x_active_isir IN VARCHAR2 DEFAULT NULL,
587 x_fafsa_data_verify_flags IN VARCHAR2 DEFAULT NULL,
588 x_reject_override_a IN VARCHAR2 DEFAULT NULL,
589 x_reject_override_c IN VARCHAR2 DEFAULT NULL,
590 x_parent_marital_status_date IN DATE DEFAULT NULL,
591 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
592 x_father_first_name_initial IN VARCHAR2 DEFAULT NULL,
593 x_father_step_father_birth_dt IN DATE DEFAULT NULL,
594 x_mother_first_name_initial IN VARCHAR2 DEFAULT NULL,
595 x_mother_step_mother_birth_dt IN DATE DEFAULT NULL,
596 x_parents_email_address_txt IN VARCHAR2 DEFAULT NULL,
597 x_address_change_type IN VARCHAR2 DEFAULT NULL,
598 x_cps_pushed_isir_flag IN VARCHAR2 DEFAULT NULL,
599 x_electronic_transaction_type IN VARCHAR2 DEFAULT NULL,
600 x_sar_c_change_type IN VARCHAR2 DEFAULT NULL,
601 x_father_ssn_match_type IN VARCHAR2 DEFAULT NULL,
602 x_mother_ssn_match_type IN VARCHAR2 DEFAULT NULL,
603 x_reject_override_g_flag IN VARCHAR2 DEFAULT NULL,
604 x_dhs_verification_num_txt IN VARCHAR2 DEFAULT NULL,
605 x_data_file_name_txt IN VARCHAR2 DEFAULT NULL,
606 x_message_class_txt IN VARCHAR2 DEFAULT NULL,
607 x_reject_override_3_flag IN VARCHAR2 DEFAULT NULL,
608 x_reject_override_12_flag IN VARCHAR2 DEFAULT NULL,
609 x_reject_override_j_flag IN VARCHAR2 DEFAULT NULL,
610 x_reject_override_k_flag IN VARCHAR2 DEFAULT NULL,
611 x_rejected_status_change_flag IN VARCHAR2 DEFAULT NULL,
612 x_verification_selection_flag IN VARCHAR2 DEFAULT NULL
613 );
614
615 PROCEDURE update_row (
616 x_rowid IN VARCHAR2,
617 x_isir_id IN NUMBER,
618 x_base_id IN NUMBER,
619 x_batch_year IN NUMBER,
620 x_transaction_num IN VARCHAR2,
621 x_current_ssn IN VARCHAR2,
622 x_ssn_name_change IN VARCHAR2,
623 x_original_ssn IN VARCHAR2,
624 x_orig_name_id IN VARCHAR2,
625 x_last_name IN VARCHAR2,
626 x_first_name IN VARCHAR2,
627 x_middle_initial IN VARCHAR2,
628 x_perm_mail_add IN VARCHAR2,
629 x_perm_city IN VARCHAR2,
630 x_perm_state IN VARCHAR2,
631 x_perm_zip_code IN VARCHAR2,
632 x_date_of_birth IN DATE,
633 x_phone_number IN VARCHAR2,
634 x_driver_license_number IN VARCHAR2,
635 x_driver_license_state IN VARCHAR2,
636 x_citizenship_status IN VARCHAR2,
637 x_alien_reg_number IN VARCHAR2,
638 x_s_marital_status IN VARCHAR2,
639 x_s_marital_status_date IN DATE,
640 x_summ_enrl_status IN VARCHAR2,
641 x_fall_enrl_status IN VARCHAR2,
642 x_winter_enrl_status IN VARCHAR2,
643 x_spring_enrl_status IN VARCHAR2,
644 x_summ2_enrl_status IN VARCHAR2,
645 x_fathers_highest_edu_level IN VARCHAR2,
646 x_mothers_highest_edu_level IN VARCHAR2,
647 x_s_state_legal_residence IN VARCHAR2,
648 x_legal_residence_before_date IN VARCHAR2,
649 x_s_legal_resd_date IN DATE,
650 x_ss_r_u_male IN VARCHAR2,
651 x_selective_service_reg IN VARCHAR2,
652 x_degree_certification IN VARCHAR2,
653 x_grade_level_in_college IN VARCHAR2,
654 x_high_school_diploma_ged IN VARCHAR2,
655 x_first_bachelor_deg_by_date IN VARCHAR2,
656 x_interest_in_loan IN VARCHAR2,
657 x_interest_in_stud_employment IN VARCHAR2,
658 x_drug_offence_conviction IN VARCHAR2,
659 x_s_tax_return_status IN VARCHAR2,
660 x_s_type_tax_return IN VARCHAR2,
661 x_s_elig_1040ez IN VARCHAR2,
662 x_s_adjusted_gross_income IN NUMBER,
663 x_s_fed_taxes_paid IN NUMBER,
664 x_s_exemptions IN NUMBER,
665 x_s_income_from_work IN NUMBER,
666 x_spouse_income_from_work IN NUMBER,
667 x_s_toa_amt_from_wsa IN NUMBER,
671 x_s_busi_farm_networth IN NUMBER,
668 x_s_toa_amt_from_wsb IN NUMBER,
669 x_s_toa_amt_from_wsc IN NUMBER,
670 x_s_investment_networth IN NUMBER,
672 x_s_cash_savings IN NUMBER,
673 x_va_months IN NUMBER,
674 x_va_amount IN NUMBER,
675 x_stud_dob_before_date IN VARCHAR2,
676 x_deg_beyond_bachelor IN VARCHAR2,
677 x_s_married IN VARCHAR2,
678 x_s_have_children IN VARCHAR2,
679 x_legal_dependents IN VARCHAR2,
680 x_orphan_ward_of_court IN VARCHAR2,
681 x_s_veteran IN VARCHAR2,
682 x_p_marital_status IN VARCHAR2,
683 x_father_ssn IN VARCHAR2,
684 x_f_last_name IN VARCHAR2,
685 x_mother_ssn IN VARCHAR2,
686 x_m_last_name IN VARCHAR2,
687 x_p_num_family_member IN NUMBER,
688 x_p_num_in_college IN NUMBER,
689 x_p_state_legal_residence IN VARCHAR2,
690 x_p_state_legal_res_before_dt IN VARCHAR2,
691 x_p_legal_res_date IN DATE,
692 x_age_older_parent IN NUMBER,
693 x_p_tax_return_status IN VARCHAR2,
694 x_p_type_tax_return IN VARCHAR2,
695 x_p_elig_1040aez IN VARCHAR2,
696 x_p_adjusted_gross_income IN NUMBER,
697 x_p_taxes_paid IN NUMBER,
698 x_p_exemptions IN NUMBER,
699 x_f_income_work IN NUMBER,
700 x_m_income_work IN NUMBER,
701 x_p_income_wsa IN NUMBER,
702 x_p_income_wsb IN NUMBER,
703 x_p_income_wsc IN NUMBER,
704 x_p_investment_networth IN NUMBER,
705 x_p_business_networth IN NUMBER,
706 x_p_cash_saving IN NUMBER,
707 x_s_num_family_members IN NUMBER,
708 x_s_num_in_college IN NUMBER,
709 x_first_college IN VARCHAR2,
710 x_first_house_plan IN VARCHAR2,
711 x_second_college IN VARCHAR2,
712 x_second_house_plan IN VARCHAR2,
713 x_third_college IN VARCHAR2,
714 x_third_house_plan IN VARCHAR2,
715 x_fourth_college IN VARCHAR2,
716 x_fourth_house_plan IN VARCHAR2,
717 x_fifth_college IN VARCHAR2,
718 x_fifth_house_plan IN VARCHAR2,
719 x_sixth_college IN VARCHAR2,
720 x_sixth_house_plan IN VARCHAR2,
721 x_date_app_completed IN DATE,
722 x_signed_by IN VARCHAR2,
723 x_preparer_ssn IN VARCHAR2,
724 x_preparer_emp_id_number IN VARCHAR2,
725 x_preparer_sign IN VARCHAR2,
726 x_transaction_receipt_date IN DATE,
727 x_dependency_override_ind IN VARCHAR2,
728 x_faa_fedral_schl_code IN VARCHAR2,
729 x_faa_adjustment IN VARCHAR2,
730 x_input_record_type IN VARCHAR2,
731 x_serial_number IN NUMBER,
732 x_batch_number IN VARCHAR2,
733 x_early_analysis_flag IN VARCHAR2,
734 x_app_entry_source_code IN VARCHAR2,
735 x_eti_destination_code IN VARCHAR2,
736 x_reject_override_b IN VARCHAR2,
737 x_reject_override_n IN VARCHAR2,
738 x_reject_override_w IN VARCHAR2,
739 x_assum_override_1 IN VARCHAR2,
740 x_assum_override_2 IN VARCHAR2,
741 x_assum_override_3 IN VARCHAR2,
742 x_assum_override_4 IN VARCHAR2,
743 x_assum_override_5 IN VARCHAR2,
744 x_assum_override_6 IN VARCHAR2,
745 x_dependency_status IN VARCHAR2,
746 x_s_email_address IN VARCHAR2,
747 x_nslds_reason_code IN VARCHAR2,
748 x_app_receipt_date IN DATE,
749 x_processed_rec_type IN VARCHAR2,
750 x_hist_correction_for_tran_id IN NUMBER,
751 x_system_generated_indicator IN VARCHAR2,
752 x_dup_request_indicator IN VARCHAR2,
753 x_source_of_correction IN VARCHAR2,
754 x_p_cal_tax_status IN VARCHAR2,
755 x_s_cal_tax_status IN VARCHAR2,
756 x_graduate_flag IN VARCHAR2,
757 x_auto_zero_efc IN VARCHAR2,
758 x_efc_change_flag IN VARCHAR2,
759 x_sarc_flag IN VARCHAR2,
760 x_simplified_need_test IN VARCHAR2,
761 x_reject_reason_codes IN VARCHAR2,
762 x_select_service_match_flag IN VARCHAR2,
763 x_select_service_reg_flag IN VARCHAR2,
767 x_sec_ins_ver_number IN NUMBER,
764 x_ins_match_flag IN VARCHAR2,
765 x_ins_verification_number IN NUMBER DEFAULT NULL,
766 x_sec_ins_match_flag IN VARCHAR2,
768 x_ssn_match_flag IN VARCHAR2,
769 x_ssa_citizenship_flag IN VARCHAR2,
770 x_ssn_date_of_death IN DATE,
771 x_nslds_match_flag IN VARCHAR2,
772 x_va_match_flag IN VARCHAR2,
773 x_prisoner_match IN VARCHAR2,
774 x_verification_flag IN VARCHAR2,
775 x_subsequent_app_flag IN VARCHAR2,
776 x_app_source_site_code IN VARCHAR2,
777 x_tran_source_site_code IN VARCHAR2,
778 x_drn IN NUMBER,
779 x_tran_process_date IN DATE,
780 x_computer_batch_number IN NUMBER,
781 x_correction_flags IN VARCHAR2,
782 x_highlight_flags IN VARCHAR2,
783 x_paid_efc IN NUMBER,
784 x_primary_efc IN NUMBER,
785 x_secondary_efc IN NUMBER,
786 x_fed_pell_grant_efc_type IN VARCHAR2,
787 x_primary_efc_type IN VARCHAR2,
788 x_sec_efc_type IN VARCHAR2,
789 x_primary_alternate_month_1 IN NUMBER,
790 x_primary_alternate_month_2 IN NUMBER,
791 x_primary_alternate_month_3 IN NUMBER,
792 x_primary_alternate_month_4 IN NUMBER,
793 x_primary_alternate_month_5 IN NUMBER,
794 x_primary_alternate_month_6 IN NUMBER,
795 x_primary_alternate_month_7 IN NUMBER,
796 x_primary_alternate_month_8 IN NUMBER,
797 x_primary_alternate_month_10 IN NUMBER,
798 x_primary_alternate_month_11 IN NUMBER,
799 x_primary_alternate_month_12 IN NUMBER,
800 x_sec_alternate_month_1 IN NUMBER,
801 x_sec_alternate_month_2 IN NUMBER,
802 x_sec_alternate_month_3 IN NUMBER,
803 x_sec_alternate_month_4 IN NUMBER,
804 x_sec_alternate_month_5 IN NUMBER,
805 x_sec_alternate_month_6 IN NUMBER,
806 x_sec_alternate_month_7 IN NUMBER,
807 x_sec_alternate_month_8 IN NUMBER,
808 x_sec_alternate_month_10 IN NUMBER,
809 x_sec_alternate_month_11 IN NUMBER,
810 x_sec_alternate_month_12 IN NUMBER,
811 x_total_income IN NUMBER,
812 x_allow_total_income IN NUMBER,
813 x_state_tax_allow IN NUMBER,
814 x_employment_allow IN NUMBER,
815 x_income_protection_allow IN NUMBER,
816 x_available_income IN NUMBER,
817 x_contribution_from_ai IN NUMBER,
818 x_discretionary_networth IN NUMBER,
819 x_efc_networth IN NUMBER,
820 x_asset_protect_allow IN NUMBER,
821 x_parents_cont_from_assets IN NUMBER,
822 x_adjusted_available_income IN NUMBER,
823 x_total_student_contribution IN NUMBER,
824 x_total_parent_contribution IN NUMBER,
825 x_parents_contribution IN NUMBER,
826 x_student_total_income IN NUMBER,
827 x_sati IN NUMBER,
828 x_sic IN NUMBER,
829 x_sdnw IN NUMBER,
830 x_sca IN NUMBER,
831 x_fti IN NUMBER,
832 x_secti IN NUMBER,
833 x_secati IN NUMBER,
834 x_secstx IN NUMBER,
835 x_secea IN NUMBER,
836 x_secipa IN NUMBER,
837 x_secai IN NUMBER,
838 x_seccai IN NUMBER,
839 x_secdnw IN NUMBER,
840 x_secnw IN NUMBER,
841 x_secapa IN NUMBER,
842 x_secpca IN NUMBER,
843 x_secaai IN NUMBER,
844 x_sectsc IN NUMBER,
845 x_sectpc IN NUMBER,
846 x_secpc IN NUMBER,
847 x_secsti IN NUMBER,
848 x_secsic IN NUMBER,
849 x_secsati IN NUMBER,
850 x_secsdnw IN NUMBER,
851 x_secsca IN NUMBER,
852 x_secfti IN NUMBER,
853 x_a_citizenship IN VARCHAR2,
854 x_a_student_marital_status IN VARCHAR2,
855 x_a_student_agi IN NUMBER,
856 x_a_s_us_tax_paid IN NUMBER,
857 x_a_s_income_work IN NUMBER,
858 x_a_spouse_income_work IN NUMBER,
859 x_a_s_total_wsc IN NUMBER,
860 x_a_date_of_birth IN VARCHAR2,
864 x_a_va_status IN VARCHAR2,
861 x_a_student_married IN VARCHAR2,
862 x_a_have_children IN VARCHAR2,
863 x_a_s_have_dependents IN VARCHAR2,
865 x_a_s_num_in_family IN NUMBER,
866 x_a_s_num_in_college IN NUMBER,
867 x_a_p_marital_status IN VARCHAR2,
868 x_a_father_ssn IN VARCHAR2,
869 x_a_mother_ssn IN VARCHAR2,
870 x_a_parents_num_family IN NUMBER,
871 x_a_parents_num_college IN NUMBER,
872 x_a_parents_agi IN NUMBER,
873 x_a_p_us_tax_paid IN NUMBER,
874 x_a_f_work_income IN NUMBER,
875 x_a_m_work_income IN NUMBER,
876 x_a_p_total_wsc IN NUMBER,
877 x_comment_codes IN VARCHAR2,
878 x_sar_ack_comm_code IN VARCHAR2,
879 x_pell_grant_elig_flag IN VARCHAR2,
880 x_reprocess_reason_code IN VARCHAR2,
881 x_duplicate_date IN DATE,
882 x_isir_transaction_type IN VARCHAR2,
883 x_fedral_schl_code_indicator IN VARCHAR2,
884 x_multi_school_code_flags IN VARCHAR2,
885 x_dup_ssn_indicator IN VARCHAR2,
886 x_payment_isir IN VARCHAR2,
887 x_receipt_status IN VARCHAR2,
888 x_isir_receipt_completed IN VARCHAR2,
889 x_mode IN VARCHAR2 DEFAULT 'R' ,
890 x_system_record_type IN VARCHAR2 DEFAULT NULL,
891 x_verif_track_flag IN VARCHAR2 DEFAULT NULL,
892 x_active_isir IN VARCHAR2 DEFAULT NULL,
893 x_fafsa_data_verify_flags IN VARCHAR2 DEFAULT NULL,
894 x_reject_override_a IN VARCHAR2 DEFAULT NULL,
895 x_reject_override_c IN VARCHAR2 DEFAULT NULL,
896 x_parent_marital_status_date IN DATE DEFAULT NULL,
897 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
898 x_father_first_name_initial IN VARCHAR2 DEFAULT NULL,
899 x_father_step_father_birth_dt IN DATE DEFAULT NULL,
900 x_mother_first_name_initial IN VARCHAR2 DEFAULT NULL,
901 x_mother_step_mother_birth_dt IN DATE DEFAULT NULL,
902 x_parents_email_address_txt IN VARCHAR2 DEFAULT NULL,
903 x_address_change_type IN VARCHAR2 DEFAULT NULL,
904 x_cps_pushed_isir_flag IN VARCHAR2 DEFAULT NULL,
905 x_electronic_transaction_type IN VARCHAR2 DEFAULT NULL,
906 x_sar_c_change_type IN VARCHAR2 DEFAULT NULL,
907 x_father_ssn_match_type IN VARCHAR2 DEFAULT NULL,
908 x_mother_ssn_match_type IN VARCHAR2 DEFAULT NULL,
909 x_reject_override_g_flag IN VARCHAR2 DEFAULT NULL,
910 x_dhs_verification_num_txt IN VARCHAR2 DEFAULT NULL,
911 x_data_file_name_txt IN VARCHAR2 DEFAULT NULL,
912 x_message_class_txt IN VARCHAR2 DEFAULT NULL,
913 x_reject_override_3_flag IN VARCHAR2 DEFAULT NULL,
914 x_reject_override_12_flag IN VARCHAR2 DEFAULT NULL,
915 x_reject_override_j_flag IN VARCHAR2 DEFAULT NULL,
916 x_reject_override_k_flag IN VARCHAR2 DEFAULT NULL,
917 x_rejected_status_change_flag IN VARCHAR2 DEFAULT NULL,
918 x_verification_selection_flag IN VARCHAR2 DEFAULT NULL
919 );
920
921 PROCEDURE add_row (
922 x_rowid IN OUT NOCOPY VARCHAR2,
923 x_isir_id IN OUT NOCOPY NUMBER,
924 x_base_id IN NUMBER,
925 x_batch_year IN NUMBER,
926 x_transaction_num IN VARCHAR2,
927 x_current_ssn IN VARCHAR2,
928 x_ssn_name_change IN VARCHAR2,
929 x_original_ssn IN VARCHAR2,
930 x_orig_name_id IN VARCHAR2,
931 x_last_name IN VARCHAR2,
932 x_first_name IN VARCHAR2,
933 x_middle_initial IN VARCHAR2,
934 x_perm_mail_add IN VARCHAR2,
935 x_perm_city IN VARCHAR2,
936 x_perm_state IN VARCHAR2,
937 x_perm_zip_code IN VARCHAR2,
938 x_date_of_birth IN DATE,
939 x_phone_number IN VARCHAR2,
940 x_driver_license_number IN VARCHAR2,
941 x_driver_license_state IN VARCHAR2,
942 x_citizenship_status IN VARCHAR2,
943 x_alien_reg_number IN VARCHAR2,
944 x_s_marital_status IN VARCHAR2,
945 x_s_marital_status_date IN DATE,
946 x_summ_enrl_status IN VARCHAR2,
947 x_fall_enrl_status IN VARCHAR2,
948 x_winter_enrl_status IN VARCHAR2,
949 x_spring_enrl_status IN VARCHAR2,
950 x_summ2_enrl_status IN VARCHAR2,
954 x_legal_residence_before_date IN VARCHAR2,
951 x_fathers_highest_edu_level IN VARCHAR2,
952 x_mothers_highest_edu_level IN VARCHAR2,
953 x_s_state_legal_residence IN VARCHAR2,
955 x_s_legal_resd_date IN DATE,
956 x_ss_r_u_male IN VARCHAR2,
957 x_selective_service_reg IN VARCHAR2,
958 x_degree_certification IN VARCHAR2,
959 x_grade_level_in_college IN VARCHAR2,
960 x_high_school_diploma_ged IN VARCHAR2,
961 x_first_bachelor_deg_by_date IN VARCHAR2,
962 x_interest_in_loan IN VARCHAR2,
963 x_interest_in_stud_employment IN VARCHAR2,
964 x_drug_offence_conviction IN VARCHAR2,
965 x_s_tax_return_status IN VARCHAR2,
966 x_s_type_tax_return IN VARCHAR2,
967 x_s_elig_1040ez IN VARCHAR2,
968 x_s_adjusted_gross_income IN NUMBER,
969 x_s_fed_taxes_paid IN NUMBER,
970 x_s_exemptions IN NUMBER,
971 x_s_income_from_work IN NUMBER,
972 x_spouse_income_from_work IN NUMBER,
973 x_s_toa_amt_from_wsa IN NUMBER,
974 x_s_toa_amt_from_wsb IN NUMBER,
975 x_s_toa_amt_from_wsc IN NUMBER,
976 x_s_investment_networth IN NUMBER,
977 x_s_busi_farm_networth IN NUMBER,
978 x_s_cash_savings IN NUMBER,
979 x_va_months IN NUMBER,
980 x_va_amount IN NUMBER,
981 x_stud_dob_before_date IN VARCHAR2,
982 x_deg_beyond_bachelor IN VARCHAR2,
983 x_s_married IN VARCHAR2,
984 x_s_have_children IN VARCHAR2,
985 x_legal_dependents IN VARCHAR2,
986 x_orphan_ward_of_court IN VARCHAR2,
987 x_s_veteran IN VARCHAR2,
988 x_p_marital_status IN VARCHAR2,
989 x_father_ssn IN VARCHAR2,
990 x_f_last_name IN VARCHAR2,
991 x_mother_ssn IN VARCHAR2,
992 x_m_last_name IN VARCHAR2,
993 x_p_num_family_member IN NUMBER,
994 x_p_num_in_college IN NUMBER,
995 x_p_state_legal_residence IN VARCHAR2,
996 x_p_state_legal_res_before_dt IN VARCHAR2,
997 x_p_legal_res_date IN DATE,
998 x_age_older_parent IN NUMBER,
999 x_p_tax_return_status IN VARCHAR2,
1000 x_p_type_tax_return IN VARCHAR2,
1001 x_p_elig_1040aez IN VARCHAR2,
1002 x_p_adjusted_gross_income IN NUMBER,
1003 x_p_taxes_paid IN NUMBER,
1004 x_p_exemptions IN NUMBER,
1005 x_f_income_work IN NUMBER,
1006 x_m_income_work IN NUMBER,
1007 x_p_income_wsa IN NUMBER,
1008 x_p_income_wsb IN NUMBER,
1009 x_p_income_wsc IN NUMBER,
1010 x_p_investment_networth IN NUMBER,
1011 x_p_business_networth IN NUMBER,
1012 x_p_cash_saving IN NUMBER,
1013 x_s_num_family_members IN NUMBER,
1014 x_s_num_in_college IN NUMBER,
1015 x_first_college IN VARCHAR2,
1016 x_first_house_plan IN VARCHAR2,
1017 x_second_college IN VARCHAR2,
1018 x_second_house_plan IN VARCHAR2,
1019 x_third_college IN VARCHAR2,
1020 x_third_house_plan IN VARCHAR2,
1021 x_fourth_college IN VARCHAR2,
1022 x_fourth_house_plan IN VARCHAR2,
1023 x_fifth_college IN VARCHAR2,
1024 x_fifth_house_plan IN VARCHAR2,
1025 x_sixth_college IN VARCHAR2,
1026 x_sixth_house_plan IN VARCHAR2,
1027 x_date_app_completed IN DATE,
1028 x_signed_by IN VARCHAR2,
1029 x_preparer_ssn IN VARCHAR2,
1030 x_preparer_emp_id_number IN VARCHAR2,
1031 x_preparer_sign IN VARCHAR2,
1032 x_transaction_receipt_date IN DATE,
1033 x_dependency_override_ind IN VARCHAR2,
1034 x_faa_fedral_schl_code IN VARCHAR2,
1035 x_faa_adjustment IN VARCHAR2,
1036 x_input_record_type IN VARCHAR2,
1037 x_serial_number IN NUMBER,
1038 x_batch_number IN VARCHAR2,
1039 x_early_analysis_flag IN VARCHAR2,
1040 x_app_entry_source_code IN VARCHAR2,
1041 x_eti_destination_code IN VARCHAR2,
1042 x_reject_override_b IN VARCHAR2,
1043 x_reject_override_n IN VARCHAR2,
1044 x_reject_override_w IN VARCHAR2,
1045 x_assum_override_1 IN VARCHAR2,
1046 x_assum_override_2 IN VARCHAR2,
1050 x_assum_override_6 IN VARCHAR2,
1047 x_assum_override_3 IN VARCHAR2,
1048 x_assum_override_4 IN VARCHAR2,
1049 x_assum_override_5 IN VARCHAR2,
1051 x_dependency_status IN VARCHAR2,
1052 x_s_email_address IN VARCHAR2,
1053 x_nslds_reason_code IN VARCHAR2,
1054 x_app_receipt_date IN DATE,
1055 x_processed_rec_type IN VARCHAR2,
1056 x_hist_correction_for_tran_id IN NUMBER,
1057 x_system_generated_indicator IN VARCHAR2,
1058 x_dup_request_indicator IN VARCHAR2,
1059 x_source_of_correction IN VARCHAR2,
1060 x_p_cal_tax_status IN VARCHAR2,
1061 x_s_cal_tax_status IN VARCHAR2,
1062 x_graduate_flag IN VARCHAR2,
1063 x_auto_zero_efc IN VARCHAR2,
1064 x_efc_change_flag IN VARCHAR2,
1065 x_sarc_flag IN VARCHAR2,
1066 x_simplified_need_test IN VARCHAR2,
1067 x_reject_reason_codes IN VARCHAR2,
1068 x_select_service_match_flag IN VARCHAR2,
1069 x_select_service_reg_flag IN VARCHAR2,
1070 x_ins_match_flag IN VARCHAR2,
1071 x_ins_verification_number IN NUMBER DEFAULT NULL,
1072 x_sec_ins_match_flag IN VARCHAR2,
1073 x_sec_ins_ver_number IN NUMBER,
1074 x_ssn_match_flag IN VARCHAR2,
1075 x_ssa_citizenship_flag IN VARCHAR2,
1076 x_ssn_date_of_death IN DATE,
1077 x_nslds_match_flag IN VARCHAR2,
1078 x_va_match_flag IN VARCHAR2,
1079 x_prisoner_match IN VARCHAR2,
1080 x_verification_flag IN VARCHAR2,
1081 x_subsequent_app_flag IN VARCHAR2,
1082 x_app_source_site_code IN VARCHAR2,
1083 x_tran_source_site_code IN VARCHAR2,
1084 x_drn IN NUMBER,
1085 x_tran_process_date IN DATE,
1086 x_computer_batch_number IN NUMBER,
1087 x_correction_flags IN VARCHAR2,
1088 x_highlight_flags IN VARCHAR2,
1089 x_paid_efc IN NUMBER,
1090 x_primary_efc IN NUMBER,
1091 x_secondary_efc IN NUMBER,
1092 x_fed_pell_grant_efc_type IN VARCHAR2,
1093 x_primary_efc_type IN VARCHAR2,
1094 x_sec_efc_type IN VARCHAR2,
1095 x_primary_alternate_month_1 IN NUMBER,
1096 x_primary_alternate_month_2 IN NUMBER,
1097 x_primary_alternate_month_3 IN NUMBER,
1098 x_primary_alternate_month_4 IN NUMBER,
1099 x_primary_alternate_month_5 IN NUMBER,
1100 x_primary_alternate_month_6 IN NUMBER,
1101 x_primary_alternate_month_7 IN NUMBER,
1102 x_primary_alternate_month_8 IN NUMBER,
1103 x_primary_alternate_month_10 IN NUMBER,
1104 x_primary_alternate_month_11 IN NUMBER,
1105 x_primary_alternate_month_12 IN NUMBER,
1106 x_sec_alternate_month_1 IN NUMBER,
1107 x_sec_alternate_month_2 IN NUMBER,
1108 x_sec_alternate_month_3 IN NUMBER,
1109 x_sec_alternate_month_4 IN NUMBER,
1110 x_sec_alternate_month_5 IN NUMBER,
1111 x_sec_alternate_month_6 IN NUMBER,
1112 x_sec_alternate_month_7 IN NUMBER,
1113 x_sec_alternate_month_8 IN NUMBER,
1114 x_sec_alternate_month_10 IN NUMBER,
1115 x_sec_alternate_month_11 IN NUMBER,
1116 x_sec_alternate_month_12 IN NUMBER,
1117 x_total_income IN NUMBER,
1118 x_allow_total_income IN NUMBER,
1119 x_state_tax_allow IN NUMBER,
1120 x_employment_allow IN NUMBER,
1121 x_income_protection_allow IN NUMBER,
1122 x_available_income IN NUMBER,
1123 x_contribution_from_ai IN NUMBER,
1124 x_discretionary_networth IN NUMBER,
1125 x_efc_networth IN NUMBER,
1126 x_asset_protect_allow IN NUMBER,
1127 x_parents_cont_from_assets IN NUMBER,
1128 x_adjusted_available_income IN NUMBER,
1129 x_total_student_contribution IN NUMBER,
1130 x_total_parent_contribution IN NUMBER,
1131 x_parents_contribution IN NUMBER,
1132 x_student_total_income IN NUMBER,
1133 x_sati IN NUMBER,
1134 x_sic IN NUMBER,
1135 x_sdnw IN NUMBER,
1136 x_sca IN NUMBER,
1137 x_fti IN NUMBER,
1138 x_secti IN NUMBER,
1139 x_secati IN NUMBER,
1140 x_secstx IN NUMBER,
1141 x_secea IN NUMBER,
1142 x_secipa IN NUMBER,
1146 x_secnw IN NUMBER,
1143 x_secai IN NUMBER,
1144 x_seccai IN NUMBER,
1145 x_secdnw IN NUMBER,
1147 x_secapa IN NUMBER,
1148 x_secpca IN NUMBER,
1149 x_secaai IN NUMBER,
1150 x_sectsc IN NUMBER,
1151 x_sectpc IN NUMBER,
1152 x_secpc IN NUMBER,
1153 x_secsti IN NUMBER,
1154 x_secsic IN NUMBER,
1155 x_secsati IN NUMBER,
1156 x_secsdnw IN NUMBER,
1157 x_secsca IN NUMBER,
1158 x_secfti IN NUMBER,
1159 x_a_citizenship IN VARCHAR2,
1160 x_a_student_marital_status IN VARCHAR2,
1161 x_a_student_agi IN NUMBER,
1162 x_a_s_us_tax_paid IN NUMBER,
1163 x_a_s_income_work IN NUMBER,
1164 x_a_spouse_income_work IN NUMBER,
1165 x_a_s_total_wsc IN NUMBER,
1166 x_a_date_of_birth IN VARCHAR2,
1167 x_a_student_married IN VARCHAR2,
1168 x_a_have_children IN VARCHAR2,
1169 x_a_s_have_dependents IN VARCHAR2,
1170 x_a_va_status IN VARCHAR2,
1171 x_a_s_num_in_family IN NUMBER,
1172 x_a_s_num_in_college IN NUMBER,
1173 x_a_p_marital_status IN VARCHAR2,
1174 x_a_father_ssn IN VARCHAR2,
1175 x_a_mother_ssn IN VARCHAR2,
1176 x_a_parents_num_family IN NUMBER,
1177 x_a_parents_num_college IN NUMBER,
1178 x_a_parents_agi IN NUMBER,
1179 x_a_p_us_tax_paid IN NUMBER,
1180 x_a_f_work_income IN NUMBER,
1181 x_a_m_work_income IN NUMBER,
1182 x_a_p_total_wsc IN NUMBER,
1183 x_comment_codes IN VARCHAR2,
1184 x_sar_ack_comm_code IN VARCHAR2,
1185 x_pell_grant_elig_flag IN VARCHAR2,
1186 x_reprocess_reason_code IN VARCHAR2,
1187 x_duplicate_date IN DATE,
1188 x_isir_transaction_type IN VARCHAR2,
1189 x_fedral_schl_code_indicator IN VARCHAR2,
1190 x_multi_school_code_flags IN VARCHAR2,
1191 x_dup_ssn_indicator IN VARCHAR2,
1192 x_payment_isir IN VARCHAR2,
1193 x_receipt_status IN VARCHAR2,
1194 x_isir_receipt_completed IN VARCHAR2,
1195 x_mode IN VARCHAR2 DEFAULT 'R',
1196 x_system_record_type IN VARCHAR2 DEFAULT NULL,
1197 x_verif_track_flag IN VARCHAR2 DEFAULT NULL,
1198 x_active_isir IN VARCHAR2 DEFAULT NULL,
1199 x_fafsa_data_verify_flags IN VARCHAR2 DEFAULT NULL,
1200 x_reject_override_a IN VARCHAR2 DEFAULT NULL,
1201 x_reject_override_c IN VARCHAR2 DEFAULT NULL,
1202 x_parent_marital_status_date IN DATE DEFAULT NULL,
1203 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
1204 x_father_first_name_initial IN VARCHAR2 DEFAULT NULL,
1205 x_father_step_father_birth_dt IN DATE DEFAULT NULL,
1206 x_mother_first_name_initial IN VARCHAR2 DEFAULT NULL,
1207 x_mother_step_mother_birth_dt IN DATE DEFAULT NULL,
1208 x_parents_email_address_txt IN VARCHAR2 DEFAULT NULL,
1209 x_address_change_type IN VARCHAR2 DEFAULT NULL,
1210 x_cps_pushed_isir_flag IN VARCHAR2 DEFAULT NULL,
1211 x_electronic_transaction_type IN VARCHAR2 DEFAULT NULL,
1212 x_sar_c_change_type IN VARCHAR2 DEFAULT NULL,
1213 x_father_ssn_match_type IN VARCHAR2 DEFAULT NULL,
1214 x_mother_ssn_match_type IN VARCHAR2 DEFAULT NULL,
1215 x_reject_override_g_flag IN VARCHAR2 DEFAULT NULL,
1216 x_dhs_verification_num_txt IN VARCHAR2 DEFAULT NULL,
1217 x_data_file_name_txt IN VARCHAR2 DEFAULT NULL,
1218 x_message_class_txt IN VARCHAR2 DEFAULT NULL,
1219 x_reject_override_3_flag IN VARCHAR2 DEFAULT NULL,
1220 x_reject_override_12_flag IN VARCHAR2 DEFAULT NULL,
1221 x_reject_override_j_flag IN VARCHAR2 DEFAULT NULL,
1222 x_reject_override_k_flag IN VARCHAR2 DEFAULT NULL,
1223 x_rejected_status_change_flag IN VARCHAR2 DEFAULT NULL,
1224 x_verification_selection_flag IN VARCHAR2 DEFAULT NULL
1225 );
1226
1227 PROCEDURE delete_row (
1228 x_rowid IN VARCHAR2
1229 );
1230
1231 FUNCTION get_pk_for_validation (
1232 x_isir_id IN NUMBER
1233 ) RETURN BOOLEAN;
1234
1235 PROCEDURE before_dml (
1236 p_action IN VARCHAR2,
1240 x_batch_year IN NUMBER DEFAULT NULL,
1237 x_rowid IN VARCHAR2 DEFAULT NULL,
1238 x_isir_id IN NUMBER DEFAULT NULL,
1239 x_base_id IN NUMBER DEFAULT NULL,
1241 x_transaction_num IN VARCHAR2 DEFAULT NULL,
1242 x_current_ssn IN VARCHAR2 DEFAULT NULL,
1243 x_ssn_name_change IN VARCHAR2 DEFAULT NULL,
1244 x_original_ssn IN VARCHAR2 DEFAULT NULL,
1245 x_orig_name_id IN VARCHAR2 DEFAULT NULL,
1246 x_last_name IN VARCHAR2 DEFAULT NULL,
1247 x_first_name IN VARCHAR2 DEFAULT NULL,
1248 x_middle_initial IN VARCHAR2 DEFAULT NULL,
1249 x_perm_mail_add IN VARCHAR2 DEFAULT NULL,
1250 x_perm_city IN VARCHAR2 DEFAULT NULL,
1251 x_perm_state IN VARCHAR2 DEFAULT NULL,
1252 x_perm_zip_code IN VARCHAR2 DEFAULT NULL,
1253 x_date_of_birth IN DATE DEFAULT NULL,
1254 x_phone_number IN VARCHAR2 DEFAULT NULL,
1255 x_driver_license_number IN VARCHAR2 DEFAULT NULL,
1256 x_driver_license_state IN VARCHAR2 DEFAULT NULL,
1257 x_citizenship_status IN VARCHAR2 DEFAULT NULL,
1258 x_alien_reg_number IN VARCHAR2 DEFAULT NULL,
1259 x_s_marital_status IN VARCHAR2 DEFAULT NULL,
1260 x_s_marital_status_date IN DATE DEFAULT NULL,
1261 x_summ_enrl_status IN VARCHAR2 DEFAULT NULL,
1262 x_fall_enrl_status IN VARCHAR2 DEFAULT NULL,
1263 x_winter_enrl_status IN VARCHAR2 DEFAULT NULL,
1264 x_spring_enrl_status IN VARCHAR2 DEFAULT NULL,
1265 x_summ2_enrl_status IN VARCHAR2 DEFAULT NULL,
1266 x_fathers_highest_edu_level IN VARCHAR2 DEFAULT NULL,
1267 x_mothers_highest_edu_level IN VARCHAR2 DEFAULT NULL,
1268 x_s_state_legal_residence IN VARCHAR2 DEFAULT NULL,
1269 x_legal_residence_before_date IN VARCHAR2 DEFAULT NULL,
1270 x_s_legal_resd_date IN DATE DEFAULT NULL,
1271 x_ss_r_u_male IN VARCHAR2 DEFAULT NULL,
1272 x_selective_service_reg IN VARCHAR2 DEFAULT NULL,
1273 x_degree_certification IN VARCHAR2 DEFAULT NULL,
1274 x_grade_level_in_college IN VARCHAR2 DEFAULT NULL,
1275 x_high_school_diploma_ged IN VARCHAR2 DEFAULT NULL,
1276 x_first_bachelor_deg_by_date IN VARCHAR2 DEFAULT NULL,
1277 x_interest_in_loan IN VARCHAR2 DEFAULT NULL,
1278 x_interest_in_stud_employment IN VARCHAR2 DEFAULT NULL,
1279 x_drug_offence_conviction IN VARCHAR2 DEFAULT NULL,
1280 x_s_tax_return_status IN VARCHAR2 DEFAULT NULL,
1281 x_s_type_tax_return IN VARCHAR2 DEFAULT NULL,
1282 x_s_elig_1040ez IN VARCHAR2 DEFAULT NULL,
1283 x_s_adjusted_gross_income IN NUMBER DEFAULT NULL,
1284 x_s_fed_taxes_paid IN NUMBER DEFAULT NULL,
1285 x_s_exemptions IN NUMBER DEFAULT NULL,
1286 x_s_income_from_work IN NUMBER DEFAULT NULL,
1287 x_spouse_income_from_work IN NUMBER DEFAULT NULL,
1288 x_s_toa_amt_from_wsa IN NUMBER DEFAULT NULL,
1289 x_s_toa_amt_from_wsb IN NUMBER DEFAULT NULL,
1290 x_s_toa_amt_from_wsc IN NUMBER DEFAULT NULL,
1291 x_s_investment_networth IN NUMBER DEFAULT NULL,
1292 x_s_busi_farm_networth IN NUMBER DEFAULT NULL,
1293 x_s_cash_savings IN NUMBER DEFAULT NULL,
1294 x_va_months IN NUMBER DEFAULT NULL,
1295 x_va_amount IN NUMBER DEFAULT NULL,
1296 x_stud_dob_before_date IN VARCHAR2 DEFAULT NULL,
1297 x_deg_beyond_bachelor IN VARCHAR2 DEFAULT NULL,
1298 x_s_married IN VARCHAR2 DEFAULT NULL,
1299 x_s_have_children IN VARCHAR2 DEFAULT NULL,
1300 x_legal_dependents IN VARCHAR2 DEFAULT NULL,
1301 x_orphan_ward_of_court IN VARCHAR2 DEFAULT NULL,
1302 x_s_veteran IN VARCHAR2 DEFAULT NULL,
1303 x_p_marital_status IN VARCHAR2 DEFAULT NULL,
1304 x_father_ssn IN VARCHAR2 DEFAULT NULL,
1305 x_f_last_name IN VARCHAR2 DEFAULT NULL,
1306 x_mother_ssn IN VARCHAR2 DEFAULT NULL,
1307 x_m_last_name IN VARCHAR2 DEFAULT NULL,
1308 x_p_num_family_member IN NUMBER DEFAULT NULL,
1309 x_p_num_in_college IN NUMBER DEFAULT NULL,
1310 x_p_state_legal_residence IN VARCHAR2 DEFAULT NULL,
1311 x_p_state_legal_res_before_dt IN VARCHAR2 DEFAULT NULL,
1312 x_p_legal_res_date IN DATE DEFAULT NULL,
1313 x_age_older_parent IN NUMBER DEFAULT NULL,
1317 x_p_adjusted_gross_income IN NUMBER DEFAULT NULL,
1314 x_p_tax_return_status IN VARCHAR2 DEFAULT NULL,
1315 x_p_type_tax_return IN VARCHAR2 DEFAULT NULL,
1316 x_p_elig_1040aez IN VARCHAR2 DEFAULT NULL,
1318 x_p_taxes_paid IN NUMBER DEFAULT NULL,
1319 x_p_exemptions IN NUMBER DEFAULT NULL,
1320 x_f_income_work IN NUMBER DEFAULT NULL,
1321 x_m_income_work IN NUMBER DEFAULT NULL,
1322 x_p_income_wsa IN NUMBER DEFAULT NULL,
1323 x_p_income_wsb IN NUMBER DEFAULT NULL,
1324 x_p_income_wsc IN NUMBER DEFAULT NULL,
1325 x_p_investment_networth IN NUMBER DEFAULT NULL,
1326 x_p_business_networth IN NUMBER DEFAULT NULL,
1327 x_p_cash_saving IN NUMBER DEFAULT NULL,
1328 x_s_num_family_members IN NUMBER DEFAULT NULL,
1329 x_s_num_in_college IN NUMBER DEFAULT NULL,
1330 x_first_college IN VARCHAR2 DEFAULT NULL,
1331 x_first_house_plan IN VARCHAR2 DEFAULT NULL,
1332 x_second_college IN VARCHAR2 DEFAULT NULL,
1333 x_second_house_plan IN VARCHAR2 DEFAULT NULL,
1334 x_third_college IN VARCHAR2 DEFAULT NULL,
1335 x_third_house_plan IN VARCHAR2 DEFAULT NULL,
1336 x_fourth_college IN VARCHAR2 DEFAULT NULL,
1337 x_fourth_house_plan IN VARCHAR2 DEFAULT NULL,
1338 x_fifth_college IN VARCHAR2 DEFAULT NULL,
1339 x_fifth_house_plan IN VARCHAR2 DEFAULT NULL,
1340 x_sixth_college IN VARCHAR2 DEFAULT NULL,
1341 x_sixth_house_plan IN VARCHAR2 DEFAULT NULL,
1342 x_date_app_completed IN DATE DEFAULT NULL,
1343 x_signed_by IN VARCHAR2 DEFAULT NULL,
1344 x_preparer_ssn IN VARCHAR2 DEFAULT NULL,
1345 x_preparer_emp_id_number IN VARCHAR2 DEFAULT NULL,
1346 x_preparer_sign IN VARCHAR2 DEFAULT NULL,
1347 x_transaction_receipt_date IN DATE DEFAULT NULL,
1348 x_dependency_override_ind IN VARCHAR2 DEFAULT NULL,
1349 x_faa_fedral_schl_code IN VARCHAR2 DEFAULT NULL,
1350 x_faa_adjustment IN VARCHAR2 DEFAULT NULL,
1351 x_input_record_type IN VARCHAR2 DEFAULT NULL,
1352 x_serial_number IN NUMBER DEFAULT NULL,
1353 x_batch_number IN VARCHAR2 DEFAULT NULL,
1354 x_early_analysis_flag IN VARCHAR2 DEFAULT NULL,
1355 x_app_entry_source_code IN VARCHAR2 DEFAULT NULL,
1356 x_eti_destination_code IN VARCHAR2 DEFAULT NULL,
1357 x_reject_override_b IN VARCHAR2 DEFAULT NULL,
1358 x_reject_override_n IN VARCHAR2 DEFAULT NULL,
1359 x_reject_override_w IN VARCHAR2 DEFAULT NULL,
1360 x_assum_override_1 IN VARCHAR2 DEFAULT NULL,
1361 x_assum_override_2 IN VARCHAR2 DEFAULT NULL,
1362 x_assum_override_3 IN VARCHAR2 DEFAULT NULL,
1363 x_assum_override_4 IN VARCHAR2 DEFAULT NULL,
1364 x_assum_override_5 IN VARCHAR2 DEFAULT NULL,
1365 x_assum_override_6 IN VARCHAR2 DEFAULT NULL,
1366 x_dependency_status IN VARCHAR2 DEFAULT NULL,
1367 x_s_email_address IN VARCHAR2 DEFAULT NULL,
1368 x_nslds_reason_code IN VARCHAR2 DEFAULT NULL,
1369 x_app_receipt_date IN DATE DEFAULT NULL,
1370 x_processed_rec_type IN VARCHAR2 DEFAULT NULL,
1371 x_hist_correction_for_tran_id IN NUMBER DEFAULT NULL,
1372 x_system_generated_indicator IN VARCHAR2 DEFAULT NULL,
1373 x_dup_request_indicator IN VARCHAR2 DEFAULT NULL,
1374 x_source_of_correction IN VARCHAR2 DEFAULT NULL,
1375 x_p_cal_tax_status IN VARCHAR2 DEFAULT NULL,
1376 x_s_cal_tax_status IN VARCHAR2 DEFAULT NULL,
1377 x_graduate_flag IN VARCHAR2 DEFAULT NULL,
1378 x_auto_zero_efc IN VARCHAR2 DEFAULT NULL,
1379 x_efc_change_flag IN VARCHAR2 DEFAULT NULL,
1380 x_sarc_flag IN VARCHAR2 DEFAULT NULL,
1381 x_simplified_need_test IN VARCHAR2 DEFAULT NULL,
1382 x_reject_reason_codes IN VARCHAR2 DEFAULT NULL,
1383 x_select_service_match_flag IN VARCHAR2 DEFAULT NULL,
1384 x_select_service_reg_flag IN VARCHAR2 DEFAULT NULL,
1385 x_ins_match_flag IN VARCHAR2 DEFAULT NULL,
1386 x_ins_verification_number IN NUMBER DEFAULT NULL,
1387 x_sec_ins_match_flag IN VARCHAR2 DEFAULT NULL,
1388 x_sec_ins_ver_number IN NUMBER DEFAULT NULL,
1389 x_ssn_match_flag IN VARCHAR2 DEFAULT NULL,
1390 x_ssa_citizenship_flag IN VARCHAR2 DEFAULT NULL,
1394 x_prisoner_match IN VARCHAR2 DEFAULT NULL,
1391 x_ssn_date_of_death IN DATE DEFAULT NULL,
1392 x_nslds_match_flag IN VARCHAR2 DEFAULT NULL,
1393 x_va_match_flag IN VARCHAR2 DEFAULT NULL,
1395 x_verification_flag IN VARCHAR2 DEFAULT NULL,
1396 x_subsequent_app_flag IN VARCHAR2 DEFAULT NULL,
1397 x_app_source_site_code IN VARCHAR2 DEFAULT NULL,
1398 x_tran_source_site_code IN VARCHAR2 DEFAULT NULL,
1399 x_drn IN NUMBER DEFAULT NULL,
1400 x_tran_process_date IN DATE DEFAULT NULL,
1401 x_computer_batch_number IN NUMBER DEFAULT NULL,
1402 x_correction_flags IN VARCHAR2 DEFAULT NULL,
1403 x_highlight_flags IN VARCHAR2 DEFAULT NULL,
1404 x_paid_efc IN NUMBER DEFAULT NULL,
1405 x_primary_efc IN NUMBER DEFAULT NULL,
1406 x_secondary_efc IN NUMBER DEFAULT NULL,
1407 x_fed_pell_grant_efc_type IN VARCHAR2 DEFAULT NULL,
1408 x_primary_efc_type IN VARCHAR2 DEFAULT NULL,
1409 x_sec_efc_type IN VARCHAR2 DEFAULT NULL,
1410 x_primary_alternate_month_1 IN NUMBER DEFAULT NULL,
1411 x_primary_alternate_month_2 IN NUMBER DEFAULT NULL,
1412 x_primary_alternate_month_3 IN NUMBER DEFAULT NULL,
1413 x_primary_alternate_month_4 IN NUMBER DEFAULT NULL,
1414 x_primary_alternate_month_5 IN NUMBER DEFAULT NULL,
1415 x_primary_alternate_month_6 IN NUMBER DEFAULT NULL,
1416 x_primary_alternate_month_7 IN NUMBER DEFAULT NULL,
1417 x_primary_alternate_month_8 IN NUMBER DEFAULT NULL,
1418 x_primary_alternate_month_10 IN NUMBER DEFAULT NULL,
1419 x_primary_alternate_month_11 IN NUMBER DEFAULT NULL,
1420 x_primary_alternate_month_12 IN NUMBER DEFAULT NULL,
1421 x_sec_alternate_month_1 IN NUMBER DEFAULT NULL,
1422 x_sec_alternate_month_2 IN NUMBER DEFAULT NULL,
1423 x_sec_alternate_month_3 IN NUMBER DEFAULT NULL,
1424 x_sec_alternate_month_4 IN NUMBER DEFAULT NULL,
1425 x_sec_alternate_month_5 IN NUMBER DEFAULT NULL,
1426 x_sec_alternate_month_6 IN NUMBER DEFAULT NULL,
1427 x_sec_alternate_month_7 IN NUMBER DEFAULT NULL,
1428 x_sec_alternate_month_8 IN NUMBER DEFAULT NULL,
1429 x_sec_alternate_month_10 IN NUMBER DEFAULT NULL,
1430 x_sec_alternate_month_11 IN NUMBER DEFAULT NULL,
1431 x_sec_alternate_month_12 IN NUMBER DEFAULT NULL,
1432 x_total_income IN NUMBER DEFAULT NULL,
1433 x_allow_total_income IN NUMBER DEFAULT NULL,
1434 x_state_tax_allow IN NUMBER DEFAULT NULL,
1435 x_employment_allow IN NUMBER DEFAULT NULL,
1436 x_income_protection_allow IN NUMBER DEFAULT NULL,
1437 x_available_income IN NUMBER DEFAULT NULL,
1438 x_contribution_from_ai IN NUMBER DEFAULT NULL,
1439 x_discretionary_networth IN NUMBER DEFAULT NULL,
1440 x_efc_networth IN NUMBER DEFAULT NULL,
1441 x_asset_protect_allow IN NUMBER DEFAULT NULL,
1442 x_parents_cont_from_assets IN NUMBER DEFAULT NULL,
1443 x_adjusted_available_income IN NUMBER DEFAULT NULL,
1444 x_total_student_contribution IN NUMBER DEFAULT NULL,
1445 x_total_parent_contribution IN NUMBER DEFAULT NULL,
1446 x_parents_contribution IN NUMBER DEFAULT NULL,
1447 x_student_total_income IN NUMBER DEFAULT NULL,
1448 x_sati IN NUMBER DEFAULT NULL,
1449 x_sic IN NUMBER DEFAULT NULL,
1450 x_sdnw IN NUMBER DEFAULT NULL,
1451 x_sca IN NUMBER DEFAULT NULL,
1452 x_fti IN NUMBER DEFAULT NULL,
1453 x_secti IN NUMBER DEFAULT NULL,
1454 x_secati IN NUMBER DEFAULT NULL,
1455 x_secstx IN NUMBER DEFAULT NULL,
1456 x_secea IN NUMBER DEFAULT NULL,
1457 x_secipa IN NUMBER DEFAULT NULL,
1458 x_secai IN NUMBER DEFAULT NULL,
1459 x_seccai IN NUMBER DEFAULT NULL,
1460 x_secdnw IN NUMBER DEFAULT NULL,
1461 x_secnw IN NUMBER DEFAULT NULL,
1462 x_secapa IN NUMBER DEFAULT NULL,
1463 x_secpca IN NUMBER DEFAULT NULL,
1464 x_secaai IN NUMBER DEFAULT NULL,
1465 x_sectsc IN NUMBER DEFAULT NULL,
1466 x_sectpc IN NUMBER DEFAULT NULL,
1467 x_secpc IN NUMBER DEFAULT NULL,
1468 x_secsti IN NUMBER DEFAULT NULL,
1469 x_secsic IN NUMBER DEFAULT NULL,
1470 x_secsati IN NUMBER DEFAULT NULL,
1471 x_secsdnw IN NUMBER DEFAULT NULL,
1472 x_secsca IN NUMBER DEFAULT NULL,
1473 x_secfti IN NUMBER DEFAULT NULL,
1474 x_a_citizenship IN VARCHAR2 DEFAULT NULL,
1475 x_a_student_marital_status IN VARCHAR2 DEFAULT NULL,
1476 x_a_student_agi IN NUMBER DEFAULT NULL,
1477 x_a_s_us_tax_paid IN NUMBER DEFAULT NULL,
1478 x_a_s_income_work IN NUMBER DEFAULT NULL,
1479 x_a_spouse_income_work IN NUMBER DEFAULT NULL,
1480 x_a_s_total_wsc IN NUMBER DEFAULT NULL,
1481 x_a_date_of_birth IN VARCHAR2 DEFAULT NULL,
1482 x_a_student_married IN VARCHAR2 DEFAULT NULL,
1483 x_a_have_children IN VARCHAR2 DEFAULT NULL,
1484 x_a_s_have_dependents IN VARCHAR2 DEFAULT NULL,
1485 x_a_va_status IN VARCHAR2 DEFAULT NULL,
1486 x_a_s_num_in_family IN NUMBER DEFAULT NULL,
1487 x_a_s_num_in_college IN NUMBER DEFAULT NULL,
1488 x_a_p_marital_status IN VARCHAR2 DEFAULT NULL,
1489 x_a_father_ssn IN VARCHAR2 DEFAULT NULL,
1490 x_a_mother_ssn IN VARCHAR2 DEFAULT NULL,
1491 x_a_parents_num_family IN NUMBER DEFAULT NULL,
1492 x_a_parents_num_college IN NUMBER DEFAULT NULL,
1493 x_a_parents_agi IN NUMBER DEFAULT NULL,
1494 x_a_p_us_tax_paid IN NUMBER DEFAULT NULL,
1495 x_a_f_work_income IN NUMBER DEFAULT NULL,
1496 x_a_m_work_income IN NUMBER DEFAULT NULL,
1497 x_a_p_total_wsc IN NUMBER DEFAULT NULL,
1498 x_comment_codes IN VARCHAR2 DEFAULT NULL,
1499 x_sar_ack_comm_code IN VARCHAR2 DEFAULT NULL,
1500 x_pell_grant_elig_flag IN VARCHAR2 DEFAULT NULL,
1501 x_reprocess_reason_code IN VARCHAR2 DEFAULT NULL,
1502 x_duplicate_date IN DATE DEFAULT NULL,
1503 x_isir_transaction_type IN VARCHAR2 DEFAULT NULL,
1507 x_payment_isir IN VARCHAR2 DEFAULT NULL,
1504 x_fedral_schl_code_indicator IN VARCHAR2 DEFAULT NULL,
1505 x_multi_school_code_flags IN VARCHAR2 DEFAULT NULL,
1506 x_dup_ssn_indicator IN VARCHAR2 DEFAULT NULL,
1508 x_receipt_status IN VARCHAR2 DEFAULT NULL,
1509 x_isir_receipt_completed IN VARCHAR2 DEFAULT NULL,
1510 x_creation_date IN DATE DEFAULT NULL,
1511 x_created_by IN NUMBER DEFAULT NULL,
1512 x_last_update_date IN DATE DEFAULT NULL,
1513 x_last_updated_by IN NUMBER DEFAULT NULL,
1514 x_last_update_login IN NUMBER DEFAULT NULL,
1515 x_system_record_type IN VARCHAR2 DEFAULT NULL,
1516 x_verif_track_flag IN VARCHAR2 DEFAULT NULL,
1517 x_active_isir IN VARCHAR2 DEFAULT NULL,
1518 x_fafsa_data_verify_flags IN VARCHAR2 DEFAULT NULL,
1519 x_reject_override_a IN VARCHAR2 DEFAULT NULL,
1520 x_reject_override_c IN VARCHAR2 DEFAULT NULL,
1521 x_parent_marital_status_date IN DATE DEFAULT NULL,
1522 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
1523 x_father_first_name_initial IN VARCHAR2 DEFAULT NULL,
1524 x_father_step_father_birth_dt IN DATE DEFAULT NULL,
1525 x_mother_first_name_initial IN VARCHAR2 DEFAULT NULL,
1526 x_mother_step_mother_birth_dt IN DATE DEFAULT NULL,
1527 x_parents_email_address_txt IN VARCHAR2 DEFAULT NULL,
1528 x_address_change_type IN VARCHAR2 DEFAULT NULL,
1529 x_cps_pushed_isir_flag IN VARCHAR2 DEFAULT NULL,
1530 x_electronic_transaction_type IN VARCHAR2 DEFAULT NULL,
1531 x_sar_c_change_type IN VARCHAR2 DEFAULT NULL,
1532 x_father_ssn_match_type IN VARCHAR2 DEFAULT NULL,
1533 x_mother_ssn_match_type IN VARCHAR2 DEFAULT NULL,
1534 x_reject_override_g_flag IN VARCHAR2 DEFAULT NULL,
1535 x_dhs_verification_num_txt IN VARCHAR2 DEFAULT NULL,
1536 x_data_file_name_txt IN VARCHAR2 DEFAULT NULL,
1537 x_message_class_txt IN VARCHAR2 DEFAULT NULL,
1538 x_reject_override_3_flag IN VARCHAR2 DEFAULT NULL,
1539 x_reject_override_12_flag IN VARCHAR2 DEFAULT NULL,
1540 x_reject_override_j_flag IN VARCHAR2 DEFAULT NULL,
1541 x_reject_override_k_flag IN VARCHAR2 DEFAULT NULL,
1542 x_rejected_status_change_flag IN VARCHAR2 DEFAULT NULL,
1543 x_verification_selection_flag IN VARCHAR2 DEFAULT NULL
1544 );
1545
1546 PROCEDURE update_row_rectype (
1547 p_isir_matched_rectype IN igf_ap_isir_matched%ROWTYPE
1548 );
1549
1550 END igf_ap_isir_matched_pkg;