Search Results get_constant

Overview

AS_FOUNDATION_PUB is a public utility API belonging to the Oracle E-Business Suite Order Settlement / Order Management Foundation layer (the AS product schema, associated with Oracle Sales and order settlement functionality). Its header comment states its purpose concisely: "This package is a public utility API for OSM." It exposes reusable helper routines that other Oracle modules — and customer extensions — can call to resolve reference data, retrieve inventory item structures, calculate monetary amounts, and obtain period names without duplicating lookup logic.

The package was originally created in August 1998 and has been maintained through several enhancement cycles (notably the addition of Get_Constant in September 1998 and get_periodNames in June 1999). The version stamp in the source header (120.1, dated 2005) indicates the package has been stable for a considerable period, which is typical of foundation-level utility code. Its API classification is PUB, meaning it is a supported, externally callable interface rather than an internal-only implementation module.

Key Procedures and Functions

The ETRM metadata documents four public routines:

• GET_INVENTORY_ITEMS — Returns inventory item information for a given organization context. The composite record definition in the package body lists attributes such as inventory_item_id, organization_id, concatenated_segments, description, enabled_flag, inventory_item_flag, item_catalog_group_id, collateral_flag, Primary_UOM_Code, Primary_Unit_of_Measure, inventory_item_status_code, product_family_item_id, and bom_item_type. This makes the routine suitable for callers needing an item's descriptive and structural attributes in a single call.
• GET_CONSTANT — The function most relevant to the search that surfaced this object. It resolves a constant value from a lookup table, allowing callers to avoid hard-coding literal values. This is the routine added in the September 1998 revision.
• CALCULATE_AMOUNT — Performs a monetary or numeric calculation used in order settlement contexts.
• GET_PERIODNAMES — Returns period names, added in the June 1999 revision, enabling callers to resolve accounting or reporting period labels programmatically.

Package-level constants also declare standard lookup views available to callers: AS_LOOKUPS, AR_LOOKUPS, HR_LOOKUPS, FND_COMMON_LOOKUPS, and CS_LOOKUPS.

Tables Accessed

The ETRM metadata does not list explicit table references for this package. Based on its documented behavior, GET_CONSTANT and related routines read from the lookup tables named in the package constants (notably AS_LOOKUPS and FND_COMMON_LOOKUPS via the FND_LOOKUPS view), while GET_INVENTORY_ITEMS resolves item attributes from Oracle Inventory item master and item catalog structures. Consumers should treat these as read-only reference accesses.

Usage Notes

Because this is a foundation utility with PUB classification, it is typically invoked from custom PL/SQL that needs lookup resolution or item attribute retrieval without direct table access. Two other packages in the EBS instance reference AS_FOUNDATION_PUB, confirming its role as a shared dependency. Typical invocation contexts include concurrent program logic, order settlement processing, and custom extensions built on the OSM foundation layer. Standard practice is to call the package through its APPS synonym, relying on the wrapper constants for lookup names rather than embedding schema-specific names.