Search Results igs_ps_unit_ofr_opt_pkg




Overview
Explore in AI Chat

Overview

IGS_EN_NSTD_USEC_DL_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It belongs to the Student Systems product family, specifically the IGS (Student Records / Higher Education) module, and handles maintenance of non-standard use of a student's enrolment records through the IGS_EN_NSTD_USEC_DL entity. The package follows the standard EBS table-handling design pattern, exposing DML wrapper procedures and validation helpers that centralize inserts, updates, deletes, locking, and foreign-key resolution for the underlying base table and its shadow (MLS) table. Its documented API classification is OTHER, and it is registered as VALID in the ETRM 12.1.1 repository.

In the Oracle EBS 12.1.1 and 12.2.2 environments, the package sits behind the enrolment-related forms and concurrent processes that capture, amend, or remove non-standard use records. The referenced-by metadata confirms that it is consumed by IGS_PS_CREATE_GENERIC_PKG and IGS_PS_UNIT_OFR_OPT_PKG, tying it directly to programme/unit-of-study offering processing. This is relevant to the search term "igs_ps_unit_ofr_opt_pkg": that package is a documented caller of IGS_EN_NSTD_USEC_DL_PKG, so any change to this package's behavior can propagate into module-offering option processing.

Key Procedures and Functions

The metadata documents 10 procedures and functions:

  • INSERT_ROW — performs the initial insert of a new non-standard use detail row into the base table.
  • ADD_ROW — adds a row as part of the package's controlled DML layer, typically invoked before validation and insert steps.
  • UPDATE_ROW — applies changes to an existing row, managing both the base record and its associated attributes.
  • DELETE_ROW — removes a row from the entity, respecting referential constraints.
  • LOCK_ROW — acquires a row-level lock to serialize concurrent modifications before an update or delete.
  • BEFORE_DML — a trigger-support routine that prepares derived/audit columns and performs pre-DML initialization common to all write paths.
  • GET_PK_FOR_VALIDATION — resolves the primary key value used by validation logic.
  • GET_UK_FOR_VALIDATION — resolves the unique key value used for uniqueness checks.
  • GET_UFK_IGS_PS_UNIT_OFR_OPT — returns the user/foreign key value pointing to the unit-of-study offering option, linking the non-standard use record to its PS offering context.
  • GET_FK_IGS_EN_NSU_DLSTP_ALL — returns the foreign key value relating the record to the IGS_EN_NSU_DLSTP_ALL entity.

Parameter signatures are not part of the documented metadata and are intentionally not reproduced here.

Tables Accessed

The package operates on two documented base objects plus DUAL, all resolved through APPS synonyms:

  • IGS_EN_NSTD_USEC_DL — the primary table storing non-standard use of enrolment detail records. All insert, update, delete, and lock operations target this table.
  • IGS_EN_NSTD_USEC_DL_S — the secondary/shadow table used in the EBS MLS pattern, holding translated or alternate-language attribute values for each base row.
  • DUAL — used for single-value validation lookups, key derivation, and EXISTS-style checks executed inside the GET_* validation functions.

Usage Notes

IGS_EN_NSTD_USEC_DL_PKG is normally invoked indirectly. Student-record forms for non-standard use and enrolment call the ADD_ROW/INSERT_ROW/UPDATE_ROW/DELETE_ROW entry points rather than issuing DML against IGS_EN_NSTD_USEC_DL directly, ensuring the BEFORE_DML defaults and GET_* validation helpers run consistently. Concurrent programs and generic creation routines pass through it as well; the dependency listing confirms IGS_PS_CREATE_GENERIC_PKG and IGS_PS_UNIT_OFR_OPT_PKG reference it, so offering and enrollment setup processes will exercise the same code path. Custom extensions should call the package's documented procedures instead of manipulating the tables directly, and any modification must account for both IGS_EN_NSTD_USEC_DL and its _S table to avoid MLD/dataloss issues between 12.1.1 and 12.2.2.