Home » Developer & Programmer » Forms » Enable zoom_available in custom.pll and calling form (Oracle form Version: 10.1.2.3.0 )
Enable zoom_available in custom.pll and calling form [message #679316] Fri, 21 February 2020 02:41 Go to next message
thussain795@gmail.com
Messages: 6
Registered: January 2020
Junior Member
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
Re: Enable zoom_available in custom.pll and calling form [message #679317 is a reply to message #679316] Fri, 21 February 2020 02:52 Go to previous messageGo to next message
Michel Cadot
Messages: 67132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, make sure that lines of code do not exceed 80 characters.

Re: Enable zoom_available in custom.pll and calling form [message #679318 is a reply to message #679316] Fri, 21 February 2020 03:03 Go to previous message
thussain795@gmail.com
Messages: 6
Registered: January 2020
Junior Member
thussain795@gmail.com wrote on Fri, 21 February 2020 02:41
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
Previous Topic: Mouse navigation validatation
Next Topic: oracle forms and reports installation 12c
Goto Forum:
  


Current Time: Tue May 26 08:33:55 CDT 2020