1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

What is ZOOM Function in oracle applications?

Discussion in 'Oracle Apps Technical' started by jagadekara, Oct 14, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    What is ZOOM Function in oracle applications R12?

    Can you please explain about this.
     
  2. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    HI Jagadekara,

    I suppose you mean the "Zoom" function in View -> Zoom.

    I've never used it (up to now) but from what I have seen in the documentations (last time I wanted to use it ... but finally didn't really need it), it is used to call custom defined "zooms". This is event handled in CUSTOM.pll (just like WHEN-NEW-BLOCK-INSTANCE, for example) and is used to call a new form from the calling module.

    Extract from CUSTOM.pll:

    Code (SQL):
      /* Sample code:
     
        form_name      varchar2(30) := name_in('system.current_form');
        block_name     varchar2(30) := name_in('system.cursor_block');  
        param_to_pass1 varchar2(255);
        param_to_pass2 varchar2(255);
      begin
        -- Zoom event opens a new session of a form and
        -- passes parameter values to the new session.  The parameters
        -- already exist in the form being opened.
        if (event_name = 'ZOOM') then  
          if (form_name = 'DEMXXEOR' and block_name = 'ORDERS') then
            param_to_pass1 := name_in('ORDERS.order_id');
            param_to_pass2 := name_in('ORDERS.customer_name');
            fnd_function.execute(FUNCTION_NAME=>'DEM_DEMXXEOR',  
                                 OPEN_FLAG=>'Y',  
                                 SESSION_FLAG=>'Y',  
                                 OTHER_PARAMS=>'ORDER_ID="'||param_to_pass1||
                                   '" CUSTOMER_NAME="'||param_to_pass2||'"');
            -- all the extra single and double quotes account for
            -- any spaces that might be in the passed values
          end if;
    ....
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thanks Rajen,

    I don't want to use CUSTOM.pll. I need it through Form Personalization.

    I don't know View--> Zoom is same as ZOOM icon after Clear ICON on menu bar.

    I want to enable ZOOM icon.
     
  4. yowancristo

    yowancristo Forum Advisor

    Messages:
    103
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Bangalore
    Hi,

    Zoom in Oralce Forms can be done via Personalization - It is the ability to access one form from another form, or to call another instance of the same form.

    Regards,
    Yowan Cristo