CREATE OR REPLACE PROCEDURE ADD_USER_GROUPS_PROC AS 
    
    V_ ACTIVE_FLAG := WWTT_INPUT.ACTIVE_FLAG%TYPE;
    V_ BEGIN_DATE := WWTT_INPUT.BEGIN_DATE%TYPE;
    V_ END_DATE := WWTT_INPUT.END_DATE%TYPE;
    V_ GROUP_NAME := WWTT_INPUT.GROUP_NAME%TYPE;
    V_ USER_ID := WWTT_INPUT.USER_ID%TYPE;
    V_ USER_TYPE := WWTT_INPUT.USER_TYPE%TYPE;
    V_ ACCESS_LEVEL := WWTT_INPUT.ACCESS_LEVEL%TYPE;
    V_ COUNTRY := WWTT_INPUT.COUNTRY%TYPE;
    V_ FIRST_NAME := WWTT_INPUT.FIRST_NAME%TYPE;
    V_ GEOGRAPHY := WWTT_INPUT.GEOGRAPHY%TYPE;
    V_ LAST_NAME := WWTT_INPUT.LAST_NAME%TYPE;
    V_ USER_EMAIL := WWTT_INPUT.USER_EMAIL%TYPE;
    USER_INDEX NUMBER;
    
     CURSOR WWTT_INPUT_CUR IS 
       SELECT * FROM SYSTEM.WWTT_INPUT
       WHERE USER_ID LIKE 'A%';
       
     CURSOR WWTT_USERS_CUR IS
       SELECT * FROM SYSTEM.WWTT_USERS;
       
     CURSOR WWTT_GROUPS_CUR IS
       SELECT * FROM SYSTEM.WWTT_GROUPS;

  BEGIN

--    SELECT USER_ID INTO V_ASDF FROM WEATHER.WWTT_USER_GROUPS WHERE USER_id <> ' ';
--    DBMS_OUTPUT.PUT_LINE('V_ASDF: ' || V_ASDF); 

    OPEN WWTT_INPUT_CUR; 
    OPEN WWTT_USERS_CUR;
    OPEN WWTT_GROUPS_CUR;
    FETCH WWTT_INPUT_CUR INTO V_WWTT_INPUT;
    FETCH WWTT_USERS_CUR INTO V_WWTT_USERS;
    FETCH WWTT_GROUPS_CUR INTO V_WWTT_GROUPS;
    
    

            INSERT INTO SYSTEM.WWTT_GROUPS
            (GROUP_NAME,BEGIN_DATE,ACTIVE_FLAG,END_DATE) 
            VALUES 
            (V_WWTT_INPUT.GROUP_NAME,SYSDATE,'Y',NULL);  
           
            --<<outerloop>>
            FOR USER_INDEX IN WWTT_INPUT_CUR LOOP
              --IF WWTT_USERS_CUR.USER_ID =  
          
            END LOOP; -- outerloop; --FOR USER_INDEX IN WWTT_INPUT_CUR   --  ***** LINE 87 *****
            

END ADD_USER_GROUPS_PROC;

CREATE OR REPLACE PROCEDURE ADD_USER_GROUPS_PROC
AS
   V_ACTIVE_FLAG    WWTT_INPUT.ACTIVE_FLAG%TYPE;
   V_BEGIN_DATE     WWTT_INPUT.BEGIN_DATE%TYPE;
   V_END_DATE       WWTT_INPUT.END_DATE%TYPE;
   V_GROUP_NAME     WWTT_INPUT.GROUP_NAME%TYPE;
   V_USER_ID        WWTT_INPUT.USER_ID%TYPE;
   V_USER_TYPE      WWTT_INPUT.USER_TYPE%TYPE;
   V_ACCESS_LEVEL   WWTT_INPUT.ACCESS_LEVEL%TYPE;
   V_COUNTRY        WWTT_INPUT.COUNTRY%TYPE;
   V_FIRST_NAME     WWTT_INPUT.FIRST_NAME%TYPE;
   V_GEOGRAPHY      WWTT_INPUT.GEOGRAPHY%TYPE;
   V_LAST_NAME      WWTT_INPUT.LAST_NAME%TYPE;
   V_USER_EMAIL     WWTT_INPUT.USER_EMAIL%TYPE;
   USER_INDEX       NUMBER;

   CURSOR WWTT_INPUT_CUR
   IS
      SELECT *
        FROM SYSTEM.WWTT_INPUT
       WHERE USER_ID LIKE 'A%';

   CURSOR WWTT_USERS_CUR
   IS
      SELECT * FROM SYSTEM.WWTT_USERS;

   CURSOR WWTT_GROUPS_CUR
   IS
      SELECT * FROM SYSTEM.WWTT_GROUPS;
