1 PACKAGE igf_ap_uhk_inas_pkg AS
2 /* $Header: IGFAP46S.pls 120.0 2005/06/01 14:42:32 appldev noship $ */
3 ------------------------------------------------------------------
4 --Created by : veramach, Oracle India
5 --Date created: 30-SEP-2003
6 --
7 --Purpose:the user-hook function which calculates IM EFC using INAS
8 --
9 --
10 --Known limitations/enhancements and/or remarks:
11 --
12 --Change History:
13 --Who When What
14 --veramach 02-Nov-2004 FA 152 - Added efc_i_award_prd
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;
23
24 FUNCTION efc_i_award_prd(
25 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
26 p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
27 ) RETURN NUMBER;
28
29 FUNCTION callHook(
30 p_sys_awd_year IN igf_ap_batch_aw_map.sys_award_year%TYPE,
31
32 pr_cssp_id IN OUT NOCOPY igf_ap_css_profile.cssp_id%TYPE ,
33 pr_org_id IN OUT NOCOPY igf_ap_css_profile.org_id%TYPE ,
34 pr_base_id IN OUT NOCOPY igf_ap_css_profile.base_id%TYPE ,
35 pr_system_record_type IN OUT NOCOPY igf_ap_css_profile.system_record_type%TYPE ,
36 pr_active_profile IN OUT NOCOPY igf_ap_css_profile.active_profile%TYPE ,
37 pr_college_code IN OUT NOCOPY igf_ap_css_profile.college_code%TYPE ,
38 pr_academic_year IN OUT NOCOPY igf_ap_css_profile.academic_year%TYPE ,
39 pr_stu_record_type IN OUT NOCOPY igf_ap_css_profile.stu_record_type%TYPE ,
40 pr_css_id_number IN OUT NOCOPY igf_ap_css_profile.css_id_number%TYPE ,
41 pr_registration_receipt_date IN OUT NOCOPY igf_ap_css_profile.registration_receipt_date%TYPE ,
42 pr_registration_type IN OUT NOCOPY igf_ap_css_profile.registration_type%TYPE ,
43 pr_application_receipt_date IN OUT NOCOPY igf_ap_css_profile.application_receipt_date%TYPE ,
44 pr_application_type IN OUT NOCOPY igf_ap_css_profile.application_type%TYPE ,
45 pr_original_fnar_compute IN OUT NOCOPY igf_ap_css_profile.original_fnar_compute%TYPE ,
46 pr_revision_fnar_compute_date IN OUT NOCOPY igf_ap_css_profile.revision_fnar_compute_date%TYPE ,
47 pr_electronic_extract_date IN OUT NOCOPY igf_ap_css_profile.electronic_extract_date%TYPE ,
48 pr_inst_reporting_type IN OUT NOCOPY igf_ap_css_profile.institutional_reporting_type%TYPE ,
49 pr_asr_receipt_date IN OUT NOCOPY igf_ap_css_profile.asr_receipt_date%TYPE ,
50 pr_last_name IN OUT NOCOPY igf_ap_css_profile.last_name%TYPE ,
51 pr_first_name IN OUT NOCOPY igf_ap_css_profile.first_name%TYPE ,
52 pr_middle_initial IN OUT NOCOPY igf_ap_css_profile.middle_initial%TYPE ,
53 pr_address_number_and_street IN OUT NOCOPY igf_ap_css_profile.address_number_and_street%TYPE ,
54 pr_city IN OUT NOCOPY igf_ap_css_profile.city%TYPE ,
55 pr_state_mailing IN OUT NOCOPY igf_ap_css_profile.state_mailing%TYPE ,
56 pr_zip_code IN OUT NOCOPY igf_ap_css_profile.zip_code%TYPE ,
57 pr_s_telephone_number IN OUT NOCOPY igf_ap_css_profile.s_telephone_number%TYPE ,
58 pr_s_title IN OUT NOCOPY igf_ap_css_profile.s_title%TYPE ,
59 pr_date_of_birth IN OUT NOCOPY igf_ap_css_profile.date_of_birth%TYPE ,
60 pr_social_security_number IN OUT NOCOPY igf_ap_css_profile.social_security_number%TYPE ,
61 pr_state_legal_residence IN OUT NOCOPY igf_ap_css_profile.state_legal_residence%TYPE ,
62 pr_foreign_address_indicator IN OUT NOCOPY igf_ap_css_profile.foreign_address_indicator%TYPE ,
63 pr_foreign_postal_code IN OUT NOCOPY igf_ap_css_profile.foreign_postal_code%TYPE ,
64 pr_country IN OUT NOCOPY igf_ap_css_profile.country%TYPE ,
65 pr_financial_aid_status IN OUT NOCOPY igf_ap_css_profile.financial_aid_status%TYPE ,
66 pr_year_in_college IN OUT NOCOPY igf_ap_css_profile.year_in_college%TYPE ,
67 pr_marital_status IN OUT NOCOPY igf_ap_css_profile.marital_status%TYPE ,
68 pr_ward_court IN OUT NOCOPY igf_ap_css_profile.ward_court%TYPE ,
69 pr_legal_dependents_other IN OUT NOCOPY igf_ap_css_profile.legal_dependents_other%TYPE ,
70 pr_household_size IN OUT NOCOPY igf_ap_css_profile.household_size%TYPE ,
71 pr_number_in_college IN OUT NOCOPY igf_ap_css_profile.number_in_college%TYPE ,
72 pr_citizenship_status IN OUT NOCOPY igf_ap_css_profile.citizenship_status%TYPE ,
73 pr_citizenship_country IN OUT NOCOPY igf_ap_css_profile.citizenship_country%TYPE ,
74 pr_visa_classification IN OUT NOCOPY igf_ap_css_profile.visa_classification%TYPE ,
75 pr_tax_figures IN OUT NOCOPY igf_ap_css_profile.tax_figures%TYPE ,
76 pr_number_exemptions IN OUT NOCOPY igf_ap_css_profile.number_exemptions%TYPE ,
77 pr_adjusted_gross_inc IN OUT NOCOPY igf_ap_css_profile.adjusted_gross_inc%TYPE ,
78 pr_us_tax_paid IN OUT NOCOPY igf_ap_css_profile.us_tax_paid%TYPE ,
79 pr_itemized_deductions IN OUT NOCOPY igf_ap_css_profile.itemized_deductions%TYPE ,
80 pr_stu_income_work IN OUT NOCOPY igf_ap_css_profile.stu_income_work%TYPE ,
81 pr_spouse_income_work IN OUT NOCOPY igf_ap_css_profile.spouse_income_work%TYPE ,
82 pr_divid_int_inc IN OUT NOCOPY igf_ap_css_profile.divid_int_inc%TYPE ,
83 pr_soc_sec_benefits IN OUT NOCOPY igf_ap_css_profile.soc_sec_benefits%TYPE ,
84 pr_welfare_tanf IN OUT NOCOPY igf_ap_css_profile.welfare_tanf%TYPE ,
85 pr_child_supp_rcvd IN OUT NOCOPY igf_ap_css_profile.child_supp_rcvd%TYPE ,
86 pr_earned_income_credit IN OUT NOCOPY igf_ap_css_profile.earned_income_credit%TYPE ,
87 pr_other_untax_income IN OUT NOCOPY igf_ap_css_profile.other_untax_income%TYPE ,
88 pr_tax_stu_aid IN OUT NOCOPY igf_ap_css_profile.tax_stu_aid%TYPE ,
89 pr_cash_sav_check IN OUT NOCOPY igf_ap_css_profile.cash_sav_check%TYPE ,
90 pr_ira_keogh IN OUT NOCOPY igf_ap_css_profile.ira_keogh%TYPE ,
91 pr_invest_value IN OUT NOCOPY igf_ap_css_profile.invest_value%TYPE ,
92 pr_invest_debt IN OUT NOCOPY igf_ap_css_profile.invest_debt%TYPE ,
93 pr_home_value IN OUT NOCOPY igf_ap_css_profile.home_value%TYPE ,
94 pr_home_debt IN OUT NOCOPY igf_ap_css_profile.home_debt%TYPE ,
95 pr_oth_real_value IN OUT NOCOPY igf_ap_css_profile.oth_real_value%TYPE ,
96 pr_oth_real_debt IN OUT NOCOPY igf_ap_css_profile.oth_real_debt%TYPE ,
97 pr_bus_farm_value IN OUT NOCOPY igf_ap_css_profile.bus_farm_value%TYPE ,
98 pr_bus_farm_debt IN OUT NOCOPY igf_ap_css_profile.bus_farm_debt%TYPE ,
99 pr_live_on_farm IN OUT NOCOPY igf_ap_css_profile.live_on_farm%TYPE ,
100 pr_home_purch_price IN OUT NOCOPY igf_ap_css_profile.home_purch_price%TYPE ,
101 pr_hope_ll_credit IN OUT NOCOPY igf_ap_css_profile.hope_ll_credit%TYPE ,
102 pr_home_purch_year IN OUT NOCOPY igf_ap_css_profile.home_purch_year%TYPE ,
103 pr_trust_amount IN OUT NOCOPY igf_ap_css_profile.trust_amount%TYPE ,
104 pr_trust_avail IN OUT NOCOPY igf_ap_css_profile.trust_avail%TYPE ,
105 pr_trust_estab IN OUT NOCOPY igf_ap_css_profile.trust_estab%TYPE ,
106 pr_child_support_paid IN OUT NOCOPY igf_ap_css_profile.child_support_paid%TYPE ,
107 pr_med_dent_expenses IN OUT NOCOPY igf_ap_css_profile.med_dent_expenses%TYPE ,
108 pr_vet_us IN OUT NOCOPY igf_ap_css_profile.vet_us%TYPE ,
109 pr_vet_ben_amount IN OUT NOCOPY igf_ap_css_profile.vet_ben_amount%TYPE ,
110 pr_vet_ben_months IN OUT NOCOPY igf_ap_css_profile.vet_ben_months%TYPE ,
111 pr_stu_summer_wages IN OUT NOCOPY igf_ap_css_profile.stu_summer_wages%TYPE ,
112 pr_stu_school_yr_wages IN OUT NOCOPY igf_ap_css_profile.stu_school_yr_wages%TYPE ,
113 pr_spouse_summer_wages IN OUT NOCOPY igf_ap_css_profile.spouse_summer_wages%TYPE ,
114 pr_spouse_school_yr_wages IN OUT NOCOPY igf_ap_css_profile.spouse_school_yr_wages%TYPE ,
115 pr_summer_other_tax_inc IN OUT NOCOPY igf_ap_css_profile.summer_other_tax_inc%TYPE ,
116 pr_school_yr_other_tax_inc IN OUT NOCOPY igf_ap_css_profile.school_yr_other_tax_inc%TYPE ,
117 pr_summer_untax_inc IN OUT NOCOPY igf_ap_css_profile.summer_untax_inc%TYPE ,
118 pr_school_yr_untax_inc IN OUT NOCOPY igf_ap_css_profile.school_yr_untax_inc%TYPE ,
119 pr_grants_schol_etc IN OUT NOCOPY igf_ap_css_profile.grants_schol_etc%TYPE ,
120 pr_tuit_benefits IN OUT NOCOPY igf_ap_css_profile.tuit_benefits%TYPE ,
121 pr_cont_parents IN OUT NOCOPY igf_ap_css_profile.cont_parents%TYPE ,
122 pr_cont_relatives IN OUT NOCOPY igf_ap_css_profile.cont_relatives%TYPE ,
123 pr_p_siblings_pre_tuit IN OUT NOCOPY igf_ap_css_profile.p_siblings_pre_tuit%TYPE ,
124 pr_p_student_pre_tuit IN OUT NOCOPY igf_ap_css_profile.p_student_pre_tuit%TYPE ,
125 pr_p_household_size IN OUT NOCOPY igf_ap_css_profile.p_household_size%TYPE ,
126 pr_p_number_in_college IN OUT NOCOPY igf_ap_css_profile.p_number_in_college%TYPE ,
127 pr_p_parents_in_college IN OUT NOCOPY igf_ap_css_profile.p_parents_in_college%TYPE ,
128 pr_p_marital_status IN OUT NOCOPY igf_ap_css_profile.p_marital_status%TYPE ,
129 pr_p_state_legal_residence IN OUT NOCOPY igf_ap_css_profile.p_state_legal_residence%TYPE ,
130 pr_p_natural_par_status IN OUT NOCOPY igf_ap_css_profile.p_natural_par_status%TYPE ,
131 pr_p_child_supp_paid IN OUT NOCOPY igf_ap_css_profile.p_child_supp_paid%TYPE ,
132 pr_p_repay_ed_loans IN OUT NOCOPY igf_ap_css_profile.p_repay_ed_loans%TYPE ,
133 pr_p_med_dent_expenses IN OUT NOCOPY igf_ap_css_profile.p_med_dent_expenses%TYPE ,
134 pr_p_tuit_paid_amount IN OUT NOCOPY igf_ap_css_profile.p_tuit_paid_amount%TYPE ,
135 pr_p_tuit_paid_number IN OUT NOCOPY igf_ap_css_profile.p_tuit_paid_number%TYPE ,
136 pr_p_exp_child_supp_paid IN OUT NOCOPY igf_ap_css_profile.p_exp_child_supp_paid%TYPE ,
137 pr_p_exp_repay_ed_loans IN OUT NOCOPY igf_ap_css_profile.p_exp_repay_ed_loans%TYPE ,
138 pr_p_exp_med_dent_expenses IN OUT NOCOPY igf_ap_css_profile.p_exp_med_dent_expenses%TYPE ,
139 pr_p_exp_tuit_pd_amount IN OUT NOCOPY igf_ap_css_profile.p_exp_tuit_pd_amount%TYPE ,
140 pr_p_exp_tuit_pd_number IN OUT NOCOPY igf_ap_css_profile.p_exp_tuit_pd_number%TYPE ,
141 pr_p_cash_sav_check IN OUT NOCOPY igf_ap_css_profile.p_cash_sav_check%TYPE ,
142 pr_p_month_mortgage_pay IN OUT NOCOPY igf_ap_css_profile.p_month_mortgage_pay%TYPE ,
143 pr_p_invest_value IN OUT NOCOPY igf_ap_css_profile.p_invest_value%TYPE ,
144 pr_p_invest_debt IN OUT NOCOPY igf_ap_css_profile.p_invest_debt%TYPE ,
145 pr_p_home_value IN OUT NOCOPY igf_ap_css_profile.p_home_value%TYPE ,
146 pr_p_home_debt IN OUT NOCOPY igf_ap_css_profile.p_home_debt%TYPE ,
147 pr_p_home_purch_price IN OUT NOCOPY igf_ap_css_profile.p_home_purch_price%TYPE ,
148 pr_p_own_business_farm IN OUT NOCOPY igf_ap_css_profile.p_own_business_farm%TYPE ,
149 pr_p_business_value IN OUT NOCOPY igf_ap_css_profile.p_business_value%TYPE ,
150 pr_p_business_debt IN OUT NOCOPY igf_ap_css_profile.p_business_debt%TYPE ,
151 pr_p_farm_value IN OUT NOCOPY igf_ap_css_profile.p_farm_value%TYPE ,
152 pr_p_farm_debt IN OUT NOCOPY igf_ap_css_profile.p_farm_debt%TYPE ,
153 pr_p_live_on_farm IN OUT NOCOPY igf_ap_css_profile.p_live_on_farm%TYPE ,
154 pr_p_oth_real_estate_value IN OUT NOCOPY igf_ap_css_profile.p_oth_real_estate_value%TYPE ,
155 pr_p_oth_real_estate_debt IN OUT NOCOPY igf_ap_css_profile.p_oth_real_estate_debt%TYPE ,
156 pr_p_oth_real_purch_price IN OUT NOCOPY igf_ap_css_profile.p_oth_real_purch_price%TYPE ,
157 pr_p_siblings_assets IN OUT NOCOPY igf_ap_css_profile.p_siblings_assets%TYPE ,
158 pr_p_home_purch_year IN OUT NOCOPY igf_ap_css_profile.p_home_purch_year%TYPE ,
159 pr_p_oth_real_purch_year IN OUT NOCOPY igf_ap_css_profile.p_oth_real_purch_year%TYPE ,
160 pr_p_prior_agi IN OUT NOCOPY igf_ap_css_profile.p_prior_agi%TYPE ,
161 pr_p_prior_us_tax_paid IN OUT NOCOPY igf_ap_css_profile.p_prior_us_tax_paid%TYPE ,
162 pr_p_prior_item_deductions IN OUT NOCOPY igf_ap_css_profile.p_prior_item_deductions%TYPE ,
163 pr_p_prior_other_untax_inc IN OUT NOCOPY igf_ap_css_profile.p_prior_other_untax_inc%TYPE ,
164 pr_p_tax_figures IN OUT NOCOPY igf_ap_css_profile.p_tax_figures%TYPE ,
165 pr_p_number_exemptions IN OUT NOCOPY igf_ap_css_profile.p_number_exemptions%TYPE ,
166 pr_p_adjusted_gross_inc IN OUT NOCOPY igf_ap_css_profile.p_adjusted_gross_inc%TYPE ,
167 pr_p_wages_sal_tips IN OUT NOCOPY igf_ap_css_profile.p_wages_sal_tips%TYPE ,
168 pr_p_interest_income IN OUT NOCOPY igf_ap_css_profile.p_interest_income%TYPE ,
169 pr_p_dividend_income IN OUT NOCOPY igf_ap_css_profile.p_dividend_income%TYPE ,
170 pr_p_net_inc_bus_farm IN OUT NOCOPY igf_ap_css_profile.p_net_inc_bus_farm%TYPE ,
171 pr_p_other_taxable_income IN OUT NOCOPY igf_ap_css_profile.p_other_taxable_income%TYPE ,
172 pr_p_adj_to_income IN OUT NOCOPY igf_ap_css_profile.p_adj_to_income%TYPE ,
173 pr_p_us_tax_paid IN OUT NOCOPY igf_ap_css_profile.p_us_tax_paid%TYPE ,
174 pr_p_itemized_deductions IN OUT NOCOPY igf_ap_css_profile.p_itemized_deductions%TYPE ,
175 pr_p_father_income_work IN OUT NOCOPY igf_ap_css_profile.p_father_income_work%TYPE ,
176 pr_p_mother_income_work IN OUT NOCOPY igf_ap_css_profile.p_mother_income_work%TYPE ,
177 pr_p_soc_sec_ben IN OUT NOCOPY igf_ap_css_profile.p_soc_sec_ben%TYPE ,
178 pr_p_welfare_tanf IN OUT NOCOPY igf_ap_css_profile.p_welfare_tanf%TYPE ,
179 pr_p_child_supp_rcvd IN OUT NOCOPY igf_ap_css_profile.p_child_supp_rcvd%TYPE ,
180 pr_p_ded_ira_keogh IN OUT NOCOPY igf_ap_css_profile.p_ded_ira_keogh%TYPE ,
181 pr_p_tax_defer_pens_savs IN OUT NOCOPY igf_ap_css_profile.p_tax_defer_pens_savs%TYPE ,
182 pr_p_dep_care_med_spending IN OUT NOCOPY igf_ap_css_profile.p_dep_care_med_spending%TYPE ,
183 pr_p_earned_income_credit IN OUT NOCOPY igf_ap_css_profile.p_earned_income_credit%TYPE ,
184 pr_p_living_allow IN OUT NOCOPY igf_ap_css_profile.p_living_allow%TYPE ,
185 pr_p_tax_exmpt_int IN OUT NOCOPY igf_ap_css_profile.p_tax_exmpt_int%TYPE ,
186 pr_p_foreign_inc_excl IN OUT NOCOPY igf_ap_css_profile.p_foreign_inc_excl%TYPE ,
187 pr_p_other_untax_inc IN OUT NOCOPY igf_ap_css_profile.p_other_untax_inc%TYPE ,
188 pr_p_hope_ll_credit IN OUT NOCOPY igf_ap_css_profile.p_hope_ll_credit%TYPE ,
189 pr_p_yr_separation IN OUT NOCOPY igf_ap_css_profile.p_yr_separation%TYPE ,
190 pr_p_yr_divorce IN OUT NOCOPY igf_ap_css_profile.p_yr_divorce%TYPE ,
191 pr_p_exp_father_inc IN OUT NOCOPY igf_ap_css_profile.p_exp_father_inc%TYPE ,
192 pr_p_exp_mother_inc IN OUT NOCOPY igf_ap_css_profile.p_exp_mother_inc%TYPE ,
193 pr_p_exp_other_tax_inc IN OUT NOCOPY igf_ap_css_profile.p_exp_other_tax_inc%TYPE ,
194 pr_p_exp_other_untax_inc IN OUT NOCOPY igf_ap_css_profile.p_exp_other_untax_inc%TYPE ,
195 pr_line_2_relation IN OUT NOCOPY igf_ap_css_profile.line_2_relation%TYPE ,
196 pr_line_2_attend_college IN OUT NOCOPY igf_ap_css_profile.line_2_attend_college%TYPE ,
197 pr_line_3_relation IN OUT NOCOPY igf_ap_css_profile.line_3_relation%TYPE ,
198 pr_line_3_attend_college IN OUT NOCOPY igf_ap_css_profile.line_3_attend_college%TYPE ,
199 pr_line_4_relation IN OUT NOCOPY igf_ap_css_profile.line_4_relation%TYPE ,
200 pr_line_4_attend_college IN OUT NOCOPY igf_ap_css_profile.line_4_attend_college%TYPE ,
201 pr_line_5_relation IN OUT NOCOPY igf_ap_css_profile.line_5_relation%TYPE ,
202 pr_line_5_attend_college IN OUT NOCOPY igf_ap_css_profile.line_5_attend_college%TYPE ,
203 pr_line_6_relation IN OUT NOCOPY igf_ap_css_profile.line_6_relation%TYPE ,
204 pr_line_6_attend_college IN OUT NOCOPY igf_ap_css_profile.line_6_attend_college%TYPE ,
205 pr_line_7_relation IN OUT NOCOPY igf_ap_css_profile.line_7_relation%TYPE ,
206 pr_line_7_attend_college IN OUT NOCOPY igf_ap_css_profile.line_7_attend_college%TYPE ,
207 pr_line_8_relation IN OUT NOCOPY igf_ap_css_profile.line_8_relation%TYPE ,
208 pr_line_8_attend_college IN OUT NOCOPY igf_ap_css_profile.line_8_attend_college%TYPE ,
209 pr_p_age_father IN OUT NOCOPY igf_ap_css_profile.p_age_father%TYPE ,
210 pr_p_age_mother IN OUT NOCOPY igf_ap_css_profile.p_age_mother%TYPE ,
211 pr_p_div_sep_ind IN OUT NOCOPY igf_ap_css_profile.p_div_sep_ind%TYPE ,
212 pr_b_cont_non_custodial_par IN OUT NOCOPY igf_ap_css_profile.b_cont_non_custodial_par%TYPE ,
213 pr_college_type_2 IN OUT NOCOPY igf_ap_css_profile.college_type_2%TYPE ,
214 pr_college_type_3 IN OUT NOCOPY igf_ap_css_profile.college_type_3%TYPE ,
215 pr_college_type_4 IN OUT NOCOPY igf_ap_css_profile.college_type_4%TYPE ,
216 pr_college_type_5 IN OUT NOCOPY igf_ap_css_profile.college_type_5%TYPE ,
217 pr_college_type_6 IN OUT NOCOPY igf_ap_css_profile.college_type_6%TYPE ,
218 pr_college_type_7 IN OUT NOCOPY igf_ap_css_profile.college_type_7%TYPE ,
219 pr_college_type_8 IN OUT NOCOPY igf_ap_css_profile.college_type_8%TYPE ,
220 pr_school_code_1 IN OUT NOCOPY igf_ap_css_profile.school_code_1%TYPE ,
221 pr_housing_code_1 IN OUT NOCOPY igf_ap_css_profile.housing_code_1%TYPE ,
222 pr_school_code_2 IN OUT NOCOPY igf_ap_css_profile.school_code_2%TYPE ,
223 pr_housing_code_2 IN OUT NOCOPY igf_ap_css_profile.housing_code_2%TYPE ,
224 pr_school_code_3 IN OUT NOCOPY igf_ap_css_profile.school_code_3%TYPE ,
225 pr_housing_code_3 IN OUT NOCOPY igf_ap_css_profile.housing_code_3%TYPE ,
226 pr_school_code_4 IN OUT NOCOPY igf_ap_css_profile.school_code_4%TYPE ,
227 pr_housing_code_4 IN OUT NOCOPY igf_ap_css_profile.housing_code_4%TYPE ,
228 pr_school_code_5 IN OUT NOCOPY igf_ap_css_profile.school_code_5%TYPE ,
229 pr_housing_code_5 IN OUT NOCOPY igf_ap_css_profile.housing_code_5%TYPE ,
230 pr_school_code_6 IN OUT NOCOPY igf_ap_css_profile.school_code_6%TYPE ,
231 pr_housing_code_6 IN OUT NOCOPY igf_ap_css_profile.housing_code_6%TYPE ,
232 pr_school_code_7 IN OUT NOCOPY igf_ap_css_profile.school_code_7%TYPE ,
233 pr_housing_code_7 IN OUT NOCOPY igf_ap_css_profile.housing_code_7%TYPE ,
234 pr_school_code_8 IN OUT NOCOPY igf_ap_css_profile.school_code_8%TYPE ,
235 pr_housing_code_8 IN OUT NOCOPY igf_ap_css_profile.housing_code_8%TYPE ,
236 pr_school_code_9 IN OUT NOCOPY igf_ap_css_profile.school_code_9%TYPE ,
237 pr_housing_code_9 IN OUT NOCOPY igf_ap_css_profile.housing_code_9%TYPE ,
238 pr_school_code_10 IN OUT NOCOPY igf_ap_css_profile.school_code_10%TYPE ,
239 pr_housing_code_10 IN OUT NOCOPY igf_ap_css_profile.housing_code_10%TYPE ,
240 pr_additional_school_code_1 IN OUT NOCOPY igf_ap_css_profile.additional_school_code_1%TYPE ,
241 pr_additional_school_code_2 IN OUT NOCOPY igf_ap_css_profile.additional_school_code_2%TYPE ,
242 pr_additional_school_code_3 IN OUT NOCOPY igf_ap_css_profile.additional_school_code_3%TYPE ,
243 pr_additional_school_code_4 IN OUT NOCOPY igf_ap_css_profile.additional_school_code_4%TYPE ,
244 pr_additional_school_code_5 IN OUT NOCOPY igf_ap_css_profile.additional_school_code_5%TYPE ,
245 pr_additional_school_code_6 IN OUT NOCOPY igf_ap_css_profile.additional_school_code_6%TYPE ,
246 pr_additional_school_code_7 IN OUT NOCOPY igf_ap_css_profile.additional_school_code_7%TYPE ,
247 pr_additional_school_code_8 IN OUT NOCOPY igf_ap_css_profile.additional_school_code_8%TYPE ,
248 pr_additional_school_code_9 IN OUT NOCOPY igf_ap_css_profile.additional_school_code_9%TYPE ,
249 pr_additional_school_code_10 IN OUT NOCOPY igf_ap_css_profile.additional_school_code_10%TYPE ,
250 pr_explanation_spec_circum IN OUT NOCOPY igf_ap_css_profile.explanation_spec_circum%TYPE ,
251 pr_signature_student IN OUT NOCOPY igf_ap_css_profile.signature_student%TYPE ,
252 pr_signature_spouse IN OUT NOCOPY igf_ap_css_profile.signature_spouse%TYPE ,
253 pr_signature_father IN OUT NOCOPY igf_ap_css_profile.signature_father%TYPE ,
254 pr_signature_mother IN OUT NOCOPY igf_ap_css_profile.signature_mother%TYPE ,
255 pr_month_day_completed IN OUT NOCOPY igf_ap_css_profile.month_day_completed%TYPE ,
256 pr_year_completed IN OUT NOCOPY igf_ap_css_profile.year_completed%TYPE ,
257 pr_age_line_2 IN OUT NOCOPY igf_ap_css_profile.age_line_2%TYPE ,
258 pr_age_line_3 IN OUT NOCOPY igf_ap_css_profile.age_line_3%TYPE ,
259 pr_age_line_4 IN OUT NOCOPY igf_ap_css_profile.age_line_4%TYPE ,
260 pr_age_line_5 IN OUT NOCOPY igf_ap_css_profile.age_line_5%TYPE ,
261 pr_age_line_6 IN OUT NOCOPY igf_ap_css_profile.age_line_6%TYPE ,
262 pr_age_line_7 IN OUT NOCOPY igf_ap_css_profile.age_line_7%TYPE ,
263 pr_age_line_8 IN OUT NOCOPY igf_ap_css_profile.age_line_8%TYPE ,
264 pr_a_online_signature IN OUT NOCOPY igf_ap_css_profile.a_online_signature%TYPE ,
265 pr_question_1_number IN OUT NOCOPY igf_ap_css_profile.question_1_number%TYPE ,
266 pr_question_1_size IN OUT NOCOPY igf_ap_css_profile.question_1_size%TYPE ,
267 pr_question_1_answer IN OUT NOCOPY igf_ap_css_profile.question_1_answer%TYPE ,
268 pr_question_2_number IN OUT NOCOPY igf_ap_css_profile.question_2_number%TYPE ,
269 pr_question_2_size IN OUT NOCOPY igf_ap_css_profile.question_2_size%TYPE ,
270 pr_question_2_answer IN OUT NOCOPY igf_ap_css_profile.question_2_answer%TYPE ,
271 pr_question_3_number IN OUT NOCOPY igf_ap_css_profile.question_3_number%TYPE ,
272 pr_question_3_size IN OUT NOCOPY igf_ap_css_profile.question_3_size%TYPE ,
273 pr_question_3_answer IN OUT NOCOPY igf_ap_css_profile.question_3_answer%TYPE ,
274 pr_question_4_number IN OUT NOCOPY igf_ap_css_profile.question_4_number%TYPE ,
275 pr_question_4_size IN OUT NOCOPY igf_ap_css_profile.question_4_size%TYPE ,
276 pr_question_4_answer IN OUT NOCOPY igf_ap_css_profile.question_4_answer%TYPE ,
277 pr_question_5_number IN OUT NOCOPY igf_ap_css_profile.question_5_number%TYPE ,
278 pr_question_5_size IN OUT NOCOPY igf_ap_css_profile.question_5_size%TYPE ,
279 pr_question_5_answer IN OUT NOCOPY igf_ap_css_profile.question_5_answer%TYPE ,
280 pr_question_6_number IN OUT NOCOPY igf_ap_css_profile.question_6_number%TYPE ,
281 pr_question_6_size IN OUT NOCOPY igf_ap_css_profile.question_6_size%TYPE ,
282 pr_question_6_answer IN OUT NOCOPY igf_ap_css_profile.question_6_answer%TYPE ,
283 pr_question_7_number IN OUT NOCOPY igf_ap_css_profile.question_7_number%TYPE ,
284 pr_question_7_size IN OUT NOCOPY igf_ap_css_profile.question_7_size%TYPE ,
285 pr_question_7_answer IN OUT NOCOPY igf_ap_css_profile.question_7_answer%TYPE ,
286 pr_question_8_number IN OUT NOCOPY igf_ap_css_profile.question_8_number%TYPE ,
287 pr_question_8_size IN OUT NOCOPY igf_ap_css_profile.question_8_size%TYPE ,
288 pr_question_8_answer IN OUT NOCOPY igf_ap_css_profile.question_8_answer%TYPE ,
289 pr_question_9_number IN OUT NOCOPY igf_ap_css_profile.question_9_number%TYPE ,
290 pr_question_9_size IN OUT NOCOPY igf_ap_css_profile.question_9_size%TYPE ,
291 pr_question_9_answer IN OUT NOCOPY igf_ap_css_profile.question_9_answer%TYPE ,
292 pr_question_10_number IN OUT NOCOPY igf_ap_css_profile.question_10_number%TYPE ,
293 pr_question_10_size IN OUT NOCOPY igf_ap_css_profile.question_10_size%TYPE ,
294 pr_question_10_answer IN OUT NOCOPY igf_ap_css_profile.question_10_answer%TYPE ,
295 pr_question_11_number IN OUT NOCOPY igf_ap_css_profile.question_11_number%TYPE ,
296 pr_question_11_size IN OUT NOCOPY igf_ap_css_profile.question_11_size%TYPE ,
297 pr_question_11_answer IN OUT NOCOPY igf_ap_css_profile.question_11_answer%TYPE ,
298 pr_question_12_number IN OUT NOCOPY igf_ap_css_profile.question_12_number%TYPE ,
299 pr_question_12_size IN OUT NOCOPY igf_ap_css_profile.question_12_size%TYPE ,
300 pr_question_12_answer IN OUT NOCOPY igf_ap_css_profile.question_12_answer%TYPE ,
301 pr_question_13_number IN OUT NOCOPY igf_ap_css_profile.question_13_number%TYPE ,
302 pr_question_13_size IN OUT NOCOPY igf_ap_css_profile.question_13_size%TYPE ,
303 pr_question_13_answer IN OUT NOCOPY igf_ap_css_profile.question_13_answer%TYPE ,
304 pr_question_14_number IN OUT NOCOPY igf_ap_css_profile.question_14_number%TYPE ,
305 pr_question_14_size IN OUT NOCOPY igf_ap_css_profile.question_14_size%TYPE ,
306 pr_question_14_answer IN OUT NOCOPY igf_ap_css_profile.question_14_answer%TYPE ,
307 pr_question_15_number IN OUT NOCOPY igf_ap_css_profile.question_15_number%TYPE ,
308 pr_question_15_size IN OUT NOCOPY igf_ap_css_profile.question_15_size%TYPE ,
309 pr_question_15_answer IN OUT NOCOPY igf_ap_css_profile.question_15_answer%TYPE ,
310 pr_question_16_number IN OUT NOCOPY igf_ap_css_profile.question_16_number%TYPE ,
311 pr_question_16_size IN OUT NOCOPY igf_ap_css_profile.question_16_size%TYPE ,
312 pr_question_16_answer IN OUT NOCOPY igf_ap_css_profile.question_16_answer%TYPE ,
313 pr_question_17_number IN OUT NOCOPY igf_ap_css_profile.question_17_number%TYPE ,
314 pr_question_17_size IN OUT NOCOPY igf_ap_css_profile.question_17_size%TYPE ,
315 pr_question_17_answer IN OUT NOCOPY igf_ap_css_profile.question_17_answer%TYPE ,
316 pr_question_18_number IN OUT NOCOPY igf_ap_css_profile.question_18_number%TYPE ,
317 pr_question_18_size IN OUT NOCOPY igf_ap_css_profile.question_18_size%TYPE ,
318 pr_question_18_answer IN OUT NOCOPY igf_ap_css_profile.question_18_answer%TYPE ,
319 pr_question_19_number IN OUT NOCOPY igf_ap_css_profile.question_19_number%TYPE ,
320 pr_question_19_size IN OUT NOCOPY igf_ap_css_profile.question_19_size%TYPE ,
321 pr_question_19_answer IN OUT NOCOPY igf_ap_css_profile.question_19_answer%TYPE ,
322 pr_question_20_number IN OUT NOCOPY igf_ap_css_profile.question_20_number%TYPE ,
323 pr_question_20_size IN OUT NOCOPY igf_ap_css_profile.question_20_size%TYPE ,
324 pr_question_20_answer IN OUT NOCOPY igf_ap_css_profile.question_20_answer%TYPE ,
325 pr_question_21_number IN OUT NOCOPY igf_ap_css_profile.question_21_number%TYPE ,
326 pr_question_21_size IN OUT NOCOPY igf_ap_css_profile.question_21_size%TYPE ,
327 pr_question_21_answer IN OUT NOCOPY igf_ap_css_profile.question_21_answer%TYPE ,
328 pr_question_22_number IN OUT NOCOPY igf_ap_css_profile.question_22_number%TYPE ,
329 pr_question_22_size IN OUT NOCOPY igf_ap_css_profile.question_22_size%TYPE ,
330 pr_question_22_answer IN OUT NOCOPY igf_ap_css_profile.question_22_answer%TYPE ,
331 pr_question_23_number IN OUT NOCOPY igf_ap_css_profile.question_23_number%TYPE ,
332 pr_question_23_size IN OUT NOCOPY igf_ap_css_profile.question_23_size%TYPE ,
333 pr_question_23_answer IN OUT NOCOPY igf_ap_css_profile.question_23_answer%TYPE ,
334 pr_question_24_number IN OUT NOCOPY igf_ap_css_profile.question_24_number%TYPE ,
335 pr_question_24_size IN OUT NOCOPY igf_ap_css_profile.question_24_size%TYPE ,
336 pr_question_24_answer IN OUT NOCOPY igf_ap_css_profile.question_24_answer%TYPE ,
337 pr_question_25_number IN OUT NOCOPY igf_ap_css_profile.question_25_number%TYPE ,
338 pr_question_25_size IN OUT NOCOPY igf_ap_css_profile.question_25_size%TYPE ,
339 pr_question_25_answer IN OUT NOCOPY igf_ap_css_profile.question_25_answer%TYPE ,
340 pr_question_26_number IN OUT NOCOPY igf_ap_css_profile.question_26_number%TYPE ,
341 pr_question_26_size IN OUT NOCOPY igf_ap_css_profile.question_26_size%TYPE ,
342 pr_question_26_answer IN OUT NOCOPY igf_ap_css_profile.question_26_answer%TYPE ,
343 pr_question_27_number IN OUT NOCOPY igf_ap_css_profile.question_27_number%TYPE ,
344 pr_question_27_size IN OUT NOCOPY igf_ap_css_profile.question_27_size%TYPE ,
345 pr_question_27_answer IN OUT NOCOPY igf_ap_css_profile.question_27_answer%TYPE ,
346 pr_question_28_number IN OUT NOCOPY igf_ap_css_profile.question_28_number%TYPE ,
347 pr_question_28_size IN OUT NOCOPY igf_ap_css_profile.question_28_size%TYPE ,
348 pr_question_28_answer IN OUT NOCOPY igf_ap_css_profile.question_28_answer%TYPE ,
349 pr_question_29_number IN OUT NOCOPY igf_ap_css_profile.question_29_number%TYPE ,
350 pr_question_29_size IN OUT NOCOPY igf_ap_css_profile.question_29_size%TYPE ,
351 pr_question_29_answer IN OUT NOCOPY igf_ap_css_profile.question_29_answer%TYPE ,
352 pr_question_30_number IN OUT NOCOPY igf_ap_css_profile.question_30_number%TYPE ,
353 pr_questions_30_size IN OUT NOCOPY igf_ap_css_profile.questions_30_size%TYPE ,
357 pr_coa_duration_num IN OUT NOCOPY igf_ap_css_profile.coa_duration_num %TYPE ,
354 pr_question_30_answer IN OUT NOCOPY igf_ap_css_profile.question_30_answer%TYPE ,
355 pr_legacy_record_flag IN OUT NOCOPY igf_ap_css_profile.legacy_record_flag%TYPE ,
356 pr_coa_duration_efc_amt IN OUT NOCOPY igf_ap_css_profile.coa_duration_efc_amt%TYPE ,
358 pr_created_by IN OUT NOCOPY igf_ap_css_profile.created_by%TYPE ,
359 pr_creation_date IN OUT NOCOPY igf_ap_css_profile.creation_date%TYPE ,
360 pr_last_updated_by IN OUT NOCOPY igf_ap_css_profile.last_updated_by%TYPE ,
361 pr_last_update_date IN OUT NOCOPY igf_ap_css_profile.last_update_date%TYPE ,
362 pr_last_update_login IN OUT NOCOPY igf_ap_css_profile.last_update_login%TYPE ,
363 pr_p_soc_sec_ben_student_amt IN OUT NOCOPY igf_ap_css_profile.p_soc_sec_ben_student_amt%TYPE ,
364 pr_p_tuit_fee_deduct_amt IN OUT NOCOPY igf_ap_css_profile.p_tuit_fee_deduct_amt%TYPE ,
365 pr_stu_lives_with_num IN OUT NOCOPY igf_ap_css_profile.stu_lives_with_num%TYPE ,
366 pr_stu_most_support_from_num IN OUT NOCOPY igf_ap_css_profile.stu_most_support_from_num%TYPE ,
367 pr_location_computer_num IN OUT NOCOPY igf_ap_css_profile.location_computer_num%TYPE ,
368
369 f_fnar_id IN OUT NOCOPY igf_ap_css_fnar.fnar_id%TYPE ,
370 f_cssp_id IN OUT NOCOPY igf_ap_css_fnar.cssp_id%TYPE ,
371 f_r_s_email_address IN OUT NOCOPY igf_ap_css_fnar.r_s_email_address%TYPE ,
372 f_eps_code IN OUT NOCOPY igf_ap_css_fnar.eps_code%TYPE ,
373 f_comp_css_dependency_status IN OUT NOCOPY igf_ap_css_fnar.comp_css_dependency_status%TYPE ,
374 f_stu_age IN OUT NOCOPY igf_ap_css_fnar.stu_age%TYPE ,
375 f_assumed_stu_yr_in_coll IN OUT NOCOPY igf_ap_css_fnar.assumed_stu_yr_in_coll%TYPE ,
376 f_comp_stu_marital_status IN OUT NOCOPY igf_ap_css_fnar.comp_stu_marital_status%TYPE ,
377 f_stu_family_members IN OUT NOCOPY igf_ap_css_fnar.stu_family_members%TYPE ,
378 f_stu_fam_members_in_college IN OUT NOCOPY igf_ap_css_fnar.stu_fam_members_in_college%TYPE ,
379 f_par_marital_status IN OUT NOCOPY igf_ap_css_fnar.par_marital_status%TYPE ,
380 f_par_family_members IN OUT NOCOPY igf_ap_css_fnar.par_family_members%TYPE ,
381 f_par_total_in_college IN OUT NOCOPY igf_ap_css_fnar.par_total_in_college%TYPE ,
382 f_par_par_in_college IN OUT NOCOPY igf_ap_css_fnar.par_par_in_college%TYPE ,
383 f_par_others_in_college IN OUT NOCOPY igf_ap_css_fnar.par_others_in_college%TYPE ,
384 f_par_aesa IN OUT NOCOPY igf_ap_css_fnar.par_aesa%TYPE ,
385 f_par_cesa IN OUT NOCOPY igf_ap_css_fnar.par_cesa%TYPE ,
386 f_stu_aesa IN OUT NOCOPY igf_ap_css_fnar.stu_aesa%TYPE ,
387 f_stu_cesa IN OUT NOCOPY igf_ap_css_fnar.stu_cesa%TYPE ,
388 f_im_p_bas_agi_taxable_income IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_agi_taxable_income%TYPE ,
389 f_im_p_bas_untx_inc_and_ben IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_untx_inc_and_ben%TYPE ,
390 f_im_p_bas_inc_adj IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_inc_adj%TYPE ,
391 f_im_p_bas_total_income IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_income%TYPE ,
392 f_im_p_bas_us_income_tax IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_us_income_tax%TYPE ,
393 f_im_p_bas_st_and_other_tax IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_st_and_other_tax%TYPE ,
394 f_im_p_bas_fica_tax IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_fica_tax%TYPE ,
395 f_im_p_bas_med_dental IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_med_dental%TYPE ,
396 f_im_p_bas_employment_allow IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_employment_allow%TYPE ,
397 f_im_p_bas_annual_ed_savings IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_annual_ed_savings%TYPE ,
398 f_im_p_bas_inc_prot_allow_m IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_inc_prot_allow_m%TYPE ,
399 f_im_p_bas_total_inc_allow IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_inc_allow%TYPE ,
400 f_im_p_bas_cal_avail_inc IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cal_avail_inc%TYPE ,
401 f_im_p_bas_avail_income IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_avail_income%TYPE ,
402 f_im_p_bas_total_cont_inc IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_cont_inc%TYPE ,
403 f_im_p_bas_cash_bank_accounts IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cash_bank_accounts%TYPE ,
404 f_im_p_bas_home_equity IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_home_equity%TYPE ,
405 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 ,
406 f_im_p_bas_adj_bus_farm_worth IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_adj_bus_farm_worth%TYPE ,
407 f_im_p_bas_ass_sibs_pre_tui IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_ass_sibs_pre_tui%TYPE ,
408 f_im_p_bas_net_worth IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_net_worth%TYPE ,
412 f_im_p_bas_total_asset_allow IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_asset_allow%TYPE ,
409 f_im_p_bas_emerg_res_allow IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_emerg_res_allow%TYPE ,
410 f_im_p_bas_cum_ed_savings IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cum_ed_savings%TYPE ,
411 f_im_p_bas_low_inc_allow IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_low_inc_allow%TYPE ,
413 f_im_p_bas_disc_net_worth IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_disc_net_worth%TYPE ,
414 f_im_p_bas_total_cont_asset IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_cont_asset%TYPE ,
415 f_im_p_bas_total_cont IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_total_cont%TYPE ,
416 f_im_p_bas_num_in_coll_adj IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_num_in_coll_adj%TYPE ,
417 f_im_p_bas_cont_for_stu IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cont_for_stu%TYPE ,
418 f_im_p_bas_cont_from_income IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cont_from_income%TYPE ,
419 f_im_p_bas_cont_from_assets IN OUT NOCOPY igf_ap_css_fnar.im_p_bas_cont_from_assets%TYPE ,
420 f_im_p_opt_agi_taxable_income IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_agi_taxable_income%TYPE ,
421 f_im_p_opt_untx_inc_and_ben IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_untx_inc_and_ben%TYPE ,
422 f_im_p_opt_inc_adj IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_inc_adj%TYPE ,
423 f_im_p_opt_total_income IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_income%TYPE ,
424 f_im_p_opt_us_income_tax IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_us_income_tax%TYPE ,
425 f_im_p_opt_st_and_other_tax IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_st_and_other_tax%TYPE ,
426 f_im_p_opt_fica_tax IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_fica_tax%TYPE ,
427 f_im_p_opt_med_dental IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_med_dental%TYPE ,
428 f_im_p_opt_elem_sec_tuit IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_elem_sec_tuit%TYPE ,
429 f_im_p_opt_employment_allow IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_employment_allow%TYPE ,
430 f_im_p_opt_annual_ed_savings IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_annual_ed_savings%TYPE ,
431 f_im_p_opt_inc_prot_allow_m IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_inc_prot_allow_m%TYPE ,
432 f_im_p_opt_total_inc_allow IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_inc_allow%TYPE ,
433 f_im_p_opt_cal_avail_inc IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cal_avail_inc%TYPE ,
434 f_im_p_opt_avail_income IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_avail_income%TYPE ,
435 f_im_p_opt_total_cont_inc IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_cont_inc%TYPE ,
436 f_im_p_opt_cash_bank_accounts IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cash_bank_accounts%TYPE ,
437 f_im_p_opt_home_equity IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_home_equity%TYPE ,
438 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 ,
439 f_im_p_opt_adj_bus_farm_worth IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_adj_bus_farm_worth%TYPE ,
440 f_im_p_opt_ass_sibs_pre_tui IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_ass_sibs_pre_tui%TYPE ,
441 f_im_p_opt_net_worth IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_net_worth%TYPE ,
442 f_im_p_opt_emerg_res_allow IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_emerg_res_allow%TYPE ,
443 f_im_p_opt_cum_ed_savings IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cum_ed_savings%TYPE ,
444 f_im_p_opt_low_inc_allow IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_low_inc_allow%TYPE ,
445 f_im_p_opt_total_asset_allow IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_asset_allow%TYPE ,
446 f_im_p_opt_disc_net_worth IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_disc_net_worth%TYPE ,
447 f_im_p_opt_total_cont_asset IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_cont_asset%TYPE ,
448 f_im_p_opt_total_cont IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_total_cont%TYPE ,
449 f_im_p_opt_num_in_coll_adj IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_num_in_coll_adj%TYPE ,
450 f_im_p_opt_cont_for_stu IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cont_for_stu%TYPE ,
451 f_im_p_opt_cont_from_income IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cont_from_income%TYPE ,
452 f_im_p_opt_cont_from_assets IN OUT NOCOPY igf_ap_css_fnar.im_p_opt_cont_from_assets%TYPE ,
453 f_fm_p_analysis_type IN OUT NOCOPY igf_ap_css_fnar.fm_p_analysis_type%TYPE ,
454 f_fm_p_agi_taxable_income IN OUT NOCOPY igf_ap_css_fnar.fm_p_agi_taxable_income%TYPE ,
455 f_fm_p_untx_inc_and_ben IN OUT NOCOPY igf_ap_css_fnar.fm_p_untx_inc_and_ben%TYPE ,
456 f_fm_p_inc_adj IN OUT NOCOPY igf_ap_css_fnar.fm_p_inc_adj%TYPE ,
457 f_fm_p_total_income IN OUT NOCOPY igf_ap_css_fnar.fm_p_total_income%TYPE ,
458 f_fm_p_us_income_tax IN OUT NOCOPY igf_ap_css_fnar.fm_p_us_income_tax%TYPE ,
459 f_fm_p_state_and_other_taxes IN OUT NOCOPY igf_ap_css_fnar.fm_p_state_and_other_taxes%TYPE ,
460 f_fm_p_fica_tax IN OUT NOCOPY igf_ap_css_fnar.fm_p_fica_tax%TYPE ,
461 f_fm_p_employment_allow IN OUT NOCOPY igf_ap_css_fnar.fm_p_employment_allow%TYPE ,
462 f_fm_p_income_prot_allow IN OUT NOCOPY igf_ap_css_fnar.fm_p_income_prot_allow%TYPE ,
466 f_fm_p_ot_rl_est_inv_equity IN OUT NOCOPY igf_ap_css_fnar.fm_p_ot_rl_est_inv_equity%TYPE ,
463 f_fm_p_total_allow IN OUT NOCOPY igf_ap_css_fnar.fm_p_total_allow%TYPE ,
464 f_fm_p_avail_income IN OUT NOCOPY igf_ap_css_fnar.fm_p_avail_income%TYPE ,
465 f_fm_p_cash_bank_accounts IN OUT NOCOPY igf_ap_css_fnar.fm_p_cash_bank_accounts%TYPE ,
467 f_fm_p_adj_bus_farm_net_worth IN OUT NOCOPY igf_ap_css_fnar.fm_p_adj_bus_farm_net_worth%TYPE ,
468 f_fm_p_net_worth IN OUT NOCOPY igf_ap_css_fnar.fm_p_net_worth%TYPE ,
469 f_fm_p_asset_prot_allow IN OUT NOCOPY igf_ap_css_fnar.fm_p_asset_prot_allow%TYPE ,
470 f_fm_p_disc_net_worth IN OUT NOCOPY igf_ap_css_fnar.fm_p_disc_net_worth%TYPE ,
471 f_fm_p_total_contribution IN OUT NOCOPY igf_ap_css_fnar.fm_p_total_contribution%TYPE ,
472 f_fm_p_num_in_coll IN OUT NOCOPY igf_ap_css_fnar.fm_p_num_in_coll%TYPE ,
473 f_fm_p_cont_for_stu IN OUT NOCOPY igf_ap_css_fnar.fm_p_cont_for_stu%TYPE ,
474 f_fm_p_cont_from_income IN OUT NOCOPY igf_ap_css_fnar.fm_p_cont_from_income%TYPE ,
475 f_fm_p_cont_from_assets IN OUT NOCOPY igf_ap_css_fnar.fm_p_cont_from_assets%TYPE ,
476 f_im_s_bas_agi_taxable_income IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_agi_taxable_income%TYPE ,
477 f_im_s_bas_untx_inc_and_ben IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_untx_inc_and_ben%TYPE ,
478 f_im_s_bas_inc_adj IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_inc_adj%TYPE ,
479 f_im_s_bas_total_income IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_income%TYPE ,
480 f_im_s_bas_us_income_tax IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_us_income_tax%TYPE ,
481 f_im_s_bas_state_and_oth_taxes IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_state_and_oth_taxes%TYPE ,
482 f_im_s_bas_fica_tax IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_fica_tax%TYPE ,
483 f_im_s_bas_med_dental IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_med_dental%TYPE ,
484 f_im_s_bas_employment_allow IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_employment_allow%TYPE ,
485 f_im_s_bas_annual_ed_savings IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_annual_ed_savings%TYPE ,
486 f_im_s_bas_inc_prot_allow_m IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_inc_prot_allow_m%TYPE ,
487 f_im_s_bas_total_inc_allow IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_inc_allow%TYPE ,
488 f_im_s_bas_cal_avail_income IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cal_avail_income%TYPE ,
489 f_im_s_bas_avail_income IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_avail_income%TYPE ,
490 f_im_s_bas_total_cont_inc IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_cont_inc%TYPE ,
491 f_im_s_bas_cash_bank_accounts IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cash_bank_accounts%TYPE ,
492 f_im_s_bas_home_equity IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_home_equity%TYPE ,
493 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 ,
494 f_im_s_bas_adj_busfarm_worth IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_adj_busfarm_worth%TYPE ,
495 f_im_s_bas_trusts IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_trusts%TYPE ,
496 f_im_s_bas_net_worth IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_net_worth%TYPE ,
497 f_im_s_bas_emerg_res_allow IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_emerg_res_allow%TYPE ,
498 f_im_s_bas_cum_ed_savings IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cum_ed_savings%TYPE ,
499 f_im_s_bas_total_asset_allow IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_asset_allow%TYPE ,
503 f_im_s_bas_num_in_coll_adj IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_num_in_coll_adj%TYPE ,
500 f_im_s_bas_disc_net_worth IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_disc_net_worth%TYPE ,
501 f_im_s_bas_total_cont_asset IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_cont_asset%TYPE ,
502 f_im_s_bas_total_cont IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_total_cont%TYPE ,
504 f_im_s_bas_cont_for_stu IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cont_for_stu%TYPE ,
505 f_im_s_bas_cont_from_income IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cont_from_income%TYPE ,
506 f_im_s_bas_cont_from_assets IN OUT NOCOPY igf_ap_css_fnar.im_s_bas_cont_from_assets%TYPE ,
507 f_im_s_est_agitaxable_income IN OUT NOCOPY igf_ap_css_fnar.im_s_est_agitaxable_income%TYPE ,
508 f_im_s_est_untx_inc_and_ben IN OUT NOCOPY igf_ap_css_fnar.im_s_est_untx_inc_and_ben%TYPE ,
509 f_im_s_est_inc_adj IN OUT NOCOPY igf_ap_css_fnar.im_s_est_inc_adj%TYPE ,
510 f_im_s_est_total_income IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_income%TYPE ,
511 f_im_s_est_us_income_tax IN OUT NOCOPY igf_ap_css_fnar.im_s_est_us_income_tax%TYPE ,
512 f_im_s_est_state_and_oth_taxes IN OUT NOCOPY igf_ap_css_fnar.im_s_est_state_and_oth_taxes%TYPE ,
513 f_im_s_est_fica_tax IN OUT NOCOPY igf_ap_css_fnar.im_s_est_fica_tax%TYPE ,
514 f_im_s_est_med_dental IN OUT NOCOPY igf_ap_css_fnar.im_s_est_med_dental%TYPE ,
515 f_im_s_est_employment_allow IN OUT NOCOPY igf_ap_css_fnar.im_s_est_employment_allow%TYPE ,
516 f_im_s_est_annual_ed_savings IN OUT NOCOPY igf_ap_css_fnar.im_s_est_annual_ed_savings%TYPE ,
517 f_im_s_est_inc_prot_allow_m IN OUT NOCOPY igf_ap_css_fnar.im_s_est_inc_prot_allow_m%TYPE ,
518 f_im_s_est_total_inc_allow IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_inc_allow%TYPE ,
519 f_im_s_est_cal_avail_income IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cal_avail_income%TYPE ,
520 f_im_s_est_avail_income IN OUT NOCOPY igf_ap_css_fnar.im_s_est_avail_income%TYPE ,
521 f_im_s_est_total_cont_inc IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_cont_inc%TYPE ,
522 f_im_s_est_cash_bank_accounts IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cash_bank_accounts%TYPE ,
523 f_im_s_est_home_equity IN OUT NOCOPY igf_ap_css_fnar.im_s_est_home_equity%TYPE ,
524 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 ,
525 f_im_s_est_adj_bus_farm_worth IN OUT NOCOPY igf_ap_css_fnar.im_s_est_adj_bus_farm_worth%TYPE ,
526 f_im_s_est_est_trusts IN OUT NOCOPY igf_ap_css_fnar.im_s_est_est_trusts%TYPE ,
527 f_im_s_est_net_worth IN OUT NOCOPY igf_ap_css_fnar.im_s_est_net_worth%TYPE ,
528 f_im_s_est_emerg_res_allow IN OUT NOCOPY igf_ap_css_fnar.im_s_est_emerg_res_allow%TYPE ,
529 f_im_s_est_cum_ed_savings IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cum_ed_savings%TYPE ,
530 f_im_s_est_total_asset_allow IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_asset_allow%TYPE ,
531 f_im_s_est_disc_net_worth IN OUT NOCOPY igf_ap_css_fnar.im_s_est_disc_net_worth%TYPE ,
532 f_im_s_est_total_cont_asset IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_cont_asset%TYPE ,
533 f_im_s_est_total_cont IN OUT NOCOPY igf_ap_css_fnar.im_s_est_total_cont%TYPE ,
534 f_im_s_est_num_in_coll_adj IN OUT NOCOPY igf_ap_css_fnar.im_s_est_num_in_coll_adj%TYPE ,
535 f_im_s_est_cont_for_stu IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cont_for_stu%TYPE ,
536 f_im_s_est_cont_from_income IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cont_from_income%TYPE ,
537 f_im_s_est_cont_from_assets IN OUT NOCOPY igf_ap_css_fnar.im_s_est_cont_from_assets%TYPE ,
538 f_im_s_opt_agi_taxable_income IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_agi_taxable_income%TYPE ,
539 f_im_s_opt_untx_inc_and_ben IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_untx_inc_and_ben%TYPE ,
540 f_im_s_opt_inc_adj IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_inc_adj%TYPE ,
541 f_im_s_opt_total_income IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_income%TYPE ,
542 f_im_s_opt_us_income_tax IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_us_income_tax%TYPE ,
543 f_im_s_opt_state_and_oth_taxes IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_state_and_oth_taxes%TYPE ,
544 f_im_s_opt_fica_tax IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_fica_tax%TYPE ,
545 f_im_s_opt_med_dental IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_med_dental%TYPE ,
546 f_im_s_opt_employment_allow IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_employment_allow%TYPE ,
547 f_im_s_opt_annual_ed_savings IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_annual_ed_savings%TYPE ,
548 f_im_s_opt_inc_prot_allow_m IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_inc_prot_allow_m%TYPE ,
549 f_im_s_opt_total_inc_allow IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_inc_allow%TYPE ,
550 f_im_s_opt_cal_avail_income IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cal_avail_income%TYPE ,
551 f_im_s_opt_avail_income IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_avail_income%TYPE ,
552 f_im_s_opt_total_cont_inc IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_cont_inc%TYPE ,
553 f_im_s_opt_cash_bank_accounts IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cash_bank_accounts%TYPE ,
554 f_im_s_opt_ira_keogh_accounts IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_ira_keogh_accounts%TYPE ,
555 f_im_s_opt_home_equity IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_home_equity%TYPE ,
556 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 ,
557 f_im_s_opt_adj_bus_farm_worth IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_adj_bus_farm_worth%TYPE ,
558 f_im_s_opt_trusts IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_trusts%TYPE ,
559 f_im_s_opt_net_worth IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_net_worth%TYPE ,
560 f_im_s_opt_emerg_res_allow IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_emerg_res_allow%TYPE ,
561 f_im_s_opt_cum_ed_savings IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cum_ed_savings%TYPE ,
562 f_im_s_opt_total_asset_allow IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_asset_allow%TYPE ,
563 f_im_s_opt_disc_net_worth IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_disc_net_worth%TYPE ,
564 f_im_s_opt_total_cont_asset IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_cont_asset%TYPE ,
565 f_im_s_opt_total_cont IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_total_cont%TYPE ,
566 f_im_s_opt_num_in_coll_adj IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_num_in_coll_adj%TYPE ,
567 f_im_s_opt_cont_for_stu IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cont_for_stu%TYPE ,
568 f_im_s_opt_cont_from_income IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cont_from_income%TYPE ,
572 f_fm_s_untx_inc_and_ben IN OUT NOCOPY igf_ap_css_fnar.fm_s_untx_inc_and_ben%TYPE ,
569 f_im_s_opt_cont_from_assets IN OUT NOCOPY igf_ap_css_fnar.im_s_opt_cont_from_assets%TYPE ,
570 f_fm_s_analysis_type IN OUT NOCOPY igf_ap_css_fnar.fm_s_analysis_type%TYPE ,
571 f_fm_s_agi_taxable_income IN OUT NOCOPY igf_ap_css_fnar.fm_s_agi_taxable_income%TYPE ,
573 f_fm_s_inc_adj IN OUT NOCOPY igf_ap_css_fnar.fm_s_inc_adj%TYPE ,
574 f_fm_s_total_income IN OUT NOCOPY igf_ap_css_fnar.fm_s_total_income%TYPE ,
575 f_fm_s_us_income_tax IN OUT NOCOPY igf_ap_css_fnar.fm_s_us_income_tax%TYPE ,
576 f_fm_s_state_and_oth_taxes IN OUT NOCOPY igf_ap_css_fnar.fm_s_state_and_oth_taxes%TYPE ,
577 f_fm_s_fica_tax IN OUT NOCOPY igf_ap_css_fnar.fm_s_fica_tax%TYPE ,
578 f_fm_s_employment_allow IN OUT NOCOPY igf_ap_css_fnar.fm_s_employment_allow%TYPE ,
579 f_fm_s_income_prot_allow IN OUT NOCOPY igf_ap_css_fnar.fm_s_income_prot_allow%TYPE ,
580 f_fm_s_total_allow IN OUT NOCOPY igf_ap_css_fnar.fm_s_total_allow%TYPE ,
581 f_fm_s_cal_avail_income IN OUT NOCOPY igf_ap_css_fnar.fm_s_cal_avail_income%TYPE ,
582 f_fm_s_avail_income IN OUT NOCOPY igf_ap_css_fnar.fm_s_avail_income%TYPE ,
583 f_fm_s_cash_bank_accounts IN OUT NOCOPY igf_ap_css_fnar.fm_s_cash_bank_accounts%TYPE ,
584 f_fm_s_ot_rl_est_inv_equity IN OUT NOCOPY igf_ap_css_fnar.fm_s_ot_rl_est_inv_equity%TYPE ,
585 f_fm_s_adj_bus_farm_worth IN OUT NOCOPY igf_ap_css_fnar.fm_s_adj_bus_farm_worth%TYPE ,
586 f_fm_s_trusts IN OUT NOCOPY igf_ap_css_fnar.fm_s_trusts%TYPE ,
587 f_fm_s_net_worth IN OUT NOCOPY igf_ap_css_fnar.fm_s_net_worth%TYPE ,
588 f_fm_s_asset_prot_allow IN OUT NOCOPY igf_ap_css_fnar.fm_s_asset_prot_allow%TYPE ,
589 f_fm_s_disc_net_worth IN OUT NOCOPY igf_ap_css_fnar.fm_s_disc_net_worth%TYPE ,
590 f_fm_s_total_cont IN OUT NOCOPY igf_ap_css_fnar.fm_s_total_cont%TYPE ,
591 f_fm_s_num_in_coll IN OUT NOCOPY igf_ap_css_fnar.fm_s_num_in_coll%TYPE ,
592 f_fm_s_cont_for_stu IN OUT NOCOPY igf_ap_css_fnar.fm_s_cont_for_stu%TYPE ,
593 f_fm_s_cont_from_income IN OUT NOCOPY igf_ap_css_fnar.fm_s_cont_from_income%TYPE ,
594 f_fm_s_cont_from_assets IN OUT NOCOPY igf_ap_css_fnar.fm_s_cont_from_assets%TYPE ,
595 f_im_inst_resident_ind IN OUT NOCOPY igf_ap_css_fnar.im_inst_resident_ind%TYPE ,
596 f_institutional_1_budget_name IN OUT NOCOPY igf_ap_css_fnar.institutional_1_budget_name%TYPE ,
597 f_im_inst_1_budget_duration IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_budget_duration%TYPE ,
601 f_im_inst_1_tot_expenses IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tot_expenses%TYPE ,
598 f_im_inst_1_tuition_fees IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tuition_fees%TYPE ,
599 f_im_inst_1_books_supplies IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_books_supplies%TYPE ,
600 f_im_inst_1_living_expenses IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_living_expenses%TYPE ,
602 f_im_inst_1_tot_stu_cont IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tot_stu_cont%TYPE ,
603 f_im_inst_1_tot_par_cont IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tot_par_cont%TYPE ,
604 f_im_inst_1_tot_family_cont IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_tot_family_cont%TYPE ,
605 f_im_inst_1_va_benefits IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_va_benefits%TYPE ,
606 f_im_inst_1_ot_cont IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_ot_cont%TYPE ,
607 f_im_inst_1_est_financial_need IN OUT NOCOPY igf_ap_css_fnar.im_inst_1_est_financial_need%TYPE ,
608 f_institutional_2_budget_name IN OUT NOCOPY igf_ap_css_fnar.institutional_2_budget_name%TYPE ,
609 f_im_inst_2_budget_duration IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_budget_duration%TYPE ,
610 f_im_inst_2_tuition_fees IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tuition_fees%TYPE ,
611 f_im_inst_2_books_supplies IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_books_supplies%TYPE ,
612 f_im_inst_2_living_expenses IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_living_expenses%TYPE ,
613 f_im_inst_2_tot_expenses IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tot_expenses%TYPE ,
614 f_im_inst_2_tot_stu_cont IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tot_stu_cont%TYPE ,
615 f_im_inst_2_tot_par_cont IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tot_par_cont%TYPE ,
616 f_im_inst_2_tot_family_cont IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_tot_family_cont%TYPE ,
617 f_im_inst_2_va_benefits IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_va_benefits%TYPE ,
618 f_im_inst_2_est_financial_need IN OUT NOCOPY igf_ap_css_fnar.im_inst_2_est_financial_need%TYPE ,
619 f_institutional_3_budget_name IN OUT NOCOPY igf_ap_css_fnar.institutional_3_budget_name%TYPE ,
620 f_im_inst_3_budget_duration IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_budget_duration%TYPE ,
621 f_im_inst_3_tuition_fees IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tuition_fees%TYPE ,
622 f_im_inst_3_books_supplies IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_books_supplies%TYPE ,
623 f_im_inst_3_living_expenses IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_living_expenses%TYPE ,
624 f_im_inst_3_tot_expenses IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tot_expenses%TYPE ,
625 f_im_inst_3_tot_stu_cont IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tot_stu_cont%TYPE ,
626 f_im_inst_3_tot_par_cont IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tot_par_cont%TYPE ,
627 f_im_inst_3_tot_family_cont IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_tot_family_cont%TYPE ,
628 f_im_inst_3_va_benefits IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_va_benefits%TYPE ,
629 f_im_inst_3_est_financial_need IN OUT NOCOPY igf_ap_css_fnar.im_inst_3_est_financial_need%TYPE ,
630 f_fm_inst_1_federal_efc IN OUT NOCOPY igf_ap_css_fnar.fm_inst_1_federal_efc%TYPE ,
631 f_fm_inst_1_va_benefits IN OUT NOCOPY igf_ap_css_fnar.fm_inst_1_va_benefits%TYPE ,
632 f_fm_inst_1_fed_eligibility IN OUT NOCOPY igf_ap_css_fnar.fm_inst_1_fed_eligibility%TYPE ,
633 f_fm_inst_1_pell IN OUT NOCOPY igf_ap_css_fnar.fm_inst_1_pell%TYPE ,
634 f_option_par_loss_allow_ind IN OUT NOCOPY igf_ap_css_fnar.option_par_loss_allow_ind%TYPE ,
635 f_option_par_tuition_ind IN OUT NOCOPY igf_ap_css_fnar.option_par_tuition_ind%TYPE ,
636 f_option_par_home_ind IN OUT NOCOPY igf_ap_css_fnar.option_par_home_ind%TYPE ,
637 f_option_par_home_value IN OUT NOCOPY igf_ap_css_fnar.option_par_home_value%TYPE ,
638 f_option_par_home_debt IN OUT NOCOPY igf_ap_css_fnar.option_par_home_debt%TYPE ,
639 f_option_stu_ira_keogh_ind IN OUT NOCOPY igf_ap_css_fnar.option_stu_ira_keogh_ind%TYPE ,
640 f_option_stu_home_ind IN OUT NOCOPY igf_ap_css_fnar.option_stu_home_ind%TYPE ,
641 f_option_stu_home_value IN OUT NOCOPY igf_ap_css_fnar.option_stu_home_value%TYPE ,
642 f_option_stu_home_debt IN OUT NOCOPY igf_ap_css_fnar.option_stu_home_debt%TYPE ,
643 f_option_stu_sum_ay_inc_ind IN OUT NOCOPY igf_ap_css_fnar.option_stu_sum_ay_inc_ind%TYPE ,
644 f_option_par_hope_ll_credit IN OUT NOCOPY igf_ap_css_fnar.option_par_hope_ll_credit%TYPE ,
645 f_option_stu_hope_ll_credit IN OUT NOCOPY igf_ap_css_fnar.option_stu_hope_ll_credit%TYPE ,
646 f_option_par_cola_adj_ind IN OUT NOCOPY igf_ap_css_fnar.option_par_cola_adj_ind%TYPE ,
647 f_option_par_stu_fa_assets_ind IN OUT NOCOPY igf_ap_css_fnar.option_par_stu_fa_assets_ind%TYPE ,
648 f_option_par_ipt_assets_ind IN OUT NOCOPY igf_ap_css_fnar.option_par_ipt_assets_ind%TYPE ,
649 f_option_stu_ipt_assets_ind IN OUT NOCOPY igf_ap_css_fnar.option_stu_ipt_assets_ind%TYPE ,
650 f_option_par_cola_adj_value IN OUT NOCOPY igf_ap_css_fnar.option_par_cola_adj_value%TYPE ,
651 f_im_parent_1_8_months_bas IN OUT NOCOPY igf_ap_css_fnar.im_parent_1_8_months_bas%TYPE ,
655 f_fnar_message_1 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_1%TYPE ,
652 f_im_p_more_than_9_mth_ba IN OUT NOCOPY igf_ap_css_fnar.im_p_more_than_9_mth_ba%TYPE ,
653 f_im_parent_1_8_months_opt IN OUT NOCOPY igf_ap_css_fnar.im_parent_1_8_months_opt%TYPE ,
654 f_im_p_more_than_9_mth_op IN OUT NOCOPY igf_ap_css_fnar.im_p_more_than_9_mth_op%TYPE ,
656 f_fnar_message_2 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_2%TYPE ,
657 f_fnar_message_3 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_3%TYPE ,
658 f_fnar_message_4 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_4%TYPE ,
659 f_fnar_message_5 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_5%TYPE ,
660 f_fnar_message_6 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_6%TYPE ,
661 f_fnar_message_7 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_7%TYPE ,
662 f_fnar_message_8 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_8%TYPE ,
663 f_fnar_message_9 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_9%TYPE ,
664 f_fnar_message_10 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_10%TYPE ,
665 f_fnar_message_11 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_11%TYPE ,
666 f_fnar_message_12 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_12%TYPE ,
667 f_fnar_message_13 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_13%TYPE ,
668 f_fnar_message_20 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_20%TYPE ,
669 f_fnar_message_21 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_21%TYPE ,
670 f_fnar_message_22 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_22%TYPE ,
671 f_fnar_message_23 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_23%TYPE ,
672 f_fnar_message_24 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_24%TYPE ,
673 f_fnar_message_25 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_25%TYPE ,
674 f_fnar_message_26 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_26%TYPE ,
675 f_fnar_message_27 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_27%TYPE ,
676 f_fnar_message_30 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_30%TYPE ,
677 f_fnar_message_31 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_31%TYPE ,
678 f_fnar_message_32 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_32%TYPE ,
679 f_fnar_message_33 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_33%TYPE ,
680 f_fnar_message_34 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_34%TYPE ,
681 f_fnar_message_35 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_35%TYPE ,
682 f_fnar_message_36 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_36%TYPE ,
683 f_fnar_message_37 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_37%TYPE ,
684 f_fnar_message_38 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_38%TYPE ,
685 f_fnar_message_39 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_39%TYPE ,
686 f_fnar_message_45 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_45%TYPE ,
687 f_fnar_message_46 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_46%TYPE ,
688 f_fnar_message_47 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_47%TYPE ,
689 f_fnar_message_48 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_48%TYPE ,
690 f_fnar_message_49 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_49%TYPE ,
691 f_fnar_message_50 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_50%TYPE ,
692 f_fnar_message_51 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_51%TYPE ,
693 f_fnar_message_52 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_52%TYPE ,
697 f_fnar_message_57 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_57%TYPE ,
694 f_fnar_message_53 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_53%TYPE ,
695 f_fnar_message_55 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_55%TYPE ,
696 f_fnar_message_56 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_56%TYPE ,
698 f_fnar_message_58 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_58%TYPE ,
699 f_fnar_message_59 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_59%TYPE ,
700 f_fnar_message_60 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_60%TYPE ,
701 f_fnar_message_61 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_61%TYPE ,
702 f_fnar_message_62 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_62%TYPE ,
703 f_fnar_message_63 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_63%TYPE ,
704 f_fnar_message_64 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_64%TYPE ,
705 f_fnar_message_65 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_65%TYPE ,
706 f_fnar_message_71 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_71%TYPE ,
707 f_fnar_message_72 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_72%TYPE ,
708 f_fnar_message_73 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_73%TYPE ,
709 f_fnar_message_74 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_74%TYPE ,
710 f_fnar_message_75 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_75%TYPE ,
711 f_fnar_message_76 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_76%TYPE ,
712 f_fnar_message_77 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_77%TYPE ,
713 f_fnar_message_78 IN OUT NOCOPY igf_ap_css_fnar.fnar_message_78%TYPE ,
714 f_fnar_mesg_10_stu_fam_mem IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_10_stu_fam_mem%TYPE ,
718 f_fnar_mesg_33_stu_home_value IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_33_stu_home_value%TYPE ,
715 f_fnar_mesg_11_stu_no_in_coll IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_11_stu_no_in_coll%TYPE ,
716 f_fnar_mesg_24_stu_avail_inc IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_24_stu_avail_inc%TYPE ,
717 f_fnar_mesg_26_stu_taxes IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_26_stu_taxes%TYPE ,
719 f_fnar_mesg_34_stu_home_value IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_34_stu_home_value%TYPE ,
720 f_fnar_mesg_34_stu_home_equity IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_34_stu_home_equity%TYPE ,
721 f_fnar_mesg_35_stu_home_value IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_35_stu_home_value%TYPE ,
722 f_fnar_mesg_35_stu_home_equity IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_35_stu_home_equity%TYPE ,
723 f_fnar_mesg_36_stu_home_equity IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_36_stu_home_equity%TYPE ,
724 f_fnar_mesg_48_par_fam_mem IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_48_par_fam_mem%TYPE ,
725 f_fnar_mesg_49_par_no_in_coll IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_49_par_no_in_coll%TYPE ,
726 f_fnar_mesg_56_par_agi IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_56_par_agi%TYPE ,
727 f_fnar_mesg_62_par_taxes IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_62_par_taxes%TYPE ,
728 f_fnar_mesg_73_par_home_value IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_73_par_home_value%TYPE ,
729 f_fnar_mesg_74_par_home_value IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_74_par_home_value%TYPE ,
730 f_fnar_mesg_74_par_home_equity IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_74_par_home_equity%TYPE ,
731 f_fnar_mesg_75_par_home_value IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_75_par_home_value%TYPE ,
732 f_fnar_mesg_75_par_home_equity IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_75_par_home_equity%TYPE ,
733 f_fnar_mesg_76_par_home_equity IN OUT NOCOPY igf_ap_css_fnar.fnar_mesg_76_par_home_equity%TYPE ,
734 f_assumption_message_1 IN OUT NOCOPY igf_ap_css_fnar.assumption_message_1%TYPE ,
735 f_assumption_message_2 IN OUT NOCOPY igf_ap_css_fnar.assumption_message_2%TYPE ,
736 f_assumption_message_3 IN OUT NOCOPY igf_ap_css_fnar.assumption_message_3%TYPE ,
737 f_assumption_message_4 IN OUT NOCOPY igf_ap_css_fnar.assumption_message_4%TYPE ,
738 f_assumption_message_5 IN OUT NOCOPY igf_ap_css_fnar.assumption_message_5%TYPE ,
739 f_assumption_message_6 IN OUT NOCOPY igf_ap_css_fnar.assumption_message_6%TYPE ,
740 f_record_mark IN OUT NOCOPY igf_ap_css_fnar.record_mark%TYPE ,
741 f_legacy_record_flag IN OUT NOCOPY igf_ap_css_fnar.legacy_record_flag%TYPE ,
742 f_creation_date IN OUT NOCOPY igf_ap_css_fnar.creation_date%TYPE ,
743 f_created_by IN OUT NOCOPY igf_ap_css_fnar.created_by%TYPE ,
744 f_last_updated_by IN OUT NOCOPY igf_ap_css_fnar.last_updated_by%TYPE ,
745 f_last_update_date IN OUT NOCOPY igf_ap_css_fnar.last_update_date%TYPE ,
746 f_last_update_login IN OUT NOCOPY igf_ap_css_fnar.last_update_login%TYPE ,
747 f_opt_ind_stu_ipt_assets_flag IN OUT NOCOPY igf_ap_css_fnar.option_ind_stu_ipt_assets_flag%TYPE ,
748 f_cust_parent_cont_adj_num IN OUT NOCOPY igf_ap_css_fnar.cust_parent_cont_adj_num%TYPE ,
749 f_custodial_parent_num IN OUT NOCOPY igf_ap_css_fnar.custodial_parent_num%TYPE ,
750 f_cust_par_base_prcnt_inc_amt IN OUT NOCOPY igf_ap_css_fnar.cust_par_base_prcnt_inc_amt%TYPE ,
751 f_cust_par_base_cont_inc_amt IN OUT NOCOPY igf_ap_css_fnar.cust_par_base_cont_inc_amt%TYPE ,
752 f_cust_par_base_cont_ast_amt IN OUT NOCOPY igf_ap_css_fnar.cust_par_base_cont_ast_amt%TYPE ,
753 f_cust_par_base_tot_cont_amt IN OUT NOCOPY igf_ap_css_fnar.cust_par_base_tot_cont_amt%TYPE ,
754 f_cust_par_opt_prcnt_inc_amt IN OUT NOCOPY igf_ap_css_fnar.cust_par_opt_prcnt_inc_amt%TYPE ,
755 f_cust_par_opt_cont_inc_amt IN OUT NOCOPY igf_ap_css_fnar.cust_par_opt_cont_inc_amt%TYPE ,
756 f_cust_par_opt_cont_ast_amt IN OUT NOCOPY igf_ap_css_fnar.cust_par_opt_cont_ast_amt%TYPE ,
757 f_cust_par_opt_tot_cont_amt IN OUT NOCOPY igf_ap_css_fnar.cust_par_opt_tot_cont_amt%TYPE ,
758 f_parents_email_txt IN OUT NOCOPY igf_ap_css_fnar.parents_email_txt%TYPE ,
759 f_parent_1_birth_date IN OUT NOCOPY igf_ap_css_fnar.parent_1_birth_date%TYPE ,
760 f_parent_2_birth_date IN OUT NOCOPY igf_ap_css_fnar.parent_2_birth_date%TYPE ,
761
762 p_err_mesg OUT NOCOPY fnd_new_messages.message_name%TYPE)
763 RETURN VARCHAR;
764
765 END igf_ap_uhk_inas_pkg;
[Home] [Help]