APPS.CZ_XML dependencies on CZ_UI_TEMPLATES

Line 1230: FROM CZ_UI_TEMPLATES

1226: l_bad_attributes_detected BOOLEAN;
1227: BEGIN
1228: IF p_template_id IS NULL THEN
1229: FOR i IN(SELECT jrad_doc,template_name
1230: FROM CZ_UI_TEMPLATES
1231: WHERE deleted_flag='0' AND
1232: seeded_flag='0')
1233: LOOP
1234: handle_Doc_Bad_Attributes

Line 1245: FROM CZ_UI_TEMPLATES

1241: END LOOP;
1242:
1243: ELSE
1244: FOR i IN(SELECT jrad_doc,template_name
1245: FROM CZ_UI_TEMPLATES
1246: WHERE template_id=p_template_id AND
1247: deleted_flag='0' AND
1248: seeded_flag='0')
1249: LOOP

Line 1594: FOR i IN(SELECT jrad_doc FROM CZ_UI_TEMPLATES

1590: l_replaced BOOLEAN;
1591:
1592: BEGIN
1593: IF p_template_id IS NOT NULL AND p_template_id > 0 THEN -- UI Templates
1594: FOR i IN(SELECT jrad_doc FROM CZ_UI_TEMPLATES
1595: WHERE template_id=p_template_id AND ui_def_id IN(0,1) AND seeded_flag='0' AND deleted_flag='0')
1596: LOOP
1597: l_xmldoc := parse_JRAD_Document(i.jrad_doc);
1598:

Line 1750: FOR i IN(SELECT template_id FROM CZ_UI_TEMPLATES WHERE seeded_flag='0' AND deleted_flag='0')

1746: Initialize(x_run_id,x_return_status,x_msg_count,x_msg_data);
1747: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;
1748:
1749: IF p_template_id IS NULL THEN
1750: FOR i IN(SELECT template_id FROM CZ_UI_TEMPLATES WHERE seeded_flag='0' AND deleted_flag='0')
1751: LOOP
1752: Open_Parser();
1753: BEGIN
1754: restore_UI_Rule_ids(p_ui_def_id => NULL, p_template_id => i.template_id);

Line 1763: FOR i IN(SELECT template_id FROM CZ_UI_TEMPLATES

1759: END;
1760: Close_Parser();
1761: END LOOP;
1762: ELSE
1763: FOR i IN(SELECT template_id FROM CZ_UI_TEMPLATES
1764: WHERE template_id=p_template_id AND seeded_flag='0' AND
1765: deleted_flag='0')
1766:
1767: LOOP

Line 1946: FOR templ IN(SELECT template_id,template_name FROM CZ_UI_TEMPLATES

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
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