5 Replies Latest reply on Feb 26, 2020 11:33 AM by Mohammed Fareed Hussain

    Enable zoom_available in custom.pll and calling form

    Mohammed Fareed Hussain

      Hi Experts,

      Oracle Application: 12.2.4

      Oracle Forms Version: 10.1.2.3.0

       

      I am working on a requirement form personalization using custom.pll enabling the zoom button using the below code in custom.pll

       

      function zoom_available return boolean is
      form_name  varchar2(30) := name_in('system.current_form');
      block_name varchar2(30) := name_in('system.cursor_block');
        begin
      if (form_name = 'FNDSCRSP' and block_name = 'RESPONSIBILITY') then
            return TRUE;
          else
            return FALSE;
          end if;
        end zoom_available;
      

      My zoom in button got enabled for RESPONSIBILITY form.

      I have a requirement that if the zoom button is clicked then I should take me to REQUEST GROUP form and should copy the values RESPONSIBILITY form VALUES ARE REQUEST_GROUP_NAME and APPLICATION_NAME and should display the records based on the Values which is passed by RESPONSIBILITY form. I am trying to do these in custom.pll event procedure I have incomplete code below please help me to complete these codes.

      procedure event(event_name varchar2) is
      form_name VARCHAR2(50):= NAME_IN('system.current_form');
        block_name VARCHAR2(50):= NAME_IN('system.cursor_block');
      BEGIN
         IF (event_name = 'ZOOM')
         THEN
            IF (form_name = 'FNDSCRSP' AND block_name = 'RESPONSIBILITY')
            THEN
               fnd_function.execute (FUNCTION_NAME   => 'FND_FNDRSGRP',
                                     OPEN_FLAG       => 'Y',
                                     SESSION_FLAG    => 'Y',
                                     OTHER_PARAMS    => NULL);
            END IF;
         END IF;
      END event;
      

      the above code is calling another form but how can I pass the values to the destination form and get the result based on that values.

       

      thanks and regards,

      Mohammed