Search Results get_fk_igs_ps_unit_ver

Overview

IGS_PS_UNIT_OFR_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It encapsulates the data manipulation and validation logic for the IGS_PS_UNIT_OFR entity, which represents unit offerings within the Student Systems (IGS) product family. A unit offering associates a specific unit version with a calendar type, defining the academic unit that is offered within a given teaching period. The package follows the standard Oracle EBS table handler pattern, declaring AUTHID CURRENT_USER and providing a complete set of row-level operations — insert, lock, delete, foreign key lookups, primary key validation, constraint checking, and a centralized Before_DML hook. The header comment identifies the source file as IGSPI82S.pls, version 115.4, last modified in November 2002, confirming it is a long-standing component of the Student Systems schema. The API classification is OTHER, indicating it is treated as an internal table handler rather than a formally published public API, though it remains callable from forms, concurrent programs, and custom extensions. In EBS 12.1.1 and 12.2.2 the package is compiled into the APPS schema and operates against the IGS_PS_UNIT_OFR table through APPS synonyms.

Key Procedures and Functions

• INSERT_ROW — Creates a new unit offering row, accepting the unit code, version number, calendar type, and a processing mode that defaults to 'R'. It returns the ROWID of the newly created record.
• LOCK_ROW — Obtains a row-level lock on an existing unit offering identified by its ROWID and key columns, supporting pessimistic locking in concurrent form sessions.
• DELETE_ROW — Removes a unit offering row identified by ROWID.
• GET_PK_FOR_VALIDATION — A boolean function that validates whether the supplied unit code, version number, and calendar type combination corresponds to an existing primary key in the unit offering table.
• GET_FK_IGS_CA_TYPE — A foreign key validation procedure that verifies the supplied calendar type exists in the IGS_CA_TYPE reference entity.
• GET_FK_IGS_PS_UNIT_VER — The foreign key validation procedure matching the user's search term. It verifies that the supplied unit code and version number identify a valid unit version record, ensuring referential integrity between the unit offering and its parent unit version before DML is permitted.
• CHECK_CONSTRAINTS — A generic constraint validation routine that accepts an optional column name and value, used to enforce column-level business rules.
• BEFORE_DML — A centralized pre-DML hook invoked by the other procedures to apply defaulting, auditing columns, and validation logic consistently across insert, update, and delete actions.

Tables Accessed

The package reads from and writes to IGS_PS_UNIT_OFR, the base table storing unit offering records. All access is performed through the APPS synonym in accordance with EBS schema conventions. Validation routines additionally interrogate the parent reference entities IGS_CA_TYPE and IGS_PS_UNIT_VER indirectly through their foreign key checks, confirming that calendar types and unit versions exist before an offering is created or modified.

Usage Notes

IGS_PS_UNIT_OFR_PKG is typically invoked by the Oracle Forms-based unit offering maintenance screens within the Student Systems responsibility, where LOCK_ROW and INSERT_ROW support interactive record management. Because the package is referenced by seven other packages, it also serves as a dependency for higher-level academic structure APIs and concurrent processes that create or validate unit offerings in bulk. Developers extending Student Systems should call these procedures rather than issuing direct DML against IGS_PS_UNIT_OFR, so that the Before_DML logic, constraint checks, and foreign key validation remain enforced. GET_FK_IGS_PS_UNIT_VER is of particular interest when diagnosing errors raised during unit offering creation, since a failure indicates the referenced unit code and version number do not exist in IGS_PS_UNIT_VER.