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

Explain the various types of oracle report?

1068

---

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2986

---

What do you understand by lov?

1030

---

What is the difference between bind and lexical parameter?

1069

---

what is difference between group above and group left report

3811

---

how report can be generated if we have the database designed in oracle 10g?

1875

---

What is the difference between flex mode and confined mode?

1043

---

difference between global n context sensitive segments?

2664

---

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1009

---

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2276

---

where do u put the report file

2091

---

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

2374

---

a text item is there what r the different types of triggers associated with it

2004

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2126

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2324

---