Back to OIM Explorer

dbo.QER_PPickedItemInsert_b

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.260 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_FCVStringToGUID source text reference
  • references source dbo.QBM_FCVStringToGUIDMAll source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QER_PPickedItemInsert source text reference

References

Referenced By

Complete Source

SQL52 lines
1CREATE PROCEDURE QER_PPickedItemInsert_b(2  @UID_QERPickCategory varchar(38),3  @Items QBM_YParameterList READONLY4)5AS6BEGIN7  DECLARE @XUser nvarchar(64) = dbo.QBM_FGISessionContext('XUser')8  DECLARE @XDate datetime = getutcdate()9  SET XACT_ABORT OFF10  BEGIN TRY11    IF @XUser = ''12    BEGIN13      SELECT @XUser = OBJECT_NAME(@@PROCID)14    END15    merge INTO QERPickedItem AS t using(16    SELECT17      @UID_QERPickCategory AS UID_QERPickCategory,18      i.parameter1 AS ObjectKeyItem,19      dbo.QBM_FCVStringToGUIDMAll(NULL, @UID_QERPickCategory, i.parameter1) AS UID_QERPickedItem20    FROM @items i) AS s21      ON t.UID_QERPickedItem = s.UID_QERPickedItem WHEN matched THEN22    UPDATE23    SET xdateupdated = @XDate,24    XuserUpdated = @Xuser WHEN NOT matched BY target THEN25    INSERT(UID_QERPickedItem,26    UID_QERPickCategory,27    ObjectKeyItem,28    XDateInserted,29    XDateUpdated,30    XUserInserted,31    XUserUpdated,32    XObjectKey)33    VALUES(s.UID_QERPickedItem,34    s.UID_QERPickCategory,35    s.ObjectKeyItem,36    @XDate,37    @XDate,38    @XUser,39    @XUser,40    dbo.QBM_FCVElementToObjectKey1('QERPickedItem', 'UID_QERPickedItem', s.UID_QERPickedItem));41  END TRY42  BEGIN CATCH43    EXEC QBM_PSessionErrorAdd DEFAULT44    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()45    RAISERROR(@Rethrow,46    18,47    1)48      WITH NOWAIT49  END CATCH50  endLabel:51  RETURN52END
Open raw exported source
SQL ยท Raw10 lines
1   create   procedure QER_PPickedItemInsert_b (@UID_QERPickCategory varchar(38) , @Items QBM_YParameterList readonly  ) as begin declare @XUser 2nvarchar(64) = dbo.QBM_FGISessionContext('XUser') declare @XDate datetime = getutcdate() SET XACT_ABORT OFF BEGIN TRY if @XUser = '' begin select @XUser3 = OBJECT_NAME(@@PROCID) end merge into QERPickedItem as t using ( select @UID_QERPickCategory as UID_QERPickCategory , i.parameter1 as ObjectKeyItem ,4 dbo.QBM_FCVStringToGUIDMAll(null, @UID_QERPickCategory, i.parameter1) as UID_QERPickedItem from @items i ) as s on t.UID_QERPickedItem = s.UID_QERPickedItem5 when matched then update set xdateupdated = @XDate , XuserUpdated = @Xuser when not matched by target then insert ( UID_QERPickedItem , UID_QERPickCategory6 , ObjectKeyItem ,XDateInserted, XDateUpdated, XUserInserted, XUserUpdated , XObjectKey ) values ( s.UID_QERPickedItem , s.UID_QERPickCategory , s.ObjectKeyItem7 , @XDate, @XDate, @XUser, @XUser , dbo.QBM_FCVElementToObjectKey1('QERPickedItem', 'UID_QERPickedItem', s.UID_QERPickedItem) ) ; END TRY BEGIN CATCH exec8 QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH  endLabel:9 return end 10