There are two approaches for translating column titles.
Translate column titles within a LOV using the following statements:
DECLARE
l_column_title m_glossary_details.translated_prompt%TYPE;
l_translated_hint m_glossary_details.translated_hint%TYPE;
l_translated_tooltip m_glossary_details.translated_tooltip%TYPE;
BEGIN
/* First column */
m_pck_dynamic_labels.get_translated_prompt (‘My column title’,
l_column_title,
l_translated_hint,
l_translated_tooltip
);
SET_LOV_COLUMN_PROPERTY (‘my_lov’, 1, TITLE, l_column_title);
/* Second column */
m_pck_dynamic_labels.get_translated_prompt (‘Second column title’,
l_column_title,
l_translated_hint,
l_translated_tooltip
);
SET_LOV_COLUMN_PROPERTY (‘my_lov’, 2, TITLE, l_column_title);
/* Third column */
…
END;
To use a more flexible and dynamic approach, use the entries of the third window of screen A.30.01.
DECLARE
l_order_seq m_appl_menu_lov_details.order_seq%TYPE;
l_column_title m_appl_menu_lov_details.column_title%TYPE;
l_translated_prompt m_glossary_details.translated_prompt%TYPE;
l_translated_hint m_glossary_details.translated_hint%TYPE;
l_translated_tooltip m_glossary_details.translated_tooltip%TYPE;
CURSOR lov_columns IS
SELECT amld.order_seq,
amld.column_title
FROM m_appl_menu_lov_details amld,
m_appl_menu_lovs amlv,
m_appl_menus am
WHERE am.menuitem_code = 'my_menu_item'
AND amlv.menuitem_id = am.menuitem_id
AND amlv.amlv_code = 'my_lov'
AND amld.amlv_id = amlv.amlv_id;
BEGIN
OPEN lov_columns;
FETCH lov_columns INTO l_order_seq,
l_column_title;
WHILE lov_columns%FOUND LOOP
m_pck_dynamic_labels.get_translated_prompt (l_column_title,
l_translated_prompt,
l_translated_hint,
l_translated_tooltip
);
SET_LOV_COLUMN_PROPERTY ('my_lov', l_order_seq, TITLE, l_translated_prompt);
FETCH lov_columns INTO l_order_seq,
l_column_title;
END LOOP;
CLOSE lov_columns;
END;