USP_DATAFORMTEMPLATE_EDIT_ETLCONFIGURATION

          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ETLCONFIGURATION
          (
            @CHANGEAGENTID uniqueidentifier,
            @DATEOPTION bit,
            @REVENUESTARTDATE datetime,
            @REVENUETYPELIST xml
          )
          as
            set nocount on;

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

            begin try

              if @DATEOPTION = 0
                set @REVENUESTARTDATE = '1753-01-01';

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

              update dbo.[ETLCONFIGURATION]
              set 
                [REVENUESTARTDATE] = @REVENUESTARTDATE,
                [CHANGEDBYID] = @CHANGEAGENTID,
                [DATECHANGED] = @CURRENTDATE;

              declare @REVENUETYPEID uniqueidentifier;
              declare @SELECTED bit;

              declare REVENUETYPESCURSOR cursor local fast_forward for
              select [ID], [SELECTED]
              from dbo.[UFN_ETLCONFIGURATION_GETREVENUETYPES_FROMITEMLISTXML](@REVENUETYPELIST);

              open REVENUETYPESCURSOR;
              fetch next from REVENUETYPESCURSOR into @REVENUETYPEID, @SELECTED;

              while (@@FETCH_STATUS = 0)
              begin
                update dbo.[ETLCONFIGURATIONREVENUETYPES] 
                set [SELECTED] = @SELECTED
                where [ID] = @REVENUETYPEID;

                fetch next from REVENUETYPESCURSOR into @REVENUETYPEID, @SELECTED;
              end;

              close REVENUETYPESCURSOR;
              deallocate REVENUETYPESCURSOR;

            end try
            begin catch
              exec dbo.USP_RAISE_ERROR;
              return 1;
            end catch

            return 0;