APPS.OE_PAYMENT_TRXN_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 160: from oe_order_headers_all where header_id = p_header_id;

156: and line_id = p_line_id;
157: ELSE
158: /*
159: select invoice_to_org_id,org_id into l_invoice_to_org_id,l_org_id
160: from oe_order_headers_all where header_id = p_header_id;
161: */
162: -- get cached value.
163: oe_order_cache.load_order_header(p_header_id);
164: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;

Line 896: from oe_order_headers_all where header_id = p_header_id;

892: from oe_order_lines_all where header_id = p_header_id and line_id = p_line_id;
893: else
894: /*
895: select invoice_to_org_id,org_id into l_invoice_to_org_id,l_org_id
896: from oe_order_headers_all where header_id = p_header_id;
897: */
898:
899: oe_order_cache.load_order_header(p_header_id);
900: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;

Line 1923: from oe_order_headers_all where header_id = p_header_id;

1919: from oe_order_lines_all where header_id = p_header_id and line_id = p_line_id;
1920: else
1921: /*
1922: select invoice_to_org_id,ORG_ID into l_invoice_to_org_id,l_org_id
1923: from oe_order_headers_all where header_id = p_header_id;
1924: */
1925:
1926: oe_order_cache.load_order_header(p_header_id);
1927: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;

Line 2962: FROM oe_order_headers_all

2958: END IF;
2959: BEGIN
2960: SELECT invoice_to_org_id, org_id
2961: INTO l_invoice_to_org_id,l_org_id
2962: FROM oe_order_headers_all
2963: WHERE header_id = p_header_id;
2964: EXCEPTION WHEN NO_DATA_FOUND THEN
2965: IF l_debug_level > 0 THEN
2966: oe_debug_pub.add('Invoice to Org id is null.....',5);

Line 2994: FROM oe_order_headers_all

2990:
2991: BEGIN
2992: SELECT transactional_curr_code
2993: INTO l_currency_code
2994: FROM oe_order_headers_all
2995: WHERE header_id = p_header_id;
2996: EXCEPTION WHEN NO_DATA_FOUND THEN
2997: IF l_debug_level > 0 THEN
2998: oe_debug_pub.add('Currency code is null.....',5);

Line 3159: UPDATE oe_order_headers_all

3155: -- table directly here as we did in 11i code, as the payment amount field is also
3156: -- used for Cash and Check payment type.
3157: -- if line_id is null, then this is for header invoice payment.
3158: IF p_line_id IS NULL THEN
3159: UPDATE oe_order_headers_all
3160: SET payment_amount = 0
3161: , last_updated_by = FND_GLOBAL.USER_ID
3162: , last_update_date = SYSDATE
3163: , last_update_login = FND_GLOBAL.LOGIN_ID