Search Results igs_ad_basis_for_ad_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_AD_BASIS_FOR_AD_PKG package is a PL/SQL database object owned by the APPS schema in Oracle E-Business Suite. Its status is documented as VALID in the ETRM metadata for release 12.1.1, and it is classified as an "OTHER" API type. The package supports the Oracle Student System (formerly iLearning / Student Administration) admissions module by managing the relationship between admissions applications and the admission basis for admission (a reference dataset associated with how an applicant qualifies for admission). In practice, this is a table maintenance or supporting utility package rather than a high-level business service API; it provides the underlying row-level DML logic for its base table and is consumed by other admissions packages. It is referenced by three packages: IGS_AD_CD_PKG, IGS_AD_GOV_BAS_FR_TY_PKG, and IGS_AD_PS_APPL_PKG, plus its own internal references. It depends only on SYS-level objects such as STANDARD in the documented dependency set.

Key Procedures and Functions

The metadata documents nine procedures and functions. Their purposes are as follows:

  • INSERT_ROW — Inserts a new record into the base table that stores admission-basis-for-admission data.
  • LOCK_ROW — Acquires a row-level lock on an existing record, typically used to serialize concurrent updates before modification.
  • UPDATE_ROW — Modifies an existing record in the base table.
  • ADD_ROW — Provides an alternate entry point for adding a record, generally wrapping insert logic or handling defaults and validation.
  • DELETE_ROW — Removes a record from the base table.
  • GET_PK_FOR_VALIDATION — Returns the primary key value used to validate a row, supporting lookup and referential integrity checks.
  • CHECK_CONSTRAINTS — Validates business or data constraints on a row before it is committed.
  • GET_FK_IGS_AD_GOV_BAS_FR_TY — Resolves the foreign key to the IGS_AD_GOV_BAS_FR_TY entity, likely a government basis-for-admission-type reference.
  • BEFORE_DML — A trigger-style routine executed before DML operations to enforce standard validation and bookkeeping logic.

No parameter lists are documented in the ETRM metadata, and parameter details should be confirmed against the deployed package specification in the target environment.

Tables Accessed

The only documented base table is IGS_AD_BASIS_FOR_AD, accessed through the APPS synonym. This package serves as the DML layer for that table: INSERT_ROW, ADD_ROW, UPDATE_ROW, and DELETE_ROW perform the create, update, and delete operations, while LOCK_ROW, CHECK_CONSTRAINTS, BEFORE_DML, and GET_PK_FOR_VALIDATION provide locking and validation around those operations. GET_FK_IGS_AD_GOV_BAS_FR_TY indicates a reference relationship to the government basis-for-admission-type entity, though no additional tables are listed in the documented dependency set.

Usage Notes

This package is not typically invoked directly by end users. It is called programmatically by the three dependent APPS packages and, by extension, from Oracle Forms-based admissions maintenance screens, OAF pages, or concurrent programs that perform maintenance of admissions basis-for-admission records. Custom code should preferably call the higher-level packages that already wrap this one rather than invoking IGS_AD_BASIS_FOR_AD_PKG procedures directly, to preserve validation sequencing and locking behavior. Any custom invocation should honor the BEFORE_DML and CHECK_CONSTRAINTS validation flow and should not bypass LOCK_ROW when updating shared rows. Because the documented metadata is limited to object names and dependency relationships, parameter signatures and error codes must be verified against the package specification in the specific EBS 12.1.1 or 12.2.2 instance before use.