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_LINE_PAYMENT_UTIL dependencies on OE_ORDER_CACHE

Line 1255: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM

1251:
1252: --bug3625027 start
1253: BEGIN
1254: -- use order_header cache instead of sql : bug 4200055
1255: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1256: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1257: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then
1258: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1259: else

Line 1256: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL

1252: --bug3625027 start
1253: BEGIN
1254: -- use order_header cache instead of sql : bug 4200055
1255: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1256: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1257: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then
1258: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1259: else
1260: OE_ORDER_CACHE.Load_Order_Header(p_x_Line_Payment_rec.header_id);

Line 1257: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then

1253: BEGIN
1254: -- use order_header cache instead of sql : bug 4200055
1255: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1256: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1257: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then
1258: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1259: else
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 ;

Line 1258: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;

1254: -- use order_header cache instead of sql : bug 4200055
1255: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1256: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1257: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then
1258: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1259: else
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 ;

Line 1260: OE_ORDER_CACHE.Load_Order_Header(p_x_Line_Payment_rec.header_id);

1256: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1257: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then
1258: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1259: else
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

Line 1261: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;

1257: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then
1258: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1259: else
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; */

Line 3604: -- l_invoice_to_org_id := OE_Order_Cache.g_line_rec.invoice_to_org_id;

3600: from oe_order_lines_all where header_id = p_x_line_Payment_rec.header_id
3601: and line_id = p_x_line_payment_rec.line_id;
3602: --Not taking it from the cache as the invoice to org id might change
3603: --in the line level as well.
3604: -- l_invoice_to_org_id := OE_Order_Cache.g_line_rec.invoice_to_org_id;
3605:
3606:
3607: BEGIN
3608: SELECT 'Y'

Line 3634: oe_order_cache.load_order_header(p_x_line_Payment_rec.header_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);
3635: l_ordered_date := OE_Order_Cache.g_header_rec.ordered_date;
3636: l_transactional_curr_code := OE_Order_Cache.g_header_rec.transactional_curr_code;
3637:
3638: IF l_debug_level > 0 THEN

Line 3635: l_ordered_date := OE_Order_Cache.g_header_rec.ordered_date;

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);
3635: l_ordered_date := OE_Order_Cache.g_header_rec.ordered_date;
3636: l_transactional_curr_code := OE_Order_Cache.g_header_rec.transactional_curr_code;
3637:
3638: IF l_debug_level > 0 THEN
3639: oe_debug_pub.add( 'l_transactional_curr_code:'||l_transactional_curr_code||':l_invoice_to_org_id:'||l_invoice_to_org_id);

Line 3636: l_transactional_curr_code := OE_Order_Cache.g_header_rec.transactional_curr_code;

3632: **/
3633:
3634: oe_order_cache.load_order_header(p_x_line_Payment_rec.header_id);
3635: l_ordered_date := OE_Order_Cache.g_header_rec.ordered_date;
3636: l_transactional_curr_code := OE_Order_Cache.g_header_rec.transactional_curr_code;
3637:
3638: IF l_debug_level > 0 THEN
3639: oe_debug_pub.add( 'l_transactional_curr_code:'||l_transactional_curr_code||':l_invoice_to_org_id:'||l_invoice_to_org_id);
3640: END IF;