USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMSPONSORSHIP

The save procedure used by the edit dataform template "Sales Order Item Sponsorship Edit Data Form".

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.
@SPONSORSHIPID	uniqueidentifier	IN	Sponsorship Id
@SPONSORSHIPPROGRAMID	uniqueidentifier	IN	Sponsorship Program Id
@SPONSORSHIPOPPORTUNITYID	uniqueidentifier	IN	Sponsorship Opportunity Id
@STARTDATE	date	IN	Start date
@GIFTRECIPIENTID	uniqueidentifier	IN	Gift Recipient Id
@SPONSORSHIPLOCATIONID	uniqueidentifier	IN	Sponsorship Location Id
@GENDERCODE	tinyint	IN	Gender Code
@SPONSORSHIPOPPORTUNITYAGERANGEID	uniqueidentifier	IN	Sponsorship age range Id
@ISHIVPOSITIVECODE	tinyint	IN	Is Hiv positive
@HASCONDITIONCODE	tinyint	IN	Has condition code
@ISORPHANEDCODE	tinyint	IN	Is orphaned code
@SPROPPPROJECTCATEGORYCODEID	uniqueidentifier	IN	Project category code
@ISSOLESPONSORSHIP	bit	IN	Is sole sponsorship
@EXPIRATIONDATE	date	IN	Expiration date
@EXPIRATIONREASONID	uniqueidentifier	IN	Expiration reason Id
@AMOUNT	money	IN	Amount
@FREQUENCYCODE	tinyint	IN	Frequency
@SCHEDULESTARTDATE	date	IN	Schedule start date
@ORDERPAYMENTAMOUNT	money	IN	Order payment amount
@GROUPID	uniqueidentifier	IN	Group Id
@CALLBACKURL	nvarchar(255)	IN	Call back url
@DATA	xml	IN	Data
@ACKNOWLEDGEMENTHTML	nvarchar(max)	IN	Acknowledgement Html
@ATTRIBUTES	xml	IN	Attributes
@OPTIONS	xml	IN	Options
@MASKIMAGEID	int	IN	Mask Image ID

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMSPONSORSHIP
(
    @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
)

as
  set nocount on;

    declare @PDACCOUNTSYSTEMID uniqueidentifier;

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

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMSPONSORSHIP_2
        @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

  return 0;