APPS.OE_ORDER_COPY_UTIL dependencies on OE_SETS

Line 2641: SELECT OE_SETS_S.NEXTVAL

2637:
2638: IF l_line_set_tbl(x).set_count = 1 AND
2639: l_line_set_tbl(x).line_set_id IS NULL
2640: THEN
2641: SELECT OE_SETS_S.NEXTVAL
2642: INTO l_line_set_tbl(x).line_set_id
2643: FROM DUAL;
2644: l_index := l_line_set_tbl(x).line_index;
2645: p_x_line_tbl(l_index).line_set_id :=

Line 4947: SELECT OE_SETS_S.NEXTVAL

4943: oe_debug_pub.add( 'MATCH FOUND WITH SPLIT FROM LINE_ID' , 1 ) ;
4944: END IF;
4945: IF l_copied_rec.line_set_id(m) IS NULL THEN
4946:
4947: SELECT OE_SETS_S.NEXTVAL
4948: INTO l_copied_rec.line_set_id(m)
4949: FROM DUAL;
4950: /*
4951: Create_Line_Set(

Line 5163: INSERT INTO OE_SETS(

5159: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5160: --
5161: BEGIN
5162:
5163: INSERT INTO OE_SETS(
5164: SET_ID
5165: , SET_NAME
5166: , SET_TYPE
5167: , Header_Id

Line 5824: FROM oe_sets

5820: -- Cursor for finding all sets of a particular type from source order.
5821: CURSOR set_cur(stype IN VARCHAR2)
5822: IS
5823: SELECT distinct set_id, set_name,set_type
5824: FROM oe_sets
5825: WHERE header_id = p_old_header_id
5826: AND set_type = stype
5827: ORDER BY set_id;
5828: