Name

Enter a unique name for the Stored Procedure Application Rule.

Rule Type

Select the Rule Type from the drop-down list. The Stored Procedure Application Rule can be used as a Decision Rule, Execution Rule or Selection Rule based on your requirement.

Execution Type

Displays the Application Execution Type as Stored Procedure.

Procedure Name

Enter the Stored Procedure Name.

Input Parameters

Select the list of Data Fields which will be passed as input parameters, from the drop-down list.

Parameter Mode

Enter the Parameter Mode in JSON format. For example, suppose you have given 3 parameters as input parameters, enter parameter mode as [“IN”,”IN”,”OUT”].During Execution of Stored Procedure,

·       In case of Decision Rule type, the first return parameter should return value ‘PASS’ for success evaluation.

·       In case of Selection Rule type, the first return parameter value is taken as Selection data.

·       In case of Execution Rule, the procedure return OUT parameter value overwrites the current value of respective mapped Data Field.

Scope

Select the Scope as Process to use the Application Rule only in the current process or Package to use the Application Rule across all the processes in the package.