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

Line 385: OE_Order_Cache.Load_Order_Header(l_header_id);

381: -- Performance Bug 1929163:
382: -- Use cached header rec to get header values instead
383: -- of a query to select the values.
384:
385: OE_Order_Cache.Load_Order_Header(l_header_id);
386:
387: if OE_Order_Cache.g_header_rec.order_category_code = 'RETURN' THEN
388: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
389: else

Line 387: if OE_Order_Cache.g_header_rec.order_category_code = 'RETURN' THEN

383: -- of a query to select the values.
384:
385: OE_Order_Cache.Load_Order_Header(l_header_id);
386:
387: if OE_Order_Cache.g_header_rec.order_category_code = 'RETURN' THEN
388: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
389: else
390: fnd_message.set_name('ONT', 'OE_WF_LINE');
391: end if;

Line 394: to_char(OE_Order_Cache.g_header_rec.order_number));

390: fnd_message.set_name('ONT', 'OE_WF_LINE');
391: end if;
392:
393: fnd_message.set_token('ORDER_NUMBER',
394: to_char(OE_Order_Cache.g_header_rec.order_number));
395: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number));
396: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number));
397: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number));
398: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number));

Line 939: l_item_rec OE_ORDER_CACHE.item_rec_type;

935: FUNCTION Get_Wf_Item_type
936: ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type
937: ) RETURN VARCHAR2
938: IS
939: l_item_rec OE_ORDER_CACHE.item_rec_type;
940: --
941: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
942: --
943: BEGIN

Line 945: OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id

941: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
942: --
943: BEGIN
944: l_item_rec :=
945: OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id
946: ,p_line_rec.ship_from_org_id);
947:
948: IF l_debug_level > 0 THEN
949: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE ) ;

Line 1491: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;

1487: BEGIN
1488: IF l_debug_level > 0 THEN
1489: oe_debug_pub.add('ENTERING UPDATE_FLOW_STATUS_CODE' , 5 ) ;
1490: oe_debug_pub.add('UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION) ;
1491: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
1492: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
1493: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
1494: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
1495: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;

Line 1590: OE_Order_Cache.Set_Order_Header(l_header_rec);

1586:
1587: -- aksingh performance
1588: -- As the update is on headers table, it is time to update
1589: -- cache also!
1590: OE_Order_Cache.Set_Order_Header(l_header_rec);
1591:
1592: -- Bug 1755817: clear the cached constraint results for header entity
1593: -- when order header is updated.
1594: OE_PC_Constraints_Admin_Pvt.Clear_Cached_Results

Line 2017: OE_Order_Cache.Set_Order_Header(l_header_rec);

2013:
2014: -- aksingh performance
2015: -- As the update is on headers table, it is time to update
2016: -- cache also!
2017: OE_Order_Cache.Set_Order_Header(l_header_rec);
2018:
2019: -- Bug 1755817: clear the cached constraint results for header entity
2020: -- when order header is updated.
2021: OE_PC_Constraints_Admin_Pvt.Clear_Cached_Results

Line 2089: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;

2085:
2086: IF l_debug_level > 0 THEN
2087: oe_debug_pub.add('ENTERING UPDATE_FLOW_STATUS_CODE' , 5 ) ;
2088: oe_debug_pub.add('UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION) ;
2089: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
2090: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
2091: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
2092: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
2093: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;

Line 2437: OE_Order_Cache.Set_Order_Header(l_header_rec);

2433:
2434: -- aksingh performance
2435: -- As the update is on headers table, it is time to update
2436: -- cache also!
2437: OE_Order_Cache.Set_Order_Header(l_header_rec);
2438:
2439: -- Bug 1755817: clear the cached constraint results for header entity
2440: -- when order header is updated.
2441: OE_PC_Constraints_Admin_Pvt.Clear_Cached_Results