Search Results igf_ap_lg_coa_imp




Overview
Explore in AI Chat

Overview

IGF_AP_LG_COA_IMP is an Oracle EBS PL/SQL package owned by the APPS schema. It belongs to the Oracle iGovernment (IGF) product family and supports the Grants Accounting and Federal financials flows, specifically those related to award letter-of-credit (LOC) and Chart of Accounts (COA) processing. In Oracle EBS 12.1.1 and 12.2.2, the package is classified under the ETRM API classification of "OTHER," meaning it is not an externally published Open Interface or public API and is generally intended for internal consumption by the IGF application logic. The package is documented as VALID in the ETRM repository, confirming that its compiled state exists in the APPS schema at the time of documentation.

The primary mission of the package is the importation and validation of Chart of Accounts data associated with letter-of-credit award transactions. It serves as a bridge between inbound COA items and underlying base records used by the iGovernment award accounting engine. This includes validation of COA item terms, item definitions, and their linkage to interim or interface tables before the data is promoted into the functional base records.

Key Procedures and Functions

The ETRM documentation records a single procedure/function entry for this package:

  • MAIN — The single documented entry point for the package. Based on the package name and its COA import context, MAIN orchestrates the import process: it reads source COA rows from the interim tables, applies validation logic, and writes the accepted records into the base record structures for subsequent LOC processing. No parameter list is documented in the ETRM metadata; consultants should inspect the package specification on the target instance before invoking it from custom code.

The package also carries a package body, indicating that additional private helpers are present in the compiled unit beyond the public specification.

Tables Accessed

The ETRM metadata lists the following tables referenced via APPS synonyms:

  • IGF_AP_FA_BASE_REC_ALL — The base record table for iGovernment award transactions. It is the principal target of the import process, holding the persistent COA-linked records used downstream by LOC processing.
  • IGF_AP_LI_BAT_INTS — The line batch interface table used to stage batches of LOC line activity prior to validation and transfer.
  • IGF_AW_COA_ITEMS — Stores Chart of Accounts item definitions associated with awards.
  • IGF_AW_COA_ITM_TERMS — Stores terms attached to COA items, such as effective dates and eligibility conditions applied during validation.
  • IGF_AW_ITEM — The general item master for iGovernment award items, providing item attributes referenced by the COA import logic.
  • IGF_AW_LI_COA_INTS — The line COA interface table, which holds staged COA rows awaiting validation and promotion into base records.
  • PLITBLM — A standard Oracle Applications PL/SQL table used for internal temporary storage of record identifiers during bulk processing.

Usage Notes

IGF_AP_LG_COA_IMP is not a public, documented Open Interface. The ETRM record shows it is referenced by zero other EBS packages and does not itself reference any other APPS packages beyond the base record table, suggesting it functions as a leaf-level utility. In practice it is invoked from the iGovernment LOC award processing flow, typically triggered by concurrent programs or internal calls after COA interface rows have been populated. Customizations that call it directly should treat the procedure signature as unsupported and confirm the compiled specification against the target instance, since signatures are not guaranteed across 12.1.1 and 12.2.2. The package does not expose formal error-handling APIs, so callers should validate results against IGF_AP_FA_BASE_REC_ALL after execution.