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: #

Varchar2

If 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.

---

Notes#

Click to create a new notes page