DBA Data[Home] [Help]

APPS.IGF_AP_UHK_INAS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 398

                    pr_last_updated_by            IN OUT NOCOPY igf_ap_css_profile.last_updated_by%TYPE              ,
                    pr_last_update_date           IN OUT NOCOPY igf_ap_css_profile.last_update_date%TYPE             ,
                    pr_last_update_login          IN OUT NOCOPY igf_ap_css_profile.last_update_login%TYPE            ,
                    pr_p_soc_sec_ben_student_amt  IN OUT NOCOPY igf_ap_css_profile.p_soc_sec_ben_student_amt%TYPE    ,
                    pr_p_tuit_fee_deduct_amt      IN OUT NOCOPY igf_ap_css_profile.p_tuit_fee_deduct_amt%TYPE        ,
                    pr_stu_lives_with_num         IN OUT NOCOPY igf_ap_css_profile.stu_lives_with_num%TYPE           ,
                    pr_stu_most_support_from_num  IN OUT NOCOPY igf_ap_css_profile.stu_most_support_from_num%TYPE    ,
                    pr_location_computer_num      IN OUT NOCOPY igf_ap_css_profile.location_computer_num%TYPE        ,

                    f_fnar_id                               IN OUT NOCOPY igf_ap_css_fnar.fnar_id%TYPE                       ,
                    f_cssp_id                               IN OUT NOCOPY igf_ap_css_fnar.cssp_id%TYPE                      ,
                    f_r_s_email_address                     IN OUT NOCOPY igf_ap_css_fnar.r_s_email_address%TYPE            ,
                    f_eps_code                              IN OUT NOCOPY igf_ap_css_fnar.eps_code%TYPE                     ,
                    f_comp_css_dependency_status            IN OUT NOCOPY igf_ap_css_fnar.comp_css_dependency_status%TYPE   ,
                    f_stu_age                               IN OUT NOCOPY igf_ap_css_fnar.stu_age%TYPE                      ,
                    f_assumed_stu_yr_in_coll                IN OUT NOCOPY igf_ap_css_fnar.assumed_stu_yr_in_coll%TYPE       ,
                    f_comp_stu_marital_status               IN OUT NOCOPY igf_ap_css_fnar.comp_stu_marital_status%TYPE      ,
                    f_stu_family_members                    IN OUT NOCOPY igf_ap_css_fnar.stu_family_members%TYPE           ,
                    f_stu_fam_members_in_college            IN OUT NOCOPY igf_ap_css_fnar.stu_fam_members_in_college%TYPE   ,
                    f_par_marital_status                    IN OUT NOCOPY igf_ap_css_fnar.par_marital_status%TYPE           ,
                    f_par_family_members                    IN OUT NOCOPY igf_ap_css_fnar.par_family_members%TYPE           ,
                    f_par_total_in_college                  IN OUT NOCOPY igf_ap_css_fnar.par_total_in_college%TYPE         ,
                    f_par_par_in_college                    IN OUT NOCOPY igf_ap_css_fnar.par_par_in_college%TYPE           ,
                    f_par_others_in_college                 IN OUT NOCOPY igf_ap_css_fnar.par_others_in_college%TYPE        ,
                    f_par_aesa                              IN OUT NOCOPY igf_ap_css_fnar.par_aesa%TYPE                     ,
                    f_par_cesa                              IN OUT NOCOPY igf_ap_css_fnar.par_cesa%TYPE                     ,
                    f_stu_aesa                              IN OUT NOCOPY igf_ap_css_fnar.stu_aesa%TYPE                     ,
                    f_stu_cesa                              IN OUT NOCOPY igf_ap_css_fnar.stu_cesa%TYPE                     ,
                    f_im_p_bas_agi_taxable_income           IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_agi_taxable_income%TYPE  ,
                    f_im_p_bas_untx_inc_and_ben             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_untx_inc_and_ben%TYPE    ,
                    f_im_p_bas_inc_adj                      IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_inc_adj%TYPE             ,
                    f_im_p_bas_total_income                 IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_income%TYPE        ,
                    f_im_p_bas_us_income_tax                IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_us_income_tax%TYPE       ,
                    f_im_p_bas_st_and_other_tax             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_st_and_other_tax%TYPE    ,
                    f_im_p_bas_fica_tax                     IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_fica_tax%TYPE            ,
                    f_im_p_bas_med_dental                   IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_med_dental%TYPE          ,
                    f_im_p_bas_employment_allow             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_employment_allow%TYPE    ,
                    f_im_p_bas_annual_ed_savings            IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_annual_ed_savings%TYPE   ,
                    f_im_p_bas_inc_prot_allow_m             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_inc_prot_allow_m%TYPE    ,
                    f_im_p_bas_total_inc_allow              IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_inc_allow%TYPE     ,
                    f_im_p_bas_cal_avail_inc                IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cal_avail_inc%TYPE       ,
                    f_im_p_bas_avail_income                 IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_avail_income%TYPE        ,
                    f_im_p_bas_total_cont_inc               IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_cont_inc%TYPE      ,
                    f_im_p_bas_cash_bank_accounts           IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cash_bank_accounts%TYPE  ,
                    f_im_p_bas_home_equity                  IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_home_equity%TYPE         ,
                    f_im_p_bas_ot_rl_est_inv_eq             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_ot_rl_est_inv_eq%TYPE    ,
                    f_im_p_bas_adj_bus_farm_worth           IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_adj_bus_farm_worth%TYPE  ,
                    f_im_p_bas_ass_sibs_pre_tui             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_ass_sibs_pre_tui%TYPE    ,
                    f_im_p_bas_net_worth                    IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_net_worth%TYPE           ,
                    f_im_p_bas_emerg_res_allow              IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_emerg_res_allow%TYPE     ,
                    f_im_p_bas_cum_ed_savings               IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cum_ed_savings%TYPE      ,
                    f_im_p_bas_low_inc_allow                IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_low_inc_allow%TYPE       ,
                    f_im_p_bas_total_asset_allow            IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_asset_allow%TYPE   ,
                    f_im_p_bas_disc_net_worth               IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_disc_net_worth%TYPE      ,
                    f_im_p_bas_total_cont_asset             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_cont_asset%TYPE    ,
                    f_im_p_bas_total_cont                   IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_cont%TYPE          ,
                    f_im_p_bas_num_in_coll_adj              IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_num_in_coll_adj%TYPE     ,
                    f_im_p_bas_cont_for_stu                 IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cont_for_stu%TYPE        ,
                    f_im_p_bas_cont_from_income             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cont_from_income%TYPE    ,
                    f_im_p_bas_cont_from_assets             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cont_from_assets%TYPE    ,
                    f_im_p_opt_agi_taxable_income           IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_agi_taxable_income%TYPE  ,
                    f_im_p_opt_untx_inc_and_ben             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_untx_inc_and_ben%TYPE    ,
                    f_im_p_opt_inc_adj                      IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_inc_adj%TYPE             ,
                    f_im_p_opt_total_income                 IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_income%TYPE        ,
                    f_im_p_opt_us_income_tax                IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_us_income_tax%TYPE       ,
                    f_im_p_opt_st_and_other_tax             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_st_and_other_tax%TYPE    ,
                    f_im_p_opt_fica_tax                     IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_fica_tax%TYPE            ,
                    f_im_p_opt_med_dental                   IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_med_dental%TYPE          ,
                    f_im_p_opt_elem_sec_tuit                IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_elem_sec_tuit%TYPE       ,
                    f_im_p_opt_employment_allow             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_employment_allow%TYPE    ,
                    f_im_p_opt_annual_ed_savings            IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_annual_ed_savings%TYPE   ,
                    f_im_p_opt_inc_prot_allow_m             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_inc_prot_allow_m%TYPE    ,
                    f_im_p_opt_total_inc_allow              IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_inc_allow%TYPE     ,
                    f_im_p_opt_cal_avail_inc                IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cal_avail_inc%TYPE       ,
                    f_im_p_opt_avail_income                 IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_avail_income%TYPE        ,
                    f_im_p_opt_total_cont_inc               IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_cont_inc%TYPE      ,
                    f_im_p_opt_cash_bank_accounts           IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cash_bank_accounts%TYPE  ,
                    f_im_p_opt_home_equity                  IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_home_equity%TYPE         ,
                    f_im_p_opt_ot_rl_est_inv_eq             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_ot_rl_est_inv_eq%TYPE   ,
                    f_im_p_opt_adj_bus_farm_worth           IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_adj_bus_farm_worth%TYPE  ,
                    f_im_p_opt_ass_sibs_pre_tui             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_ass_sibs_pre_tui%TYPE    ,
                    f_im_p_opt_net_worth                    IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_net_worth%TYPE           ,
                    f_im_p_opt_emerg_res_allow              IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_emerg_res_allow%TYPE     ,
                    f_im_p_opt_cum_ed_savings               IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cum_ed_savings%TYPE      ,
                    f_im_p_opt_low_inc_allow                IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_low_inc_allow%TYPE       ,
                    f_im_p_opt_total_asset_allow            IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_asset_allow%TYPE   ,
                    f_im_p_opt_disc_net_worth               IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_disc_net_worth%TYPE      ,
                    f_im_p_opt_total_cont_asset             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_cont_asset%TYPE    ,
                    f_im_p_opt_total_cont                   IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_cont%TYPE          ,
                    f_im_p_opt_num_in_coll_adj              IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_num_in_coll_adj%TYPE     ,
                    f_im_p_opt_cont_for_stu                 IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cont_for_stu%TYPE        ,
                    f_im_p_opt_cont_from_income             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cont_from_income%TYPE    ,
                    f_im_p_opt_cont_from_assets             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cont_from_assets%TYPE    ,
                    f_fm_p_analysis_type                    IN OUT NOCOPY igf_ap_css_fnar.fm_p_analysis_type%TYPE           ,
                    f_fm_p_agi_taxable_income               IN OUT NOCOPY igf_ap_css_fnar.fm_p_agi_taxable_income%TYPE      ,
                    f_fm_p_untx_inc_and_ben                 IN OUT NOCOPY igf_ap_css_fnar.fm_p_untx_inc_and_ben%TYPE        ,
                    f_fm_p_inc_adj                          IN OUT NOCOPY igf_ap_css_fnar.fm_p_inc_adj%TYPE                 ,
                    f_fm_p_total_income                     IN OUT NOCOPY igf_ap_css_fnar.fm_p_total_income%TYPE            ,
                    f_fm_p_us_income_tax                    IN OUT NOCOPY igf_ap_css_fnar.fm_p_us_income_tax%TYPE           ,
                    f_fm_p_state_and_other_taxes            IN OUT NOCOPY igf_ap_css_fnar.fm_p_state_and_other_taxes%TYPE   ,
                    f_fm_p_fica_tax                         IN OUT NOCOPY igf_ap_css_fnar.fm_p_fica_tax%TYPE                ,
                    f_fm_p_employment_allow                 IN OUT NOCOPY igf_ap_css_fnar.fm_p_employment_allow%TYPE        ,
                    f_fm_p_income_prot_allow                IN OUT NOCOPY igf_ap_css_fnar.fm_p_income_prot_allow%TYPE       ,
                    f_fm_p_total_allow                      IN OUT NOCOPY igf_ap_css_fnar.fm_p_total_allow%TYPE             ,
                    f_fm_p_avail_income                     IN OUT NOCOPY igf_ap_css_fnar.fm_p_avail_income%TYPE            ,
                    f_fm_p_cash_bank_accounts               IN OUT NOCOPY igf_ap_css_fnar.fm_p_cash_bank_accounts%TYPE      ,
                    f_fm_p_ot_rl_est_inv_equity             IN OUT NOCOPY igf_ap_css_fnar.fm_p_ot_rl_est_inv_equity%TYPE    ,
                    f_fm_p_adj_bus_farm_net_worth           IN OUT NOCOPY igf_ap_css_fnar.fm_p_adj_bus_farm_net_worth%TYPE  ,
                    f_fm_p_net_worth                        IN OUT NOCOPY igf_ap_css_fnar.fm_p_net_worth%TYPE               ,
                    f_fm_p_asset_prot_allow                 IN OUT NOCOPY igf_ap_css_fnar.fm_p_asset_prot_allow%TYPE        ,
                    f_fm_p_disc_net_worth                   IN OUT NOCOPY igf_ap_css_fnar.fm_p_disc_net_worth%TYPE          ,
                    f_fm_p_total_contribution               IN OUT NOCOPY igf_ap_css_fnar.fm_p_total_contribution%TYPE      ,
                    f_fm_p_num_in_coll                      IN OUT NOCOPY igf_ap_css_fnar.fm_p_num_in_coll%TYPE             ,
                    f_fm_p_cont_for_stu                     IN OUT NOCOPY igf_ap_css_fnar.fm_p_cont_for_stu%TYPE            ,
                    f_fm_p_cont_from_income                 IN OUT NOCOPY igf_ap_css_fnar.fm_p_cont_from_income%TYPE        ,
                    f_fm_p_cont_from_assets                 IN OUT NOCOPY igf_ap_css_fnar.fm_p_cont_from_assets%TYPE        ,
                    f_im_s_bas_agi_taxable_income           IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_agi_taxable_income%TYPE  ,
                    f_im_s_bas_untx_inc_and_ben             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_untx_inc_and_ben%TYPE    ,
                    f_im_s_bas_inc_adj                      IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_inc_adj%TYPE             ,
                    f_im_s_bas_total_income                 IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_income%TYPE        ,
                    f_im_s_bas_us_income_tax                IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_us_income_tax%TYPE       ,
                    f_im_s_bas_state_and_oth_taxes          IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_state_and_oth_taxes%TYPE ,
                    f_im_s_bas_fica_tax                     IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_fica_tax%TYPE            ,
                    f_im_s_bas_med_dental                   IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_med_dental%TYPE          ,
                    f_im_s_bas_employment_allow             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_employment_allow%TYPE    ,
                    f_im_s_bas_annual_ed_savings            IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_annual_ed_savings%TYPE   ,
                    f_im_s_bas_inc_prot_allow_m             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_inc_prot_allow_m%TYPE    ,
                    f_im_s_bas_total_inc_allow              IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_inc_allow%TYPE     ,
                    f_im_s_bas_cal_avail_income             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cal_avail_income%TYPE    ,
                    f_im_s_bas_avail_income                 IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_avail_income%TYPE        ,
                    f_im_s_bas_total_cont_inc               IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_cont_inc%TYPE      ,
                    f_im_s_bas_cash_bank_accounts           IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cash_bank_accounts%TYPE  ,
                    f_im_s_bas_home_equity                  IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_home_equity%TYPE         ,
                    f_im_s_bas_ot_rl_est_inv_eq             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_ot_rl_est_inv_eq%TYPE    ,
                    f_im_s_bas_adj_busfarm_worth            IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_adj_busfarm_worth%TYPE   ,
                    f_im_s_bas_trusts                       IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_trusts%TYPE              ,
                    f_im_s_bas_net_worth                    IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_net_worth%TYPE           ,
                    f_im_s_bas_emerg_res_allow              IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_emerg_res_allow%TYPE     ,
                    f_im_s_bas_cum_ed_savings               IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cum_ed_savings%TYPE      ,
                    f_im_s_bas_total_asset_allow            IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_asset_allow%TYPE   ,
                    f_im_s_bas_disc_net_worth               IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_disc_net_worth%TYPE      ,
                    f_im_s_bas_total_cont_asset             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_cont_asset%TYPE    ,
                    f_im_s_bas_total_cont                   IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_cont%TYPE          ,
                    f_im_s_bas_num_in_coll_adj              IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_num_in_coll_adj%TYPE     ,
                    f_im_s_bas_cont_for_stu                 IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cont_for_stu%TYPE        ,
                    f_im_s_bas_cont_from_income             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cont_from_income%TYPE    ,
                    f_im_s_bas_cont_from_assets             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cont_from_assets%TYPE    ,
                    f_im_s_est_agitaxable_income            IN OUT NOCOPY igf_ap_css_fnar.im_s_est_agitaxable_income%TYPE   ,
                    f_im_s_est_untx_inc_and_ben             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_untx_inc_and_ben%TYPE    ,
                    f_im_s_est_inc_adj                      IN OUT NOCOPY igf_ap_css_fnar.im_s_est_inc_adj%TYPE             ,
                    f_im_s_est_total_income                 IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_income%TYPE        ,
                    f_im_s_est_us_income_tax                IN OUT NOCOPY igf_ap_css_fnar.im_s_est_us_income_tax%TYPE       ,
                    f_im_s_est_state_and_oth_taxes          IN OUT NOCOPY igf_ap_css_fnar.im_s_est_state_and_oth_taxes%TYPE ,
                    f_im_s_est_fica_tax                     IN OUT NOCOPY igf_ap_css_fnar.im_s_est_fica_tax%TYPE            ,
                    f_im_s_est_med_dental                   IN OUT NOCOPY igf_ap_css_fnar.im_s_est_med_dental%TYPE          ,
                    f_im_s_est_employment_allow             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_employment_allow%TYPE    ,
                    f_im_s_est_annual_ed_savings            IN OUT NOCOPY igf_ap_css_fnar.im_s_est_annual_ed_savings%TYPE   ,
                    f_im_s_est_inc_prot_allow_m             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_inc_prot_allow_m%TYPE    ,
                    f_im_s_est_total_inc_allow              IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_inc_allow%TYPE     ,
                    f_im_s_est_cal_avail_income             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cal_avail_income%TYPE    ,
                    f_im_s_est_avail_income                 IN OUT NOCOPY igf_ap_css_fnar.im_s_est_avail_income%TYPE        ,
                    f_im_s_est_total_cont_inc               IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_cont_inc%TYPE      ,
                    f_im_s_est_cash_bank_accounts           IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cash_bank_accounts%TYPE  ,
                    f_im_s_est_home_equity                  IN OUT NOCOPY igf_ap_css_fnar.im_s_est_home_equity%TYPE         ,
                    f_im_s_est_ot_rl_est_inv_eq             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_ot_rl_est_inv_eq%TYPE    ,
                    f_im_s_est_adj_bus_farm_worth           IN OUT NOCOPY igf_ap_css_fnar.im_s_est_adj_bus_farm_worth%TYPE  ,
                    f_im_s_est_est_trusts                   IN OUT NOCOPY igf_ap_css_fnar.im_s_est_est_trusts%TYPE          ,
                    f_im_s_est_net_worth                    IN OUT NOCOPY igf_ap_css_fnar.im_s_est_net_worth%TYPE           ,
                    f_im_s_est_emerg_res_allow              IN OUT NOCOPY igf_ap_css_fnar.im_s_est_emerg_res_allow%TYPE     ,
                    f_im_s_est_cum_ed_savings               IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cum_ed_savings%TYPE      ,
                    f_im_s_est_total_asset_allow            IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_asset_allow%TYPE   ,
                    f_im_s_est_disc_net_worth               IN OUT NOCOPY igf_ap_css_fnar.im_s_est_disc_net_worth%TYPE      ,
                    f_im_s_est_total_cont_asset             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_cont_asset%TYPE    ,
                    f_im_s_est_total_cont                   IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_cont%TYPE          ,
                    f_im_s_est_num_in_coll_adj              IN OUT NOCOPY igf_ap_css_fnar.im_s_est_num_in_coll_adj%TYPE     ,
                    f_im_s_est_cont_for_stu                 IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cont_for_stu%TYPE        ,
                    f_im_s_est_cont_from_income             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cont_from_income%TYPE    ,
                    f_im_s_est_cont_from_assets             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cont_from_assets%TYPE    ,
                    f_im_s_opt_agi_taxable_income           IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_agi_taxable_income%TYPE  ,
                    f_im_s_opt_untx_inc_and_ben             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_untx_inc_and_ben%TYPE    ,
                    f_im_s_opt_inc_adj                      IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_inc_adj%TYPE             ,
                    f_im_s_opt_total_income                 IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_income%TYPE        ,
                    f_im_s_opt_us_income_tax                IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_us_income_tax%TYPE       ,
                    f_im_s_opt_state_and_oth_taxes          IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_state_and_oth_taxes%TYPE ,
                    f_im_s_opt_fica_tax                     IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_fica_tax%TYPE            ,
                    f_im_s_opt_med_dental                   IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_med_dental%TYPE          ,
                    f_im_s_opt_employment_allow             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_employment_allow%TYPE    ,
                    f_im_s_opt_annual_ed_savings            IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_annual_ed_savings%TYPE   ,
                    f_im_s_opt_inc_prot_allow_m             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_inc_prot_allow_m%TYPE    ,
                    f_im_s_opt_total_inc_allow              IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_inc_allow%TYPE     ,
                    f_im_s_opt_cal_avail_income             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cal_avail_income%TYPE    ,
                    f_im_s_opt_avail_income                 IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_avail_income%TYPE        ,
                    f_im_s_opt_total_cont_inc               IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_cont_inc%TYPE      ,
                    f_im_s_opt_cash_bank_accounts           IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cash_bank_accounts%TYPE  ,
                    f_im_s_opt_ira_keogh_accounts           IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_ira_keogh_accounts%TYPE  ,
                    f_im_s_opt_home_equity                  IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_home_equity%TYPE         ,
                    f_im_s_opt_ot_rl_est_inv_eq             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_ot_rl_est_inv_eq%TYPE    ,
                    f_im_s_opt_adj_bus_farm_worth           IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_adj_bus_farm_worth%TYPE  ,
                    f_im_s_opt_trusts                       IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_trusts%TYPE              ,
                    f_im_s_opt_net_worth                    IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_net_worth%TYPE           ,
                    f_im_s_opt_emerg_res_allow              IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_emerg_res_allow%TYPE     ,
                    f_im_s_opt_cum_ed_savings               IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cum_ed_savings%TYPE      ,
                    f_im_s_opt_total_asset_allow            IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_asset_allow%TYPE   ,
                    f_im_s_opt_disc_net_worth               IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_disc_net_worth%TYPE      ,
                    f_im_s_opt_total_cont_asset             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_cont_asset%TYPE    ,
                    f_im_s_opt_total_cont                   IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_cont%TYPE          ,
                    f_im_s_opt_num_in_coll_adj              IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_num_in_coll_adj%TYPE     ,
                    f_im_s_opt_cont_for_stu                 IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cont_for_stu%TYPE        ,
                    f_im_s_opt_cont_from_income             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cont_from_income%TYPE    ,
                    f_im_s_opt_cont_from_assets             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cont_from_assets%TYPE    ,
                    f_fm_s_analysis_type                    IN OUT NOCOPY igf_ap_css_fnar.fm_s_analysis_type%TYPE           ,
                    f_fm_s_agi_taxable_income               IN OUT NOCOPY igf_ap_css_fnar.fm_s_agi_taxable_income%TYPE      ,
                    f_fm_s_untx_inc_and_ben                 IN OUT NOCOPY igf_ap_css_fnar.fm_s_untx_inc_and_ben%TYPE        ,
                    f_fm_s_inc_adj                          IN OUT NOCOPY igf_ap_css_fnar.fm_s_inc_adj%TYPE                 ,
                    f_fm_s_total_income                     IN OUT NOCOPY igf_ap_css_fnar.fm_s_total_income%TYPE            ,
                    f_fm_s_us_income_tax                    IN OUT NOCOPY igf_ap_css_fnar.fm_s_us_income_tax%TYPE           ,
                    f_fm_s_state_and_oth_taxes              IN OUT NOCOPY igf_ap_css_fnar.fm_s_state_and_oth_taxes%TYPE     ,
                    f_fm_s_fica_tax                         IN OUT NOCOPY igf_ap_css_fnar.fm_s_fica_tax%TYPE                ,
                    f_fm_s_employment_allow                 IN OUT NOCOPY igf_ap_css_fnar.fm_s_employment_allow%TYPE        ,
                    f_fm_s_income_prot_allow                IN OUT NOCOPY igf_ap_css_fnar.fm_s_income_prot_allow%TYPE       ,
                    f_fm_s_total_allow                      IN OUT NOCOPY igf_ap_css_fnar.fm_s_total_allow%TYPE             ,
                    f_fm_s_cal_avail_income                 IN OUT NOCOPY igf_ap_css_fnar.fm_s_cal_avail_income%TYPE        ,
                    f_fm_s_avail_income                     IN OUT NOCOPY igf_ap_css_fnar.fm_s_avail_income%TYPE            ,
                    f_fm_s_cash_bank_accounts               IN OUT NOCOPY igf_ap_css_fnar.fm_s_cash_bank_accounts%TYPE      ,
                    f_fm_s_ot_rl_est_inv_equity             IN OUT NOCOPY igf_ap_css_fnar.fm_s_ot_rl_est_inv_equity%TYPE    ,
                    f_fm_s_adj_bus_farm_worth               IN OUT NOCOPY igf_ap_css_fnar.fm_s_adj_bus_farm_worth%TYPE      ,
                    f_fm_s_trusts                           IN OUT NOCOPY igf_ap_css_fnar.fm_s_trusts%TYPE                  ,
                    f_fm_s_net_worth                        IN OUT NOCOPY igf_ap_css_fnar.fm_s_net_worth%TYPE              ,
                    f_fm_s_asset_prot_allow                 IN OUT NOCOPY igf_ap_css_fnar.fm_s_asset_prot_allow%TYPE        ,
                    f_fm_s_disc_net_worth                   IN OUT NOCOPY igf_ap_css_fnar.fm_s_disc_net_worth%TYPE          ,
                    f_fm_s_total_cont                       IN OUT NOCOPY igf_ap_css_fnar.fm_s_total_cont%TYPE              ,
                    f_fm_s_num_in_coll                      IN OUT NOCOPY igf_ap_css_fnar.fm_s_num_in_coll%TYPE             ,
                    f_fm_s_cont_for_stu                     IN OUT NOCOPY igf_ap_css_fnar.fm_s_cont_for_stu%TYPE            ,
                    f_fm_s_cont_from_income                 IN OUT NOCOPY igf_ap_css_fnar.fm_s_cont_from_income%TYPE        ,
                    f_fm_s_cont_from_assets                 IN OUT NOCOPY igf_ap_css_fnar.fm_s_cont_from_assets%TYPE        ,
                    f_im_inst_resident_ind                  IN OUT NOCOPY igf_ap_css_fnar.im_inst_resident_ind%TYPE         ,
                    f_institutional_1_budget_name           IN OUT NOCOPY igf_ap_css_fnar.institutional_1_budget_name%TYPE  ,
                    f_im_inst_1_budget_duration             IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_budget_duration%TYPE    ,
                    f_im_inst_1_tuition_fees                IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tuition_fees%TYPE       ,
                    f_im_inst_1_books_supplies              IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_books_supplies%TYPE     ,
                    f_im_inst_1_living_expenses             IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_living_expenses%TYPE    ,
                    f_im_inst_1_tot_expenses                IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tot_expenses%TYPE       ,
                    f_im_inst_1_tot_stu_cont                IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tot_stu_cont%TYPE       ,
                    f_im_inst_1_tot_par_cont                IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tot_par_cont%TYPE       ,
                    f_im_inst_1_tot_family_cont             IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tot_family_cont%TYPE    ,
                    f_im_inst_1_va_benefits                 IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_va_benefits%TYPE        ,
                    f_im_inst_1_ot_cont                     IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_ot_cont%TYPE            ,
                    f_im_inst_1_est_financial_need          IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_est_financial_need%TYPE ,
                    f_institutional_2_budget_name           IN OUT NOCOPY igf_ap_css_fnar.institutional_2_budget_name%TYPE  ,
                    f_im_inst_2_budget_duration             IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_budget_duration%TYPE    ,
                    f_im_inst_2_tuition_fees                IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tuition_fees%TYPE       ,
                    f_im_inst_2_books_supplies              IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_books_supplies%TYPE     ,
                    f_im_inst_2_living_expenses             IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_living_expenses%TYPE    ,
                    f_im_inst_2_tot_expenses                IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tot_expenses%TYPE       ,
                    f_im_inst_2_tot_stu_cont                IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tot_stu_cont%TYPE       ,
                    f_im_inst_2_tot_par_cont                IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tot_par_cont%TYPE       ,
                    f_im_inst_2_tot_family_cont             IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tot_family_cont%TYPE    ,
                    f_im_inst_2_va_benefits                 IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_va_benefits%TYPE        ,
                    f_im_inst_2_est_financial_need          IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_est_financial_need%TYPE ,
                    f_institutional_3_budget_name           IN OUT NOCOPY igf_ap_css_fnar.institutional_3_budget_name%TYPE  ,
                    f_im_inst_3_budget_duration             IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_budget_duration%TYPE    ,
                    f_im_inst_3_tuition_fees                IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tuition_fees%TYPE       ,
                    f_im_inst_3_books_supplies              IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_books_supplies%TYPE     ,
                    f_im_inst_3_living_expenses             IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_living_expenses%TYPE    ,
                    f_im_inst_3_tot_expenses                IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tot_expenses%TYPE       ,
                    f_im_inst_3_tot_stu_cont                IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tot_stu_cont%TYPE       ,
                    f_im_inst_3_tot_par_cont                IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tot_par_cont%TYPE       ,
                    f_im_inst_3_tot_family_cont             IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tot_family_cont%TYPE    ,
                    f_im_inst_3_va_benefits                 IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_va_benefits%TYPE        ,
                    f_im_inst_3_est_financial_need          IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_est_financial_need%TYPE ,
                    f_fm_inst_1_federal_efc                 IN OUT NOCOPY igf_ap_css_fnar.fm_inst_1_federal_efc%TYPE        ,
                    f_fm_inst_1_va_benefits                 IN OUT NOCOPY igf_ap_css_fnar.fm_inst_1_va_benefits%TYPE        ,
                    f_fm_inst_1_fed_eligibility             IN OUT NOCOPY igf_ap_css_fnar.fm_inst_1_fed_eligibility%TYPE    ,
                    f_fm_inst_1_pell                        IN OUT NOCOPY igf_ap_css_fnar.fm_inst_1_pell%TYPE               ,
                    f_option_par_loss_allow_ind             IN OUT NOCOPY igf_ap_css_fnar.option_par_loss_allow_ind%TYPE    ,
                    f_option_par_tuition_ind                IN OUT NOCOPY igf_ap_css_fnar.option_par_tuition_ind%TYPE       ,
                    f_option_par_home_ind                   IN OUT NOCOPY igf_ap_css_fnar.option_par_home_ind%TYPE          ,
                    f_option_par_home_value                 IN OUT NOCOPY igf_ap_css_fnar.option_par_home_value%TYPE        ,
                    f_option_par_home_debt                  IN OUT NOCOPY igf_ap_css_fnar.option_par_home_debt%TYPE         ,
                    f_option_stu_ira_keogh_ind              IN OUT NOCOPY igf_ap_css_fnar.option_stu_ira_keogh_ind%TYPE     ,
                    f_option_stu_home_ind                   IN OUT NOCOPY igf_ap_css_fnar.option_stu_home_ind%TYPE          ,
                    f_option_stu_home_value                 IN OUT NOCOPY igf_ap_css_fnar.option_stu_home_value%TYPE        ,
                    f_option_stu_home_debt                  IN OUT NOCOPY igf_ap_css_fnar.option_stu_home_debt%TYPE         ,
                    f_option_stu_sum_ay_inc_ind             IN OUT NOCOPY igf_ap_css_fnar.option_stu_sum_ay_inc_ind%TYPE    ,
                    f_option_par_hope_ll_credit             IN OUT NOCOPY igf_ap_css_fnar.option_par_hope_ll_credit%TYPE    ,
                    f_option_stu_hope_ll_credit             IN OUT NOCOPY igf_ap_css_fnar.option_stu_hope_ll_credit%TYPE    ,
                    f_option_par_cola_adj_ind               IN OUT NOCOPY igf_ap_css_fnar.option_par_cola_adj_ind%TYPE      ,
                    f_option_par_stu_fa_assets_ind          IN OUT NOCOPY igf_ap_css_fnar.option_par_stu_fa_assets_ind%TYPE ,
                    f_option_par_ipt_assets_ind             IN OUT NOCOPY igf_ap_css_fnar.option_par_ipt_assets_ind%TYPE    ,
                    f_option_stu_ipt_assets_ind             IN OUT NOCOPY igf_ap_css_fnar.option_stu_ipt_assets_ind%TYPE    ,
                    f_option_par_cola_adj_value             IN OUT NOCOPY igf_ap_css_fnar.option_par_cola_adj_value%TYPE    ,
                    f_im_parent_1_8_months_bas              IN OUT NOCOPY igf_ap_css_fnar.im_parent_1_8_months_bas%TYPE     ,
                    f_im_p_more_than_9_mth_ba               IN OUT NOCOPY igf_ap_css_fnar.im_p_more_than_9_mth_ba%TYPE      ,
                    f_im_parent_1_8_months_opt              IN OUT NOCOPY igf_ap_css_fnar.im_parent_1_8_months_opt%TYPE     ,
                    f_im_p_more_than_9_mth_op               IN OUT NOCOPY igf_ap_css_fnar.im_p_more_than_9_mth_op%TYPE      ,
                    f_fnar_message_1                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_1%TYPE               ,
                    f_fnar_message_2                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_2%TYPE               ,
                    f_fnar_message_3                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_3%TYPE               ,
                    f_fnar_message_4                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_4%TYPE              ,
                    f_fnar_message_5                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_5%TYPE               ,
                    f_fnar_message_6                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_6%TYPE               ,
                    f_fnar_message_7                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_7%TYPE               ,
                    f_fnar_message_8                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_8%TYPE               ,
                    f_fnar_message_9                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_9%TYPE               ,
                    f_fnar_message_10                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_10%TYPE              ,
                    f_fnar_message_11                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_11%TYPE              ,
                    f_fnar_message_12                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_12%TYPE              ,
                    f_fnar_message_13                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_13%TYPE              ,
                    f_fnar_message_20                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_20%TYPE              ,
                    f_fnar_message_21                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_21%TYPE              ,
                    f_fnar_message_22                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_22%TYPE              ,
                    f_fnar_message_23                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_23%TYPE              ,
                    f_fnar_message_24                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_24%TYPE              ,
                    f_fnar_message_25                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_25%TYPE              ,
                    f_fnar_message_26                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_26%TYPE              ,
                    f_fnar_message_27                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_27%TYPE              ,
                    f_fnar_message_30                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_30%TYPE              ,
                    f_fnar_message_31                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_31%TYPE              ,
                    f_fnar_message_32                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_32%TYPE              ,
                    f_fnar_message_33                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_33%TYPE              ,
                    f_fnar_message_34                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_34%TYPE              ,
                    f_fnar_message_35                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_35%TYPE              ,
                    f_fnar_message_36                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_36%TYPE              ,
                    f_fnar_message_37                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_37%TYPE              ,
                    f_fnar_message_38                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_38%TYPE              ,
                    f_fnar_message_39                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_39%TYPE              ,
                    f_fnar_message_45                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_45%TYPE              ,
                    f_fnar_message_46                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_46%TYPE              ,
                    f_fnar_message_47                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_47%TYPE              ,
                    f_fnar_message_48                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_48%TYPE              ,
                    f_fnar_message_49                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_49%TYPE              ,
                    f_fnar_message_50                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_50%TYPE              ,
                    f_fnar_message_51                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_51%TYPE              ,
                    f_fnar_message_52                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_52%TYPE              ,
                    f_fnar_message_53                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_53%TYPE              ,
                    f_fnar_message_55                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_55%TYPE              ,
                    f_fnar_message_56                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_56%TYPE              ,
                    f_fnar_message_57                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_57%TYPE              ,
                    f_fnar_message_58                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_58%TYPE              ,
                    f_fnar_message_59                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_59%TYPE              ,
                    f_fnar_message_60                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_60%TYPE              ,
                    f_fnar_message_61                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_61%TYPE              ,
                    f_fnar_message_62                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_62%TYPE              ,
                    f_fnar_message_63                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_63%TYPE              ,
                    f_fnar_message_64                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_64%TYPE              ,
                    f_fnar_message_65                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_65%TYPE              ,
                    f_fnar_message_71                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_71%TYPE              ,
                    f_fnar_message_72                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_72%TYPE              ,
                    f_fnar_message_73                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_73%TYPE              ,
                    f_fnar_message_74                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_74%TYPE              ,
                    f_fnar_message_75                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_75%TYPE              ,
                    f_fnar_message_76                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_76%TYPE              ,
                    f_fnar_message_77                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_77%TYPE              ,
                    f_fnar_message_78                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_78%TYPE              ,
                    f_fnar_mesg_10_stu_fam_mem              IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_10_stu_fam_mem%TYPE     ,
                    f_fnar_mesg_11_stu_no_in_coll           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_11_stu_no_in_coll%TYPE  ,
                    f_fnar_mesg_24_stu_avail_inc            IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_24_stu_avail_inc%TYPE   ,
                    f_fnar_mesg_26_stu_taxes                IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_26_stu_taxes%TYPE       ,
                    f_fnar_mesg_33_stu_home_value           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_33_stu_home_value%TYPE  ,
                    f_fnar_mesg_34_stu_home_value           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_34_stu_home_value%TYPE  ,
                    f_fnar_mesg_34_stu_home_equity          IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_34_stu_home_equity%TYPE ,
                    f_fnar_mesg_35_stu_home_value           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_35_stu_home_value%TYPE  ,
                    f_fnar_mesg_35_stu_home_equity          IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_35_stu_home_equity%TYPE ,
                    f_fnar_mesg_36_stu_home_equity          IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_36_stu_home_equity%TYPE ,
                    f_fnar_mesg_48_par_fam_mem              IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_48_par_fam_mem%TYPE     ,
                    f_fnar_mesg_49_par_no_in_coll           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_49_par_no_in_coll%TYPE  ,
                    f_fnar_mesg_56_par_agi                  IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_56_par_agi%TYPE         ,
                    f_fnar_mesg_62_par_taxes                IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_62_par_taxes%TYPE       ,
                    f_fnar_mesg_73_par_home_value           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_73_par_home_value%TYPE  ,
                    f_fnar_mesg_74_par_home_value           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_74_par_home_value%TYPE  ,
                    f_fnar_mesg_74_par_home_equity          IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_74_par_home_equity%TYPE ,
                    f_fnar_mesg_75_par_home_value           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_75_par_home_value%TYPE  ,
                    f_fnar_mesg_75_par_home_equity          IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_75_par_home_equity%TYPE ,
                    f_fnar_mesg_76_par_home_equity          IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_76_par_home_equity%TYPE ,
                    f_assumption_message_1                  IN OUT NOCOPY igf_ap_css_fnar.assumption_message_1%TYPE         ,
                    f_assumption_message_2                  IN OUT NOCOPY igf_ap_css_fnar.assumption_message_2%TYPE         ,
                    f_assumption_message_3                  IN OUT NOCOPY igf_ap_css_fnar.assumption_message_3%TYPE         ,
                    f_assumption_message_4                  IN OUT NOCOPY igf_ap_css_fnar.assumption_message_4%TYPE         ,
                    f_assumption_message_5                  IN OUT NOCOPY igf_ap_css_fnar.assumption_message_5%TYPE         ,
                    f_assumption_message_6                  IN OUT NOCOPY igf_ap_css_fnar.assumption_message_6%TYPE         ,
                    f_record_mark                           IN OUT NOCOPY igf_ap_css_fnar.record_mark%TYPE                  ,
                    f_legacy_record_flag                    IN OUT NOCOPY igf_ap_css_fnar.legacy_record_flag%TYPE           ,
                    f_creation_date                         IN OUT NOCOPY igf_ap_css_fnar.creation_date%TYPE                ,
                    f_created_by                            IN OUT NOCOPY igf_ap_css_fnar.created_by%TYPE                   ,
                    f_last_updated_by                       IN OUT NOCOPY igf_ap_css_fnar.last_updated_by%TYPE              ,
                    f_last_update_date                      IN OUT NOCOPY igf_ap_css_fnar.last_update_date%TYPE             ,
                    f_last_update_login                     IN OUT NOCOPY igf_ap_css_fnar.last_update_login%TYPE            ,
                    f_opt_ind_stu_ipt_assets_flag           IN OUT NOCOPY igf_ap_css_fnar.option_ind_stu_ipt_assets_flag%TYPE ,
                    f_cust_parent_cont_adj_num              IN OUT NOCOPY igf_ap_css_fnar.cust_parent_cont_adj_num%TYPE     ,
                    f_custodial_parent_num                  IN OUT NOCOPY igf_ap_css_fnar.custodial_parent_num%TYPE         ,
                    f_cust_par_base_prcnt_inc_amt           IN OUT NOCOPY igf_ap_css_fnar.cust_par_base_prcnt_inc_amt%TYPE  ,
                    f_cust_par_base_cont_inc_amt            IN OUT NOCOPY igf_ap_css_fnar.cust_par_base_cont_inc_amt%TYPE   ,
                    f_cust_par_base_cont_ast_amt            IN OUT NOCOPY igf_ap_css_fnar.cust_par_base_cont_ast_amt%TYPE   ,
                    f_cust_par_base_tot_cont_amt            IN OUT NOCOPY igf_ap_css_fnar.cust_par_base_tot_cont_amt%TYPE   ,
                    f_cust_par_opt_prcnt_inc_amt            IN OUT NOCOPY igf_ap_css_fnar.cust_par_opt_prcnt_inc_amt%TYPE   ,
                    f_cust_par_opt_cont_inc_amt             IN OUT NOCOPY igf_ap_css_fnar.cust_par_opt_cont_inc_amt%TYPE    ,
                    f_cust_par_opt_cont_ast_amt             IN OUT NOCOPY igf_ap_css_fnar.cust_par_opt_cont_ast_amt%TYPE    ,
                    f_cust_par_opt_tot_cont_amt             IN OUT NOCOPY igf_ap_css_fnar.cust_par_opt_tot_cont_amt%TYPE    ,
                    f_parents_email_txt                     IN OUT NOCOPY igf_ap_css_fnar.parents_email_txt%TYPE            ,
                    f_parent_1_birth_date                   IN OUT NOCOPY igf_ap_css_fnar.parent_1_birth_date%TYPE          ,
                    f_parent_2_birth_date                   IN OUT NOCOPY igf_ap_css_fnar.parent_2_birth_date%TYPE          ,

                    p_err_mesg OUT NOCOPY fnd_new_messages.message_name%TYPE)
  RETURN VARCHAR AS

  p_profile_rec igf_ap_css_profile%ROWTYPE;
Line: 1142

    p_profile_rec.last_updated_by                 :=  pr_last_updated_by                ;
Line: 1143

    p_profile_rec.last_update_date                :=  pr_last_update_date               ;
Line: 1144

    p_profile_rec.last_update_login               :=  pr_last_update_login              ;
Line: 1526

    p_fnar_rec.last_updated_by                    :=  f_last_updated_by                ;
Line: 1527

    p_fnar_rec.last_update_date                   :=  f_last_update_date               ;
Line: 1528

    p_fnar_rec.last_update_login                  :=  f_last_update_login              ;
Line: 1874

    pr_last_updated_by                :=  p_profile_rec.last_updated_by                 ;
Line: 1875

    pr_last_update_date               :=  p_profile_rec.last_update_date                ;
Line: 1876

    pr_last_update_login              :=  p_profile_rec.last_update_login               ;
Line: 2258

    f_last_updated_by                :=  p_fnar_rec.last_updated_by                 ;
Line: 2259

    f_last_update_date               :=  p_fnar_rec.last_update_date                ;
Line: 2260

    f_last_update_login              :=  p_fnar_rec.last_update_login               ;