Hi,
I have a form with multiple tabs. In when_tab_page_changed trigger I have following code :
IF some_condition and cur_tab = 'OPTIONS' THEN
create_parameter_duration_list;
END IF;
the code in procedure create_parameter_duration_list is as follows
PROCEDURE create_parameter_duration_list IS
BEGIN
if get_block_property('report_request',status) <> 'NEW' then
GO_BLOCK ('REPORT_REQUEST'); ---- Block is in TAB_1
FIRST_RECORD;
loop
do_something.....
IF :SYSTEM.LAST_RECORD = 'TRUE' THEN
EXIT;
ELSE
NEXT_RECORD;
END IF;
END LOOP;
end if;
END;
The problem I am facing is, If a user enters some value in the report_request block (TAB_1) and goes to 'OPTIONS' tab , the form works fine....but if the user goes back to the tab_1 and clears the value in report _request block and then goes to OPTIONS tab then I get the frm-40106 error (No navigable items in destination block)