Results for “igs_ad_rating_scales_pkg”

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

Overview

IGS_AD_RATING_SCALES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Student Systems / Academic Registry (IGS) product family, specifically the Admissions (AD) module's rating scales functionality. Rating scales provide the configurable grading or scoring frameworks used when assessing applicants against admission criteria. In EBS 12.1.1 and 12.2.2, this package is classified as an "OTHER" API rather than a formal public API, meaning it is primarily a table-handler package generated to manage the DML lifecycle of the underlying rating scale entities. It encapsulates insert, update, delete, and validation logic so that dependent components do not manipulate the base tables directly. The package is currently VALID in the ETRM repository and is referenced by two other packages, IGS_AD_APL_RVPF_RSL_PKG and IGS_AD_RS_VALUES_PKG, confirming its role as a foundational data-access layer for rating scale definitions.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions within this package. Their purposes are as follows:

• INSERT_ROW — Inserts a new rating scale record into the base table, populating the primary key and standard WHO columns.
• UPDATE_ROW — Applies modifications to an existing rating scale row identified by its primary key.
• DELETE_ROW — Removes a rating scale record, typically subject to referential and constraint validation.
• LOCK_ROW — Acquires a row-level lock on the target record to serialize concurrent modifications before update or delete operations.
• ADD_ROW — Performs the combined insert operation, orchestrating validation and defaulting prior to the physical insert.
• GET_PK_FOR_VALIDATION — Resolves and returns primary key information used during validation checks.
• GET_UK_FOR_VALIDATION — Resolves and returns unique key information used to enforce uniqueness during validation.
• CHECK_CONSTRAINTS — Evaluates mandatory, foreign key, and uniqueness constraints against the incoming record.
• BEFORE_DML — Executes pre-DML processing, including WHO column stamping and derived value assignment.

No parameter signatures are asserted here, as the ETRM metadata does not enumerate them.

Tables Accessed

The package operates against two documented tables accessed through APPS synonyms:

• IGS_AD_RATING_SCALES — The primary transactional table holding rating scale definitions. All insert, update, and delete operations target this table.
• IGS_AD_RATING_SCALES_S — The corresponding translated/description table (_S suffix), which stores language-specific textual attributes. Rows are maintained in parallel with the base table to support multi-language installations.

Both tables are read for validation and lock acquisition, and written during insert, update, and delete processing.

Usage Notes

IGS_AD_RATING_SCALES_PKG is not intended for direct invocation by end users. It is normally called indirectly: Oracle Forms-based maintenance screens for rating scales trigger the table-handler routines when the user saves or deletes a record, and the two dependent packages — IGS_AD_APL_RVPF_RSL_PKG and IGS_AD_RS_VALUES_PKG — reference it when processing applicant rating values and rating scale values respectively. Custom or extension code that must create or maintain rating scales should reuse these routines rather than issuing direct DML against IGS_AD_RATING_SCALES, preserving the package's validation, locking, and WHO column conventions. Because the package is classified as OTHER rather than a supported public API, its internal structure is subject to change across patches and upgrades, and any custom dependency on it should be re-verified after applying EBS maintenance packs or upgrading between 12.1.1 and 12.2.2.