This content has been marked as final. Show 3 replies
What are your approaches ?
We could suggest best in them.. there could be n number of ways to achieve it.
- Get the plans ready to suit present requirement.
- Estimate the changes in requirement in near future.
- Consider easy deployment when a new change arises.
You can define a looping activity with some maximum count and timeout. Create the wf process such that for each timeout an reminder notification is sent, and after the count reaches maximum, complete the workflow activity.
Another alternative is to make use of db package dba_jobs and create a job to run periodically (weekly or so) and call a procedure that will basically look for those notifications and check the begin_date and so on and then respond to them if it meets your criteria.
You will need to set the result of the response:
WF_NOTIFICATION.SetAttrText(nid => l_nid, aname => 'RESULT', avalue => 'APPROVE'); --or whatever the result is
WF_NOTIFICATION.Respond(nid => l_nid, respond_comment => 'Approved from PLSQL', responder => 'ME', action_source => 'WA');
You get the point...