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

Line 252: IF oe_order_cache.g_header_rec.header_id = p_header_id THEN

248: l_org_id := OE_GLOBALS.G_ORG_ID;
249: END IF;
250:
251: -- aksingh use global record if exists for header_id
252: IF oe_order_cache.g_header_rec.header_id = p_header_id THEN
253: l_x_header_rec_oper := x_header_rec.operation;
254: x_header_rec := oe_order_cache.g_header_rec;
255: x_header_rec.operation := l_x_header_rec_oper;
256: return;

Line 254: x_header_rec := oe_order_cache.g_header_rec;

250:
251: -- aksingh use global record if exists for header_id
252: IF oe_order_cache.g_header_rec.header_id = p_header_id THEN
253: l_x_header_rec_oper := x_header_rec.operation;
254: x_header_rec := oe_order_cache.g_header_rec;
255: x_header_rec.operation := l_x_header_rec_oper;
256: return;
257: END IF;
258:

Line 673: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then

669: G_STMT_NO := 'Enforce_Price_lists_Flag#10';
670: -- changes for bug 4200055
671: IF ( OE_Order_PUB.G_Line.Line_Type_id is not null
672: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
673: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
674: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
675: end if ;
676: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then
677: l_enforce_price_flag := nvl(OE_Order_Cache.g_line_type_rec.enforce_line_prices_flag,'N') ;

Line 674: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;

670: -- changes for bug 4200055
671: IF ( OE_Order_PUB.G_Line.Line_Type_id is not null
672: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
673: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
674: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
675: end if ;
676: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then
677: l_enforce_price_flag := nvl(OE_Order_Cache.g_line_type_rec.enforce_line_prices_flag,'N') ;
678: else

Line 676: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then

672: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
673: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
674: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
675: end if ;
676: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then
677: l_enforce_price_flag := nvl(OE_Order_Cache.g_line_type_rec.enforce_line_prices_flag,'N') ;
678: else
679: l_enforce_price_flag := 'N';
680: end if ;

Line 677: l_enforce_price_flag := nvl(OE_Order_Cache.g_line_type_rec.enforce_line_prices_flag,'N') ;

673: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
674: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
675: end if ;
676: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then
677: l_enforce_price_flag := nvl(OE_Order_Cache.g_line_type_rec.enforce_line_prices_flag,'N') ;
678: else
679: l_enforce_price_flag := 'N';
680: end if ;
681: ELSE

Line 698: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then

694: G_STMT_NO := 'Enforce_Price_lists_Flag#20';
695: --changes for bug 4200055
696: IF ( OE_Order_PUB.G_Hdr.Order_Type_id is not null
697: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
698: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
699: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
700: end if ;
701: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
702: l_enforce_price_flag := nvl(OE_Order_Cache.g_order_type_rec.enforce_line_prices_flag,'N') ;

Line 699: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;

695: --changes for bug 4200055
696: IF ( OE_Order_PUB.G_Hdr.Order_Type_id is not null
697: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
698: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
699: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
700: end if ;
701: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
702: l_enforce_price_flag := nvl(OE_Order_Cache.g_order_type_rec.enforce_line_prices_flag,'N') ;
703: else

Line 701: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then

697: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
698: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
699: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
700: end if ;
701: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
702: l_enforce_price_flag := nvl(OE_Order_Cache.g_order_type_rec.enforce_line_prices_flag,'N') ;
703: else
704: l_enforce_price_flag := 'N';
705: end if ;

Line 702: l_enforce_price_flag := nvl(OE_Order_Cache.g_order_type_rec.enforce_line_prices_flag,'N') ;

698: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
699: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
700: end if ;
701: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
702: l_enforce_price_flag := nvl(OE_Order_Cache.g_order_type_rec.enforce_line_prices_flag,'N') ;
703: else
704: l_enforce_price_flag := 'N';
705: end if ;
706: ELSE

Line 1759: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;

1755: l_related_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1756: l_status_code varchar2(1);
1757: l_status_text varchar2(240);
1758: --bug 3968023 start
1759: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
1760: l_transactional_curr_code VARCHAR2(15);
1761: l_conversion_type_code VARCHAR2(30);
1762: l_conversion_rate NUMBER;
1763: l_conversion_rate_date DATE;

Line 1799: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;

1795: -- modified by lkxu, to be used in repricing
1796: px_Line_Tbl(line_Tbl_index).calculate_price_flag := 'X';
1797:
1798: --bug 3968023 start
1799: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
1800:
1801:
1802: SELECT transactional_curr_code,
1803: conversion_type_code,

Line 2880: l_tax_calc_rec OE_ORDER_CACHE.Tax_Calc_Rec_Type;

2876: := OE_COMMITMENT_PVT.Do_Commitment_Sequencing;
2877: l_return_status varchar2(1);
2878: l_tax_event_code number := 0;
2879: l_tax_calculation_flag varchar2(1):=NULL;
2880: l_tax_calc_rec OE_ORDER_CACHE.Tax_Calc_Rec_Type;
2881: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2882: l_order_adj_changed_flag varchar2(1);
2883: l_commt_tax_flag varchar2(1); --bug 2505961
2884: cursor updated_lines IS

Line 2944: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then

2940: IF OE_Order_pub.g_hdr.order_type_id is not null THEN
2941:
2942: --changes for bug 4200055
2943: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2944: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2945: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2946: end if ;
2947: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2948: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then

Line 2945: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;

2941:
2942: --changes for bug 4200055
2943: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2944: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2945: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2946: end if ;
2947: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2948: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2949: l_tax_event_code := 0;

Line 2947: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then

2943: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2944: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2945: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2946: end if ;
2947: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2948: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2949: l_tax_event_code := 0;
2950: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
2951: l_tax_event_code := 1;

Line 2948: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then

2944: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2945: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2946: end if ;
2947: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2948: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2949: l_tax_event_code := 0;
2950: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
2951: l_tax_event_code := 1;
2952: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then

Line 2950: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then

2946: end if ;
2947: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2948: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2949: l_tax_event_code := 0;
2950: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
2951: l_tax_event_code := 1;
2952: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
2953: l_tax_event_code := 2;
2954: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then

Line 2952: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then

2948: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2949: l_tax_event_code := 0;
2950: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
2951: l_tax_event_code := 1;
2952: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
2953: l_tax_event_code := 2;
2954: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
2955: l_tax_event_code := 3;
2956: else

Line 2954: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then

2950: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
2951: l_tax_event_code := 1;
2952: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
2953: l_tax_event_code := 2;
2954: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
2955: l_tax_event_code := 3;
2956: else
2957: l_tax_event_code := -1;
2958: end if ;

Line 3011: l_tax_calc_rec := oe_order_cache.get_tax_calculation_flag

3007: l_line_rec.line_category_code := update_line.line_category_code;
3008: l_line_rec.return_context := update_line.return_context;
3009: l_line_Rec.reference_customer_trx_line_id
3010: := update_line.reference_customer_trx_line_id;
3011: l_tax_calc_rec := oe_order_cache.get_tax_calculation_flag
3012: (update_line.line_type_id,
3013: l_line_rec);
3014:
3015: l_tax_calculation_flag := l_tax_calc_rec.tax_calculation_flag;

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

3183: oe_debug_pub.add('old SP :'||update_line.unit_selling_price);
3184: oe_debug_pub.add('new SP :'||update_line.new_selling_price);
3185: END IF;
3186:
3187: OE_Order_Cache.Load_Order_Header(update_line.header_id);
3188: --for bug 3108881
3189: --request should be logged only for Sales order and not for quotes
3190: IF nvl(update_line.transaction_phase_code,'F') = 'F' THEN
3191:

Line 3216: OE_Order_Cache.g_header_rec.transactional_curr_code

3212: -- Other parameters
3213: ,p_param8 => update_line.fulfilled_flag
3214: ,p_param9 => update_line.line_set_id
3215: ,p_request_unique_key1 =>
3216: OE_Order_Cache.g_header_rec.transactional_curr_code
3217: ,x_return_status => l_return_status
3218: );
3219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3235: OE_Order_Cache.g_header_rec.transactional_curr_code

3231: ,p_request_type => 'VALIDATE_RELEASE_SHIPMENTS'
3232: ,p_request_unique_key1 => update_line.blanket_number
3233: ,p_request_unique_key2 => update_line.blanket_line_number
3234: ,p_param1 =>
3235: OE_Order_Cache.g_header_rec.transactional_curr_code
3236: ,x_return_status => l_return_status
3237: );
3238: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3459: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;

3455: i NUMBER;
3456: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3457: l_return_status VARCHAR2(30);
3458: l_index NUMBER;
3459: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
3460:
3461: --
3462: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3463: --

Line 4090: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;

4086: and ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED;
4087:
4088: --pviprana: cursors retrieving the needed values from qp temp tables for debugging purpose *end*
4089:
4090: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
4091:
4092: --bug 3836854
4093: Cursor upd_adj(l_line_type IN Varchar2) Is
4094: select ldets2.price_adjustment_id, ldets2.line_detail_index

Line 5107: l_item_rec OE_ORDER_CACHE.item_rec_type; --OPM 2434270

5103: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
5104: l_uom_rate NUMBER;
5105: v_discounting_privilege VARCHAR2(30);
5106: l_item_type_code VARCHAR2(30);
5107: l_item_rec OE_ORDER_CACHE.item_rec_type; --OPM 2434270
5108: l_dummy VARCHAR2(30);
5109: x_return_status VARCHAR2(30);
5110: x_msg_count NUMBER;
5111: x_msg_data VARCHAR2(2000);

Line 5115: x_item_rec OE_Order_Cache.Item_Rec_Type;

5111: x_msg_data VARCHAR2(2000);
5112: x_secondary_quantity NUMBER;
5113: x_secondary_uom_code VARCHAR2(3);
5114: l_shipped_quantity2 NUMBER;
5115: x_item_rec OE_Order_Cache.Item_Rec_Type;
5116: l_fulfilled_qty NUMBER;
5117:
5118: --
5119: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5433: x_item_rec := OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id

5429: IF (p_line_rec.inventory_item_id IS NOT NULL AND
5430: p_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
5431: (p_line_rec.ship_from_org_id IS NOT NULL AND
5432: p_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
5433: x_item_rec := OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id
5434: ,p_line_rec.ship_from_org_id);
5435: END IF;
5436: IF l_debug_level > 0 THEN
5437: oe_debug_pub.add('ont_pricing_qty_source:'|| l_item_rec.ont_pricing_qty_source);

Line 6015: -- OE_Order_PUB.g_hdr := OE_ORDER_CACHE.g_header_rec;

6011: G_STMT_NO := 'calculate_adjustments#30';
6012:
6013: Begin
6014:
6015: -- OE_Order_PUB.g_hdr := OE_ORDER_CACHE.g_header_rec;
6016: query_header(
6017: p_header_id => p_header_id
6018: , x_header_rec=>oe_order_pub.g_hdr);
6019: Exception when no_data_found then

Line 6665: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;

6661: )
6662: IS
6663: l_return_status_text varchar(2000);
6664: l_control_rec QP_PREQ_GRP.control_record_type;
6665: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
6666: /*
6667: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6668: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6669: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 6704: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;

6700: --For multi_currency price list
6701: l_control_rec.use_multi_currency:='Y';
6702: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
6703: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
6704: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
6705: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
6706:
6707: If l_Control_Rec.pricing_event IN ('BATCH','RETROBILL') OR
6708: nvl(instr( l_Control_Rec.pricing_event,'BATCH'),0) > 0

Line 7532: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;

7528: l_num_changed_lines NUMBER := 0;
7529: l_process_requests BOOLEAN := FALSE;
7530: l_process_ack BOOLEAN := FALSE;
7531: l_notify_flag BOOLEAN;
7532: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
7533: l_return_status VARCHAR2(30);
7534: l_msg_count NUMBER;
7535: l_msg_data VARCHAR2(2000);
7536:

Line 7651: IF (oe_order_cache.g_header_rec.booked_flag = 'Y') Then

7647: IF l_debug_level > 0 THEN
7648: oe_debug_pub.add( 'VOPRB BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;
7649: END IF;
7650:
7651: IF (oe_order_cache.g_header_rec.booked_flag = 'Y') Then
7652: l_process_ack := TRUE;
7653: END IF;
7654:
7655: OE_Order_PVT.Process_Requests_And_Notify