Text and Code Translations#
Functionality:#
This function retrieves text and code translation information as shown on IMLA.Parameters:#
| P_TABLE | Identifies the TABLE_ALIAS that you are translating data for |
| P_COLUMN | Identifies the COLUMN_NAME that you are translating data for |
| P_REF_ID | Identifies the record ID for the table indicated that contains the data to be translated |
| P_LANGUAGE | Optional. The LANGUAGE_CODE that you want to translate to. If not provided, 'FRE'nch will be used. |
| P_COUNTRY | Optional. The COUNTRY_CODE that you are tranlsating data for. If not provided, no country-specific translation is sought. |
| P_ROLE | Optional. The ROLE_NAME that you are translating data for. If not provided, no role-specific translation is sought. |
Returns: #
Varchar2If no translation is found, NULL is returned.
Errors: #
- *NO COUNTRY When the country code provided is invalid
- *NO ROLE When the role name provided is invalid
- *NO LANGUAGE When the language code provided is invalid, or there is some other error retrieving the set of languages
Example: #
P2K_PU.TRANSLATE('DPD','POSITION_TITLE',~)
Will return the translation for the position title, as seen on IDPS, for the French language, for the position detail identified by the ID placed in ~. If there is no translation, NULL is returned
NVL(P2K_PU.TRANSLATE('DPD','POSITION_TITLE',~),POSITION_TITLE)
Will return the translation as above, but if there is no translation, will return the position title. This would be useful in reports.
