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 1991: from AK_REGION_ITEMS ari, AK_REGIONS ar

1987: and attribute_application_id = p_attribute_application_id
1988: and attribute_code = p_attribute_code;
1989: cursor l_get_region_item_csr is
1990: select ari.REGION_APPLICATION_ID, ari.REGION_CODE
1991: from AK_REGION_ITEMS ari, AK_REGIONS ar
1992: where ar.database_object_name = p_database_object_name
1993: and ar.region_application_id = ari.region_application_id
1994: and ar.region_code = ari.region_code
1995: and ari.attribute_application_id = p_attribute_application_id

Line 2002: from AK_FLOW_PAGE_REGION_ITEMS afpri, AK_REGIONS ar

1998: cursor l_get_page_region_item_csr is
1999: select afpri.FLOW_APPLICATION_ID, afpri.FLOW_CODE,
2000: afpri.PAGE_APPLICATION_ID, afpri.PAGE_CODE,
2001: afpri.REGION_APPLICATION_ID, afpri.REGION_CODE
2002: from AK_FLOW_PAGE_REGION_ITEMS afpri, AK_REGIONS ar
2003: where ar.region_application_id = afpri.region_application_id
2004: and ar.region_code = afpri.region_code
2005: and ar.database_object_name = p_database_object_name
2006: and afpri.to_url_attribute_appl_id = p_attribute_application_id

Line 2909: from AK_REGIONS

2905: from AK_UNIQUE_KEYS
2906: where database_object_name = p_database_object_name;
2907: cursor l_get_regions_csr is
2908: select REGION_APPLICATION_ID, REGION_CODE
2909: from AK_REGIONS
2910: where database_object_name = p_database_object_name;
2911: l_api_version_number CONSTANT number := 1.0;
2912: l_api_name CONSTANT varchar2(30):= 'Delete_object';
2913: l_attribute_application_id NUMBER;

Line 3002: -- AK_REGIONS

2998: raise FND_API.G_EXC_ERROR;
2999: end if;
3000: close l_get_foreign_keys_csr;
3001: --
3002: -- AK_REGIONS
3003: --
3004: open l_get_regions_csr;
3005: fetch l_get_regions_csr into l_region_application_id, l_region_code;
3006: if l_get_regions_csr%found then

Line 3094: -- AK_REGIONS

3090: end if;
3091: end loop;
3092: close l_get_foreign_keys_csr;
3093: --
3094: -- AK_REGIONS
3095: --
3096: open l_get_regions_csr;
3097: loop
3098: fetch l_get_regions_csr into l_region_application_id, l_region_code;