DBA Data[Home] [Help]

APPS.CSP_EXCESS_LST_SERIAL_LOTS_PKG dependencies on DUAL

Line 27: CURSOR C2 IS SELECT CSP_EXCESS_LIST_SERIAL_LOTS_S1.nextval FROM sys.dual;

23: p_SERIAL_NUMBER VARCHAR2,
24: p_REVISION VARCHAR2,
25: p_LOCATOR_ID NUMBER)
26: IS
27: CURSOR C2 IS SELECT CSP_EXCESS_LIST_SERIAL_LOTS_S1.nextval FROM sys.dual;
28: BEGIN
29: If (px_EXCESS_LIST_SERIAL_LOT_ID IS NULL) OR (px_EXCESS_LIST_SERIAL_LOT_ID = FND_API.G_MISS_NUM) then
30: OPEN C2;
31: FETCH C2 INTO px_EXCESS_LIST_SERIAL_LOT_ID;