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 264: l_set_rec OE_ORDER_CACHE.set_rec_type;

260: Procedure Create_Fulfillment_Set(p_line_id NUMBER,
261: -- 4925992
262: p_top_model_line_id NUMBER := NULL,
263: p_set_id NUMBER) IS
264: l_set_rec OE_ORDER_CACHE.set_rec_type;
265: x_msg_count number;
266: x_msg_data varchar2(2000);
267: Cursor C1 is
268: Select line_id from

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

445: end if;
446: end if;
447:
448: -- 2695403
449: g_set_rec := OE_ORDER_CACHE.Load_Set(p_set_id); -- refresh the cache record
450: ---
451:
452: Delete oe_line_sets
453: Where line_id = p_line_id

Line 519: l_set_rec OE_ORDER_CACHE.set_rec_type;

515: x_msg_count number;
516: x_msg_data varchar2(2000);
517:
518: l_return_status VARCHAR2(30);
519: l_set_rec OE_ORDER_CACHE.set_rec_type;
520: l_atp_rec OE_ATP.atp_tbl_type;
521: l_atp_tbl OE_ATP.atp_tbl_type;
522:
523: Cursor optiontbl IS

Line 878: l_set_rec OE_ORDER_CACHE.set_rec_type;

874: l_header_id NUMBER ;
875: l_line_id NUMBER ;
876: l_set_type VARCHAR2(30) ;
877: l_set_name VARCHAR2(30) ;
878: l_set_rec OE_ORDER_CACHE.set_rec_type;
879: l_atp_rec OE_ATP.atp_tbl_type;
880: l_atp_tbl OE_ATP.atp_tbl_type;
881: lcnt number := 0;
882: l_Ship_from_org_id NUMBER ;

Line 1578: l_set_rec OE_ORDER_CACHE.set_rec_type;

1574: l_Schedule_Arrival_Date DATE ;
1575: l_Freight_Carrier_Code VARCHAR2(30) ;
1576: l_Shipping_Method_Code VARCHAR2(30) ;
1577: l_Shipment_priority_code VARCHAR2(30);
1578: l_set_rec OE_ORDER_CACHE.set_rec_type;
1579: --
1580: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1581: --
1582: BEGIN

Line 2192: l_set_rec OE_ORDER_CACHE.set_rec_type;

2188: l_header_id NUMBER ;
2189: l_line_id NUMBER ;
2190: l_set_type VARCHAR2(30) ;
2191: l_set_name VARCHAR2(30) ;
2192: l_set_rec OE_ORDER_CACHE.set_rec_type;
2193: l_atp_rec OE_ATP.atp_tbl_type;
2194: l_atp_tbl OE_ATP.atp_tbl_type;
2195: lcnt number := 0;
2196: l_Ship_from_org_id NUMBER ;

Line 2801: l_set_rec OE_ORDER_CACHE.set_rec_type;

2797:
2798: x_msg_data OUT NOCOPY VARCHAR2
2799:
2800: )IS
2801: l_set_rec OE_ORDER_CACHE.set_rec_type;
2802: l_init_set_rec OE_ORDER_CACHE.set_rec_type;
2803: l_Ship_From_Org_Id NUMBER ;
2804: l_Ship_To_Org_Id NUMBER ;
2805: l_Schedule_Ship_Date DATE ;

Line 2802: l_init_set_rec OE_ORDER_CACHE.set_rec_type;

2798: x_msg_data OUT NOCOPY VARCHAR2
2799:
2800: )IS
2801: l_set_rec OE_ORDER_CACHE.set_rec_type;
2802: l_init_set_rec OE_ORDER_CACHE.set_rec_type;
2803: l_Ship_From_Org_Id NUMBER ;
2804: l_Ship_To_Org_Id NUMBER ;
2805: l_Schedule_Ship_Date DATE ;
2806: l_Schedule_Arrival_Date DATE ;

Line 2925: RETURN OE_ORDER_CACHE.set_rec_type IS

2921: );
2922: End Update_Set;
2923:
2924: FUNCTION get_set_rec(p_set_id IN NUMBER)
2925: RETURN OE_ORDER_CACHE.set_rec_type IS
2926: --
2927: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2928: --
2929: begin

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

2930: --Performance regression. Reverted the changes made earlier for Bug4080531
2931: IF g_set_rec.set_id IS NULL OR
2932: g_set_rec.set_id <> p_set_id THEN
2933:
2934: g_set_rec := OE_ORDER_CACHE.Load_Set(p_set_id);
2935: RETURN g_set_rec;
2936:
2937: ELSE
2938: RETURN g_set_rec;

Line 2953: l_set_rec OE_ORDER_CACHE.set_rec_type;

