Search This Blog

Wednesday, November 17, 2021

Oracle Apps r12 API to Delete BEE (batch Element Entry) Lines

 


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