!!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|Edit:Internal.P2K_PU.TRANSLATE]
[{InsertPage page='Internal.P2K_PU.TRANSLATE' default='Click to create a new notes page'}]