2949: p_Shipping_Method_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2950: p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2951: X_Return_Status OUT NOCOPY VARCHAR2) IS
2952:
2953: l_set_rec OE_ORDER_CACHE.set_rec_type;
2954: x_msg_count NUMBER;
2955: x_msg_data VARCHAR2(254);
2956: --
2957: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3076: l_set_rec OE_ORDER_CACHE.set_rec_type;

3072: l_Schedule_Arrival_Date DATE ;
3073: l_Freight_Carrier_Code VARCHAR2(30) ;
3074: l_Shipping_Method_Code VARCHAR2(30) ;
3075: l_Shipment_priority_code VARCHAR2(30);
3076: l_set_rec OE_ORDER_CACHE.set_rec_type;
3077: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3078: -- 4925992
3079: l_top_model_line_id NUMBER;
3080: BEGIN

Line 3974: l_set_rec OE_ORDER_CACHE.set_rec_type;

3970: l_api_name CONSTANT VARCHAR2(30) := 'Split_set';
3971: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3972:
3973: l_return_status VARCHAR2(30);
3974: l_set_rec OE_ORDER_CACHE.set_rec_type;
3975: J number;
3976: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
3977: l_set_name varchar2(240);
3978: l_set_id NUMBER;

Line 4106: l_set_rec OE_ORDER_CACHE.set_rec_type;

4102: p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,
4103: p_index IN number) IS
4104:
4105: l_set_id NUMBER;
4106: l_set_rec OE_ORDER_CACHE.set_rec_type;
4107: I number := 0;
4108: J number := 0;
4109: x_arrival_set_id Number;
4110: l_exist boolean := FALSE;

Line 5277: l_set_rec OE_ORDER_CACHE.set_rec_type;

5273: l_header_id NUMBER ;
5274: l_line_id NUMBER ;
5275: l_set_type VARCHAR2(30) ;
5276: l_set_name VARCHAR2(30) ;
5277: l_set_rec OE_ORDER_CACHE.set_rec_type;
5278: l_atp_rec OE_ATP.atp_tbl_type;
5279: l_atp_tbl OE_ATP.atp_tbl_type;
5280: l_Ship_from_org_id NUMBER ;
5281: l_Ship_to_org_id NUMBER ;

Line 6108: l_set_rec oe_order_cache.set_rec_type ;

6104: l_cascade_flag varchar2(1) := 'N';
6105: l_create_set varchar2(1) := 'N';
6106: l_set_type varchar2(30) ;
6107: l_set_name varchar2(2000);
6108: l_set_rec oe_order_cache.set_rec_type ;
6109: x_msg_data varchar2(32000);
6110: x_msg_count number ;
6111: l_return_status varchar2(30);
6112: lsettempname varchar2(2000);

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

6249: ,p_old_line_rec.transaction_phase_code)
6250: )
6251: THEN
6252:
6253: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
6254:
6255: IF OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR
6256: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL'
6257: THEN

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

6251: THEN
6252:
6253: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
6254:
6255: IF OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR
6256: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL'
6257: THEN
6258: l_cust_pref := OE_ORDER_CACHE.g_header_rec.customer_preference_set_code;
6259: IF l_cust_pref = 'SHIP' THEN

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

6252:
6253: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
6254:
6255: IF OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR
6256: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL'
6257: THEN
6258: l_cust_pref := OE_ORDER_CACHE.g_header_rec.customer_preference_set_code;
6259: IF l_cust_pref = 'SHIP' THEN
6260: l_set_pref_type := 'SHIP_SET';

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

6254:
6255: IF OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' OR
6256: OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'ARRIVAL'
6257: THEN
6258: l_cust_pref := OE_ORDER_CACHE.g_header_rec.customer_preference_set_code;
6259: IF l_cust_pref = 'SHIP' THEN
6260: l_set_pref_type := 'SHIP_SET';
6261: ELSE
6262: l_set_pref_type := 'ARRIVAL_SET';

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

6939: OE_DEBUG_PUB.Add('Automatic Fulfillment Set:'||p_x_line_rec.fulfillment_set);
6940:
6941: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
6942:
6943: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
6944:
6945: IF OE_ORDER_CACHE.g_header_rec.default_fulfillment_set = 'Y' THEN
6946:
6947: IF l_debug_level > 0 THEN

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

6941: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
6942:
6943: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
6944:
6945: IF OE_ORDER_CACHE.g_header_rec.default_fulfillment_set = 'Y' THEN
6946:
6947: IF l_debug_level > 0 THEN
6948: OE_DEBUG_PUB.Add('Default Fulfillment set to YES!!!',1 ) ;
6949: END IF;