This discussion is archived
1 Reply Latest reply: Aug 6, 2012 11:24 PM by 653032 RSS

Approve notifications

653032 Newbie
Currently Being Moderated
Can anybody please tell me I want to use PL/SQL to approve notification like purchase order or purchase requisition. I have written following PL/SQL code for it.

BEGIN
wf_notification.setattrtext ( nid => '7382356' -- notification id for Purchase order
, aname => 'RESULT'
, avalue => 'APPROVED' );
wf_notification.respond ('7382356',NULL,'CHORTON');
COMMIT;
END;

When I approve any purchase order from oracle workflow it approves successfully with activity status as 'complete' and Purchase Order is successfully approved status . But when I execute this PL/SQL code some of the activities has status as 'Active' and Purchase order is not in 'Approved' status but notification status is closed at the end of Approver user.Also I am not able to find error for this. Please let me know where i am going wrong.



Thanks in advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points