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