USP_DATAFORMTEMPLATE_PRELOAD_ADD_RECURRINGGIFTSTATUSUPDATEPROCESS

          CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_RECURRINGGIFTSTATUSUPDATEPROCESS
          (
              @REVENUERECORDTYPEID uniqueidentifier = null output,
              @PAYMENTMETHODVALUE xml = null output,
              @FREQUENCYVALUE xml = null output
          )
          as 
          begin
              set nocount on;

              select @REVENUERECORDTYPEID = ID
              from dbo.RECORDTYPE 
              where upper(NAME) = 'REVENUE';

              set @PAYMENTMETHODVALUE =
                  (   select PAYMENTMETHODCODE
                      from (values (0), (1), (2), (98), (3), (11), (10), (9), (101), (102)) as X(PAYMENTMETHODCODE)
                      for xml raw('ITEM'),type,elements,root('PAYMENTMETHODVALUE'),BINARY BASE64
                  );

              set @FREQUENCYVALUE =
                  (   select FREQUENCYCODE
                      from (values (0), (1), (2), (3), (6), (7), (8), (9), (10)) as X(FREQUENCYCODE)
                      for xml raw('ITEM'),type,elements,root('FREQUENCYVALUE'),BINARY BASE64
                  );

              return 0;
          end