Search Results p_close_date

Overview

IGW_INSTALLMENTS_PVT is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its classification as a PVT (private) API indicates that it is intended for internal consumption by other Oracle Application modules rather than as a public integration interface. The package encapsulates the core business logic governing installment records within the Grants Management (IGW/GMS) product family. Installments represent scheduled or staged payment amounts tied to an award, grant, or sponsored project funding arrangement. The package provides the persistence-level operations required to create, modify, and remove these installment records while enforcing the validation, message-handling, and error-propagation conventions mandated by the Oracle EBS API framework.

The body is marked VALID in the ETRM registry, confirming that it compiles cleanly and presents no invalid dependencies at the documented releases. It is not referenced by any other database object, meaning its callers reside outside the schema-level dependency graph — typically form libraries, concurrent program wrappers, or sibling packages invoking it dynamically.

Key Procedures and Functions

The ETRM metadata documents three procedures within this package body:

• CREATE_INSTALLMENT — Inserts a new installment record. It applies the standard API validation sequence, populates required columns, and registers any business-rule violations with the FND message stack before committing through the underlying table handler.
• UPDATE_INSTALLMENT — Modifies the attributes of an existing installment, such as amount, schedule date, or status. It performs the same validation and message-accumulation pattern as the create routine, ensuring consistent error reporting across the API surface.
• DELETE_INSTALLMENT — Removes an installment record, subject to the referential and business constraints enforced by the package logic.

Each procedure follows the FND_API convention of accepting a standard parameter set including a return status and a message list, allowing callers to inspect outcomes without relying solely on exceptions.

Tables Accessed

The package operates against IGW_INSTALLMENTS, accessed through the APPS synonym layer. This table stores the installment master rows — the schedule entries and monetary amounts associated with a funding source. All three DML operations target this single table. Supporting reads draw on GMS_LOOKUPS for validation of lookup-coded columns, confirming that installment attributes such as status or type are constrained to defined lookup values. The package also declares a dependency on IGW_INSTALLMENTS_TBH, the dedicated table handler that isolates direct SQL manipulation and enforces row-level consistency.

Usage Notes

Because IGW_INSTALLMENTS_PVT is a private API, it is not intended for direct invocation from customer extensions. It is instead called by the Grants Management forms layer and by the IGW_INSTALLMENTS_PVT specification when a user creates, amends, or deletes installment schedules through the Awards or Grants Maintenance user interface. The package relies on FND_API, FND_MESSAGE, and FND_MSG_PUB to perform standard API initialization, message token substitution, and message-stack publication; callers should therefore invoke FND_MSG_PUB.initialize prior to use and inspect the returned message list afterward. Custom code that must manipulate installments should preferentially use public Grants Management APIs; where no public alternative exists, developers should treat this package as unstable across patches. Its zero inbound dependencies and VALID status indicate a self-contained, form-driven maintenance utility typical of EBS 12.1.1 and 12.2.2 Grants Management internals.