Your client loves what you have done for them.  But they would like you add the same functionality you did at Hands-On 12 to do it by using the main menu. 

You have been assigned to modify the main menu and add the “CALL FORM” function from Hands-On 12 to their window's main menu.

In this Hands-On, you will learn how to:  create or modify default main menu, use and assign global variable from one form to another, use global variable to execute query base on that parameter, create and use "WHEN-NEW-FORM-INSTANCE" trigger.

Save the Form name as version 13.

Change the application to invoke the “Product Price Data Entry” FORM from the application main menu.

Highlight the “Menu” item in the "object navigator” and -

open the predefined “Oracle default menu” from the Forms folder.

Open the default menu.

Save it as "cust_menu" in the “iself” folder.

Change the menu name to "Cust_menu.” And -

open its property palette. Notice that the name was changed. Then close the window.

Double click on the "cust_menu" icon.

Click on the "up arrow" icon to collapse each menu list item.

Just to make it easier to read.

Select the “Field” sub-menu, and then click on the "create right" icon.

Change "New Item" to "Data."

Click on the "create down" icon.

Change "new item" to "product price," then right click on it and open it's property palette.

Here, you could also change the name and other properties from here.

Close the window.

Right click on  it and open the "PL/SQL Editor."

Write a PL/SQL block to store the “product id” item into the “global product id” item.

Open the new version of the “Product Price Data Entry” Form from the iself folder.

Compile and close the window.

Delete the “Edit” sub-menu item.

Try to delete some other sub-menu items if not needed.

Close the menu editor.

Highlight "cust_menu," save the changes.

Then compile the menu.  The compile module is saved in the same folder of its source module.

Open the “Customer Orders” Form property palette to assign the new menu.

Type the new menu name.

Close the window and run the Form.

Notice that the main menu was changed.

The “Data” sub-menu was added.

Click on “Execute query.”

Navigate through the application Form.

Highlight a product id, then click on the "Product Data Entry” button.

Close the window.

Do the same by using the main menu option.

The results are the same.

Here, you can change, delete, insert a product price for a selected product.

Then, close the windows and save the changes.

Now, you should practice this over and over, until you become a master at it.

Good Luck!