AP Invoice Data Delete From the Base Table Using 'AP_AI_TABLE_HANDLER_PKG.Delete_Row(i.rowid,'APXINWKB')' in Oracle Apps EBS R12.

AP Invoice Data Delete From the Base Table Using 'AP_AI_TABLE_HANDLER_PKG.Delete_Row(i.rowid,'APXINWKB')'
in Oracle Apps EBS R12.

-------  This Script can be used when invoice accounting is not done.

DECLARE
cursor CUR1 is

-- Here we write the script for Which AP Invoice Data, We are Deleting from the Oracle Base Table ---
       SELECT aia.rowid,aia.* from ap_invoices_all aia where aia.BATCH_ID <> 13000;
     
BEGIN
   mo_global.set_policy_context('S',101);  -- Change the org id as per instance setup.
for i in cur1 loop

    AP_AI_TABLE_HANDLER_PKG.Delete_Row(i.rowid,'APXINWKB');
end loop;
    commit;
END;