CAR collection save in db

begin

for i in (select c001 "action", c002 "assigned_to" , c003 "root_cause_analysis" , c004 "status", c006 "question",
       n002 "id", n005 "score",d001 "completion_date"
       from APEX_COLLECTIONS where collection_name = 'CORRECTIVE_ACTIONS') LOOP
     iF i.id IS NULL THEN
        insert into ACTIONS 
        ( ACTION, ASSIGNED_TO, COMPLETION_DATE,STATUS,REPORT_ID,ROOT_CAUSE_ANALYSIS )
        values 
        ( i.action, i.assigned_to, i.completion_date, i.status, :P41_REPORT_ID, i.root_cause_analysis);

    ELSE
        update ACTIONS
           set ACTION  =  i.action,
               ASSIGNED_TO = i.assigned_to,
               COMPLETION_DATE =  i.completion_date,
               STATUS = i.status ,
               REPORT_ID =:P41_REPORT_ID,
               ROOT_CAUSE_ANALYSIS = i.root_cause_analysis
         where ID  = i.id;
    end if;
END LOOP;
end;