Finding Hard Coded objects in DB and application features/ Select statements.

  Hi,

 

We use various Person Types in Oracle HR.

EC_Employee, EC_Student, Contractor and etc’.

Now we need to change one of the descriptions – ‘EC_Student’  to  ‘EC_Student_Employee’

But, we know that over the years, some of the scripts for Concurrent, Alerts, Views, Lookups, and any other application features and database features were hard coded with the Person Type description and not with the Person Type code.

It brings us to a situation in which, changing the Person Type description is very risky to the application proper usage and a potential disaster to the application numerous interfaces to other application.