Search Results igs_ps_awd_own_pkg




Overview
Explore in AI Chat

Overview

IGS_PS_AWD_OWN_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business PL/SQL delivered for the Student System (IGS) product family. Its name and table dependencies identify it as the owner (OWN) data-access layer for the awards (AWD) of a program of study within the Student System academic structure. In Oracle EBS 12.1.1 and 12.2.2 this package serves as the internal implementation package behind the Award Ownership entity: it encapsulates the standard Oracle Forms DML pattern (row insertion, deletion, updating, and locking) plus the table-handler validation logic required to keep award owner records consistent with their parent award. It is thus a supporting, non-public API — classified in the ETRM metadata as API classification OTHER — rather than a published business interface. Application developers should treat it as the private backend for the Award Ownership maintenance form and its underlying validation, not as a general-purpose external API.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions in the package. Their purposes align with the standard Oracle Forms table-handler and row-level DML conventions used throughout the IGS schema:

  • INSERT_ROW — Inserts a new Award Ownership record into the database, mapping the form or caller values to the underlying table columns.
  • UPDATE_ROW — Updates an existing Award Ownership record in the underlying table.
  • DELETE_ROW — Deletes the currently selected Award Ownership record.
  • ADD_ROW — Adds a new row to the block/collection, typically priming defaults before the row is committed.
  • LOCK_ROW — Obtains a row-level lock on the selected record, preventing concurrent modification while it is edited.
  • BEFORE_DML — Table-handler pre-DML event procedure, invoked by Oracle Forms before insert, update, or delete to perform final validation.
  • CHECK_CONSTRAINTS — Performs the business-rule and referential integrity checks required before a DML operation is permitted.
  • GET_PK_FOR_VALIDATION — Resolves the primary key of an Award Ownership record for validation purposes.
  • GET_FK_IGS_OR_UNIT — Resolves the foreign key linking the record to the owning organizational unit, supporting validation of the parent reference.

Exact parameter signatures are not exposed in the ETRM metadata and are deliberately not reproduced here; callers should consult the package specification in the database for authoritative signatures.

Tables Accessed

The package operates against two documented tables through APPS synonyms:

  • IGS_PS_AWD_OWN — the primary table holding Award Ownership records, keyed to the award. This is the base table for all row-level DML and locking operations.
  • IGS_PS_AWARD — the parent Award table, read to validate the award reference on the ownership record and to enforce parent-child consistency.

These are the only documented table references. No additional data structures are reported in the ETRM dependency listing.

Usage Notes

IGS_PS_AWD_OWN_PKG is a private implementation package. The ETRM dependency metadata records that it is referenced only by itself and by IGS_PS_GEN_001, an IGS generation/support package, indicating that it is invoked indirectly rather than called directly by end user or interface code. In practice it is exercised by the Oracle Forms front end that maintains Award Ownership information for a program of study, with the form's Table Handler triggering INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW, and BEFORE_DML at the appropriate block events, and CHECK_CONSTRAINTS enforcing integrity before commit. Because the package is not classified as a public API, custom extensions should not call its procedures directly; instead, custom code should extend or wrap the standard forms and concurrent program flows that use it, or perform its own DML against IGS_PS_AWD_OWN and IGS_PS_AWARD under appropriate validation. Any change to the package should be assessed for impact on IGS_PS_GEN_001, the sole documented dependent. Both EBS 12.1.1 and 12.2.2 utilise the online patching and editioning model, so package changes are applied through ADOP on 12.2.2 and should be regression-tested with the Award Ownership form and the IGS_PS_GEN_001 consumer.