USP_FAFEVENTREGISTRATIONWAIVER_COPY

CREATE procedure dbo.USP_FAFEVENTREGISTRATIONWAIVER_COPY
(
  @SOURCEID uniqueidentifier,
  @TARGETEVENTID uniqueidentifier, 
  @SOURCEXML xml = null, 
  @CHANGEAGENTID uniqueidentifier = null,
  @COPYBATCHGUID uniqueidentifier
)
as
    declare @CURRENTDATE datetime,
          @IsCopyEvent bit
  set @CURRENTDATE = getdate()

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

  select @IsCopyEvent = case when @SOURCEXML is null and @SOURCEID is not null then 1 else 0 end

begin try
  if @SOURCEXML is null
    set @SOURCEXML = dbo.UFN_FAFEVENT_GETREGISTRATIONWAIVER_TOITEMLISTXML(@SOURCEID)

  if @IsCopyEvent = 1
    set @SOURCEXML = CAST(REPLACE(CAST(@SOURCEXML AS NVARCHAR(MAX)), '<COPYBATCHGUID>'+CAST(@SOURCEID as nvarchar(40))+'</COPYBATCHGUID>', '<COPYBATCHGUID>'+CAST(@COPYBATCHGUID as nvarchar(40))+'</COPYBATCHGUID>') AS XML)

  exec dbo.USP_FAFEVENT_GETREGISTRATIONWAIVER_ADDFROMXML @EVENTID=@TARGETEVENTID, @XML=@SOURCEXML,@CHANGEAGENTID=@CHANGEAGENTID,@CHANGEDATE=@CURRENTDATE

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