eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_PB_MGR dependencies on CZ_PS_PROP_VALS

Line 380: ELSIF(p_table_name = 'cz_ps_prop_vals')

376: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref.DELETE;
377: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
378: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
379: END IF;
380: ELSIF(p_table_name = 'cz_ps_prop_vals')
381: THEN
382: IF (p_table_type = 'tbl')
383: THEN
384: cz_pb_mgr.v_prop_vals_node_tbl.DELETE;

Line 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);

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:

Line 12437: -----procedure inserts data into cz_ps_prop_vals for non-migration session

12433: END get_rem_nodes_of_models;
12434:
12435: -------------------------------------------------------------------------------------------------------------------------------------------
12436:
12437: -----procedure inserts data into cz_ps_prop_vals for non-migration session
12438: -----@p_prop_vals_array: table of ps nodes
12439: -----@p_property_array : table of property ids
12440: -----@p_data_val_array : table of data values
12441: -----@x_status : publication status parameter

Line 12463: || 'INSERT INTO cz_ps_prop_vals'

12459: || 'cz_pb_mgr.v_propval_data_value := cz_pb_mgr.v_prop_vals_data_ref(i);'
12460: || ' '
12461: || 'cz_pb_mgr.v_propval_data_num_value := cz_pb_mgr.v_prop_vals_data_num_ref(i);'
12462: || ' '
12463: || 'INSERT INTO cz_ps_prop_vals'
12464: || cz_pb_mgr.v_db_link
12465: || '('
12466: || ' '
12467: || 'ps_node_id,PROPERTY_ID,DATA_VALUE,DELETED_FLAG,data_num_value)'

Line 12490: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);

12486: COMMIT;
12487: EXCEPTION
12488: WHEN OTHERS
12489: THEN
12490: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
12491: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
12492: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
12493: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
12494: RAISE;

Line 12491: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);

12487: EXCEPTION
12488: WHEN OTHERS
12489: THEN
12490: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
12491: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
12492: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
12493: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
12494: RAISE;
12495: END insert_into_ps_prop_vals;

Line 12498: -----procedure inserts data into cz_ps_prop_vals

12494: RAISE;
12495: END insert_into_ps_prop_vals;
12496:
12497: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12498: -----procedure inserts data into cz_ps_prop_vals
12499: -----@p_prop_vals_array: table of ps nodes
12500: -----@p_property_array : table of property ids
12501: -----@p_data_val_array : table of data values
12502: -----@x_status : publication status parameter

Line 12538: INSERT INTO cz_ps_prop_vals(PS_NODE_ID, PROPERTY_ID, DATA_VALUE, DELETED_FLAG, DATA_NUM_VALUE)

12534: END IF;
12535:
12536: FORALL i IN StIdx..EndIdx
12537:
12538: INSERT INTO cz_ps_prop_vals(PS_NODE_ID, PROPERTY_ID, DATA_VALUE, DELETED_FLAG, DATA_NUM_VALUE)
12539: VALUES (CZ_PB_MGR.v_prop_vals_node_ref(i),
12540: CZ_PB_MGR.v_prop_vals_prop_ref(i),
12541: CZ_PB_MGR.v_prop_vals_data_ref(i),
12542: '0',

Line 12648: CZ_PB_MGR.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'remote_cz_ps_prop_vals', 'SQLERRM', SQLERRM);

12644:
12645: COMMIT;
12646: EXCEPTION
12647: WHEN REMOTE_EXCEPTION THEN
12648: CZ_PB_MGR.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'remote_cz_ps_prop_vals', 'SQLERRM', SQLERRM);
12649: CZ_PB_MGR.error_msg_populate(CZ_PB_MGR.v_err_message ,'CZ_PB_MGR.LOAD_DATA:cz_ps_prop_vals',SQLCODE);
12650: CZ_PB_MGR.v_status_code := PUBLICATION_ERROR;
12651: CZ_PB_MGR.v_sql_err_msg := substr(SQLERRM,1,2000);
12652: WHEN OTHERS THEN

Line 12649: CZ_PB_MGR.error_msg_populate(CZ_PB_MGR.v_err_message ,'CZ_PB_MGR.LOAD_DATA:cz_ps_prop_vals',SQLCODE);

