APPS.OE_LINE_PAYMENT_UTIL dependencies on OE_ORDER_HEADERS

Line 1202: FROM oe_order_headers_all

1198: OE_ORDER_CACHE.Load_Order_Header(p_x_Line_Payment_rec.header_id);
1199: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1200: end if ;
1201: /*SELECT booked_flag INTO l_booked_flag
1202: FROM oe_order_headers_all
1203: WHERE header_id=p_x_Line_Payment_rec.header_id; */
1204: -- end bug 4200055
1205:
1206: IF p_old_Line_Payment_rec.payment_type_code IS NOT NULL THEN

Line 3465: INTO l_currency_code from oe_order_headers

3461: -- build currency format.
3462: IF g_fmt_mask IS NULL THEN
3463: BEGIN
3464: SELECT nvl(transactional_curr_code,'USD')
3465: INTO l_currency_code from oe_order_headers
3466: WHERE header_id=p_x_line_Payment_rec.header_id;
3467:
3468: EXCEPTION
3469: WHEN NO_DATA_FOUND THEN

Line 3552: from oe_order_headers

3548: --Verify
3549: /** comment out this sql stmt to fetch these data from cache.
3550: select ordered_date, transactional_curr_code, invoice_to_org_id
3551: into l_ordered_date, l_transactional_curr_code, l_invoice_to_org_id
3552: from oe_order_headers
3553: where header_id=p_x_line_Payment_rec.header_id;
3554: **/
3555:
3556: oe_order_cache.load_order_header(p_x_line_Payment_rec.header_id);

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

4074:
4075: l_line_rec := l_old_line_rec;
4076:
4077: if l_debug_level > 0 then
4078: oe_debug_pub.add('before updating oe_order_headers_all ');
4079: end if;
4080:
4081: if l_upd_commitment = 1 and l_upd_payment = 1 then
4082: