DBA Data[Home] [Help]

APPS.OE_SET_UTIL dependencies on OE_SETS_S

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