Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 About these Tutorials

• What this Book Is Not
• Tutorial Topics
• About Loading Sample Objects
  • Downloading OEHR Sample Objects
  • Importing and Installing OEHR Sample Objects
  • Viewing Database Objects
• About Application Authentication

2 How to Create a Tabular Form

• Creating an Application
• Creating a Tabular Form Using a Wizard
• Changing an Updatable Column to a Select List
  • Create a Named List of Values
  • Edit the Column to Display as a Select List

3 How to Create a Parameterized Report

• Introducing Application Express Reports
  • Overview of Report Types
  • Selecting the Appropriate Report Type
• Creating an Application with Interactive Reports
  • Create and Populate the Database Objects
  • Create the Application
  • Preview the Application
• Add Columns of Data from Other Tables
• Using an Interactive Report
  • Introducing Interactive Report Components
  • Adding a Filter to a Report
  • Saving Report Settings and Selecting Columns
  • Resetting to the Default Report Settings
• Related Documentation

4 Using Advanced Report Techniques

• Create the Basic Application
  • Create and Populate the Database Objects
  • Create the Application
  • Run the Application
• Display People and Project Names
  • Change the Query to Retrieve Values from Other Tables
  • Add Name Value Columns to the Display
• Add a Dashboard Page
  • Create a Dashboard Page
  • Add a Link on the Home Page to the Dashboard
  • Add an Overdue Issues Report Region to the Dashboard
  • Add an Open Issues by Project Pie Chart
• Related Documentation

5 How to Control Form Layout

• Creating a Table and Data Input Form
  • Create the HT_EMP Table
  • Create a New Application
  • Create a New Page Containing an Input Form
  • Run the Page
• Changing the Appearance of a Page by Altering Region Attributes
  • Edit the Region Title
  • Change the Display Point and Template
  • Change the Region Attributes Back to the Original Selections
• Understanding How Item Attributes Affect Page Layout
  • Edit Item Attributes
  • Fix Item Alignment
  • Change a Region to Display-only
• Adding a Region Header and Footer
• Making a Region Conditional
• Adding a Region to Contain Hint Text
• Changing Item Types
  • Change an Item to a Radio Group
  • Change an Item to a Select List
  • Change an Item to a Check Box
• About Label Templates
• Changing Buttons
• Running the Page for Update
• Making Data Bold

6 How to Work with Check Boxes

• Creating an Application
  • Run the Application
• Editing the Update Form
  • Hide the Warranty Period Field
  • Add a New Checkbox
• Change the Report Display
• Create Multi Value Check Boxes to Filter Content
  • Change the Search Field to a Multi Value Check Box
  • Edit the Report Region Definition
  • Change the Default Check Box Behavior
  • Change the Check Boxes to Display in Bold
• Adding Check Boxes to Each Row in the Report
  • Call APEX_ITEM.CHECKBOX
  • Add a Button to Submit Check Box Array Values
  • Add a Process

7 How to Implement a Web Service

• About Creating Web Service References
• Creating a New Application
• Specifying an Application Proxy Server Address
• Creating a Web Service Reference from a WSDL
  • Create a Form and Report
• Creating a Web Service Reference Manually
  • Create a Web Service Reference Manually
  • Test the Web Service
  • Create a Page to Call the Manual Web Service
  • Create a Submit Button
  • Create Items for ZIP Code and Radius
  • Create a Process to Call the Manually Created Web Reference
  • Create a Report on the Web Service Result

8 How to Create a Stacked Bar Chart

• About the Syntax for Creating Chart Queries
• Creating an Application
• Creating a New Page
• Adding Additional Series
• Updating the Sample Data
• Viewing the Chart
• Editing Chart Attributes

9 How to Upload and Download Files in an Application

• Creating an Application
• Creating an Upload Form
  • Create an HTML Region
  • Create an Upload Item
  • Create a Button
• Creating a Report with Download Links
  • Create a Report on APEX_APPLICATION_FILES
  • Add Link to Download Documents
• Storing Additional Attributes About the Document
  • Create a Table to Store Document Attributes
  • Create an Item to Capture the Document Subject
  • Create a Process to Insert Information
  • Show Additional Attributes in the Report Region
• Storing the Document in a Custom Table
• Downloading Documents from the Custom Table
  • Create a Procedure to Download Documents
  • Edit the Uploaded Files Region
  • Change the Download Link to Use the New Procedure
  • Create Download Page for Embedded PL/SQL Gateway
