DBA Data[Home] [Help]

PACKAGE BODY: APPS.IGF_AP_UHK_INAS_PKG

Source


1 PACKAGE BODY igf_ap_uhk_inas_pkg AS
2 /* $Header: IGFAP46B.pls 120.0 2005/06/01 14:54:09 appldev noship $ */
3 ------------------------------------------------------------------
4 --Created by  : veramach, Oracle India
5 --Date created: 30-SEP-2003
6 --
7 --Purpose:
8 --   The userhook function to calculate student's Institutional Methodology Expected Family Contribution
9 --
10 --Known limitations/enhancements and/or remarks:
11 --  1. This package can be run only if INAS is integrated. The code is customized at customer location
12 --  2. This will overwrite the userhook is already a version is installed in the customer site.
13 --Change History:
14 --Who         When            What
15 -------------------------------------------------------------------
16 
17   FUNCTION get_im_efc(
18                         p_sys_awd_year IN            igf_ap_batch_aw_map.sys_award_year%TYPE,
19                         p_profile_rec  IN OUT NOCOPY igf_ap_css_profile%ROWTYPE,
20                         p_fnar_rec     IN OUT NOCOPY igf_ap_css_fnar%ROWTYPE,
21                         p_error_msg    OUT    NOCOPY fnd_new_messages.message_name%TYPE
22                       ) RETURN BOOLEAN AS
23   ------------------------------------------------------------------
24   --Created by  : veramach, Oracle India
25   --Date created: 30-SEP-2003
26   --
27   --Purpose:
28   --   This is the user hook function to calculate EFC according to Institutional Methodology
29   --   Parameters:
30   --    p_sys_awd_year         - System Award Year (like 0203, 0304,etc.)
31   --    p_profile_rec          - Profile record type
32   --    p_fnar_rec             - FNAR record type
33   --    p_error_msg            - Error message,if any,returned from the external application
34   --
35   --Known limitations/enhancements and/or remarks:
36   --
37   --Change History:
38   --Who         When            What
39   -------------------------------------------------------------------
40 
41   BEGIN
42     RETURN TRUE;
43   END get_im_efc;
44 
45    FUNCTION efc_i_award_prd(
46                             p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
47                             p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
48                            ) RETURN NUMBER AS
49    ------------------------------------------------------------------
50    --Created by  : veramach, Oracle India
51    --Date created: 02-Nov-2004
52    --
53    --Purpose:
54    --   Calculate IM EFC.
55    --   Parameters:
56    --   p_base_id      - Student for whom EFC needs to be calculated
57    --   p_awd_prd_code - Award Period in which EFC has to be calculated
58    --Known limitations/enhancements and/or remarks:
59    --
60    --Change History:
61    --Who         When            What
62    -------------------------------------------------------------------
63    BEGIN
64      RETURN 0;
65    END efc_i_award_prd;
66 
67   FUNCTION  callHook(
68                     p_sys_awd_year   IN igf_ap_batch_aw_map.sys_award_year%TYPE,
69 
70                     pr_cssp_id                    IN OUT NOCOPY igf_ap_css_profile.cssp_id%TYPE                      ,
71                     pr_org_id                     IN OUT NOCOPY igf_ap_css_profile.org_id%TYPE                       ,
72                     pr_base_id                    IN OUT NOCOPY igf_ap_css_profile.base_id%TYPE                      ,
73                     pr_system_record_type         IN OUT NOCOPY igf_ap_css_profile.system_record_type%TYPE           ,
74                     pr_active_profile             IN OUT NOCOPY igf_ap_css_profile.active_profile%TYPE               ,
75                     pr_college_code               IN OUT NOCOPY igf_ap_css_profile.college_code%TYPE                 ,
76                     pr_academic_year              IN OUT NOCOPY igf_ap_css_profile.academic_year%TYPE                ,
77                     pr_stu_record_type            IN OUT NOCOPY igf_ap_css_profile.stu_record_type%TYPE              ,
78                     pr_css_id_number              IN OUT NOCOPY igf_ap_css_profile.css_id_number%TYPE                ,
79                     pr_registration_receipt_date  IN OUT NOCOPY igf_ap_css_profile.registration_receipt_date%TYPE    ,
80                     pr_registration_type          IN OUT NOCOPY igf_ap_css_profile.registration_type%TYPE            ,
81                     pr_application_receipt_date   IN OUT NOCOPY igf_ap_css_profile.application_receipt_date%TYPE     ,
82                     pr_application_type           IN OUT NOCOPY igf_ap_css_profile.application_type%TYPE             ,
83                     pr_original_fnar_compute      IN OUT NOCOPY igf_ap_css_profile.original_fnar_compute%TYPE        ,
84                     pr_revision_fnar_compute_date IN OUT NOCOPY igf_ap_css_profile.revision_fnar_compute_date%TYPE   ,
85                     pr_electronic_extract_date    IN OUT NOCOPY igf_ap_css_profile.electronic_extract_date%TYPE      ,
86                     pr_inst_reporting_type        IN OUT NOCOPY igf_ap_css_profile.institutional_reporting_type%TYPE ,
87                     pr_asr_receipt_date           IN OUT NOCOPY igf_ap_css_profile.asr_receipt_date%TYPE             ,
88                     pr_last_name                  IN OUT NOCOPY igf_ap_css_profile.last_name%TYPE                    ,
89                     pr_first_name                 IN OUT NOCOPY igf_ap_css_profile.first_name%TYPE                   ,
90                     pr_middle_initial             IN OUT NOCOPY igf_ap_css_profile.middle_initial%TYPE               ,
91                     pr_address_number_and_street  IN OUT NOCOPY igf_ap_css_profile.address_number_and_street%TYPE    ,
92                     pr_city                       IN OUT NOCOPY igf_ap_css_profile.city%TYPE                        ,
93                     pr_state_mailing              IN OUT NOCOPY igf_ap_css_profile.state_mailing%TYPE                ,
94                     pr_zip_code                   IN OUT NOCOPY igf_ap_css_profile.zip_code%TYPE                     ,
95                     pr_s_telephone_number         IN OUT NOCOPY igf_ap_css_profile.s_telephone_number%TYPE           ,
96                     pr_s_title                    IN OUT NOCOPY igf_ap_css_profile.s_title%TYPE                      ,
97                     pr_date_of_birth              IN OUT NOCOPY igf_ap_css_profile.date_of_birth%TYPE                ,
98                     pr_social_security_number     IN OUT NOCOPY igf_ap_css_profile.social_security_number%TYPE       ,
99                     pr_state_legal_residence      IN OUT NOCOPY igf_ap_css_profile.state_legal_residence%TYPE        ,
100                     pr_foreign_address_indicator  IN OUT NOCOPY igf_ap_css_profile.foreign_address_indicator%TYPE    ,
101                     pr_foreign_postal_code        IN OUT NOCOPY igf_ap_css_profile.foreign_postal_code%TYPE          ,
102                     pr_country                    IN OUT NOCOPY igf_ap_css_profile.country%TYPE                      ,
103                     pr_financial_aid_status       IN OUT NOCOPY igf_ap_css_profile.financial_aid_status%TYPE         ,
104                     pr_year_in_college            IN OUT NOCOPY igf_ap_css_profile.year_in_college%TYPE              ,
105                     pr_marital_status             IN OUT NOCOPY igf_ap_css_profile.marital_status%TYPE               ,
106                     pr_ward_court                 IN OUT NOCOPY igf_ap_css_profile.ward_court%TYPE                   ,
107                     pr_legal_dependents_other     IN OUT NOCOPY igf_ap_css_profile.legal_dependents_other%TYPE       ,
108                     pr_household_size             IN OUT NOCOPY igf_ap_css_profile.household_size%TYPE               ,
109                     pr_number_in_college          IN OUT NOCOPY igf_ap_css_profile.number_in_college%TYPE            ,
110                     pr_citizenship_status         IN OUT NOCOPY igf_ap_css_profile.citizenship_status%TYPE           ,
111                     pr_citizenship_country        IN OUT NOCOPY igf_ap_css_profile.citizenship_country%TYPE          ,
112                     pr_visa_classification        IN OUT NOCOPY igf_ap_css_profile.visa_classification%TYPE          ,
113                     pr_tax_figures                IN OUT NOCOPY igf_ap_css_profile.tax_figures%TYPE                  ,
114                     pr_number_exemptions          IN OUT NOCOPY igf_ap_css_profile.number_exemptions%TYPE            ,
115                     pr_adjusted_gross_inc         IN OUT NOCOPY igf_ap_css_profile.adjusted_gross_inc%TYPE           ,
116                     pr_us_tax_paid                IN OUT NOCOPY igf_ap_css_profile.us_tax_paid%TYPE                  ,
117                     pr_itemized_deductions        IN OUT NOCOPY igf_ap_css_profile.itemized_deductions%TYPE          ,
118                     pr_stu_income_work            IN OUT NOCOPY igf_ap_css_profile.stu_income_work%TYPE              ,
119                     pr_spouse_income_work         IN OUT NOCOPY igf_ap_css_profile.spouse_income_work%TYPE           ,
120                     pr_divid_int_inc              IN OUT NOCOPY igf_ap_css_profile.divid_int_inc%TYPE                ,
121                     pr_soc_sec_benefits           IN OUT NOCOPY igf_ap_css_profile.soc_sec_benefits%TYPE             ,
122                     pr_welfare_tanf               IN OUT NOCOPY igf_ap_css_profile.welfare_tanf%TYPE                 ,
123                     pr_child_supp_rcvd            IN OUT NOCOPY igf_ap_css_profile.child_supp_rcvd%TYPE              ,
124                     pr_earned_income_credit       IN OUT NOCOPY igf_ap_css_profile.earned_income_credit%TYPE         ,
125                     pr_other_untax_income         IN OUT NOCOPY igf_ap_css_profile.other_untax_income%TYPE           ,
126                     pr_tax_stu_aid                IN OUT NOCOPY igf_ap_css_profile.tax_stu_aid%TYPE                  ,
127                     pr_cash_sav_check             IN OUT NOCOPY igf_ap_css_profile.cash_sav_check%TYPE               ,
128                     pr_ira_keogh                  IN OUT NOCOPY igf_ap_css_profile.ira_keogh%TYPE                    ,
129                     pr_invest_value               IN OUT NOCOPY igf_ap_css_profile.invest_value%TYPE                 ,
130                     pr_invest_debt                IN OUT NOCOPY igf_ap_css_profile.invest_debt%TYPE                  ,
131                     pr_home_value                 IN OUT NOCOPY igf_ap_css_profile.home_value%TYPE                   ,
132                     pr_home_debt                  IN OUT NOCOPY igf_ap_css_profile.home_debt%TYPE                    ,
133                     pr_oth_real_value             IN OUT NOCOPY igf_ap_css_profile.oth_real_value%TYPE               ,
134                     pr_oth_real_debt              IN OUT NOCOPY igf_ap_css_profile.oth_real_debt%TYPE                ,
135                     pr_bus_farm_value             IN OUT NOCOPY igf_ap_css_profile.bus_farm_value%TYPE               ,
136                     pr_bus_farm_debt              IN OUT NOCOPY igf_ap_css_profile.bus_farm_debt%TYPE                ,
137                     pr_live_on_farm               IN OUT NOCOPY igf_ap_css_profile.live_on_farm%TYPE                 ,
138                     pr_home_purch_price           IN OUT NOCOPY igf_ap_css_profile.home_purch_price%TYPE             ,
139                     pr_hope_ll_credit             IN OUT NOCOPY igf_ap_css_profile.hope_ll_credit%TYPE               ,
140                     pr_home_purch_year            IN OUT NOCOPY igf_ap_css_profile.home_purch_year%TYPE              ,
141                     pr_trust_amount               IN OUT NOCOPY igf_ap_css_profile.trust_amount%TYPE                 ,
142                     pr_trust_avail                IN OUT NOCOPY igf_ap_css_profile.trust_avail%TYPE                  ,
143                     pr_trust_estab                IN OUT NOCOPY igf_ap_css_profile.trust_estab%TYPE                  ,
144                     pr_child_support_paid         IN OUT NOCOPY igf_ap_css_profile.child_support_paid%TYPE           ,
145                     pr_med_dent_expenses          IN OUT NOCOPY igf_ap_css_profile.med_dent_expenses%TYPE            ,
146                     pr_vet_us                     IN OUT NOCOPY igf_ap_css_profile.vet_us%TYPE                       ,
147                     pr_vet_ben_amount             IN OUT NOCOPY igf_ap_css_profile.vet_ben_amount%TYPE               ,
148                     pr_vet_ben_months             IN OUT NOCOPY igf_ap_css_profile.vet_ben_months%TYPE               ,
149                     pr_stu_summer_wages           IN OUT NOCOPY igf_ap_css_profile.stu_summer_wages%TYPE             ,
150                     pr_stu_school_yr_wages        IN OUT NOCOPY igf_ap_css_profile.stu_school_yr_wages%TYPE          ,
151                     pr_spouse_summer_wages        IN OUT NOCOPY igf_ap_css_profile.spouse_summer_wages%TYPE          ,
152                     pr_spouse_school_yr_wages     IN OUT NOCOPY igf_ap_css_profile.spouse_school_yr_wages%TYPE       ,
153                     pr_summer_other_tax_inc       IN OUT NOCOPY igf_ap_css_profile.summer_other_tax_inc%TYPE         ,
154                     pr_school_yr_other_tax_inc    IN OUT NOCOPY igf_ap_css_profile.school_yr_other_tax_inc%TYPE      ,
155                     pr_summer_untax_inc           IN OUT NOCOPY igf_ap_css_profile.summer_untax_inc%TYPE             ,
156                     pr_school_yr_untax_inc        IN OUT NOCOPY igf_ap_css_profile.school_yr_untax_inc%TYPE          ,
157                     pr_grants_schol_etc           IN OUT NOCOPY igf_ap_css_profile.grants_schol_etc%TYPE             ,
158                     pr_tuit_benefits              IN OUT NOCOPY igf_ap_css_profile.tuit_benefits%TYPE                ,
159                     pr_cont_parents               IN OUT NOCOPY igf_ap_css_profile.cont_parents%TYPE                 ,
160                     pr_cont_relatives             IN OUT NOCOPY igf_ap_css_profile.cont_relatives%TYPE               ,
164                     pr_p_number_in_college        IN OUT NOCOPY igf_ap_css_profile.p_number_in_college%TYPE          ,
161                     pr_p_siblings_pre_tuit        IN OUT NOCOPY igf_ap_css_profile.p_siblings_pre_tuit%TYPE          ,
162                     pr_p_student_pre_tuit         IN OUT NOCOPY igf_ap_css_profile.p_student_pre_tuit%TYPE           ,
163                     pr_p_household_size           IN OUT NOCOPY igf_ap_css_profile.p_household_size%TYPE             ,
165                     pr_p_parents_in_college       IN OUT NOCOPY igf_ap_css_profile.p_parents_in_college%TYPE         ,
166                     pr_p_marital_status           IN OUT NOCOPY igf_ap_css_profile.p_marital_status%TYPE             ,
167                     pr_p_state_legal_residence    IN OUT NOCOPY igf_ap_css_profile.p_state_legal_residence%TYPE      ,
168                     pr_p_natural_par_status       IN OUT NOCOPY igf_ap_css_profile.p_natural_par_status%TYPE         ,
169                     pr_p_child_supp_paid          IN OUT NOCOPY igf_ap_css_profile.p_child_supp_paid%TYPE            ,
170                     pr_p_repay_ed_loans           IN OUT NOCOPY igf_ap_css_profile.p_repay_ed_loans%TYPE             ,
171                     pr_p_med_dent_expenses        IN OUT NOCOPY igf_ap_css_profile.p_med_dent_expenses%TYPE          ,
172                     pr_p_tuit_paid_amount         IN OUT NOCOPY igf_ap_css_profile.p_tuit_paid_amount%TYPE           ,
173                     pr_p_tuit_paid_number         IN OUT NOCOPY igf_ap_css_profile.p_tuit_paid_number%TYPE           ,
174                     pr_p_exp_child_supp_paid      IN OUT NOCOPY igf_ap_css_profile.p_exp_child_supp_paid%TYPE        ,
175                     pr_p_exp_repay_ed_loans       IN OUT NOCOPY igf_ap_css_profile.p_exp_repay_ed_loans%TYPE         ,
176                     pr_p_exp_med_dent_expenses    IN OUT NOCOPY igf_ap_css_profile.p_exp_med_dent_expenses%TYPE      ,
177                     pr_p_exp_tuit_pd_amount       IN OUT NOCOPY igf_ap_css_profile.p_exp_tuit_pd_amount%TYPE         ,
178                     pr_p_exp_tuit_pd_number       IN OUT NOCOPY igf_ap_css_profile.p_exp_tuit_pd_number%TYPE         ,
179                     pr_p_cash_sav_check           IN OUT NOCOPY igf_ap_css_profile.p_cash_sav_check%TYPE             ,
180                     pr_p_month_mortgage_pay       IN OUT NOCOPY igf_ap_css_profile.p_month_mortgage_pay%TYPE         ,
181                     pr_p_invest_value             IN OUT NOCOPY igf_ap_css_profile.p_invest_value%TYPE               ,
182                     pr_p_invest_debt              IN OUT NOCOPY igf_ap_css_profile.p_invest_debt%TYPE                ,
183                     pr_p_home_value               IN OUT NOCOPY igf_ap_css_profile.p_home_value%TYPE                 ,
184                     pr_p_home_debt                IN OUT NOCOPY igf_ap_css_profile.p_home_debt%TYPE                  ,
185                     pr_p_home_purch_price         IN OUT NOCOPY igf_ap_css_profile.p_home_purch_price%TYPE           ,
186                     pr_p_own_business_farm        IN OUT NOCOPY igf_ap_css_profile.p_own_business_farm%TYPE          ,
187                     pr_p_business_value           IN OUT NOCOPY igf_ap_css_profile.p_business_value%TYPE             ,
188                     pr_p_business_debt            IN OUT NOCOPY igf_ap_css_profile.p_business_debt%TYPE              ,
189                     pr_p_farm_value               IN OUT NOCOPY igf_ap_css_profile.p_farm_value%TYPE                 ,
190                     pr_p_farm_debt                IN OUT NOCOPY igf_ap_css_profile.p_farm_debt%TYPE                  ,
191                     pr_p_live_on_farm             IN OUT NOCOPY igf_ap_css_profile.p_live_on_farm%TYPE               ,
192                     pr_p_oth_real_estate_value    IN OUT NOCOPY igf_ap_css_profile.p_oth_real_estate_value%TYPE      ,
193                     pr_p_oth_real_estate_debt     IN OUT NOCOPY igf_ap_css_profile.p_oth_real_estate_debt%TYPE       ,
194                     pr_p_oth_real_purch_price     IN OUT NOCOPY igf_ap_css_profile.p_oth_real_purch_price%TYPE       ,
195                     pr_p_siblings_assets          IN OUT NOCOPY igf_ap_css_profile.p_siblings_assets%TYPE           ,
196                     pr_p_home_purch_year          IN OUT NOCOPY igf_ap_css_profile.p_home_purch_year%TYPE            ,
197                     pr_p_oth_real_purch_year      IN OUT NOCOPY igf_ap_css_profile.p_oth_real_purch_year%TYPE        ,
198                     pr_p_prior_agi                IN OUT NOCOPY igf_ap_css_profile.p_prior_agi%TYPE                  ,
199                     pr_p_prior_us_tax_paid        IN OUT NOCOPY igf_ap_css_profile.p_prior_us_tax_paid%TYPE          ,
200                     pr_p_prior_item_deductions    IN OUT NOCOPY igf_ap_css_profile.p_prior_item_deductions%TYPE      ,
201                     pr_p_prior_other_untax_inc    IN OUT NOCOPY igf_ap_css_profile.p_prior_other_untax_inc%TYPE      ,
202                     pr_p_tax_figures              IN OUT NOCOPY igf_ap_css_profile.p_tax_figures%TYPE                ,
203                     pr_p_number_exemptions        IN OUT NOCOPY igf_ap_css_profile.p_number_exemptions%TYPE          ,
204                     pr_p_adjusted_gross_inc       IN OUT NOCOPY igf_ap_css_profile.p_adjusted_gross_inc%TYPE         ,
205                     pr_p_wages_sal_tips           IN OUT NOCOPY igf_ap_css_profile.p_wages_sal_tips%TYPE             ,
206                     pr_p_interest_income          IN OUT NOCOPY igf_ap_css_profile.p_interest_income%TYPE            ,
207                     pr_p_dividend_income          IN OUT NOCOPY igf_ap_css_profile.p_dividend_income%TYPE            ,
208                     pr_p_net_inc_bus_farm         IN OUT NOCOPY igf_ap_css_profile.p_net_inc_bus_farm%TYPE           ,
209                     pr_p_other_taxable_income     IN OUT NOCOPY igf_ap_css_profile.p_other_taxable_income%TYPE       ,
210                     pr_p_adj_to_income            IN OUT NOCOPY igf_ap_css_profile.p_adj_to_income%TYPE              ,
211                     pr_p_us_tax_paid              IN OUT NOCOPY igf_ap_css_profile.p_us_tax_paid%TYPE                ,
212                     pr_p_itemized_deductions      IN OUT NOCOPY igf_ap_css_profile.p_itemized_deductions%TYPE        ,
213                     pr_p_father_income_work       IN OUT NOCOPY igf_ap_css_profile.p_father_income_work%TYPE         ,
214                     pr_p_mother_income_work       IN OUT NOCOPY igf_ap_css_profile.p_mother_income_work%TYPE         ,
218                     pr_p_ded_ira_keogh            IN OUT NOCOPY igf_ap_css_profile.p_ded_ira_keogh%TYPE              ,
215                     pr_p_soc_sec_ben              IN OUT NOCOPY igf_ap_css_profile.p_soc_sec_ben%TYPE                ,
216                     pr_p_welfare_tanf             IN OUT NOCOPY igf_ap_css_profile.p_welfare_tanf%TYPE               ,
217                     pr_p_child_supp_rcvd          IN OUT NOCOPY igf_ap_css_profile.p_child_supp_rcvd%TYPE            ,
219                     pr_p_tax_defer_pens_savs      IN OUT NOCOPY igf_ap_css_profile.p_tax_defer_pens_savs%TYPE        ,
220                     pr_p_dep_care_med_spending    IN OUT NOCOPY igf_ap_css_profile.p_dep_care_med_spending%TYPE      ,
221                     pr_p_earned_income_credit     IN OUT NOCOPY igf_ap_css_profile.p_earned_income_credit%TYPE       ,
222                     pr_p_living_allow             IN OUT NOCOPY igf_ap_css_profile.p_living_allow%TYPE               ,
223                     pr_p_tax_exmpt_int            IN OUT NOCOPY igf_ap_css_profile.p_tax_exmpt_int%TYPE              ,
224                     pr_p_foreign_inc_excl         IN OUT NOCOPY igf_ap_css_profile.p_foreign_inc_excl%TYPE           ,
225                     pr_p_other_untax_inc          IN OUT NOCOPY igf_ap_css_profile.p_other_untax_inc%TYPE            ,
226                     pr_p_hope_ll_credit           IN OUT NOCOPY igf_ap_css_profile.p_hope_ll_credit%TYPE             ,
227                     pr_p_yr_separation            IN OUT NOCOPY igf_ap_css_profile.p_yr_separation%TYPE              ,
228                     pr_p_yr_divorce               IN OUT NOCOPY igf_ap_css_profile.p_yr_divorce%TYPE                 ,
229                     pr_p_exp_father_inc           IN OUT NOCOPY igf_ap_css_profile.p_exp_father_inc%TYPE             ,
230                     pr_p_exp_mother_inc           IN OUT NOCOPY igf_ap_css_profile.p_exp_mother_inc%TYPE             ,
231                     pr_p_exp_other_tax_inc        IN OUT NOCOPY igf_ap_css_profile.p_exp_other_tax_inc%TYPE          ,
232                     pr_p_exp_other_untax_inc      IN OUT NOCOPY igf_ap_css_profile.p_exp_other_untax_inc%TYPE        ,
233                     pr_line_2_relation            IN OUT NOCOPY igf_ap_css_profile.line_2_relation%TYPE              ,
234                     pr_line_2_attend_college      IN OUT NOCOPY igf_ap_css_profile.line_2_attend_college%TYPE        ,
235                     pr_line_3_relation            IN OUT NOCOPY igf_ap_css_profile.line_3_relation%TYPE              ,
236                     pr_line_3_attend_college      IN OUT NOCOPY igf_ap_css_profile.line_3_attend_college%TYPE        ,
237                     pr_line_4_relation            IN OUT NOCOPY igf_ap_css_profile.line_4_relation%TYPE              ,
238                     pr_line_4_attend_college      IN OUT NOCOPY igf_ap_css_profile.line_4_attend_college%TYPE        ,
239                     pr_line_5_relation            IN OUT NOCOPY igf_ap_css_profile.line_5_relation%TYPE              ,
240                     pr_line_5_attend_college      IN OUT NOCOPY igf_ap_css_profile.line_5_attend_college%TYPE        ,
241                     pr_line_6_relation            IN OUT NOCOPY igf_ap_css_profile.line_6_relation%TYPE              ,
242                     pr_line_6_attend_college      IN OUT NOCOPY igf_ap_css_profile.line_6_attend_college%TYPE        ,
243                     pr_line_7_relation            IN OUT NOCOPY igf_ap_css_profile.line_7_relation%TYPE              ,
244                     pr_line_7_attend_college      IN OUT NOCOPY igf_ap_css_profile.line_7_attend_college%TYPE        ,
245                     pr_line_8_relation            IN OUT NOCOPY igf_ap_css_profile.line_8_relation%TYPE              ,
246                     pr_line_8_attend_college      IN OUT NOCOPY igf_ap_css_profile.line_8_attend_college%TYPE        ,
247                     pr_p_age_father               IN OUT NOCOPY igf_ap_css_profile.p_age_father%TYPE                 ,
248                     pr_p_age_mother               IN OUT NOCOPY igf_ap_css_profile.p_age_mother%TYPE                 ,
249                     pr_p_div_sep_ind              IN OUT NOCOPY igf_ap_css_profile.p_div_sep_ind%TYPE                ,
250                     pr_b_cont_non_custodial_par   IN OUT NOCOPY igf_ap_css_profile.b_cont_non_custodial_par%TYPE     ,
251                     pr_college_type_2             IN OUT NOCOPY igf_ap_css_profile.college_type_2%TYPE               ,
252                     pr_college_type_3             IN OUT NOCOPY igf_ap_css_profile.college_type_3%TYPE               ,
253                     pr_college_type_4             IN OUT NOCOPY igf_ap_css_profile.college_type_4%TYPE               ,
254                     pr_college_type_5             IN OUT NOCOPY igf_ap_css_profile.college_type_5%TYPE               ,
255                     pr_college_type_6             IN OUT NOCOPY igf_ap_css_profile.college_type_6%TYPE              ,
256                     pr_college_type_7             IN OUT NOCOPY igf_ap_css_profile.college_type_7%TYPE               ,
257                     pr_college_type_8             IN OUT NOCOPY igf_ap_css_profile.college_type_8%TYPE               ,
258                     pr_school_code_1              IN OUT NOCOPY igf_ap_css_profile.school_code_1%TYPE                ,
259                     pr_housing_code_1             IN OUT NOCOPY igf_ap_css_profile.housing_code_1%TYPE               ,
260                     pr_school_code_2              IN OUT NOCOPY igf_ap_css_profile.school_code_2%TYPE                ,
261                     pr_housing_code_2             IN OUT NOCOPY igf_ap_css_profile.housing_code_2%TYPE               ,
262                     pr_school_code_3              IN OUT NOCOPY igf_ap_css_profile.school_code_3%TYPE                ,
263                     pr_housing_code_3             IN OUT NOCOPY igf_ap_css_profile.housing_code_3%TYPE               ,
264                     pr_school_code_4              IN OUT NOCOPY igf_ap_css_profile.school_code_4%TYPE                ,
265                     pr_housing_code_4             IN OUT NOCOPY igf_ap_css_profile.housing_code_4%TYPE               ,
266                     pr_school_code_5              IN OUT NOCOPY igf_ap_css_profile.school_code_5%TYPE                ,
267                     pr_housing_code_5             IN OUT NOCOPY igf_ap_css_profile.housing_code_5%TYPE               ,
268                     pr_school_code_6              IN OUT NOCOPY igf_ap_css_profile.school_code_6%TYPE                ,
272                     pr_school_code_8              IN OUT NOCOPY igf_ap_css_profile.school_code_8%TYPE                ,
269                     pr_housing_code_6             IN OUT NOCOPY igf_ap_css_profile.housing_code_6%TYPE               ,
270                     pr_school_code_7              IN OUT NOCOPY igf_ap_css_profile.school_code_7%TYPE                ,
271                     pr_housing_code_7             IN OUT NOCOPY igf_ap_css_profile.housing_code_7%TYPE               ,
273                     pr_housing_code_8             IN OUT NOCOPY igf_ap_css_profile.housing_code_8%TYPE               ,
274                     pr_school_code_9              IN OUT NOCOPY igf_ap_css_profile.school_code_9%TYPE                ,
275                     pr_housing_code_9             IN OUT NOCOPY igf_ap_css_profile.housing_code_9%TYPE               ,
276                     pr_school_code_10             IN OUT NOCOPY igf_ap_css_profile.school_code_10%TYPE               ,
277                     pr_housing_code_10            IN OUT NOCOPY igf_ap_css_profile.housing_code_10%TYPE              ,
278                     pr_additional_school_code_1   IN OUT NOCOPY igf_ap_css_profile.additional_school_code_1%TYPE     ,
279                     pr_additional_school_code_2   IN OUT NOCOPY igf_ap_css_profile.additional_school_code_2%TYPE     ,
280                     pr_additional_school_code_3   IN OUT NOCOPY igf_ap_css_profile.additional_school_code_3%TYPE     ,
281                     pr_additional_school_code_4   IN OUT NOCOPY igf_ap_css_profile.additional_school_code_4%TYPE     ,
282                     pr_additional_school_code_5   IN OUT NOCOPY igf_ap_css_profile.additional_school_code_5%TYPE     ,
283                     pr_additional_school_code_6   IN OUT NOCOPY igf_ap_css_profile.additional_school_code_6%TYPE     ,
284                     pr_additional_school_code_7   IN OUT NOCOPY igf_ap_css_profile.additional_school_code_7%TYPE     ,
285                     pr_additional_school_code_8   IN OUT NOCOPY igf_ap_css_profile.additional_school_code_8%TYPE     ,
286                     pr_additional_school_code_9   IN OUT NOCOPY igf_ap_css_profile.additional_school_code_9%TYPE     ,
287                     pr_additional_school_code_10  IN OUT NOCOPY igf_ap_css_profile.additional_school_code_10%TYPE    ,
288                     pr_explanation_spec_circum    IN OUT NOCOPY igf_ap_css_profile.explanation_spec_circum%TYPE      ,
289                     pr_signature_student          IN OUT NOCOPY igf_ap_css_profile.signature_student%TYPE            ,
290                     pr_signature_spouse           IN OUT NOCOPY igf_ap_css_profile.signature_spouse%TYPE             ,
291                     pr_signature_father           IN OUT NOCOPY igf_ap_css_profile.signature_father%TYPE             ,
292                     pr_signature_mother           IN OUT NOCOPY igf_ap_css_profile.signature_mother%TYPE             ,
293                     pr_month_day_completed        IN OUT NOCOPY igf_ap_css_profile.month_day_completed%TYPE          ,
294                     pr_year_completed             IN OUT NOCOPY igf_ap_css_profile.year_completed%TYPE               ,
295                     pr_age_line_2                 IN OUT NOCOPY igf_ap_css_profile.age_line_2%TYPE                   ,
296                     pr_age_line_3                 IN OUT NOCOPY igf_ap_css_profile.age_line_3%TYPE                   ,
297                     pr_age_line_4                 IN OUT NOCOPY igf_ap_css_profile.age_line_4%TYPE                   ,
298                     pr_age_line_5                 IN OUT NOCOPY igf_ap_css_profile.age_line_5%TYPE                   ,
299                     pr_age_line_6                 IN OUT NOCOPY igf_ap_css_profile.age_line_6%TYPE                   ,
300                     pr_age_line_7                 IN OUT NOCOPY igf_ap_css_profile.age_line_7%TYPE                   ,
301                     pr_age_line_8                 IN OUT NOCOPY igf_ap_css_profile.age_line_8%TYPE                   ,
302                     pr_a_online_signature         IN OUT NOCOPY igf_ap_css_profile.a_online_signature%TYPE           ,
303                     pr_question_1_number          IN OUT NOCOPY igf_ap_css_profile.question_1_number%TYPE            ,
304                     pr_question_1_size            IN OUT NOCOPY igf_ap_css_profile.question_1_size%TYPE              ,
305                     pr_question_1_answer          IN OUT NOCOPY igf_ap_css_profile.question_1_answer%TYPE            ,
306                     pr_question_2_number          IN OUT NOCOPY igf_ap_css_profile.question_2_number%TYPE            ,
307                     pr_question_2_size            IN OUT NOCOPY igf_ap_css_profile.question_2_size%TYPE              ,
308                     pr_question_2_answer          IN OUT NOCOPY igf_ap_css_profile.question_2_answer%TYPE            ,
309                     pr_question_3_number          IN OUT NOCOPY igf_ap_css_profile.question_3_number%TYPE            ,
310                     pr_question_3_size            IN OUT NOCOPY igf_ap_css_profile.question_3_size%TYPE             ,
311                     pr_question_3_answer          IN OUT NOCOPY igf_ap_css_profile.question_3_answer%TYPE            ,
312                     pr_question_4_number          IN OUT NOCOPY igf_ap_css_profile.question_4_number%TYPE            ,
313                     pr_question_4_size            IN OUT NOCOPY igf_ap_css_profile.question_4_size%TYPE              ,
314                     pr_question_4_answer          IN OUT NOCOPY igf_ap_css_profile.question_4_answer%TYPE            ,
315                     pr_question_5_number          IN OUT NOCOPY igf_ap_css_profile.question_5_number%TYPE            ,
316                     pr_question_5_size            IN OUT NOCOPY igf_ap_css_profile.question_5_size%TYPE              ,
317                     pr_question_5_answer          IN OUT NOCOPY igf_ap_css_profile.question_5_answer%TYPE            ,
318                     pr_question_6_number          IN OUT NOCOPY igf_ap_css_profile.question_6_number%TYPE            ,
319                     pr_question_6_size            IN OUT NOCOPY igf_ap_css_profile.question_6_size%TYPE              ,
320                     pr_question_6_answer          IN OUT NOCOPY igf_ap_css_profile.question_6_answer%TYPE            ,
321                     pr_question_7_number          IN OUT NOCOPY igf_ap_css_profile.question_7_number%TYPE            ,
322                     pr_question_7_size            IN OUT NOCOPY igf_ap_css_profile.question_7_size%TYPE              ,
326                     pr_question_8_answer          IN OUT NOCOPY igf_ap_css_profile.question_8_answer%TYPE            ,
323                     pr_question_7_answer          IN OUT NOCOPY igf_ap_css_profile.question_7_answer%TYPE            ,
324                     pr_question_8_number          IN OUT NOCOPY igf_ap_css_profile.question_8_number%TYPE            ,
325                     pr_question_8_size            IN OUT NOCOPY igf_ap_css_profile.question_8_size%TYPE              ,
327                     pr_question_9_number          IN OUT NOCOPY igf_ap_css_profile.question_9_number%TYPE            ,
328                     pr_question_9_size            IN OUT NOCOPY igf_ap_css_profile.question_9_size%TYPE              ,
329                     pr_question_9_answer          IN OUT NOCOPY igf_ap_css_profile.question_9_answer%TYPE            ,
330                     pr_question_10_number         IN OUT NOCOPY igf_ap_css_profile.question_10_number%TYPE           ,
331                     pr_question_10_size           IN OUT NOCOPY igf_ap_css_profile.question_10_size%TYPE             ,
332                     pr_question_10_answer         IN OUT NOCOPY igf_ap_css_profile.question_10_answer%TYPE           ,
333                     pr_question_11_number         IN OUT NOCOPY igf_ap_css_profile.question_11_number%TYPE           ,
334                     pr_question_11_size           IN OUT NOCOPY igf_ap_css_profile.question_11_size%TYPE             ,
335                     pr_question_11_answer         IN OUT NOCOPY igf_ap_css_profile.question_11_answer%TYPE           ,
336                     pr_question_12_number         IN OUT NOCOPY igf_ap_css_profile.question_12_number%TYPE           ,
337                     pr_question_12_size           IN OUT NOCOPY igf_ap_css_profile.question_12_size%TYPE             ,
338                     pr_question_12_answer         IN OUT NOCOPY igf_ap_css_profile.question_12_answer%TYPE           ,
339                     pr_question_13_number         IN OUT NOCOPY igf_ap_css_profile.question_13_number%TYPE           ,
340                     pr_question_13_size           IN OUT NOCOPY igf_ap_css_profile.question_13_size%TYPE             ,
341                     pr_question_13_answer         IN OUT NOCOPY igf_ap_css_profile.question_13_answer%TYPE           ,
342                     pr_question_14_number         IN OUT NOCOPY igf_ap_css_profile.question_14_number%TYPE           ,
343                     pr_question_14_size           IN OUT NOCOPY igf_ap_css_profile.question_14_size%TYPE             ,
344                     pr_question_14_answer         IN OUT NOCOPY igf_ap_css_profile.question_14_answer%TYPE           ,
345                     pr_question_15_number         IN OUT NOCOPY igf_ap_css_profile.question_15_number%TYPE           ,
346                     pr_question_15_size           IN OUT NOCOPY igf_ap_css_profile.question_15_size%TYPE             ,
347                     pr_question_15_answer         IN OUT NOCOPY igf_ap_css_profile.question_15_answer%TYPE           ,
348                     pr_question_16_number         IN OUT NOCOPY igf_ap_css_profile.question_16_number%TYPE           ,
349                     pr_question_16_size           IN OUT NOCOPY igf_ap_css_profile.question_16_size%TYPE             ,
350                     pr_question_16_answer         IN OUT NOCOPY igf_ap_css_profile.question_16_answer%TYPE           ,
351                     pr_question_17_number         IN OUT NOCOPY igf_ap_css_profile.question_17_number%TYPE           ,
352                     pr_question_17_size           IN OUT NOCOPY igf_ap_css_profile.question_17_size%TYPE             ,
353                     pr_question_17_answer         IN OUT NOCOPY igf_ap_css_profile.question_17_answer%TYPE           ,
354                     pr_question_18_number         IN OUT NOCOPY igf_ap_css_profile.question_18_number%TYPE           ,
355                     pr_question_18_size           IN OUT NOCOPY igf_ap_css_profile.question_18_size%TYPE             ,
356                     pr_question_18_answer         IN OUT NOCOPY igf_ap_css_profile.question_18_answer%TYPE           ,
357                     pr_question_19_number         IN OUT NOCOPY igf_ap_css_profile.question_19_number%TYPE           ,
358                     pr_question_19_size           IN OUT NOCOPY igf_ap_css_profile.question_19_size%TYPE             ,
359                     pr_question_19_answer         IN OUT NOCOPY igf_ap_css_profile.question_19_answer%TYPE           ,
360                     pr_question_20_number         IN OUT NOCOPY igf_ap_css_profile.question_20_number%TYPE           ,
361                     pr_question_20_size           IN OUT NOCOPY igf_ap_css_profile.question_20_size%TYPE             ,
362                     pr_question_20_answer         IN OUT NOCOPY igf_ap_css_profile.question_20_answer%TYPE           ,
363                     pr_question_21_number         IN OUT NOCOPY igf_ap_css_profile.question_21_number%TYPE           ,
364                     pr_question_21_size           IN OUT NOCOPY igf_ap_css_profile.question_21_size%TYPE             ,
365                     pr_question_21_answer         IN OUT NOCOPY igf_ap_css_profile.question_21_answer%TYPE           ,
366                     pr_question_22_number         IN OUT NOCOPY igf_ap_css_profile.question_22_number%TYPE           ,
367                     pr_question_22_size           IN OUT NOCOPY igf_ap_css_profile.question_22_size%TYPE             ,
368                     pr_question_22_answer         IN OUT NOCOPY igf_ap_css_profile.question_22_answer%TYPE           ,
369                     pr_question_23_number         IN OUT NOCOPY igf_ap_css_profile.question_23_number%TYPE           ,
370                     pr_question_23_size           IN OUT NOCOPY igf_ap_css_profile.question_23_size%TYPE             ,
371                     pr_question_23_answer         IN OUT NOCOPY igf_ap_css_profile.question_23_answer%TYPE           ,
372                     pr_question_24_number         IN OUT NOCOPY igf_ap_css_profile.question_24_number%TYPE           ,
373                     pr_question_24_size           IN OUT NOCOPY igf_ap_css_profile.question_24_size%TYPE             ,
374                     pr_question_24_answer         IN OUT NOCOPY igf_ap_css_profile.question_24_answer%TYPE           ,
375                     pr_question_25_number         IN OUT NOCOPY igf_ap_css_profile.question_25_number%TYPE           ,
379                     pr_question_26_size           IN OUT NOCOPY igf_ap_css_profile.question_26_size%TYPE             ,
376                     pr_question_25_size           IN OUT NOCOPY igf_ap_css_profile.question_25_size%TYPE             ,
377                     pr_question_25_answer         IN OUT NOCOPY igf_ap_css_profile.question_25_answer%TYPE           ,
378                     pr_question_26_number         IN OUT NOCOPY igf_ap_css_profile.question_26_number%TYPE           ,
380                     pr_question_26_answer         IN OUT NOCOPY igf_ap_css_profile.question_26_answer%TYPE           ,
381                     pr_question_27_number         IN OUT NOCOPY igf_ap_css_profile.question_27_number%TYPE           ,
382                     pr_question_27_size           IN OUT NOCOPY igf_ap_css_profile.question_27_size%TYPE             ,
383                     pr_question_27_answer         IN OUT NOCOPY igf_ap_css_profile.question_27_answer%TYPE           ,
384                     pr_question_28_number         IN OUT NOCOPY igf_ap_css_profile.question_28_number%TYPE           ,
385                     pr_question_28_size           IN OUT NOCOPY igf_ap_css_profile.question_28_size%TYPE             ,
386                     pr_question_28_answer         IN OUT NOCOPY igf_ap_css_profile.question_28_answer%TYPE           ,
387                     pr_question_29_number         IN OUT NOCOPY igf_ap_css_profile.question_29_number%TYPE           ,
388                     pr_question_29_size           IN OUT NOCOPY igf_ap_css_profile.question_29_size%TYPE             ,
389                     pr_question_29_answer         IN OUT NOCOPY igf_ap_css_profile.question_29_answer%TYPE           ,
390                     pr_question_30_number         IN OUT NOCOPY igf_ap_css_profile.question_30_number%TYPE           ,
391                     pr_questions_30_size          IN OUT NOCOPY igf_ap_css_profile.questions_30_size%TYPE            ,
392                     pr_question_30_answer         IN OUT NOCOPY igf_ap_css_profile.question_30_answer%TYPE           ,
393                     pr_legacy_record_flag         IN OUT NOCOPY igf_ap_css_profile.legacy_record_flag%TYPE           ,
394                     pr_coa_duration_efc_amt       IN OUT NOCOPY igf_ap_css_profile.coa_duration_efc_amt%TYPE         ,
395                     pr_coa_duration_num           IN OUT NOCOPY igf_ap_css_profile.coa_duration_num %TYPE            ,
396                     pr_created_by                 IN OUT NOCOPY igf_ap_css_profile.created_by%TYPE                   ,
397                     pr_creation_date              IN OUT NOCOPY igf_ap_css_profile.creation_date%TYPE                ,
398                     pr_last_updated_by            IN OUT NOCOPY igf_ap_css_profile.last_updated_by%TYPE              ,
399                     pr_last_update_date           IN OUT NOCOPY igf_ap_css_profile.last_update_date%TYPE             ,
400                     pr_last_update_login          IN OUT NOCOPY igf_ap_css_profile.last_update_login%TYPE            ,
401                     pr_p_soc_sec_ben_student_amt  IN OUT NOCOPY igf_ap_css_profile.p_soc_sec_ben_student_amt%TYPE    ,
402                     pr_p_tuit_fee_deduct_amt      IN OUT NOCOPY igf_ap_css_profile.p_tuit_fee_deduct_amt%TYPE        ,
403                     pr_stu_lives_with_num         IN OUT NOCOPY igf_ap_css_profile.stu_lives_with_num%TYPE           ,
404                     pr_stu_most_support_from_num  IN OUT NOCOPY igf_ap_css_profile.stu_most_support_from_num%TYPE    ,
405                     pr_location_computer_num      IN OUT NOCOPY igf_ap_css_profile.location_computer_num%TYPE        ,
406 
407                     f_fnar_id                               IN OUT NOCOPY igf_ap_css_fnar.fnar_id%TYPE                       ,
408                     f_cssp_id                               IN OUT NOCOPY igf_ap_css_fnar.cssp_id%TYPE                      ,
409                     f_r_s_email_address                     IN OUT NOCOPY igf_ap_css_fnar.r_s_email_address%TYPE            ,
410                     f_eps_code                              IN OUT NOCOPY igf_ap_css_fnar.eps_code%TYPE                     ,
411                     f_comp_css_dependency_status            IN OUT NOCOPY igf_ap_css_fnar.comp_css_dependency_status%TYPE   ,
412                     f_stu_age                               IN OUT NOCOPY igf_ap_css_fnar.stu_age%TYPE                      ,
413                     f_assumed_stu_yr_in_coll                IN OUT NOCOPY igf_ap_css_fnar.assumed_stu_yr_in_coll%TYPE       ,
414                     f_comp_stu_marital_status               IN OUT NOCOPY igf_ap_css_fnar.comp_stu_marital_status%TYPE      ,
415                     f_stu_family_members                    IN OUT NOCOPY igf_ap_css_fnar.stu_family_members%TYPE           ,
416                     f_stu_fam_members_in_college            IN OUT NOCOPY igf_ap_css_fnar.stu_fam_members_in_college%TYPE   ,
417                     f_par_marital_status                    IN OUT NOCOPY igf_ap_css_fnar.par_marital_status%TYPE           ,
418                     f_par_family_members                    IN OUT NOCOPY igf_ap_css_fnar.par_family_members%TYPE           ,
419                     f_par_total_in_college                  IN OUT NOCOPY igf_ap_css_fnar.par_total_in_college%TYPE         ,
420                     f_par_par_in_college                    IN OUT NOCOPY igf_ap_css_fnar.par_par_in_college%TYPE           ,
421                     f_par_others_in_college                 IN OUT NOCOPY igf_ap_css_fnar.par_others_in_college%TYPE        ,
422                     f_par_aesa                              IN OUT NOCOPY igf_ap_css_fnar.par_aesa%TYPE                     ,
423                     f_par_cesa                              IN OUT NOCOPY igf_ap_css_fnar.par_cesa%TYPE                     ,
424                     f_stu_aesa                              IN OUT NOCOPY igf_ap_css_fnar.stu_aesa%TYPE                     ,
425                     f_stu_cesa                              IN OUT NOCOPY igf_ap_css_fnar.stu_cesa%TYPE                     ,
426                     f_im_p_bas_agi_taxable_income           IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_agi_taxable_income%TYPE  ,
427                     f_im_p_bas_untx_inc_and_ben             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_untx_inc_and_ben%TYPE    ,
428                     f_im_p_bas_inc_adj                      IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_inc_adj%TYPE             ,
432                     f_im_p_bas_fica_tax                     IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_fica_tax%TYPE            ,
429                     f_im_p_bas_total_income                 IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_income%TYPE        ,
430                     f_im_p_bas_us_income_tax                IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_us_income_tax%TYPE       ,
431                     f_im_p_bas_st_and_other_tax             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_st_and_other_tax%TYPE    ,
433                     f_im_p_bas_med_dental                   IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_med_dental%TYPE          ,
434                     f_im_p_bas_employment_allow             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_employment_allow%TYPE    ,
435                     f_im_p_bas_annual_ed_savings            IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_annual_ed_savings%TYPE   ,
436                     f_im_p_bas_inc_prot_allow_m             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_inc_prot_allow_m%TYPE    ,
437                     f_im_p_bas_total_inc_allow              IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_inc_allow%TYPE     ,
438                     f_im_p_bas_cal_avail_inc                IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cal_avail_inc%TYPE       ,
439                     f_im_p_bas_avail_income                 IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_avail_income%TYPE        ,
440                     f_im_p_bas_total_cont_inc               IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_cont_inc%TYPE      ,
441                     f_im_p_bas_cash_bank_accounts           IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cash_bank_accounts%TYPE  ,
442                     f_im_p_bas_home_equity                  IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_home_equity%TYPE         ,
443                     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    ,
444                     f_im_p_bas_adj_bus_farm_worth           IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_adj_bus_farm_worth%TYPE  ,
445                     f_im_p_bas_ass_sibs_pre_tui             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_ass_sibs_pre_tui%TYPE    ,
446                     f_im_p_bas_net_worth                    IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_net_worth%TYPE           ,
447                     f_im_p_bas_emerg_res_allow              IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_emerg_res_allow%TYPE     ,
448                     f_im_p_bas_cum_ed_savings               IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cum_ed_savings%TYPE      ,
449                     f_im_p_bas_low_inc_allow                IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_low_inc_allow%TYPE       ,
450                     f_im_p_bas_total_asset_allow            IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_asset_allow%TYPE   ,
451                     f_im_p_bas_disc_net_worth               IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_disc_net_worth%TYPE      ,
452                     f_im_p_bas_total_cont_asset             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_cont_asset%TYPE    ,
453                     f_im_p_bas_total_cont                   IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_cont%TYPE          ,
454                     f_im_p_bas_num_in_coll_adj              IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_num_in_coll_adj%TYPE     ,
455                     f_im_p_bas_cont_for_stu                 IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cont_for_stu%TYPE        ,
456                     f_im_p_bas_cont_from_income             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cont_from_income%TYPE    ,
457                     f_im_p_bas_cont_from_assets             IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cont_from_assets%TYPE    ,
458                     f_im_p_opt_agi_taxable_income           IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_agi_taxable_income%TYPE  ,
459                     f_im_p_opt_untx_inc_and_ben             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_untx_inc_and_ben%TYPE    ,
460                     f_im_p_opt_inc_adj                      IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_inc_adj%TYPE             ,
461                     f_im_p_opt_total_income                 IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_income%TYPE        ,
462                     f_im_p_opt_us_income_tax                IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_us_income_tax%TYPE       ,
463                     f_im_p_opt_st_and_other_tax             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_st_and_other_tax%TYPE    ,
464                     f_im_p_opt_fica_tax                     IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_fica_tax%TYPE            ,
465                     f_im_p_opt_med_dental                   IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_med_dental%TYPE          ,
466                     f_im_p_opt_elem_sec_tuit                IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_elem_sec_tuit%TYPE       ,
467                     f_im_p_opt_employment_allow             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_employment_allow%TYPE    ,
468                     f_im_p_opt_annual_ed_savings            IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_annual_ed_savings%TYPE   ,
469                     f_im_p_opt_inc_prot_allow_m             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_inc_prot_allow_m%TYPE    ,
470                     f_im_p_opt_total_inc_allow              IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_inc_allow%TYPE     ,
471                     f_im_p_opt_cal_avail_inc                IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cal_avail_inc%TYPE       ,
472                     f_im_p_opt_avail_income                 IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_avail_income%TYPE        ,
473                     f_im_p_opt_total_cont_inc               IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_cont_inc%TYPE      ,
474                     f_im_p_opt_cash_bank_accounts           IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cash_bank_accounts%TYPE  ,
475                     f_im_p_opt_home_equity                  IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_home_equity%TYPE         ,
476                     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   ,
477                     f_im_p_opt_adj_bus_farm_worth           IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_adj_bus_farm_worth%TYPE  ,
478                     f_im_p_opt_ass_sibs_pre_tui             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_ass_sibs_pre_tui%TYPE    ,
479                     f_im_p_opt_net_worth                    IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_net_worth%TYPE           ,
483                     f_im_p_opt_total_asset_allow            IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_asset_allow%TYPE   ,
480                     f_im_p_opt_emerg_res_allow              IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_emerg_res_allow%TYPE     ,
481                     f_im_p_opt_cum_ed_savings               IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cum_ed_savings%TYPE      ,
482                     f_im_p_opt_low_inc_allow                IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_low_inc_allow%TYPE       ,
484                     f_im_p_opt_disc_net_worth               IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_disc_net_worth%TYPE      ,
485                     f_im_p_opt_total_cont_asset             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_cont_asset%TYPE    ,
486                     f_im_p_opt_total_cont                   IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_cont%TYPE          ,
487                     f_im_p_opt_num_in_coll_adj              IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_num_in_coll_adj%TYPE     ,
488                     f_im_p_opt_cont_for_stu                 IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cont_for_stu%TYPE        ,
489                     f_im_p_opt_cont_from_income             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cont_from_income%TYPE    ,
490                     f_im_p_opt_cont_from_assets             IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cont_from_assets%TYPE    ,
491                     f_fm_p_analysis_type                    IN OUT NOCOPY igf_ap_css_fnar.fm_p_analysis_type%TYPE           ,
492                     f_fm_p_agi_taxable_income               IN OUT NOCOPY igf_ap_css_fnar.fm_p_agi_taxable_income%TYPE      ,
493                     f_fm_p_untx_inc_and_ben                 IN OUT NOCOPY igf_ap_css_fnar.fm_p_untx_inc_and_ben%TYPE        ,
494                     f_fm_p_inc_adj                          IN OUT NOCOPY igf_ap_css_fnar.fm_p_inc_adj%TYPE                 ,
495                     f_fm_p_total_income                     IN OUT NOCOPY igf_ap_css_fnar.fm_p_total_income%TYPE            ,
496                     f_fm_p_us_income_tax                    IN OUT NOCOPY igf_ap_css_fnar.fm_p_us_income_tax%TYPE           ,
497                     f_fm_p_state_and_other_taxes            IN OUT NOCOPY igf_ap_css_fnar.fm_p_state_and_other_taxes%TYPE   ,
498                     f_fm_p_fica_tax                         IN OUT NOCOPY igf_ap_css_fnar.fm_p_fica_tax%TYPE                ,
499                     f_fm_p_employment_allow                 IN OUT NOCOPY igf_ap_css_fnar.fm_p_employment_allow%TYPE        ,
500                     f_fm_p_income_prot_allow                IN OUT NOCOPY igf_ap_css_fnar.fm_p_income_prot_allow%TYPE       ,
501                     f_fm_p_total_allow                      IN OUT NOCOPY igf_ap_css_fnar.fm_p_total_allow%TYPE             ,
502                     f_fm_p_avail_income                     IN OUT NOCOPY igf_ap_css_fnar.fm_p_avail_income%TYPE            ,
503                     f_fm_p_cash_bank_accounts               IN OUT NOCOPY igf_ap_css_fnar.fm_p_cash_bank_accounts%TYPE      ,
504                     f_fm_p_ot_rl_est_inv_equity             IN OUT NOCOPY igf_ap_css_fnar.fm_p_ot_rl_est_inv_equity%TYPE    ,
505                     f_fm_p_adj_bus_farm_net_worth           IN OUT NOCOPY igf_ap_css_fnar.fm_p_adj_bus_farm_net_worth%TYPE  ,
506                     f_fm_p_net_worth                        IN OUT NOCOPY igf_ap_css_fnar.fm_p_net_worth%TYPE               ,
507                     f_fm_p_asset_prot_allow                 IN OUT NOCOPY igf_ap_css_fnar.fm_p_asset_prot_allow%TYPE        ,
508                     f_fm_p_disc_net_worth                   IN OUT NOCOPY igf_ap_css_fnar.fm_p_disc_net_worth%TYPE          ,
509                     f_fm_p_total_contribution               IN OUT NOCOPY igf_ap_css_fnar.fm_p_total_contribution%TYPE      ,
510                     f_fm_p_num_in_coll                      IN OUT NOCOPY igf_ap_css_fnar.fm_p_num_in_coll%TYPE             ,
511                     f_fm_p_cont_for_stu                     IN OUT NOCOPY igf_ap_css_fnar.fm_p_cont_for_stu%TYPE            ,
512                     f_fm_p_cont_from_income                 IN OUT NOCOPY igf_ap_css_fnar.fm_p_cont_from_income%TYPE        ,
513                     f_fm_p_cont_from_assets                 IN OUT NOCOPY igf_ap_css_fnar.fm_p_cont_from_assets%TYPE        ,
514                     f_im_s_bas_agi_taxable_income           IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_agi_taxable_income%TYPE  ,
515                     f_im_s_bas_untx_inc_and_ben             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_untx_inc_and_ben%TYPE    ,
516                     f_im_s_bas_inc_adj                      IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_inc_adj%TYPE             ,
517                     f_im_s_bas_total_income                 IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_income%TYPE        ,
518                     f_im_s_bas_us_income_tax                IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_us_income_tax%TYPE       ,
519                     f_im_s_bas_state_and_oth_taxes          IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_state_and_oth_taxes%TYPE ,
520                     f_im_s_bas_fica_tax                     IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_fica_tax%TYPE            ,
521                     f_im_s_bas_med_dental                   IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_med_dental%TYPE          ,
522                     f_im_s_bas_employment_allow             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_employment_allow%TYPE    ,
523                     f_im_s_bas_annual_ed_savings            IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_annual_ed_savings%TYPE   ,
524                     f_im_s_bas_inc_prot_allow_m             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_inc_prot_allow_m%TYPE    ,
525                     f_im_s_bas_total_inc_allow              IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_inc_allow%TYPE     ,
526                     f_im_s_bas_cal_avail_income             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cal_avail_income%TYPE    ,
527                     f_im_s_bas_avail_income                 IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_avail_income%TYPE        ,
528                     f_im_s_bas_total_cont_inc               IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_cont_inc%TYPE      ,
529                     f_im_s_bas_cash_bank_accounts           IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cash_bank_accounts%TYPE  ,
530                     f_im_s_bas_home_equity                  IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_home_equity%TYPE         ,
534                     f_im_s_bas_net_worth                    IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_net_worth%TYPE           ,
531                     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    ,
532                     f_im_s_bas_adj_busfarm_worth            IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_adj_busfarm_worth%TYPE   ,
533                     f_im_s_bas_trusts                       IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_trusts%TYPE              ,
535                     f_im_s_bas_emerg_res_allow              IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_emerg_res_allow%TYPE     ,
536                     f_im_s_bas_cum_ed_savings               IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cum_ed_savings%TYPE      ,
537                     f_im_s_bas_total_asset_allow            IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_asset_allow%TYPE   ,
538                     f_im_s_bas_disc_net_worth               IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_disc_net_worth%TYPE      ,
539                     f_im_s_bas_total_cont_asset             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_cont_asset%TYPE    ,
540                     f_im_s_bas_total_cont                   IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_cont%TYPE          ,
541                     f_im_s_bas_num_in_coll_adj              IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_num_in_coll_adj%TYPE     ,
542                     f_im_s_bas_cont_for_stu                 IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cont_for_stu%TYPE        ,
543                     f_im_s_bas_cont_from_income             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cont_from_income%TYPE    ,
544                     f_im_s_bas_cont_from_assets             IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cont_from_assets%TYPE    ,
545                     f_im_s_est_agitaxable_income            IN OUT NOCOPY igf_ap_css_fnar.im_s_est_agitaxable_income%TYPE   ,
546                     f_im_s_est_untx_inc_and_ben             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_untx_inc_and_ben%TYPE    ,
547                     f_im_s_est_inc_adj                      IN OUT NOCOPY igf_ap_css_fnar.im_s_est_inc_adj%TYPE             ,
548                     f_im_s_est_total_income                 IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_income%TYPE        ,
549                     f_im_s_est_us_income_tax                IN OUT NOCOPY igf_ap_css_fnar.im_s_est_us_income_tax%TYPE       ,
550                     f_im_s_est_state_and_oth_taxes          IN OUT NOCOPY igf_ap_css_fnar.im_s_est_state_and_oth_taxes%TYPE ,
551                     f_im_s_est_fica_tax                     IN OUT NOCOPY igf_ap_css_fnar.im_s_est_fica_tax%TYPE            ,
552                     f_im_s_est_med_dental                   IN OUT NOCOPY igf_ap_css_fnar.im_s_est_med_dental%TYPE          ,
553                     f_im_s_est_employment_allow             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_employment_allow%TYPE    ,
554                     f_im_s_est_annual_ed_savings            IN OUT NOCOPY igf_ap_css_fnar.im_s_est_annual_ed_savings%TYPE   ,
555                     f_im_s_est_inc_prot_allow_m             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_inc_prot_allow_m%TYPE    ,
556                     f_im_s_est_total_inc_allow              IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_inc_allow%TYPE     ,
557                     f_im_s_est_cal_avail_income             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cal_avail_income%TYPE    ,
558                     f_im_s_est_avail_income                 IN OUT NOCOPY igf_ap_css_fnar.im_s_est_avail_income%TYPE        ,
559                     f_im_s_est_total_cont_inc               IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_cont_inc%TYPE      ,
560                     f_im_s_est_cash_bank_accounts           IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cash_bank_accounts%TYPE  ,
561                     f_im_s_est_home_equity                  IN OUT NOCOPY igf_ap_css_fnar.im_s_est_home_equity%TYPE         ,
562                     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    ,
563                     f_im_s_est_adj_bus_farm_worth           IN OUT NOCOPY igf_ap_css_fnar.im_s_est_adj_bus_farm_worth%TYPE  ,
564                     f_im_s_est_est_trusts                   IN OUT NOCOPY igf_ap_css_fnar.im_s_est_est_trusts%TYPE          ,
565                     f_im_s_est_net_worth                    IN OUT NOCOPY igf_ap_css_fnar.im_s_est_net_worth%TYPE           ,
566                     f_im_s_est_emerg_res_allow              IN OUT NOCOPY igf_ap_css_fnar.im_s_est_emerg_res_allow%TYPE     ,
567                     f_im_s_est_cum_ed_savings               IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cum_ed_savings%TYPE      ,
568                     f_im_s_est_total_asset_allow            IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_asset_allow%TYPE   ,
569                     f_im_s_est_disc_net_worth               IN OUT NOCOPY igf_ap_css_fnar.im_s_est_disc_net_worth%TYPE      ,
570                     f_im_s_est_total_cont_asset             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_cont_asset%TYPE    ,
571                     f_im_s_est_total_cont                   IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_cont%TYPE          ,
572                     f_im_s_est_num_in_coll_adj              IN OUT NOCOPY igf_ap_css_fnar.im_s_est_num_in_coll_adj%TYPE     ,
573                     f_im_s_est_cont_for_stu                 IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cont_for_stu%TYPE        ,
574                     f_im_s_est_cont_from_income             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cont_from_income%TYPE    ,
575                     f_im_s_est_cont_from_assets             IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cont_from_assets%TYPE    ,
576                     f_im_s_opt_agi_taxable_income           IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_agi_taxable_income%TYPE  ,
577                     f_im_s_opt_untx_inc_and_ben             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_untx_inc_and_ben%TYPE    ,
578                     f_im_s_opt_inc_adj                      IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_inc_adj%TYPE             ,
579                     f_im_s_opt_total_income                 IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_income%TYPE        ,
580                     f_im_s_opt_us_income_tax                IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_us_income_tax%TYPE       ,
581                     f_im_s_opt_state_and_oth_taxes          IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_state_and_oth_taxes%TYPE ,
585                     f_im_s_opt_annual_ed_savings            IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_annual_ed_savings%TYPE   ,
582                     f_im_s_opt_fica_tax                     IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_fica_tax%TYPE            ,
583                     f_im_s_opt_med_dental                   IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_med_dental%TYPE          ,
584                     f_im_s_opt_employment_allow             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_employment_allow%TYPE    ,
586                     f_im_s_opt_inc_prot_allow_m             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_inc_prot_allow_m%TYPE    ,
587                     f_im_s_opt_total_inc_allow              IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_inc_allow%TYPE     ,
588                     f_im_s_opt_cal_avail_income             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cal_avail_income%TYPE    ,
589                     f_im_s_opt_avail_income                 IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_avail_income%TYPE        ,
590                     f_im_s_opt_total_cont_inc               IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_cont_inc%TYPE      ,
591                     f_im_s_opt_cash_bank_accounts           IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cash_bank_accounts%TYPE  ,
592                     f_im_s_opt_ira_keogh_accounts           IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_ira_keogh_accounts%TYPE  ,
593                     f_im_s_opt_home_equity                  IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_home_equity%TYPE         ,
594                     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    ,
595                     f_im_s_opt_adj_bus_farm_worth           IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_adj_bus_farm_worth%TYPE  ,
596                     f_im_s_opt_trusts                       IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_trusts%TYPE              ,
597                     f_im_s_opt_net_worth                    IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_net_worth%TYPE           ,
598                     f_im_s_opt_emerg_res_allow              IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_emerg_res_allow%TYPE     ,
599                     f_im_s_opt_cum_ed_savings               IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cum_ed_savings%TYPE      ,
600                     f_im_s_opt_total_asset_allow            IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_asset_allow%TYPE   ,
601                     f_im_s_opt_disc_net_worth               IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_disc_net_worth%TYPE      ,
602                     f_im_s_opt_total_cont_asset             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_cont_asset%TYPE    ,
603                     f_im_s_opt_total_cont                   IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_cont%TYPE          ,
604                     f_im_s_opt_num_in_coll_adj              IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_num_in_coll_adj%TYPE     ,
605                     f_im_s_opt_cont_for_stu                 IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cont_for_stu%TYPE        ,
606                     f_im_s_opt_cont_from_income             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cont_from_income%TYPE    ,
607                     f_im_s_opt_cont_from_assets             IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cont_from_assets%TYPE    ,
608                     f_fm_s_analysis_type                    IN OUT NOCOPY igf_ap_css_fnar.fm_s_analysis_type%TYPE           ,
609                     f_fm_s_agi_taxable_income               IN OUT NOCOPY igf_ap_css_fnar.fm_s_agi_taxable_income%TYPE      ,
610                     f_fm_s_untx_inc_and_ben                 IN OUT NOCOPY igf_ap_css_fnar.fm_s_untx_inc_and_ben%TYPE        ,
611                     f_fm_s_inc_adj                          IN OUT NOCOPY igf_ap_css_fnar.fm_s_inc_adj%TYPE                 ,
612                     f_fm_s_total_income                     IN OUT NOCOPY igf_ap_css_fnar.fm_s_total_income%TYPE            ,
613                     f_fm_s_us_income_tax                    IN OUT NOCOPY igf_ap_css_fnar.fm_s_us_income_tax%TYPE           ,
614                     f_fm_s_state_and_oth_taxes              IN OUT NOCOPY igf_ap_css_fnar.fm_s_state_and_oth_taxes%TYPE     ,
615                     f_fm_s_fica_tax                         IN OUT NOCOPY igf_ap_css_fnar.fm_s_fica_tax%TYPE                ,
616                     f_fm_s_employment_allow                 IN OUT NOCOPY igf_ap_css_fnar.fm_s_employment_allow%TYPE        ,
617                     f_fm_s_income_prot_allow                IN OUT NOCOPY igf_ap_css_fnar.fm_s_income_prot_allow%TYPE       ,
618                     f_fm_s_total_allow                      IN OUT NOCOPY igf_ap_css_fnar.fm_s_total_allow%TYPE             ,
619                     f_fm_s_cal_avail_income                 IN OUT NOCOPY igf_ap_css_fnar.fm_s_cal_avail_income%TYPE        ,
620                     f_fm_s_avail_income                     IN OUT NOCOPY igf_ap_css_fnar.fm_s_avail_income%TYPE            ,
621                     f_fm_s_cash_bank_accounts               IN OUT NOCOPY igf_ap_css_fnar.fm_s_cash_bank_accounts%TYPE      ,
622                     f_fm_s_ot_rl_est_inv_equity             IN OUT NOCOPY igf_ap_css_fnar.fm_s_ot_rl_est_inv_equity%TYPE    ,
623                     f_fm_s_adj_bus_farm_worth               IN OUT NOCOPY igf_ap_css_fnar.fm_s_adj_bus_farm_worth%TYPE      ,
624                     f_fm_s_trusts                           IN OUT NOCOPY igf_ap_css_fnar.fm_s_trusts%TYPE                  ,
625                     f_fm_s_net_worth                        IN OUT NOCOPY igf_ap_css_fnar.fm_s_net_worth%TYPE              ,
629                     f_fm_s_num_in_coll                      IN OUT NOCOPY igf_ap_css_fnar.fm_s_num_in_coll%TYPE             ,
626                     f_fm_s_asset_prot_allow                 IN OUT NOCOPY igf_ap_css_fnar.fm_s_asset_prot_allow%TYPE        ,
627                     f_fm_s_disc_net_worth                   IN OUT NOCOPY igf_ap_css_fnar.fm_s_disc_net_worth%TYPE          ,
628                     f_fm_s_total_cont                       IN OUT NOCOPY igf_ap_css_fnar.fm_s_total_cont%TYPE              ,
630                     f_fm_s_cont_for_stu                     IN OUT NOCOPY igf_ap_css_fnar.fm_s_cont_for_stu%TYPE            ,
631                     f_fm_s_cont_from_income                 IN OUT NOCOPY igf_ap_css_fnar.fm_s_cont_from_income%TYPE        ,
632                     f_fm_s_cont_from_assets                 IN OUT NOCOPY igf_ap_css_fnar.fm_s_cont_from_assets%TYPE        ,
633                     f_im_inst_resident_ind                  IN OUT NOCOPY igf_ap_css_fnar.im_inst_resident_ind%TYPE         ,
634                     f_institutional_1_budget_name           IN OUT NOCOPY igf_ap_css_fnar.institutional_1_budget_name%TYPE  ,
635                     f_im_inst_1_budget_duration             IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_budget_duration%TYPE    ,
636                     f_im_inst_1_tuition_fees                IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tuition_fees%TYPE       ,
637                     f_im_inst_1_books_supplies              IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_books_supplies%TYPE     ,
638                     f_im_inst_1_living_expenses             IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_living_expenses%TYPE    ,
639                     f_im_inst_1_tot_expenses                IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tot_expenses%TYPE       ,
640                     f_im_inst_1_tot_stu_cont                IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tot_stu_cont%TYPE       ,
641                     f_im_inst_1_tot_par_cont                IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tot_par_cont%TYPE       ,
642                     f_im_inst_1_tot_family_cont             IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tot_family_cont%TYPE    ,
643                     f_im_inst_1_va_benefits                 IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_va_benefits%TYPE        ,
644                     f_im_inst_1_ot_cont                     IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_ot_cont%TYPE            ,
645                     f_im_inst_1_est_financial_need          IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_est_financial_need%TYPE ,
646                     f_institutional_2_budget_name           IN OUT NOCOPY igf_ap_css_fnar.institutional_2_budget_name%TYPE  ,
647                     f_im_inst_2_budget_duration             IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_budget_duration%TYPE    ,
648                     f_im_inst_2_tuition_fees                IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tuition_fees%TYPE       ,
649                     f_im_inst_2_books_supplies              IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_books_supplies%TYPE     ,
650                     f_im_inst_2_living_expenses             IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_living_expenses%TYPE    ,
651                     f_im_inst_2_tot_expenses                IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tot_expenses%TYPE       ,
652                     f_im_inst_2_tot_stu_cont                IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tot_stu_cont%TYPE       ,
653                     f_im_inst_2_tot_par_cont                IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tot_par_cont%TYPE       ,
654                     f_im_inst_2_tot_family_cont             IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tot_family_cont%TYPE    ,
655                     f_im_inst_2_va_benefits                 IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_va_benefits%TYPE        ,
656                     f_im_inst_2_est_financial_need          IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_est_financial_need%TYPE ,
657                     f_institutional_3_budget_name           IN OUT NOCOPY igf_ap_css_fnar.institutional_3_budget_name%TYPE  ,
658                     f_im_inst_3_budget_duration             IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_budget_duration%TYPE    ,
659                     f_im_inst_3_tuition_fees                IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tuition_fees%TYPE       ,
660                     f_im_inst_3_books_supplies              IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_books_supplies%TYPE     ,
661                     f_im_inst_3_living_expenses             IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_living_expenses%TYPE    ,
662                     f_im_inst_3_tot_expenses                IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tot_expenses%TYPE       ,
663                     f_im_inst_3_tot_stu_cont                IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tot_stu_cont%TYPE       ,
664                     f_im_inst_3_tot_par_cont                IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tot_par_cont%TYPE       ,
665                     f_im_inst_3_tot_family_cont             IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tot_family_cont%TYPE    ,
666                     f_im_inst_3_va_benefits                 IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_va_benefits%TYPE        ,
667                     f_im_inst_3_est_financial_need          IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_est_financial_need%TYPE ,
668                     f_fm_inst_1_federal_efc                 IN OUT NOCOPY igf_ap_css_fnar.fm_inst_1_federal_efc%TYPE        ,
669                     f_fm_inst_1_va_benefits                 IN OUT NOCOPY igf_ap_css_fnar.fm_inst_1_va_benefits%TYPE        ,
670                     f_fm_inst_1_fed_eligibility             IN OUT NOCOPY igf_ap_css_fnar.fm_inst_1_fed_eligibility%TYPE    ,
671                     f_fm_inst_1_pell                        IN OUT NOCOPY igf_ap_css_fnar.fm_inst_1_pell%TYPE               ,
672                     f_option_par_loss_allow_ind             IN OUT NOCOPY igf_ap_css_fnar.option_par_loss_allow_ind%TYPE    ,
673                     f_option_par_tuition_ind                IN OUT NOCOPY igf_ap_css_fnar.option_par_tuition_ind%TYPE       ,
674                     f_option_par_home_ind                   IN OUT NOCOPY igf_ap_css_fnar.option_par_home_ind%TYPE          ,
675                     f_option_par_home_value                 IN OUT NOCOPY igf_ap_css_fnar.option_par_home_value%TYPE        ,
676                     f_option_par_home_debt                  IN OUT NOCOPY igf_ap_css_fnar.option_par_home_debt%TYPE         ,
680                     f_option_stu_home_debt                  IN OUT NOCOPY igf_ap_css_fnar.option_stu_home_debt%TYPE         ,
677                     f_option_stu_ira_keogh_ind              IN OUT NOCOPY igf_ap_css_fnar.option_stu_ira_keogh_ind%TYPE     ,
678                     f_option_stu_home_ind                   IN OUT NOCOPY igf_ap_css_fnar.option_stu_home_ind%TYPE          ,
679                     f_option_stu_home_value                 IN OUT NOCOPY igf_ap_css_fnar.option_stu_home_value%TYPE        ,
681                     f_option_stu_sum_ay_inc_ind             IN OUT NOCOPY igf_ap_css_fnar.option_stu_sum_ay_inc_ind%TYPE    ,
682                     f_option_par_hope_ll_credit             IN OUT NOCOPY igf_ap_css_fnar.option_par_hope_ll_credit%TYPE    ,
683                     f_option_stu_hope_ll_credit             IN OUT NOCOPY igf_ap_css_fnar.option_stu_hope_ll_credit%TYPE    ,
684                     f_option_par_cola_adj_ind               IN OUT NOCOPY igf_ap_css_fnar.option_par_cola_adj_ind%TYPE      ,
685                     f_option_par_stu_fa_assets_ind          IN OUT NOCOPY igf_ap_css_fnar.option_par_stu_fa_assets_ind%TYPE ,
686                     f_option_par_ipt_assets_ind             IN OUT NOCOPY igf_ap_css_fnar.option_par_ipt_assets_ind%TYPE    ,
687                     f_option_stu_ipt_assets_ind             IN OUT NOCOPY igf_ap_css_fnar.option_stu_ipt_assets_ind%TYPE    ,
688                     f_option_par_cola_adj_value             IN OUT NOCOPY igf_ap_css_fnar.option_par_cola_adj_value%TYPE    ,
689                     f_im_parent_1_8_months_bas              IN OUT NOCOPY igf_ap_css_fnar.im_parent_1_8_months_bas%TYPE     ,
690                     f_im_p_more_than_9_mth_ba               IN OUT NOCOPY igf_ap_css_fnar.im_p_more_than_9_mth_ba%TYPE      ,
691                     f_im_parent_1_8_months_opt              IN OUT NOCOPY igf_ap_css_fnar.im_parent_1_8_months_opt%TYPE     ,
692                     f_im_p_more_than_9_mth_op               IN OUT NOCOPY igf_ap_css_fnar.im_p_more_than_9_mth_op%TYPE      ,
693                     f_fnar_message_1                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_1%TYPE               ,
694                     f_fnar_message_2                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_2%TYPE               ,
695                     f_fnar_message_3                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_3%TYPE               ,
696                     f_fnar_message_4                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_4%TYPE              ,
697                     f_fnar_message_5                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_5%TYPE               ,
698                     f_fnar_message_6                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_6%TYPE               ,
699                     f_fnar_message_7                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_7%TYPE               ,
700                     f_fnar_message_8                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_8%TYPE               ,
701                     f_fnar_message_9                        IN OUT NOCOPY igf_ap_css_fnar.fnar_message_9%TYPE               ,
702                     f_fnar_message_10                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_10%TYPE              ,
703                     f_fnar_message_11                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_11%TYPE              ,
704                     f_fnar_message_12                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_12%TYPE              ,
705                     f_fnar_message_13                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_13%TYPE              ,
706                     f_fnar_message_20                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_20%TYPE              ,
707                     f_fnar_message_21                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_21%TYPE              ,
708                     f_fnar_message_22                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_22%TYPE              ,
709                     f_fnar_message_23                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_23%TYPE              ,
710                     f_fnar_message_24                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_24%TYPE              ,
711                     f_fnar_message_25                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_25%TYPE              ,
712                     f_fnar_message_26                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_26%TYPE              ,
713                     f_fnar_message_27                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_27%TYPE              ,
714                     f_fnar_message_30                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_30%TYPE              ,
715                     f_fnar_message_31                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_31%TYPE              ,
716                     f_fnar_message_32                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_32%TYPE              ,
717                     f_fnar_message_33                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_33%TYPE              ,
718                     f_fnar_message_34                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_34%TYPE              ,
719                     f_fnar_message_35                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_35%TYPE              ,
720                     f_fnar_message_36                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_36%TYPE              ,
721                     f_fnar_message_37                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_37%TYPE              ,
722                     f_fnar_message_38                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_38%TYPE              ,
723                     f_fnar_message_39                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_39%TYPE              ,
724                     f_fnar_message_45                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_45%TYPE              ,
725                     f_fnar_message_46                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_46%TYPE              ,
726                     f_fnar_message_47                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_47%TYPE              ,
727                     f_fnar_message_48                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_48%TYPE              ,
731                     f_fnar_message_52                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_52%TYPE              ,
728                     f_fnar_message_49                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_49%TYPE              ,
729                     f_fnar_message_50                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_50%TYPE              ,
730                     f_fnar_message_51                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_51%TYPE              ,
732                     f_fnar_message_53                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_53%TYPE              ,
733                     f_fnar_message_55                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_55%TYPE              ,
734                     f_fnar_message_56                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_56%TYPE              ,
735                     f_fnar_message_57                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_57%TYPE              ,
736                     f_fnar_message_58                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_58%TYPE              ,
737                     f_fnar_message_59                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_59%TYPE              ,
738                     f_fnar_message_60                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_60%TYPE              ,
739                     f_fnar_message_61                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_61%TYPE              ,
740                     f_fnar_message_62                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_62%TYPE              ,
741                     f_fnar_message_63                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_63%TYPE              ,
742                     f_fnar_message_64                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_64%TYPE              ,
743                     f_fnar_message_65                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_65%TYPE              ,
744                     f_fnar_message_71                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_71%TYPE              ,
745                     f_fnar_message_72                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_72%TYPE              ,
746                     f_fnar_message_73                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_73%TYPE              ,
747                     f_fnar_message_74                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_74%TYPE              ,
748                     f_fnar_message_75                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_75%TYPE              ,
749                     f_fnar_message_76                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_76%TYPE              ,
750                     f_fnar_message_77                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_77%TYPE              ,
751                     f_fnar_message_78                       IN OUT NOCOPY igf_ap_css_fnar.fnar_message_78%TYPE              ,
752                     f_fnar_mesg_10_stu_fam_mem              IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_10_stu_fam_mem%TYPE     ,
753                     f_fnar_mesg_11_stu_no_in_coll           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_11_stu_no_in_coll%TYPE  ,
754                     f_fnar_mesg_24_stu_avail_inc            IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_24_stu_avail_inc%TYPE   ,
755                     f_fnar_mesg_26_stu_taxes                IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_26_stu_taxes%TYPE       ,
756                     f_fnar_mesg_33_stu_home_value           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_33_stu_home_value%TYPE  ,
757                     f_fnar_mesg_34_stu_home_value           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_34_stu_home_value%TYPE  ,
758                     f_fnar_mesg_34_stu_home_equity          IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_34_stu_home_equity%TYPE ,
759                     f_fnar_mesg_35_stu_home_value           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_35_stu_home_value%TYPE  ,
760                     f_fnar_mesg_35_stu_home_equity          IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_35_stu_home_equity%TYPE ,
761                     f_fnar_mesg_36_stu_home_equity          IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_36_stu_home_equity%TYPE ,
762                     f_fnar_mesg_48_par_fam_mem              IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_48_par_fam_mem%TYPE     ,
763                     f_fnar_mesg_49_par_no_in_coll           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_49_par_no_in_coll%TYPE  ,
764                     f_fnar_mesg_56_par_agi                  IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_56_par_agi%TYPE         ,
765                     f_fnar_mesg_62_par_taxes                IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_62_par_taxes%TYPE       ,
766                     f_fnar_mesg_73_par_home_value           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_73_par_home_value%TYPE  ,
767                     f_fnar_mesg_74_par_home_value           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_74_par_home_value%TYPE  ,
768                     f_fnar_mesg_74_par_home_equity          IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_74_par_home_equity%TYPE ,
769                     f_fnar_mesg_75_par_home_value           IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_75_par_home_value%TYPE  ,
770                     f_fnar_mesg_75_par_home_equity          IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_75_par_home_equity%TYPE ,
771                     f_fnar_mesg_76_par_home_equity          IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_76_par_home_equity%TYPE ,
772                     f_assumption_message_1                  IN OUT NOCOPY igf_ap_css_fnar.assumption_message_1%TYPE         ,
773                     f_assumption_message_2                  IN OUT NOCOPY igf_ap_css_fnar.assumption_message_2%TYPE         ,
774                     f_assumption_message_3                  IN OUT NOCOPY igf_ap_css_fnar.assumption_message_3%TYPE         ,
775                     f_assumption_message_4                  IN OUT NOCOPY igf_ap_css_fnar.assumption_message_4%TYPE         ,
776                     f_assumption_message_5                  IN OUT NOCOPY igf_ap_css_fnar.assumption_message_5%TYPE         ,
777                     f_assumption_message_6                  IN OUT NOCOPY igf_ap_css_fnar.assumption_message_6%TYPE         ,
778                     f_record_mark                           IN OUT NOCOPY igf_ap_css_fnar.record_mark%TYPE                  ,
782                     f_last_updated_by                       IN OUT NOCOPY igf_ap_css_fnar.last_updated_by%TYPE              ,
779                     f_legacy_record_flag                    IN OUT NOCOPY igf_ap_css_fnar.legacy_record_flag%TYPE           ,
780                     f_creation_date                         IN OUT NOCOPY igf_ap_css_fnar.creation_date%TYPE                ,
781                     f_created_by                            IN OUT NOCOPY igf_ap_css_fnar.created_by%TYPE                   ,
783                     f_last_update_date                      IN OUT NOCOPY igf_ap_css_fnar.last_update_date%TYPE             ,
784                     f_last_update_login                     IN OUT NOCOPY igf_ap_css_fnar.last_update_login%TYPE            ,
785                     f_opt_ind_stu_ipt_assets_flag           IN OUT NOCOPY igf_ap_css_fnar.option_ind_stu_ipt_assets_flag%TYPE ,
786                     f_cust_parent_cont_adj_num              IN OUT NOCOPY igf_ap_css_fnar.cust_parent_cont_adj_num%TYPE     ,
787                     f_custodial_parent_num                  IN OUT NOCOPY igf_ap_css_fnar.custodial_parent_num%TYPE         ,
788                     f_cust_par_base_prcnt_inc_amt           IN OUT NOCOPY igf_ap_css_fnar.cust_par_base_prcnt_inc_amt%TYPE  ,
789                     f_cust_par_base_cont_inc_amt            IN OUT NOCOPY igf_ap_css_fnar.cust_par_base_cont_inc_amt%TYPE   ,
790                     f_cust_par_base_cont_ast_amt            IN OUT NOCOPY igf_ap_css_fnar.cust_par_base_cont_ast_amt%TYPE   ,
791                     f_cust_par_base_tot_cont_amt            IN OUT NOCOPY igf_ap_css_fnar.cust_par_base_tot_cont_amt%TYPE   ,
792                     f_cust_par_opt_prcnt_inc_amt            IN OUT NOCOPY igf_ap_css_fnar.cust_par_opt_prcnt_inc_amt%TYPE   ,
793                     f_cust_par_opt_cont_inc_amt             IN OUT NOCOPY igf_ap_css_fnar.cust_par_opt_cont_inc_amt%TYPE    ,
794                     f_cust_par_opt_cont_ast_amt             IN OUT NOCOPY igf_ap_css_fnar.cust_par_opt_cont_ast_amt%TYPE    ,
795                     f_cust_par_opt_tot_cont_amt             IN OUT NOCOPY igf_ap_css_fnar.cust_par_opt_tot_cont_amt%TYPE    ,
796                     f_parents_email_txt                     IN OUT NOCOPY igf_ap_css_fnar.parents_email_txt%TYPE            ,
797                     f_parent_1_birth_date                   IN OUT NOCOPY igf_ap_css_fnar.parent_1_birth_date%TYPE          ,
798                     f_parent_2_birth_date                   IN OUT NOCOPY igf_ap_css_fnar.parent_2_birth_date%TYPE          ,
799 
800                     p_err_mesg OUT NOCOPY fnd_new_messages.message_name%TYPE)
801   RETURN VARCHAR AS
802 
803   p_profile_rec igf_ap_css_profile%ROWTYPE;
804 
805   p_fnar_rec igf_ap_css_fnar%ROWTYPE;
806 
807   p_user_hook BOOLEAN;
808 
809   p_error_msg fnd_new_messages.message_name%TYPE;
810 
811   BEGIN
812 
813 
814     p_profile_rec.cssp_id                         :=  pr_cssp_id                        ;
815     p_profile_rec.org_id                          :=  pr_org_id                         ;
816     p_profile_rec.base_id                         :=  pr_base_id                        ;
817     p_profile_rec.system_record_type              :=  pr_system_record_type             ;
818     p_profile_rec.active_profile                  :=  pr_active_profile                 ;
819     p_profile_rec.college_code                    :=  pr_college_code                   ;
820     p_profile_rec.academic_year                   :=  pr_academic_year                  ;
821     p_profile_rec.stu_record_type                 :=  pr_stu_record_type                ;
822     p_profile_rec.css_id_number                   :=  pr_css_id_number                  ;
823     p_profile_rec.registration_receipt_date       :=  pr_registration_receipt_date      ;
824     p_profile_rec.registration_type               :=  pr_registration_type              ;
825     p_profile_rec.application_receipt_date        :=  pr_application_receipt_date       ;
826     p_profile_rec.application_type                :=  pr_application_type               ;
827     p_profile_rec.original_fnar_compute           :=  pr_original_fnar_compute          ;
828     p_profile_rec.revision_fnar_compute_date      :=  pr_revision_fnar_compute_date     ;
829     p_profile_rec.electronic_extract_date         :=  pr_electronic_extract_date        ;
830     p_profile_rec.institutional_reporting_type    :=  pr_inst_reporting_type            ;
831     p_profile_rec.asr_receipt_date                :=  pr_asr_receipt_date               ;
832     p_profile_rec.last_name                       :=  pr_last_name                      ;
833     p_profile_rec.first_name                      :=  pr_first_name                     ;
834     p_profile_rec.middle_initial                  :=  pr_middle_initial                 ;
835     p_profile_rec.address_number_and_street       :=  pr_address_number_and_street      ;
836     p_profile_rec.city                            :=  pr_city                           ;
837     p_profile_rec.state_mailing                   :=  pr_state_mailing                  ;
838     p_profile_rec.zip_code                        :=  pr_zip_code                       ;
839     p_profile_rec.s_telephone_number              :=  pr_s_telephone_number             ;
840     p_profile_rec.s_title                         :=  pr_s_title                        ;
841     p_profile_rec.date_of_birth                   :=  pr_date_of_birth                  ;
842     p_profile_rec.social_security_number          :=  pr_social_security_number         ;
843     p_profile_rec.state_legal_residence           :=  pr_state_legal_residence          ;
844     p_profile_rec.foreign_address_indicator       :=  pr_foreign_address_indicator      ;
845     p_profile_rec.foreign_postal_code             :=  pr_foreign_postal_code            ;
846     p_profile_rec.country                         :=  pr_country                        ;
847     p_profile_rec.financial_aid_status            :=  pr_financial_aid_status           ;
848     p_profile_rec.year_in_college                 :=  pr_year_in_college                ;
849     p_profile_rec.marital_status                  :=  pr_marital_status                 ;
850     p_profile_rec.ward_court                      :=  pr_ward_court                     ;
854     p_profile_rec.citizenship_status              :=  pr_citizenship_status             ;
851     p_profile_rec.legal_dependents_other          :=  pr_legal_dependents_other         ;
852     p_profile_rec.household_size                  :=  pr_household_size                 ;
853     p_profile_rec.number_in_college               :=  pr_number_in_college              ;
855     p_profile_rec.citizenship_country             :=  pr_citizenship_country            ;
856     p_profile_rec.visa_classification             :=  pr_visa_classification            ;
857     p_profile_rec.tax_figures                     :=  pr_tax_figures                    ;
858     p_profile_rec.number_exemptions               :=  pr_number_exemptions              ;
859     p_profile_rec.adjusted_gross_inc              :=  pr_adjusted_gross_inc             ;
860     p_profile_rec.us_tax_paid                     :=  pr_us_tax_paid                    ;
861     p_profile_rec.itemized_deductions             :=  pr_itemized_deductions            ;
862     p_profile_rec.stu_income_work                 :=  pr_stu_income_work                ;
863     p_profile_rec.spouse_income_work              :=  pr_spouse_income_work             ;
864     p_profile_rec.divid_int_inc                   :=  pr_divid_int_inc                  ;
865     p_profile_rec.soc_sec_benefits                :=  pr_soc_sec_benefits               ;
866     p_profile_rec.welfare_tanf                    :=  pr_welfare_tanf                   ;
867     p_profile_rec.child_supp_rcvd                 :=  pr_child_supp_rcvd                ;
868     p_profile_rec.earned_income_credit            :=  pr_earned_income_credit           ;
869     p_profile_rec.other_untax_income              :=  pr_other_untax_income             ;
870     p_profile_rec.tax_stu_aid                     :=  pr_tax_stu_aid                    ;
871     p_profile_rec.cash_sav_check                  :=  pr_cash_sav_check                 ;
872     p_profile_rec.ira_keogh                       :=  pr_ira_keogh                      ;
873     p_profile_rec.invest_value                    :=  pr_invest_value                   ;
874     p_profile_rec.invest_debt                     :=  pr_invest_debt                    ;
875     p_profile_rec.home_value                      :=  pr_home_value                     ;
876     p_profile_rec.home_debt                       :=  pr_home_debt                      ;
877     p_profile_rec.oth_real_value                  :=  pr_oth_real_value                 ;
878     p_profile_rec.oth_real_debt                   :=  pr_oth_real_debt                  ;
879     p_profile_rec.bus_farm_value                  :=  pr_bus_farm_value                 ;
880     p_profile_rec.bus_farm_debt                   :=  pr_bus_farm_debt                  ;
881     p_profile_rec.live_on_farm                    :=  pr_live_on_farm                   ;
882     p_profile_rec.home_purch_price                :=  pr_home_purch_price               ;
883     p_profile_rec.hope_ll_credit                  :=  pr_hope_ll_credit                 ;
884     p_profile_rec.home_purch_year                 :=  pr_home_purch_year                ;
885     p_profile_rec.trust_amount                    :=  pr_trust_amount                   ;
886     p_profile_rec.trust_avail                     :=  pr_trust_avail                    ;
887     p_profile_rec.trust_estab                     :=  pr_trust_estab                    ;
888     p_profile_rec.child_support_paid              :=  pr_child_support_paid             ;
889     p_profile_rec.med_dent_expenses               :=  pr_med_dent_expenses              ;
890     p_profile_rec.vet_us                          :=  pr_vet_us                         ;
891     p_profile_rec.vet_ben_amount                  :=  pr_vet_ben_amount                 ;
892     p_profile_rec.vet_ben_months                  :=  pr_vet_ben_months                 ;
893     p_profile_rec.stu_summer_wages                :=  pr_stu_summer_wages               ;
894     p_profile_rec.stu_school_yr_wages             :=  pr_stu_school_yr_wages            ;
895     p_profile_rec.spouse_summer_wages             :=  pr_spouse_summer_wages            ;
896     p_profile_rec.spouse_school_yr_wages          :=  pr_spouse_school_yr_wages         ;
897     p_profile_rec.summer_other_tax_inc            :=  pr_summer_other_tax_inc           ;
898     p_profile_rec.school_yr_other_tax_inc         :=  pr_school_yr_other_tax_inc        ;
899     p_profile_rec.summer_untax_inc                :=  pr_summer_untax_inc               ;
900     p_profile_rec.school_yr_untax_inc             :=  pr_school_yr_untax_inc            ;
901     p_profile_rec.grants_schol_etc                :=  pr_grants_schol_etc               ;
902     p_profile_rec.tuit_benefits                   :=  pr_tuit_benefits                  ;
903     p_profile_rec.cont_parents                    :=  pr_cont_parents                   ;
904     p_profile_rec.cont_relatives                  :=  pr_cont_relatives                 ;
905     p_profile_rec.p_siblings_pre_tuit             :=  pr_p_siblings_pre_tuit            ;
906     p_profile_rec.p_student_pre_tuit              :=  pr_p_student_pre_tuit             ;
907     p_profile_rec.p_household_size                :=  pr_p_household_size               ;
908     p_profile_rec.p_number_in_college             :=  pr_p_number_in_college            ;
909     p_profile_rec.p_parents_in_college            :=  pr_p_parents_in_college           ;
910     p_profile_rec.p_marital_status                :=  pr_p_marital_status               ;
911     p_profile_rec.p_state_legal_residence         :=  pr_p_state_legal_residence        ;
912     p_profile_rec.p_natural_par_status            :=  pr_p_natural_par_status           ;
913     p_profile_rec.p_child_supp_paid               :=  pr_p_child_supp_paid              ;
914     p_profile_rec.p_repay_ed_loans                :=  pr_p_repay_ed_loans               ;
915     p_profile_rec.p_med_dent_expenses             :=  pr_p_med_dent_expenses            ;
916     p_profile_rec.p_tuit_paid_amount              :=  pr_p_tuit_paid_amount             ;
917     p_profile_rec.p_tuit_paid_number              :=  pr_p_tuit_paid_number             ;
918     p_profile_rec.p_exp_child_supp_paid           :=  pr_p_exp_child_supp_paid          ;
919     p_profile_rec.p_exp_repay_ed_loans            :=  pr_p_exp_repay_ed_loans           ;
923     p_profile_rec.p_cash_sav_check                :=  pr_p_cash_sav_check               ;
920     p_profile_rec.p_exp_med_dent_expenses         :=  pr_p_exp_med_dent_expenses        ;
921     p_profile_rec.p_exp_tuit_pd_amount            :=  pr_p_exp_tuit_pd_amount           ;
922     p_profile_rec.p_exp_tuit_pd_number            :=  pr_p_exp_tuit_pd_number           ;
924     p_profile_rec.p_month_mortgage_pay            :=  pr_p_month_mortgage_pay           ;
925     p_profile_rec.p_invest_value                  :=  pr_p_invest_value                 ;
926     p_profile_rec.p_invest_debt                   :=  pr_p_invest_debt                  ;
927     p_profile_rec.p_home_value                    :=  pr_p_home_value                   ;
928     p_profile_rec.p_home_debt                     :=  pr_p_home_debt                    ;
929     p_profile_rec.p_home_purch_price              :=  pr_p_home_purch_price             ;
930     p_profile_rec.p_own_business_farm             :=  pr_p_own_business_farm            ;
931     p_profile_rec.p_business_value                :=  pr_p_business_value               ;
932     p_profile_rec.p_business_debt                 :=  pr_p_business_debt                ;
933     p_profile_rec.p_farm_value                    :=  pr_p_farm_value                   ;
934     p_profile_rec.p_farm_debt                     :=  pr_p_farm_debt                    ;
935     p_profile_rec.p_live_on_farm                  :=  pr_p_live_on_farm                 ;
936     p_profile_rec.p_oth_real_estate_value         :=  pr_p_oth_real_estate_value        ;
937     p_profile_rec.p_oth_real_estate_debt          :=  pr_p_oth_real_estate_debt         ;
938     p_profile_rec.p_oth_real_purch_price          :=  pr_p_oth_real_purch_price         ;
939     p_profile_rec.p_siblings_assets               :=  pr_p_siblings_assets              ;
940     p_profile_rec.p_home_purch_year               :=  pr_p_home_purch_year              ;
941     p_profile_rec.p_oth_real_purch_year           :=  pr_p_oth_real_purch_year          ;
942     p_profile_rec.p_prior_agi                     :=  pr_p_prior_agi                    ;
943     p_profile_rec.p_prior_us_tax_paid             :=  pr_p_prior_us_tax_paid            ;
944     p_profile_rec.p_prior_item_deductions         :=  pr_p_prior_item_deductions        ;
945     p_profile_rec.p_prior_other_untax_inc         :=  pr_p_prior_other_untax_inc        ;
946     p_profile_rec.p_tax_figures                   :=  pr_p_tax_figures                  ;
947     p_profile_rec.p_number_exemptions             :=  pr_p_number_exemptions            ;
948     p_profile_rec.p_adjusted_gross_inc            :=  pr_p_adjusted_gross_inc           ;
949     p_profile_rec.p_wages_sal_tips                :=  pr_p_wages_sal_tips               ;
950     p_profile_rec.p_interest_income               :=  pr_p_interest_income              ;
951     p_profile_rec.p_dividend_income               :=  pr_p_dividend_income              ;
952     p_profile_rec.p_net_inc_bus_farm              :=  pr_p_net_inc_bus_farm             ;
953     p_profile_rec.p_other_taxable_income          :=  pr_p_other_taxable_income         ;
954     p_profile_rec.p_adj_to_income                 :=  pr_p_adj_to_income                ;
955     p_profile_rec.p_us_tax_paid                   :=  pr_p_us_tax_paid                  ;
956     p_profile_rec.p_itemized_deductions           :=  pr_p_itemized_deductions          ;
957     p_profile_rec.p_father_income_work            :=  pr_p_father_income_work           ;
958     p_profile_rec.p_mother_income_work            :=  pr_p_mother_income_work           ;
959     p_profile_rec.p_soc_sec_ben                   :=  pr_p_soc_sec_ben                  ;
960     p_profile_rec.p_welfare_tanf                  :=  pr_p_welfare_tanf                 ;
961     p_profile_rec.p_child_supp_rcvd               :=  pr_p_child_supp_rcvd              ;
962     p_profile_rec.p_ded_ira_keogh                 :=  pr_p_ded_ira_keogh                ;
963     p_profile_rec.p_tax_defer_pens_savs           :=  pr_p_tax_defer_pens_savs          ;
964     p_profile_rec.p_dep_care_med_spending         :=  pr_p_dep_care_med_spending        ;
965     p_profile_rec.p_earned_income_credit          :=  pr_p_earned_income_credit         ;
966     p_profile_rec.p_living_allow                  :=  pr_p_living_allow                 ;
967     p_profile_rec.p_tax_exmpt_int                 :=  pr_p_tax_exmpt_int                ;
968     p_profile_rec.p_foreign_inc_excl              :=  pr_p_foreign_inc_excl             ;
969     p_profile_rec.p_other_untax_inc               :=  pr_p_other_untax_inc              ;
970     p_profile_rec.p_hope_ll_credit                :=  pr_p_hope_ll_credit               ;
971     p_profile_rec.p_yr_separation                 :=  pr_p_yr_separation                ;
972     p_profile_rec.p_yr_divorce                    :=  pr_p_yr_divorce                   ;
973     p_profile_rec.p_exp_father_inc                :=  pr_p_exp_father_inc               ;
974     p_profile_rec.p_exp_mother_inc                :=  pr_p_exp_mother_inc               ;
975     p_profile_rec.p_exp_other_tax_inc             :=  pr_p_exp_other_tax_inc            ;
976     p_profile_rec.p_exp_other_untax_inc           :=  pr_p_exp_other_untax_inc          ;
977     p_profile_rec.line_2_relation                 :=  pr_line_2_relation                ;
978     p_profile_rec.line_2_attend_college           :=  pr_line_2_attend_college          ;
979     p_profile_rec.line_3_relation                 :=  pr_line_3_relation                ;
980     p_profile_rec.line_3_attend_college           :=  pr_line_3_attend_college          ;
981     p_profile_rec.line_4_relation                 :=  pr_line_4_relation                ;
982     p_profile_rec.line_4_attend_college           :=  pr_line_4_attend_college          ;
983     p_profile_rec.line_5_relation                 :=  pr_line_5_relation                ;
984     p_profile_rec.line_5_attend_college           :=  pr_line_5_attend_college          ;
985     p_profile_rec.line_6_relation                 :=  pr_line_6_relation                ;
986     p_profile_rec.line_6_attend_college           :=  pr_line_6_attend_college          ;
987     p_profile_rec.line_7_relation                 :=  pr_line_7_relation                ;
988     p_profile_rec.line_7_attend_college           :=  pr_line_7_attend_college          ;
992     p_profile_rec.p_age_mother                    :=  pr_p_age_mother                   ;
989     p_profile_rec.line_8_relation                 :=  pr_line_8_relation                ;
990     p_profile_rec.line_8_attend_college           :=  pr_line_8_attend_college          ;
991     p_profile_rec.p_age_father                    :=  pr_p_age_father                   ;
993     p_profile_rec.p_div_sep_ind                   :=  pr_p_div_sep_ind                  ;
994     p_profile_rec.b_cont_non_custodial_par        :=  pr_b_cont_non_custodial_par       ;
995     p_profile_rec.college_type_2                  :=  pr_college_type_2                 ;
996     p_profile_rec.college_type_3                  :=  pr_college_type_3                 ;
997     p_profile_rec.college_type_4                  :=  pr_college_type_4                 ;
998     p_profile_rec.college_type_5                  :=  pr_college_type_5                 ;
999     p_profile_rec.college_type_6                  :=  pr_college_type_6                 ;
1000     p_profile_rec.college_type_7                  :=  pr_college_type_7                 ;
1001     p_profile_rec.college_type_8                  :=  pr_college_type_8                 ;
1002     p_profile_rec.school_code_1                   :=  pr_school_code_1                  ;
1003     p_profile_rec.housing_code_1                  :=  pr_housing_code_1                 ;
1004     p_profile_rec.school_code_2                   :=  pr_school_code_2                  ;
1005     p_profile_rec.housing_code_2                  :=  pr_housing_code_2                 ;
1006     p_profile_rec.school_code_3                   :=  pr_school_code_3                  ;
1007     p_profile_rec.housing_code_3                  :=  pr_housing_code_3                 ;
1008     p_profile_rec.school_code_4                   :=  pr_school_code_4                  ;
1009     p_profile_rec.housing_code_4                  :=  pr_housing_code_4                 ;
1010     p_profile_rec.school_code_5                   :=  pr_school_code_5                  ;
1011     p_profile_rec.housing_code_5                  :=  pr_housing_code_5                 ;
1012     p_profile_rec.school_code_6                   :=  pr_school_code_6                  ;
1013     p_profile_rec.housing_code_6                  :=  pr_housing_code_6                 ;
1014     p_profile_rec.school_code_7                   :=  pr_school_code_7                  ;
1015     p_profile_rec.housing_code_7                  :=  pr_housing_code_7                 ;
1016     p_profile_rec.school_code_8                   :=  pr_school_code_8                  ;
1017     p_profile_rec.housing_code_8                  :=  pr_housing_code_8                 ;
1018     p_profile_rec.school_code_9                   :=  pr_school_code_9                  ;
1019     p_profile_rec.housing_code_9                  :=  pr_housing_code_9                 ;
1020     p_profile_rec.school_code_10                  :=  pr_school_code_10                 ;
1021     p_profile_rec.housing_code_10                 :=  pr_housing_code_10                ;
1022     p_profile_rec.additional_school_code_1        :=  pr_additional_school_code_1       ;
1023     p_profile_rec.additional_school_code_2        :=  pr_additional_school_code_2       ;
1024     p_profile_rec.additional_school_code_3        :=  pr_additional_school_code_3       ;
1025     p_profile_rec.additional_school_code_4        :=  pr_additional_school_code_4       ;
1026     p_profile_rec.additional_school_code_5        :=  pr_additional_school_code_5       ;
1027     p_profile_rec.additional_school_code_6        :=  pr_additional_school_code_6       ;
1028     p_profile_rec.additional_school_code_7        :=  pr_additional_school_code_7       ;
1029     p_profile_rec.additional_school_code_8        :=  pr_additional_school_code_8       ;
1030     p_profile_rec.additional_school_code_9        :=  pr_additional_school_code_9       ;
1031     p_profile_rec.additional_school_code_10       :=  pr_additional_school_code_10      ;
1032     p_profile_rec.explanation_spec_circum         :=  pr_explanation_spec_circum        ;
1033     p_profile_rec.signature_student               :=  pr_signature_student              ;
1034     p_profile_rec.signature_spouse                :=  pr_signature_spouse               ;
1035     p_profile_rec.signature_father                :=  pr_signature_father               ;
1036     p_profile_rec.signature_mother                :=  pr_signature_mother               ;
1037     p_profile_rec.month_day_completed             :=  pr_month_day_completed            ;
1038     p_profile_rec.year_completed                  :=  pr_year_completed                 ;
1039     p_profile_rec.age_line_2                      :=  pr_age_line_2                     ;
1040     p_profile_rec.age_line_3                      :=  pr_age_line_3                     ;
1041     p_profile_rec.age_line_4                      :=  pr_age_line_4                     ;
1042     p_profile_rec.age_line_5                      :=  pr_age_line_5                     ;
1043     p_profile_rec.age_line_6                      :=  pr_age_line_6                     ;
1044     p_profile_rec.age_line_7                      :=  pr_age_line_7                     ;
1045     p_profile_rec.age_line_8                      :=  pr_age_line_8                     ;
1046     p_profile_rec.a_online_signature              :=  pr_a_online_signature             ;
1047     p_profile_rec.question_1_number               :=  pr_question_1_number              ;
1048     p_profile_rec.question_1_size                 :=  pr_question_1_size                ;
1049     p_profile_rec.question_1_answer               :=  pr_question_1_answer              ;
1050     p_profile_rec.question_2_number               :=  pr_question_2_number              ;
1051     p_profile_rec.question_2_size                 :=  pr_question_2_size                ;
1052     p_profile_rec.question_2_answer               :=  pr_question_2_answer              ;
1053     p_profile_rec.question_3_number               :=  pr_question_3_number              ;
1054     p_profile_rec.question_3_size                 :=  pr_question_3_size                ;
1055     p_profile_rec.question_3_answer               :=  pr_question_3_answer              ;
1056     p_profile_rec.question_4_number               :=  pr_question_4_number              ;
1057     p_profile_rec.question_4_size                 :=  pr_question_4_size                ;
1061     p_profile_rec.question_5_answer               :=  pr_question_5_answer              ;
1058     p_profile_rec.question_4_answer               :=  pr_question_4_answer              ;
1059     p_profile_rec.question_5_number               :=  pr_question_5_number              ;
1060     p_profile_rec.question_5_size                 :=  pr_question_5_size                ;
1062     p_profile_rec.question_6_number               :=  pr_question_6_number              ;
1063     p_profile_rec.question_6_size                 :=  pr_question_6_size                ;
1064     p_profile_rec.question_6_answer               :=  pr_question_6_answer              ;
1065     p_profile_rec.question_7_number               :=  pr_question_7_number              ;
1066     p_profile_rec.question_7_size                 :=  pr_question_7_size                ;
1067     p_profile_rec.question_7_answer               :=  pr_question_7_answer              ;
1068     p_profile_rec.question_8_number               :=  pr_question_8_number              ;
1069     p_profile_rec.question_8_size                 :=  pr_question_8_size                ;
1070     p_profile_rec.question_8_answer               :=  pr_question_8_answer              ;
1071     p_profile_rec.question_9_number               :=  pr_question_9_number              ;
1072     p_profile_rec.question_9_size                 :=  pr_question_9_size                ;
1073     p_profile_rec.question_9_answer               :=  pr_question_9_answer              ;
1074     p_profile_rec.question_10_number              :=  pr_question_10_number             ;
1075     p_profile_rec.question_10_size                :=  pr_question_10_size               ;
1076     p_profile_rec.question_10_answer              :=  pr_question_10_answer             ;
1077     p_profile_rec.question_11_number              :=  pr_question_11_number             ;
1078     p_profile_rec.question_11_size                :=  pr_question_11_size               ;
1079     p_profile_rec.question_11_answer              :=  pr_question_11_answer             ;
1080     p_profile_rec.question_12_number              :=  pr_question_12_number             ;
1081     p_profile_rec.question_12_size                :=  pr_question_12_size               ;
1082     p_profile_rec.question_12_answer              :=  pr_question_12_answer             ;
1083     p_profile_rec.question_13_number              :=  pr_question_13_number             ;
1084     p_profile_rec.question_13_size                :=  pr_question_13_size               ;
1085     p_profile_rec.question_13_answer              :=  pr_question_13_answer             ;
1086     p_profile_rec.question_14_number              :=  pr_question_14_number             ;
1087     p_profile_rec.question_14_size                :=  pr_question_14_size               ;
1088     p_profile_rec.question_14_answer              :=  pr_question_14_answer             ;
1089     p_profile_rec.question_15_number              :=  pr_question_15_number             ;
1090     p_profile_rec.question_15_size                :=  pr_question_15_size               ;
1091     p_profile_rec.question_15_answer              :=  pr_question_15_answer             ;
1092     p_profile_rec.question_16_number              :=  pr_question_16_number             ;
1093     p_profile_rec.question_16_size                :=  pr_question_16_size               ;
1094     p_profile_rec.question_16_answer              :=  pr_question_16_answer             ;
1095     p_profile_rec.question_17_number              :=  pr_question_17_number             ;
1096     p_profile_rec.question_17_size                :=  pr_question_17_size               ;
1097     p_profile_rec.question_17_answer              :=  pr_question_17_answer             ;
1098     p_profile_rec.question_18_number              :=  pr_question_18_number             ;
1099     p_profile_rec.question_18_size                :=  pr_question_18_size               ;
1100     p_profile_rec.question_18_answer              :=  pr_question_18_answer             ;
1101     p_profile_rec.question_19_number              :=  pr_question_19_number             ;
1102     p_profile_rec.question_19_size                :=  pr_question_19_size               ;
1103     p_profile_rec.question_19_answer              :=  pr_question_19_answer             ;
1104     p_profile_rec.question_20_number              :=  pr_question_20_number             ;
1105     p_profile_rec.question_20_size                :=  pr_question_20_size               ;
1106     p_profile_rec.question_20_answer              :=  pr_question_20_answer             ;
1107     p_profile_rec.question_21_number              :=  pr_question_21_number             ;
1108     p_profile_rec.question_21_size                :=  pr_question_21_size               ;
1109     p_profile_rec.question_21_answer              :=  pr_question_21_answer             ;
1110     p_profile_rec.question_22_number              :=  pr_question_22_number             ;
1111     p_profile_rec.question_22_size                :=  pr_question_22_size               ;
1112     p_profile_rec.question_22_answer              :=  pr_question_22_answer             ;
1113     p_profile_rec.question_23_number              :=  pr_question_23_number             ;
1114     p_profile_rec.question_23_size                :=  pr_question_23_size               ;
1115     p_profile_rec.question_23_answer              :=  pr_question_23_answer             ;
1116     p_profile_rec.question_24_number              :=  pr_question_24_number             ;
1117     p_profile_rec.question_24_size                :=  pr_question_24_size               ;
1118     p_profile_rec.question_24_answer              :=  pr_question_24_answer             ;
1119     p_profile_rec.question_25_number              :=  pr_question_25_number             ;
1120     p_profile_rec.question_25_size                :=  pr_question_25_size               ;
1121     p_profile_rec.question_25_answer              :=  pr_question_25_answer             ;
1122     p_profile_rec.question_26_number              :=  pr_question_26_number             ;
1123     p_profile_rec.question_26_size                :=  pr_question_26_size               ;
1127     p_profile_rec.question_27_answer              :=  pr_question_27_answer             ;
1124     p_profile_rec.question_26_answer              :=  pr_question_26_answer             ;
1125     p_profile_rec.question_27_number              :=  pr_question_27_number             ;
1126     p_profile_rec.question_27_size                :=  pr_question_27_size               ;
1128     p_profile_rec.question_28_number              :=  pr_question_28_number             ;
1129     p_profile_rec.question_28_size                :=  pr_question_28_size               ;
1130     p_profile_rec.question_28_answer              :=  pr_question_28_answer             ;
1131     p_profile_rec.question_29_number              :=  pr_question_29_number             ;
1132     p_profile_rec.question_29_size                :=  pr_question_29_size               ;
1133     p_profile_rec.question_29_answer              :=  pr_question_29_answer             ;
1134     p_profile_rec.question_30_number              :=  pr_question_30_number             ;
1135     p_profile_rec.questions_30_size               :=  pr_questions_30_size              ;
1136     p_profile_rec.question_30_answer              :=  pr_question_30_answer             ;
1137     p_profile_rec.legacy_record_flag              :=  pr_legacy_record_flag             ;
1138     p_profile_rec.coa_duration_efc_amt            :=  pr_coa_duration_efc_amt           ;
1139     p_profile_rec.coa_duration_num                :=  pr_coa_duration_num               ;
1140     p_profile_rec.created_by                      :=  pr_created_by                     ;
1141     p_profile_rec.creation_date                   :=  pr_creation_date                  ;
1142     p_profile_rec.last_updated_by                 :=  pr_last_updated_by                ;
1143     p_profile_rec.last_update_date                :=  pr_last_update_date               ;
1144     p_profile_rec.last_update_login               :=  pr_last_update_login              ;
1145     p_profile_rec.p_soc_sec_ben_student_amt       :=  pr_p_soc_sec_ben_student_amt      ;
1146     p_profile_rec.p_tuit_fee_deduct_amt           :=  pr_p_tuit_fee_deduct_amt          ;
1147     p_profile_rec.stu_lives_with_num              :=  pr_stu_lives_with_num             ;
1148     p_profile_rec.stu_most_support_from_num       :=  pr_stu_most_support_from_num      ;
1149     p_profile_rec.location_computer_num           :=  pr_location_computer_num          ;
1150 
1151     p_fnar_rec.fnar_id                            :=  f_fnar_id                        ;
1152     p_fnar_rec.cssp_id                            :=  f_cssp_id                        ;
1153     p_fnar_rec.r_s_email_address                  :=  f_r_s_email_address              ;
1154     p_fnar_rec.eps_code                           :=  f_eps_code                       ;
1155     p_fnar_rec.comp_css_dependency_status         :=  f_comp_css_dependency_status     ;
1156     p_fnar_rec.stu_age                            :=  f_stu_age                        ;
1157     p_fnar_rec.assumed_stu_yr_in_coll             :=  f_assumed_stu_yr_in_coll         ;
1158     p_fnar_rec.comp_stu_marital_status            :=  f_comp_stu_marital_status        ;
1159     p_fnar_rec.stu_family_members                 :=  f_stu_family_members             ;
1160     p_fnar_rec.stu_fam_members_in_college         :=  f_stu_fam_members_in_college     ;
1161     p_fnar_rec.par_marital_status                 :=  f_par_marital_status             ;
1162     p_fnar_rec.par_family_members                 :=  f_par_family_members             ;
1163     p_fnar_rec.par_total_in_college               :=  f_par_total_in_college           ;
1164     p_fnar_rec.par_par_in_college                 :=  f_par_par_in_college             ;
1165     p_fnar_rec.par_others_in_college              :=  f_par_others_in_college          ;
1166     p_fnar_rec.par_aesa                           :=  f_par_aesa                       ;
1167     p_fnar_rec.par_cesa                           :=  f_par_cesa                       ;
1168     p_fnar_rec.stu_aesa                           :=  f_stu_aesa                       ;
1169     p_fnar_rec.stu_cesa                           :=  f_stu_cesa                       ;
1170     p_fnar_rec.im_p_bas_agi_taxable_income        :=  f_im_p_bas_agi_taxable_income    ;
1171     p_fnar_rec.im_p_bas_untx_inc_and_ben          :=  f_im_p_bas_untx_inc_and_ben      ;
1172     p_fnar_rec.im_p_bas_inc_adj                   :=  f_im_p_bas_inc_adj               ;
1173     p_fnar_rec.im_p_bas_total_income              :=  f_im_p_bas_total_income          ;
1174     p_fnar_rec.im_p_bas_us_income_tax             :=  f_im_p_bas_us_income_tax         ;
1175     p_fnar_rec.im_p_bas_st_and_other_tax          :=  f_im_p_bas_st_and_other_tax      ;
1176     p_fnar_rec.im_p_bas_fica_tax                  :=  f_im_p_bas_fica_tax              ;
1177     p_fnar_rec.im_p_bas_med_dental                :=  f_im_p_bas_med_dental            ;
1178     p_fnar_rec.im_p_bas_employment_allow          :=  f_im_p_bas_employment_allow      ;
1179     p_fnar_rec.im_p_bas_annual_ed_savings         :=  f_im_p_bas_annual_ed_savings     ;
1180     p_fnar_rec.im_p_bas_inc_prot_allow_m          :=  f_im_p_bas_inc_prot_allow_m      ;
1181     p_fnar_rec.im_p_bas_total_inc_allow           :=  f_im_p_bas_total_inc_allow       ;
1182     p_fnar_rec.im_p_bas_cal_avail_inc             :=  f_im_p_bas_cal_avail_inc         ;
1183     p_fnar_rec.im_p_bas_avail_income              :=  f_im_p_bas_avail_income          ;
1184     p_fnar_rec.im_p_bas_total_cont_inc            :=  f_im_p_bas_total_cont_inc        ;
1185     p_fnar_rec.im_p_bas_cash_bank_accounts        :=  f_im_p_bas_cash_bank_accounts    ;
1186     p_fnar_rec.im_p_bas_home_equity               :=  f_im_p_bas_home_equity           ;
1187     p_fnar_rec.im_p_bas_ot_rl_est_inv_eq          :=  f_im_p_bas_ot_rl_est_inv_eq      ;
1188     p_fnar_rec.im_p_bas_adj_bus_farm_worth        :=  f_im_p_bas_adj_bus_farm_worth    ;
1189     p_fnar_rec.im_p_bas_ass_sibs_pre_tui          :=  f_im_p_bas_ass_sibs_pre_tui      ;
1190     p_fnar_rec.im_p_bas_net_worth                 :=  f_im_p_bas_net_worth             ;
1194     p_fnar_rec.im_p_bas_total_asset_allow         :=  f_im_p_bas_total_asset_allow     ;
1191     p_fnar_rec.im_p_bas_emerg_res_allow           :=  f_im_p_bas_emerg_res_allow       ;
1192     p_fnar_rec.im_p_bas_cum_ed_savings            :=  f_im_p_bas_cum_ed_savings        ;
1193     p_fnar_rec.im_p_bas_low_inc_allow             :=  f_im_p_bas_low_inc_allow         ;
1195     p_fnar_rec.im_p_bas_disc_net_worth            :=  f_im_p_bas_disc_net_worth        ;
1196     p_fnar_rec.im_p_bas_total_cont_asset          :=  f_im_p_bas_total_cont_asset      ;
1197     p_fnar_rec.im_p_bas_total_cont                :=  f_im_p_bas_total_cont            ;
1198     p_fnar_rec.im_p_bas_num_in_coll_adj           :=  f_im_p_bas_num_in_coll_adj       ;
1199     p_fnar_rec.im_p_bas_cont_for_stu              :=  f_im_p_bas_cont_for_stu          ;
1200     p_fnar_rec.im_p_bas_cont_from_income          :=  f_im_p_bas_cont_from_income      ;
1201     p_fnar_rec.im_p_bas_cont_from_assets          :=  f_im_p_bas_cont_from_assets      ;
1202     p_fnar_rec.im_p_opt_agi_taxable_income        :=  f_im_p_opt_agi_taxable_income    ;
1203     p_fnar_rec.im_p_opt_untx_inc_and_ben          :=  f_im_p_opt_untx_inc_and_ben      ;
1204     p_fnar_rec.im_p_opt_inc_adj                   :=  f_im_p_opt_inc_adj               ;
1205     p_fnar_rec.im_p_opt_total_income              :=  f_im_p_opt_total_income          ;
1206     p_fnar_rec.im_p_opt_us_income_tax             :=  f_im_p_opt_us_income_tax         ;
1207     p_fnar_rec.im_p_opt_st_and_other_tax          :=  f_im_p_opt_st_and_other_tax      ;
1208     p_fnar_rec.im_p_opt_fica_tax                  :=  f_im_p_opt_fica_tax              ;
1209     p_fnar_rec.im_p_opt_med_dental                :=  f_im_p_opt_med_dental            ;
1210     p_fnar_rec.im_p_opt_elem_sec_tuit             :=  f_im_p_opt_elem_sec_tuit         ;
1211     p_fnar_rec.im_p_opt_employment_allow          :=  f_im_p_opt_employment_allow      ;
1212     p_fnar_rec.im_p_opt_annual_ed_savings         :=  f_im_p_opt_annual_ed_savings     ;
1213     p_fnar_rec.im_p_opt_inc_prot_allow_m          :=  f_im_p_opt_inc_prot_allow_m      ;
1214     p_fnar_rec.im_p_opt_total_inc_allow           :=  f_im_p_opt_total_inc_allow       ;
1215     p_fnar_rec.im_p_opt_cal_avail_inc             :=  f_im_p_opt_cal_avail_inc         ;
1216     p_fnar_rec.im_p_opt_avail_income              :=  f_im_p_opt_avail_income          ;
1217     p_fnar_rec.im_p_opt_total_cont_inc            :=  f_im_p_opt_total_cont_inc        ;
1218     p_fnar_rec.im_p_opt_cash_bank_accounts        :=  f_im_p_opt_cash_bank_accounts    ;
1219     p_fnar_rec.im_p_opt_home_equity               :=  f_im_p_opt_home_equity           ;
1220     p_fnar_rec.im_p_opt_ot_rl_est_inv_eq          :=  f_im_p_opt_ot_rl_est_inv_eq      ;
1221     p_fnar_rec.im_p_opt_adj_bus_farm_worth        :=  f_im_p_opt_adj_bus_farm_worth    ;
1222     p_fnar_rec.im_p_opt_ass_sibs_pre_tui          :=  f_im_p_opt_ass_sibs_pre_tui      ;
1223     p_fnar_rec.im_p_opt_net_worth                 :=  f_im_p_opt_net_worth             ;
1224     p_fnar_rec.im_p_opt_emerg_res_allow           :=  f_im_p_opt_emerg_res_allow       ;
1225     p_fnar_rec.im_p_opt_cum_ed_savings            :=  f_im_p_opt_cum_ed_savings        ;
1226     p_fnar_rec.im_p_opt_low_inc_allow             :=  f_im_p_opt_low_inc_allow         ;
1227     p_fnar_rec.im_p_opt_total_asset_allow         :=  f_im_p_opt_total_asset_allow     ;
1228     p_fnar_rec.im_p_opt_disc_net_worth            :=  f_im_p_opt_disc_net_worth        ;
1229     p_fnar_rec.im_p_opt_total_cont_asset          :=  f_im_p_opt_total_cont_asset      ;
1230     p_fnar_rec.im_p_opt_total_cont                :=  f_im_p_opt_total_cont            ;
1231     p_fnar_rec.im_p_opt_num_in_coll_adj           :=  f_im_p_opt_num_in_coll_adj       ;
1232     p_fnar_rec.im_p_opt_cont_for_stu              :=  f_im_p_opt_cont_for_stu          ;
1233     p_fnar_rec.im_p_opt_cont_from_income          :=  f_im_p_opt_cont_from_income      ;
1234     p_fnar_rec.im_p_opt_cont_from_assets          :=  f_im_p_opt_cont_from_assets      ;
1235     p_fnar_rec.fm_p_analysis_type                 :=  f_fm_p_analysis_type             ;
1236     p_fnar_rec.fm_p_agi_taxable_income            :=  f_fm_p_agi_taxable_income        ;
1237     p_fnar_rec.fm_p_untx_inc_and_ben              :=  f_fm_p_untx_inc_and_ben          ;
1238     p_fnar_rec.fm_p_inc_adj                       :=  f_fm_p_inc_adj                   ;
1239     p_fnar_rec.fm_p_total_income                  :=  f_fm_p_total_income              ;
1240     p_fnar_rec.fm_p_us_income_tax                 :=  f_fm_p_us_income_tax             ;
1241     p_fnar_rec.fm_p_state_and_other_taxes         :=  f_fm_p_state_and_other_taxes     ;
1242     p_fnar_rec.fm_p_fica_tax                      :=  f_fm_p_fica_tax                  ;
1243     p_fnar_rec.fm_p_employment_allow              :=  f_fm_p_employment_allow          ;
1244     p_fnar_rec.fm_p_income_prot_allow             :=  f_fm_p_income_prot_allow         ;
1245     p_fnar_rec.fm_p_total_allow                   :=  f_fm_p_total_allow               ;
1246     p_fnar_rec.fm_p_avail_income                  :=  f_fm_p_avail_income              ;
1247     p_fnar_rec.fm_p_cash_bank_accounts            :=  f_fm_p_cash_bank_accounts        ;
1248     p_fnar_rec.fm_p_ot_rl_est_inv_equity          :=  f_fm_p_ot_rl_est_inv_equity      ;
1249     p_fnar_rec.fm_p_adj_bus_farm_net_worth        :=  f_fm_p_adj_bus_farm_net_worth    ;
1250     p_fnar_rec.fm_p_net_worth                     :=  f_fm_p_net_worth                 ;
1251     p_fnar_rec.fm_p_asset_prot_allow              :=  f_fm_p_asset_prot_allow          ;
1252     p_fnar_rec.fm_p_disc_net_worth                :=  f_fm_p_disc_net_worth            ;
1253     p_fnar_rec.fm_p_total_contribution            :=  f_fm_p_total_contribution        ;
1254     p_fnar_rec.fm_p_num_in_coll                   :=  f_fm_p_num_in_coll               ;
1255     p_fnar_rec.fm_p_cont_for_stu                  :=  f_fm_p_cont_for_stu              ;
1256     p_fnar_rec.fm_p_cont_from_income              :=  f_fm_p_cont_from_income          ;
1257     p_fnar_rec.fm_p_cont_from_assets              :=  f_fm_p_cont_from_assets          ;
1258     p_fnar_rec.im_s_bas_agi_taxable_income        :=  f_im_s_bas_agi_taxable_income    ;
1259     p_fnar_rec.im_s_bas_untx_inc_and_ben          :=  f_im_s_bas_untx_inc_and_ben      ;
1263     p_fnar_rec.im_s_bas_state_and_oth_taxes       :=  f_im_s_bas_state_and_oth_taxes   ;
1260     p_fnar_rec.im_s_bas_inc_adj                   :=  f_im_s_bas_inc_adj               ;
1261     p_fnar_rec.im_s_bas_total_income              :=  f_im_s_bas_total_income          ;
1262     p_fnar_rec.im_s_bas_us_income_tax             :=  f_im_s_bas_us_income_tax         ;
1264     p_fnar_rec.im_s_bas_fica_tax                  :=  f_im_s_bas_fica_tax              ;
1265     p_fnar_rec.im_s_bas_med_dental                :=  f_im_s_bas_med_dental            ;
1266     p_fnar_rec.im_s_bas_employment_allow          :=  f_im_s_bas_employment_allow      ;
1267     p_fnar_rec.im_s_bas_annual_ed_savings         :=  f_im_s_bas_annual_ed_savings     ;
1268     p_fnar_rec.im_s_bas_inc_prot_allow_m          :=  f_im_s_bas_inc_prot_allow_m      ;
1269     p_fnar_rec.im_s_bas_total_inc_allow           :=  f_im_s_bas_total_inc_allow       ;
1270     p_fnar_rec.im_s_bas_cal_avail_income          :=  f_im_s_bas_cal_avail_income      ;
1271     p_fnar_rec.im_s_bas_avail_income              :=  f_im_s_bas_avail_income          ;
1272     p_fnar_rec.im_s_bas_total_cont_inc            :=  f_im_s_bas_total_cont_inc        ;
1273     p_fnar_rec.im_s_bas_cash_bank_accounts        :=  f_im_s_bas_cash_bank_accounts    ;
1274     p_fnar_rec.im_s_bas_home_equity               :=  f_im_s_bas_home_equity           ;
1275     p_fnar_rec.im_s_bas_ot_rl_est_inv_eq          :=  f_im_s_bas_ot_rl_est_inv_eq      ;
1276     p_fnar_rec.im_s_bas_adj_busfarm_worth         :=  f_im_s_bas_adj_busfarm_worth     ;
1277     p_fnar_rec.im_s_bas_trusts                    :=  f_im_s_bas_trusts                ;
1278     p_fnar_rec.im_s_bas_net_worth                 :=  f_im_s_bas_net_worth             ;
1279     p_fnar_rec.im_s_bas_emerg_res_allow           :=  f_im_s_bas_emerg_res_allow       ;
1280     p_fnar_rec.im_s_bas_cum_ed_savings            :=  f_im_s_bas_cum_ed_savings        ;
1281     p_fnar_rec.im_s_bas_total_asset_allow         :=  f_im_s_bas_total_asset_allow     ;
1282     p_fnar_rec.im_s_bas_disc_net_worth            :=  f_im_s_bas_disc_net_worth        ;
1283     p_fnar_rec.im_s_bas_total_cont_asset          :=  f_im_s_bas_total_cont_asset      ;
1284     p_fnar_rec.im_s_bas_total_cont                :=  f_im_s_bas_total_cont            ;
1285     p_fnar_rec.im_s_bas_num_in_coll_adj           :=  f_im_s_bas_num_in_coll_adj       ;
1286     p_fnar_rec.im_s_bas_cont_for_stu              :=  f_im_s_bas_cont_for_stu          ;
1287     p_fnar_rec.im_s_bas_cont_from_income          :=  f_im_s_bas_cont_from_income      ;
1288     p_fnar_rec.im_s_bas_cont_from_assets          :=  f_im_s_bas_cont_from_assets      ;
1289     p_fnar_rec.im_s_est_agitaxable_income         :=  f_im_s_est_agitaxable_income     ;
1290     p_fnar_rec.im_s_est_untx_inc_and_ben          :=  f_im_s_est_untx_inc_and_ben      ;
1291     p_fnar_rec.im_s_est_inc_adj                   :=  f_im_s_est_inc_adj               ;
1292     p_fnar_rec.im_s_est_total_income              :=  f_im_s_est_total_income          ;
1293     p_fnar_rec.im_s_est_us_income_tax             :=  f_im_s_est_us_income_tax         ;
1294     p_fnar_rec.im_s_est_state_and_oth_taxes       :=  f_im_s_est_state_and_oth_taxes   ;
1295     p_fnar_rec.im_s_est_fica_tax                  :=  f_im_s_est_fica_tax              ;
1296     p_fnar_rec.im_s_est_med_dental                :=  f_im_s_est_med_dental            ;
1297     p_fnar_rec.im_s_est_employment_allow          :=  f_im_s_est_employment_allow      ;
1298     p_fnar_rec.im_s_est_annual_ed_savings         :=  f_im_s_est_annual_ed_savings     ;
1299     p_fnar_rec.im_s_est_inc_prot_allow_m          :=  f_im_s_est_inc_prot_allow_m      ;
1300     p_fnar_rec.im_s_est_total_inc_allow           :=  f_im_s_est_total_inc_allow       ;
1301     p_fnar_rec.im_s_est_cal_avail_income          :=  f_im_s_est_cal_avail_income      ;
1302     p_fnar_rec.im_s_est_avail_income              :=  f_im_s_est_avail_income          ;
1303     p_fnar_rec.im_s_est_total_cont_inc            :=  f_im_s_est_total_cont_inc        ;
1304     p_fnar_rec.im_s_est_cash_bank_accounts        :=  f_im_s_est_cash_bank_accounts    ;
1305     p_fnar_rec.im_s_est_home_equity               :=  f_im_s_est_home_equity           ;
1306     p_fnar_rec.im_s_est_ot_rl_est_inv_eq          :=  f_im_s_est_ot_rl_est_inv_eq      ;
1307     p_fnar_rec.im_s_est_adj_bus_farm_worth        :=  f_im_s_est_adj_bus_farm_worth    ;
1308     p_fnar_rec.im_s_est_est_trusts                :=  f_im_s_est_est_trusts            ;
1309     p_fnar_rec.im_s_est_net_worth                 :=  f_im_s_est_net_worth             ;
1310     p_fnar_rec.im_s_est_emerg_res_allow           :=  f_im_s_est_emerg_res_allow       ;
1311     p_fnar_rec.im_s_est_cum_ed_savings            :=  f_im_s_est_cum_ed_savings        ;
1312     p_fnar_rec.im_s_est_total_asset_allow         :=  f_im_s_est_total_asset_allow     ;
1313     p_fnar_rec.im_s_est_disc_net_worth            :=  f_im_s_est_disc_net_worth        ;
1314     p_fnar_rec.im_s_est_total_cont_asset          :=  f_im_s_est_total_cont_asset      ;
1315     p_fnar_rec.im_s_est_total_cont                :=  f_im_s_est_total_cont            ;
1316     p_fnar_rec.im_s_est_num_in_coll_adj           :=  f_im_s_est_num_in_coll_adj       ;
1317     p_fnar_rec.im_s_est_cont_for_stu              :=  f_im_s_est_cont_for_stu          ;
1318     p_fnar_rec.im_s_est_cont_from_income          :=  f_im_s_est_cont_from_income      ;
1319     p_fnar_rec.im_s_est_cont_from_assets          :=  f_im_s_est_cont_from_assets      ;
1320     p_fnar_rec.im_s_opt_agi_taxable_income        :=  f_im_s_opt_agi_taxable_income    ;
1321     p_fnar_rec.im_s_opt_untx_inc_and_ben          :=  f_im_s_opt_untx_inc_and_ben      ;
1322     p_fnar_rec.im_s_opt_inc_adj                   :=  f_im_s_opt_inc_adj               ;
1323     p_fnar_rec.im_s_opt_total_income              :=  f_im_s_opt_total_income          ;
1324     p_fnar_rec.im_s_opt_us_income_tax             :=  f_im_s_opt_us_income_tax         ;
1325     p_fnar_rec.im_s_opt_state_and_oth_taxes       :=  f_im_s_opt_state_and_oth_taxes   ;
1326     p_fnar_rec.im_s_opt_fica_tax                  :=  f_im_s_opt_fica_tax              ;
1327     p_fnar_rec.im_s_opt_med_dental                :=  f_im_s_opt_med_dental            ;
1328     p_fnar_rec.im_s_opt_employment_allow          :=  f_im_s_opt_employment_allow      ;
1332     p_fnar_rec.im_s_opt_cal_avail_income          :=  f_im_s_opt_cal_avail_income      ;
1329     p_fnar_rec.im_s_opt_annual_ed_savings         :=  f_im_s_opt_annual_ed_savings     ;
1330     p_fnar_rec.im_s_opt_inc_prot_allow_m          :=  f_im_s_opt_inc_prot_allow_m      ;
1331     p_fnar_rec.im_s_opt_total_inc_allow           :=  f_im_s_opt_total_inc_allow       ;
1333     p_fnar_rec.im_s_opt_avail_income              :=  f_im_s_opt_avail_income          ;
1334     p_fnar_rec.im_s_opt_total_cont_inc            :=  f_im_s_opt_total_cont_inc        ;
1335     p_fnar_rec.im_s_opt_cash_bank_accounts        :=  f_im_s_opt_cash_bank_accounts    ;
1336     p_fnar_rec.im_s_opt_ira_keogh_accounts        :=  f_im_s_opt_ira_keogh_accounts    ;
1337     p_fnar_rec.im_s_opt_home_equity               :=  f_im_s_opt_home_equity           ;
1338     p_fnar_rec.im_s_opt_ot_rl_est_inv_eq          :=  f_im_s_opt_ot_rl_est_inv_eq      ;
1339     p_fnar_rec.im_s_opt_adj_bus_farm_worth        :=  f_im_s_opt_adj_bus_farm_worth    ;
1340     p_fnar_rec.im_s_opt_trusts                    :=  f_im_s_opt_trusts                ;
1341     p_fnar_rec.im_s_opt_net_worth                 :=  f_im_s_opt_net_worth             ;
1342     p_fnar_rec.im_s_opt_emerg_res_allow           :=  f_im_s_opt_emerg_res_allow       ;
1343     p_fnar_rec.im_s_opt_cum_ed_savings            :=  f_im_s_opt_cum_ed_savings        ;
1344     p_fnar_rec.im_s_opt_total_asset_allow         :=  f_im_s_opt_total_asset_allow     ;
1345     p_fnar_rec.im_s_opt_disc_net_worth            :=  f_im_s_opt_disc_net_worth        ;
1346     p_fnar_rec.im_s_opt_total_cont_asset          :=  f_im_s_opt_total_cont_asset      ;
1347     p_fnar_rec.im_s_opt_total_cont                :=  f_im_s_opt_total_cont            ;
1348     p_fnar_rec.im_s_opt_num_in_coll_adj           :=  f_im_s_opt_num_in_coll_adj       ;
1349     p_fnar_rec.im_s_opt_cont_for_stu              :=  f_im_s_opt_cont_for_stu          ;
1350     p_fnar_rec.im_s_opt_cont_from_income          :=  f_im_s_opt_cont_from_income      ;
1351     p_fnar_rec.im_s_opt_cont_from_assets          :=  f_im_s_opt_cont_from_assets      ;
1352     p_fnar_rec.fm_s_analysis_type                 :=  f_fm_s_analysis_type             ;
1353     p_fnar_rec.fm_s_agi_taxable_income            :=  f_fm_s_agi_taxable_income        ;
1354     p_fnar_rec.fm_s_untx_inc_and_ben              :=  f_fm_s_untx_inc_and_ben          ;
1355     p_fnar_rec.fm_s_inc_adj                       :=  f_fm_s_inc_adj                   ;
1356     p_fnar_rec.fm_s_total_income                  :=  f_fm_s_total_income              ;
1357     p_fnar_rec.fm_s_us_income_tax                 :=  f_fm_s_us_income_tax             ;
1358     p_fnar_rec.fm_s_state_and_oth_taxes           :=  f_fm_s_state_and_oth_taxes       ;
1359     p_fnar_rec.fm_s_fica_tax                      :=  f_fm_s_fica_tax                  ;
1360     p_fnar_rec.fm_s_employment_allow              :=  f_fm_s_employment_allow          ;
1361     p_fnar_rec.fm_s_income_prot_allow             :=  f_fm_s_income_prot_allow         ;
1362     p_fnar_rec.fm_s_total_allow                   :=  f_fm_s_total_allow               ;
1363     p_fnar_rec.fm_s_cal_avail_income              :=  f_fm_s_cal_avail_income          ;
1364     p_fnar_rec.fm_s_avail_income                  :=  f_fm_s_avail_income              ;
1365     p_fnar_rec.fm_s_cash_bank_accounts            :=  f_fm_s_cash_bank_accounts        ;
1366     p_fnar_rec.fm_s_ot_rl_est_inv_equity          :=  f_fm_s_ot_rl_est_inv_equity      ;
1367     p_fnar_rec.fm_s_adj_bus_farm_worth            :=  f_fm_s_adj_bus_farm_worth        ;
1368     p_fnar_rec.fm_s_trusts                        :=  f_fm_s_trusts                    ;
1369     p_fnar_rec.fm_s_net_worth                     :=  f_fm_s_net_worth                 ;
1370     p_fnar_rec.fm_s_asset_prot_allow              :=  f_fm_s_asset_prot_allow          ;
1371     p_fnar_rec.fm_s_disc_net_worth                :=  f_fm_s_disc_net_worth            ;
1372     p_fnar_rec.fm_s_total_cont                    :=  f_fm_s_total_cont                ;
1373     p_fnar_rec.fm_s_num_in_coll                   :=  f_fm_s_num_in_coll               ;
1374     p_fnar_rec.fm_s_cont_for_stu                  :=  f_fm_s_cont_for_stu              ;
1375     p_fnar_rec.fm_s_cont_from_income              :=  f_fm_s_cont_from_income          ;
1376     p_fnar_rec.fm_s_cont_from_assets              :=  f_fm_s_cont_from_assets          ;
1377     p_fnar_rec.im_inst_resident_ind               :=  f_im_inst_resident_ind           ;
1378     p_fnar_rec.institutional_1_budget_name        :=  f_institutional_1_budget_name    ;
1379     p_fnar_rec.im_inst_1_budget_duration          :=  f_im_inst_1_budget_duration      ;
1380     p_fnar_rec.im_inst_1_tuition_fees             :=  f_im_inst_1_tuition_fees         ;
1381     p_fnar_rec.im_inst_1_books_supplies           :=  f_im_inst_1_books_supplies       ;
1382     p_fnar_rec.im_inst_1_living_expenses          :=  f_im_inst_1_living_expenses      ;
1383     p_fnar_rec.im_inst_1_tot_expenses             :=  f_im_inst_1_tot_expenses         ;
1384     p_fnar_rec.im_inst_1_tot_stu_cont             :=  f_im_inst_1_tot_stu_cont         ;
1385     p_fnar_rec.im_inst_1_tot_par_cont             :=  f_im_inst_1_tot_par_cont         ;
1386     p_fnar_rec.im_inst_1_tot_family_cont          :=  f_im_inst_1_tot_family_cont      ;
1387     p_fnar_rec.im_inst_1_va_benefits              :=  f_im_inst_1_va_benefits          ;
1388     p_fnar_rec.im_inst_1_ot_cont                  :=  f_im_inst_1_ot_cont              ;
1389     p_fnar_rec.im_inst_1_est_financial_need       :=  f_im_inst_1_est_financial_need   ;
1390     p_fnar_rec.institutional_2_budget_name        :=  f_institutional_2_budget_name    ;
1391     p_fnar_rec.im_inst_2_budget_duration          :=  f_im_inst_2_budget_duration      ;
1392     p_fnar_rec.im_inst_2_tuition_fees             :=  f_im_inst_2_tuition_fees         ;
1393     p_fnar_rec.im_inst_2_books_supplies           :=  f_im_inst_2_books_supplies       ;
1394     p_fnar_rec.im_inst_2_living_expenses          :=  f_im_inst_2_living_expenses      ;
1395     p_fnar_rec.im_inst_2_tot_expenses             :=  f_im_inst_2_tot_expenses         ;
1396     p_fnar_rec.im_inst_2_tot_stu_cont             :=  f_im_inst_2_tot_stu_cont         ;
1397     p_fnar_rec.im_inst_2_tot_par_cont             :=  f_im_inst_2_tot_par_cont         ;
1401     p_fnar_rec.institutional_3_budget_name        :=  f_institutional_3_budget_name    ;
1398     p_fnar_rec.im_inst_2_tot_family_cont          :=  f_im_inst_2_tot_family_cont      ;
1399     p_fnar_rec.im_inst_2_va_benefits              :=  f_im_inst_2_va_benefits          ;
1400     p_fnar_rec.im_inst_2_est_financial_need       :=  f_im_inst_2_est_financial_need   ;
1402     p_fnar_rec.im_inst_3_budget_duration          :=  f_im_inst_3_budget_duration      ;
1403     p_fnar_rec.im_inst_3_tuition_fees             :=  f_im_inst_3_tuition_fees         ;
1404     p_fnar_rec.im_inst_3_books_supplies           :=  f_im_inst_3_books_supplies       ;
1405     p_fnar_rec.im_inst_3_living_expenses          :=  f_im_inst_3_living_expenses      ;
1406     p_fnar_rec.im_inst_3_tot_expenses             :=  f_im_inst_3_tot_expenses         ;
1407     p_fnar_rec.im_inst_3_tot_stu_cont             :=  f_im_inst_3_tot_stu_cont         ;
1408     p_fnar_rec.im_inst_3_tot_par_cont             :=  f_im_inst_3_tot_par_cont         ;
1409     p_fnar_rec.im_inst_3_tot_family_cont          :=  f_im_inst_3_tot_family_cont      ;
1410     p_fnar_rec.im_inst_3_va_benefits              :=  f_im_inst_3_va_benefits          ;
1411     p_fnar_rec.im_inst_3_est_financial_need       :=  f_im_inst_3_est_financial_need   ;
1412     p_fnar_rec.fm_inst_1_federal_efc              :=  f_fm_inst_1_federal_efc          ;
1413     p_fnar_rec.fm_inst_1_va_benefits              :=  f_fm_inst_1_va_benefits          ;
1414     p_fnar_rec.fm_inst_1_fed_eligibility          :=  f_fm_inst_1_fed_eligibility      ;
1415     p_fnar_rec.fm_inst_1_pell                     :=  f_fm_inst_1_pell                 ;
1416     p_fnar_rec.option_par_loss_allow_ind          :=  f_option_par_loss_allow_ind      ;
1417     p_fnar_rec.option_par_tuition_ind             :=  f_option_par_tuition_ind         ;
1418     p_fnar_rec.option_par_home_ind                :=  f_option_par_home_ind            ;
1419     p_fnar_rec.option_par_home_value              :=  f_option_par_home_value          ;
1420     p_fnar_rec.option_par_home_debt               :=  f_option_par_home_debt           ;
1421     p_fnar_rec.option_stu_ira_keogh_ind           :=  f_option_stu_ira_keogh_ind       ;
1422     p_fnar_rec.option_stu_home_ind                :=  f_option_stu_home_ind            ;
1423     p_fnar_rec.option_stu_home_value              :=  f_option_stu_home_value          ;
1424     p_fnar_rec.option_stu_home_debt               :=  f_option_stu_home_debt           ;
1425     p_fnar_rec.option_stu_sum_ay_inc_ind          :=  f_option_stu_sum_ay_inc_ind      ;
1426     p_fnar_rec.option_par_hope_ll_credit          :=  f_option_par_hope_ll_credit      ;
1427     p_fnar_rec.option_stu_hope_ll_credit          :=  f_option_stu_hope_ll_credit      ;
1428     p_fnar_rec.option_par_cola_adj_ind            :=  f_option_par_cola_adj_ind        ;
1429     p_fnar_rec.option_par_stu_fa_assets_ind       :=  f_option_par_stu_fa_assets_ind   ;
1430     p_fnar_rec.option_par_ipt_assets_ind          :=  f_option_par_ipt_assets_ind      ;
1431     p_fnar_rec.option_stu_ipt_assets_ind          :=  f_option_stu_ipt_assets_ind      ;
1432     p_fnar_rec.option_par_cola_adj_value          :=  f_option_par_cola_adj_value      ;
1433     p_fnar_rec.im_parent_1_8_months_bas           :=  f_im_parent_1_8_months_bas       ;
1434     p_fnar_rec.im_p_more_than_9_mth_ba            :=  f_im_p_more_than_9_mth_ba        ;
1435     p_fnar_rec.im_parent_1_8_months_opt           :=  f_im_parent_1_8_months_opt       ;
1436     p_fnar_rec.im_p_more_than_9_mth_op            :=  f_im_p_more_than_9_mth_op        ;
1437     p_fnar_rec.fnar_message_1                     :=  f_fnar_message_1                 ;
1438     p_fnar_rec.fnar_message_2                     :=  f_fnar_message_2                 ;
1439     p_fnar_rec.fnar_message_3                     :=  f_fnar_message_3                 ;
1440     p_fnar_rec.fnar_message_4                     :=  f_fnar_message_4                 ;
1441     p_fnar_rec.fnar_message_5                     :=  f_fnar_message_5                 ;
1442     p_fnar_rec.fnar_message_6                     :=  f_fnar_message_6                 ;
1443     p_fnar_rec.fnar_message_7                     :=  f_fnar_message_7                 ;
1444     p_fnar_rec.fnar_message_8                     :=  f_fnar_message_8                 ;
1445     p_fnar_rec.fnar_message_9                     :=  f_fnar_message_9                 ;
1446     p_fnar_rec.fnar_message_10                    :=  f_fnar_message_10                ;
1447     p_fnar_rec.fnar_message_11                    :=  f_fnar_message_11                ;
1448     p_fnar_rec.fnar_message_12                    :=  f_fnar_message_12                ;
1449     p_fnar_rec.fnar_message_13                    :=  f_fnar_message_13                ;
1450     p_fnar_rec.fnar_message_20                    :=  f_fnar_message_20                ;
1451     p_fnar_rec.fnar_message_21                    :=  f_fnar_message_21                ;
1452     p_fnar_rec.fnar_message_22                    :=  f_fnar_message_22                ;
1453     p_fnar_rec.fnar_message_23                    :=  f_fnar_message_23                ;
1454     p_fnar_rec.fnar_message_24                    :=  f_fnar_message_24                ;
1455     p_fnar_rec.fnar_message_25                    :=  f_fnar_message_25                ;
1456     p_fnar_rec.fnar_message_26                    :=  f_fnar_message_26                ;
1457     p_fnar_rec.fnar_message_27                    :=  f_fnar_message_27                ;
1458     p_fnar_rec.fnar_message_30                    :=  f_fnar_message_30                ;
1459     p_fnar_rec.fnar_message_31                    :=  f_fnar_message_31                ;
1460     p_fnar_rec.fnar_message_32                    :=  f_fnar_message_32                ;
1461     p_fnar_rec.fnar_message_33                    :=  f_fnar_message_33                ;
1462     p_fnar_rec.fnar_message_34                    :=  f_fnar_message_34                ;
1463     p_fnar_rec.fnar_message_35                    :=  f_fnar_message_35                ;
1467     p_fnar_rec.fnar_message_39                    :=  f_fnar_message_39                ;
1464     p_fnar_rec.fnar_message_36                    :=  f_fnar_message_36                ;
1465     p_fnar_rec.fnar_message_37                    :=  f_fnar_message_37                ;
1466     p_fnar_rec.fnar_message_38                    :=  f_fnar_message_38                ;
1468     p_fnar_rec.fnar_message_45                    :=  f_fnar_message_45                ;
1469     p_fnar_rec.fnar_message_46                    :=  f_fnar_message_46                ;
1470     p_fnar_rec.fnar_message_47                    :=  f_fnar_message_47                ;
1471     p_fnar_rec.fnar_message_48                    :=  f_fnar_message_48                ;
1472     p_fnar_rec.fnar_message_49                    :=  f_fnar_message_49                ;
1473     p_fnar_rec.fnar_message_50                    :=  f_fnar_message_50                ;
1474     p_fnar_rec.fnar_message_51                    :=  f_fnar_message_51                ;
1475     p_fnar_rec.fnar_message_52                    :=  f_fnar_message_52                ;
1476     p_fnar_rec.fnar_message_53                    :=  f_fnar_message_53                ;
1477     p_fnar_rec.fnar_message_55                    :=  f_fnar_message_55                ;
1478     p_fnar_rec.fnar_message_56                    :=  f_fnar_message_56                ;
1479     p_fnar_rec.fnar_message_57                    :=  f_fnar_message_57                ;
1480     p_fnar_rec.fnar_message_58                    :=  f_fnar_message_58                ;
1481     p_fnar_rec.fnar_message_59                    :=  f_fnar_message_59                ;
1482     p_fnar_rec.fnar_message_60                    :=  f_fnar_message_60                ;
1483     p_fnar_rec.fnar_message_61                    :=  f_fnar_message_61                ;
1484     p_fnar_rec.fnar_message_62                    :=  f_fnar_message_62                ;
1485     p_fnar_rec.fnar_message_63                    :=  f_fnar_message_63                ;
1486     p_fnar_rec.fnar_message_64                    :=  f_fnar_message_64                ;
1487     p_fnar_rec.fnar_message_65                    :=  f_fnar_message_65                ;
1488     p_fnar_rec.fnar_message_71                    :=  f_fnar_message_71                ;
1489     p_fnar_rec.fnar_message_72                    :=  f_fnar_message_72                ;
1490     p_fnar_rec.fnar_message_73                    :=  f_fnar_message_73                ;
1491     p_fnar_rec.fnar_message_74                    :=  f_fnar_message_74                ;
1492     p_fnar_rec.fnar_message_75                    :=  f_fnar_message_75                ;
1493     p_fnar_rec.fnar_message_76                    :=  f_fnar_message_76                ;
1494     p_fnar_rec.fnar_message_77                    :=  f_fnar_message_77                ;
1495     p_fnar_rec.fnar_message_78                    :=  f_fnar_message_78                ;
1496     p_fnar_rec.fnar_mesg_10_stu_fam_mem           :=  f_fnar_mesg_10_stu_fam_mem       ;
1497     p_fnar_rec.fnar_mesg_11_stu_no_in_coll        :=  f_fnar_mesg_11_stu_no_in_coll    ;
1498     p_fnar_rec.fnar_mesg_24_stu_avail_inc         :=  f_fnar_mesg_24_stu_avail_inc     ;
1499     p_fnar_rec.fnar_mesg_26_stu_taxes             :=  f_fnar_mesg_26_stu_taxes         ;
1500     p_fnar_rec.fnar_mesg_33_stu_home_value        :=  f_fnar_mesg_33_stu_home_value    ;
1501     p_fnar_rec.fnar_mesg_34_stu_home_value        :=  f_fnar_mesg_34_stu_home_value    ;
1502     p_fnar_rec.fnar_mesg_34_stu_home_equity       :=  f_fnar_mesg_34_stu_home_equity   ;
1503     p_fnar_rec.fnar_mesg_35_stu_home_value        :=  f_fnar_mesg_35_stu_home_value    ;
1504     p_fnar_rec.fnar_mesg_35_stu_home_equity       :=  f_fnar_mesg_35_stu_home_equity   ;
1505     p_fnar_rec.fnar_mesg_36_stu_home_equity       :=  f_fnar_mesg_36_stu_home_equity   ;
1506     p_fnar_rec.fnar_mesg_48_par_fam_mem           :=  f_fnar_mesg_48_par_fam_mem       ;
1507     p_fnar_rec.fnar_mesg_49_par_no_in_coll        :=  f_fnar_mesg_49_par_no_in_coll    ;
1508     p_fnar_rec.fnar_mesg_56_par_agi               :=  f_fnar_mesg_56_par_agi           ;
1509     p_fnar_rec.fnar_mesg_62_par_taxes             :=  f_fnar_mesg_62_par_taxes         ;
1510     p_fnar_rec.fnar_mesg_73_par_home_value        :=  f_fnar_mesg_73_par_home_value    ;
1511     p_fnar_rec.fnar_mesg_74_par_home_value        :=  f_fnar_mesg_74_par_home_value    ;
1512     p_fnar_rec.fnar_mesg_74_par_home_equity       :=  f_fnar_mesg_74_par_home_equity   ;
1513     p_fnar_rec.fnar_mesg_75_par_home_value        :=  f_fnar_mesg_75_par_home_value    ;
1514     p_fnar_rec.fnar_mesg_75_par_home_equity       :=  f_fnar_mesg_75_par_home_equity   ;
1515     p_fnar_rec.fnar_mesg_76_par_home_equity       :=  f_fnar_mesg_76_par_home_equity   ;
1516     p_fnar_rec.assumption_message_1               :=  f_assumption_message_1           ;
1517     p_fnar_rec.assumption_message_2               :=  f_assumption_message_2           ;
1518     p_fnar_rec.assumption_message_3               :=  f_assumption_message_3           ;
1519     p_fnar_rec.assumption_message_4               :=  f_assumption_message_4           ;
1520     p_fnar_rec.assumption_message_5               :=  f_assumption_message_5           ;
1521     p_fnar_rec.assumption_message_6               :=  f_assumption_message_6           ;
1522     p_fnar_rec.record_mark                        :=  f_record_mark                    ;
1523     p_fnar_rec.legacy_record_flag                 :=  f_legacy_record_flag             ;
1524     p_fnar_rec.creation_date                      :=  f_creation_date                  ;
1525     p_fnar_rec.created_by                         :=  f_created_by                     ;
1526     p_fnar_rec.last_updated_by                    :=  f_last_updated_by                ;
1527     p_fnar_rec.last_update_date                   :=  f_last_update_date               ;
1528     p_fnar_rec.last_update_login                  :=  f_last_update_login              ;
1529     p_fnar_rec.option_ind_stu_ipt_assets_flag     :=  f_opt_ind_stu_ipt_assets_flag    ;
1530     p_fnar_rec.cust_parent_cont_adj_num           :=  f_cust_parent_cont_adj_num       ;
1534     p_fnar_rec.cust_par_base_cont_ast_amt         :=  f_cust_par_base_cont_ast_amt     ;
1531     p_fnar_rec.custodial_parent_num               :=  f_custodial_parent_num           ;
1532     p_fnar_rec.cust_par_base_prcnt_inc_amt        :=  f_cust_par_base_prcnt_inc_amt    ;
1533     p_fnar_rec.cust_par_base_cont_inc_amt         :=  f_cust_par_base_cont_inc_amt     ;
1535     p_fnar_rec.cust_par_base_tot_cont_amt         :=  f_cust_par_base_tot_cont_amt     ;
1536     p_fnar_rec.cust_par_opt_prcnt_inc_amt         :=  f_cust_par_opt_prcnt_inc_amt     ;
1537     p_fnar_rec.cust_par_opt_cont_inc_amt          :=  f_cust_par_opt_cont_inc_amt      ;
1538     p_fnar_rec.cust_par_opt_cont_ast_amt          :=  f_cust_par_opt_cont_ast_amt      ;
1539     p_fnar_rec.cust_par_opt_tot_cont_amt          :=  f_cust_par_opt_tot_cont_amt      ;
1540     p_fnar_rec.parents_email_txt                  :=  f_parents_email_txt              ;
1541     p_fnar_rec.parent_1_birth_date                :=  f_parent_1_birth_date            ;
1542     p_fnar_rec.parent_2_birth_date                :=  f_parent_2_birth_date            ;
1543 
1544     p_user_hook := igf_ap_uhk_inas_pkg.get_im_efc(p_sys_awd_year, p_profile_rec, p_fnar_rec, p_err_mesg);
1545 
1546 
1547     pr_cssp_id                        :=  p_profile_rec.cssp_id                         ;
1548     pr_base_id                        :=  p_profile_rec.base_id                         ;
1549     pr_system_record_type             :=  p_profile_rec.system_record_type              ;
1550     pr_active_profile                 :=  p_profile_rec.active_profile                  ;
1551     pr_college_code                   :=  p_profile_rec.college_code                    ;
1552     pr_academic_year                  :=  p_profile_rec.academic_year                   ;
1553     pr_stu_record_type                :=  p_profile_rec.stu_record_type                 ;
1554     pr_css_id_number                  :=  p_profile_rec.css_id_number                   ;
1555     pr_registration_receipt_date      :=  p_profile_rec.registration_receipt_date       ;
1556     pr_registration_type              :=  p_profile_rec.registration_type               ;
1557     pr_application_receipt_date       :=  p_profile_rec.application_receipt_date        ;
1558     pr_application_type               :=  p_profile_rec.application_type                ;
1559     pr_original_fnar_compute          :=  p_profile_rec.original_fnar_compute           ;
1560     pr_revision_fnar_compute_date     :=  p_profile_rec.revision_fnar_compute_date      ;
1561     pr_electronic_extract_date        :=  p_profile_rec.electronic_extract_date         ;
1562     pr_inst_reporting_type            :=  p_profile_rec.institutional_reporting_type    ;
1563     pr_asr_receipt_date               :=  p_profile_rec.asr_receipt_date                ;
1564     pr_last_name                      :=  p_profile_rec.last_name                       ;
1565     pr_first_name                     :=  p_profile_rec.first_name                      ;
1566     pr_middle_initial                 :=  p_profile_rec.middle_initial                  ;
1567     pr_address_number_and_street      :=  p_profile_rec.address_number_and_street       ;
1568     pr_city                           :=  p_profile_rec.city                            ;
1569     pr_state_mailing                  :=  p_profile_rec.state_mailing                   ;
1570     pr_zip_code                       :=  p_profile_rec.zip_code                        ;
1571     pr_s_telephone_number             :=  p_profile_rec.s_telephone_number              ;
1572     pr_s_title                        :=  p_profile_rec.s_title                         ;
1573     pr_date_of_birth                  :=  p_profile_rec.date_of_birth                   ;
1574     pr_social_security_number         :=  p_profile_rec.social_security_number          ;
1575     pr_state_legal_residence          :=  p_profile_rec.state_legal_residence           ;
1576     pr_foreign_address_indicator      :=  p_profile_rec.foreign_address_indicator       ;
1577     pr_foreign_postal_code            :=  p_profile_rec.foreign_postal_code             ;
1578     pr_country                        :=  p_profile_rec.country                         ;
1579     pr_financial_aid_status           :=  p_profile_rec.financial_aid_status            ;
1580     pr_year_in_college                :=  p_profile_rec.year_in_college                 ;
1581     pr_marital_status                 :=  p_profile_rec.marital_status                  ;
1582     pr_ward_court                     :=  p_profile_rec.ward_court                      ;
1583     pr_legal_dependents_other         :=  p_profile_rec.legal_dependents_other          ;
1584     pr_household_size                 :=  p_profile_rec.household_size                  ;
1585     pr_number_in_college              :=  p_profile_rec.number_in_college               ;
1586     pr_citizenship_status             :=  p_profile_rec.citizenship_status              ;
1587     pr_citizenship_country            :=  p_profile_rec.citizenship_country             ;
1588     pr_visa_classification            :=  p_profile_rec.visa_classification             ;
1589     pr_tax_figures                    :=  p_profile_rec.tax_figures                     ;
1590     pr_number_exemptions              :=  p_profile_rec.number_exemptions               ;
1591     pr_adjusted_gross_inc             :=  p_profile_rec.adjusted_gross_inc              ;
1592     pr_us_tax_paid                    :=  p_profile_rec.us_tax_paid                     ;
1593     pr_itemized_deductions            :=  p_profile_rec.itemized_deductions             ;
1594     pr_stu_income_work                :=  p_profile_rec.stu_income_work                 ;
1595     pr_spouse_income_work             :=  p_profile_rec.spouse_income_work              ;
1596     pr_divid_int_inc                  :=  p_profile_rec.divid_int_inc                   ;
1597     pr_soc_sec_benefits               :=  p_profile_rec.soc_sec_benefits                ;
1598     pr_welfare_tanf                   :=  p_profile_rec.welfare_tanf                    ;
1599     pr_child_supp_rcvd                :=  p_profile_rec.child_supp_rcvd                 ;
1600     pr_earned_income_credit           :=  p_profile_rec.earned_income_credit            ;
1601     pr_other_untax_income             :=  p_profile_rec.other_untax_income              ;
1605     pr_invest_value                   :=  p_profile_rec.invest_value                    ;
1602     pr_tax_stu_aid                    :=  p_profile_rec.tax_stu_aid                     ;
1603     pr_cash_sav_check                 :=  p_profile_rec.cash_sav_check                  ;
1604     pr_ira_keogh                      :=  p_profile_rec.ira_keogh                       ;
1606     pr_invest_debt                    :=  p_profile_rec.invest_debt                     ;
1607     pr_home_value                     :=  p_profile_rec.home_value                      ;
1608     pr_home_debt                      :=  p_profile_rec.home_debt                       ;
1609     pr_oth_real_value                 :=  p_profile_rec.oth_real_value                  ;
1610     pr_oth_real_debt                  :=  p_profile_rec.oth_real_debt                   ;
1611     pr_bus_farm_value                 :=  p_profile_rec.bus_farm_value                  ;
1612     pr_bus_farm_debt                  :=  p_profile_rec.bus_farm_debt                   ;
1613     pr_live_on_farm                   :=  p_profile_rec.live_on_farm                    ;
1614     pr_home_purch_price               :=  p_profile_rec.home_purch_price                ;
1615     pr_hope_ll_credit                 :=  p_profile_rec.hope_ll_credit                  ;
1616     pr_home_purch_year                :=  p_profile_rec.home_purch_year                 ;
1617     pr_trust_amount                   :=  p_profile_rec.trust_amount                    ;
1618     pr_trust_avail                    :=  p_profile_rec.trust_avail                     ;
1619     pr_trust_estab                    :=  p_profile_rec.trust_estab                     ;
1620     pr_child_support_paid             :=  p_profile_rec.child_support_paid              ;
1621     pr_med_dent_expenses              :=  p_profile_rec.med_dent_expenses               ;
1622     pr_vet_us                         :=  p_profile_rec.vet_us                          ;
1623     pr_vet_ben_amount                 :=  p_profile_rec.vet_ben_amount                  ;
1624     pr_vet_ben_months                 :=  p_profile_rec.vet_ben_months                  ;
1625     pr_stu_summer_wages               :=  p_profile_rec.stu_summer_wages                ;
1626     pr_stu_school_yr_wages            :=  p_profile_rec.stu_school_yr_wages             ;
1627     pr_spouse_summer_wages            :=  p_profile_rec.spouse_summer_wages             ;
1628     pr_spouse_school_yr_wages         :=  p_profile_rec.spouse_school_yr_wages          ;
1629     pr_summer_other_tax_inc           :=  p_profile_rec.summer_other_tax_inc            ;
1630     pr_school_yr_other_tax_inc        :=  p_profile_rec.school_yr_other_tax_inc         ;
1631     pr_summer_untax_inc               :=  p_profile_rec.summer_untax_inc                ;
1632     pr_school_yr_untax_inc            :=  p_profile_rec.school_yr_untax_inc             ;
1633     pr_grants_schol_etc               :=  p_profile_rec.grants_schol_etc                ;
1634     pr_tuit_benefits                  :=  p_profile_rec.tuit_benefits                   ;
1635     pr_cont_parents                   :=  p_profile_rec.cont_parents                    ;
1636     pr_cont_relatives                 :=  p_profile_rec.cont_relatives                  ;
1637     pr_p_siblings_pre_tuit            :=  p_profile_rec.p_siblings_pre_tuit             ;
1638     pr_p_student_pre_tuit             :=  p_profile_rec.p_student_pre_tuit              ;
1639     pr_p_household_size               :=  p_profile_rec.p_household_size                ;
1640     pr_p_number_in_college            :=  p_profile_rec.p_number_in_college             ;
1641     pr_p_parents_in_college           :=  p_profile_rec.p_parents_in_college            ;
1642     pr_p_marital_status               :=  p_profile_rec.p_marital_status                ;
1643     pr_p_state_legal_residence        :=  p_profile_rec.p_state_legal_residence         ;
1644     pr_p_natural_par_status           :=  p_profile_rec.p_natural_par_status            ;
1645     pr_p_child_supp_paid              :=  p_profile_rec.p_child_supp_paid               ;
1646     pr_p_repay_ed_loans               :=  p_profile_rec.p_repay_ed_loans                ;
1647     pr_p_med_dent_expenses            :=  p_profile_rec.p_med_dent_expenses             ;
1648     pr_p_tuit_paid_amount             :=  p_profile_rec.p_tuit_paid_amount              ;
1649     pr_p_tuit_paid_number             :=  p_profile_rec.p_tuit_paid_number              ;
1650     pr_p_exp_child_supp_paid          :=  p_profile_rec.p_exp_child_supp_paid           ;
1651     pr_p_exp_repay_ed_loans           :=  p_profile_rec.p_exp_repay_ed_loans            ;
1652     pr_p_exp_med_dent_expenses        :=  p_profile_rec.p_exp_med_dent_expenses         ;
1653     pr_p_exp_tuit_pd_amount           :=  p_profile_rec.p_exp_tuit_pd_amount            ;
1654     pr_p_exp_tuit_pd_number           :=  p_profile_rec.p_exp_tuit_pd_number            ;
1655     pr_p_cash_sav_check               :=  p_profile_rec.p_cash_sav_check                ;
1656     pr_p_month_mortgage_pay           :=  p_profile_rec.p_month_mortgage_pay            ;
1657     pr_p_invest_value                 :=  p_profile_rec.p_invest_value                  ;
1658     pr_p_invest_debt                  :=  p_profile_rec.p_invest_debt                   ;
1659     pr_p_home_value                   :=  p_profile_rec.p_home_value                    ;
1660     pr_p_home_debt                    :=  p_profile_rec.p_home_debt                     ;
1661     pr_p_home_purch_price             :=  p_profile_rec.p_home_purch_price              ;
1662     pr_p_own_business_farm            :=  p_profile_rec.p_own_business_farm             ;
1663     pr_p_business_value               :=  p_profile_rec.p_business_value                ;
1664     pr_p_business_debt                :=  p_profile_rec.p_business_debt                 ;
1665     pr_p_farm_value                   :=  p_profile_rec.p_farm_value                    ;
1666     pr_p_farm_debt                    :=  p_profile_rec.p_farm_debt                     ;
1667     pr_p_live_on_farm                 :=  p_profile_rec.p_live_on_farm                  ;
1668     pr_p_oth_real_estate_value        :=  p_profile_rec.p_oth_real_estate_value         ;
1669     pr_p_oth_real_estate_debt         :=  p_profile_rec.p_oth_real_estate_debt          ;
1670     pr_p_oth_real_purch_price         :=  p_profile_rec.p_oth_real_purch_price          ;
1674     pr_p_prior_agi                    :=  p_profile_rec.p_prior_agi                     ;
1671     pr_p_siblings_assets              :=  p_profile_rec.p_siblings_assets               ;
1672     pr_p_home_purch_year              :=  p_profile_rec.p_home_purch_year               ;
1673     pr_p_oth_real_purch_year          :=  p_profile_rec.p_oth_real_purch_year           ;
1675     pr_p_prior_us_tax_paid            :=  p_profile_rec.p_prior_us_tax_paid             ;
1676     pr_p_prior_item_deductions        :=  p_profile_rec.p_prior_item_deductions         ;
1677     pr_p_prior_other_untax_inc        :=  p_profile_rec.p_prior_other_untax_inc         ;
1678     pr_p_tax_figures                  :=  p_profile_rec.p_tax_figures                   ;
1679     pr_p_number_exemptions            :=  p_profile_rec.p_number_exemptions             ;
1680     pr_p_adjusted_gross_inc           :=  p_profile_rec.p_adjusted_gross_inc            ;
1681     pr_p_wages_sal_tips               :=  p_profile_rec.p_wages_sal_tips                ;
1682     pr_p_interest_income              :=  p_profile_rec.p_interest_income               ;
1683     pr_p_dividend_income              :=  p_profile_rec.p_dividend_income               ;
1684     pr_p_net_inc_bus_farm             :=  p_profile_rec.p_net_inc_bus_farm              ;
1685     pr_p_other_taxable_income         :=  p_profile_rec.p_other_taxable_income          ;
1686     pr_p_adj_to_income                :=  p_profile_rec.p_adj_to_income                 ;
1687     pr_p_us_tax_paid                  :=  p_profile_rec.p_us_tax_paid                   ;
1688     pr_p_itemized_deductions          :=  p_profile_rec.p_itemized_deductions           ;
1689     pr_p_father_income_work           :=  p_profile_rec.p_father_income_work            ;
1690     pr_p_mother_income_work           :=  p_profile_rec.p_mother_income_work            ;
1691     pr_p_soc_sec_ben                  :=  p_profile_rec.p_soc_sec_ben                   ;
1692     pr_p_welfare_tanf                 :=  p_profile_rec.p_welfare_tanf                  ;
1693     pr_p_child_supp_rcvd              :=  p_profile_rec.p_child_supp_rcvd               ;
1694     pr_p_ded_ira_keogh                :=  p_profile_rec.p_ded_ira_keogh                 ;
1695     pr_p_tax_defer_pens_savs          :=  p_profile_rec.p_tax_defer_pens_savs           ;
1696     pr_p_dep_care_med_spending        :=  p_profile_rec.p_dep_care_med_spending         ;
1697     pr_p_earned_income_credit         :=  p_profile_rec.p_earned_income_credit          ;
1698     pr_p_living_allow                 :=  p_profile_rec.p_living_allow                  ;
1699     pr_p_tax_exmpt_int                :=  p_profile_rec.p_tax_exmpt_int                 ;
1700     pr_p_foreign_inc_excl             :=  p_profile_rec.p_foreign_inc_excl              ;
1701     pr_p_other_untax_inc              :=  p_profile_rec.p_other_untax_inc               ;
1702     pr_p_hope_ll_credit               :=  p_profile_rec.p_hope_ll_credit                ;
1703     pr_p_yr_separation                :=  p_profile_rec.p_yr_separation                 ;
1704     pr_p_yr_divorce                   :=  p_profile_rec.p_yr_divorce                    ;
1705     pr_p_exp_father_inc               :=  p_profile_rec.p_exp_father_inc                ;
1706     pr_p_exp_mother_inc               :=  p_profile_rec.p_exp_mother_inc                ;
1707     pr_p_exp_other_tax_inc            :=  p_profile_rec.p_exp_other_tax_inc             ;
1708     pr_p_exp_other_untax_inc          :=  p_profile_rec.p_exp_other_untax_inc           ;
1709     pr_line_2_relation                :=  p_profile_rec.line_2_relation                 ;
1710     pr_line_2_attend_college          :=  p_profile_rec.line_2_attend_college           ;
1711     pr_line_3_relation                :=  p_profile_rec.line_3_relation                 ;
1712     pr_line_3_attend_college          :=  p_profile_rec.line_3_attend_college           ;
1713     pr_line_4_relation                :=  p_profile_rec.line_4_relation                 ;
1714     pr_line_4_attend_college          :=  p_profile_rec.line_4_attend_college           ;
1715     pr_line_5_relation                :=  p_profile_rec.line_5_relation                 ;
1716     pr_line_5_attend_college          :=  p_profile_rec.line_5_attend_college           ;
1717     pr_line_6_relation                :=  p_profile_rec.line_6_relation                 ;
1718     pr_line_6_attend_college          :=  p_profile_rec.line_6_attend_college           ;
1719     pr_line_7_relation                :=  p_profile_rec.line_7_relation                 ;
1720     pr_line_7_attend_college          :=  p_profile_rec.line_7_attend_college           ;
1721     pr_line_8_relation                :=  p_profile_rec.line_8_relation                 ;
1722     pr_line_8_attend_college          :=  p_profile_rec.line_8_attend_college           ;
1723     pr_p_age_father                   :=  p_profile_rec.p_age_father                    ;
1724     pr_p_age_mother                   :=  p_profile_rec.p_age_mother                    ;
1725     pr_p_div_sep_ind                  :=  p_profile_rec.p_div_sep_ind                   ;
1726     pr_b_cont_non_custodial_par       :=  p_profile_rec.b_cont_non_custodial_par        ;
1727     pr_college_type_2                 :=  p_profile_rec.college_type_2                  ;
1728     pr_college_type_3                 :=  p_profile_rec.college_type_3                  ;
1729     pr_college_type_4                 :=  p_profile_rec.college_type_4                  ;
1730     pr_college_type_5                 :=  p_profile_rec.college_type_5                  ;
1731     pr_college_type_6                 :=  p_profile_rec.college_type_6                  ;
1732     pr_college_type_7                 :=  p_profile_rec.college_type_7                  ;
1733     pr_college_type_8                 :=  p_profile_rec.college_type_8                  ;
1734     pr_school_code_1                  :=  p_profile_rec.school_code_1                   ;
1735     pr_housing_code_1                 :=  p_profile_rec.housing_code_1                  ;
1739     pr_housing_code_3                 :=  p_profile_rec.housing_code_3                  ;
1736     pr_school_code_2                  :=  p_profile_rec.school_code_2                   ;
1737     pr_housing_code_2                 :=  p_profile_rec.housing_code_2                  ;
1738     pr_school_code_3                  :=  p_profile_rec.school_code_3                   ;
1740     pr_school_code_4                  :=  p_profile_rec.school_code_4                   ;
1741     pr_housing_code_4                 :=  p_profile_rec.housing_code_4                  ;
1742     pr_school_code_5                  :=  p_profile_rec.school_code_5                   ;
1743     pr_housing_code_5                 :=  p_profile_rec.housing_code_5                  ;
1744     pr_school_code_6                  :=  p_profile_rec.school_code_6                   ;
1745     pr_housing_code_6                 :=  p_profile_rec.housing_code_6                  ;
1746     pr_school_code_7                  :=  p_profile_rec.school_code_7                   ;
1747     pr_housing_code_7                 :=  p_profile_rec.housing_code_7                  ;
1748     pr_school_code_8                  :=  p_profile_rec.school_code_8                   ;
1749     pr_housing_code_8                 :=  p_profile_rec.housing_code_8                  ;
1750     pr_school_code_9                  :=  p_profile_rec.school_code_9                   ;
1751     pr_housing_code_9                 :=  p_profile_rec.housing_code_9                  ;
1752     pr_school_code_10                 :=  p_profile_rec.school_code_10                  ;
1753     pr_housing_code_10                :=  p_profile_rec.housing_code_10                 ;
1754     pr_additional_school_code_1       :=  p_profile_rec.additional_school_code_1        ;
1755     pr_additional_school_code_2       :=  p_profile_rec.additional_school_code_2        ;
1756     pr_additional_school_code_3       :=  p_profile_rec.additional_school_code_3        ;
1757     pr_additional_school_code_4       :=  p_profile_rec.additional_school_code_4        ;
1758     pr_additional_school_code_5       :=  p_profile_rec.additional_school_code_5        ;
1759     pr_additional_school_code_6       :=  p_profile_rec.additional_school_code_6        ;
1760     pr_additional_school_code_7       :=  p_profile_rec.additional_school_code_7        ;
1761     pr_additional_school_code_8       :=  p_profile_rec.additional_school_code_8        ;
1762     pr_additional_school_code_9       :=  p_profile_rec.additional_school_code_9        ;
1763     pr_additional_school_code_10      :=  p_profile_rec.additional_school_code_10       ;
1764     pr_explanation_spec_circum        :=  p_profile_rec.explanation_spec_circum         ;
1765     pr_signature_student              :=  p_profile_rec.signature_student               ;
1766     pr_signature_spouse               :=  p_profile_rec.signature_spouse                ;
1767     pr_signature_father               :=  p_profile_rec.signature_father                ;
1768     pr_signature_mother               :=  p_profile_rec.signature_mother                ;
1769     pr_month_day_completed            :=  p_profile_rec.month_day_completed             ;
1770     pr_year_completed                 :=  p_profile_rec.year_completed                  ;
1771     pr_age_line_2                     :=  p_profile_rec.age_line_2                      ;
1772     pr_age_line_3                     :=  p_profile_rec.age_line_3                      ;
1773     pr_age_line_4                     :=  p_profile_rec.age_line_4                      ;
1774     pr_age_line_5                     :=  p_profile_rec.age_line_5                      ;
1775     pr_age_line_6                     :=  p_profile_rec.age_line_6                      ;
1776     pr_age_line_7                     :=  p_profile_rec.age_line_7                      ;
1777     pr_age_line_8                     :=  p_profile_rec.age_line_8                      ;
1778     pr_a_online_signature             :=  p_profile_rec.a_online_signature              ;
1779     pr_question_1_number              :=  p_profile_rec.question_1_number               ;
1780     pr_question_1_size                :=  p_profile_rec.question_1_size                 ;
1781     pr_question_1_answer              :=  p_profile_rec.question_1_answer               ;
1782     pr_question_2_number              :=  p_profile_rec.question_2_number               ;
1783     pr_question_2_size                :=  p_profile_rec.question_2_size                 ;
1784     pr_question_2_answer              :=  p_profile_rec.question_2_answer               ;
1785     pr_question_3_number              :=  p_profile_rec.question_3_number               ;
1786     pr_question_3_size                :=  p_profile_rec.question_3_size                 ;
1787     pr_question_3_answer              :=  p_profile_rec.question_3_answer               ;
1788     pr_question_4_number              :=  p_profile_rec.question_4_number               ;
1789     pr_question_4_size                :=  p_profile_rec.question_4_size                 ;
1790     pr_question_4_answer              :=  p_profile_rec.question_4_answer               ;
1791     pr_question_5_number              :=  p_profile_rec.question_5_number               ;
1792     pr_question_5_size                :=  p_profile_rec.question_5_size                 ;
1793     pr_question_5_answer              :=  p_profile_rec.question_5_answer               ;
1794     pr_question_6_number              :=  p_profile_rec.question_6_number               ;
1795     pr_question_6_size                :=  p_profile_rec.question_6_size                 ;
1796     pr_question_6_answer              :=  p_profile_rec.question_6_answer               ;
1797     pr_question_7_number              :=  p_profile_rec.question_7_number               ;
1798     pr_question_7_size                :=  p_profile_rec.question_7_size                 ;
1799     pr_question_7_answer              :=  p_profile_rec.question_7_answer               ;
1800     pr_question_8_number              :=  p_profile_rec.question_8_number               ;
1801     pr_question_8_size                :=  p_profile_rec.question_8_size                 ;
1805     pr_question_9_answer              :=  p_profile_rec.question_9_answer               ;
1802     pr_question_8_answer              :=  p_profile_rec.question_8_answer               ;
1803     pr_question_9_number              :=  p_profile_rec.question_9_number               ;
1804     pr_question_9_size                :=  p_profile_rec.question_9_size                 ;
1806     pr_question_10_number             :=  p_profile_rec.question_10_number              ;
1807     pr_question_10_size               :=  p_profile_rec.question_10_size                ;
1808     pr_question_10_answer             :=  p_profile_rec.question_10_answer              ;
1809     pr_question_11_number             :=  p_profile_rec.question_11_number              ;
1810     pr_question_11_size               :=  p_profile_rec.question_11_size                ;
1811     pr_question_11_answer             :=  p_profile_rec.question_11_answer              ;
1812     pr_question_12_number             :=  p_profile_rec.question_12_number              ;
1813     pr_question_12_size               :=  p_profile_rec.question_12_size                ;
1814     pr_question_12_answer             :=  p_profile_rec.question_12_answer              ;
1815     pr_question_13_number             :=  p_profile_rec.question_13_number              ;
1816     pr_question_13_size               :=  p_profile_rec.question_13_size                ;
1817     pr_question_13_answer             :=  p_profile_rec.question_13_answer              ;
1818     pr_question_14_number             :=  p_profile_rec.question_14_number              ;
1819     pr_question_14_size               :=  p_profile_rec.question_14_size                ;
1820     pr_question_14_answer             :=  p_profile_rec.question_14_answer              ;
1821     pr_question_15_number             :=  p_profile_rec.question_15_number              ;
1822     pr_question_15_size               :=  p_profile_rec.question_15_size                ;
1823     pr_question_15_answer             :=  p_profile_rec.question_15_answer              ;
1824     pr_question_16_number             :=  p_profile_rec.question_16_number              ;
1825     pr_question_16_size               :=  p_profile_rec.question_16_size                ;
1826     pr_question_16_answer             :=  p_profile_rec.question_16_answer              ;
1827     pr_question_17_number             :=  p_profile_rec.question_17_number              ;
1828     pr_question_17_size               :=  p_profile_rec.question_17_size                ;
1829     pr_question_17_answer             :=  p_profile_rec.question_17_answer              ;
1830     pr_question_18_number             :=  p_profile_rec.question_18_number              ;
1831     pr_question_18_size               :=  p_profile_rec.question_18_size                ;
1832     pr_question_18_answer             :=  p_profile_rec.question_18_answer              ;
1833     pr_question_19_number             :=  p_profile_rec.question_19_number              ;
1834     pr_question_19_size               :=  p_profile_rec.question_19_size                ;
1835     pr_question_19_answer             :=  p_profile_rec.question_19_answer              ;
1836     pr_question_20_number             :=  p_profile_rec.question_20_number              ;
1837     pr_question_20_size               :=  p_profile_rec.question_20_size                ;
1838     pr_question_20_answer             :=  p_profile_rec.question_20_answer              ;
1839     pr_question_21_number             :=  p_profile_rec.question_21_number              ;
1840     pr_question_21_size               :=  p_profile_rec.question_21_size                ;
1841     pr_question_21_answer             :=  p_profile_rec.question_21_answer              ;
1842     pr_question_22_number             :=  p_profile_rec.question_22_number              ;
1843     pr_question_22_size               :=  p_profile_rec.question_22_size                ;
1844     pr_question_22_answer             :=  p_profile_rec.question_22_answer              ;
1845     pr_question_23_number             :=  p_profile_rec.question_23_number              ;
1846     pr_question_23_size               :=  p_profile_rec.question_23_size                ;
1847     pr_question_23_answer             :=  p_profile_rec.question_23_answer              ;
1848     pr_question_24_number             :=  p_profile_rec.question_24_number              ;
1849     pr_question_24_size               :=  p_profile_rec.question_24_size                ;
1850     pr_question_24_answer             :=  p_profile_rec.question_24_answer              ;
1851     pr_question_25_number             :=  p_profile_rec.question_25_number              ;
1852     pr_question_25_size               :=  p_profile_rec.question_25_size                ;
1853     pr_question_25_answer             :=  p_profile_rec.question_25_answer              ;
1854     pr_question_26_number             :=  p_profile_rec.question_26_number              ;
1855     pr_question_26_size               :=  p_profile_rec.question_26_size                ;
1856     pr_question_26_answer             :=  p_profile_rec.question_26_answer              ;
1857     pr_question_27_number             :=  p_profile_rec.question_27_number              ;
1858     pr_question_27_size               :=  p_profile_rec.question_27_size                ;
1859     pr_question_27_answer             :=  p_profile_rec.question_27_answer              ;
1860     pr_question_28_number             :=  p_profile_rec.question_28_number              ;
1861     pr_question_28_size               :=  p_profile_rec.question_28_size                ;
1862     pr_question_28_answer             :=  p_profile_rec.question_28_answer              ;
1863     pr_question_29_number             :=  p_profile_rec.question_29_number              ;
1864     pr_question_29_size               :=  p_profile_rec.question_29_size                ;
1865     pr_question_29_answer             :=  p_profile_rec.question_29_answer              ;
1866     pr_question_30_number             :=  p_profile_rec.question_30_number              ;
1867     pr_questions_30_size              :=  p_profile_rec.questions_30_size               ;
1868     pr_question_30_answer             :=  p_profile_rec.question_30_answer              ;
1869     pr_legacy_record_flag             :=  p_profile_rec.legacy_record_flag              ;
1870     pr_coa_duration_efc_amt           :=  p_profile_rec.coa_duration_efc_amt            ;
1874     pr_last_updated_by                :=  p_profile_rec.last_updated_by                 ;
1871     pr_coa_duration_num               :=  p_profile_rec.coa_duration_num                ;
1872     pr_created_by                     :=  p_profile_rec.created_by                      ;
1873     pr_creation_date                  :=  p_profile_rec.creation_date                   ;
1875     pr_last_update_date               :=  p_profile_rec.last_update_date                ;
1876     pr_last_update_login              :=  p_profile_rec.last_update_login               ;
1877     pr_p_soc_sec_ben_student_amt      :=  p_profile_rec.p_soc_sec_ben_student_amt       ;
1878     pr_p_tuit_fee_deduct_amt          :=  p_profile_rec.p_tuit_fee_deduct_amt           ;
1879     pr_stu_lives_with_num             :=  p_profile_rec.stu_lives_with_num              ;
1880     pr_stu_most_support_from_num      :=  p_profile_rec.stu_most_support_from_num       ;
1881     pr_location_computer_num          :=  p_profile_rec.location_computer_num           ;
1882 
1883     f_fnar_id                        :=  p_fnar_rec.fnar_id                         ;
1884     f_cssp_id                        :=  p_fnar_rec.cssp_id                         ;
1885     f_r_s_email_address              :=  p_fnar_rec.r_s_email_address               ;
1886     f_eps_code                       :=  p_fnar_rec.eps_code                        ;
1887     f_comp_css_dependency_status     :=  p_fnar_rec.comp_css_dependency_status      ;
1888     f_stu_age                        :=  p_fnar_rec.stu_age                         ;
1889     f_assumed_stu_yr_in_coll         :=  p_fnar_rec.assumed_stu_yr_in_coll          ;
1890     f_comp_stu_marital_status        :=  p_fnar_rec.comp_stu_marital_status         ;
1891     f_stu_family_members             :=  p_fnar_rec.stu_family_members              ;
1892     f_stu_fam_members_in_college     :=  p_fnar_rec.stu_fam_members_in_college      ;
1893     f_par_marital_status             :=  p_fnar_rec.par_marital_status              ;
1894     f_par_family_members             :=  p_fnar_rec.par_family_members              ;
1895     f_par_total_in_college           :=  p_fnar_rec.par_total_in_college            ;
1896     f_par_par_in_college             :=  p_fnar_rec.par_par_in_college              ;
1897     f_par_others_in_college          :=  p_fnar_rec.par_others_in_college           ;
1898     f_par_aesa                       :=  p_fnar_rec.par_aesa                        ;
1899     f_par_cesa                       :=  p_fnar_rec.par_cesa                        ;
1900     f_stu_aesa                       :=  p_fnar_rec.stu_aesa                        ;
1901     f_stu_cesa                       :=  p_fnar_rec.stu_cesa                        ;
1902     f_im_p_bas_agi_taxable_income    :=  p_fnar_rec.im_p_bas_agi_taxable_income     ;
1903     f_im_p_bas_untx_inc_and_ben      :=  p_fnar_rec.im_p_bas_untx_inc_and_ben       ;
1904     f_im_p_bas_inc_adj               :=  p_fnar_rec.im_p_bas_inc_adj                ;
1905     f_im_p_bas_total_income          :=  p_fnar_rec.im_p_bas_total_income           ;
1906     f_im_p_bas_us_income_tax         :=  p_fnar_rec.im_p_bas_us_income_tax          ;
1907     f_im_p_bas_st_and_other_tax      :=  p_fnar_rec.im_p_bas_st_and_other_tax       ;
1908     f_im_p_bas_fica_tax              :=  p_fnar_rec.im_p_bas_fica_tax               ;
1909     f_im_p_bas_med_dental            :=  p_fnar_rec.im_p_bas_med_dental             ;
1910     f_im_p_bas_employment_allow      :=  p_fnar_rec.im_p_bas_employment_allow       ;
1911     f_im_p_bas_annual_ed_savings     :=  p_fnar_rec.im_p_bas_annual_ed_savings      ;
1912     f_im_p_bas_inc_prot_allow_m      :=  p_fnar_rec.im_p_bas_inc_prot_allow_m       ;
1913     f_im_p_bas_total_inc_allow       :=  p_fnar_rec.im_p_bas_total_inc_allow        ;
1914     f_im_p_bas_cal_avail_inc         :=  p_fnar_rec.im_p_bas_cal_avail_inc          ;
1915     f_im_p_bas_avail_income          :=  p_fnar_rec.im_p_bas_avail_income           ;
1916     f_im_p_bas_total_cont_inc        :=  p_fnar_rec.im_p_bas_total_cont_inc         ;
1917     f_im_p_bas_cash_bank_accounts    :=  p_fnar_rec.im_p_bas_cash_bank_accounts     ;
1918     f_im_p_bas_home_equity           :=  p_fnar_rec.im_p_bas_home_equity            ;
1919     f_im_p_bas_ot_rl_est_inv_eq      :=  p_fnar_rec.im_p_bas_ot_rl_est_inv_eq       ;
1920     f_im_p_bas_adj_bus_farm_worth    :=  p_fnar_rec.im_p_bas_adj_bus_farm_worth     ;
1921     f_im_p_bas_ass_sibs_pre_tui      :=  p_fnar_rec.im_p_bas_ass_sibs_pre_tui       ;
1922     f_im_p_bas_net_worth             :=  p_fnar_rec.im_p_bas_net_worth              ;
1923     f_im_p_bas_emerg_res_allow       :=  p_fnar_rec.im_p_bas_emerg_res_allow        ;
1924     f_im_p_bas_cum_ed_savings        :=  p_fnar_rec.im_p_bas_cum_ed_savings         ;
1925     f_im_p_bas_low_inc_allow         :=  p_fnar_rec.im_p_bas_low_inc_allow          ;
1926     f_im_p_bas_total_asset_allow     :=  p_fnar_rec.im_p_bas_total_asset_allow      ;
1927     f_im_p_bas_disc_net_worth        :=  p_fnar_rec.im_p_bas_disc_net_worth         ;
1928     f_im_p_bas_total_cont_asset      :=  p_fnar_rec.im_p_bas_total_cont_asset       ;
1929     f_im_p_bas_total_cont            :=  p_fnar_rec.im_p_bas_total_cont             ;
1930     f_im_p_bas_num_in_coll_adj       :=  p_fnar_rec.im_p_bas_num_in_coll_adj        ;
1931     f_im_p_bas_cont_for_stu          :=  p_fnar_rec.im_p_bas_cont_for_stu           ;
1932     f_im_p_bas_cont_from_income      :=  p_fnar_rec.im_p_bas_cont_from_income       ;
1933     f_im_p_bas_cont_from_assets      :=  p_fnar_rec.im_p_bas_cont_from_assets       ;
1934     f_im_p_opt_agi_taxable_income    :=  p_fnar_rec.im_p_opt_agi_taxable_income     ;
1935     f_im_p_opt_untx_inc_and_ben      :=  p_fnar_rec.im_p_opt_untx_inc_and_ben       ;
1936     f_im_p_opt_inc_adj               :=  p_fnar_rec.im_p_opt_inc_adj                ;
1937     f_im_p_opt_total_income          :=  p_fnar_rec.im_p_opt_total_income           ;
1938     f_im_p_opt_us_income_tax         :=  p_fnar_rec.im_p_opt_us_income_tax          ;
1942     f_im_p_opt_elem_sec_tuit         :=  p_fnar_rec.im_p_opt_elem_sec_tuit          ;
1939     f_im_p_opt_st_and_other_tax      :=  p_fnar_rec.im_p_opt_st_and_other_tax       ;
1940     f_im_p_opt_fica_tax              :=  p_fnar_rec.im_p_opt_fica_tax               ;
1941     f_im_p_opt_med_dental            :=  p_fnar_rec.im_p_opt_med_dental             ;
1943     f_im_p_opt_employment_allow      :=  p_fnar_rec.im_p_opt_employment_allow       ;
1944     f_im_p_opt_annual_ed_savings     :=  p_fnar_rec.im_p_opt_annual_ed_savings      ;
1945     f_im_p_opt_inc_prot_allow_m      :=  p_fnar_rec.im_p_opt_inc_prot_allow_m       ;
1946     f_im_p_opt_total_inc_allow       :=  p_fnar_rec.im_p_opt_total_inc_allow        ;
1947     f_im_p_opt_cal_avail_inc         :=  p_fnar_rec.im_p_opt_cal_avail_inc          ;
1948     f_im_p_opt_avail_income          :=  p_fnar_rec.im_p_opt_avail_income           ;
1949     f_im_p_opt_total_cont_inc        :=  p_fnar_rec.im_p_opt_total_cont_inc         ;
1950     f_im_p_opt_cash_bank_accounts    :=  p_fnar_rec.im_p_opt_cash_bank_accounts     ;
1951     f_im_p_opt_home_equity           :=  p_fnar_rec.im_p_opt_home_equity            ;
1952     f_im_p_opt_ot_rl_est_inv_eq      :=  p_fnar_rec.im_p_opt_ot_rl_est_inv_eq       ;
1953     f_im_p_opt_adj_bus_farm_worth    :=  p_fnar_rec.im_p_opt_adj_bus_farm_worth     ;
1954     f_im_p_opt_ass_sibs_pre_tui      :=  p_fnar_rec.im_p_opt_ass_sibs_pre_tui       ;
1955     f_im_p_opt_net_worth             :=  p_fnar_rec.im_p_opt_net_worth              ;
1956     f_im_p_opt_emerg_res_allow       :=  p_fnar_rec.im_p_opt_emerg_res_allow        ;
1957     f_im_p_opt_cum_ed_savings        :=  p_fnar_rec.im_p_opt_cum_ed_savings         ;
1958     f_im_p_opt_low_inc_allow         :=  p_fnar_rec.im_p_opt_low_inc_allow          ;
1959     f_im_p_opt_total_asset_allow     :=  p_fnar_rec.im_p_opt_total_asset_allow      ;
1960     f_im_p_opt_disc_net_worth        :=  p_fnar_rec.im_p_opt_disc_net_worth         ;
1961     f_im_p_opt_total_cont_asset      :=  p_fnar_rec.im_p_opt_total_cont_asset       ;
1962     f_im_p_opt_total_cont            :=  p_fnar_rec.im_p_opt_total_cont             ;
1963     f_im_p_opt_num_in_coll_adj       :=  p_fnar_rec.im_p_opt_num_in_coll_adj        ;
1964     f_im_p_opt_cont_for_stu          :=  p_fnar_rec.im_p_opt_cont_for_stu           ;
1965     f_im_p_opt_cont_from_income      :=  p_fnar_rec.im_p_opt_cont_from_income       ;
1966     f_im_p_opt_cont_from_assets      :=  p_fnar_rec.im_p_opt_cont_from_assets       ;
1967     f_fm_p_analysis_type             :=  p_fnar_rec.fm_p_analysis_type              ;
1968     f_fm_p_agi_taxable_income        :=  p_fnar_rec.fm_p_agi_taxable_income         ;
1969     f_fm_p_untx_inc_and_ben          :=  p_fnar_rec.fm_p_untx_inc_and_ben           ;
1970     f_fm_p_inc_adj                   :=  p_fnar_rec.fm_p_inc_adj                    ;
1971     f_fm_p_total_income              :=  p_fnar_rec.fm_p_total_income               ;
1972     f_fm_p_us_income_tax             :=  p_fnar_rec.fm_p_us_income_tax              ;
1973     f_fm_p_state_and_other_taxes     :=  p_fnar_rec.fm_p_state_and_other_taxes      ;
1974     f_fm_p_fica_tax                  :=  p_fnar_rec.fm_p_fica_tax                   ;
1975     f_fm_p_employment_allow          :=  p_fnar_rec.fm_p_employment_allow           ;
1976     f_fm_p_income_prot_allow         :=  p_fnar_rec.fm_p_income_prot_allow          ;
1977     f_fm_p_total_allow               :=  p_fnar_rec.fm_p_total_allow                ;
1978     f_fm_p_avail_income              :=  p_fnar_rec.fm_p_avail_income               ;
1979     f_fm_p_cash_bank_accounts        :=  p_fnar_rec.fm_p_cash_bank_accounts         ;
1980     f_fm_p_ot_rl_est_inv_equity      :=  p_fnar_rec.fm_p_ot_rl_est_inv_equity       ;
1981     f_fm_p_adj_bus_farm_net_worth    :=  p_fnar_rec.fm_p_adj_bus_farm_net_worth     ;
1982     f_fm_p_net_worth                 :=  p_fnar_rec.fm_p_net_worth                  ;
1983     f_fm_p_asset_prot_allow          :=  p_fnar_rec.fm_p_asset_prot_allow           ;
1984     f_fm_p_disc_net_worth            :=  p_fnar_rec.fm_p_disc_net_worth             ;
1985     f_fm_p_total_contribution        :=  p_fnar_rec.fm_p_total_contribution         ;
1986     f_fm_p_num_in_coll               :=  p_fnar_rec.fm_p_num_in_coll                ;
1987     f_fm_p_cont_for_stu              :=  p_fnar_rec.fm_p_cont_for_stu               ;
1988     f_fm_p_cont_from_income          :=  p_fnar_rec.fm_p_cont_from_income           ;
1989     f_fm_p_cont_from_assets          :=  p_fnar_rec.fm_p_cont_from_assets           ;
1990     f_im_s_bas_agi_taxable_income    :=  p_fnar_rec.im_s_bas_agi_taxable_income     ;
1991     f_im_s_bas_untx_inc_and_ben      :=  p_fnar_rec.im_s_bas_untx_inc_and_ben       ;
1992     f_im_s_bas_inc_adj               :=  p_fnar_rec.im_s_bas_inc_adj                ;
1993     f_im_s_bas_total_income          :=  p_fnar_rec.im_s_bas_total_income           ;
1994     f_im_s_bas_us_income_tax         :=  p_fnar_rec.im_s_bas_us_income_tax          ;
1995     f_im_s_bas_state_and_oth_taxes   :=  p_fnar_rec.im_s_bas_state_and_oth_taxes    ;
1996     f_im_s_bas_fica_tax              :=  p_fnar_rec.im_s_bas_fica_tax               ;
1997     f_im_s_bas_med_dental            :=  p_fnar_rec.im_s_bas_med_dental             ;
1998     f_im_s_bas_employment_allow      :=  p_fnar_rec.im_s_bas_employment_allow       ;
1999     f_im_s_bas_annual_ed_savings     :=  p_fnar_rec.im_s_bas_annual_ed_savings      ;
2000     f_im_s_bas_inc_prot_allow_m      :=  p_fnar_rec.im_s_bas_inc_prot_allow_m       ;
2001     f_im_s_bas_total_inc_allow       :=  p_fnar_rec.im_s_bas_total_inc_allow        ;
2002     f_im_s_bas_cal_avail_income      :=  p_fnar_rec.im_s_bas_cal_avail_income       ;
2003     f_im_s_bas_avail_income          :=  p_fnar_rec.im_s_bas_avail_income           ;
2004     f_im_s_bas_total_cont_inc        :=  p_fnar_rec.im_s_bas_total_cont_inc         ;
2005     f_im_s_bas_cash_bank_accounts    :=  p_fnar_rec.im_s_bas_cash_bank_accounts     ;
2006     f_im_s_bas_home_equity           :=  p_fnar_rec.im_s_bas_home_equity            ;
2007     f_im_s_bas_ot_rl_est_inv_eq      :=  p_fnar_rec.im_s_bas_ot_rl_est_inv_eq       ;
2011     f_im_s_bas_emerg_res_allow       :=  p_fnar_rec.im_s_bas_emerg_res_allow        ;
2008     f_im_s_bas_adj_busfarm_worth     :=  p_fnar_rec.im_s_bas_adj_busfarm_worth      ;
2009     f_im_s_bas_trusts                :=  p_fnar_rec.im_s_bas_trusts                 ;
2010     f_im_s_bas_net_worth             :=  p_fnar_rec.im_s_bas_net_worth              ;
2012     f_im_s_bas_cum_ed_savings        :=  p_fnar_rec.im_s_bas_cum_ed_savings         ;
2013     f_im_s_bas_total_asset_allow     :=  p_fnar_rec.im_s_bas_total_asset_allow      ;
2014     f_im_s_bas_disc_net_worth        :=  p_fnar_rec.im_s_bas_disc_net_worth         ;
2015     f_im_s_bas_total_cont_asset      :=  p_fnar_rec.im_s_bas_total_cont_asset       ;
2016     f_im_s_bas_total_cont            :=  p_fnar_rec.im_s_bas_total_cont             ;
2017     f_im_s_bas_num_in_coll_adj       :=  p_fnar_rec.im_s_bas_num_in_coll_adj        ;
2018     f_im_s_bas_cont_for_stu          :=  p_fnar_rec.im_s_bas_cont_for_stu           ;
2019     f_im_s_bas_cont_from_income      :=  p_fnar_rec.im_s_bas_cont_from_income       ;
2020     f_im_s_bas_cont_from_assets      :=  p_fnar_rec.im_s_bas_cont_from_assets       ;
2021     f_im_s_est_agitaxable_income     :=  p_fnar_rec.im_s_est_agitaxable_income      ;
2022     f_im_s_est_untx_inc_and_ben      :=  p_fnar_rec.im_s_est_untx_inc_and_ben       ;
2023     f_im_s_est_inc_adj               :=  p_fnar_rec.im_s_est_inc_adj                ;
2024     f_im_s_est_total_income          :=  p_fnar_rec.im_s_est_total_income           ;
2025     f_im_s_est_us_income_tax         :=  p_fnar_rec.im_s_est_us_income_tax          ;
2026     f_im_s_est_state_and_oth_taxes   :=  p_fnar_rec.im_s_est_state_and_oth_taxes    ;
2027     f_im_s_est_fica_tax              :=  p_fnar_rec.im_s_est_fica_tax               ;
2028     f_im_s_est_med_dental            :=  p_fnar_rec.im_s_est_med_dental             ;
2029     f_im_s_est_employment_allow      :=  p_fnar_rec.im_s_est_employment_allow       ;
2030     f_im_s_est_annual_ed_savings     :=  p_fnar_rec.im_s_est_annual_ed_savings      ;
2031     f_im_s_est_inc_prot_allow_m      :=  p_fnar_rec.im_s_est_inc_prot_allow_m       ;
2032     f_im_s_est_total_inc_allow       :=  p_fnar_rec.im_s_est_total_inc_allow        ;
2033     f_im_s_est_cal_avail_income      :=  p_fnar_rec.im_s_est_cal_avail_income       ;
2034     f_im_s_est_avail_income          :=  p_fnar_rec.im_s_est_avail_income           ;
2035     f_im_s_est_total_cont_inc        :=  p_fnar_rec.im_s_est_total_cont_inc         ;
2036     f_im_s_est_cash_bank_accounts    :=  p_fnar_rec.im_s_est_cash_bank_accounts     ;
2037     f_im_s_est_home_equity           :=  p_fnar_rec.im_s_est_home_equity            ;
2038     f_im_s_est_ot_rl_est_inv_eq      :=  p_fnar_rec.im_s_est_ot_rl_est_inv_eq       ;
2039     f_im_s_est_adj_bus_farm_worth    :=  p_fnar_rec.im_s_est_adj_bus_farm_worth     ;
2040     f_im_s_est_est_trusts            :=  p_fnar_rec.im_s_est_est_trusts             ;
2041     f_im_s_est_net_worth             :=  p_fnar_rec.im_s_est_net_worth              ;
2042     f_im_s_est_emerg_res_allow       :=  p_fnar_rec.im_s_est_emerg_res_allow        ;
2043     f_im_s_est_cum_ed_savings        :=  p_fnar_rec.im_s_est_cum_ed_savings         ;
2044     f_im_s_est_total_asset_allow     :=  p_fnar_rec.im_s_est_total_asset_allow      ;
2045     f_im_s_est_disc_net_worth        :=  p_fnar_rec.im_s_est_disc_net_worth         ;
2046     f_im_s_est_total_cont_asset      :=  p_fnar_rec.im_s_est_total_cont_asset       ;
2047     f_im_s_est_total_cont            :=  p_fnar_rec.im_s_est_total_cont             ;
2048     f_im_s_est_num_in_coll_adj       :=  p_fnar_rec.im_s_est_num_in_coll_adj        ;
2049     f_im_s_est_cont_for_stu          :=  p_fnar_rec.im_s_est_cont_for_stu           ;
2050     f_im_s_est_cont_from_income      :=  p_fnar_rec.im_s_est_cont_from_income       ;
2051     f_im_s_est_cont_from_assets      :=  p_fnar_rec.im_s_est_cont_from_assets       ;
2052     f_im_s_opt_agi_taxable_income    :=  p_fnar_rec.im_s_opt_agi_taxable_income     ;
2053     f_im_s_opt_untx_inc_and_ben      :=  p_fnar_rec.im_s_opt_untx_inc_and_ben       ;
2054     f_im_s_opt_inc_adj               :=  p_fnar_rec.im_s_opt_inc_adj                ;
2055     f_im_s_opt_total_income          :=  p_fnar_rec.im_s_opt_total_income           ;
2056     f_im_s_opt_us_income_tax         :=  p_fnar_rec.im_s_opt_us_income_tax          ;
2057     f_im_s_opt_state_and_oth_taxes   :=  p_fnar_rec.im_s_opt_state_and_oth_taxes    ;
2058     f_im_s_opt_fica_tax              :=  p_fnar_rec.im_s_opt_fica_tax               ;
2059     f_im_s_opt_med_dental            :=  p_fnar_rec.im_s_opt_med_dental             ;
2060     f_im_s_opt_employment_allow      :=  p_fnar_rec.im_s_opt_employment_allow       ;
2061     f_im_s_opt_annual_ed_savings     :=  p_fnar_rec.im_s_opt_annual_ed_savings      ;
2062     f_im_s_opt_inc_prot_allow_m      :=  p_fnar_rec.im_s_opt_inc_prot_allow_m       ;
2063     f_im_s_opt_total_inc_allow       :=  p_fnar_rec.im_s_opt_total_inc_allow        ;
2064     f_im_s_opt_cal_avail_income      :=  p_fnar_rec.im_s_opt_cal_avail_income       ;
2065     f_im_s_opt_avail_income          :=  p_fnar_rec.im_s_opt_avail_income           ;
2066     f_im_s_opt_total_cont_inc        :=  p_fnar_rec.im_s_opt_total_cont_inc         ;
2067     f_im_s_opt_cash_bank_accounts    :=  p_fnar_rec.im_s_opt_cash_bank_accounts     ;
2068     f_im_s_opt_ira_keogh_accounts    :=  p_fnar_rec.im_s_opt_ira_keogh_accounts     ;
2069     f_im_s_opt_home_equity           :=  p_fnar_rec.im_s_opt_home_equity            ;
2070     f_im_s_opt_ot_rl_est_inv_eq      :=  p_fnar_rec.im_s_opt_ot_rl_est_inv_eq       ;
2071     f_im_s_opt_adj_bus_farm_worth    :=  p_fnar_rec.im_s_opt_adj_bus_farm_worth     ;
2072     f_im_s_opt_trusts                :=  p_fnar_rec.im_s_opt_trusts                 ;
2073     f_im_s_opt_net_worth             :=  p_fnar_rec.im_s_opt_net_worth              ;
2074     f_im_s_opt_emerg_res_allow       :=  p_fnar_rec.im_s_opt_emerg_res_allow        ;
2075     f_im_s_opt_cum_ed_savings        :=  p_fnar_rec.im_s_opt_cum_ed_savings         ;
2076     f_im_s_opt_total_asset_allow     :=  p_fnar_rec.im_s_opt_total_asset_allow      ;
2077     f_im_s_opt_disc_net_worth        :=  p_fnar_rec.im_s_opt_disc_net_worth         ;
2078     f_im_s_opt_total_cont_asset      :=  p_fnar_rec.im_s_opt_total_cont_asset       ;
2082     f_im_s_opt_cont_from_income      :=  p_fnar_rec.im_s_opt_cont_from_income       ;
2079     f_im_s_opt_total_cont            :=  p_fnar_rec.im_s_opt_total_cont             ;
2080     f_im_s_opt_num_in_coll_adj       :=  p_fnar_rec.im_s_opt_num_in_coll_adj        ;
2081     f_im_s_opt_cont_for_stu          :=  p_fnar_rec.im_s_opt_cont_for_stu           ;
2083     f_im_s_opt_cont_from_assets      :=  p_fnar_rec.im_s_opt_cont_from_assets       ;
2084     f_fm_s_analysis_type             :=  p_fnar_rec.fm_s_analysis_type              ;
2085     f_fm_s_agi_taxable_income        :=  p_fnar_rec.fm_s_agi_taxable_income         ;
2086     f_fm_s_untx_inc_and_ben          :=  p_fnar_rec.fm_s_untx_inc_and_ben           ;
2087     f_fm_s_inc_adj                   :=  p_fnar_rec.fm_s_inc_adj                    ;
2088     f_fm_s_total_income              :=  p_fnar_rec.fm_s_total_income               ;
2089     f_fm_s_us_income_tax             :=  p_fnar_rec.fm_s_us_income_tax              ;
2090     f_fm_s_state_and_oth_taxes       :=  p_fnar_rec.fm_s_state_and_oth_taxes        ;
2091     f_fm_s_fica_tax                  :=  p_fnar_rec.fm_s_fica_tax                   ;
2092     f_fm_s_employment_allow          :=  p_fnar_rec.fm_s_employment_allow           ;
2093     f_fm_s_income_prot_allow         :=  p_fnar_rec.fm_s_income_prot_allow          ;
2094     f_fm_s_total_allow               :=  p_fnar_rec.fm_s_total_allow                ;
2095     f_fm_s_cal_avail_income          :=  p_fnar_rec.fm_s_cal_avail_income           ;
2096     f_fm_s_avail_income              :=  p_fnar_rec.fm_s_avail_income               ;
2097     f_fm_s_cash_bank_accounts        :=  p_fnar_rec.fm_s_cash_bank_accounts         ;
2098     f_fm_s_ot_rl_est_inv_equity      :=  p_fnar_rec.fm_s_ot_rl_est_inv_equity       ;
2099     f_fm_s_adj_bus_farm_worth        :=  p_fnar_rec.fm_s_adj_bus_farm_worth         ;
2100     f_fm_s_trusts                    :=  p_fnar_rec.fm_s_trusts                     ;
2101     f_fm_s_net_worth                 :=  p_fnar_rec.fm_s_net_worth                  ;
2102     f_fm_s_asset_prot_allow          :=  p_fnar_rec.fm_s_asset_prot_allow           ;
2103     f_fm_s_disc_net_worth            :=  p_fnar_rec.fm_s_disc_net_worth             ;
2104     f_fm_s_total_cont                :=  p_fnar_rec.fm_s_total_cont                 ;
2105     f_fm_s_num_in_coll               :=  p_fnar_rec.fm_s_num_in_coll                ;
2106     f_fm_s_cont_for_stu              :=  p_fnar_rec.fm_s_cont_for_stu               ;
2107     f_fm_s_cont_from_income          :=  p_fnar_rec.fm_s_cont_from_income           ;
2108     f_fm_s_cont_from_assets          :=  p_fnar_rec.fm_s_cont_from_assets           ;
2109     f_im_inst_resident_ind           :=  p_fnar_rec.im_inst_resident_ind            ;
2110     f_institutional_1_budget_name    :=  p_fnar_rec.institutional_1_budget_name     ;
2111     f_im_inst_1_budget_duration      :=  p_fnar_rec.im_inst_1_budget_duration       ;
2112     f_im_inst_1_tuition_fees         :=  p_fnar_rec.im_inst_1_tuition_fees          ;
2113     f_im_inst_1_books_supplies       :=  p_fnar_rec.im_inst_1_books_supplies        ;
2114     f_im_inst_1_living_expenses      :=  p_fnar_rec.im_inst_1_living_expenses       ;
2115     f_im_inst_1_tot_expenses         :=  p_fnar_rec.im_inst_1_tot_expenses          ;
2116     f_im_inst_1_tot_stu_cont         :=  p_fnar_rec.im_inst_1_tot_stu_cont          ;
2117     f_im_inst_1_tot_par_cont         :=  p_fnar_rec.im_inst_1_tot_par_cont          ;
2118     f_im_inst_1_tot_family_cont      :=  p_fnar_rec.im_inst_1_tot_family_cont       ;
2119     f_im_inst_1_va_benefits          :=  p_fnar_rec.im_inst_1_va_benefits           ;
2120     f_im_inst_1_ot_cont              :=  p_fnar_rec.im_inst_1_ot_cont               ;
2121     f_im_inst_1_est_financial_need   :=  p_fnar_rec.im_inst_1_est_financial_need    ;
2122     f_institutional_2_budget_name    :=  p_fnar_rec.institutional_2_budget_name     ;
2123     f_im_inst_2_budget_duration      :=  p_fnar_rec.im_inst_2_budget_duration       ;
2124     f_im_inst_2_tuition_fees         :=  p_fnar_rec.im_inst_2_tuition_fees          ;
2125     f_im_inst_2_books_supplies       :=  p_fnar_rec.im_inst_2_books_supplies        ;
2126     f_im_inst_2_living_expenses      :=  p_fnar_rec.im_inst_2_living_expenses       ;
2127     f_im_inst_2_tot_expenses         :=  p_fnar_rec.im_inst_2_tot_expenses          ;
2128     f_im_inst_2_tot_stu_cont         :=  p_fnar_rec.im_inst_2_tot_stu_cont          ;
2129     f_im_inst_2_tot_par_cont         :=  p_fnar_rec.im_inst_2_tot_par_cont          ;
2130     f_im_inst_2_tot_family_cont      :=  p_fnar_rec.im_inst_2_tot_family_cont       ;
2131     f_im_inst_2_va_benefits          :=  p_fnar_rec.im_inst_2_va_benefits           ;
2132     f_im_inst_2_est_financial_need   :=  p_fnar_rec.im_inst_2_est_financial_need    ;
2133     f_institutional_3_budget_name    :=  p_fnar_rec.institutional_3_budget_name     ;
2134     f_im_inst_3_budget_duration      :=  p_fnar_rec.im_inst_3_budget_duration       ;
2135     f_im_inst_3_tuition_fees         :=  p_fnar_rec.im_inst_3_tuition_fees          ;
2136     f_im_inst_3_books_supplies       :=  p_fnar_rec.im_inst_3_books_supplies        ;
2137     f_im_inst_3_living_expenses      :=  p_fnar_rec.im_inst_3_living_expenses       ;
2138     f_im_inst_3_tot_expenses         :=  p_fnar_rec.im_inst_3_tot_expenses          ;
2139     f_im_inst_3_tot_stu_cont         :=  p_fnar_rec.im_inst_3_tot_stu_cont          ;
2140     f_im_inst_3_tot_par_cont         :=  p_fnar_rec.im_inst_3_tot_par_cont          ;
2141     f_im_inst_3_tot_family_cont      :=  p_fnar_rec.im_inst_3_tot_family_cont       ;
2142     f_im_inst_3_va_benefits          :=  p_fnar_rec.im_inst_3_va_benefits           ;
2143     f_im_inst_3_est_financial_need   :=  p_fnar_rec.im_inst_3_est_financial_need    ;
2144     f_fm_inst_1_federal_efc          :=  p_fnar_rec.fm_inst_1_federal_efc           ;
2145     f_fm_inst_1_va_benefits          :=  p_fnar_rec.fm_inst_1_va_benefits           ;
2146     f_fm_inst_1_fed_eligibility      :=  p_fnar_rec.fm_inst_1_fed_eligibility       ;
2147     f_fm_inst_1_pell                 :=  p_fnar_rec.fm_inst_1_pell                  ;
2148     f_option_par_loss_allow_ind      :=  p_fnar_rec.option_par_loss_allow_ind       ;
2149     f_option_par_tuition_ind         :=  p_fnar_rec.option_par_tuition_ind          ;
2150     f_option_par_home_ind            :=  p_fnar_rec.option_par_home_ind             ;
2154     f_option_stu_home_ind            :=  p_fnar_rec.option_stu_home_ind             ;
2151     f_option_par_home_value          :=  p_fnar_rec.option_par_home_value           ;
2152     f_option_par_home_debt           :=  p_fnar_rec.option_par_home_debt            ;
2153     f_option_stu_ira_keogh_ind       :=  p_fnar_rec.option_stu_ira_keogh_ind        ;
2155     f_option_stu_home_value          :=  p_fnar_rec.option_stu_home_value           ;
2156     f_option_stu_home_debt           :=  p_fnar_rec.option_stu_home_debt            ;
2157     f_option_stu_sum_ay_inc_ind      :=  p_fnar_rec.option_stu_sum_ay_inc_ind       ;
2158     f_option_par_hope_ll_credit      :=  p_fnar_rec.option_par_hope_ll_credit       ;
2159     f_option_stu_hope_ll_credit      :=  p_fnar_rec.option_stu_hope_ll_credit       ;
2160     f_option_par_cola_adj_ind        :=  p_fnar_rec.option_par_cola_adj_ind         ;
2161     f_option_par_stu_fa_assets_ind   :=  p_fnar_rec.option_par_stu_fa_assets_ind    ;
2162     f_option_par_ipt_assets_ind      :=  p_fnar_rec.option_par_ipt_assets_ind       ;
2163     f_option_stu_ipt_assets_ind      :=  p_fnar_rec.option_stu_ipt_assets_ind       ;
2164     f_option_par_cola_adj_value      :=  p_fnar_rec.option_par_cola_adj_value       ;
2165     f_im_parent_1_8_months_bas       :=  p_fnar_rec.im_parent_1_8_months_bas        ;
2166     f_im_p_more_than_9_mth_ba        :=  p_fnar_rec.im_p_more_than_9_mth_ba         ;
2167     f_im_parent_1_8_months_opt       :=  p_fnar_rec.im_parent_1_8_months_opt        ;
2168     f_im_p_more_than_9_mth_op        :=  p_fnar_rec.im_p_more_than_9_mth_op         ;
2169     f_fnar_message_1                 :=  p_fnar_rec.fnar_message_1                  ;
2170     f_fnar_message_2                 :=  p_fnar_rec.fnar_message_2                  ;
2171     f_fnar_message_3                 :=  p_fnar_rec.fnar_message_3                  ;
2172     f_fnar_message_4                 :=  p_fnar_rec.fnar_message_4                  ;
2173     f_fnar_message_5                 :=  p_fnar_rec.fnar_message_5                  ;
2174     f_fnar_message_6                 :=  p_fnar_rec.fnar_message_6                  ;
2175     f_fnar_message_7                 :=  p_fnar_rec.fnar_message_7                  ;
2176     f_fnar_message_8                 :=  p_fnar_rec.fnar_message_8                  ;
2177     f_fnar_message_9                 :=  p_fnar_rec.fnar_message_9                  ;
2178     f_fnar_message_10                :=  p_fnar_rec.fnar_message_10                 ;
2179     f_fnar_message_11                :=  p_fnar_rec.fnar_message_11                 ;
2180     f_fnar_message_12                :=  p_fnar_rec.fnar_message_12                 ;
2181     f_fnar_message_13                :=  p_fnar_rec.fnar_message_13                 ;
2182     f_fnar_message_20                :=  p_fnar_rec.fnar_message_20                 ;
2183     f_fnar_message_21                :=  p_fnar_rec.fnar_message_21                 ;
2184     f_fnar_message_22                :=  p_fnar_rec.fnar_message_22                 ;
2185     f_fnar_message_23                :=  p_fnar_rec.fnar_message_23                 ;
2186     f_fnar_message_24                :=  p_fnar_rec.fnar_message_24                 ;
2187     f_fnar_message_25                :=  p_fnar_rec.fnar_message_25                 ;
2188     f_fnar_message_26                :=  p_fnar_rec.fnar_message_26                 ;
2189     f_fnar_message_27                :=  p_fnar_rec.fnar_message_27                 ;
2190     f_fnar_message_30                :=  p_fnar_rec.fnar_message_30                 ;
2191     f_fnar_message_31                :=  p_fnar_rec.fnar_message_31                 ;
2192     f_fnar_message_32                :=  p_fnar_rec.fnar_message_32                 ;
2193     f_fnar_message_33                :=  p_fnar_rec.fnar_message_33                 ;
2194     f_fnar_message_34                :=  p_fnar_rec.fnar_message_34                 ;
2195     f_fnar_message_35                :=  p_fnar_rec.fnar_message_35                 ;
2196     f_fnar_message_36                :=  p_fnar_rec.fnar_message_36                 ;
2197     f_fnar_message_37                :=  p_fnar_rec.fnar_message_37                 ;
2198     f_fnar_message_38                :=  p_fnar_rec.fnar_message_38                 ;
2199     f_fnar_message_39                :=  p_fnar_rec.fnar_message_39                 ;
2200     f_fnar_message_45                :=  p_fnar_rec.fnar_message_45                 ;
2201     f_fnar_message_46                :=  p_fnar_rec.fnar_message_46                 ;
2202     f_fnar_message_47                :=  p_fnar_rec.fnar_message_47                 ;
2203     f_fnar_message_48                :=  p_fnar_rec.fnar_message_48                 ;
2204     f_fnar_message_49                :=  p_fnar_rec.fnar_message_49                 ;
2205     f_fnar_message_50                :=  p_fnar_rec.fnar_message_50                 ;
2206     f_fnar_message_51                :=  p_fnar_rec.fnar_message_51                 ;
2207     f_fnar_message_52                :=  p_fnar_rec.fnar_message_52                 ;
2208     f_fnar_message_53                :=  p_fnar_rec.fnar_message_53                 ;
2209     f_fnar_message_55                :=  p_fnar_rec.fnar_message_55                 ;
2210     f_fnar_message_56                :=  p_fnar_rec.fnar_message_56                 ;
2211     f_fnar_message_57                :=  p_fnar_rec.fnar_message_57                 ;
2212     f_fnar_message_58                :=  p_fnar_rec.fnar_message_58                 ;
2213     f_fnar_message_59                :=  p_fnar_rec.fnar_message_59                 ;
2214     f_fnar_message_60                :=  p_fnar_rec.fnar_message_60                 ;
2215     f_fnar_message_61                :=  p_fnar_rec.fnar_message_61                 ;
2216     f_fnar_message_62                :=  p_fnar_rec.fnar_message_62                 ;
2217     f_fnar_message_63                :=  p_fnar_rec.fnar_message_63                 ;
2218     f_fnar_message_64                :=  p_fnar_rec.fnar_message_64                 ;
2219     f_fnar_message_65                :=  p_fnar_rec.fnar_message_65                 ;
2220     f_fnar_message_71                :=  p_fnar_rec.fnar_message_71                 ;
2221     f_fnar_message_72                :=  p_fnar_rec.fnar_message_72                 ;
2222     f_fnar_message_73                :=  p_fnar_rec.fnar_message_73                 ;
2223     f_fnar_message_74                :=  p_fnar_rec.fnar_message_74                 ;
2224     f_fnar_message_75                :=  p_fnar_rec.fnar_message_75                 ;
2225     f_fnar_message_76                :=  p_fnar_rec.fnar_message_76                 ;
2226     f_fnar_message_77                :=  p_fnar_rec.fnar_message_77                 ;
2227     f_fnar_message_78                :=  p_fnar_rec.fnar_message_78                 ;
2228     f_fnar_mesg_10_stu_fam_mem       :=  p_fnar_rec.fnar_mesg_10_stu_fam_mem        ;
2229     f_fnar_mesg_11_stu_no_in_coll    :=  p_fnar_rec.fnar_mesg_11_stu_no_in_coll     ;
2230     f_fnar_mesg_24_stu_avail_inc     :=  p_fnar_rec.fnar_mesg_24_stu_avail_inc      ;
2231     f_fnar_mesg_26_stu_taxes         :=  p_fnar_rec.fnar_mesg_26_stu_taxes          ;
2232     f_fnar_mesg_33_stu_home_value    :=  p_fnar_rec.fnar_mesg_33_stu_home_value     ;
2233     f_fnar_mesg_34_stu_home_value    :=  p_fnar_rec.fnar_mesg_34_stu_home_value     ;
2234     f_fnar_mesg_34_stu_home_equity   :=  p_fnar_rec.fnar_mesg_34_stu_home_equity    ;
2235     f_fnar_mesg_35_stu_home_value    :=  p_fnar_rec.fnar_mesg_35_stu_home_value     ;
2236     f_fnar_mesg_35_stu_home_equity   :=  p_fnar_rec.fnar_mesg_35_stu_home_equity    ;
2237     f_fnar_mesg_36_stu_home_equity   :=  p_fnar_rec.fnar_mesg_36_stu_home_equity    ;
2238     f_fnar_mesg_48_par_fam_mem       :=  p_fnar_rec.fnar_mesg_48_par_fam_mem        ;
2239     f_fnar_mesg_49_par_no_in_coll    :=  p_fnar_rec.fnar_mesg_49_par_no_in_coll     ;
2240     f_fnar_mesg_56_par_agi           :=  p_fnar_rec.fnar_mesg_56_par_agi            ;
2241     f_fnar_mesg_62_par_taxes         :=  p_fnar_rec.fnar_mesg_62_par_taxes          ;
2242     f_fnar_mesg_73_par_home_value    :=  p_fnar_rec.fnar_mesg_73_par_home_value     ;
2243     f_fnar_mesg_74_par_home_value    :=  p_fnar_rec.fnar_mesg_74_par_home_value     ;
2244     f_fnar_mesg_74_par_home_equity   :=  p_fnar_rec.fnar_mesg_74_par_home_equity    ;
2245     f_fnar_mesg_75_par_home_value    :=  p_fnar_rec.fnar_mesg_75_par_home_value     ;
2246     f_fnar_mesg_75_par_home_equity   :=  p_fnar_rec.fnar_mesg_75_par_home_equity    ;
2247     f_fnar_mesg_76_par_home_equity   :=  p_fnar_rec.fnar_mesg_76_par_home_equity    ;
2248     f_assumption_message_1           :=  p_fnar_rec.assumption_message_1            ;
2249     f_assumption_message_2           :=  p_fnar_rec.assumption_message_2            ;
2250     f_assumption_message_3           :=  p_fnar_rec.assumption_message_3            ;
2251     f_assumption_message_4           :=  p_fnar_rec.assumption_message_4            ;
2252     f_assumption_message_5           :=  p_fnar_rec.assumption_message_5            ;
2253     f_assumption_message_6           :=  p_fnar_rec.assumption_message_6            ;
2254     f_record_mark                    :=  p_fnar_rec.record_mark                     ;
2255     f_legacy_record_flag             :=  p_fnar_rec.legacy_record_flag              ;
2256     f_creation_date                  :=  p_fnar_rec.creation_date                   ;
2257     f_created_by                     :=  p_fnar_rec.created_by                      ;
2258     f_last_updated_by                :=  p_fnar_rec.last_updated_by                 ;
2259     f_last_update_date               :=  p_fnar_rec.last_update_date                ;
2260     f_last_update_login              :=  p_fnar_rec.last_update_login               ;
2261     f_opt_ind_stu_ipt_assets_flag    :=  p_fnar_rec.option_ind_stu_ipt_assets_flag  ;
2262     f_cust_parent_cont_adj_num       :=  p_fnar_rec.cust_parent_cont_adj_num        ;
2263     f_custodial_parent_num           :=  p_fnar_rec.custodial_parent_num            ;
2264     f_cust_par_base_prcnt_inc_amt    :=  p_fnar_rec.cust_par_base_prcnt_inc_amt     ;
2265     f_cust_par_base_cont_inc_amt     :=  p_fnar_rec.cust_par_base_cont_inc_amt      ;
2266     f_cust_par_base_cont_ast_amt     :=  p_fnar_rec.cust_par_base_cont_ast_amt      ;
2267     f_cust_par_base_tot_cont_amt     :=  p_fnar_rec.cust_par_base_tot_cont_amt      ;
2268     f_cust_par_opt_prcnt_inc_amt     :=  p_fnar_rec.cust_par_opt_prcnt_inc_amt      ;
2269     f_cust_par_opt_cont_inc_amt      :=  p_fnar_rec.cust_par_opt_cont_inc_amt       ;
2270     f_cust_par_opt_cont_ast_amt      :=  p_fnar_rec.cust_par_opt_cont_ast_amt       ;
2271     f_cust_par_opt_tot_cont_amt      :=  p_fnar_rec.cust_par_opt_tot_cont_amt       ;
2272     f_parents_email_txt              :=  p_fnar_rec.parents_email_txt               ;
2273     f_parent_1_birth_date            :=  p_fnar_rec.parent_1_birth_date             ;
2274     f_parent_2_birth_date            :=  p_fnar_rec.parent_2_birth_date             ;
2275 
2276 
2277    if p_user_hook = TRUE then
2278       return 'true';
2279     else
2280       return 'false';
2281     end if;
2282 
2283     return 'true';
2284 
2285   END callHook;
2286 
2287 END igf_ap_uhk_inas_pkg;