Enable zoom_available in custom.pll and calling form [message #679316] |
Fri, 21 February 2020 02:41 |
|
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 #679318 is a reply to message #679316] |
Fri, 21 February 2020 03:03 |
|
thussain795@gmail.com
Messages: 6 Registered: January 2020
|
Junior Member |
|
|
thussain795@gmail.com wrote on Fri, 21 February 2020 02:41Hi 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
|
|
|