eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_PAYMENT_TRXN_UTIL dependencies on OE_ORDER_CACHE

Line 105: oe_order_cache.load_order_header(p_header_id);

101: select invoice_to_org_id,org_id into l_invoice_to_org_id,l_org_id
102: from oe_order_headers_all where header_id = p_header_id;
103: */
104: -- get cached value.
105: oe_order_cache.load_order_header(p_header_id);
106: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;
107: l_org_id := OE_Order_Cache.g_header_rec.org_id;
108: END IF;
109: IF l_debug_level > 0 THEN

Line 106: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;

102: from oe_order_headers_all where header_id = p_header_id;
103: */
104: -- get cached value.
105: oe_order_cache.load_order_header(p_header_id);
106: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;
107: l_org_id := OE_Order_Cache.g_header_rec.org_id;
108: END IF;
109: IF l_debug_level > 0 THEN
110: oe_debug_pub.add('Invoice_to_org_id'||l_invoice_to_org_id);

Line 107: l_org_id := OE_Order_Cache.g_header_rec.org_id;

103: */
104: -- get cached value.
105: oe_order_cache.load_order_header(p_header_id);
106: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;
107: l_org_id := OE_Order_Cache.g_header_rec.org_id;
108: END IF;
109: IF l_debug_level > 0 THEN
110: oe_debug_pub.add('Invoice_to_org_id'||l_invoice_to_org_id);
111: oe_debug_pub.add('org id'||l_org_id);

Line 758: oe_order_cache.load_order_header(p_header_id);

754: select invoice_to_org_id,org_id into l_invoice_to_org_id,l_org_id
755: from oe_order_headers_all where header_id = p_header_id;
756: */
757:
758: oe_order_cache.load_order_header(p_header_id);
759: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;
760: l_org_id := OE_Order_Cache.g_header_rec.org_id;
761: end if;
762:

Line 759: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;

755: from oe_order_headers_all where header_id = p_header_id;
756: */
757:
758: oe_order_cache.load_order_header(p_header_id);
759: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;
760: l_org_id := OE_Order_Cache.g_header_rec.org_id;
761: end if;
762:
763: IF l_debug_level > 0 THEN

Line 760: l_org_id := OE_Order_Cache.g_header_rec.org_id;

756: */
757:
758: oe_order_cache.load_order_header(p_header_id);
759: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;
760: l_org_id := OE_Order_Cache.g_header_rec.org_id;
761: end if;
762:
763: IF l_debug_level > 0 THEN
764: oe_debug_pub.add('INVOICE_TO_ORG_ID and ORG_ID'||l_invoice_to_org_id||' and '||l_org_id);

Line 1623: oe_order_cache.load_order_header(p_header_id);

1619: select invoice_to_org_id,ORG_ID into l_invoice_to_org_id,l_org_id
1620: from oe_order_headers_all where header_id = p_header_id;
1621: */
1622:
1623: oe_order_cache.load_order_header(p_header_id);
1624: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;
1625: l_org_id := OE_Order_Cache.g_header_rec.org_id;
1626: end if;
1627: IF l_debug_level > 0 THEN

Line 1624: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;

1620: from oe_order_headers_all where header_id = p_header_id;
1621: */
1622:
1623: oe_order_cache.load_order_header(p_header_id);
1624: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;
1625: l_org_id := OE_Order_Cache.g_header_rec.org_id;
1626: end if;
1627: IF l_debug_level > 0 THEN
1628: oe_debug_pub.add('INVOICE_TO_ORG_ID and ORG_ID'||l_invoice_to_org_id||' and '||l_org_id);

Line 1625: l_org_id := OE_Order_Cache.g_header_rec.org_id;

1621: */
1622:
1623: oe_order_cache.load_order_header(p_header_id);
1624: l_invoice_to_org_id := OE_Order_Cache.g_header_rec.invoice_to_org_id;
1625: l_org_id := OE_Order_Cache.g_header_rec.org_id;
1626: end if;
1627: IF l_debug_level > 0 THEN
1628: oe_debug_pub.add('INVOICE_TO_ORG_ID and ORG_ID'||l_invoice_to_org_id||' and '||l_org_id);
1629: END IF;

Line 2110: oe_order_cache.load_order_header(p_header_id);

2106: IF p_line_id is not null then
2107: Select ORG_ID into l_org_id
2108: from oe_order_lines_all where line_id = p_line_id and header_id = p_header_id;
2109: else
2110: oe_order_cache.load_order_header(p_header_id);
2111: l_org_id := OE_Order_Cache.g_header_rec.org_id;
2112: end if;
2113: --For ACH and direct debit payment types, the site use id that
2114: --needs to be queried from payment tables is different from the query

Line 2111: l_org_id := OE_Order_Cache.g_header_rec.org_id;

2107: Select ORG_ID into l_org_id
2108: from oe_order_lines_all where line_id = p_line_id and header_id = p_header_id;
2109: else
2110: oe_order_cache.load_order_header(p_header_id);
2111: l_org_id := OE_Order_Cache.g_header_rec.org_id;
2112: end if;
2113: --For ACH and direct debit payment types, the site use id that
2114: --needs to be queried from payment tables is different from the query
2115: --for Credit card payments. Hence to differentiate this, the payment