dbo.RPS_TURPSSubscription

1create   trigger RPS_TURPSSubscription on RPSSubscription  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('') if update(UID_Person) or update(UID_RPSReport) begin if exists (select top 1 1 from inserted i join RPSSubscription s on i.UID_RPSSubscription = s.UID_RPSSubscription
4 left outer join PersonHasRPSReport t on t.uid_RPSReport = s.UID_RPSReport and t.UID_Person = s.UID_Person and t.XOrigin > 0  where t.uid_person is null
5  ) begin raiserror ('#LDS#Assignment is not permitted due to missing combination of person and report.|', 18, 2) with nowait end end if update(isRejected
6) begin if exists (select top 1 1 from deleted d join RPSSubscription s on d.UID_RPSSubscription = s.UID_RPSSubscription and d.isRejected = 1 and isnull
7(s.isRejected, 0) = 0 left outer join PersonHasRPSReport t on t.uid_RPSReport = s.UID_RPSReport and t.UID_Person = s.UID_Person and t.XOrigin > 0  where
8 t.uid_person is null  ) begin raiserror ('#LDS#Assignment is not permitted due to missing combination of person and report.|', 18, 2) with nowait end 
9end if update(UID_Person) begin declare @DBQueueElements_PHO QBM_YDBQueueRaw insert into @DBQueueElements_PHO (object, subobject, genprocid) select x.uid
10, null, @GenProcID from ( select distinct d.UID_Person as uid from deleted d join RPSSubscription r on d.UID_RPSSubscription = r.UID_RPSSubscription where
11 isnull(d.UID_Person, '') <> isnull(r.UID_Person, '') ) as x exec QBM_PDBQueueInsert_Bulk 'RPS-K-PersonHasObject', @DBQueueElements_PHO end  END TRY BEGIN
12 CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
13