Posted by : Akshay Patil Tuesday, 10 March 2015

Application Process is a PL/SQL Anonymous Block that can be called on various events like.


  • On Load : Before Header (Page Template Header)
  • On Load : after Header (Page Template Header)
  • On Load : Before "Body" (Regions)
  • On Load : after "Body" (Regions)
  • On Load : Before Footer (Page Template Footer)
  • On Load : after Footer (Page Template Footer)
  • On submit : after Page Submission - Before computations and validations.
  • On submit : after Page Submission - after computations and validations.
  • On New Instance (New Session)
  • On Demand : Run this Application Process when requested by a page Process (call from Java Script)


The reason behind using Application Process is to avoid repeated code in PL/SQL Process so that we can define the process at application level and can call it at any events mentioned above whenever its needed.

For Example : You have such requirement that to perform some transaction in database whenever page is getting load.

To define Application Process:

  1. Go to Application Builder --> Application --> Shared Components --> select Application Processes from Logic Section as shown below
  2. Once you click on Application Process , wizard will appear as shown below.
    You can define Process by specifying name, event and writing PL/SQL Code in Source section that comes after.




Leave a Reply

Subscribe to Posts | Subscribe to Comments

Welcome to My Blog

Study Basics

Oracle APEX Oracle SQL Oracle PL/SQL

Popular Post

Blogger templates

Total Pageviews

Powered by Blogger.

Unordered List

Follow us on Facebook!

- Copyright © TechnicalBits -Robotic Notes- Powered by Blogger - Designed by Johanes Djogan -