Combine triggers for oracle apex logic

  1. vinipathak

    vinipathak Starter

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Delhi
    Hi,

    I need to create dynamic approval workflow so i have created triggers for that.
    However i need to combine these/make the logic dynamic.
    Trigger 1 sends email to first approver for approval.
    When the approver logs in to approve, set p_it_issues.APPROVE_THIS='Y', the next trigger sets p_it_issues.approved=1 to show it has passed first level. ANd with this second trigger sends email notification to second approver as well. (all code mentioned below for reference).
    However in this app, the approval levels could be dynamic, for one dept there could be 2 approvers and for another there could be 3.
     
    Last edited: May 5, 2020