You can make a custom call from a custom menu. This can be a web call or a PL/SQL call.
First, setup the custom menu. Goto ‘Modules Administration Forms’, search for the form and click on it. Click Custom menus to the side and add a menu.
Set the menu title, and add a submenu line. The type should be CUSTOM and the Action should be a unique value. The title will show up under Submenu Title.
Next, you need to add your code to the srpi.pll module. You will need to download and install Forms 10g from Oracle (now called Developer Suite 10g).
Copy srpi.pll from the applications server. It should be in d:\synergen\INSTANCE\forms where instance is the name of your WAM environment.
Open it with Oracle forms:
Double-click on SAPI_TRIGGER
Add your code to this proc:
The trigger name is WHEN-CUSTOM-MENU-ACTION- and your custom menu name. In this case I am calling a stored procedure named mark.
You should be able to read a value from the underlining form using the name_in function. More information can be found at http://download.oracle.com/otn_hosted_doc/forms/forms/A73074_01.pdf
Click the icon in the upper left corner to compile.
After making the change save your work and close the procedure body. Then select the menu Program, Compile Module. This will produce the file srpi.plx. Stop your oc4j services on the WAM server and copy this file to the WAM server. Restart the services and your custom menu should now be there and work.
