Transform Cursor to Bulk

                        from diego_parent
                        where state = 200;

     insert into diego_child_arch
       select * from diego_child
         where docid = cur1.docid;



     --Archive Parent items 


     insert into diego_parent_arch
       select * from diego_parent
         where rowid = cur1.rowid;

     show_value := to_char(cur1.docid);
     dbms_output.put_line('Deleting ' || show_value);
     


     ---More selects and updates here on other tables here based on


that DOCID
     select payee into v_PAYEE  
       from payee_T 
       where other = cur1.other;
     
     insert into temp(a,b,c) values(cur1.docid, cur1.state, v_payee);
     
     
     


     --Delete Archived child items 


     delete from diego_child
        where docid = cur1.docid;



     --Delete Archived Parent items 


     delete from diego_parent
        where rowid = cur1.rowid;