DBA Data[Home] [Help]

APPS.OE_BULK_ORDER_PVT dependencies on OE_ORDER_HEADERS

Line 71: DELETE from OE_ORDER_HEADERS

67: and a.orig_sys_document_ref=G_ERROR_REC.orig_sys_document_ref(i));
68:
69: -- Delete Header Records
70: FORALL i IN 1..G_ERROR_REC.order_source_id.COUNT
71: DELETE from OE_ORDER_HEADERS
72: WHERE header_id = G_ERROR_REC.header_id(i)
73: and not exists (select 1 from oe_order_lines
74: where header_id=G_ERROR_REC.header_id(i));
75: else

Line 83: DELETE from OE_ORDER_HEADERS

79: WHERE header_id = G_ERROR_REC.header_id(i);
80:
81: -- Delete Header Records
82: FORALL i IN 1..G_ERROR_REC.order_source_id.COUNT
83: DELETE from OE_ORDER_HEADERS
84: WHERE header_id = G_ERROR_REC.header_id(i);
85:
86: end if;
87: