procedure GetRoleInfo2 (Role in varchar2, Role_Info_Tbl out wf_directory.wf_local_roles_tbl_type);
Returns the following information about a role in a PL/SQL table:
Name
Display name
Description
Notification preference ('QUERY', 'MAILTEXT', 'MAILHTML', 'MAILATTH', 'MAILHTM2', 'DISABLED', 'SUMMARY', or 'SUMHTML')
E-mail address
Fax
Status
Expiration date
Originating system
Originating system ID
Parent originating system
Parent originating system ID
Owner tag
NLS parameters, including language, territory, date format, date language, calendar, numeric characters, sort, and currency
Standard Who columns
Note: For roles that are Oracle E-Business Suite 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 E-Business Suite 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.
Additionally, for roles that are Oracle E-Business Suite users marked with an originating system of FND_USR or PER, the GetRoleInfo2() procedure obtains the remaining NLS parameters from the following profile options:
Date format - ICX: Date format mask profile option
Date language - ICX: Date language profile option
Calendar - FND: Forms User Calendar profile option
Numeric characters - ICX: Numeric characters profile option
Sort - ICX: NLS Sort profile option
Currency - ICX: Preferred Currency profile option
For roles that are not Oracle E-Business Suite users, the procedure returns the language and territory values from the Oracle Workflow directory service and the remaining NLS parameters from the default system-level values.
| role | A valid role name. |