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.

APPS.CZ_UIOA_PVT dependencies on CZ_LOCALIZED_TEXTS

Line 5867: FOR k IN(SELECT * FROM CZ_LOCALIZED_TEXTS

5863:
5864: l_new_intl_text_id := NULL;
5865: l_persistent_intl_text_id := NULL;
5866:
5867: FOR k IN(SELECT * FROM CZ_LOCALIZED_TEXTS
5868: WHERE intl_text_id=l_id AND seeded_flag=G_NO_FLAG
5869: AND deleted_flag=G_NO_FLAG)
5870: LOOP
5871: l_persistent_intl_text_id_tmp := null;

Line 5875: INSERT INTO CZ_LOCALIZED_TEXTS

5871: l_persistent_intl_text_id_tmp := null;
5872: IF l_new_intl_text_id IS NULL THEN
5873: l_new_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
5874: END IF;
5875: INSERT INTO CZ_LOCALIZED_TEXTS
5876: (
5877: LOCALE_ID
5878: ,LOCALIZED_STR
5879: ,INTL_TEXT_ID

Line 6156: FOR k IN(SELECT * FROM CZ_LOCALIZED_TEXTS

6152:
6153: l_new_intl_text_id := NULL;
6154: l_persistent_intl_text_id := NULL;
6155:
6156: FOR k IN(SELECT * FROM CZ_LOCALIZED_TEXTS
6157: WHERE intl_text_id=l_id AND seeded_flag=G_NO_FLAG
6158: AND deleted_flag=G_NO_FLAG)
6159: LOOP
6160: IF l_new_intl_text_id IS NULL THEN

Line 6164: INSERT INTO CZ_LOCALIZED_TEXTS

6160: IF l_new_intl_text_id IS NULL THEN
6161: l_persistent_intl_text_id_tmp := null;
6162: l_new_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
6163: END IF;
6164: INSERT INTO CZ_LOCALIZED_TEXTS
6165: (
6166: LOCALE_ID
6167: ,LOCALIZED_STR
6168: ,INTL_TEXT_ID

Line 6813: UPDATE CZ_LOCALIZED_TEXTS

6809: AND deleted_flag = G_NO_FLAG)
6810: LOOP
6811: IF l_element_ids_tbl.EXISTS(i.ui_page_element_id) THEN
6812: DEBUG('asp: Updating intl_text ' || i.intl_text_id || ' for element_id ' || i.ui_page_element_id);
6813: UPDATE CZ_LOCALIZED_TEXTS
6814: SET ui_page_id = p_ui_node.page_id
6815: WHERE intl_text_id = i.intl_text_id;
6816: END IF;
6817: END LOOP;

Line 17798: UPDATE CZ_LOCALIZED_TEXTS

17794: FOR i IN g_caption_attr_tbl.First..g_caption_attr_tbl.Last
17795: LOOP
17796: l_persistent_id := TO_NUMBER(get_User_Attribute(l_user_attribute_value,g_caption_attr_tbl(i)));
17797: IF l_persistent_id IS NOT NULL THEN
17798: UPDATE CZ_LOCALIZED_TEXTS
17799: SET deleted_flag=G_YES_FLAG
17800: WHERE persistent_intl_text_id=l_persistent_id AND
17801: ui_def_id=p_ui_def_id AND
17802: seeded_flag=G_NO_FLAG;

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

18713: --
18714: -- This procedure sets/propogates deleted_flag='1' from a given UI element to its subtree in CZ_UI_PAGE_ELEMENTS table.
18715: -- Also the procedure parses the corresponding XML to collect all caption intl_text_ids, UI condtion rules ids of
18716: -- deleted UI elements and then performs a soft delete ( set deleted_flag='1' ) of corresponding records
18717: -- in tables CZ_LOCALIZED_TEXTS and CZ_RULES which have seeded_flag='0'.
18718: -- If parameter p_delete_xml = '1' then it also deletes a corresponding XML elements.
18719: --
18720: PROCEDURE delete_UI_Subtree(p_ui_def_id IN NUMBER,
18721: p_ui_page_id IN NUMBER,

Line 18794: UPDATE CZ_LOCALIZED_TEXTS

18790: FROM CZ_UI_PAGE_REFS
18791: WHERE ui_def_id=p_ui_def_id AND target_page_id=p_ui_page_id AND deleted_flag=G_NO_FLAG)
18792: LOOP
18793:
18794: UPDATE CZ_LOCALIZED_TEXTS
18795: SET deleted_flag=G_YES_FLAG
18796: WHERE persistent_intl_text_id=i.caption_text_id AND
18797: ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;
18798:

Line 18837: UPDATE CZ_LOCALIZED_TEXTS

18833: WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG
18834: RETURNING caption_text_id,caption_rule_id,display_condition_id,enabled_condition_id
18835: INTO l_caption_text_id,l_caption_rule_id,l_display_condition_id,l_enabled_condition_id;
18836:
18837: UPDATE CZ_LOCALIZED_TEXTS
18838: SET deleted_flag=G_YES_FLAG
18839: WHERE intl_text_id=l_caption_text_id AND ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;
18840:
18841: UPDATE CZ_RULES

Line 18864: UPDATE CZ_LOCALIZED_TEXTS

18860: ui_page_element_id=l_element_id_tbl(i) AND
18861: deleted_flag=G_NO_FLAG AND seeded_flag=G_NO_FLAG;
18862:
18863: FORALL i IN l_element_id_tbl.First..l_element_id_tbl.Last
18864: UPDATE CZ_LOCALIZED_TEXTS
18865: SET deleted_flag=G_YES_FLAG
18866: WHERE ui_def_id=p_ui_def_id AND
18867: ui_page_id=p_ui_page_id AND
18868: ui_page_element_id=l_element_id_tbl(i) AND

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

18934: --
18935: -- This procedure sets/propogates deleted_flag='1' from a given UI page to all related UI entities which belong to this page,
18936: -- parses the corresponding XML to collect all caption intl_text_ids, UI condtion rules ids of
18937: -- deleted UI elements and then performs a soft delete ( set deleted_flag='1' ) of corresponding records
18938: -- in tables CZ_LOCALIZED_TEXTS and CZ_RULES which have seeded_flag='0' and deletes the corresponding XML/JRAD document.
18939: --
18940: PROCEDURE delete_UI_Page(p_ui_def_id IN NUMBER, -- ui_def_id of UI
18941: p_ui_page_id IN NUMBER, -- page_id of
18942: -- UI page which needs

Line 19083: -- Delete of corresponding records in CZ_LOCALIZED_TEXTS

19079: --
19080: -- For a given Local Template specified by parameters p_template_id and p_ui_def_id this procedure performs a soft deletion
19081: -- ( sets deleted_flag='1' ) of corresponding CZ_UI_TEMPLATES record and deletes the corresponding JRAD/XML document.
19082: -- It parses the corresponding XML to collect all caption intl_text_ids and UI Condition Ids and performs soft
19083: -- Delete of corresponding records in CZ_LOCALIZED_TEXTS
19084: -- and CZ_RULES which have seeded_flag='0'
19085: --
19086: PROCEDURE delete_Local_Template(p_template_ui_def_id IN NUMBER, -- ui_def_id of UI
19087: p_template_id IN NUMBER, -- template_id of