Previous	Next		Contents	Index	Glossary

Message Attribute Table To include a table of message attributes in a message body, call WF_NOTIFICATION() with the ATTRS option followed by the internal names of the message attributes, separated by commas. Use the following format:

WF_NOTIFICATION(ATTRS,<attribute1>,<attribute2>,<attribute3>,...)

Note: You must not include any spaces or carriage returns in the call to WF_NOTIFICATION(). You only need to use a comma to delimit the parameters in the list.

The message attribute table contains a row for each message attribute listed in the WF_NOTIFICATION() call, showing the display name and the value for each attribute.

Notification History Table To include a notification history table in a message body, call WF_NOTIFICATION() with the HISTORY option in the following format:

WF_NOTIFICATION(HISTORY)

The notification history table contains a row for each previous execution of the notification activity in the process, as well as a row for the initial submission of the process. For example, for a requisition approval notification that is sent to several approvers in turn, the notification history table would contain a row for each approver to whom the notification was sent, as well as a row for the process owner.

The notification history table includes the following columns:

• Sequence--The order in which the executions of the notification activity took place, beginning at zero (0) for the initial submission of the process by the process owner.

• Who--The notification recipient or process owner.

• Action--The action with which the recipient responded to the notification.

• Date--The notification date.

• Note--An additional note from the recipient. To allow a recipient to add a note for the notification history table, you must create a special 'Respond' message attribute with the internal name WF_NOTE.

Define the message attribute with the following properties:

• Internal Name--WF_NOTE

• Display Name--Note

• Description--Note

• Type--Text

• Source--Respond

When the WF_NOTE attribute is defined with a source of 'Respond', it appears as part of the notification response section, and the recipient can enter a note there when responding to the notification. The WF_NOTIFICATION() function retrieves the note text stored in the WF_NOTE attribute and displays it in the notification history table.

If the recipient did not enter a note, or if the WF_NOTE message attribute was not defined for the notification, then the Note column in the notification history table is left blank.

Note: The process owner cannot add a note for the notification history table when submitting the process. Only a notification recipient can add a note when responding to the notification.

See Also

To Define a Message Attribute

Copyright © 2002 Oracle Corporation.
All Rights Reserved.