USE [METX]
GO
/****** Object:  Trigger [mt].[ots_cl_inventory_update]    Script Date: 9/24/2024 11:25:54 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [mt].[ots_cl_inventory_update] 
	ON [mt].[Inventory] 
	AFTER UPDATE
	AS

	BEGIN TRY

	SET NOCOUNT ON;

		DECLARE @current_user CHAR(60),
		@assetnum CHAR(60),
		@old_I4201 nvarchar(30) ,
		@old_I4202 nvarchar(30),
		@old_I4203 nvarchar(50),
		@old_I4204 nvarchar(60),
		@old_I4205 nvarchar(1),
		@old_I4206 nvarchar(50),
		@old_I4207 nvarchar(24),
		@old_I4208 nvarchar(29),
		@old_I4209 nvarchar(1) ,
		@old_I4210 nvarchar(12),
		@old_I4211 nvarchar(15),
		@old_I4212 date,
		@old_I4213 nvarchar(12),
		@old_I4214 nvarchar(16),
		@old_I4215 nvarchar(5),
		@old_I4216 nvarchar(5),
		@old_I4217 nvarchar(60),
		@old_I4218 nvarchar(4),
		@old_I4219 numeric(12,2),
		@old_I4220 int,
		@old_I4221 date,
		@old_I4222 nvarchar(12),
		@old_I4223 nvarchar(16),
		@old_I4224 date,
		@old_I4225 nvarchar(8),
		@old_I4226 nvarchar(1),
		@old_I4228 nvarchar(1) ,
		@old_I4229 int,
		@old_I4230 int,
		@old_I4231 nvarchar(32),
		@old_I4232 nvarchar(32),
		@old_I4233 nvarchar(32),
		@old_I4234 nvarchar(32),
		@old_I4235 nvarchar(32),
		@old_I4236 datetime2(7),
		@old_I4237 nvarchar(16),
		@old_I4238 datetime2(7),
		@old_I4239 nvarchar(16),
		@old_I4240 nvarchar(8) ,
		@old_I4241 nvarchar(80),
		@old_I4242 nvarchar(80),
		@old_I4243 nvarchar(80),
		@old_I4244 nvarchar(48),
		@old_I4245 nvarchar(48),
		@old_I4246 nvarchar(48),
		@old_I4247 nvarchar(48),
		@old_I4248 nvarchar(50),
		@old_I4249 nvarchar(48),
		@old_I4250 date,
		@old_I4251 date,
		@old_I4252 date,
		@old_I4253 date,
		@old_I4254 numeric(12,2),
		@old_I4255 bit ,
		@old_I4256 numeric(12,2),
		@old_I4257 numeric(12,2),
		@old_I4258 nvarchar(1),
		@old_I4259 int,
		@old_I4260 nvarchar(4000),
		@old_I4261 nvarchar(128),
		@old_I4262 nvarchar(128),
		@old_I4263 char(512),
		@old_I4299 nvarchar(1) ,
		@old_idsrc nvarchar(3),
		@old_IPUBLISH nvarchar(32),
		@old_ktag nvarchar(80),
		@old_MTAG nvarchar(80) ,
		@old_replic nvarchar(1),
		@new_I4201 nvarchar(30) ,
		@new_I4202 nvarchar(30),
		@new_I4203 nvarchar(30),
		@new_I4204 nvarchar(60),
		@new_I4205 nvarchar(1),
		@new_I4206 nvarchar(30),
		@new_I4207 nvarchar(24),
		@new_I4208 nvarchar(29),
		@new_I4209 nvarchar(1) ,
		@new_I4210 nvarchar(12),
		@new_I4211 nvarchar(15),
		@new_I4212 date,
		@new_I4213 nvarchar(12),
		@new_I4214 nvarchar(16),
		@new_I4215 nvarchar(5),
		@new_I4216 nvarchar(5),
		@new_I4217 nvarchar(60),
		@new_I4218 nvarchar(4),
		@new_I4219 numeric(12,2),
		@new_I4220 int,
		@new_I4221 date,
		@new_I4222 nvarchar(12),
		@new_I4223 nvarchar(16),
		@new_I4224 date,
		@new_I4225 nvarchar(8),
		@new_I4226 nvarchar(1),
		@new_I4228 nvarchar(1) ,
		@new_I4229 int,
		@new_I4230 int,
		@new_I4231 nvarchar(32),
		@new_I4232 nvarchar(32),
		@new_I4233 nvarchar(32),
		@new_I4234 nvarchar(32),
		@new_I4235 nvarchar(32),
		@new_I4236 datetime2(7),
		@new_I4237 nvarchar(16),
		@new_I4238 datetime2(7),
		@new_I4239 nvarchar(16),
		@new_I4240 nvarchar(8) ,
		@new_I4241 nvarchar(80),
		@new_I4242 nvarchar(80),
		@new_I4243 nvarchar(80),
		@new_I4244 nvarchar(48),
		@new_I4245 nvarchar(48),
		@new_I4246 nvarchar(48),
		@new_I4247 nvarchar(48),
		@new_I4248 nvarchar(48),
		@new_I4249 nvarchar(48),
		@new_I4250 date,
		@new_I4251 date,
		@new_I4252 date,
		@new_I4253 date,
		@new_I4254 numeric(12,2),
		@new_I4255 bit ,
		@new_I4256 numeric(12,2),
		@new_I4257 numeric(12,2),
		@new_I4258 nvarchar(1),
		@new_I4259 int,
		@new_I4260 nvarchar(4000),
		@new_I4261 nvarchar(128),
		@new_I4262 nvarchar(128),
		@new_I4263 char(512),
		@new_I4299 nvarchar(1) ,
		@new_idsrc nvarchar(3),
		@new_IPUBLISH nvarchar(32),
		@new_ktag nvarchar(80),
		@new_MTAG nvarchar(80) ,
		@new_replic nvarchar(1);

		SELECT @current_user = SUSER_SNAME();

		DECLARE @RowCount INTEGER,
		@I INTEGER;

		SELECT  @RowCount=count(*) FROM deleted;
		IF @RowCount = 0
			RETURN;

		DECLARE @tmp_ots_cl_inventory_update_d TABLE (
			ColumnID INT IDENTITY(1,1),
			[I4201] [nvarchar](30) NOT NULL,
			[I4202] [nvarchar](30) NULL,
			[I4203] [nvarchar](50) NULL,
			[I4204] [nvarchar](60) NULL,
			[I4205] [nvarchar](1) NULL,
			[I4206] [nvarchar](50) NULL,
			[I4207] [nvarchar](24) NULL,
			[I4208] [nvarchar](29) NULL,
			[I4209] [nvarchar](1) NOT NULL,
			[I4210] [nvarchar](12) NULL,
			[I4211] [nvarchar](15) NULL,
			[I4212] [date] NULL,
			[I4213] [nvarchar](12) NULL,
			[I4214] [nvarchar](16) NULL,
			[I4215] [nvarchar](5) NULL,
			[I4216] [nvarchar](5) NULL,
			[I4217] [nvarchar](60) NULL,
			[I4218] [nvarchar](4) NULL,
			[I4219] [numeric](12,2) NULL,
			[I4220] [int] NULL,
			[I4221] [date] NULL,
			[I4222] [nvarchar](12) NULL,
			[I4223] [nvarchar](16) NULL,
			[I4224] [date] NULL,
			[I4225] [nvarchar](8) NULL,
			[I4226] [nvarchar](1) NULL,
			[I4228] [nvarchar](1) NOT NULL,
			[I4229] [int] NULL,
			[I4230] [int] NULL,
			[I4231] [nvarchar](32) NULL,
			[I4232] [nvarchar](32) NULL,
			[I4233] [nvarchar](32) NULL,
			[I4234] [nvarchar](32) NULL,
			[I4235] [nvarchar](32) NULL,
			[I4236] [datetime2](7) NULL,
			[I4237] [nvarchar](16) NULL,
			[I4238] [datetime2](7) NULL,
			[I4239] [nvarchar](16) NULL,
			[I4240] [nvarchar](8) NOT NULL,
			[I4241] [nvarchar](80) NULL,
			[I4242] [nvarchar](80) NULL,
			[I4243] [nvarchar](80) NULL,
			[I4244] [nvarchar](48) NULL,
			[I4245] [nvarchar](48) NULL,
			[I4246] [nvarchar](48) NULL,
			[I4247] [nvarchar](48) NULL,
			[I4248] [nvarchar](50) NULL,
			[I4249] [nvarchar](48) NULL,
			[I4250] [date] NULL,
			[I4251] [date] NULL,
			[I4252] [date] NULL,
			[I4253] [date] NULL,
			[I4254] [numeric](12,2) NULL,
			[I4255] [bit] NOT NULL,
			[I4256] [numeric](12,2) NULL,
			[I4257] [numeric](12,2) NULL,
			[I4258] [nvarchar](1) NULL,
			[I4259] [int] NULL,
			[I4260] [nvarchar](4000) NULL,
			[I4261] [nvarchar](128) NULL,
			[I4262] [nvarchar](128) NULL,
			[I4263] [char](512) NULL,
			[I4299] [nvarchar](1) NOT NULL,
			[idsrc] [nvarchar](3) NULL,
			[IPUBLISH] [nvarchar](32) NULL,
			[ktag] [nvarchar](80) NULL,
			[MTAG] [nvarchar](80) NOT NULL,
			[replic] [nvarchar](1) NULL
			); 

		INSERT INTO @tmp_ots_cl_inventory_update_d  
			SELECT I4201,
				I4202,
				I4203,
				I4204,
				I4205,
				I4206,
				I4207,
				I4208,
				I4209,
				I4210,
				I4211,
				I4212,
				I4213,
				I4214,
				I4215,
				I4216,
				I4217,
				I4218,
				I4219,
				I4220,
				I4221,
				I4222,
				I4223,
				I4224,
				I4225,
				I4226,
				I4228,
				I4229,
				I4230,
				I4231,
				I4232,
				I4233,
				I4234,
				I4235,
				I4236,
				I4237,
				I4238,
				I4239,
				I4240,
				I4241,
				I4242,
				I4243,
				I4244,
				I4245,
				I4246,
				I4247,
				I4248,
				I4249,
				I4250,
				I4251,
				I4252,
				I4253,
				I4254,
				I4255,
				I4256,
				I4257,
				I4258,
				I4259,
				I4260,
				I4261,
				I4262,
				I4263,
				I4299,
				idsrc,
				IPUBLISH,
				ktag,
				MTAG,
				replic
			FROM deleted;

		DECLARE @tmp_ots_cl_inventory_update_i TABLE (
			ColumnID INT IDENTITY(1,1),
			[I4201] [nvarchar](30) NOT NULL,
			[I4202] [nvarchar](30) NULL,
			[I4203] [nvarchar](50) NULL,
			[I4204] [nvarchar](60) NULL,
			[I4205] [nvarchar](1) NULL,
			[I4206] [nvarchar](50) NULL,
			[I4207] [nvarchar](24) NULL,
			[I4208] [nvarchar](29) NULL,
			[I4209] [nvarchar](1) NOT NULL,
			[I4210] [nvarchar](12) NULL,
			[I4211] [nvarchar](15) NULL,
			[I4212] [date] NULL,
			[I4213] [nvarchar](12) NULL,
			[I4214] [nvarchar](16) NULL,
			[I4215] [nvarchar](5) NULL,
			[I4216] [nvarchar](5) NULL,
			[I4217] [nvarchar](60) NULL,
			[I4218] [nvarchar](4) NULL,
			[I4219] [numeric](12,2) NULL,
			[I4220] [int] NULL,
			[I4221] [date] NULL,
			[I4222] [nvarchar](12) NULL,
			[I4223] [nvarchar](16) NULL,
			[I4224] [date] NULL,
			[I4225] [nvarchar](8) NULL,
			[I4226] [nvarchar](1) NULL,
			[I4228] [nvarchar](1) NOT NULL,
			[I4229] [int] NULL,
			[I4230] [int] NULL,
			[I4231] [nvarchar](32) NULL,
			[I4232] [nvarchar](32) NULL,
			[I4233] [nvarchar](32) NULL,
			[I4234] [nvarchar](32) NULL,
			[I4235] [nvarchar](32) NULL,
			[I4236] [datetime2](7) NULL,
			[I4237] [nvarchar](16) NULL,
			[I4238] [datetime2](7) NULL,
			[I4239] [nvarchar](16) NULL,
			[I4240] [nvarchar](8) NOT NULL,
			[I4241] [nvarchar](80) NULL,
			[I4242] [nvarchar](80) NULL,
			[I4243] [nvarchar](80) NULL,
			[I4244] [nvarchar](48) NULL,
			[I4245] [nvarchar](48) NULL,
			[I4246] [nvarchar](48) NULL,
			[I4247] [nvarchar](48) NULL,
			[I4248] [nvarchar](50) NULL,
			[I4249] [nvarchar](48) NULL,
			[I4250] [date] NULL,
			[I4251] [date] NULL,
			[I4252] [date] NULL,
			[I4253] [date] NULL,
			[I4254] [numeric](12,2) NULL,
			[I4255] [bit] NOT NULL,
			[I4256] [numeric](12,2) NULL,
			[I4257] [numeric](12,2) NULL,
			[I4258] [nvarchar](1) NULL,
			[I4259] [int] NULL,
			[I4260] [nvarchar](4000) NULL,
			[I4261] [nvarchar](128) NULL,
			[I4262] [nvarchar](128) NULL,
			[I4263] [char](512) NULL,
			[I4299] [nvarchar](1) NOT NULL,
			[idsrc] [nvarchar](3) NULL,
			[IPUBLISH] [nvarchar](32) NULL,
			[ktag] [nvarchar](80) NULL,
			[MTAG] [nvarchar](80) NOT NULL,
			[replic] [nvarchar](1) NULL
			); 

		INSERT INTO @tmp_ots_cl_inventory_update_i  
			SELECT I4201,
				I4202,
				I4203,
				I4204,
				I4205,
				I4206,
				I4207,
				I4208,
				I4209,
				I4210,
				I4211,
				I4212,
				I4213,
				I4214,
				I4215,
				I4216,
				I4217,
				I4218,
				I4219,
				I4220,
				I4221,
				I4222,
				I4223,
				I4224,
				I4225,
				I4226,
				I4228,
				I4229,
				I4230,
				I4231,
				I4232,
				I4233,
				I4234,
				I4235,
				I4236,
				I4237,
				I4238,
				I4239,
				I4240,
				I4241,
				I4242,
				I4243,
				I4244,
				I4245,
				I4246,
				I4247,
				I4248,
				I4249,
				I4250,
				I4251,
				I4252,
				I4253,
				I4254,
				I4255,
				I4256,
				I4257,
				I4258,
				I4259,
				I4260,
				I4261,
				I4262,
				I4263,
				I4299,
				idsrc,
				IPUBLISH,
				ktag,
				MTAG,
				replic
			FROM inserted;


		SET @RowCount = (SELECT COUNT(*) FROM @tmp_ots_cl_inventory_update_d);

		SET @I = 1;

		WHILE (@I <= @RowCount) 

			BEGIN

				SELECT @old_mtag=mtag  FROM @tmp_ots_cl_inventory_update_d WHERE ColumnID = @I;

				SELECT @assetnum = (SELECT i4201 FROM mt.inventory WHERE MTAG = @old_mtag);

				BEGIN
					SELECT 
					@new_I4201 = i.I4201, @old_I4201 = d.I4201,
					@new_I4202 = i.I4202, @old_I4202 = d.I4202,
					@new_I4203 = i.I4203, @old_I4203 = d.I4203,
					@new_I4204 = i.I4204, @old_I4204 = d.I4204,
					@new_I4205 = i.I4205, @old_I4205 = d.I4205,
					@new_I4206 = i.I4206, @old_I4206 = d.I4206,
					@new_I4207 = i.I4207, @old_I4207 = d.I4207,
					@new_I4208 = i.I4208, @old_I4208 = d.I4208,
					@new_I4209 = i.I4209, @old_I4209 = d.I4209,
					@new_I4210 = i.I4210, @old_I4210 = d.I4210,
					@new_I4211 = i.I4211, @old_I4211 = d.I4211,
					@new_I4212 = i.I4212, @old_I4212 = d.I4212,
					@new_I4213 = i.I4213, @old_I4213 = d.I4213,
					@new_I4214 = i.I4214, @old_I4214 = d.I4214,
					@new_I4215 = i.I4215, @old_I4215 = d.I4215,
					@new_I4216 = i.I4216, @old_I4216 = d.I4216,
					@new_I4217 = i.I4217, @old_I4217 = d.I4217,
					@new_I4218 = i.I4218, @old_I4218 = d.I4218,
					@new_I4219 = i.I4219, @old_I4219 = d.I4219,
					@new_I4220 = i.I4220, @old_I4220 = d.I4220,
					@new_I4221 = i.I4221, @old_I4221 = d.I4221,
					@new_I4222 = i.I4222, @old_I4222 = d.I4222,
					@new_I4223 = i.I4223, @old_I4223 = d.I4223,
					@new_I4224 = i.I4224, @old_I4224 = d.I4224,
					@new_I4225 = i.I4225, @old_I4225 = d.I4225,
					@new_I4226 = i.I4226, @old_I4226 = d.I4226,
					@new_I4228 = i.I4228, @old_I4228 = d.I4228,
					@new_I4229 = i.I4229, @old_I4229 = d.I4229,
					@new_I4230 = i.I4230, @old_I4230 = d.I4230,
					@new_I4231 = i.I4231, @old_I4231 = d.I4231,
					@new_I4232 = i.I4232, @old_I4232 = d.I4232,
					@new_I4233 = i.I4233, @old_I4233 = d.I4233,
					@new_I4234 = i.I4234, @old_I4234 = d.I4234,
					@new_I4235 = i.I4235, @old_I4235 = d.I4235,
					@new_I4236 = i.I4236, @old_I4236 = d.I4236,
					@new_I4237 = i.I4237, @old_I4237 = d.I4237,
					@new_I4238 = i.I4238, @old_I4238 = d.I4238,
					@new_I4239 = i.I4239, @old_I4239 = d.I4239,
					@new_I4240 = i.I4240, @old_I4240 = d.I4240,
					@new_I4241 = i.I4241, @old_I4241 = d.I4241,
					@new_I4242 = i.I4242, @old_I4242 = d.I4242,
					@new_I4243 = i.I4243, @old_I4243 = d.I4243,
					@new_I4244 = i.I4244, @old_I4244 = d.I4244,
					@new_I4245 = i.I4245, @old_I4245 = d.I4245,
					@new_I4246 = i.I4246, @old_I4246 = d.I4246,
					@new_I4247 = i.I4247, @old_I4247 = d.I4247,
					@new_I4248 = i.I4248, @old_I4248 = d.I4248,
					@new_I4249 = i.I4249, @old_I4249 = d.I4249,
					@new_I4250 = i.I4250, @old_I4250 = d.I4250,
					@new_I4251 = i.I4251, @old_I4251 = d.I4251,
					@new_I4252 = i.I4252, @old_I4252 = d.I4252,
					@new_I4253 = i.I4253, @old_I4253 = d.I4253,
					@new_I4254 = i.I4254, @old_I4254 = d.I4254,
					@new_I4255 = i.I4255, @old_I4255 = d.I4255,
					@new_I4256 = i.I4256, @old_I4256 = d.I4256,
					@new_I4257 = i.I4257, @old_I4257 = d.I4257,
					@new_I4258 = i.I4258, @old_I4258 = d.I4258,
					@new_I4259 = i.I4259, @old_I4259 = d.I4259,
					@new_I4260 = i.I4260, @old_I4260 = d.I4260,
					@new_I4261 = i.I4261, @old_I4261 = d.I4261,
					@new_I4262 = i.I4262, @old_I4262 = d.I4262,
					@new_I4263 = i.I4263, @old_I4263 = d.I4263,
					@new_I4299 = i.I4299, @old_I4299 = d.I4299,
					@new_ktag = i.KTAG, @old_ktag = d.KTAG,
					@new_MTAG = i.MTAG, @old_MTAG = d.MTAG
					FROM @tmp_ots_cl_inventory_update_i i, @tmp_ots_cl_inventory_update_d d  WHERE i.ColumnID = @I AND d.ColumnID = @I;
				END

				-- check each column in inventory for a change and call procedure to insert record for it	
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4201',@old_I4201,@new_I4201;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4202',@old_I4202,@new_I4202;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4203',@old_I4203,@new_I4203;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4204',@old_I4204,@new_I4204;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4205',@old_I4205,@new_I4205;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4206',@old_I4206,@new_I4206;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4207',@old_I4207,@new_I4207;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4208',@old_I4208,@new_I4208;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4209',@old_I4209,@new_I4209;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4210',@old_I4210,@new_I4210;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4211',@old_I4211,@new_I4211;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4212',@old_I4212,@new_I4212;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4213',@old_I4213,@new_I4213;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4214',@old_I4214,@new_I4214;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4215',@old_I4215,@new_I4215;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4216',@old_I4216,@new_I4216;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4217',@old_I4217,@new_I4217;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4218',@old_I4218,@new_I4218;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4219',@old_I4219,@new_I4219;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4220',@old_I4220,@new_I4220;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4221',@old_I4221,@new_I4221;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4222',@old_I4222,@new_I4222;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4223',@old_I4223,@new_I4223;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4224',@old_I4224,@new_I4224;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4225',@old_I4225,@new_I4225;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4226',@old_I4226,@new_I4226;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4228',@old_I4228,@new_I4228;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4229',@old_I4229,@new_I4229;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4230',@old_I4230,@new_I4230;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4231',@old_I4231,@new_I4231;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4232',@old_I4232,@new_I4232;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4233',@old_I4233,@new_I4233;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4234',@old_I4234,@new_I4234;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4235',@old_I4235,@new_I4235;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4236',@old_I4236,@new_I4236;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4237',@old_I4237,@new_I4237;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4238',@old_I4238,@new_I4238;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4239',@old_I4239,@new_I4239;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4240',@old_I4240,@new_I4240;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4241',@old_I4241,@new_I4241;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4242',@old_I4242,@new_I4242;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4243',@old_I4243,@new_I4243;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4244',@old_I4244,@new_I4244;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4245',@old_I4245,@new_I4245;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4246',@old_I4246,@new_I4246;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4247',@old_I4247,@new_I4247;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4248',@old_I4248,@new_I4248;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4249',@old_I4249,@new_I4249;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4250',@old_I4250,@new_I4250;	
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4251',@old_I4251,@new_I4251;	
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4252',@old_I4252,@new_I4252;	
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4253',@old_I4253,@new_I4253;	
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4254',@old_I4254,@new_I4254;	
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4255',@old_I4255,@new_I4255;	
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4256',@old_I4256,@new_I4256;	
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4257',@old_I4257,@new_I4257;	
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4258',@old_I4258,@new_I4258;	
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4259',@old_I4259,@new_I4259;	
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4260',@old_I4260,@new_I4260;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4261',@old_I4261,@new_I4261;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4262',@old_I4262,@new_I4262;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4263',@old_I4263,@new_I4263;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','I4299',@old_I4299,@new_I4299;
				EXEC [mt].[ots_cl_log_insert] @current_user,@new_I4201,@new_MTAG,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','KTAG',@old_KTAG,@new_KTAG;	

				SET @I = @I + 1

		END

	SET NOCOUNT OFF;

END TRY

BEGIN CATCH

    THROW      --  Uncomment only if you need to see the error in debug or development;

END CATCH;

