Normally, the attribute
object_type in
acs_object_types has the same value as the attribute
package_name. For the core packages, just the following cases differ.
oacs-5-9-1=# select object_type, supertype, package_name from acs_object_types where object_type <> package_name;
object_type | supertype | package_name
---------------+------------+--------------------
relationship | acs_object | acs_rel
user | person | acs_user
group | party | acs_group
It means that the the (Oracle) package "acs_rel" defines the object_type "relationship".
How can this hinder you? Probably, the differences are more or less there for legacy reason. In my opinion, it would be better to define the package names after the type and to drop the attribute package_name. But that could be only done by someone developing in an Oracle installation.
If this hinders you, please tell, what the exact problem is.
