<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
            select t.project_id,
                   t.project_number,
                   t.amount
            from wh_train_project_lv t
			#WHERE_CLAUSE#]]></bm:query-sql>

        <bm:operation name="execute">
        <bm:update-sql><![CDATA[
            begin
                wh_train_project_pkg.project_submit(p_project_id	 =>${@project_id},,
                									 p_user_id	 =>${/session/@user_id}
                									 p_user_id	 =>${/session/@user_id});
            end;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
    <bm:query-fields>
        <bm:query-field name="project_id" dataType="java.lang.String" queryExpression="project_id =  ${@project_id}"/>
        <bm:query-field name="project_number" dataType="java.lang.String" queryExpression="project_number like  &apos;%&apos;||${@project_number}||&apos;%&apos;"/>
        <bm:query-field name="amount" dataType="java.lang.String" queryExpression="amount =  ${@amount}"/>
    </bm:query-fields>
</bm:model>