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

Line 293: x_item_rec OE_ORDER_CACHE.item_rec_type;

289:
290: Procedure Calc_Catchweight_Return_qty2
291: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
292: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type) IS
293: x_item_rec OE_ORDER_CACHE.item_rec_type;
294: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
295:
296: BEGIN
297: If l_debug_level > 0 Then

Line 309: x_item_rec := OE_Order_Cache.Load_Item (p_x_line_rec.inventory_item_id

305: IF (p_x_line_rec.inventory_item_id IS NOT NULL AND
306: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
307: (p_x_line_rec.ship_from_org_id IS NOT NULL AND
308: p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
309: x_item_rec := OE_Order_Cache.Load_Item (p_x_line_rec.inventory_item_id
310: ,p_x_line_rec.ship_from_org_id);
311: --IF x_item_rec.ont_pricing_qty_source = 1 AND -- INVCONV
312: IF x_item_rec.ont_pricing_qty_source = 'S' AND -- INVCONV
313: x_item_rec.tracking_quantity_ind = 'P' THEN -- AND -- INVCONV -

Line 400: l_item_rec OE_ORDER_CACHE.item_rec_type; -- INVCONV

396: l_error_buffer VARCHAR2(240);
397: l_x_result_out VARCHAR2(30);
398: l_turn_off_pricing VARCHAR2(30);
399: --OPM 06/SEP/00
400: l_item_rec OE_ORDER_CACHE.item_rec_type; -- INVCONV
401: -- l_OPM_shipped_quantity NUMBER(19,9); -- INVCONV
402: -- l_OPM_shipping_quantity_uom VARCHAR2(4); -- INVCONV
403: -- l_OPM_order_quantity_uom VARCHAR2(4); -- INVCONV
404: l_status VARCHAR2(1);

Line 440: l_tax_calc_rec OE_ORDER_CACHE.Tax_Calc_Rec_Type;

436: l_charges_for_included_item VARCHAR2(1):= G_CHARGES_FOR_INCLUD_ITM; /* Bug # 5036404 */
437: -- bug 1406890
438: l_current_event number := 0;
439: l_tax_calculation_event_code number := 0; --renga's change
440: l_tax_calc_rec OE_ORDER_CACHE.Tax_Calc_Rec_Type;
441: l_tax_calculation_flag varchar2(1) := NULL; --end renga's change
442: l_tax_commt_flag varchar2(1) := 'N'; --bug 2505961
443: --B2037234 EMC
444: --B2204216 EMC Assignment of IC$EPSILON profile value moved outside

Line 487: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);

483: -- Query Header Record
484: -- Performance Improvement Bug 1929163
485: -- Use cached header rec instead of querying header rec into
486: -- a local variable
487: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
488:
489: l_tax_calc_rec := oe_order_cache.get_tax_calculation_flag
490: (p_x_line_rec.line_type_id,
491: p_x_line_rec);

Line 489: l_tax_calc_rec := oe_order_cache.get_tax_calculation_flag

485: -- Use cached header rec instead of querying header rec into
486: -- a local variable
487: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
488:
489: l_tax_calc_rec := oe_order_cache.get_tax_calculation_flag
490: (p_x_line_rec.line_type_id,
491: p_x_line_rec);
492:
493: l_tax_calculation_flag := l_tax_calc_rec.tax_calculation_flag;

Line 598: IF NVL(OE_Order_Cache.g_header_rec.payment_type_code,'NULL') <> 'CREDIT_CARD'

594: Log delayed request for Verify Payment if the payment type
595: is not CREDIT CARD and the Order line is Booked */
596:
597: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
598: IF NVL(OE_Order_Cache.g_header_rec.payment_type_code,'NULL') <> 'CREDIT_CARD'
599: AND p_x_line_rec.booked_flag ='Y'
600: THEN
601: -- Log Delayed Request for Verify Payment
602: if l_debug_level > 0 then

Line 735: OE_Order_Cache.Enforce_List_price(p_line_type_id => p_x_line_rec.Line_Type_id

731:
732: If p_x_line_rec.calculate_price_flag = 'Y' then
733: Begin
734:
735: OE_Order_Cache.Enforce_List_price(p_line_type_id => p_x_line_rec.Line_Type_id
736: , p_header_id => p_x_line_rec.header_id);
737:
738: exception when no_data_found then
739: OE_Order_Cache.g_Enforce_list_price_rec.enforce_line_prices_flag := 'N';

Line 739: OE_Order_Cache.g_Enforce_list_price_rec.enforce_line_prices_flag := 'N';

735: OE_Order_Cache.Enforce_List_price(p_line_type_id => p_x_line_rec.Line_Type_id
736: , p_header_id => p_x_line_rec.header_id);
737:
738: exception when no_data_found then
739: OE_Order_Cache.g_Enforce_list_price_rec.enforce_line_prices_flag := 'N';
740: end ;
741:
742: If OE_Order_Cache.g_Enforce_list_price_rec.enforce_line_prices_flag = 'Y' Then
743: p_x_line_rec.calculate_price_flag := 'P';

Line 742: If OE_Order_Cache.g_Enforce_list_price_rec.enforce_line_prices_flag = 'Y' Then

738: exception when no_data_found then
739: OE_Order_Cache.g_Enforce_list_price_rec.enforce_line_prices_flag := 'N';
740: end ;
741:
742: If OE_Order_Cache.g_Enforce_list_price_rec.enforce_line_prices_flag = 'Y' Then
743: p_x_line_rec.calculate_price_flag := 'P';
744: End If;
745:
746: IF p_x_line_rec.open_flag = 'N' or

Line 1025: IF NVL(OE_Order_Cache.g_header_rec.payment_type_code,'NULL') <> 'CREDIT_CARD'

1021: END IF;--Payment type code check
1022: --R12 CC Encryption
1023: /* Additional Task : Log a delayed request for Verify payment
1024: (Credit Checking) when the bill to site changes for a booked line */
1025: IF NVL(OE_Order_Cache.g_header_rec.payment_type_code,'NULL') <> 'CREDIT_CARD'
1026: AND p_x_line_rec.booked_flag ='Y'
1027: THEN
1028: if l_debug_level > 0 then
1029: oe_debug_pub.ADD('log verify payment delayed request for change in invoice to site');

Line 1592: l_item_rec := OE_Order_Cache.Load_Item (p_x_line_rec.inventory_item_id

1588: IF (p_x_line_rec.inventory_item_id IS NOT NULL AND
1589: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
1590: (p_x_line_rec.ship_from_org_id IS NOT NULL AND
1591: p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
1592: l_item_rec := OE_Order_Cache.Load_Item (p_x_line_rec.inventory_item_id
1593: ,p_x_line_rec.ship_from_org_id);
1594: -- IF l_item_rec.ont_pricing_qty_source = 1 AND
1595: IF l_item_rec.ont_pricing_qty_source = 'S' AND -- INVCONV
1596: l_item_rec.tracking_quantity_ind = 'P' and

Line 1815: IF OE_Order_Cache.g_header_rec.payment_type_code = 'CREDIT_CARD' THEN

1811: -- is not CREDIT CARD and the Line is Booked.
1812: -- If the payment type is CREDIT CARD then the delayed req should be
1813: -- logged only if the quantity has increased.
1814:
1815: IF OE_Order_Cache.g_header_rec.payment_type_code = 'CREDIT_CARD' THEN
1816: IF p_x_line_rec.ordered_quantity > p_old_line_rec.ordered_quantity
1817: THEN
1818: -- Log request here if commitment id is null
1819: if p_x_line_rec.commitment_id is null then

Line 2008: ELSIF NVL(OE_Order_Cache.g_header_rec.payment_type_code, 'NULL') <> 'CREDIT_CARD'

2004: end if;
2005: l_verify_payment_flag := 'Y';
2006:
2007:
2008: ELSIF NVL(OE_Order_Cache.g_header_rec.payment_type_code, 'NULL') <> 'CREDIT_CARD'
2009: THEN
2010:
2011: if l_debug_level > 0 then
2012: oe_debug_pub.ADD('logging delayed request for verify payment as payment term is changed');

Line 2229: IF NVL(OE_Order_Cache.g_header_rec.payment_type_code, 'NULL') <> 'CREDIT_CARD' AND

2225: IF (p_x_line_rec.source_type_code <> OE_GLOBALS.G_SOURCE_EXTERNAL) THEN
2226:
2227: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2228: THEN
2229: IF NVL(OE_Order_Cache.g_header_rec.payment_type_code, 'NULL') <> 'CREDIT_CARD' AND
2230: p_x_line_rec.booked_flag ='Y' AND
2231: (to_date(p_x_line_rec.schedule_ship_date, 'DD/MM/YYYY') <>
2232: to_date(p_x_line_rec.request_date, 'DD/MM/YYYY'))
2233: THEN

Line 3263: OE_Order_Cache.g_header_rec.payment_type_code = 'CREDIT_CARD' THEN

3259: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3260: -- Log Verify Payment only if the Tax Value has
3261: -- Increased AND Payment Type Code is Credit Card.
3262: IF p_x_line_rec.tax_value > p_old_line_rec.tax_value AND
3263: OE_Order_Cache.g_header_rec.payment_type_code = 'CREDIT_CARD' THEN
3264: -- Set flag to log Verify Payment Delayed Request
3265: if l_debug_level > 0 then
3266: oe_debug_pub.ADD('Log Verify Payment delayed request in Tax Value');
3267: end if;

Line 3330: IF OE_Order_Cache.g_header_rec.payment_type_code = 'CREDIT_CARD' THEN

3326: -- Additional task : Log Verify Payment always when the payment Type
3327: -- code is not CREDIT CARD. For CREDIT CARD, log this request only if
3328: -- the Unit Selling Price has increased.
3329:
3330: IF OE_Order_Cache.g_header_rec.payment_type_code = 'CREDIT_CARD' THEN
3331: IF p_x_line_rec.unit_selling_price > p_old_line_rec.unit_selling_price
3332: then
3333: -- Log request here if commitment id is null
3334: IF p_x_line_rec.commitment_id is null THEN

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

4785: END IF;
4786:
4787: BEGIN
4788:
4789: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
4790:
4791: --use cache instead of SQL to fix bug 4200055
4792: if (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
4793: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)

Line 4792: if (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)

4788:
4789: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
4790:
4791: --use cache instead of SQL to fix bug 4200055
4792: if (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
4793: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
4794: OR (OE_Order_Cache.g_order_type_rec.order_type_id <>
4795: OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4796: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id)

Line 4793: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)

4789: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
4790:
4791: --use cache instead of SQL to fix bug 4200055
4792: if (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
4793: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
4794: OR (OE_Order_Cache.g_order_type_rec.order_type_id <>
4795: OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4796: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id)
4797: ;

Line 4794: OR (OE_Order_Cache.g_order_type_rec.order_type_id <>

4790:
4791: --use cache instead of SQL to fix bug 4200055
4792: if (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
4793: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
4794: OR (OE_Order_Cache.g_order_type_rec.order_type_id <>
4795: OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4796: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id)
4797: ;
4798: END IF ;

Line 4795: OE_Order_Cache.g_header_rec.Order_Type_id) THEN

4791: --use cache instead of SQL to fix bug 4200055
4792: if (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
4793: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
4794: OR (OE_Order_Cache.g_order_type_rec.order_type_id <>
4795: OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4796: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id)
4797: ;
4798: END IF ;
4799: IF (OE_Order_Cache.g_order_type_rec.order_type_id =

Line 4796: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id)

4792: if (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
4793: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
4794: OR (OE_Order_Cache.g_order_type_rec.order_type_id <>
4795: OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4796: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id)
4797: ;
4798: END IF ;
4799: IF (OE_Order_Cache.g_order_type_rec.order_type_id =
4800: OE_Order_Cache.g_header_rec.Order_Type_id) THEN

Line 4799: IF (OE_Order_Cache.g_order_type_rec.order_type_id =

4795: OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4796: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id)
4797: ;
4798: END IF ;
4799: IF (OE_Order_Cache.g_order_type_rec.order_type_id =
4800: OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4801: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =
4802: 'ENTERING') then
4803: l_tax_calculation_event_code := 0;

Line 4800: OE_Order_Cache.g_header_rec.Order_Type_id) THEN

4796: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id)
4797: ;
4798: END IF ;
4799: IF (OE_Order_Cache.g_order_type_rec.order_type_id =
4800: OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4801: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =
4802: 'ENTERING') then
4803: l_tax_calculation_event_code := 0;
4804: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =

Line 4801: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =

4797: ;
4798: END IF ;
4799: IF (OE_Order_Cache.g_order_type_rec.order_type_id =
4800: OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4801: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =
4802: 'ENTERING') then
4803: l_tax_calculation_event_code := 0;
4804: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =
4805: 'BOOKING') then

Line 4804: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =

4800: OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4801: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =
4802: 'ENTERING') then
4803: l_tax_calculation_event_code := 0;
4804: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =
4805: 'BOOKING') then
4806: l_tax_calculation_event_code := 1;
4807: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =
4808: 'SHIPPING') then

Line 4807: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =

4803: l_tax_calculation_event_code := 0;
4804: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =
4805: 'BOOKING') then
4806: l_tax_calculation_event_code := 1;
4807: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =
4808: 'SHIPPING') then
4809: l_tax_calculation_event_code := 2;
4810: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =
4811: 'INVOICING') then

Line 4810: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =

4806: l_tax_calculation_event_code := 1;
4807: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =
4808: 'SHIPPING') then
4809: l_tax_calculation_event_code := 2;
4810: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code =
4811: 'INVOICING') then
4812: l_tax_calculation_event_code := 3;
4813: else
4814: l_tax_calculation_event_code := -1;

