APPS.EAM_ASSETATTR_VALUE_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 57

	INSERT into temp_isetup_api(msg,sr_no)
	VALUES (info,g_sr_no);

Line: 75

        select eam_item_type into l_eam_item_type
        from mtl_system_items
        where inventory_item_id=p_inventory_item_id
        and rownum=1;

Line: 105

			SELECT count(*) INTO l_count_rec
			FROM mtl_system_items MSI , csi_item_instances CII
			WHERE cii.serial_number = p_serial_number
			AND cii.instance_id = p_maintenance_object_id
			AND CII.inventory_item_id = MSI.inventory_item_id
			AND MSI.inventory_item_id = p_asset_group_id;

Line: 117

			SELECT count(*) INTO l_count_rec
			FROM mtl_system_items
			WHERE inventory_item_id = p_asset_group_id;

Line: 165

		select count(*) into l_count
		from csi_item_instances
		where instance_id=p_object_id;

Line: 170

		select count(*) into l_count
		from mtl_system_items
		where inventory_item_id=p_object_id
		and organization_id=p_organization_id;

Line: 193

	select count(*) into l_count
	from mtl_eam_asset_attr_groups
	where association_id = p_association_id and
	/* removing this as creation_organization_id is not used */
	/* decode(p_eam_item_type,1,creation_organization_id,1) = 	decode(p_eam_item_type,1,p_creation_organization_id,1) and */
	inventory_item_id = p_inventory_item_id
	and descriptive_flex_context_code=p_attribute_category;

Line: 227

        SELECT COUNT(*) INTO l_count
	FROM   FND_DESCR_FLEX_CONTEXTS_VL
	WHERE  DESCRIPTIVE_FLEXFIELD_NAME = 'MTL_EAM_ASSET_ATTR_VALUES'
	AND    ENABLED_FLAG = 'Y'
	AND    APPLICATION_ID = p_application_id
	AND    DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attribute_category;

Line: 365

        SELECT COUNT(*) INTO l_count
	FROM  MTL_EAM_ASSET_ATTR_VALUES
	WHERE 	association_id	 	 = 	p_association_id    and
		inventory_item_id	 = 	p_inventory_item_id and
		serial_number 	 	 = 	p_serial_number	    and
		/* removing this as creation_organization_id is not used */
		/* decode(p_eam_item_type,1,creation_organization_id,1) = 	decode(p_eam_item_type,1,p_creation_organization_id,1) and */
		attribute_category	 = 	p_attribute_category;

Line: 394

