[Home] [Help]
1121: v_insertstring := v_insertstring || ' IF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_TYPE_PROPERTIES'') THEN ';
1122: v_insertstring := v_insertstring || ' UPDATE cz_item_type_properties' || cz_pb_mgr.v_db_link || ' SET DELETED_FLAG = ''0'' ';
1123: v_insertstring := v_insertstring || ' WHERE ITEM_TYPE_ID = ' || plsql_table_name1 || '(m) ';
1124: v_insertstring := v_insertstring || ' AND PROPERTY_ID = ' || plsql_table_name2 || '(m); ';
1125: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_PROPERTY_VALUES'') THEN ';
1126: v_insertstring :=
1127: v_insertstring || ' UPDATE cz_item_property_values' || cz_pb_mgr.v_db_link || ' t SET ( PROPERTY_VALUE )= (SELECT PROPERTY_VALUE ';
1128: v_insertstring := v_insertstring || ' FROM cz_item_property_values WHERE PROPERTY_ID = ' || plsql_table_name1 || '(m) ';
1129: v_insertstring :=
1123: v_insertstring := v_insertstring || ' WHERE ITEM_TYPE_ID = ' || plsql_table_name1 || '(m) ';
1124: v_insertstring := v_insertstring || ' AND PROPERTY_ID = ' || plsql_table_name2 || '(m); ';
1125: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_PROPERTY_VALUES'') THEN ';
1126: v_insertstring :=
1127: v_insertstring || ' UPDATE cz_item_property_values' || cz_pb_mgr.v_db_link || ' t SET ( PROPERTY_VALUE )= (SELECT PROPERTY_VALUE ';
1128: v_insertstring := v_insertstring || ' FROM cz_item_property_values WHERE PROPERTY_ID = ' || plsql_table_name1 || '(m) ';
1129: v_insertstring :=
1130: v_insertstring || ' AND ITEM_ID = ' || plsql_table_name2 || '(m) ) WHERE t.PROPERTY_ID = ' || plsql_table_name1 || '(m) ';
1131: v_insertstring := v_insertstring || ' AND t.ITEM_ID = ' || plsql_table_name2 || '(m); ';
1124: v_insertstring := v_insertstring || ' AND PROPERTY_ID = ' || plsql_table_name2 || '(m); ';
1125: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_PROPERTY_VALUES'') THEN ';
1126: v_insertstring :=
1127: v_insertstring || ' UPDATE cz_item_property_values' || cz_pb_mgr.v_db_link || ' t SET ( PROPERTY_VALUE )= (SELECT PROPERTY_VALUE ';
1128: v_insertstring := v_insertstring || ' FROM cz_item_property_values WHERE PROPERTY_ID = ' || plsql_table_name1 || '(m) ';
1129: v_insertstring :=
1130: v_insertstring || ' AND ITEM_ID = ' || plsql_table_name2 || '(m) ) WHERE t.PROPERTY_ID = ' || plsql_table_name1 || '(m) ';
1131: v_insertstring := v_insertstring || ' AND t.ITEM_ID = ' || plsql_table_name2 || '(m); ';
1132: v_insertstring := v_insertstring || ' END IF; END; END LOOP; COMMIT; END; ';
1516: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array1';
1517: rec_count := rec_count + 1;
1518: plsql_table_list(rec_count).col_name := 'item_id';
1519: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array2';
1520: insert_item_tables('cz_item_property_values'
1521: ,'item_id'
1522: ,'property_id'
1523: ,cz_pb_mgr.v_db_link
1524: ,plsql_table_list
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:
16652:
16653: BEGIN
16654: SELECT property_id, item_id
16655: BULK COLLECT INTO cz_pb_mgr.v_it_prop_vals_id_ref, cz_pb_mgr.v_it_prop_vals_item_ref
16656: FROM cz_item_property_values
16657: WHERE cz_item_property_values.item_id = cz_pb_mgr.v_item_masters_tbl(i) AND deleted_flag = '0';
16658: EXCEPTION
16659: WHEN NO_DATA_FOUND
16660: THEN
16653: BEGIN
16654: SELECT property_id, item_id
16655: BULK COLLECT INTO cz_pb_mgr.v_it_prop_vals_id_ref, cz_pb_mgr.v_it_prop_vals_item_ref
16656: FROM cz_item_property_values
16657: WHERE cz_item_property_values.item_id = cz_pb_mgr.v_item_masters_tbl(i) AND deleted_flag = '0';
16658: EXCEPTION
16659: WHEN NO_DATA_FOUND
16660: THEN
16661: cz_pb_mgr.v_err_message := 'No item property value found for item id: ' || TO_CHAR(cz_pb_mgr.v_item_masters_tbl(i));
22634:
22635: s_item_id := v_prop_vals_item_id_ref(j);
22636:
22637: --If s_item_id is not null, than the value is defined on the item, not on the ps node.
22638: --If the value exists on the source in cz_item_property_values, than the value is defined
22639: --on the item directly, not through item type.
22640:
22641: IF((s_item_id IS NOT NULL) AND (mm_get_ifexists_on_source(s_prop_id, 'ITPROPVAL') = '1'))THEN
22642:
22677:
22678: --Now we deal with properties associated with Item Types.
22679:
22680: --This is the same algorithm as above, but the sources of property_id and property_num_value are different arrays and
22681: --a different query must be used (against cz_item_property_values) when the property and the item exist on the target.
22682: --For item_id, the second part of the above block must be useful.
22683:
22684: IF(cz_pb_mgr.v_item_prop_type_tbl.COUNT > 0)THEN
22685:
22837: SELECT '1'
22838: INTO record_exists
22839: FROM DUAL
22840: WHERE EXISTS(SELECT property_id
22841: FROM cz_item_property_values
22842: WHERE property_id = source_id);
22843: END IF;
22844:
22845: RETURN record_exists;