Search Results igs_uc_applicants_pkg




Overview
Explore in AI Chat

Overview

IGS_UC_APPLICANTS_PKG is a PL/SQL package in the APPS schema that supports the Oracle E-Business Suite application processing model for UCAS (Universities and Colleges Admissions Service) applicant data. It sits at the centre of the UCAS integration component of the Student Systems (IGS) product family. Its principal business role is to provide the transactional data-access layer for the IGS_UC_APPLICANTS entity — the master record of an individual applicant received from or transmitted to UCAS. The package encapsulates the insert, update, delete, locking and DML-preparation logic required to keep the applicant record consistent with the entity's keys and foreign key relationships, allowing higher-level UCAS processes to manipulate applicant data without embedding SQL directly. It is classified as an OTHER API rather than a public business API, indicating that it is intended for internal use by other UCAS packages and concurrent programs rather than for external customer extension. Its status is VALID, confirming it is compiled and active.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new applicant row into IGS_UC_APPLICANTS and its key-preserving structures, applying the standard WHO columns and validation.
  • LOCK_ROW — Selects the target applicant row FOR UPDATE to serialize concurrent modification before an update or delete.
  • UPDATE_ROW — Applies changes to an existing applicant record.
  • ADD_ROW — Convenience entry point that performs the insert workflow for a new applicant.
  • DELETE_ROW — Removes an applicant record, including any dependent child data handled by the package.
  • GET_PK_FOR_VALIDATION — Returns the primary key value used to validate the applicant entity within the data model.
  • GET_UK_FOR_VALIDATION — Returns the unique key value used for uniqueness validation.
  • GET_FK_IGS_UC_DEFAULTS — Derives/resolves the foreign key reference to the IGS_UC_DEFAULTS parent, used for default-attribute inheritance.
  • GET_FK_IGS_PE_PERSON — Derives/resolves the foreign key reference to the IGS_PE_PERSON party record associated with the applicant.
  • BEFORE_DML — Central pre-DML hook that enforces attribute-level defaults and validation before the row is written.

Tables Accessed

The package operates on the table IGS_UC_APPLICANTS through the APPS synonym, which stores the core UCAS applicant records. It also accesses IGS_UC_APPLICANTS_S1, the sequence/selector object associated with the applicant entity that supplies the surrogate primary key during insert operations. DUAL is referenced for single-row evaluations used in key resolution and validation logic. Referencing the applicant table and its selector ensures that generated keys and foreign keys to IGS_UC_DEFAULTS and IGS_PE_PERSON remain consistent with the rest of the UCAS and person model.

Usage Notes

This package is not intended for direct invocation by end users. The ETRM dependency record shows it is referenced by twelve other APPS objects, including IGS_UC_APP_ADDRESES_PKG, IGS_UC_APP_CHOICES_PKG, IGS_UC_APP_CLEARING_PKG, IGS_UC_APP_NAMES_PKG, IGS_UC_APP_REFEREES_PKG, IGS_UC_APP_RESULTS_PKG, IGS_UC_APP_STATS_PKG, IGS_UC_DAT_IMP_FROM_UCAS, IGS_UC_EXPUNGE_APP, IGS_UC_EXP_APPLICANT_DTLS, IGS_UC_FORM_QUALS_PKG and IGS_UC_PROC_APPLICATION_DATA. It is therefore called in the course of UCAS data import, applicant cleansing/expunge processing, and application-data processing concurrent programs, as well as by the related UCAS child-entity packages. Customisations should call the parent UCAS processing routines rather than this package directly, so that locking, key generation and validation remain consistent. Because the metadata exposes no parameter lists, exact signatures must be confirmed from the package specification in the database.