USP_REVENUEBATCH_EVENTCOMMITMENT

create procedure dbo.USP_REVENUEBATCH_EVENTCOMMITMENT
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @EVENTNAME nvarchar(100) = null output,
  @CONSTITUENTNAME nvarchar(255) = null output,
  @EVENTSTARTDATE date = null output,
  @REGISTRANTBALANCE money = null output,
  @EVENTCURRENCYID uniqueidentifier = null output
)
as begin
  set nocount on;

  begin try

    select
      @DATALOADED = 1,
      @EVENTNAME = EVENT.NAME,
      @CONSTITUENTNAME = CONSTITUENT_NF.NAME,
      @EVENTSTARTDATE = EVENT.STARTDATE,
      @REGISTRANTBALANCE = dbo.UFN_EVENTREGISTRANT_GETBALANCE(REGISTRANT.ID),
      @EVENTCURRENCYID = EVENT.BASECURRENCYID
    from
      dbo.REGISTRANT
    inner join
      dbo.EVENT on EVENT.ID = REGISTRANT.EVENTID
    cross apply
      dbo.UFN_CONSTITUENT_DISPLAYNAME(REGISTRANT.CONSTITUENTID) CONSTITUENT_NF
    where
      dbo.REGISTRANT.ID = @ID;

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

  return 0;

end;