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_REFS

Line 1882: cz_pb_mgr.v_err_message := 'Insert into cz ui page refs: ' || SQLERRM;

1878: COMMIT;
1879: EXCEPTION
1880: WHEN OTHERS
1881: THEN
1882: cz_pb_mgr.v_err_message := 'Insert into cz ui page refs: ' || SQLERRM;
1883: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZUIPAGEREFS', SQLCODE);
1884: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
1885: RAISE;
1886: END;

Line 4136: FROM cz_ui_page_refs

4132: SELECT ui_def_id, page_set_id, page_ref_id, condition_id, caption_text_id
4133: ,target_ui_def_id, target_expl_node_id, caption_rule_id
4134: BULK COLLECT INTO l_page_refs_ui_def_tbl, l_page_refs_pg_set_tbl, l_page_refs_pg_ref_tbl, l_page_refs_cond_id_tbl, l_page_refs_capt_id_tbl
4135: ,l_page_refs_tgt_ui_tbl, l_page_refs_tgt_expl_tbl, l_page_refs_cpt_rule_tbl
4136: FROM cz_ui_page_refs
4137: WHERE cz_ui_page_refs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_page_refs.deleted_flag = record_not_deleted;
4138:
4139: IF (l_page_refs_ui_def_tbl.COUNT > 0)
4140: THEN

Line 4137: WHERE cz_ui_page_refs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_page_refs.deleted_flag = record_not_deleted;

4133: ,target_ui_def_id, target_expl_node_id, caption_rule_id
4134: BULK COLLECT INTO l_page_refs_ui_def_tbl, l_page_refs_pg_set_tbl, l_page_refs_pg_ref_tbl, l_page_refs_cond_id_tbl, l_page_refs_capt_id_tbl
4135: ,l_page_refs_tgt_ui_tbl, l_page_refs_tgt_expl_tbl, l_page_refs_cpt_rule_tbl
4136: FROM cz_ui_page_refs
4137: WHERE cz_ui_page_refs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_page_refs.deleted_flag = record_not_deleted;
4138:
4139: IF (l_page_refs_ui_def_tbl.COUNT > 0)
4140: THEN
4141: rec_count := cz_pb_mgr.g_page_refs_ui_def_old_ref.COUNT;

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

4163: THEN
4164: NULL;
4165: WHEN OTHERS
4166: THEN
4167: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_page_refs', 'SQLERRM', SQLERRM);
4168: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPAGEREFS', SQLCODE);
4169: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4170: RAISE;
4171: END bulk_collect_page_refs;

Line 4189: -----insert_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref,'caption ids of cz ui page refs');

