KDLV_DELETED_PKG_LINES

This table stores a record of deleted package lines for use by the SOX accelerator.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KDLV_OBJECT_TYPES

OBJECT_TYPE_ID

OBJECT_TYPE_ID

KDLV_PACKAGES

PACKAGE_ID

PACKAGE_ID

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

SOURCE_PACKAGE_LINE_ID

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

USER_DATA_SET_CONTEXT_ID

Column Descriptions

Column Name

Null?

Data Type

Description

DELETED_PKG_LINE_ID

NOT NULL

NUMBER

System-generated identifier

PACKAGE_LINE_ID

NOT NULL

NUMBER

System-generated identifier

DELETED_BY

NOT NULL

NUMBER

Identifier for user who deleted the record

DELETION_DATE

NOT NULL

DATE

Date record was deleted

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

PACKAGE_ID

NOT NULL

NUMBER

Package identifier

SEQ

NOT NULL

NUMBER

Sequence of this Line on the Package

OBJECT_TYPE_ID

NOT NULL

NUMBER

Denormalized object_type_id of the object chosen for this Line

OBJECT_NAME

NULLABLE

VARCHAR2(300)

Denormalized object_name of the object entered on this Line

OBJECT_REVISION

NULLABLE

VARCHAR2(300)

Denormalized object_revision of the object entered on this Line

APP_CODE

NULLABLE

VARCHAR2(30)

Selected app code for this line (chosen from all available app codes in the selected workflow)

PARAMETER_SET_CONTEXT_ID

NULLABLE

NUMBER

Package Line parameter

PARAMETER1-30

NULLABLE

VARCHAR2(200)

Package Line parameter

VISIBLE_PARAMETER1-30

NULLABLE

VARCHAR2(200)

Package Line parameter

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

SOURCE_PACKAGE_LINE_ID

NULLABLE

NUMBER

Identifier of the original Package Line for this Distribution placeholder Package Line

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Denote whether this Distribution Package Line is enabled or disabled

Indexes

Index Name

Index Type

Sequence

Column Name

KDLV_DELETED_PKG_LINES_U1

UNIQUE

1

DELETED_PKG_LINE_ID

KDLV_DELETED_PKG_LINES_U2

UNIQUE

1

PACKAGE_ID

KDLV_DELETED_PKG_LINES_U2

UNIQUE

2

PACKAGE_LINE_ID

KDLV_DELETED_PKG_LINES_U3

UNIQUE

1

PACKAGE_LINE_ID

Sequences

Sequence Name

Sequence Type

KDLV_DELETED_PKG_LINES_S

DELETED_PKG_LINE_ID