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;
Navigation: Help > Diagnostics > Custom Code > Personalize
Personalization in Destination 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
No comments:
Post a Comment