Search Results igs_ad_rs_values_pkg




Overview
Explore in AI Chat

Overview

IGS_AD_RS_VALUES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Student System (formerly Oracle iLearning/Recruiting and Admissions) admissions module. Specifically, it manages the data layer for rating scale values — the individual score, grade, or rating entries that make up a rating scale used during applicant evaluation and admission decision processing. In an admissions context, rating scales (for example, standardized test bands, interview scoring scales, or qualification ratings) require discrete allowable values that evaluators select when scoring an applicant. This package encapsulates the insert, update, delete, locking, and integrity-checking logic required to maintain those values consistently, insulating higher-level admissions packages from direct DML on the underlying tables.

The package is classified as OTHER in the ETRM metadata, meaning it is not a fully published public API but a supporting internal package. It is, nonetheless, a stable dependency of at least two other APPS packages: IGS_AD_APPL_EVAL_PKG (applicant evaluation) and IGS_AD_RATING_SCALES_PKG (rating scale maintenance).

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions:

  • INSERT_ROW — Inserts a new rating scale value record into the base table.
  • UPDATE_ROW — Modifies an existing rating scale value record.
  • DELETE_ROW — Removes a rating scale value record.
  • LOCK_ROW — Issues a row-level lock, typically via SELECT ... FOR UPDATE, to serialize concurrent modifications prior to DML.
  • ADD_ROW — A convenience/entry wrapper that combines validation and insertion logic for adding a value.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key for a supplied record, used to confirm uniqueness and existence during validation.
  • GET_UK_FOR_VALIDATION — Retrieves or validates against the unique key, ensuring no duplicate rating scale value is created within the same scale.
  • GET_FK_IGS_AD_RATING_SCALES — Resolves/validates the foreign key relationship to the parent rating scale record IGS_AD_RATING_SCALES.
  • CHECK_CONSTRAINTS — Performs business-rule and referential integrity checks before committing changes.
  • BEFORE_DML — A pre-DML hook that standardizes WHO-column population (created_by, creation_date, last_updated_by, last_update_date) and invokes constraint validation prior to insert or update.

Tables Accessed

The package operates against two documented tables via APPS synonyms:

  • IGS_AD_RS_VALUES — The base transactional table holding individual rating scale values, including their relationship to a parent rating scale and descriptive attributes.
  • IGS_AD_RS_VALUES_S — The corresponding translation (TL-style) table, storing language-specific descriptive text for each value, enabling multilingual display of rating scale values.

Reads and writes are therefore scoped to value definitions and their translated descriptions, with foreign key integrity enforced against the rating scales table.

Usage Notes

IGS_AD_RS_VALUES_PKG is not intended for direct invocation by end users. It is called programmatically by the admissions forms and by the two dependent packages, IGS_AD_APPL_EVAL_PKG and IGS_AD_RATING_SCALES_PKG, which drive applicant evaluation and rating scale setup respectively. Typical invocation paths include the Rating Scales maintenance form (where administrators define scales and their values) and evaluation processing, where valid values are read during scoring. Because the package is referenced by self-dependency (IGS_AD_RS_VALUES_PKG references itself), internal recursion or nested calls may occur during validation routines. Customizations should prefer the documented wrapper procedures — particularly ADD_ROW and UPDATE_ROW — rather than direct DML, so that BEFORE_DML standardization and CHECK_CONSTRAINTS validation are honored. The behavior is consistent across Oracle EBS 12.1.1 and 12.2.2, as the underlying schema objects are unchanged between these releases.