Script to Delete XML publisher Data Definition or Template

In the XML Publisher's OA Framework pages, both Template and Data Definition pages do not provide an option to delete anything. As an alternative you may opt to run the below script to delete the unwanted records.

DECLARE
BEGIN 
DELETE FROM xdo_templates_b where   template_code = 
Delete   from XDO_TEMPLATES_TL  where template_code    = 
Delete   from xdo_lobs  where lob_code     = 
Delete   from XDO_DS_DEFINITIONS_TL  where data_source_code = 
Delete   from XDO_DS_DEFINITIONS_b   where data_source_code = 
END;