Handling Tab Pages in Oracle Forms

Handle tab pages in Oracle forms at runtime with When-Tab-Page-Changed trigger at Form Level. This trigger Fires whenever there is explicit item or mouse navigation from one tab page to another in a tab canvas.

Usage Notes
·  Use a When-Tab-Page-Changed trigger to perform actions when any tab page is changed during
item or mouse navigation.
·  When-Tab-Page-Changed fires only when tab page navigation is explicit; it does not respond to
implicit navigation. For example, the trigger will fire when the mouse or keyboard is used to
navigate between tab pages, but the trigger will not fire if an end user presses [Next Item] (Tab) to
navigate from one field to another field in the same block, but on different tab pages.
·  When-Tab-Page-Changed does not fire when the tab page is changed programmatically.

When-Tab-Page-Changed examples
Use a When-Tab-Page-Changed trigger to dynamically change a tab page’s label from lower- to upper-case (to indicate to end users if they already have navigated to the tab page)

DECLARE
tp_nm VARCHAR2(30);
tp_id TAB_PAGE;
tp_lb VARCHAR2(30);
BEGIN
tp_nm := GET_CANVAS_PROPERTY(’emp_cvs’, topmost_tab_page);
tp_id := FIND_TAB_PAGE(tp_nm);
tp_lb := GET_TAB_PAGE_PROPERTY(tp_id, label);
IF tp_lb LIKE ’Sa%’ THEN
SET_TAB_PAGE_PROPERTY(tp_id, label, ’SALARY’);
ELSIF tp_lb LIKE ’Va%’ THEN
SET_TAB_PAGE_PROPERTY(tp_id, label, ’VACATION’);
ELSE null;
END IF;
END;