[Home] [Help]
15845: END IF;
15846:
15847: IF (cz_pb_mgr.g_log_timing = publication_timing)
15848: THEN
15849: log_timing_message('end bulk collect from cz_psnode_propval_v');
15850: END IF;
15851:
15852: IF (cz_pb_mgr.g_log_timing = publication_timing)
15853: THEN
23608: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
23609: THEN
23610: IF (cz_pb_mgr.g_log_timing = publication_timing)
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
23626:
23627: IF (cz_pb_mgr.v_session_parameter <> model_copy)
23628: THEN
23629:
23630: -- Bug 5570651: The view cz_psnode_propval_v returns records for
23631: -- REFERENCE nodes (ps_node_type:263), also. So, when publishing a model
23632: -- containing references, properties defined on the root of the referred model
23633: -- are retrieved more than once: once for the root node, and once for every node
23634: -- of type 263 referring to it. This causes publishing to create a record in
23646: , def_num_value
23647: 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
23648: , cz_pb_mgr.v_prop_vals_data_tbl, l_item_type_id_tbl, l_item_id_tbl, l_inherited_flag_tbl, l_valuesource_tbl
23649: , l_devl_project_id_tbl, l_def_num_value_tbl
23650: FROM cz_psnode_propval_v t
23651: WHERE t.ps_node_id = l_old_psnode_id
23652: AND t.ps_node_type <> PS_NODE_REF_TYPE;
23653: -----ORDER BY ps_node_id;
23654: ELSE
23749:
23750: CURSOR prop_cur (cp_model_to_be_exported NUMBER) IS
23751: SELECT ps_node_id, property_id, data_type, property_num_value,
23752: property_value, item_type_id, item_id, inherited_flag, valuesource, l_devl_project_id,
23753: def_num_value FROM cz_psnode_propval_v t
23754: WHERE t.devl_project_id = cp_model_to_be_exported
23755: AND t.ps_node_type <> PS_NODE_REF_TYPE;
23756:
23757: TYPE b_cur IS TABLE OF prop_cur%ROWTYPE
23766: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0) THEN
23767:
23768: IF (cz_pb_mgr.v_session_parameter <> model_copy) THEN
23769:
23770: -- Bug 5570651: The view cz_psnode_propval_v returns records for
23771: -- REFERENCE nodes (ps_node_type:263), also. So, when publishing a model
23772: -- containing references, properties defined on the root of the referred model
23773: -- are retrieved more than once: once for the root node, and once for every node
23774: -- of type 263 referring to it. This causes publishing to create a record in
23781: -- written with a wrong model_id. We solve this problem by excluding records with
23782: -- ps_node_type = 263 in the query below
23783:
23784: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
23785: log_timing_message('Publication start bulk collect from cz_psnode_propval_v for remote builk selectInsert');
23786: END IF;
23787:
23788: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
23789:
23797: BEGIN
23798: l_devl_project_id := cz_pb_mgr.v_devl_project_tbl(i);
23799:
23800: OPEN prop_cur(v_models_to_be_exported(i));
23801: log_timing_message('one - Publication start bulk collect from cz_psnode_propval_v for remote builk selectInsert'||v_models_to_be_exported(i));
23802:
23803: LOOP
23804: FETCH prop_cur
23805: 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,
23805: 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,
23806: cz_pb_mgr.v_prop_vals_data_tbl, l_item_type_id_tbl, l_item_id_tbl, l_inherited_flag_tbl, l_valuesource_tbl,
23807: l_devl_project_id_tbl, l_def_num_value_tbl LIMIT remote_bulk_size;
23808:
23809: log_timing_message('two - Publication start bulk collect from cz_psnode_propval_v for remote builk selectInsert'||l_prop_cur.COUNT);
23810:
23811: EXIT WHEN l_prop_cur.COUNT = 0;
23812: END LOOP;
23813: CLOSE prop_cur;