Multiple collections on one page - interference?
510477Jun 26 2008 — edited Jun 27 2008I thought I had this figured out, but my debug page (a bunch of report regions that show the various collection contents) tells me I have a problem.
I am trying to create a timecard entry system. There are different types of work, so I have separated the entry into 5 sections - a master and 4 detail sections. Each detail section is a collection named either TC_LOAD_DTL, TC_HRLY_DTL, TC_OTHR_DTL, or TC_MILE_DTL. Each gathers different kinds of data to be processed and recorded into 7 different tables. (TC_OTHR_DTL is a miscellanous group where I filter and store based on business rules into 4 other tables).
I can prepopulate the collections simply enough using an After Header process. Writing the information to the database is also straightforward. It is the update portion that is defeating me. I have a separate Page Process for each collection that fires After Submit (for development). Each handles it's own region and updates the various collections based on user input. It isn't (or shouldn't be) complicated at this point because all I'm doing is writing the input into the appropriate column in the collection. But somehow I keep getting only the first collection to properly update. The other processes seem to be bleeding across.
Here is a sample:
http://apex.oracle.com/pls/otn/f?p=52742:1:2479505591204321::NO:::
I know there is probably something simple I am missing, but I would appreciate the gaze of another set of eyes, as three days hasn't revealed it yet to me.
Thanks in advance,
Blair