Search Results products_enabled

Overview

IGI_GEN_VERT is a general-purpose utility package in the Oracle EBS Financials product family (IGI application). Its name reflects its role as a central "gate-keeper" or verification layer for the IGI suite: the package determines which IGI products and sub-features are installed and enabled before downstream logic attempts to execute them. The source header comment identifies the file as igigccbs.pls and shows it declares an extensive block of global variables that are consumed by the companion package IGILUTIL2, covering flags such as CBC, CC, CIS, DOS, EXP, IAC, MHC, SIA, and STP. A specific global, IGI_IGILUTIL2_EXP, aligns with the user's search term "igi_exp" and illustrates the package's role as a product-flag cache.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema, and it includes a PRAGMA RESTRICT_REFERENCES(is_req_installed, WNDS) to guarantee that the function performs no database writes — an important property for functions called from SQL. Given IGI's placement within the Financials stack, this package is a foundational dependency that many IGI forms and reports consult at runtime.

Key Procedures and Functions

• IS_REQ_INSTALLED — Determines whether a named requirement (product option) is installed. Overloaded to accept an optional organization identifier for Multi-Org Access Control (MOAC) environments, returning either a BOOLEAN or a VARCHAR2 depending on the signature.
• GET_OPTION_STATUS — Returns the status flag and error number for a given option name, providing a programmatic way to interrogate enabled/disabled state.
• DEBUG — Write diagnostic information to aid troubleshooting of package logic.
• GET_LOOKUP_MEANING — Resolves a lookup type to its descriptive meaning, standardising code/value translation across IGI modules.
• IGI_EFC_CHECK_OPTIONS — Validates EFC (Enterprise Financial Consolidation) options against a given set of books, returning the applicable option code.
• GET_AP_SOB_ID / GET_AR_SOB_ID / GET_PO_SOB_ID — Return the set-of-books identifiers for Payables, Receivables, and Purchasing respectively, commonly used for cross-module SOB reconciliation.
• IGIINSTALLED — Indicates whether the IGI application itself is installed.
• CACHEPRODUCTOPTIONS — Populates the global product-option variables so that repeated checks are cheap.
• PRODUCTENABLED — Returns whether a specific product, identified by name, is enabled.
• PRODUCTS_ENABLED — Returns the enabled state of multiple IGI products in a single call through OUT parameters.

Tables Accessed

• AP_SYSTEM_PARAMETERS, AR_SYSTEM_PARAMETERS, and FINANCIALS_SYSTEM_PARAMETERS — read to determine the set-of-books identifiers and installed/operating configuration for the Payables, Receivables, and shared Financials environments.
• PSA_EFC_OPTIONS — read to validate EFC option availability when IGI_EFC_CHECK_OPTIONS executes.

All access is read-only, consistent with the WNDS restriction declared on IS_REQ_INSTALLED.

Usage Notes

IGI_GEN_VERT is not documented as being referenced by any other package, so it is primarily invoked directly from Oracle Forms, concurrent programs, and custom extensions that need to guard IGI functionality. The typical pattern is to call CACHEPRODUCTOPTIONS once at the start of a session or program to populate the global flags, then call PRODUCTENABLED or IS_REQ_INSTALLED for individual checks. Because the package is AUTHID CURRENT_USER and relies on APPS synonyms for its tables, callers must ensure the appropriate roles and synonyms are granted. The EXP flag (IGI_IGILUTIL2_EXP) is read by IGILUTIL2, so any custom code that toggles or inspects the expiry/expense-related feature should reference the global rather than re-querying the base tables.