Results for “set_application_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BOM_SET_CONTEXT is a utility package in the Oracle E-Business Suite Applications (APPS) schema that establishes session-level context for Oracle Bills of Material processing. Its principal business function is to configure the runtime environment so that downstream Bill of Materials logic resolves the correct structure type and application identity for the duration of a session. Because Oracle EBS maintains many of its core configuration values as session state rather than as explicit parameters, packages such as BOM_SET_CONTEXT serve as the initialization layer that other BOM programs depend upon.

The package body is documented as VALID and is classified under the API classification OTHER, indicating that it is an internal support package rather than a public, business-facing API. Its tightly scoped procedure set—three documented entry points—confirms that its role is narrowly focused on context establishment rather than on business transactions.

Key Procedures and Functions

The documented procedures for this package are:

• SET_STRUCT_TYPE_CONTEXT — Establishes the Bill of Materials structure type context for the session. This is the central routine of the package, allowing calling programs to declare which structure type (for example, manufacturing or engineering) governs subsequent BOM processing.
• SET_APPLICATION_ID — Sets the Oracle Application identifier context for the session. This ensures that application-specific behavior and any dependent lookups resolve against the correct product application.
• Additional context routine — The metadata documents three procedures in total; the third routine continues the package's context-setting theme and is used in conjunction with the two named above.

No parameter lists are documented; the procedures should be treated strictly by name and purpose, not by assumed signatures.

Tables Accessed

The package references the following objects, largely through APPS synonyms:

• BOM_STRUCTURE_TYPES_B — The base table that stores Bill of Materials structure type definitions. It is the primary data source consulted when establishing the structure type context, validating that the requested structure type is a recognized value.
• DBMS_SESSION — The standard Oracle-supplied package used to set and clear session-level attributes. BOM_SET_CONTEXT relies on it to persist context values across the session, which is the mechanism by which the context remains available to subsequent calls.
• DUAL — Referenced for simple single-row evaluations, a common pattern in context-setting code.

Additional dependencies include FND_GLOBAL, the EBS foundation package used for managing application and session globals, and the STANDARD package supplied by the database. The metadata does not indicate that the package writes business data to any table; its reads against BOM_STRUCTURE_TYPES_B are for validation and lookup purposes.

Usage Notes

BOM_SET_CONTEXT is typically invoked at the start of a processing sequence, before any Bill of Materials structure query or update is performed. In Oracle EBS 12.1.1 and 12.2.2, this pattern is common in concurrent programs, forms-based logic, and custom PL/SQL that must guarantee the correct structure type and application identity are in force.

Because the package is documented as not referenced by any database object, it is not automatically triggered by database-level dependencies; it must be called explicitly. The metadata records that the package is referenced by two other packages, indicating it is used as a shared prerequisite by other BOM-related modules. Custom code should call the relevant context procedures rather than manipulating session values directly, and should be aware that context established in this manner persists for the session and may affect subsequent operations.