USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTGROUPBASECURRENCY

The save procedure used by the edit dataform template "Segment Group Base Currency Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@BASECURRENCYID	uniqueidentifier	IN	Base currency

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTGROUPBASECURRENCY]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @BASECURRENCYID uniqueidentifier
)
as

  set nocount on;

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

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

  begin try
      declare @OLDBASECURRENCYID uniqueidentifier;
      select 
          @OLDBASECURRENCYID = [BASECURRENCYID]
      from 
          dbo.[MKTSEGMENTGROUP]
      where
          [ID] = @ID;

      if @OLDBASECURRENCYID <> @BASECURRENCYID
      begin
      update dbo.[MKTSEGMENTGROUP] set
          [BASECURRENCYID] = @BASECURRENCYID,
          [CHANGEDBYID] = @CHANGEAGENTID,
          [DATECHANGED] = @CURRENTDATE
      where [ID] = @ID;
      end
  end try
  begin catch
      exec dbo.[USP_RAISE_ERROR];
      return 1;
  end catch

  return 0;