Search Results igs_ad_os_sec_edu_qf_pkg




Overview
Explore in AI Chat

Overview

IGS_AD_OS_SEC_EDU_QF_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and classified under the ETRM as an OTHER API. It belongs to the Student Systems / Admissions (IGS) product family and supports the secondary education qualification data model used by admissions processing. The package encapsulates the data manipulation logic for the IGS_AD_OS_SEC_EDU_QF entity, which stores qualification records associated with an applicant's secondary education history supplied through the online admissions self-service (OS) flows. Its status is VALID in both EBS 12.1.1 and 12.2.2, and in the ETRM metadata it is documented as an OTHER API with nine procedures and functions. The package provides a controlled, reusable layer between the admissions forms and self-service pages and the underlying qualification table, ensuring that inserts, updates, deletes and validation checks follow consistent business rules rather than embedding direct DML in the calling forms.

Key Procedures and Functions

The documented interface comprises nine procedures and functions:

  • INSERT_ROW — Performs the initial insert of a new secondary education qualification record into the underlying table.
  • LOCK_ROW — Acquires a row-level lock on an existing qualification record, typically before an update or delete to prevent concurrent modification.
  • UPDATE_ROW — Applies changes to an existing qualification record.
  • ADD_ROW — Adds a qualification row, providing the higher-level entry point used by the calling forms or APIs when creating new data.
  • DELETE_ROW — Removes an existing qualification record.
  • GET_PK_FOR_VALIDATION — Returns the primary key value used to validate that a record exists and is uniquely identifiable.
  • GET_FK_IGS_PE_COUNTRY_CD — Retrieves the foreign key reference to the country code entity, supporting validation against the person/country code package.
  • CHECK_CONSTRAINTS — Enforces the package's referential and business constraints, verifying that mandatory relationships and valid values are present before DML proceeds.
  • BEFORE_DML — A pre-DML hook that prepares default values, derives keys, and performs last-minute validation ahead of an insert, update or delete.

No parameter lists are documented in the ETRM metadata; the procedures are described by role only.

Tables Accessed

The package operates on a single documented table, IGS_AD_OS_SEC_EDU_QF, accessed through an APPS synonym. This table is the secondary education qualification entity within the admissions online self-service model. INSERT_ROW and ADD_ROW write new qualification rows; UPDATE_ROW and LOCK_ROW modify or protect existing rows; DELETE_ROW removes them; GET_PK_FOR_VALIDATION reads the primary key; and GET_FK_IGS_PE_COUNTRY_CD reads the foreign key that links the qualification to the country code held in the IGS_PE_COUNTRY_CD_PKG domain. CHECK_CONSTRAINTS and BEFORE_DML read and validate against the same table without directly persisting business data of their own.

Usage Notes

IGS_AD_OS_SEC_EDU_QF_PKG is referenced by two packages: IGS_AD_OS_SEC_EDU_PKG, the parent secondary-education package, and IGS_PE_COUNTRY_CD_PKG, which relies on the foreign-key accessor for country code validation. It in turn depends on SYS.STANDARD for standard PL/SQL behaviour. The package is typically invoked indirectly rather than called by end users: admissions online self-service pages and related forms or concurrent processes call the parent IGS_AD_OS_SEC_EDU_PKG, which delegates DML and validation to this qualification-level package. In EBS 12.1.1 and 12.2.2 it therefore functions as a supporting API layer, and customisations should call the documented procedures rather than issuing direct DML against IGS_AD_OS_SEC_EDU_QF, so that the constraint checks and BEFORE_DML logic are preserved.