DBA Data[Home] [Help]

APPS.AK_ATTRIBUTE_PVT dependencies on AK_REGION_ITEMS

Line 1136: from AK_REGION_ITEMS

1132: where ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
1133: and ATTRIBUTE_CODE = p_attribute_code;
1134: cursor l_get_region_item_csr is
1135: select REGION_APPLICATION_ID, REGION_CODE
1136: from AK_REGION_ITEMS
1137: where ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
1138: and ATTRIBUTE_CODE = p_attribute_code
1139: and OBJECT_ATTRIBUTE_FLAG = 'N';
1140: l_api_version_number CONSTANT number := 1.0;

Line 1200: -- AK_REGION_ITEMS

1196: raise FND_API.G_EXC_ERROR;
1197: end if;
1198: close l_get_obj_attr_csr;
1199: --
1200: -- AK_REGION_ITEMS
1201: --
1202: open l_get_region_item_csr;
1203: fetch l_get_region_item_csr into l_region_application_id, l_region_code;
1204: if l_get_region_item_csr%found then

Line 1243: -- AK_REGION_ITEMS

1239: end if;
1240: end loop;
1241: close l_get_obj_attr_csr;
1242: --
1243: -- AK_REGION_ITEMS
1244: --
1245: open l_get_region_item_csr;
1246: loop
1247: fetch l_get_region_item_csr into l_region_application_id, l_region_code;