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.