Parameters for Execution Step Schedule

The following parameters should be used for execution step schedules.

Table 6-7. Parameters for execution step schedule

Parameter

Usage

Data Type

Description

P_EVENT

Required

VARCHAR2

Specifies the type of workflow transaction.

Set to EXECUTION_SCHEDULE.

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_SCHEDULE_DATE

Required

DATE

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