prj_reconsider_confirm.lwm 983 Bytes
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: Feng  
    $Date: 2013-7-15 下午4:10:21  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
                BEGIN
                    UPDATE
                        prj_project
                    SET
                        project_status  = 'RECONSIDER',
                        project_number   = 'CON' || substr(project_number,
                                                  4),
                        LAST_UPDATED_BY = ${/session/@user_id},
                        LAST_UPDATE_DATE = SYSDATE,
                        reconsider_time = SYSDATE
                    WHERE
                        project_id = ${/parameter/@project_id};
                END;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>