Search Results igs_pr_css_class_std_s

Overview

IGS_PR_CSS_CLASS_STD_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as an "OTHER" API. It belongs to the Student System (IGS) product family and, more specifically, to the Progression and Awards module, where it supports the maintenance of class standing records associated with a student's academic progression. The package encapsulates the standard insert, update, delete, locking, and validation logic required to keep the IGS_PR_CSS_CLASS_STD entity consistent within the EBS data model.

The "_PKG" naming convention indicates that it is a generated or seeded package that wraps the base table, providing a controlled interface for forms, concurrent programs, and other dependent packages. Under ETRM 12.1.1, the package is documented as VALID and exposes ten procedures and functions. It is referenced by three other database objects, confirming its role as a shared utility layer within the progression and awards schema.

Key Procedures and Functions

• INSERT_ROW — Inserts a new row into the underlying class standing table, applying the standard column defaults and audit information.
• LOCK_ROW — Acquires a row-level lock against the target record to serialize concurrent updates.
• UPDATE_ROW — Applies changes to an existing class standing record.
• ADD_ROW — Combines validation and insertion into a single entry point for a new class standing row.
• DELETE_ROW — Removes a class standing record, typically after integrity checks.
• GET_PK_FOR_VALIDATION — Resolves the primary key of the target row so that dependent validation logic can be executed.
• GET_UK_FOR_VALIDATION — Returns the unique key attributes used to detect duplicates before insert or update.
• GET_FK_IGS_PR_CS_SCHDL — Derives the foreign key reference to the class schedule entity (IGS_PR_CS_SCHDL).
• GET_FK_IGS_PR_CLASS_STD — Derives the foreign key reference to the class standing entity (IGS_PR_CLASS_STD).
• BEFORE_DML — The pre-DML hook that orchestrates validation, defaulting, and audit stamping before any insert, update, or delete is committed.

Tables Accessed

The package reads from and writes to IGS_PR_CSS_CLASS_STD, the base table holding class standing records, and IGS_PR_CSS_CLASS_STD_S, its translated or secondary description table. DUAL is referenced for single-row calculations and default value derivation. The two foreign key helper functions indicate that the package validates against the class schedule and class standing parents before persisting a row, ensuring referential integrity within the progression and awards model.

Usage Notes

IGS_PR_CSS_CLASS_STD_PKG is typically invoked from the OAF or Forms-based maintenance pages for class standing, from concurrent programs that bulk-process student progression records, and from custom PL/SQL that needs to create or amend class standing assignments programmatically. Because the package is referenced by three other database objects, changes to its behaviour can cascade across the progression and awards module, so it should be treated as a core seeded component rather than a customization point. Error handling is centralised through APP_EXCEPTION, FND_MESSAGE, and IGS_GE_MSG_STACK, with FND_GLOBAL supplying session context such as the current user and responsibility. Developers extending the module should call the public procedures rather than writing directly against the underlying tables, preserving the validation and audit logic embedded in BEFORE_DML.