Previous	Next		Contents	Index	Glossary

• In Oracle Applications, the tables are created as Oracle Applications Framework regions, unless the message body also includes any message attribute tokens that reference values other than Oracle Applications Framework regions. In this case, the tables are created in a standard Oracle Workflow format. See: Embedding Oracle Applications Framework Regions in Messages.

• In standalone Oracle Workflow, the tables are always created in the standard Oracle Workflow format.

Note: WF_NOTIFICATION() is not a PL/SQL function, but rather a special message function that can only be called within an Oracle Workflow message body.

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.

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

WF_NOTIFICATION(HISTORY)

The action history table contains the standard action history information provided by Oracle Workflow, unless you have defined the #HISTORY attribute for a message in Oracle Applications to use a custom action history region instead. See: Action History and #HISTORY Attribute.

See Also

To Define a Message Attribute