Results for “igs_ps_fld_of_study_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.IGS_PS_FLD_OF_STUDY_PKG package is a core PL/SQL component of the Oracle E-Business Suite (EBS) Student System (formerly Oracle Student System, delivered in 12.1.1 and carried forward into 12.2.2). It encapsulates the business logic governing the maintenance of Fields of Study — the academic subject areas and disciplines that institutions attach to programs, program offerings, and student records. Fields of study are foundational institutional reference data: they drive curriculum mapping, student academic interest tracking, term education records, and statutory returns such as HESA reporting in the UK higher-education localization.

Because the package resides in the APPS schema and is classified as an OTHER API (rather than a fully documented public API), it functions primarily as a table-handler or low-level data access layer rather than a declarative business service. The eight documented units of the package implement insert, update, locking, primary-key validation, foreign-key lookup, and constraint-checking behavior consistent with the Oracle Forms–generated table-handler pattern. The package is marked VALID in 12.1.1 and remains the dependency anchor for nine downstream packages, indicating that it is a stable, widely consumed element of the IGS (Oracle Student System) module.

Key Procedures and Functions

• INSERT_ROW — Performs the physical insert of a new field-of-study row into the base table, populating all mandatory and audit columns.
• LOCK_ROW — Acquires a row-level lock on the target field-of-study record to guarantee serialized concurrent updates.
• UPDATE_ROW — Applies modifications to an existing field-of-study row, honoring the row lock established by LOCK_ROW.
• ADD_ROW — Provides the higher-level wrapper used by calling forms to add a record, orchestrating validation and the insert path.
• GET_PK_FOR_VALIDATION — Returns the primary key needed to validate a field-of-study reference, supporting foreign-key integrity checks from dependent packages.
• GET_FK_IGS_RE_GV_FLD_OF_SDY — Resolves the foreign key to the related graduated field-of-study entity, used when linking field-of-study data to award or graduation structures.
• CHECK_CONSTRAINTS — Enforces business and referential constraints before a DML operation commits.
• BEFORE_DML — A pre-DML trigger-style procedure that standardizes audit stamping and defaulting logic ahead of insert or update.

Tables Accessed

The package references three objects via APPS synonyms. IGS_PS_FLD_OF_STUDY_ALL is the primary base table holding field-of-study definitions in a multi-org (ALL) structure. IGS_PS_FLD_STDY_HIST_ALL stores the historical audit trail of changes to field-of-study records. DUAL is used for PL/SQL expression evaluation and single-value lookups rather than business data.

Usage Notes

The package is invoked almost exclusively from the Field of Study maintenance forms and from peer APIs within the Student System. Its documented callers include IGS_PS_FIELD_STUDY_PKG, IGS_PS_FLD_STD_HIST_PKG, IGS_AD_ACAD_INTEREST_PKG, IGS_AD_TER_EDU_PKG, and the regulatory reporting packages IGS_RE_CDT_FLD_OF_SY_PKG, IGS_RE_GV_FLD_OF_SDY_PKG, and IGS_UC_QUAL_DETS_PKG, as well as IGS_HE_SPA_LGCY_PUB and IGS_PS_FACLTY_DISP_PKG. Customizations should prefer the documented public packages over direct calls to this handler, and any direct use must account for the BEFORE_DML and constraint-checking conventions to avoid invalidating the audit history. As an OTHER-classified API, it is not a supported integration point for external systems.