Oracle Applications Developer's Guide
ROracle ApplicationsDeveloper’s GuideRELEASE 11iApril 2000
Oracle Applications Developer’s Guide, RELEASE 11iThe part number for this volume is A83705–02.To reorder this book, please use the set part number, A75545–02.Copyright E 1995, 2000 Oracle Corporation. All rights reserved.Contributing Authors: Anne Carlson, Emily Nordhagen, Lisa Nordhagen, DanaSpradley, Martin Taylor, Peter Wallack, Millie Wang, Sara WoodhullContributors: Ram Bhoopalam, Eric Bing, Steven Carter, Cliff Godwin, MarkFisher, Michael Konopik, Michael Mast, Tom Morrow, Robert Nix, GursatOlgun, Susan Stratton, Leslie Studdard, Venkata Vengala, Maxine ZasowskiThe Programs (which include both the software and documentation) containproprietary information of Oracle Corporation; they are provided under alicense agreement containing restrictions on use and disclosure and are alsoprotected by copyright, patent and other intellectual property law. Reverseengineering of the Programs is prohibited. No part of this document may bereproduced or transmitted in any form or by any means, electronic ormechanical, for any purpose, without the express written permission of OracleCorporation.Program Documentation is licensed for use solely to support the deployment ofthe Programs and not for any other purpose.The information contained in this document is subject to change without notice.If you find any problems in the documentation, please report them to us inwriting. Oracle Corporation does not warrant that this document 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 anyform or by any means, electronic or mechanical, for any purpose, without theexpress written permission of Oracle Corporation.If the Programs are delivered to the U.S. Government or anyone licensing orusing the Programs on behalf of the U.S. Government, the following notice isapplicable:RESTRICTED RIGHTS LEGENDPrograms delivered subject to the DOD FAR Supplement are ’commercialcomputer software’ and use, duplication and disclosure of the Programsincluding documentation, shall be subject to the licensing restrictions set forthin the applicable Oracle license agreement. Otherwise, Programs deliveredsubject to the Federal Acquisition Regulations are ’restricted computer software’and use, duplication and disclosure of the Programs shall be subject to therestrictions in FAR 52.227–19, Commercial Computer Software – RestrictedRights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA94065.The Programs are not intended for use in any nuclear, aviation, mass transit,medical, or other inherently dangerous applications. It shall be licensee’sresponsibility to take all appropriate fail–safe, back up, redundancy and othermeasures to ensure the safe use of such applications if the Programs are used for
such purposes, and Oracle disclaims liability for any damages caused by suchuse of the Programs.Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8,Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials,Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms,Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,PL/SQL, Pro*C and SmartClient are trademarks or registered trademarks of OracleCorporation.All other company or product names are mentioned for identification purposes only, andmay be trademarks of their respective owners.
ContentsChapter 1Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Audience for This Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Other Information Sources . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Online Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Related User Guides . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .User Guides Related to All Products . . . . . . . . . . . . . . . . . . . .Do Not Use Database Tools to ModifyOracle Applications Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Typographic Conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Function Keys . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Command and Example Syntax . . . . . . . . . . . . . . . . . . . . . . . .Case Sensitivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Syntax Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .About Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Your Feedback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .iiiiiiiiiiiiiviviiviiviiviiiixixixOverview of Coding Standards . . . . . . . . . . . . . . . . . . . . . . . . . . .Overview of Coding Standards . . . . . . . . . . . . . . . . . . . . . . . . . . . .Importance of these Standards . . . . . . . . . . . . . . . . . . . . . . . . .Coding Principles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Coding With Handlers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Libraries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Performance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1–11–21–21–21–31–41–5Contentsi
Chapter 2Chapter 3Coding for Web Compatibility . . . . . . . . . . . . . . . . . . . . . . . . .The Standard Development Environment . . . . . . . . . . . . . . . . . . .Oracle Application Object Library for Release 11i . . . . . . . . .Shared Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Standard Libraries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Property Classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Visual Attributes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Overview of Building an Application . . . . . . . . . . . . . . . . . . . . . . .Overall Design Issues to Consider . . . . . . . . . . . . . . . . . . . . . .Overview of Application Development Steps . . . . . . . . . . . .Overview of Form Development Steps . . . . . . . . . . . . . . . . . .1–61–71–91–91 – 111 – 121 – 131 – 151 – 151 – 161 – 17Setting Up Your Application Framework . . . . . . . . . . . . . . . . . . .Overview of Setting Up Your Application Framework . . . . . . . .Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Set Up Your Application Directory Structures . . . . . . . . . . . .Register Your Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Modify Your Environment Files . . . . . . . . . . . . . . . . . . . . . . . .Set Up and Register Your Oracle Schema . . . . . . . . . . . . . . . .Create Database Objects and Integrate withAPPS Schema . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Add Your Application to a Data Group . . . . . . . . . . . . . . . . . .Set Up Concurrent Managers . . . . . . . . . . . . . . . . . . . . . . . . . .Applications Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Applications Block . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2–12–22–22–32–32–42–4Building Your Database Objects . . . . . . . . . . . . . . . . . . . . . . . . . .Overview of Building Your Database Objects . . . . . . . . . . . . . . . .Using Cost–Based Optimization . . . . . . . . . . . . . . . . . . . . . . . .Tracking Data Changes with Record History (WHO) . . . . . .Oracle8i Declarative Constraints . . . . . . . . . . . . . . . . . . . . . . .LONG, LONG RAW and RAW Datatypes . . . . . . . . . . . . . . .Columns Using a Reserved Word . . . . . . . . . . . . . . . . . . . . . . .Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Sequences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Table Registration API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Procedures in the AD DD Package . . . . . . . . . . . . . . . . . . . . .Example of Using the AD DD Package . . . . . . . . . . . . . . . . . .3–13–23–23–23–53–73–73–73 – 103 – 113 – 113 – 13ii Oracle Applications Developer’s Guide2–52–52–52–62–72–7
Chapter 4Using PL/SQL in Oracle Applications . . . . . . . . . . . . . . . . . . . . .Overview of Using PL/SQL in Applications . . . . . . . . . . . . . . . . .Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .General PL/SQL Coding Standards . . . . . . . . . . . . . . . . . . . . .Database Server Side versus Client Side . . . . . . . . . . . . . . . . .Formatting PL/SQL Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Exception Handling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .SQL Coding Guidelines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Triggers in Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Replacements for Oracle Forms Built–ins . . . . . . . . . . . . . . . . . . . .Coding Item, Event and Table Handlers . . . . . . . . . . . . . . . . . . . . .Coding Item Handlers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Coding Event Handlers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Coding Table Handlers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Example Client–Side Table Handler . . . . . . . . . . . . . . . . . . . . .Example Server–Side Table Handler . . . . . . . . . . . . . . . . . . . .4–14–24–34–34–64–74–94 – 114 – 114 – 124 – 144 – 174 – 174 – 194 – 204 – 214 – 24Chapter 5Setting the Properties of Container Objects . . . . . . . . . . . . . . . .Modules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Non–Modal Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Modal Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Canvases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Content Canvases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Stacked Canvases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Blocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Context Blocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Dialog Blocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Data Blocks With No Base Table . . . . . . . . . . . . . . . . . . . . . . .Single–Record Data Blocks . . . . . . . . . . . . . . . . . . . . . . . . . . . .Multi–Record Blocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Combination Blocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Master–Detail Relations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Dynamic WHERE Clauses . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Regions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Tabbed Regions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Alternative Regions (Obsolete for Release 11i) . . . . . . . . . . . .Overflow Regions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5–15–25–35–35–55–85–85–85 – 105 – 115 – 115 – 135 – 135 – 145 – 165 – 165 – 175 – 195 – 195 – 195 – 19Contentsiii
Chapter 6Chapter 7Setting the Properties of Widget Objects . . . . . . . . . . . . . . . . . . .Text Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Date Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Display Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Poplists . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Option Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Check Boxes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Buttons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Lists of Values (LOVs) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .LOV Behaviors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .LOVs in ENTER–QUERY Mode . . . . . . . . . . . . . . . . . . . . . . . .Alerts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Editors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Flexfields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Setting Item Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Using APP ITEM PROPERTY.SET PROPERTY . . . . . . . . . .Item Properties with Unique OracleApplications Behavior . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Impact of Item–level and Item–instance–level Settings . . . . .Setting Properties at Design Time . . . . . . . . . . . . . . . . . . . . . . .Setting Visual Attributes Programatically . . . . . . . . . . . . . . . .6–16–26–36–46–66–86–96 – 106 – 126 – 146 – 156 – 176 – 186 – 196 – 206 – 20Controlling Window, Block and Region Behavior . . . . . . . . . . .Controlling Window Behavior . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Positioning Windows Upon Opening . . . . . . . . . . . . . . . . . . .Closing Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Setting Window Titles Dynamically . . . . . . . . . . . . . . . . . . . . .Controlling Block Behavior . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Coding Master–Detail Relations . . . . . . . . . . . . . . . . . . . . . . . .Implementing a Combination Block . . . . . . . . . . . . . . . . . . . . .Coding Tabbed Regions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Tabbed Region Behavior . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Three Degrees of Coding Difficulty . . . . . . . . . . . . . . . . . . . . .Implementing Tabbed Regions . . . . . . . . . . . . . . . . . . . . . . . . .Tab Handler Logic . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .WHEN–TAB–PAGE–CHANGED Logic . . . . . . . . . . . . . . . . .WHEN–NEW–ITEM–INSTANCE Logic . . . . . . . . . . . . . . . . .Handling Dynamic Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Other Code You May Need . . . . . . . . . . . . . . . . . . . . . . . . . . . .7–17–27–27–37–57–67–67–87 – 127 – 127 – 137 – 147 – 157 – 187 – 187 – 227 – 237 – 25iv Oracle Applications Developer’s Guide6 – 216 – 256 – 266 – 26
Coding Alternative Region Behavior . . . . . . . . . . . . . . . . . . . . . . .Alternative Regions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Example: Coding an Alternative Region . . . . . . . . . . . . . . . . .Controlling Records in a Window . . . . . . . . . . . . . . . . . . . . . . . . . .Duplicating Records . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Renumbering All Records in a Window . . . . . . . . . . . . . . . . .Passing Instructions to a Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7 – 277 – 277 – 277 – 317 – 317 – 327 – 34Chapter 8Enabling Query Behavior . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Overview of Query Find . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Raising Query Find on Form Startup . . . . . . . . . . . . . . . . . . . .Implementing Row–LOV . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Implementing Find Windows . . . . . . . . . . . . . . . . . . . . . . . . . .8–18–28–28–38–4Chapter 9Coding Item Behavior . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Item Relations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Dependent Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Conditionally Dependent Item . . . . . . . . . . . . . . . . . . . . . . . . .Multiple Dependent Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Two Master Items and One Dependent Item . . . . . . . . . . . . .Cascading Dependence . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Mutually Exclusive Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Mutually Inclusive Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Mutually Inclusive Items with Dependent Items . . . . . . . . . .Conditionally Mandatory Items . . . . . . . . . . . . . . . . . . . . . . . .Defaults . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Integrity Checking . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Uniqueness Check . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Referential Integrity Check . . . . . . . . . . . . . . . . . . . . . . . . . . . .The Calendar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Advanced Calendar Options . . . . . . . . . . . . . . . . . . . . . . . . . . .Calendar Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .CALENDAR: Calendar Package . . . . . . . . . . . . . . . . . . . . . . . . . . .CALENDAR.SHOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .CALENDAR.SETUP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .CALENDAR.EVENT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .9–19–29–39–59–69–79–89 – 109 – 129 – 139 – 159 – 189 – 199 – 199 – 209 – 239 – 249 – 269 – 289 – 289 – 289 – 28Chapter 10Controlling the Toolbar and the Default Menu . . . . . . . . . . . . . 10 – 1Pulldown Menus and the Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . 10 – 2Contentsv
Chapter 11Menu and Toolbar Entries . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Save and Proceed . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Synchronizing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Application–Specific Entries: Special Menus . . . . . . . . . . . . .Customizing Right–Mouse Menus (Popup Menus) . . . . . . .APP POPUP: Right–Mouse Menu Control . . . . . . . . . . . . . . . . . .APP POPUP.INSTANTIATE . . . . . . . . . . . . . . . . . . . . . . . . . . .APP SPECIAL: Menu and Toolbar Control . . . . . . . . . . . . . . . . . .APP SPECIAL.INSTANTIATE . . . . . . . . . . . . . . . . . . . . . . . . .APP SPECIAL.ENABLE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .APP SPECIAL.GET CHECKBOX . . . . . . . . . . . . . . . . . . . . . .APP SPECIAL.SET CHECKBOX . . . . . . . . . . . . . . . . . . . . . .10 – 210 – 810 – 810 – 810 – 1010 – 1310 – 1310 – 1510 – 1510 – 1710 – 1810 – 19Menus and Function Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Overview of Menus and Function Security . . . . . . . . . . . . . . . . . .Using Form Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Function Security Standards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .General Function and Menu Standards . . . . . . . . . . . . . . . . . .Form Function Standards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Subfunction Standards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Function Security Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Function Security APIs for PL/SQL Procedures . . . . . . . . . . . . . .FND FUNCTION.TEST . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .FND FUNCTION.QUERY . . . . . . . . . . . . . . . . . . . . . . . . . . . .FND FUNCTION.EXECUTE . . . . . . . . . . . . . . . . . . . . . . . . . .FND FUNCTION.USER FUNCTION NAME . . . . . . . . . . .FND FUNCTION.CURRENT FORM FUNCTION . . . . . . .Forms Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Forms Block . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Form Functions Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Form Functions Block . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Web HTML and Web Host . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Menus Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Menus Block . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .View Tree. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Menu Entries Block . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .11 – 111 – 211 – 811 – 1011 – 1011 – 1111 – 1211 – 1511 – 1611 – 1611 – 1611 – 1711 – 1911 – 1911 – 2011 – 2011 – 2011 – 2211 – 2311 – 2311 – 2311 – 2411 – 2611 – 2711 – 2711 – 28vi Oracle Applications Developer’s Guide
Chapter 12Message Dictionary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Overview of Message Dictionary . . . . . . . . . . . . . . . . . . . . . . . . . . .Major Features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Implementing Message Dictionary . . . . . . . . . . . . . . . . . . . . . . . . .Create Your Message Directories . . . . . . . . . . . . . . . . . . . . . . .Define Your Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Create Your Message Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Code Logic to Set Up Messages . . . . . . . . . . . . . . . . . . . . . . . .Code Logic to Display Messages . . . . . . . . . . . . . . . . . . . . . . .Message Dictionary APIs for PL/SQL Procedures . . . . . . . . . . . .FND MESSAGE.CLEAR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .FND MESSAGE.DEBUG . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .FND MESSAGE.ERASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .FND MESSAGE.ERROR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .FND MESSAGE.GET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .FND MESSAGE.HINT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .FND MESSAGE.QUESTION . . . . . . . . . . . . . . . . . . . . . . . . . .FND MESSAGE.RETRIEVE . . . . . . . . . . . . . . . . . . . . . . . . . . .FND MESSAGE.SET NAME . . . . . . . . . . . . . . . . . . . . . . . . . .FND MESSAGE.SET STRING . . . . . . . . . . . . . . . . . . . . . . . . .FND MESSAGE.SET TOKEN . . . . . . . . . . . . . . . . . . . . . . . . .FND MESSAGE.SHOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .FND MESSAGE.WARN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Application Message Standards . . . . . . . . . . . . . . . . . . . . . . . . . . . .Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Message Naming Standards . . . . . . . . . . . . . . . . . . . . . . . . . . .Message Numbering Standards . . . . . . . . . . . . . . . . . . . . . . . .Message Type Standards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Message Description Standards . . . . . . . . . . . . . . . . . . . . . . . .Message Content Standards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Message Token Standards . . . . . . . . . . . . . . . . . . . . . . . . . . . . .A Few General Guidelines for Writing Good Messages . . . .When the User Needs to Get Help . . . . . . . . . . . . . . . . . . . . . .Complex Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Specific Types of Message Content . . . . . . . . . . . . . . . . . . . . . .Message Writing Style . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Special Purpose Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Messages Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Messages Block . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12 – 112 – 212 – 212 – 312 – 512 – 512 – 512 – 612 – 712 – 812 – 1112 – 1112 – 1112 – 1212 – 1212 – 1312 – 1412 – 1412 – 1712 – 1712 – 1912 – 1912 – 2212 – 2212 – 2412 – 2412 – 2612 – 2712 – 2912 – 3112 – 3312 – 3312 – 3612 – 3812 – 4012 – 4012 – 4312 – 5212 – 5512 – 5612 – 56Contentsvii
Chapter 13User Profiles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Overview of User Profiles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Defining New User Profile Options . . . . . . . . . . . . . . . . . . . . .Setting User Profile Option Values . . . . . . . . . . . . . . . . . . . . . .Setting Your Personal User Profile . . . . . . . . . . . . . . . . . . . . . .Implementing User Profiles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Predefined User Profile Options . . . . . . . . . . . . . . . . . . . . . . . .FND PROFILE: User Profile APIs . . . . . . . . . . . . . . . . . . . . . . . . . .FND PROFILE.PUT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .FND PROFILE.GET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .FND PROFILE.VALUE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .User Profile C Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .afpoget . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .afpoput . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Profiles Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Profiles Block . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Active Dates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .SQL Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .User Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Program Access Block . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .System Administrator Access Block . . . . . . . . . . . . . . . . . . . . .13 – 113 – 213 – 213 – 313 – 413 – 413 – 513 – 513 – 913 – 913 – 1013 – 1013 – 1213 – 1213 – 1213 – 1413 – 1413 – 1513 – 1513 – 1613 – 2113 – 2113 – 21Chapter 14Flexfields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Overview of Flexfields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Building a Flexfield into Your Application . . . . . . . . . . . . . . .Flexfields and Application Upgrades . . . . . . . . . . . . . . . . . . .Implementing Key Flexfields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Defining Key Flexfield Database Columns . . . . . . . . . . . . . . .Registering Your Key Flexfield Table . . . . . . . . . . . . . . . . . . . .Registering Your Key Flexfield . . . . . . . . . . . . . . . . . . . . . . . . .Add Your Flexfield to Your Forms . . . . . . . . . . . . . . . . . . . . . .Implementing Descriptive Flexfields . . . . . . . . . . . . . . . . . . . . . . . .Planning for Reference Fields . . . . . . . . . . . . . . . . . . . . . . . . . .Defining Descriptive Flexfield Database Columns . . . . . . . .Adding a Descriptive Flexfield to a Table withExisting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Protected Descriptive Flexfields . . . . . . . . . . . . . . . . . . . . . . . .Registering Your Descriptive Flexfield Table . . . . . . . . . . . . .14 – 114 – 214 – 514 – 814 – 1014 – 1114 – 1514 – 1814 – 1814 – 1914 – 2014 – 2014 – 21viii Oracle Applications Developer’s Guide14 – 2214 – 2314 – 24
Registering Your Descriptive Flexfield . . . . . . . . . . . . . . . . . .Add Your Flexfield to Your Forms . . . . . . . . . . . . . . . . . . . . . .Adding Flexfields to Your Forms . . . . . . . . . . . . . . . . . . . . . . . . . . .Create Your Hidden Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Create Your Displayed Fields . . . . . . . . . . . . . . . . . . . . . . . . . .Create Your Flexfield Definition . . . . . . . . . . . . . . . . . . . . . . . .Invoke Your Flexfield Definition from SeveralEvent Tri
Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,
Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,
xii Oracle Workflow Developer's Guide Audience for This Guide Welcome to the Oracle Workflow Developer's Guide. This guide assumes you have a working knowledge of the following: The principles and customary practices of your business area. Oracle Workflow Oracle Workflow Developer's Guide. Workflow.
Changes in Oracle SQL Developer Release 18.1 xlviii 1 SQL Developer Concepts and Usage 1.1 About SQL Developer 1-2 1.2 Installing and Getting Started with SQL Developer 1-2 1.3 SQL Developer User Interface 1-3 1.3.1 Menus for SQL Developer
7 Messaging Server Oracle Oracle Communications suite Oracle 8 Mail Server Oracle Oracle Communications suite Oracle 9 IDAM Oracle Oracle Access Management Suite Plus / Oracle Identity Manager Connectors Pack / Oracle Identity Governance Suite Oracle 10 Business Intelligence
Advanced Replication Option, Database Server, Enabling the Information Age, Oracle Call Interface, Oracle EDI Gateway, Oracle Enterprise Manager, Oracle Expert, Oracle Expert Option, Oracle Forms, Oracle Parallel Server [or, Oracle7 Parallel Server], Oracle Procedural Gateway, Oracle Replication Services, Oracle Reports, Oracle
Specific tasks you can accomplish using Oracle Sales Compensation Oracle Oracle Sales Compensation setup Oracle Oracle Sales Compensation functions and features Oracle Oracle Sales Compensation windows Oracle Oracle Sales Compensation reports and processes This preface explains how this user's guide is organized and introduces
Oracle Compute hosting Oracle Data Integrator, the Oracle BI Applications Configuration Manager and Oracle Database Cloud Service. See detailed deployment documentation published on Oracle Support. (Figure 2) Hybrid solutions deploy the BI semantic model, analyses and dashboards on Oracle Analytics Cloud with Oracle Data Integrator and Oracle .
“Explosive, thrilling, action-packed – meet Alex Rider.” Guardian “Horowitz is pure class, stylish but action-packed being James Bond in miniature is way cooler than being a wizard.” Daily Mirror “Horowitz will grip you with suspense, daring and cheek – and that’s just the first page! Prepare for action scenes as fast as a movie.” The Times “Anthony Horowitz is the .
