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 use commit in trigger? If yes how?

2 Answers   Cap Gemini, TCS,

---

Which module is not in multiorg

6 Answers   HCL, Wipro,

---

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

2 Answers  

---

Can we create tables in apps schema?

1 Answers  

---

Is it possible to do purchase order without requisition?

8 Answers  

---

what is the purpose of standard cost update?

2 Answers   Satyam, Scan Steel,

---

What is the Exception. Types of exception, Difference between those. And example

2 Answers   IBM,

---

Name the different Cursor Attributes.

2 Answers   Satyam,

---

How to create a purchase order without a requisition?

1 Answers  

---

what is MRC? Why it is needed?

4 Answers   Convergys,

---

What are the requests groups?

3 Answers  

---

what are the functions you are used in utl_file at the time of transferring the data?

2 Answers   Oracle,

---