How to register a form and stored procedure in oracle apps
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 17 Yes | 7 No |
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
| Is This Answer Correct ? | 1 Yes | 3 No |
How will U link GL with OU in Multi-org environment.
35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?
suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?
In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?
Do you know where we can check the status of po?
What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.
How You Will display the key flexifields in your report
Where we can write a PL/SQL code in report triggers?
what are the difference between oracle discoverer and report6i
There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.
is it possible to run the interface without using oracle apps?
what are the steps to develop a new report?