APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_PRICE_ADJS_INTERFACE

Line 214: DELETE FROM oe_price_adjs_interface

210:
211: --ER 9060917
212: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then
213:
214: DELETE FROM oe_price_adjs_interface
215: WHERE(order_source_id, orig_sys_document_ref) IN
216: (SELECT order_source_id,
217: orig_sys_document_ref
218: FROM oe_headers_iface_all a

Line 229: DELETE FROM oe_price_adjs_interface

225: AND b.order_source_id = a.order_source_id
226: AND batch_id = p_batch_id
227: AND nvl(error_flag, 'N') = 'N'));
228:
229: DELETE FROM oe_price_adjs_interface
230: WHERE(order_source_id, orig_sys_line_ref, orig_sys_document_ref) IN
231: (SELECT a.order_source_id,
232: a.orig_sys_line_ref,
233: a.orig_sys_document_ref

Line 284: delete from oe_price_adjs_interface

280:
281:
282: --ER 9060917
283: else
284: delete from oe_price_adjs_interface
285: where (order_source_id, orig_sys_document_ref) IN
286: (select order_source_id, orig_sys_document_ref
287: from oe_headers_iface_all
288: where batch_id = p_batch_id

Line 1197: -- Update on oe_price_adjs_interface

1193: = l_order_rec.orig_sys_document_ref(l_index)
1194: AND org_id IS NULL
1195: AND l_default_org_id = nvl(p_operating_unit,l_default_org_id);
1196:
1197: -- Update on oe_price_adjs_interface
1198: FORALL l_index IN 1..l_order_count
1199: UPDATE OE_PRICE_ADJS_IFACE_ALL
1200: SET org_id = l_order_rec.org_id(l_index) -- added for MOAC
1201: WHERE order_source_id = l_order_rec.order_source_id(l_index)

Line 1278: UPDATE oe_price_adjs_interface

1274: WHERE request_id = l_request_id);
1275:
1276: COMMIT;
1277:
1278: UPDATE oe_price_adjs_interface
1279: SET request_id = l_request_id
1280: WHERE (order_source_id, orig_sys_document_ref) IN
1281: ( SELECT order_source_id, orig_sys_document_ref
1282: FROM oe_headers_iface_all