Search Results ml_imploder

Overview

APPS.BOM_BOMRWUIT_XMLP_PKG is the Oracle E-Business Suite PL/SQL package that supports the "Bill of Material Report" (structured where-used / implosion report) submitted from Oracle Bills of Material. It is an XML Publisher (XMLP) concurrent program support package, evidenced by the naming convention and the BEFOREREPORT/AFTERREPORT entry points that the XMLP engine calls during report execution. Its principal business function is to drive a multilevel implosion of a bill of materials — starting from one or more assemblies and descending through component levels — and to persist the resulting hierarchical rows so that the report layout can render them. The "ml_imploder" entry the user searched for corresponds to the ML_IMPLODER procedure, which performs implosion processing for a specific level or organization context.

The package holds the bind and report parameters (organization, item range, category range, implemented/engineering flags, implosion date, level, precision, debug and message buffers) as package globals, and exposes helper functions used by the XMLP data template or report triggers.

Key Procedures and Functions

• BEFOREREPORT — Report-level initialization executed before the query; validates parameters, resolves organization and precision settings, and seeds package globals.
• AFTERREPORT — Post-processing invoked after the report completes, used to finalize report output or clean up.
• GET_STATUS — Derives a display status string from the revised item sequence, implemented flag, and change notice supplied by the caller.
• GET_ORGCODE — Returns the organization code for a given organization identifier.
• CF_ALL_ORGSFORMULA — Formula helper returning an indicator for the "all organizations" report option.
• GET_PRECISION — Returns the formatted quantity precision derived from the precision input.
• IMPLODER_USEREXIT — User exit wrapper that drives implosion processing; it accepts the sequence, engineering/manufacturing flag, organization, implemented flag, display option, levels to implode, item, and date, returning error message and error code.
• IMPLOSION — Core implosion routine that performs the multilevel bill explode and populates the temporary implosion structures.
• SL_IMPLODER — Single-level imploder processing for one level of the structure.
• ML_IMPLODER — Multilevel imploder that iterates the implosion to the requested depth.

Tables Accessed

• BOM_IMPLOSION_TEMP / BOM_IMPLOSION_TEMP_S — Temporary tables written during implosion and read to build the report's hierarchical output; S is the corresponding sequence.
• ENG_REVISED_ITEMS — Read for engineering change status and revised item information used by GET_STATUS.
• FND_ID_FLEX_STRUCTURES — Read to resolve the category structure key flexfield used for category range filters.
• MTL_PARAMETERS — Read to validate organization parameters, including quantity precision and organization defaults.
• DBMS_SQL — Used for dynamic SQL constructed from runtime filter selections.
• DUAL — Standard single-row source for scalar derivations.
• PLITBLM — PL/SQL table utility referenced during processing.

Usage Notes

The package is not referenced by any other package (0 referencing objects) and is intended to be invoked by the Oracle Bills of Material "Bill of Material Report" concurrent program and its XML Publisher data template. It is not a general-purpose API; the implosion procedures are report-internal and should not be called directly from custom code without risk, since they depend on package globals being initialized by BEFOREREPORT. Custom reports requiring a where-used implosion should use supported public APIs rather than this XMLP support package. No external extension points are documented.