Parameters for Execution Step Schedule
The following parameters should be used for execution step schedules.
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. |