Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use WF_NOTIFICATION api to approve the notification?

no4ericJul 6 2011 — edited Jul 11 2011
Hi all,

I want to use PL/SQL to write a script to approve a notification without using Oracle EBS(11.5.10.2). My script is as the followings but the status of the notification is still waiting for approve after commit my script.... Is there any way to resolve this problem?


===================================================
begin
WF_NOTIFICATION.SetAttrText(nid => 7382356, aname => 'RESULT', avalue => 'APPROVED');
commit ;
end ;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2011
Added on Jul 6 2011
6 comments
6,169 views