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 7011: -- l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM -- INVCONV Not needed now because of OPM inventory convergence

7007: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7008: --
7009: /*OPM BEGIN Bug 2794760
7010: ====================*/
7011: -- l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM -- INVCONV Not needed now because of OPM inventory convergence
7012: /*OPM End Bug 2794760
7013: ====================*/
7014: BEGIN
7015: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7781: OE_Order_Cache.Load_Order_Header(p_header_id);

7777: ELSE
7778: IF l_debug_level > 0 THEN
7779: oe_debug_pub.add( 'LOAD HEADER : ' || P_HEADER_ID , 2 ) ;
7780: END IF;
7781: OE_Order_Cache.Load_Order_Header(p_header_id);
7782: OE_ORDER_CACHE.Load_order_type(OE_ORDER_CACHE.g_header_rec.order_type_id);
7783: IF l_debug_level > 0 THEN
7784: oe_debug_pub.add( 'ORDER TYPE ID : ' || OE_ORDER_CACHE.G_ORDER_TYPE_REC.ORDER_TYPE_ID , 2 ) ;
7785: END IF;

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

7778: IF l_debug_level > 0 THEN
7779: oe_debug_pub.add( 'LOAD HEADER : ' || P_HEADER_ID , 2 ) ;
7780: END IF;
7781: OE_Order_Cache.Load_Order_Header(p_header_id);
7782: OE_ORDER_CACHE.Load_order_type(OE_ORDER_CACHE.g_header_rec.order_type_id);
7783: IF l_debug_level > 0 THEN
7784: oe_debug_pub.add( 'ORDER TYPE ID : ' || OE_ORDER_CACHE.G_ORDER_TYPE_REC.ORDER_TYPE_ID , 2 ) ;
7785: END IF;
7786: IF nvl(OE_ORDER_CACHE.g_order_type_rec.auto_scheduling_flag,'N') = 'Y' THEN

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

7780: END IF;
7781: OE_Order_Cache.Load_Order_Header(p_header_id);
7782: OE_ORDER_CACHE.Load_order_type(OE_ORDER_CACHE.g_header_rec.order_type_id);
7783: IF l_debug_level > 0 THEN
7784: oe_debug_pub.add( 'ORDER TYPE ID : ' || OE_ORDER_CACHE.G_ORDER_TYPE_REC.ORDER_TYPE_ID , 2 ) ;
7785: END IF;
7786: IF nvl(OE_ORDER_CACHE.g_order_type_rec.auto_scheduling_flag,'N') = 'Y' THEN
7787: Set_Auto_Sch_Flag('Y');
7788: ELSE

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

7782: OE_ORDER_CACHE.Load_order_type(OE_ORDER_CACHE.g_header_rec.order_type_id);
7783: IF l_debug_level > 0 THEN
7784: oe_debug_pub.add( 'ORDER TYPE ID : ' || OE_ORDER_CACHE.G_ORDER_TYPE_REC.ORDER_TYPE_ID , 2 ) ;
7785: END IF;
7786: IF nvl(OE_ORDER_CACHE.g_order_type_rec.auto_scheduling_flag,'N') = 'Y' THEN
7787: Set_Auto_Sch_Flag('Y');
7788: ELSE
7789: Set_Auto_Sch_Flag('N');
7790: END IF;

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

8447: AND p_x_line_rec.operation = oe_globals.g_opr_create
8448: AND (p_x_line_rec.top_model_line_id = p_x_line_rec.line_id
8449: OR p_x_line_rec.top_model_line_id IS NULL) THEN
8450:
8451: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
8452: IF OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR
8453: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL'
8454: THEN
8455:

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

8448: AND (p_x_line_rec.top_model_line_id = p_x_line_rec.line_id
8449: OR p_x_line_rec.top_model_line_id IS NULL) THEN
8450:
8451: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
8452: IF OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR
8453: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL'
8454: THEN
8455:
8456: IF l_debug_level > 0 THEN

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

8449: OR p_x_line_rec.top_model_line_id IS NULL) THEN
8450:
8451: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
8452: IF OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR
8453: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL'
8454: THEN
8455:
8456: IF l_debug_level > 0 THEN
8457: oe_debug_pub.add( 'VALIDATION FAILED FOR SET' , 2 ) ;

Line 9348: l_set_rec OE_ORDER_CACHE.set_rec_type;

9344: l_org_code VARCHAR2(30);
9345: l_order_date_type_code VARCHAR2(30) := null; -- Bug-2371760
9346: l_auth_to_override_atp VARCHAR2(3) := NULL; -- BUG 1282873
9347: l_override NUMBER; -- BUG 1282873
9348: l_set_rec OE_ORDER_CACHE.set_rec_type;
9349: l_found VARCHAR2(1) :='N'; --Bug 2746497
9350: l_overridden VARCHAR2(1) :='N'; --Bug 2716220
9351: --
9352: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 10308: l_set_rec := OE_ORDER_CACHE.Load_Set

