APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_UI_PAGE_ELEMENTS

Line 4007: UPDATE CZ_UI_PAGE_ELEMENTS

4003: UPDATE CZ_UI_PAGE_SETS
4004: SET deleted_flag = '1'
4005: WHERE ui_def_id = p_ui_def_id;
4006:
4007: UPDATE CZ_UI_PAGE_ELEMENTS
4008: SET deleted_flag = '1'
4009: WHERE ui_def_id = p_ui_def_id;
4010:
4011: FOR I in (SELECT JRAD_DOC from CZ_UI_PAGES

Line 5314: SELECT cz_ui_page_elements_s.nextval INTO l_new_seq FROM dual;

5310: -- 5311: IF ( g_attribute_map.EXISTS(p_attrib_val) ) THEN
5312: l_attrib_val := g_attribute_map(p_attrib_val);
5313: ELSE
5314: SELECT cz_ui_page_elements_s.nextval INTO l_new_seq FROM dual;
5315: l_attrib_val := '_czc'||l_new_seq;
5316: g_attribute_map(p_attrib_val) := l_attrib_val;
5317: END IF;
5318:

Line 5331: SELECT cz_ui_page_elements_s.nextval INTO l_new_seq FROM dual;

5327: -- This case can happen when user:attribute3 is processed before the id attribute
5328: -- We have no control over the order in which these attributes are returned.
5329: -- So this case can occur. Since id is not yet processed we dont have the new id
5330: -- So let us just create a new id for the switcher right now and put it in the map
5331: SELECT cz_ui_page_elements_s.nextval INTO l_new_seq FROM dual;
5332: -- this is the new id attribute value for the switcher.
5333: -- We will put it in the map so that it gets used when processing the id attribute in the
5334: -- first If block in this function
5335: l_attrib_val := '_czc'||l_new_seq;

Line 6990: FROM cz_ui_page_elements

6986: AND cz_ui_cont_type_templs.template_ui_def_id = 0
6987: AND cz_ui_cont_type_templs.deleted_flag = '0'
6988: UNION ALL
6989: SELECT ui_def_id
6990: FROM cz_ui_page_elements
6991: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id
6992: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
6993: AND cz_ui_page_elements.deleted_flag = '0')
6994: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'

Line 6991: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id

6987: AND cz_ui_cont_type_templs.deleted_flag = '0'
6988: UNION ALL
6989: SELECT ui_def_id
6990: FROM cz_ui_page_elements
6991: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id
6992: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
6993: AND cz_ui_page_elements.deleted_flag = '0')
6994: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
6995: AND object_id = ui.devl_project_id and object_type = 'PRJ');

Line 6992: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0

6988: UNION ALL
6989: SELECT ui_def_id
6990: FROM cz_ui_page_elements
6991: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id
6992: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
6993: AND cz_ui_page_elements.deleted_flag = '0')
6994: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
6995: AND object_id = ui.devl_project_id and object_type = 'PRJ');
6996: EXCEPTION

Line 6993: AND cz_ui_page_elements.deleted_flag = '0')

6989: SELECT ui_def_id
6990: FROM cz_ui_page_elements
6991: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id
6992: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
6993: AND cz_ui_page_elements.deleted_flag = '0')
6994: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
6995: AND object_id = ui.devl_project_id and object_type = 'PRJ');
6996: EXCEPTION
6997: WHEN NO_DATA_FOUND THEN