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

Line 189: OE_Order_Cache.Load_Order_Header(update_line.header_id);

185: oe_debug_pub.add('old SP :'||update_line.unit_selling_price);
186: oe_debug_pub.add('new SP :'||l_selling_price);
187: END IF;
188:
189: OE_Order_Cache.Load_Order_Header(update_line.header_id);
190: --for bug 3108881.Log the request for Orders only
191: IF nvl(update_line.transaction_phase_code,'F') = 'F' THEN
192:
193: OE_Delayed_Requests_Pvt.Log_Request

Line 217: OE_Order_Cache.g_header_rec.transactional_curr_code

213: -- Other parameters
214: ,p_param8 => update_line.fulfilled_flag
215: ,p_param9 => update_line.line_set_id
216: ,p_request_unique_key1 =>
217: OE_Order_Cache.g_header_rec.transactional_curr_code
218: ,x_return_status => l_return_status
219: );
220:
221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 237: OE_Order_Cache.g_header_rec.transactional_curr_code

233: ,p_request_type => 'VALIDATE_RELEASE_SHIPMENTS'
234: ,p_request_unique_key1 => update_line.blanket_number
235: ,p_request_unique_key2 => update_line.blanket_line_number
236: ,p_param1 =>
237: OE_Order_Cache.g_header_rec.transactional_curr_code
238: ,x_return_status => l_return_status
239: );
240: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 786: oe_debug_pub.add( 'CACHED VALUE' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;

782: -- Start : Changes made as a part of DBI ER # 4185227
783: --
784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add( 'CALLING OE_DBI_UTIL FOR HEADER PRICE ADJUSTMENTS' , 1 ) ;
786: oe_debug_pub.add( 'CACHED VALUE' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
787: oe_debug_pub.add( 'RECURSION VALUE' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
788: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
789: END IF;
790:

Line 792: oe_order_cache.g_header_rec.booked_flag = 'Y' AND

788: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
789: END IF;
790:
791: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND
792: oe_order_cache.g_header_rec.booked_flag = 'Y' AND
793: oe_order_util.g_recursion_without_exception = 'N' AND
794: l_control_rec.write_to_db
795: THEN
796:

Line 1508: oe_debug_pub.add( 'CACHED VALUE' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;

1504: -- Start : Changes made as a part of DBI ER # 4185227
1505: --
1506: IF l_debug_level > 0 THEN
1507: oe_debug_pub.add( 'CALLING OE_DBI_UTIL FOR ORDER LINE PRICE ADJUSTMENTS' , 1 ) ;
1508: oe_debug_pub.add( 'CACHED VALUE' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
1509: oe_debug_pub.add( 'RECURSION VALUE' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
1510: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
1511: END IF;
1512:

Line 1514: oe_order_cache.g_header_rec.booked_flag = 'Y' AND

1510: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
1511: END IF;
1512:
1513: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND
1514: oe_order_cache.g_header_rec.booked_flag = 'Y' AND
1515: oe_order_util.g_recursion_without_exception = 'N' AND
1516: l_control_rec.write_to_db
1517: THEN
1518: OE_DBI_UTIL.Update_DBI_Log( x_return_status => l_return_status);

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

1988: x_return_status => l_return_status);
1989: */
1990: Begin
1991: -- use order_header cache instead of sql : bug 4200055
1992: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1993: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1994: and OE_Order_Cache.g_header_rec.header_id = l_header_price_att_rec.header_id ) then
1995: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1996: else

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

1989: */
1990: Begin
1991: -- use order_header cache instead of sql : bug 4200055
1992: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1993: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1994: and OE_Order_Cache.g_header_rec.header_id = l_header_price_att_rec.header_id ) then
1995: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1996: else
1997: OE_ORDER_CACHE.Load_Order_Header(l_header_price_att_rec.header_id);

Line 1994: and OE_Order_Cache.g_header_rec.header_id = l_header_price_att_rec.header_id ) then

1990: Begin
1991: -- use order_header cache instead of sql : bug 4200055
1992: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1993: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1994: and OE_Order_Cache.g_header_rec.header_id = l_header_price_att_rec.header_id ) then
1995: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1996: else
1997: OE_ORDER_CACHE.Load_Order_Header(l_header_price_att_rec.header_id);
1998: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;

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

1991: -- use order_header cache instead of sql : bug 4200055
1992: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1993: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1994: and OE_Order_Cache.g_header_rec.header_id = l_header_price_att_rec.header_id ) then
1995: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1996: else
1997: OE_ORDER_CACHE.Load_Order_Header(l_header_price_att_rec.header_id);
1998: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1999: end if ;

Line 1997: OE_ORDER_CACHE.Load_Order_Header(l_header_price_att_rec.header_id);

