APPS.OE_BULK_PROCESS_LINE dependencies on OE_LINES_IFACE_ALL

Line 513: FROM OE_LINES_IFACE_ALL

509: , l_segment_array(18)
510: , l_segment_array(19)
511: , l_segment_array(20)
512: , l_inventory_item
513: FROM OE_LINES_IFACE_ALL
514: WHERE order_source_id = p_line_rec.order_source_id(p_index)
515: AND orig_sys_document_ref = p_line_rec.orig_sys_document_ref(p_index)
516: AND orig_sys_line_ref = p_line_rec.orig_sys_line_ref(p_index)
517: AND org_id = p_line_rec.org_id(p_index)

Line 4430: UPDATE OE_LINES_IFACE_ALL

4426: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then
4427:
4428: If p_line_rec.item_type_code(l_index) ='STANDARD' then
4429:
4430: UPDATE OE_LINES_IFACE_ALL
4431: SET ERROR_FLAG = 'Y'
4432: WHERE ORDER_SOURCE_ID = p_line_rec.order_source_id(l_index)
4433: AND ORIG_SYS_DOCUMENT_REF = p_line_rec.orig_sys_document_ref(l_index)
4434: AND ORIG_SYS_LINE_REF = p_line_rec.orig_sys_line_Ref(l_index);

Line 4438: UPDATE OE_LINES_IFACE_ALL

4434: AND ORIG_SYS_LINE_REF = p_line_rec.orig_sys_line_Ref(l_index);
4435:
4436: else
4437:
4438: UPDATE OE_LINES_IFACE_ALL
4439: SET ERROR_FLAG = 'Y'
4440: WHERE ORDER_SOURCE_ID = p_line_rec.order_source_id(l_index)
4441: AND ORIG_SYS_DOCUMENT_REF = p_line_rec.orig_sys_document_ref(l_index)
4442: AND top_model_line_ref = p_line_rec.top_model_line_ref(l_index);