10304: (p_line_rec.arrival_set_id IS NOT NULL AND
10305: NOT oe_globals.equal(p_line_rec.arrival_set_id,
10306: p_old_line_rec.arrival_set_id))) THEN
10307:
10308: l_set_rec := OE_ORDER_CACHE.Load_Set
10309: (nvl(p_line_rec.arrival_set_id,p_line_rec.ship_set_id));
10310: IF NVL(p_line_rec.override_atp_date_code, 'N') = 'Y' THEN
10311:
10312: IF l_set_rec.ship_from_org_id is not null

Line 10461: l_set_rec := OE_ORDER_CACHE.Load_Set

10457: (p_line_rec.arrival_set_id IS NOT NULL AND
10458: NOT oe_globals.equal(p_line_rec.arrival_set_id,
10459: p_old_line_rec.arrival_set_id))) THEN
10460:
10461: l_set_rec := OE_ORDER_CACHE.Load_Set
10462: (nvl(p_line_rec.arrival_set_id,p_line_rec.ship_set_id));
10463:
10464: IF ((l_order_date_type_code = 'SHIP'
10465: AND trunc(l_set_rec.schedule_ship_date)

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

11123: END IF;
11124: -- 3748723
11125: IF p_order_type_id IS NULL THEN
11126:
11127: IF OE_Order_Cache.g_header_rec.order_type_id IS NOT NULL
11128: AND OE_Order_Cache.g_header_rec.header_id = p_header_id THEN --Bug4683211
11129:
11130: IF l_debug_level > 0 THEN
11131: oe_debug_pub.add( 'From Header Cache ' , 2 ) ;

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

11124: -- 3748723
11125: IF p_order_type_id IS NULL THEN
11126:
11127: IF OE_Order_Cache.g_header_rec.order_type_id IS NOT NULL
11128: AND OE_Order_Cache.g_header_rec.header_id = p_header_id THEN --Bug4683211
11129:
11130: IF l_debug_level > 0 THEN
11131: oe_debug_pub.add( 'From Header Cache ' , 2 ) ;
11132: END IF;

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

11129:
11130: IF l_debug_level > 0 THEN
11131: oe_debug_pub.add( 'From Header Cache ' , 2 ) ;
11132: END IF;
11133: l_order_type_id := OE_Order_Cache.g_header_rec.order_type_id;
11134: ELSE
11135:
11136: BEGIN
11137: SELECT order_type_id

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

11525: END IF;
11526: IF l_debug_level > 0 THEN
11527: oe_debug_pub.add( 'MODEL LINE: '|| P_X_LINE_TBL ( I ) .LINE_ID , 1 ) ;
11528: END IF;
11529: OE_Order_Cache.Clear_Top_Model_Line(p_key => p_x_line_tbl(I).line_id);
11530: END IF;
11531:
11532: ELSIF nvl(p_x_line_tbl(I).open_flag,'Y') = 'N' THEN
11533:

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

11760: l_process_requests BOOLEAN;
11761: l_line_tbl OE_ORDER_PUB.line_tbl_type;
11762: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
11763: l_sec_result NUMBER;
11764: l_order_type_id NUMBER := OE_Order_Cache.g_header_rec.order_type_id;
11765: l_control_rec OE_GLOBALS.control_rec_type;
11766: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
11767: l_index NUMBER;
11768: --

Line 13055: l_set_rec OE_ORDER_CACHE.set_rec_type;

13051: l_found BOOLEAN := FALSE;
13052: l_buffer VARCHAR2(2000);
13053: l_msg_count NUMBER;
13054: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
13055: l_set_rec OE_ORDER_CACHE.set_rec_type;
13056:
13057: --
13058: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
13059: --

Line 13082: l_set_rec := OE_ORDER_CACHE.Load_Set

13078:
13079: OE_Set_Util.Query_Set_Rows(p_set_id => p_x_line_tbl(I).arrival_set_id,
13080: x_line_tbl => l_local_line_tbl);
13081:
13082: l_set_rec := OE_ORDER_CACHE.Load_Set
13083: (p_x_line_tbl(I).arrival_set_id);
13084:
13085: FOR L IN 1..l_local_line_tbl.count LOOP
13086:

Line 13103: l_set_rec := OE_ORDER_CACHE.Load_Set

13099:
13100: OE_Set_Util.Query_Set_Rows(p_set_id => p_x_line_tbl(I).ship_set_id,
13101: x_line_tbl => l_local_line_tbl);
13102:
13103: l_set_rec := OE_ORDER_CACHE.Load_Set
13104: (p_x_line_tbl(I).ship_set_id);
13105: FOR L IN 1..l_local_line_tbl.count LOOP
13106:
13107: K := K +1;