USP_MKTPACKAGE_DELETE

Executes the "Package: 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_MKTPACKAGE_DELETE]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier
)
as begin
  set nocount on;

  if (select [ISSYSTEM] from dbo.[MKTPACKAGE] where ID = @ID) = 1
    begin
      raiserror('BBERR_MKTPACKAGE_ISSYSTEMPACKAGE', 13, 1);
      return 1;
    end

  exec dbo.[USP_MKTPACKAGE_DELETEBYID_WITHCHANGEAGENTID] @ID, @CHANGEAGENTID

  return 0;
end