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 253: IF oe_order_cache.g_header_rec.header_id = p_header_id THEN

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

Line 255: x_header_rec := oe_order_cache.g_header_rec;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1760: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;

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

Line 1800: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;

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

Line 2901: l_tax_calc_rec OE_ORDER_CACHE.Tax_Calc_Rec_Type;

2897: := OE_COMMITMENT_PVT.Do_Commitment_Sequencing;
2898: l_return_status varchar2(1);
2899: l_tax_event_code number := 0;
2900: l_tax_calculation_flag varchar2(1):=NULL;
2901: l_tax_calc_rec OE_ORDER_CACHE.Tax_Calc_Rec_Type;
2902: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2903: l_order_adj_changed_flag varchar2(1);
2904: l_commt_tax_flag varchar2(1); --bug 2505961
2905: cursor updated_lines IS

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

2961: IF OE_Order_pub.g_hdr.order_type_id is not null THEN
2962:
2963: --changes for bug 4200055
2964: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2965: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2966: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2967: end if ;
2968: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2969: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then

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

2962:
2963: --changes for bug 4200055
2964: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2965: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2966: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2967: end if ;
2968: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2969: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2970: l_tax_event_code := 0;

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

2964: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2965: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2966: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2967: end if ;
2968: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2969: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2970: l_tax_event_code := 0;
2971: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
2972: l_tax_event_code := 1;

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

2965: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2966: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2967: end if ;
2968: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2969: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2970: l_tax_event_code := 0;
2971: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
2972: l_tax_event_code := 1;
2973: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then

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

2967: end if ;
2968: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2969: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2970: l_tax_event_code := 0;
2971: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
2972: l_tax_event_code := 1;
2973: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
2974: l_tax_event_code := 2;
2975: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then

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

2969: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2970: l_tax_event_code := 0;
2971: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
2972: l_tax_event_code := 1;
2973: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
2974: l_tax_event_code := 2;
2975: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
2976: l_tax_event_code := 3;
2977: else

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

2971: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
2972: l_tax_event_code := 1;
2973: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
2974: l_tax_event_code := 2;
2975: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
2976: l_tax_event_code := 3;
2977: else
2978: l_tax_event_code := -1;
2979: end if ;

Line 3032: l_tax_calc_rec := oe_order_cache.get_tax_calculation_flag

3028: l_line_rec.line_category_code := update_line.line_category_code;
3029: l_line_rec.return_context := update_line.return_context;
3030: l_line_Rec.reference_customer_trx_line_id
3031: := update_line.reference_customer_trx_line_id;
3032: l_tax_calc_rec := oe_order_cache.get_tax_calculation_flag
3033: (update_line.line_type_id,
3034: l_line_rec);
3035:
3036: l_tax_calculation_flag := l_tax_calc_rec.tax_calculation_flag;

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

3205: oe_debug_pub.add('old SP :'||update_line.unit_selling_price);
3206: oe_debug_pub.add('new SP :'||update_line.new_selling_price);
3207: END IF;
3208:
3209: OE_Order_Cache.Load_Order_Header(update_line.header_id);
3210: --for bug 3108881
3211: --request should be logged only for Sales order and not for quotes
3212: IF nvl(update_line.transaction_phase_code,'F') = 'F' THEN
3213:

Line 3238: OE_Order_Cache.g_header_rec.transactional_curr_code

3234: -- Other parameters
3235: ,p_param8 => update_line.fulfilled_flag
3236: ,p_param9 => update_line.line_set_id
3237: ,p_request_unique_key1 =>
3238: OE_Order_Cache.g_header_rec.transactional_curr_code
3239: ,x_return_status => l_return_status
3240: );
3241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3257: OE_Order_Cache.g_header_rec.transactional_curr_code

3253: ,p_request_type => 'VALIDATE_RELEASE_SHIPMENTS'
3254: ,p_request_unique_key1 => update_line.blanket_number
3255: ,p_request_unique_key2 => update_line.blanket_line_number
3256: ,p_param1 =>
3257: OE_Order_Cache.g_header_rec.transactional_curr_code
3258: ,x_return_status => l_return_status
3259: );
3260: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3526: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3527: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type; -- bug 8415941
3528: l_return_status VARCHAR2(30);
3529: l_index NUMBER;
3530: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
3531:
3532: --
3533: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3534: --

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

4201: and ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED;
4202:
4203: --pviprana: cursors retrieving the needed values from qp temp tables for debugging purpose *end*
4204:
4205: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
4206:
4207: --bug 3836854
4208: Cursor upd_adj(l_line_type IN Varchar2) Is
4209: select ldets2.price_adjustment_id, ldets2.line_detail_index

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

5281: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
5282: l_uom_rate NUMBER;
5283: v_discounting_privilege VARCHAR2(30);
5284: l_item_type_code VARCHAR2(30);
5285: l_item_rec OE_ORDER_CACHE.item_rec_type; --OPM 2434270
5286: l_dummy VARCHAR2(30);
5287: x_return_status VARCHAR2(30);
5288: x_msg_count NUMBER;
5289: x_msg_data VARCHAR2(2000);

