DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_UI_PAGES

Line 1908: FROM cz_ui_pages

1904: -- here we are getting persistent_node_id of base page
1905: --
1906: SELECT persistent_node_id,pagebase_expl_node_id
1907: INTO l_persistent_node_id, l_model_ref_expl_id
1908: FROM cz_ui_pages
1909: WHERE page_id=p_ui_page_id
1910: AND ui_def_id=p_ui_def_id;
1911:
1912: --

Line 4027: UPDATE CZ_UI_PAGES

4023: UPDATE CZ_UI_PAGE_REFS
4024: SET deleted_flag = '1'
4025: WHERE ui_def_id = p_ui_def_id;
4026:
4027: UPDATE CZ_UI_PAGES
4028: SET deleted_flag = '1'
4029: WHERE ui_def_id = p_ui_def_id;
4030:
4031: UPDATE CZ_UI_PAGE_SETS

Line 4039: FOR I in (SELECT JRAD_DOC from CZ_UI_PAGES

4035: UPDATE CZ_UI_PAGE_ELEMENTS
4036: SET deleted_flag = '1'
4037: WHERE ui_def_id = p_ui_def_id;
4038:
4039: FOR I in (SELECT JRAD_DOC from CZ_UI_PAGES
4040: WHERE ui_def_id = p_ui_def_id)
4041: LOOP
4042:
4043: IF jdr_docbuilder.documentexists(i.JRAD_DOC)=TRUE

Line 6747: FROM CZ_UI_PAGES

6743:
6744: BEGIN
6745: SELECT 1
6746: INTO l_ui_pages_count
6747: FROM CZ_UI_PAGES
6748: WHERE property_id = p_property_id
6749: AND deleted_flag = '0';
6750: EXCEPTION
6751: WHEN NO_DATA_FOUND THEN

Line 8130: FROM CZ_UI_PAGES

8126:
8127: BEGIN
8128: SELECT 1
8129: INTO l_ui_pages_count
8130: FROM CZ_UI_PAGES
8131: WHERE property_id = l_prp_ref(modelId)
8132: AND deleted_flag = '0';
8133: EXCEPTION
8134: WHEN NO_DATA_FOUND THEN