Back to OIM Explorer

dbo.ATT_TUAttestationPolicy

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on AttestationPolicy. Bulk DBQueue insert -> ATT-K-Attestation-RESET / ATT_ZAttestationReset at line 16; Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 16; Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 16; Bulk DBQueue insert -> ATT-K-HelperAttestationPolicy / ATT_ZHelperAttestationPolicy at line 16

Source: sandbox-db sys.sql_modules

Source size: 3.831 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Bulk DBQueue insert -> ATT-K-Attestation-RESET / ATT_ZAttestationReset at line 16
  • Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 16
  • Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 16
  • Bulk DBQueue insert -> ATT-K-HelperAttestationPolicy / ATT_ZHelperAttestationPolicy at line 16
  • Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 17
  • Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 17
  • Bulk DBQueue insert -> ATT-K-HelperAttestationPolicy / ATT_ZHelperAttestationPolicy at line 17
  • Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 22
  • Bulk DBQueue insert -> ATT-K-HelperAttestationPolicy / ATT_ZHelperAttestationPolicy at line 22
  • Bulk DBQueue insert -> ATT-K-HelperAttestationPolicy / ATT_ZHelperAttestationPolicy at line 24
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: AttestationPolicy

Typed Edges

  • queues DBQueue task ATT_ZAttestationReset at line 16 Bulk DBQueue insert -> ATT-K-Attestation-RESET / ATT_ZAttestationReset at line 16
  • queues DBQueue task ATT_ZAttestationAbort at line 16 Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 16
  • queues DBQueue task ATT_ZHelperAttestationPolicy at line 16 Bulk DBQueue insert -> ATT-K-HelperAttestationPolicy / ATT_ZHelperAttestationPolicy at line 16
  • queues DBQueue task ATT_ZAttestationAbort at line 17 Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 17
  • queues DBQueue task ATT_ZHelperAttestationPolicy at line 17 Bulk DBQueue insert -> ATT-K-HelperAttestationPolicy / ATT_ZHelperAttestationPolicy at line 17
  • queues DBQueue task ATT_ZAttestationAbort at line 22 Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 22
  • queues DBQueue task ATT_ZHelperAttestationPolicy at line 22 Bulk DBQueue insert -> ATT-K-HelperAttestationPolicy / ATT_ZHelperAttestationPolicy at line 22
  • queues DBQueue task ATT_ZHelperAttestationPolicy at line 24 Bulk DBQueue insert -> ATT-K-HelperAttestationPolicy / ATT_ZHelperAttestationPolicy at line 24
  • trigger on table AttestationPolicy Trigger parent table: AttestationPolicy
  • references source dbo.QBM_FCVElementToObjectKey1 source text reference
  • references source dbo.QBM_FGIConfigparmValue source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PSQLCheckExecutable 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

SQL157 lines
1CREATE trigger ATT_TUAttestationPolicy2  ON AttestationPolicy FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @SQLToCheck QBM_YParameterList7  DECLARE @QER_Attestation_OnWorkflowAssign varchar(16)8  BEGIN TRY9    IF EXISTS(10      SELECT TOP 1 111      FROM inserted)12    GOTO start13    IF EXISTS(14      SELECT TOP 1 115      FROM deleted)16    GOTO start17    RETURN start:18    DECLARE @GenProcID varchar(38)19    SELECT @GenProcID = dbo.QBM_FGISessionContext('')20    IF21    UPDATE(WhereClause)22    BEGIN23      INSERT INTO @SQLToCheck(Parameter1,24      ContentFull)25      SELECT26        c.XObjectKey,27        'select top 1 1 as columnvalue from ' + t.TableName + '28		 where (29		 ' + c.WhereClause + '30		 )'31      FROM inserted c32      JOIN AttestationObject o33        ON c.UID_AttestationObject = o.UID_AttestationObject34      JOIN DialogTable t35        ON o.UID_DialogTable = t.UID_DialogTable36      WHERE37        c.WhereClause > ' '38      UPDATE @SQLToCheck39      SET ContentFull = REPLACE(replace(ContentFull, '@UID_QERPickCategory', '''#'''),40      '@UID_AttestationPolicy',41      '''#''')42      EXEC QBM_PSQLCheckExecutable @SQLToCheck,43        @RaiseError = 144    END45    IF dbo.QBM_FGIConfigparmValue('QER\Attestation') = ''46    BEGIN47      GOTO endLabel48    END49    IF50    UPDATE(UID_PWODecisionMethod)51    BEGIN52      SELECT53        @QER_Attestation_OnWorkflowAssign = dbo.QBM_FGIConfigparmValue('QER\Attestation\OnWorkflowAssign')54      IF @QER_Attestation_OnWorkflowAssign IN('RESET',55      'ABORT')56      BEGIN57        DECLARE @DBQueueElements_01 QBM_YDBQueueRaw58        INSERT INTO @DBQueueElements_01(Object,59        SubObject,60        GenProcID)61        SELECT62          x.uid,63          NULL,64          @GenProcID65        FROM(66        SELECT ac.UID_AttestationCase AS uid67        FROM AttestationPolicy po68        JOIN deleted d69          ON po.UID_AttestationPolicy = d.UID_AttestationPolicy AND isnull(po.UID_PWODecisionMethod, '') <> isnull(d.UID_PWODecisionMethod,70        '') AND po.UID_PWODecisionMethod > ' '71        JOIN PWODecisionMethod m72          ON d.UID_PWODecisionMethod = m.UID_PWODecisionMethod73        JOIN QERWorkingMethod wm74          ON wm.UID_PWODecisionSubMethod = m.UID_SubMethodOrderProduct75        JOIN AttestationCase ac76          ON ac.UID_QERWorkingMethod = wm.UID_QERWorkingMethod AND ac.IsClosed = 0) AS x77        IF @QER_Attestation_OnWorkflowAssign = 'RESET'78        BEGIN79          EXEC QBM_PDBQueueInsert_Bulk 'ATT-K-Attestation-RESET',80            @DBQueueElements_0181        END82        IF @QER_Attestation_OnWorkflowAssign = 'ABORT'83        BEGIN84          EXEC QBM_PDBQueueInsert_Bulk 'ATT-K-Attestation-ABORT',85            @DBQueueElements_0186        END87      END88      DECLARE @DBQueueElements_02 QBM_YDBQueueRaw89      INSERT INTO @DBQueueElements_02(Object,90      SubObject,91      GenProcID)92      SELECT93        x.uid,94        NULL,95        @GenProcID96      FROM(97      SELECT ac.UID_AttestationCase AS uid98      FROM AttestationPolicy po99      JOIN deleted d100        ON po.UID_AttestationPolicy = d.UID_AttestationPolicy AND isnull(po.UID_PWODecisionMethod, '') <> isnull(d.UID_PWODecisionMethod,101      '') AND po.UID_PWODecisionMethod IS NULL102      JOIN PWODecisionMethod m103        ON d.UID_PWODecisionMethod = m.UID_PWODecisionMethod104      JOIN QERWorkingMethod wm105        ON wm.UID_PWODecisionSubMethod = m.UID_SubMethodOrderProduct106      JOIN AttestationCase ac107        ON ac.UID_QERWorkingMethod = wm.UID_QERWorkingMethod AND ac.IsClosed = 0) AS x108      EXEC QBM_PDBQueueInsert_Bulk 'ATT-K-Attestation-ABORT',109        @DBQueueElements_02110    END111    IF112    UPDATE(IsInactive)113    BEGIN114      DECLARE @DBQueueElements_03 QBM_YDBQueueRaw115      INSERT INTO @DBQueueElements_03(object,116      subobject,117      genprocid)118      SELECT119        x.uid,120        NULL,121        @GenProcID122      FROM(123      SELECT uid_AttestationPolicy AS uid124      FROM inserted) AS x125      EXEC QBM_PDBQueueInsert_Bulk 'ATT-K-HelperAttestationPolicy',126        @DBQueueElements_03127    END128    IF129    UPDATE(UID_AERoleOwner)130    BEGIN131      DECLARE @RecalcParameter_01 QBM_YCursorBuffer132      INSERT INTO @RecalcParameter_01(ObjectKey1,133      UID1,134      Ident1)135      SELECT136        dbo.QBM_FCVElementToObjectKey1('AERole',137        '',138        i.UID_AERoleOwner),139        v.UID_PWODecisionRule,140        'A'141      FROM inserted i CROSS142      JOIN(143      VALUES('ATT-PWODecisionRule-PW')) AS v(UID_PWODecisionRule)144      EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_01,145        @GenprocID146    END147  END TRY148  BEGIN CATCH149    EXEC QBM_PSessionErrorAdd DEFAULT150    RAISERROR('',151    18,152    1)153      WITH NOWAIT154  END CATCH155  endLabel:156  RETURN157END
Open raw exported source
SQL ยท Raw29 lines
1create   trigger ATT_TUAttestationPolicy on AttestationPolicy  for UPDATE not for Replication as begin  declare @SQLToCheck QBM_YParameterList declare2 @QER_Attestation_OnWorkflowAssign varchar(16) BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto3 start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  if update(WhereClause) begin insert into @SQLToCheck4(Parameter1, ContentFull) select c.XObjectKey, 'select top 1 1 as columnvalue from ' + t.TableName + '5		 where (6		 ' + c.WhereClause + '7		 )' from8 inserted c  join AttestationObject o on c.UID_AttestationObject = o.UID_AttestationObject join DialogTable t on o.UID_DialogTable = t.UID_DialogTable 9where c.WhereClause > ' '  update @SQLToCheck set ContentFull = REPLACE (replace(ContentFull , '@UID_QERPickCategory', '''#''') , '@UID_AttestationPolicy'10, '''#''') exec QBM_PSQLCheckExecutable @SQLToCheck, @RaiseError = 1 end if dbo.QBM_FGIConfigparmValue('QER\Attestation') = '' begin goto endLabel end 11if update(UID_PWODecisionMethod) begin select @QER_Attestation_OnWorkflowAssign = dbo.QBM_FGIConfigparmValue('QER\Attestation\OnWorkflowAssign') if @QER_Attestation_OnWorkflowAssign12 in ('RESET', 'ABORT') begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01(Object, SubObject, GenProcID) select x.uid, null13, @GenProcID from ( select ac.UID_AttestationCase as uid from AttestationPolicy po join deleted d on po.UID_AttestationPolicy = d.UID_AttestationPolicy14 and isnull(po.UID_PWODecisionMethod, '') <> isnull(d.UID_PWODecisionMethod, '') and po.UID_PWODecisionMethod > ' ' join PWODecisionMethod m on d.UID_PWODecisionMethod15 = m.UID_PWODecisionMethod join QERWorkingMethod wm on wm.UID_PWODecisionSubMethod = m.UID_SubMethodOrderProduct join AttestationCase ac on ac.UID_QERWorkingMethod16 = wm.UID_QERWorkingMethod and ac.IsClosed = 0 ) as x if @QER_Attestation_OnWorkflowAssign = 'RESET' begin exec QBM_PDBQueueInsert_Bulk 'ATT-K-Attestation-RESET'17, @DBQueueElements_01 end if @QER_Attestation_OnWorkflowAssign = 'ABORT' begin exec QBM_PDBQueueInsert_Bulk'ATT-K-Attestation-ABORT', @DBQueueElements_0118 end end   declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02(Object, SubObject, GenProcID) select x.uid, null, @GenProcID from19 ( select ac.UID_AttestationCase as uid from AttestationPolicy po join deleted d on po.UID_AttestationPolicy = d.UID_AttestationPolicy and isnull(po.UID_PWODecisionMethod20, '') <> isnull(d.UID_PWODecisionMethod, '') and po.UID_PWODecisionMethod is null join PWODecisionMethod m on d.UID_PWODecisionMethod = m.UID_PWODecisionMethod21 join QERWorkingMethod wm on wm.UID_PWODecisionSubMethod = m.UID_SubMethodOrderProduct join AttestationCase ac on ac.UID_QERWorkingMethod = wm.UID_QERWorkingMethod22 and ac.IsClosed = 0 ) as x exec QBM_PDBQueueInsert_Bulk'ATT-K-Attestation-ABORT', @DBQueueElements_02 end  if update(IsInactive) begin declare @DBQueueElements_0323 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uid_AttestationPolicy as uid24 from inserted ) as x exec QBM_PDBQueueInsert_Bulk 'ATT-K-HelperAttestationPolicy', @DBQueueElements_03 end if UPDATE(UID_AERoleOwner) begin declare @RecalcParameter_0125 QBM_YCursorBuffer  insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select dbo.QBM_FCVElementToObjectKey1('AERole', '', i.UID_AERoleOwner), 26v.UID_PWODecisionRule, 'A' from inserted i cross join (values ('ATT-PWODecisionRule-PW') ) as v (UID_PWODecisionRule) exec QER_PITShopHelperFill_Recalc27 @RecalcParameter_01, @GenprocID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return28 end 29