DBA Data[Home] [Help]

APPS.CSD_MRO_SERIAL_NUMBERS_PKG dependencies on DUAL

Line 40: CURSOR C2 IS SELECT CSD_MRO_SERIAL_NUMBERS_S1.nextval FROM sys.dual;

36: ,p_CUSTOMER_PRODUCT_ID NUMBER
37: ,p_REFERENCE_NUMBER VARCHAR2)
38:
39: IS
40: CURSOR C2 IS SELECT CSD_MRO_SERIAL_NUMBERS_S1.nextval FROM sys.dual;
41: BEGIN
42: If (px_MRO_SERIAL_NUMBER_ID IS NULL) OR (px_MRO_SERIAL_NUMBER_ID = FND_API.G_MISS_NUM) then
43: OPEN C2;
44: FETCH C2 INTO px_MRO_SERIAL_NUMBER_ID;