delete data from hr_api_transactions and related tables

Sometimes client may request to delete pending transactions as the approver may be inactive or other such reasons. Use the below script.

DECLARE
  P_TRANSACTION_ID NUMBER;
  P_VALIDATE BOOLEAN;

BEGIN
  P_TRANSACTION_ID := 17053;
  P_VALIDATE := FALSE;

  APPS.HR_TRANSACTION_API.ROLLBACK_TRANSACTION ( P_TRANSACTION_ID, P_VALIDATE );
 -- COMMIT;
END;