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.

[Home] [Help]

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 896: oe_sets where

892: l_line_tbl_model_exists varchar2(1) := 'N' ;
893:
894: Cursor shipset is
895: Select set_id from
896: oe_sets where
897: set_type = 'SHIP_SET'
898: and header_id = l_header_id
899: and ship_from_org_id = l_ship_from_org_id
900: and ship_to_org_id = l_ship_to_org_id

Line 907: oe_sets where

903: ;
904:
905: Cursor arrivalset is
906: Select set_id from
907: oe_sets where
908: set_type = 'ARRIVAL_SET' and
909: header_id = l_header_id
910: and ship_to_org_id = l_ship_to_org_id
911: and trunc(schedule_arrival_date) = trunc(l_Schedule_arrival_Date)

Line 916: oe_sets

912: and nvl(set_status,'X') <> 'C';
913:
914: Cursor C1 is
915: select Max(to_number(set_name)) from
916: oe_sets
917: where
918: set_status = 'T'
919: and header_id = l_header_id and
920: set_type = l_set_type;

Line 941: oe_sets

937: ato_line_id IS NOT NULL) */
938:
939: Cursor C3 is
940: select Max(to_number(set_name)) from
941: oe_sets
942: where
943: header_id = l_header_id and
944: set_type = l_set_type and
945: set_name = lsettempname;

Line 1913: FROM OE_SETS

1909: --
1910: Begin
1911: SELECT set_id
1912: INTO x_set_id
1913: FROM OE_SETS
1914: where set_name = p_set_name
1915: and set_type = p_set_type and
1916: header_id = p_header_id ;
1917: --and nvl(set_status,'X') <> 'C';

Line 1950: FROM OE_SETS

1946:
1947:
1948: SELECT 'Y'
1949: INTO row_exists
1950: FROM OE_SETS
1951: WHERE set_id = p_set_id
1952: and header_id = nvl(l_header_id,header_id);
1953:
1954: RETURN TRUE;

Line 2049: SELECT OE_SETS_S.NEXTVAL

2045:
2046: END IF; */
2047:
2048:
2049: SELECT OE_SETS_S.NEXTVAL
2050: INTO l_set_id
2051: FROM DUAL;
2052: IF l_debug_level > 0 THEN
2053: oe_debug_pub.add( 'AFTERSEQUECEVALUE ' , 1 ) ;

