DECLARE
  v_a  VARCHAR2(100):= '1,2,3,4,5,6';
BEGIN

For i in (v_a )  loop

Get_Procedure_Status (Each value from variable v_a - comma separated);-- Procedure

End loop;

END;
/

SQL> declare
  2    v_a varchar2(30) := '1,2,3,4,5,6';
  3  begin
  4    for cur_r in (select regexp_substr (v_a, '[^,]+', 1, level) result
  5                  from dual
  6                  connect by regexp_substr (v_a, '[^,]+', 1, level) is not null
  7                 )
  8    loop
  9      dbms_output.put_line(cur_r.result);
 10    end loop;
 11  end;
 12  /
1
2
3
4
5
6

PL/SQL procedure successfully completed.

SQL>

SQL> var mylist varchar2(100)
SQL> exec :mylist := '5,11,13,22,23,31,44,45'

PL/SQL procedure successfully completed.

SQL> select substr(:mylist,
  2                instr(','||:mylist||',', ',', 1, rn),
  3                instr(','||:mylist||',', ',', 1, rn+1)
  4                - instr(','||:mylist||',', ',', 1, rn) - 1) value
  5  from ( select level rn from dual 
  6         connect by level 
  7                      <= length(:mylist)-length(replace(:mylist,',',''))+1
  8       )
  9  /
VALUE
-----------------------------------------------------------
5
11
13
22
23
31
44
45

DECLARE 
nt_email_catalogid sys.ODCINumberList := sys.ODCINumberList();
BEGIN 


 FOR i IN 1..5 
  LOOP
      nt_email_catalogid.extend;
      nt_email_catalogid(i):=10*i;
 END LOOP;
 
 FOR i IN (SELECT COLUMN_VALUE FROM TABLE(nt_email_catalogid))
          LOOP
        DBMS_OUTPUT.PUT_LINE(I.COLUMN_VALUE);
END LOOP;
END;