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_CONT_TYPE_TEMPLS

Line 5718: ----bulk collect from cz_ui_cont_type_templs

5714: RAISE;
5715: END insert_ui_templates;
5716:
5717: --------------------------------------------------------------
5718: ----bulk collect from cz_ui_cont_type_templs
5719: PROCEDURE bulk_collect_cont_type_templs(p_cz_ui_defs_old_oa_ref cz_pb_mgr.t_ref)
5720: IS
5721: l_cnt_typ_tmpls_tmpid_tbl cz_pb_mgr.t_ref;
5722: l_cnt_typ_tmpls_uidef_tbl cz_pb_mgr.t_ref;

Line 5744: FROM cz_ui_cont_type_templs

5740: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
5741: THEN
5742: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5743: BULK COLLECT INTO l_cnt_typ_tmpls_uidef_tbl, l_cnt_typ_tmpls_tmpid_tbl, l_cnt_typ_tmpls_tgtuidef_tbl, l_cnt_typ_tmpls_cont_tbl
5744: FROM cz_ui_cont_type_templs
5745: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted;
5746: ELSE
5747: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5748: BULK COLLECT INTO l_cnt_typ_tmpls_uidef_tbl, l_cnt_typ_tmpls_tmpid_tbl, l_cnt_typ_tmpls_tgtuidef_tbl, l_cnt_typ_tmpls_cont_tbl

Line 5745: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted;

5741: THEN
5742: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5743: BULK COLLECT INTO l_cnt_typ_tmpls_uidef_tbl, l_cnt_typ_tmpls_tmpid_tbl, l_cnt_typ_tmpls_tgtuidef_tbl, l_cnt_typ_tmpls_cont_tbl
5744: FROM cz_ui_cont_type_templs
5745: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted;
5746: ELSE
5747: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5748: BULK COLLECT INTO l_cnt_typ_tmpls_uidef_tbl, l_cnt_typ_tmpls_tmpid_tbl, l_cnt_typ_tmpls_tgtuidef_tbl, l_cnt_typ_tmpls_cont_tbl
5749: FROM cz_ui_cont_type_templs

Line 5749: FROM cz_ui_cont_type_templs

5745: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted;
5746: ELSE
5747: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5748: BULK COLLECT INTO l_cnt_typ_tmpls_uidef_tbl, l_cnt_typ_tmpls_tmpid_tbl, l_cnt_typ_tmpls_tgtuidef_tbl, l_cnt_typ_tmpls_cont_tbl
5749: FROM cz_ui_cont_type_templs
5750: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef)
5751: AND cz_ui_cont_type_templs.seeded_flag <> seed_data
5752: AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted
5753: AND cz_ui_cont_type_templs.master_template_flag <> '1';

Line 5750: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef)

5746: ELSE
5747: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5748: BULK COLLECT INTO l_cnt_typ_tmpls_uidef_tbl, l_cnt_typ_tmpls_tmpid_tbl, l_cnt_typ_tmpls_tgtuidef_tbl, l_cnt_typ_tmpls_cont_tbl
5749: FROM cz_ui_cont_type_templs
5750: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef)
5751: AND cz_ui_cont_type_templs.seeded_flag <> seed_data
5752: AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted
5753: AND cz_ui_cont_type_templs.master_template_flag <> '1';
5754: END IF;

Line 5751: AND cz_ui_cont_type_templs.seeded_flag <> seed_data

5747: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5748: BULK COLLECT INTO l_cnt_typ_tmpls_uidef_tbl, l_cnt_typ_tmpls_tmpid_tbl, l_cnt_typ_tmpls_tgtuidef_tbl, l_cnt_typ_tmpls_cont_tbl
5749: FROM cz_ui_cont_type_templs
5750: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef)
5751: AND cz_ui_cont_type_templs.seeded_flag <> seed_data
5752: AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted
5753: AND cz_ui_cont_type_templs.master_template_flag <> '1';
5754: END IF;
5755:

Line 5752: AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted

5748: BULK COLLECT INTO l_cnt_typ_tmpls_uidef_tbl, l_cnt_typ_tmpls_tmpid_tbl, l_cnt_typ_tmpls_tgtuidef_tbl, l_cnt_typ_tmpls_cont_tbl
5749: FROM cz_ui_cont_type_templs
5750: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef)
5751: AND cz_ui_cont_type_templs.seeded_flag <> seed_data
5752: AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted
5753: AND cz_ui_cont_type_templs.master_template_flag <> '1';
5754: END IF;
5755:
5756: IF (l_cnt_typ_tmpls_uidef_tbl.COUNT > 0)

Line 5753: AND cz_ui_cont_type_templs.master_template_flag <> '1';

