Parameters for Forced Workflow Step Transition

The following parameters should be used for a workflow step transition.

Table 6-10. Parameters for forced workflow step transition

Parameter

Usage

Data Type

Description

P_EVENT

Required

VARCHAR2

Specifies the type of workflow transaction.

Set to FORCE_TRANSITION.

Note that this does not work between a subworkflow and its parent workflow.

P_PACKAGE_LINE_SEQ

Requirement varies

NUMBER

Provides the identifier for a package line.

Derived from the KDLV_PACKAGE_LINES_S sequence.

Use if the transaction is for a package line.

P_WORKFLOW_STEP_NAME

Requirement varies

VARCHAR2

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

Supply this or P_WORKFLOW_STEP_SEQ.

P_WORKFLOW_STEP_SEQ

Requirement varies

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.

Supply this or P_WORKFLOW_STEP_NAME.

P_VISIBLE_RESULT_VALUE

Required

VARCHAR2

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

P_TO_WORKFLOW_STEP_NAME

Requirement varies

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.

Supply this or P_TO_WORKFLOW_STEP_SEQ.

P_TO_WORKFLOW_STEP_SEQ

Requirement varies

VARCHAR2

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

Supply this or P_TO_WORKFLOW_STEP_NAME.