The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 1
from AK_FLOW_PAGES
where flow_application_id = p_flow_application_id
and flow_code = p_flow_code;
p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
l_error := TRUE;
p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
l_error := TRUE;
p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
l_error := TRUE;
select 1
from AK_FLOW_PAGE_REGIONS
where flow_application_id = p_flow_application_id
and flow_code = p_flow_code
and page_application_id = p_page_application_id
and page_code = p_page_code;
p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
l_error := TRUE;
p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
l_error := TRUE;
p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
l_error := TRUE;
select 1
from AK_FLOW_PAGE_REGIONS
where flow_application_id = p_flow_application_id
and flow_code = p_flow_code
and page_application_id = p_page_application_id
and page_code = p_page_code
and display_sequence = p_display_sequence
and ( (region_application_id <> p_region_application_id) or
(region_code <> p_region_code) );
select primary_region_appl_id, primary_region_code
from AK_FLOW_PAGES
where flow_application_id = p_flow_application_id
and flow_code = p_flow_code
and page_application_id = p_page_application_id
and page_code = p_page_code;
(p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
l_error := TRUE;
select 1
from AK_ATTRIBUTES
where attribute_application_id = p_to_url_attribute_appl_id
and attribute_code = p_to_url_attribute_code
and upper(data_type) = 'URL';
select 1
from AK_FLOW_REGION_RELATIONS
where flow_application_id = p_flow_application_id
and flow_code = p_flow_code
and from_page_appl_id = p_page_application_id
and from_page_code = p_page_code
and from_region_appl_id = p_region_application_id
and from_region_code = p_region_code
and to_page_appl_id = p_to_page_appl_id
and to_page_code = p_to_page_code;
FND_MESSAGE.SET_NAME('AK','AK_NO_LINK_SELECTED');
FND_MESSAGE.SET_NAME('AK','AK_TWO_LINK_SELECTED');
select 1
from ak_foreign_keys fk, ak_unique_keys uk,
ak_regions ar1, ak_regions ar2
where fk.database_object_name = ar1.database_object_name
and fk.unique_key_name = uk.unique_key_name
and uk.database_object_name = ar2.database_object_name
and ar1.region_application_id = p_from_region_appl_id
and ar1.region_code = p_from_region_code
and ar2.region_application_id = p_to_region_appl_id
and ar2.region_code = p_to_region_code
and fk.foreign_key_name = p_foreign_key_name
UNION
select 1
from ak_foreign_keys fk, ak_unique_keys uk,
ak_regions ar1, ak_regions ar2
where fk.database_object_name = ar2.database_object_name
and fk.unique_key_name = uk.unique_key_name
and uk.database_object_name = ar1.database_object_name
and ar1.region_application_id = p_from_region_appl_id
and ar1.region_code = p_from_region_code
and ar2.region_application_id = p_to_region_appl_id
and ar2.region_code = p_to_region_code
and fk.foreign_key_name = p_foreign_key_name;
(p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
l_error := TRUE;