Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to invoke functions in FORM". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn how to invoke functions in FORM.

1. Fun_function.execute

Fnd_function.execute is used to access the specified form-based (Form) and accessible functionality (inaccessible will throw an error message), and Oracle recommends that you replace the built-in function OPEN_FORM with this process. Because fnd_function.execute can bypass application security authentication and find the functionally correct access path.

Accessible description: the accessed function needs to be hung under the same menu of the same responsibility. If the function being called does not want to be seen under the menu, the "prompt" of the function can be set to empty; otherwise, an inaccessible error will be reported: no function is available for this responsibility. Change responsibilities or contact your system administrator.

Parameter description:

Function_name

Open_flag

Y-> opens a FORM and retains the original FORM, which belongs to multi-form mode; N-> creating a new FORM will close the previous FORM

The best parameter is Y

Y _ map N calls the built-in method OPEN_FORM/NEW_FORM respectively

Session_flag

N / NO_SESSION means that the existing FORM and the newly opened FORM are in the same session

Y / SESSION indicates that the open FORM will create a new database session

Other_params

FORM parameters. Note the format of the parameters: the parameter values are enclosed in double quotation marks, and the parameters are separated by spaces. Example:

OTHER_PARAMS= > 'CONTEXT1= "' | |: block.context1 | |'" | | 'CONTEXT2=' | |: block.context2 | |'"')

If you are calling other types of functions, such as JSP pages, OAF pages, etc., the parameters are separated by the & delimiter, for example:

OTHER_PARAMS= > 'param1=' | | value1 | |'? M2 room' | | value2

Activate_flag

ACTIVATE/NO_ACTIVATE, indicating whether to focus on the newly opened FORM, the default ACTIVATE.

ACTIVATE indicates that the newly opened FORM gets focus, while NO_ACTIVATE opens a FORM, but the cursor is still at the current FORM.

Browser_target

Used only for self-service functions such as JSP, OAF, and so on, to specify the browser Frame. If empty, the page will be opened in a new browser window.

2. App_navigate.execute

Its parameters and functions are similar to those of fnd_function.execute.

Parameter description:

Pinned

TRUE/FALSE. If set to TRUE,app_nivigate.execute, Form instances will no longer be reused, and the effect is exactly the same as fun_function.execute.

3. The difference between the two processes

App_navifate.execute can also turn on a function, but this method is mainly related to FORM instance and reuse.

For example: Form A uses this process to open FormB, and when it continues to open FormB in the near future, it will use the last opened instance of FormB instead of creating a new FormB.

Moreover, a FORM instance can be shared among multiple Form instances. For example, when Form A uses this process to open Form B, and then Form C also uses this process to open Form B, it will not create a new Form B instance, but will directly use the instance opened by Form A. Fnd_function.execute creates a new Form instance in any case.

Thank you for your reading, the above is the content of "how to invoke functions in FORM". After the study of this article, I believe you have a deeper understanding of how to invoke functions in FORM, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.