Query_Find Form in Oracle Apps

Steps To Develop a Query_Find Form in Oracle Apps

• Step 1: Open Template.fmb with form builder save it with another name(XXMZ_Query_Find.fmb)  and give the module name as XXMZ_QUERY_FIND.
  

• Step2 : Delete  BLOCKNAME from Window,Canvas and Data Block and delete DETAILBLOCK from Data Block.
  

• Step 3: Create window(DEPT_WINDOW) apply subclass information as WINDOW and give the title.
  

• Step 4:  Give this window name in PRE-FORM trigger (Form Level) and give this window   name in in APP_CUSTOM  body   Program_Unit( in place of window name).
  

Compile and Close The Window.

Compile and Close The Window.

 Step 5: Create Canvas(DEPT_CANVAS) apply subclass information as Canvas.

 Step 6:  Now Create Data block(DEPT)  with Wizard or Manual ,apply subclass information to the block as BLOCK   and also apply subclass information to the items as TEXT_ITEM.

 Step 7:Step 5: Drag QUERY_FIND Object Group from APPSTAND.fmb to Our Form(XXMZ_Query_Find.fmb) Object Group. Here we get  window,canvas,datablock will come automatically  with the name QUERY_FIND.

Step 8: Apply subclass information to Window,Canvas as well as Block. And drag these to first position   as shown in below.

 Step 9:  In QUERY_FIND data block we get 3 buttons(Clear,New,Find) with 3 Triggers.

Give Block name as DEPT in   WHEN-BUTTON-PRESSED trigger of New and Find Button. Compile and close.

Step 10: Next create  Control item in the Query_Find Block apply subclass information as TEXT_ITEM  and attach that item to the  QUERY_FIND canvas.

Step 9:

Next drag the QUERY_FIND trigger from APPSTAND.fmb and Place it in DEPT block  level trigger.

Syntax:             APP_FIND.QUERY_FIND(<results block window>,

<Find window>,

<Find window block>);

And write the following code in that trigger:

APP_FIND.QUERY_FIND(‘DEPT_WINDOW’, ‘QUERY_FIND’,'QUERY_FIND’);

 Step 10:

Next Create PRE-QUERY trigger in the block level(DEPT)

Syntax:          IF :parameter.G_query_find = TRUE THEN

COPY (<find Window field>,<results field>);

:parameter.G_query_find := FALSE;

END IF;

Write the following code

IF :parameter.G_query_find = ‘TRUE’ THEN

COPY(:QUERY_FIND.DEPTNO, ‘DEPT.DEPTNO’);

:parameter.G_query_find := ‘FALSE’;

END IF;

 Step 11: In the form module(XXMZ_Query_Find) give the first navigation block as QUERY_FIND. In the  QUERY_FIND datablock give next navigation block as DEPT.

 Step 12:   Finally Save and move your form from our Local Machine  to CUSTOM_TOP using WINSCP tool.

 Step 13:  Compile the Form using f60gen

In the UNIX environment, type the following command:

f60gen XXMZ_QUERY_FIND.fmb apps/apps

Now XXMZ_QUERY_FIND.fmx should be generated in the CUSTOM_TOP.

 Step 14:

Connect to Oracle Applications. Create a Form

(Navigation:Application Developer->Application-> Form)

Here give Form =>XXMZ_QUERY_FIND(.fmx )

Application => xxmz Custom(Custom TOP Application)

User Form Name=>Give any name

 Step 15: Create a function (Navigation: Application->function)

 Step 16:Attaching Form to the Function shown in below.

Attach that function to the Custom TOP menu

Click on Find Button