USP_DATAFORMTEMPLATE_EDIT_FENXTSYNCPROCESS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@FENXTINTEGRATIONID	uniqueidentifier	IN
@SYNCFISCALYEARS	bit	IN
@SYNCPROJECT_DESIGNATION	bit	IN
@SYNCACCOUNTS	bit	IN
@PURPOSETYPECODE	tinyint	IN
@PURPOSETYPEID	uniqueidentifier	IN

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FENXTSYNCPROCESS 
                    (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @NAME nvarchar(100),
                    @DESCRIPTION nvarchar(255),
                    @FENXTINTEGRATIONID uniqueidentifier,
                    @SYNCFISCALYEARS bit,
                    @SYNCPROJECT_DESIGNATION bit,
                    @SYNCACCOUNTS bit,
                    @PURPOSETYPECODE tinyint,
                    @PURPOSETYPEID uniqueidentifier
                    )
                    as
                        set nocount on;

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

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

                        begin try
                            -- handle updating the data

                            update dbo.FENXTSYNCPROCESS set
                                NAME = @NAME, 
                                DESCRIPTION = @DESCRIPTION, 
                                SYNCFISCALYEARS = @SYNCFISCALYEARS, 
                                SYNCPROJECT_DESIGNATION = @SYNCPROJECT_DESIGNATION, 
                                FENXTINTEGRATIONID = FENXTINTEGRATIONID, 
                                SYNCACCOUNTS = @SYNCACCOUNTS,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE,
                                PURPOSETYPECODE = case @SYNCPROJECT_DESIGNATION when 1 then @PURPOSETYPECODE else 0 end,
                                PURPOSETYPEID = case @SYNCPROJECT_DESIGNATION when 1 then case @PURPOSETYPECODE when 1 then @PURPOSETYPEID else null end else null end
                            where ID = @ID;
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1;
                        end catch

                    return 0;