SW_CLOSE_WITHOUT

Copyright © Cloud Software Group, Inc. All Rights Reserved

Appendix C SSOLite Stored Procedures : Command Procedures : SW_CLOSE_WITHOUT_EVENT

SW_CLOSE_WITHOUT_EVENT

The SW_CLOSE_WITHOUT_EVENT procedure closes an active case of a procedure without triggering the events that are set for the OnBeforeClose event or the OnAfterClose event.

Syntax

SW_CLOSE_WITHOUT_EVENT (
proc_name in varchar2(8),
proc_maj_ver in number(5),
proc_min_ver in number(5),
case_number in integer,
user_id in varchar2(24))

where:

•

proc_name is the name of the procedure that you want to close a case of.

•

proc_maj_ver is either the major version number of the proc_name procedure, or -1. See the notes below.

•

proc_min_ver is either the minor version number of the proc_name procedure, or -1. See the notes below.

•

case_num is the number of the case that is to be closed.

•

user_id is the name of the iProcess user who is closing the case.

Notes

Instead of using the specific major and/or minor version number of the procedure, you can specify both the proc_maj_ver and proc_min_ver parameters as -1. If you do this, iProcess will use the version number of the procedure that the case was originally started with or, that it has subsequently been migrated to (if a subsequent version has been released while the case is still in progress).

If you specify one version number parameter as -1, you must specify the other one as -1 as well.

Example

This example closes the 103 case of the CUSTREQ procedure without triggering an event.

EXEC SSOLITE.SW_CLOSE ('CUSTREQ', -1, -1, 103, 'swadmin')