Search Results igs_ps_unit_ofr_pat_pkg




Overview
Explore in AI Chat

Overview

IGS_PS_UNIT_OFR_PAT_PKG is a PL/SQL package in the APPS schema belonging to the Oracle Student System (also known as Oracle Higher Education or the Student Information Management System family of products) shipped with Oracle E-Business Suite 12.1.1 and 12.2.2. The package encapsulates the table-handling logic for the IGS_PS_UNIT_OFR_PAT_ALL entity, which stores unit offering pattern records. Unit offering patterns define the templates that control how units (courses) are offered to students within a particular academic period, including the offering pattern structure attached to a program or unit offering option.

The package is classified as an OTHER API within the ETRM repository rather than a formal public API. It functions as a generated or maintained table handler that provides standardized insert, update, delete, lock, and constraint-validation operations against the underlying unit offering pattern table. It is a foundational dependency for numerous other Student System packages, and the ETRM metadata confirms that it is referenced by sixteen distinct packages, underscoring its central role in unit offering configuration processing.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new unit offering pattern record into the base table, populating the primary key and standard WHO audit columns.
  • UPDATE_ROW — Updates an existing unit offering pattern record, modifying the mutable business attributes while preserving the primary key.
  • ADD_ROW — Adds a row using the schema-defined defaulting and validation logic, typically invoked before an INSERT to apply column defaults.
  • DELETE_ROW — Removes a unit offering pattern record from the base table.
  • LOCK_ROW — Issues a SELECT FOR UPDATE against the target row to serialize concurrent access by multiple sessions.
  • GET_PK_FOR_VALIDATION — Derives or validates the primary key value for the row, supporting referential integrity checks.
  • GET_UFK_IGS_CA_INST — Returns the unique foreign key value referencing the IGS_CA_INST (calendar instance / teaching period) parent record.
  • GET_FK_IGS_PS_UNIT_OFR — Returns the foreign key value referencing the parent unit offering record in IGS_PS_UNIT_OFR.
  • CHECK_CONSTRAINTS — Performs application-level validation of business constraints on the row prior to committing changes.
  • BEFORE_DML — A pre-DML trigger helper that executes standard housekeeping and validation logic before INSERT, UPDATE, or DELETE operations.

Tables Accessed

The package operates against a single documented base table, IGS_PS_UNIT_OFR_PAT_ALL, accessed through its APPS synonym. This table holds the unit offering pattern records that link a unit offering to a calendar instance and associated pattern attributes. Because the table is an _ALL table with an associated _TL translation table in the standard EBS multi-language pattern, the package is the controlled DML entry point that enforces consistency between the base entity and its foreign key relationships to IGS_CA_INST and IGS_PS_UNIT_OFR.

Usage Notes

IGS_PS_UNIT_OFR_PAT_PKG is not a formal published API and should not be called directly by customer customizations where a supported alternative exists; Oracle retains the right to change its signature between releases. Within the product it is invoked by a wide set of Student System packages, including IGS_PS_UNIT_OFR_PKG, IGS_PS_UNIT_OFR_OPT_PKG, IGS_PS_UNT_OFR_PAT_N_PKG, IGS_PS_RSV_UOP_PRI_PKG, IGS_PS_UOFR_WLST_PRI_PKG, IGS_PS_UNIT_LGCY_PKG, IGS_AS_UNTAS_PATTERN_PKG, IGS_AD_PS_APLINSTUNT_PKG, IGS_CA_INST_PKG, IGS_PS_USEC_SCHEDULE, IGS_PS_PURGE_DEL_RECORD, and the concurrent-program driver packages IGS_PS_GEN_006 and IGS_PS_GEN_008. These callers use the package during unit offering setup, pattern generation, enrollment-related processing, and purge operations. Custom integrations should instead target the supported unit offering APIs, reserving this package for diagnostic queries against the ETRM dependency map.