Journal TechnoLust's Journal: Where my PL/SQL thugs at? (or HELP!!!!) 10

Here's the rundown. I loop through a list of Open POs and grab their ids. I used a cursor and that's gravy. So now I grab all the PO Line Items (stored in a different table) for each PO and check to make sure they are all Paid or Cancelled. If they are, I close the PO and adjust the budget. Groovy. The problem is that for some reason, we have a plethora of POs with no line items. So my FOR loop is never entered on these and my BOOLEAN doesn't get set to false. So when it gets down to the next section it enters to IF block and performs a SELECT INTO which explodes because there's nothing SELECTed to put INTO the variable.

So I'm thinking I'm all slick, I created another variable and set it to 0 and incremented it on ever iteration of the FOR loop. then I tested to see if it was 0 and if so, set my BOOLEAN to FALSE. It still bombed with an ORA-01403: no data found error. Here is what I have so far: (Statuses is a cursor.)

V_our_rowcount := 0;
FOR Row1 IN Statuses (Row0.Document_id) LOOP
V_our_rowcount := V_our_rowcount + 1;

IF (Row1.Status IN ('Open', 'Ordered', 'Received', 'Invoiced') ) THEN
V_ready_to_close := FALSE;
END IF;
END LOOP;

IF (V_our_rowcount = 0) THEN
V_ready_to_close := FALSE;
DBMS_OUTPUT.Put_line ('No Rows, setting to False.');
END IF;

IF (V_ready_to_close = TRUE) THEN
--Do some cool stuff.
END IF;