ZOOM

Using zoom button we can call the another form.
Zoom button is used to calling the second form at a time.
Directly going from one form to another form with click of a button is called zoom functionality in oracle applications.
In oracle apps if you open one form & try to open the second from first form is automatically closed.
With this you are able to open second from.

Open CUSTOM.pll go to the function called zoom_available  and write the following code in the palce of 
"Real Code Starts Here"

    form_name  varchar2(30) := name_in('system.current_form');
    block_name varchar2(30) := name_in('system.cursor_block'); 
  begin
    if (form_name = 'POXRQERQ' and block_name = 'PO_REQ_HDR') then
      return TRUE;
    else
      return FALSE;
    end if;

Goto the Event Procedure and write the follwing code in the place of "Real Code Starts here"
   
form_name      varchar2(30) := name_in('system.current_form');
    block_name     varchar2(30) := name_in('system.cursor_block');
    begin
   
      if (event_name = 'ZOOM')  then
      if (form_name = 'POXRQERQ' and block_name = 'PO_REQ_HDR') then     
        fnd_function.execute(function_name =>   'PO_POXRQVRQ',
        open_flag     =>   'Y');
      end if;
      end if;

How to implement Zoom functionality?

In this tutorial we will zoom from Order Organizer form to Shipping transactions form and also populate the order number dynamically in destination form.

Know the following things before you start

• Know the names of source form and destination form 

• If you need to populate the data dynamically know what fields that you need to populate. 

• Global Variables: These variables can be initialized in any form and can be used in any form all over the applications 

• Trigger & Action: trigger is an event and action is operation/execution that we do. When an event occurs we do operation/execution 

Source form        : Order Organizer form (OEXOEORD)

Destination form : Shipping transactions form (WSHFSTRX)

Source field         : Order number ()

Destination field1: Order number low (QM_DLVB.DLVB_SOURCE_HEADER_NUMBER_LO)

Destination field2: Order number high (QM_DLVB.DLVB_SOURCE_HEADER_NUMBER_HI)

Destination field3: Line Status (QM_DLVB.DLVB_LINE_RELEASED)

Process flow:

• Initialize the menu/icon in source form 

• Initialize the global variables 

• When the menu/icon is clicked copy the order number from source form filed to global variable and then launch the destination form 

• In the destination form copy the value from global variable to destination form field. 

Initialize the menu/icon in source form

 

Navigation: Order Management Super User  > Orders, Returns >  Order Organizer

Navigation: Help > Diagnostics > Custom Code > Personalize

Personalization in Destination Form