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_ELEMENTS

Line 5060: FROM cz_ui_page_elements

5056: SELECT ui_def_id, ctrl_template_id, page_id, element_id
5057: ,model_ref_expl_id, ctrl_template_ui_def_id, element_signature_id, target_page_ui_def_id
5058: BULK COLLECT INTO l_ui_ps_maps_ui_def_tbl, l_ui_ps_maps_ctrl_tmp_tbl, l_ui_ps_maps_page_id_tbl, l_ui_ps_maps_element_tbl
5059: ,l_ui_ps_maps_expl_id_tbl, l_ui_ps_maps_ctrl_temp_ui_tbl, l_ui_ps_maps_elem_sig_tbl, l_ui_ps_maps_tgt_pg_ui_def_tbl
5060: FROM cz_ui_page_elements
5061: WHERE cz_ui_page_elements.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef)
5062: AND cz_ui_page_elements.deleted_flag = record_not_deleted;
5063: EXCEPTION
5064: WHEN NO_DATA_FOUND

Line 5061: WHERE cz_ui_page_elements.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef)

5057: ,model_ref_expl_id, ctrl_template_ui_def_id, element_signature_id, target_page_ui_def_id
5058: BULK COLLECT INTO l_ui_ps_maps_ui_def_tbl, l_ui_ps_maps_ctrl_tmp_tbl, l_ui_ps_maps_page_id_tbl, l_ui_ps_maps_element_tbl
5059: ,l_ui_ps_maps_expl_id_tbl, l_ui_ps_maps_ctrl_temp_ui_tbl, l_ui_ps_maps_elem_sig_tbl, l_ui_ps_maps_tgt_pg_ui_def_tbl
5060: FROM cz_ui_page_elements
5061: WHERE cz_ui_page_elements.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef)
5062: AND cz_ui_page_elements.deleted_flag = record_not_deleted;
5063: EXCEPTION
5064: WHEN NO_DATA_FOUND
5065: THEN

Line 5062: AND cz_ui_page_elements.deleted_flag = record_not_deleted;

5058: BULK COLLECT INTO l_ui_ps_maps_ui_def_tbl, l_ui_ps_maps_ctrl_tmp_tbl, l_ui_ps_maps_page_id_tbl, l_ui_ps_maps_element_tbl
5059: ,l_ui_ps_maps_expl_id_tbl, l_ui_ps_maps_ctrl_temp_ui_tbl, l_ui_ps_maps_elem_sig_tbl, l_ui_ps_maps_tgt_pg_ui_def_tbl
5060: FROM cz_ui_page_elements
5061: WHERE cz_ui_page_elements.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef)
5062: AND cz_ui_page_elements.deleted_flag = record_not_deleted;
5063: EXCEPTION
5064: WHEN NO_DATA_FOUND
5065: THEN
5066: NULL;

Line 5142: ,'cz_ui_page_elements.target_page_ui_def_id'

5138: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_ps_maps_new_ui_def_ref
5139: ,cz_pb_mgr.v_cz_ui_defs_old_ref
5140: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
5141: ,cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl
5142: ,'cz_ui_page_elements.target_page_ui_def_id'
5143: ,cz_pb_mgr.v_status_code
5144: );
5145: insert_into_table('cz_ui_page_elements'
5146: ,'ui_def_id'

Line 5145: insert_into_table('cz_ui_page_elements'

5141: ,cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl
5142: ,'cz_ui_page_elements.target_page_ui_def_id'
5143: ,cz_pb_mgr.v_status_code
5144: );
5145: insert_into_table('cz_ui_page_elements'
5146: ,'ui_def_id'
5147: ,'page_id'
5148: ,'element_id'
5149: ,cz_pb_mgr.v_db_link

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

5158: END IF;
5159: EXCEPTION
5160: WHEN OTHERS
5161: THEN
5162: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_page_elements', 'SQLERRM', SQLERRM);
5163: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIPSMAPS', SQLCODE);
5164: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5165: RAISE;
5166: END insert_ui_ps_maps;

Line 6343: ----insert into cz_ui_page_elements

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
6344: export_signatures(cz_pb_mgr.g_ui_ps_maps_elem_sig_tbl);
6345: insert_ui_ps_maps;
6346:
6347: -- A master template carries its own set of content templates

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

7212: ,cz_pb_mgr.v_cz_des_cells_rule_id_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);

Line 7921: FROM cz_ui_page_elements

7917: ORDER BY last_update_date DESC;
7918: CURSOR ui_page_elements(p_ui_def_id NUMBER)
7919: IS
7920: SELECT last_update_date
7921: FROM cz_ui_page_elements
7922: WHERE cz_ui_page_elements.ui_def_id = p_ui_def_id
7923: ORDER BY last_update_date DESC;
7924: BEGIN
7925: v_initialized_date := cz_utils.epoch_begin;

Line 7922: WHERE cz_ui_page_elements.ui_def_id = p_ui_def_id

7918: CURSOR ui_page_elements(p_ui_def_id NUMBER)
7919: IS
7920: SELECT last_update_date
7921: FROM cz_ui_page_elements
7922: WHERE cz_ui_page_elements.ui_def_id = p_ui_def_id
7923: ORDER BY last_update_date DESC;
7924: BEGIN
7925: v_initialized_date := cz_utils.epoch_begin;
7926: v_ui_def_id_date := v_initialized_date;

Line 11708: ,'cz_ui_page_elements.target_page_ui_def_id'

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: )
11712: )