USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPSTATUSCMSSETTINGS

The save procedure used by the edit dataform template "SponsorshipStatusCMSSettings Edit 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.
@CHILDHTMLCONTENT	nvarchar(max)	IN	ChildHtmlcontent
@PROJECTHTMLCONTENT	nvarchar(max)	IN	ProjectHtmlContent
@FILTERPROGRAM	bit	IN	Filterprogram
@SELECTEDPROGRAMS	xml	IN	Selectedprograms
@NOTESAVAILABLILITYCODE	tinyint	IN	Notesavailablility
@NOTESCODESLIST	xml	IN	Notescodeslist
@ATTACHMENTSAVAILABILITYCODE	tinyint	IN	Attachmentsavailability
@ATTACHMENTCODESLIST	xml	IN	Attachmentcodeslist
@MEDIALINKSAVAILABILITYCODE	tinyint	IN	Medialinksavailability
@MEDIALINKCODESLIST	xml	IN	Medialinkcodeslist
@EMAILENABLED	bit	IN	Emailenabled
@EMAILCATEGORYID	uniqueidentifier	IN	Emailcategoryid
@EMAILSUBCATEGORYID	uniqueidentifier	IN	Emailsubcategoryid
@DEFAULTEMAILCATEGORYID	uniqueidentifier	IN	Defaultemailcategoryid
@DEFAULTEMAILSUBCATEGORYID	uniqueidentifier	IN	Defaultemailsubcategoryid
@DEFAULTEMAILADDRESS	UDT_EMAILADDRESS	IN	Defaultemailaddress
@EMAILTYPECODE	uniqueidentifier	IN	Emailtypecode
@EMAILFIELDLIMIT	int	IN	Emailfieldlimit
@EMAILTEMPLATESLIST	xml	IN	EmailTEMPLATeslist
@EMAILPROGRAMLIST	xml	IN	Emailprogramlist
@OUTPUTFIELDLIST	xml	IN	Outputfieldlist

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPSTATUSCMSSETTINGS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CHILDHTMLCONTENT nvarchar(max),
    @PROJECTHTMLCONTENT nvarchar(max),
    @FILTERPROGRAM bit,
    @SELECTEDPROGRAMS xml,
    @NOTESAVAILABLILITYCODE tinyint,
    @NOTESCODESLIST xml,
    @ATTACHMENTSAVAILABILITYCODE tinyint,
    @ATTACHMENTCODESLIST xml,
    @MEDIALINKSAVAILABILITYCODE tinyint,
    @MEDIALINKCODESLIST xml,
    @EMAILENABLED bit,
    @EMAILCATEGORYID uniqueidentifier,
    @EMAILSUBCATEGORYID uniqueidentifier,
    @DEFAULTEMAILCATEGORYID uniqueidentifier,
    @DEFAULTEMAILSUBCATEGORYID uniqueidentifier,
    @DEFAULTEMAILADDRESS dbo.UDT_EMAILADDRESS,
    @EMAILTYPECODE uniqueidentifier,
    @EMAILFIELDLIMIT int,
    @EMAILTEMPLATESLIST xml,
    @EMAILPROGRAMLIST xml,
    @OUTPUTFIELDLIST xml
)

as
  set nocount on;

  declare @PAYMENTPARTPAGE int;  

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPSTATUSCMSSETTINGS
        @ID = @ID,
    @PAYMENTPARTPAGE = @PAYMENTPARTPAGE output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPSTATUSCMSSETTINGS_2
        @ID,
        @CHANGEAGENTID,
        @CHILDHTMLCONTENT,
        @PROJECTHTMLCONTENT,
        @FILTERPROGRAM,
        @SELECTEDPROGRAMS,
        @NOTESAVAILABLILITYCODE,
        @NOTESCODESLIST,
        @ATTACHMENTSAVAILABILITYCODE,
        @ATTACHMENTCODESLIST,
        @MEDIALINKSAVAILABILITYCODE,
        @MEDIALINKCODESLIST,
        @EMAILENABLED,
        @EMAILCATEGORYID,
        @EMAILSUBCATEGORYID,
        @DEFAULTEMAILCATEGORYID,
        @DEFAULTEMAILSUBCATEGORYID,
        @DEFAULTEMAILADDRESS,
        @EMAILTYPECODE,
        @EMAILFIELDLIMIT,
        @EMAILTEMPLATESLIST,
        @EMAILPROGRAMLIST,
        @OUTPUTFIELDLIST,
    @PAYMENTPARTPAGE

  return 0;