Search Results update_period

Overview

IGIOCERL is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM API classification "OTHER." Its name follows the IGI prefix convention associated with the former Oracle Grants Accounting / Oracle Financials for government and education product family, indicating the package belongs to an IGI-branded subsystem rather than a core Oracle Purchasing or Payables module. The package body is intentionally minimal: the source header dates to 2003 (igicecdb.pls 115.8) and the only executable content is a single procedure whose body resolves to a NULL statement.

From a business-function standpoint the package occupies a placeholder or stub role. Procedures such as UPDATE_PERIOD exist so that calling code, configuration, or dependent objects can reference a stable API signature while the substantive logic is either performed elsewhere or was never implemented in this version. The "ERL" suffix in the package name suggests a relationship to error-handling or release-related processing, but the metadata provides no confirmation of that interpretation and no additional behavior.

Key Procedures and Functions

The ETRM metadata documents exactly one procedure for this package:

• UPDATE_PERIOD — The sole documented entry point. Its declared parameter list includes an OUT NOCOPY error-code parameter (x_cec_errcode) and IN parameters bound to PO_DISTRIBUTIONS.PO_RELEASE_ID%TYPE and PO_DISTRIBUTIONS.PO_HEADER_ID%TYPE, identifying the Purchasing distribution context by release and header. Despite this signature, the procedure body consists of a single NULL statement, so no period update logic is executed when it is called.

Because the procedure returns only an error code and performs no work, callers receive a successful (or at least non-failing) response with no side effects on period data. No other procedures or functions are documented for this package body.

Tables Accessed

The documented table reference is PO_DISTRIBUTIONS, accessed through APPS synonyms. This table stores the accounting distributions generated for purchase order shipments and releases, and the UPDATE_PERIOD parameters are anchored to its PO_RELEASE_ID and PO_HEADER_ID columns. In practice, an "update period" routine on this table would reassign the accounting period or GL date on distribution rows, typically to correct a period that has been closed or to align charges with the intended accounting calendar. Given that the procedure body is NULL, no read or write of PO_DISTRIBUTIONS is actually performed by this implementation; the table is referenced only for its column data types in the parameter declarations.

Usage Notes

Because UPDATE_PERIOD is effectively a no-op, calling it from a form, concurrent program, or custom script will validate the caller's parameter values against the Purchasing distribution data types and return without altering any period information. Any customization or extension that expects this package to shift distribution periods must therefore supply its own logic or invoke an alternative API.

The ETRM metadata records that IGIOCERL is not referenced by any other package, which limits its reachability through standard dependency chains. It is most likely encountered through direct invocation from IGI-branded forms or concurrent requests, or through legacy custom code preserved during upgrades from earlier releases. Before relying on it in a 12.1.1 or 12.2.2 environment, customers should verify the deployed source, since a stub package may have been superseded by an implemented routine in a later patch or by a supported Oracle Purchasing API for distribution and period adjustments. There is no documented error-code contract beyond the OUT parameter itself, and no documented exceptions or commit behavior.