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_SETS

Line 173: FROM OE_SETS

169: FND_MESSAGE.Set_Name ('ONT','ONT_SET_PICK_RELEASED');
170: BEGIN
171: SELECT SET_NAME
172: INTO l_set_name
173: FROM OE_SETS
174: WHERE set_id = p_line_rec.ship_set_id;
175: EXCEPTION
176: WHEN NO_DATA_FOUND THEN
177: l_set_name := null;

Line 309: FROM oe_sets

305: oe_debug_pub.add('Locking The Set Status ');
306:
307: SELECT set_status
308: INTO l_set_s
309: FROM oe_sets
310: WHERE set_id = p_set_id
311: FOR UPDATE NOWAIT;
312:
313: EXCEPTION

Line 932: oe_sets where

928: l_line_tbl_model_exists varchar2(1) := 'N' ;
929:
930: Cursor shipset is
931: Select set_id from
932: oe_sets where
933: set_type = 'SHIP_SET'
934: and header_id = l_header_id
935: and ship_from_org_id = l_ship_from_org_id
936: and ship_to_org_id = l_ship_to_org_id

Line 943: oe_sets where

939: ;
940:
941: Cursor arrivalset is
942: Select set_id from
943: oe_sets where
944: set_type = 'ARRIVAL_SET' and
945: header_id = l_header_id
946: and ship_to_org_id = l_ship_to_org_id
947: and trunc(schedule_arrival_date) = trunc(l_Schedule_arrival_Date)

Line 952: oe_sets

948: and nvl(set_status,'X') <> 'C';
949:
950: Cursor C1 is
951: select Max(to_number(set_name)) from
952: oe_sets
953: where
954: set_status = 'T'
955: and header_id = l_header_id and
956: set_type = l_set_type;

Line 977: oe_sets

973: ato_line_id IS NOT NULL) */
974:
975: Cursor C3 is
976: select Max(to_number(set_name)) from
977: oe_sets
978: where
979: header_id = l_header_id and
980: set_type = l_set_type and
981: set_name = lsettempname;

Line 1951: FROM OE_SETS

1947: --
1948: Begin
1949: SELECT set_id
1950: INTO x_set_id
1951: FROM OE_SETS
1952: where set_name = p_set_name
1953: and set_type = p_set_type and
1954: header_id = p_header_id ;
1955: --and nvl(set_status,'X') <> 'C';

Line 1988: FROM OE_SETS

1984:
1985:
1986: SELECT 'Y'
1987: INTO row_exists
1988: FROM OE_SETS
1989: WHERE set_id = p_set_id
1990: and header_id = nvl(l_header_id,header_id);
1991:
1992: RETURN TRUE;

Line 2102: SELECT OE_SETS_S.NEXTVAL

2098: END IF;
2099: -- Bug 14760471 : END
2100:
2101:
2102: SELECT OE_SETS_S.NEXTVAL
2103: INTO l_set_id
2104: FROM DUAL;
2105: IF l_debug_level > 0 THEN
2106: oe_debug_pub.add( 'AFTERSEQUECEVALUE ' , 1 ) ;

