DBA Data[Home] [Help]

APPS.AK_ATTRIBUTE_PVT dependencies on AK_FLOW_PAGE_REGION_ITEMS

Line 3140: from AK_FLOW_PAGE_REGION_ITEMS ri

3136: where ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
3137: and ATTRIBUTE_CODE = p_attribute_code;
3138: cursor l_check_page_region_item_csr is
3139: select 1
3140: from AK_FLOW_PAGE_REGION_ITEMS ri
3141: where ri.to_url_attribute_appl_id = p_attribute_application_id
3142: and ri.to_url_attribute_code = p_attribute_code;
3143: l_api_version_number CONSTANT number := 1.0;
3144: l_api_name CONSTANT varchar2(30) := 'Update_Attribute';

Line 3255: /* see if any 'To URL attribute' in ak_flow_page_region_items */

3251: if ((p_data_type is not null) and (p_data_type <> FND_API.G_MISS_CHAR) and
3252: (p_data_type <> l_attributes_rec.data_type)) then
3253:
3254: if (l_attributes_rec.data_type = 'URL') then
3255: /* see if any 'To URL attribute' in ak_flow_page_region_items */
3256: /* are using this URL-type object attribute */
3257: open l_check_page_region_item_csr;
3258: fetch l_check_page_region_item_csr into l_dummy;
3259: if (l_check_page_region_item_csr%found) then