DBA Data[Home] [Help]

APPS.CSP_PICKLIST_SERIAL_LOTS_PKG dependencies on DUAL

Line 29: CURSOR C2 IS SELECT CSP_PICKLIST_SERIAL_LOTS_S1.nextval FROM sys.dual;

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