USP_MKTVENDOR_DELETE

Executes the "Marketing Vendor: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



CREATE procedure dbo.USP_MKTVENDOR_DELETE
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier
)
as
  set nocount on;

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

  if exists(select CONSTITUENTID from FINANCIALTRANSACTION where CONSTITUENTID = @ID)
    raiserror('FK_FINANCIALTRANSACTION_CONSTITUENTID', 13, 1)

  begin try
    --No longer deletes the constituent. It just strips it of the constituency... if possible

    --exec dbo.USP_CONSTITUENT_DELETE @ID, @CHANGEAGENTID;


    --delete the vendor record


    exec dbo.USP_VENDOR_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
  end try

  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch

  return 0;