[Home] [Help]
339: cz_pb_mgr.v_cz_func_expl_old_ref.DELETE;
340: cz_pb_mgr.v_cz_func_fld_old_ref.DELETE;
341: cz_pb_mgr.v_cz_func_obj_ref.DELETE;
342: END IF;
343: ELSIF(p_table_name = 'cz_ui_defs')
344: THEN
345: IF (p_table_type = 'tbl')
346: THEN
347: cz_pb_mgr.v_ui_devl_id_tbl.DELETE;
347: cz_pb_mgr.v_ui_devl_id_tbl.DELETE;
348: cz_pb_mgr.v_ui_comp_id_tbl.DELETE;
349: ELSIF(p_table_type = 'ref')
350: THEN
351: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
352: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
353: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
354: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
355: cz_pb_mgr.v_ui_devl_id_ref.DELETE;
348: cz_pb_mgr.v_ui_comp_id_tbl.DELETE;
349: ELSIF(p_table_type = 'ref')
350: THEN
351: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
352: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
353: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
354: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
355: cz_pb_mgr.v_ui_devl_id_ref.DELETE;
356: cz_pb_mgr.v_ui_comp_id_ref.DELETE;
349: ELSIF(p_table_type = 'ref')
350: THEN
351: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
352: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
353: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
354: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
355: cz_pb_mgr.v_ui_devl_id_ref.DELETE;
356: cz_pb_mgr.v_ui_comp_id_ref.DELETE;
357: cz_pb_mgr.v_ui_defs_mcpt_rule_ref.DELETE;
350: THEN
351: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
352: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
353: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
354: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
355: cz_pb_mgr.v_ui_devl_id_ref.DELETE;
356: cz_pb_mgr.v_ui_comp_id_ref.DELETE;
357: cz_pb_mgr.v_ui_defs_mcpt_rule_ref.DELETE;
358: cz_pb_mgr.v_ui_defs_pcpt_rule_ref.DELETE;
1034: END IF;
1035: END IF;
1036: ELSE
1037: BEGIN
1038: p_array_to_resolve(i) := cz_pb_mgr.v_cz_ui_defs_idx_ref(p_array_to_resolve(i));
1039: EXCEPTION
1040: WHEN OTHERS
1041: THEN
1042: NULL;
3034:
3035: --IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
3036: -- log_timing_message('SPITRE rework calling resolve_ids for - ui def id of cz intl texts');
3037: --END IF;
3038: resolve_ids(cz_pb_mgr.v_intl_text_ui_tbl, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def id of cz intl texts');
3039:
3040: IF (cz_pb_mgr.v_cz_intl_text_new_ref.COUNT > 0)
3041: THEN
3042: --------populate plsql_table_list for intl texts
3234: l_export_model_id := p_src_models(i);
3235: v_src_uis_tbl.DELETE;
3236:
3237: BEGIN
3238: SELECT cz_ui_defs.ui_def_id, cz_ui_defs.menu_caption_rule_id, cz_ui_defs.page_caption_rule_id, cz_ui_defs.from_master_template_id
3239: BULK COLLECT INTO v_src_uis_tbl, l_menu_caption_rule_tbl, l_page_caption_rule_tbl, l_from_mt_id_tbl
3240: FROM cz_ui_defs
3241: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.ui_style = oa_ui_style AND cz_ui_defs.deleted_flag = '0';
3242: EXCEPTION
3236:
3237: BEGIN
3238: SELECT cz_ui_defs.ui_def_id, cz_ui_defs.menu_caption_rule_id, cz_ui_defs.page_caption_rule_id, cz_ui_defs.from_master_template_id
3239: BULK COLLECT INTO v_src_uis_tbl, l_menu_caption_rule_tbl, l_page_caption_rule_tbl, l_from_mt_id_tbl
3240: FROM cz_ui_defs
3241: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.ui_style = oa_ui_style AND cz_ui_defs.deleted_flag = '0';
3242: EXCEPTION
3243: WHEN NO_DATA_FOUND
3244: THEN
3237: BEGIN
3238: SELECT cz_ui_defs.ui_def_id, cz_ui_defs.menu_caption_rule_id, cz_ui_defs.page_caption_rule_id, cz_ui_defs.from_master_template_id
3239: BULK COLLECT INTO v_src_uis_tbl, l_menu_caption_rule_tbl, l_page_caption_rule_tbl, l_from_mt_id_tbl
3240: FROM cz_ui_defs
3241: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.ui_style = oa_ui_style AND cz_ui_defs.deleted_flag = '0';
3242: EXCEPTION
3243: WHEN NO_DATA_FOUND
3244: THEN
3245: -----if there are no UI do not care
4207: AND cz_ui_templates.seeded_flag = '0'
4208: AND ( cz_ui_templates.ui_def_id = 0
4209: OR cz_ui_templates.ui_def_id IN(
4210: SELECT ui_def_id
4211: FROM cz_ui_defs
4212: WHERE cz_ui_defs.deleted_flag = '0'
4213: AND cz_ui_defs.devl_project_id IN(SELECT object_id
4214: FROM cz_rp_entries
4215: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0'))
4208: AND ( cz_ui_templates.ui_def_id = 0
4209: OR cz_ui_templates.ui_def_id IN(
4210: SELECT ui_def_id
4211: FROM cz_ui_defs
4212: WHERE cz_ui_defs.deleted_flag = '0'
4213: AND cz_ui_defs.devl_project_id IN(SELECT object_id
4214: FROM cz_rp_entries
4215: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0'))
4216: );
4209: OR cz_ui_templates.ui_def_id IN(
4210: SELECT ui_def_id
4211: FROM cz_ui_defs
4212: WHERE cz_ui_defs.deleted_flag = '0'
4213: AND cz_ui_defs.devl_project_id IN(SELECT object_id
4214: FROM cz_rp_entries
4215: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0'))
4216: );
4217:
4497: l_rec_count NUMBER;
4498: BEGIN
4499: pbdebug := 22029;
4500:
4501: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
4502: THEN
4503: cz_pb_mgr.g_cz_ui_pages_ui_def_ref.DELETE;
4504: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.DELETE;
4505: cz_pb_mgr.g_cz_ui_pages_capt_id_ref.DELETE;
4514: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;
4515: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl.DELETE;
4516: cz_pb_mgr.g_cz_ui_pages_expl_tbl.DELETE;
4517:
4518: 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
4519: LOOP
4520: l_cz_ui_pages_ui_def_tbl.DELETE;
4521: l_cz_ui_pages_jrad_doc_tbl.DELETE;
4522: l_cz_ui_pages_capt_id_tbl.DELETE;
4534: BULK COLLECT INTO l_cz_ui_pages_ui_def_tbl, l_cz_ui_pages_jrad_doc_tbl, l_cz_ui_pages_capt_id_tbl, l_cz_page_stat_templ_tbl
4535: ,l_cz_page_stat_uidef_tbl, l_cz_ui_pages_pgtmplid_tbl, l_cz_ui_pages_pgtmplui_tbl, l_cz_ui_pages_dis_cond_tbl
4536: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
4537: FROM cz_ui_pages
4538: WHERE cz_ui_pages.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_pages.deleted_flag = record_not_deleted;
4539:
4540: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)
4541: THEN
4542: l_rec_count := cz_pb_mgr.g_pages_ui_def_old_ref.COUNT;
4585:
4586: IF (cz_pb_mgr.g_pages_ui_def_old_ref.COUNT > 0)
4587: THEN
4588: ----resolve ui_def_id of ui pages
4589: resolve_ids(cz_pb_mgr.g_pages_ui_def_old_ref,cz_pb_mgr.g_cz_ui_pages_ui_def_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui pages');
4590:
4591: -- resolve page status and outer page templates
4592: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
4593: resolve_tmpl_ui_defs(g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_templ, v_cz_ui_defs_idx_ref, 'pg status templ uidefs of ui pages');
4589: resolve_ids(cz_pb_mgr.g_pages_ui_def_old_ref,cz_pb_mgr.g_cz_ui_pages_ui_def_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui pages');
4590:
4591: -- resolve page status and outer page templates
4592: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
4593: resolve_tmpl_ui_defs(g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_templ, v_cz_ui_defs_idx_ref, 'pg status templ uidefs of ui pages');
4594: resolve_ids(cz_pb_mgr.g_cz_ui_pages_stat_templ, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'pg stat templs of ui pages', ENTITY_TYPE_UCT);
4595: resolve_tmpl_ui_defs(g_cz_uipg_tmplui_tbl, g_cz_uipg_tmplui_tbl,g_cz_uipg_tmplid_tbl, v_cz_ui_defs_idx_ref, 'outer pg templ uidefs of ui pages');
4596: resolve_ids(cz_pb_mgr.g_cz_uipg_tmplid_tbl, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'outer page tmpl id of ui pages', ENTITY_TYPE_UCT);
4597: END IF;
4591: -- resolve page status and outer page templates
4592: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
4593: resolve_tmpl_ui_defs(g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_templ, v_cz_ui_defs_idx_ref, 'pg status templ uidefs of ui pages');
4594: resolve_ids(cz_pb_mgr.g_cz_ui_pages_stat_templ, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'pg stat templs of ui pages', ENTITY_TYPE_UCT);
4595: resolve_tmpl_ui_defs(g_cz_uipg_tmplui_tbl, g_cz_uipg_tmplui_tbl,g_cz_uipg_tmplid_tbl, v_cz_ui_defs_idx_ref, 'outer pg templ uidefs of ui pages');
4596: resolve_ids(cz_pb_mgr.g_cz_uipg_tmplid_tbl, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'outer page tmpl id of ui pages', ENTITY_TYPE_UCT);
4597: END IF;
4598:
4599: ----caption ids of ui pages
4657: l_train_jrad_doc_tbl varchar_type_tbl;
4658: BEGIN
4659: pbdebug := 22031;
4660:
4661: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
4662: THEN
4663: cz_pb_mgr.g_page_sets_ui_old_ref.DELETE;
4664: cz_pb_mgr.g_page_sets_ui_ref.DELETE;
4665: cz_pb_mgr.g_page_sets_pg_tbl.DELETE;
4665: cz_pb_mgr.g_page_sets_pg_tbl.DELETE;
4666: cz_pb_mgr.g_page_sets_jrad_doc_ref.DELETE;
4667: cz_pb_mgr.g_page_sets_expl_tbl.DELETE;
4668:
4669: 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
4670: LOOP
4671: SELECT ui_def_id, page_set_id, train_jrad_doc, pagebase_expl_node_id
4672: BULK COLLECT INTO l_page_sets_ui_tbl, l_page_sets_pg_tbl, l_train_jrad_doc_tbl, l_pagebase_expl_tbl
4673: FROM cz_ui_page_sets
4670: LOOP
4671: SELECT ui_def_id, page_set_id, train_jrad_doc, pagebase_expl_node_id
4672: BULK COLLECT INTO l_page_sets_ui_tbl, l_page_sets_pg_tbl, l_train_jrad_doc_tbl, l_pagebase_expl_tbl
4673: FROM cz_ui_page_sets
4674: 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);
4675:
4676: IF (l_page_sets_ui_tbl.COUNT > 0)
4677: THEN
4678: l_rec_count := cz_pb_mgr.g_page_sets_ui_old_ref.COUNT;
4711: IF (cz_pb_mgr.g_page_sets_ui_old_ref.COUNT > 0)
4712: THEN
4713: pbdebug := 22032;
4714: ----resolve ui_def_id of page sets
4715: resolve_ids(cz_pb_mgr.g_page_sets_ui_old_ref,cz_pb_mgr.g_page_sets_ui_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of page sets');
4716: resolve_ids(cz_pb_mgr.g_page_sets_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl node id of page sets');
4717: plsql_table_list.DELETE;
4718: rec_count := 1;
4719: plsql_table_list(rec_count).col_name := 'ui_def_id';
4762: l_page_refs_tgt_expl_tbl cz_pb_mgr.t_ref;
4763: l_page_refs_cpt_rule_tbl cz_pb_mgr.t_ref;
4764: rec_count NUMBER := 0;
4765: BEGIN
4766: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
4767: THEN
4768: cz_pb_mgr.g_page_refs_ui_def_old_ref.DELETE;
4769: cz_pb_mgr.g_page_refs_ui_def_new_ref.DELETE;
4770: cz_pb_mgr.g_page_refs_cond_id_ref.DELETE;
4777: cz_pb_mgr.g_page_refs_tgt_expl_tbl.DELETE;
4778: cz_pb_mgr.g_page_refs_cpt_rule_tbl.DELETE;
4779: pbdebug := 22033;
4780:
4781: 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
4782: LOOP
4783: l_page_refs_ui_def_tbl.DELETE;
4784: l_page_refs_cond_id_tbl.DELETE;
4785: l_page_refs_capt_id_tbl.DELETE;
4791: ,target_ui_def_id, target_expl_node_id, caption_rule_id
4792: 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
4793: ,l_page_refs_tgt_ui_tbl, l_page_refs_tgt_expl_tbl, l_page_refs_cpt_rule_tbl
4794: FROM cz_ui_page_refs
4795: 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;
4796:
4797: IF (l_page_refs_ui_def_tbl.COUNT > 0)
4798: THEN
4799: rec_count := cz_pb_mgr.g_page_refs_ui_def_old_ref.COUNT;
4838: IF (cz_pb_mgr.g_page_refs_ui_def_old_ref.COUNT > 0)
4839: THEN
4840: pbdebug := 22034;
4841: ----resolve ui_def_id
4842: resolve_ids(cz_pb_mgr.g_page_refs_ui_def_old_ref,cz_pb_mgr.g_page_refs_ui_def_new_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of page refs');
4843:
4844: ---bug14004074. Should not resolve caption_rule_id of page refs as this will have always a seeded value.
4845: --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 refs');
4846:
4871: plsql_table_list(rec_count).col_name := 'condition_id';
4872: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_page_refs_cond_id_ref';
4873: -- should call resolve_ids instead
4874: resolve_ref_ids_not_found(cz_pb_mgr.g_page_refs_ui_def_new_ref
4875: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4876: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4877: ,cz_pb_mgr.g_page_refs_tgt_ui_ref
4878: ,'cz_ui_page_refs.target_ui_def_id'
4879: ,cz_pb_mgr.v_status_code
4872: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_page_refs_cond_id_ref';
4873: -- should call resolve_ids instead
4874: resolve_ref_ids_not_found(cz_pb_mgr.g_page_refs_ui_def_new_ref
4875: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4876: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4877: ,cz_pb_mgr.g_page_refs_tgt_ui_ref
4878: ,'cz_ui_page_refs.target_ui_def_id'
4879: ,cz_pb_mgr.v_status_code
4880: );
4909: l_ui_refs_ref_ui_def_tbl cz_pb_mgr.t_ref;
4910: l_ui_refs_expl_id_tbl cz_pb_mgr.t_ref;
4911: rec_count NUMBER := 0;
4912: BEGIN
4913: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
4914: THEN
4915: cz_pb_mgr.g_ui_refs_old_ui_def_ref.DELETE;
4916: cz_pb_mgr.g_ui_refs_new_ui_def_ref.DELETE;
4917: cz_pb_mgr.g_ui_refs_ref_ui_def_ref.DELETE;
4918: cz_pb_mgr.g_ui_refs_expl_id_ref.DELETE;
4919: cz_pb_mgr.g_ui_refs_ref_ui_def_old_ref.DELETE;
4920: cz_pb_mgr.g_ui_refs_expl_id_old_ref.DELETE;
4921:
4922: 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
4923: LOOP
4924: l_ui_refs_ui_def_tbl.DELETE;
4925: l_ui_refs_ref_ui_def_tbl.DELETE;
4926: l_ui_refs_expl_id_tbl.DELETE;
4927:
4928: SELECT ui_def_id, ref_ui_def_id, model_ref_expl_id
4929: BULK COLLECT INTO l_ui_refs_ui_def_tbl, l_ui_refs_ref_ui_def_tbl, l_ui_refs_expl_id_tbl
4930: FROM cz_ui_refs
4931: WHERE cz_ui_refs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_refs.deleted_flag = record_not_deleted;
4932:
4933: IF (l_ui_refs_ui_def_tbl.COUNT > 0)
4934: THEN
4935: rec_count := cz_pb_mgr.g_ui_refs_old_ui_def_ref.COUNT;
4968: BEGIN
4969: IF (cz_pb_mgr.g_ui_refs_old_ui_def_ref.COUNT > 0)
4970: THEN
4971: ----resolve ui_def_id
4972: resolve_ids(cz_pb_mgr.g_ui_refs_old_ui_def_ref,cz_pb_mgr.g_ui_refs_new_ui_def_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui refs');
4973: ----resolve model ref expl id
4974: resolve_ids(cz_pb_mgr.g_ui_refs_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl ids of page refs');
4975: plsql_table_list.DELETE;
4976: rec_count := 1;
4983: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
4984: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_refs_expl_id_ref';
4985: -- should call resolve_ids instead
4986: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_refs_new_ui_def_ref
4987: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4988: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4989: ,cz_pb_mgr.g_ui_refs_ref_ui_def_ref
4990: ,'cz_ui_refs.ref_ui_def_id'
4991: ,cz_pb_mgr.v_status_code
4984: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_refs_expl_id_ref';
4985: -- should call resolve_ids instead
4986: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_refs_new_ui_def_ref
4987: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4988: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4989: ,cz_pb_mgr.g_ui_refs_ref_ui_def_ref
4990: ,'cz_ui_refs.ref_ui_def_id'
4991: ,cz_pb_mgr.v_status_code
4992: );
5028: l_ui_ps_maps_element_tbl varchar_type_tbl;
5029: l_ui_ps_maps_tgt_pg_ui_def_tbl cz_pb_mgr.t_ref;
5030: rec_count NUMBER := 0;
5031: BEGIN
5032: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
5033: THEN
5034: cz_pb_mgr.g_ui_ps_maps_old_ui_def_ref.DELETE;
5035: cz_pb_mgr.g_ui_ps_maps_new_ui_def_ref.DELETE;
5036: cz_pb_mgr.g_ui_ps_maps_ctrl_tmp_ref.DELETE;
5040: cz_pb_mgr.g_ui_ps_maps_templ_ui_tbl.DELETE;
5041: cz_pb_mgr.g_ui_ps_maps_elem_sig_tbl.DELETE;
5042: cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl.DELETE;
5043:
5044: 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
5045: LOOP
5046: l_ui_ps_maps_ui_def_tbl.DELETE;
5047: l_ui_ps_maps_ctrl_tmp_tbl.DELETE;
5048: l_ui_ps_maps_page_id_tbl.DELETE;
5057: ,model_ref_expl_id, ctrl_template_ui_def_id, element_signature_id, target_page_ui_def_id
5058: BULK COLLECT INTO l_ui_ps_maps_ui_def_tbl, l_ui_ps_maps_ctrl_tmp_tbl, l_ui_ps_maps_page_id_tbl, l_ui_ps_maps_element_tbl
5059: ,l_ui_ps_maps_expl_id_tbl, l_ui_ps_maps_ctrl_temp_ui_tbl, l_ui_ps_maps_elem_sig_tbl, l_ui_ps_maps_tgt_pg_ui_def_tbl
5060: FROM cz_ui_page_elements
5061: WHERE cz_ui_page_elements.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef)
5062: AND cz_ui_page_elements.deleted_flag = record_not_deleted;
5063: EXCEPTION
5064: WHEN NO_DATA_FOUND
5065: THEN
5104: BEGIN
5105: IF (cz_pb_mgr.g_ui_ps_maps_old_ui_def_ref.COUNT > 0)
5106: THEN
5107: ----resolve ui_def_id
5108: resolve_ids(cz_pb_mgr.g_ui_ps_maps_old_ui_def_ref,cz_pb_mgr.g_ui_ps_maps_new_ui_def_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui ps maps');
5109:
5110: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
5111: resolve_tmpl_ui_defs(cz_pb_mgr.g_ui_ps_maps_templ_ui_tbl, cz_pb_mgr.g_ui_ps_maps_ctrl_tmp_ref, 'ctrl tmp ui def ids of ui ps maps');
5112: resolve_ids(cz_pb_mgr.g_ui_ps_maps_ctrl_tmp_ref, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'ctrl template id of ui ps maps', ENTITY_TYPE_UCT);
5135: plsql_table_list(rec_count).col_name := 'TARGET_PAGE_UI_DEF_ID';
5136: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl';
5137: -- should call resolve_ids instead
5138: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_ps_maps_new_ui_def_ref
5139: ,cz_pb_mgr.v_cz_ui_defs_old_ref
5140: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
5141: ,cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl
5142: ,'cz_ui_page_elements.target_page_ui_def_id'
5143: ,cz_pb_mgr.v_status_code
5136: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl';
5137: -- should call resolve_ids instead
5138: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_ps_maps_new_ui_def_ref
5139: ,cz_pb_mgr.v_cz_ui_defs_old_ref
5140: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
5141: ,cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl
5142: ,'cz_ui_page_elements.target_page_ui_def_id'
5143: ,cz_pb_mgr.v_status_code
5144: );
5567: --But there is a possibility that it would introduce regression in publishing
5568: --and taking the safer route here.
5569: IF (cz_pb_mgr.v_session_parameter = pub_model)
5570: THEN
5571: resolve_ids(cz_pb_mgr.g_ui_templates_ui_def_new_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'resolving ui defs of templates');
5572: ELSE
5573: resolve_tmpl_ui_defs(cz_pb_mgr.g_ui_templates_ui_def_new_ref, cz_pb_mgr.g_ui_templates_old_temp_id_ref, 'resolving ui defs of templates');
5574: END IF;
5575: -----resolve button bar templates
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;
5723: l_cnt_typ_tmpls_tgtuidef_tbl cz_pb_mgr.t_ref;
5723: l_cnt_typ_tmpls_tgtuidef_tbl cz_pb_mgr.t_ref;
5724: l_cnt_typ_tmpls_cont_tbl cz_pb_mgr.t_ref;
5725: rec_count NUMBER := 0;
5726: BEGIN
5727: IF (p_cz_ui_defs_old_oa_ref.COUNT > 0)
5728: THEN
5729: cz_pb_mgr.g_cnt_typ_tmpls_tmpid_ref.DELETE;
5730: cz_pb_mgr.g_cnt_typ_tmpls_old_uidef_ref.DELETE;
5731: cz_pb_mgr.g_cnt_typ_tmpls_new_uidef_ref.DELETE;
5729: cz_pb_mgr.g_cnt_typ_tmpls_tmpid_ref.DELETE;
5730: cz_pb_mgr.g_cnt_typ_tmpls_old_uidef_ref.DELETE;
5731: cz_pb_mgr.g_cnt_typ_tmpls_new_uidef_ref.DELETE;
5732:
5733: FOR uidef IN p_cz_ui_defs_old_oa_ref.FIRST .. p_cz_ui_defs_old_oa_ref.LAST
5734: LOOP
5735: l_cnt_typ_tmpls_tmpid_tbl.DELETE;
5736: l_cnt_typ_tmpls_uidef_tbl.DELETE;
5737: l_cnt_typ_tmpls_cont_tbl.DELETE;
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
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;
5973: LOOP
5974: l_new_document :=
5975: REPLACE(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc)
5976: ,TO_CHAR(cz_pb_mgr.g_pages_ui_def_old_ref(doc))
5977: ,TO_CHAR(cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.g_pages_ui_def_old_ref(doc)))
5978: );
5979: insert_into_repository(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc), l_new_document, cz_pb_mgr.v_db_link , 'UI_PAGE');
5980: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc) := l_new_document;
5981: END LOOP;
5997: LOOP
5998: l_new_document :=
5999: REPLACE(cz_pb_mgr.g_page_sets_jrad_doc_ref(doc)
6000: ,'ui' || TO_CHAR(cz_pb_mgr.g_page_sets_ui_old_ref(doc))
6001: ,'ui' || TO_CHAR(cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.g_page_sets_ui_old_ref(doc)))
6002: );
6003: insert_into_repository(cz_pb_mgr.g_page_sets_jrad_doc_ref(doc), l_new_document, cz_pb_mgr.v_db_link, 'ui page set');
6004: cz_pb_mgr.g_page_sets_jrad_doc_ref(doc) := l_new_document;
6005: END LOOP;
6245:
6246: BEGIN
6247: SELECT intl_text_id
6248: BULK COLLECT INTO l_intl_text_id_tbl
6249: FROM cz_intl_texts txt, cz_ui_defs ui
6250: WHERE txt.model_id = cz_pb_mgr.v_models_to_be_exported(i)
6251: AND txt.deleted_flag = '0'
6252: AND NVL(txt.seeded_flag, '0') = '0'
6253: AND NVL(txt.ui_def_id, -1) = ui.ui_def_id
6389: END IF;
6390: END IF;
6391:
6392: ----resolve ui_def_id
6393: bulk_collect_cont_type_templs(cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
6394:
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
6391:
6392: ----resolve ui_def_id
6393: bulk_collect_cont_type_templs(cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
6394:
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');
6433: END LOOP;
6434: END IF;
6435:
6436: ----bulk collect ui actions
6437: bulk_collect_ui_actions(cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
6438:
6439: -- Note g_ui_actns_ui_act_id_ref contains both local ui actions (bulk_collect_ui_actions)
6440: -- and global ones (collect_global_actions). The 'new' ids in this array are the same old
6441: -- ids as the ones in g_ui_actns_ui_act_id_old_ref. They are real new ids only when the
6441: -- ids as the ones in g_ui_actns_ui_act_id_old_ref. They are real new ids only when the
6442: -- session is remote migration and the actions are globals.
6443:
6444: ----resolve ui_def_id
6445: resolve_ids(cz_pb_mgr.g_ui_actns_ui_uidef_old_ref,cz_pb_mgr.g_ui_actns_ui_uidef_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui actions');
6446: -- ignore expl id resolution failure because of a ui refresh issue (see 6817586)
6447: resolve_ids(cz_pb_mgr.g_ui_actns_tgtexpl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of ui actions', FLD_IGNORE_NOW);
6448: -- context_component_id, obsolete
6449: -- resolve_ids(cz_pb_mgr.g_ui_actns_ctx_comp_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'ctx comp id of ui actions');
6493: plsql_table_list(rec_count).col_name := 'main_message_text_id';
6494: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_uiact_main_msg_tbl';
6495: -- should call resolve_ids instead
6496: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_actns_ui_uidef_ref
6497: ,cz_pb_mgr.v_cz_ui_defs_old_ref
6498: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
6499: ,cz_pb_mgr.g_ui_actns_ui_tgtui_ref
6500: ,'cz_ui_actions.target_ui_def_id'
6501: ,cz_pb_mgr.v_status_code
6494: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_uiact_main_msg_tbl';
6495: -- should call resolve_ids instead
6496: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_actns_ui_uidef_ref
6497: ,cz_pb_mgr.v_cz_ui_defs_old_ref
6498: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
6499: ,cz_pb_mgr.g_ui_actns_ui_tgtui_ref
6500: ,'cz_ui_actions.target_ui_def_id'
6501: ,cz_pb_mgr.v_status_code
6502: );
6560: END IF;
6561: END IF;
6562:
6563: ----resolve ui_def_id
6564: bulk_collect_ui_images(cz_pb_mgr.v_cz_ui_defs_old_ref);
6565: resolve_ids(cz_pb_mgr.v_ui_images_ui_tbl,cz_pb_mgr.v_ui_images_ui_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui images');
6566: -----insert into ui images
6567: plsql_table_list.DELETE;
6568: rec_count := 1;
6561: END IF;
6562:
6563: ----resolve ui_def_id
6564: bulk_collect_ui_images(cz_pb_mgr.v_cz_ui_defs_old_ref);
6565: resolve_ids(cz_pb_mgr.v_ui_images_ui_tbl,cz_pb_mgr.v_ui_images_ui_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui images');
6566: -----insert into ui images
6567: plsql_table_list.DELETE;
6568: rec_count := 1;
6569: plsql_table_list(rec_count).col_name := 'ui_def_id';
6637:
6638: BEGIN
6639: SELECT ui_def_id, ui_style
6640: INTO l_ui_def_id, l_ui_style
6641: FROM cz_ui_defs
6642: WHERE cz_ui_defs.ui_def_id = p_ui_def_id AND cz_ui_defs.deleted_flag = record_not_deleted;
6643: EXCEPTION
6644: WHEN NO_DATA_FOUND
6645: THEN
6638: BEGIN
6639: SELECT ui_def_id, ui_style
6640: INTO l_ui_def_id, l_ui_style
6641: FROM cz_ui_defs
6642: WHERE cz_ui_defs.ui_def_id = p_ui_def_id AND cz_ui_defs.deleted_flag = record_not_deleted;
6643: EXCEPTION
6644: WHEN NO_DATA_FOUND
6645: THEN
6646: RAISE ui_def_id_not_found;
6650: THEN
6651: RAISE not_oa_style_ui;
6652: END IF;
6653:
6654: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
6655: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
6656: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
6657: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6658: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
6651: RAISE not_oa_style_ui;
6652: END IF;
6653:
6654: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
6655: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
6656: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
6657: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6658: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
6659: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_ui_def_id;
6652: END IF;
6653:
6654: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
6655: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
6656: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
6657: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6658: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
6659: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_ui_def_id;
6660: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_ui_def_id;
6653:
6654: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
6655: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
6656: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
6657: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6658: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
6659: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_ui_def_id;
6660: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_ui_def_id;
6661: l_child_ui_tbl.DELETE;
6654: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
6655: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
6656: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
6657: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6658: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
6659: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_ui_def_id;
6660: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_ui_def_id;
6661: l_child_ui_tbl.DELETE;
6662:
6655: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
6656: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
6657: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6658: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
6659: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_ui_def_id;
6660: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_ui_def_id;
6661: l_child_ui_tbl.DELETE;
6662:
6663: BEGIN
6656: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
6657: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6658: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
6659: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_ui_def_id;
6660: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_ui_def_id;
6661: l_child_ui_tbl.DELETE;
6662:
6663: BEGIN
6664: SELECT ref_ui_def_id
6672: END;
6673:
6674: IF (l_child_ui_tbl.COUNT > 0)
6675: THEN
6676: rec_count := cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT + 1;
6677:
6678: FOR i IN l_child_ui_tbl.FIRST .. l_child_ui_tbl.LAST
6679: LOOP
6680: rec_count := rec_count + 1;
6677:
6678: FOR i IN l_child_ui_tbl.FIRST .. l_child_ui_tbl.LAST
6679: LOOP
6680: rec_count := rec_count + 1;
6681: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_child_ui_tbl(i);
6682: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_child_ui_tbl(i);
6683: END LOOP;
6684: END IF;
6685:
6678: FOR i IN l_child_ui_tbl.FIRST .. l_child_ui_tbl.LAST
6679: LOOP
6680: rec_count := rec_count + 1;
6681: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_child_ui_tbl(i);
6682: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_child_ui_tbl(i);
6683: END LOOP;
6684: END IF;
6685:
6686: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
6682: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_child_ui_tbl(i);
6683: END LOOP;
6684: END IF;
6685:
6686: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
6687: THEN
6688: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6689: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
6690: IF (v_cz_ui_defs_old_ref.COUNT > 0) THEN
6684: END IF;
6685:
6686: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
6687: THEN
6688: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6689: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
6690: IF (v_cz_ui_defs_old_ref.COUNT > 0) THEN
6691: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
6692: LOOP
6685:
6686: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
6687: THEN
6688: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6689: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
6690: IF (v_cz_ui_defs_old_ref.COUNT > 0) THEN
6691: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
6692: LOOP
6693: rec_count := rec_count + 1;
6686: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
6687: THEN
6688: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6689: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
6690: IF (v_cz_ui_defs_old_ref.COUNT > 0) THEN
6691: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
6692: LOOP
6693: rec_count := rec_count + 1;
6694: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
6687: THEN
6688: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6689: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
6690: IF (v_cz_ui_defs_old_ref.COUNT > 0) THEN
6691: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
6692: LOOP
6693: rec_count := rec_count + 1;
6694: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
6695: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq, 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr);
6690: IF (v_cz_ui_defs_old_ref.COUNT > 0) THEN
6691: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
6692: LOOP
6693: rec_count := rec_count + 1;
6694: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
6695: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq, 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr);
6696:
6697: IF (cz_pb_mgr.v_cz_ui_defs_old_ref(k) = p_ui_def_id)
6698: THEN
6691: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
6692: LOOP
6693: rec_count := rec_count + 1;
6694: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
6695: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq, 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr);
6696:
6697: IF (cz_pb_mgr.v_cz_ui_defs_old_ref(k) = p_ui_def_id)
6698: THEN
6699: x_ui_def_id := cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count);
6693: rec_count := rec_count + 1;
6694: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
6695: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq, 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr);
6696:
6697: IF (cz_pb_mgr.v_cz_ui_defs_old_ref(k) = p_ui_def_id)
6698: THEN
6699: x_ui_def_id := cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count);
6700: END IF;
6701:
6695: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq, 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr);
6696:
6697: IF (cz_pb_mgr.v_cz_ui_defs_old_ref(k) = p_ui_def_id)
6698: THEN
6699: x_ui_def_id := cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count);
6700: END IF;
6701:
6702: cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.v_cz_ui_defs_old_ref(k)):=cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count);
6703: END LOOP;
6698: THEN
6699: x_ui_def_id := cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count);
6700: END IF;
6701:
6702: cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.v_cz_ui_defs_old_ref(k)):=cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count);
6703: END LOOP;
6704: END IF;
6705:
6706: --------populate plsql_table_list for ui_defs
6706: --------populate plsql_table_list for ui_defs
6707: plsql_table_list.DELETE;
6708: rec_count := 1;
6709: plsql_table_list(rec_count).col_name := 'ui_def_id';
6710: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_defs_new_ref';
6711: insert_into_table('cz_ui_defs'
6712: ,'ui_def_id'
6713: ,cz_pb_mgr.v_db_link
6714: ,plsql_table_list
6707: plsql_table_list.DELETE;
6708: rec_count := 1;
6709: plsql_table_list(rec_count).col_name := 'ui_def_id';
6710: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_defs_new_ref';
6711: insert_into_table('cz_ui_defs'
6712: ,'ui_def_id'
6713: ,cz_pb_mgr.v_db_link
6714: ,plsql_table_list
6715: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
6711: insert_into_table('cz_ui_defs'
6712: ,'ui_def_id'
6713: ,cz_pb_mgr.v_db_link
6714: ,plsql_table_list
6715: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
6716: ,cz_pb_mgr.v_cz_ui_defs_old_ref
6717: );
6718: ------export oa uis
6719: export_oa_uis;
6712: ,'ui_def_id'
6713: ,cz_pb_mgr.v_db_link
6714: ,plsql_table_list
6715: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
6716: ,cz_pb_mgr.v_cz_ui_defs_old_ref
6717: );
6718: ------export oa uis
6719: export_oa_uis;
6720: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
6716: ,cz_pb_mgr.v_cz_ui_defs_old_ref
6717: );
6718: ------export oa uis
6719: export_oa_uis;
6720: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
6721: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
6722: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
6723: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6724: END IF;
6717: );
6718: ------export oa uis
6719: export_oa_uis;
6720: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
6721: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
6722: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
6723: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6724: END IF;
6725: EXCEPTION
6718: ------export oa uis
6719: export_oa_uis;
6720: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
6721: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
6722: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
6723: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6724: END IF;
6725: EXCEPTION
6726: WHEN ui_def_id_is_null
6719: export_oa_uis;
6720: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
6721: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
6722: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
6723: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
6724: END IF;
6725: EXCEPTION
6726: WHEN ui_def_id_is_null
6727: THEN
7186: -- ,v_database_link
7187: -- ,'cz_pb_mgr.v_models_to_be_exported_new'
7188: -- ,cz_pb_mgr.v_models_to_be_exported_new
7189: -- );
7190: delete_from_table('cz_ui_defs', 'ui_def_id', v_database_link, 'cz_pb_mgr.v_cz_ui_defs_new_ref', cz_pb_mgr.v_cz_ui_defs_new_ref);
7191: delete_from_table('cz_ui_properties', 'ui_def_id', v_database_link, 'cz_pb_mgr.v_cz_ui_defs_new_ref', cz_pb_mgr.v_cz_ui_defs_new_ref);
7192: delete_from_table('cz_ui_nodes', 'ui_node_id', v_database_link, 'cz_pb_mgr.v_cz_ui_nodes_new_ref', cz_pb_mgr.v_cz_ui_nodes_new_ref);
7193: delete_from_table('cz_ui_node_props', 'ui_node_id', v_database_link, 'cz_pb_mgr.v_cz_ui_nodes_new_ref', cz_pb_mgr.v_cz_ui_nodes_new_ref);
7194: delete_from_table('cz_model_ref_expls'
7187: -- ,'cz_pb_mgr.v_models_to_be_exported_new'
7188: -- ,cz_pb_mgr.v_models_to_be_exported_new
7189: -- );
7190: delete_from_table('cz_ui_defs', 'ui_def_id', v_database_link, 'cz_pb_mgr.v_cz_ui_defs_new_ref', cz_pb_mgr.v_cz_ui_defs_new_ref);
7191: delete_from_table('cz_ui_properties', 'ui_def_id', v_database_link, 'cz_pb_mgr.v_cz_ui_defs_new_ref', cz_pb_mgr.v_cz_ui_defs_new_ref);
7192: delete_from_table('cz_ui_nodes', 'ui_node_id', v_database_link, 'cz_pb_mgr.v_cz_ui_nodes_new_ref', cz_pb_mgr.v_cz_ui_nodes_new_ref);
7193: delete_from_table('cz_ui_node_props', 'ui_node_id', v_database_link, 'cz_pb_mgr.v_cz_ui_nodes_new_ref', cz_pb_mgr.v_cz_ui_nodes_new_ref);
7194: delete_from_table('cz_model_ref_expls'
7195: ,'model_ref_expl_id'
7689: )
7690: AS
7691: v_ui_def_count NUMBER := 0;
7692: v_src_uis_tbl cz_pb_mgr.t_ref;
7693: v_cz_ui_defs_old_ref_idx_ref cz_pb_mgr.t_ref_idx_vc2;
7694: l_export_model_id cz_devl_projects.devl_project_id%TYPE;
7695: BEGIN
7696: IF (p_src_models.COUNT > 0)
7697: THEN
7702: l_export_model_id := p_src_models(i);
7703: v_src_uis_tbl.DELETE;
7704:
7705: BEGIN
7706: SELECT cz_ui_defs.ui_def_id
7707: BULK COLLECT INTO v_src_uis_tbl
7708: FROM cz_ui_defs
7709: WHERE cz_ui_defs.devl_project_id = l_export_model_id
7710: AND cz_ui_defs.deleted_flag = '0'
7704:
7705: BEGIN
7706: SELECT cz_ui_defs.ui_def_id
7707: BULK COLLECT INTO v_src_uis_tbl
7708: FROM cz_ui_defs
7709: WHERE cz_ui_defs.devl_project_id = l_export_model_id
7710: AND cz_ui_defs.deleted_flag = '0'
7711: AND cz_ui_defs.ui_style <> 7
7712: AND cz_ui_defs.NAME <> 'MUID';
7705: BEGIN
7706: SELECT cz_ui_defs.ui_def_id
7707: BULK COLLECT INTO v_src_uis_tbl
7708: FROM cz_ui_defs
7709: WHERE cz_ui_defs.devl_project_id = l_export_model_id
7710: AND cz_ui_defs.deleted_flag = '0'
7711: AND cz_ui_defs.ui_style <> 7
7712: AND cz_ui_defs.NAME <> 'MUID';
7713: EXCEPTION
7706: SELECT cz_ui_defs.ui_def_id
7707: BULK COLLECT INTO v_src_uis_tbl
7708: FROM cz_ui_defs
7709: WHERE cz_ui_defs.devl_project_id = l_export_model_id
7710: AND cz_ui_defs.deleted_flag = '0'
7711: AND cz_ui_defs.ui_style <> 7
7712: AND cz_ui_defs.NAME <> 'MUID';
7713: EXCEPTION
7714: WHEN OTHERS
7707: BULK COLLECT INTO v_src_uis_tbl
7708: FROM cz_ui_defs
7709: WHERE cz_ui_defs.devl_project_id = l_export_model_id
7710: AND cz_ui_defs.deleted_flag = '0'
7711: AND cz_ui_defs.ui_style <> 7
7712: AND cz_ui_defs.NAME <> 'MUID';
7713: EXCEPTION
7714: WHEN OTHERS
7715: THEN
7708: FROM cz_ui_defs
7709: WHERE cz_ui_defs.devl_project_id = l_export_model_id
7710: AND cz_ui_defs.deleted_flag = '0'
7711: AND cz_ui_defs.ui_style <> 7
7712: AND cz_ui_defs.NAME <> 'MUID';
7713: EXCEPTION
7714: WHEN OTHERS
7715: THEN
7716: cz_pb_mgr.v_err_message := SUBSTR('bulk collection into cz_pb_mgr.v_cz_ui_defs_old_tbl: ' || SQLERRM, 1, 2000);
7712: AND cz_ui_defs.NAME <> 'MUID';
7713: EXCEPTION
7714: WHEN OTHERS
7715: THEN
7716: cz_pb_mgr.v_err_message := SUBSTR('bulk collection into cz_pb_mgr.v_cz_ui_defs_old_tbl: ' || SQLERRM, 1, 2000);
7717: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZUIDEFS', SQLCODE);
7718: END;
7719:
7720: IF (v_src_uis_tbl.COUNT > 0)
7722: v_ui_def_count := x_ui_def_ref.COUNT;
7723:
7724: FOR k IN v_src_uis_tbl.FIRST .. v_src_uis_tbl.LAST
7725: LOOP
7726: IF (NOT v_cz_ui_defs_old_ref_idx_ref.EXISTS(v_src_uis_tbl(k)))
7727: THEN
7728: v_ui_def_count := v_ui_def_count + 1;
7729: x_ui_def_ref(v_ui_def_count) := v_src_uis_tbl(k);
7730: v_cz_ui_defs_old_ref_idx_ref(v_src_uis_tbl(k)) := v_src_uis_tbl(k);
7726: IF (NOT v_cz_ui_defs_old_ref_idx_ref.EXISTS(v_src_uis_tbl(k)))
7727: THEN
7728: v_ui_def_count := v_ui_def_count + 1;
7729: x_ui_def_ref(v_ui_def_count) := v_src_uis_tbl(k);
7730: v_cz_ui_defs_old_ref_idx_ref(v_src_uis_tbl(k)) := v_src_uis_tbl(k);
7731: END IF;
7732: END LOOP;
7733: END IF;
7734:
7738: SELECT DISTINCT ui_def_ref_id
7739: BULK COLLECT INTO v_src_uis_tbl
7740: FROM cz_ui_nodes
7741: WHERE cz_ui_nodes.ui_def_id IN(
7742: SELECT cz_ui_defs.ui_def_id
7743: FROM cz_ui_defs
7744: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7745: AND cz_ui_defs.NAME <> 'MUID')
7746: AND cz_ui_nodes.ui_def_ref_id IN(
7739: BULK COLLECT INTO v_src_uis_tbl
7740: FROM cz_ui_nodes
7741: WHERE cz_ui_nodes.ui_def_id IN(
7742: SELECT cz_ui_defs.ui_def_id
7743: FROM cz_ui_defs
7744: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7745: AND cz_ui_defs.NAME <> 'MUID')
7746: AND cz_ui_nodes.ui_def_ref_id IN(
7747: SELECT cz_ui_defs.ui_def_id
7740: FROM cz_ui_nodes
7741: WHERE cz_ui_nodes.ui_def_id IN(
7742: SELECT cz_ui_defs.ui_def_id
7743: FROM cz_ui_defs
7744: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7745: AND cz_ui_defs.NAME <> 'MUID')
7746: AND cz_ui_nodes.ui_def_ref_id IN(
7747: SELECT cz_ui_defs.ui_def_id
7748: FROM cz_ui_defs
7741: WHERE cz_ui_nodes.ui_def_id IN(
7742: SELECT cz_ui_defs.ui_def_id
7743: FROM cz_ui_defs
7744: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7745: AND cz_ui_defs.NAME <> 'MUID')
7746: AND cz_ui_nodes.ui_def_ref_id IN(
7747: SELECT cz_ui_defs.ui_def_id
7748: FROM cz_ui_defs
7749: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7743: FROM cz_ui_defs
7744: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7745: AND cz_ui_defs.NAME <> 'MUID')
7746: AND cz_ui_nodes.ui_def_ref_id IN(
7747: SELECT cz_ui_defs.ui_def_id
7748: FROM cz_ui_defs
7749: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7750: AND cz_ui_defs.NAME <> 'MUID')
7751: AND cz_ui_nodes.deleted_flag = '0'
7744: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7745: AND cz_ui_defs.NAME <> 'MUID')
7746: AND cz_ui_nodes.ui_def_ref_id IN(
7747: SELECT cz_ui_defs.ui_def_id
7748: FROM cz_ui_defs
7749: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7750: AND cz_ui_defs.NAME <> 'MUID')
7751: AND cz_ui_nodes.deleted_flag = '0'
7752: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL;
7745: AND cz_ui_defs.NAME <> 'MUID')
7746: AND cz_ui_nodes.ui_def_ref_id IN(
7747: SELECT cz_ui_defs.ui_def_id
7748: FROM cz_ui_defs
7749: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7750: AND cz_ui_defs.NAME <> 'MUID')
7751: AND cz_ui_nodes.deleted_flag = '0'
7752: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL;
7753: EXCEPTION
7746: AND cz_ui_nodes.ui_def_ref_id IN(
7747: SELECT cz_ui_defs.ui_def_id
7748: FROM cz_ui_defs
7749: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7750: AND cz_ui_defs.NAME <> 'MUID')
7751: AND cz_ui_nodes.deleted_flag = '0'
7752: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL;
7753: EXCEPTION
7754: WHEN OTHERS
7752: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL;
7753: EXCEPTION
7754: WHEN OTHERS
7755: THEN
7756: cz_pb_mgr.v_err_message := SUBSTR('bulk collection into cz_pb_mgr.v_cz_ui_defs_old_tbl: ' || SQLERRM, 1, 2000);
7757: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZUIDEFS', SQLCODE);
7758: END;
7759:
7760: IF (v_src_uis_tbl.COUNT > 0)
7762: v_ui_def_count := x_ui_def_ref.COUNT;
7763:
7764: FOR k IN v_src_uis_tbl.FIRST .. v_src_uis_tbl.LAST
7765: LOOP
7766: IF (NOT v_cz_ui_defs_old_ref_idx_ref.EXISTS(v_src_uis_tbl(k)))
7767: THEN
7768: v_ui_def_count := v_ui_def_count + 1;
7769: x_ui_def_ref(v_ui_def_count) := v_src_uis_tbl(k);
7770: v_cz_ui_defs_old_ref_idx_ref(v_src_uis_tbl(k)) := v_src_uis_tbl(k);
7766: IF (NOT v_cz_ui_defs_old_ref_idx_ref.EXISTS(v_src_uis_tbl(k)))
7767: THEN
7768: v_ui_def_count := v_ui_def_count + 1;
7769: x_ui_def_ref(v_ui_def_count) := v_src_uis_tbl(k);
7770: v_cz_ui_defs_old_ref_idx_ref(v_src_uis_tbl(k)) := v_src_uis_tbl(k);
7771: END IF;
7772: END LOOP;
7773: END IF;
7774: END LOOP; /* end loop of FOR I IN p_src_models.FIRST */
7782: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7783: ----procedure that returns the max last_update_date of ui schema
7784: PROCEDURE get_max_ui_date(p_ui_def_id IN cz_model_publications.ui_def_id%TYPE, x_max_update_date IN OUT NOCOPY DATE)
7785: AS
7786: v_ui_def_id_date cz_ui_defs.last_update_date%TYPE;
7787: v_ui_node_id_date cz_ui_nodes.last_update_date%TYPE;
7788: v_ui_props_date cz_ui_nodes.last_update_date%TYPE;
7789: v_ui_node_props_date cz_ui_nodes.last_update_date%TYPE;
7790: v_ui_node_intl_date cz_ui_nodes.last_update_date%TYPE;
7803:
7804: CURSOR ui_def_cur(ui_ui_def_id NUMBER)
7805: IS
7806: SELECT last_update_date
7807: FROM cz_ui_defs
7808: WHERE cz_ui_defs.ui_def_id = ui_ui_def_id AND cz_ui_defs.deleted_flag = '0'
7809: ORDER BY last_update_date DESC;
7810:
7811: CURSOR ui_nodes_cur(node_ui_def_id NUMBER)
7804: CURSOR ui_def_cur(ui_ui_def_id NUMBER)
7805: IS
7806: SELECT last_update_date
7807: FROM cz_ui_defs
7808: WHERE cz_ui_defs.ui_def_id = ui_ui_def_id AND cz_ui_defs.deleted_flag = '0'
7809: ORDER BY last_update_date DESC;
7810:
7811: CURSOR ui_nodes_cur(node_ui_def_id NUMBER)
7812: IS
9153: cz_pb_mgr.g_ui_templates_obj_type.DELETE;
9154: cz_pb_mgr.g_enclosing_fld_rp_entry.DELETE;
9155:
9156: -- templs directly referred by the UIs: not published before or changed since publication
9157: IF cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 AND cz_pb_mgr.v_session_parameter <> model_copy THEN
9158: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST LOOP
9159: l_temp_tbl.DELETE;
9160: SELECT template_id BULK COLLECT INTO l_temp_tbl
9161: FROM cz_ui_collect_tmpls_v
9154: cz_pb_mgr.g_enclosing_fld_rp_entry.DELETE;
9155:
9156: -- templs directly referred by the UIs: not published before or changed since publication
9157: IF cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 AND cz_pb_mgr.v_session_parameter <> model_copy THEN
9158: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST LOOP
9159: l_temp_tbl.DELETE;
9160: SELECT template_id BULK COLLECT INTO l_temp_tbl
9161: FROM cz_ui_collect_tmpls_v
9162: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
9158: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST LOOP
9159: l_temp_tbl.DELETE;
9160: SELECT template_id BULK COLLECT INTO l_temp_tbl
9161: FROM cz_ui_collect_tmpls_v
9162: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
9163: AND cz_ui_collect_tmpls_v.template_id IN
9164: (SELECT template_id
9165: FROM cz_ui_templates
9166: WHERE cz_ui_templates.deleted_flag = '0' AND cz_ui_templates.seeded_flag = '0'
9378: IS
9379: v_last_struct_update cz_devl_projects.last_struct_update%TYPE;
9380: v_models_tbl cz_pb_mgr.t_ref;
9381: record_count PLS_INTEGER := 0;
9382: v_last_update_date cz_ui_defs.last_update_date%TYPE;
9383: v_fc_update_date cz_func_comp_specs.last_update_date%TYPE;
9384: v_eff_update_date DATE;
9385: v_last_xfr_activity cz_pb_model_exports.last_xfr_activity%TYPE;
9386: l_max_template_date cz_pb_model_exports.last_xfr_activity%TYPE;
9389: v_descr_date DATE;
9390: BEGIN
9391: chk_if_aleady_published(publicationid, record_count);
9392: get_source_models(cz_pb_mgr.v_root_model_id, v_models_tbl);
9393: get_source_uis(cz_pb_mgr.v_root_model_id, v_models_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref);
9394: get_oa_uis(v_models_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref, cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
9395: get_oa_tmpls;
9396:
9397: IF (record_count > 0)
9390: BEGIN
9391: chk_if_aleady_published(publicationid, record_count);
9392: get_source_models(cz_pb_mgr.v_root_model_id, v_models_tbl);
9393: get_source_uis(cz_pb_mgr.v_root_model_id, v_models_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref);
9394: get_oa_uis(v_models_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref, cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
9395: get_oa_tmpls;
9396:
9397: IF (record_count > 0)
9398: THEN
9531:
9532: ----check if uis have changed
9533: cz_pb_mgr.v_ui_str := 'x';
9534:
9535: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
9536: THEN
9537: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
9538: LOOP
9539: get_max_ui_date(cz_pb_mgr.v_cz_ui_defs_old_ref(i), v_last_update_date);
9533: cz_pb_mgr.v_ui_str := 'x';
9534:
9535: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
9536: THEN
9537: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
9538: LOOP
9539: get_max_ui_date(cz_pb_mgr.v_cz_ui_defs_old_ref(i), v_last_update_date);
9540:
9541: IF (v_last_xfr_activity IS NULL)
9535: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
9536: THEN
9537: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
9538: LOOP
9539: get_max_ui_date(cz_pb_mgr.v_cz_ui_defs_old_ref(i), v_last_update_date);
9540:
9541: IF (v_last_xfr_activity IS NULL)
9542: THEN
9543: cz_pb_mgr.v_ui_str := 'UI';
9576: ELSIF((record_count = refresh_rules_count) AND(cz_pb_mgr.v_ui_str <> 'UI'))
9577: THEN
9578: v_refresh_rules := 'YES';
9579: RETURN TRUE; ----refresh rules
9580: ELSIF(cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT = 0)
9581: THEN
9582: cz_pb_mgr.v_ui_str := 'x';
9583: RETURN TRUE;
9584: ELSE
10039:
10040: -- check if any new ui created after last xfr activity
10041: -- call get_max_ui_date if this check still not enough
10042: SELECT MAX(creation_date) INTO l_max_ui_date
10043: FROM cz_ui_defs
10044: WHERE deleted_flag = '0' AND devl_project_id = v_model_id AND ui_style <> '-1';
10045: IF l_max_ui_date IS NOT NULL AND l_max_ui_date > v_expr_last_update THEN
10046: v_expr_last_update := l_max_ui_date;
10047: END IF;
11713: THEN
11714: BEGIN
11715: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
11716: THEN
11717: OPEN child_ref_id_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'
11718: || cz_pb_mgr.v_db_link
11719: || ' '
11720: || 'WHERE name = (SELECT name FROM cz_ui_defs t'
11721: || ' '
11716: THEN
11717: OPEN child_ref_id_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'
11718: || cz_pb_mgr.v_db_link
11719: || ' '
11720: || 'WHERE name = (SELECT name FROM cz_ui_defs t'
11721: || ' '
11722: || 'WHERE t.ui_def_id = '
11723: || p_resolved_key_array(i)
11724: || ')'
11733: END LOOP;
11734:
11735: CLOSE child_ref_id_cv;
11736: ELSE
11737: OPEN child_ref_id_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'
11738: || cz_pb_mgr.v_db_link
11739: || ' '
11740: || 'WHERE name = ( SELECT name FROM cz_ui_defs t'
11741: || ' '
11736: ELSE
11737: OPEN child_ref_id_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'
11738: || cz_pb_mgr.v_db_link
11739: || ' '
11740: || 'WHERE name = ( SELECT name FROM cz_ui_defs t'
11741: || ' '
11742: || 'WHERE t.ui_def_id = '
11743: || p_resolved_key_array(i)
11744: || ' )'
12047: -- Models with no change since the last successful export are not exported. Therefore their UIs
12048: -- are not exported as well. In such a case if a referring UI is exported, then the ids of referred UIs
12049: -- need to be resolved in these referring UIs. For that we need to map all referred UI Id from the
12050: -- source to corresponding remote Ids. This is exactly what this procedure does i.e. tt maps the
12051: -- source ui_def_ids to remote ui_def_ids in the table x_cz_ui_defs_idx_ref
12052: PROCEDURE get_uis_of_mdls_not_exported(p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref,
12053: x_cz_ui_defs_idx_ref IN OUT NOCOPY cz_pb_mgr.t_ref_idx_vc2,
12054: p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE,
12055: x_status IN OUT NOCOPY VARCHAR2)
12049: -- need to be resolved in these referring UIs. For that we need to map all referred UI Id from the
12050: -- source to corresponding remote Ids. This is exactly what this procedure does i.e. tt maps the
12051: -- source ui_def_ids to remote ui_def_ids in the table x_cz_ui_defs_idx_ref
12052: PROCEDURE get_uis_of_mdls_not_exported(p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref,
12053: x_cz_ui_defs_idx_ref IN OUT NOCOPY cz_pb_mgr.t_ref_idx_vc2,
12054: p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE,
12055: x_status IN OUT NOCOPY VARCHAR2)
12056: AS
12057:
12059:
12060: ui_ref_id_cv REF_CURSOR;
12061: v_devl_project_id cz_devl_projects.devl_project_id%TYPE;
12062: v_remote_devl_project_id cz_devl_projects.devl_project_id%TYPE;
12063: v_remote_ui_def_id cz_ui_defs.ui_def_id%TYPE;
12064: v_name cz_ui_defs.name%TYPE;
12065: CANNOT_FIND_REMOTE_UI EXCEPTION;
12066:
12067: BEGIN
12060: ui_ref_id_cv REF_CURSOR;
12061: v_devl_project_id cz_devl_projects.devl_project_id%TYPE;
12062: v_remote_devl_project_id cz_devl_projects.devl_project_id%TYPE;
12063: v_remote_ui_def_id cz_ui_defs.ui_def_id%TYPE;
12064: v_name cz_ui_defs.name%TYPE;
12065: CANNOT_FIND_REMOTE_UI EXCEPTION;
12066:
12067: BEGIN
12068:
12077:
12078: -- For each of these source models, get all the UIs
12079: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0) THEN
12080: SELECT ui_def_id BULK COLLECT INTO v_ui_defs_tbl
12081: FROM cz_ui_defs
12082: WHERE deleted_flag='0' AND devl_project_id=v_devl_project_id AND ui_style=g_ui_style_jrad;
12083: ELSE
12084: BEGIN
12085: SELECT ui_def_id
12085: SELECT ui_def_id
12086: BULK
12087: COLLECT
12088: INTO v_ui_defs_tbl
12089: FROM cz_ui_defs
12090: WHERE cz_ui_defs.devl_project_id = v_devl_project_id
12091: AND cz_ui_defs.deleted_flag = RECORD_NOT_DELETED
12092: AND cz_ui_defs.ui_style <> '-1';
12093:
12086: BULK
12087: COLLECT
12088: INTO v_ui_defs_tbl
12089: FROM cz_ui_defs
12090: WHERE cz_ui_defs.devl_project_id = v_devl_project_id
12091: AND cz_ui_defs.deleted_flag = RECORD_NOT_DELETED
12092: AND cz_ui_defs.ui_style <> '-1';
12093:
12094: EXCEPTION
12087: COLLECT
12088: INTO v_ui_defs_tbl
12089: FROM cz_ui_defs
12090: WHERE cz_ui_defs.devl_project_id = v_devl_project_id
12091: AND cz_ui_defs.deleted_flag = RECORD_NOT_DELETED
12092: AND cz_ui_defs.ui_style <> '-1';
12093:
12094: EXCEPTION
12095: WHEN NO_DATA_FOUND THEN
12088: INTO v_ui_defs_tbl
12089: FROM cz_ui_defs
12090: WHERE cz_ui_defs.devl_project_id = v_devl_project_id
12091: AND cz_ui_defs.deleted_flag = RECORD_NOT_DELETED
12092: AND cz_ui_defs.ui_style <> '-1';
12093:
12094: EXCEPTION
12095: WHEN NO_DATA_FOUND THEN
12096: cz_pb_mgr.v_err_message := 'No ui_def_ids found for : '||to_char(v_devl_project_id);
12106: FOR K IN v_ui_defs_tbl.FIRST..v_ui_defs_tbl.LAST
12107: LOOP
12108: BEGIN
12109: SELECT name into v_name
12110: from cz_ui_defs
12111: where ui_def_Id = v_ui_defs_tbl(k)
12112: AND deleted_flag = RECORD_NOT_DELETED;
12113:
12114: v_remote_ui_def_id := NULL;
12111: where ui_def_Id = v_ui_defs_tbl(k)
12112: AND deleted_flag = RECORD_NOT_DELETED;
12113:
12114: v_remote_ui_def_id := NULL;
12115: OPEN ui_ref_id_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'||CZ_PB_MGR.v_db_link ||
12116: ' WHERE name = :1 AND devl_project_id = :2' ||
12117: ' AND deleted_flag = :3'
12118: USING v_name, v_remote_devl_project_id, RECORD_NOT_DELETED;
12119: LOOP
12131: END IF;
12132:
12133: CLOSE ui_ref_id_cv;
12134:
12135: x_cz_ui_defs_idx_ref(v_ui_defs_tbl(k)) := v_remote_ui_def_id;
12136:
12137: EXCEPTION
12138: WHEN OTHERS THEN
12139: CLOSE ui_ref_id_cv;
12170: v_node_ref_export_id cz_pb_model_exports.export_id%TYPE;
12171: v_node_ref_remote_model cz_pb_model_exports.remote_model_id%TYPE;
12172: rec_count NUMBER;
12173:
12174: CURSOR l_ui_def_cur (p_ui_def_id NUMBER) IS SELECT name FROM cz_ui_defs b WHERE b.ui_def_id = p_ui_def_id;
12175: l_ui_def_name cz_ui_defs.name%TYPE;
12176:
12177: BEGIN
12178: IF (x_status <> PUBLICATION_ERROR)
12171: v_node_ref_remote_model cz_pb_model_exports.remote_model_id%TYPE;
12172: rec_count NUMBER;
12173:
12174: CURSOR l_ui_def_cur (p_ui_def_id NUMBER) IS SELECT name FROM cz_ui_defs b WHERE b.ui_def_id = p_ui_def_id;
12175: l_ui_def_name cz_ui_defs.name%TYPE;
12176:
12177: BEGIN
12178: IF (x_status <> PUBLICATION_ERROR)
12179: THEN
12190:
12191: BEGIN
12192: SELECT ui_def_id
12193: BULK COLLECT INTO v_remote_ui_defs_tbl
12194: FROM cz_ui_defs
12195: WHERE cz_ui_defs.devl_project_id = p_models_not_exported(i) AND cz_ui_defs.deleted_flag = record_not_deleted
12196: AND ui_style IN (g_ui_style_dhtml,g_ui_style_applet);
12197: EXCEPTION
12198: WHEN NO_DATA_FOUND
12191: BEGIN
12192: SELECT ui_def_id
12193: BULK COLLECT INTO v_remote_ui_defs_tbl
12194: FROM cz_ui_defs
12195: WHERE cz_ui_defs.devl_project_id = p_models_not_exported(i) AND cz_ui_defs.deleted_flag = record_not_deleted
12196: AND ui_style IN (g_ui_style_dhtml,g_ui_style_applet);
12197: EXCEPTION
12198: WHEN NO_DATA_FOUND
12199: THEN
12272: THEN
12273: ---------get devl_project_id
12274: SELECT devl_project_id
12275: INTO v_node_ref_proj_id
12276: FROM cz_ui_defs
12277: WHERE ui_def_id = v_remote_ui_nod_ui_def_ref(i) AND cz_ui_defs.deleted_flag = '0';
12278:
12279: get_remote_model_id(p_server_id,v_node_ref_proj_id,x_status,v_node_ref_remote_model);
12280:
12273: ---------get devl_project_id
12274: SELECT devl_project_id
12275: INTO v_node_ref_proj_id
12276: FROM cz_ui_defs
12277: WHERE ui_def_id = v_remote_ui_nod_ui_def_ref(i) AND cz_ui_defs.deleted_flag = '0';
12278:
12279: get_remote_model_id(p_server_id,v_node_ref_proj_id,x_status,v_node_ref_remote_model);
12280:
12281: OPEN l_ui_def_cur(v_remote_ui_nod_ui_def_ref(i));
12291: || 'WHERE t.persistent_ui_node_id = :pers_ui_node_id'
12292: || ' '
12293: || 'AND t.ui_def_id = (SELECT ui_def_id'
12294: || ' '
12295: || 'FROM cz_ui_defs'
12296: || cz_pb_mgr.v_db_link
12297: || ' a'
12298: || ' '
12299: || 'WHERE a.name = :ui_def_name'
13037: )
13038: AND (
13039: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
13040: (t.ui_def_id>1 AND
13041: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
13042: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
13043: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
13044: WHERE p.page_id=t.ui_page_id AND
13045: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
13066: )
13067: AND (
13068: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
13069: (t.ui_def_id>1 AND
13070: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
13071: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
13072: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
13073: WHERE p.page_id=t.ui_page_id AND
13074: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
13092: AND t.seeded_flag <> SEED_DATA
13093: AND (
13094: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
13095: (t.ui_def_id>1 AND
13096: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
13097: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
13098: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
13099: WHERE p.page_id=t.ui_page_id AND
13100: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
13119: AND t.deleted_flag = '0' AND t.seeded_flag <> SEED_DATA
13120: AND (
13121: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
13122: (t.ui_def_id>1 AND
13123: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
13124: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
13125: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
13126: WHERE p.page_id=t.ui_page_id AND
13127: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
13199: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
13200: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
13201: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
13202: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
13203: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
13204: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
13205: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
13206: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
13207: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
13200: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
13201: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
13202: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
13203: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
13204: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
13205: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
13206: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
13207: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
13208: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
13352: THEN
13353: BEGIN
13354: SELECT ui_def_id
13355: INTO x_ui_def_id
13356: FROM cz_ui_defs
13357: WHERE cz_ui_defs.devl_project_id = x_model_id AND cz_ui_defs.deleted_flag = '0' AND cz_ui_defs.NAME NOT LIKE 'MUID' AND ROWNUM < 2;
13358: EXCEPTION
13359: WHEN NO_DATA_FOUND
13360: THEN
13353: BEGIN
13354: SELECT ui_def_id
13355: INTO x_ui_def_id
13356: FROM cz_ui_defs
13357: WHERE cz_ui_defs.devl_project_id = x_model_id AND cz_ui_defs.deleted_flag = '0' AND cz_ui_defs.NAME NOT LIKE 'MUID' AND ROWNUM < 2;
13358: EXCEPTION
13359: WHEN NO_DATA_FOUND
13360: THEN
13361: x_ui_def_id := NULL;
14079: ,cz_pb_mgr.remote_publication_id
14080: ,cz_pb_mgr.v_status_code
14081: );
14082: ------get new ui_def_id for the target publication
14083: get_new_ui_def_id(p_publication_id, cz_pb_mgr.v_cz_ui_defs_old_ref, cz_pb_mgr.v_cz_ui_defs_new_ref, v_new_ui_def_id, cz_pb_mgr.v_status_code);
14084:
14085: -------get model id for target publication
14086: IF (g_object_type = MODEL_PUBLICATION) THEN
14087: get_new_model_id(p_publication_id, v_models_to_be_exported_new, v_remote_model, cz_pb_mgr.v_status_code);
14979: cz_pb_mgr.g_ui_node_prop_old_node_tbl.DELETE;
14980: cz_pb_mgr.g_ui_node_prop_new_uidf_tbl.DELETE;
14981: cz_pb_mgr.g_ui_node_prop_old_uidf_tbl.DELETE;
14982:
14983: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
14984: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14985: LOOP
14986: l_prop_node_tbl.DELETE;
14987:
14980: cz_pb_mgr.g_ui_node_prop_new_uidf_tbl.DELETE;
14981: cz_pb_mgr.g_ui_node_prop_old_uidf_tbl.DELETE;
14982:
14983: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
14984: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14985: LOOP
14986: l_prop_node_tbl.DELETE;
14987:
14988: SELECT DISTINCT prop.ui_node_id
14988: SELECT DISTINCT prop.ui_node_id
14989: BULK COLLECT INTO l_prop_node_tbl
14990: FROM cz_ui_node_props prop, cz_ui_nodes node
14991: WHERE prop.ui_def_id = node.ui_def_id
14992: AND prop.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
14993: AND node.ui_node_id = prop.ui_node_id
14994: AND node.deleted_flag = record_not_deleted
14995: AND prop.deleted_flag = record_not_deleted;
14996:
15002: LOOP
15003: l_rec_count := l_rec_count + 1;
15004: cz_pb_mgr.g_ui_node_prop_new_node_tbl(l_rec_count) := l_prop_node_tbl(j);
15005: cz_pb_mgr.g_ui_node_prop_old_node_tbl(l_rec_count) := l_prop_node_tbl(j);
15006: cz_pb_mgr.g_ui_node_prop_new_uidf_tbl(l_rec_count) := cz_pb_mgr.v_cz_ui_defs_old_ref(i);
15007: cz_pb_mgr.g_ui_node_prop_old_uidf_tbl(l_rec_count) := cz_pb_mgr.v_cz_ui_defs_old_ref(i);
15008: END LOOP;
15009: END IF;
15010: END LOOP;
15003: l_rec_count := l_rec_count + 1;
15004: cz_pb_mgr.g_ui_node_prop_new_node_tbl(l_rec_count) := l_prop_node_tbl(j);
15005: cz_pb_mgr.g_ui_node_prop_old_node_tbl(l_rec_count) := l_prop_node_tbl(j);
15006: cz_pb_mgr.g_ui_node_prop_new_uidf_tbl(l_rec_count) := cz_pb_mgr.v_cz_ui_defs_old_ref(i);
15007: cz_pb_mgr.g_ui_node_prop_old_uidf_tbl(l_rec_count) := cz_pb_mgr.v_cz_ui_defs_old_ref(i);
15008: END LOOP;
15009: END IF;
15010: END LOOP;
15011: END IF;
15012:
15013: IF cz_pb_mgr.g_ui_node_prop_new_node_tbl.COUNT > 0
15014: THEN
15015: resolve_ids(cz_pb_mgr.g_ui_node_prop_new_node_tbl, cz_pb_mgr.v_cz_ui_nodes_idx_ref, 'ui node ids of ui node props');
15016: resolve_ids(cz_pb_mgr.g_ui_node_prop_new_uidf_tbl, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui node props');
15017: l_plsql_table_list(1).col_name := 'ui_node_id';
15018: l_plsql_table_list(1).table_name := 'cz_pb_mgr.g_ui_node_prop_new_node_tbl';
15019: l_plsql_table_list(2).col_name := 'ui_def_id';
15020: l_plsql_table_list(2).table_name := 'cz_pb_mgr.g_ui_node_prop_new_uidf_tbl';
15061: cz_pb_mgr.v_new_mt_id_ref.DELETE;
15062: cz_pb_mgr.v_new_mt_id_tbl.DELETE;
15063: cz_pb_mgr.g_mt_obj_type.DELETE;
15064:
15065: -- Bug 5510573; 06-Sep-2006; kdande; Added a check to see if cz_pb_mgr.v_cz_ui_defs_old_ref has elements at all and then proceed
15066: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
15067: FOR ui IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15068: LOOP
15069: -- Andrew is going to provide with a query to fetch master template for given ui def id.
15062: cz_pb_mgr.v_new_mt_id_tbl.DELETE;
15063: cz_pb_mgr.g_mt_obj_type.DELETE;
15064:
15065: -- Bug 5510573; 06-Sep-2006; kdande; Added a check to see if cz_pb_mgr.v_cz_ui_defs_old_ref has elements at all and then proceed
15066: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
15067: FOR ui IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15068: LOOP
15069: -- Andrew is going to provide with a query to fetch master template for given ui def id.
15070: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq, 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
15063: cz_pb_mgr.g_mt_obj_type.DELETE;
15064:
15065: -- Bug 5510573; 06-Sep-2006; kdande; Added a check to see if cz_pb_mgr.v_cz_ui_defs_old_ref has elements at all and then proceed
15066: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
15067: FOR ui IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15068: LOOP
15069: -- Andrew is going to provide with a query to fetch master template for given ui def id.
15070: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq, 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
15071: ,ui_def_id, NAME
15066: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
15067: FOR ui IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15068: LOOP
15069: -- Andrew is going to provide with a query to fetch master template for given ui def id.
15070: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq, 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
15071: ,ui_def_id, NAME
15072: BULK COLLECT INTO l_mt_gen_id
15073: ,l_mt_old_id, l_mt_name
15074: FROM cz_ui_defs mstr
15070: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq, 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
15071: ,ui_def_id, NAME
15072: BULK COLLECT INTO l_mt_gen_id
15073: ,l_mt_old_id, l_mt_name
15074: FROM cz_ui_defs mstr
15075: WHERE mstr.deleted_flag = '0'
15076: AND mstr.master_template_flag = '1'
15077: AND mstr.seeded_flag = '0'
15078: AND EXISTS(SELECT 1
15075: WHERE mstr.deleted_flag = '0'
15076: AND mstr.master_template_flag = '1'
15077: AND mstr.seeded_flag = '0'
15078: AND EXISTS(SELECT 1
15079: FROM cz_ui_defs udf
15080: WHERE udf.from_master_template_id = mstr.ui_def_id AND ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(ui));
15081:
15082: -- keep a running array for l_mt_names
15083: rec_count := v_mt_name.COUNT;
15076: AND mstr.master_template_flag = '1'
15077: AND mstr.seeded_flag = '0'
15078: AND EXISTS(SELECT 1
15079: FROM cz_ui_defs udf
15080: WHERE udf.from_master_template_id = mstr.ui_def_id AND ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(ui));
15081:
15082: -- keep a running array for l_mt_names
15083: rec_count := v_mt_name.COUNT;
15084:
15112: rec_count := rec_count + 1;
15113:
15114: OPEN remote_mt FOR 'Select ui_def_id'
15115: || ' '
15116: || 'from cz_ui_defs'
15117: || cz_pb_mgr.v_db_link
15118: || 't'
15119: || ' '
15120: || 'where t.deleted_flag = ''0'' and t.master_template_flag = ''1'' and t.name = :1' USING cz_pb_mgr.v_mt_name(n);
15173: plsql_table_list.DELETE;
15174: rec_count := 1;
15175: plsql_table_list(rec_count).col_name := 'ui_def_id';
15176: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_new_mt_id_tbl';
15177: insert_into_table('cz_ui_defs', 'ui_def_id', cz_pb_mgr.v_db_link, plsql_table_list, 'cz_pb_mgr.v_mt_old_only', cz_pb_mgr.v_mt_old_only);
15178: ----------begin insert into cz_rp_entries----------------
15179: plsql_table_list.DELETE;
15180: rec_count := 1;
15181: plsql_table_list(rec_count).col_name := 'object_id';
15208: AS
15209: plsql_table_list cz_pb_mgr.col_plsql_table_list;
15210: rec_count PLS_INTEGER := 0;
15211: v_ui_node_count PLS_INTEGER := 0;
15212: v_cz_ui_defs_old_tbl cz_pb_mgr.t_ref;
15213: v_ui_devl_id_tbl cz_pb_mgr.t_ref;
15214: v_ui_comp_id_tbl cz_pb_mgr.t_ref;
15215: v_ui_rf_id_tbl cz_pb_mgr.t_ref;
15216: v_cz_ui_nodes_new_tbl cz_pb_mgr.t_ref;
15242: END IF;
15243:
15244: IF ((cz_pb_mgr.v_root_ui_def_id IS NOT NULL) AND(cz_pb_mgr.v_root_ui_def_id <= 0))THEN RETURN; END IF;
15245:
15246: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
15247:
15248: IF (p_models_for_export.COUNT > 0) THEN
15249: -- not copy non-jrad ui in any conversion session or in a copy session flagged by p_copy_nonjradui
15250: IF NOT (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 OR
15248: IF (p_models_for_export.COUNT > 0) THEN
15249: -- not copy non-jrad ui in any conversion session or in a copy session flagged by p_copy_nonjradui
15250: IF NOT (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 OR
15251: cz_pb_mgr.v_session_parameter=model_copy AND NOT p_copy_nonjradui) THEN
15252: get_source_uis(cz_pb_mgr.v_root_model_id, p_models_for_export, cz_pb_mgr.v_cz_ui_defs_old_ref);
15253: END IF;
15254: get_oa_uis(p_models_for_export, cz_pb_mgr.v_cz_ui_defs_old_ref, cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
15255:
15256: --get_oa_tmpls is also called from has_to_be_published.
15250: IF NOT (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 OR
15251: cz_pb_mgr.v_session_parameter=model_copy AND NOT p_copy_nonjradui) THEN
15252: get_source_uis(cz_pb_mgr.v_root_model_id, p_models_for_export, cz_pb_mgr.v_cz_ui_defs_old_ref);
15253: END IF;
15254: get_oa_uis(p_models_for_export, cz_pb_mgr.v_cz_ui_defs_old_ref, cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
15255:
15256: --get_oa_tmpls is also called from has_to_be_published.
15257: --However, for model migration, has_to_be_published
15258: --is not called. So make the call to get_oa_tmpls here.
15259: IF cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0 THEN
15260: get_oa_tmpls;
15261: END IF;
15262:
15263: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
15264: THEN
15265: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
15266:
15267: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15261: END IF;
15262:
15263: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
15264: THEN
15265: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
15266:
15267: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15268: LOOP
15269: rec_count := rec_count + 1;
15263: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
15264: THEN
15265: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
15266:
15267: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15268: LOOP
15269: rec_count := rec_count + 1;
15270: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
15271: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq
15266:
15267: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15268: LOOP
15269: rec_count := rec_count + 1;
15270: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
15271: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq
15272: , 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link
15273: ,cz_pb_mgr.v_oraclesequenceincr
15274: );
15267: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15268: LOOP
15269: rec_count := rec_count + 1;
15270: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
15271: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq
15272: , 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link
15273: ,cz_pb_mgr.v_oraclesequenceincr
15274: );
15275: END LOOP;
15268: LOOP
15269: rec_count := rec_count + 1;
15270: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
15271: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq
15272: , 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link
15273: ,cz_pb_mgr.v_oraclesequenceincr
15274: );
15275: END LOOP;
15276: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
15272: , 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link
15273: ,cz_pb_mgr.v_oraclesequenceincr
15274: );
15275: END LOOP;
15276: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
15277: END IF;
15278:
15279: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
15280: THEN
15275: END LOOP;
15276: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
15277: END IF;
15278:
15279: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
15280: THEN
15281: FOR m IN cz_pb_mgr.v_cz_ui_defs_new_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_new_ref.LAST
15282: LOOP
15283: cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.v_cz_ui_defs_old_ref(m)) := cz_pb_mgr.v_cz_ui_defs_new_ref(m);
15277: END IF;
15278:
15279: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
15280: THEN
15281: FOR m IN cz_pb_mgr.v_cz_ui_defs_new_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_new_ref.LAST
15282: LOOP
15283: cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.v_cz_ui_defs_old_ref(m)) := cz_pb_mgr.v_cz_ui_defs_new_ref(m);
15284: END LOOP;
15285: END IF;
15279: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
15280: THEN
15281: FOR m IN cz_pb_mgr.v_cz_ui_defs_new_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_new_ref.LAST
15282: LOOP
15283: cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.v_cz_ui_defs_old_ref(m)) := cz_pb_mgr.v_cz_ui_defs_new_ref(m);
15284: END LOOP;
15285: END IF;
15286:
15287: get_uis_of_mdls_not_exported(cz_pb_mgr.v_models_not_to_be_exported,
15284: END LOOP;
15285: END IF;
15286:
15287: get_uis_of_mdls_not_exported(cz_pb_mgr.v_models_not_to_be_exported,
15288: cz_pb_mgr.v_cz_ui_defs_idx_ref,
15289: cz_pb_mgr.v_server_id,
15290: cz_pb_mgr.v_status_code);
15291:
15292: IF (cz_pb_mgr.g_log_timing = publication_timing)
15296: END IF;
15297:
15298: ---------get devl_project_ids and component_ids for ui_defs
15299: /* We should really re-architect this portion of the code
15300: we have already queried cz_ui_defs before for oa_style UIs in
15301: get_oa_uis and have the menu_caption_rule_id,page_caption_rule_id,
15302: from_master_template_id. We need to query it again here because
15303: we don't have these values for DHTML UIs and insert_into_table for
15304: cz_ui_defs will fail. We should consolidate the querying into one place.
15300: we have already queried cz_ui_defs before for oa_style UIs in
15301: get_oa_uis and have the menu_caption_rule_id,page_caption_rule_id,
15302: from_master_template_id. We need to query it again here because
15303: we don't have these values for DHTML UIs and insert_into_table for
15304: cz_ui_defs will fail. We should consolidate the querying into one place.
15305: */
15306:
15307: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
15308: THEN
15303: we don't have these values for DHTML UIs and insert_into_table for
15304: cz_ui_defs will fail. We should consolidate the querying into one place.
15305: */
15306:
15307: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
15308: THEN
15309: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
15310: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15311: LOOP
15305: */
15306:
15307: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
15308: THEN
15309: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
15310: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15311: LOOP
15312: BEGIN
15313: v_ui_devl_id_tbl.DELETE;
15306:
15307: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
15308: THEN
15309: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
15310: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15311: LOOP
15312: BEGIN
15313: v_ui_devl_id_tbl.DELETE;
15314: v_ui_comp_id_tbl.DELETE;
15313: v_ui_devl_id_tbl.DELETE;
15314: v_ui_comp_id_tbl.DELETE;
15315: v_ui_rf_id_tbl.DELETE;
15316:
15317: SELECT devl_project_id, component_id, menu_caption_rule_id, page_caption_rule_id, cz_ui_defs.from_master_template_id
15318: BULK COLLECT INTO v_ui_devl_id_tbl, v_ui_comp_id_tbl, v_menu_capt_rule_tbl, v_page_capt_rule_tbl, l_from_mt_id_tbl
15319: FROM cz_ui_defs
15320: WHERE cz_ui_defs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i) AND cz_ui_defs.deleted_flag = record_not_deleted;
15321:
15315: v_ui_rf_id_tbl.DELETE;
15316:
15317: SELECT devl_project_id, component_id, menu_caption_rule_id, page_caption_rule_id, cz_ui_defs.from_master_template_id
15318: BULK COLLECT INTO v_ui_devl_id_tbl, v_ui_comp_id_tbl, v_menu_capt_rule_tbl, v_page_capt_rule_tbl, l_from_mt_id_tbl
15319: FROM cz_ui_defs
15320: WHERE cz_ui_defs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i) AND cz_ui_defs.deleted_flag = record_not_deleted;
15321:
15322: rec_count := cz_pb_mgr.v_ui_devl_id_ref.COUNT;
15323:
15316:
15317: SELECT devl_project_id, component_id, menu_caption_rule_id, page_caption_rule_id, cz_ui_defs.from_master_template_id
15318: BULK COLLECT INTO v_ui_devl_id_tbl, v_ui_comp_id_tbl, v_menu_capt_rule_tbl, v_page_capt_rule_tbl, l_from_mt_id_tbl
15319: FROM cz_ui_defs
15320: WHERE cz_ui_defs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i) AND cz_ui_defs.deleted_flag = record_not_deleted;
15321:
15322: rec_count := cz_pb_mgr.v_ui_devl_id_ref.COUNT;
15323:
15324: IF (v_ui_devl_id_tbl.COUNT > 0)
15335: END IF;
15336: EXCEPTION
15337: WHEN OTHERS
15338: THEN
15339: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_defs', 'SQLERRM', SQLERRM);
15340: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
15341: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15342: RAISE;
15343: END;
15340: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
15341: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15342: RAISE;
15343: END;
15344: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_ui_defs_old_ref */
15345: END IF;
15346: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0 */
15347:
15348: IF (cz_pb_mgr.g_log_timing = publication_timing)
15342: RAISE;
15343: END;
15344: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_ui_defs_old_ref */
15345: END IF;
15346: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0 */
15347:
15348: IF (cz_pb_mgr.g_log_timing = publication_timing)
15349: THEN
15350: log_timing_message('end bulk collect of devl_project_ids and component_ids for ui_defs');
15347:
15348: IF (cz_pb_mgr.g_log_timing = publication_timing)
15349: THEN
15350: log_timing_message('end bulk collect of devl_project_ids and component_ids for ui_defs');
15351: log_timing_message('start resolve_ids devl project id of cz_ui_defs');
15352: END IF;
15353:
15354: ----------resolve devl_project_ids
15355: resolve_ids(cz_pb_mgr.v_ui_devl_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl project id of cz_ui_defs');
15351: log_timing_message('start resolve_ids devl project id of cz_ui_defs');
15352: END IF;
15353:
15354: ----------resolve devl_project_ids
15355: resolve_ids(cz_pb_mgr.v_ui_devl_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl project id of cz_ui_defs');
15356:
15357: IF (cz_pb_mgr.g_log_timing = publication_timing)
15358: THEN
15359: log_timing_message('end resolve_ids devl project id of cz_ui_defs');
15355: resolve_ids(cz_pb_mgr.v_ui_devl_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl project id of cz_ui_defs');
15356:
15357: IF (cz_pb_mgr.g_log_timing = publication_timing)
15358: THEN
15359: log_timing_message('end resolve_ids devl project id of cz_ui_defs');
15360: END IF;
15361:
15362: ----------resolve component_ids
15363: IF (cz_pb_mgr.g_log_timing = publication_timing)
15361:
15362: ----------resolve component_ids
15363: IF (cz_pb_mgr.g_log_timing = publication_timing)
15364: THEN
15365: log_timing_message('start resolve_ids component id of cz_ui_defs');
15366: END IF;
15367:
15368: resolve_ids(cz_pb_mgr.v_ui_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_ui_defs');
15369:
15364: THEN
15365: log_timing_message('start resolve_ids component id of cz_ui_defs');
15366: END IF;
15367:
15368: resolve_ids(cz_pb_mgr.v_ui_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_ui_defs');
15369:
15370: IF (cz_pb_mgr.g_log_timing = publication_timing)
15371: THEN
15372: log_timing_message('end resolve_ids component id of cz_ui_defs');
15368: resolve_ids(cz_pb_mgr.v_ui_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_ui_defs');
15369:
15370: IF (cz_pb_mgr.g_log_timing = publication_timing)
15371: THEN
15372: log_timing_message('end resolve_ids component id of cz_ui_defs');
15373: END IF;
15374:
15375: ----------resolve component_ids of models not to be exported
15376: IF (cz_pb_mgr.g_log_timing = publication_timing)
15407: --------populate plsql_table_list for ui_defs
15408: plsql_table_list.DELETE;
15409: rec_count := 1;
15410: plsql_table_list(rec_count).col_name := 'ui_def_id';
15411: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_defs_new_ref';
15412: rec_count := rec_count + 1;
15413: plsql_table_list(rec_count).col_name := 'devl_project_id';
15414: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ui_devl_id_ref';
15415: rec_count := rec_count + 1;
15421: rec_count := rec_count + 1;
15422: plsql_table_list(rec_count).col_name := 'page_caption_rule_id';
15423: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ui_defs_pcpt_rule_ref';
15424:
15425: ---------insert into cz_ui_defs of target server
15426: IF (cz_pb_mgr.g_log_timing = publication_timing)
15427: THEN
15428: log_timing_message('start insert_into_table cz_ui_defs');
15429: END IF;
15424:
15425: ---------insert into cz_ui_defs of target server
15426: IF (cz_pb_mgr.g_log_timing = publication_timing)
15427: THEN
15428: log_timing_message('start insert_into_table cz_ui_defs');
15429: END IF;
15430:
15431: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id <> 0)
15432: THEN
15434: plsql_table_list(rec_count).col_name := 'from_master_template_id';
15435: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_master_template_id_ref';
15436: END IF;
15437:
15438: insert_into_table('cz_ui_defs'
15439: ,'ui_def_id'
15440: ,cz_pb_mgr.v_db_link
15441: ,plsql_table_list
15442: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
15438: insert_into_table('cz_ui_defs'
15439: ,'ui_def_id'
15440: ,cz_pb_mgr.v_db_link
15441: ,plsql_table_list
15442: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
15443: ,cz_pb_mgr.v_cz_ui_defs_old_ref
15444: );
15445:
15446: IF (cz_pb_mgr.g_log_timing = publication_timing)
15439: ,'ui_def_id'
15440: ,cz_pb_mgr.v_db_link
15441: ,plsql_table_list
15442: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
15443: ,cz_pb_mgr.v_cz_ui_defs_old_ref
15444: );
15445:
15446: IF (cz_pb_mgr.g_log_timing = publication_timing)
15447: THEN
15444: );
15445:
15446: IF (cz_pb_mgr.g_log_timing = publication_timing)
15447: THEN
15448: log_timing_message('end insert_into_table cz_ui_defs');
15449: END IF;
15450:
15451: ------export oa uis
15452: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0) THEN
15448: log_timing_message('end insert_into_table cz_ui_defs');
15449: END IF;
15450:
15451: ------export oa uis
15452: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0) THEN
15453: export_oa_uis;
15454: END IF;
15455:
15456: --------populate plsql_table_list for ui_properties
15456: --------populate plsql_table_list for ui_properties
15457: plsql_table_list.DELETE;
15458: rec_count := 1;
15459: plsql_table_list(rec_count).col_name := 'ui_def_id';
15460: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_defs_new_ref';
15461:
15462: ------------insert into cz_ui_properties of target server
15463: IF (cz_pb_mgr.g_log_timing = publication_timing)
15464: THEN
15468: insert_into_table('cz_ui_properties'
15469: ,'ui_def_id'
15470: ,cz_pb_mgr.v_db_link
15471: ,plsql_table_list
15472: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
15473: ,cz_pb_mgr.v_cz_ui_defs_old_ref
15474: );
15475:
15476: IF (cz_pb_mgr.g_log_timing = publication_timing)
15469: ,'ui_def_id'
15470: ,cz_pb_mgr.v_db_link
15471: ,plsql_table_list
15472: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
15473: ,cz_pb_mgr.v_cz_ui_defs_old_ref
15474: );
15475:
15476: IF (cz_pb_mgr.g_log_timing = publication_timing)
15477: THEN
15485: THEN
15486: log_timing_message('start bulk collect of cz_ui_nodes');
15487: END IF;
15488:
15489: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
15490: THEN
15491: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15492: LOOP
15493: v_cz_ui_nodes_new_tbl.DELETE;
15487: END IF;
15488:
15489: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
15490: THEN
15491: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15492: LOOP
15493: v_cz_ui_nodes_new_tbl.DELETE;
15494: v_cz_ui_nodes_old_tbl.DELETE;
15495: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15515: ,v_cz_ui_nodes_old_tbl, v_cz_ui_nodes_ui_def_id_tbl, v_cz_ui_nodes_parent_id_tbl, v_cz_ui_nodes_ui_ref_id_tbl
15516: ,v_cz_ui_nodes_ui_dref_id_tbl, v_cz_ui_nodes_ps_node_id_tbl, v_cz_ui_nodes_component_id_tbl, v_cz_ui_nodes_expl_id_tbl
15517: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
15518: FROM cz_ui_nodes
15519: WHERE cz_ui_nodes.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i) AND cz_ui_nodes.deleted_flag = record_not_deleted;
15520: EXCEPTION
15521: WHEN NO_DATA_FOUND
15522: THEN
15523: cz_pb_mgr.v_err_message := 'No ui nodes found for : ' || TO_CHAR(cz_pb_mgr.v_cz_ui_defs_old_ref(i));
15519: WHERE cz_ui_nodes.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i) AND cz_ui_nodes.deleted_flag = record_not_deleted;
15520: EXCEPTION
15521: WHEN NO_DATA_FOUND
15522: THEN
15523: cz_pb_mgr.v_err_message := 'No ui nodes found for : ' || TO_CHAR(cz_pb_mgr.v_cz_ui_defs_old_ref(i));
15524: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UINODES', SQLCODE);
15525: WHEN OTHERS
15526: THEN
15527: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_nodes', 'SQLERRM', SQLERRM);
15550: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
15551: END LOOP;
15552: END IF; /* end if of v_cz_ui_nodes_new_tbl.COUNT > 0 */
15553: END LOOP;
15554: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
15555:
15556: IF (cz_pb_mgr.g_log_timing = publication_timing)
15557: THEN
15558: log_timing_message('end bulk collect of cz_ui_nodes');
15615: THEN
15616: log_timing_message('start resolve_ids ui def ids of ui nodes');
15617: END IF;
15618:
15619: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui nodes');
15620:
15621: IF (cz_pb_mgr.g_log_timing = publication_timing)
15622: THEN
15623: log_timing_message('end resolve_ids ui def ids of ui nodes');
15695:
15696: ---------resolve ui_def_ref_id
15697: -- should call resolve_ids instead
15698: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_ui_nodes_new_ref
15699: ,cz_pb_mgr.v_cz_ui_defs_old_ref
15700: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
15701: ,cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref
15702: ,'cz_ui_nodes.ui_def_ref_id'
15703: ,cz_pb_mgr.v_status_code
15696: ---------resolve ui_def_ref_id
15697: -- should call resolve_ids instead
15698: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_ui_nodes_new_ref
15699: ,cz_pb_mgr.v_cz_ui_defs_old_ref
15700: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
15701: ,cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref
15702: ,'cz_ui_nodes.ui_def_ref_id'
15703: ,cz_pb_mgr.v_status_code
15704: );
15782: THEN
15783: log_timing_message('start insert_into_table cz_ui_node_props');
15784: END IF;
15785:
15786: insert_ui_node_props(cz_pb_mgr.v_cz_ui_defs_old_ref);
15787:
15788: IF (cz_pb_mgr.g_log_timing = publication_timing)
15789: THEN
15790: log_timing_message('end insert_into_table cz_ui_node_props');
16120: resolve_ids(cz_pb_mgr.v_cz_rules_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component_id of cz rules', FLD_RULE_COMPONENT_ID);
16121:
16122: -------------Resolve expl id of cz_rules
16123: resolve_ids(cz_pb_mgr.v_cz_rules_expl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl id of cz rules');
16124: resolve_ids(cz_pb_mgr.v_cz_rules_ui_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def id of cz rules');
16125: -------------populate plsql_table_list for cz rules
16126: plsql_table_list.DELETE;
16127: rec_count := 1;
16128: plsql_table_list(rec_count).col_name := 'rule_id';
18467: ,x_model_name OUT NOCOPY VARCHAR2
18468: ,p_check_root_ui_only IN BOOLEAN DEFAULT FALSE
18469: )
18470: IS
18471: l_ui_style cz_ui_defs.ui_style%TYPE;
18472: l_ui_status cz_ui_defs.ui_status%TYPE;
18473: l_ui_tbl t_ref;
18474: l_ui_name cz_ui_defs.NAME%TYPE;
18475: l_root_model_id NUMBER;
18468: ,p_check_root_ui_only IN BOOLEAN DEFAULT FALSE
18469: )
18470: IS
18471: l_ui_style cz_ui_defs.ui_style%TYPE;
18472: l_ui_status cz_ui_defs.ui_status%TYPE;
18473: l_ui_tbl t_ref;
18474: l_ui_name cz_ui_defs.NAME%TYPE;
18475: l_root_model_id NUMBER;
18476: l_root_ui_last_update_date DATE;
18470: IS
18471: l_ui_style cz_ui_defs.ui_style%TYPE;
18472: l_ui_status cz_ui_defs.ui_status%TYPE;
18473: l_ui_tbl t_ref;
18474: l_ui_name cz_ui_defs.NAME%TYPE;
18475: l_root_model_id NUMBER;
18476: l_root_ui_last_update_date DATE;
18477: l_model_id NUMBER;
18478: l_model_name cz_devl_projects.NAME%TYPE;
18477: l_model_id NUMBER;
18478: l_model_name cz_devl_projects.NAME%TYPE;
18479: l_last_update_date DATE;
18480: l_last_struct_update DATE;
18481: l_suppress_refresh_flag cz_ui_defs.suppress_refresh_flag%TYPE;
18482: BEGIN
18483: x_return_status := 0;
18484: x_msg_data := '';
18485:
18484: x_msg_data := '';
18485:
18486: SELECT ui_style, ui_status, NAME, NVL(suppress_refresh_flag, '0'), devl_project_id, NVL(ui_timestamp_refresh, last_update_date)
18487: INTO l_ui_style, l_ui_status, l_ui_name, l_suppress_refresh_flag, l_root_model_id, l_root_ui_last_update_date
18488: FROM cz_ui_defs
18489: WHERE ui_def_id = p_ui_def_id;
18490:
18491: IF l_ui_status = 'NEED_REFRESH' THEN
18492: x_return_status := 2;
18518: FROM cz_ui_refs
18519: START WITH ui_def_id = p_ui_def_id AND deleted_flag = '0'
18520: CONNECT BY PRIOR ref_ui_def_id = ui_def_id AND deleted_flag = '0' AND PRIOR deleted_flag = '0') uis
18521: WHERE EXISTS (SELECT NULL
18522: FROM cz_ui_defs
18523: WHERE ui_def_id = uis.ref_ui_def_id AND deleted_flag = '0' AND NVL(suppress_refresh_flag, '0') = '0');
18524:
18525: IF l_suppress_refresh_flag = '0' THEN
18526: l_ui_tbl(l_ui_tbl.COUNT + 1) := p_ui_def_id;
18543: ELSE
18544: BEGIN
18545: SELECT NVL(ui_timestamp_refresh, last_update_date), devl_project_id, NAME, ui_status
18546: INTO l_last_update_date, l_model_id, l_ui_name, l_ui_status
18547: FROM cz_ui_defs
18548: WHERE cz_ui_defs.ui_def_id = l_ui_tbl(i);
18549: EXCEPTION
18550: WHEN OTHERS THEN
18551: l_last_update_date := NULL;
18544: BEGIN
18545: SELECT NVL(ui_timestamp_refresh, last_update_date), devl_project_id, NAME, ui_status
18546: INTO l_last_update_date, l_model_id, l_ui_name, l_ui_status
18547: FROM cz_ui_defs
18548: WHERE cz_ui_defs.ui_def_id = l_ui_tbl(i);
18549: EXCEPTION
18550: WHEN OTHERS THEN
18551: l_last_update_date := NULL;
18552: END;
18641: l_model_name VARCHAR2(1000);
18642: l_copy_nonjradui BOOLEAN;
18643: ui_not_uptodate EXCEPTION;
18644:
18645: TYPE ui_style_tbl_type IS TABLE OF cz_ui_defs.ui_style%TYPE INDEX BY PLS_INTEGER;
18646: l_ui_style_tbl ui_style_tbl_type;
18647: BEGIN
18648: ----------delete session specific parameters
18649: BEGIN
18722: THEN
18723: BEGIN
18724: SELECT MAX(ui_def_id)
18725: INTO cz_pb_mgr.v_root_ui_def_id
18726: FROM cz_ui_defs
18727: WHERE cz_ui_defs.devl_project_id = cz_pb_mgr.v_root_model_id AND cz_ui_defs.deleted_flag = '0';
18728: EXCEPTION
18729: WHEN NO_DATA_FOUND
18730: THEN
18723: BEGIN
18724: SELECT MAX(ui_def_id)
18725: INTO cz_pb_mgr.v_root_ui_def_id
18726: FROM cz_ui_defs
18727: WHERE cz_ui_defs.devl_project_id = cz_pb_mgr.v_root_model_id AND cz_ui_defs.deleted_flag = '0';
18728: EXCEPTION
18729: WHEN NO_DATA_FOUND
18730: THEN
18731: cz_pb_mgr.v_root_ui_def_id := -999;
18765: THEN
18766: BEGIN
18767: SELECT 1
18768: INTO v_ui_chk_count
18769: FROM cz_ui_defs
18770: WHERE cz_ui_defs.ui_def_id = cz_pb_mgr.v_root_ui_def_id AND cz_ui_defs.deleted_flag = '0';
18771: EXCEPTION
18772: WHEN OTHERS
18773: THEN
18766: BEGIN
18767: SELECT 1
18768: INTO v_ui_chk_count
18769: FROM cz_ui_defs
18770: WHERE cz_ui_defs.ui_def_id = cz_pb_mgr.v_root_ui_def_id AND cz_ui_defs.deleted_flag = '0';
18771: EXCEPTION
18772: WHEN OTHERS
18773: THEN
18774: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_UI');
18781: IF cz_pb_mgr.copy_uis = 'YES' THEN
18782: l_copy_nonjradui := TRUE;
18783: IF cz_pb_mgr.copy_root_only = 'YES' THEN
18784: SELECT ui_def_id, ui_style BULK COLLECT INTO l_ui_tbl, l_ui_style_tbl
18785: FROM cz_ui_defs
18786: WHERE deleted_flag='0' AND ui_style<>-1 AND devl_project_id=p_model_id;
18787: ELSE
18788: SELECT ui_def_id, ui_style BULK COLLECT INTO l_ui_tbl, l_ui_style_tbl
18789: FROM cz_ui_defs
18785: FROM cz_ui_defs
18786: WHERE deleted_flag='0' AND ui_style<>-1 AND devl_project_id=p_model_id;
18787: ELSE
18788: SELECT ui_def_id, ui_style BULK COLLECT INTO l_ui_tbl, l_ui_style_tbl
18789: FROM cz_ui_defs
18790: WHERE deleted_flag='0' AND ui_style<>-1 AND devl_project_id IN
18791: (SELECT component_id FROM cz_model_ref_expls
18792: WHERE deleted_flag='0' AND model_id=p_model_id);
18793: END IF;
19514: IF ((p_ui_def_id IS NOT NULL) AND(p_ui_def_id > 0))
19515: THEN
19516: SELECT COUNT(*)
19517: INTO v_ui_chk_count
19518: FROM cz_ui_defs
19519: WHERE cz_ui_defs.ui_def_id = p_ui_def_id AND cz_ui_defs.deleted_flag = record_not_deleted;
19520:
19521: IF (v_ui_chk_count = 0)
19522: THEN
19515: THEN
19516: SELECT COUNT(*)
19517: INTO v_ui_chk_count
19518: FROM cz_ui_defs
19519: WHERE cz_ui_defs.ui_def_id = p_ui_def_id AND cz_ui_defs.deleted_flag = record_not_deleted;
19520:
19521: IF (v_ui_chk_count = 0)
19522: THEN
19523: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_UI', 'PUBID', p_publication_id);
19547: ,x_rem_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
19548: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
19549: )
19550: AS
19551: v_ui_name cz_ui_defs.NAME%TYPE;
19552: v_old_remote_model cz_model_publications.model_id%TYPE;
19553: ui_cv ref_cursor;
19554: BEGIN
19555: BEGIN
19554: BEGIN
19555: BEGIN
19556: SELECT NAME
19557: INTO v_ui_name
19558: FROM cz_ui_defs
19559: WHERE ui_def_id = p_ui_def_id;
19560: EXCEPTION
19561: WHEN OTHERS
19562: THEN
19574: x_rem_model_id := v_old_remote_model;
19575:
19576: IF (v_ui_name IS NOT NULL)
19577: THEN
19578: OPEN ui_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'
19579: || cz_pb_mgr.v_db_link
19580: || ' '
19581: || 'WHERE name = :1'
19582: || ' '
19776: -- private, check all uis if input uidefid null, check the given ui tree otherwise
19777: PROCEDURE model_upto_date(modelid IN NUMBER, status IN OUT NOCOPY VARCHAR2, uidefid IN NUMBER DEFAULT NULL)
19778: AS
19779: l_model_name VARCHAR2(4000);
19780: l_ui_name cz_ui_defs.NAME%TYPE;
19781: l_ui_model_name VARCHAR2(4000);
19782: l_model_status NUMBER;
19783: l_ui_status NUMBER;
19784: l_folder_id NUMBER;
19798:
19799: IF uidefid IS NULL THEN
19800: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 THEN
19801: SELECT ui_def_id BULK COLLECT INTO l_uidef_tbl
19802: FROM cz_ui_defs
19803: WHERE deleted_flag='0' AND ui_style=g_ui_style_jrad AND devl_project_id IN
19804: (SELECT component_id FROM cz_model_ref_expls
19805: WHERE deleted_flag='0' AND model_id=modelid);
19806: ELSE
19804: (SELECT component_id FROM cz_model_ref_expls
19805: WHERE deleted_flag='0' AND model_id=modelid);
19806: ELSE
19807: SELECT ui_def_id BULK COLLECT INTO l_uidef_tbl
19808: FROM cz_ui_defs
19809: WHERE deleted_flag='0' AND ui_style<>-1 AND devl_project_id IN
19810: (SELECT component_id FROM cz_model_ref_expls
19811: WHERE deleted_flag='0' AND model_id=modelid);
19812: END IF;
22341: l_usage_id_tbl cz_pb_mgr.t_ref;
22342: l_param_status VARCHAR2(2000);
22343: v_upto_date_status VARCHAR2(2000);
22344: v_publicationidstring VARCHAR2(2000);
22345: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
22346: l_deleted_flag VARCHAR2(1);
22347: l_ui_name cz_ui_defs.NAME%TYPE;
22348: expstatus_exception EXCEPTION;
22349: get_params_exception EXCEPTION;
22343: v_upto_date_status VARCHAR2(2000);
22344: v_publicationidstring VARCHAR2(2000);
22345: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
22346: l_deleted_flag VARCHAR2(1);
22347: l_ui_name cz_ui_defs.NAME%TYPE;
22348: expstatus_exception EXCEPTION;
22349: get_params_exception EXCEPTION;
22350: model_not_upto_date EXCEPTION;
22351: pub_overlap EXCEPTION;
22389: THEN
22390: BEGIN
22391: SELECT ui_def_id, deleted_flag, NAME
22392: INTO l_ui_def_id, l_deleted_flag, l_ui_name
22393: FROM cz_ui_defs
22394: WHERE cz_ui_defs.ui_def_id = v_source_pb_record.ui_def_id;
22395: EXCEPTION
22396: WHEN NO_DATA_FOUND
22397: THEN
22390: BEGIN
22391: SELECT ui_def_id, deleted_flag, NAME
22392: INTO l_ui_def_id, l_deleted_flag, l_ui_name
22393: FROM cz_ui_defs
22394: WHERE cz_ui_defs.ui_def_id = v_source_pb_record.ui_def_id;
22395: EXCEPTION
22396: WHEN NO_DATA_FOUND
22397: THEN
22398: RAISE ui_def_id_is_deleted;
23094: l_last_updated DATE;
23095: l_persistent_project_id cz_devl_projects.persistent_project_id%TYPE;
23096: v_publicationidstring VARCHAR2(2000);
23097: v_upto_date_status VARCHAR2(2000);
23098: l_ui_style cz_ui_defs.ui_style%TYPE;
23099: v_new_publication_id cz_model_publications.publication_id%TYPE;
23100: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;
23101: l_organization_id cz_devl_projects.organization_id%TYPE;
23102: l_product_key cz_devl_projects.product_key%TYPE;
23099: v_new_publication_id cz_model_publications.publication_id%TYPE;
23100: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;
23101: l_organization_id cz_devl_projects.organization_id%TYPE;
23102: l_product_key cz_devl_projects.product_key%TYPE;
23103: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
23104: l_short_name cz_pb_client_apps.application_short_name%TYPE;
23105: pub_overlap EXCEPTION;
23106: no_model_id EXCEPTION;
23107: no_model_exists EXCEPTION;
23159: ELSE
23160: BEGIN
23161: SELECT ui_def_id, ui_style
23162: INTO l_ui_def_id, l_ui_style
23163: FROM cz_ui_defs
23164: WHERE cz_ui_defs.ui_def_id = p_ui_def_id AND cz_ui_defs.devl_project_id = p_model_id AND cz_ui_defs.deleted_flag = '0';
23165: EXCEPTION
23166: WHEN NO_DATA_FOUND
23167: THEN
23160: BEGIN
23161: SELECT ui_def_id, ui_style
23162: INTO l_ui_def_id, l_ui_style
23163: FROM cz_ui_defs
23164: WHERE cz_ui_defs.ui_def_id = p_ui_def_id AND cz_ui_defs.devl_project_id = p_model_id AND cz_ui_defs.deleted_flag = '0';
23165: EXCEPTION
23166: WHEN NO_DATA_FOUND
23167: THEN
23168: RAISE no_ui_exists;
25156: */
25157: FUNCTION has_ui_inany_chld_mdl_changed(rootmodelid IN NUMBER) RETURN boolean IS
25158:
25159: v_models_tbl cz_pb_mgr.t_ref;
25160: v_last_update_date cz_ui_defs.last_update_date%TYPE;
25161: v_last_xfr_activity cz_pb_model_exports.last_xfr_activity%TYPE;
25162: curr_model_tbl cz_pb_mgr.t_ref;
25163:
25164: BEGIN
25176: IF(v_models_tbl(i) <> rootmodelid) THEN
25177:
25178: v_last_xfr_activity := get_mdl_last_xfr_activity(v_models_tbl(i), cz_pb_mgr.v_server_id);
25179: IF cz_pb_mgr.v_server_id<>0 THEN
25180: get_source_uis(rootmodelid, curr_model_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref);
25181: END IF;
25182: get_oa_uis(curr_model_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref, cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
25183:
25184: IF(cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
25178: v_last_xfr_activity := get_mdl_last_xfr_activity(v_models_tbl(i), cz_pb_mgr.v_server_id);
25179: IF cz_pb_mgr.v_server_id<>0 THEN
25180: get_source_uis(rootmodelid, curr_model_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref);
25181: END IF;
25182: get_oa_uis(curr_model_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref, cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
25183:
25184: IF(cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
25185: FOR j IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
25186: LOOP
25180: get_source_uis(rootmodelid, curr_model_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref);
25181: END IF;
25182: get_oa_uis(curr_model_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref, cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
25183:
25184: IF(cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
25185: FOR j IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
25186: LOOP
25187: get_max_ui_date(cz_pb_mgr.v_cz_ui_defs_old_ref(j), v_last_update_date);
25188:
25181: END IF;
25182: get_oa_uis(curr_model_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref, cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
25183:
25184: IF(cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
25185: FOR j IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
25186: LOOP
25187: get_max_ui_date(cz_pb_mgr.v_cz_ui_defs_old_ref(j), v_last_update_date);
25188:
25189: IF(v_last_xfr_activity IS NULL) THEN
25183:
25184: IF(cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
25185: FOR j IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
25186: LOOP
25187: get_max_ui_date(cz_pb_mgr.v_cz_ui_defs_old_ref(j), v_last_update_date);
25188:
25189: IF(v_last_xfr_activity IS NULL) THEN
25190: RETURN TRUE;
25191: ELSIF((v_last_xfr_activity IS NOT NULL)