Search Results cs_charge_core_pvt




Overview
Explore in AI Chat

Overview

CS_CHARGE_CORE_PVT is a private (PVT class) PL/SQL package body in the APPS schema of Oracle E-Business Suite, documented as VALID in ETRM for release 12.2.2 and applicable to 12.1.1. It functions as the internal charge-processing engine for the Service (CS) module, providing the low-level routines that compute, resolve, and persist charge and billing information associated with service incidents, repair orders, and debrief transactions. The package bridges the transactional service tables (incidents, repairs, estimates, and debrief headers) with the receivables and order management tables used to generate customer invoices and order lines. As a PVT package, it is intended to be called only by other packages within the Service charge framework rather than directly by end users, forms, or external integrations. Because it exposes a small, stable set of utility functions and is not referenced by any other database object, it behaves as a leaf-level worker package whose public-facing counterparts orchestrate the overall charge calculation and invoicing flow.

Key Procedures and Functions

The documented package exposes seven procedures and functions:

  • GET_SOURCE_ID — Resolves the source identifier for a charge or transaction line, providing the originating record key used to link service activity to downstream billing entities.
  • GET_INVOICE_DETAILS — Retrieves invoice-related details, including header and line information from the receivables tables, for a given charge context.
  • DEFAULT_ATTRIBUTES — Applies default values to charge and transaction attributes, ensuring that required fields are populated with standard or derived values before processing continues.
  • GET_SHIP_TO_SITE_ID — Determines the ship-to site identifier by resolving the appropriate customer account site from the trading community model.
  • GET_INVOICE_TO_PARTY_SITE_ID — Determines the invoice-to party site identifier, identifying the billing location associated with the customer.
  • NUMBER_FORMAT — Formats numeric values according to the applicable currency or display rules, supporting consistent presentation of monetary amounts.
  • GET_VALUE_NAME — Returns the descriptive name associated with a lookup or reference value, used to translate codes into user-readable text.

Tables Accessed

The package references the following tables through APPS synonyms:

Usage Notes

CS_CHARGE_CORE_PVT is typically invoked indirectly. Service forms and concurrent programs that manage incident charges, repair estimates, and debrief-based billing call the package's public siblings, which in turn call these routines. The package is not referenced by any other database object per ETRM, confirming its role as an internal implementation layer. Customizations should avoid direct calls; instead, developers should call the documented public API that wraps this logic to preserve upgrade safety across 12.1.1 and 12.2.2. Where direct use is unavoidable, callers must supply a valid incident, repair, or debrief context and ensure the referenced customer and site records exist, since the site-resolution and invoice-detail routines depend on consistent trading community and receivables data.