View Stored Procedure Details

Viewing Stored Procedure Details

This page allows you to view the stored procedure rules, for each combination of Business Process Chain and Business Function. You can view the entire list of parameters predefined for the combination of Business Process Chain and Business Function. You can view whether each parameter is an input or output, and the parameter type and length. Additionally, the system shows the exhaustive list of database variables under the business process chain.

Select the hyperlink for viewing the stored procedure from the required page.

The “View Stored Procedure Details” page appears.

The system displays the following.

Rule For

The name of the business process chain, in combination with the name of the pertinent business function.

Using the example above, this field will show “Leave Management - Prorata Rule”, where Leave Management is the business process chain and Prorata Rule is the business function.

Rule ID

The identification number or code that uniquely identifies the stored procedure rule.

Rule Description

The description of the rule.

The system displays the input and output parameters for the combination of business process chain and business function in the “Parameters” multiline.

Parameter Name	The name of each parameter applicable for the combination of business process chain and business function.
Input/Output	Whether the parameter is an input or an output.
Type	The type of parameter, whether integer, character or date.
Length	The length of the parameter.

The system displays the variables specific to the business process cycle in the “Database Variables” multiline.

Database Variable	Each variable specific to the combination of business process chain and business function.
Database Variable Details	The exact meaning of the variable.

The system displays the rule description, the existing code of the stored procedure, the parameters and the database variables specific to the business function in the “Stored Procedure” group box.