Search Results igs_ps_of_opt_unt_st_pkg




Overview
Explore in AI Chat

Overview

IGS_PS_OF_OPT_UNT_ST_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the Higher Education / Student System product family (the IGS_ prefix denotes the Oracle Student System module). Its name expands to "Institution General Studies – Program of Study – Offered Option Unit Set Status," indicating responsibility for maintaining the status attributes of offered option unit sets within a program-of-study offering. In EBS 12.1.1 and 12.2.2, this package operates as a low-level data-access and DML utility rather than a business-facing API. It encapsulates the row-level operations that other Student System packages and generated forms depend on, providing a consistent, reusable layer for inserting, updating, locking, and deleting records in the underlying status table. The package is documented as VALID in the ETRM repository and is classified as API classification OTHER.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions within this package. Their purposes are as follows:

  • AFFECTED – Returns or records the row(s) impacted by a preceding DML operation, supporting downstream processing and audit logic.
  • LOCK_ROW – Acquires a row-level lock on the target status record to guarantee serialized access before modification, preventing concurrent update conflicts.
  • UPDATE_ROW – Applies changes to an existing status row in the offered option unit set status table.
  • ADD_ROW – Inserts a new status row for an offered option unit set.
  • DELETE_ROW – Removes a status row from the underlying table.
  • GET_PK_FOR_VALIDATION – Retrieves the primary key of a record so that it can be validated against foreign-key or business constraints.
  • GET_FK_IGS_PS_OFR_OPT – Resolves the foreign key linking the status record to the IGS_PS_OFR_OPT entity (offered option).
  • GET_UFK_IGS_PS_OFR_OPT – Retrieves the unique/alternate key value for the related offered option, used for validation and lookup.
  • GET_FK_IGS_PS_OFR_UNIT_SET – Resolves the foreign key linking the status record to the IGS_PS_OFR_UNIT_SET entity (offered unit set).
  • CHECK_CONSTRAINTS – Validates that all required relational and business constraints are satisfied before committing a DML operation.
  • BEFORE_DML – Executes pre-insert/pre-update logic, such as defaulting status values, timestamps, or derived attributes, immediately prior to the DML statement.

No parameter lists are documented in the ETRM excerpt; callers should inspect the package specification in the database for exact signatures.

Tables Accessed

The package reads from and writes to IGS_PS_OF_OPT_UNT_ST (accessed through an APPS synonym), the table that stores status information for offered option unit sets. All eleven procedures operate against this single base table. The GET_FK_* and GET_UFK_* routines imply logical joins against IGS_PS_OFR_OPT and IGS_PS_OFR_UNIT_SET to resolve parent-key relationships, though the ETRM metadata lists only IGS_PS_OF_OPT_UNT_ST as a directly referenced table.

Usage Notes

IGS_PS_OF_OPT_UNT_ST_PKG is referenced by four other APPS packages: IGS_PS_GEN_001, IGS_PS_GEN_008, IGS_PS_OFR_OPT_PKG, and IGS_PS_OFR_UNIT_SET_PKG. It is therefore invoked indirectly when those higher-level packages perform DML against option unit set status data. Typical invocation paths include Student System setup and offering maintenance forms, generated form handlers (the GEN_ packages are typically Oracle Forms generated code), and any concurrent program or custom extension that must create or amend offered option unit set status records. Because the package is not a formal public API, Oracle does not guarantee its interface across releases; custom code should avoid calling it directly and instead use the documented higher-level packages that wrap it.