eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_UI_PAGE_ELEMENTS

Line 4035: UPDATE CZ_UI_PAGE_ELEMENTS

4031: UPDATE CZ_UI_PAGE_SETS
4032: SET deleted_flag = '1'
4033: WHERE ui_def_id = p_ui_def_id;
4034:
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

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

5339: -- 5340: IF ( g_attribute_map.EXISTS(p_attrib_val) ) THEN
5341: l_attrib_val := g_attribute_map(p_attrib_val);
5342: ELSE
5343: SELECT cz_ui_page_elements_s.nextval INTO l_new_seq FROM dual;
5344: l_attrib_val := '_czc'||l_new_seq;
5345: g_attribute_map(p_attrib_val) := l_attrib_val;
5346: END IF;
5347:

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

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

Line 7019: FROM cz_ui_page_elements

7015: AND cz_ui_cont_type_templs.template_ui_def_id = 0
7016: AND cz_ui_cont_type_templs.deleted_flag = '0'
7017: UNION ALL
7018: SELECT ui_def_id
7019: FROM cz_ui_page_elements
7020: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id
7021: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
7022: AND cz_ui_page_elements.deleted_flag = '0')
7023: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'

Line 7020: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id

7016: AND cz_ui_cont_type_templs.deleted_flag = '0'
7017: UNION ALL
7018: SELECT ui_def_id
7019: FROM cz_ui_page_elements
7020: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id
7021: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
7022: AND cz_ui_page_elements.deleted_flag = '0')
7023: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
7024: AND object_id = ui.devl_project_id and object_type = 'PRJ');

Line 7021: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0

7017: UNION ALL
7018: SELECT ui_def_id
7019: FROM cz_ui_page_elements
7020: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id
7021: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
7022: AND cz_ui_page_elements.deleted_flag = '0')
7023: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
7024: AND object_id = ui.devl_project_id and object_type = 'PRJ');
7025: EXCEPTION

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

7018: SELECT ui_def_id
7019: FROM cz_ui_page_elements
7020: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id
7021: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
7022: AND cz_ui_page_elements.deleted_flag = '0')
7023: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
7024: AND object_id = ui.devl_project_id and object_type = 'PRJ');
7025: EXCEPTION
7026: WHEN NO_DATA_FOUND THEN

Line 8214: UNION ALL --Bug#13770170: Added Missing Check for cz_ui_page_elements

8210: FROM cz_ui_cont_type_templs
8211: WHERE cz_ui_cont_type_templs.template_id = l_uct_ref(modelId)
8212: AND cz_ui_cont_type_templs.deleted_flag = '0'
8213: AND cz_ui_cont_type_templs.seeded_flag <> '1'
8214: UNION ALL --Bug#13770170: Added Missing Check for cz_ui_page_elements
8215: SELECT ui_def_id
8216: FROM cz_ui_page_elements
8217: WHERE cz_ui_page_elements.ctrl_template_id = l_uct_ref(modelId)
8218: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0

Line 8216: FROM cz_ui_page_elements

8212: AND cz_ui_cont_type_templs.deleted_flag = '0'
8213: AND cz_ui_cont_type_templs.seeded_flag <> '1'
8214: UNION ALL --Bug#13770170: Added Missing Check for cz_ui_page_elements
8215: SELECT ui_def_id
8216: FROM cz_ui_page_elements
8217: WHERE cz_ui_page_elements.ctrl_template_id = l_uct_ref(modelId)
8218: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
8219: AND cz_ui_page_elements.deleted_flag = '0')
8220: AND EXISTS (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'

Line 8217: WHERE cz_ui_page_elements.ctrl_template_id = l_uct_ref(modelId)

8213: AND cz_ui_cont_type_templs.seeded_flag <> '1'
8214: UNION ALL --Bug#13770170: Added Missing Check for cz_ui_page_elements
8215: SELECT ui_def_id
8216: FROM cz_ui_page_elements
8217: WHERE cz_ui_page_elements.ctrl_template_id = l_uct_ref(modelId)
8218: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
8219: AND cz_ui_page_elements.deleted_flag = '0')
8220: AND EXISTS (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
8221: AND object_id = cz_ui_defs.devl_project_id AND object_type = 'PRJ')

Line 8218: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0

8214: UNION ALL --Bug#13770170: Added Missing Check for cz_ui_page_elements
8215: SELECT ui_def_id
8216: FROM cz_ui_page_elements
8217: WHERE cz_ui_page_elements.ctrl_template_id = l_uct_ref(modelId)
8218: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
8219: AND cz_ui_page_elements.deleted_flag = '0')
8220: AND EXISTS (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
8221: AND object_id = cz_ui_defs.devl_project_id AND object_type = 'PRJ')
8222: AND cz_ui_defs.deleted_flag = '0';

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

8215: SELECT ui_def_id
8216: FROM cz_ui_page_elements
8217: WHERE cz_ui_page_elements.ctrl_template_id = l_uct_ref(modelId)
8218: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
8219: AND cz_ui_page_elements.deleted_flag = '0')
8220: AND EXISTS (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
8221: AND object_id = cz_ui_defs.devl_project_id AND object_type = 'PRJ')
8222: AND cz_ui_defs.deleted_flag = '0';
8223: