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_XML dependencies on CZ_UI_PAGE_ELEMENTS

Line 1375: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;

1371:
1372: PROCEDURE reconstruct_Parent_Elements(p_xml_node xmldom.DOMNode) IS
1373:
1374: l_parent_node xmldom.DOMNode;
1375: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
1376: l_user_attribute4_value VARCHAR2(32000);
1377: l_node_name VARCHAR2(32000);
1378:
1379: BEGIN

Line 1389: FOR n IN(SELECT element_id FROM CZ_UI_PAGE_ELEMENTS

1385: l_element_id := get_Attribute_Value(l_parent_node, G_ID_ATTRIBUTE);
1386:
1387: IF l_element_id IS NOT NULL AND l_element_id<>G_NULL_VALUE AND xmldom.getNodeName(l_parent_node)<>'#document'THEN
1388:
1389: FOR n IN(SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
1390: WHERE ui_def_id=p_ui_def_id AND
1391: page_id=p_page_id AND
1392: element_id=l_element_id AND deleted_flag='0')
1393: LOOP

Line 1394: UPDATE CZ_UI_PAGE_ELEMENTS

1390: WHERE ui_def_id=p_ui_def_id AND
1391: page_id=p_page_id AND
1392: element_id=l_element_id AND deleted_flag='0')
1393: LOOP
1394: UPDATE CZ_UI_PAGE_ELEMENTS
1395: SET parent_element_id=l_element_id
1396: WHERE ui_def_id=p_ui_def_id AND
1397: page_id=p_page_id AND
1398: element_id=p_element_id;

Line 1419: UPDATE CZ_UI_PAGE_ELEMENTS

1415:
1416: IF NOT(xmldom.IsNull(l_xml_node)) THEN
1417: reconstruct_Parent_Elements(l_xml_node);
1418: ELSE
1419: UPDATE CZ_UI_PAGE_ELEMENTS
1420: SET deleted_flag='1'
1421: WHERE ui_def_id=p_ui_def_id AND
1422: page_id=p_page_id AND
1423: element_id=p_element_id AND

Line 1446: FROM cz_ui_page_elements a

