dbo.ATT_TUHelperHeadPerson

1create   trigger ATT_TUHelperHeadPerson on HelperHeadPerson  for Update not for Replication as begin  declare @SQLcmd nvarchar(1000) declare @uid_personwantsorg
2 varchar(38) declare @BasisObjectKey varchar(138) declare @UID_PWOStateFinalError nvarchar(64) declare @Parameter nvarchar(1000) BEGIN TRY if exists (select
3 top 1 1 from deleted) goto start if exists (select top 1 1 from inserted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = 
4dbo.QBM_FGISessionContext('') if update(XOrigin) begin    declare @RecalcParameter_01 QBM_YCursorBuffer insert into @RecalcParameter_01 (ObjectKey1, UID1
5, Ident1) select dbo.QBM_FCVElementToObjectKey1('Person', '', d.UID_Person), v.UID_PWODecisionRule, 'A' from deleted d join HelperHeadPerson a on d.XObjectKey
6 = a.XObjectKey and d.XOrigin > 0 and a.XOrigin = 0 cross join (values ('ATT-PWODecisionRule-CM') , ('ATT-PWODecisionRule-EM') , ('ATT-PWODecisionRule-XM'
7) , ('ATT-PWODecisionRule-AM') ) as v (UID_PWODecisionRule) exec QER_PITShopHelperFill_Recalc @RecalcParameter_01, @GenprocID  end END TRY BEGIN CATCH 
8exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
9