APEX

Hi.

I am having some troubles using interactive report. The problem lies in view which serves as a source to data in that interactive report. The view has some where clause that references previously set package global variable. The first time the page is rendered the query works ok. This is because I have created "On Load - Before Header" process that sets those global variables in database package. The problem is when I just hit interactive report "Go" button the "No data found" is raised. I have nailed down the problem to the point I know that after hitting "Go" button the apex uses a new database connection and logically there the value in database package global variables are NULL. My first idea was to change the "Process Point" (so the process would fire whenever "Go" button is pressed) but I could not find the corresponding point.

So my question is if there is a way to overcome this problem.

Best regards