USP_RECORDOPERATION_MARKSOURCECODEINACTIVE

Executes the "Source Code: Mark Inactive" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	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.

Definition

Copy



CREATE procedure dbo.USP_RECORDOPERATION_MARKSOURCECODEINACTIVE
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null
)
as
  set nocount on;

  declare @isactive bit;
  select @isactive=[ISACTIVE] from dbo.[MKTSOURCECODE] where [ID]=@ID;

  if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  update
    dbo.[MKTSOURCECODE]
  set
    ISACTIVE = (case @isactive when 0 then 1 else 0 end),
    CHANGEDBYID = @CHANGEAGENTID,
    DATECHANGED = getdate()
  where
    [MKTSOURCECODE].[ID] = @ID;

  return 0;