Search Results igs_ps_ofr_pkg




Overview
Explore in AI Chat

Overview

IGS_PS_OFR_PKG is a PL/SQL package in the APPS schema that encapsulates the core data manipulation logic for the IGS_PS_OFR_ALL entity, the base table storing Program Offering records within the Oracle E-Business Suite Student System (IGS) product family. A program offering represents a specific instance of an academic program offered by an institution for a defined attendance pattern, calendar, and location combination. The package follows the standard Oracle Forms-generated table handler pattern, exposing a discrete set of procedures for row insertion, locking, deletion, primary and foreign key resolution, constraint checking, and a consolidated BEFORE_DML entry point. It is documented as an OTHER-classified API in the ETRM repository, indicating that it is an internal infrastructure package rather than a public, versioned business API. Its principal role is to provide a single, consistent path for validating and persisting Program Offering data so that dependent packages and forms do not manipulate the underlying table directly.

Key Procedures and Functions

The package exposes eight documented procedures. INSERT_ROW creates a new Program Offering record in the base table. LOCK_ROW obtains a row-level lock on an existing offering, typically used to serialize concurrent modification. DELETE_ROW removes an offering record. GET_PK_FOR_VALIDATION resolves the primary key required for validation checks. GET_FK_IGS_CA_TYPE and GET_FK_IGS_PS_VER resolve foreign key values referencing the calendar type and program version entities respectively, ensuring referential integrity before DML is attempted. CHECK_CONSTRAINTS performs the column-level and cross-column validation rules defined for the offering entity. BEFORE_DML acts as the consolidated pre-DML trigger handler, orchestrating the appropriate validation and defaulting logic prior to insert, update, or delete operations. Together these procedures implement the standard table handler contract used throughout the IGS schema.

Tables Accessed

The only documented table referenced by this package, through APPS synonyms, is IGS_PS_OFR_ALL. All insert, update, lock, and delete operations are directed at this single table. The foreign key resolution routines imply read access to the calendar type and program version entities, but the ETRM metadata records IGS_PS_OFR_ALL as the sole documented table dependency. The package itself depends only on the SYS.STANDARD package at the PL/SQL level, confirming that it is a self-contained table handler whose external interactions occur through the IGS_PS_OFR_ALL synonym.

Usage Notes

IGS_PS_OFR_PKG is referenced by ten other packages, including IGS_PS_OFR_INST_PKG, IGS_PS_OFR_NOTE_PKG, IGS_PS_OFR_OPT_PKG, IGS_PS_OFR_UNIT_SET_PKG, IGS_PS_GEN_001, IGS_CA_TYPE_PKG, IGS_PS_VER_PKG, IGS_PS_PAT_OF_STUDY_PKG, IGS_AD_PECRS_OFOP_DT_PKG, and IGS_AD_PRD_PS_OF_OPT_PKG. This dependency pattern confirms that the package functions as the foundational persistence layer for the program offering entity, invoked by higher-level offering-related packages and by generated Forms code. It is not intended for direct invocation by end users or external custom code; clients should use the higher-level IGS APIs that internally call this package. The package is present and valid in both EBS 12.1.1 and 12.2.2, and its structure is unchanged between those releases.