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 4930: FROM cz_ui_refs

4926: l_ui_refs_expl_id_tbl.DELETE;
4927:
4928: SELECT ui_def_id, ref_ui_def_id, model_ref_expl_id
4929: BULK COLLECT INTO l_ui_refs_ui_def_tbl, l_ui_refs_ref_ui_def_tbl, l_ui_refs_expl_id_tbl
4930: FROM cz_ui_refs
4931: 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;
4932:
4933: IF (l_ui_refs_ui_def_tbl.COUNT > 0)
4934: THEN

Line 4931: 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;

4927:
4928: SELECT ui_def_id, ref_ui_def_id, model_ref_expl_id
4929: BULK COLLECT INTO l_ui_refs_ui_def_tbl, l_ui_refs_ref_ui_def_tbl, l_ui_refs_expl_id_tbl
4930: FROM cz_ui_refs
4931: 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;
4932:
4933: IF (l_ui_refs_ui_def_tbl.COUNT > 0)
4934: THEN
4935: rec_count := cz_pb_mgr.g_ui_refs_old_ui_def_ref.COUNT;

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

4952: THEN
4953: NULL;
4954: WHEN OTHERS
4955: THEN
4956: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_refs', 'SQLERRM', SQLERRM);
4957: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIREFS', SQLCODE);
4958: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4959: RAISE;
4960: END bulk_collect_ui_refs;

Line 4963: ------insert into cz_ui_refs

4959: RAISE;
4960: END bulk_collect_ui_refs;
4961:
4962: -----------------------------------------------------------------
4963: ------insert into cz_ui_refs
4964: PROCEDURE insert_into_ui_refs
4965: IS
4966: rec_count NUMBER := 0;
4967: plsql_table_list cz_pb_mgr.col_plsql_table_list;

Line 4990: ,'cz_ui_refs.ref_ui_def_id'

4986: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_refs_new_ui_def_ref
4987: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4988: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4989: ,cz_pb_mgr.g_ui_refs_ref_ui_def_ref
4990: ,'cz_ui_refs.ref_ui_def_id'
4991: ,cz_pb_mgr.v_status_code
4992: );
4993: insert_into_table('cz_ui_refs'
4994: ,'ui_def_id'

Line 4993: insert_into_table('cz_ui_refs'

4989: ,cz_pb_mgr.g_ui_refs_ref_ui_def_ref
4990: ,'cz_ui_refs.ref_ui_def_id'
4991: ,cz_pb_mgr.v_status_code
4992: );
4993: insert_into_table('cz_ui_refs'
4994: ,'ui_def_id'
4995: ,'ref_ui_def_id'
4996: ,'model_ref_expl_id'
4997: ,cz_pb_mgr.v_db_link

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

5008: COMMIT;
5009: EXCEPTION
5010: WHEN OTHERS
5011: THEN
5012: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_refs', 'SQLERRM', SQLERRM);
5013: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIREFS', SQLCODE);
5014: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5015: RAISE;
5016: END;

Line 6339: ----insert into cz_ui_refs

6335: ----insert into cz_ui_page_refs
6336: insert_into_ui_page_refs;
6337: -----bulk collect from ui refs
6338: bulk_collect_ui_refs;
6339: ----insert into cz_ui_refs
6340: insert_into_ui_refs;
6341: -----bulk collect from ui ps maps
6342: bulk_collect_ui_ps_maps;
6343: ----insert into cz_ui_page_elements

Line 6666: FROM cz_ui_refs

6662:
6663: BEGIN
6664: SELECT ref_ui_def_id
6665: BULK COLLECT INTO l_child_ui_tbl
6666: FROM cz_ui_refs
6667: WHERE cz_ui_refs.ui_def_id = l_ui_def_id AND cz_ui_refs.deleted_flag = record_not_deleted;
6668: EXCEPTION
6669: WHEN NO_DATA_FOUND
6670: THEN

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

6663: BEGIN
6664: SELECT ref_ui_def_id
6665: BULK COLLECT INTO l_child_ui_tbl
6666: FROM cz_ui_refs
6667: WHERE cz_ui_refs.ui_def_id = l_ui_def_id AND cz_ui_refs.deleted_flag = record_not_deleted;
6668: EXCEPTION
6669: WHEN NO_DATA_FOUND
6670: THEN
6671: NULL; ---if no children then ignore

Line 7219: 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);

7215: 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);
7216: 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);
7217: 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);
7218: 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);
7219: 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);
7220: 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);
7221:
7222: --bug 11700415 skip rollback for ref templates and templ actions depending on global variable
7223: IF NOT g_skip_templ_rollback THEN

Line 7887: FROM cz_ui_refs

7883:
7884: CURSOR ui_refs_cur(p_ui_def_id NUMBER)
7885: IS
7886: SELECT last_update_date
7887: FROM cz_ui_refs
7888: WHERE cz_ui_refs.ui_def_id = p_ui_def_id AND cz_ui_refs.deleted_flag = '0'
7889: ORDER BY last_update_date DESC;
7890:
7891: CURSOR ui_templs_cur(p_ui_def_id NUMBER)

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

7884: CURSOR ui_refs_cur(p_ui_def_id NUMBER)
7885: IS
7886: SELECT last_update_date
7887: FROM cz_ui_refs
7888: WHERE cz_ui_refs.ui_def_id = p_ui_def_id AND cz_ui_refs.deleted_flag = '0'
7889: ORDER BY last_update_date DESC;
7890:
7891: CURSOR ui_templs_cur(p_ui_def_id NUMBER)
7892: IS

Line 11706: ,'cz_ui_refs.ref_ui_def_id'

11702: ,cz_pb_mgr.v_status_code
11703: );
11704: ELSIF(p_column_name IN
11705: ('cz_ui_nodes.ui_def_ref_id'
11706: ,'cz_ui_refs.ref_ui_def_id'
11707: ,'cz_ui_page_refs.target_ui_def_id'
11708: ,'cz_ui_page_elements.target_page_ui_def_id'
11709: ,'cz_ui_ref_templates.ref_template_ui_def_id'
11710: ,'cz_ui_actions.target_ui_def_id'

Line 18518: FROM cz_ui_refs

18514: CONNECT BY PRIOR ui_def_ref_id = ui_def_id AND PRIOR deleted_flag = '0';
18515: ELSIF (l_ui_style = g_ui_style_jrad) THEN
18516: SELECT ref_ui_def_id BULK COLLECT INTO l_ui_tbl
18517: FROM (SELECT DISTINCT ref_ui_def_id
18518: FROM cz_ui_refs
18519: START WITH ui_def_id = p_ui_def_id AND deleted_flag = '0'
18520: CONNECT BY PRIOR ref_ui_def_id = ui_def_id AND deleted_flag = '0' AND PRIOR deleted_flag = '0') uis
18521: WHERE EXISTS (SELECT NULL
18522: FROM cz_ui_defs