USP_SKYAPI_ENABLEDISABLE

      CREATE procedure dbo.USP_SKYAPI_ENABLEDISABLE
      (
        @ID nvarchar(100),
        @CHANGEAGENTID uniqueidentifier
      )
        as
        begin
          set nocount on;

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

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

        if not exists (
          select 1
          from dbo.CONDITIONSETTING
          where CONDITIONSETTING.NAME = 'SkyApi'
          )
            exec dbo.USP_CONDITIONSETTING_SETCONDITION 'SkyApi', @CHANGEAGENTID, @CURRENTDATE;
        else
        begin
          exec dbo.USP_CONDITIONSETTING_DELETEBYNAME_WITHCHANGEAGENTID 'SkyApi', @CHANGEAGENTID;

          /* cache current context information */
          declare @CONTEXTCACHE varbinary(128);
          set @CONTEXTCACHE = CONTEXT_INFO();

          /* set CONTEXT_INFO to @CHANGEAGENTID */
          if not @CHANGEAGENTID is null
            set CONTEXT_INFO @CHANGEAGENTID;

          /* clear all mappings from APPUSERCLAIMSLINK */
          delete from APPUSERCLAIMSLINK;

          /* reset CONTEXT_INFO to previous value */
          if not @CONTEXTCACHE is null
            set CONTEXT_INFO @CONTEXTCACHE;

          end
        end