5749: FROM cz_ui_cont_type_templs
5750: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef)
5751: AND cz_ui_cont_type_templs.seeded_flag <> seed_data
5752: AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted
5753: AND cz_ui_cont_type_templs.master_template_flag <> '1';
5754: END IF;
5755:
5756: IF (l_cnt_typ_tmpls_uidef_tbl.COUNT > 0)
5757: THEN

Line 5785: ----bulk collect from cz_ui_cont_type_templs

5781: RAISE;
5782: END bulk_collect_cont_type_templs;
5783:
5784: --------------------------------------------------------------------------
5785: ----bulk collect from cz_ui_cont_type_templs
5786: PROCEDURE bulk_collect_ui_actions(p_old_ui_def_tbl IN cz_pb_mgr.t_ref)
5787: IS
5788: l_ui_actns_ui_act_id_tbl cz_pb_mgr.t_ref;
5789: l_ui_actns_ui_uidef_tbl cz_pb_mgr.t_ref;

Line 5868: ----bulk collect from cz_ui_cont_type_templs

5864: RAISE;
5865: END bulk_collect_ui_actions;
5866:
5867: ----------------------------------------------------------
5868: ----bulk collect from cz_ui_cont_type_templs
5869: PROCEDURE bulk_collect_ui_images(p_old_ui_def_tbl cz_pb_mgr.t_ref)
5870: IS
5871: l_ui_images_ui_tbl cz_pb_mgr.t_ref;
5872: l_ui_images_usg_tbl cz_pb_mgr.t_ref;

Line 6371: insert_into_table('cz_ui_cont_type_templs'

6367: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cnt_typ_tmpls_tgtuidef_ref';
6368: rec_count := rec_count + 1;
6369: plsql_table_list(rec_count).col_name := 'content_type';
6370: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cnt_typ_tmpls_cont_ref';
6371: insert_into_table('cz_ui_cont_type_templs'
6372: ,'content_type'
6373: ,'ui_def_id'
6374: ,cz_pb_mgr.v_db_link
6375: ,plsql_table_list

Line 6399: resolve_tmpl_ui_defs(cz_pb_mgr.g_cnt_typ_tmpls_tgtuidef_ref, cz_pb_mgr.g_cnt_typ_tmpls_tmpid_ref, 'tmpl uidefs of cz_ui_cont_type_templs');

6395: resolve_ids(cz_pb_mgr.g_cnt_typ_tmpls_old_uidef_ref,cz_pb_mgr.g_cnt_typ_tmpls_new_uidef_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of cont type tmpls');
6396:
6397: ----resolve tmp ui_def_id, template id
6398: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
6399: resolve_tmpl_ui_defs(cz_pb_mgr.g_cnt_typ_tmpls_tgtuidef_ref, cz_pb_mgr.g_cnt_typ_tmpls_tmpid_ref, 'tmpl uidefs of cz_ui_cont_type_templs');
6400: resolve_ids(cz_pb_mgr.g_cnt_typ_tmpls_tmpid_ref, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'tmpl ids of ui def of cont type tmpls', ENTITY_TYPE_UCT);
6401: END IF;
6402:
6403: plsql_table_list.DELETE;

Line 6416: insert_into_table('cz_ui_cont_type_templs'

6412: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cnt_typ_tmpls_tgtuidef_ref';
6413: rec_count := rec_count + 1;
6414: plsql_table_list(rec_count).col_name := 'content_type';
6415: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cnt_typ_tmpls_cont_ref';
6416: insert_into_table('cz_ui_cont_type_templs'
6417: ,'content_type'
6418: ,'ui_def_id'
6419: ,cz_pb_mgr.v_db_link
6420: ,plsql_table_list

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

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
7223: IF NOT g_skip_templ_rollback THEN
7224: delete_from_table('cz_ui_ref_templates','template_id','template_ui_def_id',

Line 7901: FROM cz_ui_cont_type_templs

7897:
7898: CURSOR ui_cont_templs_cur(p_ui_def_id NUMBER)
7899: IS
7900: SELECT last_update_date
7901: FROM cz_ui_cont_type_templs
7902: WHERE cz_ui_cont_type_templs.ui_def_id = p_ui_def_id AND cz_ui_cont_type_templs.deleted_flag = '0'
7903: ORDER BY last_update_date DESC;
7904:
7905: CURSOR ui_actions_cur(p_ui_def_id NUMBER)

Line 7902: WHERE cz_ui_cont_type_templs.ui_def_id = p_ui_def_id AND cz_ui_cont_type_templs.deleted_flag = '0'

7898: CURSOR ui_cont_templs_cur(p_ui_def_id NUMBER)
7899: IS
7900: SELECT last_update_date
7901: FROM cz_ui_cont_type_templs
7902: WHERE cz_ui_cont_type_templs.ui_def_id = p_ui_def_id AND cz_ui_cont_type_templs.deleted_flag = '0'
7903: ORDER BY last_update_date DESC;
7904:
7905: CURSOR ui_actions_cur(p_ui_def_id NUMBER)
7906: IS