APPS.AR_BPA_TEMPLATES_PKG dependencies on AR_BPA_CONTENT_AREAS_B

Line 456: where content_area_id in (select content_area_id from ar_bpa_content_areas_b

452: up content area deletion. In any case without a template, it's content areas (detail)
453: mustn't exist
454: */
455: delete from AR_BPA_CONTENT_AREAS_TL
456: where content_area_id in (select content_area_id from ar_bpa_content_areas_b
457: where template_id = X_TEMPLATE_ID);
458:
459: delete from AR_BPA_CONTENT_AREAS_B
460: where TEMPLATE_ID = X_TEMPLATE_ID;

Line 459: delete from AR_BPA_CONTENT_AREAS_B

455: delete from AR_BPA_CONTENT_AREAS_TL
456: where content_area_id in (select content_area_id from ar_bpa_content_areas_b
457: where template_id = X_TEMPLATE_ID);
458:
459: delete from AR_BPA_CONTENT_AREAS_B
460: where TEMPLATE_ID = X_TEMPLATE_ID;
461:
462: delete from AR_BPA_AREA_ITEMS
463: where TEMPLATE_ID = X_TEMPLATE_ID;