USP_BANKINGSYSTEM_EDIT

CREATE procedure dbo.USP_BANKINGSYSTEM_EDIT
(
    @ID uniqueidentifier,
    @ENABLED bit,
    @NAME nvarchar(50),
    @CHANGEAGENTID uniqueidentifier = null,
    @CURRENTDATE datetime = null
)
as
begin
    if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    if @CURRENTDATE is null
        set @CURRENTDATE = getdate();

    exec dbo.USP_BANKINGSYSTEM_SETCONDITIONSETTING @ID, @ENABLED, @CHANGEAGENTID, @CURRENTDATE;

    update dbo.BANKINGSYSTEM set
        NAME = @NAME,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where
        BANKINGSYSTEM.ID = @ID
        and NAME <> @NAME;

end