Search Results igc_cc_version_view_pkg




Overview
Explore in AI Chat

Overview

IGC_CC_VERSION_VIEW_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the version-view layer of the Oracle Contracts (IGC) module. Its specific domain is contract commitment (CC) version viewing, which governs how header, detail, summary, and account-line records are presented to users when multiple versions of a contract commitment exist. The package supplies the runtime logic that the IGC_CC_*_VERSION_V views rely on to determine which version number should be treated as current and to prepare view state for that version. Because it is classified as OTHER rather than as a public API, it is an internal implementation component whose behaviour is exposed indirectly through the version views that reference it. It is marked VALID in both Oracle EBS 12.1.1 and 12.2.2, and its only documented dependency is on SYS.STANDARD, indicating that it is built from standard PL/SQL constructs rather than from other application PL/SQL units or application tables directly.

Key Procedures and Functions

  • INITIALIZE_VIEW — Prepares the version view for use, establishing the state required before version-specific contract commitment data can be read. It is the entry point that the version views invoke so that downstream queries return records for the appropriate contract commitment version rather than for an unspecified or stale version.
  • GET_VERSION_NUM — Returns the version number that applies to the version view being processed. It is the function through which the IGC_CC_*_VERSION_V views determine which version of the contract commitment (header, detail, summary, or account line) is to be presented.

No additional documented procedures or functions exist in the ETRM metadata. Parameter lists are not documented and should not be assumed; the package is used exclusively through its interaction with the version views listed below.

Tables Accessed

ETRM records no tables referenced through APPS synonyms for this package. The only dependency identified is SYS.STANDARD, which reflects use of standard PL/SQL language elements. In practice, packages of this kind operate on the version-view layer rather than on base contract commitment tables directly, and any data access is expected to occur through the views that call the package. Custom code should therefore not assume that the package writes to or reads from application tables as part of its documented contract.

Usage Notes

IGC_CC_VERSION_VIEW_PKG is referenced by four documented objects: IGC_CC_ACCT_LINE_VERSION_V, IGC_CC_DET_PF_VERSION_V, IGC_CC_HEADER_VERSION_V, and IGC_CC_SMRY_PF_VERSION_V. These are the version views for account lines, detail public-framework records, headers, and summary public-framework records respectively. The package is also self-referencing. It is therefore invoked indirectly whenever a form, concurrent program, or query selects from one of those version views, which is the typical path for Oracle Contracts commitment display and processing in both release 12.1.1 and 12.2.2. Because the package is not a published API and its parameters are undocumented, direct calls from custom code are not recommended; developers seeking version information should query the version views, which encapsulate the call to GET_VERSION_NUM and the preparation performed by INITIALIZE_VIEW. Any validation of the package's continued integrity should rely on its VALID status and on the resolution of its dependent version views, since those views will fail to compile or execute correctly if the package body becomes invalid.