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_DEFS

Line 1895: SELECT devl_project_id INTO l_devl_project_id FROM CZ_UI_DEFS

1891: IF (i.rule_type IN (RULE_TYPE_DISPLAY_CONDITION,
1892: RULE_TYPE_ENABLED_CONDITION,
1893: RULE_TYPE_CAPTION) AND (p_ui_def_id IS NOT NULL AND p_ui_def_id<>0) AND p_ui_page_id IS NOT NULL) THEN
1894: BEGIN
1895: SELECT devl_project_id INTO l_devl_project_id FROM CZ_UI_DEFS
1896: WHERE ui_def_id=p_ui_def_id AND deleted_flag='0';
1897: EXCEPTION
1898: WHEN NO_DATA_FOUND THEN
1899: RAISE PAGEBASE_NOT_FOUND_EXCP;

Line 3825: TYPE l_tName IS TABLE OF cz_ui_defs.name%TYPE INDEX BY BINARY_INTEGER;

3821: x_msg_count OUT NOCOPY NUMBER,
3822: x_msg_data OUT NOCOPY VARCHAR2)
3823: IS
3824:
3825: TYPE l_tName IS TABLE OF cz_ui_defs.name%TYPE INDEX BY BINARY_INTEGER;
3826:
3827: l_procedure_name CONSTANT VARCHAR2(30) := 'delete_ui_def';
3828:
3829: UIDEF_LOCKED_EXCP EXCEPTION;

Line 3847: l_ui_style cz_ui_defs.ui_style%TYPE;

3843: l_name_tbl l_tName;
3844:
3845: l_model_name_tbl t_varchar_array_tbl_type;
3846: l_devl_project_id cz_ps_nodes.devl_project_id%TYPE;
3847: l_ui_style cz_ui_defs.ui_style%TYPE;
3848: l_seeded_flag cz_ui_defs.seeded_flag%TYPE;
3849: l_uidef_name cz_ui_defs.name%TYPE;
3850:
3851: p_out_err INTEGER;

Line 3848: l_seeded_flag cz_ui_defs.seeded_flag%TYPE;

3844:
3845: l_model_name_tbl t_varchar_array_tbl_type;
3846: l_devl_project_id cz_ps_nodes.devl_project_id%TYPE;
3847: l_ui_style cz_ui_defs.ui_style%TYPE;
3848: l_seeded_flag cz_ui_defs.seeded_flag%TYPE;
3849: l_uidef_name cz_ui_defs.name%TYPE;
3850:
3851: p_out_err INTEGER;
3852: p_del_logically INTEGER:=1;

Line 3849: l_uidef_name cz_ui_defs.name%TYPE;

3845: l_model_name_tbl t_varchar_array_tbl_type;
3846: l_devl_project_id cz_ps_nodes.devl_project_id%TYPE;
3847: l_ui_style cz_ui_defs.ui_style%TYPE;
3848: l_seeded_flag cz_ui_defs.seeded_flag%TYPE;
3849: l_uidef_name cz_ui_defs.name%TYPE;
3850:
3851: p_out_err INTEGER;
3852: p_del_logically INTEGER:=1;
3853:

Line 3861: FROM cz_ui_refs r, cz_ui_defs d

3857: -- referencing UI Defs JRAD Style
3858: ---------------------------------
3859: CURSOR l_ref_ui_def_jrad_csr (inUIDefID integer) IS
3860: SELECT DISTINCT r.ui_def_id, d.name
3861: FROM cz_ui_refs r, cz_ui_defs d
3862: WHERE r.ref_ui_def_id = inUIDefID
3863: AND r.ui_def_id = d.ui_def_id
3864: AND d.deleted_flag = '0'
3865: AND r.deleted_flag = '0'

Line 3876: FROM cz_ui_nodes n, cz_ui_defs d

3872: -- referencing UI Defs HTML Style
3873: ---------------------------------
3874: CURSOR l_ref_ui_def_0_csr (inUIDefID integer) IS
3875: SELECT DISTINCT d.ui_def_id, d.name
3876: FROM cz_ui_nodes n, cz_ui_defs d
3877: WHERE n.ui_def_ref_id = inUIDefID
3878: AND n.ui_def_id = d.ui_def_id
3879: AND d.deleted_flag = '0'
3880: AND n.deleted_flag = '0';

Line 3894: FROM cz_ui_defs

3890:
3891: BEGIN
3892: SELECT devl_project_id, seeded_flag, ui_style, name
3893: INTO l_devl_project_id, l_seeded_flag, l_ui_style, l_uidef_name
3894: FROM cz_ui_defs
3895: WHERE ui_def_id = p_ui_def_id;
3896: EXCEPTION
3897: WHEN NO_DATA_FOUND THEN
3898: RAISE INVALID_UIDEF_ID_EXCP;

Line 4007: UPDATE cz_ui_defs

4003: ----------------------------
4004: -- finally delete the ui def
4005: ----------------------------
4006:
4007: UPDATE cz_ui_defs
4008: SET deleted_flag = '1'
4009: WHERE ui_def_id = p_ui_def_id;
4010:
4011: UPDATE CZ_RULES

Line 6190: x_new_ui_def_id := allocateId('CZ_UI_DEFS_S');

