Search Results igs_ps_unitass_item_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_PS_UNITASS_ITEM_PKG package is a PL/SQL database object within the Oracle E-Business Suite (EBS) higher education / student system product family. The IGS prefix identifies the Student Information System design lineage, while the PS component denotes the Program/Plan (course structure) functional area. Within this context, "UNITASS_ITEM" refers to a Unit Association Item, that is, an individual element within a unit association that links academic units (such as units, versions, or offerings) into defined associations. The package encapsulates the programmatic Data Manipulation Logic (DML) for the underlying entity, providing a controlled, reusable layer through which other application logic, forms, and concurrent programs may create, modify, lock, validate, and delete Unit Association Item records without directly manipulating the base tables.

Under ETRM documentation this object is classified as API type OTHER and is marked VALID in schema APPS. It is a well-established dependency in the Student System data model, referenced by five other packages and by the standalone programs IGS_AS_GEN_007 and IGS_PS_GEN_001.

Key Procedures and Functions

The documented body exposes eleven procedures and functions. The DML group comprises INSERT_ROW, UPDATE_ROW, DELETE_ROW, ADD_ROW, and LOCK_ROW, together with the BEFORE_DML trigger-style procedure that enforces attribute derivation and auditing rules prior to any insert or update. LOCK_ROW implements the standard EBS pessimistic locking pattern, ensuring that a record cannot be concurrently modified by another session.

Validation is handled by CHECK_CONSTRAINTS, GET_PK_FOR_VALIDATION, and GET_UK_FOR_VALIDATION, which respectively enforce database-level constraints, retrieve a record identifier by primary key for foreign-key checking, and resolve a unique-key identifier to support the Forms validation mechanism. Two foreign-key lookup functions, GET_FK_IGS_AS_GRD_SCHEMA and GET_FK_IGS_AS_US_AI_GROUP, resolve parent references to the Grading Schema and Unit Set/Assessment Item Group entities, supporting referential integrity between the Unit Association Item and those parent configurations.

Tables Accessed

The package operates against three tables through APPS synonyms: IGS_PS_UNITASS_ITEM, the base transactional table holding Unit Association Item records; IGS_PS_UNITASS_ITEM_S, the corresponding EBS "secure" or supplementary table used to store translated / DFF (Descriptive Flexfield) style attribute data; and IGS_PS_UNITASS_ITEM_SEQ_NUM_S, which supports sequence-number maintenance for ordered items. DUAL is referenced for scalar lookups and sequence retrieval. The two _S tables are typically populated and maintained in tandem with the base row, which is why the package provides paired insert/update/delete logic rather than single-table DML.

Usage Notes

In a standard EBS 12.1.1 or 12.2.2 deployment, IGS_PS_UNITASS_ITEM_PKG is not usually invoked directly by end users. It is most commonly called from Oracle Forms (the Unit Association Item maintenance form) via the Forms DML event hooks, from the concurrent/generation programs that consume its output (IGS_PS_CREATE_GENERIC_PKG, IGS_AS_GEN_007, IGS_PS_GEN_001), and from the higher-level packages IGS_AS_GRD_SCHEMA_PKG and IGS_AS_US_AI_GROUP_PKG. Because it is referenced by these five objects, it forms part of the stable lower-level DML tier of the Student System schema. Custom extensions should invoke the package rather than performing direct INSERT/UPDATE/DELETE on the underlying tables, so that BEFORE_DML logic, constraints, and audit columns remain consistent. Any modification requires recompilation of both the package specification and body, and the object's VALID status in DBA_OBJECTS should be verified after patches or upgrades.