Search Results get_value_name

Overview

CS_CHARGE_CORE_PVT is an Oracle EBS service (field service / depot repair) private API that belongs to the CS (Customer Support) application family, owned by the APPS schema. As indicated by the _PVT suffix, it is an internal implementation package rather than a public, supported API: it is invoked by other service modules, forms, or concurrent programs rather than being called directly by customer extensions. In the Oracle E-Business Suite 12.1.1 and 12.2.2 releases, this package supplies the shared "core" charge logic used when service charges, debrief lines, and repair order details must be enriched with quoting, ordering, and invoicing context.

The package operates under AUTHID CURRENT_USER, meaning its unqualified references resolve against the calling user's schema and the APPS synonyms available at runtime. Its principal responsibility is to resolve key identifiers and descriptive values required for charge creation and validation — for example, translating a source code and source number pair into a source ID, deriving the correct ship-to and invoice-to party site IDs from a quotation, and formatting monetary amounts for display or storage.

Key Procedures and Functions

• GET_SOURCE_ID — Resolves a source identifier from a source code, source number, and organization ID combination; returns the source ID along with a return status.
• GET_INVOICE_DETAILS — Retrieves invoice number and invoice date for a given order header and order line, providing the receivables context associated with a service transaction.
• DEFAULT_ATTRIBUTES — Populates defaulting values and returns the organization along with a status indicator used to signal success or failure.
• GET_SHIP_TO_SITE_ID — Returns the ship-to site identifier derived from a quotation header and quotation line.
• GET_INVOICE_TO_PARTY_SITE_ID — The function of interest to the searching user. It returns the invoice-to party site identifier for a given quotation header and quotation line. This is used when charge lines must reference the correct billing party site so that downstream receivables transactions are created against the right customer site.
• NUMBER_FORMAT — Converts a numeric amount into a formatted VARCHAR2 string, typically for consistent display of charge values.
• GET_VALUE_NAME — Returns the descriptive value name for a restriction type and value object ID pairing, supporting lookup and validation logic.

Tables Accessed

The package reads from and writes to a range of service, order, and receivables tables through APPS synonyms. Customer and party data is sourced from HZ_PARTIES, HZ_CUST_ACCT_SITES, and HZ_CUST_SITE_USES, which support the ship-to and invoice-to site resolution functions. Repair and debrief context comes from CSD_REPAIRS and CSF_DEBRIEF_HEADERS, while estimating data is drawn from CS_ESTIMATE_DETAILS and incident records from CS_INCIDENTS_ALL_B. Order and billing information is retrieved from OE_ORDER_HEADERS_ALL, RA_CUSTOMER_TRX_ALL, and RA_CUSTOMER_TRX_LINES_ALL, enabling the package to link service charges to their originating order and resulting invoice.

Usage Notes

CS_CHARGE_CORE_PVT is a private package and is not referenced by any other documented package in the ETRM metadata set. It is typically invoked internally by Oracle service and depot repair forms and business logic during charge calculation, debrief processing, and repair order creation, where the invoice-to and ship-to site IDs must be derived from quotation lines. Because it is not a public API, customizations should avoid direct calls; instead, integrators should rely on supported public APIs and preserve the documented behavior. Parameters are passed as IN values with OUT NOCOPY return variables for status and IDs, and functions such as GET_INVOICE_TO_PARTY_SITE_ID return NUMBER directly. Its availability is consistent across 12.1.1 and 12.2.2.