Using custom PL/SQL packages in custom menus

admin

Below is an example custom menu we use

Customer menus

action type:  SAL code

Parameter:  frmInventoryPart.DbPLSQLTransaction(frmInventoryPart.c_hSql, "&AO.up_parts_api.ur_clone_part( 'CA', 'US', :i_hWndFrame.frmInventoryPart.ecmbPartNo.i_sMyValue )")

&AO.up_parts_api.ur_clone_part is my procedure( mine is actually in a package )

'CA', 'US' – two static values being passed to my procedure

:i_hWndFrame.frmInventoryPart.ecmbPartNo.i_sMyValue – value from the form being passed to my procedure.  

i_sMyValue – if you are passing a value that is in a drop down box you need to add i_sMyValue to the end o the statement.