Line 4827: where transaction_type_id = OE_Order_Cache.g_header_rec.order_type_id;

4823: 'INVOICING', 3,
4824: -1)
4825: into l_tax_calculation_event_code
4826: from oe_transaction_types_all
4827: where transaction_type_id = OE_Order_Cache.g_header_rec.order_type_id;
4828: */
4829: --end bug 4200055
4830:
4831: END IF;

Line 4971: IF (NVL(OE_Order_Cache.g_header_rec.payment_type_code, 'NULL') <> 'CREDIT_CARD'

4967: -- new config item lines being added to an order.
4968: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
4969: p_x_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG AND
4970: p_x_line_rec.booked_flag = 'Y' THEN
4971: IF (NVL(OE_Order_Cache.g_header_rec.payment_type_code, 'NULL') <> 'CREDIT_CARD'
4972: AND OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'N')
4973: OR OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'Y'
4974: THEN
4975: if l_debug_level > 0 then

Line 14490: --OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);

14486:
14487: -- bug 2411783
14488: -- for a newly created order, since the line is not posted,
14489: -- in Order import, there will be no Header record.
14490: --OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
14491: --l_sold_to_org_id := OE_Order_Cache.g_header_rec.sold_to_org_id;
14492: null;
14493:
14494: ELSIF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

