<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
            	begin
            		
                      rd_prj_project_pkg.update_prj_lease_item(
            			p_project_id                =>${@project_id},
                        p_project_lease_item_id     =>${@project_lease_item_id},
                        p_down_payment              =>${@down_payment},
                        p_down_payment_ratio        =>${@down_payment_ratio},
                        p_deposit_ratio             =>${@deposit_ratio},
                        p_deposit                   =>${@deposit},
                        p_future_prices             =>${@future_prices},
                        p_used_evaluation_amout     =>${@used_evaluation_amout},
                        p_rating_agency_used_prices =>${@rating_agency_used_prices},
                        p_user_id                   =>${/session/@user_id});
                        
              
                        
                     rd_prj_project_pkg.insert_wfl_credit_advice(
            			p_project_id                =>${@project_id},
            			p_credit_advice_type        =>${@credit_advice_type},
                        p_credit_advice_yes_reason  =>${@credit_advice_yes_reason},
                        p_advice_no_main_a=>${@advice_no_main_a},
                        p_advice_no_main_b=>${@advice_no_main_b},
                        p_advice_no_main_c=>${@advice_no_main_c},
                        p_advice_no_main_d=>${@advice_no_main_d},
                        p_advice_no_main_e=>${@advice_no_main_e},
                        p_advice_no_main_f=>${@advice_no_main_f},
                        p_advice_no_main_g=>${@advice_no_main_g},
                        p_advice_no_main_h=>${@advice_no_main_h},
                        p_advice_no_main_i=>${@advice_no_main_i},
                        p_advice_no_main_j=>${@advice_no_main_j},
                        p_advice_no_main_k=>${@advice_no_main_k},
                        
                        p_advice_no_detail_a1=>${@advice_no_detail_a1},
                        p_advice_no_detail_a2=>${@advice_no_detail_a2},
                        p_advice_no_detail_a3=>${@advice_no_detail_a3},
                        p_advice_no_detail_a4=>${@advice_no_detail_a4},
                        p_advice_no_detail_a5=>${@advice_no_detail_a5},
                        p_advice_no_detail_a6=>${@advice_no_detail_a6},
                        p_advice_no_detail_a7=>${@advice_no_detail_a7},
                        p_advice_no_detail_a8=>${@advice_no_detail_a8},
                        p_advice_no_detail_a9=>${@advice_no_detail_a9},
                        p_advice_no_detail_a10=>${@advice_no_detail_a10},
                        p_advice_no_detail_a11=>${@advice_no_detail_a11},
                        p_advice_no_detail_a12=>${@advice_no_detail_a12},
                        p_advice_no_detail_a13=>${@advice_no_detail_a13},
                        
                        p_advice_no_detail_b1=>${@advice_no_detail_b1},
                        p_advice_no_detail_b2=>${@advice_no_detail_b2},
                        p_advice_no_detail_b3=>${@advice_no_detail_b3},
                        p_advice_no_detail_b4=>${@advice_no_detail_b4},
                        p_advice_no_detail_b5=>${@advice_no_detail_b5},
                        p_advice_no_detail_b6=>${@advice_no_detail_b6},
                        
                        p_advice_no_detail_c1=>${@advice_no_detail_c1},
                        p_advice_no_detail_c2=>${@advice_no_detail_c2},
                        p_advice_no_detail_c3=>${@advice_no_detail_c3},
                        p_advice_no_detail_c4=>${@advice_no_detail_c4},
                        p_advice_no_detail_c5=>${@advice_no_detail_c5},
                        p_advice_no_detail_c6=>${@advice_no_detail_c6},
                        
                        p_advice_no_detail_d1=>${@advice_no_detail_d1},
                        p_advice_no_detail_d2=>${@advice_no_detail_d2},
                        p_advice_no_detail_d3=>${@advice_no_detail_d3},
                        p_advice_no_detail_d4=>${@advice_no_detail_d4},
                        p_advice_no_detail_d5=>${@advice_no_detail_d5},
                        
                        p_advice_no_detail_e1=>${@advice_no_detail_e1},
                        p_advice_no_detail_e2=>${@advice_no_detail_e2},
                        p_advice_no_detail_e3=>${@advice_no_detail_e3},
                        p_advice_no_detail_e4=>${@advice_no_detail_e4},
                        p_advice_no_detail_e5=>${@advice_no_detail_e5},
                        
                        p_advice_no_detail_f1=>${@advice_no_detail_f1},
                        p_advice_no_detail_f2=>${@advice_no_detail_f2},
                        p_advice_no_detail_f3=>${@advice_no_detail_f3},
                        p_advice_no_detail_f4=>${@advice_no_detail_f4},
                        p_advice_no_detail_f5=>${@advice_no_detail_f5},
                        p_advice_no_detail_f6=>${@advice_no_detail_f6},
                        
                        p_advice_no_detail_g1=>${@advice_no_detail_g1},
                        p_advice_no_detail_g2=>${@advice_no_detail_g2},
                        p_advice_no_detail_g3=>${@advice_no_detail_g3},
                        p_advice_no_detail_g4=>${@advice_no_detail_g4},
                        p_advice_no_detail_g5=>${@advice_no_detail_g5},
                        p_advice_no_detail_g6=>${@advice_no_detail_g6},
                        p_advice_no_detail_g7=>${@advice_no_detail_g7},
                        
                        p_advice_no_detail_h1=>${@advice_no_detail_h1},
                        p_advice_no_detail_h2=>${@advice_no_detail_h2},
                        p_advice_no_detail_h3=>${@advice_no_detail_h3},
                        p_advice_no_detail_h4=>${@advice_no_detail_h4},
                        p_advice_no_detail_h5=>${@advice_no_detail_h5},
                        
                        p_advice_no_detail_i1=>${@advice_no_detail_i1},
                        p_advice_no_detail_i2=>${@advice_no_detail_i2},
                        p_advice_no_detail_i3=>${@advice_no_detail_i3},
                        p_advice_no_detail_i4=>${@advice_no_detail_i4},
                        p_advice_no_detail_i5=>${@advice_no_detail_i5},
                        p_advice_no_detail_i6=>${@advice_no_detail_i6},
                        
                        p_advice_no_detail_j1=>${@advice_no_detail_j1},
                        p_advice_no_detail_j2=>${@advice_no_detail_j2},
                        p_advice_no_detail_j3=>${@advice_no_detail_j3},
                        p_advice_no_detail_j4=>${@advice_no_detail_j4},
                        
                        p_advice_no_detail_k1=>${@advice_no_detail_k1},
                        
                        p_user_id         =>${/session/@user_id});
            	end;
            	
            	
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
