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

Line 8: --g_set_rec OE_ORDER_CACHE.set_rec_type;

4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Line_Set';
6:
7: --Bug4080531
8: --g_set_rec OE_ORDER_CACHE.set_rec_type;
9:
10: g_cust_pref_set boolean := FALSE;
11: g_old_line_tbl OE_ORDER_PUB.Line_tbl_Type;
12: g_process_options boolean := TRUE;

Line 24: l_set_rec OE_ORDER_CACHE.set_rec_type;

20:
21: FUNCTION IS_SET_CLOSED(p_set_id number)
22: return BOOLEAN
23: IS
24: l_set_rec OE_ORDER_CACHE.set_rec_type;
25:
26: --
27: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
28: --

Line 274: l_set_rec OE_ORDER_CACHE.set_rec_type;

270: Procedure Create_Fulfillment_Set(p_line_id NUMBER,
271: -- 4925992
272: p_top_model_line_id NUMBER := NULL,
273: p_set_id NUMBER) IS
274: l_set_rec OE_ORDER_CACHE.set_rec_type;
275: x_msg_count number;
276: x_msg_data varchar2(2000);
277: Cursor C1 is
278: Select line_id from

Line 485: g_set_rec := OE_ORDER_CACHE.Load_Set(p_set_id); -- refresh the cache record

481: end if;
482: end if;
483:
484: -- 2695403
485: g_set_rec := OE_ORDER_CACHE.Load_Set(p_set_id); -- refresh the cache record
486: ---
487:
488: Delete oe_line_sets
489: Where line_id = p_line_id

Line 555: l_set_rec OE_ORDER_CACHE.set_rec_type;

551: x_msg_count number;
552: x_msg_data varchar2(2000);
553:
554: l_return_status VARCHAR2(30);
555: l_set_rec OE_ORDER_CACHE.set_rec_type;
556: l_atp_rec OE_ATP.atp_tbl_type;
557: l_atp_tbl OE_ATP.atp_tbl_type;
558:
559: Cursor optiontbl IS

Line 914: l_set_rec OE_ORDER_CACHE.set_rec_type;

910: l_header_id NUMBER ;
911: l_line_id NUMBER ;
912: l_set_type VARCHAR2(30) ;
913: l_set_name VARCHAR2(30) ;
914: l_set_rec OE_ORDER_CACHE.set_rec_type;
915: l_atp_rec OE_ATP.atp_tbl_type;
916: l_atp_tbl OE_ATP.atp_tbl_type;
917: lcnt number := 0;
918: l_Ship_from_org_id NUMBER ;

Line 1614: l_set_rec OE_ORDER_CACHE.set_rec_type;

1610: l_Schedule_Arrival_Date DATE ;
1611: l_Freight_Carrier_Code VARCHAR2(30) ;
1612: l_Shipping_Method_Code VARCHAR2(30) ;
1613: l_Shipment_priority_code VARCHAR2(30);
1614: l_set_rec OE_ORDER_CACHE.set_rec_type;
1615: --
1616: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1617: --
1618: BEGIN

Line 2245: l_set_rec OE_ORDER_CACHE.set_rec_type;

2241: l_header_id NUMBER ;
2242: l_line_id NUMBER ;
2243: l_set_type VARCHAR2(30) ;
2244: l_set_name VARCHAR2(30) ;
2245: l_set_rec OE_ORDER_CACHE.set_rec_type;
2246: l_atp_rec OE_ATP.atp_tbl_type;
2247: l_atp_tbl OE_ATP.atp_tbl_type;
2248: lcnt number := 0;
2249: l_Ship_from_org_id NUMBER ;

Line 2854: l_set_rec OE_ORDER_CACHE.set_rec_type;

2850:
2851: x_msg_data OUT NOCOPY VARCHAR2
2852:
2853: )IS
2854: l_set_rec OE_ORDER_CACHE.set_rec_type;
2855: l_init_set_rec OE_ORDER_CACHE.set_rec_type;
2856: l_Ship_From_Org_Id NUMBER ;
2857: l_Ship_To_Org_Id NUMBER ;
2858: l_Schedule_Ship_Date DATE ;

Line 2855: l_init_set_rec OE_ORDER_CACHE.set_rec_type;

2851: x_msg_data OUT NOCOPY VARCHAR2
2852:
2853: )IS
2854: l_set_rec OE_ORDER_CACHE.set_rec_type;
2855: l_init_set_rec OE_ORDER_CACHE.set_rec_type;
2856: l_Ship_From_Org_Id NUMBER ;
2857: l_Ship_To_Org_Id NUMBER ;
2858: l_Schedule_Ship_Date DATE ;
2859: l_Schedule_Arrival_Date DATE ;

Line 2978: RETURN OE_ORDER_CACHE.set_rec_type IS

2974: );
2975: End Update_Set;
2976:
2977: FUNCTION get_set_rec(p_set_id IN NUMBER)
2978: RETURN OE_ORDER_CACHE.set_rec_type IS
2979: --
2980: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2981: --
2982: begin

Line 2987: g_set_rec := OE_ORDER_CACHE.Load_Set(p_set_id);

2983: --Performance regression. Reverted the changes made earlier for Bug4080531
2984: IF g_set_rec.set_id IS NULL OR
2985: g_set_rec.set_id <> p_set_id THEN
2986:
2987: g_set_rec := OE_ORDER_CACHE.Load_Set(p_set_id);
2988: RETURN g_set_rec;
2989:
2990: ELSE
2991: RETURN g_set_rec;

Line 3006: l_set_rec OE_ORDER_CACHE.set_rec_type;

