USP_CRMBBPAYTEMPLATE_DELETE_BYPAGE

CREATE procedure dbo.USP_CRMBBPAYTEMPLATE_DELETE_BYPAGE
(
    @SITEPAGEID integer,
    @DELIVERYCHANNELID uniqueidentifier = null
)
as
begin

    --Cache current context information 

    declare @CONTEXTCACHE varbinary(128); 
    set @CONTEXTCACHE = CONTEXT_INFO();

    declare @ID uniqueidentifier
    select @ID = ID from 
        dbo.CRMBBPAYTEMPLATE
    where 
        SITEPAGEID = @SITEPAGEID
        and coalesce(DELIVERYCHANNELID, '23B56292-0F3C-43AC-AF13-7767AD9D4057') = coalesce(@DELIVERYCHANNELID, '23B56292-0F3C-43AC-AF13-7767AD9D4057')

   delete BBET from 
        dbo.BBPAYENVIRONMENTTEMPLATE BBET
    where 
        BBET.TEMPLATEID = @ID  

    delete from 
        dbo.CRMBBPAYTEMPLATE
    where 
        ID = @ID

    --Reset CONTEXT_INFO to previous value 

    if not @CONTEXTCACHE is null 
      set CONTEXT_INFO @CONTEXTCACHE;

    return 0;

end