This content has been marked as final. Show 3 replies
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...