Fnd_function.execute/app_navigate.execute differences

1, Fun_function.execute Introduction

Fnd_function.execute is used to access a specified form-based (form)-accessible feature (no access will throw an error message), and Oracle recommends replacing the original built-in function open_form with this procedure.
Because Fnd_function.execute can bypass the application security verification and find the correct access path for the feature. Accessible Description: The function to be accessed is to be hung under the same menu for the same duty, and if the function being called does not want to be seen under the menu, you can set the prompt for the feature to null; otherwise, an inaccessible error is reported: There is no function available for this responsibility. Change the responsibility or contact your system administrator.

2.Fun_function.execute Parameter description

PROCEDURE Fnd_function.execute (function_name in VARCHAR2,

Open_flag in VARCHAR2 DEFAULT ' Y ',

Session_flag in VARCHAR2 DEFAULT ' SESSION ',

Other_params in VARCHAR2 DEFAULT NULL,

Activate in VARCHAR2 DEFAULT ' activate ',

Browser_target in VARCHAR2 DEFAULT NULL);

Parameter description:

Name of parameter	Description
Open_flag	Y--Opens a form and retains the original form, which belongs to the multi-form mode; N-> creates a new form that closes the original form; The parameter is preferably ' Y ' ; y/n calls the built-in method, respectively Open_form/new_form
session_flag	n/no_session means that the existing form and the newly opened form are in the same session, y/ The session indicates that the open form will create a new database   session ps: When the function type is the following type, The parameter is automatically ignored. www, Wwk, JSP,   servelet.
other_params	form parameter, parameter note format: parameter values are enclosed in double quotation marks, separated by a space between the parameters. Example: OTHER_PARAMS=> ' context1= ' | |:block.context1   | | ' ' | | ' context2= "' | |: Block.context2 | | ' "'); other_params=> ' param1= ' | | value1 | | ' &param2= ' | | value2;
Activate_flag	Activate/no_activate, indicates whether to focus on the newly opened form, the default ACTIVATE. Activate says the new form gets focus, while no_activate opens a form, but the cursor is still in the current form
Browser_target	Used only for JSP, OAF and other self-service functions, to specify the browser frame, if empty, will open the page in a new browser window.

3, App_navigate.execute Introduction

PROCEDURE App_navigate.execute (function_name in VARCHAR2,

Open_flag in VARCHAR2 DEFAULT ' Y ',

Session_flag in VARCHAR2 DEFAULT ' SESSION ',

Other_params in VARCHAR2 DEFAULT NULL,

Activate_flag in VARCHAR2 DEFAULT ' activate ',

Pinned in BOOLEAN DEFAULT FALSE);

The parameters are basically similar to the functions and Fnd_function.execute, only the pinned are explained:

Pinned:true/false. If set to True,app_nivigate.execute will no longer reuse form instances, the effect is exactly the same as Fun_function.execute

4, two process differences

App_navifate.execute can also open a feature, but this method is primarily related to form instance and multiplexing. Example: Form A uses this procedure to open form B, and soon after it continues to open form B with this method, the last opened FORMB instance is used, and a new FORMB is not created. Also, a form instance can be shared between multiple form instances, for example, form a opens form B with this procedure, and then form C uses this procedure to open form B, and does not create a new instance of form B, directly using the instance opened by form a.

Fnd_function.execute, in any case, creates a new form instance.

Fnd_function.execute/app_navigate.execute differences