Search Results igs_ps_ofr_opt_pkg




Overview
Explore in AI Chat

Overview

IGS_PS_OFR_OPT_PKG is a PL/SQL package in the APPS schema that forms part of the Oracle E-Business Suite Student Systems (IGS) product family. Its name follows the IGS naming convention: IGS identifies the Student System product, PS denotes the Programme/Program offering structures group, and OFR_OPT indicates the Offering Option entity. In EBS 12.1.1 and 12.2.2, the package serves as the table-handler / API layer for the IGS_PS_OFR_OPT_ALL table, which stores the option records (delivery, attendance, and related variants) that attach to a programme offering. The package encapsulates the standard insert, update, delete, locking, foreign-key lookup, and validation logic required to maintain that entity consistently, so that other IGS packages and forms do not manipulate the table directly. The ETRM record classifies the object as an OTHER API (rather than a public interface API), which indicates it is primarily an internal implementation package used by dependent IGS code. It contains 14 documented program units and is referenced by 15 other packages, confirming its role as a shared foundation object within the Student Systems schema.

Key Procedures and Functions

The package exposes a set of DML primitives and helper functions that follow the standard generated table-handler pattern:

  • INSERT_ROW — performs the core row insertion into the offering option table.
  • ADD_ROW — the higher-level add routine that prepares and inserts a new offering option row.
  • UPDATE_ROW — updates an existing offering option record.
  • DELETE_ROW — removes an offering option row.
  • LOCK_ROW — obtains a row lock to protect against concurrent modification during DML.
  • GET_PK_FOR_VALIDATION — returns the primary key value used for validation checks.
  • GET_UK_FOR_VALIDATION — returns the unique key value used for validation checks.
  • GET_FK_IGS_EN_ATD_MODE — resolves the foreign key to the attendance mode entity.
  • GET_FK_IGS_EN_ATD_TYPE — resolves the foreign key to the attendance type entity.
  • GET_FK_IGS_PS_OFR — resolves the foreign key to the parent programme offering.
  • GET_FK_IGS_AD_LOCATION — resolves the foreign key to the address/location entity.
  • GET_FK_IGS_PE_PERSON — resolves the foreign key to the person entity.
  • CHECK_CONSTRAINTS — enforces the business and referential integrity constraints associated with the entity.
  • BEFORE_DML — the pre-DML trigger logic that sets up defaults and validation before insert or update processing.

No parameter lists are published in the documented metadata; the descriptions therefore reflect purpose only.

Tables Accessed

The package references the following tables through APPS synonyms:

  • IGS_PS_OFR_OPT_ALL — the primary entity table holding offering option rows; the target of INSERT_ROW, UPDATE_ROW, and DELETE_ROW.
  • IGS_GE_REF_CD and IGS_GE_REF_CD_TYPE_ALL — the reference-code and reference-code-type tables, used to validate and decode codes stored against the offering option.
  • IGS_PS_ENT_PT_REF_CD_SEQ_NUM_S — the sequence used to generate sequence numbers for entry-point reference codes tied to the option.
  • DUAL — used for scalar lookups and single-row evaluations.
  • USER_OBJECTS — used to verify object existence or metadata during validation.

Usage Notes

IGS_PS_OFR_OPT_PKG is typically invoked indirectly. Oracle Forms built on the Offering Option block call the ADD_ROW, UPDATE_ROW, and DELETE_ROW routines for user-driven maintenance, while BEFORE_DML and CHECK_CONSTRAINTS enforce validation. Concurrent programs such as IGS_PS_GEN_001 and the purge utility IGS_PS_PURGE_DEL_RECORD call the package for bulk generation and cleanup of offering option data. Other IGS packages — including IGS_PS_OFR_PKG, IGS_PS_OFR_PAT_PKG, IGS_PS_OFR_OPT_NOTE_PKG, IGS_PS_OF_OPT_AD_CAT_PKG, IGS_PS_OF_OPT_UNT_ST_PKG, IGS_AD_LOCATION_PKG, IGS_EN_ATD_MODE_PKG, IGS_EN_ATD_TYPE_PKG, IGS_EN_SPA_TERMS_PKG, IGS_EN_STDNT_PS_ATT_PKG, IGS_HE_POOUS_ALL_PKG, IGS_HE_POOUS_OU_ALL_PKG, and IGS_PS_ENT_PT_REF_CD_PKG — depend on it for consistent access to option records. Custom extensions should call these documented routines rather than issuing direct DML against IGS_PS_OFR_OPT_ALL, so that the packaged validation and locking behaviour is preserved across both 12.1.1 and 12.2.2 releases.