USP_MKTCOMMUNICATIONTEMPLATE_DELETE

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

  begin try
    /*****************************************************************************/
    /* Clean up the business process export format record related to template    */
    /*****************************************************************************/
    declare @BUSINESSPROCESSEXPORTFORMATID uniqueidentifier;

    select 
      @BUSINESSPROCESSEXPORTFORMATID = [BUSINESSPROCESSEXPORTFORMATID] 
    from dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULT] 
    where [COMMUNICATIONTEMPLATEID] = @ID;

    exec dbo.[USP_BUSINESSPROCESSEXPORTFORMAT_DELETEBYID_WITHCHANGEAGENTID] @BUSINESSPROCESSEXPORTFORMATID, @CHANGEAGENTID;

    /***********************/
    /* Delete template     */
    /***********************/
    exec dbo.[USP_MKTCOMMUNICATIONTEMPLATE_DELETEBYID_WITHCHANGEAGENTID] @ID, @CHANGEAGENTID;
  end try

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

  return 0;