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 1867: SELECT devl_project_id INTO l_devl_project_id FROM CZ_UI_DEFS

1863: IF (i.rule_type IN (RULE_TYPE_DISPLAY_CONDITION,
1864: RULE_TYPE_ENABLED_CONDITION,
1865: 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
1866: BEGIN
1867: SELECT devl_project_id INTO l_devl_project_id FROM CZ_UI_DEFS
1868: WHERE ui_def_id=p_ui_def_id AND deleted_flag='0';
1869: EXCEPTION
1870: WHEN NO_DATA_FOUND THEN
1871: RAISE PAGEBASE_NOT_FOUND_EXCP;

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

3793: x_msg_count OUT NOCOPY NUMBER,
3794: x_msg_data OUT NOCOPY VARCHAR2)
3795: IS
3796:
3797: TYPE l_tName IS TABLE OF cz_ui_defs.name%TYPE INDEX BY BINARY_INTEGER;
3798:
3799: l_procedure_name CONSTANT VARCHAR2(30) := 'delete_ui_def';
3800:
3801: UIDEF_LOCKED_EXCP EXCEPTION;

Line 3819: l_ui_style cz_ui_defs.ui_style%TYPE;

3815: l_name_tbl l_tName;
3816:
3817: l_model_name_tbl t_varchar_array_tbl_type;
3818: l_devl_project_id cz_ps_nodes.devl_project_id%TYPE;
3819: l_ui_style cz_ui_defs.ui_style%TYPE;
3820: l_seeded_flag cz_ui_defs.seeded_flag%TYPE;
3821: l_uidef_name cz_ui_defs.name%TYPE;
3822:
3823: p_out_err INTEGER;

Line 3820: l_seeded_flag cz_ui_defs.seeded_flag%TYPE;

3816:
3817: l_model_name_tbl t_varchar_array_tbl_type;
3818: l_devl_project_id cz_ps_nodes.devl_project_id%TYPE;
3819: l_ui_style cz_ui_defs.ui_style%TYPE;
3820: l_seeded_flag cz_ui_defs.seeded_flag%TYPE;
3821: l_uidef_name cz_ui_defs.name%TYPE;
3822:
3823: p_out_err INTEGER;
3824: p_del_logically INTEGER:=1;

Line 3821: l_uidef_name cz_ui_defs.name%TYPE;

3817: l_model_name_tbl t_varchar_array_tbl_type;
3818: l_devl_project_id cz_ps_nodes.devl_project_id%TYPE;
3819: l_ui_style cz_ui_defs.ui_style%TYPE;
3820: l_seeded_flag cz_ui_defs.seeded_flag%TYPE;
3821: l_uidef_name cz_ui_defs.name%TYPE;
3822:
3823: p_out_err INTEGER;
3824: p_del_logically INTEGER:=1;
3825:

Line 3833: FROM cz_ui_refs r, cz_ui_defs d

3829: -- referencing UI Defs JRAD Style
3830: ---------------------------------
3831: CURSOR l_ref_ui_def_jrad_csr (inUIDefID integer) IS
3832: SELECT DISTINCT r.ui_def_id, d.name
3833: FROM cz_ui_refs r, cz_ui_defs d
3834: WHERE r.ref_ui_def_id = inUIDefID
3835: AND r.ui_def_id = d.ui_def_id
3836: AND d.deleted_flag = '0'
3837: AND r.deleted_flag = '0'

Line 3848: FROM cz_ui_nodes n, cz_ui_defs d

3844: -- referencing UI Defs HTML Style
3845: ---------------------------------
3846: CURSOR l_ref_ui_def_0_csr (inUIDefID integer) IS
3847: SELECT DISTINCT d.ui_def_id, d.name
3848: FROM cz_ui_nodes n, cz_ui_defs d
3849: WHERE n.ui_def_ref_id = inUIDefID
3850: AND n.ui_def_id = d.ui_def_id
3851: AND d.deleted_flag = '0'
3852: AND n.deleted_flag = '0';

Line 3866: FROM cz_ui_defs

3862:
3863: BEGIN
3864: SELECT devl_project_id, seeded_flag, ui_style, name
3865: INTO l_devl_project_id, l_seeded_flag, l_ui_style, l_uidef_name
3866: FROM cz_ui_defs
3867: WHERE ui_def_id = p_ui_def_id;
3868: EXCEPTION
3869: WHEN NO_DATA_FOUND THEN
3870: RAISE INVALID_UIDEF_ID_EXCP;

Line 3979: UPDATE cz_ui_defs

3975: ----------------------------
3976: -- finally delete the ui def
3977: ----------------------------
3978:
3979: UPDATE cz_ui_defs
3980: SET deleted_flag = '1'
3981: WHERE ui_def_id = p_ui_def_id;
3982:
3983: UPDATE CZ_RULES

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

6157: INVALID_UIDEF_ID_EXCP EXCEPTION;
6158: l_name cz_rp_entries.name%TYPE;
6159:
6160: BEGIN
6161: x_new_ui_def_id := allocateId('CZ_UI_DEFS_S');
6162: l_name := copy_name(p_ui_def_id,'UMT');
6163: INSERT INTO CZ_UI_DEFS(
6164: UI_DEF_ID
6165: ,DESC_TEXT

Line 6163: INSERT INTO CZ_UI_DEFS(

6159:
6160: BEGIN
6161: x_new_ui_def_id := allocateId('CZ_UI_DEFS_S');
6162: l_name := copy_name(p_ui_def_id,'UMT');
6163: INSERT INTO CZ_UI_DEFS(
6164: UI_DEF_ID
6165: ,DESC_TEXT
6166: ,NAME
6167: ,DEVL_PROJECT_ID

Line 6290: FROM CZ_UI_DEFS

6286: ,OPTION_SORT_ORDER
6287: ,OPTION_SORT_METHOD
6288: ,OPTION_SORT_PROPERTY_ID
6289: ,SHOW_ALL_NODES_FLAG
6290: FROM CZ_UI_DEFS
6291: WHERE ui_def_id = p_ui_def_id;
6292:
6293: IF SQL%ROWCOUNT = 0 THEN
6294: RAISE INVALID_UIDEF_ID_EXCP;

Line 6843: FROM cz_ui_defs ui

6839: SELECT name
6840: BULK
6841: COLLECT
6842: INTO l_ui_name_tbl
6843: FROM cz_ui_defs ui
6844: WHERE from_master_template_id = p_umt_id
6845: AND deleted_flag = '0'
6846: AND seeded_flag <> '1'
6847: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'

Line 6910: UPDATE cz_ui_defs

6906: name = append_name(p_umt_id, 'UMT', name)
6907: WHERE object_id = p_umt_id
6908: AND object_type = 'UMT';
6909:
6910: UPDATE cz_ui_defs
6911: set deleted_flag = '1',
6912: name = append_name(p_umt_id, 'UMT', name)
6913: WHERE ui_def_id = p_umt_id
6914: AND master_template_flag = '1'

Line 6980: FROM cz_ui_defs ui

6976: l_ui_name_tbl.DELETE;
6977: BEGIN
6978: SELECT name name, master_template_flag
6979: BULK COLLECT INTO l_ui_name_tbl, l_mt_flag_tbl
6980: FROM cz_ui_defs ui
6981: WHERE deleted_flag = '0'
6982: AND ui_def_id IN
6983: (SELECT ui_def_id
6984: FROM cz_ui_cont_type_templs

Line 8108: FROM cz_ui_defs

8104: SELECT name
8105: BULK
8106: COLLECT
8107: INTO l_ui_name_tbl
8108: FROM cz_ui_defs
8109: WHERE cz_ui_defs.from_master_template_id = l_umt_ref(modelId)
8110: AND cz_ui_defs.deleted_flag = '0'
8111: AND cz_ui_defs.seeded_flag <> '1';
8112:

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

8105: BULK
8106: COLLECT
8107: INTO l_ui_name_tbl
8108: FROM cz_ui_defs
8109: WHERE cz_ui_defs.from_master_template_id = l_umt_ref(modelId)
8110: AND cz_ui_defs.deleted_flag = '0'
8111: AND cz_ui_defs.seeded_flag <> '1';
8112:
8113: IF (l_ui_name_tbl.count > 0 ) THEN

Line 8110: AND cz_ui_defs.deleted_flag = '0'

8106: COLLECT
8107: INTO l_ui_name_tbl
8108: FROM cz_ui_defs
8109: WHERE cz_ui_defs.from_master_template_id = l_umt_ref(modelId)
8110: AND cz_ui_defs.deleted_flag = '0'
8111: AND cz_ui_defs.seeded_flag <> '1';
8112:
8113: IF (l_ui_name_tbl.count > 0 ) THEN
8114: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8111: AND cz_ui_defs.seeded_flag <> '1';

8107: INTO l_ui_name_tbl
8108: FROM cz_ui_defs
8109: WHERE cz_ui_defs.from_master_template_id = l_umt_ref(modelId)
8110: AND cz_ui_defs.deleted_flag = '0'
8111: AND cz_ui_defs.seeded_flag <> '1';
8112:
8113: IF (l_ui_name_tbl.count > 0 ) THEN
8114: x_return_status := FND_API.G_RET_STS_ERROR;
8115: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST

Line 8147: FROM cz_ui_defs

8143: SELECT name
8144: BULK
8145: COLLECT
8146: INTO l_ui_name_tbl
8147: FROM cz_ui_defs
8148: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id
8149: FROM cz_ui_cont_type_templs
8150: WHERE cz_ui_cont_type_templs.template_id = l_uct_ref(modelId)
8151: AND cz_ui_cont_type_templs.deleted_flag = '0'

Line 8148: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id

8144: BULK
8145: COLLECT
8146: INTO l_ui_name_tbl
8147: FROM cz_ui_defs
8148: WHERE cz_ui_defs.ui_def_id IN (SELECT ui_def_id
8149: FROM cz_ui_cont_type_templs
8150: WHERE cz_ui_cont_type_templs.template_id = l_uct_ref(modelId)
8151: AND cz_ui_cont_type_templs.deleted_flag = '0'
8152: AND cz_ui_cont_type_templs.seeded_flag <> '1')

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

8149: FROM cz_ui_cont_type_templs
8150: WHERE cz_ui_cont_type_templs.template_id = l_uct_ref(modelId)
8151: AND cz_ui_cont_type_templs.deleted_flag = '0'
8152: AND cz_ui_cont_type_templs.seeded_flag <> '1')
8153: AND cz_ui_defs.deleted_flag = '0';
8154:
8155: IF (l_ui_name_tbl.count > 0 ) THEN
8156: x_return_status := FND_API.G_RET_STS_ERROR;
8157: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST

Line 8396: UPDATE cz_ui_defs

8392: WHERE template_id = l_object_id_tbl(i)
8393: AND ui_def_id = 0;
8394:
8395: ELSIF (l_object_typ_tbl(i) = 'UMT') THEN
8396: UPDATE cz_ui_defs
8397: SET deleted_flag = '1'
8398: WHERE ui_def_id = l_object_id_tbl(i);
8399: ELSIF (l_object_typ_tbl(i) = 'USG') THEN
8400: UPDATE cz_model_usages