Search Results igs_ps_pat_of_study_pkg




Overview
Explore in AI Chat

Overview

IGS_PS_PAT_OF_STUDY_PKG is an Oracle EBS Student System (IGS) package body owned by the APPS schema. It encapsulates the core data manipulation logic for the IGS_PS_PAT_OF_STUDY entity, which stores the pattern of study records — the structured definition of how a program offering is delivered across study periods, attendance modes, attendance types, and locations. The package is classified as OTHER under the ETRM API classification scheme, identifying it as a table-handler package rather than a public business API. Its documented status is VALID in both EBS 12.1.1 and 12.2.2, and it is referenced by nine other database objects, confirming it as a shared dependency within the Student System module. The body depends on a broad set of validation and lookup packages, including IGS_PS_VAL_POS, IGS_PS_VAL_CRS, IGS_PS_VAL_UOO, IGS_AS_VAL_UAI, and IGS_AD_VAL_APCOO, indicating that it performs extensive cross-entity validation before persisting pattern-of-study data.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new row into the IGS_PS_PAT_OF_STUDY table, applying mandatory column defaults and validation.
  • LOCK_ROW — Acquires a row-level lock for a specified pattern-of-study record, typically used to serialize concurrent updates.
  • UPDATE_ROW — Updates an existing row following successful locking and validation.
  • ADD_ROW — Convenience wrapper that locks, validates, and inserts a row in a single call.
  • DELETE_ROW — Removes a pattern-of-study record, subject to referential integrity constraints.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key for validation purposes, supporting the check-constraint discipline used by the IGS table-handler pattern.
  • GET_FK_IGS_AD_CAT — Resolves or validates the foreign key to the attendance category entity.
  • GET_FK_IGS_EN_ATD_MODE — Resolves the attendance mode foreign key reference.
  • GET_FK_IGS_EN_ATD_TYPE — Resolves the attendance type foreign key reference.
  • GET_FK_IGS_CA_TYPE — Resolves the calendar type foreign key reference.
  • GET_FK_IGS_CA_INST — Resolves the calendar instance foreign key reference.
  • GET_FK_IGS_PS_OFR — Resolves the program offering foreign key reference, linking the pattern of study to its parent offering.
  • GET_FK_IGS_AD_LOCATION — Resolves the location foreign key reference.
  • CHECK_CONSTRAINTS — Executes the package's referential and business-rule validation, called before DML operations.
  • BEFORE_DML — Central pre-DML hook that drives constraint checking, foreign-key resolution, and audit column population prior to insert, update, or delete activity.

Tables Accessed

The package operates on a single documented table, IGS_PS_PAT_OF_STUDY, accessed through an APPS synonym. All insert, update, delete, and lock operations target this table. The foreign-key accessors listed above do not write to their respective parent tables; they validate and resolve identifiers used in the pattern-of-study record so that the row remains consistent with attendance, calendar, offering, and location definitions held elsewhere in the Student System.

Usage Notes

Because the package body is not referenced by any database object itself, it is invoked by form-level and concurrent-program logic within the Student System, typically through the pattern-of-study maintenance windows where users define or revise delivery patterns for a program offering. The supplied foreign-key accessors are commonly called by custom extensions, reports, and integration scripts that need resolved descriptions for attendance mode, attendance type, calendar instance, and location values associated with a pattern of study. The presence of BEFORE_DML and CHECK_CONSTRAINTS makes the package a reliable entry point for both Oracle Forms triggers and custom PL/SQL that must observe the same validation rules as the standard product, ensuring audit columns and cross-entity checks are applied consistently in 12.1.1 and 12.2.2 environments.