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 190: OE_Order_Cache.Load_Order_Header(update_line.header_id);

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

Line 218: OE_Order_Cache.g_header_rec.transactional_curr_code

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

Line 238: OE_Order_Cache.g_header_rec.transactional_curr_code

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

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

817: -- Start : Changes made as a part of DBI ER # 4185227
818: --
819: IF l_debug_level > 0 THEN
820: oe_debug_pub.add( 'CALLING OE_DBI_UTIL FOR HEADER PRICE ADJUSTMENTS' , 1 ) ;
821: oe_debug_pub.add( 'CACHED VALUE' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
822: oe_debug_pub.add( 'RECURSION VALUE' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
823: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
824: END IF;
825:

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

823: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
824: END IF;
825:
826: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND
827: oe_order_cache.g_header_rec.booked_flag = 'Y' AND
828: oe_order_util.g_recursion_without_exception = 'N' AND
829: l_control_rec.write_to_db
830: THEN
831:

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

1587: -- Start : Changes made as a part of DBI ER # 4185227
1588: --
1589: IF l_debug_level > 0 THEN
1590: oe_debug_pub.add( 'CALLING OE_DBI_UTIL FOR ORDER LINE PRICE ADJUSTMENTS' , 1 ) ;
1591: oe_debug_pub.add( 'CACHED VALUE' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
1592: oe_debug_pub.add( 'RECURSION VALUE' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
1593: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
1594: END IF;
1595:

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

1593: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
1594: END IF;
1595:
1596: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND
1597: oe_order_cache.g_header_rec.booked_flag = 'Y' AND
1598: oe_order_util.g_recursion_without_exception = 'N' AND
1599: l_control_rec.write_to_db
1600: THEN
1601: OE_DBI_UTIL.Update_DBI_Log( x_return_status => l_return_status);

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

2071: x_return_status => l_return_status);
2072: */
2073: Begin
2074: -- use order_header cache instead of sql : bug 4200055
2075: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
2076: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
2077: and OE_Order_Cache.g_header_rec.header_id = l_header_price_att_rec.header_id ) then
2078: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
2079: else

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

2072: */
2073: Begin
2074: -- use order_header cache instead of sql : bug 4200055
2075: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
2076: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
2077: and OE_Order_Cache.g_header_rec.header_id = l_header_price_att_rec.header_id ) then
2078: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
2079: else
2080: OE_ORDER_CACHE.Load_Order_Header(l_header_price_att_rec.header_id);

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

2073: Begin
2074: -- use order_header cache instead of sql : bug 4200055
2075: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
2076: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
2077: and OE_Order_Cache.g_header_rec.header_id = l_header_price_att_rec.header_id ) then
2078: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
2079: else
2080: OE_ORDER_CACHE.Load_Order_Header(l_header_price_att_rec.header_id);
2081: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;

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

2074: -- use order_header cache instead of sql : bug 4200055
2075: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
2076: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
2077: and OE_Order_Cache.g_header_rec.header_id = l_header_price_att_rec.header_id ) then
2078: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
2079: else
2080: OE_ORDER_CACHE.Load_Order_Header(l_header_price_att_rec.header_id);
2081: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
2082: end if ;

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