1442:
1443: l_xmldoc := parse_JRAD_Document(i.jrad_doc);
1444:
1445: FOR j IN(SELECT element_id
1446: FROM cz_ui_page_elements a
1447: WHERE a.ui_def_id=p_ui_def_id AND a.page_id=i.page_id AND a.deleted_flag='0' AND
1448: a.parent_element_id IS NOT NULL AND
1449: EXISTS(SELECT NULL FROM CZ_RP_ENTRIES d
1450: WHERE d.object_id IN(SELECT e.devl_project_id FROM CZ_UI_DEFS e

Line 1457: NOT EXISTS(SELECT NULL FROM cz_ui_page_elements b WHERE b.ui_def_id=p_ui_def_id AND

1453: d.deleted_flag='0') AND
1454: EXISTS(SELECT NULL FROM CZ_UI_PAGES c
1455: WHERE c.page_id=i.page_id AND c.ui_def_id=p_ui_def_id AND
1456: c.deleted_flag='0') AND
1457: NOT EXISTS(SELECT NULL FROM cz_ui_page_elements b WHERE b.ui_def_id=p_ui_def_id AND
1458: b.page_id=i.page_id AND b.element_id=NVL(a.parent_element_id,'0')))
1459: LOOP
1460: restore_Elements_Hierarchy(l_xmldoc, p_ui_def_id, i.page_id, j.element_id);
1461: END LOOP;

Line 1797: SELECT element_id BULK COLLECT INTO l_arr_tbl FROM CZ_UI_PAGE_ELEMENTS

1793: TYPE arr_tbl_type IS TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
1794: l_arr_tbl arr_tbl_type;
1795: BEGIN
1796:
1797: SELECT element_id BULK COLLECT INTO l_arr_tbl FROM CZ_UI_PAGE_ELEMENTS
1798: WHERE ui_def_id=p_ui_def_id AND deleted_flag='0';
1799:
1800: IF l_arr_tbl.COUNT>0 THEN
1801: FOR i IN l_arr_tbl.First..l_arr_tbl.Last

Line 1821: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;

1817:
1818: l_error_message VARCHAR2(32000);
1819: l_error BOOLEAN;
1820: l_xmldoc xmldom.DOMDocument;
1821: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
1822: l_xml_node xmldom.DOMNode;
1823: l_nodeslist xmldom.DOMNodeList;
1824: l_empty_xml_node xmldom.DOMNode;
1825: l_length NUMBER;

Line 1830: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;

1826: l_attribute_value VARCHAR2(32000);
1827: l_id_attribute_value VARCHAR2(32000);
1828: l_ui_elements_tbl ui_tbl_type;
1829: l_seq_nbr NUMBER;
1830: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
1831: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
1832: l_ui_def_id NUMBER;
1833:
1834: FUNCTION find_Parent_UI_Element(p_xml_node xmldom.DOMNode) RETURN VARCHAR2 IS

Line 1831: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;

1827: l_id_attribute_value VARCHAR2(32000);
1828: l_ui_elements_tbl ui_tbl_type;
1829: l_seq_nbr NUMBER;
1830: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
1831: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
1832: l_ui_def_id NUMBER;
1833:
1834: FUNCTION find_Parent_UI_Element(p_xml_node xmldom.DOMNode) RETURN VARCHAR2 IS
1835:

Line 1836: l_ui_element CZ_UI_PAGE_ELEMENTS.element_id%TYPE;

1832: l_ui_def_id NUMBER;
1833:
1834: FUNCTION find_Parent_UI_Element(p_xml_node xmldom.DOMNode) RETURN VARCHAR2 IS
1835:
1836: l_ui_element CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
1837:
1838: PROCEDURE get_Parent_XML(p_check_xml_node xmldom.DOMNode) IS
1839:
1840: l_parent_xml_node xmldom.DOMNode;

Line 1941: SELECT * INTO l_ui_node FROM CZ_UI_PAGE_ELEMENTS

1937: l_parent_element_id := find_Parent_UI_Element(l_xml_node);
1938:
1939: IF l_parent_element_id <> l_id_attribute_value AND l_attribute_value IS NOT NULL AND l_attribute_value <> G_NULL_VALUE THEN
1940:
1941: SELECT * INTO l_ui_node FROM CZ_UI_PAGE_ELEMENTS
1942: WHERE ui_def_id=i.ui_def_id AND page_id=j.page_id AND element_id=l_parent_element_id;
1943:
1944: SELECT CZ_UI_PAGE_ELEMENTS_S.NEXTVAL INTO l_element_id FROM dual;
1945:

Line 1944: SELECT CZ_UI_PAGE_ELEMENTS_S.NEXTVAL INTO l_element_id FROM dual;

1940:
1941: SELECT * INTO l_ui_node FROM CZ_UI_PAGE_ELEMENTS
1942: WHERE ui_def_id=i.ui_def_id AND page_id=j.page_id AND element_id=l_parent_element_id;
1943:
1944: SELECT CZ_UI_PAGE_ELEMENTS_S.NEXTVAL INTO l_element_id FROM dual;
1945:
1946: FOR templ IN(SELECT template_id,template_name FROM CZ_UI_TEMPLATES
1947: WHERE ui_def_id=0 AND jrad_doc=l_attribute_value AND deleted_flag='0')
1948: LOOP

Line 1949: SELECT NVL(max(seq_nbr),0)+1 INTO l_seq_nbr FROM CZ_UI_PAGE_ELEMENTS

1945:
1946: FOR templ IN(SELECT template_id,template_name FROM CZ_UI_TEMPLATES
1947: WHERE ui_def_id=0 AND jrad_doc=l_attribute_value AND deleted_flag='0')
1948: LOOP
1949: SELECT NVL(max(seq_nbr),0)+1 INTO l_seq_nbr FROM CZ_UI_PAGE_ELEMENTS
1950: WHERE ui_def_id=i.ui_def_id AND
1951: page_id=j.page_id AND
1952: parent_element_id=l_parent_element_id AND
1953: deleted_flag='0';

Line 1955: INSERT INTO CZ_UI_PAGE_ELEMENTS

1951: page_id=j.page_id AND
1952: parent_element_id=l_parent_element_id AND
1953: deleted_flag='0';
1954:
1955: INSERT INTO CZ_UI_PAGE_ELEMENTS
1956: (
1957: UI_DEF_ID
1958: ,PAGE_ID
1959: ,PERSISTENT_NODE_ID