DBA Data[Home] [Help]

APPS.CSP_NOTIFICATION_DETAILS_PKG dependencies on DUAL

Line 47: CURSOR C2 IS SELECT CSP_NOTIFICATION_DETAILS_S1.nextval FROM sys.dual;

43: ,p_REPAIR_SUPPLIER_ID NUMBER
44: ,p_ORDER_NUMBER NUMBER
45: )
46: IS
47: CURSOR C2 IS SELECT CSP_NOTIFICATION_DETAILS_S1.nextval FROM sys.dual;
48: BEGIN
49: If (px_NOTIFICATION_DETAIL_ID IS NULL) OR (px_NOTIFICATION_DETAIL_ID = FND_API.G_MISS_NUM) then
50: OPEN C2;
51: FETCH C2 INTO px_NOTIFICATION_DETAIL_ID;