APPS.OE_ORDER_PRICE_PVT dependencies on OE_ORDER_HEADERS

Line 313: FROM OE_ORDER_HEADERS_ALL

309: , x_header_rec.SHIPPING_METHOD_CODE
310: , x_header_rec.SOLD_TO_ORG_ID
311: , x_header_rec.TRANSACTIONAL_CURR_CODE
312: , x_header_rec.LOCK_CONTROL
313: FROM OE_ORDER_HEADERS_ALL
314: WHERE HEADER_ID = p_header_id;
315:
316: EXCEPTION
317: WHEN NO_DATA_FOUND THEN

Line 1811: FROM OE_ORDER_HEADERS_ALL

1807: INTO l_transactional_curr_code,
1808: l_conversion_type_code,
1809: l_conversion_rate,
1810: l_conversion_rate_date
1811: FROM OE_ORDER_HEADERS_ALL
1812: WHERE header_id = l_line_rec.header_id;
1813:
1814: IF l_debug_level > 0 THEN
1815:

Line 2871: update oe_order_headers

2867: where line_type_code='ORDER' and line_id=px_header_rec.header_id;
2868:
2869: oe_debug_pub.add(' l_price_request_code = '|| l_price_request_code);
2870:
2871: update oe_order_headers
2872: set price_request_code = l_price_request_code
2873: where header_id = px_header_rec.header_id;
2874: --bug 9777018: End
2875: