Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between restricted and unrestricted
package procedure ?
- 3 Answers
- 8025 Views
- I also Faced
- E-Mail Answers
Answer Posted / a.kondala rao.
Restricted package procedure that affects the basic basic
functions of SQL * Forms. It cannot used in all triggers
except key triggers.
Unrestricted package procedure that does not interfere
with the basic functions of SQL * Forms it can be used in
any triggers
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff
What is an SQL FORMS ?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
if u want to delete all these detail block etc what will happen in form
Is it possible to have multiple layouts in a report?
what are the new features introduced in oracle form services in 11g release 2?
a text item is there what r the different types of triggers associated with it
In what situation u create the BPA.
What is the difference between BPA AND Contract What are documents and test cases u followed
What is a canvas in oracle forms?
i am writing a query select EmpNo from Emp how can i call in after parameter form
What do you understand by lov and how can it be used?
What is responsibility and how u attach How to create user and how u attach with responsibility.
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
