USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPSTATUSCMSSETTINGS_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHILDHTMLCONTENT	nvarchar(max)	IN
@PROJECTHTMLCONTENT	nvarchar(max)	IN
@FILTERPROGRAM	bit	IN
@SELECTEDPROGRAMS	xml	IN
@NOTESAVAILABLILITYCODE	tinyint	IN
@NOTESCODESLIST	xml	IN
@ATTACHMENTSAVAILABILITYCODE	tinyint	IN
@ATTACHMENTCODESLIST	xml	IN
@MEDIALINKSAVAILABILITYCODE	tinyint	IN
@MEDIALINKCODESLIST	xml	IN
@EMAILENABLED	bit	IN
@EMAILCATEGORYID	uniqueidentifier	IN
@EMAILSUBCATEGORYID	uniqueidentifier	IN
@DEFAULTEMAILCATEGORYID	uniqueidentifier	IN
@DEFAULTEMAILSUBCATEGORYID	uniqueidentifier	IN
@DEFAULTEMAILADDRESS	UDT_EMAILADDRESS	IN
@EMAILTYPECODE	uniqueidentifier	IN
@EMAILFIELDLIMIT	int	IN
@EMAILTEMPLATESLIST	xml	IN
@EMAILPROGRAMLIST	xml	IN
@OUTPUTFIELDLIST	xml	IN
@PAYMENTPARTPAGE	int	IN

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPSTATUSCMSSETTINGS_2
(
    @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,
    @PAYMENTPARTPAGE int
)

as
  set nocount on;

    declare @SPONSORSHIPLISTFORMATCODE tinyint;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPSTATUSCMSSETTINGS
        @ID = @ID,
        @SPONSORSHIPLISTFORMATCODE = @SPONSORSHIPLISTFORMATCODE output

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

  return 0;