<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
            	begin
            		con_contract_workflow_pkg.check_lease_start_date(
            				p_contract_id   =>${@contract_id},
            				p_lease_start_date   =>to_date(${@lease_start_date},'yyyy/mm/dd'),
            				p_error_count    =>${@error_count},
            				p_user_id              =>${/session/@user_id}
               		);
            	end;
            ]]></bm:update-sql>
             <bm:parameters>
             <bm:parameter name="error_count" dataType="java.lang.Long" input="false" output="true"/>
            </bm:parameters>
           </bm:operation>
      <bm:operation name="query">
               <bm:query-sql><![CDATA[
                 select
                  cc.sign_type sign_type,
                  hd.full_elec_sign full_elec_sign
                  from con_contract cc, hls_division hd
                  #WHERE_CLAUSE#
                ]]></bm:query-sql>
           </bm:operation>
     </bm:operations>
</bm:model>

