dbo.QER_TUPWODecisionSubmethod

1    create   trigger QER_TUPWODecisionSubmethod on PWODecisionSubmethod for Update not for Replication as begin  declare @QER_ITShop_OnWorkflowUpdate
2 varchar(16) BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID
3 varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  if update(RevisionNumber) begin select @QER_ITShop_OnWorkflowUpdate = dbo.QBM_FGIConfigparmValue
4('QER\ITShop\OnWorkflowUpdate') if @QER_ITShop_OnWorkflowUpdate in ('RESET', 'ABORT') begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01
5(Object, SubObject, GenProcID) select x.uid, null, @GenProcID from ( select pwo.UID_PersonWantsOrg as uid from PWODecisionSubmethod sm join deleted d on
6 sm.UID_PWODecisionSubMethod = d.UID_PWODecisionSubMethod and sm.RevisionNumber <> d.RevisionNumber join QERWorkingMethod wm on wm.UID_PWODecisionSubMethod
7 = sm.UID_PWODecisionSubMethod join PersonWantsOrg pwo on pwo.UID_QERWorkingMethod = wm.UID_QERWorkingMethod ) as x if @QER_ITShop_OnWorkflowUpdate = 'RESET'
8 begin exec QBM_PDBQueueInsert_Bulk 'QER-K-ITSHOPOrder-RESET', @DBQueueElements_01 end if @QER_ITShop_OnWorkflowUpdate = 'ABORT' begin exec QBM_PDBQueueInsert_Bulk
9 'QER-K-ITSHOPOrder-ABORT', @DBQueueElements_01 end end   declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02(Object, SubObject
10, GenProcID) select distinct ohm.UID_Org, null, @GenProcID from PWODecisionSubMethod s join deleted d on s.UID_PWODecisionSubMethod = d.UID_PWODecisionSubMethod
11 join PWODecisionMethod m on m.UID_SubMethodOrderProduct = s.UID_PWODecisionSubMethod or m.UID_SubMethodOrderProlongate = s.UID_PWODecisionSubMethod or
12 m.UID_SubMethodOrderUnsubscribe = s.UID_PWODecisionSubMethod join BaseTreeHasPWODecisionMethod ohm on m.UID_PWODecisionMethod = ohm.uid_PWODecisionmethod
13 exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRack-All', @DBQueueElements_02 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18
14, 1) WITH NOWAIT END CATCH ende: return end 
15