procedure insert_assetattr_value
(
	p_api_version          	IN	NUMBER			,
  	p_init_msg_list	   	IN	VARCHAR2:= FND_API.G_FALSE	,
	p_commit	    	IN  	VARCHAR2:= FND_API.G_FALSE	,
	p_validation_level	IN  	NUMBER  := FND_API.G_VALID_LEVEL_FULL,
	x_return_status		OUT NOCOPY VARCHAR2	 ,
	x_msg_count		OUT NOCOPY NUMBER	 ,
	x_msg_data	    	OUT NOCOPY VARCHAR2  ,
	P_ASSOCIATION_ID	IN	NUMBER	,
	P_APPLICATION_ID	IN	NUMBER	default 401,
	P_DESCRIPTIVE_FLEXFIELD_NAME  	IN VARCHAR2 default 'MTL_EAM_ASSET_ATTR_VALUES'	,
	P_INVENTORY_ITEM_ID	IN	NUMBER	default null,
	P_SERIAL_NUMBER		IN	VARCHAR2	default null,
	P_ORGANIZATION_ID	IN	NUMBER	,
	P_ATTRIBUTE_CATEGORY	IN	VARCHAR2	,
	P_C_ATTRIBUTE1		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE2		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE3		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE4		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE5		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE6		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE7		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE8		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE9		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE10		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE11		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE12		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE13		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE14		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE15		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE16		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE17		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE18		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE19		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE20		IN	VARCHAR2	default null,
	P_D_ATTRIBUTE1		IN	DATE	default null,
	P_D_ATTRIBUTE2		IN	DATE	default null,
	P_D_ATTRIBUTE3		IN	DATE	default null,
	P_D_ATTRIBUTE4		IN	DATE	default null,
	P_D_ATTRIBUTE5		IN	DATE	default null,
	P_D_ATTRIBUTE6		IN	DATE	default null,
	P_D_ATTRIBUTE7		IN	DATE	default null,
	P_D_ATTRIBUTE8		IN	DATE	default null,
	P_D_ATTRIBUTE9		IN	DATE	default null,
	P_D_ATTRIBUTE10		IN	DATE	default null,
	P_N_ATTRIBUTE1		IN	NUMBER	default null,
	P_N_ATTRIBUTE2		IN	NUMBER	default null,
	P_N_ATTRIBUTE3		IN	NUMBER	default null,
	P_N_ATTRIBUTE4		IN	NUMBER	default null,
	P_N_ATTRIBUTE5		IN	NUMBER	default null,
	P_N_ATTRIBUTE6		IN	NUMBER	default null,
	P_N_ATTRIBUTE7		IN	NUMBER	default null,
	P_N_ATTRIBUTE8		IN	NUMBER	default null,
	P_N_ATTRIBUTE9		IN	NUMBER	default null,
	P_N_ATTRIBUTE10		IN	NUMBER	default null,
	P_MAINTENANCE_OBJECT_TYPE     	IN	VARCHAR2 default null	,
	P_MAINTENANCE_OBJECT_ID		IN	NUMBER	default null,
	P_CREATION_ORGANIZATION_ID  	IN	NUMBER	default null
)
IS
	l_api_name			CONSTANT VARCHAR2(30)	:= 'insert_assetattr_value';

Line: 482

    SAVEPOINT	INSERT_ASSETATTR_VALUE;

Line: 559

		select msi.eam_item_type into l_item_type
		from mtl_system_items msi, csi_item_instances cii
		where cii.inventory_item_id = msi.inventory_item_id
		and cii.last_vld_organization_id = msi.organization_id
		and cii.instance_id = p_maintenance_object_id;

Line: 590

			select instance_id, 3 into l_maintenance_object_id, l_maintenance_object_type
			from csi_item_instances
			where serial_number = p_serial_number
                        and inventory_item_id = p_inventory_item_id;

Line: 604

			select cii.serial_number, cii.inventory_item_id
				into l_serial_number, l_asset_group_id
			from csi_item_instances cii
			where cii.instance_id = p_maintenance_object_id;

Line: 636

		select instance_id,3
		into l_maintenance_object_id,l_maintenance_object_type
		from csi_item_instances
		where inventory_item_id=p_inventory_item_id
		and serial_number=p_serial_number;

Line: 651

		select inventory_item_id, serial_number, last_vld_organization_id
		into l_asset_group_id , l_serial_number, l_temp_org_id
		from csi_item_instances
		where instance_id=p_maintenance_object_id;

Line: 669

	    select count(*) into l_count
    	    from csi_item_instances
	    where instance_id=l_maintenance_object_id
	    and inventory_item_id=l_asset_group_id
	    and serial_number=l_serial_number;

