Database Reference
In-Depth Information
•
On New Instance - (New Session)
•
On Load - Before Header
•
On Load - After Header
•
On Load - Before Regions
•
On Load - After Regions
•
On Load - Before Footer
•
On Load - After Footer
•
On Submit - Before Computations and Validations
•
On Submit - After Computations and Validations
•
On Demand - Run This Process When Requested by AJAX
Processes can be defined at the individual page level or at the application level as
part of the shared components. Functionally, page processes and application processes
behave the same. The difference is where business logic is contained. For processes
that need to run on all pages, you can define an application process. Also, just as with
regions, you can use Global Pages to define processes that run on every page, but only
for page rendering.
Process Types
Each different process type has a different use depending on the requirement. The types
and their uses are as follows:
•
PL/SQL
: General use for utilizing database PL/SQL logic
•
Reset Pagination
: Resets pagination for a report
•
Session State
: Clears session state values; also referred to as cache
•
Data Manipulation
: Built-in processes for reading from and writing to the
database
•
Web Services
: Submits a request to a web service provider
•
Form Pagination
: Most often used in master-detail forms
•
Send Email
: Declarative interface to easily send e-mail
•
Close Popup Window
: Supports pop-up window handling