APPS.OE_BULK_ORDER_PVT dependencies on OE_HEADERS_IFACE_ALL

Line 159: UPDATE OE_HEADERS_IFACE_ALL

155: oe_debug_pub.add('G_REQUEST_ID :'||G_REQUEST_ID);
156: oe_debug_pub.add('G_ORDER_SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID(1));
157: END IF;
158: FORALL i IN (G_error_count+1)..G_ERROR_REC.order_source_id.COUNT
159: UPDATE OE_HEADERS_IFACE_ALL
160: SET ERROR_FLAG = 'Y'
161: WHERE REQUEST_ID = G_REQUEST_ID
162: AND ORDER_SOURCE_ID = G_ERROR_REC.order_source_id(i)
163: AND ORIG_SYS_DOCUMENT_REF = G_ERROR_REC.orig_sys_document_ref(i);

Line 1126: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

1122: BEGIN
1123:
1124: SELECT 'Y'
1125: INTO l_adjustments_exist
1126: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
1127: WHERE h.batch_id = p_batch_id
1128: AND a.order_source_id = h.order_source_id
1129: AND a.orig_sys_document_ref = h.orig_sys_document_ref
1130: AND rownum = 1;