Search Results igs_ps_of_opt_ad_cat_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_PS_OF_OPT_AD_CAT_PKG package is a database-tier PL/SQL component within the Oracle E-Business Suite (EBS) Higher Education / Student System (IGS) product family. It manages the association between program offering options (IGS_PS_OFR_OPT) and admissions categories (IGS_AD_CAT) housed in the intersection table IGS_PS_OF_OPT_AD_CAT. In effect, this package controls the mapping that determines which admissions categories apply to a particular program offering option — a relationship critical to recruitment, application processing, and admissions routing within institutions that run the Oracle Student System.

According to the ETRM metadata (validated against 12.1.1 and applicable to 12.2.2), the package resides in the APPS schema and has a status of VALID. It is classified as an "OTHER" API rather than a public or private API, indicating it is primarily an internal supporting package rather than a formally published integration interface.

Key Procedures and Functions

The package exposes eleven documented procedures and functions, grouped by purpose:

  • INSERT_ROW — Inserts a new admissions category association record into the underlying table.
  • ADD_ROW — Adds a row, typically providing a higher-level wrapper that prepares default values before insertion.
  • UPDATE_ROW — Modifies an existing association record.
  • DELETE_ROW — Removes an association record.
  • LOCK_ROW — Acquires a row-level lock to prevent concurrent modification during transactional processing.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key value used in validation logic.
  • GET_FK_IGS_AD_CAT — Returns the foreign key value referencing the admissions category entity.
  • GET_FK_IGS_PS_OFR_OPT — Returns the foreign key value referencing the program offering option.
  • GET_UFK_IGS_PS_OFR_OPT — Returns the unique (alternate) foreign key pointing to the program offering option.
  • CHECK_CONSTRAINTS — Validates business and referential integrity constraints prior to DML.
  • BEFORE_DML — A pre-DML trigger routine performing standard housekeeping (such as WHO-column population) and invoking validation.

Tables Accessed

The package operates primarily against the IGS_PS_OF_OPT_AD_CAT table (accessed via an APPS synonym). This intersection table stores the admissions category assignments tied to specific program offering options. All insert, update, delete, lock, and constraint-checking operations target this table. The foreign-key accessors (GET_FK_IGS_AD_CAT, GET_FK_IGS_PS_OFR_OPT, GET_UFK_IGS_PS_OFR_OPT) expose the surrogate and alternate keys that relate this table to IGS_AD_CAT and IGS_PS_OFR_OPT. Dependencies on SYS.STANDARD reflect only standard PL/SQL runtime features.

Usage Notes

This package is referenced by four other packages — IGS_AD_CAT_PKG, IGS_PS_COO_AD_UNIT_S_PKG, IGS_PS_GEN_001, and IGS_PS_OFR_OPT_PKG — which indicates it functions as a low-level utility invoked by higher-level admissions and program offering logic. Typical invocation arises during maintenance of program offering option definitions in the Oracle Student System forms, when admissions categories are attached or detached, and during concurrent or batch validation runs. Because it is classified as an "OTHER" API, direct calls from custom code are possible but should be exercised cautiously; the documented procedures do not publish parameter lists in the available metadata, so implementers should inspect the package specification in the database before calling it directly. Instance-specific behavior can vary based on setup data and any customer extensions layered over the standard IGS schema.