Are there any PROMs (one time programmable) that get activated
when the power is on and without th help of any microcontrollers
the data stored on the PROM is readout.
It's needed to pass a predefined sequence to a device.
Are there such Altera PROMs, what is the name of such a PROM?
All proms (one time programmable and multi read) are all 'activated' when power is applied. Whether or not the data inside is read from (i.e. transferred to another device) is another matter.
To my knowledge all PROMs regardless of type do not transmitt data unless requested to do so.