APPS.OE_ORDER_COPY_UTIL dependencies on OE_SETS

Line 2760: SELECT OE_SETS_S.NEXTVAL

2756:
2757: IF l_line_set_tbl(x).set_count = 1 AND
2758: l_line_set_tbl(x).line_set_id IS NULL
2759: THEN
2760: SELECT OE_SETS_S.NEXTVAL
2761: INTO l_line_set_tbl(x).line_set_id
2762: FROM DUAL;
2763: l_index := l_line_set_tbl(x).line_index;
2764: p_x_line_tbl(l_index).line_set_id :=

Line 5114: SELECT OE_SETS_S.NEXTVAL

5110: oe_debug_pub.add( 'MATCH FOUND WITH SPLIT FROM LINE_ID' , 1 ) ;
5111: END IF;
5112: IF l_copied_rec.line_set_id(m) IS NULL THEN
5113:
5114: SELECT OE_SETS_S.NEXTVAL
5115: INTO l_copied_rec.line_set_id(m)
5116: FROM DUAL;
5117: /*
5118: Create_Line_Set(

Line 5334: INSERT INTO OE_SETS(

5330: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5331: --
5332: BEGIN
5333:
5334: INSERT INTO OE_SETS(
5335: SET_ID
5336: , SET_NAME
5337: , SET_TYPE
5338: , Header_Id

Line 6016: FROM oe_sets

6012: -- Cursor for finding all sets of a particular type from source order.
6013: CURSOR set_cur(stype IN VARCHAR2)
6014: IS
6015: SELECT distinct set_id, set_name,set_type
6016: FROM oe_sets
6017: WHERE header_id = p_old_header_id
6018: AND set_type = stype
6019: ORDER BY set_id;
6020: