Back to OIM Explorer

dbo.ATT_TUDialogParameter

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DialogParameter. Trigger parent table: DialogParameter

Source: sandbox-db sys.sql_modules

Source size: 1.100 characters

Interpretation

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

Relations

  • Trigger parent table: DialogParameter

Typed Edges

  • trigger on table DialogParameter Trigger parent table: DialogParameter
  • 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

  • No direct source references extracted.

Complete Source

SQL57 lines
1CREATE trigger ATT_TUDialogParameter2  ON DialogParameter FOR3UPDATE NOT FOR replication4AS5BEGIN6  DECLARE @GenProcID varchar(38)7  IF EXISTS(8    SELECT TOP 1 19    FROM inserted)10  GOTO start11  IF EXISTS(12    SELECT TOP 1 113    FROM deleted)14  GOTO start15  GOTO endLabel start:16  BEGIN TRY17    SELECT @GenProcID = dbo.QBM_FGISessionContext('')18    IF19    UPDATE(ParameterValue)20    BEGIN21      DECLARE @RecalcParameter_01 QBM_YCursorBuffer22      INSERT INTO @RecalcParameter_01(ObjectKey1,23      UID1,24      Ident1)25      SELECT26        dbo.QBM_FCVElementToObjectKey1('Person',27        '',28        i.ParameterValue) AS ObjectKey,29        'ATT-DB3656229AB30E439BAB4F6B23873A0E' AS UID_PWODecisionRule,30        'A'31      FROM inserted i32      WHERE33        i.ParameterName = 'UID_PROPOSED_OWNER'34      UNION all35      SELECT36        dbo.QBM_FCVElementToObjectKey1('Person',37        '',38        i.ParameterValue) AS ObjectKey,39        'ATT-DB3656229AB30E439BAB4F6B23873A0E' AS UID_PWODecisionRule,40        'A'41      FROM deleted i42      WHERE43        i.ParameterName = 'UID_PROPOSED_OWNER'44      EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_01,45        @GenprocID46    END47  END TRY48  BEGIN CATCH49    EXEC QBM_PSessionErrorAdd DEFAULT50    RAISERROR('',51    18,52    1)53      WITH NOWAIT54  END CATCH55  endLabel:56  RETURN57END
Open raw exported source
SQL ยท Raw9 lines
1 create   trigger ATT_TUDialogParameter on DialogParameter  for update not for replication as begin  declare @GenProcID varchar(38)   if exists 2(select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start goto endLabel start: BEGIN TRY select @GenProcID = dbo.QBM_FGISessionContext3('') if UPDATE(ParameterValue) begin    declare @RecalcParameter_01 QBM_YCursorBuffer insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select4 dbo.QBM_FCVElementToObjectKey1('Person', '', i.ParameterValue) as ObjectKey , 'ATT-DB3656229AB30E439BAB4F6B23873A0E' as UID_PWODecisionRule, 'A' from 5inserted i where i.ParameterName = 'UID_PROPOSED_OWNER' union all select dbo.QBM_FCVElementToObjectKey1('Person', '', i.ParameterValue) as ObjectKey , 6'ATT-DB3656229AB30E439BAB4F6B23873A0E' as UID_PWODecisionRule, 'A' from deleted i where i.ParameterName = 'UID_PROPOSED_OWNER' exec QER_PITShopHelperFill_Recalc7 @RecalcParameter_01, @GenprocID  end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return8 end 9