4185: ---create rules for g_page_refs_cond_id_ref
4186: resolve_ids(cz_pb_mgr.g_page_refs_cpt_rule_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'caption rule id of page sets');
4187: resolve_ids(cz_pb_mgr.g_page_refs_cond_id_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'condition id of page sets');
4188: ----caption ids of ui pages
4189: -----insert_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref,'caption ids of cz ui page refs');
4190: resolve_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui page refs');
4191: ----resolve expl id
4192: resolve_ids(cz_pb_mgr.g_page_refs_tgt_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl ids of page refs');
4193: plsql_table_list.DELETE;

Line 4190: resolve_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui page refs');

4186: resolve_ids(cz_pb_mgr.g_page_refs_cpt_rule_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'caption rule id of page sets');
4187: resolve_ids(cz_pb_mgr.g_page_refs_cond_id_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'condition id of page sets');
4188: ----caption ids of ui pages
4189: -----insert_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref,'caption ids of cz ui page refs');
4190: resolve_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui page refs');
4191: ----resolve expl id
4192: resolve_ids(cz_pb_mgr.g_page_refs_tgt_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl ids of page refs');
4193: plsql_table_list.DELETE;
4194: rec_count := 1;

Line 4217: ,'cz_ui_page_refs.target_ui_def_id'

4213: resolve_ref_ids_not_found(cz_pb_mgr.g_page_refs_ui_def_new_ref
4214: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4215: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4216: ,cz_pb_mgr.g_page_refs_tgt_ui_ref
4217: ,'cz_ui_page_refs.target_ui_def_id'
4218: ,cz_pb_mgr.v_status_code
4219: );
4220: insert_into_table('cz_ui_page_refs'
4221: ,'ui_def_id'

Line 4220: insert_into_table('cz_ui_page_refs'

4216: ,cz_pb_mgr.g_page_refs_tgt_ui_ref
4217: ,'cz_ui_page_refs.target_ui_def_id'
4218: ,cz_pb_mgr.v_status_code
4219: );
4220: insert_into_table('cz_ui_page_refs'
4221: ,'ui_def_id'
4222: ,'page_set_id'
4223: ,'page_ref_id'
4224: ,cz_pb_mgr.v_db_link

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

4233: END IF;
4234: EXCEPTION
4235: WHEN OTHERS
4236: THEN
4237: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_page_refs', 'SQLERRM', SQLERRM);
4238: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIPAGEREFS', SQLCODE);
4239: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4240: RAISE;
4241: END insert_into_ui_page_refs;

Line 5581: ----insert into cz_ui_page_refs

5577: copy_train_docs;
5578: insert_into_ui_page_sets;
5579: -----bulk collect from page refs
5580: bulk_collect_page_refs;
5581: ----insert into cz_ui_page_refs
5582: insert_into_ui_page_refs;
5583: -----bulk collect from ui refs
5584: bulk_collect_ui_refs;
5585: ----insert into cz_ui_refs

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

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

Line 7148: FROM cz_ui_page_refs

7144:
7145: CURSOR ui_page_refs_cur(p_ui_def_id NUMBER)
7146: IS
7147: SELECT last_update_date
7148: FROM cz_ui_page_refs
7149: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id AND cz_ui_page_refs.deleted_flag = '0'
7150: ORDER BY last_update_date DESC;
7151:
7152: CURSOR ui_page_refs_capt_cur(p_ui_def_id NUMBER)

Line 7149: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id AND cz_ui_page_refs.deleted_flag = '0'

7145: CURSOR ui_page_refs_cur(p_ui_def_id NUMBER)
7146: IS
7147: SELECT last_update_date
7148: FROM cz_ui_page_refs
7149: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id AND cz_ui_page_refs.deleted_flag = '0'
7150: ORDER BY last_update_date DESC;
7151:
7152: CURSOR ui_page_refs_capt_cur(p_ui_def_id NUMBER)
7153: IS

Line 7157: FROM cz_ui_page_refs

7153: IS
7154: SELECT last_update_date
7155: FROM cz_intl_texts
7156: WHERE intl_text_id IN(SELECT caption_text_id
7157: FROM cz_ui_page_refs
7158: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id)
7159: ORDER BY last_update_date DESC;
7160:
7161: CURSOR ui_refs_cur(p_ui_def_id NUMBER)

Line 7158: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id)

7154: SELECT last_update_date
7155: FROM cz_intl_texts
7156: WHERE intl_text_id IN(SELECT caption_text_id
7157: FROM cz_ui_page_refs
7158: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id)
7159: ORDER BY last_update_date DESC;
7160:
7161: CURSOR ui_refs_cur(p_ui_def_id NUMBER)
7162: IS

Line 10951: ,'cz_ui_page_refs.target_ui_def_id'

10947: );
10948: ELSIF(p_column_name IN
10949: ('cz_ui_nodes.ui_def_ref_id'
10950: ,'cz_ui_refs.ref_ui_def_id'
10951: ,'cz_ui_page_refs.target_ui_def_id'
10952: ,'cz_ui_page_elements.target_page_ui_def_id'
10953: ,'cz_ui_ref_templates.ref_template_ui_def_id'
10954: ,'cz_ui_actions.target_ui_def_id'
10955: )