Search Results igs_ad_perd_ad_cat_pkg




Overview
Explore in AI Chat

Overview

The package body APPS.IGS_AD_PERD_AD_CAT_PKG is a database-side PL/SQL module belonging to the Oracle E-Business Suite Advanced Degree (formerly OSS/Student Systems) product family. It supports maintenance of the IGS_AD_PERD_AD_CAT entity, an intersection table that associates a program admission calendar instance with an admission category for a given admission period. In the Oracle EBS 12.1.1 and 12.2.2 application schema, this package encapsulates the DML, locking, validation, and referential integrity logic required to keep that relationship coherent.

The package is classified as an OTHER API under the ETRM register, meaning it is not one of the formally published public APIs, but is nonetheless a maintained object with a stable procedural interface. It owns ten documented procedures and is referenced by five other packages in the same product layer, indicating that it functions as a shared low-level DML utility rather than an end-user entry point.

Key Procedures and Functions

  • INSERT_ROW — Creates a new row in the underlying table with the supplied column values.
  • ADD_ROW — Higher-level creation routine that performs the insert together with any associated defaulting or pre-processing required before the record is stored.
  • UPDATE_ROW — Applies modifications to an existing admission period / admission category record.
  • DELETE_ROW — Removes a record from the entity, subject to the internal validation rules enforced by the package.
  • LOCK_ROW — Obtains a row-level lock on the target record, protecting it against concurrent modification during a multi-step transaction.
  • BEFORE_DML — Pre-DML hook invoked to normalise values, derive audit columns such as creation/update user and date, and raise errors through FND_MESSAGE/APP_EXCEPTION when mandatory attributes are invalid.
  • CHECK_CONSTRAINTS — Enforces business-level integrity rules that are not expressed as database constraints.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key context needed before validation activities are executed against the record.
  • GET_FK_IGS_AD_CAT — Returns the foreign key value that links the record to the admission category definition.
  • GET_UFK_IGS_CA_INST — Returns the alternate (unique) foreign key value that ties the record to the admission calendar instance.

Function-getters such as the two FK routines are typically used by dependent packages and by the interface layer to resolve relationship identifiers without direct table access. No parameter signatures are reproduced here; ETRM documents the procedures by name and purpose only.

Tables Accessed

The only table recorded in the metadata is IGS_AD_PERD_AD_CAT, accessed through its APPS synonym. This is the package's base entity: the package inserts, updates, deletes, and locks rows in it and reads it to resolve primary and foreign key values. All access is performed as the APPS schema owner, so it is subject to the standard APPS-level privileges and to the row-level security implied by the product's operating units.

Usage Notes

This package is normally invoked indirectly rather than by end users. Oracle Forms built on the Advanced Degree admission period and admission category blocks call into it during save, delete, and navigation-triggered locking. Concurrent programs and batch loaders that stage admissions setup data may also call the package. The dependency list confirms it is called by IGS_AD_CAT_PKG, IGS_AD_PECRS_OFOP_DT_PKG, and IGS_AD_PRD_AD_PRC_CA_PKG, which delegate their own row maintenance to it. Custom extensions should follow the same pattern: use the supplied procedures rather than issuing raw DML, so that validation, locking, and exception handling via APP_EXCEPTION, FND_MESSAGE, and IGS_GE_MSG_STACK remain consistent. Because the package is not formally published, custom callers should retest against any 12.2.2 upgrade, since internal signatures may change between releases.