APPS.CZ_XML dependencies on CZ_UI_DEFS

Line 1068: FROM CZ_UI_DEFS

1064: l_flag BOOLEAN;
1065: BEGIN
1066: IF p_ui_def_id IS NULL THEN
1067: FOR i IN(SELECT ui_def_id,NAME
1068: FROM CZ_UI_DEFS
1069: WHERE deleted_flag='0' AND
1070: ui_style=G_OA_STYLE_UI AND seeded_flag='0')
1071: LOOP
1072: l_flag := FALSE;

Line 1093: FROM CZ_UI_DEFS

1089: END LOOP;
1090:
1091: ELSE
1092: FOR i IN(SELECT ui_def_id,NAME
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

Line 1120: FROM CZ_UI_DEFS

1116: BEGIN
1117: IF p_ui_def_id IS NULL THEN
1118:
1119: FOR i IN(SELECT ui_def_id,NAME
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

Line 1145: FROM CZ_UI_DEFS

1141:
1142: ELSE
1143:
1144: FOR i IN(SELECT ui_def_id,NAME
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

Line 1450: WHERE d.object_id IN(SELECT e.devl_project_id FROM CZ_UI_DEFS e

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

Line 1481: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS WHERE ui_style='7' AND deleted_flag='0' AND seeded_flag='0')

1477: Initialize(x_run_id,x_return_status,x_msg_count,x_msg_data);
1478: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;
1479:
1480: IF p_ui_def_id IS NULL THEN
1481: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS WHERE ui_style='7' AND deleted_flag='0' AND seeded_flag='0')
1482: LOOP
1483: Open_Parser();
1484: BEGIN
1485: restore_Parent_Elements(p_ui_def_id => i.ui_def_id);

Line 1494: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS WHERE ui_style='7' AND deleted_flag='0' AND seeded_flag='0' AND

1490: END;
1491: Close_Parser();
1492: END LOOP;
1493: ELSE
1494: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS WHERE ui_style='7' AND deleted_flag='0' AND seeded_flag='0' AND
1495: ui_def_id IN(
1496: (SELECT ref_ui_def_id
1497: FROM cz_ui_refs
1498: START WITH ui_def_id = p_ui_def_id

Line 1692: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS WHERE ui_style='7' AND seeded_flag='0' AND deleted_flag='0')

1688: Initialize(x_run_id,x_return_status,x_msg_count,x_msg_data);
1689: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;
1690:
1691: IF p_ui_def_id IS NULL THEN
1692: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS WHERE ui_style='7' AND seeded_flag='0' AND deleted_flag='0')
1693: LOOP
1694: Open_Parser();
1695: BEGIN
1696: restore_UI_Rule_ids(p_ui_def_id => i.ui_def_id, p_template_id => NULL);

Line 1711: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS

1707: END;
1708: Close_Parser();
1709: END LOOP;
1710: ELSE
1711: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS
1712: WHERE ui_def_id=p_ui_def_id AND ui_style='7' AND seeded_flag='0' AND
1713: deleted_flag='0')
1714: LOOP
1715: Open_Parser();

Line 1900: FOR i IN(SELECT a.ui_def_id FROM CZ_UI_DEFS a

1896: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;
1897:
1898: Open_Parser();
1899:
1900: FOR i IN(SELECT a.ui_def_id FROM CZ_UI_DEFS a
1901: WHERE a.ui_style='7' AND a.deleted_flag='0' AND
1902: EXISTS(SELECT NULL FROM CZ_RP_ENTRIES b WHERE b.object_id=a.devl_project_id AND
1903: b.object_type='PRJ' AND b.deleted_flag='0')
1904: )