Search Results igf_sl_loans_pkg




Overview
Explore in AI Chat

Overview

IGF_SL_LOANS_PKG is a PL/SQL package in the APPS schema whose body implements the core data-maintenance logic for student loan records within Oracle E-Business Suite. The IGF module family supports the financial aid and student loan lifecycle, and this package is specifically responsible for the loan header entity represented by the IGF_SL_LOANS_ALL and IGF_SL_LOANS_S tables. In ETRM classification the package is registered as an "OTHER" API rather than a public, supported interface, which indicates that it is consumed internally by other loan-processing packages rather than by external integrations directly.

The package body is documented as VALID and is referenced by 25 other packages, confirming that it functions as a shared foundation utility for the loan data model. Its design pattern follows the standard Oracle Designer/Forms generator style: table-handler procedures for INSERT, UPDATE, DELETE, and LOCK operations, together with validation helpers and a BEFORE_DML trigger body. This pattern provides row-level integrity enforcement, primary/unique/foreign key resolution, and sequence population for the loan entities.

Key Procedures and Functions

The documented interface of the package body contains ten procedures and functions:

  • INSERT_ROW — inserts a new loan row into the underlying loan table, applying defaulting and sequencing logic.
  • LOCK_ROW — acquires a row-level lock on an existing loan record, used to serialize concurrent modifications.
  • UPDATE_ROW — persists modifications to an existing loan row.
  • ADD_ROW — add semantics for the loan entity, populating identifying and descriptive columns.
  • DELETE_ROW — removes a loan row from the entity, subject to the package's referential checks.
  • GET_PK_FOR_VALIDATION — resolves the primary key of a loan row, supporting validation of duplicate or conflicting records.
  • GET_UK_FOR_VALIDATION — resolves the primary unique key used to validate uniqueness constraints.
  • GET_UK2_FOR_VALIDATION — resolves a secondary unique key, providing validation against an alternate uniqueness rule.
  • GET_FK_IGF_AW_AWARD — retrieves the foreign key relationship to the award entity, validating the loan-to-award association.
  • BEFORE_DML — a trigger-style routine executed prior to DML to enforce audit columns, defaults, and derived values.

Tables Accessed

The package reads and writes the following tables through APPS synonyms: IGF_SL_LOANS_ALL, the loan header entity; IGF_SL_LOANS_S, the corresponding sequence/row handle; IGF_SL_CLCHSN_DTLS, change-selection detail records used when loan data is versioned or changed; IGF_AW_DB_CHG_DTLS, award disbursement change details; IGF_AW_FUND_CAT_ALL, award fund categories; and FND_NEW_MESSAGES, the Applications message repository used for runtime error signalling, accessed alongside DUAL. Message handling also relies on FND_MESSAGE, FND_GLOBAL, and IGS_GE_MSG_STACK. Change processing delegates to IGF_SL_CL_CHG_PRC and IGF_SL_CL_CREATE_CHG, while alternate borrower handling uses IGF_SL_ALT_BORW_PKG and choice detail logic uses IGF_SL_CLCHSN_DTLS_PKG. Disbursement manifest and promissory note generation are handled through IGF_SL_DL_MANIFEST_PKG, IGF_SL_DL_PNOTE_P_P_PKG, and IGF_SL_DL_PNOTE_S_P_PKG.

Usage Notes

Because the package exposes internal table handlers rather than a formal public API, it is normally invoked by other IGF packages and by the Oracle Forms loan maintenance screens rather than being called directly by custom code. Customizations should prefer the higher-level loan and award packages; where direct invocation is required, callers must respect LOCK_ROW, BEFORE_DML, and the validation functions in the documented order to avoid bypassing integrity checks. In Oracle EBS 12.1.1 and 12.2.2 the object exists in the APPS schema with a VALID status, and the same source is delivered in both releases for the unmodified code line.