<?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
                    UPDATE
                        con_col_management_hd t
                    SET
                        t.CONFIRM_CAR_FLAG = 'Y',
                        t.CONFIRM_DATE     = trunc(sysdate),
                        t.last_update_date = sysdate,
                        t.last_updated_by  = ${/session/@user_id}
                    WHERE
                        t.management_id = ${@management_id};
                END;
            ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
                BEGIN
                    -- Call the procedure
                    con_collection_pkg.con_col_management_submit(p_management_id => ${@management_id}, p_user_id => ${/session/@user_id});
                END;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
