apex_add_app_process
Add an application-level process to execute PL/SQL code on new session, page submit, or login, with configurable conditions and execution order.
Instructions
Create an application-level process (runs on every page load or session init).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| point | No | When to execute: - "ON_NEW_INSTANCE": On new session start — use to initialize session state (default) - "ON_SUBMIT": On every page submit - "BEFORE_LOGIN": Before authentication - "AFTER_LOGIN": After successful login | ON_NEW_INSTANCE |
| sequence | No | Execution order when multiple processes exist. | |
| plsql_body | Yes | PL/SQL anonymous block to execute. Has access to apex_application, apex_util, :APP_* items. | |
| process_name | Yes | Process display name. | |
| condition_expr | No | Item name for the condition. | |
| condition_type | No | Optional condition: - "": Always run (default) - "ITEM_IS_NULL": Run only if item is null - "ITEM_IS_NOT_NULL": Run only if item is not null |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |