Back to OIM Explorer

dbo.ATT_TUAccProduct

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on AccProduct. Trigger parent table: AccProduct

Source: sandbox-db sys.sql_modules

Source size: 1.686 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.

Relations

  • Trigger parent table: AccProduct

Typed Edges

  • trigger on table AccProduct Trigger parent table: AccProduct
  • references source dbo.QBM_FCVElementToObjectKey1 source text reference
  • references source dbo.QBM_FGISessionContext 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

Complete Source

SQL89 lines
1CREATE trigger ATT_TUAccProduct2  ON AccProduct FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    IF EXISTS(13      SELECT TOP 1 114      FROM deleted)15    GOTO start16    RETURN start:17    IF18    UPDATE(UID_OrgAttestator)19    BEGIN20      DECLARE @RecalcParameter_01 QBM_YCursorBuffer21      INSERT INTO @RecalcParameter_01(ObjectKey1,22      UID1,23      Ident1)24      SELECT25        dbo.QBM_FCVElementToObjectKey1('Person',26        '',27        pio.UID_Person),28        'ATT-PWODecisionRule-AN',29        'A'30      FROM inserted i31      JOIN PersonInBaseTree pio32        ON i.UID_OrgAttestator = pio.UID_Org33      UNION all34      SELECT35        dbo.QBM_FCVElementToObjectKey1('Person',36        '',37        pio.UID_Person),38        'ATT-PWODecisionRule-AN',39        'A'40      FROM deleted d41      JOIN PersonInBaseTree pio42        ON d.UID_OrgAttestator = pio.UID_Org43      EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_01,44        @GenprocID45    END46    IF47    UPDATE(UID_OrgRuler)48    BEGIN49      DECLARE @RecalcParameter_03 QBM_YCursorBuffer50      INSERT INTO @RecalcParameter_03(ObjectKey1,51      UID1,52      Ident1)53      SELECT54        i.XObjectKey,55        v.UID_PWODecisionRule,56        'A'57      FROM inserted i CROSS58      JOIN(59      VALUES('ARS-AttestationRule-KA'),60      ('ATT-PWODecisionRule-OA'),61      ('ATT-PWODecisionRule-EO')) AS v(UID_PWODecisionRule)62      EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_03,63        @GenprocID64    END65    IF66    UPDATE(UID_OrgAttestator)67    BEGIN68      DECLARE @RecalcParameter_02 QBM_YCursorBuffer69      INSERT INTO @RecalcParameter_02(ObjectKey1,70      UID1,71      Ident1)72      SELECT73        i.XObjectKey,74        'ATT-PWODecisionRule-OrgATT',75        'A'76      FROM inserted i77      EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_02,78        @GenprocID79    END80  END TRY81  BEGIN CATCH82    EXEC QBM_PSessionErrorAdd DEFAULT83    RAISERROR('',84    18,85    1)86      WITH NOWAIT87  END CATCH88  RETURN89END
Open raw exported source
SQL ยท Raw12 lines
1    create   trigger ATT_TUAccProduct on AccProduct  for UPDATE not for Replication as begin  declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext2('') BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start:  if update(UID_OrgAttestator3) begin declare @RecalcParameter_01 QBM_YCursorBuffer insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1)  select dbo.QBM_FCVElementToObjectKey14('Person', '', pio.UID_Person), 'ATT-PWODecisionRule-AN' ,'A' from inserted i join PersonInBaseTree pio on i.UID_OrgAttestator = pio.UID_Org union all 5select dbo.QBM_FCVElementToObjectKey1('Person', '', pio.UID_Person), 'ATT-PWODecisionRule-AN' , 'A' from deleted d join PersonInBaseTree pio on d.UID_OrgAttestator6 = pio.UID_Org exec QER_PITShopHelperFill_Recalc @RecalcParameter_01, @GenprocID end  if update(UID_OrgRuler) begin declare @RecalcParameter_03 QBM_YCursorBuffer7 insert into @RecalcParameter_03 (ObjectKey1, UID1, Ident1)  select i.XObjectKey , v.UID_PWODecisionRule, 'A' from inserted i cross join ( values ('ARS-AttestationRule-KA'8 ) , ('ATT-PWODecisionRule-OA') , ('ATT-PWODecisionRule-EO') ) as v (UID_PWODecisionRule) exec QER_PITShopHelperFill_Recalc @RecalcParameter_03, @GenprocID9 end  if update(UID_OrgAttestator) begin declare @RecalcParameter_02 QBM_YCursorBuffer insert into @RecalcParameter_02 (ObjectKey1, UID1, Ident1)  select10 i.XObjectKey, 'ATT-PWODecisionRule-OrgATT', 'A' from inserted i exec QER_PITShopHelperFill_Recalc @RecalcParameter_02, @GenprocID end   END TRY BEGIN 11CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  return end 12