DBA Data[Home] [Help]

APPS.CSP_PACKLIST_SERIAL_LOTS_PKG dependencies on DUAL

Line 31: CURSOR C2 IS SELECT CSP_PACKLIST_SERIAL_LOTS_S1.nextval FROM sys.dual;

27: p_LOT_NUMBER VARCHAR2,
28: p_SERIAL_NUMBER VARCHAR2)
29:
30: IS
31: CURSOR C2 IS SELECT CSP_PACKLIST_SERIAL_LOTS_S1.nextval FROM sys.dual;
32: BEGIN
33: If (px_PACKLIST_SERIAL_LOT_ID IS NULL) OR (px_PACKLIST_SERIAL_LOT_ID = FND_API.G_MISS_NUM) then
34: OPEN C2;
35: FETCH C2 INTO px_PACKLIST_SERIAL_LOT_ID;