USP_DATAFORMTEMPLATE_ADD_AWARDMANAGEMENTINTEGRATIONSYNCEDRECORDMERGE

create procedure dbo.USP_DATAFORMTEMPLATE_ADD_AWARDMANAGEMENTINTEGRATIONSYNCEDRECORDMERGE
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @BUSINESSPROCESSPARAMETERSETID uniqueidentifier = null,
    @AMRECORDID int = 0,
    @DATESYNCED datetime = 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

    merge into dbo.AWARDMANAGEMENTSYNCEDRECORD as Target
    using (
           select
      @BUSINESSPROCESSPARAMETERSETID BUSINESSPROCESSPARAMETERSETID,
      @AMRECORDID AMRECORDID,
      @DATESYNCED DATESYNCED
      ) as Source
      on (
      Target.BUSINESSPROCESSPARAMETERSETID = Source.BUSINESSPROCESSPARAMETERSETID
      and Target.AMRECORDID = Source.AMRECORDID
      )
      when matched then
      update set Target.DATESYNCED=Source.DATESYNCED
      when not matched then
      insert (BUSINESSPROCESSPARAMETERSETID,AMRECORDID,DATESYNCED)
      values (Source.BUSINESSPROCESSPARAMETERSETID,Source.AMRECORDID,Source.DATESYNCED);

end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0