dbo.QER_P04F128DC257D2B3C236MAIL_

1 create   procedure QER_P04F128DC257D2B3C236MAIL_( @GenProcIDToUse varchar(38) , @PWOHelperPWO_New QER_YPWOHelper readonly , @PWOToCheck QER_YPWOBufferForHelper
2 readonly , @DecisionLevelToUse int , @UID_PWO varchar(38) ) with execute as 'dbo' as begin declare @ObjectKeysToFire QBM_YParameterList declare @WhereclauseForMail
3 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_PWOHelperPWO
5 and h.decision = '' join @PWOToCheck pwo on h.uid_personwantsorg = pwo.uid_personwantsorg and h.levelnumber = pwo.decisionlevel and pwo.GenProcid = @GenProcIDToUse
6 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_PWODecisionRule
8 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 and
9 pwo.UID_PersonWantsOrg = @UID_PWO union  select h.XObjectKey from PWOHelperPWO h with (readpast) join @PWOToCheck pwo on h.uid_personwantsorg = pwo.uid_personwantsorg
10 and h.levelnumber = pwo.decisionlevel and pwo.GenProcid = @GenProcIDToUse and pwo.decisionlevel = @DecisionLevelToUse and h.levelnumber = pwo.decisionlevel
11 and h.decision = '' join QERWorkingStep s on h.UID_QERWorkingStep = s.UID_QERWorkingStep and (  s.UID_DialogRichMailInsert > ' ' or dbo.QBM_FGIConfigparmValue
12('QER\Person\Starling\UseApprovalAnywhere') > ' ' ) join pwodecisionrule r on s.UID_PWODecisionRule = r.UID_PWODecisionRule and r.UID_Task is null join
13 person p on h.uid_personhead = p.uid_person and p.defaultemailaddress > ' ' where pwo.isNewDecisionLevel = 1  and h.RulerLevel < 2 and pwo.UID_PersonWantsOrg
14 = @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