Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change Menu Item Property

Eslam_ElbyalyAug 3 2016 — edited Aug 10 2016

hi ,

i am using forms Forms [32 Bit] Version 6.0.8.26.0 (Production) ,

i have a menu module which has menus and menu items which their names are stored in a table in the database ,

i want to set some menu items " Visible " and " Enabled " to " True " according to user's Privileges .

i am using this code in the " Start Up " code of the Menu Module

PROCEDURE pro_active_user_menu

BEGIN

FOR I IN

(SELECT PMF1.ENGLISH\_DESC MENU , PMF2.ENGLISH\_DESC MENU\_ITEM

FROM POS_MENU_FORM PMF1 , POS_MENU_FORM PMF2

WHERE PMF1.MENU_ID = PMF2.PERANT_ID

AND (pmf2.OBJECT_ID IN ( SELECT PADF.OBJECT_ID FROM pos_users pu , pos_al_details_form PADF

WHERE pu.access_id = padf.access_id

and pu.user_id = :global.user_id )

or pmf2.object_id is null))

LOOP

  SET\_MENU\_ITEM\_PROPERTY(I.MENU||'.'||I.MENU\_ITEM,VISIBLE,PROPERTY\_TRUE);

 SET\_MENU\_ITEM\_PROPERTY(I.MENU||'.'||I.MENU\_ITEM,ENABLED,PROPERTY\_TRUE);

END LOOP;

END;

it's working with all menus except " IT " Menu , it does not show up at all ,

- i've tried the select statement in sql developer and it retrieves " IT " menu and it's child menus .

so why the code does not work with it ?

any idea ?

- the " IT " Menu Properties