OraFAQ Forum: Forms » DYNAMIC MENUS BASED ON ROLE_ID & corresponding MENUS information stored in DB (merged 6)

Home » Developer & Programmer » Forms » DYNAMIC MENUS BASED ON ROLE_ID & corresponding MENUS information stored in DB (merged 6) (Forms 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DYNAMIC MENUS BASED ON ROLE_ID & corresponding MENUS information stored in DB (merged 6) [message #492889]

Thu, 03 February 2011 07:24

imvip0101
Messages: 3
Registered: February 2011
Location: India

Junior Member

Is it possible to create menus dynamically based on roles & corresponding menus information stored in database in FORMS 10g

i am working on a project & our TL wants that if any menu item is deleted from DB then corresponding MENU should be deleted from form automatically

i have attached DB tables for making my problem a bit more clear.

pls help...
Sad

Attachment: DYNAMIC_MENU_DATABASE_DD.txt
(Size: 0.94KB, Downloaded 1214 times)

Report message to a moderator

Re: DYNAMIC MENUS BASED ON ROLE_ID & corresponding MENUS information stored in DB (merged 6) [message #492987 is a reply to message #492889]

Fri, 04 February 2011 01:39

athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan

Senior Member

use set_menu_item_property to show hide menus based on database values.

Report message to a moderator

Re: DYNAMIC MENUS BASED ON ROLE_ID & corresponding MENUS information stored in DB (merged 6) [message #493222 is a reply to message #492987]

Sun, 06 February 2011 20:57

imvip0101
Messages: 3
Registered: February 2011
Location: India

Junior Member

for this i have to make a master menu module where i vl have to place all the possible menus (related to all the roles) on that particular module & then only i think i can make them show or hide according to requirement.

bt what if i add new menus in the database...?? i vl have to add new menu to master menu module & then recompile it...???

so this solution becomes faulty.... dear.. pls suggest a bit more flexible situation Sad

Report message to a moderator

Re: DYNAMIC MENUS BASED ON ROLE_ID & corresponding MENUS information stored in DB (merged 6) [message #493232 is a reply to message #493222]

Sun, 06 February 2011 23:46

athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan

Senior Member

Currently what kind of menus are u using. i don't think that there is something like dynamic menus.

You have to create menus then show or hide them according to user logged in.

Report message to a moderator

Re: DYNAMIC MENUS BASED ON ROLE_ID & corresponding MENUS information stored in DB (merged 6) [message #493805 is a reply to message #493232]

Thu, 10 February 2011 00:59

imvip0101
Messages: 3
Registered: February 2011
Location: India

Junior Member

v r using menus for a financial application

i have created menu module using set_menu_item_property
now i have to develop a screen for "create menu" & "create role"
so that ADMIN may create menu & roles for automation of this system....

what should i do now? pls help....

Report message to a moderator

Re: DYNAMIC MENUS BASED ON ROLE_ID & corresponding MENUS information stored in DB (merged 6) [message #495930 is a reply to message #493805]

Wed, 23 February 2011 05:45

tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka

Senior Member

Dear imvip0101,

You can create a menu with Hierarchical tree item. So that you can dynamically populate a tree menu for a specific USER. You have to stored all forms & reports name in a table with user id or as your convenient. It should be 100% dynamic. Thanks.

Regards,
Tamzidul Amin.

Report message to a moderator

Previous Topic:	dynamic record group for LOV (merged)
Next Topic:	Calendar.pll and Standard.pll (merged 4)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 01:10:28 CST 2025