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 956: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_PROPERTIES'') THEN ';

952: v_insertstring := v_insertstring || ' = (SELECT DESC_TEXT,NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04 ';
953: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF ';
954: v_insertstring := v_insertstring || ' FROM cz_item_types WHERE cz_item_types.item_type_id = ' || plsql_table_name || '(m) ';
955: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'') WHERE t.item_type_id = ' || plsql_table_name || '(m); ';
956: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_PROPERTIES'') THEN ';
957: v_insertstring := v_insertstring || ' UPDATE cz_properties' || cz_pb_mgr.v_db_link || ' t ';
958: v_insertstring := v_insertstring || ' SET ( PROPERTY_UNIT,DESC_TEXT,NAME,DATA_TYPE,DEF_VALUE,USER_NUM01 ';
959: v_insertstring := v_insertstring || ' ,USER_NUM02,USER_NUM03,USER_NUM04,USER_STR01,USER_STR02,USER_STR03,USER_STR04 ';
960: v_insertstring := v_insertstring || ' ,DELETED_FLAG,EFF_FROM,EFF_TO,ORIG_SYS_REF) = (SELECT PROPERTY_UNIT,DESC_TEXT,';

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

953: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF ';
954: v_insertstring := v_insertstring || ' FROM cz_item_types WHERE cz_item_types.item_type_id = ' || plsql_table_name || '(m) ';
955: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'') WHERE t.item_type_id = ' || plsql_table_name || '(m); ';
956: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_PROPERTIES'') THEN ';
957: v_insertstring := v_insertstring || ' UPDATE cz_properties' || cz_pb_mgr.v_db_link || ' t ';
958: v_insertstring := v_insertstring || ' SET ( PROPERTY_UNIT,DESC_TEXT,NAME,DATA_TYPE,DEF_VALUE,USER_NUM01 ';
959: v_insertstring := v_insertstring || ' ,USER_NUM02,USER_NUM03,USER_NUM04,USER_STR01,USER_STR02,USER_STR03,USER_STR04 ';
960: v_insertstring := v_insertstring || ' ,DELETED_FLAG,EFF_FROM,EFF_TO,ORIG_SYS_REF) = (SELECT PROPERTY_UNIT,DESC_TEXT,';
961: v_insertstring := v_insertstring || ' NAME,DATA_TYPE,DEF_VALUE,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,';

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

959: v_insertstring := v_insertstring || ' ,USER_NUM02,USER_NUM03,USER_NUM04,USER_STR01,USER_STR02,USER_STR03,USER_STR04 ';
960: v_insertstring := v_insertstring || ' ,DELETED_FLAG,EFF_FROM,EFF_TO,ORIG_SYS_REF) = (SELECT PROPERTY_UNIT,DESC_TEXT,';
961: v_insertstring := v_insertstring || ' NAME,DATA_TYPE,DEF_VALUE,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,';
962: v_insertstring := v_insertstring || ' USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,EFF_FROM,';
963: v_insertstring := v_insertstring || ' EFF_TO,ORIG_SYS_REF FROM cz_properties ';
964: v_insertstring := v_insertstring || ' WHERE cz_properties.property_id = ' || plsql_table_name || '(m) ';
965: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'') WHERE t.property_id = ' || plsql_table_name || '(m); ';
966: v_insertstring := v_insertstring || ' END IF; END; END LOOP; COMMIT; END; ';
967:

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

960: v_insertstring := v_insertstring || ' ,DELETED_FLAG,EFF_FROM,EFF_TO,ORIG_SYS_REF) = (SELECT PROPERTY_UNIT,DESC_TEXT,';
961: v_insertstring := v_insertstring || ' NAME,DATA_TYPE,DEF_VALUE,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,';
962: v_insertstring := v_insertstring || ' USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,EFF_FROM,';
963: v_insertstring := v_insertstring || ' EFF_TO,ORIG_SYS_REF FROM cz_properties ';
964: v_insertstring := v_insertstring || ' WHERE cz_properties.property_id = ' || plsql_table_name || '(m) ';
965: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'') WHERE t.property_id = ' || plsql_table_name || '(m); ';
966: v_insertstring := v_insertstring || ' END IF; END; END LOOP; COMMIT; END; ';
967:
968: EXECUTE IMMEDIATE v_insertstring;

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

