| Oracle Workflow Guide Release 2.6.2 Part Number A95265-03 |
|
|
|
| |
|
|
||
| Contents | Index | Glossary | Master Index | Feedback |
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. |
| Previous | Next | Contents | Index | Glossary |
