XML or BI publisher template and data Definition deletion or Removal

From http://sivakandigatla.blogspot.com/2011/07/xml-or-bi-publisher-template-and-data.html

select * from XDO_TEMPLATES_B        where template_code    = :p_template_code
select * from XDO_TEMPLATES_TL       where template_code    = :p_template_code
select * from XDO_LOBS               where lob_code         = :p_template_code
select * from XDO_DS_DEFINITIONS_TL  where data_source_code = :p_template_code
select * from XDO_DS_DEFINITIONS_B   where data_source_code = :p_template_code

declare
p_template_code XDO_TEMPLATES_B.template_code%type := 'XXGRREP' ;
begin
delete   from XDO_TEMPLATES_B        where template_code    = :p_template_code
delete   from XDO_TEMPLATES_TL       where template_code    = :p_template_code
delete   from xdo_lobs               where lob_code         = :p_template_code
delete   from XDO_DS_DEFINITIONS_TL  where data_source_code = :p_template_code
delete   from XDO_DS_DEFINITIONS_b   where data_source_code = :p_template_code
end;