Event Triggers

The Before data trigger and the After data trigger are the two event trigger types.

The Before data trigger is the starting point of the report after submission. The Before data trigger executes the pkg_agg_rpt.f_before_data procedure. You can customize trigger names per your requirements.

The Before data trigger call to the pkg_agg_rpt.f_before_data package passes the following arguments:

  • XDO User name: The user logged in.
  • Template ID: 1 represents PBRER, 2 represents PMAR, and 3 represents DSUR.

You can create multiple Before data triggers, and the system executes them in the arranged order.

The After data type trigger fires after the completion of the Before data triggers. OOTB reports call an empty function in this trigger so that the end user can modify the function.