Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 5 Procedures : proc_instance

proc_instance
The proc_instance table holds information that is specific to an instance of a version of a procedure (or sub-procedure or sub-procedure parameter template).
Structure
The proc_instance table has the following structure:
TABLE proc_instance(
node_id
number(5) NOT NULL,
proc_id number(5) NOT NULL,
major_vers number(5) NOT NULL,
minor_vers number(5) NOT NULL,
pd_version number(7) NOT NULL,
pi_first_step varchar2(8) ,
pi_rpa_start number(1) ,
pi_rpa_admin number(1) ,
pi_has_eis_objs number(1) ,
pi_has_subprocs number(1) )
Flag that defines whether (1) or not (0) Remote Procedure Access (RPA) case start restrictions are set in the procedure definition.
Flag that defines whether (1) or not (0) Remote Procedure Access (RPA) administration restrictions are set in the procedure definition.
Flag that defines whether (1) or not (0) the procedure definition contains EIS objects.
Flag that defines whether (1) or not (0) the procedure definition contains sub-procedure steps or graft steps.
Primary Key
The following primary key is defined for this table.
Foreign Keys
The following foreign key is defined for this table.

1
This key enforces the DELETE CASCADE referential action.

Indexes
The following index is defined for this table.
Storage
The following STORAGE values are defined for this table.
Table Activity
The proc_instance table contains one row for each instance of each procedure (or sub-procedure or sub-procedure parameter template) defined on the system.
Rows are added, updated and deleted in the following situations.

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.