USP_DATAFORMTEMPLATE_ADD_FENXTSYNCPROCSS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@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_ADD_FENXTSYNCPROCSS
                (
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,
                @NAME nvarchar(100) = '',
                @DESCRIPTION nvarchar(255) = '',
                @FENXTINTEGRATIONID uniqueidentifier = null,
                @SYNCFISCALYEARS bit = 0,
                @SYNCPROJECT_DESIGNATION bit = 0,
                @SYNCACCOUNTS bit = 0,
                @PURPOSETYPECODE tinyint = 1,
                @PURPOSETYPEID uniqueidentifier = null
                )
                as

                set nocount on;

                if @ID is null
                    set @ID = newid();

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

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

                begin try
                    -- handle inserting the data

                    insert into dbo.FENXTSYNCPROCESS
                        (ID, 
                        NAME,
                        DESCRIPTION,
                        SYNCFISCALYEARS,
                        SYNCPROJECT_DESIGNATION,
                        FENXTINTEGRATIONID,
                        SYNCACCOUNTS,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED)
                    values
                        (@ID,
                        @NAME,
                        @DESCRIPTION,
                        @SYNCFISCALYEARS,
                        @SYNCPROJECT_DESIGNATION,
                        @FENXTINTEGRATIONID,
                        @SYNCACCOUNTS,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CURRENTDATE,
                        @CURRENTDATE);
                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1;
                end catch

                return 0;