USP_REVENUEBATCH_MEMBERSHIPCOMMITMENT

create procedure dbo.USP_REVENUEBATCH_MEMBERSHIPCOMMITMENT
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @PROGRAMNAME nvarchar(100) = null output,
  @LEVELNAME nvarchar(100) = null output,
  @CONSTITUENTNAME nvarchar(255) = null output,
  @EXPIRATIONDATE date = null output,
  @TERMAMOUNT money = null output,
  @CURRENCYID uniqueidentifier = null output
)
as begin
  set nocount on;

  begin try

    select
      @DATALOADED = 1,
      @PROGRAMNAME = dbo.UFN_MEMBERSHIPPROGRAM_GETNAME(MEMBERSHIP.MEMBERSHIPPROGRAMID),
      @LEVELNAME = dbo.UFN_MEMBERSHIPLEVEL_GETNAME(MEMBERSHIP.MEMBERSHIPLEVELID),
      @CONSTITUENTNAME = CONSTITUENT_NF.NAME,
      @EXPIRATIONDATE = MEMBERSHIP.EXPIRATIONDATE,
      @TERMAMOUNT = MEMBERSHIPLEVELTERM.AMOUNT,
      @CURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY()
    from
      dbo.MEMBERSHIP
    inner join
      dbo.MEMBER on MEMBERSHIP.ID = MEMBER.MEMBERSHIPID
    inner join
      dbo.MEMBERSHIPLEVELTERM on MEMBERSHIP.MEMBERSHIPLEVELTERMID = MEMBERSHIPLEVELTERM.ID
    cross apply
      dbo.UFN_CONSTITUENT_DISPLAYNAME(MEMBER.CONSTITUENTID) CONSTITUENT_NF
    where
      dbo.MEMBERSHIP.ID = @ID;

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

  return 0;

end;