APPS.OE_DEALS_UTIL dependencies on OE_ORDER_LINES_ALL

Line 72: FROM OE_ORDER_LINES_ALL where header_id = p_header_id AND

68: l_Configuration_id NUMBER;
69:
70:
71: cursor config_lines is select line_id, Config_header_id, Config_rev_nbr, Configuration_id
72: FROM OE_ORDER_LINES_ALL where header_id = p_header_id AND
73: line_id= top_model_line_id and open_flag='Y' and nvl(cancelled_flag,'N') ='N';
74:
75: BEGIN
76: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 382: UPDATE OE_ORDER_LINES_ALL

378:
379: --Bug 7322917
380: --This is temporary. We need to update the flag using process order API.
381: --Even the above update statement has to be included in the call.
382: UPDATE OE_ORDER_LINES_ALL
383: SET CALCULATE_PRICE_FLAG = 'P'
384: WHERE header_id = l_header_id
385: AND open_flag='Y'
386: AND cancelled_flag='N';

Line 916: cursor lines_cursor is select line_id, unit_selling_price from oe_order_lines_all where header_id=p_header_id

912: i number :=0;
913: l_price_adj_id NUMBER ;
914: l_adjusted_amount NUMBER;
915: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
916: cursor lines_cursor is select line_id, unit_selling_price from oe_order_lines_all where header_id=p_header_id
917: and open_flag='Y' and cancelled_flag='N';
918:
919: BEGIN
920: