Search Results igs_as_unitass_item_pkg




Overview
Explore in AI Chat

Overview

IGS_AS_UNITASS_ITEM_PKG is an Oracle EBS Student Systems (IGS) package that manages assessment item records for unit assessment structures. Within the Academic Assessment (IGS_AS) product family, the package supports the persistence, validation, and maintenance of rows held in the IGS_AS_UNITASS_ITEM entities. It functions as a table-handling (dictionary) package rather than as a business-level API, exposing the standard row-level primitives used by Oracle Forms and by other PL/SQL callers to insert, update, lock, and delete assessment item data.

The package is owned by APPS and is currently VALID in the ETRM repository for Oracle EBS 12.1.1 and 12.2.2. It is classified as OTHER in the API classification scheme, indicating that it is intended primarily for internal use by the assessment application modules rather than as a published public API. Its procedure list (18 documented procedures/functions) follows the conventional Oracle Forms table-handler pattern: primary key and unique key lookups, foreign key lookups, constraint checks, and before-DML processing.

Key Procedures and Functions

The documented procedures fall into several functional groupings:

Tables Accessed

The package operates against the following documented objects:

  • IGS_AS_UNITASS_ITEM_ALL — The primary base table holding unit assessment item data. All INSERT, UPDATE, DELETE, and LOCK operations are performed here.
  • IGS_AS_UNITASS_ITEM_S — The sequence/identifier-supporting object used to generate primary key values for newly created rows.
  • DUAL — Used for simple single-value lookups and validation queries.

Usage Notes

The package is referenced by nine other application packages, including IGS_AS_ASSESSMNT_ITM_PKG, IGS_AS_GRD_SCHEMA_PKG, IGS_AS_UNIT_AI_GRP_PKG, IGS_AS_UNT_PATRN_ITM_PKG, IGS_CA_INST_PKG, IGS_CA_TYPE_PKG, IGS_PS_UNIT_OFR_PAT_PKG, and the generated forms packages IGS_AS_GEN_007 and IGS_PS_GEN_008. This dependency profile confirms that it is invoked both from Oracle Forms-based maintenance screens and from within the assessment processing APIs.

When extending or customizing assessment item handling, developers should invoke the package through its row-level primitives rather than writing direct DML against IGS_AS_UNITASS_ITEM_ALL, so that validation and WHO-column population performed by BEFORE_DML and CHECK_CONSTRAINTS are consistently applied. Because the package is classified as OTHER rather than a supported public API, custom code that calls it should be re-validated against the target EBS release during upgrade testing.