Line 14491: --l_sold_to_org_id := OE_Order_Cache.g_header_rec.sold_to_org_id;

14487: -- bug 2411783
14488: -- for a newly created order, since the line is not posted,
14489: -- in Order import, there will be no Header record.
14490: --OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
14491: --l_sold_to_org_id := OE_Order_Cache.g_header_rec.sold_to_org_id;
14492: null;
14493:
14494: ELSIF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
14495:

Line 16758: OE_Order_Cache.Clear_Top_Model_Line(p_key => p_x_line_rec.line_id);

16754: if l_debug_level > 0 then
16755: oe_debug_pub.add('clear the cached top model record', 1);
16756: oe_debug_pub.add('model line: '|| p_x_line_rec.line_id, 1);
16757: end if;
16758: OE_Order_Cache.Clear_Top_Model_Line(p_key => p_x_line_rec.line_id);
16759: END IF;
16760:
16761: -- Changes for Late Demand Penalty Factor
16762: if l_debug_level > 0 then

Line 18458: ,x_item_rec OUT NOCOPY OE_ORDER_CACHE.item_rec_type

18454: FUNCTION dual_uom_control -- INVCONV renamed from process_characteristics
18455: (
18456: p_inventory_item_id IN NUMBER
18457: ,p_ship_from_org_id IN NUMBER
18458: ,x_item_rec OUT NOCOPY OE_ORDER_CACHE.item_rec_type
18459: )
18460: RETURN BOOLEAN
18461: IS
18462:

