Search Results ece_output_runs_s




Overview
Explore in AI Chat

Overview

The APPS.IGW_EDI_PROCESSING package body is a server-side PL/SQL component that belongs to the Oracle Grants Management (IGW) product family within Oracle E-Business Suite. Its primary business function is to support the exchange of electronic business documents related to grants and proposals by integrating the Grants schema with the Electronic Commerce/EDI infrastructure. This integration spans the 12.1.1 and 12.2.2 releases of EBS, where the object retains a VALID status in the APPS schema.

The package is classified under the generic OTHER API category in the ETRM registry, indicating that it is an internal helper package rather than a formally published public API. It bridges grant-management entities — budgets, proposals, proposal abstracts, and report processing — with the EDI output-run mechanism, allowing grant-related data to participate in outbound electronic document generation and status tracking.

Key Procedures and Functions

The ETRM metadata documents two named program units within this package body:

  • SUBMIT — Orchestrates the submission of grant-related EDI processing activity. It is the entry point through which callers initiate an EDI output run or processing cycle tied to grant documents, coordinating the supporting data structures and error handling required to hand document data to the EDI layer.
  • UPDATE_EDI_DATE — Maintains the EDI-related date attributes associated with grant records. This routine updates the tracking dates that record when EDI processing occurred, providing the audit and reconciliation timestamps used by downstream reporting and by the output-run bookkeeping.

Both procedures rely on the standard Oracle Application Object Library utilities, including FND_API for the common API programming model and FND_MSG_PUB for message-stack handling, which govern how success, warning, and error conditions are surfaced to calling applications.

Tables Accessed

The package body touches the following documented objects:

  • ECE_OUTPUT_RUNS_S — the EDI output runs sequence, used to generate unique run identifiers for each EDI processing execution. This is the object most directly associated with the searched term ece_output_runs_s.
  • IGW_BUDGETS — grant budget records whose document content may be routed through EDI output processing.
  • IGW_PROPOSALS_ALL — the base grants proposal table, holding the primary proposal header information.
  • IGW_PROP_ABSTRACTS — proposal abstract text that forms part of the transmitted grant document.
  • EC_DOCUMENT and DUAL — supporting EDI document references and single-row utility queries.

Additional internal dependencies include IGW_REPORT_PROCESSING, which handles reporting-side processing for grant data.

Usage Notes

Because IGW_EDI_PROCESSING is not referenced by any other database object and is classified as an OTHER API, it is not invoked through a widely published dependency chain. Instead it is typically called from Oracle Grants Management concurrent programs, from workflow-driven EDI submission logic, or from custom PL/SQL extensions that need to trigger outbound grant document exchange. Implementers integrating grants with EDI should treat this package as an internal supporting routine: direct calls should be validated against the specific 12.1.1 or 12.2.2 patch level in use, and error handling should inspect the FND_MSG_PUB message stack after each invocation. Its dependence on ECE_OUTPUT_RUNS_S makes it relevant when diagnosing output-run sequencing or duplicate-run issues in the EDI subsystem.