USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMSPONSORSHIP_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SPONSORSHIPID	uniqueidentifier	IN
@SPONSORSHIPPROGRAMID	uniqueidentifier	IN
@SPONSORSHIPOPPORTUNITYID	uniqueidentifier	IN
@STARTDATE	date	IN
@GIFTRECIPIENTID	uniqueidentifier	IN
@SPONSORSHIPLOCATIONID	uniqueidentifier	IN
@GENDERCODE	tinyint	IN
@SPONSORSHIPOPPORTUNITYAGERANGEID	uniqueidentifier	IN
@ISHIVPOSITIVECODE	tinyint	IN
@HASCONDITIONCODE	tinyint	IN
@ISORPHANEDCODE	tinyint	IN
@SPROPPPROJECTCATEGORYCODEID	uniqueidentifier	IN
@ISSOLESPONSORSHIP	bit	IN
@EXPIRATIONDATE	date	IN
@EXPIRATIONREASONID	uniqueidentifier	IN
@AMOUNT	money	IN
@FREQUENCYCODE	tinyint	IN
@SCHEDULESTARTDATE	date	IN
@ORDERPAYMENTAMOUNT	money	IN
@GROUPID	uniqueidentifier	IN
@CALLBACKURL	nvarchar(255)	IN
@DATA	xml	IN
@ACKNOWLEDGEMENTHTML	nvarchar(max)	IN
@ATTRIBUTES	xml	IN
@OPTIONS	xml	IN
@MASKIMAGEID	int	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	IN
@CURRENCYISO	nvarchar(3)	IN

Definition

Copy



create procedure USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMSPONSORSHIP_3
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SPONSORSHIPID uniqueidentifier,
    @SPONSORSHIPPROGRAMID uniqueidentifier,
    @SPONSORSHIPOPPORTUNITYID uniqueidentifier,
    @STARTDATE date,
    @GIFTRECIPIENTID uniqueidentifier,
    @SPONSORSHIPLOCATIONID uniqueidentifier,
    @GENDERCODE tinyint,
    @SPONSORSHIPOPPORTUNITYAGERANGEID uniqueidentifier,
    @ISHIVPOSITIVECODE tinyint,
    @HASCONDITIONCODE tinyint,
    @ISORPHANEDCODE tinyint,
    @SPROPPPROJECTCATEGORYCODEID uniqueidentifier,
    @ISSOLESPONSORSHIP bit,
    @EXPIRATIONDATE date,
    @EXPIRATIONREASONID uniqueidentifier,
    @AMOUNT money,
    @FREQUENCYCODE tinyint,
    @SCHEDULESTARTDATE date,
    @ORDERPAYMENTAMOUNT money,
    @GROUPID uniqueidentifier,
    @CALLBACKURL nvarchar(255),
    @DATA xml,
    @ACKNOWLEDGEMENTHTML nvarchar(max),
    @ATTRIBUTES xml,
    @OPTIONS xml,
    @MASKIMAGEID int,
    @PDACCOUNTSYSTEMID uniqueidentifier,
    @CURRENCYISO nvarchar(3)
)

as
  set nocount on;

    declare @APPEALID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SALESORDERITEMSPONSORSHIP
        @ID = @ID,
        @APPEALID = @APPEALID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMSPONSORSHIP_4
        @ID,
        @CHANGEAGENTID,
        @SPONSORSHIPID,
        @SPONSORSHIPPROGRAMID,
        @SPONSORSHIPOPPORTUNITYID,
        @STARTDATE,
        @GIFTRECIPIENTID,
        @SPONSORSHIPLOCATIONID,
        @GENDERCODE,
        @SPONSORSHIPOPPORTUNITYAGERANGEID,
        @ISHIVPOSITIVECODE,
        @HASCONDITIONCODE,
        @ISORPHANEDCODE,
        @SPROPPPROJECTCATEGORYCODEID,
        @ISSOLESPONSORSHIP,
        @EXPIRATIONDATE,
        @EXPIRATIONREASONID,
        @AMOUNT,
        @FREQUENCYCODE,
        @SCHEDULESTARTDATE,
        @ORDERPAYMENTAMOUNT,
        @GROUPID,
        @CALLBACKURL,
        @DATA,
        @ACKNOWLEDGEMENTHTML,
        @ATTRIBUTES,
        @OPTIONS,
        @MASKIMAGEID,
        @PDACCOUNTSYSTEMID,
        @CURRENCYISO,
        @APPEALID

  return 0;