Search Results csd_repair_actual_process_pvt




Overview
Explore in AI Chat

Overview

CSD_CHARGE_LINE_UTIL is an APPS-owned PL/SQL utility package within the Oracle E-Business Suite Depot Repair (CSD) module, present in both release 12.1.1 and 12.2.2. Classified as a UTIL API in the ETRM repository, it provides the shared pricing, contract, and billing-reference logic that the Depot Repair costing and estimation flows depend on. Its principal responsibility is to translate repair-related business context — the repair order, its repair type, the transaction type, and the associated incident — into the pricing constructs required to value a repair: the operating unit's functional currency code, the applicable price list, the contract and contract price list, service account identifiers, discount amounts, and coverage information. Once this context has been resolved, the package converts the derived pricing and coverage data into charge lines, which are the records that subsequently flow into Oracle Order Management, Service Contracts, and Receivables. In this sense the package acts as the pricing and billing bridge between Depot Repair execution and the financial applications that invoice the customer.

Key Procedures and Functions

The package exposes eleven documented program units, split between currency, price list, contract, and validation helpers, plus a single charge line conversion routine:

  • GET_PLCURRCODE — returns the functional currency code associated with the applicable price list, so that monetary values are expressed in the correct ledger currency.
  • GET_DEFAULTPRICELIST — resolves the default price list applicable to the repair context when no explicit price list has been supplied.
  • GET_RO_PRICELIST — retrieves the price list specifically associated with the repair order.
  • GET_SR_ACCOUNTID — returns the service (SR) account identifier used to bind the repair transaction to the correct customer account.
  • GET_DEFAULTCONTRACT — determines the default service contract applicable to the repair, used when no contract is explicitly specified.
  • GET_CONTRACTPRICELIST — returns the price list attached to the resolved contract.
  • VALIDATE_CONTRACT — validates that the identified contract is eligible for the repair transaction being processed.
  • VALIDATE_PRICELIST — validates the selected price list for correctness and applicability.
  • GET_DISCOUNTEDPRICE — calculates the discounted price for the repair line, applying the pricing and contract context already resolved.
  • GET_COVERAGEINFO — returns coverage information (entitlement) determining which portions of the repair are covered by contract or warranty.
  • CONVERT_TO_CHARGE_LINES — the central routine, transforming the assembled pricing, currency, contract, and coverage data into charge line records suitable for downstream billing and order processing.

Tables Accessed

The package operates against Depot Repair, Service, and Advanced Pricing tables through APPS synonyms. CSD_REPAIRS and CSD_REPAIR_TYPES_B supply the repair order and repair type context that drives currency and price list selection. CSI_TXN_TYPES and CS_TXN_BILLING_TYPES provide the transaction and billing type classifications that determine how a repair is charged. CS_INCIDENTS_ALL_B supplies incident information used for coverage and service account resolution. QP_LIST_HEADERS_B holds Advanced Pricing price list headers queried for default and contract price lists. PLITBLM is the pricing list table used in price list resolution and discounting logic. Together these tables give the package both the repair-side context and the pricing-side configuration needed to produce valid charge lines.

Usage Notes

CSD_CHARGE_LINE_UTIL is a shared dependency rather than an end-user entry point. It is referenced by seven other packages, including CSD_REPAIR_ACTUAL_PROCESS_PVT (the object associated with the user's search term, appearing twice in the dependency list, indicating both specification and body references), CSD_REPAIR_ESTIMATE_PVT, CSD_ESTIMATES_FROM_BOM_PVT, CSD_ESTIMATE_UTILS_PVT, CSD_PROCESS_UTIL, CSD_RETURNS_UTIL, and CSD_WF_PROCESS_PVT. It also references CS_CHARGE_DETAILS_PUB, indicating that charge detail publication logic is invoked alongside it. In practice, the package is called during Depot Repair creation, estimate generation, actual repair processing, and repair return handling, whenever repairs must be priced and converted into billable charge lines. Because it is invoked from the actual repair and estimate processing packages, it is exercised by Depot Repair forms and by any concurrent program or custom extension that drives repair costing, estimation, or warranty/contract coverage determination. Customizations should treat it as a supporting utility and invoke it indirectly through the documented process packages rather than calling its procedures directly, since its contract and price list resolution logic assumes the full repair context has already been established by the calling flow.