USP_CREDITCARD_CLEARTOKEN

create procedure dbo.USP_CREDITCARD_CLEARTOKEN
(
    @CREDITCARDTOKEN uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null
)
as
begin
    if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    update dbo.CREDITCARD
    set 
        CREDITCARD.CREDITCARDTOKEN = null,
        CREDITCARD.CHANGEDBYID = @CHANGEAGENTID,
        CREDITCARD.DATECHANGED = @CURRENTDATE
    where 
        CREDITCARD.CREDITCARDTOKEN = @CREDITCARDTOKEN;

    return 0;
end