DBA Data[Home] [Help]

APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_LINES_INTERFACE

Line 218: delete from oe_lines_interface

214: from oe_headers_iface_all
215: where batch_id = p_batch_id
216: and nvl(error_flag,'N') = 'N');
217:
218: delete from oe_lines_interface
219: where (order_source_id, orig_sys_document_ref) IN
220: (select order_source_id, orig_sys_document_ref
221: from oe_headers_iface_all
222: where batch_id = p_batch_id

Line 1174: UPDATE oe_lines_interface

1170: BULK Processing APIs should use the global request ID (G_REQUEST_ID)
1171: to identify current child request ID. Do not use request_id on the
1172: interface tables.
1173:
1174: UPDATE oe_lines_interface
1175: SET request_id = l_request_id
1176: WHERE (order_source_id, orig_sys_document_ref) IN
1177: ( SELECT order_source_id, orig_sys_document_ref
1178: FROM oe_headers_iface_all