[Home] [Help] [Dependency Information]
Object Name: | VEA_PROGRAM_UNITS |
---|---|
Object Type: | TABLE |
Owner: | VEA |
FND Design Data: | VEA.VEA_PROGRAM_UNITS |
Subobject Name: | |
Status: | VALID |
The VEA_PROGRAM_UNITS table contains information about following types of program units registered with the trading partner architecture repository
- Base layer program units
- Trading partner selector program units
- Trading partner layer program units
- Callout program units
- Program units generated by the trading partner architecture
Each row contains information about whether the program unit is customizable, whether it is trading partner selector and type of program unit whether it is procedure or function. It also stores mapping between base layer program unit and corresponding program unit to be generated by the architecture.
The import utility parses package files and registers information about requisite program units in the repository. Layer workbench displays this information and generate utility uses this information to find out program units to be generated and base layer program units it is linked to.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
VEA_PROGRAM_UNITS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
LAYER_PROVIDER_CODE
PROGRAM_UNIT_ID |
VEA_PROGRAM_UNITS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
LAYER_PROVIDER_CODE
PACKAGE_ID NAME |
VEA_PROGRAM_UNITS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
PACKAGE_ID
LAYER_PROVIDER_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROGRAM_UNIT_ID | NUMBER | Yes | Program unit identifier | |
LAYER_PROVIDER_CODE | VARCHAR2 | (30) | Yes | Layer developer identifier |
PACKAGE_ID | NUMBER | Yes | Package identifier | |
PROGRAM_UNIT_TYPE | VARCHAR2 | (1) | Yes | Indicates whether program unit is a procedure(P) or function(F) |
PUBLIC_FLAG | VARCHAR2 | (1) | Yes | Not currently used, always defaulted to Y |
CUSTOMIZABLE_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the program unit is customizable, Y/N flag |
TPS_FLAG | VARCHAR2 | (1) | Yes | Indicates if the program unit is a trading partner selector, Y/N flag |
NAME | VARCHAR2 | (30) | Yes | Name of the program unit |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
REQUEST_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
LABEL | VARCHAR2 | (100) | Label of the program unit | |
RETURN_TYPE | VARCHAR2 | (500) | Return type if program unit is a function | |
TPA_PROGRAM_UNIT_ID | NUMBER | Identifier for the base layer program unit, if the program unit is generated by the architecture | ||
DESCRIPTION | VARCHAR2 | (1000) | Description for the program unit |
Cut, paste (and edit) the following text to query this object:
SELECT PROGRAM_UNIT_ID
, LAYER_PROVIDER_CODE
, PACKAGE_ID
, PROGRAM_UNIT_TYPE
, PUBLIC_FLAG
, CUSTOMIZABLE_FLAG
, TPS_FLAG
, NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LABEL
, RETURN_TYPE
, TPA_PROGRAM_UNIT_ID
, DESCRIPTION
FROM VEA.VEA_PROGRAM_UNITS;
VEA.VEA_PROGRAM_UNITS does not reference any database object
VEA.VEA_PROGRAM_UNITS is referenced by following:
|
|
|