Search Results igs_fi_fnd_src_rstn_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_FI_FND_SRC_RSTN_PKG package is a PL/SQL database object within the Oracle E-Business Suite (EBS) environment, specifically belonging to the Student Systems (IGS) product family. It is an internal library package designed to encapsulate the business logic and database operations for the IGS_FI_FND_SRC_RSTN entity—the Funding Source Restriction table. In the context of Oracle EBS 12.1.1 and 12.2.2, this package acts as a structured Data Manipulation Language (DML) handler, ensuring that all inserts, updates, and deletes on the underlying table are performed through a standardized, validated interface.

Its primary function is to manage restrictions placed on funding sources within the institution's financial aid or student funding setup. By centralizing DML operations, the package enforces data integrity, executes necessary validation checks, and maintains referential integrity between funding sources and their associated restrictions.

Key Procedures and Functions

The package exposes a set of ten documented procedures and functions that form a complete CRUD (Create, Read, Update, Delete) API for the IGS_FI_FND_SRC_RSTN table:

  • INSERT_ROW: Inserts a new record into the underlying table, populating the restriction data for a specific funding source.
  • UPDATE_ROW: Modifies an existing record in the table, typically keyed by the primary key of the restriction.
  • ADD_ROW: An alias or wrapper for insert functionality, often used in specific form-level processing to add a new row to the dataset.
  • DELETE_ROW: Removes a record from the table, possibly performing dependent checks before deletion.
  • LOCK_ROW: Issues a selective SELECT ... FOR UPDATE to lock a specific row, preventing concurrent modification during an update or delete transaction.
  • CHECK_CONSTRAINTS: Validates business rules and database constraints before a DML operation is committed, ensuring the data adheres to the application's logic.
  • GET_PK_FOR_VALIDATION: Retrieves the primary key of the restriction record, used for validation and referential lookup purposes.
  • GET_FK_IGS_FI_FUND_SRC: Fetches the foreign key value linking the restriction to its parent IGS_FI_FUND_SRC (Funding Source) entity.
  • GET_FK_IGS_PS_VER: Fetches the foreign key value linking the restriction to a specific version in the IGS_PS_VER (Student Program Version) entity.
  • BEFORE_DML: A centralized pre-DML trigger-style routine that executes validation and defaulting logic before any insert, update, or delete is performed on the entity.

Tables Accessed

The package interacts with the following database objects:

  • IGS_FI_FND_SRC_RSTN: The primary table managed by this package. It stores the restriction definitions that apply to specific funding sources. All procedures in the package ultimately read from or write to this table.
  • DUAL: The standard Oracle dummy table, used in GET_* functions and validation routines for performing single-row lookups, calculations, or existence checks (e.g., SELECT ... INTO ... FROM DUAL).

Usage Notes

This package is an internal API within the Student Systems module. It is typically not invoked directly by end users but is called programmatically by other PL/SQL packages and forms. As documented, it is directly referenced by three other packages: IGS_FI_FUND_SRC_PKG, IGS_PS_GEN_001, and IGS_PS_VER_PKG. This indicates that funding source and program version processing logic relies on this package to manage restriction data.

Because it is a public synonym within the APPS schema, custom extensions or integrations that need to maintain funding source restrictions should call these procedures rather than performing direct DML on the table. This ensures that the BEFORE_DML logic, constraint checks, and locking mechanisms are respected. The lack of a formal API classification ("OTHER") suggests it is a supporting library rather than a published integration API, but its dependencies confirm it is a stable, production component in EBS 12.1.1 and 12.2.2.