Line 18479: OE_Order_Cache.Load_Item (p_inventory_item_id

18475: p_inventory_item_id <> FND_API.G_MISS_NUM) AND
18476: (p_ship_from_org_id IS NOT NULL AND
18477: p_ship_from_org_id <> FND_API.G_MISS_NUM) THEN
18478: x_item_rec :=
18479: OE_Order_Cache.Load_Item (p_inventory_item_id
18480: ,p_ship_from_org_id);
18481: -- IF x_item_rec.process_warehouse_flag = 'Y' INVCONV
18482: -- AND INVCONV
18483: oe_debug_pub.add('in function Dual_uom_control - tracking_quantity_ind = ' || x_item_rec.tracking_quantity_ind);

Line 18529: l_item_rec OE_ORDER_CACHE.item_rec_type;

18525: -- l_APPS_UOM2 VARCHAR2(3) := NULL; INVCONV
18526: l_status VARCHAR2(1);
18527: l_msg_count NUMBER;
18528: l_msg_data VARCHAR2(2000);
18529: l_item_rec OE_ORDER_CACHE.item_rec_type;
18530:
18531: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18532:
18533: BEGIN

Line 18598: l_item_rec OE_ORDER_CACHE.item_rec_type;

18594: RETURN VARCHAR2
18595: IS
18596: l_grade_ctl NUMBER(5):= NULL;
18597: l_preferred_grade VARCHAR2(4) := NULL;
18598: l_item_rec OE_ORDER_CACHE.item_rec_type;
18599:
18600: CURSOR C_GRADE1 IS
18601: SELECT alot.prefqc_grade
18602: FROM op_alot_prm alot, ic_item_mst item, op_cust_mst cust

