Share this page

# KDLV_PACKAGE_LINES_INT

The KDLV_PACKAGE_LINES_INT interface table defines each package line for a new package, or each package line added to an existing package. This interface table holds information for each package line on the new package, or for each new package line to be added to an existing package. This includes information of the specific object type and application code for the package line, and parameter information for the specified object type and user data for the package line.

Table A-22. KDLV_PACKAGE_LINES_INT interface table
Column | Usage | Data Type | Description
--- | --- | --- | ---
PACKAGE_LINE_INTERFACE_ID | I/O | NUMBER | Provides a unique identifier for the record. If left blank, the value is derived from the KDLV_INTERFACES_S sequence.
GROUP_ID | I | NUMBER | Groups all the records that should be processed at the same time. Use only one GROUP_ID each time you run a report. Derived from the KNTA_INTERFACE_GROUPS_S sequence.
PACKAGE_INTERFACE_ID | I | NUMBER | Provides a unique identifier for the each record. Derived from the KDLV_INTERFACES_S sequence. For lines tied to a new package, this can be used to tie the line record to the parent record in KDLV_PACKAGES_INT. The PACKAGE_NUMBER and PACKAGE_ID columns can be used for this tie as well. This is required if package lines exist. For new lines, this should be left blank.
PACKAGE_ID | I | NUMBER | Provides an identifier for a package and makes the association between the package and package lines. Derived from the KDLV_PACKAGES_S sequence. For new lines to be imported into existing packages, this column should refer to the PACKAGE_ID of the existing package. For lines tied to a new package, this column can be used to tie the line record to the parent record in KDLV_PACKAGES_INT. Either PACKAGE_INTERFACE_ID and PACKAGE_NUMBER can be used to tie the records.
PACKAGE_NUMBER | I | VARCHAR2 | Identifies the package number. This must use either the same value as PACKAGE_ID or a unique string.
PROCESS_PHASE | O | NUMBER | Indicates the current stage of the record as it is being processed. See Process State Information for details.
PROCESS_STATUS | O | NUMBER | Indicates the current disposition of the record. See Process State Information for details.
CREATED_BY | I/O | NUMBER | Identifies the USER_ID (from KNTA_USERS) for the user performing the transaction. If left blank, the value is derived from CREATED_BY_USERNAME. If both are left blank, the value is set to the user currently running the report.
CREATED_BY_USERNAME | I | VARCHAR2 | Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction. This is used only if CREATED_BY is left blank.
CREATION_DATE | I/O | DATE | Indicates the transaction date. If left blank, the current date is used.
SOURCE_CODE | I | VARCHAR2 | Provides the identify of the source of the record. This value is not validated and is for informational purposes only.
SEQ | I | NUMBER | Provides a user-visible sequence number for the package line. This must be a unique, positive integer and not conflict with other package lines in the interface table or existing lines if importing lines to an existing packages.
PACKAGE_LINE_ID | I/O | NUMBER | Provides the identifier for a package line. This is normally left blank and the value is derived from the KDLV_PACKAGE_LINES_S sequence.
OBJECT_TYPE_ID | I | NUMBER | Provides the object type ID attached to the package line. Derived from OBJECT_TYPE_ID (in KDLV_OBJECT_TYPES). Either OBJECT_TYPE_ID or OBJECT_TYPE_NAME must be entered.
OBJECT_TYPE_NAME | I | VARCHAR2 | Provides the object type name attached to the package line. Derived from OBJECT_TYPE_NAME (in KDLV_OBJECT_TYPES). This is used only if OBJECT_TYPE_ID is left blank.
OBJECT_NAME | I | VARCHAR2 | Specifies the name of the object to be processed. This value is not validated.
APP_CODE | I/O | VARCHAR2 | Specifies the application category for the package line. Derived from KDLV_ENVIRONMENT_APPS. The APP_CODE must exist for all environments in the workflow attached to the package. APP_CODE can be used as information and can sometimes determine migration behavior.
PARAMETER_SET_CONTEXT_ID | I/O | NUMBER | Sets the context identifier for the detail fields. This is normally left blank and is derived from OBJECT_TYPE_ID.
PARAMETER1 VISIBLE_PARAMETER1 through PARAMETER30 VISIBLE_PARAMETER30 | I | VARCHAR2 | Specifies the user-defined fields attached to the user screen. This is required only if user data is defined.
RELEASE_FLAG | I/O | VARCHAR2 | Indicates whether or not the interface program will release the package once it imports in into the standard Deployment Management tables. Valid values are: Yes No The default is No.
USER_DATA_SET_CONTEXT_ID | I/O | NUMBER | Sets the context identifier for the USER_DATA fields. If left blank, the value is set to 1203.
USER_DATA1 VISIBLE_USER_DATA1 through USER_DATA20 VISIBLE_USER_DATA20 | I | VARCHAR2 | Specifies the user-defined fields attached to the user screen. This is required only if user data is defined. This information is not validated nor does it have a default value.
OBJECT_REVISION | I | VARCHAR2 | Specifies the denormalized object_revision of the object entered on this line.
SOURCE_PACKAGE_LINE_ID | I | NUMBER | Identifies the original package line for this distribution package line.
ENABLED_FLAG | I | VARCHAR2 | Indicates whether or not the distribution package is enabled upon import. (Applies to distribution packages only.) Valid values are: Y N The default is Y.

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: