P_EVENT

Required

VARCHAR2

Specifies the type of workflow transaction.

The value depends on the type of transaction.

P_GROUP_ID

Optional

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.

If left blank, the value is generated by the system.

P_CREATED_USERNAME

Required

VARCHAR2

Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction.

P_SOURCE

Optional

VARCHAR2

Specifies the source of the information. This information is not validated during an import.

For example, the name of the third-party application or a value of CONVERSION.

P_REQUEST_NUMBER

Requirement varies

VARCHAR2

Identifies the request.

Supply this or P_PACKAGE_NUMBER.

P_PACKAGE_NUMBER

Requirement varies

VARCHAR2

Identifies the package number.

Supply this or P_REQUEST_NUMBER.

P_USER_COMMENTS

Optional

VARCHAR2

Specifies comments for the transaction. Any comments are appended to the notes for the package or request.

O_MESSAGE_TYPE

Leave blank

NUMBER

Indicates what type of error occurred.

Valid values (from KNTA_Constant) are:

• SUCCESS - No error occurred

• USER_ERR - User error

• INTERNAL_ERR - An internal error occurred

• WARNING - A non-fatal warning is returned

O_MESSAGE_NAME

Leave blank

VARCHAR2

Specifies the internal message name of the error that was returned.

This is used mainly for debugging purposes.

O_MESSAGE

Leave blank

VARCHAR2 (1000)

Provides the error message.