Line 18702: l_item_rec OE_ORDER_CACHE.item_rec_type;

18698: )
18699: IS
18700:
18701: l_converted_qty NUMBER(19,9); -- OPM 25/AUG/00
18702: l_item_rec OE_ORDER_CACHE.item_rec_type;
18703: -- l_OPM_UOM VARCHAR2(4); INVCONV
18704: l_return NUMBER;
18705: l_status VARCHAR2(1);
18706: l_msg_count NUMBER;

Line 19245: l_item_rec OE_ORDER_CACHE.item_rec_type;

19241: P_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type
19242: ) RETURN NUMBER
19243: IS
19244:
19245: l_item_rec OE_ORDER_CACHE.item_rec_type;
19246: -- OPM 25/AUG/00 - add precision of 19,9
19247: l_ordered_quantity2 NUMBER(19,9) := p_line_rec.ordered_quantity2;
19248: l_OPM_UOM VARCHAR2(4);
19249: l_return NUMBER;

Line 21312: l_item_rec OE_ORDER_CACHE.item_rec_type;

21308:
21309: IS
21310:
21311: l_converted_qty NUMBER(19,9);
21312: l_item_rec OE_ORDER_CACHE.item_rec_type;
21313: --l_OPM_UOM VARCHAR2(4); -- INVCONV
21314: l_error_message VARCHAR2(1000); -- INVCONV
21315: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level; -- INVCONV
21316: l_return NUMBER;

Line 21836: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);

21832:
21833: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_DELETE
21834: THEN
21835:
21836: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
21837:
21838: -- For DELETES, log process releases request with new values as
21839: -- null or 0 so that quantity/amount cumulations see negative
21840: -- changes thus resulting in decrementing final released qty/amount

Line 21865: OE_Order_Cache.g_header_rec.transactional_curr_code