3002: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3003: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3004: X_Return_Status OUT NOCOPY VARCHAR2) IS
3005:
3006: l_set_rec OE_ORDER_CACHE.set_rec_type;
3007: x_msg_count NUMBER;
3008: x_msg_data VARCHAR2(254);
3009: --
3010: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3129: l_set_rec OE_ORDER_CACHE.set_rec_type;

3125: l_Schedule_Arrival_Date DATE ;
3126: l_Freight_Carrier_Code VARCHAR2(30) ;
3127: l_Shipping_Method_Code VARCHAR2(30) ;
3128: l_Shipment_priority_code VARCHAR2(30);
3129: l_set_rec OE_ORDER_CACHE.set_rec_type;
3130: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3131: -- 4925992
3132: l_top_model_line_id NUMBER;
3133: BEGIN

Line 3212: g_set_rec := OE_ORDER_CACHE.Load_Set(l_set_id); -- refresh the cache record

3208:
3209: IF l_set_id IS NOT NULL THEN
3210:
3211: -- bug8420761
3212: g_set_rec := OE_ORDER_CACHE.Load_Set(l_set_id); -- refresh the cache record
3213: ---end bug8420761
3214:
3215: IF is_set_closed(l_set_id) THEN
3216:

Line 4031: l_set_rec OE_ORDER_CACHE.set_rec_type;

4027: l_api_name CONSTANT VARCHAR2(30) := 'Split_set';
4028: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4029:
4030: l_return_status VARCHAR2(30);
4031: l_set_rec OE_ORDER_CACHE.set_rec_type;
4032: J number;
4033: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
4034: l_set_name varchar2(240);
4035: l_set_id NUMBER;

Line 4163: l_set_rec OE_ORDER_CACHE.set_rec_type;

4159: p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,
4160: p_index IN number) IS
4161:
4162: l_set_id NUMBER;
4163: l_set_rec OE_ORDER_CACHE.set_rec_type;
4164: I number := 0;
4165: J number := 0;
4166: x_arrival_set_id Number;
4167: l_exist boolean := FALSE;

Line 5334: l_set_rec OE_ORDER_CACHE.set_rec_type;

5330: l_header_id NUMBER ;
5331: l_line_id NUMBER ;
5332: l_set_type VARCHAR2(30) ;
5333: l_set_name VARCHAR2(30) ;
5334: l_set_rec OE_ORDER_CACHE.set_rec_type;
5335: l_atp_rec OE_ATP.atp_tbl_type;
5336: l_atp_tbl OE_ATP.atp_tbl_type;
5337: l_Ship_from_org_id NUMBER ;
5338: l_Ship_to_org_id NUMBER ;

Line 6165: l_set_rec oe_order_cache.set_rec_type ;

6161: l_cascade_flag varchar2(1) := 'N';
6162: l_create_set varchar2(1) := 'N';
6163: l_set_type varchar2(30) ;
6164: l_set_name varchar2(2000);
6165: l_set_rec oe_order_cache.set_rec_type ;
6166: x_msg_data varchar2(32000);
6167: x_msg_count number ;
6168: l_return_status varchar2(30);
6169: lsettempname varchar2(2000);

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

6358: ,p_old_line_rec.transaction_phase_code)
6359: )-- Comented for 2843738 */
6360: THEN
6361:
6362: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
6363:
6364: -- 2843738
6365: IF (p_x_line_rec.item_type_code = 'STANDARD' OR
6366: p_x_line_rec.top_model_line_id = p_x_line_rec.line_id) THEN

Line 6385: IF (OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR

6381: IF l_debug_level > 0 THEN
6382: oe_debug_pub.add( 'l_set_id : ' || l_set_id, 1 ) ;
6383: END IF;
6384:
6385: IF (OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR
6386: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL')
6387: AND p_x_line_rec.split_from_line_id IS null --Bug 13691678
6388: THEN
6389: l_cust_pref := OE_ORDER_CACHE.g_header_rec.customer_preference_set_code;

Line 6386: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL')

6382: oe_debug_pub.add( 'l_set_id : ' || l_set_id, 1 ) ;
6383: END IF;
6384:
6385: IF (OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR
6386: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL')
6387: AND p_x_line_rec.split_from_line_id IS null --Bug 13691678
6388: THEN
6389: l_cust_pref := OE_ORDER_CACHE.g_header_rec.customer_preference_set_code;
6390:

Line 6389: l_cust_pref := OE_ORDER_CACHE.g_header_rec.customer_preference_set_code;

6385: IF (OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR
6386: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL')
6387: AND p_x_line_rec.split_from_line_id IS null --Bug 13691678
6388: THEN
6389: l_cust_pref := OE_ORDER_CACHE.g_header_rec.customer_preference_set_code;
6390:
6391: IF l_cust_pref = 'SHIP' THEN
6392: l_set_pref_type := 'SHIP_SET';
6393: ELSE

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

7419: OE_DEBUG_PUB.Add('Automatic Fulfillment Set:'||p_x_line_rec.fulfillment_set);
7420:
7421: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
7422:
7423: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
7424:
7425: IF OE_ORDER_CACHE.g_header_rec.default_fulfillment_set = 'Y' THEN
7426:
7427: IF l_debug_level > 0 THEN

Line 7425: IF OE_ORDER_CACHE.g_header_rec.default_fulfillment_set = 'Y' THEN

7421: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
7422:
7423: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
7424:
7425: IF OE_ORDER_CACHE.g_header_rec.default_fulfillment_set = 'Y' THEN
7426:
7427: IF l_debug_level > 0 THEN
7428: OE_DEBUG_PUB.Add('Default Fulfillment set to YES!!!',1 ) ;
7429: END IF;