Search Results igs_uc_com_ebl_subj_pkg




Overview
Explore in AI Chat

Overview

The package APPS.IGS_UC_COM_EBL_SUBJ_PKG is a component of the Oracle E-Business Suite (EBS) Student System / Higher Education module, specifically within the UK-specific UC (Universities and Colleges Admissions Service, or "UCAS") subsystem whose objects carry the IGS_UC_ prefix. Its name, combining the tokens COM (common), EBL (Awarding Body / Examining Body link), and SUBJ (subject), indicates that it manages the association between common subject records and awarding bodies. The package carries an API classification of OTHER in the ETRM metadata, meaning it is not a public, supported business API but an internal data-management layer used by the UCAS applications/results flow.

In business terms, UCAS application data arriving into EBS must resolve the subjects named by applicants and institutions onto the institution's internal subject definitions and the awarding bodies that certify them. This package provides the low-level, row-oriented operations that create, validate, and maintain entries in the underlying IGS_UC_COM_EBL_SUBJ intersection table. The ETRM record lists the object as VALID at both 12.1.1 and 12.2.2, confirming continued support across the two release lines.

Key Procedures and Functions

Eight documented procedures compose the package. They follow the standard Oracle Forms-generated table-handler pattern, which explains both their naming and their behaviour:

  • INSERT_ROW — Inserts a new row into the underlying table, typically invoked during programmatic creation of a subject/awarding-body association.
  • LOCK_ROW — Acquires a row-level lock on an existing record, used to serialize concurrent access before an update or delete.
  • UPDATE_ROW — Applies changes to an existing row, refreshing the association's attributes.
  • ADD_ROW — Adds a row in the context of a form block, including default population logic that complements a plain insert.
  • DELETE_ROW — Removes a subject/awarding-body association record.
  • GET_PK_FOR_VALIDATION — Resolves and returns the primary-key value used to validate a row before DML, supporting form-level validation logic.
  • GET_FK_IGS_UC_REF_AWRDBDY — Retrieves the foreign-key reference to the awarding body entity (IGS_UC_REF_AWRDBDY), enforcing referential integrity between the subject record and its awarding body.
  • BEFORE_DML — A pre-DML trigger routine that fires before insert, update, or delete operations to apply standard auditing and column-population rules.

No public parameter lists are exposed in the documented metadata; parameter signature details should be obtained from the deployed package source.

Tables Accessed

The package operates on a single documented table, IGS_UC_COM_EBL_SUBJ, accessed through an APPS synonym. This is the intersection (cross-reference) table holding common subject data linked to awarding bodies. The insert, update, add, and delete procedures all write to this table, while LOCK_ROW, GET_PK_FOR_VALIDATION, and GET_FK_IGS_UC_REF_AWRDBDY read from it to support validation and locking. No other base tables are documented, though the foreign-key lookup implies a logical relationship to the awarding-body entity.

Usage Notes

Because the package is classified as OTHER and follows the Forms table-handler idiom, it is most commonly invoked indirectly from Oracle Forms or from server-side PL/SQL packages in the UCAS applications and results pipeline rather than being called directly by end users. The ETRM dependency list confirms that IGS_UC_APP_RESULTS_PKG, IGS_UC_PROC_COM_INST_DATA, and IGS_UC_REF_AWRDBDY_PKG all reference it, and it is also self-referential. These callers process incoming UCAS application and results data, converting awarding-body and subject information into internal records. Customisations should avoid direct DML on IGS_UC_COM_EBL_SUBJ and instead invoke these procedures so that BEFORE_DML validation and auditing remain consistent. Availability is uniform across EBS 12.1.1 and 12.2.2.