DBA Data[Home] [Help]

APPS.BIS_CUSTOMIZATIONS_PVT dependencies on AK_CUSTOM_REGION_ITEMS

Line 251: ak_custom_region_items_pkg.insert_row(

247: IS
248: l_rowid VARCHAR2(100);
249: BEGIN
250:
251: ak_custom_region_items_pkg.insert_row(
252: X_ROWID =>l_rowid
253: ,X_CUSTOMIZATION_APPLICATION_ID => p_Custom_Region_Items_Rec.CUSTOMIZATION_APPLICATION_ID
254: ,X_CUSTOMIZATION_CODE => p_Custom_Region_Items_Rec.CUSTOMIZATION_CODE
255: ,X_REGION_APPLICATION_ID => p_Custom_Region_Items_Rec.REGION_APPLICATION_ID

Line 298: ak_custom_region_items_pkg.delete_row(

294: BEGIN
295: --BugFix 3500031
296: /*
297: BEGIN
298: ak_custom_region_items_pkg.delete_row(
299: X_CUSTOMIZATION_APPLICATION_ID => p_Custom_Region_Items_Rec.customization_application_id
300: ,X_CUSTOMIZATION_CODE => p_Custom_Region_Items_Rec.customization_code
301: ,X_REGION_APPLICATION_ID => p_Custom_Region_Items_Rec.region_application_id
302: ,X_REGION_CODE => p_Custom_Region_Items_Rec.region_code

Line 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;

341: DELETE FROM ak_customizations 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;

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

Line 371: DELETE FROM ak_custom_region_items

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
373: AND region_application_id = p_region_application_id;
374: DELETE FROM ak_custom_regions_tl
375: WHERE region_code = p_region_code

Line 386: DELETE FROM bis_ak_custom_region_items

382: AND region_application_id = p_region_application_id;
383: DELETE FROM ak_customizations
384: WHERE region_code = p_region_code
385: AND region_application_id = p_region_application_id;
386: DELETE FROM bis_ak_custom_region_items
387: WHERE region_code = p_region_code
388: AND region_application_id = p_region_application_id;
389: DELETE FROM bis_ak_custom_regions
390: WHERE region_code = p_region_code