15.3 Understanding Page Processes
Create page processes to perform an action at a specified point during the rendering or submission of the page.
- About Page Processes
A page process performs an action at a specified point during the rendering or submission of the page. - Creating Page Processes
Create a page process in Page Designer. - Editing Page Process Attributes
Edit a page process in Page Designer. - Controlling When a Page Process Executes
Control when a process executes by editing the Sequence and Point attributes. - Creating Page Process Success and Error Messages
Define both success and error messages that display when a process runs. - Making a Page Process Conditional
Create a conditional page process by editing Server-side Condition attributes.
Parent topic: Managing Computations, Validations, and Processes
15.3.1 About Page Processes
A page process performs an action at a specified point during the rendering or submission of the page.
For example, you can create a page process to execute logic or to make a call to the APEX engine. A page process is a unit of logic that runs when a specific event occurs, such as loading or submitting a page.
From a functional perspective, there is no difference between page-level and application-level processes. The difference between these two process types is where the process is defined, that is at the page-level or at the application level.
You create a page process in Page Designer. In either the Rendering or Processing tab, locate the node where the process will occur, right-click, and select Create Process. The process Type determines what attributes you need to configure.
Supported Process Types
Note:
Depending on your application configuration, you may also have additional process type plug-ins. These display as <My Plug-in> [Plug-in].Supported page process Types include:
- Clear Session State - Process to clear session state stored within Oracle APEX.
- Close Dialog - Process to close the current modal or non-modal dialog page.
- Data Loading - Process to load data into the target table or collection based on the given data load definition.
- Execute Code - Process to execute PL/SQL code.
- Form - Automatic Row Processing (DML) - Process to insert, update, or delete a form region row(s).
- Form - Initialization - Process to initialize form region items. Initialization can either be fetching data from the region source, using the primary key value(s) or simple initialization of the form region items. Human Task - Create - Process to create a human task, using an existing task definition from the application.
- Human Task - Manage - Process to manage a human task. The different types of task management are Approve, Reject, Claim, Release, Delegate, Forward, Cancel, Comment and Invite Participant.
- Interactive Grid - Automatic Row Processing (DML) - Process to insert, update, or delete Interactive Grid rows.
- Invoke API - Process to invoke a procedure or function stored in the local database.
- Reset Pagination - Process to reset pagination of reports on the current page.
- Send E-Mail - Process to send an email, and optionally one or more attachments, from the application.
- User Preferences - Process to set User Preferences for the end user.
- Web Service - Process to consume the specified Web service.
Parent topic: Understanding Page Processes
15.3.3 Editing Page Process Attributes
Edit a page process in Page Designer.
To edit an existing page process:
Parent topic: Understanding Page Processes
15.3.4 Controlling When a Page Process Executes
Control when a process executes by editing the Sequence and Point attributes.
To control when a process executes, edit the Sequence and Point attributes:
See Also:
Parent topic: Understanding Page Processes
15.3.5 Creating Page Process Success and Error Messages
Define both success and error messages that display when a process runs.
On Submit - Before Computation and Validations
or
On Submit - After Computations and Validations
, you can specify
whether the error message displays inline on the current page (the default) or on a
separate page. For all other page processes, error messages display on a separate error
page.
To create a page process error or success message:
See Also:
Page TemplatesParent topic: Understanding Page Processes
15.3.6 Making a Page Process Conditional
Create a conditional page process by editing Server-side Condition attributes.
To create a conditional page process:
Parent topic: Understanding Page Processes