12645: COMMIT;
12646: EXCEPTION
12647: WHEN REMOTE_EXCEPTION THEN
12648: CZ_PB_MGR.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'remote_cz_ps_prop_vals', 'SQLERRM', SQLERRM);
12649: CZ_PB_MGR.error_msg_populate(CZ_PB_MGR.v_err_message ,'CZ_PB_MGR.LOAD_DATA:cz_ps_prop_vals',SQLCODE);
12650: CZ_PB_MGR.v_status_code := PUBLICATION_ERROR;
12651: CZ_PB_MGR.v_sql_err_msg := substr(SQLERRM,1,2000);
12652: WHEN OTHERS THEN
12653: CZ_PB_MGR.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'local_cz_ps_prop_vals', 'SQLERRM', SQLERRM);

Line 12653: CZ_PB_MGR.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'local_cz_ps_prop_vals', 'SQLERRM', SQLERRM);

12649: CZ_PB_MGR.error_msg_populate(CZ_PB_MGR.v_err_message ,'CZ_PB_MGR.LOAD_DATA:cz_ps_prop_vals',SQLCODE);
12650: CZ_PB_MGR.v_status_code := PUBLICATION_ERROR;
12651: CZ_PB_MGR.v_sql_err_msg := substr(SQLERRM,1,2000);
12652: WHEN OTHERS THEN
12653: CZ_PB_MGR.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'local_cz_ps_prop_vals', 'SQLERRM', SQLERRM);
12654: CZ_PB_MGR.error_msg_populate(CZ_PB_MGR.v_err_message ,'CZ_PB_MGR.LOAD_DATA:cz_ps_prop_vals',SQLCODE);
12655: CZ_PB_MGR.v_status_code := PUBLICATION_ERROR;
12656: CZ_PB_MGR.v_sql_err_msg := substr(SQLERRM,1,2000);
12657: RAISE;

Line 12654: CZ_PB_MGR.error_msg_populate(CZ_PB_MGR.v_err_message ,'CZ_PB_MGR.LOAD_DATA:cz_ps_prop_vals',SQLCODE);

12650: CZ_PB_MGR.v_status_code := PUBLICATION_ERROR;
12651: CZ_PB_MGR.v_sql_err_msg := substr(SQLERRM,1,2000);
12652: WHEN OTHERS THEN
12653: CZ_PB_MGR.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'local_cz_ps_prop_vals', 'SQLERRM', SQLERRM);
12654: CZ_PB_MGR.error_msg_populate(CZ_PB_MGR.v_err_message ,'CZ_PB_MGR.LOAD_DATA:cz_ps_prop_vals',SQLCODE);
12655: CZ_PB_MGR.v_status_code := PUBLICATION_ERROR;
12656: CZ_PB_MGR.v_sql_err_msg := substr(SQLERRM,1,2000);
12657: RAISE;
12658: END rm_insert_into_ps_prop_vals;

Line 12681: INSERT INTO cz_ps_prop_vals(PS_NODE_ID, PROPERTY_ID, DATA_VALUE, DELETED_FLAG, DATA_NUM_VALUE)

12677: IF (InsPsNodeId.COUNT > 0) THEN
12678:
12679:
12680: FORALL i IN InsPsNodeId.FIRST..InsPsNodeId.LAST
12681: INSERT INTO cz_ps_prop_vals(PS_NODE_ID, PROPERTY_ID, DATA_VALUE, DELETED_FLAG, DATA_NUM_VALUE)
12682: VALUES (InsPsNodeId(i), InsPropId(i), InsCharData(i), '0', InsNumData(i) );
12683:
12684: COMMIT;
12685:

Line 12714: INSERT INTO cz_ps_prop_vals(ps_node_id, property_id, data_value, data_num_value, deleted_flag)

12710: IF cz_pb_mgr.v_prop_vals_node_ref.COUNT=0 THEN RETURN; END IF;
12711:
12712: FOR i IN cz_pb_mgr.v_prop_vals_node_ref.FIRST .. cz_pb_mgr.v_prop_vals_node_ref.LAST LOOP
12713: IF cz_pb_mgr.v_prop_vals_valuesource_ref(i) = 'PsValue' OR cz_pb_mgr.v_prop_vals_valuesource_ref(i) = 'PsDflt' THEN
12714: INSERT INTO cz_ps_prop_vals(ps_node_id, property_id, data_value, data_num_value, deleted_flag)
12715: VALUES(cz_pb_mgr.v_prop_vals_node_ref(i), cz_pb_mgr.v_prop_vals_prop_ref(i),
12716: cz_pb_mgr.v_prop_vals_data_ref(i), cz_pb_mgr.v_prop_vals_data_num_ref(i), '0');
12717: END IF;
12718: END LOOP;

