Search Results csd_estimates_from_bom_pvt




Overview
Explore in AI Chat

Overview

CSD_ESTIMATES_FROM_BOM_PVT is an Oracle E-Business Suite private PL/SQL package owned by the APPS schema. Its designation as a PVT (private) API indicates that it is intended for internal use by Oracle's Enterprise Technical Reference Model (ETRM) service modules rather than as a public integration interface. The package supports the Service Request / Depot Repair estimation workflow, where service organizations must derive cost and price information for repair line items that are driven by bills of material (BOM) structures. Specifically, the package explodes a parent item's bill of material, evaluates the associated contract and pricing context, and generates estimate lines that feed downstream service costing and quoting activities. In EBS 12.1.1 and 12.2.2, the package is a dependency-bearing component that references shared utility structures such as the APPS VARCHAR2_TABLE_200 collection type and the SYS STANDARD package, and it is not referenced by any other packaged API, confirming its role as a leaf-level implementation module invoked by forms or concurrent logic rather than as a reusable public entry point.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions within the package. Each name reflects its role in the estimate generation cycle:

  • EXPLODE_BOM_ITEMS — Performs the bill of material explosion, expanding a parent/serviceable item into its component structure so that each component can be evaluated for estimation.
  • CREATE_ESTIMATE_LINES — Persists the derived estimate rows, converting the exploded and priced component data into estimate lines.
  • GET_DEFAULT_CONTRACT — Resolves the applicable service contract header for the estimation context, enabling correct pricing and discounting.
  • GET_ITEM_COST — Retrieves the cost basis for a given component item, typically from inventory costing information.
  • GET_SELLING_PRICE — Determines the selling price applicable to an item under the resolved contract or price context.
  • GET_DISCOUNT_PRICE — Applies contract-level discount logic to arrive at the final discounted price for the estimate line.

Parameter lists are not exposed in the documented metadata and are therefore not reproduced here.

Tables Accessed

The package operates against a combination of BOM, inventory, contract, and project tables through APPS synonyms:

Usage Notes

Because CSD_ESTIMATES_FROM_BOM_PVT is a private API and is not referenced by any other documented package, it is not intended for direct customer invocation. It is typically called from the Service Request and Depot Repair forms or from concurrent programs that build repair estimates from bills of material. Developers extending estimation behavior should treat this package as an internal dependency and instead use supported public APIs, while DBAs performing impact analysis should note its dependencies on OKC contract tables and BOM explosion objects when applying patches. Its validity status is VALID in the documented release.