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_REF_TEMPLATES

Line 6042: FROM cz_ui_ref_templates

6038:
6039: BEGIN
6040: SELECT template_id, ref_template_id, template_ui_def_id, ref_template_ui_def_id
6041: BULK COLLECT INTO l_template_id_tbl, l_ref_template_id_tbl, l_template_ui_tbl, l_ref_templ_ui_tbl
6042: FROM cz_ui_ref_templates
6043: WHERE cz_ui_ref_templates.template_id = cz_pb_mgr.g_ui_templates_old_temp_id_ref(i)
6044: -- vsingava 29th Oct '10. Bug10245926.
6045: -- Consider only source templates.
6046: AND cz_ui_ref_templates.template_ui_def_id = '0'

Line 6043: WHERE cz_ui_ref_templates.template_id = cz_pb_mgr.g_ui_templates_old_temp_id_ref(i)

6039: BEGIN
6040: SELECT template_id, ref_template_id, template_ui_def_id, ref_template_ui_def_id
6041: BULK COLLECT INTO l_template_id_tbl, l_ref_template_id_tbl, l_template_ui_tbl, l_ref_templ_ui_tbl
6042: FROM cz_ui_ref_templates
6043: WHERE cz_ui_ref_templates.template_id = cz_pb_mgr.g_ui_templates_old_temp_id_ref(i)
6044: -- vsingava 29th Oct '10. Bug10245926.
6045: -- Consider only source templates.
6046: AND cz_ui_ref_templates.template_ui_def_id = '0'
6047: AND cz_ui_ref_templates.deleted_flag = '0';

Line 6046: AND cz_ui_ref_templates.template_ui_def_id = '0'

6042: FROM cz_ui_ref_templates
6043: WHERE cz_ui_ref_templates.template_id = cz_pb_mgr.g_ui_templates_old_temp_id_ref(i)
6044: -- vsingava 29th Oct '10. Bug10245926.
6045: -- Consider only source templates.
6046: AND cz_ui_ref_templates.template_ui_def_id = '0'
6047: AND cz_ui_ref_templates.deleted_flag = '0';
6048: EXCEPTION
6049: WHEN NO_DATA_FOUND
6050: THEN

Line 6047: AND cz_ui_ref_templates.deleted_flag = '0';

6043: WHERE cz_ui_ref_templates.template_id = cz_pb_mgr.g_ui_templates_old_temp_id_ref(i)
6044: -- vsingava 29th Oct '10. Bug10245926.
6045: -- Consider only source templates.
6046: AND cz_ui_ref_templates.template_ui_def_id = '0'
6047: AND cz_ui_ref_templates.deleted_flag = '0';
6048: EXCEPTION
6049: WHEN NO_DATA_FOUND
6050: THEN
6051: NULL;

