[Home] [Help]
1365: --
1366: --Change History:
1367: --Who When What
1368: --bvisvana 10-Apr-2006 Build FA 161.
1369: -- TBH Impact change done in igf_sl_lor_loc_pkg.update_row()
1370: --museshad 05-May-2005 Bug# 4346258
1371: -- Added the parameter 'base_id' in the call to the
1372: -- function get_cl_version(). The signature of
1373: -- this function has been changed so that it takes
2676: -- if no loan increase (@1-24), pass the same value originally present in the
2677: -- lor table for the input loan and origination id
2678: rec_c_sl_lor_loc.requested_loan_amt := NVL(l_n_loan_amt_increase,rec_c_sl_lor_loc.requested_loan_amt);
2679: log_to_fnd(p_v_module => 'sub_create_file',
2680: p_v_string => ' invoking igf_sl_lor_loc_pkg.update_row for ' ||
2681: ' loan id = ' ||rec_c_recip_dtls.loan_id ||
2682: ' Origination id = ' ||rec_c_sl_lor_loc.origination_id
2683: );
2684: igf_sl_lor_loc_pkg.update_row (
2680: p_v_string => ' invoking igf_sl_lor_loc_pkg.update_row for ' ||
2681: ' loan id = ' ||rec_c_recip_dtls.loan_id ||
2682: ' Origination id = ' ||rec_c_sl_lor_loc.origination_id
2683: );
2684: igf_sl_lor_loc_pkg.update_row (
2685: x_rowid => rec_c_sl_lor_loc.row_id ,
2686: x_loan_id => rec_c_sl_lor_loc.loan_id ,
2687: x_origination_id => rec_c_sl_lor_loc.origination_id ,
2688: x_loan_number => rec_c_sl_lor_loc.loan_number ,
2881: x_borower_credit_authoriz_flag => rec_c_sl_lor_loc.borower_credit_authoriz_flag ,
2882: x_esign_src_typ_cd => rec_c_sl_lor_loc.esign_src_typ_cd
2883: );
2884: log_to_fnd(p_v_module => 'sub_create_file',
2885: p_v_string => ' Call out to igf_sl_lor_loc_pkg.update_row for ' ||
2886: ' loan id = ' ||rec_c_sl_lor_loc.loan_id ||
2887: ' Origination id = ' ||rec_c_sl_lor_loc.origination_id ||
2888: ' Successful. Updated the change status to Sent '
2889: );