[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_last_update_date IN DATE DEFAULT NULL,
x_last_updated_by IN NUMBER DEFAULT NULL,
x_last_update_login IN NUMBER DEFAULT NULL,
x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
x_coa_duration_efc_amt IN NUMBER DEFAULT NULL,
x_coa_duration_num IN NUMBER DEFAULT NULL,
x_p_soc_sec_ben_student_amt IN NUMBER DEFAULT NULL,
x_p_tuit_fee_deduct_amt IN NUMBER DEFAULT NULL,
x_stu_lives_with_num IN NUMBER DEFAULT NULL,
x_stu_most_support_from_num IN NUMBER DEFAULT NULL,
x_location_computer_num IN NUMBER DEFAULT NULL
) AS
/*
|| Created By : vivuyyur
|| Created On : 29-MAY-2001
|| Purpose : Initialises the Old and New references for the columns of the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
CURSOR cur_old_ref_values IS
SELECT *
FROM IGF_AP_CSS_PROFILE_ALL
WHERE rowid = x_rowid;
IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
CLOSE cur_old_ref_values;
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
IF (p_action = 'UPDATE') THEN
new_references.creation_date := old_references.creation_date;
new_references.last_update_date := x_last_update_date;
new_references.last_updated_by := x_last_updated_by;
new_references.last_update_login := x_last_update_login;
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
SELECT rowid
FROM igf_ap_css_profile_all
WHERE cssp_id = x_cssp_id
FOR UPDATE NOWAIT;
SELECT rowid
FROM igf_ap_css_profile_all
WHERE ((base_id = x_base_id));
x_last_update_date IN DATE DEFAULT NULL,
x_last_updated_by IN NUMBER DEFAULT NULL,
x_last_update_login IN NUMBER DEFAULT NULL ,
x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
x_coa_duration_efc_amt IN NUMBER DEFAULT NULL,
x_coa_duration_num IN NUMBER DEFAULT NULL,
x_p_soc_sec_ben_student_amt IN NUMBER DEFAULT NULL,
x_p_tuit_fee_deduct_amt IN NUMBER DEFAULT NULL,
x_stu_lives_with_num IN NUMBER DEFAULT NULL,
x_stu_most_support_from_num IN NUMBER DEFAULT NULL,
x_location_computer_num IN NUMBER DEFAULT NULL
) AS
/*
|| Created By : vivuyyur
|| Created On : 29-MAY-2001
|| Purpose : Initialises the columns, Checks Constraints, Calls the
|| Trigger Handlers for the table, before any DML operation.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
BEGIN
set_column_values (
p_action,
x_rowid,
x_cssp_id,
x_base_id,
x_system_record_type,
x_active_profile,
x_college_code,
x_academic_year,
x_stu_record_type,
x_css_id_number,
x_registration_receipt_date,
x_registration_type,
x_application_receipt_date,
x_application_type,
x_original_fnar_compute,
x_revision_fnar_compute_date,
x_electronic_extract_date,
x_institutional_reporting_type,
x_asr_receipt_date,
x_last_name,
x_first_name,
x_middle_initial,
x_address_number_and_street,
x_city,
x_state_mailing,
x_zip_code,
x_s_telephone_number,
x_s_title,
x_date_of_birth,
x_social_security_number,
x_state_legal_residence,
x_foreign_address_indicator,
x_foreign_postal_code,
x_country,
x_financial_aid_status,
x_year_in_college,
x_marital_status,
x_ward_court,
x_legal_dependents_other,
x_household_size,
x_number_in_college,
x_citizenship_status,
x_citizenship_country,
x_visa_classification,
x_tax_figures,
x_number_exemptions,
x_adjusted_gross_inc,
x_us_tax_paid,
x_itemized_deductions,
x_stu_income_work,
x_spouse_income_work,
x_divid_int_inc,
x_soc_sec_benefits,
x_welfare_tanf,
x_child_supp_rcvd,
x_earned_income_credit,
x_other_untax_income,
x_tax_stu_aid,
x_cash_sav_check,
x_ira_keogh,
x_invest_value,
x_invest_debt,
x_home_value,
x_home_debt,
x_oth_real_value,
x_oth_real_debt,
x_bus_farm_value,
x_bus_farm_debt,
x_live_on_farm,
x_home_purch_price,
x_hope_ll_credit,
x_home_purch_year,
x_trust_amount,
x_trust_avail,
x_trust_estab,
x_child_support_paid,
x_med_dent_expenses,
x_vet_us,
x_vet_ben_amount,
x_vet_ben_months,
x_stu_summer_wages,
x_stu_school_yr_wages,
x_spouse_summer_wages,
x_spouse_school_yr_wages,
x_summer_other_tax_inc,
x_school_yr_other_tax_inc,
x_summer_untax_inc,
x_school_yr_untax_inc,
x_grants_schol_etc,
x_tuit_benefits,
x_cont_parents,
x_cont_relatives,
x_p_siblings_pre_tuit,
x_p_student_pre_tuit,
x_p_household_size,
x_p_number_in_college,
x_p_parents_in_college,
x_p_marital_status,
x_p_state_legal_residence,
x_p_natural_par_status,
x_p_child_supp_paid,
x_p_repay_ed_loans,
x_p_med_dent_expenses,
x_p_tuit_paid_amount,
x_p_tuit_paid_number,
x_p_exp_child_supp_paid,
x_p_exp_repay_ed_loans,
x_p_exp_med_dent_expenses,
x_p_exp_tuit_pd_amount,
x_p_exp_tuit_pd_number,
x_p_cash_sav_check,
x_p_month_mortgage_pay,
x_p_invest_value,
x_p_invest_debt,
x_p_home_value,
x_p_home_debt,
x_p_home_purch_price,
x_p_own_business_farm,
x_p_business_value,
x_p_business_debt,
x_p_farm_value,
x_p_farm_debt,
x_p_live_on_farm,
x_p_oth_real_estate_value,
x_p_oth_real_estate_debt,
x_p_oth_real_purch_price,
x_p_siblings_assets,
x_p_home_purch_year,
x_p_oth_real_purch_year,
x_p_prior_agi,
x_p_prior_us_tax_paid,
x_p_prior_item_deductions,
x_p_prior_other_untax_inc,
x_p_tax_figures,
x_p_number_exemptions,
x_p_adjusted_gross_inc,
x_p_wages_sal_tips,
x_p_interest_income,
x_p_dividend_income,
x_p_net_inc_bus_farm,
x_p_other_taxable_income,
x_p_adj_to_income,
x_p_us_tax_paid,
x_p_itemized_deductions,
x_p_father_income_work,
x_p_mother_income_work,
x_p_soc_sec_ben,
x_p_welfare_tanf,
x_p_child_supp_rcvd,
x_p_ded_ira_keogh,
x_p_tax_defer_pens_savs,
x_p_dep_care_med_spending,
x_p_earned_income_credit,
x_p_living_allow,
x_p_tax_exmpt_int,
x_p_foreign_inc_excl,
x_p_other_untax_inc,
x_p_hope_ll_credit,
x_p_yr_separation,
x_p_yr_divorce,
x_p_exp_father_inc,
x_p_exp_mother_inc,
x_p_exp_other_tax_inc,
x_p_exp_other_untax_inc,
x_line_2_relation,
x_line_2_attend_college,
x_line_3_relation,
x_line_3_attend_college,
x_line_4_relation,
x_line_4_attend_college,
x_line_5_relation,
x_line_5_attend_college,
x_line_6_relation,
x_line_6_attend_college,
x_line_7_relation,
x_line_7_attend_college,
x_line_8_relation,
x_line_8_attend_college,
x_p_age_father,
x_p_age_mother,
x_p_div_sep_ind,
x_b_cont_non_custodial_par,
x_college_type_2,
x_college_type_3,
x_college_type_4,
x_college_type_5,
x_college_type_6,
x_college_type_7,
x_college_type_8,
x_school_code_1,
x_housing_code_1,
x_school_code_2,
x_housing_code_2,
x_school_code_3,
x_housing_code_3,
x_school_code_4,
x_housing_code_4,
x_school_code_5,
x_housing_code_5,
x_school_code_6,
x_housing_code_6,
x_school_code_7,
x_housing_code_7,
x_school_code_8,
x_housing_code_8,
x_school_code_9,
x_housing_code_9,
x_school_code_10,
x_housing_code_10,
x_additional_school_code_1,
x_additional_school_code_2,
x_additional_school_code_3,
x_additional_school_code_4,
x_additional_school_code_5,
x_additional_school_code_6,
x_additional_school_code_7,
x_additional_school_code_8,
x_additional_school_code_9,
x_additional_school_code_10,
x_explanation_spec_circum,
x_signature_student,
x_signature_spouse,
x_signature_father,
x_signature_mother,
x_month_day_completed,
x_year_completed,
x_age_line_2,
x_age_line_3,
x_age_line_4,
x_age_line_5,
x_age_line_6,
x_age_line_7,
x_age_line_8,
x_a_online_signature,
x_question_1_number,
x_question_1_size,
x_question_1_answer,
x_question_2_number,
x_question_2_size,
x_question_2_answer,
x_question_3_number,
x_question_3_size,
x_question_3_answer,
x_question_4_number,
x_question_4_size,
x_question_4_answer,
x_question_5_number,
x_question_5_size,
x_question_5_answer,
x_question_6_number,
x_question_6_size,
x_question_6_answer,
x_question_7_number,
x_question_7_size,
x_question_7_answer,
x_question_8_number,
x_question_8_size,
x_question_8_answer,
x_question_9_number,
x_question_9_size,
x_question_9_answer,
x_question_10_number,
x_question_10_size,
x_question_10_answer,
x_question_11_number,
x_question_11_size,
x_question_11_answer,
x_question_12_number,
x_question_12_size,
x_question_12_answer,
x_question_13_number,
x_question_13_size,
x_question_13_answer,
x_question_14_number,
x_question_14_size,
x_question_14_answer,
x_question_15_number,
x_question_15_size,
x_question_15_answer,
x_question_16_number,
x_question_16_size,
x_question_16_answer,
x_question_17_number,
x_question_17_size,
x_question_17_answer,
x_question_18_number,
x_question_18_size,
x_question_18_answer,
x_question_19_number,
x_question_19_size,
x_question_19_answer,
x_question_20_number,
x_question_20_size,
x_question_20_answer,
x_question_21_number,
x_question_21_size,
x_question_21_answer,
x_question_22_number,
x_question_22_size,
x_question_22_answer,
x_question_23_number,
x_question_23_size,
x_question_23_answer,
x_question_24_number,
x_question_24_size,
x_question_24_answer,
x_question_25_number,
x_question_25_size,
x_question_25_answer,
x_question_26_number,
x_question_26_size,
x_question_26_answer,
x_question_27_number,
x_question_27_size,
x_question_27_answer,
x_question_28_number,
x_question_28_size,
x_question_28_answer,
x_question_29_number,
x_question_29_size,
x_question_29_answer,
x_question_30_number,
x_questions_30_size,
x_question_30_answer,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_legacy_record_flag,
x_coa_duration_efc_amt,
x_coa_duration_num,
x_p_soc_sec_ben_student_amt,
x_p_tuit_fee_deduct_amt,
x_stu_lives_with_num,
x_stu_most_support_from_num,
x_location_computer_num
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation(
new_references.cssp_id
)
) THEN
fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to Before Update.
check_parent_existance;
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to Before Delete.
check_child_existance;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation (
new_references.cssp_id
)
) THEN
fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'VALIDATE_DELETE') THEN
check_child_existance;
PROCEDURE insert_row (
x_rowid IN OUT NOCOPY VARCHAR2,
x_cssp_id IN OUT NOCOPY NUMBER,
x_base_id IN NUMBER,
x_system_record_type IN VARCHAR2,
x_active_profile IN VARCHAR2,
x_college_code IN VARCHAR2,
x_academic_year IN VARCHAR2,
x_stu_record_type IN VARCHAR2,
x_css_id_number IN VARCHAR2,
x_registration_receipt_date IN VARCHAR2,
x_registration_type IN VARCHAR2,
x_application_receipt_date IN VARCHAR2,
x_application_type IN VARCHAR2,
x_original_fnar_compute IN VARCHAR2,
x_revision_fnar_compute_date IN VARCHAR2,
x_electronic_extract_date IN VARCHAR2,
x_institutional_reporting_type IN VARCHAR2,
x_asr_receipt_date IN VARCHAR2,
x_last_name IN VARCHAR2,
x_first_name IN VARCHAR2,
x_middle_initial IN VARCHAR2,
x_address_number_and_street IN VARCHAR2,
x_city IN VARCHAR2,
x_state_mailing IN VARCHAR2,
x_zip_code IN VARCHAR2,
x_s_telephone_number IN VARCHAR2,
x_s_title IN VARCHAR2,
x_date_of_birth IN DATE,
x_social_security_number IN VARCHAR2,
x_state_legal_residence IN VARCHAR2,
x_foreign_address_indicator IN VARCHAR2,
x_foreign_postal_code IN VARCHAR2,
x_country IN VARCHAR2,
x_financial_aid_status IN VARCHAR2,
x_year_in_college IN VARCHAR2,
x_marital_status IN VARCHAR2,
x_ward_court IN VARCHAR2,
x_legal_dependents_other IN VARCHAR2,
x_household_size IN NUMBER,
x_number_in_college IN NUMBER,
x_citizenship_status IN VARCHAR2,
x_citizenship_country IN VARCHAR2,
x_visa_classification IN VARCHAR2,
x_tax_figures IN VARCHAR2,
x_number_exemptions IN NUMBER,
x_adjusted_gross_inc IN NUMBER,
x_us_tax_paid IN NUMBER,
x_itemized_deductions IN NUMBER,
x_stu_income_work IN NUMBER,
x_spouse_income_work IN NUMBER,
x_divid_int_inc IN NUMBER,
x_soc_sec_benefits IN NUMBER,
x_welfare_tanf IN NUMBER,
x_child_supp_rcvd IN NUMBER,
x_earned_income_credit IN NUMBER,
x_other_untax_income IN NUMBER,
x_tax_stu_aid IN NUMBER,
x_cash_sav_check IN NUMBER,
x_ira_keogh IN NUMBER,
x_invest_value IN NUMBER,
x_invest_debt IN NUMBER,
x_home_value IN NUMBER,
x_home_debt IN NUMBER,
x_oth_real_value IN NUMBER,
x_oth_real_debt IN NUMBER,
x_bus_farm_value IN NUMBER,
x_bus_farm_debt IN NUMBER,
x_live_on_farm IN VARCHAR2,
x_home_purch_price IN NUMBER,
x_hope_ll_credit IN NUMBER,
x_home_purch_year IN VARCHAR2,
x_trust_amount IN NUMBER,
x_trust_avail IN VARCHAR2,
x_trust_estab IN VARCHAR2,
x_child_support_paid IN NUMBER,
x_med_dent_expenses IN NUMBER,
x_vet_us IN VARCHAR2,
x_vet_ben_amount IN NUMBER,
x_vet_ben_months IN NUMBER,
x_stu_summer_wages IN NUMBER,
x_stu_school_yr_wages IN NUMBER,
x_spouse_summer_wages IN NUMBER,
x_spouse_school_yr_wages IN NUMBER,
x_summer_other_tax_inc IN NUMBER,
x_school_yr_other_tax_inc IN NUMBER,
x_summer_untax_inc IN NUMBER,
x_school_yr_untax_inc IN NUMBER,
x_grants_schol_etc IN NUMBER,
x_tuit_benefits IN NUMBER,
x_cont_parents IN NUMBER,
x_cont_relatives IN NUMBER,
x_p_siblings_pre_tuit IN NUMBER,
x_p_student_pre_tuit IN NUMBER,
x_p_household_size IN NUMBER,
x_p_number_in_college IN NUMBER,
x_p_parents_in_college IN NUMBER,
x_p_marital_status IN VARCHAR2,
x_p_state_legal_residence IN VARCHAR2,
x_p_natural_par_status IN VARCHAR2,
x_p_child_supp_paid IN NUMBER,
x_p_repay_ed_loans IN NUMBER,
x_p_med_dent_expenses IN NUMBER,
x_p_tuit_paid_amount IN NUMBER,
x_p_tuit_paid_number IN NUMBER,
x_p_exp_child_supp_paid IN NUMBER,
x_p_exp_repay_ed_loans IN NUMBER,
x_p_exp_med_dent_expenses IN NUMBER,
x_p_exp_tuit_pd_amount IN NUMBER,
x_p_exp_tuit_pd_number IN NUMBER,
x_p_cash_sav_check IN NUMBER,
x_p_month_mortgage_pay IN NUMBER,
x_p_invest_value IN NUMBER,
x_p_invest_debt IN NUMBER,
x_p_home_value IN NUMBER,
x_p_home_debt IN NUMBER,
x_p_home_purch_price IN NUMBER,
x_p_own_business_farm IN VARCHAR2,
x_p_business_value IN NUMBER,
x_p_business_debt IN NUMBER,
x_p_farm_value IN NUMBER,
x_p_farm_debt IN NUMBER,
x_p_live_on_farm IN NUMBER,
x_p_oth_real_estate_value IN NUMBER,
x_p_oth_real_estate_debt IN NUMBER,
x_p_oth_real_purch_price IN NUMBER,
x_p_siblings_assets IN NUMBER,
x_p_home_purch_year IN VARCHAR2,
x_p_oth_real_purch_year IN VARCHAR2,
x_p_prior_agi IN NUMBER,
x_p_prior_us_tax_paid IN NUMBER,
x_p_prior_item_deductions IN NUMBER,
x_p_prior_other_untax_inc IN NUMBER,
x_p_tax_figures IN NUMBER,
x_p_number_exemptions IN NUMBER,
x_p_adjusted_gross_inc IN NUMBER,
x_p_wages_sal_tips IN NUMBER,
x_p_interest_income IN NUMBER,
x_p_dividend_income IN NUMBER,
x_p_net_inc_bus_farm IN NUMBER,
x_p_other_taxable_income IN NUMBER,
x_p_adj_to_income IN NUMBER,
x_p_us_tax_paid IN NUMBER,
x_p_itemized_deductions IN NUMBER,
x_p_father_income_work IN NUMBER,
x_p_mother_income_work IN NUMBER,
x_p_soc_sec_ben IN NUMBER,
x_p_welfare_tanf IN NUMBER,
x_p_child_supp_rcvd IN NUMBER,
x_p_ded_ira_keogh IN NUMBER,
x_p_tax_defer_pens_savs IN NUMBER,
x_p_dep_care_med_spending IN NUMBER,
x_p_earned_income_credit IN NUMBER,
x_p_living_allow IN NUMBER,
x_p_tax_exmpt_int IN NUMBER,
x_p_foreign_inc_excl IN NUMBER,
x_p_other_untax_inc IN NUMBER,
x_p_hope_ll_credit IN NUMBER,
x_p_yr_separation IN NUMBER,
x_p_yr_divorce IN NUMBER,
x_p_exp_father_inc IN NUMBER,
x_p_exp_mother_inc IN NUMBER,
x_p_exp_other_tax_inc IN NUMBER,
x_p_exp_other_untax_inc IN NUMBER,
x_line_2_relation IN VARCHAR2,
x_line_2_attend_college IN VARCHAR2,
x_line_3_relation IN VARCHAR2,
x_line_3_attend_college IN VARCHAR2,
x_line_4_relation IN VARCHAR2,
x_line_4_attend_college IN VARCHAR2,
x_line_5_relation IN VARCHAR2,
x_line_5_attend_college IN VARCHAR2,
x_line_6_relation IN VARCHAR2,
x_line_6_attend_college IN VARCHAR2,
x_line_7_relation IN VARCHAR2,
x_line_7_attend_college IN VARCHAR2,
x_line_8_relation IN VARCHAR2,
x_line_8_attend_college IN VARCHAR2,
x_p_age_father IN VARCHAR2,
x_p_age_mother IN VARCHAR2,
x_p_div_sep_ind IN VARCHAR2,
x_b_cont_non_custodial_par IN VARCHAR2,
x_college_type_2 IN VARCHAR2,
x_college_type_3 IN VARCHAR2,
x_college_type_4 IN VARCHAR2,
x_college_type_5 IN VARCHAR2,
x_college_type_6 IN VARCHAR2,
x_college_type_7 IN VARCHAR2,
x_college_type_8 IN VARCHAR2,
x_school_code_1 IN VARCHAR2,
x_housing_code_1 IN VARCHAR2,
x_school_code_2 IN VARCHAR2,
x_housing_code_2 IN VARCHAR2,
x_school_code_3 IN VARCHAR2,
x_housing_code_3 IN VARCHAR2,
x_school_code_4 IN VARCHAR2,
x_housing_code_4 IN VARCHAR2,
x_school_code_5 IN VARCHAR2,
x_housing_code_5 IN VARCHAR2,
x_school_code_6 IN VARCHAR2,
x_housing_code_6 IN VARCHAR2,
x_school_code_7 IN VARCHAR2,
x_housing_code_7 IN VARCHAR2,
x_school_code_8 IN VARCHAR2,
x_housing_code_8 IN VARCHAR2,
x_school_code_9 IN VARCHAR2,
x_housing_code_9 IN VARCHAR2,
x_school_code_10 IN VARCHAR2,
x_housing_code_10 IN VARCHAR2,
x_additional_school_code_1 IN VARCHAR2,
x_additional_school_code_2 IN VARCHAR2,
x_additional_school_code_3 IN VARCHAR2,
x_additional_school_code_4 IN VARCHAR2,
x_additional_school_code_5 IN VARCHAR2,
x_additional_school_code_6 IN VARCHAR2,
x_additional_school_code_7 IN VARCHAR2,
x_additional_school_code_8 IN VARCHAR2,
x_additional_school_code_9 IN VARCHAR2,
x_additional_school_code_10 IN VARCHAR2,
x_explanation_spec_circum IN VARCHAR2,
x_signature_student IN VARCHAR2,
x_signature_spouse IN VARCHAR2,
x_signature_father IN VARCHAR2,
x_signature_mother IN VARCHAR2,
x_month_day_completed IN VARCHAR2,
x_year_completed IN VARCHAR2,
x_age_line_2 IN NUMBER,
x_age_line_3 IN NUMBER,
x_age_line_4 IN NUMBER,
x_age_line_5 IN NUMBER,
x_age_line_6 IN NUMBER,
x_age_line_7 IN NUMBER,
x_age_line_8 IN NUMBER,
x_a_online_signature IN VARCHAR2,
x_question_1_number IN VARCHAR2,
x_question_1_size IN NUMBER,
x_question_1_answer IN VARCHAR2,
x_question_2_number IN VARCHAR2,
x_question_2_size IN NUMBER,
x_question_2_answer IN VARCHAR2,
x_question_3_number IN VARCHAR2,
x_question_3_size IN NUMBER,
x_question_3_answer IN VARCHAR2,
x_question_4_number IN VARCHAR2,
x_question_4_size IN NUMBER,
x_question_4_answer IN VARCHAR2,
x_question_5_number IN VARCHAR2,
x_question_5_size IN NUMBER,
x_question_5_answer IN VARCHAR2,
x_question_6_number IN VARCHAR2,
x_question_6_size IN NUMBER,
x_question_6_answer IN VARCHAR2,
x_question_7_number IN VARCHAR2,
x_question_7_size IN NUMBER,
x_question_7_answer IN VARCHAR2,
x_question_8_number IN VARCHAR2,
x_question_8_size IN NUMBER,
x_question_8_answer IN VARCHAR2,
x_question_9_number IN VARCHAR2,
x_question_9_size IN NUMBER,
x_question_9_answer IN VARCHAR2,
x_question_10_number IN VARCHAR2,
x_question_10_size IN NUMBER,
x_question_10_answer IN VARCHAR2,
x_question_11_number IN VARCHAR2,
x_question_11_size IN NUMBER,
x_question_11_answer IN VARCHAR2,
x_question_12_number IN VARCHAR2,
x_question_12_size IN NUMBER,
x_question_12_answer IN VARCHAR2,
x_question_13_number IN VARCHAR2,
x_question_13_size IN NUMBER,
x_question_13_answer IN VARCHAR2,
x_question_14_number IN VARCHAR2,
x_question_14_size IN NUMBER,
x_question_14_answer IN VARCHAR2,
x_question_15_number IN VARCHAR2,
x_question_15_size IN NUMBER,
x_question_15_answer IN VARCHAR2,
x_question_16_number IN VARCHAR2,
x_question_16_size IN NUMBER,
x_question_16_answer IN VARCHAR2,
x_question_17_number IN VARCHAR2,
x_question_17_size IN NUMBER,
x_question_17_answer IN VARCHAR2,
x_question_18_number IN VARCHAR2,
x_question_18_size IN NUMBER,
x_question_18_answer IN VARCHAR2,
x_question_19_number IN VARCHAR2,
x_question_19_size IN NUMBER,
x_question_19_answer IN VARCHAR2,
x_question_20_number IN VARCHAR2,
x_question_20_size IN NUMBER,
x_question_20_answer IN VARCHAR2,
x_question_21_number IN VARCHAR2,
x_question_21_size IN NUMBER,
x_question_21_answer IN VARCHAR2,
x_question_22_number IN VARCHAR2,
x_question_22_size IN NUMBER,
x_question_22_answer IN VARCHAR2,
x_question_23_number IN VARCHAR2,
x_question_23_size IN NUMBER,
x_question_23_answer IN VARCHAR2,
x_question_24_number IN VARCHAR2,
x_question_24_size IN NUMBER,
x_question_24_answer IN VARCHAR2,
x_question_25_number IN VARCHAR2,
x_question_25_size IN NUMBER,
x_question_25_answer IN VARCHAR2,
x_question_26_number IN VARCHAR2,
x_question_26_size IN NUMBER,
x_question_26_answer IN VARCHAR2,
x_question_27_number IN VARCHAR2,
x_question_27_size IN NUMBER,
x_question_27_answer IN VARCHAR2,
x_question_28_number IN VARCHAR2,
x_question_28_size IN NUMBER,
x_question_28_answer IN VARCHAR2,
x_question_29_number IN VARCHAR2,
x_question_29_size IN NUMBER,
x_question_29_answer IN VARCHAR2,
x_question_30_number IN VARCHAR2,
x_questions_30_size IN NUMBER,
x_question_30_answer IN VARCHAR2,
x_mode IN VARCHAR2 DEFAULT 'R' ,
x_legacy_record_flag IN VARCHAR2,
x_coa_duration_efc_amt IN NUMBER,
x_coa_duration_num IN NUMBER,
x_p_soc_sec_ben_student_amt IN NUMBER,
x_p_tuit_fee_deduct_amt IN NUMBER,
x_stu_lives_with_num IN NUMBER,
x_stu_most_support_from_num IN NUMBER,
x_location_computer_num IN NUMBER
) AS
/*
|| Created By : vivuyyur
|| Created On : 29-MAY-2001
|| Purpose : Handles the INSERT DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
CURSOR c IS
SELECT rowid
FROM igf_ap_css_profile_all
WHERE cssp_id = x_cssp_id;
x_last_update_date DATE;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
x_last_update_date := SYSDATE;
x_last_updated_by := 1;
x_last_update_login := 0;
x_last_updated_by := fnd_global.user_id;
IF (x_last_updated_by IS NULL) THEN
x_last_updated_by := -1;
x_last_update_login := fnd_global.login_id;
IF (x_last_update_login IS NULL) THEN
x_last_update_login := -1;
SELECT igf_ap_css_profile_all_s.NEXTVAL
INTO x_cssp_id
FROM dual;
p_action => 'INSERT',
x_rowid => x_rowid,
x_cssp_id => x_cssp_id,
x_base_id => x_base_id,
x_system_record_type => x_system_record_type,
x_active_profile => x_active_profile,
x_college_code => x_college_code,
x_academic_year => x_academic_year,
x_stu_record_type => x_stu_record_type,
x_css_id_number => x_css_id_number,
x_registration_receipt_date => x_registration_receipt_date,
x_registration_type => x_registration_type,
x_application_receipt_date => x_application_receipt_date,
x_application_type => x_application_type,
x_original_fnar_compute => x_original_fnar_compute,
x_revision_fnar_compute_date => x_revision_fnar_compute_date,
x_electronic_extract_date => x_electronic_extract_date,
x_institutional_reporting_type => x_institutional_reporting_type,
x_asr_receipt_date => x_asr_receipt_date,
x_last_name => x_last_name,
x_first_name => x_first_name,
x_middle_initial => x_middle_initial,
x_address_number_and_street => x_address_number_and_street,
x_city => x_city,
x_state_mailing => x_state_mailing,
x_zip_code => x_zip_code,
x_s_telephone_number => x_s_telephone_number,
x_s_title => x_s_title,
x_date_of_birth => x_date_of_birth,
x_social_security_number => x_social_security_number,
x_state_legal_residence => x_state_legal_residence,
x_foreign_address_indicator => x_foreign_address_indicator,
x_foreign_postal_code => x_foreign_postal_code,
x_country => x_country,
x_financial_aid_status => x_financial_aid_status,
x_year_in_college => x_year_in_college,
x_marital_status => x_marital_status,
x_ward_court => x_ward_court,
x_legal_dependents_other => x_legal_dependents_other,
x_household_size => x_household_size,
x_number_in_college => x_number_in_college,
x_citizenship_status => x_citizenship_status,
x_citizenship_country => x_citizenship_country,
x_visa_classification => x_visa_classification,
x_tax_figures => x_tax_figures,
x_number_exemptions => x_number_exemptions,
x_adjusted_gross_inc => x_adjusted_gross_inc,
x_us_tax_paid => x_us_tax_paid,
x_itemized_deductions => x_itemized_deductions,
x_stu_income_work => x_stu_income_work,
x_spouse_income_work => x_spouse_income_work,
x_divid_int_inc => x_divid_int_inc,
x_soc_sec_benefits => x_soc_sec_benefits,
x_welfare_tanf => x_welfare_tanf,
x_child_supp_rcvd => x_child_supp_rcvd,
x_earned_income_credit => x_earned_income_credit,
x_other_untax_income => x_other_untax_income,
x_tax_stu_aid => x_tax_stu_aid,
x_cash_sav_check => x_cash_sav_check,
x_ira_keogh => x_ira_keogh,
x_invest_value => x_invest_value,
x_invest_debt => x_invest_debt,
x_home_value => x_home_value,
x_home_debt => x_home_debt,
x_oth_real_value => x_oth_real_value,
x_oth_real_debt => x_oth_real_debt,
x_bus_farm_value => x_bus_farm_value,
x_bus_farm_debt => x_bus_farm_debt,
x_live_on_farm => x_live_on_farm,
x_home_purch_price => x_home_purch_price,
x_hope_ll_credit => x_hope_ll_credit,
x_home_purch_year => x_home_purch_year,
x_trust_amount => x_trust_amount,
x_trust_avail => x_trust_avail,
x_trust_estab => x_trust_estab,
x_child_support_paid => x_child_support_paid,
x_med_dent_expenses => x_med_dent_expenses,
x_vet_us => x_vet_us,
x_vet_ben_amount => x_vet_ben_amount,
x_vet_ben_months => x_vet_ben_months,
x_stu_summer_wages => x_stu_summer_wages,
x_stu_school_yr_wages => x_stu_school_yr_wages,
x_spouse_summer_wages => x_spouse_summer_wages,
x_spouse_school_yr_wages => x_spouse_school_yr_wages,
x_summer_other_tax_inc => x_summer_other_tax_inc,
x_school_yr_other_tax_inc => x_school_yr_other_tax_inc,
x_summer_untax_inc => x_summer_untax_inc,
x_school_yr_untax_inc => x_school_yr_untax_inc,
x_grants_schol_etc => x_grants_schol_etc,
x_tuit_benefits => x_tuit_benefits,
x_cont_parents => x_cont_parents,
x_cont_relatives => x_cont_relatives,
x_p_siblings_pre_tuit => x_p_siblings_pre_tuit,
x_p_student_pre_tuit => x_p_student_pre_tuit,
x_p_household_size => x_p_household_size,
x_p_number_in_college => x_p_number_in_college,
x_p_parents_in_college => x_p_parents_in_college,
x_p_marital_status => x_p_marital_status,
x_p_state_legal_residence => x_p_state_legal_residence,
x_p_natural_par_status => x_p_natural_par_status,
x_p_child_supp_paid => x_p_child_supp_paid,
x_p_repay_ed_loans => x_p_repay_ed_loans,
x_p_med_dent_expenses => x_p_med_dent_expenses,
x_p_tuit_paid_amount => x_p_tuit_paid_amount,
x_p_tuit_paid_number => x_p_tuit_paid_number,
x_p_exp_child_supp_paid => x_p_exp_child_supp_paid,
x_p_exp_repay_ed_loans => x_p_exp_repay_ed_loans,
x_p_exp_med_dent_expenses => x_p_exp_med_dent_expenses,
x_p_exp_tuit_pd_amount => x_p_exp_tuit_pd_amount,
x_p_exp_tuit_pd_number => x_p_exp_tuit_pd_number,
x_p_cash_sav_check => x_p_cash_sav_check,
x_p_month_mortgage_pay => x_p_month_mortgage_pay,
x_p_invest_value => x_p_invest_value,
x_p_invest_debt => x_p_invest_debt,
x_p_home_value => x_p_home_value,
x_p_home_debt => x_p_home_debt,
x_p_home_purch_price => x_p_home_purch_price,
x_p_own_business_farm => x_p_own_business_farm,
x_p_business_value => x_p_business_value,
x_p_business_debt => x_p_business_debt,
x_p_farm_value => x_p_farm_value,
x_p_farm_debt => x_p_farm_debt,
x_p_live_on_farm => x_p_live_on_farm,
x_p_oth_real_estate_value => x_p_oth_real_estate_value,
x_p_oth_real_estate_debt => x_p_oth_real_estate_debt,
x_p_oth_real_purch_price => x_p_oth_real_purch_price,
x_p_siblings_assets => x_p_siblings_assets,
x_p_home_purch_year => x_p_home_purch_year,
x_p_oth_real_purch_year => x_p_oth_real_purch_year,
x_p_prior_agi => x_p_prior_agi,
x_p_prior_us_tax_paid => x_p_prior_us_tax_paid,
x_p_prior_item_deductions => x_p_prior_item_deductions,
x_p_prior_other_untax_inc => x_p_prior_other_untax_inc,
x_p_tax_figures => x_p_tax_figures,
x_p_number_exemptions => x_p_number_exemptions,
x_p_adjusted_gross_inc => x_p_adjusted_gross_inc,
x_p_wages_sal_tips => x_p_wages_sal_tips,
x_p_interest_income => x_p_interest_income,
x_p_dividend_income => x_p_dividend_income,
x_p_net_inc_bus_farm => x_p_net_inc_bus_farm,
x_p_other_taxable_income => x_p_other_taxable_income,
x_p_adj_to_income => x_p_adj_to_income,
x_p_us_tax_paid => x_p_us_tax_paid,
x_p_itemized_deductions => x_p_itemized_deductions,
x_p_father_income_work => x_p_father_income_work,
x_p_mother_income_work => x_p_mother_income_work,
x_p_soc_sec_ben => x_p_soc_sec_ben,
x_p_welfare_tanf => x_p_welfare_tanf,
x_p_child_supp_rcvd => x_p_child_supp_rcvd,
x_p_ded_ira_keogh => x_p_ded_ira_keogh,
x_p_tax_defer_pens_savs => x_p_tax_defer_pens_savs,
x_p_dep_care_med_spending => x_p_dep_care_med_spending,
x_p_earned_income_credit => x_p_earned_income_credit,
x_p_living_allow => x_p_living_allow,
x_p_tax_exmpt_int => x_p_tax_exmpt_int,
x_p_foreign_inc_excl => x_p_foreign_inc_excl,
x_p_other_untax_inc => x_p_other_untax_inc,
x_p_hope_ll_credit => x_p_hope_ll_credit,
x_p_yr_separation => x_p_yr_separation,
x_p_yr_divorce => x_p_yr_divorce,
x_p_exp_father_inc => x_p_exp_father_inc,
x_p_exp_mother_inc => x_p_exp_mother_inc,
x_p_exp_other_tax_inc => x_p_exp_other_tax_inc,
x_p_exp_other_untax_inc => x_p_exp_other_untax_inc,
x_line_2_relation => x_line_2_relation,
x_line_2_attend_college => x_line_2_attend_college,
x_line_3_relation => x_line_3_relation,
x_line_3_attend_college => x_line_3_attend_college,
x_line_4_relation => x_line_4_relation,
x_line_4_attend_college => x_line_4_attend_college,
x_line_5_relation => x_line_5_relation,
x_line_5_attend_college => x_line_5_attend_college,
x_line_6_relation => x_line_6_relation,
x_line_6_attend_college => x_line_6_attend_college,
x_line_7_relation => x_line_7_relation,
x_line_7_attend_college => x_line_7_attend_college,
x_line_8_relation => x_line_8_relation,
x_line_8_attend_college => x_line_8_attend_college,
x_p_age_father => x_p_age_father,
x_p_age_mother => x_p_age_mother,
x_p_div_sep_ind => x_p_div_sep_ind,
x_b_cont_non_custodial_par => x_b_cont_non_custodial_par,
x_college_type_2 => x_college_type_2,
x_college_type_3 => x_college_type_3,
x_college_type_4 => x_college_type_4,
x_college_type_5 => x_college_type_5,
x_college_type_6 => x_college_type_6,
x_college_type_7 => x_college_type_7,
x_college_type_8 => x_college_type_8,
x_school_code_1 => x_school_code_1,
x_housing_code_1 => x_housing_code_1,
x_school_code_2 => x_school_code_2,
x_housing_code_2 => x_housing_code_2,
x_school_code_3 => x_school_code_3,
x_housing_code_3 => x_housing_code_3,
x_school_code_4 => x_school_code_4,
x_housing_code_4 => x_housing_code_4,
x_school_code_5 => x_school_code_5,
x_housing_code_5 => x_housing_code_5,
x_school_code_6 => x_school_code_6,
x_housing_code_6 => x_housing_code_6,
x_school_code_7 => x_school_code_7,
x_housing_code_7 => x_housing_code_7,
x_school_code_8 => x_school_code_8,
x_housing_code_8 => x_housing_code_8,
x_school_code_9 => x_school_code_9,
x_housing_code_9 => x_housing_code_9,
x_school_code_10 => x_school_code_10,
x_housing_code_10 => x_housing_code_10,
x_additional_school_code_1 => x_additional_school_code_1,
x_additional_school_code_2 => x_additional_school_code_2,
x_additional_school_code_3 => x_additional_school_code_3,
x_additional_school_code_4 => x_additional_school_code_4,
x_additional_school_code_5 => x_additional_school_code_5,
x_additional_school_code_6 => x_additional_school_code_6,
x_additional_school_code_7 => x_additional_school_code_7,
x_additional_school_code_8 => x_additional_school_code_8,
x_additional_school_code_9 => x_additional_school_code_9,
x_additional_school_code_10 => x_additional_school_code_10,
x_explanation_spec_circum => x_explanation_spec_circum,
x_signature_student => x_signature_student,
x_signature_spouse => x_signature_spouse,
x_signature_father => x_signature_father,
x_signature_mother => x_signature_mother,
x_month_day_completed => x_month_day_completed,
x_year_completed => x_year_completed,
x_age_line_2 => x_age_line_2,
x_age_line_3 => x_age_line_3,
x_age_line_4 => x_age_line_4,
x_age_line_5 => x_age_line_5,
x_age_line_6 => x_age_line_6,
x_age_line_7 => x_age_line_7,
x_age_line_8 => x_age_line_8,
x_a_online_signature => x_a_online_signature,
x_question_1_number => x_question_1_number,
x_question_1_size => x_question_1_size,
x_question_1_answer => x_question_1_answer,
x_question_2_number => x_question_2_number,
x_question_2_size => x_question_2_size,
x_question_2_answer => x_question_2_answer,
x_question_3_number => x_question_3_number,
x_question_3_size => x_question_3_size,
x_question_3_answer => x_question_3_answer,
x_question_4_number => x_question_4_number,
x_question_4_size => x_question_4_size,
x_question_4_answer => x_question_4_answer,
x_question_5_number => x_question_5_number,
x_question_5_size => x_question_5_size,
x_question_5_answer => x_question_5_answer,
x_question_6_number => x_question_6_number,
x_question_6_size => x_question_6_size,
x_question_6_answer => x_question_6_answer,
x_question_7_number => x_question_7_number,
x_question_7_size => x_question_7_size,
x_question_7_answer => x_question_7_answer,
x_question_8_number => x_question_8_number,
x_question_8_size => x_question_8_size,
x_question_8_answer => x_question_8_answer,
x_question_9_number => x_question_9_number,
x_question_9_size => x_question_9_size,
x_question_9_answer => x_question_9_answer,
x_question_10_number => x_question_10_number,
x_question_10_size => x_question_10_size,
x_question_10_answer => x_question_10_answer,
x_question_11_number => x_question_11_number,
x_question_11_size => x_question_11_size,
x_question_11_answer => x_question_11_answer,
x_question_12_number => x_question_12_number,
x_question_12_size => x_question_12_size,
x_question_12_answer => x_question_12_answer,
x_question_13_number => x_question_13_number,
x_question_13_size => x_question_13_size,
x_question_13_answer => x_question_13_answer,
x_question_14_number => x_question_14_number,
x_question_14_size => x_question_14_size,
x_question_14_answer => x_question_14_answer,
x_question_15_number => x_question_15_number,
x_question_15_size => x_question_15_size,
x_question_15_answer => x_question_15_answer,
x_question_16_number => x_question_16_number,
x_question_16_size => x_question_16_size,
x_question_16_answer => x_question_16_answer,
x_question_17_number => x_question_17_number,
x_question_17_size => x_question_17_size,
x_question_17_answer => x_question_17_answer,
x_question_18_number => x_question_18_number,
x_question_18_size => x_question_18_size,
x_question_18_answer => x_question_18_answer,
x_question_19_number => x_question_19_number,
x_question_19_size => x_question_19_size,
x_question_19_answer => x_question_19_answer,
x_question_20_number => x_question_20_number,
x_question_20_size => x_question_20_size,
x_question_20_answer => x_question_20_answer,
x_question_21_number => x_question_21_number,
x_question_21_size => x_question_21_size,
x_question_21_answer => x_question_21_answer,
x_question_22_number => x_question_22_number,
x_question_22_size => x_question_22_size,
x_question_22_answer => x_question_22_answer,
x_question_23_number => x_question_23_number,
x_question_23_size => x_question_23_size,
x_question_23_answer => x_question_23_answer,
x_question_24_number => x_question_24_number,
x_question_24_size => x_question_24_size,
x_question_24_answer => x_question_24_answer,
x_question_25_number => x_question_25_number,
x_question_25_size => x_question_25_size,
x_question_25_answer => x_question_25_answer,
x_question_26_number => x_question_26_number,
x_question_26_size => x_question_26_size,
x_question_26_answer => x_question_26_answer,
x_question_27_number => x_question_27_number,
x_question_27_size => x_question_27_size,
x_question_27_answer => x_question_27_answer,
x_question_28_number => x_question_28_number,
x_question_28_size => x_question_28_size,
x_question_28_answer => x_question_28_answer,
x_question_29_number => x_question_29_number,
x_question_29_size => x_question_29_size,
x_question_29_answer => x_question_29_answer,
x_question_30_number => x_question_30_number,
x_questions_30_size => x_questions_30_size,
x_question_30_answer => x_question_30_answer,
x_creation_date => x_last_update_date,
x_created_by => x_last_updated_by,
x_last_update_date => x_last_update_date,
x_last_updated_by => x_last_updated_by,
x_last_update_login => x_last_update_login,
x_legacy_record_flag => x_legacy_record_flag,
x_coa_duration_efc_amt => x_coa_duration_efc_amt,
x_coa_duration_num => x_coa_duration_num,
x_p_soc_sec_ben_student_amt => x_p_soc_sec_ben_student_amt,
x_p_tuit_fee_deduct_amt => x_p_tuit_fee_deduct_amt,
x_stu_lives_with_num => x_stu_lives_with_num,
x_stu_most_support_from_num => x_stu_most_support_from_num,
x_location_computer_num => x_location_computer_num
);
INSERT INTO igf_ap_css_profile_all (
cssp_id,
org_id,
base_id,
system_record_type,
active_profile,
college_code,
academic_year,
stu_record_type,
css_id_number,
registration_receipt_date,
registration_type,
application_receipt_date,
application_type,
original_fnar_compute,
revision_fnar_compute_date,
electronic_extract_date,
institutional_reporting_type,
asr_receipt_date,
last_name,
first_name,
middle_initial,
address_number_and_street,
city,
state_mailing,
zip_code,
s_telephone_number,
s_title,
date_of_birth,
social_security_number,
state_legal_residence,
foreign_address_indicator,
foreign_postal_code,
country,
financial_aid_status,
year_in_college,
marital_status,
ward_court,
legal_dependents_other,
household_size,
number_in_college,
citizenship_status,
citizenship_country,
visa_classification,
tax_figures,
number_exemptions,
adjusted_gross_inc,
us_tax_paid,
itemized_deductions,
stu_income_work,
spouse_income_work,
divid_int_inc,
soc_sec_benefits,
welfare_tanf,
child_supp_rcvd,
earned_income_credit,
other_untax_income,
tax_stu_aid,
cash_sav_check,
ira_keogh,
invest_value,
invest_debt,
home_value,
home_debt,
oth_real_value,
oth_real_debt,
bus_farm_value,
bus_farm_debt,
live_on_farm,
home_purch_price,
hope_ll_credit,
home_purch_year,
trust_amount,
trust_avail,
trust_estab,
child_support_paid,
med_dent_expenses,
vet_us,
vet_ben_amount,
vet_ben_months,
stu_summer_wages,
stu_school_yr_wages,
spouse_summer_wages,
spouse_school_yr_wages,
summer_other_tax_inc,
school_yr_other_tax_inc,
summer_untax_inc,
school_yr_untax_inc,
grants_schol_etc,
tuit_benefits,
cont_parents,
cont_relatives,
p_siblings_pre_tuit,
p_student_pre_tuit,
p_household_size,
p_number_in_college,
p_parents_in_college,
p_marital_status,
p_state_legal_residence,
p_natural_par_status,
p_child_supp_paid,
p_repay_ed_loans,
p_med_dent_expenses,
p_tuit_paid_amount,
p_tuit_paid_number,
p_exp_child_supp_paid,
p_exp_repay_ed_loans,
p_exp_med_dent_expenses,
p_exp_tuit_pd_amount,
p_exp_tuit_pd_number,
p_cash_sav_check,
p_month_mortgage_pay,
p_invest_value,
p_invest_debt,
p_home_value,
p_home_debt,
p_home_purch_price,
p_own_business_farm,
p_business_value,
p_business_debt,
p_farm_value,
p_farm_debt,
p_live_on_farm,
p_oth_real_estate_value,
p_oth_real_estate_debt,
p_oth_real_purch_price,
p_siblings_assets,
p_home_purch_year,
p_oth_real_purch_year,
p_prior_agi,
p_prior_us_tax_paid,
p_prior_item_deductions,
p_prior_other_untax_inc,
p_tax_figures,
p_number_exemptions,
p_adjusted_gross_inc,
p_wages_sal_tips,
p_interest_income,
p_dividend_income,
p_net_inc_bus_farm,
p_other_taxable_income,
p_adj_to_income,
p_us_tax_paid,
p_itemized_deductions,
p_father_income_work,
p_mother_income_work,
p_soc_sec_ben,
p_welfare_tanf,
p_child_supp_rcvd,
p_ded_ira_keogh,
p_tax_defer_pens_savs,
p_dep_care_med_spending,
p_earned_income_credit,
p_living_allow,
p_tax_exmpt_int,
p_foreign_inc_excl,
p_other_untax_inc,
p_hope_ll_credit,
p_yr_separation,
p_yr_divorce,
p_exp_father_inc,
p_exp_mother_inc,
p_exp_other_tax_inc,
p_exp_other_untax_inc,
line_2_relation,
line_2_attend_college,
line_3_relation,
line_3_attend_college,
line_4_relation,
line_4_attend_college,
line_5_relation,
line_5_attend_college,
line_6_relation,
line_6_attend_college,
line_7_relation,
line_7_attend_college,
line_8_relation,
line_8_attend_college,
p_age_father,
p_age_mother,
p_div_sep_ind,
b_cont_non_custodial_par,
college_type_2,
college_type_3,
college_type_4,
college_type_5,
college_type_6,
college_type_7,
college_type_8,
school_code_1,
housing_code_1,
school_code_2,
housing_code_2,
school_code_3,
housing_code_3,
school_code_4,
housing_code_4,
school_code_5,
housing_code_5,
school_code_6,
housing_code_6,
school_code_7,
housing_code_7,
school_code_8,
housing_code_8,
school_code_9,
housing_code_9,
school_code_10,
housing_code_10,
additional_school_code_1,
additional_school_code_2,
additional_school_code_3,
additional_school_code_4,
additional_school_code_5,
additional_school_code_6,
additional_school_code_7,
additional_school_code_8,
additional_school_code_9,
additional_school_code_10,
explanation_spec_circum,
signature_student,
signature_spouse,
signature_father,
signature_mother,
month_day_completed,
year_completed,
age_line_2,
age_line_3,
age_line_4,
age_line_5,
age_line_6,
age_line_7,
age_line_8,
a_online_signature,
question_1_number,
question_1_size,
question_1_answer,
question_2_number,
question_2_size,
question_2_answer,
question_3_number,
question_3_size,
question_3_answer,
question_4_number,
question_4_size,
question_4_answer,
question_5_number,
question_5_size,
question_5_answer,
question_6_number,
question_6_size,
question_6_answer,
question_7_number,
question_7_size,
question_7_answer,
question_8_number,
question_8_size,
question_8_answer,
question_9_number,
question_9_size,
question_9_answer,
question_10_number,
question_10_size,
question_10_answer,
question_11_number,
question_11_size,
question_11_answer,
question_12_number,
question_12_size,
question_12_answer,
question_13_number,
question_13_size,
question_13_answer,
question_14_number,
question_14_size,
question_14_answer,
question_15_number,
question_15_size,
question_15_answer,
question_16_number,
question_16_size,
question_16_answer,
question_17_number,
question_17_size,
question_17_answer,
question_18_number,
question_18_size,
question_18_answer,
question_19_number,
question_19_size,
question_19_answer,
question_20_number,
question_20_size,
question_20_answer,
question_21_number,
question_21_size,
question_21_answer,
question_22_number,
question_22_size,
question_22_answer,
question_23_number,
question_23_size,
question_23_answer,
question_24_number,
question_24_size,
question_24_answer,
question_25_number,
question_25_size,
question_25_answer,
question_26_number,
question_26_size,
question_26_answer,
question_27_number,
question_27_size,
question_27_answer,
question_28_number,
question_28_size,
question_28_answer,
question_29_number,
question_29_size,
question_29_answer,
question_30_number,
questions_30_size,
question_30_answer,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
legacy_record_flag,
coa_duration_efc_amt,
coa_duration_num,
p_soc_sec_ben_student_amt,
p_tuit_fee_deduct_amt,
stu_lives_with_num,
stu_most_support_from_num,
location_computer_num
) VALUES (
new_references.cssp_id,
new_references.org_id,
new_references.base_id,
new_references.system_record_type,
new_references.active_profile,
new_references.college_code,
new_references.academic_year,
new_references.stu_record_type,
new_references.css_id_number,
new_references.registration_receipt_date,
new_references.registration_type,
new_references.application_receipt_date,
new_references.application_type,
new_references.original_fnar_compute,
new_references.revision_fnar_compute_date,
new_references.electronic_extract_date,
new_references.institutional_reporting_type,
new_references.asr_receipt_date,
new_references.last_name,
new_references.first_name,
new_references.middle_initial,
new_references.address_number_and_street,
new_references.city,
new_references.state_mailing,
new_references.zip_code,
new_references.s_telephone_number,
new_references.s_title,
new_references.date_of_birth,
new_references.social_security_number,
new_references.state_legal_residence,
new_references.foreign_address_indicator,
new_references.foreign_postal_code,
new_references.country,
new_references.financial_aid_status,
new_references.year_in_college,
new_references.marital_status,
new_references.ward_court,
new_references.legal_dependents_other,
new_references.household_size,
new_references.number_in_college,
new_references.citizenship_status,
new_references.citizenship_country,
new_references.visa_classification,
new_references.tax_figures,
new_references.number_exemptions,
new_references.adjusted_gross_inc,
new_references.us_tax_paid,
new_references.itemized_deductions,
new_references.stu_income_work,
new_references.spouse_income_work,
new_references.divid_int_inc,
new_references.soc_sec_benefits,
new_references.welfare_tanf,
new_references.child_supp_rcvd,
new_references.earned_income_credit,
new_references.other_untax_income,
new_references.tax_stu_aid,
new_references.cash_sav_check,
new_references.ira_keogh,
new_references.invest_value,
new_references.invest_debt,
new_references.home_value,
new_references.home_debt,
new_references.oth_real_value,
new_references.oth_real_debt,
new_references.bus_farm_value,
new_references.bus_farm_debt,
new_references.live_on_farm,
new_references.home_purch_price,
new_references.hope_ll_credit,
new_references.home_purch_year,
new_references.trust_amount,
new_references.trust_avail,
new_references.trust_estab,
new_references.child_support_paid,
new_references.med_dent_expenses,
new_references.vet_us,
new_references.vet_ben_amount,
new_references.vet_ben_months,
new_references.stu_summer_wages,
new_references.stu_school_yr_wages,
new_references.spouse_summer_wages,
new_references.spouse_school_yr_wages,
new_references.summer_other_tax_inc,
new_references.school_yr_other_tax_inc,
new_references.summer_untax_inc,
new_references.school_yr_untax_inc,
new_references.grants_schol_etc,
new_references.tuit_benefits,
new_references.cont_parents,
new_references.cont_relatives,
new_references.p_siblings_pre_tuit,
new_references.p_student_pre_tuit,
new_references.p_household_size,
new_references.p_number_in_college,
new_references.p_parents_in_college,
new_references.p_marital_status,
new_references.p_state_legal_residence,
new_references.p_natural_par_status,
new_references.p_child_supp_paid,
new_references.p_repay_ed_loans,
new_references.p_med_dent_expenses,
new_references.p_tuit_paid_amount,
new_references.p_tuit_paid_number,
new_references.p_exp_child_supp_paid,
new_references.p_exp_repay_ed_loans,
new_references.p_exp_med_dent_expenses,
new_references.p_exp_tuit_pd_amount,
new_references.p_exp_tuit_pd_number,
new_references.p_cash_sav_check,
new_references.p_month_mortgage_pay,
new_references.p_invest_value,
new_references.p_invest_debt,
new_references.p_home_value,
new_references.p_home_debt,
new_references.p_home_purch_price,
new_references.p_own_business_farm,
new_references.p_business_value,
new_references.p_business_debt,
new_references.p_farm_value,
new_references.p_farm_debt,
new_references.p_live_on_farm,
new_references.p_oth_real_estate_value,
new_references.p_oth_real_estate_debt,
new_references.p_oth_real_purch_price,
new_references.p_siblings_assets,
new_references.p_home_purch_year,
new_references.p_oth_real_purch_year,
new_references.p_prior_agi,
new_references.p_prior_us_tax_paid,
new_references.p_prior_item_deductions,
new_references.p_prior_other_untax_inc,
new_references.p_tax_figures,
new_references.p_number_exemptions,
new_references.p_adjusted_gross_inc,
new_references.p_wages_sal_tips,
new_references.p_interest_income,
new_references.p_dividend_income,
new_references.p_net_inc_bus_farm,
new_references.p_other_taxable_income,
new_references.p_adj_to_income,
new_references.p_us_tax_paid,
new_references.p_itemized_deductions,
new_references.p_father_income_work,
new_references.p_mother_income_work,
new_references.p_soc_sec_ben,
new_references.p_welfare_tanf,
new_references.p_child_supp_rcvd,
new_references.p_ded_ira_keogh,
new_references.p_tax_defer_pens_savs,
new_references.p_dep_care_med_spending,
new_references.p_earned_income_credit,
new_references.p_living_allow,
new_references.p_tax_exmpt_int,
new_references.p_foreign_inc_excl,
new_references.p_other_untax_inc,
new_references.p_hope_ll_credit,
new_references.p_yr_separation,
new_references.p_yr_divorce,
new_references.p_exp_father_inc,
new_references.p_exp_mother_inc,
new_references.p_exp_other_tax_inc,
new_references.p_exp_other_untax_inc,
new_references.line_2_relation,
new_references.line_2_attend_college,
new_references.line_3_relation,
new_references.line_3_attend_college,
new_references.line_4_relation,
new_references.line_4_attend_college,
new_references.line_5_relation,
new_references.line_5_attend_college,
new_references.line_6_relation,
new_references.line_6_attend_college,
new_references.line_7_relation,
new_references.line_7_attend_college,
new_references.line_8_relation,
new_references.line_8_attend_college,
new_references.p_age_father,
new_references.p_age_mother,
new_references.p_div_sep_ind,
new_references.b_cont_non_custodial_par,
new_references.college_type_2,
new_references.college_type_3,
new_references.college_type_4,
new_references.college_type_5,
new_references.college_type_6,
new_references.college_type_7,
new_references.college_type_8,
new_references.school_code_1,
new_references.housing_code_1,
new_references.school_code_2,
new_references.housing_code_2,
new_references.school_code_3,
new_references.housing_code_3,
new_references.school_code_4,
new_references.housing_code_4,
new_references.school_code_5,
new_references.housing_code_5,
new_references.school_code_6,
new_references.housing_code_6,
new_references.school_code_7,
new_references.housing_code_7,
new_references.school_code_8,
new_references.housing_code_8,
new_references.school_code_9,
new_references.housing_code_9,
new_references.school_code_10,
new_references.housing_code_10,
new_references.additional_school_code_1,
new_references.additional_school_code_2,
new_references.additional_school_code_3,
new_references.additional_school_code_4,
new_references.additional_school_code_5,
new_references.additional_school_code_6,
new_references.additional_school_code_7,
new_references.additional_school_code_8,
new_references.additional_school_code_9,
new_references.additional_school_code_10,
new_references.explanation_spec_circum,
new_references.signature_student,
new_references.signature_spouse,
new_references.signature_father,
new_references.signature_mother,
new_references.month_day_completed,
new_references.year_completed,
new_references.age_line_2,
new_references.age_line_3,
new_references.age_line_4,
new_references.age_line_5,
new_references.age_line_6,
new_references.age_line_7,
new_references.age_line_8,
new_references.a_online_signature,
new_references.question_1_number,
new_references.question_1_size,
new_references.question_1_answer,
new_references.question_2_number,
new_references.question_2_size,
new_references.question_2_answer,
new_references.question_3_number,
new_references.question_3_size,
new_references.question_3_answer,
new_references.question_4_number,
new_references.question_4_size,
new_references.question_4_answer,
new_references.question_5_number,
new_references.question_5_size,
new_references.question_5_answer,
new_references.question_6_number,
new_references.question_6_size,
new_references.question_6_answer,
new_references.question_7_number,
new_references.question_7_size,
new_references.question_7_answer,
new_references.question_8_number,
new_references.question_8_size,
new_references.question_8_answer,
new_references.question_9_number,
new_references.question_9_size,
new_references.question_9_answer,
new_references.question_10_number,
new_references.question_10_size,
new_references.question_10_answer,
new_references.question_11_number,
new_references.question_11_size,
new_references.question_11_answer,
new_references.question_12_number,
new_references.question_12_size,
new_references.question_12_answer,
new_references.question_13_number,
new_references.question_13_size,
new_references.question_13_answer,
new_references.question_14_number,
new_references.question_14_size,
new_references.question_14_answer,
new_references.question_15_number,
new_references.question_15_size,
new_references.question_15_answer,
new_references.question_16_number,
new_references.question_16_size,
new_references.question_16_answer,
new_references.question_17_number,
new_references.question_17_size,
new_references.question_17_answer,
new_references.question_18_number,
new_references.question_18_size,
new_references.question_18_answer,
new_references.question_19_number,
new_references.question_19_size,
new_references.question_19_answer,
new_references.question_20_number,
new_references.question_20_size,
new_references.question_20_answer,
new_references.question_21_number,
new_references.question_21_size,
new_references.question_21_answer,
new_references.question_22_number,
new_references.question_22_size,
new_references.question_22_answer,
new_references.question_23_number,
new_references.question_23_size,
new_references.question_23_answer,
new_references.question_24_number,
new_references.question_24_size,
new_references.question_24_answer,
new_references.question_25_number,
new_references.question_25_size,
new_references.question_25_answer,
new_references.question_26_number,
new_references.question_26_size,
new_references.question_26_answer,
new_references.question_27_number,
new_references.question_27_size,
new_references.question_27_answer,
new_references.question_28_number,
new_references.question_28_size,
new_references.question_28_answer,
new_references.question_29_number,
new_references.question_29_size,
new_references.question_29_answer,
new_references.question_30_number,
new_references.questions_30_size,
new_references.question_30_answer,
x_last_update_date,
x_last_updated_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
new_references.legacy_record_flag,
new_references.coa_duration_efc_amt,
new_references.coa_duration_num,
new_references.p_soc_sec_ben_student_amt,
new_references.p_tuit_fee_deduct_amt,
new_references.stu_lives_with_num,
new_references.stu_most_support_from_num,
new_references.location_computer_num
);
END insert_row;
SELECT
base_id,
system_record_type,
active_profile,
college_code,
academic_year,
stu_record_type,
css_id_number,
registration_receipt_date,
registration_type,
application_receipt_date,
application_type,
original_fnar_compute,
revision_fnar_compute_date,
electronic_extract_date,
institutional_reporting_type,
asr_receipt_date,
last_name,
first_name,
middle_initial,
address_number_and_street,
city,
state_mailing,
zip_code,
s_telephone_number,
s_title,
date_of_birth,
social_security_number,
state_legal_residence,
foreign_address_indicator,
foreign_postal_code,
country,
financial_aid_status,
year_in_college,
marital_status,
ward_court,
legal_dependents_other,
household_size,
number_in_college,
citizenship_status,
citizenship_country,
visa_classification,
tax_figures,
number_exemptions,
adjusted_gross_inc,
us_tax_paid,
itemized_deductions,
stu_income_work,
spouse_income_work,
divid_int_inc,
soc_sec_benefits,
welfare_tanf,
child_supp_rcvd,
earned_income_credit,
other_untax_income,
tax_stu_aid,
cash_sav_check,
ira_keogh,
invest_value,
invest_debt,
home_value,
home_debt,
oth_real_value,
oth_real_debt,
bus_farm_value,
bus_farm_debt,
live_on_farm,
home_purch_price,
hope_ll_credit,
home_purch_year,
trust_amount,
trust_avail,
trust_estab,
child_support_paid,
med_dent_expenses,
vet_us,
vet_ben_amount,
vet_ben_months,
stu_summer_wages,
stu_school_yr_wages,
spouse_summer_wages,
spouse_school_yr_wages,
summer_other_tax_inc,
school_yr_other_tax_inc,
summer_untax_inc,
school_yr_untax_inc,
grants_schol_etc,
tuit_benefits,
cont_parents,
cont_relatives,
p_siblings_pre_tuit,
p_student_pre_tuit,
p_household_size,
p_number_in_college,
p_parents_in_college,
p_marital_status,
p_state_legal_residence,
p_natural_par_status,
p_child_supp_paid,
p_repay_ed_loans,
p_med_dent_expenses,
p_tuit_paid_amount,
p_tuit_paid_number,
p_exp_child_supp_paid,
p_exp_repay_ed_loans,
p_exp_med_dent_expenses,
p_exp_tuit_pd_amount,
p_exp_tuit_pd_number,
p_cash_sav_check,
p_month_mortgage_pay,
p_invest_value,
p_invest_debt,
p_home_value,
p_home_debt,
p_home_purch_price,
p_own_business_farm,
p_business_value,
p_business_debt,
p_farm_value,
p_farm_debt,
p_live_on_farm,
p_oth_real_estate_value,
p_oth_real_estate_debt,
p_oth_real_purch_price,
p_siblings_assets,
p_home_purch_year,
p_oth_real_purch_year,
p_prior_agi,
p_prior_us_tax_paid,
p_prior_item_deductions,
p_prior_other_untax_inc,
p_tax_figures,
p_number_exemptions,
p_adjusted_gross_inc,
p_wages_sal_tips,
p_interest_income,
p_dividend_income,
p_net_inc_bus_farm,
p_other_taxable_income,
p_adj_to_income,
p_us_tax_paid,
p_itemized_deductions,
p_father_income_work,
p_mother_income_work,
p_soc_sec_ben,
p_welfare_tanf,
p_child_supp_rcvd,
p_ded_ira_keogh,
p_tax_defer_pens_savs,
p_dep_care_med_spending,
p_earned_income_credit,
p_living_allow,
p_tax_exmpt_int,
p_foreign_inc_excl,
p_other_untax_inc,
p_hope_ll_credit,
p_yr_separation,
p_yr_divorce,
p_exp_father_inc,
p_exp_mother_inc,
p_exp_other_tax_inc,
p_exp_other_untax_inc,
line_2_relation,
line_2_attend_college,
line_3_relation,
line_3_attend_college,
line_4_relation,
line_4_attend_college,
line_5_relation,
line_5_attend_college,
line_6_relation,
line_6_attend_college,
line_7_relation,
line_7_attend_college,
line_8_relation,
line_8_attend_college,
p_age_father,
p_age_mother,
p_div_sep_ind,
b_cont_non_custodial_par,
college_type_2,
college_type_3,
college_type_4,
college_type_5,
college_type_6,
college_type_7,
college_type_8,
school_code_1,
housing_code_1,
school_code_2,
housing_code_2,
school_code_3,
housing_code_3,
school_code_4,
housing_code_4,
school_code_5,
housing_code_5,
school_code_6,
housing_code_6,
school_code_7,
housing_code_7,
school_code_8,
housing_code_8,
school_code_9,
housing_code_9,
school_code_10,
housing_code_10,
additional_school_code_1,
additional_school_code_2,
additional_school_code_3,
additional_school_code_4,
additional_school_code_5,
additional_school_code_6,
additional_school_code_7,
additional_school_code_8,
additional_school_code_9,
additional_school_code_10,
explanation_spec_circum,
signature_student,
signature_spouse,
signature_father,
signature_mother,
month_day_completed,
year_completed,
age_line_2,
age_line_3,
age_line_4,
age_line_5,
age_line_6,
age_line_7,
age_line_8,
a_online_signature,
question_1_number,
question_1_size,
question_1_answer,
question_2_number,
question_2_size,
question_2_answer,
question_3_number,
question_3_size,
question_3_answer,
question_4_number,
question_4_size,
question_4_answer,
question_5_number,
question_5_size,
question_5_answer,
question_6_number,
question_6_size,
question_6_answer,
question_7_number,
question_7_size,
question_7_answer,
question_8_number,
question_8_size,
question_8_answer,
question_9_number,
question_9_size,
question_9_answer,
question_10_number,
question_10_size,
question_10_answer,
question_11_number,
question_11_size,
question_11_answer,
question_12_number,
question_12_size,
question_12_answer,
question_13_number,
question_13_size,
question_13_answer,
question_14_number,
question_14_size,
question_14_answer,
question_15_number,
question_15_size,
question_15_answer,
question_16_number,
question_16_size,
question_16_answer,
question_17_number,
question_17_size,
question_17_answer,
question_18_number,
question_18_size,
question_18_answer,
question_19_number,
question_19_size,
question_19_answer,
question_20_number,
question_20_size,
question_20_answer,
question_21_number,
question_21_size,
question_21_answer,
question_22_number,
question_22_size,
question_22_answer,
question_23_number,
question_23_size,
question_23_answer,
question_24_number,
question_24_size,
question_24_answer,
question_25_number,
question_25_size,
question_25_answer,
question_26_number,
question_26_size,
question_26_answer,
question_27_number,
question_27_size,
question_27_answer,
question_28_number,
question_28_size,
question_28_answer,
question_29_number,
question_29_size,
question_29_answer,
question_30_number,
questions_30_size,
question_30_answer,
legacy_record_flag,
coa_duration_efc_amt,
coa_duration_num,
p_soc_sec_ben_student_amt,
p_tuit_fee_deduct_amt,
stu_lives_with_num,
stu_most_support_from_num,
location_computer_num
FROM igf_ap_css_profile_all
WHERE rowid = x_rowid
FOR UPDATE NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_cssp_id IN NUMBER,
x_base_id IN NUMBER,
x_system_record_type IN VARCHAR2,
x_active_profile IN VARCHAR2,
x_college_code IN VARCHAR2,
x_academic_year IN VARCHAR2,
x_stu_record_type IN VARCHAR2,
x_css_id_number IN VARCHAR2,
x_registration_receipt_date IN VARCHAR2,
x_registration_type IN VARCHAR2,
x_application_receipt_date IN VARCHAR2,
x_application_type IN VARCHAR2,
x_original_fnar_compute IN VARCHAR2,
x_revision_fnar_compute_date IN VARCHAR2,
x_electronic_extract_date IN VARCHAR2,
x_institutional_reporting_type IN VARCHAR2,
x_asr_receipt_date IN VARCHAR2,
x_last_name IN VARCHAR2,
x_first_name IN VARCHAR2,
x_middle_initial IN VARCHAR2,
x_address_number_and_street IN VARCHAR2,
x_city IN VARCHAR2,
x_state_mailing IN VARCHAR2,
x_zip_code IN VARCHAR2,
x_s_telephone_number IN VARCHAR2,
x_s_title IN VARCHAR2,
x_date_of_birth IN DATE,
x_social_security_number IN VARCHAR2,
x_state_legal_residence IN VARCHAR2,
x_foreign_address_indicator IN VARCHAR2,
x_foreign_postal_code IN VARCHAR2,
x_country IN VARCHAR2,
x_financial_aid_status IN VARCHAR2,
x_year_in_college IN VARCHAR2,
x_marital_status IN VARCHAR2,
x_ward_court IN VARCHAR2,
x_legal_dependents_other IN VARCHAR2,
x_household_size IN NUMBER,
x_number_in_college IN NUMBER,
x_citizenship_status IN VARCHAR2,
x_citizenship_country IN VARCHAR2,
x_visa_classification IN VARCHAR2,
x_tax_figures IN VARCHAR2,
x_number_exemptions IN NUMBER,
x_adjusted_gross_inc IN NUMBER,
x_us_tax_paid IN NUMBER,
x_itemized_deductions IN NUMBER,
x_stu_income_work IN NUMBER,
x_spouse_income_work IN NUMBER,
x_divid_int_inc IN NUMBER,
x_soc_sec_benefits IN NUMBER,
x_welfare_tanf IN NUMBER,
x_child_supp_rcvd IN NUMBER,
x_earned_income_credit IN NUMBER,
x_other_untax_income IN NUMBER,
x_tax_stu_aid IN NUMBER,
x_cash_sav_check IN NUMBER,
x_ira_keogh IN NUMBER,
x_invest_value IN NUMBER,
x_invest_debt IN NUMBER,
x_home_value IN NUMBER,
x_home_debt IN NUMBER,
x_oth_real_value IN NUMBER,
x_oth_real_debt IN NUMBER,
x_bus_farm_value IN NUMBER,
x_bus_farm_debt IN NUMBER,
x_live_on_farm IN VARCHAR2,
x_home_purch_price IN NUMBER,
x_hope_ll_credit IN NUMBER,
x_home_purch_year IN VARCHAR2,
x_trust_amount IN NUMBER,
x_trust_avail IN VARCHAR2,
x_trust_estab IN VARCHAR2,
x_child_support_paid IN NUMBER,
x_med_dent_expenses IN NUMBER,
x_vet_us IN VARCHAR2,
x_vet_ben_amount IN NUMBER,
x_vet_ben_months IN NUMBER,
x_stu_summer_wages IN NUMBER,
x_stu_school_yr_wages IN NUMBER,
x_spouse_summer_wages IN NUMBER,
x_spouse_school_yr_wages IN NUMBER,
x_summer_other_tax_inc IN NUMBER,
x_school_yr_other_tax_inc IN NUMBER,
x_summer_untax_inc IN NUMBER,
x_school_yr_untax_inc IN NUMBER,
x_grants_schol_etc IN NUMBER,
x_tuit_benefits IN NUMBER,
x_cont_parents IN NUMBER,
x_cont_relatives IN NUMBER,
x_p_siblings_pre_tuit IN NUMBER,
x_p_student_pre_tuit IN NUMBER,
x_p_household_size IN NUMBER,
x_p_number_in_college IN NUMBER,
x_p_parents_in_college IN NUMBER,
x_p_marital_status IN VARCHAR2,
x_p_state_legal_residence IN VARCHAR2,
x_p_natural_par_status IN VARCHAR2,
x_p_child_supp_paid IN NUMBER,
x_p_repay_ed_loans IN NUMBER,
x_p_med_dent_expenses IN NUMBER,
x_p_tuit_paid_amount IN NUMBER,
x_p_tuit_paid_number IN NUMBER,
x_p_exp_child_supp_paid IN NUMBER,
x_p_exp_repay_ed_loans IN NUMBER,
x_p_exp_med_dent_expenses IN NUMBER,
x_p_exp_tuit_pd_amount IN NUMBER,
x_p_exp_tuit_pd_number IN NUMBER,
x_p_cash_sav_check IN NUMBER,
x_p_month_mortgage_pay IN NUMBER,
x_p_invest_value IN NUMBER,
x_p_invest_debt IN NUMBER,
x_p_home_value IN NUMBER,
x_p_home_debt IN NUMBER,
x_p_home_purch_price IN NUMBER,
x_p_own_business_farm IN VARCHAR2,
x_p_business_value IN NUMBER,
x_p_business_debt IN NUMBER,
x_p_farm_value IN NUMBER,
x_p_farm_debt IN NUMBER,
x_p_live_on_farm IN NUMBER,
x_p_oth_real_estate_value IN NUMBER,
x_p_oth_real_estate_debt IN NUMBER,
x_p_oth_real_purch_price IN NUMBER,
x_p_siblings_assets IN NUMBER,
x_p_home_purch_year IN VARCHAR2,
x_p_oth_real_purch_year IN VARCHAR2,
x_p_prior_agi IN NUMBER,
x_p_prior_us_tax_paid IN NUMBER,
x_p_prior_item_deductions IN NUMBER,
x_p_prior_other_untax_inc IN NUMBER,
x_p_tax_figures IN NUMBER,
x_p_number_exemptions IN NUMBER,
x_p_adjusted_gross_inc IN NUMBER,
x_p_wages_sal_tips IN NUMBER,
x_p_interest_income IN NUMBER,
x_p_dividend_income IN NUMBER,
x_p_net_inc_bus_farm IN NUMBER,
x_p_other_taxable_income IN NUMBER,
x_p_adj_to_income IN NUMBER,
x_p_us_tax_paid IN NUMBER,
x_p_itemized_deductions IN NUMBER,
x_p_father_income_work IN NUMBER,
x_p_mother_income_work IN NUMBER,
x_p_soc_sec_ben IN NUMBER,
x_p_welfare_tanf IN NUMBER,
x_p_child_supp_rcvd IN NUMBER,
x_p_ded_ira_keogh IN NUMBER,
x_p_tax_defer_pens_savs IN NUMBER,
x_p_dep_care_med_spending IN NUMBER,
x_p_earned_income_credit IN NUMBER,
x_p_living_allow IN NUMBER,
x_p_tax_exmpt_int IN NUMBER,
x_p_foreign_inc_excl IN NUMBER,
x_p_other_untax_inc IN NUMBER,
x_p_hope_ll_credit IN NUMBER,
x_p_yr_separation IN NUMBER,
x_p_yr_divorce IN NUMBER,
x_p_exp_father_inc IN NUMBER,
x_p_exp_mother_inc IN NUMBER,
x_p_exp_other_tax_inc IN NUMBER,
x_p_exp_other_untax_inc IN NUMBER,
x_line_2_relation IN VARCHAR2,
x_line_2_attend_college IN VARCHAR2,
x_line_3_relation IN VARCHAR2,
x_line_3_attend_college IN VARCHAR2,
x_line_4_relation IN VARCHAR2,
x_line_4_attend_college IN VARCHAR2,
x_line_5_relation IN VARCHAR2,
x_line_5_attend_college IN VARCHAR2,
x_line_6_relation IN VARCHAR2,
x_line_6_attend_college IN VARCHAR2,
x_line_7_relation IN VARCHAR2,
x_line_7_attend_college IN VARCHAR2,
x_line_8_relation IN VARCHAR2,
x_line_8_attend_college IN VARCHAR2,
x_p_age_father IN VARCHAR2,
x_p_age_mother IN VARCHAR2,
x_p_div_sep_ind IN VARCHAR2,
x_b_cont_non_custodial_par IN VARCHAR2,
x_college_type_2 IN VARCHAR2,
x_college_type_3 IN VARCHAR2,
x_college_type_4 IN VARCHAR2,
x_college_type_5 IN VARCHAR2,
x_college_type_6 IN VARCHAR2,
x_college_type_7 IN VARCHAR2,
x_college_type_8 IN VARCHAR2,
x_school_code_1 IN VARCHAR2,
x_housing_code_1 IN VARCHAR2,
x_school_code_2 IN VARCHAR2,
x_housing_code_2 IN VARCHAR2,
x_school_code_3 IN VARCHAR2,
x_housing_code_3 IN VARCHAR2,
x_school_code_4 IN VARCHAR2,
x_housing_code_4 IN VARCHAR2,
x_school_code_5 IN VARCHAR2,
x_housing_code_5 IN VARCHAR2,
x_school_code_6 IN VARCHAR2,
x_housing_code_6 IN VARCHAR2,
x_school_code_7 IN VARCHAR2,
x_housing_code_7 IN VARCHAR2,
x_school_code_8 IN VARCHAR2,
x_housing_code_8 IN VARCHAR2,
x_school_code_9 IN VARCHAR2,
x_housing_code_9 IN VARCHAR2,
x_school_code_10 IN VARCHAR2,
x_housing_code_10 IN VARCHAR2,
x_additional_school_code_1 IN VARCHAR2,
x_additional_school_code_2 IN VARCHAR2,
x_additional_school_code_3 IN VARCHAR2,
x_additional_school_code_4 IN VARCHAR2,
x_additional_school_code_5 IN VARCHAR2,
x_additional_school_code_6 IN VARCHAR2,
x_additional_school_code_7 IN VARCHAR2,
x_additional_school_code_8 IN VARCHAR2,
x_additional_school_code_9 IN VARCHAR2,
x_additional_school_code_10 IN VARCHAR2,
x_explanation_spec_circum IN VARCHAR2,
x_signature_student IN VARCHAR2,
x_signature_spouse IN VARCHAR2,
x_signature_father IN VARCHAR2,
x_signature_mother IN VARCHAR2,
x_month_day_completed IN VARCHAR2,
x_year_completed IN VARCHAR2,
x_age_line_2 IN NUMBER,
x_age_line_3 IN NUMBER,
x_age_line_4 IN NUMBER,
x_age_line_5 IN NUMBER,
x_age_line_6 IN NUMBER,
x_age_line_7 IN NUMBER,
x_age_line_8 IN NUMBER,
x_a_online_signature IN VARCHAR2,
x_question_1_number IN VARCHAR2,
x_question_1_size IN NUMBER,
x_question_1_answer IN VARCHAR2,
x_question_2_number IN VARCHAR2,
x_question_2_size IN NUMBER,
x_question_2_answer IN VARCHAR2,
x_question_3_number IN VARCHAR2,
x_question_3_size IN NUMBER,
x_question_3_answer IN VARCHAR2,
x_question_4_number IN VARCHAR2,
x_question_4_size IN NUMBER,
x_question_4_answer IN VARCHAR2,
x_question_5_number IN VARCHAR2,
x_question_5_size IN NUMBER,
x_question_5_answer IN VARCHAR2,
x_question_6_number IN VARCHAR2,
x_question_6_size IN NUMBER,
x_question_6_answer IN VARCHAR2,
x_question_7_number IN VARCHAR2,
x_question_7_size IN NUMBER,
x_question_7_answer IN VARCHAR2,
x_question_8_number IN VARCHAR2,
x_question_8_size IN NUMBER,
x_question_8_answer IN VARCHAR2,
x_question_9_number IN VARCHAR2,
x_question_9_size IN NUMBER,
x_question_9_answer IN VARCHAR2,
x_question_10_number IN VARCHAR2,
x_question_10_size IN NUMBER,
x_question_10_answer IN VARCHAR2,
x_question_11_number IN VARCHAR2,
x_question_11_size IN NUMBER,
x_question_11_answer IN VARCHAR2,
x_question_12_number IN VARCHAR2,
x_question_12_size IN NUMBER,
x_question_12_answer IN VARCHAR2,
x_question_13_number IN VARCHAR2,
x_question_13_size IN NUMBER,
x_question_13_answer IN VARCHAR2,
x_question_14_number IN VARCHAR2,
x_question_14_size IN NUMBER,
x_question_14_answer IN VARCHAR2,
x_question_15_number IN VARCHAR2,
x_question_15_size IN NUMBER,
x_question_15_answer IN VARCHAR2,
x_question_16_number IN VARCHAR2,
x_question_16_size IN NUMBER,
x_question_16_answer IN VARCHAR2,
x_question_17_number IN VARCHAR2,
x_question_17_size IN NUMBER,
x_question_17_answer IN VARCHAR2,
x_question_18_number IN VARCHAR2,
x_question_18_size IN NUMBER,
x_question_18_answer IN VARCHAR2,
x_question_19_number IN VARCHAR2,
x_question_19_size IN NUMBER,
x_question_19_answer IN VARCHAR2,
x_question_20_number IN VARCHAR2,
x_question_20_size IN NUMBER,
x_question_20_answer IN VARCHAR2,
x_question_21_number IN VARCHAR2,
x_question_21_size IN NUMBER,
x_question_21_answer IN VARCHAR2,
x_question_22_number IN VARCHAR2,
x_question_22_size IN NUMBER,
x_question_22_answer IN VARCHAR2,
x_question_23_number IN VARCHAR2,
x_question_23_size IN NUMBER,
x_question_23_answer IN VARCHAR2,
x_question_24_number IN VARCHAR2,
x_question_24_size IN NUMBER,
x_question_24_answer IN VARCHAR2,
x_question_25_number IN VARCHAR2,
x_question_25_size IN NUMBER,
x_question_25_answer IN VARCHAR2,
x_question_26_number IN VARCHAR2,
x_question_26_size IN NUMBER,
x_question_26_answer IN VARCHAR2,
x_question_27_number IN VARCHAR2,
x_question_27_size IN NUMBER,
x_question_27_answer IN VARCHAR2,
x_question_28_number IN VARCHAR2,
x_question_28_size IN NUMBER,
x_question_28_answer IN VARCHAR2,
x_question_29_number IN VARCHAR2,
x_question_29_size IN NUMBER,
x_question_29_answer IN VARCHAR2,
x_question_30_number IN VARCHAR2,
x_questions_30_size IN NUMBER,
x_question_30_answer IN VARCHAR2,
x_mode IN VARCHAR2 DEFAULT 'R',
x_legacy_record_flag IN VARCHAR2,
x_coa_duration_efc_amt IN NUMBER,
x_coa_duration_num IN NUMBER,
x_p_soc_sec_ben_student_amt IN NUMBER,
x_p_tuit_fee_deduct_amt IN NUMBER,
x_stu_lives_with_num IN NUMBER,
x_stu_most_support_from_num IN NUMBER,
x_location_computer_num IN NUMBER
) AS
/*
|| Created By : vivuyyur
|| Created On : 29-MAY-2001
|| Purpose : Handles the UPDATE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
x_last_update_date DATE ;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
x_last_update_date := SYSDATE;
x_last_updated_by := 1;
x_last_update_login := 0;
x_last_updated_by := fnd_global.user_id;
IF x_last_updated_by IS NULL THEN
x_last_updated_by := -1;
x_last_update_login := fnd_global.login_id;
IF (x_last_update_login IS NULL) THEN
x_last_update_login := -1;
p_action => 'UPDATE',
x_rowid => x_rowid,
x_cssp_id => x_cssp_id,
x_base_id => x_base_id,
x_system_record_type => x_system_record_type,
x_active_profile => x_active_profile,
x_college_code => x_college_code,
x_academic_year => x_academic_year,
x_stu_record_type => x_stu_record_type,
x_css_id_number => x_css_id_number,
x_registration_receipt_date => x_registration_receipt_date,
x_registration_type => x_registration_type,
x_application_receipt_date => x_application_receipt_date,
x_application_type => x_application_type,
x_original_fnar_compute => x_original_fnar_compute,
x_revision_fnar_compute_date => x_revision_fnar_compute_date,
x_electronic_extract_date => x_electronic_extract_date,
x_institutional_reporting_type => x_institutional_reporting_type,
x_asr_receipt_date => x_asr_receipt_date,
x_last_name => x_last_name,
x_first_name => x_first_name,
x_middle_initial => x_middle_initial,
x_address_number_and_street => x_address_number_and_street,
x_city => x_city,
x_state_mailing => x_state_mailing,
x_zip_code => x_zip_code,
x_s_telephone_number => x_s_telephone_number,
x_s_title => x_s_title,
x_date_of_birth => x_date_of_birth,
x_social_security_number => x_social_security_number,
x_state_legal_residence => x_state_legal_residence,
x_foreign_address_indicator => x_foreign_address_indicator,
x_foreign_postal_code => x_foreign_postal_code,
x_country => x_country,
x_financial_aid_status => x_financial_aid_status,
x_year_in_college => x_year_in_college,
x_marital_status => x_marital_status,
x_ward_court => x_ward_court,
x_legal_dependents_other => x_legal_dependents_other,
x_household_size => x_household_size,
x_number_in_college => x_number_in_college,
x_citizenship_status => x_citizenship_status,
x_citizenship_country => x_citizenship_country,
x_visa_classification => x_visa_classification,
x_tax_figures => x_tax_figures,
x_number_exemptions => x_number_exemptions,
x_adjusted_gross_inc => x_adjusted_gross_inc,
x_us_tax_paid => x_us_tax_paid,
x_itemized_deductions => x_itemized_deductions,
x_stu_income_work => x_stu_income_work,
x_spouse_income_work => x_spouse_income_work,
x_divid_int_inc => x_divid_int_inc,
x_soc_sec_benefits => x_soc_sec_benefits,
x_welfare_tanf => x_welfare_tanf,
x_child_supp_rcvd => x_child_supp_rcvd,
x_earned_income_credit => x_earned_income_credit,
x_other_untax_income => x_other_untax_income,
x_tax_stu_aid => x_tax_stu_aid,
x_cash_sav_check => x_cash_sav_check,
x_ira_keogh => x_ira_keogh,
x_invest_value => x_invest_value,
x_invest_debt => x_invest_debt,
x_home_value => x_home_value,
x_home_debt => x_home_debt,
x_oth_real_value => x_oth_real_value,
x_oth_real_debt => x_oth_real_debt,
x_bus_farm_value => x_bus_farm_value,
x_bus_farm_debt => x_bus_farm_debt,
x_live_on_farm => x_live_on_farm,
x_home_purch_price => x_home_purch_price,
x_hope_ll_credit => x_hope_ll_credit,
x_home_purch_year => x_home_purch_year,
x_trust_amount => x_trust_amount,
x_trust_avail => x_trust_avail,
x_trust_estab => x_trust_estab,
x_child_support_paid => x_child_support_paid,
x_med_dent_expenses => x_med_dent_expenses,
x_vet_us => x_vet_us,
x_vet_ben_amount => x_vet_ben_amount,
x_vet_ben_months => x_vet_ben_months,
x_stu_summer_wages => x_stu_summer_wages,
x_stu_school_yr_wages => x_stu_school_yr_wages,
x_spouse_summer_wages => x_spouse_summer_wages,
x_spouse_school_yr_wages => x_spouse_school_yr_wages,
x_summer_other_tax_inc => x_summer_other_tax_inc,
x_school_yr_other_tax_inc => x_school_yr_other_tax_inc,
x_summer_untax_inc => x_summer_untax_inc,
x_school_yr_untax_inc => x_school_yr_untax_inc,
x_grants_schol_etc => x_grants_schol_etc,
x_tuit_benefits => x_tuit_benefits,
x_cont_parents => x_cont_parents,
x_cont_relatives => x_cont_relatives,
x_p_siblings_pre_tuit => x_p_siblings_pre_tuit,
x_p_student_pre_tuit => x_p_student_pre_tuit,
x_p_household_size => x_p_household_size,
x_p_number_in_college => x_p_number_in_college,
x_p_parents_in_college => x_p_parents_in_college,
x_p_marital_status => x_p_marital_status,
x_p_state_legal_residence => x_p_state_legal_residence,
x_p_natural_par_status => x_p_natural_par_status,
x_p_child_supp_paid => x_p_child_supp_paid,
x_p_repay_ed_loans => x_p_repay_ed_loans,
x_p_med_dent_expenses => x_p_med_dent_expenses,
x_p_tuit_paid_amount => x_p_tuit_paid_amount,
x_p_tuit_paid_number => x_p_tuit_paid_number,
x_p_exp_child_supp_paid => x_p_exp_child_supp_paid,
x_p_exp_repay_ed_loans => x_p_exp_repay_ed_loans,
x_p_exp_med_dent_expenses => x_p_exp_med_dent_expenses,
x_p_exp_tuit_pd_amount => x_p_exp_tuit_pd_amount,
x_p_exp_tuit_pd_number => x_p_exp_tuit_pd_number,
x_p_cash_sav_check => x_p_cash_sav_check,
x_p_month_mortgage_pay => x_p_month_mortgage_pay,
x_p_invest_value => x_p_invest_value,
x_p_invest_debt => x_p_invest_debt,
x_p_home_value => x_p_home_value,
x_p_home_debt => x_p_home_debt,
x_p_home_purch_price => x_p_home_purch_price,
x_p_own_business_farm => x_p_own_business_farm,
x_p_business_value => x_p_business_value,
x_p_business_debt => x_p_business_debt,
x_p_farm_value => x_p_farm_value,
x_p_farm_debt => x_p_farm_debt,
x_p_live_on_farm => x_p_live_on_farm,
x_p_oth_real_estate_value => x_p_oth_real_estate_value,
x_p_oth_real_estate_debt => x_p_oth_real_estate_debt,
x_p_oth_real_purch_price => x_p_oth_real_purch_price,
x_p_siblings_assets => x_p_siblings_assets,
x_p_home_purch_year => x_p_home_purch_year,
x_p_oth_real_purch_year => x_p_oth_real_purch_year,
x_p_prior_agi => x_p_prior_agi,
x_p_prior_us_tax_paid => x_p_prior_us_tax_paid,
x_p_prior_item_deductions => x_p_prior_item_deductions,
x_p_prior_other_untax_inc => x_p_prior_other_untax_inc,
x_p_tax_figures => x_p_tax_figures,
x_p_number_exemptions => x_p_number_exemptions,
x_p_adjusted_gross_inc => x_p_adjusted_gross_inc,
x_p_wages_sal_tips => x_p_wages_sal_tips,
x_p_interest_income => x_p_interest_income,
x_p_dividend_income => x_p_dividend_income,
x_p_net_inc_bus_farm => x_p_net_inc_bus_farm,
x_p_other_taxable_income => x_p_other_taxable_income,
x_p_adj_to_income => x_p_adj_to_income,
x_p_us_tax_paid => x_p_us_tax_paid,
x_p_itemized_deductions => x_p_itemized_deductions,
x_p_father_income_work => x_p_father_income_work,
x_p_mother_income_work => x_p_mother_income_work,
x_p_soc_sec_ben => x_p_soc_sec_ben,
x_p_welfare_tanf => x_p_welfare_tanf,
x_p_child_supp_rcvd => x_p_child_supp_rcvd,
x_p_ded_ira_keogh => x_p_ded_ira_keogh,
x_p_tax_defer_pens_savs => x_p_tax_defer_pens_savs,
x_p_dep_care_med_spending => x_p_dep_care_med_spending,
x_p_earned_income_credit => x_p_earned_income_credit,
x_p_living_allow => x_p_living_allow,
x_p_tax_exmpt_int => x_p_tax_exmpt_int,
x_p_foreign_inc_excl => x_p_foreign_inc_excl,
x_p_other_untax_inc => x_p_other_untax_inc,
x_p_hope_ll_credit => x_p_hope_ll_credit,
x_p_yr_separation => x_p_yr_separation,
x_p_yr_divorce => x_p_yr_divorce,
x_p_exp_father_inc => x_p_exp_father_inc,
x_p_exp_mother_inc => x_p_exp_mother_inc,
x_p_exp_other_tax_inc => x_p_exp_other_tax_inc,
x_p_exp_other_untax_inc => x_p_exp_other_untax_inc,
x_line_2_relation => x_line_2_relation,
x_line_2_attend_college => x_line_2_attend_college,
x_line_3_relation => x_line_3_relation,
x_line_3_attend_college => x_line_3_attend_college,
x_line_4_relation => x_line_4_relation,
x_line_4_attend_college => x_line_4_attend_college,
x_line_5_relation => x_line_5_relation,
x_line_5_attend_college => x_line_5_attend_college,
x_line_6_relation => x_line_6_relation,
x_line_6_attend_college => x_line_6_attend_college,
x_line_7_relation => x_line_7_relation,
x_line_7_attend_college => x_line_7_attend_college,
x_line_8_relation => x_line_8_relation,
x_line_8_attend_college => x_line_8_attend_college,
x_p_age_father => x_p_age_father,
x_p_age_mother => x_p_age_mother,
x_p_div_sep_ind => x_p_div_sep_ind,
x_b_cont_non_custodial_par => x_b_cont_non_custodial_par,
x_college_type_2 => x_college_type_2,
x_college_type_3 => x_college_type_3,
x_college_type_4 => x_college_type_4,
x_college_type_5 => x_college_type_5,
x_college_type_6 => x_college_type_6,
x_college_type_7 => x_college_type_7,
x_college_type_8 => x_college_type_8,
x_school_code_1 => x_school_code_1,
x_housing_code_1 => x_housing_code_1,
x_school_code_2 => x_school_code_2,
x_housing_code_2 => x_housing_code_2,
x_school_code_3 => x_school_code_3,
x_housing_code_3 => x_housing_code_3,
x_school_code_4 => x_school_code_4,
x_housing_code_4 => x_housing_code_4,
x_school_code_5 => x_school_code_5,
x_housing_code_5 => x_housing_code_5,
x_school_code_6 => x_school_code_6,
x_housing_code_6 => x_housing_code_6,
x_school_code_7 => x_school_code_7,
x_housing_code_7 => x_housing_code_7,
x_school_code_8 => x_school_code_8,
x_housing_code_8 => x_housing_code_8,
x_school_code_9 => x_school_code_9,
x_housing_code_9 => x_housing_code_9,
x_school_code_10 => x_school_code_10,
x_housing_code_10 => x_housing_code_10,
x_additional_school_code_1 => x_additional_school_code_1,
x_additional_school_code_2 => x_additional_school_code_2,
x_additional_school_code_3 => x_additional_school_code_3,
x_additional_school_code_4 => x_additional_school_code_4,
x_additional_school_code_5 => x_additional_school_code_5,
x_additional_school_code_6 => x_additional_school_code_6,
x_additional_school_code_7 => x_additional_school_code_7,
x_additional_school_code_8 => x_additional_school_code_8,
x_additional_school_code_9 => x_additional_school_code_9,
x_additional_school_code_10 => x_additional_school_code_10,
x_explanation_spec_circum => x_explanation_spec_circum,
x_signature_student => x_signature_student,
x_signature_spouse => x_signature_spouse,
x_signature_father => x_signature_father,
x_signature_mother => x_signature_mother,
x_month_day_completed => x_month_day_completed,
x_year_completed => x_year_completed,
x_age_line_2 => x_age_line_2,
x_age_line_3 => x_age_line_3,
x_age_line_4 => x_age_line_4,
x_age_line_5 => x_age_line_5,
x_age_line_6 => x_age_line_6,
x_age_line_7 => x_age_line_7,
x_age_line_8 => x_age_line_8,
x_a_online_signature => x_a_online_signature,
x_question_1_number => x_question_1_number,
x_question_1_size => x_question_1_size,
x_question_1_answer => x_question_1_answer,
x_question_2_number => x_question_2_number,
x_question_2_size => x_question_2_size,
x_question_2_answer => x_question_2_answer,
x_question_3_number => x_question_3_number,
x_question_3_size => x_question_3_size,
x_question_3_answer => x_question_3_answer,
x_question_4_number => x_question_4_number,
x_question_4_size => x_question_4_size,
x_question_4_answer => x_question_4_answer,
x_question_5_number => x_question_5_number,
x_question_5_size => x_question_5_size,
x_question_5_answer => x_question_5_answer,
x_question_6_number => x_question_6_number,
x_question_6_size => x_question_6_size,
x_question_6_answer => x_question_6_answer,
x_question_7_number => x_question_7_number,
x_question_7_size => x_question_7_size,
x_question_7_answer => x_question_7_answer,
x_question_8_number => x_question_8_number,
x_question_8_size => x_question_8_size,
x_question_8_answer => x_question_8_answer,
x_question_9_number => x_question_9_number,
x_question_9_size => x_question_9_size,
x_question_9_answer => x_question_9_answer,
x_question_10_number => x_question_10_number,
x_question_10_size => x_question_10_size,
x_question_10_answer => x_question_10_answer,
x_question_11_number => x_question_11_number,
x_question_11_size => x_question_11_size,
x_question_11_answer => x_question_11_answer,
x_question_12_number => x_question_12_number,
x_question_12_size => x_question_12_size,
x_question_12_answer => x_question_12_answer,
x_question_13_number => x_question_13_number,
x_question_13_size => x_question_13_size,
x_question_13_answer => x_question_13_answer,
x_question_14_number => x_question_14_number,
x_question_14_size => x_question_14_size,
x_question_14_answer => x_question_14_answer,
x_question_15_number => x_question_15_number,
x_question_15_size => x_question_15_size,
x_question_15_answer => x_question_15_answer,
x_question_16_number => x_question_16_number,
x_question_16_size => x_question_16_size,
x_question_16_answer => x_question_16_answer,
x_question_17_number => x_question_17_number,
x_question_17_size => x_question_17_size,
x_question_17_answer => x_question_17_answer,
x_question_18_number => x_question_18_number,
x_question_18_size => x_question_18_size,
x_question_18_answer => x_question_18_answer,
x_question_19_number => x_question_19_number,
x_question_19_size => x_question_19_size,
x_question_19_answer => x_question_19_answer,
x_question_20_number => x_question_20_number,
x_question_20_size => x_question_20_size,
x_question_20_answer => x_question_20_answer,
x_question_21_number => x_question_21_number,
x_question_21_size => x_question_21_size,
x_question_21_answer => x_question_21_answer,
x_question_22_number => x_question_22_number,
x_question_22_size => x_question_22_size,
x_question_22_answer => x_question_22_answer,
x_question_23_number => x_question_23_number,
x_question_23_size => x_question_23_size,
x_question_23_answer => x_question_23_answer,
x_question_24_number => x_question_24_number,
x_question_24_size => x_question_24_size,
x_question_24_answer => x_question_24_answer,
x_question_25_number => x_question_25_number,
x_question_25_size => x_question_25_size,
x_question_25_answer => x_question_25_answer,
x_question_26_number => x_question_26_number,
x_question_26_size => x_question_26_size,
x_question_26_answer => x_question_26_answer,
x_question_27_number => x_question_27_number,
x_question_27_size => x_question_27_size,
x_question_27_answer => x_question_27_answer,
x_question_28_number => x_question_28_number,
x_question_28_size => x_question_28_size,
x_question_28_answer => x_question_28_answer,
x_question_29_number => x_question_29_number,
x_question_29_size => x_question_29_size,
x_question_29_answer => x_question_29_answer,
x_question_30_number => x_question_30_number,
x_questions_30_size => x_questions_30_size,
x_question_30_answer => x_question_30_answer,
x_creation_date => x_last_update_date,
x_created_by => x_last_updated_by,
x_last_update_date => x_last_update_date,
x_last_updated_by => x_last_updated_by,
x_last_update_login => x_last_update_login,
x_legacy_record_flag => x_legacy_record_flag,
x_coa_duration_efc_amt => x_coa_duration_efc_amt,
x_coa_duration_num => x_coa_duration_num,
x_p_soc_sec_ben_student_amt => x_p_soc_sec_ben_student_amt,
x_p_tuit_fee_deduct_amt => x_p_tuit_fee_deduct_amt,
x_stu_lives_with_num => x_stu_lives_with_num,
x_stu_most_support_from_num => x_stu_most_support_from_num,
x_location_computer_num => x_location_computer_num
);
UPDATE igf_ap_css_profile_all
SET
base_id = new_references.base_id,
system_record_type = new_references.system_record_type,
active_profile = new_references.active_profile,
college_code = new_references.college_code,
academic_year = new_references.academic_year,
stu_record_type = new_references.stu_record_type,
css_id_number = new_references.css_id_number,
registration_receipt_date = new_references.registration_receipt_date,
registration_type = new_references.registration_type,
application_receipt_date = new_references.application_receipt_date,
application_type = new_references.application_type,
original_fnar_compute = new_references.original_fnar_compute,
revision_fnar_compute_date = new_references.revision_fnar_compute_date,
electronic_extract_date = new_references.electronic_extract_date,
institutional_reporting_type = new_references.institutional_reporting_type,
asr_receipt_date = new_references.asr_receipt_date,
last_name = new_references.last_name,
first_name = new_references.first_name,
middle_initial = new_references.middle_initial,
address_number_and_street = new_references.address_number_and_street,
city = new_references.city,
state_mailing = new_references.state_mailing,
zip_code = new_references.zip_code,
s_telephone_number = new_references.s_telephone_number,
s_title = new_references.s_title,
date_of_birth = new_references.date_of_birth,
social_security_number = new_references.social_security_number,
state_legal_residence = new_references.state_legal_residence,
foreign_address_indicator = new_references.foreign_address_indicator,
foreign_postal_code = new_references.foreign_postal_code,
country = new_references.country,
financial_aid_status = new_references.financial_aid_status,
year_in_college = new_references.year_in_college,
marital_status = new_references.marital_status,
ward_court = new_references.ward_court,
legal_dependents_other = new_references.legal_dependents_other,
household_size = new_references.household_size,
number_in_college = new_references.number_in_college,
citizenship_status = new_references.citizenship_status,
citizenship_country = new_references.citizenship_country,
visa_classification = new_references.visa_classification,
tax_figures = new_references.tax_figures,
number_exemptions = new_references.number_exemptions,
adjusted_gross_inc = new_references.adjusted_gross_inc,
us_tax_paid = new_references.us_tax_paid,
itemized_deductions = new_references.itemized_deductions,
stu_income_work = new_references.stu_income_work,
spouse_income_work = new_references.spouse_income_work,
divid_int_inc = new_references.divid_int_inc,
soc_sec_benefits = new_references.soc_sec_benefits,
welfare_tanf = new_references.welfare_tanf,
child_supp_rcvd = new_references.child_supp_rcvd,
earned_income_credit = new_references.earned_income_credit,
other_untax_income = new_references.other_untax_income,
tax_stu_aid = new_references.tax_stu_aid,
cash_sav_check = new_references.cash_sav_check,
ira_keogh = new_references.ira_keogh,
invest_value = new_references.invest_value,
invest_debt = new_references.invest_debt,
home_value = new_references.home_value,
home_debt = new_references.home_debt,
oth_real_value = new_references.oth_real_value,
oth_real_debt = new_references.oth_real_debt,
bus_farm_value = new_references.bus_farm_value,
bus_farm_debt = new_references.bus_farm_debt,
live_on_farm = new_references.live_on_farm,
home_purch_price = new_references.home_purch_price,
hope_ll_credit = new_references.hope_ll_credit,
home_purch_year = new_references.home_purch_year,
trust_amount = new_references.trust_amount,
trust_avail = new_references.trust_avail,
trust_estab = new_references.trust_estab,
child_support_paid = new_references.child_support_paid,
med_dent_expenses = new_references.med_dent_expenses,
vet_us = new_references.vet_us,
vet_ben_amount = new_references.vet_ben_amount,
vet_ben_months = new_references.vet_ben_months,
stu_summer_wages = new_references.stu_summer_wages,
stu_school_yr_wages = new_references.stu_school_yr_wages,
spouse_summer_wages = new_references.spouse_summer_wages,
spouse_school_yr_wages = new_references.spouse_school_yr_wages,
summer_other_tax_inc = new_references.summer_other_tax_inc,
school_yr_other_tax_inc = new_references.school_yr_other_tax_inc,
summer_untax_inc = new_references.summer_untax_inc,
school_yr_untax_inc = new_references.school_yr_untax_inc,
grants_schol_etc = new_references.grants_schol_etc,
tuit_benefits = new_references.tuit_benefits,
cont_parents = new_references.cont_parents,
cont_relatives = new_references.cont_relatives,
p_siblings_pre_tuit = new_references.p_siblings_pre_tuit,
p_student_pre_tuit = new_references.p_student_pre_tuit,
p_household_size = new_references.p_household_size,
p_number_in_college = new_references.p_number_in_college,
p_parents_in_college = new_references.p_parents_in_college,
p_marital_status = new_references.p_marital_status,
p_state_legal_residence = new_references.p_state_legal_residence,
p_natural_par_status = new_references.p_natural_par_status,
p_child_supp_paid = new_references.p_child_supp_paid,
p_repay_ed_loans = new_references.p_repay_ed_loans,
p_med_dent_expenses = new_references.p_med_dent_expenses,
p_tuit_paid_amount = new_references.p_tuit_paid_amount,
p_tuit_paid_number = new_references.p_tuit_paid_number,
p_exp_child_supp_paid = new_references.p_exp_child_supp_paid,
p_exp_repay_ed_loans = new_references.p_exp_repay_ed_loans,
p_exp_med_dent_expenses = new_references.p_exp_med_dent_expenses,
p_exp_tuit_pd_amount = new_references.p_exp_tuit_pd_amount,
p_exp_tuit_pd_number = new_references.p_exp_tuit_pd_number,
p_cash_sav_check = new_references.p_cash_sav_check,
p_month_mortgage_pay = new_references.p_month_mortgage_pay,
p_invest_value = new_references.p_invest_value,
p_invest_debt = new_references.p_invest_debt,
p_home_value = new_references.p_home_value,
p_home_debt = new_references.p_home_debt,
p_home_purch_price = new_references.p_home_purch_price,
p_own_business_farm = new_references.p_own_business_farm,
p_business_value = new_references.p_business_value,
p_business_debt = new_references.p_business_debt,
p_farm_value = new_references.p_farm_value,
p_farm_debt = new_references.p_farm_debt,
p_live_on_farm = new_references.p_live_on_farm,
p_oth_real_estate_value = new_references.p_oth_real_estate_value,
p_oth_real_estate_debt = new_references.p_oth_real_estate_debt,
p_oth_real_purch_price = new_references.p_oth_real_purch_price,
p_siblings_assets = new_references.p_siblings_assets,
p_home_purch_year = new_references.p_home_purch_year,
p_oth_real_purch_year = new_references.p_oth_real_purch_year,
p_prior_agi = new_references.p_prior_agi,
p_prior_us_tax_paid = new_references.p_prior_us_tax_paid,
p_prior_item_deductions = new_references.p_prior_item_deductions,
p_prior_other_untax_inc = new_references.p_prior_other_untax_inc,
p_tax_figures = new_references.p_tax_figures,
p_number_exemptions = new_references.p_number_exemptions,
p_adjusted_gross_inc = new_references.p_adjusted_gross_inc,
p_wages_sal_tips = new_references.p_wages_sal_tips,
p_interest_income = new_references.p_interest_income,
p_dividend_income = new_references.p_dividend_income,
p_net_inc_bus_farm = new_references.p_net_inc_bus_farm,
p_other_taxable_income = new_references.p_other_taxable_income,
p_adj_to_income = new_references.p_adj_to_income,
p_us_tax_paid = new_references.p_us_tax_paid,
p_itemized_deductions = new_references.p_itemized_deductions,
p_father_income_work = new_references.p_father_income_work,
p_mother_income_work = new_references.p_mother_income_work,
p_soc_sec_ben = new_references.p_soc_sec_ben,
p_welfare_tanf = new_references.p_welfare_tanf,
p_child_supp_rcvd = new_references.p_child_supp_rcvd,
p_ded_ira_keogh = new_references.p_ded_ira_keogh,
p_tax_defer_pens_savs = new_references.p_tax_defer_pens_savs,
p_dep_care_med_spending = new_references.p_dep_care_med_spending,
p_earned_income_credit = new_references.p_earned_income_credit,
p_living_allow = new_references.p_living_allow,
p_tax_exmpt_int = new_references.p_tax_exmpt_int,
p_foreign_inc_excl = new_references.p_foreign_inc_excl,
p_other_untax_inc = new_references.p_other_untax_inc,
p_hope_ll_credit = new_references.p_hope_ll_credit,
p_yr_separation = new_references.p_yr_separation,
p_yr_divorce = new_references.p_yr_divorce,
p_exp_father_inc = new_references.p_exp_father_inc,
p_exp_mother_inc = new_references.p_exp_mother_inc,
p_exp_other_tax_inc = new_references.p_exp_other_tax_inc,
p_exp_other_untax_inc = new_references.p_exp_other_untax_inc,
line_2_relation = new_references.line_2_relation,
line_2_attend_college = new_references.line_2_attend_college,
line_3_relation = new_references.line_3_relation,
line_3_attend_college = new_references.line_3_attend_college,
line_4_relation = new_references.line_4_relation,
line_4_attend_college = new_references.line_4_attend_college,
line_5_relation = new_references.line_5_relation,
line_5_attend_college = new_references.line_5_attend_college,
line_6_relation = new_references.line_6_relation,
line_6_attend_college = new_references.line_6_attend_college,
line_7_relation = new_references.line_7_relation,
line_7_attend_college = new_references.line_7_attend_college,
line_8_relation = new_references.line_8_relation,
line_8_attend_college = new_references.line_8_attend_college,
p_age_father = new_references.p_age_father,
p_age_mother = new_references.p_age_mother,
p_div_sep_ind = new_references.p_div_sep_ind,
b_cont_non_custodial_par = new_references.b_cont_non_custodial_par,
college_type_2 = new_references.college_type_2,
college_type_3 = new_references.college_type_3,
college_type_4 = new_references.college_type_4,
college_type_5 = new_references.college_type_5,
college_type_6 = new_references.college_type_6,
college_type_7 = new_references.college_type_7,
college_type_8 = new_references.college_type_8,
school_code_1 = new_references.school_code_1,
housing_code_1 = new_references.housing_code_1,
school_code_2 = new_references.school_code_2,
housing_code_2 = new_references.housing_code_2,
school_code_3 = new_references.school_code_3,
housing_code_3 = new_references.housing_code_3,
school_code_4 = new_references.school_code_4,
housing_code_4 = new_references.housing_code_4,
school_code_5 = new_references.school_code_5,
housing_code_5 = new_references.housing_code_5,
school_code_6 = new_references.school_code_6,
housing_code_6 = new_references.housing_code_6,
school_code_7 = new_references.school_code_7,
housing_code_7 = new_references.housing_code_7,
school_code_8 = new_references.school_code_8,
housing_code_8 = new_references.housing_code_8,
school_code_9 = new_references.school_code_9,
housing_code_9 = new_references.housing_code_9,
school_code_10 = new_references.school_code_10,
housing_code_10 = new_references.housing_code_10,
additional_school_code_1 = new_references.additional_school_code_1,
additional_school_code_2 = new_references.additional_school_code_2,
additional_school_code_3 = new_references.additional_school_code_3,
additional_school_code_4 = new_references.additional_school_code_4,
additional_school_code_5 = new_references.additional_school_code_5,
additional_school_code_6 = new_references.additional_school_code_6,
additional_school_code_7 = new_references.additional_school_code_7,
additional_school_code_8 = new_references.additional_school_code_8,
additional_school_code_9 = new_references.additional_school_code_9,
additional_school_code_10 = new_references.additional_school_code_10,
explanation_spec_circum = new_references.explanation_spec_circum,
signature_student = new_references.signature_student,
signature_spouse = new_references.signature_spouse,
signature_father = new_references.signature_father,
signature_mother = new_references.signature_mother,
month_day_completed = new_references.month_day_completed,
year_completed = new_references.year_completed,
age_line_2 = new_references.age_line_2,
age_line_3 = new_references.age_line_3,
age_line_4 = new_references.age_line_4,
age_line_5 = new_references.age_line_5,
age_line_6 = new_references.age_line_6,
age_line_7 = new_references.age_line_7,
age_line_8 = new_references.age_line_8,
a_online_signature = new_references.a_online_signature,
question_1_number = new_references.question_1_number,
question_1_size = new_references.question_1_size,
question_1_answer = new_references.question_1_answer,
question_2_number = new_references.question_2_number,
question_2_size = new_references.question_2_size,
question_2_answer = new_references.question_2_answer,
question_3_number = new_references.question_3_number,
question_3_size = new_references.question_3_size,
question_3_answer = new_references.question_3_answer,
question_4_number = new_references.question_4_number,
question_4_size = new_references.question_4_size,
question_4_answer = new_references.question_4_answer,
question_5_number = new_references.question_5_number,
question_5_size = new_references.question_5_size,
question_5_answer = new_references.question_5_answer,
question_6_number = new_references.question_6_number,
question_6_size = new_references.question_6_size,
question_6_answer = new_references.question_6_answer,
question_7_number = new_references.question_7_number,
question_7_size = new_references.question_7_size,
question_7_answer = new_references.question_7_answer,
question_8_number = new_references.question_8_number,
question_8_size = new_references.question_8_size,
question_8_answer = new_references.question_8_answer,
question_9_number = new_references.question_9_number,
question_9_size = new_references.question_9_size,
question_9_answer = new_references.question_9_answer,
question_10_number = new_references.question_10_number,
question_10_size = new_references.question_10_size,
question_10_answer = new_references.question_10_answer,
question_11_number = new_references.question_11_number,
question_11_size = new_references.question_11_size,
question_11_answer = new_references.question_11_answer,
question_12_number = new_references.question_12_number,
question_12_size = new_references.question_12_size,
question_12_answer = new_references.question_12_answer,
question_13_number = new_references.question_13_number,
question_13_size = new_references.question_13_size,
question_13_answer = new_references.question_13_answer,
question_14_number = new_references.question_14_number,
question_14_size = new_references.question_14_size,
question_14_answer = new_references.question_14_answer,
question_15_number = new_references.question_15_number,
question_15_size = new_references.question_15_size,
question_15_answer = new_references.question_15_answer,
question_16_number = new_references.question_16_number,
question_16_size = new_references.question_16_size,
question_16_answer = new_references.question_16_answer,
question_17_number = new_references.question_17_number,
question_17_size = new_references.question_17_size,
question_17_answer = new_references.question_17_answer,
question_18_number = new_references.question_18_number,
question_18_size = new_references.question_18_size,
question_18_answer = new_references.question_18_answer,
question_19_number = new_references.question_19_number,
question_19_size = new_references.question_19_size,
question_19_answer = new_references.question_19_answer,
question_20_number = new_references.question_20_number,
question_20_size = new_references.question_20_size,
question_20_answer = new_references.question_20_answer,
question_21_number = new_references.question_21_number,
question_21_size = new_references.question_21_size,
question_21_answer = new_references.question_21_answer,
question_22_number = new_references.question_22_number,
question_22_size = new_references.question_22_size,
question_22_answer = new_references.question_22_answer,
question_23_number = new_references.question_23_number,
question_23_size = new_references.question_23_size,
question_23_answer = new_references.question_23_answer,
question_24_number = new_references.question_24_number,
question_24_size = new_references.question_24_size,
question_24_answer = new_references.question_24_answer,
question_25_number = new_references.question_25_number,
question_25_size = new_references.question_25_size,
question_25_answer = new_references.question_25_answer,
question_26_number = new_references.question_26_number,
question_26_size = new_references.question_26_size,
question_26_answer = new_references.question_26_answer,
question_27_number = new_references.question_27_number,
question_27_size = new_references.question_27_size,
question_27_answer = new_references.question_27_answer,
question_28_number = new_references.question_28_number,
question_28_size = new_references.question_28_size,
question_28_answer = new_references.question_28_answer,
question_29_number = new_references.question_29_number,
question_29_size = new_references.question_29_size,
question_29_answer = new_references.question_29_answer,
question_30_number = new_references.question_30_number,
questions_30_size = new_references.questions_30_size,
question_30_answer = new_references.question_30_answer,
last_update_date = new_references.last_update_date,
last_updated_by = new_references.last_updated_by,
last_update_login = new_references.last_update_login,
legacy_record_flag = new_references.legacy_record_flag,
coa_duration_efc_amt = new_references.coa_duration_efc_amt,
coa_duration_num = new_references.coa_duration_num,
p_soc_sec_ben_student_amt = new_references.p_soc_sec_ben_student_amt,
p_tuit_fee_deduct_amt = new_references.p_tuit_fee_deduct_amt,
stu_lives_with_num = new_references.stu_lives_with_num,
stu_most_support_from_num = new_references.stu_most_support_from_num,
location_computer_num = new_references.location_computer_num
WHERE rowid = x_rowid;
END update_row;
|| Purpose : Adds a row if there is no existing row, otherwise updates existing row in the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
CURSOR c1 IS
SELECT rowid
FROM igf_ap_css_profile_all
WHERE cssp_id = x_cssp_id;
insert_row (
x_rowid,
x_cssp_id,
x_base_id,
x_system_record_type,
x_active_profile,
x_college_code,
x_academic_year,
x_stu_record_type,
x_css_id_number,
x_registration_receipt_date,
x_registration_type,
x_application_receipt_date,
x_application_type,
x_original_fnar_compute,
x_revision_fnar_compute_date,
x_electronic_extract_date,
x_institutional_reporting_type,
x_asr_receipt_date,
x_last_name,
x_first_name,
x_middle_initial,
x_address_number_and_street,
x_city,
x_state_mailing,
x_zip_code,
x_s_telephone_number,
x_s_title,
x_date_of_birth,
x_social_security_number,
x_state_legal_residence,
x_foreign_address_indicator,
x_foreign_postal_code,
x_country,
x_financial_aid_status,
x_year_in_college,
x_marital_status,
x_ward_court,
x_legal_dependents_other,
x_household_size,
x_number_in_college,
x_citizenship_status,
x_citizenship_country,
x_visa_classification,
x_tax_figures,
x_number_exemptions,
x_adjusted_gross_inc,
x_us_tax_paid,
x_itemized_deductions,
x_stu_income_work,
x_spouse_income_work,
x_divid_int_inc,
x_soc_sec_benefits,
x_welfare_tanf,
x_child_supp_rcvd,
x_earned_income_credit,
x_other_untax_income,
x_tax_stu_aid,
x_cash_sav_check,
x_ira_keogh,
x_invest_value,
x_invest_debt,
x_home_value,
x_home_debt,
x_oth_real_value,
x_oth_real_debt,
x_bus_farm_value,
x_bus_farm_debt,
x_live_on_farm,
x_home_purch_price,
x_hope_ll_credit,
x_home_purch_year,
x_trust_amount,
x_trust_avail,
x_trust_estab,
x_child_support_paid,
x_med_dent_expenses,
x_vet_us,
x_vet_ben_amount,
x_vet_ben_months,
x_stu_summer_wages,
x_stu_school_yr_wages,
x_spouse_summer_wages,
x_spouse_school_yr_wages,
x_summer_other_tax_inc,
x_school_yr_other_tax_inc,
x_summer_untax_inc,
x_school_yr_untax_inc,
x_grants_schol_etc,
x_tuit_benefits,
x_cont_parents,
x_cont_relatives,
x_p_siblings_pre_tuit,
x_p_student_pre_tuit,
x_p_household_size,
x_p_number_in_college,
x_p_parents_in_college,
x_p_marital_status,
x_p_state_legal_residence,
x_p_natural_par_status,
x_p_child_supp_paid,
x_p_repay_ed_loans,
x_p_med_dent_expenses,
x_p_tuit_paid_amount,
x_p_tuit_paid_number,
x_p_exp_child_supp_paid,
x_p_exp_repay_ed_loans,
x_p_exp_med_dent_expenses,
x_p_exp_tuit_pd_amount,
x_p_exp_tuit_pd_number,
x_p_cash_sav_check,
x_p_month_mortgage_pay,
x_p_invest_value,
x_p_invest_debt,
x_p_home_value,
x_p_home_debt,
x_p_home_purch_price,
x_p_own_business_farm,
x_p_business_value,
x_p_business_debt,
x_p_farm_value,
x_p_farm_debt,
x_p_live_on_farm,
x_p_oth_real_estate_value,
x_p_oth_real_estate_debt,
x_p_oth_real_purch_price,
x_p_siblings_assets,
x_p_home_purch_year,
x_p_oth_real_purch_year,
x_p_prior_agi,
x_p_prior_us_tax_paid,
x_p_prior_item_deductions,
x_p_prior_other_untax_inc,
x_p_tax_figures,
x_p_number_exemptions,
x_p_adjusted_gross_inc,
x_p_wages_sal_tips,
x_p_interest_income,
x_p_dividend_income,
x_p_net_inc_bus_farm,
x_p_other_taxable_income,
x_p_adj_to_income,
x_p_us_tax_paid,
x_p_itemized_deductions,
x_p_father_income_work,
x_p_mother_income_work,
x_p_soc_sec_ben,
x_p_welfare_tanf,
x_p_child_supp_rcvd,
x_p_ded_ira_keogh,
x_p_tax_defer_pens_savs,
x_p_dep_care_med_spending,
x_p_earned_income_credit,
x_p_living_allow,
x_p_tax_exmpt_int,
x_p_foreign_inc_excl,
x_p_other_untax_inc,
x_p_hope_ll_credit,
x_p_yr_separation,
x_p_yr_divorce,
x_p_exp_father_inc,
x_p_exp_mother_inc,
x_p_exp_other_tax_inc,
x_p_exp_other_untax_inc,
x_line_2_relation,
x_line_2_attend_college,
x_line_3_relation,
x_line_3_attend_college,
x_line_4_relation,
x_line_4_attend_college,
x_line_5_relation,
x_line_5_attend_college,
x_line_6_relation,
x_line_6_attend_college,
x_line_7_relation,
x_line_7_attend_college,
x_line_8_relation,
x_line_8_attend_college,
x_p_age_father,
x_p_age_mother,
x_p_div_sep_ind,
x_b_cont_non_custodial_par,
x_college_type_2,
x_college_type_3,
x_college_type_4,
x_college_type_5,
x_college_type_6,
x_college_type_7,
x_college_type_8,
x_school_code_1,
x_housing_code_1,
x_school_code_2,
x_housing_code_2,
x_school_code_3,
x_housing_code_3,
x_school_code_4,
x_housing_code_4,
x_school_code_5,
x_housing_code_5,
x_school_code_6,
x_housing_code_6,
x_school_code_7,
x_housing_code_7,
x_school_code_8,
x_housing_code_8,
x_school_code_9,
x_housing_code_9,
x_school_code_10,
x_housing_code_10,
x_additional_school_code_1,
x_additional_school_code_2,
x_additional_school_code_3,
x_additional_school_code_4,
x_additional_school_code_5,
x_additional_school_code_6,
x_additional_school_code_7,
x_additional_school_code_8,
x_additional_school_code_9,
x_additional_school_code_10,
x_explanation_spec_circum,
x_signature_student,
x_signature_spouse,
x_signature_father,
x_signature_mother,
x_month_day_completed,
x_year_completed,
x_age_line_2,
x_age_line_3,
x_age_line_4,
x_age_line_5,
x_age_line_6,
x_age_line_7,
x_age_line_8,
x_a_online_signature,
x_question_1_number,
x_question_1_size,
x_question_1_answer,
x_question_2_number,
x_question_2_size,
x_question_2_answer,
x_question_3_number,
x_question_3_size,
x_question_3_answer,
x_question_4_number,
x_question_4_size,
x_question_4_answer,
x_question_5_number,
x_question_5_size,
x_question_5_answer,
x_question_6_number,
x_question_6_size,
x_question_6_answer,
x_question_7_number,
x_question_7_size,
x_question_7_answer,
x_question_8_number,
x_question_8_size,
x_question_8_answer,
x_question_9_number,
x_question_9_size,
x_question_9_answer,
x_question_10_number,
x_question_10_size,
x_question_10_answer,
x_question_11_number,
x_question_11_size,
x_question_11_answer,
x_question_12_number,
x_question_12_size,
x_question_12_answer,
x_question_13_number,
x_question_13_size,
x_question_13_answer,
x_question_14_number,
x_question_14_size,
x_question_14_answer,
x_question_15_number,
x_question_15_size,
x_question_15_answer,
x_question_16_number,
x_question_16_size,
x_question_16_answer,
x_question_17_number,
x_question_17_size,
x_question_17_answer,
x_question_18_number,
x_question_18_size,
x_question_18_answer,
x_question_19_number,
x_question_19_size,
x_question_19_answer,
x_question_20_number,
x_question_20_size,
x_question_20_answer,
x_question_21_number,
x_question_21_size,
x_question_21_answer,
x_question_22_number,
x_question_22_size,
x_question_22_answer,
x_question_23_number,
x_question_23_size,
x_question_23_answer,
x_question_24_number,
x_question_24_size,
x_question_24_answer,
x_question_25_number,
x_question_25_size,
x_question_25_answer,
x_question_26_number,
x_question_26_size,
x_question_26_answer,
x_question_27_number,
x_question_27_size,
x_question_27_answer,
x_question_28_number,
x_question_28_size,
x_question_28_answer,
x_question_29_number,
x_question_29_size,
x_question_29_answer,
x_question_30_number,
x_questions_30_size,
x_question_30_answer,
x_mode ,
x_legacy_record_flag,
x_coa_duration_efc_amt,
x_coa_duration_num,
x_p_soc_sec_ben_student_amt,
x_p_tuit_fee_deduct_amt,
x_stu_lives_with_num,
x_stu_most_support_from_num,
x_location_computer_num
);
update_row (
x_rowid,
x_cssp_id,
x_base_id,
x_system_record_type,
x_active_profile,
x_college_code,
x_academic_year,
x_stu_record_type,
x_css_id_number,
x_registration_receipt_date,
x_registration_type,
x_application_receipt_date,
x_application_type,
x_original_fnar_compute,
x_revision_fnar_compute_date,
x_electronic_extract_date,
x_institutional_reporting_type,
x_asr_receipt_date,
x_last_name,
x_first_name,
x_middle_initial,
x_address_number_and_street,
x_city,
x_state_mailing,
x_zip_code,
x_s_telephone_number,
x_s_title,
x_date_of_birth,
x_social_security_number,
x_state_legal_residence,
x_foreign_address_indicator,
x_foreign_postal_code,
x_country,
x_financial_aid_status,
x_year_in_college,
x_marital_status,
x_ward_court,
x_legal_dependents_other,
x_household_size,
x_number_in_college,
x_citizenship_status,
x_citizenship_country,
x_visa_classification,
x_tax_figures,
x_number_exemptions,
x_adjusted_gross_inc,
x_us_tax_paid,
x_itemized_deductions,
x_stu_income_work,
x_spouse_income_work,
x_divid_int_inc,
x_soc_sec_benefits,
x_welfare_tanf,
x_child_supp_rcvd,
x_earned_income_credit,
x_other_untax_income,
x_tax_stu_aid,
x_cash_sav_check,
x_ira_keogh,
x_invest_value,
x_invest_debt,
x_home_value,
x_home_debt,
x_oth_real_value,
x_oth_real_debt,
x_bus_farm_value,
x_bus_farm_debt,
x_live_on_farm,
x_home_purch_price,
x_hope_ll_credit,
x_home_purch_year,
x_trust_amount,
x_trust_avail,
x_trust_estab,
x_child_support_paid,
x_med_dent_expenses,
x_vet_us,
x_vet_ben_amount,
x_vet_ben_months,
x_stu_summer_wages,
x_stu_school_yr_wages,
x_spouse_summer_wages,
x_spouse_school_yr_wages,
x_summer_other_tax_inc,
x_school_yr_other_tax_inc,
x_summer_untax_inc,
x_school_yr_untax_inc,
x_grants_schol_etc,
x_tuit_benefits,
x_cont_parents,
x_cont_relatives,
x_p_siblings_pre_tuit,
x_p_student_pre_tuit,
x_p_household_size,
x_p_number_in_college,
x_p_parents_in_college,
x_p_marital_status,
x_p_state_legal_residence,
x_p_natural_par_status,
x_p_child_supp_paid,
x_p_repay_ed_loans,
x_p_med_dent_expenses,
x_p_tuit_paid_amount,
x_p_tuit_paid_number,
x_p_exp_child_supp_paid,
x_p_exp_repay_ed_loans,
x_p_exp_med_dent_expenses,
x_p_exp_tuit_pd_amount,
x_p_exp_tuit_pd_number,
x_p_cash_sav_check,
x_p_month_mortgage_pay,
x_p_invest_value,
x_p_invest_debt,
x_p_home_value,
x_p_home_debt,
x_p_home_purch_price,
x_p_own_business_farm,
x_p_business_value,
x_p_business_debt,
x_p_farm_value,
x_p_farm_debt,
x_p_live_on_farm,
x_p_oth_real_estate_value,
x_p_oth_real_estate_debt,
x_p_oth_real_purch_price,
x_p_siblings_assets,
x_p_home_purch_year,
x_p_oth_real_purch_year,
x_p_prior_agi,
x_p_prior_us_tax_paid,
x_p_prior_item_deductions,
x_p_prior_other_untax_inc,
x_p_tax_figures,
x_p_number_exemptions,
x_p_adjusted_gross_inc,
x_p_wages_sal_tips,
x_p_interest_income,
x_p_dividend_income,
x_p_net_inc_bus_farm,
x_p_other_taxable_income,
x_p_adj_to_income,
x_p_us_tax_paid,
x_p_itemized_deductions,
x_p_father_income_work,
x_p_mother_income_work,
x_p_soc_sec_ben,
x_p_welfare_tanf,
x_p_child_supp_rcvd,
x_p_ded_ira_keogh,
x_p_tax_defer_pens_savs,
x_p_dep_care_med_spending,
x_p_earned_income_credit,
x_p_living_allow,
x_p_tax_exmpt_int,
x_p_foreign_inc_excl,
x_p_other_untax_inc,
x_p_hope_ll_credit,
x_p_yr_separation,
x_p_yr_divorce,
x_p_exp_father_inc,
x_p_exp_mother_inc,
x_p_exp_other_tax_inc,
x_p_exp_other_untax_inc,
x_line_2_relation,
x_line_2_attend_college,
x_line_3_relation,
x_line_3_attend_college,
x_line_4_relation,
x_line_4_attend_college,
x_line_5_relation,
x_line_5_attend_college,
x_line_6_relation,
x_line_6_attend_college,
x_line_7_relation,
x_line_7_attend_college,
x_line_8_relation,
x_line_8_attend_college,
x_p_age_father,
x_p_age_mother,
x_p_div_sep_ind,
x_b_cont_non_custodial_par,
x_college_type_2,
x_college_type_3,
x_college_type_4,
x_college_type_5,
x_college_type_6,
x_college_type_7,
x_college_type_8,
x_school_code_1,
x_housing_code_1,
x_school_code_2,
x_housing_code_2,
x_school_code_3,
x_housing_code_3,
x_school_code_4,
x_housing_code_4,
x_school_code_5,
x_housing_code_5,
x_school_code_6,
x_housing_code_6,
x_school_code_7,
x_housing_code_7,
x_school_code_8,
x_housing_code_8,
x_school_code_9,
x_housing_code_9,
x_school_code_10,
x_housing_code_10,
x_additional_school_code_1,
x_additional_school_code_2,
x_additional_school_code_3,
x_additional_school_code_4,
x_additional_school_code_5,
x_additional_school_code_6,
x_additional_school_code_7,
x_additional_school_code_8,
x_additional_school_code_9,
x_additional_school_code_10,
x_explanation_spec_circum,
x_signature_student,
x_signature_spouse,
x_signature_father,
x_signature_mother,
x_month_day_completed,
x_year_completed,
x_age_line_2,
x_age_line_3,
x_age_line_4,
x_age_line_5,
x_age_line_6,
x_age_line_7,
x_age_line_8,
x_a_online_signature,
x_question_1_number,
x_question_1_size,
x_question_1_answer,
x_question_2_number,
x_question_2_size,
x_question_2_answer,
x_question_3_number,
x_question_3_size,
x_question_3_answer,
x_question_4_number,
x_question_4_size,
x_question_4_answer,
x_question_5_number,
x_question_5_size,
x_question_5_answer,
x_question_6_number,
x_question_6_size,
x_question_6_answer,
x_question_7_number,
x_question_7_size,
x_question_7_answer,
x_question_8_number,
x_question_8_size,
x_question_8_answer,
x_question_9_number,
x_question_9_size,
x_question_9_answer,
x_question_10_number,
x_question_10_size,
x_question_10_answer,
x_question_11_number,
x_question_11_size,
x_question_11_answer,
x_question_12_number,
x_question_12_size,
x_question_12_answer,
x_question_13_number,
x_question_13_size,
x_question_13_answer,
x_question_14_number,
x_question_14_size,
x_question_14_answer,
x_question_15_number,
x_question_15_size,
x_question_15_answer,
x_question_16_number,
x_question_16_size,
x_question_16_answer,
x_question_17_number,
x_question_17_size,
x_question_17_answer,
x_question_18_number,
x_question_18_size,
x_question_18_answer,
x_question_19_number,
x_question_19_size,
x_question_19_answer,
x_question_20_number,
x_question_20_size,
x_question_20_answer,
x_question_21_number,
x_question_21_size,
x_question_21_answer,
x_question_22_number,
x_question_22_size,
x_question_22_answer,
x_question_23_number,
x_question_23_size,
x_question_23_answer,
x_question_24_number,
x_question_24_size,
x_question_24_answer,
x_question_25_number,
x_question_25_size,
x_question_25_answer,
x_question_26_number,
x_question_26_size,
x_question_26_answer,
x_question_27_number,
x_question_27_size,
x_question_27_answer,
x_question_28_number,
x_question_28_size,
x_question_28_answer,
x_question_29_number,
x_question_29_size,
x_question_29_answer,
x_question_30_number,
x_questions_30_size,
x_question_30_answer,
x_mode,
x_legacy_record_flag,
x_coa_duration_efc_amt,
x_coa_duration_num,
x_p_soc_sec_ben_student_amt,
x_p_tuit_fee_deduct_amt,
x_stu_lives_with_num,
x_stu_most_support_from_num,
x_location_computer_num
);
PROCEDURE delete_row (
x_rowid IN VARCHAR2
) AS
/*
|| Created By : vivuyyur
|| Created On : 29-MAY-2001
|| Purpose : Handles the DELETE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
BEGIN
before_dml (
p_action => 'DELETE',
x_rowid => x_rowid
);
DELETE FROM igf_ap_css_profile_all
WHERE rowid = x_rowid;
END delete_row;