Back to OIM Explorer

dbo.QER_PITShopOrderMove

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 574 characters

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_PSessionErrorAdd source text reference
  • references source dbo.QER_PITShopOrderMove_bulk source text reference

References

Referenced By

Complete Source

SQL33 lines
1CREATE PROCEDURE QER_PITShopOrderMove(2  @UID_PersonWantsOrg varchar(38),3  @UID_BOTarget varchar(38),4  @GenProcID varchar(38),5  @useCopyFlag BIT = 1,6  @IsRemovePersonFromShop BIT = 07)8AS9BEGIN10  DECLARE @Pwo QBM_YParameterList11  SET XACT_ABORT OFF12  BEGIN TRY13    INSERT INTO @Pwo(Parameter1,14    Parameter2,15    Parameter3,16    HasContentFull)17    SELECT18      @UID_PersonWantsOrg,19      @UID_BOTarget,20      @GenProcID,21      @IsRemovePersonFromShop22    EXEC QER_PITShopOrderMove_bulk @PWO23  END TRY24  BEGIN CATCH25    EXEC QBM_PSessionErrorAdd DEFAULT26    RAISERROR('',27    18,28    1)29      WITH NOWAIT30  END CATCH31  ende:32  RETURN33END
Open raw exported source
SQL ยท Raw5 lines
1       create   procedure QER_PITShopOrderMove (@UID_PersonWantsOrg varchar(38)  , @UID_BOTarget varchar(38)  , @GenProcID varchar(38) , @useCopyFlag2 bit = 1 , @IsRemovePersonFromShop bit = 0   ) as begin declare @Pwo QBM_YParameterList SET XACT_ABORT OFF BEGIN TRY insert into @Pwo(Parameter1, Parameter23, Parameter3, HasContentFull) select @UID_PersonWantsOrg, @UID_BOTarget, @GenProcID, @IsRemovePersonFromShop exec QER_PITShopOrderMove_bulk @PWO END TRY4 BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  ende: return end 5