Search Results igs_uc_app_choices_pkg




Overview
Explore in AI Chat

Overview

IGS_UC_APP_CHOICES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the UCAS (Universities and Colleges Admissions Service) integration within the Oracle Student System. Its primary business function is to manage application choice records — the individual course or institution selections that an applicant submits for admission consideration. Application choices are the transactional heart of the admissions cycle: each applicant may register multiple choices, each tied to a course detail and, where applicable, an offer condition. This package provides the canonical DML layer, validation support, locking, and referential integrity helpers that other UCAS-related packages rely upon when inserting, updating, or deleting choice data during the import, processing, and export of applications.

Key Procedures and Functions

ETRM documents eleven procedures and functions, classified as a generic "OTHER" API rather than a pure table-handler. Their purposes are as follows:

  • INSERT_ROW — Inserts a new application choice record into the base table.
  • UPDATE_ROW — Applies modifications to an existing choice row.
  • DELETE_ROW — Removes a choice record.
  • ADD_ROW — Provides the combined add path used by the UCAS processing flow, typically handling sequencing and validation before insert.
  • LOCK_ROW — Acquires a row-level lock on a choice record to serialize concurrent access.
  • GET_PK_FOR_VALIDATION — Returns the primary key value used to validate the base table row for a choice.
  • GET_UK_FOR_VALIDATION — Returns unique key values required for uniqueness validation.
  • GET_FK_IGS_UC_APPLICANTS — Retrieves the foreign key that links a choice to its parent applicant.
  • GET_FK_IGS_UC_CRSE_DETS — Retrieves the foreign key associating the choice with course detail data.
  • GET_FK_IGS_UC_OFFER_CONDS — Retrieves the foreign key that binds the choice to an offer condition, when one exists.
  • BEFORE_DML — Serves as a pre-DML hook that populates WHO columns and other derived attributes prior to insert or update.

Tables Accessed

The package reads and writes the following objects through APPS synonyms:

  • IGS_UC_APP_CHOICES — The primary application choice table, holding the substantive choice data.
  • IGS_UC_APP_CHOICES_S — The sequence-bearing shadow table used to generate and store the primary key.
  • IGS_UC_DEFAULTS — Supplies default values applied during row creation.
  • DUAL — Used for single-row queries, such as retrieving sequence values.

Usage Notes

IGS_UC_APP_CHOICES_PKG is not typically invoked directly by end users through a form. Instead, it is called programmatically by the UCAS application data processing and export components. ETRM confirms it is referenced by seven objects, including IGS_UC_APPLICANTS_PKG, IGS_UC_APP_CHO_CNDS_PKG, IGS_UC_OFFER_CONDS_PKG, IGS_UC_PROC_APPLICATION_DATA, IGS_UC_EXPORT_TO_OSS, IGS_UC_EXPORT_DECISION_REPLY, and IGS_UC_EXPUNGE_APP. These callers cover the full lifecycle: importing applicant data, processing applications, exporting decisions to the OSS, and expunging application records. Because the package records its status as VALID in APPS under both 12.1.1 and 12.2.2, it is safe to treat as an active, supported object. Customizations should call the documented procedures rather than writing directly to IGS_UC_APP_CHOICES, ensuring that validation, locking, and WHO-column maintenance remain consistent across the UCAS integration.