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

Line 8299: -- l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM -- INVCONV Not needed now because of OPM inventory convergence

8295: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8296: --
8297: /*OPM BEGIN Bug 2794760
8298: ====================*/
8299: -- l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM -- INVCONV Not needed now because of OPM inventory convergence
8300: /*OPM End Bug 2794760
8301: ====================*/
8302: BEGIN
8303: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9123: OE_Order_Cache.Load_Order_Header(p_header_id);

9119: ELSE
9120: IF l_debug_level > 0 THEN
9121: oe_debug_pub.add( 'LOAD HEADER : ' || P_HEADER_ID , 2 ) ;
9122: END IF;
9123: OE_Order_Cache.Load_Order_Header(p_header_id);
9124: OE_ORDER_CACHE.Load_order_type(OE_ORDER_CACHE.g_header_rec.order_type_id);
9125: IF l_debug_level > 0 THEN
9126: oe_debug_pub.add( 'ORDER TYPE ID : ' || OE_ORDER_CACHE.G_ORDER_TYPE_REC.ORDER_TYPE_ID , 2 ) ;
9127: END IF;

Line 9124: OE_ORDER_CACHE.Load_order_type(OE_ORDER_CACHE.g_header_rec.order_type_id);

9120: IF l_debug_level > 0 THEN
9121: oe_debug_pub.add( 'LOAD HEADER : ' || P_HEADER_ID , 2 ) ;
9122: END IF;
9123: OE_Order_Cache.Load_Order_Header(p_header_id);
9124: OE_ORDER_CACHE.Load_order_type(OE_ORDER_CACHE.g_header_rec.order_type_id);
9125: IF l_debug_level > 0 THEN
9126: oe_debug_pub.add( 'ORDER TYPE ID : ' || OE_ORDER_CACHE.G_ORDER_TYPE_REC.ORDER_TYPE_ID , 2 ) ;
9127: END IF;
9128: IF nvl(OE_ORDER_CACHE.g_order_type_rec.auto_scheduling_flag,'N') = 'Y' THEN

Line 9126: oe_debug_pub.add( 'ORDER TYPE ID : ' || OE_ORDER_CACHE.G_ORDER_TYPE_REC.ORDER_TYPE_ID , 2 ) ;

9122: END IF;
9123: OE_Order_Cache.Load_Order_Header(p_header_id);
9124: OE_ORDER_CACHE.Load_order_type(OE_ORDER_CACHE.g_header_rec.order_type_id);
9125: IF l_debug_level > 0 THEN
9126: oe_debug_pub.add( 'ORDER TYPE ID : ' || OE_ORDER_CACHE.G_ORDER_TYPE_REC.ORDER_TYPE_ID , 2 ) ;
9127: END IF;
9128: IF nvl(OE_ORDER_CACHE.g_order_type_rec.auto_scheduling_flag,'N') = 'Y' THEN
9129: Set_Auto_Sch_Flag('Y');
9130: ELSE

Line 9128: IF nvl(OE_ORDER_CACHE.g_order_type_rec.auto_scheduling_flag,'N') = 'Y' THEN

9124: OE_ORDER_CACHE.Load_order_type(OE_ORDER_CACHE.g_header_rec.order_type_id);
9125: IF l_debug_level > 0 THEN
9126: oe_debug_pub.add( 'ORDER TYPE ID : ' || OE_ORDER_CACHE.G_ORDER_TYPE_REC.ORDER_TYPE_ID , 2 ) ;
9127: END IF;
9128: IF nvl(OE_ORDER_CACHE.g_order_type_rec.auto_scheduling_flag,'N') = 'Y' THEN
9129: Set_Auto_Sch_Flag('Y');
9130: ELSE
9131: Set_Auto_Sch_Flag('N');
9132: END IF;

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

9796: AND p_x_line_rec.operation = oe_globals.g_opr_create
9797: AND (p_x_line_rec.top_model_line_id = p_x_line_rec.line_id
9798: OR p_x_line_rec.top_model_line_id IS NULL) THEN
9799:
9800: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
9801: IF OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR
9802: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL'
9803: THEN
9804:

Line 9801: IF OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR

9797: AND (p_x_line_rec.top_model_line_id = p_x_line_rec.line_id
9798: OR p_x_line_rec.top_model_line_id IS NULL) THEN
9799:
9800: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
9801: IF OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR
9802: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL'
9803: THEN
9804:
9805: IF l_debug_level > 0 THEN

Line 9802: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL'

9798: OR p_x_line_rec.top_model_line_id IS NULL) THEN
9799:
9800: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
9801: IF OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR
9802: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL'
9803: THEN
9804:
9805: IF l_debug_level > 0 THEN
9806: oe_debug_pub.add( 'VALIDATION FAILED FOR SET' , 2 ) ;

Line 10880: l_set_rec OE_ORDER_CACHE.set_rec_type;

10876: l_org_code VARCHAR2(30);
10877: l_order_date_type_code VARCHAR2(30) := null; -- Bug-2371760
10878: l_auth_to_override_atp VARCHAR2(3) := NULL; -- BUG 1282873
10879: l_override NUMBER; -- BUG 1282873
10880: l_set_rec OE_ORDER_CACHE.set_rec_type;
10881: l_found VARCHAR2(1) :='N'; --Bug 2746497
10882: l_overridden VARCHAR2(1) :='N'; --Bug 2716220
10883: --
10884: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 11890: l_set_rec := OE_ORDER_CACHE.Load_Set

