Oracle E-Business Suite R12 Core Development and Extension Cookbook

Adding a query screen to a form

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 ...