Search Results get_pdh_srcsys_code

Overview

APPS.BOM_COMMON_DEFINITIONS is a Bill of Materials (BOM) utility package body residing in the Oracle E-Business Suite Applications schema. Its documented purpose is to centralize shared constants, global variables, and lightweight accessor functions used across the Oracle Bills of Material and Oracle Engineering product families. The package is classified as OTHER in the ETRM repository, indicating that it is not a public, installable API but rather an internal helper unit consumed by other BOM-related packages and forms.

The body is a single, compact unit (approximately 27 lines, identified by the header revision $Header: BOMCONSB.pls 120.1 2005/08/15). It exposes two public functions whose sole responsibility is to return the current value of package-level global variables. This pattern allows dependent PL/SQL units to read session- or call-scoped configuration values without directly referencing the global variables, preserving encapsulation and providing a stable callable interface even if the underlying variable definitions change.

Key Procedures and Functions

• GET_INITIAL_SORT_CODE — Returns a VARCHAR2 value representing the initial sort code used within BOM processing. It reads and returns the package global G_Bom_Init_SortCode. Callers use this to obtain the default ordering/sequencing indicator applied when BOM structures are processed or displayed.
• GET_PDH_SRCSYS_CODE — Returns a NUMBER value corresponding to the PDH (Product Data Hub) source system identifier. It reads and returns the package global G_BOM_PDH_SRCSYS_ID. The existence of this function reflects the integration between Oracle Bills of Material and the Product Data Hub / Product Information Management source-system framework, where a numeric source system code is required to identify the origin of BOM data during import, synchronization, or publication operations.

No parameter lists are documented for either function; both are parameterless scalar getters, consistent with the source excerpt provided in the ETRM metadata.

Tables Accessed

The documented table reference associated with this package is BOM_EXPLOSIONS, accessed through an APPS synonym. BOM_EXPLOSIONS is the central BOM explosion engine table, storing the recursively resolved structure of assemblies, components, quantities, and effectivity information. Although the published body of BOM_COMMON_DEFINITIONS itself performs no explicit SQL against this table, the documented lineage indicates that the package participates in, or is invoked within, the BOM explosion processing path. Its global variables — notably the initial sort code and PDH source system identifier — are consumed by the routines that read and interpret BOM_EXPLOSIONS rows.

Usage Notes

BOM_COMMON_DEFINITIONS is referenced by 17 other packages according to the ETRM metadata, confirming its role as a widely shared internal utility. It is typically invoked from within BOM explosion and Product Data Hub integration logic rather than directly from a form or concurrent program. Developers writing custom code against Oracle BOM should treat these functions as read-only informational accessors: GET_PDH_SRCSYS_CODE is useful when custom logic must determine the active PDH source system for a BOM transaction, and GET_INITIAL_SORT_CODE when the standard sort behaviour must be replicated. Because the values are held in package globals, the returned results reflect the state established by the calling session and must not be cached across sessions or assumed to be immutable. Direct modification of the underlying globals is not supported, and the functions should not be used as substitutes for the public BOM APIs.