[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
loans.loan_number,
fabase.base_id
FROM
igf_sl_loans loans,
igf_sl_lor lor,
igf_aw_award awd,
igf_aw_fund_mast fmast,
igf_aw_fund_cat fcat,
igf_ap_fa_base_rec fabase,
igf_ap_isir_matched isr
WHERE
fabase.ci_cal_type = cp_cal_type AND
fabase.ci_sequence_number = cp_seq_number AND
fabase.base_id = awd.base_id AND
awd.fund_id = fmast.fund_id AND
fabase.base_id = isr.base_id AND
-- fabase.payment_isir_id = isr.isir_id AND
isr.payment_isir = 'Y' AND
isr.system_record_type = 'ORIGINAL' AND
fmast.fund_code = fcat.fund_code AND
(fcat.fed_fund_code = cp_fed_fund_1 OR fcat.fed_fund_code = cp_fed_fund_2) AND
loans.award_id = awd.award_id AND
loans.loan_number LIKE NVL(cp_dl_loan_number,loans.loan_number) AND
loans.loan_id = lor.loan_id AND
loans.loan_status = cp_loan_status AND
loans.active = cp_active AND
substr(loans.loan_number, 13, 6) = p_school_code;
SELECT loan.loan_id
FROM igf_sl_loans_all loan,
igf_aw_award_all awd,
igf_aw_fund_mast_all fmast,
igf_aw_fund_cat_all fcat
WHERE
loan.award_id = awd.award_id AND
awd.fund_id = fmast.fund_id AND
fcat.fund_code = fmast.fund_code AND
fmast.ci_cal_type = lv_cal_type AND
fmast.ci_sequence_number = lv_cal_seq_num AND
loan.loan_number LIKE DECODE(p_loan_number, NULL, '%', p_loan_number) AND
fcat.fed_fund_code in
(SELECT lookup_code FROM igf_lookups_view
WHERE lookup_type = decode(p_dl_loan_catg,
'DL_STAFFORD', 'IGF_SL_DL_STAFFORD',
'DL_PLUS', 'IGF_SL_DL_PLUS') AND
enabled_flag = 'Y') AND
loan.loan_status = 'V' AND -- "Valid and Ready to Send"
loan.active = 'Y';
SELECT meaning FROM igf_lookups_view
WHERE lookup_type='IGF_SL_DL_LOAN_CATG' AND lookup_code=p_dl_loan_catg AND enabled_flag = 'Y'
UNION ALL
SELECT meaning FROM igf_lookups_view
WHERE lookup_type='IGF_GE_PARAMETERS' AND lookup_code IN ('AWARD_YEAR','LOAN_CATG','LOAN_ID','PARAMETER_PASS') AND enabled_flag = 'Y';
SELECT ca.alternate_code FROM igs_ca_inst ca
WHERE ca.cal_type =lv_cal_type
AND ca.sequence_number = lv_cal_seq_num;
SELECT meaning
FROM igs_lookups_view
WHERE lookup_type = 'OR_SYSTEM_ID_TYPE'
AND lookup_code = 'DL_SCH_CD'
AND enabled_flag = 'Y';
SELECT row_id row_id FROM igf_sl_lor_loc
WHERE loan_id = lv_orig_loan_id FOR UPDATE OF igf_sl_lor_loc.sch_cert_date NOWAIT;
igf_sl_lor_loc_pkg.delete_row (tbh_rec.row_id);
SELECT row_id row_id FROM igf_sl_awd_disb_loc
WHERE award_id = lv_orig_award_id FOR UPDATE OF igf_sl_awd_disb_loc.disb_date NOWAIT;
igf_sl_awd_disb_loc_pkg.delete_row (tbh_rec.row_id);
SELECT loans.rowid row_id,
loans.loan_id,
loans.loan_number,
loans.award_id,
awd.offered_amt,
awd.accepted_amt,
loans.loan_per_begin_date,
loans.loan_per_end_date,
loans.loan_status,
loans.loan_status_date,
loans.loan_chg_status,
loans.loan_chg_status_date,
loans.active,
loans.active_date,
lor.orig_fee_perct,
lor.pnote_print_ind,
lor.s_default_status,
lor.p_default_status,
lor.p_person_id,
lor.sch_cert_date,
lor.prc_type_code,
lor.anticip_compl_date,
lor.cl_loan_type,
lor.borw_interest_ind,
lor.grade_level_code,
lor.enrollment_code,
lor.req_serial_loan_code,
lor.lend_non_ed_brc_id,
lor.pnote_delivery_code,
lor.s_signature_code,
lor.p_signature_code,
lor.borw_outstd_loan_code,
lor.cl_seq_number,
lor.rec_type_ind,
lor.p_signature_date,
lor.borr_sign_ind,
lor.stud_sign_ind,
lor.borr_credit_auth_code,
lor.origination_id,
lor.act_serial_loan_code,
lor.orig_status_flag,
lor.orig_batch_id,
lor.orig_batch_date,
lor.orig_ack_date,
lor.credit_override,
lor.credit_decision_date,
lor.pnote_status,
lor.pnote_status_date,
lor.pnote_id,
lor.pnote_accept_amt,
lor.pnote_accept_date,
lor.borw_confirm_ind,
lor.unsub_elig_for_heal,
lor.disclosure_print_ind,
lor.unsub_elig_for_depnt,
lor.guarantee_amt,
lor.guarantee_date,
lor.guarnt_adj_ind,
lor.guarnt_amt_redn_code,
lor.guarnt_status_code,
lor.guarnt_status_date,
lor.lend_status_code,
lor.lend_status_date,
lor.last_resort_lender,
lor.alt_prog_type_code,
lor.alt_appl_ver_code,
lor.resp_to_orig_code,
lor.tot_outstd_stafford,
lor.tot_outstd_plus,
lor.alt_borw_tot_debt,
lor.act_interest_rate,
lor.service_type_code,
lor.rev_notice_of_guarnt,
lor.sch_refund_amt,
lor.sch_refund_date,
lor.uniq_layout_vend_code,
lor.uniq_layout_ident_code,
lor.pnote_batch_id,
lor.pnote_ack_date,
lor.pnote_mpn_ind,
fabase.person_id student_id,
fabase.base_id,
fmast.fund_code loan_type,
lor.interest_rebate_percent_num,
lor.cps_trans_num,
lor.atd_entity_id_txt,
lor.rep_entity_id_txt,
lor.crdt_decision_status,
lor.note_message,
lor.book_loan_amt,
lor.book_loan_amt_date,
lor.pymt_servicer_amt,
lor.pymt_servicer_date,
lor.external_loan_id_txt,
lor.deferment_request_code,
lor.eft_authorization_code,
lor.requested_loan_amt,
lor.actual_record_type_code,
lor.reinstatement_amt,
lor.school_use_txt,
lor.lender_use_txt,
lor.guarantor_use_txt,
lor.fls_approved_amt,
lor.flu_approved_amt,
lor.flp_approved_amt,
lor.alt_approved_amt,
lor.loan_app_form_code,
lor.override_grade_level_code,
lor.b_alien_reg_num_txt,
lor.esign_src_typ_cd,
lor.acad_begin_date,
lor.acad_end_date
FROM igf_sl_loans_all loans,
igf_sl_lor_all lor,
igf_aw_award_all awd,
igf_ap_fa_base_rec_all fabase,
igf_aw_fund_mast_all fmast
WHERE loans.loan_id = lv_orig_loan_id
AND loans.loan_id = lor.loan_id
AND loans.award_id = awd.award_id
AND awd.base_id = fabase.base_id
AND fmast.fund_id = awd.fund_id;
SELECT isr.dependency_status dependency_status
FROM IGF_AP_FA_BASE_REC fabase,
IGF_AP_ISIR_MATCHED isr
WHERE
fabase.base_id = isr.base_id
AND isr.payment_isir = 'Y'
AND isr.system_record_type = 'ORIGINAL'
AND fabase.base_id = lv_base_id;
CURSOR cur_get_s_phone IS select
DECODE(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(lv_base_id)),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(lv_base_id)),10,0))
FROM DUAL;
SELECT DECODE(igf_sl_gen.get_person_phone(p_per_id),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(p_per_id),10,0))
FROM DUAL;
igf_sl_lor_loc_pkg.insert_row (
X_Mode => 'R',
x_rowid => lv_row_id,
x_loan_id => tbh_rec.loan_id,
x_origination_id => tbh_rec.origination_id,
x_loan_number => tbh_rec.loan_number,
x_loan_type => tbh_rec.loan_type,
x_loan_amt_offered => tbh_rec.offered_amt ,
x_loan_amt_accepted => tbh_rec.accepted_amt ,
x_loan_per_begin_date => tbh_rec.loan_per_begin_date,
x_loan_per_end_date => tbh_rec.loan_per_end_date,
x_acad_yr_begin_date => lv_acad_begin_dt,
x_acad_yr_end_date => lv_acad_end_dt,
x_loan_status => tbh_rec.loan_status,
x_loan_status_date => tbh_rec.loan_status_date,
x_loan_chg_status => tbh_rec.loan_chg_status,
x_loan_chg_status_date => tbh_rec.loan_chg_status_date,
x_req_serial_loan_code => tbh_rec.req_serial_loan_code,
x_act_serial_loan_code => tbh_rec.act_serial_loan_code,
x_active => tbh_rec.active,
x_active_date => tbh_rec.active_date,
x_sch_cert_date => tbh_rec.sch_cert_date,
x_orig_status_flag => tbh_rec.orig_status_flag,
x_orig_batch_id => tbh_rec.orig_batch_id,
x_orig_batch_date => tbh_rec.orig_batch_date,
x_chg_batch_id => NULL,
x_orig_ack_date => tbh_rec.orig_ack_date,
x_credit_override => tbh_rec.credit_override,
x_credit_decision_date => tbh_rec.credit_decision_date,
x_pnote_delivery_code => tbh_rec.pnote_delivery_code,
x_pnote_status => tbh_rec.pnote_status,
x_pnote_status_date => tbh_rec.pnote_status_date,
x_pnote_id => tbh_rec.pnote_id,
x_pnote_print_ind => tbh_rec.pnote_print_ind,
x_pnote_accept_amt => tbh_rec.pnote_accept_amt,
x_pnote_accept_date => tbh_rec.pnote_accept_date,
x_p_signature_code => tbh_rec.p_signature_code,
x_p_signature_date => tbh_rec.p_signature_date,
x_s_signature_code => tbh_rec.s_signature_code,
x_unsub_elig_for_heal => tbh_rec.unsub_elig_for_heal,
x_disclosure_print_ind => tbh_rec.disclosure_print_ind,
x_orig_fee_perct => tbh_rec.orig_fee_perct,
x_borw_confirm_ind => tbh_rec.borw_confirm_ind,
x_borw_interest_ind => tbh_rec.borw_interest_ind,
x_unsub_elig_for_depnt => tbh_rec.unsub_elig_for_depnt,
x_guarantee_amt => tbh_rec.guarantee_amt,
x_guarantee_date => tbh_rec.guarantee_date,
x_guarnt_adj_ind => tbh_rec.guarnt_adj_ind,
x_guarnt_amt_redn_code => tbh_rec.guarnt_amt_redn_code,
x_guarnt_status_code => tbh_rec.guarnt_status_code,
x_guarnt_status_date => tbh_rec.guarnt_status_date,
x_lend_apprv_denied_code => NULL,
x_lend_apprv_denied_date => NULL,
x_lend_status_code => tbh_rec.lend_status_code,
x_lend_status_date => tbh_rec.lend_status_date,
x_grade_level_code => tbh_rec.grade_level_code,
x_enrollment_code => tbh_rec.enrollment_code,
x_anticip_compl_date => tbh_rec.anticip_compl_date,
x_borw_lender_id => NULL,
x_duns_borw_lender_id => NULL,
x_guarantor_id => NULL,
x_duns_guarnt_id => NULL,
x_prc_type_code => tbh_rec.prc_type_code,
x_rec_type_ind => tbh_rec.rec_type_ind,
x_cl_loan_type => tbh_rec.cl_loan_type,
x_cl_seq_number => tbh_rec.cl_seq_number,
x_last_resort_lender => tbh_rec.last_resort_lender,
x_lender_id => NULL,
x_duns_lender_id => NULL,
x_lend_non_ed_brc_id => NULL,
x_recipient_id => NULL,
x_recipient_type => NULL,
x_duns_recip_id => NULL,
x_recip_non_ed_brc_id => NULL,
x_cl_rec_status => NULL,
x_cl_rec_status_last_update => NULL,
x_alt_prog_type_code => tbh_rec.alt_prog_type_code,
x_alt_appl_ver_code => tbh_rec.alt_appl_ver_code,
x_borw_outstd_loan_code => tbh_rec.borw_outstd_loan_code,
x_mpn_confirm_code => NULL,
x_resp_to_orig_code => tbh_rec.resp_to_orig_code,
x_appl_loan_phase_code => NULL,
x_appl_loan_phase_code_chg => NULL,
x_tot_outstd_stafford => tbh_rec.tot_outstd_stafford,
x_tot_outstd_plus => tbh_rec.tot_outstd_plus,
x_alt_borw_tot_debt => tbh_rec.alt_borw_tot_debt,
x_act_interest_rate => tbh_rec.act_interest_rate,
x_service_type_code => tbh_rec.service_type_code,
x_rev_notice_of_guarnt => tbh_rec.rev_notice_of_guarnt,
x_sch_refund_amt => tbh_rec.sch_refund_amt,
x_sch_refund_date => tbh_rec.sch_refund_date,
x_uniq_layout_vend_code => tbh_rec.uniq_layout_vend_code,
x_uniq_layout_ident_code => tbh_rec.uniq_layout_ident_code,
x_p_person_id => tbh_rec.p_person_id,
x_p_ssn => parent_dtl_rec.p_ssn,
x_p_ssn_chg_date => NULL,
x_p_last_name => parent_dtl_rec.p_last_name,
x_p_first_name => parent_dtl_rec.p_first_name,
x_p_middle_name => parent_dtl_rec.p_middle_name,
x_p_permt_addr1 => parent_dtl_rec.p_permt_addr1,
x_p_permt_addr2 => parent_dtl_rec.p_permt_addr2,
x_p_permt_city => parent_dtl_rec.p_permt_city,
x_p_permt_state => parent_dtl_rec.p_permt_state,
x_p_permt_zip => parent_dtl_rec.p_permt_zip,
x_p_permt_addr_chg_date => NULL,
x_p_permt_phone => l_p_phone,
x_p_email_addr => parent_dtl_rec.p_email_addr,
x_p_date_of_birth => parent_dtl_rec.p_date_of_birth,
x_p_dob_chg_date => NULL,
x_p_license_num => parent_dtl_rec.p_license_num,
x_p_license_state => parent_dtl_rec.p_license_state,
x_p_citizenship_status => parent_dtl_rec.p_citizenship_status,
x_p_alien_reg_num => parent_dtl_rec.p_alien_reg_num,
x_p_default_status => tbh_rec.p_default_status,
x_p_foreign_postal_code => NULL,
x_p_state_of_legal_res => parent_dtl_rec.p_state_of_legal_res,
x_p_legal_res_date => parent_dtl_rec.p_legal_res_date,
x_s_ssn => student_dtl_rec.p_ssn,
x_s_ssn_chg_date => NULL,
x_s_last_name => student_dtl_rec.p_last_name,
x_s_first_name => student_dtl_rec.p_first_name,
x_s_middle_name => student_dtl_rec.p_middle_name,
x_s_permt_addr1 => student_dtl_rec.p_permt_addr1,
x_s_permt_addr2 => student_dtl_rec.p_permt_addr2,
x_s_permt_city => student_dtl_rec.p_permt_city,
x_s_permt_state => student_dtl_rec.p_permt_state,
x_s_permt_zip => student_dtl_rec.p_permt_zip,
x_s_permt_addr_chg_date => NULL,
x_s_permt_phone => l_s_phone,
x_s_local_addr1 => student_dtl_rec.p_local_addr1,
x_s_local_addr2 => student_dtl_rec.p_local_addr2,
x_s_local_city => student_dtl_rec.p_local_city,
x_s_local_state => student_dtl_rec.p_local_state,
x_s_local_zip => student_dtl_rec.p_local_zip,
x_s_local_addr_chg_date => NULL,
x_s_email_addr => student_dtl_rec.p_email_addr,
x_s_date_of_birth => student_dtl_rec.p_date_of_birth,
x_s_dob_chg_date => NULL,
x_s_license_num => student_dtl_rec.p_license_num,
x_s_license_state => student_dtl_rec.p_license_state,
x_s_depncy_status => c_fabase_rec.dependency_status,
x_s_default_status => tbh_rec.s_default_status,
x_s_citizenship_status => student_dtl_rec.p_citizenship_status,
x_s_alien_reg_num => student_dtl_rec.p_alien_reg_num,
x_s_foreign_postal_code => NULL,
x_pnote_batch_id => tbh_rec.pnote_batch_id,
x_pnote_ack_date => tbh_rec.pnote_ack_date,
x_pnote_mpn_ind => tbh_rec.pnote_mpn_ind,
--Added fields
x_award_id => tbh_rec.award_id,
x_base_id => tbh_rec.base_id,
x_document_id_txt => NULL,
x_loan_key_num => NULL,
x_interest_rebate_percent_num => tbh_rec.interest_rebate_percent_num,
x_fin_award_year => NULL,
x_cps_trans_num => tbh_rec.cps_trans_num,
x_atd_entity_id_txt => tbh_rec.atd_entity_id_txt,
x_rep_entity_id_txt => tbh_rec.rep_entity_id_txt,
x_source_entity_id_txt => NULL,
x_pymt_servicer_amt => tbh_rec.pymt_servicer_amt,
x_pymt_servicer_date => tbh_rec.pymt_servicer_date,
x_book_loan_amt => tbh_rec.book_loan_amt,
x_book_loan_amt_date => tbh_rec.book_loan_amt_date,
x_s_chg_birth_date => NULL,
x_s_chg_ssn => NULL,
x_s_chg_last_name => NULL,
x_b_chg_birth_date => NULL,
x_b_chg_ssn => NULL,
x_b_chg_last_name => NULL,
x_note_message => tbh_rec.note_message,
x_full_resp_code => NULL,
x_s_permt_county => NULL,
x_b_permt_county => NULL,
x_s_permt_country => NULL,
x_b_permt_country => NULL,
x_crdt_decision_status => tbh_rec.crdt_decision_status,
x_external_loan_id_txt => tbh_rec.external_loan_id_txt,
x_deferment_request_code => tbh_rec.deferment_request_code,
x_eft_authorization_code => tbh_rec.eft_authorization_code,
x_requested_loan_amt => tbh_rec.requested_loan_amt,
x_actual_record_type_code => tbh_rec.actual_record_type_code,
x_reinstatement_amt => tbh_rec.reinstatement_amt,
x_lender_use_txt => tbh_rec.lender_use_txt,
x_guarantor_use_txt => tbh_rec.guarantor_use_txt,
x_fls_approved_amt => tbh_rec.fls_approved_amt,
x_flu_approved_amt => tbh_rec.flu_approved_amt,
x_flp_approved_amt => tbh_rec.flp_approved_amt,
x_alt_approved_amt => tbh_rec.alt_approved_amt,
x_loan_app_form_code => tbh_rec.loan_app_form_code,
x_alt_borrower_ind_flag => NULL,
x_school_id_txt => NULL,
x_cost_of_attendance_amt => NULL,
x_established_fin_aid_amount => NULL,
x_student_electronic_sign_flag => NULL,
x_mpn_type_flag => NULL,
x_school_use_txt => tbh_rec.school_use_txt,
x_expect_family_contribute_amt => NULL,
x_borower_electronic_sign_flag => NULL,
x_borower_credit_authoriz_flag => NULL,
x_esign_src_typ_cd => NULL
);
SELECT * FROM igf_aw_awd_disb
WHERE award_id = lv_orig_award_id;
igf_sl_awd_disb_loc_pkg.insert_row (
X_Mode => 'R',
x_rowid => lv_row_id,
x_award_id => tbh_rec.award_id,
x_disb_num => tbh_rec.disb_num,
x_disb_gross_amt => tbh_rec.disb_accepted_amt,
x_fee_1 => tbh_rec.fee_1,
x_fee_2 => tbh_rec.fee_2,
x_disb_net_amt => tbh_rec.disb_net_amt,
x_disb_date => tbh_rec.disb_date,
x_hold_rel_ind => tbh_rec.hold_rel_ind,
x_fee_paid_1 => tbh_rec.fee_paid_1,
x_fee_paid_2 => tbh_rec.fee_paid_2
);
SELECT igf_sl_loans.* FROM igf_sl_loans
WHERE loan_id = lv_orig_loan_id FOR UPDATE OF igf_sl_loans.loan_status NOWAIT;
igf_sl_loans_pkg.update_row (
X_Mode => 'R',
x_rowid => tbh_rec.row_id,
x_loan_id => tbh_rec.loan_id,
x_award_id => tbh_rec.award_id,
x_seq_num => tbh_rec.seq_num,
x_loan_number => tbh_rec.loan_number,
x_loan_per_begin_date => tbh_rec.loan_per_begin_date,
x_loan_per_end_date => tbh_rec.loan_per_end_date,
x_loan_status => 'S',
x_loan_status_date => TRUNC(SYSDATE),
x_loan_chg_status => tbh_rec.loan_chg_status,
x_loan_chg_status_date => tbh_rec.loan_chg_status_date,
x_active => tbh_rec.active,
x_active_date => tbh_rec.active_date,
x_borw_detrm_code => tbh_rec.borw_detrm_code,
x_legacy_record_flag => NULL,
x_external_loan_id_txt => tbh_rec.external_loan_id_txt
);
SELECT igf_sl_lor.* FROM igf_sl_lor
WHERE loan_id = lv_orig_loan_id FOR UPDATE OF igf_sl_lor.sch_cert_date NOWAIT;
igf_sl_lor_pkg.update_row (
X_Mode => 'R',
x_rowid => tbh_rec.row_id,
x_origination_id => tbh_rec.origination_id,
x_loan_id => tbh_rec.loan_id,
x_sch_cert_date => tbh_rec.sch_cert_date,
x_orig_status_flag => tbh_rec.orig_status_flag,
x_orig_batch_id => lv_batch_id,
x_orig_batch_date => TRUNC(SYSDATE),
x_chg_batch_id => NULL,
x_orig_ack_date => tbh_rec.orig_ack_date,
x_credit_override => tbh_rec.credit_override,
x_credit_decision_date => tbh_rec.credit_decision_date,
x_req_serial_loan_code => tbh_rec.req_serial_loan_code,
x_act_serial_loan_code => tbh_rec.act_serial_loan_code,
x_pnote_delivery_code => tbh_rec.pnote_delivery_code,
x_pnote_status => tbh_rec.pnote_status,
x_pnote_status_date => tbh_rec.pnote_status_date,
x_pnote_id => tbh_rec.pnote_id,
x_pnote_print_ind => tbh_rec.pnote_print_ind,
x_pnote_accept_amt => tbh_rec.pnote_accept_amt,
x_pnote_accept_date => tbh_rec.pnote_accept_date,
x_unsub_elig_for_heal => tbh_rec.unsub_elig_for_heal,
x_disclosure_print_ind => tbh_rec.disclosure_print_ind,
x_orig_fee_perct => tbh_rec.orig_fee_perct,
x_borw_confirm_ind => tbh_rec.borw_confirm_ind,
x_borw_interest_ind => tbh_rec.borw_interest_ind,
x_borw_outstd_loan_code => tbh_rec.borw_outstd_loan_code,
x_unsub_elig_for_depnt => tbh_rec.unsub_elig_for_depnt,
x_guarantee_amt => tbh_rec.guarantee_amt,
x_guarantee_date => tbh_rec.guarantee_date,
x_guarnt_amt_redn_code => tbh_rec.guarnt_amt_redn_code,
x_guarnt_status_code => tbh_rec.guarnt_status_code,
x_guarnt_status_date => tbh_rec.guarnt_status_date,
x_lend_apprv_denied_code => NULL,
x_lend_apprv_denied_date => NULL,
x_lend_status_code => tbh_rec.lend_status_code,
x_lend_status_date => tbh_rec.lend_status_date,
x_guarnt_adj_ind => tbh_rec.guarnt_adj_ind,
x_grade_level_code => tbh_rec.grade_level_code,
x_enrollment_code => tbh_rec.enrollment_code,
x_anticip_compl_date => tbh_rec.anticip_compl_date,
x_borw_lender_id => NULL,
x_duns_borw_lender_id => NULL,
x_guarantor_id => NULL,
x_duns_guarnt_id => NULL,
x_prc_type_code => tbh_rec.prc_type_code,
x_cl_seq_number => tbh_rec.cl_seq_number,
x_last_resort_lender => tbh_rec.last_resort_lender,
x_lender_id => NULL,
x_duns_lender_id => NULL,
x_lend_non_ed_brc_id => NULL,
x_recipient_id => NULL,
x_recipient_type => NULL,
x_duns_recip_id => NULL,
x_recip_non_ed_brc_id => NULL,
x_rec_type_ind => tbh_rec.rec_type_ind,
x_cl_loan_type => tbh_rec.cl_loan_type,
x_cl_rec_status => NULL,
x_cl_rec_status_last_update => NULL,
x_alt_prog_type_code => tbh_rec.alt_prog_type_code,
x_alt_appl_ver_code => tbh_rec.alt_appl_ver_code,
x_mpn_confirm_code => NULL,
x_resp_to_orig_code => tbh_rec.resp_to_orig_code,
x_appl_loan_phase_code => NULL,
x_appl_loan_phase_code_chg => NULL,
x_appl_send_error_codes => NULL,
x_tot_outstd_stafford => tbh_rec.tot_outstd_stafford,
x_tot_outstd_plus => tbh_rec.tot_outstd_plus,
x_alt_borw_tot_debt => tbh_rec.alt_borw_tot_debt,
x_act_interest_rate => tbh_rec.act_interest_rate,
x_service_type_code => tbh_rec.service_type_code,
x_rev_notice_of_guarnt => tbh_rec.rev_notice_of_guarnt,
x_sch_refund_amt => tbh_rec.sch_refund_amt,
x_sch_refund_date => tbh_rec.sch_refund_date,
x_uniq_layout_vend_code => tbh_rec.uniq_layout_vend_code,
x_uniq_layout_ident_code => tbh_rec.uniq_layout_ident_code,
x_p_person_id => tbh_rec.p_person_id,
x_p_ssn_chg_date => NULL,
x_p_dob_chg_date => NULL,
x_p_permt_addr_chg_date => NULL,
x_p_default_status => tbh_rec.p_default_status,
x_p_signature_code => tbh_rec.p_signature_code,
x_p_signature_date => tbh_rec.p_signature_date,
x_s_ssn_chg_date => NULL,
x_s_dob_chg_date => NULL,
x_s_permt_addr_chg_date => NULL,
x_s_local_addr_chg_date => NULL,
x_s_default_status => tbh_rec.s_default_status,
x_s_signature_code => tbh_rec.s_signature_code,
x_pnote_batch_id => tbh_rec.pnote_batch_id,
x_pnote_ack_date => tbh_rec.pnote_ack_date,
x_pnote_mpn_ind => tbh_rec.pnote_mpn_ind ,
x_elec_mpn_ind => tbh_rec.elec_mpn_ind ,
x_borr_sign_ind => tbh_rec.borr_sign_ind ,
x_stud_sign_ind => tbh_rec.stud_sign_ind ,
x_borr_credit_auth_code => tbh_rec.borr_credit_auth_code ,
x_relationship_cd => tbh_rec.relationship_cd,
x_interest_rebate_percent_num => tbh_rec.interest_rebate_percent_num,
x_cps_trans_num => tbh_rec.cps_trans_num,
x_atd_entity_id_txt => tbh_rec.atd_entity_id_txt ,
x_rep_entity_id_txt => tbh_rec.rep_entity_id_txt,
x_crdt_decision_status => tbh_rec.crdt_decision_status,
x_note_message => tbh_rec.note_message,
x_book_loan_amt => tbh_rec.book_loan_amt ,
x_book_loan_amt_date => tbh_rec.book_loan_amt_date,
x_pymt_servicer_amt => tbh_rec.pymt_servicer_amt,
x_pymt_servicer_date => tbh_rec.pymt_servicer_date,
x_requested_loan_amt => tbh_rec.requested_loan_amt,
x_eft_authorization_code => tbh_rec.eft_authorization_code,
x_external_loan_id_txt => tbh_rec.external_loan_id_txt,
x_deferment_request_code => tbh_rec.deferment_request_code ,
x_actual_record_type_code => tbh_rec.actual_record_type_code,
x_reinstatement_amt => tbh_rec.reinstatement_amt,
x_school_use_txt => tbh_rec.school_use_txt,
x_lender_use_txt => tbh_rec.lender_use_txt,
x_guarantor_use_txt => tbh_rec.guarantor_use_txt,
x_fls_approved_amt => tbh_rec.fls_approved_amt,
x_flu_approved_amt => tbh_rec.flu_approved_amt,
x_flp_approved_amt => tbh_rec.flp_approved_amt,
x_alt_approved_amt => tbh_rec.alt_approved_amt,
x_loan_app_form_code => tbh_rec.loan_app_form_code,
x_override_grade_level_code => tbh_rec.override_grade_level_code,
x_b_alien_reg_num_txt => tbh_rec.b_alien_reg_num_txt,
x_esign_src_typ_cd => tbh_rec.esign_src_typ_cd,
x_acad_begin_date => tbh_rec.acad_begin_date,
x_acad_end_date => tbh_rec.acad_end_date
);