APPS.OE_LINE_PAYMENT_UTIL dependencies on OE_ORDER_HEADERS

Line 1264: FROM oe_order_headers_all

1260: OE_ORDER_CACHE.Load_Order_Header(p_x_Line_Payment_rec.header_id);
1261: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1262: end if ;
1263: /*SELECT booked_flag INTO l_booked_flag
1264: FROM oe_order_headers_all
1265: WHERE header_id=p_x_Line_Payment_rec.header_id; */
1266: -- end bug 4200055
1267:
1268: IF p_old_Line_Payment_rec.payment_type_code IS NOT NULL THEN

Line 3543: INTO l_currency_code from oe_order_headers

3539: -- build currency format.
3540: IF g_fmt_mask IS NULL THEN
3541: BEGIN
3542: SELECT nvl(transactional_curr_code,'USD')
3543: INTO l_currency_code from oe_order_headers
3544: WHERE header_id=p_x_line_Payment_rec.header_id;
3545:
3546: EXCEPTION
3547: WHEN NO_DATA_FOUND THEN

Line 3630: from oe_order_headers

3626: --Verify
3627: /** comment out this sql stmt to fetch these data from cache.
3628: select ordered_date, transactional_curr_code, invoice_to_org_id
3629: into l_ordered_date, l_transactional_curr_code, l_invoice_to_org_id
3630: from oe_order_headers
3631: where header_id=p_x_line_Payment_rec.header_id;
3632: **/
3633:
3634: oe_order_cache.load_order_header(p_x_line_Payment_rec.header_id);

Line 4156: oe_debug_pub.add('before updating oe_order_headers_all ');

4152:
4153: l_line_rec := l_old_line_rec;
4154:
4155: if l_debug_level > 0 then
4156: oe_debug_pub.add('before updating oe_order_headers_all ');
4157: end if;
4158:
4159: if l_upd_commitment = 1 and l_upd_payment = 1 then
4160: