Creating a Page Process

You create a process by running the Create Process Wizard. During the wizard, you define a process name, specify a sequence and the point at which the process will execute, and select a process category. You can change nearly all of these attributes on the Edit Page Process page.

To create a process:

1. Navigate to the appropriate Page Definition. See "Accessing the Page Definition".

2. Access the Create Page Process Wizard:

   • Tree view - Under the appropriate event, locate Processes. Right-click and select Create.

   • Component view - Under Processes, click the Create icon.

3. Select a category as described in Table: Process Categories:

   Process Categories

   Process Category	Description
   PL/SQL	Runs the PL/SQL you provide. Use this process type to execute a block of PL/SQL entered directly into the process or to simply call an existing API.
   Reset Pagination	In Report regions, resets pagination back to the first result set. The Application Express engine keeps track of where the user is within a given result set. This process category returns the user to the beginning result set. In other words, this category resets the counters associated with the report region to return the first part of the result set the next time the result set displays.
   Session State	Sets the values of existing session state items to null. Select this process type to clear the cache for applications, sessions, or items and to clear existing user preferences. See Also: "Managing Session State Values" and "Managing User Preferences" in Oracle Application Express Administration Guide
   Data Manipulation	Data Manipulation process types are frequently used by wizards to support data manipulation language (DML) actions. Application Builder supports the following declarative data manipulation processes: Select Automatic Row Fetch and Automatic Row Processing (DML) to create an automatic data manipulation language (DML) process. Use Multi Row Update and Multi Row Delete with tabular forms. Use Add Rows to Tabular Form with a tabular form.
   Web Services	Implements a Web Service as a process on a page. Running the process submits a request to the service provider. See Also: "Invoking a Web Service as a Process"
   Form Pagination	Implements pagination through the detail records associated with a master detail form. Most often used in master detail forms (such as in the Master Detail Wizard), this process checks the master table to determine which set of detail records you are in and determines what the next detail record should be. See Also: "Creating a Master Detail Form"
   Send E-Mail	Provides a declarative interface for the APEX_MAIL.SEND_MAIL package. The process type support attachments.
   Plug-ins	Plug-ins allow developers to declaratively extend the built-in types available with Application Express. This option is available when a plug-in type process exists in this application. See Also: "Implementing Plug-ins"
   Close Popup Window	Applies to processes running within a popup window. Upon execution, this process type closes the current popup window.
   Run On Demand Process	Creates an application-level process that can only be executed when called from a specific page. When you create this process type at the page-level, you are creating reference to an existing application-level process. See Also: "About On Demand Application Processes"

   
   

4. Follow the on-screen instructions.