DBA Data[Home] [Help]

APPS.OE_ORDER_BOOK_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 490: UPDATE oe_order_headers_all

486:
487: -- Update the booked_flag and flow_status on the tables
488: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
489:
490: UPDATE oe_order_headers_all
491: SET booked_flag = 'Y'
492: , booked_date = sysdate
493: , flow_status_code = 'BOOKED'
494: , last_updated_by = FND_GLOBAL.USER_ID

Line 1540: FROM OE_ORDER_HEADERS_ALL

1536: END IF;
1537: -- modified the following query to fetch flow_status_code for 13536089
1538: SELECT order_source_id, orig_sys_document_ref, change_sequence, source_document_type_id, source_document_id,flow_status_code
1539: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence, l_source_document_type_id, l_source_document_id,l_flow_status_code
1540: FROM OE_ORDER_HEADERS_ALL
1541: WHERE HEADER_ID = p_header_id;
1542:
1543: OE_MSG_PUB.set_msg_context(
1544: p_entity_code => 'HEADER'

Line 1652: FROM OE_ORDER_HEADERS_ALL

1648: -- been updated.
1649:
1650: SELECT booked_flag
1651: INTO l_booked_flag
1652: FROM OE_ORDER_HEADERS_ALL
1653: WHERE HEADER_ID = p_header_id;
1654:
1655: OE_MSG_PUB.set_msg_context(
1656: p_entity_code => 'HEADER'

Line 1876: FROM oe_order_headers_all h

1872: END IF;
1873: --For CC Project
1874: SELECT h.Transaction_Phase_Code
1875: INTO l_Transaction_Phase_Code
1876: FROM oe_order_headers_all h
1877: WHERE l_header_id=h.header_id;
1878: IF (l_Transaction_Phase_Code='N' ) THEN
1879: OE_Order_Wf_Util.Complete_eligible_and_Book(
1880: p_api_version_number => 1.0