Validation of Collection fields against existing data in Table
432643Apr 15 2009 — edited Apr 21 2009I am modifying the TIMESHEETS application to work for my organization.
The person who built this application and posted it to OTN did a great job and there are only a few tweeks we need to make.
Unfortunately these "tweaks" appear to be beyond my expertise at the moment.
The problem is that an employee is able to enter their time sheets multiple times for the same week if they want to.
We would like to validate any date/code combination and check to see if that code has already been entered for that date thus avoiding duplicates.
Now Collections are somewhat of a mystery to me! I am guessing that one can use the validations feature to write a pl/sql function that compares the values in the collection with what is already in the database table (EBA_TIME_TIMECODES)
Looking at the validations for if a field is null I see that the fields are named
htmldb_application.g_f02(i)
Has anyone done validations based on exiting data in tables and applied it to a collection?