^ That is FRIGGIN BRILLIANT, thanks for pointing out using it like that.
Yep .. dependencies can have unsatisfied dependencies, overall this is lovingly referred to as dependency hell. One sure-fire way to ascertain whether everything required is satisfied is installing them(crapton of deb's)locally with apt, have used dpkg for doing this type of thing ... For installing whatever pkgs to offline OS's. Though keep seeing people mention apt is better able to handle this, does a better job and should be used instead. Either one will make it obvious if something is missing, what the something(s) is/are etc.
Some good commands to know while playing around with this type of thing, if you get the opportunity to put an offline system on the internet briefly, "sudo apt install -f" and-or "sudo dpkg --configure -a". For helping to resolve package nightmares. More random thoughts a good precaution can be setting up and doing this type of thing on a VM if possible or a bare-metal clone to use for crash testing etc. Rather than the install you care about. Setting such up takes very little time, same for tearing them down or restoring them too.
For that matter depending on what you have in mind, if you've got access to an online system but want to maintain an install on another which doesn't have internet access. Could perhaps set up a clone of the offline OS on a pc with internet(upgrade it normally) and use rsync to transfer changes/upgrades to the system without. Even turn it(clone)into a portable Os, anywhere you can plug the thumb drive into and boot on a pc that has internet, you can upgrade, install whatever to it and rsync the changes onto an offline os.
Are also of course utils specifically for this type of thing, though when isn't there in gnu/Linux ?
One which comes to mind is apt-offline (google it) are others but off the top don't remember them. Such searches are bound to bring up much offline upgrading information for you to consider. Been here done some of this, forgot most of it.
Ps, The big daddy of em all, mirroring entire Debian software repo's onto a portable usb drive. Dont remember how much drive space is involved but it's not as much diskspace as one might think. Then you have the ultimate offline, portable repository a person could ever want.
Install anything desired locally, gnu/linux is fairly amazing. If x-user can imagine it, some geek(s) probably already came out with tools and doc's on how to do it.