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_IMAGES

Line 5143: FROM cz_ui_images

5139: l_ui_images_ui_tbl.DELETE;
5140:
5141: SELECT ui_def_id, image_usage_code, entity_code
5142: BULK COLLECT INTO l_ui_images_ui_tbl, l_ui_images_usg_tbl, l_ui_images_enty_tbl
5143: FROM cz_ui_images
5144: WHERE cz_ui_images.ui_def_id = p_old_ui_def_tbl(uidef)
5145: AND cz_ui_images.deleted_flag = record_not_deleted
5146: AND cz_ui_images.seeded_flag <> seed_data;
5147:

Line 5144: WHERE cz_ui_images.ui_def_id = p_old_ui_def_tbl(uidef)

5140:
5141: SELECT ui_def_id, image_usage_code, entity_code
5142: BULK COLLECT INTO l_ui_images_ui_tbl, l_ui_images_usg_tbl, l_ui_images_enty_tbl
5143: FROM cz_ui_images
5144: WHERE cz_ui_images.ui_def_id = p_old_ui_def_tbl(uidef)
5145: AND cz_ui_images.deleted_flag = record_not_deleted
5146: AND cz_ui_images.seeded_flag <> seed_data;
5147:
5148: IF (l_ui_images_ui_tbl.COUNT > 0)

Line 5145: AND cz_ui_images.deleted_flag = record_not_deleted

5141: SELECT ui_def_id, image_usage_code, entity_code
5142: BULK COLLECT INTO l_ui_images_ui_tbl, l_ui_images_usg_tbl, l_ui_images_enty_tbl
5143: FROM cz_ui_images
5144: WHERE cz_ui_images.ui_def_id = p_old_ui_def_tbl(uidef)
5145: AND cz_ui_images.deleted_flag = record_not_deleted
5146: AND cz_ui_images.seeded_flag <> seed_data;
5147:
5148: IF (l_ui_images_ui_tbl.COUNT > 0)
5149: THEN

Line 5146: AND cz_ui_images.seeded_flag <> seed_data;

5142: BULK COLLECT INTO l_ui_images_ui_tbl, l_ui_images_usg_tbl, l_ui_images_enty_tbl
5143: FROM cz_ui_images
5144: WHERE cz_ui_images.ui_def_id = p_old_ui_def_tbl(uidef)
5145: AND cz_ui_images.deleted_flag = record_not_deleted
5146: AND cz_ui_images.seeded_flag <> seed_data;
5147:
5148: IF (l_ui_images_ui_tbl.COUNT > 0)
5149: THEN
5150: rec_count := cz_pb_mgr.v_ui_images_ui_tbl.COUNT;

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

5165: THEN
5166: NULL;
5167: WHEN OTHERS
5168: THEN
5169: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_images', 'SQLERRM', SQLERRM);
5170: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIIMAGES', SQLCODE);
5171: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5172: RAISE;
5173: END bulk_collect_ui_images;

Line 5781: insert_into_table('cz_ui_images'

5777: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ui_images_usg_tbl';
5778: rec_count := rec_count + 1;
5779: plsql_table_list(rec_count).col_name := 'entity_code';
5780: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ui_images_enty_tbl';
5781: insert_into_table('cz_ui_images'
5782: ,'ui_def_id'
5783: ,'image_usage_code'
5784: ,'entity_code'
5785: ,cz_pb_mgr.v_db_link

Line 5820: insert_into_table('cz_ui_images'

5816: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ui_images_usg_tbl';
5817: rec_count := rec_count + 1;
5818: plsql_table_list(rec_count).col_name := 'entity_code';
5819: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ui_images_enty_tbl';
5820: insert_into_table('cz_ui_images'
5821: ,'ui_def_id'
5822: ,'image_usage_code'
5823: ,'entity_code'
5824: ,cz_pb_mgr.v_db_link

Line 6513: delete_from_table('cz_ui_images','ui_def_id','image_usage_code','entity_code',v_database_link,'cz_pb_mgr.l_ui_images_ui_ref','cz_pb_mgr.l_ui_images_usg_tbl','cz_pb_mgr.l_ui_images_enty_tbl',cz_pb_mgr.l_ui_images_ui_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);
6512: delete_from_table('cz_ui_actions','ui_def_id','ui_action_id',v_database_link,'cz_pb_mgr.g_ui_actns_ui_uidef_ref','cz_pb_mgr.g_ui_actns_ui_act_id_ref',cz_pb_mgr.g_ui_actns_ui_uidef_ref);
6513: delete_from_table('cz_ui_images','ui_def_id','image_usage_code','entity_code',v_database_link,'cz_pb_mgr.l_ui_images_ui_ref','cz_pb_mgr.l_ui_images_usg_tbl','cz_pb_mgr.l_ui_images_enty_tbl',cz_pb_mgr.l_ui_images_ui_ref);
6514: delete_from_table('cz_signatures','signature_id',v_database_link,'cz_pb_mgr.v_sig_new_ref',cz_pb_mgr.v_sig_new_ref);
6515: delete_from_table('cz_signature_arguments','argument_signature_id','argument_index',v_database_link,'cz_pb_mgr.v_arg_sig_tbl','cz_pb_mgr.v_arg_ind_old_tbl',cz_pb_mgr.v_arg_sig_tbl);
6516: delete_from_table('cz_func_comp_specs','func_comp_id',v_database_link,'cz_pb_mgr.v_cz_func_comp_new_ref',cz_pb_mgr.v_cz_func_comp_new_ref);
6517: delete_from_table('cz_populators','populator_id',v_database_link,'cz_pb_mgr.v_populators_new_id_ref',cz_pb_mgr.v_populators_new_id_ref);

Line 7192: FROM cz_ui_images

7188:
7189: CURSOR ui_images_cur(p_ui_def_id NUMBER)
7190: IS
7191: SELECT last_update_date
7192: FROM cz_ui_images
7193: WHERE cz_ui_images.ui_def_id = p_ui_def_id
7194: ORDER BY last_update_date DESC;
7195: CURSOR ui_page_elements(p_ui_def_id NUMBER)
7196: IS

Line 7193: WHERE cz_ui_images.ui_def_id = p_ui_def_id

7189: CURSOR ui_images_cur(p_ui_def_id NUMBER)
7190: IS
7191: SELECT last_update_date
7192: FROM cz_ui_images
7193: WHERE cz_ui_images.ui_def_id = p_ui_def_id
7194: ORDER BY last_update_date DESC;
7195: CURSOR ui_page_elements(p_ui_def_id NUMBER)
7196: IS
7197: SELECT last_update_date