SQL & PL/SQL

I have 100 plus tables want to create a procedure that will take all the table names as input where in each table it will do bulk delete and bulk insert  and want to create TYPE according to table names run time.

Cursor :-

CURSOR C1 IS

SELECT SOURCE_NAME, TARGET_NAME FROM TABLE_INFO;

Table_info will store all the source and target table names.

After getting the target names want to pass this in TYPE in place of T1 so that dynamically will create the type of that particular target table.

Syntax for Type :-

TYPE T_TYPE

IS

  TABLE OF T1%ROWTYPE;

  T_BULK T_TYPE;

Please let me know if there is any workaround.

Thanks,

Bhavik