1148:
1149: COMMIT;
1150: END insert_item_tables;
1151:
1152: /* Procedure to insert dev num val for translateable properties of CZ_PROPERTIES into localized texts*/
1153:
1154: PROCEDURE mm_ins_def_num_val_in_intl AS
1155: l_sql_str varchar2(4000);
1156: lang_count number;

Line 1411: insert_into_item_tables('cz_properties'

1407:
1408: plsql_table_list(rec_count).col_name := 'def_num_value';
1409: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array2';
1410:
1411: insert_into_item_tables('cz_properties'
1412: ,'property_id'
1413: ,cz_pb_mgr.v_db_link
1414: ,plsql_table_list
1415: ,'cz_pb_mgr.mm_source_array1'

Line 1443: insert_into_item_tables('cz_properties'

1439: );
1440: ELSE
1441: plsql_table_list(rec_count).col_name := 'property_id';
1442: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_remote_prop_ref';
1443: insert_into_item_tables('cz_properties'
1444: ,'property_id'
1445: ,cz_pb_mgr.v_db_link
1446: ,plsql_table_list
1447: ,'cz_pb_mgr.v_remote_prop_ref'

Line 16103: v_prop_id cz_properties.property_id%TYPE;

16099: END upload_rule_schema;
16100: -----------------------------------------------------------------------------------------------------
16101: PROCEDURE mm_raiseallpossiblesyncerrors
16102: AS
16103: v_prop_id cz_properties.property_id%TYPE;
16104: v_error_flag PLS_INTEGER := 0;
16105: v_null PLS_INTEGER;
16106: j PLS_INTEGER;
16107: v_target_item_type_name cz_item_types.name%TYPE;

Line 16122: EXECUTE IMMEDIATE 'SELECT data_type FROM cz_properties'

16118: -- USAGE: Name does not match, but there are already 64 Usages
16119: FOR i IN 1 .. v_remote_prop_ref.COUNT
16120: LOOP
16121: BEGIN
16122: EXECUTE IMMEDIATE 'SELECT data_type FROM cz_properties'
16123: || cz_pb_mgr.v_db_link
16124: || ' WHERE deleted_flag = ''0'' AND name = :1 AND NVL(src_application_id, 0) = :2'
16125: INTO v_null
16126: USING v_property_record_ref(v_remote_prop_ref(i)).NAME, v_property_record_ref(v_remote_prop_ref(i)).src_application_id;

Line 16165: || ' cz_properties'

16161: || 'it, '
16162: || ' cz_item_type_properties'
16163: || cz_pb_mgr.v_db_link
16164: || 'tp, '
16165: || ' cz_properties'
16166: || cz_pb_mgr.v_db_link
16167: || ' pr '
16168: || ' WHERE it.deleted_flag = ''0'''
16169: || ' AND pr.deleted_flag = ''0'''

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

16536: BEGIN
16537: SELECT property_id, data_type, name, src_application_id
16538: BULK COLLECT INTO v_remote_prop_tbl, v_prop_type_tbl, v_prop_name_tbl, v_prop_src_app_tbl
16539: FROM (SELECT itp.property_id, p.data_type, p.name, nvl(p.src_application_id, 0) AS src_application_id
16540: from cz_item_masters im, cz_item_type_properties itp, cz_ps_nodes psn, cz_properties p
16541: where psn.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) and psn.deleted_flag = '0'
16542: and psn.item_id = im.item_id AND im.deleted_flag = '0' and im.item_type_id = itp.item_type_id
16543: AND itp.deleted_flag = '0' and itp.property_id = p.property_id and p.deleted_flag = '0'
16544: UNION

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

16542: and psn.item_id = im.item_id AND im.deleted_flag = '0' and im.item_type_id = itp.item_type_id
16543: AND itp.deleted_flag = '0' and itp.property_id = p.property_id and p.deleted_flag = '0'
16544: UNION
16545: SELECT psp.property_id, p.data_type, p.name, nvl(p.src_application_id, 0) AS src_application_id
16546: from cz_ps_prop_vals psp, cz_ps_nodes psn, cz_properties p
16547: where psn.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) and psn.ps_node_id = psp.ps_node_id
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

Line 16552: from cz_ps_nodes psn, cz_item_property_values ipv, cz_properties p

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:

Line 16605: SELECT cz_item_type_properties.property_id, cz_item_type_properties.item_type_id,cz_properties.def_num_value

16601: cz_pb_mgr.v_item_prop_num_val_ref.DELETE;
16602: cz_pb_mgr.v_item_prop_data_typ_ref.DELETE;
16603:
16604: BEGIN
16605: SELECT cz_item_type_properties.property_id, cz_item_type_properties.item_type_id,cz_properties.def_num_value
16606: ,cz_properties.data_type
16607: BULK COLLECT INTO cz_pb_mgr.v_item_prop_id_ref, cz_pb_mgr.v_item_prop_type_ref,cz_pb_mgr.v_item_prop_num_val_ref
16608: ,cz_pb_mgr.v_item_prop_data_typ_ref
16609: FROM cz_item_type_properties, cz_properties

Line 16606: ,cz_properties.data_type

16602: cz_pb_mgr.v_item_prop_data_typ_ref.DELETE;
16603:
16604: BEGIN
16605: SELECT cz_item_type_properties.property_id, cz_item_type_properties.item_type_id,cz_properties.def_num_value
16606: ,cz_properties.data_type
16607: BULK COLLECT INTO cz_pb_mgr.v_item_prop_id_ref, cz_pb_mgr.v_item_prop_type_ref,cz_pb_mgr.v_item_prop_num_val_ref
16608: ,cz_pb_mgr.v_item_prop_data_typ_ref
16609: FROM cz_item_type_properties, cz_properties
16610: WHERE cz_item_type_properties.item_type_id = cz_pb_mgr.v_item_types_new_ref(i)

Line 16609: FROM cz_item_type_properties, cz_properties

16605: SELECT cz_item_type_properties.property_id, cz_item_type_properties.item_type_id,cz_properties.def_num_value
16606: ,cz_properties.data_type
16607: BULK COLLECT INTO cz_pb_mgr.v_item_prop_id_ref, cz_pb_mgr.v_item_prop_type_ref,cz_pb_mgr.v_item_prop_num_val_ref
16608: ,cz_pb_mgr.v_item_prop_data_typ_ref
16609: FROM cz_item_type_properties, cz_properties
16610: WHERE cz_item_type_properties.item_type_id = cz_pb_mgr.v_item_types_new_ref(i)
16611: AND cz_properties.deleted_flag = '0'
16612: AND cz_item_type_properties.property_id =cz_properties.property_id
16613: AND cz_item_type_properties.deleted_flag = '0';

Line 16611: AND cz_properties.deleted_flag = '0'

16607: BULK COLLECT INTO cz_pb_mgr.v_item_prop_id_ref, cz_pb_mgr.v_item_prop_type_ref,cz_pb_mgr.v_item_prop_num_val_ref
16608: ,cz_pb_mgr.v_item_prop_data_typ_ref
16609: FROM cz_item_type_properties, cz_properties
16610: WHERE cz_item_type_properties.item_type_id = cz_pb_mgr.v_item_types_new_ref(i)
16611: AND cz_properties.deleted_flag = '0'
16612: AND cz_item_type_properties.property_id =cz_properties.property_id
16613: AND cz_item_type_properties.deleted_flag = '0';
16614: EXCEPTION
16615: WHEN NO_DATA_FOUND

Line 16612: AND cz_item_type_properties.property_id =cz_properties.property_id

16608: ,cz_pb_mgr.v_item_prop_data_typ_ref
16609: FROM cz_item_type_properties, cz_properties
16610: WHERE cz_item_type_properties.item_type_id = cz_pb_mgr.v_item_types_new_ref(i)
16611: AND cz_properties.deleted_flag = '0'
16612: AND cz_item_type_properties.property_id =cz_properties.property_id
16613: AND cz_item_type_properties.deleted_flag = '0';
16614: EXCEPTION
16615: WHEN NO_DATA_FOUND
16616: THEN

Line 22448: FROM cz_ps_prop_vals a, cz_properties b

22444: SELECT a.ps_node_id, a.property_id, b.data_type, a.data_num_value
22445: , a.data_value, l_devl_project_id
22446: 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
22447: , cz_pb_mgr.v_prop_vals_data_tbl, l_devl_project_id_tbl
22448: FROM cz_ps_prop_vals a, cz_properties b
22449: WHERE a.property_id = b.property_id AND a.ps_node_id = l_old_psnode_id AND a.deleted_flag = '0';
22450: -----ORDER BY a.ps_node_id;
22451: END IF;
22452: EXCEPTION

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

22581: t_prop_val_num := cz_pb_mgr.v_prop_vals_data_num_ref(j); /*Other properties dont need new intl_text_id*/
22582: new_def_num_val := v_prop_vals_def_num_value_ref(j);
22583: END IF;
22584:
22585: --mm_v_tbl_sync_prop_vals_num: contains all new def num vals which need to be inserted into cz_properties
22586:
22587: --Making mm_v_tbl_sync_prop_vals_num a hash table. Now it cannot be used directly in the only place where
22588: --it is currently used - insert_item_schema. Will need to construct an array with the values from this
22589: --hash table.

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

22723:
22724: new_def_num_val := cz_pb_mgr.v_item_prop_num_val_tbl(j);
22725: END IF;
22726:
22727: --mm_v_tbl_sync_prop_vals_num: contains all new def num vals which need to be inserted into cz_properties
22728:
22729: mm_v_tbl_sync_prop_vals_num(t_prop_id) := new_def_num_val;
22730: ELSE /*get the def num values of properties on target*/
22731:

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

22731:
22732: --The property exists on the target, so t_prop_id is not null. Again, these are properties associated with item types,
22733: --so we need only the default numeric value. This query cannot fail with NO_DATA_FOUND.
22734:
22735: EXECUTE IMMEDIATE 'SELECT def_num_value FROM cz_properties' || cz_pb_mgr.v_db_link ||
22736: ' WHERE property_id = :1 AND deleted_flag = 0'
22737: INTO new_def_num_val
22738: USING t_prop_id;
22739:

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

22862: BEGIN
22863: IF (what_exists = 'PROP')
22864: THEN
22865: l_sql_str :=
22866: 'SELECT t.property_id, t.NAME FROM cz_properties' || cz_pb_mgr.v_db_link || ' t' || ',' ||
22867: 'cz_rp_entries' || cz_pb_mgr.v_db_link || ' t1' || ',' ||
22868: 'cz_properties s' || ' ' ||
22869: 'WHERE t1.object_id = t.property_id AND t1.object_type = ''PRP'' ' || ' ' ||
22870: 'AND t1.DELETED_FLAG = ''0'' '|| ' ' ||

Line 22868: 'cz_properties s' || ' ' ||

22864: THEN
22865: l_sql_str :=
22866: 'SELECT t.property_id, t.NAME FROM cz_properties' || cz_pb_mgr.v_db_link || ' t' || ',' ||
22867: 'cz_rp_entries' || cz_pb_mgr.v_db_link || ' t1' || ',' ||
22868: 'cz_properties s' || ' ' ||
22869: 'WHERE t1.object_id = t.property_id AND t1.object_type = ''PRP'' ' || ' ' ||
22870: 'AND t1.DELETED_FLAG = ''0'' '|| ' ' ||
22871: 'AND t.NAME = s.NAME AND t1.NAME = s.NAME' || ' ' ||
22872: 'AND t.data_type = s.data_type' || ' ' ||

Line 22961: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_PROPERTIES_SEQ

22957:
22958: BEGIN
22959: IF (what_id = 'PROP')
22960: THEN
22961: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_PROPERTIES_SEQ
22962: , 'CZ_PROPERTIES_S.nextval' || cz_pb_mgr.v_db_link
22963: ,cz_pb_mgr.v_oraclesequenceincr
22964: );
22965:

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

22958: BEGIN
22959: IF (what_id = 'PROP')
22960: THEN
22961: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_PROPERTIES_SEQ
22962: , 'CZ_PROPERTIES_S.nextval' || cz_pb_mgr.v_db_link
22963: ,cz_pb_mgr.v_oraclesequenceincr
22964: );
22965:
22966: ELSIF(what_id = 'ITEM')