[Home] [Help]
PACKAGE BODY: APPS.IGF_AP_CS_UPD_FLAGS_PKG
Source
1 PACKAGE BODY igf_ap_cs_upd_flags_pkg AS
2 /* $Header: IGFAI34B.pls 115.3 2002/11/28 13:58:59 nsidana ship $ */
3
4 l_rowid VARCHAR2(25);
5 old_references igf_ap_cs_upd_flags%ROWTYPE;
6 new_references igf_ap_cs_upd_flags%ROWTYPE;
7
8 PROCEDURE set_column_values (
9 p_action IN VARCHAR2,
10 x_rowid IN VARCHAR2 DEFAULT NULL,
11 x_base_id IN NUMBER DEFAULT NULL,
12 x_last_name IN VARCHAR2 DEFAULT NULL,
13 x_first_name IN VARCHAR2 DEFAULT NULL,
14 x_middle_initial IN VARCHAR2 DEFAULT NULL,
15 x_address_number_and_street IN VARCHAR2 DEFAULT NULL,
16 x_city IN VARCHAR2 DEFAULT NULL,
17 x_state_mailing IN VARCHAR2 DEFAULT NULL,
18 x_zip_code IN VARCHAR2 DEFAULT NULL,
19 x_s_telephone_number IN VARCHAR2 DEFAULT NULL,
20 x_s_title IN VARCHAR2 DEFAULT NULL,
21 x_date_of_birth IN VARCHAR2 DEFAULT NULL,
22 x_social_security_number IN VARCHAR2 DEFAULT NULL,
23 x_state_legal_residence IN VARCHAR2 DEFAULT NULL,
24 x_foreign_address_indicator IN VARCHAR2 DEFAULT NULL,
25 x_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
26 x_country IN VARCHAR2 DEFAULT NULL,
27 x_financial_aid_status IN VARCHAR2 DEFAULT NULL,
28 x_year_in_college IN VARCHAR2 DEFAULT NULL,
29 x_marital_status IN VARCHAR2 DEFAULT NULL,
30 x_ward_court IN VARCHAR2 DEFAULT NULL,
31 x_legal_dependents_other IN VARCHAR2 DEFAULT NULL,
32 x_household_size IN VARCHAR2 DEFAULT NULL,
33 x_number_in_college IN VARCHAR2 DEFAULT NULL,
34 x_citizenship_status IN VARCHAR2 DEFAULT NULL,
35 x_citizenship_country IN VARCHAR2 DEFAULT NULL,
36 x_visa_classification IN VARCHAR2 DEFAULT NULL,
37 x_tax_figures IN VARCHAR2 DEFAULT NULL,
38 x_number_exemptions IN VARCHAR2 DEFAULT NULL,
39 x_adjusted_gross_inc IN VARCHAR2 DEFAULT NULL,
40 x_us_tax_paid IN VARCHAR2 DEFAULT NULL,
41 x_itemized_deductions IN VARCHAR2 DEFAULT NULL,
42 x_stu_income_work IN VARCHAR2 DEFAULT NULL,
43 x_spouse_income_work IN VARCHAR2 DEFAULT NULL,
44 x_divid_int_inc IN VARCHAR2 DEFAULT NULL,
45 x_soc_sec_benefits IN VARCHAR2 DEFAULT NULL,
46 x_welfare_tanf IN VARCHAR2 DEFAULT NULL,
47 x_child_supp_rcvd IN VARCHAR2 DEFAULT NULL,
48 x_earned_income_credit IN VARCHAR2 DEFAULT NULL,
49 x_other_untax_income IN VARCHAR2 DEFAULT NULL,
50 x_tax_stu_aid IN VARCHAR2 DEFAULT NULL,
51 x_cash_sav_check IN VARCHAR2 DEFAULT NULL,
52 x_ira_keogh IN VARCHAR2 DEFAULT NULL,
53 x_invest_value IN VARCHAR2 DEFAULT NULL,
54 x_invest_debt IN VARCHAR2 DEFAULT NULL,
55 x_home_value IN VARCHAR2 DEFAULT NULL,
56 x_home_debt IN VARCHAR2 DEFAULT NULL,
57 x_oth_real_value IN VARCHAR2 DEFAULT NULL,
58 x_oth_real_debt IN VARCHAR2 DEFAULT NULL,
59 x_bus_farm_value IN VARCHAR2 DEFAULT NULL,
60 x_bus_farm_debt IN VARCHAR2 DEFAULT NULL,
61 x_live_on_farm IN VARCHAR2 DEFAULT NULL,
62 x_home_purch_price IN VARCHAR2 DEFAULT NULL,
63 x_hope_ll_credit IN VARCHAR2 DEFAULT NULL,
64 x_home_purch_year IN VARCHAR2 DEFAULT NULL,
65 x_trust_amount IN VARCHAR2 DEFAULT NULL,
66 x_trust_avail IN VARCHAR2 DEFAULT NULL,
67 x_trust_estab IN VARCHAR2 DEFAULT NULL,
68 x_child_support_paid IN VARCHAR2 DEFAULT NULL,
69 x_med_dent_expenses IN VARCHAR2 DEFAULT NULL,
70 x_vet_us IN VARCHAR2 DEFAULT NULL,
71 x_vet_ben_amount IN VARCHAR2 DEFAULT NULL,
72 x_vet_ben_months IN VARCHAR2 DEFAULT NULL,
73 x_stu_summer_wages IN VARCHAR2 DEFAULT NULL,
74 x_stu_school_yr_wages IN VARCHAR2 DEFAULT NULL,
75 x_spouse_summer_wages IN VARCHAR2 DEFAULT NULL,
76 x_spouse_school_yr_wages IN VARCHAR2 DEFAULT NULL,
77 x_summer_other_tax_inc IN VARCHAR2 DEFAULT NULL,
78 x_school_yr_other_tax_inc IN VARCHAR2 DEFAULT NULL,
79 x_summer_untax_inc IN VARCHAR2 DEFAULT NULL,
80 x_school_yr_untax_inc IN VARCHAR2 DEFAULT NULL,
81 x_grants_schol_etc IN VARCHAR2 DEFAULT NULL,
82 x_tuit_benefits IN VARCHAR2 DEFAULT NULL,
83 x_cont_parents IN VARCHAR2 DEFAULT NULL,
84 x_cont_relatives IN VARCHAR2 DEFAULT NULL,
85 x_p_siblings_pre_tuit IN VARCHAR2 DEFAULT NULL,
86 x_p_student_pre_tuit IN VARCHAR2 DEFAULT NULL,
87 x_p_household_size IN VARCHAR2 DEFAULT NULL,
88 x_p_number_in_college IN VARCHAR2 DEFAULT NULL,
89 x_p_parents_in_college IN VARCHAR2 DEFAULT NULL,
90 x_p_marital_status IN VARCHAR2 DEFAULT NULL,
91 x_p_state_legal_residence IN VARCHAR2 DEFAULT NULL,
92 x_p_natural_par_status IN VARCHAR2 DEFAULT NULL,
93 x_p_child_supp_paid IN VARCHAR2 DEFAULT NULL,
94 x_p_repay_ed_loans IN VARCHAR2 DEFAULT NULL,
95 x_p_med_dent_expenses IN VARCHAR2 DEFAULT NULL,
96 x_p_tuit_paid_amount IN VARCHAR2 DEFAULT NULL,
97 x_p_tuit_paid_number IN VARCHAR2 DEFAULT NULL,
98 x_p_exp_child_supp_paid IN VARCHAR2 DEFAULT NULL,
99 x_p_exp_repay_ed_loans IN VARCHAR2 DEFAULT NULL,
100 x_p_exp_med_dent_expenses IN VARCHAR2 DEFAULT NULL,
101 x_p_exp_tuit_pd_amount IN VARCHAR2 DEFAULT NULL,
102 x_p_exp_tuit_pd_number IN VARCHAR2 DEFAULT NULL,
103 x_p_cash_sav_check IN VARCHAR2 DEFAULT NULL,
104 x_p_month_mortgage_pay IN VARCHAR2 DEFAULT NULL,
105 x_p_invest_value IN VARCHAR2 DEFAULT NULL,
106 x_p_invest_debt IN VARCHAR2 DEFAULT NULL,
107 x_p_home_value IN VARCHAR2 DEFAULT NULL,
108 x_p_home_debt IN VARCHAR2 DEFAULT NULL,
109 x_p_home_purch_price IN VARCHAR2 DEFAULT NULL,
110 x_p_own_business_farm IN VARCHAR2 DEFAULT NULL,
111 x_p_business_value IN VARCHAR2 DEFAULT NULL,
112 x_p_business_debt IN VARCHAR2 DEFAULT NULL,
113 x_p_farm_value IN VARCHAR2 DEFAULT NULL,
114 x_p_farm_debt IN VARCHAR2 DEFAULT NULL,
115 x_p_live_on_farm IN VARCHAR2 DEFAULT NULL,
116 x_p_oth_real_estate_value IN VARCHAR2 DEFAULT NULL,
117 x_p_oth_real_estate_debt IN VARCHAR2 DEFAULT NULL,
118 x_p_oth_real_purch_price IN VARCHAR2 DEFAULT NULL,
119 x_p_siblings_assets IN VARCHAR2 DEFAULT NULL,
120 x_p_home_purch_year IN VARCHAR2 DEFAULT NULL,
121 x_p_oth_real_purch_year IN VARCHAR2 DEFAULT NULL,
122 x_p_prior_agi IN VARCHAR2 DEFAULT NULL,
123 x_p_prior_us_tax_paid IN VARCHAR2 DEFAULT NULL,
124 x_p_prior_item_deductions IN VARCHAR2 DEFAULT NULL,
125 x_p_prior_other_untax_inc IN VARCHAR2 DEFAULT NULL,
126 x_p_tax_figures IN VARCHAR2 DEFAULT NULL,
127 x_p_number_exemptions IN VARCHAR2 DEFAULT NULL,
128 x_p_adjusted_gross_inc IN VARCHAR2 DEFAULT NULL,
129 x_p_wages_sal_tips IN VARCHAR2 DEFAULT NULL,
130 x_p_interest_income IN VARCHAR2 DEFAULT NULL,
131 x_p_dividend_income IN VARCHAR2 DEFAULT NULL,
132 x_p_net_inc_bus_farm IN VARCHAR2 DEFAULT NULL,
133 x_p_other_taxable_income IN VARCHAR2 DEFAULT NULL,
134 x_p_adj_to_income IN VARCHAR2 DEFAULT NULL,
135 x_p_us_tax_paid IN VARCHAR2 DEFAULT NULL,
136 x_p_itemized_deductions IN VARCHAR2 DEFAULT NULL,
137 x_p_father_income_work IN VARCHAR2 DEFAULT NULL,
138 x_p_mother_income_work IN VARCHAR2 DEFAULT NULL,
139 x_p_soc_sec_ben IN VARCHAR2 DEFAULT NULL,
140 x_p_welfare_tanf IN VARCHAR2 DEFAULT NULL,
141 x_p_child_supp_rcvd IN VARCHAR2 DEFAULT NULL,
142 x_p_ded_ira_keogh IN VARCHAR2 DEFAULT NULL,
143 x_p_tax_defer_pens_savs IN VARCHAR2 DEFAULT NULL,
144 x_p_dep_care_med_spending IN VARCHAR2 DEFAULT NULL,
145 x_p_earned_income_credit IN VARCHAR2 DEFAULT NULL,
146 x_p_living_allow IN VARCHAR2 DEFAULT NULL,
147 x_p_tax_exmpt_int IN VARCHAR2 DEFAULT NULL,
148 x_p_foreign_inc_excl IN VARCHAR2 DEFAULT NULL,
149 x_p_other_untax_inc IN VARCHAR2 DEFAULT NULL,
150 x_p_hope_ll_credit IN VARCHAR2 DEFAULT NULL,
151 x_p_yr_separation IN VARCHAR2 DEFAULT NULL,
152 x_p_yr_divorce IN VARCHAR2 DEFAULT NULL,
153 x_p_exp_father_inc IN VARCHAR2 DEFAULT NULL,
154 x_p_exp_mother_inc IN VARCHAR2 DEFAULT NULL,
155 x_p_exp_other_tax_inc IN VARCHAR2 DEFAULT NULL,
156 x_p_exp_other_untax_inc IN VARCHAR2 DEFAULT NULL,
157 x_line_2_relation IN VARCHAR2 DEFAULT NULL,
158 x_line_2_attend_college IN VARCHAR2 DEFAULT NULL,
159 x_line_3_relation IN VARCHAR2 DEFAULT NULL,
160 x_line_3_attend_college IN VARCHAR2 DEFAULT NULL,
161 x_line_4_relation IN VARCHAR2 DEFAULT NULL,
162 x_line_4_attend_college IN VARCHAR2 DEFAULT NULL,
163 x_line_5_relation IN VARCHAR2 DEFAULT NULL,
164 x_line_5_attend_college IN VARCHAR2 DEFAULT NULL,
165 x_line_6_relation IN VARCHAR2 DEFAULT NULL,
166 x_line_6_attend_college IN VARCHAR2 DEFAULT NULL,
167 x_line_7_relation IN VARCHAR2 DEFAULT NULL,
171 x_p_age_father IN VARCHAR2 DEFAULT NULL,
168 x_line_7_attend_college IN VARCHAR2 DEFAULT NULL,
169 x_line_8_relation IN VARCHAR2 DEFAULT NULL,
170 x_line_8_attend_college IN VARCHAR2 DEFAULT NULL,
172 x_p_age_mother IN VARCHAR2 DEFAULT NULL,
173 x_p_div_sep_ind IN VARCHAR2 DEFAULT NULL,
174 x_b_cont_non_custodial_par IN VARCHAR2 DEFAULT NULL,
175 x_college_type_2 IN VARCHAR2 DEFAULT NULL,
176 x_college_type_3 IN VARCHAR2 DEFAULT NULL,
177 x_college_type_4 IN VARCHAR2 DEFAULT NULL,
178 x_college_type_5 IN VARCHAR2 DEFAULT NULL,
179 x_college_type_6 IN VARCHAR2 DEFAULT NULL,
180 x_college_type_7 IN VARCHAR2 DEFAULT NULL,
181 x_college_type_8 IN VARCHAR2 DEFAULT NULL,
182 x_school_code_1 IN VARCHAR2 DEFAULT NULL,
183 x_housing_code_1 IN VARCHAR2 DEFAULT NULL,
184 x_school_code_2 IN VARCHAR2 DEFAULT NULL,
185 x_housing_code_2 IN VARCHAR2 DEFAULT NULL,
186 x_school_code_3 IN VARCHAR2 DEFAULT NULL,
187 x_housing_code_3 IN VARCHAR2 DEFAULT NULL,
188 x_school_code_4 IN VARCHAR2 DEFAULT NULL,
189 x_housing_code_4 IN VARCHAR2 DEFAULT NULL,
190 x_school_code_5 IN VARCHAR2 DEFAULT NULL,
191 x_housing_code_5 IN VARCHAR2 DEFAULT NULL,
192 x_school_code_6 IN VARCHAR2 DEFAULT NULL,
193 x_housing_code_6 IN VARCHAR2 DEFAULT NULL,
194 x_school_code_7 IN VARCHAR2 DEFAULT NULL,
195 x_housing_code_7 IN VARCHAR2 DEFAULT NULL,
196 x_school_code_8 IN VARCHAR2 DEFAULT NULL,
197 x_housing_code_8 IN VARCHAR2 DEFAULT NULL,
198 x_school_code_9 IN VARCHAR2 DEFAULT NULL,
199 x_housing_code_9 IN VARCHAR2 DEFAULT NULL,
200 x_school_code_10 IN VARCHAR2 DEFAULT NULL,
201 x_housing_code_10 IN VARCHAR2 DEFAULT NULL,
202 x_additional_school_code_1 IN VARCHAR2 DEFAULT NULL,
203 x_additional_school_code_2 IN VARCHAR2 DEFAULT NULL,
204 x_additional_school_code_3 IN VARCHAR2 DEFAULT NULL,
205 x_additional_school_code_4 IN VARCHAR2 DEFAULT NULL,
206 x_additional_school_code_5 IN VARCHAR2 DEFAULT NULL,
207 x_additional_school_code_6 IN VARCHAR2 DEFAULT NULL,
208 x_additional_school_code_7 IN VARCHAR2 DEFAULT NULL,
209 x_additional_school_code_8 IN VARCHAR2 DEFAULT NULL,
210 x_additional_school_code_9 IN VARCHAR2 DEFAULT NULL,
211 x_additional_school_code_10 IN VARCHAR2 DEFAULT NULL,
212 x_explanation_spec_circum IN VARCHAR2 DEFAULT NULL,
213 x_signature_student IN VARCHAR2 DEFAULT NULL,
214 x_signature_spouse IN VARCHAR2 DEFAULT NULL,
215 x_signature_father IN VARCHAR2 DEFAULT NULL,
216 x_signature_mother IN VARCHAR2 DEFAULT NULL,
217 x_month_day_completed IN VARCHAR2 DEFAULT NULL,
218 x_year_completed IN VARCHAR2 DEFAULT NULL,
219 x_age_line_2 IN VARCHAR2 DEFAULT NULL,
220 x_age_line_3 IN VARCHAR2 DEFAULT NULL,
221 x_age_line_4 IN VARCHAR2 DEFAULT NULL,
222 x_age_line_5 IN VARCHAR2 DEFAULT NULL,
226 x_a_online_signature IN VARCHAR2 DEFAULT NULL,
223 x_age_line_6 IN VARCHAR2 DEFAULT NULL,
224 x_age_line_7 IN VARCHAR2 DEFAULT NULL,
225 x_age_line_8 IN VARCHAR2 DEFAULT NULL,
227 x_question_1_number IN VARCHAR2 DEFAULT NULL,
228 x_question_1_size IN VARCHAR2 DEFAULT NULL,
229 x_question_1_answer IN VARCHAR2 DEFAULT NULL,
230 x_question_2_number IN VARCHAR2 DEFAULT NULL,
231 x_question_2_size IN VARCHAR2 DEFAULT NULL,
232 x_question_2_answer IN VARCHAR2 DEFAULT NULL,
233 x_question_3_number IN VARCHAR2 DEFAULT NULL,
234 x_question_3_size IN VARCHAR2 DEFAULT NULL,
235 x_question_3_answer IN VARCHAR2 DEFAULT NULL,
236 x_question_4_number IN VARCHAR2 DEFAULT NULL,
237 x_question_4_size IN VARCHAR2 DEFAULT NULL,
238 x_question_4_answer IN VARCHAR2 DEFAULT NULL,
239 x_question_5_number IN VARCHAR2 DEFAULT NULL,
240 x_question_5_size IN VARCHAR2 DEFAULT NULL,
241 x_question_5_answer IN VARCHAR2 DEFAULT NULL,
242 x_question_6_number IN VARCHAR2 DEFAULT NULL,
243 x_question_6_size IN VARCHAR2 DEFAULT NULL,
244 x_question_6_answer IN VARCHAR2 DEFAULT NULL,
245 x_question_7_number IN VARCHAR2 DEFAULT NULL,
246 x_question_7_size IN VARCHAR2 DEFAULT NULL,
247 x_question_7_answer IN VARCHAR2 DEFAULT NULL,
248 x_question_8_number IN VARCHAR2 DEFAULT NULL,
249 x_question_8_size IN VARCHAR2 DEFAULT NULL,
250 x_question_8_answer IN VARCHAR2 DEFAULT NULL,
251 x_question_9_number IN VARCHAR2 DEFAULT NULL,
252 x_question_9_size IN VARCHAR2 DEFAULT NULL,
253 x_question_9_answer IN VARCHAR2 DEFAULT NULL,
254 x_question_10_number IN VARCHAR2 DEFAULT NULL,
255 x_question_10_size IN VARCHAR2 DEFAULT NULL,
256 x_question_10_answer IN VARCHAR2 DEFAULT NULL,
257 x_question_11_number IN VARCHAR2 DEFAULT NULL,
258 x_question_11_size IN VARCHAR2 DEFAULT NULL,
259 x_question_11_answer IN VARCHAR2 DEFAULT NULL,
260 x_question_12_number IN VARCHAR2 DEFAULT NULL,
261 x_question_12_size IN VARCHAR2 DEFAULT NULL,
262 x_question_12_answer IN VARCHAR2 DEFAULT NULL,
263 x_question_13_number IN VARCHAR2 DEFAULT NULL,
264 x_question_13_size IN VARCHAR2 DEFAULT NULL,
265 x_question_13_answer IN VARCHAR2 DEFAULT NULL,
266 x_question_14_number IN VARCHAR2 DEFAULT NULL,
267 x_question_14_size IN VARCHAR2 DEFAULT NULL,
268 x_question_14_answer IN VARCHAR2 DEFAULT NULL,
269 x_question_15_number IN VARCHAR2 DEFAULT NULL,
270 x_question_15_size IN VARCHAR2 DEFAULT NULL,
271 x_question_15_answer IN VARCHAR2 DEFAULT NULL,
272 x_question_16_number IN VARCHAR2 DEFAULT NULL,
273 x_question_16_size IN VARCHAR2 DEFAULT NULL,
274 x_question_16_answer IN VARCHAR2 DEFAULT NULL,
275 x_question_17_number IN VARCHAR2 DEFAULT NULL,
276 x_question_17_size IN VARCHAR2 DEFAULT NULL,
277 x_question_17_answer IN VARCHAR2 DEFAULT NULL,
278 x_question_18_number IN VARCHAR2 DEFAULT NULL,
279 x_question_18_size IN VARCHAR2 DEFAULT NULL,
280 x_question_18_answer IN VARCHAR2 DEFAULT NULL,
281 x_question_19_number IN VARCHAR2 DEFAULT NULL,
282 x_question_19_size IN VARCHAR2 DEFAULT NULL,
283 x_question_19_answer IN VARCHAR2 DEFAULT NULL,
284 x_question_20_number IN VARCHAR2 DEFAULT NULL,
285 x_question_20_size IN VARCHAR2 DEFAULT NULL,
286 x_question_20_answer IN VARCHAR2 DEFAULT NULL,
287 x_question_21_number IN VARCHAR2 DEFAULT NULL,
288 x_question_21_size IN VARCHAR2 DEFAULT NULL,
289 x_question_21_answer IN VARCHAR2 DEFAULT NULL,
290 x_question_22_number IN VARCHAR2 DEFAULT NULL,
291 x_question_22_size IN VARCHAR2 DEFAULT NULL,
292 x_question_22_answer IN VARCHAR2 DEFAULT NULL,
293 x_question_23_number IN VARCHAR2 DEFAULT NULL,
294 x_question_23_size IN VARCHAR2 DEFAULT NULL,
295 x_question_23_answer IN VARCHAR2 DEFAULT NULL,
296 x_question_24_number IN VARCHAR2 DEFAULT NULL,
297 x_question_24_size IN VARCHAR2 DEFAULT NULL,
301 x_question_25_answer IN VARCHAR2 DEFAULT NULL,
298 x_question_24_answer IN VARCHAR2 DEFAULT NULL,
299 x_question_25_number IN VARCHAR2 DEFAULT NULL,
300 x_question_25_size IN VARCHAR2 DEFAULT NULL,
302 x_question_26_number IN VARCHAR2 DEFAULT NULL,
303 x_question_26_size IN VARCHAR2 DEFAULT NULL,
304 x_question_26_answer IN VARCHAR2 DEFAULT NULL,
305 x_question_27_number IN VARCHAR2 DEFAULT NULL,
306 x_question_27_size IN VARCHAR2 DEFAULT NULL,
307 x_question_27_answer IN VARCHAR2 DEFAULT NULL,
308 x_question_28_number IN VARCHAR2 DEFAULT NULL,
309 x_question_28_size IN VARCHAR2 DEFAULT NULL,
310 x_question_28_answer IN VARCHAR2 DEFAULT NULL,
311 x_question_29_number IN VARCHAR2 DEFAULT NULL,
312 x_question_29_size IN VARCHAR2 DEFAULT NULL,
313 x_question_29_answer IN VARCHAR2 DEFAULT NULL,
314 x_question_30_number IN VARCHAR2 DEFAULT NULL,
315 x_questions_30_size IN VARCHAR2 DEFAULT NULL,
316 x_question_30_answer IN VARCHAR2 DEFAULT NULL,
317 x_creation_date IN DATE DEFAULT NULL,
318 x_created_by IN NUMBER DEFAULT NULL,
319 x_last_update_date IN DATE DEFAULT NULL,
320 x_last_updated_by IN NUMBER DEFAULT NULL,
321 x_last_update_login IN NUMBER DEFAULT NULL
322 ) AS
323 /*
324 || Created By : kkillams
325 || Created On : 30-MAY-2001
326 || Purpose : Initialises the Old and New references for the columns of the table.
327 || Known limitations, enhancements or remarks :
328 || Change History :
329 || Who When What
330 || (reverse chronological order - newest change first)
331 */
332
333 CURSOR cur_old_ref_values IS
334 SELECT *
335 FROM IGF_AP_CS_UPD_FLAGS
336 WHERE rowid = x_rowid;
337
338 BEGIN
339
340 l_rowid := x_rowid;
341
342 -- Code for setting the Old and New Reference Values.
343 -- Populate Old Values.
344 OPEN cur_old_ref_values;
345 FETCH cur_old_ref_values INTO old_references;
346 IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
347 CLOSE cur_old_ref_values;
348 fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
349 igs_ge_msg_stack.add;
350 app_exception.raise_exception;
351 RETURN;
352 END IF;
353 CLOSE cur_old_ref_values;
354
355 -- Populate New Values.
356 new_references.base_id := x_base_id;
357 new_references.last_name := x_last_name;
358 new_references.first_name := x_first_name;
359 new_references.middle_initial := x_middle_initial;
360 new_references.address_number_and_street := x_address_number_and_street;
361 new_references.city := x_city;
362 new_references.state_mailing := x_state_mailing;
363 new_references.zip_code := x_zip_code;
364 new_references.s_telephone_number := x_s_telephone_number;
365 new_references.s_title := x_s_title;
366 new_references.date_of_birth := x_date_of_birth;
367 new_references.social_security_number := x_social_security_number;
368 new_references.state_legal_residence := x_state_legal_residence;
369 new_references.foreign_address_indicator := x_foreign_address_indicator;
370 new_references.foreign_postal_code := x_foreign_postal_code;
371 new_references.country := x_country;
372 new_references.financial_aid_status := x_financial_aid_status;
373 new_references.year_in_college := x_year_in_college;
374 new_references.marital_status := x_marital_status;
375 new_references.ward_court := x_ward_court;
376 new_references.legal_dependents_other := x_legal_dependents_other;
377 new_references.household_size := x_household_size;
378 new_references.number_in_college := x_number_in_college;
379 new_references.citizenship_status := x_citizenship_status;
380 new_references.citizenship_country := x_citizenship_country;
381 new_references.visa_classification := x_visa_classification;
382 new_references.tax_figures := x_tax_figures;
383 new_references.number_exemptions := x_number_exemptions;
384 new_references.adjusted_gross_inc := x_adjusted_gross_inc;
385 new_references.us_tax_paid := x_us_tax_paid;
386 new_references.itemized_deductions := x_itemized_deductions;
387 new_references.stu_income_work := x_stu_income_work;
388 new_references.spouse_income_work := x_spouse_income_work;
389 new_references.divid_int_inc := x_divid_int_inc;
390 new_references.soc_sec_benefits := x_soc_sec_benefits;
394 new_references.other_untax_income := x_other_untax_income;
391 new_references.welfare_tanf := x_welfare_tanf;
392 new_references.child_supp_rcvd := x_child_supp_rcvd;
393 new_references.earned_income_credit := x_earned_income_credit;
395 new_references.tax_stu_aid := x_tax_stu_aid;
396 new_references.cash_sav_check := x_cash_sav_check;
397 new_references.ira_keogh := x_ira_keogh;
398 new_references.invest_value := x_invest_value;
399 new_references.invest_debt := x_invest_debt;
400 new_references.home_value := x_home_value;
401 new_references.home_debt := x_home_debt;
402 new_references.oth_real_value := x_oth_real_value;
403 new_references.oth_real_debt := x_oth_real_debt;
404 new_references.bus_farm_value := x_bus_farm_value;
405 new_references.bus_farm_debt := x_bus_farm_debt;
406 new_references.live_on_farm := x_live_on_farm;
407 new_references.home_purch_price := x_home_purch_price;
408 new_references.hope_ll_credit := x_hope_ll_credit;
409 new_references.home_purch_year := x_home_purch_year;
410 new_references.trust_amount := x_trust_amount;
411 new_references.trust_avail := x_trust_avail;
412 new_references.trust_estab := x_trust_estab;
413 new_references.child_support_paid := x_child_support_paid;
414 new_references.med_dent_expenses := x_med_dent_expenses;
415 new_references.vet_us := x_vet_us;
416 new_references.vet_ben_amount := x_vet_ben_amount;
417 new_references.vet_ben_months := x_vet_ben_months;
418 new_references.stu_summer_wages := x_stu_summer_wages;
419 new_references.stu_school_yr_wages := x_stu_school_yr_wages;
420 new_references.spouse_summer_wages := x_spouse_summer_wages;
421 new_references.spouse_school_yr_wages := x_spouse_school_yr_wages;
422 new_references.summer_other_tax_inc := x_summer_other_tax_inc;
423 new_references.school_yr_other_tax_inc := x_school_yr_other_tax_inc;
424 new_references.summer_untax_inc := x_summer_untax_inc;
425 new_references.school_yr_untax_inc := x_school_yr_untax_inc;
426 new_references.grants_schol_etc := x_grants_schol_etc;
427 new_references.tuit_benefits := x_tuit_benefits;
428 new_references.cont_parents := x_cont_parents;
429 new_references.cont_relatives := x_cont_relatives;
430 new_references.p_siblings_pre_tuit := x_p_siblings_pre_tuit;
431 new_references.p_student_pre_tuit := x_p_student_pre_tuit;
432 new_references.p_household_size := x_p_household_size;
433 new_references.p_number_in_college := x_p_number_in_college;
434 new_references.p_parents_in_college := x_p_parents_in_college;
435 new_references.p_marital_status := x_p_marital_status;
436 new_references.p_state_legal_residence := x_p_state_legal_residence;
437 new_references.p_natural_par_status := x_p_natural_par_status;
438 new_references.p_child_supp_paid := x_p_child_supp_paid;
439 new_references.p_repay_ed_loans := x_p_repay_ed_loans;
440 new_references.p_med_dent_expenses := x_p_med_dent_expenses;
441 new_references.p_tuit_paid_amount := x_p_tuit_paid_amount;
442 new_references.p_tuit_paid_number := x_p_tuit_paid_number;
443 new_references.p_exp_child_supp_paid := x_p_exp_child_supp_paid;
444 new_references.p_exp_repay_ed_loans := x_p_exp_repay_ed_loans;
445 new_references.p_exp_med_dent_expenses := x_p_exp_med_dent_expenses;
446 new_references.p_exp_tuit_pd_amount := x_p_exp_tuit_pd_amount;
447 new_references.p_exp_tuit_pd_number := x_p_exp_tuit_pd_number;
448 new_references.p_cash_sav_check := x_p_cash_sav_check;
449 new_references.p_month_mortgage_pay := x_p_month_mortgage_pay;
450 new_references.p_invest_value := x_p_invest_value;
451 new_references.p_invest_debt := x_p_invest_debt;
452 new_references.p_home_value := x_p_home_value;
453 new_references.p_home_debt := x_p_home_debt;
454 new_references.p_home_purch_price := x_p_home_purch_price;
455 new_references.p_own_business_farm := x_p_own_business_farm;
456 new_references.p_business_value := x_p_business_value;
457 new_references.p_business_debt := x_p_business_debt;
458 new_references.p_farm_value := x_p_farm_value;
459 new_references.p_farm_debt := x_p_farm_debt;
460 new_references.p_live_on_farm := x_p_live_on_farm;
461 new_references.p_oth_real_estate_value := x_p_oth_real_estate_value;
462 new_references.p_oth_real_estate_debt := x_p_oth_real_estate_debt;
463 new_references.p_oth_real_purch_price := x_p_oth_real_purch_price;
464 new_references.p_siblings_assets := x_p_siblings_assets;
465 new_references.p_home_purch_year := x_p_home_purch_year;
466 new_references.p_oth_real_purch_year := x_p_oth_real_purch_year;
470 new_references.p_prior_other_untax_inc := x_p_prior_other_untax_inc;
467 new_references.p_prior_agi := x_p_prior_agi;
468 new_references.p_prior_us_tax_paid := x_p_prior_us_tax_paid;
469 new_references.p_prior_item_deductions := x_p_prior_item_deductions;
471 new_references.p_tax_figures := x_p_tax_figures;
472 new_references.p_number_exemptions := x_p_number_exemptions;
473 new_references.p_adjusted_gross_inc := x_p_adjusted_gross_inc;
474 new_references.p_wages_sal_tips := x_p_wages_sal_tips;
475 new_references.p_interest_income := x_p_interest_income;
476 new_references.p_dividend_income := x_p_dividend_income;
477 new_references.p_net_inc_bus_farm := x_p_net_inc_bus_farm;
478 new_references.p_other_taxable_income := x_p_other_taxable_income;
479 new_references.p_adj_to_income := x_p_adj_to_income;
480 new_references.p_us_tax_paid := x_p_us_tax_paid;
481 new_references.p_itemized_deductions := x_p_itemized_deductions;
482 new_references.p_father_income_work := x_p_father_income_work;
483 new_references.p_mother_income_work := x_p_mother_income_work;
484 new_references.p_soc_sec_ben := x_p_soc_sec_ben;
485 new_references.p_welfare_tanf := x_p_welfare_tanf;
486 new_references.p_child_supp_rcvd := x_p_child_supp_rcvd;
487 new_references.p_ded_ira_keogh := x_p_ded_ira_keogh;
488 new_references.p_tax_defer_pens_savs := x_p_tax_defer_pens_savs;
489 new_references.p_dep_care_med_spending := x_p_dep_care_med_spending;
490 new_references.p_earned_income_credit := x_p_earned_income_credit;
491 new_references.p_living_allow := x_p_living_allow;
492 new_references.p_tax_exmpt_int := x_p_tax_exmpt_int;
493 new_references.p_foreign_inc_excl := x_p_foreign_inc_excl;
494 new_references.p_other_untax_inc := x_p_other_untax_inc;
495 new_references.p_hope_ll_credit := x_p_hope_ll_credit;
496 new_references.p_yr_separation := x_p_yr_separation;
497 new_references.p_yr_divorce := x_p_yr_divorce;
498 new_references.p_exp_father_inc := x_p_exp_father_inc;
499 new_references.p_exp_mother_inc := x_p_exp_mother_inc;
500 new_references.p_exp_other_tax_inc := x_p_exp_other_tax_inc;
501 new_references.p_exp_other_untax_inc := x_p_exp_other_untax_inc;
502 new_references.line_2_relation := x_line_2_relation;
503 new_references.line_2_attend_college := x_line_2_attend_college;
504 new_references.line_3_relation := x_line_3_relation;
505 new_references.line_3_attend_college := x_line_3_attend_college;
506 new_references.line_4_relation := x_line_4_relation;
507 new_references.line_4_attend_college := x_line_4_attend_college;
508 new_references.line_5_relation := x_line_5_relation;
509 new_references.line_5_attend_college := x_line_5_attend_college;
510 new_references.line_6_relation := x_line_6_relation;
511 new_references.line_6_attend_college := x_line_6_attend_college;
512 new_references.line_7_relation := x_line_7_relation;
513 new_references.line_7_attend_college := x_line_7_attend_college;
514 new_references.line_8_relation := x_line_8_relation;
515 new_references.line_8_attend_college := x_line_8_attend_college;
516 new_references.p_age_father := x_p_age_father;
517 new_references.p_age_mother := x_p_age_mother;
518 new_references.p_div_sep_ind := x_p_div_sep_ind;
519 new_references.b_cont_non_custodial_par := x_b_cont_non_custodial_par;
520 new_references.college_type_2 := x_college_type_2;
521 new_references.college_type_3 := x_college_type_3;
522 new_references.college_type_4 := x_college_type_4;
523 new_references.college_type_5 := x_college_type_5;
524 new_references.college_type_6 := x_college_type_6;
525 new_references.college_type_7 := x_college_type_7;
529 new_references.school_code_2 := x_school_code_2;
526 new_references.college_type_8 := x_college_type_8;
527 new_references.school_code_1 := x_school_code_1;
528 new_references.housing_code_1 := x_housing_code_1;
530 new_references.housing_code_2 := x_housing_code_2;
531 new_references.school_code_3 := x_school_code_3;
532 new_references.housing_code_3 := x_housing_code_3;
533 new_references.school_code_4 := x_school_code_4;
534 new_references.housing_code_4 := x_housing_code_4;
535 new_references.school_code_5 := x_school_code_5;
536 new_references.housing_code_5 := x_housing_code_5;
537 new_references.school_code_6 := x_school_code_6;
538 new_references.housing_code_6 := x_housing_code_6;
539 new_references.school_code_7 := x_school_code_7;
540 new_references.housing_code_7 := x_housing_code_7;
541 new_references.school_code_8 := x_school_code_8;
542 new_references.housing_code_8 := x_housing_code_8;
543 new_references.school_code_9 := x_school_code_9;
544 new_references.housing_code_9 := x_housing_code_9;
545 new_references.school_code_10 := x_school_code_10;
546 new_references.housing_code_10 := x_housing_code_10;
547 new_references.additional_school_code_1 := x_additional_school_code_1;
548 new_references.additional_school_code_2 := x_additional_school_code_2;
549 new_references.additional_school_code_3 := x_additional_school_code_3;
550 new_references.additional_school_code_4 := x_additional_school_code_4;
551 new_references.additional_school_code_5 := x_additional_school_code_5;
552 new_references.additional_school_code_6 := x_additional_school_code_6;
553 new_references.additional_school_code_7 := x_additional_school_code_7;
554 new_references.additional_school_code_8 := x_additional_school_code_8;
555 new_references.additional_school_code_9 := x_additional_school_code_9;
556 new_references.additional_school_code_10 := x_additional_school_code_10;
557 new_references.explanation_spec_circum := x_explanation_spec_circum;
558 new_references.signature_student := x_signature_student;
559 new_references.signature_spouse := x_signature_spouse;
560 new_references.signature_father := x_signature_father;
561 new_references.signature_mother := x_signature_mother;
562 new_references.month_day_completed := x_month_day_completed;
563 new_references.year_completed := x_year_completed;
564 new_references.age_line_2 := x_age_line_2;
565 new_references.age_line_3 := x_age_line_3;
566 new_references.age_line_4 := x_age_line_4;
567 new_references.age_line_5 := x_age_line_5;
568 new_references.age_line_6 := x_age_line_6;
569 new_references.age_line_7 := x_age_line_7;
570 new_references.age_line_8 := x_age_line_8;
571 new_references.a_online_signature := x_a_online_signature;
572 new_references.question_1_number := x_question_1_number;
573 new_references.question_1_size := x_question_1_size;
574 new_references.question_1_answer := x_question_1_answer;
575 new_references.question_2_number := x_question_2_number;
579 new_references.question_3_size := x_question_3_size;
576 new_references.question_2_size := x_question_2_size;
577 new_references.question_2_answer := x_question_2_answer;
578 new_references.question_3_number := x_question_3_number;
580 new_references.question_3_answer := x_question_3_answer;
581 new_references.question_4_number := x_question_4_number;
582 new_references.question_4_size := x_question_4_size;
583 new_references.question_4_answer := x_question_4_answer;
584 new_references.question_5_number := x_question_5_number;
585 new_references.question_5_size := x_question_5_size;
586 new_references.question_5_answer := x_question_5_answer;
587 new_references.question_6_number := x_question_6_number;
588 new_references.question_6_size := x_question_6_size;
589 new_references.question_6_answer := x_question_6_answer;
590 new_references.question_7_number := x_question_7_number;
591 new_references.question_7_size := x_question_7_size;
592 new_references.question_7_answer := x_question_7_answer;
593 new_references.question_8_number := x_question_8_number;
594 new_references.question_8_size := x_question_8_size;
595 new_references.question_8_answer := x_question_8_answer;
596 new_references.question_9_number := x_question_9_number;
597 new_references.question_9_size := x_question_9_size;
598 new_references.question_9_answer := x_question_9_answer;
599 new_references.question_10_number := x_question_10_number;
600 new_references.question_10_size := x_question_10_size;
601 new_references.question_10_answer := x_question_10_answer;
602 new_references.question_11_number := x_question_11_number;
603 new_references.question_11_size := x_question_11_size;
604 new_references.question_11_answer := x_question_11_answer;
605 new_references.question_12_number := x_question_12_number;
606 new_references.question_12_size := x_question_12_size;
607 new_references.question_12_answer := x_question_12_answer;
608 new_references.question_13_number := x_question_13_number;
609 new_references.question_13_size := x_question_13_size;
610 new_references.question_13_answer := x_question_13_answer;
611 new_references.question_14_number := x_question_14_number;
612 new_references.question_14_size := x_question_14_size;
613 new_references.question_14_answer := x_question_14_answer;
614 new_references.question_15_number := x_question_15_number;
615 new_references.question_15_size := x_question_15_size;
616 new_references.question_15_answer := x_question_15_answer;
617 new_references.question_16_number := x_question_16_number;
618 new_references.question_16_size := x_question_16_size;
619 new_references.question_16_answer := x_question_16_answer;
620 new_references.question_17_number := x_question_17_number;
621 new_references.question_17_size := x_question_17_size;
622 new_references.question_17_answer := x_question_17_answer;
623 new_references.question_18_number := x_question_18_number;
624 new_references.question_18_size := x_question_18_size;
625 new_references.question_18_answer := x_question_18_answer;
626 new_references.question_19_number := x_question_19_number;
627 new_references.question_19_size := x_question_19_size;
628 new_references.question_19_answer := x_question_19_answer;
629 new_references.question_20_number := x_question_20_number;
630 new_references.question_20_size := x_question_20_size;
634 new_references.question_21_answer := x_question_21_answer;
631 new_references.question_20_answer := x_question_20_answer;
632 new_references.question_21_number := x_question_21_number;
633 new_references.question_21_size := x_question_21_size;
635 new_references.question_22_number := x_question_22_number;
636 new_references.question_22_size := x_question_22_size;
637 new_references.question_22_answer := x_question_22_answer;
638 new_references.question_23_number := x_question_23_number;
639 new_references.question_23_size := x_question_23_size;
640 new_references.question_23_answer := x_question_23_answer;
641 new_references.question_24_number := x_question_24_number;
642 new_references.question_24_size := x_question_24_size;
643 new_references.question_24_answer := x_question_24_answer;
644 new_references.question_25_number := x_question_25_number;
645 new_references.question_25_size := x_question_25_size;
646 new_references.question_25_answer := x_question_25_answer;
647 new_references.question_26_number := x_question_26_number;
648 new_references.question_26_size := x_question_26_size;
649 new_references.question_26_answer := x_question_26_answer;
650 new_references.question_27_number := x_question_27_number;
651 new_references.question_27_size := x_question_27_size;
652 new_references.question_27_answer := x_question_27_answer;
653 new_references.question_28_number := x_question_28_number;
654 new_references.question_28_size := x_question_28_size;
655 new_references.question_28_answer := x_question_28_answer;
656 new_references.question_29_number := x_question_29_number;
657 new_references.question_29_size := x_question_29_size;
658 new_references.question_29_answer := x_question_29_answer;
659 new_references.question_30_number := x_question_30_number;
660 new_references.questions_30_size := x_questions_30_size;
661 new_references.question_30_answer := x_question_30_answer;
662
663 IF (p_action = 'UPDATE') THEN
664 new_references.creation_date := old_references.creation_date;
665 new_references.created_by := old_references.created_by;
666 ELSE
667 new_references.creation_date := x_creation_date;
668 new_references.created_by := x_created_by;
669 END IF;
670
671 new_references.last_update_date := x_last_update_date;
672 new_references.last_updated_by := x_last_updated_by;
673 new_references.last_update_login := x_last_update_login;
674
675 END set_column_values;
676
677
678 FUNCTION get_pk_for_validation (
679 x_base_id IN NUMBER
680 ) RETURN BOOLEAN AS
681 /*
682 || Created By : kkillams
683 || Created On : 30-MAY-2001
684 || Purpose : Validates the Primary Key of the table.
685 || Known limitations, enhancements or remarks :
686 || Change History :
687 || Who When What
688 || (reverse chronological order - newest change first)
689 */
690 CURSOR cur_rowid IS
691 SELECT rowid
692 FROM igf_ap_cs_upd_flags
693 WHERE base_id = x_base_id
694 FOR UPDATE NOWAIT;
695
696 lv_rowid cur_rowid%RowType;
697
698 BEGIN
699
700 OPEN cur_rowid;
701 FETCH cur_rowid INTO lv_rowid;
702 IF (cur_rowid%FOUND) THEN
703 CLOSE cur_rowid;
704 RETURN(TRUE);
705 ELSE
706 CLOSE cur_rowid;
707 RETURN(FALSE);
708 END IF;
709
710 END get_pk_for_validation;
711
712
713 PROCEDURE before_dml (
714 p_action IN VARCHAR2,
715 x_rowid IN VARCHAR2 DEFAULT NULL,
716 x_base_id IN NUMBER DEFAULT NULL,
717 x_last_name IN VARCHAR2 DEFAULT NULL,
718 x_first_name IN VARCHAR2 DEFAULT NULL,
719 x_middle_initial IN VARCHAR2 DEFAULT NULL,
720 x_address_number_and_street IN VARCHAR2 DEFAULT NULL,
721 x_city IN VARCHAR2 DEFAULT NULL,
722 x_state_mailing IN VARCHAR2 DEFAULT NULL,
723 x_zip_code IN VARCHAR2 DEFAULT NULL,
724 x_s_telephone_number IN VARCHAR2 DEFAULT NULL,
725 x_s_title IN VARCHAR2 DEFAULT NULL,
726 x_date_of_birth IN VARCHAR2 DEFAULT NULL,
727 x_social_security_number IN VARCHAR2 DEFAULT NULL,
728 x_state_legal_residence IN VARCHAR2 DEFAULT NULL,
729 x_foreign_address_indicator IN VARCHAR2 DEFAULT NULL,
730 x_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
731 x_country IN VARCHAR2 DEFAULT NULL,
732 x_financial_aid_status IN VARCHAR2 DEFAULT NULL,
733 x_year_in_college IN VARCHAR2 DEFAULT NULL,
737 x_household_size IN VARCHAR2 DEFAULT NULL,
734 x_marital_status IN VARCHAR2 DEFAULT NULL,
735 x_ward_court IN VARCHAR2 DEFAULT NULL,
736 x_legal_dependents_other IN VARCHAR2 DEFAULT NULL,
738 x_number_in_college IN VARCHAR2 DEFAULT NULL,
739 x_citizenship_status IN VARCHAR2 DEFAULT NULL,
740 x_citizenship_country IN VARCHAR2 DEFAULT NULL,
741 x_visa_classification IN VARCHAR2 DEFAULT NULL,
742 x_tax_figures IN VARCHAR2 DEFAULT NULL,
743 x_number_exemptions IN VARCHAR2 DEFAULT NULL,
744 x_adjusted_gross_inc IN VARCHAR2 DEFAULT NULL,
745 x_us_tax_paid IN VARCHAR2 DEFAULT NULL,
746 x_itemized_deductions IN VARCHAR2 DEFAULT NULL,
747 x_stu_income_work IN VARCHAR2 DEFAULT NULL,
748 x_spouse_income_work IN VARCHAR2 DEFAULT NULL,
749 x_divid_int_inc IN VARCHAR2 DEFAULT NULL,
750 x_soc_sec_benefits IN VARCHAR2 DEFAULT NULL,
751 x_welfare_tanf IN VARCHAR2 DEFAULT NULL,
752 x_child_supp_rcvd IN VARCHAR2 DEFAULT NULL,
753 x_earned_income_credit IN VARCHAR2 DEFAULT NULL,
754 x_other_untax_income IN VARCHAR2 DEFAULT NULL,
755 x_tax_stu_aid IN VARCHAR2 DEFAULT NULL,
756 x_cash_sav_check IN VARCHAR2 DEFAULT NULL,
757 x_ira_keogh IN VARCHAR2 DEFAULT NULL,
758 x_invest_value IN VARCHAR2 DEFAULT NULL,
759 x_invest_debt IN VARCHAR2 DEFAULT NULL,
760 x_home_value IN VARCHAR2 DEFAULT NULL,
761 x_home_debt IN VARCHAR2 DEFAULT NULL,
762 x_oth_real_value IN VARCHAR2 DEFAULT NULL,
763 x_oth_real_debt IN VARCHAR2 DEFAULT NULL,
764 x_bus_farm_value IN VARCHAR2 DEFAULT NULL,
765 x_bus_farm_debt IN VARCHAR2 DEFAULT NULL,
766 x_live_on_farm IN VARCHAR2 DEFAULT NULL,
767 x_home_purch_price IN VARCHAR2 DEFAULT NULL,
768 x_hope_ll_credit IN VARCHAR2 DEFAULT NULL,
769 x_home_purch_year IN VARCHAR2 DEFAULT NULL,
770 x_trust_amount IN VARCHAR2 DEFAULT NULL,
771 x_trust_avail IN VARCHAR2 DEFAULT NULL,
772 x_trust_estab IN VARCHAR2 DEFAULT NULL,
773 x_child_support_paid IN VARCHAR2 DEFAULT NULL,
774 x_med_dent_expenses IN VARCHAR2 DEFAULT NULL,
775 x_vet_us IN VARCHAR2 DEFAULT NULL,
776 x_vet_ben_amount IN VARCHAR2 DEFAULT NULL,
777 x_vet_ben_months IN VARCHAR2 DEFAULT NULL,
778 x_stu_summer_wages IN VARCHAR2 DEFAULT NULL,
779 x_stu_school_yr_wages IN VARCHAR2 DEFAULT NULL,
780 x_spouse_summer_wages IN VARCHAR2 DEFAULT NULL,
781 x_spouse_school_yr_wages IN VARCHAR2 DEFAULT NULL,
782 x_summer_other_tax_inc IN VARCHAR2 DEFAULT NULL,
783 x_school_yr_other_tax_inc IN VARCHAR2 DEFAULT NULL,
784 x_summer_untax_inc IN VARCHAR2 DEFAULT NULL,
785 x_school_yr_untax_inc IN VARCHAR2 DEFAULT NULL,
786 x_grants_schol_etc IN VARCHAR2 DEFAULT NULL,
787 x_tuit_benefits IN VARCHAR2 DEFAULT NULL,
788 x_cont_parents IN VARCHAR2 DEFAULT NULL,
789 x_cont_relatives IN VARCHAR2 DEFAULT NULL,
790 x_p_siblings_pre_tuit IN VARCHAR2 DEFAULT NULL,
791 x_p_student_pre_tuit IN VARCHAR2 DEFAULT NULL,
792 x_p_household_size IN VARCHAR2 DEFAULT NULL,
793 x_p_number_in_college IN VARCHAR2 DEFAULT NULL,
794 x_p_parents_in_college IN VARCHAR2 DEFAULT NULL,
795 x_p_marital_status IN VARCHAR2 DEFAULT NULL,
796 x_p_state_legal_residence IN VARCHAR2 DEFAULT NULL,
797 x_p_natural_par_status IN VARCHAR2 DEFAULT NULL,
798 x_p_child_supp_paid IN VARCHAR2 DEFAULT NULL,
799 x_p_repay_ed_loans IN VARCHAR2 DEFAULT NULL,
800 x_p_med_dent_expenses IN VARCHAR2 DEFAULT NULL,
801 x_p_tuit_paid_amount IN VARCHAR2 DEFAULT NULL,
802 x_p_tuit_paid_number IN VARCHAR2 DEFAULT NULL,
803 x_p_exp_child_supp_paid IN VARCHAR2 DEFAULT NULL,
804 x_p_exp_repay_ed_loans IN VARCHAR2 DEFAULT NULL,
805 x_p_exp_med_dent_expenses IN VARCHAR2 DEFAULT NULL,
806 x_p_exp_tuit_pd_amount IN VARCHAR2 DEFAULT NULL,
807 x_p_exp_tuit_pd_number IN VARCHAR2 DEFAULT NULL,
808 x_p_cash_sav_check IN VARCHAR2 DEFAULT NULL,
809 x_p_month_mortgage_pay IN VARCHAR2 DEFAULT NULL,
810 x_p_invest_value IN VARCHAR2 DEFAULT NULL,
814 x_p_home_purch_price IN VARCHAR2 DEFAULT NULL,
811 x_p_invest_debt IN VARCHAR2 DEFAULT NULL,
812 x_p_home_value IN VARCHAR2 DEFAULT NULL,
813 x_p_home_debt IN VARCHAR2 DEFAULT NULL,
815 x_p_own_business_farm IN VARCHAR2 DEFAULT NULL,
816 x_p_business_value IN VARCHAR2 DEFAULT NULL,
817 x_p_business_debt IN VARCHAR2 DEFAULT NULL,
818 x_p_farm_value IN VARCHAR2 DEFAULT NULL,
819 x_p_farm_debt IN VARCHAR2 DEFAULT NULL,
820 x_p_live_on_farm IN VARCHAR2 DEFAULT NULL,
821 x_p_oth_real_estate_value IN VARCHAR2 DEFAULT NULL,
822 x_p_oth_real_estate_debt IN VARCHAR2 DEFAULT NULL,
823 x_p_oth_real_purch_price IN VARCHAR2 DEFAULT NULL,
824 x_p_siblings_assets IN VARCHAR2 DEFAULT NULL,
825 x_p_home_purch_year IN VARCHAR2 DEFAULT NULL,
826 x_p_oth_real_purch_year IN VARCHAR2 DEFAULT NULL,
827 x_p_prior_agi IN VARCHAR2 DEFAULT NULL,
828 x_p_prior_us_tax_paid IN VARCHAR2 DEFAULT NULL,
829 x_p_prior_item_deductions IN VARCHAR2 DEFAULT NULL,
830 x_p_prior_other_untax_inc IN VARCHAR2 DEFAULT NULL,
831 x_p_tax_figures IN VARCHAR2 DEFAULT NULL,
832 x_p_number_exemptions IN VARCHAR2 DEFAULT NULL,
833 x_p_adjusted_gross_inc IN VARCHAR2 DEFAULT NULL,
834 x_p_wages_sal_tips IN VARCHAR2 DEFAULT NULL,
835 x_p_interest_income IN VARCHAR2 DEFAULT NULL,
836 x_p_dividend_income IN VARCHAR2 DEFAULT NULL,
837 x_p_net_inc_bus_farm IN VARCHAR2 DEFAULT NULL,
838 x_p_other_taxable_income IN VARCHAR2 DEFAULT NULL,
839 x_p_adj_to_income IN VARCHAR2 DEFAULT NULL,
840 x_p_us_tax_paid IN VARCHAR2 DEFAULT NULL,
841 x_p_itemized_deductions IN VARCHAR2 DEFAULT NULL,
842 x_p_father_income_work IN VARCHAR2 DEFAULT NULL,
843 x_p_mother_income_work IN VARCHAR2 DEFAULT NULL,
844 x_p_soc_sec_ben IN VARCHAR2 DEFAULT NULL,
845 x_p_welfare_tanf IN VARCHAR2 DEFAULT NULL,
846 x_p_child_supp_rcvd IN VARCHAR2 DEFAULT NULL,
847 x_p_ded_ira_keogh IN VARCHAR2 DEFAULT NULL,
848 x_p_tax_defer_pens_savs IN VARCHAR2 DEFAULT NULL,
849 x_p_dep_care_med_spending IN VARCHAR2 DEFAULT NULL,
850 x_p_earned_income_credit IN VARCHAR2 DEFAULT NULL,
851 x_p_living_allow IN VARCHAR2 DEFAULT NULL,
852 x_p_tax_exmpt_int IN VARCHAR2 DEFAULT NULL,
853 x_p_foreign_inc_excl IN VARCHAR2 DEFAULT NULL,
854 x_p_other_untax_inc IN VARCHAR2 DEFAULT NULL,
855 x_p_hope_ll_credit IN VARCHAR2 DEFAULT NULL,
856 x_p_yr_separation IN VARCHAR2 DEFAULT NULL,
857 x_p_yr_divorce IN VARCHAR2 DEFAULT NULL,
858 x_p_exp_father_inc IN VARCHAR2 DEFAULT NULL,
859 x_p_exp_mother_inc IN VARCHAR2 DEFAULT NULL,
860 x_p_exp_other_tax_inc IN VARCHAR2 DEFAULT NULL,
861 x_p_exp_other_untax_inc IN VARCHAR2 DEFAULT NULL,
862 x_line_2_relation IN VARCHAR2 DEFAULT NULL,
863 x_line_2_attend_college IN VARCHAR2 DEFAULT NULL,
864 x_line_3_relation IN VARCHAR2 DEFAULT NULL,
865 x_line_3_attend_college IN VARCHAR2 DEFAULT NULL,
866 x_line_4_relation IN VARCHAR2 DEFAULT NULL,
867 x_line_4_attend_college IN VARCHAR2 DEFAULT NULL,
868 x_line_5_relation IN VARCHAR2 DEFAULT NULL,
869 x_line_5_attend_college IN VARCHAR2 DEFAULT NULL,
870 x_line_6_relation IN VARCHAR2 DEFAULT NULL,
871 x_line_6_attend_college IN VARCHAR2 DEFAULT NULL,
872 x_line_7_relation IN VARCHAR2 DEFAULT NULL,
873 x_line_7_attend_college IN VARCHAR2 DEFAULT NULL,
874 x_line_8_relation IN VARCHAR2 DEFAULT NULL,
875 x_line_8_attend_college IN VARCHAR2 DEFAULT NULL,
876 x_p_age_father IN VARCHAR2 DEFAULT NULL,
877 x_p_age_mother IN VARCHAR2 DEFAULT NULL,
878 x_p_div_sep_ind IN VARCHAR2 DEFAULT NULL,
879 x_b_cont_non_custodial_par IN VARCHAR2 DEFAULT NULL,
880 x_college_type_2 IN VARCHAR2 DEFAULT NULL,
881 x_college_type_3 IN VARCHAR2 DEFAULT NULL,
882 x_college_type_4 IN VARCHAR2 DEFAULT NULL,
886 x_college_type_8 IN VARCHAR2 DEFAULT NULL,
883 x_college_type_5 IN VARCHAR2 DEFAULT NULL,
884 x_college_type_6 IN VARCHAR2 DEFAULT NULL,
885 x_college_type_7 IN VARCHAR2 DEFAULT NULL,
887 x_school_code_1 IN VARCHAR2 DEFAULT NULL,
888 x_housing_code_1 IN VARCHAR2 DEFAULT NULL,
889 x_school_code_2 IN VARCHAR2 DEFAULT NULL,
890 x_housing_code_2 IN VARCHAR2 DEFAULT NULL,
891 x_school_code_3 IN VARCHAR2 DEFAULT NULL,
892 x_housing_code_3 IN VARCHAR2 DEFAULT NULL,
893 x_school_code_4 IN VARCHAR2 DEFAULT NULL,
894 x_housing_code_4 IN VARCHAR2 DEFAULT NULL,
895 x_school_code_5 IN VARCHAR2 DEFAULT NULL,
896 x_housing_code_5 IN VARCHAR2 DEFAULT NULL,
897 x_school_code_6 IN VARCHAR2 DEFAULT NULL,
898 x_housing_code_6 IN VARCHAR2 DEFAULT NULL,
899 x_school_code_7 IN VARCHAR2 DEFAULT NULL,
900 x_housing_code_7 IN VARCHAR2 DEFAULT NULL,
901 x_school_code_8 IN VARCHAR2 DEFAULT NULL,
902 x_housing_code_8 IN VARCHAR2 DEFAULT NULL,
903 x_school_code_9 IN VARCHAR2 DEFAULT NULL,
904 x_housing_code_9 IN VARCHAR2 DEFAULT NULL,
905 x_school_code_10 IN VARCHAR2 DEFAULT NULL,
906 x_housing_code_10 IN VARCHAR2 DEFAULT NULL,
907 x_additional_school_code_1 IN VARCHAR2 DEFAULT NULL,
908 x_additional_school_code_2 IN VARCHAR2 DEFAULT NULL,
909 x_additional_school_code_3 IN VARCHAR2 DEFAULT NULL,
910 x_additional_school_code_4 IN VARCHAR2 DEFAULT NULL,
911 x_additional_school_code_5 IN VARCHAR2 DEFAULT NULL,
912 x_additional_school_code_6 IN VARCHAR2 DEFAULT NULL,
913 x_additional_school_code_7 IN VARCHAR2 DEFAULT NULL,
914 x_additional_school_code_8 IN VARCHAR2 DEFAULT NULL,
915 x_additional_school_code_9 IN VARCHAR2 DEFAULT NULL,
916 x_additional_school_code_10 IN VARCHAR2 DEFAULT NULL,
917 x_explanation_spec_circum IN VARCHAR2 DEFAULT NULL,
918 x_signature_student IN VARCHAR2 DEFAULT NULL,
919 x_signature_spouse IN VARCHAR2 DEFAULT NULL,
920 x_signature_father IN VARCHAR2 DEFAULT NULL,
921 x_signature_mother IN VARCHAR2 DEFAULT NULL,
922 x_month_day_completed IN VARCHAR2 DEFAULT NULL,
923 x_year_completed IN VARCHAR2 DEFAULT NULL,
924 x_age_line_2 IN VARCHAR2 DEFAULT NULL,
925 x_age_line_3 IN VARCHAR2 DEFAULT NULL,
926 x_age_line_4 IN VARCHAR2 DEFAULT NULL,
927 x_age_line_5 IN VARCHAR2 DEFAULT NULL,
928 x_age_line_6 IN VARCHAR2 DEFAULT NULL,
929 x_age_line_7 IN VARCHAR2 DEFAULT NULL,
930 x_age_line_8 IN VARCHAR2 DEFAULT NULL,
931 x_a_online_signature IN VARCHAR2 DEFAULT NULL,
932 x_question_1_number IN VARCHAR2 DEFAULT NULL,
933 x_question_1_size IN VARCHAR2 DEFAULT NULL,
934 x_question_1_answer IN VARCHAR2 DEFAULT NULL,
935 x_question_2_number IN VARCHAR2 DEFAULT NULL,
936 x_question_2_size IN VARCHAR2 DEFAULT NULL,
937 x_question_2_answer IN VARCHAR2 DEFAULT NULL,
938 x_question_3_number IN VARCHAR2 DEFAULT NULL,
939 x_question_3_size IN VARCHAR2 DEFAULT NULL,
940 x_question_3_answer IN VARCHAR2 DEFAULT NULL,
941 x_question_4_number IN VARCHAR2 DEFAULT NULL,
942 x_question_4_size IN VARCHAR2 DEFAULT NULL,
943 x_question_4_answer IN VARCHAR2 DEFAULT NULL,
944 x_question_5_number IN VARCHAR2 DEFAULT NULL,
945 x_question_5_size IN VARCHAR2 DEFAULT NULL,
946 x_question_5_answer IN VARCHAR2 DEFAULT NULL,
947 x_question_6_number IN VARCHAR2 DEFAULT NULL,
948 x_question_6_size IN VARCHAR2 DEFAULT NULL,
949 x_question_6_answer IN VARCHAR2 DEFAULT NULL,
950 x_question_7_number IN VARCHAR2 DEFAULT NULL,
951 x_question_7_size IN VARCHAR2 DEFAULT NULL,
952 x_question_7_answer IN VARCHAR2 DEFAULT NULL,
953 x_question_8_number IN VARCHAR2 DEFAULT NULL,
954 x_question_8_size IN VARCHAR2 DEFAULT NULL,
955 x_question_8_answer IN VARCHAR2 DEFAULT NULL,
956 x_question_9_number IN VARCHAR2 DEFAULT NULL,
957 x_question_9_size IN VARCHAR2 DEFAULT NULL,
958 x_question_9_answer IN VARCHAR2 DEFAULT NULL,
959 x_question_10_number IN VARCHAR2 DEFAULT NULL,
960 x_question_10_size IN VARCHAR2 DEFAULT NULL,
964 x_question_11_answer IN VARCHAR2 DEFAULT NULL,
961 x_question_10_answer IN VARCHAR2 DEFAULT NULL,
962 x_question_11_number IN VARCHAR2 DEFAULT NULL,
963 x_question_11_size IN VARCHAR2 DEFAULT NULL,
965 x_question_12_number IN VARCHAR2 DEFAULT NULL,
966 x_question_12_size IN VARCHAR2 DEFAULT NULL,
967 x_question_12_answer IN VARCHAR2 DEFAULT NULL,
968 x_question_13_number IN VARCHAR2 DEFAULT NULL,
969 x_question_13_size IN VARCHAR2 DEFAULT NULL,
970 x_question_13_answer IN VARCHAR2 DEFAULT NULL,
974 x_question_15_number IN VARCHAR2 DEFAULT NULL,
971 x_question_14_number IN VARCHAR2 DEFAULT NULL,
972 x_question_14_size IN VARCHAR2 DEFAULT NULL,
973 x_question_14_answer IN VARCHAR2 DEFAULT NULL,
975 x_question_15_size IN VARCHAR2 DEFAULT NULL,
976 x_question_15_answer IN VARCHAR2 DEFAULT NULL,
977 x_question_16_number IN VARCHAR2 DEFAULT NULL,
978 x_question_16_size IN VARCHAR2 DEFAULT NULL,
979 x_question_16_answer IN VARCHAR2 DEFAULT NULL,
980 x_question_17_number IN VARCHAR2 DEFAULT NULL,
981 x_question_17_size IN VARCHAR2 DEFAULT NULL,
982 x_question_17_answer IN VARCHAR2 DEFAULT NULL,
983 x_question_18_number IN VARCHAR2 DEFAULT NULL,
984 x_question_18_size IN VARCHAR2 DEFAULT NULL,
985 x_question_18_answer IN VARCHAR2 DEFAULT NULL,
986 x_question_19_number IN VARCHAR2 DEFAULT NULL,
987 x_question_19_size IN VARCHAR2 DEFAULT NULL,
988 x_question_19_answer IN VARCHAR2 DEFAULT NULL,
989 x_question_20_number IN VARCHAR2 DEFAULT NULL,
990 x_question_20_size IN VARCHAR2 DEFAULT NULL,
991 x_question_20_answer IN VARCHAR2 DEFAULT NULL,
992 x_question_21_number IN VARCHAR2 DEFAULT NULL,
993 x_question_21_size IN VARCHAR2 DEFAULT NULL,
994 x_question_21_answer IN VARCHAR2 DEFAULT NULL,
995 x_question_22_number IN VARCHAR2 DEFAULT NULL,
996 x_question_22_size IN VARCHAR2 DEFAULT NULL,
997 x_question_22_answer IN VARCHAR2 DEFAULT NULL,
998 x_question_23_number IN VARCHAR2 DEFAULT NULL,
999 x_question_23_size IN VARCHAR2 DEFAULT NULL,
1000 x_question_23_answer IN VARCHAR2 DEFAULT NULL,
1001 x_question_24_number IN VARCHAR2 DEFAULT NULL,
1002 x_question_24_size IN VARCHAR2 DEFAULT NULL,
1003 x_question_24_answer IN VARCHAR2 DEFAULT NULL,
1004 x_question_25_number IN VARCHAR2 DEFAULT NULL,
1005 x_question_25_size IN VARCHAR2 DEFAULT NULL,
1006 x_question_25_answer IN VARCHAR2 DEFAULT NULL,
1007 x_question_26_number IN VARCHAR2 DEFAULT NULL,
1008 x_question_26_size IN VARCHAR2 DEFAULT NULL,
1009 x_question_26_answer IN VARCHAR2 DEFAULT NULL,
1010 x_question_27_number IN VARCHAR2 DEFAULT NULL,
1011 x_question_27_size IN VARCHAR2 DEFAULT NULL,
1012 x_question_27_answer IN VARCHAR2 DEFAULT NULL,
1013 x_question_28_number IN VARCHAR2 DEFAULT NULL,
1014 x_question_28_size IN VARCHAR2 DEFAULT NULL,
1015 x_question_28_answer IN VARCHAR2 DEFAULT NULL,
1016 x_question_29_number IN VARCHAR2 DEFAULT NULL,
1017 x_question_29_size IN VARCHAR2 DEFAULT NULL,
1018 x_question_29_answer IN VARCHAR2 DEFAULT NULL,
1019 x_question_30_number IN VARCHAR2 DEFAULT NULL,
1020 x_questions_30_size IN VARCHAR2 DEFAULT NULL,
1021 x_question_30_answer IN VARCHAR2 DEFAULT NULL,
1025 x_last_updated_by IN NUMBER DEFAULT NULL,
1022 x_creation_date IN DATE DEFAULT NULL,
1023 x_created_by IN NUMBER DEFAULT NULL,
1024 x_last_update_date IN DATE DEFAULT NULL,
1026 x_last_update_login IN NUMBER DEFAULT NULL
1027 ) AS
1028 /*
1029 || Created By : kkillams
1030 || Created On : 30-MAY-2001
1031 || Purpose : Initialises the columns, Checks Constraints, Calls the
1032 || Trigger Handlers for the table, before any DML operation.
1033 || Known limitations, enhancements or remarks :
1034 || Change History :
1035 || Who When What
1036 || (reverse chronological order - newest change first)
1037 */
1038 BEGIN
1039
1040 set_column_values (
1041 p_action,
1042 x_rowid,
1043 x_base_id,
1044 x_last_name,
1045 x_first_name,
1046 x_middle_initial,
1047 x_address_number_and_street,
1048 x_city,
1049 x_state_mailing,
1050 x_zip_code,
1051 x_s_telephone_number,
1052 x_s_title,
1053 x_date_of_birth,
1054 x_social_security_number,
1055 x_state_legal_residence,
1056 x_foreign_address_indicator,
1057 x_foreign_postal_code,
1058 x_country,
1059 x_financial_aid_status,
1060 x_year_in_college,
1061 x_marital_status,
1062 x_ward_court,
1063 x_legal_dependents_other,
1064 x_household_size,
1065 x_number_in_college,
1066 x_citizenship_status,
1067 x_citizenship_country,
1068 x_visa_classification,
1069 x_tax_figures,
1070 x_number_exemptions,
1071 x_adjusted_gross_inc,
1072 x_us_tax_paid,
1073 x_itemized_deductions,
1074 x_stu_income_work,
1075 x_spouse_income_work,
1076 x_divid_int_inc,
1077 x_soc_sec_benefits,
1078 x_welfare_tanf,
1079 x_child_supp_rcvd,
1080 x_earned_income_credit,
1081 x_other_untax_income,
1082 x_tax_stu_aid,
1083 x_cash_sav_check,
1084 x_ira_keogh,
1085 x_invest_value,
1086 x_invest_debt,
1087 x_home_value,
1088 x_home_debt,
1089 x_oth_real_value,
1090 x_oth_real_debt,
1091 x_bus_farm_value,
1092 x_bus_farm_debt,
1093 x_live_on_farm,
1094 x_home_purch_price,
1095 x_hope_ll_credit,
1096 x_home_purch_year,
1097 x_trust_amount,
1098 x_trust_avail,
1099 x_trust_estab,
1100 x_child_support_paid,
1101 x_med_dent_expenses,
1102 x_vet_us,
1103 x_vet_ben_amount,
1104 x_vet_ben_months,
1105 x_stu_summer_wages,
1106 x_stu_school_yr_wages,
1107 x_spouse_summer_wages,
1108 x_spouse_school_yr_wages,
1109 x_summer_other_tax_inc,
1110 x_school_yr_other_tax_inc,
1111 x_summer_untax_inc,
1112 x_school_yr_untax_inc,
1113 x_grants_schol_etc,
1114 x_tuit_benefits,
1115 x_cont_parents,
1116 x_cont_relatives,
1117 x_p_siblings_pre_tuit,
1118 x_p_student_pre_tuit,
1119 x_p_household_size,
1120 x_p_number_in_college,
1121 x_p_parents_in_college,
1122 x_p_marital_status,
1123 x_p_state_legal_residence,
1124 x_p_natural_par_status,
1125 x_p_child_supp_paid,
1126 x_p_repay_ed_loans,
1127 x_p_med_dent_expenses,
1131 x_p_exp_repay_ed_loans,
1128 x_p_tuit_paid_amount,
1129 x_p_tuit_paid_number,
1130 x_p_exp_child_supp_paid,
1132 x_p_exp_med_dent_expenses,
1133 x_p_exp_tuit_pd_amount,
1134 x_p_exp_tuit_pd_number,
1135 x_p_cash_sav_check,
1136 x_p_month_mortgage_pay,
1137 x_p_invest_value,
1138 x_p_invest_debt,
1139 x_p_home_value,
1140 x_p_home_debt,
1141 x_p_home_purch_price,
1142 x_p_own_business_farm,
1143 x_p_business_value,
1144 x_p_business_debt,
1145 x_p_farm_value,
1146 x_p_farm_debt,
1147 x_p_live_on_farm,
1148 x_p_oth_real_estate_value,
1149 x_p_oth_real_estate_debt,
1150 x_p_oth_real_purch_price,
1151 x_p_siblings_assets,
1152 x_p_home_purch_year,
1153 x_p_oth_real_purch_year,
1154 x_p_prior_agi,
1155 x_p_prior_us_tax_paid,
1156 x_p_prior_item_deductions,
1157 x_p_prior_other_untax_inc,
1158 x_p_tax_figures,
1159 x_p_number_exemptions,
1160 x_p_adjusted_gross_inc,
1161 x_p_wages_sal_tips,
1162 x_p_interest_income,
1163 x_p_dividend_income,
1164 x_p_net_inc_bus_farm,
1165 x_p_other_taxable_income,
1166 x_p_adj_to_income,
1167 x_p_us_tax_paid,
1168 x_p_itemized_deductions,
1169 x_p_father_income_work,
1170 x_p_mother_income_work,
1171 x_p_soc_sec_ben,
1172 x_p_welfare_tanf,
1173 x_p_child_supp_rcvd,
1174 x_p_ded_ira_keogh,
1175 x_p_tax_defer_pens_savs,
1176 x_p_dep_care_med_spending,
1177 x_p_earned_income_credit,
1178 x_p_living_allow,
1179 x_p_tax_exmpt_int,
1180 x_p_foreign_inc_excl,
1181 x_p_other_untax_inc,
1182 x_p_hope_ll_credit,
1183 x_p_yr_separation,
1184 x_p_yr_divorce,
1185 x_p_exp_father_inc,
1186 x_p_exp_mother_inc,
1187 x_p_exp_other_tax_inc,
1188 x_p_exp_other_untax_inc,
1189 x_line_2_relation,
1190 x_line_2_attend_college,
1191 x_line_3_relation,
1192 x_line_3_attend_college,
1193 x_line_4_relation,
1194 x_line_4_attend_college,
1195 x_line_5_relation,
1196 x_line_5_attend_college,
1197 x_line_6_relation,
1198 x_line_6_attend_college,
1199 x_line_7_relation,
1200 x_line_7_attend_college,
1201 x_line_8_relation,
1202 x_line_8_attend_college,
1203 x_p_age_father,
1204 x_p_age_mother,
1205 x_p_div_sep_ind,
1206 x_b_cont_non_custodial_par,
1207 x_college_type_2,
1208 x_college_type_3,
1209 x_college_type_4,
1210 x_college_type_5,
1211 x_college_type_6,
1212 x_college_type_7,
1213 x_college_type_8,
1214 x_school_code_1,
1215 x_housing_code_1,
1216 x_school_code_2,
1217 x_housing_code_2,
1218 x_school_code_3,
1219 x_housing_code_3,
1220 x_school_code_4,
1221 x_housing_code_4,
1222 x_school_code_5,
1223 x_housing_code_5,
1224 x_school_code_6,
1225 x_housing_code_6,
1226 x_school_code_7,
1227 x_housing_code_7,
1228 x_school_code_8,
1229 x_housing_code_8,
1233 x_housing_code_10,
1230 x_school_code_9,
1231 x_housing_code_9,
1232 x_school_code_10,
1234 x_additional_school_code_1,
1235 x_additional_school_code_2,
1236 x_additional_school_code_3,
1237 x_additional_school_code_4,
1238 x_additional_school_code_5,
1239 x_additional_school_code_6,
1240 x_additional_school_code_7,
1241 x_additional_school_code_8,
1242 x_additional_school_code_9,
1243 x_additional_school_code_10,
1244 x_explanation_spec_circum,
1245 x_signature_student,
1246 x_signature_spouse,
1247 x_signature_father,
1248 x_signature_mother,
1249 x_month_day_completed,
1250 x_year_completed,
1251 x_age_line_2,
1252 x_age_line_3,
1253 x_age_line_4,
1254 x_age_line_5,
1255 x_age_line_6,
1256 x_age_line_7,
1257 x_age_line_8,
1258 x_a_online_signature,
1259 x_question_1_number,
1260 x_question_1_size,
1261 x_question_1_answer,
1262 x_question_2_number,
1263 x_question_2_size,
1264 x_question_2_answer,
1265 x_question_3_number,
1266 x_question_3_size,
1267 x_question_3_answer,
1268 x_question_4_number,
1269 x_question_4_size,
1270 x_question_4_answer,
1271 x_question_5_number,
1272 x_question_5_size,
1273 x_question_5_answer,
1274 x_question_6_number,
1275 x_question_6_size,
1276 x_question_6_answer,
1277 x_question_7_number,
1278 x_question_7_size,
1279 x_question_7_answer,
1280 x_question_8_number,
1281 x_question_8_size,
1282 x_question_8_answer,
1283 x_question_9_number,
1284 x_question_9_size,
1285 x_question_9_answer,
1286 x_question_10_number,
1287 x_question_10_size,
1288 x_question_10_answer,
1289 x_question_11_number,
1290 x_question_11_size,
1291 x_question_11_answer,
1292 x_question_12_number,
1293 x_question_12_size,
1294 x_question_12_answer,
1295 x_question_13_number,
1296 x_question_13_size,
1297 x_question_13_answer,
1298 x_question_14_number,
1299 x_question_14_size,
1300 x_question_14_answer,
1301 x_question_15_number,
1302 x_question_15_size,
1303 x_question_15_answer,
1304 x_question_16_number,
1305 x_question_16_size,
1306 x_question_16_answer,
1307 x_question_17_number,
1308 x_question_17_size,
1309 x_question_17_answer,
1310 x_question_18_number,
1311 x_question_18_size,
1312 x_question_18_answer,
1313 x_question_19_number,
1314 x_question_19_size,
1315 x_question_19_answer,
1316 x_question_20_number,
1317 x_question_20_size,
1318 x_question_20_answer,
1319 x_question_21_number,
1320 x_question_21_size,
1321 x_question_21_answer,
1322 x_question_22_number,
1323 x_question_22_size,
1324 x_question_22_answer,
1325 x_question_23_number,
1326 x_question_23_size,
1327 x_question_23_answer,
1328 x_question_24_number,
1329 x_question_24_size,
1330 x_question_24_answer,
1331 x_question_25_number,
1332 x_question_25_size,
1333 x_question_25_answer,
1334 x_question_26_number,
1335 x_question_26_size,
1336 x_question_26_answer,
1337 x_question_27_number,
1338 x_question_27_size,
1339 x_question_27_answer,
1340 x_question_28_number,
1341 x_question_28_size,
1342 x_question_28_answer,
1343 x_question_29_number,
1344 x_question_29_size,
1345 x_question_29_answer,
1346 x_question_30_number,
1347 x_questions_30_size,
1348 x_question_30_answer,
1349 x_creation_date,
1350 x_created_by,
1351 x_last_update_date,
1352 x_last_updated_by,
1353 x_last_update_login
1354 );
1355
1356 IF (p_action = 'INSERT') THEN
1357 -- Call all the procedures related to Before Insert.
1358 IF ( get_pk_for_validation(
1359 new_references.base_id
1360 )
1361 ) THEN
1362 fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1363 igs_ge_msg_stack.add;
1364 app_exception.raise_exception;
1365 END IF;
1366 ELSIF (p_action = 'VALIDATE_INSERT') THEN
1367 -- Call all the procedures related to Before Insert.
1368 IF ( get_pk_for_validation (
1369 new_references.base_id
1370 )
1371 ) THEN
1372 fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1373 igs_ge_msg_stack.add;
1374 app_exception.raise_exception;
1375 END IF;
1376 END IF;
1377
1378 END before_dml;
1379
1380
1381 PROCEDURE insert_row (
1382 x_rowid IN OUT NOCOPY VARCHAR2,
1383 x_base_id IN OUT NOCOPY NUMBER,
1384 x_last_name IN VARCHAR2,
1385 x_first_name IN VARCHAR2,
1386 x_middle_initial IN VARCHAR2,
1387 x_address_number_and_street IN VARCHAR2,
1388 x_city IN VARCHAR2,
1389 x_state_mailing IN VARCHAR2,
1393 x_date_of_birth IN VARCHAR2,
1390 x_zip_code IN VARCHAR2,
1391 x_s_telephone_number IN VARCHAR2,
1392 x_s_title IN VARCHAR2,
1394 x_social_security_number IN VARCHAR2,
1395 x_state_legal_residence IN VARCHAR2,
1396 x_foreign_address_indicator IN VARCHAR2,
1397 x_foreign_postal_code IN VARCHAR2,
1398 x_country IN VARCHAR2,
1399 x_financial_aid_status IN VARCHAR2,
1400 x_year_in_college IN VARCHAR2,
1401 x_marital_status IN VARCHAR2,
1402 x_ward_court IN VARCHAR2,
1403 x_legal_dependents_other IN VARCHAR2,
1404 x_household_size IN VARCHAR2,
1405 x_number_in_college IN VARCHAR2,
1406 x_citizenship_status IN VARCHAR2,
1407 x_citizenship_country IN VARCHAR2,
1408 x_visa_classification IN VARCHAR2,
1409 x_tax_figures IN VARCHAR2,
1410 x_number_exemptions IN VARCHAR2,
1411 x_adjusted_gross_inc IN VARCHAR2,
1412 x_us_tax_paid IN VARCHAR2,
1413 x_itemized_deductions IN VARCHAR2,
1414 x_stu_income_work IN VARCHAR2,
1415 x_spouse_income_work IN VARCHAR2,
1416 x_divid_int_inc IN VARCHAR2,
1417 x_soc_sec_benefits IN VARCHAR2,
1418 x_welfare_tanf IN VARCHAR2,
1419 x_child_supp_rcvd IN VARCHAR2,
1420 x_earned_income_credit IN VARCHAR2,
1421 x_other_untax_income IN VARCHAR2,
1422 x_tax_stu_aid IN VARCHAR2,
1423 x_cash_sav_check IN VARCHAR2,
1424 x_ira_keogh IN VARCHAR2,
1425 x_invest_value IN VARCHAR2,
1426 x_invest_debt IN VARCHAR2,
1427 x_home_value IN VARCHAR2,
1428 x_home_debt IN VARCHAR2,
1429 x_oth_real_value IN VARCHAR2,
1430 x_oth_real_debt IN VARCHAR2,
1431 x_bus_farm_value IN VARCHAR2,
1432 x_bus_farm_debt IN VARCHAR2,
1433 x_live_on_farm IN VARCHAR2,
1434 x_home_purch_price IN VARCHAR2,
1435 x_hope_ll_credit IN VARCHAR2,
1436 x_home_purch_year IN VARCHAR2,
1437 x_trust_amount IN VARCHAR2,
1438 x_trust_avail IN VARCHAR2,
1439 x_trust_estab IN VARCHAR2,
1440 x_child_support_paid IN VARCHAR2,
1441 x_med_dent_expenses IN VARCHAR2,
1442 x_vet_us IN VARCHAR2,
1443 x_vet_ben_amount IN VARCHAR2,
1444 x_vet_ben_months IN VARCHAR2,
1445 x_stu_summer_wages IN VARCHAR2,
1446 x_stu_school_yr_wages IN VARCHAR2,
1447 x_spouse_summer_wages IN VARCHAR2,
1448 x_spouse_school_yr_wages IN VARCHAR2,
1449 x_summer_other_tax_inc IN VARCHAR2,
1450 x_school_yr_other_tax_inc IN VARCHAR2,
1451 x_summer_untax_inc IN VARCHAR2,
1452 x_school_yr_untax_inc IN VARCHAR2,
1453 x_grants_schol_etc IN VARCHAR2,
1454 x_tuit_benefits IN VARCHAR2,
1455 x_cont_parents IN VARCHAR2,
1456 x_cont_relatives IN VARCHAR2,
1457 x_p_siblings_pre_tuit IN VARCHAR2,
1458 x_p_student_pre_tuit IN VARCHAR2,
1459 x_p_household_size IN VARCHAR2,
1460 x_p_number_in_college IN VARCHAR2,
1461 x_p_parents_in_college IN VARCHAR2,
1462 x_p_marital_status IN VARCHAR2,
1463 x_p_state_legal_residence IN VARCHAR2,
1464 x_p_natural_par_status IN VARCHAR2,
1465 x_p_child_supp_paid IN VARCHAR2,
1466 x_p_repay_ed_loans IN VARCHAR2,
1467 x_p_med_dent_expenses IN VARCHAR2,
1468 x_p_tuit_paid_amount IN VARCHAR2,
1469 x_p_tuit_paid_number IN VARCHAR2,
1470 x_p_exp_child_supp_paid IN VARCHAR2,
1471 x_p_exp_repay_ed_loans IN VARCHAR2,
1472 x_p_exp_med_dent_expenses IN VARCHAR2,
1473 x_p_exp_tuit_pd_amount IN VARCHAR2,
1474 x_p_exp_tuit_pd_number IN VARCHAR2,
1475 x_p_cash_sav_check IN VARCHAR2,
1476 x_p_month_mortgage_pay IN VARCHAR2,
1477 x_p_invest_value IN VARCHAR2,
1478 x_p_invest_debt IN VARCHAR2,
1479 x_p_home_value IN VARCHAR2,
1480 x_p_home_debt IN VARCHAR2,
1481 x_p_home_purch_price IN VARCHAR2,
1482 x_p_own_business_farm IN VARCHAR2,
1483 x_p_business_value IN VARCHAR2,
1484 x_p_business_debt IN VARCHAR2,
1485 x_p_farm_value IN VARCHAR2,
1486 x_p_farm_debt IN VARCHAR2,
1487 x_p_live_on_farm IN VARCHAR2,
1491 x_p_siblings_assets IN VARCHAR2,
1488 x_p_oth_real_estate_value IN VARCHAR2,
1489 x_p_oth_real_estate_debt IN VARCHAR2,
1490 x_p_oth_real_purch_price IN VARCHAR2,
1492 x_p_home_purch_year IN VARCHAR2,
1493 x_p_oth_real_purch_year IN VARCHAR2,
1494 x_p_prior_agi IN VARCHAR2,
1495 x_p_prior_us_tax_paid IN VARCHAR2,
1496 x_p_prior_item_deductions IN VARCHAR2,
1497 x_p_prior_other_untax_inc IN VARCHAR2,
1498 x_p_tax_figures IN VARCHAR2,
1499 x_p_number_exemptions IN VARCHAR2,
1500 x_p_adjusted_gross_inc IN VARCHAR2,
1501 x_p_wages_sal_tips IN VARCHAR2,
1502 x_p_interest_income IN VARCHAR2,
1503 x_p_dividend_income IN VARCHAR2,
1504 x_p_net_inc_bus_farm IN VARCHAR2,
1505 x_p_other_taxable_income IN VARCHAR2,
1506 x_p_adj_to_income IN VARCHAR2,
1507 x_p_us_tax_paid IN VARCHAR2,
1508 x_p_itemized_deductions IN VARCHAR2,
1509 x_p_father_income_work IN VARCHAR2,
1510 x_p_mother_income_work IN VARCHAR2,
1511 x_p_soc_sec_ben IN VARCHAR2,
1512 x_p_welfare_tanf IN VARCHAR2,
1513 x_p_child_supp_rcvd IN VARCHAR2,
1514 x_p_ded_ira_keogh IN VARCHAR2,
1515 x_p_tax_defer_pens_savs IN VARCHAR2,
1516 x_p_dep_care_med_spending IN VARCHAR2,
1517 x_p_earned_income_credit IN VARCHAR2,
1518 x_p_living_allow IN VARCHAR2,
1519 x_p_tax_exmpt_int IN VARCHAR2,
1520 x_p_foreign_inc_excl IN VARCHAR2,
1521 x_p_other_untax_inc IN VARCHAR2,
1522 x_p_hope_ll_credit IN VARCHAR2,
1523 x_p_yr_separation IN VARCHAR2,
1524 x_p_yr_divorce IN VARCHAR2,
1525 x_p_exp_father_inc IN VARCHAR2,
1526 x_p_exp_mother_inc IN VARCHAR2,
1527 x_p_exp_other_tax_inc IN VARCHAR2,
1528 x_p_exp_other_untax_inc IN VARCHAR2,
1529 x_line_2_relation IN VARCHAR2,
1530 x_line_2_attend_college IN VARCHAR2,
1531 x_line_3_relation IN VARCHAR2,
1532 x_line_3_attend_college IN VARCHAR2,
1533 x_line_4_relation IN VARCHAR2,
1534 x_line_4_attend_college IN VARCHAR2,
1535 x_line_5_relation IN VARCHAR2,
1536 x_line_5_attend_college IN VARCHAR2,
1537 x_line_6_relation IN VARCHAR2,
1538 x_line_6_attend_college IN VARCHAR2,
1539 x_line_7_relation IN VARCHAR2,
1540 x_line_7_attend_college IN VARCHAR2,
1541 x_line_8_relation IN VARCHAR2,
1542 x_line_8_attend_college IN VARCHAR2,
1543 x_p_age_father IN VARCHAR2,
1544 x_p_age_mother IN VARCHAR2,
1545 x_p_div_sep_ind IN VARCHAR2,
1546 x_b_cont_non_custodial_par IN VARCHAR2,
1547 x_college_type_2 IN VARCHAR2,
1548 x_college_type_3 IN VARCHAR2,
1549 x_college_type_4 IN VARCHAR2,
1550 x_college_type_5 IN VARCHAR2,
1551 x_college_type_6 IN VARCHAR2,
1552 x_college_type_7 IN VARCHAR2,
1553 x_college_type_8 IN VARCHAR2,
1554 x_school_code_1 IN VARCHAR2,
1555 x_housing_code_1 IN VARCHAR2,
1556 x_school_code_2 IN VARCHAR2,
1557 x_housing_code_2 IN VARCHAR2,
1558 x_school_code_3 IN VARCHAR2,
1559 x_housing_code_3 IN VARCHAR2,
1560 x_school_code_4 IN VARCHAR2,
1561 x_housing_code_4 IN VARCHAR2,
1562 x_school_code_5 IN VARCHAR2,
1563 x_housing_code_5 IN VARCHAR2,
1564 x_school_code_6 IN VARCHAR2,
1565 x_housing_code_6 IN VARCHAR2,
1566 x_school_code_7 IN VARCHAR2,
1567 x_housing_code_7 IN VARCHAR2,
1568 x_school_code_8 IN VARCHAR2,
1569 x_housing_code_8 IN VARCHAR2,
1570 x_school_code_9 IN VARCHAR2,
1571 x_housing_code_9 IN VARCHAR2,
1572 x_school_code_10 IN VARCHAR2,
1573 x_housing_code_10 IN VARCHAR2,
1574 x_additional_school_code_1 IN VARCHAR2,
1575 x_additional_school_code_2 IN VARCHAR2,
1576 x_additional_school_code_3 IN VARCHAR2,
1577 x_additional_school_code_4 IN VARCHAR2,
1578 x_additional_school_code_5 IN VARCHAR2,
1579 x_additional_school_code_6 IN VARCHAR2,
1580 x_additional_school_code_7 IN VARCHAR2,
1581 x_additional_school_code_8 IN VARCHAR2,
1582 x_additional_school_code_9 IN VARCHAR2,
1583 x_additional_school_code_10 IN VARCHAR2,
1584 x_explanation_spec_circum IN VARCHAR2,
1585 x_signature_student IN VARCHAR2,
1589 x_month_day_completed IN VARCHAR2,
1586 x_signature_spouse IN VARCHAR2,
1587 x_signature_father IN VARCHAR2,
1588 x_signature_mother IN VARCHAR2,
1590 x_year_completed IN VARCHAR2,
1591 x_age_line_2 IN VARCHAR2,
1592 x_age_line_3 IN VARCHAR2,
1593 x_age_line_4 IN VARCHAR2,
1594 x_age_line_5 IN VARCHAR2,
1595 x_age_line_6 IN VARCHAR2,
1596 x_age_line_7 IN VARCHAR2,
1597 x_age_line_8 IN VARCHAR2,
1598 x_a_online_signature IN VARCHAR2,
1599 x_question_1_number IN VARCHAR2,
1600 x_question_1_size IN VARCHAR2,
1601 x_question_1_answer IN VARCHAR2,
1602 x_question_2_number IN VARCHAR2,
1603 x_question_2_size IN VARCHAR2,
1604 x_question_2_answer IN VARCHAR2,
1605 x_question_3_number IN VARCHAR2,
1606 x_question_3_size IN VARCHAR2,
1607 x_question_3_answer IN VARCHAR2,
1608 x_question_4_number IN VARCHAR2,
1609 x_question_4_size IN VARCHAR2,
1610 x_question_4_answer IN VARCHAR2,
1611 x_question_5_number IN VARCHAR2,
1612 x_question_5_size IN VARCHAR2,
1613 x_question_5_answer IN VARCHAR2,
1614 x_question_6_number IN VARCHAR2,
1615 x_question_6_size IN VARCHAR2,
1616 x_question_6_answer IN VARCHAR2,
1617 x_question_7_number IN VARCHAR2,
1618 x_question_7_size IN VARCHAR2,
1619 x_question_7_answer IN VARCHAR2,
1620 x_question_8_number IN VARCHAR2,
1621 x_question_8_size IN VARCHAR2,
1622 x_question_8_answer IN VARCHAR2,
1623 x_question_9_number IN VARCHAR2,
1624 x_question_9_size IN VARCHAR2,
1625 x_question_9_answer IN VARCHAR2,
1626 x_question_10_number IN VARCHAR2,
1627 x_question_10_size IN VARCHAR2,
1628 x_question_10_answer IN VARCHAR2,
1629 x_question_11_number IN VARCHAR2,
1630 x_question_11_size IN VARCHAR2,
1631 x_question_11_answer IN VARCHAR2,
1632 x_question_12_number IN VARCHAR2,
1633 x_question_12_size IN VARCHAR2,
1634 x_question_12_answer IN VARCHAR2,
1635 x_question_13_number IN VARCHAR2,
1636 x_question_13_size IN VARCHAR2,
1637 x_question_13_answer IN VARCHAR2,
1638 x_question_14_number IN VARCHAR2,
1639 x_question_14_size IN VARCHAR2,
1640 x_question_14_answer IN VARCHAR2,
1641 x_question_15_number IN VARCHAR2,
1642 x_question_15_size IN VARCHAR2,
1643 x_question_15_answer IN VARCHAR2,
1644 x_question_16_number IN VARCHAR2,
1645 x_question_16_size IN VARCHAR2,
1646 x_question_16_answer IN VARCHAR2,
1647 x_question_17_number IN VARCHAR2,
1648 x_question_17_size IN VARCHAR2,
1649 x_question_17_answer IN VARCHAR2,
1650 x_question_18_number IN VARCHAR2,
1651 x_question_18_size IN VARCHAR2,
1652 x_question_18_answer IN VARCHAR2,
1653 x_question_19_number IN VARCHAR2,
1654 x_question_19_size IN VARCHAR2,
1655 x_question_19_answer IN VARCHAR2,
1656 x_question_20_number IN VARCHAR2,
1657 x_question_20_size IN VARCHAR2,
1658 x_question_20_answer IN VARCHAR2,
1659 x_question_21_number IN VARCHAR2,
1660 x_question_21_size IN VARCHAR2,
1661 x_question_21_answer IN VARCHAR2,
1662 x_question_22_number IN VARCHAR2,
1663 x_question_22_size IN VARCHAR2,
1664 x_question_22_answer IN VARCHAR2,
1665 x_question_23_number IN VARCHAR2,
1666 x_question_23_size IN VARCHAR2,
1667 x_question_23_answer IN VARCHAR2,
1668 x_question_24_number IN VARCHAR2,
1669 x_question_24_size IN VARCHAR2,
1670 x_question_24_answer IN VARCHAR2,
1671 x_question_25_number IN VARCHAR2,
1672 x_question_25_size IN VARCHAR2,
1673 x_question_25_answer IN VARCHAR2,
1674 x_question_26_number IN VARCHAR2,
1675 x_question_26_size IN VARCHAR2,
1676 x_question_26_answer IN VARCHAR2,
1677 x_question_27_number IN VARCHAR2,
1678 x_question_27_size IN VARCHAR2,
1679 x_question_27_answer IN VARCHAR2,
1680 x_question_28_number IN VARCHAR2,
1681 x_question_28_size IN VARCHAR2,
1682 x_question_28_answer IN VARCHAR2,
1686 x_question_30_number IN VARCHAR2,
1683 x_question_29_number IN VARCHAR2,
1684 x_question_29_size IN VARCHAR2,
1685 x_question_29_answer IN VARCHAR2,
1687 x_questions_30_size IN VARCHAR2,
1688 x_question_30_answer IN VARCHAR2,
1689 x_mode IN VARCHAR2 DEFAULT 'R'
1690 ) AS
1691 /*
1692 || Created By : kkillams
1693 || Created On : 30-MAY-2001
1694 || Purpose : Handles the INSERT DML logic for the table.
1695 || Known limitations, enhancements or remarks :
1696 || Change History :
1697 || Who When What
1698 || (reverse chronological order - newest change first)
1699 */
1700 CURSOR c IS
1701 SELECT rowid
1702 FROM igf_ap_cs_upd_flags
1703 WHERE base_id = x_base_id;
1704
1705 x_last_update_date DATE;
1706 x_last_updated_by NUMBER;
1707 x_last_update_login NUMBER;
1708
1709 BEGIN
1710
1711 x_last_update_date := SYSDATE;
1712 IF (x_mode = 'I') THEN
1713 x_last_updated_by := 1;
1714 x_last_update_login := 0;
1715 ELSIF (x_mode = 'R') THEN
1716 x_last_updated_by := fnd_global.user_id;
1717 IF (x_last_updated_by IS NULL) THEN
1718 x_last_updated_by := -1;
1719 END IF;
1720 x_last_update_login := fnd_global.login_id;
1721 IF (x_last_update_login IS NULL) THEN
1722 x_last_update_login := -1;
1723 END IF;
1724 ELSE
1725 fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1726 igs_ge_msg_stack.add;
1727 app_exception.raise_exception;
1728 END IF;
1729
1730 before_dml(
1731 p_action => 'INSERT',
1732 x_rowid => x_rowid,
1733 x_base_id => x_base_id,
1734 x_last_name => x_last_name,
1735 x_first_name => x_first_name,
1736 x_middle_initial => x_middle_initial,
1737 x_address_number_and_street => x_address_number_and_street,
1738 x_city => x_city,
1739 x_state_mailing => x_state_mailing,
1740 x_zip_code => x_zip_code,
1741 x_s_telephone_number => x_s_telephone_number,
1742 x_s_title => x_s_title,
1743 x_date_of_birth => x_date_of_birth,
1744 x_social_security_number => x_social_security_number,
1745 x_state_legal_residence => x_state_legal_residence,
1746 x_foreign_address_indicator => x_foreign_address_indicator,
1747 x_foreign_postal_code => x_foreign_postal_code,
1748 x_country => x_country,
1749 x_financial_aid_status => x_financial_aid_status,
1750 x_year_in_college => x_year_in_college,
1751 x_marital_status => x_marital_status,
1752 x_ward_court => x_ward_court,
1753 x_legal_dependents_other => x_legal_dependents_other,
1754 x_household_size => x_household_size,
1755 x_number_in_college => x_number_in_college,
1756 x_citizenship_status => x_citizenship_status,
1757 x_citizenship_country => x_citizenship_country,
1758 x_visa_classification => x_visa_classification,
1759 x_tax_figures => x_tax_figures,
1760 x_number_exemptions => x_number_exemptions,
1761 x_adjusted_gross_inc => x_adjusted_gross_inc,
1762 x_us_tax_paid => x_us_tax_paid,
1763 x_itemized_deductions => x_itemized_deductions,
1764 x_stu_income_work => x_stu_income_work,
1765 x_spouse_income_work => x_spouse_income_work,
1766 x_divid_int_inc => x_divid_int_inc,
1767 x_soc_sec_benefits => x_soc_sec_benefits,
1768 x_welfare_tanf => x_welfare_tanf,
1769 x_child_supp_rcvd => x_child_supp_rcvd,
1770 x_earned_income_credit => x_earned_income_credit,
1771 x_other_untax_income => x_other_untax_income,
1772 x_tax_stu_aid => x_tax_stu_aid,
1773 x_cash_sav_check => x_cash_sav_check,
1774 x_ira_keogh => x_ira_keogh,
1775 x_invest_value => x_invest_value,
1776 x_invest_debt => x_invest_debt,
1777 x_home_value => x_home_value,
1778 x_home_debt => x_home_debt,
1779 x_oth_real_value => x_oth_real_value,
1780 x_oth_real_debt => x_oth_real_debt,
1781 x_bus_farm_value => x_bus_farm_value,
1782 x_bus_farm_debt => x_bus_farm_debt,
1786 x_home_purch_year => x_home_purch_year,
1783 x_live_on_farm => x_live_on_farm,
1784 x_home_purch_price => x_home_purch_price,
1785 x_hope_ll_credit => x_hope_ll_credit,
1787 x_trust_amount => x_trust_amount,
1788 x_trust_avail => x_trust_avail,
1789 x_trust_estab => x_trust_estab,
1790 x_child_support_paid => x_child_support_paid,
1791 x_med_dent_expenses => x_med_dent_expenses,
1792 x_vet_us => x_vet_us,
1793 x_vet_ben_amount => x_vet_ben_amount,
1794 x_vet_ben_months => x_vet_ben_months,
1795 x_stu_summer_wages => x_stu_summer_wages,
1796 x_stu_school_yr_wages => x_stu_school_yr_wages,
1797 x_spouse_summer_wages => x_spouse_summer_wages,
1798 x_spouse_school_yr_wages => x_spouse_school_yr_wages,
1799 x_summer_other_tax_inc => x_summer_other_tax_inc,
1800 x_school_yr_other_tax_inc => x_school_yr_other_tax_inc,
1801 x_summer_untax_inc => x_summer_untax_inc,
1802 x_school_yr_untax_inc => x_school_yr_untax_inc,
1803 x_grants_schol_etc => x_grants_schol_etc,
1804 x_tuit_benefits => x_tuit_benefits,
1805 x_cont_parents => x_cont_parents,
1806 x_cont_relatives => x_cont_relatives,
1807 x_p_siblings_pre_tuit => x_p_siblings_pre_tuit,
1808 x_p_student_pre_tuit => x_p_student_pre_tuit,
1809 x_p_household_size => x_p_household_size,
1810 x_p_number_in_college => x_p_number_in_college,
1811 x_p_parents_in_college => x_p_parents_in_college,
1812 x_p_marital_status => x_p_marital_status,
1813 x_p_state_legal_residence => x_p_state_legal_residence,
1814 x_p_natural_par_status => x_p_natural_par_status,
1815 x_p_child_supp_paid => x_p_child_supp_paid,
1816 x_p_repay_ed_loans => x_p_repay_ed_loans,
1817 x_p_med_dent_expenses => x_p_med_dent_expenses,
1818 x_p_tuit_paid_amount => x_p_tuit_paid_amount,
1819 x_p_tuit_paid_number => x_p_tuit_paid_number,
1820 x_p_exp_child_supp_paid => x_p_exp_child_supp_paid,
1821 x_p_exp_repay_ed_loans => x_p_exp_repay_ed_loans,
1822 x_p_exp_med_dent_expenses => x_p_exp_med_dent_expenses,
1823 x_p_exp_tuit_pd_amount => x_p_exp_tuit_pd_amount,
1824 x_p_exp_tuit_pd_number => x_p_exp_tuit_pd_number,
1825 x_p_cash_sav_check => x_p_cash_sav_check,
1826 x_p_month_mortgage_pay => x_p_month_mortgage_pay,
1827 x_p_invest_value => x_p_invest_value,
1828 x_p_invest_debt => x_p_invest_debt,
1829 x_p_home_value => x_p_home_value,
1830 x_p_home_debt => x_p_home_debt,
1831 x_p_home_purch_price => x_p_home_purch_price,
1832 x_p_own_business_farm => x_p_own_business_farm,
1833 x_p_business_value => x_p_business_value,
1834 x_p_business_debt => x_p_business_debt,
1835 x_p_farm_value => x_p_farm_value,
1836 x_p_farm_debt => x_p_farm_debt,
1837 x_p_live_on_farm => x_p_live_on_farm,
1841 x_p_siblings_assets => x_p_siblings_assets,
1838 x_p_oth_real_estate_value => x_p_oth_real_estate_value,
1839 x_p_oth_real_estate_debt => x_p_oth_real_estate_debt,
1840 x_p_oth_real_purch_price => x_p_oth_real_purch_price,
1842 x_p_home_purch_year => x_p_home_purch_year,
1843 x_p_oth_real_purch_year => x_p_oth_real_purch_year,
1844 x_p_prior_agi => x_p_prior_agi,
1845 x_p_prior_us_tax_paid => x_p_prior_us_tax_paid,
1846 x_p_prior_item_deductions => x_p_prior_item_deductions,
1847 x_p_prior_other_untax_inc => x_p_prior_other_untax_inc,
1848 x_p_tax_figures => x_p_tax_figures,
1849 x_p_number_exemptions => x_p_number_exemptions,
1850 x_p_adjusted_gross_inc => x_p_adjusted_gross_inc,
1851 x_p_wages_sal_tips => x_p_wages_sal_tips,
1852 x_p_interest_income => x_p_interest_income,
1853 x_p_dividend_income => x_p_dividend_income,
1854 x_p_net_inc_bus_farm => x_p_net_inc_bus_farm,
1855 x_p_other_taxable_income => x_p_other_taxable_income,
1856 x_p_adj_to_income => x_p_adj_to_income,
1857 x_p_us_tax_paid => x_p_us_tax_paid,
1858 x_p_itemized_deductions => x_p_itemized_deductions,
1859 x_p_father_income_work => x_p_father_income_work,
1860 x_p_mother_income_work => x_p_mother_income_work,
1861 x_p_soc_sec_ben => x_p_soc_sec_ben,
1862 x_p_welfare_tanf => x_p_welfare_tanf,
1863 x_p_child_supp_rcvd => x_p_child_supp_rcvd,
1864 x_p_ded_ira_keogh => x_p_ded_ira_keogh,
1865 x_p_tax_defer_pens_savs => x_p_tax_defer_pens_savs,
1866 x_p_dep_care_med_spending => x_p_dep_care_med_spending,
1867 x_p_earned_income_credit => x_p_earned_income_credit,
1868 x_p_living_allow => x_p_living_allow,
1869 x_p_tax_exmpt_int => x_p_tax_exmpt_int,
1870 x_p_foreign_inc_excl => x_p_foreign_inc_excl,
1871 x_p_other_untax_inc => x_p_other_untax_inc,
1872 x_p_hope_ll_credit => x_p_hope_ll_credit,
1873 x_p_yr_separation => x_p_yr_separation,
1874 x_p_yr_divorce => x_p_yr_divorce,
1875 x_p_exp_father_inc => x_p_exp_father_inc,
1876 x_p_exp_mother_inc => x_p_exp_mother_inc,
1877 x_p_exp_other_tax_inc => x_p_exp_other_tax_inc,
1878 x_p_exp_other_untax_inc => x_p_exp_other_untax_inc,
1879 x_line_2_relation => x_line_2_relation,
1880 x_line_2_attend_college => x_line_2_attend_college,
1881 x_line_3_relation => x_line_3_relation,
1882 x_line_3_attend_college => x_line_3_attend_college,
1883 x_line_4_relation => x_line_4_relation,
1884 x_line_4_attend_college => x_line_4_attend_college,
1885 x_line_5_relation => x_line_5_relation,
1886 x_line_5_attend_college => x_line_5_attend_college,
1887 x_line_6_relation => x_line_6_relation,
1888 x_line_6_attend_college => x_line_6_attend_college,
1889 x_line_7_relation => x_line_7_relation,
1890 x_line_7_attend_college => x_line_7_attend_college,
1891 x_line_8_relation => x_line_8_relation,
1892 x_line_8_attend_college => x_line_8_attend_college,
1893 x_p_age_father => x_p_age_father,
1894 x_p_age_mother => x_p_age_mother,
1895 x_p_div_sep_ind => x_p_div_sep_ind,
1896 x_b_cont_non_custodial_par => x_b_cont_non_custodial_par,
1897 x_college_type_2 => x_college_type_2,
1898 x_college_type_3 => x_college_type_3,
1899 x_college_type_4 => x_college_type_4,
1900 x_college_type_5 => x_college_type_5,
1901 x_college_type_6 => x_college_type_6,
1902 x_college_type_7 => x_college_type_7,
1903 x_college_type_8 => x_college_type_8,
1904 x_school_code_1 => x_school_code_1,
1905 x_housing_code_1 => x_housing_code_1,
1906 x_school_code_2 => x_school_code_2,
1907 x_housing_code_2 => x_housing_code_2,
1908 x_school_code_3 => x_school_code_3,
1909 x_housing_code_3 => x_housing_code_3,
1910 x_school_code_4 => x_school_code_4,
1911 x_housing_code_4 => x_housing_code_4,
1912 x_school_code_5 => x_school_code_5,
1913 x_housing_code_5 => x_housing_code_5,
1914 x_school_code_6 => x_school_code_6,
1915 x_housing_code_6 => x_housing_code_6,
1916 x_school_code_7 => x_school_code_7,
1917 x_housing_code_7 => x_housing_code_7,
1918 x_school_code_8 => x_school_code_8,
1919 x_housing_code_8 => x_housing_code_8,
1920 x_school_code_9 => x_school_code_9,
1921 x_housing_code_9 => x_housing_code_9,
1922 x_school_code_10 => x_school_code_10,
1926 x_additional_school_code_3 => x_additional_school_code_3,
1923 x_housing_code_10 => x_housing_code_10,
1924 x_additional_school_code_1 => x_additional_school_code_1,
1925 x_additional_school_code_2 => x_additional_school_code_2,
1927 x_additional_school_code_4 => x_additional_school_code_4,
1928 x_additional_school_code_5 => x_additional_school_code_5,
1929 x_additional_school_code_6 => x_additional_school_code_6,
1930 x_additional_school_code_7 => x_additional_school_code_7,
1931 x_additional_school_code_8 => x_additional_school_code_8,
1932 x_additional_school_code_9 => x_additional_school_code_9,
1933 x_additional_school_code_10 => x_additional_school_code_10,
1934 x_explanation_spec_circum => x_explanation_spec_circum,
1935 x_signature_student => x_signature_student,
1936 x_signature_spouse => x_signature_spouse,
1937 x_signature_father => x_signature_father,
1938 x_signature_mother => x_signature_mother,
1939 x_month_day_completed => x_month_day_completed,
1940 x_year_completed => x_year_completed,
1941 x_age_line_2 => x_age_line_2,
1942 x_age_line_3 => x_age_line_3,
1943 x_age_line_4 => x_age_line_4,
1944 x_age_line_5 => x_age_line_5,
1945 x_age_line_6 => x_age_line_6,
1946 x_age_line_7 => x_age_line_7,
1947 x_age_line_8 => x_age_line_8,
1948 x_a_online_signature => x_a_online_signature,
1949 x_question_1_number => x_question_1_number,
1950 x_question_1_size => x_question_1_size,
1951 x_question_1_answer => x_question_1_answer,
1952 x_question_2_number => x_question_2_number,
1953 x_question_2_size => x_question_2_size,
1954 x_question_2_answer => x_question_2_answer,
1955 x_question_3_number => x_question_3_number,
1956 x_question_3_size => x_question_3_size,
1957 x_question_3_answer => x_question_3_answer,
1958 x_question_4_number => x_question_4_number,
1959 x_question_4_size => x_question_4_size,
1960 x_question_4_answer => x_question_4_answer,
1961 x_question_5_number => x_question_5_number,
1962 x_question_5_size => x_question_5_size,
1963 x_question_5_answer => x_question_5_answer,
1964 x_question_6_number => x_question_6_number,
1965 x_question_6_size => x_question_6_size,
1966 x_question_6_answer => x_question_6_answer,
1967 x_question_7_number => x_question_7_number,
1968 x_question_7_size => x_question_7_size,
1969 x_question_7_answer => x_question_7_answer,
1970 x_question_8_number => x_question_8_number,
1971 x_question_8_size => x_question_8_size,
1972 x_question_8_answer => x_question_8_answer,
1973 x_question_9_number => x_question_9_number,
1974 x_question_9_size => x_question_9_size,
1975 x_question_9_answer => x_question_9_answer,
1976 x_question_10_number => x_question_10_number,
1977 x_question_10_size => x_question_10_size,
1978 x_question_10_answer => x_question_10_answer,
1979 x_question_11_number => x_question_11_number,
1980 x_question_11_size => x_question_11_size,
1981 x_question_11_answer => x_question_11_answer,
1982 x_question_12_number => x_question_12_number,
1986 x_question_13_size => x_question_13_size,
1983 x_question_12_size => x_question_12_size,
1984 x_question_12_answer => x_question_12_answer,
1985 x_question_13_number => x_question_13_number,
1987 x_question_13_answer => x_question_13_answer,
1988 x_question_14_number => x_question_14_number,
1989 x_question_14_size => x_question_14_size,
1990 x_question_14_answer => x_question_14_answer,
1991 x_question_15_number => x_question_15_number,
1992 x_question_15_size => x_question_15_size,
1993 x_question_15_answer => x_question_15_answer,
1994 x_question_16_number => x_question_16_number,
1995 x_question_16_size => x_question_16_size,
1996 x_question_16_answer => x_question_16_answer,
1997 x_question_17_number => x_question_17_number,
1998 x_question_17_size => x_question_17_size,
1999 x_question_17_answer => x_question_17_answer,
2000 x_question_18_number => x_question_18_number,
2001 x_question_18_size => x_question_18_size,
2002 x_question_18_answer => x_question_18_answer,
2003 x_question_19_number => x_question_19_number,
2004 x_question_19_size => x_question_19_size,
2005 x_question_19_answer => x_question_19_answer,
2006 x_question_20_number => x_question_20_number,
2007 x_question_20_size => x_question_20_size,
2008 x_question_20_answer => x_question_20_answer,
2009 x_question_21_number => x_question_21_number,
2010 x_question_21_size => x_question_21_size,
2011 x_question_21_answer => x_question_21_answer,
2012 x_question_22_number => x_question_22_number,
2013 x_question_22_size => x_question_22_size,
2014 x_question_22_answer => x_question_22_answer,
2015 x_question_23_number => x_question_23_number,
2016 x_question_23_size => x_question_23_size,
2017 x_question_23_answer => x_question_23_answer,
2018 x_question_24_number => x_question_24_number,
2019 x_question_24_size => x_question_24_size,
2020 x_question_24_answer => x_question_24_answer,
2021 x_question_25_number => x_question_25_number,
2022 x_question_25_size => x_question_25_size,
2023 x_question_25_answer => x_question_25_answer,
2024 x_question_26_number => x_question_26_number,
2025 x_question_26_size => x_question_26_size,
2026 x_question_26_answer => x_question_26_answer,
2027 x_question_27_number => x_question_27_number,
2028 x_question_27_size => x_question_27_size,
2029 x_question_27_answer => x_question_27_answer,
2030 x_question_28_number => x_question_28_number,
2031 x_question_28_size => x_question_28_size,
2032 x_question_28_answer => x_question_28_answer,
2033 x_question_29_number => x_question_29_number,
2034 x_question_29_size => x_question_29_size,
2035 x_question_29_answer => x_question_29_answer,
2036 x_question_30_number => x_question_30_number,
2037 x_questions_30_size => x_questions_30_size,
2038 x_question_30_answer => x_question_30_answer,
2039 x_creation_date => x_last_update_date,
2040 x_created_by => x_last_updated_by,
2041 x_last_update_date => x_last_update_date,
2042 x_last_updated_by => x_last_updated_by,
2043 x_last_update_login => x_last_update_login
2044 );
2045
2046 INSERT INTO igf_ap_cs_upd_flags (
2047 base_id,
2048 last_name,
2049 first_name,
2050 middle_initial,
2051 address_number_and_street,
2052 city,
2053 state_mailing,
2054 zip_code,
2055 s_telephone_number,
2056 s_title,
2057 date_of_birth,
2058 social_security_number,
2059 state_legal_residence,
2060 foreign_address_indicator,
2061 foreign_postal_code,
2062 country,
2063 financial_aid_status,
2064 year_in_college,
2065 marital_status,
2066 ward_court,
2067 legal_dependents_other,
2068 household_size,
2069 number_in_college,
2070 citizenship_status,
2071 citizenship_country,
2072 visa_classification,
2073 tax_figures,
2074 number_exemptions,
2075 adjusted_gross_inc,
2076 us_tax_paid,
2077 itemized_deductions,
2078 stu_income_work,
2079 spouse_income_work,
2080 divid_int_inc,
2081 soc_sec_benefits,
2082 welfare_tanf,
2083 child_supp_rcvd,
2084 earned_income_credit,
2085 other_untax_income,
2086 tax_stu_aid,
2087 cash_sav_check,
2088 ira_keogh,
2089 invest_value,
2090 invest_debt,
2091 home_value,
2092 home_debt,
2093 oth_real_value,
2094 oth_real_debt,
2095 bus_farm_value,
2099 hope_ll_credit,
2096 bus_farm_debt,
2097 live_on_farm,
2098 home_purch_price,
2100 home_purch_year,
2101 trust_amount,
2102 trust_avail,
2103 trust_estab,
2104 child_support_paid,
2105 med_dent_expenses,
2106 vet_us,
2107 vet_ben_amount,
2108 vet_ben_months,
2109 stu_summer_wages,
2110 stu_school_yr_wages,
2111 spouse_summer_wages,
2112 spouse_school_yr_wages,
2113 summer_other_tax_inc,
2114 school_yr_other_tax_inc,
2115 summer_untax_inc,
2116 school_yr_untax_inc,
2117 grants_schol_etc,
2118 tuit_benefits,
2119 cont_parents,
2120 cont_relatives,
2121 p_siblings_pre_tuit,
2122 p_student_pre_tuit,
2123 p_household_size,
2124 p_number_in_college,
2125 p_parents_in_college,
2126 p_marital_status,
2127 p_state_legal_residence,
2128 p_natural_par_status,
2129 p_child_supp_paid,
2130 p_repay_ed_loans,
2131 p_med_dent_expenses,
2132 p_tuit_paid_amount,
2133 p_tuit_paid_number,
2134 p_exp_child_supp_paid,
2135 p_exp_repay_ed_loans,
2136 p_exp_med_dent_expenses,
2137 p_exp_tuit_pd_amount,
2138 p_exp_tuit_pd_number,
2139 p_cash_sav_check,
2140 p_month_mortgage_pay,
2141 p_invest_value,
2142 p_invest_debt,
2143 p_home_value,
2144 p_home_debt,
2145 p_home_purch_price,
2146 p_own_business_farm,
2147 p_business_value,
2148 p_business_debt,
2149 p_farm_value,
2150 p_farm_debt,
2151 p_live_on_farm,
2152 p_oth_real_estate_value,
2153 p_oth_real_estate_debt,
2154 p_oth_real_purch_price,
2155 p_siblings_assets,
2156 p_home_purch_year,
2157 p_oth_real_purch_year,
2158 p_prior_agi,
2159 p_prior_us_tax_paid,
2160 p_prior_item_deductions,
2161 p_prior_other_untax_inc,
2162 p_tax_figures,
2163 p_number_exemptions,
2164 p_adjusted_gross_inc,
2165 p_wages_sal_tips,
2166 p_interest_income,
2167 p_dividend_income,
2168 p_net_inc_bus_farm,
2169 p_other_taxable_income,
2170 p_adj_to_income,
2171 p_us_tax_paid,
2172 p_itemized_deductions,
2173 p_father_income_work,
2174 p_mother_income_work,
2175 p_soc_sec_ben,
2176 p_welfare_tanf,
2177 p_child_supp_rcvd,
2178 p_ded_ira_keogh,
2179 p_tax_defer_pens_savs,
2180 p_dep_care_med_spending,
2181 p_earned_income_credit,
2182 p_living_allow,
2183 p_tax_exmpt_int,
2184 p_foreign_inc_excl,
2185 p_other_untax_inc,
2186 p_hope_ll_credit,
2187 p_yr_separation,
2188 p_yr_divorce,
2189 p_exp_father_inc,
2190 p_exp_mother_inc,
2191 p_exp_other_tax_inc,
2192 p_exp_other_untax_inc,
2193 line_2_relation,
2194 line_2_attend_college,
2195 line_3_relation,
2196 line_3_attend_college,
2197 line_4_relation,
2198 line_4_attend_college,
2199 line_5_relation,
2200 line_5_attend_college,
2201 line_6_relation,
2202 line_6_attend_college,
2203 line_7_relation,
2204 line_7_attend_college,
2205 line_8_relation,
2206 line_8_attend_college,
2207 p_age_father,
2208 p_age_mother,
2209 p_div_sep_ind,
2210 b_cont_non_custodial_par,
2211 college_type_2,
2212 college_type_3,
2213 college_type_4,
2214 college_type_5,
2215 college_type_6,
2216 college_type_7,
2217 college_type_8,
2218 school_code_1,
2219 housing_code_1,
2220 school_code_2,
2221 housing_code_2,
2222 school_code_3,
2223 housing_code_3,
2224 school_code_4,
2225 housing_code_4,
2226 school_code_5,
2227 housing_code_5,
2228 school_code_6,
2229 housing_code_6,
2230 school_code_7,
2231 housing_code_7,
2232 school_code_8,
2233 housing_code_8,
2234 school_code_9,
2235 housing_code_9,
2236 school_code_10,
2237 housing_code_10,
2238 additional_school_code_1,
2239 additional_school_code_2,
2240 additional_school_code_3,
2241 additional_school_code_4,
2242 additional_school_code_5,
2243 additional_school_code_6,
2244 additional_school_code_7,
2245 additional_school_code_8,
2246 additional_school_code_9,
2247 additional_school_code_10,
2248 explanation_spec_circum,
2249 signature_student,
2250 signature_spouse,
2251 signature_father,
2252 signature_mother,
2253 month_day_completed,
2254 year_completed,
2255 age_line_2,
2256 age_line_3,
2257 age_line_4,
2258 age_line_5,
2259 age_line_6,
2260 age_line_7,
2261 age_line_8,
2262 a_online_signature,
2263 question_1_number,
2264 question_1_size,
2265 question_1_answer,
2269 question_3_number,
2266 question_2_number,
2267 question_2_size,
2268 question_2_answer,
2270 question_3_size,
2271 question_3_answer,
2272 question_4_number,
2273 question_4_size,
2274 question_4_answer,
2275 question_5_number,
2276 question_5_size,
2277 question_5_answer,
2278 question_6_number,
2279 question_6_size,
2280 question_6_answer,
2281 question_7_number,
2282 question_7_size,
2283 question_7_answer,
2284 question_8_number,
2285 question_8_size,
2286 question_8_answer,
2287 question_9_number,
2288 question_9_size,
2289 question_9_answer,
2290 question_10_number,
2291 question_10_size,
2292 question_10_answer,
2293 question_11_number,
2294 question_11_size,
2295 question_11_answer,
2296 question_12_number,
2297 question_12_size,
2298 question_12_answer,
2299 question_13_number,
2300 question_13_size,
2301 question_13_answer,
2302 question_14_number,
2303 question_14_size,
2304 question_14_answer,
2305 question_15_number,
2306 question_15_size,
2307 question_15_answer,
2308 question_16_number,
2309 question_16_size,
2310 question_16_answer,
2311 question_17_number,
2312 question_17_size,
2313 question_17_answer,
2314 question_18_number,
2315 question_18_size,
2316 question_18_answer,
2317 question_19_number,
2318 question_19_size,
2319 question_19_answer,
2320 question_20_number,
2321 question_20_size,
2322 question_20_answer,
2323 question_21_number,
2324 question_21_size,
2325 question_21_answer,
2326 question_22_number,
2327 question_22_size,
2328 question_22_answer,
2329 question_23_number,
2330 question_23_size,
2331 question_23_answer,
2332 question_24_number,
2333 question_24_size,
2334 question_24_answer,
2335 question_25_number,
2336 question_25_size,
2337 question_25_answer,
2338 question_26_number,
2339 question_26_size,
2340 question_26_answer,
2341 question_27_number,
2342 question_27_size,
2343 question_27_answer,
2344 question_28_number,
2345 question_28_size,
2346 question_28_answer,
2347 question_29_number,
2348 question_29_size,
2349 question_29_answer,
2350 question_30_number,
2351 questions_30_size,
2352 question_30_answer,
2353 creation_date,
2354 created_by,
2355 last_update_date,
2356 last_updated_by,
2357 last_update_login
2358 ) VALUES (
2359 new_references.base_id,
2360 new_references.last_name,
2361 new_references.first_name,
2362 new_references.middle_initial,
2363 new_references.address_number_and_street,
2364 new_references.city,
2365 new_references.state_mailing,
2366 new_references.zip_code,
2367 new_references.s_telephone_number,
2368 new_references.s_title,
2369 new_references.date_of_birth,
2370 new_references.social_security_number,
2371 new_references.state_legal_residence,
2372 new_references.foreign_address_indicator,
2373 new_references.foreign_postal_code,
2374 new_references.country,
2375 new_references.financial_aid_status,
2376 new_references.year_in_college,
2377 new_references.marital_status,
2378 new_references.ward_court,
2379 new_references.legal_dependents_other,
2380 new_references.household_size,
2381 new_references.number_in_college,
2382 new_references.citizenship_status,
2383 new_references.citizenship_country,
2384 new_references.visa_classification,
2385 new_references.tax_figures,
2386 new_references.number_exemptions,
2387 new_references.adjusted_gross_inc,
2388 new_references.us_tax_paid,
2389 new_references.itemized_deductions,
2390 new_references.stu_income_work,
2391 new_references.spouse_income_work,
2392 new_references.divid_int_inc,
2393 new_references.soc_sec_benefits,
2394 new_references.welfare_tanf,
2395 new_references.child_supp_rcvd,
2396 new_references.earned_income_credit,
2397 new_references.other_untax_income,
2398 new_references.tax_stu_aid,
2399 new_references.cash_sav_check,
2400 new_references.ira_keogh,
2401 new_references.invest_value,
2402 new_references.invest_debt,
2403 new_references.home_value,
2404 new_references.home_debt,
2405 new_references.oth_real_value,
2406 new_references.oth_real_debt,
2407 new_references.bus_farm_value,
2408 new_references.bus_farm_debt,
2409 new_references.live_on_farm,
2410 new_references.home_purch_price,
2411 new_references.hope_ll_credit,
2412 new_references.home_purch_year,
2413 new_references.trust_amount,
2414 new_references.trust_avail,
2415 new_references.trust_estab,
2416 new_references.child_support_paid,
2420 new_references.vet_ben_months,
2417 new_references.med_dent_expenses,
2418 new_references.vet_us,
2419 new_references.vet_ben_amount,
2421 new_references.stu_summer_wages,
2422 new_references.stu_school_yr_wages,
2423 new_references.spouse_summer_wages,
2424 new_references.spouse_school_yr_wages,
2425 new_references.summer_other_tax_inc,
2426 new_references.school_yr_other_tax_inc,
2427 new_references.summer_untax_inc,
2428 new_references.school_yr_untax_inc,
2429 new_references.grants_schol_etc,
2430 new_references.tuit_benefits,
2431 new_references.cont_parents,
2432 new_references.cont_relatives,
2433 new_references.p_siblings_pre_tuit,
2434 new_references.p_student_pre_tuit,
2435 new_references.p_household_size,
2436 new_references.p_number_in_college,
2437 new_references.p_parents_in_college,
2438 new_references.p_marital_status,
2439 new_references.p_state_legal_residence,
2440 new_references.p_natural_par_status,
2441 new_references.p_child_supp_paid,
2442 new_references.p_repay_ed_loans,
2443 new_references.p_med_dent_expenses,
2444 new_references.p_tuit_paid_amount,
2445 new_references.p_tuit_paid_number,
2446 new_references.p_exp_child_supp_paid,
2447 new_references.p_exp_repay_ed_loans,
2448 new_references.p_exp_med_dent_expenses,
2449 new_references.p_exp_tuit_pd_amount,
2450 new_references.p_exp_tuit_pd_number,
2451 new_references.p_cash_sav_check,
2452 new_references.p_month_mortgage_pay,
2453 new_references.p_invest_value,
2454 new_references.p_invest_debt,
2455 new_references.p_home_value,
2456 new_references.p_home_debt,
2457 new_references.p_home_purch_price,
2458 new_references.p_own_business_farm,
2459 new_references.p_business_value,
2460 new_references.p_business_debt,
2461 new_references.p_farm_value,
2462 new_references.p_farm_debt,
2463 new_references.p_live_on_farm,
2464 new_references.p_oth_real_estate_value,
2465 new_references.p_oth_real_estate_debt,
2466 new_references.p_oth_real_purch_price,
2467 new_references.p_siblings_assets,
2468 new_references.p_home_purch_year,
2469 new_references.p_oth_real_purch_year,
2470 new_references.p_prior_agi,
2471 new_references.p_prior_us_tax_paid,
2472 new_references.p_prior_item_deductions,
2473 new_references.p_prior_other_untax_inc,
2474 new_references.p_tax_figures,
2475 new_references.p_number_exemptions,
2476 new_references.p_adjusted_gross_inc,
2477 new_references.p_wages_sal_tips,
2478 new_references.p_interest_income,
2479 new_references.p_dividend_income,
2480 new_references.p_net_inc_bus_farm,
2481 new_references.p_other_taxable_income,
2482 new_references.p_adj_to_income,
2483 new_references.p_us_tax_paid,
2484 new_references.p_itemized_deductions,
2485 new_references.p_father_income_work,
2486 new_references.p_mother_income_work,
2487 new_references.p_soc_sec_ben,
2488 new_references.p_welfare_tanf,
2489 new_references.p_child_supp_rcvd,
2490 new_references.p_ded_ira_keogh,
2491 new_references.p_tax_defer_pens_savs,
2492 new_references.p_dep_care_med_spending,
2493 new_references.p_earned_income_credit,
2494 new_references.p_living_allow,
2495 new_references.p_tax_exmpt_int,
2496 new_references.p_foreign_inc_excl,
2497 new_references.p_other_untax_inc,
2498 new_references.p_hope_ll_credit,
2499 new_references.p_yr_separation,
2500 new_references.p_yr_divorce,
2501 new_references.p_exp_father_inc,
2502 new_references.p_exp_mother_inc,
2503 new_references.p_exp_other_tax_inc,
2504 new_references.p_exp_other_untax_inc,
2505 new_references.line_2_relation,
2506 new_references.line_2_attend_college,
2507 new_references.line_3_relation,
2508 new_references.line_3_attend_college,
2509 new_references.line_4_relation,
2510 new_references.line_4_attend_college,
2511 new_references.line_5_relation,
2512 new_references.line_5_attend_college,
2513 new_references.line_6_relation,
2514 new_references.line_6_attend_college,
2515 new_references.line_7_relation,
2516 new_references.line_7_attend_college,
2517 new_references.line_8_relation,
2518 new_references.line_8_attend_college,
2519 new_references.p_age_father,
2520 new_references.p_age_mother,
2521 new_references.p_div_sep_ind,
2522 new_references.b_cont_non_custodial_par,
2523 new_references.college_type_2,
2524 new_references.college_type_3,
2525 new_references.college_type_4,
2526 new_references.college_type_5,
2527 new_references.college_type_6,
2528 new_references.college_type_7,
2529 new_references.college_type_8,
2530 new_references.school_code_1,
2531 new_references.housing_code_1,
2532 new_references.school_code_2,
2533 new_references.housing_code_2,
2534 new_references.school_code_3,
2535 new_references.housing_code_3,
2536 new_references.school_code_4,
2537 new_references.housing_code_4,
2541 new_references.housing_code_6,
2538 new_references.school_code_5,
2539 new_references.housing_code_5,
2540 new_references.school_code_6,
2542 new_references.school_code_7,
2543 new_references.housing_code_7,
2544 new_references.school_code_8,
2545 new_references.housing_code_8,
2546 new_references.school_code_9,
2547 new_references.housing_code_9,
2548 new_references.school_code_10,
2549 new_references.housing_code_10,
2550 new_references.additional_school_code_1,
2551 new_references.additional_school_code_2,
2552 new_references.additional_school_code_3,
2553 new_references.additional_school_code_4,
2554 new_references.additional_school_code_5,
2555 new_references.additional_school_code_6,
2556 new_references.additional_school_code_7,
2557 new_references.additional_school_code_8,
2558 new_references.additional_school_code_9,
2559 new_references.additional_school_code_10,
2560 new_references.explanation_spec_circum,
2561 new_references.signature_student,
2562 new_references.signature_spouse,
2563 new_references.signature_father,
2564 new_references.signature_mother,
2565 new_references.month_day_completed,
2566 new_references.year_completed,
2567 new_references.age_line_2,
2568 new_references.age_line_3,
2569 new_references.age_line_4,
2570 new_references.age_line_5,
2571 new_references.age_line_6,
2572 new_references.age_line_7,
2573 new_references.age_line_8,
2574 new_references.a_online_signature,
2575 new_references.question_1_number,
2576 new_references.question_1_size,
2577 new_references.question_1_answer,
2578 new_references.question_2_number,
2579 new_references.question_2_size,
2580 new_references.question_2_answer,
2581 new_references.question_3_number,
2582 new_references.question_3_size,
2583 new_references.question_3_answer,
2584 new_references.question_4_number,
2585 new_references.question_4_size,
2586 new_references.question_4_answer,
2587 new_references.question_5_number,
2588 new_references.question_5_size,
2589 new_references.question_5_answer,
2590 new_references.question_6_number,
2591 new_references.question_6_size,
2592 new_references.question_6_answer,
2593 new_references.question_7_number,
2594 new_references.question_7_size,
2595 new_references.question_7_answer,
2596 new_references.question_8_number,
2597 new_references.question_8_size,
2598 new_references.question_8_answer,
2599 new_references.question_9_number,
2600 new_references.question_9_size,
2601 new_references.question_9_answer,
2602 new_references.question_10_number,
2603 new_references.question_10_size,
2604 new_references.question_10_answer,
2605 new_references.question_11_number,
2606 new_references.question_11_size,
2607 new_references.question_11_answer,
2608 new_references.question_12_number,
2609 new_references.question_12_size,
2610 new_references.question_12_answer,
2611 new_references.question_13_number,
2612 new_references.question_13_size,
2613 new_references.question_13_answer,
2614 new_references.question_14_number,
2615 new_references.question_14_size,
2616 new_references.question_14_answer,
2617 new_references.question_15_number,
2618 new_references.question_15_size,
2619 new_references.question_15_answer,
2620 new_references.question_16_number,
2621 new_references.question_16_size,
2622 new_references.question_16_answer,
2623 new_references.question_17_number,
2624 new_references.question_17_size,
2625 new_references.question_17_answer,
2626 new_references.question_18_number,
2627 new_references.question_18_size,
2628 new_references.question_18_answer,
2629 new_references.question_19_number,
2630 new_references.question_19_size,
2631 new_references.question_19_answer,
2632 new_references.question_20_number,
2633 new_references.question_20_size,
2634 new_references.question_20_answer,
2635 new_references.question_21_number,
2636 new_references.question_21_size,
2637 new_references.question_21_answer,
2638 new_references.question_22_number,
2639 new_references.question_22_size,
2640 new_references.question_22_answer,
2641 new_references.question_23_number,
2642 new_references.question_23_size,
2643 new_references.question_23_answer,
2644 new_references.question_24_number,
2645 new_references.question_24_size,
2646 new_references.question_24_answer,
2647 new_references.question_25_number,
2648 new_references.question_25_size,
2649 new_references.question_25_answer,
2650 new_references.question_26_number,
2651 new_references.question_26_size,
2652 new_references.question_26_answer,
2653 new_references.question_27_number,
2654 new_references.question_27_size,
2655 new_references.question_27_answer,
2656 new_references.question_28_number,
2660 new_references.question_29_size,
2657 new_references.question_28_size,
2658 new_references.question_28_answer,
2659 new_references.question_29_number,
2661 new_references.question_29_answer,
2662 new_references.question_30_number,
2663 new_references.questions_30_size,
2664 new_references.question_30_answer,
2665 x_last_update_date,
2666 x_last_updated_by,
2667 x_last_update_date,
2668 x_last_updated_by,
2669 x_last_update_login
2670 );
2671
2672 OPEN c;
2673 FETCH c INTO x_rowid;
2674 IF (c%NOTFOUND) THEN
2675 CLOSE c;
2676 RAISE NO_DATA_FOUND;
2677 END IF;
2678 CLOSE c;
2679
2680 END insert_row;
2681
2682
2683 PROCEDURE lock_row (
2684 x_rowid IN VARCHAR2,
2685 x_base_id IN NUMBER,
2686 x_last_name IN VARCHAR2,
2687 x_first_name IN VARCHAR2,
2688 x_middle_initial IN VARCHAR2,
2689 x_address_number_and_street IN VARCHAR2,
2690 x_city IN VARCHAR2,
2691 x_state_mailing IN VARCHAR2,
2692 x_zip_code IN VARCHAR2,
2693 x_s_telephone_number IN VARCHAR2,
2694 x_s_title IN VARCHAR2,
2695 x_date_of_birth IN VARCHAR2,
2696 x_social_security_number IN VARCHAR2,
2697 x_state_legal_residence IN VARCHAR2,
2698 x_foreign_address_indicator IN VARCHAR2,
2699 x_foreign_postal_code IN VARCHAR2,
2700 x_country IN VARCHAR2,
2701 x_financial_aid_status IN VARCHAR2,
2702 x_year_in_college IN VARCHAR2,
2703 x_marital_status IN VARCHAR2,
2704 x_ward_court IN VARCHAR2,
2705 x_legal_dependents_other IN VARCHAR2,
2706 x_household_size IN VARCHAR2,
2707 x_number_in_college IN VARCHAR2,
2708 x_citizenship_status IN VARCHAR2,
2709 x_citizenship_country IN VARCHAR2,
2710 x_visa_classification IN VARCHAR2,
2711 x_tax_figures IN VARCHAR2,
2712 x_number_exemptions IN VARCHAR2,
2713 x_adjusted_gross_inc IN VARCHAR2,
2714 x_us_tax_paid IN VARCHAR2,
2715 x_itemized_deductions IN VARCHAR2,
2716 x_stu_income_work IN VARCHAR2,
2717 x_spouse_income_work IN VARCHAR2,
2718 x_divid_int_inc IN VARCHAR2,
2719 x_soc_sec_benefits IN VARCHAR2,
2720 x_welfare_tanf IN VARCHAR2,
2721 x_child_supp_rcvd IN VARCHAR2,
2722 x_earned_income_credit IN VARCHAR2,
2723 x_other_untax_income IN VARCHAR2,
2724 x_tax_stu_aid IN VARCHAR2,
2725 x_cash_sav_check IN VARCHAR2,
2726 x_ira_keogh IN VARCHAR2,
2727 x_invest_value IN VARCHAR2,
2728 x_invest_debt IN VARCHAR2,
2729 x_home_value IN VARCHAR2,
2730 x_home_debt IN VARCHAR2,
2731 x_oth_real_value IN VARCHAR2,
2732 x_oth_real_debt IN VARCHAR2,
2733 x_bus_farm_value IN VARCHAR2,
2734 x_bus_farm_debt IN VARCHAR2,
2735 x_live_on_farm IN VARCHAR2,
2736 x_home_purch_price IN VARCHAR2,
2737 x_hope_ll_credit IN VARCHAR2,
2738 x_home_purch_year IN VARCHAR2,
2739 x_trust_amount IN VARCHAR2,
2740 x_trust_avail IN VARCHAR2,
2741 x_trust_estab IN VARCHAR2,
2742 x_child_support_paid IN VARCHAR2,
2743 x_med_dent_expenses IN VARCHAR2,
2744 x_vet_us IN VARCHAR2,
2745 x_vet_ben_amount IN VARCHAR2,
2746 x_vet_ben_months IN VARCHAR2,
2747 x_stu_summer_wages IN VARCHAR2,
2748 x_stu_school_yr_wages IN VARCHAR2,
2749 x_spouse_summer_wages IN VARCHAR2,
2750 x_spouse_school_yr_wages IN VARCHAR2,
2751 x_summer_other_tax_inc IN VARCHAR2,
2752 x_school_yr_other_tax_inc IN VARCHAR2,
2753 x_summer_untax_inc IN VARCHAR2,
2754 x_school_yr_untax_inc IN VARCHAR2,
2755 x_grants_schol_etc IN VARCHAR2,
2756 x_tuit_benefits IN VARCHAR2,
2757 x_cont_parents IN VARCHAR2,
2758 x_cont_relatives IN VARCHAR2,
2759 x_p_siblings_pre_tuit IN VARCHAR2,
2760 x_p_student_pre_tuit IN VARCHAR2,
2761 x_p_household_size IN VARCHAR2,
2762 x_p_number_in_college IN VARCHAR2,
2763 x_p_parents_in_college IN VARCHAR2,
2767 x_p_child_supp_paid IN VARCHAR2,
2764 x_p_marital_status IN VARCHAR2,
2765 x_p_state_legal_residence IN VARCHAR2,
2766 x_p_natural_par_status IN VARCHAR2,
2768 x_p_repay_ed_loans IN VARCHAR2,
2769 x_p_med_dent_expenses IN VARCHAR2,
2770 x_p_tuit_paid_amount IN VARCHAR2,
2771 x_p_tuit_paid_number IN VARCHAR2,
2772 x_p_exp_child_supp_paid IN VARCHAR2,
2773 x_p_exp_repay_ed_loans IN VARCHAR2,
2774 x_p_exp_med_dent_expenses IN VARCHAR2,
2775 x_p_exp_tuit_pd_amount IN VARCHAR2,
2776 x_p_exp_tuit_pd_number IN VARCHAR2,
2777 x_p_cash_sav_check IN VARCHAR2,
2778 x_p_month_mortgage_pay IN VARCHAR2,
2779 x_p_invest_value IN VARCHAR2,
2780 x_p_invest_debt IN VARCHAR2,
2781 x_p_home_value IN VARCHAR2,
2782 x_p_home_debt IN VARCHAR2,
2783 x_p_home_purch_price IN VARCHAR2,
2784 x_p_own_business_farm IN VARCHAR2,
2785 x_p_business_value IN VARCHAR2,
2786 x_p_business_debt IN VARCHAR2,
2787 x_p_farm_value IN VARCHAR2,
2788 x_p_farm_debt IN VARCHAR2,
2789 x_p_live_on_farm IN VARCHAR2,
2790 x_p_oth_real_estate_value IN VARCHAR2,
2791 x_p_oth_real_estate_debt IN VARCHAR2,
2792 x_p_oth_real_purch_price IN VARCHAR2,
2793 x_p_siblings_assets IN VARCHAR2,
2794 x_p_home_purch_year IN VARCHAR2,
2795 x_p_oth_real_purch_year IN VARCHAR2,
2796 x_p_prior_agi IN VARCHAR2,
2797 x_p_prior_us_tax_paid IN VARCHAR2,
2798 x_p_prior_item_deductions IN VARCHAR2,
2799 x_p_prior_other_untax_inc IN VARCHAR2,
2800 x_p_tax_figures IN VARCHAR2,
2801 x_p_number_exemptions IN VARCHAR2,
2802 x_p_adjusted_gross_inc IN VARCHAR2,
2803 x_p_wages_sal_tips IN VARCHAR2,
2804 x_p_interest_income IN VARCHAR2,
2805 x_p_dividend_income IN VARCHAR2,
2806 x_p_net_inc_bus_farm IN VARCHAR2,
2807 x_p_other_taxable_income IN VARCHAR2,
2808 x_p_adj_to_income IN VARCHAR2,
2809 x_p_us_tax_paid IN VARCHAR2,
2810 x_p_itemized_deductions IN VARCHAR2,
2811 x_p_father_income_work IN VARCHAR2,
2812 x_p_mother_income_work IN VARCHAR2,
2813 x_p_soc_sec_ben IN VARCHAR2,
2814 x_p_welfare_tanf IN VARCHAR2,
2815 x_p_child_supp_rcvd IN VARCHAR2,
2816 x_p_ded_ira_keogh IN VARCHAR2,
2817 x_p_tax_defer_pens_savs IN VARCHAR2,
2818 x_p_dep_care_med_spending IN VARCHAR2,
2819 x_p_earned_income_credit IN VARCHAR2,
2820 x_p_living_allow IN VARCHAR2,
2821 x_p_tax_exmpt_int IN VARCHAR2,
2822 x_p_foreign_inc_excl IN VARCHAR2,
2823 x_p_other_untax_inc IN VARCHAR2,
2824 x_p_hope_ll_credit IN VARCHAR2,
2825 x_p_yr_separation IN VARCHAR2,
2826 x_p_yr_divorce IN VARCHAR2,
2827 x_p_exp_father_inc IN VARCHAR2,
2828 x_p_exp_mother_inc IN VARCHAR2,
2829 x_p_exp_other_tax_inc IN VARCHAR2,
2830 x_p_exp_other_untax_inc IN VARCHAR2,
2831 x_line_2_relation IN VARCHAR2,
2832 x_line_2_attend_college IN VARCHAR2,
2833 x_line_3_relation IN VARCHAR2,
2834 x_line_3_attend_college IN VARCHAR2,
2835 x_line_4_relation IN VARCHAR2,
2836 x_line_4_attend_college IN VARCHAR2,
2837 x_line_5_relation IN VARCHAR2,
2838 x_line_5_attend_college IN VARCHAR2,
2839 x_line_6_relation IN VARCHAR2,
2840 x_line_6_attend_college IN VARCHAR2,
2841 x_line_7_relation IN VARCHAR2,
2842 x_line_7_attend_college IN VARCHAR2,
2843 x_line_8_relation IN VARCHAR2,
2844 x_line_8_attend_college IN VARCHAR2,
2845 x_p_age_father IN VARCHAR2,
2846 x_p_age_mother IN VARCHAR2,
2847 x_p_div_sep_ind IN VARCHAR2,
2848 x_b_cont_non_custodial_par IN VARCHAR2,
2849 x_college_type_2 IN VARCHAR2,
2850 x_college_type_3 IN VARCHAR2,
2851 x_college_type_4 IN VARCHAR2,
2852 x_college_type_5 IN VARCHAR2,
2853 x_college_type_6 IN VARCHAR2,
2854 x_college_type_7 IN VARCHAR2,
2855 x_college_type_8 IN VARCHAR2,
2856 x_school_code_1 IN VARCHAR2,
2857 x_housing_code_1 IN VARCHAR2,
2858 x_school_code_2 IN VARCHAR2,
2859 x_housing_code_2 IN VARCHAR2,
2863 x_housing_code_4 IN VARCHAR2,
2860 x_school_code_3 IN VARCHAR2,
2861 x_housing_code_3 IN VARCHAR2,
2862 x_school_code_4 IN VARCHAR2,
2864 x_school_code_5 IN VARCHAR2,
2865 x_housing_code_5 IN VARCHAR2,
2866 x_school_code_6 IN VARCHAR2,
2867 x_housing_code_6 IN VARCHAR2,
2868 x_school_code_7 IN VARCHAR2,
2869 x_housing_code_7 IN VARCHAR2,
2870 x_school_code_8 IN VARCHAR2,
2871 x_housing_code_8 IN VARCHAR2,
2872 x_school_code_9 IN VARCHAR2,
2873 x_housing_code_9 IN VARCHAR2,
2874 x_school_code_10 IN VARCHAR2,
2875 x_housing_code_10 IN VARCHAR2,
2876 x_additional_school_code_1 IN VARCHAR2,
2877 x_additional_school_code_2 IN VARCHAR2,
2878 x_additional_school_code_3 IN VARCHAR2,
2879 x_additional_school_code_4 IN VARCHAR2,
2880 x_additional_school_code_5 IN VARCHAR2,
2881 x_additional_school_code_6 IN VARCHAR2,
2882 x_additional_school_code_7 IN VARCHAR2,
2883 x_additional_school_code_8 IN VARCHAR2,
2884 x_additional_school_code_9 IN VARCHAR2,
2885 x_additional_school_code_10 IN VARCHAR2,
2886 x_explanation_spec_circum IN VARCHAR2,
2887 x_signature_student IN VARCHAR2,
2888 x_signature_spouse IN VARCHAR2,
2889 x_signature_father IN VARCHAR2,
2890 x_signature_mother IN VARCHAR2,
2891 x_month_day_completed IN VARCHAR2,
2892 x_year_completed IN VARCHAR2,
2893 x_age_line_2 IN VARCHAR2,
2894 x_age_line_3 IN VARCHAR2,
2895 x_age_line_4 IN VARCHAR2,
2896 x_age_line_5 IN VARCHAR2,
2897 x_age_line_6 IN VARCHAR2,
2898 x_age_line_7 IN VARCHAR2,
2899 x_age_line_8 IN VARCHAR2,
2900 x_a_online_signature IN VARCHAR2,
2901 x_question_1_number IN VARCHAR2,
2902 x_question_1_size IN VARCHAR2,
2903 x_question_1_answer IN VARCHAR2,
2904 x_question_2_number IN VARCHAR2,
2905 x_question_2_size IN VARCHAR2,
2906 x_question_2_answer IN VARCHAR2,
2907 x_question_3_number IN VARCHAR2,
2908 x_question_3_size IN VARCHAR2,
2909 x_question_3_answer IN VARCHAR2,
2910 x_question_4_number IN VARCHAR2,
2911 x_question_4_size IN VARCHAR2,
2912 x_question_4_answer IN VARCHAR2,
2913 x_question_5_number IN VARCHAR2,
2914 x_question_5_size IN VARCHAR2,
2915 x_question_5_answer IN VARCHAR2,
2916 x_question_6_number IN VARCHAR2,
2917 x_question_6_size IN VARCHAR2,
2918 x_question_6_answer IN VARCHAR2,
2919 x_question_7_number IN VARCHAR2,
2920 x_question_7_size IN VARCHAR2,
2921 x_question_7_answer IN VARCHAR2,
2922 x_question_8_number IN VARCHAR2,
2923 x_question_8_size IN VARCHAR2,
2924 x_question_8_answer IN VARCHAR2,
2925 x_question_9_number IN VARCHAR2,
2926 x_question_9_size IN VARCHAR2,
2927 x_question_9_answer IN VARCHAR2,
2928 x_question_10_number IN VARCHAR2,
2929 x_question_10_size IN VARCHAR2,
2930 x_question_10_answer IN VARCHAR2,
2931 x_question_11_number IN VARCHAR2,
2932 x_question_11_size IN VARCHAR2,
2933 x_question_11_answer IN VARCHAR2,
2934 x_question_12_number IN VARCHAR2,
2935 x_question_12_size IN VARCHAR2,
2936 x_question_12_answer IN VARCHAR2,
2937 x_question_13_number IN VARCHAR2,
2938 x_question_13_size IN VARCHAR2,
2939 x_question_13_answer IN VARCHAR2,
2940 x_question_14_number IN VARCHAR2,
2941 x_question_14_size IN VARCHAR2,
2942 x_question_14_answer IN VARCHAR2,
2943 x_question_15_number IN VARCHAR2,
2944 x_question_15_size IN VARCHAR2,
2945 x_question_15_answer IN VARCHAR2,
2946 x_question_16_number IN VARCHAR2,
2947 x_question_16_size IN VARCHAR2,
2948 x_question_16_answer IN VARCHAR2,
2949 x_question_17_number IN VARCHAR2,
2950 x_question_17_size IN VARCHAR2,
2951 x_question_17_answer IN VARCHAR2,
2952 x_question_18_number IN VARCHAR2,
2953 x_question_18_size IN VARCHAR2,
2954 x_question_18_answer IN VARCHAR2,
2955 x_question_19_number IN VARCHAR2,
2959 x_question_20_size IN VARCHAR2,
2956 x_question_19_size IN VARCHAR2,
2957 x_question_19_answer IN VARCHAR2,
2958 x_question_20_number IN VARCHAR2,
2960 x_question_20_answer IN VARCHAR2,
2961 x_question_21_number IN VARCHAR2,
2962 x_question_21_size IN VARCHAR2,
2963 x_question_21_answer IN VARCHAR2,
2964 x_question_22_number IN VARCHAR2,
2965 x_question_22_size IN VARCHAR2,
2966 x_question_22_answer IN VARCHAR2,
2967 x_question_23_number IN VARCHAR2,
2968 x_question_23_size IN VARCHAR2,
2969 x_question_23_answer IN VARCHAR2,
2970 x_question_24_number IN VARCHAR2,
2971 x_question_24_size IN VARCHAR2,
2972 x_question_24_answer IN VARCHAR2,
2973 x_question_25_number IN VARCHAR2,
2974 x_question_25_size IN VARCHAR2,
2975 x_question_25_answer IN VARCHAR2,
2976 x_question_26_number IN VARCHAR2,
2977 x_question_26_size IN VARCHAR2,
2978 x_question_26_answer IN VARCHAR2,
2979 x_question_27_number IN VARCHAR2,
2980 x_question_27_size IN VARCHAR2,
2981 x_question_27_answer IN VARCHAR2,
2982 x_question_28_number IN VARCHAR2,
2983 x_question_28_size IN VARCHAR2,
2984 x_question_28_answer IN VARCHAR2,
2985 x_question_29_number IN VARCHAR2,
2986 x_question_29_size IN VARCHAR2,
2987 x_question_29_answer IN VARCHAR2,
2988 x_question_30_number IN VARCHAR2,
2989 x_questions_30_size IN VARCHAR2,
2990 x_question_30_answer IN VARCHAR2
2991 ) AS
2992 /*
2993 || Created By : kkillams
2994 || Created On : 30-MAY-2001
2995 || Purpose : Handles the LOCK mechanism for the table.
2996 || Known limitations, enhancements or remarks :
2997 || Change History :
2998 || Who When What
2999 || (reverse chronological order - newest change first)
3000 */
3001 CURSOR c1 IS
3002 SELECT
3003 last_name,
3004 first_name,
3005 middle_initial,
3006 address_number_and_street,
3007 city,
3008 state_mailing,
3009 zip_code,
3010 s_telephone_number,
3011 s_title,
3012 date_of_birth,
3013 social_security_number,
3014 state_legal_residence,
3015 foreign_address_indicator,
3016 foreign_postal_code,
3017 country,
3018 financial_aid_status,
3019 year_in_college,
3020 marital_status,
3021 ward_court,
3022 legal_dependents_other,
3023 household_size,
3024 number_in_college,
3025 citizenship_status,
3026 citizenship_country,
3027 visa_classification,
3028 tax_figures,
3029 number_exemptions,
3030 adjusted_gross_inc,
3031 us_tax_paid,
3032 itemized_deductions,
3033 stu_income_work,
3034 spouse_income_work,
3035 divid_int_inc,
3036 soc_sec_benefits,
3037 welfare_tanf,
3038 child_supp_rcvd,
3039 earned_income_credit,
3040 other_untax_income,
3041 tax_stu_aid,
3042 cash_sav_check,
3043 ira_keogh,
3044 invest_value,
3045 invest_debt,
3046 home_value,
3047 home_debt,
3048 oth_real_value,
3049 oth_real_debt,
3050 bus_farm_value,
3051 bus_farm_debt,
3052 live_on_farm,
3053 home_purch_price,
3054 hope_ll_credit,
3055 home_purch_year,
3056 trust_amount,
3057 trust_avail,
3058 trust_estab,
3059 child_support_paid,
3060 med_dent_expenses,
3061 vet_us,
3062 vet_ben_amount,
3063 vet_ben_months,
3064 stu_summer_wages,
3065 stu_school_yr_wages,
3066 spouse_summer_wages,
3067 spouse_school_yr_wages,
3068 summer_other_tax_inc,
3069 school_yr_other_tax_inc,
3070 summer_untax_inc,
3071 school_yr_untax_inc,
3072 grants_schol_etc,
3073 tuit_benefits,
3074 cont_parents,
3075 cont_relatives,
3076 p_siblings_pre_tuit,
3077 p_student_pre_tuit,
3078 p_household_size,
3079 p_number_in_college,
3080 p_parents_in_college,
3081 p_marital_status,
3082 p_state_legal_residence,
3083 p_natural_par_status,
3084 p_child_supp_paid,
3085 p_repay_ed_loans,
3086 p_med_dent_expenses,
3087 p_tuit_paid_amount,
3088 p_tuit_paid_number,
3089 p_exp_child_supp_paid,
3090 p_exp_repay_ed_loans,
3091 p_exp_med_dent_expenses,
3092 p_exp_tuit_pd_amount,
3093 p_exp_tuit_pd_number,
3094 p_cash_sav_check,
3095 p_month_mortgage_pay,
3096 p_invest_value,
3097 p_invest_debt,
3101 p_own_business_farm,
3098 p_home_value,
3099 p_home_debt,
3100 p_home_purch_price,
3102 p_business_value,
3103 p_business_debt,
3104 p_farm_value,
3105 p_farm_debt,
3106 p_live_on_farm,
3107 p_oth_real_estate_value,
3108 p_oth_real_estate_debt,
3109 p_oth_real_purch_price,
3110 p_siblings_assets,
3111 p_home_purch_year,
3112 p_oth_real_purch_year,
3113 p_prior_agi,
3114 p_prior_us_tax_paid,
3115 p_prior_item_deductions,
3116 p_prior_other_untax_inc,
3117 p_tax_figures,
3118 p_number_exemptions,
3119 p_adjusted_gross_inc,
3120 p_wages_sal_tips,
3121 p_interest_income,
3122 p_dividend_income,
3123 p_net_inc_bus_farm,
3124 p_other_taxable_income,
3125 p_adj_to_income,
3126 p_us_tax_paid,
3127 p_itemized_deductions,
3128 p_father_income_work,
3129 p_mother_income_work,
3130 p_soc_sec_ben,
3131 p_welfare_tanf,
3132 p_child_supp_rcvd,
3133 p_ded_ira_keogh,
3134 p_tax_defer_pens_savs,
3135 p_dep_care_med_spending,
3136 p_earned_income_credit,
3137 p_living_allow,
3138 p_tax_exmpt_int,
3139 p_foreign_inc_excl,
3140 p_other_untax_inc,
3141 p_hope_ll_credit,
3142 p_yr_separation,
3143 p_yr_divorce,
3144 p_exp_father_inc,
3145 p_exp_mother_inc,
3146 p_exp_other_tax_inc,
3147 p_exp_other_untax_inc,
3148 line_2_relation,
3149 line_2_attend_college,
3150 line_3_relation,
3151 line_3_attend_college,
3152 line_4_relation,
3153 line_4_attend_college,
3154 line_5_relation,
3155 line_5_attend_college,
3156 line_6_relation,
3157 line_6_attend_college,
3158 line_7_relation,
3159 line_7_attend_college,
3160 line_8_relation,
3161 line_8_attend_college,
3162 p_age_father,
3163 p_age_mother,
3164 p_div_sep_ind,
3165 b_cont_non_custodial_par,
3166 college_type_2,
3167 college_type_3,
3168 college_type_4,
3169 college_type_5,
3170 college_type_6,
3171 college_type_7,
3172 college_type_8,
3173 school_code_1,
3174 housing_code_1,
3175 school_code_2,
3176 housing_code_2,
3177 school_code_3,
3178 housing_code_3,
3179 school_code_4,
3180 housing_code_4,
3181 school_code_5,
3182 housing_code_5,
3183 school_code_6,
3184 housing_code_6,
3185 school_code_7,
3186 housing_code_7,
3187 school_code_8,
3188 housing_code_8,
3189 school_code_9,
3190 housing_code_9,
3191 school_code_10,
3192 housing_code_10,
3193 additional_school_code_1,
3194 additional_school_code_2,
3195 additional_school_code_3,
3196 additional_school_code_4,
3197 additional_school_code_5,
3198 additional_school_code_6,
3199 additional_school_code_7,
3200 additional_school_code_8,
3201 additional_school_code_9,
3202 additional_school_code_10,
3203 explanation_spec_circum,
3204 signature_student,
3205 signature_spouse,
3206 signature_father,
3207 signature_mother,
3208 month_day_completed,
3209 year_completed,
3210 age_line_2,
3211 age_line_3,
3212 age_line_4,
3213 age_line_5,
3214 age_line_6,
3215 age_line_7,
3216 age_line_8,
3217 a_online_signature,
3218 question_1_number,
3219 question_1_size,
3220 question_1_answer,
3221 question_2_number,
3222 question_2_size,
3223 question_2_answer,
3224 question_3_number,
3225 question_3_size,
3226 question_3_answer,
3227 question_4_number,
3228 question_4_size,
3229 question_4_answer,
3230 question_5_number,
3231 question_5_size,
3232 question_5_answer,
3233 question_6_number,
3234 question_6_size,
3235 question_6_answer,
3236 question_7_number,
3237 question_7_size,
3238 question_7_answer,
3239 question_8_number,
3240 question_8_size,
3241 question_8_answer,
3242 question_9_number,
3243 question_9_size,
3244 question_9_answer,
3245 question_10_number,
3246 question_10_size,
3247 question_10_answer,
3248 question_11_number,
3249 question_11_size,
3250 question_11_answer,
3251 question_12_number,
3252 question_12_size,
3253 question_12_answer,
3254 question_13_number,
3255 question_13_size,
3256 question_13_answer,
3257 question_14_number,
3258 question_14_size,
3259 question_14_answer,
3260 question_15_number,
3261 question_15_size,
3262 question_15_answer,
3263 question_16_number,
3264 question_16_size,
3265 question_16_answer,
3266 question_17_number,
3270 question_18_size,
3267 question_17_size,
3268 question_17_answer,
3269 question_18_number,
3271 question_18_answer,
3272 question_19_number,
3273 question_19_size,
3274 question_19_answer,
3275 question_20_number,
3276 question_20_size,
3277 question_20_answer,
3278 question_21_number,
3279 question_21_size,
3280 question_21_answer,
3281 question_22_number,
3282 question_22_size,
3283 question_22_answer,
3284 question_23_number,
3285 question_23_size,
3286 question_23_answer,
3287 question_24_number,
3288 question_24_size,
3289 question_24_answer,
3290 question_25_number,
3291 question_25_size,
3292 question_25_answer,
3293 question_26_number,
3294 question_26_size,
3295 question_26_answer,
3296 question_27_number,
3297 question_27_size,
3298 question_27_answer,
3299 question_28_number,
3300 question_28_size,
3301 question_28_answer,
3302 question_29_number,
3303 question_29_size,
3304 question_29_answer,
3305 question_30_number,
3306 questions_30_size,
3307 question_30_answer
3308 FROM igf_ap_cs_upd_flags
3309 WHERE rowid = x_rowid
3310 FOR UPDATE NOWAIT;
3311
3312 tlinfo c1%ROWTYPE;
3313
3314 BEGIN
3315
3316 OPEN c1;
3317 FETCH c1 INTO tlinfo;
3318 IF (c1%notfound) THEN
3319 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
3320 igs_ge_msg_stack.add;
3321 CLOSE c1;
3322 app_exception.raise_exception;
3323 RETURN;
3324 END IF;
3325 CLOSE c1;
3326
3327 IF (
3328 ((tlinfo.last_name = x_last_name) OR ((tlinfo.last_name IS NULL) AND (X_last_name IS NULL)))
3329 AND ((tlinfo.first_name = x_first_name) OR ((tlinfo.first_name IS NULL) AND (X_first_name IS NULL)))
3330 AND ((tlinfo.middle_initial = x_middle_initial) OR ((tlinfo.middle_initial IS NULL) AND (X_middle_initial IS NULL)))
3331 AND ((tlinfo.address_number_and_street = x_address_number_and_street) OR ((tlinfo.address_number_and_street IS NULL) AND (X_address_number_and_street IS NULL)))
3332 AND ((tlinfo.city = x_city) OR ((tlinfo.city IS NULL) AND (X_city IS NULL)))
3333 AND ((tlinfo.state_mailing = x_state_mailing) OR ((tlinfo.state_mailing IS NULL) AND (X_state_mailing IS NULL)))
3334 AND ((tlinfo.zip_code = x_zip_code) OR ((tlinfo.zip_code IS NULL) AND (X_zip_code IS NULL)))
3335 AND ((tlinfo.s_telephone_number = x_s_telephone_number) OR ((tlinfo.s_telephone_number IS NULL) AND (X_s_telephone_number IS NULL)))
3336 AND ((tlinfo.s_title = x_s_title) OR ((tlinfo.s_title IS NULL) AND (X_s_title IS NULL)))
3337 AND ((tlinfo.date_of_birth = x_date_of_birth) OR ((tlinfo.date_of_birth IS NULL) AND (X_date_of_birth IS NULL)))
3338 AND ((tlinfo.social_security_number = x_social_security_number) OR ((tlinfo.social_security_number IS NULL) AND (X_social_security_number IS NULL)))
3339 AND ((tlinfo.state_legal_residence = x_state_legal_residence) OR ((tlinfo.state_legal_residence IS NULL) AND (X_state_legal_residence IS NULL)))
3340 AND ((tlinfo.foreign_address_indicator = x_foreign_address_indicator) OR ((tlinfo.foreign_address_indicator IS NULL) AND (X_foreign_address_indicator IS NULL)))
3341 AND ((tlinfo.foreign_postal_code = x_foreign_postal_code) OR ((tlinfo.foreign_postal_code IS NULL) AND (X_foreign_postal_code IS NULL)))
3342 AND ((tlinfo.country = x_country) OR ((tlinfo.country IS NULL) AND (X_country IS NULL)))
3343 AND ((tlinfo.financial_aid_status = x_financial_aid_status) OR ((tlinfo.financial_aid_status IS NULL) AND (X_financial_aid_status IS NULL)))
3344 AND ((tlinfo.year_in_college = x_year_in_college) OR ((tlinfo.year_in_college IS NULL) AND (X_year_in_college IS NULL)))
3345 AND ((tlinfo.marital_status = x_marital_status) OR ((tlinfo.marital_status IS NULL) AND (X_marital_status IS NULL)))
3346 AND ((tlinfo.ward_court = x_ward_court) OR ((tlinfo.ward_court IS NULL) AND (X_ward_court IS NULL)))
3347 AND ((tlinfo.legal_dependents_other = x_legal_dependents_other) OR ((tlinfo.legal_dependents_other IS NULL) AND (X_legal_dependents_other IS NULL)))
3348 AND ((tlinfo.household_size = x_household_size) OR ((tlinfo.household_size IS NULL) AND (X_household_size IS NULL)))
3349 AND ((tlinfo.number_in_college = x_number_in_college) OR ((tlinfo.number_in_college IS NULL) AND (X_number_in_college IS NULL)))
3350 AND ((tlinfo.citizenship_status = x_citizenship_status) OR ((tlinfo.citizenship_status IS NULL) AND (X_citizenship_status IS NULL)))
3351 AND ((tlinfo.citizenship_country = x_citizenship_country) OR ((tlinfo.citizenship_country IS NULL) AND (X_citizenship_country IS NULL)))
3352 AND ((tlinfo.visa_classification = x_visa_classification) OR ((tlinfo.visa_classification IS NULL) AND (X_visa_classification IS NULL)))
3353 AND ((tlinfo.tax_figures = x_tax_figures) OR ((tlinfo.tax_figures IS NULL) AND (X_tax_figures IS NULL)))
3354 AND ((tlinfo.number_exemptions = x_number_exemptions) OR ((tlinfo.number_exemptions IS NULL) AND (X_number_exemptions IS NULL)))
3355 AND ((tlinfo.adjusted_gross_inc = x_adjusted_gross_inc) OR ((tlinfo.adjusted_gross_inc IS NULL) AND (X_adjusted_gross_inc IS NULL)))
3356 AND ((tlinfo.us_tax_paid = x_us_tax_paid) OR ((tlinfo.us_tax_paid IS NULL) AND (X_us_tax_paid IS NULL)))
3357 AND ((tlinfo.itemized_deductions = x_itemized_deductions) OR ((tlinfo.itemized_deductions IS NULL) AND (X_itemized_deductions IS NULL)))
3358 AND ((tlinfo.stu_income_work = x_stu_income_work) OR ((tlinfo.stu_income_work IS NULL) AND (X_stu_income_work IS NULL)))
3362 AND ((tlinfo.welfare_tanf = x_welfare_tanf) OR ((tlinfo.welfare_tanf IS NULL) AND (X_welfare_tanf IS NULL)))
3359 AND ((tlinfo.spouse_income_work = x_spouse_income_work) OR ((tlinfo.spouse_income_work IS NULL) AND (X_spouse_income_work IS NULL)))
3360 AND ((tlinfo.divid_int_inc = x_divid_int_inc) OR ((tlinfo.divid_int_inc IS NULL) AND (X_divid_int_inc IS NULL)))
3361 AND ((tlinfo.soc_sec_benefits = x_soc_sec_benefits) OR ((tlinfo.soc_sec_benefits IS NULL) AND (X_soc_sec_benefits IS NULL)))
3363 AND ((tlinfo.child_supp_rcvd = x_child_supp_rcvd) OR ((tlinfo.child_supp_rcvd IS NULL) AND (X_child_supp_rcvd IS NULL)))
3364 AND ((tlinfo.earned_income_credit = x_earned_income_credit) OR ((tlinfo.earned_income_credit IS NULL) AND (X_earned_income_credit IS NULL)))
3365 AND ((tlinfo.other_untax_income = x_other_untax_income) OR ((tlinfo.other_untax_income IS NULL) AND (X_other_untax_income IS NULL)))
3366 AND ((tlinfo.tax_stu_aid = x_tax_stu_aid) OR ((tlinfo.tax_stu_aid IS NULL) AND (X_tax_stu_aid IS NULL)))
3367 AND ((tlinfo.cash_sav_check = x_cash_sav_check) OR ((tlinfo.cash_sav_check IS NULL) AND (X_cash_sav_check IS NULL)))
3368 AND ((tlinfo.ira_keogh = x_ira_keogh) OR ((tlinfo.ira_keogh IS NULL) AND (X_ira_keogh IS NULL)))
3369 AND ((tlinfo.invest_value = x_invest_value) OR ((tlinfo.invest_value IS NULL) AND (X_invest_value IS NULL)))
3370 AND ((tlinfo.invest_debt = x_invest_debt) OR ((tlinfo.invest_debt IS NULL) AND (X_invest_debt IS NULL)))
3371 AND ((tlinfo.home_value = x_home_value) OR ((tlinfo.home_value IS NULL) AND (X_home_value IS NULL)))
3372 AND ((tlinfo.home_debt = x_home_debt) OR ((tlinfo.home_debt IS NULL) AND (X_home_debt IS NULL)))
3373 AND ((tlinfo.oth_real_value = x_oth_real_value) OR ((tlinfo.oth_real_value IS NULL) AND (X_oth_real_value IS NULL)))
3374 AND ((tlinfo.oth_real_debt = x_oth_real_debt) OR ((tlinfo.oth_real_debt IS NULL) AND (X_oth_real_debt IS NULL)))
3375 AND ((tlinfo.bus_farm_value = x_bus_farm_value) OR ((tlinfo.bus_farm_value IS NULL) AND (X_bus_farm_value IS NULL)))
3376 AND ((tlinfo.bus_farm_debt = x_bus_farm_debt) OR ((tlinfo.bus_farm_debt IS NULL) AND (X_bus_farm_debt IS NULL)))
3377 AND ((tlinfo.live_on_farm = x_live_on_farm) OR ((tlinfo.live_on_farm IS NULL) AND (X_live_on_farm IS NULL)))
3378 AND ((tlinfo.home_purch_price = x_home_purch_price) OR ((tlinfo.home_purch_price IS NULL) AND (X_home_purch_price IS NULL)))
3379 AND ((tlinfo.hope_ll_credit = x_hope_ll_credit) OR ((tlinfo.hope_ll_credit IS NULL) AND (X_hope_ll_credit IS NULL)))
3380 AND ((tlinfo.home_purch_year = x_home_purch_year) OR ((tlinfo.home_purch_year IS NULL) AND (X_home_purch_year IS NULL)))
3381 AND ((tlinfo.trust_amount = x_trust_amount) OR ((tlinfo.trust_amount IS NULL) AND (X_trust_amount IS NULL)))
3382 AND ((tlinfo.trust_avail = x_trust_avail) OR ((tlinfo.trust_avail IS NULL) AND (X_trust_avail IS NULL)))
3383 AND ((tlinfo.trust_estab = x_trust_estab) OR ((tlinfo.trust_estab IS NULL) AND (X_trust_estab IS NULL)))
3384 AND ((tlinfo.child_support_paid = x_child_support_paid) OR ((tlinfo.child_support_paid IS NULL) AND (X_child_support_paid IS NULL)))
3385 AND ((tlinfo.med_dent_expenses = x_med_dent_expenses) OR ((tlinfo.med_dent_expenses IS NULL) AND (X_med_dent_expenses IS NULL)))
3386 AND ((tlinfo.vet_us = x_vet_us) OR ((tlinfo.vet_us IS NULL) AND (X_vet_us IS NULL)))
3387 AND ((tlinfo.vet_ben_amount = x_vet_ben_amount) OR ((tlinfo.vet_ben_amount IS NULL) AND (X_vet_ben_amount IS NULL)))
3388 AND ((tlinfo.vet_ben_months = x_vet_ben_months) OR ((tlinfo.vet_ben_months IS NULL) AND (X_vet_ben_months IS NULL)))
3389 AND ((tlinfo.stu_summer_wages = x_stu_summer_wages) OR ((tlinfo.stu_summer_wages IS NULL) AND (X_stu_summer_wages IS NULL)))
3390 AND ((tlinfo.stu_school_yr_wages = x_stu_school_yr_wages) OR ((tlinfo.stu_school_yr_wages IS NULL) AND (X_stu_school_yr_wages IS NULL)))
3391 AND ((tlinfo.spouse_summer_wages = x_spouse_summer_wages) OR ((tlinfo.spouse_summer_wages IS NULL) AND (X_spouse_summer_wages IS NULL)))
3392 AND ((tlinfo.spouse_school_yr_wages = x_spouse_school_yr_wages) OR ((tlinfo.spouse_school_yr_wages IS NULL) AND (X_spouse_school_yr_wages IS NULL)))
3393 AND ((tlinfo.summer_other_tax_inc = x_summer_other_tax_inc) OR ((tlinfo.summer_other_tax_inc IS NULL) AND (X_summer_other_tax_inc IS NULL)))
3394 AND ((tlinfo.school_yr_other_tax_inc = x_school_yr_other_tax_inc) OR ((tlinfo.school_yr_other_tax_inc IS NULL) AND (X_school_yr_other_tax_inc IS NULL)))
3395 AND ((tlinfo.summer_untax_inc = x_summer_untax_inc) OR ((tlinfo.summer_untax_inc IS NULL) AND (X_summer_untax_inc IS NULL)))
3396 AND ((tlinfo.school_yr_untax_inc = x_school_yr_untax_inc) OR ((tlinfo.school_yr_untax_inc IS NULL) AND (X_school_yr_untax_inc IS NULL)))
3397 AND ((tlinfo.grants_schol_etc = x_grants_schol_etc) OR ((tlinfo.grants_schol_etc IS NULL) AND (X_grants_schol_etc IS NULL)))
3398 AND ((tlinfo.tuit_benefits = x_tuit_benefits) OR ((tlinfo.tuit_benefits IS NULL) AND (X_tuit_benefits IS NULL)))
3399 AND ((tlinfo.cont_parents = x_cont_parents) OR ((tlinfo.cont_parents IS NULL) AND (X_cont_parents IS NULL)))
3400 AND ((tlinfo.cont_relatives = x_cont_relatives) OR ((tlinfo.cont_relatives IS NULL) AND (X_cont_relatives IS NULL)))
3401 AND ((tlinfo.p_siblings_pre_tuit = x_p_siblings_pre_tuit) OR ((tlinfo.p_siblings_pre_tuit IS NULL) AND (X_p_siblings_pre_tuit IS NULL)))
3402 AND ((tlinfo.p_student_pre_tuit = x_p_student_pre_tuit) OR ((tlinfo.p_student_pre_tuit IS NULL) AND (X_p_student_pre_tuit IS NULL)))
3403 AND ((tlinfo.p_household_size = x_p_household_size) OR ((tlinfo.p_household_size IS NULL) AND (X_p_household_size IS NULL)))
3404 AND ((tlinfo.p_number_in_college = x_p_number_in_college) OR ((tlinfo.p_number_in_college IS NULL) AND (X_p_number_in_college IS NULL)))
3408 AND ((tlinfo.p_natural_par_status = x_p_natural_par_status) OR ((tlinfo.p_natural_par_status IS NULL) AND (X_p_natural_par_status IS NULL)))
3405 AND ((tlinfo.p_parents_in_college = x_p_parents_in_college) OR ((tlinfo.p_parents_in_college IS NULL) AND (X_p_parents_in_college IS NULL)))
3406 AND ((tlinfo.p_marital_status = x_p_marital_status) OR ((tlinfo.p_marital_status IS NULL) AND (X_p_marital_status IS NULL)))
3407 AND ((tlinfo.p_state_legal_residence = x_p_state_legal_residence) OR ((tlinfo.p_state_legal_residence IS NULL) AND (X_p_state_legal_residence IS NULL)))
3409 AND ((tlinfo.p_child_supp_paid = x_p_child_supp_paid) OR ((tlinfo.p_child_supp_paid IS NULL) AND (X_p_child_supp_paid IS NULL)))
3410 AND ((tlinfo.p_repay_ed_loans = x_p_repay_ed_loans) OR ((tlinfo.p_repay_ed_loans IS NULL) AND (X_p_repay_ed_loans IS NULL)))
3411 AND ((tlinfo.p_med_dent_expenses = x_p_med_dent_expenses) OR ((tlinfo.p_med_dent_expenses IS NULL) AND (X_p_med_dent_expenses IS NULL)))
3412 AND ((tlinfo.p_tuit_paid_amount = x_p_tuit_paid_amount) OR ((tlinfo.p_tuit_paid_amount IS NULL) AND (X_p_tuit_paid_amount IS NULL)))
3413 AND ((tlinfo.p_tuit_paid_number = x_p_tuit_paid_number) OR ((tlinfo.p_tuit_paid_number IS NULL) AND (X_p_tuit_paid_number IS NULL)))
3414 AND ((tlinfo.p_exp_child_supp_paid = x_p_exp_child_supp_paid) OR ((tlinfo.p_exp_child_supp_paid IS NULL) AND (X_p_exp_child_supp_paid IS NULL)))
3415 AND ((tlinfo.p_exp_repay_ed_loans = x_p_exp_repay_ed_loans) OR ((tlinfo.p_exp_repay_ed_loans IS NULL) AND (X_p_exp_repay_ed_loans IS NULL)))
3416 AND ((tlinfo.p_exp_med_dent_expenses = x_p_exp_med_dent_expenses) OR ((tlinfo.p_exp_med_dent_expenses IS NULL) AND (X_p_exp_med_dent_expenses IS NULL)))
3417 AND ((tlinfo.p_exp_tuit_pd_amount = x_p_exp_tuit_pd_amount) OR ((tlinfo.p_exp_tuit_pd_amount IS NULL) AND (X_p_exp_tuit_pd_amount IS NULL)))
3418 AND ((tlinfo.p_exp_tuit_pd_number = x_p_exp_tuit_pd_number) OR ((tlinfo.p_exp_tuit_pd_number IS NULL) AND (X_p_exp_tuit_pd_number IS NULL)))
3419 AND ((tlinfo.p_cash_sav_check = x_p_cash_sav_check) OR ((tlinfo.p_cash_sav_check IS NULL) AND (X_p_cash_sav_check IS NULL)))
3420 AND ((tlinfo.p_month_mortgage_pay = x_p_month_mortgage_pay) OR ((tlinfo.p_month_mortgage_pay IS NULL) AND (X_p_month_mortgage_pay IS NULL)))
3421 AND ((tlinfo.p_invest_value = x_p_invest_value) OR ((tlinfo.p_invest_value IS NULL) AND (X_p_invest_value IS NULL)))
3422 AND ((tlinfo.p_invest_debt = x_p_invest_debt) OR ((tlinfo.p_invest_debt IS NULL) AND (X_p_invest_debt IS NULL)))
3423 AND ((tlinfo.p_home_value = x_p_home_value) OR ((tlinfo.p_home_value IS NULL) AND (X_p_home_value IS NULL)))
3424 AND ((tlinfo.p_home_debt = x_p_home_debt) OR ((tlinfo.p_home_debt IS NULL) AND (X_p_home_debt IS NULL)))
3425 AND ((tlinfo.p_home_purch_price = x_p_home_purch_price) OR ((tlinfo.p_home_purch_price IS NULL) AND (X_p_home_purch_price IS NULL)))
3426 AND ((tlinfo.p_own_business_farm = x_p_own_business_farm) OR ((tlinfo.p_own_business_farm IS NULL) AND (X_p_own_business_farm IS NULL)))
3427 AND ((tlinfo.p_business_value = x_p_business_value) OR ((tlinfo.p_business_value IS NULL) AND (X_p_business_value IS NULL)))
3428 AND ((tlinfo.p_business_debt = x_p_business_debt) OR ((tlinfo.p_business_debt IS NULL) AND (X_p_business_debt IS NULL)))
3429 AND ((tlinfo.p_farm_value = x_p_farm_value) OR ((tlinfo.p_farm_value IS NULL) AND (X_p_farm_value IS NULL)))
3430 AND ((tlinfo.p_farm_debt = x_p_farm_debt) OR ((tlinfo.p_farm_debt IS NULL) AND (X_p_farm_debt IS NULL)))
3431 AND ((tlinfo.p_live_on_farm = x_p_live_on_farm) OR ((tlinfo.p_live_on_farm IS NULL) AND (X_p_live_on_farm IS NULL)))
3432 AND ((tlinfo.p_oth_real_estate_value = x_p_oth_real_estate_value) OR ((tlinfo.p_oth_real_estate_value IS NULL) AND (X_p_oth_real_estate_value IS NULL)))
3433 AND ((tlinfo.p_oth_real_estate_debt = x_p_oth_real_estate_debt) OR ((tlinfo.p_oth_real_estate_debt IS NULL) AND (X_p_oth_real_estate_debt IS NULL)))
3434 AND ((tlinfo.p_oth_real_purch_price = x_p_oth_real_purch_price) OR ((tlinfo.p_oth_real_purch_price IS NULL) AND (X_p_oth_real_purch_price IS NULL)))
3435 AND ((tlinfo.p_siblings_assets = x_p_siblings_assets) OR ((tlinfo.p_siblings_assets IS NULL) AND (X_p_siblings_assets IS NULL)))
3436 AND ((tlinfo.p_home_purch_year = x_p_home_purch_year) OR ((tlinfo.p_home_purch_year IS NULL) AND (X_p_home_purch_year IS NULL)))
3437 AND ((tlinfo.p_oth_real_purch_year = x_p_oth_real_purch_year) OR ((tlinfo.p_oth_real_purch_year IS NULL) AND (X_p_oth_real_purch_year IS NULL)))
3438 AND ((tlinfo.p_prior_agi = x_p_prior_agi) OR ((tlinfo.p_prior_agi IS NULL) AND (X_p_prior_agi IS NULL)))
3439 AND ((tlinfo.p_prior_us_tax_paid = x_p_prior_us_tax_paid) OR ((tlinfo.p_prior_us_tax_paid IS NULL) AND (X_p_prior_us_tax_paid IS NULL)))
3440 AND ((tlinfo.p_prior_item_deductions = x_p_prior_item_deductions) OR ((tlinfo.p_prior_item_deductions IS NULL) AND (X_p_prior_item_deductions IS NULL)))
3441 AND ((tlinfo.p_prior_other_untax_inc = x_p_prior_other_untax_inc) OR ((tlinfo.p_prior_other_untax_inc IS NULL) AND (X_p_prior_other_untax_inc IS NULL)))
3442 AND ((tlinfo.p_tax_figures = x_p_tax_figures) OR ((tlinfo.p_tax_figures IS NULL) AND (X_p_tax_figures IS NULL)))
3443 AND ((tlinfo.p_number_exemptions = x_p_number_exemptions) OR ((tlinfo.p_number_exemptions IS NULL) AND (X_p_number_exemptions IS NULL)))
3444 AND ((tlinfo.p_adjusted_gross_inc = x_p_adjusted_gross_inc) OR ((tlinfo.p_adjusted_gross_inc IS NULL) AND (X_p_adjusted_gross_inc IS NULL)))
3445 AND ((tlinfo.p_wages_sal_tips = x_p_wages_sal_tips) OR ((tlinfo.p_wages_sal_tips IS NULL) AND (X_p_wages_sal_tips IS NULL)))
3446 AND ((tlinfo.p_interest_income = x_p_interest_income) OR ((tlinfo.p_interest_income IS NULL) AND (X_p_interest_income IS NULL)))
3450 AND ((tlinfo.p_adj_to_income = x_p_adj_to_income) OR ((tlinfo.p_adj_to_income IS NULL) AND (X_p_adj_to_income IS NULL)))
3447 AND ((tlinfo.p_dividend_income = x_p_dividend_income) OR ((tlinfo.p_dividend_income IS NULL) AND (X_p_dividend_income IS NULL)))
3448 AND ((tlinfo.p_net_inc_bus_farm = x_p_net_inc_bus_farm) OR ((tlinfo.p_net_inc_bus_farm IS NULL) AND (X_p_net_inc_bus_farm IS NULL)))
3449 AND ((tlinfo.p_other_taxable_income = x_p_other_taxable_income) OR ((tlinfo.p_other_taxable_income IS NULL) AND (X_p_other_taxable_income IS NULL)))
3451 AND ((tlinfo.p_us_tax_paid = x_p_us_tax_paid) OR ((tlinfo.p_us_tax_paid IS NULL) AND (X_p_us_tax_paid IS NULL)))
3452 AND ((tlinfo.p_itemized_deductions = x_p_itemized_deductions) OR ((tlinfo.p_itemized_deductions IS NULL) AND (X_p_itemized_deductions IS NULL)))
3453 AND ((tlinfo.p_father_income_work = x_p_father_income_work) OR ((tlinfo.p_father_income_work IS NULL) AND (X_p_father_income_work IS NULL)))
3454 AND ((tlinfo.p_mother_income_work = x_p_mother_income_work) OR ((tlinfo.p_mother_income_work IS NULL) AND (X_p_mother_income_work IS NULL)))
3455 AND ((tlinfo.p_soc_sec_ben = x_p_soc_sec_ben) OR ((tlinfo.p_soc_sec_ben IS NULL) AND (X_p_soc_sec_ben IS NULL)))
3456 AND ((tlinfo.p_welfare_tanf = x_p_welfare_tanf) OR ((tlinfo.p_welfare_tanf IS NULL) AND (X_p_welfare_tanf IS NULL)))
3457 AND ((tlinfo.p_child_supp_rcvd = x_p_child_supp_rcvd) OR ((tlinfo.p_child_supp_rcvd IS NULL) AND (X_p_child_supp_rcvd IS NULL)))
3458 AND ((tlinfo.p_ded_ira_keogh = x_p_ded_ira_keogh) OR ((tlinfo.p_ded_ira_keogh IS NULL) AND (X_p_ded_ira_keogh IS NULL)))
3459 AND ((tlinfo.p_tax_defer_pens_savs = x_p_tax_defer_pens_savs) OR ((tlinfo.p_tax_defer_pens_savs IS NULL) AND (X_p_tax_defer_pens_savs IS NULL)))
3460 AND ((tlinfo.p_dep_care_med_spending = x_p_dep_care_med_spending) OR ((tlinfo.p_dep_care_med_spending IS NULL) AND (X_p_dep_care_med_spending IS NULL)))
3461 AND ((tlinfo.p_earned_income_credit = x_p_earned_income_credit) OR ((tlinfo.p_earned_income_credit IS NULL) AND (X_p_earned_income_credit IS NULL)))
3462 AND ((tlinfo.p_living_allow = x_p_living_allow) OR ((tlinfo.p_living_allow IS NULL) AND (X_p_living_allow IS NULL)))
3463 AND ((tlinfo.p_tax_exmpt_int = x_p_tax_exmpt_int) OR ((tlinfo.p_tax_exmpt_int IS NULL) AND (X_p_tax_exmpt_int IS NULL)))
3464 AND ((tlinfo.p_foreign_inc_excl = x_p_foreign_inc_excl) OR ((tlinfo.p_foreign_inc_excl IS NULL) AND (X_p_foreign_inc_excl IS NULL)))
3465 AND ((tlinfo.p_other_untax_inc = x_p_other_untax_inc) OR ((tlinfo.p_other_untax_inc IS NULL) AND (X_p_other_untax_inc IS NULL)))
3466 AND ((tlinfo.p_hope_ll_credit = x_p_hope_ll_credit) OR ((tlinfo.p_hope_ll_credit IS NULL) AND (X_p_hope_ll_credit IS NULL)))
3467 AND ((tlinfo.p_yr_separation = x_p_yr_separation) OR ((tlinfo.p_yr_separation IS NULL) AND (X_p_yr_separation IS NULL)))
3468 AND ((tlinfo.p_yr_divorce = x_p_yr_divorce) OR ((tlinfo.p_yr_divorce IS NULL) AND (X_p_yr_divorce IS NULL)))
3469 AND ((tlinfo.p_exp_father_inc = x_p_exp_father_inc) OR ((tlinfo.p_exp_father_inc IS NULL) AND (X_p_exp_father_inc IS NULL)))
3470 AND ((tlinfo.p_exp_mother_inc = x_p_exp_mother_inc) OR ((tlinfo.p_exp_mother_inc IS NULL) AND (X_p_exp_mother_inc IS NULL)))
3471 AND ((tlinfo.p_exp_other_tax_inc = x_p_exp_other_tax_inc) OR ((tlinfo.p_exp_other_tax_inc IS NULL) AND (X_p_exp_other_tax_inc IS NULL)))
3472 AND ((tlinfo.p_exp_other_untax_inc = x_p_exp_other_untax_inc) OR ((tlinfo.p_exp_other_untax_inc IS NULL) AND (X_p_exp_other_untax_inc IS NULL)))
3473 AND ((tlinfo.line_2_relation = x_line_2_relation) OR ((tlinfo.line_2_relation IS NULL) AND (X_line_2_relation IS NULL)))
3474 AND ((tlinfo.line_2_attend_college = x_line_2_attend_college) OR ((tlinfo.line_2_attend_college IS NULL) AND (X_line_2_attend_college IS NULL)))
3475 AND ((tlinfo.line_3_relation = x_line_3_relation) OR ((tlinfo.line_3_relation IS NULL) AND (X_line_3_relation IS NULL)))
3476 AND ((tlinfo.line_3_attend_college = x_line_3_attend_college) OR ((tlinfo.line_3_attend_college IS NULL) AND (X_line_3_attend_college IS NULL)))
3477 AND ((tlinfo.line_4_relation = x_line_4_relation) OR ((tlinfo.line_4_relation IS NULL) AND (X_line_4_relation IS NULL)))
3478 AND ((tlinfo.line_4_attend_college = x_line_4_attend_college) OR ((tlinfo.line_4_attend_college IS NULL) AND (X_line_4_attend_college IS NULL)))
3479 AND ((tlinfo.line_5_relation = x_line_5_relation) OR ((tlinfo.line_5_relation IS NULL) AND (X_line_5_relation IS NULL)))
3480 AND ((tlinfo.line_5_attend_college = x_line_5_attend_college) OR ((tlinfo.line_5_attend_college IS NULL) AND (X_line_5_attend_college IS NULL)))
3481 AND ((tlinfo.line_6_relation = x_line_6_relation) OR ((tlinfo.line_6_relation IS NULL) AND (X_line_6_relation IS NULL)))
3482 AND ((tlinfo.line_6_attend_college = x_line_6_attend_college) OR ((tlinfo.line_6_attend_college IS NULL) AND (X_line_6_attend_college IS NULL)))
3483 AND ((tlinfo.line_7_relation = x_line_7_relation) OR ((tlinfo.line_7_relation IS NULL) AND (X_line_7_relation IS NULL)))
3484 AND ((tlinfo.line_7_attend_college = x_line_7_attend_college) OR ((tlinfo.line_7_attend_college IS NULL) AND (X_line_7_attend_college IS NULL)))
3485 AND ((tlinfo.line_8_relation = x_line_8_relation) OR ((tlinfo.line_8_relation IS NULL) AND (X_line_8_relation IS NULL)))
3486 AND ((tlinfo.line_8_attend_college = x_line_8_attend_college) OR ((tlinfo.line_8_attend_college IS NULL) AND (X_line_8_attend_college IS NULL)))
3487 AND ((tlinfo.p_age_father = x_p_age_father) OR ((tlinfo.p_age_father IS NULL) AND (X_p_age_father IS NULL)))
3488 AND ((tlinfo.p_age_mother = x_p_age_mother) OR ((tlinfo.p_age_mother IS NULL) AND (X_p_age_mother IS NULL)))
3489 AND ((tlinfo.p_div_sep_ind = x_p_div_sep_ind) OR ((tlinfo.p_div_sep_ind IS NULL) AND (X_p_div_sep_ind IS NULL)))
3490 AND ((tlinfo.b_cont_non_custodial_par = x_b_cont_non_custodial_par) OR ((tlinfo.b_cont_non_custodial_par IS NULL) AND (X_b_cont_non_custodial_par IS NULL)))
3491 AND ((tlinfo.college_type_2 = x_college_type_2) OR ((tlinfo.college_type_2 IS NULL) AND (X_college_type_2 IS NULL)))
3495 AND ((tlinfo.college_type_6 = x_college_type_6) OR ((tlinfo.college_type_6 IS NULL) AND (X_college_type_6 IS NULL)))
3492 AND ((tlinfo.college_type_3 = x_college_type_3) OR ((tlinfo.college_type_3 IS NULL) AND (X_college_type_3 IS NULL)))
3493 AND ((tlinfo.college_type_4 = x_college_type_4) OR ((tlinfo.college_type_4 IS NULL) AND (X_college_type_4 IS NULL)))
3494 AND ((tlinfo.college_type_5 = x_college_type_5) OR ((tlinfo.college_type_5 IS NULL) AND (X_college_type_5 IS NULL)))
3496 AND ((tlinfo.college_type_7 = x_college_type_7) OR ((tlinfo.college_type_7 IS NULL) AND (X_college_type_7 IS NULL)))
3497 AND ((tlinfo.college_type_8 = x_college_type_8) OR ((tlinfo.college_type_8 IS NULL) AND (X_college_type_8 IS NULL)))
3498 AND ((tlinfo.school_code_1 = x_school_code_1) OR ((tlinfo.school_code_1 IS NULL) AND (X_school_code_1 IS NULL)))
3499 AND ((tlinfo.housing_code_1 = x_housing_code_1) OR ((tlinfo.housing_code_1 IS NULL) AND (X_housing_code_1 IS NULL)))
3500 AND ((tlinfo.school_code_2 = x_school_code_2) OR ((tlinfo.school_code_2 IS NULL) AND (X_school_code_2 IS NULL)))
3501 AND ((tlinfo.housing_code_2 = x_housing_code_2) OR ((tlinfo.housing_code_2 IS NULL) AND (X_housing_code_2 IS NULL)))
3502 AND ((tlinfo.school_code_3 = x_school_code_3) OR ((tlinfo.school_code_3 IS NULL) AND (X_school_code_3 IS NULL)))
3503 AND ((tlinfo.housing_code_3 = x_housing_code_3) OR ((tlinfo.housing_code_3 IS NULL) AND (X_housing_code_3 IS NULL)))
3504 AND ((tlinfo.school_code_4 = x_school_code_4) OR ((tlinfo.school_code_4 IS NULL) AND (X_school_code_4 IS NULL)))
3505 AND ((tlinfo.housing_code_4 = x_housing_code_4) OR ((tlinfo.housing_code_4 IS NULL) AND (X_housing_code_4 IS NULL)))
3506 AND ((tlinfo.school_code_5 = x_school_code_5) OR ((tlinfo.school_code_5 IS NULL) AND (X_school_code_5 IS NULL)))
3507 AND ((tlinfo.housing_code_5 = x_housing_code_5) OR ((tlinfo.housing_code_5 IS NULL) AND (X_housing_code_5 IS NULL)))
3508 AND ((tlinfo.school_code_6 = x_school_code_6) OR ((tlinfo.school_code_6 IS NULL) AND (X_school_code_6 IS NULL)))
3509 AND ((tlinfo.housing_code_6 = x_housing_code_6) OR ((tlinfo.housing_code_6 IS NULL) AND (X_housing_code_6 IS NULL)))
3510 AND ((tlinfo.school_code_7 = x_school_code_7) OR ((tlinfo.school_code_7 IS NULL) AND (X_school_code_7 IS NULL)))
3511 AND ((tlinfo.housing_code_7 = x_housing_code_7) OR ((tlinfo.housing_code_7 IS NULL) AND (X_housing_code_7 IS NULL)))
3512 AND ((tlinfo.school_code_8 = x_school_code_8) OR ((tlinfo.school_code_8 IS NULL) AND (X_school_code_8 IS NULL)))
3513 AND ((tlinfo.housing_code_8 = x_housing_code_8) OR ((tlinfo.housing_code_8 IS NULL) AND (X_housing_code_8 IS NULL)))
3514 AND ((tlinfo.school_code_9 = x_school_code_9) OR ((tlinfo.school_code_9 IS NULL) AND (X_school_code_9 IS NULL)))
3515 AND ((tlinfo.housing_code_9 = x_housing_code_9) OR ((tlinfo.housing_code_9 IS NULL) AND (X_housing_code_9 IS NULL)))
3516 AND ((tlinfo.school_code_10 = x_school_code_10) OR ((tlinfo.school_code_10 IS NULL) AND (X_school_code_10 IS NULL)))
3517 AND ((tlinfo.housing_code_10 = x_housing_code_10) OR ((tlinfo.housing_code_10 IS NULL) AND (X_housing_code_10 IS NULL)))
3518 AND ((tlinfo.additional_school_code_1 = x_additional_school_code_1) OR ((tlinfo.additional_school_code_1 IS NULL) AND (X_additional_school_code_1 IS NULL)))
3519 AND ((tlinfo.additional_school_code_2 = x_additional_school_code_2) OR ((tlinfo.additional_school_code_2 IS NULL) AND (X_additional_school_code_2 IS NULL)))
3520 AND ((tlinfo.additional_school_code_3 = x_additional_school_code_3) OR ((tlinfo.additional_school_code_3 IS NULL) AND (X_additional_school_code_3 IS NULL)))
3521 AND ((tlinfo.additional_school_code_4 = x_additional_school_code_4) OR ((tlinfo.additional_school_code_4 IS NULL) AND (X_additional_school_code_4 IS NULL)))
3522 AND ((tlinfo.additional_school_code_5 = x_additional_school_code_5) OR ((tlinfo.additional_school_code_5 IS NULL) AND (X_additional_school_code_5 IS NULL)))
3523 AND ((tlinfo.additional_school_code_6 = x_additional_school_code_6) OR ((tlinfo.additional_school_code_6 IS NULL) AND (X_additional_school_code_6 IS NULL)))
3524 AND ((tlinfo.additional_school_code_7 = x_additional_school_code_7) OR ((tlinfo.additional_school_code_7 IS NULL) AND (X_additional_school_code_7 IS NULL)))
3525 AND ((tlinfo.additional_school_code_8 = x_additional_school_code_8) OR ((tlinfo.additional_school_code_8 IS NULL) AND (X_additional_school_code_8 IS NULL)))
3526 AND ((tlinfo.additional_school_code_9 = x_additional_school_code_9) OR ((tlinfo.additional_school_code_9 IS NULL) AND (X_additional_school_code_9 IS NULL)))
3527 AND ((tlinfo.additional_school_code_10 = x_additional_school_code_10) OR ((tlinfo.additional_school_code_10 IS NULL) AND (X_additional_school_code_10 IS NULL)))
3528 AND ((tlinfo.explanation_spec_circum = x_explanation_spec_circum) OR ((tlinfo.explanation_spec_circum IS NULL) AND (X_explanation_spec_circum IS NULL)))
3529 AND ((tlinfo.signature_student = x_signature_student) OR ((tlinfo.signature_student IS NULL) AND (X_signature_student IS NULL)))
3530 AND ((tlinfo.signature_spouse = x_signature_spouse) OR ((tlinfo.signature_spouse IS NULL) AND (X_signature_spouse IS NULL)))
3531 AND ((tlinfo.signature_father = x_signature_father) OR ((tlinfo.signature_father IS NULL) AND (X_signature_father IS NULL)))
3532 AND ((tlinfo.signature_mother = x_signature_mother) OR ((tlinfo.signature_mother IS NULL) AND (X_signature_mother IS NULL)))
3533 AND ((tlinfo.month_day_completed = x_month_day_completed) OR ((tlinfo.month_day_completed IS NULL) AND (X_month_day_completed IS NULL)))
3534 AND ((tlinfo.year_completed = x_year_completed) OR ((tlinfo.year_completed IS NULL) AND (X_year_completed IS NULL)))
3535 AND ((tlinfo.age_line_2 = x_age_line_2) OR ((tlinfo.age_line_2 IS NULL) AND (X_age_line_2 IS NULL)))
3536 AND ((tlinfo.age_line_3 = x_age_line_3) OR ((tlinfo.age_line_3 IS NULL) AND (X_age_line_3 IS NULL)))
3537 AND ((tlinfo.age_line_4 = x_age_line_4) OR ((tlinfo.age_line_4 IS NULL) AND (X_age_line_4 IS NULL)))
3541 AND ((tlinfo.age_line_8 = x_age_line_8) OR ((tlinfo.age_line_8 IS NULL) AND (X_age_line_8 IS NULL)))
3538 AND ((tlinfo.age_line_5 = x_age_line_5) OR ((tlinfo.age_line_5 IS NULL) AND (X_age_line_5 IS NULL)))
3539 AND ((tlinfo.age_line_6 = x_age_line_6) OR ((tlinfo.age_line_6 IS NULL) AND (X_age_line_6 IS NULL)))
3540 AND ((tlinfo.age_line_7 = x_age_line_7) OR ((tlinfo.age_line_7 IS NULL) AND (X_age_line_7 IS NULL)))
3542 AND ((tlinfo.a_online_signature = x_a_online_signature) OR ((tlinfo.a_online_signature IS NULL) AND (X_a_online_signature IS NULL)))
3543 AND ((tlinfo.question_1_number = x_question_1_number) OR ((tlinfo.question_1_number IS NULL) AND (X_question_1_number IS NULL)))
3544 AND ((tlinfo.question_1_size = x_question_1_size) OR ((tlinfo.question_1_size IS NULL) AND (X_question_1_size IS NULL)))
3545 AND ((tlinfo.question_1_answer = x_question_1_answer) OR ((tlinfo.question_1_answer IS NULL) AND (X_question_1_answer IS NULL)))
3546 AND ((tlinfo.question_2_number = x_question_2_number) OR ((tlinfo.question_2_number IS NULL) AND (X_question_2_number IS NULL)))
3547 AND ((tlinfo.question_2_size = x_question_2_size) OR ((tlinfo.question_2_size IS NULL) AND (X_question_2_size IS NULL)))
3548 AND ((tlinfo.question_2_answer = x_question_2_answer) OR ((tlinfo.question_2_answer IS NULL) AND (X_question_2_answer IS NULL)))
3549 AND ((tlinfo.question_3_number = x_question_3_number) OR ((tlinfo.question_3_number IS NULL) AND (X_question_3_number IS NULL)))
3550 AND ((tlinfo.question_3_size = x_question_3_size) OR ((tlinfo.question_3_size IS NULL) AND (X_question_3_size IS NULL)))
3551 AND ((tlinfo.question_3_answer = x_question_3_answer) OR ((tlinfo.question_3_answer IS NULL) AND (X_question_3_answer IS NULL)))
3552 AND ((tlinfo.question_4_number = x_question_4_number) OR ((tlinfo.question_4_number IS NULL) AND (X_question_4_number IS NULL)))
3553 AND ((tlinfo.question_4_size = x_question_4_size) OR ((tlinfo.question_4_size IS NULL) AND (X_question_4_size IS NULL)))
3554 AND ((tlinfo.question_4_answer = x_question_4_answer) OR ((tlinfo.question_4_answer IS NULL) AND (X_question_4_answer IS NULL)))
3555 AND ((tlinfo.question_5_number = x_question_5_number) OR ((tlinfo.question_5_number IS NULL) AND (X_question_5_number IS NULL)))
3556 AND ((tlinfo.question_5_size = x_question_5_size) OR ((tlinfo.question_5_size IS NULL) AND (X_question_5_size IS NULL)))
3557 AND ((tlinfo.question_5_answer = x_question_5_answer) OR ((tlinfo.question_5_answer IS NULL) AND (X_question_5_answer IS NULL)))
3558 AND ((tlinfo.question_6_number = x_question_6_number) OR ((tlinfo.question_6_number IS NULL) AND (X_question_6_number IS NULL)))
3559 AND ((tlinfo.question_6_size = x_question_6_size) OR ((tlinfo.question_6_size IS NULL) AND (X_question_6_size IS NULL)))
3560 AND ((tlinfo.question_6_answer = x_question_6_answer) OR ((tlinfo.question_6_answer IS NULL) AND (X_question_6_answer IS NULL)))
3561 AND ((tlinfo.question_7_number = x_question_7_number) OR ((tlinfo.question_7_number IS NULL) AND (X_question_7_number IS NULL)))
3562 AND ((tlinfo.question_7_size = x_question_7_size) OR ((tlinfo.question_7_size IS NULL) AND (X_question_7_size IS NULL)))
3563 AND ((tlinfo.question_7_answer = x_question_7_answer) OR ((tlinfo.question_7_answer IS NULL) AND (X_question_7_answer IS NULL)))
3564 AND ((tlinfo.question_8_number = x_question_8_number) OR ((tlinfo.question_8_number IS NULL) AND (X_question_8_number IS NULL)))
3565 AND ((tlinfo.question_8_size = x_question_8_size) OR ((tlinfo.question_8_size IS NULL) AND (X_question_8_size IS NULL)))
3566 AND ((tlinfo.question_8_answer = x_question_8_answer) OR ((tlinfo.question_8_answer IS NULL) AND (X_question_8_answer IS NULL)))
3567 AND ((tlinfo.question_9_number = x_question_9_number) OR ((tlinfo.question_9_number IS NULL) AND (X_question_9_number IS NULL)))
3568 AND ((tlinfo.question_9_size = x_question_9_size) OR ((tlinfo.question_9_size IS NULL) AND (X_question_9_size IS NULL)))
3569 AND ((tlinfo.question_9_answer = x_question_9_answer) OR ((tlinfo.question_9_answer IS NULL) AND (X_question_9_answer IS NULL)))
3570 AND ((tlinfo.question_10_number = x_question_10_number) OR ((tlinfo.question_10_number IS NULL) AND (X_question_10_number IS NULL)))
3571 AND ((tlinfo.question_10_size = x_question_10_size) OR ((tlinfo.question_10_size IS NULL) AND (X_question_10_size IS NULL)))
3572 AND ((tlinfo.question_10_answer = x_question_10_answer) OR ((tlinfo.question_10_answer IS NULL) AND (X_question_10_answer IS NULL)))
3573 AND ((tlinfo.question_11_number = x_question_11_number) OR ((tlinfo.question_11_number IS NULL) AND (X_question_11_number IS NULL)))
3574 AND ((tlinfo.question_11_size = x_question_11_size) OR ((tlinfo.question_11_size IS NULL) AND (X_question_11_size IS NULL)))
3575 AND ((tlinfo.question_11_answer = x_question_11_answer) OR ((tlinfo.question_11_answer IS NULL) AND (X_question_11_answer IS NULL)))
3576 AND ((tlinfo.question_12_number = x_question_12_number) OR ((tlinfo.question_12_number IS NULL) AND (X_question_12_number IS NULL)))
3577 AND ((tlinfo.question_12_size = x_question_12_size) OR ((tlinfo.question_12_size IS NULL) AND (X_question_12_size IS NULL)))
3578 AND ((tlinfo.question_12_answer = x_question_12_answer) OR ((tlinfo.question_12_answer IS NULL) AND (X_question_12_answer IS NULL)))
3579 AND ((tlinfo.question_13_number = x_question_13_number) OR ((tlinfo.question_13_number IS NULL) AND (X_question_13_number IS NULL)))
3580 AND ((tlinfo.question_13_size = x_question_13_size) OR ((tlinfo.question_13_size IS NULL) AND (X_question_13_size IS NULL)))
3581 AND ((tlinfo.question_13_answer = x_question_13_answer) OR ((tlinfo.question_13_answer IS NULL) AND (X_question_13_answer IS NULL)))
3582 AND ((tlinfo.question_14_number = x_question_14_number) OR ((tlinfo.question_14_number IS NULL) AND (X_question_14_number IS NULL)))
3583 AND ((tlinfo.question_14_size = x_question_14_size) OR ((tlinfo.question_14_size IS NULL) AND (X_question_14_size IS NULL)))
3587 AND ((tlinfo.question_15_answer = x_question_15_answer) OR ((tlinfo.question_15_answer IS NULL) AND (X_question_15_answer IS NULL)))
3584 AND ((tlinfo.question_14_answer = x_question_14_answer) OR ((tlinfo.question_14_answer IS NULL) AND (X_question_14_answer IS NULL)))
3585 AND ((tlinfo.question_15_number = x_question_15_number) OR ((tlinfo.question_15_number IS NULL) AND (X_question_15_number IS NULL)))
3586 AND ((tlinfo.question_15_size = x_question_15_size) OR ((tlinfo.question_15_size IS NULL) AND (X_question_15_size IS NULL)))
3588 AND ((tlinfo.question_16_number = x_question_16_number) OR ((tlinfo.question_16_number IS NULL) AND (X_question_16_number IS NULL)))
3589 AND ((tlinfo.question_16_size = x_question_16_size) OR ((tlinfo.question_16_size IS NULL) AND (X_question_16_size IS NULL)))
3590 AND ((tlinfo.question_16_answer = x_question_16_answer) OR ((tlinfo.question_16_answer IS NULL) AND (X_question_16_answer IS NULL)))
3591 AND ((tlinfo.question_17_number = x_question_17_number) OR ((tlinfo.question_17_number IS NULL) AND (X_question_17_number IS NULL)))
3592 AND ((tlinfo.question_17_size = x_question_17_size) OR ((tlinfo.question_17_size IS NULL) AND (X_question_17_size IS NULL)))
3593 AND ((tlinfo.question_17_answer = x_question_17_answer) OR ((tlinfo.question_17_answer IS NULL) AND (X_question_17_answer IS NULL)))
3594 AND ((tlinfo.question_18_number = x_question_18_number) OR ((tlinfo.question_18_number IS NULL) AND (X_question_18_number IS NULL)))
3595 AND ((tlinfo.question_18_size = x_question_18_size) OR ((tlinfo.question_18_size IS NULL) AND (X_question_18_size IS NULL)))
3596 AND ((tlinfo.question_18_answer = x_question_18_answer) OR ((tlinfo.question_18_answer IS NULL) AND (X_question_18_answer IS NULL)))
3597 AND ((tlinfo.question_19_number = x_question_19_number) OR ((tlinfo.question_19_number IS NULL) AND (X_question_19_number IS NULL)))
3598 AND ((tlinfo.question_19_size = x_question_19_size) OR ((tlinfo.question_19_size IS NULL) AND (X_question_19_size IS NULL)))
3599 AND ((tlinfo.question_19_answer = x_question_19_answer) OR ((tlinfo.question_19_answer IS NULL) AND (X_question_19_answer IS NULL)))
3600 AND ((tlinfo.question_20_number = x_question_20_number) OR ((tlinfo.question_20_number IS NULL) AND (X_question_20_number IS NULL)))
3601 AND ((tlinfo.question_20_size = x_question_20_size) OR ((tlinfo.question_20_size IS NULL) AND (X_question_20_size IS NULL)))
3602 AND ((tlinfo.question_20_answer = x_question_20_answer) OR ((tlinfo.question_20_answer IS NULL) AND (X_question_20_answer IS NULL)))
3603 AND ((tlinfo.question_21_number = x_question_21_number) OR ((tlinfo.question_21_number IS NULL) AND (X_question_21_number IS NULL)))
3604 AND ((tlinfo.question_21_size = x_question_21_size) OR ((tlinfo.question_21_size IS NULL) AND (X_question_21_size IS NULL)))
3605 AND ((tlinfo.question_21_answer = x_question_21_answer) OR ((tlinfo.question_21_answer IS NULL) AND (X_question_21_answer IS NULL)))
3606 AND ((tlinfo.question_22_number = x_question_22_number) OR ((tlinfo.question_22_number IS NULL) AND (X_question_22_number IS NULL)))
3607 AND ((tlinfo.question_22_size = x_question_22_size) OR ((tlinfo.question_22_size IS NULL) AND (X_question_22_size IS NULL)))
3608 AND ((tlinfo.question_22_answer = x_question_22_answer) OR ((tlinfo.question_22_answer IS NULL) AND (X_question_22_answer IS NULL)))
3609 AND ((tlinfo.question_23_number = x_question_23_number) OR ((tlinfo.question_23_number IS NULL) AND (X_question_23_number IS NULL)))
3610 AND ((tlinfo.question_23_size = x_question_23_size) OR ((tlinfo.question_23_size IS NULL) AND (X_question_23_size IS NULL)))
3611 AND ((tlinfo.question_23_answer = x_question_23_answer) OR ((tlinfo.question_23_answer IS NULL) AND (X_question_23_answer IS NULL)))
3612 AND ((tlinfo.question_24_number = x_question_24_number) OR ((tlinfo.question_24_number IS NULL) AND (X_question_24_number IS NULL)))
3613 AND ((tlinfo.question_24_size = x_question_24_size) OR ((tlinfo.question_24_size IS NULL) AND (X_question_24_size IS NULL)))
3614 AND ((tlinfo.question_24_answer = x_question_24_answer) OR ((tlinfo.question_24_answer IS NULL) AND (X_question_24_answer IS NULL)))
3615 AND ((tlinfo.question_25_number = x_question_25_number) OR ((tlinfo.question_25_number IS NULL) AND (X_question_25_number IS NULL)))
3616 AND ((tlinfo.question_25_size = x_question_25_size) OR ((tlinfo.question_25_size IS NULL) AND (X_question_25_size IS NULL)))
3617 AND ((tlinfo.question_25_answer = x_question_25_answer) OR ((tlinfo.question_25_answer IS NULL) AND (X_question_25_answer IS NULL)))
3618 AND ((tlinfo.question_26_number = x_question_26_number) OR ((tlinfo.question_26_number IS NULL) AND (X_question_26_number IS NULL)))
3619 AND ((tlinfo.question_26_size = x_question_26_size) OR ((tlinfo.question_26_size IS NULL) AND (X_question_26_size IS NULL)))
3620 AND ((tlinfo.question_26_answer = x_question_26_answer) OR ((tlinfo.question_26_answer IS NULL) AND (X_question_26_answer IS NULL)))
3621 AND ((tlinfo.question_27_number = x_question_27_number) OR ((tlinfo.question_27_number IS NULL) AND (X_question_27_number IS NULL)))
3622 AND ((tlinfo.question_27_size = x_question_27_size) OR ((tlinfo.question_27_size IS NULL) AND (X_question_27_size IS NULL)))
3623 AND ((tlinfo.question_27_answer = x_question_27_answer) OR ((tlinfo.question_27_answer IS NULL) AND (X_question_27_answer IS NULL)))
3624 AND ((tlinfo.question_28_number = x_question_28_number) OR ((tlinfo.question_28_number IS NULL) AND (X_question_28_number IS NULL)))
3625 AND ((tlinfo.question_28_size = x_question_28_size) OR ((tlinfo.question_28_size IS NULL) AND (X_question_28_size IS NULL)))
3626 AND ((tlinfo.question_28_answer = x_question_28_answer) OR ((tlinfo.question_28_answer IS NULL) AND (X_question_28_answer IS NULL)))
3627 AND ((tlinfo.question_29_number = x_question_29_number) OR ((tlinfo.question_29_number IS NULL) AND (X_question_29_number IS NULL)))
3631 AND ((tlinfo.questions_30_size = x_questions_30_size) OR ((tlinfo.questions_30_size IS NULL) AND (X_questions_30_size IS NULL)))
3628 AND ((tlinfo.question_29_size = x_question_29_size) OR ((tlinfo.question_29_size IS NULL) AND (X_question_29_size IS NULL)))
3629 AND ((tlinfo.question_29_answer = x_question_29_answer) OR ((tlinfo.question_29_answer IS NULL) AND (X_question_29_answer IS NULL)))
3630 AND ((tlinfo.question_30_number = x_question_30_number) OR ((tlinfo.question_30_number IS NULL) AND (X_question_30_number IS NULL)))
3632 AND ((tlinfo.question_30_answer = x_question_30_answer) OR ((tlinfo.question_30_answer IS NULL) AND (X_question_30_answer IS NULL)))
3633 ) THEN
3634 NULL;
3635 ELSE
3636 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
3637 igs_ge_msg_stack.add;
3638 app_exception.raise_exception;
3639 END IF;
3640
3641 RETURN;
3642
3643 END lock_row;
3644
3645
3646 PROCEDURE update_row (
3647 x_rowid IN VARCHAR2,
3648 x_base_id IN NUMBER,
3649 x_last_name IN VARCHAR2,
3650 x_first_name IN VARCHAR2,
3651 x_middle_initial IN VARCHAR2,
3652 x_address_number_and_street IN VARCHAR2,
3653 x_city IN VARCHAR2,
3654 x_state_mailing IN VARCHAR2,
3655 x_zip_code IN VARCHAR2,
3656 x_s_telephone_number IN VARCHAR2,
3657 x_s_title IN VARCHAR2,
3658 x_date_of_birth IN VARCHAR2,
3659 x_social_security_number IN VARCHAR2,
3660 x_state_legal_residence IN VARCHAR2,
3661 x_foreign_address_indicator IN VARCHAR2,
3662 x_foreign_postal_code IN VARCHAR2,
3663 x_country IN VARCHAR2,
3664 x_financial_aid_status IN VARCHAR2,
3665 x_year_in_college IN VARCHAR2,
3666 x_marital_status IN VARCHAR2,
3667 x_ward_court IN VARCHAR2,
3668 x_legal_dependents_other IN VARCHAR2,
3669 x_household_size IN VARCHAR2,
3670 x_number_in_college IN VARCHAR2,
3671 x_citizenship_status IN VARCHAR2,
3672 x_citizenship_country IN VARCHAR2,
3673 x_visa_classification IN VARCHAR2,
3674 x_tax_figures IN VARCHAR2,
3675 x_number_exemptions IN VARCHAR2,
3676 x_adjusted_gross_inc IN VARCHAR2,
3677 x_us_tax_paid IN VARCHAR2,
3678 x_itemized_deductions IN VARCHAR2,
3679 x_stu_income_work IN VARCHAR2,
3680 x_spouse_income_work IN VARCHAR2,
3681 x_divid_int_inc IN VARCHAR2,
3682 x_soc_sec_benefits IN VARCHAR2,
3683 x_welfare_tanf IN VARCHAR2,
3684 x_child_supp_rcvd IN VARCHAR2,
3685 x_earned_income_credit IN VARCHAR2,
3686 x_other_untax_income IN VARCHAR2,
3687 x_tax_stu_aid IN VARCHAR2,
3688 x_cash_sav_check IN VARCHAR2,
3689 x_ira_keogh IN VARCHAR2,
3690 x_invest_value IN VARCHAR2,
3691 x_invest_debt IN VARCHAR2,
3692 x_home_value IN VARCHAR2,
3693 x_home_debt IN VARCHAR2,
3694 x_oth_real_value IN VARCHAR2,
3695 x_oth_real_debt IN VARCHAR2,
3696 x_bus_farm_value IN VARCHAR2,
3697 x_bus_farm_debt IN VARCHAR2,
3698 x_live_on_farm IN VARCHAR2,
3699 x_home_purch_price IN VARCHAR2,
3700 x_hope_ll_credit IN VARCHAR2,
3701 x_home_purch_year IN VARCHAR2,
3702 x_trust_amount IN VARCHAR2,
3703 x_trust_avail IN VARCHAR2,
3704 x_trust_estab IN VARCHAR2,
3705 x_child_support_paid IN VARCHAR2,
3706 x_med_dent_expenses IN VARCHAR2,
3707 x_vet_us IN VARCHAR2,
3708 x_vet_ben_amount IN VARCHAR2,
3709 x_vet_ben_months IN VARCHAR2,
3710 x_stu_summer_wages IN VARCHAR2,
3711 x_stu_school_yr_wages IN VARCHAR2,
3712 x_spouse_summer_wages IN VARCHAR2,
3713 x_spouse_school_yr_wages IN VARCHAR2,
3714 x_summer_other_tax_inc IN VARCHAR2,
3715 x_school_yr_other_tax_inc IN VARCHAR2,
3716 x_summer_untax_inc IN VARCHAR2,
3717 x_school_yr_untax_inc IN VARCHAR2,
3718 x_grants_schol_etc IN VARCHAR2,
3719 x_tuit_benefits IN VARCHAR2,
3720 x_cont_parents IN VARCHAR2,
3721 x_cont_relatives IN VARCHAR2,
3722 x_p_siblings_pre_tuit IN VARCHAR2,
3723 x_p_student_pre_tuit IN VARCHAR2,
3724 x_p_household_size IN VARCHAR2,
3725 x_p_number_in_college IN VARCHAR2,
3729 x_p_natural_par_status IN VARCHAR2,
3726 x_p_parents_in_college IN VARCHAR2,
3727 x_p_marital_status IN VARCHAR2,
3728 x_p_state_legal_residence IN VARCHAR2,
3730 x_p_child_supp_paid IN VARCHAR2,
3731 x_p_repay_ed_loans IN VARCHAR2,
3732 x_p_med_dent_expenses IN VARCHAR2,
3733 x_p_tuit_paid_amount IN VARCHAR2,
3734 x_p_tuit_paid_number IN VARCHAR2,
3735 x_p_exp_child_supp_paid IN VARCHAR2,
3736 x_p_exp_repay_ed_loans IN VARCHAR2,
3737 x_p_exp_med_dent_expenses IN VARCHAR2,
3738 x_p_exp_tuit_pd_amount IN VARCHAR2,
3739 x_p_exp_tuit_pd_number IN VARCHAR2,
3740 x_p_cash_sav_check IN VARCHAR2,
3741 x_p_month_mortgage_pay IN VARCHAR2,
3742 x_p_invest_value IN VARCHAR2,
3743 x_p_invest_debt IN VARCHAR2,
3744 x_p_home_value IN VARCHAR2,
3745 x_p_home_debt IN VARCHAR2,
3746 x_p_home_purch_price IN VARCHAR2,
3747 x_p_own_business_farm IN VARCHAR2,
3748 x_p_business_value IN VARCHAR2,
3749 x_p_business_debt IN VARCHAR2,
3750 x_p_farm_value IN VARCHAR2,
3751 x_p_farm_debt IN VARCHAR2,
3752 x_p_live_on_farm IN VARCHAR2,
3753 x_p_oth_real_estate_value IN VARCHAR2,
3754 x_p_oth_real_estate_debt IN VARCHAR2,
3755 x_p_oth_real_purch_price IN VARCHAR2,
3756 x_p_siblings_assets IN VARCHAR2,
3757 x_p_home_purch_year IN VARCHAR2,
3758 x_p_oth_real_purch_year IN VARCHAR2,
3759 x_p_prior_agi IN VARCHAR2,
3760 x_p_prior_us_tax_paid IN VARCHAR2,
3761 x_p_prior_item_deductions IN VARCHAR2,
3762 x_p_prior_other_untax_inc IN VARCHAR2,
3763 x_p_tax_figures IN VARCHAR2,
3764 x_p_number_exemptions IN VARCHAR2,
3765 x_p_adjusted_gross_inc IN VARCHAR2,
3766 x_p_wages_sal_tips IN VARCHAR2,
3767 x_p_interest_income IN VARCHAR2,
3768 x_p_dividend_income IN VARCHAR2,
3769 x_p_net_inc_bus_farm IN VARCHAR2,
3770 x_p_other_taxable_income IN VARCHAR2,
3771 x_p_adj_to_income IN VARCHAR2,
3772 x_p_us_tax_paid IN VARCHAR2,
3773 x_p_itemized_deductions IN VARCHAR2,
3774 x_p_father_income_work IN VARCHAR2,
3775 x_p_mother_income_work IN VARCHAR2,
3776 x_p_soc_sec_ben IN VARCHAR2,
3777 x_p_welfare_tanf IN VARCHAR2,
3778 x_p_child_supp_rcvd IN VARCHAR2,
3779 x_p_ded_ira_keogh IN VARCHAR2,
3780 x_p_tax_defer_pens_savs IN VARCHAR2,
3781 x_p_dep_care_med_spending IN VARCHAR2,
3782 x_p_earned_income_credit IN VARCHAR2,
3783 x_p_living_allow IN VARCHAR2,
3784 x_p_tax_exmpt_int IN VARCHAR2,
3785 x_p_foreign_inc_excl IN VARCHAR2,
3786 x_p_other_untax_inc IN VARCHAR2,
3787 x_p_hope_ll_credit IN VARCHAR2,
3788 x_p_yr_separation IN VARCHAR2,
3789 x_p_yr_divorce IN VARCHAR2,
3790 x_p_exp_father_inc IN VARCHAR2,
3791 x_p_exp_mother_inc IN VARCHAR2,
3792 x_p_exp_other_tax_inc IN VARCHAR2,
3793 x_p_exp_other_untax_inc IN VARCHAR2,
3794 x_line_2_relation IN VARCHAR2,
3795 x_line_2_attend_college IN VARCHAR2,
3796 x_line_3_relation IN VARCHAR2,
3797 x_line_3_attend_college IN VARCHAR2,
3798 x_line_4_relation IN VARCHAR2,
3799 x_line_4_attend_college IN VARCHAR2,
3800 x_line_5_relation IN VARCHAR2,
3801 x_line_5_attend_college IN VARCHAR2,
3802 x_line_6_relation IN VARCHAR2,
3803 x_line_6_attend_college IN VARCHAR2,
3804 x_line_7_relation IN VARCHAR2,
3805 x_line_7_attend_college IN VARCHAR2,
3806 x_line_8_relation IN VARCHAR2,
3807 x_line_8_attend_college IN VARCHAR2,
3808 x_p_age_father IN VARCHAR2,
3809 x_p_age_mother IN VARCHAR2,
3810 x_p_div_sep_ind IN VARCHAR2,
3811 x_b_cont_non_custodial_par IN VARCHAR2,
3812 x_college_type_2 IN VARCHAR2,
3813 x_college_type_3 IN VARCHAR2,
3814 x_college_type_4 IN VARCHAR2,
3815 x_college_type_5 IN VARCHAR2,
3816 x_college_type_6 IN VARCHAR2,
3817 x_college_type_7 IN VARCHAR2,
3818 x_college_type_8 IN VARCHAR2,
3819 x_school_code_1 IN VARCHAR2,
3820 x_housing_code_1 IN VARCHAR2,
3821 x_school_code_2 IN VARCHAR2,
3825 x_school_code_4 IN VARCHAR2,
3822 x_housing_code_2 IN VARCHAR2,
3823 x_school_code_3 IN VARCHAR2,
3824 x_housing_code_3 IN VARCHAR2,
3826 x_housing_code_4 IN VARCHAR2,
3827 x_school_code_5 IN VARCHAR2,
3828 x_housing_code_5 IN VARCHAR2,
3829 x_school_code_6 IN VARCHAR2,
3830 x_housing_code_6 IN VARCHAR2,
3831 x_school_code_7 IN VARCHAR2,
3832 x_housing_code_7 IN VARCHAR2,
3833 x_school_code_8 IN VARCHAR2,
3834 x_housing_code_8 IN VARCHAR2,
3835 x_school_code_9 IN VARCHAR2,
3836 x_housing_code_9 IN VARCHAR2,
3837 x_school_code_10 IN VARCHAR2,
3838 x_housing_code_10 IN VARCHAR2,
3839 x_additional_school_code_1 IN VARCHAR2,
3840 x_additional_school_code_2 IN VARCHAR2,
3841 x_additional_school_code_3 IN VARCHAR2,
3842 x_additional_school_code_4 IN VARCHAR2,
3843 x_additional_school_code_5 IN VARCHAR2,
3844 x_additional_school_code_6 IN VARCHAR2,
3845 x_additional_school_code_7 IN VARCHAR2,
3846 x_additional_school_code_8 IN VARCHAR2,
3847 x_additional_school_code_9 IN VARCHAR2,
3848 x_additional_school_code_10 IN VARCHAR2,
3849 x_explanation_spec_circum IN VARCHAR2,
3850 x_signature_student IN VARCHAR2,
3851 x_signature_spouse IN VARCHAR2,
3852 x_signature_father IN VARCHAR2,
3853 x_signature_mother IN VARCHAR2,
3854 x_month_day_completed IN VARCHAR2,
3855 x_year_completed IN VARCHAR2,
3856 x_age_line_2 IN VARCHAR2,
3857 x_age_line_3 IN VARCHAR2,
3858 x_age_line_4 IN VARCHAR2,
3859 x_age_line_5 IN VARCHAR2,
3860 x_age_line_6 IN VARCHAR2,
3861 x_age_line_7 IN VARCHAR2,
3862 x_age_line_8 IN VARCHAR2,
3863 x_a_online_signature IN VARCHAR2,
3864 x_question_1_number IN VARCHAR2,
3865 x_question_1_size IN VARCHAR2,
3866 x_question_1_answer IN VARCHAR2,
3867 x_question_2_number IN VARCHAR2,
3868 x_question_2_size IN VARCHAR2,
3869 x_question_2_answer IN VARCHAR2,
3870 x_question_3_number IN VARCHAR2,
3871 x_question_3_size IN VARCHAR2,
3872 x_question_3_answer IN VARCHAR2,
3873 x_question_4_number IN VARCHAR2,
3874 x_question_4_size IN VARCHAR2,
3875 x_question_4_answer IN VARCHAR2,
3876 x_question_5_number IN VARCHAR2,
3877 x_question_5_size IN VARCHAR2,
3878 x_question_5_answer IN VARCHAR2,
3879 x_question_6_number IN VARCHAR2,
3880 x_question_6_size IN VARCHAR2,
3881 x_question_6_answer IN VARCHAR2,
3882 x_question_7_number IN VARCHAR2,
3883 x_question_7_size IN VARCHAR2,
3884 x_question_7_answer IN VARCHAR2,
3885 x_question_8_number IN VARCHAR2,
3886 x_question_8_size IN VARCHAR2,
3887 x_question_8_answer IN VARCHAR2,
3888 x_question_9_number IN VARCHAR2,
3889 x_question_9_size IN VARCHAR2,
3890 x_question_9_answer IN VARCHAR2,
3891 x_question_10_number IN VARCHAR2,
3892 x_question_10_size IN VARCHAR2,
3893 x_question_10_answer IN VARCHAR2,
3894 x_question_11_number IN VARCHAR2,
3895 x_question_11_size IN VARCHAR2,
3896 x_question_11_answer IN VARCHAR2,
3897 x_question_12_number IN VARCHAR2,
3898 x_question_12_size IN VARCHAR2,
3899 x_question_12_answer IN VARCHAR2,
3900 x_question_13_number IN VARCHAR2,
3901 x_question_13_size IN VARCHAR2,
3902 x_question_13_answer IN VARCHAR2,
3903 x_question_14_number IN VARCHAR2,
3904 x_question_14_size IN VARCHAR2,
3905 x_question_14_answer IN VARCHAR2,
3906 x_question_15_number IN VARCHAR2,
3907 x_question_15_size IN VARCHAR2,
3908 x_question_15_answer IN VARCHAR2,
3909 x_question_16_number IN VARCHAR2,
3910 x_question_16_size IN VARCHAR2,
3911 x_question_16_answer IN VARCHAR2,
3912 x_question_17_number IN VARCHAR2,
3913 x_question_17_size IN VARCHAR2,
3914 x_question_17_answer IN VARCHAR2,
3915 x_question_18_number IN VARCHAR2,
3916 x_question_18_size IN VARCHAR2,
3917 x_question_18_answer IN VARCHAR2,
3921 x_question_20_number IN VARCHAR2,
3918 x_question_19_number IN VARCHAR2,
3919 x_question_19_size IN VARCHAR2,
3920 x_question_19_answer IN VARCHAR2,
3922 x_question_20_size IN VARCHAR2,
3923 x_question_20_answer IN VARCHAR2,
3924 x_question_21_number IN VARCHAR2,
3925 x_question_21_size IN VARCHAR2,
3926 x_question_21_answer IN VARCHAR2,
3927 x_question_22_number IN VARCHAR2,
3928 x_question_22_size IN VARCHAR2,
3929 x_question_22_answer IN VARCHAR2,
3930 x_question_23_number IN VARCHAR2,
3931 x_question_23_size IN VARCHAR2,
3932 x_question_23_answer IN VARCHAR2,
3933 x_question_24_number IN VARCHAR2,
3934 x_question_24_size IN VARCHAR2,
3935 x_question_24_answer IN VARCHAR2,
3936 x_question_25_number IN VARCHAR2,
3937 x_question_25_size IN VARCHAR2,
3938 x_question_25_answer IN VARCHAR2,
3939 x_question_26_number IN VARCHAR2,
3940 x_question_26_size IN VARCHAR2,
3941 x_question_26_answer IN VARCHAR2,
3942 x_question_27_number IN VARCHAR2,
3943 x_question_27_size IN VARCHAR2,
3944 x_question_27_answer IN VARCHAR2,
3945 x_question_28_number IN VARCHAR2,
3946 x_question_28_size IN VARCHAR2,
3947 x_question_28_answer IN VARCHAR2,
3948 x_question_29_number IN VARCHAR2,
3949 x_question_29_size IN VARCHAR2,
3950 x_question_29_answer IN VARCHAR2,
3951 x_question_30_number IN VARCHAR2,
3952 x_questions_30_size IN VARCHAR2,
3953 x_question_30_answer IN VARCHAR2,
3954 x_mode IN VARCHAR2 DEFAULT 'R'
3955 ) AS
3956 /*
3957 || Created By : kkillams
3958 || Created On : 30-MAY-2001
3959 || Purpose : Handles the UPDATE DML logic for the table.
3960 || Known limitations, enhancements or remarks :
3961 || Change History :
3962 || Who When What
3963 || (reverse chronological order - newest change first)
3964 */
3965 x_last_update_date DATE ;
3966 x_last_updated_by NUMBER;
3967 x_last_update_login NUMBER;
3968
3969 BEGIN
3970
3971 x_last_update_date := SYSDATE;
3972 IF (X_MODE = 'I') THEN
3973 x_last_updated_by := 1;
3974 x_last_update_login := 0;
3975 ELSIF (x_mode = 'R') THEN
3976 x_last_updated_by := fnd_global.user_id;
3977 IF x_last_updated_by IS NULL THEN
3978 x_last_updated_by := -1;
3979 END IF;
3980 x_last_update_login := fnd_global.login_id;
3981 IF (x_last_update_login IS NULL) THEN
3982 x_last_update_login := -1;
3983 END IF;
3984 ELSE
3985 fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
3986 igs_ge_msg_stack.add;
3987 app_exception.raise_exception;
3988 END IF;
3989
3990 before_dml(
3991 p_action => 'UPDATE',
3992 x_rowid => x_rowid,
3993 x_base_id => x_base_id,
3994 x_last_name => x_last_name,
3995 x_first_name => x_first_name,
3996 x_middle_initial => x_middle_initial,
3997 x_address_number_and_street => x_address_number_and_street,
3998 x_city => x_city,
3999 x_state_mailing => x_state_mailing,
4000 x_zip_code => x_zip_code,
4001 x_s_telephone_number => x_s_telephone_number,
4002 x_s_title => x_s_title,
4003 x_date_of_birth => x_date_of_birth,
4004 x_social_security_number => x_social_security_number,
4005 x_state_legal_residence => x_state_legal_residence,
4006 x_foreign_address_indicator => x_foreign_address_indicator,
4007 x_foreign_postal_code => x_foreign_postal_code,
4008 x_country => x_country,
4009 x_financial_aid_status => x_financial_aid_status,
4010 x_year_in_college => x_year_in_college,
4011 x_marital_status => x_marital_status,
4012 x_ward_court => x_ward_court,
4013 x_legal_dependents_other => x_legal_dependents_other,
4014 x_household_size => x_household_size,
4015 x_number_in_college => x_number_in_college,
4016 x_citizenship_status => x_citizenship_status,
4017 x_citizenship_country => x_citizenship_country,
4018 x_visa_classification => x_visa_classification,
4019 x_tax_figures => x_tax_figures,
4020 x_number_exemptions => x_number_exemptions,
4021 x_adjusted_gross_inc => x_adjusted_gross_inc,
4022 x_us_tax_paid => x_us_tax_paid,
4023 x_itemized_deductions => x_itemized_deductions,
4024 x_stu_income_work => x_stu_income_work,
4028 x_welfare_tanf => x_welfare_tanf,
4025 x_spouse_income_work => x_spouse_income_work,
4026 x_divid_int_inc => x_divid_int_inc,
4027 x_soc_sec_benefits => x_soc_sec_benefits,
4029 x_child_supp_rcvd => x_child_supp_rcvd,
4030 x_earned_income_credit => x_earned_income_credit,
4031 x_other_untax_income => x_other_untax_income,
4032 x_tax_stu_aid => x_tax_stu_aid,
4033 x_cash_sav_check => x_cash_sav_check,
4034 x_ira_keogh => x_ira_keogh,
4035 x_invest_value => x_invest_value,
4036 x_invest_debt => x_invest_debt,
4037 x_home_value => x_home_value,
4038 x_home_debt => x_home_debt,
4039 x_oth_real_value => x_oth_real_value,
4040 x_oth_real_debt => x_oth_real_debt,
4041 x_bus_farm_value => x_bus_farm_value,
4042 x_bus_farm_debt => x_bus_farm_debt,
4043 x_live_on_farm => x_live_on_farm,
4044 x_home_purch_price => x_home_purch_price,
4045 x_hope_ll_credit => x_hope_ll_credit,
4046 x_home_purch_year => x_home_purch_year,
4047 x_trust_amount => x_trust_amount,
4048 x_trust_avail => x_trust_avail,
4049 x_trust_estab => x_trust_estab,
4050 x_child_support_paid => x_child_support_paid,
4051 x_med_dent_expenses => x_med_dent_expenses,
4052 x_vet_us => x_vet_us,
4053 x_vet_ben_amount => x_vet_ben_amount,
4054 x_vet_ben_months => x_vet_ben_months,
4055 x_stu_summer_wages => x_stu_summer_wages,
4056 x_stu_school_yr_wages => x_stu_school_yr_wages,
4057 x_spouse_summer_wages => x_spouse_summer_wages,
4058 x_spouse_school_yr_wages => x_spouse_school_yr_wages,
4059 x_summer_other_tax_inc => x_summer_other_tax_inc,
4060 x_school_yr_other_tax_inc => x_school_yr_other_tax_inc,
4061 x_summer_untax_inc => x_summer_untax_inc,
4062 x_school_yr_untax_inc => x_school_yr_untax_inc,
4063 x_grants_schol_etc => x_grants_schol_etc,
4064 x_tuit_benefits => x_tuit_benefits,
4065 x_cont_parents => x_cont_parents,
4066 x_cont_relatives => x_cont_relatives,
4067 x_p_siblings_pre_tuit => x_p_siblings_pre_tuit,
4068 x_p_student_pre_tuit => x_p_student_pre_tuit,
4069 x_p_household_size => x_p_household_size,
4070 x_p_number_in_college => x_p_number_in_college,
4071 x_p_parents_in_college => x_p_parents_in_college,
4072 x_p_marital_status => x_p_marital_status,
4073 x_p_state_legal_residence => x_p_state_legal_residence,
4074 x_p_natural_par_status => x_p_natural_par_status,
4075 x_p_child_supp_paid => x_p_child_supp_paid,
4076 x_p_repay_ed_loans => x_p_repay_ed_loans,
4077 x_p_med_dent_expenses => x_p_med_dent_expenses,
4078 x_p_tuit_paid_amount => x_p_tuit_paid_amount,
4079 x_p_tuit_paid_number => x_p_tuit_paid_number,
4080 x_p_exp_child_supp_paid => x_p_exp_child_supp_paid,
4081 x_p_exp_repay_ed_loans => x_p_exp_repay_ed_loans,
4082 x_p_exp_med_dent_expenses => x_p_exp_med_dent_expenses,
4083 x_p_exp_tuit_pd_amount => x_p_exp_tuit_pd_amount,
4084 x_p_exp_tuit_pd_number => x_p_exp_tuit_pd_number,
4085 x_p_cash_sav_check => x_p_cash_sav_check,
4086 x_p_month_mortgage_pay => x_p_month_mortgage_pay,
4087 x_p_invest_value => x_p_invest_value,
4088 x_p_invest_debt => x_p_invest_debt,
4089 x_p_home_value => x_p_home_value,
4090 x_p_home_debt => x_p_home_debt,
4091 x_p_home_purch_price => x_p_home_purch_price,
4092 x_p_own_business_farm => x_p_own_business_farm,
4093 x_p_business_value => x_p_business_value,
4094 x_p_business_debt => x_p_business_debt,
4095 x_p_farm_value => x_p_farm_value,
4096 x_p_farm_debt => x_p_farm_debt,
4097 x_p_live_on_farm => x_p_live_on_farm,
4098 x_p_oth_real_estate_value => x_p_oth_real_estate_value,
4099 x_p_oth_real_estate_debt => x_p_oth_real_estate_debt,
4100 x_p_oth_real_purch_price => x_p_oth_real_purch_price,
4101 x_p_siblings_assets => x_p_siblings_assets,
4102 x_p_home_purch_year => x_p_home_purch_year,
4103 x_p_oth_real_purch_year => x_p_oth_real_purch_year,
4104 x_p_prior_agi => x_p_prior_agi,
4105 x_p_prior_us_tax_paid => x_p_prior_us_tax_paid,
4106 x_p_prior_item_deductions => x_p_prior_item_deductions,
4107 x_p_prior_other_untax_inc => x_p_prior_other_untax_inc,
4108 x_p_tax_figures => x_p_tax_figures,
4109 x_p_number_exemptions => x_p_number_exemptions,
4110 x_p_adjusted_gross_inc => x_p_adjusted_gross_inc,
4114 x_p_net_inc_bus_farm => x_p_net_inc_bus_farm,
4111 x_p_wages_sal_tips => x_p_wages_sal_tips,
4112 x_p_interest_income => x_p_interest_income,
4113 x_p_dividend_income => x_p_dividend_income,
4115 x_p_other_taxable_income => x_p_other_taxable_income,
4116 x_p_adj_to_income => x_p_adj_to_income,
4117 x_p_us_tax_paid => x_p_us_tax_paid,
4118 x_p_itemized_deductions => x_p_itemized_deductions,
4119 x_p_father_income_work => x_p_father_income_work,
4120 x_p_mother_income_work => x_p_mother_income_work,
4121 x_p_soc_sec_ben => x_p_soc_sec_ben,
4122 x_p_welfare_tanf => x_p_welfare_tanf,
4123 x_p_child_supp_rcvd => x_p_child_supp_rcvd,
4124 x_p_ded_ira_keogh => x_p_ded_ira_keogh,
4125 x_p_tax_defer_pens_savs => x_p_tax_defer_pens_savs,
4126 x_p_dep_care_med_spending => x_p_dep_care_med_spending,
4127 x_p_earned_income_credit => x_p_earned_income_credit,
4128 x_p_living_allow => x_p_living_allow,
4129 x_p_tax_exmpt_int => x_p_tax_exmpt_int,
4130 x_p_foreign_inc_excl => x_p_foreign_inc_excl,
4131 x_p_other_untax_inc => x_p_other_untax_inc,
4132 x_p_hope_ll_credit => x_p_hope_ll_credit,
4133 x_p_yr_separation => x_p_yr_separation,
4134 x_p_yr_divorce => x_p_yr_divorce,
4135 x_p_exp_father_inc => x_p_exp_father_inc,
4136 x_p_exp_mother_inc => x_p_exp_mother_inc,
4137 x_p_exp_other_tax_inc => x_p_exp_other_tax_inc,
4138 x_p_exp_other_untax_inc => x_p_exp_other_untax_inc,
4139 x_line_2_relation => x_line_2_relation,
4140 x_line_2_attend_college => x_line_2_attend_college,
4141 x_line_3_relation => x_line_3_relation,
4142 x_line_3_attend_college => x_line_3_attend_college,
4143 x_line_4_relation => x_line_4_relation,
4144 x_line_4_attend_college => x_line_4_attend_college,
4145 x_line_5_relation => x_line_5_relation,
4146 x_line_5_attend_college => x_line_5_attend_college,
4147 x_line_6_relation => x_line_6_relation,
4148 x_line_6_attend_college => x_line_6_attend_college,
4149 x_line_7_relation => x_line_7_relation,
4150 x_line_7_attend_college => x_line_7_attend_college,
4151 x_line_8_relation => x_line_8_relation,
4152 x_line_8_attend_college => x_line_8_attend_college,
4153 x_p_age_father => x_p_age_father,
4154 x_p_age_mother => x_p_age_mother,
4155 x_p_div_sep_ind => x_p_div_sep_ind,
4156 x_b_cont_non_custodial_par => x_b_cont_non_custodial_par,
4157 x_college_type_2 => x_college_type_2,
4158 x_college_type_3 => x_college_type_3,
4159 x_college_type_4 => x_college_type_4,
4160 x_college_type_5 => x_college_type_5,
4161 x_college_type_6 => x_college_type_6,
4162 x_college_type_7 => x_college_type_7,
4163 x_college_type_8 => x_college_type_8,
4164 x_school_code_1 => x_school_code_1,
4165 x_housing_code_1 => x_housing_code_1,
4166 x_school_code_2 => x_school_code_2,
4167 x_housing_code_2 => x_housing_code_2,
4168 x_school_code_3 => x_school_code_3,
4169 x_housing_code_3 => x_housing_code_3,
4170 x_school_code_4 => x_school_code_4,
4171 x_housing_code_4 => x_housing_code_4,
4172 x_school_code_5 => x_school_code_5,
4173 x_housing_code_5 => x_housing_code_5,
4174 x_school_code_6 => x_school_code_6,
4175 x_housing_code_6 => x_housing_code_6,
4176 x_school_code_7 => x_school_code_7,
4177 x_housing_code_7 => x_housing_code_7,
4178 x_school_code_8 => x_school_code_8,
4179 x_housing_code_8 => x_housing_code_8,
4180 x_school_code_9 => x_school_code_9,
4181 x_housing_code_9 => x_housing_code_9,
4182 x_school_code_10 => x_school_code_10,
4183 x_housing_code_10 => x_housing_code_10,
4184 x_additional_school_code_1 => x_additional_school_code_1,
4185 x_additional_school_code_2 => x_additional_school_code_2,
4186 x_additional_school_code_3 => x_additional_school_code_3,
4187 x_additional_school_code_4 => x_additional_school_code_4,
4188 x_additional_school_code_5 => x_additional_school_code_5,
4189 x_additional_school_code_6 => x_additional_school_code_6,
4190 x_additional_school_code_7 => x_additional_school_code_7,
4191 x_additional_school_code_8 => x_additional_school_code_8,
4192 x_additional_school_code_9 => x_additional_school_code_9,
4193 x_additional_school_code_10 => x_additional_school_code_10,
4194 x_explanation_spec_circum => x_explanation_spec_circum,
4195 x_signature_student => x_signature_student,
4199 x_month_day_completed => x_month_day_completed,
4196 x_signature_spouse => x_signature_spouse,
4197 x_signature_father => x_signature_father,
4198 x_signature_mother => x_signature_mother,
4200 x_year_completed => x_year_completed,
4201 x_age_line_2 => x_age_line_2,
4202 x_age_line_3 => x_age_line_3,
4203 x_age_line_4 => x_age_line_4,
4204 x_age_line_5 => x_age_line_5,
4205 x_age_line_6 => x_age_line_6,
4206 x_age_line_7 => x_age_line_7,
4207 x_age_line_8 => x_age_line_8,
4208 x_a_online_signature => x_a_online_signature,
4209 x_question_1_number => x_question_1_number,
4210 x_question_1_size => x_question_1_size,
4211 x_question_1_answer => x_question_1_answer,
4212 x_question_2_number => x_question_2_number,
4213 x_question_2_size => x_question_2_size,
4214 x_question_2_answer => x_question_2_answer,
4215 x_question_3_number => x_question_3_number,
4216 x_question_3_size => x_question_3_size,
4217 x_question_3_answer => x_question_3_answer,
4218 x_question_4_number => x_question_4_number,
4219 x_question_4_size => x_question_4_size,
4220 x_question_4_answer => x_question_4_answer,
4221 x_question_5_number => x_question_5_number,
4222 x_question_5_size => x_question_5_size,
4223 x_question_5_answer => x_question_5_answer,
4224 x_question_6_number => x_question_6_number,
4225 x_question_6_size => x_question_6_size,
4226 x_question_6_answer => x_question_6_answer,
4227 x_question_7_number => x_question_7_number,
4228 x_question_7_size => x_question_7_size,
4229 x_question_7_answer => x_question_7_answer,
4230 x_question_8_number => x_question_8_number,
4231 x_question_8_size => x_question_8_size,
4232 x_question_8_answer => x_question_8_answer,
4233 x_question_9_number => x_question_9_number,
4234 x_question_9_size => x_question_9_size,
4235 x_question_9_answer => x_question_9_answer,
4236 x_question_10_number => x_question_10_number,
4237 x_question_10_size => x_question_10_size,
4238 x_question_10_answer => x_question_10_answer,
4239 x_question_11_number => x_question_11_number,
4240 x_question_11_size => x_question_11_size,
4241 x_question_11_answer => x_question_11_answer,
4242 x_question_12_number => x_question_12_number,
4243 x_question_12_size => x_question_12_size,
4244 x_question_12_answer => x_question_12_answer,
4245 x_question_13_number => x_question_13_number,
4246 x_question_13_size => x_question_13_size,
4247 x_question_13_answer => x_question_13_answer,
4248 x_question_14_number => x_question_14_number,
4249 x_question_14_size => x_question_14_size,
4250 x_question_14_answer => x_question_14_answer,
4251 x_question_15_number => x_question_15_number,
4252 x_question_15_size => x_question_15_size,
4253 x_question_15_answer => x_question_15_answer,
4254 x_question_16_number => x_question_16_number,
4255 x_question_16_size => x_question_16_size,
4256 x_question_16_answer => x_question_16_answer,
4257 x_question_17_number => x_question_17_number,
4258 x_question_17_size => x_question_17_size,
4259 x_question_17_answer => x_question_17_answer,
4260 x_question_18_number => x_question_18_number,
4261 x_question_18_size => x_question_18_size,
4262 x_question_18_answer => x_question_18_answer,
4263 x_question_19_number => x_question_19_number,
4264 x_question_19_size => x_question_19_size,
4265 x_question_19_answer => x_question_19_answer,
4266 x_question_20_number => x_question_20_number,
4267 x_question_20_size => x_question_20_size,
4268 x_question_20_answer => x_question_20_answer,
4269 x_question_21_number => x_question_21_number,
4270 x_question_21_size => x_question_21_size,
4271 x_question_21_answer => x_question_21_answer,
4272 x_question_22_number => x_question_22_number,
4273 x_question_22_size => x_question_22_size,
4274 x_question_22_answer => x_question_22_answer,
4275 x_question_23_number => x_question_23_number,
4276 x_question_23_size => x_question_23_size,
4277 x_question_23_answer => x_question_23_answer,
4278 x_question_24_number => x_question_24_number,
4279 x_question_24_size => x_question_24_size,
4280 x_question_24_answer => x_question_24_answer,
4281 x_question_25_number => x_question_25_number,
4285 x_question_26_size => x_question_26_size,
4282 x_question_25_size => x_question_25_size,
4283 x_question_25_answer => x_question_25_answer,
4284 x_question_26_number => x_question_26_number,
4286 x_question_26_answer => x_question_26_answer,
4287 x_question_27_number => x_question_27_number,
4288 x_question_27_size => x_question_27_size,
4289 x_question_27_answer => x_question_27_answer,
4290 x_question_28_number => x_question_28_number,
4291 x_question_28_size => x_question_28_size,
4292 x_question_28_answer => x_question_28_answer,
4293 x_question_29_number => x_question_29_number,
4294 x_question_29_size => x_question_29_size,
4295 x_question_29_answer => x_question_29_answer,
4296 x_question_30_number => x_question_30_number,
4297 x_questions_30_size => x_questions_30_size,
4298 x_question_30_answer => x_question_30_answer,
4299 x_creation_date => x_last_update_date,
4300 x_created_by => x_last_updated_by,
4301 x_last_update_date => x_last_update_date,
4302 x_last_updated_by => x_last_updated_by,
4303 x_last_update_login => x_last_update_login
4304 );
4305
4306 UPDATE igf_ap_cs_upd_flags
4307 SET
4308 last_name = new_references.last_name,
4309 first_name = new_references.first_name,
4310 middle_initial = new_references.middle_initial,
4311 address_number_and_street = new_references.address_number_and_street,
4312 city = new_references.city,
4313 state_mailing = new_references.state_mailing,
4314 zip_code = new_references.zip_code,
4315 s_telephone_number = new_references.s_telephone_number,
4316 s_title = new_references.s_title,
4317 date_of_birth = new_references.date_of_birth,
4318 social_security_number = new_references.social_security_number,
4319 state_legal_residence = new_references.state_legal_residence,
4320 foreign_address_indicator = new_references.foreign_address_indicator,
4321 foreign_postal_code = new_references.foreign_postal_code,
4322 country = new_references.country,
4323 financial_aid_status = new_references.financial_aid_status,
4324 year_in_college = new_references.year_in_college,
4325 marital_status = new_references.marital_status,
4326 ward_court = new_references.ward_court,
4327 legal_dependents_other = new_references.legal_dependents_other,
4328 household_size = new_references.household_size,
4329 number_in_college = new_references.number_in_college,
4330 citizenship_status = new_references.citizenship_status,
4331 citizenship_country = new_references.citizenship_country,
4332 visa_classification = new_references.visa_classification,
4333 tax_figures = new_references.tax_figures,
4334 number_exemptions = new_references.number_exemptions,
4335 adjusted_gross_inc = new_references.adjusted_gross_inc,
4336 us_tax_paid = new_references.us_tax_paid,
4337 itemized_deductions = new_references.itemized_deductions,
4338 stu_income_work = new_references.stu_income_work,
4339 spouse_income_work = new_references.spouse_income_work,
4340 divid_int_inc = new_references.divid_int_inc,
4341 soc_sec_benefits = new_references.soc_sec_benefits,
4342 welfare_tanf = new_references.welfare_tanf,
4343 child_supp_rcvd = new_references.child_supp_rcvd,
4344 earned_income_credit = new_references.earned_income_credit,
4345 other_untax_income = new_references.other_untax_income,
4346 tax_stu_aid = new_references.tax_stu_aid,
4347 cash_sav_check = new_references.cash_sav_check,
4348 ira_keogh = new_references.ira_keogh,
4349 invest_value = new_references.invest_value,
4350 invest_debt = new_references.invest_debt,
4351 home_value = new_references.home_value,
4352 home_debt = new_references.home_debt,
4353 oth_real_value = new_references.oth_real_value,
4354 oth_real_debt = new_references.oth_real_debt,
4355 bus_farm_value = new_references.bus_farm_value,
4356 bus_farm_debt = new_references.bus_farm_debt,
4357 live_on_farm = new_references.live_on_farm,
4358 home_purch_price = new_references.home_purch_price,
4359 hope_ll_credit = new_references.hope_ll_credit,
4360 home_purch_year = new_references.home_purch_year,
4361 trust_amount = new_references.trust_amount,
4362 trust_avail = new_references.trust_avail,
4366 vet_us = new_references.vet_us,
4363 trust_estab = new_references.trust_estab,
4364 child_support_paid = new_references.child_support_paid,
4365 med_dent_expenses = new_references.med_dent_expenses,
4367 vet_ben_amount = new_references.vet_ben_amount,
4368 vet_ben_months = new_references.vet_ben_months,
4369 stu_summer_wages = new_references.stu_summer_wages,
4370 stu_school_yr_wages = new_references.stu_school_yr_wages,
4371 spouse_summer_wages = new_references.spouse_summer_wages,
4372 spouse_school_yr_wages = new_references.spouse_school_yr_wages,
4373 summer_other_tax_inc = new_references.summer_other_tax_inc,
4374 school_yr_other_tax_inc = new_references.school_yr_other_tax_inc,
4375 summer_untax_inc = new_references.summer_untax_inc,
4376 school_yr_untax_inc = new_references.school_yr_untax_inc,
4377 grants_schol_etc = new_references.grants_schol_etc,
4378 tuit_benefits = new_references.tuit_benefits,
4379 cont_parents = new_references.cont_parents,
4380 cont_relatives = new_references.cont_relatives,
4381 p_siblings_pre_tuit = new_references.p_siblings_pre_tuit,
4382 p_student_pre_tuit = new_references.p_student_pre_tuit,
4383 p_household_size = new_references.p_household_size,
4384 p_number_in_college = new_references.p_number_in_college,
4385 p_parents_in_college = new_references.p_parents_in_college,
4386 p_marital_status = new_references.p_marital_status,
4387 p_state_legal_residence = new_references.p_state_legal_residence,
4388 p_natural_par_status = new_references.p_natural_par_status,
4389 p_child_supp_paid = new_references.p_child_supp_paid,
4390 p_repay_ed_loans = new_references.p_repay_ed_loans,
4391 p_med_dent_expenses = new_references.p_med_dent_expenses,
4392 p_tuit_paid_amount = new_references.p_tuit_paid_amount,
4393 p_tuit_paid_number = new_references.p_tuit_paid_number,
4394 p_exp_child_supp_paid = new_references.p_exp_child_supp_paid,
4395 p_exp_repay_ed_loans = new_references.p_exp_repay_ed_loans,
4396 p_exp_med_dent_expenses = new_references.p_exp_med_dent_expenses,
4397 p_exp_tuit_pd_amount = new_references.p_exp_tuit_pd_amount,
4398 p_exp_tuit_pd_number = new_references.p_exp_tuit_pd_number,
4399 p_cash_sav_check = new_references.p_cash_sav_check,
4400 p_month_mortgage_pay = new_references.p_month_mortgage_pay,
4401 p_invest_value = new_references.p_invest_value,
4402 p_invest_debt = new_references.p_invest_debt,
4403 p_home_value = new_references.p_home_value,
4404 p_home_debt = new_references.p_home_debt,
4405 p_home_purch_price = new_references.p_home_purch_price,
4406 p_own_business_farm = new_references.p_own_business_farm,
4407 p_business_value = new_references.p_business_value,
4408 p_business_debt = new_references.p_business_debt,
4409 p_farm_value = new_references.p_farm_value,
4410 p_farm_debt = new_references.p_farm_debt,
4411 p_live_on_farm = new_references.p_live_on_farm,
4412 p_oth_real_estate_value = new_references.p_oth_real_estate_value,
4413 p_oth_real_estate_debt = new_references.p_oth_real_estate_debt,
4414 p_oth_real_purch_price = new_references.p_oth_real_purch_price,
4415 p_siblings_assets = new_references.p_siblings_assets,
4416 p_home_purch_year = new_references.p_home_purch_year,
4417 p_oth_real_purch_year = new_references.p_oth_real_purch_year,
4418 p_prior_agi = new_references.p_prior_agi,
4419 p_prior_us_tax_paid = new_references.p_prior_us_tax_paid,
4420 p_prior_item_deductions = new_references.p_prior_item_deductions,
4421 p_prior_other_untax_inc = new_references.p_prior_other_untax_inc,
4422 p_tax_figures = new_references.p_tax_figures,
4423 p_number_exemptions = new_references.p_number_exemptions,
4424 p_adjusted_gross_inc = new_references.p_adjusted_gross_inc,
4425 p_wages_sal_tips = new_references.p_wages_sal_tips,
4426 p_interest_income = new_references.p_interest_income,
4427 p_dividend_income = new_references.p_dividend_income,
4428 p_net_inc_bus_farm = new_references.p_net_inc_bus_farm,
4429 p_other_taxable_income = new_references.p_other_taxable_income,
4430 p_adj_to_income = new_references.p_adj_to_income,
4431 p_us_tax_paid = new_references.p_us_tax_paid,
4432 p_itemized_deductions = new_references.p_itemized_deductions,
4433 p_father_income_work = new_references.p_father_income_work,
4434 p_mother_income_work = new_references.p_mother_income_work,
4435 p_soc_sec_ben = new_references.p_soc_sec_ben,
4439 p_tax_defer_pens_savs = new_references.p_tax_defer_pens_savs,
4436 p_welfare_tanf = new_references.p_welfare_tanf,
4437 p_child_supp_rcvd = new_references.p_child_supp_rcvd,
4438 p_ded_ira_keogh = new_references.p_ded_ira_keogh,
4440 p_dep_care_med_spending = new_references.p_dep_care_med_spending,
4441 p_earned_income_credit = new_references.p_earned_income_credit,
4442 p_living_allow = new_references.p_living_allow,
4443 p_tax_exmpt_int = new_references.p_tax_exmpt_int,
4444 p_foreign_inc_excl = new_references.p_foreign_inc_excl,
4445 p_other_untax_inc = new_references.p_other_untax_inc,
4446 p_hope_ll_credit = new_references.p_hope_ll_credit,
4447 p_yr_separation = new_references.p_yr_separation,
4448 p_yr_divorce = new_references.p_yr_divorce,
4449 p_exp_father_inc = new_references.p_exp_father_inc,
4450 p_exp_mother_inc = new_references.p_exp_mother_inc,
4451 p_exp_other_tax_inc = new_references.p_exp_other_tax_inc,
4452 p_exp_other_untax_inc = new_references.p_exp_other_untax_inc,
4453 line_2_relation = new_references.line_2_relation,
4454 line_2_attend_college = new_references.line_2_attend_college,
4455 line_3_relation = new_references.line_3_relation,
4456 line_3_attend_college = new_references.line_3_attend_college,
4457 line_4_relation = new_references.line_4_relation,
4458 line_4_attend_college = new_references.line_4_attend_college,
4459 line_5_relation = new_references.line_5_relation,
4460 line_5_attend_college = new_references.line_5_attend_college,
4461 line_6_relation = new_references.line_6_relation,
4462 line_6_attend_college = new_references.line_6_attend_college,
4463 line_7_relation = new_references.line_7_relation,
4464 line_7_attend_college = new_references.line_7_attend_college,
4465 line_8_relation = new_references.line_8_relation,
4466 line_8_attend_college = new_references.line_8_attend_college,
4467 p_age_father = new_references.p_age_father,
4468 p_age_mother = new_references.p_age_mother,
4469 p_div_sep_ind = new_references.p_div_sep_ind,
4470 b_cont_non_custodial_par = new_references.b_cont_non_custodial_par,
4471 college_type_2 = new_references.college_type_2,
4472 college_type_3 = new_references.college_type_3,
4473 college_type_4 = new_references.college_type_4,
4474 college_type_5 = new_references.college_type_5,
4475 college_type_6 = new_references.college_type_6,
4476 college_type_7 = new_references.college_type_7,
4477 college_type_8 = new_references.college_type_8,
4478 school_code_1 = new_references.school_code_1,
4479 housing_code_1 = new_references.housing_code_1,
4480 school_code_2 = new_references.school_code_2,
4481 housing_code_2 = new_references.housing_code_2,
4482 school_code_3 = new_references.school_code_3,
4483 housing_code_3 = new_references.housing_code_3,
4484 school_code_4 = new_references.school_code_4,
4485 housing_code_4 = new_references.housing_code_4,
4486 school_code_5 = new_references.school_code_5,
4487 housing_code_5 = new_references.housing_code_5,
4488 school_code_6 = new_references.school_code_6,
4489 housing_code_6 = new_references.housing_code_6,
4490 school_code_7 = new_references.school_code_7,
4491 housing_code_7 = new_references.housing_code_7,
4492 school_code_8 = new_references.school_code_8,
4493 housing_code_8 = new_references.housing_code_8,
4494 school_code_9 = new_references.school_code_9,
4495 housing_code_9 = new_references.housing_code_9,
4496 school_code_10 = new_references.school_code_10,
4497 housing_code_10 = new_references.housing_code_10,
4498 additional_school_code_1 = new_references.additional_school_code_1,
4499 additional_school_code_2 = new_references.additional_school_code_2,
4500 additional_school_code_3 = new_references.additional_school_code_3,
4501 additional_school_code_4 = new_references.additional_school_code_4,
4502 additional_school_code_5 = new_references.additional_school_code_5,
4503 additional_school_code_6 = new_references.additional_school_code_6,
4504 additional_school_code_7 = new_references.additional_school_code_7,
4505 additional_school_code_8 = new_references.additional_school_code_8,
4506 additional_school_code_9 = new_references.additional_school_code_9,
4507 additional_school_code_10 = new_references.additional_school_code_10,
4508 explanation_spec_circum = new_references.explanation_spec_circum,
4509 signature_student = new_references.signature_student,
4510 signature_spouse = new_references.signature_spouse,
4511 signature_father = new_references.signature_father,
4512 signature_mother = new_references.signature_mother,
4516 age_line_3 = new_references.age_line_3,
4513 month_day_completed = new_references.month_day_completed,
4514 year_completed = new_references.year_completed,
4515 age_line_2 = new_references.age_line_2,
4517 age_line_4 = new_references.age_line_4,
4518 age_line_5 = new_references.age_line_5,
4519 age_line_6 = new_references.age_line_6,
4520 age_line_7 = new_references.age_line_7,
4521 age_line_8 = new_references.age_line_8,
4522 a_online_signature = new_references.a_online_signature,
4523 question_1_number = new_references.question_1_number,
4524 question_1_size = new_references.question_1_size,
4525 question_1_answer = new_references.question_1_answer,
4526 question_2_number = new_references.question_2_number,
4527 question_2_size = new_references.question_2_size,
4528 question_2_answer = new_references.question_2_answer,
4529 question_3_number = new_references.question_3_number,
4530 question_3_size = new_references.question_3_size,
4531 question_3_answer = new_references.question_3_answer,
4532 question_4_number = new_references.question_4_number,
4533 question_4_size = new_references.question_4_size,
4534 question_4_answer = new_references.question_4_answer,
4535 question_5_number = new_references.question_5_number,
4536 question_5_size = new_references.question_5_size,
4537 question_5_answer = new_references.question_5_answer,
4538 question_6_number = new_references.question_6_number,
4539 question_6_size = new_references.question_6_size,
4540 question_6_answer = new_references.question_6_answer,
4541 question_7_number = new_references.question_7_number,
4542 question_7_size = new_references.question_7_size,
4543 question_7_answer = new_references.question_7_answer,
4544 question_8_number = new_references.question_8_number,
4545 question_8_size = new_references.question_8_size,
4546 question_8_answer = new_references.question_8_answer,
4547 question_9_number = new_references.question_9_number,
4548 question_9_size = new_references.question_9_size,
4549 question_9_answer = new_references.question_9_answer,
4550 question_10_number = new_references.question_10_number,
4551 question_10_size = new_references.question_10_size,
4552 question_10_answer = new_references.question_10_answer,
4553 question_11_number = new_references.question_11_number,
4554 question_11_size = new_references.question_11_size,
4555 question_11_answer = new_references.question_11_answer,
4556 question_12_number = new_references.question_12_number,
4557 question_12_size = new_references.question_12_size,
4558 question_12_answer = new_references.question_12_answer,
4559 question_13_number = new_references.question_13_number,
4560 question_13_size = new_references.question_13_size,
4561 question_13_answer = new_references.question_13_answer,
4562 question_14_number = new_references.question_14_number,
4563 question_14_size = new_references.question_14_size,
4564 question_14_answer = new_references.question_14_answer,
4565 question_15_number = new_references.question_15_number,
4566 question_15_size = new_references.question_15_size,
4567 question_15_answer = new_references.question_15_answer,
4568 question_16_number = new_references.question_16_number,
4569 question_16_size = new_references.question_16_size,
4570 question_16_answer = new_references.question_16_answer,
4571 question_17_number = new_references.question_17_number,
4572 question_17_size = new_references.question_17_size,
4573 question_17_answer = new_references.question_17_answer,
4574 question_18_number = new_references.question_18_number,
4575 question_18_size = new_references.question_18_size,
4576 question_18_answer = new_references.question_18_answer,
4577 question_19_number = new_references.question_19_number,
4578 question_19_size = new_references.question_19_size,
4579 question_19_answer = new_references.question_19_answer,
4580 question_20_number = new_references.question_20_number,
4581 question_20_size = new_references.question_20_size,
4582 question_20_answer = new_references.question_20_answer,
4583 question_21_number = new_references.question_21_number,
4584 question_21_size = new_references.question_21_size,
4585 question_21_answer = new_references.question_21_answer,
4586 question_22_number = new_references.question_22_number,
4587 question_22_size = new_references.question_22_size,
4588 question_22_answer = new_references.question_22_answer,
4589 question_23_number = new_references.question_23_number,
4590 question_23_size = new_references.question_23_size,
4594 question_24_answer = new_references.question_24_answer,
4591 question_23_answer = new_references.question_23_answer,
4592 question_24_number = new_references.question_24_number,
4593 question_24_size = new_references.question_24_size,
4595 question_25_number = new_references.question_25_number,
4596 question_25_size = new_references.question_25_size,
4597 question_25_answer = new_references.question_25_answer,
4598 question_26_number = new_references.question_26_number,
4599 question_26_size = new_references.question_26_size,
4600 question_26_answer = new_references.question_26_answer,
4601 question_27_number = new_references.question_27_number,
4602 question_27_size = new_references.question_27_size,
4603 question_27_answer = new_references.question_27_answer,
4604 question_28_number = new_references.question_28_number,
4605 question_28_size = new_references.question_28_size,
4606 question_28_answer = new_references.question_28_answer,
4607 question_29_number = new_references.question_29_number,
4608 question_29_size = new_references.question_29_size,
4609 question_29_answer = new_references.question_29_answer,
4610 question_30_number = new_references.question_30_number,
4611 questions_30_size = new_references.questions_30_size,
4612 question_30_answer = new_references.question_30_answer,
4613 last_update_date = x_last_update_date,
4614 last_updated_by = x_last_updated_by,
4615 last_update_login = x_last_update_login
4616 WHERE rowid = x_rowid;
4617
4618 IF (SQL%NOTFOUND) THEN
4619 RAISE NO_DATA_FOUND;
4620 END IF;
4621
4622 END update_row;
4623
4624
4625 PROCEDURE add_row (
4626 x_rowid IN OUT NOCOPY VARCHAR2,
4627 x_base_id IN OUT NOCOPY NUMBER,
4628 x_last_name IN VARCHAR2,
4629 x_first_name IN VARCHAR2,
4630 x_middle_initial IN VARCHAR2,
4631 x_address_number_and_street IN VARCHAR2,
4632 x_city IN VARCHAR2,
4633 x_state_mailing IN VARCHAR2,
4634 x_zip_code IN VARCHAR2,
4635 x_s_telephone_number IN VARCHAR2,
4636 x_s_title IN VARCHAR2,
4637 x_date_of_birth IN VARCHAR2,
4638 x_social_security_number IN VARCHAR2,
4639 x_state_legal_residence IN VARCHAR2,
4640 x_foreign_address_indicator IN VARCHAR2,
4641 x_foreign_postal_code IN VARCHAR2,
4642 x_country IN VARCHAR2,
4643 x_financial_aid_status IN VARCHAR2,
4644 x_year_in_college IN VARCHAR2,
4645 x_marital_status IN VARCHAR2,
4646 x_ward_court IN VARCHAR2,
4647 x_legal_dependents_other IN VARCHAR2,
4648 x_household_size IN VARCHAR2,
4649 x_number_in_college IN VARCHAR2,
4650 x_citizenship_status IN VARCHAR2,
4651 x_citizenship_country IN VARCHAR2,
4652 x_visa_classification IN VARCHAR2,
4653 x_tax_figures IN VARCHAR2,
4654 x_number_exemptions IN VARCHAR2,
4655 x_adjusted_gross_inc IN VARCHAR2,
4656 x_us_tax_paid IN VARCHAR2,
4657 x_itemized_deductions IN VARCHAR2,
4658 x_stu_income_work IN VARCHAR2,
4659 x_spouse_income_work IN VARCHAR2,
4660 x_divid_int_inc IN VARCHAR2,
4661 x_soc_sec_benefits IN VARCHAR2,
4662 x_welfare_tanf IN VARCHAR2,
4663 x_child_supp_rcvd IN VARCHAR2,
4664 x_earned_income_credit IN VARCHAR2,
4665 x_other_untax_income IN VARCHAR2,
4666 x_tax_stu_aid IN VARCHAR2,
4667 x_cash_sav_check IN VARCHAR2,
4668 x_ira_keogh IN VARCHAR2,
4669 x_invest_value IN VARCHAR2,
4670 x_invest_debt IN VARCHAR2,
4671 x_home_value IN VARCHAR2,
4672 x_home_debt IN VARCHAR2,
4673 x_oth_real_value IN VARCHAR2,
4674 x_oth_real_debt IN VARCHAR2,
4675 x_bus_farm_value IN VARCHAR2,
4676 x_bus_farm_debt IN VARCHAR2,
4677 x_live_on_farm IN VARCHAR2,
4678 x_home_purch_price IN VARCHAR2,
4679 x_hope_ll_credit IN VARCHAR2,
4680 x_home_purch_year IN VARCHAR2,
4681 x_trust_amount IN VARCHAR2,
4682 x_trust_avail IN VARCHAR2,
4683 x_trust_estab IN VARCHAR2,
4684 x_child_support_paid IN VARCHAR2,
4685 x_med_dent_expenses IN VARCHAR2,
4686 x_vet_us IN VARCHAR2,
4687 x_vet_ben_amount IN VARCHAR2,
4688 x_vet_ben_months IN VARCHAR2,
4692 x_spouse_school_yr_wages IN VARCHAR2,
4689 x_stu_summer_wages IN VARCHAR2,
4690 x_stu_school_yr_wages IN VARCHAR2,
4691 x_spouse_summer_wages IN VARCHAR2,
4693 x_summer_other_tax_inc IN VARCHAR2,
4694 x_school_yr_other_tax_inc IN VARCHAR2,
4695 x_summer_untax_inc IN VARCHAR2,
4696 x_school_yr_untax_inc IN VARCHAR2,
4697 x_grants_schol_etc IN VARCHAR2,
4698 x_tuit_benefits IN VARCHAR2,
4699 x_cont_parents IN VARCHAR2,
4700 x_cont_relatives IN VARCHAR2,
4701 x_p_siblings_pre_tuit IN VARCHAR2,
4702 x_p_student_pre_tuit IN VARCHAR2,
4703 x_p_household_size IN VARCHAR2,
4704 x_p_number_in_college IN VARCHAR2,
4705 x_p_parents_in_college IN VARCHAR2,
4706 x_p_marital_status IN VARCHAR2,
4707 x_p_state_legal_residence IN VARCHAR2,
4708 x_p_natural_par_status IN VARCHAR2,
4709 x_p_child_supp_paid IN VARCHAR2,
4710 x_p_repay_ed_loans IN VARCHAR2,
4711 x_p_med_dent_expenses IN VARCHAR2,
4712 x_p_tuit_paid_amount IN VARCHAR2,
4713 x_p_tuit_paid_number IN VARCHAR2,
4714 x_p_exp_child_supp_paid IN VARCHAR2,
4715 x_p_exp_repay_ed_loans IN VARCHAR2,
4716 x_p_exp_med_dent_expenses IN VARCHAR2,
4717 x_p_exp_tuit_pd_amount IN VARCHAR2,
4718 x_p_exp_tuit_pd_number IN VARCHAR2,
4719 x_p_cash_sav_check IN VARCHAR2,
4720 x_p_month_mortgage_pay IN VARCHAR2,
4721 x_p_invest_value IN VARCHAR2,
4722 x_p_invest_debt IN VARCHAR2,
4723 x_p_home_value IN VARCHAR2,
4724 x_p_home_debt IN VARCHAR2,
4725 x_p_home_purch_price IN VARCHAR2,
4726 x_p_own_business_farm IN VARCHAR2,
4727 x_p_business_value IN VARCHAR2,
4728 x_p_business_debt IN VARCHAR2,
4729 x_p_farm_value IN VARCHAR2,
4730 x_p_farm_debt IN VARCHAR2,
4731 x_p_live_on_farm IN VARCHAR2,
4732 x_p_oth_real_estate_value IN VARCHAR2,
4733 x_p_oth_real_estate_debt IN VARCHAR2,
4734 x_p_oth_real_purch_price IN VARCHAR2,
4735 x_p_siblings_assets IN VARCHAR2,
4736 x_p_home_purch_year IN VARCHAR2,
4737 x_p_oth_real_purch_year IN VARCHAR2,
4738 x_p_prior_agi IN VARCHAR2,
4739 x_p_prior_us_tax_paid IN VARCHAR2,
4740 x_p_prior_item_deductions IN VARCHAR2,
4741 x_p_prior_other_untax_inc IN VARCHAR2,
4742 x_p_tax_figures IN VARCHAR2,
4743 x_p_number_exemptions IN VARCHAR2,
4744 x_p_adjusted_gross_inc IN VARCHAR2,
4745 x_p_wages_sal_tips IN VARCHAR2,
4746 x_p_interest_income IN VARCHAR2,
4747 x_p_dividend_income IN VARCHAR2,
4748 x_p_net_inc_bus_farm IN VARCHAR2,
4749 x_p_other_taxable_income IN VARCHAR2,
4750 x_p_adj_to_income IN VARCHAR2,
4751 x_p_us_tax_paid IN VARCHAR2,
4752 x_p_itemized_deductions IN VARCHAR2,
4753 x_p_father_income_work IN VARCHAR2,
4754 x_p_mother_income_work IN VARCHAR2,
4755 x_p_soc_sec_ben IN VARCHAR2,
4756 x_p_welfare_tanf IN VARCHAR2,
4757 x_p_child_supp_rcvd IN VARCHAR2,
4758 x_p_ded_ira_keogh IN VARCHAR2,
4759 x_p_tax_defer_pens_savs IN VARCHAR2,
4760 x_p_dep_care_med_spending IN VARCHAR2,
4761 x_p_earned_income_credit IN VARCHAR2,
4762 x_p_living_allow IN VARCHAR2,
4763 x_p_tax_exmpt_int IN VARCHAR2,
4764 x_p_foreign_inc_excl IN VARCHAR2,
4765 x_p_other_untax_inc IN VARCHAR2,
4766 x_p_hope_ll_credit IN VARCHAR2,
4767 x_p_yr_separation IN VARCHAR2,
4768 x_p_yr_divorce IN VARCHAR2,
4769 x_p_exp_father_inc IN VARCHAR2,
4770 x_p_exp_mother_inc IN VARCHAR2,
4771 x_p_exp_other_tax_inc IN VARCHAR2,
4772 x_p_exp_other_untax_inc IN VARCHAR2,
4773 x_line_2_relation IN VARCHAR2,
4774 x_line_2_attend_college IN VARCHAR2,
4775 x_line_3_relation IN VARCHAR2,
4776 x_line_3_attend_college IN VARCHAR2,
4777 x_line_4_relation IN VARCHAR2,
4778 x_line_4_attend_college IN VARCHAR2,
4779 x_line_5_relation IN VARCHAR2,
4780 x_line_5_attend_college IN VARCHAR2,
4781 x_line_6_relation IN VARCHAR2,
4782 x_line_6_attend_college IN VARCHAR2,
4783 x_line_7_relation IN VARCHAR2,
4784 x_line_7_attend_college IN VARCHAR2,
4785 x_line_8_relation IN VARCHAR2,
4786 x_line_8_attend_college IN VARCHAR2,
4787 x_p_age_father IN VARCHAR2,
4788 x_p_age_mother IN VARCHAR2,
4792 x_college_type_3 IN VARCHAR2,
4789 x_p_div_sep_ind IN VARCHAR2,
4790 x_b_cont_non_custodial_par IN VARCHAR2,
4791 x_college_type_2 IN VARCHAR2,
4793 x_college_type_4 IN VARCHAR2,
4794 x_college_type_5 IN VARCHAR2,
4795 x_college_type_6 IN VARCHAR2,
4796 x_college_type_7 IN VARCHAR2,
4797 x_college_type_8 IN VARCHAR2,
4798 x_school_code_1 IN VARCHAR2,
4799 x_housing_code_1 IN VARCHAR2,
4800 x_school_code_2 IN VARCHAR2,
4801 x_housing_code_2 IN VARCHAR2,
4802 x_school_code_3 IN VARCHAR2,
4803 x_housing_code_3 IN VARCHAR2,
4804 x_school_code_4 IN VARCHAR2,
4805 x_housing_code_4 IN VARCHAR2,
4806 x_school_code_5 IN VARCHAR2,
4807 x_housing_code_5 IN VARCHAR2,
4808 x_school_code_6 IN VARCHAR2,
4809 x_housing_code_6 IN VARCHAR2,
4810 x_school_code_7 IN VARCHAR2,
4811 x_housing_code_7 IN VARCHAR2,
4812 x_school_code_8 IN VARCHAR2,
4813 x_housing_code_8 IN VARCHAR2,
4814 x_school_code_9 IN VARCHAR2,
4815 x_housing_code_9 IN VARCHAR2,
4816 x_school_code_10 IN VARCHAR2,
4817 x_housing_code_10 IN VARCHAR2,
4818 x_additional_school_code_1 IN VARCHAR2,
4819 x_additional_school_code_2 IN VARCHAR2,
4820 x_additional_school_code_3 IN VARCHAR2,
4821 x_additional_school_code_4 IN VARCHAR2,
4822 x_additional_school_code_5 IN VARCHAR2,
4823 x_additional_school_code_6 IN VARCHAR2,
4824 x_additional_school_code_7 IN VARCHAR2,
4825 x_additional_school_code_8 IN VARCHAR2,
4826 x_additional_school_code_9 IN VARCHAR2,
4827 x_additional_school_code_10 IN VARCHAR2,
4828 x_explanation_spec_circum IN VARCHAR2,
4829 x_signature_student IN VARCHAR2,
4830 x_signature_spouse IN VARCHAR2,
4831 x_signature_father IN VARCHAR2,
4832 x_signature_mother IN VARCHAR2,
4833 x_month_day_completed IN VARCHAR2,
4834 x_year_completed IN VARCHAR2,
4835 x_age_line_2 IN VARCHAR2,
4836 x_age_line_3 IN VARCHAR2,
4837 x_age_line_4 IN VARCHAR2,
4838 x_age_line_5 IN VARCHAR2,
4839 x_age_line_6 IN VARCHAR2,
4840 x_age_line_7 IN VARCHAR2,
4841 x_age_line_8 IN VARCHAR2,
4842 x_a_online_signature IN VARCHAR2,
4843 x_question_1_number IN VARCHAR2,
4844 x_question_1_size IN VARCHAR2,
4845 x_question_1_answer IN VARCHAR2,
4846 x_question_2_number IN VARCHAR2,
4847 x_question_2_size IN VARCHAR2,
4848 x_question_2_answer IN VARCHAR2,
4849 x_question_3_number IN VARCHAR2,
4850 x_question_3_size IN VARCHAR2,
4851 x_question_3_answer IN VARCHAR2,
4852 x_question_4_number IN VARCHAR2,
4853 x_question_4_size IN VARCHAR2,
4854 x_question_4_answer IN VARCHAR2,
4855 x_question_5_number IN VARCHAR2,
4856 x_question_5_size IN VARCHAR2,
4857 x_question_5_answer IN VARCHAR2,
4858 x_question_6_number IN VARCHAR2,
4859 x_question_6_size IN VARCHAR2,
4860 x_question_6_answer IN VARCHAR2,
4861 x_question_7_number IN VARCHAR2,
4862 x_question_7_size IN VARCHAR2,
4863 x_question_7_answer IN VARCHAR2,
4864 x_question_8_number IN VARCHAR2,
4865 x_question_8_size IN VARCHAR2,
4866 x_question_8_answer IN VARCHAR2,
4867 x_question_9_number IN VARCHAR2,
4868 x_question_9_size IN VARCHAR2,
4869 x_question_9_answer IN VARCHAR2,
4870 x_question_10_number IN VARCHAR2,
4871 x_question_10_size IN VARCHAR2,
4872 x_question_10_answer IN VARCHAR2,
4873 x_question_11_number IN VARCHAR2,
4874 x_question_11_size IN VARCHAR2,
4875 x_question_11_answer IN VARCHAR2,
4876 x_question_12_number IN VARCHAR2,
4877 x_question_12_size IN VARCHAR2,
4878 x_question_12_answer IN VARCHAR2,
4879 x_question_13_number IN VARCHAR2,
4880 x_question_13_size IN VARCHAR2,
4881 x_question_13_answer IN VARCHAR2,
4882 x_question_14_number IN VARCHAR2,
4883 x_question_14_size IN VARCHAR2,
4884 x_question_14_answer IN VARCHAR2,
4885 x_question_15_number IN VARCHAR2,
4886 x_question_15_size IN VARCHAR2,
4887 x_question_15_answer IN VARCHAR2,
4888 x_question_16_number IN VARCHAR2,
4889 x_question_16_size IN VARCHAR2,
4890 x_question_16_answer IN VARCHAR2,
4891 x_question_17_number IN VARCHAR2,
4892 x_question_17_size IN VARCHAR2,
4893 x_question_17_answer IN VARCHAR2,
4894 x_question_18_number IN VARCHAR2,
4895 x_question_18_size IN VARCHAR2,
4896 x_question_18_answer IN VARCHAR2,
4897 x_question_19_number IN VARCHAR2,
4898 x_question_19_size IN VARCHAR2,
4899 x_question_19_answer IN VARCHAR2,
4900 x_question_20_number IN VARCHAR2,
4901 x_question_20_size IN VARCHAR2,
4902 x_question_20_answer IN VARCHAR2,
4903 x_question_21_number IN VARCHAR2,
4904 x_question_21_size IN VARCHAR2,
4905 x_question_21_answer IN VARCHAR2,
4906 x_question_22_number IN VARCHAR2,
4907 x_question_22_size IN VARCHAR2,
4908 x_question_22_answer IN VARCHAR2,
4909 x_question_23_number IN VARCHAR2,
4910 x_question_23_size IN VARCHAR2,
4911 x_question_23_answer IN VARCHAR2,
4912 x_question_24_number IN VARCHAR2,
4913 x_question_24_size IN VARCHAR2,
4914 x_question_24_answer IN VARCHAR2,
4915 x_question_25_number IN VARCHAR2,
4916 x_question_25_size IN VARCHAR2,
4917 x_question_25_answer IN VARCHAR2,
4918 x_question_26_number IN VARCHAR2,
4919 x_question_26_size IN VARCHAR2,
4920 x_question_26_answer IN VARCHAR2,
4921 x_question_27_number IN VARCHAR2,
4922 x_question_27_size IN VARCHAR2,
4923 x_question_27_answer IN VARCHAR2,
4924 x_question_28_number IN VARCHAR2,
4925 x_question_28_size IN VARCHAR2,
4926 x_question_28_answer IN VARCHAR2,
4927 x_question_29_number IN VARCHAR2,
4928 x_question_29_size IN VARCHAR2,
4929 x_question_29_answer IN VARCHAR2,
4930 x_question_30_number IN VARCHAR2,
4931 x_questions_30_size IN VARCHAR2,
4932 x_question_30_answer IN VARCHAR2,
4933 x_mode IN VARCHAR2 DEFAULT 'R'
4934 ) AS
4935 /*
4936 || Created By : kkillams
4937 || Created On : 30-MAY-2001
4938 || Purpose : Adds a row if there is no existing row, otherwise updates existing row in the table.
4939 || Known limitations, enhancements or remarks :
4940 || Change History :
4941 || Who When What
4942 || (reverse chronological order - newest change first)
4943 */
4944 CURSOR c1 IS
4945 SELECT rowid
4946 FROM igf_ap_cs_upd_flags
4947 WHERE base_id = x_base_id;
4948
4949 BEGIN
4950
4951 OPEN c1;
4952 FETCH c1 INTO x_rowid;
4953 IF (c1%NOTFOUND) THEN
4954 CLOSE c1;
4955
4956 insert_row (
4957 x_rowid,
4958 x_base_id,
4959 x_last_name,
4960 x_first_name,
4961 x_middle_initial,
4962 x_address_number_and_street,
4963 x_city,
4964 x_state_mailing,
4965 x_zip_code,
4966 x_s_telephone_number,
4967 x_s_title,
4968 x_date_of_birth,
4969 x_social_security_number,
4970 x_state_legal_residence,
4971 x_foreign_address_indicator,
4972 x_foreign_postal_code,
4973 x_country,
4974 x_financial_aid_status,
4975 x_year_in_college,
4976 x_marital_status,
4977 x_ward_court,
4978 x_legal_dependents_other,
4979 x_household_size,
4980 x_number_in_college,
4981 x_citizenship_status,
4982 x_citizenship_country,
4983 x_visa_classification,
4984 x_tax_figures,
4985 x_number_exemptions,
4986 x_adjusted_gross_inc,
4987 x_us_tax_paid,
4988 x_itemized_deductions,
4989 x_stu_income_work,
4990 x_spouse_income_work,
4991 x_divid_int_inc,
4992 x_soc_sec_benefits,
4993 x_welfare_tanf,
4994 x_child_supp_rcvd,
4995 x_earned_income_credit,
4996 x_other_untax_income,
4997 x_tax_stu_aid,
4998 x_cash_sav_check,
4999 x_ira_keogh,
5000 x_invest_value,
5001 x_invest_debt,
5002 x_home_value,
5003 x_home_debt,
5004 x_oth_real_value,
5005 x_oth_real_debt,
5006 x_bus_farm_value,
5007 x_bus_farm_debt,
5008 x_live_on_farm,
5009 x_home_purch_price,
5010 x_hope_ll_credit,
5011 x_home_purch_year,
5012 x_trust_amount,
5013 x_trust_avail,
5014 x_trust_estab,
5015 x_child_support_paid,
5016 x_med_dent_expenses,
5017 x_vet_us,
5018 x_vet_ben_amount,
5019 x_vet_ben_months,
5020 x_stu_summer_wages,
5021 x_stu_school_yr_wages,
5022 x_spouse_summer_wages,
5023 x_spouse_school_yr_wages,
5024 x_summer_other_tax_inc,
5025 x_school_yr_other_tax_inc,
5026 x_summer_untax_inc,
5027 x_school_yr_untax_inc,
5028 x_grants_schol_etc,
5029 x_tuit_benefits,
5030 x_cont_parents,
5031 x_cont_relatives,
5032 x_p_siblings_pre_tuit,
5033 x_p_student_pre_tuit,
5034 x_p_household_size,
5035 x_p_number_in_college,
5036 x_p_parents_in_college,
5037 x_p_marital_status,
5038 x_p_state_legal_residence,
5039 x_p_natural_par_status,
5040 x_p_child_supp_paid,
5041 x_p_repay_ed_loans,
5042 x_p_med_dent_expenses,
5043 x_p_tuit_paid_amount,
5044 x_p_tuit_paid_number,
5045 x_p_exp_child_supp_paid,
5046 x_p_exp_repay_ed_loans,
5047 x_p_exp_med_dent_expenses,
5048 x_p_exp_tuit_pd_amount,
5049 x_p_exp_tuit_pd_number,
5050 x_p_cash_sav_check,
5051 x_p_month_mortgage_pay,
5052 x_p_invest_value,
5053 x_p_invest_debt,
5054 x_p_home_value,
5055 x_p_home_debt,
5056 x_p_home_purch_price,
5057 x_p_own_business_farm,
5058 x_p_business_value,
5059 x_p_business_debt,
5060 x_p_farm_value,
5061 x_p_farm_debt,
5062 x_p_live_on_farm,
5063 x_p_oth_real_estate_value,
5064 x_p_oth_real_estate_debt,
5065 x_p_oth_real_purch_price,
5066 x_p_siblings_assets,
5067 x_p_home_purch_year,
5068 x_p_oth_real_purch_year,
5069 x_p_prior_agi,
5070 x_p_prior_us_tax_paid,
5071 x_p_prior_item_deductions,
5072 x_p_prior_other_untax_inc,
5073 x_p_tax_figures,
5074 x_p_number_exemptions,
5075 x_p_adjusted_gross_inc,
5076 x_p_wages_sal_tips,
5077 x_p_interest_income,
5078 x_p_dividend_income,
5079 x_p_net_inc_bus_farm,
5080 x_p_other_taxable_income,
5081 x_p_adj_to_income,
5082 x_p_us_tax_paid,
5083 x_p_itemized_deductions,
5084 x_p_father_income_work,
5085 x_p_mother_income_work,
5086 x_p_soc_sec_ben,
5087 x_p_welfare_tanf,
5088 x_p_child_supp_rcvd,
5089 x_p_ded_ira_keogh,
5090 x_p_tax_defer_pens_savs,
5091 x_p_dep_care_med_spending,
5092 x_p_earned_income_credit,
5093 x_p_living_allow,
5094 x_p_tax_exmpt_int,
5095 x_p_foreign_inc_excl,
5096 x_p_other_untax_inc,
5097 x_p_hope_ll_credit,
5098 x_p_yr_separation,
5099 x_p_yr_divorce,
5100 x_p_exp_father_inc,
5101 x_p_exp_mother_inc,
5102 x_p_exp_other_tax_inc,
5103 x_p_exp_other_untax_inc,
5104 x_line_2_relation,
5105 x_line_2_attend_college,
5106 x_line_3_relation,
5107 x_line_3_attend_college,
5108 x_line_4_relation,
5109 x_line_4_attend_college,
5110 x_line_5_relation,
5111 x_line_5_attend_college,
5112 x_line_6_relation,
5113 x_line_6_attend_college,
5114 x_line_7_relation,
5115 x_line_7_attend_college,
5116 x_line_8_relation,
5117 x_line_8_attend_college,
5118 x_p_age_father,
5119 x_p_age_mother,
5120 x_p_div_sep_ind,
5121 x_b_cont_non_custodial_par,
5122 x_college_type_2,
5123 x_college_type_3,
5124 x_college_type_4,
5125 x_college_type_5,
5126 x_college_type_6,
5127 x_college_type_7,
5128 x_college_type_8,
5129 x_school_code_1,
5130 x_housing_code_1,
5131 x_school_code_2,
5132 x_housing_code_2,
5133 x_school_code_3,
5134 x_housing_code_3,
5135 x_school_code_4,
5136 x_housing_code_4,
5137 x_school_code_5,
5138 x_housing_code_5,
5139 x_school_code_6,
5140 x_housing_code_6,
5141 x_school_code_7,
5142 x_housing_code_7,
5143 x_school_code_8,
5144 x_housing_code_8,
5145 x_school_code_9,
5146 x_housing_code_9,
5147 x_school_code_10,
5148 x_housing_code_10,
5149 x_additional_school_code_1,
5150 x_additional_school_code_2,
5151 x_additional_school_code_3,
5152 x_additional_school_code_4,
5153 x_additional_school_code_5,
5154 x_additional_school_code_6,
5155 x_additional_school_code_7,
5156 x_additional_school_code_8,
5157 x_additional_school_code_9,
5158 x_additional_school_code_10,
5159 x_explanation_spec_circum,
5160 x_signature_student,
5161 x_signature_spouse,
5162 x_signature_father,
5163 x_signature_mother,
5164 x_month_day_completed,
5165 x_year_completed,
5166 x_age_line_2,
5167 x_age_line_3,
5168 x_age_line_4,
5169 x_age_line_5,
5170 x_age_line_6,
5171 x_age_line_7,
5172 x_age_line_8,
5173 x_a_online_signature,
5174 x_question_1_number,
5175 x_question_1_size,
5176 x_question_1_answer,
5177 x_question_2_number,
5178 x_question_2_size,
5179 x_question_2_answer,
5180 x_question_3_number,
5181 x_question_3_size,
5182 x_question_3_answer,
5183 x_question_4_number,
5184 x_question_4_size,
5185 x_question_4_answer,
5186 x_question_5_number,
5187 x_question_5_size,
5188 x_question_5_answer,
5189 x_question_6_number,
5190 x_question_6_size,
5191 x_question_6_answer,
5192 x_question_7_number,
5193 x_question_7_size,
5194 x_question_7_answer,
5195 x_question_8_number,
5196 x_question_8_size,
5197 x_question_8_answer,
5198 x_question_9_number,
5199 x_question_9_size,
5200 x_question_9_answer,
5201 x_question_10_number,
5202 x_question_10_size,
5203 x_question_10_answer,
5204 x_question_11_number,
5205 x_question_11_size,
5206 x_question_11_answer,
5207 x_question_12_number,
5208 x_question_12_size,
5209 x_question_12_answer,
5210 x_question_13_number,
5211 x_question_13_size,
5212 x_question_13_answer,
5213 x_question_14_number,
5214 x_question_14_size,
5215 x_question_14_answer,
5216 x_question_15_number,
5217 x_question_15_size,
5218 x_question_15_answer,
5219 x_question_16_number,
5220 x_question_16_size,
5221 x_question_16_answer,
5222 x_question_17_number,
5223 x_question_17_size,
5224 x_question_17_answer,
5225 x_question_18_number,
5226 x_question_18_size,
5227 x_question_18_answer,
5228 x_question_19_number,
5229 x_question_19_size,
5230 x_question_19_answer,
5231 x_question_20_number,
5232 x_question_20_size,
5233 x_question_20_answer,
5234 x_question_21_number,
5235 x_question_21_size,
5236 x_question_21_answer,
5237 x_question_22_number,
5238 x_question_22_size,
5239 x_question_22_answer,
5240 x_question_23_number,
5241 x_question_23_size,
5242 x_question_23_answer,
5243 x_question_24_number,
5244 x_question_24_size,
5245 x_question_24_answer,
5246 x_question_25_number,
5247 x_question_25_size,
5248 x_question_25_answer,
5249 x_question_26_number,
5250 x_question_26_size,
5251 x_question_26_answer,
5252 x_question_27_number,
5253 x_question_27_size,
5254 x_question_27_answer,
5255 x_question_28_number,
5256 x_question_28_size,
5257 x_question_28_answer,
5258 x_question_29_number,
5259 x_question_29_size,
5260 x_question_29_answer,
5261 x_question_30_number,
5262 x_questions_30_size,
5263 x_question_30_answer,
5264 x_mode
5265 );
5266 RETURN;
5267 END IF;
5268 CLOSE c1;
5269
5270 update_row (
5271 x_rowid,
5272 x_base_id,
5273 x_last_name,
5274 x_first_name,
5275 x_middle_initial,
5276 x_address_number_and_street,
5277 x_city,
5278 x_state_mailing,
5279 x_zip_code,
5280 x_s_telephone_number,
5281 x_s_title,
5282 x_date_of_birth,
5283 x_social_security_number,
5284 x_state_legal_residence,
5285 x_foreign_address_indicator,
5286 x_foreign_postal_code,
5287 x_country,
5288 x_financial_aid_status,
5289 x_year_in_college,
5290 x_marital_status,
5291 x_ward_court,
5292 x_legal_dependents_other,
5293 x_household_size,
5294 x_number_in_college,
5295 x_citizenship_status,
5296 x_citizenship_country,
5297 x_visa_classification,
5298 x_tax_figures,
5299 x_number_exemptions,
5300 x_adjusted_gross_inc,
5301 x_us_tax_paid,
5302 x_itemized_deductions,
5303 x_stu_income_work,
5304 x_spouse_income_work,
5305 x_divid_int_inc,
5306 x_soc_sec_benefits,
5307 x_welfare_tanf,
5308 x_child_supp_rcvd,
5309 x_earned_income_credit,
5310 x_other_untax_income,
5311 x_tax_stu_aid,
5312 x_cash_sav_check,
5313 x_ira_keogh,
5314 x_invest_value,
5315 x_invest_debt,
5316 x_home_value,
5317 x_home_debt,
5318 x_oth_real_value,
5319 x_oth_real_debt,
5320 x_bus_farm_value,
5321 x_bus_farm_debt,
5322 x_live_on_farm,
5323 x_home_purch_price,
5324 x_hope_ll_credit,
5325 x_home_purch_year,
5326 x_trust_amount,
5327 x_trust_avail,
5328 x_trust_estab,
5329 x_child_support_paid,
5330 x_med_dent_expenses,
5331 x_vet_us,
5332 x_vet_ben_amount,
5333 x_vet_ben_months,
5334 x_stu_summer_wages,
5335 x_stu_school_yr_wages,
5336 x_spouse_summer_wages,
5337 x_spouse_school_yr_wages,
5338 x_summer_other_tax_inc,
5339 x_school_yr_other_tax_inc,
5340 x_summer_untax_inc,
5341 x_school_yr_untax_inc,
5342 x_grants_schol_etc,
5343 x_tuit_benefits,
5344 x_cont_parents,
5345 x_cont_relatives,
5346 x_p_siblings_pre_tuit,
5347 x_p_student_pre_tuit,
5348 x_p_household_size,
5349 x_p_number_in_college,
5350 x_p_parents_in_college,
5351 x_p_marital_status,
5352 x_p_state_legal_residence,
5353 x_p_natural_par_status,
5354 x_p_child_supp_paid,
5355 x_p_repay_ed_loans,
5356 x_p_med_dent_expenses,
5357 x_p_tuit_paid_amount,
5358 x_p_tuit_paid_number,
5359 x_p_exp_child_supp_paid,
5360 x_p_exp_repay_ed_loans,
5361 x_p_exp_med_dent_expenses,
5362 x_p_exp_tuit_pd_amount,
5363 x_p_exp_tuit_pd_number,
5364 x_p_cash_sav_check,
5365 x_p_month_mortgage_pay,
5366 x_p_invest_value,
5367 x_p_invest_debt,
5368 x_p_home_value,
5369 x_p_home_debt,
5370 x_p_home_purch_price,
5371 x_p_own_business_farm,
5372 x_p_business_value,
5373 x_p_business_debt,
5374 x_p_farm_value,
5375 x_p_farm_debt,
5376 x_p_live_on_farm,
5377 x_p_oth_real_estate_value,
5378 x_p_oth_real_estate_debt,
5379 x_p_oth_real_purch_price,
5380 x_p_siblings_assets,
5381 x_p_home_purch_year,
5382 x_p_oth_real_purch_year,
5383 x_p_prior_agi,
5384 x_p_prior_us_tax_paid,
5385 x_p_prior_item_deductions,
5386 x_p_prior_other_untax_inc,
5387 x_p_tax_figures,
5388 x_p_number_exemptions,
5389 x_p_adjusted_gross_inc,
5390 x_p_wages_sal_tips,
5391 x_p_interest_income,
5392 x_p_dividend_income,
5393 x_p_net_inc_bus_farm,
5394 x_p_other_taxable_income,
5395 x_p_adj_to_income,
5396 x_p_us_tax_paid,
5397 x_p_itemized_deductions,
5398 x_p_father_income_work,
5399 x_p_mother_income_work,
5400 x_p_soc_sec_ben,
5401 x_p_welfare_tanf,
5402 x_p_child_supp_rcvd,
5403 x_p_ded_ira_keogh,
5404 x_p_tax_defer_pens_savs,
5405 x_p_dep_care_med_spending,
5406 x_p_earned_income_credit,
5407 x_p_living_allow,
5408 x_p_tax_exmpt_int,
5409 x_p_foreign_inc_excl,
5410 x_p_other_untax_inc,
5411 x_p_hope_ll_credit,
5412 x_p_yr_separation,
5413 x_p_yr_divorce,
5414 x_p_exp_father_inc,
5415 x_p_exp_mother_inc,
5416 x_p_exp_other_tax_inc,
5417 x_p_exp_other_untax_inc,
5418 x_line_2_relation,
5419 x_line_2_attend_college,
5420 x_line_3_relation,
5421 x_line_3_attend_college,
5422 x_line_4_relation,
5423 x_line_4_attend_college,
5424 x_line_5_relation,
5425 x_line_5_attend_college,
5426 x_line_6_relation,
5427 x_line_6_attend_college,
5428 x_line_7_relation,
5429 x_line_7_attend_college,
5430 x_line_8_relation,
5431 x_line_8_attend_college,
5432 x_p_age_father,
5433 x_p_age_mother,
5434 x_p_div_sep_ind,
5435 x_b_cont_non_custodial_par,
5436 x_college_type_2,
5437 x_college_type_3,
5438 x_college_type_4,
5439 x_college_type_5,
5440 x_college_type_6,
5441 x_college_type_7,
5442 x_college_type_8,
5443 x_school_code_1,
5444 x_housing_code_1,
5445 x_school_code_2,
5446 x_housing_code_2,
5447 x_school_code_3,
5448 x_housing_code_3,
5449 x_school_code_4,
5450 x_housing_code_4,
5451 x_school_code_5,
5452 x_housing_code_5,
5453 x_school_code_6,
5454 x_housing_code_6,
5455 x_school_code_7,
5456 x_housing_code_7,
5457 x_school_code_8,
5458 x_housing_code_8,
5459 x_school_code_9,
5460 x_housing_code_9,
5461 x_school_code_10,
5462 x_housing_code_10,
5463 x_additional_school_code_1,
5464 x_additional_school_code_2,
5465 x_additional_school_code_3,
5466 x_additional_school_code_4,
5467 x_additional_school_code_5,
5468 x_additional_school_code_6,
5469 x_additional_school_code_7,
5470 x_additional_school_code_8,
5471 x_additional_school_code_9,
5472 x_additional_school_code_10,
5473 x_explanation_spec_circum,
5474 x_signature_student,
5475 x_signature_spouse,
5476 x_signature_father,
5477 x_signature_mother,
5478 x_month_day_completed,
5479 x_year_completed,
5480 x_age_line_2,
5481 x_age_line_3,
5482 x_age_line_4,
5483 x_age_line_5,
5484 x_age_line_6,
5485 x_age_line_7,
5486 x_age_line_8,
5487 x_a_online_signature,
5488 x_question_1_number,
5489 x_question_1_size,
5490 x_question_1_answer,
5491 x_question_2_number,
5492 x_question_2_size,
5493 x_question_2_answer,
5494 x_question_3_number,
5495 x_question_3_size,
5496 x_question_3_answer,
5497 x_question_4_number,
5498 x_question_4_size,
5499 x_question_4_answer,
5500 x_question_5_number,
5501 x_question_5_size,
5502 x_question_5_answer,
5503 x_question_6_number,
5504 x_question_6_size,
5505 x_question_6_answer,
5506 x_question_7_number,
5507 x_question_7_size,
5508 x_question_7_answer,
5509 x_question_8_number,
5510 x_question_8_size,
5511 x_question_8_answer,
5512 x_question_9_number,
5513 x_question_9_size,
5514 x_question_9_answer,
5515 x_question_10_number,
5516 x_question_10_size,
5517 x_question_10_answer,
5518 x_question_11_number,
5519 x_question_11_size,
5520 x_question_11_answer,
5521 x_question_12_number,
5522 x_question_12_size,
5523 x_question_12_answer,
5524 x_question_13_number,
5525 x_question_13_size,
5526 x_question_13_answer,
5527 x_question_14_number,
5528 x_question_14_size,
5529 x_question_14_answer,
5530 x_question_15_number,
5531 x_question_15_size,
5532 x_question_15_answer,
5533 x_question_16_number,
5534 x_question_16_size,
5535 x_question_16_answer,
5536 x_question_17_number,
5537 x_question_17_size,
5538 x_question_17_answer,
5539 x_question_18_number,
5540 x_question_18_size,
5541 x_question_18_answer,
5542 x_question_19_number,
5543 x_question_19_size,
5544 x_question_19_answer,
5545 x_question_20_number,
5546 x_question_20_size,
5547 x_question_20_answer,
5548 x_question_21_number,
5549 x_question_21_size,
5550 x_question_21_answer,
5551 x_question_22_number,
5552 x_question_22_size,
5553 x_question_22_answer,
5554 x_question_23_number,
5555 x_question_23_size,
5556 x_question_23_answer,
5557 x_question_24_number,
5558 x_question_24_size,
5559 x_question_24_answer,
5560 x_question_25_number,
5561 x_question_25_size,
5562 x_question_25_answer,
5563 x_question_26_number,
5564 x_question_26_size,
5565 x_question_26_answer,
5566 x_question_27_number,
5567 x_question_27_size,
5568 x_question_27_answer,
5569 x_question_28_number,
5570 x_question_28_size,
5571 x_question_28_answer,
5572 x_question_29_number,
5573 x_question_29_size,
5574 x_question_29_answer,
5575 x_question_30_number,
5576 x_questions_30_size,
5577 x_question_30_answer,
5578 x_mode
5579 );
5580
5581 END add_row;
5582
5583
5584 PROCEDURE delete_row (
5585 x_rowid IN VARCHAR2
5586 ) AS
5587 /*
5588 || Created By : kkillams
5589 || Created On : 30-MAY-2001
5590 || Purpose : Handles the DELETE DML logic for the table.
5591 || Known limitations, enhancements or remarks :
5592 || Change History :
5593 || Who When What
5594 || (reverse chronological order - newest change first)
5595 */
5596 BEGIN
5597
5598 before_dml (
5599 p_action => 'DELETE',
5600 x_rowid => x_rowid
5601 );
5602
5603 DELETE FROM igf_ap_cs_upd_flags
5604 WHERE rowid = x_rowid;
5605
5606 IF (SQL%NOTFOUND) THEN
5607 RAISE NO_DATA_FOUND;
5608 END IF;
5609
5610 END delete_row;
5611
5612
5613 END igf_ap_cs_upd_flags_pkg;