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_PROPERTIES

Line 1214: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_PROPERTIES'') THEN ';

1210: v_insertstring := v_insertstring || ' = (SELECT DESC_TEXT,NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04 ';
1211: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF ';
1212: v_insertstring := v_insertstring || ' FROM cz_item_types WHERE cz_item_types.item_type_id = ' || plsql_table_name || '(m) ';
1213: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'') WHERE t.item_type_id = ' || plsql_table_name || '(m); ';
1214: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_PROPERTIES'') THEN ';
1215: v_insertstring := v_insertstring || ' UPDATE cz_properties' || cz_pb_mgr.v_db_link || ' t ';
1216: v_insertstring := v_insertstring || ' SET ( PROPERTY_UNIT,DESC_TEXT,NAME,DATA_TYPE,DEF_VALUE,USER_NUM01 ';
1217: v_insertstring := v_insertstring || ' ,USER_NUM02,USER_NUM03,USER_NUM04,USER_STR01,USER_STR02,USER_STR03,USER_STR04 ';
1218: v_insertstring := v_insertstring || ' ,DELETED_FLAG,EFF_FROM,EFF_TO,ORIG_SYS_REF) = (SELECT PROPERTY_UNIT,DESC_TEXT,';

Line 1215: v_insertstring := v_insertstring || ' UPDATE cz_properties' || cz_pb_mgr.v_db_link || ' t ';

1211: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF ';
1212: v_insertstring := v_insertstring || ' FROM cz_item_types WHERE cz_item_types.item_type_id = ' || plsql_table_name || '(m) ';
1213: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'') WHERE t.item_type_id = ' || plsql_table_name || '(m); ';
1214: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_PROPERTIES'') THEN ';
1215: v_insertstring := v_insertstring || ' UPDATE cz_properties' || cz_pb_mgr.v_db_link || ' t ';
1216: v_insertstring := v_insertstring || ' SET ( PROPERTY_UNIT,DESC_TEXT,NAME,DATA_TYPE,DEF_VALUE,USER_NUM01 ';
1217: v_insertstring := v_insertstring || ' ,USER_NUM02,USER_NUM03,USER_NUM04,USER_STR01,USER_STR02,USER_STR03,USER_STR04 ';
1218: v_insertstring := v_insertstring || ' ,DELETED_FLAG,EFF_FROM,EFF_TO,ORIG_SYS_REF) = (SELECT PROPERTY_UNIT,DESC_TEXT,';
1219: v_insertstring := v_insertstring || ' NAME,DATA_TYPE,DEF_VALUE,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,';

Line 1221: v_insertstring := v_insertstring || ' EFF_TO,ORIG_SYS_REF FROM cz_properties ';

1217: v_insertstring := v_insertstring || ' ,USER_NUM02,USER_NUM03,USER_NUM04,USER_STR01,USER_STR02,USER_STR03,USER_STR04 ';
1218: v_insertstring := v_insertstring || ' ,DELETED_FLAG,EFF_FROM,EFF_TO,ORIG_SYS_REF) = (SELECT PROPERTY_UNIT,DESC_TEXT,';
1219: v_insertstring := v_insertstring || ' NAME,DATA_TYPE,DEF_VALUE,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,';
1220: v_insertstring := v_insertstring || ' USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,EFF_FROM,';
1221: v_insertstring := v_insertstring || ' EFF_TO,ORIG_SYS_REF FROM cz_properties ';
1222: v_insertstring := v_insertstring || ' WHERE cz_properties.property_id = ' || plsql_table_name || '(m) ';
1223: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'') WHERE t.property_id = ' || plsql_table_name || '(m); ';
1224: v_insertstring := v_insertstring || ' END IF; END; END LOOP; COMMIT; END; ';
1225:

Line 1222: v_insertstring := v_insertstring || ' WHERE cz_properties.property_id = ' || plsql_table_name || '(m) ';

1218: v_insertstring := v_insertstring || ' ,DELETED_FLAG,EFF_FROM,EFF_TO,ORIG_SYS_REF) = (SELECT PROPERTY_UNIT,DESC_TEXT,';
1219: v_insertstring := v_insertstring || ' NAME,DATA_TYPE,DEF_VALUE,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,';
1220: v_insertstring := v_insertstring || ' USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,EFF_FROM,';
1221: v_insertstring := v_insertstring || ' EFF_TO,ORIG_SYS_REF FROM cz_properties ';
1222: v_insertstring := v_insertstring || ' WHERE cz_properties.property_id = ' || plsql_table_name || '(m) ';
1223: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'') WHERE t.property_id = ' || plsql_table_name || '(m); ';
1224: v_insertstring := v_insertstring || ' END IF; END; END LOOP; COMMIT; END; ';
1225:
1226: EXECUTE IMMEDIATE v_insertstring;

Line 1412: /* Procedure to insert dev num val for translateable properties of CZ_PROPERTIES into localized texts*/

1408:
1409: COMMIT;
1410: END insert_item_tables;
1411:
1412: /* Procedure to insert dev num val for translateable properties of CZ_PROPERTIES into localized texts*/
1413:
1414: PROCEDURE mm_ins_def_num_val_in_intl AS
1415: l_sql_str varchar2(4000);
1416: lang_count number;

Line 1770: insert_into_item_tables('cz_properties'

1766:
1767: plsql_table_list(rec_count).col_name := 'def_num_value';
1768: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array2';
1769:
1770: insert_into_item_tables('cz_properties'
1771: ,'property_id'
1772: ,cz_pb_mgr.v_db_link
1773: ,plsql_table_list
1774: ,'cz_pb_mgr.mm_source_array1'

Line 1802: insert_into_item_tables('cz_properties'

1798: );
1799: ELSE
1800: plsql_table_list(rec_count).col_name := 'property_id';
1801: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_remote_prop_ref';
1802: insert_into_item_tables('cz_properties'
1803: ,'property_id'
1804: ,cz_pb_mgr.v_db_link
1805: ,plsql_table_list
1806: ,'cz_pb_mgr.v_remote_prop_ref'

Line 17217: v_prop_id cz_properties.property_id%TYPE;

17213: END upload_rule_schema;
17214: -----------------------------------------------------------------------------------------------------
17215: PROCEDURE mm_raiseallpossiblesyncerrors
17216: AS
17217: v_prop_id cz_properties.property_id%TYPE;
17218: v_error_flag PLS_INTEGER := 0;
17219: v_null PLS_INTEGER;
17220: j PLS_INTEGER;
17221: v_target_item_type_name cz_item_types.name%TYPE;

Line 17236: EXECUTE IMMEDIATE 'SELECT data_type FROM cz_properties'

17232: -- USAGE: Name does not match, but there are already 64 Usages
17233: FOR i IN 1 .. v_remote_prop_ref.COUNT
17234: LOOP
17235: BEGIN
17236: EXECUTE IMMEDIATE 'SELECT data_type FROM cz_properties'
17237: || cz_pb_mgr.v_db_link
17238: || ' WHERE deleted_flag = ''0'' AND name = :1 AND NVL(src_application_id, 0) = :2'
17239: INTO v_null
17240: USING v_property_record_ref(v_remote_prop_ref(i)).NAME, v_property_record_ref(v_remote_prop_ref(i)).src_application_id;

Line 17279: || ' cz_properties'

17275: || 'it, '
17276: || ' cz_item_type_properties'
17277: || cz_pb_mgr.v_db_link
17278: || 'tp, '
17279: || ' cz_properties'
17280: || cz_pb_mgr.v_db_link
17281: || ' pr '
17282: || ' WHERE it.deleted_flag = ''0'''
17283: || ' AND pr.deleted_flag = ''0'''

Line 17660: from cz_item_masters im, cz_item_type_properties itp, cz_ps_nodes psn, cz_properties p

17656: BEGIN
17657: SELECT property_id, data_type, name, src_application_id
17658: BULK COLLECT INTO v_remote_prop_tbl, v_prop_type_tbl, v_prop_name_tbl, v_prop_src_app_tbl
17659: FROM (SELECT itp.property_id, p.data_type, p.name, nvl(p.src_application_id, 0) AS src_application_id
17660: from cz_item_masters im, cz_item_type_properties itp, cz_ps_nodes psn, cz_properties p
17661: where psn.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) and psn.deleted_flag = '0'
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

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 17672: from cz_ps_nodes psn, cz_item_property_values ipv, cz_properties p

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
17671: SELECT ipv.property_id, p.data_type, p.name, nvl(p.src_application_id, 0) AS src_application_id
17672: from cz_ps_nodes psn, cz_item_property_values ipv, cz_properties p
17673: where psn.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) and psn.item_id = ipv.item_id
17674: and psn.deleted_flag = '0' and ipv.deleted_flag = '0' and ipv.property_id = p.property_id
17675: and p.deleted_flag = '0');
17676:

Line 17733: FROM cz_item_type_properties itp, cz_properties p

17729: ,NVL(itp.orig_sys_ref, cz_pb_mgr.null_string)),NVL(itp.orig_sys_ref, cz_pb_mgr.null_string)
17730: BULK COLLECT INTO cz_pb_mgr.v_item_prop_id_ref, cz_pb_mgr.v_item_prop_type_ref
17731: ,cz_pb_mgr.v_item_prop_num_val_ref, cz_pb_mgr.v_item_prop_data_typ_ref
17732: ,v_tgt_item_type_prop_orig_ref, v_src_item_type_prop_orig_ref
17733: FROM cz_item_type_properties itp, cz_properties p
17734: WHERE itp.item_type_id = cz_pb_mgr.v_item_types_new_ref(i)
17735: AND p.deleted_flag = '0'
17736: AND itp.property_id =p.property_id
17737: AND itp.deleted_flag = '0';

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 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 24027: --mm_v_tbl_sync_prop_vals_num: contains all new def num vals which need to be inserted into cz_properties

