| 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

Back to top
The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio