XML or BI publisher template and data Definition deletion or Removal

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
                                                := 'XXM_MACYS_EBS_SOW_REPORT';
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;