Share this page

# 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: