Recently I had this requirement to restrict some of the values on an existing LOV item in a EBS form.Below are the steps required for the same.

 

 

 

To call a pl/sql API from forms personalization, do this

1. Personalize the form2. Create an action of type "BuiltIn"3. BuiltIn Type for Action should be "Execute a Procedure"

 

4. Argument should be as below

='declare   v_field_value VARCHAR2(200) ;   begin       plsql_package.procedurenameHere ;  end'

or alternately

='declare   v_field_value VARCHAR2(200) ;   begin       apassi_prc ('''||${item.PO_CONTROL_RULES.OBJECT_CODE_DISPLAYED_VALUE.value}||''');   end'

Note the syntax, after =, entire declare begin end is within single quote.Also, there is no semi colon after "end"

You can pass field values as '''||${item.BLOCKNAME.FIELDNAME.value}||'''

Call form by menu: