Search Results initialize_view

Overview

IGC_CC_VERSION_VIEW_PKG is a small utility package in the Oracle EBS Applications (APPS) schema that supports the Contract Commitment (IGC) product family — the module historically associated with Oracle Grants Management and its award/contract commitment processing. The package implements a session-scoped mechanism for tracking the "version number" of a database view that underlies the contract commitment user interface. Rather than persisting this value in a table, the package relies on a package-level global variable, g_version_num, which is set by an explicit initializer and subsequently read by any dependent code.

The business purpose is straightforward: the contract commitment forms and their supporting logic need to know which version of the view definition is currently in effect, so that dependent behavior (query construction, display, validation, or caching decisions) can adapt to the installed view version. This is a lightweight runtime contract between the form layer and the database view, not a data-processing routine. It contains no DML, no table access, and no business validation logic.

Key Procedures and Functions

• Initialize_View — This procedure accepts a version number and assigns it to the package global variable. It is the single entry point through which callers establish the active view version for the current database session. Because the value is held in a package global, the initialization applies only for the life of that session; a new session must call Initialize_View again before Get_Version_Num will return a meaningful value.
• Get_Version_Num — This function returns the NUMBER value currently held in the package global variable. It is the read-side accessor, allowing forms, concurrent programs, and other PL/SQL units to retrieve the view version that was previously initialized. If Initialize_View has not been invoked in the session, the function returns NULL, since the global variable is initialized to NULL by default at package instantiation.

Both routines are public and documented. The package does not expose any overloads, exceptions, or additional internal helpers beyond the package global itself.

Tables Accessed

No tables are referenced by this package. The ETRM metadata lists no APPS synonyms consumed by IGC_CC_VERSION_VIEW_PKG, and the source confirms that strictly PL/SQL variables are used. The package therefore performs no SQL reads or writes and requires no table-level privileges. Any association with contract commitment view objects is indirect: the package simply stores a numeric version identifier that other components compare against view metadata they query themselves.

Usage Notes

This package is a support utility rather than a user-facing API. It is typically invoked from the contract commitment form layer or from PL/SQL code that needs to coordinate with the contract commitment view definition. The documented signature calls are:

• IGC_CC_VERSION_VIEW_PKG.Initialize_View(p_version_num => <n>);
• v_num := IGC_CC_VERSION_VIEW_PKG.Get_Version_Num;

Because the stored value is session-scoped, callers must invoke Initialize_View during form or session initialization, before any call to Get_Version_Num. The ETRM metadata indicates that four other packages reference IGC_CC_VERSION_VIEW_PKG, which suggests it is embedded in the dependency chain of the contract commitment UI and its supporting packages. The header revision (120.2.12000000.1, dated 2007) indicates this is a stable, legacy component that has carried forward across EBS 12.1.1 and 12.2.2 without structural change. Customizations should avoid hard-coding returned version values; instead, resolve them at runtime through Get_Version_Num to remain compatible across environments.