Search Results igs_pr_ou_fnd_pkg




Overview
Explore in AI Chat

Overview

IGS_PR_OU_FND_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and classified as an "OTHER" API in the ETRM repository for release 12.1.1. It operates within the Oracle Student System (formerly Oracle iGS / Oracle Higher Education) product family, where the "IGS_PR" prefix denotes the Prospect and Recruitment module and "OU_FND" identifies an organizational unit funding entity. The package serves as the table-handling API for the IGS_PR_OU_FND base table, encapsulating the standard row-level DML operations required by the Oracle Forms automatic locking and block-processing model. It is a valid, compiled object in the database and is referenced by several other packages in the same module, including IGF_AW_FUND_CAT_PKG, IGS_PR_GEN_004, IGS_PR_GEN_006, and IGS_PR_RU_OU_PKG, indicating that it acts as a foundational dependency for both the prospect/recruitment and awards/funding areas. Because it is a Forms-generated style API rather than a business-logic API, its scope is intentionally narrow: it exists to support insert, update, delete, lock, and validation operations on a single table.

Key Procedures and Functions

The package exposes seven documented procedures and functions, all of which follow the Oracle Forms "table handler" convention:

  • INSERT_ROW — Inserts a new row into the IGS_PR_OU_FND table, populating the primary key and audit columns.
  • LOCK_ROW — Acquires a row-level lock during Forms update processing to prevent lost updates in a multi-user environment.
  • DELETE_ROW — Removes a row from IGS_PR_OU_FND, typically invoked when a user deletes a record in the associated form.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key value used for validation purposes, supporting the Forms validation logic.
  • GET_FK_IGS_PR_RU_OU — Returns the foreign key value linking the record to the IGS_PR_RU_OU parent entity (research unit / organizational unit).
  • GET_FK_IGF_AW_FUND_CAT — Returns the foreign key value linking the record to the IGF_AW_FUND_CAT (awards funding category) entity.
  • BEFORE_DML — A pre-DML trigger routine that executes audit and validation logic before the insert, update, or delete operation occurs.

No parameter lists are documented in the available metadata; only the purpose of each routine can be confirmed.

Tables Accessed

The package reads and writes a single documented table, IGS_PR_OU_FND, accessed through an APPS synonym. This table stores the funding records associated with prospect/recruitment organizational units, and it is the sole target of the INSERT_ROW, LOCK_ROW, DELETE_ROW, and BEFORE_DML routines. The two GET_FK functions reference foreign key relationships to the IGS_PR_RU_OU table (organizational unit data) and the IGF_AW_FUND_CAT table (award funding categories), though those parent tables are not directly manipulated by this package. Referential integrity is therefore enforced at the database level while this API handles row-level maintenance of the child funding table.

Usage Notes

IGS_PR_OU_FND_PKG is typically invoked indirectly rather than called by end users. It is primarily consumed by Oracle Forms blocks built on the IGS_PR_OU_FND table, where the Forms runtime automatically calls INSERT_ROW, LOCK_ROW, DELETE_ROW, and BEFORE_DML during standard record navigation and save operations. It is also referenced by the concurrent programs or PL/SQL routines IGS_PR_GEN_004 and IGS_PR_GEN_006, and by peer packages IGF_AW_FUND_CAT_PKG and IGS_PR_RU_OU_PKG, which depend on its foreign key retrieval functions for validation and funding lookups. Custom code should treat this package as a low-level table handler; direct calls are only appropriate when performing set-based maintenance of IGS_PR_OU_FND, and developers should ensure that concurrent program or batch processes respect the same validation performed by BEFORE_DML. Because the object is VALID and shipped in APPS, no recompilation or modification is required under EBS 12.1.1 or 12.2.2.