USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPFORMCMSSETTINGS_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHILDDISPLAYHTML	nvarchar(max)	IN
@PROJECTDISPLAYHTML	nvarchar(max)	IN
@ATTRIBUTEITEMSLIST	xml	IN
@DESIGNATIONLIST	xml	IN
@DEFAULTDESIGNATIONID	uniqueidentifier	IN
@DEFAULTDESIGNATION	int	IN
@APPEALSLIST	xml	IN
@REQUIREAPPEAL	bit	IN
@SOLESPONSORSHIPENABLED	bit	IN
@GIFTSPONSORSHIPENABLED	bit	IN
@ECARDSENABLED	bit	IN
@ADDITIONALGIFTENABLED	bit	IN
@MULTIPLEGIFTSENABLED	bit	IN
@MINIMUMGIFTAMOUNT	decimal(20, 4)	IN
@CONSTITUENCYID	uniqueidentifier	IN
@GENERALRECURRENCEENABLED	bit	IN
@SCHEDULEDENDDATEENABLED	bit	IN
@RECURRENCEDATAIDLIST	xml	IN
@ITEMEXPIRATION	int	IN
@PAYMENTPARTPAGE	int	IN
@DIRECTDEBITENABLED	bit	IN
@CHECKENABLED	bit	IN
@FORMITEMEXPIRATION	int	IN
@ACKNOWLEDGEMENTHTML	nvarchar(max)	IN
@FORCESTARTDATE	bit	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	IN

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPFORMCMSSETTINGS_3
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CHILDDISPLAYHTML nvarchar(max),
    @PROJECTDISPLAYHTML nvarchar(max),
    @ATTRIBUTEITEMSLIST xml,
    @DESIGNATIONLIST xml,
    @DEFAULTDESIGNATIONID uniqueidentifier,
    @DEFAULTDESIGNATION int,
    @APPEALSLIST xml,
    @REQUIREAPPEAL bit,
    @SOLESPONSORSHIPENABLED bit,
    @GIFTSPONSORSHIPENABLED bit,
    @ECARDSENABLED bit,
    @ADDITIONALGIFTENABLED bit,
    @MULTIPLEGIFTSENABLED bit,
    @MINIMUMGIFTAMOUNT decimal(20,4),
    @CONSTITUENCYID uniqueidentifier,
    @GENERALRECURRENCEENABLED bit,
    @SCHEDULEDENDDATEENABLED bit,
    @RECURRENCEDATAIDLIST xml,
    @ITEMEXPIRATION int,
    @PAYMENTPARTPAGE int,
    @DIRECTDEBITENABLED bit,
    @CHECKENABLED bit,
    @FORMITEMEXPIRATION int,
    @ACKNOWLEDGEMENTHTML nvarchar(max),
    @FORCESTARTDATE bit,
    @PDACCOUNTSYSTEMID uniqueidentifier
)

as
  set nocount on;

    declare @SUPPORTSCHECKOUTONLY bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPFORMCMSSETTINGS
        @ID = @ID,
        @PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID output,
        @SUPPORTSCHECKOUTONLY=@SUPPORTSCHECKOUTONLY output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPFORMCMSSETTINGS_4
        @ID,
        @CHANGEAGENTID,
        @CHILDDISPLAYHTML,
        @PROJECTDISPLAYHTML,
        @ATTRIBUTEITEMSLIST,
        @DESIGNATIONLIST,
        @DEFAULTDESIGNATIONID,
        @DEFAULTDESIGNATION,
        @APPEALSLIST,
        @REQUIREAPPEAL,
        @SOLESPONSORSHIPENABLED,
        @GIFTSPONSORSHIPENABLED,
        @ECARDSENABLED,
        @ADDITIONALGIFTENABLED,
        @MULTIPLEGIFTSENABLED,
        @MINIMUMGIFTAMOUNT,
        @CONSTITUENCYID,
        @GENERALRECURRENCEENABLED,
        @SCHEDULEDENDDATEENABLED,
        @RECURRENCEDATAIDLIST,
        @ITEMEXPIRATION,
        @PAYMENTPARTPAGE,
        @DIRECTDEBITENABLED,
        @CHECKENABLED,
        @FORMITEMEXPIRATION,
        @ACKNOWLEDGEMENTHTML,
        @FORCESTARTDATE,
        @PDACCOUNTSYSTEMID,
        @SUPPORTSCHECKOUTONLY

  return 0;