• Security Issues to Consider

10 How to Incorporate JavaScript into an Application

• Understanding How to Incorporate JavaScript Functions
  • Incorporating JavaScript in the HTML Header Attribute
  • Including JavaScript in a .js File Referenced by the Page Template
• About Referencing Items Using JavaScript
• Calling JavaScript from a Button
• Changing the Value of Form Elements
• Creating a Client Side JavaScript Validation
  • Create an Application on the OEHR_EMPLOYEES Table
  • Add a Function to the HTML Header Attribute
  • Edit an Item to Call the Function
  • Test the Validation by Running the Page
• Enabling and Disabling Form Elements
  • Add a Function to the HTML Header Attribute
  • Edit an Item to Call the Function
  • Change the Item to a Select List
  • Create a Call to the disFormItems Function

11 How to Build an Access Control Page

• How Access Control Administration Works
• Creating an Application
  • Download Spreadsheet Data
  • Create an Application Based on Spreadsheet Data
  • Run the Application
• Creating an Access Control Administration Page
  • Create an Access Control Page
  • View the Page
  • Add Users to the Access Control List
• Creating an Authentication Function
• Updating the Current Authentication Scheme
• Applying Authorization Schemes to Components
  • Associate an Authorization Scheme with the Application
  • Associate Edit Privileges with the ID Column
  • Associate Edit Privileges with the Create Button
  • Associate Edit Privileges with Page 2
  • Restrict Access to Page 8
• Testing the Application
  • Log In with View Privileges
  • Log In with Edit Privileges
  • Log In with Administrator Privileges

12 How to Review a Packaged Application

• What Is a Packaged Application?
• About the Supporting Object Utility
  • Accessing the Supporting Objects Page
• About Supporting Objects Installation
  • Welcome Message
  • Prerequisites
  • License Acceptance
  • Application Substitution Strings
  • Build Options
  • Pre-Installation Validations
  • Pre-Installation Confirmation Message
  • Installation Scripts
  • Success Message
• About Supporting Objects Deinstallation
  • View the Deinstallation Confirmation Message
  • Review the Deinstallation Script
  • View the Deinstallation Success Message
• About Supporting Objects Export
  • Review the Supporting Objects Export Setting
  • Where the Export Default Appears When Exporting
• About Creating Upgrade Scripts
  • Utilizing Upgrade Messages
• About Refining Your Installation Scripts
• Downloading Public Packaged Applications and Sample Code

13 How to Create a Master Detail PDF Report

• About Oracle BI Publisher Licensing Requirements
  • Viewing a Hosted Version of the Application
• Loading the Required Objects
  • Download the Packaged Application
  • Import and Install the Packaged Application
• Creating a Master Detail Form
  • View the Report
• Creating the Report Query
• Creating the RTF Template
  • Download Oracle BI Publisher Desktop
  • Load the XML Details
  • Insert the Fields
  • Include Line Items
• Creating the Report Layout
  • Create a Report Layout
  • Associate the Report Layout and Report Query
• Linking the PDF Report to the Application
  • Create a Button
  • Run the Page
• About Creating One PDF Containing All Orders

14 How to Design an Issue Tracking Application

• Planning and Project Analysis
  • Planning and Project Analysis
• Designing the Database Objects
  • About the Projects Table
  • About the People Table
  • About the Issues Table
• Implementing Database Objects
  • Additional Database Objects Needed
  • About Building Database Objects
  • Create and Run a Script to Build Database Objects
  • View the Created Database Objects
• Loading Demonstration Data

15 How to Build and Deploy an Issue Tracking Application

• Issue Tracker Application Overview
  • Issue Tracker User Interface
  • Issue Tracker Architecture
• Building a Basic User Interface
  • Create the Basic Application
  • Add Navigation Image List to Home Page
  • Add Pages to Maintain Projects
  • Add Pages to Track Users
  • Add Pages to Track Issues
  • Add Pages for Summary Reports
  • Add a Dashboard Page
• Adding Advanced Features
  • Add Support for Email Notification
  • Add Application Security
• Deploying Your Application
  • Move the Application Definition
  • Alternate Authentication Mechanisms to Consider
  • Create Users
  • Publish the URL

A DDLs and Scripts

• Creating Application Database Objects DDL
• Creating Issues Script