USP_AWARDMANAGEMENTCONFIGURATION_DELETE

CREATE procedure dbo.USP_AWARDMANAGEMENTCONFIGURATION_DELETE
(
    @CHANGEAGENTID uniqueidentifier
)
as

  /* Cache CONTEXT INFO */
  declare @CONTEXTCACHE varbinary(128);
  set @CONTEXTCACHE = CONTEXT_INFO();

  if not @CHANGEAGENTID is null
    set CONTEXT_INFO @CHANGEAGENTID;

  delete from dbo.AWARDMANAGEMENTCONFIGURATION;

  /* Restore CONTEXT INFO */
  if not @CONTEXTCACHE is null
    set CONTEXT_INFO @CONTEXTCACHE;

  return 0;