[Home] [Help]
290: cz_pb_mgr.v_cz_func_expl_old_ref.DELETE;
291: cz_pb_mgr.v_cz_func_fld_old_ref.DELETE;
292: cz_pb_mgr.v_cz_func_obj_ref.DELETE;
293: END IF;
294: ELSIF(p_table_name = 'cz_ui_defs')
295: THEN
296: IF (p_table_type = 'tbl')
297: THEN
298: cz_pb_mgr.v_ui_devl_id_tbl.DELETE;
298: cz_pb_mgr.v_ui_devl_id_tbl.DELETE;
299: cz_pb_mgr.v_ui_comp_id_tbl.DELETE;
300: ELSIF(p_table_type = 'ref')
301: THEN
302: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
303: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
304: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
305: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
306: cz_pb_mgr.v_ui_devl_id_ref.DELETE;
299: cz_pb_mgr.v_ui_comp_id_tbl.DELETE;
300: ELSIF(p_table_type = 'ref')
301: THEN
302: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
303: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
304: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
305: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
306: cz_pb_mgr.v_ui_devl_id_ref.DELETE;
307: cz_pb_mgr.v_ui_comp_id_ref.DELETE;
300: ELSIF(p_table_type = 'ref')
301: THEN
302: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
303: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
304: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
305: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
306: cz_pb_mgr.v_ui_devl_id_ref.DELETE;
307: cz_pb_mgr.v_ui_comp_id_ref.DELETE;
308: cz_pb_mgr.v_ui_defs_mcpt_rule_ref.DELETE;
301: THEN
302: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
303: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
304: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
305: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
306: cz_pb_mgr.v_ui_devl_id_ref.DELETE;
307: cz_pb_mgr.v_ui_comp_id_ref.DELETE;
308: cz_pb_mgr.v_ui_defs_mcpt_rule_ref.DELETE;
309: cz_pb_mgr.v_ui_defs_pcpt_rule_ref.DELETE;
780: END IF;
781: END IF;
782: ELSE
783: BEGIN
784: p_array_to_resolve(i) := cz_pb_mgr.v_cz_ui_defs_idx_ref(p_array_to_resolve(i));
785: EXCEPTION
786: WHEN OTHERS
787: THEN
788: NULL;
2438:
2439: IF p_intl_text <> 'prop num value of cz prop vals' THEN
2440: resolve_ids(cz_pb_mgr.v_intl_text_model_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz intl texts');
2441: END IF;
2442: 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');
2443:
2444: IF (cz_pb_mgr.v_cz_intl_text_new_ref.COUNT > 0)
2445: THEN
2446: --------populate plsql_table_list for intl texts
2628: l_export_model_id := p_src_models(i);
2629: v_src_uis_tbl.DELETE;
2630:
2631: BEGIN
2632: 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
2633: BULK COLLECT INTO v_src_uis_tbl, l_menu_caption_rule_tbl, l_page_caption_rule_tbl, l_from_mt_id_tbl
2634: FROM cz_ui_defs
2635: 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';
2636: EXCEPTION
2630:
2631: BEGIN
2632: 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
2633: BULK COLLECT INTO v_src_uis_tbl, l_menu_caption_rule_tbl, l_page_caption_rule_tbl, l_from_mt_id_tbl
2634: FROM cz_ui_defs
2635: 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';
2636: EXCEPTION
2637: WHEN NO_DATA_FOUND
2638: THEN
2631: BEGIN
2632: 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
2633: BULK COLLECT INTO v_src_uis_tbl, l_menu_caption_rule_tbl, l_page_caption_rule_tbl, l_from_mt_id_tbl
2634: FROM cz_ui_defs
2635: 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';
2636: EXCEPTION
2637: WHEN NO_DATA_FOUND
2638: THEN
2639: -----if there are no UI do not care
3569: AND cz_ui_templates.seeded_flag = '0'
3570: AND ( cz_ui_templates.ui_def_id = 0
3571: OR cz_ui_templates.ui_def_id IN(
3572: SELECT ui_def_id
3573: FROM cz_ui_defs
3574: WHERE cz_ui_defs.deleted_flag = '0'
3575: AND cz_ui_defs.devl_project_id IN(SELECT object_id
3576: FROM cz_rp_entries
3577: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0'))
3570: AND ( cz_ui_templates.ui_def_id = 0
3571: OR cz_ui_templates.ui_def_id IN(
3572: SELECT ui_def_id
3573: FROM cz_ui_defs
3574: WHERE cz_ui_defs.deleted_flag = '0'
3575: AND cz_ui_defs.devl_project_id IN(SELECT object_id
3576: FROM cz_rp_entries
3577: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0'))
3578: );
3571: OR cz_ui_templates.ui_def_id IN(
3572: SELECT ui_def_id
3573: FROM cz_ui_defs
3574: WHERE cz_ui_defs.deleted_flag = '0'
3575: AND cz_ui_defs.devl_project_id IN(SELECT object_id
3576: FROM cz_rp_entries
3577: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0'))
3578: );
3579:
3839: l_rec_count NUMBER;
3840: BEGIN
3841: pbdebug := 22029;
3842:
3843: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
3844: THEN
3845: cz_pb_mgr.g_cz_ui_pages_ui_def_ref.DELETE;
3846: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.DELETE;
3847: cz_pb_mgr.g_cz_ui_pages_capt_id_ref.DELETE;
3856: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;
3857: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl.DELETE;
3858: cz_pb_mgr.g_cz_ui_pages_expl_tbl.DELETE;
3859:
3860: 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
3861: LOOP
3862: l_cz_ui_pages_ui_def_tbl.DELETE;
3863: l_cz_ui_pages_jrad_doc_tbl.DELETE;
3864: l_cz_ui_pages_capt_id_tbl.DELETE;
3876: 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
3877: ,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
3878: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
3879: FROM cz_ui_pages
3880: 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;
3881:
3882: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)
3883: THEN
3884: l_rec_count := cz_pb_mgr.g_pages_ui_def_old_ref.COUNT;
3927:
3928: IF (cz_pb_mgr.g_pages_ui_def_old_ref.COUNT > 0)
3929: THEN
3930: ----resolve ui_def_id of ui pages
3931: 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');
3932:
3933: -- resolve page status and outer page templates
3934: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
3935: 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');
3931: 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');
3932:
3933: -- resolve page status and outer page templates
3934: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
3935: 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');
3936: 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);
3937: 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');
3938: 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);
3939: END IF;
3933: -- resolve page status and outer page templates
3934: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
3935: 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');
3936: 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);
3937: 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');
3938: 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);
3939: END IF;
3940:
3941: ----caption ids of ui pages
3999: l_train_jrad_doc_tbl varchar_type_tbl;
4000: BEGIN
4001: pbdebug := 22031;
4002:
4003: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
4004: THEN
4005: cz_pb_mgr.g_page_sets_ui_old_ref.DELETE;
4006: cz_pb_mgr.g_page_sets_ui_ref.DELETE;
4007: cz_pb_mgr.g_page_sets_pg_tbl.DELETE;
4007: cz_pb_mgr.g_page_sets_pg_tbl.DELETE;
4008: cz_pb_mgr.g_page_sets_jrad_doc_ref.DELETE;
4009: cz_pb_mgr.g_page_sets_expl_tbl.DELETE;
4010:
4011: 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
4012: LOOP
4013: SELECT ui_def_id, page_set_id, train_jrad_doc, pagebase_expl_node_id
4014: BULK COLLECT INTO l_page_sets_ui_tbl, l_page_sets_pg_tbl, l_train_jrad_doc_tbl, l_pagebase_expl_tbl
4015: FROM cz_ui_page_sets
4012: LOOP
4013: SELECT ui_def_id, page_set_id, train_jrad_doc, pagebase_expl_node_id
4014: BULK COLLECT INTO l_page_sets_ui_tbl, l_page_sets_pg_tbl, l_train_jrad_doc_tbl, l_pagebase_expl_tbl
4015: FROM cz_ui_page_sets
4016: 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);
4017:
4018: IF (l_page_sets_ui_tbl.COUNT > 0)
4019: THEN
4020: l_rec_count := cz_pb_mgr.g_page_sets_ui_old_ref.COUNT;
4053: IF (cz_pb_mgr.g_page_sets_ui_old_ref.COUNT > 0)
4054: THEN
4055: pbdebug := 22032;
4056: ----resolve ui_def_id of page sets
4057: 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');
4058: 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');
4059: plsql_table_list.DELETE;
4060: rec_count := 1;
4061: plsql_table_list(rec_count).col_name := 'ui_def_id';
4104: l_page_refs_tgt_expl_tbl cz_pb_mgr.t_ref;
4105: l_page_refs_cpt_rule_tbl cz_pb_mgr.t_ref;
4106: rec_count NUMBER := 0;
4107: BEGIN
4108: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
4109: THEN
4110: cz_pb_mgr.g_page_refs_ui_def_old_ref.DELETE;
4111: cz_pb_mgr.g_page_refs_ui_def_new_ref.DELETE;
4112: cz_pb_mgr.g_page_refs_cond_id_ref.DELETE;
4119: cz_pb_mgr.g_page_refs_tgt_expl_tbl.DELETE;
4120: cz_pb_mgr.g_page_refs_cpt_rule_tbl.DELETE;
4121: pbdebug := 22033;
4122:
4123: 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
4124: LOOP
4125: l_page_refs_ui_def_tbl.DELETE;
4126: l_page_refs_cond_id_tbl.DELETE;
4127: l_page_refs_capt_id_tbl.DELETE;
4133: ,target_ui_def_id, target_expl_node_id, caption_rule_id
4134: BULK COLLECT INTO l_page_refs_ui_def_tbl, l_page_refs_pg_set_tbl, l_page_refs_pg_ref_tbl, l_page_refs_cond_id_tbl, l_page_refs_capt_id_tbl
4135: ,l_page_refs_tgt_ui_tbl, l_page_refs_tgt_expl_tbl, l_page_refs_cpt_rule_tbl
4136: FROM cz_ui_page_refs
4137: WHERE cz_ui_page_refs.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_page_refs.deleted_flag = record_not_deleted;
4138:
4139: IF (l_page_refs_ui_def_tbl.COUNT > 0)
4140: THEN
4141: rec_count := cz_pb_mgr.g_page_refs_ui_def_old_ref.COUNT;
4180: IF (cz_pb_mgr.g_page_refs_ui_def_old_ref.COUNT > 0)
4181: THEN
4182: pbdebug := 22034;
4183: ----resolve ui_def_id
4184: 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 sets');
4185: ---create rules for g_page_refs_cond_id_ref
4186: resolve_ids(cz_pb_mgr.g_page_refs_cpt_rule_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'caption rule id of page sets');
4187: resolve_ids(cz_pb_mgr.g_page_refs_cond_id_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'condition id of page sets');
4188: ----caption ids of ui pages
4210: plsql_table_list(rec_count).col_name := 'condition_id';
4211: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_page_refs_cond_id_ref';
4212: -- should call resolve_ids instead
4213: resolve_ref_ids_not_found(cz_pb_mgr.g_page_refs_ui_def_new_ref
4214: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4215: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4216: ,cz_pb_mgr.g_page_refs_tgt_ui_ref
4217: ,'cz_ui_page_refs.target_ui_def_id'
4218: ,cz_pb_mgr.v_status_code
4211: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_page_refs_cond_id_ref';
4212: -- should call resolve_ids instead
4213: resolve_ref_ids_not_found(cz_pb_mgr.g_page_refs_ui_def_new_ref
4214: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4215: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4216: ,cz_pb_mgr.g_page_refs_tgt_ui_ref
4217: ,'cz_ui_page_refs.target_ui_def_id'
4218: ,cz_pb_mgr.v_status_code
4219: );
4248: l_ui_refs_ref_ui_def_tbl cz_pb_mgr.t_ref;
4249: l_ui_refs_expl_id_tbl cz_pb_mgr.t_ref;
4250: rec_count NUMBER := 0;
4251: BEGIN
4252: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
4253: THEN
4254: cz_pb_mgr.g_ui_refs_old_ui_def_ref.DELETE;
4255: cz_pb_mgr.g_ui_refs_new_ui_def_ref.DELETE;
4256: cz_pb_mgr.g_ui_refs_ref_ui_def_ref.DELETE;
4257: cz_pb_mgr.g_ui_refs_expl_id_ref.DELETE;
4258: cz_pb_mgr.g_ui_refs_ref_ui_def_old_ref.DELETE;
4259: cz_pb_mgr.g_ui_refs_expl_id_old_ref.DELETE;
4260:
4261: 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
4262: LOOP
4263: l_ui_refs_ui_def_tbl.DELETE;
4264: l_ui_refs_ref_ui_def_tbl.DELETE;
4265: l_ui_refs_expl_id_tbl.DELETE;
4266:
4267: SELECT ui_def_id, ref_ui_def_id, model_ref_expl_id
4268: BULK COLLECT INTO l_ui_refs_ui_def_tbl, l_ui_refs_ref_ui_def_tbl, l_ui_refs_expl_id_tbl
4269: FROM cz_ui_refs
4270: 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;
4271:
4272: IF (l_ui_refs_ui_def_tbl.COUNT > 0)
4273: THEN
4274: rec_count := cz_pb_mgr.g_ui_refs_old_ui_def_ref.COUNT;
4307: BEGIN
4308: IF (cz_pb_mgr.g_ui_refs_old_ui_def_ref.COUNT > 0)
4309: THEN
4310: ----resolve ui_def_id
4311: 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');
4312: ----resolve model ref expl id
4313: 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');
4314: plsql_table_list.DELETE;
4315: rec_count := 1;
4322: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
4323: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_refs_expl_id_ref';
4324: -- should call resolve_ids instead
4325: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_refs_new_ui_def_ref
4326: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4327: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4328: ,cz_pb_mgr.g_ui_refs_ref_ui_def_ref
4329: ,'cz_ui_refs.ref_ui_def_id'
4330: ,cz_pb_mgr.v_status_code
4323: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_refs_expl_id_ref';
4324: -- should call resolve_ids instead
4325: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_refs_new_ui_def_ref
4326: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4327: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4328: ,cz_pb_mgr.g_ui_refs_ref_ui_def_ref
4329: ,'cz_ui_refs.ref_ui_def_id'
4330: ,cz_pb_mgr.v_status_code
4331: );
4367: l_ui_ps_maps_element_tbl varchar_type_tbl;
4368: l_ui_ps_maps_tgt_pg_ui_def_tbl cz_pb_mgr.t_ref;
4369: rec_count NUMBER := 0;
4370: BEGIN
4371: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
4372: THEN
4373: cz_pb_mgr.g_ui_ps_maps_old_ui_def_ref.DELETE;
4374: cz_pb_mgr.g_ui_ps_maps_new_ui_def_ref.DELETE;
4375: cz_pb_mgr.g_ui_ps_maps_ctrl_tmp_ref.DELETE;
4379: cz_pb_mgr.g_ui_ps_maps_templ_ui_tbl.DELETE;
4380: cz_pb_mgr.g_ui_ps_maps_elem_sig_tbl.DELETE;
4381: cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl.DELETE;
4382:
4383: 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
4384: LOOP
4385: l_ui_ps_maps_ui_def_tbl.DELETE;
4386: l_ui_ps_maps_ctrl_tmp_tbl.DELETE;
4387: l_ui_ps_maps_page_id_tbl.DELETE;
4396: ,model_ref_expl_id, ctrl_template_ui_def_id, element_signature_id, target_page_ui_def_id
4397: 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
4398: ,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
4399: FROM cz_ui_page_elements
4400: WHERE cz_ui_page_elements.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef)
4401: AND cz_ui_page_elements.deleted_flag = record_not_deleted;
4402: EXCEPTION
4403: WHEN NO_DATA_FOUND
4404: THEN
4443: BEGIN
4444: IF (cz_pb_mgr.g_ui_ps_maps_old_ui_def_ref.COUNT > 0)
4445: THEN
4446: ----resolve ui_def_id
4447: 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');
4448:
4449: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
4450: 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');
4451: 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);
4474: plsql_table_list(rec_count).col_name := 'TARGET_PAGE_UI_DEF_ID';
4475: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl';
4476: -- should call resolve_ids instead
4477: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_ps_maps_new_ui_def_ref
4478: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4479: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4480: ,cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl
4481: ,'cz_ui_page_elements.target_page_ui_def_id'
4482: ,cz_pb_mgr.v_status_code
4475: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl';
4476: -- should call resolve_ids instead
4477: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_ps_maps_new_ui_def_ref
4478: ,cz_pb_mgr.v_cz_ui_defs_old_ref
4479: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
4480: ,cz_pb_mgr.g_ui_ps_maps_tgt_pg_ui_def_tbl
4481: ,'cz_ui_page_elements.target_page_ui_def_id'
4482: ,cz_pb_mgr.v_status_code
4483: );
4844: --But there is a possibility that it would introduce regression in publishing
4845: --and taking the safer route here.
4846: IF (cz_pb_mgr.v_session_parameter = pub_model)
4847: THEN
4848: 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');
4849: ELSE
4850: 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');
4851: END IF;
4852: -----resolve button bar templates
4975: END insert_ui_templates;
4976:
4977: --------------------------------------------------------------
4978: ----bulk collect from cz_ui_cont_type_templs
4979: PROCEDURE bulk_collect_cont_type_templs(p_cz_ui_defs_old_oa_ref cz_pb_mgr.t_ref)
4980: IS
4981: l_cnt_typ_tmpls_tmpid_tbl cz_pb_mgr.t_ref;
4982: l_cnt_typ_tmpls_uidef_tbl cz_pb_mgr.t_ref;
4983: l_cnt_typ_tmpls_tgtuidef_tbl cz_pb_mgr.t_ref;
4983: l_cnt_typ_tmpls_tgtuidef_tbl cz_pb_mgr.t_ref;
4984: l_cnt_typ_tmpls_cont_tbl cz_pb_mgr.t_ref;
4985: rec_count NUMBER := 0;
4986: BEGIN
4987: IF (p_cz_ui_defs_old_oa_ref.COUNT > 0)
4988: THEN
4989: cz_pb_mgr.g_cnt_typ_tmpls_tmpid_ref.DELETE;
4990: cz_pb_mgr.g_cnt_typ_tmpls_old_uidef_ref.DELETE;
4991: cz_pb_mgr.g_cnt_typ_tmpls_new_uidef_ref.DELETE;
4989: cz_pb_mgr.g_cnt_typ_tmpls_tmpid_ref.DELETE;
4990: cz_pb_mgr.g_cnt_typ_tmpls_old_uidef_ref.DELETE;
4991: cz_pb_mgr.g_cnt_typ_tmpls_new_uidef_ref.DELETE;
4992:
4993: FOR uidef IN p_cz_ui_defs_old_oa_ref.FIRST .. p_cz_ui_defs_old_oa_ref.LAST
4994: LOOP
4995: l_cnt_typ_tmpls_tmpid_tbl.DELETE;
4996: l_cnt_typ_tmpls_uidef_tbl.DELETE;
4997: l_cnt_typ_tmpls_cont_tbl.DELETE;
5001: THEN
5002: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5003: BULK COLLECT INTO l_cnt_typ_tmpls_uidef_tbl, l_cnt_typ_tmpls_tmpid_tbl, l_cnt_typ_tmpls_tgtuidef_tbl, l_cnt_typ_tmpls_cont_tbl
5004: FROM cz_ui_cont_type_templs
5005: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted;
5006: ELSE
5007: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5008: BULK COLLECT INTO l_cnt_typ_tmpls_uidef_tbl, l_cnt_typ_tmpls_tmpid_tbl, l_cnt_typ_tmpls_tgtuidef_tbl, l_cnt_typ_tmpls_cont_tbl
5009: FROM cz_ui_cont_type_templs
5006: ELSE
5007: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5008: BULK COLLECT INTO l_cnt_typ_tmpls_uidef_tbl, l_cnt_typ_tmpls_tmpid_tbl, l_cnt_typ_tmpls_tgtuidef_tbl, l_cnt_typ_tmpls_cont_tbl
5009: FROM cz_ui_cont_type_templs
5010: WHERE cz_ui_cont_type_templs.ui_def_id = p_cz_ui_defs_old_oa_ref(uidef)
5011: AND cz_ui_cont_type_templs.seeded_flag <> seed_data
5012: AND cz_ui_cont_type_templs.deleted_flag = record_not_deleted
5013: AND cz_ui_cont_type_templs.master_template_flag <> '1';
5014: END IF;
5227: LOOP
5228: l_new_document :=
5229: REPLACE(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc)
5230: ,TO_CHAR(cz_pb_mgr.g_pages_ui_def_old_ref(doc))
5231: ,TO_CHAR(cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.g_pages_ui_def_old_ref(doc)))
5232: );
5233: 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');
5234: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc) := l_new_document;
5235: END LOOP;
5251: LOOP
5252: l_new_document :=
5253: REPLACE(cz_pb_mgr.g_page_sets_jrad_doc_ref(doc)
5254: ,'ui' || TO_CHAR(cz_pb_mgr.g_page_sets_ui_old_ref(doc))
5255: ,'ui' || TO_CHAR(cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.g_page_sets_ui_old_ref(doc)))
5256: );
5257: 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');
5258: cz_pb_mgr.g_page_sets_jrad_doc_ref(doc) := l_new_document;
5259: END LOOP;
5495:
5496: BEGIN
5497: SELECT intl_text_id
5498: BULK COLLECT INTO l_intl_text_id_tbl
5499: FROM cz_intl_texts txt, cz_ui_defs ui
5500: WHERE txt.model_id = cz_pb_mgr.v_models_to_be_exported(i)
5501: AND txt.deleted_flag = '0'
5502: AND NVL(txt.seeded_flag, '0') = '0'
5503: AND NVL(txt.ui_def_id, -1) = ui.ui_def_id
5635: END IF;
5636: END IF;
5637:
5638: ----resolve ui_def_id
5639: bulk_collect_cont_type_templs(cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
5640:
5641: resolve_ids(cz_pb_mgr.g_cnt_typ_tmpls_old_uidef_ref,cz_pb_mgr.g_cnt_typ_tmpls_new_uidef_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of cont type tmpls');
5642:
5643: ----resolve tmp ui_def_id, template id
5637:
5638: ----resolve ui_def_id
5639: bulk_collect_cont_type_templs(cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
5640:
5641: resolve_ids(cz_pb_mgr.g_cnt_typ_tmpls_old_uidef_ref,cz_pb_mgr.g_cnt_typ_tmpls_new_uidef_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of cont type tmpls');
5642:
5643: ----resolve tmp ui_def_id, template id
5644: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
5645: resolve_tmpl_ui_defs(cz_pb_mgr.g_cnt_typ_tmpls_tgtuidef_ref, cz_pb_mgr.g_cnt_typ_tmpls_tmpid_ref, 'tmpl uidefs of cz_ui_cont_type_templs');
5679: END LOOP;
5680: END IF;
5681:
5682: ----bulk collect ui actions
5683: bulk_collect_ui_actions(cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
5684:
5685: -- Note g_ui_actns_ui_act_id_ref contains both local ui actions (bulk_collect_ui_actions)
5686: -- and global ones (collect_global_actions). The 'new' ids in this array are the same old
5687: -- ids as the ones in g_ui_actns_ui_act_id_old_ref. They are real new ids only when the
5687: -- ids as the ones in g_ui_actns_ui_act_id_old_ref. They are real new ids only when the
5688: -- session is remote migration and the actions are globals.
5689:
5690: ----resolve ui_def_id
5691: 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');
5692: -- ignore expl id resolution failure because of a ui refresh issue (see 6817586)
5693: 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);
5694: -- context_component_id, obsolete
5695: -- 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');
5739: plsql_table_list(rec_count).col_name := 'main_message_text_id';
5740: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_uiact_main_msg_tbl';
5741: -- should call resolve_ids instead
5742: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_actns_ui_uidef_ref
5743: ,cz_pb_mgr.v_cz_ui_defs_old_ref
5744: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
5745: ,cz_pb_mgr.g_ui_actns_ui_tgtui_ref
5746: ,'cz_ui_actions.target_ui_def_id'
5747: ,cz_pb_mgr.v_status_code
5740: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_uiact_main_msg_tbl';
5741: -- should call resolve_ids instead
5742: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_actns_ui_uidef_ref
5743: ,cz_pb_mgr.v_cz_ui_defs_old_ref
5744: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
5745: ,cz_pb_mgr.g_ui_actns_ui_tgtui_ref
5746: ,'cz_ui_actions.target_ui_def_id'
5747: ,cz_pb_mgr.v_status_code
5748: );
5803: END IF;
5804: END IF;
5805:
5806: ----resolve ui_def_id
5807: bulk_collect_ui_images(cz_pb_mgr.v_cz_ui_defs_old_ref);
5808: 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');
5809: -----insert into ui images
5810: plsql_table_list.DELETE;
5811: rec_count := 1;
5804: END IF;
5805:
5806: ----resolve ui_def_id
5807: bulk_collect_ui_images(cz_pb_mgr.v_cz_ui_defs_old_ref);
5808: 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');
5809: -----insert into ui images
5810: plsql_table_list.DELETE;
5811: rec_count := 1;
5812: plsql_table_list(rec_count).col_name := 'ui_def_id';
5880:
5881: BEGIN
5882: SELECT ui_def_id, ui_style
5883: INTO l_ui_def_id, l_ui_style
5884: FROM cz_ui_defs
5885: WHERE cz_ui_defs.ui_def_id = p_ui_def_id AND cz_ui_defs.deleted_flag = record_not_deleted;
5886: EXCEPTION
5887: WHEN NO_DATA_FOUND
5888: THEN
5881: BEGIN
5882: SELECT ui_def_id, ui_style
5883: INTO l_ui_def_id, l_ui_style
5884: FROM cz_ui_defs
5885: WHERE cz_ui_defs.ui_def_id = p_ui_def_id AND cz_ui_defs.deleted_flag = record_not_deleted;
5886: EXCEPTION
5887: WHEN NO_DATA_FOUND
5888: THEN
5889: RAISE ui_def_id_not_found;
5893: THEN
5894: RAISE not_oa_style_ui;
5895: END IF;
5896:
5897: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
5898: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
5899: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
5900: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5901: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
5894: RAISE not_oa_style_ui;
5895: END IF;
5896:
5897: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
5898: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
5899: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
5900: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5901: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
5902: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_ui_def_id;
5895: END IF;
5896:
5897: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
5898: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
5899: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
5900: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5901: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
5902: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_ui_def_id;
5903: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_ui_def_id;
5896:
5897: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
5898: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
5899: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
5900: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5901: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
5902: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_ui_def_id;
5903: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_ui_def_id;
5904: l_child_ui_tbl.DELETE;
5897: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
5898: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
5899: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
5900: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5901: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
5902: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_ui_def_id;
5903: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_ui_def_id;
5904: l_child_ui_tbl.DELETE;
5905:
5898: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
5899: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
5900: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5901: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
5902: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_ui_def_id;
5903: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_ui_def_id;
5904: l_child_ui_tbl.DELETE;
5905:
5906: BEGIN
5899: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
5900: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5901: rec_count := cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT + 1;
5902: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_ui_def_id;
5903: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_ui_def_id;
5904: l_child_ui_tbl.DELETE;
5905:
5906: BEGIN
5907: SELECT ref_ui_def_id
5915: END;
5916:
5917: IF (l_child_ui_tbl.COUNT > 0)
5918: THEN
5919: rec_count := cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT + 1;
5920:
5921: FOR i IN l_child_ui_tbl.FIRST .. l_child_ui_tbl.LAST
5922: LOOP
5923: rec_count := rec_count + 1;
5920:
5921: FOR i IN l_child_ui_tbl.FIRST .. l_child_ui_tbl.LAST
5922: LOOP
5923: rec_count := rec_count + 1;
5924: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_child_ui_tbl(i);
5925: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_child_ui_tbl(i);
5926: END LOOP;
5927: END IF;
5928:
5921: FOR i IN l_child_ui_tbl.FIRST .. l_child_ui_tbl.LAST
5922: LOOP
5923: rec_count := rec_count + 1;
5924: cz_pb_mgr.v_cz_ui_defs_old_ref(rec_count) := l_child_ui_tbl(i);
5925: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_child_ui_tbl(i);
5926: END LOOP;
5927: END IF;
5928:
5929: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
5925: cz_pb_mgr.v_cz_ui_defs_old_oa_ref(rec_count) := l_child_ui_tbl(i);
5926: END LOOP;
5927: END IF;
5928:
5929: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
5930: THEN
5931: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5932: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
5933: IF (v_cz_ui_defs_old_ref.COUNT > 0) THEN
5927: END IF;
5928:
5929: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
5930: THEN
5931: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5932: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
5933: IF (v_cz_ui_defs_old_ref.COUNT > 0) THEN
5934: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
5935: LOOP
5928:
5929: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
5930: THEN
5931: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5932: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
5933: IF (v_cz_ui_defs_old_ref.COUNT > 0) THEN
5934: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
5935: LOOP
5936: rec_count := rec_count + 1;
5929: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
5930: THEN
5931: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5932: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
5933: IF (v_cz_ui_defs_old_ref.COUNT > 0) THEN
5934: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
5935: LOOP
5936: rec_count := rec_count + 1;
5937: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
5930: THEN
5931: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5932: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
5933: IF (v_cz_ui_defs_old_ref.COUNT > 0) THEN
5934: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
5935: LOOP
5936: rec_count := rec_count + 1;
5937: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
5938: 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);
5933: IF (v_cz_ui_defs_old_ref.COUNT > 0) THEN
5934: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
5935: LOOP
5936: rec_count := rec_count + 1;
5937: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
5938: 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);
5939:
5940: IF (cz_pb_mgr.v_cz_ui_defs_old_ref(k) = p_ui_def_id)
5941: THEN
5934: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
5935: LOOP
5936: rec_count := rec_count + 1;
5937: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
5938: 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);
5939:
5940: IF (cz_pb_mgr.v_cz_ui_defs_old_ref(k) = p_ui_def_id)
5941: THEN
5942: x_ui_def_id := cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count);
5936: rec_count := rec_count + 1;
5937: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
5938: 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);
5939:
5940: IF (cz_pb_mgr.v_cz_ui_defs_old_ref(k) = p_ui_def_id)
5941: THEN
5942: x_ui_def_id := cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count);
5943: END IF;
5944:
5938: 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);
5939:
5940: IF (cz_pb_mgr.v_cz_ui_defs_old_ref(k) = p_ui_def_id)
5941: THEN
5942: x_ui_def_id := cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count);
5943: END IF;
5944:
5945: 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);
5946: END LOOP;
5941: THEN
5942: x_ui_def_id := cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count);
5943: END IF;
5944:
5945: 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);
5946: END LOOP;
5947: END IF;
5948:
5949: --------populate plsql_table_list for ui_defs
5949: --------populate plsql_table_list for ui_defs
5950: plsql_table_list.DELETE;
5951: rec_count := 1;
5952: plsql_table_list(rec_count).col_name := 'ui_def_id';
5953: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_defs_new_ref';
5954: insert_into_table('cz_ui_defs'
5955: ,'ui_def_id'
5956: ,cz_pb_mgr.v_db_link
5957: ,plsql_table_list
5950: plsql_table_list.DELETE;
5951: rec_count := 1;
5952: plsql_table_list(rec_count).col_name := 'ui_def_id';
5953: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_defs_new_ref';
5954: insert_into_table('cz_ui_defs'
5955: ,'ui_def_id'
5956: ,cz_pb_mgr.v_db_link
5957: ,plsql_table_list
5958: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
5954: insert_into_table('cz_ui_defs'
5955: ,'ui_def_id'
5956: ,cz_pb_mgr.v_db_link
5957: ,plsql_table_list
5958: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
5959: ,cz_pb_mgr.v_cz_ui_defs_old_ref
5960: );
5961: ------export oa uis
5962: export_oa_uis;
5955: ,'ui_def_id'
5956: ,cz_pb_mgr.v_db_link
5957: ,plsql_table_list
5958: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
5959: ,cz_pb_mgr.v_cz_ui_defs_old_ref
5960: );
5961: ------export oa uis
5962: export_oa_uis;
5963: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
5959: ,cz_pb_mgr.v_cz_ui_defs_old_ref
5960: );
5961: ------export oa uis
5962: export_oa_uis;
5963: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
5964: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
5965: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
5966: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5967: END IF;
5960: );
5961: ------export oa uis
5962: export_oa_uis;
5963: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
5964: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
5965: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
5966: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5967: END IF;
5968: EXCEPTION
5961: ------export oa uis
5962: export_oa_uis;
5963: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
5964: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
5965: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
5966: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5967: END IF;
5968: EXCEPTION
5969: WHEN ui_def_id_is_null
5962: export_oa_uis;
5963: cz_pb_mgr.v_cz_ui_defs_old_oa_ref.DELETE;
5964: cz_pb_mgr.v_cz_ui_defs_old_ref.DELETE;
5965: cz_pb_mgr.v_cz_ui_defs_idx_ref.DELETE;
5966: cz_pb_mgr.v_cz_ui_defs_new_ref.DELETE;
5967: END IF;
5968: EXCEPTION
5969: WHEN ui_def_id_is_null
5970: THEN
6474: ,v_database_link
6475: ,'cz_pb_mgr.v_models_to_be_exported_new'
6476: ,cz_pb_mgr.v_models_to_be_exported_new
6477: );
6478: 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);
6479: 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);
6480: 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);
6481: 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);
6482: delete_from_table('cz_model_ref_expls'
6475: ,'cz_pb_mgr.v_models_to_be_exported_new'
6476: ,cz_pb_mgr.v_models_to_be_exported_new
6477: );
6478: 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);
6479: 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);
6480: 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);
6481: 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);
6482: delete_from_table('cz_model_ref_expls'
6483: ,'model_ref_expl_id'
6966: )
6967: AS
6968: v_ui_def_count NUMBER := 0;
6969: v_src_uis_tbl cz_pb_mgr.t_ref;
6970: v_cz_ui_defs_old_ref_idx_ref cz_pb_mgr.t_ref_idx_vc2;
6971: l_export_model_id cz_devl_projects.devl_project_id%TYPE;
6972: BEGIN
6973: IF (p_src_models.COUNT > 0)
6974: THEN
6979: l_export_model_id := p_src_models(i);
6980: v_src_uis_tbl.DELETE;
6981:
6982: BEGIN
6983: SELECT cz_ui_defs.ui_def_id
6984: BULK COLLECT INTO v_src_uis_tbl
6985: FROM cz_ui_defs
6986: WHERE cz_ui_defs.devl_project_id = l_export_model_id
6987: AND cz_ui_defs.deleted_flag = '0'
6981:
6982: BEGIN
6983: SELECT cz_ui_defs.ui_def_id
6984: BULK COLLECT INTO v_src_uis_tbl
6985: FROM cz_ui_defs
6986: WHERE cz_ui_defs.devl_project_id = l_export_model_id
6987: AND cz_ui_defs.deleted_flag = '0'
6988: AND cz_ui_defs.ui_style <> 7
6989: AND cz_ui_defs.NAME <> 'MUID';
6982: BEGIN
6983: SELECT cz_ui_defs.ui_def_id
6984: BULK COLLECT INTO v_src_uis_tbl
6985: FROM cz_ui_defs
6986: WHERE cz_ui_defs.devl_project_id = l_export_model_id
6987: AND cz_ui_defs.deleted_flag = '0'
6988: AND cz_ui_defs.ui_style <> 7
6989: AND cz_ui_defs.NAME <> 'MUID';
6990: EXCEPTION
6983: SELECT cz_ui_defs.ui_def_id
6984: BULK COLLECT INTO v_src_uis_tbl
6985: FROM cz_ui_defs
6986: WHERE cz_ui_defs.devl_project_id = l_export_model_id
6987: AND cz_ui_defs.deleted_flag = '0'
6988: AND cz_ui_defs.ui_style <> 7
6989: AND cz_ui_defs.NAME <> 'MUID';
6990: EXCEPTION
6991: WHEN OTHERS
6984: BULK COLLECT INTO v_src_uis_tbl
6985: FROM cz_ui_defs
6986: WHERE cz_ui_defs.devl_project_id = l_export_model_id
6987: AND cz_ui_defs.deleted_flag = '0'
6988: AND cz_ui_defs.ui_style <> 7
6989: AND cz_ui_defs.NAME <> 'MUID';
6990: EXCEPTION
6991: WHEN OTHERS
6992: THEN
6985: FROM cz_ui_defs
6986: WHERE cz_ui_defs.devl_project_id = l_export_model_id
6987: AND cz_ui_defs.deleted_flag = '0'
6988: AND cz_ui_defs.ui_style <> 7
6989: AND cz_ui_defs.NAME <> 'MUID';
6990: EXCEPTION
6991: WHEN OTHERS
6992: THEN
6993: cz_pb_mgr.v_err_message := SUBSTR('bulk collection into cz_pb_mgr.v_cz_ui_defs_old_tbl: ' || SQLERRM, 1, 2000);
6989: AND cz_ui_defs.NAME <> 'MUID';
6990: EXCEPTION
6991: WHEN OTHERS
6992: THEN
6993: cz_pb_mgr.v_err_message := SUBSTR('bulk collection into cz_pb_mgr.v_cz_ui_defs_old_tbl: ' || SQLERRM, 1, 2000);
6994: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZUIDEFS', SQLCODE);
6995: END;
6996:
6997: IF (v_src_uis_tbl.COUNT > 0)
6999: v_ui_def_count := x_ui_def_ref.COUNT;
7000:
7001: FOR k IN v_src_uis_tbl.FIRST .. v_src_uis_tbl.LAST
7002: LOOP
7003: IF (NOT v_cz_ui_defs_old_ref_idx_ref.EXISTS(v_src_uis_tbl(k)))
7004: THEN
7005: v_ui_def_count := v_ui_def_count + 1;
7006: x_ui_def_ref(v_ui_def_count) := v_src_uis_tbl(k);
7007: v_cz_ui_defs_old_ref_idx_ref(v_src_uis_tbl(k)) := v_src_uis_tbl(k);
7003: IF (NOT v_cz_ui_defs_old_ref_idx_ref.EXISTS(v_src_uis_tbl(k)))
7004: THEN
7005: v_ui_def_count := v_ui_def_count + 1;
7006: x_ui_def_ref(v_ui_def_count) := v_src_uis_tbl(k);
7007: v_cz_ui_defs_old_ref_idx_ref(v_src_uis_tbl(k)) := v_src_uis_tbl(k);
7008: END IF;
7009: END LOOP;
7010: END IF;
7011:
7015: SELECT DISTINCT ui_def_ref_id
7016: BULK COLLECT INTO v_src_uis_tbl
7017: FROM cz_ui_nodes
7018: WHERE cz_ui_nodes.ui_def_id IN(
7019: SELECT cz_ui_defs.ui_def_id
7020: FROM cz_ui_defs
7021: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7022: AND cz_ui_defs.NAME <> 'MUID')
7023: AND cz_ui_nodes.ui_def_ref_id IN(
7016: BULK COLLECT INTO v_src_uis_tbl
7017: FROM cz_ui_nodes
7018: WHERE cz_ui_nodes.ui_def_id IN(
7019: SELECT cz_ui_defs.ui_def_id
7020: FROM cz_ui_defs
7021: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7022: AND cz_ui_defs.NAME <> 'MUID')
7023: AND cz_ui_nodes.ui_def_ref_id IN(
7024: SELECT cz_ui_defs.ui_def_id
7017: FROM cz_ui_nodes
7018: WHERE cz_ui_nodes.ui_def_id IN(
7019: SELECT cz_ui_defs.ui_def_id
7020: FROM cz_ui_defs
7021: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7022: AND cz_ui_defs.NAME <> 'MUID')
7023: AND cz_ui_nodes.ui_def_ref_id IN(
7024: SELECT cz_ui_defs.ui_def_id
7025: FROM cz_ui_defs
7018: WHERE cz_ui_nodes.ui_def_id IN(
7019: SELECT cz_ui_defs.ui_def_id
7020: FROM cz_ui_defs
7021: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7022: AND cz_ui_defs.NAME <> 'MUID')
7023: AND cz_ui_nodes.ui_def_ref_id IN(
7024: SELECT cz_ui_defs.ui_def_id
7025: FROM cz_ui_defs
7026: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7020: FROM cz_ui_defs
7021: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7022: AND cz_ui_defs.NAME <> 'MUID')
7023: AND cz_ui_nodes.ui_def_ref_id IN(
7024: SELECT cz_ui_defs.ui_def_id
7025: FROM cz_ui_defs
7026: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7027: AND cz_ui_defs.NAME <> 'MUID')
7028: AND cz_ui_nodes.deleted_flag = '0'
7021: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7022: AND cz_ui_defs.NAME <> 'MUID')
7023: AND cz_ui_nodes.ui_def_ref_id IN(
7024: SELECT cz_ui_defs.ui_def_id
7025: FROM cz_ui_defs
7026: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7027: AND cz_ui_defs.NAME <> 'MUID')
7028: AND cz_ui_nodes.deleted_flag = '0'
7029: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL;
7022: AND cz_ui_defs.NAME <> 'MUID')
7023: AND cz_ui_nodes.ui_def_ref_id IN(
7024: SELECT cz_ui_defs.ui_def_id
7025: FROM cz_ui_defs
7026: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7027: AND cz_ui_defs.NAME <> 'MUID')
7028: AND cz_ui_nodes.deleted_flag = '0'
7029: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL;
7030: EXCEPTION
7023: AND cz_ui_nodes.ui_def_ref_id IN(
7024: SELECT cz_ui_defs.ui_def_id
7025: FROM cz_ui_defs
7026: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7027: AND cz_ui_defs.NAME <> 'MUID')
7028: AND cz_ui_nodes.deleted_flag = '0'
7029: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL;
7030: EXCEPTION
7031: WHEN OTHERS
7029: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL;
7030: EXCEPTION
7031: WHEN OTHERS
7032: THEN
7033: cz_pb_mgr.v_err_message := SUBSTR('bulk collection into cz_pb_mgr.v_cz_ui_defs_old_tbl: ' || SQLERRM, 1, 2000);
7034: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZUIDEFS', SQLCODE);
7035: END;
7036:
7037: IF (v_src_uis_tbl.COUNT > 0)
7039: v_ui_def_count := x_ui_def_ref.COUNT;
7040:
7041: FOR k IN v_src_uis_tbl.FIRST .. v_src_uis_tbl.LAST
7042: LOOP
7043: IF (NOT v_cz_ui_defs_old_ref_idx_ref.EXISTS(v_src_uis_tbl(k)))
7044: THEN
7045: v_ui_def_count := v_ui_def_count + 1;
7046: x_ui_def_ref(v_ui_def_count) := v_src_uis_tbl(k);
7047: v_cz_ui_defs_old_ref_idx_ref(v_src_uis_tbl(k)) := v_src_uis_tbl(k);
7043: IF (NOT v_cz_ui_defs_old_ref_idx_ref.EXISTS(v_src_uis_tbl(k)))
7044: THEN
7045: v_ui_def_count := v_ui_def_count + 1;
7046: x_ui_def_ref(v_ui_def_count) := v_src_uis_tbl(k);
7047: v_cz_ui_defs_old_ref_idx_ref(v_src_uis_tbl(k)) := v_src_uis_tbl(k);
7048: END IF;
7049: END LOOP;
7050: END IF;
7051: END LOOP; /* end loop of FOR I IN p_src_models.FIRST */
7059: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7060: ----procedure that returns the max last_update_date of ui schema
7061: 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)
7062: AS
7063: v_ui_def_id_date cz_ui_defs.last_update_date%TYPE;
7064: v_ui_node_id_date cz_ui_nodes.last_update_date%TYPE;
7065: v_ui_props_date cz_ui_nodes.last_update_date%TYPE;
7066: v_ui_node_props_date cz_ui_nodes.last_update_date%TYPE;
7067: v_ui_node_intl_date cz_ui_nodes.last_update_date%TYPE;
7080:
7081: CURSOR ui_def_cur(ui_ui_def_id NUMBER)
7082: IS
7083: SELECT last_update_date
7084: FROM cz_ui_defs
7085: WHERE cz_ui_defs.ui_def_id = ui_ui_def_id AND cz_ui_defs.deleted_flag = '0'
7086: ORDER BY last_update_date DESC;
7087:
7088: CURSOR ui_nodes_cur(node_ui_def_id NUMBER)
7081: CURSOR ui_def_cur(ui_ui_def_id NUMBER)
7082: IS
7083: SELECT last_update_date
7084: FROM cz_ui_defs
7085: WHERE cz_ui_defs.ui_def_id = ui_ui_def_id AND cz_ui_defs.deleted_flag = '0'
7086: ORDER BY last_update_date DESC;
7087:
7088: CURSOR ui_nodes_cur(node_ui_def_id NUMBER)
7089: IS
8423: cz_pb_mgr.g_ui_templates_obj_type.DELETE;
8424: cz_pb_mgr.g_enclosing_fld_rp_entry.DELETE;
8425:
8426: -- templs directly referred by the UIs: not published before or changed since publication
8427: IF cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 AND cz_pb_mgr.v_session_parameter <> model_copy THEN
8428: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST LOOP
8429: l_temp_tbl.DELETE;
8430: SELECT template_id BULK COLLECT INTO l_temp_tbl
8431: FROM cz_ui_collect_tmpls_v
8424: cz_pb_mgr.g_enclosing_fld_rp_entry.DELETE;
8425:
8426: -- templs directly referred by the UIs: not published before or changed since publication
8427: IF cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 AND cz_pb_mgr.v_session_parameter <> model_copy THEN
8428: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST LOOP
8429: l_temp_tbl.DELETE;
8430: SELECT template_id BULK COLLECT INTO l_temp_tbl
8431: FROM cz_ui_collect_tmpls_v
8432: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
8428: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST LOOP
8429: l_temp_tbl.DELETE;
8430: SELECT template_id BULK COLLECT INTO l_temp_tbl
8431: FROM cz_ui_collect_tmpls_v
8432: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
8433: AND cz_ui_collect_tmpls_v.template_id IN
8434: (SELECT template_id
8435: FROM cz_ui_templates
8436: WHERE cz_ui_templates.deleted_flag = '0' AND cz_ui_templates.seeded_flag = '0'
8622: IS
8623: v_last_struct_update cz_devl_projects.last_struct_update%TYPE;
8624: v_models_tbl cz_pb_mgr.t_ref;
8625: record_count PLS_INTEGER := 0;
8626: v_last_update_date cz_ui_defs.last_update_date%TYPE;
8627: v_fc_update_date cz_func_comp_specs.last_update_date%TYPE;
8628: v_eff_update_date DATE;
8629: v_last_xfr_activity cz_pb_model_exports.last_xfr_activity%TYPE;
8630: l_max_template_date cz_pb_model_exports.last_xfr_activity%TYPE;
8633: v_descr_date DATE;
8634: BEGIN
8635: chk_if_aleady_published(publicationid, record_count);
8636: get_source_models(cz_pb_mgr.v_root_model_id, v_models_tbl);
8637: get_source_uis(cz_pb_mgr.v_root_model_id, v_models_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref);
8638: 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);
8639: get_oa_tmpls;
8640:
8641: IF (record_count > 0)
8634: BEGIN
8635: chk_if_aleady_published(publicationid, record_count);
8636: get_source_models(cz_pb_mgr.v_root_model_id, v_models_tbl);
8637: get_source_uis(cz_pb_mgr.v_root_model_id, v_models_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref);
8638: 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);
8639: get_oa_tmpls;
8640:
8641: IF (record_count > 0)
8642: THEN
8775:
8776: ----check if uis have changed
8777: cz_pb_mgr.v_ui_str := 'x';
8778:
8779: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
8780: THEN
8781: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
8782: LOOP
8783: get_max_ui_date(cz_pb_mgr.v_cz_ui_defs_old_ref(i), v_last_update_date);
8777: cz_pb_mgr.v_ui_str := 'x';
8778:
8779: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
8780: THEN
8781: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
8782: LOOP
8783: get_max_ui_date(cz_pb_mgr.v_cz_ui_defs_old_ref(i), v_last_update_date);
8784:
8785: IF (v_last_xfr_activity IS NULL)
8779: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
8780: THEN
8781: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
8782: LOOP
8783: get_max_ui_date(cz_pb_mgr.v_cz_ui_defs_old_ref(i), v_last_update_date);
8784:
8785: IF (v_last_xfr_activity IS NULL)
8786: THEN
8787: cz_pb_mgr.v_ui_str := 'UI';
8820: ELSIF((record_count = refresh_rules_count) AND(cz_pb_mgr.v_ui_str <> 'UI'))
8821: THEN
8822: v_refresh_rules := 'YES';
8823: RETURN TRUE; ----refresh rules
8824: ELSIF(cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT = 0)
8825: THEN
8826: cz_pb_mgr.v_ui_str := 'x';
8827: RETURN TRUE;
8828: ELSE
9283:
9284: -- check if any new ui created after last xfr activity
9285: -- call get_max_ui_date if this check still not enough
9286: SELECT MAX(creation_date) INTO l_max_ui_date
9287: FROM cz_ui_defs
9288: WHERE deleted_flag = '0' AND devl_project_id = v_model_id AND ui_style <> '-1';
9289: IF l_max_ui_date IS NOT NULL AND l_max_ui_date > v_expr_last_update THEN
9290: v_expr_last_update := l_max_ui_date;
9291: END IF;
10957: THEN
10958: BEGIN
10959: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
10960: THEN
10961: OPEN child_ref_id_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'
10962: || cz_pb_mgr.v_db_link
10963: || ' '
10964: || 'WHERE name = (SELECT name FROM cz_ui_defs t'
10965: || ' '
10960: THEN
10961: OPEN child_ref_id_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'
10962: || cz_pb_mgr.v_db_link
10963: || ' '
10964: || 'WHERE name = (SELECT name FROM cz_ui_defs t'
10965: || ' '
10966: || 'WHERE t.ui_def_id = '
10967: || p_resolved_key_array(i)
10968: || ')'
10977: END LOOP;
10978:
10979: CLOSE child_ref_id_cv;
10980: ELSE
10981: OPEN child_ref_id_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'
10982: || cz_pb_mgr.v_db_link
10983: || ' '
10984: || 'WHERE name = ( SELECT name FROM cz_ui_defs t'
10985: || ' '
10980: ELSE
10981: OPEN child_ref_id_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'
10982: || cz_pb_mgr.v_db_link
10983: || ' '
10984: || 'WHERE name = ( SELECT name FROM cz_ui_defs t'
10985: || ' '
10986: || 'WHERE t.ui_def_id = '
10987: || p_resolved_key_array(i)
10988: || ' )'
11291: -- Models with no change since the last successful export are not exported. Therefore their UIs
11292: -- are not exported as well. In such a case if a referring UI is exported, then the ids of referred UIs
11293: -- need to be resolved in these referring UIs. For that we need to map all referred UI Id from the
11294: -- source to corresponding remote Ids. This is exactly what this procedure does i.e. tt maps the
11295: -- source ui_def_ids to remote ui_def_ids in the table x_cz_ui_defs_idx_ref
11296: PROCEDURE get_uis_of_mdls_not_exported(p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref,
11297: x_cz_ui_defs_idx_ref IN OUT NOCOPY cz_pb_mgr.t_ref_idx_vc2,
11298: p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE,
11299: x_status IN OUT NOCOPY VARCHAR2)
11293: -- need to be resolved in these referring UIs. For that we need to map all referred UI Id from the
11294: -- source to corresponding remote Ids. This is exactly what this procedure does i.e. tt maps the
11295: -- source ui_def_ids to remote ui_def_ids in the table x_cz_ui_defs_idx_ref
11296: PROCEDURE get_uis_of_mdls_not_exported(p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref,
11297: x_cz_ui_defs_idx_ref IN OUT NOCOPY cz_pb_mgr.t_ref_idx_vc2,
11298: p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE,
11299: x_status IN OUT NOCOPY VARCHAR2)
11300: AS
11301:
11303:
11304: ui_ref_id_cv REF_CURSOR;
11305: v_devl_project_id cz_devl_projects.devl_project_id%TYPE;
11306: v_remote_devl_project_id cz_devl_projects.devl_project_id%TYPE;
11307: v_remote_ui_def_id cz_ui_defs.ui_def_id%TYPE;
11308: v_name cz_ui_defs.name%TYPE;
11309: CANNOT_FIND_REMOTE_UI EXCEPTION;
11310:
11311: BEGIN
11304: ui_ref_id_cv REF_CURSOR;
11305: v_devl_project_id cz_devl_projects.devl_project_id%TYPE;
11306: v_remote_devl_project_id cz_devl_projects.devl_project_id%TYPE;
11307: v_remote_ui_def_id cz_ui_defs.ui_def_id%TYPE;
11308: v_name cz_ui_defs.name%TYPE;
11309: CANNOT_FIND_REMOTE_UI EXCEPTION;
11310:
11311: BEGIN
11312:
11321:
11322: -- For each of these source models, get all the UIs
11323: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0) THEN
11324: SELECT ui_def_id BULK COLLECT INTO v_ui_defs_tbl
11325: FROM cz_ui_defs
11326: WHERE deleted_flag='0' AND devl_project_id=v_devl_project_id AND ui_style=g_ui_style_jrad;
11327: ELSE
11328: BEGIN
11329: SELECT ui_def_id
11329: SELECT ui_def_id
11330: BULK
11331: COLLECT
11332: INTO v_ui_defs_tbl
11333: FROM cz_ui_defs
11334: WHERE cz_ui_defs.devl_project_id = v_devl_project_id
11335: AND cz_ui_defs.deleted_flag = RECORD_NOT_DELETED
11336: AND cz_ui_defs.ui_style <> '-1';
11337:
11330: BULK
11331: COLLECT
11332: INTO v_ui_defs_tbl
11333: FROM cz_ui_defs
11334: WHERE cz_ui_defs.devl_project_id = v_devl_project_id
11335: AND cz_ui_defs.deleted_flag = RECORD_NOT_DELETED
11336: AND cz_ui_defs.ui_style <> '-1';
11337:
11338: EXCEPTION
11331: COLLECT
11332: INTO v_ui_defs_tbl
11333: FROM cz_ui_defs
11334: WHERE cz_ui_defs.devl_project_id = v_devl_project_id
11335: AND cz_ui_defs.deleted_flag = RECORD_NOT_DELETED
11336: AND cz_ui_defs.ui_style <> '-1';
11337:
11338: EXCEPTION
11339: WHEN NO_DATA_FOUND THEN
11332: INTO v_ui_defs_tbl
11333: FROM cz_ui_defs
11334: WHERE cz_ui_defs.devl_project_id = v_devl_project_id
11335: AND cz_ui_defs.deleted_flag = RECORD_NOT_DELETED
11336: AND cz_ui_defs.ui_style <> '-1';
11337:
11338: EXCEPTION
11339: WHEN NO_DATA_FOUND THEN
11340: cz_pb_mgr.v_err_message := 'No ui_def_ids found for : '||to_char(v_devl_project_id);
11350: FOR K IN v_ui_defs_tbl.FIRST..v_ui_defs_tbl.LAST
11351: LOOP
11352: BEGIN
11353: SELECT name into v_name
11354: from cz_ui_defs
11355: where ui_def_Id = v_ui_defs_tbl(k)
11356: AND deleted_flag = RECORD_NOT_DELETED;
11357:
11358: v_remote_ui_def_id := NULL;
11355: where ui_def_Id = v_ui_defs_tbl(k)
11356: AND deleted_flag = RECORD_NOT_DELETED;
11357:
11358: v_remote_ui_def_id := NULL;
11359: OPEN ui_ref_id_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'||CZ_PB_MGR.v_db_link ||
11360: ' WHERE name = :1 AND devl_project_id = :2' ||
11361: ' AND deleted_flag = :3'
11362: USING v_name, v_remote_devl_project_id, RECORD_NOT_DELETED;
11363: LOOP
11375: END IF;
11376:
11377: CLOSE ui_ref_id_cv;
11378:
11379: x_cz_ui_defs_idx_ref(v_ui_defs_tbl(k)) := v_remote_ui_def_id;
11380:
11381: EXCEPTION
11382: WHEN OTHERS THEN
11383: CLOSE ui_ref_id_cv;
11414: v_node_ref_export_id cz_pb_model_exports.export_id%TYPE;
11415: v_node_ref_remote_model cz_pb_model_exports.remote_model_id%TYPE;
11416: rec_count NUMBER;
11417:
11418: 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;
11419: l_ui_def_name cz_ui_defs.name%TYPE;
11420:
11421: BEGIN
11422: IF (x_status <> PUBLICATION_ERROR)
11415: v_node_ref_remote_model cz_pb_model_exports.remote_model_id%TYPE;
11416: rec_count NUMBER;
11417:
11418: 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;
11419: l_ui_def_name cz_ui_defs.name%TYPE;
11420:
11421: BEGIN
11422: IF (x_status <> PUBLICATION_ERROR)
11423: THEN
11434:
11435: BEGIN
11436: SELECT ui_def_id
11437: BULK COLLECT INTO v_remote_ui_defs_tbl
11438: FROM cz_ui_defs
11439: WHERE cz_ui_defs.devl_project_id = p_models_not_exported(i) AND cz_ui_defs.deleted_flag = record_not_deleted
11440: AND ui_style IN (g_ui_style_dhtml,g_ui_style_applet);
11441: EXCEPTION
11442: WHEN NO_DATA_FOUND
11435: BEGIN
11436: SELECT ui_def_id
11437: BULK COLLECT INTO v_remote_ui_defs_tbl
11438: FROM cz_ui_defs
11439: WHERE cz_ui_defs.devl_project_id = p_models_not_exported(i) AND cz_ui_defs.deleted_flag = record_not_deleted
11440: AND ui_style IN (g_ui_style_dhtml,g_ui_style_applet);
11441: EXCEPTION
11442: WHEN NO_DATA_FOUND
11443: THEN
11516: THEN
11517: ---------get devl_project_id
11518: SELECT devl_project_id
11519: INTO v_node_ref_proj_id
11520: FROM cz_ui_defs
11521: WHERE ui_def_id = v_remote_ui_nod_ui_def_ref(i) AND cz_ui_defs.deleted_flag = '0';
11522:
11523: get_remote_model_id(p_server_id,v_node_ref_proj_id,x_status,v_node_ref_remote_model);
11524:
11517: ---------get devl_project_id
11518: SELECT devl_project_id
11519: INTO v_node_ref_proj_id
11520: FROM cz_ui_defs
11521: WHERE ui_def_id = v_remote_ui_nod_ui_def_ref(i) AND cz_ui_defs.deleted_flag = '0';
11522:
11523: get_remote_model_id(p_server_id,v_node_ref_proj_id,x_status,v_node_ref_remote_model);
11524:
11525: OPEN l_ui_def_cur(v_remote_ui_nod_ui_def_ref(i));
11535: || 'WHERE t.persistent_ui_node_id = :pers_ui_node_id'
11536: || ' '
11537: || 'AND t.ui_def_id = (SELECT ui_def_id'
11538: || ' '
11539: || 'FROM cz_ui_defs'
11540: || cz_pb_mgr.v_db_link
11541: || ' a'
11542: || ' '
11543: || 'WHERE a.name = :ui_def_name'
12073: )
12074: AND (
12075: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
12076: (t.ui_def_id>1 AND
12077: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
12078: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
12079: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
12080: WHERE p.page_id=t.ui_page_id AND
12081: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
12100: AND t.seeded_flag <> SEED_DATA
12101: AND (
12102: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
12103: (t.ui_def_id>1 AND
12104: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
12105: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
12106: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
12107: WHERE p.page_id=t.ui_page_id AND
12108: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
12127: AND t.deleted_flag = '0' AND t.seeded_flag <> SEED_DATA
12128: AND (
12129: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
12130: (t.ui_def_id>1 AND
12131: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
12132: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
12133: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
12134: WHERE p.page_id=t.ui_page_id AND
12135: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
12207: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
12208: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
12209: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
12210: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
12211: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
12212: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
12213: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
12214: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
12215: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
12208: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
12209: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
12210: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
12211: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
12212: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
12213: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
12214: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
12215: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
12216: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
12360: THEN
12361: BEGIN
12362: SELECT ui_def_id
12363: INTO x_ui_def_id
12364: FROM cz_ui_defs
12365: 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;
12366: EXCEPTION
12367: WHEN NO_DATA_FOUND
12368: THEN
12361: BEGIN
12362: SELECT ui_def_id
12363: INTO x_ui_def_id
12364: FROM cz_ui_defs
12365: 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;
12366: EXCEPTION
12367: WHEN NO_DATA_FOUND
12368: THEN
12369: x_ui_def_id := NULL;
13024: ,cz_pb_mgr.remote_publication_id
13025: ,cz_pb_mgr.v_status_code
13026: );
13027: ------get new ui_def_id for the target publication
13028: 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);
13029:
13030: -------get model id for target publication
13031: IF (g_object_type = MODEL_PUBLICATION) THEN
13032: get_new_model_id(p_publication_id, v_models_to_be_exported_new, v_remote_model, cz_pb_mgr.v_status_code);
13919: cz_pb_mgr.g_ui_node_prop_old_node_tbl.DELETE;
13920: cz_pb_mgr.g_ui_node_prop_new_uidf_tbl.DELETE;
13921: cz_pb_mgr.g_ui_node_prop_old_uidf_tbl.DELETE;
13922:
13923: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
13924: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
13925: LOOP
13926: l_prop_node_tbl.DELETE;
13927:
13920: cz_pb_mgr.g_ui_node_prop_new_uidf_tbl.DELETE;
13921: cz_pb_mgr.g_ui_node_prop_old_uidf_tbl.DELETE;
13922:
13923: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
13924: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
13925: LOOP
13926: l_prop_node_tbl.DELETE;
13927:
13928: SELECT DISTINCT prop.ui_node_id
13928: SELECT DISTINCT prop.ui_node_id
13929: BULK COLLECT INTO l_prop_node_tbl
13930: FROM cz_ui_node_props prop, cz_ui_nodes node
13931: WHERE prop.ui_def_id = node.ui_def_id
13932: AND prop.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
13933: AND node.ui_node_id = prop.ui_node_id
13934: AND node.deleted_flag = record_not_deleted
13935: AND prop.deleted_flag = record_not_deleted;
13936:
13942: LOOP
13943: l_rec_count := l_rec_count + 1;
13944: cz_pb_mgr.g_ui_node_prop_new_node_tbl(l_rec_count) := l_prop_node_tbl(j);
13945: cz_pb_mgr.g_ui_node_prop_old_node_tbl(l_rec_count) := l_prop_node_tbl(j);
13946: cz_pb_mgr.g_ui_node_prop_new_uidf_tbl(l_rec_count) := cz_pb_mgr.v_cz_ui_defs_old_ref(i);
13947: cz_pb_mgr.g_ui_node_prop_old_uidf_tbl(l_rec_count) := cz_pb_mgr.v_cz_ui_defs_old_ref(i);
13948: END LOOP;
13949: END IF;
13950: END LOOP;
13943: l_rec_count := l_rec_count + 1;
13944: cz_pb_mgr.g_ui_node_prop_new_node_tbl(l_rec_count) := l_prop_node_tbl(j);
13945: cz_pb_mgr.g_ui_node_prop_old_node_tbl(l_rec_count) := l_prop_node_tbl(j);
13946: cz_pb_mgr.g_ui_node_prop_new_uidf_tbl(l_rec_count) := cz_pb_mgr.v_cz_ui_defs_old_ref(i);
13947: cz_pb_mgr.g_ui_node_prop_old_uidf_tbl(l_rec_count) := cz_pb_mgr.v_cz_ui_defs_old_ref(i);
13948: END LOOP;
13949: END IF;
13950: END LOOP;
13951: END IF;
13952:
13953: IF cz_pb_mgr.g_ui_node_prop_new_node_tbl.COUNT > 0
13954: THEN
13955: 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');
13956: 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');
13957: l_plsql_table_list(1).col_name := 'ui_node_id';
13958: l_plsql_table_list(1).table_name := 'cz_pb_mgr.g_ui_node_prop_new_node_tbl';
13959: l_plsql_table_list(2).col_name := 'ui_def_id';
13960: l_plsql_table_list(2).table_name := 'cz_pb_mgr.g_ui_node_prop_new_uidf_tbl';
14001: cz_pb_mgr.v_new_mt_id_ref.DELETE;
14002: cz_pb_mgr.v_new_mt_id_tbl.DELETE;
14003: cz_pb_mgr.g_mt_obj_type.DELETE;
14004:
14005: -- 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
14006: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
14007: FOR ui IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14008: LOOP
14009: -- Andrew is going to provide with a query to fetch master template for given ui def id.
14002: cz_pb_mgr.v_new_mt_id_tbl.DELETE;
14003: cz_pb_mgr.g_mt_obj_type.DELETE;
14004:
14005: -- 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
14006: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
14007: FOR ui IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14008: LOOP
14009: -- Andrew is going to provide with a query to fetch master template for given ui def id.
14010: 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)
14003: cz_pb_mgr.g_mt_obj_type.DELETE;
14004:
14005: -- 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
14006: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
14007: FOR ui IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14008: LOOP
14009: -- Andrew is going to provide with a query to fetch master template for given ui def id.
14010: 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)
14011: ,ui_def_id, NAME
14006: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
14007: FOR ui IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14008: LOOP
14009: -- Andrew is going to provide with a query to fetch master template for given ui def id.
14010: 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)
14011: ,ui_def_id, NAME
14012: BULK COLLECT INTO l_mt_gen_id
14013: ,l_mt_old_id, l_mt_name
14014: FROM cz_ui_defs mstr
14010: 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)
14011: ,ui_def_id, NAME
14012: BULK COLLECT INTO l_mt_gen_id
14013: ,l_mt_old_id, l_mt_name
14014: FROM cz_ui_defs mstr
14015: WHERE mstr.deleted_flag = '0'
14016: AND mstr.master_template_flag = '1'
14017: AND mstr.seeded_flag = '0'
14018: AND EXISTS(SELECT 1
14015: WHERE mstr.deleted_flag = '0'
14016: AND mstr.master_template_flag = '1'
14017: AND mstr.seeded_flag = '0'
14018: AND EXISTS(SELECT 1
14019: FROM cz_ui_defs udf
14020: WHERE udf.from_master_template_id = mstr.ui_def_id AND ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(ui));
14021:
14022: -- keep a running array for l_mt_names
14023: rec_count := v_mt_name.COUNT;
14016: AND mstr.master_template_flag = '1'
14017: AND mstr.seeded_flag = '0'
14018: AND EXISTS(SELECT 1
14019: FROM cz_ui_defs udf
14020: WHERE udf.from_master_template_id = mstr.ui_def_id AND ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(ui));
14021:
14022: -- keep a running array for l_mt_names
14023: rec_count := v_mt_name.COUNT;
14024:
14052: rec_count := rec_count + 1;
14053:
14054: OPEN remote_mt FOR 'Select ui_def_id'
14055: || ' '
14056: || 'from cz_ui_defs'
14057: || cz_pb_mgr.v_db_link
14058: || 't'
14059: || ' '
14060: || 'where t.deleted_flag = ''0'' and t.master_template_flag = ''1'' and t.name = :1' USING cz_pb_mgr.v_mt_name(n);
14113: plsql_table_list.DELETE;
14114: rec_count := 1;
14115: plsql_table_list(rec_count).col_name := 'ui_def_id';
14116: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_new_mt_id_tbl';
14117: 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);
14118: ----------begin insert into cz_rp_entries----------------
14119: plsql_table_list.DELETE;
14120: rec_count := 1;
14121: plsql_table_list(rec_count).col_name := 'object_id';
14148: AS
14149: plsql_table_list cz_pb_mgr.col_plsql_table_list;
14150: rec_count PLS_INTEGER := 0;
14151: v_ui_node_count PLS_INTEGER := 0;
14152: v_cz_ui_defs_old_tbl cz_pb_mgr.t_ref;
14153: v_ui_devl_id_tbl cz_pb_mgr.t_ref;
14154: v_ui_comp_id_tbl cz_pb_mgr.t_ref;
14155: v_ui_rf_id_tbl cz_pb_mgr.t_ref;
14156: v_cz_ui_nodes_new_tbl cz_pb_mgr.t_ref;
14182: END IF;
14183:
14184: 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;
14185:
14186: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
14187:
14188: IF (p_models_for_export.COUNT > 0) THEN
14189: -- not copy non-jrad ui in any conversion session or in a copy session flagged by p_copy_nonjradui
14190: IF NOT (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 OR
14188: IF (p_models_for_export.COUNT > 0) THEN
14189: -- not copy non-jrad ui in any conversion session or in a copy session flagged by p_copy_nonjradui
14190: IF NOT (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 OR
14191: cz_pb_mgr.v_session_parameter=model_copy AND NOT p_copy_nonjradui) THEN
14192: get_source_uis(cz_pb_mgr.v_root_model_id, p_models_for_export, cz_pb_mgr.v_cz_ui_defs_old_ref);
14193: END IF;
14194: 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);
14195:
14196: --get_oa_tmpls is also called from has_to_be_published.
14190: IF NOT (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 OR
14191: cz_pb_mgr.v_session_parameter=model_copy AND NOT p_copy_nonjradui) THEN
14192: get_source_uis(cz_pb_mgr.v_root_model_id, p_models_for_export, cz_pb_mgr.v_cz_ui_defs_old_ref);
14193: END IF;
14194: 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);
14195:
14196: --get_oa_tmpls is also called from has_to_be_published.
14197: --However, for model migration, has_to_be_published
14198: --is not called. So make the call to get_oa_tmpls here.
14199: IF cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0 THEN
14200: get_oa_tmpls;
14201: END IF;
14202:
14203: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
14204: THEN
14205: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
14206:
14207: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14201: END IF;
14202:
14203: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
14204: THEN
14205: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
14206:
14207: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14208: LOOP
14209: rec_count := rec_count + 1;
14203: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
14204: THEN
14205: rec_count := cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT;
14206:
14207: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14208: LOOP
14209: rec_count := rec_count + 1;
14210: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
14211: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq
14206:
14207: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14208: LOOP
14209: rec_count := rec_count + 1;
14210: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
14211: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq
14212: , 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link
14213: ,cz_pb_mgr.v_oraclesequenceincr
14214: );
14207: FOR k IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14208: LOOP
14209: rec_count := rec_count + 1;
14210: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
14211: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq
14212: , 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link
14213: ,cz_pb_mgr.v_oraclesequenceincr
14214: );
14215: END LOOP;
14208: LOOP
14209: rec_count := rec_count + 1;
14210: cz_pb_mgr.v_cz_ui_defs_new_ref(rec_count) :=
14211: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_defs_seq
14212: , 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link
14213: ,cz_pb_mgr.v_oraclesequenceincr
14214: );
14215: END LOOP;
14216: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
14212: , 'cz_ui_defs_s.NEXTVAL' || cz_pb_mgr.v_db_link
14213: ,cz_pb_mgr.v_oraclesequenceincr
14214: );
14215: END LOOP;
14216: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
14217: END IF;
14218:
14219: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
14220: THEN
14215: END LOOP;
14216: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
14217: END IF;
14218:
14219: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
14220: THEN
14221: FOR m IN cz_pb_mgr.v_cz_ui_defs_new_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_new_ref.LAST
14222: LOOP
14223: 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);
14217: END IF;
14218:
14219: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
14220: THEN
14221: FOR m IN cz_pb_mgr.v_cz_ui_defs_new_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_new_ref.LAST
14222: LOOP
14223: 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);
14224: END LOOP;
14225: END IF;
14219: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
14220: THEN
14221: FOR m IN cz_pb_mgr.v_cz_ui_defs_new_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_new_ref.LAST
14222: LOOP
14223: 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);
14224: END LOOP;
14225: END IF;
14226:
14227: get_uis_of_mdls_not_exported(cz_pb_mgr.v_models_not_to_be_exported,
14224: END LOOP;
14225: END IF;
14226:
14227: get_uis_of_mdls_not_exported(cz_pb_mgr.v_models_not_to_be_exported,
14228: cz_pb_mgr.v_cz_ui_defs_idx_ref,
14229: cz_pb_mgr.v_server_id,
14230: cz_pb_mgr.v_status_code);
14231:
14232: IF (cz_pb_mgr.g_log_timing = publication_timing)
14236: END IF;
14237:
14238: ---------get devl_project_ids and component_ids for ui_defs
14239: /* We should really re-architect this portion of the code
14240: we have already queried cz_ui_defs before for oa_style UIs in
14241: get_oa_uis and have the menu_caption_rule_id,page_caption_rule_id,
14242: from_master_template_id. We need to query it again here because
14243: we don't have these values for DHTML UIs and insert_into_table for
14244: cz_ui_defs will fail. We should consolidate the querying into one place.
14240: we have already queried cz_ui_defs before for oa_style UIs in
14241: get_oa_uis and have the menu_caption_rule_id,page_caption_rule_id,
14242: from_master_template_id. We need to query it again here because
14243: we don't have these values for DHTML UIs and insert_into_table for
14244: cz_ui_defs will fail. We should consolidate the querying into one place.
14245: */
14246:
14247: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
14248: THEN
14243: we don't have these values for DHTML UIs and insert_into_table for
14244: cz_ui_defs will fail. We should consolidate the querying into one place.
14245: */
14246:
14247: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
14248: THEN
14249: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
14250: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14251: LOOP
14245: */
14246:
14247: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
14248: THEN
14249: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
14250: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14251: LOOP
14252: BEGIN
14253: v_ui_devl_id_tbl.DELETE;
14246:
14247: IF (cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0)
14248: THEN
14249: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
14250: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14251: LOOP
14252: BEGIN
14253: v_ui_devl_id_tbl.DELETE;
14254: v_ui_comp_id_tbl.DELETE;
14253: v_ui_devl_id_tbl.DELETE;
14254: v_ui_comp_id_tbl.DELETE;
14255: v_ui_rf_id_tbl.DELETE;
14256:
14257: SELECT devl_project_id, component_id, menu_caption_rule_id, page_caption_rule_id, cz_ui_defs.from_master_template_id
14258: 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
14259: FROM cz_ui_defs
14260: 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;
14261:
14255: v_ui_rf_id_tbl.DELETE;
14256:
14257: SELECT devl_project_id, component_id, menu_caption_rule_id, page_caption_rule_id, cz_ui_defs.from_master_template_id
14258: 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
14259: FROM cz_ui_defs
14260: 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;
14261:
14262: rec_count := cz_pb_mgr.v_ui_devl_id_ref.COUNT;
14263:
14256:
14257: SELECT devl_project_id, component_id, menu_caption_rule_id, page_caption_rule_id, cz_ui_defs.from_master_template_id
14258: 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
14259: FROM cz_ui_defs
14260: 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;
14261:
14262: rec_count := cz_pb_mgr.v_ui_devl_id_ref.COUNT;
14263:
14264: IF (v_ui_devl_id_tbl.COUNT > 0)
14275: END IF;
14276: EXCEPTION
14277: WHEN OTHERS
14278: THEN
14279: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_defs', 'SQLERRM', SQLERRM);
14280: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
14281: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
14282: RAISE;
14283: END;
14280: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
14281: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
14282: RAISE;
14283: END;
14284: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_ui_defs_old_ref */
14285: END IF;
14286: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0 */
14287:
14288: IF (cz_pb_mgr.g_log_timing = publication_timing)
14282: RAISE;
14283: END;
14284: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_ui_defs_old_ref */
14285: END IF;
14286: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_new_ref.COUNT > 0 */
14287:
14288: IF (cz_pb_mgr.g_log_timing = publication_timing)
14289: THEN
14290: log_timing_message('end bulk collect of devl_project_ids and component_ids for ui_defs');
14287:
14288: IF (cz_pb_mgr.g_log_timing = publication_timing)
14289: THEN
14290: log_timing_message('end bulk collect of devl_project_ids and component_ids for ui_defs');
14291: log_timing_message('start resolve_ids devl project id of cz_ui_defs');
14292: END IF;
14293:
14294: ----------resolve devl_project_ids
14295: 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');
14291: log_timing_message('start resolve_ids devl project id of cz_ui_defs');
14292: END IF;
14293:
14294: ----------resolve devl_project_ids
14295: 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');
14296:
14297: IF (cz_pb_mgr.g_log_timing = publication_timing)
14298: THEN
14299: log_timing_message('end resolve_ids devl project id of cz_ui_defs');
14295: 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');
14296:
14297: IF (cz_pb_mgr.g_log_timing = publication_timing)
14298: THEN
14299: log_timing_message('end resolve_ids devl project id of cz_ui_defs');
14300: END IF;
14301:
14302: ----------resolve component_ids
14303: IF (cz_pb_mgr.g_log_timing = publication_timing)
14301:
14302: ----------resolve component_ids
14303: IF (cz_pb_mgr.g_log_timing = publication_timing)
14304: THEN
14305: log_timing_message('start resolve_ids component id of cz_ui_defs');
14306: END IF;
14307:
14308: 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');
14309:
14304: THEN
14305: log_timing_message('start resolve_ids component id of cz_ui_defs');
14306: END IF;
14307:
14308: 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');
14309:
14310: IF (cz_pb_mgr.g_log_timing = publication_timing)
14311: THEN
14312: log_timing_message('end resolve_ids component id of cz_ui_defs');
14308: 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');
14309:
14310: IF (cz_pb_mgr.g_log_timing = publication_timing)
14311: THEN
14312: log_timing_message('end resolve_ids component id of cz_ui_defs');
14313: END IF;
14314:
14315: ----------resolve component_ids of models not to be exported
14316: IF (cz_pb_mgr.g_log_timing = publication_timing)
14347: --------populate plsql_table_list for ui_defs
14348: plsql_table_list.DELETE;
14349: rec_count := 1;
14350: plsql_table_list(rec_count).col_name := 'ui_def_id';
14351: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_defs_new_ref';
14352: rec_count := rec_count + 1;
14353: plsql_table_list(rec_count).col_name := 'devl_project_id';
14354: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ui_devl_id_ref';
14355: rec_count := rec_count + 1;
14361: rec_count := rec_count + 1;
14362: plsql_table_list(rec_count).col_name := 'page_caption_rule_id';
14363: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ui_defs_pcpt_rule_ref';
14364:
14365: ---------insert into cz_ui_defs of target server
14366: IF (cz_pb_mgr.g_log_timing = publication_timing)
14367: THEN
14368: log_timing_message('start insert_into_table cz_ui_defs');
14369: END IF;
14364:
14365: ---------insert into cz_ui_defs of target server
14366: IF (cz_pb_mgr.g_log_timing = publication_timing)
14367: THEN
14368: log_timing_message('start insert_into_table cz_ui_defs');
14369: END IF;
14370:
14371: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id <> 0)
14372: THEN
14374: plsql_table_list(rec_count).col_name := 'from_master_template_id';
14375: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_master_template_id_ref';
14376: END IF;
14377:
14378: insert_into_table('cz_ui_defs'
14379: ,'ui_def_id'
14380: ,cz_pb_mgr.v_db_link
14381: ,plsql_table_list
14382: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
14378: insert_into_table('cz_ui_defs'
14379: ,'ui_def_id'
14380: ,cz_pb_mgr.v_db_link
14381: ,plsql_table_list
14382: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
14383: ,cz_pb_mgr.v_cz_ui_defs_old_ref
14384: );
14385:
14386: IF (cz_pb_mgr.g_log_timing = publication_timing)
14379: ,'ui_def_id'
14380: ,cz_pb_mgr.v_db_link
14381: ,plsql_table_list
14382: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
14383: ,cz_pb_mgr.v_cz_ui_defs_old_ref
14384: );
14385:
14386: IF (cz_pb_mgr.g_log_timing = publication_timing)
14387: THEN
14384: );
14385:
14386: IF (cz_pb_mgr.g_log_timing = publication_timing)
14387: THEN
14388: log_timing_message('end insert_into_table cz_ui_defs');
14389: END IF;
14390:
14391: ------export oa uis
14392: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0) THEN
14388: log_timing_message('end insert_into_table cz_ui_defs');
14389: END IF;
14390:
14391: ------export oa uis
14392: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0) THEN
14393: export_oa_uis;
14394: END IF;
14395:
14396: --------populate plsql_table_list for ui_properties
14396: --------populate plsql_table_list for ui_properties
14397: plsql_table_list.DELETE;
14398: rec_count := 1;
14399: plsql_table_list(rec_count).col_name := 'ui_def_id';
14400: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_defs_new_ref';
14401:
14402: ------------insert into cz_ui_properties of target server
14403: IF (cz_pb_mgr.g_log_timing = publication_timing)
14404: THEN
14408: insert_into_table('cz_ui_properties'
14409: ,'ui_def_id'
14410: ,cz_pb_mgr.v_db_link
14411: ,plsql_table_list
14412: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
14413: ,cz_pb_mgr.v_cz_ui_defs_old_ref
14414: );
14415:
14416: IF (cz_pb_mgr.g_log_timing = publication_timing)
14409: ,'ui_def_id'
14410: ,cz_pb_mgr.v_db_link
14411: ,plsql_table_list
14412: ,'cz_pb_mgr.v_cz_ui_defs_old_ref'
14413: ,cz_pb_mgr.v_cz_ui_defs_old_ref
14414: );
14415:
14416: IF (cz_pb_mgr.g_log_timing = publication_timing)
14417: THEN
14425: THEN
14426: log_timing_message('start bulk collect of cz_ui_nodes');
14427: END IF;
14428:
14429: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
14430: THEN
14431: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14432: LOOP
14433: v_cz_ui_nodes_new_tbl.DELETE;
14427: END IF;
14428:
14429: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
14430: THEN
14431: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14432: LOOP
14433: v_cz_ui_nodes_new_tbl.DELETE;
14434: v_cz_ui_nodes_old_tbl.DELETE;
14435: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14455: ,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
14456: ,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
14457: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
14458: FROM cz_ui_nodes
14459: 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;
14460: EXCEPTION
14461: WHEN NO_DATA_FOUND
14462: THEN
14463: cz_pb_mgr.v_err_message := 'No ui nodes found for : ' || TO_CHAR(cz_pb_mgr.v_cz_ui_defs_old_ref(i));
14459: 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;
14460: EXCEPTION
14461: WHEN NO_DATA_FOUND
14462: THEN
14463: cz_pb_mgr.v_err_message := 'No ui nodes found for : ' || TO_CHAR(cz_pb_mgr.v_cz_ui_defs_old_ref(i));
14464: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UINODES', SQLCODE);
14465: WHEN OTHERS
14466: THEN
14467: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_nodes', 'SQLERRM', SQLERRM);
14490: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
14491: END LOOP;
14492: END IF; /* end if of v_cz_ui_nodes_new_tbl.COUNT > 0 */
14493: END LOOP;
14494: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
14495:
14496: IF (cz_pb_mgr.g_log_timing = publication_timing)
14497: THEN
14498: log_timing_message('end bulk collect of cz_ui_nodes');
14555: THEN
14556: log_timing_message('start resolve_ids ui def ids of ui nodes');
14557: END IF;
14558:
14559: 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');
14560:
14561: IF (cz_pb_mgr.g_log_timing = publication_timing)
14562: THEN
14563: log_timing_message('end resolve_ids ui def ids of ui nodes');
14635:
14636: ---------resolve ui_def_ref_id
14637: -- should call resolve_ids instead
14638: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_ui_nodes_new_ref
14639: ,cz_pb_mgr.v_cz_ui_defs_old_ref
14640: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
14641: ,cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref
14642: ,'cz_ui_nodes.ui_def_ref_id'
14643: ,cz_pb_mgr.v_status_code
14636: ---------resolve ui_def_ref_id
14637: -- should call resolve_ids instead
14638: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_ui_nodes_new_ref
14639: ,cz_pb_mgr.v_cz_ui_defs_old_ref
14640: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
14641: ,cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref
14642: ,'cz_ui_nodes.ui_def_ref_id'
14643: ,cz_pb_mgr.v_status_code
14644: );
14722: THEN
14723: log_timing_message('start insert_into_table cz_ui_node_props');
14724: END IF;
14725:
14726: insert_ui_node_props(cz_pb_mgr.v_cz_ui_defs_old_ref);
14727:
14728: IF (cz_pb_mgr.g_log_timing = publication_timing)
14729: THEN
14730: log_timing_message('end insert_into_table cz_ui_node_props');
15006: 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);
15007:
15008: -------------Resolve expl id of cz_rules
15009: 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');
15010: 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');
15011: -------------populate plsql_table_list for cz rules
15012: plsql_table_list.DELETE;
15013: rec_count := 1;
15014: plsql_table_list(rec_count).col_name := 'rule_id';
17324: ,x_model_name OUT NOCOPY VARCHAR2
17325: ,p_check_root_ui_only IN BOOLEAN DEFAULT FALSE
17326: )
17327: IS
17328: l_ui_style cz_ui_defs.ui_style%TYPE;
17329: l_ui_status cz_ui_defs.ui_status%TYPE;
17330: l_ui_tbl t_ref;
17331: l_ui_name cz_ui_defs.NAME%TYPE;
17332: l_root_model_id NUMBER;
17325: ,p_check_root_ui_only IN BOOLEAN DEFAULT FALSE
17326: )
17327: IS
17328: l_ui_style cz_ui_defs.ui_style%TYPE;
17329: l_ui_status cz_ui_defs.ui_status%TYPE;
17330: l_ui_tbl t_ref;
17331: l_ui_name cz_ui_defs.NAME%TYPE;
17332: l_root_model_id NUMBER;
17333: l_root_ui_last_update_date DATE;
17327: IS
17328: l_ui_style cz_ui_defs.ui_style%TYPE;
17329: l_ui_status cz_ui_defs.ui_status%TYPE;
17330: l_ui_tbl t_ref;
17331: l_ui_name cz_ui_defs.NAME%TYPE;
17332: l_root_model_id NUMBER;
17333: l_root_ui_last_update_date DATE;
17334: l_model_id NUMBER;
17335: l_model_name cz_devl_projects.NAME%TYPE;
17334: l_model_id NUMBER;
17335: l_model_name cz_devl_projects.NAME%TYPE;
17336: l_last_update_date DATE;
17337: l_last_struct_update DATE;
17338: l_suppress_refresh_flag cz_ui_defs.suppress_refresh_flag%TYPE;
17339: BEGIN
17340: x_return_status := 0;
17341: x_msg_data := '';
17342:
17341: x_msg_data := '';
17342:
17343: SELECT ui_style, ui_status, NAME, NVL(suppress_refresh_flag, '0'), devl_project_id, NVL(ui_timestamp_refresh, last_update_date)
17344: INTO l_ui_style, l_ui_status, l_ui_name, l_suppress_refresh_flag, l_root_model_id, l_root_ui_last_update_date
17345: FROM cz_ui_defs
17346: WHERE ui_def_id = p_ui_def_id;
17347:
17348: IF l_ui_status = 'NEED_REFRESH' THEN
17349: x_return_status := 2;
17375: FROM cz_ui_refs
17376: START WITH ui_def_id = p_ui_def_id AND deleted_flag = '0'
17377: CONNECT BY PRIOR ref_ui_def_id = ui_def_id AND deleted_flag = '0' AND PRIOR deleted_flag = '0') uis
17378: WHERE EXISTS (SELECT NULL
17379: FROM cz_ui_defs
17380: WHERE ui_def_id = uis.ref_ui_def_id AND deleted_flag = '0' AND NVL(suppress_refresh_flag, '0') = '0');
17381:
17382: IF l_suppress_refresh_flag = '0' THEN
17383: l_ui_tbl(l_ui_tbl.COUNT + 1) := p_ui_def_id;
17400: ELSE
17401: BEGIN
17402: SELECT NVL(ui_timestamp_refresh, last_update_date), devl_project_id, NAME, ui_status
17403: INTO l_last_update_date, l_model_id, l_ui_name, l_ui_status
17404: FROM cz_ui_defs
17405: WHERE cz_ui_defs.ui_def_id = l_ui_tbl(i);
17406: EXCEPTION
17407: WHEN OTHERS THEN
17408: l_last_update_date := NULL;
17401: BEGIN
17402: SELECT NVL(ui_timestamp_refresh, last_update_date), devl_project_id, NAME, ui_status
17403: INTO l_last_update_date, l_model_id, l_ui_name, l_ui_status
17404: FROM cz_ui_defs
17405: WHERE cz_ui_defs.ui_def_id = l_ui_tbl(i);
17406: EXCEPTION
17407: WHEN OTHERS THEN
17408: l_last_update_date := NULL;
17409: END;
17498: l_model_name VARCHAR2(1000);
17499: l_copy_nonjradui BOOLEAN;
17500: ui_not_uptodate EXCEPTION;
17501:
17502: TYPE ui_style_tbl_type IS TABLE OF cz_ui_defs.ui_style%TYPE INDEX BY PLS_INTEGER;
17503: l_ui_style_tbl ui_style_tbl_type;
17504: BEGIN
17505: ----------delete session specific parameters
17506: BEGIN
17579: THEN
17580: BEGIN
17581: SELECT MAX(ui_def_id)
17582: INTO cz_pb_mgr.v_root_ui_def_id
17583: FROM cz_ui_defs
17584: WHERE cz_ui_defs.devl_project_id = cz_pb_mgr.v_root_model_id AND cz_ui_defs.deleted_flag = '0';
17585: EXCEPTION
17586: WHEN NO_DATA_FOUND
17587: THEN
17580: BEGIN
17581: SELECT MAX(ui_def_id)
17582: INTO cz_pb_mgr.v_root_ui_def_id
17583: FROM cz_ui_defs
17584: WHERE cz_ui_defs.devl_project_id = cz_pb_mgr.v_root_model_id AND cz_ui_defs.deleted_flag = '0';
17585: EXCEPTION
17586: WHEN NO_DATA_FOUND
17587: THEN
17588: cz_pb_mgr.v_root_ui_def_id := -999;
17622: THEN
17623: BEGIN
17624: SELECT 1
17625: INTO v_ui_chk_count
17626: FROM cz_ui_defs
17627: WHERE cz_ui_defs.ui_def_id = cz_pb_mgr.v_root_ui_def_id AND cz_ui_defs.deleted_flag = '0';
17628: EXCEPTION
17629: WHEN OTHERS
17630: THEN
17623: BEGIN
17624: SELECT 1
17625: INTO v_ui_chk_count
17626: FROM cz_ui_defs
17627: WHERE cz_ui_defs.ui_def_id = cz_pb_mgr.v_root_ui_def_id AND cz_ui_defs.deleted_flag = '0';
17628: EXCEPTION
17629: WHEN OTHERS
17630: THEN
17631: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_UI');
17638: IF cz_pb_mgr.copy_uis = 'YES' THEN
17639: l_copy_nonjradui := TRUE;
17640: IF cz_pb_mgr.copy_root_only = 'YES' THEN
17641: SELECT ui_def_id, ui_style BULK COLLECT INTO l_ui_tbl, l_ui_style_tbl
17642: FROM cz_ui_defs
17643: WHERE deleted_flag='0' AND ui_style<>-1 AND devl_project_id=p_model_id;
17644: ELSE
17645: SELECT ui_def_id, ui_style BULK COLLECT INTO l_ui_tbl, l_ui_style_tbl
17646: FROM cz_ui_defs
17642: FROM cz_ui_defs
17643: WHERE deleted_flag='0' AND ui_style<>-1 AND devl_project_id=p_model_id;
17644: ELSE
17645: SELECT ui_def_id, ui_style BULK COLLECT INTO l_ui_tbl, l_ui_style_tbl
17646: FROM cz_ui_defs
17647: WHERE deleted_flag='0' AND ui_style<>-1 AND devl_project_id IN
17648: (SELECT component_id FROM cz_model_ref_expls
17649: WHERE deleted_flag='0' AND model_id=p_model_id);
17650: END IF;
18377: IF ((p_ui_def_id IS NOT NULL) AND(p_ui_def_id > 0))
18378: THEN
18379: SELECT COUNT(*)
18380: INTO v_ui_chk_count
18381: FROM cz_ui_defs
18382: WHERE cz_ui_defs.ui_def_id = p_ui_def_id AND cz_ui_defs.deleted_flag = record_not_deleted;
18383:
18384: IF (v_ui_chk_count = 0)
18385: THEN
18378: THEN
18379: SELECT COUNT(*)
18380: INTO v_ui_chk_count
18381: FROM cz_ui_defs
18382: WHERE cz_ui_defs.ui_def_id = p_ui_def_id AND cz_ui_defs.deleted_flag = record_not_deleted;
18383:
18384: IF (v_ui_chk_count = 0)
18385: THEN
18386: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_UI', 'PUBID', p_publication_id);
18410: ,x_rem_ui_def_id IN OUT NOCOPY cz_model_publications.ui_def_id%TYPE
18411: ,x_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
18412: )
18413: AS
18414: v_ui_name cz_ui_defs.NAME%TYPE;
18415: v_old_remote_model cz_model_publications.model_id%TYPE;
18416: ui_cv ref_cursor;
18417: BEGIN
18418: BEGIN
18417: BEGIN
18418: BEGIN
18419: SELECT NAME
18420: INTO v_ui_name
18421: FROM cz_ui_defs
18422: WHERE ui_def_id = p_ui_def_id;
18423: EXCEPTION
18424: WHEN OTHERS
18425: THEN
18437: x_rem_model_id := v_old_remote_model;
18438:
18439: IF (v_ui_name IS NOT NULL)
18440: THEN
18441: OPEN ui_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'
18442: || cz_pb_mgr.v_db_link
18443: || ' '
18444: || 'WHERE name = :1'
18445: || ' '
18639: -- private, check all uis if input uidefid null, check the given ui tree otherwise
18640: PROCEDURE model_upto_date(modelid IN NUMBER, status IN OUT NOCOPY VARCHAR2, uidefid IN NUMBER DEFAULT NULL)
18641: AS
18642: l_model_name VARCHAR2(4000);
18643: l_ui_name cz_ui_defs.NAME%TYPE;
18644: l_ui_model_name VARCHAR2(4000);
18645: l_model_status NUMBER;
18646: l_ui_status NUMBER;
18647: l_folder_id NUMBER;
18661:
18662: IF uidefid IS NULL THEN
18663: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 THEN
18664: SELECT ui_def_id BULK COLLECT INTO l_uidef_tbl
18665: FROM cz_ui_defs
18666: WHERE deleted_flag='0' AND ui_style=g_ui_style_jrad AND devl_project_id IN
18667: (SELECT component_id FROM cz_model_ref_expls
18668: WHERE deleted_flag='0' AND model_id=modelid);
18669: ELSE
18667: (SELECT component_id FROM cz_model_ref_expls
18668: WHERE deleted_flag='0' AND model_id=modelid);
18669: ELSE
18670: SELECT ui_def_id BULK COLLECT INTO l_uidef_tbl
18671: FROM cz_ui_defs
18672: WHERE deleted_flag='0' AND ui_style<>-1 AND devl_project_id IN
18673: (SELECT component_id FROM cz_model_ref_expls
18674: WHERE deleted_flag='0' AND model_id=modelid);
18675: END IF;
21132: l_usage_id_tbl cz_pb_mgr.t_ref;
21133: l_param_status VARCHAR2(2000);
21134: v_upto_date_status VARCHAR2(2000);
21135: v_publicationidstring VARCHAR2(2000);
21136: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
21137: l_deleted_flag VARCHAR2(1);
21138: l_ui_name cz_ui_defs.NAME%TYPE;
21139: expstatus_exception EXCEPTION;
21140: get_params_exception EXCEPTION;
21134: v_upto_date_status VARCHAR2(2000);
21135: v_publicationidstring VARCHAR2(2000);
21136: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
21137: l_deleted_flag VARCHAR2(1);
21138: l_ui_name cz_ui_defs.NAME%TYPE;
21139: expstatus_exception EXCEPTION;
21140: get_params_exception EXCEPTION;
21141: model_not_upto_date EXCEPTION;
21142: pub_overlap EXCEPTION;
21180: THEN
21181: BEGIN
21182: SELECT ui_def_id, deleted_flag, NAME
21183: INTO l_ui_def_id, l_deleted_flag, l_ui_name
21184: FROM cz_ui_defs
21185: WHERE cz_ui_defs.ui_def_id = v_source_pb_record.ui_def_id;
21186: EXCEPTION
21187: WHEN NO_DATA_FOUND
21188: THEN
21181: BEGIN
21182: SELECT ui_def_id, deleted_flag, NAME
21183: INTO l_ui_def_id, l_deleted_flag, l_ui_name
21184: FROM cz_ui_defs
21185: WHERE cz_ui_defs.ui_def_id = v_source_pb_record.ui_def_id;
21186: EXCEPTION
21187: WHEN NO_DATA_FOUND
21188: THEN
21189: RAISE ui_def_id_is_deleted;
21885: l_last_updated DATE;
21886: l_persistent_project_id cz_devl_projects.persistent_project_id%TYPE;
21887: v_publicationidstring VARCHAR2(2000);
21888: v_upto_date_status VARCHAR2(2000);
21889: l_ui_style cz_ui_defs.ui_style%TYPE;
21890: v_new_publication_id cz_model_publications.publication_id%TYPE;
21891: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;
21892: l_organization_id cz_devl_projects.organization_id%TYPE;
21893: l_product_key cz_devl_projects.product_key%TYPE;
21890: v_new_publication_id cz_model_publications.publication_id%TYPE;
21891: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;
21892: l_organization_id cz_devl_projects.organization_id%TYPE;
21893: l_product_key cz_devl_projects.product_key%TYPE;
21894: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
21895: l_short_name cz_pb_client_apps.application_short_name%TYPE;
21896: pub_overlap EXCEPTION;
21897: no_model_id EXCEPTION;
21898: no_model_exists EXCEPTION;
21950: ELSE
21951: BEGIN
21952: SELECT ui_def_id, ui_style
21953: INTO l_ui_def_id, l_ui_style
21954: FROM cz_ui_defs
21955: 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';
21956: EXCEPTION
21957: WHEN NO_DATA_FOUND
21958: THEN
21951: BEGIN
21952: SELECT ui_def_id, ui_style
21953: INTO l_ui_def_id, l_ui_style
21954: FROM cz_ui_defs
21955: 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';
21956: EXCEPTION
21957: WHEN NO_DATA_FOUND
21958: THEN
21959: RAISE no_ui_exists;
23645: */
23646: FUNCTION has_ui_inany_chld_mdl_changed(rootmodelid IN NUMBER) RETURN boolean IS
23647:
23648: v_models_tbl cz_pb_mgr.t_ref;
23649: v_last_update_date cz_ui_defs.last_update_date%TYPE;
23650: v_last_xfr_activity cz_pb_model_exports.last_xfr_activity%TYPE;
23651: curr_model_tbl cz_pb_mgr.t_ref;
23652:
23653: BEGIN
23665: IF(v_models_tbl(i) <> rootmodelid) THEN
23666:
23667: v_last_xfr_activity := get_mdl_last_xfr_activity(v_models_tbl(i), cz_pb_mgr.v_server_id);
23668: IF cz_pb_mgr.v_server_id<>0 THEN
23669: get_source_uis(rootmodelid, curr_model_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref);
23670: END IF;
23671: 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);
23672:
23673: IF(cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
23667: v_last_xfr_activity := get_mdl_last_xfr_activity(v_models_tbl(i), cz_pb_mgr.v_server_id);
23668: IF cz_pb_mgr.v_server_id<>0 THEN
23669: get_source_uis(rootmodelid, curr_model_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref);
23670: END IF;
23671: 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);
23672:
23673: IF(cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
23674: FOR j IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
23675: LOOP
23669: get_source_uis(rootmodelid, curr_model_tbl, cz_pb_mgr.v_cz_ui_defs_old_ref);
23670: END IF;
23671: 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);
23672:
23673: IF(cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
23674: FOR j IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
23675: LOOP
23676: get_max_ui_date(cz_pb_mgr.v_cz_ui_defs_old_ref(j), v_last_update_date);
23677:
23670: END IF;
23671: 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);
23672:
23673: IF(cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
23674: FOR j IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
23675: LOOP
23676: get_max_ui_date(cz_pb_mgr.v_cz_ui_defs_old_ref(j), v_last_update_date);
23677:
23678: IF(v_last_xfr_activity IS NULL) THEN
23672:
23673: IF(cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0) THEN
23674: FOR j IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
23675: LOOP
23676: get_max_ui_date(cz_pb_mgr.v_cz_ui_defs_old_ref(j), v_last_update_date);
23677:
23678: IF(v_last_xfr_activity IS NULL) THEN
23679: RETURN TRUE;
23680: ELSIF((v_last_xfr_activity IS NOT NULL)