Search Results igs_ps_ofr_pat_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_PS_OFR_PAT_PKG package is a core component of the Oracle E-Business Suite Student System (formerly Oracle Student System / OSS), specifically belonging to the IGS (Integrated Graduate/Student) schema family that governs academic program and offering structures. The suffix OFR_PAT denotes "Offering Pattern," indicating that the package encapsulates the data-access and business rules layer for the IGS_PS_OFR_PAT entity — the definition of offering patterns applied to academic offerings within a program version.

The package is classified as an OTHER API within the ETRM (E-Business Suite Technical Reference Manual) metadata, meaning it is a table-handler style package rather than a standalone public business API. Its primary role is to provide controlled, transactional access to the underlying offering-pattern table while enforcing integrity through foreign-key lookups, unique-key validation, and record locking. Because offering patterns drive the scheduling and delivery of courses within a program, this package is instrumental in maintaining consistency between an offering and the patterns that describe how and when it is delivered.

Key Procedures and Functions

The ETRM documents 14 callable units. The principal data-maintenance procedures are as follows:

  • INSERT_ROW — Inserts a new offering-pattern record into the base table, applying default and validation logic.
  • ADD_ROW — An alternate/variant insertion routine used where the calling context supplies additional derived attributes.
  • UPDATE_ROW — Modifies an existing offering-pattern record, typically preceded by a lock.
  • DELETE_ROW — Removes an offering-pattern record.
  • LOCK_ROW — Acquires a row-level lock to serialize concurrent modifications and enforce optimistic concurrency.
  • BEFORE_DML — A pre-DML trigger-style procedure that performs validation and derived-column population prior to insert/update.
  • CHECK_CONSTRAINTS — Validates that all required foreign-key and uniqueness constraints are satisfied before committing.

Supporting lookup/validation functions return key values and validate referential integrity:

Tables Accessed

The only documented base table is IGS_PS_OFR_PAT, accessed through APPS synonyms. This table stores the offering-pattern rows themselves — the records describing delivery patterns associated with an offering. All INSERT, UPDATE, DELETE, LOCK, and validation operations target this table. Referential dependencies (offering instance, offering option, grading schema, person) are resolved through the foreign-key getter functions rather than direct table access, keeping the package focused on its owning entity.

Usage Notes

IGS_PS_OFR_PAT_PKG is referenced by six other packages, including IGS_AS_GRD_SCHEMA_PKG, IGS_PS_GEN_001, IGS_PS_GEN_003, IGS_PS_OFR_INST_PKG, IGS_PS_OFR_OPT_PKG, and IGS_PS_OFR_PAT_NOTE_PKG. This dependency chain indicates the package is invoked indirectly during offering setup, option configuration, and grading-schema association flows, most commonly through the Student System setup forms and their underlying gen-001/gen-003 generated code. Custom extensions should call the insert/update/delete procedures rather than issuing direct DML, and should invoke CHECK_CONSTRAINTS and BEFORE_DML in the documented order to preserve data integrity. It depends on SYS.STANDARD and is marked VALID in both 12.1.1 and 12.2.2.