Line: 765

        INSERT INTO MTL_EAM_ASSET_ATTR_VALUES
        (
		ASSOCIATION_ID	,
		INVENTORY_ITEM_ID	,
		SERIAL_NUMBER 	,
		ORGANIZATION_ID  	,
		ATTRIBUTE_CATEGORY	,
		C_ATTRIBUTE1  	,
		C_ATTRIBUTE2  	,
		C_ATTRIBUTE3  	,
		C_ATTRIBUTE4  	,
		C_ATTRIBUTE5  	,
		C_ATTRIBUTE6  	,
		C_ATTRIBUTE7  	,
		C_ATTRIBUTE8  	,
		C_ATTRIBUTE9  	,
		C_ATTRIBUTE10 	,
		C_ATTRIBUTE11 	,
		C_ATTRIBUTE12 	,
		C_ATTRIBUTE13 	,
		C_ATTRIBUTE14 	,
		C_ATTRIBUTE15 	,
		C_ATTRIBUTE16 	,
		C_ATTRIBUTE17 	,
		C_ATTRIBUTE18 	,
		C_ATTRIBUTE19 	,
		C_ATTRIBUTE20 	,
		D_ATTRIBUTE1  	,
		D_ATTRIBUTE2  	,
		D_ATTRIBUTE3  	,
		D_ATTRIBUTE4  	,
		D_ATTRIBUTE5  	,
		D_ATTRIBUTE6  	,
		D_ATTRIBUTE7  	,
		D_ATTRIBUTE8  	,
		D_ATTRIBUTE9  	,
		D_ATTRIBUTE10 	,
		N_ATTRIBUTE1  	,
		N_ATTRIBUTE2  	,
		N_ATTRIBUTE3  	,
		N_ATTRIBUTE4  	,
		N_ATTRIBUTE5  	,
		N_ATTRIBUTE6  	,
		N_ATTRIBUTE7  	,
		N_ATTRIBUTE8  	,
		N_ATTRIBUTE9  	,
		N_ATTRIBUTE10 	,
		APPLICATION_ID	,
		DESCRIPTIVE_FLEXFIELD_NAME	,
		MAINTENANCE_OBJECT_TYPE	,
		MAINTENANCE_OBJECT_ID	,
		CREATION_ORGANIZATION_ID               	,

		CREATED_BY           ,
		CREATION_DATE       ,
		LAST_UPDATE_LOGIN  ,
		LAST_UPDATE_DATE  ,
		LAST_UPDATED_BY
	)
	VALUES
	(
		P_ASSOCIATION_ID	,
		/*P_INVENTORY_ITEM_ID	,
		P_SERIAL_NUMBER	,
		P_ORGANIZATION_ID	,*/
		l_asset_group_id,
		l_serial_number,
		p_organization_id,
		P_ATTRIBUTE_CATEGORY	,
		P_C_ATTRIBUTE1	,
		P_C_ATTRIBUTE2	,
		P_C_ATTRIBUTE3	,
		P_C_ATTRIBUTE4	,
		P_C_ATTRIBUTE5	,
		P_C_ATTRIBUTE6	,
		P_C_ATTRIBUTE7	,
		P_C_ATTRIBUTE8	,
		P_C_ATTRIBUTE9	,
		P_C_ATTRIBUTE10	,
		P_C_ATTRIBUTE11	,
		P_C_ATTRIBUTE12	,
		P_C_ATTRIBUTE13	,
		P_C_ATTRIBUTE14	,
		P_C_ATTRIBUTE15	,
		P_C_ATTRIBUTE16	,
		P_C_ATTRIBUTE17	,
		P_C_ATTRIBUTE18	,
		P_C_ATTRIBUTE19	,
		P_C_ATTRIBUTE20	,
		P_D_ATTRIBUTE1	,
		P_D_ATTRIBUTE2	,
		P_D_ATTRIBUTE3	,
		P_D_ATTRIBUTE4	,
		P_D_ATTRIBUTE5	,
		P_D_ATTRIBUTE6	,
		P_D_ATTRIBUTE7	,
		P_D_ATTRIBUTE8	,
		P_D_ATTRIBUTE9	,
		P_D_ATTRIBUTE10	,
		P_N_ATTRIBUTE1	,
		P_N_ATTRIBUTE2	,
		P_N_ATTRIBUTE3	,
		P_N_ATTRIBUTE4	,
		P_N_ATTRIBUTE5	,
		P_N_ATTRIBUTE6	,
		P_N_ATTRIBUTE7	,
		P_N_ATTRIBUTE8	,
		P_N_ATTRIBUTE9	,
		P_N_ATTRIBUTE10	,
		P_APPLICATION_ID	,
		P_DESCRIPTIVE_FLEXFIELD_NAME  	,
		/*P_MAINTENANCE_OBJECT_TYPE     	,
		P_MAINTENANCE_OBJECT_ID	,
		P_CREATION_ORGANIZATION_ID  	,*/
		l_maintenance_object_type,
		l_maintenance_object_id,
		p_creation_organization_id,

		fnd_global.user_id,
		sysdate,
		fnd_global.login_id,
		sysdate    ,
		fnd_global.user_id
	);

