USP_DESIGNATIONLEVELREVENUEINFORMATION_UNMARKASORIGINALFUNDING

Executes the "Fundraising Purpose Revenue Information: Unmark As Original Funding" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nvarchar(72)	IN	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy


CREATE procedure dbo.USP_DESIGNATIONLEVELREVENUEINFORMATION_UNMARKASORIGINALFUNDING (
  @ID nvarchar(72)
  ,@CHANGEAGENTID uniqueidentifier
  )
as
begin
  set nocount on;

  declare @DATECHANGED datetime

  set @DATECHANGED = getdate();

  declare @REVENUEID uniqueidentifier;
  declare @DESIGNATIONLEVELID uniqueidentifier;

  set @REVENUEID = cast(left(@ID, 36) as uniqueidentifier);
  set @DESIGNATIONLEVELID = cast(right(@ID, 36) as uniqueidentifier);

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

  update dbo.DESIGNATIONLEVELREVENUEINFORMATION
  set ISORIGINALFUNDING = 0
    ,CHANGEDBYID = @CHANGEAGENTID
    ,DATECHANGED = @DATECHANGED
  where ISORIGINALFUNDING = 1
    and REVENUEID = @REVENUEID
    and DESIGNATIONLEVELID = @DESIGNATIONLEVELID;

  return 0;
end