con505_contract_content.lwm 1.66 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
<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
               begin
  			-- Call the procedure
  				con_collection_tool_pkg.con50_contract_content(p_content_id => ${@content_id},
                                                			 p_contract_id => ${@contract_id},
                                                			 p_contract_bp_id => ${@contract_bp_id},
                                                			 p_clause_usage => ${@clause_usage},
                                                			 p_user_id => ${/session/@user_id});
				end;
            ]]></bm:update-sql>
            <bm:parameters>
                <bm:parameter name="content_id" input="false" output="true" outputPath="@content_id"/>
            </bm:parameters>
        </bm:operation>
        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
        	begin
  			-- Call the procedure
  			con_collection_tool_pkg.con_contract_content_update(p_content_id => ${@content_id},
                                                      			p_file_path => ${@file_path},
                                                      			p_user_id => ${/session/@user_id});
			end;
        	 ]]></bm:update-sql>
        </bm:operation>
29 30 31 32 33 34 35

        <bm:operation name="query">
            <bm:query-sql><![CDATA[
                select con_contract_workflow_pkg.get_rsc_upload_flag(p_contract_id   =>${@contract_id}) as is_rsc_upload_flag
                from dual
                ]]></bm:query-sql>
        </bm:operation>
Spencer Chang's avatar
Spencer Chang committed
36 37
    </bm:operations>
</bm:model>