DBA Data[Home] [Help]

APPS.BIS_CUSTOMIZATIONS_PVT dependencies on AK_CUSTOM_REGION_ITEMS_TL

Line 346: DELETE FROM ak_custom_region_items_tl WHERE region_code = p_regionCode AND region_application_id = p_regionAppId AND customization_code = p_customizationCode AND customization_application_id = p_customizationAppId;

342: DELETE FROM ak_customizations_tl WHERE region_code = p_regionCode AND region_application_id = p_regionAppId AND customization_code = p_customizationCode AND customization_application_id = p_customizationAppId;
343: DELETE FROM ak_custom_regions WHERE region_code = p_regionCode AND region_application_id = p_regionAppId AND customization_code = p_customizationCode AND customization_application_id = p_customizationAppId;
344: DELETE FROM ak_custom_regions_tl WHERE region_code = p_regionCode AND region_application_id = p_regionAppId AND customization_code = p_customizationCode AND customization_application_id = p_customizationAppId;
345: DELETE FROM ak_custom_region_items WHERE region_code = p_regionCode AND region_application_id = p_regionAppId AND customization_code = p_customizationCode AND customization_application_id = p_customizationAppId;
346: DELETE FROM ak_custom_region_items_tl WHERE region_code = p_regionCode AND region_application_id = p_regionAppId AND customization_code = p_customizationCode AND customization_application_id = p_customizationAppId;
347: END IF;
348:
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:

Line 368: DELETE FROM ak_custom_region_items_tl

364: )
365: IS
366: BEGIN
367:
368: DELETE FROM ak_custom_region_items_tl
369: WHERE region_code = p_region_code
370: AND region_application_id = p_region_application_id;
371: DELETE FROM ak_custom_region_items
372: WHERE region_code = p_region_code