USP_DATAFORMTEMPLATE_EDIT_COAUPDATEPROCESSOPTIONS_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@UPDATEADDRESSCODE	tinyint	IN
@SAVEFORMERADDRESS	bit	IN
@ADDRESSTYPECODEID	uniqueidentifier	IN
@FOOTNOTECODE1REASONCODEID	uniqueidentifier	IN
@FOOTNOTECODE2REASONCODEID	uniqueidentifier	IN
@FOOTNOTECODE3REASONCODEID	uniqueidentifier	IN
@FOOTNOTECODE4REASONCODEID	uniqueidentifier	IN
@FOOTNOTECODE5REASONCODEID	uniqueidentifier	IN
@FOOTNOTECODE6REASONCODEID	uniqueidentifier	IN
@FOOTNOTECODE7REASONCODEID	uniqueidentifier	IN
@INFOSOURCECODEID	uniqueidentifier	IN
@MAILGRADEFREASONCODEID	uniqueidentifier	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_COAUPDATEPROCESSOPTIONS_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @UPDATEADDRESSCODE tinyint,
    @SAVEFORMERADDRESS bit,
    @ADDRESSTYPECODEID uniqueidentifier,
    @FOOTNOTECODE1REASONCODEID uniqueidentifier,
    @FOOTNOTECODE2REASONCODEID uniqueidentifier,
    @FOOTNOTECODE3REASONCODEID uniqueidentifier,
    @FOOTNOTECODE4REASONCODEID uniqueidentifier,
    @FOOTNOTECODE5REASONCODEID uniqueidentifier,
    @FOOTNOTECODE6REASONCODEID uniqueidentifier,
    @FOOTNOTECODE7REASONCODEID uniqueidentifier,
    @INFOSOURCECODEID uniqueidentifier,
    @MAILGRADEFREASONCODEID uniqueidentifier
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime = getdate();

    begin try
        update dbo.COAUPDATE set
            [UPDATEADDRESSCODE] = @UPDATEADDRESSCODE,
            [SAVEFORMERADDRESS] = @SAVEFORMERADDRESS,
            [ADDRESSTYPECODEID] = @ADDRESSTYPECODEID,
            [FOOTNOTECODE1REASONCODEID] = @FOOTNOTECODE1REASONCODEID,
            [FOOTNOTECODE2REASONCODEID] = @FOOTNOTECODE2REASONCODEID,
            [FOOTNOTECODE3REASONCODEID] = @FOOTNOTECODE3REASONCODEID,
            [FOOTNOTECODE4REASONCODEID] = @FOOTNOTECODE4REASONCODEID,
            [FOOTNOTECODE5REASONCODEID] = @FOOTNOTECODE5REASONCODEID,
            [FOOTNOTECODE6REASONCODEID] = @FOOTNOTECODE6REASONCODEID,
            [FOOTNOTECODE7REASONCODEID] = @FOOTNOTECODE7REASONCODEID,
            [INFOSOURCECODEID] = @INFOSOURCECODEID,
            [MAILGRADEFREASONCODEID] = @MAILGRADEFREASONCODEID,
            [CHANGEDBYID] = @CHANGEAGENTID,
            [DATECHANGED] = @CURRENTDATE
        where [ID] = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

return 0;