KDLV_PACKAGE_NOTES_INT

The KDLV_PACKAGE_NOTES_INT interface table defines the notes attached to the new package. It can only be used when importing a new package and cannot be used to update the notes of an existing package.

Table A-23. KDLV_PACKAGE_NOTES_INT interface table
Column	Usage	Data Type	Description
PACKAGE_NOTE_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. This is required if package lines exist. For new lines, this should be left blank. 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.
PACKAGE_ID	I	NUMBER	Provides an identifier for a package and makes the association between the package and note. Derived from the KDLV_PACKAGES_S sequence. Identifies the package ID. This can be used to tie the note 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. This can be used to tie the note record to the parent record in KDLV_PACKAGES_INT. The PACKAGE_INTERFACE_ID and PACKAGE_ID can be used for this tie as well.
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.
NOTE	I	CLOB	Specifies the full text of the note.
REPLACE_NOTE_FLAG	Obsolete	VARCHAR2	No longer used.