Line 6088: insert_into_table('CZ_UI_REF_TEMPLATES'

6084: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_TEMPLATE_UI_ref';
6085: rec_count := rec_count + 1;
6086: plsql_table_list(rec_count).col_name := 'ref_template_ui_def_id';
6087: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_REF_TEMPL_UI_ref';
6088: insert_into_table('CZ_UI_REF_TEMPLATES'
6089: ,'template_id'
6090: ,'ref_template_id'
6091: ,cz_pb_mgr.v_db_link
6092: ,plsql_table_list

Line 7224: delete_from_table('cz_ui_ref_templates','template_id','template_ui_def_id',

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
7223: IF NOT g_skip_templ_rollback THEN
7224: delete_from_table('cz_ui_ref_templates','template_id','template_ui_def_id',
7225: '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',
7226: 'cz_pb_mgr.g_REF_TEMPLATE_ID_ref','cz_pb_mgr.g_REF_TEMPL_UI_ref',cz_pb_mgr.g_TEMPLATE_ID_ref);
7227: END IF;
7228: --If UI action for templates inserted refine the array by removing action related to templates

Line 9182: FROM cz_ui_ref_templates

9178: IF l_rec_count > 0 THEN
9179: FOR i IN 1 .. l_rec_count LOOP
9180: l_temp_tbl.DELETE;
9181: SELECT ref_template_id BULK COLLECT INTO l_temp_tbl
9182: FROM cz_ui_ref_templates
9183: WHERE cz_ui_ref_templates.deleted_flag = '0'
9184: AND cz_ui_ref_templates.seeded_flag = '0'
9185: AND cz_ui_ref_templates.ref_template_ui_def_id = '0'
9186: AND cz_ui_ref_templates.ref_template_id IN

Line 9183: WHERE cz_ui_ref_templates.deleted_flag = '0'

9179: FOR i IN 1 .. l_rec_count LOOP
9180: l_temp_tbl.DELETE;
9181: SELECT ref_template_id BULK COLLECT INTO l_temp_tbl
9182: FROM cz_ui_ref_templates
9183: WHERE cz_ui_ref_templates.deleted_flag = '0'
9184: AND cz_ui_ref_templates.seeded_flag = '0'
9185: AND cz_ui_ref_templates.ref_template_ui_def_id = '0'
9186: AND cz_ui_ref_templates.ref_template_id IN
9187: (SELECT template_id

Line 9184: AND cz_ui_ref_templates.seeded_flag = '0'

9180: l_temp_tbl.DELETE;
9181: SELECT ref_template_id BULK COLLECT INTO l_temp_tbl
9182: FROM cz_ui_ref_templates
9183: WHERE cz_ui_ref_templates.deleted_flag = '0'
9184: AND cz_ui_ref_templates.seeded_flag = '0'
9185: AND cz_ui_ref_templates.ref_template_ui_def_id = '0'
9186: AND cz_ui_ref_templates.ref_template_id IN
9187: (SELECT template_id
9188: FROM cz_ui_templates t

Line 9185: AND cz_ui_ref_templates.ref_template_ui_def_id = '0'

9181: SELECT ref_template_id BULK COLLECT INTO l_temp_tbl
9182: FROM cz_ui_ref_templates
9183: WHERE cz_ui_ref_templates.deleted_flag = '0'
9184: AND cz_ui_ref_templates.seeded_flag = '0'
9185: AND cz_ui_ref_templates.ref_template_ui_def_id = '0'
9186: AND cz_ui_ref_templates.ref_template_id IN
9187: (SELECT template_id
9188: FROM cz_ui_templates t
9189: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0)

Line 9186: AND cz_ui_ref_templates.ref_template_id IN

9182: FROM cz_ui_ref_templates
9183: WHERE cz_ui_ref_templates.deleted_flag = '0'
9184: AND cz_ui_ref_templates.seeded_flag = '0'
9185: AND cz_ui_ref_templates.ref_template_ui_def_id = '0'
9186: AND cz_ui_ref_templates.ref_template_id IN
9187: (SELECT template_id
9188: FROM cz_ui_templates t
9189: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0)
9190: START WITH cz_ui_ref_templates.template_id = l_all_tmpl_tbl(i) AND cz_ui_ref_templates.template_ui_def_id = '0'

Line 9190: START WITH cz_ui_ref_templates.template_id = l_all_tmpl_tbl(i) AND cz_ui_ref_templates.template_ui_def_id = '0'

9186: AND cz_ui_ref_templates.ref_template_id IN
9187: (SELECT template_id
9188: FROM cz_ui_templates t
9189: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0)
9190: START WITH cz_ui_ref_templates.template_id = l_all_tmpl_tbl(i) AND cz_ui_ref_templates.template_ui_def_id = '0'
9191: CONNECT BY PRIOR ref_template_id = cz_ui_ref_templates.template_id
9192: AND PRIOR ref_template_ui_def_id = cz_ui_ref_templates.template_ui_def_id
9193: AND PRIOR cz_ui_ref_templates.deleted_flag = '0';
9194:

Line 9191: CONNECT BY PRIOR ref_template_id = cz_ui_ref_templates.template_id

9187: (SELECT template_id
9188: FROM cz_ui_templates t
9189: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0)
9190: START WITH cz_ui_ref_templates.template_id = l_all_tmpl_tbl(i) AND cz_ui_ref_templates.template_ui_def_id = '0'
9191: CONNECT BY PRIOR ref_template_id = cz_ui_ref_templates.template_id
9192: AND PRIOR ref_template_ui_def_id = cz_ui_ref_templates.template_ui_def_id
9193: AND PRIOR cz_ui_ref_templates.deleted_flag = '0';
9194:
9195: check_template_status(l_temp_tbl);

Line 9192: AND PRIOR ref_template_ui_def_id = cz_ui_ref_templates.template_ui_def_id

9188: FROM cz_ui_templates t
9189: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0)
9190: START WITH cz_ui_ref_templates.template_id = l_all_tmpl_tbl(i) AND cz_ui_ref_templates.template_ui_def_id = '0'
9191: CONNECT BY PRIOR ref_template_id = cz_ui_ref_templates.template_id
9192: AND PRIOR ref_template_ui_def_id = cz_ui_ref_templates.template_ui_def_id
9193: AND PRIOR cz_ui_ref_templates.deleted_flag = '0';
9194:
9195: check_template_status(l_temp_tbl);
9196: END LOOP;

Line 9193: AND PRIOR cz_ui_ref_templates.deleted_flag = '0';

9189: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0)
9190: START WITH cz_ui_ref_templates.template_id = l_all_tmpl_tbl(i) AND cz_ui_ref_templates.template_ui_def_id = '0'
9191: CONNECT BY PRIOR ref_template_id = cz_ui_ref_templates.template_id
9192: AND PRIOR ref_template_ui_def_id = cz_ui_ref_templates.template_ui_def_id
9193: AND PRIOR cz_ui_ref_templates.deleted_flag = '0';
9194:
9195: check_template_status(l_temp_tbl);
9196: END LOOP;
9197: END IF;

Line 11709: ,'cz_ui_ref_templates.ref_template_ui_def_id'

11705: ('cz_ui_nodes.ui_def_ref_id'
11706: ,'cz_ui_refs.ref_ui_def_id'
11707: ,'cz_ui_page_refs.target_ui_def_id'
11708: ,'cz_ui_page_elements.target_page_ui_def_id'
11709: ,'cz_ui_ref_templates.ref_template_ui_def_id'
11710: ,'cz_ui_actions.target_ui_def_id'
11711: )
11712: )
11713: THEN