KDLV_PACKAGE_LINES_INT
This table corresponds to the KDLV_PACKAGE_LINES table (package lines). This table as well as other interface tables will be processed through the java report that calls a PL/SQL package that can be run either from the command line or through the report job scheduler. This allows the user to immediately run the interface but also allow for scheduled processing. PL/SQL package will query this table, validate some columns of the table against appropriate tables and call the necessary package line
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KDLV_PACKAGE_LINES |
PACKAGE_LINE_ID |
PACKAGE_LINE_ID |
KNTA_PARAMETER_SET_CONTEXTS |
PARAMETER_SET_CONTEXT_ID |
PARAMETER_SET_CONTEXT_ID |
KDLV_PACKAGES |
PACKAGE_ID |
PACKAGE_ID |
KNTA_PARAMETER_SET_CONTEXTS |
PARAMETER_SET_CONTEXT_ID |
USER_DATA_SET_CONTEXT_ID |
KDLV_OBJECT_TYPES |
OBJECT_TYPE_ID |
OBJECT_TYPE_ID |
KDLV_PACKAGES_INT |
PACKAGE_INTERFACE_ID |
PACKAGE_INTERFACE_ID |
KNTA_USERS |
USER_ID |
CREATED_BY |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
PACKAGE_LINE_INTERFACE_ID |
NULLABLE |
NUMBER |
System-generated identifier |
GROUP_ID |
NULLABLE |
NUMBER |
Common column among interface tables. This value is used to tie records in the interface tables together. Most of database processing is done based on this value |
PACKAGE_INTERFACE_ID |
NULLABLE |
NUMBER |
ID of the package interface ID in KDLV_PACKAGES_INT table |
PACKAGE_ID |
NULLABLE |
NUMBER |
If not null, used to validate against the request_id in KDLV_PACKAGES |
PACKAGE_NUMBER |
NULLABLE |
VARCHAR2(40) |
If not null, used to validate against the request_number in KDLV_PACKAGES |
PROCESS_PHASE |
NULLABLE |
NUMBER |
Common column among interface tables. Used to determine which phase a record is at: Pending, Deriving, Validating, Importing or Completed |
PROCESS_STATUS |
NULLABLE |
NUMBER |
Common column among interface tables. Used to determine the current status of the interface record: Pending, In Process, Errored or Completed |
CREATED_BY |
NULLABLE |
NUMBER |
Identifier for the user who created the record |
CREATED_BY_USERNAME |
NULLABLE |
VARCHAR2(200) |
Username that created this record |
CREATION_DATE |
NULLABLE |
DATE |
Date record was created |
SOURCE_CODE |
NULLABLE |
VARCHAR2(30) |
Common column among interface tables. Used to differentiate interface records by their point of origin |
SEQ |
NULLABLE |
NUMBER |
Sequence number |
PACKAGE_LINE_ID |
NULLABLE |
NUMBER |
If not null, used to validate against KDLV_PACKAGE_LINES. If null, derive from KDLV_PACKAGE_LINES_S |
OBJECT_TYPE_ID |
NULLABLE |
NUMBER |
If not null, used to validate against KDLV_OBJECT_TYPES. If null, derive from OBJECT_TYPE_NAME |
OBJECT_TYPE_NAME |
NULLABLE |
VARCHAR2(80) |
If OBJECT_TYPE_ID not null, ignore this column, otherwise validate against KDLV_OBJECT_TYPES |
OBJECT_NAME |
NULLABLE |
VARCHAR2(300) |
Do we try to populate this from the object type definition and the parameter column values? |
APP_CODE |
NULLABLE |
VARCHAR2(30) |
If not null, validate against the distinct APP_CODES in KDLV_ENVIRONMENT_APPS |
PARAMETER_SET_CONTEXT_ID |
NULLABLE |
NUMBER |
Identifier of the parameter set context associated with the object type chosen for this line. Links the parameter values stored in this line with their context |
PARAMETER1-30 |
NULLABLE |
VARCHAR2(200) |
Package line parameter |
VISIBLE_PARAMETER1-30 |
NULLABLE |
VARCHAR2(200) |
Package line parameter |
RELEASE_FLAG |
NULLABLE |
VARCHAR2(1) |
Whether or not to release after creation |
USER_DATA_SET_CONTEXT_ID |
NULLABLE |
NUMBER |
Parameter set context identifier for the user data fields |
USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
VISIBLE_USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
OBJECT_REVISION |
NULLABLE |
VARCHAR2(300) |
Revision of the object |
SOURCE_PACKAGE_LINE_ID |
NULLABLE |
NUMBER |
Identifier of the original Package Line for this Distribution placeholder Package Line |
ENABLED_FLAG |
NULLABLE |
VARCHAR2(1) |
Denote whether this Distribution Package Line is enabled or disabled |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KDLV_PACKAGE_LINES_INT_N1 |
NONUNIQUE |
1 |
PACKAGE_LINE_INTERFACE_ID |
KDLV_PACKAGE_LINES_INT_N1 |
NONUNIQUE |
2 |
GROUP_ID |
KDLV_PACKAGE_LINES_INT_N2 |
NONUNIQUE |
1 |
GROUP_ID |
KDLV_PACKAGE_LINES_INT_N2 |
NONUNIQUE |
2 |
PACKAGE_INTERFACE_ID |
KDLV_PACKAGE_LINES_INT_N3 |
NONUNIQUE |
1 |
PACKAGE_NUMBER |
KDLV_PACKAGE_LINES_INT_N3 |
NONUNIQUE |
2 |
SEQ |
Sequences
Sequence Name |
Sequence Type |
---|---|
KDLV_INTERFACES_S |
PACKAGE_LINE_INTERFACE_ID |
KDLV_PACKAGE_LINES_S |
PACKAGE_LINE_ID |
KNTA_INTERFACE_GROUPS_S |
GROUP_ID |