Oracle Applications Developer’s Guide

Oracle
ApplicationsDeveloper’sGuideRELEASE11iVOLUME1April2001OracleApplicationsDeveloper’sGuide,RELEASE11iVOLUME1ThepartnumberforthisvolumeisA83705–03.Toreorderthisbook,pleaseusethesetpartnumber,A75545–03.Copyright1995,2001OracleCorporation.Allrightsreserved.ContributingAuthors:AnneCarlson,EmilyNordhagen,LisaNordhagen,DanaSpradley,MartinTaylor,PeterWallack,MillieWang,SaraWoodhullContributors:RamBhoopalam,EricBing,StevenCarter,CliffGodwin,MarkFisher,MichaelKonopik,MichaelMast,TomMorrow,RobertNix,GursatOlgun,SusanStratton,LeslieStuddard,VenkataVengala,MaxineZasowskiThePrograms(whichincludeboththesoftwareanddocumentation)containproprietaryinformationofOracleCorporation;theyareprovidedunderalicenseagreementcontainingrestrictionsonuseanddisclosureandarealsoprotectedbycopyright,patentandotherintellectualpropertylaw.ReverseengineeringoftheProgramsisprohibited.Nopartofthisdocumentmaybereproducedortransmittedinanyformorbyanymeans,electronicormechanical,foranypurpose,withouttheexpresswrittenpermissionofOracleCorporation.ProgramDocumentationislicensedforusesolelytosupportthedeploymentoftheProgramsandnotforanyotherpurpose.Theinformationcontainedinthisdocumentissubjecttochangewithoutnotice.Ifyoufindanyproblemsinthedocumentation,pleasereportthemtousinwriting.OracleCorporationdoesnotwarrantthatthisdocumentiserrorfree.ExceptasmaybeexpresslypermittedinyourlicenseagreementforthesePrograms,nopartoftheseProgramsmaybereproducedortransmittedinanyformorbyanymeans,electronicormechanical,foranypurpose,withouttheexpresswrittenpermissionofOracleCorporation.IftheProgramsaredeliveredtotheU.S.GovernmentoranyonelicensingorusingtheProgramsonbehalfoftheU.S.Government,thefollowingnoticeisapplicable:RESTRICTEDRIGHTSLEGENDProgramsdeliveredsubjecttotheDODFARSupplementare’commercialcomputersoftware’anduse,duplicationanddisclosureoftheProgramsincludingdocumentation,shallbesubjecttothelicensingrestrictionssetforthintheapplicableOraclelicenseagreement.Otherwise,ProgramsdeliveredsubjecttotheFederalAcquisitionRegulationsare’restrictedcomputersoftware’anduse,duplicationanddisclosureoftheProgramsshallbesubjecttotherestrictionsinFAR52.227–19,CommercialComputerSoftware–RestrictedRights(June,1987).OracleCorporation,500OracleParkway,RedwoodCity,CA94065.TheProgramsarenotintendedforuseinanynuclear,aviation,masstransit,medical,orotherinherentlydangerousapplications.Itshallbelicensee’sresponsibilitytotakeallappropriatefail–safe,backup,redundancyandothermeasurestoensurethesafeuseofsuchapplicationsiftheProgramsareusedforsuchpurposes,andOracledisclaimsliabilityforanydamagescausedbysuchuseofthePrograms.OracleisaregisteredtrademarkandOracle7,Oracle8,OracleApplicationObjectLibrary,OracleApplica-tions,OracleAlert,OracleFinancials,OracleWorkflow,SQL*Forms,SQL*Plus,SQL*Report,OracleDataBrowser,OracleForms,OracleGeneralLedger,OracleHumanResources,OracleManufacturing,OracleReports,PL/SQL,Pro*CandSmartClientaretrademarksorregisteredtrademarksofOracleCorporation.Allothercompanyorproductnamesarementionedforidentificationpurposesonly,andmaybetrademarksoftheirrespectiveowners.iContentsContentsVolume1VOLUME1i.........................Prefacei.................................................AudienceforThisGuideii..............................OtherInformationSourcesii.............................DoNotUseDatabaseToolstoModifyOracleApplicationsDatavi....................................TypographicConventionsvii.............................AboutOracleix........................................YourFeedbackix.......................................Chapter1OverviewofCodingStandards1–1...........................OverviewofCodingStandards1–2............................ImportanceoftheseStandards1–2.........................CodingPrinciples1–2....................................CodingWithHandlers1–3................................Libraries1–4............................................Performance1–5.........................................CodingforWebCompatibility1–6.........................TheStandardDevelopmentEnvironment1–7...................OracleApplicationObjectLibraryforRelease11i1–9.........SettingObjectCharacteristics1–9..........................SharedObjects1–10.......................................StandardLibraries1–11....................................iiOracleApplicationsDeveloper’sGuidePropertyClasses1–13.....................................VisualAttributes1–14.....................................OverviewofBuildinganApplication1–15.......................OverallDesignIssuestoConsider1–15......................OverviewofApplicationDevelopmentSteps1–16............OverviewofFormDevelopmentSteps1–17..................Chapter2SettingUpYourApplicationFramework2–1...................OverviewofSettingUpYourApplicationFramework2–2........Definitions2–2..........................................SetUpYourApplicationDirectoryStructures2–3............RegisterYourApplication2–3.............................ModifyYourEnvironmentFiles2–4........................SetUpandRegisterYourOracleSchema2–4....