[Home] [Help]
6430: and aoa.lov_region_code is not null;
6431: cursor l_get_attr_lov_regions_csr (region_appl_id_param number,
6432: region_code_param varchar2) is
6433: select distinct aa.lov_region_application_id, aa.lov_region_code
6434: from AK_REGION_ITEMS ar, AK_ATTRIBUTES aa
6435: where ar.region_application_id = region_appl_id_param
6436: and ar.region_code = region_code_param
6437: and ar.object_attribute_flag = 'N'
6438: and ar.attribute_application_id = aa.attribute_application_id
7523: --
7524: -- If the object_attribute_flag is missing, pass the value in the
7525: -- database to the validate_item procedure. This is done such that
7526: -- the validate_item procedure can check the validity of attribute
7527: -- key fields against ak_attributes or ak_object_attributes.
7528: --
7529: if (p_object_attribute_flag = FND_API.G_MISS_CHAR) then
7530: l_object_attribute_flag := l_items_rec.object_attribute_flag;
7531: else