Oracle Workflow:Providing Approval/Rejection for a notifcation through API's

Hi All,

Recently i got a requirement to  Overide a work flow  Approval process programmatically

Scenario:Let assume the workflow is pending with supervisor and he is not available to provide approval/rejection a oracle notification.

Possible reasons:
1.users didnt set up vaccation rules
2.Notification is timedout and pending with supervisor manager


One way to handle these scenarios is througth work flow administartor which requires a production incident and it own SLA to resolve.

There are oracle wokflow  notification API' s which allows to set the result of the notification through APIS

--Set all the notification attributes result/any comments attributes on the notification etc
wf_notification.setattrtext (nid      => l_notification_id,
                                           aname    => l_aname,
                                           avalue   => l_avalue);
--API to complete the worklfow node and move it
wf_notification.respond (l_notification_id,
                                  ',
                                 );

This solution is usesful when the oracle approval mechanism need to be handled from third party applications