USP_DATAFORMTEMPLATE_EDITSAVE_SOLESPONSORSHIPREMOVE_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DATE	datetime	IN
@AMOUNT	money	IN
@SPLITS	xml	IN
@FREQUENCYCODE	tinyint	IN
@ENDDATE	datetime	IN
@STARTDATE	datetime	IN
@FINDERNUMBER	bigint	IN
@SOURCECODE	nvarchar(50)	IN
@APPEALID	uniqueidentifier	IN
@GIVENANONYMOUSLY	bit	IN
@MAILINGID	uniqueidentifier	IN
@CHANNELCODEID	uniqueidentifier	IN
@DONOTACKNOWLEDGE	bit	IN
@REFERENCE	nvarchar(255)	IN
@CATEGORYCODEID	uniqueidentifier	IN
@SENDREMINDER	bit	IN
@NEXTINSTALLMENTID	uniqueidentifier	IN
@REVENUEDEVELOPMENTFUNCTIONCODEID	uniqueidentifier	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@BASEEXCHANGERATEID	uniqueidentifier	IN
@EXCHANGERATE	decimal(20, 8)	IN
@HADSPOTRATE	bit	IN
@RATECHANGED	bit	IN
@UPDATERECOGNITIONOPTION	tinyint	IN
@SCHEDULESEEDDATE	datetime	IN
@ISMEMBERSHIPRECURRING	bit	IN
@PREVIOUSSCHEDULESEEDDATE	datetime	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_SOLESPONSORSHIPREMOVE_2 (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @DATE datetime,
    @AMOUNT money,
    @SPLITS xml,
    @FREQUENCYCODE tinyint,
    @ENDDATE datetime,
    @STARTDATE datetime,
    @FINDERNUMBER bigint,
    @SOURCECODE nvarchar(50),
    @APPEALID uniqueidentifier,
    @GIVENANONYMOUSLY bit,
    @MAILINGID uniqueidentifier,
    @CHANNELCODEID uniqueidentifier,
    @DONOTACKNOWLEDGE bit,
    @REFERENCE nvarchar(255),
    @CATEGORYCODEID uniqueidentifier,
    @SENDREMINDER bit,
    @NEXTINSTALLMENTID uniqueidentifier,
    @REVENUEDEVELOPMENTFUNCTIONCODEID uniqueidentifier,
    @TRANSACTIONCURRENCYID uniqueidentifier,
    @BASEEXCHANGERATEID uniqueidentifier,
    @EXCHANGERATE decimal(20,8),
    @HADSPOTRATE bit,
    @RATECHANGED bit,
    @UPDATERECOGNITIONOPTION tinyint,
    @SCHEDULESEEDDATE datetime,
    @ISMEMBERSHIPRECURRING bit,
    @PREVIOUSSCHEDULESEEDDATE datetime
)
as

    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    declare @SPONSORSHIPID uniqueidentifier;
    set @SPONSORSHIPID = dbo.UFN_SPONSORSHIP_ID_FROM_REVENUEID(@ID);

    begin try
        exec dbo.USP_SPONSORSHIP_REMOVESOLESPONSORSHIP @SPONSORSHIPID, @CHANGEAGENTID

        exec dbo.USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFT_8
            @ID,
            @CHANGEAGENTID,
            @DATE,
            @AMOUNT,
            @SPLITS,
            @FREQUENCYCODE,
            @ENDDATE,
            @STARTDATE,
            @FINDERNUMBER,
            @SOURCECODE,
            @APPEALID,
            @GIVENANONYMOUSLY,
            @MAILINGID,
            @CHANNELCODEID,
            @DONOTACKNOWLEDGE,
            @REFERENCE,
            @CATEGORYCODEID,
            @SENDREMINDER,
            @NEXTINSTALLMENTID,
            @REVENUEDEVELOPMENTFUNCTIONCODEID,
            @TRANSACTIONCURRENCYID,
            @BASEEXCHANGERATEID,
            @EXCHANGERATE,
            @HADSPOTRATE,
            @RATECHANGED,
            @UPDATERECOGNITIONOPTION,
            null,
            @SCHEDULESEEDDATE,
            0,
            @PREVIOUSSCHEDULESEEDDATE;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;