CreateAdHocRole (Oracle Workflow Help)

Oracle Workflow Guide
Release 2.6.2
Part Number A95265-02


	Previous	Next		Contents	Index	Glossary

CreateAdHocRole

Syntax

procedure CreateAdHocRole

     (role_name in out varchar2,
      role_display_name in out varchar2,
      language in varchar2 default null,
      territory in varchar2 default null,
      role_description in varchar2 default null,
      notification_preference in varchar2 default
      'MAILHTML',
      role_users in varchar2 default null,
      email_address in varchar2 default null,
      fax in varchar2 default null,
      status in varchar2 default 'ACTIVE',
      expiration_date in date default sysdate);

Description

Creates a role at runtime by creating a value in the WF_LOCAL_ROLES table. This is referred to as an ad hoc role.

Arguments (input)

role_name An internal name for the role. The name must less than 30 characters long and is all uppercase. This procedure checks that the name provided does not already exist in WF_ROLES and returns an error if the name already exists. If you do not provide an internal name, the system generates an internal name for you where the name contains a prefix of '~WF_ADHOC-' followed by a sequence number.

role_display_name The display name of the role. This procedure checks that the display name provided does not already exist in WF_ROLES and returns an error if the display name already exists. If you do not provide an display name, the system generates one for you where the display name contains a prefix of '~WF_ADHOC-' followed by a sequence number.

language The value of the database NLS_LANGUAGE initialization parameter that specifies the default language-dependent behavior of the user's notification session. If null, the procedure resolves this to the language setting of your current session.

territory The value of the database NLS_TERRITORY initialization parameter that specifies the default territory-dependant date and numeric formatting used in the user's notification session. If null, the procedure resolves this to the territory setting of your current session.

role_description An optional description for the role.

notification_preference Indicate how this role receives notifications: 'MAILTEXT', 'MAILHTML', 'MAILATTH', 'QUERY' or 'SUMMARY'. If null, the procedure sets the notification preference to 'MAILHTML'.

role_users Indicate the names of the users that belong to this role, using commas or spaces to delimit the list.

email_address A optional electronic mail address for this role or a mail distribution list defined by your electronic mail system.

fax An optional Fax number for the role.

status The availability of the role to participate in a workflow process. The possible statuses are ACTIVE, EXTLEAVE, INACTIVE, and TMPLEAVE. If null, the procedure sets the status to 'ACTIVE'.

expiration_date The date at which the role is no longer valid in the directory service. If null, the procedure defaults the expiration date to sysdate.

role_name	An internal name for the role. The name must less than 30 characters long and is all uppercase. This procedure checks that the name provided does not already exist in WF_ROLES and returns an error if the name already exists. If you do not provide an internal name, the system generates an internal name for you where the name contains a prefix of '~WF_ADHOC-' followed by a sequence number.
role_display_name	The display name of the role. This procedure checks that the display name provided does not already exist in WF_ROLES and returns an error if the display name already exists. If you do not provide an display name, the system generates one for you where the display name contains a prefix of '~WF_ADHOC-' followed by a sequence number.
language	The value of the database NLS_LANGUAGE initialization parameter that specifies the default language-dependent behavior of the user's notification session. If null, the procedure resolves this to the language setting of your current session.
territory	The value of the database NLS_TERRITORY initialization parameter that specifies the default territory-dependant date and numeric formatting used in the user's notification session. If null, the procedure resolves this to the territory setting of your current session.
role_description	An optional description for the role.
notification_preference	Indicate how this role receives notifications: 'MAILTEXT', 'MAILHTML', 'MAILATTH', 'QUERY' or 'SUMMARY'. If null, the procedure sets the notification preference to 'MAILHTML'.
role_users	Indicate the names of the users that belong to this role, using commas or spaces to delimit the list.
email_address	A optional electronic mail address for this role or a mail distribution list defined by your electronic mail system.
fax	An optional Fax number for the role.
status	The availability of the role to participate in a workflow process. The possible statuses are ACTIVE, EXTLEAVE, INACTIVE, and TMPLEAVE. If null, the procedure sets the status to 'ACTIVE'.
expiration_date	The date at which the role is no longer valid in the directory service. If null, the procedure defaults the expiration date to sysdate.

CreateAdHocRole

See Also