DBA Data[Home] [Help]

APPS.BIS_CUSTOMIZATIONS_PVT dependencies on AK_CUSTOM_REGIONS

Line 170: ak_custom_regions_pkg.insert_row(

166: IS
167: l_rowid VARCHAR2(100);
168: BEGIN
169:
170: ak_custom_regions_pkg.insert_row(
171: X_ROWID => l_rowid
172: , X_CUSTOMIZATION_APPLICATION_ID => p_Custom_Regions_Rec.CUSTOMIZATION_APPLICATION_ID
173: , X_CUSTOMIZATION_CODE => p_Custom_Regions_Rec.CUSTOMIZATION_CODE
174: , X_REGION_APPLICATION_ID => p_Custom_Regions_Rec.REGION_APPLICATION_ID

Line 213: ak_custom_regions_pkg.delete_row(

209: BEGIN
210: --BugFix 3500031
211: /*
212: BEGIN
213: ak_custom_regions_pkg.delete_row(
214: X_CUSTOMIZATION_APPLICATION_ID => p_Custom_Regions_Rec.customization_application_id
215: , X_CUSTOMIZATION_CODE => p_Custom_Regions_Rec.customization_code
216: , X_REGION_APPLICATION_ID => p_Custom_Regions_Rec.region_application_id
217: , X_REGION_CODE => p_Custom_Regions_Rec.region_code

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

339:
340: IF (p_customizationCode is not null AND p_regionCode is not null) THEN
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;

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

340: IF (p_customizationCode is not null AND p_regionCode is not null) THEN
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:

Line 374: DELETE FROM ak_custom_regions_tl

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
376: AND region_application_id = p_region_application_id;
377: DELETE FROM ak_custom_regions
378: WHERE region_code = p_region_code

Line 377: DELETE FROM ak_custom_regions

373: AND region_application_id = p_region_application_id;
374: DELETE FROM ak_custom_regions_tl
375: WHERE region_code = p_region_code
376: AND region_application_id = p_region_application_id;
377: DELETE FROM ak_custom_regions
378: WHERE region_code = p_region_code
379: AND region_application_id = p_region_application_id;
380: DELETE FROM ak_customizations_tl
381: WHERE region_code = p_region_code

Line 389: DELETE FROM bis_ak_custom_regions

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
391: AND region_application_id = p_region_application_id;
392:
393: EXCEPTION