declare
cursor c1 is
select batch_line_id,object_version_number from pay_batch_lines
where batch_id = 126167;
begin
for i in c1 loop
pay_batch_element_entry_api.delete_batch_line
(p_validate => false
,p_batch_line_id => i.batch_line_id
,p_object_version_number => i.object_version_number
);
end loop;
commit;
exception when others then
dbms_output.put_line(sqlerrm);
end;
No comments:
Post a Comment