Search Results cs_calculate_credit




Overview
Explore in AI Chat

Overview

CS_CALCULATE_CREDIT is a PL/SQL package in the Oracle E-Business Suite Customer Service (CS) module, owned by the APPS schema and defined with AUTHID CURRENT_USER. Its header identifies it as part of the service transaction infrastructure, with a source control stamp (csxstsvs.pls) reflecting its Service (CSX) lineage and origin in the R11-era codebase that carried forward into EBS 12.1.1 and 12.2.2. The package supports the Credit and Returns/Service Request lifecycle by exposing two application programming interfaces: one that computes credit amounts associated with the termination or winding-down of a service, and one that creates a service interaction from a form invocation.

In deployments where users search for "Crédito de consumo fácil" (a colloquial Spanish phrase for a simple consumer credit or easy consumer credit flow), this package is the technical anchor for the credit-derivation logic executed against a customer service contract or service record. Rather than a financials-ledger credit package, it operates on the Customer Service service-transaction model, calculating how much credit a customer is owed when service coverage is terminated before its natural end.

Key Procedures and Functions

The package exposes exactly two documented procedures:

  • CS_CALCULATE_CREDIT — The core credit-computation routine. It receives a service identifier and a termination effective date, and returns the first applicable service transaction, the first credit amount, the total credit amount, the total credit percentage, and a flag indicating whether multiple transactions are involved. This procedure encapsulates the proration and credit-derivation rules applied at the point of service termination.
  • CREATE_INTERACTION_FROM_FORM — A form-facing wrapper that creates a service interaction record from data captured in an Oracle Forms session, accepting user, service, parent interaction, bill-to contact, and audit columns, and returning a status code and message to the caller.

No parameter lists beyond those published in the package specification should be assumed; the signatures are stable and must be invoked as declared.

Tables Accessed

Per the ETRM metadata, the package references two tables through APPS synonyms:

  • CS_CP_SERVICE_TRANSACTIONS — The principal data source and target. Credit calculations read the constituent service transactions tied to a service ID, and the first/multi-transaction outputs derive from this table's rows. Writes and reads during interaction creation also flow here.
  • FND_USER — Used to resolve and validate the application user context, predominantly for audit columns and the control user identifier in the form-driven interaction procedure.

No other packages are documented as referencing CS_CALCULATE_CREDIT, indicating it is a leaf-level utility invoked directly rather than a shared library dependency.

Usage Notes

CS_CALCULATE_CREDIT is typically invoked from the Customer Service forms layer and from custom extensions that need to reproduce the standard credit calculation, for example when a service contract is terminated and the customer is owed a prorated refund or account credit. The procedure's OUT parameters are designed for a forms block or a calling program that subsequently displays or posts the resulting credit amount.

CREATE_INTERACTION_FROM_FORM is form-specific by design; it should be called from Oracle Forms triggers rather than from concurrent programs, because it depends on form-supplied identifiers. Because the package runs with AUTHID CURRENT_USER, privileges of the invoking user apply, and callers must have appropriate execute grants. For 12.2.2 deployments using Online Patching, the package follows the standard editioning model for APPS-owned code, and no special editioning view is required for these table accesses.