Previous	Next		Contents	Index	Glossary

procedure Denormalize_Notification

     (nid in number, 

      username in varchar2 default null, 

      langcode in varchar2 default null);

Description

Stores denormalized values for certain notification fields, including the notification subject, in the WF_NOTIFICATIONS table. If you are using the Notification System to send a notification outside of a workflow process, you must call Denormalize_Notification() after setting the values for any notification attributes, in order to populate the denormalized fields.

Denormalize_Notification() tests whether the language in which the notification should be delivered matches the current session language, and stores the denormalized information according to this setting only if the languages match. You can indicate the language for the notification in a number of ways.

• If you specify a role name when you call the API, the language setting for that role is used to determine the notification language.

• If you do not specify a role name, you can specify a language code for the language you want.

Note: If you specify both a role name and a language code, the role name is used to determine the notification language, and the language code is ignored.

• If you specify neither a role name nor a language code, the notification language defaults to the language setting for the recipient role of the notification.

Arguments (input)

nid	The notification ID.
username	An optional internal name of a role used to determine the notification language.
langcode	An optional language code used to determine the notification language if no role name is provided.