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 5889: FROM cz_ui_images

5885: l_ui_images_ui_tbl.DELETE;
5886:
5887: SELECT ui_def_id, image_usage_code, entity_code
5888: BULK COLLECT INTO l_ui_images_ui_tbl, l_ui_images_usg_tbl, l_ui_images_enty_tbl
5889: FROM cz_ui_images
5890: WHERE cz_ui_images.ui_def_id = p_old_ui_def_tbl(uidef)
5891: AND cz_ui_images.deleted_flag = record_not_deleted
5892: AND cz_ui_images.seeded_flag <> seed_data;
5893:

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

5886:
5887: SELECT ui_def_id, image_usage_code, entity_code
5888: BULK COLLECT INTO l_ui_images_ui_tbl, l_ui_images_usg_tbl, l_ui_images_enty_tbl
5889: FROM cz_ui_images
5890: WHERE cz_ui_images.ui_def_id = p_old_ui_def_tbl(uidef)
5891: AND cz_ui_images.deleted_flag = record_not_deleted
5892: AND cz_ui_images.seeded_flag <> seed_data;
5893:
5894: IF (l_ui_images_ui_tbl.COUNT > 0)

Line 5891: AND cz_ui_images.deleted_flag = record_not_deleted

5887: SELECT ui_def_id, image_usage_code, entity_code
5888: BULK COLLECT INTO l_ui_images_ui_tbl, l_ui_images_usg_tbl, l_ui_images_enty_tbl
5889: FROM cz_ui_images
5890: WHERE cz_ui_images.ui_def_id = p_old_ui_def_tbl(uidef)
5891: AND cz_ui_images.deleted_flag = record_not_deleted
5892: AND cz_ui_images.seeded_flag <> seed_data;
5893:
5894: IF (l_ui_images_ui_tbl.COUNT > 0)
5895: THEN

Line 5892: AND cz_ui_images.seeded_flag <> seed_data;

5888: BULK COLLECT INTO l_ui_images_ui_tbl, l_ui_images_usg_tbl, l_ui_images_enty_tbl
5889: FROM cz_ui_images
5890: WHERE cz_ui_images.ui_def_id = p_old_ui_def_tbl(uidef)
5891: AND cz_ui_images.deleted_flag = record_not_deleted
5892: AND cz_ui_images.seeded_flag <> seed_data;
5893:
5894: IF (l_ui_images_ui_tbl.COUNT > 0)
5895: THEN
5896: rec_count := cz_pb_mgr.v_ui_images_ui_tbl.COUNT;

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

5911: THEN
5912: NULL;
5913: WHEN OTHERS
5914: THEN
5915: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_images', 'SQLERRM', SQLERRM);
5916: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIIMAGES', SQLCODE);
5917: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5918: RAISE;
5919: END bulk_collect_ui_images;

Line 6538: insert_into_table('cz_ui_images'

6534: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ui_images_usg_tbl';
6535: rec_count := rec_count + 1;
6536: plsql_table_list(rec_count).col_name := 'entity_code';
6537: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ui_images_enty_tbl';
6538: insert_into_table('cz_ui_images'
6539: ,'ui_def_id'
6540: ,'image_usage_code'
6541: ,'entity_code'
6542: ,cz_pb_mgr.v_db_link

Line 6577: insert_into_table('cz_ui_images'

6573: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ui_images_usg_tbl';
6574: rec_count := rec_count + 1;
6575: plsql_table_list(rec_count).col_name := 'entity_code';
6576: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ui_images_enty_tbl';
6577: insert_into_table('cz_ui_images'
6578: ,'ui_def_id'
6579: ,'image_usage_code'
6580: ,'entity_code'
6581: ,cz_pb_mgr.v_db_link

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

7230: refine_ui_action_array;
7231: END IF;
7232:
7233: 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);
7234: 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);
7235: delete_from_table('cz_signatures','signature_id',v_database_link,'cz_pb_mgr.v_sig_new_ref',cz_pb_mgr.v_sig_new_ref);
7236: 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);
7237: 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);
7238: 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 7915: FROM cz_ui_images

7911:
7912: CURSOR ui_images_cur(p_ui_def_id NUMBER)
7913: IS
7914: SELECT last_update_date
7915: FROM cz_ui_images
7916: WHERE cz_ui_images.ui_def_id = p_ui_def_id
7917: ORDER BY last_update_date DESC;
7918: CURSOR ui_page_elements(p_ui_def_id NUMBER)
7919: IS

Line 7916: WHERE cz_ui_images.ui_def_id = p_ui_def_id

7912: CURSOR ui_images_cur(p_ui_def_id NUMBER)
7913: IS
7914: SELECT last_update_date
7915: FROM cz_ui_images
7916: WHERE cz_ui_images.ui_def_id = p_ui_def_id
7917: ORDER BY last_update_date DESC;
7918: CURSOR ui_page_elements(p_ui_def_id NUMBER)
7919: IS
7920: SELECT last_update_date