Search Results pos_get




Overview
Explore in AI Chat

Overview

The APPS.POS_GET package body is a shared PL/SQL utility package within the Oracle E-Business Suite Applications (APPS) schema. Its name and documented procedures indicate that it provides centralized "getter" or lookup functionality for commonly requested reference values across Oracle Procurement and related modules. In EBS 12.1.1 and 12.2.2, packages of this class are not tied to a single transactional workflow; instead they act as reusable helpers that other packages, forms, and concurrent programs call to resolve human-readable descriptions, flexfield segment values, and derived amounts from key identifiers.

Because POS_GET is documented with 18 dependent packages referencing it, it occupies a foundational position in the dependency chain. It consolidates lookups that would otherwise be duplicated, ensuring consistent interpretation of person names, item identifiers, GL account combinations, and change amounts. The package is classified as an OTHER API within the ETRM documentation, and its object status is VALID in the APPS schema.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions. Each serves a distinct lookup or derivation purpose:

  • GET_PERSON_NAME — Resolves a person identifier to that person's display name, drawing on the PER_ALL_PEOPLE_F/PER_PEOPLE_F hierarchy.
  • GET_PERSON_NAME_CACHE — A cached variant of the person name lookup, reducing repeated queries against the person tables within a session.
  • ITEM_FLEX_SEG — Returns a specific key flexfield segment for an item, supporting structured item description or classification value retrieval.
  • GET_GL_ACCOUNT — Retrieves the full General Ledger account (code combination) for a given identifier, resolving against the GL code combinations key flexfield view.
  • GET_GL_VALUE — Obtains an individual GL segment value or description associated with an account combination.
  • GET_ITEM_CONFIG — Returns configuration information for a configured item, relevant to procurement of configurable goods.
  • GET_ITEM_NUMBER — Resolves an internal item identifier to the user-facing item number.
  • GET_CHANGED_AMOUNT — Calculates the difference or changed amount between two monetary values, typically for change-order or amendment processing.
  • GET_CHG_AMT_EXCL_OPT — Computes change amounts excluding optional line components, refining the amount calculation used in modification workflows.

Parameter lists are not documented in the ETRM excerpt and are deliberately not reproduced here.

Tables Accessed

The documented dependency list identifies two principal base views accessed via APPS synonyms:

  • MTL_SYSTEM_ITEMS_KFV — The key flexfield view of inventory items, used by the item-number, flex-segment, and configuration functions to resolve item attributes and descriptions.
  • PER_ALL_PEOPLE_F — The date-effective people table, used by the person-name functions to retrieve current person records.

The package also depends on GL_CODE_COMBINATIONS_KFV for GL account and value lookups, FND_FLEX_APIS for flexfield processing, and STANDARD/DUAL for generic PL/SQL operations. These dependencies confirm that POS_GET performs read-only reference lookups rather than transactional writes.

Usage Notes

POS_GET is normally invoked indirectly. Because it is referenced by 18 other packages, it is typically called from within higher-level Procurement APIs and internal package logic rather than being executed directly by end users. It may also be called from Oracle Forms customizations or concurrent-program PL/SQL that need consistent resolution of item numbers, person names, GL accounts, or change amounts. The package is not referenced by any database object (such as a trigger or view), which reinforces its role as a callable utility layer rather than an event-driven component. Custom code should call the documented functions instead of reimplementing equivalent joins against MTL_SYSTEM_ITEMS_KFV, PER_ALL_PEOPLE_F, or GL_CODE_COMBINATIONS_KFV, to preserve consistency with Oracle's standard logic.