USP_DATAFORMTEMPLATE_EDIT_GLOBALRELATIONSHIPSETTINGS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_GLOBALRELATIONSHIPSETTINGS 
(
    @CHANGEAGENTID uniqueidentifier = null,
    @RECIPROCALRELATIONSHIPSORTCODE tinyint
)
as
    set nocount on;

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

    declare @CURRENTDATE datetime = getdate();

    begin try
        update dbo.GLOBALRELATIONSHIPSETTINGS set
            RECIPROCALRELATIONSHIPSORTCODE = @RECIPROCALRELATIONSHIPSORTCODE,
            DATECHANGED = @CURRENTDATE,
            CHANGEDBYID = @CHANGEAGENTID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

    return 0;