USP_OPPORTUNITY_ADDPAYMENT

Adds a payment of a gift.

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@OPPORTUNITYID	uniqueidentifier	IN
@AMOUNT	money	IN
@DESIGNATIONID	uniqueidentifier	IN
@CAMPAIGNS	xml	IN
@RECOGNITIONCREDITS	xml	IN
@SOLICITORS	xml	IN
@CREATIONDATE	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_OPPORTUNITY_ADDPAYMENT
            (
                @REVENUEID uniqueidentifier,
                @OPPORTUNITYID uniqueidentifier,
                @AMOUNT money,
                @DESIGNATIONID uniqueidentifier,
                @CAMPAIGNS xml,
                @RECOGNITIONCREDITS xml,
                @SOLICITORS xml,
                @CREATIONDATE datetime = null,
                @CHANGEAGENTID uniqueidentifier = null
            )
            as
                set nocount on;

                declare @ID uniqueidentifier;
                set @ID = newid();

                insert into dbo.REVENUESPLIT(ID, REVENUEID, APPLICATIONCODE, TYPECODE, DESIGNATIONID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                values(@ID, @REVENUEID, 9, 0, @DESIGNATIONID, @CHANGEAGENTID, @CHANGEAGENTID, @CREATIONDATE, @CREATIONDATE);

                insert into dbo.REVENUEOPPORTUNITY(ID, OPPORTUNITYID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                values(@ID, @OPPORTUNITYID, @CHANGEAGENTID, @CHANGEAGENTID, @CREATIONDATE, @CREATIONDATE);

                --exec dbo.USP_REVENUESPLIT_GETCAMPAIGNS_ADDFROMXML @ID, @CAMPAIGNS, @CHANGEAGENTID;

                exec dbo.USP_REVENUE_GETRECOGNITIONS_ADDFROMXML @ID, @CAMPAIGNS, @CHANGEAGENTID;
                exec dbo.USP_REVENUE_GETSOLICITORS_ADDFROMXML @ID, @SOLICITORS, @CHANGEAGENTID;