Search Results igf_aw_coa_grp_item_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGF_AW_COA_GRP_ITEM_PKG is a PL/SQL package within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, classified in the ETRM registry under the API classification OTHER and owned by the APPS schema. The package forms part of the Oracle Grants / Awards (IGF) module family, specifically the awards (AW) subsystem, and manages the intersection of Chart of Accounts (COA) code combinations with award group items. Its principal business function is to expose a controlled, table-style API (often referred to as a TAPI — Table API) around the IGF_AW_COA_GRP_ITEM_ALL entity, allowing the different layers of the application stack to perform consistent, validated data manipulation against that table without embedding direct DML statements. The naming convention "COA_GRP_ITEM" indicates that the package is responsible for maintaining the relationship records that link individual items to COA groups, including attributes such as default value flags, fixed-cost indicators, Pell grant amounts and alternate amounts, item distribution settings, and active status flags.

Key Procedures and Functions

The ETRM documentation lists nine procedures and functions in this package. These are standard TAPI building blocks:

  • INSERT_ROW — Performs a validated insert of a new row into the underlying table. It accepts the full set of column values, including COA code, calendar type and sequence number, item code, default value, fixed cost, Pell-related flags and amounts, item distribution, and lock flag. The x_mode parameter defaults to 'R' (row mode), indicating the standard TAPI insert behavior. A rowid is returned via an IN OUT NOCOPY parameter.
  • LOCK_ROW — Acquires a row-level lock on an existing record identified by rowid, validating the supplied attribute values against the current row so that concurrent updates are serialized and optimistic locking is enforced.
  • UPDATE_ROW — Applies validated updates to an existing record, again keyed by rowid, using the same parameter set and default mode as the insert operation.
  • ADD_ROW — Similar in signature to INSERT_ROW, this procedure typically performs an insert after first checking for the existence of a matching row, enabling the API to be used idempotently by callers that do not know whether the record already exists.
  • DELETE_ROW — Removes a row from the underlying entity, presumably by primary key or rowid, and is normally accompanied by the delete-validation logic in the BEFORE_DML trigger.
  • GET_PK_FOR_VALIDATION — Returns the primary-key combination used by the API's validation routines so that callers or other APIs can verify uniqueness and existence without duplicating the key derivation logic.
  • GET_FK_IGF_AW_COA_GROUP — Resolves the foreign key to the COA group, supporting relational validation of the parent COA group record.
  • GET_FK_IGF_AW_ITEM — Resolves the foreign key to the item master entry, validating the item referenced by each association row.
  • BEFORE_DML — A shared internal procedure invoked by the DML entry points to apply default values, WHO-column population, and validation logic before the row is committed.

Tables Accessed

The package reads and writes a single documented base table, IGF_AW_COA_GRP_ITEM_ALL, accessed through an APPS synonym. This table stores the association records connecting source/detail COA group definitions to item codes, along with the operational attributes (default value, fixed cost, Pell COA, active flag, Pell amounts, item distribution, and lock flag) declared in the procedure signatures. The _ALL suffix implies that the table is multi-org enabled and that the API operates against the appropriate operating unit context. No other base tables are documented in the metadata, although the foreign-key lookup procedures imply logical dependencies on the COA group and item entities referenced by the FK columns.

Usage Notes

This package is a server-side TAPI and is typically invoked from Oracle Forms clients, concurrent programs, and other PL/SQL packages within the Grants and Awards modules rather than called directly by end users. The ETRM metadata records that the package is referenced by five other packages, indicating that it sits at a relatively foundational layer of the Grants awards dependency graph; downstream packages rely on it to maintain COA-group/item associations consistently. Customizations that need to insert or maintain such associations should call the documented procedures rather than issuing direct DML against IGF_AW_COA_GRP_ITEM_ALL, so that the BEFORE_DML validation, WHO column defaults, and foreign-key checks remain in effect. The header comment ($Header: IGFWI06S.pls 120.0 2005/06/01) shows that the package has been stable since the earlier releases of the family, and the same interface is carried forward into 12.2.2 with no documented signature changes.