How to call another oracle Form with Parameters

1)Develop both forms and register in application.

2)Place the Button in first from 

3)Write the following code in WHEN-BUTTON-PRESSED Trigger.

fnd_funCtion.execute(function_name => 'second_form_function_name',

             open_flag     => 'Y'    ,             

                     OTHER_PARAMS  => 'P1 = '||:XXAP_SUPPLIERS.VENDOR_ID);

 

P1 is Second form parameter

 

4)Open the Second form and define the Parmaeter called P1

5)goto PRE-QUERY trigger and write the following code to change the query dynamically.

 :XXAP_SUPPLIER_SITES_ALL.VENDOR_ID  := :PARAMETER.P1;

 --:blockname.fieldname := :PARAMETER.Parametername; 

  

6) Goto the WHEN-NEW-FORM-INSTANCE Trigger at form level. write the following code 

    GO_BLOCK('XXAP_SUPPLIER_SITES_ALL');

EXECUTE_QUERY;