APEX

I'm running Apex 4.0.2. Here is the scenarion.

I have an item (P23_PARENT_APPROVER_ID) which I set using "SetValue" action (SQL Statement) and then the "Execute PLSQL Code" action executes to send the affected item to the server. The second action really does nothing (begin NULL; end;). I just use it to get the item session state set. When I run the page I check the session states of the items and all looks perfect.

I have another dynamic action which displays the confirm dialog. This is to warn the users in case the item was not set to any value (possible as per my requirement). To accomplish this I added the condition to my "confirm" action which checks if the value of an item is NULL. The condition is based on PLSQL and it looks like this:
BEGIN
IF *:P23_PARENT_APPROVER_ID* IS NULL THEN
IF :P23_APPROVAL_TYPE IN ('M','S') THEN
RETURN FALSE;
ELSE
RETURN TRUE;
END IF;
ELSE
RETURN FALSE;
END IF;
END;

The P23_PARENT_APPROVER_ID item is the item set by my dynamic action. When the "confirm" condition is evaluated it does not see the value of the item and it always returns NULL. Again the item session is set and I can see it via session page.

Any idea what is happening and how to solve it?

Edited by: Tomek on May 6, 2011 7:22 AM

Edited by: Tomek on May 6, 2011 8:39 AM