The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_cl_rec_status_last_update IN DATE DEFAULT NULL,
x_alt_prog_type_code IN VARCHAR2 DEFAULT NULL,
x_alt_appl_ver_code IN NUMBER DEFAULT NULL,
x_borw_outstd_loan_code IN VARCHAR2 DEFAULT NULL,
x_mpn_confirm_code IN VARCHAR2 DEFAULT NULL,
x_resp_to_orig_code IN VARCHAR2 DEFAULT NULL,
x_appl_loan_phase_code IN VARCHAR2 DEFAULT NULL,
x_appl_loan_phase_code_chg IN DATE DEFAULT NULL,
x_tot_outstd_stafford IN NUMBER DEFAULT NULL,
x_tot_outstd_plus IN NUMBER DEFAULT NULL,
x_alt_borw_tot_debt IN NUMBER DEFAULT NULL,
x_act_interest_rate IN NUMBER DEFAULT NULL,
x_service_type_code IN VARCHAR2 DEFAULT NULL,
x_rev_notice_of_guarnt IN VARCHAR2 DEFAULT NULL,
x_sch_refund_amt IN NUMBER DEFAULT NULL,
x_sch_refund_date IN DATE DEFAULT NULL,
x_uniq_layout_vend_code IN VARCHAR2 DEFAULT NULL,
x_uniq_layout_ident_code IN VARCHAR2 DEFAULT NULL,
x_p_person_id IN NUMBER DEFAULT NULL,
x_p_ssn IN VARCHAR2 DEFAULT NULL,
x_p_ssn_chg_date IN DATE DEFAULT NULL,
x_p_last_name IN VARCHAR2 DEFAULT NULL,
x_p_first_name IN VARCHAR2 DEFAULT NULL,
x_p_middle_name IN VARCHAR2 DEFAULT NULL,
x_p_permt_addr1 IN VARCHAR2 DEFAULT NULL,
x_p_permt_addr2 IN VARCHAR2 DEFAULT NULL,
x_p_permt_city IN VARCHAR2 DEFAULT NULL,
x_p_permt_state IN VARCHAR2 DEFAULT NULL,
x_p_permt_zip IN VARCHAR2 DEFAULT NULL,
x_p_permt_addr_chg_date IN DATE DEFAULT NULL,
x_p_permt_phone IN VARCHAR2 DEFAULT NULL,
x_p_email_addr IN VARCHAR2 DEFAULT NULL,
x_p_date_of_birth IN DATE DEFAULT NULL,
x_p_dob_chg_date IN DATE DEFAULT NULL,
x_p_license_num IN VARCHAR2 DEFAULT NULL,
x_p_license_state IN VARCHAR2 DEFAULT NULL,
x_p_citizenship_status IN VARCHAR2 DEFAULT NULL,
x_p_alien_reg_num IN VARCHAR2 DEFAULT NULL,
x_p_default_status IN VARCHAR2 DEFAULT NULL,
x_p_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
x_p_state_of_legal_res IN VARCHAR2 DEFAULT NULL,
x_p_legal_res_date IN DATE DEFAULT NULL,
x_s_ssn IN VARCHAR2 DEFAULT NULL,
x_s_ssn_chg_date IN DATE DEFAULT NULL,
x_s_last_name IN VARCHAR2 DEFAULT NULL,
x_s_first_name IN VARCHAR2 DEFAULT NULL,
x_s_middle_name IN VARCHAR2 DEFAULT NULL,
x_s_permt_addr1 IN VARCHAR2 DEFAULT NULL,
x_s_permt_addr2 IN VARCHAR2 DEFAULT NULL,
x_s_permt_city IN VARCHAR2 DEFAULT NULL,
x_s_permt_state IN VARCHAR2 DEFAULT NULL,
x_s_permt_zip IN VARCHAR2 DEFAULT NULL,
x_s_permt_addr_chg_date IN DATE DEFAULT NULL,
x_s_permt_phone IN VARCHAR2 DEFAULT NULL,
x_s_local_addr1 IN VARCHAR2 DEFAULT NULL,
x_s_local_addr2 IN VARCHAR2 DEFAULT NULL,
x_s_local_city IN VARCHAR2 DEFAULT NULL,
x_s_local_state IN VARCHAR2 DEFAULT NULL,
x_s_local_zip IN VARCHAR2 DEFAULT NULL,
x_s_local_addr_chg_date IN DATE DEFAULT NULL,
x_s_email_addr IN VARCHAR2 DEFAULT NULL,
x_s_date_of_birth IN DATE DEFAULT NULL,
x_s_dob_chg_date IN DATE DEFAULT NULL,
x_s_license_num IN VARCHAR2 DEFAULT NULL,
x_s_license_state IN VARCHAR2 DEFAULT NULL,
x_s_depncy_status IN VARCHAR2 DEFAULT NULL,
x_s_default_status IN VARCHAR2 DEFAULT NULL,
x_s_citizenship_status IN VARCHAR2 DEFAULT NULL,
x_s_alien_reg_num IN VARCHAR2 DEFAULT NULL,
x_s_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
x_creation_date IN DATE DEFAULT NULL,
x_created_by IN NUMBER DEFAULT NULL,
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_pnote_batch_id IN VARCHAR2 DEFAULT NULL,
x_pnote_ack_date IN DATE DEFAULT NULL,
x_pnote_mpn_ind IN VARCHAR2 DEFAULT NULL,
x_award_id IN NUMBER DEFAULT NULL,
x_base_id IN NUMBER DEFAULT NULL,
x_document_id_txt IN VARCHAR2 DEFAULT NULL,
x_loan_key_num IN NUMBER DEFAULT NULL,
x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
x_fin_award_year IN VARCHAR2 DEFAULT NULL,
x_cps_trans_num IN NUMBER DEFAULT NULL,
x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
x_source_entity_id_txt IN VARCHAR2 DEFAULT NULL,
x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
x_pymt_servicer_date IN DATE DEFAULT NULL,
x_book_loan_amt IN NUMBER DEFAULT NULL,
x_book_loan_amt_date IN DATE DEFAULT NULL,
x_s_chg_birth_date IN DATE DEFAULT NULL,
x_s_chg_ssn IN VARCHAR2 DEFAULT NULL,
x_s_chg_last_name IN VARCHAR2 DEFAULT NULL,
x_b_chg_birth_date IN DATE DEFAULT NULL,
x_b_chg_ssn IN VARCHAR2 DEFAULT NULL,
x_b_chg_last_name IN VARCHAR2 DEFAULT NULL,
x_note_message IN VARCHAR2 DEFAULT NULL,
x_full_resp_code IN VARCHAR2 DEFAULT NULL,
x_s_permt_county IN VARCHAR2 DEFAULT NULL,
x_b_permt_county IN VARCHAR2 DEFAULT NULL,
x_s_permt_country IN VARCHAR2 DEFAULT NULL,
x_b_permt_country IN VARCHAR2 DEFAULT NULL,
x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
x_requested_loan_amt IN NUMBER DEFAULT NULL,
x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
x_reinstatement_amt IN NUMBER DEFAULT NULL,
x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
x_fls_approved_amt IN NUMBER DEFAULT NULL,
x_flu_approved_amt IN NUMBER DEFAULT NULL,
x_flp_approved_amt IN NUMBER DEFAULT NULL,
x_alt_approved_amt IN NUMBER DEFAULT NULL,
x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
x_alt_borrower_ind_flag IN VARCHAR2 DEFAULT NULL,
x_school_id_txt IN VARCHAR2 DEFAULT NULL,
x_cost_of_attendance_amt IN NUMBER DEFAULT NULL,
x_established_fin_aid_amount IN NUMBER DEFAULT NULL,
x_student_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
x_mpn_type_flag IN VARCHAR2 DEFAULT NULL,
x_school_use_txt IN VARCHAR2 DEFAULT NULL,
x_expect_family_contribute_amt IN NUMBER DEFAULT NULL,
x_borower_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
x_borower_credit_authoriz_flag IN VARCHAR2 DEFAULT NULL,
x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL
) AS
/*
|| Created By : venagara
|| Created On : 22-JAN-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_SL_LOR_LOC_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');
new_references.cl_rec_status_last_update := x_cl_rec_status_last_update;
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');
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
SELECT rowid
FROM igf_sl_lor_loc_all
WHERE loan_id = x_loan_id
FOR UPDATE NOWAIT;
SELECT rowid
FROM igf_sl_lor_loc_all
WHERE origination_id = x_origination_id
AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
SELECT rowid
FROM igf_sl_lor_loc_all
WHERE ((origination_id = x_origination_id));
SELECT rowid
FROM igf_sl_lor_loc_all
WHERE ((award_id = x_award_id));
SELECT rowid
FROM igf_sl_lor_loc_all
WHERE ((base_id = x_base_id));
x_cl_rec_status_last_update IN DATE DEFAULT NULL,
x_alt_prog_type_code IN VARCHAR2 DEFAULT NULL,
x_alt_appl_ver_code IN NUMBER DEFAULT NULL,
x_borw_outstd_loan_code IN VARCHAR2 DEFAULT NULL,
x_mpn_confirm_code IN VARCHAR2 DEFAULT NULL,
x_resp_to_orig_code IN VARCHAR2 DEFAULT NULL,
x_appl_loan_phase_code IN VARCHAR2 DEFAULT NULL,
x_appl_loan_phase_code_chg IN DATE DEFAULT NULL,
x_tot_outstd_stafford IN NUMBER DEFAULT NULL,
x_tot_outstd_plus IN NUMBER DEFAULT NULL,
x_alt_borw_tot_debt IN NUMBER DEFAULT NULL,
x_act_interest_rate IN NUMBER DEFAULT NULL,
x_service_type_code IN VARCHAR2 DEFAULT NULL,
x_rev_notice_of_guarnt IN VARCHAR2 DEFAULT NULL,
x_sch_refund_amt IN NUMBER DEFAULT NULL,
x_sch_refund_date IN DATE DEFAULT NULL,
x_uniq_layout_vend_code IN VARCHAR2 DEFAULT NULL,
x_uniq_layout_ident_code IN VARCHAR2 DEFAULT NULL,
x_p_person_id IN NUMBER DEFAULT NULL,
x_p_ssn IN VARCHAR2 DEFAULT NULL,
x_p_ssn_chg_date IN DATE DEFAULT NULL,
x_p_last_name IN VARCHAR2 DEFAULT NULL,
x_p_first_name IN VARCHAR2 DEFAULT NULL,
x_p_middle_name IN VARCHAR2 DEFAULT NULL,
x_p_permt_addr1 IN VARCHAR2 DEFAULT NULL,
x_p_permt_addr2 IN VARCHAR2 DEFAULT NULL,
x_p_permt_city IN VARCHAR2 DEFAULT NULL,
x_p_permt_state IN VARCHAR2 DEFAULT NULL,
x_p_permt_zip IN VARCHAR2 DEFAULT NULL,
x_p_permt_addr_chg_date IN DATE DEFAULT NULL,
x_p_permt_phone IN VARCHAR2 DEFAULT NULL,
x_p_email_addr IN VARCHAR2 DEFAULT NULL,
x_p_date_of_birth IN DATE DEFAULT NULL,
x_p_dob_chg_date IN DATE DEFAULT NULL,
x_p_license_num IN VARCHAR2 DEFAULT NULL,
x_p_license_state IN VARCHAR2 DEFAULT NULL,
x_p_citizenship_status IN VARCHAR2 DEFAULT NULL,
x_p_alien_reg_num IN VARCHAR2 DEFAULT NULL,
x_p_default_status IN VARCHAR2 DEFAULT NULL,
x_p_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
x_p_state_of_legal_res IN VARCHAR2 DEFAULT NULL,
x_p_legal_res_date IN DATE DEFAULT NULL,
x_s_ssn IN VARCHAR2 DEFAULT NULL,
x_s_ssn_chg_date IN DATE DEFAULT NULL,
x_s_last_name IN VARCHAR2 DEFAULT NULL,
x_s_first_name IN VARCHAR2 DEFAULT NULL,
x_s_middle_name IN VARCHAR2 DEFAULT NULL,
x_s_permt_addr1 IN VARCHAR2 DEFAULT NULL,
x_s_permt_addr2 IN VARCHAR2 DEFAULT NULL,
x_s_permt_city IN VARCHAR2 DEFAULT NULL,
x_s_permt_state IN VARCHAR2 DEFAULT NULL,
x_s_permt_zip IN VARCHAR2 DEFAULT NULL,
x_s_permt_addr_chg_date IN DATE DEFAULT NULL,
x_s_permt_phone IN VARCHAR2 DEFAULT NULL,
x_s_local_addr1 IN VARCHAR2 DEFAULT NULL,
x_s_local_addr2 IN VARCHAR2 DEFAULT NULL,
x_s_local_city IN VARCHAR2 DEFAULT NULL,
x_s_local_state IN VARCHAR2 DEFAULT NULL,
x_s_local_zip IN VARCHAR2 DEFAULT NULL,
x_s_local_addr_chg_date IN DATE DEFAULT NULL,
x_s_email_addr IN VARCHAR2 DEFAULT NULL,
x_s_date_of_birth IN DATE DEFAULT NULL,
x_s_dob_chg_date IN DATE DEFAULT NULL,
x_s_license_num IN VARCHAR2 DEFAULT NULL,
x_s_license_state IN VARCHAR2 DEFAULT NULL,
x_s_depncy_status IN VARCHAR2 DEFAULT NULL,
x_s_default_status IN VARCHAR2 DEFAULT NULL,
x_s_citizenship_status IN VARCHAR2 DEFAULT NULL,
x_s_alien_reg_num IN VARCHAR2 DEFAULT NULL,
x_s_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
x_creation_date IN DATE DEFAULT NULL,
x_created_by IN NUMBER DEFAULT NULL,
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_pnote_batch_id IN VARCHAR2 DEFAULT NULL,
x_pnote_ack_date IN DATE DEFAULT NULL,
x_pnote_mpn_ind IN VARCHAR2 DEFAULT NULL,
x_award_id IN NUMBER DEFAULT NULL,
x_base_id IN NUMBER DEFAULT NULL,
x_document_id_txt IN VARCHAR2 DEFAULT NULL,
x_loan_key_num IN NUMBER DEFAULT NULL,
x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
x_fin_award_year IN VARCHAR2 DEFAULT NULL,
x_cps_trans_num IN NUMBER DEFAULT NULL,
x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
x_source_entity_id_txt IN VARCHAR2 DEFAULT NULL,
x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
x_pymt_servicer_date IN DATE DEFAULT NULL,
x_book_loan_amt IN NUMBER DEFAULT NULL,
x_book_loan_amt_date IN DATE DEFAULT NULL,
x_s_chg_birth_date IN DATE DEFAULT NULL,
x_s_chg_ssn IN VARCHAR2 DEFAULT NULL,
x_s_chg_last_name IN VARCHAR2 DEFAULT NULL,
x_b_chg_birth_date IN DATE DEFAULT NULL,
x_b_chg_ssn IN VARCHAR2 DEFAULT NULL,
x_b_chg_last_name IN VARCHAR2 DEFAULT NULL,
x_note_message IN VARCHAR2 DEFAULT NULL,
x_full_resp_code IN VARCHAR2 DEFAULT NULL,
x_s_permt_county IN VARCHAR2 DEFAULT NULL,
x_b_permt_county IN VARCHAR2 DEFAULT NULL,
x_s_permt_country IN VARCHAR2 DEFAULT NULL,
x_b_permt_country IN VARCHAR2 DEFAULT NULL,
x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
x_requested_loan_amt IN NUMBER DEFAULT NULL,
x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
x_reinstatement_amt IN NUMBER DEFAULT NULL,
x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
x_fls_approved_amt IN NUMBER DEFAULT NULL,
x_flu_approved_amt IN NUMBER DEFAULT NULL,
x_flp_approved_amt IN NUMBER DEFAULT NULL,
x_alt_approved_amt IN NUMBER DEFAULT NULL,
x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
x_alt_borrower_ind_flag IN VARCHAR2 DEFAULT NULL,
x_school_id_txt IN VARCHAR2 DEFAULT NULL,
x_cost_of_attendance_amt IN NUMBER DEFAULT NULL,
x_established_fin_aid_amount IN NUMBER DEFAULT NULL,
x_student_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
x_mpn_type_flag IN VARCHAR2 DEFAULT NULL,
x_school_use_txt IN VARCHAR2 DEFAULT NULL,
x_expect_family_contribute_amt IN NUMBER DEFAULT NULL,
x_borower_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
x_borower_credit_authoriz_flag IN VARCHAR2 DEFAULT NULL,
x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL
) AS
/*
|| Created By : venagara
|| Created On : 22-JAN-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_loan_id,
x_origination_id,
x_loan_number,
x_loan_type,
x_loan_amt_offered,
x_loan_amt_accepted,
x_loan_per_begin_date,
x_loan_per_end_date,
x_acad_yr_begin_date,
x_acad_yr_end_date,
x_loan_status,
x_loan_status_date,
x_loan_chg_status,
x_loan_chg_status_date,
x_req_serial_loan_code,
x_act_serial_loan_code,
x_active,
x_active_date,
x_sch_cert_date,
x_orig_status_flag,
x_orig_batch_id,
x_orig_batch_date,
x_chg_batch_id,
x_orig_ack_date,
x_credit_override,
x_credit_decision_date,
x_pnote_delivery_code,
x_pnote_status,
x_pnote_status_date,
x_pnote_id,
x_pnote_print_ind,
x_pnote_accept_amt,
x_pnote_accept_date,
x_p_signature_code,
x_p_signature_date,
x_s_signature_code,
x_unsub_elig_for_heal,
x_disclosure_print_ind,
x_orig_fee_perct,
x_borw_confirm_ind,
x_borw_interest_ind,
x_unsub_elig_for_depnt,
x_guarantee_amt,
x_guarantee_date,
x_guarnt_adj_ind,
x_guarnt_amt_redn_code,
x_guarnt_status_code,
x_guarnt_status_date,
x_lend_apprv_denied_code,
x_lend_apprv_denied_date,
x_lend_status_code,
x_lend_status_date,
x_grade_level_code,
x_enrollment_code,
x_anticip_compl_date,
x_borw_lender_id,
x_duns_borw_lender_id,
x_guarantor_id,
x_duns_guarnt_id,
x_prc_type_code,
x_rec_type_ind,
x_cl_loan_type,
x_cl_seq_number,
x_last_resort_lender,
x_lender_id,
x_duns_lender_id,
x_lend_non_ed_brc_id,
x_recipient_id,
x_recipient_type,
x_duns_recip_id,
x_recip_non_ed_brc_id,
x_cl_rec_status,
x_cl_rec_status_last_update,
x_alt_prog_type_code,
x_alt_appl_ver_code,
x_borw_outstd_loan_code,
x_mpn_confirm_code,
x_resp_to_orig_code,
x_appl_loan_phase_code,
x_appl_loan_phase_code_chg,
x_tot_outstd_stafford,
x_tot_outstd_plus,
x_alt_borw_tot_debt,
x_act_interest_rate,
x_service_type_code,
x_rev_notice_of_guarnt,
x_sch_refund_amt,
x_sch_refund_date,
x_uniq_layout_vend_code,
x_uniq_layout_ident_code,
x_p_person_id,
x_p_ssn,
x_p_ssn_chg_date,
x_p_last_name,
x_p_first_name,
x_p_middle_name,
x_p_permt_addr1,
x_p_permt_addr2,
x_p_permt_city,
x_p_permt_state,
x_p_permt_zip,
x_p_permt_addr_chg_date,
x_p_permt_phone,
x_p_email_addr,
x_p_date_of_birth,
x_p_dob_chg_date,
x_p_license_num,
x_p_license_state,
x_p_citizenship_status,
x_p_alien_reg_num,
x_p_default_status,
x_p_foreign_postal_code,
x_p_state_of_legal_res,
x_p_legal_res_date,
x_s_ssn,
x_s_ssn_chg_date,
x_s_last_name,
x_s_first_name,
x_s_middle_name,
x_s_permt_addr1,
x_s_permt_addr2,
x_s_permt_city,
x_s_permt_state,
x_s_permt_zip,
x_s_permt_addr_chg_date,
x_s_permt_phone,
x_s_local_addr1,
x_s_local_addr2,
x_s_local_city,
x_s_local_state,
x_s_local_zip,
x_s_local_addr_chg_date,
x_s_email_addr,
x_s_date_of_birth,
x_s_dob_chg_date,
x_s_license_num,
x_s_license_state,
x_s_depncy_status,
x_s_default_status,
x_s_citizenship_status,
x_s_alien_reg_num,
x_s_foreign_postal_code,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_pnote_batch_id,
x_pnote_ack_date,
x_pnote_mpn_ind,
x_award_id,
x_base_id,
x_document_id_txt,
x_loan_key_num,
x_interest_rebate_percent_num,
x_fin_award_year,
x_cps_trans_num,
x_atd_entity_id_txt,
x_rep_entity_id_txt,
x_source_entity_id_txt,
x_pymt_servicer_amt,
x_pymt_servicer_date,
x_book_loan_amt,
x_book_loan_amt_date,
x_s_chg_birth_date,
x_s_chg_ssn,
x_s_chg_last_name,
x_b_chg_birth_date,
x_b_chg_ssn,
x_b_chg_last_name,
x_note_message,
x_full_resp_code,
x_s_permt_county,
x_b_permt_county,
x_s_permt_country,
x_b_permt_country,
x_crdt_decision_status,
x_external_loan_id_txt ,
x_deferment_request_code ,
x_eft_authorization_code ,
x_requested_loan_amt ,
x_actual_record_type_code ,
x_reinstatement_amt ,
x_lender_use_txt ,
x_guarantor_use_txt ,
x_fls_approved_amt ,
x_flu_approved_amt ,
x_flp_approved_amt ,
x_alt_approved_amt ,
x_loan_app_form_code ,
x_alt_borrower_ind_flag ,
x_school_id_txt ,
x_cost_of_attendance_amt ,
x_established_fin_aid_amount ,
x_student_electronic_sign_flag,
x_mpn_type_flag ,
x_school_use_txt ,
x_expect_family_contribute_amt,
x_borower_electronic_sign_flag,
x_borower_credit_authoriz_flag,
x_esign_src_typ_cd
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation(
new_references.loan_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_uniqueness;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation (
new_references.loan_id
)
) THEN
fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'VALIDATE_UPDATE') THEN
check_uniqueness;
PROCEDURE insert_row (
x_rowid IN OUT NOCOPY VARCHAR2,
x_loan_id IN NUMBER,
x_origination_id IN NUMBER,
x_loan_number IN VARCHAR2,
x_loan_type IN VARCHAR2,
x_loan_amt_offered IN NUMBER,
x_loan_amt_accepted IN NUMBER,
x_loan_per_begin_date IN DATE,
x_loan_per_end_date IN DATE,
x_acad_yr_begin_date IN DATE,
x_acad_yr_end_date IN DATE,
x_loan_status IN VARCHAR2,
x_loan_status_date IN DATE,
x_loan_chg_status IN VARCHAR2,
x_loan_chg_status_date IN DATE,
x_req_serial_loan_code IN VARCHAR2,
x_act_serial_loan_code IN VARCHAR2,
x_active IN VARCHAR2,
x_active_date IN DATE,
x_sch_cert_date IN DATE,
x_orig_status_flag IN VARCHAR2,
x_orig_batch_id IN VARCHAR2,
x_orig_batch_date IN DATE,
x_chg_batch_id IN VARCHAR2,
x_orig_ack_date IN DATE,
x_credit_override IN VARCHAR2,
x_credit_decision_date IN DATE,
x_pnote_delivery_code IN VARCHAR2,
x_pnote_status IN VARCHAR2,
x_pnote_status_date IN DATE,
x_pnote_id IN VARCHAR2,
x_pnote_print_ind IN VARCHAR2,
x_pnote_accept_amt IN NUMBER,
x_pnote_accept_date IN DATE,
x_p_signature_code IN VARCHAR2,
x_p_signature_date IN DATE,
x_s_signature_code IN VARCHAR2,
x_unsub_elig_for_heal IN VARCHAR2,
x_disclosure_print_ind IN VARCHAR2,
x_orig_fee_perct IN NUMBER,
x_borw_confirm_ind IN VARCHAR2,
x_borw_interest_ind IN VARCHAR2,
x_unsub_elig_for_depnt IN VARCHAR2,
x_guarantee_amt IN NUMBER,
x_guarantee_date IN DATE,
x_guarnt_adj_ind IN VARCHAR2,
x_guarnt_amt_redn_code IN VARCHAR2,
x_guarnt_status_code IN VARCHAR2,
x_guarnt_status_date IN DATE,
x_lend_apprv_denied_code IN VARCHAR2,
x_lend_apprv_denied_date IN DATE,
x_lend_status_code IN VARCHAR2,
x_lend_status_date IN DATE,
x_grade_level_code IN VARCHAR2,
x_enrollment_code IN VARCHAR2,
x_anticip_compl_date IN DATE,
x_borw_lender_id IN VARCHAR2,
x_duns_borw_lender_id IN VARCHAR2,
x_guarantor_id IN VARCHAR2,
x_duns_guarnt_id IN VARCHAR2,
x_prc_type_code IN VARCHAR2,
x_rec_type_ind IN VARCHAR2,
x_cl_loan_type IN VARCHAR2,
x_cl_seq_number IN NUMBER,
x_last_resort_lender IN VARCHAR2,
x_lender_id IN VARCHAR2,
x_duns_lender_id IN VARCHAR2,
x_lend_non_ed_brc_id IN VARCHAR2,
x_recipient_id IN VARCHAR2,
x_recipient_type IN VARCHAR2,
x_duns_recip_id IN VARCHAR2,
x_recip_non_ed_brc_id IN VARCHAR2,
x_cl_rec_status IN VARCHAR2,
x_cl_rec_status_last_update IN DATE,
x_alt_prog_type_code IN VARCHAR2,
x_alt_appl_ver_code IN NUMBER,
x_borw_outstd_loan_code IN VARCHAR2,
x_mpn_confirm_code IN VARCHAR2,
x_resp_to_orig_code IN VARCHAR2,
x_appl_loan_phase_code IN VARCHAR2,
x_appl_loan_phase_code_chg IN DATE,
x_tot_outstd_stafford IN NUMBER,
x_tot_outstd_plus IN NUMBER,
x_alt_borw_tot_debt IN NUMBER,
x_act_interest_rate IN NUMBER,
x_service_type_code IN VARCHAR2,
x_rev_notice_of_guarnt IN VARCHAR2,
x_sch_refund_amt IN NUMBER,
x_sch_refund_date IN DATE,
x_uniq_layout_vend_code IN VARCHAR2,
x_uniq_layout_ident_code IN VARCHAR2,
x_p_person_id IN NUMBER,
x_p_ssn IN VARCHAR2,
x_p_ssn_chg_date IN DATE,
x_p_last_name IN VARCHAR2,
x_p_first_name IN VARCHAR2,
x_p_middle_name IN VARCHAR2,
x_p_permt_addr1 IN VARCHAR2,
x_p_permt_addr2 IN VARCHAR2,
x_p_permt_city IN VARCHAR2,
x_p_permt_state IN VARCHAR2,
x_p_permt_zip IN VARCHAR2,
x_p_permt_addr_chg_date IN DATE,
x_p_permt_phone IN VARCHAR2,
x_p_email_addr IN VARCHAR2,
x_p_date_of_birth IN DATE,
x_p_dob_chg_date IN DATE,
x_p_license_num IN VARCHAR2,
x_p_license_state IN VARCHAR2,
x_p_citizenship_status IN VARCHAR2,
x_p_alien_reg_num IN VARCHAR2,
x_p_default_status IN VARCHAR2,
x_p_foreign_postal_code IN VARCHAR2,
x_p_state_of_legal_res IN VARCHAR2,
x_p_legal_res_date IN DATE,
x_s_ssn IN VARCHAR2,
x_s_ssn_chg_date IN DATE,
x_s_last_name IN VARCHAR2,
x_s_first_name IN VARCHAR2,
x_s_middle_name IN VARCHAR2,
x_s_permt_addr1 IN VARCHAR2,
x_s_permt_addr2 IN VARCHAR2,
x_s_permt_city IN VARCHAR2,
x_s_permt_state IN VARCHAR2,
x_s_permt_zip IN VARCHAR2,
x_s_permt_addr_chg_date IN DATE,
x_s_permt_phone IN VARCHAR2,
x_s_local_addr1 IN VARCHAR2,
x_s_local_addr2 IN VARCHAR2,
x_s_local_city IN VARCHAR2,
x_s_local_state IN VARCHAR2,
x_s_local_zip IN VARCHAR2,
x_s_local_addr_chg_date IN DATE,
x_s_email_addr IN VARCHAR2,
x_s_date_of_birth IN DATE,
x_s_dob_chg_date IN DATE,
x_s_license_num IN VARCHAR2,
x_s_license_state IN VARCHAR2,
x_s_depncy_status IN VARCHAR2,
x_s_default_status IN VARCHAR2,
x_s_citizenship_status IN VARCHAR2,
x_s_alien_reg_num IN VARCHAR2,
x_s_foreign_postal_code IN VARCHAR2,
x_mode IN VARCHAR2 DEFAULT 'R',
x_pnote_batch_id IN VARCHAR2,
x_pnote_ack_date IN DATE,
x_pnote_mpn_ind IN VARCHAR2,
x_award_id IN NUMBER,
x_base_id IN NUMBER,
x_document_id_txt IN VARCHAR2,
x_loan_key_num IN NUMBER,
x_interest_rebate_percent_num IN NUMBER,
x_fin_award_year IN VARCHAR2,
x_cps_trans_num IN NUMBER,
x_atd_entity_id_txt IN VARCHAR2,
x_rep_entity_id_txt IN VARCHAR2,
x_source_entity_id_txt IN VARCHAR2,
x_pymt_servicer_amt IN NUMBER,
x_pymt_servicer_date IN DATE,
x_book_loan_amt IN NUMBER,
x_book_loan_amt_date IN DATE,
x_s_chg_birth_date IN DATE,
x_s_chg_ssn IN VARCHAR2,
x_s_chg_last_name IN VARCHAR2,
x_b_chg_birth_date IN DATE,
x_b_chg_ssn IN VARCHAR2,
x_b_chg_last_name IN VARCHAR2,
x_note_message IN VARCHAR2,
x_full_resp_code IN VARCHAR2,
x_s_permt_county IN VARCHAR2,
x_b_permt_county IN VARCHAR2,
x_s_permt_country IN VARCHAR2,
x_b_permt_country IN VARCHAR2,
x_crdt_decision_status IN VARCHAR2,
x_external_loan_id_txt IN VARCHAR2,
x_deferment_request_code IN VARCHAR2,
x_eft_authorization_code IN VARCHAR2,
x_requested_loan_amt IN NUMBER ,
x_actual_record_type_code IN VARCHAR2,
x_reinstatement_amt IN NUMBER ,
x_lender_use_txt IN VARCHAR2,
x_guarantor_use_txt IN VARCHAR2,
x_fls_approved_amt IN NUMBER ,
x_flu_approved_amt IN NUMBER ,
x_flp_approved_amt IN NUMBER ,
x_alt_approved_amt IN NUMBER ,
x_loan_app_form_code IN VARCHAR2,
x_alt_borrower_ind_flag IN VARCHAR2,
x_school_id_txt IN VARCHAR2,
x_cost_of_attendance_amt IN NUMBER ,
x_established_fin_aid_amount IN NUMBER ,
x_student_electronic_sign_flag IN VARCHAR2,
x_mpn_type_flag IN VARCHAR2,
x_school_use_txt IN VARCHAR2,
x_expect_family_contribute_amt IN NUMBER ,
x_borower_electronic_sign_flag IN VARCHAR2,
x_borower_credit_authoriz_flag IN VARCHAR2,
x_esign_src_typ_cd IN VARCHAR2
) AS
/*
|| Created By : venagara
|| Created On : 22-JAN-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_sl_lor_loc_all
WHERE loan_id = x_loan_id;
x_last_update_date DATE;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
x_program_update_date DATE;
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;
x_program_update_date := NULL;
x_program_update_date := SYSDATE;
p_action => 'INSERT',
x_rowid => x_rowid,
x_loan_id => x_loan_id,
x_origination_id => x_origination_id,
x_loan_number => x_loan_number,
x_loan_type => x_loan_type,
x_loan_amt_offered => x_loan_amt_offered,
x_loan_amt_accepted => x_loan_amt_accepted,
x_loan_per_begin_date => x_loan_per_begin_date,
x_loan_per_end_date => x_loan_per_end_date,
x_acad_yr_begin_date => x_acad_yr_begin_date,
x_acad_yr_end_date => x_acad_yr_end_date,
x_loan_status => x_loan_status,
x_loan_status_date => x_loan_status_date,
x_loan_chg_status => x_loan_chg_status,
x_loan_chg_status_date => x_loan_chg_status_date,
x_req_serial_loan_code => x_req_serial_loan_code,
x_act_serial_loan_code => x_act_serial_loan_code,
x_active => x_active,
x_active_date => x_active_date,
x_sch_cert_date => x_sch_cert_date,
x_orig_status_flag => x_orig_status_flag,
x_orig_batch_id => x_orig_batch_id,
x_orig_batch_date => x_orig_batch_date,
x_chg_batch_id => x_chg_batch_id,
x_orig_ack_date => x_orig_ack_date,
x_credit_override => x_credit_override,
x_credit_decision_date => x_credit_decision_date,
x_pnote_delivery_code => x_pnote_delivery_code,
x_pnote_status => x_pnote_status,
x_pnote_status_date => x_pnote_status_date,
x_pnote_id => x_pnote_id,
x_pnote_print_ind => x_pnote_print_ind,
x_pnote_accept_amt => x_pnote_accept_amt,
x_pnote_accept_date => x_pnote_accept_date,
x_p_signature_code => x_p_signature_code,
x_p_signature_date => x_p_signature_date,
x_s_signature_code => x_s_signature_code,
x_unsub_elig_for_heal => x_unsub_elig_for_heal,
x_disclosure_print_ind => x_disclosure_print_ind,
x_orig_fee_perct => x_orig_fee_perct,
x_borw_confirm_ind => x_borw_confirm_ind,
x_borw_interest_ind => x_borw_interest_ind,
x_unsub_elig_for_depnt => x_unsub_elig_for_depnt,
x_guarantee_amt => x_guarantee_amt,
x_guarantee_date => x_guarantee_date,
x_guarnt_adj_ind => x_guarnt_adj_ind,
x_guarnt_amt_redn_code => x_guarnt_amt_redn_code,
x_guarnt_status_code => x_guarnt_status_code,
x_guarnt_status_date => x_guarnt_status_date,
x_lend_apprv_denied_code => x_lend_apprv_denied_code,
x_lend_apprv_denied_date => x_lend_apprv_denied_date,
x_lend_status_code => x_lend_status_code,
x_lend_status_date => x_lend_status_date,
x_grade_level_code => x_grade_level_code,
x_enrollment_code => x_enrollment_code,
x_anticip_compl_date => x_anticip_compl_date,
x_borw_lender_id => x_borw_lender_id,
x_duns_borw_lender_id => x_duns_borw_lender_id,
x_guarantor_id => x_guarantor_id,
x_duns_guarnt_id => x_duns_guarnt_id,
x_prc_type_code => x_prc_type_code,
x_rec_type_ind => x_rec_type_ind,
x_cl_loan_type => x_cl_loan_type,
x_cl_seq_number => x_cl_seq_number,
x_last_resort_lender => x_last_resort_lender,
x_lender_id => x_lender_id,
x_duns_lender_id => x_duns_lender_id,
x_lend_non_ed_brc_id => x_lend_non_ed_brc_id,
x_recipient_id => x_recipient_id,
x_recipient_type => x_recipient_type,
x_duns_recip_id => x_duns_recip_id,
x_recip_non_ed_brc_id => x_recip_non_ed_brc_id,
x_cl_rec_status => x_cl_rec_status,
x_cl_rec_status_last_update => x_cl_rec_status_last_update,
x_alt_prog_type_code => x_alt_prog_type_code,
x_alt_appl_ver_code => x_alt_appl_ver_code,
x_borw_outstd_loan_code => x_borw_outstd_loan_code,
x_mpn_confirm_code => x_mpn_confirm_code,
x_resp_to_orig_code => x_resp_to_orig_code,
x_appl_loan_phase_code => x_appl_loan_phase_code,
x_appl_loan_phase_code_chg => x_appl_loan_phase_code_chg,
x_tot_outstd_stafford => x_tot_outstd_stafford,
x_tot_outstd_plus => x_tot_outstd_plus,
x_alt_borw_tot_debt => x_alt_borw_tot_debt,
x_act_interest_rate => x_act_interest_rate,
x_service_type_code => x_service_type_code,
x_rev_notice_of_guarnt => x_rev_notice_of_guarnt,
x_sch_refund_amt => x_sch_refund_amt,
x_sch_refund_date => x_sch_refund_date,
x_uniq_layout_vend_code => x_uniq_layout_vend_code,
x_uniq_layout_ident_code => x_uniq_layout_ident_code,
x_p_person_id => x_p_person_id,
x_p_ssn => x_p_ssn,
x_p_ssn_chg_date => x_p_ssn_chg_date,
x_p_last_name => x_p_last_name,
x_p_first_name => x_p_first_name,
x_p_middle_name => x_p_middle_name,
x_p_permt_addr1 => x_p_permt_addr1,
x_p_permt_addr2 => x_p_permt_addr2,
x_p_permt_city => x_p_permt_city,
x_p_permt_state => x_p_permt_state,
x_p_permt_zip => x_p_permt_zip,
x_p_permt_addr_chg_date => x_p_permt_addr_chg_date,
x_p_permt_phone => x_p_permt_phone,
x_p_email_addr => x_p_email_addr,
x_p_date_of_birth => x_p_date_of_birth,
x_p_dob_chg_date => x_p_dob_chg_date,
x_p_license_num => x_p_license_num,
x_p_license_state => x_p_license_state,
x_p_citizenship_status => x_p_citizenship_status,
x_p_alien_reg_num => x_p_alien_reg_num,
x_p_default_status => x_p_default_status,
x_p_foreign_postal_code => x_p_foreign_postal_code,
x_p_state_of_legal_res => x_p_state_of_legal_res,
x_p_legal_res_date => x_p_legal_res_date,
x_s_ssn => x_s_ssn,
x_s_ssn_chg_date => x_s_ssn_chg_date,
x_s_last_name => x_s_last_name,
x_s_first_name => x_s_first_name,
x_s_middle_name => x_s_middle_name,
x_s_permt_addr1 => x_s_permt_addr1,
x_s_permt_addr2 => x_s_permt_addr2,
x_s_permt_city => x_s_permt_city,
x_s_permt_state => x_s_permt_state,
x_s_permt_zip => x_s_permt_zip,
x_s_permt_addr_chg_date => x_s_permt_addr_chg_date,
x_s_permt_phone => x_s_permt_phone,
x_s_local_addr1 => x_s_local_addr1,
x_s_local_addr2 => x_s_local_addr2,
x_s_local_city => x_s_local_city,
x_s_local_state => x_s_local_state,
x_s_local_zip => x_s_local_zip,
x_s_local_addr_chg_date => x_s_local_addr_chg_date,
x_s_email_addr => x_s_email_addr,
x_s_date_of_birth => x_s_date_of_birth,
x_s_dob_chg_date => x_s_dob_chg_date,
x_s_license_num => x_s_license_num,
x_s_license_state => x_s_license_state,
x_s_depncy_status => x_s_depncy_status,
x_s_default_status => x_s_default_status,
x_s_citizenship_status => x_s_citizenship_status,
x_s_alien_reg_num => x_s_alien_reg_num,
x_s_foreign_postal_code => x_s_foreign_postal_code,
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_pnote_batch_id => x_pnote_batch_id,
x_pnote_ack_date => x_pnote_ack_date,
x_pnote_mpn_ind => x_pnote_mpn_ind,
x_award_id => x_award_id,
x_base_id => x_base_id,
x_document_id_txt => x_document_id_txt,
x_loan_key_num => x_loan_key_num,
x_interest_rebate_percent_num => x_interest_rebate_percent_num,
x_fin_award_year => x_fin_award_year,
x_cps_trans_num => x_cps_trans_num,
x_atd_entity_id_txt => x_atd_entity_id_txt,
x_rep_entity_id_txt => x_rep_entity_id_txt,
x_source_entity_id_txt => x_source_entity_id_txt,
x_pymt_servicer_amt => x_pymt_servicer_amt,
x_pymt_servicer_date => x_pymt_servicer_date,
x_book_loan_amt => x_book_loan_amt,
x_book_loan_amt_date => x_book_loan_amt_date,
x_s_chg_birth_date => x_s_chg_birth_date,
x_s_chg_ssn => x_s_chg_ssn,
x_s_chg_last_name => x_s_chg_last_name,
x_b_chg_birth_date => x_b_chg_birth_date,
x_b_chg_ssn => x_b_chg_ssn,
x_b_chg_last_name => x_b_chg_last_name,
x_note_message => x_note_message,
x_full_resp_code => x_full_resp_code,
x_s_permt_county => x_s_permt_county,
x_b_permt_county => x_b_permt_county,
x_s_permt_country => x_s_permt_country,
x_b_permt_country => x_b_permt_country,
x_crdt_decision_status => x_crdt_decision_status,
x_external_loan_id_txt => x_external_loan_id_txt ,
x_deferment_request_code => x_deferment_request_code ,
x_eft_authorization_code => x_eft_authorization_code ,
x_requested_loan_amt => x_requested_loan_amt ,
x_actual_record_type_code => x_actual_record_type_code ,
x_reinstatement_amt => x_reinstatement_amt ,
x_lender_use_txt => x_lender_use_txt ,
x_guarantor_use_txt => x_guarantor_use_txt ,
x_fls_approved_amt => x_fls_approved_amt ,
x_flu_approved_amt => x_flu_approved_amt ,
x_flp_approved_amt => x_flp_approved_amt ,
x_alt_approved_amt => x_alt_approved_amt ,
x_loan_app_form_code => x_loan_app_form_code ,
x_alt_borrower_ind_flag => x_alt_borrower_ind_flag ,
x_school_id_txt => x_school_id_txt ,
x_cost_of_attendance_amt => x_cost_of_attendance_amt ,
x_established_fin_aid_amount => x_established_fin_aid_amount ,
x_student_electronic_sign_flag => x_student_electronic_sign_flag ,
x_mpn_type_flag => x_mpn_type_flag ,
x_school_use_txt => x_school_use_txt ,
x_expect_family_contribute_amt => x_expect_family_contribute_amt ,
x_borower_electronic_sign_flag => x_borower_electronic_sign_flag ,
x_borower_credit_authoriz_flag => x_borower_credit_authoriz_flag ,
x_esign_src_typ_cd => x_esign_src_typ_cd
);
INSERT INTO igf_sl_lor_loc_all(
loan_id,
origination_id,
loan_number,
loan_type,
loan_amt_offered,
loan_amt_accepted,
loan_per_begin_date,
loan_per_end_date,
acad_yr_begin_date,
acad_yr_end_date,
loan_status,
loan_status_date,
loan_chg_status,
loan_chg_status_date,
req_serial_loan_code,
act_serial_loan_code,
active,
active_date,
sch_cert_date,
orig_status_flag,
orig_batch_id,
orig_batch_date,
chg_batch_id,
orig_ack_date,
credit_override,
credit_decision_date,
pnote_delivery_code,
pnote_status,
pnote_status_date,
pnote_id,
pnote_print_ind,
pnote_accept_amt,
pnote_accept_date,
p_signature_code,
p_signature_date,
s_signature_code,
unsub_elig_for_heal,
disclosure_print_ind,
orig_fee_perct,
borw_confirm_ind,
borw_interest_ind,
unsub_elig_for_depnt,
guarantee_amt,
guarantee_date,
guarnt_adj_ind,
guarnt_amt_redn_code,
guarnt_status_code,
guarnt_status_date,
lend_apprv_denied_code,
lend_apprv_denied_date,
lend_status_code,
lend_status_date,
grade_level_code,
enrollment_code,
anticip_compl_date,
borw_lender_id,
guarantor_id,
prc_type_code,
rec_type_ind,
cl_loan_type,
cl_seq_number,
last_resort_lender,
lender_id,
lend_non_ed_brc_id,
recipient_id,
recipient_type,
recip_non_ed_brc_id,
cl_rec_status,
cl_rec_status_last_update,
alt_prog_type_code,
alt_appl_ver_code,
borw_outstd_loan_code,
mpn_confirm_code,
resp_to_orig_code,
appl_loan_phase_code,
appl_loan_phase_code_chg,
tot_outstd_stafford,
tot_outstd_plus,
alt_borw_tot_debt,
act_interest_rate,
service_type_code,
rev_notice_of_guarnt,
sch_refund_amt,
sch_refund_date,
uniq_layout_vend_code,
uniq_layout_ident_code,
p_person_id,
p_ssn,
p_ssn_chg_date,
p_last_name,
p_first_name,
p_middle_name,
p_permt_addr1,
p_permt_addr2,
p_permt_city,
p_permt_state,
p_permt_zip,
p_permt_addr_chg_date,
p_permt_phone,
p_email_addr,
p_date_of_birth,
p_dob_chg_date,
p_license_num,
p_license_state,
p_citizenship_status,
p_alien_reg_num,
p_default_status,
p_foreign_postal_code,
p_state_of_legal_res,
p_legal_res_date,
s_ssn,
s_ssn_chg_date,
s_last_name,
s_first_name,
s_middle_name,
s_permt_addr1,
s_permt_addr2,
s_permt_city,
s_permt_state,
s_permt_zip,
s_permt_addr_chg_date,
s_permt_phone,
s_local_addr1,
s_local_addr2,
s_local_city,
s_local_state,
s_local_zip,
s_local_addr_chg_date,
s_email_addr,
s_date_of_birth,
s_dob_chg_date,
s_license_num,
s_license_state,
s_depncy_status,
s_default_status,
s_citizenship_status,
s_alien_reg_num,
s_foreign_postal_code,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
request_id,
program_id,
program_application_id,
program_update_date,
org_id,
pnote_batch_id,
pnote_ack_date,
pnote_mpn_ind,
award_id,
base_id,
document_id_txt,
loan_key_num,
interest_rebate_percent_num,
fin_award_year,
cps_trans_num,
atd_entity_id_txt,
rep_entity_id_txt,
source_entity_id_txt,
pymt_servicer_amt,
pymt_servicer_date,
book_loan_amt,
book_loan_amt_date,
s_chg_birth_date,
s_chg_ssn,
s_chg_last_name,
b_chg_birth_date,
b_chg_ssn,
b_chg_last_name,
note_message,
full_resp_code,
s_permt_county,
b_permt_county,
s_permt_country,
b_permt_country,
crdt_decision_status,
external_loan_id_txt ,
deferment_request_code ,
eft_authorization_code ,
requested_loan_amt ,
actual_record_type_code ,
reinstatement_amt ,
lender_use_txt ,
guarantor_use_txt ,
fls_approved_amt ,
flu_approved_amt ,
flp_approved_amt ,
alt_approved_amt ,
loan_app_form_code ,
alt_borrower_ind_flag ,
school_id_txt ,
cost_of_attendance_amt ,
established_fin_aid_amount ,
student_electronic_sign_flag,
mpn_type_flag ,
school_use_txt ,
expect_family_contribute_amt,
borower_electronic_sign_flag,
borower_credit_authoriz_flag,
esign_src_typ_cd
) VALUES (
new_references.loan_id,
new_references.origination_id,
new_references.loan_number,
new_references.loan_type,
new_references.loan_amt_offered,
new_references.loan_amt_accepted,
new_references.loan_per_begin_date,
new_references.loan_per_end_date,
new_references.acad_yr_begin_date,
new_references.acad_yr_end_date,
new_references.loan_status,
new_references.loan_status_date,
new_references.loan_chg_status,
new_references.loan_chg_status_date,
new_references.req_serial_loan_code,
new_references.act_serial_loan_code,
new_references.active,
new_references.active_date,
new_references.sch_cert_date,
new_references.orig_status_flag,
new_references.orig_batch_id,
new_references.orig_batch_date,
new_references.chg_batch_id,
new_references.orig_ack_date,
new_references.credit_override,
new_references.credit_decision_date,
new_references.pnote_delivery_code,
new_references.pnote_status,
new_references.pnote_status_date,
new_references.pnote_id,
new_references.pnote_print_ind,
new_references.pnote_accept_amt,
new_references.pnote_accept_date,
new_references.p_signature_code,
new_references.p_signature_date,
new_references.s_signature_code,
new_references.unsub_elig_for_heal,
new_references.disclosure_print_ind,
new_references.orig_fee_perct,
new_references.borw_confirm_ind,
new_references.borw_interest_ind,
new_references.unsub_elig_for_depnt,
new_references.guarantee_amt,
new_references.guarantee_date,
new_references.guarnt_adj_ind,
new_references.guarnt_amt_redn_code,
new_references.guarnt_status_code,
new_references.guarnt_status_date,
new_references.lend_apprv_denied_code,
new_references.lend_apprv_denied_date,
new_references.lend_status_code,
new_references.lend_status_date,
new_references.grade_level_code,
new_references.enrollment_code,
new_references.anticip_compl_date,
new_references.borw_lender_id,
new_references.guarantor_id,
new_references.prc_type_code,
new_references.rec_type_ind,
new_references.cl_loan_type,
new_references.cl_seq_number,
new_references.last_resort_lender,
new_references.lender_id,
new_references.lend_non_ed_brc_id,
new_references.recipient_id,
new_references.recipient_type,
new_references.recip_non_ed_brc_id,
new_references.cl_rec_status,
new_references.cl_rec_status_last_update,
new_references.alt_prog_type_code,
new_references.alt_appl_ver_code,
new_references.borw_outstd_loan_code,
new_references.mpn_confirm_code,
new_references.resp_to_orig_code,
new_references.appl_loan_phase_code,
new_references.appl_loan_phase_code_chg,
new_references.tot_outstd_stafford,
new_references.tot_outstd_plus,
new_references.alt_borw_tot_debt,
new_references.act_interest_rate,
new_references.service_type_code,
new_references.rev_notice_of_guarnt,
new_references.sch_refund_amt,
new_references.sch_refund_date,
new_references.uniq_layout_vend_code,
new_references.uniq_layout_ident_code,
new_references.p_person_id,
new_references.p_ssn,
new_references.p_ssn_chg_date,
new_references.p_last_name,
new_references.p_first_name,
new_references.p_middle_name,
new_references.p_permt_addr1,
new_references.p_permt_addr2,
new_references.p_permt_city,
new_references.p_permt_state,
new_references.p_permt_zip,
new_references.p_permt_addr_chg_date,
new_references.p_permt_phone,
new_references.p_email_addr,
new_references.p_date_of_birth,
new_references.p_dob_chg_date,
new_references.p_license_num,
new_references.p_license_state,
new_references.p_citizenship_status,
new_references.p_alien_reg_num,
new_references.p_default_status,
new_references.p_foreign_postal_code,
new_references.p_state_of_legal_res,
new_references.p_legal_res_date,
new_references.s_ssn,
new_references.s_ssn_chg_date,
new_references.s_last_name,
new_references.s_first_name,
new_references.s_middle_name,
new_references.s_permt_addr1,
new_references.s_permt_addr2,
new_references.s_permt_city,
new_references.s_permt_state,
new_references.s_permt_zip,
new_references.s_permt_addr_chg_date,
new_references.s_permt_phone,
new_references.s_local_addr1,
new_references.s_local_addr2,
new_references.s_local_city,
new_references.s_local_state,
new_references.s_local_zip,
new_references.s_local_addr_chg_date,
new_references.s_email_addr,
new_references.s_date_of_birth,
new_references.s_dob_chg_date,
new_references.s_license_num,
new_references.s_license_state,
new_references.s_depncy_status,
new_references.s_default_status,
new_references.s_citizenship_status,
new_references.s_alien_reg_num,
new_references.s_foreign_postal_code,
x_last_update_date,
x_last_updated_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login ,
x_request_id,
x_program_id,
x_program_application_id,
x_program_update_date,
l_org_id,
new_references.pnote_batch_id,
new_references.pnote_ack_date,
new_references.pnote_mpn_ind,
new_references.award_id,
new_references.base_id,
new_references.document_id_txt,
new_references.loan_key_num,
new_references.interest_rebate_percent_num,
new_references.fin_award_year,
new_references.cps_trans_num,
new_references.atd_entity_id_txt,
new_references.rep_entity_id_txt,
new_references.source_entity_id_txt,
new_references.pymt_servicer_amt,
new_references.pymt_servicer_date,
new_references.book_loan_amt,
new_references.book_loan_amt_date,
new_references.s_chg_birth_date,
new_references.s_chg_ssn,
new_references.s_chg_last_name,
new_references.b_chg_birth_date,
new_references.b_chg_ssn,
new_references.b_chg_last_name,
new_references.note_message,
new_references.full_resp_code,
new_references.s_permt_county,
new_references.b_permt_county,
new_references.s_permt_country,
new_references.b_permt_country,
new_references.crdt_decision_status,
new_references.external_loan_id_txt ,
new_references.deferment_request_code ,
new_references.eft_authorization_code ,
new_references.requested_loan_amt ,
new_references.actual_record_type_code ,
new_references.reinstatement_amt ,
new_references.lender_use_txt ,
new_references.guarantor_use_txt ,
new_references.fls_approved_amt ,
new_references.flu_approved_amt ,
new_references.flp_approved_amt ,
new_references.alt_approved_amt ,
new_references.loan_app_form_code ,
new_references.alt_borrower_ind_flag ,
new_references.school_id_txt ,
new_references.cost_of_attendance_amt ,
new_references.established_fin_aid_amount ,
new_references.student_electronic_sign_flag,
new_references.mpn_type_flag ,
new_references.school_use_txt ,
new_references.expect_family_contribute_amt,
new_references.borower_electronic_sign_flag,
new_references.borower_credit_authoriz_flag,
new_references.esign_src_typ_cd
);
after_dml (p_action => 'INSERT');
END insert_row;
x_cl_rec_status_last_update IN DATE,
x_alt_prog_type_code IN VARCHAR2,
x_alt_appl_ver_code IN NUMBER,
x_borw_outstd_loan_code IN VARCHAR2,
x_mpn_confirm_code IN VARCHAR2,
x_resp_to_orig_code IN VARCHAR2,
x_appl_loan_phase_code IN VARCHAR2,
x_appl_loan_phase_code_chg IN DATE,
x_tot_outstd_stafford IN NUMBER,
x_tot_outstd_plus IN NUMBER,
x_alt_borw_tot_debt IN NUMBER,
x_act_interest_rate IN NUMBER,
x_service_type_code IN VARCHAR2,
x_rev_notice_of_guarnt IN VARCHAR2,
x_sch_refund_amt IN NUMBER,
x_sch_refund_date IN DATE,
x_uniq_layout_vend_code IN VARCHAR2,
x_uniq_layout_ident_code IN VARCHAR2,
x_p_person_id IN NUMBER,
x_p_ssn IN VARCHAR2,
x_p_ssn_chg_date IN DATE,
x_p_last_name IN VARCHAR2,
x_p_first_name IN VARCHAR2,
x_p_middle_name IN VARCHAR2,
x_p_permt_addr1 IN VARCHAR2,
x_p_permt_addr2 IN VARCHAR2,
x_p_permt_city IN VARCHAR2,
x_p_permt_state IN VARCHAR2,
x_p_permt_zip IN VARCHAR2,
x_p_permt_addr_chg_date IN DATE,
x_p_permt_phone IN VARCHAR2,
x_p_email_addr IN VARCHAR2,
x_p_date_of_birth IN DATE,
x_p_dob_chg_date IN DATE,
x_p_license_num IN VARCHAR2,
x_p_license_state IN VARCHAR2,
x_p_citizenship_status IN VARCHAR2,
x_p_alien_reg_num IN VARCHAR2,
x_p_default_status IN VARCHAR2,
x_p_foreign_postal_code IN VARCHAR2,
x_p_state_of_legal_res IN VARCHAR2,
x_p_legal_res_date IN DATE,
x_s_ssn IN VARCHAR2,
x_s_ssn_chg_date IN DATE,
x_s_last_name IN VARCHAR2,
x_s_first_name IN VARCHAR2,
x_s_middle_name IN VARCHAR2,
x_s_permt_addr1 IN VARCHAR2,
x_s_permt_addr2 IN VARCHAR2,
x_s_permt_city IN VARCHAR2,
x_s_permt_state IN VARCHAR2,
x_s_permt_zip IN VARCHAR2,
x_s_permt_addr_chg_date IN DATE,
x_s_permt_phone IN VARCHAR2,
x_s_local_addr1 IN VARCHAR2,
x_s_local_addr2 IN VARCHAR2,
x_s_local_city IN VARCHAR2,
x_s_local_state IN VARCHAR2,
x_s_local_zip IN VARCHAR2,
x_s_local_addr_chg_date IN DATE,
x_s_email_addr IN VARCHAR2,
x_s_date_of_birth IN DATE,
x_s_dob_chg_date IN DATE,
x_s_license_num IN VARCHAR2,
x_s_license_state IN VARCHAR2,
x_s_depncy_status IN VARCHAR2,
x_s_default_status IN VARCHAR2,
x_s_citizenship_status IN VARCHAR2,
x_s_alien_reg_num IN VARCHAR2,
x_s_foreign_postal_code IN VARCHAR2,
x_pnote_batch_id IN VARCHAR2,
x_pnote_ack_date IN DATE,
x_pnote_mpn_ind IN VARCHAR2,
x_award_id IN NUMBER,
x_base_id IN NUMBER,
x_document_id_txt IN VARCHAR2,
x_loan_key_num IN NUMBER,
x_interest_rebate_percent_num IN NUMBER,
x_fin_award_year IN VARCHAR2,
x_cps_trans_num IN NUMBER,
x_atd_entity_id_txt IN VARCHAR2,
x_rep_entity_id_txt IN VARCHAR2,
x_source_entity_id_txt IN VARCHAR2,
x_pymt_servicer_amt IN NUMBER,
x_pymt_servicer_date IN DATE,
x_book_loan_amt IN NUMBER,
x_book_loan_amt_date IN DATE,
x_s_chg_birth_date IN DATE,
x_s_chg_ssn IN VARCHAR2,
x_s_chg_last_name IN VARCHAR2,
x_b_chg_birth_date IN DATE,
x_b_chg_ssn IN VARCHAR2,
x_b_chg_last_name IN VARCHAR2,
x_note_message IN VARCHAR2,
x_full_resp_code IN VARCHAR2,
x_s_permt_county IN VARCHAR2,
x_b_permt_county IN VARCHAR2,
x_s_permt_country IN VARCHAR2,
x_b_permt_country IN VARCHAR2,
x_crdt_decision_status IN VARCHAR2,
x_external_loan_id_txt IN VARCHAR2,
x_deferment_request_code IN VARCHAR2,
x_eft_authorization_code IN VARCHAR2,
x_requested_loan_amt IN NUMBER ,
x_actual_record_type_code IN VARCHAR2,
x_reinstatement_amt IN NUMBER ,
x_lender_use_txt IN VARCHAR2,
x_guarantor_use_txt IN VARCHAR2,
x_fls_approved_amt IN NUMBER ,
x_flu_approved_amt IN NUMBER ,
x_flp_approved_amt IN NUMBER ,
x_alt_approved_amt IN NUMBER ,
x_loan_app_form_code IN VARCHAR2,
x_alt_borrower_ind_flag IN VARCHAR2,
x_school_id_txt IN VARCHAR2,
x_cost_of_attendance_amt IN NUMBER ,
x_established_fin_aid_amount IN NUMBER ,
x_student_electronic_sign_flag IN VARCHAR2,
x_mpn_type_flag IN VARCHAR2,
x_school_use_txt IN VARCHAR2,
x_expect_family_contribute_amt IN NUMBER ,
x_borower_electronic_sign_flag IN VARCHAR2,
x_borower_credit_authoriz_flag IN VARCHAR2,
x_esign_src_typ_cd IN VARCHAR2
) AS
/*
|| Created By : venagara
|| Created On : 22-JAN-2001
|| Purpose : Handles the LOCK mechanism for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| veramach 23-SEP-2003 Bug 3104228: Removed checks for lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
|| cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
|| p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
|| chg_batch_id from lock_row
|| (reverse chronological order - newest change first)
*/
CURSOR c1 IS
SELECT
origination_id,
loan_number,
loan_type,
loan_amt_offered,
loan_amt_accepted,
loan_per_begin_date,
loan_per_end_date,
acad_yr_begin_date,
acad_yr_end_date,
loan_status,
loan_status_date,
loan_chg_status,
loan_chg_status_date,
req_serial_loan_code,
act_serial_loan_code,
active,
active_date,
sch_cert_date,
orig_status_flag,
orig_batch_id,
orig_batch_date,
chg_batch_id,
orig_ack_date,
credit_override,
credit_decision_date,
pnote_delivery_code,
pnote_status,
pnote_status_date,
pnote_id,
pnote_print_ind,
pnote_accept_amt,
pnote_accept_date,
p_signature_code,
p_signature_date,
s_signature_code,
unsub_elig_for_heal,
disclosure_print_ind,
orig_fee_perct,
borw_confirm_ind,
borw_interest_ind,
unsub_elig_for_depnt,
guarantee_amt,
guarantee_date,
guarnt_adj_ind,
guarnt_amt_redn_code,
guarnt_status_code,
guarnt_status_date,
lend_apprv_denied_code,
lend_apprv_denied_date,
lend_status_code,
lend_status_date,
grade_level_code,
enrollment_code,
anticip_compl_date,
borw_lender_id,
guarantor_id,
prc_type_code,
rec_type_ind,
cl_loan_type,
cl_seq_number,
last_resort_lender,
lender_id,
lend_non_ed_brc_id,
recipient_id,
recipient_type,
recip_non_ed_brc_id,
cl_rec_status,
cl_rec_status_last_update,
alt_prog_type_code,
alt_appl_ver_code,
borw_outstd_loan_code,
mpn_confirm_code,
resp_to_orig_code,
appl_loan_phase_code,
appl_loan_phase_code_chg,
tot_outstd_stafford,
tot_outstd_plus,
alt_borw_tot_debt,
act_interest_rate,
service_type_code,
rev_notice_of_guarnt,
sch_refund_amt,
sch_refund_date,
uniq_layout_vend_code,
uniq_layout_ident_code,
p_person_id,
p_ssn,
p_ssn_chg_date,
p_last_name,
p_first_name,
p_middle_name,
p_permt_addr1,
p_permt_addr2,
p_permt_city,
p_permt_state,
p_permt_zip,
p_permt_addr_chg_date,
p_permt_phone,
p_email_addr,
p_date_of_birth,
p_dob_chg_date,
p_license_num,
p_license_state,
p_citizenship_status,
p_alien_reg_num,
p_default_status,
p_foreign_postal_code,
p_state_of_legal_res,
p_legal_res_date,
s_ssn,
s_ssn_chg_date,
s_last_name,
s_first_name,
s_middle_name,
s_permt_addr1,
s_permt_addr2,
s_permt_city,
s_permt_state,
s_permt_zip,
s_permt_addr_chg_date,
s_permt_phone,
s_local_addr1,
s_local_addr2,
s_local_city,
s_local_state,
s_local_zip,
s_local_addr_chg_date,
s_email_addr,
s_date_of_birth,
s_dob_chg_date,
s_license_num,
s_license_state,
s_depncy_status,
s_default_status,
s_citizenship_status,
s_alien_reg_num,
s_foreign_postal_code,
org_id,
pnote_batch_id,
pnote_ack_date,
pnote_mpn_ind,
award_id,
base_id,
document_id_txt,
loan_key_num,
interest_rebate_percent_num,
fin_award_year,
cps_trans_num,
atd_entity_id_txt,
rep_entity_id_txt,
source_entity_id_txt,
pymt_servicer_amt,
pymt_servicer_date,
book_loan_amt,
book_loan_amt_date,
s_chg_birth_date,
s_chg_ssn,
s_chg_last_name,
b_chg_birth_date,
b_chg_ssn,
b_chg_last_name,
note_message,
full_resp_code,
s_permt_county,
b_permt_county,
s_permt_country,
b_permt_country,
crdt_decision_status,
external_loan_id_txt ,
deferment_request_code ,
eft_authorization_code ,
requested_loan_amt ,
actual_record_type_code ,
reinstatement_amt ,
lender_use_txt ,
guarantor_use_txt ,
fls_approved_amt ,
flu_approved_amt ,
flp_approved_amt ,
alt_approved_amt ,
loan_app_form_code ,
alt_borrower_ind_flag ,
school_id_txt ,
cost_of_attendance_amt ,
established_fin_aid_amount ,
student_electronic_sign_flag,
mpn_type_flag ,
school_use_txt ,
expect_family_contribute_amt,
borower_electronic_sign_flag,
borower_credit_authoriz_flag,
esign_src_typ_cd
FROM igf_sl_lor_loc_all
WHERE rowid = x_rowid
FOR UPDATE NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_loan_id IN NUMBER,
x_origination_id IN NUMBER,
x_loan_number IN VARCHAR2,
x_loan_type IN VARCHAR2,
x_loan_amt_offered IN NUMBER,
x_loan_amt_accepted IN NUMBER,
x_loan_per_begin_date IN DATE,
x_loan_per_end_date IN DATE,
x_acad_yr_begin_date IN DATE,
x_acad_yr_end_date IN DATE,
x_loan_status IN VARCHAR2,
x_loan_status_date IN DATE,
x_loan_chg_status IN VARCHAR2,
x_loan_chg_status_date IN DATE,
x_req_serial_loan_code IN VARCHAR2,
x_act_serial_loan_code IN VARCHAR2,
x_active IN VARCHAR2,
x_active_date IN DATE,
x_sch_cert_date IN DATE,
x_orig_status_flag IN VARCHAR2,
x_orig_batch_id IN VARCHAR2,
x_orig_batch_date IN DATE,
x_chg_batch_id IN VARCHAR2,
x_orig_ack_date IN DATE,
x_credit_override IN VARCHAR2,
x_credit_decision_date IN DATE,
x_pnote_delivery_code IN VARCHAR2,
x_pnote_status IN VARCHAR2,
x_pnote_status_date IN DATE,
x_pnote_id IN VARCHAR2,
x_pnote_print_ind IN VARCHAR2,
x_pnote_accept_amt IN NUMBER,
x_pnote_accept_date IN DATE,
x_p_signature_code IN VARCHAR2,
x_p_signature_date IN DATE,
x_s_signature_code IN VARCHAR2,
x_unsub_elig_for_heal IN VARCHAR2,
x_disclosure_print_ind IN VARCHAR2,
x_orig_fee_perct IN NUMBER,
x_borw_confirm_ind IN VARCHAR2,
x_borw_interest_ind IN VARCHAR2,
x_unsub_elig_for_depnt IN VARCHAR2,
x_guarantee_amt IN NUMBER,
x_guarantee_date IN DATE,
x_guarnt_adj_ind IN VARCHAR2,
x_guarnt_amt_redn_code IN VARCHAR2,
x_guarnt_status_code IN VARCHAR2,
x_guarnt_status_date IN DATE,
x_lend_apprv_denied_code IN VARCHAR2,
x_lend_apprv_denied_date IN DATE,
x_lend_status_code IN VARCHAR2,
x_lend_status_date IN DATE,
x_grade_level_code IN VARCHAR2,
x_enrollment_code IN VARCHAR2,
x_anticip_compl_date IN DATE,
x_borw_lender_id IN VARCHAR2,
x_duns_borw_lender_id IN VARCHAR2,
x_guarantor_id IN VARCHAR2,
x_duns_guarnt_id IN VARCHAR2,
x_prc_type_code IN VARCHAR2,
x_rec_type_ind IN VARCHAR2,
x_cl_loan_type IN VARCHAR2,
x_cl_seq_number IN NUMBER,
x_last_resort_lender IN VARCHAR2,
x_lender_id IN VARCHAR2,
x_duns_lender_id IN VARCHAR2,
x_lend_non_ed_brc_id IN VARCHAR2,
x_recipient_id IN VARCHAR2,
x_recipient_type IN VARCHAR2,
x_duns_recip_id IN VARCHAR2,
x_recip_non_ed_brc_id IN VARCHAR2,
x_cl_rec_status IN VARCHAR2,
x_cl_rec_status_last_update IN DATE,
x_alt_prog_type_code IN VARCHAR2,
x_alt_appl_ver_code IN NUMBER,
x_borw_outstd_loan_code IN VARCHAR2,
x_mpn_confirm_code IN VARCHAR2,
x_resp_to_orig_code IN VARCHAR2,
x_appl_loan_phase_code IN VARCHAR2,
x_appl_loan_phase_code_chg IN DATE,
x_tot_outstd_stafford IN NUMBER,
x_tot_outstd_plus IN NUMBER,
x_alt_borw_tot_debt IN NUMBER,
x_act_interest_rate IN NUMBER,
x_service_type_code IN VARCHAR2,
x_rev_notice_of_guarnt IN VARCHAR2,
x_sch_refund_amt IN NUMBER,
x_sch_refund_date IN DATE,
x_uniq_layout_vend_code IN VARCHAR2,
x_uniq_layout_ident_code IN VARCHAR2,
x_p_person_id IN NUMBER,
x_p_ssn IN VARCHAR2,
x_p_ssn_chg_date IN DATE,
x_p_last_name IN VARCHAR2,
x_p_first_name IN VARCHAR2,
x_p_middle_name IN VARCHAR2,
x_p_permt_addr1 IN VARCHAR2,
x_p_permt_addr2 IN VARCHAR2,
x_p_permt_city IN VARCHAR2,
x_p_permt_state IN VARCHAR2,
x_p_permt_zip IN VARCHAR2,
x_p_permt_addr_chg_date IN DATE,
x_p_permt_phone IN VARCHAR2,
x_p_email_addr IN VARCHAR2,
x_p_date_of_birth IN DATE,
x_p_dob_chg_date IN DATE,
x_p_license_num IN VARCHAR2,
x_p_license_state IN VARCHAR2,
x_p_citizenship_status IN VARCHAR2,
x_p_alien_reg_num IN VARCHAR2,
x_p_default_status IN VARCHAR2,
x_p_foreign_postal_code IN VARCHAR2,
x_p_state_of_legal_res IN VARCHAR2,
x_p_legal_res_date IN DATE,
x_s_ssn IN VARCHAR2,
x_s_ssn_chg_date IN DATE,
x_s_last_name IN VARCHAR2,
x_s_first_name IN VARCHAR2,
x_s_middle_name IN VARCHAR2,
x_s_permt_addr1 IN VARCHAR2,
x_s_permt_addr2 IN VARCHAR2,
x_s_permt_city IN VARCHAR2,
x_s_permt_state IN VARCHAR2,
x_s_permt_zip IN VARCHAR2,
x_s_permt_addr_chg_date IN DATE,
x_s_permt_phone IN VARCHAR2,
x_s_local_addr1 IN VARCHAR2,
x_s_local_addr2 IN VARCHAR2,
x_s_local_city IN VARCHAR2,
x_s_local_state IN VARCHAR2,
x_s_local_zip IN VARCHAR2,
x_s_local_addr_chg_date IN DATE,
x_s_email_addr IN VARCHAR2,
x_s_date_of_birth IN DATE,
x_s_dob_chg_date IN DATE,
x_s_license_num IN VARCHAR2,
x_s_license_state IN VARCHAR2,
x_s_depncy_status IN VARCHAR2,
x_s_default_status IN VARCHAR2,
x_s_citizenship_status IN VARCHAR2,
x_s_alien_reg_num IN VARCHAR2,
x_s_foreign_postal_code IN VARCHAR2,
x_mode IN VARCHAR2 DEFAULT 'R',
x_pnote_batch_id IN VARCHAR2,
x_pnote_ack_date IN DATE,
x_pnote_mpn_ind IN VARCHAR2,
x_award_id IN NUMBER,
x_base_id IN NUMBER,
x_document_id_txt IN VARCHAR2,
x_loan_key_num IN NUMBER,
x_interest_rebate_percent_num IN NUMBER,
x_fin_award_year IN VARCHAR2,
x_cps_trans_num IN NUMBER,
x_atd_entity_id_txt IN VARCHAR2,
x_rep_entity_id_txt IN VARCHAR2,
x_source_entity_id_txt IN VARCHAR2,
x_pymt_servicer_amt IN NUMBER,
x_pymt_servicer_date IN DATE,
x_book_loan_amt IN NUMBER,
x_book_loan_amt_date IN DATE,
x_s_chg_birth_date IN DATE,
x_s_chg_ssn IN VARCHAR2,
x_s_chg_last_name IN VARCHAR2,
x_b_chg_birth_date IN DATE,
x_b_chg_ssn IN VARCHAR2,
x_b_chg_last_name IN VARCHAR2,
x_note_message IN VARCHAR2,
x_full_resp_code IN VARCHAR2,
x_s_permt_county IN VARCHAR2,
x_b_permt_county IN VARCHAR2,
x_s_permt_country IN VARCHAR2,
x_b_permt_country IN VARCHAR2,
x_crdt_decision_status IN VARCHAR2,
x_external_loan_id_txt IN VARCHAR2,
x_deferment_request_code IN VARCHAR2,
x_eft_authorization_code IN VARCHAR2,
x_requested_loan_amt IN NUMBER ,
x_actual_record_type_code IN VARCHAR2,
x_reinstatement_amt IN NUMBER ,
x_lender_use_txt IN VARCHAR2,
x_guarantor_use_txt IN VARCHAR2,
x_fls_approved_amt IN NUMBER ,
x_flu_approved_amt IN NUMBER ,
x_flp_approved_amt IN NUMBER ,
x_alt_approved_amt IN NUMBER ,
x_loan_app_form_code IN VARCHAR2,
x_alt_borrower_ind_flag IN VARCHAR2,
x_school_id_txt IN VARCHAR2,
x_cost_of_attendance_amt IN NUMBER ,
x_established_fin_aid_amount IN NUMBER ,
x_student_electronic_sign_flag IN VARCHAR2,
x_mpn_type_flag IN VARCHAR2,
x_school_use_txt IN VARCHAR2,
x_expect_family_contribute_amt IN NUMBER ,
x_borower_electronic_sign_flag IN VARCHAR2,
x_borower_credit_authoriz_flag IN VARCHAR2,
x_esign_src_typ_cd IN VARCHAR2
) AS
/*
|| Created By : venagara
|| Created On : 22-JAN-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_program_update_date DATE;
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_loan_id => x_loan_id,
x_origination_id => x_origination_id,
x_loan_number => x_loan_number,
x_loan_type => x_loan_type,
x_loan_amt_offered => x_loan_amt_offered,
x_loan_amt_accepted => x_loan_amt_accepted,
x_loan_per_begin_date => x_loan_per_begin_date,
x_loan_per_end_date => x_loan_per_end_date,
x_acad_yr_begin_date => x_acad_yr_begin_date,
x_acad_yr_end_date => x_acad_yr_end_date,
x_loan_status => x_loan_status,
x_loan_status_date => x_loan_status_date,
x_loan_chg_status => x_loan_chg_status,
x_loan_chg_status_date => x_loan_chg_status_date,
x_req_serial_loan_code => x_req_serial_loan_code,
x_act_serial_loan_code => x_act_serial_loan_code,
x_active => x_active,
x_active_date => x_active_date,
x_sch_cert_date => x_sch_cert_date,
x_orig_status_flag => x_orig_status_flag,
x_orig_batch_id => x_orig_batch_id,
x_orig_batch_date => x_orig_batch_date,
x_chg_batch_id => x_chg_batch_id,
x_orig_ack_date => x_orig_ack_date,
x_credit_override => x_credit_override,
x_credit_decision_date => x_credit_decision_date,
x_pnote_delivery_code => x_pnote_delivery_code,
x_pnote_status => x_pnote_status,
x_pnote_status_date => x_pnote_status_date,
x_pnote_id => x_pnote_id,
x_pnote_print_ind => x_pnote_print_ind,
x_pnote_accept_amt => x_pnote_accept_amt,
x_pnote_accept_date => x_pnote_accept_date,
x_p_signature_code => x_p_signature_code,
x_p_signature_date => x_p_signature_date,
x_s_signature_code => x_s_signature_code,
x_unsub_elig_for_heal => x_unsub_elig_for_heal,
x_disclosure_print_ind => x_disclosure_print_ind,
x_orig_fee_perct => x_orig_fee_perct,
x_borw_confirm_ind => x_borw_confirm_ind,
x_borw_interest_ind => x_borw_interest_ind,
x_unsub_elig_for_depnt => x_unsub_elig_for_depnt,
x_guarantee_amt => x_guarantee_amt,
x_guarantee_date => x_guarantee_date,
x_guarnt_adj_ind => x_guarnt_adj_ind,
x_guarnt_amt_redn_code => x_guarnt_amt_redn_code,
x_guarnt_status_code => x_guarnt_status_code,
x_guarnt_status_date => x_guarnt_status_date,
x_lend_apprv_denied_code => x_lend_apprv_denied_code,
x_lend_apprv_denied_date => x_lend_apprv_denied_date,
x_lend_status_code => x_lend_status_code,
x_lend_status_date => x_lend_status_date,
x_grade_level_code => x_grade_level_code,
x_enrollment_code => x_enrollment_code,
x_anticip_compl_date => x_anticip_compl_date,
x_borw_lender_id => x_borw_lender_id,
x_duns_borw_lender_id => x_duns_borw_lender_id,
x_guarantor_id => x_guarantor_id,
x_duns_guarnt_id => x_duns_guarnt_id,
x_prc_type_code => x_prc_type_code,
x_rec_type_ind => x_rec_type_ind,
x_cl_loan_type => x_cl_loan_type,
x_cl_seq_number => x_cl_seq_number,
x_last_resort_lender => x_last_resort_lender,
x_lender_id => x_lender_id,
x_duns_lender_id => x_duns_lender_id,
x_lend_non_ed_brc_id => x_lend_non_ed_brc_id,
x_recipient_id => x_recipient_id,
x_recipient_type => x_recipient_type,
x_duns_recip_id => x_duns_recip_id,
x_recip_non_ed_brc_id => x_recip_non_ed_brc_id,
x_cl_rec_status => x_cl_rec_status,
x_cl_rec_status_last_update => x_cl_rec_status_last_update,
x_alt_prog_type_code => x_alt_prog_type_code,
x_alt_appl_ver_code => x_alt_appl_ver_code,
x_borw_outstd_loan_code => x_borw_outstd_loan_code,
x_mpn_confirm_code => x_mpn_confirm_code,
x_resp_to_orig_code => x_resp_to_orig_code,
x_appl_loan_phase_code => x_appl_loan_phase_code,
x_appl_loan_phase_code_chg => x_appl_loan_phase_code_chg,
x_tot_outstd_stafford => x_tot_outstd_stafford,
x_tot_outstd_plus => x_tot_outstd_plus,
x_alt_borw_tot_debt => x_alt_borw_tot_debt,
x_act_interest_rate => x_act_interest_rate,
x_service_type_code => x_service_type_code,
x_rev_notice_of_guarnt => x_rev_notice_of_guarnt,
x_sch_refund_amt => x_sch_refund_amt,
x_sch_refund_date => x_sch_refund_date,
x_uniq_layout_vend_code => x_uniq_layout_vend_code,
x_uniq_layout_ident_code => x_uniq_layout_ident_code,
x_p_person_id => x_p_person_id,
x_p_ssn => x_p_ssn,
x_p_ssn_chg_date => x_p_ssn_chg_date,
x_p_last_name => x_p_last_name,
x_p_first_name => x_p_first_name,
x_p_middle_name => x_p_middle_name,
x_p_permt_addr1 => x_p_permt_addr1,
x_p_permt_addr2 => x_p_permt_addr2,
x_p_permt_city => x_p_permt_city,
x_p_permt_state => x_p_permt_state,
x_p_permt_zip => x_p_permt_zip,
x_p_permt_addr_chg_date => x_p_permt_addr_chg_date,
x_p_permt_phone => x_p_permt_phone,
x_p_email_addr => x_p_email_addr,
x_p_date_of_birth => x_p_date_of_birth,
x_p_dob_chg_date => x_p_dob_chg_date,
x_p_license_num => x_p_license_num,
x_p_license_state => x_p_license_state,
x_p_citizenship_status => x_p_citizenship_status,
x_p_alien_reg_num => x_p_alien_reg_num,
x_p_default_status => x_p_default_status,
x_p_foreign_postal_code => x_p_foreign_postal_code,
x_p_state_of_legal_res => x_p_state_of_legal_res,
x_p_legal_res_date => x_p_legal_res_date,
x_s_ssn => x_s_ssn,
x_s_ssn_chg_date => x_s_ssn_chg_date,
x_s_last_name => x_s_last_name,
x_s_first_name => x_s_first_name,
x_s_middle_name => x_s_middle_name,
x_s_permt_addr1 => x_s_permt_addr1,
x_s_permt_addr2 => x_s_permt_addr2,
x_s_permt_city => x_s_permt_city,
x_s_permt_state => x_s_permt_state,
x_s_permt_zip => x_s_permt_zip,
x_s_permt_addr_chg_date => x_s_permt_addr_chg_date,
x_s_permt_phone => x_s_permt_phone,
x_s_local_addr1 => x_s_local_addr1,
x_s_local_addr2 => x_s_local_addr2,
x_s_local_city => x_s_local_city,
x_s_local_state => x_s_local_state,
x_s_local_zip => x_s_local_zip,
x_s_local_addr_chg_date => x_s_local_addr_chg_date,
x_s_email_addr => x_s_email_addr,
x_s_date_of_birth => x_s_date_of_birth,
x_s_dob_chg_date => x_s_dob_chg_date,
x_s_license_num => x_s_license_num,
x_s_license_state => x_s_license_state,
x_s_depncy_status => x_s_depncy_status,
x_s_default_status => x_s_default_status,
x_s_citizenship_status => x_s_citizenship_status,
x_s_alien_reg_num => x_s_alien_reg_num,
x_s_foreign_postal_code => x_s_foreign_postal_code,
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_pnote_batch_id => x_pnote_batch_id,
x_pnote_ack_date => x_pnote_ack_date,
x_pnote_mpn_ind => x_pnote_mpn_ind,
x_award_id => x_award_id,
x_base_id => x_base_id,
x_document_id_txt => x_document_id_txt,
x_loan_key_num => x_loan_key_num,
x_interest_rebate_percent_num => x_interest_rebate_percent_num,
x_fin_award_year => x_fin_award_year,
x_cps_trans_num => x_cps_trans_num,
x_atd_entity_id_txt => x_atd_entity_id_txt,
x_rep_entity_id_txt => x_rep_entity_id_txt,
x_source_entity_id_txt => x_source_entity_id_txt,
x_pymt_servicer_amt => x_pymt_servicer_amt,
x_pymt_servicer_date => x_pymt_servicer_date,
x_book_loan_amt => x_book_loan_amt,
x_book_loan_amt_date => x_book_loan_amt_date,
x_s_chg_birth_date => x_s_chg_birth_date,
x_s_chg_ssn => x_s_chg_ssn,
x_s_chg_last_name => x_s_chg_last_name,
x_b_chg_birth_date => x_b_chg_birth_date,
x_b_chg_ssn => x_b_chg_ssn,
x_b_chg_last_name => x_b_chg_last_name,
x_note_message => x_note_message,
x_full_resp_code => x_full_resp_code,
x_s_permt_county => x_s_permt_county,
x_b_permt_county => x_b_permt_county,
x_s_permt_country => x_s_permt_country,
x_b_permt_country => x_b_permt_country,
x_crdt_decision_status => x_crdt_decision_status,
x_external_loan_id_txt => x_external_loan_id_txt ,
x_deferment_request_code => x_deferment_request_code ,
x_eft_authorization_code => x_eft_authorization_code ,
x_requested_loan_amt => x_requested_loan_amt ,
x_actual_record_type_code => x_actual_record_type_code ,
x_reinstatement_amt => x_reinstatement_amt ,
x_lender_use_txt => x_lender_use_txt ,
x_guarantor_use_txt => x_guarantor_use_txt ,
x_fls_approved_amt => x_fls_approved_amt ,
x_flu_approved_amt => x_flu_approved_amt ,
x_flp_approved_amt => x_flp_approved_amt ,
x_alt_approved_amt => x_alt_approved_amt ,
x_loan_app_form_code => x_loan_app_form_code ,
x_alt_borrower_ind_flag => x_alt_borrower_ind_flag ,
x_school_id_txt => x_school_id_txt ,
x_cost_of_attendance_amt => x_cost_of_attendance_amt ,
x_established_fin_aid_amount => x_established_fin_aid_amount ,
x_student_electronic_sign_flag => x_student_electronic_sign_flag ,
x_mpn_type_flag => x_mpn_type_flag ,
x_school_use_txt => x_school_use_txt ,
x_expect_family_contribute_amt => x_expect_family_contribute_amt ,
x_borower_electronic_sign_flag => x_borower_electronic_sign_flag ,
x_borower_credit_authoriz_flag => x_borower_credit_authoriz_flag ,
x_esign_src_typ_cd => x_esign_src_typ_cd
);
x_program_update_date := old_references.program_update_date;
x_program_update_date := SYSDATE;
UPDATE igf_sl_lor_loc_all
SET
origination_id = new_references.origination_id,
loan_number = new_references.loan_number,
loan_type = new_references.loan_type,
loan_amt_offered = new_references.loan_amt_offered,
loan_amt_accepted = new_references.loan_amt_accepted,
loan_per_begin_date = new_references.loan_per_begin_date,
loan_per_end_date = new_references.loan_per_end_date,
acad_yr_begin_date = new_references.acad_yr_begin_date,
acad_yr_end_date = new_references.acad_yr_end_date,
loan_status = new_references.loan_status,
loan_status_date = new_references.loan_status_date,
loan_chg_status = new_references.loan_chg_status,
loan_chg_status_date = new_references.loan_chg_status_date,
req_serial_loan_code = new_references.req_serial_loan_code,
act_serial_loan_code = new_references.act_serial_loan_code,
active = new_references.active,
active_date = new_references.active_date,
sch_cert_date = new_references.sch_cert_date,
orig_status_flag = new_references.orig_status_flag,
orig_batch_id = new_references.orig_batch_id,
orig_batch_date = new_references.orig_batch_date,
chg_batch_id = new_references.chg_batch_id,
orig_ack_date = new_references.orig_ack_date,
credit_override = new_references.credit_override,
credit_decision_date = new_references.credit_decision_date,
pnote_delivery_code = new_references.pnote_delivery_code,
pnote_status = new_references.pnote_status,
pnote_status_date = new_references.pnote_status_date,
pnote_id = new_references.pnote_id,
pnote_print_ind = new_references.pnote_print_ind,
pnote_accept_amt = new_references.pnote_accept_amt,
pnote_accept_date = new_references.pnote_accept_date,
p_signature_code = new_references.p_signature_code,
p_signature_date = new_references.p_signature_date,
s_signature_code = new_references.s_signature_code,
unsub_elig_for_heal = new_references.unsub_elig_for_heal,
disclosure_print_ind = new_references.disclosure_print_ind,
orig_fee_perct = new_references.orig_fee_perct,
borw_confirm_ind = new_references.borw_confirm_ind,
borw_interest_ind = new_references.borw_interest_ind,
unsub_elig_for_depnt = new_references.unsub_elig_for_depnt,
guarantee_amt = new_references.guarantee_amt,
guarantee_date = new_references.guarantee_date,
guarnt_adj_ind = new_references.guarnt_adj_ind,
guarnt_amt_redn_code = new_references.guarnt_amt_redn_code,
guarnt_status_code = new_references.guarnt_status_code,
guarnt_status_date = new_references.guarnt_status_date,
lend_apprv_denied_code = new_references.lend_apprv_denied_code,
lend_apprv_denied_date = new_references.lend_apprv_denied_date,
lend_status_code = new_references.lend_status_code,
lend_status_date = new_references.lend_status_date,
grade_level_code = new_references.grade_level_code,
enrollment_code = new_references.enrollment_code,
anticip_compl_date = new_references.anticip_compl_date,
borw_lender_id = new_references.borw_lender_id,
guarantor_id = new_references.guarantor_id,
prc_type_code = new_references.prc_type_code,
rec_type_ind = new_references.rec_type_ind,
cl_loan_type = new_references.cl_loan_type,
cl_seq_number = new_references.cl_seq_number,
last_resort_lender = new_references.last_resort_lender,
lender_id = new_references.lender_id,
lend_non_ed_brc_id = new_references.lend_non_ed_brc_id,
recipient_id = new_references.recipient_id,
recipient_type = new_references.recipient_type,
recip_non_ed_brc_id = new_references.recip_non_ed_brc_id,
cl_rec_status = new_references.cl_rec_status,
cl_rec_status_last_update = new_references.cl_rec_status_last_update,
alt_prog_type_code = new_references.alt_prog_type_code,
alt_appl_ver_code = new_references.alt_appl_ver_code,
borw_outstd_loan_code = new_references.borw_outstd_loan_code,
mpn_confirm_code = new_references.mpn_confirm_code,
resp_to_orig_code = new_references.resp_to_orig_code,
appl_loan_phase_code = new_references.appl_loan_phase_code,
appl_loan_phase_code_chg = new_references.appl_loan_phase_code_chg,
tot_outstd_stafford = new_references.tot_outstd_stafford,
tot_outstd_plus = new_references.tot_outstd_plus,
alt_borw_tot_debt = new_references.alt_borw_tot_debt,
act_interest_rate = new_references.act_interest_rate,
service_type_code = new_references.service_type_code,
rev_notice_of_guarnt = new_references.rev_notice_of_guarnt,
sch_refund_amt = new_references.sch_refund_amt,
sch_refund_date = new_references.sch_refund_date,
uniq_layout_vend_code = new_references.uniq_layout_vend_code,
uniq_layout_ident_code = new_references.uniq_layout_ident_code,
p_person_id = new_references.p_person_id,
p_ssn = new_references.p_ssn,
p_ssn_chg_date = new_references.p_ssn_chg_date,
p_last_name = new_references.p_last_name,
p_first_name = new_references.p_first_name,
p_middle_name = new_references.p_middle_name,
p_permt_addr1 = new_references.p_permt_addr1,
p_permt_addr2 = new_references.p_permt_addr2,
p_permt_city = new_references.p_permt_city,
p_permt_state = new_references.p_permt_state,
p_permt_zip = new_references.p_permt_zip,
p_permt_addr_chg_date = new_references.p_permt_addr_chg_date,
p_permt_phone = new_references.p_permt_phone,
p_email_addr = new_references.p_email_addr,
p_date_of_birth = new_references.p_date_of_birth,
p_dob_chg_date = new_references.p_dob_chg_date,
p_license_num = new_references.p_license_num,
p_license_state = new_references.p_license_state,
p_citizenship_status = new_references.p_citizenship_status,
p_alien_reg_num = new_references.p_alien_reg_num,
p_default_status = new_references.p_default_status,
p_foreign_postal_code = new_references.p_foreign_postal_code,
p_state_of_legal_res = new_references.p_state_of_legal_res,
p_legal_res_date = new_references.p_legal_res_date,
s_ssn = new_references.s_ssn,
s_ssn_chg_date = new_references.s_ssn_chg_date,
s_last_name = new_references.s_last_name,
s_first_name = new_references.s_first_name,
s_middle_name = new_references.s_middle_name,
s_permt_addr1 = new_references.s_permt_addr1,
s_permt_addr2 = new_references.s_permt_addr2,
s_permt_city = new_references.s_permt_city,
s_permt_state = new_references.s_permt_state,
s_permt_zip = new_references.s_permt_zip,
s_permt_addr_chg_date = new_references.s_permt_addr_chg_date,
s_permt_phone = new_references.s_permt_phone,
s_local_addr1 = new_references.s_local_addr1,
s_local_addr2 = new_references.s_local_addr2,
s_local_city = new_references.s_local_city,
s_local_state = new_references.s_local_state,
s_local_zip = new_references.s_local_zip,
s_local_addr_chg_date = new_references.s_local_addr_chg_date,
s_email_addr = new_references.s_email_addr,
s_date_of_birth = new_references.s_date_of_birth,
s_dob_chg_date = new_references.s_dob_chg_date,
s_license_num = new_references.s_license_num,
s_license_state = new_references.s_license_state,
s_depncy_status = new_references.s_depncy_status,
s_default_status = new_references.s_default_status,
s_citizenship_status = new_references.s_citizenship_status,
s_alien_reg_num = new_references.s_alien_reg_num,
s_foreign_postal_code = new_references.s_foreign_postal_code,
last_update_date = x_last_update_date,
last_updated_by = x_last_updated_by,
last_update_login = x_last_update_login ,
request_id = x_request_id,
program_id = x_program_id,
program_application_id = x_program_application_id,
program_update_date = x_program_update_date,
pnote_batch_id = x_pnote_batch_id,
pnote_ack_date = x_pnote_ack_date,
pnote_mpn_ind = x_pnote_mpn_ind,
award_id = new_references.award_id,
base_id = new_references.base_id,
document_id_txt = new_references.document_id_txt,
loan_key_num = new_references.loan_key_num,
interest_rebate_percent_num = new_references.interest_rebate_percent_num,
fin_award_year = new_references.fin_award_year,
cps_trans_num = new_references.cps_trans_num,
atd_entity_id_txt = new_references.atd_entity_id_txt,
rep_entity_id_txt = new_references.rep_entity_id_txt,
source_entity_id_txt = new_references.source_entity_id_txt,
pymt_servicer_amt = new_references.pymt_servicer_amt,
pymt_servicer_date = new_references.pymt_servicer_date,
book_loan_amt = new_references.book_loan_amt,
book_loan_amt_date = new_references.book_loan_amt_date,
s_chg_birth_date = new_references.s_chg_birth_date,
s_chg_ssn = new_references.s_chg_ssn,
s_chg_last_name = new_references.s_chg_last_name,
b_chg_birth_date = new_references.b_chg_birth_date,
b_chg_ssn = new_references.b_chg_ssn,
b_chg_last_name = new_references.b_chg_last_name,
note_message = new_references.note_message,
full_resp_code = new_references.full_resp_code,
s_permt_county = new_references.s_permt_county,
b_permt_county = new_references.b_permt_county,
s_permt_country = new_references.s_permt_country,
b_permt_country = new_references.b_permt_country,
crdt_decision_status = new_references.crdt_decision_status,
external_loan_id_txt = new_references.external_loan_id_txt ,
deferment_request_code = new_references.deferment_request_code ,
eft_authorization_code = new_references.eft_authorization_code ,
requested_loan_amt = new_references.requested_loan_amt ,
actual_record_type_code = new_references.actual_record_type_code ,
reinstatement_amt = new_references.reinstatement_amt ,
lender_use_txt = new_references.lender_use_txt ,
guarantor_use_txt = new_references.guarantor_use_txt ,
fls_approved_amt = new_references.fls_approved_amt ,
flu_approved_amt = new_references.flu_approved_amt ,
flp_approved_amt = new_references.flp_approved_amt ,
alt_approved_amt = new_references.alt_approved_amt ,
loan_app_form_code = new_references.loan_app_form_code ,
alt_borrower_ind_flag = new_references.alt_borrower_ind_flag ,
school_id_txt = new_references.school_id_txt ,
cost_of_attendance_amt = new_references.cost_of_attendance_amt ,
established_fin_aid_amount = new_references.established_fin_aid_amount ,
student_electronic_sign_flag = new_references.student_electronic_sign_flag,
mpn_type_flag = new_references.mpn_type_flag ,
school_use_txt = new_references.school_use_txt ,
expect_family_contribute_amt = new_references.expect_family_contribute_amt,
borower_electronic_sign_flag = new_references.borower_electronic_sign_flag,
borower_credit_authoriz_flag = new_references.borower_credit_authoriz_flag,
esign_src_typ_cd = new_references.esign_src_typ_cd
WHERE rowid = x_rowid;
after_dml (p_action => 'UPDATE');
END update_row;
x_cl_rec_status_last_update IN DATE,
x_alt_prog_type_code IN VARCHAR2,
x_alt_appl_ver_code IN NUMBER,
x_borw_outstd_loan_code IN VARCHAR2,
x_mpn_confirm_code IN VARCHAR2,
x_resp_to_orig_code IN VARCHAR2,
x_appl_loan_phase_code IN VARCHAR2,
x_appl_loan_phase_code_chg IN DATE,
x_tot_outstd_stafford IN NUMBER,
x_tot_outstd_plus IN NUMBER,
x_alt_borw_tot_debt IN NUMBER,
x_act_interest_rate IN NUMBER,
x_service_type_code IN VARCHAR2,
x_rev_notice_of_guarnt IN VARCHAR2,
x_sch_refund_amt IN NUMBER,
x_sch_refund_date IN DATE,
x_uniq_layout_vend_code IN VARCHAR2,
x_uniq_layout_ident_code IN VARCHAR2,
x_p_person_id IN NUMBER,
x_p_ssn IN VARCHAR2,
x_p_ssn_chg_date IN DATE,
x_p_last_name IN VARCHAR2,
x_p_first_name IN VARCHAR2,
x_p_middle_name IN VARCHAR2,
x_p_permt_addr1 IN VARCHAR2,
x_p_permt_addr2 IN VARCHAR2,
x_p_permt_city IN VARCHAR2,
x_p_permt_state IN VARCHAR2,
x_p_permt_zip IN VARCHAR2,
x_p_permt_addr_chg_date IN DATE,
x_p_permt_phone IN VARCHAR2,
x_p_email_addr IN VARCHAR2,
x_p_date_of_birth IN DATE,
x_p_dob_chg_date IN DATE,
x_p_license_num IN VARCHAR2,
x_p_license_state IN VARCHAR2,
x_p_citizenship_status IN VARCHAR2,
x_p_alien_reg_num IN VARCHAR2,
x_p_default_status IN VARCHAR2,
x_p_foreign_postal_code IN VARCHAR2,
x_p_state_of_legal_res IN VARCHAR2,
x_p_legal_res_date IN DATE,
x_s_ssn IN VARCHAR2,
x_s_ssn_chg_date IN DATE,
x_s_last_name IN VARCHAR2,
x_s_first_name IN VARCHAR2,
x_s_middle_name IN VARCHAR2,
x_s_permt_addr1 IN VARCHAR2,
x_s_permt_addr2 IN VARCHAR2,
x_s_permt_city IN VARCHAR2,
x_s_permt_state IN VARCHAR2,
x_s_permt_zip IN VARCHAR2,
x_s_permt_addr_chg_date IN DATE,
x_s_permt_phone IN VARCHAR2,
x_s_local_addr1 IN VARCHAR2,
x_s_local_addr2 IN VARCHAR2,
x_s_local_city IN VARCHAR2,
x_s_local_state IN VARCHAR2,
x_s_local_zip IN VARCHAR2,
x_s_local_addr_chg_date IN DATE,
x_s_email_addr IN VARCHAR2,
x_s_date_of_birth IN DATE,
x_s_dob_chg_date IN DATE,
x_s_license_num IN VARCHAR2,
x_s_license_state IN VARCHAR2,
x_s_depncy_status IN VARCHAR2,
x_s_default_status IN VARCHAR2,
x_s_citizenship_status IN VARCHAR2,
x_s_alien_reg_num IN VARCHAR2,
x_s_foreign_postal_code IN VARCHAR2,
x_mode IN VARCHAR2 DEFAULT 'R',
x_pnote_batch_id IN VARCHAR2,
x_pnote_ack_date IN DATE,
x_pnote_mpn_ind IN VARCHAR2,
x_award_id IN NUMBER,
x_base_id IN NUMBER,
x_document_id_txt IN VARCHAR2,
x_loan_key_num IN NUMBER,
x_interest_rebate_percent_num IN NUMBER,
x_fin_award_year IN VARCHAR2,
x_cps_trans_num IN NUMBER,
x_atd_entity_id_txt IN VARCHAR2,
x_rep_entity_id_txt IN VARCHAR2,
x_source_entity_id_txt IN VARCHAR2,
x_pymt_servicer_amt IN NUMBER,
x_pymt_servicer_date IN DATE,
x_book_loan_amt IN NUMBER,
x_book_loan_amt_date IN DATE,
x_s_chg_birth_date IN DATE,
x_s_chg_ssn IN VARCHAR2,
x_s_chg_last_name IN VARCHAR2,
x_b_chg_birth_date IN DATE,
x_b_chg_ssn IN VARCHAR2,
x_b_chg_last_name IN VARCHAR2,
x_note_message IN VARCHAR2,
x_full_resp_code IN VARCHAR2,
x_s_permt_county IN VARCHAR2,
x_b_permt_county IN VARCHAR2,
x_s_permt_country IN VARCHAR2,
x_b_permt_country IN VARCHAR2,
x_crdt_decision_status IN VARCHAR2,
x_external_loan_id_txt IN VARCHAR2,
x_deferment_request_code IN VARCHAR2,
x_eft_authorization_code IN VARCHAR2,
x_requested_loan_amt IN NUMBER ,
x_actual_record_type_code IN VARCHAR2,
x_reinstatement_amt IN NUMBER ,
x_lender_use_txt IN VARCHAR2,
x_guarantor_use_txt IN VARCHAR2,
x_fls_approved_amt IN NUMBER ,
x_flu_approved_amt IN NUMBER ,
x_flp_approved_amt IN NUMBER ,
x_alt_approved_amt IN NUMBER ,
x_loan_app_form_code IN VARCHAR2,
x_alt_borrower_ind_flag IN VARCHAR2,
x_school_id_txt IN VARCHAR2,
x_cost_of_attendance_amt IN NUMBER ,
x_established_fin_aid_amount IN NUMBER ,
x_student_electronic_sign_flag IN VARCHAR2,
x_mpn_type_flag IN VARCHAR2,
x_school_use_txt IN VARCHAR2,
x_expect_family_contribute_amt IN NUMBER ,
x_borower_electronic_sign_flag IN VARCHAR2,
x_borower_credit_authoriz_flag IN VARCHAR2,
x_esign_src_typ_cd IN VARCHAR2
) AS
/*
|| Created By : venagara
|| Created On : 22-JAN-2001
|| 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_sl_lor_loc_all
WHERE loan_id = x_loan_id;
insert_row (
x_rowid,
x_loan_id,
x_origination_id,
x_loan_number,
x_loan_type,
x_loan_amt_offered,
x_loan_amt_accepted,
x_loan_per_begin_date,
x_loan_per_end_date,
x_acad_yr_begin_date,
x_acad_yr_end_date,
x_loan_status,
x_loan_status_date,
x_loan_chg_status,
x_loan_chg_status_date,
x_req_serial_loan_code,
x_act_serial_loan_code,
x_active,
x_active_date,
x_sch_cert_date,
x_orig_status_flag,
x_orig_batch_id,
x_orig_batch_date,
x_chg_batch_id,
x_orig_ack_date,
x_credit_override,
x_credit_decision_date,
x_pnote_delivery_code,
x_pnote_status,
x_pnote_status_date,
x_pnote_id,
x_pnote_print_ind,
x_pnote_accept_amt,
x_pnote_accept_date,
x_p_signature_code,
x_p_signature_date,
x_s_signature_code,
x_unsub_elig_for_heal,
x_disclosure_print_ind,
x_orig_fee_perct,
x_borw_confirm_ind,
x_borw_interest_ind,
x_unsub_elig_for_depnt,
x_guarantee_amt,
x_guarantee_date,
x_guarnt_adj_ind,
x_guarnt_amt_redn_code,
x_guarnt_status_code,
x_guarnt_status_date,
x_lend_apprv_denied_code,
x_lend_apprv_denied_date,
x_lend_status_code,
x_lend_status_date,
x_grade_level_code,
x_enrollment_code,
x_anticip_compl_date,
x_borw_lender_id,
x_duns_borw_lender_id,
x_guarantor_id,
x_duns_guarnt_id,
x_prc_type_code,
x_rec_type_ind,
x_cl_loan_type,
x_cl_seq_number,
x_last_resort_lender,
x_lender_id,
x_duns_lender_id,
x_lend_non_ed_brc_id,
x_recipient_id,
x_recipient_type,
x_duns_recip_id,
x_recip_non_ed_brc_id,
x_cl_rec_status,
x_cl_rec_status_last_update,
x_alt_prog_type_code,
x_alt_appl_ver_code,
x_borw_outstd_loan_code,
x_mpn_confirm_code,
x_resp_to_orig_code,
x_appl_loan_phase_code,
x_appl_loan_phase_code_chg,
x_tot_outstd_stafford,
x_tot_outstd_plus,
x_alt_borw_tot_debt,
x_act_interest_rate,
x_service_type_code,
x_rev_notice_of_guarnt,
x_sch_refund_amt,
x_sch_refund_date,
x_uniq_layout_vend_code,
x_uniq_layout_ident_code,
x_p_person_id,
x_p_ssn,
x_p_ssn_chg_date,
x_p_last_name,
x_p_first_name,
x_p_middle_name,
x_p_permt_addr1,
x_p_permt_addr2,
x_p_permt_city,
x_p_permt_state,
x_p_permt_zip,
x_p_permt_addr_chg_date,
x_p_permt_phone,
x_p_email_addr,
x_p_date_of_birth,
x_p_dob_chg_date,
x_p_license_num,
x_p_license_state,
x_p_citizenship_status,
x_p_alien_reg_num,
x_p_default_status,
x_p_foreign_postal_code,
x_p_state_of_legal_res,
x_p_legal_res_date,
x_s_ssn,
x_s_ssn_chg_date,
x_s_last_name,
x_s_first_name,
x_s_middle_name,
x_s_permt_addr1,
x_s_permt_addr2,
x_s_permt_city,
x_s_permt_state,
x_s_permt_zip,
x_s_permt_addr_chg_date,
x_s_permt_phone,
x_s_local_addr1,
x_s_local_addr2,
x_s_local_city,
x_s_local_state,
x_s_local_zip,
x_s_local_addr_chg_date,
x_s_email_addr,
x_s_date_of_birth,
x_s_dob_chg_date,
x_s_license_num,
x_s_license_state,
x_s_depncy_status,
x_s_default_status,
x_s_citizenship_status,
x_s_alien_reg_num,
x_s_foreign_postal_code,
x_mode,
x_pnote_batch_id,
x_pnote_ack_date,
x_pnote_mpn_ind,
x_award_id,
x_base_id,
x_document_id_txt,
x_loan_key_num,
x_interest_rebate_percent_num,
x_fin_award_year,
x_cps_trans_num,
x_atd_entity_id_txt,
x_rep_entity_id_txt,
x_source_entity_id_txt,
x_pymt_servicer_amt,
x_pymt_servicer_date,
x_book_loan_amt,
x_book_loan_amt_date,
x_s_chg_birth_date,
x_s_chg_ssn,
x_s_chg_last_name,
x_b_chg_birth_date,
x_b_chg_ssn,
x_b_chg_last_name,
x_note_message,
x_full_resp_code,
x_s_permt_county,
x_b_permt_county,
x_s_permt_country,
x_b_permt_country,
x_crdt_decision_status,
x_external_loan_id_txt ,
x_deferment_request_code ,
x_eft_authorization_code ,
x_requested_loan_amt ,
x_actual_record_type_code ,
x_reinstatement_amt ,
x_lender_use_txt ,
x_guarantor_use_txt ,
x_fls_approved_amt ,
x_flu_approved_amt ,
x_flp_approved_amt ,
x_alt_approved_amt ,
x_loan_app_form_code ,
x_alt_borrower_ind_flag ,
x_school_id_txt ,
x_cost_of_attendance_amt ,
x_established_fin_aid_amount ,
x_student_electronic_sign_flag ,
x_mpn_type_flag ,
x_school_use_txt ,
x_expect_family_contribute_amt ,
x_borower_electronic_sign_flag ,
x_borower_credit_authoriz_flag ,
x_esign_src_typ_cd
);
update_row (
x_rowid,
x_loan_id,
x_origination_id,
x_loan_number,
x_loan_type,
x_loan_amt_offered,
x_loan_amt_accepted,
x_loan_per_begin_date,
x_loan_per_end_date,
x_acad_yr_begin_date,
x_acad_yr_end_date,
x_loan_status,
x_loan_status_date,
x_loan_chg_status,
x_loan_chg_status_date,
x_req_serial_loan_code,
x_act_serial_loan_code,
x_active,
x_active_date,
x_sch_cert_date,
x_orig_status_flag,
x_orig_batch_id,
x_orig_batch_date,
x_chg_batch_id,
x_orig_ack_date,
x_credit_override,
x_credit_decision_date,
x_pnote_delivery_code,
x_pnote_status,
x_pnote_status_date,
x_pnote_id,
x_pnote_print_ind,
x_pnote_accept_amt,
x_pnote_accept_date,
x_p_signature_code,
x_p_signature_date,
x_s_signature_code,
x_unsub_elig_for_heal,
x_disclosure_print_ind,
x_orig_fee_perct,
x_borw_confirm_ind,
x_borw_interest_ind,
x_unsub_elig_for_depnt,
x_guarantee_amt,
x_guarantee_date,
x_guarnt_adj_ind,
x_guarnt_amt_redn_code,
x_guarnt_status_code,
x_guarnt_status_date,
x_lend_apprv_denied_code,
x_lend_apprv_denied_date,
x_lend_status_code,
x_lend_status_date,
x_grade_level_code,
x_enrollment_code,
x_anticip_compl_date,
x_borw_lender_id,
x_duns_borw_lender_id,
x_guarantor_id,
x_duns_guarnt_id,
x_prc_type_code,
x_rec_type_ind,
x_cl_loan_type,
x_cl_seq_number,
x_last_resort_lender,
x_lender_id,
x_duns_lender_id,
x_lend_non_ed_brc_id,
x_recipient_id,
x_recipient_type,
x_duns_recip_id,
x_recip_non_ed_brc_id,
x_cl_rec_status,
x_cl_rec_status_last_update,
x_alt_prog_type_code,
x_alt_appl_ver_code,
x_borw_outstd_loan_code,
x_mpn_confirm_code,
x_resp_to_orig_code,
x_appl_loan_phase_code,
x_appl_loan_phase_code_chg,
x_tot_outstd_stafford,
x_tot_outstd_plus,
x_alt_borw_tot_debt,
x_act_interest_rate,
x_service_type_code,
x_rev_notice_of_guarnt,
x_sch_refund_amt,
x_sch_refund_date,
x_uniq_layout_vend_code,
x_uniq_layout_ident_code,
x_p_person_id,
x_p_ssn,
x_p_ssn_chg_date,
x_p_last_name,
x_p_first_name,
x_p_middle_name,
x_p_permt_addr1,
x_p_permt_addr2,
x_p_permt_city,
x_p_permt_state,
x_p_permt_zip,
x_p_permt_addr_chg_date,
x_p_permt_phone,
x_p_email_addr,
x_p_date_of_birth,
x_p_dob_chg_date,
x_p_license_num,
x_p_license_state,
x_p_citizenship_status,
x_p_alien_reg_num,
x_p_default_status,
x_p_foreign_postal_code,
x_p_state_of_legal_res,
x_p_legal_res_date,
x_s_ssn,
x_s_ssn_chg_date,
x_s_last_name,
x_s_first_name,
x_s_middle_name,
x_s_permt_addr1,
x_s_permt_addr2,
x_s_permt_city,
x_s_permt_state,
x_s_permt_zip,
x_s_permt_addr_chg_date,
x_s_permt_phone,
x_s_local_addr1,
x_s_local_addr2,
x_s_local_city,
x_s_local_state,
x_s_local_zip,
x_s_local_addr_chg_date,
x_s_email_addr,
x_s_date_of_birth,
x_s_dob_chg_date,
x_s_license_num,
x_s_license_state,
x_s_depncy_status,
x_s_default_status,
x_s_citizenship_status,
x_s_alien_reg_num,
x_s_foreign_postal_code,
x_mode,
x_pnote_batch_id,
x_pnote_ack_date,
x_pnote_mpn_ind,
x_award_id,
x_base_id,
x_document_id_txt,
x_loan_key_num,
x_interest_rebate_percent_num,
x_fin_award_year,
x_cps_trans_num,
x_atd_entity_id_txt,
x_rep_entity_id_txt,
x_source_entity_id_txt,
x_pymt_servicer_amt,
x_pymt_servicer_date,
x_book_loan_amt,
x_book_loan_amt_date,
x_s_chg_birth_date,
x_s_chg_ssn,
x_s_chg_last_name,
x_b_chg_birth_date,
x_b_chg_ssn,
x_b_chg_last_name,
x_note_message,
x_full_resp_code,
x_s_permt_county,
x_b_permt_county,
x_s_permt_country,
x_b_permt_country,
x_crdt_decision_status,
x_external_loan_id_txt ,
x_deferment_request_code ,
x_eft_authorization_code ,
x_requested_loan_amt ,
x_actual_record_type_code ,
x_reinstatement_amt ,
x_lender_use_txt ,
x_guarantor_use_txt ,
x_fls_approved_amt ,
x_flu_approved_amt ,
x_flp_approved_amt ,
x_alt_approved_amt ,
x_loan_app_form_code ,
x_alt_borrower_ind_flag ,
x_school_id_txt ,
x_cost_of_attendance_amt ,
x_established_fin_aid_amount ,
x_student_electronic_sign_flag ,
x_mpn_type_flag ,
x_school_use_txt ,
x_expect_family_contribute_amt ,
x_borower_electronic_sign_flag ,
x_borower_credit_authoriz_flag ,
x_esign_src_typ_cd
);
PROCEDURE delete_row (
x_rowid IN VARCHAR2
) AS
/*
|| Created By : venagara
|| Created On : 22-JAN-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_sl_lor_loc_all
WHERE rowid = x_rowid;
END delete_row;
|| Purpose : To insert in the history table also whenever
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| bvisvana 28-Feb-2006 Build FA161. TBH Impact change.
*/
l_rowid ROWID;
IF p_action = 'INSERT' THEN
l_source := 'SYSTEM';
ELSIF p_action='UPDATE' THEN
IF NVL(new_references.loan_status,'*') = 'S'
OR NVL(new_references.loan_chg_status,'*') = 'S' THEN
l_source := 'SYSTEM';
igf_sl_lor_loc_history_pkg.insert_row(
x_rowid => l_rowid,
x_loan_id => new_references.loan_id,
x_origination_id => new_references.origination_id,
x_loan_number => new_references.loan_number,
x_loan_type => new_references.loan_type,
x_loan_amt_offered => new_references.loan_amt_offered,
x_loan_amt_accepted => new_references.loan_amt_accepted,
x_loan_per_begin_date => new_references.loan_per_begin_date,
x_loan_per_end_date => new_references.loan_per_end_date,
x_acad_yr_begin_date => new_references.acad_yr_begin_date,
x_acad_yr_end_date => new_references.acad_yr_end_date,
x_loan_status => new_references.loan_status,
x_loan_status_date => new_references.loan_status_date,
x_loan_chg_status => new_references.loan_chg_status,
x_loan_chg_status_date => new_references.loan_chg_status_date,
x_req_serial_loan_code => new_references.req_serial_loan_code,
x_act_serial_loan_code => new_references.act_serial_loan_code,
x_active => new_references.active,
x_active_date => new_references.active_date,
x_sch_cert_date => new_references.sch_cert_date,
x_orig_status_flag => new_references.orig_status_flag,
x_orig_batch_id => new_references.orig_batch_id,
x_orig_batch_date => new_references.orig_batch_date,
x_orig_ack_date => new_references.orig_ack_date,
x_credit_override => new_references.credit_override,
x_credit_decision_date => new_references.credit_decision_date,
x_pnote_delivery_code => new_references.pnote_delivery_code,
x_pnote_status => new_references.pnote_status,
x_pnote_status_date => new_references.pnote_status_date,
x_pnote_id => new_references.pnote_id,
x_pnote_print_ind => new_references.pnote_print_ind,
x_pnote_accept_amt => new_references.pnote_accept_amt,
x_pnote_accept_date => new_references.pnote_accept_date,
x_p_signature_code => new_references.p_signature_code,
x_p_signature_date => new_references.p_signature_date,
x_s_signature_code => new_references.s_signature_code,
x_unsub_elig_for_heal => new_references.unsub_elig_for_heal,
x_disclosure_print_ind => new_references.disclosure_print_ind,
x_orig_fee_perct => new_references.orig_fee_perct,
x_borw_confirm_ind => new_references.borw_confirm_ind,
x_borw_interest_ind => new_references.borw_interest_ind,
x_unsub_elig_for_depnt => new_references.unsub_elig_for_depnt,
x_guarantee_amt => new_references.guarantee_amt,
x_guarantee_date => new_references.guarantee_date,
x_guarnt_adj_ind => new_references.guarnt_adj_ind,
x_guarnt_amt_redn_code => new_references.guarnt_amt_redn_code,
x_guarnt_status_code => new_references.guarnt_status_code,
x_guarnt_status_date => new_references.guarnt_status_date,
x_lend_apprv_denied_code => new_references.lend_apprv_denied_code,
x_lend_apprv_denied_date => new_references.lend_apprv_denied_date,
x_lend_status_code => new_references.lend_status_code,
x_lend_status_date => new_references.lend_status_date,
x_grade_level_code => new_references.grade_level_code,
x_enrollment_code => new_references.enrollment_code,
x_anticip_compl_date => new_references.anticip_compl_date,
x_borw_lender_id => new_references.borw_lender_id,
x_guarantor_id => new_references.guarantor_id,
x_prc_type_code => new_references.prc_type_code,
x_rec_type_ind => new_references.rec_type_ind,
x_cl_loan_type => new_references.cl_loan_type,
x_cl_seq_number => new_references.cl_seq_number,
x_last_resort_lender => new_references.last_resort_lender,
x_lender_id => new_references.lender_id,
x_lend_non_ed_brc_id => new_references.lend_non_ed_brc_id,
x_recipient_id => new_references.recipient_id,
x_recipient_type => new_references.recipient_type,
x_recip_non_ed_brc_id => new_references.recip_non_ed_brc_id,
x_cl_rec_status => new_references.cl_rec_status,
x_cl_rec_status_last_update => new_references.cl_rec_status_last_update,
x_alt_prog_type_code => new_references.alt_prog_type_code,
x_alt_appl_ver_code => new_references.alt_appl_ver_code,
x_borw_outstd_loan_code => new_references.borw_outstd_loan_code,
x_mpn_confirm_code => new_references.mpn_confirm_code,
x_resp_to_orig_code => new_references.resp_to_orig_code,
x_appl_loan_phase_code => new_references.appl_loan_phase_code,
x_appl_loan_phase_code_chg => new_references.appl_loan_phase_code_chg,
x_tot_outstd_stafford => new_references.tot_outstd_stafford,
x_tot_outstd_plus => new_references.tot_outstd_plus,
x_alt_borw_tot_debt => new_references.alt_borw_tot_debt,
x_act_interest_rate => new_references.act_interest_rate,
x_service_type_code => new_references.service_type_code,
x_rev_notice_of_guarnt => new_references.rev_notice_of_guarnt,
x_sch_refund_amt => new_references.sch_refund_amt,
x_sch_refund_date => new_references.sch_refund_date,
x_uniq_layout_vend_code => new_references.uniq_layout_vend_code,
x_uniq_layout_ident_code => new_references.uniq_layout_ident_code,
x_p_person_id => new_references.p_person_id,
x_p_ssn => new_references.p_ssn,
x_p_last_name => new_references.p_last_name,
x_p_first_name => new_references.p_first_name,
x_p_middle_name => new_references.p_middle_name,
x_p_permt_addr1 => new_references.p_permt_addr1,
x_p_permt_addr2 => new_references.p_permt_addr2,
x_p_permt_city => new_references.p_permt_city,
x_p_permt_state => new_references.p_permt_state,
x_p_permt_zip => new_references.p_permt_zip,
x_p_permt_addr_chg_date => new_references.p_permt_addr_chg_date,
x_p_permt_phone => new_references.p_permt_phone,
x_p_email_addr => new_references.p_email_addr,
x_p_date_of_birth => new_references.p_date_of_birth,
x_p_license_num => new_references.p_license_num,
x_p_license_state => new_references.p_license_state,
x_p_citizenship_status => new_references.p_citizenship_status,
x_p_alien_reg_num => new_references.p_alien_reg_num,
x_p_default_status => new_references.p_default_status,
x_p_foreign_postal_code => new_references.p_foreign_postal_code,
x_p_state_of_legal_res => new_references.p_state_of_legal_res,
x_p_legal_res_date => new_references.p_legal_res_date,
x_s_ssn => new_references.s_ssn,
x_s_last_name => new_references.s_last_name,
x_s_first_name => new_references.s_first_name,
x_s_middle_name => new_references.s_middle_name,
x_s_permt_addr1 => new_references.s_permt_addr1,
x_s_permt_addr2 => new_references.s_permt_addr2,
x_s_permt_city => new_references.s_permt_city,
x_s_permt_state => new_references.s_permt_state,
x_s_permt_zip => new_references.s_permt_zip,
x_s_permt_addr_chg_date => new_references.s_permt_addr_chg_date,
x_s_permt_phone => new_references.s_permt_phone,
x_s_local_addr1 => new_references.s_local_addr1,
x_s_local_addr2 => new_references.s_local_addr2,
x_s_local_city => new_references.s_local_city,
x_s_local_state => new_references.s_local_state,
x_s_local_zip => new_references.s_local_zip,
x_s_email_addr => new_references.s_email_addr,
x_s_date_of_birth => new_references.s_date_of_birth,
x_s_license_num => new_references.s_license_num,
x_s_license_state => new_references.s_license_state,
x_s_depncy_status => new_references.s_depncy_status,
x_s_default_status => new_references.s_default_status,
x_s_citizenship_status => new_references.s_citizenship_status,
x_s_alien_reg_num => new_references.s_alien_reg_num,
x_s_foreign_postal_code => new_references.s_foreign_postal_code,
x_pnote_batch_id => new_references.pnote_batch_id,
x_pnote_ack_date => new_references.pnote_ack_date,
x_pnote_mpn_ind => new_references.pnote_mpn_ind,
x_award_id => new_references.award_id,
x_base_id => new_references.base_id,
x_loan_key_num => new_references.loan_key_num,
x_fin_award_year => new_references.fin_award_year,
x_cps_trans_num => new_references.cps_trans_num,
x_pymt_servicer_amt => new_references.pymt_servicer_amt,
x_pymt_servicer_date => new_references.pymt_servicer_date,
x_book_loan_amt => new_references.book_loan_amt,
x_book_loan_amt_date => new_references.book_loan_amt_date,
x_s_chg_ssn => new_references.s_chg_ssn,
x_s_chg_last_name => new_references.s_chg_last_name,
x_b_chg_ssn => new_references.b_chg_ssn,
x_b_chg_last_name => new_references.b_chg_last_name,
x_note_message => new_references.note_message,
x_full_resp_code => new_references.full_resp_code,
x_s_permt_county => new_references.s_permt_county,
x_b_permt_county => new_references.b_permt_county,
x_s_permt_country => new_references.s_permt_country,
x_b_permt_country => new_references.b_permt_country,
x_crdt_decision_status => new_references.crdt_decision_status,
x_b_chg_birth_date => new_references.b_chg_birth_date,
x_s_chg_birth_date => new_references.s_chg_birth_date,
x_external_loan_id_txt => new_references.external_loan_id_txt ,
x_deferment_request_code => new_references.deferment_request_code ,
x_eft_authorization_code => new_references.eft_authorization_code ,
x_requested_loan_amt => new_references.requested_loan_amt ,
x_actual_record_type_code => new_references.actual_record_type_code ,
x_reinstatement_amt => new_references.reinstatement_amt ,
x_lender_use_txt => new_references.lender_use_txt ,
x_guarantor_use_txt => new_references.guarantor_use_txt ,
x_fls_approved_amt => new_references.fls_approved_amt ,
x_flu_approved_amt => new_references.flu_approved_amt ,
x_flp_approved_amt => new_references.flp_approved_amt ,
x_alt_approved_amt => new_references.alt_approved_amt ,
x_loan_app_form_code => new_references.loan_app_form_code ,
x_alt_borrower_ind_flag => new_references.alt_borrower_ind_flag ,
x_school_id_txt => new_references.school_id_txt ,
x_cost_of_attendance_amt => new_references.cost_of_attendance_amt ,
x_EXPECT_FAMILY_CONTRIBUTE_AMT => new_references.expect_family_contribute_amt,
x_established_fin_aid_amount => new_references.established_fin_aid_amount ,
x_BOROWER_ELECTRONIC_SIGN_FLAG => new_references.borower_electronic_sign_flag,
x_student_electronic_sign_flag => new_references.student_electronic_sign_flag,
x_BOROWER_CREDIT_AUTHORIZ_FLAG => new_references.borower_credit_authoriz_flag,
x_mpn_type_flag => new_references.mpn_type_flag,
x_school_use_txt => new_references.school_use_txt,
x_document_id_txt => new_references.document_id_txt,
x_atd_entity_id_txt => new_references.atd_entity_id_txt,
x_rep_entity_id_txt => new_references.rep_entity_id_txt,
x_source_entity_id_txt => new_references.source_entity_id_txt,
x_interest_rebate_percent_num => new_references.interest_rebate_percent_num,
x_esign_src_typ_cd => new_references.esign_src_typ_cd,
x_loansh_id => l_seq,
x_source_txt => l_source,
x_mode => 'R'
);