APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_PRICE_ADJS_INTERFACE

Line 211: delete from oe_price_adjs_interface

207: from oe_headers_iface_all
208: where batch_id = p_batch_id
209: and nvl(error_flag,'N') = 'N');
210:
211: delete from oe_price_adjs_interface
212: where (order_source_id, orig_sys_document_ref) IN
213: (select order_source_id, orig_sys_document_ref
214: from oe_headers_iface_all
215: where batch_id = p_batch_id

Line 1102: -- Update on oe_price_adjs_interface

1098: = l_order_rec.orig_sys_document_ref(l_index)
1099: AND org_id IS NULL
1100: AND l_default_org_id = nvl(p_operating_unit,l_default_org_id);
1101:
1102: -- Update on oe_price_adjs_interface
1103: FORALL l_index IN 1..l_order_count
1104: UPDATE OE_PRICE_ADJS_IFACE_ALL
1105: SET org_id = l_order_rec.org_id(l_index) -- added for MOAC
1106: WHERE order_source_id = l_order_rec.order_source_id(l_index)

Line 1183: UPDATE oe_price_adjs_interface

1179: WHERE request_id = l_request_id);
1180:
1181: COMMIT;
1182:
1183: UPDATE oe_price_adjs_interface
1184: SET request_id = l_request_id
1185: WHERE (order_source_id, orig_sys_document_ref) IN
1186: ( SELECT order_source_id, orig_sys_document_ref
1187: FROM oe_headers_iface_all