[Home] [Help]
28:
29: -- special fields in id resolution
30: -- cz_des_chart_cells.primary_opt_id, secondary_opt_id, secondary_feature_id
31: -- cz_des_chart_feature.feature_id, cz_rules.rule_folder_id,
32: -- cz_ps_nodes.reference_id, cz_ui_nodes.ui_node_ref_id
33: FLD_PSN_REFERENCE_ID CONSTANT VARCHAR2(9) := 'PSNREFID';
34: FLD_RULE_COMPONENT_ID CONSTANT VARCHAR2(9) := 'RULCOMID';
35: FLD_UI_NODE_REF_ID CONSTANT VARCHAR2(9) := 'UINREFID';
36: FLD_IGNORE_NOW CONSTANT VARCHAR2(9) := 'IGNOREID';
213: -----@x_status : publication status parameter
214: PROCEDURE clear_tables(p_table_name IN VARCHAR2, p_table_type IN VARCHAR2, x_status IN OUT NOCOPY VARCHAR2)
215: AS
216: BEGIN
217: IF (p_table_name = 'cz_ps_nodes')
218: THEN
219: IF (p_table_type = 'tbl')
220: THEN
221: cz_pb_mgr.v_cz_ps_nodes_new_tbl.DELETE;
217: IF (p_table_name = 'cz_ps_nodes')
218: THEN
219: IF (p_table_type = 'tbl')
220: THEN
221: cz_pb_mgr.v_cz_ps_nodes_new_tbl.DELETE;
222: cz_pb_mgr.v_cz_ps_nodes_old_tbl.DELETE;
223: cz_pb_mgr.v_cz_ps_nodes_idx_tbl.DELETE;
224: cz_pb_mgr.v_ps_parent_id_tbl.DELETE;
225: cz_pb_mgr.v_ps_refid_old_tbl.DELETE;
218: THEN
219: IF (p_table_type = 'tbl')
220: THEN
221: cz_pb_mgr.v_cz_ps_nodes_new_tbl.DELETE;
222: cz_pb_mgr.v_cz_ps_nodes_old_tbl.DELETE;
223: cz_pb_mgr.v_cz_ps_nodes_idx_tbl.DELETE;
224: cz_pb_mgr.v_ps_parent_id_tbl.DELETE;
225: cz_pb_mgr.v_ps_refid_old_tbl.DELETE;
226: cz_pb_mgr.v_devl_project_tbl.DELETE;
219: IF (p_table_type = 'tbl')
220: THEN
221: cz_pb_mgr.v_cz_ps_nodes_new_tbl.DELETE;
222: cz_pb_mgr.v_cz_ps_nodes_old_tbl.DELETE;
223: cz_pb_mgr.v_cz_ps_nodes_idx_tbl.DELETE;
224: cz_pb_mgr.v_ps_parent_id_tbl.DELETE;
225: cz_pb_mgr.v_ps_refid_old_tbl.DELETE;
226: cz_pb_mgr.v_devl_project_tbl.DELETE;
227: cz_pb_mgr.v_ps_eff_set_id_tbl.DELETE;
232: cz_pb_mgr.v_ps_comp_seq_id_tbl.DELETE;
233: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
234: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
235: cz_pb_mgr.v_ps_capt_rule_tbl.DELETE;
236: cz_pb_mgr.v_cz_ps_nodes_comp_tbl.DELETE;
237: cz_pb_mgr.v_ps_item_id_tbl.DELETE;
238: cz_pb_mgr.v_ps_type_old_tbl.DELETE;
239: cz_pb_mgr.g_ps_uits_add_tbl.DELETE;
240: cz_pb_mgr.g_usg_name_processed.DELETE;
239: cz_pb_mgr.g_ps_uits_add_tbl.DELETE;
240: cz_pb_mgr.g_usg_name_processed.DELETE;
241: ELSIF(p_table_type = 'ref')
242: THEN
243: cz_pb_mgr.v_cz_ps_nodes_new_ref.DELETE;
244: cz_pb_mgr.v_cz_ps_nodes_old_ref.DELETE;
245: cz_pb_mgr.v_ps_parent_id_ref.DELETE;
246: cz_pb_mgr.v_ps_ref_id_ref.DELETE;
247: cz_pb_mgr.v_ps_eff_set_id_ref.DELETE;
240: cz_pb_mgr.g_usg_name_processed.DELETE;
241: ELSIF(p_table_type = 'ref')
242: THEN
243: cz_pb_mgr.v_cz_ps_nodes_new_ref.DELETE;
244: cz_pb_mgr.v_cz_ps_nodes_old_ref.DELETE;
245: cz_pb_mgr.v_ps_parent_id_ref.DELETE;
246: cz_pb_mgr.v_ps_ref_id_ref.DELETE;
247: cz_pb_mgr.v_ps_eff_set_id_ref.DELETE;
248: cz_pb_mgr.v_ps_intl_old_ref.DELETE;
250: cz_pb_mgr.v_ps_orig_sys_ref.DELETE;
251: cz_pb_mgr.v_ps_comp_seq_path_ref.DELETE;
252: cz_pb_mgr.v_ps_comp_seq_id_ref.DELETE;
253: cz_pb_mgr.v_ps_capt_rule_ref.DELETE;
254: cz_pb_mgr.v_cz_ps_nodes_comp_ref.DELETE;
255: cz_pb_mgr.v_ps_item_id_ref.DELETE;
256: cz_pb_mgr.v_ps_type_old_ref.DELETE;
257: END IF;
258: ELSIF(p_table_name = 'cz_model_ref_expls')
2436: END IF;
2437: END LOOP;
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)
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');
5696: resolve_ids(cz_pb_mgr.g_ui_actns_ren_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'render condition id of ui actions');
5697:
5698: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
5699: resolve_tmpl_ui_defs(cz_pb_mgr.g_uiact_prcpg_tmpui_tbl, cz_pb_mgr.g_uiact_prcpg_templ_tbl, 'prc pg tmp uidef of ui actions');
6466: THEN
6467: v_database_link := NULL;
6468: END IF;
6469:
6470: delete_from_table('cz_ps_nodes', 'ps_node_id', v_database_link, 'cz_pb_mgr.v_cz_ps_nodes_new_tbl', cz_pb_mgr.v_cz_ps_nodes_new_tbl);
6471: delete_from_table('cz_ps_prop_vals', 'ps_node_id', v_database_link, 'cz_pb_mgr.v_cz_ps_nodes_new_tbl', cz_pb_mgr.v_cz_ps_nodes_new_tbl);
6472: delete_from_table('cz_devl_projects'
6473: ,'devl_project_id'
6474: ,v_database_link
6467: v_database_link := NULL;
6468: END IF;
6469:
6470: delete_from_table('cz_ps_nodes', 'ps_node_id', v_database_link, 'cz_pb_mgr.v_cz_ps_nodes_new_tbl', cz_pb_mgr.v_cz_ps_nodes_new_tbl);
6471: delete_from_table('cz_ps_prop_vals', 'ps_node_id', v_database_link, 'cz_pb_mgr.v_cz_ps_nodes_new_tbl', cz_pb_mgr.v_cz_ps_nodes_new_tbl);
6472: delete_from_table('cz_devl_projects'
6473: ,'devl_project_id'
6474: ,v_database_link
6475: ,'cz_pb_mgr.v_models_to_be_exported_new'
7748: PROCEDURE get_psnode_last_date(p_model_id IN NUMBER, x_last_update_date OUT NOCOPY DATE) AS
7749: BEGIN
7750: SELECT MAX(last_update_date)
7751: INTO x_last_update_date
7752: FROM cz_ps_nodes
7753: WHERE devl_project_id = p_model_id;
7754: EXCEPTION
7755: WHEN OTHERS THEN
7756: x_last_update_date := cz_utils.epoch_begin;
7875: INTO x_last_update_date
7876: FROM cz_effectivity_sets
7877: WHERE cz_effectivity_sets.effectivity_set_id IN(
7878: SELECT DISTINCT effectivity_set_id
7879: FROM cz_ps_nodes
7880: WHERE cz_ps_nodes.devl_project_id = p_model_id
7881: AND cz_ps_nodes.deleted_flag = record_not_deleted
7882: AND cz_ps_nodes.effectivity_set_id IS NOT NULL);
7883: EXCEPTION
7876: FROM cz_effectivity_sets
7877: WHERE cz_effectivity_sets.effectivity_set_id IN(
7878: SELECT DISTINCT effectivity_set_id
7879: FROM cz_ps_nodes
7880: WHERE cz_ps_nodes.devl_project_id = p_model_id
7881: AND cz_ps_nodes.deleted_flag = record_not_deleted
7882: AND cz_ps_nodes.effectivity_set_id IS NOT NULL);
7883: EXCEPTION
7884: WHEN NO_DATA_FOUND
7877: WHERE cz_effectivity_sets.effectivity_set_id IN(
7878: SELECT DISTINCT effectivity_set_id
7879: FROM cz_ps_nodes
7880: WHERE cz_ps_nodes.devl_project_id = p_model_id
7881: AND cz_ps_nodes.deleted_flag = record_not_deleted
7882: AND cz_ps_nodes.effectivity_set_id IS NOT NULL);
7883: EXCEPTION
7884: WHEN NO_DATA_FOUND
7885: THEN
7878: SELECT DISTINCT effectivity_set_id
7879: FROM cz_ps_nodes
7880: WHERE cz_ps_nodes.devl_project_id = p_model_id
7881: AND cz_ps_nodes.deleted_flag = record_not_deleted
7882: AND cz_ps_nodes.effectivity_set_id IS NOT NULL);
7883: EXCEPTION
7884: WHEN NO_DATA_FOUND
7885: THEN
7886: x_last_update_date := cz_utils.epoch_begin;
9040: )
9041: AS
9042: BEGIN
9043: IF ((x_status <> PUBLICATION_ERROR) AND (cz_pb_mgr.v_session_parameter <> model_copy)) THEN
9044: IF cz_pb_mgr.v_cz_ps_nodes_idx_tbl.EXISTS(p_model_id) THEN
9045: x_remote_model_id := cz_pb_mgr.v_cz_ps_nodes_idx_tbl(p_model_id);
9046: ELSE
9047: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model THEN
9048: IF p_server_id=0 THEN
9041: AS
9042: BEGIN
9043: IF ((x_status <> PUBLICATION_ERROR) AND (cz_pb_mgr.v_session_parameter <> model_copy)) THEN
9044: IF cz_pb_mgr.v_cz_ps_nodes_idx_tbl.EXISTS(p_model_id) THEN
9045: x_remote_model_id := cz_pb_mgr.v_cz_ps_nodes_idx_tbl(p_model_id);
9046: ELSE
9047: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model THEN
9048: IF p_server_id=0 THEN
9049: SELECT remote_model_id INTO x_remote_model_id
9102: AND cz_pb_model_exports.model_id = p_model_id
9103: AND cz_pb_model_exports.status = 'OK';
9104: END IF;
9105:
9106: cz_pb_mgr.v_cz_ps_nodes_idx_tbl(p_model_id) := x_remote_model_id;
9107: END IF;
9108:
9109: ELSE
9110: x_remote_model_id := p_model_id;
9752: SELECT source_server
9753: INTO v_source_server
9754: FROM cz_xfr_project_bills
9755: WHERE model_ps_node_id = (SELECT devl_project_id
9756: FROM cz_ps_nodes
9757: WHERE cz_ps_nodes.ps_node_id = v_bom_ps_node_id AND cz_ps_nodes.deleted_flag = '0');
9758:
9759: ------if the server from where it was imported is different from the target
9760: ------to which it is being published then call the bom sync procedure
9753: INTO v_source_server
9754: FROM cz_xfr_project_bills
9755: WHERE model_ps_node_id = (SELECT devl_project_id
9756: FROM cz_ps_nodes
9757: WHERE cz_ps_nodes.ps_node_id = v_bom_ps_node_id AND cz_ps_nodes.deleted_flag = '0');
9758:
9759: ------if the server from where it was imported is different from the target
9760: ------to which it is being published then call the bom sync procedure
9761: ------else no sync required
10181:
10182: IF (cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT > 0)
10183: THEN
10184: ------resolve component ids of cz lce headers
10185: resolve_ids(cz_pb_mgr.v_cz_lce_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component ids of lce headers');
10186: -------resolve model ref expl id
10187: resolve_ids(cz_pb_mgr.v_cz_lce_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of lce headers');
10188: -------resolve model ref expl id
10189: resolve_ids(cz_pb_mgr.v_cz_lce_devl_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl proj id of lce headers');
10185: resolve_ids(cz_pb_mgr.v_cz_lce_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component ids of lce headers');
10186: -------resolve model ref expl id
10187: resolve_ids(cz_pb_mgr.v_cz_lce_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of lce headers');
10188: -------resolve model ref expl id
10189: resolve_ids(cz_pb_mgr.v_cz_lce_devl_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl proj id of lce headers');
10190: ------------insert into cz lce headers
10191: plsql_table_list.DELETE;
10192: rec_count := 1;
10193: plsql_table_list(rec_count).col_name := 'lce_header_id';
10262: resolve_ids(cz_pb_mgr.v_specs_lce_header_id_ref, cz_pb_mgr.v_cz_lce_headers_idx_ref, 'lce_header_id of cz_lce_load_specs');
10263: --------resolve required expl id
10264: resolve_ids(cz_pb_mgr.v_specs_required_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'required expl id of cz_lce_load_specs');
10265: --------resolve attachment comp id
10266: resolve_ids(cz_pb_mgr.v_specs_attach_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'attachment comp id of cz_lce_load_specs');
10267: --------resolve model id
10268: resolve_ids(cz_pb_mgr.v_specs_model_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz_lce_load_specs');
10269: insert_lce_load_specs(cz_pb_mgr.v_specs_attach_expl_id_ref
10270: ,cz_pb_mgr.v_specs_lce_header_id_ref
10264: resolve_ids(cz_pb_mgr.v_specs_required_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'required expl id of cz_lce_load_specs');
10265: --------resolve attachment comp id
10266: resolve_ids(cz_pb_mgr.v_specs_attach_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'attachment comp id of cz_lce_load_specs');
10267: --------resolve model id
10268: resolve_ids(cz_pb_mgr.v_specs_model_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz_lce_load_specs');
10269: insert_lce_load_specs(cz_pb_mgr.v_specs_attach_expl_id_ref
10270: ,cz_pb_mgr.v_specs_lce_header_id_ref
10271: ,cz_pb_mgr.v_specs_required_expl_id_ref
10272: ,cz_pb_mgr.v_specs_attach_comp_id_ref
10601: -----there could be many projects with the same persistent_node_id
10602: -----So we need persistent_node_id and its associated project for resolving child_model_expl_id
10603: -----of model ref expls.
10604: PROCEDURE get_pers_prj_id(
10605: p_ref_node IN cz_ps_nodes.ps_node_id%TYPE
10606: ,x_pers_node_id OUT NOCOPY cz_ps_nodes.ps_node_id%TYPE
10607: ,x_prj_id OUT NOCOPY cz_ps_nodes.devl_project_id%TYPE
10608: )
10609: IS
10602: -----So we need persistent_node_id and its associated project for resolving child_model_expl_id
10603: -----of model ref expls.
10604: PROCEDURE get_pers_prj_id(
10605: p_ref_node IN cz_ps_nodes.ps_node_id%TYPE
10606: ,x_pers_node_id OUT NOCOPY cz_ps_nodes.ps_node_id%TYPE
10607: ,x_prj_id OUT NOCOPY cz_ps_nodes.devl_project_id%TYPE
10608: )
10609: IS
10610: BEGIN
10603: -----of model ref expls.
10604: PROCEDURE get_pers_prj_id(
10605: p_ref_node IN cz_ps_nodes.ps_node_id%TYPE
10606: ,x_pers_node_id OUT NOCOPY cz_ps_nodes.ps_node_id%TYPE
10607: ,x_prj_id OUT NOCOPY cz_ps_nodes.devl_project_id%TYPE
10608: )
10609: IS
10610: BEGIN
10611: SELECT persistent_node_id, devl_project_id
10609: IS
10610: BEGIN
10611: SELECT persistent_node_id, devl_project_id
10612: INTO x_pers_node_id, x_prj_id
10613: FROM cz_ps_nodes t
10614: WHERE t.ps_node_id = p_ref_node AND t.deleted_flag = '0';
10615: EXCEPTION
10616: WHEN OTHERS
10617: THEN
10614: WHERE t.ps_node_id = p_ref_node AND t.deleted_flag = '0';
10615: EXCEPTION
10616: WHEN OTHERS
10617: THEN
10618: cz_pb_mgr.v_err_message := 'Error in retrieving persistent_node_id from cz ps nodes for ps node id: ' || p_ref_node;
10619: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.get_pers_prj_id', SQLCODE);
10620: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10621: RAISE;
10622: END;
10623:
10624: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
10625: -------procedure retrieves the project id of a ps node
10626: PROCEDURE get_devl_project_id(
10627: p_ps_node_id IN cz_ps_nodes.ps_node_id%TYPE
10628: ,x_devl_project_id IN OUT NOCOPY cz_ps_nodes.devl_project_id%TYPE
10629: ,x_status IN OUT NOCOPY VARCHAR2
10630: )
10631: AS
10624: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
10625: -------procedure retrieves the project id of a ps node
10626: PROCEDURE get_devl_project_id(
10627: p_ps_node_id IN cz_ps_nodes.ps_node_id%TYPE
10628: ,x_devl_project_id IN OUT NOCOPY cz_ps_nodes.devl_project_id%TYPE
10629: ,x_status IN OUT NOCOPY VARCHAR2
10630: )
10631: AS
10632: BEGIN
10633: IF (x_status <> PUBLICATION_ERROR)
10634: THEN
10635: SELECT devl_project_id
10636: INTO x_devl_project_id
10637: FROM cz_ps_nodes
10638: WHERE cz_ps_nodes.ps_node_id = p_ps_node_id AND cz_ps_nodes.deleted_flag = '0';
10639: END IF;
10640: EXCEPTION
10641: WHEN OTHERS
10634: THEN
10635: SELECT devl_project_id
10636: INTO x_devl_project_id
10637: FROM cz_ps_nodes
10638: WHERE cz_ps_nodes.ps_node_id = p_ps_node_id AND cz_ps_nodes.deleted_flag = '0';
10639: END IF;
10640: EXCEPTION
10641: WHEN OTHERS
10642: THEN
10639: END IF;
10640: EXCEPTION
10641: WHEN OTHERS
10642: THEN
10643: cz_pb_mgr.v_err_message := 'Error in retrieving devl proj id from cz ps nodes for ps node id: ' || p_ps_node_id || ' : ' || SQLERRM;
10644: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.GETDEVLPROJID', SQLCODE);
10645: x_status := PUBLICATION_ERROR;
10646: RAISE;
10647: END;
10648:
10649: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
10650: -------procedure that retrieves persistent node id
10651: PROCEDURE get_persistent_node_id(
10652: p_ps_node_id IN cz_ps_nodes.ps_node_id%TYPE
10653: ,x_persistent_id IN OUT NOCOPY cz_ps_nodes.persistent_node_id%TYPE
10654: ,x_status IN OUT NOCOPY VARCHAR2
10655: )
10656: AS
10649: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
10650: -------procedure that retrieves persistent node id
10651: PROCEDURE get_persistent_node_id(
10652: p_ps_node_id IN cz_ps_nodes.ps_node_id%TYPE
10653: ,x_persistent_id IN OUT NOCOPY cz_ps_nodes.persistent_node_id%TYPE
10654: ,x_status IN OUT NOCOPY VARCHAR2
10655: )
10656: AS
10657: BEGIN
10658: IF (x_status <> PUBLICATION_ERROR)
10659: THEN
10660: SELECT persistent_node_id
10661: INTO x_persistent_id
10662: FROM cz_ps_nodes t
10663: WHERE t.ps_node_id = p_ps_node_id AND t.deleted_flag = '0';
10664: END IF;
10665: EXCEPTION
10666: WHEN OTHERS
10664: END IF;
10665: EXCEPTION
10666: WHEN OTHERS
10667: THEN
10668: cz_pb_mgr.v_err_message := 'Error in retrieving persistent_node_id from cz ps nodes for ps node id: ' || p_ps_node_id;
10669: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.GETDEVLPROJID', SQLCODE);
10670: x_status := PUBLICATION_ERROR;
10671: RAISE;
10672: END;
10719: child_ref_id_cv ref_cursor;
10720: v_ref_project cz_devl_projects.devl_project_id%TYPE;
10721: v_ref_remote_model cz_devl_projects.devl_project_id%TYPE;
10722: v_child_expl_id cz_model_ref_expls.model_ref_expl_id%TYPE;
10723: v_persistent_node_id cz_ps_nodes.persistent_node_id%TYPE;
10724: v_source_child_model cz_model_ref_expls.model_id%TYPE;
10725: v_child_ref_node cz_ps_nodes.ps_node_id%TYPE;
10726: v_ref_model_id cz_model_ref_expls.model_id%TYPE;
10727: BEGIN
10721: v_ref_remote_model cz_devl_projects.devl_project_id%TYPE;
10722: v_child_expl_id cz_model_ref_expls.model_ref_expl_id%TYPE;
10723: v_persistent_node_id cz_ps_nodes.persistent_node_id%TYPE;
10724: v_source_child_model cz_model_ref_expls.model_id%TYPE;
10725: v_child_ref_node cz_ps_nodes.ps_node_id%TYPE;
10726: v_ref_model_id cz_model_ref_expls.model_id%TYPE;
10727: BEGIN
10728: IF (x_status <> PUBLICATION_ERROR)
10729: THEN
10802: CLOSE child_ref_id_cv;
10803:
10804: get_persistent_node_id(p_resolved_key_array(i), v_persistent_node_id, cz_pb_mgr.v_status_code);
10805:
10806: OPEN child_ref_id_cv FOR 'SELECT ps_node_id FROM cz_ps_nodes'
10807: || cz_pb_mgr.v_db_link
10808: || ' t'
10809: || ' '
10810: || 'WHERE t.persistent_node_id = '
10845:
10846: BEGIN
10847: OPEN child_ref_id_cv FOR 'SELECT ps_node_id'
10848: || ' '
10849: || 'FROM cz_ps_nodes'
10850: || cz_pb_mgr.v_db_link
10851: || ' t'
10852: || ' '
10853: || 'WHERE t.persistent_node_id = '
11021: RAISE;
11022: END;
11023:
11024: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11025: ------update reference ids of cz ps nodes of the remote model
11026: ------@p_models_exported -- root model and all its children
11027: ------@x_status --- publication status
11028: ------@p_server_id --- server local is of the target instance
11029: ------@p_new_ps_node_array --- ps node array that contains new values
11049: LOOP
11050: IF (cz_pb_mgr.v_ps_refid_old_tbl(j) IS NOT NULL)
11051: THEN
11052: get_remote_model_id(p_server_id, p_models_not_exported(i), x_status, l_remote_mode_id);
11053: l_sql_string := 'UPDATE cz_ps_nodes'
11054: || cz_pb_mgr.v_db_link
11055: || ' SET reference_id=:1,component_id=:2'
11056: || ' WHERE deleted_flag=:3 AND ps_node_id=:4 AND reference_id=:5';
11057: EXECUTE IMMEDIATE l_sql_string
11066: END IF;
11067: EXCEPTION
11068: WHEN OTHERS
11069: THEN
11070: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REF_ID_ERR', 'TABLENAME', 'cz_ps_nodes', 'SQLERRM', SQLERRM);
11071: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
11072: x_status := PUBLICATION_ERROR;
11073: RAISE;
11074: END;
11094: v_vir_remote_model_id NUMBER := 0.0;
11095: v_vir_devl_id NUMBER := 0.0;
11096: v_remote_comp_id NUMBER := 0.0;
11097: v_child_expl_id NUMBER := 0.0;
11098: v_vir_persistent_id cz_ps_nodes.persistent_node_id%TYPE;
11099: v_errored_model_id cz_devl_projects.devl_project_id%TYPE;
11100: BEGIN
11101: IF (x_status <> PUBLICATION_ERROR)
11102: THEN
11152: LOOP
11153: BEGIN
11154: SELECT devl_project_id, persistent_node_id
11155: INTO v_vir_devl_id, v_vir_persistent_id
11156: FROM cz_ps_nodes
11157: WHERE ps_node_id = v_vrt_comp_id_ref(i);
11158: EXCEPTION
11159: WHEN OTHERS
11160: THEN
11173:
11174: IF (v_vir_remote_model_id > 0)
11175: THEN
11176: BEGIN
11177: OPEN virt_ref_id_cv FOR 'SELECT ps_node_id FROM cz_ps_nodes'
11178: || cz_pb_mgr.v_db_link
11179: || ' t'
11180: || ' '
11181: || 'WHERE t.devl_project_id = '
11599: v_rem_ps_nodes_ref cz_pb_mgr.t_ref;
11600: v_rem_pers_nodes_ref cz_pb_mgr.t_ref;
11601: v_src_ps_nodes_ref cz_pb_mgr.t_ref;
11602: remote_node_cv ref_cursor;
11603: v_remote_ps_node_id cz_ps_nodes.ps_node_id%TYPE;
11604: v_remote_pers_node_id cz_ps_nodes.persistent_node_id%TYPE;
11605: l_remote_model_id NUMBER;
11606: BEGIN
11607: IF (x_status <> PUBLICATION_ERROR) THEN
11600: v_rem_pers_nodes_ref cz_pb_mgr.t_ref;
11601: v_src_ps_nodes_ref cz_pb_mgr.t_ref;
11602: remote_node_cv ref_cursor;
11603: v_remote_ps_node_id cz_ps_nodes.ps_node_id%TYPE;
11604: v_remote_pers_node_id cz_ps_nodes.persistent_node_id%TYPE;
11605: l_remote_model_id NUMBER;
11606: BEGIN
11607: IF (x_status <> PUBLICATION_ERROR) THEN
11608: IF (p_model_not_exported_array.COUNT > 0) THEN
11623:
11624: IF (v_remote_models_tbl(k) > 0) THEN
11625: OPEN remote_node_cv FOR 'SELECT ps_node_id,persistent_node_id'
11626: || ' '
11627: || 'FROM cz_ps_nodes'
11628: || cz_pb_mgr.v_db_link
11629: || ' t'
11630: || ' '
11631: || 'WHERE t.devl_project_id = '
11643: v_rem_pers_nodes_ref(remote_ps_count) := v_remote_pers_node_id;
11644:
11645: SELECT ps_node_id
11646: INTO v_src_ps_nodes_ref(remote_ps_count)
11647: FROM cz_ps_nodes
11648: WHERE cz_ps_nodes.devl_project_id = p_model_not_exported_array(k)
11649: AND cz_ps_nodes.persistent_node_id = v_remote_pers_node_id
11650: AND cz_ps_nodes.deleted_flag = record_not_deleted;
11651: END LOOP;
11644:
11645: SELECT ps_node_id
11646: INTO v_src_ps_nodes_ref(remote_ps_count)
11647: FROM cz_ps_nodes
11648: WHERE cz_ps_nodes.devl_project_id = p_model_not_exported_array(k)
11649: AND cz_ps_nodes.persistent_node_id = v_remote_pers_node_id
11650: AND cz_ps_nodes.deleted_flag = record_not_deleted;
11651: END LOOP;
11652:
11645: SELECT ps_node_id
11646: INTO v_src_ps_nodes_ref(remote_ps_count)
11647: FROM cz_ps_nodes
11648: WHERE cz_ps_nodes.devl_project_id = p_model_not_exported_array(k)
11649: AND cz_ps_nodes.persistent_node_id = v_remote_pers_node_id
11650: AND cz_ps_nodes.deleted_flag = record_not_deleted;
11651: END LOOP;
11652:
11653: CLOSE remote_node_cv;
11646: INTO v_src_ps_nodes_ref(remote_ps_count)
11647: FROM cz_ps_nodes
11648: WHERE cz_ps_nodes.devl_project_id = p_model_not_exported_array(k)
11649: AND cz_ps_nodes.persistent_node_id = v_remote_pers_node_id
11650: AND cz_ps_nodes.deleted_flag = record_not_deleted;
11651: END LOOP;
11652:
11653: CLOSE remote_node_cv;
11654: END IF; /* end if of (v_remote_models_tbl(k) > 0) */
11657: IF (v_rem_ps_nodes_ref.COUNT > 0)
11658: THEN
11659: FOR m IN v_rem_ps_nodes_ref.FIRST .. v_rem_ps_nodes_ref.LAST
11660: LOOP
11661: cz_pb_mgr.v_cz_ps_nodes_idx_tbl(v_src_ps_nodes_ref(m)):=v_rem_ps_nodes_ref(m);
11662: END LOOP;
11663: END IF; /* end if of (v_rem_ps_nodes_ref.COUNT > 0) */
11664: END IF; /* end if of (p_model_not_exported_array.COUNT > 0) */
11665: END IF; /* end if of x_status <> PUBLICATION_ERROR */
12201: ----procedure that clears all global pl/sql tables
12202: PROCEDURE clear_all_tables(x_status IN OUT NOCOPY VARCHAR2)
12203: AS
12204: BEGIN
12205: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
12206: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
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);
12202: PROCEDURE clear_all_tables(x_status IN OUT NOCOPY VARCHAR2)
12203: AS
12204: BEGIN
12205: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
12206: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
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);
13484: THEN
13485: log_timing_message('end eff sets of ps nodes');
13486: END IF;
13487:
13488: -------------insert intl texts for cz_ps_nodes
13489: IF (cz_pb_mgr.g_log_timing = publication_timing)
13490: THEN
13491: log_timing_message('start insert_intl_texts Intl Text of ps nodes');
13492: END IF;
13548: THEN
13549: log_timing_message('end resolve resolve caption rule ids in ps nodes');
13550: END IF;
13551:
13552: ------------Resolving ps_ref_id of cz ps nodes
13553: IF (cz_pb_mgr.g_log_timing = publication_timing)
13554: THEN
13555: log_timing_message('start resolve_ids ps_ref_id of cz ps nodes');
13556: END IF;
13551:
13552: ------------Resolving ps_ref_id of cz ps nodes
13553: IF (cz_pb_mgr.g_log_timing = publication_timing)
13554: THEN
13555: log_timing_message('start resolve_ids ps_ref_id of cz ps nodes');
13556: END IF;
13557:
13558: -- non-exported psnodes actually loaded and put into the map too, so it would be better to load them early too
13559: -- then no special treatment needed for reference_id, component_id, etc
13556: END IF;
13557:
13558: -- non-exported psnodes actually loaded and put into the map too, so it would be better to load them early too
13559: -- then no special treatment needed for reference_id, component_id, etc
13560: resolve_ids(cz_pb_mgr.v_ps_refid_old_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'reference_id of cz ps nodes', FLD_PSN_REFERENCE_ID);
13561:
13562: IF (cz_pb_mgr.g_log_timing = publication_timing)
13563: THEN
13564: log_timing_message('end resolve_ids ps_ref_id of cz ps nodes');
13560: resolve_ids(cz_pb_mgr.v_ps_refid_old_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'reference_id of cz ps nodes', FLD_PSN_REFERENCE_ID);
13561:
13562: IF (cz_pb_mgr.g_log_timing = publication_timing)
13563: THEN
13564: log_timing_message('end resolve_ids ps_ref_id of cz ps nodes');
13565: END IF;
13566:
13567: ------------Resolving component -ids of ps_nodes
13568: resolve_ids(cz_pb_mgr.v_cz_ps_nodes_comp_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz ps nodes', FLD_PSN_REFERENCE_ID);
13564: log_timing_message('end resolve_ids ps_ref_id of cz ps nodes');
13565: END IF;
13566:
13567: ------------Resolving component -ids of ps_nodes
13568: resolve_ids(cz_pb_mgr.v_cz_ps_nodes_comp_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz ps nodes', FLD_PSN_REFERENCE_ID);
13569:
13570: -- resolve effective usage mask for ps nodes.
13571: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
13572: THEN
13569:
13570: -- resolve effective usage mask for ps nodes.
13571: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
13572: THEN
13573: resolve_effective_usage_mask(cz_pb_mgr.v_cz_ps_nodes_old_tbl, 0);
13574: END IF;
13575:
13576: -- to verify: the model referred by reverse connector id would always be reexported regardless of having any
13577: -- change or not, if the model having the reverse connector is exported?
13575:
13576: -- to verify: the model referred by reverse connector id would always be reexported regardless of having any
13577: -- change or not, if the model having the reverse connector is exported?
13578: -- otherwise, we need to implement resolver_ref_ids_not_found for this column and call that instead
13579: resolve_ids(cz_pb_mgr.g_ps_reverse_connector_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'psn reverse_connector_id');
13580:
13581: plsql_table_list.DELETE;
13582: rec_count := 1;
13583: plsql_table_list(rec_count).col_name := 'ps_node_id';
13580:
13581: plsql_table_list.DELETE;
13582: rec_count := 1;
13583: plsql_table_list(rec_count).col_name := 'ps_node_id';
13584: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ps_nodes_new_tbl';
13585: rec_count := rec_count + 1;
13586: plsql_table_list(rec_count).col_name := 'devl_project_id';
13587: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_devl_project_tbl';
13588: rec_count := rec_count + 1;
13612: rec_count := rec_count + 1;
13613: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ps_capt_rule_tbl';
13614: plsql_table_list(rec_count).col_name := 'displayname_capt_rule_id';
13615: rec_count := rec_count + 1;
13616: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ps_nodes_comp_tbl';
13617: plsql_table_list(rec_count).col_name := 'component_id';
13618: rec_count := rec_count + 1;
13619: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ps_uits_add_tbl';
13620: plsql_table_list(rec_count).col_name := 'UI_TIMESTAMP_ADD';
13635: END IF;
13636:
13637: IF (cz_pb_mgr.g_log_timing = publication_timing)
13638: THEN
13639: log_timing_message('start insert_into_table of cz ps nodes');
13640: END IF;
13641:
13642: insert_into_table('cz_ps_nodes'
13643: ,'ps_node_id'
13638: THEN
13639: log_timing_message('start insert_into_table of cz ps nodes');
13640: END IF;
13641:
13642: insert_into_table('cz_ps_nodes'
13643: ,'ps_node_id'
13644: ,cz_pb_mgr.v_db_link
13645: ,plsql_table_list
13646: ,'cz_pb_mgr.v_cz_ps_nodes_old_tbl'
13642: insert_into_table('cz_ps_nodes'
13643: ,'ps_node_id'
13644: ,cz_pb_mgr.v_db_link
13645: ,plsql_table_list
13646: ,'cz_pb_mgr.v_cz_ps_nodes_old_tbl'
13647: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
13648: );
13649:
13650: IF (cz_pb_mgr.g_log_timing = publication_timing)
13643: ,'ps_node_id'
13644: ,cz_pb_mgr.v_db_link
13645: ,plsql_table_list
13646: ,'cz_pb_mgr.v_cz_ps_nodes_old_tbl'
13647: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
13648: );
13649:
13650: IF (cz_pb_mgr.g_log_timing = publication_timing)
13651: THEN
13648: );
13649:
13650: IF (cz_pb_mgr.g_log_timing = publication_timing)
13651: THEN
13652: log_timing_message('end insert_into_table of cz ps nodes');
13653: END IF;
13654:
13655: -----------update reference id of cz_ps_nodes of the target server for the models not exported
13656: IF (cz_pb_mgr.g_log_timing = publication_timing)
13651: THEN
13652: log_timing_message('end insert_into_table of cz ps nodes');
13653: END IF;
13654:
13655: -----------update reference id of cz_ps_nodes of the target server for the models not exported
13656: IF (cz_pb_mgr.g_log_timing = publication_timing)
13657: THEN
13658: log_timing_message('start update_remote_reference_ids');
13659: END IF;
13658: log_timing_message('start update_remote_reference_ids');
13659: END IF;
13660:
13661: update_remote_reference_ids(cz_pb_mgr.v_models_not_to_be_exported
13662: ,cz_pb_mgr.v_cz_ps_nodes_new_tbl
13663: ,cz_pb_mgr.v_server_id
13664: ,cz_pb_mgr.v_status_code
13665: );
13666:
13749: THEN
13750: log_timing_message('start resolve_ids model id of cz_model_ref_expls');
13751: END IF;
13752:
13753: resolve_ids(cz_pb_mgr.v_ref_model_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz_model_ref_expls');
13754:
13755: IF (cz_pb_mgr.g_log_timing = publication_timing)
13756: THEN
13757: log_timing_message('end resolve_ids model id of cz_model_ref_expls');
13763: log_timing_message('start resolve_ref_ids_not_found cz_model_ref_expl.referring_node_id');
13764: END IF;
13765:
13766: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
13767: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
13768: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
13769: ,cz_pb_mgr.v_referring_node_id_ref
13770: ,'cz_model_ref_expl.referring_node_id'
13771: ,cz_pb_mgr.v_status_code
13764: END IF;
13765:
13766: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
13767: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
13768: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
13769: ,cz_pb_mgr.v_referring_node_id_ref
13770: ,'cz_model_ref_expl.referring_node_id'
13771: ,cz_pb_mgr.v_status_code
13772: );
13801: log_timing_message('start resolve_ref_ids_not_found cz_model_ref_expl.component_id');
13802: END IF;
13803:
13804: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
13805: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
13806: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
13807: ,cz_pb_mgr.v_component_id_old_ref
13808: ,'cz_model_ref_expl.component_id'
13809: ,cz_pb_mgr.v_status_code
13802: END IF;
13803:
13804: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
13805: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
13806: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
13807: ,cz_pb_mgr.v_component_id_old_ref
13808: ,'cz_model_ref_expl.component_id'
13809: ,cz_pb_mgr.v_status_code
13810: );
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');
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');
14594: THEN
14595: log_timing_message('start resolve_ids ps node ids of ui nodes');
14596: END IF;
14597:
14598: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'ps node ids of ui nodes');
14599:
14600: IF (cz_pb_mgr.g_log_timing = publication_timing)
14601: THEN
14602: log_timing_message('end resolve_ids ps node ids of ui nodes');
14607: THEN
14608: log_timing_message('start resolve_ids component ids of ui nodes');
14609: END IF;
14610:
14611: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_component_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component ids of ui nodes');
14612:
14613: IF (cz_pb_mgr.g_log_timing = publication_timing)
14614: THEN
14615: log_timing_message('end resolve_ids component ids of ui nodes');
14776: log_timing_message('start resolve psnodes of prop vals');
14777: END IF;
14778:
14779: -----resolve psnodes of prop vals
14780: resolve_ids(cz_pb_mgr.v_prop_vals_node_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'ps node id of prop vals');
14781:
14782: IF (cz_pb_mgr.g_log_timing = publication_timing)
14783: THEN
14784: log_timing_message('end resolve psnodes of prop vals');
14937: END LOOP;
14938: END IF;
14939: END LOOP;
14940:
14941: resolve_ids(cz_pb_mgr.g_fcefile_compid_tbl,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'component id of fce files');
14942:
14943: l_plsql_table_list(1).col_name := 'FCE_FILE_ID';
14944: l_plsql_table_list(1).table_name := 'cz_pb_mgr.g_fcefile_new_id_tbl';
14945: l_plsql_table_list(2).col_name := 'COMPONENT_ID';
15000: END IF;
15001: resolve_ids(cz_pb_mgr.v_cz_rules_rf_id_ref, cz_pb_mgr.v_cz_folders_id_idx_ref, 'rule folder ids of cz rules');
15002:
15003: -------------Resolve devl_project_id of cz_rules
15004: resolve_ids(cz_pb_mgr.v_cz_rules_proj_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl_project_id of cz rules');
15005: -------------Resolve component_id of cz_rules
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
15002:
15003: -------------Resolve devl_project_id of cz_rules
15004: resolve_ids(cz_pb_mgr.v_cz_rules_proj_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl_project_id of cz rules');
15005: -------------Resolve component_id of cz_rules
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');
15264: BULK COLLECT INTO l_filter_sets_new_id_tbl
15265: ,l_filter_sets_id_tbl, l_filter_sets_devl_tbl, l_filter_sets_rule_tbl
15266: FROM cz_filter_sets
15267: WHERE cz_filter_sets.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_filter_sets.deleted_flag = '0'
15268: AND EXISTS (SELECT NULL FROM cz_populators pop, cz_ps_nodes psn
15269: WHERE pop.deleted_flag = '0' AND pop.filter_set_id = cz_filter_sets.filter_set_id
15270: AND pop.owned_by_node_id = psn.ps_node_id AND psn.deleted_flag = '0');
15271:
15272: EXCEPTION
15348: END IF;
15349: END LOOP;
15350:
15351: ------resolve devl id and rule id
15352: resolve_ids(cz_pb_mgr.v_filter_sets_devl_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'dev proj id of cz filter sets');
15353: ------resolve devl id
15354: resolve_ids(cz_pb_mgr.v_filter_sets_rule_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of cz filter sets');
15355: -----resolve ps node id
15356: resolve_ids(cz_pb_mgr.v_populators_node_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'owned by node id of cz populators');
15352: resolve_ids(cz_pb_mgr.v_filter_sets_devl_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'dev proj id of cz filter sets');
15353: ------resolve devl id
15354: resolve_ids(cz_pb_mgr.v_filter_sets_rule_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of cz filter sets');
15355: -----resolve ps node id
15356: resolve_ids(cz_pb_mgr.v_populators_node_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'owned by node id of cz populators');
15357: -----resolve filter set id
15358: resolve_ids(cz_pb_mgr.v_populators_set_id_ref, cz_pb_mgr.v_filter_sets_idx_ref, 'filter set id of cz populators');
15359: plsql_table_list.DELETE;
15360: rec_count := 1;
15396: EXECUTE IMMEDIATE
15397: 'BEGIN' || ' ' ||
15398: 'FOR i IN cz_pb_mgr.v_populators_node_ref.FIRST..cz_pb_mgr.v_populators_node_ref.LAST' || ' ' ||
15399: 'LOOP' || ' ' ||
15400: 'UPDATE cz_ps_nodes' || cz_pb_mgr.v_db_link || ' ' || 't' || ' ' ||
15401: 'SET t.from_populator_id = cz_pb_mgr.v_populators_new_id_ref(i) ' || ' ' ||
15402: 'WHERE t.devl_project_id = cz_pb_mgr.v_filter_sets_devl_ref(i) AND' || ' ' ||
15403: 't.from_populator_id=cz_pb_mgr.v_populators_id_ref(i) AND' || ' ' ||
15404: 't.deleted_flag=''0''; ' || ' ' ||
15472:
15473: BEGIN
15474: --------------populate ps nodes pl/sql table with ps node ids from remote server
15475: get_rem_nodes_of_models(cz_pb_mgr.v_models_not_to_be_exported
15476: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
15477: ,cz_pb_mgr.v_status_code
15478: );
15479: -------insert into cz_rule_folders
15480: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
15597: END IF; /* end if of cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
15598:
15599: -----resolve parent rule folder id and devl proj id
15600: resolve_ids(cz_pb_mgr.v_cz_folders_pf_id_ref, cz_pb_mgr.v_cz_folders_id_idx_ref, 'parent folder id of rule folders');
15601: resolve_ids(cz_pb_mgr.v_cz_folders_pj_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl proj id of rule folders');
15602: insert_eff_sets(cz_pb_mgr.v_cz_folders_eff_ref
15603: ,cz_pb_mgr.v_cz_eff_sets_old_tbl
15604: ,cz_pb_mgr.v_cz_eff_sets_new_tbl
15605: ,cz_pb_mgr.v_cz_eff_sets_idx_tbl
15661: THEN
15662: log_timing_message('start resolve_ids devl project id of cz_func_comp_specs');
15663: END IF;
15664:
15665: resolve_ids(cz_pb_mgr.v_cz_func_devl_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl project id of cz_func_comp_specs');
15666:
15667: IF (cz_pb_mgr.g_log_timing = publication_timing)
15668: THEN
15669: log_timing_message('end resolve_ids devl project id of cz_func_comp_specs');
15669: log_timing_message('end resolve_ids devl project id of cz_func_comp_specs');
15670: log_timing_message('start resolve_ids component id of cz_func_comp_specs');
15671: END IF;
15672:
15673: resolve_ids(cz_pb_mgr.v_cz_func_cid_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_func_comp_specs', FLD_RULE_COMPONENT_ID);
15674:
15675: IF (cz_pb_mgr.g_log_timing = publication_timing)
15676: THEN
15677: log_timing_message('end resolve_ids component id of cz_func_comp_specs');
15873: resolve_ids(cz_pb_mgr.v_cz_enodes_arg_sig_id_ref, cz_pb_mgr.v_sig_idx_ref, 'arg sig ids cz expr nodes', ENTITY_TYPE_SIGNATURE);
15874: resolve_ids(cz_pb_mgr.v_cz_enodes_par_sig_id_ref, cz_pb_mgr.v_sig_idx_ref, 'param sig ids cz expr nodes', ENTITY_TYPE_SIGNATURE);
15875:
15876: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
15877: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_psnode_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.ps_node_id');
15878: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.model_ref_expl_id');
15879: resolve_ids(cz_pb_mgr.v_cz_enodes_prop_id_ref, cz_pb_mgr.mm_v_ht_sync_all_prop, 'property id of cz expr nodes', ENTITY_TYPE_PROPERTY);
15880: ELSE
15881: resolve_ids(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of expression nodes',FLD_IGNORE_NOW);
15878: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.model_ref_expl_id');
15879: resolve_ids(cz_pb_mgr.v_cz_enodes_prop_id_ref, cz_pb_mgr.mm_v_ht_sync_all_prop, 'property id of cz expr nodes', ENTITY_TYPE_PROPERTY);
15880: ELSE
15881: resolve_ids(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of expression nodes',FLD_IGNORE_NOW);
15882: resolve_ids(cz_pb_mgr.v_cz_enodes_psnode_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'ps node ids of expression nodes',FLD_IGNORE_NOW);
15883: END IF;
15884:
15885: resolve_ids(cz_pb_mgr.v_cz_enodes_rule_id_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of expression nodes');
15886:
15980: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_models_to_be_exported */
15981: END IF; /* cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
15982:
15983: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
15984: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.feature_id');
15985: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.model_ref_expl_id');
15986: ELSE
15987: resolve_ids(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'feature id of cz_des_features',FLD_IGNORE_NOW);
15988: resolve_ids(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of cz_des_features',FLD_IGNORE_NOW);
15983: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
15984: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.feature_id');
15985: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.model_ref_expl_id');
15986: ELSE
15987: resolve_ids(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'feature id of cz_des_features',FLD_IGNORE_NOW);
15988: resolve_ids(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of cz_des_features',FLD_IGNORE_NOW);
15989: END IF;
15990:
15991: resolve_ids(cz_pb_mgr.v_cz_des_feature_rid_new_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of des chart features');
16051: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_models_to_be_exported */
16052: END IF; /* end if of cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
16053:
16054: resolve_ids(cz_pb_mgr.v_cz_des_cells_rule_id_new_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of des chart cells');
16055: resolve_ids(cz_pb_mgr.v_cz_des_cells_popt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'cz_des_chart_cells.primary_opt_id',FLD_IGNORE_NOW);
16056:
16057: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16058: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feature_id');
16059: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_opt_id');
16054: resolve_ids(cz_pb_mgr.v_cz_des_cells_rule_id_new_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of des chart cells');
16055: resolve_ids(cz_pb_mgr.v_cz_des_cells_popt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'cz_des_chart_cells.primary_opt_id',FLD_IGNORE_NOW);
16056:
16057: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16058: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feature_id');
16059: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_opt_id');
16060: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feat_expl_id');
16061: ELSE
16062: resolve_ids(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary feature id of cz_des_cells',FLD_IGNORE_NOW);
16055: resolve_ids(cz_pb_mgr.v_cz_des_cells_popt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'cz_des_chart_cells.primary_opt_id',FLD_IGNORE_NOW);
16056:
16057: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16058: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feature_id');
16059: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_opt_id');
16060: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feat_expl_id');
16061: ELSE
16062: resolve_ids(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary feature id of cz_des_cells',FLD_IGNORE_NOW);
16063: resolve_ids(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary opt id of cz_des_cells',FLD_IGNORE_NOW);
16058: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feature_id');
16059: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_opt_id');
16060: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feat_expl_id');
16061: ELSE
16062: resolve_ids(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary feature id of cz_des_cells',FLD_IGNORE_NOW);
16063: resolve_ids(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary opt id of cz_des_cells',FLD_IGNORE_NOW);
16064: resolve_ids(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'secondary feat expl id of cz_des_cells',FLD_IGNORE_NOW);
16065: END IF;
16066:
16059: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_opt_id');
16060: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feat_expl_id');
16061: ELSE
16062: resolve_ids(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary feature id of cz_des_cells',FLD_IGNORE_NOW);
16063: resolve_ids(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary opt id of cz_des_cells',FLD_IGNORE_NOW);
16064: resolve_ids(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'secondary feat expl id of cz_des_cells',FLD_IGNORE_NOW);
16065: END IF;
16066:
16067: ------insert new records into cz_des_chart_cells
16457: END IF;
16458: END IF;
16459: END LOOP;
16460: END IF; /* end if of cz_pb_mgr.v_item_masters_ref.COUNT > 0 */
16461: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_ps_nodes_old_tbl */
16462: END IF; /* end if of cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0 */
16463:
16464: IF (cz_pb_mgr.v_item_types_tbl.COUNT > 0)
16465: THEN
16458: END IF;
16459: END LOOP;
16460: END IF; /* end if of cz_pb_mgr.v_item_masters_ref.COUNT > 0 */
16461: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_ps_nodes_old_tbl */
16462: END IF; /* end if of cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0 */
16463:
16464: IF (cz_pb_mgr.v_item_types_tbl.COUNT > 0)
16465: THEN
16466: cz_pb_mgr.v_item_types_new_ref.DELETE;
16536: BEGIN
16537: SELECT property_id, data_type, name, src_application_id
16538: BULK COLLECT INTO v_remote_prop_tbl, v_prop_type_tbl, v_prop_name_tbl, v_prop_src_app_tbl
16539: FROM (SELECT itp.property_id, p.data_type, p.name, nvl(p.src_application_id, 0) AS src_application_id
16540: from cz_item_masters im, cz_item_type_properties itp, cz_ps_nodes psn, cz_properties p
16541: where psn.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) and psn.deleted_flag = '0'
16542: and psn.item_id = im.item_id AND im.deleted_flag = '0' and im.item_type_id = itp.item_type_id
16543: AND itp.deleted_flag = '0' and itp.property_id = p.property_id and p.deleted_flag = '0'
16544: UNION
16542: and psn.item_id = im.item_id AND im.deleted_flag = '0' and im.item_type_id = itp.item_type_id
16543: AND itp.deleted_flag = '0' and itp.property_id = p.property_id and p.deleted_flag = '0'
16544: UNION
16545: SELECT psp.property_id, p.data_type, p.name, nvl(p.src_application_id, 0) AS src_application_id
16546: from cz_ps_prop_vals psp, cz_ps_nodes psn, cz_properties p
16547: where psn.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) and psn.ps_node_id = psp.ps_node_id
16548: and psn.deleted_flag = '0' AND psp.deleted_Flag = '0' and psp.property_id = p.property_id
16549: and p.deleted_flag = '0'
16550: UNION
16548: and psn.deleted_flag = '0' AND psp.deleted_Flag = '0' and psp.property_id = p.property_id
16549: and p.deleted_flag = '0'
16550: UNION
16551: SELECT ipv.property_id, p.data_type, p.name, nvl(p.src_application_id, 0) AS src_application_id
16552: from cz_ps_nodes psn, cz_item_property_values ipv, cz_properties p
16553: where psn.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) and psn.item_id = ipv.item_id
16554: and psn.deleted_flag = '0' and ipv.deleted_flag = '0' and ipv.property_id = p.property_id
16555: and p.deleted_flag = '0');
16556:
16781:
16782: --upload_item_schema used to to happen after upload_ps_structure, upload_ui_schema
16783: --but model migration required this to happen earlier. Moving this did not seem to affect
16784: --publication.
16785: upload_item_schema(cz_pb_mgr.v_cz_ps_nodes_old_tbl, cz_pb_mgr.v_status_code);
16786:
16787: IF (cz_pb_mgr.g_log_timing = publication_timing)
16788: THEN
16789: log_timing_message('end upload_item_schema');
19232: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
19233: END;
19234:
19235: --Calculate the max_persistent_rec_id for the model and insert into CZ_PERSISTENT_REC_IDS.
19236: EXECUTE IMMEDIATE 'SELECT GREATEST(NVL((SELECT MAX(persistent_node_id) FROM cz_ps_nodes'
19237: || cz_pb_mgr.v_db_link
19238: || ' WHERE deleted_flag = ''0'' AND devl_project_id = :1), 0),'
19239: || ' NVL((SELECT MAX(persistent_rule_id) FROM cz_rules'
19240: || cz_pb_mgr.v_db_link
22251: PROCEDURE mm_loadoldpsnodesforitems
22252: AS
22253: v_project_count PLS_INTEGER;
22254: rec_count PLS_INTEGER;
22255: l_ps_uits_add_tbl date_tbl_type; -- cz_ps_nodes.UI_TIMESTAMP_ADD
22256: l_reverse_connector_tbl t_ref;
22257: BEGIN
22258: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
22259: cz_pb_mgr.sequence_const := 0;
22254: rec_count PLS_INTEGER;
22255: l_ps_uits_add_tbl date_tbl_type; -- cz_ps_nodes.UI_TIMESTAMP_ADD
22256: l_reverse_connector_tbl t_ref;
22257: BEGIN
22258: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
22259: cz_pb_mgr.sequence_const := 0;
22260:
22261: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
22262: THEN
22262: THEN
22263: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
22264: LOOP
22265: BEGIN
22266: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
22267: l_ps_uits_add_tbl.DELETE;
22268: l_reverse_connector_tbl.DELETE;
22269:
22270: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ps_nodes_seq
22266: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
22267: l_ps_uits_add_tbl.DELETE;
22268: l_reverse_connector_tbl.DELETE;
22269:
22270: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ps_nodes_seq
22271: , 'cz_ps_nodes_s.NEXTVAL' || cz_pb_mgr.v_db_link
22272: ,cz_pb_mgr.v_oraclesequenceincr
22273: )
22274: ,ps_node_id, parent_id, reference_id, effectivity_set_id
22267: l_ps_uits_add_tbl.DELETE;
22268: l_reverse_connector_tbl.DELETE;
22269:
22270: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ps_nodes_seq
22271: , 'cz_ps_nodes_s.NEXTVAL' || cz_pb_mgr.v_db_link
22272: ,cz_pb_mgr.v_oraclesequenceincr
22273: )
22274: ,ps_node_id, parent_id, reference_id, effectivity_set_id
22275: ,intl_text_id, violation_text_id, displayname_capt_rule_id, component_id
22277: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_origsysref(orig_sys_ref), 'N', orig_sys_ref)
22278: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqpath(component_sequence_path), 'N', component_sequence_path)
22279: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)
22280: ,NVL(ui_timestamp_add, creation_date), reverse_connector_id
22281: BULK COLLECT INTO cz_pb_mgr.v_cz_ps_nodes_new_ref
22282: ,cz_pb_mgr.v_cz_ps_nodes_old_ref, cz_pb_mgr.v_ps_parent_id_ref, cz_pb_mgr.v_ps_ref_id_ref, cz_pb_mgr.v_ps_eff_set_id_ref
22283: ,cz_pb_mgr.v_ps_intl_old_ref, cz_pb_mgr.v_ps_viol_old_ref, cz_pb_mgr.v_ps_capt_rule_ref, cz_pb_mgr.v_cz_ps_nodes_comp_ref
22284: ,cz_pb_mgr.v_cz_effective_usage_mask_ref, cz_pb_mgr.v_ps_item_id_ref, cz_pb_mgr.v_ps_type_old_ref
22285: ,cz_pb_mgr.v_ps_orig_sys_ref
22278: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqpath(component_sequence_path), 'N', component_sequence_path)
22279: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)
22280: ,NVL(ui_timestamp_add, creation_date), reverse_connector_id
22281: BULK COLLECT INTO cz_pb_mgr.v_cz_ps_nodes_new_ref
22282: ,cz_pb_mgr.v_cz_ps_nodes_old_ref, cz_pb_mgr.v_ps_parent_id_ref, cz_pb_mgr.v_ps_ref_id_ref, cz_pb_mgr.v_ps_eff_set_id_ref
22283: ,cz_pb_mgr.v_ps_intl_old_ref, cz_pb_mgr.v_ps_viol_old_ref, cz_pb_mgr.v_ps_capt_rule_ref, cz_pb_mgr.v_cz_ps_nodes_comp_ref
22284: ,cz_pb_mgr.v_cz_effective_usage_mask_ref, cz_pb_mgr.v_ps_item_id_ref, cz_pb_mgr.v_ps_type_old_ref
22285: ,cz_pb_mgr.v_ps_orig_sys_ref
22286: ,cz_pb_mgr.v_ps_comp_seq_path_ref
22279: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)
22280: ,NVL(ui_timestamp_add, creation_date), reverse_connector_id
22281: BULK COLLECT INTO cz_pb_mgr.v_cz_ps_nodes_new_ref
22282: ,cz_pb_mgr.v_cz_ps_nodes_old_ref, cz_pb_mgr.v_ps_parent_id_ref, cz_pb_mgr.v_ps_ref_id_ref, cz_pb_mgr.v_ps_eff_set_id_ref
22283: ,cz_pb_mgr.v_ps_intl_old_ref, cz_pb_mgr.v_ps_viol_old_ref, cz_pb_mgr.v_ps_capt_rule_ref, cz_pb_mgr.v_cz_ps_nodes_comp_ref
22284: ,cz_pb_mgr.v_cz_effective_usage_mask_ref, cz_pb_mgr.v_ps_item_id_ref, cz_pb_mgr.v_ps_type_old_ref
22285: ,cz_pb_mgr.v_ps_orig_sys_ref
22286: ,cz_pb_mgr.v_ps_comp_seq_path_ref
22287: ,cz_pb_mgr.v_ps_comp_seq_id_ref
22285: ,cz_pb_mgr.v_ps_orig_sys_ref
22286: ,cz_pb_mgr.v_ps_comp_seq_path_ref
22287: ,cz_pb_mgr.v_ps_comp_seq_id_ref
22288: ,l_ps_uits_add_tbl, l_reverse_connector_tbl
22289: FROM cz_ps_nodes
22290: WHERE cz_ps_nodes.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND deleted_flag = record_not_deleted;
22291: EXCEPTION
22292: WHEN OTHERS
22293: THEN
22286: ,cz_pb_mgr.v_ps_comp_seq_path_ref
22287: ,cz_pb_mgr.v_ps_comp_seq_id_ref
22288: ,l_ps_uits_add_tbl, l_reverse_connector_tbl
22289: FROM cz_ps_nodes
22290: WHERE cz_ps_nodes.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND deleted_flag = record_not_deleted;
22291: EXCEPTION
22292: WHEN OTHERS
22293: THEN
22294: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ps_nodes', 'SQLERRM', SQLERRM);
22290: WHERE cz_ps_nodes.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND deleted_flag = record_not_deleted;
22291: EXCEPTION
22292: WHEN OTHERS
22293: THEN
22294: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ps_nodes', 'SQLERRM', SQLERRM);
22295: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
22296: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
22297: RAISE;
22298: END;
22297: RAISE;
22298: END;
22299:
22300: v_project_count := cz_pb_mgr.v_devl_project_tbl.COUNT;
22301: rec_count := cz_pb_mgr.v_cz_ps_nodes_new_tbl.COUNT;
22302:
22303: IF (cz_pb_mgr.v_cz_ps_nodes_new_ref.COUNT > 0)
22304: THEN
22305: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
22299:
22300: v_project_count := cz_pb_mgr.v_devl_project_tbl.COUNT;
22301: rec_count := cz_pb_mgr.v_cz_ps_nodes_new_tbl.COUNT;
22302:
22303: IF (cz_pb_mgr.v_cz_ps_nodes_new_ref.COUNT > 0)
22304: THEN
22305: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
22306: LOOP
22307: rec_count := rec_count + 1;
22301: rec_count := cz_pb_mgr.v_cz_ps_nodes_new_tbl.COUNT;
22302:
22303: IF (cz_pb_mgr.v_cz_ps_nodes_new_ref.COUNT > 0)
22304: THEN
22305: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
22306: LOOP
22307: rec_count := rec_count + 1;
22308: cz_pb_mgr.v_cz_ps_nodes_new_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
22309: cz_pb_mgr.v_cz_ps_nodes_old_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_old_ref(k);
22304: THEN
22305: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
22306: LOOP
22307: rec_count := rec_count + 1;
22308: cz_pb_mgr.v_cz_ps_nodes_new_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
22309: cz_pb_mgr.v_cz_ps_nodes_old_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_old_ref(k);
22310: cz_pb_mgr.v_cz_effective_usage_mask_tbl(rec_count) := cz_pb_mgr.v_cz_effective_usage_mask_ref(k);
22311: cz_pb_mgr.v_cz_ps_nodes_idx_tbl(cz_pb_mgr.v_cz_ps_nodes_old_ref(k)):=cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
22312: cz_pb_mgr.v_ps_refid_old_tbl(rec_count) := cz_pb_mgr.v_ps_ref_id_ref(k);
22305: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
22306: LOOP
22307: rec_count := rec_count + 1;
22308: cz_pb_mgr.v_cz_ps_nodes_new_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
22309: cz_pb_mgr.v_cz_ps_nodes_old_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_old_ref(k);
22310: cz_pb_mgr.v_cz_effective_usage_mask_tbl(rec_count) := cz_pb_mgr.v_cz_effective_usage_mask_ref(k);
22311: cz_pb_mgr.v_cz_ps_nodes_idx_tbl(cz_pb_mgr.v_cz_ps_nodes_old_ref(k)):=cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
22312: cz_pb_mgr.v_ps_refid_old_tbl(rec_count) := cz_pb_mgr.v_ps_ref_id_ref(k);
22313:
22307: rec_count := rec_count + 1;
22308: cz_pb_mgr.v_cz_ps_nodes_new_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
22309: cz_pb_mgr.v_cz_ps_nodes_old_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_old_ref(k);
22310: cz_pb_mgr.v_cz_effective_usage_mask_tbl(rec_count) := cz_pb_mgr.v_cz_effective_usage_mask_ref(k);
22311: cz_pb_mgr.v_cz_ps_nodes_idx_tbl(cz_pb_mgr.v_cz_ps_nodes_old_ref(k)):=cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
22312: cz_pb_mgr.v_ps_refid_old_tbl(rec_count) := cz_pb_mgr.v_ps_ref_id_ref(k);
22313:
22314: IF (cz_pb_mgr.v_cz_ps_nodes_old_ref(k) = cz_pb_mgr.v_models_to_be_exported(i))
22315: THEN
22310: cz_pb_mgr.v_cz_effective_usage_mask_tbl(rec_count) := cz_pb_mgr.v_cz_effective_usage_mask_ref(k);
22311: cz_pb_mgr.v_cz_ps_nodes_idx_tbl(cz_pb_mgr.v_cz_ps_nodes_old_ref(k)):=cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
22312: cz_pb_mgr.v_ps_refid_old_tbl(rec_count) := cz_pb_mgr.v_ps_ref_id_ref(k);
22313:
22314: IF (cz_pb_mgr.v_cz_ps_nodes_old_ref(k) = cz_pb_mgr.v_models_to_be_exported(i))
22315: THEN
22316: cz_pb_mgr.v_new_devl_id := cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
22317: END IF;
22318:
22312: cz_pb_mgr.v_ps_refid_old_tbl(rec_count) := cz_pb_mgr.v_ps_ref_id_ref(k);
22313:
22314: IF (cz_pb_mgr.v_cz_ps_nodes_old_ref(k) = cz_pb_mgr.v_models_to_be_exported(i))
22315: THEN
22316: cz_pb_mgr.v_new_devl_id := cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
22317: END IF;
22318:
22319: ------------resolve parent ids
22320: IF (cz_pb_mgr.v_ps_parent_id_ref(k) IS NOT NULL)
22318:
22319: ------------resolve parent ids
22320: IF (cz_pb_mgr.v_ps_parent_id_ref(k) IS NOT NULL)
22321: THEN
22322: IF (cz_pb_mgr.v_cz_ps_nodes_old_ref.COUNT > 0) THEN
22323: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_ref.LAST
22324: LOOP
22325: IF (cz_pb_mgr.v_ps_parent_id_ref(k) = cz_pb_mgr.v_cz_ps_nodes_old_ref(i))
22326: THEN
22319: ------------resolve parent ids
22320: IF (cz_pb_mgr.v_ps_parent_id_ref(k) IS NOT NULL)
22321: THEN
22322: IF (cz_pb_mgr.v_cz_ps_nodes_old_ref.COUNT > 0) THEN
22323: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_ref.LAST
22324: LOOP
22325: IF (cz_pb_mgr.v_ps_parent_id_ref(k) = cz_pb_mgr.v_cz_ps_nodes_old_ref(i))
22326: THEN
22327: cz_pb_mgr.v_ps_parent_id_ref(k) := cz_pb_mgr.v_cz_ps_nodes_new_ref(i);
22321: THEN
22322: IF (cz_pb_mgr.v_cz_ps_nodes_old_ref.COUNT > 0) THEN
22323: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_ref.LAST
22324: LOOP
22325: IF (cz_pb_mgr.v_ps_parent_id_ref(k) = cz_pb_mgr.v_cz_ps_nodes_old_ref(i))
22326: THEN
22327: cz_pb_mgr.v_ps_parent_id_ref(k) := cz_pb_mgr.v_cz_ps_nodes_new_ref(i);
22328: EXIT;
22329: END IF;
22323: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_ref.LAST
22324: LOOP
22325: IF (cz_pb_mgr.v_ps_parent_id_ref(k) = cz_pb_mgr.v_cz_ps_nodes_old_ref(i))
22326: THEN
22327: cz_pb_mgr.v_ps_parent_id_ref(k) := cz_pb_mgr.v_cz_ps_nodes_new_ref(i);
22328: EXIT;
22329: END IF;
22330: END LOOP;
22331: END IF;
22335: cz_pb_mgr.v_ps_eff_set_id_tbl(rec_count) := cz_pb_mgr.v_ps_eff_set_id_ref(k);
22336: cz_pb_mgr.v_ps_intl_old_tbl(rec_count) := cz_pb_mgr.v_ps_intl_old_ref(k);
22337: cz_pb_mgr.v_ps_viol_old_tbl(rec_count) := cz_pb_mgr.v_ps_viol_old_ref(k);
22338: cz_pb_mgr.v_ps_capt_rule_tbl(rec_count) := cz_pb_mgr.v_ps_capt_rule_ref(k);
22339: cz_pb_mgr.v_cz_ps_nodes_comp_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_comp_ref(k);
22340: cz_pb_mgr.v_ps_orig_sys_tbl(rec_count) := cz_pb_mgr.v_ps_orig_sys_ref(k);
22341: cz_pb_mgr.v_ps_comp_seq_path_tbl(rec_count) := cz_pb_mgr.v_ps_comp_seq_path_ref(k);
22342: cz_pb_mgr.v_ps_comp_seq_id_tbl(rec_count) := cz_pb_mgr.v_ps_comp_seq_id_ref(k);
22343: cz_pb_mgr.v_ps_item_id_tbl(rec_count) := cz_pb_mgr.v_ps_item_id_ref(k);
22348: END IF;
22349:
22350: cz_pb_mgr.v_models_to_be_exported_new(i) := cz_pb_mgr.v_new_devl_id;
22351:
22352: IF (cz_pb_mgr.v_cz_ps_nodes_new_ref.COUNT > 0) THEN
22353: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
22354: LOOP
22355: v_project_count := v_project_count + 1;
22356: cz_pb_mgr.v_devl_project_tbl(v_project_count) := cz_pb_mgr.v_new_devl_id;
22349:
22350: cz_pb_mgr.v_models_to_be_exported_new(i) := cz_pb_mgr.v_new_devl_id;
22351:
22352: IF (cz_pb_mgr.v_cz_ps_nodes_new_ref.COUNT > 0) THEN
22353: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
22354: LOOP
22355: v_project_count := v_project_count + 1;
22356: cz_pb_mgr.v_devl_project_tbl(v_project_count) := cz_pb_mgr.v_new_devl_id;
22357: -- cz_pb_mgr.v_intl_text_model_tbl(v_project_count) := cz_pb_mgr.v_new_devl_id;
22400: THEN
22401: log_timing_message('start bulk collect from cz_psnode_propval_v');
22402: END IF;
22403:
22404: IF (cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0) THEN
22405: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_tbl.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_tbl.LAST
22406: LOOP
22407: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
22408: l_data_type_tbl.DELETE;
22401: log_timing_message('start bulk collect from cz_psnode_propval_v');
22402: END IF;
22403:
22404: IF (cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0) THEN
22405: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_tbl.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_tbl.LAST
22406: LOOP
22407: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
22408: l_data_type_tbl.DELETE;
22409: l_prop_num_value_tbl.DELETE;
22409: l_prop_num_value_tbl.DELETE;
22410: l_def_num_value_tbl.DELETE;
22411:
22412: BEGIN
22413: l_old_psnode_id := cz_pb_mgr.v_cz_ps_nodes_old_tbl(i);
22414: l_devl_project_id := cz_pb_mgr.v_devl_project_tbl(i);
22415:
22416: IF (cz_pb_mgr.v_session_parameter <> model_copy)
22417: THEN
22500:
22501: END IF;
22502: END LOOP;
22503: END IF; /* end if of cz_pb_mgr.v_prop_vals_node_tbl.COUNT > 0 */
22504: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_ps_nodes_old_tbl */
22505: END IF;
22506: END IF; /* cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0 */
22507: END get_all_properties;
22508: ------------------------------------------------------------------------------------------------
22502: END LOOP;
22503: END IF; /* end if of cz_pb_mgr.v_prop_vals_node_tbl.COUNT > 0 */
22504: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_ps_nodes_old_tbl */
22505: END IF;
22506: END IF; /* cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0 */
22507: END get_all_properties;
22508: ------------------------------------------------------------------------------------------------
22509: PROCEDURE mm_sync_properties
22510: AS
23183: ,plsql_table_list
23184: ,'cz_pb_mgr.g_archives_old_ref'
23185: ,cz_pb_mgr.g_archives_old_ref
23186: );
23187: resolve_ids(cz_pb_mgr.g_devl_proj_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'resolve proj of archives');
23188: plsql_table_list.DELETE;
23189: rec_count := 1;
23190: plsql_table_list(rec_count).col_name := 'archive_id';
23191: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_archive_id_ref';
23256: END IF;
23257:
23258: resolve_ids(cz_pb_mgr.g_archive_id_old_ref,cz_pb_mgr.g_archive_id_ref, cz_pb_mgr.g_archives_mig_idx_ref, 'rsolve archive ids for ref');
23259: -- Need to use the right array to resolve the devl project ids.
23260: resolve_ids(cz_pb_mgr.g_devl_proj_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'resolve proj of archives');
23261: plsql_table_list.DELETE;
23262: rec_count := 1;
23263: plsql_table_list(rec_count).col_name := 'archive_id';
23264: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_archive_id_ref';