APEX

In my application, I am providing way to add item information. when user clicks "Add" button, I am storing items into one temporary table along with app_user and session_id. user can add multiple items. at-least one item is required to add. validation for at-least one item is like this...

** Function returning boolean**
declare
l_count number;
begin
select count(*) into l_count from PO_ITEM_DETAILS where upper(user_name) = upper(:app_user) and session_id = :app_session;
if l_count = 0 then
return false;
else
return true;
end if;
end;

PO_ITEM_DETAILS is a temp table. while submitting request I am inserting value by using cursor, like this...

cursor temp_items
is
select *
from po_item_details
where upper (user_name) = upper (:app_user) and session_id = :app_session;

Application was working fine since last 8 months. 2 days back, customer complained that items info is missing for one request. I am not able to rectify what is the problem. because all the other code in process with temp insert was executed successfully. From primary key sequence of temp table, I cam to know that cursor "for loop" has not been executed. But Why??

Any help is appreciated.

Thanks.