Search Results delete_installment

Overview

IGW_INSTALLMENTS_PVT is a private PL/SQL API package owned by the APPS schema in Oracle E-Business Suite (12.1.1 and 12.2.2). The "IGW" prefix identifies it as part of the Grants Accounting / Oracle Grants Management product family, and the "_PVT" suffix designates it as a private API — that is, an internal implementation package rather than a public, supported integration interface. The package encapsulates the core create, update, and delete (DML) logic for installment records associated with proposal awards, and it is intended to be consumed by other packages or forms within the Grants module rather than called directly by external customers. Its responsibilities include validating installment attributes, maintaining audit and versioning information, and managing the transactional integrity of installment records stored in the underlying base table.

Key Procedures and Functions

The documented package exposes three procedures, all of which follow the standard Oracle EBS API return-status convention (x_return_status, x_msg_count, x_msg_data), as well as Fnd_Api message-list and commit conventions (p_init_msg_list, p_validate_only, p_commit).

• Create_Installment — Inserts a new installment record. It accepts the parent proposal award identifier and installment identifying attributes (installment number, description, type code and description, issue, close, start, and end dates), along with financial attributes (direct cost, indirect cost, billable flag). It returns the new row's ROWID and the generated proposal_installment_id, and reports outcome through the standard return-status parameters.
• Update_Installment — Modifies an existing installment record. In addition to the descriptive and financial attributes handled by Create, it accepts the ROWID, the proposal_installment_id, and a record_version_number, enabling optimistic locking consistent with Oracle EBS concurrency standards.
• Delete_Installment — Removes an installment record. The metadata excerpt truncates this procedure's signature, so the specific parameters should be confirmed against the delivered source before it is invoked.

Tables Accessed

The package operates against a single documented base table, IGW_INSTALLMENTS, referenced through an APPS synonym. This table stores the installment records that link to a proposal award; Create inserts into it, Update modifies existing rows, and Delete removes them. All DML is validated and committed under the control of the aforementioned API parameters.

Usage Notes

Because there are no documented callers and no other APPS packages referencing IGW_INSTALLMENTS_PVT, it should be understood as an internal building block invoked by higher-level Grants Accounting logic — typically from the Grants forms stack or from a companion public API that wraps these private procedures. Oracle's standard guidance is that private (_PVT) APIs are subject to change between releases and are not part of the supported customization surface; custom code should instead call the corresponding public API. Developers who search for "create_installment" should treat Create_Installment as the insert operation behind installment maintenance screens, always honoring the p_validate_only flag for dry-run validation, respecting the p_commit setting rather than issuing an independent COMMIT, and checking x_return_status along with the Fnd_Msg_Pub message stack before proceeding. Callers must also supply a valid parent proposal_award_id, as the installment cannot exist independently of its award.