USP_DATAFORMTEMPLATE_PRELOAD_ADD_MEMBERSHIPPROGRAM

The load procedure used by the edit dataform template "Membership Program Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@SITEID	uniqueidentifier	INOUT	Site
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEREQUIRED	bit	INOUT
@BASECURRENCYID	uniqueidentifier	INOUT	Currency

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_MEMBERSHIPPROGRAM 
          (
            @SITEID uniqueidentifier = null output,
            @CURRENTAPPUSERID uniqueidentifier,
            @SITEREQUIRED bit = null output,
            @BASECURRENCYID uniqueidentifier = null output
          ) as
            set nocount on;

            set @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID);
            set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);
                        select @BASECURRENCYID = 
                            (select CURRENCYSET.BASECURRENCYID from dbo.CURRENCYSET where ID = dbo.UFN_CURRENCYSET_GETAPPUSERCURRENCYSET(@CURRENTAPPUSERID))