Line 65: CURSOR C2 IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;
61: X_attribute15 VARCHAR2) IS
62: CURSOR C1 IS SELECT rowid
63: FROM CE_FORECASTS
64: WHERE forecast_id = X_forecast_id; 65: CURSOR C2 IS SELECT CE_FORECASTS_S.nextval FROM sys.dual; 66: BEGIN
67: IF (X_forecast_id IS NULL) THEN
68: OPEN C2;
69: FETCH C2 INTO X_forecast_id;