Back to OIM Explorer

dbo.ATT_PAttestationCaseCreate_i

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. HOCallMethod -> AttestationPolicy.CompleteCasesUnderConstruction at line 11; References QBM_PJobCreate*; References QBM_PJobCreate_HOCallMethod*

Source: sandbox-db sys.sql_modules

Source size: 2.233 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

  • HOCallMethod -> AttestationPolicy.CompleteCasesUnderConstruction at line 11
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOCallMethod*

Typed Edges

  • calls object method AttestationPolicy.CompleteCasesUnderConstruction HOCallMethod -> AttestationPolicy.CompleteCasesUnderConstruction at line 11
  • 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.ATT_PAttestationCaseCreate source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOCallMethod source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL90 lines
1CREATE PROCEDURE ATT_PAttestationCaseCreate_i(2  @Zwischenlager QBM_YParameterList READONLY,3  @UID_AttestationRun varchar(38),4  @UID_AttestationPolicy varchar(38),5  @UID_QERWorkingMethod varchar(38),6  @HexPattern varchar(200),7  @Xdate datetime,8  @XUser nvarchar(64),9  @ChunkWithData int OUTPUT10)11AS12BEGIN13  DECLARE @ZwischenlagerPortion QBM_YParameterList14  DECLARE @ParamUIDs nvarchar(max)15  DECLARE @HOWhereClause nvarchar(max) = CONCAT('UID_AttestationPolicy = ''',16  @UID_AttestationPolicy,17  '''')18  DECLARE @BasisObjectKey varchar(138) = dbo.QBM_FCVElementToObjectKey1('AttestationPolicy',19  'UID_AttestationPolicy',20  @UID_AttestationPolicy)21  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')22  SET XACT_ABORT OFF23  BEGIN TRY24    INSERT INTO @ZwischenlagerPortion(Parameter1,25    Parameter2,26    Parameter3)27    SELECT28      z.Parameter1,29      z.Parameter2,30      z.Parameter331    FROM @Zwischenlager z32    WHERE33      z.Parameter1 LIKE '<Key><T>AttestationCase</T><P>' + @HexPattern34    SELECT @ChunkWithData = SIGN(@@ROWCOUNT)35    IF @ChunkWithData > 036    BEGIN37      INSERT INTO AttestationCase(UID_AttestationCase,38      UID_AttestationPolicy,39      ObjectKeyBase,40      XDateInserted,41      XDateUpdated,42      XUserInserted,43      XUserUpdated,44      XObjectKey,45      UID_AttestationRun,46      UID_QERWorkingMethod,47      IsUnderConstruction)48      SELECT49        z.Parameter2 AS UID_AttestationCase,50        @UID_AttestationPolicy,51        z.Parameter3 AS ObjectKeyBase,52        @Xdate,53        @Xdate,54        @XUser,55        @XUser,56        z.Parameter1 AS XObjectKey,57        @UID_AttestationRun,58        @UID_QERWorkingMethod,59        1 AS IsUnderConstruction60      FROM @ZwischenlagerPortion z61      SELECT62        TOP 1 @ParamUIDs = STRING_AGG(convert(nvarchar(max), z.Parameter2),63        N ',')64      FROM @ZwischenlagerPortion z65      EXEC QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationPolicy',66        @WhereClause = @HOWhereClause,67        @save = 1,68        @MethodName = 'CompleteCasesUnderConstruction',69        @GenProcID = @GenProcID,70        @ObjectKeysAffected = DEFAULT,71        @Param1 = @ParamUIDs,72        @Param2 = @GenProcID,73        @Retries = 3,74        @checkForExisting = 1,75        @WhereClauseAdditional = '',76        @BasisObjectKey = @BasisObjectKey,77        @isToFreezeOnError = 178    END79  END TRY80  BEGIN CATCH81    EXEC QBM_PSessionErrorAdd DEFAULT82    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()83    RAISERROR(@Rethrow,84    18,85    1)86      WITH NOWAIT87  END CATCH88  endLabel:89  RETURN90END
Open raw exported source
SQL ยท Raw16 lines
1 create   procedure ATT_PAttestationCaseCreate_i (@Zwischenlager QBM_YParameterList readonly , @UID_AttestationRun varchar(38) , @UID_AttestationPolicy2 varchar(38) , @UID_QERWorkingMethod varchar(38) , @HexPattern varchar(200) , @Xdate datetime , @XUser nvarchar(64) , @ChunkWithData int output ) as begin3 declare @ZwischenlagerPortion QBM_YParameterList  declare @ParamUIDs nvarchar(max) declare @HOWhereClause nvarchar(max) = concat('UID_AttestationPolicy = '''4, @UID_AttestationPolicy , '''') declare @BasisObjectKey varchar(138) = dbo.QBM_FCVElementToObjectKey1('AttestationPolicy', 'UID_AttestationPolicy', @UID_AttestationPolicy5) declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext('') SET XACT_ABORT OFF BEGIN TRY insert into @ZwischenlagerPortion(Parameter1, Parameter2,6 Parameter3) select z.Parameter1, z.Parameter2, z.Parameter3 from @Zwischenlager z where z.Parameter1 like '<Key><T>AttestationCase</T><P>' + @HexPattern7 select @ChunkWithData = SIGN(@@ROWCOUNT) if @ChunkWithData > 0  begin insert into AttestationCase (UID_AttestationCase, UID_AttestationPolicy, ObjectKeyBase8 , XDateInserted, XDateUpdated, XUserInserted, XUserUpdated , XObjectKey, UID_AttestationRun, UID_QERWorkingMethod , IsUnderConstruction ) select z.Parameter29 as UID_AttestationCase, @UID_AttestationPolicy, z.Parameter3 as ObjectKeyBase , @Xdate, @Xdate, @XUser, @XUser , z.Parameter1 as XObjectKey, @UID_AttestationRun10, @UID_QERWorkingMethod , 1 as IsUnderConstruction from @ZwischenlagerPortion z    select top 1 @ParamUIDs = STRING_AGG( convert(nvarchar(max), z.Parameter211) , N',' ) from @ZwischenlagerPortion z exec QBM_PJobCreate_HOCallMethod @objecttype = 'AttestationPolicy' , @WhereClause = @HOWhereClause , @save = 1 12, @MethodName = 'CompleteCasesUnderConstruction' , @GenProcID = @GenProcID , @ObjectKeysAffected = default , @Param1 = @ParamUIDs  , @Param2 = @GenProcID13  , @Retries = 3 , @checkForExisting = 1 , @WhereClauseAdditional = ''  , @BasisObjectKey = @BasisObjectKey , @isToFreezeOnError = 1 end  END TRY BEGIN14 CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END 15CATCH endLabel: return end 16