USP_REGISTERCMSAUTOLOG_TOKEN

Executes the "Register CMS autolog token" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



create procedure dbo.USP_REGISTERCMSAUTOLOG_TOKEN
(
    @ID uniqueidentifier output,
    @CHANGEAGENTID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
as begin

  declare @UserId int

  if @ID is null    
      set @ID = newid(); 

  select @UserId=cu.ID 
  from dbo.BBNCUSERMAP map
  join dbo.ClientUsers cu on cu.UserName=map.BBNCUSERNAME
  where map.ID=@CURRENTAPPUSERID

  exec dbo.USP_REGISTER_CMS_AUTOLOG_TOKEN @ID, @UserId

    return 0;

end