Line: 902

		ROLLBACK TO insert_assetattr_value;

Line: 909

		ROLLBACK TO insert_assetattr_value;

Line: 916

		ROLLBACK TO insert_assetattr_value;

Line: 930

END insert_assetattr_value;

Line: 933

procedure update_assetattr_value
(
	p_api_version           IN	NUMBER			,
  	p_init_msg_list	   	IN	VARCHAR2:= FND_API.G_FALSE	,
	p_commit	    	IN  	VARCHAR2:= FND_API.G_FALSE	,
	p_validation_level	IN  	NUMBER  := FND_API.G_VALID_LEVEL_FULL,
	x_return_status		OUT NOCOPY VARCHAR2	 ,
	x_msg_count		OUT NOCOPY NUMBER	 ,
	x_msg_data	 	OUT NOCOPY VARCHAR2  ,
	P_ASSOCIATION_ID	IN	NUMBER	,
	P_APPLICATION_ID	IN	NUMBER	default 401,
	P_DESCRIPTIVE_FLEXFIELD_NAME  IN	VARCHAR2 default 'MTL_EAM_ASSET_ATTR_VALUES'	,
	P_INVENTORY_ITEM_ID	IN	NUMBER	default null,
	P_SERIAL_NUMBER		IN	VARCHAR2 default null	,
	P_ORGANIZATION_ID	IN	NUMBER	,
	P_ATTRIBUTE_CATEGORY	IN	VARCHAR2	,
	P_C_ATTRIBUTE1		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE2		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE3		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE4		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE5		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE6		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE7		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE8		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE9		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE10		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE11		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE12		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE13		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE14		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE15		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE16		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE17		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE18		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE19		IN	VARCHAR2	default null,
	P_C_ATTRIBUTE20		IN	VARCHAR2	default null,
	P_D_ATTRIBUTE1		IN	DATE	default null,
	P_D_ATTRIBUTE2		IN	DATE	default null,
	P_D_ATTRIBUTE3		IN	DATE	default null,
	P_D_ATTRIBUTE4		IN	DATE	default null,
	P_D_ATTRIBUTE5		IN	DATE	default null,
	P_D_ATTRIBUTE6		IN	DATE	default null,
	P_D_ATTRIBUTE7		IN	DATE	default null,
	P_D_ATTRIBUTE8		IN	DATE	default null,
	P_D_ATTRIBUTE9		IN	DATE	default null,
	P_D_ATTRIBUTE10		IN	DATE	default null,
	P_N_ATTRIBUTE1		IN	NUMBER	default null,
	P_N_ATTRIBUTE2		IN	NUMBER	default null,
	P_N_ATTRIBUTE3		IN	NUMBER	default null,
	P_N_ATTRIBUTE4		IN	NUMBER	default null,
	P_N_ATTRIBUTE5		IN	NUMBER	default null,
	P_N_ATTRIBUTE6		IN	NUMBER	default null,
	P_N_ATTRIBUTE7		IN	NUMBER	default null,
	P_N_ATTRIBUTE8		IN	NUMBER	default null,
	P_N_ATTRIBUTE9		IN	NUMBER	default null,
	P_N_ATTRIBUTE10		IN	NUMBER	default null,
	P_MAINTENANCE_OBJECT_TYPE     	IN	VARCHAR2	default null,
	P_MAINTENANCE_OBJECT_ID		IN	NUMBER	default null,
	P_CREATION_ORGANIZATION_ID  	IN	NUMBER	default null
)
IS
	l_api_name			CONSTANT VARCHAR2(30)	:= 'update_assetattr_value';

