Search Results get_fk_igs_ad_code_classes

Overview

IGS_AD_RECRUIT_PI_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Admissions recruitment functionality, specifically the management of recruitment probability index data. The package encapsulates the database logic required to manipulate the IGS_AD_RECRUIT_PI entity, which records probability index values associated with prospective students, probability types, calculation dates and probability sources. Because the package is declared AUTHID CURRENT_USER, it executes with the privileges of the invoking schema rather than the definer, a design choice typical of generated table-handler APIs that are intended to be called from forms, concurrent programs, or custom extensions operating under the APPS account.

The package follows the standard Oracle Forms-generated table handler pattern, exposing a predictable set of DML wrappers, validation functions, foreign key helper lookups and a before_dml trigger procedure. This makes it a reusable interface for maintaining recruitment probability records while enforcing the base-table constraints defined on the underlying tables.

Key Procedures and Functions

• INSERT_ROW — Inserts a new probability index record, returning the generated rowid and probability index identifier.
• LOCK_ROW — Acquires a row-level lock on an existing record to support optimistic concurrency control during updates.
• UPDATE_ROW — Updates an existing probability index record identified by rowid.
• ADD_ROW — Combines insert and update semantics, adding a row when absent or updating it when present.
• DELETE_ROW — Deletes a probability index record identified by its rowid.
• GET_PK_FOR_VALIDATION — Validates that a supplied probability index identifier corresponds to an existing primary key.
• GET_UK_FOR_VAHIDATION — Validates uniqueness across the probability type code, calculation date and person combination.
• CHECK_CONSTRAINTS — Evaluates column-level base table constraints, optionally scoped to a single column and value.
• GET_FK_IGS_PE_PERSON — Foreign key helper that validates the referenced party/person identifier against IGS_PE_PERSON.
• GET_FK_IGS_AD_CODE_CLASSES — Foreign key helper that validates a supplied code identifier against the IGS_AD_CODE_CLASSES reference table. This is the routine referenced by the search term and is used to verify that probability type or source codes belong to the appropriate code class before DML is permitted.
• BEFORE_DML — Central pre-DML processing routine invoked prior to insert, update or delete operations.

Tables Accessed

The package operates on two documented tables accessed through APPS synonyms. IGS_AD_RECRUIT_PI is the primary transactional table holding probability index records, and IGS_AD_RECRUIT_PI_S is its corresponding secondary or translated table used to store language-specific attribute descriptions. Foreign key validation routines reference IGS_PE_PERSON and IGS_AD_CODE_CLASSES to confirm that person and code references remain valid.

Usage Notes

This package is typically invoked from the Admissions recruitment Oracle Forms modules, where the standard table handler pattern is generated automatically. Because it is a server-side API, custom PL/SQL extensions and concurrent programs may call the procedures directly to insert, update or delete probability index data, provided they supply the correct identifiers. Two other packages in the ETRM inventory reference IGS_AD_RECRUIT_PI_PKG, indicating it acts as a dependency for higher-level recruitment processing logic. Developers should invoke GET_FK_IGS_AD_CODE_CLASSES before assigning probability type or source codes, and should rely on BEFORE_DML to enforce base-table integrity automatically.