tre_interest_confirm.lwm 1.79 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
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: qwm  
    $Date: 2014-1-3 下午1:05:14  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="execute">
            <bm:parameters>
                <bm:parameter name="confirm_return_value" dataType="java.lang.String" input="false" inputPath="@confirm_return_value" output="true" outputPath="/parameter/@confirm_return_value"/>
                <bm:parameter name="company_id" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="internal_period_num" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="user_id" dataType="java.lang.Long" input="true" output="false"/>
            </bm:parameters>
            <bm:update-sql><![CDATA[
            	declare
 					v_return_value varchar2(30);
                begin
Darming's avatar
Darming committed
21
                    v_return_value := HLS_MONTHEND_NEW_PKG.tre_interest_confirm
Spencer Chang's avatar
Spencer Chang committed
22 23 24 25 26 27
                    (
                        p_company_id=>${/session/@company_id},
                        p_internal_period_num=>${@internal_period_num},
                        p_user_id=>${/session/@user_id}
                    );
                    if v_return_value ='SUCCESS' then
Darming's avatar
Darming committed
28
                    	${@confirm_return_value} := HLS_MONTHEND_NEW_PKG.tre_accrued_interest_je
Spencer Chang's avatar
Spencer Chang committed
29 30 31 32 33 34 35 36 37 38 39 40 41
                    (
                        p_company_id=>${/session/@company_id},
                        p_internal_period_num=>${@internal_period_num},
                        p_user_id=>${/session/@user_id}
                    );
                    end if;
                    
                    
                    
                end;]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>