Search Results get_fk_igs_pr_class_std

Overview

IGS_PR_CSS_CLASS_STD_PKG is a standard Oracle E-Business Suite 12.1.1 / 12.2.2 PL/SQL API belonging to the Student Systems (IGS) product family, specifically the Academic Regulations and Progression module. The package encapsulates the database logic that governs a single entity: the IGS_PR_CSS_CLASS_STD record, a child table that links a Progression Calendar Schedule (IGS_PR_CS_SCHDL_ID) to a Progression Class Standard (IGS_PR_CLASS_STD_ID), capped by minimum credit points, maximum credit points, and an academic year value. This intersection, defined once, is what allows the system to state how many credit points must be achieved in a given academic year against a particular class standard for a given progression schedule.

The package is declared AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the calling session rather than the package owner. In practice, this means the API is invoked from within the APPS schema or from an account that has been granted the appropriate APPS privileges and synonyms. It is classified as OTHER in the ETRM registry, indicating that it is an internal, table-maintained API rather than a business-documented public interface.

Key Procedures and Functions

• INSERT_ROW — Creates a new progression class standard record, returning the generated ROWID and the new surrogate primary key to the caller.
• LOCK_ROW — Obtains a row-level lock on an existing record, protecting against concurrent modification before an update or delete.
• UPDATE_ROW — Updates an existing record identified by its ROWID with a supplied set of column values.
• ADD_ROW — A convenience wrapper that performs the add path for a new record, returning the ROWID and primary key, typically handling the pre-DML validation and the insert together.
• DELETE_ROW — Removes a record identified by its ROWID.
• GET_PK_FOR_VALIDATION — Returns BOOLEAN, confirming whether a given surrogate primary key corresponds to a valid record.
• GET_UK_FOR_… — Validates the unique key combination for the entity; a BOOLEAN return confirms uniqueness of the class standard plus schedule pair.
• GET_FK_IGS_PR_CS_SCHDL — Foreign-key validation routine that checks a supplied progression calendar schedule identifier against the parent table.
• GET_FK_IGS_PR_CLASS_STD — The routine at the centre of the searched term; it validates that a supplied IGS_PR_CLASS_STD_ID exists in the parent Progression Class Standard table before any child record is committed.
• BEFORE_DML — The internal pre-DML hook that performs the standard column defaulting, who-column population, and validation checks called by the insert, update, and delete paths.

Tables Accessed

• IGS_PR_CSS_CLASS_STD — The primary entity table. All DML operations (insert, update, delete) target this table, and validation routines SELECT against it.
• IGS_PR_CSS_CLASS_STD_S — The corresponding translated/descriptive table (the "_S" suffix follows Oracle's standard internationalisation convention), used to store language-specific descriptive columns.
• DUAL — Used for single-value SELECT statements, typically within validation logic and default checks.

Usage Notes

The package is invoked primarily by the Oracle Forms that maintain the Progression Class Standard Schedule setup and by the associated concurrent programs and workflow processes that build or refresh progression data. It is also referenced by three other packages in the APPS schema, which rely on it as the canonical access path for this entity rather than writing directly to the table. Custom development should call INSERT_ROW, UPDATE_ROW, DELETE_ROW, and the validation functions rather than issuing direct DML, since BEFORE_DML enforces the who-column and defaulting rules that keep the row consistent with the ETRM data model. The GET_FK_IGS_PR_CLASS_STD routine in particular should be used by any custom code that needs to pre-validate a class standard identifier before inserting a linked schedule-standard record.