Deleting template and data definitions

DELETE from XDO_TEMPLATES_TL where TEMPLATE_CODE  = 'XX_TEMPLATE_CODE';

DELETE from XDO_TEMPLATES_B where TEMPLATE_CODE  = 'XX_TEMPLATE_CODE';

DELETE from XDO_TRANS_UNIT_PROPS where TEMPLATE_CODE  = 'XX_TEMPLATE_CODE';

DELETE from XDO_TRANS_UNIT_VALUES where TEMPLATE_CODE  = 'XX_TEMPLATE_CODE';

DELETE from XDO_LOBS where LOB_CODE LIKE 'XX_TEMPLATE_CODE'
and XDO_FILE_TYPE in ('XSL-FO','RTF');

DELETE from XDO_DS_DEFINITIONS_TL
where DATA_SOURCE_CODE  = 'XX_DATA_SOURCE_CODE';

DELETE from XDO_DS_DEFINITIONS_B
where DATA_SOURCE_CODE  = 'XX_DATA_SOURCE_CODE';