Search Results inv_globals




Overview
Explore in AI Chat

Overview

INV_GLOBALS is a utility package body in the APPS schema that supplies shared, session-level services for Oracle Inventory and the broader supply chain modules in Oracle E-Business Suite 12.1.1 and 12.2.2. Rather than implementing a single business transaction, it centralizes the global variables, profile lookups, organization and ledger context, and control-rule evaluations that many Inventory APIs and forms require before they can execute. The package is classified as OTHER in the ETRM repository, reflecting its role as internal infrastructure rather than a public integration API.

The package carries a VALID status and depends on FND_API, FND_MESSAGE, FND_MSG_PUB, FND_PROFILE, GL_SETS_OF_BOOKS, HR_ORGANIZATION_INFORMATION, and the PL/SQL table type PLITBLM, confirming that it is tightly coupled to the Oracle Application Object Library and to Human Resources organization data. It is documented as referenced by 123 other packages, which establishes it as a foundational component within the Inventory code base.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions. Their purposes are:

  • GET_ENTITIES_TBL — returns a PL/SQL table of entities, used to populate multi-row processing structures from calling code.
  • IS_ISSUE_XFR_TRANSACTION — evaluates whether a given transaction represents an issue or transfer, allowing callers to branch transaction logic accordingly.
  • INIT_CONTROL_REC — initializes the control record that governs Inventory control-rule behavior for the session or organization.
  • EQUAL — a comparison utility used to test equality of values within the package's internal logic.
  • SET_ORG_ID — establishes the current inventory organization context identifier.
  • SET_PJM_ORG_ID — establishes the organization identifier in the Project Manufacturing (PJM) context.
  • NO_NEG_ALLOWED — returns whether negative balances or quantities are prohibited under the prevailing control settings.
  • LOCATOR_CONTROL — returns the locator control setting that determines whether locators are required, optional, or disallowed.
  • GET_LEDGER_INFO — retrieves ledger information, typically the set of books or ledger associated with the operating context.

The remaining documented entry points follow the same pattern of context initialization and control-rule interrogation.

Tables Accessed

Two tables are documented as referenced through APPS synonyms. HR_ORGANIZATION_INFORMATION supplies organization classification and attribute data, which the package uses to resolve legal entities, operating units, and inventory organizations, and to populate the PJM organization context. PLITBLM is the standard Oracle PL/SQL table type used for passing and storing list values in memory; it appears here as an in-memory structure rather than a physical application table. Ledger-related information is obtained through GL_SETS_OF_BOOKS, which the package queries to resolve accounting context for Inventory transactions.

Usage Notes

INV_GLOBALS is typically invoked implicitly. Inventory forms and concurrent programs call its initialization routines at the start of processing to set organization and ledger context, then consult its control functions such as NO_NEG_ALLOWED and LOCATOR_CONTROL before permitting a transaction. Because the package is not referenced by any database object and is not a published interface, custom code should treat it as an internal dependency. Direct invocation is possible from custom PL/SQL, but developers should expect signature and behavior changes across releases and should prefer documented public APIs where one exists. In 12.1.1 and 12.2.2 environments, the package should be expected in any execution path that depends on Inventory organization or locator control settings.