PL/SQL Syntax

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 NLS settings according to which the notification should be sent match the NLS settings of the current session, and stores the denormalized information only if these settings match. The procedure tests the following NLS parameters:

• nls_language

• nls_date_format

• nls_date_language

• nls_calendar

• nls_territory

• nls_sort

You can indicate the language setting 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.

For the other NLS parameters, the settings according to which the notification should be sent are those of the recipient role.

If NLS settings for the notification do not match the settings of the current session, the procedure does not store the denormalized information immediately. Instead, it raises the oracle.apps.wf.notification.denormalize event to defer the denormalization. The procedure sets all the NLS parameters into the event attributes so that the full NLS context will be available when the event is processed and the denormalization is performed.

After notifications are sent, the user interface through which notification recipients access notifications should also call this procedure to check the language and perform denormalization if necessary. The Oracle Workflow Worklist performs these tasks for you if your users access their notifications through the Worklist Web pages.

Arguments (input)