APPS.AK_REGION_PVT dependencies on AK_OBJECT_ATTRIBUTE_NAVIGATION

Line 6065: from AK_OBJECT_ATTRIBUTE_NAVIGATION

6061: and region_code = p_region_code;
6062: cursor l_get_navigations_csr is
6063: select DATABASE_OBJECT_NAME, ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE,
6064: VALUE_VARCHAR2, VALUE_DATE, VALUE_NUMBER
6065: from AK_OBJECT_ATTRIBUTE_NAVIGATION
6066: where to_region_appl_id = p_region_application_id
6067: and to_region_code = p_region_code;
6068: l_api_version_number CONSTANT number := 1.0;
6069: l_api_name CONSTANT varchar2(30):= 'Delete_Region';

Line 6172: -- AK_OBJECT_ATTRIBUTE_NAVIGATION

6168: raise FND_API.G_EXC_ERROR;
6169: end if;
6170: close l_get_page_region_csr;
6171: --
6172: -- AK_OBJECT_ATTRIBUTE_NAVIGATION
6173: --
6174: open l_get_navigations_csr;
6175: fetch l_get_navigations_csr into l_database_object_name,
6176: l_attribute_application_id, l_attribute_code,

Line 6246: -- AK_OBJECT_ATTRIBUTE_NAVIGATION

6242: -- end if;
6243: -- end loop;
6244: -- close l_get_page_region_csr;
6245: --
6246: -- AK_OBJECT_ATTRIBUTE_NAVIGATION
6247: --
6248: -- open l_get_navigations_csr;
6249: -- loop
6250: -- fetch l_get_navigations_csr into l_database_object_name,

Line 6415: from AK_OBJECT_ATTRIBUTE_NAVIGATION aoan, AK_REGIONS ar

6411: and object_attribute_flag = 'N';
6412: cursor l_get_target_regions_csr (region_appl_id_param number,
6413: region_code_param varchar2) is
6414: select distinct to_region_appl_id, to_region_code
6415: from AK_OBJECT_ATTRIBUTE_NAVIGATION aoan, AK_REGIONS ar
6416: where ar.region_application_id = region_appl_id_param
6417: and ar.region_code = region_code_param
6418: and aoan.database_object_name = ar.database_object_name;
6419: cursor l_get_database_object_name_csr (region_appl_id_param number,