Search Results get_functional_currency

Overview

IGIRGLOBE is a PL/SQL package in the APPS schema that supports global configuration and reference data provisioning for the Oracle E-Business Suite financials and receivables-adjacent components known as IGI (Interactive Gulf / regional localization utilities). Its principal business role is to seed, refresh, and expose environment-wide system options and Receivables Transaction Flexfield (RPI Flex) definitions so that downstream modules operate against correctly configured functional currency, set-of-books, and descriptive flexfield structures.

The package is classified under the ETRM as API classification OTHER, indicating it is an internal utility rather than a public or customer-facing API. It is not referenced by any other documented package, so it is normally called by concurrent programs, forms, or setup routines rather than through cross-package dependencies.

Key Procedures and Functions

• Get_functional_currency — Returns the functional currency of the operating environment as a VARCHAR2 value, allowing callers to align calculations and defaults with the ledger currency.
• Get_functional_sob_name — Returns the name of the functional set of books (SOB), exposing the accounting book identity associated with the current environment.
• PopulateSystemOptions — Populates the IGI system options tables from the standard Oracle Receivables system parameters, effectively mirroring core setup values into the IGI localization options structures.
• PopulateRPIFlexforCurrSOb — Builds the RPI (Receivables Periodic Invoicing) Flexfield configuration scoped to the current set of books, ensuring the descriptive flexfield segments resolve against the correct SOB context.
• PopulateRPIFlex — Establishes the header-level and line-level transaction context mappings used by the RPI Flexfield, accepting default contexts and identifiers such as header/line transaction context, standing charge identifiers, generate sequence, standing charge line number, price break number, and language code. Defaults target the PERIODICS context.
• PopulateExtendedData — A concurrent-program style entry point that accepts standard errbuf/retcode out parameters plus a source indicator and commit flag, driving the extended data population process.

Tables Accessed

• AR_SYSTEM_PARAMETERS / AR_SYSTEM_PARAMETERS_ALL — The standard Receivables system parameter tables, read as the authoritative source for organization-level options that are then reflected into IGI-specific options.
• IGI_AR_SYSTEM_OPTIONS / IGI_AR_SYSTEM_OPTIONS_ALL — The IGI localization option tables that this package writes to maintain region-specific system configuration synchronized with the core Receivables parameters.

Usage Notes

IGIRGLOBE is typically invoked during initial setup and after changes to Receivables system parameters, when the IGI-specific options and RPI Flexfield structures must be synchronized with the current set of books and functional currency. The PopulateExtendedData procedure follows the Oracle concurrent program calling convention with errbuf and retcode parameters, so it is most naturally executed as a concurrent program step or host script. The remaining procedures and functions are generally called from forms, setup routines, or custom code that needs to resolve the functional currency, set-of-books name, or RPI Flexfield configuration at runtime.

Because the package is internal and undocumented externally, customizations should treat it as version-sensitive. References should be limited to read-oriented calls such as the two getter functions where possible; write-oriented procedures should be invoked only through the delivered setup flows to avoid configuration drift between AR and IGI option tables.