Answer Posted / kiran kumar

---- is a named pl/sql block to perform a specific task, is
mainly used for calculation purpose.
---- A function is called as part of an exception.
---- Every function should return a value
Example for function
Create or replace
Function get_sal(p_id in emp.emp_no% type)
Return number
Is
v_sal emp.sal%type :=0;
Begin
Select salary into v_salary

From emp

Where emp_no = p_id;
Return v_salary
End get_sal;
End;

Output :
var g_sal number;
Exec :g_sal := get_sal(99);
Print g_salary;

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2975

---

What is oracle soa suite and what are its different components?

1134

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2007

---

q)what are the validations in sql*loader

2332

---

please send me forms, xml pulisher questions,answers

2067

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2576

---

Which oracle apps version you are very confident in?

1175

---

How can you achieve loose coupling in soa framework?

1176

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2168

---

What are the benefits of using soa architecture?

1180

---

What are file in oracle.

2180

---

what are the prerequisites for costing transactions?

3095

---

What do you understand by a set of books?

1043

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3573

---

How do you register report in oracle apps?

1031

---