Answer / mylapuram

you can create two more dummy parameters(like
p2_dummy,p3_dummmy ) and set display property to no.

now set the default value for p2_dummy as "decode
(p1,'a','Y',null) in the same way for p3_dummmy.

now in the valueset for p2 use where $FLEX$.p2_dummy ='Y'
and similarly for p3.

contact me if u have any doubt in this(on my mail).

can we write sql statement in Format trigger?

4 Answers  

---

What are the different components you should consider while defining a responsibility in oracle apps?

0 Answers  

---

what is MRC? Why it is needed?

4 Answers   Convergys,

---

How do u identity its name of report?

3 Answers  

---

What is Place holder Columns?

3 Answers  

---

---

Where we can write a PL/SQL code in report triggers?

2 Answers   IBM,

---

Exception Handilings?

1 Answers  

---

Is that Possible To create package Overloading , If Yes Give any Examples

1 Answers   PWC,

---

Difference between triggers and procedures?

2 Answers  

---

In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?

1 Answers   Accenture,

---

Is that Possible To create package without Specification , If Yes Give any Examples

2 Answers   PWC,

---

we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?

4 Answers  

---