Search Results update_charge_lines

Overview

CS_CHG_AUTO_SUB_CON_PKG is a PL/SQL package body owned by APPS in Oracle E-Business Suite (documented against ETRM 12.2.2, applicable to 12.1.1 and 12.2.2). It supports the Oracle TeleService / Service (CS) charging subsystem — historically the "Value Added Services" (VAS) module — by automatically submitting charge lines associated with service requests and debrief records. The package is registered as the implementation body for a concurrent program, with MAIN_PROCEDURE serving as the concurrent program entry point and accepting the standard ERRBUF and RETCODE output parameters used by the concurrent manager. The header indicates a maintained source file (csxvasub.pls, version 120.9.12010000.2), reflecting the R12 lineage of the code.

From a business perspective, the package automates the conversion of unbilled or pending charge lines into submitted charge transactions, ensuring that billable service activity captured during incident and debrief processing is passed forward to the charging engine without manual intervention. This reduces revenue leakage on billable service requests and keeps charge submission aligned with the debrief lifecycle.

Key Procedures and Functions

• MAIN_PROCEDURE — The private driver procedure invoked by the concurrent program. It writes diagnostic output to the concurrent log, initializes multi-org context via MO_GLOBAL.INIT for the CS_CHARGES entity (an R12-specific requirement so that temporary tables are populated correctly), and orchestrates the auto-submission of charge lines. It reports status back through ERRBUF and RETCODE (0 = success, 1 = warning, 2 = error).
• AUTO_SUBMIT_CHG_LINES — The principal API invoked by MAIN_PROCEDURE with the standard OEO/PL/SQL API signature pattern (p_api_version, p_init_msg_list, p_commit, x_return_status, x_msg_count, x_msg_data). It selects eligible charge lines and drives their submission.
• UPDATE_CHARGE_LINES — Updates charge line records to reflect submission status and related charging attributes after processing.
• SUBMIT_CHARGE_LINES — Performs the actual submission of charge lines to the charging subsystem.
• CHECK_DEBRIEF_STATUS — Evaluates whether the associated debrief record has reached a state that permits charge submission, acting as a gating check before lines are processed.

Tables Accessed

The package reads and writes charge-related and service-request data through APPS synonyms:

• CS_ESTIMATE_DETAILS — charge/estimate line source data.
• CSF_DEBRIEF_HEADERS — debrief records whose status gates submission via CHECK_DEBRIEF_STATUS.
• CS_CHG_SUB_RESTRICTIONS — restrictions controlling which charge lines may be auto-submitted.
• CS_INCIDENTS_ALL_B and CS_INCIDENT_TYPES — incident (service request) header and type context.
• CS_TRANSACTION_TYPES — transaction classification driving charge behavior.
• HZ_PARTIES — party/account information associated with billable activity.
• JTF_TASK_ASSIGNMENTS and JTF_TASK_STATUSES_B — task assignment and status data used in eligibility determinations.
• PLITBLM — the standard PL/SQL table-to-SQL helper used to store and reference in-memory collections in SQL statements.

Usage Notes

CS_CHG_AUTO_SUB_CON_PKG is intended to be driven through the concurrent manager rather than from a form; MAIN_PROCEDURE is the documented concurrent program entry point and produces log output via FND_FILE.PUT_LINE. It is referenced by zero other packaged APIs, so integration is expected to occur by scheduling the concurrent program or by direct invocation from custom code following the same ERRBUF/RETCODE convention.

Because the code calls MO_GLOBAL.INIT('CS_CHARGES'), invocations must respect multi-org initialization — this is particularly important on 12.1.1 and 12.2.2, where omitting it prevents temporary tables from being populated and results in no charge lines being processed. Note that total_charges is not a documented procedure, function, parameter, or column in this package's ETRM metadata; if it appears in session or log output, it reflects runtime data or a label rather than a named package element.