Results for “igs_as_suaai_ouhist_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AS_SUAAI_OUHIST_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It belongs to the Oracle Student System (originally the Higher Education product, prefix IGS) and is classified in the ETRM repository as an "OTHER" API rather than a public interface API. Its name expands to the Student Unit Attempt Assessment Item Organisational Unit history entity, indicating that it maintains historical audit rows for assessment item records that are scoped to an organisational unit. In practice, the package behaves as a generated, table-handler style wrapper: it encapsulates the DML and locking logic for a single base table and exposes it through a uniform set of procedures. It is not intended as a business-facing API; instead it supports the internal persistence and validation of the IGS_AS_SUAAI_OUHIST record set while enforcing primary and foreign key integrity.

Key Procedures and Functions

The package exposes nine documented program units, consistent with Oracle's standard generated table-handler pattern:

• INSERT_ROW — performs the initial insert of a new organisational unit history row into the base table, applying the mandatory column values and defaulting logic required for a valid record.
• UPDATE_ROW — modifies an existing history row, updating the columns supplied by the caller while preserving the primary key.
• LOCK_ROW — acquires a row-level lock on the target record, typically used to serialise concurrent updates and to detect lost-update conflicts.
• ADD_ROW — a higher-level insert routine that combines attribute assignment with the insert operation, often used where additional derived values must be set before the row is written.
• DELETE_ROW — removes an existing history row from the base table.
• GET_PK_FOR_VALIDATION — returns the primary key of the target row so the caller can validate existence before performing update or delete operations.
• GET_FK_IGS_AS_SU_ATMPT_ITM — resolves the foreign key relationship to the student unit attempt item entity, supporting referential validation and lookups.
• GET_FK_IGS_AS_SUA_AI_GROUP — resolves the foreign key relationship to the student unit attempt assessment item group entity.
• BEFORE_DML — a pre-DML hook that enforces validation and derivation rules prior to an insert, update, or delete being committed.

Tables Accessed

The package operates against a single documented base table, IGS_AS_SUAAI_OUHIST, referenced through its APPS synonym. This table stores the historical/audit rows for student unit attempt assessment items associated with an organisational unit. All insert, update, lock, and delete operations are directed at this table. The foreign key helper functions indicate that the table carries references to IGS_AS_SU_ATMPT_ITM (the student unit attempt assessment item) and to the assessment item group entity, so the package participates in the referential integrity chain linking history rows back to their parent assessment records.

Usage Notes

Because the package is classified as a non-public ("OTHER") API, it is not normally called directly by end users or external integrations. It is most commonly invoked by the Oracle Student System forms and by higher-level assessment packages that need to persist or maintain organisational unit history rows. The ETRM dependency listing confirms that IGS_AS_SUAAI_OUHIST_PKG is referenced by IGS_AS_SUA_AI_GROUP_PKG and IGS_AS_SU_ATMPT_ITM_PKG, meaning those packages use it when processing assessment item groups and attempt items respectively. In Oracle EBS 12.1.1 and 12.2.2 the package remains VALID in the APPS schema and depends only on SYS.STANDARD, so it can be recompiled and validated cleanly. Custom extensions should avoid direct DML on IGS_AS_SUAAI_OUHIST and instead route changes through these procedures to ensure the locking, key validation, and BEFORE_DML rules are consistently applied.