6186: INVALID_UIDEF_ID_EXCP EXCEPTION;
6187: l_name cz_rp_entries.name%TYPE;
6188:
6189: BEGIN
6190: x_new_ui_def_id := allocateId('CZ_UI_DEFS_S');
6191: l_name := copy_name(p_ui_def_id,'UMT');
6192: INSERT INTO CZ_UI_DEFS(
6193: UI_DEF_ID
6194: ,DESC_TEXT

Line 6192: INSERT INTO CZ_UI_DEFS(

6188:
6189: BEGIN
6190: x_new_ui_def_id := allocateId('CZ_UI_DEFS_S');
6191: l_name := copy_name(p_ui_def_id,'UMT');
6192: INSERT INTO CZ_UI_DEFS(
6193: UI_DEF_ID
6194: ,DESC_TEXT
6195: ,NAME
6196: ,DEVL_PROJECT_ID

Line 6319: FROM CZ_UI_DEFS

6315: ,OPTION_SORT_ORDER
6316: ,OPTION_SORT_METHOD
6317: ,OPTION_SORT_PROPERTY_ID
6318: ,SHOW_ALL_NODES_FLAG
6319: FROM CZ_UI_DEFS
6320: WHERE ui_def_id = p_ui_def_id;
6321:
6322: IF SQL%ROWCOUNT = 0 THEN
6323: RAISE INVALID_UIDEF_ID_EXCP;

Line 6872: FROM cz_ui_defs ui

6868: SELECT name
6869: BULK
6870: COLLECT
6871: INTO l_ui_name_tbl
6872: FROM cz_ui_defs ui
6873: WHERE from_master_template_id = p_umt_id
6874: AND deleted_flag = '0'
6875: AND seeded_flag <> '1'
6876: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'

Line 6939: UPDATE cz_ui_defs

6935: name = append_name(p_umt_id, 'UMT', name)
6936: WHERE object_id = p_umt_id
6937: AND object_type = 'UMT';
6938:
6939: UPDATE cz_ui_defs
6940: set deleted_flag = '1',
6941: name = append_name(p_umt_id, 'UMT', name)
6942: WHERE ui_def_id = p_umt_id
6943: AND master_template_flag = '1'

Line 7009: FROM cz_ui_defs ui

7005: l_ui_name_tbl.DELETE;
7006: BEGIN
7007: SELECT name name, master_template_flag
7008: BULK COLLECT INTO l_ui_name_tbl, l_mt_flag_tbl
7009: FROM cz_ui_defs ui
7010: WHERE deleted_flag = '0'
7011: AND ui_def_id IN
7012: (SELECT ui_def_id
7013: FROM cz_ui_cont_type_templs

Line 8166: FROM cz_ui_defs

8162: SELECT name
8163: BULK
8164: COLLECT
8165: INTO l_ui_name_tbl
8166: FROM cz_ui_defs
8167: WHERE cz_ui_defs.from_master_template_id = l_umt_ref(modelId)
8168: AND cz_ui_defs.deleted_flag = '0'
8169: AND cz_ui_defs.seeded_flag <> '1'
8170: --Additional Checks added. Must be a active model

Line 8167: WHERE cz_ui_defs.from_master_template_id = l_umt_ref(modelId)

8163: BULK
8164: COLLECT
8165: INTO l_ui_name_tbl
8166: FROM cz_ui_defs
8167: WHERE cz_ui_defs.from_master_template_id = l_umt_ref(modelId)
8168: AND cz_ui_defs.deleted_flag = '0'
8169: AND cz_ui_defs.seeded_flag <> '1'
8170: --Additional Checks added. Must be a active model
8171: AND EXISTS (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'

Line 8168: AND cz_ui_defs.deleted_flag = '0'

8164: COLLECT
8165: INTO l_ui_name_tbl
8166: FROM cz_ui_defs
8167: WHERE cz_ui_defs.from_master_template_id = l_umt_ref(modelId)
8168: AND cz_ui_defs.deleted_flag = '0'
8169: AND cz_ui_defs.seeded_flag <> '1'
8170: --Additional Checks added. Must be a active model
8171: AND EXISTS (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
8172: AND object_id = cz_ui_defs.devl_project_id AND object_type = 'PRJ');

Line 8169: AND cz_ui_defs.seeded_flag <> '1'

8165: INTO l_ui_name_tbl
8166: FROM cz_ui_defs
8167: WHERE cz_ui_defs.from_master_template_id = l_umt_ref(modelId)
8168: AND cz_ui_defs.deleted_flag = '0'
8169: AND cz_ui_defs.seeded_flag <> '1'
8170: --Additional Checks added. Must be a active model
8171: AND EXISTS (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
8172: AND object_id = cz_ui_defs.devl_project_id AND object_type = 'PRJ');
8173:

Line 8172: AND object_id = cz_ui_defs.devl_project_id AND object_type = 'PRJ');

8168: AND cz_ui_defs.deleted_flag = '0'
8169: AND cz_ui_defs.seeded_flag <> '1'
8170: --Additional Checks added. Must be a active model
8171: AND EXISTS (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
8172: AND object_id = cz_ui_defs.devl_project_id AND object_type = 'PRJ');
8173:
8174: IF (l_ui_name_tbl.count > 0 ) THEN
8175: x_return_status := FND_API.G_RET_STS_ERROR;
8176: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST

Line 8208: FROM cz_ui_defs

8204: SELECT name
8205: BULK
8206: COLLECT
8207: INTO l_ui_name_tbl
8208: FROM cz_ui_defs
8209: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id
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'

Line 8209: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id

8205: BULK
8206: COLLECT
8207: INTO l_ui_name_tbl
8208: FROM cz_ui_defs
8209: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id
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'

Line 8221: AND object_id = cz_ui_defs.devl_project_id AND object_type = 'PRJ')

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:
8224: IF (l_ui_name_tbl.count > 0 ) THEN
8225: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8222: AND cz_ui_defs.deleted_flag = '0';

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:
8224: IF (l_ui_name_tbl.count > 0 ) THEN
8225: x_return_status := FND_API.G_RET_STS_ERROR;
8226: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST