Search Results get_ele_desc

Overview

APPS.BOM_BOMRBOMC_XMLP_PKG is the PL/SQL package associated with the Oracle Bills of Material "Bill of Material Composition" report (internal short name BOMRBOMC), a concurrent program that produces an XML Publisher output listing BOM components for selected assemblies. The package implements the report's parameter handling, data extraction, and XML Publisher callback logic: it declares the report's bind and lexical parameters (organization, revision, explode option, explosion quantity and level, item/category range, alternate designation, ordering, planning factor flags, and precision settings), then exposes the entry points the report engine invokes before, during, and after report execution.

Because the report must flatten a multi-level bill into hierarchical rows, the package carries the classic Oracle BOM "exploder" logic. The EXPLODER_USEREXIT procedure is the callback named by the concurrent program definition and is the anchor point most commonly searched for under the term "exploder_userexit". It performs the multi-level explosion of the selected assembly, respects the implosion/planning-factor flags and the requested number of levels, and populates the temporary structures consumed by the report's XML data model. The package header is $Header: BOMRBOMCS.pls 120.0 2007/12/24, indicating a long-lived object carried forward unchanged into the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

• G_FILTER — Returns a boolean used to control whether processing continues for a given report context; acts as a guard for the report's filtering logic.
• GET_REV — Returns the revision of a component item for a given component organization and component item identifier. Populates the revision displayed beside each component row.
• BEFOREREPORT — Standard XML Publisher before-report trigger. Initializes report state, derives organization name and other display values, and sets up the flexfield and category context required by the query.
• GET_ELE_DESC — Returns the description of a descriptive element for a given BOM item type, element name, and item catalog group. Used to render descriptive element values in the report output.
• AFTERREPORT — Standard XML Publisher after-report trigger; performs cleanup and return-status handling at the conclusion of report execution.
• EXPLODER_USEREXIT — The principal user-exit callback. Accepts the verify flag, organization, order-by, group, session, levels-to-explode, BOM-or-engineering indicator, and implosion flag, and drives the multi-level explosion of the bill into the report's result set. This is the procedure invoked when the report definition references the exploder user exit.
• EXPLOSION_REPORT — Report-level driver procedure that assembles the explosion output.
• EXPLODERS — Core exploder engine performing the recursive traversal of bill structures.
• LOOPSTR2MSG — Utility that converts a loop/formatted string into the message buffer used for the report's status or error output (P_MSG_BUF, P_ERR_MSG).

Tables Accessed

• BOM_LISTS_S — Supplies bill header information for the assemblies being exploded.
• MTL_ITEM_REVISIONS — Provides component revision data returned by GET_REV.
• MTL_CATEGORY_SETS — Resolves the category set selected in the report parameters when category ranges are used.
• MTL_DESCRIPTIVE_ELEMENTS — Backs GET_ELE_DESC for item descriptive element values.
• FND_ID_FLEX_STRUCTURES — Identifies the item flexfield structure required to render flexfield segments.
• DUAL and DBMS_SQL — Support parameter derivation and dynamic SQL construction within the report logic.

Usage Notes

The package is invoked only through the Bill of Material Composition concurrent program; it is not a public API and is not referenced by other packages (referenced-by count: zero). Customizations should be limited to the report's XML template or a copied concurrent program rather than modifying the seeded package, since it is flagged "noship" in its header and carries no extension points. When troubleshooting the "exploder_userexit" reference, confirm that the concurrent program definition for the BOM composition report still names EXPLODER_USEREXIT as its user exit and that the logged-in user holds the required BOM inquiry or maintenance responsibility, as the exit executes with the caller's privileges against the organization selected in the report parameters.