List of Tables

2-1 Portlet Building Technologies Comparison Matrix

3-1 OmniPortlet Wizard and Edit Defaults

3-2 Supported Data Source Types

4-1 Column Properties for the Weather Forecast Portlet

6-1 Deployment Settings for EAR File, Portal and Wireless

6-2 Create Data Source Settings

6-3 Deployment Settings for EAR File, non-Portal and Wireless

6-4 General Portlet Properties Values

6-5 Name and Attribution Values

6-6 Settings for New OC4J Oracle Application Server Connection

6-7 Settings for New OC4J Standalone Connection

6-8 Register Provider Page Values

6-9 Public Portlet Parameter

6-10 Settings for New Application Server Connection

6-11 Provider Information Page Values

7-1 Events

7-2 PDK-Java JNDI Variables

7-3 Device Classes

7-4 Equivalent HTML and SimpleResult Utilities

8-1 Show Mode Constants in wwpro_api_provider

8-2 Recommended Functions and Procedures for PL/SQL Portlets

8-3 XML Tags for PL/SQL Generator Input

8-4 Changes to starter_provider2.pkb

8-5 Context Information Function Calls

8-6 Portlet Record Attributes

8-7 DeviceClass Header Values

8-8 Required provider_record Fields

9-1 Mapping of Release 1 Terminology to Current Terminology

11-1 Editable Page Record Properties

11-2 Attribute Values for Base Attributes

13-1 Search Results to Secure View Mapping

16-1 AQ Message Properties Set by CMEF

16-2 CMEF Message Payload Properties

A-1 Types of Portlets Available Through Portlet-Building Wizards

A-2 Form-Level Formatting and Validation Options

A-3 Formatting and Validation Options for Buttons

A-4 Formatting and Validation Options for Table or View Columns

A-5 Form Text Options on Tabular Format Forms

A-6 Additional PL/SQL Code Options

A-7 Options on the Column Conditions Page

A-8 Column Formatting Options for a Tabular Report

A-9 Examples of Date Format Masks

A-10 Examples of Number Format Masks

A-11 Options on the Formatting Conditions Page of the Report Wizard

A-12 Report Display Options Common to All Views

A-13 Report Display Options for Full Web-Page and Portlet Views

A-14 Report Display Options for Column Breaks

A-15 Report Display Options for Row Order

A-16 Report Display Options for Mobile Devices

A-17 Display Options for the Personalization Form Display Options Page

A-18 Button Display Options for the Personalization Form Display Options Page

A-19 Options for Including Text on a Report or a Report Personalization Form

A-20 Options for Executing PL/SQL Code During Report Publication

A-21 Data Selection Options for Charts

A-22 Options on the Column Conditions Page

A-23 Options on the Formatting Conditions Page of the Chart Wizard

A-24 Display Options Common to All Chart Views

A-25 Display Options Applying to Full Web-Page Chart Views

A-26 Display Options for Charts Viewed as Portlets

A-27 Display Options for Charts Viewed on Mobile Devices

A-28 Chart Personalization Form Display Options

A-29 Chart Personalization Form Formatting Options

A-30 Chart Personalization Form Public Formatting Options

A-31 Chart Personalization Form Button Options

A-32 Options Available on the Chart and Personalization Form Text Page

A-33 Options Available on the Additional PL/SQL Code Page

A-34 Portlet Actions Associated with Portlet Privilege Levels

A-35 Suggested Batch-Handling Settings for the init.ora File

A-36 Constants for Applications and Schemas for Portlet Builder Components

A-37 Examples of the Use of Constants

A-38 owa_cookie Subprograms and Data Types

A-39 Shared Components Provider Access Privileges

A-40 Unstructured UI Template Substitution Tags

A-41 Team Details Report Column Heading Text

A-42 Team Details Report Full Page and Portlet Display Options

A-43 Average Salaries Chart Full Page and Portlet Display Options

A-44 Team Bonuses Report Column Heading Text

A-45 Team Bonuses Report Full Page and Portlet Display Options

C-1 Elements of application.xml

C-2 Application Tab Settings

C-3 JNDI Variables for Provider Deployment

D-1 runTest Options

E-1 Secure Content Repository Views

E-2 WWSBR_ALL_CATEGORIES

E-3 WWSBR_ALL_CONTENT_AREAS

E-4 WWSBR_ALL_FOLDER_REGIONS

E-5 WWSBR_ALL_FOLDERS

E-6 WWSBR_ALL_ITEMS

E-7 WWSBR_ALL_NAVIGATION_BARS

E-8 WWSBR_ALL_PERSPECTIVES

E-9 WWSBR_ALL_STYLES

E-10 WWSBR_APPROVER

E-11 WWSBR_ATTRIBUTES

E-12 WWSBR_CONTENT_AREA_APPROVAL

E-13 WWSBR_CONTENT_AREA_ITEM_TYPES

E-14 WWSBR_FOLDER_ATTRIBUTES

E-15 WWSBR_FOLDER_PERSPECTIVES

E-16 WWSBR_FOLDER_TYPE_ATTRIBUTES

E-17 WWSBR_FOLDER_TYPES

E-18 WWSBR_ITEM_APPROVAL

E-19 WWSBR_ITEM_ATTRIBUTES

E-20 WWSBR_ITEM_PERSPECTIVES

E-21 WWSBR_ITEM_TYPE_ATTRIBUTES

E-22 WWSBR_ITEM_TYPES

E-23 WWSBR_SUBSCRIPTION

E-24 WWSBR_USER_FOLDERS

E-25 WWSBR_USER_PAGES

F-1 Adding and Editing Items

F-2 Copying and Moving Items

F-3 Deleting and Restoring Items

F-4 Defining Item Privileges

F-5 Item Versioning

F-6 Item Approvals

F-7 Adding and Editing Pages

F-8 Deleting Pages

F-9 Defining Page Privileges

F-10 Adding and Editing Tabs

F-11 Adding and Editing Page Groups

F-12 Deleting and Purging Page Groups

F-13 Defining Page Group Privileges

F-14 Page Group Translations