title: Oracle APEX - Selecting next row to insert into using a process on form submit
body: <p>Ok. I have a situation where I have two companies, COMPANY1 and COMPANY2, which work in tandem to create a PART. Since they worked together they both have ownership and therefore want to both assign a PART_NUMBER to the same part. COMPANY1 provides COMPANY2 a block of PART_NUMBERS to assign to the parts they create.</p>
  
  <p>I have a table (TABLE_PARTS) which contains the primary key (COMPANY1_PART_NUMBER). Since COMPANY1 provided COMPANY2 with a block of numbers the table has been populated with just these numbers and awaits assignment to an actual part.</p>
  
  <p>I have an input form that is to be used by COMPANY2 to plug in the part information, including the COMPANY2_PART_NUMBER. I need to updated the rows in TABLE_PARTS to fill out the rest of the columns around the pk, COMPANY1_PART_NUMBER, thus assigning that number to a part. </p>
  
  <p>I have determined that I need to SELECT the MIN(COMPANY1_PART_NUMBER) where COMPANY2_PART_NUMBER is null and update that row with the part information.</p>
  
  <p>I need to determine which row will be updated with a process after the form has been submitted because there will be concurrent users for the form and to select a row when the page loads would certainly cause people to accidentally attempt to insert into the same COMPANY1_PART_NUMBER row.</p>
  
  <p>Any thoughts? I am sure it is not difficult but I am having issues, lol. Thanks!</p>