[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select row_id from igf_ap_isir_matched
WHERE
active_isir = 'Y' and
base_id = l_base_id and
isir_id <> l_isir_id ;
UPDATE igf_ap_isir_matched set active_isir = 'N'
where row_id = l_isir.row_id;
x_selective_service_reg IN VARCHAR2,
x_degree_certification IN VARCHAR2,
x_grade_level_in_college IN VARCHAR2,
x_high_school_diploma_ged IN VARCHAR2,
x_first_bachelor_deg_by_date IN VARCHAR2,
x_interest_in_loan IN VARCHAR2,
x_interest_in_stud_employment IN VARCHAR2,
x_drug_offence_conviction IN VARCHAR2,
x_s_tax_return_status IN VARCHAR2,
x_s_type_tax_return IN VARCHAR2,
x_s_elig_1040ez IN VARCHAR2,
x_s_adjusted_gross_income IN NUMBER ,
x_s_fed_taxes_paid IN NUMBER ,
x_s_exemptions IN NUMBER ,
x_s_income_from_work IN NUMBER ,
x_spouse_income_from_work IN NUMBER ,
x_s_toa_amt_from_wsa IN NUMBER ,
x_s_toa_amt_from_wsb IN NUMBER ,
x_s_toa_amt_from_wsc IN NUMBER ,
x_s_investment_networth IN NUMBER ,
x_s_busi_farm_networth IN NUMBER ,
x_s_cash_savings IN NUMBER ,
x_va_months IN NUMBER ,
x_va_amount IN NUMBER ,
x_stud_dob_before_date IN VARCHAR2,
x_deg_beyond_bachelor IN VARCHAR2,
x_s_married IN VARCHAR2,
x_s_have_children IN VARCHAR2,
x_legal_dependents IN VARCHAR2,
x_orphan_ward_of_court IN VARCHAR2,
x_s_veteran IN VARCHAR2,
x_p_marital_status IN VARCHAR2,
x_father_ssn IN VARCHAR2,
x_f_last_name IN VARCHAR2,
x_mother_ssn IN VARCHAR2,
x_m_last_name IN VARCHAR2,
x_p_num_family_member IN NUMBER ,
x_p_num_in_college IN NUMBER ,
x_p_state_legal_residence IN VARCHAR2,
x_p_state_legal_res_before_dt IN VARCHAR2,
x_p_legal_res_date IN DATE ,
x_age_older_parent IN NUMBER ,
x_p_tax_return_status IN VARCHAR2,
x_p_type_tax_return IN VARCHAR2,
x_p_elig_1040aez IN VARCHAR2,
x_p_adjusted_gross_income IN NUMBER ,
x_p_taxes_paid IN NUMBER ,
x_p_exemptions IN NUMBER ,
x_f_income_work IN NUMBER ,
x_m_income_work IN NUMBER ,
x_p_income_wsa IN NUMBER ,
x_p_income_wsb IN NUMBER ,
x_p_income_wsc IN NUMBER ,
x_p_investment_networth IN NUMBER ,
x_p_business_networth IN NUMBER ,
x_p_cash_saving IN NUMBER ,
x_s_num_family_members IN NUMBER ,
x_s_num_in_college IN NUMBER ,
x_first_college IN VARCHAR2,
x_first_house_plan IN VARCHAR2,
x_second_college IN VARCHAR2,
x_second_house_plan IN VARCHAR2,
x_third_college IN VARCHAR2,
x_third_house_plan IN VARCHAR2,
x_fourth_college IN VARCHAR2,
x_fourth_house_plan IN VARCHAR2,
x_fifth_college IN VARCHAR2,
x_fifth_house_plan IN VARCHAR2,
x_sixth_college IN VARCHAR2,
x_sixth_house_plan IN VARCHAR2,
x_date_app_completed IN DATE ,
x_signed_by IN VARCHAR2,
x_preparer_ssn IN VARCHAR2,
x_preparer_emp_id_number IN VARCHAR2,
x_preparer_sign IN VARCHAR2,
x_transaction_receipt_date IN DATE ,
x_dependency_override_ind IN VARCHAR2,
x_faa_fedral_schl_code IN VARCHAR2,
x_faa_adjustment IN VARCHAR2,
x_input_record_type IN VARCHAR2,
x_serial_number IN NUMBER ,
x_batch_number IN VARCHAR2,
x_early_analysis_flag IN VARCHAR2,
x_app_entry_source_code IN VARCHAR2,
x_eti_destination_code IN VARCHAR2,
x_reject_override_b IN VARCHAR2,
x_reject_override_n IN VARCHAR2,
x_reject_override_w IN VARCHAR2,
x_assum_override_1 IN VARCHAR2,
x_assum_override_2 IN VARCHAR2,
x_assum_override_3 IN VARCHAR2,
x_assum_override_4 IN VARCHAR2,
x_assum_override_5 IN VARCHAR2,
x_assum_override_6 IN VARCHAR2,
x_dependency_status IN VARCHAR2,
x_s_email_address IN VARCHAR2,
x_nslds_reason_code IN VARCHAR2,
x_app_receipt_date IN DATE ,
x_processed_rec_type IN VARCHAR2,
x_hist_correction_for_tran_id IN NUMBER ,
x_system_generated_indicator IN VARCHAR2,
x_dup_request_indicator IN VARCHAR2,
x_source_of_correction IN VARCHAR2,
x_p_cal_tax_status IN VARCHAR2,
x_s_cal_tax_status IN VARCHAR2,
x_graduate_flag IN VARCHAR2,
x_auto_zero_efc IN VARCHAR2,
x_efc_change_flag IN VARCHAR2,
x_sarc_flag IN VARCHAR2,
x_simplified_need_test IN VARCHAR2,
x_reject_reason_codes IN VARCHAR2,
x_select_service_match_flag IN VARCHAR2,
x_select_service_reg_flag IN VARCHAR2,
x_ins_match_flag IN VARCHAR2,
x_ins_verification_number IN NUMBER ,
x_sec_ins_match_flag IN VARCHAR2,
x_sec_ins_ver_number IN NUMBER ,
x_ssn_match_flag IN VARCHAR2,
x_ssa_citizenship_flag IN VARCHAR2,
x_ssn_date_of_death IN DATE ,
x_nslds_match_flag IN VARCHAR2,
x_va_match_flag IN VARCHAR2,
x_prisoner_match IN VARCHAR2,
x_verification_flag IN VARCHAR2,
x_subsequent_app_flag IN VARCHAR2,
x_app_source_site_code IN VARCHAR2,
x_tran_source_site_code IN VARCHAR2,
x_drn IN NUMBER ,
x_tran_process_date IN DATE ,
x_computer_batch_number IN NUMBER ,
x_correction_flags IN VARCHAR2,
x_highlight_flags IN VARCHAR2,
x_paid_efc IN NUMBER ,
x_primary_efc IN NUMBER ,
x_secondary_efc IN NUMBER ,
x_fed_pell_grant_efc_type IN VARCHAR2,
x_primary_efc_type IN VARCHAR2,
x_sec_efc_type IN VARCHAR2,
x_primary_alternate_month_1 IN NUMBER ,
x_primary_alternate_month_2 IN NUMBER ,
x_primary_alternate_month_3 IN NUMBER ,
x_primary_alternate_month_4 IN NUMBER ,
x_primary_alternate_month_5 IN NUMBER ,
x_primary_alternate_month_6 IN NUMBER ,
x_primary_alternate_month_7 IN NUMBER ,
x_primary_alternate_month_8 IN NUMBER ,
x_primary_alternate_month_10 IN NUMBER ,
x_primary_alternate_month_11 IN NUMBER ,
x_primary_alternate_month_12 IN NUMBER ,
x_sec_alternate_month_1 IN NUMBER ,
x_sec_alternate_month_2 IN NUMBER ,
x_sec_alternate_month_3 IN NUMBER ,
x_sec_alternate_month_4 IN NUMBER ,
x_sec_alternate_month_5 IN NUMBER ,
x_sec_alternate_month_6 IN NUMBER ,
x_sec_alternate_month_7 IN NUMBER ,
x_sec_alternate_month_8 IN NUMBER ,
x_sec_alternate_month_10 IN NUMBER ,
x_sec_alternate_month_11 IN NUMBER ,
x_sec_alternate_month_12 IN NUMBER ,
x_total_income IN NUMBER ,
x_allow_total_income IN NUMBER ,
x_state_tax_allow IN NUMBER ,
x_employment_allow IN NUMBER ,
x_income_protection_allow IN NUMBER ,
x_available_income IN NUMBER ,
x_contribution_from_ai IN NUMBER ,
x_discretionary_networth IN NUMBER ,
x_efc_networth IN NUMBER ,
x_asset_protect_allow IN NUMBER ,
x_parents_cont_from_assets IN NUMBER ,
x_adjusted_available_income IN NUMBER ,
x_total_student_contribution IN NUMBER ,
x_total_parent_contribution IN NUMBER ,
x_parents_contribution IN NUMBER ,
x_student_total_income IN NUMBER ,
x_sati IN NUMBER ,
x_sic IN NUMBER ,
x_sdnw IN NUMBER ,
x_sca IN NUMBER ,
x_fti IN NUMBER ,
x_secti IN NUMBER ,
x_secati IN NUMBER ,
x_secstx IN NUMBER ,
x_secea IN NUMBER ,
x_secipa IN NUMBER ,
x_secai IN NUMBER ,
x_seccai IN NUMBER ,
x_secdnw IN NUMBER ,
x_secnw IN NUMBER ,
x_secapa IN NUMBER ,
x_secpca IN NUMBER ,
x_secaai IN NUMBER ,
x_sectsc IN NUMBER ,
x_sectpc IN NUMBER ,
x_secpc IN NUMBER ,
x_secsti IN NUMBER ,
x_secsic IN NUMBER ,
x_secsati IN NUMBER ,
x_secsdnw IN NUMBER ,
x_secsca IN NUMBER ,
x_secfti IN NUMBER ,
x_a_citizenship IN VARCHAR2,
x_a_student_marital_status IN VARCHAR2,
x_a_student_agi IN NUMBER ,
x_a_s_us_tax_paid IN NUMBER ,
x_a_s_income_work IN NUMBER ,
x_a_spouse_income_work IN NUMBER ,
x_a_s_total_wsc IN NUMBER ,
x_a_date_of_birth IN VARCHAR2,
x_a_student_married IN VARCHAR2,
x_a_have_children IN VARCHAR2,
x_a_s_have_dependents IN VARCHAR2,
x_a_va_status IN VARCHAR2,
x_a_s_num_in_family IN NUMBER ,
x_a_s_num_in_college IN NUMBER ,
x_a_p_marital_status IN VARCHAR2,
x_a_father_ssn IN VARCHAR2,
x_a_mother_ssn IN VARCHAR2,
x_a_parents_num_family IN NUMBER ,
x_a_parents_num_college IN NUMBER ,
x_a_parents_agi IN NUMBER ,
x_a_p_us_tax_paid IN NUMBER ,
x_a_f_work_income IN NUMBER ,
x_a_m_work_income IN NUMBER ,
x_a_p_total_wsc IN NUMBER ,
x_comment_codes IN VARCHAR2,
x_sar_ack_comm_code IN VARCHAR2,
x_pell_grant_elig_flag IN VARCHAR2,
x_reprocess_reason_code IN VARCHAR2,
x_duplicate_date IN DATE ,
x_isir_transaction_type IN VARCHAR2,
x_fedral_schl_code_indicator IN VARCHAR2,
x_multi_school_code_flags IN VARCHAR2,
x_dup_ssn_indicator IN VARCHAR2,
x_payment_isir IN VARCHAR2,
x_receipt_status IN VARCHAR2,
x_isir_receipt_completed IN VARCHAR2,
x_creation_date IN DATE ,
x_created_by IN NUMBER ,
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER ,
x_system_record_type IN VARCHAR2,
x_verif_track_flag IN VARCHAR2,
x_active_isir IN VARCHAR2,
x_fafsa_data_verify_flags IN VARCHAR2,
x_reject_override_a IN VARCHAR2,
x_reject_override_c IN VARCHAR2,
x_parent_marital_status_date IN DATE,
x_legacy_record_flag IN VARCHAR2,
x_father_first_name_initial IN VARCHAR2,
x_father_step_father_birth_dt IN DATE ,
x_mother_first_name_initial IN VARCHAR2,
x_mother_step_mother_birth_dt IN DATE ,
x_parents_email_address_txt IN VARCHAR2,
x_address_change_type IN VARCHAR2,
x_cps_pushed_isir_flag IN VARCHAR2,
x_electronic_transaction_type IN VARCHAR2,
x_sar_c_change_type IN VARCHAR2,
x_father_ssn_match_type IN VARCHAR2,
x_mother_ssn_match_type IN VARCHAR2,
x_reject_override_g_flag IN VARCHAR2,
x_dhs_verification_num_txt IN VARCHAR2,
x_data_file_name_txt IN VARCHAR2,
x_message_class_txt IN VARCHAR2,
x_reject_override_3_flag IN VARCHAR2,
x_reject_override_12_flag IN VARCHAR2,
x_reject_override_j_flag IN VARCHAR2,
x_reject_override_k_flag IN VARCHAR2,
x_rejected_status_change_flag IN VARCHAR2,
x_verification_selection_flag IN VARCHAR2
) AS
/*
|| Created By : rasingh
|| Created On : 06-DEC-2000
|| Purpose : Initialises the Old and New references for the columns of the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
CURSOR cur_old_ref_values IS
SELECT *
FROM IGF_AP_ISIR_MATCHED_ALL
WHERE rowid = x_rowid;
IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
CLOSE cur_old_ref_values;
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
new_references.selective_service_reg := x_selective_service_reg;
new_references.select_service_match_flag := x_select_service_match_flag;
new_references.select_service_reg_flag := x_select_service_reg_flag;
new_references.verification_selection_flag := x_verification_selection_flag;
IF (p_action = 'UPDATE') THEN
new_references.creation_date := old_references.creation_date;
new_references.last_update_date := x_last_update_date;
new_references.last_updated_by := x_last_updated_by;
new_references.last_update_login := x_last_update_login;
SELECT rowid
FROM igf_ap_isir_matched_all
WHERE isir_id = x_isir_id
FOR UPDATE NOWAIT;
x_selective_service_reg IN VARCHAR2,
x_degree_certification IN VARCHAR2,
x_grade_level_in_college IN VARCHAR2,
x_high_school_diploma_ged IN VARCHAR2,
x_first_bachelor_deg_by_date IN VARCHAR2,
x_interest_in_loan IN VARCHAR2,
x_interest_in_stud_employment IN VARCHAR2,
x_drug_offence_conviction IN VARCHAR2,
x_s_tax_return_status IN VARCHAR2,
x_s_type_tax_return IN VARCHAR2,
x_s_elig_1040ez IN VARCHAR2,
x_s_adjusted_gross_income IN NUMBER ,
x_s_fed_taxes_paid IN NUMBER ,
x_s_exemptions IN NUMBER ,
x_s_income_from_work IN NUMBER ,
x_spouse_income_from_work IN NUMBER ,
x_s_toa_amt_from_wsa IN NUMBER ,
x_s_toa_amt_from_wsb IN NUMBER ,
x_s_toa_amt_from_wsc IN NUMBER ,
x_s_investment_networth IN NUMBER ,
x_s_busi_farm_networth IN NUMBER ,
x_s_cash_savings IN NUMBER ,
x_va_months IN NUMBER ,
x_va_amount IN NUMBER ,
x_stud_dob_before_date IN VARCHAR2,
x_deg_beyond_bachelor IN VARCHAR2,
x_s_married IN VARCHAR2,
x_s_have_children IN VARCHAR2,
x_legal_dependents IN VARCHAR2,
x_orphan_ward_of_court IN VARCHAR2,
x_s_veteran IN VARCHAR2,
x_p_marital_status IN VARCHAR2,
x_father_ssn IN VARCHAR2,
x_f_last_name IN VARCHAR2,
x_mother_ssn IN VARCHAR2,
x_m_last_name IN VARCHAR2,
x_p_num_family_member IN NUMBER ,
x_p_num_in_college IN NUMBER ,
x_p_state_legal_residence IN VARCHAR2,
x_p_state_legal_res_before_dt IN VARCHAR2,
x_p_legal_res_date IN DATE ,
x_age_older_parent IN NUMBER ,
x_p_tax_return_status IN VARCHAR2,
x_p_type_tax_return IN VARCHAR2,
x_p_elig_1040aez IN VARCHAR2,
x_p_adjusted_gross_income IN NUMBER ,
x_p_taxes_paid IN NUMBER ,
x_p_exemptions IN NUMBER ,
x_f_income_work IN NUMBER ,
x_m_income_work IN NUMBER ,
x_p_income_wsa IN NUMBER ,
x_p_income_wsb IN NUMBER ,
x_p_income_wsc IN NUMBER ,
x_p_investment_networth IN NUMBER ,
x_p_business_networth IN NUMBER ,
x_p_cash_saving IN NUMBER ,
x_s_num_family_members IN NUMBER ,
x_s_num_in_college IN NUMBER ,
x_first_college IN VARCHAR2,
x_first_house_plan IN VARCHAR2,
x_second_college IN VARCHAR2,
x_second_house_plan IN VARCHAR2,
x_third_college IN VARCHAR2,
x_third_house_plan IN VARCHAR2,
x_fourth_college IN VARCHAR2,
x_fourth_house_plan IN VARCHAR2,
x_fifth_college IN VARCHAR2,
x_fifth_house_plan IN VARCHAR2,
x_sixth_college IN VARCHAR2,
x_sixth_house_plan IN VARCHAR2,
x_date_app_completed IN DATE ,
x_signed_by IN VARCHAR2,
x_preparer_ssn IN VARCHAR2,
x_preparer_emp_id_number IN VARCHAR2,
x_preparer_sign IN VARCHAR2,
x_transaction_receipt_date IN DATE ,
x_dependency_override_ind IN VARCHAR2,
x_faa_fedral_schl_code IN VARCHAR2,
x_faa_adjustment IN VARCHAR2,
x_input_record_type IN VARCHAR2,
x_serial_number IN NUMBER ,
x_batch_number IN VARCHAR2,
x_early_analysis_flag IN VARCHAR2,
x_app_entry_source_code IN VARCHAR2,
x_eti_destination_code IN VARCHAR2,
x_reject_override_b IN VARCHAR2,
x_reject_override_n IN VARCHAR2,
x_reject_override_w IN VARCHAR2,
x_assum_override_1 IN VARCHAR2,
x_assum_override_2 IN VARCHAR2,
x_assum_override_3 IN VARCHAR2,
x_assum_override_4 IN VARCHAR2,
x_assum_override_5 IN VARCHAR2,
x_assum_override_6 IN VARCHAR2,
x_dependency_status IN VARCHAR2,
x_s_email_address IN VARCHAR2,
x_nslds_reason_code IN VARCHAR2,
x_app_receipt_date IN DATE ,
x_processed_rec_type IN VARCHAR2,
x_hist_correction_for_tran_id IN NUMBER ,
x_system_generated_indicator IN VARCHAR2,
x_dup_request_indicator IN VARCHAR2,
x_source_of_correction IN VARCHAR2,
x_p_cal_tax_status IN VARCHAR2,
x_s_cal_tax_status IN VARCHAR2,
x_graduate_flag IN VARCHAR2,
x_auto_zero_efc IN VARCHAR2,
x_efc_change_flag IN VARCHAR2,
x_sarc_flag IN VARCHAR2,
x_simplified_need_test IN VARCHAR2,
x_reject_reason_codes IN VARCHAR2,
x_select_service_match_flag IN VARCHAR2,
x_select_service_reg_flag IN VARCHAR2,
x_ins_match_flag IN VARCHAR2,
x_ins_verification_number IN NUMBER ,
x_sec_ins_match_flag IN VARCHAR2,
x_sec_ins_ver_number IN NUMBER ,
x_ssn_match_flag IN VARCHAR2,
x_ssa_citizenship_flag IN VARCHAR2,
x_ssn_date_of_death IN DATE ,
x_nslds_match_flag IN VARCHAR2,
x_va_match_flag IN VARCHAR2,
x_prisoner_match IN VARCHAR2,
x_verification_flag IN VARCHAR2,
x_subsequent_app_flag IN VARCHAR2,
x_app_source_site_code IN VARCHAR2,
x_tran_source_site_code IN VARCHAR2,
x_drn IN NUMBER ,
x_tran_process_date IN DATE ,
x_computer_batch_number IN NUMBER ,
x_correction_flags IN VARCHAR2,
x_highlight_flags IN VARCHAR2,
x_paid_efc IN NUMBER ,
x_primary_efc IN NUMBER ,
x_secondary_efc IN NUMBER ,
x_fed_pell_grant_efc_type IN VARCHAR2,
x_primary_efc_type IN VARCHAR2,
x_sec_efc_type IN VARCHAR2,
x_primary_alternate_month_1 IN NUMBER ,
x_primary_alternate_month_2 IN NUMBER ,
x_primary_alternate_month_3 IN NUMBER ,
x_primary_alternate_month_4 IN NUMBER ,
x_primary_alternate_month_5 IN NUMBER ,
x_primary_alternate_month_6 IN NUMBER ,
x_primary_alternate_month_7 IN NUMBER ,
x_primary_alternate_month_8 IN NUMBER ,
x_primary_alternate_month_10 IN NUMBER ,
x_primary_alternate_month_11 IN NUMBER ,
x_primary_alternate_month_12 IN NUMBER ,
x_sec_alternate_month_1 IN NUMBER ,
x_sec_alternate_month_2 IN NUMBER ,
x_sec_alternate_month_3 IN NUMBER ,
x_sec_alternate_month_4 IN NUMBER ,
x_sec_alternate_month_5 IN NUMBER ,
x_sec_alternate_month_6 IN NUMBER ,
x_sec_alternate_month_7 IN NUMBER ,
x_sec_alternate_month_8 IN NUMBER ,
x_sec_alternate_month_10 IN NUMBER ,
x_sec_alternate_month_11 IN NUMBER ,
x_sec_alternate_month_12 IN NUMBER ,
x_total_income IN NUMBER ,
x_allow_total_income IN NUMBER ,
x_state_tax_allow IN NUMBER ,
x_employment_allow IN NUMBER ,
x_income_protection_allow IN NUMBER ,
x_available_income IN NUMBER ,
x_contribution_from_ai IN NUMBER ,
x_discretionary_networth IN NUMBER ,
x_efc_networth IN NUMBER ,
x_asset_protect_allow IN NUMBER ,
x_parents_cont_from_assets IN NUMBER ,
x_adjusted_available_income IN NUMBER ,
x_total_student_contribution IN NUMBER ,
x_total_parent_contribution IN NUMBER ,
x_parents_contribution IN NUMBER ,
x_student_total_income IN NUMBER ,
x_sati IN NUMBER ,
x_sic IN NUMBER ,
x_sdnw IN NUMBER ,
x_sca IN NUMBER ,
x_fti IN NUMBER ,
x_secti IN NUMBER ,
x_secati IN NUMBER ,
x_secstx IN NUMBER ,
x_secea IN NUMBER ,
x_secipa IN NUMBER ,
x_secai IN NUMBER ,
x_seccai IN NUMBER ,
x_secdnw IN NUMBER ,
x_secnw IN NUMBER ,
x_secapa IN NUMBER ,
x_secpca IN NUMBER ,
x_secaai IN NUMBER ,
x_sectsc IN NUMBER ,
x_sectpc IN NUMBER ,
x_secpc IN NUMBER ,
x_secsti IN NUMBER ,
x_secsic IN NUMBER ,
x_secsati IN NUMBER ,
x_secsdnw IN NUMBER ,
x_secsca IN NUMBER ,
x_secfti IN NUMBER ,
x_a_citizenship IN VARCHAR2,
x_a_student_marital_status IN VARCHAR2,
x_a_student_agi IN NUMBER ,
x_a_s_us_tax_paid IN NUMBER ,
x_a_s_income_work IN NUMBER ,
x_a_spouse_income_work IN NUMBER ,
x_a_s_total_wsc IN NUMBER ,
x_a_date_of_birth IN VARCHAR2,
x_a_student_married IN VARCHAR2,
x_a_have_children IN VARCHAR2,
x_a_s_have_dependents IN VARCHAR2,
x_a_va_status IN VARCHAR2,
x_a_s_num_in_family IN NUMBER ,
x_a_s_num_in_college IN NUMBER ,
x_a_p_marital_status IN VARCHAR2,
x_a_father_ssn IN VARCHAR2,
x_a_mother_ssn IN VARCHAR2,
x_a_parents_num_family IN NUMBER ,
x_a_parents_num_college IN NUMBER ,
x_a_parents_agi IN NUMBER ,
x_a_p_us_tax_paid IN NUMBER ,
x_a_f_work_income IN NUMBER ,
x_a_m_work_income IN NUMBER ,
x_a_p_total_wsc IN NUMBER ,
x_comment_codes IN VARCHAR2,
x_sar_ack_comm_code IN VARCHAR2,
x_pell_grant_elig_flag IN VARCHAR2,
x_reprocess_reason_code IN VARCHAR2,
x_duplicate_date IN DATE ,
x_isir_transaction_type IN VARCHAR2,
x_fedral_schl_code_indicator IN VARCHAR2,
x_multi_school_code_flags IN VARCHAR2,
x_dup_ssn_indicator IN VARCHAR2,
x_payment_isir IN VARCHAR2,
x_receipt_status IN VARCHAR2,
x_isir_receipt_completed IN VARCHAR2,
x_creation_date IN DATE ,
x_created_by IN NUMBER ,
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER ,
x_system_record_type IN VARCHAR2,
x_verif_track_flag IN VARCHAR2,
x_active_isir IN VARCHAR2,
x_fafsa_data_verify_flags IN VARCHAR2,
x_reject_override_a IN VARCHAR2,
x_reject_override_c IN VARCHAR2,
x_parent_marital_status_date IN DATE ,
x_legacy_record_flag IN VARCHAR2,
x_father_first_name_initial IN VARCHAR2,
x_father_step_father_birth_dt IN DATE ,
x_mother_first_name_initial IN VARCHAR2,
x_mother_step_mother_birth_dt IN DATE ,
x_parents_email_address_txt IN VARCHAR2,
x_address_change_type IN VARCHAR2,
x_cps_pushed_isir_flag IN VARCHAR2,
x_electronic_transaction_type IN VARCHAR2,
x_sar_c_change_type IN VARCHAR2,
x_father_ssn_match_type IN VARCHAR2,
x_mother_ssn_match_type IN VARCHAR2,
x_reject_override_g_flag IN VARCHAR2,
x_dhs_verification_num_txt IN VARCHAR2,
x_data_file_name_txt IN VARCHAR2,
x_message_class_txt IN VARCHAR2,
x_reject_override_3_flag IN VARCHAR2,
x_reject_override_12_flag IN VARCHAR2,
x_reject_override_j_flag IN VARCHAR2,
x_reject_override_k_flag IN VARCHAR2,
x_rejected_status_change_flag IN VARCHAR2,
x_verification_selection_flag IN VARCHAR2
) AS
/*
|| Created By : rasingh
|| Created On : 06-DEC-2000
|| Purpose : Initialises the columns, Checks Constraints, Calls the
|| Trigger Handlers for the table, before any DML operation.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
BEGIN
set_column_values (
p_action,
x_rowid,
x_isir_id,
x_base_id,
x_batch_year,
x_transaction_num,
x_current_ssn,
x_ssn_name_change,
x_original_ssn,
x_orig_name_id,
x_last_name,
x_first_name,
x_middle_initial,
x_perm_mail_add,
x_perm_city,
x_perm_state,
x_perm_zip_code,
x_date_of_birth,
x_phone_number,
x_driver_license_number,
x_driver_license_state,
x_citizenship_status,
x_alien_reg_number,
x_s_marital_status,
x_s_marital_status_date,
x_summ_enrl_status,
x_fall_enrl_status,
x_winter_enrl_status,
x_spring_enrl_status,
x_summ2_enrl_status,
x_fathers_highest_edu_level,
x_mothers_highest_edu_level,
x_s_state_legal_residence,
x_legal_residence_before_date,
x_s_legal_resd_date,
x_ss_r_u_male,
x_selective_service_reg,
x_degree_certification,
x_grade_level_in_college,
x_high_school_diploma_ged,
x_first_bachelor_deg_by_date,
x_interest_in_loan,
x_interest_in_stud_employment,
x_drug_offence_conviction,
x_s_tax_return_status,
x_s_type_tax_return,
x_s_elig_1040ez,
x_s_adjusted_gross_income,
x_s_fed_taxes_paid,
x_s_exemptions,
x_s_income_from_work,
x_spouse_income_from_work,
x_s_toa_amt_from_wsa,
x_s_toa_amt_from_wsb,
x_s_toa_amt_from_wsc,
x_s_investment_networth,
x_s_busi_farm_networth,
x_s_cash_savings,
x_va_months,
x_va_amount,
x_stud_dob_before_date,
x_deg_beyond_bachelor,
x_s_married,
x_s_have_children,
x_legal_dependents,
x_orphan_ward_of_court,
x_s_veteran,
x_p_marital_status,
x_father_ssn,
x_f_last_name,
x_mother_ssn,
x_m_last_name,
x_p_num_family_member,
x_p_num_in_college,
x_p_state_legal_residence,
x_p_state_legal_res_before_dt,
x_p_legal_res_date,
x_age_older_parent,
x_p_tax_return_status,
x_p_type_tax_return,
x_p_elig_1040aez,
x_p_adjusted_gross_income,
x_p_taxes_paid,
x_p_exemptions,
x_f_income_work,
x_m_income_work,
x_p_income_wsa,
x_p_income_wsb,
x_p_income_wsc,
x_p_investment_networth,
x_p_business_networth,
x_p_cash_saving,
x_s_num_family_members,
x_s_num_in_college,
x_first_college,
x_first_house_plan,
x_second_college,
x_second_house_plan,
x_third_college,
x_third_house_plan,
x_fourth_college,
x_fourth_house_plan,
x_fifth_college,
x_fifth_house_plan,
x_sixth_college,
x_sixth_house_plan,
x_date_app_completed,
x_signed_by,
x_preparer_ssn,
x_preparer_emp_id_number,
x_preparer_sign,
x_transaction_receipt_date,
x_dependency_override_ind,
x_faa_fedral_schl_code,
x_faa_adjustment,
x_input_record_type,
x_serial_number,
x_batch_number,
x_early_analysis_flag,
x_app_entry_source_code,
x_eti_destination_code,
x_reject_override_b,
x_reject_override_n,
x_reject_override_w,
x_assum_override_1,
x_assum_override_2,
x_assum_override_3,
x_assum_override_4,
x_assum_override_5,
x_assum_override_6,
x_dependency_status,
x_s_email_address,
x_nslds_reason_code,
x_app_receipt_date,
x_processed_rec_type,
x_hist_correction_for_tran_id,
x_system_generated_indicator,
x_dup_request_indicator,
x_source_of_correction,
x_p_cal_tax_status,
x_s_cal_tax_status,
x_graduate_flag,
x_auto_zero_efc,
x_efc_change_flag,
x_sarc_flag,
x_simplified_need_test,
x_reject_reason_codes,
x_select_service_match_flag,
x_select_service_reg_flag,
x_ins_match_flag,
x_ins_verification_number,
x_sec_ins_match_flag,
x_sec_ins_ver_number,
x_ssn_match_flag,
x_ssa_citizenship_flag,
x_ssn_date_of_death,
x_nslds_match_flag,
x_va_match_flag,
x_prisoner_match,
x_verification_flag,
x_subsequent_app_flag,
x_app_source_site_code,
x_tran_source_site_code,
x_drn,
x_tran_process_date,
x_computer_batch_number,
x_correction_flags,
x_highlight_flags,
x_paid_efc,
x_primary_efc,
x_secondary_efc,
x_fed_pell_grant_efc_type,
x_primary_efc_type,
x_sec_efc_type,
x_primary_alternate_month_1,
x_primary_alternate_month_2,
x_primary_alternate_month_3,
x_primary_alternate_month_4,
x_primary_alternate_month_5,
x_primary_alternate_month_6,
x_primary_alternate_month_7,
x_primary_alternate_month_8,
x_primary_alternate_month_10,
x_primary_alternate_month_11,
x_primary_alternate_month_12,
x_sec_alternate_month_1,
x_sec_alternate_month_2,
x_sec_alternate_month_3,
x_sec_alternate_month_4,
x_sec_alternate_month_5,
x_sec_alternate_month_6,
x_sec_alternate_month_7,
x_sec_alternate_month_8,
x_sec_alternate_month_10,
x_sec_alternate_month_11,
x_sec_alternate_month_12,
x_total_income,
x_allow_total_income,
x_state_tax_allow,
x_employment_allow,
x_income_protection_allow,
x_available_income,
x_contribution_from_ai,
x_discretionary_networth,
x_efc_networth,
x_asset_protect_allow,
x_parents_cont_from_assets,
x_adjusted_available_income,
x_total_student_contribution,
x_total_parent_contribution,
x_parents_contribution,
x_student_total_income,
x_sati,
x_sic,
x_sdnw,
x_sca,
x_fti,
x_secti,
x_secati,
x_secstx,
x_secea,
x_secipa,
x_secai,
x_seccai,
x_secdnw,
x_secnw,
x_secapa,
x_secpca,
x_secaai,
x_sectsc,
x_sectpc,
x_secpc,
x_secsti,
x_secsic,
x_secsati,
x_secsdnw,
x_secsca,
x_secfti,
x_a_citizenship,
x_a_student_marital_status,
x_a_student_agi,
x_a_s_us_tax_paid,
x_a_s_income_work,
x_a_spouse_income_work,
x_a_s_total_wsc,
x_a_date_of_birth,
x_a_student_married,
x_a_have_children,
x_a_s_have_dependents,
x_a_va_status,
x_a_s_num_in_family,
x_a_s_num_in_college,
x_a_p_marital_status,
x_a_father_ssn,
x_a_mother_ssn,
x_a_parents_num_family,
x_a_parents_num_college,
x_a_parents_agi,
x_a_p_us_tax_paid,
x_a_f_work_income,
x_a_m_work_income,
x_a_p_total_wsc,
x_comment_codes,
x_sar_ack_comm_code,
x_pell_grant_elig_flag,
x_reprocess_reason_code,
x_duplicate_date,
x_isir_transaction_type,
x_fedral_schl_code_indicator,
x_multi_school_code_flags,
x_dup_ssn_indicator,
x_payment_isir,
x_receipt_status,
x_isir_receipt_completed,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_system_record_type,
x_verif_track_flag,
x_active_isir,
x_fafsa_data_verify_flags,
x_reject_override_a,
x_reject_override_c,
x_parent_marital_status_date,
x_legacy_record_flag,
x_father_first_name_initial,
x_father_step_father_birth_dt,
x_mother_first_name_initial,
x_mother_step_mother_birth_dt,
x_parents_email_address_txt ,
x_address_change_type,
x_cps_pushed_isir_flag,
x_electronic_transaction_type,
x_sar_c_change_type ,
x_father_ssn_match_type,
x_mother_ssn_match_type,
x_reject_override_g_flag,
x_dhs_verification_num_txt,
x_data_file_name_txt,
x_message_class_txt,
x_reject_override_3_flag,
x_reject_override_12_flag,
x_reject_override_j_flag,
x_reject_override_k_flag ,
x_rejected_status_change_flag,
x_verification_selection_flag
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation(
new_references.isir_id
)
) THEN
fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to Before Delete.
check_child_existance;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation (
new_references.isir_id
)
) THEN
fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'VALIDATE_DELETE') THEN
check_child_existance;
SELECT person_id
FROM igf_ap_fa_base_rec_all
WHERE base_id = p_base_id;
SELECT hz.party_id party_id
FROM hz_parties hz,
igs_or_org_alt_ids oli,
igs_or_org_alt_idtyp olt
WHERE oli.org_structure_id = hz.party_number
AND oli.org_alternate_id_type = olt.org_alternate_id_type
AND SYSDATE BETWEEN oli.start_date AND NVL(oli.end_date, SYSDATE)
AND hz.status = 'A'
AND olt.system_id_type = 'FED_SCH_CD'
AND oli.org_alternate_id = p_school_code;
SELECT 'X'
FROM hz_relationships
WHERE subject_id = p_subject_id
AND object_id = p_object_id
AND relationship_code='ATTENDS_INSTITUTION'
AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);
lv_last_update_date hz_parties.last_update_date%TYPE ;
lv_last_update_date := SYSDATE;
igs_pe_relationships_pkg.creatupdate_party_relationship ( p_action => 'INSERT',
p_subject_id => l_subject_id,
p_object_id => l_object_id,
p_party_relationship_type => 'STUDENTINSTITUTION',
p_relationship_code => 'ATTENDS_INSTITUTION',
p_comments => '',
p_start_date => SYSDATE,
p_end_date => null,
p_last_update_date => lv_last_update_date,
p_return_status => lv_return_status,
p_msg_count => lv_msg_count,
p_msg_data => lv_msg_data,
p_party_relationship_id => lv_party_relationship_id,
p_party_id => lv_party_id,
p_party_number => lv_party_number,
p_object_version_number => lv_object_version_number,
p_directional_flag => 'F'
);
PROCEDURE insert_row (
x_rowid IN OUT NOCOPY VARCHAR2,
x_isir_id IN OUT NOCOPY NUMBER,
x_base_id IN NUMBER,
x_batch_year IN NUMBER,
x_transaction_num IN VARCHAR2,
x_current_ssn IN VARCHAR2,
x_ssn_name_change IN VARCHAR2,
x_original_ssn IN VARCHAR2,
x_orig_name_id IN VARCHAR2,
x_last_name IN VARCHAR2,
x_first_name IN VARCHAR2,
x_middle_initial IN VARCHAR2,
x_perm_mail_add IN VARCHAR2,
x_perm_city IN VARCHAR2,
x_perm_state IN VARCHAR2,
x_perm_zip_code IN VARCHAR2,
x_date_of_birth IN DATE,
x_phone_number IN VARCHAR2,
x_driver_license_number IN VARCHAR2,
x_driver_license_state IN VARCHAR2,
x_citizenship_status IN VARCHAR2,
x_alien_reg_number IN VARCHAR2,
x_s_marital_status IN VARCHAR2,
x_s_marital_status_date IN DATE,
x_summ_enrl_status IN VARCHAR2,
x_fall_enrl_status IN VARCHAR2,
x_winter_enrl_status IN VARCHAR2,
x_spring_enrl_status IN VARCHAR2,
x_summ2_enrl_status IN VARCHAR2,
x_fathers_highest_edu_level IN VARCHAR2,
x_mothers_highest_edu_level IN VARCHAR2,
x_s_state_legal_residence IN VARCHAR2,
x_legal_residence_before_date IN VARCHAR2,
x_s_legal_resd_date IN DATE,
x_ss_r_u_male IN VARCHAR2,
x_selective_service_reg IN VARCHAR2,
x_degree_certification IN VARCHAR2,
x_grade_level_in_college IN VARCHAR2,
x_high_school_diploma_ged IN VARCHAR2,
x_first_bachelor_deg_by_date IN VARCHAR2,
x_interest_in_loan IN VARCHAR2,
x_interest_in_stud_employment IN VARCHAR2,
x_drug_offence_conviction IN VARCHAR2,
x_s_tax_return_status IN VARCHAR2,
x_s_type_tax_return IN VARCHAR2,
x_s_elig_1040ez IN VARCHAR2,
x_s_adjusted_gross_income IN NUMBER,
x_s_fed_taxes_paid IN NUMBER,
x_s_exemptions IN NUMBER,
x_s_income_from_work IN NUMBER,
x_spouse_income_from_work IN NUMBER,
x_s_toa_amt_from_wsa IN NUMBER,
x_s_toa_amt_from_wsb IN NUMBER,
x_s_toa_amt_from_wsc IN NUMBER,
x_s_investment_networth IN NUMBER,
x_s_busi_farm_networth IN NUMBER,
x_s_cash_savings IN NUMBER,
x_va_months IN NUMBER,
x_va_amount IN NUMBER,
x_stud_dob_before_date IN VARCHAR2,
x_deg_beyond_bachelor IN VARCHAR2,
x_s_married IN VARCHAR2,
x_s_have_children IN VARCHAR2,
x_legal_dependents IN VARCHAR2,
x_orphan_ward_of_court IN VARCHAR2,
x_s_veteran IN VARCHAR2,
x_p_marital_status IN VARCHAR2,
x_father_ssn IN VARCHAR2,
x_f_last_name IN VARCHAR2,
x_mother_ssn IN VARCHAR2,
x_m_last_name IN VARCHAR2,
x_p_num_family_member IN NUMBER,
x_p_num_in_college IN NUMBER,
x_p_state_legal_residence IN VARCHAR2,
x_p_state_legal_res_before_dt IN VARCHAR2,
x_p_legal_res_date IN DATE,
x_age_older_parent IN NUMBER,
x_p_tax_return_status IN VARCHAR2,
x_p_type_tax_return IN VARCHAR2,
x_p_elig_1040aez IN VARCHAR2,
x_p_adjusted_gross_income IN NUMBER,
x_p_taxes_paid IN NUMBER,
x_p_exemptions IN NUMBER,
x_f_income_work IN NUMBER,
x_m_income_work IN NUMBER,
x_p_income_wsa IN NUMBER,
x_p_income_wsb IN NUMBER,
x_p_income_wsc IN NUMBER,
x_p_investment_networth IN NUMBER,
x_p_business_networth IN NUMBER,
x_p_cash_saving IN NUMBER,
x_s_num_family_members IN NUMBER,
x_s_num_in_college IN NUMBER,
x_first_college IN VARCHAR2,
x_first_house_plan IN VARCHAR2,
x_second_college IN VARCHAR2,
x_second_house_plan IN VARCHAR2,
x_third_college IN VARCHAR2,
x_third_house_plan IN VARCHAR2,
x_fourth_college IN VARCHAR2,
x_fourth_house_plan IN VARCHAR2,
x_fifth_college IN VARCHAR2,
x_fifth_house_plan IN VARCHAR2,
x_sixth_college IN VARCHAR2,
x_sixth_house_plan IN VARCHAR2,
x_date_app_completed IN DATE,
x_signed_by IN VARCHAR2,
x_preparer_ssn IN VARCHAR2,
x_preparer_emp_id_number IN VARCHAR2,
x_preparer_sign IN VARCHAR2,
x_transaction_receipt_date IN DATE,
x_dependency_override_ind IN VARCHAR2,
x_faa_fedral_schl_code IN VARCHAR2,
x_faa_adjustment IN VARCHAR2,
x_input_record_type IN VARCHAR2,
x_serial_number IN NUMBER,
x_batch_number IN VARCHAR2,
x_early_analysis_flag IN VARCHAR2,
x_app_entry_source_code IN VARCHAR2,
x_eti_destination_code IN VARCHAR2,
x_reject_override_b IN VARCHAR2,
x_reject_override_n IN VARCHAR2,
x_reject_override_w IN VARCHAR2,
x_assum_override_1 IN VARCHAR2,
x_assum_override_2 IN VARCHAR2,
x_assum_override_3 IN VARCHAR2,
x_assum_override_4 IN VARCHAR2,
x_assum_override_5 IN VARCHAR2,
x_assum_override_6 IN VARCHAR2,
x_dependency_status IN VARCHAR2,
x_s_email_address IN VARCHAR2,
x_nslds_reason_code IN VARCHAR2,
x_app_receipt_date IN DATE,
x_processed_rec_type IN VARCHAR2,
x_hist_correction_for_tran_id IN NUMBER,
x_system_generated_indicator IN VARCHAR2,
x_dup_request_indicator IN VARCHAR2,
x_source_of_correction IN VARCHAR2,
x_p_cal_tax_status IN VARCHAR2,
x_s_cal_tax_status IN VARCHAR2,
x_graduate_flag IN VARCHAR2,
x_auto_zero_efc IN VARCHAR2,
x_efc_change_flag IN VARCHAR2,
x_sarc_flag IN VARCHAR2,
x_simplified_need_test IN VARCHAR2,
x_reject_reason_codes IN VARCHAR2,
x_select_service_match_flag IN VARCHAR2,
x_select_service_reg_flag IN VARCHAR2,
x_ins_match_flag IN VARCHAR2,
x_ins_verification_number IN NUMBER,
x_sec_ins_match_flag IN VARCHAR2,
x_sec_ins_ver_number IN NUMBER,
x_ssn_match_flag IN VARCHAR2,
x_ssa_citizenship_flag IN VARCHAR2,
x_ssn_date_of_death IN DATE,
x_nslds_match_flag IN VARCHAR2,
x_va_match_flag IN VARCHAR2,
x_prisoner_match IN VARCHAR2,
x_verification_flag IN VARCHAR2,
x_subsequent_app_flag IN VARCHAR2,
x_app_source_site_code IN VARCHAR2,
x_tran_source_site_code IN VARCHAR2,
x_drn IN NUMBER,
x_tran_process_date IN DATE,
x_computer_batch_number IN NUMBER,
x_correction_flags IN VARCHAR2,
x_highlight_flags IN VARCHAR2,
x_paid_efc IN NUMBER,
x_primary_efc IN NUMBER,
x_secondary_efc IN NUMBER,
x_fed_pell_grant_efc_type IN VARCHAR2,
x_primary_efc_type IN VARCHAR2,
x_sec_efc_type IN VARCHAR2,
x_primary_alternate_month_1 IN NUMBER,
x_primary_alternate_month_2 IN NUMBER,
x_primary_alternate_month_3 IN NUMBER,
x_primary_alternate_month_4 IN NUMBER,
x_primary_alternate_month_5 IN NUMBER,
x_primary_alternate_month_6 IN NUMBER,
x_primary_alternate_month_7 IN NUMBER,
x_primary_alternate_month_8 IN NUMBER,
x_primary_alternate_month_10 IN NUMBER,
x_primary_alternate_month_11 IN NUMBER,
x_primary_alternate_month_12 IN NUMBER,
x_sec_alternate_month_1 IN NUMBER,
x_sec_alternate_month_2 IN NUMBER,
x_sec_alternate_month_3 IN NUMBER,
x_sec_alternate_month_4 IN NUMBER,
x_sec_alternate_month_5 IN NUMBER,
x_sec_alternate_month_6 IN NUMBER,
x_sec_alternate_month_7 IN NUMBER,
x_sec_alternate_month_8 IN NUMBER,
x_sec_alternate_month_10 IN NUMBER,
x_sec_alternate_month_11 IN NUMBER,
x_sec_alternate_month_12 IN NUMBER,
x_total_income IN NUMBER,
x_allow_total_income IN NUMBER,
x_state_tax_allow IN NUMBER,
x_employment_allow IN NUMBER,
x_income_protection_allow IN NUMBER,
x_available_income IN NUMBER,
x_contribution_from_ai IN NUMBER,
x_discretionary_networth IN NUMBER,
x_efc_networth IN NUMBER,
x_asset_protect_allow IN NUMBER,
x_parents_cont_from_assets IN NUMBER,
x_adjusted_available_income IN NUMBER,
x_total_student_contribution IN NUMBER,
x_total_parent_contribution IN NUMBER,
x_parents_contribution IN NUMBER,
x_student_total_income IN NUMBER,
x_sati IN NUMBER,
x_sic IN NUMBER,
x_sdnw IN NUMBER,
x_sca IN NUMBER,
x_fti IN NUMBER,
x_secti IN NUMBER,
x_secati IN NUMBER,
x_secstx IN NUMBER,
x_secea IN NUMBER,
x_secipa IN NUMBER,
x_secai IN NUMBER,
x_seccai IN NUMBER,
x_secdnw IN NUMBER,
x_secnw IN NUMBER,
x_secapa IN NUMBER,
x_secpca IN NUMBER,
x_secaai IN NUMBER,
x_sectsc IN NUMBER,
x_sectpc IN NUMBER,
x_secpc IN NUMBER,
x_secsti IN NUMBER,
x_secsic IN NUMBER,
x_secsati IN NUMBER,
x_secsdnw IN NUMBER,
x_secsca IN NUMBER,
x_secfti IN NUMBER,
x_a_citizenship IN VARCHAR2,
x_a_student_marital_status IN VARCHAR2,
x_a_student_agi IN NUMBER,
x_a_s_us_tax_paid IN NUMBER,
x_a_s_income_work IN NUMBER,
x_a_spouse_income_work IN NUMBER,
x_a_s_total_wsc IN NUMBER,
x_a_date_of_birth IN VARCHAR2,
x_a_student_married IN VARCHAR2,
x_a_have_children IN VARCHAR2,
x_a_s_have_dependents IN VARCHAR2,
x_a_va_status IN VARCHAR2,
x_a_s_num_in_family IN NUMBER,
x_a_s_num_in_college IN NUMBER,
x_a_p_marital_status IN VARCHAR2,
x_a_father_ssn IN VARCHAR2,
x_a_mother_ssn IN VARCHAR2,
x_a_parents_num_family IN NUMBER,
x_a_parents_num_college IN NUMBER,
x_a_parents_agi IN NUMBER,
x_a_p_us_tax_paid IN NUMBER,
x_a_f_work_income IN NUMBER,
x_a_m_work_income IN NUMBER,
x_a_p_total_wsc IN NUMBER,
x_comment_codes IN VARCHAR2,
x_sar_ack_comm_code IN VARCHAR2,
x_pell_grant_elig_flag IN VARCHAR2,
x_reprocess_reason_code IN VARCHAR2,
x_duplicate_date IN DATE,
x_isir_transaction_type IN VARCHAR2,
x_fedral_schl_code_indicator IN VARCHAR2,
x_multi_school_code_flags IN VARCHAR2,
x_dup_ssn_indicator IN VARCHAR2,
x_payment_isir IN VARCHAR2,
x_receipt_status IN VARCHAR2,
x_isir_receipt_completed IN VARCHAR2,
x_mode IN VARCHAR2,
x_system_record_type IN VARCHAR2,
x_verif_track_flag IN VARCHAR2,
x_active_isir IN VARCHAR2,
x_fafsa_data_verify_flags IN VARCHAR2,
x_reject_override_a IN VARCHAR2,
x_reject_override_c IN VARCHAR2,
x_parent_marital_status_date IN DATE,
x_legacy_record_flag IN VARCHAR2,
x_father_first_name_initial IN VARCHAR2,
x_father_step_father_birth_dt IN DATE ,
x_mother_first_name_initial IN VARCHAR2,
x_mother_step_mother_birth_dt IN DATE ,
x_parents_email_address_txt IN VARCHAR2,
x_address_change_type IN VARCHAR2,
x_cps_pushed_isir_flag IN VARCHAR2,
x_electronic_transaction_type IN VARCHAR2,
x_sar_c_change_type IN VARCHAR2,
x_father_ssn_match_type IN VARCHAR2,
x_mother_ssn_match_type IN VARCHAR2,
x_reject_override_g_flag IN VARCHAR2,
x_dhs_verification_num_txt IN VARCHAR2,
x_data_file_name_txt IN VARCHAR2,
x_message_class_txt IN VARCHAR2,
x_reject_override_3_flag IN VARCHAR2,
x_reject_override_12_flag IN VARCHAR2,
x_reject_override_j_flag IN VARCHAR2,
x_reject_override_k_flag IN VARCHAR2,
x_rejected_status_change_flag IN VARCHAR2,
x_verification_selection_flag IN VARCHAR2
) AS
/*
|| Created By : rasingh
|| Created On : 06-DEC-2000
|| Purpose : Handles the INSERT DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
CURSOR c IS
SELECT rowid
FROM igf_ap_isir_matched_all
WHERE isir_id = x_isir_id;
x_last_update_date DATE;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
x_program_update_date DATE;
SELECT igf_ap_isir_matched_s.nextval INTO x_isir_id
FROM dual;
x_last_update_date := SYSDATE;
x_last_updated_by := 1;
x_last_update_login := 0;
x_last_updated_by := fnd_global.user_id;
IF (x_last_updated_by IS NULL) THEN
x_last_updated_by := -1;
x_last_update_login := fnd_global.login_id;
IF (x_last_update_login IS NULL) THEN
x_last_update_login := -1;
x_program_update_date := NULL;
x_program_update_date := SYSDATE;
p_action => 'INSERT',
x_rowid => x_rowid,
x_isir_id => x_isir_id,
x_base_id => x_base_id,
x_batch_year => x_batch_year,
x_transaction_num => x_transaction_num,
x_current_ssn => x_current_ssn,
x_ssn_name_change => x_ssn_name_change,
x_original_ssn => x_original_ssn,
x_orig_name_id => x_orig_name_id,
x_last_name => x_last_name,
x_first_name => x_first_name,
x_middle_initial => x_middle_initial,
x_perm_mail_add => x_perm_mail_add,
x_perm_city => x_perm_city,
x_perm_state => x_perm_state,
x_perm_zip_code => x_perm_zip_code,
x_date_of_birth => x_date_of_birth,
x_phone_number => x_phone_number,
x_driver_license_number => x_driver_license_number,
x_driver_license_state => x_driver_license_state,
x_citizenship_status => x_citizenship_status,
x_alien_reg_number => x_alien_reg_number,
x_s_marital_status => x_s_marital_status,
x_s_marital_status_date => x_s_marital_status_date,
x_summ_enrl_status => x_summ_enrl_status,
x_fall_enrl_status => x_fall_enrl_status,
x_winter_enrl_status => x_winter_enrl_status,
x_spring_enrl_status => x_spring_enrl_status,
x_summ2_enrl_status => x_summ2_enrl_status,
x_fathers_highest_edu_level => x_fathers_highest_edu_level,
x_mothers_highest_edu_level => x_mothers_highest_edu_level,
x_s_state_legal_residence => x_s_state_legal_residence,
x_legal_residence_before_date => x_legal_residence_before_date,
x_s_legal_resd_date => x_s_legal_resd_date,
x_ss_r_u_male => x_ss_r_u_male,
x_selective_service_reg => x_selective_service_reg,
x_degree_certification => x_degree_certification,
x_grade_level_in_college => x_grade_level_in_college,
x_high_school_diploma_ged => x_high_school_diploma_ged,
x_first_bachelor_deg_by_date => x_first_bachelor_deg_by_date,
x_interest_in_loan => x_interest_in_loan,
x_interest_in_stud_employment => x_interest_in_stud_employment,
x_drug_offence_conviction => x_drug_offence_conviction,
x_s_tax_return_status => x_s_tax_return_status,
x_s_type_tax_return => x_s_type_tax_return,
x_s_elig_1040ez => x_s_elig_1040ez,
x_s_adjusted_gross_income => x_s_adjusted_gross_income,
x_s_fed_taxes_paid => x_s_fed_taxes_paid,
x_s_exemptions => x_s_exemptions,
x_s_income_from_work => x_s_income_from_work,
x_spouse_income_from_work => x_spouse_income_from_work,
x_s_toa_amt_from_wsa => x_s_toa_amt_from_wsa,
x_s_toa_amt_from_wsb => x_s_toa_amt_from_wsb,
x_s_toa_amt_from_wsc => x_s_toa_amt_from_wsc,
x_s_investment_networth => x_s_investment_networth,
x_s_busi_farm_networth => x_s_busi_farm_networth,
x_s_cash_savings => x_s_cash_savings,
x_va_months => x_va_months,
x_va_amount => x_va_amount,
x_stud_dob_before_date => x_stud_dob_before_date,
x_deg_beyond_bachelor => x_deg_beyond_bachelor,
x_s_married => x_s_married,
x_s_have_children => x_s_have_children,
x_legal_dependents => x_legal_dependents,
x_orphan_ward_of_court => x_orphan_ward_of_court,
x_s_veteran => x_s_veteran,
x_p_marital_status => x_p_marital_status,
x_father_ssn => x_father_ssn,
x_f_last_name => x_f_last_name,
x_mother_ssn => x_mother_ssn,
x_m_last_name => x_m_last_name,
x_p_num_family_member => x_p_num_family_member,
x_p_num_in_college => x_p_num_in_college,
x_p_state_legal_residence => x_p_state_legal_residence,
x_p_state_legal_res_before_dt => x_p_state_legal_res_before_dt,
x_p_legal_res_date => x_p_legal_res_date,
x_age_older_parent => x_age_older_parent,
x_p_tax_return_status => x_p_tax_return_status,
x_p_type_tax_return => x_p_type_tax_return,
x_p_elig_1040aez => x_p_elig_1040aez,
x_p_adjusted_gross_income => x_p_adjusted_gross_income,
x_p_taxes_paid => x_p_taxes_paid,
x_p_exemptions => x_p_exemptions,
x_f_income_work => x_f_income_work,
x_m_income_work => x_m_income_work,
x_p_income_wsa => x_p_income_wsa,
x_p_income_wsb => x_p_income_wsb,
x_p_income_wsc => x_p_income_wsc,
x_p_investment_networth => x_p_investment_networth,
x_p_business_networth => x_p_business_networth,
x_p_cash_saving => x_p_cash_saving,
x_s_num_family_members => x_s_num_family_members,
x_s_num_in_college => x_s_num_in_college,
x_first_college => x_first_college,
x_first_house_plan => x_first_house_plan,
x_second_college => x_second_college,
x_second_house_plan => x_second_house_plan,
x_third_college => x_third_college,
x_third_house_plan => x_third_house_plan,
x_fourth_college => x_fourth_college,
x_fourth_house_plan => x_fourth_house_plan,
x_fifth_college => x_fifth_college,
x_fifth_house_plan => x_fifth_house_plan,
x_sixth_college => x_sixth_college,
x_sixth_house_plan => x_sixth_house_plan,
x_date_app_completed => x_date_app_completed,
x_signed_by => x_signed_by,
x_preparer_ssn => x_preparer_ssn,
x_preparer_emp_id_number => x_preparer_emp_id_number,
x_preparer_sign => x_preparer_sign,
x_transaction_receipt_date => x_transaction_receipt_date,
x_dependency_override_ind => x_dependency_override_ind,
x_faa_fedral_schl_code => x_faa_fedral_schl_code,
x_faa_adjustment => x_faa_adjustment,
x_input_record_type => x_input_record_type,
x_serial_number => x_serial_number,
x_batch_number => x_batch_number,
x_early_analysis_flag => x_early_analysis_flag,
x_app_entry_source_code => x_app_entry_source_code,
x_eti_destination_code => x_eti_destination_code,
x_reject_override_b => x_reject_override_b,
x_reject_override_n => x_reject_override_n,
x_reject_override_w => x_reject_override_w,
x_assum_override_1 => x_assum_override_1,
x_assum_override_2 => x_assum_override_2,
x_assum_override_3 => x_assum_override_3,
x_assum_override_4 => x_assum_override_4,
x_assum_override_5 => x_assum_override_5,
x_assum_override_6 => x_assum_override_6,
x_dependency_status => x_dependency_status,
x_s_email_address => x_s_email_address,
x_nslds_reason_code => x_nslds_reason_code,
x_app_receipt_date => x_app_receipt_date,
x_processed_rec_type => x_processed_rec_type,
x_hist_correction_for_tran_id => x_hist_correction_for_tran_id,
x_system_generated_indicator => x_system_generated_indicator,
x_dup_request_indicator => x_dup_request_indicator,
x_source_of_correction => x_source_of_correction,
x_p_cal_tax_status => x_p_cal_tax_status,
x_s_cal_tax_status => x_s_cal_tax_status,
x_graduate_flag => x_graduate_flag,
x_auto_zero_efc => x_auto_zero_efc,
x_efc_change_flag => x_efc_change_flag,
x_sarc_flag => x_sarc_flag,
x_simplified_need_test => x_simplified_need_test,
x_reject_reason_codes => x_reject_reason_codes,
x_select_service_match_flag => x_select_service_match_flag,
x_select_service_reg_flag => x_select_service_reg_flag,
x_ins_match_flag => x_ins_match_flag,
x_ins_verification_number => x_ins_verification_number,
x_sec_ins_match_flag => x_sec_ins_match_flag,
x_sec_ins_ver_number => x_sec_ins_ver_number,
x_ssn_match_flag => x_ssn_match_flag,
x_ssa_citizenship_flag => x_ssa_citizenship_flag,
x_ssn_date_of_death => x_ssn_date_of_death,
x_nslds_match_flag => x_nslds_match_flag,
x_va_match_flag => x_va_match_flag,
x_prisoner_match => x_prisoner_match,
x_verification_flag => x_verification_flag,
x_subsequent_app_flag => x_subsequent_app_flag,
x_app_source_site_code => x_app_source_site_code,
x_tran_source_site_code => x_tran_source_site_code,
x_drn => x_drn,
x_tran_process_date => x_tran_process_date,
x_computer_batch_number => x_computer_batch_number,
x_correction_flags => x_correction_flags,
x_highlight_flags => x_highlight_flags,
x_paid_efc => x_paid_efc,
x_primary_efc => x_primary_efc,
x_secondary_efc => x_secondary_efc,
x_fed_pell_grant_efc_type => x_fed_pell_grant_efc_type,
x_primary_efc_type => x_primary_efc_type,
x_sec_efc_type => x_sec_efc_type,
x_primary_alternate_month_1 => x_primary_alternate_month_1,
x_primary_alternate_month_2 => x_primary_alternate_month_2,
x_primary_alternate_month_3 => x_primary_alternate_month_3,
x_primary_alternate_month_4 => x_primary_alternate_month_4,
x_primary_alternate_month_5 => x_primary_alternate_month_5,
x_primary_alternate_month_6 => x_primary_alternate_month_6,
x_primary_alternate_month_7 => x_primary_alternate_month_7,
x_primary_alternate_month_8 => x_primary_alternate_month_8,
x_primary_alternate_month_10 => x_primary_alternate_month_10,
x_primary_alternate_month_11 => x_primary_alternate_month_11,
x_primary_alternate_month_12 => x_primary_alternate_month_12,
x_sec_alternate_month_1 => x_sec_alternate_month_1,
x_sec_alternate_month_2 => x_sec_alternate_month_2,
x_sec_alternate_month_3 => x_sec_alternate_month_3,
x_sec_alternate_month_4 => x_sec_alternate_month_4,
x_sec_alternate_month_5 => x_sec_alternate_month_5,
x_sec_alternate_month_6 => x_sec_alternate_month_6,
x_sec_alternate_month_7 => x_sec_alternate_month_7,
x_sec_alternate_month_8 => x_sec_alternate_month_8,
x_sec_alternate_month_10 => x_sec_alternate_month_10,
x_sec_alternate_month_11 => x_sec_alternate_month_11,
x_sec_alternate_month_12 => x_sec_alternate_month_12,
x_total_income => x_total_income,
x_allow_total_income => x_allow_total_income,
x_state_tax_allow => x_state_tax_allow,
x_employment_allow => x_employment_allow,
x_income_protection_allow => x_income_protection_allow,
x_available_income => x_available_income,
x_contribution_from_ai => x_contribution_from_ai,
x_discretionary_networth => x_discretionary_networth,
x_efc_networth => x_efc_networth,
x_asset_protect_allow => x_asset_protect_allow,
x_parents_cont_from_assets => x_parents_cont_from_assets,
x_adjusted_available_income => x_adjusted_available_income,
x_total_student_contribution => x_total_student_contribution,
x_total_parent_contribution => x_total_parent_contribution,
x_parents_contribution => x_parents_contribution,
x_student_total_income => x_student_total_income,
x_sati => x_sati,
x_sic => x_sic,
x_sdnw => x_sdnw,
x_sca => x_sca,
x_fti => x_fti,
x_secti => x_secti,
x_secati => x_secati,
x_secstx => x_secstx,
x_secea => x_secea,
x_secipa => x_secipa,
x_secai => x_secai,
x_seccai => x_seccai,
x_secdnw => x_secdnw,
x_secnw => x_secnw,
x_secapa => x_secapa,
x_secpca => x_secpca,
x_secaai => x_secaai,
x_sectsc => x_sectsc,
x_sectpc => x_sectpc,
x_secpc => x_secpc,
x_secsti => x_secsti,
x_secsic => x_secsic,
x_secsati => x_secsati,
x_secsdnw => x_secsdnw,
x_secsca => x_secsca,
x_secfti => x_secfti,
x_a_citizenship => x_a_citizenship,
x_a_student_marital_status => x_a_student_marital_status,
x_a_student_agi => x_a_student_agi,
x_a_s_us_tax_paid => x_a_s_us_tax_paid,
x_a_s_income_work => x_a_s_income_work,
x_a_spouse_income_work => x_a_spouse_income_work,
x_a_s_total_wsc => x_a_s_total_wsc,
x_a_date_of_birth => x_a_date_of_birth,
x_a_student_married => x_a_student_married,
x_a_have_children => x_a_have_children,
x_a_s_have_dependents => x_a_s_have_dependents,
x_a_va_status => x_a_va_status,
x_a_s_num_in_family => x_a_s_num_in_family,
x_a_s_num_in_college => x_a_s_num_in_college,
x_a_p_marital_status => x_a_p_marital_status,
x_a_father_ssn => x_a_father_ssn,
x_a_mother_ssn => x_a_mother_ssn,
x_a_parents_num_family => x_a_parents_num_family,
x_a_parents_num_college => x_a_parents_num_college,
x_a_parents_agi => x_a_parents_agi,
x_a_p_us_tax_paid => x_a_p_us_tax_paid,
x_a_f_work_income => x_a_f_work_income,
x_a_m_work_income => x_a_m_work_income,
x_a_p_total_wsc => x_a_p_total_wsc,
x_comment_codes => x_comment_codes,
x_sar_ack_comm_code => x_sar_ack_comm_code,
x_pell_grant_elig_flag => x_pell_grant_elig_flag,
x_reprocess_reason_code => x_reprocess_reason_code,
x_duplicate_date => x_duplicate_date,
x_isir_transaction_type => x_isir_transaction_type,
x_fedral_schl_code_indicator => x_fedral_schl_code_indicator,
x_multi_school_code_flags => x_multi_school_code_flags,
x_dup_ssn_indicator => x_dup_ssn_indicator,
x_payment_isir => x_payment_isir,
x_receipt_status => x_receipt_status,
x_isir_receipt_completed => x_isir_receipt_completed,
x_creation_date => x_last_update_date,
x_created_by => x_last_updated_by,
x_last_update_date => x_last_update_date,
x_last_updated_by => x_last_updated_by,
x_last_update_login => x_last_update_login,
x_system_record_type => x_system_record_type,
x_verif_track_flag => x_verif_track_flag,
x_active_isir => x_active_isir,
x_fafsa_data_verify_flags => x_fafsa_data_verify_flags,
x_reject_override_a => x_reject_override_a,
x_reject_override_c => x_reject_override_c,
x_parent_marital_status_date => x_parent_marital_status_date ,
x_legacy_record_flag =>x_legacy_record_flag,
x_father_first_name_initial => x_father_first_name_initial,
x_father_step_father_birth_dt => x_father_step_father_birth_dt,
x_mother_first_name_initial => x_mother_first_name_initial,
x_mother_step_mother_birth_dt => x_mother_step_mother_birth_dt,
x_parents_email_address_txt => x_parents_email_address_txt,
x_address_change_type => x_address_change_type,
x_cps_pushed_isir_flag => x_cps_pushed_isir_flag,
x_electronic_transaction_type =>x_electronic_transaction_type,
x_sar_c_change_type => x_sar_c_change_type,
x_father_ssn_match_type => x_father_ssn_match_type,
x_mother_ssn_match_type => x_mother_ssn_match_type,
x_reject_override_g_flag => x_reject_override_g_flag,
x_dhs_verification_num_txt => x_dhs_verification_num_txt,
x_data_file_name_txt => x_data_file_name_txt ,
x_message_class_txt => x_message_class_txt,
x_reject_override_3_flag => x_reject_override_3_flag,
x_reject_override_12_flag => x_reject_override_12_flag,
x_reject_override_j_flag => x_reject_override_j_flag,
x_reject_override_k_flag => x_reject_override_k_flag,
x_rejected_status_change_flag => x_rejected_status_change_flag,
x_verification_selection_flag => x_verification_selection_flag
);
INSERT INTO igf_ap_isir_matched_all (
isir_id,
base_id,
batch_year,
transaction_num,
current_ssn,
ssn_name_change,
original_ssn,
orig_name_id,
last_name,
first_name,
middle_initial,
perm_mail_add,
perm_city,
perm_state,
perm_zip_code,
date_of_birth,
phone_number,
driver_license_number,
driver_license_state,
citizenship_status,
alien_reg_number,
s_marital_status,
s_marital_status_date,
summ_enrl_status,
fall_enrl_status,
winter_enrl_status,
spring_enrl_status,
summ2_enrl_status,
fathers_highest_edu_level,
mothers_highest_edu_level,
s_state_legal_residence,
legal_residence_before_date,
s_legal_resd_date,
ss_r_u_male,
selective_service_reg,
degree_certification,
grade_level_in_college,
high_school_diploma_ged,
first_bachelor_deg_by_date,
interest_in_loan,
interest_in_stud_employment,
drug_offence_conviction,
s_tax_return_status,
s_type_tax_return,
s_elig_1040ez,
s_adjusted_gross_income,
s_fed_taxes_paid,
s_exemptions,
s_income_from_work,
spouse_income_from_work,
s_toa_amt_from_wsa,
s_toa_amt_from_wsb,
s_toa_amt_from_wsc,
s_investment_networth,
s_busi_farm_networth,
s_cash_savings,
va_months,
va_amount,
stud_dob_before_date,
deg_beyond_bachelor,
s_married,
s_have_children,
legal_dependents,
orphan_ward_of_court,
s_veteran,
p_marital_status,
father_ssn,
f_last_name,
mother_ssn,
m_last_name,
p_num_family_member,
p_num_in_college,
p_state_legal_residence,
p_state_legal_res_before_dt,
p_legal_res_date,
age_older_parent,
p_tax_return_status,
p_type_tax_return,
p_elig_1040aez,
p_adjusted_gross_income,
p_taxes_paid,
p_exemptions,
f_income_work,
m_income_work,
p_income_wsa,
p_income_wsb,
p_income_wsc,
p_investment_networth,
p_business_networth,
p_cash_saving,
s_num_family_members,
s_num_in_college,
first_college,
first_house_plan,
second_college,
second_house_plan,
third_college,
third_house_plan,
fourth_college,
fourth_house_plan,
fifth_college,
fifth_house_plan,
sixth_college,
sixth_house_plan,
date_app_completed,
signed_by,
preparer_ssn,
preparer_emp_id_number,
preparer_sign,
transaction_receipt_date,
dependency_override_ind,
faa_fedral_schl_code,
faa_adjustment,
input_record_type,
serial_number,
batch_number,
early_analysis_flag,
app_entry_source_code,
eti_destination_code,
reject_override_b,
reject_override_n,
reject_override_w,
assum_override_1,
assum_override_2,
assum_override_3,
assum_override_4,
assum_override_5,
assum_override_6,
dependency_status,
s_email_address,
nslds_reason_code,
app_receipt_date,
processed_rec_type,
hist_correction_for_tran_id,
system_generated_indicator,
dup_request_indicator,
source_of_correction,
p_cal_tax_status,
s_cal_tax_status,
graduate_flag,
auto_zero_efc,
efc_change_flag,
sarc_flag,
simplified_need_test,
reject_reason_codes,
select_service_match_flag,
select_service_reg_flag,
ins_match_flag,
ins_verification_number,
sec_ins_match_flag,
sec_ins_ver_number,
ssn_match_flag,
ssa_citizenship_flag,
ssn_date_of_death,
nslds_match_flag,
va_match_flag,
prisoner_match,
verification_flag,
subsequent_app_flag,
app_source_site_code,
tran_source_site_code,
drn,
tran_process_date,
computer_batch_number,
correction_flags,
highlight_flags,
paid_efc,
primary_efc,
secondary_efc,
fed_pell_grant_efc_type,
primary_efc_type,
sec_efc_type,
primary_alternate_month_1,
primary_alternate_month_2,
primary_alternate_month_3,
primary_alternate_month_4,
primary_alternate_month_5,
primary_alternate_month_6,
primary_alternate_month_7,
primary_alternate_month_8,
primary_alternate_month_10,
primary_alternate_month_11,
primary_alternate_month_12,
sec_alternate_month_1,
sec_alternate_month_2,
sec_alternate_month_3,
sec_alternate_month_4,
sec_alternate_month_5,
sec_alternate_month_6,
sec_alternate_month_7,
sec_alternate_month_8,
sec_alternate_month_10,
sec_alternate_month_11,
sec_alternate_month_12,
total_income,
allow_total_income,
state_tax_allow,
employment_allow,
income_protection_allow,
available_income,
contribution_from_ai,
discretionary_networth,
efc_networth,
asset_protect_allow,
parents_cont_from_assets,
adjusted_available_income,
total_student_contribution,
total_parent_contribution,
parents_contribution,
student_total_income,
sati,
sic,
sdnw,
sca,
fti,
secti,
secati,
secstx,
secea,
secipa,
secai,
seccai,
secdnw,
secnw,
secapa,
secpca,
secaai,
sectsc,
sectpc,
secpc,
secsti,
secsic,
secsati,
secsdnw,
secsca,
secfti,
a_citizenship,
a_student_marital_status,
a_student_agi,
a_s_us_tax_paid,
a_s_income_work,
a_spouse_income_work,
a_s_total_wsc,
a_date_of_birth,
a_student_married,
a_have_children,
a_s_have_dependents,
a_va_status,
a_s_num_in_family,
a_s_num_in_college,
a_p_marital_status,
a_father_ssn,
a_mother_ssn,
a_parents_num_family,
a_parents_num_college,
a_parents_agi,
a_p_us_tax_paid,
a_f_work_income,
a_m_work_income,
a_p_total_wsc,
comment_codes,
sar_ack_comm_code,
pell_grant_elig_flag,
reprocess_reason_code,
duplicate_date,
isir_transaction_type,
fedral_schl_code_indicator,
multi_school_code_flags,
dup_ssn_indicator,
payment_isir,
receipt_status,
isir_receipt_completed,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
request_id,
program_id,
program_application_id,
program_update_date,
org_id,
system_record_type,
verif_track_flag,
active_isir,
fafsa_data_verify_flags,
reject_override_a,
reject_override_c,
parent_marital_status_date,
legacy_record_flag,
father_first_name_initial_txt,
father_step_father_birth_date,
mother_first_name_initial_txt,
mother_step_mother_birth_date,
parents_email_address_txt,
address_change_type,
cps_pushed_isir_flag,
electronic_transaction_type,
sar_c_change_type,
father_ssn_match_type ,
mother_ssn_match_type ,
reject_override_g_flag,
dhs_verification_num_txt,
data_file_name_txt,
message_class_txt,
reject_override_3_flag,
reject_override_12_flag,
reject_override_j_flag,
reject_override_k_flag ,
rejected_status_change_flag,
verification_selection_flag
) VALUES (
new_references.isir_id,
new_references.base_id,
new_references.batch_year,
new_references.transaction_num,
new_references.current_ssn,
new_references.ssn_name_change,
new_references.original_ssn,
new_references.orig_name_id,
new_references.last_name,
new_references.first_name,
new_references.middle_initial,
new_references.perm_mail_add,
new_references.perm_city,
new_references.perm_state,
new_references.perm_zip_code,
new_references.date_of_birth,
new_references.phone_number,
new_references.driver_license_number,
new_references.driver_license_state,
new_references.citizenship_status,
new_references.alien_reg_number,
new_references.s_marital_status,
new_references.s_marital_status_date,
new_references.summ_enrl_status,
new_references.fall_enrl_status,
new_references.winter_enrl_status,
new_references.spring_enrl_status,
new_references.summ2_enrl_status,
new_references.fathers_highest_edu_level,
new_references.mothers_highest_edu_level,
new_references.s_state_legal_residence,
new_references.legal_residence_before_date,
new_references.s_legal_resd_date,
new_references.ss_r_u_male,
new_references.selective_service_reg,
new_references.degree_certification,
new_references.grade_level_in_college,
new_references.high_school_diploma_ged,
new_references.first_bachelor_deg_by_date,
new_references.interest_in_loan,
new_references.interest_in_stud_employment,
new_references.drug_offence_conviction,
new_references.s_tax_return_status,
new_references.s_type_tax_return,
new_references.s_elig_1040ez,
new_references.s_adjusted_gross_income,
new_references.s_fed_taxes_paid,
new_references.s_exemptions,
new_references.s_income_from_work,
new_references.spouse_income_from_work,
new_references.s_toa_amt_from_wsa,
new_references.s_toa_amt_from_wsb,
new_references.s_toa_amt_from_wsc,
new_references.s_investment_networth,
new_references.s_busi_farm_networth,
new_references.s_cash_savings,
new_references.va_months,
new_references.va_amount,
new_references.stud_dob_before_date,
new_references.deg_beyond_bachelor,
new_references.s_married,
new_references.s_have_children,
new_references.legal_dependents,
new_references.orphan_ward_of_court,
new_references.s_veteran,
new_references.p_marital_status,
new_references.father_ssn,
new_references.f_last_name,
new_references.mother_ssn,
new_references.m_last_name,
new_references.p_num_family_member,
new_references.p_num_in_college,
new_references.p_state_legal_residence,
new_references.p_state_legal_res_before_dt,
new_references.p_legal_res_date,
new_references.age_older_parent,
new_references.p_tax_return_status,
new_references.p_type_tax_return,
new_references.p_elig_1040aez,
new_references.p_adjusted_gross_income,
new_references.p_taxes_paid,
new_references.p_exemptions,
new_references.f_income_work,
new_references.m_income_work,
new_references.p_income_wsa,
new_references.p_income_wsb,
new_references.p_income_wsc,
new_references.p_investment_networth,
new_references.p_business_networth,
new_references.p_cash_saving,
new_references.s_num_family_members,
new_references.s_num_in_college,
new_references.first_college,
new_references.first_house_plan,
new_references.second_college,
new_references.second_house_plan,
new_references.third_college,
new_references.third_house_plan,
new_references.fourth_college,
new_references.fourth_house_plan,
new_references.fifth_college,
new_references.fifth_house_plan,
new_references.sixth_college,
new_references.sixth_house_plan,
new_references.date_app_completed,
new_references.signed_by,
new_references.preparer_ssn,
new_references.preparer_emp_id_number,
new_references.preparer_sign,
new_references.transaction_receipt_date,
new_references.dependency_override_ind,
new_references.faa_fedral_schl_code,
new_references.faa_adjustment,
new_references.input_record_type,
new_references.serial_number,
new_references.batch_number,
new_references.early_analysis_flag,
new_references.app_entry_source_code,
new_references.eti_destination_code,
new_references.reject_override_b,
new_references.reject_override_n,
new_references.reject_override_w,
new_references.assum_override_1,
new_references.assum_override_2,
new_references.assum_override_3,
new_references.assum_override_4,
new_references.assum_override_5,
new_references.assum_override_6,
new_references.dependency_status,
new_references.s_email_address,
new_references.nslds_reason_code,
new_references.app_receipt_date,
new_references.processed_rec_type,
new_references.hist_correction_for_tran_id,
new_references.system_generated_indicator,
new_references.dup_request_indicator,
new_references.source_of_correction,
new_references.p_cal_tax_status,
new_references.s_cal_tax_status,
new_references.graduate_flag,
new_references.auto_zero_efc,
new_references.efc_change_flag,
new_references.sarc_flag,
new_references.simplified_need_test,
new_references.reject_reason_codes,
new_references.select_service_match_flag,
new_references.select_service_reg_flag,
new_references.ins_match_flag,
NULL,
new_references.sec_ins_match_flag,
new_references.sec_ins_ver_number,
new_references.ssn_match_flag,
new_references.ssa_citizenship_flag,
new_references.ssn_date_of_death,
new_references.nslds_match_flag,
new_references.va_match_flag,
new_references.prisoner_match,
new_references.verification_flag,
new_references.subsequent_app_flag,
new_references.app_source_site_code,
new_references.tran_source_site_code,
new_references.drn,
new_references.tran_process_date,
new_references.computer_batch_number,
new_references.correction_flags,
new_references.highlight_flags,
new_references.paid_efc,
new_references.primary_efc,
new_references.secondary_efc,
new_references.fed_pell_grant_efc_type,
new_references.primary_efc_type,
new_references.sec_efc_type,
new_references.primary_alternate_month_1,
new_references.primary_alternate_month_2,
new_references.primary_alternate_month_3,
new_references.primary_alternate_month_4,
new_references.primary_alternate_month_5,
new_references.primary_alternate_month_6,
new_references.primary_alternate_month_7,
new_references.primary_alternate_month_8,
new_references.primary_alternate_month_10,
new_references.primary_alternate_month_11,
new_references.primary_alternate_month_12,
new_references.sec_alternate_month_1,
new_references.sec_alternate_month_2,
new_references.sec_alternate_month_3,
new_references.sec_alternate_month_4,
new_references.sec_alternate_month_5,
new_references.sec_alternate_month_6,
new_references.sec_alternate_month_7,
new_references.sec_alternate_month_8,
new_references.sec_alternate_month_10,
new_references.sec_alternate_month_11,
new_references.sec_alternate_month_12,
new_references.total_income,
new_references.allow_total_income,
new_references.state_tax_allow,
new_references.employment_allow,
new_references.income_protection_allow,
new_references.available_income,
new_references.contribution_from_ai,
new_references.discretionary_networth,
new_references.efc_networth,
new_references.asset_protect_allow,
new_references.parents_cont_from_assets,
new_references.adjusted_available_income,
new_references.total_student_contribution,
new_references.total_parent_contribution,
new_references.parents_contribution,
new_references.student_total_income,
new_references.sati,
new_references.sic,
new_references.sdnw,
new_references.sca,
new_references.fti,
new_references.secti,
new_references.secati,
new_references.secstx,
new_references.secea,
new_references.secipa,
new_references.secai,
new_references.seccai,
new_references.secdnw,
new_references.secnw,
new_references.secapa,
new_references.secpca,
new_references.secaai,
new_references.sectsc,
new_references.sectpc,
new_references.secpc,
new_references.secsti,
new_references.secsic,
new_references.secsati,
new_references.secsdnw,
new_references.secsca,
new_references.secfti,
new_references.a_citizenship,
new_references.a_student_marital_status,
new_references.a_student_agi,
new_references.a_s_us_tax_paid,
new_references.a_s_income_work,
new_references.a_spouse_income_work,
new_references.a_s_total_wsc,
new_references.a_date_of_birth,
new_references.a_student_married,
new_references.a_have_children,
new_references.a_s_have_dependents,
new_references.a_va_status,
new_references.a_s_num_in_family,
new_references.a_s_num_in_college,
new_references.a_p_marital_status,
new_references.a_father_ssn,
new_references.a_mother_ssn,
new_references.a_parents_num_family,
new_references.a_parents_num_college,
new_references.a_parents_agi,
new_references.a_p_us_tax_paid,
new_references.a_f_work_income,
new_references.a_m_work_income,
new_references.a_p_total_wsc,
new_references.comment_codes,
new_references.sar_ack_comm_code,
new_references.pell_grant_elig_flag,
new_references.reprocess_reason_code,
new_references.duplicate_date,
new_references.isir_transaction_type,
new_references.fedral_schl_code_indicator,
new_references.multi_school_code_flags,
new_references.dup_ssn_indicator,
new_references.payment_isir,
new_references.receipt_status,
new_references.isir_receipt_completed,
x_last_update_date,
x_last_updated_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login ,
x_request_id,
x_program_id,
x_program_application_id,
x_program_update_date ,
l_org_id,
new_references.system_record_type,
new_references.verif_track_flag,
new_references.active_isir,
new_references.fafsa_data_verify_flags,
new_references.reject_override_a,
new_references.reject_override_c,
new_references.parent_marital_status_date,
new_references.legacy_record_flag,
new_references.father_first_name_initial_txt,
new_references.father_step_father_birth_date,
new_references.mother_first_name_initial_txt,
new_references.mother_step_mother_birth_date,
new_references.parents_email_address_txt,
new_references.address_change_type ,
new_references.cps_pushed_isir_flag,
new_references.electronic_transaction_type,
new_references.sar_c_change_type ,
new_references.father_ssn_match_type ,
new_references.mother_ssn_match_type ,
new_references.reject_override_g_flag,
new_references.dhs_verification_num_txt,
new_references.data_file_name_txt,
new_references.message_class_txt,
new_references.reject_override_3_flag,
new_references.reject_override_12_flag,
new_references.reject_override_j_flag,
new_references.reject_override_k_flag ,
new_references.rejected_status_change_flag,
new_references.verification_selection_flag
);
END insert_row;
x_selective_service_reg IN VARCHAR2,
x_degree_certification IN VARCHAR2,
x_grade_level_in_college IN VARCHAR2,
x_high_school_diploma_ged IN VARCHAR2,
x_first_bachelor_deg_by_date IN VARCHAR2,
x_interest_in_loan IN VARCHAR2,
x_interest_in_stud_employment IN VARCHAR2,
x_drug_offence_conviction IN VARCHAR2,
x_s_tax_return_status IN VARCHAR2,
x_s_type_tax_return IN VARCHAR2,
x_s_elig_1040ez IN VARCHAR2,
x_s_adjusted_gross_income IN NUMBER,
x_s_fed_taxes_paid IN NUMBER,
x_s_exemptions IN NUMBER,
x_s_income_from_work IN NUMBER,
x_spouse_income_from_work IN NUMBER,
x_s_toa_amt_from_wsa IN NUMBER,
x_s_toa_amt_from_wsb IN NUMBER,
x_s_toa_amt_from_wsc IN NUMBER,
x_s_investment_networth IN NUMBER,
x_s_busi_farm_networth IN NUMBER,
x_s_cash_savings IN NUMBER,
x_va_months IN NUMBER,
x_va_amount IN NUMBER,
x_stud_dob_before_date IN VARCHAR2,
x_deg_beyond_bachelor IN VARCHAR2,
x_s_married IN VARCHAR2,
x_s_have_children IN VARCHAR2,
x_legal_dependents IN VARCHAR2,
x_orphan_ward_of_court IN VARCHAR2,
x_s_veteran IN VARCHAR2,
x_p_marital_status IN VARCHAR2,
x_father_ssn IN VARCHAR2,
x_f_last_name IN VARCHAR2,
x_mother_ssn IN VARCHAR2,
x_m_last_name IN VARCHAR2,
x_p_num_family_member IN NUMBER,
x_p_num_in_college IN NUMBER,
x_p_state_legal_residence IN VARCHAR2,
x_p_state_legal_res_before_dt IN VARCHAR2,
x_p_legal_res_date IN DATE,
x_age_older_parent IN NUMBER,
x_p_tax_return_status IN VARCHAR2,
x_p_type_tax_return IN VARCHAR2,
x_p_elig_1040aez IN VARCHAR2,
x_p_adjusted_gross_income IN NUMBER,
x_p_taxes_paid IN NUMBER,
x_p_exemptions IN NUMBER,
x_f_income_work IN NUMBER,
x_m_income_work IN NUMBER,
x_p_income_wsa IN NUMBER,
x_p_income_wsb IN NUMBER,
x_p_income_wsc IN NUMBER,
x_p_investment_networth IN NUMBER,
x_p_business_networth IN NUMBER,
x_p_cash_saving IN NUMBER,
x_s_num_family_members IN NUMBER,
x_s_num_in_college IN NUMBER,
x_first_college IN VARCHAR2,
x_first_house_plan IN VARCHAR2,
x_second_college IN VARCHAR2,
x_second_house_plan IN VARCHAR2,
x_third_college IN VARCHAR2,
x_third_house_plan IN VARCHAR2,
x_fourth_college IN VARCHAR2,
x_fourth_house_plan IN VARCHAR2,
x_fifth_college IN VARCHAR2,
x_fifth_house_plan IN VARCHAR2,
x_sixth_college IN VARCHAR2,
x_sixth_house_plan IN VARCHAR2,
x_date_app_completed IN DATE,
x_signed_by IN VARCHAR2,
x_preparer_ssn IN VARCHAR2,
x_preparer_emp_id_number IN VARCHAR2,
x_preparer_sign IN VARCHAR2,
x_transaction_receipt_date IN DATE,
x_dependency_override_ind IN VARCHAR2,
x_faa_fedral_schl_code IN VARCHAR2,
x_faa_adjustment IN VARCHAR2,
x_input_record_type IN VARCHAR2,
x_serial_number IN NUMBER,
x_batch_number IN VARCHAR2,
x_early_analysis_flag IN VARCHAR2,
x_app_entry_source_code IN VARCHAR2,
x_eti_destination_code IN VARCHAR2,
x_reject_override_b IN VARCHAR2,
x_reject_override_n IN VARCHAR2,
x_reject_override_w IN VARCHAR2,
x_assum_override_1 IN VARCHAR2,
x_assum_override_2 IN VARCHAR2,
x_assum_override_3 IN VARCHAR2,
x_assum_override_4 IN VARCHAR2,
x_assum_override_5 IN VARCHAR2,
x_assum_override_6 IN VARCHAR2,
x_dependency_status IN VARCHAR2,
x_s_email_address IN VARCHAR2,
x_nslds_reason_code IN VARCHAR2,
x_app_receipt_date IN DATE,
x_processed_rec_type IN VARCHAR2,
x_hist_correction_for_tran_id IN NUMBER,
x_system_generated_indicator IN VARCHAR2,
x_dup_request_indicator IN VARCHAR2,
x_source_of_correction IN VARCHAR2,
x_p_cal_tax_status IN VARCHAR2,
x_s_cal_tax_status IN VARCHAR2,
x_graduate_flag IN VARCHAR2,
x_auto_zero_efc IN VARCHAR2,
x_efc_change_flag IN VARCHAR2,
x_sarc_flag IN VARCHAR2,
x_simplified_need_test IN VARCHAR2,
x_reject_reason_codes IN VARCHAR2,
x_select_service_match_flag IN VARCHAR2,
x_select_service_reg_flag IN VARCHAR2,
x_ins_match_flag IN VARCHAR2,
x_ins_verification_number IN NUMBER,
x_sec_ins_match_flag IN VARCHAR2,
x_sec_ins_ver_number IN NUMBER,
x_ssn_match_flag IN VARCHAR2,
x_ssa_citizenship_flag IN VARCHAR2,
x_ssn_date_of_death IN DATE,
x_nslds_match_flag IN VARCHAR2,
x_va_match_flag IN VARCHAR2,
x_prisoner_match IN VARCHAR2,
x_verification_flag IN VARCHAR2,
x_subsequent_app_flag IN VARCHAR2,
x_app_source_site_code IN VARCHAR2,
x_tran_source_site_code IN VARCHAR2,
x_drn IN NUMBER,
x_tran_process_date IN DATE,
x_computer_batch_number IN NUMBER,
x_correction_flags IN VARCHAR2,
x_highlight_flags IN VARCHAR2,
x_paid_efc IN NUMBER,
x_primary_efc IN NUMBER,
x_secondary_efc IN NUMBER,
x_fed_pell_grant_efc_type IN VARCHAR2,
x_primary_efc_type IN VARCHAR2,
x_sec_efc_type IN VARCHAR2,
x_primary_alternate_month_1 IN NUMBER,
x_primary_alternate_month_2 IN NUMBER,
x_primary_alternate_month_3 IN NUMBER,
x_primary_alternate_month_4 IN NUMBER,
x_primary_alternate_month_5 IN NUMBER,
x_primary_alternate_month_6 IN NUMBER,
x_primary_alternate_month_7 IN NUMBER,
x_primary_alternate_month_8 IN NUMBER,
x_primary_alternate_month_10 IN NUMBER,
x_primary_alternate_month_11 IN NUMBER,
x_primary_alternate_month_12 IN NUMBER,
x_sec_alternate_month_1 IN NUMBER,
x_sec_alternate_month_2 IN NUMBER,
x_sec_alternate_month_3 IN NUMBER,
x_sec_alternate_month_4 IN NUMBER,
x_sec_alternate_month_5 IN NUMBER,
x_sec_alternate_month_6 IN NUMBER,
x_sec_alternate_month_7 IN NUMBER,
x_sec_alternate_month_8 IN NUMBER,
x_sec_alternate_month_10 IN NUMBER,
x_sec_alternate_month_11 IN NUMBER,
x_sec_alternate_month_12 IN NUMBER,
x_total_income IN NUMBER,
x_allow_total_income IN NUMBER,
x_state_tax_allow IN NUMBER,
x_employment_allow IN NUMBER,
x_income_protection_allow IN NUMBER,
x_available_income IN NUMBER,
x_contribution_from_ai IN NUMBER,
x_discretionary_networth IN NUMBER,
x_efc_networth IN NUMBER,
x_asset_protect_allow IN NUMBER,
x_parents_cont_from_assets IN NUMBER,
x_adjusted_available_income IN NUMBER,
x_total_student_contribution IN NUMBER,
x_total_parent_contribution IN NUMBER,
x_parents_contribution IN NUMBER,
x_student_total_income IN NUMBER,
x_sati IN NUMBER,
x_sic IN NUMBER,
x_sdnw IN NUMBER,
x_sca IN NUMBER,
x_fti IN NUMBER,
x_secti IN NUMBER,
x_secati IN NUMBER,
x_secstx IN NUMBER,
x_secea IN NUMBER,
x_secipa IN NUMBER,
x_secai IN NUMBER,
x_seccai IN NUMBER,
x_secdnw IN NUMBER,
x_secnw IN NUMBER,
x_secapa IN NUMBER,
x_secpca IN NUMBER,
x_secaai IN NUMBER,
x_sectsc IN NUMBER,
x_sectpc IN NUMBER,
x_secpc IN NUMBER,
x_secsti IN NUMBER,
x_secsic IN NUMBER,
x_secsati IN NUMBER,
x_secsdnw IN NUMBER,
x_secsca IN NUMBER,
x_secfti IN NUMBER,
x_a_citizenship IN VARCHAR2,
x_a_student_marital_status IN VARCHAR2,
x_a_student_agi IN NUMBER,
x_a_s_us_tax_paid IN NUMBER,
x_a_s_income_work IN NUMBER,
x_a_spouse_income_work IN NUMBER,
x_a_s_total_wsc IN NUMBER,
x_a_date_of_birth IN VARCHAR2,
x_a_student_married IN VARCHAR2,
x_a_have_children IN VARCHAR2,
x_a_s_have_dependents IN VARCHAR2,
x_a_va_status IN VARCHAR2,
x_a_s_num_in_family IN NUMBER,
x_a_s_num_in_college IN NUMBER,
x_a_p_marital_status IN VARCHAR2,
x_a_father_ssn IN VARCHAR2,
x_a_mother_ssn IN VARCHAR2,
x_a_parents_num_family IN NUMBER,
x_a_parents_num_college IN NUMBER,
x_a_parents_agi IN NUMBER,
x_a_p_us_tax_paid IN NUMBER,
x_a_f_work_income IN NUMBER,
x_a_m_work_income IN NUMBER,
x_a_p_total_wsc IN NUMBER,
x_comment_codes IN VARCHAR2,
x_sar_ack_comm_code IN VARCHAR2,
x_pell_grant_elig_flag IN VARCHAR2,
x_reprocess_reason_code IN VARCHAR2,
x_duplicate_date IN DATE,
x_isir_transaction_type IN VARCHAR2,
x_fedral_schl_code_indicator IN VARCHAR2,
x_multi_school_code_flags IN VARCHAR2,
x_dup_ssn_indicator IN VARCHAR2,
x_payment_isir IN VARCHAR2,
x_receipt_status IN VARCHAR2,
x_isir_receipt_completed IN VARCHAR2,
x_system_record_type IN VARCHAR2,
x_verif_track_flag IN VARCHAR2,
x_active_isir IN VARCHAR2,
x_fafsa_data_verify_flags IN VARCHAR2,
x_reject_override_a IN VARCHAR2,
x_reject_override_c IN VARCHAR2,
x_parent_marital_status_date IN DATE ,
x_legacy_record_flag IN VARCHAR2,
x_father_first_name_initial IN VARCHAR2,
x_father_step_father_birth_dt IN DATE ,
x_mother_first_name_initial IN VARCHAR2,
x_mother_step_mother_birth_dt IN DATE ,
x_parents_email_address_txt IN VARCHAR2,
x_address_change_type IN VARCHAR2,
x_cps_pushed_isir_flag IN VARCHAR2,
x_electronic_transaction_type IN VARCHAR2,
x_sar_c_change_type IN VARCHAR2,
x_father_ssn_match_type IN VARCHAR2,
x_mother_ssn_match_type IN VARCHAR2,
x_reject_override_g_flag IN VARCHAR2,
x_dhs_verification_num_txt IN VARCHAR2,
x_data_file_name_txt IN VARCHAR2,
x_message_class_txt IN VARCHAR2,
x_reject_override_3_flag IN VARCHAR2,
x_reject_override_12_flag IN VARCHAR2,
x_reject_override_j_flag IN VARCHAR2,
x_reject_override_k_flag IN VARCHAR2,
x_rejected_status_change_flag IN VARCHAR2,
x_verification_selection_flag IN VARCHAR2
) AS
/*
|| Created By : rasingh
|| Created On : 06-DEC-2000
|| Purpose : Handles the LOCK mechanism for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
CURSOR c1 IS
SELECT
base_id,
batch_year,
transaction_num,
current_ssn,
ssn_name_change,
original_ssn,
orig_name_id,
last_name,
first_name,
middle_initial,
perm_mail_add,
perm_city,
perm_state,
perm_zip_code,
date_of_birth,
phone_number,
driver_license_number,
driver_license_state,
citizenship_status,
alien_reg_number,
s_marital_status,
s_marital_status_date,
summ_enrl_status,
fall_enrl_status,
winter_enrl_status,
spring_enrl_status,
summ2_enrl_status,
fathers_highest_edu_level,
mothers_highest_edu_level,
s_state_legal_residence,
legal_residence_before_date,
s_legal_resd_date,
ss_r_u_male,
selective_service_reg,
degree_certification,
grade_level_in_college,
high_school_diploma_ged,
first_bachelor_deg_by_date,
interest_in_loan,
interest_in_stud_employment,
drug_offence_conviction,
s_tax_return_status,
s_type_tax_return,
s_elig_1040ez,
s_adjusted_gross_income,
s_fed_taxes_paid,
s_exemptions,
s_income_from_work,
spouse_income_from_work,
s_toa_amt_from_wsa,
s_toa_amt_from_wsb,
s_toa_amt_from_wsc,
s_investment_networth,
s_busi_farm_networth,
s_cash_savings,
va_months,
va_amount,
stud_dob_before_date,
deg_beyond_bachelor,
s_married,
s_have_children,
legal_dependents,
orphan_ward_of_court,
s_veteran,
p_marital_status,
father_ssn,
f_last_name,
mother_ssn,
m_last_name,
p_num_family_member,
p_num_in_college,
p_state_legal_residence,
p_state_legal_res_before_dt,
p_legal_res_date,
age_older_parent,
p_tax_return_status,
p_type_tax_return,
p_elig_1040aez,
p_adjusted_gross_income,
p_taxes_paid,
p_exemptions,
f_income_work,
m_income_work,
p_income_wsa,
p_income_wsb,
p_income_wsc,
p_investment_networth,
p_business_networth,
p_cash_saving,
s_num_family_members,
s_num_in_college,
first_college,
first_house_plan,
second_college,
second_house_plan,
third_college,
third_house_plan,
fourth_college,
fourth_house_plan,
fifth_college,
fifth_house_plan,
sixth_college,
sixth_house_plan,
date_app_completed,
signed_by,
preparer_ssn,
preparer_emp_id_number,
preparer_sign,
transaction_receipt_date,
dependency_override_ind,
faa_fedral_schl_code,
faa_adjustment,
input_record_type,
serial_number,
batch_number,
early_analysis_flag,
app_entry_source_code,
eti_destination_code,
reject_override_b,
reject_override_n,
reject_override_w,
assum_override_1,
assum_override_2,
assum_override_3,
assum_override_4,
assum_override_5,
assum_override_6,
dependency_status,
s_email_address,
nslds_reason_code,
app_receipt_date,
processed_rec_type,
hist_correction_for_tran_id,
system_generated_indicator,
dup_request_indicator,
source_of_correction,
p_cal_tax_status,
s_cal_tax_status,
graduate_flag,
auto_zero_efc,
efc_change_flag,
sarc_flag,
simplified_need_test,
reject_reason_codes,
select_service_match_flag,
select_service_reg_flag,
ins_match_flag,
ins_verification_number,
sec_ins_match_flag,
sec_ins_ver_number,
ssn_match_flag,
ssa_citizenship_flag,
ssn_date_of_death,
nslds_match_flag,
va_match_flag,
prisoner_match,
verification_flag,
subsequent_app_flag,
app_source_site_code,
tran_source_site_code,
drn,
tran_process_date,
computer_batch_number,
correction_flags,
highlight_flags,
paid_efc,
primary_efc,
secondary_efc,
fed_pell_grant_efc_type,
primary_efc_type,
sec_efc_type,
primary_alternate_month_1,
primary_alternate_month_2,
primary_alternate_month_3,
primary_alternate_month_4,
primary_alternate_month_5,
primary_alternate_month_6,
primary_alternate_month_7,
primary_alternate_month_8,
primary_alternate_month_10,
primary_alternate_month_11,
primary_alternate_month_12,
sec_alternate_month_1,
sec_alternate_month_2,
sec_alternate_month_3,
sec_alternate_month_4,
sec_alternate_month_5,
sec_alternate_month_6,
sec_alternate_month_7,
sec_alternate_month_8,
sec_alternate_month_10,
sec_alternate_month_11,
sec_alternate_month_12,
total_income,
allow_total_income,
state_tax_allow,
employment_allow,
income_protection_allow,
available_income,
contribution_from_ai,
discretionary_networth,
efc_networth,
asset_protect_allow,
parents_cont_from_assets,
adjusted_available_income,
total_student_contribution,
total_parent_contribution,
parents_contribution,
student_total_income,
sati,
sic,
sdnw,
sca,
fti,
secti,
secati,
secstx,
secea,
secipa,
secai,
seccai,
secdnw,
secnw,
secapa,
secpca,
secaai,
sectsc,
sectpc,
secpc,
secsti,
secsic,
secsati,
secsdnw,
secsca,
secfti,
a_citizenship,
a_student_marital_status,
a_student_agi,
a_s_us_tax_paid,
a_s_income_work,
a_spouse_income_work,
a_s_total_wsc,
a_date_of_birth,
a_student_married,
a_have_children,
a_s_have_dependents,
a_va_status,
a_s_num_in_family,
a_s_num_in_college,
a_p_marital_status,
a_father_ssn,
a_mother_ssn,
a_parents_num_family,
a_parents_num_college,
a_parents_agi,
a_p_us_tax_paid,
a_f_work_income,
a_m_work_income,
a_p_total_wsc,
comment_codes,
sar_ack_comm_code,
pell_grant_elig_flag,
reprocess_reason_code,
duplicate_date,
isir_transaction_type,
fedral_schl_code_indicator,
multi_school_code_flags,
dup_ssn_indicator,
payment_isir,
receipt_status,
isir_receipt_completed,
org_id,
system_record_type,
verif_track_flag,
active_isir,
fafsa_data_verify_flags,
reject_override_a,
reject_override_c,
parent_marital_status_date,
legacy_record_flag,
father_first_name_initial_txt,
father_step_father_birth_date,
mother_first_name_initial_txt,
mother_step_mother_birth_date,
parents_email_address_txt,
address_change_type,
cps_pushed_isir_flag,
electronic_transaction_type,
sar_c_change_type,
father_ssn_match_type,
mother_ssn_match_type,
reject_override_g_flag,
dhs_verification_num_txt,
data_file_name_txt,
message_class_txt,
reject_override_3_flag,
reject_override_12_flag,
reject_override_j_flag,
reject_override_k_flag ,
rejected_status_change_flag,
verification_selection_flag
FROM igf_ap_isir_matched_all
WHERE rowid = x_rowid
FOR UPDATE NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
AND ((tlinfo.selective_service_reg = x_selective_service_reg) OR ((tlinfo.selective_service_reg IS NULL) AND (X_selective_service_reg IS NULL)))
AND ((tlinfo.degree_certification = x_degree_certification) OR ((tlinfo.degree_certification IS NULL) AND (X_degree_certification IS NULL)))
AND ((tlinfo.grade_level_in_college = x_grade_level_in_college) OR ((tlinfo.grade_level_in_college IS NULL) AND (X_grade_level_in_college IS NULL)))
AND ((tlinfo.high_school_diploma_ged = x_high_school_diploma_ged) OR ((tlinfo.high_school_diploma_ged IS NULL) AND (X_high_school_diploma_ged IS NULL)))
AND ((tlinfo.first_bachelor_deg_by_date = x_first_bachelor_deg_by_date) OR ((tlinfo.first_bachelor_deg_by_date IS NULL) AND (X_first_bachelor_deg_by_date IS NULL)))
AND ((tlinfo.interest_in_loan = x_interest_in_loan) OR ((tlinfo.interest_in_loan IS NULL) AND (X_interest_in_loan IS NULL)))
AND ((tlinfo.interest_in_stud_employment = x_interest_in_stud_employment) OR ((tlinfo.interest_in_stud_employment IS NULL) AND (X_interest_in_stud_employment IS NULL)))
AND ((tlinfo.drug_offence_conviction = x_drug_offence_conviction) OR ((tlinfo.drug_offence_conviction IS NULL) AND (X_drug_offence_conviction IS NULL)))
AND ((tlinfo.s_tax_return_status = x_s_tax_return_status) OR ((tlinfo.s_tax_return_status IS NULL) AND (X_s_tax_return_status IS NULL)))
AND ((tlinfo.s_type_tax_return = x_s_type_tax_return) OR ((tlinfo.s_type_tax_return IS NULL) AND (X_s_type_tax_return IS NULL)))
AND ((tlinfo.s_elig_1040ez = x_s_elig_1040ez) OR ((tlinfo.s_elig_1040ez IS NULL) AND (X_s_elig_1040ez IS NULL)))
AND ((tlinfo.s_adjusted_gross_income = x_s_adjusted_gross_income) OR ((tlinfo.s_adjusted_gross_income IS NULL) AND (X_s_adjusted_gross_income IS NULL)))
AND ((tlinfo.s_fed_taxes_paid = x_s_fed_taxes_paid) OR ((tlinfo.s_fed_taxes_paid IS NULL) AND (X_s_fed_taxes_paid IS NULL)))
AND ((tlinfo.s_exemptions = x_s_exemptions) OR ((tlinfo.s_exemptions IS NULL) AND (X_s_exemptions IS NULL)))
AND ((tlinfo.s_income_from_work = x_s_income_from_work) OR ((tlinfo.s_income_from_work IS NULL) AND (X_s_income_from_work IS NULL)))
AND ((tlinfo.spouse_income_from_work = x_spouse_income_from_work) OR ((tlinfo.spouse_income_from_work IS NULL) AND (X_spouse_income_from_work IS NULL)))
AND ((tlinfo.s_toa_amt_from_wsa = x_s_toa_amt_from_wsa) OR ((tlinfo.s_toa_amt_from_wsa IS NULL) AND (X_s_toa_amt_from_wsa IS NULL)))
AND ((tlinfo.s_toa_amt_from_wsb = x_s_toa_amt_from_wsb) OR ((tlinfo.s_toa_amt_from_wsb IS NULL) AND (X_s_toa_amt_from_wsb IS NULL)))
AND ((tlinfo.s_toa_amt_from_wsc = x_s_toa_amt_from_wsc) OR ((tlinfo.s_toa_amt_from_wsc IS NULL) AND (X_s_toa_amt_from_wsc IS NULL)))
AND ((tlinfo.s_investment_networth = x_s_investment_networth) OR ((tlinfo.s_investment_networth IS NULL) AND (X_s_investment_networth IS NULL)))
AND ((tlinfo.s_busi_farm_networth = x_s_busi_farm_networth) OR ((tlinfo.s_busi_farm_networth IS NULL) AND (X_s_busi_farm_networth IS NULL)))
AND ((tlinfo.s_cash_savings = x_s_cash_savings) OR ((tlinfo.s_cash_savings IS NULL) AND (X_s_cash_savings IS NULL)))
AND ((tlinfo.va_months = x_va_months) OR ((tlinfo.va_months IS NULL) AND (X_va_months IS NULL)))
AND ((tlinfo.va_amount = x_va_amount) OR ((tlinfo.va_amount IS NULL) AND (X_va_amount IS NULL)))
AND ((tlinfo.stud_dob_before_date = x_stud_dob_before_date) OR ((tlinfo.stud_dob_before_date IS NULL) AND (X_stud_dob_before_date IS NULL)))
AND ((tlinfo.deg_beyond_bachelor = x_deg_beyond_bachelor) OR ((tlinfo.deg_beyond_bachelor IS NULL) AND (X_deg_beyond_bachelor IS NULL)))
AND ((tlinfo.s_married = x_s_married) OR ((tlinfo.s_married IS NULL) AND (X_s_married IS NULL)))
AND ((tlinfo.s_have_children = x_s_have_children) OR ((tlinfo.s_have_children IS NULL) AND (X_s_have_children IS NULL)))
AND ((tlinfo.legal_dependents = x_legal_dependents) OR ((tlinfo.legal_dependents IS NULL) AND (X_legal_dependents IS NULL)))
AND ((tlinfo.orphan_ward_of_court = x_orphan_ward_of_court) OR ((tlinfo.orphan_ward_of_court IS NULL) AND (X_orphan_ward_of_court IS NULL)))
AND ((tlinfo.s_veteran = x_s_veteran) OR ((tlinfo.s_veteran IS NULL) AND (X_s_veteran IS NULL)))
AND ((tlinfo.p_marital_status = x_p_marital_status) OR ((tlinfo.p_marital_status IS NULL) AND (X_p_marital_status IS NULL)))
AND ((tlinfo.father_ssn = x_father_ssn) OR ((tlinfo.father_ssn IS NULL) AND (X_father_ssn IS NULL)))
AND ((tlinfo.f_last_name = x_f_last_name) OR ((tlinfo.f_last_name IS NULL) AND (X_f_last_name IS NULL)))
AND ((tlinfo.mother_ssn = x_mother_ssn) OR ((tlinfo.mother_ssn IS NULL) AND (X_mother_ssn IS NULL)))
AND ((tlinfo.m_last_name = x_m_last_name) OR ((tlinfo.m_last_name IS NULL) AND (X_m_last_name IS NULL)))
AND ((tlinfo.p_num_family_member = x_p_num_family_member) OR ((tlinfo.p_num_family_member IS NULL) AND (X_p_num_family_member IS NULL)))
AND ((tlinfo.p_num_in_college = x_p_num_in_college) OR ((tlinfo.p_num_in_college IS NULL) AND (X_p_num_in_college IS NULL)))
AND ((tlinfo.p_state_legal_residence = x_p_state_legal_residence) OR ((tlinfo.p_state_legal_residence IS NULL) AND (X_p_state_legal_residence IS NULL)))
AND ((tlinfo.p_state_legal_res_before_dt = x_p_state_legal_res_before_dt) OR ((tlinfo.p_state_legal_res_before_dt IS NULL) AND (X_p_state_legal_res_before_dt IS NULL)))
AND ((tlinfo.p_legal_res_date = x_p_legal_res_date) OR ((tlinfo.p_legal_res_date IS NULL) AND (X_p_legal_res_date IS NULL)))
AND ((tlinfo.age_older_parent = x_age_older_parent) OR ((tlinfo.age_older_parent IS NULL) AND (X_age_older_parent IS NULL)))
AND ((tlinfo.p_tax_return_status = x_p_tax_return_status) OR ((tlinfo.p_tax_return_status IS NULL) AND (X_p_tax_return_status IS NULL)))
AND ((tlinfo.p_type_tax_return = x_p_type_tax_return) OR ((tlinfo.p_type_tax_return IS NULL) AND (X_p_type_tax_return IS NULL)))
AND ((tlinfo.p_elig_1040aez = x_p_elig_1040aez) OR ((tlinfo.p_elig_1040aez IS NULL) AND (X_p_elig_1040aez IS NULL)))
AND ((tlinfo.p_adjusted_gross_income = x_p_adjusted_gross_income) OR ((tlinfo.p_adjusted_gross_income IS NULL) AND (X_p_adjusted_gross_income IS NULL)))
AND ((tlinfo.p_taxes_paid = x_p_taxes_paid) OR ((tlinfo.p_taxes_paid IS NULL) AND (X_p_taxes_paid IS NULL)))
AND ((tlinfo.p_exemptions = x_p_exemptions) OR ((tlinfo.p_exemptions IS NULL) AND (X_p_exemptions IS NULL)))
AND ((tlinfo.f_income_work = x_f_income_work) OR ((tlinfo.f_income_work IS NULL) AND (X_f_income_work IS NULL)))
AND ((tlinfo.m_income_work = x_m_income_work) OR ((tlinfo.m_income_work IS NULL) AND (X_m_income_work IS NULL)))
AND ((tlinfo.p_income_wsa = x_p_income_wsa) OR ((tlinfo.p_income_wsa IS NULL) AND (X_p_income_wsa IS NULL)))
AND ((tlinfo.p_income_wsb = x_p_income_wsb) OR ((tlinfo.p_income_wsb IS NULL) AND (X_p_income_wsb IS NULL)))
AND ((tlinfo.p_income_wsc = x_p_income_wsc) OR ((tlinfo.p_income_wsc IS NULL) AND (X_p_income_wsc IS NULL)))
AND ((tlinfo.p_investment_networth = x_p_investment_networth) OR ((tlinfo.p_investment_networth IS NULL) AND (X_p_investment_networth IS NULL)))
AND ((tlinfo.p_business_networth = x_p_business_networth) OR ((tlinfo.p_business_networth IS NULL) AND (X_p_business_networth IS NULL)))
AND ((tlinfo.p_cash_saving = x_p_cash_saving) OR ((tlinfo.p_cash_saving IS NULL) AND (X_p_cash_saving IS NULL)))
AND ((tlinfo.s_num_family_members = x_s_num_family_members) OR ((tlinfo.s_num_family_members IS NULL) AND (X_s_num_family_members IS NULL)))
AND ((tlinfo.s_num_in_college = x_s_num_in_college) OR ((tlinfo.s_num_in_college IS NULL) AND (X_s_num_in_college IS NULL)))
AND ((tlinfo.first_college = x_first_college) OR ((tlinfo.first_college IS NULL) AND (X_first_college IS NULL)))
AND ((tlinfo.first_house_plan = x_first_house_plan) OR ((tlinfo.first_house_plan IS NULL) AND (X_first_house_plan IS NULL)))
AND ((tlinfo.second_college = x_second_college) OR ((tlinfo.second_college IS NULL) AND (X_second_college IS NULL)))
AND ((tlinfo.second_house_plan = x_second_house_plan) OR ((tlinfo.second_house_plan IS NULL) AND (X_second_house_plan IS NULL)))
AND ((tlinfo.third_college = x_third_college) OR ((tlinfo.third_college IS NULL) AND (X_third_college IS NULL)))
AND ((tlinfo.third_house_plan = x_third_house_plan) OR ((tlinfo.third_house_plan IS NULL) AND (X_third_house_plan IS NULL)))
AND ((tlinfo.fourth_college = x_fourth_college) OR ((tlinfo.fourth_college IS NULL) AND (X_fourth_college IS NULL)))
AND ((tlinfo.fourth_house_plan = x_fourth_house_plan) OR ((tlinfo.fourth_house_plan IS NULL) AND (X_fourth_house_plan IS NULL)))
AND ((tlinfo.fifth_college = x_fifth_college) OR ((tlinfo.fifth_college IS NULL) AND (X_fifth_college IS NULL)))
AND ((tlinfo.fifth_house_plan = x_fifth_house_plan) OR ((tlinfo.fifth_house_plan IS NULL) AND (X_fifth_house_plan IS NULL)))
AND ((tlinfo.sixth_college = x_sixth_college) OR ((tlinfo.sixth_college IS NULL) AND (X_sixth_college IS NULL)))
AND ((tlinfo.sixth_house_plan = x_sixth_house_plan) OR ((tlinfo.sixth_house_plan IS NULL) AND (X_sixth_house_plan IS NULL)))
AND ((tlinfo.date_app_completed = x_date_app_completed) OR ((tlinfo.date_app_completed IS NULL) AND (X_date_app_completed IS NULL)))
AND ((tlinfo.signed_by = x_signed_by) OR ((tlinfo.signed_by IS NULL) AND (X_signed_by IS NULL)))
AND ((tlinfo.preparer_ssn = x_preparer_ssn) OR ((tlinfo.preparer_ssn IS NULL) AND (X_preparer_ssn IS NULL)))
AND ((tlinfo.preparer_emp_id_number = x_preparer_emp_id_number) OR ((tlinfo.preparer_emp_id_number IS NULL) AND (X_preparer_emp_id_number IS NULL)))
AND ((tlinfo.preparer_sign = x_preparer_sign) OR ((tlinfo.preparer_sign IS NULL) AND (X_preparer_sign IS NULL)))
AND ((tlinfo.transaction_receipt_date = x_transaction_receipt_date) OR ((tlinfo.transaction_receipt_date IS NULL) AND (X_transaction_receipt_date IS NULL)))
AND ((tlinfo.dependency_override_ind = x_dependency_override_ind) OR ((tlinfo.dependency_override_ind IS NULL) AND (X_dependency_override_ind IS NULL)))
AND ((tlinfo.faa_fedral_schl_code = x_faa_fedral_schl_code) OR ((tlinfo.faa_fedral_schl_code IS NULL) AND (X_faa_fedral_schl_code IS NULL)))
AND ((tlinfo.faa_adjustment = x_faa_adjustment) OR ((tlinfo.faa_adjustment IS NULL) AND (X_faa_adjustment IS NULL)))
AND ((tlinfo.input_record_type = x_input_record_type) OR ((tlinfo.input_record_type IS NULL) AND (X_input_record_type IS NULL)))
AND ((tlinfo.serial_number = x_serial_number) OR ((tlinfo.serial_number IS NULL) AND (X_serial_number IS NULL)))
AND ((tlinfo.batch_number = x_batch_number) OR ((tlinfo.batch_number IS NULL) AND (X_batch_number IS NULL)))
AND ((tlinfo.early_analysis_flag = x_early_analysis_flag) OR ((tlinfo.early_analysis_flag IS NULL) AND (X_early_analysis_flag IS NULL)))
AND ((tlinfo.app_entry_source_code = x_app_entry_source_code) OR ((tlinfo.app_entry_source_code IS NULL) AND (X_app_entry_source_code IS NULL)))
AND ((tlinfo.eti_destination_code = x_eti_destination_code) OR ((tlinfo.eti_destination_code IS NULL) AND (X_eti_destination_code IS NULL)))
AND ((tlinfo.reject_override_b = x_reject_override_b) OR ((tlinfo.reject_override_b IS NULL) AND (X_reject_override_b IS NULL)))
AND ((tlinfo.reject_override_n = x_reject_override_n) OR ((tlinfo.reject_override_n IS NULL) AND (X_reject_override_n IS NULL)))
AND ((tlinfo.reject_override_w = x_reject_override_w) OR ((tlinfo.reject_override_w IS NULL) AND (X_reject_override_w IS NULL)))
AND ((tlinfo.assum_override_1 = x_assum_override_1) OR ((tlinfo.assum_override_1 IS NULL) AND (X_assum_override_1 IS NULL)))
AND ((tlinfo.assum_override_2 = x_assum_override_2) OR ((tlinfo.assum_override_2 IS NULL) AND (X_assum_override_2 IS NULL)))
AND ((tlinfo.assum_override_3 = x_assum_override_3) OR ((tlinfo.assum_override_3 IS NULL) AND (X_assum_override_3 IS NULL)))
AND ((tlinfo.assum_override_4 = x_assum_override_4) OR ((tlinfo.assum_override_4 IS NULL) AND (X_assum_override_4 IS NULL)))
AND ((tlinfo.assum_override_5 = x_assum_override_5) OR ((tlinfo.assum_override_5 IS NULL) AND (X_assum_override_5 IS NULL)))
AND ((tlinfo.assum_override_6 = x_assum_override_6) OR ((tlinfo.assum_override_6 IS NULL) AND (X_assum_override_6 IS NULL)))
AND ((tlinfo.dependency_status = x_dependency_status) OR ((tlinfo.dependency_status IS NULL) AND (X_dependency_status IS NULL)))
AND ((tlinfo.s_email_address = x_s_email_address) OR ((tlinfo.s_email_address IS NULL) AND (X_s_email_address IS NULL)))
AND ((tlinfo.nslds_reason_code = x_nslds_reason_code) OR ((tlinfo.nslds_reason_code IS NULL) AND (X_nslds_reason_code IS NULL)))
AND ((tlinfo.app_receipt_date = x_app_receipt_date) OR ((tlinfo.app_receipt_date IS NULL) AND (X_app_receipt_date IS NULL)))
AND ((tlinfo.processed_rec_type = x_processed_rec_type) OR ((tlinfo.processed_rec_type IS NULL) AND (X_processed_rec_type IS NULL)))
AND ((tlinfo.hist_correction_for_tran_id = x_hist_correction_for_tran_id) OR ((tlinfo.hist_correction_for_tran_id IS NULL) AND (X_hist_correction_for_tran_id IS NULL)))
AND ((tlinfo.system_generated_indicator = x_system_generated_indicator) OR ((tlinfo.system_generated_indicator IS NULL) AND (X_system_generated_indicator IS NULL)))
AND ((tlinfo.dup_request_indicator = x_dup_request_indicator) OR ((tlinfo.dup_request_indicator IS NULL) AND (X_dup_request_indicator IS NULL)))
AND ((tlinfo.source_of_correction = x_source_of_correction) OR ((tlinfo.source_of_correction IS NULL) AND (X_source_of_correction IS NULL)))
AND ((tlinfo.p_cal_tax_status = x_p_cal_tax_status) OR ((tlinfo.p_cal_tax_status IS NULL) AND (X_p_cal_tax_status IS NULL)))
AND ((tlinfo.s_cal_tax_status = x_s_cal_tax_status) OR ((tlinfo.s_cal_tax_status IS NULL) AND (X_s_cal_tax_status IS NULL)))
AND ((tlinfo.graduate_flag = x_graduate_flag) OR ((tlinfo.graduate_flag IS NULL) AND (X_graduate_flag IS NULL)))
AND ((tlinfo.auto_zero_efc = x_auto_zero_efc) OR ((tlinfo.auto_zero_efc IS NULL) AND (X_auto_zero_efc IS NULL)))
AND ((tlinfo.efc_change_flag = x_efc_change_flag) OR ((tlinfo.efc_change_flag IS NULL) AND (X_efc_change_flag IS NULL)))
AND ((tlinfo.sarc_flag = x_sarc_flag) OR ((tlinfo.sarc_flag IS NULL) AND (X_sarc_flag IS NULL)))
AND ((tlinfo.simplified_need_test = x_simplified_need_test) OR ((tlinfo.simplified_need_test IS NULL) AND (X_simplified_need_test IS NULL)))
AND ((tlinfo.reject_reason_codes = x_reject_reason_codes) OR ((tlinfo.reject_reason_codes IS NULL) AND (X_reject_reason_codes IS NULL)))
AND ((tlinfo.select_service_match_flag = x_select_service_match_flag) OR ((tlinfo.select_service_match_flag IS NULL) AND (X_select_service_match_flag IS NULL)))
AND ((tlinfo.select_service_reg_flag = x_select_service_reg_flag) OR ((tlinfo.select_service_reg_flag IS NULL) AND (X_select_service_reg_flag IS NULL)))
AND ((tlinfo.ins_match_flag = x_ins_match_flag) OR ((tlinfo.ins_match_flag IS NULL) AND (X_ins_match_flag IS NULL)))
AND ((tlinfo.sec_ins_match_flag = x_sec_ins_match_flag) OR ((tlinfo.sec_ins_match_flag IS NULL) AND (X_sec_ins_match_flag IS NULL)))
AND ((tlinfo.sec_ins_ver_number = x_sec_ins_ver_number) OR ((tlinfo.sec_ins_ver_number IS NULL) AND (X_sec_ins_ver_number IS NULL)))
AND ((tlinfo.ssn_match_flag = x_ssn_match_flag) OR ((tlinfo.ssn_match_flag IS NULL) AND (X_ssn_match_flag IS NULL)))
AND ((tlinfo.ssa_citizenship_flag = x_ssa_citizenship_flag) OR ((tlinfo.ssa_citizenship_flag IS NULL) AND (X_ssa_citizenship_flag IS NULL)))
AND ((tlinfo.ssn_date_of_death = x_ssn_date_of_death) OR ((tlinfo.ssn_date_of_death IS NULL) AND (X_ssn_date_of_death IS NULL)))
AND ((tlinfo.nslds_match_flag = x_nslds_match_flag) OR ((tlinfo.nslds_match_flag IS NULL) AND (X_nslds_match_flag IS NULL)))
AND ((tlinfo.va_match_flag = x_va_match_flag) OR ((tlinfo.va_match_flag IS NULL) AND (X_va_match_flag IS NULL)))
AND ((tlinfo.prisoner_match = x_prisoner_match) OR ((tlinfo.prisoner_match IS NULL) AND (X_prisoner_match IS NULL)))
AND ((tlinfo.verification_flag = x_verification_flag) OR ((tlinfo.verification_flag IS NULL) AND (X_verification_flag IS NULL)))
AND ((tlinfo.subsequent_app_flag = x_subsequent_app_flag) OR ((tlinfo.subsequent_app_flag IS NULL) AND (X_subsequent_app_flag IS NULL)))
AND ((tlinfo.app_source_site_code = x_app_source_site_code) OR ((tlinfo.app_source_site_code IS NULL) AND (X_app_source_site_code IS NULL)))
AND ((tlinfo.tran_source_site_code = x_tran_source_site_code) OR ((tlinfo.tran_source_site_code IS NULL) AND (X_tran_source_site_code IS NULL)))
AND ((tlinfo.drn = x_drn) OR ((tlinfo.drn IS NULL) AND (X_drn IS NULL)))
AND ((tlinfo.tran_process_date = x_tran_process_date) OR ((tlinfo.tran_process_date IS NULL) AND (X_tran_process_date IS NULL)))
AND ((tlinfo.computer_batch_number = x_computer_batch_number) OR ((tlinfo.computer_batch_number IS NULL) AND (X_computer_batch_number IS NULL)))
AND ((tlinfo.correction_flags = x_correction_flags) OR ((tlinfo.correction_flags IS NULL) AND (X_correction_flags IS NULL)))
AND ((tlinfo.highlight_flags = x_highlight_flags) OR ((tlinfo.highlight_flags IS NULL) AND (X_highlight_flags IS NULL)))
AND ((tlinfo.paid_efc = x_paid_efc) OR ((tlinfo.paid_efc IS NULL) AND (X_paid_efc IS NULL)))
AND ((tlinfo.primary_efc = x_primary_efc) OR ((tlinfo.primary_efc IS NULL) AND (X_primary_efc IS NULL)))
AND ((tlinfo.secondary_efc = x_secondary_efc) OR ((tlinfo.secondary_efc IS NULL) AND (X_secondary_efc IS NULL)))
AND ((tlinfo.fed_pell_grant_efc_type = x_fed_pell_grant_efc_type) OR ((tlinfo.fed_pell_grant_efc_type IS NULL) AND (X_fed_pell_grant_efc_type IS NULL)))
AND ((tlinfo.primary_efc_type = x_primary_efc_type) OR ((tlinfo.primary_efc_type IS NULL) AND (X_primary_efc_type IS NULL)))
AND ((tlinfo.sec_efc_type = x_sec_efc_type) OR ((tlinfo.sec_efc_type IS NULL) AND (X_sec_efc_type IS NULL)))
AND ((tlinfo.primary_alternate_month_1 = x_primary_alternate_month_1) OR ((tlinfo.primary_alternate_month_1 IS NULL) AND (X_primary_alternate_month_1 IS NULL)))
AND ((tlinfo.primary_alternate_month_2 = x_primary_alternate_month_2) OR ((tlinfo.primary_alternate_month_2 IS NULL) AND (X_primary_alternate_month_2 IS NULL)))
AND ((tlinfo.primary_alternate_month_3 = x_primary_alternate_month_3) OR ((tlinfo.primary_alternate_month_3 IS NULL) AND (X_primary_alternate_month_3 IS NULL)))
AND ((tlinfo.primary_alternate_month_4 = x_primary_alternate_month_4) OR ((tlinfo.primary_alternate_month_4 IS NULL) AND (X_primary_alternate_month_4 IS NULL)))
AND ((tlinfo.primary_alternate_month_5 = x_primary_alternate_month_5) OR ((tlinfo.primary_alternate_month_5 IS NULL) AND (X_primary_alternate_month_5 IS NULL)))
AND ((tlinfo.primary_alternate_month_6 = x_primary_alternate_month_6) OR ((tlinfo.primary_alternate_month_6 IS NULL) AND (X_primary_alternate_month_6 IS NULL)))
AND ((tlinfo.primary_alternate_month_7 = x_primary_alternate_month_7) OR ((tlinfo.primary_alternate_month_7 IS NULL) AND (X_primary_alternate_month_7 IS NULL)))
AND ((tlinfo.primary_alternate_month_8 = x_primary_alternate_month_8) OR ((tlinfo.primary_alternate_month_8 IS NULL) AND (X_primary_alternate_month_8 IS NULL)))
AND ((tlinfo.primary_alternate_month_10 = x_primary_alternate_month_10) OR ((tlinfo.primary_alternate_month_10 IS NULL) AND (X_primary_alternate_month_10 IS NULL)))
AND ((tlinfo.primary_alternate_month_11 = x_primary_alternate_month_11) OR ((tlinfo.primary_alternate_month_11 IS NULL) AND (X_primary_alternate_month_11 IS NULL)))
AND ((tlinfo.primary_alternate_month_12 = x_primary_alternate_month_12) OR ((tlinfo.primary_alternate_month_12 IS NULL) AND (X_primary_alternate_month_12 IS NULL)))
AND ((tlinfo.sec_alternate_month_1 = x_sec_alternate_month_1) OR ((tlinfo.sec_alternate_month_1 IS NULL) AND (X_sec_alternate_month_1 IS NULL)))
AND ((tlinfo.sec_alternate_month_2 = x_sec_alternate_month_2) OR ((tlinfo.sec_alternate_month_2 IS NULL) AND (X_sec_alternate_month_2 IS NULL)))
AND ((tlinfo.sec_alternate_month_3 = x_sec_alternate_month_3) OR ((tlinfo.sec_alternate_month_3 IS NULL) AND (X_sec_alternate_month_3 IS NULL)))
AND ((tlinfo.sec_alternate_month_4 = x_sec_alternate_month_4) OR ((tlinfo.sec_alternate_month_4 IS NULL) AND (X_sec_alternate_month_4 IS NULL)))
AND ((tlinfo.sec_alternate_month_5 = x_sec_alternate_month_5) OR ((tlinfo.sec_alternate_month_5 IS NULL) AND (X_sec_alternate_month_5 IS NULL)))
AND ((tlinfo.sec_alternate_month_6 = x_sec_alternate_month_6) OR ((tlinfo.sec_alternate_month_6 IS NULL) AND (X_sec_alternate_month_6 IS NULL)))
AND ((tlinfo.sec_alternate_month_7 = x_sec_alternate_month_7) OR ((tlinfo.sec_alternate_month_7 IS NULL) AND (X_sec_alternate_month_7 IS NULL)))
AND ((tlinfo.sec_alternate_month_8 = x_sec_alternate_month_8) OR ((tlinfo.sec_alternate_month_8 IS NULL) AND (X_sec_alternate_month_8 IS NULL)))
AND ((tlinfo.sec_alternate_month_10 = x_sec_alternate_month_10) OR ((tlinfo.sec_alternate_month_10 IS NULL) AND (X_sec_alternate_month_10 IS NULL)))
AND ((tlinfo.sec_alternate_month_11 = x_sec_alternate_month_11) OR ((tlinfo.sec_alternate_month_11 IS NULL) AND (X_sec_alternate_month_11 IS NULL)))
AND ((tlinfo.sec_alternate_month_12 = x_sec_alternate_month_12) OR ((tlinfo.sec_alternate_month_12 IS NULL) AND (X_sec_alternate_month_12 IS NULL)))
AND ((tlinfo.total_income = x_total_income) OR ((tlinfo.total_income IS NULL) AND (X_total_income IS NULL)))
AND ((tlinfo.allow_total_income = x_allow_total_income) OR ((tlinfo.allow_total_income IS NULL) AND (X_allow_total_income IS NULL)))
AND ((tlinfo.state_tax_allow = x_state_tax_allow) OR ((tlinfo.state_tax_allow IS NULL) AND (X_state_tax_allow IS NULL)))
AND ((tlinfo.employment_allow = x_employment_allow) OR ((tlinfo.employment_allow IS NULL) AND (X_employment_allow IS NULL)))
AND ((tlinfo.income_protection_allow = x_income_protection_allow) OR ((tlinfo.income_protection_allow IS NULL) AND (X_income_protection_allow IS NULL)))
AND ((tlinfo.available_income = x_available_income) OR ((tlinfo.available_income IS NULL) AND (X_available_income IS NULL)))
AND ((tlinfo.contribution_from_ai = x_contribution_from_ai) OR ((tlinfo.contribution_from_ai IS NULL) AND (X_contribution_from_ai IS NULL)))
AND ((tlinfo.discretionary_networth = x_discretionary_networth) OR ((tlinfo.discretionary_networth IS NULL) AND (X_discretionary_networth IS NULL)))
AND ((tlinfo.efc_networth = x_efc_networth) OR ((tlinfo.efc_networth IS NULL) AND (X_efc_networth IS NULL)))
AND ((tlinfo.asset_protect_allow = x_asset_protect_allow) OR ((tlinfo.asset_protect_allow IS NULL) AND (X_asset_protect_allow IS NULL)))
AND ((tlinfo.parents_cont_from_assets = x_parents_cont_from_assets) OR ((tlinfo.parents_cont_from_assets IS NULL) AND (X_parents_cont_from_assets IS NULL)))
AND ((tlinfo.adjusted_available_income = x_adjusted_available_income) OR ((tlinfo.adjusted_available_income IS NULL) AND (X_adjusted_available_income IS NULL)))
AND ((tlinfo.total_student_contribution = x_total_student_contribution) OR ((tlinfo.total_student_contribution IS NULL) AND (X_total_student_contribution IS NULL)))
AND ((tlinfo.total_parent_contribution = x_total_parent_contribution) OR ((tlinfo.total_parent_contribution IS NULL) AND (X_total_parent_contribution IS NULL)))
AND ((tlinfo.parents_contribution = x_parents_contribution) OR ((tlinfo.parents_contribution IS NULL) AND (X_parents_contribution IS NULL)))
AND ((tlinfo.student_total_income = x_student_total_income) OR ((tlinfo.student_total_income IS NULL) AND (X_student_total_income IS NULL)))
AND ((tlinfo.sati = x_sati) OR ((tlinfo.sati IS NULL) AND (X_sati IS NULL)))
AND ((tlinfo.sic = x_sic) OR ((tlinfo.sic IS NULL) AND (X_sic IS NULL)))
AND ((tlinfo.sdnw = x_sdnw) OR ((tlinfo.sdnw IS NULL) AND (X_sdnw IS NULL)))
AND ((tlinfo.sca = x_sca) OR ((tlinfo.sca IS NULL) AND (X_sca IS NULL)))
AND ((tlinfo.fti = x_fti) OR ((tlinfo.fti IS NULL) AND (X_fti IS NULL)))
AND ((tlinfo.secti = x_secti) OR ((tlinfo.secti IS NULL) AND (X_secti IS NULL)))
AND ((tlinfo.secati = x_secati) OR ((tlinfo.secati IS NULL) AND (X_secati IS NULL)))
AND ((tlinfo.secstx = x_secstx) OR ((tlinfo.secstx IS NULL) AND (X_secstx IS NULL)))
AND ((tlinfo.secea = x_secea) OR ((tlinfo.secea IS NULL) AND (X_secea IS NULL)))
AND ((tlinfo.secipa = x_secipa) OR ((tlinfo.secipa IS NULL) AND (X_secipa IS NULL)))
AND ((tlinfo.secai = x_secai) OR ((tlinfo.secai IS NULL) AND (X_secai IS NULL)))
AND ((tlinfo.seccai = x_seccai) OR ((tlinfo.seccai IS NULL) AND (X_seccai IS NULL)))
AND ((tlinfo.secdnw = x_secdnw) OR ((tlinfo.secdnw IS NULL) AND (X_secdnw IS NULL)))
AND ((tlinfo.secnw = x_secnw) OR ((tlinfo.secnw IS NULL) AND (X_secnw IS NULL)))
AND ((tlinfo.secapa = x_secapa) OR ((tlinfo.secapa IS NULL) AND (X_secapa IS NULL)))
AND ((tlinfo.secpca = x_secpca) OR ((tlinfo.secpca IS NULL) AND (X_secpca IS NULL)))
AND ((tlinfo.secaai = x_secaai) OR ((tlinfo.secaai IS NULL) AND (X_secaai IS NULL)))
AND ((tlinfo.sectsc = x_sectsc) OR ((tlinfo.sectsc IS NULL) AND (X_sectsc IS NULL)))
AND ((tlinfo.sectpc = x_sectpc) OR ((tlinfo.sectpc IS NULL) AND (X_sectpc IS NULL)))
AND ((tlinfo.secpc = x_secpc) OR ((tlinfo.secpc IS NULL) AND (X_secpc IS NULL)))
AND ((tlinfo.secsti = x_secsti) OR ((tlinfo.secsti IS NULL) AND (X_secsti IS NULL)))
AND ((tlinfo.secsic = x_secsic) OR ((tlinfo.secsic IS NULL) AND (X_secsic IS NULL)))
AND ((tlinfo.secsati = x_secsati) OR ((tlinfo.secsati IS NULL) AND (X_secsati IS NULL)))
AND ((tlinfo.secsdnw = x_secsdnw) OR ((tlinfo.secsdnw IS NULL) AND (X_secsdnw IS NULL)))
AND ((tlinfo.secsca = x_secsca) OR ((tlinfo.secsca IS NULL) AND (X_secsca IS NULL)))
AND ((tlinfo.secfti = x_secfti) OR ((tlinfo.secfti IS NULL) AND (X_secfti IS NULL)))
AND ((tlinfo.a_citizenship = x_a_citizenship) OR ((tlinfo.a_citizenship IS NULL) AND (X_a_citizenship IS NULL)))
AND ((tlinfo.a_student_marital_status = x_a_student_marital_status) OR ((tlinfo.a_student_marital_status IS NULL) AND (X_a_student_marital_status IS NULL)))
AND ((tlinfo.a_student_agi = x_a_student_agi) OR ((tlinfo.a_student_agi IS NULL) AND (X_a_student_agi IS NULL)))
AND ((tlinfo.a_s_us_tax_paid = x_a_s_us_tax_paid) OR ((tlinfo.a_s_us_tax_paid IS NULL) AND (X_a_s_us_tax_paid IS NULL)))
AND ((tlinfo.a_s_income_work = x_a_s_income_work) OR ((tlinfo.a_s_income_work IS NULL) AND (X_a_s_income_work IS NULL)))
AND ((tlinfo.a_spouse_income_work = x_a_spouse_income_work) OR ((tlinfo.a_spouse_income_work IS NULL) AND (X_a_spouse_income_work IS NULL)))
AND ((tlinfo.a_s_total_wsc = x_a_s_total_wsc) OR ((tlinfo.a_s_total_wsc IS NULL) AND (X_a_s_total_wsc IS NULL)))
AND ((tlinfo.a_date_of_birth = x_a_date_of_birth) OR ((tlinfo.a_date_of_birth IS NULL) AND (X_a_date_of_birth IS NULL)))
AND ((tlinfo.a_student_married = x_a_student_married) OR ((tlinfo.a_student_married IS NULL) AND (X_a_student_married IS NULL)))
AND ((tlinfo.a_have_children = x_a_have_children) OR ((tlinfo.a_have_children IS NULL) AND (X_a_have_children IS NULL)))
AND ((tlinfo.a_s_have_dependents = x_a_s_have_dependents) OR ((tlinfo.a_s_have_dependents IS NULL) AND (X_a_s_have_dependents IS NULL)))
AND ((tlinfo.a_va_status = x_a_va_status) OR ((tlinfo.a_va_status IS NULL) AND (X_a_va_status IS NULL)))
AND ((tlinfo.a_s_num_in_family = x_a_s_num_in_family) OR ((tlinfo.a_s_num_in_family IS NULL) AND (X_a_s_num_in_family IS NULL)))
AND ((tlinfo.a_s_num_in_college = x_a_s_num_in_college) OR ((tlinfo.a_s_num_in_college IS NULL) AND (X_a_s_num_in_college IS NULL)))
AND ((tlinfo.a_p_marital_status = x_a_p_marital_status) OR ((tlinfo.a_p_marital_status IS NULL) AND (X_a_p_marital_status IS NULL)))
AND ((tlinfo.a_father_ssn = x_a_father_ssn) OR ((tlinfo.a_father_ssn IS NULL) AND (X_a_father_ssn IS NULL)))
AND ((tlinfo.a_mother_ssn = x_a_mother_ssn) OR ((tlinfo.a_mother_ssn IS NULL) AND (X_a_mother_ssn IS NULL)))
AND ((tlinfo.a_parents_num_family = x_a_parents_num_family) OR ((tlinfo.a_parents_num_family IS NULL) AND (X_a_parents_num_family IS NULL)))
AND ((tlinfo.a_parents_num_college = x_a_parents_num_college) OR ((tlinfo.a_parents_num_college IS NULL) AND (X_a_parents_num_college IS NULL)))
AND ((tlinfo.a_parents_agi = x_a_parents_agi) OR ((tlinfo.a_parents_agi IS NULL) AND (X_a_parents_agi IS NULL)))
AND ((tlinfo.a_p_us_tax_paid = x_a_p_us_tax_paid) OR ((tlinfo.a_p_us_tax_paid IS NULL) AND (X_a_p_us_tax_paid IS NULL)))
AND ((tlinfo.a_f_work_income = x_a_f_work_income) OR ((tlinfo.a_f_work_income IS NULL) AND (X_a_f_work_income IS NULL)))
AND ((tlinfo.a_m_work_income = x_a_m_work_income) OR ((tlinfo.a_m_work_income IS NULL) AND (X_a_m_work_income IS NULL)))
AND ((tlinfo.a_p_total_wsc = x_a_p_total_wsc) OR ((tlinfo.a_p_total_wsc IS NULL) AND (X_a_p_total_wsc IS NULL)))
AND ((tlinfo.comment_codes = x_comment_codes) OR ((tlinfo.comment_codes IS NULL) AND (X_comment_codes IS NULL)))
AND ((tlinfo.sar_ack_comm_code = x_sar_ack_comm_code) OR ((tlinfo.sar_ack_comm_code IS NULL) AND (X_sar_ack_comm_code IS NULL)))
AND ((tlinfo.pell_grant_elig_flag = x_pell_grant_elig_flag) OR ((tlinfo.pell_grant_elig_flag IS NULL) AND (X_pell_grant_elig_flag IS NULL)))
AND ((tlinfo.reprocess_reason_code = x_reprocess_reason_code) OR ((tlinfo.reprocess_reason_code IS NULL) AND (X_reprocess_reason_code IS NULL)))
AND ((tlinfo.duplicate_date = x_duplicate_date) OR ((tlinfo.duplicate_date IS NULL) AND (X_duplicate_date IS NULL)))
AND ((tlinfo.isir_transaction_type = x_isir_transaction_type) OR ((tlinfo.isir_transaction_type IS NULL) AND (X_isir_transaction_type IS NULL)))
AND ((tlinfo.fedral_schl_code_indicator = x_fedral_schl_code_indicator) OR ((tlinfo.fedral_schl_code_indicator IS NULL) AND (X_fedral_schl_code_indicator IS NULL)))
AND ((tlinfo.multi_school_code_flags = x_multi_school_code_flags) OR ((tlinfo.multi_school_code_flags IS NULL) AND (X_multi_school_code_flags IS NULL)))
AND ((tlinfo.dup_ssn_indicator = x_dup_ssn_indicator) OR ((tlinfo.dup_ssn_indicator IS NULL) AND (X_dup_ssn_indicator IS NULL)))
AND ((tlinfo.payment_isir = x_payment_isir) OR ((tlinfo.payment_isir IS NULL) AND (X_payment_isir IS NULL)))
AND ((tlinfo.receipt_status = x_receipt_status) OR ((tlinfo.receipt_status IS NULL) AND (X_receipt_status IS NULL)))
AND ((tlinfo.isir_receipt_completed = x_isir_receipt_completed) OR ((tlinfo.isir_receipt_completed IS NULL) AND (X_isir_receipt_completed IS NULL)))
AND ((tlinfo.system_record_type = x_system_record_type) OR ((tlinfo.system_record_type IS NULL) AND (X_system_record_type IS NULL)))
AND ((tlinfo.verif_track_flag = x_verif_track_flag) OR ((tlinfo.verif_track_flag IS NULL) AND (x_verif_track_flag IS NULL)))
AND ((tlinfo.active_isir = x_active_isir )OR ((tlinfo.active_isir IS NULL) AND (x_active_isir IS NULL)))
AND ((tlinfo.fafsa_data_verify_flags = x_fafsa_data_verify_flags )OR ((tlinfo.fafsa_data_verify_flags IS NULL) AND (x_fafsa_data_verify_flags IS NULL)))
AND ((tlinfo.reject_override_a = x_reject_override_a )OR ((tlinfo.reject_override_a IS NULL) AND (x_reject_override_a IS NULL)))
AND ((tlinfo.reject_override_c = x_reject_override_c )OR ((tlinfo.reject_override_c IS NULL) AND (x_reject_override_c IS NULL)))
AND ((tlinfo.parent_marital_status_date = x_parent_marital_status_date )OR ((tlinfo.parent_marital_status_date IS NULL) AND (x_parent_marital_status_date IS NULL)))
AND ((tlinfo.legacy_record_flag = x_legacy_record_flag )OR ((tlinfo.legacy_record_flag IS NULL) AND (x_legacy_record_flag IS NULL)))
AND ((tlinfo.father_first_name_initial_txt = x_father_first_name_initial )OR ((tlinfo.father_first_name_initial_txt IS NULL) AND (x_father_first_name_initial IS NULL)))
AND ((tlinfo.father_step_father_birth_date = x_father_step_father_birth_dt )OR ((tlinfo.father_step_father_birth_date IS NULL) AND (x_father_step_father_birth_dt IS NULL)))
AND ((tlinfo.mother_first_name_initial_txt = x_mother_first_name_initial )OR ((tlinfo.mother_first_name_initial_txt IS NULL) AND (x_mother_first_name_initial IS NULL)))
AND ((tlinfo.mother_step_mother_birth_date = x_mother_step_mother_birth_dt )OR ((tlinfo.mother_step_mother_birth_date IS NULL) AND (x_mother_step_mother_birth_dt IS NULL)))
AND ((tlinfo.parents_email_address_txt = x_parents_email_address_txt )OR ((tlinfo.parents_email_address_txt IS NULL) AND (x_parents_email_address_txt IS NULL)))
AND ((tlinfo.address_change_type = x_address_change_type )OR ((tlinfo.address_change_type IS NULL) AND (x_address_change_type IS NULL)))
AND ((tlinfo.cps_pushed_isir_flag = x_cps_pushed_isir_flag )OR ((tlinfo.cps_pushed_isir_flag IS NULL) AND (x_cps_pushed_isir_flag IS NULL)))
AND ((tlinfo.electronic_transaction_type = x_electronic_transaction_type )OR ((tlinfo.electronic_transaction_type IS NULL) AND (x_electronic_transaction_type IS NULL)))
AND ((tlinfo.sar_c_change_type = x_sar_c_change_type )OR ((tlinfo.sar_c_change_type IS NULL) AND (x_sar_c_change_type IS NULL)))
AND ((tlinfo.father_ssn_match_type = x_father_ssn_match_type )OR ((tlinfo.father_ssn_match_type IS NULL) AND (x_father_ssn_match_type IS NULL)))
AND ((tlinfo.mother_ssn_match_type = x_mother_ssn_match_type )OR ((tlinfo.mother_ssn_match_type IS NULL) AND (x_mother_ssn_match_type IS NULL)))
AND ((tlinfo.reject_override_g_flag = x_reject_override_g_flag )OR ((tlinfo.reject_override_g_flag IS NULL) AND (x_reject_override_g_flag IS NULL)))
AND ((tlinfo.dhs_verification_num_txt = x_dhs_verification_num_txt )OR ((tlinfo.dhs_verification_num_txt IS NULL) AND (x_dhs_verification_num_txt IS NULL)))
AND ((tlinfo.data_file_name_txt = x_data_file_name_txt )OR ((tlinfo.data_file_name_txt IS NULL) AND (x_data_file_name_txt IS NULL)))
AND ((tlinfo.message_class_txt = x_message_class_txt )OR ((tlinfo.message_class_txt IS NULL) AND (x_message_class_txt IS NULL)))
AND ((tlinfo.reject_override_3_flag = x_reject_override_3_flag )OR ((tlinfo.reject_override_3_flag IS NULL) AND (x_reject_override_3_flag IS NULL)))
AND ((tlinfo.reject_override_12_flag = x_reject_override_12_flag )OR ((tlinfo.reject_override_12_flag IS NULL) AND (x_reject_override_12_flag IS NULL)))
AND ((tlinfo.reject_override_j_flag = x_reject_override_j_flag )OR ((tlinfo.reject_override_j_flag IS NULL) AND (x_reject_override_j_flag IS NULL)))
AND ((tlinfo.reject_override_k_flag = x_reject_override_k_flag )OR ((tlinfo.reject_override_k_flag IS NULL) AND (x_reject_override_k_flag IS NULL)))
AND ((tlinfo.rejected_status_change_flag = x_rejected_status_change_flag )OR ((tlinfo.rejected_status_change_flag IS NULL) AND (x_rejected_status_change_flag IS NULL)))
AND ((tlinfo.verification_selection_flag = x_verification_selection_flag )OR ((tlinfo.verification_selection_flag IS NULL) AND (x_verification_selection_flag IS NULL)))
) THEN
NULL;
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_isir_id IN NUMBER,
x_base_id IN NUMBER,
x_batch_year IN NUMBER,
x_transaction_num IN VARCHAR2,
x_current_ssn IN VARCHAR2,
x_ssn_name_change IN VARCHAR2,
x_original_ssn IN VARCHAR2,
x_orig_name_id IN VARCHAR2,
x_last_name IN VARCHAR2,
x_first_name IN VARCHAR2,
x_middle_initial IN VARCHAR2,
x_perm_mail_add IN VARCHAR2,
x_perm_city IN VARCHAR2,
x_perm_state IN VARCHAR2,
x_perm_zip_code IN VARCHAR2,
x_date_of_birth IN DATE,
x_phone_number IN VARCHAR2,
x_driver_license_number IN VARCHAR2,
x_driver_license_state IN VARCHAR2,
x_citizenship_status IN VARCHAR2,
x_alien_reg_number IN VARCHAR2,
x_s_marital_status IN VARCHAR2,
x_s_marital_status_date IN DATE,
x_summ_enrl_status IN VARCHAR2,
x_fall_enrl_status IN VARCHAR2,
x_winter_enrl_status IN VARCHAR2,
x_spring_enrl_status IN VARCHAR2,
x_summ2_enrl_status IN VARCHAR2,
x_fathers_highest_edu_level IN VARCHAR2,
x_mothers_highest_edu_level IN VARCHAR2,
x_s_state_legal_residence IN VARCHAR2,
x_legal_residence_before_date IN VARCHAR2,
x_s_legal_resd_date IN DATE,
x_ss_r_u_male IN VARCHAR2,
x_selective_service_reg IN VARCHAR2,
x_degree_certification IN VARCHAR2,
x_grade_level_in_college IN VARCHAR2,
x_high_school_diploma_ged IN VARCHAR2,
x_first_bachelor_deg_by_date IN VARCHAR2,
x_interest_in_loan IN VARCHAR2,
x_interest_in_stud_employment IN VARCHAR2,
x_drug_offence_conviction IN VARCHAR2,
x_s_tax_return_status IN VARCHAR2,
x_s_type_tax_return IN VARCHAR2,
x_s_elig_1040ez IN VARCHAR2,
x_s_adjusted_gross_income IN NUMBER,
x_s_fed_taxes_paid IN NUMBER,
x_s_exemptions IN NUMBER,
x_s_income_from_work IN NUMBER,
x_spouse_income_from_work IN NUMBER,
x_s_toa_amt_from_wsa IN NUMBER,
x_s_toa_amt_from_wsb IN NUMBER,
x_s_toa_amt_from_wsc IN NUMBER,
x_s_investment_networth IN NUMBER,
x_s_busi_farm_networth IN NUMBER,
x_s_cash_savings IN NUMBER,
x_va_months IN NUMBER,
x_va_amount IN NUMBER,
x_stud_dob_before_date IN VARCHAR2,
x_deg_beyond_bachelor IN VARCHAR2,
x_s_married IN VARCHAR2,
x_s_have_children IN VARCHAR2,
x_legal_dependents IN VARCHAR2,
x_orphan_ward_of_court IN VARCHAR2,
x_s_veteran IN VARCHAR2,
x_p_marital_status IN VARCHAR2,
x_father_ssn IN VARCHAR2,
x_f_last_name IN VARCHAR2,
x_mother_ssn IN VARCHAR2,
x_m_last_name IN VARCHAR2,
x_p_num_family_member IN NUMBER,
x_p_num_in_college IN NUMBER,
x_p_state_legal_residence IN VARCHAR2,
x_p_state_legal_res_before_dt IN VARCHAR2,
x_p_legal_res_date IN DATE,
x_age_older_parent IN NUMBER,
x_p_tax_return_status IN VARCHAR2,
x_p_type_tax_return IN VARCHAR2,
x_p_elig_1040aez IN VARCHAR2,
x_p_adjusted_gross_income IN NUMBER,
x_p_taxes_paid IN NUMBER,
x_p_exemptions IN NUMBER,
x_f_income_work IN NUMBER,
x_m_income_work IN NUMBER,
x_p_income_wsa IN NUMBER,
x_p_income_wsb IN NUMBER,
x_p_income_wsc IN NUMBER,
x_p_investment_networth IN NUMBER,
x_p_business_networth IN NUMBER,
x_p_cash_saving IN NUMBER,
x_s_num_family_members IN NUMBER,
x_s_num_in_college IN NUMBER,
x_first_college IN VARCHAR2,
x_first_house_plan IN VARCHAR2,
x_second_college IN VARCHAR2,
x_second_house_plan IN VARCHAR2,
x_third_college IN VARCHAR2,
x_third_house_plan IN VARCHAR2,
x_fourth_college IN VARCHAR2,
x_fourth_house_plan IN VARCHAR2,
x_fifth_college IN VARCHAR2,
x_fifth_house_plan IN VARCHAR2,
x_sixth_college IN VARCHAR2,
x_sixth_house_plan IN VARCHAR2,
x_date_app_completed IN DATE,
x_signed_by IN VARCHAR2,
x_preparer_ssn IN VARCHAR2,
x_preparer_emp_id_number IN VARCHAR2,
x_preparer_sign IN VARCHAR2,
x_transaction_receipt_date IN DATE,
x_dependency_override_ind IN VARCHAR2,
x_faa_fedral_schl_code IN VARCHAR2,
x_faa_adjustment IN VARCHAR2,
x_input_record_type IN VARCHAR2,
x_serial_number IN NUMBER,
x_batch_number IN VARCHAR2,
x_early_analysis_flag IN VARCHAR2,
x_app_entry_source_code IN VARCHAR2,
x_eti_destination_code IN VARCHAR2,
x_reject_override_b IN VARCHAR2,
x_reject_override_n IN VARCHAR2,
x_reject_override_w IN VARCHAR2,
x_assum_override_1 IN VARCHAR2,
x_assum_override_2 IN VARCHAR2,
x_assum_override_3 IN VARCHAR2,
x_assum_override_4 IN VARCHAR2,
x_assum_override_5 IN VARCHAR2,
x_assum_override_6 IN VARCHAR2,
x_dependency_status IN VARCHAR2,
x_s_email_address IN VARCHAR2,
x_nslds_reason_code IN VARCHAR2,
x_app_receipt_date IN DATE,
x_processed_rec_type IN VARCHAR2,
x_hist_correction_for_tran_id IN NUMBER,
x_system_generated_indicator IN VARCHAR2,
x_dup_request_indicator IN VARCHAR2,
x_source_of_correction IN VARCHAR2,
x_p_cal_tax_status IN VARCHAR2,
x_s_cal_tax_status IN VARCHAR2,
x_graduate_flag IN VARCHAR2,
x_auto_zero_efc IN VARCHAR2,
x_efc_change_flag IN VARCHAR2,
x_sarc_flag IN VARCHAR2,
x_simplified_need_test IN VARCHAR2,
x_reject_reason_codes IN VARCHAR2,
x_select_service_match_flag IN VARCHAR2,
x_select_service_reg_flag IN VARCHAR2,
x_ins_match_flag IN VARCHAR2,
x_ins_verification_number IN NUMBER,
x_sec_ins_match_flag IN VARCHAR2,
x_sec_ins_ver_number IN NUMBER,
x_ssn_match_flag IN VARCHAR2,
x_ssa_citizenship_flag IN VARCHAR2,
x_ssn_date_of_death IN DATE,
x_nslds_match_flag IN VARCHAR2,
x_va_match_flag IN VARCHAR2,
x_prisoner_match IN VARCHAR2,
x_verification_flag IN VARCHAR2,
x_subsequent_app_flag IN VARCHAR2,
x_app_source_site_code IN VARCHAR2,
x_tran_source_site_code IN VARCHAR2,
x_drn IN NUMBER,
x_tran_process_date IN DATE,
x_computer_batch_number IN NUMBER,
x_correction_flags IN VARCHAR2,
x_highlight_flags IN VARCHAR2,
x_paid_efc IN NUMBER,
x_primary_efc IN NUMBER,
x_secondary_efc IN NUMBER,
x_fed_pell_grant_efc_type IN VARCHAR2,
x_primary_efc_type IN VARCHAR2,
x_sec_efc_type IN VARCHAR2,
x_primary_alternate_month_1 IN NUMBER,
x_primary_alternate_month_2 IN NUMBER,
x_primary_alternate_month_3 IN NUMBER,
x_primary_alternate_month_4 IN NUMBER,
x_primary_alternate_month_5 IN NUMBER,
x_primary_alternate_month_6 IN NUMBER,
x_primary_alternate_month_7 IN NUMBER,
x_primary_alternate_month_8 IN NUMBER,
x_primary_alternate_month_10 IN NUMBER,
x_primary_alternate_month_11 IN NUMBER,
x_primary_alternate_month_12 IN NUMBER,
x_sec_alternate_month_1 IN NUMBER,
x_sec_alternate_month_2 IN NUMBER,
x_sec_alternate_month_3 IN NUMBER,
x_sec_alternate_month_4 IN NUMBER,
x_sec_alternate_month_5 IN NUMBER,
x_sec_alternate_month_6 IN NUMBER,
x_sec_alternate_month_7 IN NUMBER,
x_sec_alternate_month_8 IN NUMBER,
x_sec_alternate_month_10 IN NUMBER,
x_sec_alternate_month_11 IN NUMBER,
x_sec_alternate_month_12 IN NUMBER,
x_total_income IN NUMBER,
x_allow_total_income IN NUMBER,
x_state_tax_allow IN NUMBER,
x_employment_allow IN NUMBER,
x_income_protection_allow IN NUMBER,
x_available_income IN NUMBER,
x_contribution_from_ai IN NUMBER,
x_discretionary_networth IN NUMBER,
x_efc_networth IN NUMBER,
x_asset_protect_allow IN NUMBER,
x_parents_cont_from_assets IN NUMBER,
x_adjusted_available_income IN NUMBER,
x_total_student_contribution IN NUMBER,
x_total_parent_contribution IN NUMBER,
x_parents_contribution IN NUMBER,
x_student_total_income IN NUMBER,
x_sati IN NUMBER,
x_sic IN NUMBER,
x_sdnw IN NUMBER,
x_sca IN NUMBER,
x_fti IN NUMBER,
x_secti IN NUMBER,
x_secati IN NUMBER,
x_secstx IN NUMBER,
x_secea IN NUMBER,
x_secipa IN NUMBER,
x_secai IN NUMBER,
x_seccai IN NUMBER,
x_secdnw IN NUMBER,
x_secnw IN NUMBER,
x_secapa IN NUMBER,
x_secpca IN NUMBER,
x_secaai IN NUMBER,
x_sectsc IN NUMBER,
x_sectpc IN NUMBER,
x_secpc IN NUMBER,
x_secsti IN NUMBER,
x_secsic IN NUMBER,
x_secsati IN NUMBER,
x_secsdnw IN NUMBER,
x_secsca IN NUMBER,
x_secfti IN NUMBER,
x_a_citizenship IN VARCHAR2,
x_a_student_marital_status IN VARCHAR2,
x_a_student_agi IN NUMBER,
x_a_s_us_tax_paid IN NUMBER,
x_a_s_income_work IN NUMBER,
x_a_spouse_income_work IN NUMBER,
x_a_s_total_wsc IN NUMBER,
x_a_date_of_birth IN VARCHAR2,
x_a_student_married IN VARCHAR2,
x_a_have_children IN VARCHAR2,
x_a_s_have_dependents IN VARCHAR2,
x_a_va_status IN VARCHAR2,
x_a_s_num_in_family IN NUMBER,
x_a_s_num_in_college IN NUMBER,
x_a_p_marital_status IN VARCHAR2,
x_a_father_ssn IN VARCHAR2,
x_a_mother_ssn IN VARCHAR2,
x_a_parents_num_family IN NUMBER,
x_a_parents_num_college IN NUMBER,
x_a_parents_agi IN NUMBER,
x_a_p_us_tax_paid IN NUMBER,
x_a_f_work_income IN NUMBER,
x_a_m_work_income IN NUMBER,
x_a_p_total_wsc IN NUMBER,
x_comment_codes IN VARCHAR2,
x_sar_ack_comm_code IN VARCHAR2,
x_pell_grant_elig_flag IN VARCHAR2,
x_reprocess_reason_code IN VARCHAR2,
x_duplicate_date IN DATE,
x_isir_transaction_type IN VARCHAR2,
x_fedral_schl_code_indicator IN VARCHAR2,
x_multi_school_code_flags IN VARCHAR2,
x_dup_ssn_indicator IN VARCHAR2,
x_payment_isir IN VARCHAR2,
x_receipt_status IN VARCHAR2,
x_isir_receipt_completed IN VARCHAR2,
x_mode IN VARCHAR2,
x_system_record_type IN VARCHAR2,
x_verif_track_flag IN VARCHAR2,
x_active_isir IN VARCHAR2,
x_fafsa_data_verify_flags IN VARCHAR2,
x_reject_override_a IN VARCHAR2,
x_reject_override_c IN VARCHAR2,
x_parent_marital_status_date IN DATE,
x_legacy_record_flag IN VARCHAR2,
x_father_first_name_initial IN VARCHAR2,
x_father_step_father_birth_dt IN DATE ,
x_mother_first_name_initial IN VARCHAR2,
x_mother_step_mother_birth_dt IN DATE ,
x_parents_email_address_txt IN VARCHAR2,
x_address_change_type IN VARCHAR2,
x_cps_pushed_isir_flag IN VARCHAR2,
x_electronic_transaction_type IN VARCHAR2,
x_sar_c_change_type IN VARCHAR2,
x_father_ssn_match_type IN VARCHAR2,
x_mother_ssn_match_type IN VARCHAR2,
x_reject_override_g_flag IN VARCHAR2,
x_dhs_verification_num_txt IN VARCHAR2,
x_data_file_name_txt IN VARCHAR2,
x_message_class_txt IN VARCHAR2,
x_reject_override_3_flag IN VARCHAR2,
x_reject_override_12_flag IN VARCHAR2,
x_reject_override_j_flag IN VARCHAR2,
x_reject_override_k_flag IN VARCHAR2,
x_rejected_status_change_flag IN VARCHAR2,
x_verification_selection_flag IN VARCHAR2
) AS
/*
|| Created By : rasingh
|| Created On : 06-DEC-2000
|| Purpose : Handles the UPDATE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
-- fetch the student details
CURSOR cur_fa_base( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
SELECT *
FROM igf_ap_fa_base_rec
WHERE base_id = cp_base_id
FOR UPDATE NOWAIT ;
x_last_update_date DATE ;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
x_program_update_date DATE;
x_last_update_date := SYSDATE;
x_last_updated_by := 1;
x_last_update_login := 0;
x_last_updated_by := fnd_global.user_id;
IF x_last_updated_by IS NULL THEN
x_last_updated_by := -1;
x_last_update_login := fnd_global.login_id;
IF (x_last_update_login IS NULL) THEN
x_last_update_login := -1;
p_action => 'UPDATE',
x_rowid => x_rowid,
x_isir_id => x_isir_id,
x_base_id => x_base_id,
x_batch_year => x_batch_year,
x_transaction_num => x_transaction_num,
x_current_ssn => x_current_ssn,
x_ssn_name_change => x_ssn_name_change,
x_original_ssn => x_original_ssn,
x_orig_name_id => x_orig_name_id,
x_last_name => x_last_name,
x_first_name => x_first_name,
x_middle_initial => x_middle_initial,
x_perm_mail_add => x_perm_mail_add,
x_perm_city => x_perm_city,
x_perm_state => x_perm_state,
x_perm_zip_code => x_perm_zip_code,
x_date_of_birth => x_date_of_birth,
x_phone_number => x_phone_number,
x_driver_license_number => x_driver_license_number,
x_driver_license_state => x_driver_license_state,
x_citizenship_status => x_citizenship_status,
x_alien_reg_number => x_alien_reg_number,
x_s_marital_status => x_s_marital_status,
x_s_marital_status_date => x_s_marital_status_date,
x_summ_enrl_status => x_summ_enrl_status,
x_fall_enrl_status => x_fall_enrl_status,
x_winter_enrl_status => x_winter_enrl_status,
x_spring_enrl_status => x_spring_enrl_status,
x_summ2_enrl_status => x_summ2_enrl_status,
x_fathers_highest_edu_level => x_fathers_highest_edu_level,
x_mothers_highest_edu_level => x_mothers_highest_edu_level,
x_s_state_legal_residence => x_s_state_legal_residence,
x_legal_residence_before_date => x_legal_residence_before_date,
x_s_legal_resd_date => x_s_legal_resd_date,
x_ss_r_u_male => x_ss_r_u_male,
x_selective_service_reg => x_selective_service_reg,
x_degree_certification => x_degree_certification,
x_grade_level_in_college => x_grade_level_in_college,
x_high_school_diploma_ged => x_high_school_diploma_ged,
x_first_bachelor_deg_by_date => x_first_bachelor_deg_by_date,
x_interest_in_loan => x_interest_in_loan,
x_interest_in_stud_employment => x_interest_in_stud_employment,
x_drug_offence_conviction => x_drug_offence_conviction,
x_s_tax_return_status => x_s_tax_return_status,
x_s_type_tax_return => x_s_type_tax_return,
x_s_elig_1040ez => x_s_elig_1040ez,
x_s_adjusted_gross_income => x_s_adjusted_gross_income,
x_s_fed_taxes_paid => x_s_fed_taxes_paid,
x_s_exemptions => x_s_exemptions,
x_s_income_from_work => x_s_income_from_work,
x_spouse_income_from_work => x_spouse_income_from_work,
x_s_toa_amt_from_wsa => x_s_toa_amt_from_wsa,
x_s_toa_amt_from_wsb => x_s_toa_amt_from_wsb,
x_s_toa_amt_from_wsc => x_s_toa_amt_from_wsc,
x_s_investment_networth => x_s_investment_networth,
x_s_busi_farm_networth => x_s_busi_farm_networth,
x_s_cash_savings => x_s_cash_savings,
x_va_months => x_va_months,
x_va_amount => x_va_amount,
x_stud_dob_before_date => x_stud_dob_before_date,
x_deg_beyond_bachelor => x_deg_beyond_bachelor,
x_s_married => x_s_married,
x_s_have_children => x_s_have_children,
x_legal_dependents => x_legal_dependents,
x_orphan_ward_of_court => x_orphan_ward_of_court,
x_s_veteran => x_s_veteran,
x_p_marital_status => x_p_marital_status,
x_father_ssn => x_father_ssn,
x_f_last_name => x_f_last_name,
x_mother_ssn => x_mother_ssn,
x_m_last_name => x_m_last_name,
x_p_num_family_member => x_p_num_family_member,
x_p_num_in_college => x_p_num_in_college,
x_p_state_legal_residence => x_p_state_legal_residence,
x_p_state_legal_res_before_dt => x_p_state_legal_res_before_dt,
x_p_legal_res_date => x_p_legal_res_date,
x_age_older_parent => x_age_older_parent,
x_p_tax_return_status => x_p_tax_return_status,
x_p_type_tax_return => x_p_type_tax_return,
x_p_elig_1040aez => x_p_elig_1040aez,
x_p_adjusted_gross_income => x_p_adjusted_gross_income,
x_p_taxes_paid => x_p_taxes_paid,
x_p_exemptions => x_p_exemptions,
x_f_income_work => x_f_income_work,
x_m_income_work => x_m_income_work,
x_p_income_wsa => x_p_income_wsa,
x_p_income_wsb => x_p_income_wsb,
x_p_income_wsc => x_p_income_wsc,
x_p_investment_networth => x_p_investment_networth,
x_p_business_networth => x_p_business_networth,
x_p_cash_saving => x_p_cash_saving,
x_s_num_family_members => x_s_num_family_members,
x_s_num_in_college => x_s_num_in_college,
x_first_college => x_first_college,
x_first_house_plan => x_first_house_plan,
x_second_college => x_second_college,
x_second_house_plan => x_second_house_plan,
x_third_college => x_third_college,
x_third_house_plan => x_third_house_plan,
x_fourth_college => x_fourth_college,
x_fourth_house_plan => x_fourth_house_plan,
x_fifth_college => x_fifth_college,
x_fifth_house_plan => x_fifth_house_plan,
x_sixth_college => x_sixth_college,
x_sixth_house_plan => x_sixth_house_plan,
x_date_app_completed => x_date_app_completed,
x_signed_by => x_signed_by,
x_preparer_ssn => x_preparer_ssn,
x_preparer_emp_id_number => x_preparer_emp_id_number,
x_preparer_sign => x_preparer_sign,
x_transaction_receipt_date => x_transaction_receipt_date,
x_dependency_override_ind => x_dependency_override_ind,
x_faa_fedral_schl_code => x_faa_fedral_schl_code,
x_faa_adjustment => x_faa_adjustment,
x_input_record_type => x_input_record_type,
x_serial_number => x_serial_number,
x_batch_number => x_batch_number,
x_early_analysis_flag => x_early_analysis_flag,
x_app_entry_source_code => x_app_entry_source_code,
x_eti_destination_code => x_eti_destination_code,
x_reject_override_b => x_reject_override_b,
x_reject_override_n => x_reject_override_n,
x_reject_override_w => x_reject_override_w,
x_assum_override_1 => x_assum_override_1,
x_assum_override_2 => x_assum_override_2,
x_assum_override_3 => x_assum_override_3,
x_assum_override_4 => x_assum_override_4,
x_assum_override_5 => x_assum_override_5,
x_assum_override_6 => x_assum_override_6,
x_dependency_status => x_dependency_status,
x_s_email_address => x_s_email_address,
x_nslds_reason_code => x_nslds_reason_code,
x_app_receipt_date => x_app_receipt_date,
x_processed_rec_type => x_processed_rec_type,
x_hist_correction_for_tran_id => x_hist_correction_for_tran_id,
x_system_generated_indicator => x_system_generated_indicator,
x_dup_request_indicator => x_dup_request_indicator,
x_source_of_correction => x_source_of_correction,
x_p_cal_tax_status => x_p_cal_tax_status,
x_s_cal_tax_status => x_s_cal_tax_status,
x_graduate_flag => x_graduate_flag,
x_auto_zero_efc => x_auto_zero_efc,
x_efc_change_flag => x_efc_change_flag,
x_sarc_flag => x_sarc_flag,
x_simplified_need_test => x_simplified_need_test,
x_reject_reason_codes => x_reject_reason_codes,
x_select_service_match_flag => x_select_service_match_flag,
x_select_service_reg_flag => x_select_service_reg_flag,
x_ins_match_flag => x_ins_match_flag,
x_ins_verification_number => x_ins_verification_number,
x_sec_ins_match_flag => x_sec_ins_match_flag,
x_sec_ins_ver_number => x_sec_ins_ver_number,
x_ssn_match_flag => x_ssn_match_flag,
x_ssa_citizenship_flag => x_ssa_citizenship_flag,
x_ssn_date_of_death => x_ssn_date_of_death,
x_nslds_match_flag => x_nslds_match_flag,
x_va_match_flag => x_va_match_flag,
x_prisoner_match => x_prisoner_match,
x_verification_flag => x_verification_flag,
x_subsequent_app_flag => x_subsequent_app_flag,
x_app_source_site_code => x_app_source_site_code,
x_tran_source_site_code => x_tran_source_site_code,
x_drn => x_drn,
x_tran_process_date => x_tran_process_date,
x_computer_batch_number => x_computer_batch_number,
x_correction_flags => x_correction_flags,
x_highlight_flags => x_highlight_flags,
x_paid_efc => x_paid_efc,
x_primary_efc => x_primary_efc,
x_secondary_efc => x_secondary_efc,
x_fed_pell_grant_efc_type => x_fed_pell_grant_efc_type,
x_primary_efc_type => x_primary_efc_type,
x_sec_efc_type => x_sec_efc_type,
x_primary_alternate_month_1 => x_primary_alternate_month_1,
x_primary_alternate_month_2 => x_primary_alternate_month_2,
x_primary_alternate_month_3 => x_primary_alternate_month_3,
x_primary_alternate_month_4 => x_primary_alternate_month_4,
x_primary_alternate_month_5 => x_primary_alternate_month_5,
x_primary_alternate_month_6 => x_primary_alternate_month_6,
x_primary_alternate_month_7 => x_primary_alternate_month_7,
x_primary_alternate_month_8 => x_primary_alternate_month_8,
x_primary_alternate_month_10 => x_primary_alternate_month_10,
x_primary_alternate_month_11 => x_primary_alternate_month_11,
x_primary_alternate_month_12 => x_primary_alternate_month_12,
x_sec_alternate_month_1 => x_sec_alternate_month_1,
x_sec_alternate_month_2 => x_sec_alternate_month_2,
x_sec_alternate_month_3 => x_sec_alternate_month_3,
x_sec_alternate_month_4 => x_sec_alternate_month_4,
x_sec_alternate_month_5 => x_sec_alternate_month_5,
x_sec_alternate_month_6 => x_sec_alternate_month_6,
x_sec_alternate_month_7 => x_sec_alternate_month_7,
x_sec_alternate_month_8 => x_sec_alternate_month_8,
x_sec_alternate_month_10 => x_sec_alternate_month_10,
x_sec_alternate_month_11 => x_sec_alternate_month_11,
x_sec_alternate_month_12 => x_sec_alternate_month_12,
x_total_income => x_total_income,
x_allow_total_income => x_allow_total_income,
x_state_tax_allow => x_state_tax_allow,
x_employment_allow => x_employment_allow,
x_income_protection_allow => x_income_protection_allow,
x_available_income => x_available_income,
x_contribution_from_ai => x_contribution_from_ai,
x_discretionary_networth => x_discretionary_networth,
x_efc_networth => x_efc_networth,
x_asset_protect_allow => x_asset_protect_allow,
x_parents_cont_from_assets => x_parents_cont_from_assets,
x_adjusted_available_income => x_adjusted_available_income,
x_total_student_contribution => x_total_student_contribution,
x_total_parent_contribution => x_total_parent_contribution,
x_parents_contribution => x_parents_contribution,
x_student_total_income => x_student_total_income,
x_sati => x_sati,
x_sic => x_sic,
x_sdnw => x_sdnw,
x_sca => x_sca,
x_fti => x_fti,
x_secti => x_secti,
x_secati => x_secati,
x_secstx => x_secstx,
x_secea => x_secea,
x_secipa => x_secipa,
x_secai => x_secai,
x_seccai => x_seccai,
x_secdnw => x_secdnw,
x_secnw => x_secnw,
x_secapa => x_secapa,
x_secpca => x_secpca,
x_secaai => x_secaai,
x_sectsc => x_sectsc,
x_sectpc => x_sectpc,
x_secpc => x_secpc,
x_secsti => x_secsti,
x_secsic => x_secsic,
x_secsati => x_secsati,
x_secsdnw => x_secsdnw,
x_secsca => x_secsca,
x_secfti => x_secfti,
x_a_citizenship => x_a_citizenship,
x_a_student_marital_status => x_a_student_marital_status,
x_a_student_agi => x_a_student_agi,
x_a_s_us_tax_paid => x_a_s_us_tax_paid,
x_a_s_income_work => x_a_s_income_work,
x_a_spouse_income_work => x_a_spouse_income_work,
x_a_s_total_wsc => x_a_s_total_wsc,
x_a_date_of_birth => x_a_date_of_birth,
x_a_student_married => x_a_student_married,
x_a_have_children => x_a_have_children,
x_a_s_have_dependents => x_a_s_have_dependents,
x_a_va_status => x_a_va_status,
x_a_s_num_in_family => x_a_s_num_in_family,
x_a_s_num_in_college => x_a_s_num_in_college,
x_a_p_marital_status => x_a_p_marital_status,
x_a_father_ssn => x_a_father_ssn,
x_a_mother_ssn => x_a_mother_ssn,
x_a_parents_num_family => x_a_parents_num_family,
x_a_parents_num_college => x_a_parents_num_college,
x_a_parents_agi => x_a_parents_agi,
x_a_p_us_tax_paid => x_a_p_us_tax_paid,
x_a_f_work_income => x_a_f_work_income,
x_a_m_work_income => x_a_m_work_income,
x_a_p_total_wsc => x_a_p_total_wsc,
x_comment_codes => x_comment_codes,
x_sar_ack_comm_code => x_sar_ack_comm_code,
x_pell_grant_elig_flag => x_pell_grant_elig_flag,
x_reprocess_reason_code => x_reprocess_reason_code,
x_duplicate_date => x_duplicate_date,
x_isir_transaction_type => x_isir_transaction_type,
x_fedral_schl_code_indicator => x_fedral_schl_code_indicator,
x_multi_school_code_flags => x_multi_school_code_flags,
x_dup_ssn_indicator => x_dup_ssn_indicator,
x_payment_isir => x_payment_isir,
x_receipt_status => x_receipt_status,
x_isir_receipt_completed => x_isir_receipt_completed,
x_creation_date => x_last_update_date,
x_created_by => x_last_updated_by,
x_last_update_date => x_last_update_date,
x_last_updated_by => x_last_updated_by,
x_last_update_login => x_last_update_login,
x_system_record_type => X_system_record_type,
x_verif_track_flag => x_verif_track_flag,
x_active_isir => x_active_isir,
x_fafsa_data_verify_flags => x_fafsa_data_verify_flags,
x_reject_override_a => x_reject_override_a,
x_reject_override_c => x_reject_override_c,
x_parent_marital_status_date => x_parent_marital_status_date,
x_legacy_record_flag => x_legacy_record_flag,
x_father_first_name_initial => x_father_first_name_initial,
x_father_step_father_birth_dt => x_father_step_father_birth_dt,
x_mother_first_name_initial => x_mother_first_name_initial,
x_mother_step_mother_birth_dt => x_mother_step_mother_birth_dt,
x_parents_email_address_txt => x_parents_email_address_txt,
x_address_change_type => x_address_change_type,
x_cps_pushed_isir_flag => x_cps_pushed_isir_flag,
x_electronic_transaction_type => x_electronic_transaction_type,
x_sar_c_change_type => x_sar_c_change_type,
x_father_ssn_match_type => x_father_ssn_match_type,
x_mother_ssn_match_type => x_mother_ssn_match_type,
x_reject_override_g_flag => x_reject_override_g_flag,
x_dhs_verification_num_txt => x_dhs_verification_num_txt,
x_data_file_name_txt => x_data_file_name_txt,
x_message_class_txt => x_message_class_txt,
x_reject_override_3_flag => x_reject_override_3_flag,
x_reject_override_12_flag => x_reject_override_12_flag,
x_reject_override_j_flag => x_reject_override_j_flag,
x_reject_override_k_flag => x_reject_override_k_flag,
x_rejected_status_change_flag => x_rejected_status_change_flag,
x_verification_selection_flag => x_verification_selection_flag
);
x_program_update_date := old_references.program_update_date;
x_program_update_date := SYSDATE;
UPDATE igf_ap_isir_matched_all
SET
base_id = new_references.base_id,
batch_year = new_references.batch_year,
transaction_num = new_references.transaction_num,
current_ssn = new_references.current_ssn,
ssn_name_change = new_references.ssn_name_change,
original_ssn = new_references.original_ssn,
orig_name_id = new_references.orig_name_id,
last_name = new_references.last_name,
first_name = new_references.first_name,
middle_initial = new_references.middle_initial,
perm_mail_add = new_references.perm_mail_add,
perm_city = new_references.perm_city,
perm_state = new_references.perm_state,
perm_zip_code = new_references.perm_zip_code,
date_of_birth = new_references.date_of_birth,
phone_number = new_references.phone_number,
driver_license_number = new_references.driver_license_number,
driver_license_state = new_references.driver_license_state,
citizenship_status = new_references.citizenship_status,
alien_reg_number = new_references.alien_reg_number,
s_marital_status = new_references.s_marital_status,
s_marital_status_date = new_references.s_marital_status_date,
summ_enrl_status = new_references.summ_enrl_status,
fall_enrl_status = new_references.fall_enrl_status,
winter_enrl_status = new_references.winter_enrl_status,
spring_enrl_status = new_references.spring_enrl_status,
summ2_enrl_status = new_references.summ2_enrl_status,
fathers_highest_edu_level = new_references.fathers_highest_edu_level,
mothers_highest_edu_level = new_references.mothers_highest_edu_level,
s_state_legal_residence = new_references.s_state_legal_residence,
legal_residence_before_date = new_references.legal_residence_before_date,
s_legal_resd_date = new_references.s_legal_resd_date,
ss_r_u_male = new_references.ss_r_u_male,
selective_service_reg = new_references.selective_service_reg,
degree_certification = new_references.degree_certification,
grade_level_in_college = new_references.grade_level_in_college,
high_school_diploma_ged = new_references.high_school_diploma_ged,
first_bachelor_deg_by_date = new_references.first_bachelor_deg_by_date,
interest_in_loan = new_references.interest_in_loan,
interest_in_stud_employment = new_references.interest_in_stud_employment,
drug_offence_conviction = new_references.drug_offence_conviction,
s_tax_return_status = new_references.s_tax_return_status,
s_type_tax_return = new_references.s_type_tax_return,
s_elig_1040ez = new_references.s_elig_1040ez,
s_adjusted_gross_income = new_references.s_adjusted_gross_income,
s_fed_taxes_paid = new_references.s_fed_taxes_paid,
s_exemptions = new_references.s_exemptions,
s_income_from_work = new_references.s_income_from_work,
spouse_income_from_work = new_references.spouse_income_from_work,
s_toa_amt_from_wsa = new_references.s_toa_amt_from_wsa,
s_toa_amt_from_wsb = new_references.s_toa_amt_from_wsb,
s_toa_amt_from_wsc = new_references.s_toa_amt_from_wsc,
s_investment_networth = new_references.s_investment_networth,
s_busi_farm_networth = new_references.s_busi_farm_networth,
s_cash_savings = new_references.s_cash_savings,
va_months = new_references.va_months,
va_amount = new_references.va_amount,
stud_dob_before_date = new_references.stud_dob_before_date,
deg_beyond_bachelor = new_references.deg_beyond_bachelor,
s_married = new_references.s_married,
s_have_children = new_references.s_have_children,
legal_dependents = new_references.legal_dependents,
orphan_ward_of_court = new_references.orphan_ward_of_court,
s_veteran = new_references.s_veteran,
p_marital_status = new_references.p_marital_status,
father_ssn = new_references.father_ssn,
f_last_name = new_references.f_last_name,
mother_ssn = new_references.mother_ssn,
m_last_name = new_references.m_last_name,
p_num_family_member = new_references.p_num_family_member,
p_num_in_college = new_references.p_num_in_college,
p_state_legal_residence = new_references.p_state_legal_residence,
p_state_legal_res_before_dt = new_references.p_state_legal_res_before_dt,
p_legal_res_date = new_references.p_legal_res_date,
age_older_parent = new_references.age_older_parent,
p_tax_return_status = new_references.p_tax_return_status,
p_type_tax_return = new_references.p_type_tax_return,
p_elig_1040aez = new_references.p_elig_1040aez,
p_adjusted_gross_income = new_references.p_adjusted_gross_income,
p_taxes_paid = new_references.p_taxes_paid,
p_exemptions = new_references.p_exemptions,
f_income_work = new_references.f_income_work,
m_income_work = new_references.m_income_work,
p_income_wsa = new_references.p_income_wsa,
p_income_wsb = new_references.p_income_wsb,
p_income_wsc = new_references.p_income_wsc,
p_investment_networth = new_references.p_investment_networth,
p_business_networth = new_references.p_business_networth,
p_cash_saving = new_references.p_cash_saving,
s_num_family_members = new_references.s_num_family_members,
s_num_in_college = new_references.s_num_in_college,
first_college = new_references.first_college,
first_house_plan = new_references.first_house_plan,
second_college = new_references.second_college,
second_house_plan = new_references.second_house_plan,
third_college = new_references.third_college,
third_house_plan = new_references.third_house_plan,
fourth_college = new_references.fourth_college,
fourth_house_plan = new_references.fourth_house_plan,
fifth_college = new_references.fifth_college,
fifth_house_plan = new_references.fifth_house_plan,
sixth_college = new_references.sixth_college,
sixth_house_plan = new_references.sixth_house_plan,
date_app_completed = new_references.date_app_completed,
signed_by = new_references.signed_by,
preparer_ssn = new_references.preparer_ssn,
preparer_emp_id_number = new_references.preparer_emp_id_number,
preparer_sign = new_references.preparer_sign,
transaction_receipt_date = new_references.transaction_receipt_date,
dependency_override_ind = new_references.dependency_override_ind,
faa_fedral_schl_code = new_references.faa_fedral_schl_code,
faa_adjustment = new_references.faa_adjustment,
input_record_type = new_references.input_record_type,
serial_number = new_references.serial_number,
batch_number = new_references.batch_number,
early_analysis_flag = new_references.early_analysis_flag,
app_entry_source_code = new_references.app_entry_source_code,
eti_destination_code = new_references.eti_destination_code,
reject_override_b = new_references.reject_override_b,
reject_override_n = new_references.reject_override_n,
reject_override_w = new_references.reject_override_w,
assum_override_1 = new_references.assum_override_1,
assum_override_2 = new_references.assum_override_2,
assum_override_3 = new_references.assum_override_3,
assum_override_4 = new_references.assum_override_4,
assum_override_5 = new_references.assum_override_5,
assum_override_6 = new_references.assum_override_6,
dependency_status = new_references.dependency_status,
s_email_address = new_references.s_email_address,
nslds_reason_code = new_references.nslds_reason_code,
app_receipt_date = new_references.app_receipt_date,
processed_rec_type = new_references.processed_rec_type,
hist_correction_for_tran_id = new_references.hist_correction_for_tran_id,
system_generated_indicator = new_references.system_generated_indicator,
dup_request_indicator = new_references.dup_request_indicator,
source_of_correction = new_references.source_of_correction,
p_cal_tax_status = new_references.p_cal_tax_status,
s_cal_tax_status = new_references.s_cal_tax_status,
graduate_flag = new_references.graduate_flag,
auto_zero_efc = new_references.auto_zero_efc,
efc_change_flag = new_references.efc_change_flag,
sarc_flag = new_references.sarc_flag,
simplified_need_test = new_references.simplified_need_test,
reject_reason_codes = new_references.reject_reason_codes,
select_service_match_flag = new_references.select_service_match_flag,
select_service_reg_flag = new_references.select_service_reg_flag,
ins_match_flag = new_references.ins_match_flag,
sec_ins_match_flag = new_references.sec_ins_match_flag,
sec_ins_ver_number = new_references.sec_ins_ver_number,
ssn_match_flag = new_references.ssn_match_flag,
ssa_citizenship_flag = new_references.ssa_citizenship_flag,
ssn_date_of_death = new_references.ssn_date_of_death,
nslds_match_flag = new_references.nslds_match_flag,
va_match_flag = new_references.va_match_flag,
prisoner_match = new_references.prisoner_match,
verification_flag = new_references.verification_flag,
subsequent_app_flag = new_references.subsequent_app_flag,
app_source_site_code = new_references.app_source_site_code,
tran_source_site_code = new_references.tran_source_site_code,
drn = new_references.drn,
tran_process_date = new_references.tran_process_date,
computer_batch_number = new_references.computer_batch_number,
correction_flags = new_references.correction_flags,
highlight_flags = new_references.highlight_flags,
paid_efc = new_references.paid_efc,
primary_efc = new_references.primary_efc,
secondary_efc = new_references.secondary_efc,
fed_pell_grant_efc_type = new_references.fed_pell_grant_efc_type,
primary_efc_type = new_references.primary_efc_type,
sec_efc_type = new_references.sec_efc_type,
primary_alternate_month_1 = new_references.primary_alternate_month_1,
primary_alternate_month_2 = new_references.primary_alternate_month_2,
primary_alternate_month_3 = new_references.primary_alternate_month_3,
primary_alternate_month_4 = new_references.primary_alternate_month_4,
primary_alternate_month_5 = new_references.primary_alternate_month_5,
primary_alternate_month_6 = new_references.primary_alternate_month_6,
primary_alternate_month_7 = new_references.primary_alternate_month_7,
primary_alternate_month_8 = new_references.primary_alternate_month_8,
primary_alternate_month_10 = new_references.primary_alternate_month_10,
primary_alternate_month_11 = new_references.primary_alternate_month_11,
primary_alternate_month_12 = new_references.primary_alternate_month_12,
sec_alternate_month_1 = new_references.sec_alternate_month_1,
sec_alternate_month_2 = new_references.sec_alternate_month_2,
sec_alternate_month_3 = new_references.sec_alternate_month_3,
sec_alternate_month_4 = new_references.sec_alternate_month_4,
sec_alternate_month_5 = new_references.sec_alternate_month_5,
sec_alternate_month_6 = new_references.sec_alternate_month_6,
sec_alternate_month_7 = new_references.sec_alternate_month_7,
sec_alternate_month_8 = new_references.sec_alternate_month_8,
sec_alternate_month_10 = new_references.sec_alternate_month_10,
sec_alternate_month_11 = new_references.sec_alternate_month_11,
sec_alternate_month_12 = new_references.sec_alternate_month_12,
total_income = new_references.total_income,
allow_total_income = new_references.allow_total_income,
state_tax_allow = new_references.state_tax_allow,
employment_allow = new_references.employment_allow,
income_protection_allow = new_references.income_protection_allow,
available_income = new_references.available_income,
contribution_from_ai = new_references.contribution_from_ai,
discretionary_networth = new_references.discretionary_networth,
efc_networth = new_references.efc_networth,
asset_protect_allow = new_references.asset_protect_allow,
parents_cont_from_assets = new_references.parents_cont_from_assets,
adjusted_available_income = new_references.adjusted_available_income,
total_student_contribution = new_references.total_student_contribution,
total_parent_contribution = new_references.total_parent_contribution,
parents_contribution = new_references.parents_contribution,
student_total_income = new_references.student_total_income,
sati = new_references.sati,
sic = new_references.sic,
sdnw = new_references.sdnw,
sca = new_references.sca,
fti = new_references.fti,
secti = new_references.secti,
secati = new_references.secati,
secstx = new_references.secstx,
secea = new_references.secea,
secipa = new_references.secipa,
secai = new_references.secai,
seccai = new_references.seccai,
secdnw = new_references.secdnw,
secnw = new_references.secnw,
secapa = new_references.secapa,
secpca = new_references.secpca,
secaai = new_references.secaai,
sectsc = new_references.sectsc,
sectpc = new_references.sectpc,
secpc = new_references.secpc,
secsti = new_references.secsti,
secsic = new_references.secsic,
secsati = new_references.secsati,
secsdnw = new_references.secsdnw,
secsca = new_references.secsca,
secfti = new_references.secfti,
a_citizenship = new_references.a_citizenship,
a_student_marital_status = new_references.a_student_marital_status,
a_student_agi = new_references.a_student_agi,
a_s_us_tax_paid = new_references.a_s_us_tax_paid,
a_s_income_work = new_references.a_s_income_work,
a_spouse_income_work = new_references.a_spouse_income_work,
a_s_total_wsc = new_references.a_s_total_wsc,
a_date_of_birth = new_references.a_date_of_birth,
a_student_married = new_references.a_student_married,
a_have_children = new_references.a_have_children,
a_s_have_dependents = new_references.a_s_have_dependents,
a_va_status = new_references.a_va_status,
a_s_num_in_family = new_references.a_s_num_in_family,
a_s_num_in_college = new_references.a_s_num_in_college,
a_p_marital_status = new_references.a_p_marital_status,
a_father_ssn = new_references.a_father_ssn,
a_mother_ssn = new_references.a_mother_ssn,
a_parents_num_family = new_references.a_parents_num_family,
a_parents_num_college = new_references.a_parents_num_college,
a_parents_agi = new_references.a_parents_agi,
a_p_us_tax_paid = new_references.a_p_us_tax_paid,
a_f_work_income = new_references.a_f_work_income,
a_m_work_income = new_references.a_m_work_income,
a_p_total_wsc = new_references.a_p_total_wsc,
comment_codes = new_references.comment_codes,
sar_ack_comm_code = new_references.sar_ack_comm_code,
pell_grant_elig_flag = new_references.pell_grant_elig_flag,
reprocess_reason_code = new_references.reprocess_reason_code,
duplicate_date = new_references.duplicate_date,
isir_transaction_type = new_references.isir_transaction_type,
fedral_schl_code_indicator = new_references.fedral_schl_code_indicator,
multi_school_code_flags = new_references.multi_school_code_flags,
dup_ssn_indicator = new_references.dup_ssn_indicator,
payment_isir = new_references.payment_isir,
receipt_status = new_references.receipt_status,
isir_receipt_completed = new_references.isir_receipt_completed,
last_update_date = x_last_update_date,
last_updated_by = x_last_updated_by,
last_update_login = x_last_update_login ,
request_id = x_request_id,
program_id = x_program_id,
program_application_id = x_program_application_id,
program_update_date = x_program_update_date,
system_record_type = new_references.system_record_type,
verif_track_flag = new_references.verif_track_flag,
active_isir = new_references.active_isir,
fafsa_data_verify_flags = new_references.fafsa_data_verify_flags,
reject_override_a = new_references.reject_override_a,
reject_override_c = new_references.reject_override_c,
parent_marital_status_date = new_references.parent_marital_status_date,
legacy_record_flag = new_references.legacy_record_flag,
father_first_name_initial_txt = new_references.father_first_name_initial_txt,
father_step_father_birth_date = new_references.father_step_father_birth_date,
mother_first_name_initial_txt = new_references.mother_first_name_initial_txt,
mother_step_mother_birth_date = new_references.mother_step_mother_birth_date,
parents_email_address_txt = new_references.parents_email_address_txt,
address_change_type = new_references.address_change_type,
cps_pushed_isir_flag = new_references.cps_pushed_isir_flag,
electronic_transaction_type = new_references.electronic_transaction_type,
sar_c_change_type = new_references.sar_c_change_type,
father_ssn_match_type = new_references.father_ssn_match_type,
mother_ssn_match_type = new_references.mother_ssn_match_type,
reject_override_g_flag = new_references.reject_override_g_flag,
dhs_verification_num_txt = new_references.dhs_verification_num_txt,
data_file_name_txt = new_references.data_file_name_txt,
message_class_txt = new_references.message_class_txt,
reject_override_3_flag = new_references.reject_override_3_flag,
reject_override_12_flag = new_references.reject_override_12_flag,
reject_override_j_flag = new_references.reject_override_j_flag,
reject_override_k_flag = new_references.reject_override_k_flag,
rejected_status_change_flag = new_references.rejected_status_change_flag,
verification_selection_flag = new_references.verification_selection_flag
WHERE rowid = x_rowid;
END update_row;
x_selective_service_reg IN VARCHAR2,
x_degree_certification IN VARCHAR2,
x_grade_level_in_college IN VARCHAR2,
x_high_school_diploma_ged IN VARCHAR2,
x_first_bachelor_deg_by_date IN VARCHAR2,
x_interest_in_loan IN VARCHAR2,
x_interest_in_stud_employment IN VARCHAR2,
x_drug_offence_conviction IN VARCHAR2,
x_s_tax_return_status IN VARCHAR2,
x_s_type_tax_return IN VARCHAR2,
x_s_elig_1040ez IN VARCHAR2,
x_s_adjusted_gross_income IN NUMBER,
x_s_fed_taxes_paid IN NUMBER,
x_s_exemptions IN NUMBER,
x_s_income_from_work IN NUMBER,
x_spouse_income_from_work IN NUMBER,
x_s_toa_amt_from_wsa IN NUMBER,
x_s_toa_amt_from_wsb IN NUMBER,
x_s_toa_amt_from_wsc IN NUMBER,
x_s_investment_networth IN NUMBER,
x_s_busi_farm_networth IN NUMBER,
x_s_cash_savings IN NUMBER,
x_va_months IN NUMBER,
x_va_amount IN NUMBER,
x_stud_dob_before_date IN VARCHAR2,
x_deg_beyond_bachelor IN VARCHAR2,
x_s_married IN VARCHAR2,
x_s_have_children IN VARCHAR2,
x_legal_dependents IN VARCHAR2,
x_orphan_ward_of_court IN VARCHAR2,
x_s_veteran IN VARCHAR2,
x_p_marital_status IN VARCHAR2,
x_father_ssn IN VARCHAR2,
x_f_last_name IN VARCHAR2,
x_mother_ssn IN VARCHAR2,
x_m_last_name IN VARCHAR2,
x_p_num_family_member IN NUMBER,
x_p_num_in_college IN NUMBER,
x_p_state_legal_residence IN VARCHAR2,
x_p_state_legal_res_before_dt IN VARCHAR2,
x_p_legal_res_date IN DATE,
x_age_older_parent IN NUMBER,
x_p_tax_return_status IN VARCHAR2,
x_p_type_tax_return IN VARCHAR2,
x_p_elig_1040aez IN VARCHAR2,
x_p_adjusted_gross_income IN NUMBER,
x_p_taxes_paid IN NUMBER,
x_p_exemptions IN NUMBER,
x_f_income_work IN NUMBER,
x_m_income_work IN NUMBER,
x_p_income_wsa IN NUMBER,
x_p_income_wsb IN NUMBER,
x_p_income_wsc IN NUMBER,
x_p_investment_networth IN NUMBER,
x_p_business_networth IN NUMBER,
x_p_cash_saving IN NUMBER,
x_s_num_family_members IN NUMBER,
x_s_num_in_college IN NUMBER,
x_first_college IN VARCHAR2,
x_first_house_plan IN VARCHAR2,
x_second_college IN VARCHAR2,
x_second_house_plan IN VARCHAR2,
x_third_college IN VARCHAR2,
x_third_house_plan IN VARCHAR2,
x_fourth_college IN VARCHAR2,
x_fourth_house_plan IN VARCHAR2,
x_fifth_college IN VARCHAR2,
x_fifth_house_plan IN VARCHAR2,
x_sixth_college IN VARCHAR2,
x_sixth_house_plan IN VARCHAR2,
x_date_app_completed IN DATE,
x_signed_by IN VARCHAR2,
x_preparer_ssn IN VARCHAR2,
x_preparer_emp_id_number IN VARCHAR2,
x_preparer_sign IN VARCHAR2,
x_transaction_receipt_date IN DATE,
x_dependency_override_ind IN VARCHAR2,
x_faa_fedral_schl_code IN VARCHAR2,
x_faa_adjustment IN VARCHAR2,
x_input_record_type IN VARCHAR2,
x_serial_number IN NUMBER,
x_batch_number IN VARCHAR2,
x_early_analysis_flag IN VARCHAR2,
x_app_entry_source_code IN VARCHAR2,
x_eti_destination_code IN VARCHAR2,
x_reject_override_b IN VARCHAR2,
x_reject_override_n IN VARCHAR2,
x_reject_override_w IN VARCHAR2,
x_assum_override_1 IN VARCHAR2,
x_assum_override_2 IN VARCHAR2,
x_assum_override_3 IN VARCHAR2,
x_assum_override_4 IN VARCHAR2,
x_assum_override_5 IN VARCHAR2,
x_assum_override_6 IN VARCHAR2,
x_dependency_status IN VARCHAR2,
x_s_email_address IN VARCHAR2,
x_nslds_reason_code IN VARCHAR2,
x_app_receipt_date IN DATE,
x_processed_rec_type IN VARCHAR2,
x_hist_correction_for_tran_id IN NUMBER,
x_system_generated_indicator IN VARCHAR2,
x_dup_request_indicator IN VARCHAR2,
x_source_of_correction IN VARCHAR2,
x_p_cal_tax_status IN VARCHAR2,
x_s_cal_tax_status IN VARCHAR2,
x_graduate_flag IN VARCHAR2,
x_auto_zero_efc IN VARCHAR2,
x_efc_change_flag IN VARCHAR2,
x_sarc_flag IN VARCHAR2,
x_simplified_need_test IN VARCHAR2,
x_reject_reason_codes IN VARCHAR2,
x_select_service_match_flag IN VARCHAR2,
x_select_service_reg_flag IN VARCHAR2,
x_ins_match_flag IN VARCHAR2,
x_ins_verification_number IN NUMBER,
x_sec_ins_match_flag IN VARCHAR2,
x_sec_ins_ver_number IN NUMBER,
x_ssn_match_flag IN VARCHAR2,
x_ssa_citizenship_flag IN VARCHAR2,
x_ssn_date_of_death IN DATE,
x_nslds_match_flag IN VARCHAR2,
x_va_match_flag IN VARCHAR2,
x_prisoner_match IN VARCHAR2,
x_verification_flag IN VARCHAR2,
x_subsequent_app_flag IN VARCHAR2,
x_app_source_site_code IN VARCHAR2,
x_tran_source_site_code IN VARCHAR2,
x_drn IN NUMBER,
x_tran_process_date IN DATE,
x_computer_batch_number IN NUMBER,
x_correction_flags IN VARCHAR2,
x_highlight_flags IN VARCHAR2,
x_paid_efc IN NUMBER,
x_primary_efc IN NUMBER,
x_secondary_efc IN NUMBER,
x_fed_pell_grant_efc_type IN VARCHAR2,
x_primary_efc_type IN VARCHAR2,
x_sec_efc_type IN VARCHAR2,
x_primary_alternate_month_1 IN NUMBER,
x_primary_alternate_month_2 IN NUMBER,
x_primary_alternate_month_3 IN NUMBER,
x_primary_alternate_month_4 IN NUMBER,
x_primary_alternate_month_5 IN NUMBER,
x_primary_alternate_month_6 IN NUMBER,
x_primary_alternate_month_7 IN NUMBER,
x_primary_alternate_month_8 IN NUMBER,
x_primary_alternate_month_10 IN NUMBER,
x_primary_alternate_month_11 IN NUMBER,
x_primary_alternate_month_12 IN NUMBER,
x_sec_alternate_month_1 IN NUMBER,
x_sec_alternate_month_2 IN NUMBER,
x_sec_alternate_month_3 IN NUMBER,
x_sec_alternate_month_4 IN NUMBER,
x_sec_alternate_month_5 IN NUMBER,
x_sec_alternate_month_6 IN NUMBER,
x_sec_alternate_month_7 IN NUMBER,
x_sec_alternate_month_8 IN NUMBER,
x_sec_alternate_month_10 IN NUMBER,
x_sec_alternate_month_11 IN NUMBER,
x_sec_alternate_month_12 IN NUMBER,
x_total_income IN NUMBER,
x_allow_total_income IN NUMBER,
x_state_tax_allow IN NUMBER,
x_employment_allow IN NUMBER,
x_income_protection_allow IN NUMBER,
x_available_income IN NUMBER,
x_contribution_from_ai IN NUMBER,
x_discretionary_networth IN NUMBER,
x_efc_networth IN NUMBER,
x_asset_protect_allow IN NUMBER,
x_parents_cont_from_assets IN NUMBER,
x_adjusted_available_income IN NUMBER,
x_total_student_contribution IN NUMBER,
x_total_parent_contribution IN NUMBER,
x_parents_contribution IN NUMBER,
x_student_total_income IN NUMBER,
x_sati IN NUMBER,
x_sic IN NUMBER,
x_sdnw IN NUMBER,
x_sca IN NUMBER,
x_fti IN NUMBER,
x_secti IN NUMBER,
x_secati IN NUMBER,
x_secstx IN NUMBER,
x_secea IN NUMBER,
x_secipa IN NUMBER,
x_secai IN NUMBER,
x_seccai IN NUMBER,
x_secdnw IN NUMBER,
x_secnw IN NUMBER,
x_secapa IN NUMBER,
x_secpca IN NUMBER,
x_secaai IN NUMBER,
x_sectsc IN NUMBER,
x_sectpc IN NUMBER,
x_secpc IN NUMBER,
x_secsti IN NUMBER,
x_secsic IN NUMBER,
x_secsati IN NUMBER,
x_secsdnw IN NUMBER,
x_secsca IN NUMBER,
x_secfti IN NUMBER,
x_a_citizenship IN VARCHAR2,
x_a_student_marital_status IN VARCHAR2,
x_a_student_agi IN NUMBER,
x_a_s_us_tax_paid IN NUMBER,
x_a_s_income_work IN NUMBER,
x_a_spouse_income_work IN NUMBER,
x_a_s_total_wsc IN NUMBER,
x_a_date_of_birth IN VARCHAR2,
x_a_student_married IN VARCHAR2,
x_a_have_children IN VARCHAR2,
x_a_s_have_dependents IN VARCHAR2,
x_a_va_status IN VARCHAR2,
x_a_s_num_in_family IN NUMBER,
x_a_s_num_in_college IN NUMBER,
x_a_p_marital_status IN VARCHAR2,
x_a_father_ssn IN VARCHAR2,
x_a_mother_ssn IN VARCHAR2,
x_a_parents_num_family IN NUMBER,
x_a_parents_num_college IN NUMBER,
x_a_parents_agi IN NUMBER,
x_a_p_us_tax_paid IN NUMBER,
x_a_f_work_income IN NUMBER,
x_a_m_work_income IN NUMBER,
x_a_p_total_wsc IN NUMBER,
x_comment_codes IN VARCHAR2,
x_sar_ack_comm_code IN VARCHAR2,
x_pell_grant_elig_flag IN VARCHAR2,
x_reprocess_reason_code IN VARCHAR2,
x_duplicate_date IN DATE,
x_isir_transaction_type IN VARCHAR2,
x_fedral_schl_code_indicator IN VARCHAR2,
x_multi_school_code_flags IN VARCHAR2,
x_dup_ssn_indicator IN VARCHAR2,
x_payment_isir IN VARCHAR2,
x_receipt_status IN VARCHAR2,
x_isir_receipt_completed IN VARCHAR2,
x_mode IN VARCHAR2,
x_system_record_type IN VARCHAR2,
x_verif_track_flag IN VARCHAR2,
x_active_isir IN VARCHAR2,
x_fafsa_data_verify_flags IN VARCHAR2,
x_reject_override_a IN VARCHAR2,
x_reject_override_c IN VARCHAR2,
x_parent_marital_status_date IN DATE,
x_legacy_record_flag IN VARCHAR2,
x_father_first_name_initial IN VARCHAR2,
x_father_step_father_birth_dt IN DATE ,
x_mother_first_name_initial IN VARCHAR2,
x_mother_step_mother_birth_dt IN DATE ,
x_parents_email_address_txt IN VARCHAR2,
x_address_change_type IN VARCHAR2,
x_cps_pushed_isir_flag IN VARCHAR2,
x_electronic_transaction_type IN VARCHAR2,
x_sar_c_change_type IN VARCHAR2,
x_father_ssn_match_type IN VARCHAR2,
x_mother_ssn_match_type IN VARCHAR2,
x_reject_override_g_flag IN VARCHAR2,
x_dhs_verification_num_txt IN VARCHAR2,
x_data_file_name_txt IN VARCHAR2,
x_message_class_txt IN VARCHAR2,
x_reject_override_3_flag IN VARCHAR2,
x_reject_override_12_flag IN VARCHAR2,
x_reject_override_j_flag IN VARCHAR2,
x_reject_override_k_flag IN VARCHAR2,
x_rejected_status_change_flag IN VARCHAR2,
x_verification_selection_flag IN VARCHAR2
) AS
/*
|| Created By : rasingh
|| Created On : 06-DEC-2000
|| Purpose : Adds a row if there is no existing row, otherwise updates existing row in the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
CURSOR c1 IS
SELECT rowid
FROM igf_ap_isir_matched_all
WHERE isir_id = x_isir_id;
insert_row (
x_rowid,
x_isir_id,
x_base_id,
x_batch_year,
x_transaction_num,
x_current_ssn,
x_ssn_name_change,
x_original_ssn,
x_orig_name_id,
x_last_name,
x_first_name,
x_middle_initial,
x_perm_mail_add,
x_perm_city,
x_perm_state,
x_perm_zip_code,
x_date_of_birth,
x_phone_number,
x_driver_license_number,
x_driver_license_state,
x_citizenship_status,
x_alien_reg_number,
x_s_marital_status,
x_s_marital_status_date,
x_summ_enrl_status,
x_fall_enrl_status,
x_winter_enrl_status,
x_spring_enrl_status,
x_summ2_enrl_status,
x_fathers_highest_edu_level,
x_mothers_highest_edu_level,
x_s_state_legal_residence,
x_legal_residence_before_date,
x_s_legal_resd_date,
x_ss_r_u_male,
x_selective_service_reg,
x_degree_certification,
x_grade_level_in_college,
x_high_school_diploma_ged,
x_first_bachelor_deg_by_date,
x_interest_in_loan,
x_interest_in_stud_employment,
x_drug_offence_conviction,
x_s_tax_return_status,
x_s_type_tax_return,
x_s_elig_1040ez,
x_s_adjusted_gross_income,
x_s_fed_taxes_paid,
x_s_exemptions,
x_s_income_from_work,
x_spouse_income_from_work,
x_s_toa_amt_from_wsa,
x_s_toa_amt_from_wsb,
x_s_toa_amt_from_wsc,
x_s_investment_networth,
x_s_busi_farm_networth,
x_s_cash_savings,
x_va_months,
x_va_amount,
x_stud_dob_before_date,
x_deg_beyond_bachelor,
x_s_married,
x_s_have_children,
x_legal_dependents,
x_orphan_ward_of_court,
x_s_veteran,
x_p_marital_status,
x_father_ssn,
x_f_last_name,
x_mother_ssn,
x_m_last_name,
x_p_num_family_member,
x_p_num_in_college,
x_p_state_legal_residence,
x_p_state_legal_res_before_dt,
x_p_legal_res_date,
x_age_older_parent,
x_p_tax_return_status,
x_p_type_tax_return,
x_p_elig_1040aez,
x_p_adjusted_gross_income,
x_p_taxes_paid,
x_p_exemptions,
x_f_income_work,
x_m_income_work,
x_p_income_wsa,
x_p_income_wsb,
x_p_income_wsc,
x_p_investment_networth,
x_p_business_networth,
x_p_cash_saving,
x_s_num_family_members,
x_s_num_in_college,
x_first_college,
x_first_house_plan,
x_second_college,
x_second_house_plan,
x_third_college,
x_third_house_plan,
x_fourth_college,
x_fourth_house_plan,
x_fifth_college,
x_fifth_house_plan,
x_sixth_college,
x_sixth_house_plan,
x_date_app_completed,
x_signed_by,
x_preparer_ssn,
x_preparer_emp_id_number,
x_preparer_sign,
x_transaction_receipt_date,
x_dependency_override_ind,
x_faa_fedral_schl_code,
x_faa_adjustment,
x_input_record_type,
x_serial_number,
x_batch_number,
x_early_analysis_flag,
x_app_entry_source_code,
x_eti_destination_code,
x_reject_override_b,
x_reject_override_n,
x_reject_override_w,
x_assum_override_1,
x_assum_override_2,
x_assum_override_3,
x_assum_override_4,
x_assum_override_5,
x_assum_override_6,
x_dependency_status,
x_s_email_address,
x_nslds_reason_code,
x_app_receipt_date,
x_processed_rec_type,
x_hist_correction_for_tran_id,
x_system_generated_indicator,
x_dup_request_indicator,
x_source_of_correction,
x_p_cal_tax_status,
x_s_cal_tax_status,
x_graduate_flag,
x_auto_zero_efc,
x_efc_change_flag,
x_sarc_flag,
x_simplified_need_test,
x_reject_reason_codes,
x_select_service_match_flag,
x_select_service_reg_flag,
x_ins_match_flag,
x_ins_verification_number,
x_sec_ins_match_flag,
x_sec_ins_ver_number,
x_ssn_match_flag,
x_ssa_citizenship_flag,
x_ssn_date_of_death,
x_nslds_match_flag,
x_va_match_flag,
x_prisoner_match,
x_verification_flag,
x_subsequent_app_flag,
x_app_source_site_code,
x_tran_source_site_code,
x_drn,
x_tran_process_date,
x_computer_batch_number,
x_correction_flags,
x_highlight_flags,
x_paid_efc,
x_primary_efc,
x_secondary_efc,
x_fed_pell_grant_efc_type,
x_primary_efc_type,
x_sec_efc_type,
x_primary_alternate_month_1,
x_primary_alternate_month_2,
x_primary_alternate_month_3,
x_primary_alternate_month_4,
x_primary_alternate_month_5,
x_primary_alternate_month_6,
x_primary_alternate_month_7,
x_primary_alternate_month_8,
x_primary_alternate_month_10,
x_primary_alternate_month_11,
x_primary_alternate_month_12,
x_sec_alternate_month_1,
x_sec_alternate_month_2,
x_sec_alternate_month_3,
x_sec_alternate_month_4,
x_sec_alternate_month_5,
x_sec_alternate_month_6,
x_sec_alternate_month_7,
x_sec_alternate_month_8,
x_sec_alternate_month_10,
x_sec_alternate_month_11,
x_sec_alternate_month_12,
x_total_income,
x_allow_total_income,
x_state_tax_allow,
x_employment_allow,
x_income_protection_allow,
x_available_income,
x_contribution_from_ai,
x_discretionary_networth,
x_efc_networth,
x_asset_protect_allow,
x_parents_cont_from_assets,
x_adjusted_available_income,
x_total_student_contribution,
x_total_parent_contribution,
x_parents_contribution,
x_student_total_income,
x_sati,
x_sic,
x_sdnw,
x_sca,
x_fti,
x_secti,
x_secati,
x_secstx,
x_secea,
x_secipa,
x_secai,
x_seccai,
x_secdnw,
x_secnw,
x_secapa,
x_secpca,
x_secaai,
x_sectsc,
x_sectpc,
x_secpc,
x_secsti,
x_secsic,
x_secsati,
x_secsdnw,
x_secsca,
x_secfti,
x_a_citizenship,
x_a_student_marital_status,
x_a_student_agi,
x_a_s_us_tax_paid,
x_a_s_income_work,
x_a_spouse_income_work,
x_a_s_total_wsc,
x_a_date_of_birth,
x_a_student_married,
x_a_have_children,
x_a_s_have_dependents,
x_a_va_status,
x_a_s_num_in_family,
x_a_s_num_in_college,
x_a_p_marital_status,
x_a_father_ssn,
x_a_mother_ssn,
x_a_parents_num_family,
x_a_parents_num_college,
x_a_parents_agi,
x_a_p_us_tax_paid,
x_a_f_work_income,
x_a_m_work_income,
x_a_p_total_wsc,
x_comment_codes,
x_sar_ack_comm_code,
x_pell_grant_elig_flag,
x_reprocess_reason_code,
x_duplicate_date,
x_isir_transaction_type,
x_fedral_schl_code_indicator,
x_multi_school_code_flags,
x_dup_ssn_indicator,
x_payment_isir,
x_receipt_status,
x_isir_receipt_completed,
x_mode,
x_system_record_type,
x_verif_track_flag,
x_active_isir,
x_fafsa_data_verify_flags,
x_reject_override_a,
x_reject_override_c,
x_parent_marital_status_date,
x_legacy_record_flag,
x_father_first_name_initial,
x_father_step_father_birth_dt,
x_mother_first_name_initial,
x_mother_step_mother_birth_dt,
x_parents_email_address_txt,
x_address_change_type,
x_cps_pushed_isir_flag,
x_electronic_transaction_type,
x_sar_c_change_type,
x_father_ssn_match_type,
x_mother_ssn_match_type,
x_reject_override_g_flag,
x_dhs_verification_num_txt,
x_data_file_name_txt,
x_message_class_txt,
x_reject_override_3_flag,
x_reject_override_12_flag,
x_reject_override_j_flag,
x_reject_override_k_flag,
x_rejected_status_change_flag,
x_verification_selection_flag
);
update_row (
x_rowid,
x_isir_id,
x_base_id,
x_batch_year,
x_transaction_num,
x_current_ssn,
x_ssn_name_change,
x_original_ssn,
x_orig_name_id,
x_last_name,
x_first_name,
x_middle_initial,
x_perm_mail_add,
x_perm_city,
x_perm_state,
x_perm_zip_code,
x_date_of_birth,
x_phone_number,
x_driver_license_number,
x_driver_license_state,
x_citizenship_status,
x_alien_reg_number,
x_s_marital_status,
x_s_marital_status_date,
x_summ_enrl_status,
x_fall_enrl_status,
x_winter_enrl_status,
x_spring_enrl_status,
x_summ2_enrl_status,
x_fathers_highest_edu_level,
x_mothers_highest_edu_level,
x_s_state_legal_residence,
x_legal_residence_before_date,
x_s_legal_resd_date,
x_ss_r_u_male,
x_selective_service_reg,
x_degree_certification,
x_grade_level_in_college,
x_high_school_diploma_ged,
x_first_bachelor_deg_by_date,
x_interest_in_loan,
x_interest_in_stud_employment,
x_drug_offence_conviction,
x_s_tax_return_status,
x_s_type_tax_return,
x_s_elig_1040ez,
x_s_adjusted_gross_income,
x_s_fed_taxes_paid,
x_s_exemptions,
x_s_income_from_work,
x_spouse_income_from_work,
x_s_toa_amt_from_wsa,
x_s_toa_amt_from_wsb,
x_s_toa_amt_from_wsc,
x_s_investment_networth,
x_s_busi_farm_networth,
x_s_cash_savings,
x_va_months,
x_va_amount,
x_stud_dob_before_date,
x_deg_beyond_bachelor,
x_s_married,
x_s_have_children,
x_legal_dependents,
x_orphan_ward_of_court,
x_s_veteran,
x_p_marital_status,
x_father_ssn,
x_f_last_name,
x_mother_ssn,
x_m_last_name,
x_p_num_family_member,
x_p_num_in_college,
x_p_state_legal_residence,
x_p_state_legal_res_before_dt,
x_p_legal_res_date,
x_age_older_parent,
x_p_tax_return_status,
x_p_type_tax_return,
x_p_elig_1040aez,
x_p_adjusted_gross_income,
x_p_taxes_paid,
x_p_exemptions,
x_f_income_work,
x_m_income_work,
x_p_income_wsa,
x_p_income_wsb,
x_p_income_wsc,
x_p_investment_networth,
x_p_business_networth,
x_p_cash_saving,
x_s_num_family_members,
x_s_num_in_college,
x_first_college,
x_first_house_plan,
x_second_college,
x_second_house_plan,
x_third_college,
x_third_house_plan,
x_fourth_college,
x_fourth_house_plan,
x_fifth_college,
x_fifth_house_plan,
x_sixth_college,
x_sixth_house_plan,
x_date_app_completed,
x_signed_by,
x_preparer_ssn,
x_preparer_emp_id_number,
x_preparer_sign,
x_transaction_receipt_date,
x_dependency_override_ind,
x_faa_fedral_schl_code,
x_faa_adjustment,
x_input_record_type,
x_serial_number,
x_batch_number,
x_early_analysis_flag,
x_app_entry_source_code,
x_eti_destination_code,
x_reject_override_b,
x_reject_override_n,
x_reject_override_w,
x_assum_override_1,
x_assum_override_2,
x_assum_override_3,
x_assum_override_4,
x_assum_override_5,
x_assum_override_6,
x_dependency_status,
x_s_email_address,
x_nslds_reason_code,
x_app_receipt_date,
x_processed_rec_type,
x_hist_correction_for_tran_id,
x_system_generated_indicator,
x_dup_request_indicator,
x_source_of_correction,
x_p_cal_tax_status,
x_s_cal_tax_status,
x_graduate_flag,
x_auto_zero_efc,
x_efc_change_flag,
x_sarc_flag,
x_simplified_need_test,
x_reject_reason_codes,
x_select_service_match_flag,
x_select_service_reg_flag,
x_ins_match_flag,
x_ins_verification_number,
x_sec_ins_match_flag,
x_sec_ins_ver_number,
x_ssn_match_flag,
x_ssa_citizenship_flag,
x_ssn_date_of_death,
x_nslds_match_flag,
x_va_match_flag,
x_prisoner_match,
x_verification_flag,
x_subsequent_app_flag,
x_app_source_site_code,
x_tran_source_site_code,
x_drn,
x_tran_process_date,
x_computer_batch_number,
x_correction_flags,
x_highlight_flags,
x_paid_efc,
x_primary_efc,
x_secondary_efc,
x_fed_pell_grant_efc_type,
x_primary_efc_type,
x_sec_efc_type,
x_primary_alternate_month_1,
x_primary_alternate_month_2,
x_primary_alternate_month_3,
x_primary_alternate_month_4,
x_primary_alternate_month_5,
x_primary_alternate_month_6,
x_primary_alternate_month_7,
x_primary_alternate_month_8,
x_primary_alternate_month_10,
x_primary_alternate_month_11,
x_primary_alternate_month_12,
x_sec_alternate_month_1,
x_sec_alternate_month_2,
x_sec_alternate_month_3,
x_sec_alternate_month_4,
x_sec_alternate_month_5,
x_sec_alternate_month_6,
x_sec_alternate_month_7,
x_sec_alternate_month_8,
x_sec_alternate_month_10,
x_sec_alternate_month_11,
x_sec_alternate_month_12,
x_total_income,
x_allow_total_income,
x_state_tax_allow,
x_employment_allow,
x_income_protection_allow,
x_available_income,
x_contribution_from_ai,
x_discretionary_networth,
x_efc_networth,
x_asset_protect_allow,
x_parents_cont_from_assets,
x_adjusted_available_income,
x_total_student_contribution,
x_total_parent_contribution,
x_parents_contribution,
x_student_total_income,
x_sati,
x_sic,
x_sdnw,
x_sca,
x_fti,
x_secti,
x_secati,
x_secstx,
x_secea,
x_secipa,
x_secai,
x_seccai,
x_secdnw,
x_secnw,
x_secapa,
x_secpca,
x_secaai,
x_sectsc,
x_sectpc,
x_secpc,
x_secsti,
x_secsic,
x_secsati,
x_secsdnw,
x_secsca,
x_secfti,
x_a_citizenship,
x_a_student_marital_status,
x_a_student_agi,
x_a_s_us_tax_paid,
x_a_s_income_work,
x_a_spouse_income_work,
x_a_s_total_wsc,
x_a_date_of_birth,
x_a_student_married,
x_a_have_children,
x_a_s_have_dependents,
x_a_va_status,
x_a_s_num_in_family,
x_a_s_num_in_college,
x_a_p_marital_status,
x_a_father_ssn,
x_a_mother_ssn,
x_a_parents_num_family,
x_a_parents_num_college,
x_a_parents_agi,
x_a_p_us_tax_paid,
x_a_f_work_income,
x_a_m_work_income,
x_a_p_total_wsc,
x_comment_codes,
x_sar_ack_comm_code,
x_pell_grant_elig_flag,
x_reprocess_reason_code,
x_duplicate_date,
x_isir_transaction_type,
x_fedral_schl_code_indicator,
x_multi_school_code_flags,
x_dup_ssn_indicator,
x_payment_isir,
x_receipt_status,
x_isir_receipt_completed,
x_mode,
x_system_record_type,
x_verif_track_flag,
x_active_isir,
x_fafsa_data_verify_flags,
x_reject_override_a,
x_reject_override_c,
x_parent_marital_status_date,
x_legacy_record_flag,
x_father_first_name_initial,
x_father_step_father_birth_dt,
x_mother_first_name_initial,
x_mother_step_mother_birth_dt,
x_parents_email_address_txt,
x_address_change_type,
x_cps_pushed_isir_flag,
x_electronic_transaction_type,
x_sar_c_change_type ,
x_father_ssn_match_type,
x_mother_ssn_match_type,
x_reject_override_g_flag,
x_dhs_verification_num_txt,
x_data_file_name_txt,
x_message_class_txt,
x_reject_override_3_flag,
x_reject_override_12_flag,
x_reject_override_j_flag,
x_reject_override_k_flag,
x_rejected_status_change_flag,
x_verification_selection_flag
);
PROCEDURE delete_row (
x_rowid IN VARCHAR2
) AS
/*
|| Created By : rasingh
|| Created On : 06-DEC-2000
|| Purpose : Handles the DELETE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
BEGIN
before_dml (
p_action => 'DELETE',
x_rowid => x_rowid
);
DELETE FROM igf_ap_isir_matched_all
WHERE rowid = x_rowid;
END delete_row;
PROCEDURE update_row_rectype (
p_isir_matched_rectype IN igf_ap_isir_matched%ROWTYPE
) AS
/*
|| Created By : rasingh
|| Created On : 06-DEC-2000
|| Purpose : Handles the DELETE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
BEGIN
igf_ap_isir_matched_pkg.update_row(
x_Mode => 'R',
x_rowid => p_isir_matched_rectype.row_id,
x_isir_id => p_isir_matched_rectype.isir_id,
x_base_id => p_isir_matched_rectype.base_id,
x_batch_year => p_isir_matched_rectype.batch_year,
x_transaction_num => p_isir_matched_rectype.transaction_num,
x_current_ssn => p_isir_matched_rectype.current_ssn,
x_ssn_name_change => p_isir_matched_rectype.ssn_name_change,
x_original_ssn => p_isir_matched_rectype.original_ssn,
x_orig_name_id => p_isir_matched_rectype.orig_name_id,
x_last_name => p_isir_matched_rectype.last_name,
x_first_name => p_isir_matched_rectype.first_name,
x_middle_initial => p_isir_matched_rectype.middle_initial,
x_perm_mail_add => p_isir_matched_rectype.perm_mail_add,
x_perm_city => p_isir_matched_rectype.perm_city,
x_perm_state => p_isir_matched_rectype.perm_state,
x_perm_zip_code => p_isir_matched_rectype.perm_zip_code,
x_date_of_birth => p_isir_matched_rectype.date_of_birth,
x_phone_number => p_isir_matched_rectype.phone_number,
x_driver_license_number => p_isir_matched_rectype.driver_license_number,
x_driver_license_state => p_isir_matched_rectype.driver_license_state,
x_citizenship_status => p_isir_matched_rectype.citizenship_status,
x_alien_reg_number => p_isir_matched_rectype.alien_reg_number,
x_s_marital_status => p_isir_matched_rectype.s_marital_status,
x_s_marital_status_date => p_isir_matched_rectype.s_marital_status_date,
x_summ_enrl_status => p_isir_matched_rectype.summ_enrl_status,
x_fall_enrl_status => p_isir_matched_rectype.fall_enrl_status,
x_winter_enrl_status => p_isir_matched_rectype.winter_enrl_status,
x_spring_enrl_status => p_isir_matched_rectype.spring_enrl_status,
x_summ2_enrl_status => p_isir_matched_rectype.summ2_enrl_status,
x_fathers_highest_edu_level => p_isir_matched_rectype.fathers_highest_edu_level,
x_mothers_highest_edu_level => p_isir_matched_rectype.mothers_highest_edu_level,
x_s_state_legal_residence => p_isir_matched_rectype.s_state_legal_residence,
x_legal_residence_before_date => p_isir_matched_rectype.legal_residence_before_date,
x_s_legal_resd_date => p_isir_matched_rectype.s_legal_resd_date,
x_ss_r_u_male => p_isir_matched_rectype.ss_r_u_male,
x_selective_service_reg => p_isir_matched_rectype.selective_service_reg,
x_degree_certification => p_isir_matched_rectype.degree_certification,
x_grade_level_in_college => p_isir_matched_rectype.grade_level_in_college,
x_high_school_diploma_ged => p_isir_matched_rectype.high_school_diploma_ged,
x_first_bachelor_deg_by_date => p_isir_matched_rectype.first_bachelor_deg_by_date,
x_interest_in_loan => p_isir_matched_rectype.interest_in_loan,
x_interest_in_stud_employment => p_isir_matched_rectype.interest_in_stud_employment,
x_drug_offence_conviction => p_isir_matched_rectype.drug_offence_conviction,
x_s_tax_return_status => p_isir_matched_rectype.s_tax_return_status,
x_s_type_tax_return => p_isir_matched_rectype.s_type_tax_return,
x_s_elig_1040ez => p_isir_matched_rectype.s_elig_1040ez,
x_s_adjusted_gross_income => p_isir_matched_rectype.s_adjusted_gross_income,
x_s_fed_taxes_paid => p_isir_matched_rectype.s_fed_taxes_paid,
x_s_exemptions => p_isir_matched_rectype.s_exemptions,
x_s_income_from_work => p_isir_matched_rectype.s_income_from_work,
x_spouse_income_from_work => p_isir_matched_rectype.spouse_income_from_work,
x_s_toa_amt_from_wsa => p_isir_matched_rectype.s_toa_amt_from_wsa,
x_s_toa_amt_from_wsb => p_isir_matched_rectype.s_toa_amt_from_wsb,
x_s_toa_amt_from_wsc => p_isir_matched_rectype.s_toa_amt_from_wsc,
x_s_investment_networth => p_isir_matched_rectype.s_investment_networth,
x_s_busi_farm_networth => p_isir_matched_rectype.s_busi_farm_networth,
x_s_cash_savings => p_isir_matched_rectype.s_cash_savings,
x_va_months => p_isir_matched_rectype.va_months,
x_va_amount => p_isir_matched_rectype.va_amount,
x_stud_dob_before_date => p_isir_matched_rectype.stud_dob_before_date,
x_deg_beyond_bachelor => p_isir_matched_rectype.deg_beyond_bachelor,
x_s_married => p_isir_matched_rectype.s_married,
x_s_have_children => p_isir_matched_rectype.s_have_children,
x_legal_dependents => p_isir_matched_rectype.legal_dependents,
x_orphan_ward_of_court => p_isir_matched_rectype.orphan_ward_of_court,
x_s_veteran => p_isir_matched_rectype.s_veteran,
x_p_marital_status => p_isir_matched_rectype.p_marital_status,
x_father_ssn => p_isir_matched_rectype.father_ssn,
x_f_last_name => p_isir_matched_rectype.f_last_name,
x_mother_ssn => p_isir_matched_rectype.mother_ssn,
x_m_last_name => p_isir_matched_rectype.m_last_name,
x_p_num_family_member => p_isir_matched_rectype.p_num_family_member,
x_p_num_in_college => p_isir_matched_rectype.p_num_in_college,
x_p_state_legal_residence => p_isir_matched_rectype.p_state_legal_residence,
x_p_state_legal_res_before_dt => p_isir_matched_rectype.p_state_legal_res_before_dt,
x_p_legal_res_date => p_isir_matched_rectype.p_legal_res_date,
x_age_older_parent => p_isir_matched_rectype.age_older_parent,
x_p_tax_return_status => p_isir_matched_rectype.p_tax_return_status,
x_p_type_tax_return => p_isir_matched_rectype.p_type_tax_return,
x_p_elig_1040aez => p_isir_matched_rectype.p_elig_1040aez,
x_p_adjusted_gross_income => p_isir_matched_rectype.p_adjusted_gross_income,
x_p_taxes_paid => p_isir_matched_rectype.p_taxes_paid,
x_p_exemptions => p_isir_matched_rectype.p_exemptions,
x_f_income_work => p_isir_matched_rectype.f_income_work,
x_m_income_work => p_isir_matched_rectype.m_income_work,
x_p_income_wsa => p_isir_matched_rectype.p_income_wsa,
x_p_income_wsb => p_isir_matched_rectype.p_income_wsb,
x_p_income_wsc => p_isir_matched_rectype.p_income_wsc,
x_p_investment_networth => p_isir_matched_rectype.p_investment_networth,
x_p_business_networth => p_isir_matched_rectype.p_business_networth,
x_p_cash_saving => p_isir_matched_rectype.p_cash_saving,
x_s_num_family_members => p_isir_matched_rectype.s_num_family_members,
x_s_num_in_college => p_isir_matched_rectype.s_num_in_college,
x_first_college => p_isir_matched_rectype.first_college,
x_first_house_plan => p_isir_matched_rectype.first_house_plan,
x_second_college => p_isir_matched_rectype.second_college,
x_second_house_plan => p_isir_matched_rectype.second_house_plan,
x_third_college => p_isir_matched_rectype.third_college,
x_third_house_plan => p_isir_matched_rectype.third_house_plan,
x_fourth_college => p_isir_matched_rectype.fourth_college,
x_fourth_house_plan => p_isir_matched_rectype.fourth_house_plan,
x_fifth_college => p_isir_matched_rectype.fifth_college,
x_fifth_house_plan => p_isir_matched_rectype.fifth_house_plan,
x_sixth_college => p_isir_matched_rectype.sixth_college,
x_sixth_house_plan => p_isir_matched_rectype.sixth_house_plan,
x_date_app_completed => p_isir_matched_rectype.date_app_completed,
x_signed_by => p_isir_matched_rectype.signed_by,
x_preparer_ssn => p_isir_matched_rectype.preparer_ssn,
x_preparer_emp_id_number => p_isir_matched_rectype.preparer_emp_id_number,
x_preparer_sign => p_isir_matched_rectype.preparer_sign,
x_transaction_receipt_date => p_isir_matched_rectype.transaction_receipt_date,
x_dependency_override_ind => p_isir_matched_rectype.dependency_override_ind,
x_faa_fedral_schl_code => p_isir_matched_rectype.faa_fedral_schl_code,
x_faa_adjustment => p_isir_matched_rectype.faa_adjustment,
x_input_record_type => p_isir_matched_rectype.input_record_type,
x_serial_number => p_isir_matched_rectype.serial_number,
x_batch_number => p_isir_matched_rectype.batch_number,
x_early_analysis_flag => p_isir_matched_rectype.early_analysis_flag,
x_app_entry_source_code => p_isir_matched_rectype.app_entry_source_code,
x_eti_destination_code => p_isir_matched_rectype.eti_destination_code,
x_reject_override_b => p_isir_matched_rectype.reject_override_b,
x_reject_override_n => p_isir_matched_rectype.reject_override_n,
x_reject_override_w => p_isir_matched_rectype.reject_override_w,
x_assum_override_1 => p_isir_matched_rectype.assum_override_1,
x_assum_override_2 => p_isir_matched_rectype.assum_override_2,
x_assum_override_3 => p_isir_matched_rectype.assum_override_3,
x_assum_override_4 => p_isir_matched_rectype.assum_override_4,
x_assum_override_5 => p_isir_matched_rectype.assum_override_5,
x_assum_override_6 => p_isir_matched_rectype.assum_override_6,
x_dependency_status => p_isir_matched_rectype.dependency_status,
x_s_email_address => p_isir_matched_rectype.s_email_address,
x_nslds_reason_code => p_isir_matched_rectype.nslds_reason_code,
x_app_receipt_date => p_isir_matched_rectype.app_receipt_date,
x_processed_rec_type => p_isir_matched_rectype.processed_rec_type,
x_hist_correction_for_tran_id => p_isir_matched_rectype.hist_correction_for_tran_id,
x_system_generated_indicator => p_isir_matched_rectype.system_generated_indicator,
x_dup_request_indicator => p_isir_matched_rectype.dup_request_indicator,
x_source_of_correction => p_isir_matched_rectype.source_of_correction,
x_p_cal_tax_status => p_isir_matched_rectype.p_cal_tax_status,
x_s_cal_tax_status => p_isir_matched_rectype.s_cal_tax_status,
x_graduate_flag => p_isir_matched_rectype.graduate_flag,
x_auto_zero_efc => p_isir_matched_rectype.auto_zero_efc,
x_efc_change_flag => p_isir_matched_rectype.efc_change_flag,
x_sarc_flag => p_isir_matched_rectype.sarc_flag,
x_simplified_need_test => p_isir_matched_rectype.simplified_need_test,
x_reject_reason_codes => p_isir_matched_rectype.reject_reason_codes,
x_select_service_match_flag => p_isir_matched_rectype.select_service_match_flag,
x_select_service_reg_flag => p_isir_matched_rectype.select_service_reg_flag,
x_ins_match_flag => p_isir_matched_rectype.ins_match_flag,
x_ins_verification_number => p_isir_matched_rectype.ins_verification_number,
x_sec_ins_match_flag => p_isir_matched_rectype.sec_ins_match_flag,
x_sec_ins_ver_number => p_isir_matched_rectype.sec_ins_ver_number,
x_ssn_match_flag => p_isir_matched_rectype.ssn_match_flag,
x_ssa_citizenship_flag => p_isir_matched_rectype.ssa_citizenship_flag,
x_ssn_date_of_death => p_isir_matched_rectype.ssn_date_of_death,
x_nslds_match_flag => p_isir_matched_rectype.nslds_match_flag,
x_va_match_flag => p_isir_matched_rectype.va_match_flag,
x_prisoner_match => p_isir_matched_rectype.prisoner_match,
x_verification_flag => p_isir_matched_rectype.verification_flag,
x_subsequent_app_flag => p_isir_matched_rectype.subsequent_app_flag,
x_app_source_site_code => p_isir_matched_rectype.app_source_site_code,
x_tran_source_site_code => p_isir_matched_rectype.tran_source_site_code,
x_drn => p_isir_matched_rectype.drn,
x_tran_process_date => p_isir_matched_rectype.tran_process_date,
x_computer_batch_number => p_isir_matched_rectype.computer_batch_number,
x_correction_flags => p_isir_matched_rectype.correction_flags,
x_highlight_flags => p_isir_matched_rectype.highlight_flags,
x_paid_efc => p_isir_matched_rectype.paid_efc,
x_primary_efc => p_isir_matched_rectype.primary_efc,
x_secondary_efc => p_isir_matched_rectype.secondary_efc,
x_fed_pell_grant_efc_type => p_isir_matched_rectype.fed_pell_grant_efc_type,
x_primary_efc_type => p_isir_matched_rectype.primary_efc_type,
x_sec_efc_type => p_isir_matched_rectype.sec_efc_type,
x_primary_alternate_month_1 => p_isir_matched_rectype.primary_alternate_month_1,
x_primary_alternate_month_2 => p_isir_matched_rectype.primary_alternate_month_2,
x_primary_alternate_month_3 => p_isir_matched_rectype.primary_alternate_month_3,
x_primary_alternate_month_4 => p_isir_matched_rectype.primary_alternate_month_4,
x_primary_alternate_month_5 => p_isir_matched_rectype.primary_alternate_month_5,
x_primary_alternate_month_6 => p_isir_matched_rectype.primary_alternate_month_6,
x_primary_alternate_month_7 => p_isir_matched_rectype.primary_alternate_month_7,
x_primary_alternate_month_8 => p_isir_matched_rectype.primary_alternate_month_8,
x_primary_alternate_month_10 => p_isir_matched_rectype.primary_alternate_month_10,
x_primary_alternate_month_11 => p_isir_matched_rectype.primary_alternate_month_11,
x_primary_alternate_month_12 => p_isir_matched_rectype.primary_alternate_month_12,
x_sec_alternate_month_1 => p_isir_matched_rectype.sec_alternate_month_1,
x_sec_alternate_month_2 => p_isir_matched_rectype.sec_alternate_month_2,
x_sec_alternate_month_3 => p_isir_matched_rectype.sec_alternate_month_3,
x_sec_alternate_month_4 => p_isir_matched_rectype.sec_alternate_month_4,
x_sec_alternate_month_5 => p_isir_matched_rectype.sec_alternate_month_5,
x_sec_alternate_month_6 => p_isir_matched_rectype.sec_alternate_month_6,
x_sec_alternate_month_7 => p_isir_matched_rectype.sec_alternate_month_7,
x_sec_alternate_month_8 => p_isir_matched_rectype.sec_alternate_month_8,
x_sec_alternate_month_10 => p_isir_matched_rectype.sec_alternate_month_10,
x_sec_alternate_month_11 => p_isir_matched_rectype.sec_alternate_month_11,
x_sec_alternate_month_12 => p_isir_matched_rectype.sec_alternate_month_12,
x_total_income => p_isir_matched_rectype.total_income,
x_allow_total_income => p_isir_matched_rectype.allow_total_income,
x_state_tax_allow => p_isir_matched_rectype.state_tax_allow,
x_employment_allow => p_isir_matched_rectype.employment_allow,
x_income_protection_allow => p_isir_matched_rectype.income_protection_allow,
x_available_income => p_isir_matched_rectype.available_income,
x_contribution_from_ai => p_isir_matched_rectype.contribution_from_ai,
x_discretionary_networth => p_isir_matched_rectype.discretionary_networth,
x_efc_networth => p_isir_matched_rectype.efc_networth,
x_asset_protect_allow => p_isir_matched_rectype.asset_protect_allow,
x_parents_cont_from_assets => p_isir_matched_rectype.parents_cont_from_assets,
x_adjusted_available_income => p_isir_matched_rectype.adjusted_available_income,
x_total_student_contribution => p_isir_matched_rectype.total_student_contribution,
x_total_parent_contribution => p_isir_matched_rectype.total_parent_contribution,
x_parents_contribution => p_isir_matched_rectype.parents_contribution,
x_student_total_income => p_isir_matched_rectype.student_total_income,
x_sati => p_isir_matched_rectype.sati,
x_sic => p_isir_matched_rectype.sic,
x_sdnw => p_isir_matched_rectype.sdnw,
x_sca => p_isir_matched_rectype.sca,
x_fti => p_isir_matched_rectype.fti,
x_secti => p_isir_matched_rectype.secti,
x_secati => p_isir_matched_rectype.secati,
x_secstx => p_isir_matched_rectype.secstx,
x_secea => p_isir_matched_rectype.secea,
x_secipa => p_isir_matched_rectype.secipa,
x_secai => p_isir_matched_rectype.secai,
x_seccai => p_isir_matched_rectype.seccai,
x_secdnw => p_isir_matched_rectype.secdnw,
x_secnw => p_isir_matched_rectype.secnw,
x_secapa => p_isir_matched_rectype.secapa,
x_secpca => p_isir_matched_rectype.secpca,
x_secaai => p_isir_matched_rectype.secaai,
x_sectsc => p_isir_matched_rectype.sectsc,
x_sectpc => p_isir_matched_rectype.sectpc,
x_secpc => p_isir_matched_rectype.secpc,
x_secsti => p_isir_matched_rectype.secsti,
x_secsic => p_isir_matched_rectype.secsic,
x_secsati => p_isir_matched_rectype.secsati,
x_secsdnw => p_isir_matched_rectype.secsdnw,
x_secsca => p_isir_matched_rectype.secsca,
x_secfti => p_isir_matched_rectype.secfti,
x_a_citizenship => p_isir_matched_rectype.a_citizenship,
x_a_student_marital_status => p_isir_matched_rectype.a_student_marital_status,
x_a_student_agi => p_isir_matched_rectype.a_student_agi,
x_a_s_us_tax_paid => p_isir_matched_rectype.a_s_us_tax_paid,
x_a_s_income_work => p_isir_matched_rectype.a_s_income_work,
x_a_spouse_income_work => p_isir_matched_rectype.a_spouse_income_work,
x_a_s_total_wsc => p_isir_matched_rectype.a_s_total_wsc,
x_a_date_of_birth => p_isir_matched_rectype.a_date_of_birth,
x_a_student_married => p_isir_matched_rectype.a_student_married,
x_a_have_children => p_isir_matched_rectype.a_have_children,
x_a_s_have_dependents => p_isir_matched_rectype.a_s_have_dependents,
x_a_va_status => p_isir_matched_rectype.a_va_status,
x_a_s_num_in_family => p_isir_matched_rectype.a_s_num_in_family,
x_a_s_num_in_college => p_isir_matched_rectype.a_s_num_in_college,
x_a_p_marital_status => p_isir_matched_rectype.a_p_marital_status,
x_a_father_ssn => p_isir_matched_rectype.a_father_ssn,
x_a_mother_ssn => p_isir_matched_rectype.a_mother_ssn,
x_a_parents_num_family => p_isir_matched_rectype.a_parents_num_family,
x_a_parents_num_college => p_isir_matched_rectype.a_parents_num_college,
x_a_parents_agi => p_isir_matched_rectype.a_parents_agi,
x_a_p_us_tax_paid => p_isir_matched_rectype.a_p_us_tax_paid,
x_a_f_work_income => p_isir_matched_rectype.a_f_work_income,
x_a_m_work_income => p_isir_matched_rectype.a_m_work_income,
x_a_p_total_wsc => p_isir_matched_rectype.a_p_total_wsc,
x_comment_codes => p_isir_matched_rectype.comment_codes,
x_sar_ack_comm_code => p_isir_matched_rectype.sar_ack_comm_code,
x_pell_grant_elig_flag => p_isir_matched_rectype.pell_grant_elig_flag,
x_reprocess_reason_code => p_isir_matched_rectype.reprocess_reason_code,
x_duplicate_date => p_isir_matched_rectype.duplicate_date,
x_isir_transaction_type => p_isir_matched_rectype.isir_transaction_type,
x_fedral_schl_code_indicator => p_isir_matched_rectype.fedral_schl_code_indicator,
x_multi_school_code_flags => p_isir_matched_rectype.multi_school_code_flags,
x_dup_ssn_indicator => p_isir_matched_rectype.dup_ssn_indicator,
x_system_record_type => p_isir_matched_rectype.system_record_type,
x_verif_track_flag => p_isir_matched_rectype.verif_track_flag,
x_payment_isir => p_isir_matched_rectype.payment_isir,
x_receipt_status => p_isir_matched_rectype.receipt_status,
x_isir_receipt_completed => p_isir_matched_rectype.isir_receipt_completed,
x_active_isir => p_isir_matched_rectype.active_isir,
x_fafsa_data_verify_flags => p_isir_matched_rectype.fafsa_data_verify_flags,
x_reject_override_a => p_isir_matched_rectype.reject_override_a,
x_reject_override_c => p_isir_matched_rectype.reject_override_c,
x_parent_marital_status_date => p_isir_matched_rectype.parent_marital_status_date,
x_legacy_record_flag => p_isir_matched_rectype.legacy_record_flag,
x_father_first_name_initial => p_isir_matched_rectype.father_first_name_initial_txt,
x_father_step_father_birth_dt => p_isir_matched_rectype.father_step_father_birth_date,
x_mother_first_name_initial => p_isir_matched_rectype.mother_first_name_initial_txt,
x_mother_step_mother_birth_dt => p_isir_matched_rectype.mother_step_mother_birth_date,
x_parents_email_address_txt => p_isir_matched_rectype.parents_email_address_txt,
x_address_change_type => p_isir_matched_rectype.address_change_type,
x_cps_pushed_isir_flag => p_isir_matched_rectype.cps_pushed_isir_flag,
x_electronic_transaction_type => p_isir_matched_rectype.electronic_transaction_type,
x_sar_c_change_type => p_isir_matched_rectype.sar_c_change_type,
x_father_ssn_match_type => p_isir_matched_rectype.father_ssn_match_type,
x_mother_ssn_match_type => p_isir_matched_rectype.mother_ssn_match_type,
x_reject_override_g_flag => p_isir_matched_rectype.reject_override_g_flag,
x_dhs_verification_num_txt => p_isir_matched_rectype.dhs_verification_num_txt,
x_data_file_name_txt => p_isir_matched_rectype.data_file_name_txt,
x_message_class_txt => p_isir_matched_rectype.message_class_txt,
x_reject_override_3_flag => p_isir_matched_rectype.reject_override_3_flag,
x_reject_override_12_flag => p_isir_matched_rectype.reject_override_12_flag,
x_reject_override_j_flag => p_isir_matched_rectype.reject_override_j_flag,
x_reject_override_k_flag => p_isir_matched_rectype.reject_override_k_flag,
x_rejected_status_change_flag => p_isir_matched_rectype.rejected_status_change_flag,
x_verification_selection_flag => p_isir_matched_rectype.verification_selection_flag
);
END update_row_rectype;