[Home] [Help] [Dependency Information]
Object Name: | XDP_PROC_BODY |
---|---|
Object Type: | TABLE |
Owner: | XDP |
FND Design Data: | XDP.XDP_PROC_BODY |
Subobject Name: | |
Status: | VALID |
XDP_PROC_BODY holds the source code of all the procedures defined for the application. This includes:
1. Fulfillment Procedures
2. Connect/Disconnect Procedures
3. Parameter Evaluation Procedures
4. Fulfillment Element Routing Procedures
5. Service to work item dynamic mapping procedure
6. Workitem to fulfillment action dynamic mapping procedure
7. Procedure to create process in user defined workflow.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000086314C00003$$ | LOB | UNIQUE | APPS_TS_SEED | |
XDP_PROC_BODY_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
PROC_NAME
ZD_EDITION_NAME |
XDP_PROC_BODY_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | PROC_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROC_NAME | VARCHAR2 | (80) | Yes | Procedure internal name |
PROC_SPEC | VARCHAR2 | (1996) | Yes | Package specification |
PROC_BODY | CLOB | (4000) | Yes | Procedure body |
PROC_TYPE | VARCHAR2 | (40) | Yes | Procedure type |
PROTECTED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the procedure is a seeded procedure or not |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PROC_NAME
, PROC_SPEC
, PROC_BODY
, PROC_TYPE
, PROTECTED_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, ZD_EDITION_NAME
FROM XDP.XDP_PROC_BODY;
XDP.XDP_PROC_BODY does not reference any database object
XDP.XDP_PROC_BODY is referenced by following:
|
|
|