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. |
If no translation is found, NULL is returned.
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.
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation