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

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

365: --l_line_index pls_integer := nvl(px_req_line_tbl.count,0);
366: l_uom_rate NUMBER;
367: v_discounting_privilege VARCHAR2(30);
368: l_item_type_code VARCHAR2(30);
369: l_item_rec OE_ORDER_CACHE.item_rec_type; --OPM 2434270
370: l_dummy VARCHAR2(30);
371: x_return_status VARCHAR2(30);
372: x_msg_count NUMBER;
373: x_msg_data VARCHAR2(2000);

Line 377: x_item_rec OE_Order_Cache.Item_Rec_Type;

373: x_msg_data VARCHAR2(2000);
374: x_secondary_quantity NUMBER;
375: x_secondary_uom_code VARCHAR2(3);
376: l_shipped_quantity2 NUMBER;
377: x_item_rec OE_Order_Cache.Item_Rec_Type;
378: l_UOM_QUANTITY NUMBER;
379: l_Calculate_Price_Flag varchar2(1);
380: --
381: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1670: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;

1666: )
1667: IS
1668: l_return_status_text varchar(2000);
1669: l_control_rec QP_PREQ_GRP.control_record_type;
1670: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
1671: --
1672: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1673: --
1674: BEGIN

Line 1691: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;

1687: --For multi_currency price list
1688: l_control_rec.use_multi_currency:='Y';
1689: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
1690: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
1691: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
1692: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
1693:
1694: -- added for freight rating.
1695: l_control_rec.get_freight_flag := 'N';

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

1901: --TaxER start
1902: IF (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y') THEN
1903: BEGIN
1904:
1905: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
1906:
1907: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
1908: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
1909: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)

Line 1907: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)

1903: BEGIN
1904:
1905: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
1906:
1907: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
1908: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
1909: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
1910: THEN
1911: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;

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

1904:
1905: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
1906:
1907: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
1908: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
1909: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
1910: THEN
1911: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
1912: END IF ;

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

1905: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
1906:
1907: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
1908: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
1909: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
1910: THEN
1911: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
1912: END IF ;
1913:

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

1907: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
1908: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
1909: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
1910: THEN
1911: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
1912: END IF ;
1913:
1914: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
1915: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then

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

1910: THEN
1911: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
1912: END IF ;
1913:
1914: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
1915: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
1916: l_tax_calculation_event_code := 0;
1917: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
1918: l_tax_calculation_event_code := 1;

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

1911: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
1912: END IF ;
1913:
1914: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
1915: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
1916: l_tax_calculation_event_code := 0;
1917: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
1918: l_tax_calculation_event_code := 1;
1919: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then

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

1913:
1914: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
1915: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
1916: l_tax_calculation_event_code := 0;
1917: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
1918: l_tax_calculation_event_code := 1;
1919: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
1920: l_tax_calculation_event_code := 2;
1921: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then

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

1915: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
1916: l_tax_calculation_event_code := 0;
1917: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
1918: l_tax_calculation_event_code := 1;
1919: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
1920: l_tax_calculation_event_code := 2;
1921: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
1922: l_tax_calculation_event_code := 3;
1923: else

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

1917: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
1918: l_tax_calculation_event_code := 1;
1919: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
1920: l_tax_calculation_event_code := 2;
1921: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
1922: l_tax_calculation_event_code := 3;
1923: else
1924: l_tax_calculation_event_code := -1;
1925: end if ;