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_PB_MGR dependencies on CZ_UI_REFS

Line 4269: FROM cz_ui_refs

4265: l_ui_refs_expl_id_tbl.DELETE;
4266:
4267: SELECT ui_def_id, ref_ui_def_id, model_ref_expl_id
4268: BULK COLLECT INTO l_ui_refs_ui_def_tbl, l_ui_refs_ref_ui_def_tbl, l_ui_refs_expl_id_tbl
4269: FROM cz_ui_refs
4270: WHERE cz_ui_refs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_refs.deleted_flag = record_not_deleted;
4271:
4272: IF (l_ui_refs_ui_def_tbl.COUNT > 0)
4273: THEN

Line 4270: WHERE cz_ui_refs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_refs.deleted_flag = record_not_deleted;

4266:
4267: SELECT ui_def_id, ref_ui_def_id, model_ref_expl_id
4268: BULK COLLECT INTO l_ui_refs_ui_def_tbl, l_ui_refs_ref_ui_def_tbl, l_ui_refs_expl_id_tbl
4269: FROM cz_ui_refs
4270: WHERE cz_ui_refs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_refs.deleted_flag = record_not_deleted;
4271:
4272: IF (l_ui_refs_ui_def_tbl.COUNT > 0)
4273: THEN
4274: rec_count := cz_pb_mgr.g_ui_refs_old_ui_def_ref.COUNT;

Line 4295: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_refs', 'SQLERRM', SQLERRM);

4291: THEN
4292: NULL;
4293: WHEN OTHERS
4294: THEN
4295: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_refs', 'SQLERRM', SQLERRM);
4296: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIREFS', SQLCODE);
4297: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4298: RAISE;
4299: END bulk_collect_ui_refs;

Line 4302: ------insert into cz_ui_refs

4298: RAISE;
4299: END bulk_collect_ui_refs;
4300:
4301: -----------------------------------------------------------------
4302: ------insert into cz_ui_refs
4303: PROCEDURE insert_into_ui_refs
4304: IS
4305: rec_count NUMBER := 0;
4306: plsql_table_list cz_pb_mgr.col_plsql_table_list;

Line 4329: ,'cz_ui_refs.ref_ui_def_id'