Line 2118: INSERT INTO OE_SETS(

2114: IF p_system_set = 'Y' AND (p_set_type = 'FULFILLMENT_SET') THEN
2115: lcustpref := 'T';
2116: END IF;
2117:
2118: INSERT INTO OE_SETS(
2119: SET_ID
2120: , SET_NAME
2121: , SET_TYPE
2122: , Header_Id

Line 2262: oe_sets where

2258: l_top_model_line_id number;
2259:
2260: Cursor shipset is
2261: Select set_id from
2262: oe_sets where
2263: set_type = 'SHIP_SET'
2264: and header_id = l_header_id
2265: and ship_from_org_id = l_ship_from_org_id
2266: and ship_to_org_id = l_ship_to_org_id

Line 2273: oe_sets where

2269: ;
2270:
2271: Cursor arrivalset is
2272: Select set_id from
2273: oe_sets where
2274: set_type = 'ARRIVAL_SET' and
2275: header_id = l_header_id
2276: and ship_to_org_id = l_ship_to_org_id
2277: and trunc(schedule_arrival_date) = trunc(l_Schedule_arrival_Date)

Line 2282: oe_sets

2278: and nvl(set_status,'X') <> 'C';
2279:
2280: Cursor C1 is
2281: select Max(to_number(set_name)) from
2282: oe_sets
2283: where
2284: set_status = 'T'
2285: and header_id = l_header_id and
2286: set_type = l_set_type;

Line 2305: oe_sets

2301: ato_line_id IS NOT NULL) */
2302:
2303: Cursor C3 is
2304: select Max(to_number(set_name)) from
2305: oe_sets
2306: where
2307: header_id = l_header_id and
2308: set_type = l_set_type and
2309: set_name = lsettempname;

Line 2317: oe_sets

2313: Schedule_ship_date,
2314: Ship_from_org_id,
2315: ship_to_org_id
2316: from
2317: oe_sets
2318: where
2319: header_id = l_header_id and
2320: set_type = 'SHIP_SET' and
2321: set_status = 'T';

Line 2919: UPDATE OE_SETS SET

2915: ELSE
2916: l_shipment_priority_code := p_shipment_priority_code ;
2917: END IF;
2918:
2919: UPDATE OE_SETS SET
2920: ship_from_org_id = l_ship_from_org_id,
2921: ship_to_org_id = l_ship_to_org_id,
2922: Schedule_Arrival_Date = l_Schedule_Arrival_Date,
2923: Schedule_Ship_Date = l_Schedule_Ship_Date,

Line 5189: From Oe_sets

5185: Begin
5186:
5187: Select header_id
5188: Into l_header_id
5189: From Oe_sets
5190: Where set_id = p_set_id;
5191: Exception
5192: When Others Then
5193:

Line 5254: SELECT OE_SETS_S.NEXTVAL

5250: IF l_debug_level > 0 THEN
5251: oe_debug_pub.add( 'ENTER:CREATE LINE SETS ' , 1 ) ;
5252: END IF;
5253:
5254: SELECT OE_SETS_S.NEXTVAL
5255: INTO l_set_id
5256: FROM DUAL;
5257: IF l_debug_level > 0 THEN
5258: oe_debug_pub.add( 'AFTERSEQUECEVALUE ' , 1 ) ;

Line 5260: INSERT INTO OE_SETS(

5256: FROM DUAL;
5257: IF l_debug_level > 0 THEN
5258: oe_debug_pub.add( 'AFTERSEQUECEVALUE ' , 1 ) ;
5259: END IF;
5260: INSERT INTO OE_SETS(
5261: SET_ID
5262: , SET_NAME
5263: , SET_TYPE
5264: , Header_Id

Line 6109: oe_sets os,

6105: RETURN VARCHAR2
6106: IS
6107: Cursor FULLIST IS
6108: Select os.set_name from
6109: oe_sets os,
6110: oe_line_sets ls
6111: where
6112: ls.line_id = p_line_id and
6113: os.set_id = ls.set_id;

Line 6202: from oe_sets

6198: l_param VARCHAR2(1);
6199:
6200: Cursor C1 is
6201: select Max(to_number(set_name))
6202: from oe_sets
6203: where set_status = 'T'
6204: and header_id = p_x_line_rec.header_id and
6205: set_type = l_set_pref_type;
6206:

Line 6209: from oe_sets

6205: set_type = l_set_pref_type;
6206:
6207: Cursor C3 is
6208: select Max(to_number(set_name))
6209: from oe_sets
6210: where header_id = p_x_line_rec.header_id
6211: and set_type = l_set_pref_type
6212: and set_name = lsettempname;
6213:

Line 6216: from oe_sets

6212: and set_name = lsettempname;
6213:
6214: CURSOR C4 is
6215: select set_id
6216: from oe_sets
6217: where header_id = p_x_line_rec.header_id
6218: and set_type = l_set_pref_type
6219: and set_status = 'T';
6220:

Line 6224: from oe_sets, oe_order_lines_all

6220:
6221: -- Added for ER 2843738
6222: CURSOR C_profile is
6223: select set_id
6224: from oe_sets, oe_order_lines_all
6225: where line_id = p_x_line_rec.line_id
6226: and set_type = l_set_pref_type
6227: and set_status = 'T'
6228: AND set_id = Nvl(ship_set_id, arrival_set_id);

Line 6233: from oe_sets

6229:
6230: -- Added for ER 2843738
6231: CURSOR C_param is
6232: select set_id
6233: from oe_sets
6234: where header_id = p_x_line_rec.header_id
6235: and set_type = 'SHIP_SET'
6236: and set_status = 'T'
6237: AND Nvl(ship_from_org_id,p_x_line_rec.ship_from_org_id) = p_x_line_rec.ship_from_org_id;

Line 6247: from oe_sets

6243: and open_flag = 'Y';
6244:
6245: CURSOR C6 is
6246: select set_name
6247: from oe_sets
6248: where header_id = p_x_line_rec.header_id
6249: and set_type = 'FULFILLMENT_SET'
6250: and set_status = 'T';
6251:

Line 6254: from oe_sets

6250: and set_status = 'T';
6251:
6252: Cursor C7 is
6253: select set_name
6254: from oe_sets
6255: where header_id = p_x_line_rec.header_id
6256: and set_type = l_set_pref_type;
6257: --and set_status = 'T';
6258:

Line 6261: from oe_sets

6257: --and set_status = 'T';
6258:
6259: CURSOR C2 is
6260: select set_id
6261: from oe_sets
6262: where header_id = p_x_line_rec.header_id
6263: and set_type = l_set_pref_type
6264: and set_status = 'T'
6265: and set_name = nvl(p_x_line_rec.arrival_set,p_x_line_rec.ship_set);

Line 6284: from oe_sets, oe_order_lines_all

6280: WHERE ship_set_id = p_x_line_rec.ship_set_id;
6281:
6282: CURSOR C10 is
6283: select set_id
6284: from oe_sets, oe_order_lines_all
6285: where line_id = p_x_line_rec.line_id
6286: and set_status = 'A'
6287: AND set_id = nvl(ship_set_id,arrival_set_id); --Bug 13691678
6288:

Line 6424: select Min(set_id) INTO l_set_id from oe_sets

6420: close C_param;
6421: -- Bug 13706641
6422: IF l_set_id IS NULL THEN
6423: BEGIN
6424: select Min(set_id) INTO l_set_id from oe_sets
6425: where header_id = p_x_line_rec.header_id
6426: AND set_status = 'T'
6427: AND not exists (select line_id FROM oe_order_lines_all
6428: WHERE ship_set_id = set_id);

Line 6899: FROM oe_sets

6895: SELECT ship_from_org_id , schedule_ship_date ,shipping_method_code
6896: , set_name
6897: INTO l_ship_from_org_id , l_schedule_ship_Date,l_shipping_method_code
6898: , l_set_name_dsp
6899: FROM oe_sets
6900: WHERE set_id=p_x_line_rec.ship_set_id;
6901: EXCEPTION
6902: WHEN NO_DATA_FOUND THEN
6903: l_ship_set_id:= NULL ;

Line 6919: FROM oe_sets

6915: BEGIN
6916: SELECT ship_from_org_id , schedule_ship_date, set_id ,shipping_method_code
6917: INTO l_ship_from_org_id , l_schedule_ship_Date , l_ship_set_id ,
6918: l_shipping_method_code
6919: FROM oe_sets
6920: WHERE set_name = p_x_line_rec.ship_set
6921: and set_type = 'SHIP_SET'
6922: and header_id = p_x_line_rec.header_id ;
6923: EXCEPTION

Line 7708: DESCRIPTION:This api will delete set record from oe_sets table if

7704:
7705: -- 4026756
7706: /*
7707: PROCEDURE: Delete_Set
7708: DESCRIPTION:This api will delete set record from oe_sets table if
7709: the set is not associated with any line.
7710: */
7711: Procedure Delete_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,
7712: x_return_status OUT NOCOPY VARCHAR2)

Line 7757: DELETE FROM OE_SETS

7753: IF l_debug_level > 0 THEN
7754: oe_debug_pub.add( 'DELETING SET '||p_request_rec.param1 , 3 ) ;
7755: END IF;
7756:
7757: DELETE FROM OE_SETS
7758: WHERE set_id = p_request_rec.param1;
7759:
7760: WHEN OTHERS THEN
7761: NULL;