[rockprofiler-sdk] Extend the hack to propagate HIP usage requirements a bit further

[marbre]

Summary

• Also fetches usage requirements from hip::amdhip64 -> rocprofiler-sdk-hip-nolink
• Adds rocprofiler-sdk-hip-nolink as a dependency of two libraries that indirectly depend on hip headers via hip.h.
• The above may not be completely as precise as it can be (it seems like there should be an intermediate library for this of some kind).
• Also conditions the link of hsa-amd-aqlprofile64_library on whether the library was found, which however might not be correct.

Link to patch

https://github.com/ROCm/TheRock/blob/main/patches/amd-mainline/rocprofiler-sdk/0001-Extend-the-hack-to-propagate-HIP-usage-requirements-.patch

Permalink to patch

https://github.com/ROCm/TheRock/blob/1af5e45b566e11924bb343018be93d870acdaf4a/patches/amd-mainline/rocprofiler-sdk/0001-Extend-the-hack-to-propagate-HIP-usage-requirements-.patch