[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT LTRIM(RTRIM(SUBSTR(record_data, 3, 12))) batch_id,
TO_DATE(TRIM(SUBSTR(record_data, 15, 8)), 'YYYYMMDDHH24MISS') file_creation_dt,
TO_DATE(TRIM(SUBSTR(record_data, 23, 6)), 'HH24MISS') file_creation_time,
TO_DATE(TRIM(SUBSTR(record_data, 29, 8)), 'YYYYMMDDHH24MISS') file_trans_dt,
LTRIM(RTRIM(SUBSTR(record_data, 43, 19))) file_ident_name,
LTRIM(RTRIM(SUBSTR(record_data, 62, 5))) file_ident_code,
LTRIM(RTRIM(SUBSTR(record_data, 67, 32))) source_name,
LTRIM(RTRIM(SUBSTR(record_data, 99, 8))) source_id,
LTRIM(RTRIM(SUBSTR(record_data, 109, 4))) source_non_ed_brc_id,
LTRIM(RTRIM(SUBSTR(record_data, 114, 32))) recipient_name,
LTRIM(RTRIM(SUBSTR(record_data, 146, 8))) recipient_id,
LTRIM(RTRIM(SUBSTR(record_data, 156, 4))) recip_non_ed_brc_id
FROM igf_sl_load_file_t
WHERE lort_id = 1 AND record_data LIKE '@H%' AND file_type =
'CL_ROSTER';
SELECT lort_id last_lort_id,
TO_NUMBER(TRIM(SUBSTR(record_data, 3, 6))) rec_count,
TO_NUMBER(TRIM(SUBSTR(record_data, 9, 14)))/100 tot_net_disb_amt,
TO_NUMBER(TRIM(SUBSTR(record_data, 23, 14)))/100 tot_net_eft_amt,
TO_NUMBER(TRIM(SUBSTR(record_data, 37, 14)))/100 tot_net_non_eft_amt,
TO_NUMBER(TRIM(SUBSTR(record_data, 51, 14)))/100 tot_reissue_amt,
TO_NUMBER(TRIM(SUBSTR(record_data, 105, 14)))/100 tot_cancel_amt,
TO_NUMBER(TRIM(SUBSTR(record_data, 119, 14)))/100 tot_deficit_amt,
TO_NUMBER(TRIM(SUBSTR(record_data, 142, 14)))/100 tot_net_cancel_amt,
TO_NUMBER(TRIM(SUBSTR(record_data, 156, 14)))/100 tot_net_out_cancel_amt
FROM igf_sl_load_file_t
WHERE lort_id = (SELECT MAX(lort_id)
FROM igf_sl_load_file_t)
AND record_data LIKE '@T%' AND file_type = 'CL_ROSTER';
SELECT meaning, lookup_code
FROM igf_lookups_view
WHERE lookup_type = 'IGF_SL_CL_ROSTER_LOGS';
SELECT meaning, lookup_code
FROM igf_lookups_view
WHERE lookup_type = 'IGF_SL_CL_ROSTER_LOGS';
SELECT record_data
FROM igf_sl_load_file_t
WHERE lort_id BETWEEN 2 AND (l_last_lort_id - 1)
AND file_type = 'CL_ROSTER';
SELECT meaning, lookup_code
FROM igf_lookups_view
WHERE lookup_type = 'IGF_SL_CL_ROSTER_LOGS';
SELECT lor.ROWID row_id, lor.*
FROM IGF_SL_LOR_ALL lor,
IGF_SL_LOANS_ALL loans
WHERE loans.loan_id = lor.loan_id
AND loans.loan_number = cp_loan_number;
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','before inserting batch record');
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','before inserting batch record for Release-5');
igf_sl_cl_batch_pkg.insert_row(
x_rowid => l_rowid,
x_cbth_id => l_cbth_id,
x_batch_id => l_batch_id,
x_file_creation_date => l_file_creation_dt,
x_file_trans_date => l_file_trans_dt,
x_file_ident_code => l_file_ident_code,
x_recipient_id => l_recipient_id,
x_recip_non_ed_brc_id => l_recip_non_ed_brc_id,
x_source_id => l_source_id,
x_source_non_ed_brc_id => l_source_non_ed_brc_id,
x_send_resp => 'D',
x_mode => 'R',
x_record_count_num => l_number_rec ,
x_total_net_disb_amt => l_tot_net_disb_amt ,
x_total_net_eft_amt => l_tot_net_eft_amt ,
x_total_net_non_eft_amt => l_tot_net_non_eft_amt ,
x_total_reissue_amt => l_tot_reissue_amt ,
x_total_cancel_amt => l_tot_cancel_amt ,
x_total_deficit_amt => l_tot_deficit_amt ,
x_total_net_cancel_amt => l_tot_net_cancel_amt ,
x_total_net_out_cancel_amt => l_tot_net_out_cancel_amt
);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','After inserting batch record for Release-5');
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','before inserting batch record for Release-4');
igf_sl_cl_batch_pkg.insert_row(
x_rowid => l_rowid,
x_cbth_id => l_cbth_id,
x_batch_id => l_batch_id,
x_file_creation_date => l_file_creation_dt,
x_file_trans_date => l_file_trans_dt,
x_file_ident_code => l_file_ident_code,
x_recipient_id => l_recipient_id,
x_recip_non_ed_brc_id => l_recip_non_ed_brc_id,
x_source_id => l_source_id,
x_source_non_ed_brc_id => l_source_non_ed_brc_id,
x_send_resp => 'D',
x_mode => 'R',
x_record_count_num => l_number_rec ,
x_total_net_disb_amt => l_tot_net_disb_amt ,
x_total_net_eft_amt => l_tot_net_eft_amt ,
x_total_net_non_eft_amt => l_tot_net_non_eft_amt ,
x_total_reissue_amt => l_tot_reissue_amt ,
x_total_cancel_amt => l_tot_cancel_amt ,
x_total_deficit_amt => l_tot_deficit_amt ,
x_total_net_cancel_amt => l_tot_net_cancel_amt ,
x_total_net_out_cancel_amt => l_tot_net_out_cancel_amt
);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','after inserting batch record for Release-4');
igf_db_cl_disb_resp_pkg.insert_row (x_mode => 'R',
x_rowid => l_rowid,
x_cdbr_id => l_cdbr_id,
x_cbth_id => l_cbth_id,
x_record_type => l_record_type ,
x_loan_number => l_loan_number,
x_cl_seq_number => l_cl_seq_number,
x_b_last_name => LTRIM(RTRIM(SUBSTR(db_rec.record_data,23,35))),
x_b_first_name => LTRIM(RTRIM(SUBSTR(db_rec.record_data,58,12))),
x_b_middle_name => LTRIM(RTRIM(SUBSTR(db_rec.record_data,70,1))),
x_b_ssn => LTRIM(RTRIM(SUBSTR(db_rec.record_data,71,9))),
x_b_addr_line_1 => LTRIM(RTRIM(SUBSTR(db_rec.record_data,80,30))),
x_b_addr_line_2 => LTRIM(RTRIM(SUBSTR(db_rec.record_data,110,30))),
x_b_city => LTRIM(RTRIM(SUBSTR(db_rec.record_data,140,24))),
x_b_state => LTRIM(RTRIM(SUBSTR(db_rec.record_data,170,2))),
x_b_zip => LTRIM(RTRIM(SUBSTR(db_rec.record_data,172,5))),
x_b_zip_suffix => LTRIM(RTRIM(SUBSTR(db_rec.record_data,177,4))),
x_b_addr_chg_date => fnd_date.string_to_date(SUBSTR(db_rec.record_data,181,8),'YYYYMMDD'),
x_eft_auth_code => LTRIM(RTRIM(SUBSTR(db_rec.record_data,189,1))),
x_s_last_name => LTRIM(RTRIM(SUBSTR(db_rec.record_data,190,35))),
x_s_first_name => LTRIM(RTRIM(SUBSTR(db_rec.record_data,225,12))),
x_s_middle_initial => LTRIM(RTRIM(SUBSTR(db_rec.record_data,237,1))),
x_s_ssn => LTRIM(RTRIM(SUBSTR(db_rec.record_data,238,9))),
x_school_id => TO_NUMBER(TRIM(SUBSTR(db_rec.record_data,247,8))),
x_school_use => LTRIM(RTRIM(SUBSTR(db_rec.record_data,257,23))),
x_loan_per_start_date => l_loan_per_start_date,
x_loan_per_end_date => l_loan_per_end_date,
x_cl_loan_type => LTRIM(RTRIM(SUBSTR(db_rec.record_data,296,2))),
x_alt_prog_type_code => LTRIM(RTRIM(SUBSTR(db_rec.record_data,298,3))),
x_lender_id => l_lender_id,
x_lend_non_ed_brc_id => l_lend_non_ed_brc_id ,
x_lender_use => LTRIM(RTRIM(SUBSTR(db_rec.record_data,311,20))),
x_borw_confirm_ind => LTRIM(RTRIM(SUBSTR(db_rec.record_data,331,1))),
x_tot_sched_disb => l_tot_sched_disb,
x_fund_release_date => l_fund_release_date,
x_disb_num => l_disb_num,
x_guarantor_id => l_guarantor_id,
x_guarantor_use => LTRIM(RTRIM(SUBSTR(db_rec.record_data,347,23))),
x_guarantee_date => l_guarantee_date,
x_guarantee_amt => l_guarantee_amt,
x_gross_disb_amt => l_gross_disb_amt,
x_fee_1 => l_fee_1,
x_fee_2 => l_fee_2,
x_net_disb_amt => l_net_disb_amt ,
x_fund_dist_mthd => l_fund_dist_mthd,
x_check_number => l_check_number,
x_late_disb_ind => l_late_disb_ind,
x_prev_reported_ind => l_prev_reported_ind,
x_err_code1 => LTRIM(RTRIM(SUBSTR(db_rec.record_data,429,3))),
x_err_code2 => LTRIM(RTRIM(SUBSTR(db_rec.record_data,432,3))),
x_err_code3 => LTRIM(RTRIM(SUBSTR(db_rec.record_data,435,3))),
x_err_code4 => LTRIM(RTRIM(SUBSTR(db_rec.record_data,438,3))),
x_err_code5 => LTRIM(RTRIM(SUBSTR(db_rec.record_data,441,3))),
x_fee_paid_2 => l_fee_paid_2,
x_lender_name => LTRIM(RTRIM(SUBSTR(db_rec.record_data,451,15))),
x_net_cancel_amt => l_net_cancel_amt,
x_duns_lender_id => NULL,
x_duns_guarnt_id => NULL,
x_hold_rel_ind => l_hold_rel_ind,
x_pnote_code => l_pnote_code,
x_pnote_status_date => l_pnote_status_date,
x_fee_paid_1 => l_fee_paid_1,
x_netted_cancel_amt => l_netted_cancel_amt,
x_outstd_cancel_amt => l_outstd_cancel_amt,
x_sch_non_ed_brc_id => l_sch_non_ed_brc_id,
x_status => 'N',
x_esign_src_typ_cd => LTRIM(RTRIM(SUBSTR(db_rec.record_data,473,9))),
x_direct_to_borr_flag => l_direct_to_borr_ind);
igf_sl_lor_pkg.update_row (
X_Mode => 'R',
x_rowid => rec_lor_data.row_id,
x_origination_id => rec_lor_data.origination_id,
x_loan_id => rec_lor_data.loan_id,
x_sch_cert_date => rec_lor_data.sch_cert_date,
x_orig_status_flag => rec_lor_data.orig_status_flag,
x_orig_batch_id => rec_lor_data.orig_batch_id,
x_orig_batch_date => rec_lor_data.orig_batch_date,
x_chg_batch_id => rec_lor_data.chg_batch_id,
x_orig_ack_date => rec_lor_data.orig_ack_date,
x_credit_override => rec_lor_data.credit_override,
x_credit_decision_date => rec_lor_data.credit_decision_date,
x_req_serial_loan_code => rec_lor_data.req_serial_loan_code,
x_act_serial_loan_code => rec_lor_data.act_serial_loan_code,
x_pnote_delivery_code => rec_lor_data.pnote_delivery_code,
x_pnote_status => rec_lor_data.pnote_status,
x_pnote_status_date => rec_lor_data.pnote_status_date,
x_pnote_id => rec_lor_data.pnote_id,
x_pnote_print_ind => rec_lor_data.pnote_print_ind,
x_pnote_accept_amt => rec_lor_data.pnote_accept_amt,
x_pnote_accept_date => rec_lor_data.pnote_accept_date,
x_unsub_elig_for_heal => rec_lor_data.unsub_elig_for_heal,
x_disclosure_print_ind => rec_lor_data.disclosure_print_ind,
x_orig_fee_perct => rec_lor_data.orig_fee_perct,
x_borw_confirm_ind => rec_lor_data.borw_confirm_ind,
x_borw_interest_ind => rec_lor_data.borw_interest_ind,
x_borw_outstd_loan_code => rec_lor_data.borw_outstd_loan_code,
x_unsub_elig_for_depnt => rec_lor_data.unsub_elig_for_depnt,
x_guarantee_amt => rec_lor_data.guarantee_amt,
x_guarantee_date => rec_lor_data.guarantee_date,
x_guarnt_amt_redn_code => rec_lor_data.guarnt_amt_redn_code,
x_guarnt_status_code => rec_lor_data.guarnt_status_code,
x_guarnt_status_date => rec_lor_data.guarnt_status_date,
x_lend_apprv_denied_code => rec_lor_data.lend_apprv_denied_code, --NULL,
x_lend_apprv_denied_date => rec_lor_data.lend_apprv_denied_date, --NULL,
x_lend_status_code => rec_lor_data.lend_status_code,
x_lend_status_date => rec_lor_data.lend_status_date,
x_guarnt_adj_ind => rec_lor_data.guarnt_adj_ind,
x_grade_level_code => rec_lor_data.grade_level_code,
x_enrollment_code => rec_lor_data.enrollment_code,
x_anticip_compl_date => rec_lor_data.anticip_compl_date,
x_borw_lender_id => rec_lor_data.borw_lender_id, --NULL,
x_duns_borw_lender_id => rec_lor_data.duns_borw_lender_id, --NULL,
x_guarantor_id => rec_lor_data.guarantor_id, --NULL,
x_duns_guarnt_id => rec_lor_data.duns_guarnt_id, --NULL,
x_prc_type_code => rec_lor_data.prc_type_code,
x_cl_seq_number => rec_lor_data.cl_seq_number,
x_last_resort_lender => rec_lor_data.last_resort_lender,
x_lender_id => rec_lor_data.lender_id, --NULL,
x_duns_lender_id => rec_lor_data.duns_lender_id, --NULL,
x_lend_non_ed_brc_id => rec_lor_data.lend_non_ed_brc_id, --NULL,
x_recipient_id => rec_lor_data.recipient_id, --NULL,
x_recipient_type => rec_lor_data.recipient_type, --NULL,
x_duns_recip_id => rec_lor_data.duns_recip_id, --NULL,
x_recip_non_ed_brc_id => rec_lor_data.recip_non_ed_brc_id, --NULL,
x_rec_type_ind => rec_lor_data.rec_type_ind,
x_cl_loan_type => rec_lor_data.cl_loan_type,
x_cl_rec_status => rec_lor_data.cl_rec_status, --NULL,
x_cl_rec_status_last_update => rec_lor_data.cl_rec_status_last_update, --NULL,
x_alt_prog_type_code => rec_lor_data.alt_prog_type_code,
x_alt_appl_ver_code => rec_lor_data.alt_appl_ver_code,
x_mpn_confirm_code => rec_lor_data.mpn_confirm_code, --NULL,
x_resp_to_orig_code => rec_lor_data.resp_to_orig_code,
x_appl_loan_phase_code => rec_lor_data.appl_loan_phase_code, --NULL,
x_appl_loan_phase_code_chg => rec_lor_data.appl_loan_phase_code_chg, --NULL,
x_appl_send_error_codes => rec_lor_data.appl_send_error_codes, --NULL,
x_tot_outstd_stafford => rec_lor_data.tot_outstd_stafford,
x_tot_outstd_plus => rec_lor_data.tot_outstd_plus,
x_alt_borw_tot_debt => rec_lor_data.alt_borw_tot_debt,
x_act_interest_rate => rec_lor_data.act_interest_rate,
x_service_type_code => rec_lor_data.service_type_code,
x_rev_notice_of_guarnt => rec_lor_data.rev_notice_of_guarnt,
x_sch_refund_amt => rec_lor_data.sch_refund_amt,
x_sch_refund_date => rec_lor_data.sch_refund_date,
x_uniq_layout_vend_code => rec_lor_data.uniq_layout_vend_code,
x_uniq_layout_ident_code => rec_lor_data.uniq_layout_ident_code,
x_p_person_id => rec_lor_data.p_person_id,
x_p_ssn_chg_date => rec_lor_data.p_ssn_chg_date, --NULL,
x_p_dob_chg_date => rec_lor_data.p_dob_chg_date, --NULL,
x_p_permt_addr_chg_date => rec_lor_data.p_permt_addr_chg_date, --NULL,
x_p_default_status => rec_lor_data.p_default_status,
x_p_signature_code => rec_lor_data.p_signature_code,
x_p_signature_date => rec_lor_data.p_signature_date,
x_s_ssn_chg_date => rec_lor_data.s_ssn_chg_date, --NULL,
x_s_dob_chg_date => rec_lor_data.s_dob_chg_date, --NULL,
x_s_permt_addr_chg_date => rec_lor_data.s_permt_addr_chg_date, --NULL,
x_s_local_addr_chg_date => rec_lor_data.s_local_addr_chg_date, --NULL,
x_s_default_status => rec_lor_data.s_default_status,
x_s_signature_code => rec_lor_data.s_signature_code,
x_pnote_batch_id => rec_lor_data.pnote_batch_id,
x_pnote_ack_date => rec_lor_data.pnote_ack_date,
x_pnote_mpn_ind => rec_lor_data.pnote_mpn_ind ,
x_elec_mpn_ind => rec_lor_data.elec_mpn_ind ,
x_borr_sign_ind => rec_lor_data.borr_sign_ind ,
x_stud_sign_ind => rec_lor_data.stud_sign_ind ,
x_borr_credit_auth_code => rec_lor_data.borr_credit_auth_code ,
x_relationship_cd => rec_lor_data.relationship_cd,
x_interest_rebate_percent_num => rec_lor_data.interest_rebate_percent_num,
x_cps_trans_num => rec_lor_data.cps_trans_num ,
x_atd_entity_id_txt => rec_lor_data.atd_entity_id_txt,
x_rep_entity_id_txt => rec_lor_data.rep_entity_id_txt,
x_crdt_decision_status => rec_lor_data.crdt_decision_status,
x_note_message => rec_lor_data.note_message ,
x_book_loan_amt => rec_lor_data.book_loan_amt ,
x_book_loan_amt_date => rec_lor_data.book_loan_amt_date,
x_actual_record_type_code => rec_lor_data.actual_record_type_code,
x_alt_approved_amt => rec_lor_data.alt_approved_amt,
x_deferment_request_code => rec_lor_data.deferment_request_code,
x_eft_authorization_code => rec_lor_data.eft_authorization_code,
x_external_loan_id_txt => rec_lor_data.external_loan_id_txt,
x_flp_approved_amt => rec_lor_data.flp_approved_amt,
x_fls_approved_amt => rec_lor_data.fls_approved_amt,
x_flu_approved_amt => rec_lor_data.flu_approved_amt,
x_guarantor_use_txt => rec_lor_data.guarantor_use_txt,
x_lender_use_txt => rec_lor_data.lender_use_txt,
x_loan_app_form_code => rec_lor_data.loan_app_form_code,
x_override_grade_level_code => rec_lor_data.override_grade_level_code,
x_pymt_servicer_amt => rec_lor_data.pymt_servicer_amt,
x_pymt_servicer_date => rec_lor_data.pymt_servicer_date,
x_reinstatement_amt => rec_lor_data.reinstatement_amt,
x_requested_loan_amt => rec_lor_data.requested_loan_amt,
x_school_use_txt => rec_lor_data.school_use_txt,
x_b_alien_reg_num_txt => rec_lor_data.b_alien_reg_num_txt,
x_esign_src_typ_cd => lv_esign_roster_data,
x_acad_begin_date => rec_lor_data.acad_begin_date,
x_acad_end_date => rec_lor_data.acad_end_date
);
p_update_disb IN VARCHAR2)
AS
/*************************************************************
Created By : sjadhav
Date Created On : 2000/12/18
Purpose :This is the procedeure called by con prog.
This procedure updates igf_aw_awd_disb table based on
certain conditions.
This process will set the status of all the records
processed as 'Processed' in the igf_db_cl_disb_resp
table.
Know limitations, enhancements or remarks
Change History
Who When What
(reverse chronological order - newest change first)
ridas 07-Aug-2006 Build FA163. Added condition to check the Direct_to_borr_ind difference between
the roster information and the disbursement table information.
tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
Changed the call of igf_aw_awd_disb_pkg.update_row to reflect the addition of attendance_type_code
***************************************************************/
l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
SELECT cdresp.* FROM igf_db_cl_disb_resp cdresp
WHERE cbth_id = l_cbth_id
AND status = 'N'
FOR UPDATE OF status NOWAIT;
SELECT
disb.*
FROM igf_aw_awd_disb disb,igf_sl_loans_all loans
WHERE
NVL(loans.external_loan_id_txt, loans.loan_number) = l_loan_number AND
disb.award_id = loans.award_id AND
disb.disb_num = l_disb_num
FOR UPDATE OF disb.fund_status NOWAIT;
SELECT clset.auto_late_disb_ind
FROM igf_sl_cl_setup_all clset
WHERE (ci_cal_type,ci_sequence_number,relationship_cd )
IN
(
SELECT base.ci_cal_type,base.ci_sequence_number, lor.relationship_cd
FROM igf_ap_fa_base_rec_all base, igf_aw_award_all awd,
igf_sl_loans_all loans,igf_sl_lor_all lor
WHERE base.base_id = awd.base_id
AND awd.award_id = loans.award_id
AND loans.loan_id = lor.loan_id
AND awd.award_id = p_award_id
);
IF p_update_disb = 'N' THEN
lv_rec_status := 'D';
ELSIF p_update_disb = 'Y' THEN
lv_rec_status := 'U';
igf_aw_awd_disb_pkg.update_row(
x_mode => 'R',
x_rowid => disb_rec.row_id,
x_award_id => disb_rec.award_id,
x_disb_num => disb_rec.disb_num,
x_tp_cal_type => disb_rec.tp_cal_type,
x_tp_sequence_number => disb_rec.tp_sequence_number,
x_disb_gross_amt => disb_rec.disb_gross_amt,
x_fee_1 => disb_rec.fee_1,
x_fee_2 => disb_rec.fee_2,
x_disb_net_amt => disb_rec.disb_net_amt,
x_disb_date => disb_rec.disb_date,
x_trans_type => disb_rec.trans_type,
x_elig_status => disb_rec.elig_status,
x_elig_status_date => disb_rec.elig_status_date,
x_affirm_flag => disb_rec.affirm_flag,
x_hold_rel_ind => disb_rec.hold_rel_ind,
x_manual_hold_ind => disb_rec.manual_hold_ind,
x_disb_status => disb_rec.disb_status,
x_disb_status_date => disb_rec.disb_status_date,
x_late_disb_ind => NVL(l_late_disb_ind, disb_rec.late_disb_ind),
x_fund_dist_mthd => NVL(l_fund_dist_mthd, disb_rec.fund_dist_mthd),
x_prev_reported_ind => NVL(l_prev_reported_ind, disb_rec.prev_reported_ind),
x_fund_release_date => NVL(l_fund_release_date,disb_rec.fund_release_date),
x_fund_status => 'Y',
x_fund_status_date => TRUNC(SYSDATE),
x_fee_paid_1 => disb_rec.fee_paid_1,
x_fee_paid_2 => disb_rec.fee_paid_2,
x_cheque_number => NVL(l_check_number,disb_rec.cheque_number),
x_ld_cal_type => disb_rec.ld_cal_type,
x_ld_sequence_number => disb_rec.ld_sequence_number,
x_disb_accepted_amt => disb_rec.disb_accepted_amt,
x_disb_paid_amt => disb_rec.disb_paid_amt,
x_rvsn_id => disb_rec.rvsn_id,
x_int_rebate_amt => disb_rec.int_rebate_amt,
x_force_disb => disb_rec.force_disb,
x_min_credit_pts => disb_rec.min_credit_pts,
x_disb_exp_dt => disb_rec.disb_exp_dt,
x_verf_enfr_dt => disb_rec.verf_enfr_dt,
x_fee_class => disb_rec.fee_class,
x_show_on_bill => disb_rec.show_on_bill,
x_attendance_type_code => disb_rec.attendance_type_code,
x_base_attendance_type_code => disb_rec.base_attendance_type_code,
x_payment_prd_st_date => disb_rec.payment_prd_st_date,
x_change_type_code => disb_rec.change_type_code,
x_fund_return_mthd_code => disb_rec.fund_return_mthd_code,
x_direct_to_borr_flag => disb_rec.direct_to_borr_flag
);
igf_db_cl_disb_resp_pkg.update_row(
x_mode => 'R',
x_rowid => cbth_rec.row_id,
x_cdbr_id => cbth_rec.cdbr_id,
x_cbth_id => cbth_rec.cbth_id,
x_record_type => cbth_rec.record_type,
x_loan_number => cbth_rec.loan_number,
x_cl_seq_number => cbth_rec.cl_seq_number,
x_b_last_name => cbth_rec.b_last_name,
x_b_first_name => cbth_rec.b_first_name,
x_b_middle_name => cbth_rec.b_middle_name,
x_b_ssn => cbth_rec.b_ssn,
x_b_addr_line_1 => cbth_rec.b_addr_line_1,
x_b_addr_line_2 => cbth_rec.b_addr_line_2,
x_b_city => cbth_rec.b_city,
x_b_state => cbth_rec.b_state,
x_b_zip => cbth_rec.b_zip,
x_b_zip_suffix => cbth_rec.b_zip_suffix,
x_b_addr_chg_date => cbth_rec.b_addr_chg_date,
x_eft_auth_code => cbth_rec.eft_auth_code,
x_s_last_name => cbth_rec.s_last_name,
x_s_first_name => cbth_rec.s_first_name,
x_s_middle_initial => cbth_rec.s_middle_initial,
x_s_ssn => cbth_rec.s_ssn,
x_school_id => cbth_rec.school_id,
x_school_use => cbth_rec.school_use,
x_loan_per_start_date => cbth_rec.loan_per_start_date,
x_loan_per_end_date => cbth_rec.loan_per_end_date,
x_cl_loan_type => cbth_rec.cl_loan_type,
x_alt_prog_type_code => cbth_rec.alt_prog_type_code,
x_lender_id => cbth_rec.lender_id,
x_lend_non_ed_brc_id => cbth_rec.lend_non_ed_brc_id,
x_lender_use => cbth_rec.lender_use,
x_borw_confirm_ind => cbth_rec.borw_confirm_ind,
x_tot_sched_disb => cbth_rec.tot_sched_disb,
x_fund_release_date => cbth_rec.fund_release_date,
x_disb_num => cbth_rec.disb_num,
x_guarantor_id => cbth_rec.guarantor_id,
x_guarantor_use => cbth_rec.guarantor_use,
x_guarantee_date => cbth_rec.guarantee_date,
x_guarantee_amt => cbth_rec.guarantee_amt,
x_gross_disb_amt => cbth_rec.gross_disb_amt,
x_fee_1 => cbth_rec.fee_1,
x_fee_2 => cbth_rec.fee_2,
x_net_disb_amt => cbth_rec.net_disb_amt,
x_fund_dist_mthd => cbth_rec.fund_dist_mthd,
x_check_number => cbth_rec.check_number,
x_late_disb_ind => cbth_rec.late_disb_ind,
x_prev_reported_ind => cbth_rec.prev_reported_ind,
x_err_code1 => cbth_rec.err_code1,
x_err_code2 => cbth_rec.err_code2,
x_err_code3 => cbth_rec.err_code3,
x_err_code4 => cbth_rec.err_code4,
x_err_code5 => cbth_rec.err_code5,
x_fee_paid_2 => cbth_rec.fee_paid_2,
x_lender_name => cbth_rec.lender_name,
x_net_cancel_amt => cbth_rec.net_cancel_amt,
x_duns_lender_id => cbth_rec.duns_lender_id,
x_duns_guarnt_id => cbth_rec.duns_guarnt_id,
x_hold_rel_ind => cbth_rec.hold_rel_ind,
x_pnote_code => cbth_rec.pnote_code,
x_pnote_status_date => cbth_rec.pnote_status_date,
x_fee_paid_1 => cbth_rec.fee_paid_1,
x_netted_cancel_amt => cbth_rec.netted_cancel_amt,
x_outstd_cancel_amt => cbth_rec.outstd_cancel_amt,
x_sch_non_ed_brc_id => cbth_rec.sch_non_ed_brc_id,
x_status => lv_rec_status,
x_esign_src_typ_cd => cbth_rec.esign_src_typ_cd,
x_direct_to_borr_flag => cbth_rec.direct_to_borr_flag
);