|
OracleAS Portal PL/SQL API Reference - 10.1.2 | |||||||
| PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES | |||||||
| VIEW SUMMARY | VIEW DETAIL | |||||||
This document describes the supported database views in the OracleAS Portal content repository.
These views allow developers to build custom queries against the content repository. Direct access to other tables and views in the repository is not supported, as the definition of those tables and views may change between releases.
These views are backward compatible with the Oracle9iAS Portal Release 1 (3.0.9) content area views, except as noted. To maintain compatibility, many of the view and column names continue to use Release 1 terminology, i.e. Page Groups are referred to as Content Areas, etc.
| Release 2 Terminology | Release 1 Terminology |
| Page Groups | Content Areas |
| Pages | Folders |
| Navigation Pages | Navigation Bars |
Other than view and column names, this document employs OracleAS Portal Release 2 terminology.
In this release, OracleAS Portal 10.1.2 views are backwards compatible with 3.0.9 views, with the following exceptions:
New views and columns to support the new Release 2 functionality have been added to the API set, as noted in this documentation. For a full description of the new OracleAS Portal Release 2 functionality and how it compares to the Oracle Portal Release 1 (3.0.9) release, refer to the OracleAS Portal Release 2 Upgrade Guide or the Technical Note entitled What Happened to Content Areas? Both these documents are available on Portal Center at http://portalcenter.oracle.com.
select ...
from WWSBR_ALL_ITEMS items, WWSBR_ALL_FOLDERS pages
where items.folder_id = pages.id
and items.caid = pages.caid
and items.language = pages.language
For example, to select the translations in the current browser session for all pages in a given page group:
select p.display_name title
from wwsbr_all_folders p
where p.caid = 1
and (p.language = wwctx_api.get_nls_language() -- get the current language for the browser session
or ( exists -- a row for the page in the page group default language
(select pg.id
from wwsbr_all_content_areas pg
where pg.id = p.caid
and pg.default_language = p.language
)
and not exists -- a row for the page in the current language
(select p2.id
from wwsbr_all_folders p2
where p2.id = p.id
and p2.language = wwctx_api.get_nls_language()
)
)
)
For example, to select items created by the current user:
select ...
from WWSBR_ALL_ITEMS
where creator = WWCTX_API.GET_USER
For example, to set context to the user "GEORGE" with the password "welcome":
DECLARE
p_user_name VARCHAR2(60) := 'GEORGE';
p_password VARCHAR2(60) := 'welcome';
p_company VARCHAR2(60) := NULL;
BEGIN
wwctx_api.set_context(p_user_name,p_password,p_company);
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
RAISE;
END;It is currently not possible to change the language context in an external environment. All programs execute with the default language of the portal.
Use the script sbrapi.sql, located in the directory ORACLE_HOME/portal/admin/plsql/wws, to grant access to these views. This script:
You must run sbrapi.sql as the Portal schema owner (SCHEMA_OWNER).
>| View Summary | ||
WWSBR_ALL_FOLDERS |
Describes pages on which the current user has view privilege or higher. | |
WWSBR_USER_FOLDERS |
Describes pages on which the current user has manage privilege or higher. | |
WWSBR_FOLDER_PERSPECTIVES |
Describes the perspectives associated with pages viewable by the current user. | |
WWSBR_FOLDER_ATTRIBUTES |
Describes the attributes associated with pages viewable by the current user. | |
WWSBR_ALL_ITEMS |
Describes the items viewable by the current user. |
|
WWSBR_ITEM_PERSPECTIVES |
Describes the perspectives associated with items viewable by the current user. | |
WWSBR_ITEM_ATTRIBUTES |
Describes the attributes and attribute values associated with items viewable by the current user. | |
WWSBR_ALL_CATEGORIES |
Describes all categories. | |
WWSBR_ALL_PERSPECTIVES |
Describes all perspectives. | |
WWSBR_ALL_CONTENT_AREAS |
Describes all page groups. | |
WWSBR_ATTRIBUTES |
Describes all attributes. | |
WWSBR_ITEM_TYPES |
Describes all item types. | |
WWSBR_CONTENT_AREA_ITEM_TYPES |
Describes which item types are available to which page groups. | |
WWSBR_ITEM_TYPE_ATTRIBUTES |
Describes the attributes that are available within each item type. | |
WWSBR_FOLDER_TYPES |
Describes all page types. | |
WWSBR_FOLDER_TYPE_ATTRIBUTES |
Describes the attributes that are available within each page type. | |
WWSBR_ALL_NAVIGATION_BARS |
Describes all navigation pages viewable by the current user. | |
WWSBR_ALL_STYLES |
Describes all styles. | |
WWSBR_ALL_FOLDER_REGIONS |
Describes all page regions on pages viewable by the current user. | |
| View Detail |
Describes pages on which the current user has view privilege or higher.
Name Null? Type
----------------------------------------- -------- ----------------
ID NOT NULL NUMBER
CAID NOT NULL NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
PARENT_ID NUMBER
NAME NOT NULL VARCHAR2(60)
DISPLAY_NAME NOT NULL VARCHAR2(256)
CATEGORY_ID NUMBER
CATEGORY_SITEID NUMBER
DESCRIPTION VARCHAR2(2000)
TYPE_ID NOT NULL NUMBER
TYPE_SITEID NOT NULL NUMBER
BASE_TYPE_ID NOT NULL NUMBER
IS_PORTLET NOT NULL NUMBER(1)
IS_CACHING_ON VARCHAR2
CACHE_MODE NUMBER(1)
SUB_FOLDER_SEQUENCE NUMBER
DISPLAY_IN_PARENT_FOLDER NOT NULL NUMBER(1)
ITEMVERSIONING VARCHAR2(30)
STYLE_ID NOT NULL NUMBER
STYLE_CAID NOT NULL NUMBER
URL_VALUE VARCHAR2(4000)
SEARCH_VALUE VARCHAR2(2000)
PLSQL_VALUE VARCHAR2(2000)
IMAGE VARCHAR2(350)
TITLE_IMAGE_NAME VARCHAR2
ROLLOVER_IMAGE_NAME VARCHAR2(350)
BANNER_IMAGE_NAME VARCHAR2
NAVIGATION_BAR_ID VARCHAR2
NAVIGATION_BAR_CAID VARCHAR2
IS_PUBLIC NOT NULL NUMBER(1)
ITEM_LEVEL_SECURITY NOT NULL NUMBER(1)
DISPLAY_FULL_SCREEN VARCHAR2
PLSQL_FOLDER_EXECUTOR VARCHAR2(30)
CREATEDATE DATE
CREATOR VARCHAR2(256)
UPDATEDATE DATE
UPDATOR VARCHAR2(256)
id caid language id - unique identifier of the page within the
page group caid - id of the page group. FK to
WWSBR_ALL_CONTENT_AREAS.ID. language - language code parent_id - id of the parent page. "0" (zero)
if root page of page group name - internal name for the page. Must be
unique within parent page.display_name - page display name, or Titlecategory_id - id for the category assigned to
the page. FK to WWSBR_ALL_CATEGORIES.ID. category_siteid - page group id for the
category assigned to the page. FK to WWSBR_ALL_CATEGORIES.CAID. description - description of the page type_id - id of the page type. FK to
WWSBR_FOLDER_TYPES.ID. type_siteid - page group id for the page
type. FK to WWSBR_FOLDER_TYPES.CAID. base_type_id - the id of the page base type.
FK to WWSBR_FOLDER_TYPES.ID where
WWSBR_FOLDER_TYPES.IS_BASE_FOLDER_TYPE = 1. is_portlet - indicates if the page is
published as a portlet. Valid values: 0 - not a portlet, 1 - is a
portlet.is_caching_on - DEPRECATED. This column is
retained for backwards compatibility only. Its value is always null. cache_mode - the caching mode for the page.
Valid values: 2 - no caching, 1 - Cache Page Definition Only, 0 - Cache
Page Definition And Content For x Minutes, 4 - Cache Page Definition
Only at System Level, 3 - Cache Page Definition and Content at System
Level for x Minutes. sub_folder_sequence - the sequence (order) of
the page on its parent page's sub page region display_in_parent_folder - indicates if the
page is displayed on its parent page's sub page region itemversioning- Determines the level of item
versioning for the page. Valid values are: versionnone - No Versioning,
versionsimple - Simple Versioning, versionaudit - Audit Versioning.
Note that the page property overrides the page group setting for itemversioning,
but only if the page is set to a higher value. Thus, if the page group
is set to versionnone, the page can specify all three
levels. If the page group specifies versionsimple, the
page can implement either versionsimpleor versionaudit-
a setting of versionnoneis ignored. If the page group
specifies versionaudit, the page can only implement versionaudit-
the other settings will be ignored. style_id -
id for the style used by the page. FK to WWSBR_ALL_STYLES.ID. style_caid - page group id for the style used
by the page. FK to WWSBR_ALL_STYLES.CAID. url_value - url value for a URL type page search_value- DEPRECATED. Search pages are no
longer supported in Release 2. This column is retained for backwards
compatibility only. plsql_value - plsql value
for a PL/SQL type page image - unique name of the image associated
with the page. Matches the NAME column in the document table.title_image_name - DEPRECATED. This column is
retained for backward compatibility only. rollover_image_name - the unique name of the
rollover image associated with the page. Matches the NAME column in the
document table.banner_image_name - DEPRECATED. Banner images
are no longer supported in Release 2. This column is retained for
backward compatibility only. navigation_bar_id - DEPRECATED. This column
is retained for backward compatibility only. navigation_bar_caid - DEPRECATED. This column
is retained for backward compatibility only. is_public - indicates that the page is
viewable by PUBLIC. Valid values are 0 - not public, 1 - public. item_level_security - indicates that item
level security is enabled for the page. Valid values are 0 - ILS
disabled, 1 - ILS enabled. plsql_folder_executor - for PL/SQL type
pages, the database schema used to execute the PL/SQL codecreatedate - date the page was createdcreator - username of the person who created
the page updatedate - date the page was last updated updator - username of the person who last
updated the pageDescribes pages on which the current user has manage privilege or higher.
Name Null? Type
----------------------------------------- -------- ------------------
ID NOT NULL NUMBER
CAID NOT NULL NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
PARENT_ID NUMBER
NAME NOT NULL VARCHAR2(60)
DISPLAY_NAME NOT NULL VARCHAR2(256)
CATEGORY_ID NUMBER
CATEGORY_CAID NUMBER
DESCRIPTION VARCHAR2(2000)
TYPE_ID NOT NULL NUMBER
TYPE_CAID NOT NULL NUMBER
BASE_TYPE_ID NOT NULL NUMBER
IS_PORTLET NOT NULL NUMBER(1)
IS_CACHING_ON VARCHAR2(0)
CACHE_MODE NUMBER(1)
SUB_FOLDER_SEQUENCE NUMBER
DISPLAY_IN_PARENT_FOLDER NOT NULL NUMBER(1)
ITEMVERSIONING VARCHAR2(30)
STYLE_ID NOT NULL NUMBER
STYLE_CAID NOT NULL NUMBER
URL_VALUE VARCHAR2(4000)
SEARCH_VALUE VARCHAR2(2000)
PLSQL_VALUE VARCHAR2(2000)
IMAGE VARCHAR2(350)
TITLE_IMAGE_NAME VARCHAR2(0)
ROLLOVER_IMAGE_NAME VARCHAR2(350)
BANNER_IMAGE_NAME VARCHAR2(0)
NAVIGATION_BAR_ID VARCHAR2(0)
NAVIGATION_BAR_CAID VARCHAR2(0)
IS_PUBLIC NOT NULL NUMBER(1)
ITEM_LEVEL_SECURITY NOT NULL NUMBER(1)
DISPLAY_FULL_SCREEN VARCHAR2(0)
PLSQL_FOLDER_EXECUTOR VARCHAR2(30)
CREATEDATE DATE
CREATOR VARCHAR2(256)
UPDATEDATE DATE
UPDATOR VARCHAR2(256)
id caid languageid - unique identifier of the page within the
page group caid - id of the page group. FK to
WWSBR_ALL_CONTENT_AREAS.ID. language - language code parent_id - id of the parent page. "0" (zero)
if the root page of page group. name - internal name for the page. Must be
unique within parent page. display_name - page's display name (Title) category_id - id for the category assigned to
the page. FK to WWSBR_ALL_CATEGORIES.ID. category_siteid - page group id for the
category assigned to the page. FK to WWSBR_ALL_CATEGORIES.CAID. description - description of the page type_id - id of the page type. FK to
WWSBR_FOLDER_TYPES.ID. type_siteid - page group id for the page
type. FK to WWSBR_FOLDER_TYPES.CAID. base_type_id - id of the page base type. FK
to WWSBR_FOLDER_TYPES.ID where WWSBR_FOLDER_TYPES.IS_BASE_FOLDER_TYPE =
1. is_portlet - indicates if the page is
published as a portlet. Valid values: 0 - not a portlet, 1 - is a
portlet. is_caching_on - DEPRECATED. This column is
retained for backwards compatibility only. Its value is always null. cache_mode - caching mode for the page. Valid
values: 2 - no caching, 1 - Cache Page Definition Only, 0 - Cache Page
Definition And Content For x Minutes, 4 - Cache Page Definition Only at
System Level, 3 - Cache Page Definition and Content at System Level for
x Minutes. sub_folder_sequence - the sequence (order) of
the page on its parent page's sub page region display_in_parent_folder - indicates if the
page is displayed on its parent page's sub page region itemversioning - determines the level of item
versioning for the page. Valid values are: versionnone - No Versioning,
versionsimple - Simple Versioning, versionaudit - Audit Versioning.
Note that the page property overrides the page group setting for itemversioning,
but only if the page is set to a higher value. Thus, if the page group
is set to versionnone, the page can specify all three
levels. If the page group specifies versionsimple, the
page can implement either versionsimple or versionaudit
- a setting of versionnone is ignored. If the page group
specifies versionaudit, the page can only implement versionaudit
- the other settings will be ignored. style_id - id for the style used by the page.
FK to WWSBR_ALL_STYLES.ID. style_caid - page group id for the style used
by the page. FK to WWSBR_ALL_STYLES.CAID. url_value - url value for a URL type page search_value - DEPRECATED. Search pages are
no longer supported in Release 2. This column is retained for backwards
compatibility only. plsql_value - plsql value for a PL/SQL type
page image - unique name of the image associated
with the page. Matches the NAME column in the document table. title_image_name - DEPRECATED. This column is
retained for backward compatibility only. rollover_image_name- unique name of the
rollover image associated with the page. Matches the NAME column in the
document table . banner_image_name- DEPRECATED. Banner images
are no longer supported in Release 2. This column is retained for
backward compatibility only. navigation_bar_id - DEPRECATED. This column
is retained for backward compatibility only. navigation_bar_caid - DEPRECATED. This column
is retained for backward compatibility only. is_public - indicates that page is viewable
by PUBLIC. Valid values are 0 - not public, 1 - public. item_level_security - indicates that item
level security is enabled for the page. Valid values are 0 - ILS
disabled, 1 - ILS enabled. plsql_folder_executor - for PL/SQL type
pages, the database schema used to execute the PL/SQL code. createdate - date the page was created. creator - username of the person who created
the page updatedate - date the page was last updated updator - username of the person who last
updated the page Describes the perspectives associated with pages viewable by the current user.
Name Null? Type
----------------------------------------- -------- ----------------------------
FOLDER_CAID NOT NULL NUMBER
FOLDER_ID NOT NULL NUMBER
PERSPECTIVE_ID NOT NULL NUMBER
PERSPECTIVE_CAID NOT NULL NUMBER
PERSPECTIVE_NAME VARCHAR2(60)
folder_caid folder_id perspective_id perspective_caidfolder_caid - id of the page's page group. FK
to WWSBR_ALL|USER_FOLDERS.CAID. folder_id - id of the page. FK to
WWSBR_ALL|USER_FOLDERS.ID. perspective_id -
id of the perspective. FK to WWSBR_ALL_PERSPECTIVES.ID. perspective_caid - id of the perspective's
page group. FK to WWSBR_ALL_PERSPECTIVES.CAID. perspective_name - internal name of the
perspective. FK to WWSBR_ALL_PERSPECTIVES.NAME. Describes the attributes associated with pages viewable by the current user.
Name Null? Type
----------------------------------------- -------- ----------------------------
FOLDER_CAID NOT NULL NUMBER
FOLDER_ID NOT NULL NUMBER
ATTRIBUTE_ID NUMBER
ATTRIBUTE_CAID NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
VALUETYPE NOT NULL VARCHAR2(30)
VALUE VARCHAR2(2000)
folder_caid folder_id attribute_id attribute_caid languagefolder_caid - id of the page's page group. FK
to WWSBR_ALL|USER_FOLDERS.CAID. folder_id - id of the page. FK to
WWSBR_ALL|USER_FOLDERS.ID. attribute_id - id of the attribute. FK to
WWSBR_ATTRIBUTES.ID. attribute_caid - id of the the attribute's
page group. FK to WWSBR_ATTRIBUTES.CAID. language - language code. FK to
WWSBR_ALL|USER_FOLDERS.LANGUAGE and WWSBR_ATTRIBUTES.LANGUAGE. valuetype - data type of the attribute value - value of the attributeDescribes the items viewable by the current user.
Name Null? Type
----------------------------------------- -------- ----------------------------
MASTERID NOT NULL NUMBER
ID NOT NULL NUMBER
CAID NOT NULL NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
IS_CURRENT_VERSION NOT NULL NUMBER(1)
FOLDER_ID NOT NULL NUMBER
FOLDER_REGION_ID NOT NULL NUMBER
NAME NOT NULL VARCHAR2(256)
DISPLAY_NAME VARCHAR2(256)
ITEMTYPE NOT NULL VARCHAR2(30)
TYPE NOT NULL VARCHAR2(30)
SUBTYPE VARCHAR2(40)
SUBTYPE_CAID NUMBER
PARENT_ITEM_ID NUMBER
CATEGORY_ID NUMBER
CATEGORY_CAID NUMBER
AUTHOR VARCHAR2(50)
DESCRIPTION VARCHAR2(2000)
PUBLISH_DATE NOT NULL DATE
EXPIREMODE VARCHAR2(90)
EXPIRENUMBER NUMBER
EXPIREDATE DATE
IMAGE VARCHAR2(350)
KEYWORDS VARCHAR2(2000)
URL VARCHAR2(4000)
FILENAME VARCHAR2(350)
TEXT CLOB
FOLDER_LINK_ID NUMBER
FOLDER_LINK_CAID NUMBER
ACTIVE NOT NULL NUMBER(1)
CAN_BE_CHECKEDOUT NUMBER(1)
IS_ITEM_CHECKEDOUT NUMBER(1)
CHECKER_USERNAME VARCHAR2(30)
CHECKOUT_DATE DATE
FULLSCREEN NOT NULL NUMBER(1)
INPLACE NOT NULL NUMBER(1)
CREATEDATE NOT NULL DATE
CREATOR NOT NULL VARCHAR2(256)
UPDATEDATE DATE
UPDATOR VARCHAR2(256)
VISIBLE NUMBER(1)
SEQUENCE NUMBER
CATEGORY_SEQUENCE NUMBER
AUTHOR_SEQUENCE NUMBER
CREATE_DATE_SEQUENCE NUMBER
ITEMTYPE_SEQUENCE NUMBER
To avoid duplicate rows when querying for currently published items, always include the columns language, active (active=1) and is_current_version (is_current_version=1). For example, to select all items on a given page (folder_id =1) and a given page group (caid = 75):
select i.display_name title, i.id latestversion
from wwsbr_all_items i
where i.folder_id = 1
and i.caid = 75
and i.active = 1
and i.is_current_version = 1
and (i.language = wwctx_api.get_nls_language -- the current session language
or ( exists -- a row for the item in the page group default language
(select pg.id
from wwsbr_all_content_areas pg
where pg.id = i.caid
and pg.default_language = i.language
)
and not exists -- a row for the item in the current language
(select i2.id
from wwsbr_all_items i2
where i2.id = i.id
and i2.language = wwctx_api.get_nls_language
and i2.active = i.active
and i2.is_current_version = i.is_current_version
)
)
)
order by i.id
Primary Key:
id caid language active = 1 is_current_version = 1masterid - master id for the item. This
value is used to relate multiple versions and/or translations of a
item. All versions and translations of an item will have the same
master id. id - id of the item. Each version of an item
receives a new id. If translations and approvals are enabled, multiple
rows may exist for the same id. caid - id of the item's page group. FK to
WWSBR_ALL|USER_FOLDERS.CAID and WWSBR_ALL_CONTENT_AREAS.ID. language - language code is_current_version - indicates that the item
is the current version. Valid values: 0 - not current version, 1 -
current version. folder_id - id of the page containing the
item. FK to WWSBR_ALL|USER_FOLDERS.ID and
WWSBR_ALL_FOLDER_REGIONS.FOLDER_ID. folder_region_id - id of the region
containing the item. FK to WWSBR_ALL_FOLDER_REGIONS.ID. name - internal name of the item. The name
is a system generated GUID (Global Unique Identifier) value that can be
used as an alternate id. The name is also used in the direct access URL
format "/<DAD>/url/item/<NAME>" (e.g.
http://mysite.mydomain:7780/pls/portal/url/item/979DAAC2FA541226E034080020F7DA4B).
Use this format when building durable links to items, as the name of
the item will not change even if the item is moved to another page. display_name - display name or title of the
item itemtype - the base item type; e.g.
"basefile", "baseimage", "basetext", "baseurl", etc. type - DEPRECATED. This column is retained
for backward compatibility only.subtype_caid- id of the item type. FK to
WWSBR_ITEM_TYPES.ID parent_item_id - id of the parent item, if
the item is a sub item. Value is "0" (zero) if item is not a sub item. category_id - id for the category assigned
to the item. FK to WWSBR_ALL_CATEGORIES.ID. category_caid - page group id for the
category assigned to the item. FK to WWSBR_ALL_CATEGORIES.CAID. author - author of the item description - description of the item publish_date - date the item will be
published expiremode - expiration mode for the item.
Valid values: 'PERMANENT' (item never expires), 'NUMBER' (item expires
in EXPIRENUMBER days from CREATEDATE), or 'DATE' (item expires on
EXPIREDATE).. expirenumber - number of days after
CREATEDATE when item will expire. Only valid when EXPIREMODE =
'NUMBER'. expiredate - date when item will expire.
Only valid when EXPIREMODE = 'DATE'. image - image associated with the item. This
value may be a reference (e.g. a path to an image stored on the file
system or in the content repository) or a unique document name that
matches the NAME column in the document table. url - URL for a url type item filename - unique name of the file
associated with a file type item. Matches the NAME column in the
document table. text - text for a text type item. folder_link_id - page id for a page link
type item. FK to WWSBR_ALL|USER_FOLDERS.ID. folder_link_caid - page group id for a page
link type item. FK to WWSBR_ALL|USER_FOLDERS.CAID. active - indicates the active status of the
item. Valid values: 1 - active, 2 - pending approval as new and current
version, 3 - pending approval as new and not current version, 0 -
pending approval, -1 - deleted, -7 - rejected, -9 - reject deleted. can_be_checkedout - indicates if the item
can be checked out. Valid values: 0 - cannot be checked out, 1 - can be
checked out. is_item_checkedout - indicates if the item
is checked out. Valid values: 0 - item is not checked out, 1- item is
checked out checker_username - username of the user who
checked out the item checkout_date - date the item was checked
out fullscreen - indicates the rendering
behavior for an item shown as a link. Valid values: 0 - clicking the
link displays the item in a new browser window, 1 - clicking the link
displays the item in the same browser window. inplace - indicates the rendering behavior
for a text or PL/SQL item. Valid values: 0 - a link to the item is
displayed; the rendering behavior of the link depends on the setting of
the FULLSCREEN column, 1 - the item is rendered in-place in the region.
createdate - date the item was created. creator - username of the person who created
the item. updatedate - date the item was last updated.
updator - username of the person who last
updated the item.visible - indicates if the item is visible
or hidden. Valid values: 0 - item is hidden, 1 - item is visible.sequence - regular sequence of the item.category_sequence - sequence of the item
when items are grouped by category.author_sequence - sequence of the item when
items are grouped by author.create_date_sequence - sequence of the item
when items are grouped by create date.itemtype_sequence - sequence of the item
when items are grouped by item type.Describes the perspectives associated with items viewable by the current user.
Name Null? Type
----------------------------------------- -------- ----------------------------
ITEM_CAID NOT NULL NUMBER
ITEM_ID NOT NULL NUMBER
ITEM_MASTERID NUMBER
PERSPECTIVE_ID NOT NULL NUMBER
PERSPECTIVE_CAID NOT NULL NUMBER
PERSPECTIVE_NAME VARCHAR2(60)
item_caid item_id item_masterid perspective_id perspective_caiditem_caid - id of the item's page group. FK
to WWSBR_ALL_ITEMS.CAID. item_id - id of the item. FK to
WWSBR_ALL_ITEMS.ID. item_masterid - master id of the item. FK to
WWSBR_ALL_ITEMS.MASTERID. perspective_id - id of the perspective. FK
to WWSBR_ALL_PERSPECTIVES.ID. perspective_caid - id of the perspective's
page group. FK to WWSBR_ALL_PERSPECTIVES.CAID. perspective_name - internal name of the
perspective. FK to WWSBR_ALL_PERSPECTIVES.NAME.Describes the attributes and attribute values associated with items viewable by the current user.
Name Null? Type
----------------------------------------- -------- ----------------------------
ITEM_CAID NOT NULL NUMBER
ITEM_MASTERID NOT NULL NUMBER
ATTRIBUTE_ID NUMBER
ATTRIBUTE_CAID NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
VALUETYPE NOT NULL VARCHAR2(30)
VALUE VARCHAR2(2000)
item_caid item_masterid attribute_id attribute_caid language item_caid - id of the items's page group. FK
to WWSBR_ALL_ITEMS.CAID. item_masterid - master id of the item. FK to
WWSBR_ALL_ITEMS.MASTERID. attribute_id - id of the the attribute. FK to
WWSBR_ATTRIBUTES.ID. attribute_caid - id of the the attribute's
page group. FK to WWSBR_ATTRIBUTES.CAID. language - language code. FK to
WWSBR_ALL_ITEMS.LANGUAGE and WWSBR_ATTRIBUTES.LANGUAGE. valuetype - data type of the attribute value - value of the attribute Describes all categories.
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
CAID NOT NULL NUMBER
PARENT_ID NOT NULL NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
NAME VARCHAR2(60)
DISPLAY_NAME NOT NULL VARCHAR2(240)
id caid language id - id of the category caid - id of the category's page group. FK
to WWSBR_ALL_CONTENT_AREAS.ID parent_id - id of the the category's parent
category. "0" (zero) if the category has no parent. language - language code name - internal name of the category. Unique
within parent category. display_name - display name (title) of the
category Describes all perspectives.
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
CAID NOT NULL NUMBER
PARENT_ID NOT NULL NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
NAME VARCHAR2(60)
DISPLAY_NAME NOT NULL VARCHAR2(240)
id caid languageid - id of the perspective. caid - id of the perspective's page group.
FK to WWSBR_ALL_CONTENT_AREAS.ID. parent_id - id of the the perspective's
parent perspective. "0" (zero) if the perspective has no parent language - language code name - internal name of the perspective.
Unique within parent perspective. display_name - display name (title) of the
perspective Describes all page groups. This view shows all page groups in the Repository, regardless of the current user's privileges.
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(60)
DISPLAY_NAME NOT NULL VARCHAR2(240)
DEFAULT_LANGUAGE NOT NULL VARCHAR2(30)
id
languagename
languageid - id of the page group language - language code name - internal name of the page group display_name - display name (title) of the
page group default_language - code for the default
language of the page group Describes all attributes.
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
CAID NOT NULL NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(256)
DISPLAY_NAME VARCHAR2(256)
IS_BASE_ATTRIBUTE NOT NULL NUMBER(1)
DATA_TYPE NOT NULL VARCHAR2(30)
LENGTH NUMBER(5)
IS_TRANSLATABLE NOT NULL NUMBER(1)
id
caid
languagename
caid
languageid - id of the attribute caid - id of the attribute's page group. FK
to WWSBR_ALL_CONTENT_AREAS.ID. language - language code name - internal name of the attribute.
Functions as alternate key (unique within page group). display_name - display name (title) of the
attribute is_base_attribute - indicates that the
attribute is a base attribute. Valid values: 0 - not a base attribute,
1 - is a base attribute data_type - data type of the attribute length - length of the attribute is_translatable - indicates that the
attribute is translatable, meaning that a different value can be stored
for each translation. If the attribute is not translatable, the same
value is stored for all translations. Valid values: 0 - not
translatable, 1 - is translatable.Describes all item types.
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
CAID NOT NULL NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
NAME VARCHAR2(30)
DISPLAY_NAME VARCHAR2(256)
DESCRIPTION VARCHAR2(2000)
IS_BASE_ITEM_TYPE NOT NULL NUMBER
BASE_ITEM_TYPE_ID NUMBER
id
caid
languagename
caid
languageid - id of the item type caid - id of the item types's page group. FK
to WWSBR_ALL_CONTENT_AREAS.ID. language - language code name - internal name of the item type.
Functions as alternate key (unique within page group). display_name - display name (title) of the
item type description - description of the item type is_base_item_type - indicates that the item
type is a base item type. Valid values: 0 - item type is not a base
item type, 1 - item type is a base item type. Note that only non-base
item types can be assigned to items. base_item_type_id - id of the base item type
on which this item type is based Describes which item types are available to which page groups. An item type cannot be assigned to an item unless the item type is available within the item's page group.
Name Null? Type
----------------------------------------- -------- ----------------------------
CAID NOT NULL NUMBER
ITEM_TYPE_ID NOT NULL NUMBER
ITEM_TYPE_CAID NOT NULL NUMBER
caid
item_type_id
item_type_caid caid - id of the page group. FK to
WWSBR_ALL_CONTENT_AREAS.ID. item_type_id - id of the item type. FK to
WWSBR_ITEM_TYPES.ID. item_type_caid - id of the item type's page
group. FK to WWSBR_ITEM_TYPES.CAID. Describes the attributes that are available within each item type.
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
CAID NOT NULL NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
ITEM_TYPE_ID NOT NULL NUMBER
ITEM_TYPE_CAID NOT NULL NUMBER
ATTRIBUTE_ID NOT NULL NUMBER
ATTRIBUTE_CAID NOT NULL NUMBER
HIDDEN_ATTRIBUTE NOT NULL NUMBER(1)
DEFAULT_VALUE VARCHAR2(2000)
id
caid
language item_type_idid - id of the item type attribute row caid - id of the page group. FK to
WWSBR_ALL_CONTENT_AREAS.ID. language - language code item_type_id - id of the item type. FK to
WWSBR_ITEM_TYPES.ID. item_type_caid - id of the item type's page
group. FK to WWSBR_ITEM_TYPES.CAID. attribute_id - id of the attribute. FK to
WWSBR_ATTRIBUTES.ID. attribute_caid - id of the attribute's page
group. FK to WWSBR_ATTRIBUTES.CAID. hidden_attribute - indicates if the attribute
should be hidden. Valid values: 0 - attribute is hidden, 1 - attribute
is not hidden. This column is used for certain built-in item types and
is not intended for customer use. default_value - default value of the
attribute. The default value is always stored as VARCHAR2, regardless
of the attribute's base type Describes all page types.
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
CAID NOT NULL NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
NAME VARCHAR2(30)
DISPLAY_NAME VARCHAR2(256)
DESCRIPTION VARCHAR2(2000)
IS_BASE_FOLDER_TYPE NOT NULL NUMBER
BASE_FOLDER_TYPE_ID NUMBER
id
caid
languagename
caid
languageid - id of the page type caid - id of the page types's page group. FK
to WWSBR_ALL_CONTENT_AREAS.ID. language - language code name - internal name of the page type.
Functions as alternate key (unique within page group). display_name - display name (title) of the
page type description - description of the page type is_base_folder_type - indicates that the page
type is a base page type. Valid values: 0 - is not a base page type, 1
- is a base page type base_folder_type_id - id of the base page
type on which this page type is based Describes the attributes that are available within each page type.
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
CAID NOT NULL NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
FOLDER_TYPE_ID NOT NULL NUMBER
FOLDER_TYPE_CAID NOT NULL NUMBER
ATTRIBUTE_ID NOT NULL NUMBER
ATTRIBUTE_CAID NOT NULL NUMBER
DEFAULT_VALUE VARCHAR2(2000)
id
caid
language folder_type_idid - id of the page type attribute row caid - id of the page group. FK to
WWSBR_ALL_CONTENT_AREAS.ID. language - language code folder_type_id - id of the page type. FK to
WWSBR_FOLDER_TYPES.ID. folder_type_caid - id of the page type's page
group. FK to WWSBR_FOLDER_TYPES.CAID. attribute_id - id of the attribute. FK to
WWSBR_ATTRIBUTES.ID. attribute_caid - id of the attribute's page
group. FK to WWSBR_ATTRIBUTES.CAID. default_value - default value of the
attribute. The default value is always stored as VARCHAR2, regardless
of the attribute's base type. Describes all styles.
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
CAID NOT NULL NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(65)
DISPLAY_NAME VARCHAR2(350)
id
caid
languagename
caid
languageid - id of the style caid - id of the style's page group. FK to
WWSBR_ALL_CONTENT_AREAS.ID. language - language code name - internal name of the style. Unique
within page group. display_name - display name (title) of the
style
Describes all navigation pages viewable by the current user.
Name Null? TypePrimary Key:
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
CAID NOT NULL NUMBER
LANGUAGE NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(60)
DISPLAY_NAME NOT NULL VARCHAR2(256)
STYLE_ID NOT NULL NUMBER
STYLE_CAID NOT NULL NUMBER
IS_PORTLET NOT NULL NUMBER(1)
ALIGNMENT VARCHAR2
id
caid
languagename
caid
languageid - id of the navigation page caid - id of the navigation page's page
group. FK to WWSBR_ALL_CONTENT_AREAS.ID. language - language code name - internal name of the navigation page.
Unique within page group. display_name - display name (title) of the
navigation page style_id- id for the style used by the page.
FK to WWSBR_ALL_STYLES.ID. style_caid - page group id for the style used
by the navigation page. FK to WWSBR_ALL_STYLES.CAID. is_portlet - indicates if the page is
published as a portlet. Valid values: 0 - not a portlet, 1 - is a
portlet alignment - DEPRECATED as of version 9.0.2.6 Describes all page regions on pages viewable by the current user.
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER(38)
DISPLAY_NAME VARCHAR2(4000)
LANGUAGE VARCHAR2(7)
FOLDER_ID NUMBER(38)
FOLDER_CAID NUMBER(38)
PARENT_ID NUMBER(38)
TYPE VARCHAR2(30)
SEQ NUMBER
ALLOW_CONTENT NUMBER
id
languageid - id of the region display_name - display name (title) of the
region. May be null. language - language code folder_id- id of the page containing the
region. FK to WWSBR_ALL|USER_FOLDERS.ID. folder_caid - page group id for the page
containing the region. FK to WWSBR_ALL|USER_FOLDERS.CAID. parent_id - id of the parent region, if
region is nested type - the region type. Valid values: NONE -
undefined, TAB - a tab region, SUBPAGE - a sub page region, ITEM - an
item region, PORTLET - a portlet region. Items can be only be added to
ITEM regions. seq - sequence of a region within the parent
region allow_content - indicates if the region
allows content to be added. Valid values: 0 - does not allow content to
be added, 1 - allows content to be added.
|
OracleAS Portal PL/SQL API Reference - 10.1.2 | |||||||
| PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES | |||||||
| VIEW SUMMARY | VIEW DETAIL | |||||||