Answer / zakkam raju

form registration:
go to application developer responsibility
goto application menu--> select form--> give form name and
application name and user form name
then go to -->function give function name and user function
name, and give form name
then go to menu --> attach funcation name to menu
run form resposibility

stored procedure registration:
go to system adminstration responsibility
goto program menu--then select executable define executable
a name and select execution method as pl/sql stored program
then defin concurrent program
then goto security define resoponsibility
and then goto restquest group
and submit the concurrent program

Answer / fred

registering plsql store proceduer with parameters on oracle
apps

that is if there is a parameter with a bind variable '&1'
in the plsql statement, how do you go about it in the
define window in my plsql registeration window

Challenges faced during upgradation of 11i to R12

1 Answers   Infosys, Satyam,

---

what is the data type of lexical parameter?

5 Answers   Wipro,

---

Tell me where we find the status of order information?

0 Answers  

---

difference b/w procedures&functions

2 Answers   Oracle, TCS,

---

in procedure how to return a value

3 Answers  

---

Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports

2 Answers  

---

in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me

4 Answers   CTS, iGate,

---

If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?

3 Answers   Accenture,

---

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,

---

Write an SQL Query to Delete Duplicate records from a table using ROWID.

24 Answers   pspl, Satyam, Thinkways,

---

in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?

2 Answers   Oracle, Schneider,

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

0 Answers   Cap Gemini,

---