Results for “igs_ps_generic_pvt”

13 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.IGS_PS_GENERIC_PVT package body is a private PL/SQL implementation unit within the Oracle E-Business Suite Student Systems (Higher Education) product family. It belongs to the IGS application module, which governs institution-wide academic structures such as programs, units, attendance types, and program enrollments. The _PVT suffix denotes the package's classification as a private API layer, intended to hold internal business logic that supports the corresponding public package, IGS_PS_GENERIC_PUB. In this capacity, the package encapsulates procedures that manipulate generic program/unit data structures but that are not exposed as supported public entry points for external integration.

The object is documented in the ETRM repository with a status of VALID and an owner of APPS. Its documented API classification is PVT, and the metadata records a single documented procedure, PSP_IMPORT. The package body depends on several standard Oracle EBS framework and IGS packages, indicating that it participates in the standard API error-handling and logging conventions used throughout the applications schema.

Key Procedures and Functions

The ETRM metadata documents one procedure within this package body:

  • PSP_IMPORT — The documented entry point for the package. Based on its naming convention and its position within the IGS private API layer, this procedure handles the import of generic program or unit data into the IGS data model. It is an internal routine, and its parameter list is not reproduced here because the ETRM metadata does not enumerate parameters. Implementers should treat PSP_IMPORT as private and route supported business operations through the public layer instead.

No functions are documented for this package body. The absence of a recorded function list, combined with the presence of the PSP_IMPORT procedure, indicates a procedural processing focus rather than a query/return-value focus.

Tables Accessed

The documented table reference for this package is PLITBLM, accessed via an APPS synonym. PLITBLM is the standard PL/SQL table (index-by table) support structure used internally by the Oracle toolset. It is not an application data table in the IGS schema, and no IGS transactional tables are recorded in the dependency metadata excerpt. Consequently, the documented evidence indicates that the package's own persistent data manipulation is carried out indirectly through its dependencies rather than through direct table DML recorded at this level.

This pattern is consistent with a private wrapper or orchestration package, where actual inserts, updates, and validations against IGS program/unit tables are delegated to cooperating packages such as IGS_PS_CREATE_GENERIC_PKG, IGS_PS_UNIT_LGCY_PKG, and IGS_PS_GENERIC_PUB.

Usage Notes

IGS_PS_GENERIC_PVT is not referenced by any other database object according to the documented dependency information, which confirms its role as a leaf-level private implementation. Its notable dependencies include the public package IGS_PS_GENERIC_PUB, the generic creation package IGS_PS_CREATE_GENERIC_PKG, the legacy unit package IGS_PS_UNIT_LGCY_PKG, and the framework packages FND_API, FND_MESSAGE, FND_MSG_PUB, and FND_LOG. The presence of FND_API and FND_MSG_PUB indicates adherence to the standard EBS API error-stack and message conventions, while FND_LOG supports debug and diagnostic logging.

Because it is a private package, it is not intended for direct invocation from Oracle Forms, concurrent programs, or custom integration code. Supported operations should be performed through IGS_PS_GENERIC_PUB, which in turn may call into this private body. In both Oracle EBS 12.1.1 and 12.2.2, the technical architecture and schema ownership remain unchanged; only the runtime editioning and online patching mechanisms of 12.2.x differ at the platform level, without altering this package's calling contract.