APPS.OE_BULK_ORDER_PVT dependencies on OE_HEADERS_IFACE_ALL

Line 179: UPDATE OE_HEADERS_IFACE_ALL

175: --ER 9060917
176: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then
177:
178: FORALL i IN (G_error_count+1)..G_ERROR_REC.order_source_id.COUNT
179: UPDATE OE_HEADERS_IFACE_ALL
180: SET ERROR_FLAG = 'Y'
181: WHERE REQUEST_ID = G_REQUEST_ID
182: AND ORDER_SOURCE_ID = G_ERROR_REC.order_source_id(i)
183: AND ORIG_SYS_DOCUMENT_REF = G_ERROR_REC.orig_sys_document_ref(i)

Line 196: UPDATE OE_HEADERS_IFACE_ALL

192:
193: else --old behaviour
194:
195: FORALL i IN (G_error_count+1)..G_ERROR_REC.order_source_id.COUNT
196: UPDATE OE_HEADERS_IFACE_ALL
197: SET ERROR_FLAG = 'Y'
198: WHERE REQUEST_ID = G_REQUEST_ID
199: AND ORDER_SOURCE_ID = G_ERROR_REC.order_source_id(i)
200: AND ORIG_SYS_DOCUMENT_REF = G_ERROR_REC.orig_sys_document_ref(i);

Line 1167: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

1163: BEGIN
1164:
1165: SELECT 'Y'
1166: INTO l_adjustments_exist
1167: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
1168: WHERE h.batch_id = p_batch_id
1169: AND a.order_source_id = h.order_source_id
1170: AND a.orig_sys_document_ref = h.orig_sys_document_ref
1171: AND rownum = 1;