Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: