Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Chapter 6 Procedure Management : pm_objects

pm_objects
The pm_objects stores information about each procedure object (except shortcuts) in the Procedure Management library.
Structure
The pm_objects table has the following structure:
TABLE pm_objects (
object_guid varchar2(36) NOT NULL,
object_type number(5) NOT NULL,
object_name varchar2(64) NOT NULL,
version_major number(5) ,
version_minor number(5) ,
icon_mod_time date NOT NULL,
icon_binary long raw ,
icon_size number(8) NOT NULL,
object_url varchar2(1000) ,
author varchar2(64) ,
object_create_time date NOT NULL,
object_mod_time date NOT NULL,
release_id varchar2(64) ,
security_all number(1) NOT NULL,
proc_id number(5) NOT NULL,
proc_status number(5) )
Procedure object type. Either: library (0), procedure (1), sub-procedure (2) or sub-procedure parameter template (3).
Note: The object’s description (if defined) is also included as part of this field, in brackets following the name.
This value is always 0 if the object is a library.
This value is always 0 if the object is a library.
Value of the Author extended property for this procedure object.
Value of the Date Created extended property for this procedure object, showing the time that this object was created.
Flag that defines whether (1) or not (0) the OEM lock is set for this procedure object.
This value is always -1 if the object is a library.
Primary Key
The following primary key is defined for this table.
Foreign Keys
None.
Indexes
None.
Storage
The following STORAGE values are defined for this table.
Table Activity
The pm_objects table contains one row for each procedure object (except shortcuts) in the Procedure Management library.
Rows are added, updated and deleted in the following situations.

Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved