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.

[Home] [Help]

APPS.CZ_PB_MGR dependencies on CZ_UI_PAGE_ELEMENTS

Line 4399: FROM cz_ui_page_elements

4395: SELECT ui_def_id, ctrl_template_id, page_id, element_id
4396: ,model_ref_expl_id, ctrl_template_ui_def_id, element_signature_id, target_page_ui_def_id
4397: 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
4398: ,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
4399: FROM cz_ui_page_elements
4400: WHERE cz_ui_page_elements.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef)
4401: AND cz_ui_page_elements.deleted_flag = record_not_deleted;
4402: EXCEPTION
4403: WHEN NO_DATA_FOUND

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

4396: ,model_ref_expl_id, ctrl_template_ui_def_id, element_signature_id, target_page_ui_def_id
4397: 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
4398: ,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
4399: FROM cz_ui_page_elements
4400: WHERE cz_ui_page_elements.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef)
4401: AND cz_ui_page_elements.deleted_flag = record_not_deleted;
4402: EXCEPTION
4403: WHEN NO_DATA_FOUND
4404: THEN

Line 4401: AND cz_ui_page_elements.deleted_flag = record_not_deleted;

4397: 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
4398: ,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
4399: FROM cz_ui_page_elements
4400: WHERE cz_ui_page_elements.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef)
4401: AND cz_ui_page_elements.deleted_flag = record_not_deleted;
4402: EXCEPTION
4403: WHEN NO_DATA_FOUND
4404: THEN
4405: NULL;

Line 4481: ,'cz_ui_page_elements.target_page_ui_def_id'

4477: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_ps_maps_new_ui_def_ref
4478: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4479: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4480: ,cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl
4481: ,'cz_ui_page_elements.target_page_ui_def_id'
4482: ,cz_pb_mgr.v_status_code
4483: );
4484: insert_into_table('cz_ui_page_elements'
4485: ,'ui_def_id'

Line 4484: insert_into_table('cz_ui_page_elements'

4480: ,cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl
4481: ,'cz_ui_page_elements.target_page_ui_def_id'
4482: ,cz_pb_mgr.v_status_code
4483: );
4484: insert_into_table('cz_ui_page_elements'
4485: ,'ui_def_id'
4486: ,'page_id'
4487: ,'element_id'
4488: ,cz_pb_mgr.v_db_link

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

4497: END IF;
4498: EXCEPTION
4499: WHEN OTHERS
4500: THEN
4501: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_page_elements', 'SQLERRM', SQLERRM);
4502: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIPSMAPS', SQLCODE);
4503: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4504: RAISE;
4505: END insert_ui_ps_maps;

Line 5589: ----insert into cz_ui_page_elements

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
5590: export_signatures(cz_pb_mgr.g_ui_ps_maps_elem_sig_tbl);
5591: insert_ui_ps_maps;
5592:
5593: -- A master template carries its own set of content templates

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

6500: ,cz_pb_mgr.v_cz_des_cells_rule_id_new_ref
6501: );
6502:
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);

Line 7198: FROM cz_ui_page_elements

7194: ORDER BY last_update_date DESC;
7195: CURSOR ui_page_elements(p_ui_def_id NUMBER)
7196: IS
7197: SELECT last_update_date
7198: FROM cz_ui_page_elements
7199: WHERE cz_ui_page_elements.ui_def_id = p_ui_def_id
7200: ORDER BY last_update_date DESC;
7201: BEGIN
7202: v_initialized_date := cz_utils.epoch_begin;

Line 7199: WHERE cz_ui_page_elements.ui_def_id = p_ui_def_id

7195: CURSOR ui_page_elements(p_ui_def_id NUMBER)
7196: IS
7197: SELECT last_update_date
7198: FROM cz_ui_page_elements
7199: WHERE cz_ui_page_elements.ui_def_id = p_ui_def_id
7200: ORDER BY last_update_date DESC;
7201: BEGIN
7202: v_initialized_date := cz_utils.epoch_begin;
7203: v_ui_def_id_date := v_initialized_date;

Line 10952: ,'cz_ui_page_elements.target_page_ui_def_id'

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'
10955: )
10956: )