USP_DATAFORMTEMPLATE_EDIT_REVENUEOFFLINEDONATION

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@REGISTRANTID	uniqueidentifier	IN	Registrant
@ADDRESSBOOKFAFID	uniqueidentifier	IN	Address book Faf
@DONORNAME	nvarchar(200)	IN	Donor name
@AMOUNT	money	IN	Amount
@PAYMENTTYPECODE	tinyint	IN	Payment type
@CHECKNUMBER	nvarchar(20)	IN	Check number
@EXPECTEDDATE	datetime	IN	Expected date

Definition

Copy




CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEOFFLINEDONATION (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,

    @REGISTRANTID uniqueidentifier,
    @ADDRESSBOOKFAFID uniqueidentifier,
    @DONORNAME nvarchar(200),
    @AMOUNT money,     
    @PAYMENTTYPECODE tinyint,
    @CHECKNUMBER nvarchar(20),
    @EXPECTEDDATE datetime

 --,@AMOUNTCONFIRMED money 

 --,@GIFTID    int  

)
as
    set nocount on;

    DECLARE     @LOCALCORPNAME nvarchar(20)    
    DECLARE     @LOCALCORPZIP nvarchar(20) 

    SET @LOCALCORPNAME = 'none'
    SET @LOCALCORPZIP = ''

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUEOFFLINEDONATION
        @ID = @ID,
        @LOCALCORPZIP = @LOCALCORPZIP output,
        @LOCALCORPNAME = @LOCALCORPNAME output



    exec dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEOFFLINEDONATION_2
        @ID,
        @CHANGEAGENTID,
        @REGISTRANTID,
        @ADDRESSBOOKFAFID,
        @DONORNAME,
        @AMOUNT,
        @PAYMENTTYPECODE,
        @CHECKNUMBER,
        @EXPECTEDDATE,
        @LOCALCORPNAME = 'none',
        @LOCALCORPZIP = ''

        return 0;