<?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>
-
Spencer Chang authoredbfd31bca