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_ITEM_TYPE_PROPERTIES

Line 1121: v_insertstring := v_insertstring || ' IF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_TYPE_PROPERTIES'') THEN ';

1117: v_insertstring := v_insertstring || ' AND ' || table_name || '.' || primary_key2 || '=' || plsql_table_name2 || '(m) ';
1118: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'' ';
1119: v_insertstring := v_insertstring || ' ; IF (MOD(M,cz_pb_mgr.RECORD_COMMIT_SIZE) = 0) THEN COMMIT; END IF; ';
1120: v_insertstring := v_insertstring || ' EXCEPTION WHEN DUP_VAL_ON_INDEX THEN ';
1121: v_insertstring := v_insertstring || ' IF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_TYPE_PROPERTIES'') THEN ';
1122: v_insertstring := v_insertstring || ' UPDATE cz_item_type_properties' || cz_pb_mgr.v_db_link || ' SET DELETED_FLAG = ''0'' ';
1123: v_insertstring := v_insertstring || ' WHERE ITEM_TYPE_ID = ' || plsql_table_name1 || '(m) ';
1124: v_insertstring := v_insertstring || ' AND PROPERTY_ID = ' || plsql_table_name2 || '(m); ';
1125: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_PROPERTY_VALUES'') THEN ';

Line 1122: v_insertstring := v_insertstring || ' UPDATE cz_item_type_properties' || cz_pb_mgr.v_db_link || ' SET DELETED_FLAG = ''0'' ';

1118: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'' ';
1119: v_insertstring := v_insertstring || ' ; IF (MOD(M,cz_pb_mgr.RECORD_COMMIT_SIZE) = 0) THEN COMMIT; END IF; ';
1120: v_insertstring := v_insertstring || ' EXCEPTION WHEN DUP_VAL_ON_INDEX THEN ';
1121: v_insertstring := v_insertstring || ' IF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_TYPE_PROPERTIES'') THEN ';
1122: v_insertstring := v_insertstring || ' UPDATE cz_item_type_properties' || cz_pb_mgr.v_db_link || ' SET DELETED_FLAG = ''0'' ';
1123: v_insertstring := v_insertstring || ' WHERE ITEM_TYPE_ID = ' || plsql_table_name1 || '(m) ';
1124: v_insertstring := v_insertstring || ' AND PROPERTY_ID = ' || plsql_table_name2 || '(m); ';
1125: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_PROPERTY_VALUES'') THEN ';
1126: v_insertstring :=

Line 1480: insert_item_tables('cz_item_type_properties'

1476: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array1';
1477: rec_count := rec_count + 1;
1478: plsql_table_list(rec_count).col_name := 'item_type_id';
1479: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array2';
1480: insert_item_tables('cz_item_type_properties'
1481: ,'property_id'
1482: ,'item_type_id'
1483: ,cz_pb_mgr.v_db_link
1484: ,plsql_table_list

Line 16162: || ' cz_item_type_properties'

16158: BEGIN
16159: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_types'
16160: || cz_pb_mgr.v_db_link
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

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 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 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 16610: WHERE cz_item_type_properties.item_type_id = cz_pb_mgr.v_item_types_new_ref(i)

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';
16614: EXCEPTION

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 16613: AND cz_item_type_properties.deleted_flag = '0';

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
16617: NULL;

Line 16620: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_item_type_properties', 'SQLERRM', SQLERRM);

16616: THEN
16617: NULL;
16618: WHEN OTHERS
16619: THEN
16620: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_item_type_properties', 'SQLERRM', SQLERRM);
16621: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.ITEMTYPE', SQLCODE);
16622: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16623: END;
16624: