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_SETS

Line 4673: FROM cz_ui_page_sets

4669: FOR uidef IN cz_pb_mgr.v_cz_ui_defs_old_oa_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_oa_ref.LAST
4670: LOOP
4671: SELECT ui_def_id, page_set_id, train_jrad_doc, pagebase_expl_node_id
4672: BULK COLLECT INTO l_page_sets_ui_tbl, l_page_sets_pg_tbl, l_train_jrad_doc_tbl, l_pagebase_expl_tbl
4673: FROM cz_ui_page_sets
4674: WHERE cz_ui_page_sets.deleted_flag = record_not_deleted AND cz_ui_page_sets.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef);
4675:
4676: IF (l_page_sets_ui_tbl.COUNT > 0)
4677: THEN

Line 4674: WHERE cz_ui_page_sets.deleted_flag = record_not_deleted AND cz_ui_page_sets.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef);

4670: LOOP
4671: SELECT ui_def_id, page_set_id, train_jrad_doc, pagebase_expl_node_id
4672: BULK COLLECT INTO l_page_sets_ui_tbl, l_page_sets_pg_tbl, l_train_jrad_doc_tbl, l_pagebase_expl_tbl
4673: FROM cz_ui_page_sets
4674: WHERE cz_ui_page_sets.deleted_flag = record_not_deleted AND cz_ui_page_sets.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef);
4675:
4676: IF (l_page_sets_ui_tbl.COUNT > 0)
4677: THEN
4678: l_rec_count := cz_pb_mgr.g_page_sets_ui_old_ref.COUNT;

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

4694: THEN
4695: NULL;
4696: WHEN OTHERS
4697: THEN
4698: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_page_sets', 'SQLERRM', SQLERRM);
4699: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPAGESETS', SQLCODE);
4700: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4701: RAISE;
4702: END bulk_collect_page_sets;

Line 4705: ----insert into cz_ui_page_sets

4701: RAISE;
4702: END bulk_collect_page_sets;
4703:
4704: ---------------------------------------------------------------
4705: ----insert into cz_ui_page_sets
4706: PROCEDURE insert_into_ui_page_sets
4707: IS
4708: rec_count NUMBER := 0;
4709: plsql_table_list cz_pb_mgr.col_plsql_table_list;

Line 4727: insert_into_table('cz_ui_page_sets'

4723: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_page_sets_jrad_doc_ref';
4724: rec_count := rec_count + 1;
4725: plsql_table_list(rec_count).col_name := 'pagebase_expl_node_id';
4726: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_page_sets_expl_tbl';
4727: insert_into_table('cz_ui_page_sets'
4728: ,'ui_def_id'
4729: ,'page_set_id'
4730: ,cz_pb_mgr.v_db_link
4731: ,plsql_table_list

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

4737: END IF;
4738: EXCEPTION
4739: WHEN OTHERS
4740: THEN
4741: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_page_sets', 'SQLERRM', SQLERRM);
4742: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIPAGESETS', SQLCODE);
4743: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4744: RAISE;
4745: END insert_into_ui_page_sets;

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

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:
7222: --bug 11700415 skip rollback for ref templates and templ actions depending on global variable

Line 7864: FROM cz_ui_page_sets

7860:
7861: CURSOR ui_page_sets_cur(p_ui_def_id NUMBER)
7862: IS
7863: SELECT last_update_date
7864: FROM cz_ui_page_sets
7865: WHERE cz_ui_page_sets.ui_def_id = p_ui_def_id AND cz_ui_page_sets.deleted_flag = '0'
7866: ORDER BY last_update_date DESC;
7867:
7868: CURSOR ui_page_refs_cur(p_ui_def_id NUMBER)

Line 7865: WHERE cz_ui_page_sets.ui_def_id = p_ui_def_id AND cz_ui_page_sets.deleted_flag = '0'

7861: CURSOR ui_page_sets_cur(p_ui_def_id NUMBER)
7862: IS
7863: SELECT last_update_date
7864: FROM cz_ui_page_sets
7865: WHERE cz_ui_page_sets.ui_def_id = p_ui_def_id AND cz_ui_page_sets.deleted_flag = '0'
7866: ORDER BY last_update_date DESC;
7867:
7868: CURSOR ui_page_refs_cur(p_ui_def_id NUMBER)
7869: IS