I have a huge number of iExpense Reports which are pending for the user approval. I am using the following code to Reject all such reports:
wf_notification.setattrtext ( nid => :notification_id
, aname => 'RESULT'
, avalue => 'REJECT' );
wf_notification.respond ( nid => :notification_id );
when I query the notification table after running the above code, the status of the notification is "CLOSED" but the expense report is still waiting for approval.Further more the user who created the report never gets to be notified that his report is rejected.
Am I missing anything any help would be appreciated.