Previous	Next		Contents	Index	Glossary

procedure GetRoleInfo

    (Role in varchar2,

     Display_Name out varchar2,

     Email_Address out varchar2,

     Notification_Preference out varchar2,

     Language out varchar2, 

     Territory out varchar2);

Description

Returns the following information about a role:

• Display name

• E-mail address

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

• Language

• Territory

Note: In Oracle Applications, for roles that are Oracle Applications users marked with an originating system of FND_USR or PER, the GetRoleInfo() 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 GetRoleInfo() 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.