OracleEBSFormCUSTOM. PLL

Compile CUSTOM database is an OracleFormsDeveloperPLSQL database, which allows you to use OracleFormsDeveloper to directly integrate your code to Ora

Compile CUSTOM database is an OracleForms Developer PL/SQL database, which allows you to use Oracle Forms Developer to directly integrate your code to Ora

Compile the M Library
The CUSTOM database is an OracleForms Developer PL/SQL database that allows you to use Oracle Forms Developer to directly integrate your menu and add entries to the Oracle Application form to the special menu, for example, an entry that opens a custom form.
SetVisual attributes use the CUSTOM library to change the visual attributes at runtime, use the Oracle Forms built-in program SET_VA_PROPERTY to set the visual attributes of CUSTOM1-CUSTOM5, and use APP_ITEM_PROPERTY2.SET_PROPERTY to apply the visual attributes at runtime.

Compile Zoom
Zoom allowedUserCall the call logic in each block. For example, you may wantProcurementOrderOpen the supplier form when using form. You can use Zoom on this block and when the user calls it, you can open the supplier form
11i Zoom:
The Oracle application provides a menu item and a button in the toolbar. You can call Zoom. The menu item and button are available only when the menu item is defined in the Zoom logic of the CUSTOM library.
When the cursor changes to different blocks in form, form calls the ZOOM_AVALIABLE method in CUSTOM library. If this method returns TRUE, the ZOOM entry and button are available, and FALSE is not available.
If the Zoom entry is available, the Zoom method in CUSTOM is called when the user calls ZOOM. You can compile this event based on the current form and block.
Compile Zooms in the CUSTOM Library
1. Add a CUSTOM. ZOOM_AVALIABLE method, which is used only for form and block. When can Zoom be enabled?
2. Add the CUSTOM. EVENT process to the zoom event.
Supports multiple Zoom times in a block.
In 11i, the Oracle application provides a LOV and corresponding parameters for Zoom:
U LOV: APPCORE_ZOOM
U parameter: APPCORE_ZOOM_VALUE
You can use the LOV and parameters to provide a LOV when this block contains an extra ZOOM.
Write ZoomLOV to the M library.
In the CUSTOM Library (including the Zoom Event code)
1. Create a record combination and fill in the available Zoom names and values
2. Add a record group to APPCORE_ZOOM LOV.
3. Call show_lov to display the LOV to the user.
4. If you select a Zoom parameter, return the value to the APPCORE_ZOOM_VALUE parameter.
5. Select different Zoom values for the obtained parameter values.
Compile common Form events
You can write the logic, which is triggered in a special form and block event. You can write the logic in the following event:
WHEN-FORM-NAVIGATE
WHEN-NEW-FORM-INSTANCE
WHEN-NEW-BLOCK-INSTANCE
WHEN-NEW-RECORD-INSTANCE
WHEN-NEW-ITEM-INSTANCE
WHEN-VALIDATE-RECORD
Specia1n (n is a number between 1 and 45)
ZOOM
EXPORT
KEY-Fn (n is a number between 1 and 8)
Some Oracle application forms, such as most Oracle Human ResourcesModuleThe form may provide additional events to call the CUSTOM library. These additional events are listed inDocument. You can write the logic in the CUSTOM database in the same way in the general time.
In the CUSTOM database, write logic for the common form time:
1. Add a branch for a special EVENT during CUSTOM. EVENT.
Inside the branch, specify the form and block that you want your logic to trigger and add the logic to the events you want to trigger to these blocks.
Compile the specified event of the product:
To write the Event Logic specified by the product to the CUSTOM database:
1. Add branches to CUSTOM. EVENT for specified events of Special Products
Add the logic to the branch.
2. To support CUSTOM execution types, add the branch to CUSTOM. STYLE method to specify the execution type.
Add custom entries to the special menu.
To add entries from the logic to the special menu in the CUSTOM Library
1. Add the branch event when-NEW-FORM-INSTANCE during CUSTOM. EVENT
In this branch, specify the form and block for which you want to add the logic and add the logic to the Special menu.
2. Add a special specia1event to the M. EVENT process.
In this branch, specify the form and block that occurs logically. Add the logic to your Special menu. If it is youDevelopmentYou should add the logic to the specia1trigger named by the user.
Special events for Oracle Application Object Library products.
The Oracle Application Object Library provides product special events that can be used by the CUSTOM library.
WHEN-LOGON-CHANGED events
Use WHEN-LOGON-CHANGED events to trigger authentication immediately when the User uses File-> Log On as a Different User. This method is only effective for Forms developed based on Oracle Forms Developer. It is useless for from Based on HTML or Java.
You can use the FND_PROFILE.GET method to get the new user name and other presets.FileValue
If the code in this time throws a form_trigger_failure exception for some reason, the user will return to the logon interface.
WHEN-RSPONSIBILITY-CHANGED events
Use the WHEN-RESPONSIBILITY-CHANGED event to trigger verification WHEN you use the "Fiel-> SwitchResponsibility" to switch duties. This method is only effective for Forms developed based on Oracle forms Developer.
You can use the FND_PROFILE.GET method to obtain the new responsibility name and other preset file values. If the code in this event throws a form_trigger_failure exception for some reason, the user will return a list interface that selects an incorrect responsibility.
CUSTOM package
The CUSTOM package contains the following methods and procedures:
CUSTOM. ZOOM_AVALIABLE
CUSTOM. STYLE
CUSTOM. EVENT
CUSTOM. ZOOM_AVAILABLE
Function custom. zoom_available return BOOLEAN;
If this block Zoom is available, TRUE is returned; otherwise, FALSE is returned, which is usually used to test the form and block.
Usually this method returns FALSE
CUSTOM. STYLE
Function custom. style (event_name varchar2) return integer;
This method allows you to determine the type of execution. You can select code execution as, before, after, or replace. Note that some product-specific events do not support all execution types of CUSTOM. STYLE and do not work for common form events or Zoom.
The following package variables are used as return values:
Custom. before
Custom. after
Custom. override
Custom. standard
As the default value, this method returns custom. standard
CUSTOM. EVENT
Procedurecustom. event (event_name varchar2 );
This method allows you to execute your code in the specified event. Generally, the test event name is either form or block.
By default, this method should return null;