Back to OIM Explorer

dbo.QER_P04F128DC257D2B3C236MAIL_

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. HOFireEvent -> PWOHelperPWO.DecisionRequired at line 21; References QBM_PJobCreate*; References QBM_PJobCreate_HOFireEvent*

Source: sandbox-db sys.sql_modules

Source size: 2.714 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

  • HOFireEvent -> PWOHelperPWO.DecisionRequired at line 21
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOFireEvent*

Typed Edges

  • fires event PWOHelperPWO.DecisionRequired HOFireEvent -> PWOHelperPWO.DecisionRequired at line 21
  • references source dbo.QBM_FGIConfigparmValue source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOFireEvent source text reference
  • references source dbo.QBM_PJobCreate_HOFireEvent_L source text reference
  • references source dbo.QBM_PSessionContextSet source text reference

References

Referenced By

Complete Source

SQL75 lines
1CREATE PROCEDURE QER_P04F128DC257D2B3C236MAIL_(2  @GenProcIDToUse varchar(38),3  @PWOHelperPWO_New QER_YPWOHelper READONLY,4  @PWOToCheck QER_YPWOBufferForHelper READONLY,5  @DecisionLevelToUse int,6  @UID_PWO varchar(38)7)8  WITH9EXECUTE10AS11'dbo' AS12BEGIN13  DECLARE @ObjectKeysToFire QBM_YParameterList14  DECLARE @WhereclauseForMail nvarchar(max)15  DECLARE @StartTemplateAt datetime = DATEADD(ss,16  15,17  getutcdate())18  EXEC QBM_PSessionContextSet 'GenProcID',19    @GenProcIDToUse20  INSERT INTO @ObjectKeysToFire(Parameter1)21  SELECT h.XObjectKey22  FROM @PWOHelperPWO_New n23  JOIN PWOHelperPWO h24    WITH(readpast)25    ON n.UID_PrimaryKey = h.uid_PWOHelperPWO AND h.decision = ''26  JOIN @PWOToCheck pwo27    ON h.uid_personwantsorg = pwo.uid_personwantsorg AND h.levelnumber = pwo.decisionlevel AND pwo.GenProcid = @GenProcIDToUse AND pwo.decisionlevel28  = @DecisionLevelToUse29  JOIN QERWorkingStep s30    ON h.UID_QERWorkingStep = s.UID_QERWorkingStep AND(s.UID_DialogRichMailInsert > ' ' OR dbo.QBM_FGIConfigparmValue('QER\Person\Starling\UseApprovalAnywhere'31  ) > ' ')32  JOIN pwodecisionrule r33    ON s.UID_PWODecisionRule = r.UID_PWODecisionRule AND r.UID_Task IS NULL34  JOIN person p35    ON h.uid_personhead = p.uid_person AND p.defaultemailaddress > ' '36  WHERE37    n.istoinsert = 1 AND h.RulerLevel < 2 AND pwo.UID_PersonWantsOrg = @UID_PWO38  UNION39  SELECT h.XObjectKey40  FROM PWOHelperPWO h41    WITH(readpast)42  JOIN @PWOToCheck pwo43    ON h.uid_personwantsorg = pwo.uid_personwantsorg AND h.levelnumber = pwo.decisionlevel AND pwo.GenProcid = @GenProcIDToUse AND pwo.decisionlevel44  = @DecisionLevelToUse AND h.levelnumber = pwo.decisionlevel AND h.decision = ''45  JOIN QERWorkingStep s46    ON h.UID_QERWorkingStep = s.UID_QERWorkingStep AND(s.UID_DialogRichMailInsert > ' ' OR dbo.QBM_FGIConfigparmValue('QER\Person\Starling\UseApprovalAnywhere'47  ) > ' ')48  JOIN pwodecisionrule r49    ON s.UID_PWODecisionRule = r.UID_PWODecisionRule AND r.UID_Task IS NULL50  JOIN person p51    ON h.uid_personhead = p.uid_person AND p.defaultemailaddress > ' '52  WHERE53    pwo.isNewDecisionLevel = 1 AND h.RulerLevel < 2 AND pwo.UID_PersonWantsOrg = @UID_PWO54  SELECT55    @WhereclauseForMail = CONCAT('exists(select top 1 1 56													from personwantsorg pwo 57													where pwo.uid_personwantsorg  = '''58    ,59    @UID_PWO,60    ''' 61													and pwo.decisionlevel = ',62    str(@DecisionLevelToUse),63    ' 64													and pwo.OrderState in (''OrderProduct'', ''OrderProlongate'', ''OrderUnsubscribe'')65												)')66  EXEC QBM_PJobCreate_HOFireEvent_L 'PWOHelperPWO',67    @ObjectKeysToFire,68  'DecisionRequired',69    @GenProcIDToUse,70    @priority = 10,71    @CheckForExisting = 1,72    @StartAt = @StartTemplateAt,73    @whereclauseAdditional = @WhereclauseForMail,74    @AdditionalObjectKeysAffected = DEFAULT75END
Open raw exported source
SQL ยท Raw23 lines
1 create   procedure QER_P04F128DC257D2B3C236MAIL_( @GenProcIDToUse varchar(38) , @PWOHelperPWO_New QER_YPWOHelper readonly , @PWOToCheck QER_YPWOBufferForHelper2 readonly , @DecisionLevelToUse int , @UID_PWO varchar(38) ) with execute as 'dbo' as begin declare @ObjectKeysToFire QBM_YParameterList declare @WhereclauseForMail3 nvarchar(max) declare @StartTemplateAt datetime = DATEADD(ss, 15, getutcdate()) exec QBM_PSessionContextSet 'GenProcID', @GenProcIDToUse  insert into 4@ObjectKeysToFire (Parameter1) select h.XObjectKey from @PWOHelperPWO_New n join PWOHelperPWO h with (readpast) on n.UID_PrimaryKey = h.uid_PWOHelperPWO5 and h.decision = '' join @PWOToCheck pwo on h.uid_personwantsorg = pwo.uid_personwantsorg and h.levelnumber = pwo.decisionlevel and pwo.GenProcid = @GenProcIDToUse6 and pwo.decisionlevel = @DecisionLevelToUse join QERWorkingStep s on h.UID_QERWorkingStep = s.UID_QERWorkingStep and (  s.UID_DialogRichMailInsert > ' '7 or dbo.QBM_FGIConfigparmValue('QER\Person\Starling\UseApprovalAnywhere') > ' ' ) join pwodecisionrule r on s.UID_PWODecisionRule = r.UID_PWODecisionRule8 and r.UID_Task is null join person p on h.uid_personhead = p.uid_person and p.defaultemailaddress > ' ' where n.istoinsert = 1  and h.RulerLevel < 2 and9 pwo.UID_PersonWantsOrg = @UID_PWO union  select h.XObjectKey from PWOHelperPWO h with (readpast) join @PWOToCheck pwo on h.uid_personwantsorg = pwo.uid_personwantsorg10 and h.levelnumber = pwo.decisionlevel and pwo.GenProcid = @GenProcIDToUse and pwo.decisionlevel = @DecisionLevelToUse and h.levelnumber = pwo.decisionlevel11 and h.decision = '' join QERWorkingStep s on h.UID_QERWorkingStep = s.UID_QERWorkingStep and (  s.UID_DialogRichMailInsert > ' ' or dbo.QBM_FGIConfigparmValue12('QER\Person\Starling\UseApprovalAnywhere') > ' ' ) join pwodecisionrule r on s.UID_PWODecisionRule = r.UID_PWODecisionRule and r.UID_Task is null join13 person p on h.uid_personhead = p.uid_person and p.defaultemailaddress > ' ' where pwo.isNewDecisionLevel = 1  and h.RulerLevel < 2 and pwo.UID_PersonWantsOrg14 = @UID_PWO  select @WhereclauseForMail = concat('exists(select top 1 1 15													from personwantsorg pwo 16													where pwo.uid_personwantsorg  = '''17 , @UID_PWO , ''' 18													and pwo.decisionlevel = ' , str(@DecisionLevelToUse) , ' 19													and pwo.OrderState in (''OrderProduct'', ''OrderProlongate'', ''OrderUnsubscribe'')20												)'21 ) exec QBM_PJobCreate_HOFireEvent_L 'PWOHelperPWO', @ObjectKeysToFire, 'DecisionRequired', @GenProcIDToUse , @priority = 10  , @CheckForExisting = 1  22, @StartAt = @StartTemplateAt , @whereclauseAdditional = @WhereclauseForMail , @AdditionalObjectKeysAffected = DEFAULT end 23