dbo.ATT_TUAccProduct

1    create   trigger ATT_TUAccProduct on AccProduct  for UPDATE not for Replication as begin  declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext
2('') BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start:  if update(UID_OrgAttestator
3) begin declare @RecalcParameter_01 QBM_YCursorBuffer insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1)  select dbo.QBM_FCVElementToObjectKey1
4('Person', '', pio.UID_Person), 'ATT-PWODecisionRule-AN' ,'A' from inserted i join PersonInBaseTree pio on i.UID_OrgAttestator = pio.UID_Org union all 
5select dbo.QBM_FCVElementToObjectKey1('Person', '', pio.UID_Person), 'ATT-PWODecisionRule-AN' , 'A' from deleted d join PersonInBaseTree pio on d.UID_OrgAttestator
6 = pio.UID_Org exec QER_PITShopHelperFill_Recalc @RecalcParameter_01, @GenprocID end  if update(UID_OrgRuler) begin declare @RecalcParameter_03 QBM_YCursorBuffer
7 insert into @RecalcParameter_03 (ObjectKey1, UID1, Ident1)  select i.XObjectKey , v.UID_PWODecisionRule, 'A' from inserted i cross join ( values ('ARS-AttestationRule-KA'
8 ) , ('ATT-PWODecisionRule-OA') , ('ATT-PWODecisionRule-EO') ) as v (UID_PWODecisionRule) exec QER_PITShopHelperFill_Recalc @RecalcParameter_03, @GenprocID
9 end  if update(UID_OrgAttestator) begin declare @RecalcParameter_02 QBM_YCursorBuffer insert into @RecalcParameter_02 (ObjectKey1, UID1, Ident1)  select
10 i.XObjectKey, 'ATT-PWODecisionRule-OrgATT', 'A' from inserted i exec QER_PITShopHelperFill_Recalc @RecalcParameter_02, @GenprocID end   END TRY BEGIN 
11CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  return end 
12