Unfortunately, I am talking about using SYSDATE in 111 packages for 1800 times. It's not possible to change those packages for testing alone. Both the UAT and Production environments have the same Code. So, the only alternative is to stall the SYSDATE without affecting the Database date, because there are other systems with different front ends working on other schemas. When I do "Alter SYSTEM SET FIXED_DATE=...", those systems are not expected to show the SYSDATE what I set. New package/function is an not an alternative in my case. I need SYSDATE function override.
Thanks for your response.
Ravi