Oracle_XX_Developers Guide.pdf | Pl/Sql

Please download to get full document.

View again

of 900
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Documents

Published:

Views: 11 | Pages: 900

Extension: PDF | Download: 0

Share
Related documents
Description
R Oracle Applications Developer’s Guide RELEASE 11i VOLUME 1 April 2001 Oracle Applications Developer’s Guide, RELEASE 11i VOLUME 1 The part number for this volume is A83705–03. To reorder this book, please use the set part number, A75545–03. Copyright E 1995, 2001 Oracle Corporation. All rights reserved. Contributing Authors: Anne Carlson, Emily Nordhagen, Lisa Nordhagen, Dana Spradley, Martin Taylor, Peter Wallack, Millie Wang, Sara Woodhull Contributors: Ram Bhoopalam, Eric Bing, Stev
Transcript
  Oracle   ApplicationsDeveloper’s Guide  RELEASE 11 i  VOLUME 1 April 2001  Oracle Applications Developer ’ s Guide , RELEASE 11 i  VOLUME 1The part number for this volume is A83705 – 03 . To reorder this book, please use the set part number, A75545 – 03 . Copyright   1995, 2001 Oracle Corporation. All rights reserved.Contributing Authors: Anne Carlson, Emily Nordhagen, Lisa Nordhagen, Dana Spradley,Martin Taylor, Peter Wallack, Millie Wang, Sara Woodhull Contributors: Ram Bhoopalam, Eric Bing, Steven Carter, Cliff Godwin, Mark Fisher, MichaelKonopik, Michael Mast, Tom Morrow, Robert Nix, Gursat Olgun, Susan Stratton, LeslieStuddard, Venkata Vengala, Maxine Zasowski The Programs (which include both the software and documentation) contain proprietary information of Oracle Corporation; they are provided under a license agreement containing restrictions on use anddisclosure and are also protected by copyright, patent and other intellectual property law. Reverseengineering of the Programs is prohibited. No part of this document may be reproduced or transmitted inany form or by any means, electronic or mechanical, for any purpose, without the express writtenpermission of Oracle Corporation.Program Documentation is licensed for use solely to support the deployment of the Programs and not forany other purpose.The information contained in this document is subject to change without notice. If you find any problemsin the documentation, please report them to us in writing. Oracle Corporation does not warrant that thisdocument is error free. Except as may be expressly permitted in your license agreement for thesePrograms, no part of these Programs may be reproduced or transmitted in any form or by any means,electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation.If the Programs are delivered to the U.S. Government or anyone licensing or using the Programs on behalf of the U.S. Government, the following notice is applicable: RESTRICTED RIGHTS LEGEND Programs delivered subject to the DOD FAR Supplement are ’ commercial computer software ’  and use,duplication and disclosure of the Programs including documentation, shall be subject to the licensingrestrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject tothe Federal Acquisition Regulations are ’ restricted computer software ’  and use, duplication and disclosureof the Programs shall be subject to the restrictions in FAR 52.227 – 19, Commercial Computer Software – Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherentlydangerous applications. It shall be licensee ’ s responsibility to take all appropriate fail – safe, back up,redundancy and other measures to ensure the safe use of such applications if the Programs are used forsuch purposes, and Oracle disclaims liability for any damages caused by such use of the Programs.Oracle is a registered trademark and Oracle7, Oracle8, Oracle Application Object Library, Oracle Applica-tions, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle DataBrowser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, OracleReports, PL/SQL, Pro*C and SmartClient are trademarks or registered trademarks of Oracle Corporation.All other company or product names are mentioned for identification purposes only, and may be trademarksof their respective owners.   iContents Contents Volume 1 VOLUME 1 i. . . . . . . . . . . . . . . . . . . . . . . . . Preface i. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Audience for This Guide ii. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Other Information Sources ii. . . . . . . . . . . . . . . . . . . . . . . . . . . . . Do Not Use Database Tools to Modify Oracle Applications Data vi. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Typographic Conventions vii. . . . . . . . . . . . . . . . . . . . . . . . . . . . . About Oracle ix. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Your Feedback ix. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Chapter 1Overview of Coding Standards1 – 1. . . . . . . . . . . . . . . . . . . . . . . . . . . Overview of Coding Standards1 –  2. . . . . . . . . . . . . . . . . . . . . . . . . . . . Importance of these Standards1 –  2. . . . . . . . . . . . . . . . . . . . . . . . . Coding Principles1 –  2. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Coding With Handlers1 –  3. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Libraries1 –  4. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Performance1 –  5. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Coding for Web Compatibility1 –  6. . . . . . . . . . . . . . . . . . . . . . . . . The Standard Development Environment1 –  7. . . . . . . . . . . . . . . . . . . Oracle Application Object Library for Release 11i1 –  9. . . . . . . . . Setting Object Characteristics1 –  9. . . . . . . . . . . . . . . . . . . . . . . . . . Shared Objects1 –  10. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Standard Libraries1 –  11. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .   iiOracle Applications Developer ’ s Guide Property Classes1 –  13. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Visual Attributes1 –  14. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Overview of Building an Application1 –  15. . . . . . . . . . . . . . . . . . . . . . . Overall Design Issues to Consider1 –  15. . . . . . . . . . . . . . . . . . . . . . Overview of Application Development Steps1 –  16. . . . . . . . . . . . Overview of Form Development Steps1 –  17. . . . . . . . . . . . . . . . . . Chapter 2Setting Up Your Application Framework2 –  1. . . . . . . . . . . . . . . . . . . Overview of Setting Up Your Application Framework2 –  2. . . . . . . . Definitions2 –  2. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Set Up Your Application Directory Structures2 –  3. . . . . . . . . . . . Register Your Application2 –  3. . . . . . . . . . . . . . . . . . . . . . . . . . . . . Modify Your Environment Files2 –  4. . . . . . . . . . . . . . . . . . . . . . . . Set Up and Register Your Oracle Schema2 –  4. . . . . . . . . . . . . . . . Create Database Objects and Integrate with APPS Schema2 –  5. Add Your Application to a Data Group2 –  5. . . . . . . . . . . . . . . . . . Set Up Concurrent Managers2 –  5. . . . . . . . . . . . . . . . . . . . . . . . . . Applications Window2 –  6. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Prerequisites2 –  7. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Applications Block2 –  7. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Chapter 3Building Your Database Objects3 –  1. . . . . . . . . . . . . . . . . . . . . . . . . . Overview of Building Your Database Objects3 –  2. . . . . . . . . . . . . . . . Using Cost – Based Optimization3 –  2. . . . . . . . . . . . . . . . . . . . . . . . Tracking Data Changes with Record History (WHO)3 –  2. . . . . . Oracle8i Declarative Constraints3 –  5. . . . . . . . . . . . . . . . . . . . . . . LONG, LONG RAW and RAW Datatypes3 –  7. . . . . . . . . . . . . . . Columns Using a Reserved Word3 –  7. . . . . . . . . . . . . . . . . . . . . . . Views3 –  7. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Sequences3 –  10. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Table Registration API3 –  11. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Chapter 4Using PL/SQL in Oracle Applications4 –  1. . . . . . . . . . . . . . . . . . . . . Overview of Using PL/SQL in Applications4 –  2. . . . . . . . . . . . . . . . . Definitions4 –  3. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . General PL/SQL Coding Standards4 –  3. . . . . . . . . . . . . . . . . . . . . Database Server Side versus Client Side4 –  6. . . . . . . . . . . . . . . . . Formatting PL/SQL Code4 –  7. . . . . . . . . . . . . . . . . . . . . . . . . . . . . Exception Handling4 –  9. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks