USP_DATAFORMTEMPLATE_ADD_MEMBERSHIPPROGRAMCONFIGURATIONWIZARD_PRELOAD

Parameters

Parameter	Parameter Type	Mode
@BASECURRENCYID	uniqueidentifier	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN
@DISCOUNTSFORPROGRAM	xml	INOUT
@SITEREQUIRED	bit	INOUT
@SITEID	uniqueidentifier	INOUT
@DESIGNATIONRECORDTYPEID	uniqueidentifier	INOUT
@FINANCIALLINEITEMRECORDTYPEID	uniqueidentifier	INOUT
Definition

Copy

                  CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_MEMBERSHIPPROGRAMCONFIGURATIONWIZARD_PRELOAD
                  (
                        @BASECURRENCYID uniqueidentifier = null output,
                        @CURRENTAPPUSERID uniqueidentifier = null,
                        @DISCOUNTSFORPROGRAM xml = null output,
                        @SITEREQUIRED bit = null output,
                        @SITEID uniqueidentifier = null output,
                        @DESIGNATIONRECORDTYPEID uniqueidentifier = null output,
                        @FINANCIALLINEITEMRECORDTYPEID uniqueidentifier = null output
                  )
                  as
                      set nocount on;

                      set @BASECURRENCYID = dbo.UFN_APPUSER_GETBASECURRENCY(@CURRENTAPPUSERID);

                      set @DISCOUNTSFORPROGRAM = (
                        select
                          MEMBERSHIPPROMO.ID,
                          0 as APPLY,
                          MEMBERSHIPPROMO.NAME,
                          MEMBERSHIPPROMO.NAME as PROMONAME,
                          MEMBERSHIPPROMO.DISCOUNTCALCULATIONTYPECODE,
                          MEMBERSHIPPROMO.EXTENSIONCALCULATIONTYPECODE,
                          MEMBERSHIPPROMO.PROMOTIONTYPECODE,
                          MEMBERSHIPPROMO.AMOUNT,
                          MEMBERSHIPPROMO.[PERCENT],
                          MEMBERSHIPPROMO.EXTENSIONVALUE,
                          MEMBERSHIPPROMO.BASECURRENCYID,
                          MEMBERSHIPPROMO.FORMATTEDVALUE
                        from dbo.MEMBERSHIPPROMO
                        where
                          MEMBERSHIPPROMO.APPLICATIONTYPECODE = 0 and
                          MEMBERSHIPPROMO.ISACTIVE = 1
                        for xml raw('ITEM'),type,elements,root('DISCOUNTSFORPROGRAM'),BINARY BASE64);

                      set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);

                      set @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)                 

                      select
                        @DESIGNATIONRECORDTYPEID = ID
                      from dbo.RECORDTYPE
                      where upper(NAME) = 'DESIGNATION'

                      select
                        @FINANCIALLINEITEMRECORDTYPEID = ID
                      from dbo.RECORDTYPE
                      where upper(NAME) = 'FINANCIAL TRANSACTION LINE ITEM'

                      return 0;