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_PAGE_REFS

Line 2388: cz_pb_mgr.v_err_message := 'Insert into cz ui page refs: ' || SQLERRM;

2384: COMMIT;
2385: EXCEPTION
2386: WHEN OTHERS
2387: THEN
2388: cz_pb_mgr.v_err_message := 'Insert into cz ui page refs: ' || SQLERRM;
2389: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZUIPAGEREFS', SQLCODE);
2390: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
2391: RAISE;
2392: END;

Line 4794: FROM cz_ui_page_refs

4790: SELECT ui_def_id, page_set_id, page_ref_id, condition_id, caption_text_id
4791: ,target_ui_def_id, target_expl_node_id, caption_rule_id
4792: BULK COLLECT INTO l_page_refs_ui_def_tbl, l_page_refs_pg_set_tbl, l_page_refs_pg_ref_tbl, l_page_refs_cond_id_tbl, l_page_refs_capt_id_tbl
4793: ,l_page_refs_tgt_ui_tbl, l_page_refs_tgt_expl_tbl, l_page_refs_cpt_rule_tbl
4794: FROM cz_ui_page_refs
4795: WHERE cz_ui_page_refs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_page_refs.deleted_flag = record_not_deleted;
4796:
4797: IF (l_page_refs_ui_def_tbl.COUNT > 0)
4798: THEN

Line 4795: WHERE cz_ui_page_refs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_page_refs.deleted_flag = record_not_deleted;

4791: ,target_ui_def_id, target_expl_node_id, caption_rule_id
4792: BULK COLLECT INTO l_page_refs_ui_def_tbl, l_page_refs_pg_set_tbl, l_page_refs_pg_ref_tbl, l_page_refs_cond_id_tbl, l_page_refs_capt_id_tbl
4793: ,l_page_refs_tgt_ui_tbl, l_page_refs_tgt_expl_tbl, l_page_refs_cpt_rule_tbl
4794: FROM cz_ui_page_refs
4795: WHERE cz_ui_page_refs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_page_refs.deleted_flag = record_not_deleted;
4796:
4797: IF (l_page_refs_ui_def_tbl.COUNT > 0)
4798: THEN
4799: rec_count := cz_pb_mgr.g_page_refs_ui_def_old_ref.COUNT;

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

4821: THEN
4822: NULL;
4823: WHEN OTHERS
4824: THEN
4825: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_page_refs', 'SQLERRM', SQLERRM);
4826: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPAGEREFS', SQLCODE);
4827: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4828: RAISE;
4829: END bulk_collect_page_refs;

Line 4850: -----insert_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref,'caption ids of cz ui page refs');

4846:
4847: ---create rules for g_page_refs_cond_id_ref
4848: resolve_ids(cz_pb_mgr.g_page_refs_cond_id_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'condition id of page refs');
4849: ----caption ids of ui pages
4850: -----insert_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref,'caption ids of cz ui page refs');
4851: resolve_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui page refs');
4852: ----resolve expl id
4853: resolve_ids(cz_pb_mgr.g_page_refs_tgt_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl ids of page refs');
4854: plsql_table_list.DELETE;

Line 4851: resolve_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui page refs');

4847: ---create rules for g_page_refs_cond_id_ref
4848: resolve_ids(cz_pb_mgr.g_page_refs_cond_id_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'condition id of page refs');
4849: ----caption ids of ui pages
4850: -----insert_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref,'caption ids of cz ui page refs');
4851: resolve_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui page refs');
4852: ----resolve expl id
4853: resolve_ids(cz_pb_mgr.g_page_refs_tgt_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl ids of page refs');
4854: plsql_table_list.DELETE;
4855: rec_count := 1;

Line 4878: ,'cz_ui_page_refs.target_ui_def_id'

4874: resolve_ref_ids_not_found(cz_pb_mgr.g_page_refs_ui_def_new_ref
4875: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4876: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4877: ,cz_pb_mgr.g_page_refs_tgt_ui_ref
4878: ,'cz_ui_page_refs.target_ui_def_id'
4879: ,cz_pb_mgr.v_status_code
4880: );
4881: insert_into_table('cz_ui_page_refs'
4882: ,'ui_def_id'

Line 4881: insert_into_table('cz_ui_page_refs'

4877: ,cz_pb_mgr.g_page_refs_tgt_ui_ref
4878: ,'cz_ui_page_refs.target_ui_def_id'
4879: ,cz_pb_mgr.v_status_code
4880: );
4881: insert_into_table('cz_ui_page_refs'
4882: ,'ui_def_id'
4883: ,'page_set_id'
4884: ,'page_ref_id'
4885: ,cz_pb_mgr.v_db_link

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

4894: END IF;
4895: EXCEPTION
4896: WHEN OTHERS
4897: THEN
4898: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_page_refs', 'SQLERRM', SQLERRM);
4899: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIPAGEREFS', SQLCODE);
4900: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4901: RAISE;
4902: END insert_into_ui_page_refs;

Line 6335: ----insert into cz_ui_page_refs

6331: copy_train_docs;
6332: insert_into_ui_page_sets;
6333: -----bulk collect from page refs
6334: bulk_collect_page_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

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

7213: );
7214:
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:

Line 7871: FROM cz_ui_page_refs

7867:
7868: CURSOR ui_page_refs_cur(p_ui_def_id NUMBER)
7869: IS
7870: SELECT last_update_date
7871: FROM cz_ui_page_refs
7872: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id AND cz_ui_page_refs.deleted_flag = '0'
7873: ORDER BY last_update_date DESC;
7874:
7875: CURSOR ui_page_refs_capt_cur(p_ui_def_id NUMBER)

Line 7872: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id AND cz_ui_page_refs.deleted_flag = '0'

7868: CURSOR ui_page_refs_cur(p_ui_def_id NUMBER)
7869: IS
7870: SELECT last_update_date
7871: FROM cz_ui_page_refs
7872: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id AND cz_ui_page_refs.deleted_flag = '0'
7873: ORDER BY last_update_date DESC;
7874:
7875: CURSOR ui_page_refs_capt_cur(p_ui_def_id NUMBER)
7876: IS

Line 7880: FROM cz_ui_page_refs

7876: IS
7877: SELECT last_update_date
7878: FROM cz_intl_texts
7879: WHERE intl_text_id IN(SELECT caption_text_id
7880: FROM cz_ui_page_refs
7881: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id)
7882: ORDER BY last_update_date DESC;
7883:
7884: CURSOR ui_refs_cur(p_ui_def_id NUMBER)

Line 7881: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id)

7877: SELECT last_update_date
7878: FROM cz_intl_texts
7879: WHERE intl_text_id IN(SELECT caption_text_id
7880: FROM cz_ui_page_refs
7881: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id)
7882: ORDER BY last_update_date DESC;
7883:
7884: CURSOR ui_refs_cur(p_ui_def_id NUMBER)
7885: IS

Line 11707: ,'cz_ui_page_refs.target_ui_def_id'

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'
11711: )