Search Results igf_aw_coa_items_pkg




Overview
Explore in AI Chat

Overview

IGF_AW_COA_ITEMS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and delivered as part of the Oracle Financials for India (IGF) application, specifically the Withholding Tax (AW) module. In Oracle EBS 12.1.1 and 12.2.2, the package body implements the server-side data access and maintenance logic for records held in the IGF_AW_COA_ITEMS table, which stores the mapping between Chart of Accounts (COA) combinations and withholding tax item definitions. Its primary business purpose is to provide a controlled, reusable API layer through which COA-based withholding tax item setup data is inserted, validated, updated, and deleted, ensuring that DML against the underlying table is consistent with application integrity rules such as primary key uniqueness, foreign key validation, and row-level locking. The package is classified as type OTHER in the ETRM metadata and is currently VALID. It is a low-level table-handler package (a "table API") rather than a public business API, and it is referenced internally by eight other packages within the IGF module, indicating it is a foundational dependency for higher-level withholding tax processing routines.

Key Procedures and Functions

The documented package exposes nine procedures and functions, which collectively form a standard Oracle Forms-style table handler:

  • INSERT_ROW — Performs the physical insert of a new COA item record into IGF_AW_COA_ITEMS.
  • LOCK_ROW — Obtains a row-level lock on an existing record, typically used when a form enters update mode, preventing concurrent modification.
  • UPDATE_ROW — Applies changes to an existing COA item record.
  • ADD_ROW — Higher-level entry point that handles adding a row, coordinating validation and insert logic before INSERT_ROW is executed.
  • DELETE_ROW — Removes an existing COA item record, subject to referential integrity checks.
  • GET_PK_FOR_VALIDATION — Returns the primary key values needed to validate a COA item row, supporting uniqueness and existence checks.
  • GET_FK_IGF_AP_FA_BASE_REC — Retrieves the foreign key reference to the IGF_AP_FA_BASE_REC parent record, verifying the linkage between the COA item and its associated base record.
  • GET_FK_IGF_AW_ITEM — Retrieves the foreign key reference to the IGF_AW_ITEM withholding tax item, validating that the COA mapping points to a legitimate item.
  • BEFORE_DML — Trigger-style procedure invoked before insert, update, or delete operations to enforce validation, defaulting, and business-rule checks.

The package also depends on standard EBS utilities, including APP_EXCEPTION, FND_GLOBAL, FND_MESSAGE, and IGS_GE_MSG_STACK, which provide error handling, session context (user, responsibility, login), message lookup, and message stacking respectively.

Tables Accessed

The primary table accessed is IGF_AW_COA_ITEMS, accessed via its APPS synonym. This table holds the persisted COA-to-withholding-item mapping records that the package inserts, locks, updates, and deletes. Read access supports the GET_PK_FOR_VALIDATION and GET_FK_* routines, which query the table (and related parent objects) to confirm key and foreign key validity before DML is committed. Additional dependencies — IGF_AP_FA_BASE_REC_PKG, IGF_AW_COA_ITM_TERMS_PKG, and IGF_AW_ITEM_PKG — indicate that the package also references associated base-record, item-terms, and item definition packages to validate cross-entity relationships during BEFORE_DML processing.

Usage Notes

IGF_AW_COA_ITEMS_PKG is typically invoked indirectly rather than called directly by end users. In Oracle EBS, packages of this shape are most often called from Oracle Forms-based setup screens (for example, withholding tax COA item maintenance forms) through the standard table-handler pattern: LOCK_ROW on query/update, ADD_ROW/INSERT_ROW on create, UPDATE_ROW on modify, and DELETE_ROW on removal. BEFORE_DML runs automatically ahead of each DML operation. Because the metadata records that the package is referenced by eight other packages and is not itself referenced by any database object at the top level, it functions as an internal dependency of the IGF withholding tax subsystem. Custom code, concurrent programs, or integrations that need to maintain COA item mappings should call this package rather than performing direct DML on IGF_AW_COA_ITEMS, so that validation, locking, and error-handling conventions are preserved across both 12.1.1 and 12.2.2 environments.