| Column | Parameter Direction | Data Type (Size) | Description |
|---|---|---|---|
| @WhereClause | INPUT | nvarchar (4000) | Filters the data set based on the selected filtering options. |
| @OrderClause | INPUT | nvarchar (2048) | Orders the data set based on the selected ordering options. |
| Column | Parameter Direction | Data Type (Size) | Description |
|---|---|---|---|
| i_WhereClause | INPUT | varchar2 | Filters the data set based on the selected filtering options. |
| i_OrderClause | INPUT | varchar2 | Orders the data set based on the selected ordering options. |
| o_prc1 | OUTPUT | sys_refcursor | |
| o_prc2 | OUTPUT | sys_refcursor |