1993: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1994: and OE_Order_Cache.g_header_rec.header_id = l_header_price_att_rec.header_id ) then
1995: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1996: else
1997: OE_ORDER_CACHE.Load_Order_Header(l_header_price_att_rec.header_id);
1998: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1999: end if ;
2000: /*Select booked_flag Into
2001: l_booked_flag

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

1994: and OE_Order_Cache.g_header_rec.header_id = l_header_price_att_rec.header_id ) then
1995: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1996: else
1997: OE_ORDER_CACHE.Load_Order_Header(l_header_price_att_rec.header_id);
1998: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1999: end if ;
2000: /*Select booked_flag Into
2001: l_booked_flag
2002: From OE_Order_Headers where

Line 4115: l_item_rec OE_ORDER_CACHE.item_rec_type; --OPM 2046190

4111: l_uom_rate NUMBER;
4112: v_discounting_privilege VARCHAR2(30);
4113: l_item_type_code VARCHAR2(30);
4114:
4115: l_item_rec OE_ORDER_CACHE.item_rec_type; --OPM 2046190
4116:
4117: begin
4118: G_STMT_NO := 'copy_Line_to_request#10';
4119: adj_debug('Entering oe_order_Adj_pvt.copy_Line_to_request',1);

Line 5600: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;

5596:
5597: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
5598: l_pass_all_lines VARCHAR2(30);
5599: l_exists_phase VARCHAR2(1) := 'N';
5600: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
5601: j PLS_INTEGER :=1;
5602: G_INT_CHANGED_LINE_ON Varchar2(3):= nvl(FND_PROFILE.VALUE('ONT_INTERNAL_CHANGED_LINE'),'Y');
5603: l_header_id2 NUMBER;
5604: begin

Line 6203: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;

6199: l_control_rec.rounding_flag := 'Q';
6200: l_control_rec.use_multi_currency:='Y';
6201: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
6202: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
6203: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
6204: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
6205:
6206: G_STMT_NO := 'QP_PRICE_REQUEST_GRP';
6207: QP_PREQ_GRP.PRICE_REQUEST

Line 8185: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940

8181: l_gsa_cust_check varchar2(1);
8182: -- for bug 1717501 end
8183: l_status_code Varchar2(5);
8184:
8185: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
8186: l_process Boolean; -- OPM 2547940
8187:
8188: Begin
8189:

Line 9077: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940

9073:
9074: l_status_code Varchar2(5);
9075: l_line_detail_replaced Index_Tbl_Type;
9076:
9077: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
9078: l_process Boolean; -- OPM 2547940
9079:
9080: --
9081: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 11152: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940

11148: l_dummy_line_rec Oe_Order_Pub.Line_Rec_Type;
11149: l_price_control_rec OE_ORDER_PRICE_PVT.CONTROL_REC_TYPE;
11150: x_line_tbl oe_order_pub.line_tbl_type;
11151: l_status_code Varchar2(5);
11152: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
11153: --serla begin
11154: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
11155: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
11156: --serla end

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

11728: END IF;
11729: adj_debug('Price Action Header_id :'||l_HEader_id);
11730:
11731: -- use order_header cache instead of sql : bug 4200055
11732: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
11733: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
11734: and OE_Order_Cache.g_header_rec.header_id = l_header_id ) then
11735: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11736: else

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

11729: adj_debug('Price Action Header_id :'||l_HEader_id);
11730:
11731: -- use order_header cache instead of sql : bug 4200055
11732: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
11733: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
11734: and OE_Order_Cache.g_header_rec.header_id = l_header_id ) then
11735: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11736: else
11737: OE_ORDER_CACHE.Load_Order_Header(l_header_id);

Line 11734: and OE_Order_Cache.g_header_rec.header_id = l_header_id ) then

11730:
11731: -- use order_header cache instead of sql : bug 4200055
11732: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
11733: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
11734: and OE_Order_Cache.g_header_rec.header_id = l_header_id ) then
11735: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11736: else
11737: OE_ORDER_CACHE.Load_Order_Header(l_header_id);
11738: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;

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

11731: -- use order_header cache instead of sql : bug 4200055
11732: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
11733: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
11734: and OE_Order_Cache.g_header_rec.header_id = l_header_id ) then
11735: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11736: else
11737: OE_ORDER_CACHE.Load_Order_Header(l_header_id);
11738: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11739: end if ;

Line 11737: OE_ORDER_CACHE.Load_Order_Header(l_header_id);

11733: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
11734: and OE_Order_Cache.g_header_rec.header_id = l_header_id ) then
11735: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11736: else
11737: OE_ORDER_CACHE.Load_Order_Header(l_header_id);
11738: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11739: end if ;
11740: /*Select booked_flag into l_booked_flag from oe_order_headers_all
11741: where header_id=l_header_id; */

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

11734: and OE_Order_Cache.g_header_rec.header_id = l_header_id ) then
11735: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11736: else
11737: OE_ORDER_CACHE.Load_Order_Header(l_header_id);
11738: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11739: end if ;
11740: /*Select booked_flag into l_booked_flag from oe_order_headers_all
11741: where header_id=l_header_id; */
11742: --end bug 4200055