Guest Access in PL/SQL (Oracle Workflow Help)

Oracle Workflow Help


	Previous	Next		Contents	Index	Glossary

Guest Access in PL/SQL

Oracle Workflow also provides PL/SQL functions to obtain URLs for guest access to the Administrator Monitor. These functions are defined in the PL/SQL package called WF_MONITOR. See: Workflow Monitor APIs.

WF_MONITOR.GetAdvancedEnvelopeURL( ) - Returns a complete URL for guest access to the Activity History page in the Administrator Monitor.

WF_MONITOR.GetDiagramURL( ) - Returns a complete URL for guest access to the Status Diagram page in the Administrator Monitor.

WF_MONITOR.GetEnvelopeURL( ) - Returns a complete URL for guest access to the Participant Responses page in the Administrator Monitor.

When calling these methods, you must provide the following parameters to indicate how you want to display the Status Monitor:

x_agent - The base Web agent defined for Oracle Applications. Obtain this value from the WF_RESOURCES token named WF_WEB_AGENT by calling WF_CORE.TRANSLATE('WF_WEB_AGENT'). See: TRANSLATE.

x_item_type - The internal name of a workflow item type to automatically query in the Status Monitor.

x_item_key - An item key to automatically query in the Status Monitor.

x_admin_mode - Specify 'YES' to grant administrator privileges to the user accessing the Status Monitor, or 'NO' to withhold administrator privileges from the user. The default is 'NO'.

You can use these URLs to provide access to the Administrator Monitor from a PL/SQL application, for example, or include a URL in a workflow notification message to allow a user to access the Administrator Monitor from the notification.

Note: In Oracle E-Business Suite, you can call the function FND_UTILITIES.OPEN_URL to open a Web browser and have it connect to a specified URL, such as a Status Monitor URL. See: FND_UTILITIES:Utility Routine, Oracle Applications Developer's Guide.

Guest Access from Notifications

You can provide guest access to the Administrator Monitor from a workflow notification. To do so, define a message attribute of type URL, and include or attach this attribute in the notification message. Obtain a guest access URL using one of the WF_MONITOR PL/SQL functions, and set the value of the message attribute to this URL. The user who receives the notification can access the Administrator Monitor by viewing the notification, either through the Worklist Web pages or through an e-mail application, and clicking the link in the message. If users are not already logged into Oracle Applications, they must first log in before they can access the Administrator Monitor from the link. See: To Define a Message Attribute.

Contents

Index

Glossary