APPS.CZ_PB_MGR dependencies on CZ_PSNODE_PROPVAL_V

Line 14771: log_timing_message('end bulk collect from cz_psnode_propval_v');

14767: get_all_properties;
14768:
14769: IF (cz_pb_mgr.g_log_timing = publication_timing)
14770: THEN
14771: log_timing_message('end bulk collect from cz_psnode_propval_v');
14772: END IF;
14773:
14774: IF (cz_pb_mgr.g_log_timing = publication_timing)
14775: THEN

Line 22401: log_timing_message('start bulk collect from cz_psnode_propval_v');

22397: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
22398: THEN
22399: IF (cz_pb_mgr.g_log_timing = publication_timing)
22400: THEN
22401: log_timing_message('start bulk collect from cz_psnode_propval_v');
22402: END IF;
22403:
22404: IF (cz_pb_mgr.v_cz_ps_nodes_old_tbl.COUNT > 0) THEN
22405: FOR i IN cz_pb_mgr.v_cz_ps_nodes_old_tbl.FIRST .. cz_pb_mgr.v_cz_ps_nodes_old_tbl.LAST

Line 22419: -- Bug 5570651: The view cz_psnode_propval_v returns records for

22415:
22416: IF (cz_pb_mgr.v_session_parameter <> model_copy)
22417: THEN
22418:
22419: -- Bug 5570651: The view cz_psnode_propval_v returns records for
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

Line 22439: FROM cz_psnode_propval_v t

22435: , def_num_value
22436: 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
22437: , cz_pb_mgr.v_prop_vals_data_tbl, l_item_type_id_tbl, l_item_id_tbl, l_inherited_flag_tbl, l_valuesource_tbl
22438: , l_devl_project_id_tbl, l_def_num_value_tbl
22439: FROM cz_psnode_propval_v t
22440: WHERE t.ps_node_id = l_old_psnode_id
22441: AND t.ps_node_type <> PS_NODE_REF_TYPE;
22442: -----ORDER BY ps_node_id;
22443: ELSE