Core Workflow - EBS (MOSC)

MOSC Banner

Query Result as a Table in WF FYI Notification

edited Jul 1, 2016 5:04AM in Core Workflow - EBS (MOSC) 1 commentAnswered

Hello,

I have a business requirement to list employees who were terminated in a particular period of time in a WF notification, I have used the below procedure, but I would like to replace the V_MESSAGE_LINE with a query result, i.e. a table.

Could anyone help me please?

DECLARE

   V_NOTIFICATION_ID   NUMBER := NULL;

   V_FROM_USER_NAME    VARCHAR2 (500) := 'SYSADMIN';

   L_TO_USER_NAME      VARCHAR2 (500) := 'SHATHA-TEST01';

   V_SUBJECT_LINE      VARCHAR2 (500) := 'Testing WF Notifications';

   V_MESSAGE_LINE      VARCHAR2 (500) := 'Hello';

BEGIN

  

   V_NOTIFICATION_ID      :=

      WF_NOTIFICATION.SEND (UPPER (L_TO_USER_NAME),

                            'CS_MSGS',

                            'EXPANDED_FYI_MSG');

   WF_NOTIFICATION.SETATTRTEXT (V_NOTIFICATION_ID,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center