Answer Posted / sudipta santra

In form-1 the written code is given below:-

list_id := Create_Parameter_List('PAR_CONTRACT');
Add_Parameter(list_id,
'CONTRACT_NO',TEXT_PARAMETER,:TBL_CONTRACT.CONTRACT_NO);
call_Form('T:\Form-2.fmx',no_hide,no_replace,
no_query_only,list_id);

In form-2 the written code is given below:-
Either in the trigger When-New-Form-Instance or in trigger
Pre-Form :-

SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,WINDOW_STATE,MAXIMIZE);
BEGIN
IF ( :PARAMETER.PAR_CONTRACT IS NOT NULL ) THEN
/* Use this value in the WHERE clause of MY_BLOCK */
Set_Block_Property('TBL_CONTRACT',DEFAULT_WHERE,
'PAR_CONTRACT = :PARAMETER.PAR_CONTRACT');
GO_BLOCK('TBL_CONTRACT');

Execute_Query;
END IF;
END;

In that way we can use parameter inside the several forms.

If you have still any doubts , then please reach me out at:
sudipta_santra@infosys.com

what is the difference between call_form, new_form and open_form?

1312

---

What is the difference between BPA AND Contract What are documents and test cases u followed

2385

---

List out the oracle forms configuration files?

1078

---

Explain how can you use the same lov for 2 columns?

1140

---

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2217

---

what is oracle forms?

1111

---

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

2166

---

What do you understand by oracle forms and why are they required?

1019

---

What do you understand by lov and how can it be used?

1097

---

Can we invoke one form from another in a multi-forms application?

1138

---

Explain the various types of oracle report?

1081

---

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1455

---

What is responsibility and how u attach How to create user and how u attach with responsibility.

2042

---

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1900

---

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1988

---