dbo.CPL_TUATTComplianceRule

1 create   trigger CPL_TUATTComplianceRule on ComplianceRule  for Update not for Replication as begin  BEGIN TRY if exists (select top 1 1 from inserted
2) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext
3('') declare @errno int declare @errmsg nvarchar(255)  if update(UID_OrgAttestator) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01
4 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select ac.UID_attestationcase as uid from inserted i join attestationcase ac on ac.ObjectkeyBase
5 = i.XObjectKey join AttestationHelper ah on ac.uid_attestationCase = ah.uid_attestationcase and ah.UID_PWODecisionRule in ('CPL-PWODecisionRule-AR') union
6 select ac.UID_attestationcase as uid from inserted i join personinBaseTree  pin on i.uid_NonCompliance = pin.uid_org  and pin.XOrigin > 0 join attestationcase
7 ac on ac.ObjectkeyBase = pin.XObjectKey join AttestationHelper ah on ac.uid_attestationCase = ah.uid_attestationcase and ah.UID_PWODecisionRule in ('CPL-PWODecisionRule-AR'
8) ) as x  exec QBM_PDBQueueInsert_Bulk 'ATT-K-AttestationHelper', @DBQueueElements_01 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR
9 ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
10