DBA Data[Home] [Help]

APPS.OE_ORDER_BOOK_UTIL dependencies on OE_ORDER_LINES_ALL

Line 472: UPDATE oe_order_lines_all

468: -- Clear cached results for constraints as order being booked
469: -- may change results of some validation packages
470: OE_PC_Constraints_Admin_PVT.Clear_Cached_Results;
471:
472: UPDATE oe_order_lines_all
473: SET booked_flag = 'Y'
474: , flow_status_code = 'BOOKED'
475: , last_updated_by = FND_GLOBAL.USER_ID
476: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 839: FROM oe_order_lines_all

835: --
836: --FP bug 3872166
837: CURSOR line_ids(p_header_id IN NUMBER) IS
838: SELECT line_id
839: FROM oe_order_lines_all
840: WHERE header_id = p_header_id;
841: BEGIN
842: IF l_debug_level > 0 THEN
843: oe_debug_pub.add('Entering Oe_Order_Book_Util.Validate_sales_Credits' ) ;

Line 1000: FROM oe_order_lines_all

996:
997: BEGIN
998: SELECT
999: 'EXISTS' INTO l_dummy
1000: FROM oe_order_lines_all
1001: WHERE header_id = p_header_id and
1002: ROWNUM = 1;
1003:
1004: IF sql%found THEN