45: FUNCTION get_service_name (
46: p_services_rec IN services_all_rec_type
47: ) RETURN VARCHAR2 IS
48: CURSOR get_service_name_cur (
49: p_cp_service_id IN MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE) IS
50: SELECT concatenated_segments
51: FROM mtl_system_items_kfv
52: WHERE inventory_item_id = p_cp_service_id
53: AND organization_id = FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID');
47: ) RETURN VARCHAR2 IS
48: CURSOR get_service_name_cur (
49: p_cp_service_id IN MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE) IS
50: SELECT concatenated_segments
51: FROM mtl_system_items_kfv
52: WHERE inventory_item_id = p_cp_service_id
53: AND organization_id = FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID');
54:
55: l_retval get_service_name_cur%ROWTYPE;