Line 12722: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);

12718: END LOOP;
12719: COMMIT;
12720: EXCEPTION
12721: WHEN OTHERS THEN
12722: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
12723: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
12724: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
12725: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
12726: RAISE;

Line 12723: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);

12719: COMMIT;
12720: EXCEPTION
12721: WHEN OTHERS THEN
12722: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
12723: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
12724: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
12725: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
12726: RAISE;
12727: END mc_insert_pspropvals;

Line 13206: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);

13202: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
13203: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
13204: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
13205: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
13206: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
13207: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
13208: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
13209: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
13210: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);

Line 13207: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);

13203: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
13204: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
13205: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
13206: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
13207: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
13208: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
13209: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
13210: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
13211: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);

Line 15825: ------------------insert data into cz_ps_prop_vals

15821: l_def_num_value_tbl cz_pb_mgr.t_ref;
15822: l_old_psnode_id NUMBER;
15823: BEGIN
15824:
15825: ------------------insert data into cz_ps_prop_vals
15826: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
15827: -------9812709-------------------------------------------------------------------------------------
15828: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
15829: log_timing_message('vBulkSelectInsert value : ' || vBulkSelectInsert);

Line 15826: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);

15822: l_old_psnode_id NUMBER;
15823: BEGIN
15824:
15825: ------------------insert data into cz_ps_prop_vals
15826: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
15827: -------9812709-------------------------------------------------------------------------------------
15828: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
15829: log_timing_message('vBulkSelectInsert value : ' || vBulkSelectInsert);
15830: END IF;

Line 15957: ------insert into cz_ps_prop_vals

15953: -- If this is remote model migration, we need to synchronize the properties before
15954: -- we insert into the target machine
15955: -- that will be done as part of insert item schema
15956: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR cz_pb_mgr.v_server_id = 0) THEN
15957: ------insert into cz_ps_prop_vals
15958: ------Srinik---------------------------------------
15959:
15960: IF cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model THEN
15961:

Line 15987: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);

15983: log_timing_message('end insert_into_ps_prop_vals');
15984: END IF;
15985:
15986: ---------release pl/sql tables
15987: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
15988: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
15989: END IF;
15990:
15991: ------------ populate item sub schema

Line 15988: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);

15984: END IF;
15985:
15986: ---------release pl/sql tables
15987: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
15988: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
15989: END IF;
15990:
15991: ------------ populate item sub schema
15992: IF (cz_pb_mgr.v_server_id <> 0)

Line 16001: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);

15997: -- they are being taken care of at this stage
15998: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
15999: THEN
16000: ---------release pl/sql tables
16001: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
16002: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
16003: END IF;
16004:
16005: ----------refresh model usages

Line 16002: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);

15998: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
15999: THEN
16000: ---------release pl/sql tables
16001: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
16002: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
16003: END IF;
16004:
16005: ----------refresh model usages
16006: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)

Line 17666: from cz_ps_prop_vals psp, cz_ps_nodes psn, cz_properties p

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

Line 23618: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);

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;
23621: l_def_num_value_tbl.DELETE;
23622:

Line 23635: -- cz_ps_prop_vals for the node with type 263. This is unnecessary because, when

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
23635: -- cz_ps_prop_vals for the node with type 263. This is unnecessary because, when
23636: -- getting properties for a reference node, CIO always goes to actual root of the
23637: -- referred model. In the case of this bug, the multiple records for the same property,
23638: -- each with a different devl_project_id were causing a problem when publishing
23639: -- translatable text properties. The intl_text_id to devl_project_id map (h_devl_prj_by_intl_text)

Line 23659: FROM cz_ps_prop_vals a, cz_properties b

23655: SELECT a.ps_node_id, a.property_id, b.data_type, a.data_num_value
23656: , a.data_value, l_devl_project_id
23657: 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
23658: , cz_pb_mgr.v_prop_vals_data_tbl, l_devl_project_id_tbl
23659: FROM cz_ps_prop_vals a, cz_properties b
23660: WHERE a.property_id = b.property_id AND a.ps_node_id = l_old_psnode_id AND a.deleted_flag = '0';
23661: -----ORDER BY a.ps_node_id;
23662: END IF;
23663: EXCEPTION

