SQL & PL/SQL

Please let me know if we have a better strategy to code for below requirement.

1. We have an automation requirement to validate data from a file with respect to the data from database tables
2. We have a package where first the text file is exported into a table with 100 columns
3. Now this 100 columns need to be validated with respect to the data from various tables in the oracle database
4. We have written a query to pull all required fields
5. Some of the data from query need to be decoded to match with the codes in the file data exported into the table
6. Now we have statements in the procedure to validate each column between the file data and query data
7. Due to this each column level validation the proc is bulky and difficult to maintain

I believe there should be more much efficient way to handle this validation. Can the experts help?