Jump implementation between EBS form (form off)

Implement form CUXOMWB use App_navigate.execute to open form Cuxoexprava; then from Cuxoexprava click the button
Jumps back from the CUXOMWB and executes the query again, at which point the from Cuxoexprava is closed, and the from CUXOMWB has only one open;


The implementation process comes from: Form APXINWKB and Apxrmtch
--app_window.close_first_window;
/* This form was closed by the trigger ap_close_match_forms in APXINWKB
This trigger fires because when the corresponding matching form is
Closed the global variable when_form_navigate is set to the value of this trigger and
A go_form call is made. When this trigger is executed, the corresponding matching
Form needs to being closed and other logic like requerying the distributions
and updating the distribution total is executed. The ID of the form to be closed
is set in the global Variable:global. AP_MATCH_FORM_ID * *




First:
Create some required parameters on form Cuxoexprava, cuxomwb_form_id must be
Open Cuxoexprava code simultaneous parameter on form CUXOMWB
/*-Get the form ID of the Invoice workbench
l_form_id Formmodule;
l_cuxomwb_form_id number;
l_form_id: = Find_form (: system.current_form);
l_cuxomwb_form_id: = l_form_id.id;*/


Create trigger on FORM CUXOMWB cux_close_price_forms call cuxomwb.close_price_forms (' Cuxoexprava ');


PROCEDURE close_price_forms (Form_name VARCHAR2) is
FORM_ID Formmodule;
L_PRICE_FORM_ID number;
BEGIN

L_PRICE_FORM_ID: =: Global. price_form_id;
--Need to set global variables back to NULL as soon as possible.
: global.when_form_navigate: = NULL;
: Global. price_form_id: = NULL;
Form_id.id: = l_price_form_id;
IF id_null (form_id) Then
NULL;
ELSE
Close_form (form_id);
END IF;
END close_price_forms;








The place to close on form Cuxoexprava






PROCEDURE back_order_btn_pressed is
L_RECT_FORM_ID Formmodule;
L_INV_FORM_ID Formmodule;
BEGIN
l_rect_form_id: = Find_form (: system.current_form);
: GLOBAL. price_form_id: = l_rect_form_id.id;
: GLOBAL. When_form_navigate: = ' cux_close_price_forms ';
L_inv_form_id.id: =:p arameter. cuxomwb_form_id; --This parameter is the form CUXOMWB Excute when you open the form Cuxoexprava.
Go_form (l_inv_form_id);

END back_order_btn_pressed;


New execution query on form CUXOMWB

Trigger when-window-actived TRIGGER judgment variable to do refresh action on form CUXOMWB

Navigate from one window to another (all two windows are open), use When–form–navigate to pass parameters, remember not to encode the trigger directly, but to use global variables to pass parameters. To do this, use global variables globally in a custom trigger. When_form_navigate to pass parameters. The When–form–navigate trigger is also triggered when navigating to another window using the Go_form built-in procedure.

Example: Querying an item (field)

It is likely that there is a need to navigate to another form and query the records based on an item in the form. Suppose you now have two forms, one named orders and the other named catalogs, and now you navigate from the Orders form to the Catalogs form, based on a name named Part_ on the Orders form. Number item to query the records in the Catalogs form. The solution is as follows:

U Step 1: Create a global variable global.part_number in the Orders form and assign the value of the query to the global variable.

U Step 2: Create another global variable global.when_form_navigate in the Orders form, and assign a value of string query_part_number.

U Step 3: Create a custom trigger Query_part_number in the Catalogs form that contains execute_query to execute the query when navigating to the form.

U Step 4: Write the following code in the form catalogs Pre-query trigger:

Copy (' GLOBAL. Part_number, ' Parts_block. Part_number ');

Copy (', ' GLOBAL. Part_number ')

Jump implementation between EBS form (form off)