4325: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_refs_new_ui_def_ref
4326: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4327: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4328: ,cz_pb_mgr.g_ui_refs_ref_ui_def_ref
4329: ,'cz_ui_refs.ref_ui_def_id'
4330: ,cz_pb_mgr.v_status_code
4331: );
4332: insert_into_table('cz_ui_refs'
4333: ,'ui_def_id'

Line 4332: insert_into_table('cz_ui_refs'

4328: ,cz_pb_mgr.g_ui_refs_ref_ui_def_ref
4329: ,'cz_ui_refs.ref_ui_def_id'
4330: ,cz_pb_mgr.v_status_code
4331: );
4332: insert_into_table('cz_ui_refs'
4333: ,'ui_def_id'
4334: ,'ref_ui_def_id'
4335: ,'model_ref_expl_id'
4336: ,cz_pb_mgr.v_db_link

Line 4351: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_refs', 'SQLERRM', SQLERRM);

4347: COMMIT;
4348: EXCEPTION
4349: WHEN OTHERS
4350: THEN
4351: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_refs', 'SQLERRM', SQLERRM);
4352: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIREFS', SQLCODE);
4353: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4354: RAISE;
4355: END;

Line 5585: ----insert into cz_ui_refs

5581: ----insert into cz_ui_page_refs
5582: insert_into_ui_page_refs;
5583: -----bulk collect from ui refs
5584: bulk_collect_ui_refs;
5585: ----insert into cz_ui_refs
5586: insert_into_ui_refs;
5587: -----bulk collect from ui ps maps
5588: bulk_collect_ui_ps_maps;
5589: ----insert into cz_ui_page_elements

Line 5909: FROM cz_ui_refs

5905:
5906: BEGIN
5907: SELECT ref_ui_def_id
5908: BULK COLLECT INTO l_child_ui_tbl
5909: FROM cz_ui_refs
5910: WHERE cz_ui_refs.ui_def_id = l_ui_def_id AND cz_ui_refs.deleted_flag = record_not_deleted;
5911: EXCEPTION
5912: WHEN NO_DATA_FOUND
5913: THEN

Line 5910: WHERE cz_ui_refs.ui_def_id = l_ui_def_id AND cz_ui_refs.deleted_flag = record_not_deleted;

5906: BEGIN
5907: SELECT ref_ui_def_id
5908: BULK COLLECT INTO l_child_ui_tbl
5909: FROM cz_ui_refs
5910: WHERE cz_ui_refs.ui_def_id = l_ui_def_id AND cz_ui_refs.deleted_flag = record_not_deleted;
5911: EXCEPTION
5912: WHEN NO_DATA_FOUND
5913: THEN
5914: NULL; ---if no children then ignore

Line 6507: delete_from_table('cz_ui_refs','ui_def_id','model_ref_expl_id',v_database_link,'cz_pb_mgr.g_ui_refs_new_ui_def_ref','cz_pb_mgr.g_ui_refs_expl_id_ref',cz_pb_mgr.g_ui_refs_new_ui_def_ref);

6503: delete_from_table('cz_ui_pages','ui_def_id',v_database_link,'cz_pb_mgr.g_cz_ui_pages_ui_def_ref',cz_pb_mgr.g_cz_ui_pages_ui_def_ref);
6504: delete_from_table('cz_ui_page_elements','ui_def_id','page_id','element_id',v_database_link,'cz_pb_mgr.g_ui_ps_maps_new_ui_def_ref','cz_pb_mgr.g_ui_ps_maps_page_id_tbl','cz_pb_mgr.g_ui_ps_maps_element_tbl',cz_pb_mgr.g_ui_ps_maps_new_ui_def_ref);
6505: delete_from_table('cz_ui_page_refs','ui_def_id','page_set_id','page_ref_id',v_database_link,'cz_pb_mgr.g_page_refs_ui_def_new_ref','cz_pb_mgr.g_page_refs_pg_set_ref','cz_pb_mgr.g_page_refs_pg_ref_ref',cz_pb_mgr.g_page_refs_ui_def_new_ref);
6506: delete_from_table('cz_ui_page_sets','ui_def_id','page_set_id',v_database_link,'cz_pb_mgr.g_page_sets_ui_ref','cz_pb_mgr.g_page_sets_pg_tbl',cz_pb_mgr.g_page_sets_ui_ref);
6507: delete_from_table('cz_ui_refs','ui_def_id','model_ref_expl_id',v_database_link,'cz_pb_mgr.g_ui_refs_new_ui_def_ref','cz_pb_mgr.g_ui_refs_expl_id_ref',cz_pb_mgr.g_ui_refs_new_ui_def_ref);
6508: delete_from_table('cz_ui_cont_type_templs','ui_def_id','content_type',v_database_link,'cz_pb_mgr.l_cnt_typ_tmpls_new_uidef_ref','cz_pb_mgr.l_cnt_typ_tmpls_cont_ref',cz_pb_mgr.l_cnt_typ_tmpls_new_uidef_ref);
6509: delete_from_table('cz_ui_ref_templates','template_id','template_ui_def_id',
6510: 'ref_template_id','ref_template_ui_def_id',v_database_link,'cz_pb_mgr.g_TEMPLATE_ID_ref','cz_pb_mgr.g_TEMPLATE_UI_ref',
6511: 'cz_pb_mgr.g_REF_TEMPLATE_ID_ref','cz_pb_mgr.g_REF_TEMPL_UI_ref',cz_pb_mgr.g_TEMPLATE_ID_ref);

Line 7164: FROM cz_ui_refs

7160:
7161: CURSOR ui_refs_cur(p_ui_def_id NUMBER)
7162: IS
7163: SELECT last_update_date
7164: FROM cz_ui_refs
7165: WHERE cz_ui_refs.ui_def_id = p_ui_def_id AND cz_ui_refs.deleted_flag = '0'
7166: ORDER BY last_update_date DESC;
7167:
7168: CURSOR ui_templs_cur(p_ui_def_id NUMBER)

Line 7165: WHERE cz_ui_refs.ui_def_id = p_ui_def_id AND cz_ui_refs.deleted_flag = '0'

7161: CURSOR ui_refs_cur(p_ui_def_id NUMBER)
7162: IS
7163: SELECT last_update_date
7164: FROM cz_ui_refs
7165: WHERE cz_ui_refs.ui_def_id = p_ui_def_id AND cz_ui_refs.deleted_flag = '0'
7166: ORDER BY last_update_date DESC;
7167:
7168: CURSOR ui_templs_cur(p_ui_def_id NUMBER)
7169: IS

Line 10950: ,'cz_ui_refs.ref_ui_def_id'

10946: ,cz_pb_mgr.v_status_code
10947: );
10948: ELSIF(p_column_name IN
10949: ('cz_ui_nodes.ui_def_ref_id'
10950: ,'cz_ui_refs.ref_ui_def_id'
10951: ,'cz_ui_page_refs.target_ui_def_id'
10952: ,'cz_ui_page_elements.target_page_ui_def_id'
10953: ,'cz_ui_ref_templates.ref_template_ui_def_id'
10954: ,'cz_ui_actions.target_ui_def_id'

Line 17375: FROM cz_ui_refs

17371: CONNECT BY PRIOR ui_def_ref_id = ui_def_id AND PRIOR deleted_flag = '0';
17372: ELSIF (l_ui_style = g_ui_style_jrad) THEN
17373: SELECT ref_ui_def_id BULK COLLECT INTO l_ui_tbl
17374: FROM (SELECT DISTINCT ref_ui_def_id
17375: FROM cz_ui_refs
17376: START WITH ui_def_id = p_ui_def_id AND deleted_flag = '0'
17377: CONNECT BY PRIOR ref_ui_def_id = ui_def_id AND deleted_flag = '0' AND PRIOR deleted_flag = '0') uis
17378: WHERE EXISTS (SELECT NULL
17379: FROM cz_ui_defs