Search Results igi_efc_check_options

Overview

IGI_GEN is a general-purpose utility package in the Oracle E-Business Suite Applications (APPS) schema. In the ETRM 12.2.2 metadata it is classified as an OTHER API, and it is documented as being referenced by 62 other packages, which confirms its role as a shared, low-level service layer rather than a business-facing API. The package provides common helper routines used throughout the IGI (Oracle Financials for Government / global accounting) product family, including installation checks, profile-style option status lookups, debugging output, system parameter retrieval, and lookup value resolution. Because it is a utility package, it does not implement a single business transaction; instead it centralizes frequently reused logic so that dependent packages and forms can avoid duplicating configuration and environment queries.

Key Procedures and Functions

• IS_REQ_INSTALLED — Overloaded function that determines whether a required option or module is installed. One signature accepts an option name and organization identifier, and the other accepts only the option name and returns a BOOLEAN (the variant modified for Multi-Org Access Control uptake). The RESTRICT_REFERENCES pragma (WNDS) is applied.
• GET_OPTION_STATUS — Procedure that returns the status flag for a named option together with an error number, providing a standardized way to query configuration state.
• DEBUG — Procedure that writes diagnostic information (module, module variable, variable value, and message) for troubleshooting. It is the package's internal logging utility.
• GET_LOOKUP_MEANING — Function that returns the meaning for a supplied lookup type.
• IGI_EFC_CHECK_OPTIONS — Procedure that validates the set-of-books context against Electronic Funds Capture options, returning status through an IN OUT parameter.
• GET_AP_SOB_ID, GET_AR_SOB_ID, GET_PO_SOB_ID — Functions that each return the set-of-books identifier for the Payables, Receivables, and Purchasing applications respectively.
• GET_IGI_PROMPT — Function that returns the prompt text associated with a lookup code.
• GET_IGI_WINDOW_TITLE — Function that returns the responsibility-based window title, used to tailor form captions for the signed-in user.

Tables Accessed

All documented table access is through APPS synonyms. The package reads AP_SYSTEM_PARAMETERS, AR_SYSTEM_PARAMETERS, and FINANCIALS_SYSTEM_PARAMETERS to resolve application-level and set-of-books configuration — this underpins the GET_AP_SOB_ID, GET_AR_SOB_ID, and GET_PO_SOB_ID functions. IGI_GCC_INST_OPTIONS_ALL and PSA_EFC_OPTIONS supply IGI install and Electronic Funds Capture options used by IS_REQ_INSTALLED and IGI_EFC_CHECK_OPTIONS. The metadata does not indicate write operations, consistent with a predominantly read-only utility role.

Usage Notes

IGI_GEN is typically invoked indirectly. Dependent packages (62 documented) call it to check installation state, fetch set-of-books identifiers, or resolve lookup meanings before executing their own logic. Oracle Forms within the IGI module call GET_IGI_WINDOW_TITLE and GET_IGI_PROMPT to render user-facing captions. The MOAC-aware overload of IS_REQ_INSTALLED should be used in environments where organization-level access control is enabled. Because the package references system parameter tables, callers should be aware of initialization ordering and caching implications. Custom code should call these routines rather than querying the underlying tables directly, preserving supportability across EBS 12.1.1 and 12.2.2.