-
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