21861: -- Other parameters
21862: ,p_param8 => p_x_line_rec.fulfilled_flag
21863: ,p_param9 => p_x_line_rec.line_set_id
21864: ,p_request_unique_key1 =>
21865: OE_Order_Cache.g_header_rec.transactional_curr_code
21866:
21867: ,x_return_status => l_return_status
21868: );
21869:

Line 21883: OE_Order_Cache.g_header_rec.transactional_curr_code

21879: ,p_request_type => OE_GLOBALS.G_VALIDATE_RELEASE_SHIPMENTS
21880: ,p_request_unique_key1 => p_x_line_rec.blanket_number
21881: ,p_request_unique_key2 => p_x_line_rec.blanket_line_number
21882: ,p_param1 =>
21883: OE_Order_Cache.g_header_rec.transactional_curr_code
21884: ,x_return_status => l_return_status
21885: );
21886: END IF;
21887:

Line 21900: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);

21896: if l_debug_level > 0 then
21897: oe_debug_pub.add('log blanket requests for complete neg');
21898: end if;
21899:
21900: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
21901:
21902: -- Qty/amount against the blanket should be incremented by
21903: -- total qty/amount of this line, as complete negotiation is
21904: -- running consumption logic for this order first time.

Line 21930: OE_Order_Cache.g_header_rec.transactional_curr_code

21926: -- Other parameters
21927: ,p_param8 => p_x_line_rec.fulfilled_flag
21928: ,p_param9 => p_x_line_rec.line_set_id
21929: ,p_request_unique_key1 =>
21930: OE_Order_Cache.g_header_rec.transactional_curr_code
21931: ,x_return_status => l_return_status
21932: );
21933:
21934: -- If this is a shipment line, log request against the line set

Line 21949: OE_Order_Cache.g_header_rec.transactional_curr_code

21945: ,p_request_type => OE_GLOBALS.G_VALIDATE_RELEASE_SHIPMENTS
21946: ,p_request_unique_key1 => p_x_line_rec.blanket_number
21947: ,p_request_unique_key2 => p_x_line_rec.blanket_line_number
21948: ,p_param1 =>
21949: OE_Order_Cache.g_header_rec.transactional_curr_code
21950: ,x_return_status => l_return_status
21951: );
21952: END IF;
21953:

Line 21972: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);

21968:
21969: -- For creates and updates, log request if any fields affecting
21970: -- quantities/amounts are changed
21971:
21972: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
21973:
21974: OE_Delayed_Requests_Pvt.Log_Request
21975: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
21976: ,p_entity_id => p_x_line_rec.line_id

Line 21998: OE_Order_Cache.g_header_rec.transactional_curr_code

21994: -- Other parameters
21995: ,p_param8 => p_x_line_rec.fulfilled_flag
21996: ,p_param9 => p_x_line_rec.line_set_id
21997: ,p_request_unique_key1 =>
21998: OE_Order_Cache.g_header_rec.transactional_curr_code
21999: ,x_return_status => l_return_status
22000: );
22001:
22002: -- If this is a shipment line, log request against the line set

Line 22017: OE_Order_Cache.g_header_rec.transactional_curr_code

22013: ,p_request_type => OE_GLOBALS.G_VALIDATE_RELEASE_SHIPMENTS
22014: ,p_request_unique_key1 => p_x_line_rec.blanket_number
22015: ,p_request_unique_key2 => p_x_line_rec.blanket_line_number
22016: ,p_param1 =>
22017: OE_Order_Cache.g_header_rec.transactional_curr_code
22018: ,x_return_status => l_return_status
22019: );
22020: END IF;
22021:

Line 22040: OE_Order_Cache.g_header_rec.transactional_curr_code

22036: ,p_request_type => OE_GLOBALS.G_VALIDATE_RELEASE_SHIPMENTS
22037: ,p_request_unique_key1 => p_old_line_rec.blanket_number
22038: ,p_request_unique_key2 => p_old_line_rec.blanket_line_number
22039: ,p_param1 =>
22040: OE_Order_Cache.g_header_rec.transactional_curr_code
22041: ,x_return_status => l_return_status
22042: );
22043: END IF;
22044: