Search Results igf_sl_alt_borw_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGF_SL_ALT_BORW_PKG package body is a core component of the Oracle E-Business Suite Financial Aid module, specifically within the Student Loan (IGF) subsystem. Its name—Alternate Borrower—indicates that it manages data pertaining to alternate or co-signer borrowers associated with student loans. In the context of Oracle EBS 12.1.1 and 12.2.2, this package encapsulates the business logic and DML operations required to create, maintain, and validate alternate borrower records. The package body is documented as VALID and classified as an OTHER API, meaning it is not a public, externally supported interface but rather an internal implementation package. It serves as the primary programmatic gateway for manipulating the IGF_SL_ALT_BORW_ALL entity, ensuring that all insertions, updates, and deletions conform to the referential and validation rules required by the Financial Aid data model.

Key Procedures and Functions

The package exposes eight documented procedures that collectively implement the standard table-handler pattern used throughout Oracle EBS applications:

  • INSERT_ROW – Inserts a new alternate borrower record, populating the base table columns and invoking validation logic.
  • LOCK_ROW – Acquires a row-level lock on an existing alternate borrower record to prevent concurrent modification.
  • UPDATE_ROW – Applies modifications to an existing alternate borrower record within the base table.
  • ADD_ROW – Provides an alternate, higher-level entry point for adding a record, typically wrapping INSERT_ROW with additional defaulting or validation.
  • DELETE_ROW – Removes an alternate borrower record, subject to the package's referential integrity checks.
  • GET_PK_FOR_VALIDATION – Retrieves the primary key of a record for use in downstream validation routines.
  • GET_FK_IGF_SL_LOANS – Resolves the foreign key relationship linking an alternate borrower to its parent loan record.
  • BEFORE_DML – Centralized pre-DML logic that enforces WHO-column population, date stamping, and other standard auditing rules before any insert, update, or delete proceeds.

Tables Accessed

The package operates against the following documented database objects, referenced through APPS synonyms:

  • IGF_SL_ALT_BORW_ALL – The base table storing alternate borrower records. All DML operations target this table.
  • IGF_SL_ALT_BORW_ALL_S – The corresponding sequence used to generate unique primary keys for new alternate borrower rows.
  • DUAL – Utilized for singleton queries and sequence value retrieval.

In addition, the package body depends on supporting packages including IGF_SL_LOANS_PKG (for loan-level context), FND_GLOBAL and FND_MESSAGE (for session context and user-facing messaging), APP_EXCEPTION, IGS_GE_GEN_003, and IGS_GE_MSG_STACK (for error handling and message stacking).

Usage Notes

Because this package is classified as OTHER and is not referenced by any other database object, it is intended to be invoked indirectly through the Financial Aid forms and concurrent programs that manage student loans. Typical invocations occur when a user creates or maintains an alternate borrower in the Student Loan maintenance forms, or when batch processes load alternate borrower data. The ETRM metadata notes that the package references three other packages and is itself referenced by three packages, indicating a moderate integration footprint. Customizations should not call the package directly unless the form or concurrent program layer has been extended accordingly; instead, extensions should respect the BEFORE_DML and validation conventions enforced here to preserve data integrity across Oracle EBS 12.1.1 and 12.2.2 environments.