APPS.AK_OBJECT_PVT dependencies on AK_REGION_ITEMS

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 2097: -- AK_REGION_ITEMS

2093: raise FND_API.G_EXC_ERROR;
2094: end if;
2095: close l_get_attr_values_csr;
2096: --
2097: -- AK_REGION_ITEMS
2098: --
2099: open l_get_region_item_csr;
2100: fetch l_get_region_item_csr into l_region_application_id, l_region_code;
2101: if l_get_region_item_csr%found then

Line 2122: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_REGION_ITEMS',TRUE);

2118: close l_get_page_region_item_csr;
2119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2120: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_PREGIM');
2121: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);
2122: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_REGION_ITEMS',TRUE);
2123: FND_MSG_PUB.Add;
2124: end if;
2125: raise FND_API.G_EXC_ERROR;
2126: end if;

Line 2199: -- AK_REGION_ITEMS

2195: end if;
2196: end loop;
2197: close l_get_attr_values_csr;
2198: --
2199: -- AK_REGION_ITEMS
2200: --
2201: open l_get_region_item_csr;
2202: loop
2203: fetch l_get_region_item_csr into l_region_application_id, l_region_code;