DBA Data[Home] [Help]

APPS.AK_ATTRIBUTE_PVT dependencies on AK_FLOW_PAGE_REGION_ITEMS

Line 3144: from AK_FLOW_PAGE_REGION_ITEMS ri

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

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

3258: if ((p_data_type is not null) and (p_data_type <> FND_API.G_MISS_CHAR) and
3259: (p_data_type <> l_attributes_rec.data_type)) then
3260:
3261: if (l_attributes_rec.data_type = 'URL') then
3262: /* see if any 'To URL attribute' in ak_flow_page_region_items */
3263: /* are using this URL-type object attribute */
3264: open l_check_page_region_item_csr;
3265: fetch l_check_page_region_item_csr into l_dummy;
3266: if (l_check_page_region_item_csr%found) then