USP_RECORDOPERATION_APPUSER_APPUSERTHIRDPARTYAUTH_MARKACTIVE

create procedure dbo.USP_RECORDOPERATION_APPUSER_APPUSERTHIRDPARTYAUTH_MARKACTIVE
(
     @ID uniqueidentifier,
     @CHANGEAGENTID uniqueidentifier = null
)
as
begin
    set nocount on;

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

        update
            dbo.APPUSER
        set
            ISACTIVE = 1,
            CHANGEDBYID = @CHANGEAGENTID,
            INVALIDLOGINATTEMPTS = 0,
            DATECHANGED = getdate()
        where
            APPUSER.ID = @ID;

       update
            dbo.APPUSERTHIRDPARTYAUTH
        set
            INACTIVE = 0,
            INACTIVEDATE = null,
            INACTIVEDETAILS = '',
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()
        where
            APPUSERTHIRDPARTYAUTH.ID = @ID;

        exec dbo.USP_APPUSERINACTIVEDETAIL_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
end