2076: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
2077: and OE_Order_Cache.g_header_rec.header_id = l_header_price_att_rec.header_id ) then
2078: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
2079: else
2080: OE_ORDER_CACHE.Load_Order_Header(l_header_price_att_rec.header_id);
2081: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
2082: end if ;
2083: /*Select booked_flag Into
2084: l_booked_flag

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

2077: and OE_Order_Cache.g_header_rec.header_id = l_header_price_att_rec.header_id ) then
2078: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
2079: else
2080: OE_ORDER_CACHE.Load_Order_Header(l_header_price_att_rec.header_id);
2081: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
2082: end if ;
2083: /*Select booked_flag Into
2084: l_booked_flag
2085: From OE_Order_Headers where

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

4194: l_uom_rate NUMBER;
4195: v_discounting_privilege VARCHAR2(30);
4196: l_item_type_code VARCHAR2(30);
4197:
4198: l_item_rec OE_ORDER_CACHE.item_rec_type; --OPM 2046190
4199:
4200: begin
4201: G_STMT_NO := 'copy_Line_to_request#10';
4202: adj_debug('Entering oe_order_Adj_pvt.copy_Line_to_request',1);

Line 5683: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;

5679:
5680: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
5681: l_pass_all_lines VARCHAR2(30);
5682: l_exists_phase VARCHAR2(1) := 'N';
5683: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
5684: j PLS_INTEGER :=1;
5685: G_INT_CHANGED_LINE_ON Varchar2(3):= nvl(FND_PROFILE.VALUE('ONT_INTERNAL_CHANGED_LINE'),'Y');
5686: l_header_id2 NUMBER;
5687: begin

Line 6294: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;

6290: l_control_rec.rounding_flag := 'Q';
6291: l_control_rec.use_multi_currency:='Y';
6292: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
6293: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
6294: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
6295: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
6296:
6297: G_STMT_NO := 'QP_PRICE_REQUEST_GRP';
6298: QP_PREQ_GRP.PRICE_REQUEST

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

8273: l_gsa_cust_check varchar2(1);
8274: -- for bug 1717501 end
8275: l_status_code Varchar2(5);
8276:
8277: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
8278: l_process Boolean; -- OPM 2547940
8279:
8280: Begin
8281:

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

9165:
9166: l_status_code Varchar2(5);
9167: l_line_detail_replaced Index_Tbl_Type;
9168:
9169: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
9170: l_process Boolean; -- OPM 2547940
9171:
9172: --
9173: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

11256: l_dummy_line_rec Oe_Order_Pub.Line_Rec_Type;
11257: l_price_control_rec OE_ORDER_PRICE_PVT.CONTROL_REC_TYPE;
11258: x_line_tbl oe_order_pub.line_tbl_type;
11259: l_status_code Varchar2(5);
11260: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
11261: --serla begin
11262: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
11263: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
11264: --serla end

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

11839: END IF;
11840: adj_debug('Price Action Header_id :'||l_HEader_id);
11841:
11842: -- use order_header cache instead of sql : bug 4200055
11843: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
11844: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
11845: and OE_Order_Cache.g_header_rec.header_id = l_header_id ) then
11846: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11847: else

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

11840: adj_debug('Price Action Header_id :'||l_HEader_id);
11841:
11842: -- use order_header cache instead of sql : bug 4200055
11843: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
11844: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
11845: and OE_Order_Cache.g_header_rec.header_id = l_header_id ) then
11846: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11847: else
11848: OE_ORDER_CACHE.Load_Order_Header(l_header_id);

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

11841:
11842: -- use order_header cache instead of sql : bug 4200055
11843: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
11844: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
11845: and OE_Order_Cache.g_header_rec.header_id = l_header_id ) then
11846: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11847: else
11848: OE_ORDER_CACHE.Load_Order_Header(l_header_id);
11849: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;

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

11842: -- use order_header cache instead of sql : bug 4200055
11843: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
11844: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
11845: and OE_Order_Cache.g_header_rec.header_id = l_header_id ) then
11846: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11847: else
11848: OE_ORDER_CACHE.Load_Order_Header(l_header_id);
11849: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11850: end if ;

Line 11848: OE_ORDER_CACHE.Load_Order_Header(l_header_id);

11844: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
11845: and OE_Order_Cache.g_header_rec.header_id = l_header_id ) then
11846: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11847: else
11848: OE_ORDER_CACHE.Load_Order_Header(l_header_id);
11849: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11850: end if ;
11851: /*Select booked_flag into l_booked_flag from oe_order_headers_all
11852: where header_id=l_header_id; */

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

11845: and OE_Order_Cache.g_header_rec.header_id = l_header_id ) then
11846: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11847: else
11848: OE_ORDER_CACHE.Load_Order_Header(l_header_id);
11849: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
11850: end if ;
11851: /*Select booked_flag into l_booked_flag from oe_order_headers_all
11852: where header_id=l_header_id; */
11853: --end bug 4200055