Tuesday 10 March 2015
Application Process is a PL/SQL Anonymous Block that can be called on various events like.
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:
- 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:
- Go to Application Builder --> Application --> Shared Components --> select Application Processes from Logic Section as shown below
- 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.
