Back to OIM Explorer

dbo.QER_TUHelperHeadPerson

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on HelperHeadPerson. HOCallMethod -> personwantsorg.Abort at line 16; References QBM_PJobCreate*; References QBM_PJobCreate_HOCallMethod*; Trigger parent table: HelperHeadPerson

Source: sandbox-db sys.sql_modules

Source size: 3.366 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

  • HOCallMethod -> personwantsorg.Abort at line 16
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOCallMethod*
  • Trigger parent table: HelperHeadPerson

Typed Edges

  • calls object method personwantsorg.Abort HOCallMethod -> personwantsorg.Abort at line 16
  • trigger on table HelperHeadPerson Trigger parent table: HelperHeadPerson
  • references source dbo.QBM_FCVStringToBit source text reference
  • references source dbo.QBM_FGIConfigparmValue source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_FGIXOriginChanged_Effect source text reference
  • references source dbo.QER_FGIGenProcIDForPWO source text reference
  • references source dbo.QER_FGIPWOStateFinalError source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOCallMethod source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QER_PITShopHelperFill source text reference
  • references source dbo.QER_PITShopHelperFill_Recalc source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL134 lines
1CREATE trigger QER_TUHelperHeadPerson2  ON HelperHeadPerson FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38)7  DECLARE @GenProcIDToUse varchar(38)8  DECLARE @CfgUseGenProcID BIT = dbo.QBM_FCVStringToBit(dbo.QBM_FGIConfigparmValue('Common\ProcessState\UseGenProcIDFromPWO'))9  DECLARE @SQLcmd nvarchar(1000)10  DECLARE @uid_personwantsorg varchar(38)11  DECLARE @BasisObjectKey varchar(138)12  DECLARE @UID_PWOStateFinalError nvarchar(64)13  DECLARE @ElementBuffer QBM_YCursorBuffer14  DECLARE @ElementCount int15  DECLARE @ElementIndex int16  DECLARE @ChangedPersonHead QBM_YSingleGUID17  BEGIN TRY18    IF EXISTS(19      SELECT TOP 1 120      FROM deleted)21    GOTO start22    RETURN start:23    SELECT @GenProcID = dbo.QBM_FGISessionContext('')24    IF25    UPDATE(XOrigin)26    BEGIN27      INSERT INTO @ChangedPersonHead(UID_SingleGuid)28      SELECT29        DISTINCT d.UID_PersonHead AS uid30      FROM HelperHeadPerson a31      JOIN deleted d32        ON a.XObjectKey = d.XObjectKey33      WHERE34        dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin,35      a.XOrigin,36      1,37      1) = 138      IF @@ROWCOUNT > 039      BEGIN40        DECLARE @RecalcParameter QBM_YCursorBuffer41        INSERT INTO @RecalcParameter(UID1,42        ObjectKey1,43        Ident1)44        SELECT45          'QER-PWODecisionRule-CM',46          e.XObjectKey,47          'I'48        FROM(49        SELECT d.UID_Person50        FROM HelperHeadPerson a51        JOIN deleted d52          ON a.XObjectKey = d.XObjectKey53        WHERE54          dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin, a.XOrigin, 1, 1) = 1) x55        JOIN Person e56          ON x.UID_Person = e.UID_Person57        EXEC QER_PITShopHelperFill_Recalc @RecalcParameter,58          @GenprocID59      END60      INSERT INTO @ElementBuffer(UID1,61      ObjectKey1,62      UID2)63      SELECT64        pwo.uid_personwantsorg,65        pwo.XObjectKey,66        dbo.QER_FGIGenProcIDForPWO(pwo.GenProcID,67        @GenProcID,68        @CfgUseGenProcID) AS GenProcID69      FROM HelperHeadPerson a70      JOIN deleted y71        ON a.XObjectKey = y.XObjectKey72      JOIN Delegation d73        ON d.ObjectKeyDelegated = y.XObjectKey74      JOIN personwantsorg pwo75        ON d.uid_personwantsorg = pwo.uid_personwantsorg76      WHERE77        dbo.QBM_FGIXOriginChanged_Effect(y.XOrigin,78      a.XOrigin,79      1,80      1) = 1 AND pwo.OrderState IN('Assigned',81      'Granted',82      'New',83      'OrderProduct',84      'OrderProlongate',85      'OrderUnsubscribe',86      'Waiting')87      SELECT @ElementCount = @@ROWCOUNT88      SELECT @ElementIndex = 189      WHILE @ElementIndex <= @ElementCount90      BEGIN91        SELECT92          TOP 1 @uid_personwantsorg = bu.UID1,93          @BasisObjectKey = bu.ObjectKey1,94          @GenProcIDToUse = bu.UID295        FROM @ElementBuffer bu96        WHERE97          bu.ElementIndex = @ElementIndex98        SELECT @SQLcmd = N 'uid_personwantsorg = ''' + rtrim(@uid_personwantsorg) + N ''''99        SELECT @UID_PWOStateFinalError = dbo.QER_FGIPWOStateFinalError(@UID_PersonWantsOrg)100        EXEC QBM_PJobCreate_HOCallMethod @objecttype = 'personwantsorg',101          @whereclause = @SQLcmd,102          @save = 1,103          @MethodName = 'Abort',104          @GenProcID = @GenProcIDToUse,105          @ObjectKeysAffected = DEFAULT,106          @param1 = '#LDS#Closing delegation because its source was deleted.|',107          @param2 = @UID_PWOStateFinalError,108          @Retries = 3,109          @isToFreezeOnError = 1,110          @BasisObjectKey = @BasisObjectKey,111          @checkForExisting = 1,112          @WhereClauseAdditional = ' OrderState in (''Assigned'', ''Granted'', ''New'', ''OrderProduct'', ''OrderProlongate'', ''OrderUnsubscribe'', ''Waiting'')'113        SELECT @ElementIndex += 1114      END115      DELETE Delegation116      FROM deleted d117      JOIN HelperHeadPerson i118        ON i.XObjectKey = d.XObjectKey119      JOIN Delegation dl120        ON d.XObjectKey = dl.ObjectKeyDelegated121      WHERE122        i.XOrigin = 0 AND d.XOrigin > 0123    END124  END TRY125  BEGIN CATCH126    EXEC QBM_PSessionErrorAdd DEFAULT127    RAISERROR('',128    18,129    1)130      WITH NOWAIT131  END CATCH132  ende:133  RETURN134END
Open raw exported source
SQL ยท Raw23 lines
1create   trigger QER_TUHelperHeadPerson on HelperHeadPerson  for update not for Replication as begin  declare @GenProcID varchar(38) declare @GenProcIDToUse2 varchar(38) declare @CfgUseGenProcID bit = dbo.QBM_FCVStringToBit(dbo.QBM_FGIConfigparmValue('Common\ProcessState\UseGenProcIDFromPWO')) declare @SQLcmd3 nvarchar(1000) declare @uid_personwantsorg varchar(38) declare @BasisObjectKey varchar(138) declare @UID_PWOStateFinalError nvarchar(64) declare @ElementBuffer4 QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int declare @ChangedPersonHead QBM_YSingleGUID BEGIN TRY if exists (select top 1 1 from5 deleted) goto start return start: select @GenProcID = dbo.QBM_FGISessionContext('') if update(XOrigin) begin insert into @ChangedPersonHead (UID_SingleGuid6) select distinct d.UID_PersonHead as uid from HelperHeadPerson a join deleted d on a.XObjectKey = d.XObjectKey where dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin7, a.XOrigin, 1, 1) = 1 if @@ROWCOUNT > 0  begin declare @RecalcParameter QBM_YCursorBuffer insert into @RecalcParameter (UID1, ObjectKey1, Ident1) select8 'QER-PWODecisionRule-CM', e.XObjectKey, 'I' from (select d.UID_Person from HelperHeadPerson a join deleted d on a.XObjectKey = d.XObjectKey where dbo.QBM_FGIXOriginChanged_Effect9(d.XOrigin, a.XOrigin, 1, 1) = 1 ) x join Person e on x.UID_Person = e.UID_Person exec QER_PITShopHelperFill_Recalc @RecalcParameter, @GenprocID end   10insert into @ElementBuffer(UID1, ObjectKey1, UID2) select pwo.uid_personwantsorg, pwo.XObjectKey, dbo.QER_FGIGenProcIDForPWO(pwo.GenProcID, @GenProcID,11 @CfgUseGenProcID) as GenProcID from HelperHeadPerson a join deleted y on a.XObjectKey = y.XObjectKey join Delegation d on d.ObjectKeyDelegated = y.XObjectKey12 join personwantsorg pwo on d.uid_personwantsorg = pwo.uid_personwantsorg    where dbo.QBM_FGIXOriginChanged_Effect(y.XOrigin, a.XOrigin, 1, 1) = 1 and13 pwo.OrderState in ('Assigned', 'Granted', 'New', 'OrderProduct', 'OrderProlongate', 'OrderUnsubscribe', 'Waiting') select @ElementCount = @@ROWCOUNT select14 @ElementIndex = 1 while @ElementIndex <= @ElementCount begin select top 1 @uid_personwantsorg = bu.UID1 , @BasisObjectKey = bu.ObjectKey1 ,@GenProcIDToUse15 = bu.UID2 from @ElementBuffer bu where bu.ElementIndex = @ElementIndex select @SQLcmd = N'uid_personwantsorg = ''' + rtrim(@uid_personwantsorg) + N''''16 select @UID_PWOStateFinalError = dbo.QER_FGIPWOStateFinalError(@UID_PersonWantsOrg) exec QBM_PJobCreate_HOCallMethod @objecttype = 'personwantsorg' , 17@whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort' , @GenProcID = @GenProcIDToUse , @ObjectKeysAffected = DEFAULT , @param1 = '#LDS#Closing delegation because its source was deleted.|'18 , @param2 = @UID_PWOStateFinalError , @Retries = 3 , @isToFreezeOnError = 1 , @BasisObjectKey = @BasisObjectKey , @checkForExisting = 1  , @WhereClauseAdditional19 = ' OrderState in (''Assigned'', ''Granted'', ''New'', ''OrderProduct'', ''OrderProlongate'', ''OrderUnsubscribe'', ''Waiting'')'  select @ElementIndex20 += 1 end     delete Delegation from deleted d join HelperHeadPerson i on i.XObjectKey = d.XObjectKey join Delegation dl on d.XObjectKey = dl.ObjectKeyDelegated21 where i.XOrigin = 0 and d.XOrigin > 0  end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return22 end 23