Line: 1017

    SAVEPOINT	update_assetattr_value;

Line: 1094

		select msi.eam_item_type into l_item_type
		from mtl_system_items msi, csi_item_instances cii
		where cii.inventory_item_id = msi.inventory_item_id
		and cii.last_vld_organization_id = msi.organization_id
		and cii.instance_id = p_maintenance_object_id;

Line: 1123

			select instance_id, 3 into l_maintenance_object_id, l_maintenance_object_type
			from csi_item_instances
			where serial_number = p_serial_number
                        and inventory_item_id = p_inventory_item_id;

Line: 1137

			select cii.serial_number, cii.inventory_item_id
				into l_serial_number, l_asset_group_id
			from csi_item_instances cii
			where cii.instance_id = p_maintenance_object_id;

Line: 1169

		select instance_id,3
		into l_maintenance_object_id,l_maintenance_object_type
		from csi_item_instances
		where inventory_item_id=p_inventory_item_id
		and serial_number=p_serial_number;

Line: 1184

		select inventory_item_id, serial_number, last_vld_organization_id
		into l_item_id , l_serial_number, l_temp_org_id
		from csi_item_instances
		where instance_id=p_maintenance_object_id;

Line: 1202

	    select count(*) into l_count
    	    from csi_item_instances
	    where instance_id=l_maintenance_object_id
	    and inventory_item_id=l_asset_group_id
	    and serial_number=l_serial_number;