Line 23670: cz_pb_mgr.v_err_message := 'Error in bulk collect from cz_ps_prop_vals: ' || SQLERRM;

23666: cz_pb_mgr.v_err_message := 'No nodes were found in prop vals view ';
23667: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PROPVALS', SQLCODE);
23668: WHEN OTHERS
23669: THEN
23670: cz_pb_mgr.v_err_message := 'Error in bulk collect from cz_ps_prop_vals: ' || SQLERRM;
23671: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PROPVALS', SQLCODE);
23672: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
23673: RAISE;
23674: END;

Line 23775: -- cz_ps_prop_vals for the node with type 263. This is unnecessary because, when

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
23775: -- cz_ps_prop_vals for the node with type 263. This is unnecessary because, when
23776: -- getting properties for a reference node, CIO always goes to actual root of the
23777: -- referred model. In the case of this bug, the multiple records for the same property,
23778: -- each with a different devl_project_id were causing a problem when publishing
23779: -- translatable text properties. The intl_text_id to devl_project_id map (h_devl_prj_by_intl_text)

Line 23791: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);

23787:
23788: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
23789:
23790: LOOP
23791: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
23792: l_data_type_tbl.DELETE;
23793: l_prop_num_value_tbl.DELETE;
23794: l_def_num_value_tbl.DELETE;
23795: -- t_rowid.DELETE;

Line 23822: cz_pb_mgr.v_err_message := 'Error in bulk collect from cz_ps_prop_vals: ' || SQLERRM;

23818: cz_pb_mgr.v_err_message := 'No nodes were found in prop vals view ';
23819: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PROPVALS', SQLCODE);
23820: WHEN OTHERS
23821: THEN
23822: cz_pb_mgr.v_err_message := 'Error in bulk collect from cz_ps_prop_vals: ' || SQLERRM;
23823: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PROPVALS', SQLCODE);
23824: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
23825: RAISE;
23826: END;

Line 23871: log_timing_message('Model copystart builk collect from cz_ps_prop_vals and cz_ps_prop_vals for remote builk selectInsert');

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;
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

Line 23876: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);

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;
23879: l_def_num_value_tbl.DELETE;
23880:

Line 23889: FROM cz_ps_prop_vals a, cz_properties b

23885: SELECT a.ps_node_id, a.property_id, b.data_type, a.data_num_value
23886: , a.data_value, l_devl_project_id
23887: 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
23888: , cz_pb_mgr.v_prop_vals_data_tbl, l_devl_project_id_tbl
23889: FROM cz_ps_prop_vals a, cz_properties b
23890: WHERE a.property_id = b.property_id AND a.ps_node_id = l_old_psnode_id
23891: AND a.deleted_flag = '0';
23892:
23893: EXCEPTION

Line 23895: cz_pb_mgr.v_err_message := 'Model copy No nodes were found in cz_ps_prop_vals and cz_properties';

23891: AND a.deleted_flag = '0';
23892:
23893: EXCEPTION
23894: WHEN NO_DATA_FOUND THEN
23895: cz_pb_mgr.v_err_message := 'Model copy No nodes were found in cz_ps_prop_vals and cz_properties';
23896: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PROPVALS', SQLCODE);
23897: WHEN OTHERS THEN
23898: cz_pb_mgr.v_err_message := 'Model copy Error in bulk collect from cz_ps_prop_vals and cz_properties: ' || SQLERRM;
23899: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PROPVALS', SQLCODE);

Line 23898: cz_pb_mgr.v_err_message := 'Model copy Error in bulk collect from cz_ps_prop_vals and cz_properties: ' || SQLERRM;

23894: WHEN NO_DATA_FOUND THEN
23895: cz_pb_mgr.v_err_message := 'Model copy No nodes were found in cz_ps_prop_vals and cz_properties';
23896: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PROPVALS', SQLCODE);
23897: WHEN OTHERS THEN
23898: cz_pb_mgr.v_err_message := 'Model copy Error in bulk collect from cz_ps_prop_vals and cz_properties: ' || SQLERRM;
23899: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PROPVALS', SQLCODE);
23900: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
23901: RAISE;
23902: END;

Line 24056: --We do not need the default value, because here we prepare data to be inserted into cz_ps_prop_vals, and

