Search Results igs_ps_unitass_item_seq_num_s

Overview

The APPS.IGS_PS_UNITASS_ITEM_PKG package body is a core database API within the Oracle E-Business Suite Student System (IGS) product family. It manages the persistence and integrity of unit assessment items—the discrete graded components (for example, essays, examinations, or practical submissions) that constitute the assessment structure of a taught unit offering. In functional terms, assessment items link a unit offering option to its assessment scheme, grade schema, and weightings, and they are fundamental to recording student results against a defined academic structure. The package encapsulates the complete data manipulation lifecycle for the IGS_PS_UNITASS_ITEM entity, exposing a controlled API layer over the underlying base table and its associated primary-key and sequence-number views. By centralising insert, update, delete, locking, and validation logic, it protects referential integrity and enforces business rules consistently across all callers, including Oracle Forms, concurrent programs, and custom extensions.

Key Procedures and Functions

The package exposes eleven documented program units, each with a defined role in the entity lifecycle:

• INSERT_ROW — Performs a direct insert of a new assessment item record into the base table.
• UPDATE_ROW — Applies changes to an existing assessment item record.
• DELETE_ROW — Removes an assessment item record from the base table.
• ADD_ROW — Provides an alternative, higher-level creation path that supports generation of surrogate key values and integration with the entity's views.
• LOCK_ROW — Acquires a row-level lock to support concurrent-safe updates and deletes.
• GET_PK_FOR_VALIDATION — Resolves the primary key for validation purposes.
• GET_UK_FOR_VALIDATION — Resolves the unique key, ensuring no duplicate assessment items are created for a given unit offering option.
• GET_FK_IGS_AS_GRD_SCHEMA — Retrieves and validates the foreign key to the grade schema, confirming that the referenced grading structure is valid and active.
• GET_FK_IGS_AS_US_AI_GROUP — Retrieves and validates the foreign key linking the item to its unit assessment item group, ensuring the item belongs to a legitimate parent grouping.
• CHECK_CONSTRAINTS — Performs the aggregate business-rule and constraint validation invoked prior to committing changes.
• BEFORE_DML — A pre-DML hook that executes shared logic (standard who-column population, derived defaults, and validation) immediately before any insert, update, or delete.

Tables Accessed

All table access proceeds through APPS synonyms. The primary base table is IGS_PS_UNITASS_ITEM, which stores the assessment item records themselves. The IGS_PS_UNITASS_ITEM_S and IGS_PS_UNITASS_ITEM_SEQ_NUM_S objects are supporting views that provide primary-key and sequence-number derivation logic, used by ADD_ROW and the validation routines. DUAL is referenced for singleton queries and function-style lookups. Additional documented dependencies include IGS_PS_UNIT_OFR_OPT (the unit offering option to which items attach), IGS_CA_INST (calendar instance data used for date and period context), and the validation and utility packages IGS_PS_VAL_UAI, IGS_PS_VAL_UNIT, IGS_PS_VAL_UOO, IGS_AS_VAL_AIEM, IGS_AS_VAL_UAI, IGS_AS_US_AI_GROUP_PKG, and IGS_AS_GEN_001/IGS_AS_GEN_002. Messaging and error handling are supplied through APP_EXCEPTION, FND_MESSAGE, FND_GLOBAL, and IGS_GE_MSG_STACK.

Usage Notes

The package is normally invoked indirectly, through the Oracle Forms user interface maintained for unit assessment setup, and through concurrent programs that load or maintain assessment structures in bulk. Custom code may call the public procedures directly, but should always use LOCK_ROW before UPDATE_ROW or DELETE_ROW, and should rely on BEFORE_DML and CHECK_CONSTRAINTS to preserve the standard who-column and validation behaviour. The package is referenced by five other database objects in the E-Business Suite schema, confirming its role as a shared API component rather than a private implementation detail. The object is VALID and its status should be checked after any patch application or upgrade between 12.1.1 and 12.2.2, since dependent packages such as the IGS_AS validation routines will fail to compile if this package is invalidated.