24023: t_prop_val_num := cz_pb_mgr.v_prop_vals_data_num_ref(j); /*Other properties dont need new intl_text_id*/
24024: new_def_num_val := v_prop_vals_def_num_value_ref(j);
24025: END IF;
24026:
24027: --mm_v_tbl_sync_prop_vals_num: contains all new def num vals which need to be inserted into cz_properties
24028:
24029: --Making mm_v_tbl_sync_prop_vals_num a hash table. Now it cannot be used directly in the only place where
24030: --it is currently used - insert_item_schema. Will need to construct an array with the values from this
24031: --hash table.

Line 24169: --mm_v_tbl_sync_prop_vals_num: contains all new def num vals which need to be inserted into cz_properties

24165:
24166: new_def_num_val := cz_pb_mgr.v_item_prop_num_val_tbl(j);
24167: END IF;
24168:
24169: --mm_v_tbl_sync_prop_vals_num: contains all new def num vals which need to be inserted into cz_properties
24170:
24171: mm_v_tbl_sync_prop_vals_num(t_prop_id) := new_def_num_val;
24172: ELSE /*get the def num values of properties on target*/
24173:

Line 24177: EXECUTE IMMEDIATE 'SELECT def_num_value FROM cz_properties' || cz_pb_mgr.v_db_link ||

24173:
24174: --The property exists on the target, so t_prop_id is not null. Again, these are properties associated with item types,
24175: --so we need only the default numeric value. This query cannot fail with NO_DATA_FOUND.
24176:
24177: EXECUTE IMMEDIATE 'SELECT def_num_value FROM cz_properties' || cz_pb_mgr.v_db_link ||
24178: ' WHERE property_id = :1 AND deleted_flag = 0'
24179: INTO new_def_num_val
24180: USING t_prop_id;
24181:

Line 24310: 'SELECT t.property_id, t.NAME FROM cz_properties' || cz_pb_mgr.v_db_link || ' t' || ',' ||

24306: BEGIN
24307: IF (what_exists = 'PROP')
24308: THEN
24309: l_sql_str :=
24310: 'SELECT t.property_id, t.NAME FROM cz_properties' || cz_pb_mgr.v_db_link || ' t' || ',' ||
24311: 'cz_rp_entries' || cz_pb_mgr.v_db_link || ' t1' || ',' ||
24312: 'cz_properties s' || ' ' ||
24313: 'WHERE t1.object_id = t.property_id AND t1.object_type = ''PRP'' ' || ' ' ||
24314: 'AND t1.DELETED_FLAG = ''0'' '|| ' ' ||

Line 24312: 'cz_properties s' || ' ' ||

24308: THEN
24309: l_sql_str :=
24310: 'SELECT t.property_id, t.NAME FROM cz_properties' || cz_pb_mgr.v_db_link || ' t' || ',' ||
24311: 'cz_rp_entries' || cz_pb_mgr.v_db_link || ' t1' || ',' ||
24312: 'cz_properties s' || ' ' ||
24313: 'WHERE t1.object_id = t.property_id AND t1.object_type = ''PRP'' ' || ' ' ||
24314: 'AND t1.DELETED_FLAG = ''0'' '|| ' ' ||
24315: 'AND t.NAME = s.NAME AND t1.NAME = s.NAME' || ' ' ||
24316: 'AND t.data_type = s.data_type' || ' ' ||

Line 24414: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_PROPERTIES_SEQ

24410:
24411: BEGIN
24412: IF (what_id = 'PROP')
24413: THEN
24414: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_PROPERTIES_SEQ
24415: , 'CZ_PROPERTIES_S.nextval' || cz_pb_mgr.v_db_link
24416: ,cz_pb_mgr.v_oraclesequenceincr
24417: );
24418:

Line 24415: , 'CZ_PROPERTIES_S.nextval' || cz_pb_mgr.v_db_link

24411: BEGIN
24412: IF (what_id = 'PROP')
24413: THEN
24414: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_PROPERTIES_SEQ
24415: , 'CZ_PROPERTIES_S.nextval' || cz_pb_mgr.v_db_link
24416: ,cz_pb_mgr.v_oraclesequenceincr
24417: );
24418:
24419: ELSIF(what_id = 'ITEM')