KDLV_DELETED_PACKAGES

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

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

ASSIGNED_TO_USER_ID

KNTA_USERS

USER_ID

CREATED_BY

KREL_DISTRIBUTIONS

DISTRIBUTION_ID

DISTRIBUTION_ID

KWFL_STEP_TRANSACTIONS

STEP_TRANSACTION_ID

DIST_STEP_TRANSACTION_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KDLV_PACKAGES

PACKAGE_ID

PACKAGE_ID

KWFL_STEP_TRANSACTIONS

STEP_TRANSACTION_ID

PARENT_STEP_TRANSACTION_ID

KDLV_PACKAGES

PACKAGE_ID

SOURCE_PACKAGE_ID

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

USER_DATA_SET_CONTEXT_ID

KWFL_VERIFICATION_TEMP

WORKFLOW_ID

WORKFLOW_ID

KWFL_WORKFLOWS_NLS

WORKFLOW_ID

WORKFLOW_ID

KNTA_SECURITY_GROUPS_NLS

SECURITY_GROUP_ID

ASSIGNED_TO_GROUP_ID

Column Descriptions

Column Name

Null?

Data Type

Description

DELETED_PACKAGE_ID

NOT NULL

NUMBER

System-generated identifier

PACKAGE_ID

NOT NULL

NUMBER

System-generated identifier

DELETED_BY

NOT NULL

NUMBER

Identifier for user who deleted the package

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

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

PACKAGE_NUMBER

NOT NULL

VARCHAR2(40)

User-defined Package number for the Package

ASSIGNED_TO_USER_ID

NULLABLE

NUMBER

ID of the user to which this Package is assigned to

ASSIGNED_TO_GROUP_ID

NULLABLE

NUMBER

ID of the group to which this Package is assigned to

DESCRIPTION

NULLABLE

VARCHAR2(240)

Short description of the Package

RELEASE_DATE

NULLABLE

DATE

Date Package is released (sets status to in-progress)

PRIORITY_CODE

NULLABLE

VARCHAR2(30)

Lookup code for 'REQUEST_PRIORITY'

PRIORITY_SEQ

NULLABLE

NUMBER

Tasks with smaller priority sequence are run earlier

STATUS_CODE

NOT NULL

VARCHAR2(30)

Lookup code for 'REQUEST_STATUS'

PROJECT_CODE

NULLABLE

VARCHAR2(30)

Project that this Package belongs to

WORKFLOW_ID

NULLABLE

NUMBER

Workflow being used to route this Package

PARENT_STEP_TRANSACTION_ID

NULLABLE

NUMBER

Reference ID of parent Request

PACKAGE_TYPE_CODE

NULLABLE

VARCHAR2(30)

Lookup code for 'REQUEST_TYPE'

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_ID

NULLABLE

NUMBER

Identifier of the original Package for this Distribution placeholder Package

DISTPKG_STATUS_MEANING

NULLABLE

VARCHAR2(200)

Displayed status of this Distribution Package

RUN_GROUP

NULLABLE

NUMBER

Run group number of this Distribution Package

DISTRIBUTION_ID

NULLABLE

NUMBER

Identifier of the Distribution that this Package belongs to

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Denote whether this Distribution Package is enabled or disabled

DIST_STEP_TRANSACTION_ID

NULLABLE

NUMBER

Identifier for the Package-level subworkflow step transaction of the Distribution that this Package belongs to

DIST_WORKFLOW_STEP_ID_PATH

NULLABLE

VARCHAR2(200)

Path of the Distribution Workflow Step that was executed in the transaction with DIST_STEP_TRANSACTION_ID

PERCENT_COMPLETE

NOT NULL

NUMBER

Percent complete of this Package (100 if the Package is closed)

Indexes

Index Name

Index Type

Sequence

Column Name

KDLV_DELETED_PACKAGES_N1

NONUNIQUE

1

ASSIGNED_TO_USER_ID

KDLV_DELETED_PACKAGES_N2

NONUNIQUE

1

WORKFLOW_ID

KDLV_DELETED_PACKAGES_N3

NONUNIQUE

1

CREATION_DATE

KDLV_DELETED_PACKAGES_N4

NONUNIQUE

1

PACKAGE_NUMBER

KDLV_DELETED_PACKAGES_U1

UNIQUE

1

DELETED_PACKAGE_ID

KDLV_DELETED_PACKAGES_U2

UNIQUE

1

PACKAGE_ID

Sequences

Sequence Name

Sequence Type

KDLV_DELETED_PACKAGES_S

DELETED_PACKAGE_ID