DBA Data[Home] [Help]

APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_LINES_INTERFACE

Line 291: delete from oe_lines_interface

287: from oe_headers_iface_all
288: where batch_id = p_batch_id
289: and nvl(error_flag,'N') = 'N');
290:
291: delete from oe_lines_interface
292: where (order_source_id, orig_sys_document_ref) IN
293: (select order_source_id, orig_sys_document_ref
294: from oe_headers_iface_all
295: where batch_id = p_batch_id

Line 1269: UPDATE oe_lines_interface

1265: BULK Processing APIs should use the global request ID (G_REQUEST_ID)
1266: to identify current child request ID. Do not use request_id on the
1267: interface tables.
1268:
1269: UPDATE oe_lines_interface
1270: SET request_id = l_request_id
1271: WHERE (order_source_id, orig_sys_document_ref) IN
1272: ( SELECT order_source_id, orig_sys_document_ref
1273: FROM oe_headers_iface_all