update_sys_parameter.lwm 1.17 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 30 31 32 33 34 35
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: ZLF  
    $Date: 2015-2-6 上午1:47:23  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
                BEGIN
                    UPDATE
                        sys_parameter_values pv
                    SET
                        pv.parameter_value=TO_CHAR(to_number(pv.parameter_value)+${@step})
                    WHERE
                        pv.parameter_id=103 AND
                        (
                            NOT EXISTS
                            (SELECT
                                1
                            FROM
                                acr_invoice_hd h
                            WHERE
                                h.invoice_hd_id  IN (${:@invoice_hd_id}) AND
                                h.receipt_number IS NOT NULL
                            ) OR
                            ${/parameter/@again_flag}='Y'
                        );
                END;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>