eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CZ_UIOA_PVT dependencies on CZ_LOCALIZED_TEXTS

Line 5632: FOR k IN(SELECT * FROM CZ_LOCALIZED_TEXTS

5628: IF l_id IS NOT NULL THEN
5629:
5630: l_new_intl_text_id := NULL;
5631:
5632: FOR k IN(SELECT * FROM CZ_LOCALIZED_TEXTS
5633: WHERE intl_text_id=l_id AND seeded_flag=G_NO_FLAG
5634: AND deleted_flag=G_NO_FLAG)
5635: LOOP
5636: IF l_new_intl_text_id IS NULL THEN

Line 5639: INSERT INTO CZ_LOCALIZED_TEXTS

5635: LOOP
5636: IF l_new_intl_text_id IS NULL THEN
5637: l_new_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
5638: END IF;
5639: INSERT INTO CZ_LOCALIZED_TEXTS
5640: (
5641: LOCALE_ID
5642: ,LOCALIZED_STR
5643: ,INTL_TEXT_ID

Line 5903: FOR k IN(SELECT * FROM CZ_LOCALIZED_TEXTS

5899: IF l_id IS NOT NULL THEN
5900:
5901: l_new_intl_text_id := NULL;
5902:
5903: FOR k IN(SELECT * FROM CZ_LOCALIZED_TEXTS
5904: WHERE intl_text_id=l_id AND seeded_flag=G_NO_FLAG
5905: AND deleted_flag=G_NO_FLAG)
5906: LOOP
5907: IF l_new_intl_text_id IS NULL THEN

Line 5910: INSERT INTO CZ_LOCALIZED_TEXTS

5906: LOOP
5907: IF l_new_intl_text_id IS NULL THEN
5908: l_new_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
5909: END IF;
5910: INSERT INTO CZ_LOCALIZED_TEXTS
5911: (
5912: LOCALE_ID
5913: ,LOCALIZED_STR
5914: ,INTL_TEXT_ID

Line 6544: UPDATE CZ_LOCALIZED_TEXTS

6540: AND deleted_flag = G_NO_FLAG)
6541: LOOP
6542: IF l_element_ids_tbl.EXISTS(i.ui_page_element_id) THEN
6543: DEBUG('asp: Updating intl_text ' || i.intl_text_id || ' for element_id ' || i.ui_page_element_id);
6544: UPDATE CZ_LOCALIZED_TEXTS
6545: SET ui_page_id = p_ui_node.page_id
6546: WHERE intl_text_id = i.intl_text_id;
6547: END IF;
6548: END LOOP;

Line 16948: UPDATE CZ_LOCALIZED_TEXTS

16944: FOR i IN g_caption_attr_tbl.First..g_caption_attr_tbl.Last
16945: LOOP
16946: l_persistent_id := TO_NUMBER(get_User_Attribute(l_user_attribute_value,g_caption_attr_tbl(i)));
16947: IF l_persistent_id IS NOT NULL THEN
16948: UPDATE CZ_LOCALIZED_TEXTS
16949: SET deleted_flag=G_YES_FLAG
16950: WHERE persistent_intl_text_id=l_persistent_id AND
16951: ui_def_id=p_ui_def_id AND
16952: seeded_flag=G_NO_FLAG;

Line 17811: -- in tables CZ_LOCALIZED_TEXTS and CZ_RULES which have seeded_flag='0'.

17807: --
17808: -- This procedure sets/propogates deleted_flag='1' from a given UI element to its subtree in CZ_UI_PAGE_ELEMENTS table.
17809: -- Also the procedure parses the corresponding XML to collect all caption intl_text_ids, UI condtion rules ids of
17810: -- deleted UI elements and then performs a soft delete ( set deleted_flag='1' ) of corresponding records
17811: -- in tables CZ_LOCALIZED_TEXTS and CZ_RULES which have seeded_flag='0'.
17812: -- If parameter p_delete_xml = '1' then it also deletes a corresponding XML elements.
17813: --
17814: PROCEDURE delete_UI_Subtree(p_ui_def_id IN NUMBER,
17815: p_ui_page_id IN NUMBER,

Line 17888: UPDATE CZ_LOCALIZED_TEXTS

17884: FROM CZ_UI_PAGE_REFS
17885: WHERE ui_def_id=p_ui_def_id AND target_page_id=p_ui_page_id AND deleted_flag=G_NO_FLAG)
17886: LOOP
17887:
17888: UPDATE CZ_LOCALIZED_TEXTS
17889: SET deleted_flag=G_YES_FLAG
17890: WHERE persistent_intl_text_id=i.caption_text_id AND
17891: ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;
17892:

Line 17931: UPDATE CZ_LOCALIZED_TEXTS

17927: WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG
17928: RETURNING caption_text_id,caption_rule_id,display_condition_id,enabled_condition_id
17929: INTO l_caption_text_id,l_caption_rule_id,l_display_condition_id,l_enabled_condition_id;
17930:
17931: UPDATE CZ_LOCALIZED_TEXTS
17932: SET deleted_flag=G_YES_FLAG
17933: WHERE intl_text_id=l_caption_text_id AND ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;
17934:
17935: UPDATE CZ_RULES

Line 17958: UPDATE CZ_LOCALIZED_TEXTS

17954: ui_page_element_id=l_element_id_tbl(i) AND
17955: deleted_flag=G_NO_FLAG AND seeded_flag=G_NO_FLAG;
17956:
17957: FORALL i IN l_element_id_tbl.First..l_element_id_tbl.Last
17958: UPDATE CZ_LOCALIZED_TEXTS
17959: SET deleted_flag=G_YES_FLAG
17960: WHERE ui_def_id=p_ui_def_id AND
17961: ui_page_id=p_ui_page_id AND
17962: ui_page_element_id=l_element_id_tbl(i) AND

Line 18032: -- in tables CZ_LOCALIZED_TEXTS and CZ_RULES which have seeded_flag='0' and deletes the corresponding XML/JRAD document.

18028: --
18029: -- This procedure sets/propogates deleted_flag='1' from a given UI page to all related UI entities which belong to this page,
18030: -- parses the corresponding XML to collect all caption intl_text_ids, UI condtion rules ids of
18031: -- deleted UI elements and then performs a soft delete ( set deleted_flag='1' ) of corresponding records
18032: -- in tables CZ_LOCALIZED_TEXTS and CZ_RULES which have seeded_flag='0' and deletes the corresponding XML/JRAD document.
18033: --
18034: PROCEDURE delete_UI_Page(p_ui_def_id IN NUMBER, -- ui_def_id of UI
18035: p_ui_page_id IN NUMBER, -- page_id of
18036: -- UI page which needs

Line 18177: -- Delete of corresponding records in CZ_LOCALIZED_TEXTS

18173: --
18174: -- For a given Local Template specified by parameters p_template_id and p_ui_def_id this procedure performs a soft deletion
18175: -- ( sets deleted_flag='1' ) of corresponding CZ_UI_TEMPLATES record and deletes the corresponding JRAD/XML document.
18176: -- It parses the corresponding XML to collect all caption intl_text_ids and UI Condition Ids and performs soft
18177: -- Delete of corresponding records in CZ_LOCALIZED_TEXTS
18178: -- and CZ_RULES which have seeded_flag='0'
18179: --
18180: PROCEDURE delete_Local_Template(p_template_ui_def_id IN NUMBER, -- ui_def_id of UI
18181: p_template_id IN NUMBER, -- template_id of