USP_DATAFORMTEMPLATE_PRELOAD_ADD_DESIGNATIONLEVELRECIPIENT

The load procedure used by the edit dataform template "Fundraising Purpose Recipient Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DESIGNATIONLEVELID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@BASECURRENCYID	uniqueidentifier	INOUT	Currency

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_DESIGNATIONLEVELRECIPIENT
          (
            @DESIGNATIONLEVELID uniqueidentifier,
            @BASECURRENCYID uniqueidentifier = null output
          ) as begin
            set nocount on;

            select
              @BASECURRENCYID = DESIGNATIONLEVEL.BASECURRENCYID
            from
              dbo.DESIGNATIONLEVEL
            where
              DESIGNATIONLEVEL.ID = @DESIGNATIONLEVELID;

            return 0;
          end