Content area API constants

Related topics

This topic presents the constants that can be used with the following API packages:

wwsbr_api constants

wwsbr_search_api constants

Warning - These APIs are not available in Oracle9iAS Portal 9.0.2.

Constant names and values for wwsbr_api

General

IS_ON

constant number := 1

IS_OFF

constant number :=0;

YES

constant number := 1;

NO

constant number := 0;

Versioning options

VERSIONING_AUDIT

constant varchar2(30) := 'versionaudit';

VERSIONING_SIMPLE

constant varchar2(30) := 'versionsimple';

VERSIONING_NONE

constant varchar2(30) := 'versionnone';

Security options

ITEM_ACCESS

constant varchar2(30) := 'item';

FOLDER_ACCESS

constant varchar2(30) := 'folder';

Item related constants

PERMANENT

constant varchar2(20) := 'PERMANENT';

EXP_NUMBER

constant varchar2(20) := 'NUMBER';

EXP_DATE

constant varchar2(20) := 'DATE'

Image alignment constants

ALIGN_LEFT

constant varchar2(30) := 'left';

ALIGN_RIGHT

constant varchar2(30) := 'right';

ALIGN_TOP

constant varchar2(30) := 'top';

ALIGN_BOTTOM

constant varchar2(30) := 'bottom';

ALIGN_ABSOLUTE_MIDDLE

constant varchar2(30) := 'absmiddle';

ALIGN_ABSOLUTE_BOTTOM

constant varchar2(30) := 'absbottom';

ALIGN_TEXT_TOP

constant varchar2(30) := 'texttop';

ALIGN_MIDDLE

constant varchar2(30) := 'middle';

ALIGN_BASELINE

constant varchar2(30) := 'baseline';

Item display options

Link that displays item in folder area

IN_FRAME

constant varchar2(30) := 'inframe';

Item displayed directly in folder area

IN_PLACE

constant varchar2(30) := 'inplace';

Link that displays item in full Browser window

FULL_SCREEN

constant varchar2(30) := 'fullscreen';

Link that displays item in new Browser window

NEW_WINDOW

constant varchar2(30) := 'newbrowserwindow';

PL/SQL executemode options

DB_USER

constant varchar(20) := 'db_user';

PUBLIC_SCHEMA

constant varchar2(20) := '$PUBLIC$';

CREATOR_SCHEMA

constant varchar2(20) := '$CREATOR$';

Shared content area id (can be used as value for any _caid parameter)

SHARED_OBJECTS

constant number := 0;

General category id (can be used as value for any p_category_id parameter)

GENERAL_CATEGORY

constant number := 30;

Folder type constants (can be used as p_type_id value for add_folder).

All of these item types belong to content area 0

FOLDER_TYPE_CONTAINER

constant number := 1;

FOLDER_TYPE_URL

constant number := 2;

FOLDER_TYPE_SEARCH

constant number := 3;

FOLDER_TYPE_PLSQL

constant number := 4;

Item type constants (can be used as p_type_id value for add_item).

All of these item types belong to content area 0

ITEM_TYPE_FILE

constant number := 1;

ITEM_TYPE_TEXT

constant number := 2;

ITEM_TYPE_URL

constant number := 3;

ITEM_TYPE_FOLDER_LINK

constant number := 4;

ITEM_TYPE_PLSQL

constant number := 5;

ITEM_TYPE_APP_COMP

constant number := 6;

ITEM_TYPE_IMAGE

constant number := 8;

ITEM_TYPE_JAVA_APP

constant number := 11;

ITEM_TYPE_ZIP_FILE

constant number := 12;

Java item type

APP_TYPE_JSP

constant varchar2(30) := 'jsp';

content area id array

subtype g_caid_array is wwsbr_type.array;
g_empty_caid_array g_caid_array;

perspective related declarations

subtype g_perspectiveidarray is wwv_perspectivedb.perspectiveidarray;
g_perspectiveidemptyarray g_perspectiveidarray

basic array related declarations

subtype g_array is wwsbr_type.array;
g_empty_array g_array;

region array

subtype g_region_array is wwsbr_folder_region.region_array;

Constant names and values for wwsbr_search_api

YES

constant number := 1;

NO

constant number := 0;

Search operator constants

FIND_ANY

constant varchar2(10) := 'ANY';

FIND_ALL

constant varchar2(10) := 'ALL';

Search type constants

ALL_OBJECTS

constant varchar2(10) := 'ALL';

FOLDERS

constant varchar2(10) := 'FOLDERS';

ITEMS

constant varchar2(10) := 'ITEMS';

Attribute operator constants

CONTAINS_ALL

constant varchar2(20) := 'containsall';

GREATER_THAN

constant varchar2(20) := 'greaterthan';

LESS_THAN

constant varchar2(20) := 'lessthan';

EQUAL_TO

constant varchar2(20) := 'equal';

Related topics
Content area API package	PDK PL/SQL API Reference - Home