oracle forms: menu
TRANSCRIPT
![Page 1: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/1.jpg)
Creating and Managing Menu Modules
http://ebiztechnics.blogspot.com
![Page 2: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/2.jpg)
Objectives
• Identify Menu components• Create, save and attach Menu modules• Modifying properties of Menu items• Creating Popup menu and attaching• Controlling Menus Programmatically• Manage Menu Security
http://ebiztechnics.blogspot.com
![Page 3: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/3.jpg)
Menu Module Components
MainMenu
IndividualMenu
MenuToolbar
MenuItem
http://ebiztechnics.blogspot.com
![Page 4: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/4.jpg)
Default Menu
Action
SaveClear AllPrintPrint SetupExit
Edit
CutCopyPasteEditDisplay List
Block
PreviousNextClear
Field
PreviousNextClearDuplicate
Record
PreviousNextScroll UpScroll DownInsertRemoveLockDuplicate Clear
Query
EnterExecuteCancelLast CriteriaCount HitsFetch Next Set
Help
HelpKeysListDisplay ErrorDebug
http://ebiztechnics.blogspot.com
![Page 5: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/5.jpg)
Menu EditorDisplaymenu
Create Down Create
Right
SwitchOrientation
Menu tabExpanded
menu Collapsedmenu
http://ebiztechnics.blogspot.com
![Page 6: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/6.jpg)
Creating a Menu Module
ObjectNavigator
Menu Editor
Select Tools Menu Editor
http://ebiztechnics.blogspot.com
![Page 7: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/7.jpg)
Menu Module Properties
Main MenuMenu DirectoryMenu FilenameStartup CodeShare Library with Form
Use SecurityModule Roles
http://ebiztechnics.blogspot.com
![Page 8: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/8.jpg)
Menu Item Properties
• Enabled• Label• Menu Item Type• Magic Item• Menu Item Radio
Group • Command Type
• Menu Item Code• Submenu Name• Icon in Menu• Icon Filename
http://ebiztechnics.blogspot.com
![Page 9: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/9.jpg)
Menu Item Types
Separator
Plain
CheckMagic
Radio
http://ebiztechnics.blogspot.com
![Page 10: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/10.jpg)
Magic Items
• About• Undo• Clear• Copy• Cut
• Paste• Help• Quit• Window
http://ebiztechnics.blogspot.com
![Page 11: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/11.jpg)
Menu Item Command Types
Null
Menu
PL/SQL
Plus
Form
Macro
Does not issue a command
Invokes a submenu
Executes a PL/SQL command
Spawns a process to SQL*Plus
Backward compatibility
Backward compatibility
http://ebiztechnics.blogspot.com
![Page 12: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/12.jpg)
Menu Module File Types
Menu module definition: • .mmb (Menu Module Binary)• Stored in files or database tablesMenu module executable:• .mmx (Menu Module Executable) • Stored in filesMenu module text:• .mmt (Menu Module Text)• Stored in files
http://ebiztechnics.blogspot.com
![Page 13: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/13.jpg)
Attaching Menu Module
• Open Form Module PropertyPallet.
• Modify Menu Module Property.• Specify the name of your menu
module.
http://ebiztechnics.blogspot.com
![Page 14: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/14.jpg)
Pop-up Menus
Menu that appears on the screen at thelocation it was invoked• Enables users to
access commonly used functions easily
• Is accessed by pressing the right mouse button (Microsoft Windows and Motif)
http://ebiztechnics.blogspot.com
![Page 15: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/15.jpg)
Using Pop-up Menus
• Pop-up menus are:– Form module objects in the object navigator,
such as alerts or Data Blocks – Built through the Property Palette or
Menu Editor– Associated with items and canvases
with a pop-up menu property
• Pre-Popup-Menu trigger providesdynamic control
http://ebiztechnics.blogspot.com
![Page 16: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/16.jpg)
Writing PL/SQL Code in Menu Triggers
• Similar to PL/SQL code in form triggers• You can share code between a form
module and a menu module by using the following:– Libraries– User-defined triggers– DO_KEY built-in
http://ebiztechnics.blogspot.com
![Page 17: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/17.jpg)
Writing PL/SQL Code in Menu Triggers
• Menu modules generated independently• Restrictions:
– Cannot directly reference values of form objects
– Must use NAME_IN built-in function– Cannot use direct assignment for
form objects– Must use COPY built-in procedure
http://ebiztechnics.blogspot.com
![Page 18: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/18.jpg)
Built-ins Used
• FIND_MENU_ITEM• GET_MENU_ITEM_PROPERTY• SET_MENU_ITEM_PROPERTY• ITEM_ENABLED• MENU_SHOW_KEYS
http://ebiztechnics.blogspot.com
![Page 19: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/19.jpg)
Built-ins Showing and Hiding
REPLACE_MENUCharacter mode built-ins:• HIDE_MENU• SHOW_MENU• MENU_REDISPLAY
http://ebiztechnics.blogspot.com
![Page 20: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/20.jpg)
Managing Menu Security
• Defining security roles• Choosing roles for the menu module• Assigning access to menu items• Setting the Use Security property
http://ebiztechnics.blogspot.com
![Page 21: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/21.jpg)
Roles
Role
Privileges
Users
http://ebiztechnics.blogspot.com
![Page 22: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/22.jpg)
Menu Module Roles
• Select Menu Module Roles Property from the menu Module properties.• Enter Database Role Names.• Use Security Property Set to Yes.
http://ebiztechnics.blogspot.com
![Page 23: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/23.jpg)
Menu Item Roles
• Invoke Property pallet of a Menu item.• Choose Menu Item roles property.• Select Menu Item roles.• Press OK button.
http://ebiztechnics.blogspot.com
![Page 24: Oracle Forms: Menu](https://reader033.vdocuments.us/reader033/viewer/2022061513/589ca3c21a28abf4148b655b/html5/thumbnails/24.jpg)
Summary
• Creating Menu Modules• Attaching Menu Modules to Forms• Popup menu items• Pre-Popup menu trigger.• Built-ins for Managing Menu items programmatically.• Menu Module security with Roles.
http://ebiztechnics.blogspot.com