Delete XML Template and Definition / Remove XML Template and Definition

delete   from XDO_TEMPLATES_B        where template_code    = :p_code;
/
delete   from XDO_TEMPLATES_TL       where template_code    = :p_code;
/
delete   from xdo_lobs               where lob_code         = :p_code;
/
delete   from XDO_DS_DEFINITIONS_TL  where data_source_code = :p_code;
/
delete   from XDO_DS_DEFINITIONS_b   where data_source_code = :p_code;
/