-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Oracle E-Business Suite R12 Core Development and Extension Cookbook
By :

As part of the TEMPLATE form, we get a standard mechanism to create a query screen. This usually is the first screen that is present when the form opens if no data is passed to the form via parameters. This allows the user to search for specific records. In our form, we want to create a query form that allows us to search for an employee. We want the user to be able to search by their name or their employee number. There are a number of steps required to implement a QUERY_FIND window. In this recipe, we are going to perform the following tasks:
Adding code to the WHEN-NEW-FORMS-INSTANCE
trigger
Copying the QUERY_FIND
object group
Setting the block, canvas, and window properties
Editing the button triggers on the QUERY_FIND
block
Creating items in the query block
Resizing the objects on the canvas
Creating a PRE-QUERY
trigger
Creating a QUERY_FIND
trigger
Firstly, we are going to add some code to the WHEN-NEW-FORM-INSTANCE...
Change the font size
Change margin width
Change background colour