Search Results igf_se_payment_pkg




Overview
Explore in AI Chat

Overview

IGF_SE_PAYMENT_PKG is a PL/SQL package owned by the APPS schema that supports the Oracle E-Business Suite Student Systems / Grants functionality, specifically the payment processing layer of the Student Enrollment (IGF) module. In Oracle EBS 12.1.1 and 12.2.2 it forms part of the iGrants/Student Systems family of packages, which manage the disbursement and tracking of funds awarded to students or institutions through grants, loans, and similar financial aid programs. The package encapsulates the low-level data manipulation and validation logic for the IGF_SE_PAYMENT entity, which represents individual payment records associated with student disbursements.

The ETRM classification for this object is OTHER — that is, it is not an exposed public API but rather an internal package used by the module's own infrastructure. It is validated against the 12.1.1 database and referenced by two other packages, indicating it occupies a supporting role beneath a higher-level public interface.

Key Procedures and Functions

The package exposes eight documented procedures and functions. These fall into two categories: row-level DML handlers and supporting utility routines.

  • INSERT_ROW — Performs the core insert of a new IGF_SE_PAYMENT record, populating the entity from the caller's supplied values.
  • UPDATE_ROW — Applies modifications to an existing payment record in the base table.
  • DELETE_ROW — Removes a payment record from the base table.
  • ADD_ROW — A convenience wrapper that combines insert/update semantics for adding a payment row, typically called from the public API layer.
  • LOCK_ROW — Acquires a row-level lock on the target payment record to serialize concurrent modification attempts.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of a payment row so callers can validate existence or pass the key onward.
  • GET_FK_HZ_PARTIES — Returns the foreign key value referencing HZ_PARTIES, establishing the link between the payment and the party (student/recipient) record.
  • BEFORE_DML — A trigger-style routine that executes standard pre-DML logic such as who-column stamping and defaulting before the row is written.

Parameter signatures are not documented and should be confirmed by inspecting the package specification in the target instance.

Tables Accessed

Via APPS synonyms, the package references:

  • IGF_SE_PAYMENT — The base table holding payment records; the primary DML target.
  • IGF_SE_PAYMENT_INT — The interface/staging table used to import or validate payment data before it reaches the base table.
  • IGF_SE_PAYMENT_S — The translation (seed) table holding language-specific descriptive text for payment rows.
  • IGF_SE_AUTH — The authorization table defining disbursement authority for the payment.
  • IGF_AP_FA_BASE_REC_ALL and IGF_AW_FUND_MAST_ALL — Award and fund master tables supplying the award/fund context against which a payment is validated.
  • HZ_PARTIES — The Trading Community Architecture party table; accessed through GET_FK_HZ_PARTIES to bind the payment to a recipient.
  • DUAL — Used for single-row scalar selection and defaulting.

Usage Notes

The package is referenced by IGF_SE_PAYMENT_PUB, the public wrapper through which forms, OAF pages, and concurrent programs interact with payment data, and by IGF_SE_GEN_001, a generation program that creates payment records in bulk. It is therefore invoked indirectly whenever a user creates, updates, or deletes a student payment through the Grants UI, and during batch disbursement or payment-generation runs.

Because it is classified as OTHER rather than a public API, custom code should call IGF_SE_PAYMENT_PUB rather than this package directly, so that validation and locking semantics are preserved. Direct invocation of IGF_SE_PAYMENT_PKG risks bypassing the business rules enforced at the public layer.