Search Results igs_ps_award_pkg




Overview
Explore in AI Chat

Overview

IGS_PS_AWARD_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Student System (IGS) product family. Its name prefix, IGS_PS, associates it with the Student Systems "Prospective Student" and awards domain, and its single documented base table, IGS_PS_AWARD, confirms that it manages award records — the qualifications, certificates, diplomas, or degrees that a student is enrolled toward or has been granted. In EBS 12.1.1 and 12.2.2 the package functions as a low-level table handler rather than an end-user-facing API, encapsulating the insert, update, lock, and constraint-validation logic for the IGS_PS_AWARD entity. Because the object is documented as VALID and dependent only on SYS.STANDARD, it is a stable, self-contained unit that other IGS packages call into rather than a package that itself orchestrates broader business flows.

The documented API classification is OTHER, indicating that the package is not a public, supported extension point such as a _PUB package, but an internal implementation detail of the Student System data model.

Key Procedures and Functions

The ETRM metadata documents eight callable units. They fall into two natural groups — DML helpers and validation helpers:

  • INSERT_ROW — Inserts a new row into the award table. This is the core creation primitive for an award record.
  • UPDATE_ROW — Modifies an existing award row.
  • ADD_ROW — A convenience routine that combines insertion handling, typically used where a caller wants create-or-append semantics without invoking the low-level insert directly.
  • LOCK_ROW — Acquires a row-level lock on an award record, providing concurrency control before an update so that two sessions cannot modify the same award simultaneously.
  • GET_PK_FOR_VALIDATION — Returns the primary key value used during validation processing, allowing callers to resolve the surrogate key of an award before validating dependent data.
  • GET_FK_IGS_PS_VER — Resolves the foreign key relationship to the IGS_PS_VER entity (version), returning the version key associated with an award. This links an award to its versioned definition.
  • CHECK_CONSTRAINTS — Performs application-level constraint validation on award data, enforcing business rules that may go beyond declarative database constraints.
  • BEFORE_DML — A pre-DML hook that executes standard housekeeping before insert or update operations, such as populating audit columns or defaulting attributes.

Parameter lists are not exposed in the ETRM excerpt and are intentionally not reproduced here.

Tables Accessed

The only table documented as accessed is IGS_PS_AWARD, referenced through an APPS synonym. This table stores award definitions and their association to the award hierarchy and versions. All eight procedures operate against this entity: INSERT_ROW, ADD_ROW, UPDATE_ROW, and LOCK_ROW perform the DML and concurrency work; BEFORE_DML and CHECK_CONSTRAINTS support those operations; and GET_PK_FOR_VALIDATION plus GET_FK_IGS_PS_VER supply key and foreign-key resolution needed when the award is validated or linked to its version record.

Usage Notes

IGS_PS_AWARD_PKG is referenced by six other packages — IGS_GR_AWD_CEREMONY_PKG, IGS_GR_GRADUAND_PKG, IGS_GR_GRD_LGCY_PUB, IGS_PS_AWD_OWN_PKG, IGS_PS_GEN_001, and IGS_PS_VER_PKG — as well as by itself. This reference pattern shows that award maintenance is invoked from graduation ceremony processing, graduand management, award ownership, and award versioning routines. Typically the package is called from Oracle Forms-based maintenance windows for the Student System, from concurrent programs that generate or update award data, and from custom extensions that manipulate awards directly. Because it is an internal handler, direct invocation from customer code is discouraged in favour of the supported public APIs (such as IGS_GR_GRD_LGCY_PUB); any custom call must respect the before-DML and constraint-checking sequence to avoid invalid award rows.