APPS.AK_OBJECT_PVT dependencies on AK_REGIONS

Line 31: from AK_REGIONS

27: p_database_object_name IN VARCHAR2
28: ) return BOOLEAN is
29: cursor l_check_region_csr is
30: select 1
31: from AK_REGIONS
32: where region_application_id = p_region_appl_id
33: and region_code = p_region_code
34: and database_object_name = p_database_object_name;
35: l_dummy number;

Line 1984: from AK_REGION_ITEMS ari, AK_REGIONS ar

1980: and attribute_application_id = p_attribute_application_id
1981: and attribute_code = p_attribute_code;
1982: cursor l_get_region_item_csr is
1983: select ari.REGION_APPLICATION_ID, ari.REGION_CODE
1984: from AK_REGION_ITEMS ari, AK_REGIONS ar
1985: where ar.database_object_name = p_database_object_name
1986: and ar.region_application_id = ari.region_application_id
1987: and ar.region_code = ari.region_code
1988: and ari.attribute_application_id = p_attribute_application_id

Line 1995: from AK_FLOW_PAGE_REGION_ITEMS afpri, AK_REGIONS ar

1991: cursor l_get_page_region_item_csr is
1992: select afpri.FLOW_APPLICATION_ID, afpri.FLOW_CODE,
1993: afpri.PAGE_APPLICATION_ID, afpri.PAGE_CODE,
1994: afpri.REGION_APPLICATION_ID, afpri.REGION_CODE
1995: from AK_FLOW_PAGE_REGION_ITEMS afpri, AK_REGIONS ar
1996: where ar.region_application_id = afpri.region_application_id
1997: and ar.region_code = afpri.region_code
1998: and ar.database_object_name = p_database_object_name
1999: and afpri.to_url_attribute_appl_id = p_attribute_application_id

Line 2902: from AK_REGIONS

2898: from AK_UNIQUE_KEYS
2899: where database_object_name = p_database_object_name;
2900: cursor l_get_regions_csr is
2901: select REGION_APPLICATION_ID, REGION_CODE
2902: from AK_REGIONS
2903: where database_object_name = p_database_object_name;
2904: l_api_version_number CONSTANT number := 1.0;
2905: l_api_name CONSTANT varchar2(30):= 'Delete_object';
2906: l_attribute_application_id NUMBER;

Line 2995: -- AK_REGIONS

2991: raise FND_API.G_EXC_ERROR;
2992: end if;
2993: close l_get_foreign_keys_csr;
2994: --
2995: -- AK_REGIONS
2996: --
2997: open l_get_regions_csr;
2998: fetch l_get_regions_csr into l_region_application_id, l_region_code;
2999: if l_get_regions_csr%found then

Line 3087: -- AK_REGIONS

3083: end if;
3084: end loop;
3085: close l_get_foreign_keys_csr;
3086: --
3087: -- AK_REGIONS
3088: --
3089: open l_get_regions_csr;
3090: loop
3091: fetch l_get_regions_csr into l_region_application_id, l_region_code;