Wf_routing_rules

[vamsioracle]

Hi all

I have a requirement where if a vacation rule is created with delegation to an employee, an automatic mail should be triggered to the person delegated(custom mail).

I tried to capture values of delegation from wf_routin_rules table and create an mail package using utl_smtp. Now where should i call this in my workflow.

Will wf_routing_rules table hold only the delegated/transferred rule details or all the approval routing rules.

Vamsi

[amitpatel66]

There should be a functionality where in an employee submits a vacation request by filling up the form. Now here if the delegation to his manager is specified, then at this point of time your send mail procedure can be fired that will send mail to the employee delegated for approval.

[amitpatel66]

Probably you will need to modify the workflow using workflow builder to add your send mail notification to the employee mentioned in the delegation field

[vamsioracle]

I got the answer.

As soon as we create a vacation rule the details are in wf_routing_rules table. I captured teh role (from address) and the action_argument (to Address) from that table and created a mail using utl_smtp. So, my package is ready. But i am confused where to call this.

My ultimate requirement is , as soon as someone creates a vacation rule, the above pacakge has to be called. So, someone suggest where in workflow i should call this.


vamsi