Workflow is handled automatically at the data base level by the use of a data base trigger.

The trigger is attached to the specific tables where workflow is enabled. The process flow is as follows:

  • When a record is updated/deleted/inserted in a table that has workflow, there is a trigger that fires.
  • This trigger (P2K_xxx_BIUD) sets up internal variables for access by any Workflows and then calls the P2K_PMWRKFLW package for that specific table
  • At this point, each table potentially takes a different course of action, but in general would do the following:
    • Set up variables for User Calcs
    • Set up internal structures for User Calcs
    • Call the RUN_WF_CALC subprogram
    • *Loads user calcs for that product
      • Executes the defined user calcs
Note that there is no specific order that multiple workflow user calcs will fire, so building dependencies between them is not recommended.


Notes #

Click to create a new notes page