USP_STANDINGORDERSIMPORTPROCESS_EDIT

Edits a standing orders import process.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@BATCHTEMPLATEID	uniqueidentifier	IN
@BATCHNUMBER	nvarchar(60)	IN
@OWNERID	uniqueidentifier	IN
@IMPORTFILENAME	nvarchar(255)	IN
@IMPORTTEMPLATEID	uniqueidentifier	IN
@DUEDATETYPECODE	tinyint	IN
@CUTOFFDATE	datetime	IN
@DAYSAFTER	int	IN
@PAYFUTURE	bit	IN

Definition

Copy



            create procedure dbo.USP_STANDINGORDERSIMPORTPROCESS_EDIT
            (
                @ID uniqueidentifier = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @NAME nvarchar(100) = '', 
                @DESCRIPTION nvarchar(255) = '',
                @BATCHTEMPLATEID uniqueidentifier = null,
                @BATCHNUMBER nvarchar(60) = '',
                @OWNERID uniqueidentifier = null,
                @IMPORTFILENAME nvarchar(255) = '',
                @IMPORTTEMPLATEID uniqueidentifier = null,
                @DUEDATETYPECODE tinyint = 0,
                @CUTOFFDATE datetime = null,
                @DAYSAFTER integer = 0,
                @PAYFUTURE bit = 0
            )
            with execute as caller
            as

            set nocount on;

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

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

            begin try
                update dbo.STANDINGORDERSIMPORTPROCESS
                    set
                        NAME = @NAME,
                        DESCRIPTION = @DESCRIPTION,
                        BATCHTEMPLATEID = @BATCHTEMPLATEID,
                        BATCHNUMBER = @BATCHNUMBER,
                        OWNERID = @OWNERID,
                        IMPORTFILENAME = @IMPORTFILENAME,
                        IMPORTTEMPLATEID = @IMPORTTEMPLATEID,
                        DUEDATETYPECODE = @DUEDATETYPECODE,
                        CUTOFFDATE = @CUTOFFDATE,
                        DAYSAFTER = @DAYSAFTER,
                        PAYFUTURE = @PAYFUTURE,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                where
                    ID = @ID;
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;