[Home] [Help] [Dependency Information]
Object Name: | VEA_PARAMETERS |
---|---|
Object Type: | TABLE |
Owner: | VEA |
FND Design Data: | VEA.VEA_PARAMETERS |
Subobject Name: | |
Status: | VALID |
The VEA_PARAMETERS table contains information about signatures 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
Each row contains information about whether the parameter type, its datatype, sequence and default value.
The import utility parses package files and registers signature information about requisite program units in the repository. Layer workbench displays this information and generate utility uses this information to generate the code to call the registered program units as specified by layer developers.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
VEA_PARAMETERS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
LAYER_PROVIDER_CODE
PARAMETER_ID |
VEA_PARAMETERS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
LAYER_PROVIDER_CODE
PROGRAM_UNIT_ID NAME |
VEA_PARAMETERS_U3 | NORMAL | UNIQUE | APPS_TS_SEED |
LAYER_PROVIDER_CODE
PROGRAM_UNIT_ID PARAMETER_SEQ |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARAMETER_ID | NUMBER | Yes | Parameter identifier | |
LAYER_PROVIDER_CODE | VARCHAR2 | (30) | Yes | Layer developer identifier |
PROGRAM_UNIT_ID | NUMBER | Yes | Program unit identifier | |
PARAMETER_TYPE | VARCHAR2 | (1) | Yes | Type of parameter, valid values are I (IN), O (OUT) and B (IN OUT) |
PARAMETER_SEQ | NUMBER | Yes | Sequence of parameter within the program unit | |
NAME | VARCHAR2 | (30) | Yes | Parameter name |
DATATYPE | VARCHAR2 | (500) | Yes | Datatype of the parameter |
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 | ||
DEFAULT_VALUE | VARCHAR2 | (500) | Default value for the parameter | |
DESCRIPTION | VARCHAR2 | (1000) | Parameter description |
Cut, paste (and edit) the following text to query this object:
SELECT PARAMETER_ID
, LAYER_PROVIDER_CODE
, PROGRAM_UNIT_ID
, PARAMETER_TYPE
, PARAMETER_SEQ
, NAME
, DATATYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DEFAULT_VALUE
, DESCRIPTION
FROM VEA.VEA_PARAMETERS;
VEA.VEA_PARAMETERS does not reference any database object
VEA.VEA_PARAMETERS is referenced by following:
|
|
|