USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTSEPAINFO

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTSEPAINFO 
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @INITIATINGPARTYNAME nvarchar(70),
    @CREDITORID nvarchar(35)
)
as
    set nocount on;

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

    declare @CURRENTDATE datetime = getdate();

    begin try
    if exists(select 1 from dbo.BANKACCOUNTSEPAINFO  where BANKACCOUNTSEPAINFO.ID = @ID)
    begin
        update dbo.BANKACCOUNTSEPAINFO set
            INITIATINGPARTYNAME = @INITIATINGPARTYNAME,
            CREDITORID = @CREDITORID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where BANKACCOUNTSEPAINFO.ID = @ID;
    end
    else
    begin
        insert into dbo.BANKACCOUNTSEPAINFO
        (
            ID,
            INITIATINGPARTYNAME,
            CREDITORID,
            CHANGEDBYID,
            ADDEDBYID,
            DATEADDED,
            DATECHANGED
        )
        values 
        (
            @ID,
            @INITIATINGPARTYNAME,
            @CREDITORID,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            @CURRENTDATE,
            @CURRENTDATE
        );
    end
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;