USP_NOTIFICATIONIDMAP_REGISTERMAPPINGFUNCTION

Stored procedure for creating or updating a row in the NOTIFICATIONIDMAP table.

Parameters

Parameter	Parameter Type	Mode
@FROMRECORDTYPE	nvarchar(200)	IN
@TORECORDTYPE	nvarchar(50)	IN
@MAPPINGFUNCTION	nvarchar(255)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_NOTIFICATIONIDMAP_REGISTERMAPPINGFUNCTION
            (
                @FROMRECORDTYPE nvarchar(200),
                @TORECORDTYPE nvarchar(50),
                @MAPPINGFUNCTION nvarchar(255),
                @CHANGEAGENTID uniqueidentifier=null
            )    
            as 
                set nocount on;

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

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

                update 
                    dbo.NOTIFICATIONIDMAP
                set 
                    MAPPINGFUNCTION = @MAPPINGFUNCTION,
                    DATECHANGED = @CURRENTDATE,
                    CHANGEDBYID = @CHANGEAGENTID
                where 
                    FROMRECORDTYPE = @FROMRECORDTYPE AND 
                    TORECORDTYPE = @TORECORDTYPE;

                if @@ROWCOUNT=0 begin
                    insert into dbo.NOTIFICATIONIDMAP 
                        (MAPPINGFUNCTION, FROMRECORDTYPE, TORECORDTYPE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                    VALUES
                        (@MAPPINGFUNCTION, @FROMRECORDTYPE, @TORECORDTYPE, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

                end