Dynamic Triggers in HRMS

HRMS Dynamic Trigger Generation:

1.       Create a procedure with your custom logic and parameters, make sure p_business_group_id, p_legislation_code are there.

2.       Define the Dynamic Trigger in HRMS Resp, select table, application and above procedure.

3.       Test it.

Example:

1.       (Example only to understand not real time scenario)

2.  HRMS RESP

1.1   Give Name of Trigger (any), Table on which trigger is going to be registered and Action type (ex: Update)

1.2   Save it, it automatically creates Initilisations elements.

1.3   Go to components tab and give module (ur procedure) and save it

1.4   Define parameters (old, new) to be passed to the procedure.

Save it so the parameters button will be enabled.

Test it.

1.       Open any employee record and update it, (not correction) and check the same.

Source:

1.       Basics: http://oracle.anilpassi.com/triggers-in-oracle-hrms-and-payroll.html

2.       Example: Video http://oracle.anilpassi.com/dynamic-triggers-in-hrms-payroll-demo.html