Search Results igs_ad_tac_ad_cd_pkg

Overview

IGS_AD_TAC_AD_CD_PKG is an Oracle EBS Applications (APPS) PL/SQL package that belongs to the Student Systems / Admissions (IGS) product family. Its naming convention — IGS_AD_ (Admissions), TAC (test/assessment component context), AD_CD (admission code) — indicates that it encapsulates the data-maintenance logic for the IGS_AD_TAC_AD_CD entity, a table holding admissions codes associated with test or assessment components. The package is classified as an "OTHER" API in the ETRM repository, meaning it is an internal, DML-oriented package rather than a published, declarative public API. It provides the standard programmatic entry points used to insert, update, delete, lock, and validate rows in the underlying entity, and is validated (Status: VALID) in the APPS schema. In the context of Oracle EBS 12.1.1 and 12.2.2, such packages form the persistence layer beneath the Admissions forms and concurrent processes, ensuring that all row-level changes to IGS_AD_TAC_AD_CD pass through a single controlled code path.

Key Procedures and Functions

The package exposes eight documented procedures that together implement a conventional table-handler pattern:

• INSERT_ROW — Inserts a new row into the entity, applying defaulting and column population logic.
• LOCK_ROW — Acquires a row-level lock on an existing record to guard against concurrent modification; typically called before an update.
• UPDATE_ROW — Modifies an existing row, generally in conjunction with LOCK_ROW.
• ADD_ROW — A convenience wrapper that combines validation and insertion for a new record.
• DELETE_ROW — Removes an existing record from the entity.
• GET_PK_FOR_VALIDATION — Returns the primary key of a row for use in validation checks, allowing callers to verify existence and uniqueness without a full query.
• CHECK_CONSTRAINTS — Enforces the business and referential constraints associated with the entity before DML is committed.
• BEFORE_DML — Performs pre-DML processing such as WHO-column defaulting (created_by, creation_date, last_updated_by, last_update_date) and attribute derivation.

The metadata does not document parameter lists, so callers should reference the package specification in the database for exact signatures.

Tables Accessed

The package accesses a single documented table, IGS_AD_TAC_AD_CD, through an APPS synonym. This table stores the admission codes tied to test/assessment components and is the sole persistence target of the DML procedures above. Reads occur during validation (GET_PK_FOR_VALIDATION, CHECK_CONSTRAINTS), while INSERT_ROW, ADD_ROW, UPDATE_ROW, and DELETE_ROW perform the corresponding writes. LOCK_ROW provides concurrency control on the same table.

Usage Notes

IGS_AD_TAC_AD_CD_PKG is referenced by one other package, IGS_AD_CD_PKG, which acts as a higher-level consumer — most likely orchestrating admissions-code processing and delegating row maintenance for the test/assessment component mapping to this package. The package is normally invoked indirectly from Admissions forms, concurrent programs, or custom extensions that must adhere to the same validation and WHO-audit rules. Because it is an internal DML handler rather than a published API, direct custom calls should be undertaken cautiously and only where no supported API exists; the recommended approach is to let IGS_AD_CD_PKG or the standard Admissions UI drive the operations. Any custom code should preserve the LOCK_ROW-then-UPDATE_ROW sequence and rely on CHECK_CONSTRAINTS to protect data integrity. The package is valid on both 12.1.1 and 12.2.2, with no known differences in its documented interface across those releases.