Line 2065: INSERT INTO OE_SETS(

2061: IF p_system_set = 'Y' AND (p_set_type = 'FULFILLMENT_SET') THEN
2062: lcustpref := 'T';
2063: END IF;
2064:
2065: INSERT INTO OE_SETS(
2066: SET_ID
2067: , SET_NAME
2068: , SET_TYPE
2069: , Header_Id

Line 2209: oe_sets where

2205: l_top_model_line_id number;
2206:
2207: Cursor shipset is
2208: Select set_id from
2209: oe_sets where
2210: set_type = 'SHIP_SET'
2211: and header_id = l_header_id
2212: and ship_from_org_id = l_ship_from_org_id
2213: and ship_to_org_id = l_ship_to_org_id

Line 2220: oe_sets where

2216: ;
2217:
2218: Cursor arrivalset is
2219: Select set_id from
2220: oe_sets where
2221: set_type = 'ARRIVAL_SET' and
2222: header_id = l_header_id
2223: and ship_to_org_id = l_ship_to_org_id
2224: and trunc(schedule_arrival_date) = trunc(l_Schedule_arrival_Date)

Line 2229: oe_sets

2225: and nvl(set_status,'X') <> 'C';
2226:
2227: Cursor C1 is
2228: select Max(to_number(set_name)) from
2229: oe_sets
2230: where
2231: set_status = 'T'
2232: and header_id = l_header_id and
2233: set_type = l_set_type;

Line 2252: oe_sets

2248: ato_line_id IS NOT NULL) */
2249:
2250: Cursor C3 is
2251: select Max(to_number(set_name)) from
2252: oe_sets
2253: where
2254: header_id = l_header_id and
2255: set_type = l_set_type and
2256: set_name = lsettempname;

Line 2264: oe_sets

2260: Schedule_ship_date,
2261: Ship_from_org_id,
2262: ship_to_org_id
2263: from
2264: oe_sets
2265: where
2266: header_id = l_header_id and
2267: set_type = 'SHIP_SET' and
2268: set_status = 'T';

Line 2866: UPDATE OE_SETS SET

2862: ELSE
2863: l_shipment_priority_code := p_shipment_priority_code ;
2864: END IF;
2865:
2866: UPDATE OE_SETS SET
2867: ship_from_org_id = l_ship_from_org_id,
2868: ship_to_org_id = l_ship_to_org_id,
2869: Schedule_Arrival_Date = l_Schedule_Arrival_Date,
2870: Schedule_Ship_Date = l_Schedule_Ship_Date,

Line 5132: From Oe_sets

5128: Begin
5129:
5130: Select header_id
5131: Into l_header_id
5132: From Oe_sets
5133: Where set_id = p_set_id;
5134: Exception
5135: When Others Then
5136:

Line 5197: SELECT OE_SETS_S.NEXTVAL

5193: IF l_debug_level > 0 THEN
5194: oe_debug_pub.add( 'ENTER:CREATE LINE SETS ' , 1 ) ;
5195: END IF;
5196:
5197: SELECT OE_SETS_S.NEXTVAL
5198: INTO l_set_id
5199: FROM DUAL;
5200: IF l_debug_level > 0 THEN
5201: oe_debug_pub.add( 'AFTERSEQUECEVALUE ' , 1 ) ;

Line 5203: INSERT INTO OE_SETS(

5199: FROM DUAL;
5200: IF l_debug_level > 0 THEN
5201: oe_debug_pub.add( 'AFTERSEQUECEVALUE ' , 1 ) ;
5202: END IF;
5203: INSERT INTO OE_SETS(
5204: SET_ID
5205: , SET_NAME
5206: , SET_TYPE
5207: , Header_Id

Line 6052: oe_sets os,

6048: RETURN VARCHAR2
6049: IS
6050: Cursor FULLIST IS
6051: Select os.set_name from
6052: oe_sets os,
6053: oe_line_sets ls
6054: where
6055: ls.line_id = p_line_id and
6056: os.set_id = ls.set_id;

Line 6129: from oe_sets

6125:
6126:
6127: Cursor C1 is
6128: select Max(to_number(set_name))
6129: from oe_sets
6130: where set_status = 'T'
6131: and header_id = p_x_line_rec.header_id and
6132: set_type = l_set_pref_type;
6133:

Line 6136: from oe_sets

6132: set_type = l_set_pref_type;
6133:
6134: Cursor C3 is
6135: select Max(to_number(set_name))
6136: from oe_sets
6137: where header_id = p_x_line_rec.header_id
6138: and set_type = l_set_pref_type
6139: and set_name = lsettempname;
6140:

Line 6143: from oe_sets

6139: and set_name = lsettempname;
6140:
6141: CURSOR C4 is
6142: select set_id
6143: from oe_sets
6144: where header_id = p_x_line_rec.header_id
6145: and set_type = l_set_pref_type
6146: and set_status = 'T';
6147:

Line 6156: from oe_sets

6152: and open_flag = 'Y';
6153:
6154: CURSOR C6 is
6155: select set_name
6156: from oe_sets
6157: where header_id = p_x_line_rec.header_id
6158: and set_type = 'FULFILLMENT_SET'
6159: and set_status = 'T';
6160:

Line 6163: from oe_sets

6159: and set_status = 'T';
6160:
6161: Cursor C7 is
6162: select set_name
6163: from oe_sets
6164: where header_id = p_x_line_rec.header_id
6165: and set_type = l_set_pref_type;
6166: --and set_status = 'T';
6167:

Line 6170: from oe_sets

6166: --and set_status = 'T';
6167:
6168: CURSOR C2 is
6169: select set_id
6170: from oe_sets
6171: where header_id = p_x_line_rec.header_id
6172: and set_type = l_set_pref_type
6173: and set_status = 'T'
6174: and set_name = nvl(p_x_line_rec.arrival_set,p_x_line_rec.ship_set);

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

7222:
7223: -- 4026756
7224: /*
7225: PROCEDURE: Delete_Set
7226: DESCRIPTION:This api will delete set record from oe_sets table if
7227: the set is not associated with any line.
7228: */
7229: Procedure Delete_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,
7230: x_return_status OUT NOCOPY VARCHAR2)

Line 7275: DELETE FROM OE_SETS

7271: IF l_debug_level > 0 THEN
7272: oe_debug_pub.add( 'DELETING SET '||p_request_rec.param1 , 3 ) ;
7273: END IF;
7274:
7275: DELETE FROM OE_SETS
7276: WHERE set_id = p_request_rec.param1;
7277:
7278: WHEN OTHERS THEN
7279: NULL;