DBA Data[Home] [Help]

APPS.BIS_CUSTOMIZATIONS_PVT dependencies on AK_CUSTOMIZATIONS_TL

Line 28: -- creates rows in ak_customizations/tl

24: REM +=======================================================================+
25: */
26: --
27:
28: -- creates rows in ak_customizations/tl
29: --
30: PROCEDURE Create_Customizations
31: ( p_api_version IN NUMBER
32: , p_commit IN VARCHAR2 := 'N'

Line 73: insert into ak_customizations_tl

69: loop
70: fetch c_languages into l_language;
71: exit when c_languages%NOTFOUND;
72:
73: insert into ak_customizations_tl
74: (CUSTOMIZATION_APPLICATION_ID,CUSTOMIZATION_CODE
75: ,REGION_APPLICATION_ID,REGION_CODE,NAME
76: ,DESCRIPTION,LANGUAGE,SOURCE_LANG,CREATED_BY,CREATION_DATE
77: ,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN

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

338: BEGIN
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;

Line 380: DELETE FROM ak_customizations_tl

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
382: AND region_application_id = p_region_application_id;
383: DELETE FROM ak_customizations
384: WHERE region_code = p_region_code