USP_REGISTRANT_UPDATESTATUS

Executes the "Registrant Status Update" 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_REGISTRANT_UPDATESTATUS
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null
)
as
set nocount on;

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

update
    dbo.REGISTRANT
set
    ISCANCELLED = ~ISCANCELLED,
    CHANGEDBYID = @CHANGEAGENTID,
    DATECHANGED = getdate()
where
    REGISTRANT.ID = @ID;

return 0;