dbo.TSB_TIBaseTreeHasUNSGroupB3

1  create   trigger TSB_TIBaseTreeHasUNSGroupB3 on BaseTreeHasUNSGroupB3  for Insert not for Replication as begin  declare @QBM_BitPatternXOrigin_Direct
2 int = dbo.QBM_FGIBitPatternXOrigin('|Direct|', 0) declare @QBM_BitPatternXOrigin_Inherit_inv int = dbo.QBM_FGIBitPatternXOrigin('|Inherit|', 1)  BEGIN
3 TRY if exists (select top 1 1 from inserted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')
4 declare @AssignCheckValues QBM_YparameterList insert into @AssignCheckValues(Parameter1, Parameter2) select i.UID_Org, i.XOrigin from inserted i exec 
5QER_PAssignmentCheckValid 'TSB-AsgnBT-UNSGroupB3', @AssignCheckValues, @GenProcID  if exists (select top 1 1 from inserted i join BaseTree dest on i.uid_Org
6 = dest.uid_Org  join UNSGroupB3 elem on i.uid_UNSGroupB3 = elem.uid_UNSGroupB3 where dbo.QER_FGIITShopFlagCombineValid(dest.XObjectKey, null, null
7, elem.XObjectKey, elem.IsForITShop, elem.IsITShopOnly) = 0 and i.XOrigin & @QBM_BitPatternXOrigin_Direct > 0 ) begin  raiserror ('#LDS#Assignment is not permitted due to the combination of IT Shop flags.|'
8, 18, 2) with nowait end  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, 'TSB-K-OrgHasUNSGroupB3'
9, @GenProcID from ( select distinct d.uid_org as uid from inserted d  where d.XOrigin & @QBM_BitPatternXOrigin_Inherit_inv > 0  ) as x exec QBM_PDBQueueInsert_Bulk
10 'QER-K-AllChildrenOfOrg', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid
11) select x.uid, null, @GenProcID from ( select distinct b.uid_org as uid from inserted d join BaseTree b on d.uid_org = b.uid_org where b.ITShopInfo = 
12'BO' and d.XIsInEffect = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-OrgAutoChild', @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueueRaw insert
13 into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct UNS.UID_UNSAccountB as uid from inserted
14 i join (select pio.uid_person, pio.uid_org from personinBaseTree pio where pio.XOrigin > 0 union all select uid_person, uid_org from helperPersonOrg )
15 hpo on hpo.uid_org = i.uid_org join UNSAccountB UNS on UNS.uid_person = hpo.uid_person and UNS.IsGroupAccount_UNSGroupB3 = 1 where i.XIsInEffect = 1
16 ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB3', @DBQueueElements_03  declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04
17 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct i.uid_org as uid from inserted i where i.XIsInEffect = 1 ) as x exec
18 QBM_PDBQueueInsert_Bulk 'TSB-K-BaseTreeHasObject', @DBQueueElements_04 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH
19 NOWAIT END CATCH ende: return end 
20