APPS.OE_ORDER_BOOK_UTIL dependencies on OE_ORDER_LINES_ALL

Line 509: UPDATE oe_order_lines_all

505: -- Clear cached results for constraints as order being booked
506: -- may change results of some validation packages
507: OE_PC_Constraints_Admin_PVT.Clear_Cached_Results;
508:
509: UPDATE oe_order_lines_all
510: SET booked_flag = 'Y'
511: , flow_status_code = 'BOOKED'
512: , last_updated_by = FND_GLOBAL.USER_ID
513: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 905: FROM oe_order_lines_all

901: --
902: --FP bug 3872166
903: CURSOR line_ids(p_header_id IN NUMBER) IS
904: SELECT line_id
905: FROM oe_order_lines_all
906: WHERE header_id = p_header_id;
907: BEGIN
908: IF l_debug_level > 0 THEN
909: oe_debug_pub.add('Entering Oe_Order_Book_Util.Validate_sales_Credits' ) ;

Line 1066: FROM oe_order_lines_all

1062:
1063: BEGIN
1064: SELECT
1065: 'EXISTS' INTO l_dummy
1066: FROM oe_order_lines_all
1067: WHERE header_id = p_header_id and
1068: ROWNUM = 1;
1069:
1070: IF sql%found THEN