Search Results get_defaultpricelist

Overview

CSD_CHARGE_LINE_UTIL is a utility package body owned by APPS within the Oracle E-Business Suite, classified as a UTIL API. Its stated purpose, per the source header, is to provide utilities for handling price lists and contracts for charge lines — the billing-related lines generated against a depot repair order. The package bridges the Service (CSD/CSI) data model and the Advanced Pricing engine (QP), resolving which price list, currency, and contract should govern the pricing of a repair charge line, and performing the calculations and conversions required to turn repair activity into chargeable lines.

The user search term "get_contractpricelist" corresponds to one of the eleven documented functions in this package. The final source revision shipped is csdvclub.pls version 120.5, dated 11 March 2008, with an internal version history tracing back to creation in October 2002.

Key Procedures and Functions

• GET_PLCURRCODE — Returns the currency code associated with a given price list by reading the price list header; raises a CSD application message when the price list cannot be resolved.
• GET_DEFAULTPRICELIST — Determines the price list to be used by default, deriving it from the contract (falling back to the default contract when none is supplied) and, failing that, from a profile option.
• GET_CONTRACTPRICELIST — Resolves the price list attached to a contract, providing the contract-driven pricing source for a charge line.
• GET_RO_PRICELIST — Returns the price list associated with a repair order context.
• GET_DEFAULTCONTRACT — Identifies the default contract to be applied when no explicit contract is provided.
• GET_SR_ACCOUNTID — Returns the service request account identifier used in pricing and billing resolution.
• VALIDATE_CONTRACT — Verifies that a supplied contract is valid for use in the charge line pricing flow.
• VALIDATE_PRICELIST — Verifies that a supplied price list is valid before it is applied.
• GET_DISCOUNTEDPRICE — Computes the discounted price for a charge line, applying the pricing/discount result to the line.
• GET_COVERAGEINFO — Retrieves coverage information, determining the extent to which a repair is covered by a contract or warranty and therefore how it should be charged.
• CONVERT_TO_CHARGE_LINES — Converts repair data into charge lines, the central transformation performed by this package.

Tables Accessed

The package reads reference and transactional data through APPS synonyms. QP_LIST_HEADERS_B supplies price list header and currency information. CSD_REPAIRS and CSD_REPAIR_TYPES_B provide the repair order and repair type context. CSI_TXN_TYPES and CS_TXN_BILLING_TYPES supply transaction and billing type definitions used when creating charge lines. CS_INCIDENTS_ALL_B provides service request/incident data supporting account and coverage resolution. PLITBLM is referenced in the pricing lookup path. The package is primarily a read-and-derive utility, with charge line creation driven through the conversion routine.

Usage Notes

CSD_CHARGE_LINE_UTIL is referenced by seven other packages, indicating it is a shared internal utility rather than a user-facing API. It is typically invoked from depot repair charge line processing — including concurrent programs and forms that generate billing for repair orders — and from other CSD packages requiring consistent price list, contract, and coverage resolution. Because procedures such as GET_CONTRACTPRICELIST and GET_DEFAULTPRICELIST rely on profile options and contract data, correct setup of pricing and service contracts is a prerequisite. Custom code should call these functions only where the standard charge line generation flow cannot be reused, and should expect NULL returns plus stacked FND messages on resolution failure rather than unhandled exceptions.