BEGIN
   -- SELECT USER_ID INTO V_ASDF FROM WEATHER.WWTT_USER_GROUPS WHERE USER_id <> ' ';
   -- DBMS_OUTPUT.PUT_LINE('V_ASDF: ' || V_ASDF);

   OPEN WWTT_INPUT_CUR;

   OPEN WWTT_USERS_CUR;

   OPEN WWTT_GROUPS_CUR;

   FETCH WWTT_INPUT_CUR INTO V_WWTT_INPUT;

   FETCH WWTT_USERS_CUR INTO V_WWTT_USERS;

   FETCH WWTT_GROUPS_CUR INTO V_WWTT_GROUPS;



   INSERT INTO SYSTEM.WWTT_GROUPS (GROUP_NAME,
                                   BEGIN_DATE,
                                   ACTIVE_FLAG,
                                   END_DATE)
        VALUES (V_WWTT_INPUT.GROUP_NAME,
                SYSDATE,
                'Y',
                NULL);

   --<<outerloop>>
   FOR USER_INDEX IN WWTT_INPUT_CUR
   LOOP
      --IF WWTT_USERS_CUR.USER_ID =
      NULL;
   END LOOP; -- outerloop; --FOR USER_INDEX IN WWTT_INPUT_CUR -- ***** LINE 87 *****
END ADD_USER_GROUPS_PROC;

SQL> ed
Wrote file afiedt.buf

  1  CREATE OR REPLACE PROCEDURE ADD_USER_GROUPS_PROC AS
  2      V_ ACTIVE_FLAG := WWTT_INPUT.ACTIVE_FLAG%TYPE;
  3      V_ BEGIN_DATE := WWTT_INPUT.BEGIN_DATE%TYPE;
  4      V_ END_DATE := WWTT_INPUT.END_DATE%TYPE;
  5      V_ GROUP_NAME := WWTT_INPUT.GROUP_NAME%TYPE;
  6      V_ USER_ID := WWTT_INPUT.USER_ID%TYPE;
  7      V_ USER_TYPE := WWTT_INPUT.USER_TYPE%TYPE;
  8      V_ ACCESS_LEVEL := WWTT_INPUT.ACCESS_LEVEL%TYPE;
  9      V_ COUNTRY := WWTT_INPUT.COUNTRY%TYPE;
 10      V_ FIRST_NAME := WWTT_INPUT.FIRST_NAME%TYPE;
 11      V_ GEOGRAPHY := WWTT_INPUT.GEOGRAPHY%TYPE;
 12      V_ LAST_NAME := WWTT_INPUT.LAST_NAME%TYPE;
 13      V_ USER_EMAIL := WWTT_INPUT.USER_EMAIL%TYPE;
 14      USER_INDEX NUMBER;
 15       CURSOR WWTT_INPUT_CUR IS
 16         SELECT * FROM SYSTEM.WWTT_INPUT
 17         WHERE USER_ID LIKE 'A%';
 18       CURSOR WWTT_USERS_CUR IS
 19         SELECT * FROM SYSTEM.WWTT_USERS;
 20       CURSOR WWTT_GROUPS_CUR IS
 21         SELECT * FROM SYSTEM.WWTT_GROUPS;
 22    BEGIN
 23  --    SELECT USER_ID INTO V_ASDF FROM WEATHER.WWTT_USER_GROUPS WHERE USER_id <> ' ';
 24  --    DBMS_OUTPUT.PUT_LINE('V_ASDF: ' || V_ASDF);
 25      OPEN WWTT_INPUT_CUR;
 26      OPEN WWTT_USERS_CUR;
 27      OPEN WWTT_GROUPS_CUR;
 28      FETCH WWTT_INPUT_CUR INTO V_WWTT_INPUT;
 29      FETCH WWTT_USERS_CUR INTO V_WWTT_USERS;
 30      FETCH WWTT_GROUPS_CUR INTO V_WWTT_GROUPS;
 31              INSERT INTO SYSTEM.WWTT_GROUPS
 32              (GROUP_NAME,BEGIN_DATE,ACTIVE_FLAG,END_DATE)
 33              VALUES
 34              (V_WWTT_INPUT.GROUP_NAME,SYSDATE,'Y',NULL);
 35              --<<outerloop>>
 36              FOR USER_INDEX IN WWTT_INPUT_CUR LOOP
 37                --IF WWTT_USERS_CUR.USER_ID =
 38                 V_USER_EMAIL := NULL;
 39              END LOOP; -- outerloop; --FOR USER_INDEX IN WWTT_INPUT_CUR   --  ***** LINE 87 *****
 40* END ADD_USER_GROUPS_PROC;
SQL> /

Warning: Procedure created with compilation errors.

SQL> show error
Errors for PROCEDURE ADD_USER_GROUPS_PROC:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/8      PL/SQL: Item ignored
2/8      PLS-00201: identifier 'ACTIVE_FLAG' must be declared
3/8      PL/SQL: Item ignored
3/8      PLS-00201: identifier 'BEGIN_DATE' must be declared
4/8      PL/SQL: Item ignored
4/8      PLS-00201: identifier 'END_DATE' must be declared
5/8      PL/SQL: Item ignored
5/8      PLS-00201: identifier 'GROUP_NAME' must be declared
6/8      PL/SQL: Item ignored
6/8      PLS-00201: identifier 'USER_ID' must be declared
7/8      PL/SQL: Item ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
7/8      PLS-00201: identifier 'USER_TYPE' must be declared
8/8      PL/SQL: Item ignored
8/8      PLS-00201: identifier 'ACCESS_LEVEL' must be declared
9/8      PL/SQL: Item ignored
9/8      PLS-00201: identifier 'COUNTRY' must be declared
10/8     PL/SQL: Item ignored
10/8     PLS-00201: identifier 'FIRST_NAME' must be declared
11/8     PL/SQL: Item ignored
11/8     PLS-00201: identifier 'GEOGRAPHY' must be declared
SQL>