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 1193: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM

1189:
1190: --bug3625027 start
1191: BEGIN
1192: -- use order_header cache instead of sql : bug 4200055
1193: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1194: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1195: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then
1196: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1197: else

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

1190: --bug3625027 start
1191: BEGIN
1192: -- use order_header cache instead of sql : bug 4200055
1193: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1194: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1195: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then
1196: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1197: else
1198: OE_ORDER_CACHE.Load_Order_Header(p_x_Line_Payment_rec.header_id);

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

1191: BEGIN
1192: -- use order_header cache instead of sql : bug 4200055
1193: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1194: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1195: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then
1196: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1197: else
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 ;

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

1192: -- use order_header cache instead of sql : bug 4200055
1193: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1194: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1195: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then
1196: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1197: else
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 ;

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

1194: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1195: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then
1196: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1197: else
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

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

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

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

3522: from oe_order_lines_all where header_id = p_x_line_Payment_rec.header_id
3523: and line_id = p_x_line_payment_rec.line_id;
3524: --Not taking it from the cache as the invoice to org id might change
3525: --in the line level as well.
3526: -- l_invoice_to_org_id := OE_Order_Cache.g_line_rec.invoice_to_org_id;
3527:
3528:
3529: BEGIN
3530: SELECT 'Y'

Line 3556: oe_order_cache.load_order_header(p_x_line_Payment_rec.header_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);
3557: l_ordered_date := OE_Order_Cache.g_header_rec.ordered_date;
3558: l_transactional_curr_code := OE_Order_Cache.g_header_rec.transactional_curr_code;
3559:
3560: IF l_debug_level > 0 THEN

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

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);
3557: l_ordered_date := OE_Order_Cache.g_header_rec.ordered_date;
3558: l_transactional_curr_code := OE_Order_Cache.g_header_rec.transactional_curr_code;
3559:
3560: IF l_debug_level > 0 THEN
3561: oe_debug_pub.add( 'l_transactional_curr_code:'||l_transactional_curr_code||':l_invoice_to_org_id:'||l_invoice_to_org_id);

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

3554: **/
3555:
3556: oe_order_cache.load_order_header(p_x_line_Payment_rec.header_id);
3557: l_ordered_date := OE_Order_Cache.g_header_rec.ordered_date;
3558: l_transactional_curr_code := OE_Order_Cache.g_header_rec.transactional_curr_code;
3559:
3560: IF l_debug_level > 0 THEN
3561: oe_debug_pub.add( 'l_transactional_curr_code:'||l_transactional_curr_code||':l_invoice_to_org_id:'||l_invoice_to_org_id);
3562: END IF;