35:
36: -- special fields in id resolution
37: -- cz_des_chart_cells.primary_opt_id, secondary_opt_id, secondary_feature_id
38: -- cz_des_chart_feature.feature_id, cz_rules.rule_folder_id,
39: -- cz_ps_nodes.reference_id, cz_ui_nodes.ui_node_ref_id
40: FLD_PSN_REFERENCE_ID CONSTANT VARCHAR2(9) := 'PSNREFID';
41: FLD_RULE_COMPONENT_ID CONSTANT VARCHAR2(9) := 'RULCOMID';
42: FLD_UI_NODE_REF_ID CONSTANT VARCHAR2(9) := 'UINREFID';
43: FLD_IGNORE_NOW CONSTANT VARCHAR2(9) := 'IGNOREID';
259: -----@x_status : publication status parameter
260: PROCEDURE clear_tables(p_table_name IN VARCHAR2, p_table_type IN VARCHAR2, x_status IN OUT NOCOPY VARCHAR2)
261: AS
262: BEGIN
263: IF (p_table_name = 'cz_ps_nodes')
264: THEN
265: IF (p_table_type = 'tbl')
266: THEN
267: cz_pb_mgr.v_cz_ps_nodes_new_tbl.DELETE;
263: IF (p_table_name = 'cz_ps_nodes')
264: THEN
265: IF (p_table_type = 'tbl')
266: THEN
267: cz_pb_mgr.v_cz_ps_nodes_new_tbl.DELETE;
268: cz_pb_mgr.v_cz_ps_nodes_old_tbl.DELETE;
269: cz_pb_mgr.v_cz_ps_nodes_idx_tbl.DELETE;
270: cz_pb_mgr.v_ps_parent_id_tbl.DELETE;
271: cz_pb_mgr.v_ps_refid_old_tbl.DELETE;
264: THEN
265: IF (p_table_type = 'tbl')
266: THEN
267: cz_pb_mgr.v_cz_ps_nodes_new_tbl.DELETE;
268: cz_pb_mgr.v_cz_ps_nodes_old_tbl.DELETE;
269: cz_pb_mgr.v_cz_ps_nodes_idx_tbl.DELETE;
270: cz_pb_mgr.v_ps_parent_id_tbl.DELETE;
271: cz_pb_mgr.v_ps_refid_old_tbl.DELETE;
272: cz_pb_mgr.v_devl_project_tbl.DELETE;
265: IF (p_table_type = 'tbl')
266: THEN
267: cz_pb_mgr.v_cz_ps_nodes_new_tbl.DELETE;
268: cz_pb_mgr.v_cz_ps_nodes_old_tbl.DELETE;
269: cz_pb_mgr.v_cz_ps_nodes_idx_tbl.DELETE;
270: cz_pb_mgr.v_ps_parent_id_tbl.DELETE;
271: cz_pb_mgr.v_ps_refid_old_tbl.DELETE;
272: cz_pb_mgr.v_devl_project_tbl.DELETE;
273: cz_pb_mgr.v_ps_eff_set_id_tbl.DELETE;
278: cz_pb_mgr.v_ps_comp_seq_id_tbl.DELETE;
279: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
280: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
281: cz_pb_mgr.v_ps_capt_rule_tbl.DELETE;
282: cz_pb_mgr.v_cz_ps_nodes_comp_tbl.DELETE;
283: cz_pb_mgr.v_ps_item_id_tbl.DELETE;
284: cz_pb_mgr.v_ps_type_old_tbl.DELETE;
285: cz_pb_mgr.v_ps_src_appl_id_old_tbl.DELETE;
286: cz_pb_mgr.v_psnode_propval_tbl.DELETE; -- Bug11685105
287: cz_pb_mgr.g_ps_uits_add_tbl.DELETE;
288: cz_pb_mgr.g_usg_name_processed.DELETE;
289: ELSIF(p_table_type = 'ref')
290: THEN
291: cz_pb_mgr.v_cz_ps_nodes_new_ref.DELETE;
292: cz_pb_mgr.v_cz_ps_nodes_old_ref.DELETE;
293: cz_pb_mgr.v_ps_parent_id_ref.DELETE;
294: cz_pb_mgr.v_ps_ref_id_ref.DELETE;
295: cz_pb_mgr.v_ps_eff_set_id_ref.DELETE;
288: cz_pb_mgr.g_usg_name_processed.DELETE;
289: ELSIF(p_table_type = 'ref')
290: THEN
291: cz_pb_mgr.v_cz_ps_nodes_new_ref.DELETE;
292: cz_pb_mgr.v_cz_ps_nodes_old_ref.DELETE;
293: cz_pb_mgr.v_ps_parent_id_ref.DELETE;
294: cz_pb_mgr.v_ps_ref_id_ref.DELETE;
295: cz_pb_mgr.v_ps_eff_set_id_ref.DELETE;
296: cz_pb_mgr.v_ps_intl_old_ref.DELETE;
298: cz_pb_mgr.v_ps_orig_sys_ref.DELETE;
299: cz_pb_mgr.v_ps_comp_seq_path_ref.DELETE;
300: cz_pb_mgr.v_ps_comp_seq_id_ref.DELETE;
301: cz_pb_mgr.v_ps_capt_rule_ref.DELETE;
302: cz_pb_mgr.v_cz_ps_nodes_comp_ref.DELETE;
303: cz_pb_mgr.v_ps_item_id_ref.DELETE;
304: cz_pb_mgr.v_ps_type_old_ref.DELETE;
305: cz_pb_mgr.v_ps_src_appl_id_old_ref.DELETE;
306: END IF;
3028: END LOOP;
3029: --IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
3030: -- log_timing_message('SPITRE rework calling resolve_ids for - model id of cz intl texts');
3031: --END IF;
3032: 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');
3033: END IF;
3034:
3035: --IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
3036: -- log_timing_message('SPITRE rework calling resolve_ids for - ui def id of cz intl texts');
6445: resolve_ids(cz_pb_mgr.g_ui_actns_ui_uidef_old_ref,cz_pb_mgr.g_ui_actns_ui_uidef_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui actions');
6446: -- ignore expl id resolution failure because of a ui refresh issue (see 6817586)
6447: resolve_ids(cz_pb_mgr.g_ui_actns_tgtexpl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of ui actions', FLD_IGNORE_NOW);
6448: -- context_component_id, obsolete
6449: -- resolve_ids(cz_pb_mgr.g_ui_actns_ctx_comp_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'ctx comp id of ui actions');
6450: 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');
6451:
6452: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
6453: 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');
7174: THEN
7175: v_database_link := NULL;
7176: END IF;
7177:
7178: 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);
7179: 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);
7180: --SKM:Bug-13437555 Caling own procedure for deleting from cz_devl_projects table.
7181:
7182: DeleteFromDevlProjects(v_database_link);
7175: v_database_link := NULL;
7176: END IF;
7177:
7178: 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);
7179: 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);
7180: --SKM:Bug-13437555 Caling own procedure for deleting from cz_devl_projects table.
7181:
7182: DeleteFromDevlProjects(v_database_link);
7183:
8471: PROCEDURE get_psnode_last_date(p_model_id IN NUMBER, x_last_update_date OUT NOCOPY DATE) AS
8472: BEGIN
8473: SELECT MAX(last_update_date)
8474: INTO x_last_update_date
8475: FROM cz_ps_nodes
8476: WHERE devl_project_id = p_model_id;
8477: EXCEPTION
8478: WHEN OTHERS THEN
8479: x_last_update_date := cz_utils.epoch_begin;
8599: INTO x_last_update_date
8600: FROM cz_effectivity_sets
8601: WHERE cz_effectivity_sets.effectivity_set_id IN(
8602: SELECT DISTINCT effectivity_set_id
8603: FROM cz_ps_nodes
8604: WHERE cz_ps_nodes.devl_project_id = p_model_id
8605: AND cz_ps_nodes.deleted_flag = record_not_deleted
8606: AND cz_ps_nodes.effectivity_set_id IS NOT NULL);
8607: EXCEPTION
8600: FROM cz_effectivity_sets
8601: WHERE cz_effectivity_sets.effectivity_set_id IN(
8602: SELECT DISTINCT effectivity_set_id
8603: FROM cz_ps_nodes
8604: WHERE cz_ps_nodes.devl_project_id = p_model_id
8605: AND cz_ps_nodes.deleted_flag = record_not_deleted
8606: AND cz_ps_nodes.effectivity_set_id IS NOT NULL);
8607: EXCEPTION
8608: WHEN NO_DATA_FOUND
8601: WHERE cz_effectivity_sets.effectivity_set_id IN(
8602: SELECT DISTINCT effectivity_set_id
8603: FROM cz_ps_nodes
8604: WHERE cz_ps_nodes.devl_project_id = p_model_id
8605: AND cz_ps_nodes.deleted_flag = record_not_deleted
8606: AND cz_ps_nodes.effectivity_set_id IS NOT NULL);
8607: EXCEPTION
8608: WHEN NO_DATA_FOUND
8609: THEN
8602: SELECT DISTINCT effectivity_set_id
8603: FROM cz_ps_nodes
8604: WHERE cz_ps_nodes.devl_project_id = p_model_id
8605: AND cz_ps_nodes.deleted_flag = record_not_deleted
8606: AND cz_ps_nodes.effectivity_set_id IS NOT NULL);
8607: EXCEPTION
8608: WHEN NO_DATA_FOUND
8609: THEN
8610: x_last_update_date := cz_utils.epoch_begin;
9796: )
9797: AS
9798: BEGIN
9799: IF ((x_status <> PUBLICATION_ERROR) AND (cz_pb_mgr.v_session_parameter <> model_copy)) THEN
9800: IF cz_pb_mgr.v_cz_ps_nodes_idx_tbl.EXISTS(p_model_id) THEN
9801: x_remote_model_id := cz_pb_mgr.v_cz_ps_nodes_idx_tbl(p_model_id);
9802: ELSE
9803: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model THEN
9804: IF p_server_id=0 THEN
9797: AS
9798: BEGIN
9799: IF ((x_status <> PUBLICATION_ERROR) AND (cz_pb_mgr.v_session_parameter <> model_copy)) THEN
9800: IF cz_pb_mgr.v_cz_ps_nodes_idx_tbl.EXISTS(p_model_id) THEN
9801: x_remote_model_id := cz_pb_mgr.v_cz_ps_nodes_idx_tbl(p_model_id);
9802: ELSE
9803: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model THEN
9804: IF p_server_id=0 THEN
9805: SELECT remote_model_id INTO x_remote_model_id
9858: AND cz_pb_model_exports.model_id = p_model_id
9859: AND cz_pb_model_exports.status = 'OK';
9860: END IF;
9861:
9862: cz_pb_mgr.v_cz_ps_nodes_idx_tbl(p_model_id) := x_remote_model_id;
9863: END IF;
9864:
9865: ELSE
9866: x_remote_model_id := p_model_id;
10508: SELECT source_server
10509: INTO v_source_server
10510: FROM cz_xfr_project_bills
10511: WHERE model_ps_node_id = (SELECT devl_project_id
10512: FROM cz_ps_nodes
10513: WHERE cz_ps_nodes.ps_node_id = v_bom_ps_node_id AND cz_ps_nodes.deleted_flag = '0');
10514:
10515: ------if the server from where it was imported is different from the target
10516: ------to which it is being published then call the bom sync procedure
10509: INTO v_source_server
10510: FROM cz_xfr_project_bills
10511: WHERE model_ps_node_id = (SELECT devl_project_id
10512: FROM cz_ps_nodes
10513: WHERE cz_ps_nodes.ps_node_id = v_bom_ps_node_id AND cz_ps_nodes.deleted_flag = '0');
10514:
10515: ------if the server from where it was imported is different from the target
10516: ------to which it is being published then call the bom sync procedure
10517: ------else no sync required
10937:
10938: IF (cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT > 0)
10939: THEN
10940: ------resolve component ids of cz lce headers
10941: 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');
10942: -------resolve model ref expl id
10943: 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');
10944: -------resolve model ref expl id
10945: 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');
10941: 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');
10942: -------resolve model ref expl id
10943: 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');
10944: -------resolve model ref expl id
10945: 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');
10946: ------------insert into cz lce headers
10947: plsql_table_list.DELETE;
10948: rec_count := 1;
10949: plsql_table_list(rec_count).col_name := 'lce_header_id';
11018: 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');
11019: --------resolve required expl id
11020: 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');
11021: --------resolve attachment comp id
11022: 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');
11023: --------resolve model id
11024: 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');
11025: insert_lce_load_specs(cz_pb_mgr.v_specs_attach_expl_id_ref
11026: ,cz_pb_mgr.v_specs_lce_header_id_ref
11020: 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');
11021: --------resolve attachment comp id
11022: 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');
11023: --------resolve model id
11024: 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');
11025: insert_lce_load_specs(cz_pb_mgr.v_specs_attach_expl_id_ref
11026: ,cz_pb_mgr.v_specs_lce_header_id_ref
11027: ,cz_pb_mgr.v_specs_required_expl_id_ref
11028: ,cz_pb_mgr.v_specs_attach_comp_id_ref
11357: -----there could be many projects with the same persistent_node_id
11358: -----So we need persistent_node_id and its associated project for resolving child_model_expl_id
11359: -----of model ref expls.
11360: PROCEDURE get_pers_prj_id(
11361: p_ref_node IN cz_ps_nodes.ps_node_id%TYPE
11362: ,x_pers_node_id OUT NOCOPY cz_ps_nodes.ps_node_id%TYPE
11363: ,x_prj_id OUT NOCOPY cz_ps_nodes.devl_project_id%TYPE
11364: )
11365: IS
11358: -----So we need persistent_node_id and its associated project for resolving child_model_expl_id
11359: -----of model ref expls.
11360: PROCEDURE get_pers_prj_id(
11361: p_ref_node IN cz_ps_nodes.ps_node_id%TYPE
11362: ,x_pers_node_id OUT NOCOPY cz_ps_nodes.ps_node_id%TYPE
11363: ,x_prj_id OUT NOCOPY cz_ps_nodes.devl_project_id%TYPE
11364: )
11365: IS
11366: BEGIN
11359: -----of model ref expls.
11360: PROCEDURE get_pers_prj_id(
11361: p_ref_node IN cz_ps_nodes.ps_node_id%TYPE
11362: ,x_pers_node_id OUT NOCOPY cz_ps_nodes.ps_node_id%TYPE
11363: ,x_prj_id OUT NOCOPY cz_ps_nodes.devl_project_id%TYPE
11364: )
11365: IS
11366: BEGIN
11367: SELECT persistent_node_id, devl_project_id
11365: IS
11366: BEGIN
11367: SELECT persistent_node_id, devl_project_id
11368: INTO x_pers_node_id, x_prj_id
11369: FROM cz_ps_nodes t
11370: WHERE t.ps_node_id = p_ref_node AND t.deleted_flag = '0';
11371: EXCEPTION
11372: WHEN OTHERS
11373: THEN
11370: WHERE t.ps_node_id = p_ref_node AND t.deleted_flag = '0';
11371: EXCEPTION
11372: WHEN OTHERS
11373: THEN
11374: cz_pb_mgr.v_err_message := 'Error in retrieving persistent_node_id from cz ps nodes for ps node id: ' || p_ref_node;
11375: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.get_pers_prj_id', SQLCODE);
11376: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11377: RAISE;
11378: END;
11379:
11380: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11381: -------procedure retrieves the project id of a ps node
11382: PROCEDURE get_devl_project_id(
11383: p_ps_node_id IN cz_ps_nodes.ps_node_id%TYPE
11384: ,x_devl_project_id IN OUT NOCOPY cz_ps_nodes.devl_project_id%TYPE
11385: ,x_status IN OUT NOCOPY VARCHAR2
11386: )
11387: AS
11380: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11381: -------procedure retrieves the project id of a ps node
11382: PROCEDURE get_devl_project_id(
11383: p_ps_node_id IN cz_ps_nodes.ps_node_id%TYPE
11384: ,x_devl_project_id IN OUT NOCOPY cz_ps_nodes.devl_project_id%TYPE
11385: ,x_status IN OUT NOCOPY VARCHAR2
11386: )
11387: AS
11388: BEGIN
11389: IF (x_status <> PUBLICATION_ERROR)
11390: THEN
11391: SELECT devl_project_id
11392: INTO x_devl_project_id
11393: FROM cz_ps_nodes
11394: WHERE cz_ps_nodes.ps_node_id = p_ps_node_id AND cz_ps_nodes.deleted_flag = '0';
11395: END IF;
11396: EXCEPTION
11397: WHEN OTHERS
11390: THEN
11391: SELECT devl_project_id
11392: INTO x_devl_project_id
11393: FROM cz_ps_nodes
11394: WHERE cz_ps_nodes.ps_node_id = p_ps_node_id AND cz_ps_nodes.deleted_flag = '0';
11395: END IF;
11396: EXCEPTION
11397: WHEN OTHERS
11398: THEN
11395: END IF;
11396: EXCEPTION
11397: WHEN OTHERS
11398: THEN
11399: 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;
11400: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.GETDEVLPROJID', SQLCODE);
11401: x_status := PUBLICATION_ERROR;
11402: RAISE;
11403: END;
11404:
11405: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11406: -------procedure that retrieves persistent node id
11407: PROCEDURE get_persistent_node_id(
11408: p_ps_node_id IN cz_ps_nodes.ps_node_id%TYPE
11409: ,x_persistent_id IN OUT NOCOPY cz_ps_nodes.persistent_node_id%TYPE
11410: ,x_status IN OUT NOCOPY VARCHAR2
11411: )
11412: AS
11405: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11406: -------procedure that retrieves persistent node id
11407: PROCEDURE get_persistent_node_id(
11408: p_ps_node_id IN cz_ps_nodes.ps_node_id%TYPE
11409: ,x_persistent_id IN OUT NOCOPY cz_ps_nodes.persistent_node_id%TYPE
11410: ,x_status IN OUT NOCOPY VARCHAR2
11411: )
11412: AS
11413: BEGIN
11414: IF (x_status <> PUBLICATION_ERROR)
11415: THEN
11416: SELECT persistent_node_id
11417: INTO x_persistent_id
11418: FROM cz_ps_nodes t
11419: WHERE t.ps_node_id = p_ps_node_id AND t.deleted_flag = '0';
11420: END IF;
11421: EXCEPTION
11422: WHEN OTHERS
11420: END IF;
11421: EXCEPTION
11422: WHEN OTHERS
11423: THEN
11424: cz_pb_mgr.v_err_message := 'Error in retrieving persistent_node_id from cz ps nodes for ps node id: ' || p_ps_node_id;
11425: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.GETDEVLPROJID', SQLCODE);
11426: x_status := PUBLICATION_ERROR;
11427: RAISE;
11428: END;
11475: child_ref_id_cv ref_cursor;
11476: v_ref_project cz_devl_projects.devl_project_id%TYPE;
11477: v_ref_remote_model cz_devl_projects.devl_project_id%TYPE;
11478: v_child_expl_id cz_model_ref_expls.model_ref_expl_id%TYPE;
11479: v_persistent_node_id cz_ps_nodes.persistent_node_id%TYPE;
11480: v_source_child_model cz_model_ref_expls.model_id%TYPE;
11481: v_child_ref_node cz_ps_nodes.ps_node_id%TYPE;
11482: v_ref_model_id cz_model_ref_expls.model_id%TYPE;
11483: BEGIN
11477: v_ref_remote_model cz_devl_projects.devl_project_id%TYPE;
11478: v_child_expl_id cz_model_ref_expls.model_ref_expl_id%TYPE;
11479: v_persistent_node_id cz_ps_nodes.persistent_node_id%TYPE;
11480: v_source_child_model cz_model_ref_expls.model_id%TYPE;
11481: v_child_ref_node cz_ps_nodes.ps_node_id%TYPE;
11482: v_ref_model_id cz_model_ref_expls.model_id%TYPE;
11483: BEGIN
11484: IF (x_status <> PUBLICATION_ERROR)
11485: THEN
11558: CLOSE child_ref_id_cv;
11559:
11560: get_persistent_node_id(p_resolved_key_array(i), v_persistent_node_id, cz_pb_mgr.v_status_code);
11561:
11562: OPEN child_ref_id_cv FOR 'SELECT ps_node_id FROM cz_ps_nodes'
11563: || cz_pb_mgr.v_db_link
11564: || ' t'
11565: || ' '
11566: || 'WHERE t.persistent_node_id = '
11601:
11602: BEGIN
11603: OPEN child_ref_id_cv FOR 'SELECT ps_node_id'
11604: || ' '
11605: || 'FROM cz_ps_nodes'
11606: || cz_pb_mgr.v_db_link
11607: || ' t'
11608: || ' '
11609: || 'WHERE t.persistent_node_id = '
11777: RAISE;
11778: END;
11779:
11780: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11781: ------update reference ids of cz ps nodes of the remote model
11782: ------@p_models_exported -- root model and all its children
11783: ------@x_status --- publication status
11784: ------@p_server_id --- server local is of the target instance
11785: ------@p_new_ps_node_array --- ps node array that contains new values
11805: LOOP
11806: IF (cz_pb_mgr.v_ps_refid_old_tbl(j) IS NOT NULL)
11807: THEN
11808: get_remote_model_id(p_server_id, p_models_not_exported(i), x_status, l_remote_mode_id);
11809: l_sql_string := 'UPDATE cz_ps_nodes'
11810: || cz_pb_mgr.v_db_link
11811: || ' SET reference_id=:1,component_id=:2'
11812: || ' WHERE deleted_flag=:3 AND ps_node_id=:4 AND reference_id=:5';
11813: EXECUTE IMMEDIATE l_sql_string
11822: END IF;
11823: EXCEPTION
11824: WHEN OTHERS
11825: THEN
11826: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REF_ID_ERR', 'TABLENAME', 'cz_ps_nodes', 'SQLERRM', SQLERRM);
11827: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
11828: x_status := PUBLICATION_ERROR;
11829: RAISE;
11830: END;
11850: v_vir_remote_model_id NUMBER := 0.0;
11851: v_vir_devl_id NUMBER := 0.0;
11852: v_remote_comp_id NUMBER := 0.0;
11853: v_child_expl_id NUMBER := 0.0;
11854: v_vir_persistent_id cz_ps_nodes.persistent_node_id%TYPE;
11855: v_errored_model_id cz_devl_projects.devl_project_id%TYPE;
11856: BEGIN
11857: IF (x_status <> PUBLICATION_ERROR)
11858: THEN
11908: LOOP
11909: BEGIN
11910: SELECT devl_project_id, persistent_node_id
11911: INTO v_vir_devl_id, v_vir_persistent_id
11912: FROM cz_ps_nodes
11913: WHERE ps_node_id = v_vrt_comp_id_ref(i);
11914: EXCEPTION
11915: WHEN OTHERS
11916: THEN
11929:
11930: IF (v_vir_remote_model_id > 0)
11931: THEN
11932: BEGIN
11933: OPEN virt_ref_id_cv FOR 'SELECT ps_node_id FROM cz_ps_nodes'
11934: || cz_pb_mgr.v_db_link
11935: || ' t'
11936: || ' '
11937: || 'WHERE t.devl_project_id = '
12355: v_rem_ps_nodes_ref cz_pb_mgr.t_ref;
12356: v_rem_pers_nodes_ref cz_pb_mgr.t_ref;
12357: v_src_ps_nodes_ref cz_pb_mgr.t_ref;
12358: remote_node_cv ref_cursor;
12359: v_remote_ps_node_id cz_ps_nodes.ps_node_id%TYPE;
12360: v_remote_pers_node_id cz_ps_nodes.persistent_node_id%TYPE;
12361: l_remote_model_id NUMBER;
12362: BEGIN
12363: IF (x_status <> PUBLICATION_ERROR) THEN
12356: v_rem_pers_nodes_ref cz_pb_mgr.t_ref;
12357: v_src_ps_nodes_ref cz_pb_mgr.t_ref;
12358: remote_node_cv ref_cursor;
12359: v_remote_ps_node_id cz_ps_nodes.ps_node_id%TYPE;
12360: v_remote_pers_node_id cz_ps_nodes.persistent_node_id%TYPE;
12361: l_remote_model_id NUMBER;
12362: BEGIN
12363: IF (x_status <> PUBLICATION_ERROR) THEN
12364: IF (p_model_not_exported_array.COUNT > 0) THEN
12379:
12380: IF (v_remote_models_tbl(k) > 0) THEN
12381: OPEN remote_node_cv FOR 'SELECT ps_node_id,persistent_node_id'
12382: || ' '
12383: || 'FROM cz_ps_nodes'
12384: || cz_pb_mgr.v_db_link
12385: || ' t'
12386: || ' '
12387: || 'WHERE t.devl_project_id = '
12399: v_rem_pers_nodes_ref(remote_ps_count) := v_remote_pers_node_id;
12400:
12401: SELECT ps_node_id
12402: INTO v_src_ps_nodes_ref(remote_ps_count)
12403: FROM cz_ps_nodes
12404: WHERE cz_ps_nodes.devl_project_id = p_model_not_exported_array(k)
12405: AND cz_ps_nodes.persistent_node_id = v_remote_pers_node_id
12406: AND cz_ps_nodes.deleted_flag = record_not_deleted;
12407: END LOOP;
12400:
12401: SELECT ps_node_id
12402: INTO v_src_ps_nodes_ref(remote_ps_count)
12403: FROM cz_ps_nodes
12404: WHERE cz_ps_nodes.devl_project_id = p_model_not_exported_array(k)
12405: AND cz_ps_nodes.persistent_node_id = v_remote_pers_node_id
12406: AND cz_ps_nodes.deleted_flag = record_not_deleted;
12407: END LOOP;
12408:
12401: SELECT ps_node_id
12402: INTO v_src_ps_nodes_ref(remote_ps_count)
12403: FROM cz_ps_nodes
12404: WHERE cz_ps_nodes.devl_project_id = p_model_not_exported_array(k)
12405: AND cz_ps_nodes.persistent_node_id = v_remote_pers_node_id
12406: AND cz_ps_nodes.deleted_flag = record_not_deleted;
12407: END LOOP;
12408:
12409: CLOSE remote_node_cv;
12402: INTO v_src_ps_nodes_ref(remote_ps_count)
12403: FROM cz_ps_nodes
12404: WHERE cz_ps_nodes.devl_project_id = p_model_not_exported_array(k)
12405: AND cz_ps_nodes.persistent_node_id = v_remote_pers_node_id
12406: AND cz_ps_nodes.deleted_flag = record_not_deleted;
12407: END LOOP;
12408:
12409: CLOSE remote_node_cv;
12410: END IF; /* end if of (v_remote_models_tbl(k) > 0) */
12413: IF (v_rem_ps_nodes_ref.COUNT > 0)
12414: THEN
12415: FOR m IN v_rem_ps_nodes_ref.FIRST .. v_rem_ps_nodes_ref.LAST
12416: LOOP
12417: cz_pb_mgr.v_cz_ps_nodes_idx_tbl(v_src_ps_nodes_ref(m)):=v_rem_ps_nodes_ref(m);
12418: END LOOP;
12419: END IF; /* end if of (v_rem_ps_nodes_ref.COUNT > 0) */
12420: END IF; /* end if of (p_model_not_exported_array.COUNT > 0) */
12421: END IF; /* end if of x_status <> PUBLICATION_ERROR */
13193: ----procedure that clears all global pl/sql tables
13194: PROCEDURE clear_all_tables(x_status IN OUT NOCOPY VARCHAR2)
13195: AS
13196: BEGIN
13197: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
13198: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
13199: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
13200: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
13201: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
13194: PROCEDURE clear_all_tables(x_status IN OUT NOCOPY VARCHAR2)
13195: AS
13196: BEGIN
13197: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
13198: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
13199: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
13200: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
13201: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
13202: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
14539: THEN
14540: log_timing_message('end eff sets of ps nodes');
14541: END IF;
14542:
14543: -------------insert intl texts for cz_ps_nodes
14544: IF (cz_pb_mgr.g_log_timing = publication_timing)
14545: THEN
14546: log_timing_message('start insert_intl_texts Intl Text of ps nodes');
14547: END IF;
14603: THEN
14604: log_timing_message('end resolve resolve caption rule ids in ps nodes');
14605: END IF;
14606:
14607: ------------Resolving ps_ref_id of cz ps nodes
14608: IF (cz_pb_mgr.g_log_timing = publication_timing)
14609: THEN
14610: log_timing_message('start resolve_ids ps_ref_id of cz ps nodes');
14611: END IF;
14606:
14607: ------------Resolving ps_ref_id of cz ps nodes
14608: IF (cz_pb_mgr.g_log_timing = publication_timing)
14609: THEN
14610: log_timing_message('start resolve_ids ps_ref_id of cz ps nodes');
14611: END IF;
14612:
14613: -- non-exported psnodes actually loaded and put into the map too, so it would be better to load them early too
14614: -- then no special treatment needed for reference_id, component_id, etc
14611: END IF;
14612:
14613: -- non-exported psnodes actually loaded and put into the map too, so it would be better to load them early too
14614: -- then no special treatment needed for reference_id, component_id, etc
14615: 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);
14616:
14617: IF (cz_pb_mgr.g_log_timing = publication_timing)
14618: THEN
14619: log_timing_message('end resolve_ids ps_ref_id of cz ps nodes');
14615: 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);
14616:
14617: IF (cz_pb_mgr.g_log_timing = publication_timing)
14618: THEN
14619: log_timing_message('end resolve_ids ps_ref_id of cz ps nodes');
14620: END IF;
14621:
14622: ------------Resolving component -ids of ps_nodes
14623: 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);
14619: log_timing_message('end resolve_ids ps_ref_id of cz ps nodes');
14620: END IF;
14621:
14622: ------------Resolving component -ids of ps_nodes
14623: 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);
14624:
14625: -- resolve effective usage mask for ps nodes.
14626: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
14627: THEN
14624:
14625: -- resolve effective usage mask for ps nodes.
14626: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
14627: THEN
14628: resolve_effective_usage_mask(cz_pb_mgr.v_cz_ps_nodes_old_tbl, 0);
14629: END IF;
14630:
14631: -- to verify: the model referred by reverse connector id would always be reexported regardless of having any
14632: -- change or not, if the model having the reverse connector is exported?
14630:
14631: -- to verify: the model referred by reverse connector id would always be reexported regardless of having any
14632: -- change or not, if the model having the reverse connector is exported?
14633: -- otherwise, we need to implement resolver_ref_ids_not_found for this column and call that instead
14634: resolve_ids(cz_pb_mgr.g_ps_reverse_connector_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'psn reverse_connector_id');
14635:
14636: plsql_table_list.DELETE;
14637: rec_count := 1;
14638: plsql_table_list(rec_count).col_name := 'ps_node_id';
14635:
14636: plsql_table_list.DELETE;
14637: rec_count := 1;
14638: plsql_table_list(rec_count).col_name := 'ps_node_id';
14639: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ps_nodes_new_tbl';
14640: rec_count := rec_count + 1;
14641: plsql_table_list(rec_count).col_name := 'devl_project_id';
14642: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_devl_project_tbl';
14643: rec_count := rec_count + 1;
14667: rec_count := rec_count + 1;
14668: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_ps_capt_rule_tbl';
14669: plsql_table_list(rec_count).col_name := 'displayname_capt_rule_id';
14670: rec_count := rec_count + 1;
14671: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ps_nodes_comp_tbl';
14672: plsql_table_list(rec_count).col_name := 'component_id';
14673: rec_count := rec_count + 1;
14674: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ps_uits_add_tbl';
14675: plsql_table_list(rec_count).col_name := 'UI_TIMESTAMP_ADD';
14687: mm_resync_ps_item_types; --Bug9180063
14688: rec_count := rec_count + 1;
14689: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_v_ps_item_id_tbl';
14690: plsql_table_list(rec_count).col_name := 'item_id';
14691: --Bug9180063 to include item_type_backptr during insertion of data into cz_ps_nodes
14692: rec_count := rec_count + 1;
14693: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_v_ps_item_type_id_tbl';
14694: plsql_table_list(rec_count).col_name := 'item_type_backptr';
14695: END IF;
14695: END IF;
14696:
14697: IF (cz_pb_mgr.g_log_timing = publication_timing)
14698: THEN
14699: log_timing_message('start insert_into_table of cz ps nodes');
14700: END IF;
14701:
14702: insert_into_table('cz_ps_nodes'
14703: ,'ps_node_id'
14698: THEN
14699: log_timing_message('start insert_into_table of cz ps nodes');
14700: END IF;
14701:
14702: insert_into_table('cz_ps_nodes'
14703: ,'ps_node_id'
14704: ,cz_pb_mgr.v_db_link
14705: ,plsql_table_list
14706: ,'cz_pb_mgr.v_cz_ps_nodes_old_tbl'
14702: insert_into_table('cz_ps_nodes'
14703: ,'ps_node_id'
14704: ,cz_pb_mgr.v_db_link
14705: ,plsql_table_list
14706: ,'cz_pb_mgr.v_cz_ps_nodes_old_tbl'
14707: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
14708: );
14709:
14710: IF (cz_pb_mgr.g_log_timing = publication_timing)
14703: ,'ps_node_id'
14704: ,cz_pb_mgr.v_db_link
14705: ,plsql_table_list
14706: ,'cz_pb_mgr.v_cz_ps_nodes_old_tbl'
14707: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
14708: );
14709:
14710: IF (cz_pb_mgr.g_log_timing = publication_timing)
14711: THEN
14708: );
14709:
14710: IF (cz_pb_mgr.g_log_timing = publication_timing)
14711: THEN
14712: log_timing_message('end insert_into_table of cz ps nodes');
14713: END IF;
14714:
14715: -----------update reference id of cz_ps_nodes of the target server for the models not exported
14716: IF (cz_pb_mgr.g_log_timing = publication_timing)
14711: THEN
14712: log_timing_message('end insert_into_table of cz ps nodes');
14713: END IF;
14714:
14715: -----------update reference id of cz_ps_nodes of the target server for the models not exported
14716: IF (cz_pb_mgr.g_log_timing = publication_timing)
14717: THEN
14718: log_timing_message('start update_remote_reference_ids');
14719: END IF;
14718: log_timing_message('start update_remote_reference_ids');
14719: END IF;
14720:
14721: update_remote_reference_ids(cz_pb_mgr.v_models_not_to_be_exported
14722: ,cz_pb_mgr.v_cz_ps_nodes_new_tbl
14723: ,cz_pb_mgr.v_server_id
14724: ,cz_pb_mgr.v_status_code
14725: );
14726:
14809: THEN
14810: log_timing_message('start resolve_ids model id of cz_model_ref_expls');
14811: END IF;
14812:
14813: 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');
14814:
14815: IF (cz_pb_mgr.g_log_timing = publication_timing)
14816: THEN
14817: log_timing_message('end resolve_ids model id of cz_model_ref_expls');
14823: log_timing_message('start resolve_ref_ids_not_found cz_model_ref_expl.referring_node_id');
14824: END IF;
14825:
14826: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
14827: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
14828: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
14829: ,cz_pb_mgr.v_referring_node_id_ref
14830: ,'cz_model_ref_expl.referring_node_id'
14831: ,cz_pb_mgr.v_status_code
14824: END IF;
14825:
14826: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
14827: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
14828: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
14829: ,cz_pb_mgr.v_referring_node_id_ref
14830: ,'cz_model_ref_expl.referring_node_id'
14831: ,cz_pb_mgr.v_status_code
14832: );
14861: log_timing_message('start resolve_ref_ids_not_found cz_model_ref_expl.component_id');
14862: END IF;
14863:
14864: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
14865: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
14866: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
14867: ,cz_pb_mgr.v_component_id_old_ref
14868: ,'cz_model_ref_expl.component_id'
14869: ,cz_pb_mgr.v_status_code
14862: END IF;
14863:
14864: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
14865: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
14866: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
14867: ,cz_pb_mgr.v_component_id_old_ref
14868: ,'cz_model_ref_expl.component_id'
14869: ,cz_pb_mgr.v_status_code
14870: );
15351: log_timing_message('start resolve_ids devl project id of cz_ui_defs');
15352: END IF;
15353:
15354: ----------resolve devl_project_ids
15355: resolve_ids(cz_pb_mgr.v_ui_devl_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl project id of cz_ui_defs');
15356:
15357: IF (cz_pb_mgr.g_log_timing = publication_timing)
15358: THEN
15359: log_timing_message('end resolve_ids devl project id of cz_ui_defs');
15364: THEN
15365: log_timing_message('start resolve_ids component id of cz_ui_defs');
15366: END IF;
15367:
15368: resolve_ids(cz_pb_mgr.v_ui_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_ui_defs');
15369:
15370: IF (cz_pb_mgr.g_log_timing = publication_timing)
15371: THEN
15372: log_timing_message('end resolve_ids component id of cz_ui_defs');
15654: THEN
15655: log_timing_message('start resolve_ids ps node ids of ui nodes');
15656: END IF;
15657:
15658: 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');
15659:
15660: IF (cz_pb_mgr.g_log_timing = publication_timing)
15661: THEN
15662: log_timing_message('end resolve_ids ps node ids of ui nodes');
15667: THEN
15668: log_timing_message('start resolve_ids component ids of ui nodes');
15669: END IF;
15670:
15671: 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');
15672:
15673: IF (cz_pb_mgr.g_log_timing = publication_timing)
15674: THEN
15675: log_timing_message('end resolve_ids component ids of ui nodes');
15854: log_timing_message('start resolve psnodes of prop vals');
15855: END IF;
15856:
15857: -----resolve psnodes of prop vals
15858: 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');
15859:
15860: -- BUG 11685105 - update the structure with new ps_node_ids
15861: IF (cz_pb_mgr.v_prop_vals_node_ref.COUNT > 0) THEN
15862: FOR k IN cz_pb_mgr.v_prop_vals_node_ref.FIRST .. cz_pb_mgr.v_prop_vals_node_ref.LAST
16051: END LOOP;
16052: END IF;
16053: END LOOP;
16054:
16055: resolve_ids(cz_pb_mgr.g_fcefile_compid_tbl,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'component id of fce files');
16056:
16057: l_plsql_table_list(1).col_name := 'FCE_FILE_ID';
16058: l_plsql_table_list(1).table_name := 'cz_pb_mgr.g_fcefile_new_id_tbl';
16059: l_plsql_table_list(2).col_name := 'COMPONENT_ID';
16114: END IF;
16115: 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');
16116:
16117: -------------Resolve devl_project_id of cz_rules
16118: 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');
16119: -------------Resolve component_id of cz_rules
16120: resolve_ids(cz_pb_mgr.v_cz_rules_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component_id of cz rules', FLD_RULE_COMPONENT_ID);
16121:
16122: -------------Resolve expl id of cz_rules
16116:
16117: -------------Resolve devl_project_id of cz_rules
16118: 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');
16119: -------------Resolve component_id of cz_rules
16120: resolve_ids(cz_pb_mgr.v_cz_rules_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component_id of cz rules', FLD_RULE_COMPONENT_ID);
16121:
16122: -------------Resolve expl id of cz_rules
16123: resolve_ids(cz_pb_mgr.v_cz_rules_expl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl id of cz rules');
16124: resolve_ids(cz_pb_mgr.v_cz_rules_ui_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def id of cz rules');
16378: BULK COLLECT INTO l_filter_sets_new_id_tbl
16379: ,l_filter_sets_id_tbl, l_filter_sets_devl_tbl, l_filter_sets_rule_tbl
16380: FROM cz_filter_sets
16381: WHERE cz_filter_sets.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_filter_sets.deleted_flag = '0'
16382: AND EXISTS (SELECT NULL FROM cz_populators pop, cz_ps_nodes psn
16383: WHERE pop.deleted_flag = '0' AND pop.filter_set_id = cz_filter_sets.filter_set_id
16384: AND pop.owned_by_node_id = psn.ps_node_id AND psn.deleted_flag = '0');
16385:
16386: EXCEPTION
16462: END IF;
16463: END LOOP;
16464:
16465: ------resolve devl id and rule id
16466: 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');
16467: ------resolve devl id
16468: 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');
16469: -----resolve ps node id
16470: 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');
16466: 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');
16467: ------resolve devl id
16468: 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');
16469: -----resolve ps node id
16470: 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');
16471: -----resolve filter set id
16472: resolve_ids(cz_pb_mgr.v_populators_set_id_ref, cz_pb_mgr.v_filter_sets_idx_ref, 'filter set id of cz populators');
16473: plsql_table_list.DELETE;
16474: rec_count := 1;
16510: EXECUTE IMMEDIATE
16511: 'BEGIN' || ' ' ||
16512: 'FOR i IN cz_pb_mgr.v_populators_node_ref.FIRST..cz_pb_mgr.v_populators_node_ref.LAST' || ' ' ||
16513: 'LOOP' || ' ' ||
16514: 'UPDATE cz_ps_nodes' || cz_pb_mgr.v_db_link || ' ' || 't' || ' ' ||
16515: 'SET t.from_populator_id = cz_pb_mgr.v_populators_new_id_ref(i) ' || ' ' ||
16516: 'WHERE t.devl_project_id = cz_pb_mgr.v_filter_sets_devl_ref(i) AND' || ' ' ||
16517: 't.from_populator_id=cz_pb_mgr.v_populators_id_ref(i) AND' || ' ' ||
16518: 't.deleted_flag=''0''; ' || ' ' ||
16586:
16587: BEGIN
16588: --------------populate ps nodes pl/sql table with ps node ids from remote server
16589: get_rem_nodes_of_models(cz_pb_mgr.v_models_not_to_be_exported
16590: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
16591: ,cz_pb_mgr.v_status_code
16592: );
16593: -------insert into cz_rule_folders
16594: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
16711: END IF; /* end if of cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
16712:
16713: -----resolve parent rule folder id and devl proj id
16714: 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');
16715: 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');
16716: insert_eff_sets(cz_pb_mgr.v_cz_folders_eff_ref
16717: ,cz_pb_mgr.v_cz_eff_sets_old_tbl
16718: ,cz_pb_mgr.v_cz_eff_sets_new_tbl
16719: ,cz_pb_mgr.v_cz_eff_sets_idx_tbl
16775: THEN
16776: log_timing_message('start resolve_ids devl project id of cz_func_comp_specs');
16777: END IF;
16778:
16779: 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');
16780:
16781: IF (cz_pb_mgr.g_log_timing = publication_timing)
16782: THEN
16783: log_timing_message('end resolve_ids devl project id of cz_func_comp_specs');
16783: log_timing_message('end resolve_ids devl project id of cz_func_comp_specs');
16784: log_timing_message('start resolve_ids component id of cz_func_comp_specs');
16785: END IF;
16786:
16787: 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);
16788:
16789: IF (cz_pb_mgr.g_log_timing = publication_timing)
16790: THEN
16791: log_timing_message('end resolve_ids component id of cz_func_comp_specs');
16987: 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);
16988: 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);
16989:
16990: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16991: 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');
16992: 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');
16993: 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);
16994: ELSE
16995: 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);
16992: 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');
16993: 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);
16994: ELSE
16995: 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);
16996: 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);
16997: END IF;
16998:
16999: 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');
17000:
17094: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_models_to_be_exported */
17095: END IF; /* cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
17096:
17097: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17098: 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');
17099: 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');
17100: ELSE
17101: 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);
17102: 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);
17097: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17098: 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');
17099: 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');
17100: ELSE
17101: 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);
17102: 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);
17103: END IF;
17104:
17105: 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');
17165: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_models_to_be_exported */
17166: END IF; /* end if of cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
17167:
17168: 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');
17169: 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);
17170:
17171: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17172: 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');
17173: 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');
17168: 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');
17169: 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);
17170:
17171: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17172: 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');
17173: 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');
17174: 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');
17175: ELSE
17176: 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);
17169: 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);
17170:
17171: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17172: 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');
17173: 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');
17174: 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');
17175: ELSE
17176: 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);
17177: 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);
17172: 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');
17173: 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');
17174: 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');
17175: ELSE
17176: 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);
17177: 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);
17178: 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);
17179: END IF;
17180:
17173: 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');
17174: 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');
17175: ELSE
17176: 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);
17177: 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);
17178: 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);
17179: END IF;
17180:
17181: ------insert new records into cz_des_chart_cells
17577: END IF;
17578: END IF;
17579: END LOOP;
17580: END IF; /* end if of cz_pb_mgr.v_item_masters_ref.COUNT > 0 */
17581: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_ps_nodes_old_tbl */
17582: END IF; /* end if of cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0 */
17583:
17584: IF (cz_pb_mgr.v_item_types_tbl.COUNT > 0)
17585: THEN
17578: END IF;
17579: END LOOP;
17580: END IF; /* end if of cz_pb_mgr.v_item_masters_ref.COUNT > 0 */
17581: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_ps_nodes_old_tbl */
17582: END IF; /* end if of cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0 */
17583:
17584: IF (cz_pb_mgr.v_item_types_tbl.COUNT > 0)
17585: THEN
17586: cz_pb_mgr.v_item_types_new_ref.DELETE;
17656: BEGIN
17657: SELECT property_id, data_type, name, src_application_id
17658: BULK COLLECT INTO v_remote_prop_tbl, v_prop_type_tbl, v_prop_name_tbl, v_prop_src_app_tbl
17659: FROM (SELECT itp.property_id, p.data_type, p.name, nvl(p.src_application_id, 0) AS src_application_id
17660: from cz_item_masters im, cz_item_type_properties itp, cz_ps_nodes psn, cz_properties p
17661: where psn.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) and psn.deleted_flag = '0'
17662: and psn.item_id = im.item_id AND im.deleted_flag = '0' and im.item_type_id = itp.item_type_id
17663: AND itp.deleted_flag = '0' and itp.property_id = p.property_id and p.deleted_flag = '0'
17664: UNION
17662: and psn.item_id = im.item_id AND im.deleted_flag = '0' and im.item_type_id = itp.item_type_id
17663: AND itp.deleted_flag = '0' and itp.property_id = p.property_id and p.deleted_flag = '0'
17664: UNION
17665: SELECT psp.property_id, p.data_type, p.name, nvl(p.src_application_id, 0) AS src_application_id
17666: from cz_ps_prop_vals psp, cz_ps_nodes psn, cz_properties p
17667: where psn.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) and psn.ps_node_id = psp.ps_node_id
17668: and psn.deleted_flag = '0' AND psp.deleted_Flag = '0' and psp.property_id = p.property_id
17669: and p.deleted_flag = '0'
17670: UNION
17668: and psn.deleted_flag = '0' AND psp.deleted_Flag = '0' and psp.property_id = p.property_id
17669: and p.deleted_flag = '0'
17670: UNION
17671: SELECT ipv.property_id, p.data_type, p.name, nvl(p.src_application_id, 0) AS src_application_id
17672: from cz_ps_nodes psn, cz_item_property_values ipv, cz_properties p
17673: where psn.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) and psn.item_id = ipv.item_id
17674: and psn.deleted_flag = '0' and ipv.deleted_flag = '0' and ipv.property_id = p.property_id
17675: and p.deleted_flag = '0');
17676:
17924:
17925: --upload_item_schema used to to happen after upload_ps_structure, upload_ui_schema
17926: --but model migration required this to happen earlier. Moving this did not seem to affect
17927: --publication.
17928: upload_item_schema(cz_pb_mgr.v_cz_ps_nodes_old_tbl, cz_pb_mgr.v_status_code);
17929:
17930: IF (cz_pb_mgr.g_log_timing = publication_timing)
17931: THEN
17932: log_timing_message('end upload_item_schema');
20417: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
20418: END;
20419:
20420: --Calculate the max_persistent_rec_id for the model and insert into CZ_PERSISTENT_REC_IDS.
20421: EXECUTE IMMEDIATE 'SELECT GREATEST(NVL((SELECT MAX(persistent_node_id) FROM cz_ps_nodes'
20422: || cz_pb_mgr.v_db_link
20423: || ' WHERE deleted_flag = ''0'' AND devl_project_id = :1), 0),'
20424: || ' NVL((SELECT MAX(persistent_rule_id) FROM cz_rules'
20425: || cz_pb_mgr.v_db_link
23460: PROCEDURE mm_loadoldpsnodesforitems
23461: AS
23462: v_project_count PLS_INTEGER;
23463: rec_count PLS_INTEGER;
23464: l_ps_uits_add_tbl date_tbl_type; -- cz_ps_nodes.UI_TIMESTAMP_ADD
23465: l_reverse_connector_tbl t_ref;
23466: BEGIN
23467: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
23468: cz_pb_mgr.sequence_const := 0;
23463: rec_count PLS_INTEGER;
23464: l_ps_uits_add_tbl date_tbl_type; -- cz_ps_nodes.UI_TIMESTAMP_ADD
23465: l_reverse_connector_tbl t_ref;
23466: BEGIN
23467: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
23468: cz_pb_mgr.sequence_const := 0;
23469:
23470: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
23471: THEN
23471: THEN
23472: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
23473: LOOP
23474: BEGIN
23475: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
23476: l_ps_uits_add_tbl.DELETE;
23477: l_reverse_connector_tbl.DELETE;
23478:
23479: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ps_nodes_seq
23475: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
23476: l_ps_uits_add_tbl.DELETE;
23477: l_reverse_connector_tbl.DELETE;
23478:
23479: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ps_nodes_seq
23480: , 'cz_ps_nodes_s.NEXTVAL' || cz_pb_mgr.v_db_link
23481: ,cz_pb_mgr.v_oraclesequenceincr
23482: )
23483: ,ps_node_id, parent_id, reference_id, effectivity_set_id
23476: l_ps_uits_add_tbl.DELETE;
23477: l_reverse_connector_tbl.DELETE;
23478:
23479: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ps_nodes_seq
23480: , 'cz_ps_nodes_s.NEXTVAL' || cz_pb_mgr.v_db_link
23481: ,cz_pb_mgr.v_oraclesequenceincr
23482: )
23483: ,ps_node_id, parent_id, reference_id, effectivity_set_id
23484: ,intl_text_id, violation_text_id, displayname_capt_rule_id, component_id
23486: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_origsysref(orig_sys_ref), 'N', orig_sys_ref)
23487: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqpath(component_sequence_path), 'N', component_sequence_path)
23488: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)
23489: ,NVL(ui_timestamp_add, creation_date), reverse_connector_id, src_application_id
23490: BULK COLLECT INTO cz_pb_mgr.v_cz_ps_nodes_new_ref
23491: ,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
23492: ,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
23493: ,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
23494: ,cz_pb_mgr.v_ps_orig_sys_ref
23487: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqpath(component_sequence_path), 'N', component_sequence_path)
23488: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)
23489: ,NVL(ui_timestamp_add, creation_date), reverse_connector_id, src_application_id
23490: BULK COLLECT INTO cz_pb_mgr.v_cz_ps_nodes_new_ref
23491: ,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
23492: ,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
23493: ,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
23494: ,cz_pb_mgr.v_ps_orig_sys_ref
23495: ,cz_pb_mgr.v_ps_comp_seq_path_ref
23488: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)
23489: ,NVL(ui_timestamp_add, creation_date), reverse_connector_id, src_application_id
23490: BULK COLLECT INTO cz_pb_mgr.v_cz_ps_nodes_new_ref
23491: ,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
23492: ,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
23493: ,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
23494: ,cz_pb_mgr.v_ps_orig_sys_ref
23495: ,cz_pb_mgr.v_ps_comp_seq_path_ref
23496: ,cz_pb_mgr.v_ps_comp_seq_id_ref
23495: ,cz_pb_mgr.v_ps_comp_seq_path_ref
23496: ,cz_pb_mgr.v_ps_comp_seq_id_ref
23497: ,l_ps_uits_add_tbl, l_reverse_connector_tbl
23498: ,cz_pb_mgr.v_ps_src_appl_id_old_ref
23499: FROM cz_ps_nodes
23500: WHERE cz_ps_nodes.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND deleted_flag = record_not_deleted;
23501: EXCEPTION
23502: WHEN OTHERS
23503: THEN
23496: ,cz_pb_mgr.v_ps_comp_seq_id_ref
23497: ,l_ps_uits_add_tbl, l_reverse_connector_tbl
23498: ,cz_pb_mgr.v_ps_src_appl_id_old_ref
23499: FROM cz_ps_nodes
23500: WHERE cz_ps_nodes.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND deleted_flag = record_not_deleted;
23501: EXCEPTION
23502: WHEN OTHERS
23503: THEN
23504: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ps_nodes', 'SQLERRM', SQLERRM);
23500: WHERE cz_ps_nodes.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND deleted_flag = record_not_deleted;
23501: EXCEPTION
23502: WHEN OTHERS
23503: THEN
23504: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ps_nodes', 'SQLERRM', SQLERRM);
23505: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
23506: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
23507: RAISE;
23508: END;
23507: RAISE;
23508: END;
23509:
23510: v_project_count := cz_pb_mgr.v_devl_project_tbl.COUNT;
23511: rec_count := cz_pb_mgr.v_cz_ps_nodes_new_tbl.COUNT;
23512:
23513: IF (cz_pb_mgr.v_cz_ps_nodes_new_ref.COUNT > 0)
23514: THEN
23515: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
23509:
23510: v_project_count := cz_pb_mgr.v_devl_project_tbl.COUNT;
23511: rec_count := cz_pb_mgr.v_cz_ps_nodes_new_tbl.COUNT;
23512:
23513: IF (cz_pb_mgr.v_cz_ps_nodes_new_ref.COUNT > 0)
23514: THEN
23515: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
23516: LOOP
23517: rec_count := rec_count + 1;
23511: rec_count := cz_pb_mgr.v_cz_ps_nodes_new_tbl.COUNT;
23512:
23513: IF (cz_pb_mgr.v_cz_ps_nodes_new_ref.COUNT > 0)
23514: THEN
23515: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
23516: LOOP
23517: rec_count := rec_count + 1;
23518: cz_pb_mgr.v_cz_ps_nodes_new_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
23519: cz_pb_mgr.v_cz_ps_nodes_old_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_old_ref(k);
23514: THEN
23515: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
23516: LOOP
23517: rec_count := rec_count + 1;
23518: cz_pb_mgr.v_cz_ps_nodes_new_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
23519: cz_pb_mgr.v_cz_ps_nodes_old_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_old_ref(k);
23520: cz_pb_mgr.v_cz_effective_usage_mask_tbl(rec_count) := cz_pb_mgr.v_cz_effective_usage_mask_ref(k);
23521: 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);
23522: cz_pb_mgr.v_ps_refid_old_tbl(rec_count) := cz_pb_mgr.v_ps_ref_id_ref(k);
23515: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
23516: LOOP
23517: rec_count := rec_count + 1;
23518: cz_pb_mgr.v_cz_ps_nodes_new_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
23519: cz_pb_mgr.v_cz_ps_nodes_old_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_old_ref(k);
23520: cz_pb_mgr.v_cz_effective_usage_mask_tbl(rec_count) := cz_pb_mgr.v_cz_effective_usage_mask_ref(k);
23521: 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);
23522: cz_pb_mgr.v_ps_refid_old_tbl(rec_count) := cz_pb_mgr.v_ps_ref_id_ref(k);
23523:
23517: rec_count := rec_count + 1;
23518: cz_pb_mgr.v_cz_ps_nodes_new_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
23519: cz_pb_mgr.v_cz_ps_nodes_old_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_old_ref(k);
23520: cz_pb_mgr.v_cz_effective_usage_mask_tbl(rec_count) := cz_pb_mgr.v_cz_effective_usage_mask_ref(k);
23521: 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);
23522: cz_pb_mgr.v_ps_refid_old_tbl(rec_count) := cz_pb_mgr.v_ps_ref_id_ref(k);
23523:
23524: IF (cz_pb_mgr.v_cz_ps_nodes_old_ref(k) = cz_pb_mgr.v_models_to_be_exported(i))
23525: THEN
23520: cz_pb_mgr.v_cz_effective_usage_mask_tbl(rec_count) := cz_pb_mgr.v_cz_effective_usage_mask_ref(k);
23521: 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);
23522: cz_pb_mgr.v_ps_refid_old_tbl(rec_count) := cz_pb_mgr.v_ps_ref_id_ref(k);
23523:
23524: IF (cz_pb_mgr.v_cz_ps_nodes_old_ref(k) = cz_pb_mgr.v_models_to_be_exported(i))
23525: THEN
23526: cz_pb_mgr.v_new_devl_id := cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
23527: END IF;
23528:
23522: cz_pb_mgr.v_ps_refid_old_tbl(rec_count) := cz_pb_mgr.v_ps_ref_id_ref(k);
23523:
23524: IF (cz_pb_mgr.v_cz_ps_nodes_old_ref(k) = cz_pb_mgr.v_models_to_be_exported(i))
23525: THEN
23526: cz_pb_mgr.v_new_devl_id := cz_pb_mgr.v_cz_ps_nodes_new_ref(k);
23527: END IF;
23528:
23529: ------------resolve parent ids
23530: IF (cz_pb_mgr.v_ps_parent_id_ref(k) IS NOT NULL)
23528:
23529: ------------resolve parent ids
23530: IF (cz_pb_mgr.v_ps_parent_id_ref(k) IS NOT NULL)
23531: THEN
23532: IF (cz_pb_mgr.v_cz_ps_nodes_old_ref.COUNT > 0) THEN
23533: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_ref.LAST
23534: LOOP
23535: IF (cz_pb_mgr.v_ps_parent_id_ref(k) = cz_pb_mgr.v_cz_ps_nodes_old_ref(i))
23536: THEN
23529: ------------resolve parent ids
23530: IF (cz_pb_mgr.v_ps_parent_id_ref(k) IS NOT NULL)
23531: THEN
23532: IF (cz_pb_mgr.v_cz_ps_nodes_old_ref.COUNT > 0) THEN
23533: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_ref.LAST
23534: LOOP
23535: IF (cz_pb_mgr.v_ps_parent_id_ref(k) = cz_pb_mgr.v_cz_ps_nodes_old_ref(i))
23536: THEN
23537: cz_pb_mgr.v_ps_parent_id_ref(k) := cz_pb_mgr.v_cz_ps_nodes_new_ref(i);
23531: THEN
23532: IF (cz_pb_mgr.v_cz_ps_nodes_old_ref.COUNT > 0) THEN
23533: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_ref.LAST
23534: LOOP
23535: IF (cz_pb_mgr.v_ps_parent_id_ref(k) = cz_pb_mgr.v_cz_ps_nodes_old_ref(i))
23536: THEN
23537: cz_pb_mgr.v_ps_parent_id_ref(k) := cz_pb_mgr.v_cz_ps_nodes_new_ref(i);
23538: EXIT;
23539: END IF;
23533: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_ref.LAST
23534: LOOP
23535: IF (cz_pb_mgr.v_ps_parent_id_ref(k) = cz_pb_mgr.v_cz_ps_nodes_old_ref(i))
23536: THEN
23537: cz_pb_mgr.v_ps_parent_id_ref(k) := cz_pb_mgr.v_cz_ps_nodes_new_ref(i);
23538: EXIT;
23539: END IF;
23540: END LOOP;
23541: END IF;
23545: cz_pb_mgr.v_ps_eff_set_id_tbl(rec_count) := cz_pb_mgr.v_ps_eff_set_id_ref(k);
23546: cz_pb_mgr.v_ps_intl_old_tbl(rec_count) := cz_pb_mgr.v_ps_intl_old_ref(k);
23547: cz_pb_mgr.v_ps_viol_old_tbl(rec_count) := cz_pb_mgr.v_ps_viol_old_ref(k);
23548: cz_pb_mgr.v_ps_capt_rule_tbl(rec_count) := cz_pb_mgr.v_ps_capt_rule_ref(k);
23549: cz_pb_mgr.v_cz_ps_nodes_comp_tbl(rec_count) := cz_pb_mgr.v_cz_ps_nodes_comp_ref(k);
23550: cz_pb_mgr.v_ps_orig_sys_tbl(rec_count) := cz_pb_mgr.v_ps_orig_sys_ref(k);
23551: cz_pb_mgr.v_ps_comp_seq_path_tbl(rec_count) := cz_pb_mgr.v_ps_comp_seq_path_ref(k);
23552: cz_pb_mgr.v_ps_comp_seq_id_tbl(rec_count) := cz_pb_mgr.v_ps_comp_seq_id_ref(k);
23553: cz_pb_mgr.v_ps_item_id_tbl(rec_count) := cz_pb_mgr.v_ps_item_id_ref(k);
23559: END IF;
23560:
23561: cz_pb_mgr.v_models_to_be_exported_new(i) := cz_pb_mgr.v_new_devl_id;
23562:
23563: IF (cz_pb_mgr.v_cz_ps_nodes_new_ref.COUNT > 0) THEN
23564: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
23565: LOOP
23566: v_project_count := v_project_count + 1;
23567: cz_pb_mgr.v_devl_project_tbl(v_project_count) := cz_pb_mgr.v_new_devl_id;
23560:
23561: cz_pb_mgr.v_models_to_be_exported_new(i) := cz_pb_mgr.v_new_devl_id;
23562:
23563: IF (cz_pb_mgr.v_cz_ps_nodes_new_ref.COUNT > 0) THEN
23564: FOR k IN cz_pb_mgr.v_cz_ps_nodes_new_ref.FIRST .. cz_pb_mgr.v_cz_ps_nodes_new_ref.LAST
23565: LOOP
23566: v_project_count := v_project_count + 1;
23567: cz_pb_mgr.v_devl_project_tbl(v_project_count) := cz_pb_mgr.v_new_devl_id;
23568: -- cz_pb_mgr.v_intl_text_model_tbl(v_project_count) := cz_pb_mgr.v_new_devl_id;
23611: THEN
23612: log_timing_message('start bulk collect from cz_psnode_propval_v');
23613: END IF;
23614:
23615: IF (cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0) THEN
23616: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_tbl.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_tbl.LAST
23617: LOOP
23618: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
23619: l_data_type_tbl.DELETE;
23612: log_timing_message('start bulk collect from cz_psnode_propval_v');
23613: END IF;
23614:
23615: IF (cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0) THEN
23616: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_tbl.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_tbl.LAST
23617: LOOP
23618: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
23619: l_data_type_tbl.DELETE;
23620: l_prop_num_value_tbl.DELETE;
23620: l_prop_num_value_tbl.DELETE;
23621: l_def_num_value_tbl.DELETE;
23622:
23623: BEGIN
23624: l_old_psnode_id := cz_pb_mgr.v_cz_ps_nodes_old_tbl(i);
23625: l_devl_project_id := cz_pb_mgr.v_devl_project_tbl(i);
23626:
23627: IF (cz_pb_mgr.v_session_parameter <> model_copy)
23628: THEN
23720: cz_pb_mgr.v_psnode_propval_tbl(v_property_count).def_num_value := l_def_num_value_tbl(j);
23721: END IF;
23722: END LOOP;
23723: END IF; /* end if of cz_pb_mgr.v_prop_vals_node_tbl.COUNT > 0 */
23724: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_ps_nodes_old_tbl */
23725: END IF;
23726: END IF; /* cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0 */
23727: END get_all_properties;
23728: -----------------------------------------------------------------------------------------------
23722: END LOOP;
23723: END IF; /* end if of cz_pb_mgr.v_prop_vals_node_tbl.COUNT > 0 */
23724: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_ps_nodes_old_tbl */
23725: END IF;
23726: END IF; /* cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0 */
23727: END get_all_properties;
23728: -----------------------------------------------------------------------------------------------
23729: --9812709 SriniK
23730:
23864: END LOOP;
23865: END IF;
23866: END LOOP;
23867: ELSE
23868: --IF (cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0) THEN
23869:
23870: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
23871: log_timing_message('Model copystart builk collect from cz_ps_prop_vals and cz_ps_prop_vals for remote builk selectInsert');
23872: END IF;
23870: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
23871: log_timing_message('Model copystart builk collect from cz_ps_prop_vals and cz_ps_prop_vals for remote builk selectInsert');
23872: END IF;
23873:
23874: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_tbl.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_tbl.LAST
23875: LOOP
23876: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
23877: l_data_type_tbl.DELETE;
23878: l_prop_num_value_tbl.DELETE;
23878: l_prop_num_value_tbl.DELETE;
23879: l_def_num_value_tbl.DELETE;
23880:
23881: BEGIN
23882: l_old_psnode_id := cz_pb_mgr.v_cz_ps_nodes_old_tbl(i);
23883: l_devl_project_id := cz_pb_mgr.v_devl_project_tbl(i);
23884:
23885: SELECT a.ps_node_id, a.property_id, b.data_type, a.data_num_value
23886: , a.data_value, l_devl_project_id
24636: ,plsql_table_list
24637: ,'cz_pb_mgr.g_archives_old_ref'
24638: ,cz_pb_mgr.g_archives_old_ref
24639: );
24640: resolve_ids(cz_pb_mgr.g_devl_proj_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'resolve proj of archives');
24641: plsql_table_list.DELETE;
24642: rec_count := 1;
24643: plsql_table_list(rec_count).col_name := 'archive_id';
24644: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_archive_id_ref';
24709: END IF;
24710:
24711: 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');
24712: -- Need to use the right array to resolve the devl project ids.
24713: resolve_ids(cz_pb_mgr.g_devl_proj_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'resolve proj of archives');
24714: plsql_table_list.DELETE;
24715: rec_count := 1;
24716: plsql_table_list(rec_count).col_name := 'archive_id';
24717: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_archive_id_ref';