P 2 K_PU.TRANSLATE

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

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