EBS : WHEN-TAB-PAGE-CHANGED change code in oracle forms in Oracle Apps (r12)

Oracle Forms Code for TAB WHEN-TAB-PAGE-CHANGED

DECLARE

   v_tp_nm   VARCHAR2 (30);

   v_tp_id   tab_page;

   v_tp_lb   VARCHAR2 (30);

BEGIN

   v_tp_nm := GET_CANVAS_PROPERTY ('TECHHARDS_TABS', topmost_tab_page);---TECHHARDS_TABS is your tab canvas

   v_tp_id := FIND_TAB_PAGE (v_tp_nm);   --this is tab page which you just had clicked to activate

   v_tp_lb := GET_TAB_PAGE_PROPERTY (v_tp_id, label);

                        --you get the lable for that particular tab page here

--here is to check the page name and associate your auto-query options--

   IF v_tp_lb LIKE 'TechHards WB%'

   THEN

      GO_BLOCK ('XX_TECHHARDS_KAB');

      EXECUTE_QUERY (no_validate);

   ELSIF v_tp_lb LIKE 'TechHards WB Pro%'

   THEN

      GO_BLOCK ('XX_TECHHARDS_PAB');

      EXECUTE_QUERY (no_validate);

   ELSIF v_tp_lb LIKE 'TechHards WB Free%'

   THEN

      GO_BLOCK ('XX_TECHHARDS_DAB');

      EXECUTE_QUERY (no_validate);

   ELSE

      NULL;

   END IF;

END;

=========================================================================

#Oracle Forms #Oracle Apps #EBS #Forms Trigger #WHEN-TAB-PAGE-CHANGED