DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_ENABLED_PLSQL

Object Details
Object Name: FND_ENABLED_PLSQL
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_ENABLED_PLSQL
Subobject Name:
Status: VALID


FND_ENABLED_PLSQL stores information about
the PL/SQL packages and package procedures accessible by the web server.
The PLSQL_NAME corresponds to the name of a package or procedure that is stored
in the database.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_ENABLED_PLSQL_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnPLSQL_TYPE
ColumnPLSQL_NAME
Columns
Name Datatype Length Mandatory Comments
PLSQL_TYPE VARCHAR2 (30) Yes Type of object identified by PLSQL_NAME column. PACKAGE and PACKAGE.PROCEDURE are possible values.
PLSQL_NAME VARCHAR2 (100) Yes Name of the PL/SQL object for which access is being controlled. Either a package name, or a package.procedure name.
ENABLED VARCHAR2 (1) Yes Y/N flag: is procedure/package accessible by web server DCD?
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
EXTERNAL VARCHAR2 (1)
EXTERNAL
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLSQL_TYPE
,      PLSQL_NAME
,      ENABLED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      EXTERNAL
FROM APPLSYS.FND_ENABLED_PLSQL;

Dependencies

[top of page]

APPLSYS.FND_ENABLED_PLSQL does not reference any database object

APPLSYS.FND_ENABLED_PLSQL is referenced by following:

SchemaAPPS
SynonymFND_ENABLED_PLSQL