<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="CON_COLLECTION_CALLBACK_TEMP"> <bm:fields> <bm:field name="callback_temp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CALLBACK_TEMP_ID" prompt="CON_COLLECTION_CALLBACK_TEMP.CALLBACK_TEMP_ID"/> <bm:field name="contract_lease_item_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_LEASE_ITEM_ID" prompt="CON_COLLECTION_CALLBACK_TEMP.CONTRACT_LEASE_ITEM_ID"/> <bm:field name="batch_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BATCH_ID" prompt="CON_COLLECTION_CALLBACK_TEMP.BATCH_ID"/> <bm:field name="callback_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CALLBACK_ID" prompt="CON_COLLECTION_CALLBACK_TEMP.CALLBACK_ID"/> </bm:fields> <bm:features> <f:standard-who/> </bm:features> <bm:operations> <bm:operation name="insert"> <bm:update-sql><![CDATA[ DECLARE v_callback_temp_id NUMBER; BEGIN SELECT con_collection_callback_temp_s.nextval INTO v_callback_temp_id FROM dual; INSERT INTO CON_COLLECTION_CALLBACK_TEMP ( callback_temp_id, contract_lease_item_id, batch_id, callback_id, creation_date, created_by, last_update_date, last_updated_by ) VALUES ( v_callback_temp_id, ${@contract_lease_item_id}, ${@batch_id}, ${@callback_id}, sysdate, ${/session/@user_id}, sysdate, ${/session/@user_id} ); UPDATE con_collection_callback SET batch_id = ${@batch_id} WHERE callback_id = ${@callback_id}; END; ]]></bm:update-sql> </bm:operation> </bm:operations> </bm:model>