Line: 1278

		update MTL_EAM_ASSET_ATTR_VALUES
		set
		--ASSOCIATION_ID	 = 	P_ASSOCIATION_ID		,
		--INVENTORY_ITEM_ID= 	l_asset_group_id,/*P_INVENTORY_ITEM_ID	,*/
		--SERIAL_NUMBER 	 = 	l_serial_number,/*P_SERIAL_NUMBER			,*/
		--ORGANIZATION_ID  = 	P_ORGANIZATION_ID	, do not update this field
		--ATTRIBUTE_CATEGORY = 	P_ATTRIBUTE_CATEGORY	,
		C_ATTRIBUTE1  	 = 	P_C_ATTRIBUTE1			,
		C_ATTRIBUTE2  	 = 	P_C_ATTRIBUTE2			,
		C_ATTRIBUTE3  	 = 	P_C_ATTRIBUTE3			,
		C_ATTRIBUTE4  	 = 	P_C_ATTRIBUTE4			,
		C_ATTRIBUTE5  	 = 	P_C_ATTRIBUTE5			,
		C_ATTRIBUTE6  	 = 	P_C_ATTRIBUTE6			,
		C_ATTRIBUTE7  	 = 	P_C_ATTRIBUTE7			,
		C_ATTRIBUTE8  	 = 	P_C_ATTRIBUTE8			,
		C_ATTRIBUTE9  	 = 	P_C_ATTRIBUTE9			,
		C_ATTRIBUTE10 	 = 	P_C_ATTRIBUTE10			,
		C_ATTRIBUTE11 	 = 	P_C_ATTRIBUTE11			,
		C_ATTRIBUTE12 	 = 	P_C_ATTRIBUTE12			,
		C_ATTRIBUTE13 	 = 	P_C_ATTRIBUTE13			,
		C_ATTRIBUTE14 	 = 	P_C_ATTRIBUTE14			,
		C_ATTRIBUTE15 	 = 	P_C_ATTRIBUTE15			,
		C_ATTRIBUTE16 	 = 	P_C_ATTRIBUTE16			,
		C_ATTRIBUTE17 	 = 	P_C_ATTRIBUTE17			,
		C_ATTRIBUTE18 	 = 	P_C_ATTRIBUTE18			,
		C_ATTRIBUTE19 	 = 	P_C_ATTRIBUTE19			,
		C_ATTRIBUTE20 	 = 	P_C_ATTRIBUTE20			,
		D_ATTRIBUTE1  	 = 	P_D_ATTRIBUTE1			,
		D_ATTRIBUTE2  	 = 	P_D_ATTRIBUTE2			,
		D_ATTRIBUTE3  	 = 	P_D_ATTRIBUTE3			,
		D_ATTRIBUTE4  	 = 	P_D_ATTRIBUTE4			,
		D_ATTRIBUTE5  	 = 	P_D_ATTRIBUTE5			,
		D_ATTRIBUTE6  	 = 	P_D_ATTRIBUTE6			,
		D_ATTRIBUTE7  	 = 	P_D_ATTRIBUTE7			,
		D_ATTRIBUTE8  	 = 	P_D_ATTRIBUTE8			,
		D_ATTRIBUTE9  	 = 	P_D_ATTRIBUTE9			,
		D_ATTRIBUTE10 	 = 	P_D_ATTRIBUTE10			,
		N_ATTRIBUTE1  	 = 	P_N_ATTRIBUTE1			,
		N_ATTRIBUTE2  	 = 	P_N_ATTRIBUTE2			,
		N_ATTRIBUTE3  	 = 	P_N_ATTRIBUTE3			,
		N_ATTRIBUTE4  	 = 	P_N_ATTRIBUTE4			,
		N_ATTRIBUTE5  	 = 	P_N_ATTRIBUTE5			,
		N_ATTRIBUTE6  	 = 	P_N_ATTRIBUTE6			,
		N_ATTRIBUTE7  	 = 	P_N_ATTRIBUTE7			,
		N_ATTRIBUTE8  	 = 	P_N_ATTRIBUTE8			,
		N_ATTRIBUTE9  	 = 	P_N_ATTRIBUTE9			,
		N_ATTRIBUTE10 	 = 	P_N_ATTRIBUTE10			,
		APPLICATION_ID	 = 	P_APPLICATION_ID			,
		DESCRIPTIVE_FLEXFIELD_NAME	 = 	P_DESCRIPTIVE_FLEXFIELD_NAME 	,
		MAINTENANCE_OBJECT_TYPE	 = 	l_maintenance_object_type , /*P_MAINTENANCE_OBJECT_TYPE     		,*/
		MAINTENANCE_OBJECT_ID	 = 	l_maintenance_object_id ,/*P_MAINTENANCE_OBJECT_ID			,*/
		CREATION_ORGANIZATION_ID = 	p_creation_organization_id ,/*P_CREATION_ORGANIZATION_ID  		,*/
		CREATED_BY           	 = 	fnd_global.user_id ,
		CREATION_DATE       	 = 	sysdate		   ,
		LAST_UPDATE_LOGIN  	 = 	fnd_global.login_id,
		LAST_UPDATE_DATE  	 = 	sysdate            ,
		LAST_UPDATED_BY  	 = 	fnd_global.user_id

	where
		ASSOCIATION_ID	 	 = 	P_ASSOCIATION_ID    and
		INVENTORY_ITEM_ID	 = 	l_asset_group_id and
		SERIAL_NUMBER 	 	 = 	l_serial_number and
		/* removing this as creation_organization_id is not used */
		/* decode(l_item_type,1,CREATION_ORGANIZATION_ID,1) = decode(l_item_type,1,p_creation_organization_id,1) and */
		ATTRIBUTE_CATEGORY	 = 	P_ATTRIBUTE_CATEGORY;

Line: 1359

		ROLLBACK TO update_assetattr_value;

Line: 1366

		ROLLBACK TO update_assetattr_value;

Line: 1373

		ROLLBACK TO update_assetattr_value;

Line: 1387

END update_assetattr_value;