[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_last_update_date IN DATE DEFAULT NULL,
x_last_updated_by IN NUMBER DEFAULT NULL,
x_last_update_login IN NUMBER DEFAULT NULL,
x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
x_opt_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
x_opt_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
x_opt_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
x_opt_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
x_opt_par_cola_adj_value IN NUMBER DEFAULT NULL,
x_legacy_record_flag IN VARCHAR2,
x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
x_cust_parent_cont_adj_num IN NUMBER DEFAULT NULL,
x_custodial_parent_num IN NUMBER DEFAULT NULL,
x_cust_par_base_prcnt_inc_amt IN NUMBER DEFAULT NULL,
x_cust_par_base_cont_inc_amt IN NUMBER DEFAULT NULL,
x_cust_par_base_cont_ast_amt IN NUMBER DEFAULT NULL,
x_cust_par_base_tot_cont_amt IN NUMBER DEFAULT NULL,
x_cust_par_opt_prcnt_inc_amt IN NUMBER DEFAULT NULL,
x_cust_par_opt_cont_inc_amt IN NUMBER DEFAULT NULL,
x_cust_par_opt_cont_ast_amt IN NUMBER DEFAULT NULL,
x_cust_par_opt_tot_cont_amt IN NUMBER DEFAULT NULL,
x_parents_email_txt IN VARCHAR2 DEFAULT NULL,
x_parent_1_birth_date IN DATE DEFAULT NULL,
x_parent_2_birth_date IN DATE DEFAULT NULL
) AS
/*
|| Created By : vivuyyur
|| Created On : 30-MAY-2001
|| 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_CSS_FNAR_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');
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;
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
SELECT rowid
FROM igf_ap_css_fnar_all
WHERE fnar_id = x_fnar_id
FOR UPDATE NOWAIT;
SELECT rowid
FROM igf_ap_css_fnar_all
WHERE ((cssp_id = x_cssp_id));
x_last_update_date IN DATE DEFAULT NULL,
x_last_updated_by IN NUMBER DEFAULT NULL,
x_last_update_login IN NUMBER DEFAULT NULL,
x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
x_opt_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
x_opt_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
x_opt_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
x_opt_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
x_opt_par_cola_adj_value IN NUMBER DEFAULT NULL,
x_legacy_record_flag IN VARCHAR2,
x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
x_cust_parent_cont_adj_num IN NUMBER DEFAULT NULL,
x_custodial_parent_num IN NUMBER DEFAULT NULL,
x_cust_par_base_prcnt_inc_amt IN NUMBER DEFAULT NULL,
x_cust_par_base_cont_inc_amt IN NUMBER DEFAULT NULL,
x_cust_par_base_cont_ast_amt IN NUMBER DEFAULT NULL,
x_cust_par_base_tot_cont_amt IN NUMBER DEFAULT NULL,
x_cust_par_opt_prcnt_inc_amt IN NUMBER DEFAULT NULL,
x_cust_par_opt_cont_inc_amt IN NUMBER DEFAULT NULL,
x_cust_par_opt_cont_ast_amt IN NUMBER DEFAULT NULL,
x_cust_par_opt_tot_cont_amt IN NUMBER DEFAULT NULL,
x_parents_email_txt IN VARCHAR2 DEFAULT NULL,
x_parent_1_birth_date IN DATE DEFAULT NULL,
x_parent_2_birth_date IN DATE DEFAULT NULL
) AS
/*
|| Created By : vivuyyur
|| Created On : 30-MAY-2001
|| 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_fnar_id,
x_cssp_id,
x_r_s_email_address,
x_eps_code,
x_comp_css_dependency_status,
x_stu_age,
x_assumed_stu_yr_in_coll,
x_comp_stu_marital_status,
x_stu_family_members,
x_stu_fam_members_in_college,
x_par_marital_status,
x_par_family_members,
x_par_total_in_college,
x_par_par_in_college,
x_par_others_in_college,
x_par_aesa,
x_par_cesa,
x_stu_aesa,
x_stu_cesa,
x_im_p_bas_agi_taxable_income,
x_im_p_bas_untx_inc_and_ben,
x_im_p_bas_inc_adj,
x_im_p_bas_total_income,
x_im_p_bas_us_income_tax,
x_im_p_bas_st_and_other_tax,
x_im_p_bas_fica_tax,
x_im_p_bas_med_dental,
x_im_p_bas_employment_allow,
x_im_p_bas_annual_ed_savings,
x_im_p_bas_inc_prot_allow_m,
x_im_p_bas_total_inc_allow,
x_im_p_bas_cal_avail_inc,
x_im_p_bas_avail_income,
x_im_p_bas_total_cont_inc,
x_im_p_bas_cash_bank_accounts,
x_im_p_bas_home_equity,
x_im_p_bas_ot_rl_est_inv_eq,
x_im_p_bas_adj_bus_farm_worth,
x_im_p_bas_ass_sibs_pre_tui,
x_im_p_bas_net_worth,
x_im_p_bas_emerg_res_allow,
x_im_p_bas_cum_ed_savings,
x_im_p_bas_low_inc_allow,
x_im_p_bas_total_asset_allow,
x_im_p_bas_disc_net_worth,
x_im_p_bas_total_cont_asset,
x_im_p_bas_total_cont,
x_im_p_bas_num_in_coll_adj,
x_im_p_bas_cont_for_stu,
x_im_p_bas_cont_from_income,
x_im_p_bas_cont_from_assets,
x_im_p_opt_agi_taxable_income,
x_im_p_opt_untx_inc_and_ben,
x_im_p_opt_inc_adj,
x_im_p_opt_total_income,
x_im_p_opt_us_income_tax,
x_im_p_opt_st_and_other_tax,
x_im_p_opt_fica_tax,
x_im_p_opt_med_dental,
x_im_p_opt_elem_sec_tuit,
x_im_p_opt_employment_allow,
x_im_p_opt_annual_ed_savings,
x_im_p_opt_inc_prot_allow_m,
x_im_p_opt_total_inc_allow,
x_im_p_opt_cal_avail_inc,
x_im_p_opt_avail_income,
x_im_p_opt_total_cont_inc,
x_im_p_opt_cash_bank_accounts,
x_im_p_opt_home_equity,
x_im_p_opt_ot_rl_est_inv_eq,
x_im_p_opt_adj_bus_farm_worth,
x_im_p_opt_ass_sibs_pre_tui,
x_im_p_opt_net_worth,
x_im_p_opt_emerg_res_allow,
x_im_p_opt_cum_ed_savings,
x_im_p_opt_low_inc_allow,
x_im_p_opt_total_asset_allow,
x_im_p_opt_disc_net_worth,
x_im_p_opt_total_cont_asset,
x_im_p_opt_total_cont,
x_im_p_opt_num_in_coll_adj,
x_im_p_opt_cont_for_stu,
x_im_p_opt_cont_from_income,
x_im_p_opt_cont_from_assets,
x_fm_p_analysis_type,
x_fm_p_agi_taxable_income,
x_fm_p_untx_inc_and_ben,
x_fm_p_inc_adj,
x_fm_p_total_income,
x_fm_p_us_income_tax,
x_fm_p_state_and_other_taxes,
x_fm_p_fica_tax,
x_fm_p_employment_allow,
x_fm_p_income_prot_allow,
x_fm_p_total_allow,
x_fm_p_avail_income,
x_fm_p_cash_bank_accounts,
x_fm_p_ot_rl_est_inv_equity,
x_fm_p_adj_bus_farm_net_worth,
x_fm_p_net_worth,
x_fm_p_asset_prot_allow,
x_fm_p_disc_net_worth,
x_fm_p_total_contribution,
x_fm_p_num_in_coll,
x_fm_p_cont_for_stu,
x_fm_p_cont_from_income,
x_fm_p_cont_from_assets,
x_im_s_bas_agi_taxable_income,
x_im_s_bas_untx_inc_and_ben,
x_im_s_bas_inc_adj,
x_im_s_bas_total_income,
x_im_s_bas_us_income_tax,
x_im_s_bas_state_and_oth_taxes,
x_im_s_bas_fica_tax,
x_im_s_bas_med_dental,
x_im_s_bas_employment_allow,
x_im_s_bas_annual_ed_savings,
x_im_s_bas_inc_prot_allow_m,
x_im_s_bas_total_inc_allow,
x_im_s_bas_cal_avail_income,
x_im_s_bas_avail_income,
x_im_s_bas_total_cont_inc,
x_im_s_bas_cash_bank_accounts,
x_im_s_bas_home_equity,
x_im_s_bas_ot_rl_est_inv_eq,
x_im_s_bas_adj_busfarm_worth,
x_im_s_bas_trusts,
x_im_s_bas_net_worth,
x_im_s_bas_emerg_res_allow,
x_im_s_bas_cum_ed_savings,
x_im_s_bas_total_asset_allow,
x_im_s_bas_disc_net_worth,
x_im_s_bas_total_cont_asset,
x_im_s_bas_total_cont,
x_im_s_bas_num_in_coll_adj,
x_im_s_bas_cont_for_stu,
x_im_s_bas_cont_from_income,
x_im_s_bas_cont_from_assets,
x_im_s_est_agitaxable_income,
x_im_s_est_untx_inc_and_ben,
x_im_s_est_inc_adj,
x_im_s_est_total_income,
x_im_s_est_us_income_tax,
x_im_s_est_state_and_oth_taxes,
x_im_s_est_fica_tax,
x_im_s_est_med_dental,
x_im_s_est_employment_allow,
x_im_s_est_annual_ed_savings,
x_im_s_est_inc_prot_allow_m,
x_im_s_est_total_inc_allow,
x_im_s_est_cal_avail_income,
x_im_s_est_avail_income,
x_im_s_est_total_cont_inc,
x_im_s_est_cash_bank_accounts,
x_im_s_est_home_equity,
x_im_s_est_ot_rl_est_inv_eq,
x_im_s_est_adj_bus_farm_worth,
x_im_s_est_est_trusts,
x_im_s_est_net_worth,
x_im_s_est_emerg_res_allow,
x_im_s_est_cum_ed_savings,
x_im_s_est_total_asset_allow,
x_im_s_est_disc_net_worth,
x_im_s_est_total_cont_asset,
x_im_s_est_total_cont,
x_im_s_est_num_in_coll_adj,
x_im_s_est_cont_for_stu,
x_im_s_est_cont_from_income,
x_im_s_est_cont_from_assets,
x_im_s_opt_agi_taxable_income,
x_im_s_opt_untx_inc_and_ben,
x_im_s_opt_inc_adj,
x_im_s_opt_total_income,
x_im_s_opt_us_income_tax,
x_im_s_opt_state_and_oth_taxes,
x_im_s_opt_fica_tax,
x_im_s_opt_med_dental,
x_im_s_opt_employment_allow,
x_im_s_opt_annual_ed_savings,
x_im_s_opt_inc_prot_allow_m,
x_im_s_opt_total_inc_allow,
x_im_s_opt_cal_avail_income,
x_im_s_opt_avail_income,
x_im_s_opt_total_cont_inc,
x_im_s_opt_cash_bank_accounts,
x_im_s_opt_ira_keogh_accounts,
x_im_s_opt_home_equity,
x_im_s_opt_ot_rl_est_inv_eq,
x_im_s_opt_adj_bus_farm_worth,
x_im_s_opt_trusts,
x_im_s_opt_net_worth,
x_im_s_opt_emerg_res_allow,
x_im_s_opt_cum_ed_savings,
x_im_s_opt_total_asset_allow,
x_im_s_opt_disc_net_worth,
x_im_s_opt_total_cont_asset,
x_im_s_opt_total_cont,
x_im_s_opt_num_in_coll_adj,
x_im_s_opt_cont_for_stu,
x_im_s_opt_cont_from_income,
x_im_s_opt_cont_from_assets,
x_fm_s_analysis_type,
x_fm_s_agi_taxable_income,
x_fm_s_untx_inc_and_ben,
x_fm_s_inc_adj,
x_fm_s_total_income,
x_fm_s_us_income_tax,
x_fm_s_state_and_oth_taxes,
x_fm_s_fica_tax,
x_fm_s_employment_allow,
x_fm_s_income_prot_allow,
x_fm_s_total_allow,
x_fm_s_cal_avail_income,
x_fm_s_avail_income,
x_fm_s_cash_bank_accounts,
x_fm_s_ot_rl_est_inv_equity,
x_fm_s_adj_bus_farm_worth,
x_fm_s_trusts,
x_fm_s_net_worth,
x_fm_s_asset_prot_allow,
x_fm_s_disc_net_worth,
x_fm_s_total_cont,
x_fm_s_num_in_coll,
x_fm_s_cont_for_stu,
x_fm_s_cont_from_income,
x_fm_s_cont_from_assets,
x_im_inst_resident_ind,
x_institutional_1_budget_name,
x_im_inst_1_budget_duration,
x_im_inst_1_tuition_fees,
x_im_inst_1_books_supplies,
x_im_inst_1_living_expenses,
x_im_inst_1_tot_expenses,
x_im_inst_1_tot_stu_cont,
x_im_inst_1_tot_par_cont,
x_im_inst_1_tot_family_cont,
x_im_inst_1_va_benefits,
x_im_inst_1_ot_cont,
x_im_inst_1_est_financial_need,
x_institutional_2_budget_name,
x_im_inst_2_budget_duration,
x_im_inst_2_tuition_fees,
x_im_inst_2_books_supplies,
x_im_inst_2_living_expenses,
x_im_inst_2_tot_expenses,
x_im_inst_2_tot_stu_cont,
x_im_inst_2_tot_par_cont,
x_im_inst_2_tot_family_cont,
x_im_inst_2_va_benefits,
x_im_inst_2_est_financial_need,
x_institutional_3_budget_name,
x_im_inst_3_budget_duration,
x_im_inst_3_tuition_fees,
x_im_inst_3_books_supplies,
x_im_inst_3_living_expenses,
x_im_inst_3_tot_expenses,
x_im_inst_3_tot_stu_cont,
x_im_inst_3_tot_par_cont,
x_im_inst_3_tot_family_cont,
x_im_inst_3_va_benefits,
x_im_inst_3_est_financial_need,
x_fm_inst_1_federal_efc,
x_fm_inst_1_va_benefits,
x_fm_inst_1_fed_eligibility,
x_fm_inst_1_pell,
x_option_par_loss_allow_ind,
x_option_par_tuition_ind,
x_option_par_home_ind,
x_option_par_home_value,
x_option_par_home_debt,
x_option_stu_ira_keogh_ind,
x_option_stu_home_ind,
x_option_stu_home_value,
x_option_stu_home_debt,
x_option_stu_sum_ay_inc_ind,
x_option_par_hope_ll_credit,
x_option_stu_hope_ll_credit,
x_im_parent_1_8_months_bas,
x_im_p_more_than_9_mth_ba,
x_im_parent_1_8_months_opt,
x_im_p_more_than_9_mth_op,
x_fnar_message_1,
x_fnar_message_2,
x_fnar_message_3,
x_fnar_message_4,
x_fnar_message_5,
x_fnar_message_6,
x_fnar_message_7,
x_fnar_message_8,
x_fnar_message_9,
x_fnar_message_10,
x_fnar_message_11,
x_fnar_message_12,
x_fnar_message_13,
x_fnar_message_20,
x_fnar_message_21,
x_fnar_message_22,
x_fnar_message_23,
x_fnar_message_24,
x_fnar_message_25,
x_fnar_message_26,
x_fnar_message_27,
x_fnar_message_30,
x_fnar_message_31,
x_fnar_message_32,
x_fnar_message_33,
x_fnar_message_34,
x_fnar_message_35,
x_fnar_message_36,
x_fnar_message_37,
x_fnar_message_38,
x_fnar_message_39,
x_fnar_message_45,
x_fnar_message_46,
x_fnar_message_47,
x_fnar_message_48,
x_fnar_message_50,
x_fnar_message_51,
x_fnar_message_52,
x_fnar_message_53,
x_fnar_message_56,
x_fnar_message_57,
x_fnar_message_58,
x_fnar_message_59,
x_fnar_message_60,
x_fnar_message_61,
x_fnar_message_62,
x_fnar_message_63,
x_fnar_message_64,
x_fnar_message_65,
x_fnar_message_71,
x_fnar_message_72,
x_fnar_message_73,
x_fnar_message_74,
x_fnar_message_75,
x_fnar_message_76,
x_fnar_message_77,
x_fnar_message_78,
x_fnar_mesg_10_stu_fam_mem,
x_fnar_mesg_11_stu_no_in_coll,
x_fnar_mesg_24_stu_avail_inc,
x_fnar_mesg_26_stu_taxes,
x_fnar_mesg_33_stu_home_value,
x_fnar_mesg_34_stu_home_value,
x_fnar_mesg_34_stu_home_equity,
x_fnar_mesg_35_stu_home_value,
x_fnar_mesg_35_stu_home_equity,
x_fnar_mesg_36_stu_home_equity,
x_fnar_mesg_48_par_fam_mem,
x_fnar_mesg_49_par_no_in_coll,
x_fnar_mesg_56_par_agi,
x_fnar_mesg_62_par_taxes,
x_fnar_mesg_73_par_home_value,
x_fnar_mesg_74_par_home_value,
x_fnar_mesg_74_par_home_equity,
x_fnar_mesg_75_par_home_value,
x_fnar_mesg_75_par_home_equity,
x_fnar_mesg_76_par_home_equity,
x_assumption_message_1,
x_assumption_message_2,
x_assumption_message_3,
x_assumption_message_4,
x_assumption_message_5,
x_assumption_message_6,
x_record_mark,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_fnar_message_55,
x_fnar_message_49,
x_opt_par_cola_adj_ind,
x_opt_par_stu_fa_assets_ind,
x_opt_par_ipt_assets_ind,
x_opt_stu_ipt_assets_ind,
x_opt_par_cola_adj_value ,
x_legacy_record_flag,
x_opt_ind_stu_ipt_assets_flag,
x_cust_parent_cont_adj_num,
x_custodial_parent_num,
x_cust_par_base_prcnt_inc_amt,
x_cust_par_base_cont_inc_amt,
x_cust_par_base_cont_ast_amt,
x_cust_par_base_tot_cont_amt,
x_cust_par_opt_prcnt_inc_amt,
x_cust_par_opt_cont_inc_amt,
x_cust_par_opt_cont_ast_amt,
x_cust_par_opt_tot_cont_amt,
x_parents_email_txt,
x_parent_1_birth_date,
x_parent_2_birth_date
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation(
new_references.fnar_id
)
) THEN
fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to Before Update.
check_parent_existance;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation (
new_references.fnar_id
)
) THEN
fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
PROCEDURE insert_row (
x_rowid IN OUT NOCOPY VARCHAR2,
x_fnar_id IN OUT NOCOPY NUMBER,
x_cssp_id IN NUMBER,
x_r_s_email_address IN VARCHAR2,
x_eps_code IN VARCHAR2,
x_comp_css_dependency_status IN VARCHAR2,
x_stu_age IN VARCHAR2,
x_assumed_stu_yr_in_coll IN VARCHAR2,
x_comp_stu_marital_status IN VARCHAR2,
x_stu_family_members IN NUMBER,
x_stu_fam_members_in_college IN NUMBER,
x_par_marital_status IN VARCHAR2,
x_par_family_members IN NUMBER,
x_par_total_in_college IN NUMBER,
x_par_par_in_college IN NUMBER,
x_par_others_in_college IN NUMBER,
x_par_aesa IN NUMBER,
x_par_cesa IN NUMBER,
x_stu_aesa IN NUMBER,
x_stu_cesa IN NUMBER,
x_im_p_bas_agi_taxable_income IN NUMBER,
x_im_p_bas_untx_inc_and_ben IN NUMBER,
x_im_p_bas_inc_adj IN NUMBER,
x_im_p_bas_total_income IN NUMBER,
x_im_p_bas_us_income_tax IN NUMBER,
x_im_p_bas_st_and_other_tax IN NUMBER,
x_im_p_bas_fica_tax IN NUMBER,
x_im_p_bas_med_dental IN NUMBER,
x_im_p_bas_employment_allow IN NUMBER,
x_im_p_bas_annual_ed_savings IN NUMBER,
x_im_p_bas_inc_prot_allow_m IN NUMBER,
x_im_p_bas_total_inc_allow IN NUMBER,
x_im_p_bas_cal_avail_inc IN NUMBER,
x_im_p_bas_avail_income IN NUMBER,
x_im_p_bas_total_cont_inc IN NUMBER,
x_im_p_bas_cash_bank_accounts IN NUMBER,
x_im_p_bas_home_equity IN NUMBER,
x_im_p_bas_ot_rl_est_inv_eq IN NUMBER,
x_im_p_bas_adj_bus_farm_worth IN NUMBER,
x_im_p_bas_ass_sibs_pre_tui IN NUMBER,
x_im_p_bas_net_worth IN NUMBER,
x_im_p_bas_emerg_res_allow IN NUMBER,
x_im_p_bas_cum_ed_savings IN NUMBER,
x_im_p_bas_low_inc_allow IN NUMBER,
x_im_p_bas_total_asset_allow IN NUMBER,
x_im_p_bas_disc_net_worth IN NUMBER,
x_im_p_bas_total_cont_asset IN NUMBER,
x_im_p_bas_total_cont IN NUMBER,
x_im_p_bas_num_in_coll_adj IN NUMBER,
x_im_p_bas_cont_for_stu IN NUMBER,
x_im_p_bas_cont_from_income IN NUMBER,
x_im_p_bas_cont_from_assets IN NUMBER,
x_im_p_opt_agi_taxable_income IN NUMBER,
x_im_p_opt_untx_inc_and_ben IN NUMBER,
x_im_p_opt_inc_adj IN NUMBER,
x_im_p_opt_total_income IN NUMBER,
x_im_p_opt_us_income_tax IN NUMBER,
x_im_p_opt_st_and_other_tax IN NUMBER,
x_im_p_opt_fica_tax IN NUMBER,
x_im_p_opt_med_dental IN NUMBER,
x_im_p_opt_elem_sec_tuit IN NUMBER,
x_im_p_opt_employment_allow IN NUMBER,
x_im_p_opt_annual_ed_savings IN NUMBER,
x_im_p_opt_inc_prot_allow_m IN NUMBER,
x_im_p_opt_total_inc_allow IN NUMBER,
x_im_p_opt_cal_avail_inc IN NUMBER,
x_im_p_opt_avail_income IN NUMBER,
x_im_p_opt_total_cont_inc IN NUMBER,
x_im_p_opt_cash_bank_accounts IN NUMBER,
x_im_p_opt_home_equity IN NUMBER,
x_im_p_opt_ot_rl_est_inv_eq IN NUMBER,
x_im_p_opt_adj_bus_farm_worth IN NUMBER,
x_im_p_opt_ass_sibs_pre_tui IN NUMBER,
x_im_p_opt_net_worth IN NUMBER,
x_im_p_opt_emerg_res_allow IN NUMBER,
x_im_p_opt_cum_ed_savings IN NUMBER,
x_im_p_opt_low_inc_allow IN NUMBER,
x_im_p_opt_total_asset_allow IN NUMBER,
x_im_p_opt_disc_net_worth IN NUMBER,
x_im_p_opt_total_cont_asset IN NUMBER,
x_im_p_opt_total_cont IN NUMBER,
x_im_p_opt_num_in_coll_adj IN NUMBER,
x_im_p_opt_cont_for_stu IN NUMBER,
x_im_p_opt_cont_from_income IN NUMBER,
x_im_p_opt_cont_from_assets IN NUMBER,
x_fm_p_analysis_type IN VARCHAR2,
x_fm_p_agi_taxable_income IN NUMBER,
x_fm_p_untx_inc_and_ben IN NUMBER,
x_fm_p_inc_adj IN NUMBER,
x_fm_p_total_income IN NUMBER,
x_fm_p_us_income_tax IN NUMBER,
x_fm_p_state_and_other_taxes IN NUMBER,
x_fm_p_fica_tax IN NUMBER,
x_fm_p_employment_allow IN NUMBER,
x_fm_p_income_prot_allow IN NUMBER,
x_fm_p_total_allow IN NUMBER,
x_fm_p_avail_income IN NUMBER,
x_fm_p_cash_bank_accounts IN NUMBER,
x_fm_p_ot_rl_est_inv_equity IN NUMBER,
x_fm_p_adj_bus_farm_net_worth IN NUMBER,
x_fm_p_net_worth IN NUMBER,
x_fm_p_asset_prot_allow IN NUMBER,
x_fm_p_disc_net_worth IN NUMBER,
x_fm_p_total_contribution IN NUMBER,
x_fm_p_num_in_coll IN NUMBER,
x_fm_p_cont_for_stu IN NUMBER,
x_fm_p_cont_from_income IN NUMBER,
x_fm_p_cont_from_assets IN NUMBER,
x_im_s_bas_agi_taxable_income IN NUMBER,
x_im_s_bas_untx_inc_and_ben IN NUMBER,
x_im_s_bas_inc_adj IN NUMBER,
x_im_s_bas_total_income IN NUMBER,
x_im_s_bas_us_income_tax IN NUMBER,
x_im_s_bas_state_and_oth_taxes IN NUMBER,
x_im_s_bas_fica_tax IN NUMBER,
x_im_s_bas_med_dental IN NUMBER,
x_im_s_bas_employment_allow IN NUMBER,
x_im_s_bas_annual_ed_savings IN NUMBER,
x_im_s_bas_inc_prot_allow_m IN NUMBER,
x_im_s_bas_total_inc_allow IN NUMBER,
x_im_s_bas_cal_avail_income IN NUMBER,
x_im_s_bas_avail_income IN NUMBER,
x_im_s_bas_total_cont_inc IN NUMBER,
x_im_s_bas_cash_bank_accounts IN NUMBER,
x_im_s_bas_home_equity IN NUMBER,
x_im_s_bas_ot_rl_est_inv_eq IN NUMBER,
x_im_s_bas_adj_busfarm_worth IN NUMBER,
x_im_s_bas_trusts IN NUMBER,
x_im_s_bas_net_worth IN NUMBER,
x_im_s_bas_emerg_res_allow IN NUMBER,
x_im_s_bas_cum_ed_savings IN NUMBER,
x_im_s_bas_total_asset_allow IN NUMBER,
x_im_s_bas_disc_net_worth IN NUMBER,
x_im_s_bas_total_cont_asset IN NUMBER,
x_im_s_bas_total_cont IN NUMBER,
x_im_s_bas_num_in_coll_adj IN NUMBER,
x_im_s_bas_cont_for_stu IN NUMBER,
x_im_s_bas_cont_from_income IN NUMBER,
x_im_s_bas_cont_from_assets IN NUMBER,
x_im_s_est_agitaxable_income IN NUMBER,
x_im_s_est_untx_inc_and_ben IN NUMBER,
x_im_s_est_inc_adj IN NUMBER,
x_im_s_est_total_income IN NUMBER,
x_im_s_est_us_income_tax IN NUMBER,
x_im_s_est_state_and_oth_taxes IN NUMBER,
x_im_s_est_fica_tax IN NUMBER,
x_im_s_est_med_dental IN NUMBER,
x_im_s_est_employment_allow IN NUMBER,
x_im_s_est_annual_ed_savings IN NUMBER,
x_im_s_est_inc_prot_allow_m IN NUMBER,
x_im_s_est_total_inc_allow IN NUMBER,
x_im_s_est_cal_avail_income IN NUMBER,
x_im_s_est_avail_income IN NUMBER,
x_im_s_est_total_cont_inc IN NUMBER,
x_im_s_est_cash_bank_accounts IN NUMBER,
x_im_s_est_home_equity IN NUMBER,
x_im_s_est_ot_rl_est_inv_eq IN NUMBER,
x_im_s_est_adj_bus_farm_worth IN NUMBER,
x_im_s_est_est_trusts IN NUMBER,
x_im_s_est_net_worth IN NUMBER,
x_im_s_est_emerg_res_allow IN NUMBER,
x_im_s_est_cum_ed_savings IN NUMBER,
x_im_s_est_total_asset_allow IN NUMBER,
x_im_s_est_disc_net_worth IN NUMBER,
x_im_s_est_total_cont_asset IN NUMBER,
x_im_s_est_total_cont IN NUMBER,
x_im_s_est_num_in_coll_adj IN NUMBER,
x_im_s_est_cont_for_stu IN NUMBER,
x_im_s_est_cont_from_income IN NUMBER,
x_im_s_est_cont_from_assets IN NUMBER,
x_im_s_opt_agi_taxable_income IN NUMBER,
x_im_s_opt_untx_inc_and_ben IN NUMBER,
x_im_s_opt_inc_adj IN NUMBER,
x_im_s_opt_total_income IN NUMBER,
x_im_s_opt_us_income_tax IN NUMBER,
x_im_s_opt_state_and_oth_taxes IN NUMBER,
x_im_s_opt_fica_tax IN NUMBER,
x_im_s_opt_med_dental IN NUMBER,
x_im_s_opt_employment_allow IN NUMBER,
x_im_s_opt_annual_ed_savings IN NUMBER,
x_im_s_opt_inc_prot_allow_m IN NUMBER,
x_im_s_opt_total_inc_allow IN NUMBER,
x_im_s_opt_cal_avail_income IN NUMBER,
x_im_s_opt_avail_income IN NUMBER,
x_im_s_opt_total_cont_inc IN NUMBER,
x_im_s_opt_cash_bank_accounts IN NUMBER,
x_im_s_opt_ira_keogh_accounts IN NUMBER,
x_im_s_opt_home_equity IN NUMBER,
x_im_s_opt_ot_rl_est_inv_eq IN NUMBER,
x_im_s_opt_adj_bus_farm_worth IN NUMBER,
x_im_s_opt_trusts IN NUMBER,
x_im_s_opt_net_worth IN NUMBER,
x_im_s_opt_emerg_res_allow IN NUMBER,
x_im_s_opt_cum_ed_savings IN NUMBER,
x_im_s_opt_total_asset_allow IN NUMBER,
x_im_s_opt_disc_net_worth IN NUMBER,
x_im_s_opt_total_cont_asset IN NUMBER,
x_im_s_opt_total_cont IN NUMBER,
x_im_s_opt_num_in_coll_adj IN NUMBER,
x_im_s_opt_cont_for_stu IN NUMBER,
x_im_s_opt_cont_from_income IN NUMBER,
x_im_s_opt_cont_from_assets IN NUMBER,
x_fm_s_analysis_type IN VARCHAR2,
x_fm_s_agi_taxable_income IN NUMBER,
x_fm_s_untx_inc_and_ben IN NUMBER,
x_fm_s_inc_adj IN NUMBER,
x_fm_s_total_income IN NUMBER,
x_fm_s_us_income_tax IN NUMBER,
x_fm_s_state_and_oth_taxes IN NUMBER,
x_fm_s_fica_tax IN NUMBER,
x_fm_s_employment_allow IN NUMBER,
x_fm_s_income_prot_allow IN NUMBER,
x_fm_s_total_allow IN NUMBER,
x_fm_s_cal_avail_income IN NUMBER,
x_fm_s_avail_income IN NUMBER,
x_fm_s_cash_bank_accounts IN NUMBER,
x_fm_s_ot_rl_est_inv_equity IN NUMBER,
x_fm_s_adj_bus_farm_worth IN NUMBER,
x_fm_s_trusts IN NUMBER,
x_fm_s_net_worth IN NUMBER,
x_fm_s_asset_prot_allow IN NUMBER,
x_fm_s_disc_net_worth IN NUMBER,
x_fm_s_total_cont IN NUMBER,
x_fm_s_num_in_coll IN NUMBER,
x_fm_s_cont_for_stu IN NUMBER,
x_fm_s_cont_from_income IN NUMBER,
x_fm_s_cont_from_assets IN NUMBER,
x_im_inst_resident_ind IN VARCHAR2,
x_institutional_1_budget_name IN VARCHAR2,
x_im_inst_1_budget_duration IN NUMBER,
x_im_inst_1_tuition_fees IN NUMBER,
x_im_inst_1_books_supplies IN NUMBER,
x_im_inst_1_living_expenses IN NUMBER,
x_im_inst_1_tot_expenses IN NUMBER,
x_im_inst_1_tot_stu_cont IN NUMBER,
x_im_inst_1_tot_par_cont IN NUMBER,
x_im_inst_1_tot_family_cont IN NUMBER,
x_im_inst_1_va_benefits IN NUMBER,
x_im_inst_1_ot_cont IN NUMBER,
x_im_inst_1_est_financial_need IN NUMBER,
x_institutional_2_budget_name IN VARCHAR2,
x_im_inst_2_budget_duration IN VARCHAR2,
x_im_inst_2_tuition_fees IN NUMBER,
x_im_inst_2_books_supplies IN NUMBER,
x_im_inst_2_living_expenses IN NUMBER,
x_im_inst_2_tot_expenses IN NUMBER,
x_im_inst_2_tot_stu_cont IN NUMBER,
x_im_inst_2_tot_par_cont IN NUMBER,
x_im_inst_2_tot_family_cont IN NUMBER,
x_im_inst_2_va_benefits IN NUMBER,
x_im_inst_2_est_financial_need IN NUMBER,
x_institutional_3_budget_name IN VARCHAR2,
x_im_inst_3_budget_duration IN NUMBER,
x_im_inst_3_tuition_fees IN NUMBER,
x_im_inst_3_books_supplies IN NUMBER,
x_im_inst_3_living_expenses IN NUMBER,
x_im_inst_3_tot_expenses IN NUMBER,
x_im_inst_3_tot_stu_cont IN NUMBER,
x_im_inst_3_tot_par_cont IN NUMBER,
x_im_inst_3_tot_family_cont IN NUMBER,
x_im_inst_3_va_benefits IN NUMBER,
x_im_inst_3_est_financial_need IN NUMBER,
x_fm_inst_1_federal_efc IN VARCHAR2,
x_fm_inst_1_va_benefits IN VARCHAR2,
x_fm_inst_1_fed_eligibility IN VARCHAR2,
x_fm_inst_1_pell IN VARCHAR2,
x_option_par_loss_allow_ind IN VARCHAR2,
x_option_par_tuition_ind IN VARCHAR2,
x_option_par_home_ind IN VARCHAR2,
x_option_par_home_value IN VARCHAR2,
x_option_par_home_debt IN VARCHAR2,
x_option_stu_ira_keogh_ind IN VARCHAR2,
x_option_stu_home_ind IN VARCHAR2,
x_option_stu_home_value IN VARCHAR2,
x_option_stu_home_debt IN VARCHAR2,
x_option_stu_sum_ay_inc_ind IN VARCHAR2,
x_option_par_hope_ll_credit IN VARCHAR2,
x_option_stu_hope_ll_credit IN VARCHAR2,
x_im_parent_1_8_months_bas IN VARCHAR2,
x_im_p_more_than_9_mth_ba IN VARCHAR2,
x_im_parent_1_8_months_opt IN VARCHAR2,
x_im_p_more_than_9_mth_op IN VARCHAR2,
x_fnar_message_1 IN VARCHAR2,
x_fnar_message_2 IN VARCHAR2,
x_fnar_message_3 IN VARCHAR2,
x_fnar_message_4 IN VARCHAR2,
x_fnar_message_5 IN VARCHAR2,
x_fnar_message_6 IN VARCHAR2,
x_fnar_message_7 IN VARCHAR2,
x_fnar_message_8 IN VARCHAR2,
x_fnar_message_9 IN VARCHAR2,
x_fnar_message_10 IN VARCHAR2,
x_fnar_message_11 IN VARCHAR2,
x_fnar_message_12 IN VARCHAR2,
x_fnar_message_13 IN VARCHAR2,
x_fnar_message_20 IN VARCHAR2,
x_fnar_message_21 IN VARCHAR2,
x_fnar_message_22 IN VARCHAR2,
x_fnar_message_23 IN VARCHAR2,
x_fnar_message_24 IN VARCHAR2,
x_fnar_message_25 IN VARCHAR2,
x_fnar_message_26 IN VARCHAR2,
x_fnar_message_27 IN VARCHAR2,
x_fnar_message_30 IN VARCHAR2,
x_fnar_message_31 IN VARCHAR2,
x_fnar_message_32 IN VARCHAR2,
x_fnar_message_33 IN VARCHAR2,
x_fnar_message_34 IN VARCHAR2,
x_fnar_message_35 IN VARCHAR2,
x_fnar_message_36 IN VARCHAR2,
x_fnar_message_37 IN VARCHAR2,
x_fnar_message_38 IN VARCHAR2,
x_fnar_message_39 IN VARCHAR2,
x_fnar_message_45 IN VARCHAR2,
x_fnar_message_46 IN VARCHAR2,
x_fnar_message_47 IN VARCHAR2,
x_fnar_message_48 IN VARCHAR2,
x_fnar_message_50 IN VARCHAR2,
x_fnar_message_51 IN VARCHAR2,
x_fnar_message_52 IN VARCHAR2,
x_fnar_message_53 IN VARCHAR2,
x_fnar_message_56 IN VARCHAR2,
x_fnar_message_57 IN VARCHAR2,
x_fnar_message_58 IN VARCHAR2,
x_fnar_message_59 IN VARCHAR2,
x_fnar_message_60 IN VARCHAR2,
x_fnar_message_61 IN VARCHAR2,
x_fnar_message_62 IN VARCHAR2,
x_fnar_message_63 IN VARCHAR2,
x_fnar_message_64 IN VARCHAR2,
x_fnar_message_65 IN VARCHAR2,
x_fnar_message_71 IN VARCHAR2,
x_fnar_message_72 IN VARCHAR2,
x_fnar_message_73 IN VARCHAR2,
x_fnar_message_74 IN VARCHAR2,
x_fnar_message_75 IN VARCHAR2,
x_fnar_message_76 IN VARCHAR2,
x_fnar_message_77 IN VARCHAR2,
x_fnar_message_78 IN VARCHAR2,
x_fnar_mesg_10_stu_fam_mem IN VARCHAR2,
x_fnar_mesg_11_stu_no_in_coll IN VARCHAR2,
x_fnar_mesg_24_stu_avail_inc IN VARCHAR2,
x_fnar_mesg_26_stu_taxes IN VARCHAR2,
x_fnar_mesg_33_stu_home_value IN VARCHAR2,
x_fnar_mesg_34_stu_home_value IN VARCHAR2,
x_fnar_mesg_34_stu_home_equity IN VARCHAR2,
x_fnar_mesg_35_stu_home_value IN VARCHAR2,
x_fnar_mesg_35_stu_home_equity IN VARCHAR2,
x_fnar_mesg_36_stu_home_equity IN VARCHAR2,
x_fnar_mesg_48_par_fam_mem IN VARCHAR2,
x_fnar_mesg_49_par_no_in_coll IN VARCHAR2,
x_fnar_mesg_56_par_agi IN VARCHAR2,
x_fnar_mesg_62_par_taxes IN VARCHAR2,
x_fnar_mesg_73_par_home_value IN VARCHAR2,
x_fnar_mesg_74_par_home_value IN VARCHAR2,
x_fnar_mesg_74_par_home_equity IN VARCHAR2,
x_fnar_mesg_75_par_home_value IN VARCHAR2,
x_fnar_mesg_75_par_home_equity IN VARCHAR2,
x_fnar_mesg_76_par_home_equity IN VARCHAR2,
x_assumption_message_1 IN VARCHAR2,
x_assumption_message_2 IN VARCHAR2,
x_assumption_message_3 IN VARCHAR2,
x_assumption_message_4 IN VARCHAR2,
x_assumption_message_5 IN VARCHAR2,
x_assumption_message_6 IN VARCHAR2,
x_record_mark IN VARCHAR2,
x_mode IN VARCHAR2 DEFAULT 'R',
x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
x_opt_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
x_opt_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
x_opt_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
x_opt_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
x_opt_par_cola_adj_value IN NUMBER DEFAULT NULL,
x_legacy_record_flag IN VARCHAR2,
x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
x_cust_parent_cont_adj_num IN NUMBER,
x_custodial_parent_num IN NUMBER,
x_cust_par_base_prcnt_inc_amt IN NUMBER,
x_cust_par_base_cont_inc_amt IN NUMBER,
x_cust_par_base_cont_ast_amt IN NUMBER,
x_cust_par_base_tot_cont_amt IN NUMBER,
x_cust_par_opt_prcnt_inc_amt IN NUMBER,
x_cust_par_opt_cont_inc_amt IN NUMBER,
x_cust_par_opt_cont_ast_amt IN NUMBER,
x_cust_par_opt_tot_cont_amt IN NUMBER,
x_parents_email_txt IN VARCHAR2,
x_parent_1_birth_date IN DATE,
x_parent_2_birth_date IN DATE
) AS
/*
|| Created By : vivuyyur
|| Created On : 30-MAY-2001
|| 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_css_fnar_all
WHERE fnar_id = x_fnar_id;
x_last_update_date DATE;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
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;
SELECT igf_ap_css_fnar_all_s.NEXTVAL
INTO x_fnar_id
FROM dual;
p_action => 'INSERT',
x_rowid => x_rowid,
x_fnar_id => x_fnar_id,
x_cssp_id => x_cssp_id,
x_r_s_email_address => x_r_s_email_address,
x_eps_code => x_eps_code,
x_comp_css_dependency_status => x_comp_css_dependency_status,
x_stu_age => x_stu_age,
x_assumed_stu_yr_in_coll => x_assumed_stu_yr_in_coll,
x_comp_stu_marital_status => x_comp_stu_marital_status,
x_stu_family_members => x_stu_family_members,
x_stu_fam_members_in_college => x_stu_fam_members_in_college,
x_par_marital_status => x_par_marital_status,
x_par_family_members => x_par_family_members,
x_par_total_in_college => x_par_total_in_college,
x_par_par_in_college => x_par_par_in_college,
x_par_others_in_college => x_par_others_in_college,
x_par_aesa => x_par_aesa,
x_par_cesa => x_par_cesa,
x_stu_aesa => x_stu_aesa,
x_stu_cesa => x_stu_cesa,
x_im_p_bas_agi_taxable_income => x_im_p_bas_agi_taxable_income,
x_im_p_bas_untx_inc_and_ben => x_im_p_bas_untx_inc_and_ben,
x_im_p_bas_inc_adj => x_im_p_bas_inc_adj,
x_im_p_bas_total_income => x_im_p_bas_total_income,
x_im_p_bas_us_income_tax => x_im_p_bas_us_income_tax,
x_im_p_bas_st_and_other_tax => x_im_p_bas_st_and_other_tax,
x_im_p_bas_fica_tax => x_im_p_bas_fica_tax,
x_im_p_bas_med_dental => x_im_p_bas_med_dental,
x_im_p_bas_employment_allow => x_im_p_bas_employment_allow,
x_im_p_bas_annual_ed_savings => x_im_p_bas_annual_ed_savings,
x_im_p_bas_inc_prot_allow_m => x_im_p_bas_inc_prot_allow_m,
x_im_p_bas_total_inc_allow => x_im_p_bas_total_inc_allow,
x_im_p_bas_cal_avail_inc => x_im_p_bas_cal_avail_inc,
x_im_p_bas_avail_income => x_im_p_bas_avail_income,
x_im_p_bas_total_cont_inc => x_im_p_bas_total_cont_inc,
x_im_p_bas_cash_bank_accounts => x_im_p_bas_cash_bank_accounts,
x_im_p_bas_home_equity => x_im_p_bas_home_equity,
x_im_p_bas_ot_rl_est_inv_eq => x_im_p_bas_ot_rl_est_inv_eq,
x_im_p_bas_adj_bus_farm_worth => x_im_p_bas_adj_bus_farm_worth,
x_im_p_bas_ass_sibs_pre_tui => x_im_p_bas_ass_sibs_pre_tui,
x_im_p_bas_net_worth => x_im_p_bas_net_worth,
x_im_p_bas_emerg_res_allow => x_im_p_bas_emerg_res_allow,
x_im_p_bas_cum_ed_savings => x_im_p_bas_cum_ed_savings,
x_im_p_bas_low_inc_allow => x_im_p_bas_low_inc_allow,
x_im_p_bas_total_asset_allow => x_im_p_bas_total_asset_allow,
x_im_p_bas_disc_net_worth => x_im_p_bas_disc_net_worth,
x_im_p_bas_total_cont_asset => x_im_p_bas_total_cont_asset,
x_im_p_bas_total_cont => x_im_p_bas_total_cont,
x_im_p_bas_num_in_coll_adj => x_im_p_bas_num_in_coll_adj,
x_im_p_bas_cont_for_stu => x_im_p_bas_cont_for_stu,
x_im_p_bas_cont_from_income => x_im_p_bas_cont_from_income,
x_im_p_bas_cont_from_assets => x_im_p_bas_cont_from_assets,
x_im_p_opt_agi_taxable_income => x_im_p_opt_agi_taxable_income,
x_im_p_opt_untx_inc_and_ben => x_im_p_opt_untx_inc_and_ben,
x_im_p_opt_inc_adj => x_im_p_opt_inc_adj,
x_im_p_opt_total_income => x_im_p_opt_total_income,
x_im_p_opt_us_income_tax => x_im_p_opt_us_income_tax,
x_im_p_opt_st_and_other_tax => x_im_p_opt_st_and_other_tax,
x_im_p_opt_fica_tax => x_im_p_opt_fica_tax,
x_im_p_opt_med_dental => x_im_p_opt_med_dental,
x_im_p_opt_elem_sec_tuit => x_im_p_opt_elem_sec_tuit,
x_im_p_opt_employment_allow => x_im_p_opt_employment_allow,
x_im_p_opt_annual_ed_savings => x_im_p_opt_annual_ed_savings,
x_im_p_opt_inc_prot_allow_m => x_im_p_opt_inc_prot_allow_m,
x_im_p_opt_total_inc_allow => x_im_p_opt_total_inc_allow,
x_im_p_opt_cal_avail_inc => x_im_p_opt_cal_avail_inc,
x_im_p_opt_avail_income => x_im_p_opt_avail_income,
x_im_p_opt_total_cont_inc => x_im_p_opt_total_cont_inc,
x_im_p_opt_cash_bank_accounts => x_im_p_opt_cash_bank_accounts,
x_im_p_opt_home_equity => x_im_p_opt_home_equity,
x_im_p_opt_ot_rl_est_inv_eq => x_im_p_opt_ot_rl_est_inv_eq,
x_im_p_opt_adj_bus_farm_worth => x_im_p_opt_adj_bus_farm_worth,
x_im_p_opt_ass_sibs_pre_tui => x_im_p_opt_ass_sibs_pre_tui,
x_im_p_opt_net_worth => x_im_p_opt_net_worth,
x_im_p_opt_emerg_res_allow => x_im_p_opt_emerg_res_allow,
x_im_p_opt_cum_ed_savings => x_im_p_opt_cum_ed_savings,
x_im_p_opt_low_inc_allow => x_im_p_opt_low_inc_allow,
x_im_p_opt_total_asset_allow => x_im_p_opt_total_asset_allow,
x_im_p_opt_disc_net_worth => x_im_p_opt_disc_net_worth,
x_im_p_opt_total_cont_asset => x_im_p_opt_total_cont_asset,
x_im_p_opt_total_cont => x_im_p_opt_total_cont,
x_im_p_opt_num_in_coll_adj => x_im_p_opt_num_in_coll_adj,
x_im_p_opt_cont_for_stu => x_im_p_opt_cont_for_stu,
x_im_p_opt_cont_from_income => x_im_p_opt_cont_from_income,
x_im_p_opt_cont_from_assets => x_im_p_opt_cont_from_assets,
x_fm_p_analysis_type => x_fm_p_analysis_type,
x_fm_p_agi_taxable_income => x_fm_p_agi_taxable_income,
x_fm_p_untx_inc_and_ben => x_fm_p_untx_inc_and_ben,
x_fm_p_inc_adj => x_fm_p_inc_adj,
x_fm_p_total_income => x_fm_p_total_income,
x_fm_p_us_income_tax => x_fm_p_us_income_tax,
x_fm_p_state_and_other_taxes => x_fm_p_state_and_other_taxes,
x_fm_p_fica_tax => x_fm_p_fica_tax,
x_fm_p_employment_allow => x_fm_p_employment_allow,
x_fm_p_income_prot_allow => x_fm_p_income_prot_allow,
x_fm_p_total_allow => x_fm_p_total_allow,
x_fm_p_avail_income => x_fm_p_avail_income,
x_fm_p_cash_bank_accounts => x_fm_p_cash_bank_accounts,
x_fm_p_ot_rl_est_inv_equity => x_fm_p_ot_rl_est_inv_equity,
x_fm_p_adj_bus_farm_net_worth => x_fm_p_adj_bus_farm_net_worth,
x_fm_p_net_worth => x_fm_p_net_worth,
x_fm_p_asset_prot_allow => x_fm_p_asset_prot_allow,
x_fm_p_disc_net_worth => x_fm_p_disc_net_worth,
x_fm_p_total_contribution => x_fm_p_total_contribution,
x_fm_p_num_in_coll => x_fm_p_num_in_coll,
x_fm_p_cont_for_stu => x_fm_p_cont_for_stu,
x_fm_p_cont_from_income => x_fm_p_cont_from_income,
x_fm_p_cont_from_assets => x_fm_p_cont_from_assets,
x_im_s_bas_agi_taxable_income => x_im_s_bas_agi_taxable_income,
x_im_s_bas_untx_inc_and_ben => x_im_s_bas_untx_inc_and_ben,
x_im_s_bas_inc_adj => x_im_s_bas_inc_adj,
x_im_s_bas_total_income => x_im_s_bas_total_income,
x_im_s_bas_us_income_tax => x_im_s_bas_us_income_tax,
x_im_s_bas_state_and_oth_taxes => x_im_s_bas_state_and_oth_taxes,
x_im_s_bas_fica_tax => x_im_s_bas_fica_tax,
x_im_s_bas_med_dental => x_im_s_bas_med_dental,
x_im_s_bas_employment_allow => x_im_s_bas_employment_allow,
x_im_s_bas_annual_ed_savings => x_im_s_bas_annual_ed_savings,
x_im_s_bas_inc_prot_allow_m => x_im_s_bas_inc_prot_allow_m,
x_im_s_bas_total_inc_allow => x_im_s_bas_total_inc_allow,
x_im_s_bas_cal_avail_income => x_im_s_bas_cal_avail_income,
x_im_s_bas_avail_income => x_im_s_bas_avail_income,
x_im_s_bas_total_cont_inc => x_im_s_bas_total_cont_inc,
x_im_s_bas_cash_bank_accounts => x_im_s_bas_cash_bank_accounts,
x_im_s_bas_home_equity => x_im_s_bas_home_equity,
x_im_s_bas_ot_rl_est_inv_eq => x_im_s_bas_ot_rl_est_inv_eq,
x_im_s_bas_adj_busfarm_worth => x_im_s_bas_adj_busfarm_worth,
x_im_s_bas_trusts => x_im_s_bas_trusts,
x_im_s_bas_net_worth => x_im_s_bas_net_worth,
x_im_s_bas_emerg_res_allow => x_im_s_bas_emerg_res_allow,
x_im_s_bas_cum_ed_savings => x_im_s_bas_cum_ed_savings,
x_im_s_bas_total_asset_allow => x_im_s_bas_total_asset_allow,
x_im_s_bas_disc_net_worth => x_im_s_bas_disc_net_worth,
x_im_s_bas_total_cont_asset => x_im_s_bas_total_cont_asset,
x_im_s_bas_total_cont => x_im_s_bas_total_cont,
x_im_s_bas_num_in_coll_adj => x_im_s_bas_num_in_coll_adj,
x_im_s_bas_cont_for_stu => x_im_s_bas_cont_for_stu,
x_im_s_bas_cont_from_income => x_im_s_bas_cont_from_income,
x_im_s_bas_cont_from_assets => x_im_s_bas_cont_from_assets,
x_im_s_est_agitaxable_income => x_im_s_est_agitaxable_income,
x_im_s_est_untx_inc_and_ben => x_im_s_est_untx_inc_and_ben,
x_im_s_est_inc_adj => x_im_s_est_inc_adj,
x_im_s_est_total_income => x_im_s_est_total_income,
x_im_s_est_us_income_tax => x_im_s_est_us_income_tax,
x_im_s_est_state_and_oth_taxes => x_im_s_est_state_and_oth_taxes,
x_im_s_est_fica_tax => x_im_s_est_fica_tax,
x_im_s_est_med_dental => x_im_s_est_med_dental,
x_im_s_est_employment_allow => x_im_s_est_employment_allow,
x_im_s_est_annual_ed_savings => x_im_s_est_annual_ed_savings,
x_im_s_est_inc_prot_allow_m => x_im_s_est_inc_prot_allow_m,
x_im_s_est_total_inc_allow => x_im_s_est_total_inc_allow,
x_im_s_est_cal_avail_income => x_im_s_est_cal_avail_income,
x_im_s_est_avail_income => x_im_s_est_avail_income,
x_im_s_est_total_cont_inc => x_im_s_est_total_cont_inc,
x_im_s_est_cash_bank_accounts => x_im_s_est_cash_bank_accounts,
x_im_s_est_home_equity => x_im_s_est_home_equity,
x_im_s_est_ot_rl_est_inv_eq => x_im_s_est_ot_rl_est_inv_eq,
x_im_s_est_adj_bus_farm_worth => x_im_s_est_adj_bus_farm_worth,
x_im_s_est_est_trusts => x_im_s_est_est_trusts,
x_im_s_est_net_worth => x_im_s_est_net_worth,
x_im_s_est_emerg_res_allow => x_im_s_est_emerg_res_allow,
x_im_s_est_cum_ed_savings => x_im_s_est_cum_ed_savings,
x_im_s_est_total_asset_allow => x_im_s_est_total_asset_allow,
x_im_s_est_disc_net_worth => x_im_s_est_disc_net_worth,
x_im_s_est_total_cont_asset => x_im_s_est_total_cont_asset,
x_im_s_est_total_cont => x_im_s_est_total_cont,
x_im_s_est_num_in_coll_adj => x_im_s_est_num_in_coll_adj,
x_im_s_est_cont_for_stu => x_im_s_est_cont_for_stu,
x_im_s_est_cont_from_income => x_im_s_est_cont_from_income,
x_im_s_est_cont_from_assets => x_im_s_est_cont_from_assets,
x_im_s_opt_agi_taxable_income => x_im_s_opt_agi_taxable_income,
x_im_s_opt_untx_inc_and_ben => x_im_s_opt_untx_inc_and_ben,
x_im_s_opt_inc_adj => x_im_s_opt_inc_adj,
x_im_s_opt_total_income => x_im_s_opt_total_income,
x_im_s_opt_us_income_tax => x_im_s_opt_us_income_tax,
x_im_s_opt_state_and_oth_taxes => x_im_s_opt_state_and_oth_taxes,
x_im_s_opt_fica_tax => x_im_s_opt_fica_tax,
x_im_s_opt_med_dental => x_im_s_opt_med_dental,
x_im_s_opt_employment_allow => x_im_s_opt_employment_allow,
x_im_s_opt_annual_ed_savings => x_im_s_opt_annual_ed_savings,
x_im_s_opt_inc_prot_allow_m => x_im_s_opt_inc_prot_allow_m,
x_im_s_opt_total_inc_allow => x_im_s_opt_total_inc_allow,
x_im_s_opt_cal_avail_income => x_im_s_opt_cal_avail_income,
x_im_s_opt_avail_income => x_im_s_opt_avail_income,
x_im_s_opt_total_cont_inc => x_im_s_opt_total_cont_inc,
x_im_s_opt_cash_bank_accounts => x_im_s_opt_cash_bank_accounts,
x_im_s_opt_ira_keogh_accounts => x_im_s_opt_ira_keogh_accounts,
x_im_s_opt_home_equity => x_im_s_opt_home_equity,
x_im_s_opt_ot_rl_est_inv_eq => x_im_s_opt_ot_rl_est_inv_eq,
x_im_s_opt_adj_bus_farm_worth => x_im_s_opt_adj_bus_farm_worth,
x_im_s_opt_trusts => x_im_s_opt_trusts,
x_im_s_opt_net_worth => x_im_s_opt_net_worth,
x_im_s_opt_emerg_res_allow => x_im_s_opt_emerg_res_allow,
x_im_s_opt_cum_ed_savings => x_im_s_opt_cum_ed_savings,
x_im_s_opt_total_asset_allow => x_im_s_opt_total_asset_allow,
x_im_s_opt_disc_net_worth => x_im_s_opt_disc_net_worth,
x_im_s_opt_total_cont_asset => x_im_s_opt_total_cont_asset,
x_im_s_opt_total_cont => x_im_s_opt_total_cont,
x_im_s_opt_num_in_coll_adj => x_im_s_opt_num_in_coll_adj,
x_im_s_opt_cont_for_stu => x_im_s_opt_cont_for_stu,
x_im_s_opt_cont_from_income => x_im_s_opt_cont_from_income,
x_im_s_opt_cont_from_assets => x_im_s_opt_cont_from_assets,
x_fm_s_analysis_type => x_fm_s_analysis_type,
x_fm_s_agi_taxable_income => x_fm_s_agi_taxable_income,
x_fm_s_untx_inc_and_ben => x_fm_s_untx_inc_and_ben,
x_fm_s_inc_adj => x_fm_s_inc_adj,
x_fm_s_total_income => x_fm_s_total_income,
x_fm_s_us_income_tax => x_fm_s_us_income_tax,
x_fm_s_state_and_oth_taxes => x_fm_s_state_and_oth_taxes,
x_fm_s_fica_tax => x_fm_s_fica_tax,
x_fm_s_employment_allow => x_fm_s_employment_allow,
x_fm_s_income_prot_allow => x_fm_s_income_prot_allow,
x_fm_s_total_allow => x_fm_s_total_allow,
x_fm_s_cal_avail_income => x_fm_s_cal_avail_income,
x_fm_s_avail_income => x_fm_s_avail_income,
x_fm_s_cash_bank_accounts => x_fm_s_cash_bank_accounts,
x_fm_s_ot_rl_est_inv_equity => x_fm_s_ot_rl_est_inv_equity,
x_fm_s_adj_bus_farm_worth => x_fm_s_adj_bus_farm_worth,
x_fm_s_trusts => x_fm_s_trusts,
x_fm_s_net_worth => x_fm_s_net_worth,
x_fm_s_asset_prot_allow => x_fm_s_asset_prot_allow,
x_fm_s_disc_net_worth => x_fm_s_disc_net_worth,
x_fm_s_total_cont => x_fm_s_total_cont,
x_fm_s_num_in_coll => x_fm_s_num_in_coll,
x_fm_s_cont_for_stu => x_fm_s_cont_for_stu,
x_fm_s_cont_from_income => x_fm_s_cont_from_income,
x_fm_s_cont_from_assets => x_fm_s_cont_from_assets,
x_im_inst_resident_ind => x_im_inst_resident_ind,
x_institutional_1_budget_name => x_institutional_1_budget_name,
x_im_inst_1_budget_duration => x_im_inst_1_budget_duration,
x_im_inst_1_tuition_fees => x_im_inst_1_tuition_fees,
x_im_inst_1_books_supplies => x_im_inst_1_books_supplies,
x_im_inst_1_living_expenses => x_im_inst_1_living_expenses,
x_im_inst_1_tot_expenses => x_im_inst_1_tot_expenses,
x_im_inst_1_tot_stu_cont => x_im_inst_1_tot_stu_cont,
x_im_inst_1_tot_par_cont => x_im_inst_1_tot_par_cont,
x_im_inst_1_tot_family_cont => x_im_inst_1_tot_family_cont,
x_im_inst_1_va_benefits => x_im_inst_1_va_benefits,
x_im_inst_1_ot_cont => x_im_inst_1_ot_cont,
x_im_inst_1_est_financial_need => x_im_inst_1_est_financial_need,
x_institutional_2_budget_name => x_institutional_2_budget_name,
x_im_inst_2_budget_duration => x_im_inst_2_budget_duration,
x_im_inst_2_tuition_fees => x_im_inst_2_tuition_fees,
x_im_inst_2_books_supplies => x_im_inst_2_books_supplies,
x_im_inst_2_living_expenses => x_im_inst_2_living_expenses,
x_im_inst_2_tot_expenses => x_im_inst_2_tot_expenses,
x_im_inst_2_tot_stu_cont => x_im_inst_2_tot_stu_cont,
x_im_inst_2_tot_par_cont => x_im_inst_2_tot_par_cont,
x_im_inst_2_tot_family_cont => x_im_inst_2_tot_family_cont,
x_im_inst_2_va_benefits => x_im_inst_2_va_benefits,
x_im_inst_2_est_financial_need => x_im_inst_2_est_financial_need,
x_institutional_3_budget_name => x_institutional_3_budget_name,
x_im_inst_3_budget_duration => x_im_inst_3_budget_duration,
x_im_inst_3_tuition_fees => x_im_inst_3_tuition_fees,
x_im_inst_3_books_supplies => x_im_inst_3_books_supplies,
x_im_inst_3_living_expenses => x_im_inst_3_living_expenses,
x_im_inst_3_tot_expenses => x_im_inst_3_tot_expenses,
x_im_inst_3_tot_stu_cont => x_im_inst_3_tot_stu_cont,
x_im_inst_3_tot_par_cont => x_im_inst_3_tot_par_cont,
x_im_inst_3_tot_family_cont => x_im_inst_3_tot_family_cont,
x_im_inst_3_va_benefits => x_im_inst_3_va_benefits,
x_im_inst_3_est_financial_need => x_im_inst_3_est_financial_need,
x_fm_inst_1_federal_efc => x_fm_inst_1_federal_efc,
x_fm_inst_1_va_benefits => x_fm_inst_1_va_benefits,
x_fm_inst_1_fed_eligibility => x_fm_inst_1_fed_eligibility,
x_fm_inst_1_pell => x_fm_inst_1_pell,
x_option_par_loss_allow_ind => x_option_par_loss_allow_ind,
x_option_par_tuition_ind => x_option_par_tuition_ind,
x_option_par_home_ind => x_option_par_home_ind,
x_option_par_home_value => x_option_par_home_value,
x_option_par_home_debt => x_option_par_home_debt,
x_option_stu_ira_keogh_ind => x_option_stu_ira_keogh_ind,
x_option_stu_home_ind => x_option_stu_home_ind,
x_option_stu_home_value => x_option_stu_home_value,
x_option_stu_home_debt => x_option_stu_home_debt,
x_option_stu_sum_ay_inc_ind => x_option_stu_sum_ay_inc_ind,
x_option_par_hope_ll_credit => x_option_par_hope_ll_credit,
x_option_stu_hope_ll_credit => x_option_stu_hope_ll_credit,
x_im_parent_1_8_months_bas => x_im_parent_1_8_months_bas,
x_im_p_more_than_9_mth_ba => x_im_p_more_than_9_mth_ba,
x_im_parent_1_8_months_opt => x_im_parent_1_8_months_opt,
x_im_p_more_than_9_mth_op => x_im_p_more_than_9_mth_op,
x_fnar_message_1 => x_fnar_message_1,
x_fnar_message_2 => x_fnar_message_2,
x_fnar_message_3 => x_fnar_message_3,
x_fnar_message_4 => x_fnar_message_4,
x_fnar_message_5 => x_fnar_message_5,
x_fnar_message_6 => x_fnar_message_6,
x_fnar_message_7 => x_fnar_message_7,
x_fnar_message_8 => x_fnar_message_8,
x_fnar_message_9 => x_fnar_message_9,
x_fnar_message_10 => x_fnar_message_10,
x_fnar_message_11 => x_fnar_message_11,
x_fnar_message_12 => x_fnar_message_12,
x_fnar_message_13 => x_fnar_message_13,
x_fnar_message_20 => x_fnar_message_20,
x_fnar_message_21 => x_fnar_message_21,
x_fnar_message_22 => x_fnar_message_22,
x_fnar_message_23 => x_fnar_message_23,
x_fnar_message_24 => x_fnar_message_24,
x_fnar_message_25 => x_fnar_message_25,
x_fnar_message_26 => x_fnar_message_26,
x_fnar_message_27 => x_fnar_message_27,
x_fnar_message_30 => x_fnar_message_30,
x_fnar_message_31 => x_fnar_message_31,
x_fnar_message_32 => x_fnar_message_32,
x_fnar_message_33 => x_fnar_message_33,
x_fnar_message_34 => x_fnar_message_34,
x_fnar_message_35 => x_fnar_message_35,
x_fnar_message_36 => x_fnar_message_36,
x_fnar_message_37 => x_fnar_message_37,
x_fnar_message_38 => x_fnar_message_38,
x_fnar_message_39 => x_fnar_message_39,
x_fnar_message_45 => x_fnar_message_45,
x_fnar_message_46 => x_fnar_message_46,
x_fnar_message_47 => x_fnar_message_47,
x_fnar_message_48 => x_fnar_message_48,
x_fnar_message_50 => x_fnar_message_50,
x_fnar_message_51 => x_fnar_message_51,
x_fnar_message_52 => x_fnar_message_52,
x_fnar_message_53 => x_fnar_message_53,
x_fnar_message_56 => x_fnar_message_56,
x_fnar_message_57 => x_fnar_message_57,
x_fnar_message_58 => x_fnar_message_58,
x_fnar_message_59 => x_fnar_message_59,
x_fnar_message_60 => x_fnar_message_60,
x_fnar_message_61 => x_fnar_message_61,
x_fnar_message_62 => x_fnar_message_62,
x_fnar_message_63 => x_fnar_message_63,
x_fnar_message_64 => x_fnar_message_64,
x_fnar_message_65 => x_fnar_message_65,
x_fnar_message_71 => x_fnar_message_71,
x_fnar_message_72 => x_fnar_message_72,
x_fnar_message_73 => x_fnar_message_73,
x_fnar_message_74 => x_fnar_message_74,
x_fnar_message_75 => x_fnar_message_75,
x_fnar_message_76 => x_fnar_message_76,
x_fnar_message_77 => x_fnar_message_77,
x_fnar_message_78 => x_fnar_message_78,
x_fnar_mesg_10_stu_fam_mem => x_fnar_mesg_10_stu_fam_mem,
x_fnar_mesg_11_stu_no_in_coll => x_fnar_mesg_11_stu_no_in_coll,
x_fnar_mesg_24_stu_avail_inc => x_fnar_mesg_24_stu_avail_inc,
x_fnar_mesg_26_stu_taxes => x_fnar_mesg_26_stu_taxes,
x_fnar_mesg_33_stu_home_value => x_fnar_mesg_33_stu_home_value,
x_fnar_mesg_34_stu_home_value => x_fnar_mesg_34_stu_home_value,
x_fnar_mesg_34_stu_home_equity => x_fnar_mesg_34_stu_home_equity,
x_fnar_mesg_35_stu_home_value => x_fnar_mesg_35_stu_home_value,
x_fnar_mesg_35_stu_home_equity => x_fnar_mesg_35_stu_home_equity,
x_fnar_mesg_36_stu_home_equity => x_fnar_mesg_36_stu_home_equity,
x_fnar_mesg_48_par_fam_mem => x_fnar_mesg_48_par_fam_mem,
x_fnar_mesg_49_par_no_in_coll => x_fnar_mesg_49_par_no_in_coll,
x_fnar_mesg_56_par_agi => x_fnar_mesg_56_par_agi,
x_fnar_mesg_62_par_taxes => x_fnar_mesg_62_par_taxes,
x_fnar_mesg_73_par_home_value => x_fnar_mesg_73_par_home_value,
x_fnar_mesg_74_par_home_value => x_fnar_mesg_74_par_home_value,
x_fnar_mesg_74_par_home_equity => x_fnar_mesg_74_par_home_equity,
x_fnar_mesg_75_par_home_value => x_fnar_mesg_75_par_home_value,
x_fnar_mesg_75_par_home_equity => x_fnar_mesg_75_par_home_equity,
x_fnar_mesg_76_par_home_equity => x_fnar_mesg_76_par_home_equity,
x_assumption_message_1 => x_assumption_message_1,
x_assumption_message_2 => x_assumption_message_2,
x_assumption_message_3 => x_assumption_message_3,
x_assumption_message_4 => x_assumption_message_4,
x_assumption_message_5 => x_assumption_message_5,
x_assumption_message_6 => x_assumption_message_6,
x_record_mark => x_record_mark,
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_fnar_message_55 => x_fnar_message_55,
x_fnar_message_49 => x_fnar_message_49,
x_opt_par_cola_adj_ind => x_opt_par_cola_adj_ind,
x_opt_par_stu_fa_assets_ind => x_opt_par_stu_fa_assets_ind,
x_opt_par_ipt_assets_ind => x_opt_par_ipt_assets_ind,
x_opt_stu_ipt_assets_ind => x_opt_stu_ipt_assets_ind,
x_opt_par_cola_adj_value => x_opt_par_cola_adj_value,
x_legacy_record_flag => x_legacy_record_flag,
x_opt_ind_stu_ipt_assets_flag => x_opt_ind_stu_ipt_assets_flag,
x_cust_parent_cont_adj_num => x_cust_parent_cont_adj_num,
x_custodial_parent_num => x_custodial_parent_num,
x_cust_par_base_prcnt_inc_amt => x_cust_par_base_prcnt_inc_amt,
x_cust_par_base_cont_inc_amt => x_cust_par_base_cont_inc_amt,
x_cust_par_base_cont_ast_amt => x_cust_par_base_cont_ast_amt,
x_cust_par_base_tot_cont_amt => x_cust_par_base_tot_cont_amt ,
x_cust_par_opt_prcnt_inc_amt => x_cust_par_opt_prcnt_inc_amt,
x_cust_par_opt_cont_inc_amt => x_cust_par_opt_cont_inc_amt,
x_cust_par_opt_cont_ast_amt => x_cust_par_opt_cont_ast_amt,
x_cust_par_opt_tot_cont_amt => x_cust_par_opt_tot_cont_amt,
x_parents_email_txt => x_parents_email_txt,
x_parent_1_birth_date => x_parent_1_birth_date,
x_parent_2_birth_date => x_parent_2_birth_date
);
INSERT INTO igf_ap_css_fnar_all (
fnar_id,
cssp_id,
org_id,
r_s_email_address,
eps_code,
comp_css_dependency_status,
stu_age,
assumed_stu_yr_in_coll,
comp_stu_marital_status,
stu_family_members,
stu_fam_members_in_college,
par_marital_status,
par_family_members,
par_total_in_college,
par_par_in_college,
par_others_in_college,
par_aesa,
par_cesa,
stu_aesa,
stu_cesa,
im_p_bas_agi_taxable_income,
im_p_bas_untx_inc_and_ben,
im_p_bas_inc_adj,
im_p_bas_total_income,
im_p_bas_us_income_tax,
im_p_bas_st_and_other_tax,
im_p_bas_fica_tax,
im_p_bas_med_dental,
im_p_bas_employment_allow,
im_p_bas_annual_ed_savings,
im_p_bas_inc_prot_allow_m,
im_p_bas_total_inc_allow,
im_p_bas_cal_avail_inc,
im_p_bas_avail_income,
im_p_bas_total_cont_inc,
im_p_bas_cash_bank_accounts,
im_p_bas_home_equity,
im_p_bas_ot_rl_est_inv_eq,
im_p_bas_adj_bus_farm_worth,
im_p_bas_ass_sibs_pre_tui,
im_p_bas_net_worth,
im_p_bas_emerg_res_allow,
im_p_bas_cum_ed_savings,
im_p_bas_low_inc_allow,
im_p_bas_total_asset_allow,
im_p_bas_disc_net_worth,
im_p_bas_total_cont_asset,
im_p_bas_total_cont,
im_p_bas_num_in_coll_adj,
im_p_bas_cont_for_stu,
im_p_bas_cont_from_income,
im_p_bas_cont_from_assets,
im_p_opt_agi_taxable_income,
im_p_opt_untx_inc_and_ben,
im_p_opt_inc_adj,
im_p_opt_total_income,
im_p_opt_us_income_tax,
im_p_opt_st_and_other_tax,
im_p_opt_fica_tax,
im_p_opt_med_dental,
im_p_opt_elem_sec_tuit,
im_p_opt_employment_allow,
im_p_opt_annual_ed_savings,
im_p_opt_inc_prot_allow_m,
im_p_opt_total_inc_allow,
im_p_opt_cal_avail_inc,
im_p_opt_avail_income,
im_p_opt_total_cont_inc,
im_p_opt_cash_bank_accounts,
im_p_opt_home_equity,
im_p_opt_ot_rl_est_inv_eq,
im_p_opt_adj_bus_farm_worth,
im_p_opt_ass_sibs_pre_tui,
im_p_opt_net_worth,
im_p_opt_emerg_res_allow,
im_p_opt_cum_ed_savings,
im_p_opt_low_inc_allow,
im_p_opt_total_asset_allow,
im_p_opt_disc_net_worth,
im_p_opt_total_cont_asset,
im_p_opt_total_cont,
im_p_opt_num_in_coll_adj,
im_p_opt_cont_for_stu,
im_p_opt_cont_from_income,
im_p_opt_cont_from_assets,
fm_p_analysis_type,
fm_p_agi_taxable_income,
fm_p_untx_inc_and_ben,
fm_p_inc_adj,
fm_p_total_income,
fm_p_us_income_tax,
fm_p_state_and_other_taxes,
fm_p_fica_tax,
fm_p_employment_allow,
fm_p_income_prot_allow,
fm_p_total_allow,
fm_p_avail_income,
fm_p_cash_bank_accounts,
fm_p_ot_rl_est_inv_equity,
fm_p_adj_bus_farm_net_worth,
fm_p_net_worth,
fm_p_asset_prot_allow,
fm_p_disc_net_worth,
fm_p_total_contribution,
fm_p_num_in_coll,
fm_p_cont_for_stu,
fm_p_cont_from_income,
fm_p_cont_from_assets,
im_s_bas_agi_taxable_income,
im_s_bas_untx_inc_and_ben,
im_s_bas_inc_adj,
im_s_bas_total_income,
im_s_bas_us_income_tax,
im_s_bas_state_and_oth_taxes,
im_s_bas_fica_tax,
im_s_bas_med_dental,
im_s_bas_employment_allow,
im_s_bas_annual_ed_savings,
im_s_bas_inc_prot_allow_m,
im_s_bas_total_inc_allow,
im_s_bas_cal_avail_income,
im_s_bas_avail_income,
im_s_bas_total_cont_inc,
im_s_bas_cash_bank_accounts,
im_s_bas_home_equity,
im_s_bas_ot_rl_est_inv_eq,
im_s_bas_adj_busfarm_worth,
im_s_bas_trusts,
im_s_bas_net_worth,
im_s_bas_emerg_res_allow,
im_s_bas_cum_ed_savings,
im_s_bas_total_asset_allow,
im_s_bas_disc_net_worth,
im_s_bas_total_cont_asset,
im_s_bas_total_cont,
im_s_bas_num_in_coll_adj,
im_s_bas_cont_for_stu,
im_s_bas_cont_from_income,
im_s_bas_cont_from_assets,
im_s_est_agitaxable_income,
im_s_est_untx_inc_and_ben,
im_s_est_inc_adj,
im_s_est_total_income,
im_s_est_us_income_tax,
im_s_est_state_and_oth_taxes,
im_s_est_fica_tax,
im_s_est_med_dental,
im_s_est_employment_allow,
im_s_est_annual_ed_savings,
im_s_est_inc_prot_allow_m,
im_s_est_total_inc_allow,
im_s_est_cal_avail_income,
im_s_est_avail_income,
im_s_est_total_cont_inc,
im_s_est_cash_bank_accounts,
im_s_est_home_equity,
im_s_est_ot_rl_est_inv_eq,
im_s_est_adj_bus_farm_worth,
im_s_est_est_trusts,
im_s_est_net_worth,
im_s_est_emerg_res_allow,
im_s_est_cum_ed_savings,
im_s_est_total_asset_allow,
im_s_est_disc_net_worth,
im_s_est_total_cont_asset,
im_s_est_total_cont,
im_s_est_num_in_coll_adj,
im_s_est_cont_for_stu,
im_s_est_cont_from_income,
im_s_est_cont_from_assets,
im_s_opt_agi_taxable_income,
im_s_opt_untx_inc_and_ben,
im_s_opt_inc_adj,
im_s_opt_total_income,
im_s_opt_us_income_tax,
im_s_opt_state_and_oth_taxes,
im_s_opt_fica_tax,
im_s_opt_med_dental,
im_s_opt_employment_allow,
im_s_opt_annual_ed_savings,
im_s_opt_inc_prot_allow_m,
im_s_opt_total_inc_allow,
im_s_opt_cal_avail_income,
im_s_opt_avail_income,
im_s_opt_total_cont_inc,
im_s_opt_cash_bank_accounts,
im_s_opt_ira_keogh_accounts,
im_s_opt_home_equity,
im_s_opt_ot_rl_est_inv_eq,
im_s_opt_adj_bus_farm_worth,
im_s_opt_trusts,
im_s_opt_net_worth,
im_s_opt_emerg_res_allow,
im_s_opt_cum_ed_savings,
im_s_opt_total_asset_allow,
im_s_opt_disc_net_worth,
im_s_opt_total_cont_asset,
im_s_opt_total_cont,
im_s_opt_num_in_coll_adj,
im_s_opt_cont_for_stu,
im_s_opt_cont_from_income,
im_s_opt_cont_from_assets,
fm_s_analysis_type,
fm_s_agi_taxable_income,
fm_s_untx_inc_and_ben,
fm_s_inc_adj,
fm_s_total_income,
fm_s_us_income_tax,
fm_s_state_and_oth_taxes,
fm_s_fica_tax,
fm_s_employment_allow,
fm_s_income_prot_allow,
fm_s_total_allow,
fm_s_cal_avail_income,
fm_s_avail_income,
fm_s_cash_bank_accounts,
fm_s_ot_rl_est_inv_equity,
fm_s_adj_bus_farm_worth,
fm_s_trusts,
fm_s_net_worth,
fm_s_asset_prot_allow,
fm_s_disc_net_worth,
fm_s_total_cont,
fm_s_num_in_coll,
fm_s_cont_for_stu,
fm_s_cont_from_income,
fm_s_cont_from_assets,
im_inst_resident_ind,
institutional_1_budget_name,
im_inst_1_budget_duration,
im_inst_1_tuition_fees,
im_inst_1_books_supplies,
im_inst_1_living_expenses,
im_inst_1_tot_expenses,
im_inst_1_tot_stu_cont,
im_inst_1_tot_par_cont,
im_inst_1_tot_family_cont,
im_inst_1_va_benefits,
im_inst_1_ot_cont,
im_inst_1_est_financial_need,
institutional_2_budget_name,
im_inst_2_budget_duration,
im_inst_2_tuition_fees,
im_inst_2_books_supplies,
im_inst_2_living_expenses,
im_inst_2_tot_expenses,
im_inst_2_tot_stu_cont,
im_inst_2_tot_par_cont,
im_inst_2_tot_family_cont,
im_inst_2_va_benefits,
im_inst_2_est_financial_need,
institutional_3_budget_name,
im_inst_3_budget_duration,
im_inst_3_tuition_fees,
im_inst_3_books_supplies,
im_inst_3_living_expenses,
im_inst_3_tot_expenses,
im_inst_3_tot_stu_cont,
im_inst_3_tot_par_cont,
im_inst_3_tot_family_cont,
im_inst_3_va_benefits,
im_inst_3_est_financial_need,
fm_inst_1_federal_efc,
fm_inst_1_va_benefits,
fm_inst_1_fed_eligibility,
fm_inst_1_pell,
option_par_loss_allow_ind,
option_par_tuition_ind,
option_par_home_ind,
option_par_home_value,
option_par_home_debt,
option_stu_ira_keogh_ind,
option_stu_home_ind,
option_stu_home_value,
option_stu_home_debt,
option_stu_sum_ay_inc_ind,
option_par_hope_ll_credit,
option_stu_hope_ll_credit,
im_parent_1_8_months_bas,
im_p_more_than_9_mth_ba,
im_parent_1_8_months_opt,
im_p_more_than_9_mth_op,
fnar_message_1,
fnar_message_2,
fnar_message_3,
fnar_message_4,
fnar_message_5,
fnar_message_6,
fnar_message_7,
fnar_message_8,
fnar_message_9,
fnar_message_10,
fnar_message_11,
fnar_message_12,
fnar_message_13,
fnar_message_20,
fnar_message_21,
fnar_message_22,
fnar_message_23,
fnar_message_24,
fnar_message_25,
fnar_message_26,
fnar_message_27,
fnar_message_30,
fnar_message_31,
fnar_message_32,
fnar_message_33,
fnar_message_34,
fnar_message_35,
fnar_message_36,
fnar_message_37,
fnar_message_38,
fnar_message_39,
fnar_message_45,
fnar_message_46,
fnar_message_47,
fnar_message_48,
fnar_message_50,
fnar_message_51,
fnar_message_52,
fnar_message_53,
fnar_message_56,
fnar_message_57,
fnar_message_58,
fnar_message_59,
fnar_message_60,
fnar_message_61,
fnar_message_62,
fnar_message_63,
fnar_message_64,
fnar_message_65,
fnar_message_71,
fnar_message_72,
fnar_message_73,
fnar_message_74,
fnar_message_75,
fnar_message_76,
fnar_message_77,
fnar_message_78,
fnar_mesg_10_stu_fam_mem,
fnar_mesg_11_stu_no_in_coll,
fnar_mesg_24_stu_avail_inc,
fnar_mesg_26_stu_taxes,
fnar_mesg_33_stu_home_value,
fnar_mesg_34_stu_home_value,
fnar_mesg_34_stu_home_equity,
fnar_mesg_35_stu_home_value,
fnar_mesg_35_stu_home_equity,
fnar_mesg_36_stu_home_equity,
fnar_mesg_48_par_fam_mem,
fnar_mesg_49_par_no_in_coll,
fnar_mesg_56_par_agi,
fnar_mesg_62_par_taxes,
fnar_mesg_73_par_home_value,
fnar_mesg_74_par_home_value,
fnar_mesg_74_par_home_equity,
fnar_mesg_75_par_home_value,
fnar_mesg_75_par_home_equity,
fnar_mesg_76_par_home_equity,
assumption_message_1,
assumption_message_2,
assumption_message_3,
assumption_message_4,
assumption_message_5,
assumption_message_6,
record_mark,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
fnar_message_55,
fnar_message_49,
option_par_cola_adj_ind,
option_par_stu_fa_assets_ind,
option_par_ipt_assets_ind,
option_stu_ipt_assets_ind,
option_par_cola_adj_value,
legacy_record_flag,
option_ind_stu_ipt_assets_flag,
cust_parent_cont_adj_num,
custodial_parent_num,
cust_par_base_prcnt_inc_amt,
cust_par_base_cont_inc_amt,
cust_par_base_cont_ast_amt,
cust_par_base_tot_cont_amt,
cust_par_opt_prcnt_inc_amt,
cust_par_opt_cont_inc_amt,
cust_par_opt_cont_ast_amt,
cust_par_opt_tot_cont_amt,
parents_email_txt,
parent_1_birth_date,
parent_2_birth_date
) VALUES (
new_references.fnar_id,
new_references.cssp_id,
new_references.org_id,
new_references.r_s_email_address,
new_references.eps_code,
new_references.comp_css_dependency_status,
new_references.stu_age,
new_references.assumed_stu_yr_in_coll,
new_references.comp_stu_marital_status,
new_references.stu_family_members,
new_references.stu_fam_members_in_college,
new_references.par_marital_status,
new_references.par_family_members,
new_references.par_total_in_college,
new_references.par_par_in_college,
new_references.par_others_in_college,
new_references.par_aesa,
new_references.par_cesa,
new_references.stu_aesa,
new_references.stu_cesa,
new_references.im_p_bas_agi_taxable_income,
new_references.im_p_bas_untx_inc_and_ben,
new_references.im_p_bas_inc_adj,
new_references.im_p_bas_total_income,
new_references.im_p_bas_us_income_tax,
new_references.im_p_bas_st_and_other_tax,
new_references.im_p_bas_fica_tax,
new_references.im_p_bas_med_dental,
new_references.im_p_bas_employment_allow,
new_references.im_p_bas_annual_ed_savings,
new_references.im_p_bas_inc_prot_allow_m,
new_references.im_p_bas_total_inc_allow,
new_references.im_p_bas_cal_avail_inc,
new_references.im_p_bas_avail_income,
new_references.im_p_bas_total_cont_inc,
new_references.im_p_bas_cash_bank_accounts,
new_references.im_p_bas_home_equity,
new_references.im_p_bas_ot_rl_est_inv_eq,
new_references.im_p_bas_adj_bus_farm_worth,
new_references.im_p_bas_ass_sibs_pre_tui,
new_references.im_p_bas_net_worth,
new_references.im_p_bas_emerg_res_allow,
new_references.im_p_bas_cum_ed_savings,
new_references.im_p_bas_low_inc_allow,
new_references.im_p_bas_total_asset_allow,
new_references.im_p_bas_disc_net_worth,
new_references.im_p_bas_total_cont_asset,
new_references.im_p_bas_total_cont,
new_references.im_p_bas_num_in_coll_adj,
new_references.im_p_bas_cont_for_stu,
new_references.im_p_bas_cont_from_income,
new_references.im_p_bas_cont_from_assets,
new_references.im_p_opt_agi_taxable_income,
new_references.im_p_opt_untx_inc_and_ben,
new_references.im_p_opt_inc_adj,
new_references.im_p_opt_total_income,
new_references.im_p_opt_us_income_tax,
new_references.im_p_opt_st_and_other_tax,
new_references.im_p_opt_fica_tax,
new_references.im_p_opt_med_dental,
new_references.im_p_opt_elem_sec_tuit,
new_references.im_p_opt_employment_allow,
new_references.im_p_opt_annual_ed_savings,
new_references.im_p_opt_inc_prot_allow_m,
new_references.im_p_opt_total_inc_allow,
new_references.im_p_opt_cal_avail_inc,
new_references.im_p_opt_avail_income,
new_references.im_p_opt_total_cont_inc,
new_references.im_p_opt_cash_bank_accounts,
new_references.im_p_opt_home_equity,
new_references.im_p_opt_ot_rl_est_inv_eq,
new_references.im_p_opt_adj_bus_farm_worth,
new_references.im_p_opt_ass_sibs_pre_tui,
new_references.im_p_opt_net_worth,
new_references.im_p_opt_emerg_res_allow,
new_references.im_p_opt_cum_ed_savings,
new_references.im_p_opt_low_inc_allow,
new_references.im_p_opt_total_asset_allow,
new_references.im_p_opt_disc_net_worth,
new_references.im_p_opt_total_cont_asset,
new_references.im_p_opt_total_cont,
new_references.im_p_opt_num_in_coll_adj,
new_references.im_p_opt_cont_for_stu,
new_references.im_p_opt_cont_from_income,
new_references.im_p_opt_cont_from_assets,
new_references.fm_p_analysis_type,
new_references.fm_p_agi_taxable_income,
new_references.fm_p_untx_inc_and_ben,
new_references.fm_p_inc_adj,
new_references.fm_p_total_income,
new_references.fm_p_us_income_tax,
new_references.fm_p_state_and_other_taxes,
new_references.fm_p_fica_tax,
new_references.fm_p_employment_allow,
new_references.fm_p_income_prot_allow,
new_references.fm_p_total_allow,
new_references.fm_p_avail_income,
new_references.fm_p_cash_bank_accounts,
new_references.fm_p_ot_rl_est_inv_equity,
new_references.fm_p_adj_bus_farm_net_worth,
new_references.fm_p_net_worth,
new_references.fm_p_asset_prot_allow,
new_references.fm_p_disc_net_worth,
new_references.fm_p_total_contribution,
new_references.fm_p_num_in_coll,
new_references.fm_p_cont_for_stu,
new_references.fm_p_cont_from_income,
new_references.fm_p_cont_from_assets,
new_references.im_s_bas_agi_taxable_income,
new_references.im_s_bas_untx_inc_and_ben,
new_references.im_s_bas_inc_adj,
new_references.im_s_bas_total_income,
new_references.im_s_bas_us_income_tax,
new_references.im_s_bas_state_and_oth_taxes,
new_references.im_s_bas_fica_tax,
new_references.im_s_bas_med_dental,
new_references.im_s_bas_employment_allow,
new_references.im_s_bas_annual_ed_savings,
new_references.im_s_bas_inc_prot_allow_m,
new_references.im_s_bas_total_inc_allow,
new_references.im_s_bas_cal_avail_income,
new_references.im_s_bas_avail_income,
new_references.im_s_bas_total_cont_inc,
new_references.im_s_bas_cash_bank_accounts,
new_references.im_s_bas_home_equity,
new_references.im_s_bas_ot_rl_est_inv_eq,
new_references.im_s_bas_adj_busfarm_worth,
new_references.im_s_bas_trusts,
new_references.im_s_bas_net_worth,
new_references.im_s_bas_emerg_res_allow,
new_references.im_s_bas_cum_ed_savings,
new_references.im_s_bas_total_asset_allow,
new_references.im_s_bas_disc_net_worth,
new_references.im_s_bas_total_cont_asset,
new_references.im_s_bas_total_cont,
new_references.im_s_bas_num_in_coll_adj,
new_references.im_s_bas_cont_for_stu,
new_references.im_s_bas_cont_from_income,
new_references.im_s_bas_cont_from_assets,
new_references.im_s_est_agitaxable_income,
new_references.im_s_est_untx_inc_and_ben,
new_references.im_s_est_inc_adj,
new_references.im_s_est_total_income,
new_references.im_s_est_us_income_tax,
new_references.im_s_est_state_and_oth_taxes,
new_references.im_s_est_fica_tax,
new_references.im_s_est_med_dental,
new_references.im_s_est_employment_allow,
new_references.im_s_est_annual_ed_savings,
new_references.im_s_est_inc_prot_allow_m,
new_references.im_s_est_total_inc_allow,
new_references.im_s_est_cal_avail_income,
new_references.im_s_est_avail_income,
new_references.im_s_est_total_cont_inc,
new_references.im_s_est_cash_bank_accounts,
new_references.im_s_est_home_equity,
new_references.im_s_est_ot_rl_est_inv_eq,
new_references.im_s_est_adj_bus_farm_worth,
new_references.im_s_est_est_trusts,
new_references.im_s_est_net_worth,
new_references.im_s_est_emerg_res_allow,
new_references.im_s_est_cum_ed_savings,
new_references.im_s_est_total_asset_allow,
new_references.im_s_est_disc_net_worth,
new_references.im_s_est_total_cont_asset,
new_references.im_s_est_total_cont,
new_references.im_s_est_num_in_coll_adj,
new_references.im_s_est_cont_for_stu,
new_references.im_s_est_cont_from_income,
new_references.im_s_est_cont_from_assets,
new_references.im_s_opt_agi_taxable_income,
new_references.im_s_opt_untx_inc_and_ben,
new_references.im_s_opt_inc_adj,
new_references.im_s_opt_total_income,
new_references.im_s_opt_us_income_tax,
new_references.im_s_opt_state_and_oth_taxes,
new_references.im_s_opt_fica_tax,
new_references.im_s_opt_med_dental,
new_references.im_s_opt_employment_allow,
new_references.im_s_opt_annual_ed_savings,
new_references.im_s_opt_inc_prot_allow_m,
new_references.im_s_opt_total_inc_allow,
new_references.im_s_opt_cal_avail_income,
new_references.im_s_opt_avail_income,
new_references.im_s_opt_total_cont_inc,
new_references.im_s_opt_cash_bank_accounts,
new_references.im_s_opt_ira_keogh_accounts,
new_references.im_s_opt_home_equity,
new_references.im_s_opt_ot_rl_est_inv_eq,
new_references.im_s_opt_adj_bus_farm_worth,
new_references.im_s_opt_trusts,
new_references.im_s_opt_net_worth,
new_references.im_s_opt_emerg_res_allow,
new_references.im_s_opt_cum_ed_savings,
new_references.im_s_opt_total_asset_allow,
new_references.im_s_opt_disc_net_worth,
new_references.im_s_opt_total_cont_asset,
new_references.im_s_opt_total_cont,
new_references.im_s_opt_num_in_coll_adj,
new_references.im_s_opt_cont_for_stu,
new_references.im_s_opt_cont_from_income,
new_references.im_s_opt_cont_from_assets,
new_references.fm_s_analysis_type,
new_references.fm_s_agi_taxable_income,
new_references.fm_s_untx_inc_and_ben,
new_references.fm_s_inc_adj,
new_references.fm_s_total_income,
new_references.fm_s_us_income_tax,
new_references.fm_s_state_and_oth_taxes,
new_references.fm_s_fica_tax,
new_references.fm_s_employment_allow,
new_references.fm_s_income_prot_allow,
new_references.fm_s_total_allow,
new_references.fm_s_cal_avail_income,
new_references.fm_s_avail_income,
new_references.fm_s_cash_bank_accounts,
new_references.fm_s_ot_rl_est_inv_equity,
new_references.fm_s_adj_bus_farm_worth,
new_references.fm_s_trusts,
new_references.fm_s_net_worth,
new_references.fm_s_asset_prot_allow,
new_references.fm_s_disc_net_worth,
new_references.fm_s_total_cont,
new_references.fm_s_num_in_coll,
new_references.fm_s_cont_for_stu,
new_references.fm_s_cont_from_income,
new_references.fm_s_cont_from_assets,
new_references.im_inst_resident_ind,
new_references.institutional_1_budget_name,
new_references.im_inst_1_budget_duration,
new_references.im_inst_1_tuition_fees,
new_references.im_inst_1_books_supplies,
new_references.im_inst_1_living_expenses,
new_references.im_inst_1_tot_expenses,
new_references.im_inst_1_tot_stu_cont,
new_references.im_inst_1_tot_par_cont,
new_references.im_inst_1_tot_family_cont,
new_references.im_inst_1_va_benefits,
new_references.im_inst_1_ot_cont,
new_references.im_inst_1_est_financial_need,
new_references.institutional_2_budget_name,
new_references.im_inst_2_budget_duration,
new_references.im_inst_2_tuition_fees,
new_references.im_inst_2_books_supplies,
new_references.im_inst_2_living_expenses,
new_references.im_inst_2_tot_expenses,
new_references.im_inst_2_tot_stu_cont,
new_references.im_inst_2_tot_par_cont,
new_references.im_inst_2_tot_family_cont,
new_references.im_inst_2_va_benefits,
new_references.im_inst_2_est_financial_need,
new_references.institutional_3_budget_name,
new_references.im_inst_3_budget_duration,
new_references.im_inst_3_tuition_fees,
new_references.im_inst_3_books_supplies,
new_references.im_inst_3_living_expenses,
new_references.im_inst_3_tot_expenses,
new_references.im_inst_3_tot_stu_cont,
new_references.im_inst_3_tot_par_cont,
new_references.im_inst_3_tot_family_cont,
new_references.im_inst_3_va_benefits,
new_references.im_inst_3_est_financial_need,
new_references.fm_inst_1_federal_efc,
new_references.fm_inst_1_va_benefits,
new_references.fm_inst_1_fed_eligibility,
new_references.fm_inst_1_pell,
new_references.option_par_loss_allow_ind,
new_references.option_par_tuition_ind,
new_references.option_par_home_ind,
new_references.option_par_home_value,
new_references.option_par_home_debt,
new_references.option_stu_ira_keogh_ind,
new_references.option_stu_home_ind,
new_references.option_stu_home_value,
new_references.option_stu_home_debt,
new_references.option_stu_sum_ay_inc_ind,
new_references.option_par_hope_ll_credit,
new_references.option_stu_hope_ll_credit,
new_references.im_parent_1_8_months_bas,
new_references.im_p_more_than_9_mth_ba,
new_references.im_parent_1_8_months_opt,
new_references.im_p_more_than_9_mth_op,
new_references.fnar_message_1,
new_references.fnar_message_2,
new_references.fnar_message_3,
new_references.fnar_message_4,
new_references.fnar_message_5,
new_references.fnar_message_6,
new_references.fnar_message_7,
new_references.fnar_message_8,
new_references.fnar_message_9,
new_references.fnar_message_10,
new_references.fnar_message_11,
new_references.fnar_message_12,
new_references.fnar_message_13,
new_references.fnar_message_20,
new_references.fnar_message_21,
new_references.fnar_message_22,
new_references.fnar_message_23,
new_references.fnar_message_24,
new_references.fnar_message_25,
new_references.fnar_message_26,
new_references.fnar_message_27,
new_references.fnar_message_30,
new_references.fnar_message_31,
new_references.fnar_message_32,
new_references.fnar_message_33,
new_references.fnar_message_34,
new_references.fnar_message_35,
new_references.fnar_message_36,
new_references.fnar_message_37,
new_references.fnar_message_38,
new_references.fnar_message_39,
new_references.fnar_message_45,
new_references.fnar_message_46,
new_references.fnar_message_47,
new_references.fnar_message_48,
new_references.fnar_message_50,
new_references.fnar_message_51,
new_references.fnar_message_52,
new_references.fnar_message_53,
new_references.fnar_message_56,
new_references.fnar_message_57,
new_references.fnar_message_58,
new_references.fnar_message_59,
new_references.fnar_message_60,
new_references.fnar_message_61,
new_references.fnar_message_62,
new_references.fnar_message_63,
new_references.fnar_message_64,
new_references.fnar_message_65,
new_references.fnar_message_71,
new_references.fnar_message_72,
new_references.fnar_message_73,
new_references.fnar_message_74,
new_references.fnar_message_75,
new_references.fnar_message_76,
new_references.fnar_message_77,
new_references.fnar_message_78,
new_references.fnar_mesg_10_stu_fam_mem,
new_references.fnar_mesg_11_stu_no_in_coll,
new_references.fnar_mesg_24_stu_avail_inc,
new_references.fnar_mesg_26_stu_taxes,
new_references.fnar_mesg_33_stu_home_value,
new_references.fnar_mesg_34_stu_home_value,
new_references.fnar_mesg_34_stu_home_equity,
new_references.fnar_mesg_35_stu_home_value,
new_references.fnar_mesg_35_stu_home_equity,
new_references.fnar_mesg_36_stu_home_equity,
new_references.fnar_mesg_48_par_fam_mem,
new_references.fnar_mesg_49_par_no_in_coll,
new_references.fnar_mesg_56_par_agi,
new_references.fnar_mesg_62_par_taxes,
new_references.fnar_mesg_73_par_home_value,
new_references.fnar_mesg_74_par_home_value,
new_references.fnar_mesg_74_par_home_equity,
new_references.fnar_mesg_75_par_home_value,
new_references.fnar_mesg_75_par_home_equity,
new_references.fnar_mesg_76_par_home_equity,
new_references.assumption_message_1,
new_references.assumption_message_2,
new_references.assumption_message_3,
new_references.assumption_message_4,
new_references.assumption_message_5,
new_references.assumption_message_6,
new_references.record_mark,
x_last_update_date,
x_last_updated_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
new_references.fnar_message_55,
new_references.fnar_message_49,
new_references.option_par_cola_adj_ind,
new_references.option_par_stu_fa_assets_ind,
new_references.option_par_ipt_assets_ind,
new_references.option_stu_ipt_assets_ind,
new_references.option_par_cola_adj_value,
new_references.legacy_record_flag,
new_references.option_ind_stu_ipt_assets_flag,
new_references.cust_parent_cont_adj_num,
new_references.custodial_parent_num,
new_references.cust_par_base_prcnt_inc_amt,
new_references.cust_par_base_cont_inc_amt,
new_references.cust_par_base_cont_ast_amt,
new_references.cust_par_base_tot_cont_amt,
new_references.cust_par_opt_prcnt_inc_amt,
new_references.cust_par_opt_cont_inc_amt,
new_references.cust_par_opt_cont_ast_amt,
new_references.cust_par_opt_tot_cont_amt,
new_references.parents_email_txt,
new_references.parent_1_birth_date,
new_references.parent_2_birth_date
);
END insert_row;
SELECT
cssp_id,
r_s_email_address,
eps_code,
comp_css_dependency_status,
stu_age,
assumed_stu_yr_in_coll,
comp_stu_marital_status,
stu_family_members,
stu_fam_members_in_college,
par_marital_status,
par_family_members,
par_total_in_college,
par_par_in_college,
par_others_in_college,
par_aesa,
par_cesa,
stu_aesa,
stu_cesa,
im_p_bas_agi_taxable_income,
im_p_bas_untx_inc_and_ben,
im_p_bas_inc_adj,
im_p_bas_total_income,
im_p_bas_us_income_tax,
im_p_bas_st_and_other_tax,
im_p_bas_fica_tax,
im_p_bas_med_dental,
im_p_bas_employment_allow,
im_p_bas_annual_ed_savings,
im_p_bas_inc_prot_allow_m,
im_p_bas_total_inc_allow,
im_p_bas_cal_avail_inc,
im_p_bas_avail_income,
im_p_bas_total_cont_inc,
im_p_bas_cash_bank_accounts,
im_p_bas_home_equity,
im_p_bas_ot_rl_est_inv_eq,
im_p_bas_adj_bus_farm_worth,
im_p_bas_ass_sibs_pre_tui,
im_p_bas_net_worth,
im_p_bas_emerg_res_allow,
im_p_bas_cum_ed_savings,
im_p_bas_low_inc_allow,
im_p_bas_total_asset_allow,
im_p_bas_disc_net_worth,
im_p_bas_total_cont_asset,
im_p_bas_total_cont,
im_p_bas_num_in_coll_adj,
im_p_bas_cont_for_stu,
im_p_bas_cont_from_income,
im_p_bas_cont_from_assets,
im_p_opt_agi_taxable_income,
im_p_opt_untx_inc_and_ben,
im_p_opt_inc_adj,
im_p_opt_total_income,
im_p_opt_us_income_tax,
im_p_opt_st_and_other_tax,
im_p_opt_fica_tax,
im_p_opt_med_dental,
im_p_opt_elem_sec_tuit,
im_p_opt_employment_allow,
im_p_opt_annual_ed_savings,
im_p_opt_inc_prot_allow_m,
im_p_opt_total_inc_allow,
im_p_opt_cal_avail_inc,
im_p_opt_avail_income,
im_p_opt_total_cont_inc,
im_p_opt_cash_bank_accounts,
im_p_opt_home_equity,
im_p_opt_ot_rl_est_inv_eq,
im_p_opt_adj_bus_farm_worth,
im_p_opt_ass_sibs_pre_tui,
im_p_opt_net_worth,
im_p_opt_emerg_res_allow,
im_p_opt_cum_ed_savings,
im_p_opt_low_inc_allow,
im_p_opt_total_asset_allow,
im_p_opt_disc_net_worth,
im_p_opt_total_cont_asset,
im_p_opt_total_cont,
im_p_opt_num_in_coll_adj,
im_p_opt_cont_for_stu,
im_p_opt_cont_from_income,
im_p_opt_cont_from_assets,
fm_p_analysis_type,
fm_p_agi_taxable_income,
fm_p_untx_inc_and_ben,
fm_p_inc_adj,
fm_p_total_income,
fm_p_us_income_tax,
fm_p_state_and_other_taxes,
fm_p_fica_tax,
fm_p_employment_allow,
fm_p_income_prot_allow,
fm_p_total_allow,
fm_p_avail_income,
fm_p_cash_bank_accounts,
fm_p_ot_rl_est_inv_equity,
fm_p_adj_bus_farm_net_worth,
fm_p_net_worth,
fm_p_asset_prot_allow,
fm_p_disc_net_worth,
fm_p_total_contribution,
fm_p_num_in_coll,
fm_p_cont_for_stu,
fm_p_cont_from_income,
fm_p_cont_from_assets,
im_s_bas_agi_taxable_income,
im_s_bas_untx_inc_and_ben,
im_s_bas_inc_adj,
im_s_bas_total_income,
im_s_bas_us_income_tax,
im_s_bas_state_and_oth_taxes,
im_s_bas_fica_tax,
im_s_bas_med_dental,
im_s_bas_employment_allow,
im_s_bas_annual_ed_savings,
im_s_bas_inc_prot_allow_m,
im_s_bas_total_inc_allow,
im_s_bas_cal_avail_income,
im_s_bas_avail_income,
im_s_bas_total_cont_inc,
im_s_bas_cash_bank_accounts,
im_s_bas_home_equity,
im_s_bas_ot_rl_est_inv_eq,
im_s_bas_adj_busfarm_worth,
im_s_bas_trusts,
im_s_bas_net_worth,
im_s_bas_emerg_res_allow,
im_s_bas_cum_ed_savings,
im_s_bas_total_asset_allow,
im_s_bas_disc_net_worth,
im_s_bas_total_cont_asset,
im_s_bas_total_cont,
im_s_bas_num_in_coll_adj,
im_s_bas_cont_for_stu,
im_s_bas_cont_from_income,
im_s_bas_cont_from_assets,
im_s_est_agitaxable_income,
im_s_est_untx_inc_and_ben,
im_s_est_inc_adj,
im_s_est_total_income,
im_s_est_us_income_tax,
im_s_est_state_and_oth_taxes,
im_s_est_fica_tax,
im_s_est_med_dental,
im_s_est_employment_allow,
im_s_est_annual_ed_savings,
im_s_est_inc_prot_allow_m,
im_s_est_total_inc_allow,
im_s_est_cal_avail_income,
im_s_est_avail_income,
im_s_est_total_cont_inc,
im_s_est_cash_bank_accounts,
im_s_est_home_equity,
im_s_est_ot_rl_est_inv_eq,
im_s_est_adj_bus_farm_worth,
im_s_est_est_trusts,
im_s_est_net_worth,
im_s_est_emerg_res_allow,
im_s_est_cum_ed_savings,
im_s_est_total_asset_allow,
im_s_est_disc_net_worth,
im_s_est_total_cont_asset,
im_s_est_total_cont,
im_s_est_num_in_coll_adj,
im_s_est_cont_for_stu,
im_s_est_cont_from_income,
im_s_est_cont_from_assets,
im_s_opt_agi_taxable_income,
im_s_opt_untx_inc_and_ben,
im_s_opt_inc_adj,
im_s_opt_total_income,
im_s_opt_us_income_tax,
im_s_opt_state_and_oth_taxes,
im_s_opt_fica_tax,
im_s_opt_med_dental,
im_s_opt_employment_allow,
im_s_opt_annual_ed_savings,
im_s_opt_inc_prot_allow_m,
im_s_opt_total_inc_allow,
im_s_opt_cal_avail_income,
im_s_opt_avail_income,
im_s_opt_total_cont_inc,
im_s_opt_cash_bank_accounts,
im_s_opt_ira_keogh_accounts,
im_s_opt_home_equity,
im_s_opt_ot_rl_est_inv_eq,
im_s_opt_adj_bus_farm_worth,
im_s_opt_trusts,
im_s_opt_net_worth,
im_s_opt_emerg_res_allow,
im_s_opt_cum_ed_savings,
im_s_opt_total_asset_allow,
im_s_opt_disc_net_worth,
im_s_opt_total_cont_asset,
im_s_opt_total_cont,
im_s_opt_num_in_coll_adj,
im_s_opt_cont_for_stu,
im_s_opt_cont_from_income,
im_s_opt_cont_from_assets,
fm_s_analysis_type,
fm_s_agi_taxable_income,
fm_s_untx_inc_and_ben,
fm_s_inc_adj,
fm_s_total_income,
fm_s_us_income_tax,
fm_s_state_and_oth_taxes,
fm_s_fica_tax,
fm_s_employment_allow,
fm_s_income_prot_allow,
fm_s_total_allow,
fm_s_cal_avail_income,
fm_s_avail_income,
fm_s_cash_bank_accounts,
fm_s_ot_rl_est_inv_equity,
fm_s_adj_bus_farm_worth,
fm_s_trusts,
fm_s_net_worth,
fm_s_asset_prot_allow,
fm_s_disc_net_worth,
fm_s_total_cont,
fm_s_num_in_coll,
fm_s_cont_for_stu,
fm_s_cont_from_income,
fm_s_cont_from_assets,
im_inst_resident_ind,
institutional_1_budget_name,
im_inst_1_budget_duration,
im_inst_1_tuition_fees,
im_inst_1_books_supplies,
im_inst_1_living_expenses,
im_inst_1_tot_expenses,
im_inst_1_tot_stu_cont,
im_inst_1_tot_par_cont,
im_inst_1_tot_family_cont,
im_inst_1_va_benefits,
im_inst_1_ot_cont,
im_inst_1_est_financial_need,
institutional_2_budget_name,
im_inst_2_budget_duration,
im_inst_2_tuition_fees,
im_inst_2_books_supplies,
im_inst_2_living_expenses,
im_inst_2_tot_expenses,
im_inst_2_tot_stu_cont,
im_inst_2_tot_par_cont,
im_inst_2_tot_family_cont,
im_inst_2_va_benefits,
im_inst_2_est_financial_need,
institutional_3_budget_name,
im_inst_3_budget_duration,
im_inst_3_tuition_fees,
im_inst_3_books_supplies,
im_inst_3_living_expenses,
im_inst_3_tot_expenses,
im_inst_3_tot_stu_cont,
im_inst_3_tot_par_cont,
im_inst_3_tot_family_cont,
im_inst_3_va_benefits,
im_inst_3_est_financial_need,
fm_inst_1_federal_efc,
fm_inst_1_va_benefits,
fm_inst_1_fed_eligibility,
fm_inst_1_pell,
option_par_loss_allow_ind,
option_par_tuition_ind,
option_par_home_ind,
option_par_home_value,
option_par_home_debt,
option_stu_ira_keogh_ind,
option_stu_home_ind,
option_stu_home_value,
option_stu_home_debt,
option_stu_sum_ay_inc_ind,
option_par_hope_ll_credit,
option_stu_hope_ll_credit,
im_parent_1_8_months_bas,
im_p_more_than_9_mth_ba,
im_parent_1_8_months_opt,
im_p_more_than_9_mth_op,
fnar_message_1,
fnar_message_2,
fnar_message_3,
fnar_message_4,
fnar_message_5,
fnar_message_6,
fnar_message_7,
fnar_message_8,
fnar_message_9,
fnar_message_10,
fnar_message_11,
fnar_message_12,
fnar_message_13,
fnar_message_20,
fnar_message_21,
fnar_message_22,
fnar_message_23,
fnar_message_24,
fnar_message_25,
fnar_message_26,
fnar_message_27,
fnar_message_30,
fnar_message_31,
fnar_message_32,
fnar_message_33,
fnar_message_34,
fnar_message_35,
fnar_message_36,
fnar_message_37,
fnar_message_38,
fnar_message_39,
fnar_message_45,
fnar_message_46,
fnar_message_47,
fnar_message_48,
fnar_message_50,
fnar_message_51,
fnar_message_52,
fnar_message_53,
fnar_message_56,
fnar_message_57,
fnar_message_58,
fnar_message_59,
fnar_message_60,
fnar_message_61,
fnar_message_62,
fnar_message_63,
fnar_message_64,
fnar_message_65,
fnar_message_71,
fnar_message_72,
fnar_message_73,
fnar_message_74,
fnar_message_75,
fnar_message_76,
fnar_message_77,
fnar_message_78,
fnar_mesg_10_stu_fam_mem,
fnar_mesg_11_stu_no_in_coll,
fnar_mesg_24_stu_avail_inc,
fnar_mesg_26_stu_taxes,
fnar_mesg_33_stu_home_value,
fnar_mesg_34_stu_home_value,
fnar_mesg_34_stu_home_equity,
fnar_mesg_35_stu_home_value,
fnar_mesg_35_stu_home_equity,
fnar_mesg_36_stu_home_equity,
fnar_mesg_48_par_fam_mem,
fnar_mesg_49_par_no_in_coll,
fnar_mesg_56_par_agi,
fnar_mesg_62_par_taxes,
fnar_mesg_73_par_home_value,
fnar_mesg_74_par_home_value,
fnar_mesg_74_par_home_equity,
fnar_mesg_75_par_home_value,
fnar_mesg_75_par_home_equity,
fnar_mesg_76_par_home_equity,
assumption_message_1,
assumption_message_2,
assumption_message_3,
assumption_message_4,
assumption_message_5,
assumption_message_6,
record_mark,
fnar_message_55,
fnar_message_49,
option_par_cola_adj_ind,
option_par_stu_fa_assets_ind,
option_par_ipt_assets_ind,
option_stu_ipt_assets_ind,
option_par_cola_adj_value ,
legacy_record_flag,
option_ind_stu_ipt_assets_flag,
cust_parent_cont_adj_num,
custodial_parent_num,
cust_par_base_prcnt_inc_amt,
cust_par_base_cont_inc_amt,
cust_par_base_cont_ast_amt,
cust_par_base_tot_cont_amt,
cust_par_opt_prcnt_inc_amt,
cust_par_opt_cont_inc_amt,
cust_par_opt_cont_ast_amt,
cust_par_opt_tot_cont_amt,
parents_email_txt,
parent_1_birth_date,
parent_2_birth_date
FROM igf_ap_css_fnar_all
WHERE rowid = x_rowid
FOR UPDATE NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_fnar_id IN NUMBER,
x_cssp_id IN NUMBER,
x_r_s_email_address IN VARCHAR2,
x_eps_code IN VARCHAR2,
x_comp_css_dependency_status IN VARCHAR2,
x_stu_age IN VARCHAR2,
x_assumed_stu_yr_in_coll IN VARCHAR2,
x_comp_stu_marital_status IN VARCHAR2,
x_stu_family_members IN NUMBER,
x_stu_fam_members_in_college IN NUMBER,
x_par_marital_status IN VARCHAR2,
x_par_family_members IN NUMBER,
x_par_total_in_college IN NUMBER,
x_par_par_in_college IN NUMBER,
x_par_others_in_college IN NUMBER,
x_par_aesa IN NUMBER,
x_par_cesa IN NUMBER,
x_stu_aesa IN NUMBER,
x_stu_cesa IN NUMBER,
x_im_p_bas_agi_taxable_income IN NUMBER,
x_im_p_bas_untx_inc_and_ben IN NUMBER,
x_im_p_bas_inc_adj IN NUMBER,
x_im_p_bas_total_income IN NUMBER,
x_im_p_bas_us_income_tax IN NUMBER,
x_im_p_bas_st_and_other_tax IN NUMBER,
x_im_p_bas_fica_tax IN NUMBER,
x_im_p_bas_med_dental IN NUMBER,
x_im_p_bas_employment_allow IN NUMBER,
x_im_p_bas_annual_ed_savings IN NUMBER,
x_im_p_bas_inc_prot_allow_m IN NUMBER,
x_im_p_bas_total_inc_allow IN NUMBER,
x_im_p_bas_cal_avail_inc IN NUMBER,
x_im_p_bas_avail_income IN NUMBER,
x_im_p_bas_total_cont_inc IN NUMBER,
x_im_p_bas_cash_bank_accounts IN NUMBER,
x_im_p_bas_home_equity IN NUMBER,
x_im_p_bas_ot_rl_est_inv_eq IN NUMBER,
x_im_p_bas_adj_bus_farm_worth IN NUMBER,
x_im_p_bas_ass_sibs_pre_tui IN NUMBER,
x_im_p_bas_net_worth IN NUMBER,
x_im_p_bas_emerg_res_allow IN NUMBER,
x_im_p_bas_cum_ed_savings IN NUMBER,
x_im_p_bas_low_inc_allow IN NUMBER,
x_im_p_bas_total_asset_allow IN NUMBER,
x_im_p_bas_disc_net_worth IN NUMBER,
x_im_p_bas_total_cont_asset IN NUMBER,
x_im_p_bas_total_cont IN NUMBER,
x_im_p_bas_num_in_coll_adj IN NUMBER,
x_im_p_bas_cont_for_stu IN NUMBER,
x_im_p_bas_cont_from_income IN NUMBER,
x_im_p_bas_cont_from_assets IN NUMBER,
x_im_p_opt_agi_taxable_income IN NUMBER,
x_im_p_opt_untx_inc_and_ben IN NUMBER,
x_im_p_opt_inc_adj IN NUMBER,
x_im_p_opt_total_income IN NUMBER,
x_im_p_opt_us_income_tax IN NUMBER,
x_im_p_opt_st_and_other_tax IN NUMBER,
x_im_p_opt_fica_tax IN NUMBER,
x_im_p_opt_med_dental IN NUMBER,
x_im_p_opt_elem_sec_tuit IN NUMBER,
x_im_p_opt_employment_allow IN NUMBER,
x_im_p_opt_annual_ed_savings IN NUMBER,
x_im_p_opt_inc_prot_allow_m IN NUMBER,
x_im_p_opt_total_inc_allow IN NUMBER,
x_im_p_opt_cal_avail_inc IN NUMBER,
x_im_p_opt_avail_income IN NUMBER,
x_im_p_opt_total_cont_inc IN NUMBER,
x_im_p_opt_cash_bank_accounts IN NUMBER,
x_im_p_opt_home_equity IN NUMBER,
x_im_p_opt_ot_rl_est_inv_eq IN NUMBER,
x_im_p_opt_adj_bus_farm_worth IN NUMBER,
x_im_p_opt_ass_sibs_pre_tui IN NUMBER,
x_im_p_opt_net_worth IN NUMBER,
x_im_p_opt_emerg_res_allow IN NUMBER,
x_im_p_opt_cum_ed_savings IN NUMBER,
x_im_p_opt_low_inc_allow IN NUMBER,
x_im_p_opt_total_asset_allow IN NUMBER,
x_im_p_opt_disc_net_worth IN NUMBER,
x_im_p_opt_total_cont_asset IN NUMBER,
x_im_p_opt_total_cont IN NUMBER,
x_im_p_opt_num_in_coll_adj IN NUMBER,
x_im_p_opt_cont_for_stu IN NUMBER,
x_im_p_opt_cont_from_income IN NUMBER,
x_im_p_opt_cont_from_assets IN NUMBER,
x_fm_p_analysis_type IN VARCHAR2,
x_fm_p_agi_taxable_income IN NUMBER,
x_fm_p_untx_inc_and_ben IN NUMBER,
x_fm_p_inc_adj IN NUMBER,
x_fm_p_total_income IN NUMBER,
x_fm_p_us_income_tax IN NUMBER,
x_fm_p_state_and_other_taxes IN NUMBER,
x_fm_p_fica_tax IN NUMBER,
x_fm_p_employment_allow IN NUMBER,
x_fm_p_income_prot_allow IN NUMBER,
x_fm_p_total_allow IN NUMBER,
x_fm_p_avail_income IN NUMBER,
x_fm_p_cash_bank_accounts IN NUMBER,
x_fm_p_ot_rl_est_inv_equity IN NUMBER,
x_fm_p_adj_bus_farm_net_worth IN NUMBER,
x_fm_p_net_worth IN NUMBER,
x_fm_p_asset_prot_allow IN NUMBER,
x_fm_p_disc_net_worth IN NUMBER,
x_fm_p_total_contribution IN NUMBER,
x_fm_p_num_in_coll IN NUMBER,
x_fm_p_cont_for_stu IN NUMBER,
x_fm_p_cont_from_income IN NUMBER,
x_fm_p_cont_from_assets IN NUMBER,
x_im_s_bas_agi_taxable_income IN NUMBER,
x_im_s_bas_untx_inc_and_ben IN NUMBER,
x_im_s_bas_inc_adj IN NUMBER,
x_im_s_bas_total_income IN NUMBER,
x_im_s_bas_us_income_tax IN NUMBER,
x_im_s_bas_state_and_oth_taxes IN NUMBER,
x_im_s_bas_fica_tax IN NUMBER,
x_im_s_bas_med_dental IN NUMBER,
x_im_s_bas_employment_allow IN NUMBER,
x_im_s_bas_annual_ed_savings IN NUMBER,
x_im_s_bas_inc_prot_allow_m IN NUMBER,
x_im_s_bas_total_inc_allow IN NUMBER,
x_im_s_bas_cal_avail_income IN NUMBER,
x_im_s_bas_avail_income IN NUMBER,
x_im_s_bas_total_cont_inc IN NUMBER,
x_im_s_bas_cash_bank_accounts IN NUMBER,
x_im_s_bas_home_equity IN NUMBER,
x_im_s_bas_ot_rl_est_inv_eq IN NUMBER,
x_im_s_bas_adj_busfarm_worth IN NUMBER,
x_im_s_bas_trusts IN NUMBER,
x_im_s_bas_net_worth IN NUMBER,
x_im_s_bas_emerg_res_allow IN NUMBER,
x_im_s_bas_cum_ed_savings IN NUMBER,
x_im_s_bas_total_asset_allow IN NUMBER,
x_im_s_bas_disc_net_worth IN NUMBER,
x_im_s_bas_total_cont_asset IN NUMBER,
x_im_s_bas_total_cont IN NUMBER,
x_im_s_bas_num_in_coll_adj IN NUMBER,
x_im_s_bas_cont_for_stu IN NUMBER,
x_im_s_bas_cont_from_income IN NUMBER,
x_im_s_bas_cont_from_assets IN NUMBER,
x_im_s_est_agitaxable_income IN NUMBER,
x_im_s_est_untx_inc_and_ben IN NUMBER,
x_im_s_est_inc_adj IN NUMBER,
x_im_s_est_total_income IN NUMBER,
x_im_s_est_us_income_tax IN NUMBER,
x_im_s_est_state_and_oth_taxes IN NUMBER,
x_im_s_est_fica_tax IN NUMBER,
x_im_s_est_med_dental IN NUMBER,
x_im_s_est_employment_allow IN NUMBER,
x_im_s_est_annual_ed_savings IN NUMBER,
x_im_s_est_inc_prot_allow_m IN NUMBER,
x_im_s_est_total_inc_allow IN NUMBER,
x_im_s_est_cal_avail_income IN NUMBER,
x_im_s_est_avail_income IN NUMBER,
x_im_s_est_total_cont_inc IN NUMBER,
x_im_s_est_cash_bank_accounts IN NUMBER,
x_im_s_est_home_equity IN NUMBER,
x_im_s_est_ot_rl_est_inv_eq IN NUMBER,
x_im_s_est_adj_bus_farm_worth IN NUMBER,
x_im_s_est_est_trusts IN NUMBER,
x_im_s_est_net_worth IN NUMBER,
x_im_s_est_emerg_res_allow IN NUMBER,
x_im_s_est_cum_ed_savings IN NUMBER,
x_im_s_est_total_asset_allow IN NUMBER,
x_im_s_est_disc_net_worth IN NUMBER,
x_im_s_est_total_cont_asset IN NUMBER,
x_im_s_est_total_cont IN NUMBER,
x_im_s_est_num_in_coll_adj IN NUMBER,
x_im_s_est_cont_for_stu IN NUMBER,
x_im_s_est_cont_from_income IN NUMBER,
x_im_s_est_cont_from_assets IN NUMBER,
x_im_s_opt_agi_taxable_income IN NUMBER,
x_im_s_opt_untx_inc_and_ben IN NUMBER,
x_im_s_opt_inc_adj IN NUMBER,
x_im_s_opt_total_income IN NUMBER,
x_im_s_opt_us_income_tax IN NUMBER,
x_im_s_opt_state_and_oth_taxes IN NUMBER,
x_im_s_opt_fica_tax IN NUMBER,
x_im_s_opt_med_dental IN NUMBER,
x_im_s_opt_employment_allow IN NUMBER,
x_im_s_opt_annual_ed_savings IN NUMBER,
x_im_s_opt_inc_prot_allow_m IN NUMBER,
x_im_s_opt_total_inc_allow IN NUMBER,
x_im_s_opt_cal_avail_income IN NUMBER,
x_im_s_opt_avail_income IN NUMBER,
x_im_s_opt_total_cont_inc IN NUMBER,
x_im_s_opt_cash_bank_accounts IN NUMBER,
x_im_s_opt_ira_keogh_accounts IN NUMBER,
x_im_s_opt_home_equity IN NUMBER,
x_im_s_opt_ot_rl_est_inv_eq IN NUMBER,
x_im_s_opt_adj_bus_farm_worth IN NUMBER,
x_im_s_opt_trusts IN NUMBER,
x_im_s_opt_net_worth IN NUMBER,
x_im_s_opt_emerg_res_allow IN NUMBER,
x_im_s_opt_cum_ed_savings IN NUMBER,
x_im_s_opt_total_asset_allow IN NUMBER,
x_im_s_opt_disc_net_worth IN NUMBER,
x_im_s_opt_total_cont_asset IN NUMBER,
x_im_s_opt_total_cont IN NUMBER,
x_im_s_opt_num_in_coll_adj IN NUMBER,
x_im_s_opt_cont_for_stu IN NUMBER,
x_im_s_opt_cont_from_income IN NUMBER,
x_im_s_opt_cont_from_assets IN NUMBER,
x_fm_s_analysis_type IN VARCHAR2,
x_fm_s_agi_taxable_income IN NUMBER,
x_fm_s_untx_inc_and_ben IN NUMBER,
x_fm_s_inc_adj IN NUMBER,
x_fm_s_total_income IN NUMBER,
x_fm_s_us_income_tax IN NUMBER,
x_fm_s_state_and_oth_taxes IN NUMBER,
x_fm_s_fica_tax IN NUMBER,
x_fm_s_employment_allow IN NUMBER,
x_fm_s_income_prot_allow IN NUMBER,
x_fm_s_total_allow IN NUMBER,
x_fm_s_cal_avail_income IN NUMBER,
x_fm_s_avail_income IN NUMBER,
x_fm_s_cash_bank_accounts IN NUMBER,
x_fm_s_ot_rl_est_inv_equity IN NUMBER,
x_fm_s_adj_bus_farm_worth IN NUMBER,
x_fm_s_trusts IN NUMBER,
x_fm_s_net_worth IN NUMBER,
x_fm_s_asset_prot_allow IN NUMBER,
x_fm_s_disc_net_worth IN NUMBER,
x_fm_s_total_cont IN NUMBER,
x_fm_s_num_in_coll IN NUMBER,
x_fm_s_cont_for_stu IN NUMBER,
x_fm_s_cont_from_income IN NUMBER,
x_fm_s_cont_from_assets IN NUMBER,
x_im_inst_resident_ind IN VARCHAR2,
x_institutional_1_budget_name IN VARCHAR2,
x_im_inst_1_budget_duration IN NUMBER,
x_im_inst_1_tuition_fees IN NUMBER,
x_im_inst_1_books_supplies IN NUMBER,
x_im_inst_1_living_expenses IN NUMBER,
x_im_inst_1_tot_expenses IN NUMBER,
x_im_inst_1_tot_stu_cont IN NUMBER,
x_im_inst_1_tot_par_cont IN NUMBER,
x_im_inst_1_tot_family_cont IN NUMBER,
x_im_inst_1_va_benefits IN NUMBER,
x_im_inst_1_ot_cont IN NUMBER,
x_im_inst_1_est_financial_need IN NUMBER,
x_institutional_2_budget_name IN VARCHAR2,
x_im_inst_2_budget_duration IN VARCHAR2,
x_im_inst_2_tuition_fees IN NUMBER,
x_im_inst_2_books_supplies IN NUMBER,
x_im_inst_2_living_expenses IN NUMBER,
x_im_inst_2_tot_expenses IN NUMBER,
x_im_inst_2_tot_stu_cont IN NUMBER,
x_im_inst_2_tot_par_cont IN NUMBER,
x_im_inst_2_tot_family_cont IN NUMBER,
x_im_inst_2_va_benefits IN NUMBER,
x_im_inst_2_est_financial_need IN NUMBER,
x_institutional_3_budget_name IN VARCHAR2,
x_im_inst_3_budget_duration IN NUMBER,
x_im_inst_3_tuition_fees IN NUMBER,
x_im_inst_3_books_supplies IN NUMBER,
x_im_inst_3_living_expenses IN NUMBER,
x_im_inst_3_tot_expenses IN NUMBER,
x_im_inst_3_tot_stu_cont IN NUMBER,
x_im_inst_3_tot_par_cont IN NUMBER,
x_im_inst_3_tot_family_cont IN NUMBER,
x_im_inst_3_va_benefits IN NUMBER,
x_im_inst_3_est_financial_need IN NUMBER,
x_fm_inst_1_federal_efc IN VARCHAR2,
x_fm_inst_1_va_benefits IN VARCHAR2,
x_fm_inst_1_fed_eligibility IN VARCHAR2,
x_fm_inst_1_pell IN VARCHAR2,
x_option_par_loss_allow_ind IN VARCHAR2,
x_option_par_tuition_ind IN VARCHAR2,
x_option_par_home_ind IN VARCHAR2,
x_option_par_home_value IN VARCHAR2,
x_option_par_home_debt IN VARCHAR2,
x_option_stu_ira_keogh_ind IN VARCHAR2,
x_option_stu_home_ind IN VARCHAR2,
x_option_stu_home_value IN VARCHAR2,
x_option_stu_home_debt IN VARCHAR2,
x_option_stu_sum_ay_inc_ind IN VARCHAR2,
x_option_par_hope_ll_credit IN VARCHAR2,
x_option_stu_hope_ll_credit IN VARCHAR2,
x_im_parent_1_8_months_bas IN VARCHAR2,
x_im_p_more_than_9_mth_ba IN VARCHAR2,
x_im_parent_1_8_months_opt IN VARCHAR2,
x_im_p_more_than_9_mth_op IN VARCHAR2,
x_fnar_message_1 IN VARCHAR2,
x_fnar_message_2 IN VARCHAR2,
x_fnar_message_3 IN VARCHAR2,
x_fnar_message_4 IN VARCHAR2,
x_fnar_message_5 IN VARCHAR2,
x_fnar_message_6 IN VARCHAR2,
x_fnar_message_7 IN VARCHAR2,
x_fnar_message_8 IN VARCHAR2,
x_fnar_message_9 IN VARCHAR2,
x_fnar_message_10 IN VARCHAR2,
x_fnar_message_11 IN VARCHAR2,
x_fnar_message_12 IN VARCHAR2,
x_fnar_message_13 IN VARCHAR2,
x_fnar_message_20 IN VARCHAR2,
x_fnar_message_21 IN VARCHAR2,
x_fnar_message_22 IN VARCHAR2,
x_fnar_message_23 IN VARCHAR2,
x_fnar_message_24 IN VARCHAR2,
x_fnar_message_25 IN VARCHAR2,
x_fnar_message_26 IN VARCHAR2,
x_fnar_message_27 IN VARCHAR2,
x_fnar_message_30 IN VARCHAR2,
x_fnar_message_31 IN VARCHAR2,
x_fnar_message_32 IN VARCHAR2,
x_fnar_message_33 IN VARCHAR2,
x_fnar_message_34 IN VARCHAR2,
x_fnar_message_35 IN VARCHAR2,
x_fnar_message_36 IN VARCHAR2,
x_fnar_message_37 IN VARCHAR2,
x_fnar_message_38 IN VARCHAR2,
x_fnar_message_39 IN VARCHAR2,
x_fnar_message_45 IN VARCHAR2,
x_fnar_message_46 IN VARCHAR2,
x_fnar_message_47 IN VARCHAR2,
x_fnar_message_48 IN VARCHAR2,
x_fnar_message_50 IN VARCHAR2,
x_fnar_message_51 IN VARCHAR2,
x_fnar_message_52 IN VARCHAR2,
x_fnar_message_53 IN VARCHAR2,
x_fnar_message_56 IN VARCHAR2,
x_fnar_message_57 IN VARCHAR2,
x_fnar_message_58 IN VARCHAR2,
x_fnar_message_59 IN VARCHAR2,
x_fnar_message_60 IN VARCHAR2,
x_fnar_message_61 IN VARCHAR2,
x_fnar_message_62 IN VARCHAR2,
x_fnar_message_63 IN VARCHAR2,
x_fnar_message_64 IN VARCHAR2,
x_fnar_message_65 IN VARCHAR2,
x_fnar_message_71 IN VARCHAR2,
x_fnar_message_72 IN VARCHAR2,
x_fnar_message_73 IN VARCHAR2,
x_fnar_message_74 IN VARCHAR2,
x_fnar_message_75 IN VARCHAR2,
x_fnar_message_76 IN VARCHAR2,
x_fnar_message_77 IN VARCHAR2,
x_fnar_message_78 IN VARCHAR2,
x_fnar_mesg_10_stu_fam_mem IN VARCHAR2,
x_fnar_mesg_11_stu_no_in_coll IN VARCHAR2,
x_fnar_mesg_24_stu_avail_inc IN VARCHAR2,
x_fnar_mesg_26_stu_taxes IN VARCHAR2,
x_fnar_mesg_33_stu_home_value IN VARCHAR2,
x_fnar_mesg_34_stu_home_value IN VARCHAR2,
x_fnar_mesg_34_stu_home_equity IN VARCHAR2,
x_fnar_mesg_35_stu_home_value IN VARCHAR2,
x_fnar_mesg_35_stu_home_equity IN VARCHAR2,
x_fnar_mesg_36_stu_home_equity IN VARCHAR2,
x_fnar_mesg_48_par_fam_mem IN VARCHAR2,
x_fnar_mesg_49_par_no_in_coll IN VARCHAR2,
x_fnar_mesg_56_par_agi IN VARCHAR2,
x_fnar_mesg_62_par_taxes IN VARCHAR2,
x_fnar_mesg_73_par_home_value IN VARCHAR2,
x_fnar_mesg_74_par_home_value IN VARCHAR2,
x_fnar_mesg_74_par_home_equity IN VARCHAR2,
x_fnar_mesg_75_par_home_value IN VARCHAR2,
x_fnar_mesg_75_par_home_equity IN VARCHAR2,
x_fnar_mesg_76_par_home_equity IN VARCHAR2,
x_assumption_message_1 IN VARCHAR2,
x_assumption_message_2 IN VARCHAR2,
x_assumption_message_3 IN VARCHAR2,
x_assumption_message_4 IN VARCHAR2,
x_assumption_message_5 IN VARCHAR2,
x_assumption_message_6 IN VARCHAR2,
x_record_mark IN VARCHAR2,
x_mode IN VARCHAR2 DEFAULT 'R',
x_fnar_message_55 IN VARCHAR2 DEFAULT NULL,
x_fnar_message_49 IN VARCHAR2 DEFAULT NULL,
x_opt_par_cola_adj_ind IN VARCHAR2 DEFAULT NULL,
x_opt_par_stu_fa_assets_ind IN VARCHAR2 DEFAULT NULL,
x_opt_par_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
x_opt_stu_ipt_assets_ind IN VARCHAR2 DEFAULT NULL,
x_opt_par_cola_adj_value IN NUMBER DEFAULT NULL,
x_legacy_record_flag IN VARCHAR2,
x_opt_ind_stu_ipt_assets_flag IN VARCHAR2 DEFAULT NULL,
x_cust_parent_cont_adj_num IN NUMBER,
x_custodial_parent_num IN NUMBER,
x_cust_par_base_prcnt_inc_amt IN NUMBER,
x_cust_par_base_cont_inc_amt IN NUMBER,
x_cust_par_base_cont_ast_amt IN NUMBER,
x_cust_par_base_tot_cont_amt IN NUMBER,
x_cust_par_opt_prcnt_inc_amt IN NUMBER,
x_cust_par_opt_cont_inc_amt IN NUMBER,
x_cust_par_opt_cont_ast_amt IN NUMBER,
x_cust_par_opt_tot_cont_amt IN NUMBER,
x_parents_email_txt IN VARCHAR2,
x_parent_1_birth_date IN DATE,
x_parent_2_birth_date IN DATE
) AS
/*
|| Created By : vivuyyur
|| Created On : 30-MAY-2001
|| 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)
*/
x_last_update_date DATE ;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
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_fnar_id => x_fnar_id,
x_cssp_id => x_cssp_id,
x_r_s_email_address => x_r_s_email_address,
x_eps_code => x_eps_code,
x_comp_css_dependency_status => x_comp_css_dependency_status,
x_stu_age => x_stu_age,
x_assumed_stu_yr_in_coll => x_assumed_stu_yr_in_coll,
x_comp_stu_marital_status => x_comp_stu_marital_status,
x_stu_family_members => x_stu_family_members,
x_stu_fam_members_in_college => x_stu_fam_members_in_college,
x_par_marital_status => x_par_marital_status,
x_par_family_members => x_par_family_members,
x_par_total_in_college => x_par_total_in_college,
x_par_par_in_college => x_par_par_in_college,
x_par_others_in_college => x_par_others_in_college,
x_par_aesa => x_par_aesa,
x_par_cesa => x_par_cesa,
x_stu_aesa => x_stu_aesa,
x_stu_cesa => x_stu_cesa,
x_im_p_bas_agi_taxable_income => x_im_p_bas_agi_taxable_income,
x_im_p_bas_untx_inc_and_ben => x_im_p_bas_untx_inc_and_ben,
x_im_p_bas_inc_adj => x_im_p_bas_inc_adj,
x_im_p_bas_total_income => x_im_p_bas_total_income,
x_im_p_bas_us_income_tax => x_im_p_bas_us_income_tax,
x_im_p_bas_st_and_other_tax => x_im_p_bas_st_and_other_tax,
x_im_p_bas_fica_tax => x_im_p_bas_fica_tax,
x_im_p_bas_med_dental => x_im_p_bas_med_dental,
x_im_p_bas_employment_allow => x_im_p_bas_employment_allow,
x_im_p_bas_annual_ed_savings => x_im_p_bas_annual_ed_savings,
x_im_p_bas_inc_prot_allow_m => x_im_p_bas_inc_prot_allow_m,
x_im_p_bas_total_inc_allow => x_im_p_bas_total_inc_allow,
x_im_p_bas_cal_avail_inc => x_im_p_bas_cal_avail_inc,
x_im_p_bas_avail_income => x_im_p_bas_avail_income,
x_im_p_bas_total_cont_inc => x_im_p_bas_total_cont_inc,
x_im_p_bas_cash_bank_accounts => x_im_p_bas_cash_bank_accounts,
x_im_p_bas_home_equity => x_im_p_bas_home_equity,
x_im_p_bas_ot_rl_est_inv_eq => x_im_p_bas_ot_rl_est_inv_eq,
x_im_p_bas_adj_bus_farm_worth => x_im_p_bas_adj_bus_farm_worth,
x_im_p_bas_ass_sibs_pre_tui => x_im_p_bas_ass_sibs_pre_tui,
x_im_p_bas_net_worth => x_im_p_bas_net_worth,
x_im_p_bas_emerg_res_allow => x_im_p_bas_emerg_res_allow,
x_im_p_bas_cum_ed_savings => x_im_p_bas_cum_ed_savings,
x_im_p_bas_low_inc_allow => x_im_p_bas_low_inc_allow,
x_im_p_bas_total_asset_allow => x_im_p_bas_total_asset_allow,
x_im_p_bas_disc_net_worth => x_im_p_bas_disc_net_worth,
x_im_p_bas_total_cont_asset => x_im_p_bas_total_cont_asset,
x_im_p_bas_total_cont => x_im_p_bas_total_cont,
x_im_p_bas_num_in_coll_adj => x_im_p_bas_num_in_coll_adj,
x_im_p_bas_cont_for_stu => x_im_p_bas_cont_for_stu,
x_im_p_bas_cont_from_income => x_im_p_bas_cont_from_income,
x_im_p_bas_cont_from_assets => x_im_p_bas_cont_from_assets,
x_im_p_opt_agi_taxable_income => x_im_p_opt_agi_taxable_income,
x_im_p_opt_untx_inc_and_ben => x_im_p_opt_untx_inc_and_ben,
x_im_p_opt_inc_adj => x_im_p_opt_inc_adj,
x_im_p_opt_total_income => x_im_p_opt_total_income,
x_im_p_opt_us_income_tax => x_im_p_opt_us_income_tax,
x_im_p_opt_st_and_other_tax => x_im_p_opt_st_and_other_tax,
x_im_p_opt_fica_tax => x_im_p_opt_fica_tax,
x_im_p_opt_med_dental => x_im_p_opt_med_dental,
x_im_p_opt_elem_sec_tuit => x_im_p_opt_elem_sec_tuit,
x_im_p_opt_employment_allow => x_im_p_opt_employment_allow,
x_im_p_opt_annual_ed_savings => x_im_p_opt_annual_ed_savings,
x_im_p_opt_inc_prot_allow_m => x_im_p_opt_inc_prot_allow_m,
x_im_p_opt_total_inc_allow => x_im_p_opt_total_inc_allow,
x_im_p_opt_cal_avail_inc => x_im_p_opt_cal_avail_inc,
x_im_p_opt_avail_income => x_im_p_opt_avail_income,
x_im_p_opt_total_cont_inc => x_im_p_opt_total_cont_inc,
x_im_p_opt_cash_bank_accounts => x_im_p_opt_cash_bank_accounts,
x_im_p_opt_home_equity => x_im_p_opt_home_equity,
x_im_p_opt_ot_rl_est_inv_eq => x_im_p_opt_ot_rl_est_inv_eq,
x_im_p_opt_adj_bus_farm_worth => x_im_p_opt_adj_bus_farm_worth,
x_im_p_opt_ass_sibs_pre_tui => x_im_p_opt_ass_sibs_pre_tui,
x_im_p_opt_net_worth => x_im_p_opt_net_worth,
x_im_p_opt_emerg_res_allow => x_im_p_opt_emerg_res_allow,
x_im_p_opt_cum_ed_savings => x_im_p_opt_cum_ed_savings,
x_im_p_opt_low_inc_allow => x_im_p_opt_low_inc_allow,
x_im_p_opt_total_asset_allow => x_im_p_opt_total_asset_allow,
x_im_p_opt_disc_net_worth => x_im_p_opt_disc_net_worth,
x_im_p_opt_total_cont_asset => x_im_p_opt_total_cont_asset,
x_im_p_opt_total_cont => x_im_p_opt_total_cont,
x_im_p_opt_num_in_coll_adj => x_im_p_opt_num_in_coll_adj,
x_im_p_opt_cont_for_stu => x_im_p_opt_cont_for_stu,
x_im_p_opt_cont_from_income => x_im_p_opt_cont_from_income,
x_im_p_opt_cont_from_assets => x_im_p_opt_cont_from_assets,
x_fm_p_analysis_type => x_fm_p_analysis_type,
x_fm_p_agi_taxable_income => x_fm_p_agi_taxable_income,
x_fm_p_untx_inc_and_ben => x_fm_p_untx_inc_and_ben,
x_fm_p_inc_adj => x_fm_p_inc_adj,
x_fm_p_total_income => x_fm_p_total_income,
x_fm_p_us_income_tax => x_fm_p_us_income_tax,
x_fm_p_state_and_other_taxes => x_fm_p_state_and_other_taxes,
x_fm_p_fica_tax => x_fm_p_fica_tax,
x_fm_p_employment_allow => x_fm_p_employment_allow,
x_fm_p_income_prot_allow => x_fm_p_income_prot_allow,
x_fm_p_total_allow => x_fm_p_total_allow,
x_fm_p_avail_income => x_fm_p_avail_income,
x_fm_p_cash_bank_accounts => x_fm_p_cash_bank_accounts,
x_fm_p_ot_rl_est_inv_equity => x_fm_p_ot_rl_est_inv_equity,
x_fm_p_adj_bus_farm_net_worth => x_fm_p_adj_bus_farm_net_worth,
x_fm_p_net_worth => x_fm_p_net_worth,
x_fm_p_asset_prot_allow => x_fm_p_asset_prot_allow,
x_fm_p_disc_net_worth => x_fm_p_disc_net_worth,
x_fm_p_total_contribution => x_fm_p_total_contribution,
x_fm_p_num_in_coll => x_fm_p_num_in_coll,
x_fm_p_cont_for_stu => x_fm_p_cont_for_stu,
x_fm_p_cont_from_income => x_fm_p_cont_from_income,
x_fm_p_cont_from_assets => x_fm_p_cont_from_assets,
x_im_s_bas_agi_taxable_income => x_im_s_bas_agi_taxable_income,
x_im_s_bas_untx_inc_and_ben => x_im_s_bas_untx_inc_and_ben,
x_im_s_bas_inc_adj => x_im_s_bas_inc_adj,
x_im_s_bas_total_income => x_im_s_bas_total_income,
x_im_s_bas_us_income_tax => x_im_s_bas_us_income_tax,
x_im_s_bas_state_and_oth_taxes => x_im_s_bas_state_and_oth_taxes,
x_im_s_bas_fica_tax => x_im_s_bas_fica_tax,
x_im_s_bas_med_dental => x_im_s_bas_med_dental,
x_im_s_bas_employment_allow => x_im_s_bas_employment_allow,
x_im_s_bas_annual_ed_savings => x_im_s_bas_annual_ed_savings,
x_im_s_bas_inc_prot_allow_m => x_im_s_bas_inc_prot_allow_m,
x_im_s_bas_total_inc_allow => x_im_s_bas_total_inc_allow,
x_im_s_bas_cal_avail_income => x_im_s_bas_cal_avail_income,
x_im_s_bas_avail_income => x_im_s_bas_avail_income,
x_im_s_bas_total_cont_inc => x_im_s_bas_total_cont_inc,
x_im_s_bas_cash_bank_accounts => x_im_s_bas_cash_bank_accounts,
x_im_s_bas_home_equity => x_im_s_bas_home_equity,
x_im_s_bas_ot_rl_est_inv_eq => x_im_s_bas_ot_rl_est_inv_eq,
x_im_s_bas_adj_busfarm_worth => x_im_s_bas_adj_busfarm_worth,
x_im_s_bas_trusts => x_im_s_bas_trusts,
x_im_s_bas_net_worth => x_im_s_bas_net_worth,
x_im_s_bas_emerg_res_allow => x_im_s_bas_emerg_res_allow,
x_im_s_bas_cum_ed_savings => x_im_s_bas_cum_ed_savings,
x_im_s_bas_total_asset_allow => x_im_s_bas_total_asset_allow,
x_im_s_bas_disc_net_worth => x_im_s_bas_disc_net_worth,
x_im_s_bas_total_cont_asset => x_im_s_bas_total_cont_asset,
x_im_s_bas_total_cont => x_im_s_bas_total_cont,
x_im_s_bas_num_in_coll_adj => x_im_s_bas_num_in_coll_adj,
x_im_s_bas_cont_for_stu => x_im_s_bas_cont_for_stu,
x_im_s_bas_cont_from_income => x_im_s_bas_cont_from_income,
x_im_s_bas_cont_from_assets => x_im_s_bas_cont_from_assets,
x_im_s_est_agitaxable_income => x_im_s_est_agitaxable_income,
x_im_s_est_untx_inc_and_ben => x_im_s_est_untx_inc_and_ben,
x_im_s_est_inc_adj => x_im_s_est_inc_adj,
x_im_s_est_total_income => x_im_s_est_total_income,
x_im_s_est_us_income_tax => x_im_s_est_us_income_tax,
x_im_s_est_state_and_oth_taxes => x_im_s_est_state_and_oth_taxes,
x_im_s_est_fica_tax => x_im_s_est_fica_tax,
x_im_s_est_med_dental => x_im_s_est_med_dental,
x_im_s_est_employment_allow => x_im_s_est_employment_allow,
x_im_s_est_annual_ed_savings => x_im_s_est_annual_ed_savings,
x_im_s_est_inc_prot_allow_m => x_im_s_est_inc_prot_allow_m,
x_im_s_est_total_inc_allow => x_im_s_est_total_inc_allow,
x_im_s_est_cal_avail_income => x_im_s_est_cal_avail_income,
x_im_s_est_avail_income => x_im_s_est_avail_income,
x_im_s_est_total_cont_inc => x_im_s_est_total_cont_inc,
x_im_s_est_cash_bank_accounts => x_im_s_est_cash_bank_accounts,
x_im_s_est_home_equity => x_im_s_est_home_equity,
x_im_s_est_ot_rl_est_inv_eq => x_im_s_est_ot_rl_est_inv_eq,
x_im_s_est_adj_bus_farm_worth => x_im_s_est_adj_bus_farm_worth,
x_im_s_est_est_trusts => x_im_s_est_est_trusts,
x_im_s_est_net_worth => x_im_s_est_net_worth,
x_im_s_est_emerg_res_allow => x_im_s_est_emerg_res_allow,
x_im_s_est_cum_ed_savings => x_im_s_est_cum_ed_savings,
x_im_s_est_total_asset_allow => x_im_s_est_total_asset_allow,
x_im_s_est_disc_net_worth => x_im_s_est_disc_net_worth,
x_im_s_est_total_cont_asset => x_im_s_est_total_cont_asset,
x_im_s_est_total_cont => x_im_s_est_total_cont,
x_im_s_est_num_in_coll_adj => x_im_s_est_num_in_coll_adj,
x_im_s_est_cont_for_stu => x_im_s_est_cont_for_stu,
x_im_s_est_cont_from_income => x_im_s_est_cont_from_income,
x_im_s_est_cont_from_assets => x_im_s_est_cont_from_assets,
x_im_s_opt_agi_taxable_income => x_im_s_opt_agi_taxable_income,
x_im_s_opt_untx_inc_and_ben => x_im_s_opt_untx_inc_and_ben,
x_im_s_opt_inc_adj => x_im_s_opt_inc_adj,
x_im_s_opt_total_income => x_im_s_opt_total_income,
x_im_s_opt_us_income_tax => x_im_s_opt_us_income_tax,
x_im_s_opt_state_and_oth_taxes => x_im_s_opt_state_and_oth_taxes,
x_im_s_opt_fica_tax => x_im_s_opt_fica_tax,
x_im_s_opt_med_dental => x_im_s_opt_med_dental,
x_im_s_opt_employment_allow => x_im_s_opt_employment_allow,
x_im_s_opt_annual_ed_savings => x_im_s_opt_annual_ed_savings,
x_im_s_opt_inc_prot_allow_m => x_im_s_opt_inc_prot_allow_m,
x_im_s_opt_total_inc_allow => x_im_s_opt_total_inc_allow,
x_im_s_opt_cal_avail_income => x_im_s_opt_cal_avail_income,
x_im_s_opt_avail_income => x_im_s_opt_avail_income,
x_im_s_opt_total_cont_inc => x_im_s_opt_total_cont_inc,
x_im_s_opt_cash_bank_accounts => x_im_s_opt_cash_bank_accounts,
x_im_s_opt_ira_keogh_accounts => x_im_s_opt_ira_keogh_accounts,
x_im_s_opt_home_equity => x_im_s_opt_home_equity,
x_im_s_opt_ot_rl_est_inv_eq => x_im_s_opt_ot_rl_est_inv_eq,
x_im_s_opt_adj_bus_farm_worth => x_im_s_opt_adj_bus_farm_worth,
x_im_s_opt_trusts => x_im_s_opt_trusts,
x_im_s_opt_net_worth => x_im_s_opt_net_worth,
x_im_s_opt_emerg_res_allow => x_im_s_opt_emerg_res_allow,
x_im_s_opt_cum_ed_savings => x_im_s_opt_cum_ed_savings,
x_im_s_opt_total_asset_allow => x_im_s_opt_total_asset_allow,
x_im_s_opt_disc_net_worth => x_im_s_opt_disc_net_worth,
x_im_s_opt_total_cont_asset => x_im_s_opt_total_cont_asset,
x_im_s_opt_total_cont => x_im_s_opt_total_cont,
x_im_s_opt_num_in_coll_adj => x_im_s_opt_num_in_coll_adj,
x_im_s_opt_cont_for_stu => x_im_s_opt_cont_for_stu,
x_im_s_opt_cont_from_income => x_im_s_opt_cont_from_income,
x_im_s_opt_cont_from_assets => x_im_s_opt_cont_from_assets,
x_fm_s_analysis_type => x_fm_s_analysis_type,
x_fm_s_agi_taxable_income => x_fm_s_agi_taxable_income,
x_fm_s_untx_inc_and_ben => x_fm_s_untx_inc_and_ben,
x_fm_s_inc_adj => x_fm_s_inc_adj,
x_fm_s_total_income => x_fm_s_total_income,
x_fm_s_us_income_tax => x_fm_s_us_income_tax,
x_fm_s_state_and_oth_taxes => x_fm_s_state_and_oth_taxes,
x_fm_s_fica_tax => x_fm_s_fica_tax,
x_fm_s_employment_allow => x_fm_s_employment_allow,
x_fm_s_income_prot_allow => x_fm_s_income_prot_allow,
x_fm_s_total_allow => x_fm_s_total_allow,
x_fm_s_cal_avail_income => x_fm_s_cal_avail_income,
x_fm_s_avail_income => x_fm_s_avail_income,
x_fm_s_cash_bank_accounts => x_fm_s_cash_bank_accounts,
x_fm_s_ot_rl_est_inv_equity => x_fm_s_ot_rl_est_inv_equity,
x_fm_s_adj_bus_farm_worth => x_fm_s_adj_bus_farm_worth,
x_fm_s_trusts => x_fm_s_trusts,
x_fm_s_net_worth => x_fm_s_net_worth,
x_fm_s_asset_prot_allow => x_fm_s_asset_prot_allow,
x_fm_s_disc_net_worth => x_fm_s_disc_net_worth,
x_fm_s_total_cont => x_fm_s_total_cont,
x_fm_s_num_in_coll => x_fm_s_num_in_coll,
x_fm_s_cont_for_stu => x_fm_s_cont_for_stu,
x_fm_s_cont_from_income => x_fm_s_cont_from_income,
x_fm_s_cont_from_assets => x_fm_s_cont_from_assets,
x_im_inst_resident_ind => x_im_inst_resident_ind,
x_institutional_1_budget_name => x_institutional_1_budget_name,
x_im_inst_1_budget_duration => x_im_inst_1_budget_duration,
x_im_inst_1_tuition_fees => x_im_inst_1_tuition_fees,
x_im_inst_1_books_supplies => x_im_inst_1_books_supplies,
x_im_inst_1_living_expenses => x_im_inst_1_living_expenses,
x_im_inst_1_tot_expenses => x_im_inst_1_tot_expenses,
x_im_inst_1_tot_stu_cont => x_im_inst_1_tot_stu_cont,
x_im_inst_1_tot_par_cont => x_im_inst_1_tot_par_cont,
x_im_inst_1_tot_family_cont => x_im_inst_1_tot_family_cont,
x_im_inst_1_va_benefits => x_im_inst_1_va_benefits,
x_im_inst_1_ot_cont => x_im_inst_1_ot_cont,
x_im_inst_1_est_financial_need => x_im_inst_1_est_financial_need,
x_institutional_2_budget_name => x_institutional_2_budget_name,
x_im_inst_2_budget_duration => x_im_inst_2_budget_duration,
x_im_inst_2_tuition_fees => x_im_inst_2_tuition_fees,
x_im_inst_2_books_supplies => x_im_inst_2_books_supplies,
x_im_inst_2_living_expenses => x_im_inst_2_living_expenses,
x_im_inst_2_tot_expenses => x_im_inst_2_tot_expenses,
x_im_inst_2_tot_stu_cont => x_im_inst_2_tot_stu_cont,
x_im_inst_2_tot_par_cont => x_im_inst_2_tot_par_cont,
x_im_inst_2_tot_family_cont => x_im_inst_2_tot_family_cont,
x_im_inst_2_va_benefits => x_im_inst_2_va_benefits,
x_im_inst_2_est_financial_need => x_im_inst_2_est_financial_need,
x_institutional_3_budget_name => x_institutional_3_budget_name,
x_im_inst_3_budget_duration => x_im_inst_3_budget_duration,
x_im_inst_3_tuition_fees => x_im_inst_3_tuition_fees,
x_im_inst_3_books_supplies => x_im_inst_3_books_supplies,
x_im_inst_3_living_expenses => x_im_inst_3_living_expenses,
x_im_inst_3_tot_expenses => x_im_inst_3_tot_expenses,
x_im_inst_3_tot_stu_cont => x_im_inst_3_tot_stu_cont,
x_im_inst_3_tot_par_cont => x_im_inst_3_tot_par_cont,
x_im_inst_3_tot_family_cont => x_im_inst_3_tot_family_cont,
x_im_inst_3_va_benefits => x_im_inst_3_va_benefits,
x_im_inst_3_est_financial_need => x_im_inst_3_est_financial_need,
x_fm_inst_1_federal_efc => x_fm_inst_1_federal_efc,
x_fm_inst_1_va_benefits => x_fm_inst_1_va_benefits,
x_fm_inst_1_fed_eligibility => x_fm_inst_1_fed_eligibility,
x_fm_inst_1_pell => x_fm_inst_1_pell,
x_option_par_loss_allow_ind => x_option_par_loss_allow_ind,
x_option_par_tuition_ind => x_option_par_tuition_ind,
x_option_par_home_ind => x_option_par_home_ind,
x_option_par_home_value => x_option_par_home_value,
x_option_par_home_debt => x_option_par_home_debt,
x_option_stu_ira_keogh_ind => x_option_stu_ira_keogh_ind,
x_option_stu_home_ind => x_option_stu_home_ind,
x_option_stu_home_value => x_option_stu_home_value,
x_option_stu_home_debt => x_option_stu_home_debt,
x_option_stu_sum_ay_inc_ind => x_option_stu_sum_ay_inc_ind,
x_option_par_hope_ll_credit => x_option_par_hope_ll_credit,
x_option_stu_hope_ll_credit => x_option_stu_hope_ll_credit,
x_im_parent_1_8_months_bas => x_im_parent_1_8_months_bas,
x_im_p_more_than_9_mth_ba => x_im_p_more_than_9_mth_ba,
x_im_parent_1_8_months_opt => x_im_parent_1_8_months_opt,
x_im_p_more_than_9_mth_op => x_im_p_more_than_9_mth_op,
x_fnar_message_1 => x_fnar_message_1,
x_fnar_message_2 => x_fnar_message_2,
x_fnar_message_3 => x_fnar_message_3,
x_fnar_message_4 => x_fnar_message_4,
x_fnar_message_5 => x_fnar_message_5,
x_fnar_message_6 => x_fnar_message_6,
x_fnar_message_7 => x_fnar_message_7,
x_fnar_message_8 => x_fnar_message_8,
x_fnar_message_9 => x_fnar_message_9,
x_fnar_message_10 => x_fnar_message_10,
x_fnar_message_11 => x_fnar_message_11,
x_fnar_message_12 => x_fnar_message_12,
x_fnar_message_13 => x_fnar_message_13,
x_fnar_message_20 => x_fnar_message_20,
x_fnar_message_21 => x_fnar_message_21,
x_fnar_message_22 => x_fnar_message_22,
x_fnar_message_23 => x_fnar_message_23,
x_fnar_message_24 => x_fnar_message_24,
x_fnar_message_25 => x_fnar_message_25,
x_fnar_message_26 => x_fnar_message_26,
x_fnar_message_27 => x_fnar_message_27,
x_fnar_message_30 => x_fnar_message_30,
x_fnar_message_31 => x_fnar_message_31,
x_fnar_message_32 => x_fnar_message_32,
x_fnar_message_33 => x_fnar_message_33,
x_fnar_message_34 => x_fnar_message_34,
x_fnar_message_35 => x_fnar_message_35,
x_fnar_message_36 => x_fnar_message_36,
x_fnar_message_37 => x_fnar_message_37,
x_fnar_message_38 => x_fnar_message_38,
x_fnar_message_39 => x_fnar_message_39,
x_fnar_message_45 => x_fnar_message_45,
x_fnar_message_46 => x_fnar_message_46,
x_fnar_message_47 => x_fnar_message_47,
x_fnar_message_48 => x_fnar_message_48,
x_fnar_message_50 => x_fnar_message_50,
x_fnar_message_51 => x_fnar_message_51,
x_fnar_message_52 => x_fnar_message_52,
x_fnar_message_53 => x_fnar_message_53,
x_fnar_message_56 => x_fnar_message_56,
x_fnar_message_57 => x_fnar_message_57,
x_fnar_message_58 => x_fnar_message_58,
x_fnar_message_59 => x_fnar_message_59,
x_fnar_message_60 => x_fnar_message_60,
x_fnar_message_61 => x_fnar_message_61,
x_fnar_message_62 => x_fnar_message_62,
x_fnar_message_63 => x_fnar_message_63,
x_fnar_message_64 => x_fnar_message_64,
x_fnar_message_65 => x_fnar_message_65,
x_fnar_message_71 => x_fnar_message_71,
x_fnar_message_72 => x_fnar_message_72,
x_fnar_message_73 => x_fnar_message_73,
x_fnar_message_74 => x_fnar_message_74,
x_fnar_message_75 => x_fnar_message_75,
x_fnar_message_76 => x_fnar_message_76,
x_fnar_message_77 => x_fnar_message_77,
x_fnar_message_78 => x_fnar_message_78,
x_fnar_mesg_10_stu_fam_mem => x_fnar_mesg_10_stu_fam_mem,
x_fnar_mesg_11_stu_no_in_coll => x_fnar_mesg_11_stu_no_in_coll,
x_fnar_mesg_24_stu_avail_inc => x_fnar_mesg_24_stu_avail_inc,
x_fnar_mesg_26_stu_taxes => x_fnar_mesg_26_stu_taxes,
x_fnar_mesg_33_stu_home_value => x_fnar_mesg_33_stu_home_value,
x_fnar_mesg_34_stu_home_value => x_fnar_mesg_34_stu_home_value,
x_fnar_mesg_34_stu_home_equity => x_fnar_mesg_34_stu_home_equity,
x_fnar_mesg_35_stu_home_value => x_fnar_mesg_35_stu_home_value,
x_fnar_mesg_35_stu_home_equity => x_fnar_mesg_35_stu_home_equity,
x_fnar_mesg_36_stu_home_equity => x_fnar_mesg_36_stu_home_equity,
x_fnar_mesg_48_par_fam_mem => x_fnar_mesg_48_par_fam_mem,
x_fnar_mesg_49_par_no_in_coll => x_fnar_mesg_49_par_no_in_coll,
x_fnar_mesg_56_par_agi => x_fnar_mesg_56_par_agi,
x_fnar_mesg_62_par_taxes => x_fnar_mesg_62_par_taxes,
x_fnar_mesg_73_par_home_value => x_fnar_mesg_73_par_home_value,
x_fnar_mesg_74_par_home_value => x_fnar_mesg_74_par_home_value,
x_fnar_mesg_74_par_home_equity => x_fnar_mesg_74_par_home_equity,
x_fnar_mesg_75_par_home_value => x_fnar_mesg_75_par_home_value,
x_fnar_mesg_75_par_home_equity => x_fnar_mesg_75_par_home_equity,
x_fnar_mesg_76_par_home_equity => x_fnar_mesg_76_par_home_equity,
x_assumption_message_1 => x_assumption_message_1,
x_assumption_message_2 => x_assumption_message_2,
x_assumption_message_3 => x_assumption_message_3,
x_assumption_message_4 => x_assumption_message_4,
x_assumption_message_5 => x_assumption_message_5,
x_assumption_message_6 => x_assumption_message_6,
x_record_mark => x_record_mark,
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_fnar_message_55 => x_fnar_message_55,
x_fnar_message_49 => x_fnar_message_49,
x_opt_par_cola_adj_ind => x_opt_par_cola_adj_ind,
x_opt_par_stu_fa_assets_ind => x_opt_par_stu_fa_assets_ind,
x_opt_par_ipt_assets_ind => x_opt_par_ipt_assets_ind,
x_opt_stu_ipt_assets_ind => x_opt_stu_ipt_assets_ind,
x_opt_par_cola_adj_value => x_opt_par_cola_adj_value,
x_legacy_record_flag => x_legacy_record_flag,
x_opt_ind_stu_ipt_assets_flag => x_opt_ind_stu_ipt_assets_flag,
x_cust_parent_cont_adj_num => x_cust_parent_cont_adj_num,
x_custodial_parent_num => x_custodial_parent_num,
x_cust_par_base_prcnt_inc_amt => x_cust_par_base_prcnt_inc_amt,
x_cust_par_base_cont_inc_amt => x_cust_par_base_cont_inc_amt,
x_cust_par_base_cont_ast_amt => x_cust_par_base_cont_ast_amt,
x_cust_par_base_tot_cont_amt => x_cust_par_base_tot_cont_amt ,
x_cust_par_opt_prcnt_inc_amt => x_cust_par_opt_prcnt_inc_amt,
x_cust_par_opt_cont_inc_amt => x_cust_par_opt_cont_inc_amt,
x_cust_par_opt_cont_ast_amt => x_cust_par_opt_cont_ast_amt,
x_cust_par_opt_tot_cont_amt => x_cust_par_opt_tot_cont_amt,
x_parents_email_txt => x_parents_email_txt,
x_parent_1_birth_date => x_parent_1_birth_date,
x_parent_2_birth_date => x_parent_2_birth_date
);
UPDATE igf_ap_css_fnar_all
SET
cssp_id = new_references.cssp_id,
r_s_email_address = new_references.r_s_email_address,
eps_code = new_references.eps_code,
comp_css_dependency_status = new_references.comp_css_dependency_status,
stu_age = new_references.stu_age,
assumed_stu_yr_in_coll = new_references.assumed_stu_yr_in_coll,
comp_stu_marital_status = new_references.comp_stu_marital_status,
stu_family_members = new_references.stu_family_members,
stu_fam_members_in_college = new_references.stu_fam_members_in_college,
par_marital_status = new_references.par_marital_status,
par_family_members = new_references.par_family_members,
par_total_in_college = new_references.par_total_in_college,
par_par_in_college = new_references.par_par_in_college,
par_others_in_college = new_references.par_others_in_college,
par_aesa = new_references.par_aesa,
par_cesa = new_references.par_cesa,
stu_aesa = new_references.stu_aesa,
stu_cesa = new_references.stu_cesa,
im_p_bas_agi_taxable_income = new_references.im_p_bas_agi_taxable_income,
im_p_bas_untx_inc_and_ben = new_references.im_p_bas_untx_inc_and_ben,
im_p_bas_inc_adj = new_references.im_p_bas_inc_adj,
im_p_bas_total_income = new_references.im_p_bas_total_income,
im_p_bas_us_income_tax = new_references.im_p_bas_us_income_tax,
im_p_bas_st_and_other_tax = new_references.im_p_bas_st_and_other_tax,
im_p_bas_fica_tax = new_references.im_p_bas_fica_tax,
im_p_bas_med_dental = new_references.im_p_bas_med_dental,
im_p_bas_employment_allow = new_references.im_p_bas_employment_allow,
im_p_bas_annual_ed_savings = new_references.im_p_bas_annual_ed_savings,
im_p_bas_inc_prot_allow_m = new_references.im_p_bas_inc_prot_allow_m,
im_p_bas_total_inc_allow = new_references.im_p_bas_total_inc_allow,
im_p_bas_cal_avail_inc = new_references.im_p_bas_cal_avail_inc,
im_p_bas_avail_income = new_references.im_p_bas_avail_income,
im_p_bas_total_cont_inc = new_references.im_p_bas_total_cont_inc,
im_p_bas_cash_bank_accounts = new_references.im_p_bas_cash_bank_accounts,
im_p_bas_home_equity = new_references.im_p_bas_home_equity,
im_p_bas_ot_rl_est_inv_eq = new_references.im_p_bas_ot_rl_est_inv_eq,
im_p_bas_adj_bus_farm_worth = new_references.im_p_bas_adj_bus_farm_worth,
im_p_bas_ass_sibs_pre_tui = new_references.im_p_bas_ass_sibs_pre_tui,
im_p_bas_net_worth = new_references.im_p_bas_net_worth,
im_p_bas_emerg_res_allow = new_references.im_p_bas_emerg_res_allow,
im_p_bas_cum_ed_savings = new_references.im_p_bas_cum_ed_savings,
im_p_bas_low_inc_allow = new_references.im_p_bas_low_inc_allow,
im_p_bas_total_asset_allow = new_references.im_p_bas_total_asset_allow,
im_p_bas_disc_net_worth = new_references.im_p_bas_disc_net_worth,
im_p_bas_total_cont_asset = new_references.im_p_bas_total_cont_asset,
im_p_bas_total_cont = new_references.im_p_bas_total_cont,
im_p_bas_num_in_coll_adj = new_references.im_p_bas_num_in_coll_adj,
im_p_bas_cont_for_stu = new_references.im_p_bas_cont_for_stu,
im_p_bas_cont_from_income = new_references.im_p_bas_cont_from_income,
im_p_bas_cont_from_assets = new_references.im_p_bas_cont_from_assets,
im_p_opt_agi_taxable_income = new_references.im_p_opt_agi_taxable_income,
im_p_opt_untx_inc_and_ben = new_references.im_p_opt_untx_inc_and_ben,
im_p_opt_inc_adj = new_references.im_p_opt_inc_adj,
im_p_opt_total_income = new_references.im_p_opt_total_income,
im_p_opt_us_income_tax = new_references.im_p_opt_us_income_tax,
im_p_opt_st_and_other_tax = new_references.im_p_opt_st_and_other_tax,
im_p_opt_fica_tax = new_references.im_p_opt_fica_tax,
im_p_opt_med_dental = new_references.im_p_opt_med_dental,
im_p_opt_elem_sec_tuit = new_references.im_p_opt_elem_sec_tuit,
im_p_opt_employment_allow = new_references.im_p_opt_employment_allow,
im_p_opt_annual_ed_savings = new_references.im_p_opt_annual_ed_savings,
im_p_opt_inc_prot_allow_m = new_references.im_p_opt_inc_prot_allow_m,
im_p_opt_total_inc_allow = new_references.im_p_opt_total_inc_allow,
im_p_opt_cal_avail_inc = new_references.im_p_opt_cal_avail_inc,
im_p_opt_avail_income = new_references.im_p_opt_avail_income,
im_p_opt_total_cont_inc = new_references.im_p_opt_total_cont_inc,
im_p_opt_cash_bank_accounts = new_references.im_p_opt_cash_bank_accounts,
im_p_opt_home_equity = new_references.im_p_opt_home_equity,
im_p_opt_ot_rl_est_inv_eq = new_references.im_p_opt_ot_rl_est_inv_eq,
im_p_opt_adj_bus_farm_worth = new_references.im_p_opt_adj_bus_farm_worth,
im_p_opt_ass_sibs_pre_tui = new_references.im_p_opt_ass_sibs_pre_tui,
im_p_opt_net_worth = new_references.im_p_opt_net_worth,
im_p_opt_emerg_res_allow = new_references.im_p_opt_emerg_res_allow,
im_p_opt_cum_ed_savings = new_references.im_p_opt_cum_ed_savings,
im_p_opt_low_inc_allow = new_references.im_p_opt_low_inc_allow,
im_p_opt_total_asset_allow = new_references.im_p_opt_total_asset_allow,
im_p_opt_disc_net_worth = new_references.im_p_opt_disc_net_worth,
im_p_opt_total_cont_asset = new_references.im_p_opt_total_cont_asset,
im_p_opt_total_cont = new_references.im_p_opt_total_cont,
im_p_opt_num_in_coll_adj = new_references.im_p_opt_num_in_coll_adj,
im_p_opt_cont_for_stu = new_references.im_p_opt_cont_for_stu,
im_p_opt_cont_from_income = new_references.im_p_opt_cont_from_income,
im_p_opt_cont_from_assets = new_references.im_p_opt_cont_from_assets,
fm_p_analysis_type = new_references.fm_p_analysis_type,
fm_p_agi_taxable_income = new_references.fm_p_agi_taxable_income,
fm_p_untx_inc_and_ben = new_references.fm_p_untx_inc_and_ben,
fm_p_inc_adj = new_references.fm_p_inc_adj,
fm_p_total_income = new_references.fm_p_total_income,
fm_p_us_income_tax = new_references.fm_p_us_income_tax,
fm_p_state_and_other_taxes = new_references.fm_p_state_and_other_taxes,
fm_p_fica_tax = new_references.fm_p_fica_tax,
fm_p_employment_allow = new_references.fm_p_employment_allow,
fm_p_income_prot_allow = new_references.fm_p_income_prot_allow,
fm_p_total_allow = new_references.fm_p_total_allow,
fm_p_avail_income = new_references.fm_p_avail_income,
fm_p_cash_bank_accounts = new_references.fm_p_cash_bank_accounts,
fm_p_ot_rl_est_inv_equity = new_references.fm_p_ot_rl_est_inv_equity,
fm_p_adj_bus_farm_net_worth = new_references.fm_p_adj_bus_farm_net_worth,
fm_p_net_worth = new_references.fm_p_net_worth,
fm_p_asset_prot_allow = new_references.fm_p_asset_prot_allow,
fm_p_disc_net_worth = new_references.fm_p_disc_net_worth,
fm_p_total_contribution = new_references.fm_p_total_contribution,
fm_p_num_in_coll = new_references.fm_p_num_in_coll,
fm_p_cont_for_stu = new_references.fm_p_cont_for_stu,
fm_p_cont_from_income = new_references.fm_p_cont_from_income,
fm_p_cont_from_assets = new_references.fm_p_cont_from_assets,
im_s_bas_agi_taxable_income = new_references.im_s_bas_agi_taxable_income,
im_s_bas_untx_inc_and_ben = new_references.im_s_bas_untx_inc_and_ben,
im_s_bas_inc_adj = new_references.im_s_bas_inc_adj,
im_s_bas_total_income = new_references.im_s_bas_total_income,
im_s_bas_us_income_tax = new_references.im_s_bas_us_income_tax,
im_s_bas_state_and_oth_taxes = new_references.im_s_bas_state_and_oth_taxes,
im_s_bas_fica_tax = new_references.im_s_bas_fica_tax,
im_s_bas_med_dental = new_references.im_s_bas_med_dental,
im_s_bas_employment_allow = new_references.im_s_bas_employment_allow,
im_s_bas_annual_ed_savings = new_references.im_s_bas_annual_ed_savings,
im_s_bas_inc_prot_allow_m = new_references.im_s_bas_inc_prot_allow_m,
im_s_bas_total_inc_allow = new_references.im_s_bas_total_inc_allow,
im_s_bas_cal_avail_income = new_references.im_s_bas_cal_avail_income,
im_s_bas_avail_income = new_references.im_s_bas_avail_income,
im_s_bas_total_cont_inc = new_references.im_s_bas_total_cont_inc,
im_s_bas_cash_bank_accounts = new_references.im_s_bas_cash_bank_accounts,
im_s_bas_home_equity = new_references.im_s_bas_home_equity,
im_s_bas_ot_rl_est_inv_eq = new_references.im_s_bas_ot_rl_est_inv_eq,
im_s_bas_adj_busfarm_worth = new_references.im_s_bas_adj_busfarm_worth,
im_s_bas_trusts = new_references.im_s_bas_trusts,
im_s_bas_net_worth = new_references.im_s_bas_net_worth,
im_s_bas_emerg_res_allow = new_references.im_s_bas_emerg_res_allow,
im_s_bas_cum_ed_savings = new_references.im_s_bas_cum_ed_savings,
im_s_bas_total_asset_allow = new_references.im_s_bas_total_asset_allow,
im_s_bas_disc_net_worth = new_references.im_s_bas_disc_net_worth,
im_s_bas_total_cont_asset = new_references.im_s_bas_total_cont_asset,
im_s_bas_total_cont = new_references.im_s_bas_total_cont,
im_s_bas_num_in_coll_adj = new_references.im_s_bas_num_in_coll_adj,
im_s_bas_cont_for_stu = new_references.im_s_bas_cont_for_stu,
im_s_bas_cont_from_income = new_references.im_s_bas_cont_from_income,
im_s_bas_cont_from_assets = new_references.im_s_bas_cont_from_assets,
im_s_est_agitaxable_income = new_references.im_s_est_agitaxable_income,
im_s_est_untx_inc_and_ben = new_references.im_s_est_untx_inc_and_ben,
im_s_est_inc_adj = new_references.im_s_est_inc_adj,
im_s_est_total_income = new_references.im_s_est_total_income,
im_s_est_us_income_tax = new_references.im_s_est_us_income_tax,
im_s_est_state_and_oth_taxes = new_references.im_s_est_state_and_oth_taxes,
im_s_est_fica_tax = new_references.im_s_est_fica_tax,
im_s_est_med_dental = new_references.im_s_est_med_dental,
im_s_est_employment_allow = new_references.im_s_est_employment_allow,
im_s_est_annual_ed_savings = new_references.im_s_est_annual_ed_savings,
im_s_est_inc_prot_allow_m = new_references.im_s_est_inc_prot_allow_m,
im_s_est_total_inc_allow = new_references.im_s_est_total_inc_allow,
im_s_est_cal_avail_income = new_references.im_s_est_cal_avail_income,
im_s_est_avail_income = new_references.im_s_est_avail_income,
im_s_est_total_cont_inc = new_references.im_s_est_total_cont_inc,
im_s_est_cash_bank_accounts = new_references.im_s_est_cash_bank_accounts,
im_s_est_home_equity = new_references.im_s_est_home_equity,
im_s_est_ot_rl_est_inv_eq = new_references.im_s_est_ot_rl_est_inv_eq,
im_s_est_adj_bus_farm_worth = new_references.im_s_est_adj_bus_farm_worth,
im_s_est_est_trusts = new_references.im_s_est_est_trusts,
im_s_est_net_worth = new_references.im_s_est_net_worth,
im_s_est_emerg_res_allow = new_references.im_s_est_emerg_res_allow,
im_s_est_cum_ed_savings = new_references.im_s_est_cum_ed_savings,
im_s_est_total_asset_allow = new_references.im_s_est_total_asset_allow,
im_s_est_disc_net_worth = new_references.im_s_est_disc_net_worth,
im_s_est_total_cont_asset = new_references.im_s_est_total_cont_asset,
im_s_est_total_cont = new_references.im_s_est_total_cont,
im_s_est_num_in_coll_adj = new_references.im_s_est_num_in_coll_adj,
im_s_est_cont_for_stu = new_references.im_s_est_cont_for_stu,
im_s_est_cont_from_income = new_references.im_s_est_cont_from_income,
im_s_est_cont_from_assets = new_references.im_s_est_cont_from_assets,
im_s_opt_agi_taxable_income = new_references.im_s_opt_agi_taxable_income,
im_s_opt_untx_inc_and_ben = new_references.im_s_opt_untx_inc_and_ben,
im_s_opt_inc_adj = new_references.im_s_opt_inc_adj,
im_s_opt_total_income = new_references.im_s_opt_total_income,
im_s_opt_us_income_tax = new_references.im_s_opt_us_income_tax,
im_s_opt_state_and_oth_taxes = new_references.im_s_opt_state_and_oth_taxes,
im_s_opt_fica_tax = new_references.im_s_opt_fica_tax,
im_s_opt_med_dental = new_references.im_s_opt_med_dental,
im_s_opt_employment_allow = new_references.im_s_opt_employment_allow,
im_s_opt_annual_ed_savings = new_references.im_s_opt_annual_ed_savings,
im_s_opt_inc_prot_allow_m = new_references.im_s_opt_inc_prot_allow_m,
im_s_opt_total_inc_allow = new_references.im_s_opt_total_inc_allow,
im_s_opt_cal_avail_income = new_references.im_s_opt_cal_avail_income,
im_s_opt_avail_income = new_references.im_s_opt_avail_income,
im_s_opt_total_cont_inc = new_references.im_s_opt_total_cont_inc,
im_s_opt_cash_bank_accounts = new_references.im_s_opt_cash_bank_accounts,
im_s_opt_ira_keogh_accounts = new_references.im_s_opt_ira_keogh_accounts,
im_s_opt_home_equity = new_references.im_s_opt_home_equity,
im_s_opt_ot_rl_est_inv_eq = new_references.im_s_opt_ot_rl_est_inv_eq,
im_s_opt_adj_bus_farm_worth = new_references.im_s_opt_adj_bus_farm_worth,
im_s_opt_trusts = new_references.im_s_opt_trusts,
im_s_opt_net_worth = new_references.im_s_opt_net_worth,
im_s_opt_emerg_res_allow = new_references.im_s_opt_emerg_res_allow,
im_s_opt_cum_ed_savings = new_references.im_s_opt_cum_ed_savings,
im_s_opt_total_asset_allow = new_references.im_s_opt_total_asset_allow,
im_s_opt_disc_net_worth = new_references.im_s_opt_disc_net_worth,
im_s_opt_total_cont_asset = new_references.im_s_opt_total_cont_asset,
im_s_opt_total_cont = new_references.im_s_opt_total_cont,
im_s_opt_num_in_coll_adj = new_references.im_s_opt_num_in_coll_adj,
im_s_opt_cont_for_stu = new_references.im_s_opt_cont_for_stu,
im_s_opt_cont_from_income = new_references.im_s_opt_cont_from_income,
im_s_opt_cont_from_assets = new_references.im_s_opt_cont_from_assets,
fm_s_analysis_type = new_references.fm_s_analysis_type,
fm_s_agi_taxable_income = new_references.fm_s_agi_taxable_income,
fm_s_untx_inc_and_ben = new_references.fm_s_untx_inc_and_ben,
fm_s_inc_adj = new_references.fm_s_inc_adj,
fm_s_total_income = new_references.fm_s_total_income,
fm_s_us_income_tax = new_references.fm_s_us_income_tax,
fm_s_state_and_oth_taxes = new_references.fm_s_state_and_oth_taxes,
fm_s_fica_tax = new_references.fm_s_fica_tax,
fm_s_employment_allow = new_references.fm_s_employment_allow,
fm_s_income_prot_allow = new_references.fm_s_income_prot_allow,
fm_s_total_allow = new_references.fm_s_total_allow,
fm_s_cal_avail_income = new_references.fm_s_cal_avail_income,
fm_s_avail_income = new_references.fm_s_avail_income,
fm_s_cash_bank_accounts = new_references.fm_s_cash_bank_accounts,
fm_s_ot_rl_est_inv_equity = new_references.fm_s_ot_rl_est_inv_equity,
fm_s_adj_bus_farm_worth = new_references.fm_s_adj_bus_farm_worth,
fm_s_trusts = new_references.fm_s_trusts,
fm_s_net_worth = new_references.fm_s_net_worth,
fm_s_asset_prot_allow = new_references.fm_s_asset_prot_allow,
fm_s_disc_net_worth = new_references.fm_s_disc_net_worth,
fm_s_total_cont = new_references.fm_s_total_cont,
fm_s_num_in_coll = new_references.fm_s_num_in_coll,
fm_s_cont_for_stu = new_references.fm_s_cont_for_stu,
fm_s_cont_from_income = new_references.fm_s_cont_from_income,
fm_s_cont_from_assets = new_references.fm_s_cont_from_assets,
im_inst_resident_ind = new_references.im_inst_resident_ind,
institutional_1_budget_name = new_references.institutional_1_budget_name,
im_inst_1_budget_duration = new_references.im_inst_1_budget_duration,
im_inst_1_tuition_fees = new_references.im_inst_1_tuition_fees,
im_inst_1_books_supplies = new_references.im_inst_1_books_supplies,
im_inst_1_living_expenses = new_references.im_inst_1_living_expenses,
im_inst_1_tot_expenses = new_references.im_inst_1_tot_expenses,
im_inst_1_tot_stu_cont = new_references.im_inst_1_tot_stu_cont,
im_inst_1_tot_par_cont = new_references.im_inst_1_tot_par_cont,
im_inst_1_tot_family_cont = new_references.im_inst_1_tot_family_cont,
im_inst_1_va_benefits = new_references.im_inst_1_va_benefits,
im_inst_1_ot_cont = new_references.im_inst_1_ot_cont,
im_inst_1_est_financial_need = new_references.im_inst_1_est_financial_need,
institutional_2_budget_name = new_references.institutional_2_budget_name,
im_inst_2_budget_duration = new_references.im_inst_2_budget_duration,
im_inst_2_tuition_fees = new_references.im_inst_2_tuition_fees,
im_inst_2_books_supplies = new_references.im_inst_2_books_supplies,
im_inst_2_living_expenses = new_references.im_inst_2_living_expenses,
im_inst_2_tot_expenses = new_references.im_inst_2_tot_expenses,
im_inst_2_tot_stu_cont = new_references.im_inst_2_tot_stu_cont,
im_inst_2_tot_par_cont = new_references.im_inst_2_tot_par_cont,
im_inst_2_tot_family_cont = new_references.im_inst_2_tot_family_cont,
im_inst_2_va_benefits = new_references.im_inst_2_va_benefits,
im_inst_2_est_financial_need = new_references.im_inst_2_est_financial_need,
institutional_3_budget_name = new_references.institutional_3_budget_name,
im_inst_3_budget_duration = new_references.im_inst_3_budget_duration,
im_inst_3_tuition_fees = new_references.im_inst_3_tuition_fees,
im_inst_3_books_supplies = new_references.im_inst_3_books_supplies,
im_inst_3_living_expenses = new_references.im_inst_3_living_expenses,
im_inst_3_tot_expenses = new_references.im_inst_3_tot_expenses,
im_inst_3_tot_stu_cont = new_references.im_inst_3_tot_stu_cont,
im_inst_3_tot_par_cont = new_references.im_inst_3_tot_par_cont,
im_inst_3_tot_family_cont = new_references.im_inst_3_tot_family_cont,
im_inst_3_va_benefits = new_references.im_inst_3_va_benefits,
im_inst_3_est_financial_need = new_references.im_inst_3_est_financial_need,
fm_inst_1_federal_efc = new_references.fm_inst_1_federal_efc,
fm_inst_1_va_benefits = new_references.fm_inst_1_va_benefits,
fm_inst_1_fed_eligibility = new_references.fm_inst_1_fed_eligibility,
fm_inst_1_pell = new_references.fm_inst_1_pell,
option_par_loss_allow_ind = new_references.option_par_loss_allow_ind,
option_par_tuition_ind = new_references.option_par_tuition_ind,
option_par_home_ind = new_references.option_par_home_ind,
option_par_home_value = new_references.option_par_home_value,
option_par_home_debt = new_references.option_par_home_debt,
option_stu_ira_keogh_ind = new_references.option_stu_ira_keogh_ind,
option_stu_home_ind = new_references.option_stu_home_ind,
option_stu_home_value = new_references.option_stu_home_value,
option_stu_home_debt = new_references.option_stu_home_debt,
option_stu_sum_ay_inc_ind = new_references.option_stu_sum_ay_inc_ind,
option_par_hope_ll_credit = new_references.option_par_hope_ll_credit,
option_stu_hope_ll_credit = new_references.option_stu_hope_ll_credit,
im_parent_1_8_months_bas = new_references.im_parent_1_8_months_bas,
im_p_more_than_9_mth_ba = new_references.im_p_more_than_9_mth_ba,
im_parent_1_8_months_opt = new_references.im_parent_1_8_months_opt,
im_p_more_than_9_mth_op = new_references.im_p_more_than_9_mth_op,
fnar_message_1 = new_references.fnar_message_1,
fnar_message_2 = new_references.fnar_message_2,
fnar_message_3 = new_references.fnar_message_3,
fnar_message_4 = new_references.fnar_message_4,
fnar_message_5 = new_references.fnar_message_5,
fnar_message_6 = new_references.fnar_message_6,
fnar_message_7 = new_references.fnar_message_7,
fnar_message_8 = new_references.fnar_message_8,
fnar_message_9 = new_references.fnar_message_9,
fnar_message_10 = new_references.fnar_message_10,
fnar_message_11 = new_references.fnar_message_11,
fnar_message_12 = new_references.fnar_message_12,
fnar_message_13 = new_references.fnar_message_13,
fnar_message_20 = new_references.fnar_message_20,
fnar_message_21 = new_references.fnar_message_21,
fnar_message_22 = new_references.fnar_message_22,
fnar_message_23 = new_references.fnar_message_23,
fnar_message_24 = new_references.fnar_message_24,
fnar_message_25 = new_references.fnar_message_25,
fnar_message_26 = new_references.fnar_message_26,
fnar_message_27 = new_references.fnar_message_27,
fnar_message_30 = new_references.fnar_message_30,
fnar_message_31 = new_references.fnar_message_31,
fnar_message_32 = new_references.fnar_message_32,
fnar_message_33 = new_references.fnar_message_33,
fnar_message_34 = new_references.fnar_message_34,
fnar_message_35 = new_references.fnar_message_35,
fnar_message_36 = new_references.fnar_message_36,
fnar_message_37 = new_references.fnar_message_37,
fnar_message_38 = new_references.fnar_message_38,
fnar_message_39 = new_references.fnar_message_39,
fnar_message_45 = new_references.fnar_message_45,
fnar_message_46 = new_references.fnar_message_46,
fnar_message_47 = new_references.fnar_message_47,
fnar_message_48 = new_references.fnar_message_48,
fnar_message_50 = new_references.fnar_message_50,
fnar_message_51 = new_references.fnar_message_51,
fnar_message_52 = new_references.fnar_message_52,
fnar_message_53 = new_references.fnar_message_53,
fnar_message_56 = new_references.fnar_message_56,
fnar_message_57 = new_references.fnar_message_57,
fnar_message_58 = new_references.fnar_message_58,
fnar_message_59 = new_references.fnar_message_59,
fnar_message_60 = new_references.fnar_message_60,
fnar_message_61 = new_references.fnar_message_61,
fnar_message_62 = new_references.fnar_message_62,
fnar_message_63 = new_references.fnar_message_63,
fnar_message_64 = new_references.fnar_message_64,
fnar_message_65 = new_references.fnar_message_65,
fnar_message_71 = new_references.fnar_message_71,
fnar_message_72 = new_references.fnar_message_72,
fnar_message_73 = new_references.fnar_message_73,
fnar_message_74 = new_references.fnar_message_74,
fnar_message_75 = new_references.fnar_message_75,
fnar_message_76 = new_references.fnar_message_76,
fnar_message_77 = new_references.fnar_message_77,
fnar_message_78 = new_references.fnar_message_78,
fnar_mesg_10_stu_fam_mem = new_references.fnar_mesg_10_stu_fam_mem,
fnar_mesg_11_stu_no_in_coll = new_references.fnar_mesg_11_stu_no_in_coll,
fnar_mesg_24_stu_avail_inc = new_references.fnar_mesg_24_stu_avail_inc,
fnar_mesg_26_stu_taxes = new_references.fnar_mesg_26_stu_taxes,
fnar_mesg_33_stu_home_value = new_references.fnar_mesg_33_stu_home_value,
fnar_mesg_34_stu_home_value = new_references.fnar_mesg_34_stu_home_value,
fnar_mesg_34_stu_home_equity = new_references.fnar_mesg_34_stu_home_equity,
fnar_mesg_35_stu_home_value = new_references.fnar_mesg_35_stu_home_value,
fnar_mesg_35_stu_home_equity = new_references.fnar_mesg_35_stu_home_equity,
fnar_mesg_36_stu_home_equity = new_references.fnar_mesg_36_stu_home_equity,
fnar_mesg_48_par_fam_mem = new_references.fnar_mesg_48_par_fam_mem,
fnar_mesg_49_par_no_in_coll = new_references.fnar_mesg_49_par_no_in_coll,
fnar_mesg_56_par_agi = new_references.fnar_mesg_56_par_agi,
fnar_mesg_62_par_taxes = new_references.fnar_mesg_62_par_taxes,
fnar_mesg_73_par_home_value = new_references.fnar_mesg_73_par_home_value,
fnar_mesg_74_par_home_value = new_references.fnar_mesg_74_par_home_value,
fnar_mesg_74_par_home_equity = new_references.fnar_mesg_74_par_home_equity,
fnar_mesg_75_par_home_value = new_references.fnar_mesg_75_par_home_value,
fnar_mesg_75_par_home_equity = new_references.fnar_mesg_75_par_home_equity,
fnar_mesg_76_par_home_equity = new_references.fnar_mesg_76_par_home_equity,
assumption_message_1 = new_references.assumption_message_1,
assumption_message_2 = new_references.assumption_message_2,
assumption_message_3 = new_references.assumption_message_3,
assumption_message_4 = new_references.assumption_message_4,
assumption_message_5 = new_references.assumption_message_5,
assumption_message_6 = new_references.assumption_message_6,
record_mark = new_references.record_mark,
last_update_date = x_last_update_date,
last_updated_by = x_last_updated_by,
last_update_login = x_last_update_login,
fnar_message_55 = new_references.fnar_message_55,
fnar_message_49 = new_references.fnar_message_49,
option_par_cola_adj_ind = new_references.option_par_cola_adj_ind,
option_par_stu_fa_assets_ind = new_references.option_par_stu_fa_assets_ind,
option_par_ipt_assets_ind = new_references.option_par_ipt_assets_ind,
option_stu_ipt_assets_ind = new_references.option_stu_ipt_assets_ind,
option_par_cola_adj_value = new_references.option_par_cola_adj_value,
legacy_record_flag = new_references.legacy_record_flag,
option_ind_stu_ipt_assets_flag = new_references.option_ind_stu_ipt_assets_flag,
cust_parent_cont_adj_num = new_references.cust_parent_cont_adj_num,
custodial_parent_num = new_references.custodial_parent_num,
cust_par_base_prcnt_inc_amt = new_references.cust_par_base_prcnt_inc_amt,
cust_par_base_cont_inc_amt = new_references.cust_par_base_cont_inc_amt,
cust_par_base_cont_ast_amt = new_references.cust_par_base_cont_ast_amt,
cust_par_base_tot_cont_amt = new_references.cust_par_base_tot_cont_amt,
cust_par_opt_prcnt_inc_amt = new_references.cust_par_opt_prcnt_inc_amt,
cust_par_opt_cont_inc_amt = new_references.cust_par_opt_cont_inc_amt,
cust_par_opt_cont_ast_amt = new_references.cust_par_opt_cont_ast_amt,
cust_par_opt_tot_cont_amt = new_references.cust_par_opt_tot_cont_amt,
parents_email_txt = new_references.parents_email_txt,
parent_1_birth_date = new_references.parent_1_birth_date,
parent_2_birth_date = new_references.parent_2_birth_date
WHERE rowid = x_rowid;
END update_row;
|| 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_css_fnar_all
WHERE fnar_id = x_fnar_id;
insert_row (
x_rowid,
x_fnar_id,
x_cssp_id,
x_r_s_email_address,
x_eps_code,
x_comp_css_dependency_status,
x_stu_age,
x_assumed_stu_yr_in_coll,
x_comp_stu_marital_status,
x_stu_family_members,
x_stu_fam_members_in_college,
x_par_marital_status,
x_par_family_members,
x_par_total_in_college,
x_par_par_in_college,
x_par_others_in_college,
x_par_aesa,
x_par_cesa,
x_stu_aesa,
x_stu_cesa,
x_im_p_bas_agi_taxable_income,
x_im_p_bas_untx_inc_and_ben,
x_im_p_bas_inc_adj,
x_im_p_bas_total_income,
x_im_p_bas_us_income_tax,
x_im_p_bas_st_and_other_tax,
x_im_p_bas_fica_tax,
x_im_p_bas_med_dental,
x_im_p_bas_employment_allow,
x_im_p_bas_annual_ed_savings,
x_im_p_bas_inc_prot_allow_m,
x_im_p_bas_total_inc_allow,
x_im_p_bas_cal_avail_inc,
x_im_p_bas_avail_income,
x_im_p_bas_total_cont_inc,
x_im_p_bas_cash_bank_accounts,
x_im_p_bas_home_equity,
x_im_p_bas_ot_rl_est_inv_eq,
x_im_p_bas_adj_bus_farm_worth,
x_im_p_bas_ass_sibs_pre_tui,
x_im_p_bas_net_worth,
x_im_p_bas_emerg_res_allow,
x_im_p_bas_cum_ed_savings,
x_im_p_bas_low_inc_allow,
x_im_p_bas_total_asset_allow,
x_im_p_bas_disc_net_worth,
x_im_p_bas_total_cont_asset,
x_im_p_bas_total_cont,
x_im_p_bas_num_in_coll_adj,
x_im_p_bas_cont_for_stu,
x_im_p_bas_cont_from_income,
x_im_p_bas_cont_from_assets,
x_im_p_opt_agi_taxable_income,
x_im_p_opt_untx_inc_and_ben,
x_im_p_opt_inc_adj,
x_im_p_opt_total_income,
x_im_p_opt_us_income_tax,
x_im_p_opt_st_and_other_tax,
x_im_p_opt_fica_tax,
x_im_p_opt_med_dental,
x_im_p_opt_elem_sec_tuit,
x_im_p_opt_employment_allow,
x_im_p_opt_annual_ed_savings,
x_im_p_opt_inc_prot_allow_m,
x_im_p_opt_total_inc_allow,
x_im_p_opt_cal_avail_inc,
x_im_p_opt_avail_income,
x_im_p_opt_total_cont_inc,
x_im_p_opt_cash_bank_accounts,
x_im_p_opt_home_equity,
x_im_p_opt_ot_rl_est_inv_eq,
x_im_p_opt_adj_bus_farm_worth,
x_im_p_opt_ass_sibs_pre_tui,
x_im_p_opt_net_worth,
x_im_p_opt_emerg_res_allow,
x_im_p_opt_cum_ed_savings,
x_im_p_opt_low_inc_allow,
x_im_p_opt_total_asset_allow,
x_im_p_opt_disc_net_worth,
x_im_p_opt_total_cont_asset,
x_im_p_opt_total_cont,
x_im_p_opt_num_in_coll_adj,
x_im_p_opt_cont_for_stu,
x_im_p_opt_cont_from_income,
x_im_p_opt_cont_from_assets,
x_fm_p_analysis_type,
x_fm_p_agi_taxable_income,
x_fm_p_untx_inc_and_ben,
x_fm_p_inc_adj,
x_fm_p_total_income,
x_fm_p_us_income_tax,
x_fm_p_state_and_other_taxes,
x_fm_p_fica_tax,
x_fm_p_employment_allow,
x_fm_p_income_prot_allow,
x_fm_p_total_allow,
x_fm_p_avail_income,
x_fm_p_cash_bank_accounts,
x_fm_p_ot_rl_est_inv_equity,
x_fm_p_adj_bus_farm_net_worth,
x_fm_p_net_worth,
x_fm_p_asset_prot_allow,
x_fm_p_disc_net_worth,
x_fm_p_total_contribution,
x_fm_p_num_in_coll,
x_fm_p_cont_for_stu,
x_fm_p_cont_from_income,
x_fm_p_cont_from_assets,
x_im_s_bas_agi_taxable_income,
x_im_s_bas_untx_inc_and_ben,
x_im_s_bas_inc_adj,
x_im_s_bas_total_income,
x_im_s_bas_us_income_tax,
x_im_s_bas_state_and_oth_taxes,
x_im_s_bas_fica_tax,
x_im_s_bas_med_dental,
x_im_s_bas_employment_allow,
x_im_s_bas_annual_ed_savings,
x_im_s_bas_inc_prot_allow_m,
x_im_s_bas_total_inc_allow,
x_im_s_bas_cal_avail_income,
x_im_s_bas_avail_income,
x_im_s_bas_total_cont_inc,
x_im_s_bas_cash_bank_accounts,
x_im_s_bas_home_equity,
x_im_s_bas_ot_rl_est_inv_eq,
x_im_s_bas_adj_busfarm_worth,
x_im_s_bas_trusts,
x_im_s_bas_net_worth,
x_im_s_bas_emerg_res_allow,
x_im_s_bas_cum_ed_savings,
x_im_s_bas_total_asset_allow,
x_im_s_bas_disc_net_worth,
x_im_s_bas_total_cont_asset,
x_im_s_bas_total_cont,
x_im_s_bas_num_in_coll_adj,
x_im_s_bas_cont_for_stu,
x_im_s_bas_cont_from_income,
x_im_s_bas_cont_from_assets,
x_im_s_est_agitaxable_income,
x_im_s_est_untx_inc_and_ben,
x_im_s_est_inc_adj,
x_im_s_est_total_income,
x_im_s_est_us_income_tax,
x_im_s_est_state_and_oth_taxes,
x_im_s_est_fica_tax,
x_im_s_est_med_dental,
x_im_s_est_employment_allow,
x_im_s_est_annual_ed_savings,
x_im_s_est_inc_prot_allow_m,
x_im_s_est_total_inc_allow,
x_im_s_est_cal_avail_income,
x_im_s_est_avail_income,
x_im_s_est_total_cont_inc,
x_im_s_est_cash_bank_accounts,
x_im_s_est_home_equity,
x_im_s_est_ot_rl_est_inv_eq,
x_im_s_est_adj_bus_farm_worth,
x_im_s_est_est_trusts,
x_im_s_est_net_worth,
x_im_s_est_emerg_res_allow,
x_im_s_est_cum_ed_savings,
x_im_s_est_total_asset_allow,
x_im_s_est_disc_net_worth,
x_im_s_est_total_cont_asset,
x_im_s_est_total_cont,
x_im_s_est_num_in_coll_adj,
x_im_s_est_cont_for_stu,
x_im_s_est_cont_from_income,
x_im_s_est_cont_from_assets,
x_im_s_opt_agi_taxable_income,
x_im_s_opt_untx_inc_and_ben,
x_im_s_opt_inc_adj,
x_im_s_opt_total_income,
x_im_s_opt_us_income_tax,
x_im_s_opt_state_and_oth_taxes,
x_im_s_opt_fica_tax,
x_im_s_opt_med_dental,
x_im_s_opt_employment_allow,
x_im_s_opt_annual_ed_savings,
x_im_s_opt_inc_prot_allow_m,
x_im_s_opt_total_inc_allow,
x_im_s_opt_cal_avail_income,
x_im_s_opt_avail_income,
x_im_s_opt_total_cont_inc,
x_im_s_opt_cash_bank_accounts,
x_im_s_opt_ira_keogh_accounts,
x_im_s_opt_home_equity,
x_im_s_opt_ot_rl_est_inv_eq,
x_im_s_opt_adj_bus_farm_worth,
x_im_s_opt_trusts,
x_im_s_opt_net_worth,
x_im_s_opt_emerg_res_allow,
x_im_s_opt_cum_ed_savings,
x_im_s_opt_total_asset_allow,
x_im_s_opt_disc_net_worth,
x_im_s_opt_total_cont_asset,
x_im_s_opt_total_cont,
x_im_s_opt_num_in_coll_adj,
x_im_s_opt_cont_for_stu,
x_im_s_opt_cont_from_income,
x_im_s_opt_cont_from_assets,
x_fm_s_analysis_type,
x_fm_s_agi_taxable_income,
x_fm_s_untx_inc_and_ben,
x_fm_s_inc_adj,
x_fm_s_total_income,
x_fm_s_us_income_tax,
x_fm_s_state_and_oth_taxes,
x_fm_s_fica_tax,
x_fm_s_employment_allow,
x_fm_s_income_prot_allow,
x_fm_s_total_allow,
x_fm_s_cal_avail_income,
x_fm_s_avail_income,
x_fm_s_cash_bank_accounts,
x_fm_s_ot_rl_est_inv_equity,
x_fm_s_adj_bus_farm_worth,
x_fm_s_trusts,
x_fm_s_net_worth,
x_fm_s_asset_prot_allow,
x_fm_s_disc_net_worth,
x_fm_s_total_cont,
x_fm_s_num_in_coll,
x_fm_s_cont_for_stu,
x_fm_s_cont_from_income,
x_fm_s_cont_from_assets,
x_im_inst_resident_ind,
x_institutional_1_budget_name,
x_im_inst_1_budget_duration,
x_im_inst_1_tuition_fees,
x_im_inst_1_books_supplies,
x_im_inst_1_living_expenses,
x_im_inst_1_tot_expenses,
x_im_inst_1_tot_stu_cont,
x_im_inst_1_tot_par_cont,
x_im_inst_1_tot_family_cont,
x_im_inst_1_va_benefits,
x_im_inst_1_ot_cont,
x_im_inst_1_est_financial_need,
x_institutional_2_budget_name,
x_im_inst_2_budget_duration,
x_im_inst_2_tuition_fees,
x_im_inst_2_books_supplies,
x_im_inst_2_living_expenses,
x_im_inst_2_tot_expenses,
x_im_inst_2_tot_stu_cont,
x_im_inst_2_tot_par_cont,
x_im_inst_2_tot_family_cont,
x_im_inst_2_va_benefits,
x_im_inst_2_est_financial_need,
x_institutional_3_budget_name,
x_im_inst_3_budget_duration,
x_im_inst_3_tuition_fees,
x_im_inst_3_books_supplies,
x_im_inst_3_living_expenses,
x_im_inst_3_tot_expenses,
x_im_inst_3_tot_stu_cont,
x_im_inst_3_tot_par_cont,
x_im_inst_3_tot_family_cont,
x_im_inst_3_va_benefits,
x_im_inst_3_est_financial_need,
x_fm_inst_1_federal_efc,
x_fm_inst_1_va_benefits,
x_fm_inst_1_fed_eligibility,
x_fm_inst_1_pell,
x_option_par_loss_allow_ind,
x_option_par_tuition_ind,
x_option_par_home_ind,
x_option_par_home_value,
x_option_par_home_debt,
x_option_stu_ira_keogh_ind,
x_option_stu_home_ind,
x_option_stu_home_value,
x_option_stu_home_debt,
x_option_stu_sum_ay_inc_ind,
x_option_par_hope_ll_credit,
x_option_stu_hope_ll_credit,
x_im_parent_1_8_months_bas,
x_im_p_more_than_9_mth_ba,
x_im_parent_1_8_months_opt,
x_im_p_more_than_9_mth_op,
x_fnar_message_1,
x_fnar_message_2,
x_fnar_message_3,
x_fnar_message_4,
x_fnar_message_5,
x_fnar_message_6,
x_fnar_message_7,
x_fnar_message_8,
x_fnar_message_9,
x_fnar_message_10,
x_fnar_message_11,
x_fnar_message_12,
x_fnar_message_13,
x_fnar_message_20,
x_fnar_message_21,
x_fnar_message_22,
x_fnar_message_23,
x_fnar_message_24,
x_fnar_message_25,
x_fnar_message_26,
x_fnar_message_27,
x_fnar_message_30,
x_fnar_message_31,
x_fnar_message_32,
x_fnar_message_33,
x_fnar_message_34,
x_fnar_message_35,
x_fnar_message_36,
x_fnar_message_37,
x_fnar_message_38,
x_fnar_message_39,
x_fnar_message_45,
x_fnar_message_46,
x_fnar_message_47,
x_fnar_message_48,
x_fnar_message_50,
x_fnar_message_51,
x_fnar_message_52,
x_fnar_message_53,
x_fnar_message_56,
x_fnar_message_57,
x_fnar_message_58,
x_fnar_message_59,
x_fnar_message_60,
x_fnar_message_61,
x_fnar_message_62,
x_fnar_message_63,
x_fnar_message_64,
x_fnar_message_65,
x_fnar_message_71,
x_fnar_message_72,
x_fnar_message_73,
x_fnar_message_74,
x_fnar_message_75,
x_fnar_message_76,
x_fnar_message_77,
x_fnar_message_78,
x_fnar_mesg_10_stu_fam_mem,
x_fnar_mesg_11_stu_no_in_coll,
x_fnar_mesg_24_stu_avail_inc,
x_fnar_mesg_26_stu_taxes,
x_fnar_mesg_33_stu_home_value,
x_fnar_mesg_34_stu_home_value,
x_fnar_mesg_34_stu_home_equity,
x_fnar_mesg_35_stu_home_value,
x_fnar_mesg_35_stu_home_equity,
x_fnar_mesg_36_stu_home_equity,
x_fnar_mesg_48_par_fam_mem,
x_fnar_mesg_49_par_no_in_coll,
x_fnar_mesg_56_par_agi,
x_fnar_mesg_62_par_taxes,
x_fnar_mesg_73_par_home_value,
x_fnar_mesg_74_par_home_value,
x_fnar_mesg_74_par_home_equity,
x_fnar_mesg_75_par_home_value,
x_fnar_mesg_75_par_home_equity,
x_fnar_mesg_76_par_home_equity,
x_assumption_message_1,
x_assumption_message_2,
x_assumption_message_3,
x_assumption_message_4,
x_assumption_message_5,
x_assumption_message_6,
x_record_mark,
x_mode,
x_fnar_message_55,
x_fnar_message_49,
x_opt_par_cola_adj_ind,
x_opt_par_stu_fa_assets_ind,
x_opt_par_ipt_assets_ind,
x_opt_stu_ipt_assets_ind,
x_opt_par_cola_adj_value,
x_legacy_record_flag,
x_opt_ind_stu_ipt_assets_flag,
x_cust_parent_cont_adj_num,
x_custodial_parent_num,
x_cust_par_base_prcnt_inc_amt,
x_cust_par_base_cont_inc_amt,
x_cust_par_base_cont_ast_amt,
x_cust_par_base_tot_cont_amt,
x_cust_par_opt_prcnt_inc_amt,
x_cust_par_opt_cont_inc_amt,
x_cust_par_opt_cont_ast_amt,
x_cust_par_opt_tot_cont_amt,
x_parents_email_txt,
x_parent_1_birth_date,
x_parent_2_birth_date
);
update_row (
x_rowid,
x_fnar_id,
x_cssp_id,
x_r_s_email_address,
x_eps_code,
x_comp_css_dependency_status,
x_stu_age,
x_assumed_stu_yr_in_coll,
x_comp_stu_marital_status,
x_stu_family_members,
x_stu_fam_members_in_college,
x_par_marital_status,
x_par_family_members,
x_par_total_in_college,
x_par_par_in_college,
x_par_others_in_college,
x_par_aesa,
x_par_cesa,
x_stu_aesa,
x_stu_cesa,
x_im_p_bas_agi_taxable_income,
x_im_p_bas_untx_inc_and_ben,
x_im_p_bas_inc_adj,
x_im_p_bas_total_income,
x_im_p_bas_us_income_tax,
x_im_p_bas_st_and_other_tax,
x_im_p_bas_fica_tax,
x_im_p_bas_med_dental,
x_im_p_bas_employment_allow,
x_im_p_bas_annual_ed_savings,
x_im_p_bas_inc_prot_allow_m,
x_im_p_bas_total_inc_allow,
x_im_p_bas_cal_avail_inc,
x_im_p_bas_avail_income,
x_im_p_bas_total_cont_inc,
x_im_p_bas_cash_bank_accounts,
x_im_p_bas_home_equity,
x_im_p_bas_ot_rl_est_inv_eq,
x_im_p_bas_adj_bus_farm_worth,
x_im_p_bas_ass_sibs_pre_tui,
x_im_p_bas_net_worth,
x_im_p_bas_emerg_res_allow,
x_im_p_bas_cum_ed_savings,
x_im_p_bas_low_inc_allow,
x_im_p_bas_total_asset_allow,
x_im_p_bas_disc_net_worth,
x_im_p_bas_total_cont_asset,
x_im_p_bas_total_cont,
x_im_p_bas_num_in_coll_adj,
x_im_p_bas_cont_for_stu,
x_im_p_bas_cont_from_income,
x_im_p_bas_cont_from_assets,
x_im_p_opt_agi_taxable_income,
x_im_p_opt_untx_inc_and_ben,
x_im_p_opt_inc_adj,
x_im_p_opt_total_income,
x_im_p_opt_us_income_tax,
x_im_p_opt_st_and_other_tax,
x_im_p_opt_fica_tax,
x_im_p_opt_med_dental,
x_im_p_opt_elem_sec_tuit,
x_im_p_opt_employment_allow,
x_im_p_opt_annual_ed_savings,
x_im_p_opt_inc_prot_allow_m,
x_im_p_opt_total_inc_allow,
x_im_p_opt_cal_avail_inc,
x_im_p_opt_avail_income,
x_im_p_opt_total_cont_inc,
x_im_p_opt_cash_bank_accounts,
x_im_p_opt_home_equity,
x_im_p_opt_ot_rl_est_inv_eq,
x_im_p_opt_adj_bus_farm_worth,
x_im_p_opt_ass_sibs_pre_tui,
x_im_p_opt_net_worth,
x_im_p_opt_emerg_res_allow,
x_im_p_opt_cum_ed_savings,
x_im_p_opt_low_inc_allow,
x_im_p_opt_total_asset_allow,
x_im_p_opt_disc_net_worth,
x_im_p_opt_total_cont_asset,
x_im_p_opt_total_cont,
x_im_p_opt_num_in_coll_adj,
x_im_p_opt_cont_for_stu,
x_im_p_opt_cont_from_income,
x_im_p_opt_cont_from_assets,
x_fm_p_analysis_type,
x_fm_p_agi_taxable_income,
x_fm_p_untx_inc_and_ben,
x_fm_p_inc_adj,
x_fm_p_total_income,
x_fm_p_us_income_tax,
x_fm_p_state_and_other_taxes,
x_fm_p_fica_tax,
x_fm_p_employment_allow,
x_fm_p_income_prot_allow,
x_fm_p_total_allow,
x_fm_p_avail_income,
x_fm_p_cash_bank_accounts,
x_fm_p_ot_rl_est_inv_equity,
x_fm_p_adj_bus_farm_net_worth,
x_fm_p_net_worth,
x_fm_p_asset_prot_allow,
x_fm_p_disc_net_worth,
x_fm_p_total_contribution,
x_fm_p_num_in_coll,
x_fm_p_cont_for_stu,
x_fm_p_cont_from_income,
x_fm_p_cont_from_assets,
x_im_s_bas_agi_taxable_income,
x_im_s_bas_untx_inc_and_ben,
x_im_s_bas_inc_adj,
x_im_s_bas_total_income,
x_im_s_bas_us_income_tax,
x_im_s_bas_state_and_oth_taxes,
x_im_s_bas_fica_tax,
x_im_s_bas_med_dental,
x_im_s_bas_employment_allow,
x_im_s_bas_annual_ed_savings,
x_im_s_bas_inc_prot_allow_m,
x_im_s_bas_total_inc_allow,
x_im_s_bas_cal_avail_income,
x_im_s_bas_avail_income,
x_im_s_bas_total_cont_inc,
x_im_s_bas_cash_bank_accounts,
x_im_s_bas_home_equity,
x_im_s_bas_ot_rl_est_inv_eq,
x_im_s_bas_adj_busfarm_worth,
x_im_s_bas_trusts,
x_im_s_bas_net_worth,
x_im_s_bas_emerg_res_allow,
x_im_s_bas_cum_ed_savings,
x_im_s_bas_total_asset_allow,
x_im_s_bas_disc_net_worth,
x_im_s_bas_total_cont_asset,
x_im_s_bas_total_cont,
x_im_s_bas_num_in_coll_adj,
x_im_s_bas_cont_for_stu,
x_im_s_bas_cont_from_income,
x_im_s_bas_cont_from_assets,
x_im_s_est_agitaxable_income,
x_im_s_est_untx_inc_and_ben,
x_im_s_est_inc_adj,
x_im_s_est_total_income,
x_im_s_est_us_income_tax,
x_im_s_est_state_and_oth_taxes,
x_im_s_est_fica_tax,
x_im_s_est_med_dental,
x_im_s_est_employment_allow,
x_im_s_est_annual_ed_savings,
x_im_s_est_inc_prot_allow_m,
x_im_s_est_total_inc_allow,
x_im_s_est_cal_avail_income,
x_im_s_est_avail_income,
x_im_s_est_total_cont_inc,
x_im_s_est_cash_bank_accounts,
x_im_s_est_home_equity,
x_im_s_est_ot_rl_est_inv_eq,
x_im_s_est_adj_bus_farm_worth,
x_im_s_est_est_trusts,
x_im_s_est_net_worth,
x_im_s_est_emerg_res_allow,
x_im_s_est_cum_ed_savings,
x_im_s_est_total_asset_allow,
x_im_s_est_disc_net_worth,
x_im_s_est_total_cont_asset,
x_im_s_est_total_cont,
x_im_s_est_num_in_coll_adj,
x_im_s_est_cont_for_stu,
x_im_s_est_cont_from_income,
x_im_s_est_cont_from_assets,
x_im_s_opt_agi_taxable_income,
x_im_s_opt_untx_inc_and_ben,
x_im_s_opt_inc_adj,
x_im_s_opt_total_income,
x_im_s_opt_us_income_tax,
x_im_s_opt_state_and_oth_taxes,
x_im_s_opt_fica_tax,
x_im_s_opt_med_dental,
x_im_s_opt_employment_allow,
x_im_s_opt_annual_ed_savings,
x_im_s_opt_inc_prot_allow_m,
x_im_s_opt_total_inc_allow,
x_im_s_opt_cal_avail_income,
x_im_s_opt_avail_income,
x_im_s_opt_total_cont_inc,
x_im_s_opt_cash_bank_accounts,
x_im_s_opt_ira_keogh_accounts,
x_im_s_opt_home_equity,
x_im_s_opt_ot_rl_est_inv_eq,
x_im_s_opt_adj_bus_farm_worth,
x_im_s_opt_trusts,
x_im_s_opt_net_worth,
x_im_s_opt_emerg_res_allow,
x_im_s_opt_cum_ed_savings,
x_im_s_opt_total_asset_allow,
x_im_s_opt_disc_net_worth,
x_im_s_opt_total_cont_asset,
x_im_s_opt_total_cont,
x_im_s_opt_num_in_coll_adj,
x_im_s_opt_cont_for_stu,
x_im_s_opt_cont_from_income,
x_im_s_opt_cont_from_assets,
x_fm_s_analysis_type,
x_fm_s_agi_taxable_income,
x_fm_s_untx_inc_and_ben,
x_fm_s_inc_adj,
x_fm_s_total_income,
x_fm_s_us_income_tax,
x_fm_s_state_and_oth_taxes,
x_fm_s_fica_tax,
x_fm_s_employment_allow,
x_fm_s_income_prot_allow,
x_fm_s_total_allow,
x_fm_s_cal_avail_income,
x_fm_s_avail_income,
x_fm_s_cash_bank_accounts,
x_fm_s_ot_rl_est_inv_equity,
x_fm_s_adj_bus_farm_worth,
x_fm_s_trusts,
x_fm_s_net_worth,
x_fm_s_asset_prot_allow,
x_fm_s_disc_net_worth,
x_fm_s_total_cont,
x_fm_s_num_in_coll,
x_fm_s_cont_for_stu,
x_fm_s_cont_from_income,
x_fm_s_cont_from_assets,
x_im_inst_resident_ind,
x_institutional_1_budget_name,
x_im_inst_1_budget_duration,
x_im_inst_1_tuition_fees,
x_im_inst_1_books_supplies,
x_im_inst_1_living_expenses,
x_im_inst_1_tot_expenses,
x_im_inst_1_tot_stu_cont,
x_im_inst_1_tot_par_cont,
x_im_inst_1_tot_family_cont,
x_im_inst_1_va_benefits,
x_im_inst_1_ot_cont,
x_im_inst_1_est_financial_need,
x_institutional_2_budget_name,
x_im_inst_2_budget_duration,
x_im_inst_2_tuition_fees,
x_im_inst_2_books_supplies,
x_im_inst_2_living_expenses,
x_im_inst_2_tot_expenses,
x_im_inst_2_tot_stu_cont,
x_im_inst_2_tot_par_cont,
x_im_inst_2_tot_family_cont,
x_im_inst_2_va_benefits,
x_im_inst_2_est_financial_need,
x_institutional_3_budget_name,
x_im_inst_3_budget_duration,
x_im_inst_3_tuition_fees,
x_im_inst_3_books_supplies,
x_im_inst_3_living_expenses,
x_im_inst_3_tot_expenses,
x_im_inst_3_tot_stu_cont,
x_im_inst_3_tot_par_cont,
x_im_inst_3_tot_family_cont,
x_im_inst_3_va_benefits,
x_im_inst_3_est_financial_need,
x_fm_inst_1_federal_efc,
x_fm_inst_1_va_benefits,
x_fm_inst_1_fed_eligibility,
x_fm_inst_1_pell,
x_option_par_loss_allow_ind,
x_option_par_tuition_ind,
x_option_par_home_ind,
x_option_par_home_value,
x_option_par_home_debt,
x_option_stu_ira_keogh_ind,
x_option_stu_home_ind,
x_option_stu_home_value,
x_option_stu_home_debt,
x_option_stu_sum_ay_inc_ind,
x_option_par_hope_ll_credit,
x_option_stu_hope_ll_credit,
x_im_parent_1_8_months_bas,
x_im_p_more_than_9_mth_ba,
x_im_parent_1_8_months_opt,
x_im_p_more_than_9_mth_op,
x_fnar_message_1,
x_fnar_message_2,
x_fnar_message_3,
x_fnar_message_4,
x_fnar_message_5,
x_fnar_message_6,
x_fnar_message_7,
x_fnar_message_8,
x_fnar_message_9,
x_fnar_message_10,
x_fnar_message_11,
x_fnar_message_12,
x_fnar_message_13,
x_fnar_message_20,
x_fnar_message_21,
x_fnar_message_22,
x_fnar_message_23,
x_fnar_message_24,
x_fnar_message_25,
x_fnar_message_26,
x_fnar_message_27,
x_fnar_message_30,
x_fnar_message_31,
x_fnar_message_32,
x_fnar_message_33,
x_fnar_message_34,
x_fnar_message_35,
x_fnar_message_36,
x_fnar_message_37,
x_fnar_message_38,
x_fnar_message_39,
x_fnar_message_45,
x_fnar_message_46,
x_fnar_message_47,
x_fnar_message_48,
x_fnar_message_50,
x_fnar_message_51,
x_fnar_message_52,
x_fnar_message_53,
x_fnar_message_56,
x_fnar_message_57,
x_fnar_message_58,
x_fnar_message_59,
x_fnar_message_60,
x_fnar_message_61,
x_fnar_message_62,
x_fnar_message_63,
x_fnar_message_64,
x_fnar_message_65,
x_fnar_message_71,
x_fnar_message_72,
x_fnar_message_73,
x_fnar_message_74,
x_fnar_message_75,
x_fnar_message_76,
x_fnar_message_77,
x_fnar_message_78,
x_fnar_mesg_10_stu_fam_mem,
x_fnar_mesg_11_stu_no_in_coll,
x_fnar_mesg_24_stu_avail_inc,
x_fnar_mesg_26_stu_taxes,
x_fnar_mesg_33_stu_home_value,
x_fnar_mesg_34_stu_home_value,
x_fnar_mesg_34_stu_home_equity,
x_fnar_mesg_35_stu_home_value,
x_fnar_mesg_35_stu_home_equity,
x_fnar_mesg_36_stu_home_equity,
x_fnar_mesg_48_par_fam_mem,
x_fnar_mesg_49_par_no_in_coll,
x_fnar_mesg_56_par_agi,
x_fnar_mesg_62_par_taxes,
x_fnar_mesg_73_par_home_value,
x_fnar_mesg_74_par_home_value,
x_fnar_mesg_74_par_home_equity,
x_fnar_mesg_75_par_home_value,
x_fnar_mesg_75_par_home_equity,
x_fnar_mesg_76_par_home_equity,
x_assumption_message_1,
x_assumption_message_2,
x_assumption_message_3,
x_assumption_message_4,
x_assumption_message_5,
x_assumption_message_6,
x_record_mark,
x_mode,
x_fnar_message_55,
x_fnar_message_49,
x_opt_par_cola_adj_ind,
x_opt_par_stu_fa_assets_ind,
x_opt_par_ipt_assets_ind,
x_opt_stu_ipt_assets_ind,
x_opt_par_cola_adj_value,
x_legacy_record_flag,
x_opt_ind_stu_ipt_assets_flag,
x_cust_parent_cont_adj_num,
x_custodial_parent_num,
x_cust_par_base_prcnt_inc_amt,
x_cust_par_base_cont_inc_amt,
x_cust_par_base_cont_ast_amt,
x_cust_par_base_tot_cont_amt,
x_cust_par_opt_prcnt_inc_amt,
x_cust_par_opt_cont_inc_amt,
x_cust_par_opt_cont_ast_amt,
x_cust_par_opt_tot_cont_amt,
x_parents_email_txt,
x_parent_1_birth_date,
x_parent_2_birth_date
);
PROCEDURE delete_row (
x_rowid IN VARCHAR2
) AS
/*
|| Created By : vivuyyur
|| Created On : 30-MAY-2001
|| 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_css_fnar_all
WHERE rowid = x_rowid;
END delete_row;