Search Results igs_ad_spl_talents_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_AD_SPL_TALENTS_PKG package body is a component of the Oracle E-Business Suite (EBS) Student Systems / Oracle Student Recruiting (formerly Oracle iRecruitment for higher education) module, specifically within the Admissions (IGS_AD) application family. This package provides the application programming interface (API) layer for the IGS_AD_SPL_TALENTS entity, which stores special talents or skills associated with an applicant's admission record. Such talents form part of the supplemental applicant data used by admissions offices to evaluate candidates beyond standard academic criteria.

The package is classified as an OTHER API type in the ETRM metadata and resides in the APPS schema, with a VALID status. It encapsulates the data manipulation logic required to insert, update, delete, lock, and validate records within the underlying base table and its associated translated (_S) table. It also enforces foreign key integrity against related admissions entities. Eleven documented procedures and functions make up the package's public and internal interface.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new talent record into the base table, populating the primary key and audit columns.
  • UPDATE_ROW — Updates an existing talent record with modified attribute values.
  • ADD_ROW — Higher-level wrapper that performs an insert after validating the record; typically used by forms and custom code instead of INSERT_ROW directly.
  • DELETE_ROW — Removes a talent record from the base table.
  • LOCK_ROW — Acquires a row-level lock on a talent record to prevent concurrent modification during an update transaction.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key value used during validation processing.
  • GET_UK_FOR_VALIDATION — Retrieves the unique key value used to verify uniqueness of a talent record.
  • GET_FK_IGS_AD_CODE_CLASSES — Resolves the foreign key reference to the code classes entity, ensuring the talent is linked to a valid classification.
  • GET_FK_IGS_AD_APPL — Resolves the foreign key reference to the admissions application (IGS_AD_APPL), binding the talent to a specific applicant's application.
  • CHECK_CONSTRAINTS — Validates all database constraints (mandatory columns, foreign keys, uniqueness) before DML is committed.
  • BEFORE_DML — Standard pre-DML hook that populates audit columns and executes validation logic ahead of insert, update, or delete operations.

Tables Accessed

The package operates against two documented tables via APPS synonyms:

  • IGS_AD_SPL_TALENTS — The primary base table holding special talent records for admission applicants. This is the principal target of INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW, and ADD_ROW.
  • IGS_AD_SPL_TALENTS_S — The translated (multilingual) shadow table that stores language-specific descriptions or attributes. The package maintains referential consistency between the _S table and the base table during insert and update operations.

Dependency metadata further indicates references to IGS_AD_APPL_PKG (for applicant lookup), IGS_AD_CODE_CLASSES_PKG (for code class validation), and the sequence IGS_AD_SPL_TALENTS_S for surrogate key generation.

Usage Notes

The package is documented as being referenced by six other database objects, reflecting its role as a foundational API within the IGS_AD module. It is typically invoked from Oracle Forms-based admissions maintenance screens when users add, modify, or remove special talent entries for an application. Concurrent programs that import or validate applicant data may also call it programmatically. Because the standard Oracle EBS API conventions are followed — LOCK_ROW, BEFORE_DML, CHECK_CONSTRAINTS, and paired PK/UK validation functions — custom developers should invoke ADD_ROW or the individual DML procedures rather than issuing direct SQL against the underlying tables. Infrastructure dependencies include FND_GLOBAL, FND_MESSAGE, IGS_GE_MSG_STACK, and APP_EXCEPTION, which provide audit context, message resolution, and error handling across both EBS 12.1.1 and 12.2.2 releases.