fnd_dimensions_operation.lwm 1.11 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 29 30 31 32 33 34 35 36 37
<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="insert">
            <bm:update-sql><![CDATA[
            begin
				fnd_dimensions_pkg.insert_fnd_dimensions
				 (
	                ${@dimension_sequence},
	                ${@dimension_code},
	                ${@description},
	                'N',
	               nvl (${@system_level},'N'),
	               nvl (${@company_level},'N'),
	               nvl (${@enabled_flag},'N'),
	                ${/session/@user_id}
				 );			  		
			end;
		]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
        		begin
					fnd_dimensions_pkg.update_fnd_dimensions
					 (
		               ${@dimension_code},
		               ${@description},
		               nvl (${@system_level},'N'),
		               nvl (${@company_level},'N'),
		               nvl (${@enabled_flag},'N'),
		               ${/session/@user_id}
					 );			  		
				end;
        	]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>