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

Line 286: l_item_rec OE_ORDER_CACHE.item_rec_type;

282: RETURN NUMBER IS
283: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
284: l_unit_cost NUMBER;
285: l_cost_group_id NUMBER;
286: l_item_rec OE_ORDER_CACHE.item_rec_type;
287: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
288: l_order_currency VARCHAR2(30);
289: l_set_of_books_id VARCHAR2(30);
290: l_sob_currency VARCHAR2(30);

Line 287: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;

283: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
284: l_unit_cost NUMBER;
285: l_cost_group_id NUMBER;
286: l_item_rec OE_ORDER_CACHE.item_rec_type;
287: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
288: l_order_currency VARCHAR2(30);
289: l_set_of_books_id VARCHAR2(30);
290: l_sob_currency VARCHAR2(30);
291: l_old_unit_cost NUMBER;

Line 583: l_item_rec := OE_Order_Cache.Load_Item(l_line_rec.inventory_item_id,

579: END IF;
580:
581: -- INVCONV
582: If l_item_rec.primary_uom_code is null or l_item_rec.primary_uom_code = fnd_api.g_miss_char then
583: l_item_rec := OE_Order_Cache.Load_Item(l_line_rec.inventory_item_id,
584: G_SHIP_FROM_ORG_ID);
585: End if;
586:
587: -- IF Process org call OPM API to get cost

Line 641: l_item_rec := OE_Order_Cache.Load_Item(l_line_rec.inventory_item_id,

637:
638: debug(' unit cost before convert:'||l_unit_cost);
639: debug('primary_uom_code : '||l_item_rec.primary_uom_code);
640: If l_item_rec.primary_uom_code is null or l_item_rec.primary_uom_code = fnd_api.g_miss_char then
641: l_item_rec := OE_Order_Cache.Load_Item(l_line_rec.inventory_item_id,
642: G_SHIP_FROM_ORG_ID);
643: End If;
644: debug('Order_quantity_uom : '||l_Line_rec.Order_quantity_uom);
645: debug('Inventory_item_id : '||l_Line_rec.Inventory_item_id);

Line 662: debug(' Order ship_from_org_id:'||OE_ORDER_CACHE.g_header_rec.ship_from_org_id);

658: END IF;
659:
660:
661: debug(' Line ship_from_org_id:'||l_line_rec.ship_from_org_id);
662: debug(' Order ship_from_org_id:'||OE_ORDER_CACHE.g_header_rec.ship_from_org_id);
663:
664: --Pricing and Availbility call
665: IF l_PA_CALL THEN
666: SELECT NVL(default_cost_group_id,-1)

Line 729: -- WHERE ORGANIZATION_ID = nvl(OE_ORDER_CACHE.g_header_rec.ship_from_org_id,G_SHIP_FROM_ORG_ID);

725: BEGIN
726: SELECT SET_OF_BOOKS_ID
727: INTO l_set_of_books_id
728: FROM ORG_ORGANIZATION_DEFINITIONS
729: -- WHERE ORGANIZATION_ID = nvl(OE_ORDER_CACHE.g_header_rec.ship_from_org_id,G_SHIP_FROM_ORG_ID);
730: -- bug 6518329/6709490
731: WHERE ORGANIZATION_ID = nvl(G_SHIP_FROM_ORG_ID,OE_ORDER_CACHE.g_header_rec.ship_from_org_id);
732:
733: EXCEPTION

Line 731: WHERE ORGANIZATION_ID = nvl(G_SHIP_FROM_ORG_ID,OE_ORDER_CACHE.g_header_rec.ship_from_org_id);

727: INTO l_set_of_books_id
728: FROM ORG_ORGANIZATION_DEFINITIONS
729: -- WHERE ORGANIZATION_ID = nvl(OE_ORDER_CACHE.g_header_rec.ship_from_org_id,G_SHIP_FROM_ORG_ID);
730: -- bug 6518329/6709490
731: WHERE ORGANIZATION_ID = nvl(G_SHIP_FROM_ORG_ID,OE_ORDER_CACHE.g_header_rec.ship_from_org_id);
732:
733: EXCEPTION
734: WHEN OTHERS THEN
735: --need to handle... to be added....

Line 756: IF OE_ORDER_CACHE.g_header_rec.header_id IS NULL OR

752:
753: IF l_PA_CALL THEN
754: l_order_currency := p_order_currency;
755: ELSE
756: IF OE_ORDER_CACHE.g_header_rec.header_id IS NULL OR
757: OE_ORDER_CACHE.g_header_rec.header_id <> l_line_rec.header_id
758: THEN
759: OE_Header_Util.query_row(p_header_id => l_line_rec.header_id
760: , x_header_rec => OE_ORDER_CACHE.g_header_rec);

Line 757: OE_ORDER_CACHE.g_header_rec.header_id <> l_line_rec.header_id

753: IF l_PA_CALL THEN
754: l_order_currency := p_order_currency;
755: ELSE
756: IF OE_ORDER_CACHE.g_header_rec.header_id IS NULL OR
757: OE_ORDER_CACHE.g_header_rec.header_id <> l_line_rec.header_id
758: THEN
759: OE_Header_Util.query_row(p_header_id => l_line_rec.header_id
760: , x_header_rec => OE_ORDER_CACHE.g_header_rec);
761: END IF;

Line 760: , x_header_rec => OE_ORDER_CACHE.g_header_rec);

756: IF OE_ORDER_CACHE.g_header_rec.header_id IS NULL OR
757: OE_ORDER_CACHE.g_header_rec.header_id <> l_line_rec.header_id
758: THEN
759: OE_Header_Util.query_row(p_header_id => l_line_rec.header_id
760: , x_header_rec => OE_ORDER_CACHE.g_header_rec);
761: END IF;
762: l_order_currency := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;
763: END IF;
764:

Line 762: l_order_currency := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;

758: THEN
759: OE_Header_Util.query_row(p_header_id => l_line_rec.header_id
760: , x_header_rec => OE_ORDER_CACHE.g_header_rec);
761: END IF;
762: l_order_currency := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;
763: END IF;
764:
765: DEBUG(' Order currency:'||l_order_currency);
766: DEBUG(' Cost''s sob currency:'||g_sob_currency);

Line 774: IF OE_ORDER_CACHE.g_header_rec.conversion_type_code = 'User'

770: IF l_order_currency <> G_SOB_CURRENCY THEN
771: BEGIN
772:
773: IF NOT l_PA_CALL THEN
774: IF OE_ORDER_CACHE.g_header_rec.conversion_type_code = 'User'
775: AND OE_ORDER_CACHE.g_header_rec.conversion_rate IS NULL
776: THEN
777: DEBUG(' USER conversion type without rate, unable to perform cost conversion');
778: RETURN NULL;

Line 775: AND OE_ORDER_CACHE.g_header_rec.conversion_rate IS NULL

771: BEGIN
772:
773: IF NOT l_PA_CALL THEN
774: IF OE_ORDER_CACHE.g_header_rec.conversion_type_code = 'User'
775: AND OE_ORDER_CACHE.g_header_rec.conversion_rate IS NULL
776: THEN
777: DEBUG(' USER conversion type without rate, unable to perform cost conversion');
778: RETURN NULL;
779: END IF;

Line 781: IF OE_ORDER_CACHE.g_header_rec.conversion_type_code IS NULL THEN

777: DEBUG(' USER conversion type without rate, unable to perform cost conversion');
778: RETURN NULL;
779: END IF;
780:
781: IF OE_ORDER_CACHE.g_header_rec.conversion_type_code IS NULL THEN
782: DEBUG(' Conversion type not entered in sales order header,unable to perfor cost conversion');
783: RETURN NULL;
784: END IF;
785:

Line 800: l_conversion_type_code := OE_ORDER_CACHE.g_header_rec.conversion_type_code;

796:
797: END IF;
798:
799: IF NOT l_PA_CALL THEN
800: l_conversion_type_code := OE_ORDER_CACHE.g_header_rec.conversion_type_code;
801: l_conversion_rate := OE_ORDER_CACHE.g_header_rec.conversion_rate;
802: ELSE
803: l_conversion_type_code := p_conversion_type_code;
804: l_conversion_rate := p_conversion_rate;

Line 801: l_conversion_rate := OE_ORDER_CACHE.g_header_rec.conversion_rate;

797: END IF;
798:
799: IF NOT l_PA_CALL THEN
800: l_conversion_type_code := OE_ORDER_CACHE.g_header_rec.conversion_type_code;
801: l_conversion_rate := OE_ORDER_CACHE.g_header_rec.conversion_rate;
802: ELSE
803: l_conversion_type_code := p_conversion_type_code;
804: l_conversion_rate := p_conversion_rate;
805: END IF;