APPS.CZ_XML dependencies on CZ_UI_PAGES

Line 1073: FOR j IN(SELECT jrad_doc,NAME FROM CZ_UI_PAGES

1069: WHERE deleted_flag='0' AND
1070: ui_style=G_OA_STYLE_UI AND seeded_flag='0')
1071: LOOP
1072: l_flag := FALSE;
1073: FOR j IN(SELECT jrad_doc,NAME FROM CZ_UI_PAGES
1074: WHERE ui_def_id=i.ui_def_id AND deleted_flag='0')
1075: LOOP
1076: handle_Doc_Bad_Attributes
1077: (p_doc_full_name => j.jrad_doc,

Line 1097: FOR j IN(SELECT jrad_doc,NAME FROM CZ_UI_PAGES

1093: FROM CZ_UI_DEFS
1094: WHERE ui_def_id=p_ui_def_id AND deleted_flag='0' AND
1095: ui_style=G_OA_STYLE_UI AND seeded_flag='0')
1096: LOOP
1097: FOR j IN(SELECT jrad_doc,NAME FROM CZ_UI_PAGES
1098: WHERE ui_def_id=i.ui_def_id AND deleted_flag='0')
1099: LOOP
1100: l_bad_attributes_detected := FALSE;
1101: handle_Doc_Bad_Attributes

Line 1124: FOR j IN(SELECT jrad_doc,page_id,NAME FROM CZ_UI_PAGES

1120: FROM CZ_UI_DEFS
1121: WHERE deleted_flag='0' AND
1122: ui_style=G_OA_STYLE_UI AND seeded_flag='0')
1123: LOOP
1124: FOR j IN(SELECT jrad_doc,page_id,NAME FROM CZ_UI_PAGES
1125: WHERE ui_def_id=i.ui_def_id AND deleted_flag='0')
1126: LOOP
1127: handle_Bad_Element_Ids(p_doc_full_name => j.jrad_doc,
1128: p_ui_def_id => j.page_id,

Line 1149: FOR j IN(SELECT jrad_doc,page_id,NAME FROM CZ_UI_PAGES

1145: FROM CZ_UI_DEFS
1146: WHERE ui_def_id=p_ui_def_id AND deleted_flag='0' AND
1147: ui_style=G_OA_STYLE_UI AND seeded_flag='0')
1148: LOOP
1149: FOR j IN(SELECT jrad_doc,page_id,NAME FROM CZ_UI_PAGES
1150: WHERE ui_def_id=i.ui_def_id AND deleted_flag='0')
1151: LOOP
1152: handle_Bad_Element_Ids(p_doc_full_name => j.jrad_doc,
1153: p_ui_def_id => j.page_id,

Line 1316: FOR i IN(SELECT * FROM CZ_UI_PAGES WHERE ui_def_id=p_ui_def_id AND deleted_flag='0')

1312:
1313: BEGIN
1314: Open_Parser();
1315:
1316: FOR i IN(SELECT * FROM CZ_UI_PAGES WHERE ui_def_id=p_ui_def_id AND deleted_flag='0')
1317: LOOP
1318: BEGIN
1319: l_xmldoc := parse_JRAD_Document(i.jrad_doc);
1320: Save_Document(p_xml_doc => l_xmldoc,

Line 1439: FOR i IN(SELECT page_id, jrad_doc FROM CZ_UI_PAGES

1435: l_xmldoc xmldom.DOMDocument;
1436:
1437: BEGIN
1438:
1439: FOR i IN(SELECT page_id, jrad_doc FROM CZ_UI_PAGES
1440: WHERE ui_def_id=p_ui_def_id AND deleted_flag='0')
1441: LOOP
1442:
1443: l_xmldoc := parse_JRAD_Document(i.jrad_doc);

Line 1454: EXISTS(SELECT NULL FROM CZ_UI_PAGES c

1450: WHERE d.object_id IN(SELECT e.devl_project_id FROM CZ_UI_DEFS e
1451: WHERE e.ui_def_id=p_ui_def_id AND
1452: e.deleted_flag='0') AND d.object_type='PRJ' 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')))

Line 1634: FOR i IN(SELECT jrad_doc FROM CZ_UI_PAGES

1630:
1631: END LOOP;
1632:
1633: ELSE -- UIs
1634: FOR i IN(SELECT jrad_doc FROM CZ_UI_PAGES
1635: WHERE ui_def_id=p_ui_def_id AND deleted_flag='0')
1636: LOOP
1637:
1638: l_xmldoc := parse_JRAD_Document(i.jrad_doc);

Line 1912: FOR j IN(SELECT * FROM CZ_UI_PAGES WHERE ui_def_id=i.ui_def_id AND deleted_flag='0')

1908:
1909: l_ui_elements_tbl.DELETE;
1910: cache_UI_elements(i.ui_def_id, l_ui_elements_tbl);
1911:
1912: FOR j IN(SELECT * FROM CZ_UI_PAGES WHERE ui_def_id=i.ui_def_id AND deleted_flag='0')
1913: LOOP
1914: BEGIN
1915: jdr_docbuilder.REFRESH;
1916: l_xmldoc := parse_JRAD_Document(j.jrad_doc);