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.

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 the notification language and the current session language do not match, the procedure does not store any denormalized information. In this case, the viewing interface through which the notification recipients access notifications must check the language and perform the denormalization. The Oracle Workflow Notification Worklist will perform these tasks for you if your users access their notifications through the Worklist web pages.

Arguments (input)

Copyright © 2003 Oracle Corporation.
All rights reserved.