24052: --The ps_node_id value has been already resolved to the new id in upload_item_schema after get_all_properties.
24053: --So we need to query for this value, or, if there's no such value, than the ps_node_id will be created and
24054: --should inherit the property value.
24055:
24056: --We do not need the default value, because here we prepare data to be inserted into cz_ps_prop_vals, and
24057: --this table does not store default values. What we need is a value in mm_v_ht_sync_all_prop_val_num(j) for
24058: --every pair of t_prop_id, v_prop_vals_node_ref(j).
24059:
24060: IF(cz_pb_mgr.v_prop_vals_data_typ_ref(j) = 8)THEN /*Translatable properties*/

Line 24107: --This block selects from all the properties only those that come from cz_ps_prop_vals, as

24103:
24104: mm_v_ht_sync_it_propval_itm(s_item_id) := t_item_id;
24105: END IF;
24106:
24107: --This block selects from all the properties only those that come from cz_ps_prop_vals, as
24108: --mm_v_ht_sync_ps_propval is used in mm_migrate_into_ps_prop_vals as one of the criteria
24109: --whether to insert the value into cz_ps_prop_vals.
24110:
24111: IF(mm_get_ifexists_on_source(s_prop_id, 'PSPROPVAL') = '1')THEN

Line 24109: --whether to insert the value into cz_ps_prop_vals.

24105: END IF;
24106:
24107: --This block selects from all the properties only those that come from cz_ps_prop_vals, as
24108: --mm_v_ht_sync_ps_propval is used in mm_migrate_into_ps_prop_vals as one of the criteria
24109: --whether to insert the value into cz_ps_prop_vals.
24110:
24111: IF(mm_get_ifexists_on_source(s_prop_id, 'PSPROPVAL') = '1')THEN
24112:
24113: mm_v_ht_sync_ps_propval(s_prop_id) := t_prop_id;

Line 24147: --because it is used for insert into cz_ps_prop_vals. We do need to populate the table

24143: mm_v_tbl_sync_prop(s_prop_id) := t_prop_id;
24144:
24145: --Because the property does not exist on the target, we will be creating a new property and so we need the
24146: --default numeric value. Note that we should not populate array mm_v_ht_sync_all_prop_val_num in this block
24147: --because it is used for insert into cz_ps_prop_vals. We do need to populate the table
24148: --mm_v_tbl_sync_prop_vals_num with default numeric values of all properties that will be inserted on the
24149: --target, just like in the previous block.
24150:
24151: IF(cz_pb_mgr.v_item_prop_data_typ_tbl(j) = 8)THEN /*Tranlatable properties*/

Line 24277: FROM cz_ps_prop_vals

24273: SELECT '1'
24274: INTO record_exists
24275: FROM DUAL
24276: WHERE EXISTS(SELECT property_id
24277: FROM cz_ps_prop_vals
24278: WHERE property_id = source_id);
24279: ELSIF(what_exists = 'ITPROPVAL')
24280: THEN
24281: SELECT '1'

Line 24450: -----procedure inserts data into cz_ps_prop_vals

24446:
24447: END mm_get_newid;
24448:
24449: ------------------------------------------------------------------------------------------------
24450: -----procedure inserts data into cz_ps_prop_vals
24451: PROCEDURE mm_migrate_into_ps_prop_vals
24452: AS
24453: v_migrate_error NUMBER := 0;
24454: l_sql_str VARCHAR2(32000);

Line 24500: || 'INSERT INTO cz_ps_prop_vals'

24496: || 'cz_pb_mgr.v_propval_data_value := cz_pb_mgr.v_prop_vals_data_ref(i);'
24497: || ' '
24498: || 'cz_pb_mgr.v_propval_data_num_value := cz_pb_mgr.mm_v_ht_sync_all_prop_val_num(i);'
24499: || ' '
24500: || 'INSERT INTO cz_ps_prop_vals'
24501: || cz_pb_mgr.v_db_link
24502: || '('
24503: || ' '
24504: || 'ps_node_id,PROPERTY_ID,DATA_VALUE,DELETED_FLAG,data_num_value)'

Line 24531: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);

24527: COMMIT;
24528: EXCEPTION
24529: WHEN OTHERS
24530: THEN
24531: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
24532: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
24533: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
24534: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
24535: RAISE;

Line 24532: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);

24528: EXCEPTION
24529: WHEN OTHERS
24530: THEN
24531: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
24532: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
24533: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
24534: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
24535: RAISE;
24536: END mm_migrate_into_ps_prop_vals;