Line 5293: x_item_rec OE_Order_Cache.Item_Rec_Type;

5289: x_msg_data VARCHAR2(2000);
5290: x_secondary_quantity NUMBER;
5291: x_secondary_uom_code VARCHAR2(3);
5292: l_shipped_quantity2 NUMBER;
5293: x_item_rec OE_Order_Cache.Item_Rec_Type;
5294: l_fulfilled_qty NUMBER;
5295: --16206165 CW Start
5296: l_ref_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
5297: l_catch_weight_pricing varchar2(1) := NULL;

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

5708: IF (p_line_rec.inventory_item_id IS NOT NULL AND
5709: p_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
5710: (p_line_rec.ship_from_org_id IS NOT NULL AND
5711: p_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
5712: x_item_rec := OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id
5713: ,p_line_rec.ship_from_org_id);
5714: END IF;
5715: IF l_debug_level > 0 THEN
5716: oe_debug_pub.add('ont_pricing_qty_source:'|| l_item_rec.ont_pricing_qty_source);

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

6293:
6294: G_STMT_NO := 'calculate_adjustments#30';
6295:
6296: Begin
6297: -- OE_Order_PUB.g_hdr := OE_ORDER_CACHE.g_header_rec;
6298: query_header( p_header_id => p_header_id, x_header_rec=>oe_order_pub.g_hdr);
6299: Exception when no_data_found then
6300: x_return_status := 'NOOP';
6301: IF l_debug_level > 0 THEN

Line 6944: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;

6940: )
6941: IS
6942: l_return_status_text varchar(2000);
6943: l_control_rec QP_PREQ_GRP.control_record_type;
6944: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
6945: /*
6946: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6947: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6948: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 6983: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;

6979: --For multi_currency price list
6980: l_control_rec.use_multi_currency:='Y';
6981: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
6982: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
6983: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
6984: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
6985:
6986: If l_Control_Rec.pricing_event IN ('BATCH','RETROBILL') OR
6987: nvl(instr( l_Control_Rec.pricing_event,'BATCH'),0) > 0

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

7831: l_num_changed_lines NUMBER := 0;
7832: l_process_requests BOOLEAN := FALSE;
7833: l_process_ack BOOLEAN := FALSE;
7834: l_notify_flag BOOLEAN;
7835: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
7836: l_return_status VARCHAR2(30);
7837: l_msg_count NUMBER;
7838: l_msg_data VARCHAR2(2000);
7839:

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

7950: IF l_debug_level > 0 THEN
7951: oe_debug_pub.add( 'VOPRB BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;
7952: END IF;
7953:
7954: IF (oe_order_cache.g_header_rec.booked_flag = 'Y') Then
7955: l_process_ack := TRUE;
7956: END IF;
7957:
7958: OE_Order_PVT.Process_Requests_And_Notify

Line 8210: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN

8206: --12598464 IF l_hdr_chg_count > 0 THEN
8207:
8208: BEGIN
8209:
8210: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
8211:
8212: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM) OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
8213: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
8214: THEN

Line 8212: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM) OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)

8208: BEGIN
8209:
8210: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
8211:
8212: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM) OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
8213: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
8214: THEN
8215: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
8216: END IF ;

Line 8213: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)

8209:
8210: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
8211:
8212: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM) OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
8213: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
8214: THEN
8215: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
8216: END IF ;
8217:

Line 8215: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;

8211:
8212: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM) OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
8213: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
8214: THEN
8215: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
8216: END IF ;
8217:
8218: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
8219: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then

Line 8218: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN

8214: THEN
8215: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
8216: END IF ;
8217:
8218: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
8219: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
8220: l_tax_calculation_event_code := 0;
8221: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
8222: l_tax_calculation_event_code := 1;

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

8215: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
8216: END IF ;
8217:
8218: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
8219: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
8220: l_tax_calculation_event_code := 0;
8221: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
8222: l_tax_calculation_event_code := 1;
8223: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then

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

8217:
8218: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
8219: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
8220: l_tax_calculation_event_code := 0;
8221: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
8222: l_tax_calculation_event_code := 1;
8223: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
8224: l_tax_calculation_event_code := 2;
8225: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then

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

8219: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
8220: l_tax_calculation_event_code := 0;
8221: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
8222: l_tax_calculation_event_code := 1;
8223: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
8224: l_tax_calculation_event_code := 2;
8225: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
8226: l_tax_calculation_event_code := 3;
8227: else

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

8221: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
8222: l_tax_calculation_event_code := 1;
8223: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
8224: l_tax_calculation_event_code := 2;
8225: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
8226: l_tax_calculation_event_code := 3;
8227: else
8228: l_tax_calculation_event_code := -1;
8229: end if ;