dbo.QER_PITShopHelperFill
Stored ProcedureSQL_STORED_PROCEDURESandbox DB
Interpretation
- Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
Relations
- No extracted relations.
Typed Edges
- references source dbo.QBM_FCVIntToString source text reference
- references source dbo.QBM_PSessionErrorAdd source text reference
- references source dbo.QER_PITShopHelperFill_bulk source text reference
References
Referenced By
- dbo.ATT_ZAllForPersonInBaseTree
- dbo.CPL_ZAllForPersonInBaseTree
- dbo.QER_PITShopHelperFill_bulk
- dbo.QER_PITShopHelperFill_Recalc
- dbo.QER_PITShopHelperFillAll
- dbo.QER_PITShopOrderMove_bulk
- dbo.QER_ZAllForPersonInBaseTree
- dbo.QER_ZITShopHelperFill
- dbo.QER_ZITShopHelperFill_Cfg
- dbo.QER_ZITShopOrderReset
- dbo.ADS_TATTUADSAccount
- dbo.ADS_TATTUADSContainer
- dbo.ADS_TATTUADSGroup
- dbo.ADS_TATTUDomain
- dbo.ADS_TCPLUADSContainer
- dbo.ADS_TCPLUDomain
- dbo.ADS_TUADSContainer
- dbo.ADS_TUAdsGroup
- dbo.ADS_TUDomain
- dbo.ARS_TATTUADSAccount
- dbo.ARS_TATTUAdsGroup
- dbo.ARS_TUAccProduct
- dbo.ARS_TUADSAccount
- dbo.ARS_TUAdsGroup
- dbo.ATT_TDAttestationPolicyHasAppr
- dbo.ATT_TIAttestationPolicyHasAppr
- dbo.ATT_TIHelperHeadOrg
- dbo.ATT_TIHelperHeadPerson
- dbo.ATT_TRMBDHelperHeadOrg
- dbo.ATT_TRMBIHelperHeadOrg
- dbo.ATT_TUAccProduct
- dbo.ATT_TUAccProductGroup
- dbo.ATT_TUAttestationPolicy
- dbo.ATT_TUDialogParameter
- dbo.ATT_TUHardware
- dbo.ATT_TUHelperHeadOrg
- dbo.ATT_TUHelperHeadPerson
- dbo.ATT_TUPerson
- dbo.ATT_TUQERAssign
- dbo.ATT_TUQERResource
- dbo.ATT_TUQERReuse
- dbo.ATT_TUQERReuseUS
- dbo.ATT_TURMBPerson
- dbo.CPL_TUPerson
- dbo.LDP_TATTULDAPAccount
- dbo.LDP_TATTULDAPContainer
- dbo.LDP_TATTULDAPGroup
- dbo.LDP_TATTULDPDomain
- dbo.LDP_TCPLULDAPContainer
- dbo.LDP_TCPLULDPDomain
- dbo.LDP_TULDAPContainer
- dbo.LDP_TULDAPGroup
- dbo.LDP_TULDPDomain
- dbo.QER_TDBaseTree
- dbo.QER_TIHelperHeadOrg
- dbo.QER_TIHelperHeadPerson
- dbo.QER_TUAccProduct
- dbo.QER_TUBaseTree
- dbo.QER_TUHelperHeadOrg
- dbo.QER_TUHelperHeadPerson
Complete Source
1CREATE PROCEDURE QER_PITShopHelperFill(2 @uid_Personwantsorg varchar(38),3 @GenProcID varchar(38),4 @isNewDecisionLevel BIT = 0,5 @CurrentLevelOnly int = 06)7 WITH8EXECUTE9AS10'dbo' AS11BEGIN12 DECLARE @PWOs QBM_YParameterlist13 SET XACT_ABORT OFF14 BEGIN TRY15 INSERT INTO @PWOs(Parameter1,16 Parameter2,17 Parameter3,18 HasContentFull)19 SELECT20 @uid_Personwantsorg,21 @GenProcID,22 dbo.QBM_FCVIntToString(@CurrentLevelOnly),23 @isNewDecisionLevel24 EXEC QER_PITShopHelperFill_bulk @PWOs25 END TRY26 BEGIN CATCH27 EXEC QBM_PSessionErrorAdd DEFAULT28 RAISERROR('',29 18,30 1)31 WITH NOWAIT32 END CATCH33 ende: revert34 RETURN35ENDOpen raw exported source
1 create procedure QER_PITShopHelperFill (@uid_Personwantsorg varchar(38) , @GenProcID varchar(38) , @isNewDecisionLevel bit = 0 , @CurrentLevelOnly2 int = 0 ) with execute as 'dbo' as begin declare @PWOs QBM_YParameterlist SET XACT_ABORT OFF BEGIN TRY insert into @PWOs (Parameter1, Parameter2,3 Parameter3, HasContentFull) select @uid_Personwantsorg, @GenProcID, dbo.QBM_FCVIntToString(@CurrentLevelOnly), @isNewDecisionLevel exec QER_PITShopHelperFill_bulk4 @PWOs END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: revert return end 5