USP_DATAFORMTEMPLATE_ADD_PRINTMEMBERSHIPCARDSPROCESS_PRELOAD

The load procedure used by the edit dataform template "Print Membership Cards Process Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTRECORDTYPEID	uniqueidentifier	INOUT
@MEMBERSHIPPROGRAMCARDFORMATS	xml	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PRINTMEMBERSHIPCARDSPROCESS_PRELOAD
                    (                        
                        @CONSTITUENTRECORDTYPEID uniqueidentifier = null output,
                        @MEMBERSHIPPROGRAMCARDFORMATS xml = null output
                    )
                    as
                        set nocount on;

                        select @CONSTITUENTRECORDTYPEID = ID from dbo.RECORDTYPE where upper([NAME]) = 'CONSTITUENT';
                        set @MEMBERSHIPPROGRAMCARDFORMATS = dbo.UFN_MEMBERSHIPPROGRAM_GETCARDFORMATS_TOITEMLISTXML();

                        return 0;