Back to OIM Explorer

dbo.QER_PITShopOrderHistoryInsert

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.335 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_FCVElementToObjectKey1 source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PSessionContextSet source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL62 lines
1CREATE PROCEDURE QER_PITShopOrderHistoryInsert(2  @uid_PersonWantsorg varchar(38),3  @DecisionType nvarchar(16),4  @GenProcID varchar(38),5  @XUser nvarchar(64),6  @Description nvarchar(256)7)8AS9BEGIN10  DECLARE @UID_PWODecisionHistory varchar(38)11  DECLARE @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('')12  DECLARE @XUser_R nvarchar(64) = dbo.QBM_FGISessionContext('XUser')13  SET XACT_ABORT OFF14  BEGIN TRY15    SELECT @UID_PWODecisionHistory = newid()16    EXEC QBM_PSessionContextSet 'GenProcID',17      @GenProcID18    EXEC QBM_PSessionContextSet 'XUser',19      @XUser20    INSERT INTO pwodecisionHistory(UID_PWODecisionHistory,21    UID_PersonWantsOrg,22    DisplayPersonHead,23    ReasonHead,24    DateHead,25    XDateInserted,26    XDateUpdated,27    XUserInserted,28    XUserUpdated,29    DecisionType,30    IsDecisionBySystem,31    XObjectKey)32    SELECT33      @UID_PWODecisionHistory,34      @uid_PersonWantsorg,35      @Description,36      @Description,37      GetUTCDate(),38      GetUTCDate(),39      GetUTCDate(),40      @XUser,41      @XUser,42      @DecisionType,43      1,44      dbo.QBM_FCVElementToObjectKey1('pwodecisionHistory',45      'UID_PWODecisionHistory',46      @UID_PWODecisionHistory)47  END TRY48  BEGIN CATCH49    EXEC QBM_PSessionErrorAdd DEFAULT50    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()51    RAISERROR(@Rethrow,52    18,53    1)54      WITH NOWAIT55  END CATCH56  ende:57  EXEC QBM_PSessionContextSet 'GenProcID',58    @GenProcID_R59  EXEC QBM_PSessionContextSet 'XUser',60    @XUser_R61  RETURN62END
Open raw exported source
SQL ยท Raw10 lines
1   create   procedure QER_PITShopOrderHistoryInsert (@uid_PersonWantsorg varchar(38) , @DecisionType nvarchar(16) , @GenProcID varchar(38) , @XUser2 nvarchar(64) , @Description nvarchar(256) ) as begin declare @UID_PWODecisionHistory varchar(38)  declare @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext3('') declare @XUser_R nvarchar(64) = dbo.QBM_FGISessionContext('XUser') SET XACT_ABORT OFF BEGIN TRY select @UID_PWODecisionHistory = newid() exec QBM_PSessionContextSet4 'GenProcID', @GenProcID exec QBM_PSessionContextSet 'XUser', @XUser insert into pwodecisionHistory (UID_PWODecisionHistory, UID_PersonWantsOrg, DisplayPersonHead5, ReasonHead, DateHead ,XDateInserted, XDateUpdated, XUserInserted, XUserUpdated , DecisionType, IsDecisionBySystem, XObjectKey) select @UID_PWODecisionHistory6, @uid_PersonWantsorg, @Description, @Description , GetUTCDate(), GetUTCDate(), GetUTCDate(), @XUser, @XUser , @DecisionType, 1, dbo.QBM_FCVElementToObjectKey17('pwodecisionHistory', 'UID_PWODecisionHistory', @UID_PWODecisionHistory) END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar8(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH  ende: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R9 exec QBM_PSessionContextSet 'XUser', @XUser_R return end 10