The \u00a0below script can be used to auto approve notifications through database procedure.<\/p>\n
Write your business logic with in the below procedure ,register it as a concurrent program and schedule it as needed to run periodically. The same script can also be used in custom forms, custom or third party applications to respond to notifications from backend procedure.<\/p>\n
The \u00a0below script can be used to auto approve notifications through database procedure. Write your business logic with in the below procedure ,register it as a concurrent program and schedule it as needed to run periodically. The same script can also be used in custom forms, custom or third party applications to respond to notifications from backend procedure.<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,499],"tags":[],"class_list":["post-11355","post","type-post","status-publish","format-standard","hentry","category-scripts","category-workflow-scripts"],"yoast_head":"\n PROCEDURE approve_reject_proc (pAction IN VARCHAR2, --APPROVE\/REJECT
\npComments IN VARCHAR2, -- User Comments -- Optional
\npNotification_id IN NUMBER, -- Notification ID
\npStatus OUT VARCHAR2,
\npMessage OUT VARCHAR2
\n)
\nIS
\nl_user_name VARCHAR2(250);
\nBEGIN
\nBEGIN
\nSELECT RECIPIENT_ROLE
\nINTO l_user_name
\nFROM WF_NOTIFICATIONS
\nWHERE notification_id = pNotification_id;
\nEXCEPTION
\nWHEN OTHERS THEN
\nl_user_name := NULL;
\nEND;
\nwf_notification.SETATTRTEXT(pNotification_id,'RESULT',pAction);
\nwf_notification.Respond(pNotification_id,
\npComments,
\nl_user_name,
\npAction);
\npStatus := 'S';
\npMessage := 'Successfully '||initcap(pAction);
\nCOMMIT;
\nEXCEPTION
\nWHEN OTHERS THEN
\npStatus := 'E';
\npMessage := 'Unexpected error while Approve\/Reject the notification: '||SQLERRM;
\nEND approve_reject_proc;
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"