dbo.QER_PITShopOrderResetOneLevel

1   create   procedure QER_PITShopOrderResetOneLevel (@uid_PersonwantsOrg varchar(38) , @NewLevel int , @GenProcID varchar(38)  ) as begin  declare
2 @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('') declare @XUser_R nvarchar(64) = dbo.QBM_FGISessionContext('XUser') declare @WhereclauseForMail
3 nvarchar(1000) SET XACT_ABORT OFF BEGIN TRY if exists (select top 1 1 from PWOHelperPWO h join QERWorkingStep s on h.UID_QERWorkingStep = s.UID_QERWorkingStep
4 join PWODecisionRule r on r.UID_PWODecisionRule = s.UID_PWODecisionRule and r.UID_PWODecisionRule not in ('CPL-PWODecisionRule-OC' , 'CPL-PWODecisionRule-OH'
5 ) where h.UID_PersonWantsOrg = @uid_PersonwantsOrg and h.LevelNumber = @NewLevel and ( h.decision > ' ' or h.UID_PersonInsteadOf > ' ' or h.uid_PersonAdditional
6 > ' ' ) ) begin update PWOHelperPWO set Decision = '' , UID_PersonInsteadOf = null , UID_PersonAdditional = null from PWOHelperPWO h join QERWorkingStep
7 s on h.UID_QERWorkingStep = s.UID_QERWorkingStep join PWODecisionRule r on r.UID_PWODecisionRule = s.UID_PWODecisionRule and r.UID_PWODecisionRule not
8 in ('CPL-PWODecisionRule-OC' , 'CPL-PWODecisionRule-OH' ) where h.UID_PersonWantsOrg = @uid_personwantsorg and h.LevelNumber = @NewLevel and ( h.decision
9 > ' ' or h.UID_PersonInsteadOf > ' ' or h.uid_PersonAdditional > ' ' ) end if exists (select top 1 1 from PWOHelperPWO h where h.UID_PersonWantsOrg = 
10@uid_PersonwantsOrg and h.LevelNumber = @NewLevel and ( h.IsFromDelegation = 1 ) ) begin delete PWOHelperPWO from PWOHelperPWO h where h.IsFromDelegation
11 = 1 and h.UID_PersonWantsOrg = @uid_personwantsorg and h.LevelNumber = @NewLevel end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow
12 varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH  ende: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R
13 exec QBM_PSessionContextSet 'XUser', @XUser_R return end 
14