APPS.OE_ORDER_BOOK_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 453: UPDATE oe_order_headers_all

449:
450: -- Update the booked_flag and flow_status on the tables
451: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
452:
453: UPDATE oe_order_headers_all
454: SET booked_flag = 'Y'
455: , booked_date = sysdate
456: , flow_status_code = 'BOOKED'
457: , last_updated_by = FND_GLOBAL.USER_ID

Line 1454: FROM OE_ORDER_HEADERS_ALL

1450: END IF;
1451:
1452: SELECT order_source_id, orig_sys_document_ref, change_sequence, source_document_type_id, source_document_id
1453: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence, l_source_document_type_id, l_source_document_id
1454: FROM OE_ORDER_HEADERS_ALL
1455: WHERE HEADER_ID = p_header_id;
1456:
1457: OE_MSG_PUB.set_msg_context(
1458: p_entity_code => 'HEADER'

Line 1559: FROM OE_ORDER_HEADERS_ALL

1555: -- been updated.
1556:
1557: SELECT booked_flag
1558: INTO l_booked_flag
1559: FROM OE_ORDER_HEADERS_ALL
1560: WHERE HEADER_ID = p_header_id;
1561:
1562: OE_MSG_PUB.set_msg_context(
1563: p_entity_code => 'HEADER'

Line 1765: FROM oe_order_headers_all h

1761: END IF;
1762: --For CC Project
1763: SELECT h.Transaction_Phase_Code
1764: INTO l_Transaction_Phase_Code
1765: FROM oe_order_headers_all h
1766: WHERE l_header_id=h.header_id;
1767: IF (l_Transaction_Phase_Code='N' ) THEN
1768: OE_Order_Wf_Util.Complete_eligible_and_Book(
1769: p_api_version_number => 1.0