Search Results igs_as_unt_patrn_itm_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_AS_UNT_PATRN_ITM_PKG package is a PL/SQL database object within the Oracle E-Business Suite (EBS) Student Systems product family, specifically belonging to the IGS (Student Information) module. It forms part of the assessment and unit pattern configuration infrastructure. In EBS 12.1.1 and 12.2.2, this package is classified as an OTHER API type, meaning it is a supporting data-access package rather than a published, externally supported business API. Its primary role is to manage the persistence and validation of records held in the IGS_AS_UNT_PATRN_ITM table, which stores unit pattern item definitions linking assessment patterns to individual units or unit offerings. The package is registered as VALID in the APPS schema and was generated following the Oracle Designer/Table API convention used widely throughout the IGS schema, as evidenced by the standard set of CRUD and constraint-checking procedures documented in the ETRM metadata.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions within this package, all of which follow the conventional Table API pattern applied across IGS tables:

  • INSERT_ROW — Inserts a new row into the underlying table, populating all mandatory columns.
  • LOCK_ROW — Issues a SELECT ... FOR UPDATE against the target row to serialize concurrent access before modification.
  • UPDATE_ROW — Updates an existing row identified by its primary key.
  • ADD_ROW — Higher-level wrapper that inserts a row and returns metadata, commonly used to add records with generated or validated key values.
  • DELETE_ROW — Removes a row from the table by primary key.
  • GET_PK_FOR_VALIDATION — Resolves and returns the primary key value used for validation of the row, supporting referential integrity checks.
  • GET_FK_IGS_AS_UNITASS_ITEM — Returns the foreign key value referencing the assessment unit item parent entity.
  • GET_FK_IGS_AS_UNTAS_PATTERN — Returns the foreign key value referencing the unit assessment pattern parent entity.
  • CHECK_CONSTRAINTS — Validates all applicable foreign key and check constraints before a DML operation proceeds.
  • BEFORE_DML — Centralized pre-DML handler that performs standardized validation and auditing logic prior to insert, update, or delete.

These routines are invoked collectively as part of a coordinated DML sequence, ensuring that row-level locking, constraint validation, and foreign key resolution occur in the correct order.

Tables Accessed

The package operates against a single documented base table, IGS_AS_UNT_PATRN_ITM, referenced through an APPS synonym. This table holds the item-level detail rows that constitute a unit assessment pattern. The package's two foreign key accessor routines confirm that the table participates in referential relationships with the assessment unit item and unit-assessment pattern parent tables, though the metadata enumerates only IGS_AS_UNT_PATRN_ITM explicitly as the directly referenced table. All reads and writes are performed within the APPS schema context.

Usage Notes

This package is typically invoked indirectly rather than called by end users directly. Its documented caller is IGS_AS_UNTAS_PATTERN_PKG, the parent pattern-level package, which delegates item-level operations to it. This package is also self-referential, indicating internal recursion or cascade handling. Because it is classified as OTHER rather than a public API, it should be treated as an internal implementation detail; customizations should avoid direct invocation and instead use supported parent-level APIs or Oracle Forms-based maintenance screens where available. In both 12.1.1 and 12.2.2, the source can be inspected via the ETRM "show dependent code" facility or the data dictionary views ALL_SOURCE and ALL_DEPENDENCIES. Given its VALID status and its limited dependency footprint, the package is stable and requires no patching beyond standard IGS module maintenance.