Line 246: DELETE FROM RRS_SITE_USES WHERE SITE_ID = p_site_id;
242: IS
243: BEGIN
244: DELETE FROM RRS_SITES_EXT_TL WHERE SITE_ID = p_site_id;
245: DELETE FROM RRS_SITES_EXT_B WHERE SITE_ID = p_site_id; 246: DELETE FROM RRS_SITE_USES WHERE SITE_ID = p_site_id; 247: DELETE FROM RRS_SITES_TL WHERE SITE_ID = p_site_id;
248: DELETE FROM RRS_SITES_B WHERE SITE_ID = p_site_id;
249: COMMIT;
250: END DELETE_TEMPLATE;