Reporting Background Progress
Show users background job progress with the APEX_APPL_PAGE_BG_PROC_STATUS view.
The APEX_APPL_PAGE_BG_PROC_STATUS view lets you access the information and status of all background jobs, including the dynamic status message and percent complete details your own code sets to keep users informed.