User expects some indicator when any process occurred. You can easily implement in Oracle Apex in a Dynamic Action.
Dynamic actions contain Pl/SQL code or some Pl/SQL calculation. To showing modal indicator you can re-using the built in “show processing indicator”, which is uses action type “Submit Page”.
--- Cheers !!!