Previous	Next		Contents	Index	Glossary

procedure GetRoleInfo2

    (Role in varchar2,

    Role_Info_Tbl out wf_directory.wf_local_roles_tbl_type);

Description

Returns the following information about a role in a PL/SQL table:

• Name

• Display name

• Description

• Notification preference ('QUERY', 'MAILTEXT', 'MAILHTML', 'MAILATTH', 'MAILHTM2', 'SUMMARY', or, for Oracle Applications only, 'SUMHTML')

• Language

• Territory

• E-mail address

• Fax

• Status

• Expiration date

• Originating system

• Originating system ID

• Parent originating system

• Parent originating system ID

• Owner tag

• Standard Who columns

Note: In Oracle Applications, for roles that are Oracle Applications users marked with an originating system of FND_USR or PER, the GetRoleInfo2() procedure by default retrieves the language and territory values from the ICX: Language and ICX: Territory profile options for that Oracle Applications user.

However, if the WF_PREFERENCE resource token is defined and set to FND, then the GetRoleInfo2() procedure obtains the language and territory values from the Oracle Workflow preferences table instead.

The WF_PREFERENCE resource token is not used in the standalone version of Oracle Workflow.

Arguments (input)

role	A valid role name.