APPS.OE_SET_UTIL dependencies on OE_SETS_S

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 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 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 ) ;