11886: (p_line_rec.arrival_set_id IS NOT NULL AND
11887: NOT oe_globals.equal(p_line_rec.arrival_set_id,
11888: p_old_line_rec.arrival_set_id))) THEN
11889:
11890: l_set_rec := OE_ORDER_CACHE.Load_Set
11891: (nvl(p_line_rec.arrival_set_id,p_line_rec.ship_set_id));
11892: IF NVL(p_line_rec.override_atp_date_code, 'N') = 'Y' THEN
11893:
11894: IF l_set_rec.ship_from_org_id is not null

Line 12043: l_set_rec := OE_ORDER_CACHE.Load_Set

12039: (p_line_rec.arrival_set_id IS NOT NULL AND
12040: NOT oe_globals.equal(p_line_rec.arrival_set_id,
12041: p_old_line_rec.arrival_set_id))) THEN
12042:
12043: l_set_rec := OE_ORDER_CACHE.Load_Set
12044: (nvl(p_line_rec.arrival_set_id,p_line_rec.ship_set_id));
12045:
12046: IF ((l_order_date_type_code = 'SHIP'
12047: AND trunc(l_set_rec.schedule_ship_date)

Line 12734: IF OE_Order_Cache.g_header_rec.order_type_id IS NOT NULL

12730: END IF;
12731: -- 3748723
12732: IF p_order_type_id IS NULL THEN
12733:
12734: IF OE_Order_Cache.g_header_rec.order_type_id IS NOT NULL
12735: AND OE_Order_Cache.g_header_rec.header_id = p_header_id THEN --Bug4683211
12736:
12737: IF l_debug_level > 0 THEN
12738: oe_debug_pub.add( 'From Header Cache ' , 2 ) ;

Line 12735: AND OE_Order_Cache.g_header_rec.header_id = p_header_id THEN --Bug4683211

12731: -- 3748723
12732: IF p_order_type_id IS NULL THEN
12733:
12734: IF OE_Order_Cache.g_header_rec.order_type_id IS NOT NULL
12735: AND OE_Order_Cache.g_header_rec.header_id = p_header_id THEN --Bug4683211
12736:
12737: IF l_debug_level > 0 THEN
12738: oe_debug_pub.add( 'From Header Cache ' , 2 ) ;
12739: END IF;

Line 12740: l_order_type_id := OE_Order_Cache.g_header_rec.order_type_id;

12736:
12737: IF l_debug_level > 0 THEN
12738: oe_debug_pub.add( 'From Header Cache ' , 2 ) ;
12739: END IF;
12740: l_order_type_id := OE_Order_Cache.g_header_rec.order_type_id;
12741: ELSE
12742:
12743: BEGIN
12744: SELECT order_type_id

Line 13136: OE_Order_Cache.Clear_Top_Model_Line(p_key => p_x_line_tbl(I).line_id);

13132: END IF;
13133: IF l_debug_level > 0 THEN
13134: oe_debug_pub.add( 'MODEL LINE: '|| P_X_LINE_TBL ( I ) .LINE_ID , 1 ) ;
13135: END IF;
13136: OE_Order_Cache.Clear_Top_Model_Line(p_key => p_x_line_tbl(I).line_id);
13137: END IF;
13138:
13139: ELSIF nvl(p_x_line_tbl(I).open_flag,'Y') = 'N' THEN
13140:

Line 13371: l_order_type_id NUMBER := OE_Order_Cache.g_header_rec.order_type_id;

13367: l_process_requests BOOLEAN;
13368: l_line_tbl OE_ORDER_PUB.line_tbl_type;
13369: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
13370: l_sec_result NUMBER;
13371: l_order_type_id NUMBER := OE_Order_Cache.g_header_rec.order_type_id;
13372: l_control_rec OE_GLOBALS.control_rec_type;
13373: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
13374: l_index NUMBER;
13375: --

Line 14901: l_set_rec OE_ORDER_CACHE.set_rec_type;

14897: l_found BOOLEAN := FALSE;
14898: l_buffer VARCHAR2(2000);
14899: l_msg_count NUMBER;
14900: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
14901: l_set_rec OE_ORDER_CACHE.set_rec_type;
14902: l_sales_order_id NUMBER; --8706868
14903: l_need_scheduling BOOLEAN :=FALSE; --8706868
14904:
14905: --

Line 14935: l_set_rec := OE_ORDER_CACHE.Load_Set

14931:
14932: OE_Set_Util.Query_Set_Rows(p_set_id => p_x_line_tbl(I).arrival_set_id,
14933: x_line_tbl => l_local_line_tbl);
14934:
14935: l_set_rec := OE_ORDER_CACHE.Load_Set
14936: (p_x_line_tbl(I).arrival_set_id);
14937:
14938: FOR L IN 1..l_local_line_tbl.count LOOP
14939:

Line 15013: l_set_rec := OE_ORDER_CACHE.Load_Set

15009:
15010: OE_Set_Util.Query_Set_Rows(p_set_id => p_x_line_tbl(I).ship_set_id,
15011: x_line_tbl => l_local_line_tbl);
15012:
15013: l_set_rec := OE_ORDER_CACHE.Load_Set
15014: (p_x_line_tbl(I).ship_set_id);
15015: FOR L IN 1..l_local_line_tbl.count LOOP
15016:
15017: K := K +1;