get_interest_rate.lwm 1.75 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="execute">
            <bm:parameters>
                <bm:parameter name="int_rate" dataType="java.lang.Double" input="false" output="true" outputPath="/parameter/@int_rate"/>
                <bm:parameter name="int_rate_type" dataType="java.lang.String" input="true" output="false"/>
                <bm:parameter name="currency" dataType="java.lang.String" input="true" output="false"/>
                <bm:parameter name="valid_date" dataType="java.util.Date" input="true" output="false"/>
                <bm:parameter name="month" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="user_id" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="calc_session_id" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="down_payment_ratio" dataType="java.lang.String" input="true" output="false"/>
            </bm:parameters>
            <bm:update-sql><![CDATA[
                begin
                    ${@int_rate} := HLS_FIN_CALC_COMMON_PKG.cus_get_interest_rate
                    (   p_calc_session_id =>${@calc_session_id},
                        p_int_rate_type=>${@int_rate_type},
                        p_currency=>${@currency},
                        p_valid_date=>nvl(to_date(${@valid_date},'yyyy-mm-dd'),sysdate),
                        p_down_payment_ratio => ${@down_payment_ratio},
                        p_month=>${@month},
                        p_user_id=>${/session/@user_id}
                    );
                end;]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>