USP_SAVE_ACKNOWLEDGEMENTANDRECEIPTINGPROCESSSTATUSIDS

Associates the given Acknowledgement and Receipting status Id with nested process status Ids.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUSID	uniqueidentifier	IN
@MKTSEGMENTATIONEXPORTPROCESSSTATUSID	uniqueidentifier	IN
@HTMLTEMPLATETODOCXMERGEPROCESSSTATUSID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_SAVE_ACKNOWLEDGEMENTANDRECEIPTINGPROCESSSTATUSIDS
(
    @ID uniqueidentifier,
    @MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUSID uniqueidentifier = null,
    @MKTSEGMENTATIONEXPORTPROCESSSTATUSID uniqueidentifier = null,
    @HTMLTEMPLATETODOCXMERGEPROCESSSTATUSID uniqueidentifier = null,
    @CHANGEAGENTID uniqueidentifier = null
)
as
begin

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    if @CHANGEAGENTID is null 
        exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

    insert into ACKNOWLEDGEMENTANDRECEIPTINGPROCESSSTATUSIDS
    (
        ID,
        MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUSID,
        MKTSEGMENTATIONEXPORTPROCESSSTATUSID,
        HTMLTEMPLATETODOCXMERGEPROCESSSTATUSID,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED
    )
    values
    (
        @ID,
        @MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUSID,
        @MKTSEGMENTATIONEXPORTPROCESSSTATUSID,
        @HTMLTEMPLATETODOCXMERGEPROCESSSTATUSID,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE
    )    

end