APPS.AK_REGION_PVT dependencies on AK_OBJECT_ATTRIBUTE_NAVIGATION

Line 6054: from AK_OBJECT_ATTRIBUTE_NAVIGATION

6050: and region_code = p_region_code;
6051: cursor l_get_navigations_csr is
6052: select DATABASE_OBJECT_NAME, ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE,
6053: VALUE_VARCHAR2, VALUE_DATE, VALUE_NUMBER
6054: from AK_OBJECT_ATTRIBUTE_NAVIGATION
6055: where to_region_appl_id = p_region_application_id
6056: and to_region_code = p_region_code;
6057: l_api_version_number CONSTANT number := 1.0;
6058: l_api_name CONSTANT varchar2(30):= 'Delete_Region';

Line 6161: -- AK_OBJECT_ATTRIBUTE_NAVIGATION

6157: raise FND_API.G_EXC_ERROR;
6158: end if;
6159: close l_get_page_region_csr;
6160: --
6161: -- AK_OBJECT_ATTRIBUTE_NAVIGATION
6162: --
6163: open l_get_navigations_csr;
6164: fetch l_get_navigations_csr into l_database_object_name,
6165: l_attribute_application_id, l_attribute_code,

Line 6235: -- AK_OBJECT_ATTRIBUTE_NAVIGATION

6231: -- end if;
6232: -- end loop;
6233: -- close l_get_page_region_csr;
6234: --
6235: -- AK_OBJECT_ATTRIBUTE_NAVIGATION
6236: --
6237: -- open l_get_navigations_csr;
6238: -- loop
6239: -- fetch l_get_navigations_csr into l_database_object_name,

Line 6404: from AK_OBJECT_ATTRIBUTE_NAVIGATION aoan, AK_REGIONS ar

6400: and object_attribute_flag = 'N';
6401: cursor l_get_target_regions_csr (region_appl_id_param number,
6402: region_code_param varchar2) is
6403: select distinct to_region_appl_id, to_region_code
6404: from AK_OBJECT_ATTRIBUTE_NAVIGATION aoan, AK_REGIONS ar
6405: where ar.region_application_id = region_appl_id_param
6406: and ar.region_code = region_code_param
6407: and aoan.database_object_name = ar.database_object_name;
6408: cursor l_get_database_object_name_csr (region_appl_id_param number,