Search Results igs_ps_media_equip_pkg




Overview
Explore in AI Chat

Overview

IGS_PS_MEDIA_EQUIP_PKG is an Oracle EBS Student Systems (Oracle iGS / Student Information) package body owned by the APPS schema. It encapsulates the DML processing logic for the media equipment entity, which models the media equipment resources associated with units or facilities in an educational institution. Media equipment records represent the physical instructional media assets (such as projectors, audio-visual systems, or laboratory equipment) that are attached to a teaching facility or unit of study. The package serves as the table handler for the underlying base table and its _ALL variant, providing a controlled, reusable API layer for insert, update, delete, locking, and constraint-validation operations rather than allowing applications to issue direct DML. It is classified as OTHER within the ETRM API taxonomy, meaning it is a supporting table-handler package rather than a public business API, and it is consumed internally by other Student System packages. The package body is documented as VALID and is present in both Oracle EBS 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The package body exposes eight documented procedures that together form a complete DML lifecycle for the media equipment entity:

  • INSERT_ROW — Performs the core insert of a new media equipment record into the base table, populating the standard WHO columns and primary key.
  • ADD_ROW — A higher-level wrapper that inserts a row while invoking the associated validation and constraint-checking logic before the physical insert.
  • UPDATE_ROW — Modifies an existing media equipment record, applying the same WHO audit column maintenance expected of Oracle EBS table handlers.
  • DELETE_ROW — Removes an existing media equipment record from the table.
  • LOCK_ROW — Acquires a row-level lock (typically SELECT ... FOR UPDATE) to serialize concurrent modifications to the same media equipment record.
  • CHECK_CONSTRAINTS — Validates the business and referential constraints that apply to the entity before DML is committed, raising errors through the message-stack utilities when violations are detected.
  • GET_PK_FOR_VALIDATION — Returns the primary key of the row being processed so that dependent validations and foreign-key checks can be resolved.
  • BEFORE_DML — A pre-DML hook invoked by the calling procedures to perform shared set-up, defaulting, and consistency checks prior to any insert, update, or delete operation.

Tables Accessed

The documented table accessed through APPS synonyms is IGS_PS_MEDIA_EQUIP_ALL, the multi-org (operating unit) enabled table that stores media equipment records. All DML operations performed by the package target this table. The dependency listing additionally identifies the non-_ALL view/table IGS_PS_MEDIA_EQUIP, which is referenced by the package for read access and validation purposes. The _ALL designation indicates that the entity is partitioned by operating unit and that the package respects the multi-org security model of Oracle EBS.

Usage Notes

IGS_PS_MEDIA_EQUIP_PKG is not referenced by any database object directly, but it in turn depends on several shared Student System utilities: APP_EXCEPTION, FND_GLOBAL (for session and user context such as WHO columns and org context), FND_MESSAGE and IGS_GE_MSG_STACK (for error message construction and the message stack), the general utility IGS_GE_GEN_003, and the sibling facility table handlers IGS_PS_UNIT_FACILITY_PKG and IGS_PS_USO_FACILITY_PKG. The package is documented as being referenced by three other packages, confirming its role as an internal service layer. In practice it is invoked from Oracle Forms-based maintenance screens, from concurrent programs that load or maintain media equipment data, and from custom PL/SQL extensions that need to create or amend media equipment records using supported logic rather than direct SQL. Because the procedures enforce constraint checking and locking, customizations should always call this package instead of issuing INSERT, UPDATE, or DELETE statements against IGS_PS_MEDIA_EQUIP_ALL directly.