KWFL_TXN_INT.INSERT_ROW

The Workflow Transaction Open Interface can be used for different types of transactions. Different parameters are required or optional depending upon the type of transaction. The values are established using the INSERT_ROW procedure in the KWFL_TXN_INT package.

Table A-32. KWFL_TXN_INT.INSERT_ROW parameters

Parameter

Usage

Data Type

Description

P_EVENT

I

VARCHAR2

Specifies the type of workflow transaction.

The value depends on the type of transaction.

P_GROUP_ID

I/O

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

I

VARCHAR2

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

P_SOURCE

I

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

I

VARCHAR2

Identifies the request.

P_PACKAGE_NUMBER

I

VARCHAR2

Identifies the package number.

P_PACKAGE_LINE_SEQ

I

NUMBER

Provides the identifier for a package line.

Derived from the KDLV_PACKAGE_LINES_S sequence.

P_WORKFLOW_STEP_NAME

I

VARCHAR2

Specifies the name of the workflow step (STEP_NAME from KWFL_WORKFLOW_STEPS).

P_WORKFLOW_STEP_SEQ

I

VARCHAR2

Specifies the sequence number of the workflow step.

For subworkflows, the sequence numbers of the workflow steps could be in the form of 2.4.5 and so forth.

P_VISIBLE_RESULT_VALUE

I

VARCHAR2

Indicates the result of the step. This is the result value that a user normally sees.

P_USER_COMMENTS

I

VARCHAR2

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

P_DELEGATED_TO_USERNAME

I

VARCHAR2

Specifies the USERNAME (from KNTA_USERS) for the user that the decision is being delegated to.

P_SCHEDULE_DATE

I

DATE

Indicates the date that the execution step is scheduled to run.

P_TO_WORKFLOW_STEP_NAME

I

VARCHAR2

Specifies the name of the workflow step (STEP_NAME from KWFL_WORKFLOW_STEPS) for the step that the package line or request should transition to.

P_TO_WORKFLOW_STEP_SEQ

I

VARCHAR2

Specifies the sequence number of the workflow step for the step that the package line or request should transition to.

O_MESSAGE_TYPE

O

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

O

VARCHAR2

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

This is used mainly for debugging purposes.

O_MESSAGE

O

VARCHAR2

Provides the error message.