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.

[Home] [Help]

APPS.CZ_PB_MGR dependencies on CZ_UI_CONT_TYPE_TEMPLS

Line 4978: ----bulk collect from cz_ui_cont_type_templs

4974: RAISE;
4975: END insert_ui_templates;
4976:
4977: --------------------------------------------------------------
4978: ----bulk collect from cz_ui_cont_type_templs
4979: PROCEDURE bulk_collect_cont_type_templs(p_cz_ui_defs_old_oa_ref cz_pb_mgr.t_ref)
4980: IS
4981: l_cnt_typ_tmpls_tmpid_tbl cz_pb_mgr.t_ref;
4982: l_cnt_typ_tmpls_uidef_tbl cz_pb_mgr.t_ref;

Line 5004: FROM cz_ui_cont_type_templs

5000: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
5001: THEN
5002: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5003: 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
5004: FROM cz_ui_cont_type_templs
5005: 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;
5006: ELSE
5007: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5008: 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 5005: 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;

5001: THEN
5002: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5003: 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
5004: FROM cz_ui_cont_type_templs
5005: 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;
5006: ELSE
5007: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5008: 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
5009: FROM cz_ui_cont_type_templs

Line 5009: FROM cz_ui_cont_type_templs

5005: 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;
5006: ELSE
5007: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5008: 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
5009: FROM cz_ui_cont_type_templs
5010: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef)
5011: AND cz_ui_cont_type_templs.seeded_flag <> seed_data
5012: AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted
5013: AND cz_ui_cont_type_templs.master_template_flag <> '1';

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

5006: ELSE
5007: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5008: 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
5009: FROM cz_ui_cont_type_templs
5010: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef)
5011: AND cz_ui_cont_type_templs.seeded_flag <> seed_data
5012: AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted
5013: AND cz_ui_cont_type_templs.master_template_flag <> '1';
5014: END IF;

Line 5011: AND cz_ui_cont_type_templs.seeded_flag <> seed_data

5007: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5008: 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
5009: FROM cz_ui_cont_type_templs
5010: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef)
5011: AND cz_ui_cont_type_templs.seeded_flag <> seed_data
5012: AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted
5013: AND cz_ui_cont_type_templs.master_template_flag <> '1';
5014: END IF;
5015:

Line 5012: AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted

5008: 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
5009: FROM cz_ui_cont_type_templs
5010: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef)
5011: AND cz_ui_cont_type_templs.seeded_flag <> seed_data
5012: AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted
5013: AND cz_ui_cont_type_templs.master_template_flag <> '1';
5014: END IF;
5015:
5016: IF (l_cnt_typ_tmpls_uidef_tbl.COUNT > 0)

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

5009: FROM cz_ui_cont_type_templs
5010: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef)
5011: AND cz_ui_cont_type_templs.seeded_flag <> seed_data
5012: AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted
5013: AND cz_ui_cont_type_templs.master_template_flag <> '1';
5014: END IF;
5015:
5016: IF (l_cnt_typ_tmpls_uidef_tbl.COUNT > 0)
5017: THEN

Line 5045: ----bulk collect from cz_ui_cont_type_templs

5041: RAISE;
5042: END bulk_collect_cont_type_templs;
5043:
5044: --------------------------------------------------------------------------
5045: ----bulk collect from cz_ui_cont_type_templs
5046: PROCEDURE bulk_collect_ui_actions(p_old_ui_def_tbl IN cz_pb_mgr.t_ref)
5047: IS
5048: l_ui_actns_ui_act_id_tbl cz_pb_mgr.t_ref;
5049: l_ui_actns_ui_uidef_tbl cz_pb_mgr.t_ref;

Line 5122: ----bulk collect from cz_ui_cont_type_templs

5118: RAISE;
5119: END bulk_collect_ui_actions;
5120:
5121: ----------------------------------------------------------
5122: ----bulk collect from cz_ui_cont_type_templs
5123: PROCEDURE bulk_collect_ui_images(p_old_ui_def_tbl cz_pb_mgr.t_ref)
5124: IS
5125: l_ui_images_ui_tbl cz_pb_mgr.t_ref;
5126: l_ui_images_usg_tbl cz_pb_mgr.t_ref;

Line 5617: insert_into_table('cz_ui_cont_type_templs'

5613: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cnt_typ_tmpls_tgtuidef_ref';
5614: rec_count := rec_count + 1;
5615: plsql_table_list(rec_count).col_name := 'content_type';
5616: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cnt_typ_tmpls_cont_ref';
5617: insert_into_table('cz_ui_cont_type_templs'
5618: ,'content_type'
5619: ,'ui_def_id'
5620: ,cz_pb_mgr.v_db_link
5621: ,plsql_table_list

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

5641: 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');
5642:
5643: ----resolve tmp ui_def_id, template id
5644: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
5645: 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');
5646: 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);
5647: END IF;
5648:
5649: plsql_table_list.DELETE;

Line 5662: insert_into_table('cz_ui_cont_type_templs'

5658: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cnt_typ_tmpls_tgtuidef_ref';
5659: rec_count := rec_count + 1;
5660: plsql_table_list(rec_count).col_name := 'content_type';
5661: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cnt_typ_tmpls_cont_ref';
5662: insert_into_table('cz_ui_cont_type_templs'
5663: ,'content_type'
5664: ,'ui_def_id'
5665: ,cz_pb_mgr.v_db_link
5666: ,plsql_table_list

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

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',
6511: 'cz_pb_mgr.g_REF_TEMPLATE_ID_ref','cz_pb_mgr.g_REF_TEMPL_UI_ref',cz_pb_mgr.g_TEMPLATE_ID_ref);
6512: delete_from_table('cz_ui_actions','ui_def_id','ui_action_id',v_database_link,'cz_pb_mgr.g_ui_actns_ui_uidef_ref','cz_pb_mgr.g_ui_actns_ui_act_id_ref',cz_pb_mgr.g_ui_actns_ui_uidef_ref);

Line 7178: FROM cz_ui_cont_type_templs

7174:
7175: CURSOR ui_cont_templs_cur(p_ui_def_id NUMBER)
7176: IS
7177: SELECT last_update_date
7178: FROM cz_ui_cont_type_templs
7179: WHERE cz_ui_cont_type_templs.ui_def_id = p_ui_def_id AND cz_ui_cont_type_templs.deleted_flag = '0'
7180: ORDER BY last_update_date DESC;
7181:
7182: CURSOR ui_actions_cur(p_ui_def_id NUMBER)

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

7175: CURSOR ui_cont_templs_cur(p_ui_def_id NUMBER)
7176: IS
7177: SELECT last_update_date
7178: FROM cz_ui_cont_type_templs
7179: WHERE cz_ui_cont_type_templs.ui_def_id = p_ui_def_id AND cz_ui_cont_type_templs.deleted_flag = '0'
7180: ORDER BY last_update_date DESC;
7181:
7182: CURSOR ui_actions_cur(p_ui_def_id NUMBER)
7183: IS