Search Results igi_dos_dynamic

Overview

IGI_DOS_DYNAMIC is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its name and internal structure indicate that it belongs to the IGI (Oracle Financials for Government / Public Sector) product family, specifically the DOS (Desktop Operating System, sometimes rendered as Document Operating System) subsystem. The package functions as a dynamic view generation utility. Rather than performing transactional business logic directly, its purpose is to construct database views on demand at runtime, based on caller-supplied parameters.

The central theme of the package is the creation of account views. Two distinct view types are supported: source accounts and destination accounts. In government and public sector accounting flows, source accounts typically represent the originating funding or expenditure account, while destination accounts represent the receiving or target account. The package exposes functions that return a view definition or view name as a VARCHAR2 result, allowing the calling program to reference the dynamically created view by name.

Key Procedures and Functions

The package body documents two public functions.

• CREATE_SOURCE_ACCOUNTS_VIEW — Accepts a chart of accounts identifier (p_coa_id) and is intended to create or return a view representing source account information for that chart of accounts. In the version documented in the ETRM excerpt, the function body simply returns NULL, indicating that this is a stub implementation intended for extension by localization or implementation-specific code.
• CREATE_DEST_ACCOUNTS_VIEW — Accepts a chart of accounts identifier (p_coa_id) and is intended to create or return a view representing destination account information for that chart of accounts. As with the source variant, the documented body returns NULL and serves as a placeholder.

Both functions follow the same signature pattern: a single numeric parameter identifying the chart of accounts and a VARCHAR2 return value. This symmetry suggests they are designed to be called in pairs.

Tables Accessed

The ETRM metadata lists no tables referenced via APPS synonyms for this package. This is consistent with the stub implementation shown in the source excerpt, where neither function performs a query against any base table. In a full, extended implementation, these functions would be expected to reference chart-of-accounts structures such as GL_CODE_COMBINATIONS, FND_ID_FLEX_STRUCTURES, and related key flexfield definition tables in order to build a valid account view for the specified chart of accounts.

Usage Notes

Because the package is classified as OTHER and is referenced by zero other packages in the documented metadata, it is not a standard dependency of any shipped Oracle EBS concurrent program, form, or API. Its invocation is most likely driven by custom or localization code, particularly implementations that require dynamic generation of account views tailored to a specific chart of accounts.

The presence of identical stub functions for source and destination accounts indicates that IGI_DOS_DYNAMIC is a template or framework package. Customers and partners are expected to extend the package body with implementation-specific logic. Developers integrating with this package should call CREATE_SOURCE_ACCOUNTS_VIEW and CREATE_DEST_ACCOUNTS_VIEW after establishing the chart of accounts context, and should be aware that the out-of-the-box behavior returns NULL. Any deployment relying on actual view creation must therefore supply its own extension logic.