[Home] [Help]
327: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref.DELETE;
328: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
329: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
330: END IF;
331: ELSIF(p_table_name = 'cz_ps_prop_vals')
332: THEN
333: IF (p_table_type = 'tbl')
334: THEN
335: cz_pb_mgr.v_prop_vals_node_tbl.DELETE;
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'
11676: RAISE;
11677: END get_rem_nodes_of_models;
11678:
11679: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11680: -----procedure inserts data into cz_ps_prop_vals for non-migration session
11681: -----@p_prop_vals_array: table of ps nodes
11682: -----@p_property_array : table of property ids
11683: -----@p_data_val_array : table of data values
11684: -----@x_status : publication status parameter
11702: || 'cz_pb_mgr.v_propval_data_value := cz_pb_mgr.v_prop_vals_data_ref(i);'
11703: || ' '
11704: || 'cz_pb_mgr.v_propval_data_num_value := cz_pb_mgr.v_prop_vals_data_num_ref(i);'
11705: || ' '
11706: || 'INSERT INTO cz_ps_prop_vals'
11707: || cz_pb_mgr.v_db_link
11708: || '('
11709: || ' '
11710: || 'ps_node_id,PROPERTY_ID,DATA_VALUE,DELETED_FLAG,data_num_value)'
11729: COMMIT;
11730: EXCEPTION
11731: WHEN OTHERS
11732: THEN
11733: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
11734: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
11735: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11736: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
11737: RAISE;
11730: EXCEPTION
11731: WHEN OTHERS
11732: THEN
11733: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
11734: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
11735: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11736: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
11737: RAISE;
11738: END insert_into_ps_prop_vals;
11746: IF cz_pb_mgr.v_prop_vals_node_ref.COUNT=0 THEN RETURN; END IF;
11747:
11748: FOR i IN cz_pb_mgr.v_prop_vals_node_ref.FIRST .. cz_pb_mgr.v_prop_vals_node_ref.LAST LOOP
11749: IF cz_pb_mgr.v_prop_vals_valuesource_ref(i) = 'PsValue' OR cz_pb_mgr.v_prop_vals_valuesource_ref(i) = 'PsDflt' THEN
11750: INSERT INTO cz_ps_prop_vals(ps_node_id, property_id, data_value, data_num_value, deleted_flag)
11751: VALUES(cz_pb_mgr.v_prop_vals_node_ref(i), cz_pb_mgr.v_prop_vals_prop_ref(i),
11752: cz_pb_mgr.v_prop_vals_data_ref(i), cz_pb_mgr.v_prop_vals_data_num_ref(i), '0');
11753: END IF;
11754: END LOOP;
11754: END LOOP;
11755: COMMIT;
11756: EXCEPTION
11757: WHEN OTHERS THEN
11758: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
11759: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
11760: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11761: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
11762: RAISE;
11755: COMMIT;
11756: EXCEPTION
11757: WHEN OTHERS THEN
11758: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
11759: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
11760: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11761: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
11762: RAISE;
11763: END mc_insert_pspropvals;
12210: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
12211: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
12212: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
12213: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
12214: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
12215: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
12216: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
12217: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
12218: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
12211: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
12212: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
12213: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
12214: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
12215: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
12216: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
12217: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
12218: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
12219: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
14761: l_def_num_value_tbl cz_pb_mgr.t_ref;
14762: l_old_psnode_id NUMBER;
14763: BEGIN
14764:
14765: ------------------insert data into cz_ps_prop_vals
14766: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
14767: get_all_properties;
14768:
14769: IF (cz_pb_mgr.g_log_timing = publication_timing)
14762: l_old_psnode_id NUMBER;
14763: BEGIN
14764:
14765: ------------------insert data into cz_ps_prop_vals
14766: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
14767: get_all_properties;
14768:
14769: IF (cz_pb_mgr.g_log_timing = publication_timing)
14770: THEN
14856: -- If this is remote model migration, we need to synchronize the properties before
14857: -- we insert into the target machine
14858: -- that will be done as part of insert item schema
14859: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR cz_pb_mgr.v_server_id = 0) THEN
14860: ------insert into cz_ps_prop_vals
14861: IF cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model THEN
14862: insert_into_ps_prop_vals;
14863: ELSE
14864: mc_insert_pspropvals;
14869: log_timing_message('end insert_into_ps_prop_vals');
14870: END IF;
14871:
14872: ---------release pl/sql tables
14873: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
14874: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
14875: END IF;
14876:
14877: ------------ populate item sub schema
14870: END IF;
14871:
14872: ---------release pl/sql tables
14873: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
14874: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
14875: END IF;
14876:
14877: ------------ populate item sub schema
14878: IF (cz_pb_mgr.v_server_id <> 0)
14883: -- they are being taken care of at this stage
14884: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
14885: THEN
14886: ---------release pl/sql tables
14887: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
14888: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
14889: END IF;
14890:
14891: ----------refresh model usages
14884: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
14885: THEN
14886: ---------release pl/sql tables
14887: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
14888: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
14889: END IF;
14890:
14891: ----------refresh model usages
14892: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
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
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;
22410: l_def_num_value_tbl.DELETE;
22411:
22420: -- REFERENCE nodes (ps_node_type:263), also. So, when publishing a model
22421: -- containing references, properties defined on the root of the referred model
22422: -- are retrieved more than once: once for the root node, and once for every node
22423: -- of type 263 referring to it. This causes publishing to create a record in
22424: -- cz_ps_prop_vals for the node with type 263. This is unnecessary because, when
22425: -- getting properties for a reference node, CIO always goes to actual root of the
22426: -- referred model. In the case of this bug, the multiple records for the same property,
22427: -- each with a different devl_project_id were causing a problem when publishing
22428: -- translatable text properties. The intl_text_id to devl_project_id map (h_devl_prj_by_intl_text)
22444: SELECT a.ps_node_id, a.property_id, b.data_type, a.data_num_value
22445: , a.data_value, l_devl_project_id
22446: BULK COLLECT INTO cz_pb_mgr.v_prop_vals_node_tbl, cz_pb_mgr.v_prop_vals_prop_tbl, l_data_type_tbl, l_prop_num_value_tbl
22447: , cz_pb_mgr.v_prop_vals_data_tbl, l_devl_project_id_tbl
22448: FROM cz_ps_prop_vals a, cz_properties b
22449: WHERE a.property_id = b.property_id AND a.ps_node_id = l_old_psnode_id AND a.deleted_flag = '0';
22450: -----ORDER BY a.ps_node_id;
22451: END IF;
22452: EXCEPTION
22455: cz_pb_mgr.v_err_message := 'No nodes were found in prop vals view ';
22456: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PROPVALS', SQLCODE);
22457: WHEN OTHERS
22458: THEN
22459: cz_pb_mgr.v_err_message := 'Error in bulk collect from cz_ps_prop_vals: ' || SQLERRM;
22460: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PROPVALS', SQLCODE);
22461: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
22462: RAISE;
22463: END;
22610: --The ps_node_id value has been already resolved to the new id in upload_item_schema after get_all_properties.
22611: --So we need to query for this value, or, if there's no such value, than the ps_node_id will be created and
22612: --should inherit the property value.
22613:
22614: --We do not need the default value, because here we prepare data to be inserted into cz_ps_prop_vals, and
22615: --this table does not store default values. What we need is a value in mm_v_ht_sync_all_prop_val_num(j) for
22616: --every pair of t_prop_id, v_prop_vals_node_ref(j).
22617:
22618: IF(cz_pb_mgr.v_prop_vals_data_typ_ref(j) = 8)THEN /*Translatable properties*/
22661:
22662: mm_v_ht_sync_it_propval_itm(s_item_id) := t_item_id;
22663: END IF;
22664:
22665: --This block selects from all the properties only those that come from cz_ps_prop_vals, as
22666: --mm_v_ht_sync_ps_propval is used in mm_migrate_into_ps_prop_vals as one of the criteria
22667: --whether to insert the value into cz_ps_prop_vals.
22668:
22669: IF(mm_get_ifexists_on_source(s_prop_id, 'PSPROPVAL') = '1')THEN
22663: END IF;
22664:
22665: --This block selects from all the properties only those that come from cz_ps_prop_vals, as
22666: --mm_v_ht_sync_ps_propval is used in mm_migrate_into_ps_prop_vals as one of the criteria
22667: --whether to insert the value into cz_ps_prop_vals.
22668:
22669: IF(mm_get_ifexists_on_source(s_prop_id, 'PSPROPVAL') = '1')THEN
22670:
22671: mm_v_ht_sync_ps_propval(s_prop_id) := t_prop_id;
22701: mm_v_tbl_sync_prop(s_prop_id) := t_prop_id;
22702:
22703: --Because the property does not exist on the target, we will be creating a new property and so we need the
22704: --default numeric value. Note that we should not populate array mm_v_ht_sync_all_prop_val_num in this block
22705: --because it is used for insert into cz_ps_prop_vals. We do need to populate the table
22706: --mm_v_tbl_sync_prop_vals_num with default numeric values of all properties that will be inserted on the
22707: --target, just like in the previous block.
22708:
22709: IF(cz_pb_mgr.v_item_prop_data_typ_tbl(j) = 8)THEN /*Tranlatable properties*/
22829: SELECT '1'
22830: INTO record_exists
22831: FROM DUAL
22832: WHERE EXISTS(SELECT property_id
22833: FROM cz_ps_prop_vals
22834: WHERE property_id = source_id);
22835: ELSIF(what_exists = 'ITPROPVAL')
22836: THEN
22837: SELECT '1'
22993:
22994: END mm_get_newid;
22995:
22996: ------------------------------------------------------------------------------------------------
22997: -----procedure inserts data into cz_ps_prop_vals
22998: PROCEDURE mm_migrate_into_ps_prop_vals
22999: AS
23000: v_migrate_error NUMBER := 0;
23001: l_sql_str VARCHAR2(32000);
23043: || 'cz_pb_mgr.v_propval_data_value := cz_pb_mgr.v_prop_vals_data_ref(i);'
23044: || ' '
23045: || 'cz_pb_mgr.v_propval_data_num_value := cz_pb_mgr.mm_v_ht_sync_all_prop_val_num(i);'
23046: || ' '
23047: || 'INSERT INTO cz_ps_prop_vals'
23048: || cz_pb_mgr.v_db_link
23049: || '('
23050: || ' '
23051: || 'ps_node_id,PROPERTY_ID,DATA_VALUE,DELETED_FLAG,data_num_value)'
23074: COMMIT;
23075: EXCEPTION
23076: WHEN OTHERS
23077: THEN
23078: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
23079: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
23080: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
23081: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
23082: RAISE;
23075: EXCEPTION
23076: WHEN OTHERS
23077: THEN
23078: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
23079: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
23080: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
23081: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
23082: RAISE;
23083: END mm_migrate_into_ps_prop_vals;