DBA Data[Home] [Help]

APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_ACTIONS_INTERFACE

Line 204: delete from oe_actions_interface

200:
201: -- Delete all successfully processed records from interface
202: -- tables
203:
204: delete from oe_actions_interface
205: where (order_source_id, orig_sys_document_ref) IN
206: (select order_source_id, orig_sys_document_ref
207: from oe_headers_iface_all
208: where batch_id = p_batch_id

Line 1287: UPDATE oe_actions_interface

1283: WHERE request_id = l_request_id);
1284:
1285: COMMIT;
1286:
1287: UPDATE oe_actions_interface
1288: SET request_id = l_request_id
1289: WHERE (order_source_id, orig_sys_document_ref) IN
1290: ( SELECT order_source_id, orig_sys_document_ref
1291: FROM oe_headers_iface_all