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 4015: FROM cz_ui_page_sets

4011: 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
4012: LOOP
4013: SELECT ui_def_id, page_set_id, train_jrad_doc, pagebase_expl_node_id
4014: BULK COLLECT INTO l_page_sets_ui_tbl, l_page_sets_pg_tbl, l_train_jrad_doc_tbl, l_pagebase_expl_tbl
4015: FROM cz_ui_page_sets
4016: 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);
4017:
4018: IF (l_page_sets_ui_tbl.COUNT > 0)
4019: THEN

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

4012: LOOP
4013: SELECT ui_def_id, page_set_id, train_jrad_doc, pagebase_expl_node_id
4014: BULK COLLECT INTO l_page_sets_ui_tbl, l_page_sets_pg_tbl, l_train_jrad_doc_tbl, l_pagebase_expl_tbl
4015: FROM cz_ui_page_sets
4016: 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);
4017:
4018: IF (l_page_sets_ui_tbl.COUNT > 0)
4019: THEN
4020: l_rec_count := cz_pb_mgr.g_page_sets_ui_old_ref.COUNT;

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

4036: THEN
4037: NULL;
4038: WHEN OTHERS
4039: THEN
4040: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_page_sets', 'SQLERRM', SQLERRM);
4041: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPAGESETS', SQLCODE);
4042: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4043: RAISE;
4044: END bulk_collect_page_sets;

Line 4047: ----insert into cz_ui_page_sets

4043: RAISE;
4044: END bulk_collect_page_sets;
4045:
4046: ---------------------------------------------------------------
4047: ----insert into cz_ui_page_sets
4048: PROCEDURE insert_into_ui_page_sets
4049: IS
4050: rec_count NUMBER := 0;
4051: plsql_table_list cz_pb_mgr.col_plsql_table_list;

Line 4069: insert_into_table('cz_ui_page_sets'

4065: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_page_sets_jrad_doc_ref';
4066: rec_count := rec_count + 1;
4067: plsql_table_list(rec_count).col_name := 'pagebase_expl_node_id';
4068: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_page_sets_expl_tbl';
4069: insert_into_table('cz_ui_page_sets'
4070: ,'ui_def_id'
4071: ,'page_set_id'
4072: ,cz_pb_mgr.v_db_link
4073: ,plsql_table_list

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

4079: END IF;
4080: EXCEPTION
4081: WHEN OTHERS
4082: THEN
4083: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_page_sets', 'SQLERRM', SQLERRM);
4084: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIPAGESETS', SQLCODE);
4085: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4086: RAISE;
4087: END insert_into_ui_page_sets;

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

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);
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',

Line 7141: FROM cz_ui_page_sets

7137:
7138: CURSOR ui_page_sets_cur(p_ui_def_id NUMBER)
7139: IS
7140: SELECT last_update_date
7141: FROM cz_ui_page_sets
7142: WHERE cz_ui_page_sets.ui_def_id = p_ui_def_id AND cz_ui_page_sets.deleted_flag = '0'
7143: ORDER BY last_update_date DESC;
7144:
7145: CURSOR ui_page_refs_cur(p_ui_def_id NUMBER)

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

7138: CURSOR ui_page_sets_cur(p_ui_def_id NUMBER)
7139: IS
7140: SELECT last_update_date
7141: FROM cz_ui_page_sets
7142: WHERE cz_ui_page_sets.ui_def_id = p_ui_def_id AND cz_ui_page_sets.deleted_flag = '0'
7143: ORDER BY last_update_date DESC;
7144:
7145: CURSOR ui_page_refs_cur(p_ui_def_id NUMBER)
7146: IS