Search Results sdo_ordinate_array




Overview
Explore in AI Chat

Overview

MDSYS.PRVT_TIN is an internal Oracle Spatial support package. It belongs to the MDSYS schema, which Oracle E-Business Suite inherits as part of the database tier when Oracle Spatial (Locator) is installed alongside the EBS database. The package name references the "TIN" (Triangulated Irregular Network) construct used in spatial analysis, and the "PRVT_" prefix identifies it as a private, wrapped implementation package rather than a public API. The package body is submitted in wrapped form, meaning its source is obfuscated and unsupported for direct modification. Per the ETRM 12.2.2 metadata it is classified as API type OTHER, and it contains no documented public procedures or functions. This is consistent with its role: it supplies internal helper logic consumed by higher-level Oracle Spatial packages rather than exposing a callable interface to EBS developers or end users. Functionally, it supports the storage and manipulation of triangulation-related spatial data, an area of functionality that is largely irrelevant to core EBS business flows such as order management, purchasing, or financials.

Key Procedures and Functions

The ETRM metadata for MDSYS.PRVT_TIN documents zero public procedures and functions. This is expected for a wrapped private package, where all program units are internal and the specification exposes nothing intended for external invocation. Consequently, no procedure or function names, parameter lists, or signatures can be enumerated from the documented metadata, and none should be assumed. Any routines that exist are implementation details consumed by the calling package identified in the metadata and are not part of any supported integration surface. Developers should treat the package as an opaque dependency of the Oracle Spatial option and should not attempt to call it directly.

Tables Accessed

The metadata records a single table referenced by MDSYS.PRVT_TIN via APPS synonyms: PLITBLM. Access to the PLITBLM table through APPS synonyms indicates that the object is visible to the EBS application schema, though the actual data manipulation occurs within the MDSYS spatial infrastructure. The table supports the internal state and intermediate results required by the package's triangulation logic. The package does not, per the documented metadata, read or write any of the standard EBS transactional or setup tables. Its data footprint is therefore confined to Oracle Spatial's own structures, and it has no impact on application data integrity in the EBS business schema.

Usage Notes

Because MDSYS.PRVT_TIN is a private, wrapped support package within the Oracle Spatial option, it is not invoked directly from EBS forms, concurrent programs, or custom PL/SQL code. It is called internally by other spatial packages; the metadata notes that it is referenced by one other package. In practice, the package becomes active only when spatial operations involving triangulation are executed against geometry data stored in the EBS database through Oracle Spatial or Locator. The search term "pi in tally" has no relation to this object; the initials P and I in the object name are incidental, and there is no dependency on any tally or counting process. EBS technical teams encountering this package in dependency or error analysis should recognize it as part of the MDSYS schema delivered by the database vendor, outside the scope of EBS patching and customization, and should route any related issues to Oracle Spatial support rather than attempting to modify or unwrap the package body.