Back to OIM Explorer

dbo.QER_TIHelperHeadOrg

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on HelperHeadOrg. Single DBQueue insert -> QER-K-ShoppingRackPWODecisionMaker / QER_ZITShopDecisionMakerFill at line 17; References QBM_PDBQueueInsert_Single; Trigger parent table: HelperHeadOrg

Source: sandbox-db sys.sql_modules

Source size: 2.871 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

  • Single DBQueue insert -> QER-K-ShoppingRackPWODecisionMaker / QER_ZITShopDecisionMakerFill at line 17
  • References QBM_PDBQueueInsert_Single
  • Trigger parent table: HelperHeadOrg

Typed Edges

  • queues DBQueue task QER_ZITShopDecisionMakerFill at line 17 Single DBQueue insert -> QER-K-ShoppingRackPWODecisionMaker / QER_ZITShopDecisionMakerFill at line 17
  • trigger on table HelperHeadOrg Trigger parent table: HelperHeadOrg
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Single 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

SQL139 lines
1CREATE trigger QER_TIHelperHeadOrg2  ON HelperHeadOrg FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @Parameter nvarchar(1000)7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    RETURN start:13    DECLARE @GenProcID varchar(38)14    SELECT @GenProcID = dbo.QBM_FGISessionContext('')15    DECLARE @RecalcParameter_01 QBM_YCursorBuffer16    INSERT INTO @RecalcParameter_01(UID1,17    ObjectKey1,18    Ident1)19    SELECT20      y.DecisionRule,21      x.XObjectKey,22      'I'23    FROM(24    SELECT e.XObjectKey25    FROM inserted i26    JOIN Basetree e27      ON i.UID_Org = e.UID_Org AND e.UID_OrgRoot = 'QER-V-Department') AS x28    JOIN(29    SELECT 'QER-PWODecisionRule-D0' AS DecisionRule30    UNION31    SELECT 'QER-PWODecisionRule-D1'32    UNION33    SELECT 'QER-PWODecisionRule-D2'34    UNION35    SELECT 'QER-PWODecisionRule-DM'36    UNION37    SELECT 'QER-PWODecisionRule-DP') AS y38      ON 1 = 139    EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_01,40      @GenprocID41    DECLARE @RecalcParameter_02 QBM_YCursorBuffer42    INSERT INTO @RecalcParameter_02(UID1,43    ObjectKey1,44    Ident1)45    SELECT46      y.DecisionRule,47      x.XObjectKey,48      'I'49    FROM(50    SELECT e.XObjectKey51    FROM inserted i52    JOIN Basetree e53      ON i.UID_Org = e.UID_Org AND e.UID_OrgRoot = 'QER-V-ITShopOrg') AS x54    JOIN(55    SELECT 'QER-PWODecisionRule-H0' AS DecisionRule56    UNION57    SELECT 'QER-PWODecisionRule-H1'58    UNION59    SELECT 'QER-PWODecisionRule-H2') AS y60      ON 1 = 161    EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_02,62      @GenprocID63    DECLARE @RecalcParameter_03 QBM_YCursorBuffer64    INSERT INTO @RecalcParameter_03(UID1,65    ObjectKey1,66    Ident1)67    SELECT68      y.DecisionRule,69      i.XObjectKey,70      'I'71    FROM inserted i72    JOIN(73    SELECT 'QER-PWODecisionRule-MS' AS DecisionRule) AS y74      ON 1 = 175    EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_03,76      @GenprocID77    DECLARE @RecalcParameter_04 QBM_YCursorBuffer78    INSERT INTO @RecalcParameter_04(UID1,79    ObjectKey1,80    Ident1)81    SELECT82      y.DecisionRule,83      x.XObjectKey,84      'I'85    FROM(86    SELECT e.XObjectKey87    FROM inserted i88    JOIN Basetree e89      ON i.UID_Org = e.UID_Org) AS x90    JOIN(91    SELECT 'QER-PWODecisionRule-OM' AS DecisionRule) AS y92      ON 1 = 193    EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_04,94      @GenprocID95    DECLARE @RecalcParameter_05 QBM_YCursorBuffer96    INSERT INTO @RecalcParameter_05(UID1,97    ObjectKey1,98    Ident1)99    SELECT100      y.DecisionRule,101      x.XObjectKey,102      'I'103    FROM(104    SELECT e.XObjectKey105    FROM inserted i106    JOIN Basetree e107      ON i.UID_Org = e.UID_Org AND e.UID_OrgRoot = 'QER-V-ProfitCenter') AS x108    JOIN(109    SELECT 'QER-PWODecisionRule-P0' AS DecisionRule110    UNION111    SELECT 'QER-PWODecisionRule-P1'112    UNION113    SELECT 'QER-PWODecisionRule-P2'114    UNION115    SELECT 'QER-PWODecisionRule-PM'116    UNION117    SELECT 'QER-PWODecisionRule-PP') AS y118      ON 1 = 1119    EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_05,120      @GenprocID121    EXEC QBM_PDBQueueInsert_Single 'QER-K-ShoppingRackPWODecisionMaker',122    '',123    '',124      @GenProcID125  END TRY126  BEGIN CATCH127    EXEC QBM_PSessionErrorAdd DEFAULT128    IF @@TRANCOUNT > 0129    BEGIN130      ROLLBACK TRANSACTION;131    END132    RAISERROR('',133    18,134    1)135      WITH NOWAIT136  END CATCH137  ende:138  RETURN139END
Open raw exported source
SQL ยท Raw20 lines
1    create   trigger QER_TIHelperHeadOrg on HelperHeadOrg  for Insert not for Replication as begin declare @Parameter nvarchar(1000)  BEGIN TRY 2if exists (select top 1 1 from inserted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') declare3 @RecalcParameter_01 QBM_YCursorBuffer insert into @RecalcParameter_01 (UID1, ObjectKey1, Ident1) select y.DecisionRule, x.XObjectKey, 'I' from (select4 e.XObjectKey from inserted i join Basetree e on i.UID_Org = e.UID_Org and e.UID_OrgRoot = 'QER-V-Department' ) as x join (select 'QER-PWODecisionRule-D0'5 as DecisionRule union select 'QER-PWODecisionRule-D1' union select 'QER-PWODecisionRule-D2' union select 'QER-PWODecisionRule-DM' union select 'QER-PWODecisionRule-DP'6 ) as y on 1 = 1 exec QER_PITShopHelperFill_Recalc @RecalcParameter_01, @GenprocID declare @RecalcParameter_02 QBM_YCursorBuffer insert into @RecalcParameter_027 (UID1, ObjectKey1, Ident1) select y.DecisionRule, x.XObjectKey, 'I' from (select e.XObjectKey from inserted i join Basetree e on i.UID_Org = e.UID_Org8 and e.UID_OrgRoot = 'QER-V-ITShopOrg' ) as x join (select 'QER-PWODecisionRule-H0' as DecisionRule union select 'QER-PWODecisionRule-H1' union select 9'QER-PWODecisionRule-H2' ) as y on 1 = 1 exec QER_PITShopHelperFill_Recalc @RecalcParameter_02, @GenprocID declare @RecalcParameter_03 QBM_YCursorBuffer10 insert into @RecalcParameter_03 (UID1, ObjectKey1, Ident1) select y.DecisionRule, i.XObjectKey, 'I' from inserted i join (select 'QER-PWODecisionRule-MS'11 as DecisionRule ) as y on 1 = 1 exec QER_PITShopHelperFill_Recalc @RecalcParameter_03, @GenprocID declare @RecalcParameter_04 QBM_YCursorBuffer insert12 into @RecalcParameter_04 (UID1, ObjectKey1, Ident1) select y.DecisionRule, x.XObjectKey, 'I' from (select e.XObjectKey from inserted i join Basetree e13 on i.UID_Org = e.UID_Org ) as x join (select 'QER-PWODecisionRule-OM' as DecisionRule ) as y on 1 = 1 exec QER_PITShopHelperFill_Recalc @RecalcParameter_0414, @GenprocID declare @RecalcParameter_05 QBM_YCursorBuffer insert into @RecalcParameter_05 (UID1, ObjectKey1, Ident1) select y.DecisionRule, x.XObjectKey15, 'I' from (select e.XObjectKey from inserted i join Basetree e on i.UID_Org = e.UID_Org and e.UID_OrgRoot = 'QER-V-ProfitCenter' ) as x join (select 'QER-PWODecisionRule-P0'16 as DecisionRule union select 'QER-PWODecisionRule-P1' union select 'QER-PWODecisionRule-P2' union select 'QER-PWODecisionRule-PM' union select 'QER-PWODecisionRule-PP'17 ) as y on 1 = 1 exec QER_PITShopHelperFill_Recalc @RecalcParameter_05, @GenprocID     exec QBM_PDBQueueInsert_Single 'QER-K-ShoppingRackPWODecisionMaker'18, '', '', @GenProcID END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default if @@TRANCOUNT > 0 BEGIN ROLLBACK TRANSACTION; END RAISERROR ('', 18, 1) WITH19 NOWAIT END CATCH ende: return end 20