Answer / kiran kumar

---- is a named pl/sql block to perform a specific task.
---- A procedure may have DML statements.
---- It may or may not return a value.
---- Procedure can return more than one value.

Example for procedure
1)To accept the year as a parameter and list emp belong to
the year?
Create or replace
Procedure empy(y number) is
Cursor emp_cursor is
Select * from emp where to_char(hiredate,?yyyy?)=?y?;
Emp_record emp%rowtype;
Begin
For emp_record in emp_cursor loop
Print (emp_record.empno);
Print (emp_record.ename);
Print (emp_record.sal);
End loop;
End;
Output :
var empx number;
Begin
:empx := ?1234?;
End;
Exec empy(:empx);
Print empy;

Answer / nidhi

Procedure consist of set of the PL/SQL statments that are
grouped togather as a unit to solve a specific problem or
perform set of related tasks.
-->May or may not return the value.
-->can not use in teh sql queries because returns more than
one value.

Answer / chandrasekhar

procedure is subprogram in pl/sql that contains a set of
SQL and PL/SQL statements.Subprograms once we executed can
be used in any no.of applications

What is the difference between buyer&employee in PO module?

7 Answers   TCS,

---

what is the back ground program run while transferring data from OM to AR?

4 Answers   Qwest,

---

what is Flex mode and Confine mode?

2 Answers   Rapidigm,

---

what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions

1 Answers  

---

The Task is that to register a Form into Oracle Apps on a particular responsiblity. - First i moved the FMX & FMB file into the custom_top through FTP - Using Application Developer i registered the Form through Form menu then Function then Menu..... as we do regularly.. - When i get into the particular responsiblity i can see the Form name getting listed. But when i click that to open..... i cant able to see the form. I need any one your help in advicing me...what would be the problem.

7 Answers   SGS,

---

---

What is profile and what is level of profile option and it's hierarchy

1 Answers   IBM,

---

Can 2 functions have same name & input parameters but differ only by return datatype ?

5 Answers  

---

tell me the scenarios of the independent in reports

0 Answers   Accenture, IBM,

---

what u did after ur btech(2009) till now? why did u prefer oracle apps technical?

1 Answers   Intelligroup,

---

What is ment by Global Templates in Oracle.

1 Answers   IBM,

---

testing tools?

0 Answers   BirlaSoft, Convergys,

---

Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232

0 Answers  

---